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 08 Rj

@kaggle.rajanand_cab_survey.cab_08_rj

5.13 MB
212094 rows
54 columns

state_code State Code	district_code District Code	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	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
1	2	2120509	10	1	09/07/2014	30	3	nan	10	1	1	nan	54	Y	15	16	4	1999	1	41.900002	1	H	168.8	1	1	11	-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	2	2120458	10	1	09/07/2014	30	3	nan	6	2	1	nan	50	Y	20	10	12	1994	1	40.700001	1	H	157.8	1	1	6	104	98	68	72	80	76	1	1	94	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
1	2	2120449	10	1	09/07/2014	30	3	nan	5	1	1	nan	49	Y	21	5	11	1993	1	61.299999	1	H	177.39999	1	1	12.2	133	122	83	78	82	76	1	1	100	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
1	2	2120491	10	1	09/07/2014	30	3	nan	7	1	1	nan	51	Y	17	4	9	1997	1	50.299999	1	H	173.89999	1	1	12.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	2	2120200	10	1	09/07/2014	30	3	nan	2	1	2	nan	46	Y	80	15	6	1934	-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	-1	-1	-1	-1	-1	-1	-1
1	2	2120199	10	1	09/07/2014	30	3	nan	1	1	1	nan	45	Y	82	15	6	1932	1	62.099998	1	H	162.3	1	1	6.4000001	199	180	109	92	64	76	1	1	111	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
1	2	2120306	10	1	09/07/2014	30	3	nan	9	2	1	nan	53	Y	38	15	6	1976	1	54.099998	1	H	162.89999	1	1	8.6999998	133	126	86	78	88	76	1	1	103	3	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
1	2	2120510	10	1	09/07/2014	30	3	nan	11	2	1	nan	55	Y	14	7	9	2000	1	37.799999	1	H	155.10001	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
1	2	2120277	10	1	09/07/2014	30	3	nan	3	1	1	nan	47	Y	43	15	5	1971	1	56.700001	1	H	173.2	1	1	4.5999999	103	98	75	78	96	82	1	1	96	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1	-1
1	2	2120325	13	1	09/07/2014	30	3	nan	1	1	2	nan	61	Y	35	12	9	1979	-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	-1	-1	-1	-1	-1	-1	-1


CREATE TABLE cab_08_rj (
  "state_code" BIGINT,
  "district_code" BIGINT,
  "rural_urban" BIGINT,
  "stratum" BIGINT,
  "psu_id" BIGINT,
  "ahs_house_unit" BIGINT,
  "house_hold_no" VARCHAR,
  "date_survey" BIGINT,
  "test_salt_iodine" BIGINT,
  "record_code_iodine" VARCHAR,
  "record_code_iodine_reason" BIGINT,
  "sl_no" BIGINT,
  "sex" BIGINT,
  "usual_residance" VARCHAR,
  "usual_residance_reason" VARCHAR,
  "identification_code" VARCHAR,
  "age_code" VARCHAR,
  "age" BIGINT,
  "date_of_birth" BIGINT,
  "month_of_birth" BIGINT,
  "year_of_birth" BIGINT,
  "weight_measured" DOUBLE,
  "weight_in_kg" BIGINT,
  "length_height_measured" VARCHAR,
  "length_height_code" DOUBLE,
  "length_height_cm" BIGINT,
  "haemoglobin_test" BIGINT,
  "haemoglobin" DOUBLE,
  "haemoglobin_level" BIGINT,
  "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" DOUBLE,
  "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" VARCHAR,
  "day_or_month_for_breast_feeding" BIGINT,
  "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" DOUBLE,
  "v54" VARCHAR
);