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

Home / Companies / TSG Consulting, LLC

TSG Consulting, 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
TSG Consulting, LLC
TSG CONSULTING LLC
663128FY2016 to FY2025
Latest decision 2025-06-25
23NETWORK CONSULTING ENGINEER
6 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings66
Certified LCAs65
Denied LCAs0
Role titles31
Worksites28
Latest decision2025-06-25
USCIS approvals23
USCIS denials3

Aliases and source names

AliasesSource NamesSources
TSG CONSULTING LLCTSG Consulting, LLC, TSG CONSULTING LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
NETWORK CONSULTING ENGINEER15-1142
NETWORK AND COMPUTER SYSTEMS ADMINISTRATORS
6$104,000$170,560
Sr. Software Engineer15-1252.00
Software Developers
5$149,360$149,360
Back-End Integration Analyst15-1211.00
Computer Systems Analysts
3$104,000$104,000
Payment Certification Tester15-1199.01
Software Quality Assurance Engineers and Testers
3$106,080$106,080
Scrum Master/Project Manager15-1199.09
Information Technology Project Managers
3$83,200$83,200
SENIOR NETWORK ENGINEER15-1142
NETWORK AND COMPUTER SYSTEMS ADMINISTRATORS
3$114,400$114,400
BUSINESS ANALYST15-11212$166,400$0
Cognos Developer15-1252.00
Software Developers
2$96,000$96,000
DATA ENGINEER17-2112.00
Industrial Engineers
2$143,520$143,520
Engineering SME13-1082.00
Project Management Specialists
2$214,240$214,240

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
CharlotteNC2820261104,000114,4002,0192,022
CaryNC2751951149,360149,3602,0232,025
SunnyvaleCA9408542110,240110,2402,0172,023
Mount ProspectIL6005641114,400135,2002,0182,020
MorrisvilleNC275604183,20083,2002,0212,023
CupertinoCA950143395,880145,6002,0202,024
Santa ClaraCA950503271,00002,0162,018
AtlantaGA3030831106,080106,0802,0222,023
LexingtonKY405143185,280120,6402,0192,023
RichardsonTX7508231170,560170,5602,0172,019

Full company payload

