owid-covid

Data license: ODbL · Data source: our world in data github owid/covid-19-data repository

Custom SQL query returning 33 rows (hide)

select rowid, date, World, Afghanistan, Albania, Algeria, Andorra, Angola, Anguilla, [Antigua and Barbuda], Argentina, Armenia, Aruba, Australia, Austria, Azerbaijan, Bahamas, Bahrain, Bangladesh, Barbados, Belarus, Belgium, Belize, Benin, Bermuda, Bhutan, Bolivia, [Bonaire Sint Eustatius and Saba], [Bosnia and Herzegovina], Botswana, Brazil, [British Virgin Islands], Brunei, Bulgaria, [Burkina Faso], Burundi, Cambodia, Cameroon, Canada, [Cape Verde], [Cayman Islands], [Central African Republic], Chad, Chile, China, Colombia, Comoros, Congo, [Costa Rica], [Cote d'Ivoire], Croatia, Cuba, Curacao, Cyprus, [Czech Republic], [Democratic Republic of Congo], Denmark, Djibouti, Dominica, [Dominican Republic], Ecuador, Egypt, [El Salvador], [Equatorial Guinea], Eritrea, Estonia, Ethiopia, [Faeroe Islands], [Falkland Islands], Fiji, Finland, France, [French Polynesia], Gabon, Gambia, Georgia, Germany, Ghana, Gibraltar, Greece, Greenland, Grenada, Guam, Guatemala, Guernsey, Guinea, [Guinea-Bissau], Guyana, Haiti, Honduras, Hungary, Iceland, India, Indonesia, International, Iran, Iraq, Ireland, [Isle of Man], Israel, Italy, Jamaica, Japan, Jersey, Jordan, Kazakhstan, Kenya, Kosovo, Kuwait, Kyrgyzstan, Laos, Latvia, Lebanon, Lesotho, Liberia, Libya, Liechtenstein, Lithuania, Luxembourg, Macedonia, Madagascar, Malawi, Malaysia, Maldives, Mali, Malta, [Marshall Islands], Mauritania, Mauritius, Mexico, Moldova, Monaco, Mongolia, Montenegro, Montserrat, Morocco, Mozambique, Myanmar, Namibia, Nepal, Netherlands, [New Caledonia], [New Zealand], Nicaragua, Niger, Nigeria, [Northern Mariana Islands], Norway, Oman, Pakistan, Palestine, Panama, [Papua New Guinea], Paraguay, Peru, Philippines, Poland, Portugal, [Puerto Rico], Qatar, Romania, Russia, Rwanda, [Saint Kitts and Nevis], [Saint Lucia], [Saint Vincent and the Grenadines], [San Marino], [Sao Tome and Principe], [Saudi Arabia], Senegal, Serbia, Seychelles, [Sierra Leone], Singapore, [Sint Maarten (Dutch part)], Slovakia, Slovenia, [Solomon Islands], Somalia, [South Africa], [South Korea], [South Sudan], Spain, [Sri Lanka], Sudan, Suriname, Swaziland, Sweden, Switzerland, Syria, Taiwan, Tajikistan, Tanzania, Thailand, Timor, Togo, [Trinidad and Tobago], Tunisia, Turkey, [Turks and Caicos Islands], Uganda, Ukraine, [United Arab Emirates], [United Kingdom], [United States], [United States Virgin Islands], Uruguay, Uzbekistan, Vatican, Venezuela, Vietnam, [Wallis and Futuna], [Western Sahara], Yemen, Zambia, Zimbabwe from total_deaths where "Taiwan" = :p0 order by rowid limit 101

Query parameters

This data as json, copyable, CSV

rowid	date	World	Albania	Algeria	Argentina	Australia	Austria	Bahrain	Belgium	Brazil	Bulgaria	Burkina Faso	Canada	China	Costa Rica	Cuba	Denmark	Ecuador	Egypt	France	Germany	Greece	Guatemala	Guyana	Hungary	Iceland	India	Indonesia	International	Iran	Iraq	Ireland	Italy	Japan	Lebanon	Luxembourg	Malaysia	Moldova	Morocco	Netherlands	Norway	Pakistan	Panama	Peru	Philippines	Poland	Portugal	San Marino	Slovenia	South Korea	Spain	Sudan	Sweden	Switzerland	Taiwan	Thailand	Turkey	Ukraine	United Kingdom	United States
49	2020-02-17	1775												1771						1														1											1										1
50	2020-02-18	1873												1869						1														1											1										1
51	2020-02-19	2012												2008						1														1											1										1
52	2020-02-20	2128												2120						1									2	2				1											1										1
53	2020-02-21	2247												2238						1									2	2				1											1					1					1
54	2020-02-22	2359												2347						1									2	4				1											1					2					1
55	2020-02-23	2463												2445						1									2	5			2	1											1					5					1
56	2020-02-24	2619												2595						1									3	8			2	1											1					7					1
57	2020-02-25	2698												2665						1									3	12			6	1											1					8					1
58	2020-02-26	2762												2717						1									4	15			11	1											1					11					1
59	2020-02-27	2800												2746						2									4	19			12	3											1					12					1
60	2020-02-28	2857												2790						2									4	26			17	3											1					13					1
61	2020-02-29	2921												2837						2									6	34			21	3											1					16					1
62	2020-03-01	2979				1								2872						2									6	43			29	5											1					17					1	1				1
63	2020-03-02	3046				1								2914						2									6	54			35	6											1			1		22					1	1				2
64	2020-03-03	3118				1								2946						3										66			52	6																28					1					6
65	2020-03-04	3202				1								2983						4										77			80	6														1		32					1					9
66	2020-03-05	3282				2								3014						4										92			107	6														1		35	1				1	1				11
67	2020-03-06	3384				2								3044						7										107	2		148	6														1		42	3			1	1					12
68	2020-03-07	3488				2								3072						9										124			197	6						1					1			1		44	5			1	1	1			1	14
69	2020-03-08	3585			1	3								3099						10										145	2		233	6						1					1			1		50	5			1	1				2	17
70	2020-03-09	3813			1	3								3122					1	19										194	6		366	7						3					1			1		51	5			2	1				2	21
71	2020-03-10	4021				3							1	3139					1	30	2								7	237			464	9						3					1			2		54	28			2	1				3	26
72	2020-03-11	4294			1	3			1				1	3161					1	33	2									291	6		631	12	1					4			1		1			2		60	35			3	1	1			7	28
73	2020-03-12	4627	1			3			4		1		1	3172					1	48	3	1						1		354	8	1	827	15	2				1	5			1		2			3		66	47		8	4	1	1			7	30
74	2020-03-13	4977	1	1	1	3	1		5		1		1	3179					2	61	5	1		1			1			429	8	1	1016	19	2				1	5	1		1		2	1		5		67	84		8	4	1				9	40
75	2020-03-14	5420	1	2	2	3	1		8		1		1	3194				1	2	79	5	1					2	4		514	9	1	1268	21		1			1	5	1		1		6	2		5		72	121		9	7	1	1			10	47
76	2020-03-15	5787	1	2	2	3	1		13		2		1	3203				2	2	91	8	3					2	4		611	9	2	1441	22	3				1	12	1		1		6	3		5		75	136	1	10	11	1	1			29	57
77	2020-03-16	6538	1	4	2	5	1		19		2		1	3216			1	2	2	127	12	4	1	1	1		2	5		724	9	2	1811	24	3	1			1	20	1		1		12	3		7		75	288	1	12	13	1	1			43	69
78	2020-03-17	7144	1	4	2	5	3	1	30		2		4	3225			1	2	2	148	13	4	1	1	1		3	5		853	9	2	2158	28	3	1			1	24	3		1		12	4		9		81	309	1	14	14	1	1			65	85
79	2020-03-18	7955	1	5	2	5	3	1	40	1	2		8	3241			4	2	4	175	13	5	1	1	1		3	5		988	11	2	2505	28	3	1	2		2	43	3		1		14	5	1	11	1	86	491	1	15	19	1	1			82	108
80	2020-03-19	8918	2	6	2	6	4	1	62	4	2	1	9	3249	1	1	4	3	6	244	13	5	1	1	1		3	5		1135	12	2	2978	29	4	2	2	1	2	58	3		1		17	5	2	14	1	91	598	1	21	25	1	1	1	2	116	150
81	2020-03-20	9993	2	7	3	6	6	1	95	6	3	1	10	3253	1	1	6	3	6	372	43	5	1	1	1	1	4	19		1284	12	3	3407	33	4	4	2	1	2	76	6	2	1	2	18	5	3	14	1	100	767	1	28	33	1	1	4	2	162	150