Name: Hospitals And Beds In India (Statewise)
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Hospitals And Beds In India (Statewise)

Context

The Novel coronavirus (Covid-19) has caused acute shortage of healthcare infrastructure. The following is number of beds and hospitals in different states and union territories. This data along with the patient database can be crucial in predicting the acute shortages of medical infrastructure and supplement wherever necessary.

Content

The files contain the details of number of beds and hospitals in different states and union territories as of July 2018. The dataset is further classified into the ministries that maintain these hospitals and beds (Ministry of Defence, Railways etc.).

The file contains

Number of Primary Health Centers(PHCs), Community Health Centers(CHCs), Sub-District/Divisional Hospitals(SDHs), District Hospitals(DHs) and beds, India, State/UT wise as uploaded by the State/UTs on the Health Management Information System (HMIS) portal of the Ministry.
Number of Govt. Hospitals and beds in Rural and Urban Areas, India, State/UT wise, as available in the Publication National Health Profile 2018.
Number of AYUSH hospitals and beds State/UT-wise, as provided by the Ministry of AYUSH.
Number of Hospitals and beds maintained by Ministry of Defence, State wise and Total.
Number of Railway Hospitals and beds, as available in the Publication National Health Profile 2018.
Number of Employees State Insurance Corporation Hospitals and beds, State/UT and Total, as available in the Publication National Health Profile 2018.

The original data is available in HTML format at (https://pib.gov.in/PressReleasePage.aspx?PRID=1539877) Archive. The original data is copyright free and republished here with CC0 License

Acknowledgements

We wouldn't be here without the help of others. If you owe any attributions or thanks, include them here along with any citations of past research.

Inspiration

The fight the ongoing Covid-19 crisis.

Tables

Ayushhospitals

@kaggle.dheerajmpai_hospitals_and_beds_in_india.ayushhospitals

8.61 kB
43 rows
10 columns

CREATE TABLE ayushhospitals (
  "srl_no" VARCHAR  -- Srl No.,
  "state_ut" VARCHAR  -- State / UT,
  "number_of_hospitals" VARCHAR,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "number_of_beds" VARCHAR,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

Employees State Insurance Corporation

@kaggle.dheerajmpai_hospitals_and_beds_in_india.employees_state_insurance_corporation

4.58 kB
33 rows
4 columns

CREATE TABLE employees_state_insurance_corporation (
  "employees_state_insurance_corporation_hospitals_and_be_3c440abd" VARCHAR  -- Employees State Insurance Corporation Hospitals And Beds (as On 31.03.2017),
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3
);

Hospitals And Beds Maintained By Ministry Of Defence

@kaggle.dheerajmpai_hospitals_and_beds_in_india.hospitals_and_beds_maintained_by_ministry_of_defence

4.25 kB
31 rows
4 columns

CREATE TABLE hospitals_and_beds_maintained_by_ministry_of_defence (
  "s_no" VARCHAR  -- S. No.,
  "name_of_state" VARCHAR,
  "no_of_hospitals" DOUBLE  -- No. Of Hospitals,
  "no_of_beds" DOUBLE  -- No. Of Beds
);

Hospitals And Beds Maintained By Railways

@kaggle.dheerajmpai_hospitals_and_beds_in_india.hospitals_and_beds_maintained_by_railways

4.58 kB
27 rows
4 columns

CREATE TABLE hospitals_and_beds_maintained_by_railways (
  "number_of_hospitals_and_beds_in_railways_as_on_21_03_2018" VARCHAR  -- Number Of Hospitals And Beds In Railways (as On 21/03/2018),
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3
);

Hospitals And Beds Statewise

@kaggle.dheerajmpai_hospitals_and_beds_in_india.hospitals_and_beds_statewise

6.72 kB
37 rows
7 columns

CREATE TABLE hospitals_and_beds_statewise (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "phc" BIGINT,
  "chc" BIGINT,
  "sdh" DOUBLE,
  "dh" BIGINT,
  "total" BIGINT,
  "unnamed_6" BIGINT  -- Unnamed: 6
);

Metadata

@kaggle.dheerajmpai_hospitals_and_beds_in_india.metadata

3.98 kB
8 rows
4 columns

CREATE TABLE metadata (
  "source_link" VARCHAR,
  "https_pib_gov_in_pressreleasepage_aspx_prid_1539877" VARCHAR  -- Https://pib.gov.in/PressReleasePage.aspx?PRID\u003d1539877,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3
);

Number Of Government Hospitals And Beds In Rural And U 1c85a5c8

@kaggle.dheerajmpai_hospitals_and_beds_in_india.number_of_government_hospitals_and_beds_in_rural_and_u_1c85a5c8

6.02 kB
38 rows
6 columns

CREATE TABLE number_of_government_hospitals_and_beds_in_rural_and_u_1c85a5c8 (
  "states_uts" VARCHAR,
  "rural_hospitals" VARCHAR,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "urban_hospitals" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "as_on" VARCHAR
);