Baselight
Sign In

H1B Visa Statistics

Bloomberg News investigation into the US into fraud around the H1B visa program

@kaggle.konradb_h1b_visa_statistics

Loading...
Loading...

About this Dataset

H1B Visa Statistics

Courtesy of Data is Plural: https://www.data-is-plural.com/

A recent Bloomberg News investigation into the US government’s annual H-1B lottery, a key step in allocating the country’s skilled-worker visas, finds that “thousands of companies got an unfair advantage by helping themselves to extra lottery tickets.” To reach those conclusions, the team “obtained data on all H-1B lottery registrations, selections, and petitions for fiscal years 2021 through 2024 after bringing a lawsuit against the Department of Homeland Security under the Freedom of Information Act.” They’ve shared the records, which indicate each registration’s employer, as well as the proposed beneficiary’s gender, nationality, and birth year. For registrations that led to visa petitions, the data include additional details, such as the worksite, salary, job title, and beneficiary’s field of study

Tables

Trk 13139 Fy2021

@kaggle.konradb_h1b_visa_statistics.trk_13139_fy2021
  • 17.2 MB
  • 269424 rows
  • 56 columns
Loading... 

CREATE TABLE trk_13139_fy2021 (
  "bcn" VARCHAR,
  "country_of_birth" VARCHAR,
  "country_of_nationality" VARCHAR,
  "ben_date_of_birth" VARCHAR,
  "ben_year_of_birth" VARCHAR,
  "gender" VARCHAR,
  "employer_name" VARCHAR,
  "fein" VARCHAR,
  "mail_addr" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "agent_first_name" VARCHAR,
  "agent_last_name" VARCHAR,
  "lottery_year" VARCHAR,
  "status_type" VARCHAR,
  "ben_multi_reg_ind" VARCHAR,
  "receipt_number" VARCHAR,
  "rec_date" VARCHAR,
  "first_decision" VARCHAR,
  "first_decision_date" VARCHAR,
  "i129_employer_name" VARCHAR,
  "pet_street" VARCHAR,
  "pet_city" VARCHAR,
  "pet_state" VARCHAR,
  "pet_zip" VARCHAR,
  "requested_class" VARCHAR,
  "basis_for_classification" VARCHAR,
  "requested_action" VARCHAR,
  "number_of_beneficiaries" VARCHAR,
  "ben_sex" VARCHAR,
  "ben_country_of_birth" VARCHAR,
  "ben_current_class" VARCHAR,
  "job_title" VARCHAR,
  "dol_eta_case_number" VARCHAR,
  "worksite_street" VARCHAR,
  "worksite_city" VARCHAR,
  "worksite_state" VARCHAR,
  "worksite_zip" VARCHAR,
  "full_time_ind" VARCHAR,
  "wage_amt" VARCHAR,
  "wage_unit" VARCHAR,
  "valid_from" VARCHAR,
  "valid_to" VARCHAR,
  "num_of_emp_in_us" VARCHAR,
  "s1q1a" VARCHAR,
  "s1q1b" VARCHAR,
  "ben_education_code" VARCHAR,
  "ed_level_definition" VARCHAR,
  "ben_pfield_of_study" VARCHAR,
  "ben_comp_paid" VARCHAR,
  "dot_code" VARCHAR,
  "naics_code" VARCHAR,
  "s3q1" VARCHAR,
  "s4q1" VARCHAR,
  "t_u_vawa_flag" VARCHAR
);

Trk 13139 Fy2022

@kaggle.konradb_h1b_visa_statistics.trk_13139_fy2022
  • 17.88 MB
  • 301447 rows
  • 56 columns
Loading... 

