owid-covid

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

Custom SQL query returning 12 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	Anguilla	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	Brunei	Bulgaria	Burkina Faso	Burundi	Cameroon	Canada	Cape Verde	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	Dominican Republic	Ecuador	Egypt	El Salvador	Equatorial Guinea	Estonia	Ethiopia	Falkland Islands	Finland	France	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	Laos	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	Saint Kitts and Nevis	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
97	2020-04-05	53427	5	17	115	17	2		0	39	7	0	27	178	4	4	3	6	0	5	2163		0	0	10		20		414		1	14	13		9	213	1	0	0	27	68	31		5	0	2	12	5	1	9	59	17	148	0	74	165	58	3	0	13	0		24	6998	0	1	0	1275	4	55	3	1	2	0		3	0	22	30	3	73	153	1896	39	134	1	45	10535	3	34	3	5	3	4	1	1	1		1	13	1		1	8	23	17	0		53	0		0	1	6	77	11	0	2	56	0	1	0	1515	1	1	5	4		43	2	32	1	43	2	68	119	74	254		3	141	43		12		29	2	43		4	2	0	21	0	9	79		10418	5	1	1	0	567	484	2	3		1	22	3	6	17	480		29	8	5022	8161		5	2	5			1	1
98	2020-04-06	56507	7	19	135	18	2		0	42	8	0	29	188	6	5	2	6	1	8	2362	1	0	0	11		23		461		1	17	14		9	260	1	0	0	33	61	33		5	0	3	15	7	1	9	66	16	166	0	79	166	61	3	0	15	2		26	7404	0	1	2	1340	4	58	3	2	3	0		3	0	22	31	3	102	150	1918	41	154	1	48	10413	3	32	3	5	5	4	0	1	4		1	14	3		1	12	28	16	0		51	0		0	1	5	92	14	0	2	66	0	1	0	1587	1	1	10	5		51	2	45	1	51	4	78	127	87	281		4	146	45		12		34	2	50		4	4	0	27	0	11	73		10698	5	1	1	0	641	499	2	3		1	25	3	7	16	544		34	8	5585	9176	1	6	2	5			1	1
99	2020-04-07	59998	6	18	156	21	2		0	49	8	0	35	195	6	5	2	9	2	13	2541	1	1	2	14		27		519		1	19	14		9	299	1	0	0	35	54	43		5	0	3	16	8	1	9	77	16	163	0	83	173	64	4	0	19	2		26	8051	0	0	2	1481	3	62	3	2	4	0		4	1	22	39	4	105	160	1927	41	168	1	56	10448	3	38	3	6	6	4	2	1	4	0	1	15	3	1	1	13	33	19	0		48	0		0	1	5	121	18	0	2	76	0	1	0	1654	1	1	10	4		51	2	48	1	49	4	87	130	99	288		4	150	47		12		38	2	57		4	4	2	29	0	12	72		10873	5	1	1	0	720	518	2	3		1	22	3	8	19	612	1	35	9	6076	10399	1	6	2	5			1	0
100	2020-04-08	65259	10	17	174	22	2		0	54	9	0	37	213	7	6	2	13	3	13	2742	1	1	2	15		30		621		1	20	16		8	353	0	0	0	41	52	47		5	0	3	17	10	1	6	85	15	171	0	92	193	66	4	0	21	2		33	9228	0	0	3	1712	3	61	3	2	4	0		4	1	22	48	4	140	166	1938	37	203	1	62	10309	2	38	3	6	6	6	4	1	4	0	2	15	3	1	1	13	36	24	0		48	0	5	0	1	5	136	21	0	2	85	0	1	0	1825	1	1	10	5		59	2	51	1	53	2	100	142	119	312		6	171	58	0	13		40	2	60		4	8	2	33	0	13	74		11102	6	1	1	0	783	555	2	3		1	26	3	8	19	681	1	42	10	7033	12094	1	7	2	7			1	0
101	2020-04-09	69184	13	17	184	23	2	0	0	57	10	0	39	239	6	7	2	15	3	13	2956	1	1	3	18		32		743	0	1	21	20		9	400	0	0	0	45	48	51		5	0	3	18	11	0	6	93	17	184	0	98	213	82	5	0	23	2		37	9538	0	0	3	1909	3	61	3	2	5	0	0	5	1	23	56	4	153	182	1916	40	226	1	66	10164	3	40	3	6	7	6	5	1	4	0	2	15	4	1	1	11	38	28	0		46	0	7	0	1	5	169	26	0	2	87	0	3	0	1892	1	1	10	5		68	2	55	1	57	2	113	144	145	337		6	196	63	0	13		39	2	63		4	8	2	36	0	18	73		11121	7	1	1	0	876	602	2	3		1	28	3	7	18	753	1	48	10	7872	13767	1	7	3	8			1	1
103	2020-04-11	77318	13	14	230	23	2	0	2	65	12	0	41	251	7	8	2	22	4	19	3299	2	1	4	20		33		964	0	1	22	23		9	516	0	0	0	60	44	74		5	1	3	18	13	0	5	110	16	195	1	106	256	111	6	0	23	2		41	11202	0	0	3	2219	3	62	3	2	6	0	0	5	2	23	74	5	220	219	1854	30	265	1	85	9715	3	45	3	7	10	6	6	1	5	0	2	13	4	1	1	12	39	29	0		44	0	7	2	1	7	221	27	1	1	84	0	3	0	1965	4	0	10	6		76	3	62	1	60	3	158	149	165	359	37	6	233	90	0	13		44	2	65		4	9	2	36	1	22	64		10985	7	1	1	0	989	608	2	3		3	30	2	6	19	914	1	64	14	9641	17070	1	7	3	8			2	2
104	2020-04-12	79792	15	13	246	24	2	0	2	70	12	0	43	269	7	8	2	25	4	23	3443	2	1	4	24		32		1010	0	0	21	18		9	593	0	0	0	67	39	94		5	1	4	16	13	0	5	118	14	195	2	107	267	116	6	0	23	3		40	11518	0	0	3	2284	3	61	4	2	6	0	0	5	2	23	86	6	248	225	1840	30	284	1	89	9447	3	46	3	6	10	6	6	1	5	0	3	12	5	1	1	16	44	30	0		46	0	9	2	1	7	257	28	1	1	88	0	3	0	2004	3	0	10	9		78	3	75	1	62	3	165	179	190	370	39	5	253	101	0	13		48	2	64		5	9	2	41	1	23	62		10663	6	1	1	0	1056	596	2	4		2	32	2	6	22	993	1	65	18	10192	18417	1	7	3	8			2	2
138	2020-05-16	67847	100	0	83	6	0	0	0	131	22	1	5	39	11	0	4	128	0	63	963	0	0	3	98	0	58	0	8488	0	0	33	7	0	79	2171	0	0	43	160	0	232	1	5	2	9	20	15	0	2	55	28	76	2	111	1531	186	15	6	11	2	0	75	2961	6	0	4	1306	11	20	0	14	0	8	2	1	12	59	113	0	1534	276	811	23	253	2	41	3374	1	267	3	1	9	24	5	66	6	0	3	2	2	0	0	9	12	16	0	0	9	3	20	2	2	0	2795	75	0	2	19	0	0	0	750	1	4	18	103	0	28	8	417	0	74	1	1269	227	256	183	28	2	312	1249	0	0	6	123	16	40	20	5	2	4	10	25	131	12	4	2463	2	60	0	1	938	160	0	1	33	5	2	2	0	4	797	0	204	99	5961	22500	2	2	2	0	0	13	4	0
139	2020-05-17	67263	96	0	83	7	0	0	0	126	25	1	5	32	11	0	4	139	0	63	918	0	0	2	94	0	58	0	8883	0	0	36	7	0	76	2113	1	0	40	174	1	238	1	5	4	10	18	13	0	2	51	27	70	2	98	1317	197	15	6	10	2	0	77	2883	6	0	4	1265	11	19	0	16	0	9	2	1	12	62	111	0	1571	258	781	26	268	2	39	3053	1	252	3	0	9	28	4	74	4	0	3	1	2	0	0	9	12	16	0	0	10	3	22	2	2	0	2984	83	0	2	19	0	0	1	683	1	4	16	91	0	28	9	433	0	72	1	1323	214	251	180	27	3	310	1315	0	0	6	126	16	39	21	5	2	4	9	24	138	12	4	2386	2	50	0	1	913	135	0	1	36	5	2	2	0	3	760	0	218	95	5788	22369	2	2	2	0	0	17	4	0
140	2020-05-18	66455	84	0	85	6	0	0	0	120	22	1	3	31	14	0	4	151	0	66	855	0	0	2	93	0	56	0	9093	0	0	37	6	0	76	2100	1	0	43	190	1	234	1	5	4	10	16	12	0	2	49	26	66	2	95	1172	201	18	6	8	2	0	68	2816	6	0	3	1243	11	19	0	18	0	9	2	1	12	60	111	0	1656	303	785	26	240	2	40	3024	0	239	3	0	7	26	4	74	4	0	3	1	3	0	0	10	11	17	1	0	8	3	25	2	3	0	3023	86	0	1	18	0	0	2	624	1	3	18	95	0	24	10	441	0	75	1	1362	217	247	155	26	3	317	1351	0	0	6	128	17	37	24	4	2	4	8	24	133	11	4	2281	2	56	0	1	891	130	0	1	37	5	2	2	0	3	743	0	226	94	5602	21880	2	3	2	0	0	18	4	0
141	2020-05-19	65767	83	0	90	6	0	0	0	122	24	1	4	29	14	0	4	167	0	68	797	0	0	2	92	0	55	0	9471	0	0	34	5	0	76	1988	1	0	43	208	1	234	0	5	4	11	15	10	0	2	45	27	58	5	88	1230	209	17	5	8	2	0	60	2696	5	0	3	1176	11	19	0	19	0	7	2	1	10	64	104	0	1595	327	780	29	228	1	37	2928	0	242	3	0	6	26	3	78	3	0	3	1	4	0	0	13	11	19	1	0	8	3	23	2	3	0	3061	83	0	1	13	0	0	2	612	1	3	18	98	0	25	14	453	0	76	1	1445	208	238	168	27	3	304	1366	0	0	4	129	16	34	24	4	2	3	7	22	148	9	4	2165	1	64	0	1	866	126	0	1	38	3	2	3	0	3	710	0	232	87	5476	21419	2	3	3	0	0	18	4	0
149	2020-05-27	57952	93	2	102	3	2	0	0	165	50	0	5	20	19	0	5	272	0	66	488	0	1	1	146	0	33	0	12112	0	0	38	2	0	50	1470	2	1	22	471	1	283	0	8	3	9	10	4	0	1	34	17	35	11	66	876	253	16	8	2	1	0	37	1539	5	0	1	715	12	21	0	36	0	9	3	1	15	67	75	0	1922	411	775	57	127	1	21	2044	0	190	3	0	5	16	1	97	4	0	4	0	6	0	0	15	8	24	2	1	6	2	30	1	8	0	4208	85	0	0	14	1	0	4	346	0	27	16	91	0	7	20	488	1	61	1	1731	135	185	179	15	14	208	1691	0	1	6	147	18	19	24	2	0	1	4	15	318	10	8	14	1	90	0	0	686	87	1	0	23	0	1	2	0	3	503	0	219	50	3999	16529	1	3	4	1	0	38	0	0