Re: [datameet] Support with District-Wise Vaccine Delivery - Throughput data per day

[Bhanu K]

hi Aashir,

This is an interesting work, thanks for sharing... From what I gather,
population projection data at districts is not available publicly. I
discovered two datasets for projecting populations at state-level recently:

1) UIDAI 
 (PDF)
  - estimates as of 31 dec, 2020
2) NHM

(big PDF)
  - estimates as of 1 mar, 2021
  - more granular estimates by category (age, gender)

I'm not an expert in this area, interested to learn. A friend suggested
estimating population from raster images shared by the likes of WorldPop
 (another source

).

*Step 1 - estimate population*
I've used QGIS (raster zonal stats) to estimate population
. Tutorial

for step-by-step guide. The files I used are from WorldPop, India districts
shapefile and use sum instead of average metric in zonal stats.

After this step, we'll have a population estimate at district level.

*Step 2 - compare against baseline*
2.1 Aggregate the population numbers at state-level.
2.2 Use state estimates from UIDAI or NHM as a baseline.
2.3 Determine the relative change rate (raster estimated population divided
by state estimate from UIDAI or NHM).
2.4 Use this rate and divide the district estimate (at the end of step 1)
by it.

I've done this for states and shared the results here
.
For most states (with multiple districts) the approach seems to work well
but *fails* for smaller regions.

If anyone else has done this earlier do share feedback on improving this
approach or suggest alternative ways.

Thanks,
Bhanu


On Sun, May 30, 2021 at 10:42 PM aashir...@gmail.com 
wrote:

> Dear All,
>
> Using the CoWIN API I managed to calculate the district-wise throughput
> data per day for vaccine delivery in India.
>
> Throughput per day per district = (SUM(Number of First Doses + Number of
> Second Dose)/Total number of Sessions)*Total number of sites
>
> The only way I get this data to be usable is to append the throughput
> numbers with the weighted average of the population of the district. This
> will provide an accurate representation of the vaccine delivery performance
> per district (although this will still be at an aggregate level).
>
> Can anyone point me to accurate population data per district as per the
> sheet enclosed as the attachment. It will be of immense help.
>
> Sincerely,
> Aashir.
>
> --
> 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+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/datameet/a677a25d-d560-44b3-8739-548b1feb4d82n%40googlegroups.com
> 
> .
>

-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/datameet/CADbFdW6oM8gor9WR7OdWOKxqkML-1pFkcaAVa-h%3D92L-m%3DU_oA%40mail.gmail.com.

Re: [datameet] Covid bed availability on a map

[Bhanu K]

Hi Achal,

@beds_covid has been helping people to find hospital beds.

Please check their work and reach out to them:

https://twitter.com/beds_covid


On Thu, May 20, 2021, 4:25 AM Achal Agrawal  wrote:

> Dear All,
>
> We started https://covi-find.in  2 weeks back, with the intention of
> geolocating all the covid beds in India. It is an open source project.
> Here's the github repo : https://github.com/Rohithgilla12/covi-find .
> Will be great if anyone wants to contribute.
>
> We are also trying to help as many as we can through our twitter handle
> @CoviFind . Any volunteers to help verify leads will be really useful.
>
> Best Regards,
>
> Achal Agrawal
>
> --
> 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+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/datameet/fcf622a0-51fc-4af1-b16f-0ed5386e2f0bn%40googlegroups.com
> 
> .
>

-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/datameet/CADbFdW5xke1TWfzgst%2BCMf_vzaVZmz9cu%2BSF%3DB8jDu5r1Xugnw%40mail.gmail.com.

Re: [datameet] Summarized election data

[Bhanu K]

Lok Dhaba by Ashoka Universitty puts out consolidated election data at
constituency/election year/candidate granularity. The Data Visualization
view gives different summaries.

If you're looking for something on that please check their work:
http://www.lokdhaba.ashoka.edu.in/browse-data?et=GE

thanks,
Bhanu

On Fri, May 7, 2021 at 2:18 PM satwik gade  wrote:

