About this Dataset

Nutrition, Physical Activity, And Obesity - Policy And Environmental Data

This dataset includes data on policy and environmental supports for physical activity, diet, and breastfeeding. 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.
Organization: U.S. Department of Health & Human Services
Last updated: 2020-11-10T16:18:09.577094
Tags: breastfeeding, dnpao, fruit, nutrition, physical-activity, vegetable

Tables

Table 1

@usgov.hhs_gov_nutrition_physical_activity_and_obesity_policy_19eea7e2.table_1

89.16 kB
6,295 rows
25 columns

CREATE TABLE table_1 (
  "yearstart" BIGINT,
  "yearend" BIGINT,
  "locationabbr" VARCHAR,
  "locationdesc" VARCHAR,
  "datasource" VARCHAR,
  "class" VARCHAR,
  "topic" VARCHAR,
  "question" VARCHAR,
  "data_value_unit" VARCHAR,
  "data_value_type" VARCHAR,
  "data_value" VARCHAR,
  "data_value_alt" DOUBLE,
  "data_value_footnote_symbol" VARCHAR,
  "data_value_footnote" VARCHAR,
  "total" VARCHAR,
  "geolocation" VARCHAR,
  "classid" VARCHAR,
  "topicid" VARCHAR,
  "questionid" VARCHAR,
  "datavaluetypeid" VARCHAR,
  "locationid" BIGINT,
  "stratificationcategory1" VARCHAR,
  "stratification1" VARCHAR,
  "stratificationcategoryid1" VARCHAR,
  "stratificationid1" VARCHAR
);