datameet / covid19

Novel Corona Virus - COVID-19 India Datasets by DataMeet. Sunsetted on 2022-10-21. Will not update anymore.
https://projects.datameet.org/covid19/
Other
121 stars 113 forks source link

Recommended hospital service costs #15

Open thejeshgn opened 3 years ago

thejeshgn commented 3 years ago

Documents related recommended hospital service costs by various state/city goverments. Collect and scrape the data.

https://github.com/datameet/covid19/tree/master/downloads/hospital-service-costs-backup

kushalre commented 3 years ago

Collected most of the pdf files available. Will scrape and data soon. https://github.com/datameet/covid19/commit/752a75c65cdbe742e172a36ba3ec5e6b7afbda7e

salilk5 commented 3 years ago

Hi , I have scraped data from the 1st pdf file "govt-recomends-dl-2020-06-20.pdf " . Attaching the notepad file containing the data and the code.
govt-recomends-dl-2020-06-20.txt

15

salilk5 commented 3 years ago

govt-recomends-dl-2020-06-20_code.txt

15

thejeshgn commented 3 years ago

@salilk5 Let me get back to you.

AnirudhK47 commented 3 years ago

Have extracted the recommended costs for Karnataka to a csv file. Let me know if this tabular form works (output sample attached), and I'll proceed with the rest.

KA_recommended_costs.txt

thejeshgn commented 3 years ago

@AnirudhK47 CSV is good. If you can make it as CSV. I will add it to the repo.

thejeshgn commented 3 years ago

I have been parsing the data manually. Because its mostly text and no point automating it. The PDF documents and images are at

https://github.com/datameet/covid19/tree/master/downloads/hospital-service-costs-backup

The corresponding google sheet is at

https://docs.google.com/spreadsheets/d/1tI-w3G3b2Pepap5ey2f6_fqu2yTyaP8H5xr5dwSpyhg/edit?usp=sharing

You can leave a comment if you find anything weird.

If you want to help, request permission, I will add you as editor.

Thank you,

thejeshgn commented 3 years ago

Punjab - http://health.punjab.gov.in/Compedium%20Final/(20)%20government%20of%20punjab%20(misc)/Pvt%20Institution%20Charges%20for%20COVID-19%20Treatment%2016-Jul-2020.pdf

PDF seems to be missing now.

This article seems to have some data

https://scroll.in/latest/967713/coronavirus-punjab-fixes-treatment-cost-private-hospitals-cant-charge-more-than-rs-18000-per-day

thejeshgn commented 3 years ago

Found it. govt-recomends-pb-2020-07-16.pdf

thejeshgn commented 3 years ago

Haryana is mentioned in this article. I am trying to find the circular

https://www.hindustantimes.com/gurugram/haryana-fixes-package-rates-of-covid-19-treatment-in-private-hospitals/story-QDf0Llf5jEj5hEOQzqJ6GO.html

thejeshgn commented 3 years ago

chandigarh

https://www.tribuneindia.com/news/chandigarh/chandigarh-administration-fixes-rates-for-private-hospitals-122673

Again need to find the circular but it has the rate card.

2020_8$largeimg_647399060

salilk5 commented 3 years ago

Found it. govt-recomends-pb-2020-07-16.pdf Hi - Unable to see this attachment. Also trying to search on the web for this doc

thejeshgn commented 3 years ago

here https://github.com/datameet/covid19/blob/master/downloads/hospital-service-costs-backup/govt-recomends-pb-2020-07-16.pdf