Behavioral Risk Factor Surveillance System

Public health surveys of 400k people from 2011-2015

@kaggle.cdc_behavioral_risk_factor_surveillance_system

Table List

5 tables(226.06 MB)

N 2011

N 2012

N 2013

N 2014

N 2015

N 2012

@kaggle.cdc_behavioral_risk_factor_surveillance_system.n_2012

40.54 MB
475687 rows
359 columns
Only the first 100 columns are shown

n__state STATE	n__geostr GEOSTR	n__denstr2 DENSTR2	precall PRECALL	repnum REPNUM	repdepth REPDEPTH	fmonth FMONTH	idate IDATE	imonth IMONTH	iday IDAY	iyear IYEAR	intvid INTVID	dispcode DISPCODE	seqno SEQNO	n__psu PSU	nattmpts NATTMPTS	nrecsel NRECSEL	nrecstr NRECSTR	ctelenum CTELENUM	pvtresid PVTRESID	cellfon CELLFON	numadult NUMADULT	nummen NUMMEN	numwomen NUMWOMEN	genhlth GENHLTH	physhlth PHYSHLTH	menthlth MENTHLTH	poorhlth POORHLTH	hlthpln1 HLTHPLN1	persdoc2 PERSDOC2	medcost MEDCOST	checkup1 CHECKUP1	exerany2 EXERANY2	cvdinfr4 CVDINFR4	cvdcrhd4 CVDCRHD4	cvdstrk3 CVDSTRK3	asthma3 ASTHMA3	asthnow ASTHNOW	chcscncr CHCSCNCR	chcocncr CHCOCNCR	chccopd1 CHCCOPD1	havarth3 HAVARTH3	addepev2 ADDEPEV2	chckidny CHCKIDNY	chcvisn1 CHCVISN1	diabete3 DIABETE3	lastden3 LASTDEN3	rmvteth3 RMVTETH3	age AGE	hispanc2 HISPANC2	mrace MRACE	veteran3 VETERAN3	marital MARITAL	children CHILDREN	educa EDUCA	employ EMPLOY	income2 INCOME2	weight2 WEIGHT2	height3 HEIGHT3	ctycode1 CTYCODE1	numhhol2 NUMHHOL2	numphon2 NUMPHON2	cpdemo1 CPDEMO1	cpdemo4 CPDEMO4	renthom1 RENTHOM1	sex SEX	pregnant PREGNANT	qlactlm2 QLACTLM2	useequip USEEQUIP	smoke100 SMOKE100	smokday2 SMOKDAY2	stopsmk2 STOPSMK2	lastsmk2 LASTSMK2	usenow3 USENOW3	alcday5 ALCDAY5	avedrnk2 AVEDRNK2	drnk3ge5 DRNK3GE5	maxdrnks MAXDRNKS	flushot5 FLUSHOT5	flshtmy2 FLSHTMY2	imfvplac IMFVPLAC	pneuvac3 PNEUVAC3	fall12mn FALL12MN	fallinj2 FALLINJ2	seatbelt SEATBELT	drnkdri2 DRNKDRI2	hadmam HADMAM	howlong HOWLONG	profexam PROFEXAM	lengexam LENGEXAM	hadpap2 HADPAP2	lastpap2 LASTPAP2	hadhyst2 HADHYST2	pcpsaad1 PCPSAAD1	pcpsadi1 PCPSADI1	pcpsare1 PCPSARE1	psatest1 PSATEST1
1	7	1	1	20118	3	2	b'02162012'	b'02'	b'16'	b'2012'	b'00163'	1100	2012000864	2012000864	8	2585	45328	1	1	1	2	1	1	3	77	88	88	1	1	2	1	2	2	2	2	2		2	2	2	1	2	2	1	3	1	1	64	2	b'1'	1	1	2	5	7	6	190	600	1	1	1	1	888	1	1		2	2	2				3	888				2			1	88		1									1	2	1	1
1	8	1	1	10119	17	1	b'01052012'	b'01'	b'05'	b'2012'	b'00172'	1100	2012000926	2012000926	2	3284	162814	1	1	1	4	1	3	1	88	88		1	1	2	1	1	2	2	2	2		2	2	2	2	2	2	2	3	1	8	54	2	b'1'	1	1	88	6	1	8	175	506	1	2		1	80	1	1		2	2	2				3	203	2	88	2	1	102011	8	2	88		1	88								1	2	1	1
1	8	2	1	10126	5	1	b'01032012'	b'01'	b'03'	b'2012'	b'00105'	1100	2012000942	2012000942	1	5535	399986	1	1	1	1	5.397605346934028e-79	1	4	2	2	88	1	1	2	1	2	2	1	2	1	1	2	2	1	1	1	1	1	3	1	2	68	2	b'2'	2	2	88	6	7	99	250	507	1	1	2	1	15	1	2		1	1	1	3		7	3	202	77	88	77	1	777777	1	1	88		1	88	1	1	1	1	1	5	1
1	8	1	1	10128	9	1	b'01192012'	b'01'	b'19'	b'2012'	b'00106'	1100	2012000947	2012000947	2	3284	162814	1	1	1	2	1	1	3	88	88		1	1	2	1	2	2	2	2	2		1	2	2	2	2	2	2	3	4	3	72	2	b'1'	2	1	88	3	8	3	145	505	1	2		2		1	2		2	2	2				3	888				2			2	88		1		1	1	2		1	3	1
1	8	1	1	10130	26	1	b'01062012'	b'01'	b'06'	b'2012'	b'00102'	1100	2012000953	2012000953	1	3284	162814	1	1	1	2	1	1	4	15	88	88	1	1	2	1	1	2	2	2	2		2	2	2	1	2	2	1	1	1	1	60	2	b'1'	2	1	88	4	7	99	285	506	1	2		1	10	1	2		2	2	2				3	888				2			2	88		1		1	1	1	1	1	2	1
1	8	1	1	10131	4	1	b'01232012'	b'01'	b'23'	b'2012'	b'00149'	1100	2012000954	2012000954	4	3284	162814	1	1	1	2	1	1	3	88	88		1	1	2	1	2	2	2	2	2		2	2	2	1	2	2	2	3	1	1	53	2	b'1'	1	1	88	4	1	7	250	601	1	2		1	50	1	1		2	2	1	3		7	3	101	2	88	3	2			2	88		1	88								2	2	2
1	8	1	1	10133	14	1	b'01282012'	b'01'	b'28'	b'2012'	b'00178'	1100	2012000959	2012000959	8	3284	162814	1	1	1	2	1	1	3	88	88		1	1	2	1	1	2	2	2	2		2	2	2	2	2	2	2	3	1	8	36	2	b'2'	1	1	3	6	1	99	165	507	1	2		1	80	1	2	2	2	2	2				3	204	2	88	2	1	112011	1	2			1	88	2		1	2	1	2	1
1	8	1	1	20122	17	2	b'02132012'	b'02'	b'13'	b'2012'	b'00104'	1100	2012000982	2012000982	4	3284	162814	1	1	1	2	1	1	3	21	88	21	1	2	2	1	2	2	2	2	2		2	2	2	1	2	2	2	3	1	8	53	2	b'1'	1	1	88	6	1	7	210	509	1	2		1	777	1	1		1	1	1	3		7	3	225	4	77	77	2			2	1	88	1	88								7	7	2	2
1	8	1	1	20123	27	2	b'02162012'	b'02'	b'16'	b'2012'	b'00198'	1100	2012000986	2012000986	6	3284	162814	1	1	1	1	1	5.397605346934028e-79	2	14	88	88	1	1	2	3	1	2	2	2	2		2	2	2	2	2	2	1	3	1	8	55	2	b'1'	1	2	88	6	1	7	175	506	1	2		2		1	1		2	2	1	1	2		3	888				2			2	1	88	5									2	2	2	2
1	8	1	1	20128	12	2	b'02022012'	b'02'	b'02'	b'2012'	b'00104'	1100	2012001000	2012001000	1	3284	162814	1	1	1	2	1	1	2	30	88	14	1	2	2	1	1	2	2	2	2		1	2	2	1	2	2	2	3	1	1	68	2	b'1'	2	1	88	6	7	7	140	503	1	2		1	50	1	2		2	2	1	3		7	3	888				1	102011	1	1	88		1		1	1	1	1	1	1	1


CREATE TABLE n_2012 (
  "n__state" DOUBLE,
  "n__geostr" DOUBLE,
  "n__denstr2" DOUBLE,
  "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,
  "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
);