Home / Companies / SPARTA CONSULTING INC.
SPARTA CONSULTING INC. 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.
| Employer | LCA filings | Role titles | Worksites | Coverage | USCIS approvals | Top role | Sources | Open |
|---|---|---|---|---|---|---|---|---|
| SPARTA CONSULTING INC. KPIT, NOT APPLICABLE, SPARTA CONSULTING INC DBA KPIT | 357 | 33 | 109 | FY2016 to FY2020 Latest decision 2020-01-16 | 644 | PRINCIPAL CONSULTANT 72 filings | dol_oflc_lca, uscis_h1b_employer_data_hub | Profile |
Activity summary
| LCA filings | 357 |
| Certified LCAs | 344 |
| Denied LCAs | 3 |
| Role titles | 33 |
| Worksites | 109 |
| Latest decision | 2020-01-16 |
| USCIS approvals | 644 |
| USCIS denials | 158 |
Aliases and source names
| Aliases | Source Names | Sources |
|---|---|---|
| KPIT, NOT APPLICABLE, SPARTA CONSULTING INC DBA KPIT, SPARTA CONSULTING INC | SPARTA CONSULTING INC., SPARTA CONSULTING INC DBA KPIT, SPARTA CONSULTING INC | dol_oflc_lca, uscis_h1b_employer_data_hub |
Top roles
| Title | SOC | LCA filings | Low wage min | High wage max |
|---|---|---|---|---|
| PRINCIPAL CONSULTANT | 15-1121 COMPUTER SYSTEMS ANALYSTS | 72 | $82,000 | $128,307 |
| SENIOR CONSULTANT | 15-1121 | 71 | $80,000 | $105,000 |
| CONSULTANT | 15-1121 | 66 | $70,000 | $90,000 |
| PRINCIPAL CONSULTANT | 15-1132 SOFTWARE DEVELOPERS, APPLICATIONS | 29 | $89,528 | $133,900 |
| SENIOR CONSULTANT | 15-1132 SOFTWARE DEVELOPERS, APPLICATIONS | 26 | $88,000 | $132,625 |
| PLATINUM CONSULTANT | 15-1121 COMPUTER SYSTEMS ANALYSTS | 15 | $118,000 | $150,000 |
| MANAGING CONSULTANT | 15-1121 COMPUTER SYSTEMS ANALYSTS | 8 | $88,000 | $120,000 |
| PLATINUM CONSULTANT | 15-1132 SOFTWARE DEVELOPERS, APPLICATIONS | 8 | $120,000 | $148,948 |
| SENIOR MANAGER | 15-1121 | 7 | $105,000 | $0 |
| CONSULTANT | 15-1132 | 5 | $85,000 | $0 |
Top markets
| City | State | Postal Code | LCA Count | Role Title Count | Wage Low Min | Wage High Max | First Fiscal Year | Latest Fiscal Year |
|---|---|---|---|---|---|---|---|---|
| Folsom | CA | 95630 | 67 | 9 | 70,000 | 115,000 | 2,016 | 2,020 |
| Honolulu | HI | 96813 | 30 | 6 | 80,000 | 121,396 | 2,017 | 2,019 |
| King Of Prussia | PA | 19406 | 19 | 8 | 76,357 | 119,025 | 2,016 | 2,019 |
| Dubuque | IA | 52001 | 13 | 3 | 85,000 | 150,000 | 2,016 | 2,018 |
| Sunnyvale | CA | 94089 | 12 | 4 | 75,000 | 0 | 2,016 | 2,017 |
| Austin | TX | 78701 | 10 | 5 | 70,000 | 88,000 | 2,016 | 2,017 |
| Edison | NJ | 08837 | 9 | 4 | 74,000 | 105,000 | 2,017 | 2,017 |
| Portland | OR | 97229 | 8 | 6 | 78,187 | 148,000 | 2,018 | 2,019 |
| Lehi | UT | 84043 | 8 | 2 | 115,000 | 0 | 2,016 | 2,017 |
| Hazelwood | MO | 63042 | 7 | 3 | 88,000 | 127,000 | 2,016 | 2,019 |
Full company payload
| Company ID | company:sparta consulting |
| Name | SPARTA CONSULTING INC. |
| Normalized Name | sparta consulting |
| Source Company Ids | company_dol_oflc_lca_sparta_consulting_inc, company_uscis_h1b_datahub_sparta_consulting_inc_dba_kpit_tax_1190, company_uscis_h1b_datahub_sparta_consulting_inc_tax_1190, company_uscis_h1b_datahub_sparta_consulting_inc_dba_kpit_tax_5030 |
| Source Names | SPARTA CONSULTING INC., SPARTA CONSULTING INC DBA KPIT, SPARTA CONSULTING INC |
| Aliases | KPIT, NOT APPLICABLE, SPARTA CONSULTING INC DBA KPIT, SPARTA CONSULTING INC |
| Sources | dol_oflc_lca, uscis_h1b_employer_data_hub |
Names
{
"source_names": [
"SPARTA CONSULTING INC.",
"SPARTA CONSULTING INC DBA KPIT",
"SPARTA CONSULTING INC"
],
"dba_names": [
"KPIT",
"NOT APPLICABLE"
],
"name_variants": [
{
"value": "SPARTA CONSULTING INC.",
"filing_count": 235,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017,
"source": "dol_oflc_lca"
},
{
"value": "KPIT",
"filing_count": 87,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2019,
"source": "dol_oflc_lca"
},
{
"value": "SPARTA CONSULTING, INC.",
"filing_count": 25,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2020,
"source": "dol_oflc_lca"
},
{
"value": "Sparta Consulting, Inc.",
"filing_count": 7,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"source": "dol_oflc_lca"
},
{
"value": "NOT APPLICABLE",
"filing_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"source": "dol_oflc_lca"
},
{
"value": "SPARTA CONSULTING INC DBA KPIT",
"source": "uscis_h1b_employer_data_hub"
},
{
"value": "SPARTA CONSULTING INC",
"source": "uscis_h1b_employer_data_hub"
},
{
"value": "SPARTA CONSULTING INC DBA KPIT",
"source": "uscis_h1b_employer_data_hub"
}
]
}Identifiers
[
{
"identifier_type": "tax_id_last_four",
"identifier_value": "1190",
"source": "uscis_h1b_employer_data_hub"
},
{
"identifier_type": "tax_id_last_four",
"identifier_value": "5030",
"source": "uscis_h1b_employer_data_hub"
}
]LCA Activity
{
"lca_count": 357,
"case_count": 357,
"role_title_count": 33,
"worksite_count": 109,
"total_workers": 645,
"first_fiscal_year": 2016,
"first_received_date": "2013-08-27",
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-01-16",
"certified_count": 344,
"denied_count": 3,
"status_breakdown": [
{
"value": "CERTIFIED",
"filing_count": 330,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2019,
"source": "dol_oflc_lca"
},
{
"value": "Certified",
"filing_count": 10,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"source": "dol_oflc_lca"
},
{
"value": "WITHDRAWN",
"filing_count": 10,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017,
"source": "dol_oflc_lca"
},
{
"value": "CERTIFIED-WITHDRAWN",
"filing_count": 3,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2019,
"source": "dol_oflc_lca"
},
{
"value": "DENIED",
"filing_count": 3,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2018,
"source": "dol_oflc_lca"
},
{
"value": "Certified - Withdrawn",
"filing_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"source": "dol_oflc_lca"
}
],
"visa_class_breakdown": [
{
"value": "H-1B",
"filing_count": 357,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2020,
"source": "dol_oflc_lca"
}
],
"full_time_position_breakdown": [
{
"value": "Y",
"filing_count": 235,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2020,
"source": "dol_oflc_lca"
}
]
}Petition Activity
{
"initial_approval": 0,
"initial_denial": 0,
"continuing_approval": 0,
"continuing_denial": 0,
"total_approval": 644,
"total_denial": 158,
"fiscal_years": [
"2009",
"2010",
"2011",
"2012",
"2013",
"2014",
"2015",
"2016",
"2017",
"2018",
"2019",
"2020"
],
"year_metrics": [
{
"cities": [
"Folsom"
],
"states": [
"CA"
],
"fiscal_year": 2014,
"naics_codes": [
"54"
],
"postal_codes": [
"95630"
],
"total_denial": 3,
"initial_denial": 2,
"total_approval": 57,
"initial_approval": 13,
"continuing_denial": 1,
"petition_count_id": "petition_count_uscis_h1b_archive_sparta_consulting_inc_dba_kpit_tax_1190_2014",
"source_record_ids": [
"sr_uscis_h1b_datahub_2014_row_017553"
],
"continuing_approval": 44
},
{
"cities": [
"Folsom"
],
"states": [
"CA"
],
"fiscal_year": 2015,
"naics_codes": [
"54"
],
"postal_codes": [
"95630"
],
"total_denial": 1,
"initial_denial": 1,
"total_approval": 48,
"initial_approval": 14,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_sparta_consulting_inc_dba_kpit_tax_1190_2015",
"source_record_ids": [
"sr_uscis_h1b_datahub_2015_row_014019"
],
"continuing_approval": 34
},
{
"cities": [
"Folsom"
],
"states": [
"CA"
],
"fiscal_year": 2016,
"naics_codes": [
"54"
],
"postal_codes": [
"95630"
],
"total_denial": 26,
"initial_denial": 1,
"total_approval": 98,
"initial_approval": 23,
"continuing_denial": 25,
"petition_count_id": "petition_count_uscis_h1b_archive_sparta_consulting_inc_dba_kpit_tax_1190_2016",
"source_record_ids": [
"sr_uscis_h1b_datahub_2016_row_014626"
],
"continuing_approval": 75
},
{
"cities": [
"Folsom"
],
"states": [
"CA"
],
"fiscal_year": 2017,
"naics_codes": [
"54"
],
"postal_codes": [
"95630"
],
"total_denial": 36,
"initial_denial": 0,
"total_approval": 71,
"initial_approval": 3,
"continuing_denial": 36,
"petition_count_id": "petition_count_uscis_h1b_archive_sparta_consulting_inc_dba_kpit_tax_1190_2017",
"source_record_ids": [
"sr_uscis_h1b_datahub_2017_row_013075"
],
"continuing_approval": 68
},
{
"cities": [
"Folsom"
],
"states": [
"CA"
],
"fiscal_year": 2018,
"naics_codes": [
"54"
],
"postal_codes": [
"95630"
],
"total_denial": 39,
"initial_denial": 10,
"total_approval": 48,
"initial_approval": 18,
"continuing_denial": 29,
"petition_count_id": "petition_count_uscis_h1b_archive_sparta_consulting_inc_dba_kpit_tax_1190_2018",
"source_record_ids": [
"sr_uscis_h1b_datahub_2018_row_013977"
],
"continuing_approval": 30
},
{
"cities": [
"Folsom"
],
"states": [
"CA"
],
"fiscal_year": 2019,
"naics_codes": [
"54"
],
"postal_codes": [
"95630"
],
"total_denial": 24,
"initial_denial": 1,
"total_approval": 28,
"initial_approval": 0,
"continuing_denial": 23,
"petition_count_id": "petition_count_uscis_h1b_archive_sparta_consulting_inc_dba_kpit_tax_1190_2019",
"source_record_ids": [
"sr_uscis_h1b_datahub_2019_row_013917"
],
"continuing_approval": 28
},
{
"cities": [
"Folsom"
],
"states": [
"CA"
],
"fiscal_year": 2009,
"naics_codes": [
"54"
],
"postal_codes": [
"95360",
"95630"
],
"total_denial": 9,
"initial_denial": 1,
"total_approval": 18,
"initial_approval": 4,
"continuing_denial": 8,
"petition_count_id": "petition_count_uscis_h1b_archive_sparta_consulting_inc_tax_1190_2009",
"source_record_ids": [
"sr_uscis_h1b_datahub_2009_row_026531",
"sr_uscis_h1b_datahub_2009_row_026532"
],
"continuing_approval": 14
},
{
"cities": [
"Folsom"
],
"states": [
"CA"
],
"fiscal_year": 2010,
"naics_codes": [
"54"
],
"postal_codes": [
"95630"
],
"total_denial": 1,
"initial_denial": 0,
"total_approval": 15,
"initial_approval": 0,
"continuing_denial": 1,
"petition_count_id": "petition_count_uscis_h1b_archive_sparta_consulting_inc_tax_1190_2010",
"source_record_ids": [
"sr_uscis_h1b_datahub_2010_row_020280"
],
"continuing_approval": 15
},
{
"cities": [
"Ames",
"Folsom"
],
"states": [
"CA",
"IA"
],
"fiscal_year": 2011,
"naics_codes": [
"54"
],
"postal_codes": [
"50014",
"95630"
],
"total_denial": 3,
"initial_denial": 0,
"total_approval": 70,
"initial_approval": 13,
"continuing_denial": 3,
"petition_count_id": "petition_count_uscis_h1b_archive_sparta_consulting_inc_tax_1190_2011",
"source_record_ids": [
"sr_uscis_h1b_datahub_2011_row_022142",
"sr_uscis_h1b_datahub_2011_row_022143"
],
"continuing_approval": 57
},
{
"cities": [
"Ames",
"Folsom"
],
"states": [
"CA",
"IA"
],
"fiscal_year": 2012,
"naics_codes": [
"54"
],
"postal_codes": [
"50014",
"95630"
],
"total_denial": 4,
"initial_denial": 0,
"total_approval": 85,
"initial_approval": 20,
"continuing_denial": 4,
"petition_count_id": "petition_count_uscis_h1b_archive_sparta_consulting_inc_tax_1190_2012",
"source_record_ids": [
"sr_uscis_h1b_datahub_2012_row_019133",
"sr_uscis_h1b_datahub_2012_row_019134"
],
"continuing_approval": 65
},
{
"cities": [
"Folsom"
],
"states": [
"CA"
],
"fiscal_year": 2013,
"naics_codes": [
"54"
],
"postal_codes": [
"95630"
],
"total_denial": 7,
"initial_denial": 6,
"total_approval": 78,
"initial_approval": 37,
"continuing_denial": 1,
"petition_count_id": "petition_count_uscis_h1b_archive_sparta_consulting_inc_tax_1190_2013",
"source_record_ids": [
"sr_uscis_h1b_datahub_2013_row_017925"
],
"continuing_approval": 41
},
{
"cities": [
"Folsom"
],
"states": [
"CA"
],
"fiscal_year": 2020,
"naics_codes": [
"54"
],
"postal_codes": [
"95630"
],
"total_denial": 4,
"initial_denial": 1,
"total_approval": 28,
"initial_approval": 7,
"continuing_denial": 3,
"petition_count_id": "petition_count_uscis_h1b_archive_sparta_consulting_inc_tax_1190_2020",
"source_record_ids": [
"sr_uscis_h1b_datahub_2020_row_044844"
],
"continuing_approval": 21
},
{
"cities": [
"Folsom"
],
"states": [
"CA"
],
"fiscal_year": 2019,
"naics_codes": [
"54"
],
"postal_codes": [
"95630"
],
"total_denial": 1,
"initial_denial": 0,
"total_approval": 0,
"initial_approval": 0,
"continuing_denial": 1,
"petition_count_id": "petition_count_uscis_h1b_archive_sparta_consulting_inc_dba_kpit_tax_5030_2019",
"source_record_ids": [
"sr_uscis_h1b_datahub_2019_row_056186"
],
"continuing_approval": 0
}
]
}Addresses
{
"office_addresses": [
{
"address_kind": "office",
"raw_address": "FOLSOM CA 95630",
"city": "Folsom",
"state": "CA",
"postal_code": "95630",
"filing_count": 355,
"case_count": 355,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-01-16",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "office",
"raw_address": "FOLSOM CA 94520",
"city": "Folsom",
"state": "CA",
"postal_code": "94520",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-06-04",
"source_ids": [
"dol_oflc_lca"
]
}
],
"worksite_addresses": [
{
"address_kind": "worksite",
"raw_address": "FOLSOM CA 95630",
"city": "Folsom",
"county": "Sacramento",
"state": "CA",
"postal_code": "95630",
"filing_count": 67,
"case_count": 67,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2020,
"latest_decision_date": "2019-12-18",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ELYRIA OH 44035",
"city": "Elyria",
"county": "Lorain",
"state": "OH",
"postal_code": "44035",
"filing_count": 6,
"case_count": 6,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2019-12-11",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "COLUMBUS IN 47201",
"city": "Columbus",
"county": "Bartholomew",
"state": "IN",
"postal_code": "47201",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2020,
"latest_decision_date": "2019-10-14",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "SKANEATELES FALLS NY 13153",
"city": "Skaneateles Falls",
"county": "Onondaga",
"state": "NY",
"postal_code": "13153",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2020,
"latest_decision_date": "2019-12-04",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "NORTHRIDGE CA 91325",
"city": "Northridge",
"county": "Los Angeles",
"state": "CA",
"postal_code": "91325",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-01-16",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "OAKBROOK TERRACE IL 60181",
"city": "Oakbrook Terrace",
"county": "Dupage",
"state": "IL",
"postal_code": "60181",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2019-11-29",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "HONOLULU HI 96813",
"city": "Honolulu",
"county": "Honolulu",
"state": "HI",
"postal_code": "96813",
"filing_count": 30,
"case_count": 30,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-09-16",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "KING OF PRUSSIA PA 19406",
"city": "King Of Prussia",
"county": "Montgomery",
"state": "PA",
"postal_code": "19406",
"filing_count": 19,
"case_count": 19,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-06-04",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "PORTLAND OR 97229",
"city": "Portland",
"county": "Multnomah",
"state": "OR",
"postal_code": "97229",
"filing_count": 8,
"case_count": 8,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-05-03",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "MIRAMAR FL 33025",
"city": "Miramar",
"county": "Broward",
"state": "FL",
"postal_code": "33025",
"filing_count": 6,
"case_count": 6,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-05-17",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "WAUKESHA WI 53189",
"city": "Waukesha",
"county": "Waukesha",
"state": "WI",
"postal_code": "53189",
"filing_count": 4,
"case_count": 4,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-09-11",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "SAN JOSE CA 95131",
"city": "San Jose",
"county": "Santa Clara",
"state": "CA",
"postal_code": "95131",
"filing_count": 4,
"case_count": 4,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2019,
"latest_decision_date": "2018-11-08",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "DALLAS TX 75235",
"city": "Dallas",
"county": "Dallas",
"state": "TX",
"postal_code": "75235",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-06-27",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "HAZELWOOD MO 63042",
"city": "Hazelwood",
"county": "St. Louis",
"state": "MO",
"postal_code": "63042",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-06-13",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "THE WOODLANDS TX 77380",
"city": "The Woodlands",
"county": "Montgomery",
"state": "TX",
"postal_code": "77380",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-02-14",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CHARLOTTE NC 28273",
"city": "Charlotte",
"county": "Mecklenburg",
"state": "NC",
"postal_code": "28273",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2019,
"latest_decision_date": "2018-10-12",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "BATESVILLE IN 47006",
"city": "Batesville",
"county": "Ripley",
"state": "IN",
"postal_code": "47006",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-09-26",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "TEWKSBURY MA 1876",
"city": "Tewksbury",
"county": "Middlesex",
"state": "MA",
"postal_code": "1876",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-09-16",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "RENTON WA 98057",
"city": "Renton",
"county": "King",
"state": "WA",
"postal_code": "98057",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-09-10",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "LISLE IL 60532",
"city": "Lisle",
"county": "Dupage",
"state": "IL",
"postal_code": "60532",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-08-08",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CHANDLER AZ 85248",
"city": "Chandler",
"county": "Maricopa",
"state": "AZ",
"postal_code": "85248",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-05-31",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "RENTON WA 98057",
"city": "Renton",
"county": "King County",
"state": "WA",
"postal_code": "98057",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-05-09",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CAMBRIDGE MA 2142",
"city": "Cambridge",
"county": "Middlesex",
"state": "MA",
"postal_code": "2142",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-04-15",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "FREMONT CA 94555",
"city": "Fremont",
"county": "Alameda",
"state": "CA",
"postal_code": "94555",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-04-01",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ANN ARBOR MI 48105",
"city": "Ann Arbor",
"county": "Washtenaw",
"state": "MI",
"postal_code": "48105",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-04-01",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "PLANO TX 75025",
"city": "Plano",
"county": "Collin",
"state": "TX",
"postal_code": "75025",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-03-22",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "MONROE CT 6468",
"city": "Monroe",
"county": "Fairfield",
"state": "CT",
"postal_code": "6468",
"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": "MORRISVILLE NC 27560",
"city": "Morrisville",
"county": "Wake County",
"state": "NC",
"postal_code": "27560",
"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": "PORT WASHINGTON NY 11050",
"city": "Port Washington",
"county": "Nassau",
"state": "NY",
"postal_code": "11050",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2018-10-24",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "DUBUQUE IA 52001",
"city": "Dubuque",
"county": "Dubuque",
"state": "IA",
"postal_code": "52001",
"filing_count": 10,
"case_count": 10,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-08-27",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "MONROE CT 06468",
"city": "Monroe",
"county": "Fairfield",
"state": "CT",
"postal_code": "06468",
"filing_count": 6,
"case_count": 6,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-08-30",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "HAZELWOOD MO 63042",
"city": "Hazelwood",
"county": "St Louis",
"state": "MO",
"postal_code": "63042",
"filing_count": 5,
"case_count": 5,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-09-10",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "DUBUQUE IA 52001",
"city": "Dubuque",
"county": "Dubuque County",
"state": "IA",
"postal_code": "52001",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-07-05",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CAMBRIDGE MA 02142",
"city": "Cambridge",
"county": "Middlesex",
"state": "MA",
"postal_code": "02142",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-06-13",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "IRVINE CA 92618",
"city": "Irvine",
"county": "Orange",
"state": "CA",
"postal_code": "92618",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-03-08",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CHARLOTTE NC 28262",
"city": "Charlotte",
"county": "Mecklenburg",
"state": "NC",
"postal_code": "28262",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2018,
"latest_decision_date": "2017-11-29",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "THOMASVILLE GA 31757",
"city": "Thomasville",
"county": "Thomas",
"state": "GA",
"postal_code": "31757",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-03-22",
"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": 2,
"case_count": 2,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-01-29",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ROSEMONT IL 60018",
"city": "Rosemont",
"county": "Cook",
"state": "IL",
"postal_code": "60018",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-09-27",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CARY NC 27513",
"city": "Cary",
"county": "Wake",
"state": "NC",
"postal_code": "27513",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-07-19",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "BANNOCKBURN IL 60015",
"city": "Bannockburn",
"county": "Lake County",
"state": "IL",
"postal_code": "60015",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-06-13",
"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": 1,
"case_count": 1,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-06-07",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "DELAND FL 32724",
"city": "Deland",
"county": "Volusia",
"state": "FL",
"postal_code": "32724",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-06-04",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "AUSTIN TX 78702",
"city": "Austin",
"county": "Travis",
"state": "TX",
"postal_code": "78702",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-05-31",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "FRISCO TX 75034",
"city": "Frisco",
"county": "Collin",
"state": "TX",
"postal_code": "75034",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-05-02",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "BANNOCKBURN IL 60015",
"city": "Bannockburn",
"county": "Lake",
"state": "IL",
"postal_code": "60015",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-04-12",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "RANCHO CORDOVA CA 95742",
"city": "Rancho Cordova",
"county": "Sacramento",
"state": "CA",
"postal_code": "95742",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-03-27",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ST CHARLES MO 63301",
"city": "St Charles",
"county": "St Charles",
"state": "MO",
"postal_code": "63301",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-03-27",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "SENECA FALLS NY 13148",
"city": "Seneca Falls",
"county": "Seneca",
"state": "NY",
"postal_code": "13148",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-02-27",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ATLANTA GA 30328",
"city": "Atlanta",
"county": "Fulton",
"state": "GA",
"postal_code": "30328",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-02-26",
"source_ids": [
"dol_oflc_lca"
]
}
],
"summary": {
"office_address_count": 2,
"worksite_address_count": 50,
"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": [
"CA",
"HI",
"PA",
"IA",
"TX",
"NJ",
"OR",
"UT",
"MO",
"CT",
"FL",
"NV",
"OH",
"MA",
"WI",
"IN",
"NC",
"GA",
"IL",
"MI",
"MN",
"NY",
"OK",
"PR",
"WA",
"AZ",
"CO",
"KY",
"TN"
],
"cities": [
"Folsom",
"Honolulu",
"King Of Prussia",
"Dubuque",
"Sunnyvale",
"Austin",
"Edison",
"Portland",
"Lehi",
"Hazelwood",
"York",
"Monroe",
"Miramar",
"Reno",
"Elyria",
"Sacramento",
"San Jose",
"Cambridge",
"Houston",
"Waukesha",
"Irvine",
"Columbus",
"Milford",
"Charlotte",
"Dallas",
"Neenah",
"Costa Mesa",
"Cypress",
"Santa Ana",
"Santa Clara",
"South San Francisco",
"Thomasville",
"Bannockburn",
"Oak Brook",
"Ishpeming",
"Bloomington",
"Hampton",
"Seneca Falls",
"Skaneateles Falls",
"Norman",
"Sabana Hoyos",
"Allen",
"The Woodlands",
"Renton",
"Chandler",
"Foothill Ranch",
"Fremont",
"Los Angeles",
"Newport Beach",
"Northridge",
"Rancho Cordova",
"San Diego",
"San Francisco",
"Greenwood Village",
"Deland",
"Petersburg",
"Tampa",
"Atlanta",
"Aurora",
"Deerfield",
"Lake Zurich",
"Lisle",
"Oakbrook Terrace",
"Rosemont",
"Batesville",
"Elkhart",
"Louisville",
"Tewksbury",
"Ann Arbor",
"Mankato",
"Maryland Heights",
"St Charles",
"St Louis",
"Cary",
"Greensboro",
"Morrisville",
"Raleigh",
"Amherst",
"Conklin",
"Mineola",
"Port Washington",
"Skaneateles",
"Hiram",
"Memphis",
"Denton",
"Frisco",
"Plano",
"Draper",
"Salt Lake City",
"Bellevue",
"Seattle",
"Middleton",
"Milwaukee",
"Oak Creek",
"Ames"
],
"postal_codes": [
"95630",
"96813",
"19406",
"52001",
"94089",
"78701",
"08837",
"97229",
"84043",
"63042",
"17401",
"06468",
"33025",
"89521",
"44035",
"95833",
"95131",
"02142",
"77042",
"53189",
"92618",
"94086",
"47201",
"01757",
"28262",
"75235",
"54956",
"92626",
"90630",
"92704",
"95051",
"94080",
"31757",
"60015",
"60523",
"49849",
"55437",
"28273",
"08827",
"13148",
"13153",
"73072",
"00688",
"75013",
"77058",
"77380",
"98057",
"85248",
"82626",
"92610",
"94538",
"94555",
"90017",
"92660",
"91325",
"95742",
"92123",
"94105",
"95134",
"80111",
"6468",
"32724",
"33701",
"33634",
"30328",
"60502",
"60047",
"60532",
"60181",
"60018",
"47006",
"46516",
"40202",
"02141",
"2142",
"1876",
"48105",
"56001",
"63141",
"63301",
"63105",
"27513",
"28277",
"27409",
"27560",
"27612",
"14228",
"13748",
"11501",
"11050",
"13152",
"44234",
"97223",
"38197",
"78702",
"76205",
"75034",
"77024",
"77036",
"75025",
"84020",
"84115",
"98004",
"98112",
"53562",
"53224",
"53154",
"50014",
"95360"
],
"top_markets": [
{
"city": "Folsom",
"state": "CA",
"postal_code": "95630",
"lca_count": 67,
"role_title_count": 9,
"wage_low_min": 70000,
"wage_high_max": 115000,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2020
},
{
"city": "Honolulu",
"state": "HI",
"postal_code": "96813",
"lca_count": 30,
"role_title_count": 6,
"wage_low_min": 80000,
"wage_high_max": 121396,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2019
},
{
"city": "King Of Prussia",
"state": "PA",
"postal_code": "19406",
"lca_count": 19,
"role_title_count": 8,
"wage_low_min": 76357,
"wage_high_max": 119025,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2019
},
{
"city": "Dubuque",
"state": "IA",
"postal_code": "52001",
"lca_count": 13,
"role_title_count": 3,
"wage_low_min": 85000,
"wage_high_max": 150000,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2018
},
{
"city": "Sunnyvale",
"state": "CA",
"postal_code": "94089",
"lca_count": 12,
"role_title_count": 4,
"wage_low_min": 75000,
"wage_high_max": 0,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017
},
{
"city": "Austin",
"state": "TX",
"postal_code": "78701",
"lca_count": 10,
"role_title_count": 5,
"wage_low_min": 70000,
"wage_high_max": 88000,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017
},
{
"city": "Edison",
"state": "NJ",
"postal_code": "08837",
"lca_count": 9,
"role_title_count": 4,
"wage_low_min": 74000,
"wage_high_max": 105000,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017
},
{
"city": "Portland",
"state": "OR",
"postal_code": "97229",
"lca_count": 8,
"role_title_count": 6,
"wage_low_min": 78187,
"wage_high_max": 148000,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2019
},
{
"city": "Lehi",
"state": "UT",
"postal_code": "84043",
"lca_count": 8,
"role_title_count": 2,
"wage_low_min": 115000,
"wage_high_max": 0,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017
},
{
"city": "Hazelwood",
"state": "MO",
"postal_code": "63042",
"lca_count": 7,
"role_title_count": 3,
"wage_low_min": 88000,
"wage_high_max": 127000,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2019
}
]
}Industry
{
"naics_codes": [
"541511",
"54"
],
"naics_breakdown": [
{
"value": "541511",
"filing_count": 235,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2020,
"source": "dol_oflc_lca"
}
]
}Wage Summary
{
"annualized_low_min": 70000,
"annualized_high_max": 190000,
"annualized_low_avg": 108688.703081232
}Trend
[
{
"fiscal_year": 2016,
"quarter": "Q2",
"lca_count": 122,
"case_count": 122,
"role_title_count": 13,
"worksite_count": 44,
"wage_low_min": 70000,
"wage_high_max": 0,
"wage_low_avg": 101614.114754098
},
{
"fiscal_year": 2017,
"quarter": "Q2",
"lca_count": 113,
"case_count": 113,
"role_title_count": 7,
"worksite_count": 43,
"wage_low_min": 70000,
"wage_high_max": 150000,
"wage_low_avg": 106762.831858407
},
{
"fiscal_year": 2018,
"quarter": "Q2",
"lca_count": 66,
"case_count": 66,
"role_title_count": 11,
"worksite_count": 32,
"wage_low_min": 80000,
"wage_high_max": 0,
"wage_low_avg": 116877.727272727
},
{
"fiscal_year": 2019,
"quarter": "Q2",
"lca_count": 45,
"case_count": 45,
"role_title_count": 17,
"worksite_count": 24,
"wage_low_min": 76357,
"wage_high_max": 152250,
"wage_low_avg": 115096.555555556
},
{
"fiscal_year": 2020,
"quarter": "Q1",
"lca_count": 10,
"case_count": 10,
"role_title_count": 8,
"worksite_count": 5,
"wage_low_min": 87255,
"wage_high_max": 190000,
"wage_low_avg": 129789.6
},
{
"fiscal_year": 2020,
"quarter": "Q2",
"lca_count": 1,
"case_count": 1,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 149574,
"wage_high_max": 149574,
"wage_low_avg": 149574
}
]Links
{
"roles": "/v1/roles?company=SPARTA%20CONSULTING%20INC.",
"wages": "/v1/wages?company=SPARTA%20CONSULTING%20INC.",
"trends": "/v1/trends?company=SPARTA%20CONSULTING%20INC."
}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=sparta+consulting+inc&limit=5JSON