daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
206 rows where deaths = 897 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 28
| day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2022-10-25 | US | North Carolina | Forsyth | 37067 | 114777 | 897 | 0 | 36.12859861 | -80.25459052 | 2022-10-26 04:22:19 | Forsyth, North Carolina, US | |
| 2022-10-24 | US | North Carolina | Forsyth | 37067 | 114777 | 897 | 0 | 36.12859861 | -80.25459052 | 2022-10-25 04:21:53 | Forsyth, North Carolina, US | |
| 2022-10-23 | US | North Carolina | Forsyth | 37067 | 114777 | 897 | 0 | 36.12859861 | -80.25459052 | 2022-10-24 04:22:29 | Forsyth, North Carolina, US | |
| 2022-10-22 | US | North Carolina | Forsyth | 37067 | 114777 | 897 | 0 | 36.12859861 | -80.25459052 | 2022-10-23 04:22:46 | Forsyth, North Carolina, US | |
| 2022-10-21 | US | North Carolina | Forsyth | 37067 | 114777 | 897 | 0 | 36.12859861 | -80.25459052 | 2022-10-22 04:22:53 | Forsyth, North Carolina, US | |
| 2022-10-20 | US | North Carolina | Forsyth | 37067 | 114777 | 897 | 0 | 36.12859861 | -80.25459052 | 2022-10-21 04:22:23 | Forsyth, North Carolina, US | |
| 2022-10-19 | US | North Carolina | Forsyth | 37067 | 114777 | 897 | 0 | 36.12859861 | -80.25459052 | 2022-10-20 04:22:59 | Forsyth, North Carolina, US | |
| 2022-10-18 | US | North Carolina | Forsyth | 37067 | 114777 | 897 | 0 | 36.12859861 | -80.25459052 | 2022-10-19 04:22:26 | Forsyth, North Carolina, US | |
| 2022-10-17 | US | North Carolina | Forsyth | 37067 | 114777 | 897 | 0 | 36.12859861 | -80.25459052 | 2022-10-18 04:22:42 | Forsyth, North Carolina, US | |
| 2022-10-16 | US | North Carolina | Forsyth | 37067 | 114777 | 897 | 0 | 36.12859861 | -80.25459052 | 2022-10-17 04:20:31 | Forsyth, North Carolina, US | |
| 2022-10-15 | US | North Carolina | Forsyth | 37067 | 114777 | 897 | 0 | 36.12859861 | -80.25459052 | 2022-10-16 04:22:39 | Forsyth, North Carolina, US | |
| 2022-10-14 | US | North Carolina | Forsyth | 37067 | 114777 | 897 | 0 | 36.12859861 | -80.25459052 | 2022-10-15 04:22:00 | Forsyth, North Carolina, US | |
| 2022-10-13 | US | North Carolina | Forsyth | 37067 | 114777 | 897 | 0 | 36.12859861 | -80.25459052 | 2022-10-14 04:22:28 | Forsyth, North Carolina, US | |
| 2022-10-12 | US | North Carolina | Forsyth | 37067 | 114777 | 897 | 0 | 36.12859861 | -80.25459052 | 2022-10-13 04:22:39 | Forsyth, North Carolina, US | |
| 2022-08-11 | US | Indiana | St. Joseph | 18141 | 77006 | 897 | 0 | 41.61756781 | -86.29040834 | 2022-08-12 04:20:54 | St. Joseph, Indiana, US | |
| 2022-08-10 | US | Indiana | St. Joseph | 18141 | 77006 | 897 | 0 | 41.61756781 | -86.29040834 | 2022-08-11 04:20:49 | St. Joseph, Indiana, US | |
| 2022-06-23 | US | California | San Francisco | 6075 | 165950 | 897 | 0 | 37.75215114 | -122.4385672 | 2022-06-24 04:20:58 | San Francisco, California, US | |
| 2022-06-22 | US | California | San Francisco | 6075 | 164524 | 897 | 0 | 37.75215114 | -122.4385672 | 2022-06-23 04:20:55 | San Francisco, California, US | |
| 2022-06-21 | US | California | San Francisco | 6075 | 164492 | 897 | 0 | 37.75215114 | -122.4385672 | 2022-06-22 04:20:54 | San Francisco, California, US | |
| 2022-06-20 | US | California | San Francisco | 6075 | 164453 | 897 | 0 | 37.75215114 | -122.4385672 | 2022-06-21 04:20:56 | San Francisco, California, US | |
| 2022-06-19 | US | California | San Francisco | 6075 | 162099 | 897 | 0 | 37.75215114 | -122.4385672 | 2022-06-20 04:21:01 | San Francisco, California, US | |
| 2022-06-18 | US | California | San Francisco | 6075 | 162081 | 897 | 0 | 37.75215114 | -122.4385672 | 2022-06-19 04:20:51 | San Francisco, California, US | |
| 2022-06-17 | US | California | San Francisco | 6075 | 162048 | 897 | 0 | 37.75215114 | -122.4385672 | 2022-06-18 04:21:10 | San Francisco, California, US | |
| 2022-05-24 | US | Pennsylvania | Cumberland | 42041 | 52158 | 897 | 0 | 40.1625372 | -77.26130755 | 2022-05-25 04:20:56 | Cumberland, Pennsylvania, US | |
| 2022-05-24 | US | Georgia | Richmond | 13245 | 50682 | 897 | 0 | 33.35777107 | -82.07026432 | 2022-05-25 04:20:56 | Richmond, Georgia, US | |
| 2022-05-23 | US | Pennsylvania | Cumberland | 42041 | 52158 | 897 | 0 | 40.1625372 | -77.26130755 | 2022-05-24 04:20:57 | Cumberland, Pennsylvania, US | |
| 2022-05-23 | US | Georgia | Richmond | 13245 | 50682 | 897 | 0 | 33.35777107 | -82.07026432 | 2022-05-24 04:20:57 | Richmond, Georgia, US | |
| 2022-05-21 | US | Pennsylvania | Cumberland | 42041 | 52158 | 897 | 0 | 40.1625372 | -77.26130755 | 2022-05-22 04:20:52 | Cumberland, Pennsylvania, US | |
| 2022-05-21 | US | Georgia | Richmond | 13245 | 50682 | 897 | 0 | 33.35777107 | -82.07026432 | 2022-05-22 04:20:52 | Richmond, Georgia, US | |
| 2022-05-20 | US | Pennsylvania | Cumberland | 42041 | 52158 | 897 | 0 | 40.1625372 | -77.26130755 | 2022-05-21 04:20:58 | Cumberland, Pennsylvania, US | |
| 2022-05-20 | US | Georgia | Richmond | 13245 | 50682 | 897 | 0 | 33.35777107 | -82.07026432 | 2022-05-21 04:20:58 | Richmond, Georgia, US | |
| 2022-05-19 | US | Pennsylvania | Cumberland | 42041 | 52158 | 897 | 0 | 40.1625372 | -77.26130755 | 2022-05-20 04:20:57 | Cumberland, Pennsylvania, US | |
| 2022-05-19 | US | Georgia | Richmond | 13245 | 50682 | 897 | 0 | 33.35777107 | -82.07026432 | 2022-05-20 04:20:57 | Richmond, Georgia, US | |
| 2022-05-18 | US | Pennsylvania | Cumberland | 42041 | 52158 | 897 | 0 | 40.1625372 | -77.26130755 | 2022-05-19 04:20:54 | Cumberland, Pennsylvania, US | |
| 2022-05-18 | US | Georgia | Richmond | 13245 | 50682 | 897 | 0 | 33.35777107 | -82.07026432 | 2022-05-19 04:20:54 | Richmond, Georgia, US | |
| 2022-05-13 | US | New York | Rockland | 36087 | 96142 | 897 | 0 | 41.15027894 | -74.02560498 | 2022-05-14 04:20:48 | Rockland, New York, US | |
| 2022-05-12 | US | New York | Rockland | 36087 | 96142 | 897 | 0 | 41.15027894 | -74.02560498 | 2022-05-13 04:20:51 | Rockland, New York, US | |
| 2022-05-11 | US | New York | Rockland | 36087 | 95943 | 897 | 0 | 41.15027894 | -74.02560498 | 2022-05-12 04:20:54 | Rockland, New York, US | |
| 2022-04-25 | US | Texas | Bell | 48027 | 67029 | 897 | 0 | 31.03736027 | -97.4785025 | 2022-04-26 04:20:51 | Bell, Texas, US | |
| 2022-04-24 | US | Texas | Bell | 48027 | 67020 | 897 | 0 | 31.03736027 | -97.4785025 | 2022-04-25 04:20:56 | Bell, Texas, US | |
| 2022-04-23 | US | Texas | Bell | 48027 | 67009 | 897 | 0 | 31.03736027 | -97.4785025 | 2022-04-24 04:20:56 | Bell, Texas, US | |
| 2022-04-22 | US | Texas | Bell | 48027 | 66996 | 897 | 0 | 31.03736027 | -97.4785025 | 2022-04-23 04:20:50 | Bell, Texas, US | |
| 2022-04-21 | US | Texas | Bell | 48027 | 66976 | 897 | 0 | 31.03736027 | -97.4785025 | 2022-04-22 04:20:45 | Bell, Texas, US | |
| 2022-04-11 | US | Tennessee | Rutherford | 47149 | 95738 | 897 | 0 | 35.84591405 | -86.4107263 | 2022-04-12 04:20:49 | Rutherford, Tennessee, US | |
| 2022-03-30 | US | Texas | McLennan | 48309 | 57540 | 897 | 0 | 31.55255453 | -97.20217694 | 2022-03-31 04:20:56 | McLennan, Texas, US | |
| 2022-03-29 | US | Texas | McLennan | 48309 | 57486 | 897 | 0 | 31.55255453 | -97.20217694 | 2022-03-30 04:20:45 | McLennan, Texas, US | |
| 2022-03-28 | US | Texas | McLennan | 48309 | 57409 | 897 | 0 | 31.55255453 | -97.20217694 | 2022-03-29 04:20:46 | McLennan, Texas, US | |
| 2022-03-27 | US | Texas | McLennan | 48309 | 57407 | 897 | 0 | 31.55255453 | -97.20217694 | 2022-03-28 04:20:33 | McLennan, Texas, US | |
| 2022-03-26 | US | Texas | McLennan | 48309 | 57404 | 897 | 0 | 31.55255453 | -97.20217694 | 2022-03-27 04:20:47 | McLennan, Texas, US | |
| 2022-03-25 | US | Texas | McLennan | 48309 | 57344 | 897 | 0 | 31.55255453 | -97.20217694 | 2022-03-26 04:20:23 | McLennan, Texas, US | |
| 2022-03-24 | US | Virginia | Henrico | 51087 | 63974 | 897 | 0 | 37.53460572 | -77.39326555 | 2022-03-25 04:20:46 | Henrico, Virginia, US | |
| 2022-03-22 | US | Virginia | Henrico | 51087 | 63882 | 897 | 0 | 37.53460572 | -77.39326555 | 2022-03-23 04:20:48 | Henrico, Virginia, US | |
| 2022-03-21 | US | Virginia | Henrico | 51087 | 63882 | 897 | 0 | 37.53460572 | -77.39326555 | 2022-03-22 04:20:54 | Henrico, Virginia, US | |
| 2022-03-17 | US | California | Imperial | 6025 | 65584 | 897 | 0 | 33.0393082 | -115.36690420000001 | 2022-03-18 04:20:55 | Imperial, California, US | |
| 2022-03-15 | US | California | Imperial | 6025 | 65522 | 897 | 0 | 33.0393082 | -115.36690420000001 | 2022-03-16 04:20:50 | Imperial, California, US | |
| 2022-03-14 | US | California | Imperial | 6025 | 65473 | 897 | 0 | 33.0393082 | -115.36690420000001 | 2022-03-15 04:20:47 | Imperial, California, US | |
| 2022-03-10 | US | Alabama | Montgomery | 1101 | 54527 | 897 | 0 | 32.2206831 | -86.20969272 | 2022-03-11 04:20:50 | Montgomery, Alabama, US | |
| 2022-03-06 | US | Alabama | Madison | 1089 | 88436 | 897 | 0 | 34.76327133 | -86.55069633 | 2022-03-07 04:20:47 | Madison, Alabama, US | |
| 2022-03-05 | US | Alabama | Madison | 1089 | 88436 | 897 | 0 | 34.76327133 | -86.55069633 | 2022-03-06 04:20:49 | Madison, Alabama, US | |
| 2022-03-04 | US | Alabama | Madison | 1089 | 88436 | 897 | 0 | 34.76327133 | -86.55069633 | 2022-03-05 04:21:10 | Madison, Alabama, US | |
| 2022-03-03 | Russia | Adygea Republic | 44396 | 897 | 0 | 44.6939006 | 40.1520421 | 2022-03-04 04:21:09 | Adygea Republic, Russia | |||
| 2022-02-23 | Russia | Novgorod Oblast | 90392 | 897 | 0 | 58.2843833 | 32.516975699999996 | 2022-02-24 04:21:14 | Novgorod Oblast, Russia | |||
| 2022-02-13 | Singapore | 469495 | 897 | 0 | 1.2833 | 103.8333 | 2022-02-14 04:20:51 | Singapore | ||||
| 2022-01-23 | US | Texas | Brazoria | 48039 | 85872 | 897 | 0 | 29.18757369 | -95.44563172 | 2022-01-24 04:21:12 | Brazoria, Texas, US | |
| 2022-01-07 | US | New York | Onondaga | 36067 | 80188 | 897 | 0 | 43.00491923 | -76.19971155 | 2022-01-08 04:21:53 | Onondaga, New York, US | |
| 2022-01-02 | US | Tennessee | Hamilton | 47065 | 71768 | 897 | 0 | 35.17670231 | -85.16652245 | 2022-01-03 02:22:25 | Hamilton, Tennessee, US | |
| 2021-12-18 | Russia | Karachay-Cherkess Republic | 31388 | 897 | 0 | 43.7368326 | 41.7267991 | 2021-12-19 04:21:11 | Karachay-Cherkess Republic, Russia | |||
| 2021-12-17 | Russia | Karachay-Cherkess Republic | 31320 | 897 | 0 | 43.7368326 | 41.7267991 | 2021-12-18 02:22:20 | Karachay-Cherkess Republic, Russia | |||
| 2021-12-16 | Russia | Karachay-Cherkess Republic | 31253 | 897 | 0 | 43.7368326 | 41.7267991 | 2021-12-17 04:22:14 | Karachay-Cherkess Republic, Russia | |||
| 2021-12-16 | Luxembourg | 95759 | 897 | 0 | 49.8153 | 6.1296 | 2021-12-17 04:22:14 | Luxembourg | ||||
| 2021-12-13 | US | Ohio | Butler | 39017 | 58792 | 897 | 0 | 39.44012838 | -84.57388716 | 2021-12-14 04:22:38 | Butler, Ohio, US | |
| 2021-12-13 | US | New Jersey | Somerset | 34035 | 37968 | 897 | 0 | 40.56465737 | -74.61683016 | 2021-12-14 04:22:38 | Somerset, New Jersey, US | |
| 2021-12-10 | Russia | Yamalo-Nenets Autonomous Okrug | 59739 | 897 | 0 | 67.1471631 | 74.3415488 | 2021-12-11 04:22:45 | Yamalo-Nenets Autonomous Okrug, Russia | |||
| 2021-12-08 | US | Indiana | Allen | 18003 | 68763 | 897 | 0 | 41.09194313 | -85.06800636 | 2021-12-09 04:22:49 | Allen, Indiana, US | |
| 2021-11-17 | US | Pennsylvania | Chester | 42029 | 53475 | 897 | 0 | 39.97291773 | -75.74768357 | 2021-11-18 04:21:33 | Chester, Pennsylvania, US | |
| 2021-11-16 | Canada | Saskatchewan | 79610 | 897 | 0 | 52.9399 | -106.4509 | 2021-11-17 04:21:48 | Saskatchewan, Canada | |||
| 2021-11-15 | US | South Carolina | Horry | 45051 | 62964 | 897 | 0 | 33.9212828 | -78.99555293 | 2021-11-16 04:21:10 | Horry, South Carolina, US | |
| 2021-11-01 | US | Colorado | Arapahoe | 8005 | 82121 | 897 | 0 | 39.64977461 | -104.3353617 | 2021-11-02 04:22:03 | Arapahoe, Colorado, US | |
| 2021-10-28 | US | Texas | Webb | 48479 | 58052 | 897 | 0 | 27.7610369 | -99.33237355 | 2021-10-29 04:22:03 | Webb, Texas, US | |
| 2021-10-28 | Russia | Pskov Oblast | 56881 | 897 | 0 | 57.535872899999994 | 28.8586826 | 2021-10-29 04:22:03 | Pskov Oblast, Russia | |||
| 2021-10-27 | Russia | Pskov Oblast | 56600 | 897 | 0 | 57.535872899999994 | 28.8586826 | 2021-10-28 04:22:08 | Pskov Oblast, Russia | |||
| 2021-10-25 | Guyana | 35104 | 897 | 0 | 4.860416000000002 | -58.93018000000001 | 2021-10-26 04:22:09 | Guyana | ||||
| 2021-10-24 | Russia | Kabardino-Balkarian Republic | 34240 | 897 | 0 | 43.480604799999995 | 43.5978976 | 2021-10-25 04:22:31 | Kabardino-Balkarian Republic, Russia | |||
| 2021-10-23 | US | Texas | Webb | 48479 | 57975 | 897 | 0 | 27.7610369 | -99.33237355 | 2021-10-24 04:21:22 | Webb, Texas, US | |
| 2021-10-22 | US | Texas | Webb | 48479 | 57936 | 897 | 0 | 27.7610369 | -99.33237355 | 2021-10-23 04:21:32 | Webb, Texas, US | |
| 2021-10-22 | Russia | Tatarstan Republic | 29239 | 897 | 0 | 55.7648572 | 52.43104273 | 2021-10-23 04:21:32 | Tatarstan Republic, Russia | |||
| 2021-10-21 | US | Texas | Webb | 48479 | 57906 | 897 | 0 | 27.7610369 | -99.33237355 | 2021-10-22 04:21:14 | Webb, Texas, US | |
| 2021-10-18 | US | Arizona | Yuma | 4027 | 41187 | 897 | 0 | 32.76895712 | -113.90666740000002 | 2021-10-19 04:20:54 | Yuma, Arizona, US | |
| 2021-10-17 | US | Arizona | Yuma | 4027 | 41187 | 897 | 0 | 32.76895712 | -113.90666740000002 | 2021-10-18 04:21:10 | Yuma, Arizona, US | |
| 2021-10-16 | US | Arizona | Yuma | 4027 | 41187 | 897 | 0 | 32.76895712 | -113.90666740000002 | 2021-10-17 04:21:29 | Yuma, Arizona, US | |
| 2021-10-15 | US | Arizona | Yuma | 4027 | 41147 | 897 | 0 | 32.76895712 | -113.90666740000002 | 2021-10-16 04:21:15 | Yuma, Arizona, US | |
| 2021-10-14 | US | Arizona | Yuma | 4027 | 41121 | 897 | 0 | 32.76895712 | -113.90666740000002 | 2021-10-15 04:21:26 | Yuma, Arizona, US | |
| 2021-10-13 | US | Arizona | Yuma | 4027 | 41100 | 897 | 0 | 32.76895712 | -113.90666740000002 | 2021-10-14 04:21:29 | Yuma, Arizona, US | |
| 2021-10-05 | US | Kansas | Johnson | 20091 | 75358 | 897 | 0 | 38.88548175 | -94.82250877 | 2021-10-06 04:21:33 | Johnson, Kansas, US | |
| 2021-10-04 | US | Kansas | Johnson | 20091 | 75358 | 897 | 0 | 38.88548175 | -94.82250877 | 2021-10-05 04:21:27 | Johnson, Kansas, US | |
| 2021-10-04 | US | Colorado | Jefferson | 8059 | 59755 | 897 | 0 | 39.58635604 | -105.2517692 | 2021-10-05 04:21:27 | Jefferson, Colorado, US | |
| 2021-10-03 | US | Kansas | Johnson | 20091 | 75105 | 897 | 0 | 38.88548175 | -94.82250877 | 2021-10-04 04:21:31 | Johnson, Kansas, US | |
| 2021-10-02 | US | Kansas | Johnson | 20091 | 75105 | 897 | 0 | 38.88548175 | -94.82250877 | 2021-10-03 04:21:24 | Johnson, Kansas, US | |
| 2021-10-01 | US | Kansas | Johnson | 20091 | 75105 | 897 | 0 | 38.88548175 | -94.82250877 | 2021-10-02 04:21:25 | Johnson, Kansas, US | |
| 2021-09-28 | US | Pennsylvania | York | 42133 | 56589 | 897 | 0 | 39.9210089 | -76.73040131 | 2021-09-29 04:21:45 | York, Pennsylvania, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;