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

Home / Companies / Capgemini America, Inc.

Capgemini America, Inc. H-1B company data

Summary

Capgemini America, Inc. filed 68,284 H-1B labor condition applications (LCAs) with the U.S. Department of Labor between FY2016-FY2026.

Of those, 67,334 were certified and 205 denied (a 100% certification rate among adjudicated filings).

The filings span 783 distinct role titles across 2,769 worksites.

The most-sponsored role was Applications Consultant 2 (3,668 filings), with offered wages from $58,900 to $960,000.

Separately, USCIS H-1B Employer Data Hub records show 25,035 approved and 4,308 denied H-1B petitions for this employer.

LCA filings are labor-condition applications certified by the U.S. Department of Labor, not active job postings or approved USCIS H-1B petitions.

EmployerLCA filingsRole titlesWorksitesCoverageUSCIS approvalsTop roleSourcesOpen
Capgemini America, Inc.
CAPGEMINI AMERICA, INC., NOT APPLICABLE, CAPGEMINI AMERICA INC
68,2847832,769FY2016 to FY2026
Latest decision 2026-03-31
25,035APPLICATIONS CONSULTANT 2
3,668 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile
CAPGEMINI AMERICA, INC. (LEGACY CAPGEMINI FINANCIAL SERVICES, INC.)1,069106189FY2016 to FY2019
Latest decision 2019-05-21
0APPLICATIONS CONSULTANT 3
73 filings
dol_oflc_lcaProfile
CAPGEMINI AMERICA INCx311FY2021 to FY2021
Latest decision 2020-12-28
0Applications Consultant 2
2 filings
dol_oflc_lcaProfile
CAPGEMINI AMERICA, INCA.111FY2019 to FY2019
Latest decision 2019-06-25
0BUSINESS SYSTEMS ANALYST 2
1 filings
dol_oflc_lcaProfile
CAPGEMINI AMERICA INC THROUGH ITS
CAPGEMINI AMERICA INC THROUGH ITS
0--FY- to FY-
Latest decision -
30-uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings68,284
Certified LCAs67,334
Denied LCAs205
Role titles783
Worksites2,769
Latest decision2026-03-31
USCIS approvals25,035
USCIS denials4,308

Aliases and source names

AliasesSource NamesSources
CAPGEMINI AMERICA, INC., NOT APPLICABLE, CAPGEMINI AMERICA INC, Capgemini America Inc, CAPGEMINI AMERICA, INC, 333 WEST WACKER DRIVE, Altria Client ServicesCapgemini America, Inc., CAPGEMINI AMERICA INCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
APPLICATIONS CONSULTANT 215-1132
SOFTWARE DEVELOPERS, APPLICATIONS
3,668$58,900$960,000
APPLICATIONS CONSULTANT 215-1132.00
Software Developers, Applications
3,298$60,000$195,293,280
SOFTWARE ENGINEER 215-1132
SOFTWARE DEVELOPERS, APPLICATIONS
2,925$60,000$151,000
TEST CONSULTANT 215-1199
COMPUTER OCCUPATIONS, ALL OTHER
2,866$48,200$151,000
Applications Consultant 315-1252.00
Software Developers
2,759$90,605$322,400,000
APPLICATIONS CONSULTANT 315-1132.00
Software Developers, Applications
2,729$76,045$1,222,221
BUSINESS SYSTEMS ANALYST 215-1121
COMPUTER SYSTEMS ANALYSTS
2,307$56,100$151,000
PROGRAMMER/DEVELOPER 215-1131
COMPUTER PROGRAMMERS
2,096$54,500$140,000
PROGRAMMER/ DEVELOPER 215-1131
COMPUTER PROGRAMMERS
2,087$48,700$120,275
APPLICATIONS CONSULTANT 315-1132
SOFTWARE DEVELOPERS, APPLICATIONS
1,799$74,700$200,000

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
AtlantaGA303052,50412850,000306,0002,0162,026
RiverwoodsIL600152,3497939,800185,0002,0162,026
ChicagoIL606061,4406851,000218,400,0002,0162,026
BloomingtonIL617911,1494560,0004,009,3042,0162,025
New YorkNY100199346060,000200,0002,0162,026
HoustonTX770568894860,000220,3182,0162,026
Woodland HillsCA913677876160,000195,293,2802,0162,026
AtlantaGA303287735960,000200,0002,0162,026
CharlotteNC282627646260,000960,0002,0162,026
RosemontIL600187609160,000152,332,9602,0162,021

Full company payload

