daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where deaths = 6680 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-18 | Japan | Osaka | 2231936 | 6680 | 0 | 34.620965 | 135.507481 | 2022-11-19 04:21:14 | Osaka, Japan | |||
2022-06-02 | Spain | Pais Vasco | 715479 | 6680 | 0 | 42.9896 | -2.6189 | 2022-06-03 04:20:58 | Pais Vasco, Spain | |||
2022-06-01 | Spain | Pais Vasco | 715479 | 6680 | 0 | 42.9896 | -2.6189 | 2022-06-02 05:20:39 | Pais Vasco, Spain | |||
2022-03-25 | US | Texas | Dallas | 48113 | 568151 | 6680 | 0 | 32.76670599 | -96.77796049999999 | 2022-03-26 04:20:23 | Dallas, Texas, US | |
2022-03-23 | Russia | Volgograd Oblast | 206467 | 6680 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-03-24 04:20:43 | Volgograd Oblast, Russia | |||
2022-03-22 | Ireland | 1397885 | 6680 | 0 | 53.1424 | -7.6921 | 2022-03-23 04:20:48 | Ireland | ||||
2021-11-07 | Peru | Ancash | 78013 | 6680 | 0 | -9.407125 | -77.67179499999997 | 2021-11-08 04:21:43 | Ancash, Peru | |||
2021-11-06 | Peru | Ancash | 78013 | 6680 | 0 | -9.407125 | -77.67179499999997 | 2021-11-07 04:21:53 | Ancash, Peru | |||
2021-11-05 | Peru | Ancash | 78013 | 6680 | 0 | -9.407125 | -77.67179499999997 | 2021-11-06 04:21:51 | Ancash, Peru | |||
2021-11-04 | Peru | Ancash | 78013 | 6680 | 0 | -9.407125 | -77.67179499999997 | 2021-11-05 04:21:54 | Ancash, Peru | |||
2021-10-22 | Mexico | Tamaulipas | 100715 | 6680 | 0 | 24.2669 | -98.8363 | 2021-10-23 04:21:32 | Tamaulipas, Mexico | |||
2021-07-24 | US | Texas | Harris | 48201 | 480449 | 6680 | 0 | 29.85864939 | -95.39339521 | 2021-07-25 04:22:12 | Harris, Texas, US | |
2021-01-30 | Tunisia | 207468 | 6680 | 156160 | 44628 | 33.886917 | 9.537499 | 2021-01-31 05:22:42 | Tunisia | |||
2020-09-08 | India | Karnataka | 412190 | 6680 | 308573 | 96937 | 14.70518 | 76.166436 | 2020-09-09 04:28:48 | Karnataka, India | ||
2020-08-23 | Indonesia | 153535 | 6680 | 107500 | 39355 | -0.7893 | 113.9213 | 2020-08-24 04:27:56 | Indonesia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;