region:us
# COVID19 CASES IN HONG KONG UNIVERSITIES
## main part: HK Universities COVID19 Cases 

### 🏠 Dashboards

[The Hong Kong Polytechnic University][l1]

[The University of Hong Kong][l2]

[The Chinese University of Hong Kong][l3]

[The Hong Kong Baptist University][l4]

[The City University of Hong Kong][l5]

### 🏠 Info Square

[Public Information Sharing and Personal Ask&Help Square][l6]


[l1]: https://datastudio.google.com/reporting/6f62f56f-fd34-4e7b-9ce3-8991fd35ae5e/page/IVVmC
[l2]: https://datastudio.google.com/reporting/19380e90-a92c-4e22-bbdf-2b4a56b2630a/page/5jWmC
[l3]: https://datastudio.google.com/reporting/fb0280da-c5c8-4b46-bd29-c80978179536/page/6YXmC
[l4]: https://datastudio.google.com/reporting/7ad2ae5c-b543-4d8e-94df-f5dd0419b147
[l5]: https://datastudio.google.com/reporting/b30e540b-3ef6-430c-9abf-94c89c621ade/page/ThbnC
[l6]: https://docs.google.com/document/d/15zdVq6KPEByHO-xtv6hJh-HQz80t6mUyZ5LMeHjtWOU/edit#heading=h.tv3qxy36yxj8


## usage part: Background Description and Lessons Learned

### 🔔 Storyline Start

Back in the February 2022, the Hong Kong was severely impacted by the 5th wave of Covid-19. Each and every day, newspapers published tsunami like and exponentially increasing everywhere confirmed cases. Every citizen felt enormously scared and deeply concerned about uncertainty in the future. Most of people had to work from home or stay at home for entire day, shops were closed at a large scale and almost no one could be seen on any street. Even worse, people are surrounded by unclear and sometimes self-contradictory messages. 

My friend, Pili reminded me that as a soft developer, why not to do something to make the society better. To visualize the data might be a good option and let people see it and calm down. Moreover, good news were that Hong Kong universities started to collect and publish daily cases. As a consequence, the project was launched immediately and benefited on Cloud Native, lightweight, low code and “more important”, zero cost. 

### 🔔 Storyline Continue

Now in the February 2023, the 5th wave of Covid-19 has already faded away. The city and her citizens become resuscitated and invigorated once more. As the government eased Covid-19 regulations and cancelled isolation orders from 30 January 2023, universities no longer collected and updated the data either. The project have to stop here, although so far thousands of visitors have gotten beneficial and expressed gratitude. 

Through this plight and struggle, everyone has learned more or less. As Alexandre Dumas pointed out, “all human wisdom is contained in these two words – WAIT and HOPE.” No matter what happened and will happen, please always take away this two words from the project. WAIT & HOPE.


## technic part: System Architecture and Main Technic Analysis

The is a light-weight low-code cloud native project, whose components are built on Google Cloud Platform and Google Workspace.

### ⚙️ Spec

- Database: Google Sheets, Google Docs 
- Backend: Google Apps Script, GCP Cloud Functions, GCP API Gateway, GCP IAM
- Frontend: Google Data Studio
- Language: Javascript
- Platform: Node.js, NPM


## supportive part: Public Information Sources
### 🔍 Hong Kong Government Sources
https://www.covidvaccine.gov.hk/pdf/5th_wave_statistics.pdf
https://www.chp.gov.hk/files/pdf/local_situation_covid19_tc.pdf
https://www.covidvaccine.gov.hk/pdf/death_analysis.pdf
https://www.covidvaccine.gov.hk/en/dashboard

### 🔍 The Hong Kong Polytechnic University Sources
https://www.polyu.edu.hk/cpa/notices/index_student.php

### 🔍 The University of Hong Kong Sources
https://covid19.hku.hk/control/latest-campus-related-test-positive-cases/
https://covid19.hku.hk/control/cases-table/
https://covid19.hku.hk/control/latest-close-contact-with-confirmed-cases/

### 🔍 The Chinese University of Hong Kong Sources
https://www.cuhk.edu.hk/english/whats-on/faces/confirmed-covid-19-cases.html

### 🔍 The Hong Kong Baptist University Sources
https://ehsu.hkbu.edu.hk/2019-nCOV/

### 🔍 The City University of Hong Kong Sources
https://auth.cityu.edu.hk


## contributive part: Acknowledgement and Awards
### 🎉 Thanks 
#The Hong Kong Government

#The Hong Kong Polytechnic University

#The University of Hong Kong

#The Chinese University of Hong Kong

#The Hong Kong Baptist University

#The City University of Hong Kong

### 🎉 Awards
Contributors welcome!
- if you possess more datasets
- if you want to improve it

### 🎉 Sponsors
Please contact me! @Henry hengluomail@gmail.com 
- if you want to access to raw dataset
- if you want to access to code

