daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
12 rows where confirmed = 40807 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 3
- US 9
- Russia 2
- United Kingdom 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-11-26 | US | New York | Ulster | 36111 | 40807 | 394 | 0 | 41.89027881 | -74.26252104 | 2022-11-27 04:21:05 | Ulster, New York, US | |
2022-03-14 | United Kingdom | Jersey | 40807 | 116 | 0 | 49.2138 | -2.1358 | 2022-03-15 04:20:47 | Jersey, United Kingdom | |||
2022-02-14 | US | Virginia | Norfolk | 51710 | 40807 | 427 | 0 | 36.89934014 | -76.26420872 | 2022-02-15 04:21:09 | Norfolk, Virginia, US | |
2022-01-07 | Russia | Mordovia Republic | 40807 | 1051 | 0 | 54.4419829 | 44.466114399999995 | 2022-01-08 04:21:53 | Mordovia Republic, Russia | |||
2021-11-04 | US | Illinois | Madison | 17119 | 40807 | 607 | 0 | 38.83042506 | -89.90422563 | 2021-11-05 04:21:54 | Madison, Illinois, US | |
2021-10-03 | US | Arizona | Yuma | 4027 | 40807 | 905 | 0 | 32.76895712 | -113.90666740000002 | 2021-10-04 04:21:31 | Yuma, Arizona, US | |
2021-09-04 | US | Missouri | Greene | 29077 | 40807 | 622 | 0 | 37.2575872 | -93.34230916 | 2021-09-05 04:21:33 | Greene, Missouri, US | |
2021-08-22 | US | North Carolina | Forsyth | 37067 | 40807 | 439 | 0 | 36.12859861 | -80.25459052 | 2021-08-23 04:21:27 | Forsyth, North Carolina, US | |
2021-08-21 | US | North Carolina | Forsyth | 37067 | 40807 | 439 | 0 | 36.12859861 | -80.25459052 | 2021-08-22 04:21:29 | Forsyth, North Carolina, US | |
2021-08-20 | US | North Carolina | Forsyth | 37067 | 40807 | 439 | 0 | 36.12859861 | -80.25459052 | 2021-08-21 04:21:38 | Forsyth, North Carolina, US | |
2021-08-17 | US | New York | Onondaga | 36067 | 40807 | 681 | 0 | 43.00491923 | -76.19971155 | 2021-08-18 04:21:35 | Onondaga, New York, US | |
2021-05-13 | Russia | Tver Oblast | 40807 | 953 | 38555 | 1299 | 57.1134475 | 35.174442799999994 | 2021-05-14 04:20:41 | Tver Oblast, Russia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;