Not sure if your H1-B Labor Condition Application (LCA) statistics on your favorite visa info website is up-to-date? Too slow and tedious to look up each company's LCA data on your favorite visa info website? This project aims to solve these problems by providing a local, simple, easy-to-use, and up-to-date H1-B LCA data analysis tool. You decide if the data is up-to-date, by comparing the data in src_data/ (listed below) to the current disclosure data from the United States Department of Labor (DOL) source files.
Download the csv files in the release tab, open them in a fast text editor e.g. VSCode, and search for your company name!
output/20191001_20230630.csv: All counts of Certified LCA (do not include Withdrawn, Denied, or Certified-Expired) by company name, sorted by count in descending order, from 2019-10-01 to 2023-06-30.output/20210701_20230630.csv: All counts of Certified LCA (do not include Withdrawn, Denied, or Certified-Expired) by company name, sorted by count in descending order, from 2021-07-01 to 2023-06-30.output/software_20191001_20230630.csv: All counts of Certified LCA that has "SOFTWARE DEVELOPERS" in the official job designation field, by company name, sorted by count in descending order, from 2019-10-01 to 2023-06-30. For reference, there are 2,278,410 total Certified LCA from 2019-10-01 to 2023-06-30, of which 868,631 (38.1%) are "SOFTWARE DEVELOPERS".output/software_20210701_20230630.csv: All counts of Certified LCA that has "SOFTWARE DEVELOPERS" in the official job designation field, by company name, sorted by count in descending order, from 2021-07-01 to 2023-06-30.
Try it yourself by following the directions below.
src_data_urls.txt: The download links for the DOL data source files. Runwget -P src_data/ -i src_data_urls.txtto download all files tosrc_data/.src_data/: All downloaded disclosure data source files from the DOL website are stored in this directory. Filenames and formats are kept as-is. All files prior to 2020 (e.g.H-1B_Disclosure_Data_FY2019.xlsx) are not considered because they are sufficiently outdated & have completely different fields in the xlsx file. Current files in this directory are listed below:LCA_Disclosure_Data_FY2023_Q3.xlsx: Decision date from 2022-10-01 to 2023-06-30, in order.LCA_Disclosure_Data_FY2022_Q4.xlsx: Decision date from 2022-07-01 to 2022-09-30, in order.LCA_Disclosure_Data_FY2022_Q3.xlsx: Decision date from 2022-04-01 to 2022-06-30, in order.LCA_Disclosure_Data_FY2022_Q2.xlsx: Decision date from 2022-01-01 to 2022-03-31, in order.LCA_Disclosure_Data_FY2022_Q1.xlsx: Decision date from 2021-10-01 to 2021-12-31, in order.LCA_Disclosure_Data_FY2021_Q4.xlsx: Decision date from 2021-07-01 to 2021-09-30, in order.LCA_Disclosure_Data_FY2021_Q3.xlsx: Decision date from 2021-04-01 to 2021-06-30, in order.LCA_Disclosure_Data_FY2021_Q2.xlsx: Decision date from 2021-01-01 to 2021-03-31, in order.LCA_Disclosure_Data_FY2021_Q1.xlsx: Decision date from 2020-10-01 to 2020-12-31, in order.LCA_Disclosure_Data_FY2020_Q4.xlsx: Decision date from 2020-07-01 to 2020-09-30, in order.LCA_Disclosure_Data_FY2020_Q3.xlsx: Decision date from 2020-04-01 to 2020-06-30, in order.LCA_Disclosure_Data_FY2020_Q2.xlsx: Decision date from 2020-01-01 to 2020-03-31, in order.LCA_Disclosure_Data_FY2020_Q1.xlsx: Decision date from 2019-10-01 to 2019-12-31, in order.
convert_csv.py: Converts all files insrc_data/to CSV format and stores them indata/, for faster processing down the line.check_fields_match: Checks if all CSV files indata/have the same fields. If not, it will print out the fields that are different.column_name_fix.py: Fixes mismatched column names, found out bycheck_fields_match.py, in all CSV files indata/. Currently converts all mismatches to the latest format indata/LCA_Disclosure_Data_FY2023_Q3.csv.gen_lca_count.ipynb: Generates relevant company LCA count from the processed CSV files. Play with it! Release files are generated from this notebook.