daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where confirmed = 27438 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-08-03 | US | New York | Putnam | 36079 | 27438 | 127 | 0 | 41.42630093 | -73.74965532 | 2022-08-04 04:20:58 | Putnam, New York, US | |
2022-05-17 | US | Wisconsin | Walworth | 55127 | 27438 | 282 | 0 | 42.66858202 | -88.54163073 | 2022-05-18 04:20:50 | Walworth, Wisconsin, US | |
2022-05-15 | US | Alabama | Marshall | 1095 | 27438 | 394 | 0 | 34.36975964 | -86.30486727 | 2022-05-16 04:20:47 | Marshall, Alabama, US | |
2022-05-14 | US | Alabama | Marshall | 1095 | 27438 | 394 | 0 | 34.36975964 | -86.30486727 | 2022-05-15 04:20:53 | Marshall, Alabama, US | |
2022-05-13 | US | Alabama | Marshall | 1095 | 27438 | 394 | 0 | 34.36975964 | -86.30486727 | 2022-05-14 04:20:48 | Marshall, Alabama, US | |
2022-03-26 | Japan | Wakayama | 27438 | 108 | 0 | 33.911879 | 135.505446 | 2022-03-27 04:20:47 | Wakayama, Japan | |||
2022-01-09 | US | Texas | Kaufman | 48257 | 27438 | 456 | 0 | 32.599141700000004 | -96.28734728 | 2022-01-10 04:22:07 | Kaufman, Texas, US | |
2022-01-03 | US | Alabama | Lee | 1081 | 27438 | 269 | 0 | 32.60154883 | -85.35132246 | 2022-01-04 04:22:17 | Lee, Alabama, US | |
2021-10-05 | Chile | Atacama | 27438 | 354 | 0 | -27.5661 | -70.0503 | 2021-10-06 04:21:33 | Atacama, Chile | |||
2021-05-24 | US | Georgia | Hall | 13139 | 27438 | 475 | 0 | 34.32207823 | -83.81896936 | 2021-05-25 04:21:08 | Hall, Georgia, US | |
2021-04-05 | US | New Jersey | Gloucester | 34015 | 27438 | 582 | 0 | 39.71581067 | -75.13995546 | 2021-04-06 04:20:32 | Gloucester, New Jersey, US | |
2021-03-15 | US | Alaska | Anchorage | 2020 | 27438 | 163 | 0 | 61.14998174 | -149.14269860000005 | 2021-03-16 05:25:13 | Anchorage, Alaska, US | |
2021-02-20 | Canada | Saskatchewan | 27438 | 368 | 25468 | 1602 | 52.9399 | -106.4509 | 2021-02-21 05:24:33 | Saskatchewan, Canada | ||
2020-12-28 | Germany | Sachsen-Anhalt | 27438 | 515 | 20466 | 7035 | 51.9503 | 11.6923 | 2020-12-29 05:22:37 | Sachsen-Anhalt, Germany | ||
2020-11-11 | US | Kentucky | Jefferson | 21111 | 27438 | 400 | 0 | 27038 | 38.18664655 | -85.65931031 | 2020-11-12 05:25:55 | Jefferson, Kentucky, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;