owid-covid

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

Custom SQL query returning 4 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 new_cases_per_million where "Saint Lucia" = :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	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	Gibraltar	Greece	Greenland	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	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
76	2020-03-15	1.565	0.077	1.7369999999999999	0.251				10.212	0.243	2.362		2.039	16.766	0.5920000000000001		0.588	0.0			15.445				0.0	0.0				0.10800000000000001		6.857	1.439	0.048		0.12	0.038	1.8019999999999998					0.9420000000000001	0.015	0.354			0.196	0.114	1.462	0.0		7.992000000000001	5.976	0.0	3.971			0.0	0.28300000000000003	0.0		0.713		27.138	0.0	0.0			4.873	12.838		0.0		0.0	8.749		3.6460000000000004				0.055999999999999994		0.0					0.621	61.538000000000004	0.005	0.099	16.250999999999998	0.0	7.696000000000001		7.162999999999999	57.838		0.34		0.0	0.32	0.0	1.5519999999999998	0.937			3.7110000000000003	3.9560000000000004				0.0	1.102					1.2670000000000001	0.0		22.648000000000003	0.215		0.38799999999999996	2.975	152.89	0.0			0.298			0.787	0.0	9.046		0.415			0.0		52.755	0.0	0.040999999999999995	0.588	1.6219999999999999			0.152	0.429	0.951	5.59		5.901	1.248	0.096	0.077		10.892000000000001		559.844		0.0	0.11900000000000001	0.735	20.338		2.3930000000000002		2.5639999999999996	19.241			0.0	1.482		45.856	0.23399999999999999	0.0	1.705	0.862	7.03	27.5		0.252			0.0		0.0	0.0	0.0					0.10099999999999999	7.041	2.347		1.7269999999999999			0.35200000000000004	0.0
122	2020-04-30	10.2	3.134	5.56	4.538	0.0	0.0	0.0	0.0	3.4960000000000004	45.221000000000004	0.0	0.314	5.5520000000000005	4.833	0.0	64.646	3.892	0.0	102.97	45.04	0.0	0.41200000000000003	16.058	0.0	4.883	0.0	30.785	0.0	29.526	0.0	0.0	6.9079999999999995	0.14400000000000002	0.0	0.0	0.9790000000000001	41.651	0.0	45.648	0.0	0.0	27.201999999999998	0.003	5.149		2.356	1.57	2.085	3.654	2.6489999999999996	0.0	6.85	7.002999999999999	0.1	27.105	5.061	0.0	21.755	23.635	2.208	4.934	0.0	0.0	4.523	0.035	0.0	0.0	0.0	29.96	24.619	0.0	17.073	0.414	1.504	17.641	0.0	4.03	0.0	17.775	0.0	1.5630000000000002	59.655	8.452	2.033	3.8139999999999996	0.0	3.332	4.968999999999999	5.861000000000001	1.245	0.951	12.775	3.878	76.14699999999999	47.041000000000004	28.305999999999997	34.501	5.066	1.8659999999999999	19.788	0.196	7.563	0.18600000000000003	5.1739999999999995	70.248	2.6060000000000003	0.0	6.892	0.586		0.0	0.0	0.0	11.387	44.73	10.08	0.0	0.0	2.904	59.2	2.864	11.324000000000002	0.0	0.0	13.612	32.97	0.0	0.0	1.5919999999999999	0.0	1.869	0.0	0.0	0.0	0.10300000000000001	22.526999999999997	0.0	0.622	0.151	0.165	0.951	0.0	11.436	28.003	3.957	2.352	41.254	0.0	1.402	83.132	2.318	11.15	36.09	11.535	223.18200000000002	18.817	40.025	1.004	0.0	10.892000000000001	0.0	294.655	13.689	38.06	3.5239999999999996	33.36	0.0	1.504	117.94200000000001	23.32	1.2819999999999998	4.81		3.398	5.968999999999999	0.078	0.0	26.543000000000003	1.401	1.3	0.0	17.239	79.115	16.523	0.0	0.0		2.9130000000000003	0.22899999999999998	0.0	1.208	0.0	0.423	34.812	0.0	0.044000000000000004	10.427	55.508	69.661	82.555	67.035	1.439	1.882	1236.094	0.07	0.0		0.0	0.168	0.109	0.135
290	2020-10-15	49.821999999999996	0.8220000000000001	70.54	4.218999999999999	2523.782	5.8420000000000005	0.0	10.212	330.385	0.0	243.523	0.941	178.31799999999998	36.393	564.529	205.10299999999998	10.225	17.399	63.178999999999995	1056.808	85.509	5.527	0.0	3.888	18.761	0.0	146.915	0.0	128.129	0.0	2.286	117.868	0.0	0.0	0.0	4.0680000000000005	66.398	210.43599999999998	60.864	0.0	0.48700000000000004	57.123999999999995	0.008	119.117	0.0	0.0	302.702	1.2890000000000001	182.205	1.589	158.44	94.76	891.1210000000001	0.703	84.94200000000001	12.145999999999999	0.0	60.288000000000004	51.692	1.251	44.093999999999994	1.426	0.0	29.4	6.193	20.465	0.0	0.0	36.818000000000005	346.098	1146.299	4.044	3.31	170.46099999999998	79.22800000000001	504.586	41.733999999999995	0.0	0.0	444.358	39.854	0.0	4.112	0.0	30.513	1.8419999999999999	61.184	98.34	260.806	49.06399999999999	15.088	57.505	95.89200000000001	219.53099999999998	23.521	228.64	121.26700000000001	26.679000000000002	4.507	39.575	237.476	5.858	11.232999999999999	41.391000000000005	124.574	59.471000000000004	0.0	54.077	201.745	13.07	0.198	121.666	0.0	51.06	303.526	212.635	0.0	0.105	20.392	127.65	2.765	251.393	2.366	0.0	20.476	284.832	178.37099999999998	0.0	307.295	0.0	91.762	4.287	16.320999999999998	27.156	90.538	424.339	0.0	0.415	0.0	0.083	0.868	0.0	28.038	110.249	3.418	104.285	192.826	0.335	90.851	90.289	16.636	172.433	203.203	341.159	68.725	208.757	97.516	2.471	0.0	10.892000000000001	0.0	0.0	0.0	14.390999999999998	1.433	36.005	0.0	0.752	0.855	233.19799999999998	258.259	340.07800000000003		0.0	31.648000000000003	1.931	0.0	284.848	6.164	0.0	18.750999999999998	16.377	95.84899999999999	314.745	3.2569999999999997	0.0	4.0889999999999995	0.0	0.18600000000000003	0.0	1.329	19.293	189.024	19.813	0.0	2.7110000000000003	127.819	144.686	290.546	179.412	0.0	0.28800000000000003	9.442	0.0	21.592	0.092		0.0	0.034	1.577	1.278
301	2020-10-26	56.29	1.67	103.899	5.997999999999999	0.0	5.994	0.0	0.0	204.732	328.35699999999997	93.663	0.8240000000000001	307.115	93.301	147.49	164.553	7.942	0.0	89.42399999999999	404.845	98.083	0.0	0.0	2.592	6.3389999999999995	0.0	345.95099999999996	0.0	63.479	0.0	0.0	47.06100000000001	0.335	0.084	0.0	0.0	56.833	133.096	0.0	0.0	0.183	79.566	0.018000000000000002	160.643	0.0	0.0	0.0	1.554	589.73	2.825	127.971	115.31	681.671	0.0	163.15	6.0729999999999995	13.890999999999998	46.922	114.54899999999999	1.3969999999999998	0.0	0.0	0.0	45.23	4.218999999999999	0.0	0.0	0.0	35.374	796.801	0.0	0.0	0.414	469.27	103.65899999999999	207.771	75.794	0.0	0.0	0.0	8.652000000000001	0.0	0.0	0.0	36.869	0.965	49.472	239.743	158.24200000000002	32.716	13.644	73.709	63.497	206.57	0.0	84.917	351.842	14.859000000000002	4.27	0.0	229.047	8.841000000000001	17.314	96.235	165.78599999999997	64.376	0.0	111.865	217.422	2.801	0.0	238.52900000000002	655.5310000000001	222.607	784.375	268.79400000000004	0.0	0.157	25.428	155.4	0.889	276.306	0.0	0.0	33.816	102.62899999999999	254.81599999999997	0.305	267.49	0.0	81.819	2.911	18.122	31.878	98.02	594.927	0.0	1.037	0.0	0.0	0.301	69.49600000000001	0.0	214.42700000000002	3.201	88.79899999999999	158.757	0.5589999999999999	77.252	75.85300000000001	20.159000000000002	310.252	252.729	427.49699999999996	71.154	200.388	114.50299999999999	0.46299999999999997	0.0	10.892000000000001	0.0	0.0	0.0	9.277999999999999	0.478	90.23299999999999	0.0	0.125	0.855	93.279	557.179	804.74	0.0	2.7680000000000002	27.348000000000003	2.3209999999999997	0.447	1116.2069999999999	16.392	0.0	6.819	6.034	51.093	0.0	2.8	0.0	4.194	0.0	0.1	0.0	1.57	5.716	0.0	23.915	0.0	3.1919999999999997	139.0	137.406	291.518	179.576	0.0	12.667	8.366	0.0	14.876	0.08199999999999999	0.0	0.0	0.0	0.0	0.47100000000000003