Help clean up hospital capacity data

[Sajjad Anwar]

Hello everyone,

A lot of folks have asked for hospital capacity datasets. While there are some out there there's no comprehensive list with location data. I found a table from the National Health Profile of 2019 that has state wise hospital details including number of beds. 

Took a first pass to turn it into CSV but this needs some manual work to clean up.  The spreadsheet is here https://docs.google.com/spreadsheets/d/1Vb1vtw4lTiP8hThLIVF4Laa8M6ozNz1vcy221Ohulw4/edit#gid=1280229606

I've attached the PDF for reference. The most important thing is to make sure the hospital name and rows match up. Some of the names couldn't be imported because the PDF wasn't rightly encoded. 

Any help appreciated. Please reach out to me if you have any questions. 

Sajjad

[Pradeep Varadaraja Banavara]

Updated for Karnataka.

Used the Copyfish Chrome plugin to do OCR on PDF in the browser (https://chrome.google.com/webstore/detail/copyfish-%F0%9F%90%9F-free-ocr-soft/eenjdnjldapjajjofmldgmkjaienebbj/related)

Will do West Bengal next. 

--
Datameet is a community of Data Science enthusiasts in India. Know more about us by visiting http://datameet.org
---
You received this message because you are subscribed to the Google Groups "datameet" group.
To unsubscribe from this group and stop receiving emails from it, send an email to datameet+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CALQA-LW3AqKKmGUbveZOda4bfvPTarcBDyDSb_BULWj-_4-6fg%40mail.gmail.com.

[Pradeep Varadaraja Banavara]

Updated the sheet. May I kindly request few folks do some Quality Checks before this can be consumed? 

[Pujari Dabbish]

& would anybody explain

What does admission capacity vs no. of beds means?

On Fri, Apr 17, 2020 at 4:06 PM Pujari Dabbish <dabh...@gmail.com> wrote:

Hello Everyone,

I counted the no. of beds capacity from data above it is coming out to be 2,91,817‬ which is way more than the 1lac mark given by the govt.

I am assuming 1lac is corona specific beds, anyways this gives a new scope as we have just 8k short of 3 lacs beds. Correct me if I am wrong.

On Fri, Apr 17, 2020 at 2:32 PM Sajjad Anwar <sajj...@gmail.com> wrote:

--

[Bhanu K]

hi Pradeep,

I reviewed entries for Telangana, Tripura, Uttar Pradesh, Uttarakhand, West Bengal. they look same as the PDF.

Thanks,

Bhanu

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CAMh_HWd_Td-E3TEUdgO8%2B%3DgD%3D1Gk4uS4pZS3Mv%2BKVDkCVrAi8g%40mail.gmail.com.

--

Bhanu

[Pujari Dabbish]

Hello Everyone,

I counted the no. of beds capacity from data above it is coming out to be 2,91,817‬ which is way more than the 1lac mark given by the govt.

I am assuming 1lac is corona specific beds, anyways this gives a new scope as we have just 8k short of 3 lacs beds. Correct me if I am wrong.

On Fri, Apr 17, 2020 at 2:32 PM Sajjad Anwar <sajj...@gmail.com> wrote:

--

[Soumya Ranjan]

Hi Sajjad,

I used Camelot a few weeks back to scrape the same data & also added geo-coordinates for the hospitals.

Here is the sheet, hope this helps.

Thanks,

Soumya Ranjan

On Fri, Apr 17, 2020 at 2:32 PM Sajjad Anwar <sajj...@gmail.com> wrote:

--

[Soumya Ranjan]

Admission Capacity: Intake of students every year.

# of beds: Number of beds in the hospital

- Soumya 

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CAAbsXhW9Gurphyv1_bMDB75OTqLYTf3CAYRLVhQ816iuNYpW%2Bg%40mail.gmail.com.

[Pujari Dabbish]

Thank you Soumya.

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CAB2NP-H%3Dejk8gUi51S0ApiOQ1mJb9ZBFgT7QW7Xk6hjpMkOuFA%40mail.gmail.com.

[Sajjad Anwar]

Wow, this is so amazing. Such a great birthday gift, Datameet! I'm going to compile all this and put it up on our Covid project page. Thank you so much everyone!

Sajjad

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CAAbsXhUdE5HY8dSi0DYVBLkkeW6Su9PECJa3roMP8eEWWdAXhQ%40mail.gmail.com.