NHGIS Census Data Workflow using Stata and Python, Miami-Dade County 1990 Block Groups

Resource Type
Dataset : administrative records data, aggregate data, census/enumeration data, geographic information system (GIS) data
  • Day, Wayne (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 Department of Landscape Architecture and Urban Planning
    • Award Number: URSC689
Free Keywords
census data; stata; python; data workflow; nhgis
  • Abstract

    This data archive provides Stata .do files and a Jupyter Notebook for the cleaning, manipulation, exploration, and mapping of Block Group and County level data. The data workflow is meant to provide useful tools and code to any researcher working Census data at the block group level or other geographic levels. The benefit of using NHGIS data is the ability to obtain older datasets not easily available for download from the Census. Additionally, NHGIS provides the data in a standardized format with codebooks.

    The workflow is broken out into sub-tasks: obtain data, clean data, and explore data. Each task is designed to be completed prior to the subsequent task. The workflow follows guidance from Long (2009).

    Stata .do file features:
    • Loops, local and global macros, and other advanced functions for generating and manipulating variables
    • Commands to generate and export descriptive statistics tables, histograms, boxplots and between-area analyses to Microsoft Word and image files
    Jupyter Notebook features:
    • Code and markdown commentary to read in and map the output file from Stata and merge with shapefiles
    The data used in this workflow example is used in analysis by Peacock et al. (2014), and Zhang and Peacock (2009).

Temporal Coverage
  • 1990-01-01 / 1990-12-31
    Time Period: Mon Jan 01 00:00:00 EST 1990--Mon Dec 31 00:00:00 EST 1990 (1990 Decennial Census)
Geographic Coverage
  • Block Groups in Miami-Dade County, Florida
Sampled Universe
For Median Household Income: All Households
For Race and Ethnicity: All Persons
For Parcels: All tax assessed parcels in Miami-Dade County. Smallest Geographic Unit: Block Group
  • Is cited by
    DOI: 10.1080/01944363.2014.980440 (Text)
  • Is cited by
    DOI: 10.1080/01944360903294556 (Text)
  • Long, J. Scott. The Workflow of Data Analysis Using Stata. College Station, Texas: Stata Press, 2009.
  • 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. https://doi.org/10.1080/01944363.2014.980440.
    • ID: 10.1080/01944363.2014.980440 (DOI)
  • Zhang, Yang, and Walter Gillis Peacock. “Planning for Housing Recovery? Lessons Learned From Hurricane Andrew.” Journal of the American Planning Association 76, no. 1 (December 31, 2009): 5–24. https://doi.org/10.1080/01944360903294556.
    • ID: 10.1080/01944360903294556 (DOI)

Update Metadata: 2020-05-18 | Issue Number: 1 | Registration Date: 2020-05-18