owid-covid

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

Custom SQL query returning 14 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	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	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	Falkland Islands	Finland	France	Gabon	Gambia	Georgia	Germany	Ghana	Greece	Grenada	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	Lesotho	Liberia	Libya	Liechtenstein	Lithuania	Luxembourg	Macedonia	Madagascar	Malawi	Malaysia	Maldives	Mali	Malta	Mauritania	Mauritius	Mexico	Moldova	Monaco	Montenegro	Montserrat	Morocco	Mozambique	Myanmar	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	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	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	Venezuela	Western Sahara	Yemen	Zambia	Zimbabwe
94	2020-04-02	39495	4	13	52	14			0	29	4	15	142	5	1	3	6	0	0	1546		0	0	8		13		237		1	8	13		6	100		1	0	0	16	67	17		2	1	1	6	5	1	9	39	11	100	0		57	117	40	2	0		5	0		17	3788	1	1	0	859	5	45		3	0	0	0		3	0	14	20	2	47	152	1901	38	83		21	10179	3	28	2	5	2	1	1	0	1		0	8		0		0	8	27	10			43	0		0	0	5	37	4	0	1		37		1	0	1115		1	1		2		29	1	31	1	31		3	47	79	38	185		2	85	24	0		12		16	1	23		4	1	0	14	0	5	78		8455	2	1	0	0	371	353		4		1	11		2	5	10	276			18	8	3009	4988		2	2	3			0
95	2020-04-03	43446	4	14	56	15			0	31	7	17	152	5	1	3	6	0	4	1732		0	0	9		17		293		1	7	15		7	128	1	1	0	0	18	73	19		3	1	1	7	5	1	9	44	11	117	0		60	117	46	2	0		11	0		19	4131	1	1	0	974	5	48		3	0	0	0		3	0	15	25	3	52	151	1876	42	95	1	34	10510	3	30	2	5	3	3	1	0	1		0	12		0		0	9	26	11	0		48	0		0	1	7	50	5	0	2	0	42		1	0	1263	0	1	1	5	2		36	1	29	1	36	0	3	53	89	52	206		3	94	30	0		16		21	1	31		5	2	0	15	0	5	74		9236	3	1	0	0	434	399		4		1	14		2	6	13	352			20	8	3620	5903		4	2	3			1	1
96	2020-04-04	48845	4	15	95	16	2		0	34	7	23	162	4	3	3	6	0	4	1933		0	0	10		18		348		1	11	15		8	175	1	0	0	0	22	71	25		3	0	1	8	5	1	9	53	13	130	0		66	138	45	3	0	0	12	0		20	6057	0	1	0	1113	5	51		4	0	2	0		3	0	15	28	3	64	156	1727	40	117	1	38	10649	3	34	2	5	3	4	1	0	1		1	12		0		0	8	26	12	0		51	0		0	1	7	58	7	0	2	0	41		1	0	1381	0	1	1	5	2		37	1	28	1	40	0	2	58	118	66	240		3	133	34	0		18		21	1	38		5	2	0	19	0	7	74		9933	4	1	1	0	505	441		3		1	18	0	3	6	12	416		0	24	9	4324	6897		4	2	3			1	1
102	2020-04-10	73794	14	17	210	22	2	0	2	67	10	39	243	6	8	1	16	3	16	3125	1	1	4	19		33		864	0	1	21	21		9	470	0	0	0	0	53	44	63		5	1	3	18	13	0	7	103	16	196	1	0	108	238	97	6	0	0	23	2		38	10514	0	0	3	2120	3	60	0	3	2	5	0	0	5	2	22	67	4	182	202	1876	33	244	1	78	10116	3	42	2	7	9	6	6	1	5	0	2	13		4	1	1	11	43	29	0		44	0	7	1	1	5	186	28	0	1	0	87	0	3	0	1962	0	2	1	10	6		74	3	57	0	57	0	3	129	158	158	349	33	6	212	74	0	0	13		41	2	63		4	8	2	38	1	16	69		11149	7	1	1	0	931	595	2	3		1	28	0	3	7	20	833	1	0	52	12	8807	15394	1	7	3	8			1	2
105	2020-04-13	81896	14	13	262	23	0	0	2	75	11	45	264	7	8	2	29	4	26	3559	2	1	4	24		32		1087	0	0	21	18		10	656	0	0	0	0	73	39	99		5	1	4	17	15	0	5	122	12	201	2	0	134	275	123	6	0	0	22	3		45	11787	0	0	3	2344	3	60	0	4	4	6	0	0	5	3	22	94	6	279	259	1834	34	288	2	88	9120	3	48	2	6	9	7	6	1	5	0	5	10		5	1	1	17	45	28	0		42	0	9	3	1	6	276	30	1	2	0	92	0	4	0	1966	0	4	0	11	9	2	81	4	80	1	63	0	3	175	226	210	385	39	6	266	122	0	0	11		51	2	67		5	9	2	42	2	23	59		10444	6	1	1	0	1115	601	1	1		2	33	0	2	5	23	1067	1	0	74	19	10637	19599	1	7	3	8			2	2
106	2020-04-14	83293	17	11	278	21	0	0	2	74	13	42	260	8	8	3	34	4	29	3666	2	1	4	22		30	1	1169	0	0	24	16	0	10	691	0	0	0	0	74	36	98		5	1	5	19	17	0	5	119	12	208	2	0	135	293	124	6	0	0	25	3		46	11943	0	0	3	2386	3	56	0	4	4	6	0	0	5	3	19	106	6	307	277	1828	32	311	2	99	8874	3	53	2	2	13	8	7	2	5	0	5	9		6	1	1	17	45	31	0		40	0	10	3	1	6	304	34	1	2	0	93	0	4	0	1959	0	8	0	10	8	2	88	4	78	1	68	0	4	169	227	214	395	39	6	274	138	0	0	11		57	2	69	0	6	9	2	44	2	24	59		10149	6	2	1	0	1154	563	0	1		2	31	0	2	5	26	1128	1	0	82	20	10987	20479	1	7	2	6			2	2
107	2020-04-15	86235	19	9	281	19	0	0	2	81	14	41	256	8	8	3	41	5	33	3719	2	1	5	21	0	27	1	1331	0	0	27	18	1	11	807	0	0	0	0	80	36	111		3	1	5	25	15	0	4	130	13	209	2	0	132	276	137	5	0	0	27	3		47	12206	0	0	3	2522	3	52	0	2	4	7	0	0	4	3	21	114	6	342	323	1785	28	335	2	103	8639	4	63	2	2	13	8	7	3	5	0	5	9		6	1	1	17	44	35	0		39	0	12	3	1	6	377	36	1	3	0	90	0	3	0	1906	0	8	0	11	9	2	99	3	81	1	65	0	5	200	247	230	407	37	5	275	153	0	0	10		63	2	71	0	7	9	2	43	2	22	62		10087	5	3	1	0	1198	527	0	1		2	33	0	2	5	25	1189	1	0	85	22	11660	21978	1	7	2	6			2	2
150	2020-05-28	58076	97	2	101	2	2	0	0	171	64	4	21	19	0	5	275	0	68	456	0	1	1	138	0	30	0	12449	0	1	37	2	0	41	1461	2	0	1	22	495	1	294	1	8	3	7	7	3	0	0	27	18	31	15	0	65	941	260	19	6	0	2	1	0	29	1522	5	0	1	688	10	18	0	0	39	0	7	4	1	16	71	73	0	1982	445	781	60	134	1	17	1966	0	171	2	0	5	15	1	93	4	0	4	0	0	7	1	0	12	7	24	2	1	4	1	26	0	14	0	4377	89	0	0	0	14	1	0	4	309	0	1	27	15	90	0	6	21	490	1	59	0	0	1814	132	167	181	14	16	203	1756	0	0	1	5	152	17	18	24	2	0	1	4	15	333	9	8	-202	1	94	0	0	674	84	1	0	23	0	1	0	2	0	3	479	0	0	219	49	3974	16309	0	3	3	1	0	41	0	0
151	2020-05-29	57462	99	2	101	2	2	0	0	155	68	4	42	21	0	5	276	0	68	439	0	1	0	141	0	29	0	12761	0	1	37	2	0	38	1405	2	0	1	19	532	1	297	1	4	2	8	8	3	0	0	26	19	30	17	0	63	975	274	16	5	0	1	2	0	26	1237	4	0	0	626	10	19	0	0	51	0	8	4	1	15	63	75	0	2057	453	773	64	133	1	19	1774	0	164	2	0	5	16	1	97	2	0	5	0	0	7	2	0	14	7	27	2	1	3	1	26	1	14	0	4567	88	0	0	0	12	2	0	5	313	0	1	27	14	92	0	4	21	514	1	60	0	0	1832	131	155	185	14	19	183	1837	0	0	1	5	158	18	17	19	2	0	1	5	19	339	9	7	-338	1	104	0	0	668	66	1	0	18	0	1	0	2	0	3	454	0	0	213	50	3965	15711	0	3	3	1	0	44	0	0
152	2020-05-30	57057	78	2	102	2	2	0	0	164	72	4	40	22	0	3	284	0	68	410	0	1	0	136	0	25	0	13061	0	1	37	2	0	37	1417	2	0	1	17	550	1	307	1	4	2	8	8	3	0	0	24	9	30	16	0	64	740	287	18	5	0	0	3	0	21	1159	5	0	0	608	6	15	0	0	60	0	7	5	1	15	65	69	0	2219	444	775	68	127	0	18	1619	0	161	2	0	3	17	1	98	2	0	5	0	0	7	2	0	14	6	29	5	1	3	1	27	1	17	0	4648	91	0	0	0	12	2	0	6	288	0	1	27	13	90	0	4	21	561	1	60	0	0	1837	136	144	193	10	22	184	1956	0	0	1	5	166	16	17	18	2	0	1	5	19	364	7	6	-438	1	142	0	0	651	62	1	0	14	0	1	0	2	0	3	434	0	0	203	50	3889	15268	0	3	3	4	1	51	0	0
153	2020-05-31	56845	81	2	104	0	2	0	0	165	71	4	40	25	0	5	296	0	69	403	0	1	0	145	0	23	0	13201	0	1	32	2	0	51	1394	1	0	1	15	576	0	328	1	4	0	8	8	4	0	0	23	9	28	18	0	74	646	301	20	5	0	0	3	0	19	1128	6	0	0	586	6	13	0	0	69	0	7	5	2	21	63	73	0	2292	484	797	74	117	0	16	1577	0	147	2	0	4	13	1	98	2	0	5	0	0	7	2	0	15	6	33	6	1	2	1	28	3	18	0	4734	84	0	0	0	12	2	0	5	281	0	1	27	13	97	0	4	21	610	1	61	0	0	1848	133	146	193	11	21	172	2018	1	0	1	5	178	17	14	17	1	0	0	5	18	382	8	6	-523	1	171	0	0	642	55	1	0	11	0	1	0	2	0	3	419	0	0	199	48	3632	15027	0	3	3	4	1	58	0	0
154	2020-06-01	56861	88	2	105	0	2	0	0	173	78	4	39	24	0	7	322	0	70	394	0	1	0	144	0	20	0	13196	0	1	30	2	0	51	1513	1	0	2	12	604	0	365	1	5	0	6	8	4	0	0	23	11	27	20	0	74	622	329	16	5	0	0	6	0	22	1091	6	0	0	576	7	12	0	0	73	0	7	4	2	24	70	64	0	2365	465	809	82	107	0	13	1507	0	143	2	0	7	14	1	100	2	0	5	1	0	6	2	0	14	3	32	5	1	2	1	25	3	19	0	4753	84	0	0	0	13	2	0	6	276	0	1	27	10	105	0	4	25	640	1	61	0	0	1858	133	139	192	13	23	165	2062	1	0	1	5	191	16	13	14	1	0	0	4	22	419	8	6	-582	1	189	0	0	635	54	1	0	8	0	1	0	2	0	3	400	0	0	194	44	3625	14821	0	2	3	4	1	60	0	0
155	2020-06-02	56708	92	2	106	0	2	0	0	174	94	3	39	28	0	7	323	0	69	378	0	1	0	169	0	21	0	13145	0	1	32	2	0	59	1484	1	0	4	13	635	0	377	1	5	0	5	8	4	0	0	24	11	28	17	0	68	595	360	16	5	0	0	7	0	20	936	6	0	0	515	7	14	0	0	78	0	7	4	2	24	71	65	0	2435	450	821	88	103	0	15	1468	0	131	2	0	6	19	1	102	3	0	5	1	0	5	2	0	11	3	36	5	1	2	2	26	3	19	0	4835	92	0	0	0	13	2	0	6	268	0	1	27	10	108	0	3	24	682	1	65	0	0	1845	129	138	193	12	25	172	2133	1	0	1	5	205	16	13	13	2	0	0	4	22	419	9	6	-651	2	193	0	1	615	54	2	0	6	0	1	0	1	0	2	392	0	0	183	42	3565	14794	0	3	2	7	1	64	0	0
156	2020-06-03	56068	92	2	106	0	2	0	0	176	103	3	37	30	0	7	339	0	68	368	0	1	0	187	0	23	0	13228	0	1	28	1	0	60	1483	2	0	4	10	679	0	396	1	5	0	5	7	4	0	0	21	11	29	18	0	74	599	393	18	5	0	0	9	0	19	918	8	0	1	461	7	14	0	0	80	0	5	2	2	26	78	64	0	2512	442	823	104	97	0	13	1361	0	129	2	0	9	21	1	105	6	0	3	1	0	5	2	0	11	1	35	4	1	1	3	25	3	27	0	4971	86	0	0	0	13	2	0	6	252	0	1	38	10	122	0	4	32	703	1	71	0	0	1720	129	144	189	14	28	153	2200	2	0	1	4	220	13	11	13	2	0	0	4	20	443	10	4	-760	2	202	0	1	610	43	3	0	6	0	2	0	1	0	1	386	0	0	179	42	3314	14260	0	3	2	8	1	59	0	0