HenryHL/covid19_cases_in_HK_universities

# 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 [e-mail]
- if you want to access to raw dataset
- if you want to access to code

原始信息汇总

数据集概述

数据集名称

• COVID19 CASES IN HONG KONG UNIVERSITIES

数据集内容

• 包含香港各大学的COVID-19病例数据。

数据集组成部分

• Dashboards
  • 香港理工大学
  • 香港大学
  • 香港中文大学
  • 香港浸会大学
  • 香港城市大学

数据集使用背景

• 数据集起源于2022年2月，香港遭受第五波COVID-19疫情严重影响，旨在通过数据可视化帮助公众理解和应对疫情。

技术架构

• 系统架构
  • 轻量级低代码云原生项目，基于Google Cloud Platform和Google Workspace构建。
• 技术组件
  • 数据库：Google Sheets, Google Docs
  • 后端：Google Apps Script, GCP Cloud Functions, GCP API Gateway, GCP IAM
  • 前端：Google Data Studio
  • 语言：Javascript
  • 平台：Node.js, NPM

支持信息来源

• 香港政府
• 香港理工大学
• 香港大学
• 香港中文大学
• 香港浸会大学
• 香港城市大学

贡献与致谢

• 感谢香港各大学的支持和贡献。
• 欢迎更多数据集贡献和改进建议。
• 赞助和数据访问请联系Henry [e-mail]。