Home / Companies / Spica Computers LLC
Spica Computers 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.
| Employer | LCA filings | Role titles | Worksites | Coverage | USCIS approvals | Top role | Sources | Open |
|---|---|---|---|---|---|---|---|---|
| Spica Computers LLC SPICA COMPUTERS LLC | 134 | 25 | 77 | FY2016 to FY2023 Latest decision 2023-04-12 | 75 | NETWORK SECURITY ENGINEER 15 filings | dol_oflc_lca, uscis_h1b_employer_data_hub | Profile |
Activity summary
| LCA filings | 134 |
| Certified LCAs | 129 |
| Denied LCAs | 0 |
| Role titles | 25 |
| Worksites | 77 |
| Latest decision | 2023-04-12 |
| USCIS approvals | 75 |
| USCIS denials | 9 |
Aliases and source names
| Aliases | Source Names | Sources |
|---|---|---|
| SPICA COMPUTERS LLC | Spica Computers LLC, SPICA COMPUTERS LLC | dol_oflc_lca, uscis_h1b_employer_data_hub |
Top roles
| Title | SOC | LCA filings | Low wage min | High wage max |
|---|---|---|---|---|
| NETWORK SECURITY ENGINEER | 15-1142 | 15 | $45,261 | $0 |
| SYSTEMS ENGINEER | 15-1199 COMPUTER OCCUPATIONS, ALL OTHER | 14 | $37,398 | $74,048 |
| NETWORK SECURITY ENGINEER | 15-1122 INFORMATION SECURITY ANALYSTS | 10 | $72,114 | $115,520 |
| Network Security Engineer | 15-1122.00 Information Security Analysts | 9 | $82,000 | $115,520 |
| SYSTEMS ENGINEER | 15-1132 | 8 | $52,166 | $0 |
| INFORMATION SECURITY ANALYST | 15-1122 INFORMATION SECURITY ANALYSTS | 7 | $63,274 | $83,970 |
| PROGRAMMER ANALYST | 15-1121 | 7 | $45,677 | $0 |
| Information Security Analyst | 15-1122.00 Information Security Analysts | 6 | $80,000 | $93,000 |
| PROGRAMMER ANALYST | 15-1132 | 5 | $65,083 | $0 |
| SYSTEMS ENGINEER | 15-1143 COMPUTER NETWORK ARCHITECTS | 4 | $73,258 | $96,886 |
Top markets
| City | State | Postal Code | LCA Count | Role Title Count | Wage Low Min | Wage High Max | First Fiscal Year | Latest Fiscal Year |
|---|---|---|---|---|---|---|---|---|
| New York | NY | 10001 | 6 | 2 | 53,165 | 0 | 2,016 | 2,017 |
| Concord | CA | 94520 | 5 | 1 | 101,483 | 0 | 2,018 | 2,018 |
| Louisville | KY | 40213 | 4 | 2 | 45,261 | 0 | 2,017 | 2,018 |
| Albany | NY | 12226 | 4 | 3 | 67,246 | 81,500 | 2,018 | 2,021 |
| Nashville | TN | 37238 | 4 | 2 | 37,398 | 82,080 | 2,017 | 2,020 |
| Fort Worth | TX | 76177 | 4 | 2 | 115,520 | 115,520 | 2,020 | 2,021 |
| Hartford | CT | 06120 | 3 | 1 | 66,664 | 0 | 2,016 | 2,017 |
| Orlando | FL | 32822 | 3 | 2 | 60,000 | 83,600 | 2,016 | 2,020 |
| Des Plaines | IL | 60016 | 3 | 1 | 77,000 | 77,000 | 2,022 | 2,022 |
| Melville | NY | 11747 | 3 | 1 | 60,216 | 0 | 2,017 | 2,017 |
Full company payload
| Company ID | company:spica computers |
| Name | Spica Computers LLC |
| Normalized Name | spica computers |
| Source Company Ids | company_dol_oflc_lca_spica_computers_llc, company_uscis_h1b_datahub_spica_computers_llc_tax_2321 |
| Source Names | Spica Computers LLC, SPICA COMPUTERS LLC |
| Aliases | SPICA COMPUTERS LLC |
| Sources | dol_oflc_lca, uscis_h1b_employer_data_hub |
Names
{
"source_names": [
"Spica Computers LLC",
"SPICA COMPUTERS LLC"
],
"dba_names": [],
"name_variants": [
{
"value": "Spica Computers LLC",
"filing_count": 46,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2023,
"source": "dol_oflc_lca"
},
{
"value": "SPICA COMPUTERS LLC.",
"filing_count": 45,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2018,
"source": "dol_oflc_lca"
},
{
"value": "SPICA COMPUTERS LLC",
"filing_count": 34,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2020,
"source": "dol_oflc_lca"
},
{
"value": "SPICA COMPUTERS, LLC",
"filing_count": 8,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2018,
"source": "dol_oflc_lca"
},
{
"value": "Spica Computers, LLC",
"filing_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"source": "dol_oflc_lca"
},
{
"value": "SPICA COMPUTERS LLC",
"source": "uscis_h1b_employer_data_hub"
}
]
}Identifiers
[
{
"identifier_type": "tax_id_last_four",
"identifier_value": "2321",
"source": "uscis_h1b_employer_data_hub"
}
]LCA Activity
{
"lca_count": 134,
"case_count": 134,
"role_title_count": 25,
"worksite_count": 77,
"total_workers": 134,
"first_fiscal_year": 2016,
"first_received_date": "2015-10-26",
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-04-12",
"certified_count": 129,
"denied_count": 0,
"status_breakdown": [
{
"value": "CERTIFIED",
"filing_count": 81,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2019,
"source": "dol_oflc_lca"
},
{
"value": "Certified",
"filing_count": 48,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2023,
"source": "dol_oflc_lca"
},
{
"value": "WITHDRAWN",
"filing_count": 5,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"source": "dol_oflc_lca"
}
],
"visa_class_breakdown": [
{
"value": "H-1B",
"filing_count": 134,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2023,
"source": "dol_oflc_lca"
}
],
"full_time_position_breakdown": [
{
"value": "Y",
"filing_count": 120,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2023,
"source": "dol_oflc_lca"
}
]
}Petition Activity
{
"initial_approval": 0,
"initial_denial": 0,
"continuing_approval": 0,
"continuing_denial": 0,
"total_approval": 75,
"total_denial": 9,
"fiscal_years": [
"2011",
"2012",
"2013",
"2014",
"2015",
"2016",
"2017",
"2018",
"2019",
"2020",
"2021",
"2022",
"2023"
],
"year_metrics": [
{
"cities": [
"Jersey City"
],
"states": [
"NJ"
],
"fiscal_year": 2011,
"naics_codes": [
"54"
],
"postal_codes": [
"07306"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 1,
"initial_approval": 1,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_spica_computers_llc_tax_2321_2011",
"source_record_ids": [
"sr_uscis_h1b_datahub_2011_row_016850"
],
"continuing_approval": 0
},
{
"cities": [
"Jersey City"
],
"states": [
"NJ"
],
"fiscal_year": 2012,
"naics_codes": [
"54"
],
"postal_codes": [
"07306"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 1,
"initial_approval": 1,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_spica_computers_llc_tax_2321_2012",
"source_record_ids": [
"sr_uscis_h1b_datahub_2012_row_014584"
],
"continuing_approval": 0
},
{
"cities": [
"Jersey City"
],
"states": [
"NJ"
],
"fiscal_year": 2013,
"naics_codes": [
"54"
],
"postal_codes": [
"07306"
],
"total_denial": 1,
"initial_denial": 0,
"total_approval": 0,
"initial_approval": 0,
"continuing_denial": 1,
"petition_count_id": "petition_count_uscis_h1b_archive_spica_computers_llc_tax_2321_2013",
"source_record_ids": [
"sr_uscis_h1b_datahub_2013_row_013512"
],
"continuing_approval": 0
},
{
"cities": [
"Jersey City"
],
"states": [
"NJ"
],
"fiscal_year": 2014,
"naics_codes": [
"54"
],
"postal_codes": [
"07306"
],
"total_denial": 1,
"initial_denial": 1,
"total_approval": 5,
"initial_approval": 5,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_spica_computers_llc_tax_2321_2014",
"source_record_ids": [
"sr_uscis_h1b_datahub_2014_row_013230"
],
"continuing_approval": 0
},
{
"cities": [
"Jersey City"
],
"states": [
"NJ"
],
"fiscal_year": 2015,
"naics_codes": [
"54"
],
"postal_codes": [
"07306"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 4,
"initial_approval": 4,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_spica_computers_llc_tax_2321_2015",
"source_record_ids": [
"sr_uscis_h1b_datahub_2015_row_010580"
],
"continuing_approval": 0
},
{
"cities": [
"Jersey City"
],
"states": [
"NJ"
],
"fiscal_year": 2016,
"naics_codes": [
"54"
],
"postal_codes": [
"07306"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 4,
"initial_approval": 3,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_spica_computers_llc_tax_2321_2016",
"source_record_ids": [
"sr_uscis_h1b_datahub_2016_row_011055"
],
"continuing_approval": 1
},
{
"cities": [
"Jersey City"
],
"states": [
"NJ"
],
"fiscal_year": 2017,
"naics_codes": [
"54"
],
"postal_codes": [
"07306"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 5,
"initial_approval": 1,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_spica_computers_llc_tax_2321_2017",
"source_record_ids": [
"sr_uscis_h1b_datahub_2017_row_009800"
],
"continuing_approval": 4
},
{
"cities": [
"Jersey City"
],
"states": [
"NJ"
],
"fiscal_year": 2018,
"naics_codes": [
"54"
],
"postal_codes": [
"07306"
],
"total_denial": 2,
"initial_denial": 1,
"total_approval": 6,
"initial_approval": 2,
"continuing_denial": 1,
"petition_count_id": "petition_count_uscis_h1b_archive_spica_computers_llc_tax_2321_2018",
"source_record_ids": [
"sr_uscis_h1b_datahub_2018_row_010380"
],
"continuing_approval": 4
},
{
"cities": [
"Jersey City"
],
"states": [
"NJ"
],
"fiscal_year": 2019,
"naics_codes": [
"54"
],
"postal_codes": [
"07306"
],
"total_denial": 3,
"initial_denial": 3,
"total_approval": 8,
"initial_approval": 5,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_spica_computers_llc_tax_2321_2019",
"source_record_ids": [
"sr_uscis_h1b_datahub_2019_row_010414"
],
"continuing_approval": 3
},
{
"cities": [
"Jersey City"
],
"states": [
"NJ"
],
"fiscal_year": 2020,
"naics_codes": [
"54"
],
"postal_codes": [
"07306"
],
"total_denial": 2,
"initial_denial": 2,
"total_approval": 13,
"initial_approval": 7,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_spica_computers_llc_tax_2321_2020",
"source_record_ids": [
"sr_uscis_h1b_datahub_2020_row_044970"
],
"continuing_approval": 6
},
{
"cities": [
"Jersey City"
],
"states": [
"NJ"
],
"fiscal_year": 2021,
"naics_codes": [
"54"
],
"postal_codes": [
"07306",
"7306"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 18,
"initial_approval": 16,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_spica_computers_llc_tax_2321_2021",
"source_record_ids": [
"sr_uscis_h1b_datahub_2021_row_049058",
"sr_uscis_h1b_datahub_2021_row_049059"
],
"continuing_approval": 2
},
{
"cities": [
"Jersey City"
],
"states": [
"NJ"
],
"fiscal_year": 2022,
"naics_codes": [
"54"
],
"postal_codes": [
"07306"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 7,
"initial_approval": 5,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_spica_computers_llc_tax_2321_2022",
"source_record_ids": [
"sr_uscis_h1b_datahub_2022_row_048632"
],
"continuing_approval": 2
},
{
"cities": [
"Jersey City"
],
"states": [
"NJ"
],
"fiscal_year": 2023,
"naics_codes": [
"54"
],
"postal_codes": [
"07306"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 3,
"initial_approval": 0,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_spica_computers_llc_tax_2321_2023",
"source_record_ids": [
"sr_uscis_h1b_datahub_2023_row_026825"
],
"continuing_approval": 3
}
]
}Addresses
{
"office_addresses": [
{
"address_kind": "office",
"raw_address": "JERSEY CITY NJ 07306",
"city": "Jersey City",
"state": "NJ",
"postal_code": "07306",
"filing_count": 71,
"case_count": 71,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-04-12",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "office",
"raw_address": "JERSEY CITY NJ 7306",
"city": "Jersey City",
"state": "NJ",
"postal_code": "7306",
"filing_count": 63,
"case_count": 63,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2022,
"latest_decision_date": "2022-09-30",
"source_ids": [
"dol_oflc_lca"
]
}
],
"worksite_addresses": [
{
"address_kind": "worksite",
"raw_address": "NEW YORK NY 10036",
"city": "New York",
"county": "New York",
"state": "NY",
"postal_code": "10036",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-04-12",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "DES PLAINES IL 60016",
"city": "Des Plaines",
"county": "Cook",
"state": "IL",
"postal_code": "60016",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2022,
"latest_decision_date": "2021-12-28",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "MILFORD CT 6461",
"city": "Milford",
"county": "Milford City",
"state": "CT",
"postal_code": "6461",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2022,
"latest_decision_date": "2022-02-01",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "WESLEY CHAPEL FL 33544",
"city": "Wesley Chapel",
"county": "Pasco",
"state": "FL",
"postal_code": "33544",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2022,
"latest_decision_date": "2022-09-30",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "DALLAS TX 75202",
"city": "Dallas",
"county": "Dallas",
"state": "TX",
"postal_code": "75202",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2022,
"latest_decision_date": "2022-09-29",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "COPPELL TX 75019",
"city": "Coppell",
"county": "Dallas",
"state": "TX",
"postal_code": "75019",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2022,
"latest_decision_date": "2022-03-23",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ROYERSFORD PA 19468",
"city": "Royersford",
"county": "Montgomery",
"state": "PA",
"postal_code": "19468",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2022,
"latest_decision_date": "2022-01-03",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ALBANY NY 12226",
"city": "Albany",
"county": "Albany",
"state": "NY",
"postal_code": "12226",
"filing_count": 4,
"case_count": 4,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-09-30",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "FORT WORTH TX 76177",
"city": "Fort Worth",
"county": "Tarrant",
"state": "TX",
"postal_code": "76177",
"filing_count": 4,
"case_count": 4,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2021,
"latest_decision_date": "2020-10-15",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "MANASSAS VA 20109",
"city": "Manassas",
"county": "Prince William",
"state": "VA",
"postal_code": "20109",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-05-14",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "SAN ANTONIO TX 78288",
"city": "San Antonio",
"county": "Bexar",
"state": "TX",
"postal_code": "78288",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2020-11-12",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "EAST PEORIA IL 61611",
"city": "East Peoria",
"county": "Tazewell",
"state": "IL",
"postal_code": "61611",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-05-14",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "EAST HARTFORD CT 6108",
"city": "East Hartford",
"county": "Hartford City",
"state": "CT",
"postal_code": "6108",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-05-14",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "WESTBOROUGH MA 1581",
"city": "Westborough",
"county": "Westborough",
"state": "MA",
"postal_code": "1581",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2020-10-30",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "JERSEY CITY NJ 7307",
"city": "Jersey City",
"county": "Hudson",
"state": "NJ",
"postal_code": "7307",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-08-26",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ATLANTA GA 30308",
"city": "Atlanta",
"county": "Fulton",
"state": "GA",
"postal_code": "30308",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-06-23",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "PINE BROOK NJ 7058",
"city": "Pine Brook",
"county": "Morris",
"state": "NJ",
"postal_code": "7058",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-05-26",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "WESTBOROUGH MA 01581",
"city": "Westborough",
"county": "Westborough",
"state": "MA",
"postal_code": "01581",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2020-10-30",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "NASHVILLE TN 37238",
"city": "Nashville",
"county": "Davidson",
"state": "TN",
"postal_code": "37238",
"filing_count": 4,
"case_count": 4,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-06-26",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CINCINNATI OH 45246",
"city": "Cincinnati",
"county": "Hamilton",
"state": "OH",
"postal_code": "45246",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-06-09",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ORLANDO FL 32822",
"city": "Orlando",
"county": "Orange",
"state": "FL",
"postal_code": "32822",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-05-26",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "AUSTIN TX 78741",
"city": "Austin",
"county": "Travis",
"state": "TX",
"postal_code": "78741",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-04-23",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "BAY LAKE FL 32830",
"city": "Bay Lake",
"county": "Orange",
"state": "FL",
"postal_code": "32830",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-05-26",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "BROOKLYN NY 11201",
"city": "Brooklyn",
"county": "Kings",
"state": "NY",
"postal_code": "11201",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-07-02",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "LA VISTA NE 68128",
"city": "La Vista",
"county": "Sarpy",
"state": "NE",
"postal_code": "68128",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-06-23",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "EDINA MN 55435",
"city": "Edina",
"county": "Hennepin",
"state": "MN",
"postal_code": "55435",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-06-22",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "PLANO TX 75024",
"city": "Plano",
"county": "Collin",
"state": "TX",
"postal_code": "75024",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-06-03",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CHELSEA MA 2150",
"city": "Chelsea",
"county": "Chelsea City",
"state": "MA",
"postal_code": "2150",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-05-26",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "BRIDGEWATER NJ 8807",
"city": "Bridgewater",
"county": "Somerset",
"state": "NJ",
"postal_code": "8807",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-05-22",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "BROOKLYN NY 11219",
"city": "Brooklyn",
"county": "Kings",
"state": "NY",
"postal_code": "11219",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-03-12",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "BROOKLYN NY 11201",
"city": "Brooklyn",
"county": "Kings County",
"state": "NY",
"postal_code": "11201",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2019-10-03",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "SYRACUSE NY 13202",
"city": "Syracuse",
"county": "Onondaga",
"state": "NY",
"postal_code": "13202",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-07-05",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "DENVER CO 80202",
"city": "Denver",
"county": "Denver",
"state": "CO",
"postal_code": "80202",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-03-28",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "PHOENIX AZ 85044",
"city": "Phoenix",
"county": "Maricopa",
"state": "AZ",
"postal_code": "85044",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-04-08",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "WEST LAFAYETTE IN 47906",
"city": "West Lafayette",
"county": "Tippecanoe",
"state": "IN",
"postal_code": "47906",
"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": "DETROIT MI 48226",
"city": "Detroit",
"county": "Wayne",
"state": "MI",
"postal_code": "48226",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-03-19",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "MIDDLETOWN NJ 7748",
"city": "Middletown",
"county": "Monmouth",
"state": "NJ",
"postal_code": "7748",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-03-14",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "SAN JOSE CA 95134",
"city": "San Jose",
"county": "Santa Clara",
"state": "CA",
"postal_code": "95134",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-03-13",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "FARMINGTON MI 48335",
"city": "Farmington",
"county": "Oakland",
"state": "MI",
"postal_code": "48335",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-03-12",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "AUDUBON PA 19403",
"city": "Audubon",
"county": "Montgomery",
"state": "PA",
"postal_code": "19403",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-03-12",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "LAFAYETTE IN 47907",
"city": "Lafayette",
"county": "Tippecanoe",
"state": "IN",
"postal_code": "47907",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-03-12",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "NORRISTOWN PA 19428",
"city": "Norristown",
"county": "Montgomery",
"state": "PA",
"postal_code": "19428",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-03-12",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "KNOXVILLE TN 37916",
"city": "Knoxville",
"county": "Knox",
"state": "TN",
"postal_code": "37916",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-03-11",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "BROOMFIELD CO 80021",
"city": "Broomfield",
"county": "Broomfield",
"state": "CO",
"postal_code": "80021",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-03-11",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "NEW YORK NY 10019",
"city": "New York",
"county": "New York",
"state": "NY",
"postal_code": "10019",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-03-09",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "GLEN ALLEN VA 23060",
"city": "Glen Allen",
"county": "Henrico",
"state": "VA",
"postal_code": "23060",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-03-07",
"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-03-06",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CHELSEA MA 2150",
"city": "Chelsea",
"county": "Suffolk",
"state": "MA",
"postal_code": "2150",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-03-06",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CONCORD CA 94520",
"city": "Concord",
"county": "Contra Costa County",
"state": "CA",
"postal_code": "94520",
"filing_count": 4,
"case_count": 4,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-07-10",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "LOUISVILLE KY 40213",
"city": "Louisville",
"county": "Jefferson",
"state": "KY",
"postal_code": "40213",
"filing_count": 4,
"case_count": 4,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-03-20",
"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": [
"NY",
"CA",
"KY",
"TN",
"TX",
"CT",
"FL",
"IL",
"OH",
"VA",
"CO",
"DE",
"MA",
"MI",
"NJ",
"PA",
"AZ",
"GA",
"IN",
"MN",
"MO",
"NC",
"NE",
"WA"
],
"cities": [
"New York",
"Concord",
"Louisville",
"Albany",
"Nashville",
"Fort Worth",
"Hartford",
"Orlando",
"Des Plaines",
"Melville",
"Cincinnati",
"Austin",
"San Antonio",
"Manassas",
"Denver",
"East Hartford",
"Milford",
"Wilmington",
"Bay Lake",
"Tampa",
"Chicago",
"East Peoria",
"Chelsea",
"Westborough",
"Holland",
"East Newark",
"Livingston",
"South Plainfield",
"Weehawken",
"Brooklyn",
"Syracuse",
"West Chester",
"Dallas",
"Irving",
"Phoenix",
"Bakersfield",
"San Diego",
"San Jose",
"Walnut Creek",
"Broomfield",
"Stamford",
"Jacksonville",
"Wesley Chapel",
"Alpharetta",
"Atlanta",
"Waukegan",
"Lafayette",
"West Lafayette",
"Lowell",
"Detroit",
"Farmington",
"Edina",
"Kansas City",
"Durham",
"La Vista",
"Bridgewater",
"Jersey City",
"Middletown",
"Pine Brook",
"Audubon",
"Harrisburg",
"Norristown",
"Royersford",
"Knoxville",
"Coppell",
"Plano",
"Ashburn",
"Glen Allen",
"Renton"
],
"postal_codes": [
"10001",
"94520",
"40213",
"12226",
"37238",
"76177",
"06120",
"32822",
"60016",
"11747",
"45246",
"78741",
"78288",
"20109",
"80202",
"6108",
"6461",
"19809",
"32830",
"33607",
"60606",
"61611",
"2150",
"1581",
"49423",
"07105",
"07039",
"07080",
"07086",
"11201",
"13202",
"19380",
"75201",
"75039",
"85044",
"93308",
"92121",
"95113",
"95134",
"94596",
"80021",
"06902",
"32256",
"33544",
"30005",
"30308",
"60612",
"60631",
"60085",
"47907",
"47906",
"01851",
"01581",
"48226",
"48335",
"55435",
"64137",
"27707",
"68128",
"8807",
"7307",
"7748",
"7058",
"11219",
"10019",
"10036",
"19403",
"17121",
"19428",
"19468",
"37916",
"75019",
"75202",
"75024",
"20147",
"23060",
"98057",
"07306",
"7306"
],
"top_markets": [
{
"city": "New York",
"state": "NY",
"postal_code": "10001",
"lca_count": 6,
"role_title_count": 2,
"wage_low_min": 53165,
"wage_high_max": 0,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017
},
{
"city": "Concord",
"state": "CA",
"postal_code": "94520",
"lca_count": 5,
"role_title_count": 1,
"wage_low_min": 101483,
"wage_high_max": 0,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018
},
{
"city": "Louisville",
"state": "KY",
"postal_code": "40213",
"lca_count": 4,
"role_title_count": 2,
"wage_low_min": 45261,
"wage_high_max": 0,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2018
},
{
"city": "Albany",
"state": "NY",
"postal_code": "12226",
"lca_count": 4,
"role_title_count": 3,
"wage_low_min": 67246,
"wage_high_max": 81500,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2021
},
{
"city": "Nashville",
"state": "TN",
"postal_code": "37238",
"lca_count": 4,
"role_title_count": 2,
"wage_low_min": 37398,
"wage_high_max": 82080,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2020
},
{
"city": "Fort Worth",
"state": "TX",
"postal_code": "76177",
"lca_count": 4,
"role_title_count": 2,
"wage_low_min": 115520,
"wage_high_max": 115520,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2021
},
{
"city": "Hartford",
"state": "CT",
"postal_code": "06120",
"lca_count": 3,
"role_title_count": 1,
"wage_low_min": 66664,
"wage_high_max": 0,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017
},
{
"city": "Orlando",
"state": "FL",
"postal_code": "32822",
"lca_count": 3,
"role_title_count": 2,
"wage_low_min": 60000,
"wage_high_max": 83600,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2020
},
{
"city": "Des Plaines",
"state": "IL",
"postal_code": "60016",
"lca_count": 3,
"role_title_count": 1,
"wage_low_min": 77000,
"wage_high_max": 77000,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2022
},
{
"city": "Melville",
"state": "NY",
"postal_code": "11747",
"lca_count": 3,
"role_title_count": 1,
"wage_low_min": 60216,
"wage_high_max": 0,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017
}
]
}Industry
{
"naics_codes": [
"541511",
"54"
],
"naics_breakdown": [
{
"value": "541511",
"filing_count": 81,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2023,
"source": "dol_oflc_lca"
},
{
"value": "54151",
"filing_count": 39,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2022,
"source": "dol_oflc_lca"
}
]
}Wage Summary
{
"annualized_low_min": 37398,
"annualized_high_max": 129000,
"annualized_low_avg": 79864.7313432836
}Trend
[
{
"fiscal_year": 2016,
"quarter": "Q2",
"lca_count": 14,
"case_count": 14,
"role_title_count": 3,
"worksite_count": 12,
"wage_low_min": 60000,
"wage_high_max": 0,
"wage_low_avg": 63917.4285714286
},
{
"fiscal_year": 2017,
"quarter": "Q2",
"lca_count": 31,
"case_count": 31,
"role_title_count": 3,
"worksite_count": 18,
"wage_low_min": 37398,
"wage_high_max": 0,
"wage_low_avg": 58400.1612903226
},
{
"fiscal_year": 2018,
"quarter": "Q2",
"lca_count": 20,
"case_count": 20,
"role_title_count": 11,
"worksite_count": 13,
"wage_low_min": 63274,
"wage_high_max": 0,
"wage_low_avg": 86985.55
},
{
"fiscal_year": 2019,
"quarter": "Q2",
"lca_count": 21,
"case_count": 21,
"role_title_count": 10,
"worksite_count": 19,
"wage_low_min": 68411,
"wage_high_max": 96886,
"wage_low_avg": 82891
},
{
"fiscal_year": 2020,
"quarter": "Q1",
"lca_count": 1,
"case_count": 1,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 102669,
"wage_high_max": 102669,
"wage_low_avg": 102669
},
{
"fiscal_year": 2020,
"quarter": "Q2",
"lca_count": 1,
"case_count": 1,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 119040,
"wage_high_max": 119040,
"wage_low_avg": 119040
},
{
"fiscal_year": 2020,
"quarter": "Q3",
"lca_count": 14,
"case_count": 14,
"role_title_count": 6,
"worksite_count": 10,
"wage_low_min": 81536,
"wage_high_max": 129000,
"wage_low_avg": 97937.2142857143
},
{
"fiscal_year": 2020,
"quarter": "Q4",
"lca_count": 2,
"case_count": 2,
"role_title_count": 2,
"worksite_count": 2,
"wage_low_min": 77750,
"wage_high_max": 115520,
"wage_low_avg": 96635
},
{
"fiscal_year": 2021,
"quarter": "Q1",
"lca_count": 3,
"case_count": 3,
"role_title_count": 1,
"worksite_count": 3,
"wage_low_min": 92310,
"wage_high_max": 115520,
"wage_low_avg": 103943.333333333
},
{
"fiscal_year": 2021,
"quarter": "Q2",
"lca_count": 3,
"case_count": 3,
"role_title_count": 1,
"worksite_count": 3,
"wage_low_min": 92310,
"wage_high_max": 115520,
"wage_low_avg": 103943.333333333
},
{
"fiscal_year": 2021,
"quarter": "Q3",
"lca_count": 11,
"case_count": 11,
"role_title_count": 3,
"worksite_count": 8,
"wage_low_min": 73000,
"wage_high_max": 115520,
"wage_low_avg": 88638
},
{
"fiscal_year": 2021,
"quarter": "Q4",
"lca_count": 3,
"case_count": 3,
"role_title_count": 2,
"worksite_count": 2,
"wage_low_min": 81500,
"wage_high_max": 106163,
"wage_low_avg": 89721
},
{
"fiscal_year": 2022,
"quarter": "Q1",
"lca_count": 4,
"case_count": 4,
"role_title_count": 2,
"worksite_count": 2,
"wage_low_min": 77000,
"wage_high_max": 100776,
"wage_low_avg": 82944
},
{
"fiscal_year": 2022,
"quarter": "Q2",
"lca_count": 3,
"case_count": 3,
"role_title_count": 3,
"worksite_count": 3,
"wage_low_min": 75296,
"wage_high_max": 99112,
"wage_low_avg": 89136
},
{
"fiscal_year": 2022,
"quarter": "Q4",
"lca_count": 2,
"case_count": 2,
"role_title_count": 2,
"worksite_count": 2,
"wage_low_min": 72966,
"wage_high_max": 80829,
"wage_low_avg": 76897.5
},
{
"fiscal_year": 2023,
"quarter": "Q3",
"lca_count": 1,
"case_count": 1,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 109283,
"wage_high_max": 109283,
"wage_low_avg": 109283
}
]Links
{
"roles": "/v1/roles?company=Spica%20Computers%20LLC",
"wages": "/v1/wages?company=Spica%20Computers%20LLC",
"trends": "/v1/trends?company=Spica%20Computers%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=spica+computers+llc&limit=5JSON