Home / Companies / Spate Business Solutions LLC

Spate Business Solutions 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.

Role rows Wage rows Trends

Employer	LCA filings	Role titles	Worksites	Coverage	USCIS approvals	Top role	Sources	Open
Spate Business Solutions LLC SPATE BUSINESS SOLUTIONS LLC	168	7	25	FY2016 to FY2021 Latest decision 2021-07-06	52	PROGRAMMER ANALYST 129 filings	dol_oflc_lca, uscis_h1b_employer_data_hub	Profile

Activity summary

LCA filings	168
Certified LCAs	168
Denied LCAs	0
Role titles	7
Worksites	25
Latest decision	2021-07-06
USCIS approvals	52
USCIS denials	27

Aliases and source names

Aliases	Source Names	Sources
SPATE BUSINESS SOLUTIONS LLC	Spate Business Solutions LLC, SPATE BUSINESS SOLUTIONS LLC	dol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

Title	SOC	LCA filings	Low wage min	High wage max
PROGRAMMER ANALYST	15-1132 SOFTWARE DEVELOPERS, APPLICATIONS	129	$56,000	$121,077
Systems Analyst	15-1121.00 Computer Systems Analysts	14	$69,534	$104,000
SYSTEMS ANALYST	15-1121 Computer Systems Analysts	10	$55,000	$104,000
Systems Analyst II	15-1121.00 Computer Systems Analysts	9	$86,000	$87,000
COMPUTER SYSTEMS ANALYST	15-1121	2	$75,000	$0
INFORMATION SECURITY ANALYST	15-1122	1	$84,000	$0
PROGRAMMER ANALYST	15-1121 COMPUTER SYSTEMS ANALYSTS	1	$71,240	$83,000
Software Design Engineer	15-1133.00 Software Developers, Systems Software	1	$105,000	$105,000
SOFTWARE DEVELOPER	15-1132 SOFTWARE DEVELOPERS, APPLICATIONS	1	$86,000	$86,000

Top markets

City	State	Postal Code	LCA Count	Role Title Count	Wage Low Min	Wage High Max	First Fiscal Year	Latest Fiscal Year
Noblesville	IN	46060	89	3	58,000	97,157	2,017	2,021
Fishers	IN	46038	41	2	60,000	0	2,016	2,017
Southfield	MI	48076	4	2	55,000	0	2,017	2,017
West Chester	PA	19380	4	1	96,000	104,000	2,020	2,021
Alpharetta	GA	30004	3	1	82,000	82,000	2,020	2,021
Noblesville	IN	46062	3	1	58,000	0	2,017	2,017
Ann Arbor	MI	48104	2	1	60,000	0	2,017	2,018
Auburn Hills	MI	48326	2	2	84,000	104,000	2,018	2,019
Oakton	VA	22185	2	1	71,000	0	2,017	2,017
Issaquah	WA	98029	2	1	113,318	113,318	2,018	2,019

Full company payload

Company ID	company:spate business solutions
Name	Spate Business Solutions LLC
Normalized Name	spate business solutions
Source Company Ids	company_dol_oflc_lca_spate_business_solutions_llc, company_uscis_h1b_datahub_spate_business_solutions_llc_tax_7404
Source Names	Spate Business Solutions LLC, SPATE BUSINESS SOLUTIONS LLC
Aliases	SPATE BUSINESS SOLUTIONS LLC
Sources	dol_oflc_lca, uscis_h1b_employer_data_hub

Names

{
  "source_names": [
    "Spate Business Solutions LLC",
    "SPATE BUSINESS SOLUTIONS LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "SPATE BUSINESS SOLUTIONS LLC",
      "filing_count": 144,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Spate Business Solutions LLC",
      "filing_count": 24,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "SPATE BUSINESS SOLUTIONS LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}

Identifiers

[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "7404",
    "source": "uscis_h1b_employer_data_hub"
  }
]

LCA Activity

{
  "lca_count": 168,
  "case_count": 168,
  "role_title_count": 7,
  "worksite_count": 25,
  "total_workers": 168,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-03-15",
  "latest_fiscal_year": 2021,
  "latest_decision_date": "2021-07-06",
  "certified_count": 168,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 123,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 27,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED-WITHDRAWN",
      "filing_count": 18,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 168,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 143,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ]
}

