Last active
December 17, 2015 21:29
-
-
Save ryanpitts/5674750 to your computer and use it in GitHub Desktop.
revised template for geography_profile.json
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "geography": { | |
| "sumlev": null, // summary level of this geography | |
| "census_name": null, // official name from census data | |
| "pretty_name": null, // our version of name, e.g. 'Cook County, Illinois' | |
| "stusab": null, // state code | |
| "total_population": null, // total population here, standard place to fetch for calculations | |
| "land_area": null, // from TIGER data | |
| "census_release": null // release from which this data is drawn, e.g. 'ACS 2011 5-year' | |
| }, | |
| // for each data point, trying to standardize structure as | |
| // category > sub-category > data point > metadata/values | |
| "demographics": { | |
| "age": { | |
| "percent_under_18": { | |
| "table_id": "B01001", // Census table ID where we got this data | |
| "universe": "Total population", // Census universe for this table | |
| "name": "Percentage under 18", | |
| "values": { | |
| "geography": null, // data value for this geography | |
| "parent_county": null, // data value for parent county, if applicable | |
| "parent_state": null, // data value for parent state, if applicable | |
| "parent_nation": null // data value for nation | |
| } | |
| }, | |
| "percent_65_over": { | |
| "table_id": "B01001", | |
| "universe": "Total population", | |
| "name": "Percentage 65 and over", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| } | |
| }, | |
| "gender": { | |
| "percent_male": { | |
| "table_id": "B01001", | |
| "universe": "Total population", | |
| "name": "Percentage male", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| }, | |
| "percent_female": { | |
| "table_id": "B01001", | |
| "universe": "Total population", | |
| "name": "Percentage female", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| } | |
| }, | |
| "race": { | |
| "percent_white": { | |
| "table_id": "B02001", | |
| "universe": "Total population", | |
| "name": "Percentage white", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| }, | |
| "percent_black": { | |
| "table_id": "B02001", | |
| "universe": "Total population", | |
| "name": "Percentage black", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| }, | |
| "percent_american_indian": { | |
| "table_id": "B02001", | |
| "universe": "Total population", | |
| "name": "Percentage American Indian/Alaska native", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| }, | |
| "percent_asian": { | |
| "table_id": "B02001", | |
| "universe": "Total population", | |
| "name": "Percentage Asian", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| }, | |
| "percent_islander": { | |
| "table_id": "B02001", | |
| "universe": "Total population", | |
| "name": "Percentage Hawaiian/Pacific Islander", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| }, | |
| "percent_other": { | |
| "table_id": "B02001", | |
| "universe": "Total population", | |
| "name": "Percentage other", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| }, | |
| "percent_two_or_more": { | |
| "table_id": "B02001", | |
| "universe": "Total population", | |
| "name": "Percentage two or more", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| } | |
| }, | |
| "ethnicity": { | |
| "percent_hispanic": { | |
| "table_id": "B03001", | |
| "universe": "Total population", | |
| "name": "Percentage Hispanic/Latino", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| } | |
| } | |
| }, | |
| "economics": { | |
| "income": { | |
| "per_capita_income": { | |
| "table_id": "B19301", | |
| "universe": "Total population", | |
| "name": "Per capita income in past year", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| }, | |
| "median_household_income": { | |
| "table_id": "B19013", | |
| "name": "Median household income", | |
| "universe": "Households", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| } | |
| }, | |
| "poverty": { | |
| "percent_poverty": { | |
| "table_id": "B17001", | |
| "universe": "Population for whom poverty status is determined", | |
| "name": "Percentage of persons below poverty line", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| } | |
| } | |
| }, | |
| "education": { | |
| "attainment": { | |
| "percent_high_school": { | |
| "table_id": "B15002", | |
| "universe": "Population 25 years and over", | |
| "name": "Percentage high school graduate or higher", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| }, | |
| "percent_college": { | |
| "table_id": "B15002", | |
| "universe": "Population 25 years and over", | |
| "name": "Percentage bachelor's degree or higher", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| } | |
| } | |
| }, | |
| "employment": { | |
| "travel_time": { | |
| "mean_travel_time": { | |
| "table_id": "B08006, B08013", | |
| "universe": "Workers 16 years and over", | |
| "name": "Mean travel time to work in minutes", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| } | |
| } | |
| }, | |
| "families": { | |
| "households": { | |
| "number_households": { // THIS would be a good candidate for 'sibling median value' treatment | |
| "table_id": "B11001", | |
| "universe": "Households", | |
| "name": "Number of households", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| }, | |
| "persons_per_household": { | |
| "table_id": "B11001, B11002", | |
| "universe": "Households", | |
| "name": "Persons per household", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| } | |
| } | |
| }, | |
| "health": {}, | |
| "housing": { | |
| "housing_units": { | |
| "number_housing_units": { // THIS would be a good candidate for 'sibling median value' treatment | |
| "table_id": "B25001", | |
| "universe": "Housing units", | |
| "name": "Number of housing units", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| }, | |
| "percent_multi_unit": { | |
| "table_id": "B25024", | |
| "universe": "Housing units", | |
| "name": "Percentage of housing units in multi-unit structures", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| } | |
| }, | |
| "tenure": { | |
| "rate_homeownership": { | |
| "table_id": "B25003", | |
| "universe": "Occupied housing units", | |
| "name": "Rate of homeownership", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| } | |
| }, | |
| "value": { | |
| "median_value": { | |
| "table_id": "B25077", | |
| "universe": "Owner-occupied housing units", | |
| "name": "Median value of owner-occupied housing units", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| } | |
| } | |
| "mobility": { | |
| "percent_same_house": { | |
| "table_id": "B07001", | |
| "universe": "Population 1 year and over in the United States", | |
| "name": "Percentage living in same house for 1 year or more", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| } | |
| }, | |
| }, | |
| "sociocultural": { | |
| "place_of_birth": { | |
| "percent_foreign_born": { | |
| "table_id": "B05002", | |
| "universe": "Total population", | |
| "name": "Percentage of foreign-born persons", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| } | |
| }, | |
| "language": { | |
| "percent_non_english_at_home": { | |
| "table_id": "B16001", | |
| "universe": "Population 5 years and over", | |
| "name": "Percentage of persons with language other than English spoken at home", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| } | |
| } | |
| }, | |
| "veterans": { | |
| "veteran_status": { | |
| "number_veterans": { // THIS would be a good candidate for 'sibling median value' treatment | |
| "table_id": "B21002", | |
| "universe": "Civilian veterans 18 years and over", | |
| "name": "Number of veterans", | |
| "values": { | |
| "geography": null, | |
| "parent_county": null, | |
| "parent_state": null, | |
| "parent_nation": null | |
| } | |
| } | |
| } | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment