Dataset: CDC Nutrition, Physical Activity, And Obesity

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

502.26 KB
48772 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,
  "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.15 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
);