daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
27 rows where deaths = 4970 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 8
- Peru 15
- Mexico 3
- Russia 3
- Italy 2
- Azerbaijan 1
- Colombia 1
- Germany 1
- United Kingdom 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-11-22 | United Kingdom | Northern Ireland | 713294 | 4970 | 0 | 54.7877 | -6.4923 | 2022-11-23 04:21:06 | Northern Ireland, United Kingdom | |||
2022-11-07 | Germany | Berlin | 1337815 | 4970 | 0 | 52.52 | 13.405 | 2022-11-08 04:21:21 | Berlin, Germany | |||
2022-04-19 | Italy | Friuli Venezia Giulia | 352221 | 4970 | 0 | 45.6494354 | 13.76813649 | 2022-04-20 04:20:45 | Friuli Venezia Giulia, Italy | |||
2022-02-20 | Peru | Cusco | 112497 | 4970 | 0 | -13.191068 | -72.153609 | 2022-02-21 04:21:05 | Cusco, Peru | |||
2022-02-19 | Peru | Cusco | 112497 | 4970 | 0 | -13.191068 | -72.153609 | 2022-02-20 04:21:00 | Cusco, Peru | |||
2022-02-18 | Peru | Cusco | 112497 | 4970 | 0 | -13.191068 | -72.153609 | 2022-02-19 04:21:11 | Cusco, Peru | |||
2022-02-17 | Peru | Cusco | 112497 | 4970 | 0 | -13.191068 | -72.153609 | 2022-02-18 04:21:04 | Cusco, Peru | |||
2022-02-16 | Peru | Cusco | 112497 | 4970 | 0 | -13.191068 | -72.153609 | 2022-02-17 04:20:56 | Cusco, Peru | |||
2022-02-16 | Colombia | Norte de Santander | 117973 | 4970 | 0 | 7.9463 | -72.8988 | 2022-02-17 04:20:56 | Norte de Santander, Colombia | |||
2022-02-15 | Peru | Cusco | 112497 | 4970 | 0 | -13.191068 | -72.153609 | 2022-02-16 04:21:10 | Cusco, Peru | |||
2022-02-14 | Peru | Cusco | 112497 | 4970 | 0 | -13.191068 | -72.153609 | 2022-02-15 04:21:09 | Cusco, Peru | |||
2022-02-13 | Peru | Cusco | 112497 | 4970 | 0 | -13.191068 | -72.153609 | 2022-02-14 04:20:51 | Cusco, Peru | |||
2022-02-12 | Peru | Cusco | 112497 | 4970 | 0 | -13.191068 | -72.153609 | 2022-02-13 04:21:00 | Cusco, Peru | |||
2022-02-11 | Peru | Cusco | 112497 | 4970 | 0 | -13.191068 | -72.153609 | 2022-02-12 04:21:06 | Cusco, Peru | |||
2022-02-10 | Peru | Cusco | 112497 | 4970 | 0 | -13.191068 | -72.153609 | 2022-02-11 04:21:09 | Cusco, Peru | |||
2022-02-09 | Peru | Cusco | 112497 | 4970 | 0 | -13.191068 | -72.153609 | 2022-02-10 04:21:14 | Cusco, Peru | |||
2022-02-08 | Peru | Cusco | 112497 | 4970 | 0 | -13.191068 | -72.153609 | 2022-02-09 04:21:04 | Cusco, Peru | |||
2022-02-07 | Peru | Cusco | 112497 | 4970 | 0 | -13.191068 | -72.153609 | 2022-02-08 04:21:15 | Cusco, Peru | |||
2021-12-24 | Russia | Saratov Oblast | 130923 | 4970 | 0 | 51.652055499999996 | 46.86319520000001 | 2021-12-25 04:21:37 | Saratov Oblast, Russia | |||
2021-11-02 | Russia | Voronezh Oblast | 155836 | 4970 | 0 | 50.9800393 | 40.15065070000001 | 2021-11-03 06:22:09 | Voronezh Oblast, Russia | |||
2021-08-24 | Russia | Sverdlovsk Oblast | 119913 | 4970 | 0 | 58.6414755 | 61.802154599999994 | 2021-08-25 04:21:41 | Sverdlovsk Oblast, Russia | |||
2021-06-28 | Azerbaijan | 335874 | 4970 | 330123 | 781 | 40.1431 | 47.5769 | 2021-06-29 04:21:28 | Azerbaijan | |||
2021-05-26 | Mexico | Tamaulipas | 59087 | 4970 | 0 | 54117 | 24.2669 | -98.8363 | 2021-05-27 04:20:59 | Tamaulipas, Mexico | ||
2021-03-23 | Mexico | Michoacan | 44642 | 4970 | 0 | 39672 | 19.5665 | -101.7068 | 2021-03-24 05:25:40 | Michoacan, Mexico | ||
2021-03-16 | Italy | Toscana | 175335 | 4970 | 145470 | 24895 | 43.76923077 | 11.25588885 | 2021-03-17 05:25:07 | Toscana, Italy | ||
2021-01-31 | Peru | Lambayeque | 35543 | 4970 | 0 | 30573 | -6.353049 | -79.824113 | 2021-02-01 05:22:53 | Lambayeque, Peru | ||
2020-11-16 | Mexico | Puebla | 37676 | 4970 | 0 | 32706 | 19.0414 | -98.2063 | 2020-11-17 05:25:54 | Puebla, Mexico |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;