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 "Western Sahara" = :p0 order by rowid limit 101

Query parameters

This data as json, copyable, CSV

rowid	date	World	Afghanistan	Albania	Algeria	Andorra	Angola	Argentina	Armenia	Australia	Austria	Azerbaijan	Bahrain	Bangladesh	Belarus	Belgium	Benin	Bolivia	Bosnia and Herzegovina	Brazil	Brunei	Bulgaria	Burkina Faso	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	Ethiopia	Finland	France	Gabon	Georgia	Germany	Ghana	Greece	Guatemala	Guinea	Guinea-Bissau	Guyana	Haiti	Honduras	Hungary	India	Indonesia	Iran	Iraq	Ireland	Israel	Italy	Jamaica	Japan	Jersey	Kazakhstan	Kenya	Kosovo	Kuwait	Kyrgyzstan	Latvia	Lebanon	Liberia	Libya	Lithuania	Luxembourg	Macedonia	Madagascar	Malawi	Malaysia	Maldives	Mali	Malta	Mauritania	Mexico	Moldova	Morocco	Mozambique	Nepal	Netherlands	New Zealand	Nicaragua	Niger	Nigeria	Norway	Oman	Pakistan	Palestine	Panama	Peru	Philippines	Poland	Portugal	Puerto Rico	Qatar	Romania	Russia	Rwanda	San Marino	Sao Tome and Principe	Saudi Arabia	Senegal	Serbia	Sierra Leone	Singapore	Slovakia	Slovenia	Somalia	South Africa	South Korea	South Sudan	Spain	Sri Lanka	Sudan	Suriname	Swaziland	Sweden	Switzerland	Syria	Tajikistan	Thailand	Togo	Tunisia	Turkey	Ukraine	United Arab Emirates	United Kingdom	United States	Uruguay	Uzbekistan	Venezuela	Western Sahara	Yemen	Zambia
152	2020-05-30	57057	78	2	102	2	2	164	72	4	40	22	3	284	68	410	1	136	25	13061	1	37	2	37	1417	2	1	17	550	1	307	1	4	2	8	8	3	0	24	9	30	16	64	740	287	18	5	3	21	1159	5	0	608	6	15	60	7	5	1	15	65	69	2219	444	775	68	127	18	1619	0	161	2	3	17	1	98	2	5	0	7	2	14	6	29	5	1	3	1	27	1	17	4648	91	12	2	6	288	1	27	13	90	4	21	561	1	60	1837	136	144	193	10	22	184	1956	0	1	5	166	16	17	18	2	1	5	19	364	7	6	-438	1	142	0	0	651	62	1	14	1	2	3	434	203	50	3889	15268	3	3	4	1	51	0
153	2020-05-31	56845	81	2	104	0	2	165	71	4	40	25	5	296	69	403	1	145	23	13201	1	32	2	51	1394	1	1	15	576	0	328	1	4	0	8	8	4	0	23	9	28	18	74	646	301	20	5	3	19	1128	6	0	586	6	13	69	7	5	2	21	63	73	2292	484	797	74	117	16	1577	0	147	2	4	13	1	98	2	5	0	7	2	15	6	33	6	1	2	1	28	3	18	4734	84	12	2	5	281	1	27	13	97	4	21	610	1	61	1848	133	146	193	11	21	172	2018	1	1	5	178	17	14	17	1	0	5	18	382	8	6	-523	1	171	0	0	642	55	1	11	1	2	3	419	199	48	3632	15027	3	3	4	1	58	0
154	2020-06-01	56861	88	2	105	0	2	173	78	4	39	24	7	322	70	394	1	144	20	13196	1	30	2	51	1513	1	2	12	604	0	365	1	5	0	6	8	4	0	23	11	27	20	74	622	329	16	5	6	22	1091	6	0	576	7	12	73	7	4	2	24	70	64	2365	465	809	82	107	13	1507	0	143	2	7	14	1	100	2	5	1	6	2	14	3	32	5	1	2	1	25	3	19	4753	84	13	2	6	276	1	27	10	105	4	25	640	1	61	1858	133	139	192	13	23	165	2062	1	1	5	191	16	13	14	1	0	4	22	419	8	6	-582	1	189	0	0	635	54	1	8	1	2	3	400	194	44	3625	14821	2	3	4	1	60	0
155	2020-06-02	56708	92	2	106	0	2	174	94	3	39	28	7	323	69	378	1	169	21	13145	1	32	2	59	1484	1	4	13	635	0	377	1	5	0	5	8	4	0	24	11	28	17	68	595	360	16	5	7	20	936	6	0	515	7	14	78	7	4	2	24	71	65	2435	450	821	88	103	15	1468	0	131	2	6	19	1	102	3	5	1	5	2	11	3	36	5	1	2	2	26	3	19	4835	92	13	2	6	268	1	27	10	108	3	24	682	1	65	1845	129	138	193	12	25	172	2133	1	1	5	205	16	13	13	2	0	4	22	419	9	6	-651	2	193	0	1	615	54	2	6	1	1	2	392	183	42	3565	14794	3	2	7	1	64	0
156	2020-06-03	56068	92	2	106	0	2	176	103	3	37	30	7	339	68	368	1	187	23	13228	1	28	1	60	1483	2	4	10	679	0	396	1	5	0	5	7	4	0	21	11	29	18	74	599	393	18	5	9	19	918	8	1	461	7	14	80	5	2	2	26	78	64	2512	442	823	104	97	13	1361	0	129	2	9	21	1	105	6	3	1	5	2	11	1	35	4	1	1	3	25	3	27	4971	86	13	2	6	252	1	38	10	122	4	32	703	1	71	1720	129	144	189	14	28	153	2200	2	1	4	220	13	11	13	2	0	4	20	443	10	4	-760	2	202	0	1	610	43	3	6	2	1	1	386	179	42	3314	14260	3	2	8	1	59	0
157	2020-06-04	56866	107	2	99	0	1	180	106	2	37	33	8	360	69	358	1	201	21	13689	1	27	1	54	1468	2	4	9	731	0	415	1	5	0	4	7	4	0	20	14	26	17	70	598	408	19	5	12	17	889	8	1	434	7	13	98	5	2	2	28	83	61	2640	456	829	122	88	12	1271	0	126	1	13	24	1	106	6	3	1	5	2	11	1	35	4	1	1	3	23	3	27	5638	82	12	2	7	229	1	38	7	115	3	37	753	1	70	1870	132	153	184	15	29	147	2243	2	1	4	240	15	10	13	2	0	2	18	453	9	4	-807	2	196	0	1	586	30	3	3	2	1	2	387	171	37	3240	13736	3	3	10	1	59	0
158	2020-06-05	56606	107	2	106	0	1	172	109	2	37	34	9	373	68	338	0	200	19	13974	1	22	1	47	1485	2	4	8	767	0	435	1	4	0	6	6	3	0	20	15	21	16	72	547	430	19	2	13	16	850	9	1	439	7	12	110	4	3	2	25	87	63	2765	443	822	131	81	12	1203	1	111	1	17	28	1	107	8	3	2	5	2	10	1	36	5	1	1	3	25	3	34	6035	82	12	2	7	215	1	38	5	112	4	36	771	1	72	1883	138	145	178	14	28	148	2285	2	1	4	260	12	9	12	1	0	2	18	479	9	8	-1494	2	193	0	1	575	22	3	4	2	1	2	381	168	36	3097	13509	3	3	10	1	70	0
159	2020-06-06	56599	104	2	108	0	1	199	113	1	37	36	11	379	69	309	0	197	17	13978	1	34	1	44	1453	2	4	9	818	0	463	1	4	0	7	4	2	0	15	18	25	16	69	478	459	20	2	14	16	822	9	1	430	11	11	165	4	6	2	25	81	60	2922	444	834	138	78	13	1158	1	106	1	17	29	1	106	8	3	2	6	2	10	1	37	5	1	1	3	25	3	38	6181	86	11	2	8	217	1	29	5	112	3	40	834	1	75	1918	130	155	176	15	30	149	2279	2	1	4	278	12	10	9	1	0	2	18	511	7	8	-1543	2	196	0	1	556	22	2	4	2	1	2	372	174	33	3064	13136	3	3	10	1	78	0
160	2020-06-07	56470	111	3	106	0	1	203	119	0	33	35	11	394	69	295	1	214	17	13917	1	34	1	44	1418	2	4	9	868	0	500	1	6	0	6	5	2	1	13	18	26	16	78	512	463	18	0	15	16	810	9	1	421	13	9	175	3	6	2	24	76	56	3062	450	850	166	66	18	1111	1	96	1	18	33	1	106	8	3	3	4	2	8	1	38	6	0	2	3	27	3	37	6332	89	10	2	8	200	1	29	4	121	3	36	869	0	87	1928	131	160	172	15	30	148	2337	2	0	4	297	12	10	9	2	0	2	21	545	7	8	-1616	2	201	0	1	530	19	2	4	2	1	1	361	172	31	2987	12715	1	4	12	1	73	0
161	2020-06-08	58875	139	2	107	0	0	212	124	0	32	39	12	408	70	274	1	215	16	13789	1	30	1	38	1376	2	4	9	1472	0	532	1	6	0	6	5	1	1	12	18	27	18	80	513	473	20	0	22	16	788	9	1	417	12	9	194	3	6	2	24	78	51	3114	479	864	186	73	18	1114	1	86	1	21	33	2	108	7	3	4	4	2	8	0	40	7	0	2	4	27	3	37	6305	91	9	2	10	191	1	29	4	128	3	38	900	0	87	2009	135	161	163	15	31	147	2318	2	0	3	322	14	11	8	2	0	2	22	569	6	8	302	2	213	0	1	519	19	2	4	1	1	1	352	171	31	2662	12794	1	4	12	1	70	0
162	2020-06-09	58721	150	2	106	0	0	226	126	0	31	42	13	429	72	257	1	214	14	13661	1	34	1	37	1290	2	4	9	1503	0	558	1	5	0	8	4	1	1	11	20	30	17	79	439	488	22	0	22	15	777	7	1	409	16	10	208	3	6	1	23	80	49	3299	492	900	207	77	17	1087	1	70	1	23	33	1	104	8	4	4	4	2	8	0	43	7	0	2	4	25	3	37	6420	92	8	1	10	186	1	29	3	128	4	44	975	0	88	1942	138	159	155	13	31	137	2338	2	0	1	347	16	11	7	2	0	2	18	599	5	11	19	1	207	1	1	515	19	2	2	1	0	1	342	174	33	2605	12787	1	5	12	1	67	3
163	2020-06-10	59703	164	1	107	0	0	233	129	0	29	46	15	453	74	245	1	213	10	13894	1	34	0	33	1258	1	4	9	1477	0	596	1	5	1	8	5	1	1	11	22	30	20	76	487	509	24	0	26	12	766	7	1	380	14	10	226	3	6	1	23	83	45	3408	505	917	223	76	18	1088	1	61	1	24	36	1	101	10	4	4	5	2	7	0	41	7	0	2	3	24	3	52	6515	98	8	1	11	175	1	11	2	116	4	46	1030	0	90	1950	131	159	150	13	34	135	2334	2	0	0	372	15	11	6	2	0	2	18	638	7	11	18	1	202	1	1	520	15	2	2	1	0	1	332	166	30	2669	13090	1	4	12	1	78	3
164	2020-06-11	59692	178	1	109	0	0	235	132	0	28	48	17	468	74	233	1	232	10	14082	0	34	0	37	1195	1	5	8	1634	0	630	0	6	2	10	5	1	1	11	27	28	16	76	445	526	25	0	29	11	723	8	1	344	14	10	248	2	5	1	24	96	42	3571	486	942	251	64	18	1042	1	62	1	30	34	1	100	10	3	4	4	1	8	0	45	8	0	3	3	26	3	45	6760	97	8	1	11	171	0	20	1	128	4	46	1096	0	98	1920	123	178	139	14	36	141	2390	2	0	0	394	15	11	5	2	0	2	18	658	7	11	17	1	205	1	1	522	27	2	2	1	0	1	315	175	29	2411	12482	1	5	12	1	76	3
165	2020-06-12	59745	191	2	111	0	1	257	138	0	6	52	19	490	74	214	1	240	8	14165	0	32	0	37	1117	2	6	7	1758	0	611	0	6	2	9	4	2	1	10	28	25	17	76	407	532	29	0	33	12	684	9	1	313	14	8	254	1	5	1	29	98	36	3792	504	957	278	64	16	1025	1	48	1	30	34	1	94	10	2	5	4	0	6	0	47	8	0	3	3	25	2	45	6900	93	9	0	10	141	0	20	1	128	6	49	1146	0	98	2010	115	177	135	13	36	140	2390	2	0	0	416	15	11	5	2	0	1	13	712	8	11	15	1	218	1	1	517	20	2	2	1	0	1	302	185	28	2144	12203	1	5	12	1	79	3