dovinmu/uscis-data

Putting USCIS data on immigrant naturalization into easier-to-use formats, plus some graphs.

USCIS-data

This repository collects together data on US citizen naturalizations by field office from the USCIS Immigrant and Citizenship Data portal. Note that there are only 2 fiscal quarters from 2020, making it look like there's a downward trend.

Made using various tools from the Anaconda stack.

Files

USCIS scrape and concat.ipynb: scrapes quarterly reports on naturalizations by field office and puts them together. Puts the results into a CSV called first_pass.csv (not committed to the repo).

concat_excel_quarters.ipynb: opens an xlsx file with the remaining quarters of data, which weren't available as CSV and so had to be pasted into an excel file. Saves everything to master_df.csv.

sum.ipynb: sums the quarterly data into (fiscal) yearly data, putting the data into three CSVs (in order to exclude non-US and non-US state data) in the data folder.

uscis-data's Issues

Field Offices by zip code

Heya Rowan -

I'm building out a sheet on margins of victory for various elections in google spreadsheets (see "2016 Margins") when I noticed that a few states were not represented in the raw data, including ND, SD, Wyoming, Delaware, Wisconsin, and Mississippi.

When I tried to figure out if this was an issue with our data on the USCIS site - see North Dakota, I found that ND is served by the Minneapolis field office AND that several Wisconsin counties are ALSO served by the Minneapolis field office (by zip code.)

This means that we can actually get more granular data on naturalizations by county, which I did not believe before was possible.

The data is obviously still limited, bc it doesn't tell us how many people are naturalized by county, just what it serves... so I'm not sure how ultimately useful it would be to pull this, BUT wanted to ask how hard/long you think it would take?

Column for states, and separation of int'l

Thx, almost there! Just two things:

1. Could we add column for states (and state totals) and also organize by states-->cities in states
2. could we move all int'l to bottom (and include in states' category?)

Missing data on applications received, approved, denied, pending

Heyy Rowan -

https://github.com/dovinmu/USCIS-data/blob/master/data/sum_by_year.csv

Just noticed that there's only one column now with data about applications, but it's incorrectly labeled as year. I'm not sure if this is applications received, approved, denied, or pending, so I actually can't use this at all?

Can I get those columns back asap? Thanks so much!