johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
388117 | 388117 | 2021-04-04 | France | Guadeloupe | 11890 | 177 | 2242 | 9471 | 16.265 | -61.551 | 2021-04-05 04:20:35 | Guadeloupe, France | ||
388118 | 388118 | 2021-04-04 | France | Martinique | 8163 | 54 | 98 | 8011 | 14.6415 | -61.0242 | 2021-04-05 04:20:35 | Martinique, France | ||
388119 | 388119 | 2021-04-04 | France | Mayotte | 19490 | 162 | 2964 | 16364 | -12.8275 | 45.166244 | 2021-04-05 04:20:35 | Mayotte, France | ||
388120 | 388120 | 2021-04-04 | France | New Caledonia | 121 | 0 | 58 | 63 | -20.904305 | 165.618042 | 2021-04-05 04:20:35 | New Caledonia, France | ||
388121 | 388121 | 2021-04-04 | France | Reunion | 16586 | 115 | 14828 | 1643 | -21.1151 | 55.5364 | 2021-04-05 04:20:35 | Reunion, France | ||
388122 | 388122 | 2021-04-04 | France | Saint Barthelemy | 910 | 1 | 462 | 447 | 17.9 | -62.8333 | 2021-04-05 04:20:35 | Saint Barthelemy, France | ||
388123 | 388123 | 2021-04-04 | France | Saint Pierre and Miquelon | 24 | 0 | 24 | 0 | 46.8852 | -56.3159 | 2021-04-05 04:20:35 | Saint Pierre and Miquelon, France | ||
388124 | 388124 | 2021-04-04 | France | St Martin | 1687 | 13 | 1399 | 275 | 18.0708 | -63.0501 | 2021-04-05 04:20:35 | St Martin, France | ||
388125 | 388125 | 2021-04-04 | France | Wallis and Futuna | 425 | 4 | 44 | 377 | -14.2938 | -178.1165 | 2021-04-05 04:20:35 | Wallis and Futuna, France | ||
388126 | 388126 | 2021-04-04 | France | 4788117 | 96046 | 269497 | 4422574 | 46.2276 | 2.2137 | 2021-04-05 04:20:35 | France | |||
388127 | 388127 | 2021-04-04 | Gabon | 19863 | 119 | 16910 | 2834 | -0.8037 | 11.6094 | 2021-04-05 04:20:35 | Gabon | |||
388128 | 388128 | 2021-04-04 | Gambia | 5505 | 166 | 5086 | 253 | 13.4432 | -15.3101 | 2021-04-05 04:20:35 | Gambia | |||
388129 | 388129 | 2021-04-04 | Georgia | 283833 | 3811 | 274599 | 5423 | 42.3154 | 43.3569 | 2021-04-05 04:20:35 | Georgia | |||
388130 | 388130 | 2021-04-04 | Germany | Baden-Wurttemberg | 371389 | 8743 | 333900 | 29760 | 48.6616 | 9.3501 | 2021-04-05 04:20:35 | Baden-Wurttemberg, Germany | ||
388131 | 388131 | 2021-04-04 | Germany | Bayern | 508747 | 13312 | 458700 | 38278 | 48.7904 | 11.4979 | 2021-04-05 04:20:35 | Bayern, Germany | ||
388132 | 388132 | 2021-04-04 | Germany | Berlin | 148725 | 3081 | 136500 | 9459 | 52.52 | 13.405 | 2021-04-05 04:20:35 | Berlin, Germany | ||
388133 | 388133 | 2021-04-04 | Germany | Brandenburg | 89948 | 3317 | 79600 | 7240 | 52.4125 | 12.5316 | 2021-04-05 04:20:35 | Brandenburg, Germany | ||
388134 | 388134 | 2021-04-04 | Germany | Bremen | 21374 | 406 | 19420 | 1642 | 53.0793 | 8.8017 | 2021-04-05 04:20:35 | Bremen, Germany | ||
388135 | 388135 | 2021-04-04 | Germany | Hamburg | 62742 | 1397 | 54270 | 7294 | 53.5511 | 9.9937 | 2021-04-05 04:20:35 | Hamburg, Germany | ||
388136 | 388136 | 2021-04-04 | Germany | Hessen | 224044 | 6370 | 198300 | 20002 | 50.6521 | 9.1624 | 2021-04-05 04:20:35 | Hessen, Germany | ||
388137 | 388137 | 2021-04-04 | Germany | Mecklenburg-Vorpommern | 31370 | 875 | 27850 | 2864 | 53.6127 | 12.4296 | 2021-04-05 04:20:35 | Mecklenburg-Vorpommern, Germany | ||
388138 | 388138 | 2021-04-04 | Germany | Niedersachsen | 202110 | 4905 | 181900 | 16018 | 52.6367 | 9.8451 | 2021-04-05 04:20:35 | Niedersachsen, Germany | ||
388139 | 388139 | 2021-04-04 | Germany | Nordrhein-Westfalen | 624339 | 14305 | 561400 | 50078 | 51.4332 | 7.6616 | 2021-04-05 04:20:35 | Nordrhein-Westfalen, Germany | ||
388140 | 388140 | 2021-04-04 | Germany | Rheinland-Pfalz | 118827 | 3340 | 106500 | 9517 | 50.1183 | 7.309 | 2021-04-05 04:20:35 | Rheinland-Pfalz, Germany | ||
388141 | 388141 | 2021-04-04 | Germany | Saarland | 32275 | 927 | 29950 | 1495 | 49.3964 | 7.023 | 2021-04-05 04:20:35 | Saarland, Germany | ||
388142 | 388142 | 2021-04-04 | Germany | Sachsen | 226142 | 8430 | 201300 | 17170 | 51.1045 | 13.2017 | 2021-04-05 04:20:35 | Sachsen, Germany | ||
388143 | 388143 | 2021-04-04 | Germany | Sachsen-Anhalt | 75018 | 2729 | 66170 | 6604 | 51.9503 | 11.6923 | 2021-04-05 04:20:35 | Sachsen-Anhalt, Germany | ||
388144 | 388144 | 2021-04-04 | Germany | Schleswig-Holstein | 50863 | 1441 | 45370 | 4217 | 54.2194 | 9.6961 | 2021-04-05 04:20:35 | Schleswig-Holstein, Germany | ||
388145 | 388145 | 2021-04-04 | Germany | Thuringen | 97473 | 3385 | 84720 | 9570 | 51.011 | 10.8453 | 2021-04-05 04:20:35 | Thuringen, Germany | ||
388146 | 388146 | 2021-04-04 | Germany | Unknown | 2211 | 0 | 0 | 2211 | 2021-04-05 04:20:35 | Unknown, Germany | ||||
388147 | 388147 | 2021-04-04 | Ghana | 90782 | 748 | 88585 | 1449 | 7.9465 | -1.0232 | 2021-04-05 04:20:35 | Ghana | |||
388148 | 388148 | 2021-04-04 | Greece | 275414 | 8380 | 93764 | 173270 | 39.0742 | 21.8243 | 2021-04-05 04:20:35 | Greece | |||
388149 | 388149 | 2021-04-04 | Grenada | 155 | 1 | 152 | 2 | 12.1165 | -61.679 | 2021-04-05 04:20:35 | Grenada | |||
388150 | 388150 | 2021-04-04 | Guatemala | 195471 | 6891 | 179988 | 8592 | 15.7835 | -90.2308 | 2021-04-05 04:20:35 | Guatemala | |||
388151 | 388151 | 2021-04-04 | Guinea | 20405 | 130 | 17458 | 2817 | 9.9456 | -9.6966 | 2021-04-05 04:20:35 | Guinea | |||
388152 | 388152 | 2021-04-04 | Guinea-Bissau | 3662 | 66 | 3012 | 584 | 11.8037 | -15.1804 | 2021-04-05 04:20:35 | Guinea-Bissau | |||
388153 | 388153 | 2021-04-04 | Guyana | 10580 | 243 | 9250 | 1087 | 4.860416000000002 | -58.93018000000001 | 2021-04-05 04:20:35 | Guyana | |||
388154 | 388154 | 2021-04-04 | Haiti | 12857 | 251 | 11126 | 1410 | 18.9712 | -72.2852 | 2021-04-05 04:20:35 | Haiti | |||
388155 | 388155 | 2021-04-04 | Holy See | 27 | 0 | 15 | 12 | 41.9029 | 12.4534 | 2021-04-05 04:20:35 | Holy See | |||
388156 | 388156 | 2021-04-04 | Honduras | 190631 | 4644 | 73373 | 112614 | 15.2 | -86.2419 | 2021-04-05 04:20:35 | Honduras | |||
388157 | 388157 | 2021-04-04 | Hungary | 685979 | 21715 | 416972 | 247292 | 47.1625 | 19.5033 | 2021-04-05 04:20:35 | Hungary | |||
388158 | 388158 | 2021-04-04 | Iceland | 6225 | 29 | 6072 | 124 | 64.9631 | -19.0208 | 2021-04-05 04:20:35 | Iceland | |||
388159 | 388159 | 2021-04-04 | India | Andaman and Nicobar Islands | 5109 | 62 | 4990 | 57 | 11.225999 | 92.968178 | 2021-04-05 04:20:35 | Andaman and Nicobar Islands, India | ||
388160 | 388160 | 2021-04-04 | India | Andhra Pradesh | 907676 | 7239 | 890137 | 10300 | 15.9129 | 79.74 | 2021-04-05 04:20:35 | Andhra Pradesh, India | ||
388161 | 388161 | 2021-04-04 | India | Arunachal Pradesh | 16849 | 56 | 16785 | 8 | 27.768456 | 96.384277 | 2021-04-05 04:20:35 | Arunachal Pradesh, India | ||
388162 | 388162 | 2021-04-04 | India | Assam | 218670 | 1109 | 215597 | 1964 | 26.357149 | 92.830441 | 2021-04-05 04:20:35 | Assam, India | ||
388163 | 388163 | 2021-04-04 | India | Bihar | 268377 | 1583 | 263233 | 3561 | 25.679658 | 85.60484 | 2021-04-05 04:20:35 | Bihar, India | ||
388164 | 388164 | 2021-04-04 | India | Chandigarh | 28194 | 383 | 24661 | 3150 | 30.733839 | 76.76827800000002 | 2021-04-05 04:20:35 | Chandigarh, India | ||
388165 | 388165 | 2021-04-04 | India | Chhattisgarh | 369046 | 4319 | 326277 | 38450 | 21.264705 | 82.035366 | 2021-04-05 04:20:35 | Chhattisgarh, India | ||
388166 | 388166 | 2021-04-04 | India | Dadra and Nagar Haveli and Daman and Diu | 3744 | 2 | 3538 | 204 | 20.194742 | 73.080901 | 2021-04-05 04:20:35 | Dadra and Nagar Haveli and Daman and Diu, India | ||
388167 | 388167 | 2021-04-04 | India | Delhi | 676414 | 11081 | 651351 | 13982 | 28.646519 | 77.10898 | 2021-04-05 04:20:35 | Delhi, India | ||
388168 | 388168 | 2021-04-04 | India | Goa | 59068 | 835 | 56156 | 2077 | 15.359682 | 74.057396 | 2021-04-05 04:20:35 | Goa, India | ||
388169 | 388169 | 2021-04-04 | India | Gujarat | 318438 | 4566 | 298737 | 15135 | 22.694884 | 71.590923 | 2021-04-05 04:20:35 | Gujarat, India | ||
388170 | 388170 | 2021-04-04 | India | Haryana | 298133 | 3191 | 282368 | 12574 | 29.20004 | 76.332824 | 2021-04-05 04:20:35 | Haryana, India | ||
388171 | 388171 | 2021-04-04 | India | Himachal Pradesh | 65242 | 1070 | 60595 | 3577 | 31.927213 | 77.233081 | 2021-04-05 04:20:35 | Himachal Pradesh, India | ||
388172 | 388172 | 2021-04-04 | India | Jammu and Kashmir | 133012 | 2008 | 127049 | 3955 | 33.75943 | 76.612638 | 2021-04-05 04:20:35 | Jammu and Kashmir, India | ||
388173 | 388173 | 2021-04-04 | India | Jharkhand | 127246 | 1130 | 120872 | 5244 | 23.654536 | 85.557631 | 2021-04-05 04:20:35 | Jharkhand, India | ||
388174 | 388174 | 2021-04-04 | India | Karnataka | 1015155 | 12625 | 963419 | 39111 | 14.70518 | 76.166436 | 2021-04-05 04:20:35 | Karnataka, India | ||
388175 | 388175 | 2021-04-04 | India | Kerala | 1135233 | 4668 | 1102359 | 28206 | 10.450898 | 76.405749 | 2021-04-05 04:20:35 | Kerala, India | ||
388176 | 388176 | 2021-04-04 | India | Ladakh | 10255 | 130 | 9802 | 323 | 34.1526 | 77.5771 | 2021-04-05 04:20:35 | Ladakh, India | ||
388177 | 388177 | 2021-04-04 | India | Lakshadweep | 741 | 1 | 704 | 36 | 13.6999972 | 72.18333259999999 | 2021-04-05 04:20:35 | Lakshadweep, India | ||
388178 | 388178 | 2021-04-04 | India | Madhya Pradesh | 306851 | 4040 | 281476 | 21335 | 23.541513 | 78.289633 | 2021-04-05 04:20:35 | Madhya Pradesh, India | ||
388179 | 388179 | 2021-04-04 | India | Maharashtra | 3010597 | 55878 | 2522823 | 431896 | 19.449759 | 76.108221 | 2021-04-05 04:20:35 | Maharashtra, India | ||
388180 | 388180 | 2021-04-04 | India | Manipur | 29423 | 374 | 28988 | 61 | 24.738975 | 93.882541 | 2021-04-05 04:20:35 | Manipur, India | ||
388181 | 388181 | 2021-04-04 | India | Meghalaya | 14122 | 150 | 13870 | 102 | 25.536934 | 91.278882 | 2021-04-05 04:20:35 | Meghalaya, India | ||
388182 | 388182 | 2021-04-04 | India | Mizoram | 4491 | 11 | 4439 | 41 | 23.309381 | 92.83822 | 2021-04-05 04:20:35 | Mizoram, India | ||
388183 | 388183 | 2021-04-04 | India | Nagaland | 12363 | 92 | 12138 | 133 | 26.06702 | 94.470302 | 2021-04-05 04:20:35 | Nagaland, India | ||
388184 | 388184 | 2021-04-04 | India | Odisha | 342695 | 1922 | 337935 | 2838 | 20.505428 | 84.418059 | 2021-04-05 04:20:35 | Odisha, India | ||
388185 | 388185 | 2021-04-04 | India | Puducherry | 42359 | 684 | 40083 | 1592 | 11.882658 | 78.86498 | 2021-04-05 04:20:35 | Puducherry, India | ||
388186 | 388186 | 2021-04-04 | India | Punjab | 251460 | 7083 | 219063 | 25314 | 30.841465000000003 | 75.40879 | 2021-04-05 04:20:35 | Punjab, India | ||
388187 | 388187 | 2021-04-04 | India | Rajasthan | 339325 | 2829 | 323618 | 12878 | 26.583423 | 73.847973 | 2021-04-05 04:20:35 | Rajasthan, India | ||
388188 | 388188 | 2021-04-04 | India | Sikkim | 6257 | 135 | 6071 | 51 | 27.571671 | 88.472712 | 2021-04-05 04:20:35 | Sikkim, India | ||
388189 | 388189 | 2021-04-04 | India | Tamil Nadu | 899807 | 12778 | 865071 | 21958 | 11.006091 | 78.400624 | 2021-04-05 04:20:35 | Tamil Nadu, India | ||
388190 | 388190 | 2021-04-04 | India | Telangana | 313237 | 1723 | 302768 | 8746 | 18.1124 | 79.0193 | 2021-04-05 04:20:35 | Telangana, India | ||
388191 | 388191 | 2021-04-04 | India | Tripura | 33540 | 392 | 33085 | 63 | 23.746783 | 91.743565 | 2021-04-05 04:20:35 | Tripura, India | ||
388192 | 388192 | 2021-04-04 | India | Unknown | 0 | 0 | 0 | 0 | 2021-04-05 04:20:35 | Unknown, India | ||||
388193 | 388193 | 2021-04-04 | India | Uttar Pradesh | 630059 | 8881 | 601440 | 19738 | 26.925425 | 80.560982 | 2021-04-05 04:20:35 | Uttar Pradesh, India | ||
388194 | 388194 | 2021-04-04 | India | Uttarakhand | 102264 | 1727 | 97520 | 3017 | 30.156447 | 79.197608 | 2021-04-05 04:20:35 | Uttarakhand, India | ||
388195 | 388195 | 2021-04-04 | India | West Bengal | 593615 | 10344 | 573118 | 10153 | 23.814082 | 87.979803 | 2021-04-05 04:20:35 | West Bengal, India | ||
388196 | 388196 | 2021-04-04 | Indonesia | 1534255 | 41669 | 1375877 | 116709 | -0.7893 | 113.9213 | 2021-04-05 04:20:35 | Indonesia | |||
388197 | 388197 | 2021-04-04 | Iran | 1932074 | 63160 | 1650569 | 218345 | 32.427908 | 53.68804599999999 | 2021-04-05 04:20:35 | Iran | |||
388198 | 388198 | 2021-04-04 | Iraq | 873568 | 14463 | 778535 | 80570 | 33.223191 | 43.679291 | 2021-04-05 04:20:35 | Iraq | |||
388199 | 388199 | 2021-04-04 | Ireland | 238148 | 4718 | 23364 | 210066 | 53.1424 | -7.6921 | 2021-04-05 04:20:35 | Ireland | |||
388200 | 388200 | 2021-04-04 | Israel | 834247 | 6243 | 822787 | 5217 | 31.046051 | 34.851612 | 2021-04-05 04:20:35 | Israel | |||
388201 | 388201 | 2021-04-04 | Italy | Abruzzo | 66594 | 2169 | 53697 | 10728 | 42.35122196 | 13.39843823 | 2021-04-05 04:20:35 | Abruzzo, Italy | ||
388202 | 388202 | 2021-04-04 | Italy | Basilicata | 20018 | 452 | 14544 | 5022 | 40.63947052 | 15.80514834 | 2021-04-05 04:20:35 | Basilicata, Italy | ||
388203 | 388203 | 2021-04-04 | Italy | Calabria | 48904 | 847 | 36574 | 11483 | 38.90597598 | 16.59440194 | 2021-04-05 04:20:35 | Calabria, Italy | ||
388204 | 388204 | 2021-04-04 | Italy | Campania | 345826 | 5516 | 247346 | 92964 | 40.83956555 | 14.25084984 | 2021-04-05 04:20:35 | Campania, Italy | ||
388205 | 388205 | 2021-04-04 | Italy | Emilia-Romagna | 342915 | 12113 | 258614 | 72188 | 44.49436681 | 11.3417208 | 2021-04-05 04:20:35 | Emilia-Romagna, Italy | ||
388206 | 388206 | 2021-04-04 | Italy | Friuli Venezia Giulia | 99517 | 3376 | 82381 | 13760 | 45.6494354 | 13.76813649 | 2021-04-05 04:20:35 | Friuli Venezia Giulia, Italy | ||
388207 | 388207 | 2021-04-04 | Italy | Lazio | 292357 | 6773 | 232937 | 52647 | 41.89277044 | 12.48366722 | 2021-04-05 04:20:35 | Lazio, Italy | ||
388208 | 388208 | 2021-04-04 | Italy | Liguria | 91378 | 3904 | 79917 | 7557 | 44.41149315 | 8.9326992 | 2021-04-05 04:20:35 | Liguria, Italy | ||
388209 | 388209 | 2021-04-04 | Italy | Lombardia | 751043 | 31130 | 625949 | 93964 | 45.46679409 | 9.190347404 | 2021-04-05 04:20:35 | Lombardia, Italy | ||
388210 | 388210 | 2021-04-04 | Italy | Marche | 90186 | 2682 | 78773 | 8731 | 43.61675973 | 13.5188753 | 2021-04-05 04:20:35 | Marche, Italy | ||
388211 | 388211 | 2021-04-04 | Italy | Molise | 12434 | 447 | 11195 | 792 | 41.55774754 | 14.65916051 | 2021-04-05 04:20:35 | Molise, Italy | ||
388212 | 388212 | 2021-04-04 | Italy | P.A. Bolzano | 69419 | 1138 | 67681 | 600 | 46.49933453 | 11.35662422 | 2021-04-05 04:20:35 | P.A. Bolzano, Italy | ||
388213 | 388213 | 2021-04-04 | Italy | P.A. Trento | 41781 | 1297 | 37761 | 2723 | 46.06893511 | 11.12123097 | 2021-04-05 04:20:35 | P.A. Trento, Italy | ||
388214 | 388214 | 2021-04-04 | Italy | Piemonte | 317358 | 10450 | 272953 | 33955 | 45.0732745 | 7.680687483 | 2021-04-05 04:20:35 | Piemonte, Italy | ||
388215 | 388215 | 2021-04-04 | Italy | Puglia | 201195 | 4911 | 145113 | 51171 | 41.12559576 | 16.86736689 | 2021-04-05 04:20:35 | Puglia, Italy | ||
388216 | 388216 | 2021-04-04 | Italy | Sardegna | 46978 | 1242 | 30180 | 15556 | 39.21531192 | 9.110616306 | 2021-04-05 04:20:35 | Sardegna, Italy |
Advanced export
JSON shape: default, array, newline-delimited
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] TEXT, [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]);