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:bill and melinda gates foundation |
| Name | BILL AND MELINDA GATES FOUNDATION |
| Normalized Name | bill and melinda gates foundation |
| Source Company Ids | company_dol_oflc_lca_bill_and_melinda_gates_foundation |
| Source Names | BILL AND MELINDA GATES FOUNDATION |
| Aliases | - |
| Identifiers | - |
| Sources | dol_oflc_lca |
LCA Activity
{
"lca_count": 13,
"case_count": 13,
"role_title_count": 12,
"worksite_count": 3,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016,
"latest_decision_date": "2016-03-17",
"certified_count": 12,
"denied_count": 1
}Petition Activity
{
"total_approval": 0,
"total_denial": 0,
"fiscal_years": [],
"year_metrics": []
}Geography
{
"states": [
"WA",
"DC"
],
"cities": [
"Seattle",
"Washington"
],
"postal_codes": [
"98109",
"20005",
"98019"
],
"top_markets": [
{
"city": "Seattle",
"state": "WA",
"postal_code": "98109",
"lca_count": 11,
"role_title_count": 10,
"wage_low_min": 80000,
"wage_high_max": 345050,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016
},
{
"city": "Washington",
"state": "DC",
"postal_code": "20005",
"lca_count": 1,
"role_title_count": 1,
"wage_low_min": 121118,
"wage_high_max": 163909,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016
},
{
"city": "Seattle",
"state": "WA",
"postal_code": "98019",
"lca_count": 1,
"role_title_count": 1,
"wage_low_min": 124571,
"wage_high_max": 166669,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016
}
]
}Industry
{
"naics_codes": []
}Wage Summary
{
"annualized_low_min": 80000,
"annualized_high_max": 345050,
"annualized_low_avg": 123029.307692308
}Trend
[
{
"fiscal_year": 2016,
"quarter": "Q2",
"lca_count": 13,
"case_count": 13,
"role_title_count": 12,
"worksite_count": 3,
"wage_low_min": 80000,
"wage_high_max": 345050,
"wage_low_avg": 123029.307692308
}
]Links
{
"roles": "/v1/roles?company=BILL%20AND%20MELINDA%20GATES%20FOUNDATION",
"wages": "/v1/wages?company=BILL%20AND%20MELINDA%20GATES%20FOUNDATION",
"trends": "/v1/trends?company=BILL%20AND%20MELINDA%20GATES%20FOUNDATION"
}