owid-covid

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

Custom SQL query returning 3 rows (hide)

select rowid, date, World, Afghanistan, Albania, Algeria, Andorra, [Antigua and Barbuda], Argentina, Armenia, Aruba, Australia, Austria, Azerbaijan, Bahamas, Bahrain, Bangladesh, Belarus, Belgium, Benin, Bhutan, Bolivia, [Bosnia and Herzegovina], Brazil, Brunei, Bulgaria, [Burkina Faso], Cambodia, Cameroon, Canada, [Cayman Islands], [Central African Republic], Chile, China, Colombia, Congo, [Costa Rica], [Cote d'Ivoire], Croatia, Cuba, Curacao, Cyprus, [Czech Republic], [Democratic Republic of Congo], Denmark, [Dominican Republic], Ecuador, Egypt, [Equatorial Guinea], Estonia, Ethiopia, [Faeroe Islands], Finland, France, [French Guiana], [French Polynesia], Gabon, Georgia, Germany, Ghana, Gibraltar, Greece, Guadeloupe, Guam, Guatemala, Guernsey, Guinea, Guyana, Honduras, Hungary, Iceland, India, Indonesia, International, Iran, Iraq, Ireland, Israel, Italy, Jamaica, Japan, Jersey, Jordan, Kazakhstan, Kenya, Kuwait, Latvia, Lebanon, Liberia, Liechtenstein, Lithuania, Luxembourg, Macedonia, Malaysia, Maldives, Malta, Martinique, Mauritania, Mayotte, Mexico, Moldova, Monaco, Mongolia, Morocco, Namibia, Nepal, Netherlands, [New Zealand], Nigeria, Norway, Oman, Pakistan, Palestine, Panama, Paraguay, Peru, Philippines, Poland, Portugal, [Puerto Rico], Qatar, Reunion, Romania, Russia, Rwanda, [Saint Barthlemy], [Saint Lucia], [Saint Martin (French part)], [Saint Vincent and the Grenadines], [San Marino], [Saudi Arabia], Senegal, Serbia, Seychelles, Singapore, Slovakia, Slovenia, Somalia, [South Africa], [South Korea], Spain, [Sri Lanka], Sudan, Suriname, Swaziland, Sweden, Switzerland, Tanzania, Thailand, Togo, [Trinidad and Tobago], Tunisia, Turkey, Ukraine, [United Arab Emirates], [United Kingdom], [United States], [United States Virgin Islands], Uruguay, Uzbekistan, Vatican, Venezuela, Vietnam from [total_cases_per_million-1] where "United Arab Emirates" = :p0 order by rowid limit 101

Query parameters

This data as json, copyable, CSV

rowid	date	World	Afghanistan	Albania	Algeria	Antigua and Barbuda	Argentina	Armenia	Australia	Austria	Azerbaijan	Bahrain	Bangladesh	Belarus	Belgium	Bhutan	Bolivia	Bosnia and Herzegovina	Brazil	Brunei	Bulgaria	Burkina Faso	Cambodia	Cameroon	Canada	Central African Republic	Chile	China	Colombia	Congo	Costa Rica	Cote d'Ivoire	Croatia	Cuba	Curacao	Cyprus	Czech Republic	Democratic Republic of Congo	Denmark	Dominican Republic	Ecuador	Egypt	Equatorial Guinea	Estonia	Ethiopia	Finland	France	French Guiana	French Polynesia	Gabon	Georgia	Germany	Ghana	Greece	Guinea	Guyana	Honduras	Hungary	Iceland	India	Indonesia	Iran	Iraq	Ireland	Israel	Italy	Jamaica	Japan	Jordan	Kazakhstan	Kenya	Kuwait	Latvia	Lebanon	Lithuania	Luxembourg	Macedonia	Malaysia	Maldives	Malta	Martinique	Mauritania	Mayotte	Mexico	Moldova	Mongolia	Morocco	Namibia	Nepal	Netherlands	New Zealand	Nigeria	Norway	Oman	Pakistan	Palestine	Panama	Paraguay	Peru	Philippines	Poland	Portugal	Puerto Rico	Qatar	Reunion	Romania	Russia	Saint Vincent and the Grenadines	Saudi Arabia	Senegal	Serbia	Singapore	Slovakia	Slovenia	South Africa	South Korea	Spain	Sri Lanka	Sudan	Swaziland	Sweden	Switzerland	Thailand	Togo	Trinidad and Tobago	Tunisia	Turkey	Ukraine	United Arab Emirates	United Kingdom	United States	Venezuela	Vietnam
53	2020-03-13	17.030120105170266	0.18394457634292485	7.817720665362807	0.5769241198243704		0.6811630018888649	0.3402889529615177	5.512206643807545	41.10582643776453	1.0891366245655951	114.85688537577343	0.01767041401762373	1.2745035251174377	27.022440329460345	1.197253500469922	0.2598756650867959	1.1434419317307996	0.36004350185866146	26.99547150965425	1.0085689458451788	0.09567846677170568	0.2991234247861327	0.07704699219329057	3.669899946028536		1.7864258593479794	56.853812491320674	0.17920999931263004		4.3614629853540094	0.03820913771528461	3.887319248765837	0.26097186618893736		4.969590249001318	10.908997891930198	0.011172535102178029	116.27104609439692	0.45011152863456505	0.9806386172487872	0.6508551984737271		9.995701848205274		19.5336055971486	43.517183543535786	19.738010803271244	3.4394518889469774		6.41267513977708	28.701079289003147		8.826783559701301		1.2645710195730304	0.20577687716097876	1.6629848874169624	177.72442807696342	0.053499219355657816	0.1248976082978621	120.53291123325936	1.6866297367038459	14.320809035694005	8.607275167356987	255.5804191069033	0.3432698512955004	5.336152002131741	0.09795602988912748			18.592220317810767	8.452223542295192	10.963828502465617	1.0517171385721469	28.14830514087399	3.352434226437776	3.9246320954039735	17.432650046087566	20.71999686897825	10.377292408751169			0.08963918413193417	0.9955977158001608	0.3115843315456701	0.16185281331750845		0.03304666016572768	35.736635662322094	1.0342502306378014	0.009701546427955848	89.7298251479487	3.4953492436452613	0.09598663835278406	5.824189512363157	3.2639130120554958	0.7075808800324921	0.6604191416124157	0.4740053808361594	1.2914369742780811	4.012364738046896		93.84602875485302	3.3462125335736657	2.475711976081321	0.2364611359918455	9.028774704984787	0.6050192396118197	0.5813901433673211	2.182918957869894	31.50772200349348	3.8522214477015084	27.37679840350039	0.2895034775242868	154.911058162511	63.8194111700414	0.14228770745192024			61.254617066761405	98.95583144523378	1.0805224334609964	0.11927066939828306		0.5880803176574644	0.011928085572085894	0.06884012692834389	8.661828950278045	8.821667583882475	3.813759013045512		0.3965020588369405
54	2020-03-14	18.284179778772945	0.18394457634292485	11.216729650303158	0.6000010846173452	9.513842641042716	0.7470820020716583	2.7223116236921423	7.7564622059291874	57.38874383554936	1.0891366245655951	123.69203040467909	0.01767041401762373	2.230381168955516	51.549177571167974	1.197253500469922	0.2598756650867959	3.1444653122596984	0.4582371841837509	56.24056564511303	1.0085689458451788	0.09567846677170568	0.41877279470058576	0.07704699219329057	4.6804521050798735		2.3277670288473664	56.87487179883311	0.31859555433356457		4.5597113028701015	0.03820913771528461	6.559851232292348	0.3479624882519165		11.595710581003079	14.106462791289053	0.022345070204356058	138.17968534363786	0.45011152863456505	1.3267463645130648	0.9034258725083076		60.74311123140127	0.008868466190790684	19.5336055971486	55.38550632813645	19.738010803271244	3.4394518889469774	0.4648375927176685	6.41267513977708	37.096962761894325	0.032537514534101024	8.826783559701301	0.0727229040640904	1.2645710195730304	0.20577687716097876	1.9747945538076428	177.72442807696342	0.05928291874545865	0.2534686756633084	135.9539457324823	2.2408080787636813	18.412468760178005	11.476366889809315	298.6534904670094	2.4028889590685027	5.660273827446411	0.09795602988912748		0.01869449010002431	23.240275397263456	8.452223542295192	12.791133252876552	2.1034342771442933	62.91974090313009	4.310272576848569	5.993430409260331	19.611731301848515	27.626662491971	15.565938613126756			0.19421823228585736	1.9911954316003213	0.3115843315456701	0.18882828220375986		0.03304666016572768	46.79520370115139	1.2411002767653618	0.009701546427955848	137.62243120851028	3.689535312736664	0.10078597027042327	6.5756978365390495	6.294689380392742	0.8490970560389905	0.8405334529612564	0.5833912379521962	1.6867748235468811	10.960606113689083	0.8217809197810338	93.84602875485302	5.577020889289443	3.300949301441762	0.2364611359918455	9.028774704984787	1.7862472788539436	0.5813901433673211	3.5616046154719316	33.69809839945827	5.503173496716441	67.72155394550097	0.2895034775242868	156.98844671037273	91.06911590571508	0.2845754149038405	0.02296675174546739		76.56827133345176	129.74977899287646	1.0805224334609964	0.11927066939828306	0.7258321484123511	1.3441835832170614	0.059640427860429474	0.06884012692834389	8.661828950278045	11.910736367464215	5.0628857783942784	0.06029109990018205	0.4880025339531575
55	2020-03-15	19.693072720178247	0.2627779662041783	12.916234142773332	0.8538476973400683	9.513842641042716	0.9887850027419006	2.7223116236921423	9.803853245057704	91.09324418341171	1.8812359878860283	124.2810400732728	0.01767041401762373	2.230381168955516	59.294463015917756	1.197253500469922	0.2598756650867959	5.1454886927885966	0.5657826457778966	89.98490503218085	6.1954949530489545	0.1435177001575585	0.41877279470058576	0.11557048828993588	6.488808600224369	0.2032153133305791	3.302181133946265	56.8938251755943	0.4778933315003468	0.17584220061590491	4.5597113028701015	0.11462741314585385	8.989425762770999	0.3479624882519165	12.232789993577786	17.393565871504613	20.12522024890572	0.022345070204356058	142.66491857576594	0.45011152863456505	1.3267463645130648	0.9034258725083076	0.7110959410643685	60.74311123140127	0.008868466190790684	37.633552067900965	67.99940323638512	23.027679270483127	10.318355666840931	0.4648375927176685	7.695210167732495	45.97745711345164	0.06507502906820205	20.535782159305068	0.0727229040640904	1.2645710195730304	0.20577687716097876	3.3259697748339248	402.06509958395	0.0773569793385863	0.429794710907349	152.28421112537555	2.2408080787636813	26.391205222921812	20.427933063860586	357.7922931942535	2.7461588103640038	6.166220091352234	0.09795602988912748	0.31953749716610186	0.01869449010002431	26.029108444935073	15.847919141803484	15.449031071656096	3.15515141571644	62.91974090313009	6.225949277670156	7.240794098497252	21.790812557609463	27.626662491971	25.943231021877928	0.2090402814351117	3.6615283219215695	0.30626721245077515	2.9867931474004816	0.3115843315456701	0.4855584399525253	0.7416920294436901	0.03304666016572768	55.81666710124899	1.2411002767653618	0.009701546427955848	166.4313934748251	3.8837213818280674	0.13438129369389767	7.139329079670968	6.294689380392742	0.8490970560389905	1.2908192313333577	1.01181917832334	2.925500084589122	10.960606113689083	0.8217809197810338	120.71034996330332	6.692425067147331	6.344011938708387	0.2364611359918455	9.028774704984787	2.9674753180960685	1.220919301071374	4.7105093301402965	35.719984303425754	8.071321128517445	67.72155394550097	0.6471254203484058	158.4639750247418	123.82902949789144	0.5217215939903743	0.02296675174546739	0.6947845994045696	91.28913898336701	156.73773302339475	1.0805224334609964	0.11927066939828306	0.7258321484123511	1.3441835832170614	0.059640427860429474	0.06884012692834389	8.661828950278045	16.98987830969958	5.0628857783942784	0.06029109990018205	0.5388361312399448