😷 Side project in response to covid-19
- To provide, collect and reflect about
covid-19
in Data Science perspective. - This is a
POC
for learning purpose, not ready for production. Please seeTODO
list below.
-
Go to
Data Studio
select JSON connector 👉 https://datastudio.google.com/data?search=json -
Add data source from 👉 https://covid19.th-stat.com/api/open/timeline
-
Choose metric, dimension
-
Share report 👉 https://datastudio.google.com/s/o8bfzfFBkek
SELECT
*,
ROUND(100 * deaths/confirmed, 2) AS death_percent
FROM
`nl-covid.covid19.trend`
ORDER BY
date DESC
cd firebase/functions
# See : https://cloud.google.com/docs/authentication/getting-started
export GOOGLE_APPLICATION_CREDENTIALS=.credential.json
npm run serve
npm run dev
- Merge data instead of manually delete.
- Present to
Data Studio
. - Auto fetch data with
Cloud Schedule
via Cloud Function. - Made prediction with
BigQuery ML
.