⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

3,488 rows where country_or_region = "France" sorted by day descending

View and edit SQL

Suggested facets: latitude, longitude, combined_key, day (date), last_update (date)

country_or_region

  • France · 3,488
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
298499 2021-01-21 France French Guiana     15311 76 9995 5240 4.0 -53.0 2021-01-22 05:22:10 French Guiana, France
298500 2021-01-21 France French Polynesia     17820 128 4842 12850 -17.6797 -149.4068 2021-01-22 05:22:10 French Polynesia, France
298501 2021-01-21 France Guadeloupe     8948 156 2242 6550 16.265 -61.551 2021-01-22 05:22:10 Guadeloupe, France
298502 2021-01-21 France Martinique     6302 44 98 6160 14.6415 -61.0242 2021-01-22 05:22:10 Martinique, France
298503 2021-01-21 France Mayotte     6981 58 2964 3959 -12.8275 45.166244 2021-01-22 05:22:10 Mayotte, France
298504 2021-01-21 France New Caledonia     44 0 43 1 -20.904305 165.618042 2021-01-22 05:22:10 New Caledonia, France
298505 2021-01-21 France Reunion     9584 45 9053 486 -21.1151 55.5364 2021-01-22 05:22:10 Reunion, France
298506 2021-01-21 France Saint Barthelemy     300 1 204 95 17.9 -62.8333 2021-01-22 05:22:10 Saint Barthelemy, France
298507 2021-01-21 France Saint Pierre and Miquelon     16 0 16 0 46.8852 -56.3159 2021-01-22 05:22:10 Saint Pierre and Miquelon, France
298508 2021-01-21 France St Martin     1146 12 1006 128 18.0708 -63.0501 2021-01-22 05:22:10 St Martin, France
298509 2021-01-21 France Wallis and Futuna     4 0 1 3 -14.2938 -178.1165 2021-01-22 05:22:10 Wallis and Futuna, France
298510 2021-01-21 France       2979915 71619 190186 2718110 46.2276 2.2137 2021-01-22 05:22:10 France
889551 2021-01-20 France French Guiana     15187 76 9995 5116 4.0 -53.0 2021-01-21 05:22:01 French Guiana, France
889552 2021-01-20 France French Polynesia     17697 127 4842 12728 -17.6797 -149.4068 2021-01-21 05:22:01 French Polynesia, France
889553 2021-01-20 France Guadeloupe     8948 156 2242 6550 16.265 -61.551 2021-01-21 05:22:01 Guadeloupe, France
889554 2021-01-20 France Martinique     6302 44 98 6160 14.6415 -61.0242 2021-01-21 05:22:01 Martinique, France
889555 2021-01-20 France Mayotte     6918 58 2964 3896 -12.8275 45.166244 2021-01-21 05:22:01 Mayotte, France
889556 2021-01-20 France New Caledonia     44 0 43 1 -20.904305 165.618042 2021-01-21 05:22:01 New Caledonia, France
889557 2021-01-20 France Reunion     9552 45 9053 454 -21.1151 55.5364 2021-01-21 05:22:01 Reunion, France
889558 2021-01-20 France Saint Barthelemy     300 1 204 95 17.9 -62.8333 2021-01-21 05:22:01 Saint Barthelemy, France
889559 2021-01-20 France Saint Pierre and Miquelon     16 0 16 0 46.8852 -56.3159 2021-01-21 05:22:01 Saint Pierre and Miquelon, France
889560 2021-01-20 France St Martin     1146 12 1006 128 18.0708 -63.0501 2021-01-21 05:22:01 St Martin, France
889561 2021-01-20 France Wallis and Futuna     4 0 1 3 -14.2938 -178.1165 2021-01-21 05:22:01 Wallis and Futuna, France
889562 2021-01-20 France       2957547 71273 188890 2697123 46.2276 2.2137 2021-01-21 05:22:01 France
318118 2021-01-19 France French Guiana     15055 76 9995 4984 4.0 -53.0 2021-01-20 05:21:54 French Guiana, France
318119 2021-01-19 France French Polynesia     17697 127 4842 12728 -17.6797 -149.4068 2021-01-20 05:21:54 French Polynesia, France
318120 2021-01-19 France Guadeloupe     8948 156 2242 6550 16.265 -61.551 2021-01-20 05:21:54 Guadeloupe, France
318121 2021-01-19 France Martinique     6302 44 98 6160 14.6415 -61.0242 2021-01-20 05:21:54 Martinique, France
318122 2021-01-19 France Mayotte     6789 58 2964 3767 -12.8275 45.166244 2021-01-20 05:21:54 Mayotte, France
318123 2021-01-19 France New Caledonia     44 0 43 1 -20.904305 165.618042 2021-01-20 05:21:54 New Caledonia, France
318124 2021-01-19 France Reunion     9552 45 9053 454 -21.1151 55.5364 2021-01-20 05:21:54 Reunion, France
318125 2021-01-19 France Saint Barthelemy     251 1 172 78 17.9 -62.8333 2021-01-20 05:21:54 Saint Barthelemy, France
318126 2021-01-19 France Saint Pierre and Miquelon     16 0 16 0 46.8852 -56.3159 2021-01-20 05:21:54 Saint Pierre and Miquelon, France
318127 2021-01-19 France St Martin     1076 12 855 209 18.0708 -63.0501 2021-01-20 05:21:54 St Martin, France
318128 2021-01-19 France Wallis and Futuna     4 0 1 3 -14.2938 -178.1165 2021-01-20 05:21:54 Wallis and Futuna, France
318129 2021-01-19 France       2931050 70963 187464 2672336 46.2276 2.2137 2021-01-20 05:21:54 France
570104 2021-01-18 France French Guiana     14975 75 9995 4905 4.0 -53.0 2021-01-19 05:22:15 French Guiana, France
570105 2021-01-18 France French Polynesia     17697 127 4842 12728 -17.6797 -149.4068 2021-01-19 05:22:15 French Polynesia, France
570106 2021-01-18 France Guadeloupe     8834 156 2242 6436 16.265 -61.551 2021-01-19 05:22:15 Guadeloupe, France
570107 2021-01-18 France Martinique     6227 43 98 6086 14.6415 -61.0242 2021-01-19 05:22:15 Martinique, France
570108 2021-01-18 France Mayotte     6611 58 2964 3589 -12.8275 45.166244 2021-01-19 05:22:15 Mayotte, France
570109 2021-01-18 France New Caledonia     44 0 43 1 -20.904305 165.618042 2021-01-19 05:22:15 New Caledonia, France
570110 2021-01-18 France Reunion     9443 45 9053 345 -21.1151 55.5364 2021-01-19 05:22:15 Reunion, France
570111 2021-01-18 France Saint Barthelemy     251 1 172 78 17.9 -62.8333 2021-01-19 05:22:15 Saint Barthelemy, France
570112 2021-01-18 France Saint Pierre and Miquelon     16 0 16 0 46.8852 -56.3159 2021-01-19 05:22:15 Saint Pierre and Miquelon, France
570113 2021-01-18 France St Martin     1076 12 855 209 18.0708 -63.0501 2021-01-19 05:22:15 St Martin, France
570114 2021-01-18 France Wallis and Futuna     4 0 1 3 -14.2938 -178.1165 2021-01-19 05:22:15 Wallis and Futuna, France
570115 2021-01-18 France       2907711 70309 185848 2651554 46.2276 2.2137 2021-01-19 05:22:15 France
534667 2021-01-17 France French Guiana     14975 75 9995 4905 4.0 -53.0 2021-01-18 05:22:34 French Guiana, France
534668 2021-01-17 France French Polynesia     17635 126 4842 12667 -17.6797 -149.4068 2021-01-18 05:22:34 French Polynesia, France
534669 2021-01-17 France Guadeloupe     8834 156 2242 6436 16.265 -61.551 2021-01-18 05:22:34 Guadeloupe, France
534670 2021-01-17 France Martinique     6227 43 98 6086 14.6415 -61.0242 2021-01-18 05:22:34 Martinique, France
534671 2021-01-17 France Mayotte     6611 58 2964 3589 -12.8275 45.166244 2021-01-18 05:22:34 Mayotte, France
534672 2021-01-17 France New Caledonia     44 0 40 4 -20.904305 165.618042 2021-01-18 05:22:34 New Caledonia, France
534673 2021-01-17 France Reunion     9443 45 9053 345 -21.1151 55.5364 2021-01-18 05:22:34 Reunion, France
534674 2021-01-17 France Saint Barthelemy     251 1 172 78 17.9 -62.8333 2021-01-18 05:22:34 Saint Barthelemy, France
534675 2021-01-17 France Saint Pierre and Miquelon     16 0 16 0 46.8852 -56.3159 2021-01-18 05:22:34 Saint Pierre and Miquelon, France
534676 2021-01-17 France St Martin     1076 12 855 209 18.0708 -63.0501 2021-01-18 05:22:34 St Martin, France
534677 2021-01-17 France Wallis and Futuna     4 0 1 3 -14.2938 -178.1165 2021-01-18 05:22:34 Wallis and Futuna, France
534678 2021-01-17 France       2903975 69906 184991 2649078 46.2276 2.2137 2021-01-18 05:22:34 France
615455 2021-01-16 France French Guiana     14776 74 9995 4707 4.0 -53.0 2021-01-17 05:22:17 French Guiana, France
615456 2021-01-16 France French Polynesia     17635 126 4842 12667 -17.6797 -149.4068 2021-01-17 05:22:17 French Polynesia, France
615457 2021-01-16 France Guadeloupe     8834 156 2242 6436 16.265 -61.551 2021-01-17 05:22:17 Guadeloupe, France
615458 2021-01-16 France Martinique     6227 43 98 6086 14.6415 -61.0242 2021-01-17 05:22:17 Martinique, France
615459 2021-01-16 France Mayotte     6611 58 2964 3589 -12.8275 45.166244 2021-01-17 05:22:17 Mayotte, France
615460 2021-01-16 France New Caledonia     44 0 40 4 -20.904305 165.618042 2021-01-17 05:22:17 New Caledonia, France
615461 2021-01-16 France Reunion     9443 45 9053 345 -21.1151 55.5364 2021-01-17 05:22:17 Reunion, France
615462 2021-01-16 France Saint Barthelemy     251 1 172 78 17.9 -62.8333 2021-01-17 05:22:17 Saint Barthelemy, France
615463 2021-01-16 France Saint Pierre and Miquelon     16 0 16 0 46.8852 -56.3159 2021-01-17 05:22:17 Saint Pierre and Miquelon, France
615464 2021-01-16 France St Martin     1076 12 855 209 18.0708 -63.0501 2021-01-17 05:22:17 St Martin, France
615465 2021-01-16 France Wallis and Futuna     4 0 1 3 -14.2938 -178.1165 2021-01-17 05:22:17 Wallis and Futuna, France
615466 2021-01-16 France       2866769 69578 183719 2612834 46.2276 2.2137 2021-01-17 05:22:17 France
180596 2021-01-15 France French Guiana     14526 74 9995 4457 4.0 -53.0 2021-01-16 05:22:40 French Guiana, France
180597 2021-01-15 France French Polynesia     17635 126 4842 12667 -17.6797 -149.4068 2021-01-16 05:22:40 French Polynesia, France
180598 2021-01-15 France Guadeloupe     8834 156 2242 6436 16.265 -61.551 2021-01-16 05:22:40 Guadeloupe, France
180599 2021-01-15 France Martinique     6227 43 98 6086 14.6415 -61.0242 2021-01-16 05:22:40 Martinique, France
180600 2021-01-15 France Mayotte     6611 58 2964 3589 -12.8275 45.166244 2021-01-16 05:22:40 Mayotte, France
180601 2021-01-15 France New Caledonia     41 0 40 1 -20.904305 165.618042 2021-01-16 05:22:40 New Caledonia, France
180602 2021-01-15 France Reunion     9406 42 9053 311 -21.1151 55.5364 2021-01-16 05:22:40 Reunion, France
180603 2021-01-15 France Saint Barthelemy     251 1 172 78 17.9 -62.8333 2021-01-16 05:22:40 Saint Barthelemy, France
180604 2021-01-15 France Saint Pierre and Miquelon     16 0 16 0 46.8852 -56.3159 2021-01-16 05:22:40 Saint Pierre and Miquelon, France
180605 2021-01-15 France St Martin     1076 12 855 209 18.0708 -63.0501 2021-01-16 05:22:40 St Martin, France
180606 2021-01-15 France Wallis and Futuna     4 0 1 3 -14.2938 -178.1165 2021-01-16 05:22:40 Wallis and Futuna, France
180607 2021-01-15 France       2866769 69578 183719 2613118 46.2276 2.2137 2021-01-16 05:22:40 France
593288 2021-01-14 France French Guiana     14370 74 9995 4301 4.0 -53.0 2021-01-15 05:22:24 French Guiana, France
593289 2021-01-14 France French Polynesia     17590 126 4842 12622 -17.6797 -149.4068 2021-01-15 05:22:24 French Polynesia, France
593290 2021-01-14 France Guadeloupe     8834 156 2242 6436 16.265 -61.551 2021-01-15 05:22:24 Guadeloupe, France
593291 2021-01-14 France Martinique     6227 43 98 6086 14.6415 -61.0242 2021-01-15 05:22:24 Martinique, France
593292 2021-01-14 France Mayotte     6255 56 2964 3235 -12.8275 45.166244 2021-01-15 05:22:24 Mayotte, France
593293 2021-01-14 France New Caledonia     40 0 40 0 -20.904305 165.618042 2021-01-15 05:22:24 New Caledonia, France
593294 2021-01-14 France Reunion     9359 42 8830 487 -21.1151 55.5364 2021-01-15 05:22:24 Reunion, France
593295 2021-01-14 France Saint Barthelemy     251 1 172 78 17.9 -62.8333 2021-01-15 05:22:24 Saint Barthelemy, France
593296 2021-01-14 France Saint Pierre and Miquelon     16 0 16 0 46.8852 -56.3159 2021-01-15 05:22:24 Saint Pierre and Miquelon, France
593297 2021-01-14 France St Martin     1076 12 855 209 18.0708 -63.0501 2021-01-15 05:22:24 St Martin, France
593298 2021-01-14 France Wallis and Futuna     4 0 1 3 -14.2938 -178.1165 2021-01-15 05:22:24 Wallis and Futuna, France
593299 2021-01-14 France       2845701 68942 182673 2594086 46.2276 2.2137 2021-01-15 05:22:24 France
724659 2021-01-13 France French Guiana     14370 74 9995 4301 4.0 -53.0 2021-01-14 05:22:32 French Guiana, France
724660 2021-01-13 France French Polynesia     17483 124 4842 12517 -17.6797 -149.4068 2021-01-14 05:22:32 French Polynesia, France
724661 2021-01-13 France Guadeloupe     8834 156 2242 6436 16.265 -61.551 2021-01-14 05:22:32 Guadeloupe, France
724662 2021-01-13 France Martinique     6227 43 98 6086 14.6415 -61.0242 2021-01-14 05:22:32 Martinique, France

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);