COVID Trends in the UN's Five Permanent Members (2020-2022)
MAT 259, 2023
Zeyu Wang
Concept
My idea is to create a data visualization of COVID-19 cases and deaths in the past three years for the five permanent members of the United Nations: UK, Russia, France, USA, and China. The visualization aims to compare and contrast the different government strategies implemented in each country and how they have affected the development of the pandemic. I have already completed the data preprocessing and have a clear sketch of how the data will be presented. Initially, my focus will be on creating the visualization, but I may explore the correlation between vaccination rates and COVID-19 deaths if time allows.
Query
<![CDATA[UPDATE matproject3.global_table_data
SET Cases_cumulative_total_per_100000_population = 0.0
where Cases_cumulative_total_per_100000_population = '';
UPDATE matproject3.global_table_data
SET Cases_newly_reported_in_last_7_days_per_100000_population = 0.0
where Cases_newly_reported_in_last_7_days_per_100000_population = '';
UPDATE matproject3.global_table_data
SET Deaths_cumulative_total_per_100000_population = 0.0
where Deaths_cumulative_total_per_100000_population = '';
UPDATE matproject3.global_table_data
SET Deaths_newly_reported_in_last_7_days_per_100000_population = 0.0
where Deaths_newly_reported_in_last_7_days_per_100000_population = '';
UPDATE global_data
SET Date_reported = '1001-01-01'
where Date_reported = '';
-- Finish data prepocessing
select *
from global_data
where Date_reported >= '2020-01-01' AND Date_reported < '2021-01-03' AND Country = 'China';
select *
from global_data
where Date_reported >= '2021-01-03' AND Date_reported < '2022-01-03' AND Country = 'China';
select *
from global_data
where Date_reported >= '2022-01-03' AND Date_reported < '2023-01-03' AND Country = 'China';
-- use new table to do query
select *
from global_data
where Date_reported >= '2020-01-01' AND Date_reported < '2021-01-03' AND Country_code = 'US';
select *
from global_data
where Date_reported >= '2021-01-03' AND Date_reported < '2022-01-03' AND Country_code = 'US';
select *
from global_data
where Date_reported >= '2022-01-03' AND Date_reported < '2023-01-03' AND Country_code = 'US';
select *
from global_data
where Date_reported >= '2020-01-01' AND Date_reported < '2021-01-03' AND Country_code = 'US';
select *
from global_data
where Date_reported >= '2021-01-03' AND Date_reported < '2022-01-03' AND Country_code = 'US';
select *
from global_data
where Date_reported >= '2022-01-03' AND Date_reported < '2023-01-03' AND Country_code = 'USglobal_data';
]]>
Preliminary sketches
Please put your sketches here with some explanations.
Process
Please put your work-in-progress images or screen shots here with some explanations.
Final result
Please put your final images or screen shots here with some explanations.
Code