daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16 rows where confirmed = 30703 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-12-06 | US | Alabama | Houston | 1069 | 30703 | 526 | 0 | 31.15197924 | -85.29939599 | 2022-12-07 04:20:58 | Houston, Alabama, US | |
2022-12-05 | US | Alabama | Houston | 1069 | 30703 | 526 | 0 | 31.15197924 | -85.29939599 | 2022-12-06 04:21:03 | Houston, Alabama, US | |
2022-12-04 | US | Alabama | Houston | 1069 | 30703 | 526 | 0 | 31.15197924 | -85.29939599 | 2022-12-05 04:20:58 | Houston, Alabama, US | |
2022-12-03 | US | Alabama | Houston | 1069 | 30703 | 526 | 0 | 31.15197924 | -85.29939599 | 2022-12-04 04:20:56 | Houston, Alabama, US | |
2022-12-02 | US | Alabama | Houston | 1069 | 30703 | 526 | 0 | 31.15197924 | -85.29939599 | 2022-12-03 04:21:02 | Houston, Alabama, US | |
2022-12-01 | US | Alabama | Houston | 1069 | 30703 | 526 | 0 | 31.15197924 | -85.29939599 | 2022-12-02 04:21:07 | Houston, Alabama, US | |
2022-11-30 | US | Alabama | Houston | 1069 | 30703 | 526 | 0 | 31.15197924 | -85.29939599 | 2022-12-01 04:21:03 | Houston, Alabama, US | |
2022-05-24 | US | Tennessee | Sevier | 47155 | 30703 | 422 | 0 | 35.78077323 | -83.52244332 | 2022-05-25 04:20:56 | Sevier, Tennessee, US | |
2022-04-30 | Haiti | 30703 | 835 | 0 | 18.9712 | -72.2852 | 2022-05-01 04:20:57 | Haiti | ||||
2022-02-24 | US | New York | Rensselaer | 36083 | 30703 | 243 | 0 | 42.71348136 | -73.51089874 | 2022-02-25 04:21:11 | Rensselaer, New York, US | |
2021-09-19 | US | Mississippi | Hinds | 28049 | 30703 | 575 | 0 | 32.2656285 | -90.44435448 | 2021-09-20 04:21:22 | Hinds, Mississippi, US | |
2021-09-18 | US | Mississippi | Hinds | 28049 | 30703 | 575 | 0 | 32.2656285 | -90.44435448 | 2021-09-19 04:21:34 | Hinds, Mississippi, US | |
2021-09-17 | US | Mississippi | Hinds | 28049 | 30703 | 575 | 0 | 32.2656285 | -90.44435448 | 2021-09-18 04:21:24 | Hinds, Mississippi, US | |
2021-09-15 | US | Texas | Hays | 48209 | 30703 | 345 | 0 | 30.05669873 | -98.02944344 | 2021-09-16 04:22:19 | Hays, Texas, US | |
2021-09-13 | Russia | Kabardino-Balkarian Republic | 30703 | 747 | 0 | 43.480604799999995 | 43.5978976 | 2021-09-14 04:21:41 | Kabardino-Balkarian Republic, Russia | |||
2021-01-11 | Russia | Karelia Republic | 30703 | 186 | 24974 | 5543 | 62.61940309999999 | 33.4920267 | 2021-01-12 05:22:15 | Karelia Republic, Russia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;