daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
351 rows where deaths = 745 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-10-19 | US | Colorado | Weld | 8123 | 100133 | 745 | 0 | 40.55499405 | -104.3929621 | 2022-10-20 04:22:59 | Weld, Colorado, US | |
2022-10-18 | US | Pennsylvania | Franklin | 42055 | 47099 | 745 | 0 | 39.92956518 | -77.72157791 | 2022-10-19 04:22:26 | Franklin, Pennsylvania, US | |
2022-10-17 | US | Pennsylvania | Franklin | 42055 | 47099 | 745 | 0 | 39.92956518 | -77.72157791 | 2022-10-18 04:22:42 | Franklin, Pennsylvania, US | |
2022-10-16 | US | Pennsylvania | Franklin | 42055 | 47099 | 745 | 0 | 39.92956518 | -77.72157791 | 2022-10-17 04:20:31 | Franklin, Pennsylvania, US | |
2022-10-15 | US | Pennsylvania | Franklin | 42055 | 47099 | 745 | 0 | 39.92956518 | -77.72157791 | 2022-10-16 04:22:39 | Franklin, Pennsylvania, US | |
2022-10-14 | US | Pennsylvania | Franklin | 42055 | 47099 | 745 | 0 | 39.92956518 | -77.72157791 | 2022-10-15 04:22:00 | Franklin, Pennsylvania, US | |
2022-10-13 | US | Pennsylvania | Franklin | 42055 | 47099 | 745 | 0 | 39.92956518 | -77.72157791 | 2022-10-14 04:22:28 | Franklin, Pennsylvania, US | |
2022-10-12 | US | Pennsylvania | Franklin | 42055 | 47099 | 745 | 0 | 39.92956518 | -77.72157791 | 2022-10-13 04:22:39 | Franklin, Pennsylvania, US | |
2022-09-24 | Japan | Hiroshima | 423649 | 745 | 0 | 34.605309 | 132.788719 | 2022-09-25 04:23:31 | Hiroshima, Japan | |||
2022-08-12 | Australia | South Australia | 735513 | 745 | 0 | -34.9285 | 138.6007 | 2022-08-13 04:20:52 | South Australia, Australia | |||
2022-08-11 | Australia | South Australia | 735513 | 745 | 0 | -34.9285 | 138.6007 | 2022-08-12 04:20:54 | South Australia, Australia | |||
2022-08-02 | US | Tennessee | Sullivan | 47163 | 50261 | 745 | 0 | 36.51240691 | -82.30412917 | 2022-08-03 04:20:59 | Sullivan, Tennessee, US | |
2022-08-02 | US | Illinois | St. Clair | 17163 | 72056 | 745 | 0 | 38.46996033 | -89.93063427 | 2022-08-03 04:20:59 | St. Clair, Illinois, US | |
2022-08-01 | US | Illinois | St. Clair | 17163 | 71967 | 745 | 0 | 38.46996033 | -89.93063427 | 2022-08-02 04:20:53 | St. Clair, Illinois, US | |
2022-07-31 | US | Illinois | St. Clair | 17163 | 71766 | 745 | 0 | 38.46996033 | -89.93063427 | 2022-08-01 04:21:03 | St. Clair, Illinois, US | |
2022-07-30 | US | Illinois | St. Clair | 17163 | 71766 | 745 | 0 | 38.46996033 | -89.93063427 | 2022-07-31 04:21:02 | St. Clair, Illinois, US | |
2022-07-29 | US | Illinois | St. Clair | 17163 | 71766 | 745 | 0 | 38.46996033 | -89.93063427 | 2022-07-30 04:20:42 | St. Clair, Illinois, US | |
2022-07-28 | US | Illinois | St. Clair | 17163 | 71646 | 745 | 0 | 38.46996033 | -89.93063427 | 2022-07-29 04:20:45 | St. Clair, Illinois, US | |
2022-07-27 | US | Illinois | St. Clair | 17163 | 71494 | 745 | 0 | 38.46996033 | -89.93063427 | 2022-07-28 04:20:56 | St. Clair, Illinois, US | |
2022-07-26 | US | Indiana | Elkhart | 18039 | 56159 | 745 | 0 | 41.59761169 | -85.85875695 | 2022-07-27 04:21:04 | Elkhart, Indiana, US | |
2022-07-26 | US | Illinois | St. Clair | 17163 | 71457 | 745 | 0 | 38.46996033 | -89.93063427 | 2022-07-27 04:21:04 | St. Clair, Illinois, US | |
2022-07-25 | US | Texas | Johnson | 48251 | 46428 | 745 | 0 | 32.37877812 | -97.36615819 | 2022-07-26 04:20:58 | Johnson, Texas, US | |
2022-07-25 | US | Indiana | Elkhart | 18039 | 56159 | 745 | 0 | 41.59761169 | -85.85875695 | 2022-07-26 04:20:58 | Elkhart, Indiana, US | |
2022-07-25 | US | Illinois | St. Clair | 17163 | 71334 | 745 | 0 | 38.46996033 | -89.93063427 | 2022-07-26 04:20:58 | St. Clair, Illinois, US | |
2022-07-24 | US | Texas | Johnson | 48251 | 46372 | 745 | 0 | 32.37877812 | -97.36615819 | 2022-07-25 04:20:51 | Johnson, Texas, US | |
2022-07-24 | US | Indiana | Elkhart | 18039 | 56119 | 745 | 0 | 41.59761169 | -85.85875695 | 2022-07-25 04:20:51 | Elkhart, Indiana, US | |
2022-07-23 | US | Indiana | Elkhart | 18039 | 56119 | 745 | 0 | 41.59761169 | -85.85875695 | 2022-07-24 04:20:47 | Elkhart, Indiana, US | |
2022-07-22 | US | Indiana | Elkhart | 18039 | 56119 | 745 | 0 | 41.59761169 | -85.85875695 | 2022-07-23 04:20:53 | Elkhart, Indiana, US | |
2022-07-18 | US | Tennessee | Sumner | 47165 | 57316 | 745 | 0 | 36.46824103 | -86.45917204 | 2022-07-19 04:20:58 | Sumner, Tennessee, US | |
2022-07-17 | US | Texas | Potter | 48375 | 37363 | 745 | 0 | 35.40133773 | -101.893964 | 2022-07-18 04:20:59 | Potter, Texas, US | |
2022-07-17 | US | Tennessee | Sumner | 47165 | 57216 | 745 | 0 | 36.46824103 | -86.45917204 | 2022-07-18 04:20:59 | Sumner, Tennessee, US | |
2022-07-16 | US | Texas | Potter | 48375 | 37363 | 745 | 0 | 35.40133773 | -101.893964 | 2022-07-17 04:21:15 | Potter, Texas, US | |
2022-07-16 | US | Tennessee | Sumner | 47165 | 57192 | 745 | 0 | 36.46824103 | -86.45917204 | 2022-07-17 04:21:15 | Sumner, Tennessee, US | |
2022-07-15 | US | Texas | Potter | 48375 | 37363 | 745 | 0 | 35.40133773 | -101.893964 | 2022-07-16 04:21:05 | Potter, Texas, US | |
2022-07-15 | US | Tennessee | Sumner | 47165 | 57147 | 745 | 0 | 36.46824103 | -86.45917204 | 2022-07-16 04:21:05 | Sumner, Tennessee, US | |
2022-07-14 | US | Texas | Potter | 48375 | 37312 | 745 | 0 | 35.40133773 | -101.893964 | 2022-07-15 04:20:53 | Potter, Texas, US | |
2022-07-14 | US | Tennessee | Sumner | 47165 | 57043 | 745 | 0 | 36.46824103 | -86.45917204 | 2022-07-15 04:20:53 | Sumner, Tennessee, US | |
2022-07-14 | US | California | Monterey | 6053 | 106139 | 745 | 0 | 36.21862405 | -121.2413397 | 2022-07-15 04:20:53 | Monterey, California, US | |
2022-07-13 | US | Texas | Potter | 48375 | 37259 | 745 | 0 | 35.40133773 | -101.893964 | 2022-07-14 04:20:57 | Potter, Texas, US | |
2022-07-13 | US | Tennessee | Sumner | 47165 | 56967 | 745 | 0 | 36.46824103 | -86.45917204 | 2022-07-14 04:20:57 | Sumner, Tennessee, US | |
2022-07-13 | US | California | Monterey | 6053 | 105519 | 745 | 0 | 36.21862405 | -121.2413397 | 2022-07-14 04:20:57 | Monterey, California, US | |
2022-07-12 | US | Tennessee | Sumner | 47165 | 56882 | 745 | 0 | 36.46824103 | -86.45917204 | 2022-07-13 04:20:58 | Sumner, Tennessee, US | |
2022-07-12 | US | California | Monterey | 6053 | 105431 | 745 | 0 | 36.21862405 | -121.2413397 | 2022-07-13 04:20:58 | Monterey, California, US | |
2022-07-11 | US | California | Monterey | 6053 | 105362 | 745 | 0 | 36.21862405 | -121.2413397 | 2022-07-12 04:20:51 | Monterey, California, US | |
2022-07-10 | US | California | Monterey | 6053 | 104709 | 745 | 0 | 36.21862405 | -121.2413397 | 2022-07-11 04:20:46 | Monterey, California, US | |
2022-07-09 | US | California | Monterey | 6053 | 104659 | 745 | 0 | 36.21862405 | -121.2413397 | 2022-07-10 04:20:54 | Monterey, California, US | |
2022-07-08 | US | California | Monterey | 6053 | 104629 | 745 | 0 | 36.21862405 | -121.2413397 | 2022-07-09 04:20:59 | Monterey, California, US | |
2022-06-30 | US | Ohio | Lake | 39085 | 52065 | 745 | 0 | 41.69710807 | -81.23676539 | 2022-07-01 04:21:10 | Lake, Ohio, US | |
2022-06-29 | US | Ohio | Lake | 39085 | 51806 | 745 | 0 | 41.69710807 | -81.23676539 | 2022-06-30 04:21:01 | Lake, Ohio, US | |
2022-06-29 | Japan | Kyoto | 211936 | 745 | 0 | 35.253815 | 135.443341 | 2022-06-30 04:21:01 | Kyoto, Japan | |||
2022-06-28 | US | Ohio | Lake | 39085 | 51806 | 745 | 0 | 41.69710807 | -81.23676539 | 2022-06-29 04:20:59 | Lake, Ohio, US | |
2022-06-27 | US | Ohio | Lake | 39085 | 51806 | 745 | 0 | 41.69710807 | -81.23676539 | 2022-06-28 04:20:58 | Lake, Ohio, US | |
2022-06-26 | US | Ohio | Lake | 39085 | 51806 | 745 | 0 | 41.69710807 | -81.23676539 | 2022-06-27 04:21:00 | Lake, Ohio, US | |
2022-06-25 | US | Ohio | Lake | 39085 | 51806 | 745 | 0 | 41.69710807 | -81.23676539 | 2022-06-26 04:21:02 | Lake, Ohio, US | |
2022-06-24 | US | Ohio | Lake | 39085 | 51806 | 745 | 0 | 41.69710807 | -81.23676539 | 2022-06-25 04:20:57 | Lake, Ohio, US | |
2022-06-23 | US | Ohio | Lake | 39085 | 51806 | 745 | 0 | 41.69710807 | -81.23676539 | 2022-06-24 04:20:58 | Lake, Ohio, US | |
2022-06-22 | US | Ohio | Lake | 39085 | 51559 | 745 | 0 | 41.69710807 | -81.23676539 | 2022-06-23 04:20:55 | Lake, Ohio, US | |
2022-06-21 | US | Ohio | Lake | 39085 | 51559 | 745 | 0 | 41.69710807 | -81.23676539 | 2022-06-22 04:20:54 | Lake, Ohio, US | |
2022-06-20 | US | Ohio | Lake | 39085 | 51559 | 745 | 0 | 41.69710807 | -81.23676539 | 2022-06-21 04:20:56 | Lake, Ohio, US | |
2022-05-17 | US | Pennsylvania | Beaver | 42007 | 40744 | 745 | 0 | 40.6825484 | -80.34921611 | 2022-05-18 04:20:50 | Beaver, Pennsylvania, US | |
2022-05-16 | US | Pennsylvania | Beaver | 42007 | 40744 | 745 | 0 | 40.6825484 | -80.34921611 | 2022-05-17 04:20:59 | Beaver, Pennsylvania, US | |
2022-05-15 | US | Pennsylvania | Beaver | 42007 | 40744 | 745 | 0 | 40.6825484 | -80.34921611 | 2022-05-16 04:20:47 | Beaver, Pennsylvania, US | |
2022-05-14 | US | Pennsylvania | Beaver | 42007 | 40744 | 745 | 0 | 40.6825484 | -80.34921611 | 2022-05-15 04:20:53 | Beaver, Pennsylvania, US | |
2022-05-13 | US | Pennsylvania | Beaver | 42007 | 40744 | 745 | 0 | 40.6825484 | -80.34921611 | 2022-05-14 04:20:48 | Beaver, Pennsylvania, US | |
2022-05-12 | US | Pennsylvania | Beaver | 42007 | 40744 | 745 | 0 | 40.6825484 | -80.34921611 | 2022-05-13 04:20:51 | Beaver, Pennsylvania, US | |
2022-05-11 | US | Pennsylvania | Beaver | 42007 | 40744 | 745 | 0 | 40.6825484 | -80.34921611 | 2022-05-12 04:20:54 | Beaver, Pennsylvania, US | |
2022-05-03 | Laos | 207867 | 745 | 0 | 19.85627 | 102.495496 | 2022-05-04 04:20:59 | Laos | ||||
2022-04-27 | US | Virginia | Prince William | 51153 | 96094 | 745 | 0 | 38.70916224 | -77.48713689 | 2022-04-28 04:20:47 | Prince William, Virginia, US | |
2022-04-27 | US | New Mexico | San Juan | 35045 | 40786 | 745 | 0 | 36.50838318 | -108.320437 | 2022-04-28 04:20:47 | San Juan, New Mexico, US | |
2022-04-26 | US | New Mexico | San Juan | 35045 | 40786 | 745 | 0 | 36.50838318 | -108.32043700000001 | 2022-04-27 04:20:52 | San Juan, New Mexico, US | |
2022-04-25 | US | New Mexico | San Juan | 35045 | 40786 | 745 | 0 | 36.50838318 | -108.32043700000001 | 2022-04-26 04:20:51 | San Juan, New Mexico, US | |
2022-04-24 | US | New Mexico | San Juan | 35045 | 40777 | 745 | 0 | 36.50838318 | -108.32043700000001 | 2022-04-25 04:20:56 | San Juan, New Mexico, US | |
2022-04-23 | US | New Mexico | San Juan | 35045 | 40777 | 745 | 0 | 36.50838318 | -108.32043700000001 | 2022-04-24 04:20:56 | San Juan, New Mexico, US | |
2022-04-22 | US | New Mexico | San Juan | 35045 | 40777 | 745 | 0 | 36.50838318 | -108.32043700000001 | 2022-04-23 04:20:50 | San Juan, New Mexico, US | |
2022-04-21 | US | New Mexico | San Juan | 35045 | 40771 | 745 | 0 | 36.50838318 | -108.32043700000001 | 2022-04-22 04:20:45 | San Juan, New Mexico, US | |
2022-04-18 | US | Louisiana | Ouachita | 22073 | 50582 | 745 | 0 | 32.47645559 | -92.15704172 | 2022-04-19 04:21:00 | Ouachita, Louisiana, US | |
2022-04-17 | US | Louisiana | Ouachita | 22073 | 50574 | 745 | 0 | 32.47645559 | -92.15704172 | 2022-04-18 04:21:12 | Ouachita, Louisiana, US | |
2022-04-16 | US | Louisiana | Ouachita | 22073 | 50574 | 745 | 0 | 32.47645559 | -92.15704172 | 2022-04-17 04:20:59 | Ouachita, Louisiana, US | |
2022-04-15 | US | Louisiana | Ouachita | 22073 | 50574 | 745 | 0 | 32.47645559 | -92.15704172 | 2022-04-16 04:20:48 | Ouachita, Louisiana, US | |
2022-04-14 | US | Louisiana | Ouachita | 22073 | 50574 | 745 | 0 | 32.47645559 | -92.15704172 | 2022-04-15 04:20:57 | Ouachita, Louisiana, US | |
2022-04-11 | US | New Mexico | Dona Ana | 35013 | 63010 | 745 | 0 | 32.35275771 | -106.83293870000001 | 2022-04-12 04:20:49 | Dona Ana, New Mexico, US | |
2022-04-07 | US | California | San Mateo | 6081 | 128514 | 745 | 0 | 37.422880799999994 | -122.32755459999998 | 2022-04-08 04:20:48 | San Mateo, California, US | |
2022-04-06 | US | California | San Mateo | 6081 | 128029 | 745 | 0 | 37.422880799999994 | -122.32755459999998 | 2022-04-07 04:20:53 | San Mateo, California, US | |
2022-04-05 | US | California | San Mateo | 6081 | 128018 | 745 | 0 | 37.422880799999994 | -122.32755459999998 | 2022-04-06 04:20:49 | San Mateo, California, US | |
2022-04-04 | US | California | San Mateo | 6081 | 128004 | 745 | 0 | 37.422880799999994 | -122.32755459999998 | 2022-04-05 04:20:48 | San Mateo, California, US | |
2022-04-03 | US | California | San Mateo | 6081 | 127673 | 745 | 0 | 37.422880799999994 | -122.32755459999998 | 2022-04-04 04:20:51 | San Mateo, California, US | |
2022-04-02 | US | California | San Mateo | 6081 | 127664 | 745 | 0 | 37.422880799999994 | -122.32755459999998 | 2022-04-03 04:20:48 | San Mateo, California, US | |
2022-04-01 | US | California | San Mateo | 6081 | 127658 | 745 | 0 | 37.422880799999994 | -122.32755459999998 | 2022-04-02 04:20:47 | San Mateo, California, US | |
2022-03-25 | Russia | Amur Oblast | 103039 | 745 | 0 | 52.8032368 | 128.437295 | 2022-03-26 04:20:23 | Amur Oblast, Russia | |||
2022-03-24 | Russia | Amur Oblast | 102844 | 745 | 0 | 52.8032368 | 128.437295 | 2022-03-25 04:20:46 | Amur Oblast, Russia | |||
2022-03-23 | US | Pennsylvania | Erie | 42049 | 56890 | 745 | 0 | 41.99253829 | -80.03301954 | 2022-03-24 04:20:43 | Erie, Pennsylvania, US | |
2022-03-22 | US | Pennsylvania | Erie | 42049 | 56875 | 745 | 0 | 41.99253829 | -80.03301954 | 2022-03-23 04:20:48 | Erie, Pennsylvania, US | |
2022-03-21 | US | Pennsylvania | Erie | 42049 | 56865 | 745 | 0 | 41.99253829 | -80.03301954 | 2022-03-22 04:20:54 | Erie, Pennsylvania, US | |
2022-03-20 | US | Pennsylvania | Erie | 42049 | 56856 | 745 | 0 | 41.99253829 | -80.03301954 | 2022-03-21 04:20:50 | Erie, Pennsylvania, US | |
2022-03-19 | US | Pennsylvania | Lackawanna | 42069 | 43195 | 745 | 0 | 41.43564672 | -75.60379201 | 2022-03-20 04:20:45 | Lackawanna, Pennsylvania, US | |
2022-03-19 | US | Pennsylvania | Erie | 42049 | 56854 | 745 | 0 | 41.99253829 | -80.03301954 | 2022-03-20 04:20:45 | Erie, Pennsylvania, US | |
2022-03-18 | US | Pennsylvania | Lackawanna | 42069 | 43183 | 745 | 0 | 41.43564672 | -75.60379201 | 2022-03-19 04:20:47 | Lackawanna, Pennsylvania, US | |
2022-03-18 | US | Pennsylvania | Erie | 42049 | 56842 | 745 | 0 | 41.99253829 | -80.03301954 | 2022-03-19 04:20:47 | Erie, Pennsylvania, US | |
2022-03-17 | US | Pennsylvania | Erie | 42049 | 56825 | 745 | 0 | 41.99253829 | -80.03301954 | 2022-03-18 04:20:55 | Erie, Pennsylvania, US | |
2022-03-15 | US | Michigan | Ingham | 26065 | 63429 | 745 | 0 | 42.59716886 | -84.37472069 | 2022-03-16 04:20:50 | Ingham, Michigan, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;