Covid-19 Weekly Trends In Oceania - Latest Data

Weekly trends of Covid-19 as on January 13, 2023

@kaggle.anandhuh_covid_weekly_trends_in_oceania

Table List

1 table(9.09 KB)

Covid Oceania Weekly Trend

@kaggle.anandhuh_covid_weekly_trends_in_oceania.covid_oceania_weekly_trend

9.09 KB
14 rows
10 columns

country_other Country/Other	cases_in_the_last_7_days Cases In The Last 7 Days	cases_in_the_preceding_7_days Cases In The Preceding 7 Days	weekly_case_change Weekly Case % Change	cases_in_the_last_7_days_1m_pop Cases In The Last 7 Days/1M Pop	deaths_in_the_last_7_days Deaths In The Last 7 Days	deaths_in_the_preceding_7_days Deaths In The Preceding 7 Days	weekly_death_change Weekly Death % Change	deaths_in_the_last_7_days_1m_pop Deaths In The Last 7 Days/1M Pop	population Population
Australia	46937	74787	-37	1801	388	253	53	15	26068792
Cook Islands	118	408	-71	6716					17571
Fiji	22	21	5	24		2	-100		909466
French Polynesia		47	-100						284164
Micronesia	13	31	-58	111		3	-100		117489
Micronesia	13	31	-58	111		3	-100		117489
New Caledonia	148	158	-6	509					290915
New Zealand	12377	22277	-44	2527	30	54	-44	6	4898203
Niue	90	151	-40	55487					1622
Palau	5	3	67	274					18233


CREATE TABLE covid_oceania_weekly_trend (
  "country_other" VARCHAR,
  "cases_in_the_last_7_days" BIGINT,
  "cases_in_the_preceding_7_days" BIGINT,
  "weekly_case_change" BIGINT,
  "cases_in_the_last_7_days_1m_pop" BIGINT,
  "deaths_in_the_last_7_days" BIGINT,
  "deaths_in_the_preceding_7_days" BIGINT,
  "weekly_death_change" BIGINT,
  "deaths_in_the_last_7_days_1m_pop" BIGINT,
  "population" BIGINT
);