Petition Activity

{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 52,
  "total_denial": 27,
  "fiscal_years": [
    "2016",
    "2017",
    "2018",
    "2019",
    "2020",
    "2021",
    "2022"
  ],
  "year_metrics": [
    {
      "cities": [
        "Farmington Hills"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "48335"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_spate_business_solutions_llc_tax_7404_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_047353"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Farmington",
        "Farmington Hills"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "48335"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 7,
      "initial_approval": 5,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_spate_business_solutions_llc_tax_7404_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_043394",
        "sr_uscis_h1b_datahub_2017_row_043395"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Farmington",
        "Farmington Hills"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "48335"
      ],
      "total_denial": 6,
      "initial_denial": 5,
      "total_approval": 3,
      "initial_approval": 1,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_spate_business_solutions_llc_tax_7404_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_047416",
        "sr_uscis_h1b_datahub_2018_row_047417"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Farmington",
        "Farmington Hills"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "48335"
      ],
      "total_denial": 8,
      "initial_denial": 5,
      "total_approval": 15,
      "initial_approval": 10,
      "continuing_denial": 3,
      "petition_count_id": "petition_count_uscis_h1b_archive_spate_business_solutions_llc_tax_7404_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_048606",
        "sr_uscis_h1b_datahub_2019_row_048607"
      ],
      "continuing_approval": 5
    },
    {
      "cities": [
        "Farmingtn Hls",
        "Farmington",
        "Farmington Hills"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "48335"
      ],
      "total_denial": 8,
      "initial_denial": 7,
      "total_approval": 17,
      "initial_approval": 12,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_spate_business_solutions_llc_tax_7404_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_044854",
        "sr_uscis_h1b_datahub_2020_row_044855",
        "sr_uscis_h1b_datahub_2020_row_044856"
      ],
      "continuing_approval": 5
    },
    {
      "cities": [
        "Farmingtn Hls",
        "Farmington Hills"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "48335"
      ],
      "total_denial": 4,
      "initial_denial": 4,
      "total_approval": 7,
      "initial_approval": 5,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_spate_business_solutions_llc_tax_7404_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_048941",
        "sr_uscis_h1b_datahub_2021_row_048942"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Farmington"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "48335"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_spate_business_solutions_llc_tax_7404_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_048532"
      ],
      "continuing_approval": 0
    }
  ]
}

Addresses

