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 = "2022-10-07" sorted by day descending

✎ View and edit SQL

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

Suggested facets: day (date), last_update (date)

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
2022-10-07 France French Guiana     93974 410 0   4.0 -53.0 2022-10-08 04:22:56 French Guiana, France
2022-10-07 France French Polynesia     76703 649 0   -17.6797 -149.4068 2022-10-08 04:22:56 French Polynesia, France
2022-10-07 France Guadeloupe     192801 989 0   16.265 -61.551 2022-10-08 04:22:56 Guadeloupe, France
2022-10-07 France Martinique     221618 1044 0   14.6415 -61.0242 2022-10-08 04:22:56 Martinique, France
2022-10-07 France Mayotte     40277 187 0   -12.8275 45.166244 2022-10-08 04:22:56 Mayotte, France
2022-10-07 France New Caledonia     74315 314 0   -20.904305 165.618042 2022-10-08 04:22:56 New Caledonia, France
2022-10-07 France Reunion     476927 894 0   -21.1151 55.5364 2022-10-08 04:22:56 Reunion, France
2022-10-07 France Saint Barthelemy     5285 6 0   17.9 -62.8333 2022-10-08 04:22:56 Saint Barthelemy, France
2022-10-07 France Saint Pierre and Miquelon     3231 1 0   46.8852 -56.3159 2022-10-08 04:22:56 Saint Pierre and Miquelon, France
2022-10-07 France St Martin     11978 63 0   18.0708 -63.0501 2022-10-08 04:22:56 St Martin, France
2022-10-07 France Wallis and Futuna     761 7 0   -14.2938 -178.1165 2022-10-08 04:22:56 Wallis and Futuna, France
2022-10-07 France       34785735 151898 0   46.2276 2.2137 2022-10-08 04:22:56 France

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;