Home / Companies / SPL Consulting, Inc.
SPL 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 |
|---|---|---|---|---|---|---|---|---|
| SPL Consulting, Inc. SPL CONSULTING, INC., SPL CONSULTING INC | 174 | 32 | 64 | FY2017 to FY2026 Latest decision 2026-03-23 | 50 | Oracle Systems Analyst 16 filings | dol_oflc_lca, uscis_h1b_employer_data_hub | Profile |
Activity summary
| LCA filings | 174 |
| Certified LCAs | 174 |
| Denied LCAs | 0 |
| Role titles | 32 |
| Worksites | 64 |
| Latest decision | 2026-03-23 |
| USCIS approvals | 50 |
| USCIS denials | 16 |
Aliases and source names
| Aliases | Source Names | Sources |
|---|---|---|
| SPL CONSULTING, INC., SPL CONSULTING INC | SPL Consulting, Inc., SPL CONSULTING INC | dol_oflc_lca, uscis_h1b_employer_data_hub |
Top roles
| Title | SOC | LCA filings | Low wage min | High wage max |
|---|---|---|---|---|
| Oracle Systems Analyst | 15-1252.00 Software Developers | 16 | $100,000 | $130,000 |
| ORACLE DEVELOPER | 15-1132 SOFTWARE DEVELOPERS, APPLICATIONS | 13 | $100,000 | $135,000 |
| Oracle Developer | 15-1132.00 Software Developers, Applications | 12 | $96,000 | $160,000 |
| SOFTWARE DEVELOPER | 15-1132 SOFTWARE DEVELOPERS, APPLICATIONS | 12 | $81,000 | $105,227 |
| Oracle Solution Architect | 15-1132.00 Software Developers, Applications | 11 | $120,000 | $170,000 |
| Oracle Developer | 15-1252.00 Software Developers | 10 | $85,738 | $160,000 |
| Software Developer | 15-1132.00 Software Developers, Applications | 10 | $96,000 | $150,000 |
| Solution Architect | 15-1252.00 Software Developers | 9 | $84,000 | $165,000 |
| Oracle Solution Architect | 15-1252.00 Software Developers | 7 | $150,000 | $240,000 |
| Solution Architect | 15-1132.00 Software Developers, Applications | 7 | $100,000 | $160,000 |
Top markets
| City | State | Postal Code | LCA Count | Role Title Count | Wage Low Min | Wage High Max | First Fiscal Year | Latest Fiscal Year |
|---|---|---|---|---|---|---|---|---|
| Southlake | TX | 76092 | 42 | 12 | 84,000 | 165,000 | 2,022 | 2,026 |
| Farmers Branch | TX | 75234 | 32 | 13 | 80,000 | 135,000 | 2,017 | 2,021 |
| Miami | FL | 33178 | 6 | 2 | 100,000 | 200,000 | 2,018 | 2,023 |
| Raleigh | NC | 27604 | 4 | 2 | 120,000 | 170,000 | 2,020 | 2,023 |
| Elkhorn | NE | 68022 | 4 | 4 | 90,000 | 0 | 2,018 | 2,018 |
| Chicago | IL | 60606 | 3 | 1 | 97,000 | 102,000 | 2,019 | 2,019 |
| Baltimore | MD | 21201 | 3 | 1 | 110,614 | 110,614 | 2,021 | 2,021 |
| Fenton | MO | 63099 | 3 | 1 | 105,000 | 105,000 | 2,019 | 2,019 |
| Raleigh | NC | 27609 | 3 | 2 | 103,272 | 130,000 | 2,024 | 2,025 |
| Ny | NY | 10001 | 3 | 1 | 135,000 | 135,000 | 2,021 | 2,021 |
Full company payload
| Company ID | company:spl consulting |
| Name | SPL Consulting, Inc. |
| Normalized Name | spl consulting |
| Source Company Ids | company_dol_oflc_lca_spl_consulting_inc, company_uscis_h1b_datahub_spl_consulting_inc_tax_3780 |
| Source Names | SPL Consulting, Inc., SPL CONSULTING INC |
| Aliases | SPL CONSULTING, INC., SPL CONSULTING INC |
| Sources | dol_oflc_lca, uscis_h1b_employer_data_hub |
Names
{
"source_names": [
"SPL Consulting, Inc.",
"SPL CONSULTING INC"
],
"dba_names": [
"SPL CONSULTING, INC."
],
"name_variants": [
{
"value": "SPL Consulting, Inc.",
"filing_count": 124,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2026,
"source": "dol_oflc_lca"
},
{
"value": "SPL CONSULTING, INC.",
"filing_count": 24,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2019,
"source": "dol_oflc_lca"
},
{
"value": "SPL CONSULTING INC",
"source": "uscis_h1b_employer_data_hub"
}
]
}Identifiers
[
{
"identifier_type": "tax_id_last_four",
"identifier_value": "3780",
"source": "uscis_h1b_employer_data_hub"
}
]LCA Activity
{
"lca_count": 174,
"case_count": 174,
"role_title_count": 32,
"worksite_count": 64,
"total_workers": 174,
"first_fiscal_year": 2017,
"first_received_date": "2017-06-29",
"latest_fiscal_year": 2026,
"latest_decision_date": "2026-03-23",
"certified_count": 174,
"denied_count": 0,
"status_breakdown": [
{
"value": "Certified",
"filing_count": 124,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2026,
"source": "dol_oflc_lca"
},
{
"value": "CERTIFIED",
"filing_count": 50,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2019,
"source": "dol_oflc_lca"
}
],
"visa_class_breakdown": [
{
"value": "H-1B",
"filing_count": 174,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2026,
"source": "dol_oflc_lca"
}
],
"full_time_position_breakdown": [
{
"value": "Y",
"filing_count": 173,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2026,
"source": "dol_oflc_lca"
},
{
"value": "N",
"filing_count": 1,
"first_fiscal_year": 2026,
"latest_fiscal_year": 2026,
"source": "dol_oflc_lca"
}
]
}Petition Activity
{
"initial_approval": 0,
"initial_denial": 0,
"continuing_approval": 0,
"continuing_denial": 0,
"total_approval": 50,
"total_denial": 16,
"fiscal_years": [
"2018",
"2019",
"2020",
"2021",
"2022",
"2023"
],
"year_metrics": [
{
"cities": [
"Farmers Ranch"
],
"states": [
"TX"
],
"fiscal_year": 2018,
"naics_codes": [
"54"
],
"postal_codes": [
"75234"
],
"total_denial": 1,
"initial_denial": 0,
"total_approval": 0,
"initial_approval": 0,
"continuing_denial": 1,
"petition_count_id": "petition_count_uscis_h1b_archive_spl_consulting_inc_tax_3780_2018",
"source_record_ids": [
"sr_uscis_h1b_datahub_2018_row_018974"
],
"continuing_approval": 0
},
{
"cities": [
"Dallas",
"Farmers Branch"
],
"states": [
"TX"
],
"fiscal_year": 2019,
"naics_codes": [
"54"
],
"postal_codes": [
"75234"
],
"total_denial": 7,
"initial_denial": 0,
"total_approval": 12,
"initial_approval": 1,
"continuing_denial": 7,
"petition_count_id": "petition_count_uscis_h1b_archive_spl_consulting_inc_tax_3780_2019",
"source_record_ids": [
"sr_uscis_h1b_datahub_2019_row_018787",
"sr_uscis_h1b_datahub_2019_row_018788"
],
"continuing_approval": 11
},
{
"cities": [
"Dallas",
"Farmers Branch"
],
"states": [
"TX"
],
"fiscal_year": 2020,
"naics_codes": [
"54"
],
"postal_codes": [
"75234"
],
"total_denial": 4,
"initial_denial": 2,
"total_approval": 10,
"initial_approval": 2,
"continuing_denial": 2,
"petition_count_id": "petition_count_uscis_h1b_archive_spl_consulting_inc_tax_3780_2020",
"source_record_ids": [
"sr_uscis_h1b_datahub_2020_row_045006",
"sr_uscis_h1b_datahub_2020_row_045007"
],
"continuing_approval": 8
},
{
"cities": [
"Dallas",
"Farmers Branch",
"Farmers Brnch"
],
"states": [
"TX"
],
"fiscal_year": 2021,
"naics_codes": [
"54"
],
"postal_codes": [
"75234"
],
"total_denial": 2,
"initial_denial": 0,
"total_approval": 14,
"initial_approval": 5,
"continuing_denial": 2,
"petition_count_id": "petition_count_uscis_h1b_archive_spl_consulting_inc_tax_3780_2021",
"source_record_ids": [
"sr_uscis_h1b_datahub_2021_row_049099",
"sr_uscis_h1b_datahub_2021_row_049100",
"sr_uscis_h1b_datahub_2021_row_049101"
],
"continuing_approval": 9
},
{
"cities": [
"Southlake"
],
"states": [
"TX"
],
"fiscal_year": 2022,
"naics_codes": [
"54"
],
"postal_codes": [
"76092"
],
"total_denial": 1,
"initial_denial": 0,
"total_approval": 13,
"initial_approval": 7,
"continuing_denial": 1,
"petition_count_id": "petition_count_uscis_h1b_archive_spl_consulting_inc_tax_3780_2022",
"source_record_ids": [
"sr_uscis_h1b_datahub_2022_row_048679"
],
"continuing_approval": 6
},
{
"cities": [
"Southlake"
],
"states": [
"TX"
],
"fiscal_year": 2023,
"naics_codes": [
"54"
],
"postal_codes": [
"76092"
],
"total_denial": 1,
"initial_denial": 1,
"total_approval": 1,
"initial_approval": 0,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_spl_consulting_inc_tax_3780_2023",
"source_record_ids": [
"sr_uscis_h1b_datahub_2023_row_026853"
],
"continuing_approval": 1
}
]
}Addresses
{
"office_addresses": [
{
"address_kind": "office",
"address_line_1": "531 Silicon Dr",
"address_line_2": "Suite 102",
"raw_address": "531 Silicon Dr Suite 102 SOUTHLAKE TX 76092",
"city": "Southlake",
"state": "TX",
"postal_code": "76092",
"filing_count": 5,
"case_count": 5,
"first_fiscal_year": 2026,
"latest_fiscal_year": 2026,
"latest_decision_date": "2026-03-23",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "office",
"raw_address": "SOUTHLAKE TX 76092",
"city": "Southlake",
"state": "TX",
"postal_code": "76092",
"filing_count": 71,
"case_count": 71,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-07-15",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "office",
"raw_address": "FARMERS BRANCH TX 75234",
"city": "Farmers Branch",
"state": "TX",
"postal_code": "75234",
"filing_count": 98,
"case_count": 98,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-06-25",
"source_ids": [
"dol_oflc_lca"
]
}
],
"worksite_addresses": [
{
"address_kind": "worksite",
"address_line_1": "5522 Heart Pine Way",
"raw_address": "5522 Heart Pine Way KATY TX 77494",
"city": "Katy",
"state": "TX",
"postal_code": "77494",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2026,
"latest_fiscal_year": 2026,
"latest_decision_date": "2026-03-23",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"address_line_1": "9823 N MacArthur Blvd",
"address_line_2": "Suite #1101",
"raw_address": "9823 N MacArthur Blvd Suite #1101 IRVING TX 75063",
"city": "Irving",
"state": "TX",
"postal_code": "75063",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2026,
"latest_fiscal_year": 2026,
"latest_decision_date": "2026-03-02",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"address_line_1": "531 Silicon Dr",
"address_line_2": "Ste 102",
"raw_address": "531 Silicon Dr Ste 102 SOUTHLAKE TX 76092",
"city": "Southlake",
"state": "TX",
"postal_code": "76092",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2026,
"latest_fiscal_year": 2026,
"latest_decision_date": "2025-12-23",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"address_line_1": "5495B Briardale Ln",
"raw_address": "5495B Briardale Ln DUBLIN OH 43016",
"city": "Dublin",
"state": "OH",
"postal_code": "43016",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2026,
"latest_fiscal_year": 2026,
"latest_decision_date": "2025-12-10",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"address_line_1": "531 Silicon Dr,",
"address_line_2": "Ste 102.",
"raw_address": "531 Silicon Dr, Ste 102. SOUTHLAKE TX 76092",
"city": "Southlake",
"state": "TX",
"postal_code": "76092",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2026,
"latest_fiscal_year": 2026,
"latest_decision_date": "2025-12-01",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "SOUTHLAKE TX 76092",
"city": "Southlake",
"county": "Tarrant",
"state": "TX",
"postal_code": "76092",
"filing_count": 40,
"case_count": 40,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-05-13",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "RALEIGH NC 27609",
"city": "Raleigh",
"county": "Wake",
"state": "NC",
"postal_code": "27609",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2025,
"latest_decision_date": "2024-11-21",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "NASHUA NH 03063",
"city": "Nashua",
"county": "Hillsborough",
"state": "NH",
"postal_code": "03063",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-05-13",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "PHOENIXVILLE PA 19460",
"city": "Phoenixville",
"county": "Chester",
"state": "PA",
"postal_code": "19460",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-01-29",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "IRVING TX 75063",
"city": "Irving",
"state": "TX",
"postal_code": "75063",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-07-15",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "MORRISVILLE NC 27560",
"city": "Morrisville",
"county": "Wake",
"state": "NC",
"postal_code": "27560",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-05-08",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "SEATTLE WA 98119-4375",
"city": "Seattle",
"county": "King",
"state": "WA",
"postal_code": "98119-4375",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-05-01",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CONROE TX 77385",
"city": "Conroe",
"county": "Montgomery",
"state": "TX",
"postal_code": "77385",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-01-15",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CYPRESS TX 77433",
"city": "Cypress",
"county": "Harris",
"state": "TX",
"postal_code": "77433",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2024,
"latest_decision_date": "2024-08-27",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "LONG GROVE IL 60047",
"city": "Long Grove",
"county": "Lake",
"state": "IL",
"postal_code": "60047",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2024,
"latest_decision_date": "2024-06-05",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "JERSEY CITY NJ 07310",
"city": "Jersey City",
"county": "Hudson",
"state": "NJ",
"postal_code": "07310",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2024,
"latest_decision_date": "2024-05-13",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "MCKINNEY TX 75070",
"city": "Mckinney",
"county": "Collin",
"state": "TX",
"postal_code": "75070",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2024,
"latest_decision_date": "2024-04-19",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "IRVING TX 75063",
"city": "Irving",
"county": "Dallas",
"state": "TX",
"postal_code": "75063",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2024,
"latest_decision_date": "2024-02-07",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CHARLOTTE NC 28262",
"city": "Charlotte",
"county": "Mecklenburg",
"state": "NC",
"postal_code": "28262",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2024,
"latest_decision_date": "2024-01-29",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "KATY TX 77493",
"city": "Katy",
"county": "Harris",
"state": "TX",
"postal_code": "77493",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2024,
"latest_decision_date": "2024-01-22",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "LOS ANGELES CA 90066",
"city": "Los Angeles",
"county": "Los Angeles",
"state": "CA",
"postal_code": "90066",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2024,
"latest_decision_date": "2023-11-17",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "MIAMI FL 33178",
"city": "Miami",
"county": "Miami-dade",
"state": "FL",
"postal_code": "33178",
"filing_count": 6,
"case_count": 6,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-02-01",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "RALEIGH NC 27604",
"city": "Raleigh",
"county": "Wake",
"state": "NC",
"postal_code": "27604",
"filing_count": 4,
"case_count": 4,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-05-02",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "HOUSTON TX 77042",
"city": "Houston",
"county": "Harris",
"state": "TX",
"postal_code": "77042",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-03-29",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "WESTLAKE TX 76262",
"city": "Westlake",
"county": "Denton",
"state": "TX",
"postal_code": "76262",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-09-14",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "SEATTLE WA 98119",
"city": "Seattle",
"county": "King",
"state": "WA",
"postal_code": "98119",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-06-16",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "WILMINGTON OH 45177",
"city": "Wilmington",
"county": "Clinton",
"state": "OH",
"postal_code": "45177",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-06-07",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "OAKLAND CA 94612",
"city": "Oakland",
"county": "Alameda",
"state": "CA",
"postal_code": "94612",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-04-18",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "IRVING TX 75039",
"city": "Irving",
"county": "Dallas",
"state": "TX",
"postal_code": "75039",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2022,
"latest_decision_date": "2022-02-09",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "NORTH CANTON OH 44720",
"city": "North Canton",
"county": "Stark",
"state": "OH",
"postal_code": "44720",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2022,
"latest_decision_date": "2021-11-22",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "NEWINGTON NH 3801",
"city": "Newington",
"county": "Newington",
"state": "NH",
"postal_code": "3801",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2022,
"latest_decision_date": "2021-10-20",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "FARMERS BRANCH TX 75234",
"city": "Farmers Branch",
"county": "Dallas",
"state": "TX",
"postal_code": "75234",
"filing_count": 32,
"case_count": 32,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-06-25",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "NY NY 10001",
"city": "Ny",
"county": "New York",
"state": "NY",
"postal_code": "10001",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2020-12-08",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "BALTIMORE MD 21201",
"city": "Baltimore",
"county": "Baltimore",
"state": "MD",
"postal_code": "21201",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2020-11-09",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "DALLAS TX 75202",
"city": "Dallas",
"county": "Dallas",
"state": "TX",
"postal_code": "75202",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2020-11-04",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "HOUSTON TX 77070",
"city": "Houston",
"county": "Harris",
"state": "TX",
"postal_code": "77070",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2020-11-02",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "FRISCO TX 75035",
"city": "Frisco",
"county": "Collin",
"state": "TX",
"postal_code": "75035",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2020-10-26",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "OMAHA NE 68135",
"city": "Omaha",
"county": "Douglas",
"state": "NE",
"postal_code": "68135",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-01-19",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "RICHMOND TX 77407",
"city": "Richmond",
"county": "Fort Bend",
"state": "TX",
"postal_code": "77407",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-05-25",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "SOMERVILLE MA 2143",
"city": "Somerville",
"county": "Somerville City",
"state": "MA",
"postal_code": "2143",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-03-11",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "HUNTSVILLE AL 35806",
"city": "Huntsville",
"county": "Madison",
"state": "AL",
"postal_code": "35806",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-06-04",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "HOFFMAN ESTATES IL 60169",
"city": "Hoffman Estates",
"county": "Cook",
"state": "IL",
"postal_code": "60169",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-05-11",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "LOS ANGELES CA 90028",
"city": "Los Angeles",
"county": "Los Angeles",
"state": "CA",
"postal_code": "90028",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-03-25",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "FORT MILL SC 29715",
"city": "Fort Mill",
"county": "York",
"state": "SC",
"postal_code": "29715",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-03-03",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "FT. MILL SC 29715",
"city": "Ft. Mill",
"county": "York",
"state": "SC",
"postal_code": "29715",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2019-11-19",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CHELMSFORD MA 01824",
"city": "Chelmsford",
"county": "Chelmsford",
"state": "MA",
"postal_code": "01824",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2019-11-18",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "MOUNT AIRY NC 27030",
"city": "Mount Airy",
"county": "Surry",
"state": "NC",
"postal_code": "27030",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2019-11-18",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "HUNTERSVILLE NC 28078",
"city": "Huntersville",
"county": "Mecklenburg",
"state": "NC",
"postal_code": "28078",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2019-10-25",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "FENTON MO 63099",
"city": "Fenton",
"county": "St. Louis",
"state": "MO",
"postal_code": "63099",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-06-11",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CHICAGO IL 60606",
"city": "Chicago",
"county": "Cook",
"state": "IL",
"postal_code": "60606",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-05-17",
"source_ids": [
"dol_oflc_lca"
]
}
],
"summary": {
"office_address_count": 3,
"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": [
"TX",
"FL",
"NC",
"NE",
"IL",
"MD",
"MO",
"NY",
"MA",
"NH",
"PA",
"AL",
"AZ",
"CA",
"CO",
"GA",
"MI",
"NJ",
"OH",
"SC",
"WA",
"WI"
],
"cities": [
"Southlake",
"Farmers Branch",
"Miami",
"Raleigh",
"Elkhorn",
"Chicago",
"Baltimore",
"Fenton",
"Ny",
"Dallas",
"Frisco",
"Houston",
"Irving",
"Chelmsford",
"Somerville",
"Hanover",
"Omaha",
"Nashua",
"Newington",
"Phoenixville",
"Huntsville",
"Phoenix",
"Cupertino",
"Goleta",
"Los Angeles",
"Mountain View",
"Oakland",
"San Carlos",
"San Jose",
"Denver",
"Smyrna",
"Hoffman Estates",
"Long Grove",
"Waltham",
"Rockville",
"Jackson",
"Charlotte",
"Huntersville",
"Morrisville",
"Mount Airy",
"Jersey City",
"Alliance",
"Dublin",
"North Canton",
"Wilmington",
"Fort Mill",
"Ft. Mill",
"Conroe",
"Cypress",
"Katy",
"Mckinney",
"Plano",
"Richmond",
"Westlake",
"Redmond",
"Seattle",
"Grafton",
"Farmers Brnch",
"Farmers Ranch"
],
"postal_codes": [
"76092",
"75234",
"33178",
"27604",
"68022",
"60606",
"21201",
"63099",
"27609",
"10001",
"75202",
"75035",
"77042",
"77070",
"75063",
"1824",
"2143",
"21076",
"68135",
"03063",
"3801",
"19460",
"35806",
"85012",
"95014",
"93117",
"90028",
"90066",
"94043",
"94612",
"94070",
"95134",
"80223",
"30080",
"60169",
"60047",
"01824",
"02451",
"20852",
"49204",
"28262",
"28078",
"27560",
"27030",
"07310",
"44601",
"43016",
"44720",
"45177",
"29715",
"77385",
"77433",
"75039",
"77493",
"77494",
"75070",
"75024",
"77407",
"76262",
"98052",
"98119",
"98119-4375",
"53024"
],
"top_markets": [
{
"city": "Southlake",
"state": "TX",
"postal_code": "76092",
"lca_count": 42,
"role_title_count": 12,
"wage_low_min": 84000,
"wage_high_max": 165000,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2026
},
{
"city": "Farmers Branch",
"state": "TX",
"postal_code": "75234",
"lca_count": 32,
"role_title_count": 13,
"wage_low_min": 80000,
"wage_high_max": 135000,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2021
},
{
"city": "Miami",
"state": "FL",
"postal_code": "33178",
"lca_count": 6,
"role_title_count": 2,
"wage_low_min": 100000,
"wage_high_max": 200000,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2023
},
{
"city": "Raleigh",
"state": "NC",
"postal_code": "27604",
"lca_count": 4,
"role_title_count": 2,
"wage_low_min": 120000,
"wage_high_max": 170000,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2023
},
{
"city": "Elkhorn",
"state": "NE",
"postal_code": "68022",
"lca_count": 4,
"role_title_count": 4,
"wage_low_min": 90000,
"wage_high_max": 0,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018
},
{
"city": "Chicago",
"state": "IL",
"postal_code": "60606",
"lca_count": 3,
"role_title_count": 1,
"wage_low_min": 97000,
"wage_high_max": 102000,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019
},
{
"city": "Baltimore",
"state": "MD",
"postal_code": "21201",
"lca_count": 3,
"role_title_count": 1,
"wage_low_min": 110614,
"wage_high_max": 110614,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021
},
{
"city": "Fenton",
"state": "MO",
"postal_code": "63099",
"lca_count": 3,
"role_title_count": 1,
"wage_low_min": 105000,
"wage_high_max": 105000,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019
},
{
"city": "Raleigh",
"state": "NC",
"postal_code": "27609",
"lca_count": 3,
"role_title_count": 2,
"wage_low_min": 103272,
"wage_high_max": 130000,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2025
},
{
"city": "Ny",
"state": "NY",
"postal_code": "10001",
"lca_count": 3,
"role_title_count": 1,
"wage_low_min": 135000,
"wage_high_max": 135000,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021
}
]
}Industry
{
"naics_codes": [
"541511",
"54"
],
"naics_breakdown": [
{
"value": "541511",
"filing_count": 174,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2026,
"source": "dol_oflc_lca"
}
]
}Wage Summary
{
"annualized_low_min": 77605,
"annualized_high_max": 240000,
"annualized_low_avg": 117974.028735632
}Trend
[
{
"fiscal_year": 2017,
"quarter": "Q2",
"lca_count": 5,
"case_count": 5,
"role_title_count": 3,
"worksite_count": 1,
"wage_low_min": 80000,
"wage_high_max": 0,
"wage_low_avg": 98800
},
{
"fiscal_year": 2018,
"quarter": "Q2",
"lca_count": 26,
"case_count": 26,
"role_title_count": 11,
"worksite_count": 13,
"wage_low_min": 90000,
"wage_high_max": 0,
"wage_low_avg": 105379.384615385
},
{
"fiscal_year": 2019,
"quarter": "Q2",
"lca_count": 19,
"case_count": 19,
"role_title_count": 6,
"worksite_count": 12,
"wage_low_min": 81000,
"wage_high_max": 135000,
"wage_low_avg": 104052.631578947
},
{
"fiscal_year": 2020,
"quarter": "Q1",
"lca_count": 4,
"case_count": 4,
"role_title_count": 3,
"worksite_count": 4,
"wage_low_min": 116000,
"wage_high_max": 150000,
"wage_low_avg": 136500
},
{
"fiscal_year": 2020,
"quarter": "Q2",
"lca_count": 6,
"case_count": 6,
"role_title_count": 4,
"worksite_count": 5,
"wage_low_min": 105000,
"wage_high_max": 170000,
"wage_low_avg": 130833.333333333
},
{
"fiscal_year": 2020,
"quarter": "Q3",
"lca_count": 4,
"case_count": 4,
"role_title_count": 2,
"worksite_count": 4,
"wage_low_min": 96000,
"wage_high_max": 160000,
"wage_low_avg": 131500
},
{
"fiscal_year": 2020,
"quarter": "Q4",
"lca_count": 2,
"case_count": 2,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 120000,
"wage_high_max": 170000,
"wage_low_avg": 145000
},
{
"fiscal_year": 2021,
"quarter": "Q1",
"lca_count": 6,
"case_count": 6,
"role_title_count": 4,
"worksite_count": 6,
"wage_low_min": 105227,
"wage_high_max": 150000,
"wage_low_avg": 121011.333333333
},
{
"fiscal_year": 2021,
"quarter": "Q2",
"lca_count": 9,
"case_count": 9,
"role_title_count": 5,
"worksite_count": 7,
"wage_low_min": 100000,
"wage_high_max": 160000,
"wage_low_avg": 124563.111111111
},
{
"fiscal_year": 2021,
"quarter": "Q3",
"lca_count": 17,
"case_count": 17,
"role_title_count": 7,
"worksite_count": 8,
"wage_low_min": 96000,
"wage_high_max": 160000,
"wage_low_avg": 115311.470588235
},
{
"fiscal_year": 2022,
"quarter": "Q1",
"lca_count": 3,
"case_count": 3,
"role_title_count": 3,
"worksite_count": 3,
"wage_low_min": 120000,
"wage_high_max": 120000,
"wage_low_avg": 120000
},
{
"fiscal_year": 2022,
"quarter": "Q2",
"lca_count": 5,
"case_count": 5,
"role_title_count": 3,
"worksite_count": 3,
"wage_low_min": 100000,
"wage_high_max": 150000,
"wage_low_avg": 126800
},
{
"fiscal_year": 2022,
"quarter": "Q3",
"lca_count": 7,
"case_count": 7,
"role_title_count": 3,
"worksite_count": 1,
"wage_low_min": 100000,
"wage_high_max": 150000,
"wage_low_avg": 108571.428571429
},
{
"fiscal_year": 2023,
"quarter": "Q2",
"lca_count": 4,
"case_count": 4,
"role_title_count": 3,
"worksite_count": 3,
"wage_low_min": 120000,
"wage_high_max": 200000,
"wage_low_avg": 170000
},
{
"fiscal_year": 2023,
"quarter": "Q3",
"lca_count": 10,
"case_count": 10,
"role_title_count": 5,
"worksite_count": 5,
"wage_low_min": 100000,
"wage_high_max": 160000,
"wage_low_avg": 115000
},
{
"fiscal_year": 2023,
"quarter": "Q4",
"lca_count": 7,
"case_count": 7,
"role_title_count": 4,
"worksite_count": 2,
"wage_low_min": 84000,
"wage_high_max": 140000,
"wage_low_avg": 104175.285714286
},
{
"fiscal_year": 2024,
"quarter": "Q1",
"lca_count": 3,
"case_count": 3,
"role_title_count": 3,
"worksite_count": 3,
"wage_low_min": 103272,
"wage_high_max": 165000,
"wage_low_avg": 139424
},
{
"fiscal_year": 2024,
"quarter": "Q2",
"lca_count": 6,
"case_count": 6,
"role_title_count": 3,
"worksite_count": 4,
"wage_low_min": 106974,
"wage_high_max": 150000,
"wage_low_avg": 128495.666666667
},
{
"fiscal_year": 2024,
"quarter": "Q3",
"lca_count": 6,
"case_count": 6,
"role_title_count": 4,
"worksite_count": 5,
"wage_low_min": 82060,
"wage_high_max": 110000,
"wage_low_avg": 94749.6666666667
},
{
"fiscal_year": 2024,
"quarter": "Q4",
"lca_count": 1,
"case_count": 1,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 150000,
"wage_high_max": 150000,
"wage_low_avg": 150000
},
{
"fiscal_year": 2025,
"quarter": "Q1",
"lca_count": 4,
"case_count": 4,
"role_title_count": 4,
"worksite_count": 2,
"wage_low_min": 100000,
"wage_high_max": 150000,
"wage_low_avg": 130500
},
{
"fiscal_year": 2025,
"quarter": "Q2",
"lca_count": 4,
"case_count": 4,
"role_title_count": 2,
"worksite_count": 3,
"wage_low_min": 110000,
"wage_high_max": 160000,
"wage_low_avg": 137500
},
{
"fiscal_year": 2025,
"quarter": "Q3",
"lca_count": 10,
"case_count": 10,
"role_title_count": 4,
"worksite_count": 4,
"wage_low_min": 77605,
"wage_high_max": 150000,
"wage_low_avg": 109021.5
},
{
"fiscal_year": 2025,
"quarter": "Q4",
"lca_count": 1,
"case_count": 1,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 170000,
"wage_high_max": 170000,
"wage_low_avg": 170000
},
{
"fiscal_year": 2026,
"quarter": "Q2",
"lca_count": 5,
"case_count": 5,
"role_title_count": 4,
"worksite_count": 4,
"wage_low_min": 104000,
"wage_high_max": 240000,
"wage_low_avg": 161800
}
]Links
{
"roles": "/v1/roles?company=SPL%20Consulting%2C%20Inc.",
"wages": "/v1/wages?company=SPL%20Consulting%2C%20Inc.",
"trends": "/v1/trends?company=SPL%20Consulting%2C%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=spl+consulting+inc&limit=5JSON