owid-covid

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

Custom SQL query returning 7 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	Argentina	Armenia	Aruba	Australia	Austria	Azerbaijan	Bahrain	Bangladesh	Barbados	Belarus	Belgium	Benin	Bermuda	Bolivia	Bosnia and Herzegovina	Brazil	Bulgaria	Burkina Faso	Cameroon	Canada	Cape Verde	Chad	Chile	China	Colombia	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	Estonia	Ethiopia	Finland	France	Gabon	Georgia	Germany	Ghana	Greece	Guatemala	Guernsey	Guinea	Guinea-Bissau	Guyana	Haiti	Honduras	Hungary	India	Indonesia	Iran	Iraq	Ireland	Isle of Man	Israel	Italy	Jamaica	Japan	Jersey	Jordan	Kazakhstan	Kenya	Kosovo	Kuwait	Kyrgyzstan	Latvia	Lebanon	Liberia	Libya	Lithuania	Luxembourg	Macedonia	Malaysia	Maldives	Mali	Malta	Mauritania	Mauritius	Mexico	Moldova	Montenegro	Montserrat	Morocco	Myanmar	Netherlands	New Zealand	Nicaragua	Niger	Nigeria	Norway	Oman	Pakistan	Palestine	Panama	Paraguay	Peru	Philippines	Poland	Portugal	Puerto Rico	Qatar	Romania	Russia	San Marino	Sao Tome and Principe	Saudi Arabia	Senegal	Serbia	Sierra Leone	Singapore	Sint Maarten (Dutch part)	Slovakia	Slovenia	Somalia	South Africa	South Korea	Spain	Sri Lanka	Sudan	Swaziland	Sweden	Switzerland	Taiwan	Tajikistan	Tanzania	Thailand	Togo	Tunisia	Turkey	Ukraine	United Arab Emirates	United Kingdom	United States	United States Virgin Islands	Uruguay	Uzbekistan	Western Sahara	Yemen	Zambia	Zimbabwe
130	2020-05-08	74909	64	4	76	10	117	16	1	22	101	8	0	72	1	56	1475	1	2	59	37	5833	32	7	59	2262	1	27	117	1	192	4	0	6	36	30	1	57	11	112	1	108	1094	206	7	3	11	1	83	4131	6	4	1945	9	23	12	3	5	2	3	7	58	142	1168	283	1005	19	609	7	47	4409	3	240	6	2	9	15	9	30	4	7	3	12	1	9	17	33	12	3	11	2	0	1	1892	65	3	1	28	1	1111	4	3	18	76	29	5	357	2	79	1	1055	223	301	285	33	2	349	1070	1	4	98	7	67	15	8	2	11	20	30	86	16	3727	2	39	1	1089	250	0		11	5	3	6	1150	153	109	8519	25707	1	5	3		6	1	1
131	2020-05-09	74662	66	4	73	7	126	16	1	18	101	7	0	75	1	58	1394	1	2	62	44	6227	34	7	59	2267	1	28	120	1	203	4	0	6	35	25	1	58	11	109	1	113	1128	209	8	3	10	1	83	3985	5	5	1869	8	20	13	2	5	2	2	7	60	143	1206	254	967	18	600	5	51	4232	2	267	6	2	6	15	10	32	4	6	4	12	1	9	15	33	11	3	14	2	0	1	1939	65	2	1	28	1	1070	3	2	20	85	22	5	365	2	77	1	1080	219	282	234	30	2	346	1108	1	5	102	7	65	14	8	3	9	20	28	99	16	3576	2	43	1	1060	217	0		11	5	4	7	1089	168	110	8088	26163	1	6	2	0	7	1	0
132	2020-05-10	72908	68	4	75	8	115	17	1	16	79	10	0	74	1	59	1323	1	2	68	45	6611	35	7	55	2228	1	31	123	1	212	2	0	7	33	23	1	58	13	98	1	112	1141	207	9	3	14	2	79	3696	5	5	1755	12	21	11	1	4	3	2	6	49	141	1285	239	939	21	383	5	48	4011	2	265	6	2	6	16	10	30	4	6	2	9	1	9	16	32	10	3	16	2	0	1	2048	67	2	0	27	1	1013	3	2	18	93	20	7	370	2	78	1	1114	210	261	223	25	3	351	1146	1	5	103	10	62	15	8	3	9	20	30	100	14	3431	2	47	1	1055	203	0		11	5	4	7	1033	175	114	7548	25605	1	4	2	0	7	4	0
133	2020-05-11	72421	63	3	77	8	114	17	1	14	76	11	0	83	1	59	1241	1	2	68	49	6918	35	7	58	2311	1	31	123	0	220	2	0	7	35	23	2	59	13	97	1	110	1551	218	9	3	11	2	77	3524	5	4	1667	11	21	11	0	4	2	2	9	47	141	1334	230	930	22	371	5	53	3916	2	270	6	2	6	18	8	38	4	6	2	8	1	9	13	30	10	3	15	1	0	1	2114	73	2	0	27	1	965	2	2	17	103	24	7	386	2	79	1	1161	218	265	207	27	4	344	1168	0	5	107	10	59	14	8	2	8	20	28	107	13	3554	2	49	1	1054	201	0		11	5	5	7	981	182	122	7401	24652	1	4	2	0	8	4	0
134	2020-05-12	71112	65	3	75	8	108	17	1	13	71	10	0	87	1	60	1171	1	2	69	52	6976	35	8	67	2286	1	31	125	0	226	3	1	7	32	21	1	59	14	97	1	115	1482	196	10	3	11	2	78	3350	6	5	1620	11	15	11	0	4	2	2	10	55	134	1359	226	879	22	365	5	56	3762	2	267	6	2	7	19	7	43	4	5	2	4	1	9	13	26	10	3	16	1	0	0	2139	73	2	0	26	1	938	2	2	17	110	31	7	405	2	82	1	1179	215	249	196	29	4	341	1214	0	5	111	10	56	15	7	2	8	19	26	116	14	3098	2	52	1	1045	190	1		11	2	5	6	941	188	119	7268	24439	1	4	2	0	9	4	0
135	2020-05-13	70303	67	1	78	7	112	18	1	9	54	11	1	95	1	63	1106	1	2	73	54	7383	37	9	66	2310	1	38	128	0	224	3	1	7	28	20	1	56	20	94	1	116	1456	185	11	3	11	2	76	3331	6	5	1519	6	16	11	0	4	2	2	12	55	130	1408	234	856	24	329	2	52	3552	2	279	6	1	7	22	8	52	4	5	2	4	1	6	13	21	9	3	16	1	0	0	2357	75	2	0	23	1	944	2	5	16	114	33	7	410	2	76	1	1203	221	243	190	28	4	352	1249	0	6	112	10	52	16	7	2	7	16	24	113	13	2829	2	55	1	1023	181	1		11	2	5	5	902	186	114	6913	24032	1	4	2	0	11	4	0
136	2020-05-14	68759	70	0	78	7	115	17	1	8	44	12	2	106	0	62	1055	0	2	83	56	7683	32	8	75	2308	1	40	130	0	231	2	1	10	27	21	2	63	19	91	1	116	1451	176	11	5	11	2	78	2987	6	5	1435	8	16	13	0	7	2	2	12	52	124	1475	244	826	23	307	2	49	3424	2	272	6	1	7	25	8	58	4	4	2	4	1	9	14	22	11	4	19	2	1	0	2488	74	2	0	20	0	851	2	4	17	113	27	7	424	2	78	2	1226	214	237	186	29	4	341	1240	0	7	116	13	49	17	7	2	5	14	24	116	13	2778	2	62	1	990	156	1	23	5	2	4	5	871	189	108	6591	23167	2	4	2	0	12	4	0