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

Home / Companies / Williams College

Williams College H-1B company data

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

EmployerLCA filingsRole titlesWorksitesCoverageUSCIS approvalsTop roleSourcesOpen
Williams College
WILLIAMS COLLEGE
87494FY2016 to FY2026
Latest decision 2026-03-25
88Assistant Professor of Statistics
4 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings87
Certified LCAs86
Denied LCAs0
Role titles49
Worksites4
Latest decision2026-03-25
USCIS approvals88
USCIS denials1

Aliases and source names

AliasesSource NamesSources
WILLIAMS COLLEGEWilliams College, WILLIAMS COLLEGEdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
Assistant Professor of Statistics25-1022.00
Mathematical Science Teachers, Postsecondary
4$99,590$111,000
Assistant Professor of Art25-1121.00
Art, Drama, and Music Teachers, Postsecondary
3$89,240$91,000
Assistant Professor of English25-1123.00
English Language and Literature Teachers, Postsecondary
3$91,000$93,000
Business Information Analyst15-1217.00
Computer Systems Analysts, Non R&D
3$116,770$6,280,560
ASSISTANT DIRECTOR FOR INTERNATIONAL RECRUITMENT11-90332$56,000$0
Assistant Professor25-1121.00
Art, Drama, and Music Teachers, Postsecondary
2$58,670$108,000
Assistant Professor of Computer Science25-1021.00
Computer Science Teachers, Postsecondary
2$110,000$127,441
ASSISTANT PROFESSOR OF HISTORY25-11252$79,750$0
Assistant Professor of Mathematics25-1022.00
Mathematical Science Teachers, Postsecondary
2$77,500$100,800
ASSISTANT PROFESSOR OF PHYSICS25-1054
PHYSICS TEACHERS, POSTSECONDARY
2$77,600$77,600

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
WilliamstownMA01267563521,9106,280,5602,0162,026
WilliamstownMA1267241848,000133,1202,0192,022
WilliamstownMA021675554,080103,0002,0162,025
WilliamstownMA21672270,00087,7002,0202,022

Full company payload

