Skip to content

Instantly share code, notes, and snippets.

@bmount
Created August 19, 2013 23:33
Show Gist options
  • Save bmount/6275440 to your computer and use it in GitHub Desktop.
Save bmount/6275440 to your computer and use it in GitHub Desktop.
human readable column name -> description mapping for American Community Survey tables, tract detail dataset
{"dp0150001": "Households with individuals 65 years and over", "dp0090004": "Total races tallied: Asian alone or in combination with one or more other races", "dp0090005": "Total races tallied: Native Hawaiian and Other Pacific Islander alone or in combination with one or more other races", "shape": "Unrepresentable_Domain: Coordinates defining the features.", "dp0090001": "Total races tallied: White alone or in combination with one or more other races", "dp0090002": "Total races tallied: Black or African American alone or in combination with one or more other races", "dp0090003": "Total races tallied: American Indian and Alaska Native alone or in combination with one or more other races", "dp0120006": "Total population: In Households: Child: Own child under 18 years", "dp0010040": "Total Population: Female: Under 5 years", "dp0010041": "Total Population: Female: 5 to 9 years", "dp0010042": "Total Population: Female: 10 to 14 years", "dp0010043": "Total Population: Female: 15 to 19 years", "dp0010044": "Total Population: Female: 20 to 24 years", "dp0010045": "Total Population: Female: 25 to 29 years", "dp0010046": "Total Population: Female: 30 to 34 years", "dp0010047": "Total Population: Female: 35 to 39 years", "dp0010048": "Total Population: Female: 40 to 44 years", "dp0010049": "Total Population: Female: 45 to 49 years", "fid": "Sequential unique whole numbers that are automatically generated.", "statefp10": "Attribute_Definition_Source: U.S. Census Bureau", "dp0220002": "Population in occupied housing units by tenure: Renter-occupied housing units", "dp0190001": "Homeowner vacancy rate (percent}", "dp0130009": "Households: Total: Female householder, no husband present: With own children under 18 years", "dp0030002": "Population 16 years and over: Male", "dp0030003": "Population 16 years and over: Female", "dp0030001": "Population 16 years and over: Total", "dp0010035": "Total Population: Male: 70 to 74 years", "dp0010034": "Total Population: Male: 65 to 69 years", "dp0010037": "Total Population: Male: 80 to 84 years", "dp0010036": "Total Population: Male: 75 to 79 years", "dp0010031": "Total Population: Male: 50 to 54 years", "dp0010030": "Total Population: Male: 45 to 49 years", "dp0010033": "Total Population: Male: 60 to 64 years", "dp0010032": "Total Population: Male: 55 to 59 years", "dp0040001": "Population 18 years and over: Total", "dp0040003": "Population 18 years and over: Female", "dp0040002": "Population 18 years and over: Male", "dp0010039": "Total Population: Female", "dp0010038": "Total Population: Male: 85 years and over", "dp0130004": "Households: Total: Husband-wife family", "dp0180001": "Total housing units: Total", "dp0130002": "Households: Total: Family households (families)", "lsad10": "Attribute_Definition_Source: U.S. Census Bureau", "dp0180006": "Total housing units: Total: Vacant housing units: For sale only", "dp0120013": "Total population: In Households: Nonrelatives: Unmarried partner", "dp0180004": "Total housing units: Total: Vacant housing units: For rent", "dp0180005": "Total housing units: Total: Vacant housing units: Rented, not occupied", "dp0180002": "Total housing units: Occupied housing units", "dp0130003": "Households: Total: Family households (families): With own children under 18 years", "dp0120012": "Total population: In Households: Nonrelatives: 65 years and over", "dp0100006": "Total Population: Hispanic or Latino (of any race): Other Hispanic or Latino", "dp0100007": "Total population: Not Hispanic or Latino", "dp0100004": "Total population: Hispanic or Latino (of any race): Puerto Rican", "dp0100005": "Total population: Hispanic or Latino (of any race): Cuban", "dp0100002": "Total Population: Hispanic or Latino (of any race):", "dp0100003": "Total population: Hispanic or Latino (of any race): Mexican", "dp0180008": "Total housing units: Total: Vacant housing units: For seasonal, recreational, or occasional use", "dp0100001": "Total population: Total", "dp0010026": "Total Population: Male: 25 to 29 years", "dp0010027": "Total Population: Male: 30 to 34 years", "dp0010024": "Total Population: Male: 15 to 19 years", "dp0010025": "Total Population: Male: 20 to 24 years", "dp0010022": "Total Population: Male: 5 to 9 years", "dp0010023": "Total Population: Male: 10 to 14 years", "dp0010020": "Total Population: Male", "dp0010021": "Total Population: Male: Under 5 years", "dp0170001": "Average family size", "dp0010028": "Total Population: Male: 35 to 39 years", "dp0010029": "Total Population: Male: 40 to 44 years", "dp0120015": "Total population: In Households: In Group Quarters: Institutionalized population", "dp0070002": "Population 65 years and over: Male", "dp0070003": "Population 65 years and over: Female", "dp0070001": "Population 65 years and over: Total", "dp0220001": "Population in occupied housing units by tenure: Owner-occupied housing units", "dp0010019": "Total Population: 85 years and over", "dp0010018": "Total Population: 80 to 84 years", "intptlat10": "Attribute_Definition_Source: U.S. Census Bureau", "dp0010013": "Total Population: 55 to 59 years", "dp0010012": "Total Population: 50 to 54 years", "dp0010011": "Total Population: 45 to 49 years", "dp0010010": "Total Population: 40 to 44 years", "dp0010017": "Total Population: 75 to 79 years", "dp0010016": "Total Population: 70 to 74 years", "dp0010015": "Total Population: 65 to 69 years", "dp0010014": "Total Population: 60 to 64 years", "dp0090006": "Total races tallied: Some Other Race alone or in combination with one or more other races", "dp0120020": "Total population: In Households: In Group Quarters: Noninstitutionalized population: Female", "dp0130008": "Households: Total: Female householder, no husband present", "dp0140001": "Households with individuals under 18 years: Total", "funcstat10": "Attribute_Definition_Source: U.S. Census Bureau", "dp0120019": "Total population: In Households: In Group Quarters: Noninstitutionalized population: Male", "dp0120018": "Total population: In Households: In Group Quarters: Noninstitutionalized population", "dp0010008": "Total Population: 30 to 34 years", "dp0010009": "Total Population: 35 to 39 years", "dp0010004": "Total Population: 10 to 14 years", "dp0010005": "Total Population: 15 to 19 years", "dp0010006": "Total Population: 20 to 24 years", "dp0010007": "Total Population: 25 to 29 years", "dp0120017": "Total population: In Households: In Group Quarters: Institutionalized population: Female", "dp0010001": "Total Population", "dp0010002": "Total Population: Under 5 years", "dp0010003": "Total Population: 5 to 9 years", "dp0080005": "Population of one race: American Indian and Alaska Native", "dp0080004": "Population of one race: Black or African American", "dp0080007": "Population of one race: Asian: Asian Indian", "dp0080006": "Population of one race: Asian", "dp0080001": "Total Population: Total", "dp0080003": "Population of one race: White", "dp0080002": "Population of one race: Total", "aland10": "Attribute_Definition_Source: U.S. Census Bureau", "dp0080009": "Population of one race: Asian: Filipino", "dp0080008": "Population of one race: Asian: Chinese", "entity_type:": "Entity_Type_Definition_Source: U.S. Census Bureau", "dp0120011": "Total population: In Households: Nonrelatives: Under 18 years", "dp0020003": "Median age: Female", "dp0020002": "Median age: Male", "dp0020001": "Median Age: Both sexes", "namelsad10": "Attribute_Definition_Source: U.S. Census Bureau", "dp0120008": "Total population: In Households: Other relatives: Under 18 years", "dp0120009": "Total population: In Households: Other relatives: 65 years and over", "dp0120004": "Total population: In Households: Spouse", "dp0120005": "Total population: In Households: Child", "lsy10": "Attribute_Label: LSY10", "dp0120007": "Total population: In Households: Other relatives", "dp0120001": "Total population: Total", "dp0120002": "Total population: In Households", "dp0120003": "Total population: In Households: Householder", "dp0080016": "Population of one race: Native Hawaiian and Other Pacific Islander: Guamanian or Chamorro", "dp0080017": "Population of one race: Native Hawaiian and Other Pacific Islander: Samoan", "dp0080014": "Population of one race: Native Hawaiian and Other Pacific Islander", "dp0080015": "Populatin of one race: Native Hawaiian and Other Pacific Islander: Native Hawaiian", "dp0080012": "Population of one race: Asian: Vietnamese", "dp0080013": "Population of one race: Asian: Other Asian", "dp0080010": "Population of one race: Asian: Japanese", "dp0080011": "Population of one race: Asian: Korean", "dp0130005": "Households: Total: Husband-wife family: With own children under 18 years", "dp0120010": "Total population: In Households: Nonrelatives", "dp0130007": "Households: Total: Male householder, no wife present: With own children under 18 years", "dp0130006": "Households: Total: Male householder, no wife present", "dp0130001": "Households: Total", "dp0080018": "Population of one race: Native Hawaiian and Other Pacific Islander: Other Pacific Islander", "dp0080019": "Population of one race: Native Hawaiian and Other Pacific Islander: Some Other Race", "dp0230001": "Average household size of occupied housing unites by tenure: Owner occupied", "dp0230002": "Average household size of occupied housing units by tenure: Renter occupied", "dp0050001": "Population 21 years and over: Total", "dp0050002": "Population 21 years and over: Male", "dp0050003": "Population 21 years and over: Female", "geoid10": "Attribute_Definition_Source: U.S. Census Bureau", "dp0180003": "Total housing units: Total: Vacant housing units", "dp0200001": "Rental vacancy rate (percent)", "dp0110009": "Total population: Hispanic or Latino: Two or More Races", "dp0110008": "Total population: Hispanic or Latino: Some Other Race alone", "dp0110007": "Total population: Hispanic or Latino: Native Hawaiian and Other Pacific Islander alone", "dp0110006": "Total population: Hispanic or Latino: Asian alone", "dp0110005": "Total population: Hispanic or Latino: American Indian and Alaska Native alone", "dp0110004": "Total population: Hispanic or Latino: Black or African American alone", "dp0110003": "Total population: Hispanic or Latino: White alone", "dp0110002": "Total population: Hispanic or Latino", "dp0110001": "Total population: Total", "sldlst10": "Attribute_Label: SLDLST10", "dp0120016": "Total population: In Households: In Group Quarters: Institutionalized population: Male", "dp0080023": "Population of Two or More Races: White; Black or African American", "dp0080022": "Population of Two or More Races: White; Asian", "dp0080021": "Population of Two or More Races: White; American Indian and Alaska Native", "dp0080020": "Population of Two or More Races:", "dp0080024": "Population of Two or More Races: White; Some Other Race", "awater10": "Attribute_Definition_Source: U.S. Census Bureau", "dp0180007": "Total housing units: Total: Vacant housing units: Sold, not occupied", "dp0130014": "Households: Total: Nonfamily households: Householder living alone: Female", "dp0130015": "Households: Total: Nonfamily households: Householder living alone: Female: 65 years and over", "dp0130012": "Households: Total: Nonfamily households: Householder living alone: Male", "dp0130013": "Households: Total: Nonfamily households: Householder living alone: Male: 65 years and over", "dp0130010": "Households: Total: Nonfamily households", "dp0130011": "Households: Total: Nonfamily households: Householder living alone", "dp0210002": "Housing Tenure: Occupied housing units: Total: Owner-occupied housing units", "dp0210003": "Housing Tenure: Occupied housing units: Total: Renter-occupied housing units", "dp0210001": "Housing Tenure: Occupied housing units: Total", "dp0160001": "Average household size", "dp0180009": "Total housing units: Total: Vacant housing units: All other vacants", "intptlon10": "Attribute_Definition_Source: U.S. Census Bureau", "dp0110010": "Total population: Not Hispanic or Latino", "dp0110011": "Total population: Not Hispanic or Latino: White Alone", "dp0110012": "Total population: Not Hispanic or Latino: Black or African American Alone", "dp0110013": "Total population: Not Hispanic or Latino: American Indian and Alaska Native alone", "dp0110014": "Total population: Not Hispanic or Latino: Asian alone", "dp0110015": "Total population: Not Hispanic or Latino: Native Hawaiian and Other Pacific Islander Alone", "dp0110016": "Total population: Not Hispanic or Latino: Some Other Race Alone", "dp0110017": "Total population: Not Hispanic or Latino: Two or More Races", "dp0060003": "Population 62 years and over: Female", "dp0060002": "Population 62 years and over: Male", "dp0060001": "Population 62 years and over: Total", "dp0120014": "Total population: In Households: In Group Quarters", "dp0010057": "Total Population: Female: 85 years and over", "dp0010056": "Total Population: Female: 80 to 84 years", "dp0010055": "Total Population: Female: 75 to 79 years", "dp0010054": "Total Population: Female: 70 to 74 years", "dp0010053": "Total Population: Female: 65 to 69 years", "dp0010052": "Total Population: Female: 60 to 64 years", "dp0010051": "Total Population: Female: 55 to 59 years", "dp0010050": "Total Population: Female: 50 to 54 years", "mtfcc10": "Attribute_Definition_Source: U.S. Census Bureau"}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment