Predict Mortality/Death Rate.

770k records & 121 variables of unit level survey data collected from 9 States.

@kaggle.rajanand_mortality

Table List

9 tables(55.61 MB)

Mortality 09 Up

@kaggle.rajanand_mortality.mortality_09_up

15.69 MB
191589 rows
122 columns
Only the first 100 columns are shown

id Id	m_id M Id	hl_id Hl Id	house_no House No	house_hold_no House Hold No	state State	district District	rural Rural	stratum_code Stratum Code	psu_id Psu Id	m_serial_no M Serial No	deceased_sex Deceased Sex	date_of_death Date Of Death	month_of_death Month Of Death	year_of_death Year Of Death	age_of_death_below_one_month Age Of Death Below One Month	age_of_death_above_one_year Age Of Death Above One Year	treatment_source Treatment Source	place_of_death Place Of Death	is_death_reg Is Death Reg	is_death_certificate_received Is Death Certificate Received	serial_num_of_infant_mother Serial Num Of Infant Mother	order_of_birth Order Of Birth	death_symptoms Death Symptoms	is_death_associated_with_pregnan Is Death Associated With Pregnan	death_period Death Period	months_of_pregnancy Months Of Pregnancy	factors_contributing_death Factors Contributing Death	factors_contributing_death_2 Factors Contributing Death 2	symptoms_of_death Symptoms Of Death	time_between_onset_of_complicati Time Between Onset Of Complicati	nearest_medical_facility Nearest Medical Facility	hh_id Hh Id	client_hh_id Client Hh Id	currently_dead_or_out_migrated Currently Dead Or Out Migrated	hh_serial_no Hh Serial No	sex Sex	usual_residance Usual Residance	relation_to_head Relation To Head	member_identity Member Identity	father_serial_no Father Serial No	mother_serial_no Mother Serial No	date_of_birth Date Of Birth	month_of_birth Month Of Birth	year_of_birth Year Of Birth	age Age	religion Religion	social_group_code Social Group Code	marital_status Marital Status	date_of_marriage Date Of Marriage	month_of_marriage Month Of Marriage	year_of_marriage Year Of Marriage	currently_attending_school Currently Attending School	reason_for_not_attending_school Reason For Not Attending School	highest_qualification Highest Qualification	occupation_status Occupation Status	illness_type Illness Type	symptoms_pertaining_illness Symptoms Pertaining Illness	sought_medical_care Sought Medical Care	diagnosed_for Diagnosed For	diagnosis_source Diagnosis Source	regular_treatment Regular Treatment	regular_treatment_source Regular Treatment Source	chew Chew	smoke Smoke	alcohol Alcohol	status Status	hh_expall_status Hh Expall Status	client_hl_id Client Hl Id	serial_no Serial No	house_status House Status	house_structure House Structure	owner_status Owner Status	drinking_water_source Drinking Water Source	is_water_filter Is Water Filter	water_filteration Water Filteration	toilet_used Toilet Used	is_toilet_shared Is Toilet Shared	household_have_electricity Household Have Electricity	lighting_source Lighting Source	cooking_fuel Cooking Fuel	no_of_dwelling_rooms No Of Dwelling Rooms	kitchen_availability Kitchen Availability	is_radio Is Radio	is_television Is Television	is_computer Is Computer	is_telephone Is Telephone	is_washing_machine Is Washing Machine	is_refrigerator Is Refrigerator	is_sewing_machine Is Sewing Machine	is_bicycle Is Bicycle	is_scooter Is Scooter	is_car Is Car
712232	375	2944	63	3	9	58	1	1	100270529	4	1	10	11	2008	0	80	0	1	1	1	0	0	0	0	0	0	0	0	0	0	0	13141	nan	2	1	1	1	1	314	nan	nan	0	0	1966	43	1	3	3	0	5	1990	nan	nan	4	7	0	11	nan	0	0	nan	0	7	4	4	0	1	nan	77	1	1	1	3	2	nan	0	nan	1	1	3	2	4	2	2	3	2	2	2	2	1	2	2
712240	383	2997	28	1	9	58	1	1	100269231	5	1	13	12	2007	0	70	9	3	1	1	0	0	0	0	0	0	0	0	0	0	0	13325	nan	2	1	2	1	1	104	nan	nan	0	0	1939	70	1	3	5	0	0	1952	nan	nan	0	16	3	5	2	21	8	2	8	5	4	4	0	1	nan	32	1	1	1	3	2	nan	0	nan	2	2	2	2	2	2	2	3	4	2	2	2	2	2	2
109886	246	nan	58	1	9	62	1	2	100281885	1	1	30	7	2011	0	87	0	1	1	1	0	0	0	0	0	0	0	0	0	0	0	40051	nan	2	02	2	1	1	277	nan	nan	6	12	1954	57	1	1	3	0	6	1974	nan	nan	3	2	0	99	nan	0	0	nan	0	7	4	4	0	1	nan	62	1	1	1	3	2	nan	0	nan	1	2	3	4	2	1	2	3	2	2	2	2	1	2	2
712216	359	2706	196	1	9	58	1	1	100268481	38	2		5	2009	0	90	9	1	1	2	0	0	0	0	0	0	0	0	0	0	0	12090	nan	2	1	1	1	1	876	nan	nan	0	0	1959	50	1	3	5	0	4	1970	nan	nan	0	3	0	11	nan	0	0	nan	0	1	1	1	0	1	nan	228	1	1	1	3	2	nan	0	nan	2	2	3	3	1	2	2	3	4	2	2	2	1	2	2
712224	367	2777	253	1	9	58	1	1	100268463	41	2		5	2008	6	0	0	1	2	0	2	3	3	0	0	0	0	0	0	0	0	12440	nan	2	1	2	1	1	1218	nan	nan	0	0	1944	65	1	3	5	0	0	1954	nan	nan	0	15	0	4	2	19	8	2	8	7	4	4	0	1	nan	299	1	1	1	3	2	nan	0	nan	2	2	2	1	4	2	2	3	2	2	2	2	1	2	2
109878	nan	nan	170	1	9	62	1	2	100282327	99	1		2	2012	0	87	nan	nan		nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	2	02	2	1	1	864	nan	nan	0	0	1944	67	1	1	3	0	5	1960	nan	nan	0	10	0	99	nan	0	0	nan	0	5	4	4	0	1	nan	189	1	3	1	3	2	nan	0	nan	2	2	3	1	2	2	2	3	4	2	2	2	2	2	2
109870	184	nan	32	1	9	62	1	2	100282361	2	1	25	8	2011	0	60	8	1	2	0	0	0	0	0	0	0	0	0	0	0	0	84094	nan	nan	02	2	nan	1	1543	nan	nan	0	0	1981	30	1	3	3	0	0	2000	nan	nan	0	10	0	13	1	30	8	2	8	nan	nan	nan	nan	nan	nan	400	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
109862	nan	nan	258	2	9	62	1	2	100281313	99	2	27	8	2012	0	67	nan	nan		nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	06	1	nan	1	2060	nan	nan	0	0	1976	35	1	3	3	16	4	2000	nan	nan	4	1	0	99	nan	0	0	nan	0	nan	nan	nan	nan	nan	nan	271	1	1	1	3	2	nan	0	nan	1	2	3	1	4	2	2	3	2	2	2	2	1	2	2
712200	343	2593	101	1	9	58	1	1	100268480	25	1		1	2007	0	55	9	1	1	1	0	0	0	0	0	0	0	0	0	0	0	11688	nan	2	1	2	1	1	492	nan	nan	0	0	1959	50	1	3	5	0	5	1971	nan	nan	0	16	0	10	2	1	9	2	9	7	4	4	0	1	nan	117	1	1	1	3	2	nan	0	nan	1	2	3	1	2	2	2	3	2	2	2	2	1	2	2
712208	351	2644	143	1	9	58	1	1	100268490	18	1	13	2	2008	0	30	0	1	1	1	0	0	0	0	0	0	0	0	0	0	0	11887	nan	2	1	2	1	1	685	nan	nan	0	0	1963	46	1	1	5	0	5	1980	nan	nan	2	10	0	11	nan	0	0	nan	0	7	4	4	1	1	nan	168	1	1	1	3	2	nan	2	2	1	2	3	4	1	1	1	3	2	2	2	2	1	2	2


