AV JanataHack Healthcare Hackathon II

Analytic Vidya Janatahack Healthcare Hackathon Dataset

@kaggle.blessondensil294_av_janatahack_healthcare_hackathon_ii

Table List

4 tables(7.59 MB)

Sample Submission Lfbv3c3

Test

Train

Train Data Dict

Test

@kaggle.blessondensil294_av_janatahack_healthcare_hackathon_ii.test

2.05 MB
137057 rows
17 columns

case_id Case Id	hospital_code Hospital Code	hospital_type_code Hospital Type Code	city_code_hospital City Code Hospital	hospital_region_code Hospital Region Code	available_extra_rooms_in_hospital Available Extra Rooms In Hospital	department Department	ward_type Ward Type	ward_facility_code Ward Facility Code	bed_grade Bed Grade	patientid Patientid	city_code_patient City Code Patient	type_of_admission Type Of Admission	severity_of_illness Severity Of Illness	visitors_with_patient Visitors With Patient	age Age	admission_deposit Admission Deposit
318439	21	c	3	Z	3	gynecology	S	A	2	17006	2	Emergency	Moderate	2	71-80	3095
318440	29	a	4	X	2	gynecology	S	F	2	17006	2	Trauma	Moderate	4	71-80	4018
318441	26	b	2	Y	3	gynecology	Q	D	4	17006	2	Emergency	Moderate	3	71-80	4492
318442	6	a	6	X	3	gynecology	Q	F	2	17006	2	Trauma	Moderate	3	71-80	4173
318443	28	b	11	X	2	gynecology	R	F	2	17006	2	Trauma	Moderate	4	71-80	4161
318444	23	a	6	X	3	gynecology	Q	F	2	17006	2	Trauma	Moderate	2	71-80	4659
318445	26	b	2	Y	2	gynecology	Q	D	2	17006	2	Trauma	Moderate	2	71-80	4167
318446	25	e	1	X	4	gynecology	S	E	3	95946		Emergency	Moderate	2	31-40	4396
318447	23	a	6	X	4	gynecology	Q	F	3	95946		Trauma	Moderate	2	31-40	4088
318448	23	a	6	X	3	gynecology	Q	F	4	95946		Urgent	Moderate	2	31-40	3925


CREATE TABLE test (
  "case_id" BIGINT,
  "hospital_code" BIGINT,
  "hospital_type_code" VARCHAR,
  "city_code_hospital" BIGINT,
  "hospital_region_code" VARCHAR,
  "available_extra_rooms_in_hospital" BIGINT,
  "department" VARCHAR,
  "ward_type" VARCHAR,
  "ward_facility_code" VARCHAR,
  "bed_grade" DOUBLE,
  "patientid" BIGINT,
  "city_code_patient" DOUBLE,
  "type_of_admission" VARCHAR,
  "severity_of_illness" VARCHAR,
  "visitors_with_patient" BIGINT,
  "age" VARCHAR,
  "admission_deposit" DOUBLE
);