Blog

  • 2021
  • 2020
  • 2019
  • 2018
  • 2017
  • 2016
  • 2015

Blog from April, 2017

We're happy to announce the release of two new datasets!

The IRS Migration Database is a SQLite / Spatialite database that has annual county to county and state to state migration data from 1990 to 2013 (for counties) and 1988 to 2013 (for states). Janine has spent over a year cleaning, collating, and organizing this data into one cohesive dataset. This data is generated by the IRS Statistics of Income Division by calculating the number of tax filers who have changed their address between tax years; if the address changed that means the filer moved. Records are summarized by county and state and show the number of filers, exemptions, and aggregate gross income. While the datasets cannot represent complete migration (not everyone files taxes) its time span and detail in showing point to point flows makes it a valuable resource for studying internal migration trends within the United States.

You can access the database using any number of free tools, like the SQLite Manager plugin for Firefox. Although the tables do not have spatial geometry, GIS users can view them and add them to projects in QGIS or ArcGIS as the database is saved in the Spatialite format. As the data represents many to many relationships, GIS users will need to write some queries to pivot the data to make it mappable; for example you can visualize all the inflow or outflow to one particular county or state, or to a group of places. Janine has included some sample views in the database to help get you started.

On the other side of the globe, we have recently acquired boundaries for City Municipal Wards for India with 2011 census data for twelve cities. This data is produced by ML Infomap and was procured by the CUNY Institute for Demographic Research. Thanks to them, we are able to provide this data by request to members of the Baruch community and to CIDR affiliates (since it's a proprietary and licensed product, we can't provide public access to it - sorry).

As we approach the summer we'll have additional updates to share, including an additional year of NYC real estate data and updates to the NYC Geodatabase that will include: new ZIP Code Business Pattern data, updated features for NYC facilities, and a new year of subway ridership data. We're also hoping to add the two latest years of data (2013-14 and 2014-15) to the IRS database. Stay tuned for details.