bluedoor data·H-1B Jobs API·bluedoor.sh ->

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.

EmployerLCA filingsRole titlesWorksitesCoverageUSCIS approvalsTop roleSourcesOpen
PUBLIC PARTNERSHIPS LLC
PUBLIC PARTNERSHIPS LLC
1035461FY2019 to FY2026
Latest decision 2026-03-31
40Software Engineer 3
7 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings103
Certified LCAs103
Denied LCAs0
Role titles54
Worksites61
Latest decision2026-03-31
USCIS approvals40
USCIS denials0

Aliases and source names

AliasesSource NamesSources
PUBLIC PARTNERSHIPS LLCPUBLIC PARTNERSHIPS LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
Software Engineer 315-1252.00
Software Developers
7$105,435$152,755
Sr. Data Analyst15-1211.00
Computer Systems Analysts
5$95,000$110,000
Sr. Software Engineer15-1132.00
Software Developers, Applications
5$118,635$140,203
Data Analyst 115-1211.00
Computer Systems Analysts
3$69,188$90,000
Lead Software Engineer15-1132.00
Software Developers, Applications
3$119,933$141,137
Sr Data Analyst15-1211.00
Computer Systems Analysts
3$103,022$106,434
Azure DevOps Engineer 315-1252.00
Software Developers
2$132,000$145,000
BI Developer15-2051.01
Business Intelligence Analysts
2$102,000$102,000
Cloud Engineer 315-1299.08
Computer Systems Engineers/Architects
2$144,000$144,000
IT Database Analyst II15-1242.00
Database Administrators
2$86,603$86,603

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
BostonMA210913954,642150,0002,0192,021
BostonMA21354375,774115,0002,0222,022
BostonMA0211331103,022106,4342,0252,025
MedfordMA21553255,00064,1682,0192,019
FriscoTX7503632120,328150,0002,0222,026
TumwaterWA985013291,486105,4352,0222,025
AttleboroMA027032263,03672,0102,0232,024
BostonMA0210922125,000140,2032,0202,021
BostonMA021152195,00095,0002,0232,023
BostonMA0213422118,450135,0002,0232,023

Full company payload

Company IDcompany:public partnerships
NamePUBLIC PARTNERSHIPS LLC
Normalized Namepublic partnerships
Source Company Idscompany_dol_oflc_lca_public_partnerships_llc, company_uscis_h1b_datahub_public_partnerships_llc_tax_8852
Source NamesPUBLIC PARTNERSHIPS LLC
AliasesPUBLIC PARTNERSHIPS LLC
Sourcesdol_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