Home / Companies / PUBLIC PARTNERSHIPS LLC
PUBLIC PARTNERSHIPS 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 |
|---|---|---|---|---|---|---|---|---|
| PUBLIC PARTNERSHIPS LLC PUBLIC PARTNERSHIPS LLC | 103 | 54 | 61 | FY2019 to FY2026 Latest decision 2026-03-31 | 40 | Software Engineer 3 7 filings | dol_oflc_lca, uscis_h1b_employer_data_hub | Profile |
Activity summary
| LCA filings | 103 |
| Certified LCAs | 103 |
| Denied LCAs | 0 |
| Role titles | 54 |
| Worksites | 61 |
| Latest decision | 2026-03-31 |
| USCIS approvals | 40 |
| USCIS denials | 0 |
Aliases and source names
| Aliases | Source Names | Sources |
|---|---|---|
| PUBLIC PARTNERSHIPS LLC | PUBLIC PARTNERSHIPS LLC | dol_oflc_lca, uscis_h1b_employer_data_hub |
Top roles
| Title | SOC | LCA filings | Low wage min | High wage max |
|---|---|---|---|---|
| Software Engineer 3 | 15-1252.00 Software Developers | 7 | $105,435 | $152,755 |
| Sr. Data Analyst | 15-1211.00 Computer Systems Analysts | 5 | $95,000 | $110,000 |
| Sr. Software Engineer | 15-1132.00 Software Developers, Applications | 5 | $118,635 | $140,203 |
| Data Analyst 1 | 15-1211.00 Computer Systems Analysts | 3 | $69,188 | $90,000 |
| Lead Software Engineer | 15-1132.00 Software Developers, Applications | 3 | $119,933 | $141,137 |
| Sr Data Analyst | 15-1211.00 Computer Systems Analysts | 3 | $103,022 | $106,434 |
| Azure DevOps Engineer 3 | 15-1252.00 Software Developers | 2 | $132,000 | $145,000 |
| BI Developer | 15-2051.01 Business Intelligence Analysts | 2 | $102,000 | $102,000 |
| Cloud Engineer 3 | 15-1299.08 Computer Systems Engineers/Architects | 2 | $144,000 | $144,000 |
| IT Database Analyst II | 15-1242.00 Database Administrators | 2 | $86,603 | $86,603 |
Top markets
| City | State | Postal Code | LCA Count | Role Title Count | Wage Low Min | Wage High Max | First Fiscal Year | Latest Fiscal Year |
|---|---|---|---|---|---|---|---|---|
| Boston | MA | 2109 | 13 | 9 | 54,642 | 150,000 | 2,019 | 2,021 |
| Boston | MA | 2135 | 4 | 3 | 75,774 | 115,000 | 2,022 | 2,022 |
| Boston | MA | 02113 | 3 | 1 | 103,022 | 106,434 | 2,025 | 2,025 |
| Medford | MA | 2155 | 3 | 2 | 55,000 | 64,168 | 2,019 | 2,019 |
| Frisco | TX | 75036 | 3 | 2 | 120,328 | 150,000 | 2,022 | 2,026 |
| Tumwater | WA | 98501 | 3 | 2 | 91,486 | 105,435 | 2,022 | 2,025 |
| Attleboro | MA | 02703 | 2 | 2 | 63,036 | 72,010 | 2,023 | 2,024 |
| Boston | MA | 02109 | 2 | 2 | 125,000 | 140,203 | 2,020 | 2,021 |
| Boston | MA | 02115 | 2 | 1 | 95,000 | 95,000 | 2,023 | 2,023 |
| Boston | MA | 02134 | 2 | 2 | 118,450 | 135,000 | 2,023 | 2,023 |
Full company payload
| Company ID | company:public partnerships |
| Name | PUBLIC PARTNERSHIPS LLC |
| Normalized Name | public partnerships |
| Source Company Ids | company_dol_oflc_lca_public_partnerships_llc, company_uscis_h1b_datahub_public_partnerships_llc_tax_8852 |
| Source Names | PUBLIC PARTNERSHIPS LLC |
| Aliases | PUBLIC PARTNERSHIPS LLC |
| Sources | dol_oflc_lca, uscis_h1b_employer_data_hub |
Names
{
"source_names": [
"PUBLIC PARTNERSHIPS LLC"
],
"dba_names": [],
"name_variants": [
{
"value": "PUBLIC PARTNERSHIPS LLC",
"filing_count": 103,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2026,
"source": "dol_oflc_lca"
},
{
"value": "PUBLIC PARTNERSHIPS LLC",
"source": "uscis_h1b_employer_data_hub"
}
]
}Identifiers
[
{
"identifier_type": "tax_id_last_four",
"identifier_value": "8852",
"source": "uscis_h1b_employer_data_hub"
}
]LCA Activity
{
"lca_count": 103,
"case_count": 103,
"role_title_count": 54,
"worksite_count": 61,
"total_workers": 103,
"first_fiscal_year": 2019,
"first_received_date": "2018-10-01",
"latest_fiscal_year": 2026,
"latest_decision_date": "2026-03-31",
"certified_count": 103,
"denied_count": 0,
"status_breakdown": [
{
"value": "Certified",
"filing_count": 89,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2026,
"source": "dol_oflc_lca"
},
{
"value": "CERTIFIED",
"filing_count": 14,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"source": "dol_oflc_lca"
}
],
"visa_class_breakdown": [
{
"value": "H-1B",
"filing_count": 103,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2026,
"source": "dol_oflc_lca"
}
],
"full_time_position_breakdown": [
{
"value": "Y",
"filing_count": 103,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2026,
"source": "dol_oflc_lca"
}
]
}Petition Activity
{
"initial_approval": 0,
"initial_denial": 0,
"continuing_approval": 0,
"continuing_denial": 0,
"total_approval": 40,
"total_denial": 0,
"fiscal_years": [
"2019",
"2020",
"2021",
"2022",
"2023"
],
"year_metrics": [
{
"cities": [
"Boston"
],
"states": [
"MA"
],
"fiscal_year": 2019,
"naics_codes": [
"54"
],
"postal_codes": [
"02109"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 9,
"initial_approval": 5,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_public_partnerships_llc_tax_8852_2019",
"source_record_ids": [
"sr_uscis_h1b_datahub_2019_row_001823"
],
"continuing_approval": 4
},
{
"cities": [
"Boston"
],
"states": [
"MA"
],
"fiscal_year": 2020,
"naics_codes": [
"54"
],
"postal_codes": [
"02109"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 4,
"initial_approval": 1,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_public_partnerships_llc_tax_8852_2020",
"source_record_ids": [
"sr_uscis_h1b_datahub_2020_row_038956"
],
"continuing_approval": 3
},
{
"cities": [
"Boston"
],
"states": [
"MA"
],
"fiscal_year": 2021,
"naics_codes": [
"54"
],
"postal_codes": [
"02109",
"2109"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 13,
"initial_approval": 1,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_public_partnerships_llc_tax_8852_2021",
"source_record_ids": [
"sr_uscis_h1b_datahub_2021_row_042171",
"sr_uscis_h1b_datahub_2021_row_042172"
],
"continuing_approval": 12
},
{
"cities": [
"Boston"
],
"states": [
"MA"
],
"fiscal_year": 2022,
"naics_codes": [
"54"
],
"postal_codes": [
"02109"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 10,
"initial_approval": 0,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_public_partnerships_llc_tax_8852_2022",
"source_record_ids": [
"sr_uscis_h1b_datahub_2022_row_042114"
],
"continuing_approval": 10
},
{
"cities": [
"Boston"
],
"states": [
"MA"
],
"fiscal_year": 2023,
"naics_codes": [
"54"
],
"postal_codes": [
"02109"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 4,
"initial_approval": 0,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_public_partnerships_llc_tax_8852_2023",
"source_record_ids": [
"sr_uscis_h1b_datahub_2023_row_023131"
],
"continuing_approval": 4
}
]
}Addresses
{
"office_addresses": [
{
"address_kind": "office",
"address_line_1": "17 Plaza Dr., Ste 300",
"raw_address": "17 Plaza Dr., Ste 300 LATHAM NY 12210",
"city": "Latham",
"state": "NY",
"postal_code": "12210",
"filing_count": 6,
"case_count": 6,
"first_fiscal_year": 2026,
"latest_fiscal_year": 2026,
"latest_decision_date": "2026-03-31",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "office",
"raw_address": "ALPHARETTA GA 30009",
"city": "Alpharetta",
"state": "GA",
"postal_code": "30009",
"filing_count": 33,
"case_count": 33,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-06-05",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "office",
"raw_address": "LATHAM NY 12210",
"city": "Latham",
"state": "NY",
"postal_code": "12210",
"filing_count": 4,
"case_count": 4,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-09-08",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "office",
"raw_address": "BOSTON MA 02109",
"city": "Boston",
"state": "MA",
"postal_code": "02109",
"filing_count": 25,
"case_count": 25,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-09-08",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "office",
"raw_address": "BOSTON MA 2109",
"city": "Boston",
"state": "MA",
"postal_code": "2109",
"filing_count": 35,
"case_count": 35,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2022,
"latest_decision_date": "2022-07-22",
"source_ids": [
"dol_oflc_lca"
]
}
],
"worksite_addresses": [
{
"address_kind": "worksite",
"address_line_1": "530 Washington Street, Apt 19",
"raw_address": "530 Washington Street, Apt 19 BOSTON MA 02135",
"city": "Boston",
"state": "MA",
"postal_code": "02135",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2026,
"latest_fiscal_year": 2026,
"latest_decision_date": "2026-03-31",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"address_line_1": "11123 Heartleaf Aster Way",
"raw_address": "11123 Heartleaf Aster Way CYPRESS TX 77433",
"city": "Cypress",
"state": "TX",
"postal_code": "77433",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2026,
"latest_fiscal_year": 2026,
"latest_decision_date": "2026-03-30",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"address_line_1": "17638 Harper’s Way",
"raw_address": "17638 Harper’s Way CONROE TX 77385",
"city": "Conroe",
"state": "TX",
"postal_code": "77385",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2026,
"latest_fiscal_year": 2026,
"latest_decision_date": "2026-03-30",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"address_line_1": "1617 Spanish Bay Court",
"raw_address": "1617 Spanish Bay Court FRISCO TX 75036",
"city": "Frisco",
"state": "TX",
"postal_code": "75036",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2026,
"latest_fiscal_year": 2026,
"latest_decision_date": "2026-03-19",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"address_line_1": "1527 Laggan Lane",
"raw_address": "1527 Laggan Lane INDIAN TRAIL NC 28079",
"city": "Indian Trail",
"state": "NC",
"postal_code": "28079",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2026,
"latest_fiscal_year": 2026,
"latest_decision_date": "2026-02-10",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"address_line_1": "4 Winslow Ln. Unit 409",
"raw_address": "4 Winslow Ln. Unit 409 NORTH GRAFTON MA 01536",
"city": "North Grafton",
"state": "MA",
"postal_code": "01536",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2026,
"latest_fiscal_year": 2026,
"latest_decision_date": "2025-12-22",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "TUMWATER WA 98501",
"city": "Tumwater",
"county": "Thurston",
"state": "WA",
"postal_code": "98501",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-04-25",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "BOSTON MA 02113",
"city": "Boston",
"state": "MA",
"postal_code": "02113",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-09-08",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "VINEYARD UT 84059",
"city": "Vineyard",
"county": "Utah",
"state": "UT",
"postal_code": "84059",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-05-14",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "FRISCO TX 75034",
"city": "Frisco",
"county": "Collin",
"state": "TX",
"postal_code": "75034",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-03-19",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "COPPELL TX 75019",
"city": "Coppell",
"county": "Dallas",
"state": "TX",
"postal_code": "75019",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2024-11-22",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "MORRISVILLE NC 27560",
"city": "Morrisville",
"county": "Wake",
"state": "NC",
"postal_code": "27560",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2025,
"latest_decision_date": "2024-10-09",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "LAND OLAKES FL 34637",
"city": "Land Olakes",
"state": "FL",
"postal_code": "34637",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-08-26",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "MALDEN MA 02148",
"city": "Malden",
"state": "MA",
"postal_code": "02148",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-07-14",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "BOSTON MA 02113",
"city": "Boston",
"county": "Boston City",
"state": "MA",
"postal_code": "02113",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-06-05",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "TEMPE AZ 85288",
"city": "Tempe",
"county": "Maricopa",
"state": "AZ",
"postal_code": "85288",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-06-04",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "HASLET TX 76052",
"city": "Haslet",
"county": "Denton",
"state": "TX",
"postal_code": "76052",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-05-29",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "DUBLIN OH 43016",
"city": "Dublin",
"county": "Franklin",
"state": "OH",
"postal_code": "43016",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-05-15",
"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": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-05-14",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "BOSTON MA 02135",
"city": "Boston",
"county": "Boston City",
"state": "MA",
"postal_code": "02135",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-04-25",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "HOLLISTON MA 01746",
"city": "Holliston",
"county": "Holliston",
"state": "MA",
"postal_code": "01746",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-03-14",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "SAN JOSE CA 95133",
"city": "San Jose",
"county": "Santa Clara",
"state": "CA",
"postal_code": "95133",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-03-12",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "GRAND RAPIDS MI 49503",
"city": "Grand Rapids",
"county": "Kent",
"state": "MI",
"postal_code": "49503",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-01-06",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "GRAND RAPIDS MI 49401",
"city": "Grand Rapids",
"county": "Kent",
"state": "MI",
"postal_code": "49401",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2024-12-30",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "MILTON GA 30004",
"city": "Milton",
"county": "Fulton",
"state": "GA",
"postal_code": "30004",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2024-12-02",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ROCHESTER HILLS MI 48307",
"city": "Rochester Hills",
"county": "Oakland",
"state": "MI",
"postal_code": "48307",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2024-11-12",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "WINTER GARDEN FL 34787",
"city": "Winter Garden",
"county": "Orange",
"state": "FL",
"postal_code": "34787",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025,
"latest_decision_date": "2024-10-09",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "OLYMPIA WA 98501",
"city": "Olympia",
"county": "Thurston",
"state": "WA",
"postal_code": "98501",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2024,
"latest_decision_date": "2024-07-22",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "TYSONS VA 22102",
"city": "Tysons",
"county": "Fairfax",
"state": "VA",
"postal_code": "22102",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2024,
"latest_decision_date": "2024-06-20",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ATTLEBORO MA 02703",
"city": "Attleboro",
"county": "Attleboro City",
"state": "MA",
"postal_code": "02703",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2024,
"latest_decision_date": "2024-04-12",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "LANGHORNE PA 19047",
"city": "Langhorne",
"county": "Bucks",
"state": "PA",
"postal_code": "19047",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2024,
"latest_decision_date": "2024-09-04",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "HOLLY SPRINGS NC 27540",
"city": "Holly Springs",
"county": "Wake",
"state": "NC",
"postal_code": "27540",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2024,
"latest_decision_date": "2024-08-09",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "RESTON VA 20194",
"city": "Reston",
"county": "Fairfax",
"state": "VA",
"postal_code": "20194",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2024,
"latest_decision_date": "2024-08-08",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CHARLOTTE NC 28215",
"city": "Charlotte",
"county": "Mecklenburg",
"state": "NC",
"postal_code": "28215",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2024,
"latest_decision_date": "2024-07-08",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "COLUMBUS OH 43240",
"city": "Columbus",
"county": "Delaware",
"state": "OH",
"postal_code": "43240",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2024,
"latest_decision_date": "2024-06-07",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CORPUS CHRISTI TX 78414",
"city": "Corpus Christi",
"county": "Nueces",
"state": "TX",
"postal_code": "78414",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2024,
"latest_decision_date": "2024-05-21",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "TALLAHASSEE FL 32311",
"city": "Tallahassee",
"county": "Leon",
"state": "FL",
"postal_code": "32311",
"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": "BOSTON MA 02134",
"city": "Boston",
"county": "Boston City",
"state": "MA",
"postal_code": "02134",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-07-10",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "DELAWARE OH 04315",
"city": "Delaware",
"county": "Delaware",
"state": "OH",
"postal_code": "04315",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2023,
"latest_decision_date": "2022-12-15",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "BOSTON MA 02115",
"city": "Boston",
"county": "Boston City",
"state": "MA",
"postal_code": "02115",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2023,
"latest_decision_date": "2022-11-25",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "NEWPORT NH 03773",
"city": "Newport",
"county": "Newport",
"state": "NH",
"postal_code": "03773",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2023,
"latest_decision_date": "2022-10-21",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "DALLAS TX 75254",
"city": "Dallas",
"county": "Dallas",
"state": "TX",
"postal_code": "75254",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2023,
"latest_decision_date": "2022-10-20",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "MALDEN MA 02148",
"city": "Malden",
"county": "Malden City",
"state": "MA",
"postal_code": "02148",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-09-08",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "SPRING TX 77380",
"city": "Spring",
"county": "Harris",
"state": "TX",
"postal_code": "77380",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-08-28",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "FRISCO TX 75036",
"city": "Frisco",
"county": "Denton",
"state": "TX",
"postal_code": "75036",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-07-31",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "BLOOMINGTON MN 55437",
"city": "Bloomington",
"county": "Hennepin",
"state": "MN",
"postal_code": "55437",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-07-26",
"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": 2023,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-07-18",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CONCORD NC 28027",
"city": "Concord",
"county": "Cabarrus",
"state": "NC",
"postal_code": "28027",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-07-18",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "TAMPA FL 33617",
"city": "Tampa",
"county": "Hillsborough",
"state": "FL",
"postal_code": "33617",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-07-10",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "RICHFIELD MN 55423",
"city": "Richfield",
"county": "Hennepin",
"state": "MN",
"postal_code": "55423",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-07-06",
"source_ids": [
"dol_oflc_lca"
]
}
],
"summary": {
"office_address_count": 5,
"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": [
"MA",
"TX",
"WA",
"MD",
"NC",
"NH",
"OH",
"UT",
"VA",
"AZ",
"CA",
"FL",
"GA",
"MI",
"MN",
"PA"
],
"cities": [
"Boston",
"Medford",
"Frisco",
"Tumwater",
"Attleboro",
"Malden",
"Clarksburg",
"Morrisville",
"Newport",
"Delaware",
"Coppell",
"Cypress",
"Dallas",
"Vineyard",
"Oakton",
"Tysons",
"Olympia",
"Phoenix",
"Tempe",
"San Jose",
"Land Olakes",
"Tallahassee",
"Tampa",
"Winter Garden",
"Milton",
"Brookline",
"Holliston",
"Hopkinton",
"North Grafton",
"Grand Rapids",
"Rochester Hills",
"Bloomington",
"Richfield",
"Apex",
"Charlotte",
"Concord",
"Holly Springs",
"Indian Trail",
"New Hill",
"Columbus",
"Dublin",
"Langhorne",
"Conroe",
"Corpus Christi",
"Haslet",
"Mckinney",
"Spring",
"Alexandria",
"Reston",
"Seattle"
],
"postal_codes": [
"2109",
"2135",
"02113",
"2155",
"75036",
"98501",
"02703",
"02109",
"02115",
"02134",
"02135",
"02148",
"20871",
"27560",
"03773",
"04315",
"75019",
"77433",
"75254",
"75034",
"84059",
"22124",
"22102",
"98502",
"85044",
"85288",
"95133",
"34637",
"32311",
"33617",
"34787",
"30004",
"2446",
"01746",
"1748",
"2148",
"01536",
"49401",
"49503",
"48307",
"55437",
"55423",
"27502",
"28215",
"28027",
"27540",
"28079",
"27562",
"43240",
"43016",
"19047",
"77385",
"78414",
"76052",
"75070",
"77380",
"22302",
"20194",
"98121"
],
"top_markets": [
{
"city": "Boston",
"state": "MA",
"postal_code": "2109",
"lca_count": 13,
"role_title_count": 9,
"wage_low_min": 54642,
"wage_high_max": 150000,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2021
},
{
"city": "Boston",
"state": "MA",
"postal_code": "2135",
"lca_count": 4,
"role_title_count": 3,
"wage_low_min": 75774,
"wage_high_max": 115000,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2022
},
{
"city": "Boston",
"state": "MA",
"postal_code": "02113",
"lca_count": 3,
"role_title_count": 1,
"wage_low_min": 103022,
"wage_high_max": 106434,
"first_fiscal_year": 2025,
"latest_fiscal_year": 2025
},
{
"city": "Medford",
"state": "MA",
"postal_code": "2155",
"lca_count": 3,
"role_title_count": 2,
"wage_low_min": 55000,
"wage_high_max": 64168,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019
},
{
"city": "Frisco",
"state": "TX",
"postal_code": "75036",
"lca_count": 3,
"role_title_count": 2,
"wage_low_min": 120328,
"wage_high_max": 150000,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2026
},
{
"city": "Tumwater",
"state": "WA",
"postal_code": "98501",
"lca_count": 3,
"role_title_count": 2,
"wage_low_min": 91486,
"wage_high_max": 105435,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2025
},
{
"city": "Attleboro",
"state": "MA",
"postal_code": "02703",
"lca_count": 2,
"role_title_count": 2,
"wage_low_min": 63036,
"wage_high_max": 72010,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2024
},
{
"city": "Boston",
"state": "MA",
"postal_code": "02109",
"lca_count": 2,
"role_title_count": 2,
"wage_low_min": 125000,
"wage_high_max": 140203,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2021
},
{
"city": "Boston",
"state": "MA",
"postal_code": "02115",
"lca_count": 2,
"role_title_count": 1,
"wage_low_min": 95000,
"wage_high_max": 95000,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2023
},
{
"city": "Boston",
"state": "MA",
"postal_code": "02134",
"lca_count": 2,
"role_title_count": 2,
"wage_low_min": 118450,
"wage_high_max": 135000,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2023
}
]
}Industry
{
"naics_codes": [
"541618",
"54"
],
"naics_breakdown": [
{
"value": "541512",
"filing_count": 89,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2026,
"source": "dol_oflc_lca"
},
{
"value": "541618",
"filing_count": 14,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"source": "dol_oflc_lca"
}
]
}Wage Summary
{
"annualized_low_min": 54642,
"annualized_high_max": 165315,
"annualized_low_avg": 114544.32038835
}Trend
[
{
"fiscal_year": 2019,
"quarter": "Q2",
"lca_count": 14,
"case_count": 14,
"role_title_count": 10,
"worksite_count": 6,
"wage_low_min": 55000,
"wage_high_max": 150000,
"wage_low_avg": 88719.2142857143
},
{
"fiscal_year": 2020,
"quarter": "Q1",
"lca_count": 1,
"case_count": 1,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 125000,
"wage_high_max": 125000,
"wage_low_avg": 125000
},
{
"fiscal_year": 2020,
"quarter": "Q3",
"lca_count": 3,
"case_count": 3,
"role_title_count": 3,
"worksite_count": 1,
"wage_low_min": 54642,
"wage_high_max": 141137,
"wage_low_avg": 95884.3333333333
},
{
"fiscal_year": 2021,
"quarter": "Q2",
"lca_count": 2,
"case_count": 2,
"role_title_count": 2,
"worksite_count": 2,
"wage_low_min": 118102,
"wage_high_max": 140203,
"wage_low_avg": 129152.5
},
{
"fiscal_year": 2021,
"quarter": "Q3",
"lca_count": 7,
"case_count": 7,
"role_title_count": 5,
"worksite_count": 4,
"wage_low_min": 96242,
"wage_high_max": 149240,
"wage_low_avg": 122224.142857143
},
{
"fiscal_year": 2022,
"quarter": "Q1",
"lca_count": 1,
"case_count": 1,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 118635,
"wage_high_max": 118635,
"wage_low_avg": 118635
},
{
"fiscal_year": 2022,
"quarter": "Q2",
"lca_count": 5,
"case_count": 5,
"role_title_count": 3,
"worksite_count": 3,
"wage_low_min": 83254,
"wage_high_max": 119350,
"wage_low_avg": 108920.8
},
{
"fiscal_year": 2022,
"quarter": "Q3",
"lca_count": 5,
"case_count": 5,
"role_title_count": 5,
"worksite_count": 4,
"wage_low_min": 91486,
"wage_high_max": 150000,
"wage_low_avg": 118906
},
{
"fiscal_year": 2022,
"quarter": "Q4",
"lca_count": 1,
"case_count": 1,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 75774,
"wage_high_max": 75774,
"wage_low_avg": 75774
},
{
"fiscal_year": 2023,
"quarter": "Q1",
"lca_count": 4,
"case_count": 4,
"role_title_count": 3,
"worksite_count": 4,
"wage_low_min": 85752,
"wage_high_max": 144000,
"wage_low_avg": 104938
},
{
"fiscal_year": 2023,
"quarter": "Q2",
"lca_count": 4,
"case_count": 4,
"role_title_count": 3,
"worksite_count": 4,
"wage_low_min": 85752,
"wage_high_max": 144000,
"wage_low_avg": 104938
},
{
"fiscal_year": 2023,
"quarter": "Q3",
"lca_count": 4,
"case_count": 4,
"role_title_count": 3,
"worksite_count": 4,
"wage_low_min": 72010,
"wage_high_max": 142100,
"wage_low_avg": 118665
},
{
"fiscal_year": 2023,
"quarter": "Q4",
"lca_count": 9,
"case_count": 9,
"role_title_count": 7,
"worksite_count": 9,
"wage_low_min": 120328,
"wage_high_max": 146250,
"wage_low_avg": 129897.555555556
},
{
"fiscal_year": 2024,
"quarter": "Q3",
"lca_count": 7,
"case_count": 7,
"role_title_count": 7,
"worksite_count": 6,
"wage_low_min": 63036,
"wage_high_max": 165315,
"wage_low_avg": 117621.571428571
},
{
"fiscal_year": 2024,
"quarter": "Q4",
"lca_count": 6,
"case_count": 6,
"role_title_count": 5,
"worksite_count": 6,
"wage_low_min": 127000,
"wage_high_max": 137700,
"wage_low_avg": 130012.833333333
},
{
"fiscal_year": 2025,
"quarter": "Q1",
"lca_count": 7,
"case_count": 7,
"role_title_count": 7,
"worksite_count": 6,
"wage_low_min": 102000,
"wage_high_max": 145000,
"wage_low_avg": 126302.285714286
},
{
"fiscal_year": 2025,
"quarter": "Q2",
"lca_count": 4,
"case_count": 4,
"role_title_count": 4,
"worksite_count": 4,
"wage_low_min": 102000,
"wage_high_max": 160000,
"wage_low_avg": 122940.5
},
{
"fiscal_year": 2025,
"quarter": "Q3",
"lca_count": 9,
"case_count": 9,
"role_title_count": 7,
"worksite_count": 8,
"wage_low_min": 69188,
"wage_high_max": 149474,
"wage_low_avg": 101733.888888889
},
{
"fiscal_year": 2025,
"quarter": "Q4",
"lca_count": 4,
"case_count": 4,
"role_title_count": 3,
"worksite_count": 3,
"wage_low_min": 106434,
"wage_high_max": 130560,
"wage_low_avg": 117511.75
},
{
"fiscal_year": 2026,
"quarter": "Q2",
"lca_count": 6,
"case_count": 6,
"role_title_count": 5,
"worksite_count": 6,
"wage_low_min": 110000,
"wage_high_max": 160000,
"wage_low_avg": 141287.666666667
}
]Links
{
"roles": "/v1/roles?company=PUBLIC%20PARTNERSHIPS%20LLC",
"wages": "/v1/wages?company=PUBLIC%20PARTNERSHIPS%20LLC",
"trends": "/v1/trends?company=PUBLIC%20PARTNERSHIPS%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=public+partnerships+llc&limit=5JSON