COVID-19 Data From John Hopkins University

Updated daily at 6am UTC in both raw and convenient form

@kaggle.antgoldbloom_covid19_data_from_john_hopkins_university

Table List

10 tables(40.66 MB)

Convenient Global Confirmed Cases

Convenient Global Deaths

Convenient Global Metadata

Convenient Us Confirmed Cases

Convenient Us Deaths

Convenient Us Metadata

Raw Global Confirmed Cases

Raw Global Deaths

Raw Us Confirmed Cases

Raw Us Deaths

Convenient Global Deaths

@kaggle.antgoldbloom_covid19_data_from_john_hopkins_university.convenient_global_deaths

391.62 KB
1143 rows
290 columns
Only the first 100 columns are shown

country_region Country/Region	australia Australia	australia_1 Australia.1	australia_2 Australia.2	australia_3 Australia.3	australia_4 Australia.4	australia_5 Australia.5	australia_6 Australia.6	australia_7 Australia.7	canada Canada	canada_1 Canada.1	canada_2 Canada.2	canada_3 Canada.3	canada_4 Canada.4	canada_5 Canada.5	canada_6 Canada.6	canada_7 Canada.7	canada_8 Canada.8	canada_9 Canada.9	canada_10 Canada.10	canada_11 Canada.11	canada_12 Canada.12	canada_13 Canada.13	canada_14 Canada.14	canada_15 Canada.15	china China	china_1 China.1	china_2 China.2	china_3 China.3	china_4 China.4	china_5 China.5	china_6 China.6	china_7 China.7	china_8 China.8	china_9 China.9	china_10 China.10	china_11 China.11	china_12 China.12	china_13 China.13	china_14 China.14	china_15 China.15	china_16 China.16	china_17 China.17	china_18 China.18	china_19 China.19	china_20 China.20	china_21 China.21	china_22 China.22	china_23 China.23	china_24 China.24	china_25 China.25	china_26 China.26	china_27 China.27	china_28 China.28	china_29 China.29	china_30 China.30	china_31 China.31	china_32 China.32	china_33 China.33
Province/State	Australian Capital Territory	New South Wales	Northern Territory	Queensland	South Australia	Tasmania	Victoria	Western Australia	Alberta	British Columbia	Diamond Princess	Grand Princess	Manitoba	New Brunswick	Newfoundland and Labrador	Northwest Territories	Nova Scotia	Nunavut	Ontario	Prince Edward Island	Quebec	Repatriated Travellers	Saskatchewan	Yukon	Anhui	Beijing	Chongqing	Fujian	Gansu	Guangdong	Guangxi	Guizhou	Hainan	Hebei	Heilongjiang	Henan	Hong Kong	Hubei	Hunan	Inner Mongolia	Jiangsu	Jiangxi	Jilin	Liaoning	Macau	Ningxia	Qinghai	Shaanxi	Shandong	Shanghai	Shanxi	Sichuan	Tianjin	Tibet	Unknown	Xinjiang	Yunnan	Zhejiang
1/23/20	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
1/24/20	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	7.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
1/25/20	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	16.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
1/26/20	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	12.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
1/27/20	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	24.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
1/28/20	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	49.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
1/29/20	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0
1/30/20	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	37.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
1/31/20	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	42.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0


CREATE TABLE convenient_global_deaths (
  "country_region" VARCHAR,
  "afghanistan" DOUBLE,
  "albania" DOUBLE,
  "algeria" DOUBLE,
  "andorra" DOUBLE,
  "angola" DOUBLE,
  "antarctica" DOUBLE,
  "antigua_and_barbuda" DOUBLE,
  "argentina" DOUBLE,
  "armenia" DOUBLE,
  "australia" VARCHAR,
  "australia_1" VARCHAR,
  "australia_2" VARCHAR,
  "australia_3" VARCHAR,
  "australia_4" VARCHAR,
  "australia_5" VARCHAR,
  "australia_6" VARCHAR,
  "australia_7" VARCHAR,
  "austria" DOUBLE,
  "azerbaijan" DOUBLE,
  "bahamas" DOUBLE,
  "bahrain" DOUBLE,
  "bangladesh" DOUBLE,
  "barbados" DOUBLE,
  "belarus" DOUBLE,
  "belgium" DOUBLE,
  "belize" DOUBLE,
  "benin" DOUBLE,
  "bhutan" DOUBLE,
  "bolivia" DOUBLE,
  "bosnia_and_herzegovina" DOUBLE,
  "botswana" DOUBLE,
  "brazil" DOUBLE,
  "brunei" DOUBLE,
  "bulgaria" DOUBLE,
  "burkina_faso" DOUBLE,
  "burma" DOUBLE,
  "burundi" DOUBLE,
  "cabo_verde" DOUBLE,
  "cambodia" DOUBLE,
  "cameroon" DOUBLE,
  "canada" VARCHAR,
  "canada_1" VARCHAR,
  "canada_2" VARCHAR,
  "canada_3" VARCHAR,
  "canada_4" VARCHAR,
  "canada_5" VARCHAR,
  "canada_6" VARCHAR,
  "canada_7" VARCHAR,
  "canada_8" VARCHAR,
  "canada_9" VARCHAR,
  "canada_10" VARCHAR,
  "canada_11" VARCHAR,
  "canada_12" VARCHAR,
  "canada_13" VARCHAR,
  "canada_14" VARCHAR,
  "canada_15" VARCHAR,
  "central_african_republic" DOUBLE,
  "chad" DOUBLE,
  "chile" DOUBLE,
  "china" VARCHAR,
  "china_1" VARCHAR,
  "china_2" VARCHAR,
  "china_3" VARCHAR,
  "china_4" VARCHAR,
  "china_5" VARCHAR,
  "china_6" VARCHAR,
  "china_7" VARCHAR,
  "china_8" VARCHAR,
  "china_9" VARCHAR,
  "china_10" VARCHAR,
  "china_11" VARCHAR,
  "china_12" VARCHAR,
  "china_13" VARCHAR,
  "china_14" VARCHAR,
  "china_15" VARCHAR,
  "china_16" VARCHAR,
  "china_17" VARCHAR,
  "china_18" VARCHAR,
  "china_19" VARCHAR,
  "china_20" VARCHAR,
  "china_21" VARCHAR,
  "china_22" VARCHAR,
  "china_23" VARCHAR,
  "china_24" VARCHAR,
  "china_25" VARCHAR,
  "china_26" VARCHAR,
  "china_27" VARCHAR,
  "china_28" VARCHAR,
  "china_29" VARCHAR,
  "china_30" VARCHAR,
  "china_31" VARCHAR,
  "china_32" VARCHAR,
  "china_33" VARCHAR,
  "colombia" DOUBLE,
  "comoros" DOUBLE,
  "congo_brazzaville" DOUBLE,
  "congo_kinshasa" DOUBLE,
  "costa_rica" DOUBLE,
  "cote_d_ivoire" DOUBLE
);