johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
674 rows where confirmed = 678 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755762 | 2755762 | 2022-12-29 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-12-30 04:21:04 | Buffalo, South Dakota, US | |
2754190 | 2754190 | 2022-12-29 | US | Kansas | Elk | 20049 | 678 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-12-30 04:21:04 | Elk, Kansas, US | |
1076768 | 1076768 | 2022-12-28 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-12-29 04:21:01 | Buffalo, South Dakota, US | |
1075196 | 1075196 | 2022-12-28 | US | Kansas | Elk | 20049 | 678 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-12-29 04:21:01 | Elk, Kansas, US | |
330765 | 330765 | 2022-12-27 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-12-28 04:21:04 | Buffalo, South Dakota, US | |
220838 | 220838 | 2022-12-26 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-12-27 04:21:07 | Buffalo, South Dakota, US | |
3225295 | 3225295 | 2022-12-25 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-12-26 04:21:06 | Buffalo, South Dakota, US | |
1021209 | 1021209 | 2022-12-24 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-12-25 04:21:04 | Buffalo, South Dakota, US | |
693232 | 693232 | 2022-12-23 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-12-24 04:21:02 | Buffalo, South Dakota, US | |
2182442 | 2182442 | 2022-12-22 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-12-23 04:21:04 | Buffalo, South Dakota, US | |
454246 | 454246 | 2022-12-21 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-12-22 04:20:56 | Buffalo, South Dakota, US | |
2954245 | 2954245 | 2022-12-20 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-12-21 04:21:03 | Buffalo, South Dakota, US | |
3176647 | 3176647 | 2022-12-19 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-12-20 04:21:04 | Buffalo, South Dakota, US | |
1631164 | 1631164 | 2022-12-18 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-12-19 04:21:03 | Buffalo, South Dakota, US | |
506543 | 506543 | 2022-12-17 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-12-18 04:21:03 | Buffalo, South Dakota, US | |
3327115 | 3327115 | 2022-12-16 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-12-17 04:21:04 | Buffalo, South Dakota, US | |
545627 | 545627 | 2022-12-15 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-12-16 04:21:01 | Buffalo, South Dakota, US | |
351155 | 351155 | 2022-12-14 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-12-15 04:20:58 | Buffalo, South Dakota, US | |
1621600 | 1621600 | 2022-11-22 | US | Kansas | Morton | 20129 | 678 | 11 | 0 | 37.19141121 | -101.7992519 | 2022-11-23 04:21:06 | Morton, Kansas, US | |
3461488 | 3461488 | 2022-11-21 | US | Kansas | Morton | 20129 | 678 | 11 | 0 | 37.19141121 | -101.7992519 | 2022-11-22 04:20:47 | Morton, Kansas, US | |
1641673 | 1641673 | 2022-11-20 | US | Kansas | Morton | 20129 | 678 | 11 | 0 | 37.19141121 | -101.7992519 | 2022-11-21 04:21:05 | Morton, Kansas, US | |
2065230 | 2065230 | 2022-11-19 | US | Kansas | Morton | 20129 | 678 | 11 | 0 | 37.19141121 | -101.7992519 | 2022-11-20 04:21:08 | Morton, Kansas, US | |
1756624 | 1756624 | 2022-11-18 | US | Kansas | Morton | 20129 | 678 | 11 | 0 | 37.19141121 | -101.7992519 | 2022-11-19 04:21:14 | Morton, Kansas, US | |
3027617 | 3027617 | 2022-11-17 | US | Kansas | Morton | 20129 | 678 | 11 | 0 | 37.19141121 | -101.7992519 | 2022-11-18 04:21:15 | Morton, Kansas, US | |
2487328 | 2487328 | 2022-11-16 | US | Kansas | Morton | 20129 | 678 | 11 | 0 | 37.19141121 | -101.7992519 | 2022-11-17 04:21:11 | Morton, Kansas, US | |
292825 | 292825 | 2022-11-15 | US | Georgia | Glascock | 13125 | 678 | 27 | 0 | 33.22879932 | -82.61297636 | 2022-11-16 04:21:09 | Glascock, Georgia, US | |
3597855 | 3597855 | 2022-11-14 | US | Georgia | Glascock | 13125 | 678 | 27 | 0 | 33.22879932 | -82.61297636 | 2022-11-15 04:21:16 | Glascock, Georgia, US | |
312713 | 312713 | 2022-11-13 | US | Georgia | Glascock | 13125 | 678 | 27 | 0 | 33.22879932 | -82.61297636 | 2022-11-14 04:21:09 | Glascock, Georgia, US | |
63874 | 63874 | 2022-11-12 | US | Georgia | Glascock | 13125 | 678 | 27 | 0 | 33.22879932 | -82.61297636 | 2022-11-13 04:21:14 | Glascock, Georgia, US | |
2928036 | 2928036 | 2022-11-11 | US | Georgia | Glascock | 13125 | 678 | 27 | 0 | 33.22879932 | -82.61297636 | 2022-11-12 04:20:41 | Glascock, Georgia, US | |
2506872 | 2506872 | 2022-11-10 | US | Georgia | Glascock | 13125 | 678 | 27 | 0 | 33.22879932 | -82.61297636 | 2022-11-11 04:21:22 | Glascock, Georgia, US | |
2431747 | 2431747 | 2022-11-09 | US | Georgia | Glascock | 13125 | 678 | 27 | 0 | 33.22879932 | -82.61297636 | 2022-11-10 04:21:16 | Glascock, Georgia, US | |
851796 | 851796 | 2022-11-02 | US | New Mexico | De Baca | 35011 | 678 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-11-03 04:22:05 | De Baca, New Mexico, US | |
712647 | 712647 | 2022-11-01 | US | New Mexico | De Baca | 35011 | 678 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-11-02 04:22:09 | De Baca, New Mexico, US | |
2758234 | 2758234 | 2022-10-18 | US | Kansas | Lincoln | 20105 | 678 | 12 | 0 | 39.04549684 | -98.20756994 | 2022-10-19 04:22:26 | Lincoln, Kansas, US | |
2026068 | 2026068 | 2022-10-17 | US | Kansas | Lincoln | 20105 | 678 | 12 | 0 | 39.04549684 | -98.20756994 | 2022-10-18 04:22:42 | Lincoln, Kansas, US | |
2160846 | 2160846 | 2022-10-16 | US | Kansas | Lincoln | 20105 | 678 | 12 | 0 | 39.04549684 | -98.20756994 | 2022-10-17 04:20:31 | Lincoln, Kansas, US | |
517043 | 517043 | 2022-10-15 | US | Kansas | Lincoln | 20105 | 678 | 12 | 0 | 39.04549684 | -98.20756994 | 2022-10-16 04:22:39 | Lincoln, Kansas, US | |
2034100 | 2034100 | 2022-10-14 | US | Kansas | Lincoln | 20105 | 678 | 12 | 0 | 39.04549684 | -98.20756994 | 2022-10-15 04:22:00 | Lincoln, Kansas, US | |
3754788 | 3754788 | 2022-10-13 | US | Kansas | Lincoln | 20105 | 678 | 12 | 0 | 39.04549684 | -98.20756994 | 2022-10-14 04:22:28 | Lincoln, Kansas, US | |
3215613 | 3215613 | 2022-10-12 | US | Kansas | Lincoln | 20105 | 678 | 12 | 0 | 39.04549684 | -98.20756994 | 2022-10-13 04:22:39 | Lincoln, Kansas, US | |
3989715 | 3989715 | 2022-09-15 | US | Texas | Fisher | 48151 | 678 | 26 | 0 | 32.74281316 | -100.4019302 | 2022-09-16 04:21:19 | Fisher, Texas, US | |
1892232 | 1892232 | 2022-09-14 | US | Texas | Fisher | 48151 | 678 | 26 | 0 | 32.74281316 | -100.4019302 | 2022-09-15 04:21:02 | Fisher, Texas, US | |
375082 | 375082 | 2022-09-13 | US | South Dakota | Jackson | 46071 | 678 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-09-14 04:20:44 | Jackson, South Dakota, US | |
2397684 | 2397684 | 2022-09-12 | US | South Dakota | Jackson | 46071 | 678 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-09-13 04:20:57 | Jackson, South Dakota, US | |
3768762 | 3768762 | 2022-09-11 | US | South Dakota | Jackson | 46071 | 678 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-09-12 04:20:58 | Jackson, South Dakota, US | |
3827337 | 3827337 | 2022-09-10 | US | South Dakota | Jackson | 46071 | 678 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-09-11 04:20:50 | Jackson, South Dakota, US | |
965794 | 965794 | 2022-09-09 | US | South Dakota | Jackson | 46071 | 678 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-09-10 04:21:10 | Jackson, South Dakota, US | |
256196 | 256196 | 2022-09-08 | US | South Dakota | Jackson | 46071 | 678 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-09-09 04:21:11 | Jackson, South Dakota, US | |
3747994 | 3747994 | 2022-09-07 | US | South Dakota | Jackson | 46071 | 678 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-09-08 04:21:02 | Jackson, South Dakota, US | |
1252028 | 1252028 | 2022-08-23 | US | Kansas | Cheyenne | 20023 | 678 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-08-24 04:20:46 | Cheyenne, Kansas, US | |
2854132 | 2854132 | 2022-08-22 | US | Kansas | Cheyenne | 20023 | 678 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-08-23 04:20:56 | Cheyenne, Kansas, US | |
2404104 | 2404104 | 2022-08-21 | US | Kansas | Cheyenne | 20023 | 678 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-08-22 04:20:38 | Cheyenne, Kansas, US | |
3799182 | 3799182 | 2022-08-20 | US | Kansas | Cheyenne | 20023 | 678 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-08-21 04:20:44 | Cheyenne, Kansas, US | |
2364768 | 2364768 | 2022-08-19 | US | Kansas | Cheyenne | 20023 | 678 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-08-20 04:21:01 | Cheyenne, Kansas, US | |
1162439 | 1162439 | 2022-08-18 | US | Kansas | Cheyenne | 20023 | 678 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-08-19 04:20:54 | Cheyenne, Kansas, US | |
3951763 | 3951763 | 2022-08-17 | US | Kansas | Cheyenne | 20023 | 678 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-08-18 04:21:11 | Cheyenne, Kansas, US | |
2596466 | 2596466 | 2022-07-25 | US | North Dakota | Towner | 38095 | 678 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-07-26 04:20:58 | Towner, North Dakota, US | |
2236850 | 2236850 | 2022-06-12 | US | Kentucky | Robertson | 21201 | 678 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-06-13 04:21:14 | Robertson, Kentucky, US | |
3143048 | 3143048 | 2022-06-11 | US | Kentucky | Robertson | 21201 | 678 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-06-12 04:20:53 | Robertson, Kentucky, US | |
1945964 | 1945964 | 2022-06-10 | US | Kentucky | Robertson | 21201 | 678 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-06-11 04:21:01 | Robertson, Kentucky, US | |
3159103 | 3159103 | 2022-06-09 | US | Kentucky | Robertson | 21201 | 678 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-06-10 04:20:55 | Robertson, Kentucky, US | |
1422570 | 1422570 | 2022-06-08 | US | Kentucky | Robertson | 21201 | 678 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-06-09 04:20:54 | Robertson, Kentucky, US | |
3727684 | 3727684 | 2022-06-07 | US | Kentucky | Robertson | 21201 | 678 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-06-08 04:20:55 | Robertson, Kentucky, US | |
3889086 | 3889086 | 2022-06-06 | US | Kentucky | Robertson | 21201 | 678 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-06-07 04:21:08 | Robertson, Kentucky, US | |
2599384 | 2599384 | 2022-05-05 | US | Kansas | Rawlins | 20153 | 678 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-05-06 04:21:00 | Rawlins, Kansas, US | |
3266833 | 3266833 | 2022-05-04 | US | Kansas | Rawlins | 20153 | 678 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-05-05 04:20:55 | Rawlins, Kansas, US | |
1573472 | 1573472 | 2022-05-03 | US | Kansas | Rawlins | 20153 | 678 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-05-04 04:20:59 | Rawlins, Kansas, US | |
464732 | 464732 | 2022-05-02 | US | Kansas | Rawlins | 20153 | 678 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-05-03 04:21:00 | Rawlins, Kansas, US | |
3917371 | 3917371 | 2022-05-01 | US | Kansas | Rawlins | 20153 | 678 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-05-02 04:21:10 | Rawlins, Kansas, US | |
2842175 | 2842175 | 2022-04-30 | US | Kansas | Rawlins | 20153 | 678 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-05-01 04:20:57 | Rawlins, Kansas, US | |
1158488 | 1158488 | 2022-04-29 | US | Kansas | Rawlins | 20153 | 678 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-04-30 04:21:05 | Rawlins, Kansas, US | |
1697670 | 1697670 | 2022-04-28 | US | Kansas | Rawlins | 20153 | 678 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-04-29 04:20:59 | Rawlins, Kansas, US | |
3853814 | 3853814 | 2022-04-27 | US | Montana | Fallon | 30025 | 678 | 10 | 0 | 46.33478338 | -104.4183565 | 2022-04-28 04:20:47 | Fallon, Montana, US | |
3853779 | 3853779 | 2022-04-27 | US | Missouri | Scotland | 29199 | 678 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-04-28 04:20:47 | Scotland, Missouri, US | |
3853153 | 3853153 | 2022-04-27 | US | Kansas | Rawlins | 20153 | 678 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-04-28 04:20:47 | Rawlins, Kansas, US | |
1328244 | 1328244 | 2022-04-26 | US | Montana | Fallon | 30025 | 678 | 10 | 0 | 46.33478338 | -104.41835649999999 | 2022-04-27 04:20:52 | Fallon, Montana, US | |
1328209 | 1328209 | 2022-04-26 | US | Missouri | Scotland | 29199 | 678 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-04-27 04:20:52 | Scotland, Missouri, US | |
1327583 | 1327583 | 2022-04-26 | US | Kansas | Rawlins | 20153 | 678 | 9 | 0 | 39.78525843 | -101.07616170000001 | 2022-04-27 04:20:52 | Rawlins, Kansas, US | |
3724198 | 3724198 | 2022-04-25 | US | Montana | Fallon | 30025 | 678 | 10 | 0 | 46.33478338 | -104.41835649999999 | 2022-04-26 04:20:51 | Fallon, Montana, US | |
3724163 | 3724163 | 2022-04-25 | US | Missouri | Scotland | 29199 | 678 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-04-26 04:20:51 | Scotland, Missouri, US | |
3723537 | 3723537 | 2022-04-25 | US | Kansas | Rawlins | 20153 | 678 | 9 | 0 | 39.78525843 | -101.07616170000001 | 2022-04-26 04:20:51 | Rawlins, Kansas, US | |
2030766 | 2030766 | 2022-04-24 | US | Montana | Fallon | 30025 | 678 | 10 | 0 | 46.33478338 | -104.41835649999999 | 2022-04-25 04:20:56 | Fallon, Montana, US | |
2030731 | 2030731 | 2022-04-24 | US | Missouri | Scotland | 29199 | 678 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-04-25 04:20:56 | Scotland, Missouri, US | |
2030105 | 2030105 | 2022-04-24 | US | Kansas | Rawlins | 20153 | 678 | 9 | 0 | 39.78525843 | -101.07616170000001 | 2022-04-25 04:20:56 | Rawlins, Kansas, US | |
748341 | 748341 | 2022-04-23 | US | Montana | Fallon | 30025 | 678 | 10 | 0 | 46.33478338 | -104.41835649999999 | 2022-04-24 04:20:56 | Fallon, Montana, US | |
748306 | 748306 | 2022-04-23 | US | Missouri | Scotland | 29199 | 678 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-04-24 04:20:56 | Scotland, Missouri, US | |
747680 | 747680 | 2022-04-23 | US | Kansas | Rawlins | 20153 | 678 | 9 | 0 | 39.78525843 | -101.07616170000001 | 2022-04-24 04:20:56 | Rawlins, Kansas, US | |
3438826 | 3438826 | 2022-04-22 | US | Montana | Fallon | 30025 | 678 | 10 | 0 | 46.33478338 | -104.41835649999999 | 2022-04-23 04:20:50 | Fallon, Montana, US | |
3438791 | 3438791 | 2022-04-22 | US | Missouri | Scotland | 29199 | 678 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-04-23 04:20:50 | Scotland, Missouri, US | |
3438165 | 3438165 | 2022-04-22 | US | Kansas | Rawlins | 20153 | 678 | 9 | 0 | 39.78525843 | -101.07616170000001 | 2022-04-23 04:20:50 | Rawlins, Kansas, US | |
2894411 | 2894411 | 2022-04-21 | US | Montana | Fallon | 30025 | 678 | 10 | 0 | 46.33478338 | -104.41835649999999 | 2022-04-22 04:20:45 | Fallon, Montana, US | |
2894376 | 2894376 | 2022-04-21 | US | Missouri | Scotland | 29199 | 678 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-04-22 04:20:45 | Scotland, Missouri, US | |
2893750 | 2893750 | 2022-04-21 | US | Kansas | Rawlins | 20153 | 678 | 9 | 0 | 39.78525843 | -101.07616170000001 | 2022-04-22 04:20:45 | Rawlins, Kansas, US | |
2309283 | 2309283 | 2022-04-20 | US | Montana | Fallon | 30025 | 678 | 10 | 0 | 46.33478338 | -104.41835649999999 | 2022-04-21 04:20:46 | Fallon, Montana, US | |
2308622 | 2308622 | 2022-04-20 | US | Kansas | Rawlins | 20153 | 678 | 9 | 0 | 39.78525843 | -101.07616170000001 | 2022-04-21 04:20:46 | Rawlins, Kansas, US | |
2252761 | 2252761 | 2022-04-19 | US | Kansas | Rawlins | 20153 | 678 | 9 | 0 | 39.78525843 | -101.07616170000001 | 2022-04-20 04:20:45 | Rawlins, Kansas, US | |
1847311 | 1847311 | 2022-04-18 | US | Kansas | Rawlins | 20153 | 678 | 9 | 0 | 39.78525843 | -101.07616170000001 | 2022-04-19 04:21:00 | Rawlins, Kansas, US | |
3418255 | 3418255 | 2022-04-17 | US | Kansas | Rawlins | 20153 | 678 | 9 | 0 | 39.78525843 | -101.07616170000001 | 2022-04-18 04:21:12 | Rawlins, Kansas, US | |
305204 | 305204 | 2022-04-16 | US | Kansas | Rawlins | 20153 | 678 | 9 | 0 | 39.78525843 | -101.07616170000001 | 2022-04-17 04:20:59 | Rawlins, Kansas, 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]);