johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
300 rows where deaths = 719 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753837 | 2753837 | 2022-12-29 | US | Idaho | Canyon | 16027 | 69262 | 719 | 0 | 43.61970148 | -116.7095499 | 2022-12-30 04:21:04 | Canyon, Idaho, US | |
2753253 | 2753253 | 2022-12-29 | US | Alabama | Baldwin | 1003 | 67496 | 719 | 0 | 30.72774991 | -87.72207058 | 2022-12-30 04:21:04 | Baldwin, Alabama, US | |
1074843 | 1074843 | 2022-12-28 | US | Idaho | Canyon | 16027 | 69262 | 719 | 0 | 43.61970148 | -116.7095499 | 2022-12-29 04:21:01 | Canyon, Idaho, US | |
1074259 | 1074259 | 2022-12-28 | US | Alabama | Baldwin | 1003 | 67496 | 719 | 0 | 30.72774991 | -87.72207058 | 2022-12-29 04:21:01 | Baldwin, Alabama, US | |
331013 | 331013 | 2022-12-27 | US | Texas | Gregg | 48183 | 26273 | 719 | 0 | 32.47940482 | -94.81591935 | 2022-12-28 04:21:04 | Gregg, Texas, US | |
328256 | 328256 | 2022-12-27 | US | Alabama | Baldwin | 1003 | 67496 | 719 | 0 | 30.72774991 | -87.72207058 | 2022-12-28 04:21:04 | Baldwin, Alabama, US | |
221086 | 221086 | 2022-12-26 | US | Texas | Gregg | 48183 | 26273 | 719 | 0 | 32.47940482 | -94.81591935 | 2022-12-27 04:21:07 | Gregg, Texas, US | |
218329 | 218329 | 2022-12-26 | US | Alabama | Baldwin | 1003 | 67496 | 719 | 0 | 30.72774991 | -87.72207058 | 2022-12-27 04:21:07 | Baldwin, Alabama, US | |
3225543 | 3225543 | 2022-12-25 | US | Texas | Gregg | 48183 | 26273 | 719 | 0 | 32.47940482 | -94.81591935 | 2022-12-26 04:21:06 | Gregg, Texas, US | |
3222786 | 3222786 | 2022-12-25 | US | Alabama | Baldwin | 1003 | 67496 | 719 | 0 | 30.72774991 | -87.72207058 | 2022-12-26 04:21:06 | Baldwin, Alabama, US | |
1021457 | 1021457 | 2022-12-24 | US | Texas | Gregg | 48183 | 26273 | 719 | 0 | 32.47940482 | -94.81591935 | 2022-12-25 04:21:04 | Gregg, Texas, US | |
1018700 | 1018700 | 2022-12-24 | US | Alabama | Baldwin | 1003 | 67496 | 719 | 0 | 30.72774991 | -87.72207058 | 2022-12-25 04:21:04 | Baldwin, Alabama, US | |
693480 | 693480 | 2022-12-23 | US | Texas | Gregg | 48183 | 26273 | 719 | 0 | 32.47940482 | -94.81591935 | 2022-12-24 04:21:02 | Gregg, Texas, US | |
690723 | 690723 | 2022-12-23 | US | Alabama | Baldwin | 1003 | 67496 | 719 | 0 | 30.72774991 | -87.72207058 | 2022-12-24 04:21:02 | Baldwin, Alabama, US | |
2182690 | 2182690 | 2022-12-22 | US | Texas | Gregg | 48183 | 26273 | 719 | 0 | 32.47940482 | -94.81591935 | 2022-12-23 04:21:04 | Gregg, Texas, US | |
2179933 | 2179933 | 2022-12-22 | US | Alabama | Baldwin | 1003 | 67496 | 719 | 0 | 30.72774991 | -87.72207058 | 2022-12-23 04:21:04 | Baldwin, Alabama, US | |
454494 | 454494 | 2022-12-21 | US | Texas | Gregg | 48183 | 26273 | 719 | 0 | 32.47940482 | -94.81591935 | 2022-12-22 04:20:56 | Gregg, Texas, US | |
451737 | 451737 | 2022-12-21 | US | Alabama | Baldwin | 1003 | 67496 | 719 | 0 | 30.72774991 | -87.72207058 | 2022-12-22 04:20:56 | Baldwin, Alabama, US | |
545006 | 545006 | 2022-12-15 | US | New York | Dutchess | 36027 | 81351 | 719 | 0 | 41.7648606 | -73.74356679 | 2022-12-16 04:21:01 | Dutchess, New York, US | |
350534 | 350534 | 2022-12-14 | US | New York | Dutchess | 36027 | 81256 | 719 | 0 | 41.7648606 | -73.74356679 | 2022-12-15 04:20:58 | Dutchess, New York, US | |
310122 | 310122 | 2022-12-13 | US | New York | Dutchess | 36027 | 81181 | 719 | 0 | 41.7648606 | -73.74356679 | 2022-12-14 04:21:04 | Dutchess, New York, US | |
1151796 | 1151796 | 2022-12-12 | US | South Carolina | York | 45091 | 91515 | 719 | 0 | 34.97281497 | -81.18085944 | 2022-12-13 04:21:01 | York, South Carolina, US | |
871650 | 871650 | 2022-12-11 | US | South Carolina | York | 45091 | 91515 | 719 | 0 | 34.97281497 | -81.18085944 | 2022-12-12 04:21:01 | York, South Carolina, US | |
260180 | 260180 | 2022-12-10 | US | South Carolina | York | 45091 | 91515 | 719 | 0 | 34.97281497 | -81.18085944 | 2022-12-11 04:20:50 | York, South Carolina, US | |
3938894 | 3938894 | 2022-12-09 | US | South Carolina | York | 45091 | 91515 | 719 | 0 | 34.97281497 | -81.18085944 | 2022-12-10 04:21:02 | York, South Carolina, US | |
3380226 | 3380226 | 2022-12-08 | US | South Carolina | York | 45091 | 91515 | 719 | 0 | 34.97281497 | -81.18085944 | 2022-12-09 04:21:05 | York, South Carolina, US | |
1987497 | 1987497 | 2022-12-07 | US | South Carolina | York | 45091 | 91515 | 719 | 0 | 34.97281497 | -81.18085944 | 2022-12-08 04:21:07 | York, South Carolina, US | |
3717020 | 3717020 | 2022-12-06 | US | South Carolina | York | 45091 | 91515 | 719 | 0 | 34.97281497 | -81.18085944 | 2022-12-07 04:20:58 | York, South Carolina, US | |
538750 | 538750 | 2022-10-26 | Japan | Ibaraki | 381203 | 719 | 0 | 36.303588 | 140.319591 | 2022-10-27 04:22:01 | Ibaraki, Japan | |||
2759594 | 2759594 | 2022-10-18 | US | Pennsylvania | Fayette | 42051 | 36762 | 719 | 0 | 39.92041012 | -79.64291195 | 2022-10-19 04:22:26 | Fayette, Pennsylvania, US | |
2027428 | 2027428 | 2022-10-17 | US | Pennsylvania | Fayette | 42051 | 36762 | 719 | 0 | 39.92041012 | -79.64291195 | 2022-10-18 04:22:42 | Fayette, Pennsylvania, US | |
2162206 | 2162206 | 2022-10-16 | US | Pennsylvania | Fayette | 42051 | 36762 | 719 | 0 | 39.92041012 | -79.64291195 | 2022-10-17 04:20:31 | Fayette, Pennsylvania, US | |
518403 | 518403 | 2022-10-15 | US | Pennsylvania | Fayette | 42051 | 36762 | 719 | 0 | 39.92041012 | -79.64291195 | 2022-10-16 04:22:39 | Fayette, Pennsylvania, US | |
2035460 | 2035460 | 2022-10-14 | US | Pennsylvania | Fayette | 42051 | 36762 | 719 | 0 | 39.92041012 | -79.64291195 | 2022-10-15 04:22:00 | Fayette, Pennsylvania, US | |
3757055 | 3757055 | 2022-10-13 | US | Wisconsin | Racine | 55101 | 66326 | 719 | 0 | 42.74753117 | -88.05941254 | 2022-10-14 04:22:28 | Racine, Wisconsin, US | |
3756148 | 3756148 | 2022-10-13 | US | Pennsylvania | Fayette | 42051 | 36762 | 719 | 0 | 39.92041012 | -79.64291195 | 2022-10-14 04:22:28 | Fayette, Pennsylvania, US | |
3216973 | 3216973 | 2022-10-12 | US | Pennsylvania | Fayette | 42051 | 36762 | 719 | 0 | 39.92041012 | -79.64291195 | 2022-10-13 04:22:39 | Fayette, Pennsylvania, US | |
1563175 | 1563175 | 2022-09-28 | US | Texas | Ector | 48135 | 41511 | 719 | 0 | 31.86898877 | -102.5429428 | 2022-09-29 04:22:34 | Ector, Texas, US | |
3997718 | 3997718 | 2022-09-27 | US | Texas | Ector | 48135 | 41511 | 719 | 0 | 31.86898877 | -102.5429428 | 2022-09-28 04:23:01 | Ector, Texas, US | |
2772046 | 2772046 | 2022-09-26 | US | Texas | Ector | 48135 | 41511 | 719 | 0 | 31.86898877 | -102.5429428 | 2022-09-27 04:23:01 | Ector, Texas, US | |
2770616 | 2770616 | 2022-09-26 | US | Michigan | Kalamazoo | 26077 | 70662 | 719 | 0 | 42.24542231 | -85.53038622 | 2022-09-27 04:23:01 | Kalamazoo, Michigan, US | |
1978269 | 1978269 | 2022-09-25 | US | Michigan | Kalamazoo | 26077 | 70662 | 719 | 0 | 42.24542231 | -85.53038622 | 2022-09-26 04:20:52 | Kalamazoo, Michigan, US | |
2651436 | 2651436 | 2022-09-24 | US | Michigan | Kalamazoo | 26077 | 70662 | 719 | 0 | 42.24542231 | -85.53038622 | 2022-09-25 04:23:31 | Kalamazoo, Michigan, US | |
385876 | 385876 | 2022-09-23 | US | Michigan | Kalamazoo | 26077 | 70662 | 719 | 0 | 42.24542231 | -85.53038622 | 2022-09-24 04:21:40 | Kalamazoo, Michigan, US | |
1625942 | 1625942 | 2022-09-22 | US | Michigan | Kalamazoo | 26077 | 70662 | 719 | 0 | 42.24542231 | -85.53038622 | 2022-09-23 04:23:13 | Kalamazoo, Michigan, US | |
1372146 | 1372146 | 2022-09-21 | US | Michigan | Kalamazoo | 26077 | 70662 | 719 | 0 | 42.24542231 | -85.53038622 | 2022-09-22 04:22:56 | Kalamazoo, Michigan, US | |
2018376 | 2018376 | 2022-09-20 | US | Michigan | Kalamazoo | 26077 | 70662 | 719 | 0 | 42.24542231 | -85.53038622 | 2022-09-21 04:23:22 | Kalamazoo, Michigan, US | |
2395517 | 2395517 | 2022-09-12 | US | Florida | Leon | 12073 | 105101 | 719 | 0 | 30.45955727 | -84.27491114 | 2022-09-13 04:20:57 | Leon, Florida, US | |
3766595 | 3766595 | 2022-09-11 | US | Florida | Leon | 12073 | 105101 | 719 | 0 | 30.45955727 | -84.27491114 | 2022-09-12 04:20:58 | Leon, Florida, US | |
3825170 | 3825170 | 2022-09-10 | US | Florida | Leon | 12073 | 105101 | 719 | 0 | 30.45955727 | -84.27491114 | 2022-09-11 04:20:50 | Leon, Florida, US | |
963627 | 963627 | 2022-09-09 | US | Florida | Leon | 12073 | 105101 | 719 | 0 | 30.45955727 | -84.27491114 | 2022-09-10 04:21:10 | Leon, Florida, US | |
254029 | 254029 | 2022-09-08 | US | Florida | Leon | 12073 | 105101 | 719 | 0 | 30.45955727 | -84.27491114 | 2022-09-09 04:21:11 | Leon, Florida, US | |
3745827 | 3745827 | 2022-09-07 | US | Florida | Leon | 12073 | 105101 | 719 | 0 | 30.45955727 | -84.27491114 | 2022-09-08 04:21:02 | Leon, Florida, US | |
115467 | 115467 | 2022-09-06 | US | Florida | Leon | 12073 | 105101 | 719 | 0 | 30.45955727 | -84.27491114 | 2022-09-07 04:20:59 | Leon, Florida, US | |
2635220 | 2635220 | 2022-09-05 | US | Louisiana | Calcasieu | 22019 | 62338 | 719 | 0 | 30.22931235 | -93.35400434 | 2022-09-06 04:21:02 | Calcasieu, Louisiana, US | |
2634439 | 2634439 | 2022-09-05 | US | Florida | Leon | 12073 | 105101 | 719 | 0 | 30.45955727 | -84.27491114 | 2022-09-06 04:21:02 | Leon, Florida, US | |
2988784 | 2988784 | 2022-09-04 | US | Louisiana | Calcasieu | 22019 | 62338 | 719 | 0 | 30.22931235 | -93.35400434 | 2022-09-05 04:21:01 | Calcasieu, Louisiana, US | |
2988003 | 2988003 | 2022-09-04 | US | Florida | Leon | 12073 | 105101 | 719 | 0 | 30.45955727 | -84.27491114 | 2022-09-05 04:21:01 | Leon, Florida, US | |
2714469 | 2714469 | 2022-09-03 | US | Louisiana | Calcasieu | 22019 | 62338 | 719 | 0 | 30.22931235 | -93.35400434 | 2022-09-04 04:21:22 | Calcasieu, Louisiana, US | |
2713688 | 2713688 | 2022-09-03 | US | Florida | Leon | 12073 | 105101 | 719 | 0 | 30.45955727 | -84.27491114 | 2022-09-04 04:21:22 | Leon, Florida, US | |
1395174 | 1395174 | 2022-09-02 | US | Louisiana | Calcasieu | 22019 | 62338 | 719 | 0 | 30.22931235 | -93.35400434 | 2022-09-03 04:21:04 | Calcasieu, Louisiana, US | |
1394393 | 1394393 | 2022-09-02 | US | Florida | Leon | 12073 | 105101 | 719 | 0 | 30.45955727 | -84.27491114 | 2022-09-03 04:21:04 | Leon, Florida, US | |
3549003 | 3549003 | 2022-09-01 | US | Louisiana | Calcasieu | 22019 | 62338 | 719 | 0 | 30.22931235 | -93.35400434 | 2022-09-02 04:21:07 | Calcasieu, Louisiana, US | |
3548222 | 3548222 | 2022-09-01 | US | Florida | Leon | 12073 | 105101 | 719 | 0 | 30.45955727 | -84.27491114 | 2022-09-02 04:21:07 | Leon, Florida, US | |
2344923 | 2344923 | 2022-08-31 | US | Louisiana | Calcasieu | 22019 | 62150 | 719 | 0 | 30.22931235 | -93.35400434 | 2022-09-01 04:21:03 | Calcasieu, Louisiana, US | |
2344142 | 2344142 | 2022-08-31 | US | Florida | Leon | 12073 | 105101 | 719 | 0 | 30.45955727 | -84.27491114 | 2022-09-01 04:21:03 | Leon, Florida, US | |
3775403 | 3775403 | 2022-08-30 | US | Louisiana | Calcasieu | 22019 | 62071 | 719 | 0 | 30.22931235 | -93.35400434 | 2022-08-31 04:20:57 | Calcasieu, Louisiana, US | |
3774622 | 3774622 | 2022-08-30 | US | Florida | Leon | 12073 | 105101 | 719 | 0 | 30.45955727 | -84.27491114 | 2022-08-31 04:20:57 | Leon, Florida, US | |
1681999 | 1681999 | 2022-08-29 | US | Louisiana | Calcasieu | 22019 | 61961 | 719 | 0 | 30.22931235 | -93.35400434 | 2022-08-30 04:21:03 | Calcasieu, Louisiana, US | |
1069577 | 1069577 | 2022-08-07 | Australia | South Australia | 727990 | 719 | 0 | -34.9285 | 138.6007 | 2022-08-08 04:21:08 | South Australia, Australia | |||
2725092 | 2725092 | 2022-05-28 | Malta | 94513 | 719 | 0 | 35.9375 | 14.3754 | 2022-05-29 04:20:53 | Malta | ||||
1314273 | 1314273 | 2022-05-27 | Malta | 94440 | 719 | 0 | 35.9375 | 14.3754 | 2022-05-28 04:21:07 | Malta | ||||
1850065 | 1850065 | 2022-05-26 | Malta | 94354 | 719 | 0 | 35.9375 | 14.3754 | 2022-05-27 04:20:56 | Malta | ||||
2047941 | 2047941 | 2022-05-25 | Malta | 94264 | 719 | 0 | 35.9375 | 14.3754 | 2022-05-26 04:20:50 | Malta | ||||
2999379 | 2999379 | 2022-05-24 | Malta | 94205 | 719 | 0 | 35.9375 | 14.3754 | 2022-05-25 04:20:56 | Malta | ||||
621952 | 621952 | 2022-05-22 | Malta | 94264 | 719 | 0 | 35.9375 | 14.3754 | 2022-05-26 04:20:50 | Malta | ||||
3854814 | 3854814 | 2022-04-27 | US | Tennessee | Sullivan | 47163 | 46085 | 719 | 0 | 36.51240691 | -82.30412917 | 2022-04-28 04:20:47 | Sullivan, Tennessee, US | |
1329244 | 1329244 | 2022-04-26 | US | Tennessee | Sullivan | 47163 | 46074 | 719 | 0 | 36.51240691 | -82.30412917 | 2022-04-27 04:20:52 | Sullivan, Tennessee, US | |
3725198 | 3725198 | 2022-04-25 | US | Tennessee | Sullivan | 47163 | 46057 | 719 | 0 | 36.51240691 | -82.30412917 | 2022-04-26 04:20:51 | Sullivan, Tennessee, US | |
2031766 | 2031766 | 2022-04-24 | US | Tennessee | Sullivan | 47163 | 46037 | 719 | 0 | 36.51240691 | -82.30412917 | 2022-04-25 04:20:56 | Sullivan, Tennessee, US | |
749341 | 749341 | 2022-04-23 | US | Tennessee | Sullivan | 47163 | 46028 | 719 | 0 | 36.51240691 | -82.30412917 | 2022-04-24 04:20:56 | Sullivan, Tennessee, US | |
3439826 | 3439826 | 2022-04-22 | US | Tennessee | Sullivan | 47163 | 46019 | 719 | 0 | 36.51240691 | -82.30412917 | 2022-04-23 04:20:50 | Sullivan, Tennessee, US | |
2310518 | 2310518 | 2022-04-20 | US | Texas | Taylor | 48441 | 31073 | 719 | 0 | 32.30163422 | -99.89007449 | 2022-04-21 04:20:46 | Taylor, Texas, US | |
2254657 | 2254657 | 2022-04-19 | US | Texas | Taylor | 48441 | 31029 | 719 | 0 | 32.30163422 | -99.89007449 | 2022-04-20 04:20:45 | Taylor, Texas, US | |
1849207 | 1849207 | 2022-04-18 | US | Texas | Taylor | 48441 | 30998 | 719 | 0 | 32.30163422 | -99.89007449 | 2022-04-19 04:21:00 | Taylor, Texas, US | |
3420151 | 3420151 | 2022-04-17 | US | Texas | Taylor | 48441 | 30943 | 719 | 0 | 32.30163422 | -99.89007449 | 2022-04-18 04:21:12 | Taylor, Texas, US | |
307100 | 307100 | 2022-04-16 | US | Texas | Taylor | 48441 | 30943 | 719 | 0 | 32.30163422 | -99.89007449 | 2022-04-17 04:20:59 | Taylor, Texas, US | |
2673045 | 2673045 | 2022-04-15 | US | Texas | Taylor | 48441 | 30943 | 719 | 0 | 32.30163422 | -99.89007449 | 2022-04-16 04:20:48 | Taylor, Texas, US | |
1226830 | 1226830 | 2022-04-14 | US | Texas | Taylor | 48441 | 30943 | 719 | 0 | 32.30163422 | -99.89007449 | 2022-04-15 04:20:57 | Taylor, Texas, US | |
2445988 | 2445988 | 2022-04-13 | US | Texas | Taylor | 48441 | 30912 | 719 | 0 | 32.30163422 | -99.89007449 | 2022-04-13 23:21:06 | Taylor, Texas, US | |
1951745 | 1951745 | 2022-04-12 | US | Texas | Taylor | 48441 | 30837 | 719 | 0 | 32.30163422 | -99.89007449 | 2022-04-13 04:21:03 | Taylor, Texas, US | |
3209498 | 3209498 | 2022-04-11 | US | Texas | Taylor | 48441 | 30791 | 719 | 0 | 32.30163422 | -99.89007449 | 2022-04-12 04:20:49 | Taylor, Texas, US | |
1579384 | 1579384 | 2022-04-10 | US | Texas | Taylor | 48441 | 30791 | 719 | 0 | 32.30163422 | -99.89007449 | 2022-04-11 04:21:02 | Taylor, Texas, US | |
1655626 | 1655626 | 2022-04-09 | US | Texas | Taylor | 48441 | 30790 | 719 | 0 | 32.30163422 | -99.89007449 | 2022-04-10 04:20:52 | Taylor, Texas, US | |
2118948 | 2118948 | 2022-04-08 | US | Texas | Taylor | 48441 | 30754 | 719 | 0 | 32.30163422 | -99.89007449 | 2022-04-09 04:20:42 | Taylor, Texas, US | |
3323472 | 3323472 | 2022-04-07 | US | Texas | Taylor | 48441 | 30742 | 719 | 0 | 32.30163422 | -99.89007449 | 2022-04-08 04:20:48 | Taylor, Texas, US | |
3733231 | 3733231 | 2022-04-03 | US | Tennessee | Sumner | 47165 | 53344 | 719 | 0 | 36.46824103 | -86.45917204 | 2022-04-04 04:20:51 | Sumner, Tennessee, US | |
502666 | 502666 | 2022-04-02 | US | Tennessee | Sumner | 47165 | 53339 | 719 | 0 | 36.46824103 | -86.45917204 | 2022-04-03 04:20:48 | Sumner, Tennessee, US | |
3353651 | 3353651 | 2022-04-01 | US | Tennessee | Sumner | 47165 | 53336 | 719 | 0 | 36.46824103 | -86.45917204 | 2022-04-02 04:20:47 | Sumner, Tennessee, US | |
1542956 | 1542956 | 2022-03-31 | US | Tennessee | Sumner | 47165 | 53332 | 719 | 0 | 36.46824103 | -86.45917204 | 2022-04-01 04:20:28 | Sumner, Tennessee, 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]);