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 23 Mp

@kaggle.rajanand_mortality.mortality_23_mp

7.49 MB
90744 rows
122 columns
Only the first 100 columns are shown

id Id	m_id M Id	client_m_id Client 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_below_eleven_month Age Of Death Below Eleven 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	m_expall_status M Expall Status	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	disability_status Disability Status	injury_treatment_type Injury Treatment Type	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	building_no Building 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
439681	581	631	6977	336	1	23	10	1	1	100683292	314	2		6	2008	nan	nan	50	6	1	3	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	1	19118	21540	2	1	1	1	1	905	nan	nan	0	0	1939	70	1	3	5	0	0	1946	nan	nan	0	1	0	0	0	11	nan	0	nan	nan	nan	5	4	4	0	1	8007	397	nan	1	3	1	3	2	nan	0	nan	1	2	1	2	2	2	2	3	2	2	2	2	2	2	2
439689	589	449	7059	34	2	23	10	1	1	100682848	34	1		8	2008	8	nan	nan	8	3	1	2	2	2	1	nan	nan	nan	nan	nan	nan	nan	nan	1	19392	17021	2	1	1	1	1	183	nan	nan	0	0	1984	25	1	1	3	0	6	2003	nan	nan	0	10	0	0	0	11	nan	0	nan	nan	nan	7	4	4	0	1	8047	45	nan	1	3	1	6	2	nan	0	nan	2	2	1	2	2	2	2	3	2	2	2	2	2	2	2
439697	597	453	7153	44	1	23	10	1	2	100682465	49	2		5	2008	nan	nan	77		1	1	1	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	1	19656	16734	2	1	1	1	1	138	6	nan	24	1	1962	47	1	3	3	9	3	1987	nan	nan	8	7	0	0	0	11	nan	0	nan	nan	nan	3	4	4	0	1	7341	60	nan	1	1	1	3	1	5	2	1	1	2	6	4	1	2	1	3	2	1	2	1	2	1	2
439705	605	461	7227	105	1	23	10	1	2	100682473	116	1	24	6	2007	nan	nan	86		1	2	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	1	19914	16992	2	1	1	1	1	383	nan	nan	0	6	1967	42	1	3	3	0	4	1970	nan	nan	2	1	0	0	0	11	nan	0	nan	nan	nan	5	4	4	0	1	7415	135	nan	1	2	1	2	2	nan	0	nan	1	2	1	2	2	2	2	3	2	2	2	2	1	2	2
439713	613	469	7368	212	5	23	10	1	2	100682491	232	1		3	2007	nan	nan	55	9	1	1	1	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	1	20357	17464	2	1	1	1	1	801	nan	2	0	5	1987	22	1	1	1	0	0	0	nan	nan	3	3	0	0	0	11	nan	0	nan	nan	nan	5	2	2	0	1	7556	275	nan	1	3	1	3	2	nan	0	nan	1	2	1	1	2	2	2	3	4	2	2	2	1	2	2
439721	622	478	7567	351	1	23	10	1	2	100682446	375	1		6	2008	nan	1	nan	6	1	2	nan	2	2	15	nan	nan	nan	nan	nan	nan	nan	nan	1	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
439729	625	257	7717	46	1	23	10	1	1	100683599	44	2		9	2008	nan	nan	75	8	1	2	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	1	21073	4918	2	1	1	1	1	156	nan	nan	0	0	1961	48	1	2	3	0	0	1981	nan	nan	0	3	0	0	0	11	nan	0	nan	nan	nan	7	4	3	0	1	2341	57	nan	1	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
439737	637	196	7792	67	1	23	10	1	1	100683218	1	1		4	2008	nan	nan	70		1	2	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	1	21413	3107	2	1	1	1	1	171	nan	nan	11	5	1959	50	1	3	3	7	8	1982	nan	nan	6	7	0	0	0	11	nan	0	nan	nan	nan	7	4	4	0	1	1597	74	nan	1	1	1	6	2	nan	0	nan	1	2	1	1	4	2	2	3	4	2	2	2	2	2	2
439745	645	204	7955	202	1	23	10	1	1	100683245	237	1		6	2009	nan	nan	70	6	1	2	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	1	21869	3563	2	1	1	1	1	611	nan	nan	0	0	1983	26	1	3	3	0	0	2005	nan	nan	5	3	0	0	0	11	nan	0	nan	nan	nan	5	4	4	0	1	1760	237	nan	1	2	1	6	1	4	0	nan	2	2	1	1	4	2	2	3	4	2	2	2	2	2	2
439753	677	198	8063	20	1	23	10	1	1	100682506	18	2		9	2008	nan	nan	8		1	2	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	1	22999	2854	2	1	1	1	1	70	nan	nan	0	0	1962	47	1	3	3	0	6	1981	nan	nan	0	2	0	0	0	11	nan	0	nan	nan	nan	7	4	4	0	1	1655	25	nan	1	3	1	9	2	nan	0	nan	2	2	1	1	1	2	2	3	4	2	2	2	2	2	2


CREATE TABLE mortality_23_mp (
  "id" BIGINT,
  "m_id" VARCHAR,
  "client_m_id" VARCHAR,
  "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" VARCHAR,
  "deceased_sex" BIGINT,
  "date_of_death" DOUBLE,
  "month_of_death" VARCHAR,
  "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" DOUBLE,
  "place_of_death" DOUBLE,
  "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
);