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	Bosnia and Herzegovina	Botswana	Brazil	Bulgaria	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	Estonia	Ethiopia	Fiji	Finland	France	Gambia	Georgia	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
246	2020-09-01	76493	31	54	131	19	2748	55	6	231	4	26	25	17	587	68	66	9	1	904	134	3	12845	117	8	94	4	1	1	776	20	4291	2	132	7	20	6	1	25	15	3	1	229	473	248	106	1	265	1	1	206	33	2	66	37	36	5	371	8	1	16	5	290	6	13431	1210	1767	1088	3	247	83	7	182	4	180	95	115	29	-439	2	62	1	80	5	55	21	14	2	5	1	3	2	7391	87	20	460	4	0	39	121	52	0	9	36	3	97	108	52	214	2	181	2463	882	154	43	99	4	592	1436	8	461	28	36	1	0	2	4	4	2167	18	0	482	1	20	23	18	28	10	44	4	1	11	21	374	2	17	441	20	132	13101	6	4	82	93	9	31	24	67
247	2020-09-02	76309	31	58	127	18	2853	49	6	219	5	27	26	15	576	69	58	9	1	929	125	3	12708	110	8	87	4	1	1	775	19	4433	6	129	7	21	7	1	24	16	4	1	249	466	267	98	1	256	1	1	210	33	2	70	28	39	8	359	7	1	16	10	295	7	13444	1228	1700	1087	2	249	86	10	179	4	237	90	117	29	-439	1	66	1	85	5	55	22	12	3	5	1	3	2	7467	100	22	470	4	0	44	125	55	0	8	42	2	92	128	56	209	2	187	2410	910	162	40	89	5	607	1427	6	459	28	34	2	2	2	4	4	1999	20	0	397	1	18	18	18	27	10	48	4	1	15	21	401	2	17	489	18	123	12868	6	4	81	94	9	34	26	62
248	2020-09-03	75875	26	62	123	19	2857	51	7	213	5	28	25	15	570	69	51	8	1	970	120	3	12680	115	8	86	5	1	1	766	21	4369	5	132	6	23	10	0	21	13	5	1	264	473	264	99	1	246	1	1	218	20	2	68	20	38	8	323	6	1	14	10	316	10	13510	1270	1825	1080	2	190	85	13	175	4	237	71	114	28	-439	1	68	1	86	5	54	23	11	3	5	1	4	2	7335	110	24	473	6	0	43	131	54	0	8	42	2	86	119	57	203	2	193	2425	828	165	41	87	6	615	1425	7	450	29	32	2	2	0	3	4	1966	22	0	421	1	15	18	15	28	8	42	4	3	16	21	423	2	17	512	20	117	12567	6	4	79	95	10	32	23	56
249	2020-09-04	75314	25	63	120	20	2749	51	7	215	6	31	27	11	561	69	51	8	1	898	121	3	12310	116	6	87	4	1	1	751	19	4435	5	127	7	26	12	0	20	12	5	1	296	448	267	104	1	236	1	1	206	18	2	62	19	43	7	298	7	1	15	14	335	11	13623	1332	1662	1067	1	190	89	14	175	5	235	69	110	27	-439	1	66	1	85	4	56	20	11	3	5	1	4	2	7223	115	23	478	6	1	45	131	44	0	8	56	0	96	116	58	202	1	203	2371	805	167	41	81	8	611	1429	7	434	26	29	2	2	4	4	4	1945	22	0	580	1	11	18	13	28	12	42	3	4	17	21	453	2	14	526	18	124	12542	6	3	80	91	10	31	18	55
250	2020-09-05	75069	25	66	121	20	2901	49	7	265	5	31	23	15	551	69	50	10	1	977	119	5	12163	119	6	77	4	1	1	771	17	4320	5	129	7	26	11	0	18	11	6	0	268	426	264	98	1	243	1	1	183	15	2	57	22	41	7	293	8	5	14	16	352	10	13767	1332	1668	1076	1	184	91	14	180	5	230	57	103	26	-439	2	67	1	89	3	50	20	10	3	4	1	4	2	7241	118	24	475	6	1	44	134	42	0	8	55	0	96	109	57	204	1	216	2309	748	162	41	81	8	616	1460	7	435	25	29	2	2	4	2	4	1835	22	0	580	1	11	19	13	23	13	44	3	4	19	20	484	3	16	516	17	132	12359	6	3	76	95	10	30	15	54
251	2020-09-06	74751	23	67	125	21	2890	45	7	263	3	30	26	13	540	68	46	9	1	956	119	5	11953	120	6	72	5	1	1	759	17	4188	5	130	6	27	11	0	20	8	6	0	286	447	268	105	1	235	1	2	186	15	2	56	22	40	7	265	8	5	15	16	363	13	13920	1346	1652	1069	0	188	104	16	181	5	230	52	99	27	-440	2	66	1	92	2	50	21	9	3	3	1	4	2	7300	128	23	471	6	2	41	134	41	2	8	57	0	96	107	61	197	1	220	2234	824	162	44	83	9	617	1449	7	430	21	28	2	2	4	3	4	1792	25	1	580	0	11	20	11	22	12	45	4	5	20	19	518	3	20	567	16	126	12176	6	3	76	97	9	26	15	53
252	2020-09-07	80444	25	66	121	21	2959	45	7	251	4	30	29	14	508	69	45	9	1	2499	110	5	11906	126	6	72	5	1	3	740	19	4096	5	123	6	27	10	0	24	9	6	1	278	4214	287	95	1	240	1	2	188	15	2	53	22	42	7	258	8	5	15	18	353	11	14100	1345	1650	1084	0	185	104	17	183	4	229	49	96	29	3	2	70	1	97	2	43	22	9	3	3	2	4	2	7078	123	24	473	7	2	37	140	43	2	8	55	0	119	110	60	194	1	230	2175	877	165	44	87	10	621	1437	7	432	21	26	2	2	4	3	4	1830	27	1	644	0	17	27	9	22	13	49	4	5	20	25	552	3	22	540	13	122	12135	6	3	77	99	8	25	15	52