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 10 Bh

@kaggle.rajanand_cab_survey.cab_10_bh

6.64 MB
284464 rows
54 columns

state_code State Code	district_code District Code	rural_urban Rural Urban	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	record_code_iodine_reason Record Code Iodine Reason	sl_no Sl No	sex Sex	usual_residance Usual Residance	usual_residance_reason Usual Residance Reason	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
10	1	2	1147723	57	1	Sun Jun 29 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	7	2	nan	3	1	1	nan	324	Y	16	20	12	1997	1	33.5	1	H	140.39999	2	3	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
10	1	2	1147744	57	1	Sun Jun 29 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	7	2	nan	4	2	1	nan	325	Y	14	15	9	1999	1	29.4	1	H	135.39999	1	1	9.1999998	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
10	1	2	1147764	57	1	Sun Jun 29 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	7	2	nan	5	1	1	nan	326	Y	13	18	2	2001	1	18.200001	1	H	155.60001	1	1	8.1000004	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
10	1	2	1147747	4	1	Sun Jun 29 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	7	2	nan	4	1	1	nan	23	Y	13	16	7	2000	1	29.700001	1	H	141.10001	1	1	9.3000002	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
10	1	2	1147766	4	1	Sun Jun 29 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	7	2	nan	5	1	1	nan	24	Y	11	8	7	2002	1	20.9	1	H	122.2	1	1	8.1000004	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
10	1	2	1147785	4	1	Sun Jun 29 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	7	2	nan	6	1	1	nan	25	Y	10	2	3	2004	1	22.1	1	H	120.3	1	1	5.8000002	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
10	1	2	1147562	94	1	Tue Jul 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	16	3	nan	1	1	1	nan	543	Y	44	19	3	1970	1	49.599998	1	H	173.2	2	3	-1	135	128	92	87	97	93	2	3	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
10	1	2	1147589	94	1	Tue Jul 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	16	3	nan	2	2	1	nan	544	Y	38	26	8	1975	1	53.099998	1	H	158.3	1	3	-1	160	155	90	85	95	90	1	1	96	3	3	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
10	1	2	1147702	94	1	Tue Jul 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	16	3	nan	3	1	1	nan	545	Y	20	8	2	1994	1	57.299999	1	H	160.5	1	1	8.1000004	115	110	70	75	65	70	1	1	98	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
10	1	2	1147733	94	1	Tue Jul 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	16	3	nan	4	2	2	nan	546	Y	15	21	9	1998	2	-1	2	-1	-1	2	2	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1


CREATE TABLE cab_10_bh (
  "state_code" BIGINT,
  "district_code" BIGINT,
  "rural_urban" BIGINT,
  "stratum" BIGINT,
  "psu_id" BIGINT,
  "ahs_house_unit" BIGINT,
  "house_hold_no" BIGINT,
  "date_survey" TIMESTAMP,
  "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" BIGINT,
  "date_of_birth" BIGINT,
  "month_of_birth" BIGINT,
  "year_of_birth" BIGINT,
  "weight_measured" BIGINT,
  "weight_in_kg" DOUBLE,
  "length_height_measured" BIGINT,
  "length_height_code" VARCHAR,
  "length_height_cm" DOUBLE,
  "haemoglobin_test" BIGINT,
  "haemoglobin" BIGINT,
  "haemoglobin_level" DOUBLE,
  "bp_systolic" BIGINT,
  "bp_systolic_2_reading" BIGINT,
  "bp_diastolic" BIGINT,
  "bp_diastolic_2reading" BIGINT,
  "pulse_rate" BIGINT,
  "pulse_rate_2_reading" BIGINT,
  "diabetes_test" BIGINT,
  "fasting_blood_glucose" BIGINT,
  "fasting_blood_glucose_mg_dl" BIGINT,
  "marital_status" BIGINT,
  "gauna_perfor_not_perfor" BIGINT,
  "duration_pregnanacy" BIGINT,
  "first_breast_feeding" BIGINT,
  "is_cur_breast_feeding" BIGINT,
  "day_or_month_for_breast_feeding" VARCHAR,
  "day_or_month_for_breast_feeding_851deb" BIGINT,
  "water_month" BIGINT,
  "ani_milk_month" BIGINT,
  "semisolid_month_or_day" BIGINT,
  "solid_month" BIGINT,
  "vegetables_month_or_day" BIGINT,
  "illness_type" BIGINT,
  "illness_duration" BIGINT,
  "treatment_type" BIGINT,
  "v54" VARCHAR
);