johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
527 rows where confirmed = 931 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
433767 | 433767 | 2022-11-03 | US | North Dakota | Hettinger | 38041 | 931 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-11-04 04:22:11 | Hettinger, North Dakota, US | |
712849 | 712849 | 2022-11-01 | US | North Dakota | Cavalier | 38019 | 931 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-11-02 04:22:09 | Cavalier, North Dakota, US | |
1833325 | 1833325 | 2022-10-25 | US | Texas | Mason | 48319 | 931 | 13 | 0 | 30.71780434 | -99.22629416 | 2022-10-26 04:22:19 | Mason, Texas, US | |
797586 | 797586 | 2022-10-24 | US | Texas | Mason | 48319 | 931 | 13 | 0 | 30.71780434 | -99.22629416 | 2022-10-25 04:21:53 | Mason, Texas, US | |
3251419 | 3251419 | 2022-10-11 | US | Kansas | Chautauqua | 20019 | 931 | 20 | 0 | 37.14994405 | -96.2454192 | 2022-10-12 04:22:51 | Chautauqua, Kansas, US | |
2968678 | 2968678 | 2022-10-10 | US | Kansas | Chautauqua | 20019 | 931 | 20 | 0 | 37.14994405 | -96.2454192 | 2022-10-11 04:23:05 | Chautauqua, Kansas, US | |
3098714 | 3098714 | 2022-10-09 | US | Kansas | Chautauqua | 20019 | 931 | 20 | 0 | 37.14994405 | -96.2454192 | 2022-10-10 04:22:32 | Chautauqua, Kansas, US | |
4003939 | 4003939 | 2022-10-08 | US | Kansas | Chautauqua | 20019 | 931 | 20 | 0 | 37.14994405 | -96.2454192 | 2022-10-09 04:21:16 | Chautauqua, Kansas, US | |
397536 | 397536 | 2022-10-07 | US | Kansas | Chautauqua | 20019 | 931 | 20 | 0 | 37.14994405 | -96.2454192 | 2022-10-08 04:22:56 | Chautauqua, Kansas, US | |
2530653 | 2530653 | 2022-10-06 | US | Kansas | Chautauqua | 20019 | 931 | 20 | 0 | 37.14994405 | -96.2454192 | 2022-10-07 04:23:08 | Chautauqua, Kansas, US | |
1812984 | 1812984 | 2022-10-05 | US | New Mexico | Mora | 35033 | 931 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-10-06 04:21:22 | Mora, New Mexico, US | |
1812047 | 1812047 | 2022-10-05 | US | Kansas | Chautauqua | 20019 | 931 | 20 | 0 | 37.14994405 | -96.2454192 | 2022-10-06 04:21:22 | Chautauqua, Kansas, US | |
132958 | 132958 | 2022-10-04 | US | New Mexico | Mora | 35033 | 931 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-10-05 04:23:06 | Mora, New Mexico, US | |
2687905 | 2687905 | 2022-10-03 | US | New Mexico | Mora | 35033 | 931 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-10-04 04:22:55 | Mora, New Mexico, US | |
2261972 | 2261972 | 2022-10-02 | US | New Mexico | Mora | 35033 | 931 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-10-03 04:23:11 | Mora, New Mexico, US | |
2997498 | 2997498 | 2022-10-01 | US | New Mexico | Mora | 35033 | 931 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-10-02 04:21:23 | Mora, New Mexico, US | |
855824 | 855824 | 2022-09-30 | US | New Mexico | Mora | 35033 | 931 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-10-01 04:23:01 | Mora, New Mexico, US | |
2377750 | 2377750 | 2022-09-29 | US | New Mexico | Mora | 35033 | 931 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-09-30 04:23:09 | Mora, New Mexico, US | |
1562301 | 1562301 | 2022-09-28 | US | New Mexico | Mora | 35033 | 931 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-09-29 04:22:34 | Mora, New Mexico, US | |
2856065 | 2856065 | 2022-08-22 | US | Texas | Reagan | 48383 | 931 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-08-23 04:20:56 | Reagan, Texas, US | |
2406038 | 2406038 | 2022-08-21 | US | Texas | Real | 48385 | 931 | 25 | 0 | 29.83321503 | -99.82018052 | 2022-08-22 04:20:38 | Real, Texas, US | |
2406037 | 2406037 | 2022-08-21 | US | Texas | Reagan | 48383 | 931 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-08-22 04:20:38 | Reagan, Texas, US | |
3801116 | 3801116 | 2022-08-20 | US | Texas | Real | 48385 | 931 | 25 | 0 | 29.83321503 | -99.82018052 | 2022-08-21 04:20:44 | Real, Texas, US | |
3801115 | 3801115 | 2022-08-20 | US | Texas | Reagan | 48383 | 931 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-08-21 04:20:44 | Reagan, Texas, US | |
2366702 | 2366702 | 2022-08-19 | US | Texas | Real | 48385 | 931 | 25 | 0 | 29.83321503 | -99.82018052 | 2022-08-20 04:21:01 | Real, Texas, US | |
2366701 | 2366701 | 2022-08-19 | US | Texas | Reagan | 48383 | 931 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-08-20 04:21:01 | Reagan, Texas, US | |
1164372 | 1164372 | 2022-08-18 | US | Texas | Reagan | 48383 | 931 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-08-19 04:20:54 | Reagan, Texas, US | |
3408573 | 3408573 | 2022-07-17 | US | Texas | Haskell | 48207 | 931 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-07-18 04:20:59 | Haskell, Texas, US | |
3406876 | 3406876 | 2022-07-17 | US | Kentucky | Hickman | 21105 | 931 | 28 | 0 | 36.6794808 | -88.97875928 | 2022-07-18 04:20:59 | Hickman, Kentucky, US | |
2153076 | 2153076 | 2022-07-16 | US | Kentucky | Hickman | 21105 | 931 | 28 | 0 | 36.6794808 | -88.97875928 | 2022-07-17 04:21:15 | Hickman, Kentucky, US | |
2420309 | 2420309 | 2022-07-15 | US | Kentucky | Hickman | 21105 | 931 | 28 | 0 | 36.6794808 | -88.97875928 | 2022-07-16 04:21:05 | Hickman, Kentucky, US | |
3430384 | 3430384 | 2022-07-14 | US | Kentucky | Hickman | 21105 | 931 | 28 | 0 | 36.6794808 | -88.97875928 | 2022-07-15 04:20:53 | Hickman, Kentucky, US | |
3110904 | 3110904 | 2022-07-13 | US | Kentucky | Hickman | 21105 | 931 | 28 | 0 | 36.6794808 | -88.97875928 | 2022-07-14 04:20:57 | Hickman, Kentucky, US | |
631327 | 631327 | 2022-07-12 | US | Kentucky | Hickman | 21105 | 931 | 28 | 0 | 36.6794808 | -88.97875928 | 2022-07-13 04:20:58 | Hickman, Kentucky, US | |
1212971 | 1212971 | 2022-07-11 | US | Kentucky | Hickman | 21105 | 931 | 28 | 0 | 36.6794808 | -88.97875928 | 2022-07-12 04:20:51 | Hickman, Kentucky, US | |
3581933 | 3581933 | 2022-06-02 | US | Virginia | Bath | 51017 | 931 | 20 | 0 | 38.05852573 | -79.73912095 | 2022-06-03 04:20:58 | Bath, Virginia, US | |
3188233 | 3188233 | 2022-05-30 | US | New York | Hamilton | 36041 | 931 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-05-31 04:20:51 | Hamilton, New York, US | |
3200382 | 3200382 | 2022-05-29 | US | New York | Hamilton | 36041 | 931 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-05-30 04:20:50 | Hamilton, New York, US | |
2727260 | 2727260 | 2022-05-28 | US | New York | Hamilton | 36041 | 931 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-05-29 04:20:53 | Hamilton, New York, US | |
1316441 | 1316441 | 2022-05-27 | US | New York | Hamilton | 36041 | 931 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-05-28 04:21:07 | Hamilton, New York, US | |
1852233 | 1852233 | 2022-05-26 | US | New York | Hamilton | 36041 | 931 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-05-27 04:20:56 | Hamilton, New York, US | |
3869304 | 3869304 | 2022-04-05 | US | Minnesota | Red Lake | 27125 | 931 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-04-06 04:20:49 | Red Lake, Minnesota, US | |
2750646 | 2750646 | 2022-04-04 | US | Minnesota | Red Lake | 27125 | 931 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-04-05 04:20:48 | Red Lake, Minnesota, US | |
3731992 | 3731992 | 2022-04-03 | US | Minnesota | Red Lake | 27125 | 931 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-04-04 04:20:51 | Red Lake, Minnesota, US | |
501427 | 501427 | 2022-04-02 | US | Minnesota | Red Lake | 27125 | 931 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-04-03 04:20:48 | Red Lake, Minnesota, US | |
3352412 | 3352412 | 2022-04-01 | US | Minnesota | Red Lake | 27125 | 931 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-04-02 04:20:47 | Red Lake, Minnesota, US | |
1541717 | 1541717 | 2022-03-31 | US | Minnesota | Red Lake | 27125 | 931 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-04-01 04:20:28 | Red Lake, Minnesota, US | |
877061 | 877061 | 2022-03-27 | US | Georgia | Echols | 13101 | 931 | 11 | 0 | 30.71101099 | -82.89687287 | 2022-03-28 04:20:33 | Echols, Georgia, US | |
2164344 | 2164344 | 2022-03-26 | US | Georgia | Echols | 13101 | 931 | 11 | 0 | 30.71101099 | -82.89687287 | 2022-03-27 04:20:47 | Echols, Georgia, US | |
1721280 | 1721280 | 2022-03-25 | US | Georgia | Echols | 13101 | 931 | 11 | 0 | 30.71101099 | -82.89687287 | 2022-03-26 04:20:23 | Echols, Georgia, US | |
1468897 | 1468897 | 2022-03-24 | US | Georgia | Echols | 13101 | 931 | 11 | 0 | 30.71101099 | -82.89687287 | 2022-03-25 04:20:46 | Echols, Georgia, US | |
3023071 | 3023071 | 2022-03-23 | US | Georgia | Echols | 13101 | 931 | 11 | 0 | 30.71101099 | -82.89687287 | 2022-03-24 04:20:43 | Echols, Georgia, US | |
1905993 | 1905993 | 2022-03-22 | US | Georgia | Echols | 13101 | 931 | 11 | 0 | 30.71101099 | -82.89687287 | 2022-03-23 04:20:48 | Echols, Georgia, US | |
1549730 | 1549730 | 2022-03-07 | US | Minnesota | Red Lake | 27125 | 931 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-03-08 04:20:54 | Red Lake, Minnesota, US | |
944592 | 944592 | 2022-02-28 | US | Minnesota | Red Lake | 27125 | 931 | 12 | 0 | 47.87197525 | -96.09561104 | 2022-03-01 04:21:09 | Red Lake, Minnesota, US | |
3046646 | 3046646 | 2022-02-26 | US | Arkansas | Calhoun | 5013 | 931 | 9 | 0 | 33.55598792 | -92.49974403 | 2022-02-27 04:21:04 | Calhoun, Arkansas, US | |
1465931 | 1465931 | 2022-02-10 | US | Mississippi | Sharkey | 28125 | 931 | 22 | 0 | 32.88149103 | -90.81595379999999 | 2022-02-11 04:21:09 | Sharkey, Mississippi, US | |
3075083 | 3075083 | 2022-02-09 | US | Illinois | Pope | 17151 | 931 | 7 | 0 | 37.41391284 | -88.56152109 | 2022-02-10 04:21:14 | Pope, Illinois, US | |
1364725 | 1364725 | 2022-02-08 | US | North Carolina | Tyrrell | 37177 | 931 | 7 | 0 | 35.87147226 | -76.17055253 | 2022-02-09 04:21:04 | Tyrrell, North Carolina, US | |
72475 | 72475 | 2022-02-07 | US | Kentucky | Carlisle | 21039 | 931 | 17 | 0 | 36.85372876 | -88.96692220000001 | 2022-02-08 04:21:15 | Carlisle, Kentucky, US | |
2475631 | 2475631 | 2022-02-03 | US | Michigan | Ontonagon | 26131 | 931 | 34 | 0 | 46.665226200000006 | -89.31390481 | 2022-02-04 04:21:10 | Ontonagon, Michigan, US | |
461780 | 461780 | 2022-02-02 | US | North Dakota | Foster | 38031 | 931 | 20 | 0 | 47.457108399999996 | -98.88279923 | 2022-02-03 04:21:21 | Foster, North Dakota, US | |
461056 | 461056 | 2022-02-02 | US | Michigan | Ontonagon | 26131 | 931 | 34 | 0 | 46.665226200000006 | -89.31390481 | 2022-02-03 04:21:21 | Ontonagon, Michigan, US | |
981504 | 981504 | 2022-02-01 | US | Oklahoma | Grant | 40053 | 931 | 12 | 0 | 36.796296999999996 | -97.78638765 | 2022-02-02 04:21:09 | Grant, Oklahoma, US | |
2660346 | 2660346 | 2022-01-31 | US | Oklahoma | Grant | 40053 | 931 | 12 | 0 | 36.796296999999996 | -97.78638765 | 2022-02-01 04:21:11 | Grant, Oklahoma, US | |
3302763 | 3302763 | 2022-01-30 | US | Oklahoma | Grant | 40053 | 931 | 12 | 0 | 36.796296999999996 | -97.78638765 | 2022-01-31 04:21:09 | Grant, Oklahoma, US | |
3064554 | 3064554 | 2022-01-29 | US | Oklahoma | Grant | 40053 | 931 | 12 | 0 | 36.796296999999996 | -97.78638765 | 2022-01-30 04:21:26 | Grant, Oklahoma, US | |
3064424 | 3064424 | 2022-01-29 | US | North Dakota | Sargent | 38081 | 931 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-01-30 04:21:26 | Sargent, North Dakota, US | |
3812488 | 3812488 | 2022-01-28 | US | Oklahoma | Grant | 40053 | 931 | 12 | 0 | 36.796296999999996 | -97.78638765 | 2022-01-29 04:21:10 | Grant, Oklahoma, US | |
1781942 | 1781942 | 2022-01-27 | US | Oklahoma | Grant | 40053 | 931 | 12 | 0 | 36.796296999999996 | -97.78638765 | 2022-01-28 04:21:09 | Grant, Oklahoma, US | |
1320770 | 1320770 | 2022-01-26 | US | Oklahoma | Grant | 40053 | 931 | 12 | 0 | 36.796296999999996 | -97.78638765 | 2022-01-27 04:21:19 | Grant, Oklahoma, US | |
2054004 | 2054004 | 2022-01-25 | US | Nebraska | Sheridan | 31161 | 931 | 10 | 0 | 42.50284406 | -102.4126613 | 2022-01-26 04:21:07 | Sheridan, Nebraska, US | |
1229735 | 1229735 | 2022-01-24 | US | Nebraska | Sheridan | 31161 | 931 | 10 | 0 | 42.50284406 | -102.4126613 | 2022-01-25 04:21:05 | Sheridan, Nebraska, US | |
1144457 | 1144457 | 2022-01-23 | US | Wisconsin | Florence | 55037 | 931 | 15 | 0 | 45.84963535 | -88.39804137 | 2022-01-24 04:21:12 | Florence, Wisconsin, US | |
2836375 | 2836375 | 2022-01-22 | US | Wisconsin | Florence | 55037 | 931 | 15 | 0 | 45.84963535 | -88.39804137 | 2022-01-23 04:21:13 | Florence, Wisconsin, US | |
2833492 | 2833492 | 2022-01-22 | US | Colorado | Washington | 8121 | 931 | 27 | 0 | 39.97015535 | -103.202587 | 2022-01-23 04:21:13 | Washington, Colorado, US | |
3428493 | 3428493 | 2022-01-21 | US | Wisconsin | Florence | 55037 | 931 | 15 | 0 | 45.84963535 | -88.39804137 | 2022-01-22 04:21:13 | Florence, Wisconsin, US | |
3425610 | 3425610 | 2022-01-21 | US | Colorado | Washington | 8121 | 931 | 27 | 0 | 39.97015535 | -103.202587 | 2022-01-22 04:21:13 | Washington, Colorado, US | |
1962994 | 1962994 | 2022-01-20 | US | North Dakota | Wells | 38103 | 931 | 11 | 0 | 47.58614526 | -99.65904998 | 2022-01-21 04:21:09 | Wells, North Dakota, US | |
3229317 | 3229317 | 2022-01-19 | US | South Dakota | Deuel | 46039 | 931 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-01-20 04:21:07 | Deuel, South Dakota, US | |
3467235 | 3467235 | 2022-01-18 | US | Texas | Concho | 48095 | 931 | 10 | 0 | 31.32635934 | -99.86473038 | 2022-01-19 04:21:23 | Concho, Texas, US | |
1474073 | 1474073 | 2022-01-17 | US | Missouri | Reynolds | 29179 | 931 | 18 | 0 | 37.36085952 | -90.97009925 | 2022-01-18 04:21:04 | Reynolds, Missouri, US | |
1473155 | 1473155 | 2022-01-17 | US | Illinois | Putnam | 17155 | 931 | 7 | 0 | 41.2013541 | -89.2869272 | 2022-01-18 04:21:04 | Putnam, Illinois, US | |
556747 | 556747 | 2022-01-16 | US | Missouri | Reynolds | 29179 | 931 | 18 | 0 | 37.36085952 | -90.97009925 | 2022-01-17 04:21:08 | Reynolds, Missouri, US | |
555829 | 555829 | 2022-01-16 | US | Illinois | Putnam | 17155 | 931 | 7 | 0 | 41.2013541 | -89.2869272 | 2022-01-17 04:21:08 | Putnam, Illinois, US | |
3842468 | 3842468 | 2022-01-15 | US | Missouri | Reynolds | 29179 | 931 | 18 | 0 | 37.36085952 | -90.97009925 | 2022-01-16 04:21:12 | Reynolds, Missouri, US | |
3841550 | 3841550 | 2022-01-15 | US | Illinois | Putnam | 17155 | 931 | 7 | 0 | 41.2013541 | -89.2869272 | 2022-01-16 04:21:12 | Putnam, Illinois, US | |
100365 | 100365 | 2022-01-14 | US | Illinois | Putnam | 17155 | 931 | 7 | 0 | 41.2013541 | -89.2869272 | 2022-01-15 04:21:07 | Putnam, Illinois, US | |
3689900 | 3689900 | 2022-01-13 | US | North Dakota | Pierce | 38069 | 931 | 29 | 0 | 48.24977025 | -99.96407787 | 2022-01-14 04:21:54 | Pierce, North Dakota, US | |
3615796 | 3615796 | 2022-01-12 | US | Puerto Rico | Ceiba | 72037 | 931 | 0 | 0 | 18.251818 | -65.666416 | 2022-01-13 08:00:09 | Ceiba, Puerto Rico, US | |
3520752 | 3520752 | 2022-01-02 | US | Kansas | Mitchell | 20123 | 931 | 17 | 0 | 39.39331582 | -98.20906732 | 2022-01-03 02:22:25 | Mitchell, Kansas, US | |
2168882 | 2168882 | 2022-01-01 | US | Kansas | Mitchell | 20123 | 931 | 17 | 0 | 39.39331582 | -98.20906732 | 2022-01-02 04:20:52 | Mitchell, Kansas, US | |
2780157 | 2780157 | 2021-12-31 | US | Texas | Lynn | 48305 | 931 | 29 | 0 | 33.17657705 | -101.8162849 | 2022-01-01 04:22:14 | Lynn, Texas, US | |
2778313 | 2778313 | 2021-12-31 | US | Kansas | Mitchell | 20123 | 931 | 17 | 0 | 39.39331582 | -98.20906732 | 2022-01-01 04:22:14 | Mitchell, Kansas, US | |
4001814 | 4001814 | 2021-12-30 | US | Texas | Lynn | 48305 | 931 | 29 | 0 | 33.17657705 | -101.8162849 | 2021-12-31 04:21:50 | Lynn, Texas, US | |
3999970 | 3999970 | 2021-12-30 | US | Kansas | Mitchell | 20123 | 931 | 17 | 0 | 39.39331582 | -98.20906732 | 2021-12-31 04:21:50 | Mitchell, Kansas, US | |
1669777 | 1669777 | 2021-12-29 | US | Kansas | Mitchell | 20123 | 931 | 17 | 0 | 39.39331582 | -98.20906732 | 2021-12-30 04:21:25 | Mitchell, Kansas, US | |
2113733 | 2113733 | 2021-12-26 | US | Montana | Teton | 30099 | 931 | 19 | 0 | 47.83741052 | -112.24106880000001 | 2021-12-27 04:21:58 | Teton, Montana, US | |
3607105 | 3607105 | 2021-12-25 | US | Montana | Teton | 30099 | 931 | 19 | 0 | 47.83741052 | -112.24106880000001 | 2021-12-26 04:21:50 | Teton, Montana, US | |
2965423 | 2965423 | 2021-12-24 | US | Montana | Teton | 30099 | 931 | 19 | 0 | 47.83741052 | -112.24106880000001 | 2021-12-25 04:21:37 | Teton, Montana, 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]);