johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
694 rows where confirmed = 648 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1623180 | 1623180 | 2022-11-22 | US | South Dakota | Sanborn | 46111 | 648 | 8 | 0 | 44.02351092 | -98.0909816 | 2022-11-23 04:21:06 | Sanborn, South Dakota, US | |
3463068 | 3463068 | 2022-11-21 | US | South Dakota | Sanborn | 46111 | 648 | 8 | 0 | 44.02351092 | -98.0909816 | 2022-11-22 04:20:47 | Sanborn, South Dakota, US | |
1643253 | 1643253 | 2022-11-20 | US | South Dakota | Sanborn | 46111 | 648 | 8 | 0 | 44.02351092 | -98.0909816 | 2022-11-21 04:21:05 | Sanborn, South Dakota, US | |
2066810 | 2066810 | 2022-11-19 | US | South Dakota | Sanborn | 46111 | 648 | 8 | 0 | 44.02351092 | -98.0909816 | 2022-11-20 04:21:08 | Sanborn, South Dakota, US | |
1758204 | 1758204 | 2022-11-18 | US | South Dakota | Sanborn | 46111 | 648 | 8 | 0 | 44.02351092 | -98.0909816 | 2022-11-19 04:21:14 | Sanborn, South Dakota, US | |
3029197 | 3029197 | 2022-11-17 | US | South Dakota | Sanborn | 46111 | 648 | 8 | 0 | 44.02351092 | -98.0909816 | 2022-11-18 04:21:15 | Sanborn, South Dakota, US | |
2488908 | 2488908 | 2022-11-16 | US | South Dakota | Sanborn | 46111 | 648 | 8 | 0 | 44.02351092 | -98.0909816 | 2022-11-17 04:21:11 | Sanborn, South Dakota, US | |
294887 | 294887 | 2022-11-15 | US | South Dakota | Faulk | 46049 | 648 | 17 | 0 | 45.07082625 | -99.14535601 | 2022-11-16 04:21:09 | Faulk, South Dakota, US | |
3599917 | 3599917 | 2022-11-14 | US | South Dakota | Faulk | 46049 | 648 | 17 | 0 | 45.07082625 | -99.14535601 | 2022-11-15 04:21:16 | Faulk, South Dakota, US | |
314775 | 314775 | 2022-11-13 | US | South Dakota | Faulk | 46049 | 648 | 17 | 0 | 45.07082625 | -99.14535601 | 2022-11-14 04:21:09 | Faulk, South Dakota, US | |
313908 | 313908 | 2022-11-13 | US | Montana | Granite | 30039 | 648 | 10 | 0 | 46.4060522 | -113.4414186 | 2022-11-14 04:21:09 | Granite, Montana, US | |
65936 | 65936 | 2022-11-12 | US | South Dakota | Faulk | 46049 | 648 | 17 | 0 | 45.07082625 | -99.14535601 | 2022-11-13 04:21:14 | Faulk, South Dakota, US | |
65069 | 65069 | 2022-11-12 | US | Montana | Granite | 30039 | 648 | 10 | 0 | 46.4060522 | -113.4414186 | 2022-11-13 04:21:14 | Granite, Montana, US | |
2930098 | 2930098 | 2022-11-11 | US | South Dakota | Faulk | 46049 | 648 | 17 | 0 | 45.07082625 | -99.14535601 | 2022-11-12 04:20:41 | Faulk, South Dakota, US | |
2929231 | 2929231 | 2022-11-11 | US | Montana | Granite | 30039 | 648 | 10 | 0 | 46.4060522 | -113.4414186 | 2022-11-12 04:20:41 | Granite, Montana, US | |
2508934 | 2508934 | 2022-11-10 | US | South Dakota | Faulk | 46049 | 648 | 17 | 0 | 45.07082625 | -99.14535601 | 2022-11-11 04:21:22 | Faulk, South Dakota, US | |
2508067 | 2508067 | 2022-11-10 | US | Montana | Granite | 30039 | 648 | 10 | 0 | 46.4060522 | -113.4414186 | 2022-11-11 04:21:22 | Granite, Montana, US | |
2433809 | 2433809 | 2022-11-09 | US | South Dakota | Faulk | 46049 | 648 | 17 | 0 | 45.07082625 | -99.14535601 | 2022-11-10 04:21:16 | Faulk, South Dakota, US | |
2432942 | 2432942 | 2022-11-09 | US | Montana | Granite | 30039 | 648 | 10 | 0 | 46.4060522 | -113.4414186 | 2022-11-10 04:21:16 | Granite, Montana, US | |
481598 | 481598 | 2022-11-08 | US | Montana | Granite | 30039 | 648 | 10 | 0 | 46.4060522 | -113.4414186 | 2022-11-09 04:21:22 | Granite, Montana, US | |
2440748 | 2440748 | 2022-11-07 | US | Montana | Granite | 30039 | 648 | 10 | 0 | 46.4060522 | -113.4414186 | 2022-11-08 04:21:21 | Granite, Montana, US | |
1051846 | 1051846 | 2022-11-06 | US | Montana | Granite | 30039 | 648 | 10 | 0 | 46.4060522 | -113.4414186 | 2022-11-07 04:21:26 | Granite, Montana, US | |
619870 | 619870 | 2022-11-05 | US | Montana | Granite | 30039 | 648 | 10 | 0 | 46.4060522 | -113.4414186 | 2022-11-06 04:21:24 | Granite, Montana, US | |
1024374 | 1024374 | 2022-11-04 | US | Montana | Granite | 30039 | 648 | 10 | 0 | 46.4060522 | -113.4414186 | 2022-11-05 04:21:52 | Granite, Montana, US | |
3099832 | 3099832 | 2022-10-09 | US | North Dakota | Adams | 38001 | 648 | 10 | 0 | 46.09686891 | -102.5285397 | 2022-10-10 04:22:32 | Adams, North Dakota, US | |
4005057 | 4005057 | 2022-10-08 | US | North Dakota | Adams | 38001 | 648 | 10 | 0 | 46.09686891 | -102.5285397 | 2022-10-09 04:21:16 | Adams, North Dakota, US | |
398654 | 398654 | 2022-10-07 | US | North Dakota | Adams | 38001 | 648 | 10 | 0 | 46.09686891 | -102.5285397 | 2022-10-08 04:22:56 | Adams, North Dakota, US | |
2531771 | 2531771 | 2022-10-06 | US | North Dakota | Adams | 38001 | 648 | 10 | 0 | 46.09686891 | -102.5285397 | 2022-10-07 04:23:08 | Adams, North Dakota, US | |
1813165 | 1813165 | 2022-10-05 | US | North Dakota | Adams | 38001 | 648 | 10 | 0 | 46.09686891 | -102.5285397 | 2022-10-06 04:21:22 | Adams, North Dakota, US | |
133158 | 133158 | 2022-10-04 | US | North Dakota | Griggs | 38039 | 648 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-10-05 04:23:06 | Griggs, North Dakota, US | |
133139 | 133139 | 2022-10-04 | US | North Dakota | Adams | 38001 | 648 | 10 | 0 | 46.09686891 | -102.5285397 | 2022-10-05 04:23:06 | Adams, North Dakota, US | |
132946 | 132946 | 2022-10-04 | US | New Mexico | De Baca | 35011 | 648 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-10-05 04:23:06 | De Baca, New Mexico, US | |
3572793 | 3572793 | 2022-09-19 | US | New Mexico | De Baca | 35011 | 648 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-09-20 04:22:48 | De Baca, New Mexico, US | |
3747305 | 3747305 | 2022-09-07 | US | New Mexico | De Baca | 35011 | 648 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-09-08 04:21:02 | De Baca, New Mexico, US | |
3776762 | 3776762 | 2022-08-30 | US | South Dakota | Buffalo | 46017 | 648 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-08-31 04:20:57 | Buffalo, South Dakota, US | |
1683358 | 1683358 | 2022-08-29 | US | South Dakota | Buffalo | 46017 | 648 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-08-30 04:21:03 | Buffalo, South Dakota, US | |
1879842 | 1879842 | 2022-08-28 | US | South Dakota | Buffalo | 46017 | 648 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-08-29 04:21:06 | Buffalo, South Dakota, US | |
2098969 | 2098969 | 2022-08-27 | US | South Dakota | Buffalo | 46017 | 648 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-08-28 04:21:02 | Buffalo, South Dakota, US | |
1534784 | 1534784 | 2022-08-26 | US | South Dakota | Buffalo | 46017 | 648 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-08-27 04:20:57 | Buffalo, South Dakota, US | |
2831671 | 2831671 | 2022-08-25 | US | South Dakota | Buffalo | 46017 | 648 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-08-26 04:21:02 | Buffalo, South Dakota, US | |
2326204 | 2326204 | 2022-08-24 | US | South Dakota | Buffalo | 46017 | 648 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-08-25 04:21:13 | Buffalo, South Dakota, US | |
991930 | 991930 | 2022-08-16 | US | Idaho | Custer | 16037 | 648 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-08-17 04:20:59 | Custer, Idaho, US | |
2494969 | 2494969 | 2022-08-15 | US | Idaho | Custer | 16037 | 648 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-08-16 04:20:58 | Custer, Idaho, US | |
3648519 | 3648519 | 2022-08-14 | US | Idaho | Custer | 16037 | 648 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-08-15 04:20:59 | Custer, Idaho, US | |
1969525 | 1969525 | 2022-08-13 | US | Idaho | Custer | 16037 | 648 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-08-14 04:20:55 | Custer, Idaho, US | |
2889334 | 2889334 | 2022-08-12 | US | Idaho | Custer | 16037 | 648 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-08-13 04:20:52 | Custer, Idaho, US | |
3908939 | 3908939 | 2022-08-11 | US | Idaho | Custer | 16037 | 648 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-08-12 04:20:54 | Custer, Idaho, US | |
1347256 | 1347256 | 2022-08-10 | US | Idaho | Custer | 16037 | 648 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-08-11 04:20:49 | Custer, Idaho, US | |
2011779 | 2011779 | 2022-08-04 | US | Texas | Fisher | 48151 | 648 | 26 | 0 | 32.74281316 | -100.4019302 | 2022-08-05 04:20:52 | Fisher, Texas, US | |
1101206 | 1101206 | 2022-08-03 | US | Texas | Fisher | 48151 | 648 | 25 | 0 | 32.74281316 | -100.4019302 | 2022-08-04 04:20:58 | Fisher, Texas, US | |
1490469 | 1490469 | 2022-07-26 | US | South Dakota | Jackson | 46071 | 648 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-07-27 04:21:04 | Jackson, South Dakota, US | |
2596915 | 2596915 | 2022-07-25 | US | South Dakota | Jackson | 46071 | 648 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-07-26 04:20:58 | Jackson, South Dakota, US | |
899030 | 899030 | 2022-07-24 | US | South Dakota | Jackson | 46071 | 648 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-07-25 04:20:51 | Jackson, South Dakota, US | |
94024 | 94024 | 2022-07-23 | US | South Dakota | Jackson | 46071 | 648 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-07-24 04:20:47 | Jackson, South Dakota, US | |
903046 | 903046 | 2022-07-22 | US | South Dakota | Jackson | 46071 | 648 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-07-23 04:20:53 | Jackson, South Dakota, US | |
673182 | 673182 | 2022-07-21 | US | South Dakota | Jackson | 46071 | 648 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-07-22 04:21:15 | Jackson, South Dakota, US | |
1611145 | 1611145 | 2022-07-20 | US | South Dakota | Jackson | 46071 | 648 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-07-21 04:21:10 | Jackson, South Dakota, US | |
961778 | 961778 | 2022-07-19 | US | South Dakota | Jackson | 46071 | 648 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-07-20 04:20:59 | Jackson, South Dakota, US | |
3213165 | 3213165 | 2022-07-18 | US | South Dakota | Jackson | 46071 | 648 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-07-19 04:20:58 | Jackson, South Dakota, US | |
3408340 | 3408340 | 2022-07-17 | US | South Dakota | Jackson | 46071 | 648 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-07-18 04:20:59 | Jackson, South Dakota, US | |
2154540 | 2154540 | 2022-07-16 | US | South Dakota | Jackson | 46071 | 648 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-07-17 04:21:15 | Jackson, South Dakota, US | |
2421773 | 2421773 | 2022-07-15 | US | South Dakota | Jackson | 46071 | 648 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-07-16 04:21:05 | Jackson, South Dakota, US | |
3431848 | 3431848 | 2022-07-14 | US | South Dakota | Jackson | 46071 | 648 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-07-15 04:20:53 | Jackson, South Dakota, US | |
3112368 | 3112368 | 2022-07-13 | US | South Dakota | Jackson | 46071 | 648 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-07-14 04:20:57 | Jackson, South Dakota, US | |
3969456 | 3969456 | 2022-07-05 | US | South Dakota | Stanley | 46117 | 648 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-07-06 04:20:58 | Stanley, South Dakota, US | |
3967902 | 3967902 | 2022-07-05 | US | Kansas | Smith | 20183 | 648 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-07-06 04:20:58 | Smith, Kansas, US | |
3080967 | 3080967 | 2022-07-04 | US | South Dakota | Stanley | 46117 | 648 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-07-05 04:20:45 | Stanley, South Dakota, US | |
3079413 | 3079413 | 2022-07-04 | US | Kansas | Smith | 20183 | 648 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-07-05 04:20:45 | Smith, Kansas, US | |
1770249 | 1770249 | 2022-07-03 | US | South Dakota | Stanley | 46117 | 648 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-07-04 04:20:54 | Stanley, South Dakota, US | |
1768695 | 1768695 | 2022-07-03 | US | Kansas | Smith | 20183 | 648 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-07-04 04:20:54 | Smith, Kansas, US | |
3368235 | 3368235 | 2022-07-02 | US | South Dakota | Stanley | 46117 | 648 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-07-03 04:20:59 | Stanley, South Dakota, US | |
3366681 | 3366681 | 2022-07-02 | US | Kansas | Smith | 20183 | 648 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-07-03 04:20:59 | Smith, Kansas, US | |
596564 | 596564 | 2022-07-01 | US | South Dakota | Stanley | 46117 | 648 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-07-02 04:21:16 | Stanley, South Dakota, US | |
595010 | 595010 | 2022-07-01 | US | Kansas | Smith | 20183 | 648 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-07-02 04:21:16 | Smith, Kansas, US | |
3942965 | 3942965 | 2022-06-30 | US | South Dakota | Stanley | 46117 | 648 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-07-01 04:21:10 | Stanley, South Dakota, US | |
3941411 | 3941411 | 2022-06-30 | US | Kansas | Smith | 20183 | 648 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-07-01 04:21:10 | Smith, Kansas, US | |
2492923 | 2492923 | 2022-06-29 | US | South Dakota | Stanley | 46117 | 648 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-06-30 04:21:01 | Stanley, South Dakota, US | |
2491369 | 2491369 | 2022-06-29 | US | Kansas | Smith | 20183 | 648 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-06-30 04:21:01 | Smith, Kansas, US | |
2242305 | 2242305 | 2022-06-28 | US | South Dakota | Stanley | 46117 | 648 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-06-29 04:20:59 | Stanley, South Dakota, US | |
2240751 | 2240751 | 2022-06-28 | US | Kansas | Smith | 20183 | 648 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-06-29 04:20:59 | Smith, Kansas, US | |
2150547 | 2150547 | 2022-06-27 | US | South Dakota | Stanley | 46117 | 648 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-06-28 04:20:58 | Stanley, South Dakota, US | |
2148993 | 2148993 | 2022-06-27 | US | Kansas | Smith | 20183 | 648 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-06-28 04:20:58 | Smith, Kansas, US | |
478348 | 478348 | 2022-06-26 | US | South Dakota | Stanley | 46117 | 648 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-06-27 04:21:00 | Stanley, South Dakota, US | |
476794 | 476794 | 2022-06-26 | US | Kansas | Smith | 20183 | 648 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-06-27 04:21:00 | Smith, Kansas, US | |
941723 | 941723 | 2022-06-25 | US | South Dakota | Stanley | 46117 | 648 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-06-26 04:21:02 | Stanley, South Dakota, US | |
940169 | 940169 | 2022-06-25 | US | Kansas | Smith | 20183 | 648 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-06-26 04:21:02 | Smith, Kansas, US | |
3349543 | 3349543 | 2022-06-24 | US | South Dakota | Stanley | 46117 | 648 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-06-25 04:20:57 | Stanley, South Dakota, US | |
3347989 | 3347989 | 2022-06-24 | US | Kansas | Smith | 20183 | 648 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-06-25 04:20:57 | Smith, Kansas, US | |
1651284 | 1651284 | 2022-06-23 | US | South Dakota | Stanley | 46117 | 648 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-06-24 04:20:58 | Stanley, South Dakota, US | |
1649730 | 1649730 | 2022-06-23 | US | Kansas | Smith | 20183 | 648 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-06-24 04:20:58 | Smith, Kansas, US | |
2190519 | 2190519 | 2022-06-22 | US | South Dakota | Stanley | 46117 | 648 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-06-23 04:20:55 | Stanley, South Dakota, US | |
2188965 | 2188965 | 2022-06-22 | US | Kansas | Smith | 20183 | 648 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-06-23 04:20:55 | Smith, Kansas, US | |
2999731 | 2999731 | 2022-05-24 | US | Alaska | Haines | 2100 | 648 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-05-25 04:20:56 | Haines, Alaska, US | |
3593452 | 3593452 | 2022-05-23 | US | Alaska | Haines | 2100 | 648 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-05-24 04:20:57 | Haines, Alaska, US | |
1110000 | 1110000 | 2022-05-21 | US | Alaska | Haines | 2100 | 648 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-05-22 04:20:52 | Haines, Alaska, US | |
1169624 | 1169624 | 2022-05-20 | US | Alaska | Haines | 2100 | 648 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-05-21 04:20:58 | Haines, Alaska, US | |
3896387 | 3896387 | 2022-05-19 | US | Alaska | Haines | 2100 | 648 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-05-20 04:20:57 | Haines, Alaska, US | |
1185171 | 1185171 | 2022-05-18 | US | Alaska | Haines | 2100 | 648 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-05-19 04:20:54 | Haines, Alaska, US | |
1572316 | 1572316 | 2022-05-03 | Peru | Unknown | 648 | 12 | 0 | 2022-05-04 04:20:59 | Unknown, Peru | |||||
2030235 | 2030235 | 2022-04-24 | US | Kentucky | Robertson | 21201 | 648 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-04-25 04:20:56 | Robertson, Kentucky, 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]);