{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "FARMINGTON HILLS MI 48335",
      "city": "Farmington Hills",
      "state": "MI",
      "postal_code": "48335",
      "filing_count": 161,
      "case_count": 161,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-07-06",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "NOVI MI 48376",
      "city": "Novi",
      "state": "MI",
      "postal_code": "48376",
      "filing_count": 7,
      "case_count": 7,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-02-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "NOBLESVILLE IN 46060",
      "city": "Noblesville",
      "county": "Hamilton",
      "state": "IN",
      "postal_code": "46060",
      "filing_count": 89,
      "case_count": 89,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2020-10-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "WEST CHESTER PA 19380",
      "city": "West Chester",
      "county": "Chester",
      "state": "PA",
      "postal_code": "19380",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2020-12-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ALPHARETTA GA 30004",
      "city": "Alpharetta",
      "county": "Fulton",
      "state": "GA",
      "postal_code": "30004",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-01-11",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "AVON CT 6001",
      "city": "Avon",
      "county": "Avon",
      "state": "CT",
      "postal_code": "6001",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-07-06",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BRENTWOOD TN 37027",
      "city": "Brentwood",
      "county": "Williamson",
      "state": "TN",
      "postal_code": "37027",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-04-01",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CHARLOTTE NC 28273",
      "city": "Charlotte",
      "county": "Mecklenburg",
      "state": "NC",
      "postal_code": "28273",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-04-08",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "LAKELAND FL 33811",
      "city": "Lakeland",
      "county": "Polk",
      "state": "FL",
      "postal_code": "33811",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-01-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "TAMPA FL 33607",
      "city": "Tampa",
      "county": "Hillsborough",
      "state": "FL",
      "postal_code": "33607",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2019-12-02",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SEATTLE WA 98104",
      "city": "Seattle",
      "county": "King",
      "state": "WA",
      "postal_code": "98104",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-08-15",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "AUBURN HILLS MI 48326",
      "city": "Auburn Hills",
      "county": "Oakland",
      "state": "MI",
      "postal_code": "48326",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-03-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ISSAQUAH WA 98029",
      "city": "Issaquah",
      "county": "King",
      "state": "WA",
      "postal_code": "98029",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2018-10-18",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NOBELSVILLE IN 46060",
      "city": "Nobelsville",
      "county": "Hamilton",
      "state": "IN",
      "postal_code": "46060",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-03-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ROCHESTER MN 55901",
      "city": "Rochester",
      "county": "Olmstead",
      "state": "MN",
      "postal_code": "55901",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-03-15",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "KANSAS CITY MO 64102",
      "city": "Kansas City",
      "county": "Jackson",
      "state": "MO",
      "postal_code": "64102",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2018-12-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SAN FRANCISCO CA 94105",
      "city": "San Francisco",
      "county": "San Francisco",
      "state": "CA",
      "postal_code": "94105",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2018-12-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "OAK BROOK IL 60523",
      "city": "Oak Brook",
      "county": "Dupage",
      "state": "IL",
      "postal_code": "60523",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2018-12-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "FOSTER CITY CA 94404",
      "city": "Foster City",
      "county": "San Mateo",
      "state": "CA",
      "postal_code": "94404",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2018-11-16",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ANN ARBOR MI 48104",
      "city": "Ann Arbor",
      "county": "Washtenaw",
      "state": "MI",
      "postal_code": "48104",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2017-11-14",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "RICHARDSON TX 75082",
      "city": "Richardson",
      "county": "Collin",
      "state": "TX",
      "postal_code": "75082",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-08-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "LOS ANGELES CA 90064",
      "city": "Los Angeles",
      "county": "Los Angeles",
      "state": "CA",
      "postal_code": "90064",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-05-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "FISHERS IN 46038",
      "city": "Fishers",
      "county": "Hamilton County",
      "state": "IN",
      "postal_code": "46038",
      "filing_count": 39,
      "case_count": 39,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-01-09",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SOUTHFIELD MI 48076",
      "city": "Southfield",
      "county": "Oakland",
      "state": "MI",
      "postal_code": "48076",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NOBLESVILLE IN 46062",
      "city": "Noblesville",
      "county": "Hamilton",
      "state": "IN",
      "postal_code": "46062",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-04-04",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "OAKTON VA 22185",
      "city": "Oakton",
      "county": "Fairfax",
      "state": "VA",
      "postal_code": "22185",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-08-22",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "FISHERS IN 46038",
      "city": "Fishers",
      "county": "Hamilton",
      "state": "IN",
      "postal_code": "46038",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-01-09",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "RICHARDSON TX 75081",
      "city": "Richardson",
      "county": "Dallas",
      "state": "TX",
      "postal_code": "75081",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2016-10-18",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "worksite_address_count": 26,
    "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": [
    "IN",
    "MI",
    "PA",
    "GA",
    "VA",
    "WA",
    "CA",
    "CT",
    "FL",
    "IL",
    "MN",
    "MO",
    "NC",
    "TN",
    "TX"
  ],
  "cities": [
    "Noblesville",
    "Fishers",
    "Southfield",
    "West Chester",
    "Alpharetta",
    "Ann Arbor",
    "Auburn Hills",
    "Oakton",
    "Issaquah",
    "Seattle",
    "Foster City",
    "Los Angeles",
    "San Francisco",
    "Avon",
    "Lakeland",
    "Tampa",
    "Oak Brook",
    "Nobelsville",
    "Rochester",
    "Kansas City",
    "Charlotte",
    "Brentwood",
    "Richardson",
    "Farmingtn Hls",
    "Farmington",
    "Farmington Hills"
  ],
  "postal_codes": [
    "46060",
    "46038",
    "48076",
    "19380",
    "30004",
    "46062",
    "48104",
    "48326",
    "22185",
    "98029",
    "98104",
    "94404",
    "90064",
    "94105",
    "6001",
    "33811",
    "33607",
    "60523",
    "55901",
    "64102",
    "28273",
    "37027",
    "75081",
    "75082",
    "48335"
  ],
  "top_markets": [
    {
      "city": "Noblesville",
      "state": "IN",
      "postal_code": "46060",
      "lca_count": 89,
      "role_title_count": 3,
      "wage_low_min": 58000,
      "wage_high_max": 97157,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2021
    },
    {
      "city": "Fishers",
      "state": "IN",
      "postal_code": "46038",
      "lca_count": 41,
      "role_title_count": 2,
      "wage_low_min": 60000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Southfield",
      "state": "MI",
      "postal_code": "48076",
      "lca_count": 4,
      "role_title_count": 2,
      "wage_low_min": 55000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "West Chester",
      "state": "PA",
      "postal_code": "19380",
      "lca_count": 4,
      "role_title_count": 1,
      "wage_low_min": 96000,
      "wage_high_max": 104000,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021
    },
    {
      "city": "Alpharetta",
      "state": "GA",
      "postal_code": "30004",
      "lca_count": 3,
      "role_title_count": 1,
      "wage_low_min": 82000,
      "wage_high_max": 82000,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021
    },
    {
      "city": "Noblesville",
      "state": "IN",
      "postal_code": "46062",
      "lca_count": 3,
      "role_title_count": 1,
      "wage_low_min": 58000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Ann Arbor",
      "state": "MI",
      "postal_code": "48104",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 60000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Auburn Hills",
      "state": "MI",
      "postal_code": "48326",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 84000,
      "wage_high_max": 104000,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Oakton",
      "state": "VA",
      "postal_code": "22185",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 71000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Issaquah",
      "state": "WA",
      "postal_code": "98029",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 113318,
      "wage_high_max": 113318,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019
    }
  ]
}

