johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 1,215,830
- Russia 25,934
- Japan 15,511
- China 13,377
- India 11,258
- Colombia 10,701
- Mexico 10,566
- Ukraine 8,929
- Brazil 8,798
- Peru 8,273
- United Kingdom 7,741
- Malaysia 7,514
- Italy 7,013
- Spain 6,678
- Sweden 6,573
- Canada 6,115
- Germany 5,700
- Chile 5,552
- Netherlands 5,115
- France 4,400
- Australia 3,364
- Pakistan 2,219
- Belgium 2,034
- Mainland China 1,517
- New Zealand 1,295
- Denmark 1,181
- Antarctica 442
- Kiribati 442
- Korea, North 442
- Nauru 442
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2247282 | 2247282 | 2021-04-07 | Estonia | 111664 | 976 | 90551 | 20137 | 58.5953 | 25.0136 | 2021-04-08 04:21:13 | Estonia | |||
2247283 | 2247283 | 2021-04-07 | Eswatini | 17365 | 669 | 16631 | 65 | -26.5225 | 31.4659 | 2021-04-08 04:21:13 | Eswatini | |||
2247284 | 2247284 | 2021-04-07 | Ethiopia | 221544 | 3058 | 166135 | 52351 | 9.145 | 40.4897 | 2021-04-08 04:21:13 | Ethiopia | |||
2247285 | 2247285 | 2021-04-07 | Fiji | 67 | 2 | 64 | 1 | -17.7134 | 178.065 | 2021-04-08 04:21:13 | Fiji | |||
2247286 | 2247286 | 2021-04-07 | Finland | 80990 | 892 | 46000 | 33554 | 61.92411 | 25.748151 | 2021-04-08 04:21:13 | Finland | |||
2247287 | 2247287 | 2021-04-07 | France | French Guiana | 17132 | 93 | 9995 | 7044 | 4.0 | -53.0 | 2021-04-08 04:21:13 | French Guiana, France | ||
2247288 | 2247288 | 2021-04-07 | France | French Polynesia | 18643 | 141 | 4842 | 13660 | -17.6797 | -149.4068 | 2021-04-08 04:21:13 | French Polynesia, France | ||
2247289 | 2247289 | 2021-04-07 | France | Guadeloupe | 11890 | 177 | 2242 | 9471 | 16.265 | -61.551 | 2021-04-08 04:21:13 | Guadeloupe, France | ||
2247290 | 2247290 | 2021-04-07 | France | Martinique | 8163 | 54 | 98 | 8011 | 14.6415 | -61.0242 | 2021-04-08 04:21:13 | Martinique, France | ||
2247291 | 2247291 | 2021-04-07 | France | Mayotte | 19490 | 167 | 2964 | 16359 | -12.8275 | 45.166244 | 2021-04-08 04:21:13 | Mayotte, France | ||
2247292 | 2247292 | 2021-04-07 | France | New Caledonia | 121 | 0 | 58 | 63 | -20.904305 | 165.618042 | 2021-04-08 04:21:13 | New Caledonia, France | ||
2247293 | 2247293 | 2021-04-07 | France | Reunion | 17508 | 123 | 16011 | 1374 | -21.1151 | 55.5364 | 2021-04-08 04:21:13 | Reunion, France | ||
2247294 | 2247294 | 2021-04-07 | France | Saint Barthelemy | 910 | 1 | 462 | 447 | 17.9 | -62.8333 | 2021-04-08 04:21:13 | Saint Barthelemy, France | ||
2247295 | 2247295 | 2021-04-07 | France | Saint Pierre and Miquelon | 24 | 0 | 24 | 0 | 46.8852 | -56.3159 | 2021-04-08 04:21:13 | Saint Pierre and Miquelon, France | ||
2247296 | 2247296 | 2021-04-07 | France | St Martin | 1687 | 13 | 1399 | 275 | 18.0708 | -63.0501 | 2021-04-08 04:21:13 | St Martin, France | ||
2247297 | 2247297 | 2021-04-07 | France | Wallis and Futuna | 431 | 4 | 44 | 383 | -14.2938 | -178.1165 | 2021-04-08 04:21:13 | Wallis and Futuna, France | ||
2247298 | 2247298 | 2021-04-07 | France | 4807123 | 97080 | 269989 | 4440054 | 46.2276 | 2.2137 | 2021-04-08 04:21:13 | France | |||
2247299 | 2247299 | 2021-04-07 | Gabon | 20265 | 124 | 17227 | 2914 | -0.8037 | 11.6094 | 2021-04-08 04:21:13 | Gabon | |||
2247300 | 2247300 | 2021-04-07 | Gambia | 5564 | 166 | 5111 | 287 | 13.4432 | -15.3101 | 2021-04-08 04:21:13 | Gambia | |||
2247301 | 2247301 | 2021-04-07 | Georgia | 285645 | 3840 | 275547 | 6258 | 42.3154 | 43.3569 | 2021-04-08 04:21:13 | Georgia | |||
2247302 | 2247302 | 2021-04-07 | Germany | Baden-Wurttemberg | 373964 | 8795 | 341300 | 27002 | 48.6616 | 9.3501 | 2021-04-08 04:21:13 | Baden-Wurttemberg, Germany | ||
2247303 | 2247303 | 2021-04-07 | Germany | Bayern | 513473 | 13387 | 467100 | 36817 | 48.7904 | 11.4979 | 2021-04-08 04:21:13 | Bayern, Germany | ||
2247304 | 2247304 | 2021-04-07 | Germany | Berlin | 149829 | 3089 | 138800 | 8487 | 52.52 | 13.405 | 2021-04-08 04:21:13 | Berlin, Germany | ||
2247305 | 2247305 | 2021-04-07 | Germany | Brandenburg | 90448 | 3344 | 81090 | 6551 | 52.4125 | 12.5316 | 2021-04-08 04:21:13 | Brandenburg, Germany | ||
2247306 | 2247306 | 2021-04-07 | Germany | Bremen | 21550 | 411 | 19790 | 1492 | 53.0793 | 8.8017 | 2021-04-08 04:21:13 | Bremen, Germany | ||
2247307 | 2247307 | 2021-04-07 | Germany | Hamburg | 63509 | 1398 | 55180 | 7242 | 53.5511 | 9.9937 | 2021-04-08 04:21:13 | Hamburg, Germany | ||
2247308 | 2247308 | 2021-04-07 | Germany | Hessen | 226031 | 6410 | 202400 | 18740 | 50.6521 | 9.1624 | 2021-04-08 04:21:13 | Hessen, Germany | ||
2247309 | 2247309 | 2021-04-07 | Germany | Mecklenburg-Vorpommern | 31895 | 881 | 28730 | 2724 | 53.6127 | 12.4296 | 2021-04-08 04:21:13 | Mecklenburg-Vorpommern, Germany | ||
2247310 | 2247310 | 2021-04-07 | Germany | Niedersachsen | 203838 | 4939 | 186600 | 13525 | 52.6367 | 9.8451 | 2021-04-08 04:21:13 | Niedersachsen, Germany | ||
2247311 | 2247311 | 2021-04-07 | Germany | Nordrhein-Westfalen | 629820 | 14403 | 572000 | 47478 | 51.4332 | 7.6616 | 2021-04-08 04:21:13 | Nordrhein-Westfalen, Germany | ||
2247312 | 2247312 | 2021-04-07 | Germany | Rheinland-Pfalz | 120131 | 3353 | 108700 | 8808 | 50.1183 | 7.309 | 2021-04-08 04:21:13 | Rheinland-Pfalz, Germany | ||
2247313 | 2247313 | 2021-04-07 | Germany | Saarland | 32500 | 929 | 30330 | 1531 | 49.3964 | 7.023 | 2021-04-08 04:21:13 | Saarland, Germany | ||
2247314 | 2247314 | 2021-04-07 | Germany | Sachsen | 227862 | 8449 | 205400 | 15575 | 51.1045 | 13.2017 | 2021-04-08 04:21:13 | Sachsen, Germany | ||
2247315 | 2247315 | 2021-04-07 | Germany | Sachsen-Anhalt | 75864 | 2756 | 67780 | 5958 | 51.9503 | 11.6923 | 2021-04-08 04:21:13 | Sachsen-Anhalt, Germany | ||
2247316 | 2247316 | 2021-04-07 | Germany | Schleswig-Holstein | 51436 | 1447 | 46260 | 4156 | 54.2194 | 9.6961 | 2021-04-08 04:21:13 | Schleswig-Holstein, Germany | ||
2247317 | 2247317 | 2021-04-07 | Germany | Thuringen | 98295 | 3410 | 86860 | 9046 | 51.011 | 10.8453 | 2021-04-08 04:21:13 | Thuringen, Germany | ||
2247318 | 2247318 | 2021-04-07 | Germany | Unknown | 9072 | 0 | 0 | 9072 | 2021-04-08 04:21:13 | Unknown, Germany | ||||
2247319 | 2247319 | 2021-04-07 | Ghana | 91009 | 752 | 88810 | 1447 | 7.9465 | -1.0232 | 2021-04-08 04:21:13 | Ghana | |||
2247320 | 2247320 | 2021-04-07 | Greece | 285015 | 8607 | 93764 | 182644 | 39.0742 | 21.8243 | 2021-04-08 04:21:13 | Greece | |||
2247321 | 2247321 | 2021-04-07 | Grenada | 155 | 1 | 152 | 2 | 12.1165 | -61.679 | 2021-04-08 04:21:13 | Grenada | |||
2247322 | 2247322 | 2021-04-07 | Guatemala | 198374 | 6928 | 182408 | 9038 | 15.7835 | -90.2308 | 2021-04-08 04:21:13 | Guatemala | |||
2247323 | 2247323 | 2021-04-07 | Guinea | 20554 | 131 | 18302 | 2121 | 9.9456 | -9.6966 | 2021-04-08 04:21:13 | Guinea | |||
2247324 | 2247324 | 2021-04-07 | Guinea-Bissau | 3663 | 66 | 3032 | 565 | 11.8037 | -15.1804 | 2021-04-08 04:21:13 | Guinea-Bissau | |||
2247325 | 2247325 | 2021-04-07 | Guyana | 10718 | 250 | 9473 | 995 | 4.860416000000002 | -58.93018000000001 | 2021-04-08 04:21:13 | Guyana | |||
2247326 | 2247326 | 2021-04-07 | Haiti | 12876 | 251 | 11317 | 1234 | 18.9712 | -72.2852 | 2021-04-08 04:21:13 | Haiti | |||
2247327 | 2247327 | 2021-04-07 | Holy See | 27 | 0 | 15 | 12 | 41.9029 | 12.4534 | 2021-04-08 04:21:13 | Holy See | |||
2247328 | 2247328 | 2021-04-07 | Honduras | 193029 | 4703 | 74299 | 114027 | 15.2 | -86.2419 | 2021-04-08 04:21:13 | Honduras | |||
2247329 | 2247329 | 2021-04-07 | Hungary | 693676 | 22409 | 419152 | 252115 | 47.1625 | 19.5033 | 2021-04-08 04:21:13 | Hungary | |||
2247330 | 2247330 | 2021-04-07 | Iceland | 6251 | 29 | 6090 | 132 | 64.9631 | -19.0208 | 2021-04-08 04:21:13 | Iceland | |||
2247331 | 2247331 | 2021-04-07 | India | Andaman and Nicobar Islands | 5131 | 62 | 5020 | 49 | 11.225999 | 92.968178 | 2021-04-08 04:21:13 | Andaman and Nicobar Islands, India | ||
2247332 | 2247332 | 2021-04-07 | India | Andhra Pradesh | 913274 | 7262 | 892736 | 13276 | 15.9129 | 79.74 | 2021-04-08 04:21:13 | Andhra Pradesh, India | ||
2247333 | 2247333 | 2021-04-07 | India | Arunachal Pradesh | 16861 | 56 | 16788 | 17 | 27.768456 | 96.384277 | 2021-04-08 04:21:13 | Arunachal Pradesh, India | ||
2247334 | 2247334 | 2021-04-07 | India | Assam | 219027 | 1111 | 215722 | 2194 | 26.357149 | 92.830441 | 2021-04-08 04:21:13 | Assam, India | ||
2247335 | 2247335 | 2021-04-07 | India | Bihar | 271919 | 1591 | 264402 | 5926 | 25.679658 | 85.60484 | 2021-04-08 04:21:13 | Bihar, India | ||
2247336 | 2247336 | 2021-04-07 | India | Chandigarh | 29197 | 388 | 25688 | 3121 | 30.733839 | 76.76827800000002 | 2021-04-08 04:21:13 | Chandigarh, India | ||
2247337 | 2247337 | 2021-04-07 | India | Chhattisgarh | 396579 | 4469 | 333227 | 58883 | 21.264705 | 82.035366 | 2021-04-08 04:21:13 | Chhattisgarh, India | ||
2247338 | 2247338 | 2021-04-07 | India | Dadra and Nagar Haveli and Daman and Diu | 3812 | 2 | 3619 | 191 | 20.194742 | 73.080901 | 2021-04-08 04:21:13 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2247339 | 2247339 | 2021-04-07 | India | Delhi | 690568 | 11133 | 659980 | 19455 | 28.646519 | 77.10898 | 2021-04-08 04:21:13 | Delhi, India | ||
2247340 | 2247340 | 2021-04-07 | India | Goa | 60229 | 840 | 56531 | 2858 | 15.359682 | 74.057396 | 2021-04-08 04:21:13 | Goa, India | ||
2247341 | 2247341 | 2021-04-07 | India | Gujarat | 328453 | 4620 | 305149 | 18684 | 22.694884 | 71.590923 | 2021-04-08 04:21:13 | Gujarat, India | ||
2247342 | 2247342 | 2021-04-07 | India | Haryana | 304638 | 3219 | 286182 | 15237 | 29.20004 | 76.332824 | 2021-04-08 04:21:13 | Haryana, India | ||
2247343 | 2247343 | 2021-04-07 | India | Himachal Pradesh | 66890 | 1090 | 61642 | 4158 | 31.927213 | 77.233081 | 2021-04-08 04:21:13 | Himachal Pradesh, India | ||
2247344 | 2247344 | 2021-04-07 | India | Jammu and Kashmir | 134827 | 2018 | 127774 | 5035 | 33.75943 | 76.612638 | 2021-04-08 04:21:13 | Jammu and Kashmir, India | ||
2247345 | 2247345 | 2021-04-07 | India | Jharkhand | 130908 | 1151 | 121885 | 7872 | 23.654536 | 85.557631 | 2021-04-08 04:21:13 | Jharkhand, India | ||
2247346 | 2247346 | 2021-04-07 | India | Karnataka | 1033560 | 12731 | 971556 | 49273 | 14.70518 | 76.166436 | 2021-04-08 04:21:13 | Karnataka, India | ||
2247347 | 2247347 | 2021-04-07 | India | Kerala | 1144594 | 4710 | 1108078 | 31806 | 10.450898 | 76.405749 | 2021-04-08 04:21:13 | Kerala, India | ||
2247348 | 2247348 | 2021-04-07 | India | Ladakh | 10412 | 130 | 9836 | 446 | 34.1526 | 77.5771 | 2021-04-08 04:21:13 | Ladakh, India | ||
2247349 | 2247349 | 2021-04-07 | India | Lakshadweep | 770 | 1 | 716 | 53 | 13.6999972 | 72.18333259999999 | 2021-04-08 04:21:13 | Lakshadweep, India | ||
2247350 | 2247350 | 2021-04-07 | India | Madhya Pradesh | 318014 | 4086 | 287869 | 26059 | 23.541513 | 78.289633 | 2021-04-08 04:21:13 | Madhya Pradesh, India | ||
2247351 | 2247351 | 2021-04-07 | India | Maharashtra | 3173261 | 56652 | 2613627 | 502982 | 19.449759 | 76.108221 | 2021-04-08 04:21:13 | Maharashtra, India | ||
2247352 | 2247352 | 2021-04-07 | India | Manipur | 29447 | 374 | 28998 | 75 | 24.738975 | 93.882541 | 2021-04-08 04:21:13 | Manipur, India | ||
2247353 | 2247353 | 2021-04-07 | India | Meghalaya | 14140 | 150 | 13882 | 108 | 25.536934 | 91.278882 | 2021-04-08 04:21:13 | Meghalaya, India | ||
2247354 | 2247354 | 2021-04-07 | India | Mizoram | 4522 | 11 | 4451 | 60 | 23.309381 | 92.83822 | 2021-04-08 04:21:13 | Mizoram, India | ||
2247355 | 2247355 | 2021-04-07 | India | Nagaland | 12376 | 92 | 12143 | 141 | 26.06702 | 94.470302 | 2021-04-08 04:21:13 | Nagaland, India | ||
2247356 | 2247356 | 2021-04-07 | India | Odisha | 344647 | 1923 | 338662 | 4062 | 20.505428 | 84.418059 | 2021-04-08 04:21:13 | Odisha, India | ||
2247357 | 2247357 | 2021-04-07 | India | Puducherry | 42949 | 687 | 40442 | 1820 | 11.882658 | 78.86498 | 2021-04-08 04:21:13 | Puducherry, India | ||
2247358 | 2247358 | 2021-04-07 | India | Punjab | 260020 | 7278 | 226887 | 25855 | 30.841465000000003 | 75.40879 | 2021-04-08 04:21:13 | Punjab, India | ||
2247359 | 2247359 | 2021-04-07 | India | Rajasthan | 346791 | 2866 | 325779 | 18146 | 26.583423 | 73.847973 | 2021-04-08 04:21:13 | Rajasthan, India | ||
2247360 | 2247360 | 2021-04-07 | India | Sikkim | 6317 | 136 | 6086 | 95 | 27.571671 | 88.472712 | 2021-04-08 04:21:13 | Sikkim, India | ||
2247361 | 2247361 | 2021-04-07 | India | Tamil Nadu | 911110 | 12821 | 870546 | 27743 | 11.006091 | 78.400624 | 2021-04-08 04:21:13 | Tamil Nadu, India | ||
2247362 | 2247362 | 2021-04-07 | India | Telangana | 319054 | 1741 | 303601 | 13712 | 18.1124 | 79.0193 | 2021-04-08 04:21:13 | Telangana, India | ||
2247363 | 2247363 | 2021-04-07 | India | Tripura | 33612 | 393 | 33095 | 124 | 23.746783 | 91.743565 | 2021-04-08 04:21:13 | Tripura, India | ||
2247364 | 2247364 | 2021-04-07 | India | Unknown | 0 | 0 | 0 | 0 | 2021-04-08 04:21:13 | Unknown, India | ||||
2247365 | 2247365 | 2021-04-07 | India | Uttar Pradesh | 645930 | 8964 | 604979 | 31987 | 26.925425 | 80.560982 | 2021-04-08 04:21:13 | Uttar Pradesh, India | ||
2247366 | 2247366 | 2021-04-07 | India | Uttarakhand | 104711 | 1741 | 98444 | 4526 | 30.156447 | 79.197608 | 2021-04-08 04:21:13 | Uttarakhand, India | ||
2247367 | 2247367 | 2021-04-07 | India | West Bengal | 600024 | 10363 | 575371 | 14290 | 23.814082 | 87.979803 | 2021-04-08 04:21:13 | West Bengal, India | ||
2247368 | 2247368 | 2021-04-07 | Indonesia | 1547376 | 42064 | 1391742 | 113570 | -0.7893 | 113.9213 | 2021-04-08 04:21:13 | Indonesia | |||
2247369 | 2247369 | 2021-04-07 | Iran | 1984348 | 63699 | 1675891 | 244758 | 32.427908 | 53.68804599999999 | 2021-04-08 04:21:13 | Iran | |||
2247370 | 2247370 | 2021-04-07 | Iraq | 895622 | 14572 | 794444 | 86606 | 33.223191 | 43.679291 | 2021-04-08 04:21:13 | Iraq | |||
2247371 | 2247371 | 2021-04-07 | Ireland | 239325 | 4732 | 23364 | 211229 | 53.1424 | -7.6921 | 2021-04-08 04:21:13 | Ireland | |||
2247372 | 2247372 | 2021-04-07 | Israel | 835216 | 6266 | 824160 | 4790 | 31.046051 | 34.851612 | 2021-04-08 04:21:13 | Israel | |||
2247373 | 2247373 | 2021-04-07 | Italy | Abruzzo | 66878 | 2200 | 54281 | 10397 | 42.35122196 | 13.39843823 | 2021-04-08 04:21:13 | Abruzzo, Italy | ||
2247374 | 2247374 | 2021-04-07 | Italy | Basilicata | 20197 | 470 | 14808 | 4919 | 40.63947052 | 15.80514834 | 2021-04-08 04:21:13 | Basilicata, Italy | ||
2247375 | 2247375 | 2021-04-07 | Italy | Calabria | 49596 | 872 | 37281 | 11443 | 38.90597598 | 16.59440194 | 2021-04-08 04:21:13 | Calabria, Italy | ||
2247376 | 2247376 | 2021-04-07 | Italy | Campania | 348959 | 5653 | 252199 | 91107 | 40.83956555 | 14.25084984 | 2021-04-08 04:21:13 | Campania, Italy | ||
2247377 | 2247377 | 2021-04-07 | Italy | Emilia-Romagna | 345753 | 12246 | 264532 | 68975 | 44.49436681 | 11.3417208 | 2021-04-08 04:21:13 | Emilia-Romagna, Italy | ||
2247378 | 2247378 | 2021-04-07 | Italy | Friuli Venezia Giulia | 100016 | 3424 | 83630 | 12962 | 45.6494354 | 13.76813649 | 2021-04-08 04:21:13 | Friuli Venezia Giulia, Italy | ||
2247379 | 2247379 | 2021-04-07 | Italy | Lazio | 295977 | 6895 | 236271 | 52811 | 41.89277044 | 12.48366722 | 2021-04-08 04:21:13 | Lazio, Italy | ||
2247380 | 2247380 | 2021-04-07 | Italy | Liguria | 92379 | 3922 | 80485 | 7972 | 44.41149315 | 8.9326992 | 2021-04-08 04:21:13 | Liguria, Italy | ||
2247381 | 2247381 | 2021-04-07 | Italy | Lombardia | 755811 | 31373 | 642145 | 82293 | 45.46679409 | 9.190347404 | 2021-04-08 04:21:13 | Lombardia, 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]);