daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where confirmed = 41686 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-07-26 | US | Arizona | Navajo | 4017 | 41686 | 917 | 0 | 35.3997715 | -110.3218983 | 2022-07-27 04:21:04 | Navajo, Arizona, US | |
2022-07-25 | US | Arizona | Navajo | 4017 | 41686 | 917 | 0 | 35.3997715 | -110.3218983 | 2022-07-26 04:20:58 | Navajo, Arizona, US | |
2022-07-24 | US | Arizona | Navajo | 4017 | 41686 | 917 | 0 | 35.3997715 | -110.3218983 | 2022-07-25 04:20:51 | Navajo, Arizona, US | |
2022-07-23 | US | Arizona | Navajo | 4017 | 41686 | 917 | 0 | 35.3997715 | -110.3218983 | 2022-07-24 04:20:47 | Navajo, Arizona, US | |
2022-07-22 | US | Arizona | Navajo | 4017 | 41686 | 917 | 0 | 35.3997715 | -110.3218983 | 2022-07-23 04:20:53 | Navajo, Arizona, US | |
2022-07-21 | US | Arizona | Navajo | 4017 | 41686 | 917 | 0 | 35.3997715 | -110.3218983 | 2022-07-22 04:21:15 | Navajo, Arizona, US | |
2022-07-20 | US | Arizona | Navajo | 4017 | 41686 | 917 | 0 | 35.3997715 | -110.3218983 | 2022-07-21 04:21:10 | Navajo, Arizona, US | |
2022-06-08 | US | New Mexico | San Juan | 35045 | 41686 | 780 | 0 | 36.50838318 | -108.320437 | 2022-06-09 04:20:54 | San Juan, New Mexico, US | |
2022-04-27 | US | Ohio | Trumbull | 39155 | 41686 | 944 | 0 | 41.31735028 | -80.76109643 | 2022-04-28 04:20:47 | Trumbull, Ohio, US | |
2022-04-26 | US | Ohio | Trumbull | 39155 | 41686 | 944 | 0 | 41.31735028 | -80.76109643 | 2022-04-27 04:20:52 | Trumbull, Ohio, US | |
2022-04-25 | US | Ohio | Trumbull | 39155 | 41686 | 943 | 0 | 41.31735028 | -80.76109643 | 2022-04-26 04:20:51 | Trumbull, Ohio, US | |
2022-04-24 | US | Ohio | Trumbull | 39155 | 41686 | 943 | 0 | 41.31735028 | -80.76109643 | 2022-04-25 04:20:56 | Trumbull, Ohio, US | |
2022-04-24 | Colombia | Casanare | 41686 | 1002 | 0 | 5.7589 | -71.5724 | 2022-04-25 04:20:56 | Casanare, Colombia | |||
2022-04-23 | US | Ohio | Trumbull | 39155 | 41686 | 943 | 0 | 41.31735028 | -80.76109643 | 2022-04-24 04:20:56 | Trumbull, Ohio, US | |
2022-04-22 | US | Ohio | Trumbull | 39155 | 41686 | 942 | 0 | 41.31735028 | -80.76109643 | 2022-04-23 04:20:50 | Trumbull, Ohio, US | |
2022-04-21 | US | Ohio | Trumbull | 39155 | 41686 | 941 | 0 | 41.31735028 | -80.76109643 | 2022-04-22 04:20:45 | Trumbull, Ohio, US | |
2021-07-06 | Russia | Kursk Oblast | 41686 | 959 | 39845 | 882 | 51.6568453 | 36.4852695 | 2021-07-07 04:21:20 | Kursk Oblast, Russia | ||
2021-05-17 | Japan | Saitama | 41686 | 766 | 38102 | 2818 | 35.997101 | 139.347635 | 2021-05-18 04:20:33 | Saitama, Japan | ||
2021-05-08 | Russia | Novosibirsk Oblast | 41686 | 1784 | 38059 | 1843 | 54.9720169 | 79.48139240000002 | 2021-05-09 04:20:35 | Novosibirsk Oblast, Russia | ||
2021-05-03 | US | Washington | Spokane | 53063 | 41686 | 625 | 0 | 47.62113146 | -117.4046494 | 2021-05-04 04:20:34 | Spokane, Washington, US | |
2020-10-10 | Libya | 41686 | 623 | 23791 | 17272 | 26.3351 | 17.228331 | 2020-10-11 04:23:46 | Libya |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;