CREATE TABLE trk_13139_fy2022 (
  "bcn" VARCHAR,
  "country_of_birth" VARCHAR,
  "country_of_nationality" VARCHAR,
  "ben_date_of_birth" VARCHAR,
  "ben_year_of_birth" VARCHAR,
  "gender" VARCHAR,
  "employer_name" VARCHAR,
  "fein" VARCHAR,
  "mail_addr" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "agent_first_name" VARCHAR,
  "agent_last_name" VARCHAR,
  "lottery_year" VARCHAR,
  "status_type" VARCHAR,
  "ben_multi_reg_ind" VARCHAR,
  "receipt_number" VARCHAR,
  "rec_date" VARCHAR,
  "first_decision" VARCHAR,
  "first_decision_date" VARCHAR,
  "i129_employer_name" VARCHAR,
  "pet_street" VARCHAR,
  "pet_city" VARCHAR,
  "pet_state" VARCHAR,
  "pet_zip" VARCHAR,
  "requested_class" VARCHAR,
  "basis_for_classification" VARCHAR,
  "requested_action" VARCHAR,
  "number_of_beneficiaries" VARCHAR,
  "ben_sex" VARCHAR,
  "ben_country_of_birth" VARCHAR,
  "ben_current_class" VARCHAR,
  "job_title" VARCHAR,
  "dol_eta_case_number" VARCHAR,
  "worksite_street" VARCHAR,
  "worksite_city" VARCHAR,
  "worksite_state" VARCHAR,
  "worksite_zip" VARCHAR,
  "full_time_ind" VARCHAR,
  "wage_amt" VARCHAR,
  "wage_unit" VARCHAR,
  "valid_from" VARCHAR,
  "valid_to" VARCHAR,
  "num_of_emp_in_us" VARCHAR,
  "s1q1a" VARCHAR,
  "s1q1b" VARCHAR,
  "ben_education_code" VARCHAR,
  "ed_level_definition" VARCHAR,
  "ben_pfield_of_study" VARCHAR,
  "ben_comp_paid" VARCHAR,
  "dot_code" VARCHAR,
  "naics_code" VARCHAR,
  "s3q1" VARCHAR,
  "s4q1" VARCHAR,
  "t_u_vawa_flag" VARCHAR
);

Trk 13139 Fy2023

@kaggle.konradb_h1b_visa_statistics.trk_13139_fy2023
  • 24.81 MB
  • 474421 rows
  • 56 columns
Loading... 

CREATE TABLE trk_13139_fy2023 (
  "bcn" VARCHAR,
  "country_of_birth" VARCHAR,
  "country_of_nationality" VARCHAR,
  "ben_date_of_birth" VARCHAR,
  "ben_year_of_birth" VARCHAR,
  "gender" VARCHAR,
  "employer_name" VARCHAR,
  "fein" VARCHAR,
  "mail_addr" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "agent_first_name" VARCHAR,
  "agent_last_name" VARCHAR,
  "lottery_year" VARCHAR,
  "status_type" VARCHAR,
  "ben_multi_reg_ind" VARCHAR,
  "receipt_number" VARCHAR,
  "rec_date" VARCHAR,
  "first_decision" VARCHAR,
  "first_decision_date" VARCHAR,
  "i129_employer_name" VARCHAR,
  "pet_street" VARCHAR,
  "pet_city" VARCHAR,
  "pet_state" VARCHAR,
  "pet_zip" VARCHAR,
  "requested_class" VARCHAR,
  "basis_for_classification" VARCHAR,
  "requested_action" VARCHAR,
  "number_of_beneficiaries" VARCHAR,
  "ben_sex" VARCHAR,
  "ben_country_of_birth" VARCHAR,
  "ben_current_class" VARCHAR,
  "job_title" VARCHAR,
  "dol_eta_case_number" VARCHAR,
  "worksite_street" VARCHAR,
  "worksite_city" VARCHAR,
  "worksite_state" VARCHAR,
  "worksite_zip" VARCHAR,
  "full_time_ind" VARCHAR,
  "wage_amt" VARCHAR,
  "wage_unit" VARCHAR,
  "valid_from" VARCHAR,
  "valid_to" VARCHAR,
  "num_of_emp_in_us" VARCHAR,
  "s1q1a" VARCHAR,
  "s1q1b" VARCHAR,
  "ben_education_code" VARCHAR,
  "ed_level_definition" VARCHAR,
  "ben_pfield_of_study" VARCHAR,
  "ben_comp_paid" VARCHAR,
  "dot_code" VARCHAR,
  "naics_code" VARCHAR,
  "s3q1" VARCHAR,
  "s4q1" VARCHAR,
  "t_u_vawa_flag" VARCHAR
);

Trk 13139 Fy2024 Multi Reg

@kaggle.konradb_h1b_visa_statistics.trk_13139_fy2024_multi_reg
  • 12.77 MB
  • 408891 rows
  • 56 columns
Loading... 

