johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
706 rows where active = 276 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 610
- Japan 14
- Russia 12
- Chile 8
- Colombia 8
- Gambia 7
- Mexico 5
- Canada 4
- Italy 4
- Malaysia 3
- Ukraine 3
- Congo (Kinshasa) 2
- Eritrea 2
- Germany 2
- India 2
- San Marino 2
- Senegal 2
- Vietnam 2
- Andorra 1
- Australia 1
- Bangladesh 1
- Belize 1
- Cote d'Ivoire 1
- Cyprus 1
- Jamaica 1
- Kyrgyzstan 1
- Latvia 1
- Liechtenstein 1
- Malta 1
- Pakistan 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3385173 | 3385173 | 2021-07-29 | Chile | Atacama | 26689 | 318 | 26095 | 276 | -27.5661 | -70.0503 | 2021-07-30 04:21:34 | Atacama, Chile | ||
1330197 | 1330197 | 2021-07-24 | India | Jharkhand | 346918 | 5124 | 341518 | 276 | 23.654536 | 85.557631 | 2021-07-25 04:22:12 | Jharkhand, India | ||
3335163 | 3335163 | 2021-07-21 | Ukraine | Luhansk Oblast | 26906 | 962 | 25668 | 276 | 48.574 | 39.3078 | 2021-07-22 04:21:19 | Luhansk Oblast, Ukraine | ||
3331307 | 3331307 | 2021-07-21 | Canada | Saskatchewan | 49525 | 575 | 48674 | 276 | 52.9399 | -106.4509 | 2021-07-22 04:21:19 | Saskatchewan, Canada | ||
2371525 | 2371525 | 2021-07-20 | Japan | Ishikawa | 4260 | 115 | 3869 | 276 | 36.769464 | 136.771027 | 2021-07-21 04:21:40 | Ishikawa, Japan | ||
483383 | 483383 | 2021-07-19 | Chile | Nuble | 34960 | 604 | 34080 | 276 | -36.7226 | -71.7622 | 2021-07-20 04:21:48 | Nuble, Chile | ||
3705969 | 3705969 | 2021-07-17 | Colombia | Choco | 15475 | 378 | 14821 | 276 | 5.2528 | -76.82600000000002 | 2021-07-18 04:22:07 | Choco, Colombia | ||
829610 | 829610 | 2021-07-09 | Japan | Ibaraki | 10765 | 166 | 10323 | 276 | 36.303588 | 140.319591 | 2021-07-10 04:21:25 | Ibaraki, Japan | ||
2764842 | 2764842 | 2021-07-01 | Germany | Berlin | 180209 | 3560 | 176400 | 276 | 52.52 | 13.405 | 2021-07-02 04:21:47 | Berlin, Germany | ||
3125519 | 3125519 | 2021-06-28 | Japan | Hyogo | 40864 | 1285 | 39303 | 276 | 35.039913 | 134.828057 | 2021-06-29 04:21:28 | Hyogo, Japan | ||
2884357 | 2884357 | 2021-06-20 | Italy | P.A. Bolzano | 73254 | 1180 | 71798 | 276 | 46.49933453 | 11.35662422 | 2021-06-21 04:21:41 | P.A. Bolzano, Italy | ||
3970589 | 3970589 | 2021-06-11 | Japan | Tochigi | 6629 | 80 | 6273 | 276 | 36.689912 | 139.819213 | 2021-06-12 04:22:22 | Tochigi, Japan | ||
2717175 | 2717175 | 2021-06-10 | Russia | Kalmykia Republic | 20987 | 387 | 20324 | 276 | 46.2313018 | 45.3275745 | 2021-06-11 04:23:20 | Kalmykia Republic, Russia | ||
2717011 | 2717011 | 2021-06-10 | Japan | Tochigi | 6603 | 80 | 6247 | 276 | 36.689912 | 139.819213 | 2021-06-11 04:23:20 | Tochigi, Japan | ||
2716992 | 2716992 | 2021-06-10 | Japan | Kumamoto | 6386 | 108 | 6002 | 276 | 32.608154 | 130.74523100000002 | 2021-06-11 04:23:20 | Kumamoto, Japan | ||
1448473 | 1448473 | 2021-06-03 | Eritrea | 4145 | 14 | 3855 | 276 | 15.1794 | 39.7823 | 2021-06-04 04:23:37 | Eritrea | |||
1708197 | 1708197 | 2021-06-02 | Eritrea | 4145 | 14 | 3855 | 276 | 15.1794 | 39.7823 | 2021-06-03 04:23:32 | Eritrea | |||
2939184 | 2939184 | 2021-05-16 | Colombia | San Andres y Providencia | 4556 | 68 | 4212 | 276 | 12.5567 | -81.7185 | 2021-05-17 04:20:34 | San Andres y Providencia, Colombia | ||
3675669 | 3675669 | 2021-05-04 | Japan | Kagoshima | 2311 | 28 | 2007 | 276 | 31.009484000000004 | 130.430665 | 2021-05-05 04:20:43 | Kagoshima, Japan | ||
36300 | 36300 | 2021-04-12 | Cote d'Ivoire | 45227 | 268 | 44683 | 276 | 7.54 | -5.5471 | 2021-04-13 04:20:37 | Cote d'Ivoire | |||
3085339 | 3085339 | 2021-04-05 | Japan | Tochigi | 4777 | 70 | 4431 | 276 | 36.689912 | 139.819213 | 2021-04-06 04:20:32 | Tochigi, Japan | ||
3710411 | 3710411 | 2021-04-03 | Senegal | 38953 | 1063 | 37614 | 276 | 14.4974 | -14.4524 | 2021-04-04 04:20:49 | Senegal | |||
3709980 | 3709980 | 2021-04-03 | Colombia | Casanare | 13150 | 305 | 12569 | 276 | 5.7589 | -71.5724 | 2021-04-04 04:20:49 | Casanare, Colombia | ||
244931 | 244931 | 2021-04-02 | Malaysia | Melaka | 6568 | 22 | 6270 | 276 | 2.1896 | 102.2501 | 2021-04-03 04:20:44 | Melaka, Malaysia | ||
637931 | 637931 | 2021-03-31 | Japan | Fukushima | 2499 | 113 | 2110 | 276 | 37.378867 | 140.223295 | 2021-04-01 04:27:05 | Fukushima, Japan | ||
2784656 | 2784656 | 2021-03-24 | Vietnam | 2576 | 35 | 2265 | 276 | 14.058324 | 108.277199 | 2021-03-25 05:27:00 | Vietnam | |||
1207481 | 1207481 | 2021-03-22 | Malaysia | Kedah | 8117 | 24 | 7817 | 276 | 6.1184 | 100.3685 | 2021-03-23 05:26:18 | Kedah, Malaysia | ||
1203814 | 1203814 | 2021-03-22 | Japan | Fukushima | 2327 | 104 | 1947 | 276 | 37.378867 | 140.223295 | 2021-03-23 05:26:18 | Fukushima, Japan | ||
3369536 | 3369536 | 2021-03-21 | Russia | Kemerovo Oblast | 32780 | 595 | 31909 | 276 | 54.53357809999999 | 87.342861 | 2021-03-22 05:25:43 | Kemerovo Oblast, Russia | ||
1748213 | 1748213 | 2021-03-20 | Malaysia | Kedah | 8060 | 24 | 7760 | 276 | 6.1184 | 100.3685 | 2021-03-21 05:25:44 | Kedah, Malaysia | ||
3452762 | 3452762 | 2021-03-18 | Gambia | 5122 | 160 | 4686 | 276 | 13.4432 | -15.3101 | 2021-03-19 05:26:09 | Gambia | |||
3670698 | 3670698 | 2021-03-06 | US | Texas | Fisher | 48151 | 314 | 14 | 0 | 276 | 32.74281316 | -100.4019302 | 2021-03-07 05:21:54 | Fisher, Texas, US |
3669608 | 3669608 | 2021-03-06 | US | Montana | Fallon | 30025 | 278 | 2 | 0 | 276 | 46.33478338 | -104.4183565 | 2021-03-07 05:21:54 | Fallon, Montana, US |
3668940 | 3668940 | 2021-03-06 | US | Kansas | Osborne | 20141 | 287 | 11 | 0 | 276 | 39.3503437 | -98.76753828 | 2021-03-07 05:21:54 | Osborne, Kansas, US |
1619319 | 1619319 | 2021-03-05 | US | Texas | Fisher | 48151 | 314 | 14 | 0 | 276 | 32.74281316 | -100.4019302 | 2021-03-06 04:23:41 | Fisher, Texas, US |
1618229 | 1618229 | 2021-03-05 | US | Montana | Fallon | 30025 | 278 | 2 | 0 | 276 | 46.33478338 | -104.4183565 | 2021-03-06 04:23:41 | Fallon, Montana, US |
1617561 | 1617561 | 2021-03-05 | US | Kansas | Osborne | 20141 | 287 | 11 | 0 | 276 | 39.3503437 | -98.76753828 | 2021-03-06 04:23:41 | Osborne, Kansas, US |
1616450 | 1616450 | 2021-03-05 | Russia | Kemerovo Oblast | 31939 | 560 | 31103 | 276 | 54.53357809999999 | 87.342861 | 2021-03-06 04:23:41 | Kemerovo Oblast, Russia | ||
2210730 | 2210730 | 2021-03-04 | US | Texas | Fisher | 48151 | 314 | 14 | 0 | 276 | 32.74281316 | -100.4019302 | 2021-03-05 05:26:29 | Fisher, Texas, US |
2209640 | 2209640 | 2021-03-04 | US | Montana | Fallon | 30025 | 278 | 2 | 0 | 276 | 46.33478338 | -104.4183565 | 2021-03-05 05:26:29 | Fallon, Montana, US |
2208972 | 2208972 | 2021-03-04 | US | Kansas | Osborne | 20141 | 287 | 11 | 0 | 276 | 39.3503437 | -98.76753828 | 2021-03-05 05:26:29 | Osborne, Kansas, US |
1093151 | 1093151 | 2021-03-03 | US | Texas | Fisher | 48151 | 314 | 14 | 0 | 276 | 32.74281316 | -100.4019302 | 2021-03-04 05:24:24 | Fisher, Texas, US |
1092061 | 1092061 | 2021-03-03 | US | Montana | Fallon | 30025 | 278 | 2 | 0 | 276 | 46.33478338 | -104.4183565 | 2021-03-04 05:24:24 | Fallon, Montana, US |
1091393 | 1091393 | 2021-03-03 | US | Kansas | Osborne | 20141 | 287 | 11 | 0 | 276 | 39.3503437 | -98.76753828 | 2021-03-04 05:24:24 | Osborne, Kansas, US |
1089765 | 1089765 | 2021-03-03 | Andorra | 10948 | 112 | 10560 | 276 | 42.5063 | 1.5218 | 2021-03-04 05:24:24 | Andorra | |||
3257223 | 3257223 | 2021-03-02 | US | Texas | Fisher | 48151 | 314 | 14 | 0 | 276 | 32.74281316 | -100.4019302 | 2021-03-03 05:23:28 | Fisher, Texas, US |
3256133 | 3256133 | 2021-03-02 | US | Montana | Fallon | 30025 | 278 | 2 | 0 | 276 | 46.33478338 | -104.4183565 | 2021-03-03 05:23:28 | Fallon, Montana, US |
3255465 | 3255465 | 2021-03-02 | US | Kansas | Osborne | 20141 | 287 | 11 | 0 | 276 | 39.3503437 | -98.76753828 | 2021-03-03 05:23:28 | Osborne, Kansas, US |
1000425 | 1000425 | 2021-03-01 | US | Montana | Fallon | 30025 | 278 | 2 | 0 | 276 | 46.33478338 | -104.4183565 | 2021-03-02 05:23:30 | Fallon, Montana, US |
999757 | 999757 | 2021-03-01 | US | Kansas | Osborne | 20141 | 287 | 11 | 0 | 276 | 39.3503437 | -98.76753828 | 2021-03-02 05:23:30 | Osborne, Kansas, US |
2369483 | 2369483 | 2021-02-28 | US | Montana | Fallon | 30025 | 278 | 2 | 0 | 276 | 46.33478338 | -104.4183565 | 2021-03-01 05:23:01 | Fallon, Montana, US |
2368815 | 2368815 | 2021-02-28 | US | Kansas | Osborne | 20141 | 286 | 10 | 0 | 276 | 39.3503437 | -98.76753828 | 2021-03-01 05:23:01 | Osborne, Kansas, US |
3067985 | 3067985 | 2021-02-27 | US | Montana | Fallon | 30025 | 278 | 2 | 0 | 276 | 46.33478338 | -104.4183565 | 2021-02-28 05:22:20 | Fallon, Montana, US |
3067317 | 3067317 | 2021-02-27 | US | Kansas | Osborne | 20141 | 286 | 10 | 0 | 276 | 39.3503437 | -98.76753828 | 2021-02-28 05:22:20 | Osborne, Kansas, US |
2185569 | 2185569 | 2021-02-26 | US | Montana | Fallon | 30025 | 278 | 2 | 0 | 276 | 46.33478338 | -104.4183565 | 2021-02-27 05:22:28 | Fallon, Montana, US |
2184901 | 2184901 | 2021-02-26 | US | Kansas | Osborne | 20141 | 286 | 10 | 0 | 276 | 39.3503437 | -98.76753828 | 2021-02-27 05:22:28 | Osborne, Kansas, US |
1859991 | 1859991 | 2021-02-25 | US | Montana | Fallon | 30025 | 278 | 2 | 0 | 276 | 46.33478338 | -104.4183565 | 2021-02-26 05:22:40 | Fallon, Montana, US |
1859323 | 1859323 | 2021-02-25 | US | Kansas | Osborne | 20141 | 286 | 10 | 0 | 276 | 39.3503437 | -98.76753828 | 2021-02-26 05:22:40 | Osborne, Kansas, US |
282169 | 282169 | 2021-02-24 | US | Montana | Fallon | 30025 | 278 | 2 | 0 | 276 | 46.33478338 | -104.4183565 | 2021-02-25 05:24:57 | Fallon, Montana, US |
281501 | 281501 | 2021-02-24 | US | Kansas | Osborne | 20141 | 286 | 10 | 0 | 276 | 39.3503437 | -98.76753828 | 2021-02-25 05:24:57 | Osborne, Kansas, US |
1937769 | 1937769 | 2021-02-23 | US | Kansas | Osborne | 20141 | 286 | 10 | 0 | 276 | 39.3503437 | -98.76753828 | 2021-02-24 05:29:16 | Osborne, Kansas, US |
532024 | 532024 | 2021-02-22 | US | Kansas | Osborne | 20141 | 286 | 10 | 0 | 276 | 39.3503437 | -98.76753828 | 2021-02-23 05:23:41 | Osborne, Kansas, US |
531733 | 531733 | 2021-02-22 | US | Illinois | Pope | 17151 | 279 | 3 | 0 | 276 | 37.41391284 | -88.56152109 | 2021-02-23 05:23:41 | Pope, Illinois, US |
183067 | 183067 | 2021-02-21 | US | Illinois | Pope | 17151 | 279 | 3 | 0 | 276 | 37.41391284 | -88.56152109 | 2021-02-22 05:24:21 | Pope, Illinois, US |
743341 | 743341 | 2021-02-20 | US | Illinois | Pope | 17151 | 279 | 3 | 0 | 276 | 37.41391284 | -88.56152109 | 2021-02-21 05:24:33 | Pope, Illinois, US |
742583 | 742583 | 2021-02-20 | San Marino | 3440 | 72 | 3092 | 276 | 43.9424 | 12.4578 | 2021-02-21 05:24:33 | San Marino | |||
1339302 | 1339302 | 2021-02-15 | US | Illinois | Pope | 17151 | 279 | 3 | 0 | 276 | 37.41391284 | -88.56152109 | 2021-02-16 05:24:38 | Pope, Illinois, US |
2284453 | 2284453 | 2021-02-14 | US | Illinois | Pope | 17151 | 279 | 3 | 0 | 276 | 37.41391284 | -88.56152109 | 2021-02-15 05:24:49 | Pope, Illinois, US |
2283695 | 2283695 | 2021-02-14 | San Marino | 3304 | 72 | 2956 | 276 | 43.9424 | 12.4578 | 2021-02-15 05:24:49 | San Marino | |||
2678853 | 2678853 | 2021-02-13 | US | Illinois | Pope | 17151 | 279 | 3 | 0 | 276 | 37.41391284 | -88.56152109 | 2021-02-14 05:23:43 | Pope, Illinois, US |
2677731 | 2677731 | 2021-02-13 | Gambia | 4302 | 135 | 3891 | 276 | 13.4432 | -15.3101 | 2021-02-14 05:23:43 | Gambia | |||
3539364 | 3539364 | 2021-02-12 | Gambia | 4302 | 135 | 3891 | 276 | 13.4432 | -15.3101 | 2021-02-13 05:22:12 | Gambia | |||
2640269 | 2640269 | 2021-02-11 | US | Oklahoma | Harmon | 40057 | 277 | 1 | 0 | 276 | 34.7440135 | -99.84741652 | 2021-02-12 05:23:29 | Harmon, Oklahoma, US |
2637627 | 2637627 | 2021-02-11 | Gambia | 4302 | 135 | 3891 | 276 | 13.4432 | -15.3101 | 2021-02-12 05:23:29 | Gambia | |||
3981653 | 3981653 | 2021-02-10 | US | Texas | Fisher | 48151 | 313 | 13 | 0 | 276 | 32.74281316 | -100.4019302 | 2021-02-11 05:23:55 | Fisher, Texas, US |
3981124 | 3981124 | 2021-02-10 | US | Oklahoma | Harmon | 40057 | 277 | 1 | 0 | 276 | 34.7440135 | -99.84741652 | 2021-02-11 05:23:55 | Harmon, Oklahoma, US |
3978482 | 3978482 | 2021-02-10 | Gambia | 4302 | 135 | 3891 | 276 | 13.4432 | -15.3101 | 2021-02-11 05:23:55 | Gambia | |||
3978432 | 3978432 | 2021-02-10 | Colombia | Putumayo | 7638 | 299 | 7063 | 276 | 0.436 | -75.5277 | 2021-02-11 05:23:55 | Putumayo, Colombia | ||
1530444 | 1530444 | 2021-02-09 | US | Oklahoma | Harmon | 40057 | 277 | 1 | 0 | 276 | 34.7440135 | -99.84741652 | 2021-02-10 05:22:41 | Harmon, Oklahoma, US |
1527802 | 1527802 | 2021-02-09 | Gambia | 4302 | 135 | 3891 | 276 | 13.4432 | -15.3101 | 2021-02-10 05:22:41 | Gambia | |||
616235 | 616235 | 2021-02-08 | US | Oklahoma | Harmon | 40057 | 277 | 1 | 0 | 276 | 34.7440135 | -99.84741652 | 2021-02-09 05:23:30 | Harmon, Oklahoma, US |
615824 | 615824 | 2021-02-08 | US | Nevada | Mineral | 32021 | 281 | 5 | 0 | 276 | 38.53841696 | -118.4344506 | 2021-02-09 05:23:30 | Mineral, Nevada, US |
613593 | 613593 | 2021-02-08 | Gambia | 4302 | 135 | 3891 | 276 | 13.4432 | -15.3101 | 2021-02-09 05:23:30 | Gambia | |||
1675004 | 1675004 | 2021-02-07 | US | Oklahoma | Harmon | 40057 | 277 | 1 | 0 | 276 | 34.7440135 | -99.84741652 | 2021-02-08 05:22:39 | Harmon, Oklahoma, US |
1674593 | 1674593 | 2021-02-07 | US | Nevada | Mineral | 32021 | 281 | 5 | 0 | 276 | 38.53841696 | -118.4344506 | 2021-02-08 05:22:39 | Mineral, Nevada, US |
977054 | 977054 | 2021-02-06 | US | Nevada | Mineral | 32021 | 281 | 5 | 0 | 276 | 38.53841696 | -118.4344506 | 2021-02-07 05:23:00 | Mineral, Nevada, US |
975534 | 975534 | 2021-02-06 | US | Colorado | Huerfano | 8055 | 300 | 16 | 0 | 276 | 37.68473101 | -104.9612585 | 2021-02-07 05:23:00 | Huerfano, Colorado, US |
1591252 | 1591252 | 2021-02-05 | US | Texas | Fisher | 48151 | 313 | 13 | 0 | 276 | 32.74281316 | -100.4019302 | 2021-02-06 05:23:55 | Fisher, Texas, US |
1588792 | 1588792 | 2021-02-05 | US | Colorado | Huerfano | 8055 | 300 | 16 | 0 | 276 | 37.68473101 | -104.9612585 | 2021-02-06 05:23:55 | Huerfano, Colorado, US |
790999 | 790999 | 2021-02-04 | US | Colorado | Huerfano | 8055 | 298 | 16 | 0 | 276 | 37.68473101 | -104.9612585 | 2021-02-05 05:22:38 | Huerfano, Colorado, US |
340891 | 340891 | 2021-02-03 | US | Colorado | Huerfano | 8055 | 297 | 16 | 0 | 276 | 37.68473101 | -104.9612585 | 2021-02-04 05:22:26 | Huerfano, Colorado, US |
1687694 | 1687694 | 2021-02-02 | US | Texas | Real | 48385 | 306 | 12 | 0 | 276 | 29.83321503 | -99.82018052 | 2021-02-03 05:22:52 | Real, Texas, US |
1685117 | 1685117 | 2021-02-02 | US | Colorado | Huerfano | 8055 | 297 | 16 | 0 | 276 | 37.68473101 | -104.9612585 | 2021-02-03 05:22:52 | Huerfano, Colorado, US |
1684224 | 1684224 | 2021-02-02 | Belize | 11957 | 303 | 11378 | 276 | 17.1899 | -88.4976 | 2021-02-03 05:22:52 | Belize | |||
1679664 | 1679664 | 2021-02-01 | US | Texas | Real | 48385 | 306 | 12 | 0 | 276 | 29.83321503 | -99.82018052 | 2021-02-02 05:22:49 | Real, Texas, US |
1677087 | 1677087 | 2021-02-01 | US | Colorado | Huerfano | 8055 | 297 | 16 | 0 | 276 | 37.68473101 | -104.9612585 | 2021-02-02 05:22:49 | Huerfano, Colorado, US |
1462952 | 1462952 | 2021-01-31 | US | Texas | Real | 48385 | 306 | 12 | 0 | 276 | 29.83321503 | -99.82018052 | 2021-02-01 05:22:53 | Real, Texas, US |
1460375 | 1460375 | 2021-01-31 | US | Colorado | Huerfano | 8055 | 297 | 16 | 0 | 276 | 37.68473101 | -104.9612585 | 2021-02-01 05:22:53 | Huerfano, Colorado, US |
2215329 | 2215329 | 2021-01-30 | Vietnam | 1767 | 35 | 1456 | 276 | 14.058324 | 108.277199 | 2021-01-31 05:22:42 | Vietnam | |||
2214860 | 2214860 | 2021-01-30 | US | Texas | Real | 48385 | 306 | 12 | 0 | 276 | 29.83321503 | -99.82018052 | 2021-01-31 05:22:42 | Real, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);