bluedoor data·H-1B Jobs API·bluedoor.sh ->

Home / Companies / MacGregor Partners, LLC

MacGregor Partners, LLC H-1B company data

Employer profile assembled from DOL OFLC LCA rows and USCIS H-1B Employer Data Hub petition summaries. Rows below include aliases, source IDs, filing coverage, petition counts, role coverage, worksite coverage, and wage summary fields when present.

EmployerLCA filingsRole titlesWorksitesCoverageUSCIS approvalsTop roleSourcesOpen
MacGregor Partners, LLC
MACGREGOR PARTNERS LLC
721FY2016 to FY2022
Latest decision 2022-08-03
4Solution Architect
5 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings7
Certified LCAs7
Denied LCAs0
Role titles2
Worksites1
Latest decision2022-08-03
USCIS approvals4
USCIS denials0

Aliases and source names

AliasesSource NamesSources
MACGREGOR PARTNERS LLCMacGregor Partners, LLC, MACGREGOR PARTNERS LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
Solution Architect15-1132.00
Software Developers, Applications
5$97,677$140,000
SENIOR CLIENT SERVICES MANAGER15-11321$110,698$150,000
Solution Architect15-1252.00
Software Developers
1$119,184$140,000

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
MilwaukeeWI532027297,677150,0002,0162,022

Full company payload

Company IDcompany:macgregor partners
NameMacGregor Partners, LLC
Normalized Namemacgregor partners
Source Company Idscompany_dol_oflc_lca_macgregor_partners_llc, company_uscis_h1b_datahub_macgregor_partners_llc_tax_9148
Source NamesMacGregor Partners, LLC, MACGREGOR PARTNERS LLC
AliasesMACGREGOR PARTNERS LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "MacGregor Partners, LLC",
    "MACGREGOR PARTNERS LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "MacGregor Partners, LLC",
      "filing_count": 5,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "MacGregor Partners LLC",
      "filing_count": 1,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "MACGREGOR PARTNERS LLC",
      "filing_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    },
    {
      "value": "MACGREGOR PARTNERS LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "9148",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 7,
  "case_count": 7,
  "role_title_count": 2,
  "worksite_count": 1,
  "total_workers": 7,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-03-01",
  "latest_fiscal_year": 2022,
  "latest_decision_date": "2022-08-03",
  "certified_count": 7,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 4,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified - Withdrawn",
      "filing_count": 2,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 7,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 6,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 4,
  "total_denial": 0,
  "fiscal_years": [
    "2015",
    "2016",
    "2021",
    "2022"
  ],
  "year_metrics": [
    {
      "cities": [
        "Raleigh"
      ],
      "states": [
        "NC"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "27613"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_macgregor_partners_llc_tax_9148_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_029584"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Milwaukee"
      ],
      "states": [
        "WI"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "53202"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_macgregor_partners_llc_tax_9148_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_031358"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Raleigh"
      ],
      "states": [
        "NC"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "27612"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_macgregor_partners_llc_tax_9148_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_031969"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Raleigh"
      ],
      "states": [
        "NC"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "27612"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_macgregor_partners_llc_tax_9148_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_031958"
      ],
      "continuing_approval": 0
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "RALEIGH NC 27612-4823",
      "city": "Raleigh",
      "state": "NC",
      "postal_code": "27612-4823",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-08-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "RALEIGH NC 27612",
      "city": "Raleigh",
      "state": "NC",
      "postal_code": "27612",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-03-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "MILWAUKEE WI 53202",
      "city": "Milwaukee",
      "state": "WI",
      "postal_code": "53202",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-07",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "MILWAUKEE WI 53202",
      "city": "Milwaukee",
      "county": "Milwaukee",
      "state": "WI",
      "postal_code": "53202",
      "filing_count": 7,
      "case_count": 7,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-08-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 3,
    "worksite_address_count": 1,
    "has_street_address_evidence": true,
    "caveat": "LCA employer/worksite addresses are capped filing evidence scoped to matched source company names and should not be treated as verified headquarters without external validation."
  }
}
Geography
{
  "states": [
    "WI",
    "NC"
  ],
  "cities": [
    "Milwaukee",
    "Raleigh"
  ],
  "postal_codes": [
    "53202",
    "27612",
    "27613"
  ],
  "top_markets": [
    {
      "city": "Milwaukee",
      "state": "WI",
      "postal_code": "53202",
      "lca_count": 7,
      "role_title_count": 2,
      "wage_low_min": 97677,
      "wage_high_max": 150000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2022
    }
  ]
}
Industry
{
  "naics_codes": [
    "541511",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541511",
      "filing_count": 6,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 97677,
  "annualized_high_max": 150000,
  "annualized_low_avg": 102609.571428571
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 110698,
    "wage_high_max": 150000,
    "wage_low_avg": 110698
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 97677,
    "wage_high_max": 140000,
    "wage_low_avg": 97677
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 97677,
    "wage_high_max": 140000,
    "wage_low_avg": 97677
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 119184,
    "wage_high_max": 140000,
    "wage_low_avg": 119184
  }
]
Links
{
  "roles": "/v1/roles?company=MacGregor%20Partners%2C%20LLC",
  "wages": "/v1/wages?company=MacGregor%20Partners%2C%20LLC",
  "trends": "/v1/trends?company=MacGregor%20Partners%2C%20LLC"
}
Get this page with API

Rendered from the bluedoor H-1B Jobs API. Reproduce it:

GET https://api.bluedoor.sh/h1b-jobs/v1/companies?q=macgregor+partners+llc&limit=5JSON