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

17 rows where deaths = 6568 sorted by day descending

✎ View and edit SQL

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

These facets timed out: province_or_state

country_or_region 7

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2022-11-02 Finland       1348737 6568 0   61.92411 25.748151 2022-11-03 04:22:05 Finland
2022-11-01 Finland       1348737 6568 0   61.92411 25.748151 2022-11-02 04:22:09 Finland
2022-10-31 Finland       1348737 6568 0   61.92411 25.748151 2022-11-01 04:22:36 Finland
2022-10-30 Finland       1348737 6568 0   61.92411 25.748151 2022-10-31 04:21:36 Finland
2022-10-29 Finland       1348737 6568 0   61.92411 25.748151 2022-10-30 04:22:14 Finland
2022-10-28 Finland       1348737 6568 0   61.92411 25.748151 2022-10-29 04:21:13 Finland
2022-10-27 Finland       1348737 6568 0   61.92411 25.748151 2022-10-28 04:22:31 Finland
2022-04-21 Slovenia       1001713 6568 0   46.1512 14.9955 2022-04-22 04:20:45 Slovenia
2022-02-18 Mexico Guerrero     94828 6568 0   17.4392 -99.5451 2022-02-19 04:21:11 Guerrero, Mexico
2022-02-17 Mexico Guerrero     94828 6568 0   17.4392 -99.5451 2022-02-18 04:21:04 Guerrero, Mexico
2021-10-29 Brazil Rondonia     270027 6568 0   -11.5057 -63.5806 2021-10-30 04:22:03 Rondonia, Brazil
2021-09-11 Italy Sicilia     287826 6568 0   38.11569725 13.362356699999998 2021-09-12 04:21:13 Sicilia, Italy
2021-05-14 Mexico Sonora     74208 6568 0 67640 29.2972 -110.3309 2021-05-15 04:20:58 Sonora, Mexico
2021-05-11 Mexico Sonora     73979 6568 0 67411 29.2972 -110.3309 2021-05-12 04:21:29 Sonora, Mexico
2021-03-14 Guatemala       182881 6568 168338 7975 15.7835 -90.2308 2021-03-15 05:25:51 Guatemala
2020-12-05 Italy Piemonte     176519 6568 103188 66763 45.0732745 7.680687483 2020-12-06 05:26:18 Piemonte, Italy
2020-09-23 Colombia Capital District     257679 6568 217189 33922 4.711 -74.0721 2020-09-24 04:23:00 Capital District, Colombia

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;