owid-covid

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

Custom SQL query returning 9 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 biweekly_deaths where "United States Virgin Islands" = :p0 order by rowid limit 101

Query parameters

This data as json, copyable, CSV

rowid	date	World	Afghanistan	Albania	Algeria	Andorra	Angola	Antigua and Barbuda	Argentina	Armenia	Aruba	Australia	Austria	Azerbaijan	Bahamas	Bahrain	Bangladesh	Barbados	Belarus	Belgium	Belize	Benin	Bermuda	Bolivia	Bonaire Sint Eustatius and Saba	Bosnia and Herzegovina	Botswana	Brazil	British Virgin Islands	Bulgaria	Burkina Faso	Burundi	Cameroon	Canada	Cape Verde	Central African Republic	Chad	Chile	China	Colombia	Comoros	Congo	Costa Rica	Cote d'Ivoire	Croatia	Cuba	Cyprus	Czech Republic	Democratic Republic of Congo	Denmark	Djibouti	Dominican Republic	Ecuador	Egypt	El Salvador	Equatorial Guinea	Estonia	Ethiopia	Finland	France	French Polynesia	Gabon	Gambia	Georgia	Germany	Ghana	Greece	Guam	Guatemala	Guernsey	Guinea	Guinea-Bissau	Guyana	Haiti	Honduras	Hungary	Iceland	India	Indonesia	Iran	Iraq	Ireland	Isle of Man	Israel	Italy	Jamaica	Japan	Jersey	Jordan	Kazakhstan	Kenya	Kosovo	Kuwait	Kyrgyzstan	Latvia	Lebanon	Lesotho	Liberia	Libya	Lithuania	Luxembourg	Macedonia	Madagascar	Malawi	Malaysia	Maldives	Mali	Malta	Mauritania	Mauritius	Mexico	Moldova	Monaco	Montenegro	Montserrat	Morocco	Mozambique	Myanmar	Namibia	Nepal	Netherlands	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	San Marino	Sao Tome and Principe	Saudi Arabia	Senegal	Serbia	Sierra Leone	Singapore	Sint Maarten (Dutch part)	Slovakia	Slovenia	Somalia	South Africa	South Korea	South Sudan	Spain	Sri Lanka	Sudan	Suriname	Swaziland	Sweden	Switzerland	Syria	Taiwan	Tajikistan	Tanzania	Thailand	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	Venezuela	Vietnam	Western Sahara	Yemen	Zambia	Zimbabwe
111	2020-04-19	96964	25	7	237	18	0	2	89	13	2	35	257	13	5	3	76	5	40	3701	2	1	5	22	0	24	0	1915	0	24	20	1	12	1236	0	0	0	99	1303	134		1	2	6	27	26	3	122	7	185	2	140	284	158	4	0	25	3	65	11763	0	0	0	4	2952	4	37	1	5	7	3	0	3	3	24	155	5	430	344	1579	25	434	5	118	7865	2	91	9	2	14	8	11	5	4	4	4		6	0	24	41	32	0	2	31	0	10	3	0	2	571	48	1	3	0	78	0	4	0	0	1950	11	0	14	15	1	98	4	124	1	74	0	5	275	253	268	421	42	5	276	270	0	7		63	1	73	0	5	7	11	48	7	43	51	0	8709	2	8	0	1	1320	570	0	1		4	24	2	2	19	1389	1	0	101	27	12773	30409	3	4	3	4	0			1	2
120	2020-04-28	92755	36	5	119	11	0	1	99	14	2	23	181	10	3	1	113	2	46	2722	0	0	2	25	0	22	0	3215	1	26	14	1	46	1927	0	0	0	116	1292	141		3	3	8	34	35	3	80	10	142	0	101	308	173	2	1	22	0	134	8326	0	2	0	3	2944	3	37	0	10	7	7	1	2	3	35	169	2	595	366	1221	10	737	16	86	6512	3	267	15	0	11	5	13	20	3	8	4		10	1	17	21	27	0	1	22	0	13	1	0	1	1102	66	0	4	1	36	0	1	0	0	1695	10	2	16	30	0	79	6	205	0	73	0	2	589	196	317	413	39	3	313	647	0	5	0	79	7	77	4	5	4	16	28	24	63	22	0	6333	0	18	0	1	1194	494	1	0		7	13	3	0	5	1604	0	0	127	57	11274	32596	3	7	4	1	0		0	1	1
121	2020-04-29	91702	37	6	112	10	0	1	102	13	2	27	185	9	3	1	109	1	46	2571	0	0	1	27	0	23	0	3485	1	23	12	0	42	1956	0	0	2	115	1291	142		3	3	8	32	37	3	66	9	135	0	103	516	181	3	1	19	0	135	7931	0	2	0	3	2861	8	35	0	11	6	7	1	2	3	35	166	2	630	314	1194	10	753	19	85	6290	2	270	16	1	11	5	13	20	3	8	3		10	1	20	22	27	0	1	18	0	11	1	0	1	1163	67	0	3	1	39	0	1	0	0	1621	10	2	17	33	0	68	6	220	0	81	0	1	624	195	333	406	41	3	306	697	0	5	0	79	7	74	4	4	4	18	30	26	66	21	0	5999	0	20	0	1	1185	479	1	0		7	11	3	0	6	1589	0	0	141	61	11167	32298	3	7	4	1	0		0	1	1
122	2020-04-30	87773	35	6	108	9	0	1	105	14	1	27	187	10	3	1	113	2	48	2398	0	1	1	30	0	24	0	3730	1	28	11	0	44	1986	0	0	2	122	1291	147		4	2	8	33	34	3	61	9	134	0	104	495	197	3	1	15	0	134	6920	0	2	0	3	2719	8	37	0	11	6	6	1	2	3	36	170	2	660	315	1180	13	746	19	85	6035	2	279	15	1	9	5	12	21	3	10	3		10	1	16	20	28	0	1	17	0	12	1	0	1	1283	65	0	3	1	41	0	2	0	0	1577	10	3	18	39	0	72	6	222	0	75	0	1	689	209	338	390	35	3	303	774	0	5	0	78	7	74	4	4	4	16	28	23	69	18	0	5650	0	23	0	1	1153	434	1	0		12	8	4	0	5	1563	0	0	142	65	11056	29981	3	6	5	1	0		0	1	1
123	2020-05-01	84896	35	5	102	9	0	1	103	14	1	29	174	9	2	1	108	2	49	2239	0	1	1	31	0	27	0	3977	1	28	11	0	40	1991	0	0	5	122	1	149		4	2	8	34	34	3	67	8	131	0	105	497	196	4	1	16	0	136	6456	0	2	0	3	2613	9	35	0	9	4	6	1	3	5	34	167	2	710	296	1159	13	746	17	80	5795	3	284	13	1	8	6	13	23	3	10	3		10	2	13	21	31	0	1	18	1	13	1	0	1	1373	65	0	3	1	40	0	2	0	0	1480	8	3	17	45	0	68	7	250	2	79	0	2	777	206	330	378	36	3	330	841	0	3	1	79	7	76	7	5	4	15	30	23	55	18	0	5346	0	26	0	1	1120	406	1	0		12	7	4	0	3	1531	0	0	145	70	10654	29722	3	8	5	1	0		2	1	1
239	2020-08-25	82033	85	54	134	1	25	0	2445	58	4	204	10	27	25	21	545	0	57	111	8	1	0	866	0	115	1	13557	0	104	1	0	13	96	5	1	0	777	21	4458	0	19	118	9	15	3	2	26	27	3	1	245	390	245	108	0	1	272	2	188	0	2	64	1	76	48	29	2	389	0	4	4	9	13	177	8	0	13133	994	2027	1055	5	0	234	232	2	145	1	3	348	131	139	36	-421	1	46	6	3	79	4	3	36	27	23	0	8	0	1	1	0	7797	95	0	16	0	404	5	0	37	78	45	0	10	0	54	0	8	116	143	37	242	1	137	6537	717	151	42	111	6	580	1387	7	0	0	492	36	55	0	0	0	2	8	0	2538	5	0	343	1	34	30	24	34	9	40	0	5	0	0	2	7	20	281	0	13	342	19	137	13818	3	5	80	114	14	0	37	39	51
263	2020-09-18	77391	26	47	123	0	32	0	3074	38	10	154	23	30	19	26	476	0	75	34	6	0	0	2308	1	105	7	10321	0	96	1	0	2	59	8	0	4	720	8	3047	0	7	206	1	44	9	1	63	9	9	1	221	4381	236	57	0	0	204	4	409	2	0	8	0	56	14	47	18	232	0	3	5	16	10	168	49	0	15900	1472	1882	1057	12	0	184	151	22	152	0	10	115	57	59	40	3	2	84	2	0	155	1	0	69	18	4	0	4	2	3	1	0	5850	134	0	25	0	461	13	54	22	126	31	3	6	0	45	0	2	113	73	89	167	1	211	1741	1097	161	59	140	7	547	1533	5	0	0	417	13	20	1	0	0	2	2	1	1209	46	2	1077	1	13	22	9	22	32	41	0	4	0	0	10	31	49	804	1	27	690	15	178	10836	3	2	81	119	0	0	12	34	18
264	2020-09-19	77720	27	47	120	0	31	0	3023	35	10	100	28	29	23	25	469	0	72	38	5	0	0	2207	1	107	5	10272	0	95	1	0	2	64	9	0	4	705	9	2962	0	7	217	1	49	11	1	66	10	8	1	233	4370	238	56	0	0	192	4	563	2	0	9	0	60	12	48	20	251	0	2	1	18	9	162	54	0	16058	1504	1908	1049	15	0	203	150	25	146	0	13	116	57	60	43	3	1	98	2	0	160	1	0	77	19	4	1	4	2	3	1	0	5952	139	0	27	0	463	14	68	22	119	36	3	6	0	43	0	3	113	75	94	166	1	213	1729	1142	170	61	144	8	548	1546	7	0	0	415	14	18	1	0	1	2	4	1	1179	47	2	1077	1	13	21	9	23	33	41	0	4	0	1	10	29	49	813	0	26	745	16	195	10824	3	1	81	118	0	0	13	37	18
265	2020-09-20	77468	31	46	116	0	29	0	3020	33	9	96	30	29	19	24	466	0	71	45	5	0	0	2188	1	113	5	10329	0	90	1	0	2	68	8	0	4	703	9	2883	0	7	228	1	47	13	1	68	10	8	1	204	4360	239	52	0	0	192	3	576	2	0	9	0	61	14	51	20	260	0	2	1	18	9	160	59	0	16126	1508	1964	1069	15	0	219	158	28	143	0	14	113	52	55	41	3	1	99	2	0	158	1	0	83	20	4	2	4	2	3	1	0	5704	138	0	27	0	466	15	73	24	121	34	1	6	0	41	0	3	113	74	92	172	1	224	1682	1140	169	61	141	7	552	1580	8	0	0	409	15	17	1	0	1	2	3	1	1161	49	1	1077	1	13	20	10	24	33	38	0	3	0	1	9	28	68	825	0	24	705	16	210	10720	3	1	84	119	0	0	14	37	19