This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
internal [2020/11/03 07:39] ngohaily |
internal [2020/11/03 08:22] ngohaily |
||
---|---|---|---|
Line 13: | Line 13: | ||
1. The part of health information | 1. The part of health information | ||
+ | |||
a. Map of COVID-19 confirmed cases in Vietnam | a. Map of COVID-19 confirmed cases in Vietnam | ||
- | - Using data: the table of Covid-19 provinces (EN, VI) | + | |
+ | - Using data: the table of Covid-19 provinces ([[https://docs.google.com/spreadsheets/d/1pusc-AEvXF8qFuAY2kMeWnycfjA2blceOvT4dHEJqtU/edit#gid=384971799|EN]], [[https://docs.google.com/spreadsheets/d/1pusc-AEvXF8qFuAY2kMeWnycfjA2blceOvT4dHEJqtU/edit#gid=0|VI]]) | ||
- Visualizing in google studio data: | - Visualizing in google studio data: | ||
- | o Geodimension: the column of province (using location of city geoname) | + | |
- | o Metric: infected column (beside it, there are some options such as recovered, active, deaths) | + | * Geodimension: the column of province (using location of city geoname) |
+ | * Metric: infected column (beside it, there are some options such as recovered, active, deaths) | ||
+ | | ||
- Data mode: live data (Sometimes need monitoring to repair the workflow if necessary) | - Data mode: live data (Sometimes need monitoring to repair the workflow if necessary) | ||
+ | |||
- Source: Ministry of Health in Vietnam | - Source: Ministry of Health in Vietnam | ||
+ | |||
b. COVID-19 situation in province | b. COVID-19 situation in province | ||
- | - Using data: the table of Covid-19 provinces (EN, VI) | + | |
+ | - Using data: the table of Covid-19 provinces ([[https://docs.google.com/spreadsheets/d/1pusc-AEvXF8qFuAY2kMeWnycfjA2blceOvT4dHEJqtU/edit#gid=384971799|EN]], [[https://docs.google.com/spreadsheets/d/1pusc-AEvXF8qFuAY2kMeWnycfjA2blceOvT4dHEJqtU/edit#gid=0|VI]]) | ||
- Visualizing in google studio data: | - Visualizing in google studio data: | ||
- | i. Dimension: the column of province (data type is string) | + | |
- | ii. Metric: the columns such as infected, recovered, active and deaths | + | * Dimension: the column of province (data type is string) |
+ | * Metric: the columns such as infected, recovered, active and deaths | ||
- Data mode: live data (Sometimes need monitoring to repair the workflow if necessary) | - Data mode: live data (Sometimes need monitoring to repair the workflow if necessary) | ||
+ | |||
- Source: Ministry of Health in Vietnam | - Source: Ministry of Health in Vietnam | ||
+ | |||
c. Education video | c. Education video | ||
- | - Using data: using the data from third party on youtube (EN, VI) | + | |
+ | - Using data: using the data from third party on youtube ([[https://www.youtube.com/watch?v=wGoodWEtV8c|EN]], [[https://www.youtube.com/watch?v=BtulL3oArQw|VI]]) | ||
- Visualizing in google studio data: insert the link under representation image | - Visualizing in google studio data: insert the link under representation image | ||
+ | |||
- Data mode: offline data | - Data mode: offline data | ||
+ | |||
- Source: online youtube | - Source: online youtube | ||
+ | |||
d. Hotline for COVID-19 | d. Hotline for COVID-19 | ||
- | - Using data: the table of hotline contacts (EN, VI) | + | |
+ | - Using data: the table of hotline contacts ([[https://docs.google.com/spreadsheets/d/19bRDMrM74pr_I6mbMxaxVTuQCLicLEYH1WomqqdE7SU/edit#gid=1237989309|EN]],[[https://docs.google.com/spreadsheets/d/19bRDMrM74pr_I6mbMxaxVTuQCLicLEYH1WomqqdE7SU/edit#gid=0 |VI]]) | ||
- Visualizing in google studio data: | - Visualizing in google studio data: | ||
- | i. Dimension: the columns of agency and telephone number | + | |
+ | * Dimension: the columns of agency and telephone number | ||
- Data mode: offline data | - Data mode: offline data | ||
+ | |||
- Source: ODV collected on media | - Source: ODV collected on media | ||
+ | |||
e. List of designated centers for quarantine and treatment facilities for COVID-19 | e. List of designated centers for quarantine and treatment facilities for COVID-19 | ||
- | - Using data: data stored on on CKAN of ODV (EN, VI) | + | |
+ | - Using data: data stored on on CKAN of ODV ([[https://data.vietnam.opendevelopmentmekong.net/dataset/covid-19-quarantine-areas-and-treatment-hospitals-in-vietnam?type=dataset|EN]], [[https://data.vietnam.opendevelopmentmekong.net/vi/dataset/covid-19-quarantine-areas-and-treatment-hospitals-in-vietnam?type=dataset|VI]]) | ||
- Visualizing in google studio data: insert the data link stored on CKAN of ODV under the text string | - Visualizing in google studio data: insert the data link stored on CKAN of ODV under the text string | ||
+ | |||
- Data mode: offline data | - Data mode: offline data | ||
+ | |||
- Source: ODV collected on media | - Source: ODV collected on media | ||
+ | |||
2. Social security resources | 2. Social security resources | ||
+ | |||
a. Government support packages | 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) | + | |
+ | - Using data: data stored on CKAND of ODV including 2 items: for citizens ([[https://data.vietnam.opendevelopmentmekong.net/dataset/social-support-during-the-covid-19-epidemic-season-in-vietnam|EN]],[[ https://data.vietnam.opendevelopmentmekong.net/vi/dataset/social-support-during-the-covid-19-epidemic-season-in-vietnam|VI]]) and for [[http://baochinhphu.vn/Thi-truong/Hang-loat-giai-phap-ho-tro-doanh-nghiep/399631.vgp|the business and enterprise]] (from the government newspaper) | ||
- Visualization: insert the data link stored on CKAN of ODV under the text string | - Visualization: insert the data link stored on CKAN of ODV under the text string | ||
+ | |||
- Data mode: offline data | - Data mode: offline data | ||
+ | |||
- Source: ODV collected on media | - Source: ODV collected on media | ||
+ | |||
b. Initiatives by community | 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) | + | |
+ | - Using data: data stored on CKAND of ODV including 2 items: Rice ATM & Zero VND supermarket ([[https://data.vietnam.opendevelopmentmekong.net/dataset/rice-atm-station-and-zero-supermarket-in-vietnam?type=dataset|EN]],[[https://data.vietnam.opendevelopmentmekong.net/vi/dataset/rice-atm-station-and-zero-supermarket-in-vietnam?type=dataset| VI]]) and [[https://thanhnien.vn/thoi-su/xuat-hien-atm-khau-trang-mien-phi-tai-tphcm-1262012.html|Face mask ATM]] (from the Thanh Nien newspaper) | ||
- Visualization: insert the data link stored on CKAN of ODV under the text string | - Visualization: insert the data link stored on CKAN of ODV under the text string | ||
+ | |||
- Data mode: offline data | - Data mode: offline data | ||
+ | |||
- Source: ODV collected on media | - Source: ODV collected on media | ||
+ | |||
c. Confirmed cases by gender and age group | c. Confirmed cases by gender and age group | ||
- | - Using data: the table of patient information (EN, VI) | + | |
+ | - Using data: the table of patient information ([[https://docs.google.com/spreadsheets/d/1ATzhaSAZ4__D2gflXj388658Rj96po2-AFMpzzKAgdU/edit#gid=1191269394|EN]],[[https://docs.google.com/spreadsheets/d/1ATzhaSAZ4__D2gflXj388658Rj96po2-AFMpzzKAgdU/edit#gid=111873581| VI]]) | ||
- Visualizing in google studio data: | - Visualizing in google studio data: | ||
- | i. Dimension: the column of age | + | |
- | ii. Metric: Male and female columns | + | * Dimension: the column of age |
+ | * Metric: Male and female columns | ||
- Data mode: need to update in the table of patient information about gender in google sheet | - Data mode: need to update in the table of patient information about gender in google sheet | ||
+ | |||
- Source: Ministry of Health in Vietnam | - Source: Ministry of Health in Vietnam | ||
+ | |||
3. Other resources | 3. Other resources | ||
+ | |||
a. Covid-19 dataset | a. Covid-19 dataset | ||
- | - Using data: the profile about Covid-19 in Vietnam in ODV page (EN, VI) | + | |
+ | - Using data: the profile about Covid-19 in Vietnam in ODV page ([[https://data.vietnam.opendevelopmentmekong.net/en/profile/coronavirus-data-in-vietnam|EN]],[[https://data.vietnam.opendevelopmentmekong.net/vi/profile/coronavirus-data-in-vietnam| VI]]) | ||
- Visualizing in google studio data: insert the data link stored on CKAN of ODV under the text string | - Visualizing in google studio data: insert the data link stored on CKAN of ODV under the text string | ||
+ | |||
- Data mode: offline data | - Data mode: offline data | ||
+ | |||
- Source: ODV collected on media | - Source: ODV collected on media | ||
+ | |||
b. Policy timeline to covid-19 | b. Policy timeline to covid-19 | ||
- | - Using data: data stored on the ODV page (EN, VI) | + | |
+ | - Using data: data stored on the ODV page ([[https://vietnam.opendevelopmentmekong.net/stories/timeline-of-covid-19-and-vietnam-policy-actions-at-a-glance/|EN]],[[https://vietnam.opendevelopmentmekong.net/vi/stories/timeline-of-covid-19-and-vietnam-policy-actions-at-a-glance/| VI]]) | ||
- Visualizing in google studio data: insert the data link stored on CKAN of ODV under the text string | - Visualizing in google studio data: insert the data link stored on CKAN of ODV under the text string | ||
+ | |||
- Data mode: offline data | - Data mode: offline data | ||
+ | |||
- Source: ODV collected on media | - Source: ODV collected on media | ||
+ | |||
c. Covid-19 regulation dataset | c. Covid-19 regulation dataset | ||
- | - Using data: data stored on the CKAN of ODV page (EN, VI) | + | |
+ | - Using data: data stored on the CKAN of ODV page ([[https://data.vietnam.opendevelopmentmekong.net/en/dataset/40839211-40dc-4252-9ab4-c39aeff3bae6?type=dataset|EN]],[[https://data.vietnam.opendevelopmentmekong.net/vi/dataset/40839211-40dc-4252-9ab4-c39aeff3bae6?type=dataset| VI]]) | ||
- Visualizing in google studio data: insert the data link stored on CKAN of ODV under the text string | - Visualizing in google studio data: insert the data link stored on CKAN of ODV under the text string | ||
+ | |||
- Data mode: offline data | - Data mode: offline data | ||
+ | |||
- Source: ODV collected on media | - Source: ODV collected on media | ||
+ | |||
4. Confirmed case summary | 4. Confirmed case summary | ||
+ | |||
a. The score | a. The score | ||
- | - Using data: the table of patient information | + | |
+ | - Using data: [[https://docs.google.com/spreadsheets/d/1ATzhaSAZ4__D2gflXj388658Rj96po2-AFMpzzKAgdU/edit#gid=1637285597|the table of patient information]] | ||
- Visualizing in google studio data: using scorecard and metric corresponding to every column content in google sheet. | - 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) | - Data mode: live data (Sometimes need monitoring to repair the workflow if necessary) | ||
+ | |||
- Source: Ministry of Health in Vietnam | - Source: Ministry of Health in Vietnam | ||
+ | |||
b. Timelines covid-19 cases in Vietnam | b. Timelines covid-19 cases in Vietnam | ||
- | - Using data: Asia map covid (EN, VI) | + | |
+ | - Using data: Asia map covid ([[https://docs.google.com/spreadsheets/d/19tOudaR81lpTI4ucvBSu3GcZx95VBHgcVgHBb0QVT48/edit#gid=14755850|EN]],[[https://docs.google.com/spreadsheets/d/19tOudaR81lpTI4ucvBSu3GcZx95VBHgcVgHBb0QVT48/edit#gid=2073666860| VI]]) | ||
- Visualizing in google studio data: using chart line | - Visualizing in google studio data: using chart line | ||
- | i. Dimension: the week column | + | * Dimension: the week column |
- | ii. Metric: the columns such as total cases and death cases | + | * Metric: the columns such as total cases and death cases |
- Data mode: offline data is updated every 14 days. | - Data mode: offline data is updated every 14 days. | ||
+ | |||
- Source: OWID | - Source: OWID | ||
+ | |||
c. Map of total COVID-19 cases in countries of ASEAN and China | c. Map of total COVID-19 cases in countries of ASEAN and China | ||
- | - Using data: Asia map covid | + | |
+ | - Using data: [[https://docs.google.com/spreadsheets/d/19tOudaR81lpTI4ucvBSu3GcZx95VBHgcVgHBb0QVT48/edit#gid=446489772|Asia map covid]] | ||
- Visualizing in google studio data: using geo chart | - Visualizing in google studio data: using geo chart | ||
- | i. GeoDimension: the column of country | + | * GeoDimension: the column of country |
- | ii. Metric: Total cases column and with option death cases column | + | * Metric: Total cases column and with option death cases column |
- Data mode: live data (Sometimes need monitoring to repair the workflow if necessary) | - 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. | - Source: ODV collected from MOH in Vietnam, ODC, Ministry of Health in Thailand, worldometers page, outbreak page. | ||
+ | * **Note: in parallel the Covid-19 data will be downloaded from the google sheet and | ||
+ | uploaded on CKAN every week to archive .** |