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 2015

@kaggle.cdc_behavioral_risk_factor_surveillance_system.n_2015

43.05 MB
441456 rows
330 columns
Only the first 100 columns are shown

n__state STATE	fmonth FMONTH	idate IDATE	imonth IMONTH	iday IDAY	iyear IYEAR	dispcode DISPCODE	seqno SEQNO	n__psu PSU	ctelenum CTELENUM	pvtresd1 PVTRESD1	stateres STATERES	cellfon3 CELLFON3	numadult NUMADULT	nummen NUMMEN	numwomen NUMWOMEN	genhlth GENHLTH	physhlth PHYSHLTH	menthlth MENTHLTH	poorhlth POORHLTH	hlthpln1 HLTHPLN1	persdoc2 PERSDOC2	medcost MEDCOST	checkup1 CHECKUP1	bphigh4 BPHIGH4	bpmeds BPMEDS	bloodcho BLOODCHO	cholchk CHOLCHK	toldhi2 TOLDHI2	cvdinfr4 CVDINFR4	cvdcrhd4 CVDCRHD4	cvdstrk3 CVDSTRK3	asthma3 ASTHMA3	asthnow ASTHNOW	chcscncr CHCSCNCR	chcocncr CHCOCNCR	chccopd1 CHCCOPD1	havarth3 HAVARTH3	addepev2 ADDEPEV2	chckidny CHCKIDNY	diabete3 DIABETE3	sex SEX	marital MARITAL	educa EDUCA	renthom1 RENTHOM1	numhhol2 NUMHHOL2	cpdemo1 CPDEMO1	veteran3 VETERAN3	employ1 EMPLOY1	children CHILDREN	income2 INCOME2	internet INTERNET	weight2 WEIGHT2	height3 HEIGHT3	qlactlm2 QLACTLM2	useequip USEEQUIP	blind BLIND	decide DECIDE	diffwalk DIFFWALK	diffdres DIFFDRES	diffalon DIFFALON	smoke100 SMOKE100	smokday2 SMOKDAY2	stopsmk2 STOPSMK2	lastsmk2 LASTSMK2	usenow3 USENOW3	alcday5 ALCDAY5	avedrnk2 AVEDRNK2	drnk3ge5 DRNK3GE5	maxdrnks MAXDRNKS	fruitju1 FRUITJU1	fruit1 FRUIT1	fvbeans FVBEANS	fvgreen FVGREEN	fvorang FVORANG	vegetab1 VEGETAB1	exerany2 EXERANY2	exract11 EXRACT11	exeroft1 EXEROFT1	exerhmm1 EXERHMM1	exract21 EXRACT21	exeroft2 EXEROFT2	exerhmm2 EXERHMM2	strength STRENGTH	lmtjoin3 LMTJOIN3	arthdis2 ARTHDIS2	arthsocl ARTHSOCL
1	1	b'01292015'	b'01'	b'29'	b'2015'	1200	2015000001	2015000001	1	1	1	2	3	1	2	5	15	18	10	1	1	2	1	1	1	1	1	1	2	2	2	1	1	2	2	1	1	1	2	3	2	1	4	1	2	1	2	8	88	3	2	280	510	1	1	2	2	1	1	1	1	3		2	3	888				305	310	320	310	305	101	2							888	1	1	1
1	1	b'01202015'	b'01'	b'20'	b'2015'	1100	2015000002	2015000002	1	1	1	2	1	5.397605346934028e-79	1	3	88	88		2	1	1	4	3		1	4	2	2	2	2	2		2	2	2	2	2	2	3	2	2	6	1	2	2	2	3	88	1	1	165	508	1	2	1	1	2	2	2	1	1	2		3	888				302	305	302	202	202	304	1	64	212	100	69	212	100	888
1	1	b'02012015'	b'02'	b'01'	b'2015'	1200	2015000003	2015000003	1	1	1	2	2	1	1	4	15	88	88	1	2	2	1	3		1	1	1	7	2	1	2		2	1	2	1	2	2	3	2	2	4	1	2	1	2	7	88	99	2	158	511	2	2	2	2
1	1	b'01142015'	b'01'	b'14'	b'2015'	1100	2015000004	2015000004	1	1	1	2	3	1	2	5	30	30	30	1	2	1	1	1	1	1	1	1	2	2	2	2		2	1	2	1	1	2	3	2	1	4	1	2	1	2	8	1	8	2	180	507	1	2	1	1	1	2	1	2				3	888				555	101	555	301	301	201	2							888	1	1	1
1	1	b'01142015'	b'01'	b'14'	b'2015'	1100	2015000005	2015000005	1	1	1	2	2	1	1	5	20	88	30	1	1	2	1	3		1	1	2	2	2	2	2		2	2	2	1	2	2	3	2	1	5	1	2	2	2	8	88	77	1	142	504	2	2	2	2	2	2	2	2				3	888				777	102	203	204	310	320	2							888	1	1	1
1	1	b'01142015'	b'01'	b'14'	b'2015'	1100	2015000006	2015000006	1	1	1	2	1	5.397605346934028e-79	1	2	88	88		1	1	2	1	1	1	1	1	2	2	2	2	2		2	2	2	1	2	2	3	2	3	3	1	2	2	2	2	88	6	2	145	502	1	2	2	2	2	2	2	2				3	888				101	101	102	101	102	101	1	18	101	100	73	107	30	888	1	2	3
1	1	b'01052015'	b'01'	b'05'	b'2015'	1100	2015000007	2015000007	1	1	1	2	1	5.397605346934028e-79	1	2	88	3	88	1	1	2	1	1	1	1	1	1	2	2	2	2		2	2	2	2	2	2	3	2	3	5	1	2	2	2	7	88	4	2	148	506	2	2	2	2	2	2	2	2				3	203	1	88	1	330	202	302	202	302	205	1	18	102	100	64	107	15	888
1	1	b'01142015'	b'01'	b'14'	b'2015'	1100	2015000008	2015000008	1	1	1	2	2	1	1	5	8	88	8	1	1	1	1	1	1	1	1	1	7	2	2	2		2	2	2	1	2	7	3	1	1	3	1	2	1	1	3	88	3	2	179	501	1	2	2	2	1	2	2	1	3		7	3	888				102	101	202	101	303	202	1	64	106	12	98	107	5	888	1	1	1
1	1	b'01132015'	b'01'	b'13'	b'2015'	1100	2015000009	2015000009	1	1	1	2	1	5.397605346934028e-79	1	5	77	88	77	1	1	2	1	3		7			2	2	2	2		2	2	2	1	2	2	3	2	3	3	1	2	1	2	5	88	77	2	84	503	1	1	2	2	7	2	2	2				3	888				777	777	302	302	777	777	1	98	103	100	88			777	2	1	2
1	1	b'01302015'	b'01'	b'30'	b'2015'	1100	2015000010	2015000010	1	1	1	2	2	1	1	2	2	88	2	1	1	2	1	1	1	1	1	1	2	2	2	2		2	2	2	2	2	2	3	1	1	6	1	2	1	2	7	88	8	1	161	507	2	2	2	2	2	2	2	1	3		7	3	888				201	101	204	205	206	101	1	64	106	50	88			888


CREATE TABLE n_2015 (
  "n__state" DOUBLE,
  "fmonth" DOUBLE,
  "idate" VARCHAR,
  "imonth" VARCHAR,
  "iday" VARCHAR,
  "iyear" VARCHAR,
  "dispcode" DOUBLE,
  "seqno" DOUBLE,
  "n__psu" DOUBLE,
  "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
);