About
Basic concepts and guidelines
User Guides
For users
For mappers
Technical
Learn about Dokuwiki
About
Basic concepts and guidelines
User Guides
For users
For mappers
Technical
Learn about Dokuwiki
This is an old revision of the document!
- Importing html data is used the import html function in google sheet
- Organizing data: using some functions like: count if, if, sum, vlookups, …
- Visualization in google studio data: using some types of chart like line chart, geo chart, scorecard, table, bar chart.
1. The part of health information
a. Map of COVID-19 confirmed cases in Vietnam
- Using data: the table of Covid-19 provinces (EN, VI)
- Visualizing in google studio data:
- Data mode: live data (Sometimes need monitoring to repair the workflow if necessary)
- Source: Ministry of Health in Vietnam
b. COVID-19 situation in province
- Using data: the table of Covid-19 provinces (EN, VI)
- Visualizing in google studio data:
- Data mode: live data (Sometimes need monitoring to repair the workflow if necessary)
- Source: Ministry of Health in Vietnam
c. Education video
- Using data: using the data from third party on youtube (EN, VI)
- Visualizing in google studio data: insert the link under representation image
- Data mode: offline data
- Source: online youtube
d. Hotline for COVID-19
- Using data: the table of hotline contacts (EN,VI)
- Visualizing in google studio data:
- Data mode: offline data
- Source: ODV collected on media
e. List of designated centers for quarantine and treatment facilities for COVID-19
- Using data: data stored on on CKAN of ODV (EN, VI)
- Visualizing in google studio data: insert the data link stored on CKAN of ODV under the text string
- Data mode: offline data
- Source: ODV collected on media
2. Social security resources
a. Government support packages
- Using data: data stored on CKAND of ODV including 2 items: for citizens (EN,VI) and for the business and enterprise (from the government newspaper)
- Visualization: insert the data link stored on CKAN of ODV under the text string
- Data mode: offline data
- Source: ODV collected on media
b. Initiatives by community
- Using data: data stored on CKAND of ODV including 2 items: Rice ATM & Zero VND supermarket (EN, VI) and Face mask ATM (from the Thanh Nien newspaper)
- Visualization: insert the data link stored on CKAN of ODV under the text string
- Data mode: offline data
- Source: ODV collected on media
c. Confirmed cases by gender and age group
- Using data: the table of patient information (EN, VI)
- Visualizing in google studio data:
- Data mode: need to update in the table of patient information about gender in google sheet
- Source: Ministry of Health in Vietnam
3. Other resources
a. Covid-19 dataset
- Using data: the profile about Covid-19 in Vietnam in ODV page (EN, VI)
- Visualizing in google studio data: insert the data link stored on CKAN of ODV under the text string
- Data mode: offline data
- Source: ODV collected on media
b. Policy timeline to covid-19
- Using data: data stored on the ODV page (EN, VI)
- Visualizing in google studio data: insert the data link stored on CKAN of ODV under the text string
- Data mode: offline data
- Source: ODV collected on media
c. Covid-19 regulation dataset
- Using data: data stored on the CKAN of ODV page (EN, VI)
- Visualizing in google studio data: insert the data link stored on CKAN of ODV under the text string
- Data mode: offline data
- Source: ODV collected on media
4. Confirmed case summary
a. The score
- Using data: the table of patient information
- Visualizing in google studio data: using scorecard and metric corresponding to every column content in google sheet.
- Data mode: live data (Sometimes need monitoring to repair the workflow if necessary)
- Source: Ministry of Health in Vietnam
b. Timelines covid-19 cases in Vietnam
- Using data: Asia map covid (EN, VI)
- Visualizing in google studio data: using chart line
- Data mode: offline data is updated every 14 days.
- Source: OWID
c. Map of total COVID-19 cases in countries of ASEAN and China
- Using data: Asia map covid
- Visualizing in google studio data: using geo chart
- Data mode: live data (Sometimes need monitoring to repair the workflow if necessary)
- Source: ODV collected from MOH in Vietnam, ODC, Ministry of Health in Thailand, worldometers page, outbreak page.