Clinical, Anthropometric & Bio-Chemical Survey

1.89m records & 53 variables of unit level annual health survey data from India.

@kaggle.rajanand_cab_survey

Table List

9 tables(45.77 MB)

Cab 18 As

@kaggle.rajanand_cab_survey.cab_18_as

3.62 MB
142840 rows
54 columns

state_code State Code	district_code District Code	rural_urban Rural Urban	stratum Stratum	psu_id Psu Id	ahs_house_unit Ahs House Unit	house_hold_no House Hold No	date_survey Date Survey	test_salt_iodine Test Salt Iodine	record_code_iodine Record Code Iodine	sl_no Sl No	sex Sex	usual_residance Usual Residance	identification_code Identification Code	age_code Age Code	age Age	date_of_birth Date Of Birth	month_of_birth Month Of Birth	year_of_birth Year Of Birth	weight_measured Weight Measured	weight_in_kg Weight In Kg	length_height_measured Length Height Measured	length_height_code Length Height Code	length_height_cm Length Height Cm	haemoglobin_test Haemoglobin Test	haemoglobin Haemoglobin	haemoglobin_level Haemoglobin Level	bp_systolic Bp Systolic	bp_systolic_2_reading Bp Systolic 2 Reading	bp_diastolic Bp Diastolic	bp_diastolic_2reading Bp Diastolic 2reading	pulse_rate Pulse Rate	pulse_rate_2_reading Pulse Rate 2 Reading	diabetes_test Diabetes Test	fasting_blood_glucose Fasting Blood Glucose	fasting_blood_glucose_mg_dl Fasting Blood Glucose Mg Dl	marital_status Marital Status	gauna_perfor_not_perfor Gauna Perfor Not Perfor	duration_pregnanacy Duration Pregnanacy	first_breast_feeding First Breast Feeding	is_cur_breast_feeding Is Cur Breast Feeding	day_or_month_for_breast_feeding Day Or Month For Breast Feeding	day_or_month_for_breast_feeding_851deb Day Or Month For Breast Feeding	water_month Water Month	ani_milk_month Ani Milk Month	semisolid_month_or_day Semisolid Month Or Day	solid_month Solid Month	vegetables_month_or_day Vegetables Month Or Day	illness_type Illness Type	illness_duration Illness Duration	treatment_type Treatment Type
18	1	1	2	1075624	130	1	12/08/2014	30	3	1	1	1	531	Y	49	1	1	1965	1	61.200001	1	H	159.5	1	1	7.5	127	129	82	80	78	77	1	1	80	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
18	1	1	1	1077449	82	1	12/02/2014	30	3	1	1	1	319	Y	50	1	1	1964	1	56.200001	1	H	159.5	1	1	7	132	129	93	90	94	88	1	1	77	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
18	1	1	2	1074487	25	1	12/01/2014	30	3	1	1	1	82	Y	60	1	1	1954	1	57.099998	1	H	159.5	1	1	10.5	145	144	90	89	72	70	1	1	60	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
18	1	1	2	1076125	424	1	13/12/2014	30	3	3	1	1	1863	Y	16	1	1	1998	1	49.299999	1	H	159.60001	1	1	10	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
18	1	1	1	1076804	90	1	29/11/2014	30	3	6	2	1	683	Y	24	1	1	1990	1	58.599998	1	H	159.60001	2	-1	-1	120	120	78	80	90	88	2	-1	-1	2	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
18	1	1	1	1078325	81	1	15/12/2014	30	3	1	1	1	356	Y	26	1	1	1988	1	61.900002	1	H	159.60001	1	1	7	128	130	76	74	63	71	1	1	78	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
18	1	1	2	1074758	132	2	12/03/2014	30	3	3	1	1	582	Y	28	1	1	1986	1	66.599998	1	H	159.60001	1	1	8	131	130	80	82	83	88	1	1	99	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
18	1	1	2	1076117	428	1	13/12/2014	30	3	3	1	1	1884	Y	17	12	5	1997	1	51.900002	1	H	159.7	1	1	7.5	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
18	1	1	1	1076842	18	1	28/11/2014	30	3	5	1	1	97	Y	20	1	1	1994	1	50	1	H	159.7	1	3	-1	130	127	80	79	87	97	2	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
18	1	1	1	1078355	251	1	17/12/2014	30	3	3	1	1	1155	Y	23	1	1	1991	1	45.400002	1	H	159.7	1	1	10	124	120	78	78	73	70	1	1	102	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1


CREATE TABLE cab_18_as (
  "state_code" VARCHAR,
  "district_code" BIGINT,
  "rural_urban" VARCHAR,
  "stratum" BIGINT,
  "psu_id" BIGINT,
  "ahs_house_unit" BIGINT,
  "house_hold_no" BIGINT,
  "date_survey" VARCHAR,
  "test_salt_iodine" BIGINT,
  "record_code_iodine" BIGINT,
  "record_code_iodine_reason" VARCHAR,
  "sl_no" BIGINT,
  "sex" BIGINT,
  "usual_residance" BIGINT,
  "usual_residance_reason" VARCHAR,
  "identification_code" DOUBLE,
  "age_code" VARCHAR,
  "age" DOUBLE,
  "date_of_birth" DOUBLE,
  "month_of_birth" DOUBLE,
  "year_of_birth" DOUBLE,
  "weight_measured" DOUBLE,
  "weight_in_kg" DOUBLE,
  "length_height_measured" DOUBLE,
  "length_height_code" VARCHAR,
  "length_height_cm" DOUBLE,
  "haemoglobin_test" DOUBLE,
  "haemoglobin" DOUBLE,
  "haemoglobin_level" DOUBLE,
  "bp_systolic" DOUBLE,
  "bp_systolic_2_reading" DOUBLE,
  "bp_diastolic" DOUBLE,
  "bp_diastolic_2reading" DOUBLE,
  "pulse_rate" DOUBLE,
  "pulse_rate_2_reading" DOUBLE,
  "diabetes_test" DOUBLE,
  "fasting_blood_glucose" DOUBLE,
  "fasting_blood_glucose_mg_dl" DOUBLE,
  "marital_status" DOUBLE,
  "gauna_perfor_not_perfor" DOUBLE,
  "duration_pregnanacy" DOUBLE,
  "first_breast_feeding" DOUBLE,
  "is_cur_breast_feeding" DOUBLE,
  "day_or_month_for_breast_feeding" VARCHAR,
  "day_or_month_for_breast_feeding_851deb" DOUBLE,
  "water_month" DOUBLE,
  "ani_milk_month" DOUBLE,
  "semisolid_month_or_day" DOUBLE,
  "solid_month" DOUBLE,
  "vegetables_month_or_day" DOUBLE,
  "illness_type" DOUBLE,
  "illness_duration" DOUBLE,
  "treatment_type" DOUBLE,
  "v54" VARCHAR
);