Company IDcompany:capgemini america
NameCapgemini America, Inc.
Normalized Namecapgemini america
Source Company Idscompany_dol_oflc_lca_capgemini_america_inc, company_uscis_h1b_datahub_capgemini_america_inc_tax_5929, company_uscis_h1b_datahub_capgemini_america_inc_tax_7592, company_uscis_h1b_datahub_capgemini_america_inc_tax_7929, company_uscis_h1b_datahub_capgemini_america_inc_tax_8544, company_uscis_h1b_datahub_capgemini_america_inc_tax_2959, company_uscis_h1b_datahub_capgemini_america_inc_tax_5920, company_uscis_h1b_datahub_capgemini_america_inc_tax_5959, company_uscis_h1b_datahub_capgemini_america_inc_tax_5292, company_uscis_h1b_datahub_capgemini_america_inc_tax_8929, company_uscis_h1b_datahub_capgemini_america_inc_tax_2929, company_uscis_h1b_datahub_capgemini_america_inc_tax_0354, company_uscis_h1b_datahub_capgemini_america_inc_tax_5500, company_uscis_h1b_datahub_capgemini_america_inc_tax_5592, company_uscis_h1b_datahub_capgemini_america_inc_tax_5919, company_uscis_h1b_datahub_capgemini_america_inc_tax_5925, company_uscis_h1b_datahub_capgemini_america_inc_tax_9592, company_uscis_h1b_datahub_capgemini_america_inc_tax_5923, company_uscis_h1b_datahub_capgemini_america_inc_tax_5909, company_uscis_h1b_datahub_capgemini_america_inc_tax_5939, company_uscis_h1b_datahub_capgemini_america_inc_tax_3548, company_uscis_h1b_datahub_capgemini_america_inc_tax_5922, company_uscis_h1b_datahub_capgemini_america_inc_tax_3929, company_uscis_h1b_datahub_capgemini_america_inc_tax_5953, company_uscis_h1b_datahub_capgemini_america_inc_tax_5862, company_uscis_h1b_datahub_capgemini_america_inc_tax_5962, company_uscis_h1b_datahub_capgemini_america_inc_tax_6607, company_uscis_h1b_datahub_capgemini_america_inc_tax_6929, company_uscis_h1b_datahub_capgemini_america_inc_tax_5792, company_uscis_h1b_datahub_capgemini_america_inc_tax_5492, company_uscis_h1b_datahub_capgemini_america_inc_tax_4610, company_uscis_h1b_datahub_capgemini_america_inc_tax_8932, company_uscis_h1b_datahub_capgemini_america_inc_tax_9259, company_uscis_h1b_datahub_capgemini_america_inc_tax_9291, company_uscis_h1b_datahub_capgemini_america_inc_tax_5949, company_uscis_h1b_datahub_capgemini_america_inc_tax_9529, company_uscis_h1b_datahub_capgemini_america_inc_tax_4929
Source NamesCapgemini America, Inc., CAPGEMINI AMERICA INC
AliasesCAPGEMINI AMERICA, INC., NOT APPLICABLE, CAPGEMINI AMERICA INC, Capgemini America Inc, CAPGEMINI AMERICA, INC, 333 WEST WACKER DRIVE, Altria Client Services
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "Capgemini America, Inc.",
    "CAPGEMINI AMERICA INC"
  ],
  "dba_names": [
    "CAPGEMINI AMERICA, INC.",
    "NOT APPLICABLE",
    "CAPGEMINI AMERICA INC",
    "Capgemini America Inc",
    "CAPGEMINI AMERICA, INC",
    "333 WEST WACKER DRIVE",
    "Altria Client Services"
  ],
  "name_variants": [
    {
      "value": "CAPGEMINI AMERICA INC",
      "filing_count": 48855,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Capgemini America, Inc.",
      "filing_count": 1878,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Capgemini America Inc",
      "filing_count": 1371,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CAPGEMINI AMERICA, INC.",
      "filing_count": 1249,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CAPGEMINI AMERICA INC.",
      "filing_count": 174,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "NOT APPLICABLE",
      "filing_count": 120,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Capgemini America, Inc",
      "filing_count": 8,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CAPGEMINI AMERICA, INC",
      "filing_count": 8,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Capgemini America Inc.",
      "filing_count": 2,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "333 WEST WACKER DRIVE",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Altria Client Services",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CAPGEMINI AMERICA,INC.",
      "filing_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Capgemini America. Inc.",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CAPGEMINI AMERICA INC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5929",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "7592",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "7929",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "8544",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "2959",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5920",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5959",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5292",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "8929",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "2929",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "0354",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5500",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5592",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5919",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5925",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "9592",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5923",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5909",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5939",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "3548",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5922",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "3929",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5953",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5862",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5962",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "6607",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "6929",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5792",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5492",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "4610",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "8932",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "9259",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "9291",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5949",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "9529",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "4929",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 68284,
  "case_count": 68284,
  "role_title_count": 783,
  "worksite_count": 2769,
  "total_workers": 111040,
  "first_fiscal_year": 2016,
  "first_received_date": "2015-09-28",
  "latest_fiscal_year": 2026,
  "latest_decision_date": "2026-03-31",
  "certified_count": 67334,
  "denied_count": 205,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 39717,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 25398,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED-WITHDRAWN",
      "filing_count": 1454,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified - Withdrawn",
      "filing_count": 765,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    },
    {
      "value": "WITHDRAWN",
      "filing_count": 552,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "DENIED",
      "filing_count": 193,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Withdrawn",
      "filing_count": 193,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Denied",
      "filing_count": 12,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 68147,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    },
    {
      "value": "E-3 Australian",
      "filing_count": 134,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    },
    {
      "value": "H-1B1 Singapore",
      "filing_count": 2,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "H-1B1 Chile",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 51232,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    },
    {
      "value": "N",
      "filing_count": 2,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 25035,
  "total_denial": 4308,
  "fiscal_years": [
    "2009",
    "2010",
    "2011",
    "2012",
    "2013",
    "2014",
    "2015",
    "2016",
    "2017",
    "2018",
    "2019",
    "2020",
    "2021",
    "2022",
    "2023"
  ],
  "year_metrics": [
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2009,
      "naics_codes": [
        "52",
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 19,
      "initial_approval": 8,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5929_2009",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2009_row_021932",
        "sr_uscis_h1b_datahub_2009_row_021933"
      ],
      "continuing_approval": 11
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2010,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 36,
      "initial_approval": 12,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5929_2010",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2010_row_016692"
      ],
      "continuing_approval": 24
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2011,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60137",
        "60505",
        "60603",
        "60606"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 68,
      "initial_approval": 19,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5929_2011",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2011_row_018245",
        "sr_uscis_h1b_datahub_2011_row_018246",
        "sr_uscis_h1b_datahub_2011_row_018247",
        "sr_uscis_h1b_datahub_2011_row_018248"
      ],
      "continuing_approval": 49
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60544",
        "60603",
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 53,
      "initial_approval": 20,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5929_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_015759",
        "sr_uscis_h1b_datahub_2012_row_015760",
        "sr_uscis_h1b_datahub_2012_row_015761"
      ],
      "continuing_approval": 33
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2013,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60544",
        "60603",
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 47,
      "initial_approval": 6,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5929_2013",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2013_row_014726",
        "sr_uscis_h1b_datahub_2013_row_014727",
        "sr_uscis_h1b_datahub_2013_row_014728"
      ],
      "continuing_approval": 41
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60603",
        "60606"
      ],
      "total_denial": 2,
      "initial_denial": 1,
      "total_approval": 62,
      "initial_approval": 13,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5929_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_014389",
        "sr_uscis_h1b_datahub_2014_row_014390"
      ],
      "continuing_approval": 49
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60603",
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 52,
      "initial_approval": 7,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5929_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_011479",
        "sr_uscis_h1b_datahub_2015_row_011480"
      ],
      "continuing_approval": 45
    },
    {
      "cities": [
        "Bridgewater",
        "Chicago",
        "New York"
      ],
      "states": [
        "IL",
        "NJ",
        "NY"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "51",
        "52",
        "54",
        "99"
      ],
      "postal_codes": [
        "08807",
        "10022",
        "60603",
        "60605",
        "60606"
      ],
      "total_denial": 8,
      "initial_denial": 4,
      "total_approval": 1283,
      "initial_approval": 882,
      "continuing_denial": 4,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5929_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_000099",
        "sr_uscis_h1b_datahub_2016_row_011987",
        "sr_uscis_h1b_datahub_2016_row_011988",
        "sr_uscis_h1b_datahub_2016_row_011989",
        "sr_uscis_h1b_datahub_2016_row_011990",
        "sr_uscis_h1b_datahub_2016_row_011992",
        "sr_uscis_h1b_datahub_2016_row_011993",
        "sr_uscis_h1b_datahub_2016_row_011994",
        "sr_uscis_h1b_datahub_2016_row_011995"
      ],
      "continuing_approval": 401
    },
    {
      "cities": [
        "Bridgewater",
        "Chicago",
        "Houston",
        "New York",
        "Rosemont"
      ],
      "states": [
        "IL",
        "NJ",
        "NY",
        "TX"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "51",
        "54"
      ],
      "postal_codes": [
        "08807",
        "10022",
        "60018",
        "60605",
        "60606",
        "60608",
        "60660",
        "77056"
      ],
      "total_denial": 286,
      "initial_denial": 129,
      "total_approval": 3653,
      "initial_approval": 517,
      "continuing_denial": 157,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5929_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_010668",
        "sr_uscis_h1b_datahub_2017_row_010669",
        "sr_uscis_h1b_datahub_2017_row_010670",
        "sr_uscis_h1b_datahub_2017_row_010671",
        "sr_uscis_h1b_datahub_2017_row_010672",
        "sr_uscis_h1b_datahub_2017_row_010673",
        "sr_uscis_h1b_datahub_2017_row_010674",
        "sr_uscis_h1b_datahub_2017_row_010675",
        "sr_uscis_h1b_datahub_2017_row_010676",
        "sr_uscis_h1b_datahub_2017_row_010678",
        "sr_uscis_h1b_datahub_2017_row_011626"
      ],
      "continuing_approval": 3136
    },
    {
      "cities": [
        "Chicago",
        "Dayton",
        "Des Plaines",
        "Irving",
        "Wheeling"
      ],
      "states": [
        "IL",
        "OH",
        "TX"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "31",
        "51",
        "54"
      ],
      "postal_codes": [
        "45390",
        "45432",
        "60018",
        "60090",
        "60603",
        "60606",
        "73301",
        "77056"
      ],
      "total_denial": 1985,
      "initial_denial": 1065,
      "total_approval": 2946,
      "initial_approval": 273,
      "continuing_denial": 920,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5929_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_002833",
        "sr_uscis_h1b_datahub_2018_row_011290",
        "sr_uscis_h1b_datahub_2018_row_011291",
        "sr_uscis_h1b_datahub_2018_row_011292",
        "sr_uscis_h1b_datahub_2018_row_011293",
        "sr_uscis_h1b_datahub_2018_row_011294",
        "sr_uscis_h1b_datahub_2018_row_011295",
        "sr_uscis_h1b_datahub_2018_row_011297",
        "sr_uscis_h1b_datahub_2018_row_011298",
        "sr_uscis_h1b_datahub_2018_row_011300",
        "sr_uscis_h1b_datahub_2018_row_011301",
        "sr_uscis_h1b_datahub_2018_row_011348",
        "sr_uscis_h1b_datahub_2018_row_011377"
      ],
      "continuing_approval": 2673
    },
    {
      "cities": [
        "Chicago",
        "Dayton",
        "Des Plaines",
        "Mc Lean",
        "Miamisburg",
        "Rosemont"
      ],
      "states": [
        "IL",
        "OH",
        "VA"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "51",
        "52",
        "54",
        "61",
        "92"
      ],
      "postal_codes": [
        "22102",
        "45342",
        "45390",
        "45401",
        "45402",
        "45406",
        "45432",
        "45459",
        "60018",
        "60603",
        "60605",
        "60606",
        "60654",
        "60660"
      ],
      "total_denial": 1349,
      "initial_denial": 671,
      "total_approval": 3666,
      "initial_approval": 813,
      "continuing_denial": 678,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5929_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_011346",
        "sr_uscis_h1b_datahub_2019_row_011347",
        "sr_uscis_h1b_datahub_2019_row_011348",
        "sr_uscis_h1b_datahub_2019_row_011349",
        "sr_uscis_h1b_datahub_2019_row_011350",
        "sr_uscis_h1b_datahub_2019_row_011351",
        "sr_uscis_h1b_datahub_2019_row_011352",
        "sr_uscis_h1b_datahub_2019_row_011353",
        "sr_uscis_h1b_datahub_2019_row_011354",
        "sr_uscis_h1b_datahub_2019_row_011355",
        "sr_uscis_h1b_datahub_2019_row_011356",
        "sr_uscis_h1b_datahub_2019_row_011357",
        "sr_uscis_h1b_datahub_2019_row_011358",
        "sr_uscis_h1b_datahub_2019_row_011359",
        "sr_uscis_h1b_datahub_2019_row_011360",
        "sr_uscis_h1b_datahub_2019_row_011361",
        "sr_uscis_h1b_datahub_2019_row_011362",
        "sr_uscis_h1b_datahub_2019_row_011363",
        "sr_uscis_h1b_datahub_2019_row_011364",
        "sr_uscis_h1b_datahub_2019_row_011365",
        "sr_uscis_h1b_datahub_2019_row_011375",
        "sr_uscis_h1b_datahub_2019_row_011471",
        "sr_uscis_h1b_datahub_2019_row_012366",
        "sr_uscis_h1b_datahub_2019_row_018122"
      ],
      "continuing_approval": 2853
    },
    {
      "cities": [
        "Chicago",
        "Dayton",
        "Miamisburg",
        "Rosemont"
      ],
      "states": [
        "IL",
        "OH"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "31",
        "51",
        "52",
        "54"
      ],
      "postal_codes": [
        "45342",
        "45432",
        "45441",
        "45449",
        "45459",
        "60018",
        "60601",
        "60603",
        "60605",
        "60606",
        "60608"
      ],
      "total_denial": 540,
      "initial_denial": 365,
      "total_approval": 5299,
      "initial_approval": 1410,
      "continuing_denial": 175,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5929_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_008488",
        "sr_uscis_h1b_datahub_2020_row_008489",
        "sr_uscis_h1b_datahub_2020_row_008490",
        "sr_uscis_h1b_datahub_2020_row_008491",
        "sr_uscis_h1b_datahub_2020_row_008492",
        "sr_uscis_h1b_datahub_2020_row_008493",
        "sr_uscis_h1b_datahub_2020_row_008494",
        "sr_uscis_h1b_datahub_2020_row_008495",
        "sr_uscis_h1b_datahub_2020_row_008496",
        "sr_uscis_h1b_datahub_2020_row_008497",
        "sr_uscis_h1b_datahub_2020_row_008498",
        "sr_uscis_h1b_datahub_2020_row_008501",
        "sr_uscis_h1b_datahub_2020_row_008502",
        "sr_uscis_h1b_datahub_2020_row_008503",
        "sr_uscis_h1b_datahub_2020_row_008504"
      ],
      "continuing_approval": 3889
    },
    {
      "cities": [
        "Chicago",
        "Miamisburg"
      ],
      "states": [
        "IL",
        "OH"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "51",
        "54"
      ],
      "postal_codes": [
        "45342",
        "60604",
        "60606",
        "60660"
      ],
      "total_denial": 54,
      "initial_denial": 34,
      "total_approval": 3200,
      "initial_approval": 889,
      "continuing_denial": 20,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5929_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_009476",
        "sr_uscis_h1b_datahub_2021_row_009477",
        "sr_uscis_h1b_datahub_2021_row_009478",
        "sr_uscis_h1b_datahub_2021_row_009479",
        "sr_uscis_h1b_datahub_2021_row_009481"
      ],
      "continuing_approval": 2311
    },
    {
      "cities": [
        "Chicago",
        "Datyon",
        "Dayton",
        "Miamisburg",
        "New Lebanon"
      ],
      "states": [
        "IL",
        "OH"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "51",
        "54"
      ],
      "postal_codes": [
        "45342",
        "45345",
        "45432",
        "60606"
      ],
      "total_denial": 39,
      "initial_denial": 16,
      "total_approval": 3125,
      "initial_approval": 1088,
      "continuing_denial": 23,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5929_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_009347",
        "sr_uscis_h1b_datahub_2022_row_009348",
        "sr_uscis_h1b_datahub_2022_row_009349",
        "sr_uscis_h1b_datahub_2022_row_009351",
        "sr_uscis_h1b_datahub_2022_row_009354",
        "sr_uscis_h1b_datahub_2022_row_009355",
        "sr_uscis_h1b_datahub_2022_row_009356",
        "sr_uscis_h1b_datahub_2022_row_009357",
        "sr_uscis_h1b_datahub_2022_row_009358",
        "sr_uscis_h1b_datahub_2022_row_009359"
      ],
      "continuing_approval": 2037
    },
    {
      "cities": [
        "Chicago",
        "Dayton",
        "Miamisburg",
        "North Granby"
      ],
      "states": [
        "CT",
        "IL",
        "OH"
      ],
      "fiscal_year": 2023,
      "naics_codes": [
        "54",
        "55"
      ],
      "postal_codes": [
        "06060",
        "45342",
        "60606"
      ],
      "total_denial": 24,
      "initial_denial": 12,
      "total_approval": 1426,
      "initial_approval": 579,
      "continuing_denial": 12,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5929_2023",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2023_row_005193",
        "sr_uscis_h1b_datahub_2023_row_005194",
        "sr_uscis_h1b_datahub_2023_row_005195",
        "sr_uscis_h1b_datahub_2023_row_005196",
        "sr_uscis_h1b_datahub_2023_row_005197",
        "sr_uscis_h1b_datahub_2023_row_005198",
        "sr_uscis_h1b_datahub_2023_row_005199",
        "sr_uscis_h1b_datahub_2023_row_005200"
      ],
      "continuing_approval": 847
    },
    {
      "cities": [
        "Chicago",
        "New York"
      ],
      "states": [
        "IL",
        "NY"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54",
        "99"
      ],
      "postal_codes": [
        "10022",
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_7592_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_010552",
        "sr_uscis_h1b_datahub_2017_row_010650",
        "sr_uscis_h1b_datahub_2017_row_010652"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 2,
      "initial_denial": 1,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_7592_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_011271",
        "sr_uscis_h1b_datahub_2018_row_011303"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago",
        "Miamisburg"
      ],
      "states": [
        "IL",
        "OH"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "45342",
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 14,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_7592_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_011230",
        "sr_uscis_h1b_datahub_2019_row_011231",
        "sr_uscis_h1b_datahub_2019_row_011327",
        "sr_uscis_h1b_datahub_2019_row_011369"
      ],
      "continuing_approval": 14
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_7592_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_008485"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2010,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_7929_2010",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2010_row_016696"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_7929_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_011692"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 9,
      "initial_approval": 1,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_7929_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_010392"
      ],
      "continuing_approval": 8
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_7929_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_011429"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_7929_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_008499"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2009,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 10,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_8544_2009",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2009_row_010389"
      ],
      "continuing_approval": 10
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_2959_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_014385"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_2959_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_011984"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5920_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_010666"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5920_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_011287"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5920_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_011343"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "Miamisburg"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "45342"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5920_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_008487"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago",
        "New York"
      ],
      "states": [
        "IL",
        "NY"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "10022",
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5959_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_011996",
        "sr_uscis_h1b_datahub_2016_row_011997"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "New York"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "10022"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5959_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_010681"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5959_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_011302"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5959_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_011367"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5292_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_010663"
      ],
      "continuing_approval": 4
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5292_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_011339"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_8929_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_011304"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_8929_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_011370"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_8929_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_009482"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_2929_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_008486"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2023,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_2929_2023",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2023_row_005192"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Dayton"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "45432"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_0354_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_005459"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Miamisburg"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "45342"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_0354_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_009350"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5500_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_020666"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5500_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_020486"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5500_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_008484"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "99"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5592_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_011341"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5592_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_009480"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5919_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_011342"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5925_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_010667"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5925_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_011345"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_9592_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_010685"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "99"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_9592_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_011371"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "99"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5923_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_011289"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "New York"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "99"
      ],
      "postal_codes": [
        "10022"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5909_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_010665"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5939_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_009352"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2011,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_3548_2011",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2011_row_011688"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5922_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_011288"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5922_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_011344"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_3929_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_010662"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5953_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_010679"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5862_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_012386"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5962_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_010682"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60603"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_6607_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_016691"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_6929_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_009353"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "New York"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "99"
      ],
      "postal_codes": [
        "10022"
      ],
      "total_denial": 4,
      "initial_denial": 4,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5792_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_010664"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5492_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_011340"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_4610_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_051061"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "New York"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "10022"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_8932_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_038787"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_9259_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_008500"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_9291_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_015652"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_5949_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_011366"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_9529_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_011305"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 2,
      "initial_denial": 1,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_america_inc_tax_4929_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_011296",
        "sr_uscis_h1b_datahub_2019_row_011338"
      ],
      "continuing_approval": 0
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "address_line_1": "333 West Wacker Drive",
      "address_line_2": "Suite 300",
      "raw_address": "333 West Wacker Drive Suite 300 CHICAGO IL 60606",
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60606",
      "filing_count": 747,
      "case_count": 747,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-31",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "address_line_1": "333 WEST WACKER DRIVE",
      "address_line_2": "SUITE 300",
      "raw_address": "333 WEST WACKER DRIVE SUITE 300 CHICAGO IL 60606",
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60606",
      "filing_count": 267,
      "case_count": 267,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "address_line_1": "333 W. Wacker Dr",
      "address_line_2": "Ste. 300",
      "raw_address": "333 W. Wacker Dr Ste. 300 CHICAGO IL 60606",
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60606",
      "filing_count": 41,
      "case_count": 41,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-31",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "CHICAGO IL 60606",
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60606",
      "filing_count": 56350,
      "case_count": 56350,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-09-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "60606 IL 60606",
      "city": "60606",
      "state": "IL",
      "postal_code": "60606",
      "filing_count": 6,
      "case_count": 6,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2020-12-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "CHICAGO IN 60606",
      "city": "Chicago",
      "state": "IN",
      "postal_code": "60606",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-06-09",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "SUITE 300 CHICAGO IL 60606",
      "city": "Suite 300 Chicago",
      "state": "IL",
      "postal_code": "60606",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-06-07",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "CHICAGO ID 60606",
      "city": "Chicago",
      "state": "ID",
      "postal_code": "60606",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-06-07",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "CHICAGO UT 60606",
      "city": "Chicago",
      "state": "UT",
      "postal_code": "60606",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-05-14",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "ROSEMONT IL 60018",
      "city": "Rosemont",
      "state": "IL",
      "postal_code": "60018",
      "filing_count": 54,
      "case_count": 54,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-01-29",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "SUITE 300 IL 60606",
      "city": "Suite 300",
      "state": "IL",
      "postal_code": "60606",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-08-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "CHICAGO IL 60018",
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60018",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-06-19",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "NEW YORK NY 10022",
      "city": "New York",
      "state": "NY",
      "postal_code": "10022",
      "filing_count": 10803,
      "case_count": 10803,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2016-12-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "CHICAGO IL 60603",
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60603",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-08-31",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "IRVING TX 75062",
      "city": "Irving",
      "state": "TX",
      "postal_code": "75062",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "address_line_1": "2500 Lake Cook Rd",
      "raw_address": "2500 Lake Cook Rd  RIVERWOODS IL 60015",
      "city": "Riverwoods",
      "state": "IL",
      "postal_code": "60015",
      "filing_count": 11,
      "case_count": 11,
      "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": "2500 Lake Cook Road",
      "raw_address": "2500 Lake Cook Road  RIVERWOODS IL 60015",
      "city": "Riverwoods",
      "state": "IL",
      "postal_code": "60015",
      "filing_count": 10,
      "case_count": 10,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-24",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "1 State Farm Plaza",
      "raw_address": "1 State Farm Plaza  BLOOMINGTON IL 61710",
      "city": "Bloomington",
      "state": "IL",
      "postal_code": "61710",
      "filing_count": 9,
      "case_count": 9,
      "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": "6303 Owensmouth Ave",
      "raw_address": "6303 Owensmouth Ave  WOODLAND HILLS CA 91367",
      "city": "Woodland Hills",
      "state": "CA",
      "postal_code": "91367",
      "filing_count": 9,
      "case_count": 9,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-12",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "3475 Piedmont Rd NE",
      "address_line_2": "Ste 1400",
      "raw_address": "3475 Piedmont Rd NE Ste 1400 ATLANTA GA 30305",
      "city": "Atlanta",
      "state": "GA",
      "postal_code": "30305",
      "filing_count": 8,
      "case_count": 8,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-01-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "333 W Wacker Dr",
      "address_line_2": "Ste 300",
      "raw_address": "333 W Wacker Dr Ste 300 CHICAGO IL 60606",
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60606",
      "filing_count": 7,
      "case_count": 7,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "1055 LPL Way",
      "raw_address": "1055 LPL Way  FORT MILL SC 29715",
      "city": "Fort Mill",
      "state": "SC",
      "postal_code": "29715",
      "filing_count": 7,
      "case_count": 7,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "100 New Millennium Way",
      "raw_address": "100 New Millennium Way  DURHAM NC 27709",
      "city": "Durham",
      "state": "NC",
      "postal_code": "27709",
      "filing_count": 7,
      "case_count": 7,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-24",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "1 Hartford Plaza",
      "raw_address": "1 Hartford Plaza  HARTFORD CT 06155",
      "city": "Hartford",
      "state": "CT",
      "postal_code": "06155",
      "filing_count": 7,
      "case_count": 7,
      "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": "300 Jefferson Park",
      "raw_address": "300 Jefferson Park  WHIPPANY NJ 07981",
      "city": "Whippany",
      "state": "NJ",
      "postal_code": "07981",
      "filing_count": 7,
      "case_count": 7,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "1800 Arch St",
      "raw_address": "1800 Arch St  PHILADELPHIA PA 19103",
      "city": "Philadelphia",
      "state": "PA",
      "postal_code": "19103",
      "filing_count": 6,
      "case_count": 6,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "5215 N O'Connor Blvd",
      "address_line_2": "Ste 250",
      "raw_address": "5215 N O'Connor Blvd Ste 250 IRVING TX 75039",
      "city": "Irving",
      "state": "TX",
      "postal_code": "75039",
      "filing_count": 6,
      "case_count": 6,
      "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": "1 Destiny Way",
      "raw_address": "1 Destiny Way  WESTLAKE TX 76262",
      "city": "Westlake",
      "state": "TX",
      "postal_code": "76262",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "6303 Owensmouth Ave",
      "address_line_2": "Flr 7",
      "raw_address": "6303 Owensmouth Ave Flr 7 WOODLAND HILLS CA 91367",
      "city": "Woodland Hills",
      "state": "CA",
      "postal_code": "91367",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-02",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "1 Spartan Way",
      "raw_address": "1 Spartan Way  MERRIMACK NH 03054",
      "city": "Merrimack",
      "state": "NH",
      "postal_code": "03054",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2025-12-11",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "110 N Carpenter St",
      "address_line_2": "Flr 5",
      "raw_address": "110 N Carpenter St Flr 5 CHICAGO IL 60607",
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60607",
      "filing_count": 4,
      "case_count": 4,
      "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": "333 West Wacker Drive",
      "address_line_2": "Ste 300",
      "raw_address": "333 West Wacker Drive Ste 300 CHICAGO IL 60606",
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60606",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "2675 MORGANTOWN RD",
      "raw_address": "2675 MORGANTOWN RD  READING PA 19607",
      "city": "Reading",
      "state": "PA",
      "postal_code": "19607",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-24",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "333 W Wacker Drive",
      "address_line_2": "Ste 300",
      "raw_address": "333 W Wacker Drive Ste 300 CHICAGO IL 60606",
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60606",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "2675 Morgantown Rd",
      "raw_address": "2675 Morgantown Rd  READING PA 19607",
      "city": "Reading",
      "state": "PA",
      "postal_code": "19607",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-02-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "1 New York Plaza",
      "address_line_2": "Flr 16",
      "raw_address": "1 New York Plaza Flr 16 NEW YORK NY 10004",
      "city": "New York",
      "state": "NY",
      "postal_code": "10004",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-02-18",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "300 JEFFERSON PARK",
      "raw_address": "300 JEFFERSON PARK  WHIPPANY NJ 07981",
      "city": "Whippany",
      "state": "NJ",
      "postal_code": "07981",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-01-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "2 Destiny Way",
      "raw_address": "2 Destiny Way  WESTLAKE TX 76262",
      "city": "Westlake",
      "state": "TX",
      "postal_code": "76262",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2025-11-19",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "250 Nicollet Mall",
      "raw_address": "250 Nicollet Mall  MINNEAPOLIS MN 55401",
      "city": "Minneapolis",
      "state": "MN",
      "postal_code": "55401",
      "filing_count": 3,
      "case_count": 3,
      "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": "1 Corporate Drive",
      "address_line_2": "Ste 1000",
      "raw_address": "1 Corporate Drive Ste 1000 SHELTON CT 06484",
      "city": "Shelton",
      "state": "CT",
      "postal_code": "06484",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "6305 Peachtree Dunwoody Rd",
      "raw_address": "6305 Peachtree Dunwoody Rd  ATLANTA GA 30328",
      "city": "Atlanta",
      "state": "GA",
      "postal_code": "30328",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "13736 Riverport Dr",
      "address_line_2": "Flr 4",
      "raw_address": "13736 Riverport Dr Flr 4 MARYLAND HEIGHTS MO 63043",
      "city": "Maryland Heights",
      "state": "MO",
      "postal_code": "63043",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "200 West Street",
      "raw_address": "200 West Street  NEW YORK NY 10282",
      "city": "New York",
      "state": "NY",
      "postal_code": "10282",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-12",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "200 S College St",
      "address_line_2": "Flr 13",
      "raw_address": "200 S College St Flr 13 CHARLOTTE NC 28202",
      "city": "Charlotte",
      "state": "NC",
      "postal_code": "28202",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "480 Washington Blvd",
      "raw_address": "480 Washington Blvd  JERSEY CITY NJ 07310",
      "city": "Jersey City",
      "state": "NJ",
      "postal_code": "07310",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "333 West Wacker Dr",
      "address_line_2": "Ste 300",
      "raw_address": "333 West Wacker Dr Ste 300 CHICAGO IL 60606",
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60606",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-09",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "5725 Innovation Drive",
      "raw_address": "5725 Innovation Drive  TROY MI 48098",
      "city": "Troy",
      "state": "MI",
      "postal_code": "48098",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-04",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "671 S High St",
      "address_line_2": "Flr 9",
      "raw_address": "671 S High St Flr 9 COLUMBUS OH 43206",
      "city": "Columbus",
      "state": "OH",
      "postal_code": "43206",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-02-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "776 HIGHWAY 74 S",
      "raw_address": "776 HIGHWAY 74 S  PEACHTREE CITY GA 30269",
      "city": "Peachtree City",
      "state": "GA",
      "postal_code": "30269",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-02-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "5051 WESTHEIMER RD STE 1800",
      "raw_address": "5051 WESTHEIMER RD STE 1800  HOUSTON TX 77056",
      "city": "Houston",
      "county": "Harris",
      "state": "TX",
      "postal_code": "77056",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-02-19",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "5051 Westheimer Road",
      "address_line_2": "Ste 2000",
      "raw_address": "5051 Westheimer Road Ste 2000 HOUSTON TX 77056",
      "city": "Houston",
      "county": "Harris",
      "state": "TX",
      "postal_code": "77056",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-02-18",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "2929 Walker Ave NW",
      "raw_address": "2929 Walker Ave NW  GRAND RAPIDS MI 49544",
      "city": "Grand Rapids",
      "state": "MI",
      "postal_code": "49544",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-02-05",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "1 New York Plaza",
      "address_line_2": "Flr 17",
      "raw_address": "1 New York Plaza Flr 17 NEW YORK NY 10004",
      "city": "New York",
      "state": "NY",
      "postal_code": "10004",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-02-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "3800 Citibank Center",
      "raw_address": "3800 Citibank Center  TAMPA FL 33610",
      "city": "Tampa",
      "state": "FL",
      "postal_code": "33610",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-01-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "5051 Westheimer Road",
      "address_line_2": "Ste 1800",
      "raw_address": "5051 Westheimer Road Ste 1800 HOUSTON TX 77056",
      "city": "Houston",
      "state": "TX",
      "postal_code": "77056",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-01-14",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "6655 Town Square",
      "address_line_2": "Flr 3",
      "raw_address": "6655 Town Square Flr 3 ALPHARETTA GA 30005",
      "city": "Alpharetta",
      "state": "GA",
      "postal_code": "30005",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-01-06",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "6303 Owensmouth Ave",
      "address_line_2": "Flr 9",
      "raw_address": "6303 Owensmouth Ave Flr 9 WOODLAND HILLS CA 91367",
      "city": "Woodland Hills",
      "state": "CA",
      "postal_code": "91367",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2025-11-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "400 Jefferson Park",
      "raw_address": "400 Jefferson Park  WHIPPANY NJ 07981",
      "city": "Whippany",
      "state": "NJ",
      "postal_code": "07981",
      "filing_count": 2,
      "case_count": 2,
      "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": "3475 Piedmont Rd",
      "address_line_2": "Ste 1400",
      "raw_address": "3475 Piedmont Rd Ste 1400 ATLANTA GA 30305",
      "city": "Atlanta",
      "state": "GA",
      "postal_code": "30305",
      "filing_count": 2,
      "case_count": 2,
      "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": "30 Rockefeller Plaza",
      "raw_address": "30 Rockefeller Plaza  NEW YORK NY 10112",
      "city": "New York",
      "state": "NY",
      "postal_code": "10112",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "1301 McKinney St",
      "address_line_2": "Ste 600",
      "raw_address": "1301 McKinney St Ste 600 HOUSTON TX 77010",
      "city": "Houston",
      "state": "TX",
      "postal_code": "77010",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "5600 Beechtree Ln SE",
      "raw_address": "5600 Beechtree Ln SE  CALEDONIA MI 49316",
      "city": "Caledonia",
      "state": "MI",
      "postal_code": "49316",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "6305 Peachtree Dunwoody Rd",
      "raw_address": "6305 Peachtree Dunwoody Rd  SANDY SPRINGS GA 30328",
      "city": "Sandy Springs",
      "state": "GA",
      "postal_code": "30328",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-25",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "2142 BOYCE STREET",
      "address_line_2": "Ste 201",
      "raw_address": "2142 BOYCE STREET Ste 201 COLUMBIA SC 29201",
      "city": "Columbia",
      "state": "SC",
      "postal_code": "29201",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "address_line_1": "79 5th Ave",
      "address_line_2": "Ste 300",
      "raw_address": "79 5th Ave Ste 300 NEW YORK NY 10003",
      "city": "New York",
      "state": "NY",
      "postal_code": "10003",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-03-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 15,
    "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": [
    "GA",
    "IL",
    "NY",
    "TX",
    "CA",
    "NC",
    "VA",
    "SC",
    "OH",
    "FL",
    "CT",
    "WI",
    "NJ",
    "MI",
    "MO",
    "PA",
    "MN",
    "TN",
    "UT",
    "WA",
    "MD",
    "DE",
    "KS",
    "IA",
    "MA",
    "CO",
    "IN",
    "AZ",
    "NV"
  ],
  "cities": [
    "Atlanta",
    "Riverwoods",
    "Chicago",
    "Bloomington",
    "New York",
    "Houston",
    "Woodland Hills",
    "Charlotte",
    "Rosemont",
    "Oak Brook",
    "Richmond",
    "Irving",
    "Universal City",
    "Cary",
    "Alpharetta",
    "Columbia",
    "Monterey Park",
    "Cincinnati",
    "Fort Mill",
    "Coral Springs",
    "Stamford",
    "San Jose",
    "Arlington Heights",
    "Madison",
    "Waukesha",
    "Orlando",
    "Schaumburg",
    "Jersey City",
    "Grand Rapids",
    "Mayfield Heights",
    "Mayfield Village",
    "Tampa",
    "Columbus",
    "Burbank",
    "Plano",
    "Whitehouse Station",
    "Richardson",
    "Mckinney",
    "Kansas City",
    "Whippany",
    "Malvern",
    "Peachtree City",
    "Southfield",
    "Minneapolis",
    "Nashville",
    "Miami",
    "Reading",
    "Berkeley Heights",
    "Englewood Cliffs",
    "Dearborn",
    "Windsor",
    "Warren",
    "Mayfield",
    "Jacksonville",
    "Philadelphia",
    "Milwaukee",
    "San Diego",
    "Frisco",
    "Wayne",
    "Norwalk",
    "Durham",
    "Long Island City",
    "San Ramon",
    "Saint Paul",
    "Salt Lake City",
    "Bothell",
    "Eden Prairie",
    "Kettering",
    "Hanover",
    "Melbourne",
    "Middletown",
    "Lynchburg",
    "Troy",
    "Franklin Lakes",
    "Wauwatosa",
    "Auburn Hills",
    "Hartford",
    "Shelton",
    "Wilmington",
    "Blue Ash",
    "Overland Park",
    "Eddystone",
    "Lincolnshire",
    "Santa Ana",
    "Elmhurst",
    "Sylmar",
    "Greenville",
    "Cedar Rapids",
    "Maryland Heights",
    "Dallas",
    "Hopkinton",
    "Elk Grove Village",
    "Bellevue",
    "Westlake",
    "Boston",
    "Bridgewater",
    "Fort Collins",
    "Fort Wayne",
    "Schenectady",
    "Oak Park Heights",
    "Fairfield",
    "Cumming",
    "Horsham",
    "Hoffman Estates",
    "Parsippany",
    "Wheeling",
    "Teaneck",
    "Minnetonka",
    "Mason",
    "Sparks",
    "Raritan",
    "Glastonbury",
    "Buffalo Grove",
    "Sacramento",
    "Riverview",
    "Downers Grove",
    "Indianapolis",
    "Lakewood",
    "Naperville",
    "West Bend",
    "Redmond",
    "Milford",
    "Santa Clara",
    "Bethlehem",
    "Fortmill",
    "Glen Allen",
    "Van Buren Twp",
    "Inver Grove Heights",
    "Montebello",
    "Henrico",
    "Glendale",
    "Las Vegas",
    "Lake Mary",
    "Datyon",
    "Dayton",
    "Des Plaines",
    "Mc Lean",
    "Miamisburg",
    "New Lebanon",
    "North Granby"
  ],
  "postal_codes": [
    "30305",
    "60015",
    "60606",
    "61791",
    "10019",
    "77056",
    "91367",
    "30328",
    "28262",
    "60018",
    "60523",
    "10004",
    "23234",
    "75039",
    "60661",
    "60604",
    "91608",
    "27513",
    "30005",
    "10036",
    "29201",
    "91755",
    "45215",
    "30339",
    "75063",
    "10003",
    "10020",
    "28202",
    "29715",
    "33065",
    "30326",
    "30313",
    "06902",
    "95134",
    "60004",
    "53783",
    "28244",
    "53188",
    "32819",
    "61710",
    "23230",
    "60196",
    "07302",
    "49544",
    "30303",
    "44124",
    "44143",
    "30346",
    "33610",
    "60607",
    "43215",
    "91505",
    "75024",
    "08889",
    "45202",
    "75082",
    "75070",
    "64108",
    "07981",
    "19355",
    "77041",
    "30269",
    "48033",
    "55402",
    "37214",
    "33157",
    "19607",
    "07922",
    "07632",
    "48126",
    "06095",
    "07310",
    "07059",
    "7981",
    "32258",
    "10007",
    "19103",
    "53204",
    "92123",
    "30004",
    "75034",
    "8889",
    "19087",
    "06851",
    "7302",
    "27709",
    "75062",
    "11120",
    "06905",
    "94583",
    "55112",
    "28263",
    "84116",
    "30308",
    "98021",
    "10005",
    "60601",
    "55344",
    "45420",
    "21076",
    "37203",
    "32904",
    "17057",
    "24504",
    "6902",
    "48083",
    "07417",
    "53226",
    "48326",
    "06155",
    "06484",
    "19803",
    "28217",
    "45242",
    "6095",
    "92108",
    "07311",
    "66202",
    "19022",
    "60069",
    "92705",
    "60126",
    "77073",
    "91342",
    "60173",
    "29615",
    "52411",
    "63043",
    "75236",
    "84123",
    "01748",
    "60007",
    "98006",
    "76262",
    "10282",
    "02210",
    "08807",
    "10022",
    "80528",
    "46835",
    "12345",
    "61704",
    "55082",
    "06828",
    "30040",
    "7632",
    "19044",
    "60192",
    "77019",
    "07306",
    "28277",
    "07054",
    "60090",
    "07666",
    "7311",
    "55345",
    "45040",
    "21152",
    "08869",
    "6033",
    "10112",
    "92121",
    "60089",
    "66211",
    "28282",
    "95814",
    "33578",
    "60515",
    "46240",
    "80215",
    "60563",
    "53095",
    "30309",
    "60611",
    "98052",
    "6461",
    "30338",
    "77010",
    "95054",
    "64105",
    "53203",
    "06033",
    "18017",
    "23059",
    "48111",
    "55077",
    "8807",
    "45241",
    "29708",
    "90640",
    "30342",
    "23233",
    "85308",
    "48093",
    "7417",
    "89118",
    "75035",
    "32771",
    "06060",
    "22102",
    "45342",
    "45345",
    "45390",
    "45401",
    "45402",
    "45406",
    "45432",
    "45441",
    "45449",
    "45459",
    "60137",
    "60505",
    "60544",
    "60603",
    "60605",
    "60608",
    "60654",
    "60660",
    "73301"
  ],
  "top_markets": [
    {
      "city": "Atlanta",
      "state": "GA",
      "postal_code": "30305",
      "lca_count": 2504,
      "role_title_count": 128,
      "wage_low_min": 50000,
      "wage_high_max": 306000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2026
    },
    {
      "city": "Riverwoods",
      "state": "IL",
      "postal_code": "60015",
      "lca_count": 2349,
      "role_title_count": 79,
      "wage_low_min": 39800,
      "wage_high_max": 185000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2026
    },
    {
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60606",
      "lca_count": 1440,
      "role_title_count": 68,
      "wage_low_min": 51000,
      "wage_high_max": 218400000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2026
    },
    {
      "city": "Bloomington",
      "state": "IL",
      "postal_code": "61791",
      "lca_count": 1149,
      "role_title_count": 45,
      "wage_low_min": 60000,
      "wage_high_max": 4009304,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2025
    },
    {
      "city": "New York",
      "state": "NY",
      "postal_code": "10019",
      "lca_count": 934,
      "role_title_count": 60,
      "wage_low_min": 60000,
      "wage_high_max": 200000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2026
    },
    {
      "city": "Houston",
      "state": "TX",
      "postal_code": "77056",
      "lca_count": 889,
      "role_title_count": 48,
      "wage_low_min": 60000,
      "wage_high_max": 220318,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2026
    },
    {
      "city": "Woodland Hills",
      "state": "CA",
      "postal_code": "91367",
      "lca_count": 787,
      "role_title_count": 61,
      "wage_low_min": 60000,
      "wage_high_max": 195293280,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2026
    },
    {
      "city": "Atlanta",
      "state": "GA",
      "postal_code": "30328",
      "lca_count": 773,
      "role_title_count": 59,
      "wage_low_min": 60000,
      "wage_high_max": 200000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2026
    },
    {
      "city": "Charlotte",
      "state": "NC",
      "postal_code": "28262",
      "lca_count": 764,
      "role_title_count": 62,
      "wage_low_min": 60000,
      "wage_high_max": 960000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2026
    },
    {
      "city": "Rosemont",
      "state": "IL",
      "postal_code": "60018",
      "lca_count": 760,
      "role_title_count": 91,
      "wage_low_min": 60000,
      "wage_high_max": 152332960,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2021
    }
  ]
}
Industry
{
  "naics_codes": [
    "54161",
    "31",
    "51",
    "52",
    "54",
    "55",
    "61",
    "92",
    "99"
  ],
  "naics_breakdown": [
    {
      "value": "5416",
      "filing_count": 32126,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "541512",
      "filing_count": 18037,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    },
    {
      "value": "541511",
      "filing_count": 867,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "54161",
      "filing_count": 202,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "541330",
      "filing_count": 2,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 39800,
  "annualized_high_max": 322400000,
  "annualized_low_avg": 121068.958452932
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 17050,
    "case_count": 17050,
    "role_title_count": 223,
    "worksite_count": 580,
    "wage_low_min": 50000,
    "wage_high_max": 306000,
    "wage_low_avg": 84201.7727859237
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 9715,
    "case_count": 9715,
    "role_title_count": 179,
    "worksite_count": 675,
    "wage_low_min": 51000,
    "wage_high_max": 229382,
    "wage_low_avg": 78252.8822439527
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 6739,
    "case_count": 6739,
    "role_title_count": 145,
    "worksite_count": 603,
    "wage_low_min": 48700,
    "wage_high_max": 228000,
    "wage_low_avg": 84440.1104021368
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 8412,
    "case_count": 8412,
    "role_title_count": 148,
    "worksite_count": 609,
    "wage_low_min": 39800,
    "wage_high_max": 301600000,
    "wage_low_avg": 125020.095815502
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q1",
    "lca_count": 1199,
    "case_count": 1199,
    "role_title_count": 83,
    "worksite_count": 291,
    "wage_low_min": 60000,
    "wage_high_max": 284128000,
    "wage_low_avg": 478402.594662219
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q2",
    "lca_count": 1346,
    "case_count": 1346,
    "role_title_count": 85,
    "worksite_count": 301,
    "wage_low_min": 60000,
    "wage_high_max": 231088,
    "wage_low_avg": 93072.1084695394
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 2027,
    "case_count": 2027,
    "role_title_count": 75,
    "worksite_count": 470,
    "wage_low_min": 60000,
    "wage_high_max": 195293280,
    "wage_low_avg": 186510.451406019
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q4",
    "lca_count": 1323,
    "case_count": 1323,
    "role_title_count": 61,
    "worksite_count": 463,
    "wage_low_min": 60000,
    "wage_high_max": 1222221,
    "wage_low_avg": 94075.6931216931
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q1",
    "lca_count": 406,
    "case_count": 406,
    "role_title_count": 54,
    "worksite_count": 224,
    "wage_low_min": 60000,
    "wage_high_max": 220318,
    "wage_low_avg": 97889.3054187192
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q2",
    "lca_count": 1175,
    "case_count": 1175,
    "role_title_count": 109,
    "worksite_count": 488,
    "wage_low_min": 60000,
    "wage_high_max": 251212,
    "wage_low_avg": 96441.9744680851
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 2558,
    "case_count": 2558,
    "role_title_count": 150,
    "worksite_count": 741,
    "wage_low_min": 60000,
    "wage_high_max": 152332960,
    "wage_low_avg": 154785.592259578
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q4",
    "lca_count": 807,
    "case_count": 807,
    "role_title_count": 70,
    "worksite_count": 428,
    "wage_low_min": 60000,
    "wage_high_max": 230000,
    "wage_low_avg": 102792.975216853
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q1",
    "lca_count": 924,
    "case_count": 924,
    "role_title_count": 73,
    "worksite_count": 408,
    "wage_low_min": 60000,
    "wage_high_max": 302400,
    "wage_low_avg": 106584.142857143
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q2",
    "lca_count": 843,
    "case_count": 843,
    "role_title_count": 76,
    "worksite_count": 400,
    "wage_low_min": 60000,
    "wage_high_max": 280000,
    "wage_low_avg": 105516.81257414
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q3",
    "lca_count": 1913,
    "case_count": 1913,
    "role_title_count": 96,
    "worksite_count": 512,
    "wage_low_min": 60000,
    "wage_high_max": 235000,
    "wage_low_avg": 99599.1082070047
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q4",
    "lca_count": 733,
    "case_count": 733,
    "role_title_count": 65,
    "worksite_count": 347,
    "wage_low_min": 60000,
    "wage_high_max": 1134000,
    "wage_low_avg": 112051.034106412
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q1",
    "lca_count": 561,
    "case_count": 561,
    "role_title_count": 50,
    "worksite_count": 282,
    "wage_low_min": 60000,
    "wage_high_max": 203663,
    "wage_low_avg": 110039.942959002
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q2",
    "lca_count": 1267,
    "case_count": 1267,
    "role_title_count": 71,
    "worksite_count": 465,
    "wage_low_min": 60000,
    "wage_high_max": 235000,
    "wage_low_avg": 106462.351223362
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q3",
    "lca_count": 1489,
    "case_count": 1489,
    "role_title_count": 73,
    "worksite_count": 449,
    "wage_low_min": 60000,
    "wage_high_max": 246688,
    "wage_low_avg": 102247.099395567
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q4",
    "lca_count": 794,
    "case_count": 794,
    "role_title_count": 64,
    "worksite_count": 319,
    "wage_low_min": 60000,
    "wage_high_max": 300000,
    "wage_low_avg": 124485.516372796
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q1",
    "lca_count": 752,
    "case_count": 752,
    "role_title_count": 55,
    "worksite_count": 312,
    "wage_low_min": 61500,
    "wage_high_max": 1621728,
    "wage_low_avg": 128470.668882979
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q2",
    "lca_count": 440,
    "case_count": 440,
    "role_title_count": 35,
    "worksite_count": 213,
    "wage_low_min": 70000,
    "wage_high_max": 215000,
    "wage_low_avg": 129102.677272727
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q3",
    "lca_count": 1089,
    "case_count": 1089,
    "role_title_count": 47,
    "worksite_count": 262,
    "wage_low_min": 75000,
    "wage_high_max": 218400000,
    "wage_low_avg": 323737.56932966
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q4",
    "lca_count": 788,
    "case_count": 788,
    "role_title_count": 51,
    "worksite_count": 335,
    "wage_low_min": 74000,
    "wage_high_max": 322400000,
    "wage_low_avg": 538538.628172589
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q1",
    "lca_count": 635,
    "case_count": 635,
    "role_title_count": 46,
    "worksite_count": 324,
    "wage_low_min": 80600,
    "wage_high_max": 220000,
    "wage_low_avg": 134645.656692913
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q2",
    "lca_count": 532,
    "case_count": 532,
    "role_title_count": 41,
    "worksite_count": 272,
    "wage_low_min": 60000,
    "wage_high_max": 265600,
    "wage_low_avg": 131963.82518797
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q3",
    "lca_count": 1062,
    "case_count": 1062,
    "role_title_count": 49,
    "worksite_count": 350,
    "wage_low_min": 74000,
    "wage_high_max": 245440000,
    "wage_low_avg": 358493.276836158
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q4",
    "lca_count": 650,
    "case_count": 650,
    "role_title_count": 44,
    "worksite_count": 285,
    "wage_low_min": 62500,
    "wage_high_max": 7800000,
    "wage_low_avg": 144543.62
  },
  {
    "fiscal_year": 2026,
    "quarter": "Q2",
    "lca_count": 1055,
    "case_count": 1055,
    "role_title_count": 54,
    "worksite_count": 412,
    "wage_low_min": 62500,
    "wage_high_max": 7800000,
    "wage_low_avg": 140870.225592417
  }
]
Links
{
  "roles": "/v1/roles?company=Capgemini%20America%2C%20Inc.",
  "wages": "/v1/wages?company=Capgemini%20America%2C%20Inc.",
  "trends": "/v1/trends?company=Capgemini%20America%2C%20Inc."
}

Frequently asked questions

Does Capgemini America, Inc. sponsor H-1B visas?
Yes. Capgemini America, Inc. filed 68,284 H-1B labor condition applications with the U.S. Department of Labor (FY2016-FY2026), of which 67,334 were certified. LCA filings are labor-condition applications certified by the U.S. Department of Labor, not active job postings or approved USCIS H-1B petitions.
How many H-1B applications has Capgemini America, Inc. filed?
Capgemini America, Inc. has 68,284 H-1B LCA filings on record spanning FY2016-FY2026 across 783 role titles and 2,769 worksites.
What roles does Capgemini America, Inc. sponsor for H-1B?
The most common H-1B role at Capgemini America, Inc. is Applications Consultant 2 (3,668 filings). Other frequent roles include Software Engineer 2, Test Consultant 2, Applications Consultant 3, Business Systems Analyst 2.
What wages does Capgemini America, Inc. offer H-1B workers?
For its most-sponsored role (Applications Consultant 2), Capgemini America, Inc. reported offered wages ranging from $58,900 to $960,000 in DOL LCA filings.
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=capgemini+america+inc&limit=5JSON