johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
314 rows where deaths = 855 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1076166 | 1076166 | 2022-12-28 | US | New York | Oneida | 36065 | 67293 | 855 | 0 | 43.24375382 | -75.43710392 | 2022-12-29 04:21:01 | Oneida, New York, US | |
2954712 | 2954712 | 2022-12-20 | US | Virginia | Chesterfield | 51041 | 95060 | 855 | 0 | 37.37373208 | -77.5868014 | 2022-12-21 04:21:03 | Chesterfield, Virginia, US | |
3177114 | 3177114 | 2022-12-19 | US | Virginia | Chesterfield | 51041 | 94961 | 855 | 0 | 37.37373208 | -77.5868014 | 2022-12-20 04:21:04 | Chesterfield, Virginia, US | |
1631631 | 1631631 | 2022-12-18 | US | Virginia | Chesterfield | 51041 | 94753 | 855 | 0 | 37.37373208 | -77.5868014 | 2022-12-19 04:21:03 | Chesterfield, Virginia, US | |
507010 | 507010 | 2022-12-17 | US | Virginia | Chesterfield | 51041 | 94753 | 855 | 0 | 37.37373208 | -77.5868014 | 2022-12-18 04:21:03 | Chesterfield, Virginia, US | |
3327582 | 3327582 | 2022-12-16 | US | Virginia | Chesterfield | 51041 | 94753 | 855 | 0 | 37.37373208 | -77.5868014 | 2022-12-17 04:21:04 | Chesterfield, Virginia, US | |
546094 | 546094 | 2022-12-15 | US | Virginia | Chesterfield | 51041 | 94668 | 855 | 0 | 37.37373208 | -77.5868014 | 2022-12-16 04:21:01 | Chesterfield, Virginia, US | |
307882 | 307882 | 2022-12-13 | Japan | Ibaraki | 472100 | 855 | 0 | 36.303588 | 140.319591 | 2022-12-14 04:21:04 | Ibaraki, Japan | |||
719137 | 719137 | 2022-12-04 | US | Colorado | Pueblo | 8101 | 59904 | 855 | 0 | 38.17359144 | -104.5127437 | 2022-12-05 04:20:58 | Pueblo, Colorado, US | |
2817426 | 2817426 | 2022-12-03 | US | Colorado | Pueblo | 8101 | 59904 | 855 | 0 | 38.17359144 | -104.5127437 | 2022-12-04 04:20:56 | Pueblo, Colorado, US | |
834282 | 834282 | 2022-12-02 | US | Colorado | Pueblo | 8101 | 59904 | 855 | 0 | 38.17359144 | -104.5127437 | 2022-12-03 04:21:02 | Pueblo, Colorado, US | |
294696 | 294696 | 2022-11-15 | US | Pennsylvania | Lackawanna | 42069 | 54997 | 855 | 0 | 41.43564672 | -75.60379201 | 2022-11-16 04:21:09 | Lackawanna, Pennsylvania, US | |
3599726 | 3599726 | 2022-11-14 | US | Pennsylvania | Lackawanna | 42069 | 54997 | 855 | 0 | 41.43564672 | -75.60379201 | 2022-11-15 04:21:16 | Lackawanna, Pennsylvania, US | |
314584 | 314584 | 2022-11-13 | US | Pennsylvania | Lackawanna | 42069 | 54997 | 855 | 0 | 41.43564672 | -75.60379201 | 2022-11-14 04:21:09 | Lackawanna, Pennsylvania, US | |
65745 | 65745 | 2022-11-12 | US | Pennsylvania | Lackawanna | 42069 | 54997 | 855 | 0 | 41.43564672 | -75.60379201 | 2022-11-13 04:21:14 | Lackawanna, Pennsylvania, US | |
2929907 | 2929907 | 2022-11-11 | US | Pennsylvania | Lackawanna | 42069 | 54997 | 855 | 0 | 41.43564672 | -75.60379201 | 2022-11-12 04:20:41 | Lackawanna, Pennsylvania, US | |
2508743 | 2508743 | 2022-11-10 | US | Pennsylvania | Lackawanna | 42069 | 54997 | 855 | 0 | 41.43564672 | -75.60379201 | 2022-11-11 04:21:22 | Lackawanna, Pennsylvania, US | |
2433618 | 2433618 | 2022-11-09 | US | Pennsylvania | Lackawanna | 42069 | 54997 | 855 | 0 | 41.43564672 | -75.60379201 | 2022-11-10 04:21:16 | Lackawanna, Pennsylvania, US | |
481275 | 481275 | 2022-11-08 | US | Michigan | Ottawa | 26139 | 84898 | 855 | 0 | 42.95996803 | -85.9969107 | 2022-11-09 04:21:22 | Ottawa, Michigan, US | |
481237 | 481237 | 2022-11-08 | US | Michigan | Ingham | 26065 | 80005 | 855 | 0 | 42.59716886 | -84.37472069 | 2022-11-09 04:21:22 | Ingham, Michigan, US | |
2440425 | 2440425 | 2022-11-07 | US | Michigan | Ottawa | 26139 | 84898 | 855 | 0 | 42.95996803 | -85.9969107 | 2022-11-08 04:21:21 | Ottawa, Michigan, US | |
2440387 | 2440387 | 2022-11-07 | US | Michigan | Ingham | 26065 | 80005 | 855 | 0 | 42.59716886 | -84.37472069 | 2022-11-08 04:21:21 | Ingham, Michigan, US | |
1051523 | 1051523 | 2022-11-06 | US | Michigan | Ottawa | 26139 | 84898 | 855 | 0 | 42.95996803 | -85.9969107 | 2022-11-07 04:21:26 | Ottawa, Michigan, US | |
1051485 | 1051485 | 2022-11-06 | US | Michigan | Ingham | 26065 | 80005 | 855 | 0 | 42.59716886 | -84.37472069 | 2022-11-07 04:21:26 | Ingham, Michigan, US | |
619547 | 619547 | 2022-11-05 | US | Michigan | Ottawa | 26139 | 84898 | 855 | 0 | 42.95996803 | -85.9969107 | 2022-11-06 04:21:24 | Ottawa, Michigan, US | |
619509 | 619509 | 2022-11-05 | US | Michigan | Ingham | 26065 | 80005 | 855 | 0 | 42.59716886 | -84.37472069 | 2022-11-06 04:21:24 | Ingham, Michigan, US | |
1024051 | 1024051 | 2022-11-04 | US | Michigan | Ottawa | 26139 | 84898 | 855 | 0 | 42.95996803 | -85.9969107 | 2022-11-05 04:21:52 | Ottawa, Michigan, US | |
1024013 | 1024013 | 2022-11-04 | US | Michigan | Ingham | 26065 | 80005 | 855 | 0 | 42.59716886 | -84.37472069 | 2022-11-05 04:21:52 | Ingham, Michigan, US | |
433042 | 433042 | 2022-11-03 | US | Michigan | Ottawa | 26139 | 84898 | 855 | 0 | 42.95996803 | -85.9969107 | 2022-11-04 04:22:11 | Ottawa, Michigan, US | |
433004 | 433004 | 2022-11-03 | US | Michigan | Ingham | 26065 | 80005 | 855 | 0 | 42.59716886 | -84.37472069 | 2022-11-04 04:22:11 | Ingham, Michigan, US | |
852146 | 852146 | 2022-11-02 | US | Oklahoma | Cleveland | 40027 | 94040 | 855 | 0 | 35.20413532 | -97.32519562 | 2022-11-03 04:22:05 | Cleveland, Oklahoma, US | |
851284 | 851284 | 2022-11-02 | US | Michigan | Ottawa | 26139 | 84898 | 855 | 0 | 42.95996803 | -85.9969107 | 2022-11-03 04:22:05 | Ottawa, Michigan, US | |
851246 | 851246 | 2022-11-02 | US | Michigan | Ingham | 26065 | 80005 | 855 | 0 | 42.59716886 | -84.37472069 | 2022-11-03 04:22:05 | Ingham, Michigan, US | |
712997 | 712997 | 2022-11-01 | US | Oklahoma | Cleveland | 40027 | 94040 | 855 | 0 | 35.20413532 | -97.32519562 | 2022-11-02 04:22:09 | Cleveland, Oklahoma, US | |
712135 | 712135 | 2022-11-01 | US | Michigan | Ottawa | 26139 | 84898 | 855 | 0 | 42.95996803 | -85.9969107 | 2022-11-02 04:22:09 | Ottawa, Michigan, US | |
712097 | 712097 | 2022-11-01 | US | Michigan | Ingham | 26065 | 80005 | 855 | 0 | 42.59716886 | -84.37472069 | 2022-11-02 04:22:09 | Ingham, Michigan, US | |
3287446 | 3287446 | 2022-10-31 | US | Oklahoma | Cleveland | 40027 | 94040 | 855 | 0 | 35.20413532 | -97.32519562 | 2022-11-01 04:22:36 | Cleveland, Oklahoma, US | |
322479 | 322479 | 2022-10-30 | US | Oklahoma | Cleveland | 40027 | 94040 | 855 | 0 | 35.20413532 | -97.32519562 | 2022-10-31 04:21:36 | Cleveland, Oklahoma, US | |
914755 | 914755 | 2022-10-29 | US | Oklahoma | Cleveland | 40027 | 94040 | 855 | 0 | 35.20413532 | -97.32519562 | 2022-10-30 04:22:14 | Cleveland, Oklahoma, US | |
1369024 | 1369024 | 2022-10-28 | US | Oklahoma | Cleveland | 40027 | 94040 | 855 | 0 | 35.20413532 | -97.32519562 | 2022-10-29 04:21:13 | Cleveland, Oklahoma, US | |
3040879 | 3040879 | 2022-10-27 | US | Oklahoma | Cleveland | 40027 | 94040 | 855 | 0 | 35.20413532 | -97.32519562 | 2022-10-28 04:22:31 | Cleveland, Oklahoma, US | |
3570364 | 3570364 | 2022-09-19 | Chile | Arica y Parinacota | 71978 | 855 | 0 | -18.594 | -69.4785 | 2022-09-19 23:21:55 | Arica y Parinacota, Chile | |||
419103 | 419103 | 2022-09-18 | Chile | Arica y Parinacota | 71978 | 855 | 0 | -18.594 | -69.4785 | 2022-09-19 04:21:49 | Arica y Parinacota, Chile | |||
3373127 | 3373127 | 2022-09-17 | Chile | Arica y Parinacota | 71978 | 855 | 0 | -18.594 | -69.4785 | 2022-09-18 04:22:50 | Arica y Parinacota, Chile | |||
2355235 | 2355235 | 2022-09-16 | Chile | Arica y Parinacota | 71978 | 855 | 0 | -18.594 | -69.4785 | 2022-09-17 04:20:19 | Arica y Parinacota, Chile | |||
3986392 | 3986392 | 2022-09-15 | Chile | Arica y Parinacota | 71978 | 855 | 0 | -18.594 | -69.4785 | 2022-09-16 04:21:19 | Arica y Parinacota, Chile | |||
1888909 | 1888909 | 2022-09-14 | Chile | Arica y Parinacota | 71978 | 855 | 0 | -18.594 | -69.4785 | 2022-09-15 04:21:02 | Arica y Parinacota, Chile | |||
371964 | 371964 | 2022-09-13 | Chile | Arica y Parinacota | 71978 | 855 | 0 | -18.594 | -69.4785 | 2022-09-14 04:20:44 | Arica y Parinacota, Chile | |||
2394569 | 2394569 | 2022-09-12 | Chile | Arica y Parinacota | 71958 | 855 | 0 | -18.594 | -69.4785 | 2022-09-13 04:20:57 | Arica y Parinacota, Chile | |||
3765647 | 3765647 | 2022-09-11 | Chile | Arica y Parinacota | 71938 | 855 | 0 | -18.594 | -69.4785 | 2022-09-12 04:20:58 | Arica y Parinacota, Chile | |||
3824222 | 3824222 | 2022-09-10 | Chile | Arica y Parinacota | 71886 | 855 | 0 | -18.594 | -69.4785 | 2022-09-11 04:20:50 | Arica y Parinacota, Chile | |||
2344491 | 2344491 | 2022-08-31 | US | Illinois | Winnebago | 17201 | 90407 | 855 | 0 | 42.33641854 | -89.16085327 | 2022-09-01 04:21:03 | Winnebago, Illinois, US | |
2828698 | 2828698 | 2022-08-25 | France | Reunion | 454665 | 855 | 0 | -21.1151 | 55.5364 | 2022-08-26 04:21:02 | Reunion, France | |||
2323231 | 2323231 | 2022-08-24 | France | Reunion | 454665 | 855 | 0 | -21.1151 | 55.5364 | 2022-08-25 04:21:13 | Reunion, France | |||
1251611 | 1251611 | 2022-08-23 | US | Georgia | Muscogee | 13215 | 42262 | 855 | 0 | 32.50931999 | -84.87142262 | 2022-08-24 04:20:46 | Muscogee, Georgia, US | |
1250640 | 1250640 | 2022-08-23 | France | Reunion | 454665 | 855 | 0 | -21.1151 | 55.5364 | 2022-08-24 04:20:46 | Reunion, France | |||
2853715 | 2853715 | 2022-08-22 | US | Georgia | Muscogee | 13215 | 42262 | 855 | 0 | 32.50931999 | -84.87142262 | 2022-08-23 04:20:56 | Muscogee, Georgia, US | |
2852744 | 2852744 | 2022-08-22 | France | Reunion | 454665 | 855 | 0 | -21.1151 | 55.5364 | 2022-08-23 04:20:56 | Reunion, France | |||
2403687 | 2403687 | 2022-08-21 | US | Georgia | Muscogee | 13215 | 42262 | 855 | 0 | 32.50931999 | -84.87142262 | 2022-08-22 04:20:38 | Muscogee, Georgia, US | |
2402716 | 2402716 | 2022-08-21 | France | Reunion | 454665 | 855 | 0 | -21.1151 | 55.5364 | 2022-08-22 04:20:38 | Reunion, France | |||
3798765 | 3798765 | 2022-08-20 | US | Georgia | Muscogee | 13215 | 42262 | 855 | 0 | 32.50931999 | -84.87142262 | 2022-08-21 04:20:44 | Muscogee, Georgia, US | |
3797794 | 3797794 | 2022-08-20 | France | Reunion | 454665 | 855 | 0 | -21.1151 | 55.5364 | 2022-08-21 04:20:44 | Reunion, France | |||
2364351 | 2364351 | 2022-08-19 | US | Georgia | Muscogee | 13215 | 42262 | 855 | 0 | 32.50931999 | -84.87142262 | 2022-08-20 04:21:01 | Muscogee, Georgia, US | |
2363380 | 2363380 | 2022-08-19 | France | Reunion | 454665 | 855 | 0 | -21.1151 | 55.5364 | 2022-08-20 04:21:01 | Reunion, France | |||
1162022 | 1162022 | 2022-08-18 | US | Georgia | Muscogee | 13215 | 42262 | 855 | 0 | 32.50931999 | -84.87142262 | 2022-08-19 04:20:54 | Muscogee, Georgia, US | |
3951346 | 3951346 | 2022-08-17 | US | Georgia | Muscogee | 13215 | 42262 | 855 | 0 | 32.50931999 | -84.87142262 | 2022-08-18 04:21:11 | Muscogee, Georgia, US | |
1086763 | 1086763 | 2022-08-09 | US | Florida | Charlotte | 12015 | 42433 | 855 | 0 | 26.90131002 | -81.92949121 | 2022-08-10 04:20:57 | Charlotte, Florida, US | |
3544178 | 3544178 | 2022-08-08 | US | Florida | Charlotte | 12015 | 42433 | 855 | 0 | 26.90131002 | -81.92949121 | 2022-08-09 04:20:34 | Charlotte, Florida, US | |
1070581 | 1070581 | 2022-08-07 | US | Florida | Charlotte | 12015 | 42433 | 855 | 0 | 26.90131002 | -81.92949121 | 2022-08-08 04:21:08 | Charlotte, Florida, US | |
1941169 | 1941169 | 2022-08-06 | US | Florida | Charlotte | 12015 | 42433 | 855 | 0 | 26.90131002 | -81.92949121 | 2022-08-07 04:20:54 | Charlotte, Florida, US | |
880968 | 880968 | 2022-08-05 | US | Florida | Charlotte | 12015 | 42433 | 855 | 0 | 26.90131002 | -81.92949121 | 2022-08-06 04:20:56 | Charlotte, Florida, US | |
2009379 | 2009379 | 2022-08-04 | US | Florida | Charlotte | 12015 | 42433 | 855 | 0 | 26.90131002 | -81.92949121 | 2022-08-05 04:20:52 | Charlotte, Florida, US | |
1100313 | 1100313 | 2022-08-03 | US | New Mexico | Dona Ana | 35013 | 70006 | 855 | 0 | 32.35275771 | -106.8329387 | 2022-08-04 04:20:58 | Dona Ana, New Mexico, US | |
1098806 | 1098806 | 2022-08-03 | US | Florida | Charlotte | 12015 | 42433 | 855 | 0 | 26.90131002 | -81.92949121 | 2022-08-04 04:20:58 | Charlotte, Florida, US | |
1407238 | 1407238 | 2022-08-02 | US | New Mexico | Dona Ana | 35013 | 69944 | 855 | 0 | 32.35275771 | -106.8329387 | 2022-08-03 04:20:59 | Dona Ana, New Mexico, US | |
2597454 | 2597454 | 2022-07-25 | US | Virginia | Virginia Beach | 51810 | 101295 | 855 | 0 | 36.73285734 | -76.04566934 | 2022-07-26 04:20:58 | Virginia Beach, Virginia, US | |
899569 | 899569 | 2022-07-24 | US | Virginia | Virginia Beach | 51810 | 100922 | 855 | 0 | 36.73285734 | -76.04566934 | 2022-07-25 04:20:51 | Virginia Beach, Virginia, US | |
899282 | 899282 | 2022-07-24 | US | Texas | Jefferson | 48245 | 55762 | 855 | 0 | 29.8832777 | -94.16434171 | 2022-07-25 04:20:51 | Jefferson, Texas, US | |
94563 | 94563 | 2022-07-23 | US | Virginia | Virginia Beach | 51810 | 100922 | 855 | 0 | 36.73285734 | -76.04566934 | 2022-07-24 04:20:47 | Virginia Beach, Virginia, US | |
94276 | 94276 | 2022-07-23 | US | Texas | Jefferson | 48245 | 55713 | 855 | 0 | 29.8832777 | -94.16434171 | 2022-07-24 04:20:47 | Jefferson, Texas, US | |
903585 | 903585 | 2022-07-22 | US | Virginia | Virginia Beach | 51810 | 100922 | 855 | 0 | 36.73285734 | -76.04566934 | 2022-07-23 04:20:53 | Virginia Beach, Virginia, US | |
673721 | 673721 | 2022-07-21 | US | Virginia | Virginia Beach | 51810 | 100749 | 855 | 0 | 36.73285734 | -76.04566934 | 2022-07-22 04:21:15 | Virginia Beach, Virginia, US | |
633345 | 633345 | 2022-07-12 | US | Washington | Clark | 53011 | 99354 | 855 | 0 | 45.77568046 | -122.4829204 | 2022-07-13 04:20:58 | Clark, Washington, US | |
1214989 | 1214989 | 2022-07-11 | US | Washington | Clark | 53011 | 99354 | 855 | 0 | 45.77568046 | -122.4829204 | 2022-07-12 04:20:51 | Clark, Washington, US | |
2792471 | 2792471 | 2022-07-10 | US | Washington | Clark | 53011 | 99056 | 855 | 0 | 45.77568046 | -122.4829204 | 2022-07-11 04:20:46 | Clark, Washington, US | |
145424 | 145424 | 2022-07-09 | US | Washington | Clark | 53011 | 99056 | 855 | 0 | 45.77568046 | -122.4829204 | 2022-07-10 04:20:54 | Clark, Washington, US | |
1420524 | 1420524 | 2022-07-08 | US | Washington | Clark | 53011 | 99056 | 855 | 0 | 45.77568046 | -122.4829204 | 2022-07-09 04:20:59 | Clark, Washington, US | |
3967367 | 3967367 | 2022-07-05 | US | Georgia | Hall | 13139 | 55126 | 855 | 0 | 34.32207823 | -83.81896936 | 2022-07-06 04:20:58 | Hall, Georgia, US | |
3078878 | 3078878 | 2022-07-04 | US | Georgia | Hall | 13139 | 55126 | 855 | 0 | 34.32207823 | -83.81896936 | 2022-07-05 04:20:45 | Hall, Georgia, US | |
1768160 | 1768160 | 2022-07-03 | US | Georgia | Hall | 13139 | 55126 | 855 | 0 | 34.32207823 | -83.81896936 | 2022-07-04 04:20:54 | Hall, Georgia, US | |
3366146 | 3366146 | 2022-07-02 | US | Georgia | Hall | 13139 | 55126 | 855 | 0 | 34.32207823 | -83.81896936 | 2022-07-03 04:20:59 | Hall, Georgia, US | |
594475 | 594475 | 2022-07-01 | US | Georgia | Hall | 13139 | 55126 | 855 | 0 | 34.32207823 | -83.81896936 | 2022-07-02 04:21:16 | Hall, Georgia, US | |
3940876 | 3940876 | 2022-06-30 | US | Georgia | Hall | 13139 | 55126 | 855 | 0 | 34.32207823 | -83.81896936 | 2022-07-01 04:21:10 | Hall, Georgia, US | |
2490834 | 2490834 | 2022-06-29 | US | Georgia | Hall | 13139 | 55126 | 855 | 0 | 34.32207823 | -83.81896936 | 2022-06-30 04:21:01 | Hall, Georgia, US | |
3349733 | 3349733 | 2022-06-24 | US | Texas | Galveston | 48167 | 101859 | 855 | 0 | 29.40167322 | -94.90469073 | 2022-06-25 04:20:57 | Galveston, Texas, US | |
1651474 | 1651474 | 2022-06-23 | US | Texas | Galveston | 48167 | 101642 | 855 | 0 | 29.40167322 | -94.90469073 | 2022-06-24 04:20:58 | Galveston, Texas, US | |
1649918 | 1649918 | 2022-06-23 | US | Louisiana | St. Tammany | 22103 | 76640 | 855 | 0 | 30.40942847 | -89.95642711 | 2022-06-24 04:20:58 | St. Tammany, Louisiana, US | |
1648634 | 1648634 | 2022-06-23 | Russia | Tomsk Oblast | 132294 | 855 | 0 | 58.6124279 | 82.0475315 | 2022-06-24 04:20:58 | Tomsk Oblast, Russia | |||
2190709 | 2190709 | 2022-06-22 | US | Texas | Galveston | 48167 | 101407 | 855 | 0 | 29.40167322 | -94.90469073 | 2022-06-23 04:20:55 | Galveston, Texas, US | |
2189153 | 2189153 | 2022-06-22 | US | Louisiana | St. Tammany | 22103 | 76514 | 855 | 0 | 30.40942847 | -89.95642711 | 2022-06-23 04:20:55 | St. Tammany, Louisiana, 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]);