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:coca cola refreshments usa |
| Name | COCA-COLA REFRESHMENTS USA, INC. |
| Normalized Name | coca cola refreshments usa |
| Source Company Ids | company_dol_oflc_lca_coca_cola_refreshments_usa_inc |
| Source Names | COCA-COLA REFRESHMENTS USA, INC. |
| Aliases | - |
| Identifiers | - |
| Sources | dol_oflc_lca |
Names
{
"source_names": [
"COCA-COLA REFRESHMENTS USA, INC."
],
"dba_names": [],
"name_variants": [
{
"value": "COCA-COLA REFRESHMENTS USA, INC.",
"filing_count": 7,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017,
"source": "dol_oflc_lca"
}
]
}LCA Activity
{
"lca_count": 7,
"case_count": 7,
"role_title_count": 7,
"worksite_count": 4,
"total_workers": 7,
"first_fiscal_year": 2016,
"first_received_date": "2015-10-01",
"latest_fiscal_year": 2017,
"latest_decision_date": "2017-03-15",
"certified_count": 7,
"denied_count": 0,
"status_breakdown": [
{
"value": "CERTIFIED",
"filing_count": 7,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017,
"source": "dol_oflc_lca"
}
],
"visa_class_breakdown": [
{
"value": "H-1B",
"filing_count": 7,
"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": 0,
"total_denial": 0,
"fiscal_years": [],
"year_metrics": []
}Addresses
{
"office_addresses": [
{
"address_kind": "office",
"raw_address": "ATLANTA GA 30313",
"city": "Atlanta",
"state": "GA",
"postal_code": "30313",
"filing_count": 7,
"case_count": 7,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017,
"latest_decision_date": "2017-03-15",
"source_ids": [
"dol_oflc_lca"
]
}
],
"worksite_addresses": [
{
"address_kind": "worksite",
"raw_address": "ATLANTA GA 30308",
"city": "Atlanta",
"county": "Fulton",
"state": "GA",
"postal_code": "30308",
"filing_count": 4,
"case_count": 4,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017,
"latest_decision_date": "2016-10-11",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "IRVINE CA 92614",
"city": "Irvine",
"county": "Orange",
"state": "CA",
"postal_code": "92614",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017,
"latest_decision_date": "2017-03-15",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "DOWNEY CA 90241",
"city": "Downey",
"county": "Los Angeles",
"state": "CA",
"postal_code": "90241",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016,
"latest_decision_date": "2016-02-17",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ATLANTA GA 30339",
"city": "Atlanta",
"county": "Cobb",
"state": "GA",
"postal_code": "30339",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016,
"latest_decision_date": "2015-10-07",
"source_ids": [
"dol_oflc_lca"
]
}
],
"summary": {
"office_address_count": 1,
"worksite_address_count": 4,
"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": [
"GA",
"CA"
],
"cities": [
"Atlanta",
"Downey",
"Irvine"
],
"postal_codes": [
"30308",
"90241",
"92614",
"30339"
],
"top_markets": [
{
"city": "Atlanta",
"state": "GA",
"postal_code": "30308",
"lca_count": 4,
"role_title_count": 4,
"wage_low_min": 95400,
"wage_high_max": 134680,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017
},
{
"city": "Downey",
"state": "CA",
"postal_code": "90241",
"lca_count": 1,
"role_title_count": 1,
"wage_low_min": 56202,
"wage_high_max": 75010,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016
},
{
"city": "Irvine",
"state": "CA",
"postal_code": "92614",
"lca_count": 1,
"role_title_count": 1,
"wage_low_min": 65800,
"wage_high_max": 122200,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017
},
{
"city": "Atlanta",
"state": "GA",
"postal_code": "30339",
"lca_count": 1,
"role_title_count": 1,
"wage_low_min": 75338,
"wage_high_max": 0,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016
}
]
}Industry
{
"naics_codes": [
"312111"
],
"naics_breakdown": [
{
"value": "3121",
"filing_count": 1,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017,
"source": "dol_oflc_lca"
},
{
"value": "312111",
"filing_count": 1,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017,
"source": "dol_oflc_lca"
}
]
}Wage Summary
{
"annualized_low_min": 56202,
"annualized_high_max": 134680,
"annualized_low_avg": 93083.7142857143
}Trend
[
{
"fiscal_year": 2016,
"quarter": "Q2",
"lca_count": 5,
"case_count": 5,
"role_title_count": 5,
"worksite_count": 3,
"wage_low_min": 56202,
"wage_high_max": 75010,
"wage_low_avg": 98077.2
},
{
"fiscal_year": 2017,
"quarter": "Q2",
"lca_count": 2,
"case_count": 2,
"role_title_count": 2,
"worksite_count": 2,
"wage_low_min": 65800,
"wage_high_max": 134680,
"wage_low_avg": 80600
}
]Links
{
"roles": "/v1/roles?company=COCA-COLA%20REFRESHMENTS%20USA%2C%20INC.",
"wages": "/v1/wages?company=COCA-COLA%20REFRESHMENTS%20USA%2C%20INC.",
"trends": "/v1/trends?company=COCA-COLA%20REFRESHMENTS%20USA%2C%20INC."
}