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 "Jersey" = :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	Bosnia and Herzegovina	Brazil	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	Falkland Islands	Finland	France	Gabon	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	Liberia	Libya	Liechtenstein	Lithuania	Luxembourg	Macedonia	Madagascar	Malawi	Malaysia	Maldives	Mali	Malta	Mauritania	Mauritius	Mexico	Moldova	Monaco	Montenegro	Morocco	Mozambique	Myanmar	Nepal	Netherlands	New Zealand	Nicaragua	Niger	Nigeria	Northern Mariana Islands	Norway	Oman	Pakistan	Palestine	Panama	Paraguay	Peru	Philippines	Poland	Portugal	Puerto Rico	Qatar	Romania	Russia	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	Ukraine	United Arab Emirates	United Kingdom	United States	United States Virgin Islands	Uruguay	Uzbekistan	Venezuela	Western Sahara	Yemen	Zambia	Zimbabwe
108	2020-04-16	91711	21	10	278	19	0	2	78	14	1	42	247	8	7	3	44	5	36	3767	2	1	5	21	27	1495	26	18	1	11	901	0	0	0	78	30	114		3	2	5	28	18	3	127	11	205	2	132	268	137	4	0	30	3		55	13135	0	3	2697	3	52	2	4	7	1	0	2	3	21	121	6	364	312	1741	29	359	2	109	8490	2	79	4	2	14	9	8	3	4	5	9	6	1	1	21	40	35	0	2	38	0	12	3	1	4	412	41	1	3	88	0	3	0	1961	8	0	9	10	1	98	3	93	1	71	5	207	253	243	412	40	5	287	174	10		63	1	76	0	6	8	6	46	5	29	60		9840	5	3	1	0	1260	595	0	1		3	34	1	3	25	1241	1	88	25	11868	25847	1	7	2	6			2	2
137	2020-05-15	68365	72	0	79	7	0	0	135	19	1	6	42	11	0	2	115	0	62	1011	0	0	3	90	55	8092	33	8	0	78	2288	1	0	41	131	0	232	1	6	2	10	25	18	2	57	19	86	1	121	1438	179	13	6	10	2	0	76	3049	7	6	1343	7	16	0	13	0	7	2	1	12	58	119	0	1502	251	826	22	274	2	43	3401	1	278	4	1	7	25	5	62	6	4	2	4	0	0	9	13	18	0	0	10	3	20	2	1	0	2618	75	0	2	20	0	0	0	795	2	4	18	109	0	28	8	418	0	72	1	1216	222	239	177	25	4	329	1232	0	6	121	14	45	19	6	2	4	12	25	135	12	1	2635	2	60	0	1	958	166	0	1	29	5	2	2	0	5	833	0	195	103	6309	22900	2	2	2	0	0	11	4	0
142	2020-05-20	64994	83	0	91	5	0	0	129	27	1	3	26	15	0	4	187	0	68	749	0	0	2	103	55	10050	38	4	0	76	1869	1	0	39	234	1	235	0	5	4	10	13	10	2	45	27	54	5	87	1270	207	17	3	8	1	0	55	2491	6	3	1094	13	19	0	24	0	8	4	0	10	54	97	0	1609	349	779	29	222	1	39	2854	0	228	4	0	6	26	3	81	2	4	1	3	0	0	14	13	20	2	0	8	3	21	1	3	0	3159	85	0	1	12	0	0	2	547	0	3	17	94	0	24	15	459	0	71	1	1470	200	232	173	25	3	299	1386	0	5	129	19	34	22	4	1	3	6	21	164	8	6	2031	0	60	0	1	835	131	0	1	36	3	2	3	0	4	679	0	232	81	5250	20843	2	3	3	0	0	25	3	0
143	2020-05-21	63588	83	0	92	5	1	0	130	28	1	3	25	15	0	4	200	0	67	703	0	0	2	108	51	10323	36	4	0	38	1798	1	0	40	263	1	233	0	5	4	11	11	10	2	42	25	54	6	84	1270	211	17	3	8	1	0	52	2323	4	3	1028	13	19	0	24	0	7	4	0	10	52	90	0	1652	347	765	32	196	1	40	2646	0	226	4	0	5	24	3	82	2	4	1	3	0	0	12	11	22	2	0	7	2	23	1	3	0	3386	85	0	1	11	0	0	2	544	0	3	20	97	0	25	17	453	0	69	1	1491	184	229	174	26	4	283	1435	0	5	130	18	32	20	2	1	3	7	22	186	8	6	1870	0	62	0	0	814	125	0	1	36	3	1	3	0	4	638	0	237	76	4931	20008	2	3	3	0	0	24	3	0
144	2020-05-22	63336	87	0	92	4	1	0	134	31	0	3	24	16	0	4	209	0	69	666	0	1	2	113	49	10901	41	4	0	48	1744	1	0	31	304	1	245	0	6	4	9	11	7	2	36	27	55	7	75	1285	214	18	6	7	1	0	51	2228	4	3	908	13	20	0	25	0	8	4	0	13	51	84	0	1697	348	763	38	180	1	39	2528	0	239	4	0	4	21	2	85	2	4	1	3	0	0	12	9	22	2	0	7	1	28	1	4	0	3549	88	0	1	13	0	0	3	487	0	3	18	104	0	25	17	473	0	66	1	1521	161	217	172	24	5	275	1474	0	4	132	20	31	19	3	1	2	7	17	208	8	6	2377	0	69	0	0	788	120	0	1	32	0	1	3	0	3	608	0	239	72	4746	19032	2	3	3	0	0	27	3	0
145	2020-05-23	62870	96	0	94	4	1	0	140	33	0	4	21	18	0	4	226	0	69	633	0	1	2	124	43	11151	38	4	0	51	1681	1	0	31	336	1	254	0	6	4	9	13	7	2	39	24	49	7	76	1352	204	17	6	7	1	0	46	2059	4	2	847	13	19	0	27	0	8	4	0	13	60	77	0	1739	383	759	43	163	1	34	2415	0	207	4	0	4	21	1	91	2	4	0	4	0	0	12	9	22	2	0	8	1	27	1	4	0	3829	85	0	1	11	0	0	3	429	0	12	16	104	0	22	17	483	0	64	1	1530	161	206	175	19	7	261	1526	0	3	135	19	28	21	3	0	2	6	17	219	10	6	2200	0	78	0	0	784	112	1	1	32	0	1	2	0	2	587	0	227	67	4458	18827	2	2	3	0	0	26	3	0
146	2020-05-24	62380	101	0	98	3	1	0	145	36	0	5	24	18	0	5	238	0	68	587	0	1	2	126	40	11386	36	4	0	51	1662	1	1	29	369	1	260	0	6	4	9	12	7	2	38	22	45	7	73	1379	221	18	8	3	0	0	41	2022	4	2	852	9	20	0	31	0	9	3	0	14	66	73	0	1758	392	770	45	158	1	32	2340	0	207	4	0	4	20	1	99	2	4	0	6	0	0	13	8	22	2	1	7	1	26	1	5	0	3826	81	0	1	12	0	0	3	389	0	12	16	93	0	22	19	494	1	62	1	1559	159	208	176	19	8	244	1561	1	3	140	18	25	21	3	0	2	5	13	221	10	6	2131	0	82	0	0	771	110	1	1	24	0	0	2	0	3	569	0	229	59	4403	18293	2	4	3	0	0	32	0	0
147	2020-05-25	60060	98	1	98	3	2	0	152	41	0	5	22	17	0	6	252	0	68	548	0	1	2	132	36	11543	39	3	0	51	1553	1	1	29	406	1	264	0	6	4	9	9	5	1	35	26	43	7	70	981	239	18	8	3	0	0	40	1987	4	2	840	10	20	0	32	0	9	3	0	12	72	70	0	1815	399	777	51	148	1	28	2225	0	209	4	0	4	19	1	98	4	4	0	6	0	0	13	9	22	2	1	7	1	27	1	5	0	3929	81	0	0	11	0	0	3	382	0	12	15	83	0	18	20	500	1	62	1	1567	149	196	181	16	9	227	1626	1	4	144	16	23	22	3	0	2	4	10	235	11	6	90	0	76	0	0	742	104	1	1	24	0	1	1	0	3	554	0	226	47	4565	18192	2	3	3	0	0	34	0	0
148	2020-05-26	59838	97	1	102	3	2	0	162	44	0	5	21	19	0	6	262	0	69	509	0	1	1	139	33	11954	37	2	0	46	1552	1	1	30	438	1	271	0	6	3	9	9	5	1	35	23	39	11	67	1058	250	18	8	2	0	0	37	1789	5	1	769	10	21	0	33	0	9	3	1	15	66	74	0	1874	400	766	53	139	1	23	2138	0	203	4	0	3	19	2	100	4	4	0	6	0	0	13	9	22	2	1	6	1	28	1	5	0	4060	86	0	0	12	1	0	4	374	0	12	16	83	0	11	20	491	1	61	1	1668	147	196	186	16	12	225	1624	1	6	144	17	21	23	2	0	2	4	14	275	11	8	197	1	91	0	0	719	99	1	0	25	0	1	2	0	3	528	0	215	47	4482	17536	1	3	3	0	0	36	0	0