> Hi all,
>
> Asking for a friend. Is Lokniti the best place to get summarized election
> info. Are there any places that are cheaper?
>
> Thank you.
>
> Regards,
> Satwik
>
> On Thu, May 6, 2021, 5:13 PM Sumantra Misra 
> wrote:
>
>> Dear everybody,
>>
>> Hoping someone has already mapped it or hoping to collaborate with
>> whoever wants to map Urban Heat Islands in Bhubaneswar. Going forward this
>> data will be used to analyse why the city is hotter than many in the
>> region. Do let me know if someone can help.
>>
>> --
>> 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+unsubscr...@googlegroups.com.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/datameet/7ee1577e-34dc-4b17-ae00-fa30c34cb819n%40googlegroups.com
>> 
>> .
>>
> --
> 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+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/datameet/CADbY0J-6CqkypK1KVPyrpaZ3QqQwMb5fKKMb7BC1_pOradznxQ%40mail.gmail.com
> 
> .
>


-- 
Bhanu

-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/datameet/CADbFdW7nd4M9Kyjj0E5L7Q0uJNUD_kiVC01L_mLE7HOym7JDXA%40mail.gmail.com.

Re: [datameet] Non Virus Data

[Bhanu K]

thanks for this dataset, Thej and team.

We used this data and published the names of all those
 who died and where
 they died.

URL: http://covid19indiaresponse.behanbox.com/. Source code on GitHub
.

- I made a copy

of the data and made few changes. Documented in a post
.
- I'm extracting from/to locations (columns Z to AD) of those who were
walking. let me know if anyone's interested to contribute.

Regards,
Bhanu


On Wed, May 20, 2020 at 4:57 AM Thejesh GN  wrote:

> It continues to grow :(
>
> We have added categorisation/Tag and FAQ.
>
> Anything else that we can do with this data? Visualization or Analysis.
>
>
> https://thejeshgn.com/projects/covid19-india/non-virus-deaths/
>
> Regards,
> Thej
>
> Thejesh GN ⏚ ತೇಜೇಶ್ ಜಿ.ಎನ್
> http://thejeshgn.com
>
> --
> 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+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/datameet/CAABnYsXC8skwDGab7F0-VXwTyCTDiOaoU3qqRZsZ%2B0kLQ_0y%3Dw%40mail.gmail.com
> 
> .
>


-- 
Bhanu

-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/datameet/CADbFdW7MJKHW%2BKedv5vC55ceojqfho6ft%3DzHnTEZF26bA2k3_g%40mail.gmail.com.

Re: [datameet] any help with geocoding and reverse geocoding without api or from open source

[Bhanu K]

Hi Deepak,

Few options depending on the tool:

- if Google Sheets is an option, Geocode by Awesome Table

is a good add-on.
- if Microsoft Excel is an option, geocode-excel
 is an offline version.
- Nominatim API 
can be used in a language of your choice.

thanks,
Bhanu


On Sat, Apr 18, 2020 at 5:00 PM Deepak Sharda  wrote:

> i googled and get this site address which is open source of geocoding and
> reverse geocoding but i am not expert in node.js  could you help .
>
>
> is it helpful for data relating to india.
>
>
> there was a file aattached as sample data for india
>
> https://github.com/pelias/pelias
>
> --
> 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+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/datameet/a672e807-c8dd-4dba-8d79-f407aa076cb1%40googlegroups.com
> 
> .
>


-- 
Bhanu

-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/datameet/CADbFdW4_1DrFTrQvpTdBuBmW2KMmm3Kxr8D84nmKK9Viwt6fmg%40mail.gmail.com.

Re: [datameet] Help clean up hospital capacity data

[Bhanu K]

hi Pradeep,

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

Thanks,
Bhanu


On Fri, Apr 17, 2020 at 12:36 PM Pradeep Varadaraja Banavara <
pradee...@gmail.com> wrote:

> Updated the sheet. May I kindly request few folks do some Quality Checks
> before this can be consumed?
>
> On Fri, Apr 17, 2020 at 4:21 PM Pradeep Varadaraja Banavara <
> pradee...@gmail.com> wrote:
>
>> 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.
>>
>>
>>
>> On Fri, Apr 17, 2020 at 2:32 PM Sajjad Anwar  wrote:
>>
>>> 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
>>>
>>> --
>>> 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+unsubscr...@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
>>> 
>>> .
>>>
>> --
> 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+unsubscr...@googlegroups.com.
> 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

-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/datameet/CADbFdW5hady8dmHM8_uwL%3DUnndun4X9WSdcpU0ixHnSpO42JYw%40mail.gmail.com.