daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
664 rows where deaths = 718 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 | Idaho | Canyon | 16027 | 69107 | 718 | 0 | 43.61970148 | -116.7095499 | 2022-12-28 04:21:04 | Canyon, Idaho, US | |
2022-12-26 | US | Missouri | Jefferson | 29099 | 65853 | 718 | 0 | 38.25926778 | -90.53870896 | 2022-12-27 04:21:07 | Jefferson, Missouri, US | |
2022-12-26 | US | Idaho | Canyon | 16027 | 69107 | 718 | 0 | 43.61970148 | -116.7095499 | 2022-12-27 04:21:07 | Canyon, Idaho, US | |
2022-12-25 | US | Missouri | Jefferson | 29099 | 65853 | 718 | 0 | 38.25926778 | -90.53870896 | 2022-12-26 04:21:06 | Jefferson, Missouri, US | |
2022-12-25 | US | Idaho | Canyon | 16027 | 69107 | 718 | 0 | 43.61970148 | -116.7095499 | 2022-12-26 04:21:06 | Canyon, Idaho, US | |
2022-12-24 | US | Missouri | Jefferson | 29099 | 65853 | 718 | 0 | 38.25926778 | -90.53870896 | 2022-12-25 04:21:04 | Jefferson, Missouri, US | |
2022-12-24 | US | Idaho | Canyon | 16027 | 69107 | 718 | 0 | 43.61970148 | -116.7095499 | 2022-12-25 04:21:04 | Canyon, Idaho, US | |
2022-12-23 | US | Missouri | Jefferson | 29099 | 65853 | 718 | 0 | 38.25926778 | -90.53870896 | 2022-12-24 04:21:02 | Jefferson, Missouri, US | |
2022-12-23 | US | Idaho | Canyon | 16027 | 69107 | 718 | 0 | 43.61970148 | -116.7095499 | 2022-12-24 04:21:02 | Canyon, Idaho, US | |
2022-12-22 | US | Missouri | Jefferson | 29099 | 65853 | 718 | 0 | 38.25926778 | -90.53870896 | 2022-12-23 04:21:04 | Jefferson, Missouri, US | |
2022-12-22 | US | Idaho | Canyon | 16027 | 69107 | 718 | 0 | 43.61970148 | -116.7095499 | 2022-12-23 04:21:04 | Canyon, Idaho, US | |
2022-12-21 | US | Missouri | Jefferson | 29099 | 65853 | 718 | 0 | 38.25926778 | -90.53870896 | 2022-12-22 04:20:56 | Jefferson, Missouri, US | |
2022-12-21 | US | Idaho | Canyon | 16027 | 69107 | 718 | 0 | 43.61970148 | -116.7095499 | 2022-12-22 04:20:56 | Canyon, Idaho, US | |
2022-12-20 | US | Missouri | Jefferson | 29099 | 65853 | 718 | 0 | 38.25926778 | -90.53870896 | 2022-12-21 04:21:03 | Jefferson, Missouri, US | |
2022-12-09 | Japan | Gifu | 382940 | 718 | 0 | 35.778671 | 137.055925 | 2022-12-10 04:21:02 | Gifu, Japan | |||
2022-11-14 | US | Florida | Martin | 12085 | 38339 | 718 | 0 | 27.0772071 | -80.43109784 | 2022-11-15 04:21:16 | Martin, Florida, US | |
2022-11-13 | US | Florida | Martin | 12085 | 38339 | 718 | 0 | 27.0772071 | -80.43109784 | 2022-11-14 04:21:09 | Martin, Florida, US | |
2022-11-12 | US | Florida | Martin | 12085 | 38339 | 718 | 0 | 27.0772071 | -80.43109784 | 2022-11-13 04:21:14 | Martin, Florida, US | |
2022-11-11 | US | Florida | Martin | 12085 | 38339 | 718 | 0 | 27.0772071 | -80.43109784 | 2022-11-12 04:20:41 | Martin, Florida, US | |
2022-11-10 | US | Florida | Martin | 12085 | 38339 | 718 | 0 | 27.0772071 | -80.43109784 | 2022-11-11 04:21:22 | Martin, Florida, US | |
2022-11-09 | US | Florida | Martin | 12085 | 38339 | 718 | 0 | 27.0772071 | -80.43109784 | 2022-11-10 04:21:16 | Martin, Florida, US | |
2022-11-08 | US | Florida | Martin | 12085 | 38339 | 718 | 0 | 27.0772071 | -80.43109784 | 2022-11-09 04:21:22 | Martin, Florida, US | |
2022-11-07 | US | Florida | Martin | 12085 | 38339 | 718 | 0 | 27.0772071 | -80.43109784 | 2022-11-08 04:21:21 | Martin, Florida, US | |
2022-11-06 | US | Florida | Martin | 12085 | 38339 | 718 | 0 | 27.0772071 | -80.43109784 | 2022-11-07 04:21:26 | Martin, Florida, US | |
2022-11-05 | US | Florida | Martin | 12085 | 38339 | 718 | 0 | 27.0772071 | -80.43109784 | 2022-11-06 04:21:24 | Martin, Florida, US | |
2022-11-04 | US | Florida | Martin | 12085 | 38339 | 718 | 0 | 27.0772071 | -80.43109784 | 2022-11-05 04:21:52 | Martin, Florida, US | |
2022-11-03 | US | Florida | Martin | 12085 | 38187 | 718 | 0 | 27.0772071 | -80.43109784 | 2022-11-04 04:22:11 | Martin, Florida, US | |
2022-11-02 | US | Florida | Martin | 12085 | 38187 | 718 | 0 | 27.0772071 | -80.43109784 | 2022-11-03 04:22:05 | Martin, Florida, US | |
2022-11-01 | US | Pennsylvania | Schuylkill | 42107 | 39703 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-11-02 04:22:09 | Schuylkill, Pennsylvania, US | |
2022-11-01 | US | Florida | Martin | 12085 | 38187 | 718 | 0 | 27.0772071 | -80.43109784 | 2022-11-02 04:22:09 | Martin, Florida, US | |
2022-10-31 | US | Pennsylvania | Schuylkill | 42107 | 39703 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-11-01 04:22:36 | Schuylkill, Pennsylvania, US | |
2022-10-31 | US | Florida | Martin | 12085 | 38187 | 718 | 0 | 27.0772071 | -80.43109784 | 2022-11-01 04:22:36 | Martin, Florida, US | |
2022-10-30 | US | Pennsylvania | Schuylkill | 42107 | 39703 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-31 04:21:36 | Schuylkill, Pennsylvania, US | |
2022-10-30 | US | Florida | Martin | 12085 | 38187 | 718 | 0 | 27.0772071 | -80.43109784 | 2022-10-31 04:21:36 | Martin, Florida, US | |
2022-10-29 | US | Pennsylvania | Schuylkill | 42107 | 39703 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-30 04:22:14 | Schuylkill, Pennsylvania, US | |
2022-10-29 | US | Florida | Martin | 12085 | 38187 | 718 | 0 | 27.0772071 | -80.43109784 | 2022-10-30 04:22:14 | Martin, Florida, US | |
2022-10-28 | US | Pennsylvania | Schuylkill | 42107 | 39703 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-29 04:21:13 | Schuylkill, Pennsylvania, US | |
2022-10-28 | US | Florida | Martin | 12085 | 38187 | 718 | 0 | 27.0772071 | -80.43109784 | 2022-10-29 04:21:13 | Martin, Florida, US | |
2022-10-27 | US | Pennsylvania | Schuylkill | 42107 | 39703 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-28 04:22:31 | Schuylkill, Pennsylvania, US | |
2022-10-27 | US | Florida | Martin | 12085 | 38187 | 718 | 0 | 27.0772071 | -80.43109784 | 2022-10-28 04:22:31 | Martin, Florida, US | |
2022-10-26 | US | Pennsylvania | Schuylkill | 42107 | 39703 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-27 04:22:01 | Schuylkill, Pennsylvania, US | |
2022-10-26 | US | Florida | Martin | 12085 | 38187 | 718 | 0 | 27.0772071 | -80.43109784 | 2022-10-27 04:22:01 | Martin, Florida, US | |
2022-10-26 | Sweden | Uppsala | 93609 | 718 | 0 | 60.0092 | 17.2715 | 2022-10-27 04:22:01 | Uppsala, Sweden | |||
2022-10-25 | US | Pennsylvania | Schuylkill | 42107 | 39524 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-26 04:22:19 | Schuylkill, Pennsylvania, US | |
2022-10-25 | Sweden | Uppsala | 93609 | 718 | 0 | 60.0092 | 17.2715 | 2022-10-26 04:22:19 | Uppsala, Sweden | |||
2022-10-24 | US | Pennsylvania | Schuylkill | 42107 | 39524 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-25 04:21:53 | Schuylkill, Pennsylvania, US | |
2022-10-24 | Sweden | Uppsala | 93609 | 718 | 0 | 60.0092 | 17.2715 | 2022-10-25 04:21:53 | Uppsala, Sweden | |||
2022-10-23 | US | Pennsylvania | Schuylkill | 42107 | 39524 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-24 04:22:29 | Schuylkill, Pennsylvania, US | |
2022-10-23 | Sweden | Uppsala | 93609 | 718 | 0 | 60.0092 | 17.2715 | 2022-10-24 04:22:29 | Uppsala, Sweden | |||
2022-10-22 | US | Pennsylvania | Schuylkill | 42107 | 39524 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-23 04:22:46 | Schuylkill, Pennsylvania, US | |
2022-10-22 | Sweden | Uppsala | 93609 | 718 | 0 | 60.0092 | 17.2715 | 2022-10-23 04:22:46 | Uppsala, Sweden | |||
2022-10-21 | US | Pennsylvania | Schuylkill | 42107 | 39524 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-22 04:22:53 | Schuylkill, Pennsylvania, US | |
2022-10-21 | Sweden | Uppsala | 93609 | 718 | 0 | 60.0092 | 17.2715 | 2022-10-22 04:22:53 | Uppsala, Sweden | |||
2022-10-20 | US | Pennsylvania | Schuylkill | 42107 | 39524 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-21 04:22:23 | Schuylkill, Pennsylvania, US | |
2022-10-20 | Sweden | Uppsala | 93609 | 718 | 0 | 60.0092 | 17.2715 | 2022-10-21 04:22:23 | Uppsala, Sweden | |||
2022-10-19 | US | Pennsylvania | Schuylkill | 42107 | 39524 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-20 04:22:59 | Schuylkill, Pennsylvania, US | |
2022-10-18 | US | Pennsylvania | Schuylkill | 42107 | 39370 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-19 04:22:26 | Schuylkill, Pennsylvania, US | |
2022-10-17 | US | Pennsylvania | Schuylkill | 42107 | 39370 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-18 04:22:42 | Schuylkill, Pennsylvania, US | |
2022-10-16 | US | Pennsylvania | Schuylkill | 42107 | 39370 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-17 04:20:31 | Schuylkill, Pennsylvania, US | |
2022-10-15 | US | Pennsylvania | Schuylkill | 42107 | 39370 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-16 04:22:39 | Schuylkill, Pennsylvania, US | |
2022-10-14 | US | Pennsylvania | Schuylkill | 42107 | 39370 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-15 04:22:00 | Schuylkill, Pennsylvania, US | |
2022-10-13 | US | Pennsylvania | Schuylkill | 42107 | 39370 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-14 04:22:28 | Schuylkill, Pennsylvania, US | |
2022-10-12 | US | Wisconsin | Racine | 55101 | 66271 | 718 | 0 | 42.74753117 | -88.05941254 | 2022-10-13 04:22:39 | Racine, Wisconsin, US | |
2022-10-12 | US | Pennsylvania | Schuylkill | 42107 | 39370 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-13 04:22:39 | Schuylkill, Pennsylvania, US | |
2022-10-11 | US | Wisconsin | Racine | 55101 | 66217 | 718 | 0 | 42.74753117 | -88.05941254 | 2022-10-12 04:22:51 | Racine, Wisconsin, US | |
2022-10-11 | US | Pennsylvania | Schuylkill | 42107 | 39199 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-12 04:22:51 | Schuylkill, Pennsylvania, US | |
2022-10-10 | US | Wisconsin | Racine | 55101 | 66182 | 718 | 0 | 42.74753117 | -88.05941254 | 2022-10-11 04:23:05 | Racine, Wisconsin, US | |
2022-10-10 | US | Pennsylvania | Schuylkill | 42107 | 39199 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-11 04:23:05 | Schuylkill, Pennsylvania, US | |
2022-10-09 | US | Wisconsin | Racine | 55101 | 66087 | 718 | 0 | 42.74753117 | -88.05941254 | 2022-10-10 04:22:32 | Racine, Wisconsin, US | |
2022-10-09 | US | Pennsylvania | Schuylkill | 42107 | 39199 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-10 04:22:32 | Schuylkill, Pennsylvania, US | |
2022-10-08 | US | Wisconsin | Racine | 55101 | 66087 | 718 | 0 | 42.74753117 | -88.05941254 | 2022-10-09 04:21:16 | Racine, Wisconsin, US | |
2022-10-08 | US | Pennsylvania | Schuylkill | 42107 | 39199 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-09 04:21:16 | Schuylkill, Pennsylvania, US | |
2022-10-07 | US | Wisconsin | Racine | 55101 | 66087 | 718 | 0 | 42.74753117 | -88.05941254 | 2022-10-08 04:22:56 | Racine, Wisconsin, US | |
2022-10-07 | US | Pennsylvania | Schuylkill | 42107 | 39199 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-08 04:22:56 | Schuylkill, Pennsylvania, US | |
2022-10-06 | US | Pennsylvania | Schuylkill | 42107 | 39199 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-07 04:23:08 | Schuylkill, Pennsylvania, US | |
2022-10-05 | US | Pennsylvania | Schuylkill | 42107 | 39199 | 718 | 0 | 40.70497338 | -76.2150785 | 2022-10-06 04:21:22 | Schuylkill, Pennsylvania, US | |
2022-09-30 | Japan | Okinawa | 500201 | 718 | 0 | 25.768923 | 126.668016 | 2022-10-01 04:23:01 | Okinawa, Japan | |||
2022-09-26 | US | Connecticut | New London | 9011 | 67583 | 718 | 0 | 41.48896435 | -72.10430976 | 2022-09-27 04:23:01 | New London, Connecticut, US | |
2022-09-25 | US | Texas | Ector | 48135 | 41497 | 718 | 0 | 31.86898877 | -102.5429428 | 2022-09-26 04:20:52 | Ector, Texas, US | |
2022-09-25 | US | Connecticut | New London | 9011 | 67558 | 718 | 0 | 41.48896435 | -72.10430976 | 2022-09-26 04:20:52 | New London, Connecticut, US | |
2022-09-24 | US | Texas | Ector | 48135 | 41497 | 718 | 0 | 31.86898877 | -102.5429428 | 2022-09-25 04:23:31 | Ector, Texas, US | |
2022-09-24 | US | Connecticut | New London | 9011 | 67517 | 718 | 0 | 41.48896435 | -72.10430976 | 2022-09-25 04:23:31 | New London, Connecticut, US | |
2022-09-23 | US | Texas | Ector | 48135 | 41497 | 718 | 0 | 31.86898877 | -102.5429428 | 2022-09-24 04:21:40 | Ector, Texas, US | |
2022-09-23 | US | Connecticut | New London | 9011 | 67479 | 718 | 0 | 41.48896435 | -72.10430976 | 2022-09-24 04:21:40 | New London, Connecticut, US | |
2022-09-22 | US | Connecticut | New London | 9011 | 67388 | 718 | 0 | 41.48896435 | -72.10430976 | 2022-09-23 04:23:13 | New London, Connecticut, US | |
2022-09-21 | US | Connecticut | New London | 9011 | 67274 | 718 | 0 | 41.48896435 | -72.10430976 | 2022-09-22 04:22:56 | New London, Connecticut, US | |
2022-09-21 | US | California | Santa Barbara | 6083 | 112102 | 718 | 0 | 34.65329488 | -120.0188492 | 2022-09-22 04:22:56 | Santa Barbara, California, US | |
2022-09-20 | US | California | Santa Barbara | 6083 | 112097 | 718 | 0 | 34.65329488 | -120.0188492 | 2022-09-21 04:23:22 | Santa Barbara, California, US | |
2022-09-19 | US | California | Santa Barbara | 6083 | 111817 | 718 | 0 | 34.65329488 | -120.0188492 | 2022-09-20 04:22:48 | Santa Barbara, California, US | |
2022-09-18 | US | California | Santa Barbara | 6083 | 111813 | 718 | 0 | 34.65329488 | -120.0188492 | 2022-09-19 04:21:49 | Santa Barbara, California, US | |
2022-09-17 | US | California | Santa Barbara | 6083 | 111811 | 718 | 0 | 34.65329488 | -120.0188492 | 2022-09-18 04:22:50 | Santa Barbara, California, US | |
2022-09-16 | US | California | Santa Barbara | 6083 | 111809 | 718 | 0 | 34.65329488 | -120.0188492 | 2022-09-17 04:20:19 | Santa Barbara, California, US | |
2022-09-15 | US | California | Santa Barbara | 6083 | 111800 | 718 | 0 | 34.65329488 | -120.0188492 | 2022-09-16 04:21:19 | Santa Barbara, California, US | |
2022-09-06 | US | Oregon | Clackamas | 41005 | 76753 | 718 | 0 | 45.18787398 | -122.2179634 | 2022-09-07 04:20:59 | Clackamas, Oregon, US | |
2022-09-05 | US | Oregon | Clackamas | 41005 | 76620 | 718 | 0 | 45.18787398 | -122.2179634 | 2022-09-06 04:21:02 | Clackamas, Oregon, US | |
2022-09-04 | US | Oregon | Clackamas | 41005 | 76620 | 718 | 0 | 45.18787398 | -122.2179634 | 2022-09-05 04:21:01 | Clackamas, Oregon, US | |
2022-09-03 | US | Oregon | Clackamas | 41005 | 76620 | 718 | 0 | 45.18787398 | -122.2179634 | 2022-09-04 04:21:22 | Clackamas, Oregon, US | |
2022-09-02 | US | Oregon | Clackamas | 41005 | 76620 | 718 | 0 | 45.18787398 | -122.2179634 | 2022-09-03 04:21:04 | Clackamas, Oregon, US | |
2022-09-01 | US | Oregon | Clackamas | 41005 | 76522 | 718 | 0 | 45.18787398 | -122.2179634 | 2022-09-02 04:21:07 | Clackamas, Oregon, US | |
2022-08-31 | US | Oregon | Clackamas | 41005 | 76490 | 718 | 0 | 45.18787398 | -122.2179634 | 2022-09-01 04:21:03 | Clackamas, Oregon, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;