USCIS publishes a "visa bulletin"
every month. This bulletin summarizes the availability of immigrant numbers during each month
for: "Final Action Dates" (FAD) and "Dates for Filing Applications" (DOF) indicating when immigrant visa applicants
should be notified to assemble and submit required documentation to the National Visa Center.
Python Pandas can read html
and extract tables into DataFrame objects. This was used to convert each table in the visa bulletin
into DataFrames for the family and employment-based dates. This was done for every bulletin published
from January 2018.
There are few entries with non-dates. Such as C for current and U for unavailable. C entries
were replaced with the 1st of the month. For example, the FAD for INDIA and F2A in the above sample
would be updated to 01FEB23. U entries were replaced with 01Jan1980.