daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
255 rows where deaths = 866 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-12-27 | US | Pennsylvania | Erie | 42049 | 70030 | 866 | 0 | 41.99253829 | -80.03301954 | 2022-12-28 04:21:04 | Erie, Pennsylvania, US | |
2022-12-26 | US | Pennsylvania | Erie | 42049 | 70030 | 866 | 0 | 41.99253829 | -80.03301954 | 2022-12-27 04:21:07 | Erie, Pennsylvania, US | |
2022-12-25 | US | Pennsylvania | Erie | 42049 | 70030 | 866 | 0 | 41.99253829 | -80.03301954 | 2022-12-26 04:21:06 | Erie, Pennsylvania, US | |
2022-12-24 | US | Pennsylvania | Erie | 42049 | 70030 | 866 | 0 | 41.99253829 | -80.03301954 | 2022-12-25 04:21:04 | Erie, Pennsylvania, US | |
2022-12-23 | US | Pennsylvania | Erie | 42049 | 70030 | 866 | 0 | 41.99253829 | -80.03301954 | 2022-12-24 04:21:02 | Erie, Pennsylvania, US | |
2022-12-22 | US | Pennsylvania | Erie | 42049 | 70030 | 866 | 0 | 41.99253829 | -80.03301954 | 2022-12-23 04:21:04 | Erie, Pennsylvania, US | |
2022-12-21 | US | Utah | Utah | 49049 | 223276 | 866 | 0 | 40.1166722 | -111.6657662 | 2022-12-22 04:20:56 | Utah, Utah, US | |
2022-12-21 | US | Pennsylvania | Erie | 42049 | 70030 | 866 | 0 | 41.99253829 | -80.03301954 | 2022-12-22 04:20:56 | Erie, Pennsylvania, US | |
2022-12-20 | US | Utah | Utah | 49049 | 223276 | 866 | 0 | 40.1166722 | -111.6657662 | 2022-12-21 04:21:03 | Utah, Utah, US | |
2022-12-20 | US | Pennsylvania | Erie | 42049 | 69712 | 866 | 0 | 41.99253829 | -80.03301954 | 2022-12-21 04:21:03 | Erie, Pennsylvania, US | |
2022-12-19 | US | Utah | Utah | 49049 | 223276 | 866 | 0 | 40.1166722 | -111.6657662 | 2022-12-20 04:21:04 | Utah, Utah, US | |
2022-12-19 | US | Pennsylvania | Erie | 42049 | 69712 | 866 | 0 | 41.99253829 | -80.03301954 | 2022-12-20 04:21:04 | Erie, Pennsylvania, US | |
2022-12-18 | US | Utah | Utah | 49049 | 223276 | 866 | 0 | 40.1166722 | -111.6657662 | 2022-12-19 04:21:03 | Utah, Utah, US | |
2022-12-18 | US | Pennsylvania | Erie | 42049 | 69712 | 866 | 0 | 41.99253829 | -80.03301954 | 2022-12-19 04:21:03 | Erie, Pennsylvania, US | |
2022-12-17 | US | Utah | Utah | 49049 | 223276 | 866 | 0 | 40.1166722 | -111.6657662 | 2022-12-18 04:21:03 | Utah, Utah, US | |
2022-12-17 | US | Pennsylvania | Erie | 42049 | 69712 | 866 | 0 | 41.99253829 | -80.03301954 | 2022-12-18 04:21:03 | Erie, Pennsylvania, US | |
2022-12-16 | US | Utah | Utah | 49049 | 223276 | 866 | 0 | 40.1166722 | -111.6657662 | 2022-12-17 04:21:04 | Utah, Utah, US | |
2022-12-16 | US | Pennsylvania | Erie | 42049 | 69712 | 866 | 0 | 41.99253829 | -80.03301954 | 2022-12-17 04:21:04 | Erie, Pennsylvania, US | |
2022-12-15 | US | Utah | Utah | 49049 | 223276 | 866 | 0 | 40.1166722 | -111.6657662 | 2022-12-16 04:21:01 | Utah, Utah, US | |
2022-12-15 | US | Pennsylvania | Erie | 42049 | 69712 | 866 | 0 | 41.99253829 | -80.03301954 | 2022-12-16 04:21:01 | Erie, Pennsylvania, US | |
2022-12-14 | US | Pennsylvania | Erie | 42049 | 69712 | 866 | 0 | 41.99253829 | -80.03301954 | 2022-12-15 04:20:58 | Erie, Pennsylvania, US | |
2022-11-03 | Germany | Bremen | 278007 | 866 | 0 | 53.0793 | 8.8017 | 2022-11-04 04:22:11 | Bremen, Germany | |||
2022-11-02 | Germany | Bremen | 277296 | 866 | 0 | 53.0793 | 8.8017 | 2022-11-03 04:22:05 | Bremen, Germany | |||
2022-10-09 | US | Texas | Jefferson | 48245 | 60401 | 866 | 0 | 29.8832777 | -94.16434171 | 2022-10-10 04:22:32 | Jefferson, Texas, US | |
2022-10-08 | US | Texas | Jefferson | 48245 | 60401 | 866 | 0 | 29.8832777 | -94.16434171 | 2022-10-09 04:21:16 | Jefferson, Texas, US | |
2022-10-07 | US | Texas | Jefferson | 48245 | 60401 | 866 | 0 | 29.8832777 | -94.16434171 | 2022-10-08 04:22:56 | Jefferson, Texas, US | |
2022-10-06 | US | Texas | Jefferson | 48245 | 60380 | 866 | 0 | 29.8832777 | -94.16434171 | 2022-10-07 04:23:08 | Jefferson, Texas, US | |
2022-10-06 | US | Illinois | Winnebago | 17201 | 92745 | 866 | 0 | 42.33641854 | -89.16085327 | 2022-10-07 04:23:08 | Winnebago, Illinois, US | |
2022-10-05 | US | Texas | Jefferson | 48245 | 60380 | 866 | 0 | 29.8832777 | -94.16434171 | 2022-10-06 04:21:22 | Jefferson, Texas, US | |
2022-10-05 | US | Illinois | Winnebago | 17201 | 92667 | 866 | 0 | 42.33641854 | -89.16085327 | 2022-10-06 04:21:22 | Winnebago, Illinois, US | |
2022-10-04 | US | Illinois | Winnebago | 17201 | 92617 | 866 | 0 | 42.33641854 | -89.16085327 | 2022-10-05 04:23:06 | Winnebago, Illinois, US | |
2022-10-03 | US | Illinois | Winnebago | 17201 | 92596 | 866 | 0 | 42.33641854 | -89.16085327 | 2022-10-04 04:22:55 | Winnebago, Illinois, US | |
2022-08-17 | US | New Mexico | Dona Ana | 35013 | 71366 | 866 | 0 | 32.35275771 | -106.8329387 | 2022-08-18 04:21:11 | Dona Ana, New Mexico, US | |
2022-08-01 | US | Texas | Galveston | 48167 | 109397 | 866 | 0 | 29.40167322 | -94.90469073 | 2022-08-02 04:20:53 | Galveston, Texas, US | |
2022-07-31 | US | Texas | Galveston | 48167 | 108978 | 866 | 0 | 29.40167322 | -94.90469073 | 2022-08-01 04:21:03 | Galveston, Texas, US | |
2022-07-31 | US | Louisiana | St. Tammany | 22103 | 81088 | 866 | 0 | 30.40942847 | -89.95642711 | 2022-08-01 04:21:03 | St. Tammany, Louisiana, US | |
2022-07-30 | US | Texas | Galveston | 48167 | 108978 | 866 | 0 | 29.40167322 | -94.90469073 | 2022-07-31 04:21:02 | Galveston, Texas, US | |
2022-07-30 | US | Louisiana | St. Tammany | 22103 | 81088 | 866 | 0 | 30.40942847 | -89.95642711 | 2022-07-31 04:21:02 | St. Tammany, Louisiana, US | |
2022-07-29 | US | Texas | Galveston | 48167 | 108978 | 866 | 0 | 29.40167322 | -94.90469073 | 2022-07-30 04:20:42 | Galveston, Texas, US | |
2022-07-29 | US | Louisiana | St. Tammany | 22103 | 81088 | 866 | 0 | 30.40942847 | -89.95642711 | 2022-07-30 04:20:42 | St. Tammany, Louisiana, US | |
2022-07-26 | US | Washington | Clark | 53011 | 101102 | 866 | 0 | 45.77568046 | -122.4829204 | 2022-07-27 04:21:04 | Clark, Washington, US | |
2022-07-26 | US | Louisiana | St. Tammany | 22103 | 80597 | 866 | 0 | 30.40942847 | -89.95642711 | 2022-07-27 04:21:04 | St. Tammany, Louisiana, US | |
2022-07-25 | US | Washington | Clark | 53011 | 101102 | 866 | 0 | 45.77568046 | -122.4829204 | 2022-07-26 04:20:58 | Clark, Washington, US | |
2022-07-25 | US | Louisiana | St. Tammany | 22103 | 80597 | 866 | 0 | 30.40942847 | -89.95642711 | 2022-07-26 04:20:58 | St. Tammany, Louisiana, US | |
2022-07-24 | US | Louisiana | St. Tammany | 22103 | 80340 | 866 | 0 | 30.40942847 | -89.95642711 | 2022-07-25 04:20:51 | St. Tammany, Louisiana, US | |
2022-07-23 | US | Louisiana | St. Tammany | 22103 | 80340 | 866 | 0 | 30.40942847 | -89.95642711 | 2022-07-24 04:20:47 | St. Tammany, Louisiana, US | |
2022-07-22 | US | Louisiana | St. Tammany | 22103 | 80340 | 866 | 0 | 30.40942847 | -89.95642711 | 2022-07-23 04:20:53 | St. Tammany, Louisiana, US | |
2022-07-12 | US | North Carolina | Gaston | 37071 | 69489 | 866 | 0 | 35.29373559 | -81.17477045 | 2022-07-13 04:20:58 | Gaston, North Carolina, US | |
2022-07-11 | US | North Carolina | Gaston | 37071 | 69489 | 866 | 0 | 35.29373559 | -81.17477045 | 2022-07-12 04:20:51 | Gaston, North Carolina, US | |
2022-07-10 | US | North Carolina | Gaston | 37071 | 69489 | 866 | 0 | 35.29373559 | -81.17477045 | 2022-07-11 04:20:46 | Gaston, North Carolina, US | |
2022-07-10 | Fiji | 66126 | 866 | 0 | -17.7134 | 178.065 | 2022-07-11 04:20:46 | Fiji | ||||
2022-07-09 | US | North Carolina | Gaston | 37071 | 69489 | 866 | 0 | 35.29373559 | -81.17477045 | 2022-07-10 04:20:54 | Gaston, North Carolina, US | |
2022-07-09 | Fiji | 66126 | 866 | 0 | -17.7134 | 178.065 | 2022-07-10 04:20:54 | Fiji | ||||
2022-07-08 | US | North Carolina | Gaston | 37071 | 69489 | 866 | 0 | 35.29373559 | -81.17477045 | 2022-07-09 04:20:59 | Gaston, North Carolina, US | |
2022-07-08 | Fiji | 66126 | 866 | 0 | -17.7134 | 178.065 | 2022-07-09 04:20:59 | Fiji | ||||
2022-07-07 | US | North Carolina | Gaston | 37071 | 69489 | 866 | 0 | 35.29373559 | -81.17477045 | 2022-07-08 04:20:56 | Gaston, North Carolina, US | |
2022-07-07 | Fiji | 66126 | 866 | 0 | -17.7134 | 178.065 | 2022-07-08 04:20:56 | Fiji | ||||
2022-07-06 | US | North Carolina | Gaston | 37071 | 69489 | 866 | 0 | 35.29373559 | -81.17477045 | 2022-07-07 04:20:55 | Gaston, North Carolina, US | |
2022-07-06 | Fiji | 65889 | 866 | 0 | -17.7134 | 178.065 | 2022-07-07 04:20:55 | Fiji | ||||
2022-07-05 | Fiji | 65889 | 866 | 0 | -17.7134 | 178.065 | 2022-07-06 04:20:58 | Fiji | ||||
2022-07-04 | Fiji | 65889 | 866 | 0 | -17.7134 | 178.065 | 2022-07-05 04:20:45 | Fiji | ||||
2022-07-03 | Fiji | 65713 | 866 | 0 | -17.7134 | 178.065 | 2022-07-04 04:20:54 | Fiji | ||||
2022-07-02 | Fiji | 65713 | 866 | 0 | -17.7134 | 178.065 | 2022-07-03 04:20:59 | Fiji | ||||
2022-07-01 | Fiji | 65713 | 866 | 0 | -17.7134 | 178.065 | 2022-07-02 04:21:16 | Fiji | ||||
2022-06-30 | Fiji | 65713 | 866 | 0 | -17.7134 | 178.065 | 2022-07-01 04:21:10 | Fiji | ||||
2022-06-18 | US | Arkansas | Benton | 5007 | 68419 | 866 | 0 | 36.33644656 | -94.25680817 | 2022-06-19 04:20:51 | Benton, Arkansas, US | |
2022-06-17 | US | Arkansas | Benton | 5007 | 68378 | 866 | 0 | 36.33644656 | -94.25680817 | 2022-06-18 04:21:10 | Benton, Arkansas, US | |
2022-06-16 | US | Arkansas | Benton | 5007 | 68337 | 866 | 0 | 36.33644656 | -94.25680817 | 2022-06-17 04:20:56 | Benton, Arkansas, US | |
2022-05-30 | Malaysia | Terengganu | 126220 | 866 | 0 | 5.3117 | 103.1324 | 2022-05-31 04:20:51 | Terengganu, Malaysia | |||
2022-05-29 | Malaysia | Terengganu | 126209 | 866 | 0 | 5.3117 | 103.1324 | 2022-05-30 04:20:50 | Terengganu, Malaysia | |||
2022-05-28 | Malaysia | Terengganu | 126205 | 866 | 0 | 5.3117 | 103.1324 | 2022-05-29 04:20:53 | Terengganu, Malaysia | |||
2022-05-27 | Malaysia | Terengganu | 126199 | 866 | 0 | 5.3117 | 103.1324 | 2022-05-28 04:21:07 | Terengganu, Malaysia | |||
2022-05-26 | Malaysia | Terengganu | 126189 | 866 | 0 | 5.3117 | 103.1324 | 2022-05-27 04:20:56 | Terengganu, Malaysia | |||
2022-05-25 | Malaysia | Terengganu | 126178 | 866 | 0 | 5.3117 | 103.1324 | 2022-05-26 04:20:50 | Terengganu, Malaysia | |||
2022-05-24 | Malaysia | Terengganu | 126164 | 866 | 0 | 5.3117 | 103.1324 | 2022-05-25 04:20:56 | Terengganu, Malaysia | |||
2022-05-23 | Malaysia | Terengganu | 126151 | 866 | 0 | 5.3117 | 103.1324 | 2022-05-24 04:20:57 | Terengganu, Malaysia | |||
2022-05-22 | Malaysia | Terengganu | 126178 | 866 | 0 | 5.3117 | 103.1324 | 2022-05-26 04:20:50 | Terengganu, Malaysia | |||
2022-05-21 | Malaysia | Terengganu | 126126 | 866 | 0 | 5.3117 | 103.1324 | 2022-05-22 04:20:52 | Terengganu, Malaysia | |||
2022-05-20 | Malaysia | Terengganu | 126114 | 866 | 0 | 5.3117 | 103.1324 | 2022-05-21 04:20:58 | Terengganu, Malaysia | |||
2022-05-19 | Malaysia | Terengganu | 126102 | 866 | 0 | 5.3117 | 103.1324 | 2022-05-20 04:20:57 | Terengganu, Malaysia | |||
2022-05-18 | Malaysia | Terengganu | 126091 | 866 | 0 | 5.3117 | 103.1324 | 2022-05-19 04:20:54 | Terengganu, Malaysia | |||
2022-05-17 | Malaysia | Terengganu | 126072 | 866 | 0 | 5.3117 | 103.1324 | 2022-05-18 04:20:50 | Terengganu, Malaysia | |||
2022-05-16 | US | California | San Francisco | 6075 | 146499 | 866 | 0 | 37.75215114 | -122.4385672 | 2022-05-17 04:20:59 | San Francisco, California, US | |
2022-05-16 | Malaysia | Terengganu | 126059 | 866 | 0 | 5.3117 | 103.1324 | 2022-05-17 04:20:59 | Terengganu, Malaysia | |||
2022-05-15 | US | California | San Francisco | 6075 | 144040 | 866 | 0 | 37.75215114 | -122.4385672 | 2022-05-16 04:20:47 | San Francisco, California, US | |
2022-05-15 | Malaysia | Terengganu | 126039 | 866 | 0 | 5.3117 | 103.1324 | 2022-05-16 04:20:47 | Terengganu, Malaysia | |||
2022-05-14 | US | California | San Francisco | 6075 | 144016 | 866 | 0 | 37.75215114 | -122.4385672 | 2022-05-15 04:20:53 | San Francisco, California, US | |
2022-05-14 | Malaysia | Terengganu | 126022 | 866 | 0 | 5.3117 | 103.1324 | 2022-05-15 04:20:53 | Terengganu, Malaysia | |||
2022-05-13 | US | California | San Francisco | 6075 | 143996 | 866 | 0 | 37.75215114 | -122.4385672 | 2022-05-14 04:20:48 | San Francisco, California, US | |
2022-05-02 | US | South Carolina | Lexington | 45063 | 95940 | 866 | 0 | 33.89665987 | -81.27146426 | 2022-05-03 04:21:00 | Lexington, South Carolina, US | |
2022-05-01 | US | South Carolina | Lexington | 45063 | 95940 | 866 | 0 | 33.89665987 | -81.27146426 | 2022-05-02 04:21:10 | Lexington, South Carolina, US | |
2022-04-30 | US | South Carolina | Lexington | 45063 | 95940 | 866 | 0 | 33.89665987 | -81.27146426 | 2022-05-01 04:20:57 | Lexington, South Carolina, US | |
2022-04-29 | US | South Carolina | Lexington | 45063 | 95940 | 866 | 0 | 33.89665987 | -81.27146426 | 2022-04-30 04:21:05 | Lexington, South Carolina, US | |
2022-04-28 | US | South Carolina | Lexington | 45063 | 95940 | 866 | 0 | 33.89665987 | -81.27146426 | 2022-04-29 04:20:59 | Lexington, South Carolina, US | |
2022-04-05 | US | Indiana | St. Joseph | 18141 | 70568 | 866 | 0 | 41.61756781 | -86.29040834 | 2022-04-06 04:20:49 | St. Joseph, Indiana, US | |
2022-04-04 | US | Indiana | St. Joseph | 18141 | 70568 | 866 | 0 | 41.61756781 | -86.29040834 | 2022-04-05 04:20:48 | St. Joseph, Indiana, US | |
2022-03-24 | US | Georgia | Richmond | 13245 | 49906 | 866 | 0 | 33.35777107 | -82.07026432 | 2022-03-25 04:20:46 | Richmond, Georgia, US | |
2022-03-14 | US | Texas | Williamson | 48491 | 131898 | 866 | 0 | 30.64655664 | -97.60048540000001 | 2022-03-15 04:20:47 | Williamson, Texas, US | |
2022-03-13 | US | Texas | Williamson | 48491 | 131836 | 866 | 0 | 30.64655664 | -97.60048540000001 | 2022-03-14 04:20:46 | Williamson, Texas, US | |
2022-03-12 | US | Texas | Williamson | 48491 | 131836 | 866 | 0 | 30.64655664 | -97.60048540000001 | 2022-03-13 04:20:49 | Williamson, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;