Kate Willyard
  • About
  • Research
    • Journal Articles
    • Awarded Research Proposals
    • Datasets
    • Doctoral Dissertation
    • Op-Eds and News
    • Presentations
    • Working Papers
  • Teaching
    • Classical Social Theory
    • Enviornmental Sociology
    • Medical Sociology
    • Social Inequality
    • Social Problems
    • Sociology of Organizations
  • Academic Blog
  • Personal Blog
  • Contact

Academic Blog

"If we knew what we were doing, it would not be called research, would it?" -Albert Einstein

Comparing Census Population Data, Part Two: Studying Documentation to Determine Feasibility of Variable Comparison

6/21/2018

0 Comments

 
This post describes the first step of comparing Census population data over time: studying documentation to determine the feasibility of variable comparison over time. See Comparing Census Population Data, Part One to get introduced to this project.

As described in the previous post, not all of the population tabulations that are available in the 2000 Decennial Census are available in the 2010 Decennial Census and American Community Survey. Additionally, questions can be asked in different ways, which can make them incomparable. 

In addition to determining data comparability, documentation must also be studied to determine variables names, table names and segment identifiers. In order to accomplish this task, I created a table with the following fields:​

- Main Fields: American Community Survey Variable Name, Other Variable Name (If Different)
- Decennial Census 2000, Summary File 1: Table Number, Table Name, Table ID, Segment, Max Size, Universe, Lowest Level of Geography
- Decennial Census 2000, Summary File 3: Table Number, Table Name, Table ID, Segment, Max Size, Universe, Lowest Level of Geography
- Decennial Census 2010, Summary File 1: Table Number, Table Name, Table ID, Segment, Max Size, Universe, Lowest Level of Geography
- American Community Survey,  2010-2014: Table Number, Table Name, Table ID, Segment, Max Size, Universe, Lowest Level of Geography
- Notes: When Comapring 2012 ACS to 2000 DC, When Comparing 2012 ACS to 2010 DC, When Comparing 2012 ACS to 2011 ACS
Click here to access a template I created.

The next step was identifying each variable and writing down the information in the template. The table number, table contents, data dictionary reference name, segment, max size, and smallest summary file level is available in the technical documentation as described below:

- Decennial Census 2000 Summary File 1: Starts on page 227 (click here to access the document)
- Decennial Census 2000 Summary File 3: Starts on page 422 (click here to access the document)
- Decennial Census 2010 Summary File 1: Starts on page 183 (click here to access the document)
- American Community Survey 2008-2012 Summary File: Starts on page 46 (click here to access the document)
After checking the data documentation/code books to find the variable/table/segment details, I looked up the variables using the following three different Census tools and used the information to fill out the comparability notes in the table:

- https://www.census.gov/programs-surveys/acs/guidance/comparing-acs-data/2012.html
- https://www.census.gov/acs/www/guidance/comparing-acs-data/acscensus-table-lookup/index.php
- https://www.census.gov/geo/maps-data/data/relationship.html

​After looking all the information up, in the comparability notes of the table, I highlighted the variables that have no comparability concerns as green, I highlighted the variables that have some comparability concerns as orange, and I highlighted the variables that are not comparable as red. Click here to access the completed table. 

In order to make information about what variables can be used and at what level, I made a simplified table with our variables of interest, if it can be broken down by race, if the variable can be measured using full population count data or sample data, if it is comparable, the smallest level of geography available, and associated notes. You can find this by clicking here.

This completed my first step of checking the documentation to determine feasibility of comparing variables over time. 

0 Comments



Leave a Reply.

    Author

    Kate Willyard is a political and economic sociologist interested in human organization and the environment.

    Archives

    October 2018
    July 2018
    June 2018
    November 2017
    March 2017
    January 2017
    December 2016
    May 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015

    Categories

    All
    Critical Geography
    Economic Sociology
    Environmental Sociology
    Natural Resources
    Political Sociology
    Quantitative Research Methods
    Sociology Of Organizations

    RSS Feed

Research Gate

ORCID

Academia

LinkedIn

GitHub