Name: CDC Nutrition, Physical Activity, And Obesity
Creator: Kaggle
License: https://opendatacommons.org/licenses/by/1-0/index.html

About this Dataset

CDC Nutrition, Physical Activity, And Obesity

DESCRIPTION
2011 - 2015 data on adult diet, physical activity, and weight status by state
SUMMARY
This dataset includes data on adult's diet, physical activity, and weight status from Behavioral Risk Factor Surveillance System. 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.

Source: CDC via Data.gov

Tables

Cdc Npao

@kaggle.mahdiehhajian_cdc_nutrition_physical_activity_and_obesity.cdc_npao

514.31 kB
48,772 rows
33 columns

CREATE TABLE cdc_npao (
  "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" DOUBLE,
  "data_value_alt" DOUBLE,
  "data_value_footnote_symbol" VARCHAR,
  "data_value_footnote" VARCHAR,
  "low_confidence_limit" DOUBLE,
  "high_confidence_limit" DOUBLE,
  "sample_size" DOUBLE,
  "total" VARCHAR,
  "age_years" VARCHAR  -- Age(years),
  "education" VARCHAR,
  "gender" VARCHAR,
  "income" VARCHAR,
  "race_ethnicity" VARCHAR,
  "geolocation" VARCHAR,
  "classid" VARCHAR,
  "topicid" VARCHAR,
  "questionid" VARCHAR,
  "datavaluetypeid" VARCHAR,
  "locationid" BIGINT,
  "stratificationcategory1" VARCHAR,
  "stratification1" VARCHAR,
  "stratificationcategoryid1" VARCHAR,
  "stratificationid1" VARCHAR
);

Cdc Npao Topics

@kaggle.mahdiehhajian_cdc_nutrition_physical_activity_and_obesity.cdc_npao_topics

6.3 kB
9 rows
7 columns

CREATE TABLE cdc_npao_topics (
  "class" VARCHAR,
  "topic" VARCHAR,
  "question" VARCHAR,
  "short_desc" VARCHAR,
  "classid" VARCHAR,
  "topicid" VARCHAR,
  "questionid" VARCHAR
);