My da|ra Login

Detailed view

metadata language: English

Census Data Workflow using IPUMS NHGIS API: Data Request and Download

Resource Type
Dataset : aggregate data, census/enumeration data, geographic information system (GIS) data, images: photographs, drawings, graphical representations, program source code
  • Day, Wayne (Texas A&M University)
  • Goodman, Cooper (Texas A&M University)
  • Gu, Donghwan (Texas A&M University)
  • Korukonda, Jayasaree (Texas A&M University)
  • Rosenheim, Nathanael (Texas A&M University)
Publication Date
Funding Reference
  • National Institute for Standards and Technology
    • Award Number: 70NANB15H044
  • National Institute for Standards and Technology
    • Award Number: 70NANB20H008
  • Texas A&M University, Hazard Reduction and Recovery Center (HRRC)
  • Texas A&M University, Department of Landscape Architecture and Urban Planning (LAUP)
Free Keywords
census data; API; NHGIS; python; google colaboratory; google colab; US Census API
  • Abstract

    This archive provides two Jupyter Notebooks to explore metadata and retrieve data using the IPUMS NHGIS API. American Community Survey (ACS) 5-year estimates 2005-2009 at the block group and county levels are requested and downloaded for Galveston County, Texas. Data of interest are race and ethnicity, and median household income. Block group and county shapefiles are also downloaded.

    The Python code was developed in Google Colaboratory, or Google Colab for short, which is an Integrated Development Environment (IDE) of JupyterLab and streamlines package installation, code collaboration and management.The notebooks use Google Drive for file storage and include extensive markdown and comments. The notebooks can be adapted for use in other environments (i.e., Jupyter Notebook) as well as reading and writing files to a local or shared drive, or cloud drive (i.e., Google Drive).

    The first notebook explores metadata in order to identify relevant datasets and tables and necessary parameters for subsequent data request and retrieval. The second notebook uses the parameters identified from the first notebook. A data request is constructed and the data extract is downloaded and files unzipped and made ready for analysis. The data that were downloaded are also stored separately with this archive.

    The data referenced in this archive have research applications listed in the Related Publications section and in ongoing research at the Texas A&M University Department of Landscape Architecture and Urban Planning (LAUP), and the Hazard Reduction and Recovery Center (HRRC).
Temporal Coverage
  • 2005-01-01 / 2009-12-31
    Time Period: Sat Jan 01 00:00:00 EST 2005--Thu Dec 31 00:00:00 EST 2009 (2009 5-year ACS)
Geographic Coverage
  • Block Groups in Galveston County, Texas
Sampled Universe
For Median Household Income: All Households
For Race and Ethnicity: All Persons. Smallest Geographic Unit: Block Group
This study is freely available to the general public via web download.
  • Has version
    DOI: 10.3886/E120305V1
  • Hamideh, Sara, Walter Gillis Peacock, and Shannon Van Zandt. “Housing Recovery after Disasters: Primary versus Seasonal and Vacation Housing Markets in Coastal Communities.” Natural Hazards Review 19, no. 2 (May 2018): 04018003.
    • ID: 10.1061/(asce)nh.1527-6996.0000287 (DOI)
  • Highfield, Wesley E., Walter Gillis Peacock, and Shannon Van Zandt. “Mitigation Planning: Why Hazard Exposure, Structural Vulnerability, and Social Vulnerability Matter.” Journal of Planning Education and Research 34, no. 3 (September 2014): 287–300.
    • ID: 10.1177/0739456x14531828 (DOI)
  • Peacock, Walter Gillis, Shannon Van Zandt, Yang Zhang, and Wesley E. Highfield. “Inequities in Long-Term Housing Recovery After Disasters.” Journal of the American Planning Association 80, no. 4 (October 2, 2014): 356–71.
    • ID: 10.1080/01944363.2014.980440 (DOI)
  • Van Zandt, Shannon, Walter Gillis Peacock, Dustin W. Henry, Himanshu Grover, Wesley E. Highfield, and Samuel D. Brody. “Mapping Social Vulnerability to Enhance Housing and Neighborhood Resilience.” Housing Policy Debate 22, no. 1 (January 2012): 29–55.
    • ID: 10.1080/10511482.2011.624528 (DOI)

Update Metadata: 2020-07-31 | Issue Number: 1 | Registration Date: 2020-07-31

Day, Wayne; Goodman, Cooper; Gu, Donghwan; Korukonda, Jayasaree; Rosenheim, Nathanael (2020): Census Data Workflow using IPUMS NHGIS API: Data Request and Download. Version: V0. ICPSR - Interuniversity Consortium for Political and Social Research. Dataset.