Name: US Permanent Visa Applications
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

US Permanent Visa Applications

Context:

A permanent labor certification issued by the Department of Labor (DOL) allows an employer to hire a foreign worker to work permanently in the United States. In most instances, before the U.S. employer can submit an immigration petition to the Department of Homeland Security's U.S. Citizenship and Immigration Services (USCIS), the employer must obtain a certified labor certification application from the DOL's Employment and Training Administration (ETA). The DOL must certify to the USCIS that there are not sufficient U.S. workers able, willing, qualified and available to accept the job opportunity in the area of intended employment and that employment of the foreign worker will not adversely affect the wages and working conditions of similarly employed U.S. workers.

Content:

Data covers 2012-2017 and includes information on employer, position, wage offered, job posting history, employee education and past visa history, associated lawyers, and final decision.

Acknowledgements:

This data was collected and distributed by the US Department of Labor.

Inspiration:

Can you predict visa decisions based on employee/employer/wage?
How does this data compare to H1B decisions in this dataset?

Tables

Us Perm Visas

@kaggle.jboysen_us_perm_visas.us_perm_visas

48.08 MB
374362 rows
154 columns


CREATE TABLE us_perm_visas (
  "add_these_pw_job_title_9089" VARCHAR,
  "agent_city" VARCHAR,
  "agent_firm_name" VARCHAR,
  "agent_state" VARCHAR,
  "application_type" VARCHAR,
  "case_no" VARCHAR,
  "case_number" VARCHAR,
  "case_received_date" TIMESTAMP,
  "case_status" VARCHAR,
  "class_of_admission" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_citzenship" VARCHAR,
  "decision_date" TIMESTAMP,
  "employer_address_1" VARCHAR,
  "employer_address_2" VARCHAR,
  "employer_city" VARCHAR,
  "employer_country" VARCHAR,
  "employer_decl_info_title" VARCHAR,
  "employer_name" VARCHAR,
  "employer_num_employees" DOUBLE,
  "employer_phone" VARCHAR,
  "employer_phone_ext" VARCHAR,
  "employer_postal_code" VARCHAR,
  "employer_state" VARCHAR,
  "employer_yr_estab" DOUBLE,
  "foreign_worker_info_alt_edu_experience" VARCHAR,
  "foreign_worker_info_birth_country" VARCHAR,
  "foreign_worker_info_city" VARCHAR,
  "foreign_worker_info_education" VARCHAR,
  "foreign_worker_info_education_other" VARCHAR,
  "foreign_worker_info_inst" VARCHAR,
  "foreign_worker_info_major" VARCHAR,
  "foreign_worker_info_postal_code" VARCHAR,
  "foreign_worker_info_rel_occup_exp" VARCHAR,
  "foreign_worker_info_req_experience" VARCHAR,
  "foreign_worker_info_state" VARCHAR,
  "foreign_worker_info_training_comp" VARCHAR,
  "foreign_worker_ownership_interest" VARCHAR,
  "foreign_worker_yr_rel_edu_completed" DOUBLE,
  "fw_info_alt_edu_experience" VARCHAR,
  "fw_info_birth_country" VARCHAR,
  "fw_info_education_other" VARCHAR,
  "fw_info_postal_code" VARCHAR,
  "fw_info_rel_occup_exp" VARCHAR,
  "fw_info_req_experience" VARCHAR,
  "fw_info_training_comp" VARCHAR,
  "fw_info_yr_rel_edu_completed" DOUBLE,
  "fw_ownership_interest" VARCHAR,
  "ji_foreign_worker_live_on_premises" VARCHAR,
  "ji_fw_live_on_premises" VARCHAR,
  "ji_live_in_dom_svc_contract" VARCHAR,
  "ji_live_in_domestic_service" VARCHAR,
  "ji_offered_to_sec_j_foreign_worker" VARCHAR,
  "ji_offered_to_sec_j_fw" VARCHAR,
  "job_info_alt_cmb_ed_oth_yrs" DOUBLE,
  "job_info_alt_combo_ed" VARCHAR,
  "job_info_alt_combo_ed_exp" VARCHAR,
  "job_info_alt_combo_ed_other" VARCHAR,
  "job_info_alt_field" VARCHAR,
  "job_info_alt_field_name" VARCHAR,
  "job_info_alt_occ" VARCHAR,
  "job_info_alt_occ_job_title" VARCHAR,
  "job_info_alt_occ_num_months" DOUBLE,
  "job_info_combo_occupation" VARCHAR,
  "job_info_education" VARCHAR,
  "job_info_education_other" VARCHAR,
  "job_info_experience" VARCHAR,
  "job_info_experience_num_months" DOUBLE,
  "job_info_foreign_ed" VARCHAR,
  "job_info_foreign_lang_req" VARCHAR,
  "job_info_job_req_normal" VARCHAR,
  "job_info_job_title" VARCHAR,
  "job_info_major" VARCHAR,
  "job_info_training" VARCHAR,
  "job_info_training_field" VARCHAR,
  "job_info_training_num_months" DOUBLE,
  "job_info_work_city" VARCHAR,
  "job_info_work_postal_code" VARCHAR,
  "job_info_work_state" VARCHAR,
  "naics_2007_us_code" VARCHAR,
  "naics_2007_us_title" VARCHAR,
  "naics_code" VARCHAR,
  "naics_title" VARCHAR,
  "naics_us_code" VARCHAR,
  "naics_us_code_2007" VARCHAR,
  "naics_us_title" VARCHAR,
  "naics_us_title_2007" VARCHAR,
  "orig_case_no" VARCHAR,
  "orig_file_date" TIMESTAMP,
  "preparer_info_emp_completed" VARCHAR,
  "preparer_info_title" VARCHAR,
  "pw_amount_9089" DOUBLE,
  "pw_determ_date" VARCHAR,
  "pw_expire_date" VARCHAR,
  "pw_job_title_908" VARCHAR,
  "pw_job_title_9089" VARCHAR,
  "pw_level_9089" VARCHAR,
  "pw_soc_code" VARCHAR,
  "pw_soc_title" VARCHAR,
  "pw_source_name_9089" VARCHAR
);