daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

19 rows where country_or_region = "Spain" and last_update = "2021-08-20 04:21:33" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: day (date)

country_or_region 1

  • Spain · 19 ✖
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2021-08-19 Spain Andalusia     767675 10492 0   37.5443 -4.7278 2021-08-20 04:21:33 Andalusia, Spain
2021-08-19 Spain Aragon     154937 3674 0   41.5976 -0.9057 2021-08-20 04:21:33 Aragon, Spain
2021-08-19 Spain Asturias     69503 2042 0   43.3614 -5.8593 2021-08-20 04:21:33 Asturias, Spain
2021-08-19 Spain Baleares     93193 893 0   39.710358 2.995148 2021-08-20 04:21:33 Baleares, Spain
2021-08-19 Spain C. Valenciana     492399 7573 0   39.484 -0.7533 2021-08-20 04:21:33 C. Valenciana, Spain
2021-08-19 Spain Canarias     89566 899 0   28.2916 -16.6291 2021-08-20 04:21:33 Canarias, Spain
2021-08-19 Spain Cantabria     43244 588 0   43.1828 -3.9878 2021-08-20 04:21:33 Cantabria, Spain
2021-08-19 Spain Castilla - La Mancha     225429 6060 0   39.2796 -3.0977 2021-08-20 04:21:33 Castilla - La Mancha, Spain
2021-08-19 Spain Castilla y Leon     290284 7092 0   41.8357 -4.3976 2021-08-20 04:21:33 Castilla y Leon, Spain
2021-08-19 Spain Catalonia     878858 15012 0   41.5912 1.5209 2021-08-20 04:21:33 Catalonia, Spain
2021-08-19 Spain Ceuta     6938 121 0   35.8894 -5.3213 2021-08-20 04:21:33 Ceuta, Spain
2021-08-19 Spain Extremadura     96115 1854 0   39.4937 -6.0679 2021-08-20 04:21:33 Extremadura, Spain
2021-08-19 Spain Galicia     176326 2516 0   42.5751 -8.1339 2021-08-20 04:21:33 Galicia, Spain
2021-08-19 Spain La Rioja     38173 812 0   42.2871 -2.5396 2021-08-20 04:21:33 La Rioja, Spain
2021-08-19 Spain Madrid     862201 15746 0   40.4168 -3.7038 2021-08-20 04:21:33 Madrid, Spain
2021-08-19 Spain Melilla     10239 99 0   35.2923 -2.9381 2021-08-20 04:21:33 Melilla, Spain
2021-08-19 Spain Murcia     134629 1656 0   37.9922 -1.1307 2021-08-20 04:21:33 Murcia, Spain
2021-08-19 Spain Navarra     80227 1204 0   42.6954 -1.6761 2021-08-20 04:21:33 Navarra, Spain
2021-08-19 Spain Pais Vasco     248067 4671 0   42.9896 -2.6189 2021-08-20 04:21:33 Pais Vasco, Spain

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;