johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
682 rows where deaths = 457 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3525897 | 3525897 | 2022-11-24 | US | Ohio | Ashtabula | 39007 | 24596 | 457 | 0 | 41.70860332 | -80.74830218 | 2022-11-25 04:21:06 | Ashtabula, Ohio, US | |
3314680 | 3314680 | 2022-11-23 | US | Ohio | Ashtabula | 39007 | 24596 | 457 | 0 | 41.70860332 | -80.74830218 | 2022-11-24 04:21:09 | Ashtabula, Ohio, US | |
313328 | 313328 | 2022-11-13 | US | Kentucky | Kenton | 21117 | 50978 | 457 | 0 | 38.93950319 | -84.53241199 | 2022-11-14 04:21:09 | Kenton, Kentucky, US | |
64489 | 64489 | 2022-11-12 | US | Kentucky | Kenton | 21117 | 50978 | 457 | 0 | 38.93950319 | -84.53241199 | 2022-11-13 04:21:14 | Kenton, Kentucky, US | |
2928651 | 2928651 | 2022-11-11 | US | Kentucky | Kenton | 21117 | 50978 | 457 | 0 | 38.93950319 | -84.53241199 | 2022-11-12 04:20:41 | Kenton, Kentucky, US | |
2507487 | 2507487 | 2022-11-10 | US | Kentucky | Kenton | 21117 | 50978 | 457 | 0 | 38.93950319 | -84.53241199 | 2022-11-11 04:21:22 | Kenton, Kentucky, US | |
2432362 | 2432362 | 2022-11-09 | US | Kentucky | Kenton | 21117 | 50978 | 457 | 0 | 38.93950319 | -84.53241199 | 2022-11-10 04:21:16 | Kenton, Kentucky, US | |
481018 | 481018 | 2022-11-08 | US | Kentucky | Kenton | 21117 | 50978 | 457 | 0 | 38.93950319 | -84.53241199 | 2022-11-09 04:21:22 | Kenton, Kentucky, US | |
2440168 | 2440168 | 2022-11-07 | US | Kentucky | Kenton | 21117 | 50978 | 457 | 0 | 38.93950319 | -84.53241199 | 2022-11-08 04:21:21 | Kenton, Kentucky, US | |
850145 | 850145 | 2022-11-02 | US | California | Butte | 6007 | 49104 | 457 | 0 | 39.66727762 | -121.6005252 | 2022-11-03 04:22:05 | Butte, California, US | |
710996 | 710996 | 2022-11-01 | US | California | Butte | 6007 | 49095 | 457 | 0 | 39.66727762 | -121.6005252 | 2022-11-02 04:22:09 | Butte, California, US | |
3285445 | 3285445 | 2022-10-31 | US | California | Butte | 6007 | 48940 | 457 | 0 | 39.66727762 | -121.6005252 | 2022-11-01 04:22:36 | Butte, California, US | |
320478 | 320478 | 2022-10-30 | US | California | Butte | 6007 | 48929 | 457 | 0 | 39.66727762 | -121.6005252 | 2022-10-31 04:21:36 | Butte, California, US | |
912754 | 912754 | 2022-10-29 | US | California | Butte | 6007 | 48924 | 457 | 0 | 39.66727762 | -121.6005252 | 2022-10-30 04:22:14 | Butte, California, US | |
1367023 | 1367023 | 2022-10-28 | US | California | Butte | 6007 | 48921 | 457 | 0 | 39.66727762 | -121.6005252 | 2022-10-29 04:21:13 | Butte, California, US | |
3040862 | 3040862 | 2022-10-27 | US | Ohio | Wayne | 39169 | 27002 | 457 | 0 | 40.82925852 | -81.88844833 | 2022-10-28 04:22:31 | Wayne, Ohio, US | |
3038878 | 3038878 | 2022-10-27 | US | California | Butte | 6007 | 48917 | 457 | 0 | 39.66727762 | -121.6005252 | 2022-10-28 04:22:31 | Butte, California, US | |
541282 | 541282 | 2022-10-26 | US | Ohio | Wayne | 39169 | 26882 | 457 | 0 | 40.82925852 | -81.88844833 | 2022-10-27 04:22:01 | Wayne, Ohio, US | |
1832683 | 1832683 | 2022-10-25 | US | Ohio | Wayne | 39169 | 26882 | 457 | 0 | 40.82925852 | -81.88844833 | 2022-10-26 04:22:19 | Wayne, Ohio, US | |
1831015 | 1831015 | 2022-10-25 | US | Georgia | Paulding | 13223 | 44149 | 457 | 0 | 33.91969522 | -84.86848792 | 2022-10-26 04:22:19 | Paulding, Georgia, US | |
796944 | 796944 | 2022-10-24 | US | Ohio | Wayne | 39169 | 26882 | 457 | 0 | 40.82925852 | -81.88844833 | 2022-10-25 04:21:53 | Wayne, Ohio, US | |
795276 | 795276 | 2022-10-24 | US | Georgia | Paulding | 13223 | 44149 | 457 | 0 | 33.91969522 | -84.86848792 | 2022-10-25 04:21:53 | Paulding, Georgia, US | |
3277731 | 3277731 | 2022-10-23 | US | Georgia | Paulding | 13223 | 44149 | 457 | 0 | 33.91969522 | -84.86848792 | 2022-10-24 04:22:29 | Paulding, Georgia, US | |
2268769 | 2268769 | 2022-10-22 | US | Georgia | Paulding | 13223 | 44149 | 457 | 0 | 33.91969522 | -84.86848792 | 2022-10-23 04:22:46 | Paulding, Georgia, US | |
1593069 | 1593069 | 2022-10-21 | US | Georgia | Paulding | 13223 | 44149 | 457 | 0 | 33.91969522 | -84.86848792 | 2022-10-22 04:22:53 | Paulding, Georgia, US | |
2272785 | 2272785 | 2022-10-20 | US | Georgia | Paulding | 13223 | 44149 | 457 | 0 | 33.91969522 | -84.86848792 | 2022-10-21 04:22:23 | Paulding, Georgia, US | |
199120 | 199120 | 2022-10-19 | US | Georgia | Paulding | 13223 | 44149 | 457 | 0 | 33.91969522 | -84.86848792 | 2022-10-20 04:22:59 | Paulding, Georgia, US | |
2019696 | 2019696 | 2022-09-20 | US | Tennessee | Madison | 47113 | 35388 | 457 | 0 | 35.61181957 | -88.84076036 | 2022-09-21 04:23:22 | Madison, Tennessee, US | |
3573569 | 3573569 | 2022-09-19 | US | Tennessee | Madison | 47113 | 35356 | 457 | 0 | 35.61181957 | -88.84076036 | 2022-09-20 04:22:48 | Madison, Tennessee, US | |
2355461 | 2355461 | 2022-09-16 | Japan | Gunma | 225648 | 457 | 0 | 36.504479 | 138.985605 | 2022-09-17 04:20:19 | Gunma, Japan | |||
3986618 | 3986618 | 2022-09-15 | Japan | Gunma | 224593 | 457 | 0 | 36.504479 | 138.985605 | 2022-09-16 04:21:19 | Gunma, Japan | |||
1892114 | 1892114 | 2022-09-14 | US | Tennessee | Madison | 47113 | 35257 | 457 | 0 | 35.61181957 | -88.84076036 | 2022-09-15 04:21:02 | Madison, Tennessee, US | |
1889135 | 1889135 | 2022-09-14 | Japan | Gunma | 223217 | 457 | 0 | 36.504479 | 138.985605 | 2022-09-15 04:21:02 | Gunma, Japan | |||
375169 | 375169 | 2022-09-13 | US | Tennessee | Madison | 47113 | 35200 | 457 | 0 | 35.61181957 | -88.84076036 | 2022-09-14 04:20:44 | Madison, Tennessee, US | |
2397771 | 2397771 | 2022-09-12 | US | Tennessee | Madison | 47113 | 35150 | 457 | 0 | 35.61181957 | -88.84076036 | 2022-09-13 04:20:57 | Madison, Tennessee, US | |
3768849 | 3768849 | 2022-09-11 | US | Tennessee | Madison | 47113 | 35127 | 457 | 0 | 35.61181957 | -88.84076036 | 2022-09-12 04:20:58 | Madison, Tennessee, US | |
3827424 | 3827424 | 2022-09-10 | US | Tennessee | Madison | 47113 | 35118 | 457 | 0 | 35.61181957 | -88.84076036 | 2022-09-11 04:20:50 | Madison, Tennessee, US | |
965881 | 965881 | 2022-09-09 | US | Tennessee | Madison | 47113 | 35096 | 457 | 0 | 35.61181957 | -88.84076036 | 2022-09-10 04:21:10 | Madison, Tennessee, US | |
256283 | 256283 | 2022-09-08 | US | Tennessee | Madison | 47113 | 35062 | 457 | 0 | 35.61181957 | -88.84076036 | 2022-09-09 04:21:11 | Madison, Tennessee, US | |
253337 | 253337 | 2022-09-08 | Japan | Tochigi | 206222 | 457 | 0 | 36.689912 | 139.819213 | 2022-09-09 04:21:11 | Tochigi, Japan | |||
3748081 | 3748081 | 2022-09-07 | US | Tennessee | Madison | 47113 | 35004 | 457 | 0 | 35.61181957 | -88.84076036 | 2022-09-08 04:21:02 | Madison, Tennessee, US | |
117721 | 117721 | 2022-09-06 | US | Tennessee | Madison | 47113 | 34938 | 457 | 0 | 35.61181957 | -88.84076036 | 2022-09-07 04:20:59 | Madison, Tennessee, US | |
2636693 | 2636693 | 2022-09-05 | US | Tennessee | Madison | 47113 | 34919 | 457 | 0 | 35.61181957 | -88.84076036 | 2022-09-06 04:21:02 | Madison, Tennessee, US | |
2990257 | 2990257 | 2022-09-04 | US | Tennessee | Madison | 47113 | 34916 | 457 | 0 | 35.61181957 | -88.84076036 | 2022-09-05 04:21:01 | Madison, Tennessee, US | |
2715942 | 2715942 | 2022-09-03 | US | Tennessee | Madison | 47113 | 34905 | 457 | 0 | 35.61181957 | -88.84076036 | 2022-09-04 04:21:22 | Madison, Tennessee, US | |
1396647 | 1396647 | 2022-09-02 | US | Tennessee | Madison | 47113 | 34890 | 457 | 0 | 35.61181957 | -88.84076036 | 2022-09-03 04:21:04 | Madison, Tennessee, US | |
3550476 | 3550476 | 2022-09-01 | US | Tennessee | Madison | 47113 | 34850 | 457 | 0 | 35.61181957 | -88.84076036 | 2022-09-02 04:21:07 | Madison, Tennessee, US | |
3774811 | 3774811 | 2022-08-30 | US | Georgia | Whitfield | 13313 | 37203 | 457 | 0 | 34.80987459 | -84.96093476 | 2022-08-31 04:20:57 | Whitfield, Georgia, US | |
1681407 | 1681407 | 2022-08-29 | US | Georgia | Whitfield | 13313 | 37203 | 457 | 0 | 34.80987459 | -84.96093476 | 2022-08-30 04:21:03 | Whitfield, Georgia, US | |
1877891 | 1877891 | 2022-08-28 | US | Georgia | Whitfield | 13313 | 37203 | 457 | 0 | 34.80987459 | -84.96093476 | 2022-08-29 04:21:06 | Whitfield, Georgia, US | |
2097018 | 2097018 | 2022-08-27 | US | Georgia | Whitfield | 13313 | 37203 | 457 | 0 | 34.80987459 | -84.96093476 | 2022-08-28 04:21:02 | Whitfield, Georgia, US | |
1532833 | 1532833 | 2022-08-26 | US | Georgia | Whitfield | 13313 | 37203 | 457 | 0 | 34.80987459 | -84.96093476 | 2022-08-27 04:20:57 | Whitfield, Georgia, US | |
2829720 | 2829720 | 2022-08-25 | US | Georgia | Whitfield | 13313 | 37203 | 457 | 0 | 34.80987459 | -84.96093476 | 2022-08-26 04:21:02 | Whitfield, Georgia, US | |
2324253 | 2324253 | 2022-08-24 | US | Georgia | Whitfield | 13313 | 37203 | 457 | 0 | 34.80987459 | -84.96093476 | 2022-08-25 04:21:13 | Whitfield, Georgia, US | |
2323360 | 2323360 | 2022-08-24 | Japan | Nara | 180530 | 457 | 0 | 34.317451 | 135.871644 | 2022-08-25 04:21:13 | Nara, Japan | |||
1251513 | 1251513 | 2022-08-23 | US | Georgia | Bartow | 13015 | 32183 | 457 | 0 | 34.23732119 | -84.83887523 | 2022-08-24 04:20:46 | Bartow, Georgia, US | |
2853617 | 2853617 | 2022-08-22 | US | Georgia | Bartow | 13015 | 32183 | 457 | 0 | 34.23732119 | -84.83887523 | 2022-08-23 04:20:56 | Bartow, Georgia, US | |
2853449 | 2853449 | 2022-08-22 | US | California | Solano | 6095 | 110288 | 457 | 0 | 38.26827353 | -121.9357113 | 2022-08-23 04:20:56 | Solano, California, US | |
2403589 | 2403589 | 2022-08-21 | US | Georgia | Bartow | 13015 | 32183 | 457 | 0 | 34.23732119 | -84.83887523 | 2022-08-22 04:20:38 | Bartow, Georgia, US | |
2403421 | 2403421 | 2022-08-21 | US | California | Solano | 6095 | 110000 | 457 | 0 | 38.26827353 | -121.9357113 | 2022-08-22 04:20:38 | Solano, California, US | |
3798667 | 3798667 | 2022-08-20 | US | Georgia | Bartow | 13015 | 32183 | 457 | 0 | 34.23732119 | -84.83887523 | 2022-08-21 04:20:44 | Bartow, Georgia, US | |
3798499 | 3798499 | 2022-08-20 | US | California | Solano | 6095 | 109992 | 457 | 0 | 38.26827353 | -121.9357113 | 2022-08-21 04:20:44 | Solano, California, US | |
2364253 | 2364253 | 2022-08-19 | US | Georgia | Bartow | 13015 | 32183 | 457 | 0 | 34.23732119 | -84.83887523 | 2022-08-20 04:21:01 | Bartow, Georgia, US | |
2364085 | 2364085 | 2022-08-19 | US | California | Solano | 6095 | 109984 | 457 | 0 | 38.26827353 | -121.9357113 | 2022-08-20 04:21:01 | Solano, California, US | |
1161924 | 1161924 | 2022-08-18 | US | Georgia | Bartow | 13015 | 32183 | 457 | 0 | 34.23732119 | -84.83887523 | 2022-08-19 04:20:54 | Bartow, Georgia, US | |
3951248 | 3951248 | 2022-08-17 | US | Georgia | Bartow | 13015 | 32183 | 457 | 0 | 34.23732119 | -84.83887523 | 2022-08-18 04:21:11 | Bartow, Georgia, US | |
994459 | 994459 | 2022-08-16 | US | Washington | Thurston | 53067 | 57537 | 457 | 0 | 46.9291895 | -122.8290656 | 2022-08-17 04:20:59 | Thurston, Washington, US | |
2497498 | 2497498 | 2022-08-15 | US | Washington | Thurston | 53067 | 57537 | 457 | 0 | 46.9291895 | -122.8290656 | 2022-08-16 04:20:58 | Thurston, Washington, US | |
3651048 | 3651048 | 2022-08-14 | US | Washington | Thurston | 53067 | 57394 | 457 | 0 | 46.9291895 | -122.8290656 | 2022-08-15 04:20:59 | Thurston, Washington, US | |
3648996 | 3648996 | 2022-08-14 | US | Kentucky | Hardin | 21093 | 37579 | 457 | 0 | 37.6976111 | -85.96319251 | 2022-08-15 04:20:59 | Hardin, Kentucky, US | |
1972054 | 1972054 | 2022-08-13 | US | Washington | Thurston | 53067 | 57394 | 457 | 0 | 46.9291895 | -122.8290656 | 2022-08-14 04:20:55 | Thurston, Washington, US | |
1970002 | 1970002 | 2022-08-13 | US | Kentucky | Hardin | 21093 | 37579 | 457 | 0 | 37.6976111 | -85.96319251 | 2022-08-14 04:20:55 | Hardin, Kentucky, US | |
2891863 | 2891863 | 2022-08-12 | US | Washington | Thurston | 53067 | 57394 | 457 | 0 | 46.9291895 | -122.8290656 | 2022-08-13 04:20:52 | Thurston, Washington, US | |
2890906 | 2890906 | 2022-08-12 | US | Ohio | Portage | 39133 | 38527 | 457 | 0 | 41.16793482 | -81.19735782 | 2022-08-13 04:20:52 | Portage, Ohio, US | |
2889811 | 2889811 | 2022-08-12 | US | Kentucky | Hardin | 21093 | 37579 | 457 | 0 | 37.6976111 | -85.96319251 | 2022-08-13 04:20:52 | Hardin, Kentucky, US | |
3910511 | 3910511 | 2022-08-11 | US | Ohio | Portage | 39133 | 38527 | 457 | 0 | 41.16793482 | -81.19735782 | 2022-08-12 04:20:54 | Portage, Ohio, US | |
3909416 | 3909416 | 2022-08-11 | US | Kentucky | Hardin | 21093 | 37579 | 457 | 0 | 37.6976111 | -85.96319251 | 2022-08-12 04:20:54 | Hardin, Kentucky, US | |
3909087 | 3909087 | 2022-08-11 | US | Indiana | Delaware | 18035 | 27144 | 457 | 0 | 40.22787247 | -85.39732772 | 2022-08-12 04:20:54 | Delaware, Indiana, US | |
3908591 | 3908591 | 2022-08-11 | US | California | Solano | 6095 | 109292 | 457 | 0 | 38.26827353 | -121.9357113 | 2022-08-12 04:20:54 | Solano, California, US | |
1347733 | 1347733 | 2022-08-10 | US | Kentucky | Hardin | 21093 | 37579 | 457 | 0 | 37.6976111 | -85.96319251 | 2022-08-11 04:20:49 | Hardin, Kentucky, US | |
1347404 | 1347404 | 2022-08-10 | US | Indiana | Delaware | 18035 | 27144 | 457 | 0 | 40.22787247 | -85.39732772 | 2022-08-11 04:20:49 | Delaware, Indiana, US | |
1346908 | 1346908 | 2022-08-10 | US | California | Solano | 6095 | 108919 | 457 | 0 | 38.26827353 | -121.9357113 | 2022-08-11 04:20:49 | Solano, California, US | |
1087488 | 1087488 | 2022-08-09 | US | Kentucky | Hardin | 21093 | 37579 | 457 | 0 | 37.6976111 | -85.96319251 | 2022-08-10 04:20:57 | Hardin, Kentucky, US | |
1087175 | 1087175 | 2022-08-09 | US | Indiana | Howard | 18067 | 27403 | 457 | 0 | 40.48527731 | -86.11351892 | 2022-08-10 04:20:57 | Howard, Indiana, US | |
1087159 | 1087159 | 2022-08-09 | US | Indiana | Delaware | 18035 | 27071 | 457 | 0 | 40.22787247 | -85.39732772 | 2022-08-10 04:20:57 | Delaware, Indiana, US | |
1086663 | 1086663 | 2022-08-09 | US | California | Solano | 6095 | 108907 | 457 | 0 | 38.26827353 | -121.9357113 | 2022-08-10 04:20:57 | Solano, California, US | |
3544903 | 3544903 | 2022-08-08 | US | Kentucky | Hardin | 21093 | 37579 | 457 | 0 | 37.6976111 | -85.96319251 | 2022-08-09 04:20:34 | Hardin, Kentucky, US | |
3544590 | 3544590 | 2022-08-08 | US | Indiana | Howard | 18067 | 27403 | 457 | 0 | 40.48527731 | -86.11351892 | 2022-08-09 04:20:34 | Howard, Indiana, US | |
3544574 | 3544574 | 2022-08-08 | US | Indiana | Delaware | 18035 | 27071 | 457 | 0 | 40.22787247 | -85.39732772 | 2022-08-09 04:20:34 | Delaware, Indiana, US | |
3544078 | 3544078 | 2022-08-08 | US | California | Solano | 6095 | 108891 | 457 | 0 | 38.26827353 | -121.9357113 | 2022-08-09 04:20:34 | Solano, California, US | |
1070993 | 1070993 | 2022-08-07 | US | Indiana | Howard | 18067 | 27347 | 457 | 0 | 40.48527731 | -86.11351892 | 2022-08-08 04:21:08 | Howard, Indiana, US | |
1070977 | 1070977 | 2022-08-07 | US | Indiana | Delaware | 18035 | 27022 | 457 | 0 | 40.22787247 | -85.39732772 | 2022-08-08 04:21:08 | Delaware, Indiana, US | |
1070481 | 1070481 | 2022-08-07 | US | California | Solano | 6095 | 107561 | 457 | 0 | 38.26827353 | -121.9357113 | 2022-08-08 04:21:08 | Solano, California, US | |
1941581 | 1941581 | 2022-08-06 | US | Indiana | Howard | 18067 | 27347 | 457 | 0 | 40.48527731 | -86.11351892 | 2022-08-07 04:20:54 | Howard, Indiana, US | |
1941565 | 1941565 | 2022-08-06 | US | Indiana | Delaware | 18035 | 27022 | 457 | 0 | 40.22787247 | -85.39732772 | 2022-08-07 04:20:54 | Delaware, Indiana, US | |
1941069 | 1941069 | 2022-08-06 | US | California | Solano | 6095 | 107555 | 457 | 0 | 38.26827353 | -121.9357113 | 2022-08-07 04:20:54 | Solano, California, US | |
881380 | 881380 | 2022-08-05 | US | Indiana | Howard | 18067 | 27347 | 457 | 0 | 40.48527731 | -86.11351892 | 2022-08-06 04:20:56 | Howard, Indiana, US | |
881364 | 881364 | 2022-08-05 | US | Indiana | Delaware | 18035 | 27022 | 457 | 0 | 40.22787247 | -85.39732772 | 2022-08-06 04:20:56 | Delaware, Indiana, US | |
880868 | 880868 | 2022-08-05 | US | California | Solano | 6095 | 107547 | 457 | 0 | 38.26827353 | -121.9357113 | 2022-08-06 04:20:56 | Solano, California, US | |
2009775 | 2009775 | 2022-08-04 | US | Indiana | Delaware | 18035 | 26949 | 457 | 0 | 40.22787247 | -85.39732772 | 2022-08-05 04:20:52 | Delaware, Indiana, 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]);