Skip to content

Instantly share code, notes, and snippets.

@JoeGermuska
Created August 1, 2014 20:01
Show Gist options
  • Save JoeGermuska/38765a72d7b8d443c0ce to your computer and use it in GitHub Desktop.
Save JoeGermuska/38765a72d7b8d443c0ce to your computer and use it in GitHub Desktop.
An attempt to identify tables suitable for use with interpolation method to compute a median for aggregated geographies.

See censusreporter/census-aggregate#1 (comment) for more info.

whee. I think this is a pretty good distillation of tables which might go through the aggregation process which are complicated... this needs more eyes for sure.

Apparent pairs suitable for interpolation B01001 Sex by age (repeat for racial iterations) B01002 Median age by sex

B05003 Sex by Age by Nativity and Citizenship Status B05004 Median Age by Nativity and Citizenship Status by Sex

B06001 Place of Birth by Age in the United States B06002 Median Age by Place of Birth in the United States

B06010 Place of Birth by Individual Income in the United States B06011 Median Income by Place of Birth in the United States

B07002 Median Age by Geographical Mobility in the Past Year for Current Residence in the United States B07003 Geographical Mobility in the Past Year by Sex for Current Residence in the United States

B07011 Median Income by Geographical Mobility in the Past Year for Current Residence in the United States B07012 Geographical Mobility in the Past Year by Poverty Status for Current Residence in the United States

B08101 Means of Transportation to Work by Age B08103 Median Age by Means of Transportation to Work

B08119 Means of Transportation to Work by Workers' Earnings B08121 Median Earnings by Means of Transportation to Work

B19001 Household Income (repeat for racial iterations) B19013 Median Household Income

B19037 Age of Householder by Household Income B19049 Median Household Income by Age of Householder

B19101 Family Income (repeat for racial iterations) B19113 Median Family Income

B19126 Median Family Income by Family Type by Presence of Own Children B19131 Family Type by Presence of Own Children by Family Income

B19201 Nonfamily Household Income B19202 Median Nonfamily Household Income (median has race iterations but not B19201)

B19325 Sex by Work Experience by Income B19326 Median Income by Sex by Work Experience With Income

B20001 Sex by Earnings With Earnings B20002 Median Earnings by Sex With Earnings

B20005 Sex by Work Experience by Earnings (repeat for racial iterations) B20017 Median Earnings by Sex by Work Experience With Earnings

B25017 Rooms B25018 Median Number of Rooms

B25034 Year Structure Built B25035 Median Year Structure Built

B25036 Tenure by Year Structure Built B25037 Median Year Structure Built by Tenure

B25038 Tenure by Year Householder Moved Into Unit B25039 Median Year Householder Moved Into Unit by Tenure

B25087 Mortgage Status and Selected Monthly Owner Costs B25088 Median Selected Monthly Owner Costs (Dollars) by Mortgage Status

B25091 Mortgage Status by Selected Monthly Owner Costs as a Percentage of Household Income B25092 Median Selected Monthly Owner Costs as a Percentage of Household Income

B25096 Mortgage Status by Value B25097 Mortgage Status by Median Value (Dollars)

B25098 Mortgage Status by Household Income B25099 Mortgage Status by Median Household Income

B25102 Mortgage Status by Real Estate Taxes Paid B25103 Mortgage Status by Median Real Estate Taxes Paid (Dollars)

B25104 Monthly Housing Costs B25105 Median Monthly Housing Costs (Dollars)

No clear companion table B10010 Median Family Income for Families With Grandparent Householders And/or Spouses Living With Own Grandchildren by Responsibility for Own Grandchildren and Presence of Parent of Grandchild B18140 Median Earnings by Disability Status by Sex for the Civilian Noninstitutionalized Population With Earnings B19019 Median Household Income by Household Size B19119 Median Family Income by Family Size B19121 Median Family Income by Number of Earners in Family B19125 Median Family Income by Presence of Own Children B19215 Median Nonfamily Household Income by Sex of Householder by Living Alone by Age of Householder B20004 Median Earnings by Sex by Educational Attainment B21004 Median Income by Veteran Status by Sex for the Civilian Population 18 Years and Over With Income B22008 Median Household Income by Receipt of Food Stamps/SNAP B23013 Median Age by Sex for Workers 16 to 64 Years B24081 Class of Worker by Median Earnings for the Civilian Population B24082 Sex by Class of Worker and Median Earnings for the Civilian Population B24090 Sex by Class of Worker for the Full-time, Year-round Civilian Population B24091 Class of Worker by Median Earnings for the Full-time, Year-round Civilian Population B24092 Sex by Class of Worker and Median Earnings for the Full-time, Year-round Civilian Population B25083 Median Value (Dollars) for Mobile Homes

Handle differently with aggregate present? B25017 Rooms B25018 Median Number of Rooms B25019 Aggregate Number of Rooms

B25020 Tenure by Rooms B25021 Median Number of Rooms by Tenure B25022 Aggregate Number of Rooms by Tenure

B25056 Contract Rent B25057 Lower Contract Rent Quartile (Dollars) B25058 Median Contract Rent (Dollars) B25059 Upper Contract Rent Quartile (Dollars) B25060 Aggregate Contract Rent (Dollars)

B25061 Rent Asked B25062 Aggregate Rent Asked (Dollars)

B25063 Gross Rent B25064 Median Gross Rent (Dollars)

B25075 Value B25076 Lower Value Quartile (Dollars) B25077 Median Value (Dollars) B25078 Upper Value Quartile (Dollars) B25079 Aggregate Value (Dollars) by Age of Householder

B25109 Median Value by Year Householder Moved Into Unit B25110 Aggregate Value (Dollars) by Year Householder Moved Into Unit

B25111 Median Gross Rent by Year Structure Built B25112 Aggregate Gross Rent (Dollars) by Year Structure Built

B25113 Median Gross Rent by Year Householder Moved Into Unit B25114 Aggregate Gross Rent (Dollars) by Year Householder Moved Into Unit

B25118 Tenure by Household Income B25119 Median Household Income the Past 12 Months by Tenure B25120 Aggregate Household Income by Tenure and Mortgage Status

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment