Clinical, Anthropometric & Bio-Chemical Survey
1.89m records & 53 variables of unit level annual health survey data from India.
@kaggle.rajanand_cab_survey
1.89m records & 53 variables of unit level annual health survey data from India.
@kaggle.rajanand_cab_survey
**Annual Health Survey : Mortality Schedule **
This unit level dataset contains the details of Clinical, Anthropometric & Bio-chemical (CAB) Survey. To supplement the information provided by Annual Health Survey (AHS),a biomarker component has been introduced in AHS to collect data on nutritional status, life style diseases like diabetes & hypertension and anemia in Empowered Action Group (EAG) States & Assam. This component, namely Clinical, Anthropometric and Bio-chemical (CAB) survey, is conducted on a sub-sample of AHS in all EAG States namely Bihar, Chhattisgarh, Jharkhand, Madhya Pradesh, Odisha, Rajasthan, Uttarakhand & Uttar Pradesh and Assam.
There are total of 1.89million observations and 53 variables in this dataset.
Base line survey - 2010-11 (4.14 million households in the sample)
1st update - 2011-12 (4.28 million households in the sample)
2nd update - 2012-13 (4.32 million households in the sample)
These nine states, which account for about 48 percent of the total population, 59 percent of Births, 70 percent of Infant Deaths, 75 percent of Under 5 Deaths and 62 percent of Maternal Deaths in the country, are the high focus States in view of their relatively higher fertility and mortality.
The files contains the below columns.
Variable Names:
File content:
Mortality_data_dictionary.xlsx : This data dictionary excel work book has the detailed information about each and every column and codes used in the data.
Department of Health and Family Welfare, Govt. of India has published this data in Open Govt Data Platform India portal under Govt. Open Data License - India.
CREATE TABLE cab_05_ut (
"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 -- Day Or Month For Breast Feeding,
"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
);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 -- Day Or Month For Breast Feeding,
"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
);CREATE TABLE cab_09_up (
"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" DOUBLE,
"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 -- Day Or Month For Breast Feeding,
"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
);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 -- Day Or Month For Breast Feeding,
"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
);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 -- Day Or Month For Breast Feeding,
"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
);CREATE TABLE cab_20_jh (
"state_code" DOUBLE,
"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 -- Day Or Month For Breast Feeding,
"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
);CREATE TABLE cab_21_or (
"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" DOUBLE,
"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 -- Day Or Month For Breast Feeding,
"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
);CREATE TABLE cab_22_ct (
"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" BIGINT,
"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 -- Day Or Month For Breast Feeding,
"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
);CREATE TABLE cab_23_mp (
"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" DOUBLE,
"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 -- Day Or Month For Breast Feeding,
"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
);Anyone who has the link will be able to view this.