johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
707 rows where deaths = 471 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
451933 | 451933 | 2022-12-21 | US | California | Butte | 6007 | 50626 | 471 | 0 | 39.66727762 | -121.6005252 | 2022-12-22 04:20:56 | Butte, California, US | |
2951932 | 2951932 | 2022-12-20 | US | California | Butte | 6007 | 50626 | 471 | 0 | 39.66727762 | -121.6005252 | 2022-12-21 04:21:03 | Butte, California, US | |
3174334 | 3174334 | 2022-12-19 | US | California | Butte | 6007 | 50503 | 471 | 0 | 39.66727762 | -121.6005252 | 2022-12-20 04:21:04 | Butte, California, US | |
1628851 | 1628851 | 2022-12-18 | US | California | Butte | 6007 | 50502 | 471 | 0 | 39.66727762 | -121.6005252 | 2022-12-19 04:21:03 | Butte, California, US | |
504230 | 504230 | 2022-12-17 | US | California | Butte | 6007 | 50502 | 471 | 0 | 39.66727762 | -121.6005252 | 2022-12-18 04:21:03 | Butte, California, US | |
3324802 | 3324802 | 2022-12-16 | US | California | Butte | 6007 | 50501 | 471 | 0 | 39.66727762 | -121.6005252 | 2022-12-17 04:21:04 | Butte, California, US | |
543314 | 543314 | 2022-12-15 | US | California | Butte | 6007 | 50500 | 471 | 0 | 39.66727762 | -121.6005252 | 2022-12-16 04:21:01 | Butte, California, US | |
1985405 | 1985405 | 2022-12-07 | US | Georgia | Bartow | 13015 | 33941 | 471 | 0 | 34.23732119 | -84.83887523 | 2022-12-08 04:21:07 | Bartow, Georgia, US | |
3714928 | 3714928 | 2022-12-06 | US | Georgia | Bartow | 13015 | 33941 | 471 | 0 | 34.23732119 | -84.83887523 | 2022-12-07 04:20:58 | Bartow, Georgia, US | |
2415633 | 2415633 | 2022-12-05 | US | Georgia | Bartow | 13015 | 33941 | 471 | 0 | 34.23732119 | -84.83887523 | 2022-12-06 04:21:03 | Bartow, Georgia, US | |
2414889 | 2414889 | 2022-12-05 | Japan | Okayama | 337725 | 471 | 0 | 34.89246 | 133.826252 | 2022-12-06 04:21:03 | Okayama, Japan | |||
719241 | 719241 | 2022-12-04 | US | Georgia | Bartow | 13015 | 33941 | 471 | 0 | 34.23732119 | -84.83887523 | 2022-12-05 04:20:58 | Bartow, Georgia, US | |
718497 | 718497 | 2022-12-04 | Japan | Okayama | 336914 | 471 | 0 | 34.89246 | 133.826252 | 2022-12-05 04:20:58 | Okayama, Japan | |||
2817530 | 2817530 | 2022-12-03 | US | Georgia | Bartow | 13015 | 33941 | 471 | 0 | 34.23732119 | -84.83887523 | 2022-12-04 04:20:56 | Bartow, Georgia, US | |
834386 | 834386 | 2022-12-02 | US | Georgia | Bartow | 13015 | 33941 | 471 | 0 | 34.23732119 | -84.83887523 | 2022-12-03 04:21:02 | Bartow, Georgia, US | |
2136916 | 2136916 | 2022-12-01 | US | Georgia | Bartow | 13015 | 33941 | 471 | 0 | 34.23732119 | -84.83887523 | 2022-12-02 04:21:07 | Bartow, Georgia, US | |
1965332 | 1965332 | 2022-11-30 | US | Georgia | Bartow | 13015 | 33941 | 471 | 0 | 34.23732119 | -84.83887523 | 2022-12-01 04:21:03 | Bartow, Georgia, US | |
2557346 | 2557346 | 2022-11-29 | US | Georgia | Bartow | 13015 | 33864 | 471 | 0 | 34.23732119 | -84.83887523 | 2022-11-30 04:21:07 | Bartow, Georgia, US | |
1240420 | 1240420 | 2022-11-28 | US | Georgia | Bartow | 13015 | 33864 | 471 | 0 | 34.23732119 | -84.83887523 | 2022-11-29 04:21:05 | Bartow, Georgia, US | |
3552408 | 3552408 | 2022-11-27 | US | Georgia | Bartow | 13015 | 33864 | 471 | 0 | 34.23732119 | -84.83887523 | 2022-11-28 04:21:02 | Bartow, Georgia, US | |
2100888 | 2100888 | 2022-11-26 | US | Georgia | Bartow | 13015 | 33864 | 471 | 0 | 34.23732119 | -84.83887523 | 2022-11-27 04:21:05 | Bartow, Georgia, US | |
488379 | 488379 | 2022-11-25 | US | Georgia | Bartow | 13015 | 33864 | 471 | 0 | 34.23732119 | -84.83887523 | 2022-11-26 04:21:11 | Bartow, Georgia, US | |
3524208 | 3524208 | 2022-11-24 | US | Georgia | Bartow | 13015 | 33864 | 471 | 0 | 34.23732119 | -84.83887523 | 2022-11-25 04:21:06 | Bartow, Georgia, US | |
3312991 | 3312991 | 2022-11-23 | US | Georgia | Bartow | 13015 | 33864 | 471 | 0 | 34.23732119 | -84.83887523 | 2022-11-24 04:21:09 | Bartow, Georgia, US | |
2488974 | 2488974 | 2022-11-16 | US | Tennessee | Madison | 47113 | 36633 | 471 | 0 | 35.61181957 | -88.84076036 | 2022-11-17 04:21:11 | Madison, Tennessee, US | |
294985 | 294985 | 2022-11-15 | US | Tennessee | Madison | 47113 | 36605 | 471 | 0 | 35.61181957 | -88.84076036 | 2022-11-16 04:21:09 | Madison, Tennessee, US | |
3600015 | 3600015 | 2022-11-14 | US | Tennessee | Madison | 47113 | 36566 | 471 | 0 | 35.61181957 | -88.84076036 | 2022-11-15 04:21:16 | Madison, Tennessee, US | |
2433907 | 2433907 | 2022-11-09 | US | Tennessee | Madison | 47113 | 36492 | 471 | 0 | 35.61181957 | -88.84076036 | 2022-11-10 04:21:16 | Madison, Tennessee, US | |
2431341 | 2431341 | 2022-11-09 | US | Alabama | Shelby | 1117 | 72078 | 471 | 0 | 33.26879845 | -86.66232561 | 2022-11-10 04:21:16 | Shelby, Alabama, US | |
482563 | 482563 | 2022-11-08 | US | Tennessee | Madison | 47113 | 36465 | 471 | 0 | 35.61181957 | -88.84076036 | 2022-11-09 04:21:22 | Madison, Tennessee, US | |
480693 | 480693 | 2022-11-08 | US | Indiana | Howard | 18067 | 28696 | 471 | 0 | 40.48527731 | -86.11351892 | 2022-11-09 04:21:22 | Howard, Indiana, US | |
479997 | 479997 | 2022-11-08 | US | Alabama | Shelby | 1117 | 72078 | 471 | 0 | 33.26879845 | -86.66232561 | 2022-11-09 04:21:22 | Shelby, Alabama, US | |
2441713 | 2441713 | 2022-11-07 | US | Tennessee | Madison | 47113 | 36442 | 471 | 0 | 35.61181957 | -88.84076036 | 2022-11-08 04:21:21 | Madison, Tennessee, US | |
2439843 | 2439843 | 2022-11-07 | US | Indiana | Howard | 18067 | 28696 | 471 | 0 | 40.48527731 | -86.11351892 | 2022-11-08 04:21:21 | Howard, Indiana, US | |
2439147 | 2439147 | 2022-11-07 | US | Alabama | Shelby | 1117 | 72078 | 471 | 0 | 33.26879845 | -86.66232561 | 2022-11-08 04:21:21 | Shelby, Alabama, US | |
1052811 | 1052811 | 2022-11-06 | US | Tennessee | Madison | 47113 | 36401 | 471 | 0 | 35.61181957 | -88.84076036 | 2022-11-07 04:21:26 | Madison, Tennessee, US | |
1050941 | 1050941 | 2022-11-06 | US | Indiana | Howard | 18067 | 28696 | 471 | 0 | 40.48527731 | -86.11351892 | 2022-11-07 04:21:26 | Howard, Indiana, US | |
1050245 | 1050245 | 2022-11-06 | US | Alabama | Shelby | 1117 | 72078 | 471 | 0 | 33.26879845 | -86.66232561 | 2022-11-07 04:21:26 | Shelby, Alabama, US | |
620835 | 620835 | 2022-11-05 | US | Tennessee | Madison | 47113 | 36387 | 471 | 0 | 35.61181957 | -88.84076036 | 2022-11-06 04:21:24 | Madison, Tennessee, US | |
618965 | 618965 | 2022-11-05 | US | Indiana | Howard | 18067 | 28696 | 471 | 0 | 40.48527731 | -86.11351892 | 2022-11-06 04:21:24 | Howard, Indiana, US | |
618269 | 618269 | 2022-11-05 | US | Alabama | Shelby | 1117 | 72078 | 471 | 0 | 33.26879845 | -86.66232561 | 2022-11-06 04:21:24 | Shelby, Alabama, US | |
1025339 | 1025339 | 2022-11-04 | US | Tennessee | Madison | 47113 | 36376 | 471 | 0 | 35.61181957 | -88.84076036 | 2022-11-05 04:21:52 | Madison, Tennessee, US | |
1023469 | 1023469 | 2022-11-04 | US | Indiana | Howard | 18067 | 28696 | 471 | 0 | 40.48527731 | -86.11351892 | 2022-11-05 04:21:52 | Howard, Indiana, US | |
1022773 | 1022773 | 2022-11-04 | US | Alabama | Shelby | 1117 | 72078 | 471 | 0 | 33.26879845 | -86.66232561 | 2022-11-05 04:21:52 | Shelby, Alabama, US | |
434330 | 434330 | 2022-11-03 | US | Tennessee | Madison | 47113 | 36358 | 471 | 0 | 35.61181957 | -88.84076036 | 2022-11-04 04:22:11 | Madison, Tennessee, US | |
433868 | 433868 | 2022-11-03 | US | Ohio | Portage | 39133 | 41381 | 471 | 0 | 41.16793482 | -81.19735782 | 2022-11-04 04:22:11 | Portage, Ohio, US | |
432460 | 432460 | 2022-11-03 | US | Indiana | Howard | 18067 | 28696 | 471 | 0 | 40.48527731 | -86.11351892 | 2022-11-04 04:22:11 | Howard, Indiana, US | |
431764 | 431764 | 2022-11-03 | US | Alabama | Shelby | 1117 | 72078 | 471 | 0 | 33.26879845 | -86.66232561 | 2022-11-04 04:22:11 | Shelby, Alabama, US | |
852572 | 852572 | 2022-11-02 | US | Tennessee | Madison | 47113 | 36341 | 471 | 0 | 35.61181957 | -88.84076036 | 2022-11-03 04:22:05 | Madison, Tennessee, US | |
852110 | 852110 | 2022-11-02 | US | Ohio | Portage | 39133 | 41163 | 471 | 0 | 41.16793482 | -81.19735782 | 2022-11-03 04:22:05 | Portage, Ohio, US | |
850702 | 850702 | 2022-11-02 | US | Indiana | Howard | 18067 | 28696 | 471 | 0 | 40.48527731 | -86.11351892 | 2022-11-03 04:22:05 | Howard, Indiana, US | |
850006 | 850006 | 2022-11-02 | US | Alabama | Shelby | 1117 | 72078 | 471 | 0 | 33.26879845 | -86.66232561 | 2022-11-03 04:22:05 | Shelby, Alabama, US | |
713423 | 713423 | 2022-11-01 | US | Tennessee | Madison | 47113 | 36312 | 471 | 0 | 35.61181957 | -88.84076036 | 2022-11-02 04:22:09 | Madison, Tennessee, US | |
712961 | 712961 | 2022-11-01 | US | Ohio | Portage | 39133 | 41163 | 471 | 0 | 41.16793482 | -81.19735782 | 2022-11-02 04:22:09 | Portage, Ohio, US | |
711537 | 711537 | 2022-11-01 | US | Indiana | Delaware | 18035 | 28534 | 471 | 0 | 40.22787247 | -85.39732772 | 2022-11-02 04:22:09 | Delaware, Indiana, US | |
711358 | 711358 | 2022-11-01 | US | Georgia | Whitfield | 13313 | 37947 | 471 | 0 | 34.80987459 | -84.96093476 | 2022-11-02 04:22:09 | Whitfield, Georgia, US | |
710857 | 710857 | 2022-11-01 | US | Alabama | Shelby | 1117 | 72078 | 471 | 0 | 33.26879845 | -86.66232561 | 2022-11-02 04:22:09 | Shelby, Alabama, US | |
3287410 | 3287410 | 2022-10-31 | US | Ohio | Portage | 39133 | 41163 | 471 | 0 | 41.16793482 | -81.19735782 | 2022-11-01 04:22:36 | Portage, Ohio, US | |
3285986 | 3285986 | 2022-10-31 | US | Indiana | Delaware | 18035 | 28534 | 471 | 0 | 40.22787247 | -85.39732772 | 2022-11-01 04:22:36 | Delaware, Indiana, US | |
3285807 | 3285807 | 2022-10-31 | US | Georgia | Whitfield | 13313 | 37947 | 471 | 0 | 34.80987459 | -84.96093476 | 2022-11-01 04:22:36 | Whitfield, Georgia, US | |
3285306 | 3285306 | 2022-10-31 | US | Alabama | Shelby | 1117 | 72078 | 471 | 0 | 33.26879845 | -86.66232561 | 2022-11-01 04:22:36 | Shelby, Alabama, US | |
323400 | 323400 | 2022-10-30 | US | Washington | Thurston | 53067 | 59802 | 471 | 0 | 46.9291895 | -122.8290656 | 2022-10-31 04:21:36 | Thurston, Washington, US | |
322443 | 322443 | 2022-10-30 | US | Ohio | Portage | 39133 | 41163 | 471 | 0 | 41.16793482 | -81.19735782 | 2022-10-31 04:21:36 | Portage, Ohio, US | |
321019 | 321019 | 2022-10-30 | US | Indiana | Delaware | 18035 | 28534 | 471 | 0 | 40.22787247 | -85.39732772 | 2022-10-31 04:21:36 | Delaware, Indiana, US | |
320840 | 320840 | 2022-10-30 | US | Georgia | Whitfield | 13313 | 37947 | 471 | 0 | 34.80987459 | -84.96093476 | 2022-10-31 04:21:36 | Whitfield, Georgia, US | |
320339 | 320339 | 2022-10-30 | US | Alabama | Shelby | 1117 | 72078 | 471 | 0 | 33.26879845 | -86.66232561 | 2022-10-31 04:21:36 | Shelby, Alabama, US | |
915676 | 915676 | 2022-10-29 | US | Washington | Thurston | 53067 | 59802 | 471 | 0 | 46.9291895 | -122.8290656 | 2022-10-30 04:22:14 | Thurston, Washington, US | |
914719 | 914719 | 2022-10-29 | US | Ohio | Portage | 39133 | 41163 | 471 | 0 | 41.16793482 | -81.19735782 | 2022-10-30 04:22:14 | Portage, Ohio, US | |
913295 | 913295 | 2022-10-29 | US | Indiana | Delaware | 18035 | 28534 | 471 | 0 | 40.22787247 | -85.39732772 | 2022-10-30 04:22:14 | Delaware, Indiana, US | |
913116 | 913116 | 2022-10-29 | US | Georgia | Whitfield | 13313 | 37947 | 471 | 0 | 34.80987459 | -84.96093476 | 2022-10-30 04:22:14 | Whitfield, Georgia, US | |
912615 | 912615 | 2022-10-29 | US | Alabama | Shelby | 1117 | 72078 | 471 | 0 | 33.26879845 | -86.66232561 | 2022-10-30 04:22:14 | Shelby, Alabama, US | |
1369945 | 1369945 | 2022-10-28 | US | Washington | Thurston | 53067 | 59802 | 471 | 0 | 46.9291895 | -122.8290656 | 2022-10-29 04:21:13 | Thurston, Washington, US | |
1368988 | 1368988 | 2022-10-28 | US | Ohio | Portage | 39133 | 41163 | 471 | 0 | 41.16793482 | -81.19735782 | 2022-10-29 04:21:13 | Portage, Ohio, US | |
1367564 | 1367564 | 2022-10-28 | US | Indiana | Delaware | 18035 | 28534 | 471 | 0 | 40.22787247 | -85.39732772 | 2022-10-29 04:21:13 | Delaware, Indiana, US | |
1367385 | 1367385 | 2022-10-28 | US | Georgia | Whitfield | 13313 | 37947 | 471 | 0 | 34.80987459 | -84.96093476 | 2022-10-29 04:21:13 | Whitfield, Georgia, US | |
1366884 | 1366884 | 2022-10-28 | US | Alabama | Shelby | 1117 | 72078 | 471 | 0 | 33.26879845 | -86.66232561 | 2022-10-29 04:21:13 | Shelby, Alabama, US | |
3041800 | 3041800 | 2022-10-27 | US | Washington | Thurston | 53067 | 59802 | 471 | 0 | 46.9291895 | -122.8290656 | 2022-10-28 04:22:31 | Thurston, Washington, US | |
3040843 | 3040843 | 2022-10-27 | US | Ohio | Portage | 39133 | 41163 | 471 | 0 | 41.16793482 | -81.19735782 | 2022-10-28 04:22:31 | Portage, Ohio, US | |
3039419 | 3039419 | 2022-10-27 | US | Indiana | Delaware | 18035 | 28534 | 471 | 0 | 40.22787247 | -85.39732772 | 2022-10-28 04:22:31 | Delaware, Indiana, US | |
3039240 | 3039240 | 2022-10-27 | US | Georgia | Whitfield | 13313 | 37947 | 471 | 0 | 34.80987459 | -84.96093476 | 2022-10-28 04:22:31 | Whitfield, Georgia, US | |
3038739 | 3038739 | 2022-10-27 | US | Alabama | Shelby | 1117 | 72078 | 471 | 0 | 33.26879845 | -86.66232561 | 2022-10-28 04:22:31 | Shelby, Alabama, US | |
542220 | 542220 | 2022-10-26 | US | Washington | Thurston | 53067 | 59802 | 471 | 0 | 46.9291895 | -122.8290656 | 2022-10-27 04:22:01 | Thurston, Washington, US | |
541263 | 541263 | 2022-10-26 | US | Ohio | Portage | 39133 | 40956 | 471 | 0 | 41.16793482 | -81.19735782 | 2022-10-27 04:22:01 | Portage, Ohio, US | |
539839 | 539839 | 2022-10-26 | US | Indiana | Delaware | 18035 | 28534 | 471 | 0 | 40.22787247 | -85.39732772 | 2022-10-27 04:22:01 | Delaware, Indiana, US | |
539660 | 539660 | 2022-10-26 | US | Georgia | Whitfield | 13313 | 37947 | 471 | 0 | 34.80987459 | -84.96093476 | 2022-10-27 04:22:01 | Whitfield, Georgia, US | |
539166 | 539166 | 2022-10-26 | US | Alabama | Walker | 1127 | 22417 | 471 | 0 | 33.80270512 | -87.30027177 | 2022-10-27 04:22:01 | Walker, Alabama, US | |
539159 | 539159 | 2022-10-26 | US | Alabama | Shelby | 1117 | 71943 | 471 | 0 | 33.26879845 | -86.66232561 | 2022-10-27 04:22:01 | Shelby, Alabama, US | |
1833621 | 1833621 | 2022-10-25 | US | Washington | Thurston | 53067 | 59758 | 471 | 0 | 46.9291895 | -122.8290656 | 2022-10-26 04:22:19 | Thurston, Washington, US | |
1832664 | 1832664 | 2022-10-25 | US | Ohio | Portage | 39133 | 40956 | 471 | 0 | 41.16793482 | -81.19735782 | 2022-10-26 04:22:19 | Portage, Ohio, US | |
1831061 | 1831061 | 2022-10-25 | US | Georgia | Whitfield | 13313 | 37917 | 471 | 0 | 34.80987459 | -84.96093476 | 2022-10-26 04:22:19 | Whitfield, Georgia, US | |
1830567 | 1830567 | 2022-10-25 | US | Alabama | Walker | 1127 | 22417 | 471 | 0 | 33.80270512 | -87.30027177 | 2022-10-26 04:22:19 | Walker, Alabama, US | |
1830560 | 1830560 | 2022-10-25 | US | Alabama | Shelby | 1117 | 71943 | 471 | 0 | 33.26879845 | -86.66232561 | 2022-10-26 04:22:19 | Shelby, Alabama, US | |
797882 | 797882 | 2022-10-24 | US | Washington | Thurston | 53067 | 59758 | 471 | 0 | 46.9291895 | -122.8290656 | 2022-10-25 04:21:53 | Thurston, Washington, US | |
795322 | 795322 | 2022-10-24 | US | Georgia | Whitfield | 13313 | 37917 | 471 | 0 | 34.80987459 | -84.96093476 | 2022-10-25 04:21:53 | Whitfield, Georgia, US | |
794828 | 794828 | 2022-10-24 | US | Alabama | Walker | 1127 | 22417 | 471 | 0 | 33.80270512 | -87.30027177 | 2022-10-25 04:21:53 | Walker, Alabama, US | |
794821 | 794821 | 2022-10-24 | US | Alabama | Shelby | 1117 | 71943 | 471 | 0 | 33.26879845 | -86.66232561 | 2022-10-25 04:21:53 | Shelby, Alabama, US | |
3280337 | 3280337 | 2022-10-23 | US | Washington | Thurston | 53067 | 59678 | 471 | 0 | 46.9291895 | -122.8290656 | 2022-10-24 04:22:29 | Thurston, Washington, US | |
3277777 | 3277777 | 2022-10-23 | US | Georgia | Whitfield | 13313 | 37917 | 471 | 0 | 34.80987459 | -84.96093476 | 2022-10-24 04:22:29 | Whitfield, Georgia, US | |
3277283 | 3277283 | 2022-10-23 | US | Alabama | Walker | 1127 | 22417 | 471 | 0 | 33.80270512 | -87.30027177 | 2022-10-24 04:22:29 | Walker, Alabama, US | |
3277276 | 3277276 | 2022-10-23 | US | Alabama | Shelby | 1117 | 71943 | 471 | 0 | 33.26879845 | -86.66232561 | 2022-10-24 04:22:29 | Shelby, Alabama, 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]);