Readme
Updated 12 months ago
‧ Indexed 41 minutes ago
Nutrition, Physical Activity, and Obesity - American Community Survey
This dataset includes select data from the U.S. Census Bureau's American Community Survey (ACS) on the percent of adults who bike or walk to work. This data is used for DNPAO's Data, Trends, and Maps database, which provides national and state specific data on obesity, nutrition, physical activity, and breastfeeding. For more information about ACS visit https://www.census.gov/programs-surveys/acs/.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| StratificationID1 | stratificationid1 | stratificationid1 | Text | Lookup identifier value for StratificationCategory1 |
| StratificationCategoryId1 | stratificationcategoryid1 | stratificationcategoryid1 | Text | Lookup identifier value for Stratification1 |
| GeoLocation (zip) | geolocation_zip | geolocation_zip | Text | |
| GeoLocation (address) | geolocation_address | geolocation_address | Text | |
| Question | question | question | Text | Question Description |
| Data_Value_Type | data_value_type | data_value_type | Text | Description of type of data e.g. Value, Percentage, Number |
| DataValueTypeID | datavaluetypeid | datavaluetypeid | Text | Lookup identification value for Data_Value_type |
| Stratification1 | stratification1 | stratification1 | Text | Data stratified by this value, such as Male, Female, Total |
| ClassID | classid | classid | Text | Lookup identifier value for Class |
| YearStart | yearstart | yearstart | Number | Year start |
| Data_Value_Alt | data_value_alt | data_value_alt | Number | Numeric representation of data value |
| Total | total | total | Text | Total/Overall breakout category |
| High_Confidence_Limit | high_confidence_limit | high_confidence_limit | Number | High 95% Confidence Interval value |
| Low_Confidence_Limit | low_confidence_limit | low_confidence_limit | Number | Low 95% Confidence Interval value |
| Data_Value | data_value | data_value | Number | Data value (percentage, text) |
| QuestionID | questionid | questionid | Text | Lookup identifier value for Indicator |
| Class | class | class | Text | Class Description |
| Topic | topic | topic | Text | Topic Description |
| GeoLocation | geolocation | geolocation | Point | Latitude & Longitude to be provided for formatting GeoLocation or Geocode in the format (latitude, longitude) |
| LocationID | locationid | locationid | Text | Lookup identifier value for Location |
| StratificationCategory1 | stratificationcategory1 | stratificationcategory1 | Text | Lookup Identification value, such as Age Group, Gender |
| LocationAbbr | locationabbr | locationabbr | Text | Location abbreviation |
| Data_Value_Unit | data_value_unit | data_value_unit | Text | Description of unit e.g. %, etc |
| Data_Value_Footnote | data_value_footnote | data_value_footnote | Text | Footnote text |
| GeoLocation (city) | geolocation_city | geolocation_city | Text | |
| States | :@computed_region_bxsw_vy29 | :@computed_region_bxsw_vy29 | Number | |
| Counties | :@computed_region_he4y_prf8 | :@computed_region_he4y_prf8 | Number | |
| GeoLocation (state) | geolocation_state | geolocation_state | Text | |
| Data_Value_Footnote_Symbol | data_value_footnote_symbol | data_value_footnote_symbol | Text | Symbol that would be used to flag footnotes |
| YearEnd | yearend | yearend | Number | Year End (for single-year indicator, year end=year start) |
| Datasource | datasource | datasource | Text | Abbreviation of Data Source |
| TopicID | topicid | topicid | Text | Lookup identifier value for Topic |
| LocationDesc | locationdesc | locationdesc | Text | Location description |
Upstream Metadata