Company IDcompany:tsg consulting
NameTSG Consulting, LLC
Normalized Nametsg consulting
Source Company Idscompany_dol_oflc_lca_tsg_consulting_llc, company_uscis_h1b_datahub_tsg_consulting_llc_tax_8988
Source NamesTSG Consulting, LLC, TSG CONSULTING LLC
AliasesTSG CONSULTING LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "TSG Consulting, LLC",
    "TSG CONSULTING LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "TSG Consulting, LLC",
      "filing_count": 32,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "TSG CONSULTING, LLC",
      "filing_count": 30,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    },
    {
      "value": "TSG Consulting LLC",
      "filing_count": 2,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "TSG CONSULTING LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "8988",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 66,
  "case_count": 66,
  "role_title_count": 31,
  "worksite_count": 28,
  "total_workers": 66,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-07-07",
  "latest_fiscal_year": 2025,
  "latest_decision_date": "2025-06-25",
  "certified_count": 65,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 33,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 19,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified - Withdrawn",
      "filing_count": 9,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED-WITHDRAWN",
      "filing_count": 4,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Withdrawn",
      "filing_count": 1,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 66,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 65,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 23,
  "total_denial": 3,
  "fiscal_years": [
    "2018",
    "2019",
    "2020",
    "2021",
    "2022",
    "2023"
  ],
  "year_metrics": [
    {
      "cities": [
        "Raleigh"
      ],
      "states": [
        "NC"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "27606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 5,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_tsg_consulting_llc_tax_8988_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_018361"
      ],
      "continuing_approval": 5
    },
    {
      "cities": [
        "Raleigh"
      ],
      "states": [
        "NC"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "27606"
      ],
      "total_denial": 3,
      "initial_denial": 1,
      "total_approval": 6,
      "initial_approval": 4,
      "continuing_denial": 2,
      "petition_count_id": "petition_count_uscis_h1b_archive_tsg_consulting_llc_tax_8988_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_018222"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Raleigh"
      ],
      "states": [
        "NC"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "27606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_tsg_consulting_llc_tax_8988_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_050205"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "Raleigh"
      ],
      "states": [
        "NC"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "27606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_tsg_consulting_llc_tax_8988_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_055042"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Raleigh"
      ],
      "states": [
        "NC"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "27606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 5,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_tsg_consulting_llc_tax_8988_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_054444"
      ],
      "continuing_approval": 4
    },
    {
      "cities": [
        "Raleigh"
      ],
      "states": [
        "NC"
      ],
      "fiscal_year": 2023,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "27617"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_tsg_consulting_llc_tax_8988_2023",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2023_row_030116"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "RALEIGH NC 27606",
      "city": "Raleigh",
      "state": "NC",
      "postal_code": "27606",
      "filing_count": 54,
      "case_count": 54,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-06-25",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "RALEIGH NC 27617",
      "city": "Raleigh",
      "state": "NC",
      "postal_code": "27617",
      "filing_count": 12,
      "case_count": 12,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2024-10-16",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "CARY NC 27519",
      "city": "Cary",
      "county": "Wake",
      "state": "NC",
      "postal_code": "27519",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2024-10-16",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "LOS ANGELES CA 90013",
      "city": "Los Angeles",
      "county": "Los Angeles",
      "state": "CA",
      "postal_code": "90013",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-06-25",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "GRRENWOOD VILLAGE CO 80111",
      "city": "Grrenwood Village",
      "county": "Arapahoe",
      "state": "CO",
      "postal_code": "80111",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2024-10-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CUPERTINO CA 95104",
      "city": "Cupertino",
      "county": "Santa Clara",
      "state": "CA",
      "postal_code": "95104",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-05-19",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "AUSTIN TX 78727",
      "city": "Austin",
      "county": "Travis",
      "state": "TX",
      "postal_code": "78727",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-01-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BASKING RIDGE NJ 07920",
      "city": "Basking Ridge",
      "county": "Somerset",
      "state": "NJ",
      "postal_code": "07920",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2024-11-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BELLEVUE WA 98005",
      "city": "Bellevue",
      "county": "King",
      "state": "WA",
      "postal_code": "98005",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-06-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CUPERTINO CA 95014",
      "city": "Cupertino",
      "county": "Santa Clara",
      "state": "CA",
      "postal_code": "95014",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2023-12-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "GREENWOOD VILLAGE CO 80111",
      "city": "Greenwood Village",
      "county": "Arapahoe",
      "state": "CO",
      "postal_code": "80111",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-05-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "WINSTON SALEM NC 27104",
      "city": "Winston Salem",
      "county": "Forsyth",
      "state": "NC",
      "postal_code": "27104",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-03-08",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "MORRISVILLE NC 27560",
      "city": "Morrisville",
      "county": "Wake",
      "state": "NC",
      "postal_code": "27560",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-07-11",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "LEXINGTON KY 40514",
      "city": "Lexington",
      "county": "Fayette",
      "state": "KY",
      "postal_code": "40514",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-07-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SUNNYVALE CA 94085",
      "city": "Sunnyvale",
      "county": "Santa Clara",
      "state": "CA",
      "postal_code": "94085",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-02-08",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ATLANTA GA 30308",
      "city": "Atlanta",
      "county": "Fulton",
      "state": "GA",
      "postal_code": "30308",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-02-08",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CHARLOTTE NC 28212",
      "city": "Charlotte",
      "county": "Mecklenburg",
      "state": "NC",
      "postal_code": "28212",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-06-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ASHBURN VA 20147",
      "city": "Ashburn",
      "county": "Loudoun",
      "state": "VA",
      "postal_code": "20147",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-05-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CHARLOTTE NC 28202",
      "city": "Charlotte",
      "county": "Mecklenburg",
      "state": "NC",
      "postal_code": "28202",
      "filing_count": 6,
      "case_count": 6,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-07-12",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NEW YORK CITY NY 10041",
      "city": "New York City",
      "county": "New York",
      "state": "NY",
      "postal_code": "10041",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-04-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "MOUNT PROSPECT IL 60056",
      "city": "Mount Prospect",
      "county": "Cook",
      "state": "IL",
      "postal_code": "60056",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-02-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "RICHARDSON TX 75082",
      "city": "Richardson",
      "county": "Collin County",
      "state": "TX",
      "postal_code": "75082",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-09-12",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "MOUNT PROSPECT IL 60056",
      "city": "Mount Prospect",
      "county": "Cook County",
      "state": "IL",
      "postal_code": "60056",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-07-19",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BELLEVUE WA 98004",
      "city": "Bellevue",
      "county": "King County",
      "state": "WA",
      "postal_code": "98004",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-06-19",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "MESA AZ 85212",
      "city": "Mesa",
      "county": "Maricopa",
      "state": "AZ",
      "postal_code": "85212",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-04-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "HUNTSVILLE AL 35801",
      "city": "Huntsville",
      "county": "Madison",
      "state": "AL",
      "postal_code": "35801",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-03-25",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CHARLOTTE NC 28206",
      "city": "Charlotte",
      "county": "Mecklenburg",
      "state": "NC",
      "postal_code": "28206",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-01-25",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NEWARK CA 95008",
      "city": "Newark",
      "county": "Alameda",
      "state": "CA",
      "postal_code": "95008",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2018-10-29",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BELLEVUE WA 98008",
      "city": "Bellevue",
      "county": "King County",
      "state": "WA",
      "postal_code": "98008",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-06",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SANTA CLARA CA 95050",
      "city": "Santa Clara",
      "county": "Santa Clara County",
      "state": "CA",
      "postal_code": "95050",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2017-11-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SAN FRANCISCO CA 94110",
      "city": "San Francisco",
      "county": "San Francisco County",
      "state": "CA",
      "postal_code": "94110",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-08-25",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SUNNYVALE CA 94085",
      "city": "Sunnyvale",
      "county": "Santa Clara County",
      "state": "CA",
      "postal_code": "94085",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-07-11",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SANTA CLARA CA 95050",
      "city": "Santa Clara",
      "county": "Santa Clara",
      "state": "CA",
      "postal_code": "95050",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-07-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "worksite_address_count": 31,
    "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": [
    "NC",
    "CA",
    "IL",
    "GA",
    "KY",
    "TX",
    "WA",
    "CO",
    "VA",
    "AL",
    "AZ",
    "NJ",
    "NY"
  ],
  "cities": [
    "Charlotte",
    "Cary",
    "Sunnyvale",
    "Mount Prospect",
    "Morrisville",
    "Cupertino",
    "Santa Clara",
    "Atlanta",
    "Lexington",
    "Richardson",
    "Bellevue",
    "Los Angeles",
    "Greenwood Village",
    "Grrenwood Village",
    "Winston Salem",
    "Ashburn",
    "Huntsville",
    "Mesa",
    "Newark",
    "San Francisco",
    "Basking Ridge",
    "New York City",
    "Austin",
    "Raleigh"
  ],
  "postal_codes": [
    "28202",
    "27519",
    "94085",
    "60056",
    "27560",
    "95014",
    "95050",
    "30308",
    "40514",
    "75082",
    "98005",
    "90013",
    "80111",
    "28212",
    "27104",
    "20147",
    "98004",
    "98008",
    "35801",
    "85212",
    "95104",
    "95008",
    "94110",
    "28206",
    "07920",
    "10041",
    "78727",
    "27606",
    "27617"
  ],
  "top_markets": [
    {
      "city": "Charlotte",
      "state": "NC",
      "postal_code": "28202",
      "lca_count": 6,
      "role_title_count": 1,
      "wage_low_min": 104000,
      "wage_high_max": 114400,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2022
    },
    {
      "city": "Cary",
      "state": "NC",
      "postal_code": "27519",
      "lca_count": 5,
      "role_title_count": 1,
      "wage_low_min": 149360,
      "wage_high_max": 149360,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2025
    },
    {
      "city": "Sunnyvale",
      "state": "CA",
      "postal_code": "94085",
      "lca_count": 4,
      "role_title_count": 2,
      "wage_low_min": 110240,
      "wage_high_max": 110240,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2023
    },
    {
      "city": "Mount Prospect",
      "state": "IL",
      "postal_code": "60056",
      "lca_count": 4,
      "role_title_count": 1,
      "wage_low_min": 114400,
      "wage_high_max": 135200,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2020
    },
    {
      "city": "Morrisville",
      "state": "NC",
      "postal_code": "27560",
      "lca_count": 4,
      "role_title_count": 1,
      "wage_low_min": 83200,
      "wage_high_max": 83200,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2023
    },
    {
      "city": "Cupertino",
      "state": "CA",
      "postal_code": "95014",
      "lca_count": 3,
      "role_title_count": 3,
      "wage_low_min": 95880,
      "wage_high_max": 145600,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2024
    },
    {
      "city": "Santa Clara",
      "state": "CA",
      "postal_code": "95050",
      "lca_count": 3,
      "role_title_count": 2,
      "wage_low_min": 71000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Atlanta",
      "state": "GA",
      "postal_code": "30308",
      "lca_count": 3,
      "role_title_count": 1,
      "wage_low_min": 106080,
      "wage_high_max": 106080,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2023
    },
    {
      "city": "Lexington",
      "state": "KY",
      "postal_code": "40514",
      "lca_count": 3,
      "role_title_count": 1,
      "wage_low_min": 85280,
      "wage_high_max": 120640,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2023
    },
    {
      "city": "Richardson",
      "state": "TX",
      "postal_code": "75082",
      "lca_count": 3,
      "role_title_count": 1,
      "wage_low_min": 170560,
      "wage_high_max": 170560,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019
    }
  ]
}
Industry
{
  "naics_codes": [
    "541611",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541611",
      "filing_count": 65,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 46238,
  "annualized_high_max": 218400,
  "annualized_low_avg": 124647.363636364
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 71000,
    "wage_high_max": 0,
    "wage_low_avg": 71000
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 3,
    "worksite_count": 4,
    "wage_low_min": 112320,
    "wage_high_max": 0,
    "wage_low_avg": 143520
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 5,
    "case_count": 5,
    "role_title_count": 4,
    "worksite_count": 4,
    "wage_low_min": 112320,
    "wage_high_max": 0,
    "wage_low_avg": 146016
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 13,
    "case_count": 13,
    "role_title_count": 10,
    "worksite_count": 10,
    "wage_low_min": 46238,
    "wage_high_max": 170560,
    "wage_low_avg": 115076.769230769
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 110240,
    "wage_high_max": 135200,
    "wage_low_avg": 122720
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 99840,
    "wage_high_max": 99840,
    "wage_low_avg": 99840
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q1",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 83200,
    "wage_high_max": 114400,
    "wage_low_avg": 98800
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 83200,
    "wage_high_max": 114400,
    "wage_low_avg": 98800
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 3,
    "worksite_count": 3,
    "wage_low_min": 83200,
    "wage_high_max": 175000,
    "wage_low_avg": 124200
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q1",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 106080,
    "wage_high_max": 143520,
    "wage_low_avg": 118560
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q3",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 85280,
    "wage_high_max": 95880,
    "wage_low_avg": 90580
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 114400,
    "wage_high_max": 114400,
    "wage_low_avg": 114400
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q1",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 149360,
    "wage_high_max": 149360,
    "wage_low_avg": 149360
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q2",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 3,
    "worksite_count": 3,
    "wage_low_min": 106080,
    "wage_high_max": 149360,
    "wage_low_avg": 128760
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q3",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 143520,
    "wage_high_max": 149760,
    "wage_low_avg": 147680
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q4",
    "lca_count": 5,
    "case_count": 5,
    "role_title_count": 4,
    "worksite_count": 4,
    "wage_low_min": 83200,
    "wage_high_max": 135200,
    "wage_low_avg": 106976
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 145600,
    "wage_high_max": 145600,
    "wage_low_avg": 145600
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 96000,
    "wage_high_max": 96000,
    "wage_low_avg": 96000
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q3",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 2,
    "worksite_count": 3,
    "wage_low_min": 104000,
    "wage_high_max": 107360,
    "wage_low_avg": 104840
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q1",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 3,
    "worksite_count": 3,
    "wage_low_min": 104000,
    "wage_high_max": 149360,
    "wage_low_avg": 128826.666666667
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 105248,
    "wage_high_max": 105248,
    "wage_low_avg": 105248
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q3",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 214240,
    "wage_high_max": 218400,
    "wage_low_avg": 215626.666666667
  }
]
Links
{
  "roles": "/v1/roles?company=TSG%20Consulting%2C%20LLC",
  "wages": "/v1/wages?company=TSG%20Consulting%2C%20LLC",
  "trends": "/v1/trends?company=TSG%20Consulting%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=tsg+consulting+llc&limit=5JSON