CREATE TABLE trk_13139_fy2024_multi_reg (
  "bcn" VARCHAR,
  "country_of_birth" VARCHAR,
  "country_of_nationality" VARCHAR,
  "ben_date_of_birth" VARCHAR,
  "ben_year_of_birth" VARCHAR,
  "gender" VARCHAR,
  "employer_name" VARCHAR,
  "fein" VARCHAR,
  "mail_addr" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "agent_first_name" VARCHAR,
  "agent_last_name" VARCHAR,
  "lottery_year" VARCHAR,
  "status_type" VARCHAR,
  "ben_multi_reg_ind" VARCHAR,
  "receipt_number" VARCHAR,
  "rec_date" VARCHAR,
  "first_decision" VARCHAR,
  "first_decision_date" VARCHAR,
  "i129_employer_name" VARCHAR,
  "pet_street" VARCHAR,
  "pet_city" VARCHAR,
  "pet_state" VARCHAR,
  "pet_zip" VARCHAR,
  "requested_class" VARCHAR,
  "basis_for_classification" VARCHAR,
  "requested_action" VARCHAR,
  "number_of_beneficiaries" VARCHAR,
  "ben_sex" VARCHAR,
  "ben_country_of_birth" VARCHAR,
  "ben_current_class" VARCHAR,
  "job_title" VARCHAR,
  "dol_eta_case_number" VARCHAR,
  "worksite_street" VARCHAR,
  "worksite_city" VARCHAR,
  "worksite_state" VARCHAR,
  "worksite_zip" VARCHAR,
  "full_time_ind" VARCHAR,
  "wage_amt" VARCHAR,
  "wage_unit" VARCHAR,
  "valid_from" VARCHAR,
  "valid_to" VARCHAR,
  "num_of_emp_in_us" VARCHAR,
  "s1q1a" VARCHAR,
  "s1q1b" VARCHAR,
  "ben_education_code" VARCHAR,
  "ed_level_definition" VARCHAR,
  "ben_pfield_of_study" VARCHAR,
  "ben_comp_paid" VARCHAR,
  "dot_code" VARCHAR,
  "naics_code" VARCHAR,
  "s3q1" VARCHAR,
  "s4q1" VARCHAR,
  "t_u_vawa_flag" VARCHAR
);

Trk 13139 Fy2024 Single Reg

@kaggle.konradb_h1b_visa_statistics.trk_13139_fy2024_single_reg
  • 19.15 MB
  • 350103 rows
  • 56 columns
Loading... 

CREATE TABLE trk_13139_fy2024_single_reg (
  "bcn" VARCHAR,
  "country_of_birth" VARCHAR,
  "country_of_nationality" VARCHAR,
  "ben_date_of_birth" VARCHAR,
  "ben_year_of_birth" VARCHAR,
  "gender" VARCHAR,
  "employer_name" VARCHAR,
  "fein" VARCHAR,
  "mail_addr" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "agent_first_name" VARCHAR,
  "agent_last_name" VARCHAR,
  "lottery_year" VARCHAR,
  "status_type" VARCHAR,
  "ben_multi_reg_ind" VARCHAR,
  "receipt_number" VARCHAR,
  "rec_date" VARCHAR,
  "first_decision" VARCHAR,
  "first_decision_date" VARCHAR,
  "i129_employer_name" VARCHAR,
  "pet_street" VARCHAR,
  "pet_city" VARCHAR,
  "pet_state" VARCHAR,
  "pet_zip" VARCHAR,
  "requested_class" VARCHAR,
  "basis_for_classification" VARCHAR,
  "requested_action" VARCHAR,
  "number_of_beneficiaries" VARCHAR,
  "ben_sex" VARCHAR,
  "ben_country_of_birth" VARCHAR,
  "ben_current_class" VARCHAR,
  "job_title" VARCHAR,
  "dol_eta_case_number" VARCHAR,
  "worksite_street" VARCHAR,
  "worksite_city" VARCHAR,
  "worksite_state" VARCHAR,
  "worksite_zip" VARCHAR,
  "full_time_ind" VARCHAR,
  "wage_amt" VARCHAR,
  "wage_unit" VARCHAR,
  "valid_from" VARCHAR,
  "valid_to" VARCHAR,
  "num_of_emp_in_us" VARCHAR,
  "s1q1a" VARCHAR,
  "s1q1b" VARCHAR,
  "ben_education_code" VARCHAR,
  "ed_level_definition" VARCHAR,
  "ben_pfield_of_study" VARCHAR,
  "ben_comp_paid" VARCHAR,
  "dot_code" VARCHAR,
  "naics_code" VARCHAR,
  "s3q1" VARCHAR,
  "s4q1" VARCHAR,
  "t_u_vawa_flag" VARCHAR
);

Share link

Anyone who has the link will be able to view this.