owid-covid

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

Custom SQL query returning 10 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_deaths where "Japan" = :p0 order by rowid limit 101

Query parameters

This data as json, copyable, CSV

rowid	date	World	Afghanistan	Albania	Algeria	Andorra	Angola	Anguilla	Argentina	Armenia	Aruba	Australia	Austria	Azerbaijan	Bahamas	Bahrain	Bangladesh	Belarus	Belgium	Belize	Bolivia	Bonaire Sint Eustatius and Saba	Bosnia and Herzegovina	Botswana	Brazil	British Virgin Islands	Bulgaria	Burkina Faso	Burundi	Cameroon	Canada	Cape Verde	Central African Republic	Chad	Chile	China	Colombia	Comoros	Congo	Costa Rica	Cote d'Ivoire	Croatia	Cuba	Curacao	Czech Republic	Democratic Republic of Congo	Denmark	Djibouti	Dominican Republic	Ecuador	Egypt	El Salvador	Ethiopia	Falkland Islands	Finland	France	French Polynesia	Gabon	Gambia	Georgia	Germany	Ghana	Greece	Guam	Guatemala	Guinea	Guinea-Bissau	Guyana	Haiti	Honduras	Hungary	India	Indonesia	Iran	Iraq	Ireland	Israel	Italy	Jamaica	Japan	Jordan	Kazakhstan	Kenya	Kosovo	Kuwait	Kyrgyzstan	Laos	Latvia	Lebanon	Lesotho	Liberia	Libya	Lithuania	Luxembourg	Macedonia	Madagascar	Malawi	Malaysia	Maldives	Mali	Malta	Mauritania	Mauritius	Mexico	Moldova	Montenegro	Morocco	Mozambique	Myanmar	Namibia	Nepal	Netherlands	Nicaragua	Niger	Nigeria	Northern Mariana Islands	Norway	Oman	Pakistan	Palestine	Panama	Paraguay	Peru	Philippines	Poland	Portugal	Puerto Rico	Qatar	Romania	Russia	Rwanda	Saint Kitts and Nevis	Saint Vincent and the Grenadines	Sao Tome and Principe	Saudi Arabia	Senegal	Serbia	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	Tajikistan	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	Vietnam	Wallis and Futuna	Western Sahara	Yemen	Zambia	Zimbabwe
84	2020-03-23	1691	0	0	2	0	0		0	0		0	8	0	0	1	1	0	47		0		0		7		0	0		0	2	0	0	0	1	9	1		0	0	0	0	0		1	1	0	0	0	7	2	0	0		0	112	0	0	0	0	27	0	2	0	0	0		0	0	0	3	3	10	129	3	1	0	649	0	5	0	0	0	1	0	0		0	0		0		0	0	1	0		6	0		0	0	1	0	0	0	1	0		0	0	43	0	0	0		0	0	2	0	0	0	0	0	2	2		0	2	0	0				0	0	0		0		0	0		0	0	9		394	0	0	0	0	11	4	0		0	0	2	9		0	0	0	36	131		0	0	0	0				0	0
140	2020-05-18	2898	1	0	6	0	0	0	3	1	0	0	1	3	0	0	14	5	31	0	4	0	3	0	485	0	2	0	0	0	103	0	0	3	29	0	12	0	0	0	2	0	0	0	1	0	4	0	4	48	18	4	0	0	1	68	0	0	0	0	21	0	1	0	2	0	1	0	0	4	11	157	59	51	2	10	4	145	0	5	0	0	0	0	5	0	0	0	0	0	1	0	1	3	3	1	0	0	0	4	0	1	0	132	4	0	0	0	0	0	1	10	0	3	6	0	0	1	30	0	6	0	125	7	10	15	1	0	16	94	0	0	0	0	10	1	2	3	0	0	0	1		1	3	1	0	59	0	6	0	0	53	1	0	3	0	0	0	44	0	0	17	6	67	808	0	1	1	0	0		0	1	0	0
153	2020-05-31	4012	3	0	8	0	0	0	8	4	0	0	0	3	0	2	28	5	23	0	10	0	0	0	956	0	1	0	0	14	94	0	0	0	53	0	37	0	0	0	1	0	1	0	0	0	3	2	10	0	34	3	0	0	2	57	0	2	0	0	11	1	0	0	12	1	0	1	6	2	7	193	53	57	10	5	0	111	0	5	0	1	1	0	11	0	0	0	0	0	0	0	2	0	5	1	0	0	0	3	2	1	0	364	3	0	2	0	0	0	0	20	0	0	12	0	0	2	88	0	4	0	141	8	10	13	1	0	13	181	1	0	0	0	22	1	0	1	0	0	0	0		1	32	1	0	2	0	29	0	0	39	0	0	0	0	0	0	26	0	0	17	2	154	945	0	0	0	0	0		0	11	0	0
178	2020-06-25	5215	21	2	8	0	0	0	36	11	0	1	0	7	0	2	37	5	3	0	30	0	1	0	1185	0	1	0	0	5	30	0	1	0	226	0	87	0	0	0	0	0	0	0	4	0	0	3	16	35	85	13	3	0	0	11	0	0	0	0	13	0	0	0	19	0	0	0	3	12	3	418	38	133	79	6	0	-31	0	5	0	2	2	2	3	1	0	0	1	0	0	1	1	0	8	1	0	0	0	1	0	3	0	965	5	0	2	0	0	0	0	2	0	0	9	0	1	2	148	0	11	0	182	18	21	3	0	5	16	154	0	0	0	1	41	4	0	1	0	0	0	0		0	103	1	1	3	0	0	1	0	22	2	0	0	1	0	0	24	0	0	16	2	87	751	0	1	0	3	0		0	13	0	0
218	2020-08-04	4226	4	6	8	0	2	0	55	0	0	13	0	6	0	3	30	4	3	0	75	0	4	0	561	0	0	1	0	0	2	1	0	0	99	3	367	0	2	9	0	4	0	0	0	0	1	0	5	17	23	19	52	0	0	29	0	1	0	0	8	9	1	0	18	0	1	0	1	7	0	803	66	215	66	0	10	12	0	5	0	0	13	7	4	7	0	0	3	0	1	13	0	1	3	4	0	0	1	0	0	0	0	266	9	1	19	1	0	1	0	0	0	0	8	0	1	0	15	0	26	3	197	45	1	0	0	0	19	79	0	0	0	0	32	2	8	0	0	0	0	0		0	173	0	0	26	0	0	0	2	4	0	2	0	0	0	0	19	0	1	13	0	1	543	0	0	6	0	2		0	2	1	10
265	2020-09-20	5073	4	5	6	0	0	0	214	2	0	7	2	2	1	1	32	3	8	0	36	0	6	0	739	0	2	0	0	0	6	0	0	0	55	0	189	0	0	20	0	0	2	0	4	0	0	0	10	40	17	3	17	0	0	25	0	0	0	0	2	2	4	0	29	0	0	2	0	20	8	1133	112	166	83	0	30	24	5	5	1	5	0	0	1	0	0	0	5	0	0	8	0	0	6	2	0	1	0	0	1	0	0	455	15	1	40	1	6	3	11	2	0	0	1	0	0	0	1	5	18	25	86	100	12	5	6	0	42	144	1	0	0	0	28	1	1	0	0	0	0	0		0	83	5	0	0	0	0	1	1	1	0	0	0	0	1	22	68	0	2	48	1	27	669	0	0	10	9	0		0	1	0	1
272	2020-09-27	5421	0	2	4	0	5	0	335	1	0	1	1	2	0	1	36	6	6	1	28	0	0	0	869	0	0	0	0	0	7	1	0	0	64	0	193	0	0	16	0	3	2	0	10	0	1	0	6	37	16	0	10	0	0	39	0	0	0	1	5	0	7	0	27	1	0	1	0	17	6	1124	90	172	68	5	36	17	8	5	4	2	7	2	2	0	0	0	7	0	0	8	0	0	1	1	0	0	0	0	0	0	0	399	15	3	43	1	24	0	8	38	0	0	3	0	0	0	6	7	12	21	105	88	32	8	7	2	54	169	0	0	0	0	30	2	0	0	0	0	3	1		1	64	2	0	0	0	0	0	0	2	1	3	1	2	0	16	71	0	0	76	2	35	723	0	0	4	9	0		0	1	0	0
288	2020-10-13	3941	3	4	8	2	0	0	318	12	0	0	5	0	1	7	31	5	36	2	18	0	10	2	201	0	23	0	0	0	42	0	0	0	61	0	151	0	0	32	0	3	0	0	17	0	2	0	6	27	22	0	14	0	0	95	1	0	1	8	13	2	7	0	3	1	0	1	0	9	28	706	91	272	60	1	38	39	7	5	16	2	11	1	6	7	0	0	11	0	0	13	0	3	5	0	0	2	0	0	2	0	0	303	17	9	31	1	18	1	9	12	0	0	0	0	1	8	18	10	11	19	52	11	35	14	5	0	56	125	1	0	0	0	25	1	2	0	1	0	0	2		0	0	1	0	80	0	0	0	0	3	7	7	0	0	2	22	58	0	1	43	1	50	314	0	1	5	7	0		0	0	9	0
300	2020-10-25	5787	4	4	10	0	5	0	275	35	0	0	6	8	2	0	19	8	88	2	19	0	6	0	432	0	7	0	0	0	34	0	0	0	48	0	198	0	0	17	0	16	0	0	106	1	3	0	6	14	11	5	19	0	0	137	0	0	0	18	29	2	5	2	15	0	0	0	0	5	35	578	128	335	55	4	43	151	4	5	32	0	12	2	4	4	0	4	3	0	0	16	3	3	14	6	0	7	0	0	1	0	0	431	14	8	50	3	28	0	13	55	0	0	0	0	0	0	9	4	6	15	62	19	179	21	3	0	73	296	0	0	0	0	17	0	3	0	0	0	25	2	0	0	53	0	0	0	1	1	0	0	1	0	3	0	0	1	35	69	0	0	125	0	174	904	0	0	5	6	0	0	0	1	2	0
303	2020-10-28	7278	7	7	9	0	2	0	429	21	0	0	18	9	0	0	20	4		0	14	0	0	0	549	0	25	0	0	0	28	0	0	0	23	0	217	0	0	17	0	18	0	0	182	0	1	0	1	15	11	9	8	0	0	523	6	0	0	15	85	0	12	1	14	0	0	0	0	6	43	508	101	346	53	5	30	221	4	5	44	30	14	3	7	2	0	3	11	0	0	11	5	0	0	0	0	2	0	3	5	0	0	643	10	5	72	1	25	0	14	70	1	0	3	0	1	13	14	10	12	18	60	14	132	28	4	0	104	320	1	0	0	0	16	0	5	0	0	0	11	4	0	0	45	1	0	168	3	0	1	0	0	16	3	0	1	0	0	76	0	2	126	2	367	988	0	0	3	3	0	0	0	0	0	0