Skip to content

mngh037/h1b-data-project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

H1B Data Project

H1B Filings in the US: A look at Winners and Losers of the Lottery

CAPP 30239 Static Visualization Capstone Project - Minh Nghiem

Project Description

H1B visa--oftentimes referred to as the hard-earned ticket to working opportunities in the US--has been the goal for many international job-seeking prospectives, be it a student who just graduated, or a foreign national looking to land a job from overseas. Because there is a cap of 85,000 visas in place, a lot of money is spent into selection every year, and while the process is not unclear, the paradigm of execution and selection by means of a lottery is far from straightforward.

Using USCIS-sourced, Bloomberg-obtained filings data at the level of details never before seen, this project explores the profile of selected H1Bs and dives into the trend and outcome of the lottery in the last 4 years (FY21-24). In addition to serving as the factsheet for curious Americans and H1B hopefuls, the project aims to call attention to the inequity that permeates the system, thus providing the basis for all to engage in discourse for process reform.

Note: the dataset and this project deal with cap-subjected employers only, as non-profits and educational institutions meeting certain requirements are exempt from this visa cap and lottery selection taking on H1B workers.

Final work Preview

H1B Filings in the US FY17-24

How to Generate the Graphs

All the graphs produced for this infographic can be replicated by running the code in ./src/graphs.ipynb once you get all the data and run uv sync in the terminal to install all necessary packages.

Due to Github's limit on uploads, in additional to the data files that are now in the ./data/ directory, please find and download 5 .csv files of USCIS data that was obtained by Bloomberg.

These files should be put in the ./data/ directory. For the code to run properly, please rename them as follows:

  • TRK_13139_FY2021.csv --> bloomberg_h1b_records_2021.csv

  • TRK_13139_FY2022.csv --> bloomberg_h1b_records_2022.csv

  • TRK_13139_FY2023.csv --> bloomberg_h1b_records_2023.csv

  • TRK_13139_FY2024_single_reg.csv --> bloomberg_h1b_records_2024_singl.csv

  • TRK_13139_FY2024_multi_reg.csv --> bloomberg_h1b_records_2024_multi.csv

Acknowledgement and Sources

Data

USCIS, Employer Data Hub

Bloomberg & USCIS, H1B Visa Lottery and Petition Data FY21-24

References

DOL, H1B Program

Forbes News, A Look At The High Fees Making Hiring H-1B Visa Holders Challenging

Bloomberg, How Thousands of Middlemen are Gaming the H1B Program

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published