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

12 rows where country_or_region = "France" and "day" is on date 2021-11-10 sorted by day descending

✎ View and edit SQL

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

country_or_region 1

  • France · 12 ✖
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2021-11-10 France French Guiana     45245 316 0   4.0 -53.0 2021-11-11 04:21:45 French Guiana, France
2021-11-10 France French Polynesia     45573 636 0   -17.6797 -149.4068 2021-11-11 04:21:45 French Polynesia, France
2021-11-10 France Guadeloupe     54672 822 0   16.265 -61.551 2021-11-11 04:21:45 Guadeloupe, France
2021-11-10 France Martinique     43789 698 0   14.6415 -61.0242 2021-11-11 04:21:45 Martinique, France
2021-11-10 France Mayotte     20751 185 0   -12.8275 45.166244 2021-11-11 04:21:45 Mayotte, France
2021-11-10 France New Caledonia     11466 271 0   -20.904304999999997 165.618042 2021-11-11 04:21:45 New Caledonia, France
2021-11-10 France Reunion     55865 376 0   -21.1151 55.5364 2021-11-11 04:21:45 Reunion, France
2021-11-10 France Saint Barthelemy     1661 6 0   17.9 -62.8333 2021-11-11 04:21:45 Saint Barthelemy, France
2021-11-10 France Saint Pierre and Miquelon     32 0 0   46.8852 -56.3159 2021-11-11 04:21:45 Saint Pierre and Miquelon, France
2021-11-10 France St Martin     3975 56 0   18.0708 -63.0501 2021-11-11 04:21:45 St Martin, France
2021-11-10 France Wallis and Futuna     454 7 0   -14.2938 -178.1165 2021-11-11 04:21:45 Wallis and Futuna, France
2021-11-10 France       7062794 115630 0   46.2276 2.2137 2021-11-11 04:21:45 France

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;