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

Home / Companies / Capgemini America, Inc.

Capgemini America, Inc. H-1B company data

Employer profile assembled from DOL OFLC LCA rows and USCIS H-1B Employer Data Hub petition summaries. Rows below include aliases, source IDs, filing coverage, petition counts, role coverage, worksite coverage, and wage summary fields when present.

EmployerLCA filingsRole titlesWorksitesCoverageUSCIS approvalsTop roleSourcesOpen
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
NOT APPLICABLE, CAPGEMINI AMERICA INCCapgemini 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
AliasesNOT APPLICABLE, CAPGEMINI AMERICA INC
Sourcesdol_oflc_lca, 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,
  "first_fiscal_year": 2016,
  "latest_fiscal_year": 2026,
  "latest_decision_date": "2026-03-31",
  "certified_count": 67334,
  "denied_count": 205
}
Petition Activity
{
  "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
    }
  ]
}
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"
  ]
}
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."
}
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