daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
849 rows where active = 233 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 745
- Japan 14
- Colombia 9
- Russia 8
- Mexico 6
- Ukraine 6
- Malaysia 5
- Germany 4
- Italy 4
- Togo 4
- Uruguay 3
- Albania 2
- Burkina Faso 2
- Chile 2
- Gambia 2
- Guinea 2
- Liechtenstein 2
- Netherlands 2
- Singapore 2
- Tanzania 2
- Antigua and Barbuda 1
- Armenia 1
- Australia 1
- Brazil 1
- Congo (Kinshasa) 1
- Fiji 1
- Finland 1
- Iceland 1
- India 1
- Kyrgyzstan 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-16 | Ukraine | Luhansk Oblast | 26829 | 960 | 25636 | 233 | 48.574 | 39.3078 | 2021-07-17 04:22:22 | Luhansk Oblast, Ukraine | ||
2021-07-16 | Italy | Friuli Venezia Giulia | 107214 | 3789 | 103192 | 233 | 45.6494354 | 13.76813649 | 2021-07-17 04:22:22 | Friuli Venezia Giulia, Italy | ||
2021-07-14 | Japan | Miyagi | 9403 | 91 | 9079 | 233 | 38.446859 | 140.927086 | 2021-07-15 04:21:48 | Miyagi, Japan | ||
2021-07-12 | Ukraine | Khmelnytskyi Oblast | 89022 | 1881 | 86908 | 233 | 49.423 | 26.9871 | 2021-07-13 04:21:18 | Khmelnytskyi Oblast, Ukraine | ||
2021-07-02 | Germany | Sachsen-Anhalt | 99243 | 3428 | 95620 | 233 | 51.9503 | 11.6923 | 2021-07-03 04:21:37 | Sachsen-Anhalt, Germany | ||
2021-06-25 | North Macedonia | 155663 | 5484 | 149946 | 233 | 41.6086 | 21.7453 | 2021-06-26 04:21:43 | North Macedonia | |||
2021-06-18 | Saint Kitts and Nevis | 304 | 1 | 70 | 233 | 17.357822 | -62.782998 | 2021-06-19 04:22:33 | Saint Kitts and Nevis | |||
2021-06-17 | Japan | Tochigi | 6739 | 80 | 6426 | 233 | 36.689912 | 139.819213 | 2021-06-18 04:22:16 | Tochigi, Japan | ||
2021-06-10 | Japan | Yamaguchi | 3045 | 69 | 2743 | 233 | 34.201190000000004 | 131.573293 | 2021-06-11 04:23:20 | Yamaguchi, Japan | ||
2021-06-02 | Japan | Fukushima | 4602 | 144 | 4225 | 233 | 37.378867 | 140.223295 | 2021-06-03 04:23:32 | Fukushima, Japan | ||
2021-05-30 | Russia | Kabardino-Balkarian Republic | 24313 | 467 | 23613 | 233 | 43.4806048 | 43.5978976 | 2021-05-31 03:08:59 | Kabardino-Balkarian Republic, Russia | ||
2021-05-30 | Japan | Nara | 7752 | 115 | 7404 | 233 | 34.317451 | 135.871644 | 2021-05-31 03:08:59 | Nara, Japan | ||
2021-05-30 | Fiji | 401 | 4 | 164 | 233 | -17.7134 | 178.065 | 2021-05-31 03:08:59 | Fiji | |||
2021-05-29 | Russia | Ingushetia Republic | 15754 | 189 | 15332 | 233 | 43.11542075 | 45.01713552 | 2021-05-30 04:20:55 | Ingushetia Republic, Russia | ||
2021-05-27 | Japan | Yamagata | 1932 | 40 | 1659 | 233 | 38.448396 | 140.102154 | 2021-05-28 04:20:36 | Yamagata, Japan | ||
2021-05-24 | Russia | Kabardino-Balkarian Republic | 24225 | 466 | 23526 | 233 | 43.4806048 | 43.5978976 | 2021-05-25 04:21:08 | Kabardino-Balkarian Republic, Russia | ||
2021-05-23 | Russia | Kabardino-Balkarian Republic | 24209 | 466 | 23510 | 233 | 43.4806048 | 43.5978976 | 2021-05-24 04:20:53 | Kabardino-Balkarian Republic, Russia | ||
2021-05-21 | Italy | Molise | 13544 | 488 | 12823 | 233 | 41.55774754 | 14.65916051 | 2021-05-22 04:20:45 | Molise, Italy | ||
2021-05-21 | Colombia | Caqueta | 17886 | 669 | 16984 | 233 | 0.8699 | -73.8419 | 2021-05-22 04:20:45 | Caqueta, Colombia | ||
2021-05-17 | Colombia | Caqueta | 17808 | 666 | 16909 | 233 | 0.8699 | -73.8419 | 2021-05-18 04:20:33 | Caqueta, Colombia | ||
2021-05-04 | Japan | Saga | 1702 | 14 | 1455 | 233 | 33.286977 | 130.115738 | 2021-05-05 04:20:43 | Saga, Japan | ||
2021-04-19 | Japan | Mie | 3189 | 75 | 2881 | 233 | 34.508018 | 136.376013 | 2021-04-20 04:20:41 | Mie, Japan | ||
2021-04-17 | Malaysia | Terengganu | 3881 | 14 | 3634 | 233 | 5.3117 | 103.1324 | 2021-04-18 04:20:41 | Terengganu, Malaysia | ||
2021-04-16 | Japan | Tochigi | 5027 | 70 | 4724 | 233 | 36.689912 | 139.819213 | 2021-04-17 04:20:40 | Tochigi, Japan | ||
2021-04-16 | Antigua and Barbuda | 1213 | 31 | 949 | 233 | 17.0608 | -61.7964 | 2021-04-17 04:20:40 | Antigua and Barbuda | |||
2021-03-30 | Japan | Kyoto | 9460 | 169 | 9058 | 233 | 35.253815 | 135.443341 | 2021-03-31 04:26:25 | Kyoto, Japan | ||
2021-03-20 | Gambia | 5153 | 160 | 4760 | 233 | 13.4432 | -15.3101 | 2021-03-21 05:25:44 | Gambia | |||
2021-03-19 | Gambia | 5153 | 160 | 4760 | 233 | 13.4432 | -15.3101 | 2021-03-20 05:25:46 | Gambia | |||
2021-03-17 | Japan | Shizuoka | 5437 | 107 | 5097 | 233 | 34.916975 | 138.40778400000002 | 2021-03-18 05:26:22 | Shizuoka, Japan | ||
2021-03-06 | US | Kansas | Kiowa | 20097 | 237 | 4 | 0 | 233 | 37.55848695 | -99.2856537 | 2021-03-07 05:21:54 | Kiowa, Kansas, US |
2021-03-05 | US | Kansas | Kiowa | 20097 | 237 | 4 | 0 | 233 | 37.55848695 | -99.2856537 | 2021-03-06 04:23:41 | Kiowa, Kansas, US |
2021-03-04 | Malaysia | Kedah | 7690 | 22 | 7435 | 233 | 6.1184 | 100.3685 | 2021-03-05 05:26:29 | Kedah, Malaysia | ||
2021-03-04 | US | Kansas | Kiowa | 20097 | 237 | 4 | 0 | 233 | 37.55848695 | -99.2856537 | 2021-03-05 05:26:29 | Kiowa, Kansas, US |
2021-03-03 | US | Kansas | Kiowa | 20097 | 237 | 4 | 0 | 233 | 37.55848695 | -99.2856537 | 2021-03-04 05:24:24 | Kiowa, Kansas, US |
2021-03-02 | US | Virginia | Norton | 51720 | 239 | 6 | 0 | 233 | 36.93357076 | -82.62750411 | 2021-03-03 05:23:28 | Norton, Virginia, US |
2021-03-02 | US | Kansas | Kiowa | 20097 | 238 | 5 | 0 | 233 | 37.55848695 | -99.2856537 | 2021-03-03 05:23:28 | Kiowa, Kansas, US |
2021-03-01 | US | Virginia | Norton | 51720 | 239 | 6 | 0 | 233 | 36.93357076 | -82.62750411 | 2021-03-02 05:23:30 | Norton, Virginia, US |
2021-03-01 | US | Texas | Cochran | 48079 | 334 | 14 | 0 | 233 | 33.60425307 | -102.8284499 | 2021-03-02 05:23:30 | Cochran, Texas, US |
2021-03-01 | US | Kansas | Kiowa | 20097 | 238 | 5 | 0 | 233 | 37.55848695 | -99.2856537 | 2021-03-02 05:23:30 | Kiowa, Kansas, US |
2021-02-28 | US | Texas | Cochran | 48079 | 334 | 14 | 0 | 233 | 33.60425307 | -102.8284499 | 2021-03-01 05:23:01 | Cochran, Texas, US |
2021-02-28 | US | Kansas | Kiowa | 20097 | 238 | 5 | 0 | 233 | 37.55848695 | -99.2856537 | 2021-03-01 05:23:01 | Kiowa, Kansas, US |
2021-02-27 | US | Texas | Cochran | 48079 | 334 | 14 | 0 | 233 | 33.60425307 | -102.8284499 | 2021-02-28 05:22:20 | Cochran, Texas, US |
2021-02-27 | US | Kansas | Kiowa | 20097 | 238 | 5 | 0 | 233 | 37.55848695 | -99.2856537 | 2021-02-28 05:22:20 | Kiowa, Kansas, US |
2021-02-26 | US | Virginia | Bath | 51017 | 243 | 10 | 0 | 233 | 38.05852573 | -79.73912095 | 2021-02-27 05:22:28 | Bath, Virginia, US |
2021-02-26 | US | Kansas | Kiowa | 20097 | 238 | 5 | 0 | 233 | 37.55848695 | -99.2856537 | 2021-02-27 05:22:28 | Kiowa, Kansas, US |
2021-02-25 | US | Virginia | Craig | 51045 | 237 | 4 | 0 | 233 | 37.48133648 | -80.21072274 | 2021-02-26 05:22:40 | Craig, Virginia, US |
2021-02-25 | Colombia | La Guajira | 16110 | 633 | 15244 | 233 | 11.3548 | -72.5205 | 2021-02-26 05:22:40 | La Guajira, Colombia | ||
2021-02-24 | US | Virginia | Bath | 51017 | 242 | 9 | 0 | 233 | 38.05852573 | -79.73912095 | 2021-02-25 05:24:57 | Bath, Virginia, US |
2021-02-23 | US | South Dakota | McPherson | 46089 | 237 | 4 | 0 | 233 | 45.76626028 | -99.22118798 | 2021-02-24 05:29:16 | McPherson, South Dakota, US |
2021-02-23 | Colombia | Putumayo | 7798 | 310 | 7255 | 233 | 0.436 | -75.5277 | 2021-02-24 05:29:16 | Putumayo, Colombia | ||
2021-02-22 | US | South Dakota | McPherson | 46089 | 237 | 4 | 0 | 233 | 45.76626028 | -99.22118798 | 2021-02-23 05:23:41 | McPherson, South Dakota, US |
2021-02-22 | US | Georgia | Glascock | 13125 | 249 | 16 | 0 | 233 | 33.22879932 | -82.61297636 | 2021-02-23 05:23:41 | Glascock, Georgia, US |
2021-02-21 | US | Virginia | Craig | 51045 | 236 | 3 | 0 | 233 | 37.48133648 | -80.21072274 | 2021-02-22 05:24:21 | Craig, Virginia, US |
2021-02-21 | US | South Dakota | McPherson | 46089 | 237 | 4 | 0 | 233 | 45.76626028 | -99.22118798 | 2021-02-22 05:24:21 | McPherson, South Dakota, US |
2021-02-21 | US | Georgia | Glascock | 13125 | 249 | 16 | 0 | 233 | 33.22879932 | -82.61297636 | 2021-02-22 05:24:21 | Glascock, Georgia, US |
2021-02-21 | Russia | Magadan Oblast | 8105 | 94 | 7778 | 233 | 62.48858785 | 153.9903764 | 2021-02-22 05:24:21 | Magadan Oblast, Russia | ||
2021-02-20 | US | Virginia | Craig | 51045 | 236 | 3 | 0 | 233 | 37.48133648 | -80.21072274 | 2021-02-21 05:24:33 | Craig, Virginia, US |
2021-02-20 | US | South Dakota | McPherson | 46089 | 237 | 4 | 0 | 233 | 45.76626028 | -99.22118798 | 2021-02-21 05:24:33 | McPherson, South Dakota, US |
2021-02-20 | US | Puerto Rico | Guayanilla | 72059 | 233 | 0 | 0 | 233 | 18.039942 | -66.79186 | 2021-02-21 05:24:33 | Guayanilla, Puerto Rico, US |
2021-02-19 | US | South Dakota | McPherson | 46089 | 237 | 4 | 0 | 233 | 45.76626028 | -99.22118798 | 2021-02-20 05:22:51 | McPherson, South Dakota, US |
2021-02-19 | US | Puerto Rico | Out of PR | 72888 | 233 | 0 | 0 | 233 | 18.459681 | -67.336525 | 2021-02-20 05:22:51 | Out of PR, Puerto Rico, US |
2021-02-18 | US | Virginia | Bath | 51017 | 241 | 8 | 0 | 233 | 38.05852573 | -79.73912095 | 2021-02-19 05:24:16 | Bath, Virginia, US |
2021-02-18 | US | South Dakota | McPherson | 46089 | 237 | 4 | 0 | 233 | 45.76626028 | -99.22118798 | 2021-02-19 05:24:16 | McPherson, South Dakota, US |
2021-02-18 | US | Puerto Rico | Out of PR | 72888 | 233 | 0 | 0 | 233 | 18.459681 | -67.336525 | 2021-02-19 05:24:16 | Out of PR, Puerto Rico, US |
2021-02-17 | US | South Dakota | McPherson | 46089 | 237 | 4 | 0 | 233 | 45.76626028 | -99.22118798 | 2021-02-18 05:22:58 | McPherson, South Dakota, US |
2021-02-17 | US | Puerto Rico | Out of PR | 72888 | 233 | 0 | 0 | 233 | 18.459681 | -67.336525 | 2021-02-18 05:22:58 | Out of PR, Puerto Rico, US |
2021-02-17 | Colombia | Putumayo | 7728 | 307 | 7188 | 233 | 0.436 | -75.5277 | 2021-02-18 05:22:58 | Putumayo, Colombia | ||
2021-02-16 | US | South Dakota | McPherson | 46089 | 237 | 4 | 0 | 233 | 45.76626028 | -99.22118798 | 2021-02-17 05:23:10 | McPherson, South Dakota, US |
2021-02-16 | US | Puerto Rico | Out of PR | 72888 | 233 | 0 | 0 | 233 | 18.459681 | -67.336525 | 2021-02-17 05:23:10 | Out of PR, Puerto Rico, US |
2021-02-16 | US | Kansas | Chase | 20017 | 236 | 3 | 0 | 233 | 38.30292938 | -96.59563862 | 2021-02-17 05:23:10 | Chase, Kansas, US |
2021-02-15 | US | South Dakota | McPherson | 46089 | 237 | 4 | 0 | 233 | 45.76626028 | -99.22118798 | 2021-02-16 05:24:38 | McPherson, South Dakota, US |
2021-02-15 | US | Puerto Rico | Out of PR | 72888 | 233 | 0 | 0 | 233 | 18.459681 | -67.336525 | 2021-02-16 05:24:38 | Out of PR, Puerto Rico, US |
2021-02-15 | US | Kansas | Chase | 20017 | 236 | 3 | 0 | 233 | 38.30292938 | -96.59563862 | 2021-02-16 05:24:38 | Chase, Kansas, US |
2021-02-14 | US | South Dakota | McPherson | 46089 | 237 | 4 | 0 | 233 | 45.76626028 | -99.22118798 | 2021-02-15 05:24:49 | McPherson, South Dakota, US |
2021-02-14 | US | Puerto Rico | Out of PR | 72888 | 233 | 0 | 0 | 233 | 18.459681 | -67.336525 | 2021-02-15 05:24:49 | Out of PR, Puerto Rico, US |
2021-02-14 | US | Kansas | Chase | 20017 | 236 | 3 | 0 | 233 | 38.30292938 | -96.59563862 | 2021-02-15 05:24:49 | Chase, Kansas, US |
2021-02-14 | Colombia | Putumayo | 7705 | 305 | 7167 | 233 | 0.436 | -75.5277 | 2021-02-15 05:24:49 | Putumayo, Colombia | ||
2021-02-13 | US | South Dakota | McPherson | 46089 | 237 | 4 | 0 | 233 | 45.76626028 | -99.22118798 | 2021-02-14 05:23:43 | McPherson, South Dakota, US |
2021-02-13 | US | Puerto Rico | Out of PR | 72888 | 233 | 0 | 0 | 233 | 18.459681 | -67.336525 | 2021-02-14 05:23:43 | Out of PR, Puerto Rico, US |
2021-02-13 | US | Kansas | Chase | 20017 | 236 | 3 | 0 | 233 | 38.30292938 | -96.59563862 | 2021-02-14 05:23:43 | Chase, Kansas, US |
2021-02-13 | US | Colorado | Ouray | 8091 | 249 | 3 | 0 | 233 | 38.14717457 | -107.7675136 | 2021-02-14 05:23:43 | Ouray, Colorado, US |
2021-02-12 | US | South Dakota | McPherson | 46089 | 237 | 4 | 0 | 233 | 45.76626028 | -99.22118798 | 2021-02-13 05:22:12 | McPherson, South Dakota, US |
2021-02-12 | US | Puerto Rico | Out of PR | 72888 | 233 | 0 | 0 | 233 | 18.459681 | -67.336525 | 2021-02-13 05:22:12 | Out of PR, Puerto Rico, US |
2021-02-12 | US | Kansas | Chase | 20017 | 236 | 3 | 0 | 233 | 38.30292938 | -96.59563862 | 2021-02-13 05:22:12 | Chase, Kansas, US |
2021-02-12 | US | Colorado | Ouray | 8091 | 247 | 3 | 0 | 233 | 38.14717457 | -107.7675136 | 2021-02-13 05:22:12 | Ouray, Colorado, US |
2021-02-11 | US | South Dakota | McPherson | 46089 | 237 | 4 | 0 | 233 | 45.76626028 | -99.22118798 | 2021-02-12 05:23:29 | McPherson, South Dakota, US |
2021-02-11 | US | Puerto Rico | Out of PR | 72888 | 233 | 0 | 0 | 233 | 18.459681 | -67.336525 | 2021-02-12 05:23:29 | Out of PR, Puerto Rico, US |
2021-02-10 | US | South Dakota | McPherson | 46089 | 237 | 4 | 0 | 233 | 45.76626028 | -99.22118798 | 2021-02-11 05:23:55 | McPherson, South Dakota, US |
2021-02-10 | US | Puerto Rico | Out of PR | 72888 | 233 | 0 | 0 | 233 | 18.459681 | -67.336525 | 2021-02-11 05:23:55 | Out of PR, Puerto Rico, US |
2021-02-09 | US | South Dakota | McPherson | 46089 | 237 | 4 | 0 | 233 | 45.76626028 | -99.22118798 | 2021-02-10 05:22:41 | McPherson, South Dakota, US |
2021-02-09 | US | Maine | Piscataquis | 23021 | 234 | 1 | 0 | 233 | 45.83839062 | -69.2860223 | 2021-02-10 05:22:41 | Piscataquis, Maine, US |
2021-02-08 | San Marino | 3137 | 69 | 2835 | 233 | 43.9424 | 12.4578 | 2021-02-09 05:23:30 | San Marino | |||
2021-02-08 | Japan | Shiga | 2251 | 33 | 1985 | 233 | 35.21582700000001 | 136.138064 | 2021-02-09 05:23:30 | Shiga, Japan | ||
2021-02-07 | US | Puerto Rico | Sabana Grande | 72121 | 233 | 0 | 0 | 233 | 18.08282 | -66.943758 | 2021-02-08 05:22:39 | Sabana Grande, Puerto Rico, US |
2021-02-05 | US | South Dakota | Haakon | 46055 | 242 | 9 | 0 | 233 | 44.29299053 | -101.539099 | 2021-02-06 05:23:55 | Haakon, South Dakota, US |
2021-02-04 | US | South Dakota | Haakon | 46055 | 242 | 9 | 0 | 233 | 44.29299053 | -101.539099 | 2021-02-05 05:22:38 | Haakon, South Dakota, US |
2021-02-04 | US | Kansas | Chautauqua | 20019 | 238 | 5 | 0 | 233 | 37.14994405 | -96.2454192 | 2021-02-05 05:22:38 | Chautauqua, Kansas, US |
2021-02-03 | US | Virginia | Bath | 51017 | 241 | 8 | 0 | 233 | 38.05852573 | -79.73912095 | 2021-02-04 05:22:26 | Bath, Virginia, US |
2021-02-03 | US | Kansas | Chautauqua | 20019 | 238 | 5 | 0 | 233 | 37.14994405 | -96.2454192 | 2021-02-04 05:22:26 | Chautauqua, Kansas, US |
2021-01-31 | Italy | Valle d'Aosta | 7797 | 404 | 7160 | 233 | 45.73750286 | 7.320149366 | 2021-02-01 05:22:53 | Valle d'Aosta, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;