CREATE TABLE mortality_09_up (
  "id" BIGINT,
  "m_id" VARCHAR,
  "client_m_id" DOUBLE,
  "hl_id" VARCHAR,
  "house_no" BIGINT,
  "house_hold_no" BIGINT,
  "state" BIGINT,
  "district" BIGINT,
  "rural" BIGINT,
  "stratum_code" BIGINT,
  "psu_id" BIGINT,
  "m_serial_no" DOUBLE,
  "deceased_sex" BIGINT,
  "date_of_death" DOUBLE,
  "month_of_death" DOUBLE,
  "year_of_death" DOUBLE,
  "age_of_death_below_one_month" VARCHAR,
  "age_of_death_below_eleven_month" VARCHAR,
  "age_of_death_above_one_year" VARCHAR,
  "treatment_source" VARCHAR,
  "place_of_death" VARCHAR,
  "is_death_reg" DOUBLE,
  "is_death_certificate_received" VARCHAR,
  "serial_num_of_infant_mother" VARCHAR,
  "order_of_birth" VARCHAR,
  "death_symptoms" VARCHAR,
  "is_death_associated_with_pregnan" VARCHAR,
  "death_period" VARCHAR,
  "months_of_pregnancy" VARCHAR,
  "factors_contributing_death" VARCHAR,
  "factors_contributing_death_2" VARCHAR,
  "symptoms_of_death" VARCHAR,
  "time_between_onset_of_complicati" VARCHAR,
  "nearest_medical_facility" VARCHAR,
  "m_expall_status" DOUBLE,
  "field38" VARCHAR,
  "hh_id" VARCHAR,
  "client_hh_id" VARCHAR,
  "currently_dead_or_out_migrated" VARCHAR,
  "hh_serial_no" VARCHAR,
  "sex" VARCHAR,
  "usual_residance" VARCHAR,
  "relation_to_head" VARCHAR,
  "member_identity" VARCHAR,
  "father_serial_no" VARCHAR,
  "mother_serial_no" VARCHAR,
  "date_of_birth" VARCHAR,
  "month_of_birth" VARCHAR,
  "year_of_birth" VARCHAR,
  "age" VARCHAR,
  "religion" VARCHAR,
  "social_group_code" VARCHAR,
  "marital_status" VARCHAR,
  "date_of_marriage" VARCHAR,
  "month_of_marriage" VARCHAR,
  "year_of_marriage" VARCHAR,
  "currently_attending_school" VARCHAR,
  "reason_for_not_attending_school" VARCHAR,
  "highest_qualification" VARCHAR,
  "occupation_status" VARCHAR,
  "disability_status" VARCHAR,
  "injury_treatment_type" VARCHAR,
  "illness_type" VARCHAR,
  "symptoms_pertaining_illness" VARCHAR,
  "sought_medical_care" VARCHAR,
  "diagnosed_for" VARCHAR,
  "diagnosis_source" VARCHAR,
  "regular_treatment" VARCHAR,
  "regular_treatment_source" VARCHAR,
  "chew" VARCHAR,
  "smoke" VARCHAR,
  "alcohol" VARCHAR,
  "status" VARCHAR,
  "hh_expall_status" VARCHAR,
  "client_hl_id" VARCHAR,
  "serial_no" VARCHAR,
  "building_no" VARCHAR,
  "house_status" VARCHAR,
  "house_structure" VARCHAR,
  "owner_status" VARCHAR,
  "drinking_water_source" VARCHAR,
  "is_water_filter" VARCHAR,
  "water_filteration" VARCHAR,
  "toilet_used" VARCHAR,
  "is_toilet_shared" VARCHAR,
  "household_have_electricity" VARCHAR,
  "lighting_source" VARCHAR,
  "cooking_fuel" VARCHAR,
  "no_of_dwelling_rooms" VARCHAR,
  "kitchen_availability" VARCHAR,
  "is_radio" VARCHAR,
  "is_television" VARCHAR,
  "is_computer" VARCHAR,
  "is_telephone" VARCHAR,
  "is_washing_machine" VARCHAR,
  "is_refrigerator" VARCHAR,
  "is_sewing_machine" VARCHAR,
  "is_bicycle" VARCHAR,
  "is_scooter" VARCHAR,
  "is_car" VARCHAR
);