daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,440 rows where active = 94 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 1,256
- Japan 39
- Germany 9
- China 8
- Colombia 8
- Ukraine 8
- Burundi 7
- Canada 7
- Italy 6
- Netherlands 6
- Russia 6
- Malaysia 5
- United Kingdom 5
- Belize 4
- Chile 4
- France 4
- India 4
- Saint Lucia 4
- Thailand 4
- Australia 3
- Pakistan 3
- Saint Kitts and Nevis 3
- Taiwan* 3
- Yemen 3
- Denmark 2
- Eswatini 2
- Mexico 2
- South Sudan 2
- Angola 1
- Antigua and Barbuda 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-29 | Eritrea | 6544 | 34 | 6416 | 94 | 15.1794 | 39.7823 | 2021-07-30 04:21:34 | Eritrea | |||
2021-07-23 | Ukraine | Zakarpattia Oblast | 62198 | 1608 | 60496 | 94 | 48.6208 | 22.2879 | 2021-07-24 00:21:36 | Zakarpattia Oblast, Ukraine | ||
2021-07-23 | Japan | Nagasaki | 3320 | 69 | 3157 | 94 | 33.235712 | 129.608033 | 2021-07-24 00:21:36 | Nagasaki, Japan | ||
2021-07-20 | India | Ladakh | 20278 | 206 | 19978 | 94 | 34.1526 | 77.5771 | 2021-07-21 04:21:40 | Ladakh, India | ||
2021-07-19 | Ukraine | Chernivtsi Oblast | 80054 | 1795 | 78165 | 94 | 48.2917 | 25.9352 | 2021-07-20 04:21:48 | Chernivtsi Oblast, Ukraine | ||
2021-07-17 | Kosovo | 107896 | 2268 | 105534 | 94 | 42.602636 | 20.902977 | 2021-07-18 04:22:07 | Kosovo | |||
2021-07-15 | Niger | 5555 | 194 | 5267 | 94 | 17.607789 | 8.081666 | 2021-07-16 04:21:22 | Niger | |||
2021-07-14 | Japan | Niigata | 3515 | 54 | 3367 | 94 | 37.521819 | 138.918647 | 2021-07-15 04:21:48 | Niigata, Japan | ||
2021-07-12 | Germany | Mecklenburg-Vorpommern | 44186 | 1161 | 42930 | 94 | 53.6127 | 12.4296 | 2021-07-13 04:21:18 | Mecklenburg-Vorpommern, Germany | ||
2021-07-11 | Denmark | Faroe Islands | 868 | 1 | 773 | 94 | 61.8926 | -6.9118 | 2021-07-12 04:21:34 | Faroe Islands, Denmark | ||
2021-07-10 | Japan | Hiroshima | 11567 | 176 | 11297 | 94 | 34.605309000000005 | 132.788719 | 2021-07-11 04:21:43 | Hiroshima, Japan | ||
2021-07-10 | Germany | Mecklenburg-Vorpommern | 44174 | 1161 | 42930 | 94 | 53.6127 | 12.4296 | 2021-07-11 04:21:43 | Mecklenburg-Vorpommern, Germany | ||
2021-07-04 | Japan | Kochi | 1851 | 26 | 1731 | 94 | 33.422519 | 133.367307 | 2021-07-05 04:21:28 | Kochi, Japan | ||
2021-07-04 | China | Hong Kong | 11942 | 211 | 11637 | 94 | 22.3 | 114.2 | 2021-07-05 04:21:28 | Hong Kong, China | ||
2021-07-03 | Saint Lucia | 5302 | 84 | 5124 | 94 | 13.9094 | -60.9789 | 2021-07-04 04:21:38 | Saint Lucia | |||
2021-07-03 | China | Hong Kong | 11939 | 211 | 11634 | 94 | 22.3 | 114.2 | 2021-07-04 04:21:38 | Hong Kong, China | ||
2021-07-02 | Saint Lucia | 5302 | 84 | 5124 | 94 | 13.9094 | -60.9789 | 2021-07-03 04:21:37 | Saint Lucia | |||
2021-07-02 | China | Hong Kong | 11938 | 211 | 11633 | 94 | 22.3 | 114.2 | 2021-07-03 04:21:37 | Hong Kong, China | ||
2021-07-01 | Saint Lucia | 5302 | 84 | 5124 | 94 | 13.9094 | -60.9789 | 2021-07-02 04:21:47 | Saint Lucia | |||
2021-06-22 | Japan | Kumamoto | 6450 | 113 | 6243 | 94 | 32.608154 | 130.74523100000002 | 2021-06-23 04:21:46 | Kumamoto, Japan | ||
2021-06-14 | Saint Lucia | 5180 | 80 | 5006 | 94 | 13.9094 | -60.9789 | 2021-06-15 04:22:22 | Saint Lucia | |||
2021-06-14 | Saint Kitts and Nevis | 155 | 0 | 61 | 94 | 17.357822 | -62.782998 | 2021-06-15 04:22:22 | Saint Kitts and Nevis | |||
2021-06-13 | Saint Kitts and Nevis | 155 | 0 | 61 | 94 | 17.357822 | -62.782998 | 2021-06-14 04:22:46 | Saint Kitts and Nevis | |||
2021-06-13 | Japan | Mie | 5144 | 108 | 4942 | 94 | 34.508018 | 136.376013 | 2021-06-14 04:22:46 | Mie, Japan | ||
2021-06-12 | Saint Kitts and Nevis | 155 | 0 | 61 | 94 | 17.357822 | -62.782998 | 2021-06-13 04:22:44 | Saint Kitts and Nevis | |||
2021-06-12 | Canada | New Brunswick | 2291 | 45 | 2152 | 94 | 46.5653 | -66.4619 | 2021-06-13 04:22:44 | New Brunswick, Canada | ||
2021-06-09 | Pakistan | Gilgit-Baltistan | 5674 | 107 | 5473 | 94 | 35.792146 | 74.982138 | 2021-06-10 04:23:17 | Gilgit-Baltistan, Pakistan | ||
2021-06-09 | Japan | Nara | 7912 | 119 | 7699 | 94 | 34.317451 | 135.871644 | 2021-06-10 04:23:17 | Nara, Japan | ||
2021-06-09 | Japan | Nagano | 4901 | 87 | 4720 | 94 | 36.132134 | 138.045528 | 2021-06-10 04:23:17 | Nagano, Japan | ||
2021-06-08 | India | Andaman and Nicobar Islands | 7154 | 125 | 6935 | 94 | 11.225999 | 92.968178 | 2021-06-09 04:23:31 | Andaman and Nicobar Islands, India | ||
2021-06-08 | Eswatini | 18680 | 674 | 17912 | 94 | -26.5225 | 31.4659 | 2021-06-09 04:23:31 | Eswatini | |||
2021-06-06 | Japan | Port Quarantine | 2998 | 3 | 2901 | 94 | 2021-06-07 04:22:51 | Port Quarantine, Japan | ||||
2021-06-03 | Canada | Newfoundland and Labrador | 1340 | 6 | 1240 | 94 | 53.1355 | -57.6604 | 2021-06-04 04:23:37 | Newfoundland and Labrador, Canada | ||
2021-06-02 | Canada | Newfoundland and Labrador | 1334 | 6 | 1234 | 94 | 53.1355 | -57.6604 | 2021-06-03 04:23:32 | Newfoundland and Labrador, Canada | ||
2021-06-01 | Russia | Magadan Oblast | 8466 | 110 | 8262 | 94 | 62.48858785 | 153.9903764 | 2021-06-02 04:24:34 | Magadan Oblast, Russia | ||
2021-06-01 | Canada | Newfoundland and Labrador | 1317 | 6 | 1217 | 94 | 53.1355 | -57.6604 | 2021-06-02 04:24:34 | Newfoundland and Labrador, Canada | ||
2021-05-21 | Russia | Altai Republic | 16921 | 242 | 16585 | 94 | 50.7114101 | 86.8572186 | 2021-05-22 04:20:45 | Altai Republic, Russia | ||
2021-05-19 | Russia | Magadan Oblast | 8408 | 105 | 8209 | 94 | 62.48858785 | 153.9903764 | 2021-05-20 04:21:05 | Magadan Oblast, Russia | ||
2021-05-14 | Pakistan | Gilgit-Baltistan | 5417 | 107 | 5216 | 94 | 35.792146 | 74.982138 | 2021-05-15 04:20:58 | Gilgit-Baltistan, Pakistan | ||
2021-05-13 | Netherlands | Aruba | 10826 | 104 | 10628 | 94 | 12.5211 | -69.9683 | 2021-05-14 04:20:41 | Aruba, Netherlands | ||
2021-05-08 | Malaysia | W.P. Putrajaya | 1439 | 9 | 1336 | 94 | 2.9264 | 101.6964 | 2021-05-09 04:20:35 | W.P. Putrajaya, Malaysia | ||
2021-05-02 | Japan | Kochi | 1067 | 20 | 953 | 94 | 33.422519 | 133.367307 | 2021-05-03 04:20:39 | Kochi, Japan | ||
2021-04-25 | Bhutan | 1022 | 1 | 927 | 94 | 27.5142 | 90.4336 | 2021-04-26 04:21:04 | Bhutan | |||
2021-04-14 | Japan | Tottori | 317 | 2 | 221 | 94 | 35.359069 | 133.863619 | 2021-04-15 04:20:54 | Tottori, Japan | ||
2021-04-11 | Russia | Magadan Oblast | 8276 | 99 | 8083 | 94 | 62.48858785 | 153.9903764 | 2021-04-12 04:21:00 | Magadan Oblast, Russia | ||
2021-04-07 | Colombia | Arauca | 5800 | 173 | 5533 | 94 | 7.0762 | -70.7105 | 2021-04-08 04:21:13 | Arauca, Colombia | ||
2021-03-27 | Japan | Nara | 3542 | 52 | 3396 | 94 | 34.317451 | 135.871644 | 2021-03-28 05:28:10 | Nara, Japan | ||
2021-03-24 | Colombia | Choco | 6650 | 204 | 6352 | 94 | 5.2528 | -76.82600000000002 | 2021-03-25 05:27:00 | Choco, Colombia | ||
2021-03-15 | Malaysia | Perlis | 320 | 2 | 224 | 94 | 6.4449 | 100.2048 | 2021-03-16 05:25:13 | Perlis, Malaysia | ||
2021-03-10 | Trinidad and Tobago | 7743 | 140 | 7509 | 94 | 10.6918 | -61.2225 | 2021-03-11 05:25:48 | Trinidad and Tobago | |||
2021-03-08 | Belize | 12335 | 315 | 11926 | 94 | 17.1899 | -88.4976 | 2021-03-09 05:28:19 | Belize | |||
2021-03-07 | Belize | 12335 | 315 | 11926 | 94 | 17.1899 | -88.4976 | 2021-03-08 05:24:48 | Belize | |||
2021-03-06 | Chile | Aysen | 3160 | 25 | 3041 | 94 | -45.9864 | -73.7669 | 2021-03-07 05:21:54 | Aysen, Chile | ||
2021-03-06 | Belize | 12335 | 315 | 11926 | 94 | 17.1899 | -88.4976 | 2021-03-07 05:21:54 | Belize | |||
2021-03-05 | Belize | 12335 | 315 | 11926 | 94 | 17.1899 | -88.4976 | 2021-03-06 04:23:41 | Belize | |||
2021-02-28 | Japan | Niigata | 1080 | 15 | 971 | 94 | 37.521819 | 138.918647 | 2021-03-01 05:23:01 | Niigata, Japan | ||
2021-02-24 | Russia | Jewish Autonomous Okrug | 4308 | 118 | 4096 | 94 | 48.57527615 | 132.66307460000002 | 2021-02-25 05:24:57 | Jewish Autonomous Okrug, Russia | ||
2021-02-24 | Liechtenstein | 2633 | 55 | 2484 | 94 | 47.14 | 9.55 | 2021-02-25 05:24:57 | Liechtenstein | |||
2021-02-24 | Chile | Aysen | 3008 | 24 | 2890 | 94 | -45.9864 | -73.7669 | 2021-02-25 05:24:57 | Aysen, Chile | ||
2021-02-15 | Japan | Miyagi | 3510 | 23 | 3393 | 94 | 38.446859 | 140.927086 | 2021-02-16 05:24:38 | Miyagi, Japan | ||
2021-02-14 | Russia | Jewish Autonomous Okrug | 4269 | 111 | 4064 | 94 | 48.57527615 | 132.66307460000002 | 2021-02-15 05:24:49 | Jewish Autonomous Okrug, Russia | ||
2021-02-14 | Colombia | Choco | 6489 | 196 | 6199 | 94 | 5.2528 | -76.82600000000002 | 2021-02-15 05:24:49 | Choco, Colombia | ||
2021-02-12 | Netherlands | Sint Maarten | 1991 | 27 | 1870 | 94 | 18.0425 | -63.0548 | 2021-02-13 05:22:12 | Sint Maarten, Netherlands | ||
2021-02-12 | Japan | Wakayama | 1140 | 16 | 1030 | 94 | 33.911879 | 135.505446 | 2021-02-13 05:22:12 | Wakayama, Japan | ||
2021-02-12 | Japan | Kagoshima | 1705 | 20 | 1591 | 94 | 31.009484000000004 | 130.430665 | 2021-02-13 05:22:12 | Kagoshima, Japan | ||
2021-02-09 | Japan | Kagoshima | 1675 | 19 | 1562 | 94 | 31.009484000000004 | 130.430665 | 2021-02-10 05:22:41 | Kagoshima, Japan | ||
2021-02-06 | US | Texas | Irion | 48235 | 91 | 1 | 0 | 94 | 31.30375559 | -100.982439 | 2021-02-07 05:23:00 | Irion, Texas, US |
2021-02-06 | Antigua and Barbuda | 288 | 7 | 187 | 94 | 17.0608 | -61.7964 | 2021-02-07 05:23:00 | Antigua and Barbuda | |||
2021-02-05 | US | Texas | Foard | 48155 | 78 | 7 | 0 | 94 | 33.97308618 | -99.7767797 | 2021-02-06 05:23:55 | Foard, Texas, US |
2021-02-04 | Malaysia | W.P. Labuan | 2176 | 12 | 2070 | 94 | 5.2831 | 115.2308 | 2021-02-05 05:22:38 | W.P. Labuan, Malaysia | ||
2021-02-03 | Liberia | 1944 | 84 | 1766 | 94 | 6.4280550000000005 | -9.429499 | 2021-02-04 05:22:26 | Liberia | |||
2021-01-31 | US | Washington | San Juan | 53055 | 94 | 0 | 0 | 94 | 48.60182783 | -122.96745 | 2021-02-01 05:22:53 | San Juan, Washington, US |
2021-01-31 | Japan | Port Quarantine | 2155 | 2 | 2059 | 94 | 2021-02-01 05:22:53 | Port Quarantine, Japan | ||||
2021-01-30 | US | Washington | San Juan | 53055 | 94 | 0 | 0 | 94 | 48.60182783 | -122.96745 | 2021-01-31 05:22:42 | San Juan, Washington, US |
2021-01-30 | Japan | Port Quarantine | 2155 | 2 | 2059 | 94 | 2021-01-31 05:22:42 | Port Quarantine, Japan | ||||
2021-01-30 | India | Sikkim | 6088 | 133 | 5861 | 94 | 27.571671 | 88.472712 | 2021-01-31 05:22:42 | Sikkim, India | ||
2021-01-25 | US | Texas | Sterling | 48431 | 90 | 4 | 0 | 94 | 31.82781912 | -101.0500746 | 2021-01-26 05:22:02 | Sterling, Texas, US |
2021-01-24 | US | Texas | Sterling | 48431 | 90 | 4 | 0 | 94 | 31.82781912 | -101.0500746 | 2021-01-25 05:22:16 | Sterling, Texas, US |
2021-01-24 | Netherlands | Curacao | 4548 | 20 | 4434 | 94 | 12.1696 | -68.99 | 2021-01-25 05:22:16 | Curacao, Netherlands | ||
2021-01-24 | Brazil | Piaui | 155723 | 3012 | 152264 | 94 | -7.7183 | -42.7289 | 2021-01-25 05:22:16 | Piaui, Brazil | ||
2021-01-23 | Malaysia | W.P. Labuan | 1982 | 9 | 1879 | 94 | 5.2831 | 115.2308 | 2021-01-24 05:22:35 | W.P. Labuan, Malaysia | ||
2021-01-23 | US | Texas | Sterling | 48431 | 90 | 4 | 0 | 94 | 31.82781912 | -101.0500746 | 2021-01-24 05:22:35 | Sterling, Texas, US |
2021-01-23 | Taiwan* | 884 | 7 | 783 | 94 | 23.7 | 121.0 | 2021-01-24 05:22:35 | Taiwan* | |||
2021-01-22 | US | Texas | Sterling | 48431 | 90 | 4 | 0 | 94 | 31.82781912 | -101.0500746 | 2021-01-23 05:22:03 | Sterling, Texas, US |
2021-01-21 | US | Texas | Sterling | 48431 | 90 | 4 | 0 | 94 | 31.82781912 | -101.0500746 | 2021-01-22 05:22:10 | Sterling, Texas, US |
2021-01-20 | US | Oregon | Wallowa | 41063 | 97 | 3 | 0 | 94 | 45.57894064 | -117.18353799999998 | 2021-01-21 05:22:01 | Wallowa, Oregon, US |
2021-01-20 | Taiwan* | 870 | 7 | 769 | 94 | 23.7 | 121.0 | 2021-01-21 05:22:01 | Taiwan* | |||
2021-01-18 | US | Georgia | Taliaferro | 13265 | 94 | 0 | 0 | 94 | 33.56543317 | -82.88136816 | 2021-01-19 05:22:15 | Taliaferro, Georgia, US |
2021-01-16 | US | Texas | Glasscock | 48173 | 86 | 1 | 0 | 94 | 31.86942909 | -101.5207776 | 2021-01-17 05:22:17 | Glasscock, Texas, US |
2021-01-14 | Japan | Aomori | 607 | 8 | 505 | 94 | 40.781541 | 140.828896 | 2021-01-15 05:22:24 | Aomori, Japan | ||
2021-01-12 | India | Mizoram | 4303 | 9 | 4200 | 94 | 23.309381 | 92.83822 | 2021-01-13 05:22:15 | Mizoram, India | ||
2021-01-10 | Netherlands | Sint Maarten | 1555 | 27 | 1434 | 94 | 18.0425 | -63.0548 | 2021-01-11 05:21:50 | Sint Maarten, Netherlands | ||
2021-01-09 | United Kingdom | Bermuda | 646 | 12 | 540 | 94 | 32.3078 | -64.7505 | 2021-01-10 05:22:12 | Bermuda, United Kingdom | ||
2021-01-07 | United Kingdom | Bermuda | 636 | 11 | 531 | 94 | 32.3078 | -64.7505 | 2021-01-08 05:22:42 | Bermuda, United Kingdom | ||
2021-01-07 | US | Texas | Glasscock | 48173 | 86 | 1 | 0 | 94 | 31.86942909 | -101.5207776 | 2021-01-08 05:22:42 | Glasscock, Texas, US |
2021-01-07 | US | Nebraska | Garden | 31069 | 95 | 1 | 0 | 94 | 41.61703149 | -102.3313973 | 2021-01-08 05:22:42 | Garden, Nebraska, US |
2021-01-07 | US | Kansas | Greeley | 20071 | 95 | 1 | 0 | 94 | 38.4808095 | -101.8061079 | 2021-01-08 05:22:42 | Greeley, Kansas, US |
2021-01-06 | US | Texas | Glasscock | 48173 | 86 | 1 | 0 | 94 | 31.86942909 | -101.5207776 | 2021-01-07 05:22:03 | Glasscock, Texas, US |
2021-01-06 | US | Nebraska | Garden | 31069 | 95 | 1 | 0 | 94 | 41.61703149 | -102.3313973 | 2021-01-07 05:22:03 | Garden, Nebraska, US |
2021-01-06 | US | Kansas | Greeley | 20071 | 95 | 1 | 0 | 94 | 38.4808095 | -101.8061079 | 2021-01-07 05:22:03 | Greeley, Kansas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;