CDC Nutrition, Physical Activity, And Obesity

2011 - 2015 data on adult diet, physical activity, and weight status by state

@kaggle.mahdiehhajian_cdc_nutrition_physical_activity_and_obesity

Table List

2 tables(508.41 KB)

Cdc Npao

@kaggle.mahdiehhajian_cdc_nutrition_physical_activity_and_obesity.cdc_npao

502.26 KB
48772 rows
33 columns

yearstart YearStart	yearend YearEnd	locationabbr LocationAbbr	locationdesc LocationDesc	datasource Datasource	class Class	topic Topic	question Question	data_value_type Data Value Type	data_value Data Value	data_value_alt Data Value Alt	data_value_footnote_symbol Data Value Footnote Symbol	data_value_footnote Data Value Footnote	low_confidence_limit Low Confidence Limit	high_confidence_limit High Confidence Limit	sample_size Sample Size	total Total	age_years Age(years)	education Education	gender Gender	income Income	race_ethnicity Race/Ethnicity	geolocation GeoLocation	classid ClassID	topicid TopicID	questionid QuestionID	datavaluetypeid DataValueTypeID	locationid LocationID	stratificationcategory1 StratificationCategory1	stratification1 Stratification1	stratificationcategoryid1 StratificationCategoryId1	stratificationid1 StratificationID1
2011	2011	AL	Alabama	Behavioral Risk Factor Surveillance System	Obesity / Weight Status	Obesity / Weight Status	Percent of adults aged 18 years and older who have obesity	Value	32	32	nan	nan	30.5	33.5	7304	Total	nan	nan	nan	nan	nan	(32.84057112200048, -86.63186076199969)	OWS	OWS1	Q036	VALUE	1	Total	Total	OVR	OVERALL
2011	2011	AL	Alabama	Behavioral Risk Factor Surveillance System	Obesity / Weight Status	Obesity / Weight Status	Percent of adults aged 18 years and older who have obesity	Value	32.3	32.3	nan	nan	29.9	34.7	2581	nan	nan	nan	Male	nan	nan	(32.84057112200048, -86.63186076199969)	OWS	OWS1	Q036	VALUE	1	Gender	Male	GEN	MALE
2011	2011	AL	Alabama	Behavioral Risk Factor Surveillance System	Obesity / Weight Status	Obesity / Weight Status	Percent of adults aged 18 years and older who have obesity	Value	31.8	31.8	nan	nan	30	33.6	4723	nan	nan	nan	Female	nan	nan	(32.84057112200048, -86.63186076199969)	OWS	OWS1	Q036	VALUE	1	Gender	Female	GEN	FEMALE
2011	2011	AL	Alabama	Behavioral Risk Factor Surveillance System	Obesity / Weight Status	Obesity / Weight Status	Percent of adults aged 18 years and older who have obesity	Value	33.6	33.6	nan	nan	29.9	37.6	1153	nan	nan	Less than high school	nan	nan	nan	(32.84057112200048, -86.63186076199969)	OWS	OWS1	Q036	VALUE	1	Education	Less than high school	EDU	EDUHS
2011	2011	AL	Alabama	Behavioral Risk Factor Surveillance System	Obesity / Weight Status	Obesity / Weight Status	Percent of adults aged 18 years and older who have obesity	Value	32.8	32.8	nan	nan	30.2	35.6	2402	nan	nan	High school graduate	nan	nan	nan	(32.84057112200048, -86.63186076199969)	OWS	OWS1	Q036	VALUE	1	Education	High school graduate	EDU	EDUHSGRAD
2011	2011	AL	Alabama	Behavioral Risk Factor Surveillance System	Obesity / Weight Status	Obesity / Weight Status	Percent of adults aged 18 years and older who have obesity	Value	33.8	33.8	nan	nan	31	36.8	1925	nan	nan	Some college or technical school	nan	nan	nan	(32.84057112200048, -86.63186076199969)	OWS	OWS1	Q036	VALUE	1	Education	Some college or technical school	EDU	EDUCOTEC
2011	2011	AL	Alabama	Behavioral Risk Factor Surveillance System	Obesity / Weight Status	Obesity / Weight Status	Percent of adults aged 18 years and older who have obesity	Value	26.4	26.4	nan	nan	23.7	29.3	1812	nan	nan	College graduate	nan	nan	nan	(32.84057112200048, -86.63186076199969)	OWS	OWS1	Q036	VALUE	1	Education	College graduate	EDU	EDUCOGRAD
2011	2011	AL	Alabama	Behavioral Risk Factor Surveillance System	Obesity / Weight Status	Obesity / Weight Status	Percent of adults aged 18 years and older who have obesity	Value	16.3	16.3	nan	nan	12.6	20.9	356	nan	18 - 24	nan	nan	nan	nan	(32.84057112200048, -86.63186076199969)	OWS	OWS1	Q036	VALUE	1	Age (years)	18 - 24	AGEYR	AGEYR1824
2011	2011	AL	Alabama	Behavioral Risk Factor Surveillance System	Obesity / Weight Status	Obesity / Weight Status	Percent of adults aged 18 years and older who have obesity	Value	35.2	35.2	nan	nan	30.7	40	598	nan	25 - 34	nan	nan	nan	nan	(32.84057112200048, -86.63186076199969)	OWS	OWS1	Q036	VALUE	1	Age (years)	25 - 34	AGEYR	AGEYR2534
2011	2011	AL	Alabama	Behavioral Risk Factor Surveillance System	Obesity / Weight Status	Obesity / Weight Status	Percent of adults aged 18 years and older who have obesity	Value	35.5	35.5	nan	nan	31.6	39.6	865	nan	35 - 44	nan	nan	nan	nan	(32.84057112200048, -86.63186076199969)	OWS	OWS1	Q036	VALUE	1	Age (years)	35 - 44	AGEYR	AGEYR3544


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
);