Clinical, Anthropometric & Bio-Chemical Survey
1.89m records & 53 variables of unit level annual health survey data from India.
@kaggle.rajanand_cab_survey
Cab 18 As
@kaggle.rajanand_cab_survey.cab_18_as
- 3.62 MB
- 142840 rows
- 54 columns
state_codeState Code | district_codeDistrict Code | rural_urbanRural Urban | stratumStratum | psu_idPsu Id | ahs_house_unitAhs House Unit | house_hold_noHouse Hold No | date_surveyDate Survey | test_salt_iodineTest Salt Iodine | record_code_iodineRecord Code Iodine | record_code_iodine_reasonRecord Code Iodine Reason | sl_noSl No | sexSex | usual_residanceUsual Residance | usual_residance_reasonUsual Residance Reason | identification_codeIdentification Code | age_codeAge Code | ageAge | date_of_birthDate Of Birth | month_of_birthMonth Of Birth | year_of_birthYear Of Birth | weight_measuredWeight Measured | weight_in_kgWeight In Kg | length_height_measuredLength Height Measured | length_height_codeLength Height Code | length_height_cmLength Height Cm | haemoglobin_testHaemoglobin Test | haemoglobinHaemoglobin | haemoglobin_levelHaemoglobin Level | bp_systolicBp Systolic | bp_systolic_2_readingBp Systolic 2 Reading | bp_diastolicBp Diastolic | bp_diastolic_2readingBp Diastolic 2reading | pulse_ratePulse Rate | pulse_rate_2_readingPulse Rate 2 Reading | diabetes_testDiabetes Test | fasting_blood_glucoseFasting Blood Glucose | fasting_blood_glucose_mg_dlFasting Blood Glucose Mg Dl | marital_statusMarital Status | gauna_perfor_not_perforGauna Perfor Not Perfor | duration_pregnanacyDuration Pregnanacy | first_breast_feedingFirst Breast Feeding | is_cur_breast_feedingIs Cur Breast Feeding | day_or_month_for_breast_feedingDay Or Month For Breast Feeding | day_or_month_for_breast_feeding_851debDay Or Month For Breast Feeding | water_monthWater Month | ani_milk_monthAni Milk Month | semisolid_month_or_daySemisolid Month Or Day | solid_monthSolid Month | vegetables_month_or_dayVegetables Month Or Day | illness_typeIllness Type | illness_durationIllness Duration | treatment_typeTreatment Type | v54V54 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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
);