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

14 rows where deaths = 6668 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 10

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2022-11-16 Japan Osaka     2223906 6668 0   34.620965 135.507481 2022-11-17 04:21:11 Osaka, Japan
2022-07-19 Slovenia       1063613 6668 0   46.1512 14.9955 2022-07-20 04:20:59 Slovenia
2022-07-18 Slovenia       1060808 6668 0   46.1512 14.9955 2022-07-19 04:20:58 Slovenia
2021-12-08 Brazil Rondonia     280199 6668 0   -11.5057 -63.5806 2021-12-09 04:22:49 Rondonia, Brazil
2021-11-23 Russia Perm Krai     135920 6668 0   58.5951603 56.3159546 2021-11-24 04:22:14 Perm Krai, Russia
2021-09-30 North Macedonia       191408 6668 0   41.6086 21.7453 2021-10-01 04:21:35 North Macedonia
2021-08-15 Israel       939360 6668 0   31.046051000000002 34.851612 2021-08-16 04:21:31 Israel
2021-07-31 Italy Puglia     256031 6668 247015 2348 41.12559576 16.86736689 2021-08-01 04:21:50 Puglia, Italy
2021-07-27 Italy Puglia     255237 6668 246745 1824 41.12559576 16.86736689 2021-07-28 04:21:39 Puglia, Italy
2021-06-03 Mexico Sonora     75565 6668 0 68897 29.2972 -110.3309 2021-06-04 04:23:37 Sonora, Mexico
2021-04-09 Colombia Valle del Cauca     214750 6668 202659 5423 3.8009 -76.6413 2021-04-10 04:20:59 Valle del Cauca, Colombia
2021-03-11 Colombia Antioquia     350402 6668 338415 5319 7.1986 -75.3412 2021-03-12 05:26:50 Antioquia, Colombia
2020-12-21 Brazil Goias     301502 6668 289828 4730 -15.827 -49.8362 2020-12-22 05:22:33 Goias, Brazil
2020-08-26 Iraq       215784 6668 157215 51901 33.223191 43.679291 2020-08-27 04:28:15 Iraq

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;