Behavioral Risk Factor Surveillance System
Public health surveys of 400k people from 2011-2015
@kaggle.cdc_behavioral_risk_factor_surveillance_system
Public health surveys of 400k people from 2011-2015
@kaggle.cdc_behavioral_risk_factor_surveillance_system
The objective of the BRFSS is to collect uniform, state-specific data on preventive health practices and risk
behaviors that are linked to chronic diseases, injuries, and preventable infectious diseases in the adult population.
Factors assessed by the BRFSS include tobacco use, health care coverage, HIV/AIDS knowledge or prevention,
physical activity, and fruit and vegetable consumption. Data are collected from a random sample of adults (one per
household) through a telephone survey.
The Behavioral Risk Factor Surveillance System (BRFSS) is the nation's premier system of health-related telephone surveys that collect state data about U.S. residents regarding their health-related risk behaviors, chronic health conditions, and use of preventive services. Established in 1984 with 15 states, BRFSS now collects data in all 50 states as well as the District of Columbia and three U.S. territories. BRFSS completes more than 400,000 adult interviews each year, making it the largest continuously conducted health survey system in the world.
This dataset was released by the CDC. You can find the original dataset and additional years of data here.
CREATE TABLE n_2011 (
"n__state" DOUBLE -- STATE,
"n__geostr" DOUBLE -- GEOSTR,
"n__denstr2" DOUBLE -- DENSTR2,
"precall" DOUBLE,
"repnum" DOUBLE,
"repdepth" DOUBLE,
"fmonth" DOUBLE,
"idate" VARCHAR,
"imonth" VARCHAR,
"iday" VARCHAR,
"iyear" VARCHAR,
"intvid" VARCHAR,
"dispcode" DOUBLE,
"seqno" DOUBLE,
"n__psu" DOUBLE -- PSU,
"nattmpts" DOUBLE,
"nrecsel" DOUBLE,
"nrecstr" DOUBLE,
"ctelenum" DOUBLE,
"cellfon" DOUBLE,
"pvtresid" DOUBLE,
"numadult" DOUBLE,
"nummen" DOUBLE,
"numwomen" DOUBLE,
"genhlth" DOUBLE,
"physhlth" DOUBLE,
"menthlth" DOUBLE,
"poorhlth" DOUBLE,
"hlthpln1" DOUBLE,
"persdoc2" DOUBLE,
"medcost" DOUBLE,
"checkup1" DOUBLE,
"bphigh4" DOUBLE,
"bpmeds" DOUBLE,
"bloodcho" DOUBLE,
"cholchk" DOUBLE,
"toldhi2" DOUBLE,
"cvdinfr4" DOUBLE,
"cvdcrhd4" DOUBLE,
"cvdstrk3" DOUBLE,
"asthma3" DOUBLE,
"asthnow" DOUBLE,
"chcscncr" DOUBLE,
"chcocncr" DOUBLE,
"chccopd" DOUBLE,
"havarth3" DOUBLE,
"addepev2" DOUBLE,
"chckidny" DOUBLE,
"chcvison" DOUBLE,
"diabete3" DOUBLE,
"smoke100" DOUBLE,
"smokday2" DOUBLE,
"stopsmk2" DOUBLE,
"lastsmk2" DOUBLE,
"usenow3" DOUBLE,
"age" DOUBLE,
"hispanc2" DOUBLE,
"mrace" VARCHAR,
"orace2" DOUBLE,
"veteran3" DOUBLE,
"marital" DOUBLE,
"children" DOUBLE,
"educa" DOUBLE,
"employ" DOUBLE,
"income2" DOUBLE,
"weight2" DOUBLE,
"height3" DOUBLE,
"ctycode1" DOUBLE,
"numhhol2" DOUBLE,
"numphon2" DOUBLE,
"cpdemo1" DOUBLE,
"cpdemo2" DOUBLE,
"cpdemo3" DOUBLE,
"cpdemo4" DOUBLE,
"renthom1" DOUBLE,
"sex" DOUBLE,
"pregnant" DOUBLE,
"fruitju1" DOUBLE,
"fruit1" DOUBLE,
"fvbeans" DOUBLE,
"fvgreen" DOUBLE,
"fvorang" DOUBLE,
"vegetab1" DOUBLE,
"exerany2" DOUBLE,
"exract01" DOUBLE,
"exeroft1" DOUBLE,
"exerhmm1" DOUBLE,
"exract02" DOUBLE,
"exeroft2" DOUBLE,
"exerhmm2" DOUBLE,
"strength" DOUBLE,
"qlactlm2" DOUBLE,
"useequip" DOUBLE,
"lmtjoin3" DOUBLE,
"arthdis2" DOUBLE,
"arthsocl" DOUBLE,
"joinpain" DOUBLE,
"seatbelt" DOUBLE,
"flushot5" DOUBLE,
"flshtmy2" DOUBLE
);CREATE TABLE n_2012 (
"n__state" DOUBLE -- STATE,
"n__geostr" DOUBLE -- GEOSTR,
"n__denstr2" DOUBLE -- DENSTR2,
"precall" DOUBLE,
"repnum" DOUBLE,
"repdepth" DOUBLE,
"fmonth" DOUBLE,
"idate" VARCHAR,
"imonth" VARCHAR,
"iday" VARCHAR,
"iyear" VARCHAR,
"intvid" VARCHAR,
"dispcode" DOUBLE,
"seqno" DOUBLE,
"n__psu" DOUBLE -- PSU,
"nattmpts" DOUBLE,
"nrecsel" DOUBLE,
"nrecstr" DOUBLE,
"ctelenum" DOUBLE,
"pvtresid" DOUBLE,
"colghous" DOUBLE,
"cellfon" DOUBLE,
"ladult" DOUBLE,
"numadult" DOUBLE,
"nummen" DOUBLE,
"numwomen" DOUBLE,
"genhlth" DOUBLE,
"physhlth" DOUBLE,
"menthlth" DOUBLE,
"poorhlth" DOUBLE,
"hlthpln1" DOUBLE,
"persdoc2" DOUBLE,
"medcost" DOUBLE,
"checkup1" DOUBLE,
"exerany2" DOUBLE,
"cvdinfr4" DOUBLE,
"cvdcrhd4" DOUBLE,
"cvdstrk3" DOUBLE,
"asthma3" DOUBLE,
"asthnow" DOUBLE,
"chcscncr" DOUBLE,
"chcocncr" DOUBLE,
"chccopd1" DOUBLE,
"havarth3" DOUBLE,
"addepev2" DOUBLE,
"chckidny" DOUBLE,
"chcvisn1" DOUBLE,
"diabete3" DOUBLE,
"lastden3" DOUBLE,
"rmvteth3" DOUBLE,
"age" DOUBLE,
"hispanc2" DOUBLE,
"mrace" VARCHAR,
"orace2" DOUBLE,
"veteran3" DOUBLE,
"marital" DOUBLE,
"children" DOUBLE,
"educa" DOUBLE,
"employ" DOUBLE,
"income2" DOUBLE,
"weight2" DOUBLE,
"height3" DOUBLE,
"ctycode1" DOUBLE,
"numhhol2" DOUBLE,
"numphon2" DOUBLE,
"cpdemo1" DOUBLE,
"cpdemo4" DOUBLE,
"renthom1" DOUBLE,
"sex" DOUBLE,
"pregnant" DOUBLE,
"qlactlm2" DOUBLE,
"useequip" DOUBLE,
"smoke100" DOUBLE,
"smokday2" DOUBLE,
"stopsmk2" DOUBLE,
"lastsmk2" DOUBLE,
"usenow3" DOUBLE,
"alcday5" DOUBLE,
"avedrnk2" DOUBLE,
"drnk3ge5" DOUBLE,
"maxdrnks" DOUBLE,
"flushot5" DOUBLE,
"flshtmy2" DOUBLE,
"imfvplac" DOUBLE,
"pneuvac3" DOUBLE,
"fall12mn" DOUBLE,
"fallinj2" DOUBLE,
"seatbelt" DOUBLE,
"drnkdri2" DOUBLE,
"hadmam" DOUBLE,
"howlong" DOUBLE,
"profexam" DOUBLE,
"lengexam" DOUBLE,
"hadpap2" DOUBLE,
"lastpap2" DOUBLE,
"hadhyst2" DOUBLE,
"pcpsaad1" DOUBLE,
"pcpsadi1" DOUBLE,
"pcpsare1" DOUBLE,
"psatest1" DOUBLE
);CREATE TABLE n_2013 (
"n__state" DOUBLE -- STATE,
"fmonth" DOUBLE,
"idate" VARCHAR,
"imonth" VARCHAR,
"iday" VARCHAR,
"iyear" VARCHAR,
"dispcode" DOUBLE,
"seqno" DOUBLE,
"n__psu" DOUBLE -- PSU,
"ctelenum" DOUBLE,
"pvtresd1" DOUBLE,
"colghous" DOUBLE,
"stateres" DOUBLE,
"cellfon3" DOUBLE,
"ladult" DOUBLE,
"numadult" DOUBLE,
"nummen" DOUBLE,
"numwomen" DOUBLE,
"genhlth" DOUBLE,
"physhlth" DOUBLE,
"menthlth" DOUBLE,
"poorhlth" DOUBLE,
"hlthpln1" DOUBLE,
"persdoc2" DOUBLE,
"medcost" DOUBLE,
"checkup1" DOUBLE,
"sleptim1" DOUBLE,
"bphigh4" DOUBLE,
"bpmeds" DOUBLE,
"bloodcho" DOUBLE,
"cholchk" DOUBLE,
"toldhi2" DOUBLE,
"cvdinfr4" DOUBLE,
"cvdcrhd4" DOUBLE,
"cvdstrk3" DOUBLE,
"asthma3" DOUBLE,
"asthnow" DOUBLE,
"chcscncr" DOUBLE,
"chcocncr" DOUBLE,
"chccopd1" DOUBLE,
"havarth3" DOUBLE,
"addepev2" DOUBLE,
"chckidny" DOUBLE,
"diabete3" DOUBLE,
"veteran3" DOUBLE,
"marital" DOUBLE,
"children" DOUBLE,
"educa" DOUBLE,
"employ1" DOUBLE,
"income2" DOUBLE,
"weight2" DOUBLE,
"height3" DOUBLE,
"numhhol2" DOUBLE,
"numphon2" DOUBLE,
"cpdemo1" DOUBLE,
"cpdemo4" DOUBLE,
"internet" DOUBLE,
"renthom1" DOUBLE,
"sex" DOUBLE,
"pregnant" DOUBLE,
"qlactlm2" DOUBLE,
"useequip" DOUBLE,
"blind" DOUBLE,
"decide" DOUBLE,
"diffwalk" DOUBLE,
"diffdres" DOUBLE,
"diffalon" DOUBLE,
"smoke100" DOUBLE,
"smokday2" DOUBLE,
"stopsmk2" DOUBLE,
"lastsmk2" DOUBLE,
"usenow3" DOUBLE,
"alcday5" DOUBLE,
"avedrnk2" DOUBLE,
"drnk3ge5" DOUBLE,
"maxdrnks" DOUBLE,
"fruitju1" DOUBLE,
"fruit1" DOUBLE,
"fvbeans" DOUBLE,
"fvgreen" DOUBLE,
"fvorang" DOUBLE,
"vegetab1" DOUBLE,
"exerany2" DOUBLE,
"exract11" DOUBLE,
"exeroft1" DOUBLE,
"exerhmm1" DOUBLE,
"exract21" DOUBLE,
"exeroft2" DOUBLE,
"exerhmm2" DOUBLE,
"strength" DOUBLE,
"lmtjoin3" DOUBLE,
"arthdis2" DOUBLE,
"arthsocl" DOUBLE,
"joinpain" DOUBLE,
"seatbelt" DOUBLE,
"flushot6" DOUBLE,
"flshtmy2" DOUBLE,
"tetanus" DOUBLE,
"pneuvac3" DOUBLE,
"hivtst6" DOUBLE
);CREATE TABLE n_2014 (
"n__state" DOUBLE -- STATE,
"fmonth" DOUBLE,
"idate" VARCHAR,
"imonth" VARCHAR,
"iday" VARCHAR,
"iyear" VARCHAR,
"dispcode" DOUBLE,
"seqno" DOUBLE,
"n__psu" DOUBLE -- PSU,
"ctelenum" DOUBLE,
"pvtresd1" DOUBLE,
"colghous" DOUBLE,
"stateres" DOUBLE,
"ladult" DOUBLE,
"numadult" DOUBLE,
"nummen" DOUBLE,
"numwomen" DOUBLE,
"genhlth" DOUBLE,
"physhlth" DOUBLE,
"menthlth" DOUBLE,
"poorhlth" DOUBLE,
"hlthpln1" DOUBLE,
"persdoc2" DOUBLE,
"medcost" DOUBLE,
"checkup1" DOUBLE,
"exerany2" DOUBLE,
"sleptim1" DOUBLE,
"cvdinfr4" DOUBLE,
"cvdcrhd4" DOUBLE,
"cvdstrk3" DOUBLE,
"asthma3" DOUBLE,
"asthnow" DOUBLE,
"chcscncr" DOUBLE,
"chcocncr" DOUBLE,
"chccopd1" DOUBLE,
"havarth3" DOUBLE,
"addepev2" DOUBLE,
"chckidny" DOUBLE,
"diabete3" DOUBLE,
"diabage2" DOUBLE,
"lastden3" DOUBLE,
"rmvteth3" DOUBLE,
"veteran3" DOUBLE,
"marital" DOUBLE,
"children" DOUBLE,
"educa" DOUBLE,
"employ1" DOUBLE,
"income2" DOUBLE,
"weight2" DOUBLE,
"height3" DOUBLE,
"numhhol2" DOUBLE,
"numphon2" DOUBLE,
"cpdemo1" DOUBLE,
"internet" DOUBLE,
"renthom1" DOUBLE,
"sex" DOUBLE,
"pregnant" DOUBLE,
"qlactlm2" DOUBLE,
"useequip" DOUBLE,
"blind" DOUBLE,
"decide" DOUBLE,
"diffwalk" DOUBLE,
"diffdres" DOUBLE,
"diffalon" DOUBLE,
"smoke100" DOUBLE,
"smokday2" DOUBLE,
"stopsmk2" DOUBLE,
"lastsmk2" DOUBLE,
"usenow3" DOUBLE,
"alcday5" DOUBLE,
"avedrnk2" DOUBLE,
"drnk3ge5" DOUBLE,
"maxdrnks" DOUBLE,
"flushot6" DOUBLE,
"flshtmy2" DOUBLE,
"pneuvac3" DOUBLE,
"shingle2" DOUBLE,
"fall12mn" DOUBLE,
"fallinj2" DOUBLE,
"seatbelt" DOUBLE,
"drnkdri2" DOUBLE,
"hadmam" DOUBLE,
"howlong" DOUBLE,
"profexam" DOUBLE,
"lengexam" DOUBLE,
"hadpap2" DOUBLE,
"lastpap2" DOUBLE,
"hadhyst2" DOUBLE,
"pcpsaad2" DOUBLE,
"pcpsadi1" DOUBLE,
"pcpsare1" DOUBLE,
"psatest1" DOUBLE,
"psatime" DOUBLE,
"pcpsars1" DOUBLE,
"bldstool" DOUBLE,
"lstblds3" DOUBLE,
"hadsigm3" DOUBLE,
"hadsgco1" DOUBLE,
"lastsig3" DOUBLE,
"hivtst6" DOUBLE
);CREATE TABLE n_2015 (
"n__state" DOUBLE -- STATE,
"fmonth" DOUBLE,
"idate" VARCHAR,
"imonth" VARCHAR,
"iday" VARCHAR,
"iyear" VARCHAR,
"dispcode" DOUBLE,
"seqno" DOUBLE,
"n__psu" DOUBLE -- PSU,
"ctelenum" DOUBLE,
"pvtresd1" DOUBLE,
"colghous" DOUBLE,
"stateres" DOUBLE,
"cellfon3" DOUBLE,
"ladult" DOUBLE,
"numadult" DOUBLE,
"nummen" DOUBLE,
"numwomen" DOUBLE,
"ctelnum1" DOUBLE,
"cellfon2" DOUBLE,
"cadult" DOUBLE,
"pvtresd2" DOUBLE,
"cclghous" DOUBLE,
"cstate" DOUBLE,
"landline" DOUBLE,
"hhadult" DOUBLE,
"genhlth" DOUBLE,
"physhlth" DOUBLE,
"menthlth" DOUBLE,
"poorhlth" DOUBLE,
"hlthpln1" DOUBLE,
"persdoc2" DOUBLE,
"medcost" DOUBLE,
"checkup1" DOUBLE,
"bphigh4" DOUBLE,
"bpmeds" DOUBLE,
"bloodcho" DOUBLE,
"cholchk" DOUBLE,
"toldhi2" DOUBLE,
"cvdinfr4" DOUBLE,
"cvdcrhd4" DOUBLE,
"cvdstrk3" DOUBLE,
"asthma3" DOUBLE,
"asthnow" DOUBLE,
"chcscncr" DOUBLE,
"chcocncr" DOUBLE,
"chccopd1" DOUBLE,
"havarth3" DOUBLE,
"addepev2" DOUBLE,
"chckidny" DOUBLE,
"diabete3" DOUBLE,
"diabage2" DOUBLE,
"sex" DOUBLE,
"marital" DOUBLE,
"educa" DOUBLE,
"renthom1" DOUBLE,
"numhhol2" DOUBLE,
"numphon2" DOUBLE,
"cpdemo1" DOUBLE,
"veteran3" DOUBLE,
"employ1" DOUBLE,
"children" DOUBLE,
"income2" DOUBLE,
"internet" DOUBLE,
"weight2" DOUBLE,
"height3" DOUBLE,
"pregnant" DOUBLE,
"qlactlm2" DOUBLE,
"useequip" DOUBLE,
"blind" DOUBLE,
"decide" DOUBLE,
"diffwalk" DOUBLE,
"diffdres" DOUBLE,
"diffalon" DOUBLE,
"smoke100" DOUBLE,
"smokday2" DOUBLE,
"stopsmk2" DOUBLE,
"lastsmk2" DOUBLE,
"usenow3" DOUBLE,
"alcday5" DOUBLE,
"avedrnk2" DOUBLE,
"drnk3ge5" DOUBLE,
"maxdrnks" DOUBLE,
"fruitju1" DOUBLE,
"fruit1" DOUBLE,
"fvbeans" DOUBLE,
"fvgreen" DOUBLE,
"fvorang" DOUBLE,
"vegetab1" DOUBLE,
"exerany2" DOUBLE,
"exract11" DOUBLE,
"exeroft1" DOUBLE,
"exerhmm1" DOUBLE,
"exract21" DOUBLE,
"exeroft2" DOUBLE,
"exerhmm2" DOUBLE,
"strength" DOUBLE,
"lmtjoin3" DOUBLE,
"arthdis2" DOUBLE,
"arthsocl" DOUBLE
);Anyone who has the link will be able to view this.