owid-covid

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

Custom SQL query returning 7 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	Angola	Argentina	Armenia	Aruba	Australia	Austria	Azerbaijan	Bahamas	Bahrain	Bangladesh	Belarus	Belgium	Belize	Benin	Bolivia	Bonaire Sint Eustatius and Saba	Bosnia and Herzegovina	Botswana	Brazil	Bulgaria	Burkina Faso	Cameroon	Canada	Cape Verde	Central African Republic	Chad	Chile	China	Colombia	Congo	Costa Rica	Cote d'Ivoire	Croatia	Cuba	Cyprus	Czech Republic	Democratic Republic of Congo	Denmark	Djibouti	Dominican Republic	Ecuador	Egypt	El Salvador	Ethiopia	Fiji	Finland	France	French Polynesia	Gambia	Germany	Ghana	Greece	Guam	Guatemala	Guinea	Guinea-Bissau	Guyana	Haiti	Honduras	Hungary	India	Indonesia	Iran	Iraq	Ireland	Israel	Italy	Jamaica	Japan	Jordan	Kazakhstan	Kenya	Kosovo	Kuwait	Kyrgyzstan	Latvia	Lebanon	Lesotho	Libya	Lithuania	Macedonia	Madagascar	Malawi	Malaysia	Maldives	Mali	Malta	Mauritania	Mexico	Moldova	Montenegro	Morocco	Mozambique	Myanmar	Namibia	Nepal	Netherlands	New Zealand	Nicaragua	Nigeria	Norway	Oman	Pakistan	Palestine	Panama	Papua New Guinea	Paraguay	Peru	Philippines	Poland	Portugal	Puerto Rico	Qatar	Romania	Russia	Rwanda	Saudi Arabia	Senegal	Serbia	Sierra Leone	Sint Maarten (Dutch part)	Slovakia	Slovenia	Somalia	South Africa	South Korea	South Sudan	Spain	Sri Lanka	Sudan	Suriname	Swaziland	Sweden	Switzerland	Syria	Tajikistan	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	Yemen	Zambia	Zimbabwe
254	2020-09-09	78504	21	62	115	18	2777	45	7	245	14	31	23	16	524	69	42	6	1	2433	0	115	6	10884	120	1	4	63	5	1	2	724	21	3928	5	155	5	28	13	0	25	9	5	1	304	4259	262	78	240	1	1	220	0	9	58	13	47	10	260	6	5	17	18	351	12	14441	1372	1766	1061	1	181	118	17	184	5	169	40	80	29	4	2	69	1	111	1	55	28	6	3	1	2	4	2	7034	127	25	472	7	6	34	142	37	2	7	60	0	100	92	65	188	1	232	2122	878	159	41	87	11	600	1425	5	415	18	22	3	2	4	2	2	1778	32	1	657	0	14	30	10	22	12	48	3	7	24	25	619	3	21	661	14	137	11193	4	2	73	101	8	19	14	52
255	2020-09-10	78303	19	59	116	21	2796	44	7	232	14	33	23	17	511	69	40	7	0	2420	0	104	3	10874	116	1	5	61	5	1	2	712	20	3869	5	157	5	31	12	0	26	6	5	1	301	4291	260	83	241	1	2	250	0	6	56	13	45	11	235	6	5	17	14	297	14	14590	1392	1768	1064	4	179	119	19	180	4	170	43	82	31	4	2	73	0	114	1	58	25	3	3	3	2	4	2	7019	129	26	469	7	8	34	137	31	2	7	60	0	105	91	66	184	1	227	2112	849	153	42	96	11	597	1470	6	410	18	21	3	2	4	3	2	1666	33	1	703	0	14	30	9	22	12	45	4	9	24	25	654	2	20	576	15	129	11101	4	2	73	109	5	17	18	43
256	2020-09-11	78113	19	58	116	21	2769	42	8	216	15	32	23	16	507	70	40	7	0	2402	0	98	4	10873	112	1	4	61	5	1	2	709	18	3807	5	170	4	31	14	0	30	7	5	1	296	4278	248	83	229	1	2	237	0	7	54	13	43	12	233	5	5	17	15	246	16	14742	1392	1661	1074	4	193	124	21	174	5	171	45	83	34	6	1	73	0	120	1	50	24	3	3	3	2	4	3	7055	129	25	480	10	8	36	134	31	2	7	64	1	112	87	66	179	1	220	2067	832	149	43	100	10	606	1459	7	404	16	22	2	2	4	3	2	1637	34	1	736	0	10	27	9	23	13	47	4	10	28	26	686	2	20	673	20	131	10965	4	2	75	102	5	18	18	33
257	2020-09-12	78541	18	56	116	24	2865	40	9	214	17	30	25	19	494	71	41	7	0	2404	0	101	4	10892	110	1	4	55	6	1	2	718	15	3751	10	176	4	31	14	0	31	7	5	1	293	4332	245	80	228	0	2	297	2	4	58	15	41	13	220	4	6	17	15	231	17	14922	1375	1664	1067	4	196	125	21	168	6	173	49	87	32	6	1	81	2	126	0	53	22	3	3	3	2	5	3	7037	133	23	472	10	9	33	127	32	2	7	65	1	112	89	74	174	0	216	1999	783	151	40	99	9	593	1451	6	400	14	21	2	2	4	3	3	1635	34	1	736	0	10	27	7	26	15	47	4	10	31	29	706	2	21	638	19	128	11243	4	2	77	110	4	19	23	29
260	2020-09-15	78061	20	54	110	27	2914	40	10	164	24	30	24	23	478	75	37	6	0	2367	1	89	5	10625	101	1	4	53	5	0	4	724	12	3460	10	185	3	41	14	1	41	7	9	1	274	4366	240	68	213	0	4	315	2	7	60	18	44	17	212	4	5	17	18	214	27	15548	1424	1742	1044	7	197	141	23	155	11	150	45	75	32	4	1	79	2	131	1	48	21	3	1	5	2	4	2	6635	135	21	473	12	26	28	132	32	2	7	70	1	105	91	82	171	1	213	1868	1067	164	49	108	10	564	1459	6	408	13	20	2	2	5	3	1	1350	43	2	852	1	13	24	10	25	21	45	4	12	33	40	749	1	23	654	15	136	10932	4	1	78	113	1	17	32	22
261	2020-09-16	78505	30	50	114	26	2980	39	12	159	23	30	23	23	486	75	37	6	0	2346	1	98	5	10523	107	1	1	56	6	0	4	719	12	3236	6	190	3	43	13	1	51	9	8	1	260	4392	239	65	207	0	4	338	2	9	55	18	42	14	206	4	5	17	14	199	38	15733	1460	1781	1043	10	190	142	22	154	11	120	47	68	34	4	1	81	2	141	1	58	19	3	0	4	2	4	2	6437	136	21	464	14	33	25	132	28	3	6	65	1	108	75	81	169	1	204	1859	1066	169	51	116	10	555	1486	6	409	14	20	1	0	5	3	1	1378	41	2	1049	1	13	23	7	23	21	44	4	12	29	46	769	1	26	735	17	160	11248	4	1	79	111	1	13	34	21
262	2020-09-17	77864	27	47	120	30	2939	39	10	161	24	31	22	25	472	76	37	6	0	2275	1	102	5	10326	102	1	1	58	6	0	4	714	9	3130	6	196	3	45	11	1	57	9	7	1	244	4377	235	62	199	0	4	359	2	10	50	18	43	16	219	4	5	17	14	178	44	15822	1484	1835	1047	11	196	148	19	154	11	117	57	65	36	4	1	82	2	144	1	64	19	3	0	4	2	3	1	6162	135	22	470	14	40	26	128	25	3	6	64	1	116	71	92	168	1	208	1792	1109	159	51	127	9	564	1503	5	413	12	20	1	0	5	3	1	1316	43	2	1171	1	13	23	7	23	28	43	4	10	30	48	787	1	28	684	15	170	11058	4	1	82	113	0	13	34	18