johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
325 rows where deaths = 748 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 28
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3460159 | 3460159 | 2022-11-21 | Japan | Ibaraki | 417423 | 748 | 0 | 36.303588 | 140.319591 | 2022-11-22 04:20:47 | Ibaraki, Japan | |||
1640344 | 1640344 | 2022-11-20 | Japan | Ibaraki | 416183 | 748 | 0 | 36.303588 | 140.319591 | 2022-11-21 04:21:05 | Ibaraki, Japan | |||
3029526 | 3029526 | 2022-11-17 | US | Texas | Taylor | 48441 | 38199 | 748 | 0 | 32.30163422 | -99.89007449 | 2022-11-18 04:21:15 | Taylor, Texas, US | |
2489237 | 2489237 | 2022-11-16 | US | Texas | Taylor | 48441 | 38199 | 748 | 0 | 32.30163422 | -99.89007449 | 2022-11-17 04:21:11 | Taylor, Texas, US | |
295248 | 295248 | 2022-11-15 | US | Texas | Taylor | 48441 | 38106 | 748 | 0 | 32.30163422 | -99.89007449 | 2022-11-16 04:21:09 | Taylor, Texas, US | |
294627 | 294627 | 2022-11-15 | US | Oregon | Clackamas | 41005 | 79949 | 748 | 0 | 45.18787398 | -122.2179634 | 2022-11-16 04:21:09 | Clackamas, Oregon, US | |
3600278 | 3600278 | 2022-11-14 | US | Texas | Taylor | 48441 | 38106 | 748 | 0 | 32.30163422 | -99.89007449 | 2022-11-15 04:21:16 | Taylor, Texas, US | |
3599657 | 3599657 | 2022-11-14 | US | Oregon | Clackamas | 41005 | 79949 | 748 | 0 | 45.18787398 | -122.2179634 | 2022-11-15 04:21:16 | Clackamas, Oregon, US | |
315136 | 315136 | 2022-11-13 | US | Texas | Taylor | 48441 | 38012 | 748 | 0 | 32.30163422 | -99.89007449 | 2022-11-14 04:21:09 | Taylor, Texas, US | |
314515 | 314515 | 2022-11-13 | US | Oregon | Clackamas | 41005 | 79949 | 748 | 0 | 45.18787398 | -122.2179634 | 2022-11-14 04:21:09 | Clackamas, Oregon, US | |
66297 | 66297 | 2022-11-12 | US | Texas | Taylor | 48441 | 38012 | 748 | 0 | 32.30163422 | -99.89007449 | 2022-11-13 04:21:14 | Taylor, Texas, US | |
65676 | 65676 | 2022-11-12 | US | Oregon | Clackamas | 41005 | 79949 | 748 | 0 | 45.18787398 | -122.2179634 | 2022-11-13 04:21:14 | Clackamas, Oregon, US | |
2930459 | 2930459 | 2022-11-11 | US | Texas | Taylor | 48441 | 38012 | 748 | 0 | 32.30163422 | -99.89007449 | 2022-11-12 04:20:41 | Taylor, Texas, US | |
2929838 | 2929838 | 2022-11-11 | US | Oregon | Clackamas | 41005 | 79949 | 748 | 0 | 45.18787398 | -122.2179634 | 2022-11-12 04:20:41 | Clackamas, Oregon, US | |
2509295 | 2509295 | 2022-11-10 | US | Texas | Taylor | 48441 | 38012 | 748 | 0 | 32.30163422 | -99.89007449 | 2022-11-11 04:21:22 | Taylor, Texas, US | |
2508674 | 2508674 | 2022-11-10 | US | Oregon | Clackamas | 41005 | 79949 | 748 | 0 | 45.18787398 | -122.2179634 | 2022-11-11 04:21:22 | Clackamas, Oregon, US | |
2434170 | 2434170 | 2022-11-09 | US | Texas | Taylor | 48441 | 38012 | 748 | 0 | 32.30163422 | -99.89007449 | 2022-11-10 04:21:16 | Taylor, Texas, US | |
482826 | 482826 | 2022-11-08 | US | Texas | Taylor | 48441 | 37926 | 748 | 0 | 32.30163422 | -99.89007449 | 2022-11-09 04:21:22 | Taylor, Texas, US | |
2441976 | 2441976 | 2022-11-07 | US | Texas | Taylor | 48441 | 37926 | 748 | 0 | 32.30163422 | -99.89007449 | 2022-11-08 04:21:21 | Taylor, Texas, US | |
1053074 | 1053074 | 2022-11-06 | US | Texas | Taylor | 48441 | 37880 | 748 | 0 | 32.30163422 | -99.89007449 | 2022-11-07 04:21:26 | Taylor, Texas, US | |
621098 | 621098 | 2022-11-05 | US | Texas | Taylor | 48441 | 37880 | 748 | 0 | 32.30163422 | -99.89007449 | 2022-11-06 04:21:24 | Taylor, Texas, US | |
1025602 | 1025602 | 2022-11-04 | US | Texas | Taylor | 48441 | 37880 | 748 | 0 | 32.30163422 | -99.89007449 | 2022-11-05 04:21:52 | Taylor, Texas, US | |
713127 | 713127 | 2022-11-01 | US | Pennsylvania | Franklin | 42055 | 47526 | 748 | 0 | 39.92956518 | -77.72157791 | 2022-11-02 04:22:09 | Franklin, Pennsylvania, US | |
3287576 | 3287576 | 2022-10-31 | US | Pennsylvania | Franklin | 42055 | 47526 | 748 | 0 | 39.92956518 | -77.72157791 | 2022-11-01 04:22:36 | Franklin, Pennsylvania, US | |
322609 | 322609 | 2022-10-30 | US | Pennsylvania | Franklin | 42055 | 47526 | 748 | 0 | 39.92956518 | -77.72157791 | 2022-10-31 04:21:36 | Franklin, Pennsylvania, US | |
914885 | 914885 | 2022-10-29 | US | Pennsylvania | Franklin | 42055 | 47526 | 748 | 0 | 39.92956518 | -77.72157791 | 2022-10-30 04:22:14 | Franklin, Pennsylvania, US | |
1369154 | 1369154 | 2022-10-28 | US | Pennsylvania | Franklin | 42055 | 47526 | 748 | 0 | 39.92956518 | -77.72157791 | 2022-10-29 04:21:13 | Franklin, Pennsylvania, US | |
3041009 | 3041009 | 2022-10-27 | US | Pennsylvania | Franklin | 42055 | 47526 | 748 | 0 | 39.92956518 | -77.72157791 | 2022-10-28 04:22:31 | Franklin, Pennsylvania, US | |
541429 | 541429 | 2022-10-26 | US | Pennsylvania | Franklin | 42055 | 47526 | 748 | 0 | 39.92956518 | -77.72157791 | 2022-10-27 04:22:01 | Franklin, Pennsylvania, US | |
198579 | 198579 | 2022-10-19 | Sweden | Jonkoping | 89407 | 748 | 0 | 57.3708 | 14.3439 | 2022-10-20 04:22:59 | Jonkoping, Sweden | |||
2757240 | 2757240 | 2022-10-18 | Sweden | Jonkoping | 89407 | 748 | 0 | 57.3708 | 14.3439 | 2022-10-19 04:22:26 | Jonkoping, Sweden | |||
2025074 | 2025074 | 2022-10-17 | Sweden | Jonkoping | 89407 | 748 | 0 | 57.3708 | 14.3439 | 2022-10-18 04:22:42 | Jonkoping, Sweden | |||
2159852 | 2159852 | 2022-10-16 | Sweden | Jonkoping | 89407 | 748 | 0 | 57.3708 | 14.3439 | 2022-10-17 04:20:31 | Jonkoping, Sweden | |||
516049 | 516049 | 2022-10-15 | Sweden | Jonkoping | 89407 | 748 | 0 | 57.3708 | 14.3439 | 2022-10-16 04:22:39 | Jonkoping, Sweden | |||
2033106 | 2033106 | 2022-10-14 | Sweden | Jonkoping | 89407 | 748 | 0 | 57.3708 | 14.3439 | 2022-10-15 04:22:00 | Jonkoping, Sweden | |||
3753794 | 3753794 | 2022-10-13 | Sweden | Jonkoping | 89407 | 748 | 0 | 57.3708 | 14.3439 | 2022-10-14 04:22:28 | Jonkoping, Sweden | |||
2995312 | 2995312 | 2022-10-01 | Japan | Shizuoka | 494863 | 748 | 0 | 34.916975 | 138.407784 | 2022-10-02 04:21:23 | Shizuoka, Japan | |||
2995064 | 2995064 | 2022-10-01 | Chile | Magallanes | 62185 | 748 | 0 | -52.368 | -70.9863 | 2022-10-02 04:21:23 | Magallanes, Chile | |||
853638 | 853638 | 2022-09-30 | Japan | Shizuoka | 493905 | 748 | 0 | 34.916975 | 138.407784 | 2022-10-01 04:23:01 | Shizuoka, Japan | |||
853390 | 853390 | 2022-09-30 | Chile | Magallanes | 62167 | 748 | 0 | -52.368 | -70.9863 | 2022-10-01 04:23:01 | Magallanes, Chile | |||
2375316 | 2375316 | 2022-09-29 | Chile | Magallanes | 62140 | 748 | 0 | -52.368 | -70.9863 | 2022-09-30 04:23:09 | Magallanes, Chile | |||
993992 | 993992 | 2022-08-16 | US | Tennessee | Sullivan | 47163 | 51752 | 748 | 0 | 36.51240691 | -82.30412917 | 2022-08-17 04:20:59 | Sullivan, Tennessee, US | |
992080 | 992080 | 2022-08-16 | US | Indiana | Elkhart | 18039 | 57234 | 748 | 0 | 41.59761169 | -85.85875695 | 2022-08-17 04:20:59 | Elkhart, Indiana, US | |
2495119 | 2495119 | 2022-08-15 | US | Indiana | Elkhart | 18039 | 57234 | 748 | 0 | 41.59761169 | -85.85875695 | 2022-08-16 04:20:58 | Elkhart, Indiana, US | |
3648669 | 3648669 | 2022-08-14 | US | Indiana | Elkhart | 18039 | 57158 | 748 | 0 | 41.59761169 | -85.85875695 | 2022-08-15 04:20:59 | Elkhart, Indiana, US | |
1969675 | 1969675 | 2022-08-13 | US | Indiana | Elkhart | 18039 | 57158 | 748 | 0 | 41.59761169 | -85.85875695 | 2022-08-14 04:20:55 | Elkhart, Indiana, US | |
2889484 | 2889484 | 2022-08-12 | US | Indiana | Elkhart | 18039 | 57158 | 748 | 0 | 41.59761169 | -85.85875695 | 2022-08-13 04:20:52 | Elkhart, Indiana, US | |
3911141 | 3911141 | 2022-08-11 | US | Texas | Johnson | 48251 | 47493 | 748 | 0 | 32.37877812 | -97.36615819 | 2022-08-12 04:20:54 | Johnson, Texas, US | |
3909089 | 3909089 | 2022-08-11 | US | Indiana | Elkhart | 18039 | 57030 | 748 | 0 | 41.59761169 | -85.85875695 | 2022-08-12 04:20:54 | Elkhart, Indiana, US | |
3909053 | 3909053 | 2022-08-11 | US | Illinois | St. Clair | 17163 | 72791 | 748 | 0 | 38.46996033 | -89.93063427 | 2022-08-12 04:20:54 | St. Clair, Illinois, US | |
1349458 | 1349458 | 2022-08-10 | US | Texas | Johnson | 48251 | 47422 | 748 | 0 | 32.37877812 | -97.36615819 | 2022-08-11 04:20:49 | Johnson, Texas, US | |
1347406 | 1347406 | 2022-08-10 | US | Indiana | Elkhart | 18039 | 57030 | 748 | 0 | 41.59761169 | -85.85875695 | 2022-08-11 04:20:49 | Elkhart, Indiana, US | |
1347370 | 1347370 | 2022-08-10 | US | Illinois | St. Clair | 17163 | 72697 | 748 | 0 | 38.46996033 | -89.93063427 | 2022-08-11 04:20:49 | St. Clair, Illinois, US | |
1089213 | 1089213 | 2022-08-09 | US | Texas | Johnson | 48251 | 47372 | 748 | 0 | 32.37877812 | -97.36615819 | 2022-08-10 04:20:57 | Johnson, Texas, US | |
1087161 | 1087161 | 2022-08-09 | US | Indiana | Elkhart | 18039 | 56883 | 748 | 0 | 41.59761169 | -85.85875695 | 2022-08-10 04:20:57 | Elkhart, Indiana, US | |
1087125 | 1087125 | 2022-08-09 | US | Illinois | St. Clair | 17163 | 72614 | 748 | 0 | 38.46996033 | -89.93063427 | 2022-08-10 04:20:57 | St. Clair, Illinois, US | |
3546628 | 3546628 | 2022-08-08 | US | Texas | Johnson | 48251 | 47304 | 748 | 0 | 32.37877812 | -97.36615819 | 2022-08-09 04:20:34 | Johnson, Texas, US | |
3544576 | 3544576 | 2022-08-08 | US | Indiana | Elkhart | 18039 | 56883 | 748 | 0 | 41.59761169 | -85.85875695 | 2022-08-09 04:20:34 | Elkhart, Indiana, US | |
1073031 | 1073031 | 2022-08-07 | US | Texas | Johnson | 48251 | 47134 | 748 | 0 | 32.37877812 | -97.36615819 | 2022-08-08 04:21:08 | Johnson, Texas, US | |
1943619 | 1943619 | 2022-08-06 | US | Texas | Johnson | 48251 | 47134 | 748 | 0 | 32.37877812 | -97.36615819 | 2022-08-07 04:20:54 | Johnson, Texas, US | |
883418 | 883418 | 2022-08-05 | US | Texas | Johnson | 48251 | 47134 | 748 | 0 | 32.37877812 | -97.36615819 | 2022-08-06 04:20:56 | Johnson, Texas, US | |
2011829 | 2011829 | 2022-08-04 | US | Texas | Johnson | 48251 | 47066 | 748 | 0 | 32.37877812 | -97.36615819 | 2022-08-05 04:20:52 | Johnson, Texas, US | |
2337880 | 2337880 | 2022-07-27 | US | Ohio | Lake | 39085 | 53144 | 748 | 0 | 41.69710807 | -81.23676539 | 2022-07-28 04:20:56 | Lake, Ohio, US | |
1490070 | 1490070 | 2022-07-26 | US | Ohio | Lake | 39085 | 53144 | 748 | 0 | 41.69710807 | -81.23676539 | 2022-07-27 04:21:04 | Lake, Ohio, US | |
2596516 | 2596516 | 2022-07-25 | US | Ohio | Lake | 39085 | 53144 | 748 | 0 | 41.69710807 | -81.23676539 | 2022-07-26 04:20:58 | Lake, Ohio, US | |
899347 | 899347 | 2022-07-24 | US | Texas | Potter | 48375 | 37713 | 748 | 0 | 35.40133773 | -101.893964 | 2022-07-25 04:20:51 | Potter, Texas, US | |
898631 | 898631 | 2022-07-24 | US | Ohio | Lake | 39085 | 53144 | 748 | 0 | 41.69710807 | -81.23676539 | 2022-07-25 04:20:51 | Lake, Ohio, US | |
94341 | 94341 | 2022-07-23 | US | Texas | Potter | 48375 | 37713 | 748 | 0 | 35.40133773 | -101.893964 | 2022-07-24 04:20:47 | Potter, Texas, US | |
93625 | 93625 | 2022-07-23 | US | Ohio | Lake | 39085 | 53144 | 748 | 0 | 41.69710807 | -81.23676539 | 2022-07-24 04:20:47 | Lake, Ohio, US | |
903363 | 903363 | 2022-07-22 | US | Texas | Potter | 48375 | 37713 | 748 | 0 | 35.40133773 | -101.893964 | 2022-07-23 04:20:53 | Potter, Texas, US | |
902647 | 902647 | 2022-07-22 | US | Ohio | Lake | 39085 | 53144 | 748 | 0 | 41.69710807 | -81.23676539 | 2022-07-23 04:20:53 | Lake, Ohio, US | |
672783 | 672783 | 2022-07-21 | US | Ohio | Lake | 39085 | 53144 | 748 | 0 | 41.69710807 | -81.23676539 | 2022-07-22 04:21:15 | Lake, Ohio, US | |
1610746 | 1610746 | 2022-07-20 | US | Ohio | Lake | 39085 | 52696 | 748 | 0 | 41.69710807 | -81.23676539 | 2022-07-21 04:21:10 | Lake, Ohio, US | |
961552 | 961552 | 2022-07-19 | US | Pennsylvania | Cambria | 42021 | 36697 | 748 | 0 | 40.49527404 | -78.71377428 | 2022-07-20 04:20:59 | Cambria, Pennsylvania, US | |
3212939 | 3212939 | 2022-07-18 | US | Pennsylvania | Cambria | 42021 | 36697 | 748 | 0 | 40.49527404 | -78.71377428 | 2022-07-19 04:20:58 | Cambria, Pennsylvania, US | |
3408114 | 3408114 | 2022-07-17 | US | Pennsylvania | Cambria | 42021 | 36697 | 748 | 0 | 40.49527404 | -78.71377428 | 2022-07-18 04:20:59 | Cambria, Pennsylvania, US | |
2154314 | 2154314 | 2022-07-16 | US | Pennsylvania | Cambria | 42021 | 36697 | 748 | 0 | 40.49527404 | -78.71377428 | 2022-07-17 04:21:15 | Cambria, Pennsylvania, US | |
2421547 | 2421547 | 2022-07-15 | US | Pennsylvania | Cambria | 42021 | 36697 | 748 | 0 | 40.49527404 | -78.71377428 | 2022-07-16 04:21:05 | Cambria, Pennsylvania, US | |
3431622 | 3431622 | 2022-07-14 | US | Pennsylvania | Cambria | 42021 | 36697 | 748 | 0 | 40.49527404 | -78.71377428 | 2022-07-15 04:20:53 | Cambria, Pennsylvania, US | |
3112142 | 3112142 | 2022-07-13 | US | Pennsylvania | Cambria | 42021 | 36697 | 748 | 0 | 40.49527404 | -78.71377428 | 2022-07-14 04:20:57 | Cambria, Pennsylvania, US | |
3078135 | 3078135 | 2022-07-04 | Malta | 105407 | 748 | 0 | 35.9375 | 14.3754 | 2022-07-05 04:20:45 | Malta | ||||
1767417 | 1767417 | 2022-07-03 | Malta | 104919 | 748 | 0 | 35.9375 | 14.3754 | 2022-07-04 04:20:54 | Malta | ||||
1767349 | 1767349 | 2022-07-03 | Japan | Kyoto | 213801 | 748 | 0 | 35.253815 | 135.443341 | 2022-07-04 04:20:54 | Kyoto, Japan | |||
3365335 | 3365335 | 2022-07-02 | Japan | Kyoto | 213321 | 748 | 0 | 35.253815 | 135.443341 | 2022-07-03 04:20:59 | Kyoto, Japan | |||
2191011 | 2191011 | 2022-06-22 | US | Virginia | Prince William | 51153 | 104546 | 748 | 0 | 38.70916224 | -77.48713689 | 2022-06-23 04:20:55 | Prince William, Virginia, US | |
974317 | 974317 | 2022-06-01 | US | Virginia | Prince William | 51153 | 101416 | 748 | 0 | 38.70916224 | -77.48713689 | 2022-06-02 05:20:39 | Prince William, Virginia, US | |
232624 | 232624 | 2022-05-31 | US | Virginia | Prince William | 51153 | 101195 | 748 | 0 | 38.70916224 | -77.48713689 | 2022-06-01 04:20:55 | Prince William, Virginia, US | |
231882 | 231882 | 2022-05-31 | US | Pennsylvania | Butler | 42019 | 45920 | 748 | 0 | 40.91152759 | -79.91351055 | 2022-06-01 04:20:55 | Butler, Pennsylvania, US | |
3189389 | 3189389 | 2022-05-30 | US | Virginia | Prince William | 51153 | 100584 | 748 | 0 | 38.70916224 | -77.48713689 | 2022-05-31 04:20:51 | Prince William, Virginia, US | |
3188647 | 3188647 | 2022-05-30 | US | Pennsylvania | Butler | 42019 | 45920 | 748 | 0 | 40.91152759 | -79.91351055 | 2022-05-31 04:20:51 | Butler, Pennsylvania, US | |
3201538 | 3201538 | 2022-05-29 | US | Virginia | Prince William | 51153 | 100584 | 748 | 0 | 38.70916224 | -77.48713689 | 2022-05-30 04:20:50 | Prince William, Virginia, US | |
3200796 | 3200796 | 2022-05-29 | US | Pennsylvania | Butler | 42019 | 45920 | 748 | 0 | 40.91152759 | -79.91351055 | 2022-05-30 04:20:50 | Butler, Pennsylvania, US | |
2728416 | 2728416 | 2022-05-28 | US | Virginia | Prince William | 51153 | 100584 | 748 | 0 | 38.70916224 | -77.48713689 | 2022-05-29 04:20:53 | Prince William, Virginia, US | |
2727674 | 2727674 | 2022-05-28 | US | Pennsylvania | Butler | 42019 | 45920 | 748 | 0 | 40.91152759 | -79.91351055 | 2022-05-29 04:20:53 | Butler, Pennsylvania, US | |
1317597 | 1317597 | 2022-05-27 | US | Virginia | Prince William | 51153 | 100584 | 748 | 0 | 38.70916224 | -77.48713689 | 2022-05-28 04:21:07 | Prince William, Virginia, US | |
1316855 | 1316855 | 2022-05-27 | US | Pennsylvania | Butler | 42019 | 45920 | 748 | 0 | 40.91152759 | -79.91351055 | 2022-05-28 04:21:07 | Butler, Pennsylvania, US | |
1853389 | 1853389 | 2022-05-26 | US | Virginia | Prince William | 51153 | 100356 | 748 | 0 | 38.70916224 | -77.48713689 | 2022-05-27 04:20:56 | Prince William, Virginia, US | |
1852647 | 1852647 | 2022-05-26 | US | Pennsylvania | Butler | 42019 | 45920 | 748 | 0 | 40.91152759 | -79.91351055 | 2022-05-27 04:20:56 | Butler, Pennsylvania, US | |
2050523 | 2050523 | 2022-05-25 | US | Pennsylvania | Butler | 42019 | 45920 | 748 | 0 | 40.91152759 | -79.91351055 | 2022-05-26 04:20:50 | Butler, Pennsylvania, US | |
624534 | 624534 | 2022-05-22 | US | Pennsylvania | Butler | 42019 | 45920 | 748 | 0 | 40.91152759 | -79.91351055 | 2022-05-26 04:20:50 | Butler, 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]);