Chronic Disease Indicators Dataset

A Comprehensive Look at Chronic Diseases and Associated Risk Factors Across US

@kaggle.yashdogra_chronic_dis_ind

Table List

1 table(4.88 MB)

U S Chronic Disease Indicators

@kaggle.yashdogra_chronic_dis_ind.u_s_chronic_disease_indicators

4.88 MB
309215 rows
34 columns

yearstart YearStart	yearend YearEnd	locationabbr LocationAbbr	locationdesc LocationDesc	datasource DataSource	topic Topic	question Question	datavalueunit DataValueUnit	datavaluetype DataValueType	datavalue DataValue	datavaluealt DataValueAlt	datavaluefootnotesymbol DataValueFootnoteSymbol	datavaluefootnote DataValueFootnote	lowconfidencelimit LowConfidenceLimit	highconfidencelimit HighConfidenceLimit	stratificationcategory1 StratificationCategory1	stratification1 Stratification1	geolocation Geolocation	locationid LocationID	topicid TopicID	questionid QuestionID	datavaluetypeid DataValueTypeID	stratificationcategoryid1 StratificationCategoryID1	stratificationid1 StratificationID1
2019	2019	AR	Arkansas	BRFSS	Diabetes	Diabetes among adults	%	Crude Prevalence	13.6	13.6	nan	nan	12.1	15.4	Sex	Male	POINT (-92.27449074299966 34.74865012400045)	5	DIA	DIA01	CRDPREV	SEX	SEXM
2019	2019	ID	Idaho	BRFSS	Diabetes	Diabetes among adults	%	Crude Prevalence	10.6	10.6	nan	nan	9.1	12.2	Sex	Male	POINT (-114.3637300419997 43.682630005000476)	16	DIA	DIA01	CRDPREV	SEX	SEXM
2019	2019	IN	Indiana	YRBSS	Sleep	Short sleep duration among high school students	%	Crude Prevalence			*	No data available			Grade	Grade 12	POINT (-86.14996019399968 39.766910452000445)	18	SLEP	SLP02	CRDPREV	GRADE	GRD12
2019	2019	IA	Iowa	NVSS	Asthma	Asthma mortality among all people, underlying cause	Number	Number	54	54	nan	nan			Overall	Overall	POINT (-93.81649055599968 42.46940091300047)	19	AST	AST01	NMBR	OVERALL	OVR
2019	2019	IA	Iowa	BRFSS	Asthma	Current asthma among adults	%	Crude Prevalence	10.3	10.3	nan	nan	9.1	11.7	Age	Age 18-44	POINT (-93.81649055599968 42.46940091300047)	19	AST	AST02	CRDPREV	AGE	AGE1844
2019	2019	IA	Iowa	NVSS	Diabetes	Diabetes mortality among all people, underlying or contributing cause	Number	Number	54	54	nan	nan			Age	Age 0-44	POINT (-93.81649055599968 42.46940091300047)	19	DIA	DIA03	NMBR	AGE	AGE0_44
2019	2019	IA	Iowa	BRFSS	Health Status	Recent activity limitation among adults	Number	Crude Mean	2.3	2.3	nan	nan	2.1	2.5	Sex	Female	POINT (-93.81649055599968 42.46940091300047)	19	HEA	HEA04	CRDMEAN	SEX	SEXF
2019	2019	IA	Iowa	BRFSS	Mental Health	Depression among adults	%	Crude Prevalence	31	31	nan	nan	20.6	43.7	Race/Ethnicity	Multiracial, non-Hispanic	POINT (-93.81649055599968 42.46940091300047)	19	MEN	MEN02	CRDPREV	RACE	MRC
2019	2019	KS	Kansas	NVSS	Diabetes	Diabetes mortality among all people, underlying or contributing cause	Number	Number	524	524	nan	nan			Age	Age 45-64	POINT (-98.20078122699965 38.34774030000045)	20	DIA	DIA03	NMBR	AGE	AGE4564
2019	2019	LA	Louisiana	BRFSS	Mental Health	Depression among adults	%	Crude Prevalence	29.3	29.3	nan	nan	20.7	39.6	Race/Ethnicity	Hispanic	POINT (-92.44568007099969 31.31266064400046)	22	MEN	MEN02	CRDPREV	RACE	HIS


CREATE TABLE u_s_chronic_disease_indicators (
  "yearstart" BIGINT,
  "yearend" BIGINT,
  "locationabbr" VARCHAR,
  "locationdesc" VARCHAR,
  "datasource" VARCHAR,
  "topic" VARCHAR,
  "question" VARCHAR,
  "response" VARCHAR,
  "datavalueunit" VARCHAR,
  "datavaluetype" VARCHAR,
  "datavalue" DOUBLE,
  "datavaluealt" DOUBLE,
  "datavaluefootnotesymbol" VARCHAR,
  "datavaluefootnote" VARCHAR,
  "lowconfidencelimit" DOUBLE,
  "highconfidencelimit" DOUBLE,
  "stratificationcategory1" VARCHAR,
  "stratification1" VARCHAR,
  "stratificationcategory2" VARCHAR,
  "stratification2" VARCHAR,
  "stratificationcategory3" VARCHAR,
  "stratification3" VARCHAR,
  "geolocation" VARCHAR,
  "locationid" BIGINT,
  "topicid" VARCHAR,
  "questionid" VARCHAR,
  "responseid" VARCHAR,
  "datavaluetypeid" VARCHAR,
  "stratificationcategoryid1" VARCHAR,
  "stratificationid1" VARCHAR,
  "stratificationcategoryid2" VARCHAR,
  "stratificationid2" VARCHAR,
  "stratificationcategoryid3" VARCHAR,
  "stratificationid3" VARCHAR
);