{
  "meta": {
    "api_version": "v2-draft",
    "generated_at": "2026-06-07T14:12:50.099Z",
    "implementation": "typescript_node",
    "source_backfill": "dol_oflc_lca_fy2016_fy2026q2_plus_uscis_h1b_archive"
  },
  "data": {
    "endpoint": "companies",
    "status": "warehouse_backed_lca_uscis_merged",
    "company_count": 10,
    "companies": [
      {
        "company_id": "company:microsoft",
        "name": "Microsoft Corporation",
        "normalized_name": "microsoft",
        "source_company_ids": [
          "company_dol_oflc_lca_microsoft_corporation",
          "company_dol_oflc_lca_microsoft",
          "company_uscis_h1b_datahub_microsoft_corporation_tax_4442",
          "company_uscis_h1b_datahub_microsoft_corp_tax_4442",
          "company_uscis_h1b_datahub_microsoft_corporation_tax_2808",
          "company_uscis_h1b_datahub_microsoft_corporation_tax_4444",
          "company_uscis_h1b_datahub_microsoft_tax_4442",
          "company_uscis_h1b_datahub_microsoft_corp_tax_1112",
          "company_uscis_h1b_datahub_microsoft_corporation_tax_1112",
          "company_uscis_h1b_datahub_microsoft_corporation_tax_4443",
          "company_uscis_h1b_datahub_microsoft_corp_tax_4444",
          "company_uscis_h1b_datahub_microsoft_corporation_tax_4421",
          "company_uscis_h1b_datahub_microsoft_corporation_tax_4424",
          "company_uscis_h1b_datahub_microsoft_corp_tax_4422",
          "company_uscis_h1b_datahub_microsoft_corp_tax_4142",
          "company_uscis_h1b_datahub_microsoft_corp_tax_4996",
          "company_uscis_h1b_datahub_microsoft_corporation_tax_4447",
          "company_uscis_h1b_datahub_microsoft_corporation_tax_4942",
          "company_uscis_h1b_datahub_microsoft_corporation_tax_9994",
          "company_uscis_h1b_datahub_microsoft_corporation_tax_2442",
          "company_uscis_h1b_datahub_microsoft_corporation_tax_1142",
          "company_uscis_h1b_datahub_microsoft_corporation_tax_4441",
          "company_uscis_h1b_datahub_microsoft_corporation_tax_4422",
          "company_uscis_h1b_datahub_microsoft_corporation_tax_4412",
          "company_uscis_h1b_datahub_microsoft_corporation_tax_4445"
        ],
        "source_names": [
          "Microsoft Corporation",
          "MICROSOFT",
          "MICROSOFT CORPORATION",
          "MICROSOFT CORP"
        ],
        "aliases": [
          "MICROSOFT",
          "MICROSOFT CORPORATION",
          "MICROSOFT CORP"
        ],
        "identifiers": [
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "4442",
            "source": "uscis_h1b_employer_data_hub"
          },
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "2808",
            "source": "uscis_h1b_employer_data_hub"
          },
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "4444",
            "source": "uscis_h1b_employer_data_hub"
          },
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "1112",
            "source": "uscis_h1b_employer_data_hub"
          },
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "4443",
            "source": "uscis_h1b_employer_data_hub"
          },
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "4421",
            "source": "uscis_h1b_employer_data_hub"
          },
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "4424",
            "source": "uscis_h1b_employer_data_hub"
          },
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "4422",
            "source": "uscis_h1b_employer_data_hub"
          },
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "4142",
            "source": "uscis_h1b_employer_data_hub"
          },
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "4996",
            "source": "uscis_h1b_employer_data_hub"
          },
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "4447",
            "source": "uscis_h1b_employer_data_hub"
          },
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "4942",
            "source": "uscis_h1b_employer_data_hub"
          },
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "9994",
            "source": "uscis_h1b_employer_data_hub"
          },
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "2442",
            "source": "uscis_h1b_employer_data_hub"
          },
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "1142",
            "source": "uscis_h1b_employer_data_hub"
          },
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "4441",
            "source": "uscis_h1b_employer_data_hub"
          },
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "4412",
            "source": "uscis_h1b_employer_data_hub"
          },
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "4445",
            "source": "uscis_h1b_employer_data_hub"
          }
        ],
        "sources": [
          "dol_oflc_lca",
          "uscis_h1b_employer_data_hub"
        ],
        "lca_activity": {
          "lca_count": 84321,
          "case_count": 84321,
          "role_title_count": 1623,
          "worksite_count": 2005,
          "first_fiscal_year": 2016,
          "latest_fiscal_year": 2026,
          "latest_decision_date": "2026-03-31",
          "certified_count": 84222,
          "denied_count": 42
        },
        "petition_activity": {
          "total_approval": 64132,
          "total_denial": 907,
          "fiscal_years": [
            "2009",
            "2010",
            "2011",
            "2012",
            "2013",
            "2014",
            "2015",
            "2016",
            "2017",
            "2018",
            "2019",
            "2020",
            "2021",
            "2022",
            "2023"
          ],
          "year_metrics": [
            {
              "cities": [
                "Redmond",
                "Redmond Attorney"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2009,
              "naics_codes": [
                "51",
                "54",
                "56"
              ],
              "postal_codes": [
                "98052",
                "98053",
                "98852"
              ],
              "total_denial": 26,
              "initial_denial": 7,
              "total_approval": 3262,
              "initial_approval": 1496,
              "continuing_denial": 19,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4442_2009",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2009_row_049516",
                "sr_uscis_h1b_datahub_2009_row_059559",
                "sr_uscis_h1b_datahub_2009_row_062037",
                "sr_uscis_h1b_datahub_2009_row_062038",
                "sr_uscis_h1b_datahub_2009_row_062039",
                "sr_uscis_h1b_datahub_2009_row_062040",
                "sr_uscis_h1b_datahub_2009_row_062042",
                "sr_uscis_h1b_datahub_2009_row_062043",
                "sr_uscis_h1b_datahub_2009_row_063152"
              ],
              "continuing_approval": 1766
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2010,
              "naics_codes": [
                "51",
                "54",
                "61"
              ],
              "postal_codes": [
                "98051",
                "98052"
              ],
              "total_denial": 16,
              "initial_denial": 8,
              "total_approval": 3661,
              "initial_approval": 1935,
              "continuing_denial": 8,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4442_2010",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2010_row_050001",
                "sr_uscis_h1b_datahub_2010_row_050002",
                "sr_uscis_h1b_datahub_2010_row_050003",
                "sr_uscis_h1b_datahub_2010_row_050004",
                "sr_uscis_h1b_datahub_2010_row_050084"
              ],
              "continuing_approval": 1726
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2011,
              "naics_codes": [
                "51",
                "54"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 3,
              "initial_approval": 3,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4442_2011",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2011_row_057166",
                "sr_uscis_h1b_datahub_2011_row_057177"
              ],
              "continuing_approval": 0
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2012,
              "naics_codes": [
                "11",
                "51",
                "54",
                "61"
              ],
              "postal_codes": [
                "98052",
                "98125"
              ],
              "total_denial": 33,
              "initial_denial": 2,
              "total_approval": 3297,
              "initial_approval": 1406,
              "continuing_denial": 31,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4442_2012",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2012_row_051504",
                "sr_uscis_h1b_datahub_2012_row_051513",
                "sr_uscis_h1b_datahub_2012_row_051514",
                "sr_uscis_h1b_datahub_2012_row_051515",
                "sr_uscis_h1b_datahub_2012_row_051516",
                "sr_uscis_h1b_datahub_2012_row_051517"
              ],
              "continuing_approval": 1891
            },
            {
              "cities": [
                "Redmond",
                "Renton"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2013,
              "naics_codes": [
                "51",
                "52"
              ],
              "postal_codes": [
                "98052",
                "98056",
                "98502"
              ],
              "total_denial": 30,
              "initial_denial": 5,
              "total_approval": 3884,
              "initial_approval": 1055,
              "continuing_denial": 25,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4442_2013",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2013_row_051322",
                "sr_uscis_h1b_datahub_2013_row_051331",
                "sr_uscis_h1b_datahub_2013_row_051332",
                "sr_uscis_h1b_datahub_2013_row_051337",
                "sr_uscis_h1b_datahub_2013_row_051338"
              ],
              "continuing_approval": 2829
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2014,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 25,
              "initial_denial": 6,
              "total_approval": 2973,
              "initial_approval": 897,
              "continuing_denial": 19,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4442_2014",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2014_row_052390",
                "sr_uscis_h1b_datahub_2014_row_052398",
                "sr_uscis_h1b_datahub_2014_row_052410",
                "sr_uscis_h1b_datahub_2014_row_052457",
                "sr_uscis_h1b_datahub_2014_row_053147"
              ],
              "continuing_approval": 2076
            },
            {
              "cities": [
                "Redmond",
                "Sammamish"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2015,
              "naics_codes": [
                "51",
                "54",
                "61"
              ],
              "postal_codes": [
                "98052",
                "98074"
              ],
              "total_denial": 42,
              "initial_denial": 12,
              "total_approval": 2819,
              "initial_approval": 968,
              "continuing_denial": 30,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4442_2015",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2015_row_011179",
                "sr_uscis_h1b_datahub_2015_row_045067",
                "sr_uscis_h1b_datahub_2015_row_045068",
                "sr_uscis_h1b_datahub_2015_row_045069",
                "sr_uscis_h1b_datahub_2015_row_045071"
              ],
              "continuing_approval": 1851
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2016,
              "naics_codes": [
                "51",
                "61"
              ],
              "postal_codes": [
                "98052",
                "98062"
              ],
              "total_denial": 75,
              "initial_denial": 11,
              "total_approval": 3652,
              "initial_approval": 1136,
              "continuing_denial": 64,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4442_2016",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2016_row_049408",
                "sr_uscis_h1b_datahub_2016_row_049412",
                "sr_uscis_h1b_datahub_2016_row_049414",
                "sr_uscis_h1b_datahub_2016_row_049415",
                "sr_uscis_h1b_datahub_2016_row_049777"
              ],
              "continuing_approval": 2516
            },
            {
              "cities": [
                "Los Angeles",
                "Redmond",
                "Santa Clara"
              ],
              "states": [
                "CA",
                "WA"
              ],
              "fiscal_year": 2017,
              "naics_codes": [
                "51",
                "54",
                "61"
              ],
              "postal_codes": [
                "90013",
                "95052",
                "95054",
                "98052",
                "98062"
              ],
              "total_denial": 82,
              "initial_denial": 18,
              "total_approval": 4086,
              "initial_approval": 1471,
              "continuing_denial": 64,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4442_2017",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2017_row_006034",
                "sr_uscis_h1b_datahub_2017_row_046318",
                "sr_uscis_h1b_datahub_2017_row_046321",
                "sr_uscis_h1b_datahub_2017_row_046322",
                "sr_uscis_h1b_datahub_2017_row_046323",
                "sr_uscis_h1b_datahub_2017_row_046325",
                "sr_uscis_h1b_datahub_2017_row_046326",
                "sr_uscis_h1b_datahub_2017_row_046327",
                "sr_uscis_h1b_datahub_2017_row_046328",
                "sr_uscis_h1b_datahub_2017_row_046376",
                "sr_uscis_h1b_datahub_2017_row_047009",
                "sr_uscis_h1b_datahub_2017_row_049376"
              ],
              "continuing_approval": 2615
            },
            {
              "cities": [
                "Bothell",
                "Redmond",
                "Santa Clara"
              ],
              "states": [
                "CA",
                "WA"
              ],
              "fiscal_year": 2018,
              "naics_codes": [
                "51",
                "54",
                "61"
              ],
              "postal_codes": [
                "95052",
                "98012",
                "98052",
                "98053"
              ],
              "total_denial": 67,
              "initial_denial": 13,
              "total_approval": 4458,
              "initial_approval": 1254,
              "continuing_denial": 54,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4442_2018",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2018_row_052321",
                "sr_uscis_h1b_datahub_2018_row_052322",
                "sr_uscis_h1b_datahub_2018_row_052323",
                "sr_uscis_h1b_datahub_2018_row_052324",
                "sr_uscis_h1b_datahub_2018_row_052325",
                "sr_uscis_h1b_datahub_2018_row_052326",
                "sr_uscis_h1b_datahub_2018_row_052380"
              ],
              "continuing_approval": 3204
            },
            {
              "cities": [
                "Olympia",
                "Redmond",
                "Santa Clara"
              ],
              "states": [
                "CA",
                "WA"
              ],
              "fiscal_year": 2019,
              "naics_codes": [
                "51",
                "54"
              ],
              "postal_codes": [
                "95052",
                "98052",
                "98502"
              ],
              "total_denial": 175,
              "initial_denial": 109,
              "total_approval": 5268,
              "initial_approval": 1704,
              "continuing_denial": 66,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4442_2019",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2019_row_055783",
                "sr_uscis_h1b_datahub_2019_row_055789",
                "sr_uscis_h1b_datahub_2019_row_055790",
                "sr_uscis_h1b_datahub_2019_row_055791",
                "sr_uscis_h1b_datahub_2019_row_055792",
                "sr_uscis_h1b_datahub_2019_row_055873"
              ],
              "continuing_approval": 3564
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2020,
              "naics_codes": [
                "33",
                "51",
                "52",
                "54",
                "56",
                "61"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 117,
              "initial_denial": 42,
              "total_approval": 6988,
              "initial_approval": 1789,
              "continuing_denial": 75,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4442_2020",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2020_row_031501",
                "sr_uscis_h1b_datahub_2020_row_031503",
                "sr_uscis_h1b_datahub_2020_row_031504",
                "sr_uscis_h1b_datahub_2020_row_031505",
                "sr_uscis_h1b_datahub_2020_row_031507",
                "sr_uscis_h1b_datahub_2020_row_031508",
                "sr_uscis_h1b_datahub_2020_row_031509",
                "sr_uscis_h1b_datahub_2020_row_031510",
                "sr_uscis_h1b_datahub_2020_row_031511"
              ],
              "continuing_approval": 5199
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2021,
              "naics_codes": [
                "51",
                "52"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 58,
              "initial_denial": 14,
              "total_approval": 6441,
              "initial_approval": 1240,
              "continuing_denial": 44,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4442_2021",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2021_row_034000",
                "sr_uscis_h1b_datahub_2021_row_034002",
                "sr_uscis_h1b_datahub_2021_row_034003"
              ],
              "continuing_approval": 5201
            },
            {
              "cities": [
                "Henderson",
                "Olympia",
                "Redmond"
              ],
              "states": [
                "NV",
                "WA"
              ],
              "fiscal_year": 2022,
              "naics_codes": [
                "21",
                "51",
                "54"
              ],
              "postal_codes": [
                "89052",
                "98052",
                "98502"
              ],
              "total_denial": 74,
              "initial_denial": 5,
              "total_approval": 7202,
              "initial_approval": 1008,
              "continuing_denial": 69,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4442_2022",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2022_row_034021",
                "sr_uscis_h1b_datahub_2022_row_034022",
                "sr_uscis_h1b_datahub_2022_row_034023",
                "sr_uscis_h1b_datahub_2022_row_034025",
                "sr_uscis_h1b_datahub_2022_row_034026",
                "sr_uscis_h1b_datahub_2022_row_034027",
                "sr_uscis_h1b_datahub_2022_row_034029",
                "sr_uscis_h1b_datahub_2022_row_034031"
              ],
              "continuing_approval": 6194
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2023,
              "naics_codes": [
                "51",
                "52"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 46,
              "initial_denial": 0,
              "total_approval": 2066,
              "initial_approval": 42,
              "continuing_denial": 46,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4442_2023",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2023_row_018718",
                "sr_uscis_h1b_datahub_2023_row_018719",
                "sr_uscis_h1b_datahub_2023_row_018720",
                "sr_uscis_h1b_datahub_2023_row_018721",
                "sr_uscis_h1b_datahub_2023_row_018722"
              ],
              "continuing_approval": 2024
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2009,
              "naics_codes": [
                "54"
              ],
              "postal_codes": [
                "98040",
                "98052",
                "98502"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 31,
              "initial_approval": 7,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corp_tax_4442_2009",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2009_row_061852",
                "sr_uscis_h1b_datahub_2009_row_062029",
                "sr_uscis_h1b_datahub_2009_row_062036",
                "sr_uscis_h1b_datahub_2009_row_062041",
                "sr_uscis_h1b_datahub_2009_row_062128",
                "sr_uscis_h1b_datahub_2009_row_062682"
              ],
              "continuing_approval": 24
            },
            {
              "cities": [
                "Olympia",
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2010,
              "naics_codes": [
                "51",
                "54"
              ],
              "postal_codes": [
                "98033",
                "98052",
                "98502"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 6,
              "initial_approval": 4,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corp_tax_4442_2010",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2010_row_048027",
                "sr_uscis_h1b_datahub_2010_row_049999",
                "sr_uscis_h1b_datahub_2010_row_050000",
                "sr_uscis_h1b_datahub_2010_row_050005",
                "sr_uscis_h1b_datahub_2010_row_050085",
                "sr_uscis_h1b_datahub_2010_row_050923"
              ],
              "continuing_approval": 2
            },
            {
              "cities": [
                "Preston",
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2011,
              "naics_codes": [
                "51",
                "61"
              ],
              "postal_codes": [
                "98050",
                "98052"
              ],
              "total_denial": 40,
              "initial_denial": 6,
              "total_approval": 3810,
              "initial_approval": 1403,
              "continuing_denial": 34,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corp_tax_4442_2011",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2011_row_036557",
                "sr_uscis_h1b_datahub_2011_row_057175",
                "sr_uscis_h1b_datahub_2011_row_057176",
                "sr_uscis_h1b_datahub_2011_row_057178",
                "sr_uscis_h1b_datahub_2011_row_057266"
              ],
              "continuing_approval": 2407
            },
            {
              "cities": [
                "Olympia",
                "Redmond",
                "Santa Clara"
              ],
              "states": [
                "CA",
                "WA"
              ],
              "fiscal_year": 2012,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "95054",
                "98052",
                "98502"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 135,
              "initial_approval": 105,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corp_tax_4442_2012",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2012_row_051511",
                "sr_uscis_h1b_datahub_2012_row_051512",
                "sr_uscis_h1b_datahub_2012_row_051518",
                "sr_uscis_h1b_datahub_2012_row_052315",
                "sr_uscis_h1b_datahub_2012_row_056220"
              ],
              "continuing_approval": 30
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2013,
              "naics_codes": [
                "51",
                "54",
                "61"
              ],
              "postal_codes": [
                "98052",
                "98056",
                "98059"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 5,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corp_tax_4442_2013",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2013_row_051333",
                "sr_uscis_h1b_datahub_2013_row_051334",
                "sr_uscis_h1b_datahub_2013_row_051335",
                "sr_uscis_h1b_datahub_2013_row_051336"
              ],
              "continuing_approval": 5
            },
            {
              "cities": [
                "Redmond",
                "San Francisco"
              ],
              "states": [
                "CA",
                "WA"
              ],
              "fiscal_year": 2014,
              "naics_codes": [
                "51",
                "54"
              ],
              "postal_codes": [
                "94105",
                "98052",
                "98252"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 4,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corp_tax_4442_2014",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2014_row_052395",
                "sr_uscis_h1b_datahub_2014_row_052399",
                "sr_uscis_h1b_datahub_2014_row_052400"
              ],
              "continuing_approval": 3
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "CA",
                "WA"
              ],
              "fiscal_year": 2015,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052",
                "98056"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 5,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corp_tax_4442_2015",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2015_row_045060",
                "sr_uscis_h1b_datahub_2015_row_045066",
                "sr_uscis_h1b_datahub_2015_row_045070",
                "sr_uscis_h1b_datahub_2015_row_045124",
                "sr_uscis_h1b_datahub_2015_row_045407"
              ],
              "continuing_approval": 4
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2016,
              "naics_codes": [
                "51",
                "54"
              ],
              "postal_codes": [
                "98052",
                "98082"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 10,
              "initial_approval": 6,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corp_tax_4442_2016",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2016_row_041415",
                "sr_uscis_h1b_datahub_2016_row_047415",
                "sr_uscis_h1b_datahub_2016_row_049413",
                "sr_uscis_h1b_datahub_2016_row_049416",
                "sr_uscis_h1b_datahub_2016_row_049469"
              ],
              "continuing_approval": 4
            },
            {
              "cities": [
                "Redmnd"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2017,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corp_tax_4442_2017",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2017_row_046324"
              ],
              "continuing_approval": 1
            },
            {
              "cities": [
                "Los Angeles",
                "Redmond",
                "San Francisco"
              ],
              "states": [
                "CA",
                "WA"
              ],
              "fiscal_year": 2018,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "90013",
                "94105",
                "98052"
              ],
              "total_denial": 1,
              "initial_denial": 1,
              "total_approval": 5,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corp_tax_4442_2018",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2018_row_020392",
                "sr_uscis_h1b_datahub_2018_row_052319",
                "sr_uscis_h1b_datahub_2018_row_052320",
                "sr_uscis_h1b_datahub_2018_row_052973"
              ],
              "continuing_approval": 4
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2020,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corp_tax_4442_2020",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2020_row_031498"
              ],
              "continuing_approval": 0
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2015,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 2,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_2808_2015",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2015_row_025919"
              ],
              "continuing_approval": 2
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2017,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 3,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_2808_2017",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2017_row_024628"
              ],
              "continuing_approval": 2
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2018,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 6,
              "initial_approval": 2,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_2808_2018",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2018_row_026835"
              ],
              "continuing_approval": 4
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2019,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 3,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_2808_2019",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2019_row_027137"
              ],
              "continuing_approval": 2
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2020,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 5,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_2808_2020",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2020_row_031500"
              ],
              "continuing_approval": 4
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2021,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 2,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_2808_2021",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2021_row_034001"
              ],
              "continuing_approval": 2
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2022,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_2808_2022",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2022_row_034024"
              ],
              "continuing_approval": 1
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2014,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4444_2014",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2014_row_052391"
              ],
              "continuing_approval": 1
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2017,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4444_2017",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2017_row_046319"
              ],
              "continuing_approval": 0
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2018,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4444_2018",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2018_row_052327"
              ],
              "continuing_approval": 1
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2019,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4444_2019",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2019_row_055794"
              ],
              "continuing_approval": 0
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2020,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 3,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4444_2020",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2020_row_031506",
                "sr_uscis_h1b_datahub_2020_row_031513"
              ],
              "continuing_approval": 3
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2018,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 3,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_tax_4442_2018",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2018_row_052313"
              ],
              "continuing_approval": 2
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2009,
              "naics_codes": [
                "54"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 2,
              "initial_approval": 2,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corp_tax_1112_2009",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2009_row_062035"
              ],
              "continuing_approval": 0
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2014,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corp_tax_1112_2014",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2014_row_052394"
              ],
              "continuing_approval": 0
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2013,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_1112_2013",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2013_row_051321"
              ],
              "continuing_approval": 0
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2014,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_1112_2014",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2014_row_052388"
              ],
              "continuing_approval": 0
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2018,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_1112_2018",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2018_row_052185"
              ],
              "continuing_approval": 1
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2019,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4443_2019",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2019_row_055793"
              ],
              "continuing_approval": 1
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2020,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4443_2020",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2020_row_031502"
              ],
              "continuing_approval": 1
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2022,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4443_2022",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2022_row_034030"
              ],
              "continuing_approval": 1
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2013,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corp_tax_4444_2013",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2013_row_051339"
              ],
              "continuing_approval": 1
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2019,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corp_tax_4444_2019",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2019_row_055784"
              ],
              "continuing_approval": 1
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2010,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4421_2010",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2010_row_049998"
              ],
              "continuing_approval": 1
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2020,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4421_2020",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2020_row_031512"
              ],
              "continuing_approval": 1
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2022,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 2,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4424_2022",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2022_row_034028"
              ],
              "continuing_approval": 2
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2011,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corp_tax_4422_2011",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2011_row_057174"
              ],
              "continuing_approval": 0
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2020,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corp_tax_4142_2020",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2020_row_031499"
              ],
              "continuing_approval": 1
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2018,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corp_tax_4996_2018",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2018_row_044046"
              ],
              "continuing_approval": 1
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2018,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4447_2018",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2018_row_052328"
              ],
              "continuing_approval": 1
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2015,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4942_2015",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2015_row_045072"
              ],
              "continuing_approval": 0
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2010,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_9994_2010",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2010_row_050026"
              ],
              "continuing_approval": 1
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2013,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_2442_2013",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2013_row_051329"
              ],
              "continuing_approval": 0
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2017,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_1142_2017",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2017_row_046317"
              ],
              "continuing_approval": 0
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2018,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4441_2018",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2018_row_052318"
              ],
              "continuing_approval": 1
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2022,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4422_2022",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2022_row_034020"
              ],
              "continuing_approval": 1
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2022,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4412_2022",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2022_row_034019"
              ],
              "continuing_approval": 1
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2022,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporation_tax_4445_2022",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2022_row_034032"
              ],
              "continuing_approval": 1
            }
          ]
        },
        "geography": {
          "states": [
            "WA",
            "CA",
            "TX",
            "GA",
            "NC",
            "NY",
            "MA",
            "OR",
            "IL",
            "ND",
            "VA",
            "FL",
            "NJ",
            "PA",
            "NV",
            "KS",
            "CO",
            "UT",
            "WI",
            "AR",
            "MN",
            "AZ",
            "MD",
            "OH"
          ],
          "cities": [
            "Redmond",
            "Bellevue",
            "Mountain View",
            "Irving",
            "Atlanta",
            "Issaquah",
            "Sunnyvale",
            "Charlotte",
            "New York",
            "Austin",
            "San Francisco",
            "Cambridge",
            "Morrisville",
            "Hillsboro",
            "Burlington",
            "San Jose",
            "Santa Clara",
            "Raleigh",
            "Chicago",
            "Fargo",
            "Bothell",
            "Reston",
            "Leander",
            "Houston",
            "Acton",
            "Irvine",
            "Fort Lauderdale",
            "Richardson",
            "Iselin",
            "San Diego",
            "Palo Alto",
            "Dallas",
            "Aliso Viejo",
            "Portland",
            "Malvern",
            "Milpitas",
            "Reno",
            "Seattle",
            "Pittsburgh",
            "Fremont",
            "Berkeley",
            "Overland Park",
            "Frisco",
            "Los Angeles",
            "Cary",
            "Fort Collins",
            "Sammamish",
            "Lehi",
            "Kirkland",
            "Madison",
            "Dublin",
            "Round Rock",
            "Downers Grove",
            "Bentonville",
            "Newark",
            "Edina",
            "Jersey City",
            "Cumming",
            "Minneapolis",
            "Alpharetta",
            "Plano",
            "Mckinney",
            "Union City",
            "Tempe",
            "Folsom",
            "Foster City",
            "Prosper",
            "Celina",
            "Durham",
            "Denver",
            "Cedar Park",
            "San Antonio",
            "Cupertino",
            "Maple Valley",
            "Georgetown",
            "Allen",
            "Monroe",
            "Ashburn",
            "Katy",
            "Sacramento",
            "Pflugerville",
            "Chevy Chase",
            "San Ramon",
            "Lake Stevens",
            "Northlake",
            "Liberty Hill",
            "Quincy",
            "Fairfax",
            "Long Island City",
            "Huntersville",
            "Aubrey",
            "Leesburg",
            "Elkridge",
            "Mill Creek",
            "Apex",
            "Little Elm",
            "Farmers Branch",
            "Tampa",
            "Secaucus",
            "Edison",
            "Everett",
            "Hutto",
            "Cincinnati",
            "Boston",
            "Suwanee",
            "Boulder",
            "Pleasanton",
            "Renton",
            "Henderson",
            "Olympia",
            "Redmond Attorney",
            "Preston",
            "Redmnd"
          ],
          "postal_codes": [
            "98052",
            "98004",
            "94043",
            "98008",
            "75039",
            "30363",
            "98029",
            "94089",
            "28273",
            "30309",
            "10036",
            "78759",
            "94103",
            "02142",
            "94085",
            "27560-9002",
            "98052-6399",
            "2142",
            "27560",
            "97006",
            "01803",
            "30308",
            "94085-3505",
            "95134",
            "95054",
            "27617-2025",
            "98007",
            "94104",
            "60601",
            "58104-3911",
            "10011",
            "98012",
            "10012",
            "20190",
            "78641",
            "77024",
            "1720",
            "92614",
            "94086",
            "58104",
            "33309",
            "75082",
            "08830",
            "30303",
            "92121",
            "94304",
            "10010",
            "27617",
            "75251",
            "92656",
            "01720",
            "95051",
            "98021",
            "97209",
            "19355",
            "95035",
            "94102",
            "89511",
            "98109",
            "30305",
            "94105",
            "75063",
            "97229",
            "15212-9988",
            "94538",
            "94704",
            "97124",
            "66223",
            "78717",
            "75035",
            "90094",
            "30308-3910",
            "98121",
            "27519",
            "80525",
            "98074",
            "98027",
            "8830",
            "84043",
            "94107",
            "98033",
            "53703",
            "94568",
            "96001",
            "78665",
            "60515",
            "72712",
            "94560",
            "55435",
            "07302",
            "30041",
            "94087",
            "55401",
            "30009",
            "30040",
            "75034",
            "07310",
            "94536",
            "75024",
            "75070",
            "97123",
            "10012-2713",
            "94587",
            "85281",
            "78701",
            "98101",
            "30328",
            "95630",
            "94404",
            "75078",
            "98034",
            "98005",
            "94040",
            "75009",
            "7310",
            "27703",
            "80237",
            "75225",
            "78613",
            "98006",
            "78245",
            "15212",
            "95050",
            "92618",
            "95014",
            "98038",
            "95126",
            "94539",
            "98122",
            "78628",
            "98011",
            "75013",
            "75071",
            "75033",
            "98272",
            "98075",
            "94555",
            "78727",
            "20148",
            "07306",
            "77494",
            "78758",
            "95814",
            "60611",
            "30004",
            "95129",
            "78660",
            "20815",
            "94582",
            "98258",
            "76226",
            "78642",
            "75038",
            "7302",
            "28277",
            "1803",
            "78681",
            "30009-7614",
            "94111",
            "92127",
            "95132",
            "98848",
            "22030",
            "10019",
            "11101",
            "28078",
            "94085-2810",
            "95136",
            "94702",
            "76227",
            "98107",
            "20175",
            "07102-2823",
            "21075",
            "94583",
            "10016",
            "28215",
            "27523",
            "75068",
            "75234",
            "78738",
            "33609",
            "07094",
            "08817",
            "98208",
            "78634",
            "75036",
            "75206",
            "78735",
            "45242",
            "10023",
            "02116",
            "30024",
            "80302",
            "20191",
            "94588",
            "98059",
            "89052",
            "90013",
            "95052",
            "98051",
            "98053",
            "98056",
            "98062",
            "98125",
            "98502",
            "98852",
            "98040",
            "98050",
            "98082",
            "98252"
          ],
          "top_markets": [
            {
              "city": "Redmond",
              "state": "WA",
              "postal_code": "98052",
              "lca_count": 52639,
              "role_title_count": 1124,
              "wage_low_min": 45677,
              "wage_high_max": 364000000,
              "first_fiscal_year": 2016,
              "latest_fiscal_year": 2026
            },
            {
              "city": "Bellevue",
              "state": "WA",
              "postal_code": "98004",
              "lca_count": 6320,
              "role_title_count": 260,
              "wage_low_min": 65000,
              "wage_high_max": 1463616,
              "first_fiscal_year": 2016,
              "latest_fiscal_year": 2026
            },
            {
              "city": "Mountain View",
              "state": "CA",
              "postal_code": "94043",
              "lca_count": 3212,
              "role_title_count": 173,
              "wage_low_min": 85842,
              "wage_high_max": 325000,
              "first_fiscal_year": 2016,
              "latest_fiscal_year": 2026
            },
            {
              "city": "Bellevue",
              "state": "WA",
              "postal_code": "98008",
              "lca_count": 2097,
              "role_title_count": 113,
              "wage_low_min": 78000,
              "wage_high_max": 249136,
              "first_fiscal_year": 2016,
              "latest_fiscal_year": 2026
            },
            {
              "city": "Irving",
              "state": "TX",
              "postal_code": "75039",
              "lca_count": 1363,
              "role_title_count": 130,
              "wage_low_min": 72500,
              "wage_high_max": 223900,
              "first_fiscal_year": 2016,
              "latest_fiscal_year": 2026
            },
            {
              "city": "Atlanta",
              "state": "GA",
              "postal_code": "30363",
              "lca_count": 1231,
              "role_title_count": 67,
              "wage_low_min": 80371,
              "wage_high_max": 241800,
              "first_fiscal_year": 2021,
              "latest_fiscal_year": 2026
            },
            {
              "city": "Issaquah",
              "state": "WA",
              "postal_code": "98029",
              "lca_count": 1090,
              "role_title_count": 107,
              "wage_low_min": 75500,
              "wage_high_max": 231724,
              "first_fiscal_year": 2016,
              "latest_fiscal_year": 2026
            },
            {
              "city": "Sunnyvale",
              "state": "CA",
              "postal_code": "94089",
              "lca_count": 822,
              "role_title_count": 59,
              "wage_low_min": 95430,
              "wage_high_max": 246000,
              "first_fiscal_year": 2016,
              "latest_fiscal_year": 2026
            },
            {
              "city": "Charlotte",
              "state": "NC",
              "postal_code": "28273",
              "lca_count": 641,
              "role_title_count": 77,
              "wage_low_min": 70000,
              "wage_high_max": 187190,
              "first_fiscal_year": 2016,
              "latest_fiscal_year": 2026
            },
            {
              "city": "Atlanta",
              "state": "GA",
              "postal_code": "30309",
              "lca_count": 581,
              "role_title_count": 42,
              "wage_low_min": 94000,
              "wage_high_max": 243200,
              "first_fiscal_year": 2020,
              "latest_fiscal_year": 2026
            }
          ]
        },
        "industry": {
          "naics_codes": [
            "513210",
            "5415",
            "11",
            "21",
            "33",
            "51",
            "52",
            "54",
            "56",
            "61"
          ]
        },
        "wage_summary": {
          "annualized_low_min": 45677,
          "annualized_high_max": 364000000,
          "annualized_low_avg": 106404.4197817835
        },
        "top_roles": [
          {
            "title": "SOFTWARE ENGINEER",
            "soc_code": "15-1132.00",
            "soc_title": "Software Developers, Applications",
            "lca_count": 15251,
            "wage_low_min": 85842,
            "wage_high_max": 288310
          },
          {
            "title": "SOFTWARE ENGINEERING",
            "soc_code": "15-1252.00",
            "soc_title": "Software Developers",
            "lca_count": 11371,
            "wage_low_min": 82971,
            "wage_high_max": 345945600
          },
          {
            "title": "SOFTWARE ENGINEER",
            "soc_code": "15-1132",
            "soc_title": "SOFTWARE DEVELOPERS, APPLICATIONS",
            "lca_count": 9423,
            "wage_low_min": 65728,
            "wage_high_max": 2006736
          },
          {
            "title": "SOFTWARE ENGINEER",
            "soc_code": "15-1252.00",
            "soc_title": "Software Developers",
            "lca_count": 9333,
            "wage_low_min": 83325,
            "wage_high_max": 364000000
          },
          {
            "title": "SENIOR SOFTWARE ENGINEER",
            "soc_code": "15-1132",
            "soc_title": "SOFTWARE DEVELOPERS, APPLICATIONS",
            "lca_count": 2694,
            "wage_low_min": 111500,
            "wage_high_max": 200282
          },
          {
            "title": "DATA AND APPLIED SCIENTIST",
            "soc_code": "15-1111.00",
            "soc_title": "Computer and Information Research Scientists",
            "lca_count": 1495,
            "wage_low_min": 104000,
            "wage_high_max": 245500
          },
          {
            "title": "PROGRAM MANAGER",
            "soc_code": "15-1132",
            "soc_title": "SOFTWARE DEVELOPERS, APPLICATIONS",
            "lca_count": 839,
            "wage_low_min": 84739,
            "wage_high_max": 224500
          },
          {
            "title": "Data Science",
            "soc_code": "15-2051.00",
            "soc_title": "Data Scientists",
            "lca_count": 768,
            "wage_low_min": 109100,
            "wage_high_max": 277980
          },
          {
            "title": "SENIOR PROGRAM MANAGER",
            "soc_code": "15-1132",
            "soc_title": "SOFTWARE DEVELOPERS, APPLICATIONS",
            "lca_count": 730,
            "wage_low_min": 108000,
            "wage_high_max": 203501
          },
          {
            "title": "Applied Sciences",
            "soc_code": "15-2051.00",
            "soc_title": "Data Scientists",
            "lca_count": 709,
            "wage_low_min": 117180,
            "wage_high_max": 270623
          }
        ],
        "trend": [
          {
            "fiscal_year": 2016,
            "quarter": "Q2",
            "lca_count": 5029,
            "case_count": 5029,
            "role_title_count": 520,
            "worksite_count": 149,
            "wage_low_min": 65000,
            "wage_high_max": 180000,
            "wage_low_avg": 128674.428116922
          },
          {
            "fiscal_year": 2017,
            "quarter": "Q2",
            "lca_count": 5005,
            "case_count": 5005,
            "role_title_count": 518,
            "worksite_count": 143,
            "wage_low_min": 45677,
            "wage_high_max": 185100,
            "wage_low_avg": 132628.787212787
          },
          {
            "fiscal_year": 2018,
            "quarter": "Q2",
            "lca_count": 5552,
            "case_count": 5552,
            "role_title_count": 520,
            "worksite_count": 131,
            "wage_low_min": 65728,
            "wage_high_max": 185000,
            "wage_low_avg": 138288.623378963
          },
          {
            "fiscal_year": 2019,
            "quarter": "Q2",
            "lca_count": 6041,
            "case_count": 6041,
            "role_title_count": 337,
            "worksite_count": 135,
            "wage_low_min": 52000,
            "wage_high_max": 2006736,
            "wage_low_avg": 97175.7649006625
          },
          {
            "fiscal_year": 2020,
            "quarter": "Q1",
            "lca_count": 2190,
            "case_count": 2190,
            "role_title_count": 167,
            "worksite_count": 75,
            "wage_low_min": 77126,
            "wage_high_max": 336290,
            "wage_low_avg": 144914.183105023
          },
          {
            "fiscal_year": 2020,
            "quarter": "Q2",
            "lca_count": 1944,
            "case_count": 1944,
            "role_title_count": 138,
            "worksite_count": 63,
            "wage_low_min": 70000,
            "wage_high_max": 263400,
            "wage_low_avg": 144651.618312757
          },
          {
            "fiscal_year": 2020,
            "quarter": "Q3",
            "lca_count": 2410,
            "case_count": 2410,
            "role_title_count": 117,
            "worksite_count": 81,
            "wage_low_min": 92000,
            "wage_high_max": 275000,
            "wage_low_avg": 143506.51659751
          },
          {
            "fiscal_year": 2020,
            "quarter": "Q4",
            "lca_count": 1460,
            "case_count": 1460,
            "role_title_count": 116,
            "worksite_count": 119,
            "wage_low_min": 70000,
            "wage_high_max": 250000,
            "wage_low_avg": 149934.933561644
          },
          {
            "fiscal_year": 2021,
            "quarter": "Q1",
            "lca_count": 1024,
            "case_count": 1024,
            "role_title_count": 99,
            "worksite_count": 139,
            "wage_low_min": 73500,
            "wage_high_max": 255360,
            "wage_low_avg": 137628.1015625
          },
          {
            "fiscal_year": 2021,
            "quarter": "Q2",
            "lca_count": 3410,
            "case_count": 3410,
            "role_title_count": 185,
            "worksite_count": 261,
            "wage_low_min": 72500,
            "wage_high_max": 255360,
            "wage_low_avg": 141932.583577713
          },
          {
            "fiscal_year": 2021,
            "quarter": "Q3",
            "lca_count": 5491,
            "case_count": 5491,
            "role_title_count": 227,
            "worksite_count": 343,
            "wage_low_min": 72500,
            "wage_high_max": 260000,
            "wage_low_avg": 143222.569477327
          },
          {
            "fiscal_year": 2021,
            "quarter": "Q4",
            "lca_count": 1838,
            "case_count": 1838,
            "role_title_count": 133,
            "worksite_count": 165,
            "wage_low_min": 81000,
            "wage_high_max": 246360,
            "wage_low_avg": 153229.364526659
          },
          {
            "fiscal_year": 2022,
            "quarter": "Q1",
            "lca_count": 2154,
            "case_count": 2154,
            "role_title_count": 142,
            "worksite_count": 217,
            "wage_low_min": 65000,
            "wage_high_max": 285000,
            "wage_low_avg": 154962.421077066
          },
          {
            "fiscal_year": 2022,
            "quarter": "Q2",
            "lca_count": 3841,
            "case_count": 3841,
            "role_title_count": 229,
            "worksite_count": 369,
            "wage_low_min": 72500,
            "wage_high_max": 288310,
            "wage_low_avg": 146198.642801354
          },
          {
            "fiscal_year": 2022,
            "quarter": "Q3",
            "lca_count": 3426,
            "case_count": 3426,
            "role_title_count": 187,
            "worksite_count": 389,
            "wage_low_min": 86500,
            "wage_high_max": 310000,
            "wage_low_avg": 151620.442790426
          },
          {
            "fiscal_year": 2022,
            "quarter": "Q4",
            "lca_count": 2126,
            "case_count": 2126,
            "role_title_count": 145,
            "worksite_count": 252,
            "wage_low_min": 86500,
            "wage_high_max": 1976400,
            "wage_low_avg": 160240.346190028
          },
          {
            "fiscal_year": 2023,
            "quarter": "Q1",
            "lca_count": 1792,
            "case_count": 1792,
            "role_title_count": 114,
            "worksite_count": 204,
            "wage_low_min": 93600,
            "wage_high_max": 290000,
            "wage_low_avg": 168930.40234375
          },
          {
            "fiscal_year": 2023,
            "quarter": "Q2",
            "lca_count": 3666,
            "case_count": 3666,
            "role_title_count": 138,
            "worksite_count": 318,
            "wage_low_min": 93600,
            "wage_high_max": 310000,
            "wage_low_avg": 168738.651118385
          },
          {
            "fiscal_year": 2023,
            "quarter": "Q3",
            "lca_count": 2241,
            "case_count": 2241,
            "role_title_count": 96,
            "worksite_count": 227,
            "wage_low_min": 90600,
            "wage_high_max": 260530,
            "wage_low_avg": 160300.468987059
          },
          {
            "fiscal_year": 2023,
            "quarter": "Q4",
            "lca_count": 1912,
            "case_count": 1912,
            "role_title_count": 99,
            "worksite_count": 232,
            "wage_low_min": 73125,
            "wage_high_max": 274600,
            "wage_low_avg": 162950.117154812
          },
          {
            "fiscal_year": 2024,
            "quarter": "Q1",
            "lca_count": 1579,
            "case_count": 1579,
            "role_title_count": 79,
            "worksite_count": 170,
            "wage_low_min": 83700,
            "wage_high_max": 364000000,
            "wage_low_avg": 395026.227359088
          },
          {
            "fiscal_year": 2024,
            "quarter": "Q2",
            "lca_count": 1936,
            "case_count": 1936,
            "role_title_count": 97,
            "worksite_count": 202,
            "wage_low_min": 87616,
            "wage_high_max": 292300,
            "wage_low_avg": 166825.827995868
          },
          {
            "fiscal_year": 2024,
            "quarter": "Q3",
            "lca_count": 3135,
            "case_count": 3135,
            "role_title_count": 106,
            "worksite_count": 315,
            "wage_low_min": 83700,
            "wage_high_max": 273780,
            "wage_low_avg": 160859.602551834
          },
          {
            "fiscal_year": 2024,
            "quarter": "Q4",
            "lca_count": 2842,
            "case_count": 2842,
            "role_title_count": 83,
            "worksite_count": 341,
            "wage_low_min": 91600,
            "wage_high_max": 286270,
            "wage_low_avg": 167915.357846587
          },
          {
            "fiscal_year": 2025,
            "quarter": "Q1",
            "lca_count": 2569,
            "case_count": 2569,
            "role_title_count": 81,
            "worksite_count": 360,
            "wage_low_min": 77958,
            "wage_high_max": 284000,
            "wage_low_avg": 170832.890618918
          },
          {
            "fiscal_year": 2025,
            "quarter": "Q2",
            "lca_count": 2193,
            "case_count": 2193,
            "role_title_count": 85,
            "worksite_count": 297,
            "wage_low_min": 79331,
            "wage_high_max": 275000,
            "wage_low_avg": 172466.146830825
          },
          {
            "fiscal_year": 2025,
            "quarter": "Q3",
            "lca_count": 2715,
            "case_count": 2715,
            "role_title_count": 105,
            "worksite_count": 314,
            "wage_low_min": 89900,
            "wage_high_max": 314000,
            "wage_low_avg": 170020.048987109
          },
          {
            "fiscal_year": 2025,
            "quarter": "Q4",
            "lca_count": 1885,
            "case_count": 1885,
            "role_title_count": 66,
            "worksite_count": 207,
            "wage_low_min": 77958,
            "wage_high_max": 289585,
            "wage_low_avg": 175355.471618037
          },
          {
            "fiscal_year": 2026,
            "quarter": "Q2",
            "lca_count": 2915,
            "case_count": 2915,
            "role_title_count": 90,
            "worksite_count": 326,
            "wage_low_min": 90896,
            "wage_high_max": 345945600,
            "wage_low_avg": 301733.659691252
          }
        ],
        "links": {
          "roles": "/v1/roles?company=Microsoft%20Corporation",
          "wages": "/v1/wages?company=Microsoft%20Corporation",
          "trends": "/v1/trends?company=Microsoft%20Corporation"
        }
      },
      {
        "company_id": "company:microsoft operations puerto rico",
        "name": "MICROSOFT OPERATIONS PUERTO RICO, LLC",
        "normalized_name": "microsoft operations puerto rico",
        "source_company_ids": [
          "company_dol_oflc_lca_microsoft_operations_puerto_rico_llc"
        ],
        "source_names": [
          "MICROSOFT OPERATIONS PUERTO RICO, LLC"
        ],
        "aliases": [],
        "identifiers": [],
        "sources": [
          "dol_oflc_lca"
        ],
        "lca_activity": {
          "lca_count": 13,
          "case_count": 13,
          "role_title_count": 7,
          "worksite_count": 5,
          "first_fiscal_year": 2017,
          "latest_fiscal_year": 2019,
          "latest_decision_date": "2019-03-18",
          "certified_count": 12,
          "denied_count": 1
        },
        "petition_activity": {
          "total_approval": 0,
          "total_denial": 0,
          "fiscal_years": [],
          "year_metrics": []
        },
        "geography": {
          "states": [
            "PR"
          ],
          "cities": [
            "Humacao",
            "Gaynabo",
            "Guaynabo"
          ],
          "postal_codes": [
            "00791",
            "00968",
            "00969-3368",
            "00791-4734"
          ],
          "top_markets": [
            {
              "city": "Humacao",
              "state": "PR",
              "postal_code": "00791",
              "lca_count": 9,
              "role_title_count": 5,
              "wage_low_min": 86500,
              "wage_high_max": 0,
              "first_fiscal_year": 2017,
              "latest_fiscal_year": 2018
            },
            {
              "city": "Gaynabo",
              "state": "PR",
              "postal_code": "00968",
              "lca_count": 1,
              "role_title_count": 1,
              "wage_low_min": 93300,
              "wage_high_max": 0,
              "first_fiscal_year": 2017,
              "latest_fiscal_year": 2017
            },
            {
              "city": "Guaynabo",
              "state": "PR",
              "postal_code": "00968",
              "lca_count": 1,
              "role_title_count": 1,
              "wage_low_min": 93300,
              "wage_high_max": 0,
              "first_fiscal_year": 2017,
              "latest_fiscal_year": 2017
            },
            {
              "city": "Guaynabo",
              "state": "PR",
              "postal_code": "00969-3368",
              "lca_count": 1,
              "role_title_count": 1,
              "wage_low_min": 94400,
              "wage_high_max": 0,
              "first_fiscal_year": 2018,
              "latest_fiscal_year": 2018
            },
            {
              "city": "Humacao",
              "state": "PR",
              "postal_code": "00791-4734",
              "lca_count": 1,
              "role_title_count": 1,
              "wage_low_min": 102270,
              "wage_high_max": 102270,
              "first_fiscal_year": 2019,
              "latest_fiscal_year": 2019
            }
          ]
        },
        "industry": {
          "naics_codes": [
            "51121"
          ]
        },
        "wage_summary": {
          "annualized_low_min": 86500,
          "annualized_high_max": 102270,
          "annualized_low_avg": 105915
        },
        "top_roles": [
          {
            "title": "LOGISTICS MANAGER",
            "soc_code": "13-1081",
            "lca_count": 3,
            "wage_low_min": 87875,
            "wage_high_max": 0
          },
          {
            "title": "SR. SOFTWARE ENGINEER",
            "soc_code": "15-1132",
            "lca_count": 3,
            "wage_low_min": 136800,
            "wage_high_max": 0
          },
          {
            "title": "SENIOR PREMIER FIELD ENGINEER",
            "soc_code": "15-1121",
            "lca_count": 2,
            "wage_low_min": 93300,
            "wage_high_max": 0
          },
          {
            "title": "SENIOR PREMIER FIELD ENGINEER DYNAMICS AX",
            "soc_code": "15-1121",
            "lca_count": 1,
            "wage_low_min": 94400,
            "wage_high_max": 0
          },
          {
            "title": "SENIOR SOFTWARE ENGINEER",
            "soc_code": "15-1132",
            "lca_count": 1,
            "wage_low_min": 136800,
            "wage_high_max": 0
          },
          {
            "title": "SERVICE ENGINEER",
            "soc_code": "15-1121",
            "lca_count": 1,
            "wage_low_min": 94400,
            "wage_high_max": 0
          },
          {
            "title": "SERVICE ENGINEER",
            "soc_code": "15-1199",
            "soc_title": "COMPUTER OCCUPATIONS, ALL OTHER",
            "lca_count": 1,
            "wage_low_min": 102270,
            "wage_high_max": 102270
          },
          {
            "title": "SERVICE ENGINEER 2",
            "soc_code": "15-1121",
            "lca_count": 1,
            "wage_low_min": 86500,
            "wage_high_max": 0
          }
        ],
        "trend": [
          {
            "fiscal_year": 2017,
            "quarter": "Q2",
            "lca_count": 8,
            "case_count": 8,
            "role_title_count": 4,
            "worksite_count": 3,
            "wage_low_min": 86500,
            "wage_high_max": 0,
            "wage_low_avg": 107406.25
          },
          {
            "fiscal_year": 2018,
            "quarter": "Q2",
            "lca_count": 4,
            "case_count": 4,
            "role_title_count": 4,
            "worksite_count": 2,
            "wage_low_min": 89775,
            "wage_high_max": 0,
            "wage_low_avg": 103843.75
          },
          {
            "fiscal_year": 2019,
            "quarter": "Q2",
            "lca_count": 1,
            "case_count": 1,
            "role_title_count": 1,
            "worksite_count": 1,
            "wage_low_min": 102270,
            "wage_high_max": 102270,
            "wage_low_avg": 102270
          }
        ],
        "links": {
          "roles": "/v1/roles?company=MICROSOFT%20OPERATIONS%20PUERTO%20RICO%2C%20LLC",
          "wages": "/v1/wages?company=MICROSOFT%20OPERATIONS%20PUERTO%20RICO%2C%20LLC",
          "trends": "/v1/trends?company=MICROSOFT%20OPERATIONS%20PUERTO%20RICO%2C%20LLC"
        }
      },
      {
        "company_id": "company:microsoft licensing gp",
        "name": "MICROSOFT LICENSING GP",
        "normalized_name": "microsoft licensing gp",
        "source_company_ids": [
          "company_uscis_h1b_datahub_microsoft_licensing_gp_tax_3249",
          "company_uscis_h1b_datahub_microsoft_licensing_gp_tax_4442"
        ],
        "source_names": [
          "MICROSOFT LICENSING GP"
        ],
        "aliases": [
          "MICROSOFT LICENSING GP"
        ],
        "identifiers": [
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "3249",
            "source": "uscis_h1b_employer_data_hub"
          },
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "4442",
            "source": "uscis_h1b_employer_data_hub"
          }
        ],
        "sources": [
          "uscis_h1b_employer_data_hub"
        ],
        "lca_activity": {
          "lca_count": 0,
          "case_count": 0,
          "role_title_count": null,
          "worksite_count": null,
          "first_fiscal_year": null,
          "latest_fiscal_year": null,
          "latest_decision_date": null,
          "certified_count": 0,
          "denied_count": 0
        },
        "petition_activity": {
          "total_approval": 22,
          "total_denial": 1,
          "fiscal_years": [
            "2009",
            "2010",
            "2011",
            "2012",
            "2013",
            "2014"
          ],
          "year_metrics": [
            {
              "cities": [
                "Redmond",
                "Reno"
              ],
              "states": [
                "NV",
                "WA"
              ],
              "fiscal_year": 2009,
              "naics_codes": [
                "54"
              ],
              "postal_codes": [
                "89502",
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 3,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_licensing_gp_tax_3249_2009",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2009_row_061573",
                "sr_uscis_h1b_datahub_2009_row_061574"
              ],
              "continuing_approval": 2
            },
            {
              "cities": [
                "Redmond",
                "Reno"
              ],
              "states": [
                "NV",
                "WA"
              ],
              "fiscal_year": 2010,
              "naics_codes": [
                "51",
                "54"
              ],
              "postal_codes": [
                "89502",
                "89511",
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 5,
              "initial_approval": 3,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_licensing_gp_tax_3249_2010",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2010_row_049594",
                "sr_uscis_h1b_datahub_2010_row_049595",
                "sr_uscis_h1b_datahub_2010_row_049596",
                "sr_uscis_h1b_datahub_2010_row_049597",
                "sr_uscis_h1b_datahub_2010_row_049598"
              ],
              "continuing_approval": 2
            },
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2011,
              "naics_codes": [
                "51",
                "54"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 6,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_licensing_gp_tax_3249_2011",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2011_row_056688",
                "sr_uscis_h1b_datahub_2011_row_056689"
              ],
              "continuing_approval": 5
            },
            {
              "cities": [
                "Redmond",
                "Reno"
              ],
              "states": [
                "NV",
                "WA"
              ],
              "fiscal_year": 2012,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "89511",
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 4,
              "initial_approval": 3,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_licensing_gp_tax_3249_2012",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2012_row_050990",
                "sr_uscis_h1b_datahub_2012_row_050991"
              ],
              "continuing_approval": 1
            },
            {
              "cities": [
                "Redmond",
                "Reno"
              ],
              "states": [
                "NV",
                "WA"
              ],
              "fiscal_year": 2013,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "89511",
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 3,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_licensing_gp_tax_3249_2013",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2013_row_050714",
                "sr_uscis_h1b_datahub_2013_row_050715"
              ],
              "continuing_approval": 3
            },
            {
              "cities": [
                "Reno"
              ],
              "states": [
                "NV"
              ],
              "fiscal_year": 2014,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "89511"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_licensing_gp_tax_3249_2014",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2014_row_051754"
              ],
              "continuing_approval": 1
            },
            {
              "cities": [
                "Reno"
              ],
              "states": [
                "NV"
              ],
              "fiscal_year": 2014,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "89511"
              ],
              "total_denial": 1,
              "initial_denial": 0,
              "total_approval": 0,
              "initial_approval": 0,
              "continuing_denial": 1,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_licensing_gp_tax_4442_2014",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2014_row_052397"
              ],
              "continuing_approval": 0
            }
          ]
        },
        "geography": {
          "states": [
            "NV",
            "WA"
          ],
          "cities": [
            "Redmond",
            "Reno"
          ],
          "postal_codes": [
            "89502",
            "89511",
            "98052"
          ],
          "top_markets": []
        },
        "industry": {
          "naics_codes": [
            "51",
            "54"
          ]
        },
        "wage_summary": {
          "annualized_low_min": null,
          "annualized_high_max": null,
          "annualized_low_avg": null
        },
        "top_roles": [],
        "trend": [],
        "links": {
          "roles": "/v1/roles?company=MICROSOFT%20LICENSING%20GP",
          "wages": "/v1/wages?company=MICROSOFT%20LICENSING%20GP",
          "trends": "/v1/trends?company=MICROSOFT%20LICENSING%20GP"
        }
      },
      {
        "company_id": "company:microsoft ops puerto rico",
        "name": "MICROSOFT OPS PUERTO RICO LLC",
        "normalized_name": "microsoft ops puerto rico",
        "source_company_ids": [
          "company_uscis_h1b_datahub_microsoft_ops_puerto_rico_llc_tax_9037"
        ],
        "source_names": [
          "MICROSOFT OPS PUERTO RICO LLC"
        ],
        "aliases": [
          "MICROSOFT OPS PUERTO RICO LLC"
        ],
        "identifiers": [
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "9037",
            "source": "uscis_h1b_employer_data_hub"
          }
        ],
        "sources": [
          "uscis_h1b_employer_data_hub"
        ],
        "lca_activity": {
          "lca_count": 0,
          "case_count": 0,
          "role_title_count": null,
          "worksite_count": null,
          "first_fiscal_year": null,
          "latest_fiscal_year": null,
          "latest_decision_date": null,
          "certified_count": 0,
          "denied_count": 0
        },
        "petition_activity": {
          "total_approval": 4,
          "total_denial": 0,
          "fiscal_years": [
            "2014",
            "2017"
          ],
          "year_metrics": [
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2014,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 2,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_ops_puerto_rico_llc_tax_9037_2014",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2014_row_056296"
              ],
              "continuing_approval": 1
            },
            {
              "cities": [
                "Humacao"
              ],
              "states": [
                "PR"
              ],
              "fiscal_year": 2017,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "00791"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 2,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_ops_puerto_rico_llc_tax_9037_2017",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2017_row_049541"
              ],
              "continuing_approval": 1
            }
          ]
        },
        "geography": {
          "states": [
            "PR",
            "WA"
          ],
          "cities": [
            "Humacao",
            "Redmond"
          ],
          "postal_codes": [
            "00791",
            "98052"
          ],
          "top_markets": []
        },
        "industry": {
          "naics_codes": [
            "51"
          ]
        },
        "wage_summary": {
          "annualized_low_min": null,
          "annualized_high_max": null,
          "annualized_low_avg": null
        },
        "top_roles": [],
        "trend": [],
        "links": {
          "roles": "/v1/roles?company=MICROSOFT%20OPS%20PUERTO%20RICO%20LLC",
          "wages": "/v1/wages?company=MICROSOFT%20OPS%20PUERTO%20RICO%20LLC",
          "trends": "/v1/trends?company=MICROSOFT%20OPS%20PUERTO%20RICO%20LLC"
        }
      },
      {
        "company_id": "company:microsoft online",
        "name": "MICROSOFT ONLINE INC",
        "normalized_name": "microsoft online",
        "source_company_ids": [
          "company_uscis_h1b_datahub_microsoft_online_inc_tax_0505"
        ],
        "source_names": [
          "MICROSOFT ONLINE INC"
        ],
        "aliases": [
          "MICROSOFT ONLINE INC"
        ],
        "identifiers": [
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "0505",
            "source": "uscis_h1b_employer_data_hub"
          }
        ],
        "sources": [
          "uscis_h1b_employer_data_hub"
        ],
        "lca_activity": {
          "lca_count": 0,
          "case_count": 0,
          "role_title_count": null,
          "worksite_count": null,
          "first_fiscal_year": null,
          "latest_fiscal_year": null,
          "latest_decision_date": null,
          "certified_count": 0,
          "denied_count": 0
        },
        "petition_activity": {
          "total_approval": 3,
          "total_denial": 0,
          "fiscal_years": [
            "2011"
          ],
          "year_metrics": [
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2011,
              "naics_codes": [
                "51",
                "54"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 3,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_online_inc_tax_0505_2011",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2011_row_054300",
                "sr_uscis_h1b_datahub_2011_row_054301"
              ],
              "continuing_approval": 2
            }
          ]
        },
        "geography": {
          "states": [
            "WA"
          ],
          "cities": [
            "Redmond"
          ],
          "postal_codes": [
            "98052"
          ],
          "top_markets": []
        },
        "industry": {
          "naics_codes": [
            "51",
            "54"
          ]
        },
        "wage_summary": {
          "annualized_low_min": null,
          "annualized_high_max": null,
          "annualized_low_avg": null
        },
        "top_roles": [],
        "trend": [],
        "links": {
          "roles": "/v1/roles?company=MICROSOFT%20ONLINE%20INC",
          "wages": "/v1/wages?company=MICROSOFT%20ONLINE%20INC",
          "trends": "/v1/trends?company=MICROSOFT%20ONLINE%20INC"
        }
      },
      {
        "company_id": "company:microsoft open technologies",
        "name": "MICROSOFT OPEN TECHNOLOGIES INC",
        "normalized_name": "microsoft open technologies",
        "source_company_ids": [
          "company_uscis_h1b_datahub_microsoft_open_technologies_inc_tax_0760"
        ],
        "source_names": [
          "MICROSOFT OPEN TECHNOLOGIES INC"
        ],
        "aliases": [
          "MICROSOFT OPEN TECHNOLOGIES INC"
        ],
        "identifiers": [
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "0760",
            "source": "uscis_h1b_employer_data_hub"
          }
        ],
        "sources": [
          "uscis_h1b_employer_data_hub"
        ],
        "lca_activity": {
          "lca_count": 0,
          "case_count": 0,
          "role_title_count": null,
          "worksite_count": null,
          "first_fiscal_year": null,
          "latest_fiscal_year": null,
          "latest_decision_date": null,
          "certified_count": 0,
          "denied_count": 0
        },
        "petition_activity": {
          "total_approval": 2,
          "total_denial": 0,
          "fiscal_years": [
            "2013"
          ],
          "year_metrics": [
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2013,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 2,
              "initial_approval": 1,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_open_technologies_inc_tax_0760_2013",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2013_row_034512"
              ],
              "continuing_approval": 1
            }
          ]
        },
        "geography": {
          "states": [
            "WA"
          ],
          "cities": [
            "Redmond"
          ],
          "postal_codes": [
            "98052"
          ],
          "top_markets": []
        },
        "industry": {
          "naics_codes": [
            "51"
          ]
        },
        "wage_summary": {
          "annualized_low_min": null,
          "annualized_high_max": null,
          "annualized_low_avg": null
        },
        "top_roles": [],
        "trend": [],
        "links": {
          "roles": "/v1/roles?company=MICROSOFT%20OPEN%20TECHNOLOGIES%20INC",
          "wages": "/v1/wages?company=MICROSOFT%20OPEN%20TECHNOLOGIES%20INC",
          "trends": "/v1/trends?company=MICROSOFT%20OPEN%20TECHNOLOGIES%20INC"
        }
      },
      {
        "company_id": "company:microsoft payments",
        "name": "MICROSOFT PAYMENTS INC",
        "normalized_name": "microsoft payments",
        "source_company_ids": [
          "company_uscis_h1b_datahub_microsoft_payments_inc_tax_4001"
        ],
        "source_names": [
          "MICROSOFT PAYMENTS INC"
        ],
        "aliases": [
          "MICROSOFT PAYMENTS INC"
        ],
        "identifiers": [
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "4001",
            "source": "uscis_h1b_employer_data_hub"
          }
        ],
        "sources": [
          "uscis_h1b_employer_data_hub"
        ],
        "lca_activity": {
          "lca_count": 0,
          "case_count": 0,
          "role_title_count": null,
          "worksite_count": null,
          "first_fiscal_year": null,
          "latest_fiscal_year": null,
          "latest_decision_date": null,
          "certified_count": 0,
          "denied_count": 0
        },
        "petition_activity": {
          "total_approval": 2,
          "total_denial": 0,
          "fiscal_years": [
            "2012"
          ],
          "year_metrics": [
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2012,
              "naics_codes": [
                "52"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 2,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_payments_inc_tax_4001_2012",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2012_row_034747"
              ],
              "continuing_approval": 2
            }
          ]
        },
        "geography": {
          "states": [
            "WA"
          ],
          "cities": [
            "Redmond"
          ],
          "postal_codes": [
            "98052"
          ],
          "top_markets": []
        },
        "industry": {
          "naics_codes": [
            "52"
          ]
        },
        "wage_summary": {
          "annualized_low_min": null,
          "annualized_high_max": null,
          "annualized_low_avg": null
        },
        "top_roles": [],
        "trend": [],
        "links": {
          "roles": "/v1/roles?company=MICROSOFT%20PAYMENTS%20INC",
          "wages": "/v1/wages?company=MICROSOFT%20PAYMENTS%20INC",
          "trends": "/v1/trends?company=MICROSOFT%20PAYMENTS%20INC"
        }
      },
      {
        "company_id": "company:microsoft caribbean",
        "name": "MICROSOFT CARIBBEAN INC",
        "normalized_name": "microsoft caribbean",
        "source_company_ids": [
          "company_uscis_h1b_datahub_microsoft_caribbean_inc_tax_0503"
        ],
        "source_names": [
          "MICROSOFT CARIBBEAN INC"
        ],
        "aliases": [
          "MICROSOFT CARIBBEAN INC"
        ],
        "identifiers": [
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "0503",
            "source": "uscis_h1b_employer_data_hub"
          }
        ],
        "sources": [
          "uscis_h1b_employer_data_hub"
        ],
        "lca_activity": {
          "lca_count": 0,
          "case_count": 0,
          "role_title_count": null,
          "worksite_count": null,
          "first_fiscal_year": null,
          "latest_fiscal_year": null,
          "latest_decision_date": null,
          "certified_count": 0,
          "denied_count": 0
        },
        "petition_activity": {
          "total_approval": 1,
          "total_denial": 0,
          "fiscal_years": [
            "2012"
          ],
          "year_metrics": [
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2012,
              "naics_codes": [
                "99"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_caribbean_inc_tax_0503_2012",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2012_row_051630"
              ],
              "continuing_approval": 1
            }
          ]
        },
        "geography": {
          "states": [
            "WA"
          ],
          "cities": [
            "Redmond"
          ],
          "postal_codes": [
            "98052"
          ],
          "top_markets": []
        },
        "industry": {
          "naics_codes": [
            "99"
          ]
        },
        "wage_summary": {
          "annualized_low_min": null,
          "annualized_high_max": null,
          "annualized_low_avg": null
        },
        "top_roles": [],
        "trend": [],
        "links": {
          "roles": "/v1/roles?company=MICROSOFT%20CARIBBEAN%20INC",
          "wages": "/v1/wages?company=MICROSOFT%20CARIBBEAN%20INC",
          "trends": "/v1/trends?company=MICROSOFT%20CARIBBEAN%20INC"
        }
      },
      {
        "company_id": "company:microsoft corporatioin",
        "name": "MICROSOFT CORPORATIOIN",
        "normalized_name": "microsoft corporatioin",
        "source_company_ids": [
          "company_uscis_h1b_datahub_microsoft_corporatioin_tax_4422"
        ],
        "source_names": [
          "MICROSOFT CORPORATIOIN"
        ],
        "aliases": [
          "MICROSOFT CORPORATIOIN"
        ],
        "identifiers": [
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "4422",
            "source": "uscis_h1b_employer_data_hub"
          }
        ],
        "sources": [
          "uscis_h1b_employer_data_hub"
        ],
        "lca_activity": {
          "lca_count": 0,
          "case_count": 0,
          "role_title_count": null,
          "worksite_count": null,
          "first_fiscal_year": null,
          "latest_fiscal_year": null,
          "latest_decision_date": null,
          "certified_count": 0,
          "denied_count": 0
        },
        "petition_activity": {
          "total_approval": 1,
          "total_denial": 0,
          "fiscal_years": [
            "2019"
          ],
          "year_metrics": [
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2019,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corporatioin_tax_4422_2019",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2019_row_055788"
              ],
              "continuing_approval": 1
            }
          ]
        },
        "geography": {
          "states": [
            "WA"
          ],
          "cities": [
            "Redmond"
          ],
          "postal_codes": [
            "98052"
          ],
          "top_markets": []
        },
        "industry": {
          "naics_codes": [
            "51"
          ]
        },
        "wage_summary": {
          "annualized_low_min": null,
          "annualized_high_max": null,
          "annualized_low_avg": null
        },
        "top_roles": [],
        "trend": [],
        "links": {
          "roles": "/v1/roles?company=MICROSOFT%20CORPORATIOIN",
          "wages": "/v1/wages?company=MICROSOFT%20CORPORATIOIN",
          "trends": "/v1/trends?company=MICROSOFT%20CORPORATIOIN"
        }
      },
      {
        "company_id": "company:microsoft corportion",
        "name": "MICROSOFT CORPORTION",
        "normalized_name": "microsoft corportion",
        "source_company_ids": [
          "company_uscis_h1b_datahub_microsoft_corportion_tax_4444"
        ],
        "source_names": [
          "MICROSOFT CORPORTION"
        ],
        "aliases": [
          "MICROSOFT CORPORTION"
        ],
        "identifiers": [
          {
            "identifier_type": "tax_id_last_four",
            "identifier_value": "4444",
            "source": "uscis_h1b_employer_data_hub"
          }
        ],
        "sources": [
          "uscis_h1b_employer_data_hub"
        ],
        "lca_activity": {
          "lca_count": 0,
          "case_count": 0,
          "role_title_count": null,
          "worksite_count": null,
          "first_fiscal_year": null,
          "latest_fiscal_year": null,
          "latest_decision_date": null,
          "certified_count": 0,
          "denied_count": 0
        },
        "petition_activity": {
          "total_approval": 1,
          "total_denial": 0,
          "fiscal_years": [
            "2022"
          ],
          "year_metrics": [
            {
              "cities": [
                "Redmond"
              ],
              "states": [
                "WA"
              ],
              "fiscal_year": 2022,
              "naics_codes": [
                "51"
              ],
              "postal_codes": [
                "98052"
              ],
              "total_denial": 0,
              "initial_denial": 0,
              "total_approval": 1,
              "initial_approval": 0,
              "continuing_denial": 0,
              "petition_count_id": "petition_count_uscis_h1b_archive_microsoft_corportion_tax_4444_2022",
              "source_record_ids": [
                "sr_uscis_h1b_datahub_2022_row_034033"
              ],
              "continuing_approval": 1
            }
          ]
        },
        "geography": {
          "states": [
            "WA"
          ],
          "cities": [
            "Redmond"
          ],
          "postal_codes": [
            "98052"
          ],
          "top_markets": []
        },
        "industry": {
          "naics_codes": [
            "51"
          ]
        },
        "wage_summary": {
          "annualized_low_min": null,
          "annualized_high_max": null,
          "annualized_low_avg": null
        },
        "top_roles": [],
        "trend": [],
        "links": {
          "roles": "/v1/roles?company=MICROSOFT%20CORPORTION",
          "wages": "/v1/wages?company=MICROSOFT%20CORPORTION",
          "trends": "/v1/trends?company=MICROSOFT%20CORPORTION"
        }
      }
    ],
    "notes": [
      "Companies merge loaded DOL LCA activity with USCIS Employer Data Hub petition summaries by normalized name matching.",
      "LCA company identity is source-scoped; entity resolution is intentionally exposed through aliases and source_names.",
      "ZIP/postal code, city, and state are the route-level location contract; source street fields are optional evidence when present."
    ]
  }
}