Industry

{
  "naics_codes": [
    "541519",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541511",
      "filing_count": 142,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "541519",
      "filing_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ]
}

Wage Summary

{
  "annualized_low_min": 55000,
  "annualized_high_max": 121077,
  "annualized_low_avg": 80265.1904761905
}

Trend

[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 25,
    "case_count": 25,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 60000,
    "wage_high_max": 0,
    "wage_low_avg": 60600
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 30,
    "case_count": 30,
    "role_title_count": 3,
    "worksite_count": 7,
    "wage_low_min": 55000,
    "wage_high_max": 0,
    "wage_low_avg": 61333.9666666667
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 28,
    "case_count": 28,
    "role_title_count": 2,
    "worksite_count": 6,
    "wage_low_min": 79227,
    "wage_high_max": 0,
    "wage_low_avg": 87412.3214285714
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 58,
    "case_count": 58,
    "role_title_count": 2,
    "worksite_count": 10,
    "wage_low_min": 71240,
    "wage_high_max": 121077,
    "wage_low_avg": 90319.1724137931
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q1",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 2,
    "wage_low_min": 79000,
    "wage_high_max": 96000,
    "wage_low_avg": 87500
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 87000,
    "wage_high_max": 87000,
    "wage_low_avg": 87000
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 11,
    "case_count": 11,
    "role_title_count": 3,
    "worksite_count": 3,
    "wage_low_min": 82000,
    "wage_high_max": 105000,
    "wage_low_avg": 87818.1818181818
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q1",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 1,
    "worksite_count": 2,
    "wage_low_min": 97157,
    "wage_high_max": 104000,
    "wage_low_avg": 99438
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q2",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 1,
    "worksite_count": 3,
    "wage_low_min": 82000,
    "wage_high_max": 104000,
    "wage_low_avg": 95078.5
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 5,
    "case_count": 5,
    "role_title_count": 1,
    "worksite_count": 4,
    "wage_low_min": 69534,
    "wage_high_max": 104000,
    "wage_low_avg": 89969.6
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 87000,
    "wage_high_max": 87000,
    "wage_low_avg": 87000
  }
]

Links

{
  "roles": "/v1/roles?company=Spate%20Business%20Solutions%20LLC",
  "wages": "/v1/wages?company=Spate%20Business%20Solutions%20LLC",
  "trends": "/v1/trends?company=Spate%20Business%20Solutions%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=spate+business+solutions+llc&limit=5JSON

Docs · Get an API key