Company IDcompany:williams college
NameWilliams College
Normalized Namewilliams college
Source Company Idscompany_dol_oflc_lca_williams_college, company_uscis_h1b_datahub_williams_college_tax_4847
Source NamesWilliams College, WILLIAMS COLLEGE
AliasesWILLIAMS COLLEGE
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "4847",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 87,
  "case_count": 87,
  "role_title_count": 49,
  "worksite_count": 4,
  "first_fiscal_year": 2016,
  "latest_fiscal_year": 2026,
  "latest_decision_date": "2026-03-25",
  "certified_count": 86,
  "denied_count": 0
}
Petition Activity
{
  "total_approval": 88,
  "total_denial": 1,
  "fiscal_years": [
    "2009",
    "2010",
    "2011",
    "2012",
    "2013",
    "2014",
    "2015",
    "2016",
    "2017",
    "2018",
    "2019",
    "2020",
    "2021",
    "2022",
    "2023"
  ],
  "year_metrics": [
    {
      "cities": [
        "Boston"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2009,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "02210"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_williams_college_tax_4847_2009",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2009_row_002121"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Boston",
        "Williamstown"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2010,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "01267",
        "02210"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_williams_college_tax_4847_2010",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2010_row_001429",
        "sr_uscis_h1b_datahub_2010_row_001430"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Williamstown"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2011,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "01267"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_williams_college_tax_4847_2011",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2011_row_001521"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Williamstown"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "01267"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 5,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_williams_college_tax_4847_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_001278"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Boston",
        "Williamstown"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2013,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "01267",
        "02210"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_williams_college_tax_4847_2013",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2013_row_001213",
        "sr_uscis_h1b_datahub_2013_row_001214"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Boston",
        "Williamstown"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "01267",
        "02210"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 8,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_williams_college_tax_4847_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_001129",
        "sr_uscis_h1b_datahub_2014_row_001130"
      ],
      "continuing_approval": 5
    },
    {
      "cities": [
        "Williamstown"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "01267"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 5,
      "initial_approval": 4,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_williams_college_tax_4847_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_000913"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Williamstown"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "01267"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 8,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_williams_college_tax_4847_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_000977"
      ],
      "continuing_approval": 6
    },
    {
      "cities": [
        "Williamstown"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "01267"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 9,
      "initial_approval": 6,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_williams_college_tax_4847_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_000868"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "Williamstown"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "01267"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 4,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_williams_college_tax_4847_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_000931"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Williamstown"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "01267"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_williams_college_tax_4847_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_001053"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Williamstown"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "01267"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 8,
      "initial_approval": 6,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_williams_college_tax_4847_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_053811"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Williamstown"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "01267",
        "1267"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 14,
      "initial_approval": 10,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_williams_college_tax_4847_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_059161",
        "sr_uscis_h1b_datahub_2021_row_059162"
      ],
      "continuing_approval": 4
    },
    {
      "cities": [
        "Williamstown"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "01267"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 7,
      "initial_approval": 5,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_williams_college_tax_4847_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_058461"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Williamstown"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2023,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "01267"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_williams_college_tax_4847_2023",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2023_row_032467",
        "sr_uscis_h1b_datahub_2023_row_032468"
      ],
      "continuing_approval": 0
    }
  ]
}
Geography
{
  "states": [
    "MA"
  ],
  "cities": [
    "Williamstown",
    "Boston"
  ],
  "postal_codes": [
    "01267",
    "1267",
    "02167",
    "2167",
    "02210"
  ],
  "top_markets": [
    {
      "city": "Williamstown",
      "state": "MA",
      "postal_code": "01267",
      "lca_count": 56,
      "role_title_count": 35,
      "wage_low_min": 21910,
      "wage_high_max": 6280560,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2026
    },
    {
      "city": "Williamstown",
      "state": "MA",
      "postal_code": "1267",
      "lca_count": 24,
      "role_title_count": 18,
      "wage_low_min": 48000,
      "wage_high_max": 133120,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2022
    },
    {
      "city": "Williamstown",
      "state": "MA",
      "postal_code": "02167",
      "lca_count": 5,
      "role_title_count": 5,
      "wage_low_min": 54080,
      "wage_high_max": 103000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2025
    },
    {
      "city": "Williamstown",
      "state": "MA",
      "postal_code": "2167",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 70000,
      "wage_high_max": 87700,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2022
    }
  ]
}
Industry
{
  "naics_codes": [
    "611310",
    "61"
  ]
}
Wage Summary
{
  "annualized_low_min": 21910,
  "annualized_high_max": 6280560,
  "annualized_low_avg": 153878.977011494
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 8,
    "case_count": 8,
    "role_title_count": 8,
    "worksite_count": 2,
    "wage_low_min": 53000,
    "wage_high_max": 81120,
    "wage_low_avg": 60887.5
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 11,
    "case_count": 11,
    "role_title_count": 10,
    "worksite_count": 1,
    "wage_low_min": 21910,
    "wage_high_max": 0,
    "wage_low_avg": 64091.8181818182
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 4,
    "worksite_count": 1,
    "wage_low_min": 46000,
    "wage_high_max": 0,
    "wage_low_avg": 71750
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 5,
    "case_count": 5,
    "role_title_count": 5,
    "worksite_count": 2,
    "wage_low_min": 67500,
    "wage_high_max": 112000,
    "wage_low_avg": 87020
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 82100,
    "wage_high_max": 82100,
    "wage_low_avg": 82100
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 7,
    "case_count": 7,
    "role_title_count": 6,
    "worksite_count": 2,
    "wage_low_min": 55220,
    "wage_high_max": 89200,
    "wage_low_avg": 74252.8571428571
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 89240,
    "wage_high_max": 99590,
    "wage_low_avg": 94415
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 7,
    "case_count": 7,
    "role_title_count": 6,
    "worksite_count": 1,
    "wage_low_min": 56100,
    "wage_high_max": 110000,
    "wage_low_avg": 82275.7142857143
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 48000,
    "wage_high_max": 48000,
    "wage_low_avg": 48000
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q1",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 90000,
    "wage_high_max": 133120,
    "wage_low_avg": 111560
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q3",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 4,
    "worksite_count": 2,
    "wage_low_min": 70000,
    "wage_high_max": 132850,
    "wage_low_avg": 94090
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 108000,
    "wage_high_max": 108000,
    "wage_low_avg": 108000
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 91000,
    "wage_high_max": 91000,
    "wage_low_avg": 91000
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 3,
    "worksite_count": 1,
    "wage_low_min": 91000,
    "wage_high_max": 145000,
    "wage_low_avg": 109000
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q3",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 72600,
    "wage_high_max": 97500,
    "wage_low_avg": 85050
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 95000,
    "wage_high_max": 95000,
    "wage_low_avg": 95000
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q2",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 4,
    "worksite_count": 1,
    "wage_low_min": 100800,
    "wage_high_max": 134000,
    "wage_low_avg": 118310.25
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q3",
    "lca_count": 5,
    "case_count": 5,
    "role_title_count": 5,
    "worksite_count": 1,
    "wage_low_min": 66560,
    "wage_high_max": 99800,
    "wage_low_avg": 83372
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q4",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 3,
    "worksite_count": 1,
    "wage_low_min": 52000,
    "wage_high_max": 101380,
    "wage_low_avg": 73313.3333333333
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 54080,
    "wage_high_max": 54080,
    "wage_low_avg": 54080
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 103000,
    "wage_high_max": 103000,
    "wage_low_avg": 103000
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q3",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 4,
    "worksite_count": 1,
    "wage_low_min": 64000,
    "wage_high_max": 116770,
    "wage_low_avg": 87192.5
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q4",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 116770,
    "wage_high_max": 6280560,
    "wage_low_avg": 2182443.33333333
  },
  {
    "fiscal_year": 2026,
    "quarter": "Q2",
    "lca_count": 6,
    "case_count": 6,
    "role_title_count": 3,
    "worksite_count": 1,
    "wage_low_min": 54660,
    "wage_high_max": 108000,
    "wage_low_avg": 84138.3333333333
  }
]
Links
{
  "roles": "/v1/roles?company=Williams%20College",
  "wages": "/v1/wages?company=Williams%20College",
  "trends": "/v1/trends?company=Williams%20College"
}
Get this page with API

Rendered from the bluedoor H-1B Jobs API. Reproduce it:

GET https://api.bluedoor.sh/h1b-jobs/v1/companies?q=williams+college&limit=5JSON