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.
Full company payload
| Company ID | company:cable one |
| Name | CABLE ONE |
| Normalized Name | cable one |
| Source Company Ids | company_dol_oflc_lca_cable_one, company_uscis_h1b_datahub_cable_one_inc_dba_sparklight_tax_0083, company_uscis_h1b_datahub_cable_one_inc_tax_0083, company_uscis_h1b_datahub_cable_one_tax_0083 |
| Source Names | CABLE ONE, CABLE ONE INC DBA SPARKLIGHT, CABLE ONE INC |
| Aliases | CABLE ONE INC DBA SPARKLIGHT, CABLE ONE INC, CABLE ONE |
| Sources | dol_oflc_lca, uscis_h1b_employer_data_hub |
Names
{
"source_names": [
"CABLE ONE",
"CABLE ONE INC DBA SPARKLIGHT",
"CABLE ONE INC"
],
"dba_names": [],
"name_variants": [
{
"value": "CABLE ONE",
"filing_count": 4,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017,
"source": "dol_oflc_lca"
},
{
"value": "CABLE ONE INC DBA SPARKLIGHT",
"source": "uscis_h1b_employer_data_hub"
},
{
"value": "CABLE ONE INC",
"source": "uscis_h1b_employer_data_hub"
},
{
"value": "CABLE ONE",
"source": "uscis_h1b_employer_data_hub"
}
]
}Identifiers
[
{
"identifier_type": "tax_id_last_four",
"identifier_value": "0083",
"source": "uscis_h1b_employer_data_hub"
}
]LCA Activity
{
"lca_count": 4,
"case_count": 4,
"role_title_count": 4,
"worksite_count": 2,
"total_workers": 4,
"first_fiscal_year": 2016,
"first_received_date": "2015-11-16",
"latest_fiscal_year": 2017,
"latest_decision_date": "2017-02-27",
"certified_count": 4,
"denied_count": 0,
"status_breakdown": [
{
"value": "CERTIFIED",
"filing_count": 4,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017,
"source": "dol_oflc_lca"
}
],
"visa_class_breakdown": [
{
"value": "H-1B",
"filing_count": 4,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017,
"source": "dol_oflc_lca"
}
],
"full_time_position_breakdown": [
{
"value": "Y",
"filing_count": 2,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017,
"source": "dol_oflc_lca"
}
]
}Petition Activity
{
"initial_approval": 0,
"initial_denial": 0,
"continuing_approval": 0,
"continuing_denial": 0,
"total_approval": 17,
"total_denial": 0,
"fiscal_years": [
"2013",
"2016",
"2017",
"2019",
"2020",
"2022",
"2023"
],
"year_metrics": [
{
"cities": [
"Phoenix"
],
"states": [
"AZ"
],
"fiscal_year": 2020,
"naics_codes": [
"51"
],
"postal_codes": [
"85012"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 2,
"initial_approval": 0,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_cable_one_inc_dba_sparklight_tax_0083_2020",
"source_record_ids": [
"sr_uscis_h1b_datahub_2020_row_008105"
],
"continuing_approval": 2
},
{
"cities": [
"Phoenix"
],
"states": [
"AZ"
],
"fiscal_year": 2022,
"naics_codes": [
"51",
"99"
],
"postal_codes": [
"85012"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 4,
"initial_approval": 1,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_cable_one_inc_dba_sparklight_tax_0083_2022",
"source_record_ids": [
"sr_uscis_h1b_datahub_2022_row_008942",
"sr_uscis_h1b_datahub_2022_row_008943"
],
"continuing_approval": 3
},
{
"cities": [
"Phoenix"
],
"states": [
"AZ"
],
"fiscal_year": 2023,
"naics_codes": [
"51"
],
"postal_codes": [
"85012"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 2,
"initial_approval": 0,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_cable_one_inc_dba_sparklight_tax_0083_2023",
"source_record_ids": [
"sr_uscis_h1b_datahub_2023_row_004960"
],
"continuing_approval": 2
},
{
"cities": [
"Phoenix"
],
"states": [
"AZ"
],
"fiscal_year": 2016,
"naics_codes": [
"51"
],
"postal_codes": [
"85012"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 2,
"initial_approval": 0,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_cable_one_inc_tax_0083_2016",
"source_record_ids": [
"sr_uscis_h1b_datahub_2016_row_004413"
],
"continuing_approval": 2
},
{
"cities": [
"Phoenix"
],
"states": [
"AZ"
],
"fiscal_year": 2017,
"naics_codes": [
"51"
],
"postal_codes": [
"85012"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 1,
"initial_approval": 0,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_cable_one_inc_tax_0083_2017",
"source_record_ids": [
"sr_uscis_h1b_datahub_2017_row_003935"
],
"continuing_approval": 1
},
{
"cities": [
"Phoenix"
],
"states": [
"AZ"
],
"fiscal_year": 2019,
"naics_codes": [
"51"
],
"postal_codes": [
"85012"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 3,
"initial_approval": 1,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_cable_one_inc_tax_0083_2019",
"source_record_ids": [
"sr_uscis_h1b_datahub_2019_row_004306"
],
"continuing_approval": 2
},
{
"cities": [
"Phoenix"
],
"states": [
"AZ"
],
"fiscal_year": 2013,
"naics_codes": [
"51"
],
"postal_codes": [
"85004",
"85012"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 3,
"initial_approval": 2,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_cable_one_tax_0083_2013",
"source_record_ids": [
"sr_uscis_h1b_datahub_2013_row_005421",
"sr_uscis_h1b_datahub_2013_row_005422"
],
"continuing_approval": 1
}
]
}Addresses
{
"office_addresses": [
{
"address_kind": "office",
"raw_address": "PHOENIX AZ 85012",
"city": "Phoenix",
"state": "AZ",
"postal_code": "85012",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017,
"latest_decision_date": "2017-02-27",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "office",
"raw_address": "PHEONIX AZ 85012",
"city": "Pheonix",
"state": "AZ",
"postal_code": "85012",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017,
"latest_decision_date": "2017-02-08",
"source_ids": [
"dol_oflc_lca"
]
}
],
"worksite_addresses": [
{
"address_kind": "worksite",
"raw_address": "PHEONIX AZ 85012",
"city": "Pheonix",
"county": "Arizona",
"state": "AZ",
"postal_code": "85012",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017,
"latest_decision_date": "2017-02-27",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "PHOENIX AZ 85012",
"city": "Phoenix",
"county": "Maricopa",
"state": "AZ",
"postal_code": "85012",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016,
"latest_decision_date": "2016-03-10",
"source_ids": [
"dol_oflc_lca"
]
}
],
"summary": {
"office_address_count": 2,
"worksite_address_count": 2,
"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": [
"AZ"
],
"cities": [
"Pheonix",
"Phoenix"
],
"postal_codes": [
"85012",
"85004"
],
"top_markets": [
{
"city": "Pheonix",
"state": "AZ",
"postal_code": "85012",
"lca_count": 2,
"role_title_count": 2,
"wage_low_min": 95000,
"wage_high_max": 0,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017
},
{
"city": "Phoenix",
"state": "AZ",
"postal_code": "85012",
"lca_count": 2,
"role_title_count": 2,
"wage_low_min": 84000,
"wage_high_max": 120000,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016
}
]
}Industry
{
"naics_codes": [
"517510",
"51",
"99"
],
"naics_breakdown": [
{
"value": "517510",
"filing_count": 2,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017,
"source": "dol_oflc_lca"
}
]
}Wage Summary
{
"annualized_low_min": 84000,
"annualized_high_max": 120000,
"annualized_low_avg": 98500
}Trend
[
{
"fiscal_year": 2016,
"quarter": "Q2",
"lca_count": 2,
"case_count": 2,
"role_title_count": 2,
"worksite_count": 1,
"wage_low_min": 84000,
"wage_high_max": 120000,
"wage_low_avg": 102000
},
{
"fiscal_year": 2017,
"quarter": "Q2",
"lca_count": 2,
"case_count": 2,
"role_title_count": 2,
"worksite_count": 1,
"wage_low_min": 95000,
"wage_high_max": 0,
"wage_low_avg": 95000
}
]Links
{
"roles": "/v1/roles?company=CABLE%20ONE",
"wages": "/v1/wages?company=CABLE%20ONE",
"trends": "/v1/trends?company=CABLE%20ONE"
}