daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where confirmed = 33734 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-11-22 | Chile | Aysen | 33734 | 207 | 0 | -45.9864 | -73.7669 | 2022-11-23 04:21:06 | Aysen, Chile | |||
2022-11-08 | US | Pennsylvania | Blair | 42013 | 33734 | 661 | 0 | 40.47961444 | -78.34917412 | 2022-11-09 04:21:22 | Blair, Pennsylvania, US | |
2022-11-07 | US | Pennsylvania | Blair | 42013 | 33734 | 661 | 0 | 40.47961444 | -78.34917412 | 2022-11-08 04:21:21 | Blair, Pennsylvania, US | |
2022-11-06 | US | Pennsylvania | Blair | 42013 | 33734 | 661 | 0 | 40.47961444 | -78.34917412 | 2022-11-07 04:21:26 | Blair, Pennsylvania, US | |
2022-11-05 | US | Pennsylvania | Blair | 42013 | 33734 | 661 | 0 | 40.47961444 | -78.34917412 | 2022-11-06 04:21:24 | Blair, Pennsylvania, US | |
2022-11-04 | US | Pennsylvania | Blair | 42013 | 33734 | 661 | 0 | 40.47961444 | -78.34917412 | 2022-11-05 04:21:52 | Blair, Pennsylvania, US | |
2022-11-03 | US | Pennsylvania | Blair | 42013 | 33734 | 661 | 0 | 40.47961444 | -78.34917412 | 2022-11-04 04:22:11 | Blair, Pennsylvania, US | |
2022-11-02 | US | Pennsylvania | Blair | 42013 | 33734 | 661 | 0 | 40.47961444 | -78.34917412 | 2022-11-03 04:22:05 | Blair, Pennsylvania, US | |
2022-06-15 | Japan | Yamanashi | 33734 | 68 | 0 | 35.612364 | 138.611489 | 2022-06-16 04:20:55 | Yamanashi, Japan | |||
2022-03-09 | US | Georgia | Whitfield | 13313 | 33734 | 413 | 0 | 34.80987459 | -84.96093476 | 2022-03-10 04:20:48 | Whitfield, Georgia, US | |
2021-07-27 | Colombia | Casanare | 33734 | 844 | 31992 | 898 | 5.7589 | -71.5724 | 2021-07-28 04:21:39 | Casanare, Colombia | ||
2021-03-22 | US | Kentucky | Fayette | 21067 | 33734 | 262 | 0 | 38.0368225 | -84.45576892 | 2021-03-23 05:26:18 | Fayette, Kentucky, US | |
2021-02-09 | US | New York | Orange | 36071 | 33734 | 690 | 0 | 33044 | 41.40337468 | -74.30240757 | 2021-02-10 05:22:41 | Orange, New York, US |
2020-11-10 | Russia | Rostov Oblast | 33734 | 976 | 26937 | 5821 | 47.6222451 | 40.7957942 | 2020-11-11 05:25:30 | Rostov Oblast, Russia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;