hktang / covid-hyogo Goto Github PK

View Code? Open in Web Editor NEW

7.0 7.0 2.0 10.02 MB

Responsible visualizations of COVID-19 in Hyogo Prefecture, Japan

Home Page: https://covid19hyogo.org

License: MIT License

JavaScript 16.07% HTML 1.87% Vue 51.69% Python 28.83% Shell 1.55%

covid-19 covid-19-hyogo covid19-japan

covid-hyogo's Introduction

Hi there 👋

covid-hyogo's People

Contributors

Stargazers

Watchers

Forkers

jajamoks autumnsky64

covid-hyogo's Issues

Calculate map circle radius on zoom in/out

Currently, the radius of circle markers on the map is a fixed value based on device type (mobile or others). It does not respond to zooming events and is therefore problematic especially when the map is zoomed out.

Breaking change: undisclosed gender

The gender of case #1077 is not disclosed. A few charts must be updated to reflect this option.

Information about Coockies/Google Analytics

Since Google Analytics is used to understand how the page is used, some kinds of ToS should be added. The Hyogo Stop COVID-19 page is a great example: https://stop-covid19-hyogo.org/about

Language - Hiragana mode

I think Hiragana "ひらがな" mode is usefull.
It would be helpfull for foreigners who unfamiliar with Kanji and usefull for japanese children.
I will implement within several days.

私はひらがなの表示モードが役立つと思います。
漢字に不慣れな外国人の助けになる。日本人の子供も使いやすい。
数日中に実装する予定です。

Disclaimer for the map

For simplicity/convenience, cases in the "administrative jurisdictions" are merged into the city itself. For example, 伊丹健康福祉事務所管内 is considered 伊丹 in the map.

A disclaimer should be added to the page to indicate how this is handled.

Compare chart - "capacity" between patient

I think hospital beds number is very important information, but one of most sensitive issue.

Realiy useful?

This project should be to help prevent infection for citizens, not to fuel the crisis.
Is this chart that comparison hospital beds with patient useful for preventing community-acquired infections?

Difficulty of ”Capacity" definition

What is "Capacity"?

Hospital beds prepared for COVID-19
Hotels for non-severe patient, Hyogo.pref has yet decided use hotels.

There will also be waiting at home for non-severe.
And may Accept patients across prefectures.

Difficulty of Infomation resouce

The number of beds is gradually increased, but no daily announced.
And annouce by PDF, it is difficult to crawl.
Example, nothing about beds in this page, need to open PDF and written by japanese.
https://web.pref.hyogo.lg.jp/kk03/200129.html

Daily discharges is not announced, only discharged total.

Check if the daily male/female/total for the previous day is correct

This section of the updater script is buggy because sometimes cases are backdated (i.e. added in the early morning of Day(n) for Day(n-1)). In that case, the script should check the previous day after it inserts a blank row for the current day.

covid-hyogo/src/updater/updateGoogleSheet.py

Lines 103 to 127 in 38a5b43

    
           # Todo: sometimes backdated cases do happen.  
        
           # Need to check one more row (2.A3 and D.A4) 
        
           refWorksheet = sheet.worksheet("D") 
        
           pivotLastDateString = refWorksheet.get("A3").first() 
        
           if lastDateString == pivotLastDateString: 
        
               if refWorksheet.acell("B3").value == '': 
        
                   female = 0 
        
               else: 
        
                   female = refWorksheet.acell("B3").value 
        
               if refWorksheet.acell("C3").value == '': 
        
                   male = 0 
        
               else: 
        
                   male = refWorksheet.acell("C3").value 
        
               if refWorksheet.acell("D3").value == '': 
        
                   total = 0 
        
               else: 
        
                   total = refWorksheet.acell("D3").value 
        
               worksheet.update("B2", female, raw=False) 
        
               worksheet.update("C2", male, raw=False) 
        
               worksheet.update("D2", total, raw=False) 
        
               print("Summary sheet updated.")

Separate hospital beds and hotel beds

As data on hospital beds and hotel beds are provided separately, why not show these numbers separately too?

	# Todo: sometimes backdated cases do happen.
	# Need to check one more row (2.A3 and D.A4)
	refWorksheet = sheet.worksheet("D")
	pivotLastDateString = refWorksheet.get("A3").first()
	if lastDateString == pivotLastDateString:
	if refWorksheet.acell("B3").value == '':
	female = 0
	else:
	female = refWorksheet.acell("B3").value

	if refWorksheet.acell("C3").value == '':
	male = 0
	else:
	male = refWorksheet.acell("C3").value

	if refWorksheet.acell("D3").value == '':
	total = 0
	else:
	total = refWorksheet.acell("D3").value

	worksheet.update("B2", female, raw=False)
	worksheet.update("C2", male, raw=False)
	worksheet.update("D2", total, raw=False)
	print("Summary sheet updated.")