dovinmu/uscis-data

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

uscis-data's Issues

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?)

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?

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!