johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by recovered
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region, day
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▼ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28720 | 28720 | 2021-11-11 | Spain | Navarra | 84270 | 1255 | 0 | 42.6954 | -1.6761 | 2021-11-12 04:22:01 | Navarra, Spain | |||
28721 | 28721 | 2021-11-11 | Spain | Pais Vasco | 266368 | 5034 | 0 | 42.9896 | -2.6189 | 2021-11-12 04:22:01 | Pais Vasco, Spain | |||
28722 | 28722 | 2021-11-11 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
28723 | 28723 | 2021-11-11 | Sri Lanka | 548061 | 13927 | 0 | 7.873054 | 80.77179699999998 | 2021-11-12 04:22:01 | Sri Lanka | ||||
28724 | 28724 | 2021-11-11 | Sudan | 41093 | 3099 | 0 | 12.8628 | 30.2176 | 2021-11-12 04:22:01 | Sudan | ||||
28725 | 28725 | 2021-11-11 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-11-12 04:22:01 | Summer Olympics 2020 | ||||
28726 | 28726 | 2021-11-11 | Suriname | 49902 | 1126 | 0 | 3.9193 | -56.0278 | 2021-11-12 04:22:01 | Suriname | ||||
28727 | 28727 | 2021-11-11 | Sweden | Blekinge | 13662 | 131 | 0 | 56.2784 | 15.017999999999999 | 2021-11-12 04:22:01 | Blekinge, Sweden | |||
28728 | 28728 | 2021-11-11 | Sweden | Dalarna | 29000 | 358 | 0 | 61.0917 | 14.6664 | 2021-11-12 04:22:01 | Dalarna, Sweden | |||
28729 | 28729 | 2021-11-11 | Sweden | Gavleborg | 37880 | 564 | 0 | 61.3012 | 16.1534 | 2021-11-12 04:22:01 | Gavleborg, Sweden | |||
28730 | 28730 | 2021-11-11 | Sweden | Gotland | 4588 | 54 | 0 | 57.4684 | 18.4867 | 2021-11-12 04:22:01 | Gotland, Sweden | |||
28731 | 28731 | 2021-11-11 | Sweden | Halland | 43616 | 328 | 0 | 56.8967 | 12.8034 | 2021-11-12 04:22:01 | Halland, Sweden | |||
28732 | 28732 | 2021-11-11 | Sweden | Jamtland Harjedalen | 13287 | 128 | 0 | 63.1712 | 14.9592 | 2021-11-12 04:22:01 | Jamtland Harjedalen, Sweden | |||
28733 | 28733 | 2021-11-11 | Sweden | Jonkoping | 46004 | 566 | 0 | 57.3708 | 14.3439 | 2021-11-12 04:22:01 | Jonkoping, Sweden | |||
28734 | 28734 | 2021-11-11 | Sweden | Kalmar | 26087 | 251 | 0 | 57.235 | 16.1849 | 2021-11-12 04:22:01 | Kalmar, Sweden | |||
28735 | 28735 | 2021-11-11 | Sweden | Kronoberg | 23820 | 326 | 0 | 56.7183 | 14.4115 | 2021-11-12 04:22:01 | Kronoberg, Sweden | |||
28736 | 28736 | 2021-11-11 | Sweden | Norrbotten | 28470 | 294 | 0 | 66.8309 | 20.3992 | 2021-11-12 04:22:01 | Norrbotten, Sweden | |||
28737 | 28737 | 2021-11-11 | Sweden | Orebro | 34924 | 353 | 0 | 59.535 | 15.0066 | 2021-11-12 04:22:01 | Orebro, Sweden | |||
28738 | 28738 | 2021-11-11 | Sweden | Ostergotland | 45248 | 659 | 0 | 58.3454 | 15.5198 | 2021-11-12 04:22:01 | Ostergotland, Sweden | |||
28739 | 28739 | 2021-11-11 | Sweden | Skane | 167690 | 1800 | 0 | 55.9903 | 13.5958 | 2021-11-12 04:22:01 | Skane, Sweden | |||
28740 | 28740 | 2021-11-11 | Sweden | Sormland | 27935 | 482 | 0 | 59.0336 | 16.7519 | 2021-11-12 04:22:01 | Sormland, Sweden | |||
28741 | 28741 | 2021-11-11 | Sweden | Stockholm | 282476 | 4511 | 0 | 59.6025 | 18.1384 | 2021-11-12 04:22:01 | Stockholm, Sweden | |||
28742 | 28742 | 2021-11-11 | Sweden | Uppsala | 43350 | 548 | 0 | 60.0092 | 17.2715 | 2021-11-12 04:22:01 | Uppsala, Sweden | |||
28743 | 28743 | 2021-11-11 | Sweden | Varmland | 21897 | 223 | 0 | 59.7294 | 13.2354 | 2021-11-12 04:22:01 | Varmland, Sweden | |||
28744 | 28744 | 2021-11-11 | Sweden | Vasterbotten | 26611 | 202 | 0 | 65.3337 | 16.5162 | 2021-11-12 04:22:01 | Vasterbotten, Sweden | |||
28745 | 28745 | 2021-11-11 | Sweden | Vasternorrland | 27907 | 487 | 0 | 63.4276 | 17.7292 | 2021-11-12 04:22:01 | Vasternorrland, Sweden | |||
28746 | 28746 | 2021-11-11 | Sweden | Vastmanland | 31493 | 369 | 0 | 59.6714 | 16.2159 | 2021-11-12 04:22:01 | Vastmanland, Sweden | |||
28747 | 28747 | 2021-11-11 | Sweden | Vastra Gotaland | 205587 | 2444 | 0 | 58.2528 | 13.0596 | 2021-11-12 04:22:01 | Vastra Gotaland, Sweden | |||
28748 | 28748 | 2021-11-11 | Switzerland | 905112 | 11309 | 0 | 46.8182 | 8.2275 | 2021-11-12 04:22:01 | Switzerland | ||||
28749 | 28749 | 2021-11-11 | Syria | 45820 | 2650 | 0 | 34.802075 | 38.99681500000001 | 2021-11-12 04:22:01 | Syria | ||||
28750 | 28750 | 2021-11-11 | Taiwan* | 16465 | 848 | 0 | 23.7 | 121.0 | 2021-11-12 04:22:01 | Taiwan* | ||||
28751 | 28751 | 2021-11-11 | Tajikistan | 17488 | 125 | 0 | 38.861 | 71.2761 | 2021-11-12 04:22:01 | Tajikistan | ||||
28752 | 28752 | 2021-11-11 | Tanzania | 26196 | 725 | 0 | -6.369028 | 34.888822 | 2021-11-12 04:22:01 | Tanzania | ||||
28753 | 28753 | 2021-11-11 | Thailand | 1996969 | 19883 | 0 | 15.870032 | 100.992541 | 2021-11-12 04:22:01 | Thailand | ||||
28754 | 28754 | 2021-11-11 | Timor-Leste | 19809 | 122 | 0 | -8.874217 | 125.727539 | 2021-11-12 04:22:01 | Timor-Leste | ||||
28755 | 28755 | 2021-11-11 | Togo | 26133 | 243 | 0 | 8.6195 | 0.8248 | 2021-11-12 04:22:01 | Togo | ||||
28756 | 28756 | 2021-11-11 | Tonga | 1 | 0 | 0 | -21.179000000000002 | -175.1982 | 2021-11-12 04:22:01 | Tonga | ||||
28757 | 28757 | 2021-11-11 | Trinidad and Tobago | 60984 | 1818 | 0 | 10.6918 | -61.2225 | 2021-11-12 04:22:01 | Trinidad and Tobago | ||||
28758 | 28758 | 2021-11-11 | Tunisia | 715489 | 25298 | 0 | 33.886917 | 9.537499 | 2021-11-12 04:22:01 | Tunisia | ||||
28759 | 28759 | 2021-11-11 | Turkey | 8340322 | 72910 | 0 | 38.9637 | 35.2433 | 2021-11-12 04:22:01 | Turkey | ||||
28760 | 28760 | 2021-11-11 | US | Alabama | Autauga | 1001 | 10373 | 152 | 0 | 32.53952745 | -86.64408227 | 2021-11-12 04:22:01 | Autauga, Alabama, US | |
28761 | 28761 | 2021-11-11 | US | Alabama | Baldwin | 1003 | 37785 | 580 | 0 | 30.72774991 | -87.72207058 | 2021-11-12 04:22:01 | Baldwin, Alabama, US | |
28762 | 28762 | 2021-11-11 | US | Alabama | Barbour | 1005 | 3631 | 79 | 0 | 31.868263 | -85.3871286 | 2021-11-12 04:22:01 | Barbour, Alabama, US | |
28763 | 28763 | 2021-11-11 | US | Alabama | Bibb | 1007 | 4310 | 92 | 0 | 32.99642064 | -87.12511459999996 | 2021-11-12 04:22:01 | Bibb, Alabama, US | |
28764 | 28764 | 2021-11-11 | US | Alabama | Blount | 1009 | 10494 | 187 | 0 | 33.98210918 | -86.56790593 | 2021-11-12 04:22:01 | Blount, Alabama, US | |
28765 | 28765 | 2021-11-11 | US | Alabama | Bullock | 1011 | 1519 | 44 | 0 | 32.10030533 | -85.71265535 | 2021-11-12 04:22:01 | Bullock, Alabama, US | |
28766 | 28766 | 2021-11-11 | US | Alabama | Butler | 1013 | 3387 | 99 | 0 | 31.75300095 | -86.68057478 | 2021-11-12 04:22:01 | Butler, Alabama, US | |
28767 | 28767 | 2021-11-11 | US | Alabama | Calhoun | 1015 | 22371 | 513 | 0 | 33.77483727 | -85.82630386 | 2021-11-12 04:22:01 | Calhoun, Alabama, US | |
28768 | 28768 | 2021-11-11 | US | Alabama | Chambers | 1017 | 5800 | 144 | 0 | 32.91360079 | -85.39072749 | 2021-11-12 04:22:01 | Chambers, Alabama, US | |
28769 | 28769 | 2021-11-11 | US | Alabama | Cherokee | 1019 | 3111 | 62 | 0 | 34.17805983 | -85.60638968 | 2021-11-12 04:22:01 | Cherokee, Alabama, US | |
28770 | 28770 | 2021-11-11 | US | Alabama | Chilton | 1021 | 6895 | 168 | 0 | 32.85044126 | -86.7173256 | 2021-11-12 04:22:01 | Chilton, Alabama, US | |
28771 | 28771 | 2021-11-11 | US | Alabama | Choctaw | 1023 | 914 | 28 | 0 | 32.02227341 | -88.26564429999998 | 2021-11-12 04:22:01 | Choctaw, Alabama, US | |
28772 | 28772 | 2021-11-11 | US | Alabama | Clarke | 1025 | 4816 | 86 | 0 | 31.68099859 | -87.83548597 | 2021-11-12 04:22:01 | Clarke, Alabama, US | |
28773 | 28773 | 2021-11-11 | US | Alabama | Clay | 1027 | 2487 | 70 | 0 | 33.26984193 | -85.85836077 | 2021-11-12 04:22:01 | Clay, Alabama, US | |
28774 | 28774 | 2021-11-11 | US | Alabama | Cleburne | 1029 | 2518 | 60 | 0 | 33.67679204 | -85.52005899 | 2021-11-12 04:22:01 | Cleburne, Alabama, US | |
28775 | 28775 | 2021-11-11 | US | Alabama | Coffee | 1031 | 9358 | 193 | 0 | 31.39932826 | -85.98901039 | 2021-11-12 04:22:01 | Coffee, Alabama, US | |
28776 | 28776 | 2021-11-11 | US | Alabama | Colbert | 1033 | 9211 | 206 | 0 | 34.69847452 | -87.80168544 | 2021-11-12 04:22:01 | Colbert, Alabama, US | |
28777 | 28777 | 2021-11-11 | US | Alabama | Conecuh | 1035 | 1909 | 60 | 0 | 31.43401703 | -86.99320044 | 2021-11-12 04:22:01 | Conecuh, Alabama, US | |
28778 | 28778 | 2021-11-11 | US | Alabama | Coosa | 1037 | 1836 | 43 | 0 | 32.93690146 | -86.24847739 | 2021-11-12 04:22:01 | Coosa, Alabama, US | |
28779 | 28779 | 2021-11-11 | US | Alabama | Covington | 1039 | 6839 | 191 | 0 | 31.247785399999998 | -86.45050893 | 2021-11-12 04:22:01 | Covington, Alabama, US | |
28780 | 28780 | 2021-11-11 | US | Alabama | Crenshaw | 1041 | 2562 | 75 | 0 | 31.72941803 | -86.31593104 | 2021-11-12 04:22:01 | Crenshaw, Alabama, US | |
28781 | 28781 | 2021-11-11 | US | Alabama | Cullman | 1043 | 15880 | 299 | 0 | 34.13020303 | -86.86888037 | 2021-11-12 04:22:01 | Cullman, Alabama, US | |
28782 | 28782 | 2021-11-11 | US | Alabama | Dale | 1045 | 8984 | 188 | 0 | 31.43037123 | -85.61095742 | 2021-11-12 04:22:01 | Dale, Alabama, US | |
28783 | 28783 | 2021-11-11 | US | Alabama | Dallas | 1047 | 5253 | 207 | 0 | 32.32688101 | -87.10866709999998 | 2021-11-12 04:22:01 | Dallas, Alabama, US | |
28784 | 28784 | 2021-11-11 | US | Alabama | DeKalb | 1049 | 12784 | 268 | 0 | 34.45946862 | -85.80782906 | 2021-11-12 04:22:01 | DeKalb, Alabama, US | |
28785 | 28785 | 2021-11-11 | US | Alabama | Elmore | 1051 | 15730 | 291 | 0 | 32.59785413 | -86.14415284 | 2021-11-12 04:22:01 | Elmore, Alabama, US | |
28786 | 28786 | 2021-11-11 | US | Alabama | Escambia | 1053 | 6902 | 139 | 0 | 31.1256789 | -87.15918694 | 2021-11-12 04:22:01 | Escambia, Alabama, US | |
28787 | 28787 | 2021-11-11 | US | Alabama | Etowah | 1055 | 19956 | 514 | 0 | 34.04567266 | -86.04051873 | 2021-11-12 04:22:01 | Etowah, Alabama, US | |
28788 | 28788 | 2021-11-11 | US | Alabama | Fayette | 1057 | 3188 | 85 | 0 | 33.72076938 | -87.73886638 | 2021-11-12 04:22:01 | Fayette, Alabama, US | |
28789 | 28789 | 2021-11-11 | US | Alabama | Franklin | 1059 | 6192 | 107 | 0 | 34.44235334 | -87.84289505 | 2021-11-12 04:22:01 | Franklin, Alabama, US | |
28790 | 28790 | 2021-11-11 | US | Alabama | Geneva | 1061 | 4610 | 133 | 0 | 31.09389027 | -85.83572839 | 2021-11-12 04:22:01 | Geneva, Alabama, US | |
28791 | 28791 | 2021-11-11 | US | Alabama | Greene | 1063 | 1293 | 44 | 0 | 32.85504247 | -87.95684022 | 2021-11-12 04:22:01 | Greene, Alabama, US | |
28792 | 28792 | 2021-11-11 | US | Alabama | Hale | 1065 | 3149 | 88 | 0 | 32.76039258 | -87.63284988 | 2021-11-12 04:22:01 | Hale, Alabama, US | |
28793 | 28793 | 2021-11-11 | US | Alabama | Henry | 1067 | 3173 | 66 | 0 | 31.51148016 | -85.24267944 | 2021-11-12 04:22:01 | Henry, Alabama, US | |
28794 | 28794 | 2021-11-11 | US | Alabama | Houston | 1069 | 17608 | 420 | 0 | 31.15197924 | -85.29939599 | 2021-11-12 04:22:01 | Houston, Alabama, US | |
28795 | 28795 | 2021-11-11 | US | Alabama | Jackson | 1071 | 10131 | 194 | 0 | 34.78144169 | -85.99750489 | 2021-11-12 04:22:01 | Jackson, Alabama, US | |
28796 | 28796 | 2021-11-11 | US | Alabama | Jefferson | 1073 | 115849 | 1993 | 0 | 33.55554728 | -86.89506300000002 | 2021-11-12 04:22:01 | Jefferson, Alabama, US | |
28797 | 28797 | 2021-11-11 | US | Alabama | Lamar | 1075 | 2418 | 51 | 0 | 33.77995024 | -88.09668032 | 2021-11-12 04:22:01 | Lamar, Alabama, US | |
28798 | 28798 | 2021-11-11 | US | Alabama | Lauderdale | 1077 | 14799 | 303 | 0 | 34.90171875 | -87.65624729 | 2021-11-12 04:22:01 | Lauderdale, Alabama, US | |
28799 | 28799 | 2021-11-11 | US | Alabama | Lawrence | 1079 | 4703 | 125 | 0 | 34.52041498 | -87.31069453 | 2021-11-12 04:22:01 | Lawrence, Alabama, US | |
28800 | 28800 | 2021-11-11 | US | Alabama | Lee | 1081 | 25382 | 260 | 0 | 32.60154883 | -85.35132246 | 2021-11-12 04:22:01 | Lee, Alabama, US | |
28801 | 28801 | 2021-11-11 | US | Alabama | Limestone | 1083 | 15967 | 217 | 0 | 34.81185586 | -86.98310072 | 2021-11-12 04:22:01 | Limestone, Alabama, US | |
28802 | 28802 | 2021-11-11 | US | Alabama | Lowndes | 1085 | 1778 | 67 | 0 | 32.1597283 | -86.65158371 | 2021-11-12 04:22:01 | Lowndes, Alabama, US | |
28803 | 28803 | 2021-11-11 | US | Alabama | Macon | 1087 | 2431 | 64 | 0 | 32.38759944 | -85.69267724 | 2021-11-12 04:22:01 | Macon, Alabama, US | |
28804 | 28804 | 2021-11-11 | US | Alabama | Madison | 1089 | 52886 | 724 | 0 | 34.76327133 | -86.55069633 | 2021-11-12 04:22:01 | Madison, Alabama, US | |
28805 | 28805 | 2021-11-11 | US | Alabama | Marengo | 1091 | 3409 | 93 | 0 | 32.24767634 | -87.78796182 | 2021-11-12 04:22:01 | Marengo, Alabama, US | |
28806 | 28806 | 2021-11-11 | US | Alabama | Marion | 1093 | 5341 | 128 | 0 | 34.13697363 | -87.88704173 | 2021-11-12 04:22:01 | Marion, Alabama, US | |
28807 | 28807 | 2021-11-11 | US | Alabama | Marshall | 1095 | 18685 | 312 | 0 | 34.36975964 | -86.30486727 | 2021-11-12 04:22:01 | Marshall, Alabama, US | |
28808 | 28808 | 2021-11-11 | US | Alabama | Mobile | 1097 | 73659 | 1368 | 0 | 30.78472347 | -88.20842409 | 2021-11-12 04:22:01 | Mobile, Alabama, US | |
28809 | 28809 | 2021-11-11 | US | Alabama | Monroe | 1099 | 3345 | 66 | 0 | 31.56729412 | -87.36995001 | 2021-11-12 04:22:01 | Monroe, Alabama, US | |
28810 | 28810 | 2021-11-11 | US | Alabama | Montgomery | 1101 | 34337 | 778 | 0 | 32.2206831 | -86.20969272 | 2021-11-12 04:22:01 | Montgomery, Alabama, US | |
28811 | 28811 | 2021-11-11 | US | Alabama | Morgan | 1103 | 22177 | 398 | 0 | 34.45500589 | -86.85475946 | 2021-11-12 04:22:01 | Morgan, Alabama, US | |
28812 | 28812 | 2021-11-11 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
28813 | 28813 | 2021-11-11 | US | Alabama | Perry | 1105 | 1415 | 40 | 0 | 32.64048341 | -87.29770589 | 2021-11-12 04:22:01 | Perry, Alabama, US | |
28814 | 28814 | 2021-11-11 | US | Alabama | Pickens | 1107 | 3288 | 85 | 0 | 33.28094866 | -88.08818103 | 2021-11-12 04:22:01 | Pickens, Alabama, US | |
28815 | 28815 | 2021-11-11 | US | Alabama | Pike | 1109 | 5065 | 108 | 0 | 31.80396383 | -85.9408295 | 2021-11-12 04:22:01 | Pike, Alabama, US | |
28816 | 28816 | 2021-11-11 | US | Alabama | Randolph | 1111 | 3320 | 66 | 0 | 33.29526734 | -85.45708831 | 2021-11-12 04:22:01 | Randolph, Alabama, US | |
28817 | 28817 | 2021-11-11 | US | Alabama | Russell | 1113 | 7021 | 63 | 0 | 32.28725256 | -85.18415324 | 2021-11-12 04:22:01 | Russell, Alabama, US | |
28818 | 28818 | 2021-11-11 | US | Alabama | Shelby | 1117 | 38050 | 362 | 0 | 33.26879845 | -86.66232561 | 2021-11-12 04:22:01 | Shelby, Alabama, US | |
28819 | 28819 | 2021-11-11 | US | Alabama | St. Clair | 1115 | 16744 | 350 | 0 | 33.71902176 | -86.31029372 | 2021-11-12 04:22:01 | St. Clair, Alabama, US |
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]);