H-1B Visa Lottery Dashboard

Interactive dashboard of the United States H-1B visa lottery system. Explore key metrics such as employer participation, salaries, job titles, and country of origin through detailed filters and visualizations.

Core Filters.

1. Fiscal year
2. Employer name (e.g., Wipro, Amazon).
3. Job title: (e.g., “Software Engineer”).
4. Country of birth, country of nationality.
5. Salary Range: wage amt(e.g. $50,000), wage unit(e.g. year).
6. Worksite: worksite_city, worksite_state.

Explore the Data live with Datasette(SQLITE) deployed on Modal

• 🔸 ✶ H1Bs Database

Demo

Example query

SELECT 
    employer_name, 
    first_decision, 
    ben_sex, 
    ben_country_of_birth, 
    COUNT(1) AS city,
    SUM(COUNT(1)) OVER (PARTITION BY employer_name ORDER BY first_decision) AS cumulative_sum
FROM (
    SELECT 
        employer_name,
        first_decision,
        ben_sex,
        ben_country_of_birth
    FROM trk_data
) subquery
GROUP BY employer_name, first_decision, ben_sex, ben_country_of_birth
ORDER BY cumulative_sum desc, first_decision desc, employer_name;

result

Figure 1: Salary of H1B recipients from Ukraine earning > $50,000

Figure 2: Salary of H1B recipients of all nationalities residing in Seatte, earning > $35,000

Figure 3: Software Engineer H1B recipients

Visualizations:

• Time-series chart: Registrations vs. approvals by year.
• Treemap: Multiple vs. single registrations.

Citations

1. US H-1B Visa Lottery and Petition Data FY 2021 - FY 2024. Data sourced from USCIS and obtained by Bloomberg. https://github.com/BloombergGraphics/2024-h1b-immigration-data