johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
610 rows where confirmed = 846 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
350711 | 350711 | 2022-12-14 | US | North Dakota | McIntosh | 38051 | 846 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-12-15 04:20:58 | McIntosh, North Dakota, US | |
3285082 | 3285082 | 2022-10-31 | Peru | Unknown | 846 | 7 | 0 | 2022-11-01 04:22:36 | Unknown, Peru | |||||
3755876 | 3755876 | 2022-10-13 | US | North Dakota | Eddy | 38027 | 846 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-10-14 04:22:28 | Eddy, North Dakota, US | |
3216701 | 3216701 | 2022-10-12 | US | North Dakota | Eddy | 38027 | 846 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-10-13 04:22:39 | Eddy, North Dakota, US | |
3252550 | 3252550 | 2022-10-11 | US | North Dakota | Eddy | 38027 | 846 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-10-12 04:22:51 | Eddy, North Dakota, US | |
2969809 | 2969809 | 2022-10-10 | US | North Dakota | Eddy | 38027 | 846 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-10-11 04:23:05 | Eddy, North Dakota, US | |
3099845 | 3099845 | 2022-10-09 | US | North Dakota | Eddy | 38027 | 846 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-10-10 04:22:32 | Eddy, North Dakota, US | |
4005070 | 4005070 | 2022-10-08 | US | North Dakota | Eddy | 38027 | 846 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-10-09 04:21:16 | Eddy, North Dakota, US | |
398667 | 398667 | 2022-10-07 | US | North Dakota | Eddy | 38027 | 846 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-10-08 04:22:56 | Eddy, North Dakota, US | |
2377575 | 2377575 | 2022-09-29 | US | Montana | Sheridan | 30091 | 846 | 12 | 0 | 48.72085833 | -104.503829 | 2022-09-30 04:23:09 | Sheridan, Montana, US | |
1562126 | 1562126 | 2022-09-28 | US | Montana | Sheridan | 30091 | 846 | 12 | 0 | 48.72085833 | -104.503829 | 2022-09-29 04:22:34 | Sheridan, Montana, US | |
3996669 | 3996669 | 2022-09-27 | US | Montana | Sheridan | 30091 | 846 | 12 | 0 | 48.72085833 | -104.503829 | 2022-09-28 04:23:01 | Sheridan, Montana, US | |
3995996 | 3995996 | 2022-09-27 | US | Kansas | Trego | 20195 | 846 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-09-28 04:23:01 | Trego, Kansas, US | |
2770997 | 2770997 | 2022-09-26 | US | Montana | Sheridan | 30091 | 846 | 12 | 0 | 48.72085833 | -104.503829 | 2022-09-27 04:23:01 | Sheridan, Montana, US | |
2770324 | 2770324 | 2022-09-26 | US | Kansas | Trego | 20195 | 846 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-09-27 04:23:01 | Trego, Kansas, US | |
1978650 | 1978650 | 2022-09-25 | US | Montana | Sheridan | 30091 | 846 | 12 | 0 | 48.72085833 | -104.503829 | 2022-09-26 04:20:52 | Sheridan, Montana, US | |
1977977 | 1977977 | 2022-09-25 | US | Kansas | Trego | 20195 | 846 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-09-26 04:20:52 | Trego, Kansas, US | |
2651817 | 2651817 | 2022-09-24 | US | Montana | Sheridan | 30091 | 846 | 12 | 0 | 48.72085833 | -104.503829 | 2022-09-25 04:23:31 | Sheridan, Montana, US | |
2651144 | 2651144 | 2022-09-24 | US | Kansas | Trego | 20195 | 846 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-09-25 04:23:31 | Trego, Kansas, US | |
386257 | 386257 | 2022-09-23 | US | Montana | Sheridan | 30091 | 846 | 12 | 0 | 48.72085833 | -104.503829 | 2022-09-24 04:21:40 | Sheridan, Montana, US | |
385584 | 385584 | 2022-09-23 | US | Kansas | Trego | 20195 | 846 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-09-24 04:21:40 | Trego, Kansas, US | |
1625650 | 1625650 | 2022-09-22 | US | Kansas | Trego | 20195 | 846 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-09-23 04:23:13 | Trego, Kansas, US | |
1371854 | 1371854 | 2022-09-21 | US | Kansas | Trego | 20195 | 846 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-09-22 04:22:56 | Trego, Kansas, US | |
3747529 | 3747529 | 2022-09-07 | US | North Dakota | Nelson | 38063 | 846 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-09-08 04:21:02 | Nelson, North Dakota, US | |
117602 | 117602 | 2022-09-06 | US | South Dakota | Bennett | 46007 | 846 | 15 | 0 | 43.19486375 | -101.6665572 | 2022-09-07 04:20:59 | Bennett, South Dakota, US | |
117169 | 117169 | 2022-09-06 | US | North Dakota | Nelson | 38063 | 846 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-09-07 04:20:59 | Nelson, North Dakota, US | |
2636574 | 2636574 | 2022-09-05 | US | South Dakota | Bennett | 46007 | 846 | 15 | 0 | 43.19486375 | -101.6665572 | 2022-09-06 04:21:02 | Bennett, South Dakota, US | |
2990138 | 2990138 | 2022-09-04 | US | South Dakota | Bennett | 46007 | 846 | 15 | 0 | 43.19486375 | -101.6665572 | 2022-09-05 04:21:01 | Bennett, South Dakota, US | |
2715823 | 2715823 | 2022-09-03 | US | South Dakota | Bennett | 46007 | 846 | 15 | 0 | 43.19486375 | -101.6665572 | 2022-09-04 04:21:22 | Bennett, South Dakota, US | |
1396528 | 1396528 | 2022-09-02 | US | South Dakota | Bennett | 46007 | 846 | 15 | 0 | 43.19486375 | -101.6665572 | 2022-09-03 04:21:04 | Bennett, South Dakota, US | |
3550357 | 3550357 | 2022-09-01 | US | South Dakota | Bennett | 46007 | 846 | 15 | 0 | 43.19486375 | -101.6665572 | 2022-09-02 04:21:07 | Bennett, South Dakota, US | |
2346277 | 2346277 | 2022-08-31 | US | South Dakota | Bennett | 46007 | 846 | 15 | 0 | 43.19486375 | -101.6665572 | 2022-09-01 04:21:03 | Bennett, South Dakota, US | |
2345162 | 2345162 | 2022-08-31 | US | Minnesota | Lake of the Woods | 27077 | 846 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-09-01 04:21:03 | Lake of the Woods, Minnesota, US | |
3776755 | 3776755 | 2022-08-30 | US | South Dakota | Aurora | 46003 | 846 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-08-31 04:20:57 | Aurora, South Dakota, US | |
3775642 | 3775642 | 2022-08-30 | US | Minnesota | Lake of the Woods | 27077 | 846 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-08-31 04:20:57 | Lake of the Woods, Minnesota, US | |
1683351 | 1683351 | 2022-08-29 | US | South Dakota | Aurora | 46003 | 846 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-08-30 04:21:03 | Aurora, South Dakota, US | |
1682238 | 1682238 | 2022-08-29 | US | Minnesota | Lake of the Woods | 27077 | 846 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-08-30 04:21:03 | Lake of the Woods, Minnesota, US | |
1879835 | 1879835 | 2022-08-28 | US | South Dakota | Aurora | 46003 | 846 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-08-29 04:21:06 | Aurora, South Dakota, US | |
1878722 | 1878722 | 2022-08-28 | US | Minnesota | Lake of the Woods | 27077 | 846 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-08-29 04:21:06 | Lake of the Woods, Minnesota, US | |
2098962 | 2098962 | 2022-08-27 | US | South Dakota | Aurora | 46003 | 846 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-08-28 04:21:02 | Aurora, South Dakota, US | |
2097849 | 2097849 | 2022-08-27 | US | Minnesota | Lake of the Woods | 27077 | 846 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-08-28 04:21:02 | Lake of the Woods, Minnesota, US | |
1534777 | 1534777 | 2022-08-26 | US | South Dakota | Aurora | 46003 | 846 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-08-27 04:20:57 | Aurora, South Dakota, US | |
1533664 | 1533664 | 2022-08-26 | US | Minnesota | Lake of the Woods | 27077 | 846 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-08-27 04:20:57 | Lake of the Woods, Minnesota, US | |
2831664 | 2831664 | 2022-08-25 | US | South Dakota | Aurora | 46003 | 846 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-08-26 04:21:02 | Aurora, South Dakota, US | |
2830551 | 2830551 | 2022-08-25 | US | Minnesota | Lake of the Woods | 27077 | 846 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-08-26 04:21:02 | Lake of the Woods, Minnesota, US | |
2326197 | 2326197 | 2022-08-24 | US | South Dakota | Aurora | 46003 | 846 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-08-25 04:21:13 | Aurora, South Dakota, US | |
1072113 | 1072113 | 2022-08-07 | US | New Mexico | Union | 35059 | 846 | 17 | 0 | 36.48126404 | -103.4709624 | 2022-08-08 04:21:08 | Union, New Mexico, US | |
1942701 | 1942701 | 2022-08-06 | US | New Mexico | Union | 35059 | 846 | 17 | 0 | 36.48126404 | -103.4709624 | 2022-08-07 04:20:54 | Union, New Mexico, US | |
882500 | 882500 | 2022-08-05 | US | New Mexico | Union | 35059 | 846 | 17 | 0 | 36.48126404 | -103.4709624 | 2022-08-06 04:20:56 | Union, New Mexico, US | |
880892 | 880892 | 2022-08-05 | US | Colorado | Costilla | 8023 | 846 | 19 | 0 | 37.27732493 | -105.4276548 | 2022-08-06 04:20:56 | Costilla, Colorado, US | |
2009303 | 2009303 | 2022-08-04 | US | Colorado | Costilla | 8023 | 846 | 19 | 0 | 37.27732493 | -105.4276548 | 2022-08-05 04:20:52 | Costilla, Colorado, US | |
1406204 | 1406204 | 2022-08-02 | US | Iowa | Adams | 19003 | 846 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-08-03 04:20:59 | Adams, Iowa, US | |
3618242 | 3618242 | 2022-08-01 | US | Iowa | Adams | 19003 | 846 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-08-02 04:20:53 | Adams, Iowa, US | |
3872722 | 3872722 | 2022-07-31 | US | Iowa | Adams | 19003 | 846 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-08-01 04:21:03 | Adams, Iowa, US | |
675476 | 675476 | 2022-07-30 | US | Iowa | Adams | 19003 | 846 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-07-31 04:21:02 | Adams, Iowa, US | |
1784675 | 1784675 | 2022-07-29 | US | Iowa | Adams | 19003 | 846 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-07-30 04:20:42 | Adams, Iowa, US | |
1067038 | 1067038 | 2022-07-28 | US | Iowa | Adams | 19003 | 846 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-07-29 04:20:45 | Adams, Iowa, US | |
2336557 | 2336557 | 2022-07-27 | US | Iowa | Adams | 19003 | 846 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-07-28 04:20:56 | Adams, Iowa, US | |
1488916 | 1488916 | 2022-07-26 | US | Kansas | Osborne | 20141 | 846 | 19 | 0 | 39.3503437 | -98.76753828 | 2022-07-27 04:21:04 | Osborne, Kansas, US | |
2596439 | 2596439 | 2022-07-25 | US | North Dakota | Hettinger | 38041 | 846 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-07-26 04:20:58 | Hettinger, North Dakota, US | |
2595362 | 2595362 | 2022-07-25 | US | Kansas | Osborne | 20141 | 846 | 19 | 0 | 39.3503437 | -98.76753828 | 2022-07-26 04:20:58 | Osborne, Kansas, US | |
898554 | 898554 | 2022-07-24 | US | North Dakota | Hettinger | 38041 | 846 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-07-25 04:20:51 | Hettinger, North Dakota, US | |
897477 | 897477 | 2022-07-24 | US | Kansas | Osborne | 20141 | 846 | 19 | 0 | 39.3503437 | -98.76753828 | 2022-07-25 04:20:51 | Osborne, Kansas, US | |
94165 | 94165 | 2022-07-23 | US | Texas | Baylor | 48023 | 846 | 32 | 0 | 33.61640794 | -99.21352901 | 2022-07-24 04:20:47 | Baylor, Texas, US | |
93548 | 93548 | 2022-07-23 | US | North Dakota | Hettinger | 38041 | 846 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-07-24 04:20:47 | Hettinger, North Dakota, US | |
92471 | 92471 | 2022-07-23 | US | Kansas | Osborne | 20141 | 846 | 19 | 0 | 39.3503437 | -98.76753828 | 2022-07-24 04:20:47 | Osborne, Kansas, US | |
902570 | 902570 | 2022-07-22 | US | North Dakota | Hettinger | 38041 | 846 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-07-23 04:20:53 | Hettinger, North Dakota, US | |
901493 | 901493 | 2022-07-22 | US | Kansas | Osborne | 20141 | 846 | 19 | 0 | 39.3503437 | -98.76753828 | 2022-07-23 04:20:53 | Osborne, Kansas, US | |
672706 | 672706 | 2022-07-21 | US | North Dakota | Hettinger | 38041 | 846 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-07-22 04:21:15 | Hettinger, North Dakota, US | |
671629 | 671629 | 2022-07-21 | US | Kansas | Osborne | 20141 | 846 | 19 | 0 | 39.3503437 | -98.76753828 | 2022-07-22 04:21:15 | Osborne, Kansas, US | |
1611431 | 1611431 | 2022-07-20 | US | Texas | Mason | 48319 | 846 | 12 | 0 | 30.71780434 | -99.22629416 | 2022-07-21 04:21:10 | Mason, Texas, US | |
1610669 | 1610669 | 2022-07-20 | US | North Dakota | Hettinger | 38041 | 846 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-07-21 04:21:10 | Hettinger, North Dakota, US | |
1609592 | 1609592 | 2022-07-20 | US | Kansas | Osborne | 20141 | 846 | 19 | 0 | 39.3503437 | -98.76753828 | 2022-07-21 04:21:10 | Osborne, Kansas, US | |
2492223 | 2492223 | 2022-06-29 | US | New Mexico | Mora | 35033 | 846 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-06-30 04:21:01 | Mora, New Mexico, US | |
2241605 | 2241605 | 2022-06-28 | US | New Mexico | Mora | 35033 | 846 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-06-29 04:20:59 | Mora, New Mexico, US | |
2239835 | 2239835 | 2022-06-28 | US | Alaska | Petersburg | 2195 | 846 | 6 | 0 | 57.13978948 | -132.9540995 | 2022-06-29 04:20:59 | Petersburg, Alaska, US | |
2148077 | 2148077 | 2022-06-27 | US | Alaska | Petersburg | 2195 | 846 | 6 | 0 | 57.13978948 | -132.9540995 | 2022-06-28 04:20:58 | Petersburg, Alaska, US | |
475878 | 475878 | 2022-06-26 | US | Alaska | Petersburg | 2195 | 846 | 6 | 0 | 57.13978948 | -132.9540995 | 2022-06-27 04:21:00 | Petersburg, Alaska, US | |
939253 | 939253 | 2022-06-25 | US | Alaska | Petersburg | 2195 | 846 | 6 | 0 | 57.13978948 | -132.9540995 | 2022-06-26 04:21:02 | Petersburg, Alaska, US | |
3347073 | 3347073 | 2022-06-24 | US | Alaska | Petersburg | 2195 | 846 | 6 | 0 | 57.13978948 | -132.9540995 | 2022-06-25 04:20:57 | Petersburg, Alaska, US | |
1648814 | 1648814 | 2022-06-23 | US | Alaska | Petersburg | 2195 | 846 | 6 | 0 | 57.13978948 | -132.9540995 | 2022-06-24 04:20:58 | Petersburg, Alaska, US | |
2188049 | 2188049 | 2022-06-22 | US | Alaska | Petersburg | 2195 | 846 | 6 | 0 | 57.13978948 | -132.9540995 | 2022-06-23 04:20:55 | Petersburg, Alaska, US | |
169249 | 169249 | 2022-06-21 | US | Texas | Real | 48385 | 846 | 25 | 0 | 29.83321503 | -99.82018052 | 2022-06-22 04:20:54 | Real, Texas, US | |
231884 | 231884 | 2022-05-31 | US | Pennsylvania | Cameron | 42023 | 846 | 21 | 0 | 41.43625568 | -78.20376845 | 2022-06-01 04:20:55 | Cameron, Pennsylvania, US | |
230495 | 230495 | 2022-05-31 | US | Kansas | Chautauqua | 20019 | 846 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-06-01 04:20:55 | Chautauqua, Kansas, US | |
3188649 | 3188649 | 2022-05-30 | US | Pennsylvania | Cameron | 42023 | 846 | 21 | 0 | 41.43625568 | -78.20376845 | 2022-05-31 04:20:51 | Cameron, Pennsylvania, US | |
3187260 | 3187260 | 2022-05-30 | US | Kansas | Chautauqua | 20019 | 846 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-05-31 04:20:51 | Chautauqua, Kansas, US | |
3200798 | 3200798 | 2022-05-29 | US | Pennsylvania | Cameron | 42023 | 846 | 21 | 0 | 41.43625568 | -78.20376845 | 2022-05-30 04:20:50 | Cameron, Pennsylvania, US | |
3199409 | 3199409 | 2022-05-29 | US | Kansas | Chautauqua | 20019 | 846 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-05-30 04:20:50 | Chautauqua, Kansas, US | |
2727676 | 2727676 | 2022-05-28 | US | Pennsylvania | Cameron | 42023 | 846 | 21 | 0 | 41.43625568 | -78.20376845 | 2022-05-29 04:20:53 | Cameron, Pennsylvania, US | |
2726287 | 2726287 | 2022-05-28 | US | Kansas | Chautauqua | 20019 | 846 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-05-29 04:20:53 | Chautauqua, Kansas, US | |
1316857 | 1316857 | 2022-05-27 | US | Pennsylvania | Cameron | 42023 | 846 | 21 | 0 | 41.43625568 | -78.20376845 | 2022-05-28 04:21:07 | Cameron, Pennsylvania, US | |
1315468 | 1315468 | 2022-05-27 | US | Kansas | Chautauqua | 20019 | 846 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-05-28 04:21:07 | Chautauqua, Kansas, US | |
1852649 | 1852649 | 2022-05-26 | US | Pennsylvania | Cameron | 42023 | 846 | 21 | 0 | 41.43625568 | -78.20376845 | 2022-05-27 04:20:56 | Cameron, Pennsylvania, US | |
1851260 | 1851260 | 2022-05-26 | US | Kansas | Chautauqua | 20019 | 846 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-05-27 04:20:56 | Chautauqua, Kansas, US | |
2050525 | 2050525 | 2022-05-25 | US | Pennsylvania | Cameron | 42023 | 846 | 21 | 0 | 41.43625568 | -78.20376845 | 2022-05-26 04:20:50 | Cameron, Pennsylvania, US | |
2049136 | 2049136 | 2022-05-25 | US | Kansas | Chautauqua | 20019 | 846 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-05-26 04:20:50 | Chautauqua, Kansas, US | |
3000574 | 3000574 | 2022-05-24 | US | Kansas | Chautauqua | 20019 | 846 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-05-25 04:20:56 | Chautauqua, Kansas, US | |
3594295 | 3594295 | 2022-05-23 | US | Kansas | Chautauqua | 20019 | 846 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-05-24 04:20:57 | Chautauqua, Kansas, US | |
624536 | 624536 | 2022-05-22 | US | Pennsylvania | Cameron | 42023 | 846 | 21 | 0 | 41.43625568 | -78.20376845 | 2022-05-26 04:20:50 | Cameron, Pennsylvania, 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]);