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
day (date) >30 ✖
- 2020-08-05 3,977
- 2020-08-06 3,977
- 2020-08-07 3,977
- 2020-08-08 3,977
- 2020-08-09 3,977
- 2020-08-10 3,977
- 2020-08-04 3,973
- 2020-07-29 3,972
- 2020-07-30 3,972
- 2020-07-31 3,972
- 2020-08-01 3,972
- 2020-08-02 3,972
- 2020-08-03 3,972
- 2020-07-28 3,969
- 2020-07-26 3,968
- 2020-07-27 3,968
- 2020-07-25 3,967
- 2020-07-24 3,966
- 2020-07-23 3,965
- 2020-07-22 3,962
- 2020-07-21 3,961
- 2020-07-20 3,958
- 2020-07-19 3,956
- 2020-07-18 3,955
- 2020-08-11 3,879
- 2020-07-17 3,874
- 2020-07-16 3,861
- 2020-07-15 3,859
- 2020-07-14 3,858
- 2020-07-13 3,852
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
662101 | 662101 | 2020-08-11 | China | Beijing | 935 | 9 | 920 | 6 | 40.1824 | 116.4142 | 2020-08-12 04:27:29 | Beijing, China | ||
662102 | 662102 | 2020-08-11 | China | Chongqing | 583 | 6 | 577 | 0 | 30.0572 | 107.874 | 2020-08-12 04:27:29 | Chongqing, China | ||
662103 | 662103 | 2020-08-11 | China | Fujian | 368 | 1 | 363 | 4 | 26.0789 | 117.9874 | 2020-08-12 04:27:29 | Fujian, China | ||
662104 | 662104 | 2020-08-11 | China | Gansu | 169 | 2 | 165 | 2 | 35.7518 | 104.2861 | 2020-08-12 04:27:29 | Gansu, China | ||
662105 | 662105 | 2020-08-11 | China | Guangdong | 1699 | 8 | 1676 | 15 | 23.3417 | 113.4244 | 2020-08-12 04:27:29 | Guangdong, China | ||
662106 | 662106 | 2020-08-11 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-12 04:27:29 | Guangxi, China | ||
662107 | 662107 | 2020-08-11 | China | Guizhou | 147 | 2 | 145 | 0 | 26.8154 | 106.8748 | 2020-08-12 04:27:29 | Guizhou, China | ||
662108 | 662108 | 2020-08-11 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-08-12 04:27:29 | Hainan, China | ||
662109 | 662109 | 2020-08-11 | China | Hebei | 350 | 6 | 343 | 1 | 37.8957 | 114.9042 | 2020-08-12 04:27:29 | Hebei, China | ||
662110 | 662110 | 2020-08-11 | China | Heilongjiang | 948 | 13 | 934 | 1 | 47.862 | 127.7615 | 2020-08-12 04:27:29 | Heilongjiang, China | ||
662111 | 662111 | 2020-08-11 | China | Henan | 1276 | 22 | 1254 | 0 | 33.882 | 113.614 | 2020-08-12 04:27:29 | Henan, China | ||
662112 | 662112 | 2020-08-11 | China | Hong Kong | 4181 | 58 | 3052 | 1070 | 22.3 | 114.2 | 2020-08-12 04:27:29 | Hong Kong, China | ||
662113 | 662113 | 2020-08-11 | China | Hubei | 68139 | 4512 | 63623 | 4 | 30.9756 | 112.2707 | 2020-08-12 04:27:29 | Hubei, China | ||
662114 | 662114 | 2020-08-11 | China | Hunan | 1019 | 4 | 1015 | 0 | 27.6104 | 111.7088 | 2020-08-12 04:27:29 | Hunan, China | ||
662115 | 662115 | 2020-08-11 | China | Inner Mongolia | 259 | 1 | 254 | 4 | 44.0935 | 113.9448 | 2020-08-12 04:27:29 | Inner Mongolia, China | ||
662116 | 662116 | 2020-08-11 | China | Jiangsu | 659 | 0 | 656 | 3 | 32.9711 | 119.455 | 2020-08-12 04:27:29 | Jiangsu, China | ||
662117 | 662117 | 2020-08-11 | China | Jiangxi | 932 | 1 | 931 | 0 | 27.614 | 115.7221 | 2020-08-12 04:27:29 | Jiangxi, China | ||
662118 | 662118 | 2020-08-11 | China | Jilin | 157 | 2 | 154 | 1 | 43.6661 | 126.1923 | 2020-08-12 04:27:29 | Jilin, China | ||
662119 | 662119 | 2020-08-11 | China | Liaoning | 261 | 2 | 191 | 68 | 41.2956 | 122.6085 | 2020-08-12 04:27:29 | Liaoning, China | ||
662120 | 662120 | 2020-08-11 | China | Macau | 46 | 0 | 46 | 0 | 22.1667 | 113.55 | 2020-08-12 04:27:29 | Macau, China | ||
662121 | 662121 | 2020-08-11 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-08-12 04:27:29 | Ningxia, China | ||
662122 | 662122 | 2020-08-11 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2020-08-12 04:27:29 | Qinghai, China | ||
662123 | 662123 | 2020-08-11 | China | Shaanxi | 341 | 3 | 323 | 15 | 35.1917 | 108.8701 | 2020-08-12 04:27:29 | Shaanxi, China | ||
662124 | 662124 | 2020-08-11 | China | Shandong | 817 | 7 | 788 | 22 | 36.3427 | 118.1498 | 2020-08-12 04:27:29 | Shandong, China | ||
662125 | 662125 | 2020-08-11 | China | Shanghai | 798 | 7 | 737 | 54 | 31.202 | 121.4491 | 2020-08-12 04:27:29 | Shanghai, China | ||
662126 | 662126 | 2020-08-11 | China | Shanxi | 201 | 0 | 201 | 0 | 37.5777 | 112.2922 | 2020-08-12 04:27:29 | Shanxi, China | ||
662127 | 662127 | 2020-08-11 | China | Sichuan | 616 | 3 | 600 | 13 | 30.6171 | 102.7103 | 2020-08-12 04:27:29 | Sichuan, China | ||
662128 | 662128 | 2020-08-11 | China | Tianjin | 205 | 3 | 202 | 0 | 39.3054 | 117.323 | 2020-08-12 04:27:29 | Tianjin, China | ||
662129 | 662129 | 2020-08-11 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2020-08-12 04:27:29 | Tibet, China | ||
662130 | 662130 | 2020-08-11 | China | Xinjiang | 875 | 3 | 337 | 535 | 41.1129 | 85.2401 | 2020-08-12 04:27:29 | Xinjiang, China | ||
662131 | 662131 | 2020-08-11 | China | Yunnan | 191 | 2 | 188 | 1 | 24.974 | 101.487 | 2020-08-12 04:27:29 | Yunnan, China | ||
662132 | 662132 | 2020-08-11 | China | Zhejiang | 1275 | 1 | 1268 | 6 | 29.1832 | 120.0934 | 2020-08-12 04:27:29 | Zhejiang, China | ||
662133 | 662133 | 2020-08-11 | Colombia | Amazonas | 2626 | 105 | 2384 | 137 | -1.4429 | -71.5724 | 2020-08-12 04:27:29 | Amazonas, Colombia | ||
662134 | 662134 | 2020-08-11 | Colombia | Antioquia | 54165 | 937 | 24659 | 28569 | 7.1986 | -75.3412 | 2020-08-12 04:27:29 | Antioquia, Colombia | ||
662135 | 662135 | 2020-08-11 | Colombia | Arauca | 509 | 8 | 194 | 307 | 7.0762 | -70.7105 | 2020-08-12 04:27:29 | Arauca, Colombia | ||
662136 | 662136 | 2020-08-11 | Colombia | Atlantico | 59101 | 2715 | 46617 | 9769 | 10.6966 | -74.8741 | 2020-08-12 04:27:29 | Atlantico, Colombia | ||
662137 | 662137 | 2020-08-11 | Colombia | Bolivar | 20705 | 630 | 16428 | 3647 | 8.6704 | -74.03 | 2020-08-12 04:27:29 | Bolivar, Colombia | ||
662138 | 662138 | 2020-08-11 | Colombia | Boyaca | 1685 | 41 | 716 | 928 | 5.4545 | -73.362 | 2020-08-12 04:27:29 | Boyaca, Colombia | ||
662139 | 662139 | 2020-08-11 | Colombia | Caldas | 1416 | 20 | 476 | 920 | 5.2983 | -75.2479 | 2020-08-12 04:27:29 | Caldas, Colombia | ||
662140 | 662140 | 2020-08-11 | Colombia | Capital District | 141994 | 3883 | 70225 | 67886 | 4.711 | -74.0721 | 2020-08-12 04:27:29 | Capital District, Colombia | ||
662141 | 662141 | 2020-08-11 | Colombia | Caqueta | 2794 | 74 | 860 | 1860 | 0.8699 | -73.8419 | 2020-08-12 04:27:29 | Caqueta, Colombia | ||
662142 | 662142 | 2020-08-11 | Colombia | Casanare | 503 | 8 | 201 | 294 | 5.7589 | -71.5724 | 2020-08-12 04:27:29 | Casanare, Colombia | ||
662143 | 662143 | 2020-08-11 | Colombia | Cauca | 2775 | 98 | 1427 | 1250 | 2.705 | -76.82600000000002 | 2020-08-12 04:27:29 | Cauca, Colombia | ||
662144 | 662144 | 2020-08-11 | Colombia | Cesar | 4786 | 101 | 2286 | 2399 | 9.3373 | -73.6536 | 2020-08-12 04:27:29 | Cesar, Colombia | ||
662145 | 662145 | 2020-08-11 | Colombia | Choco | 3326 | 120 | 2647 | 559 | 5.2528 | -76.82600000000002 | 2020-08-12 04:27:29 | Choco, Colombia | ||
662146 | 662146 | 2020-08-11 | Colombia | Cordoba | 11160 | 874 | 4667 | 5619 | 8.0493 | -75.574 | 2020-08-12 04:27:29 | Cordoba, Colombia | ||
662147 | 662147 | 2020-08-11 | Colombia | Cundinamarca | 12329 | 338 | 6998 | 4993 | 5.026 | -74.03 | 2020-08-12 04:27:29 | Cundinamarca, Colombia | ||
662148 | 662148 | 2020-08-11 | Colombia | Guainia | 20 | 1 | 13 | 6 | 2.5854 | -68.5247 | 2020-08-12 04:27:29 | Guainia, Colombia | ||
662149 | 662149 | 2020-08-11 | Colombia | Guaviare | 170 | 0 | 68 | 102 | 1.0654 | -73.2603 | 2020-08-12 04:27:29 | Guaviare, Colombia | ||
662150 | 662150 | 2020-08-11 | Colombia | Huila | 1855 | 49 | 677 | 1129 | 2.5359 | -75.5277 | 2020-08-12 04:27:29 | Huila, Colombia | ||
662151 | 662151 | 2020-08-11 | Colombia | La Guajira | 2970 | 150 | 1743 | 1077 | 11.3548 | -72.5205 | 2020-08-12 04:27:29 | La Guajira, Colombia | ||
662152 | 662152 | 2020-08-11 | Colombia | Magdalena | 8832 | 445 | 5160 | 3227 | 10.4113 | -74.4057 | 2020-08-12 04:27:29 | Magdalena, Colombia | ||
662153 | 662153 | 2020-08-11 | Colombia | Meta | 4335 | 64 | 2384 | 1887 | 3.272 | -73.0877 | 2020-08-12 04:27:29 | Meta, Colombia | ||
662154 | 662154 | 2020-08-11 | Colombia | Narino | 10122 | 352 | 6289 | 3481 | 1.2892 | -77.3579 | 2020-08-12 04:27:29 | Narino, Colombia | ||
662155 | 662155 | 2020-08-11 | Colombia | Norte de Santander | 5108 | 273 | 2039 | 2796 | 7.9463 | -72.8988 | 2020-08-12 04:27:29 | Norte de Santander, Colombia | ||
662156 | 662156 | 2020-08-11 | Colombia | Putumayo | 1589 | 75 | 569 | 945 | 0.436 | -75.5277 | 2020-08-12 04:27:29 | Putumayo, Colombia | ||
662157 | 662157 | 2020-08-11 | Colombia | Quindio | 551 | 13 | 258 | 280 | 4.461 | -75.6674 | 2020-08-12 04:27:29 | Quindio, Colombia | ||
662158 | 662158 | 2020-08-11 | Colombia | Risaralda | 2817 | 53 | 1143 | 1621 | 5.3158 | -75.9928 | 2020-08-12 04:27:29 | Risaralda, Colombia | ||
662159 | 662159 | 2020-08-11 | Colombia | San Andres y Providencia | 55 | 0 | 33 | 22 | 12.5567 | -81.7185 | 2020-08-12 04:27:29 | San Andres y Providencia, Colombia | ||
662160 | 662160 | 2020-08-11 | Colombia | Santander | 7678 | 289 | 2563 | 4826 | 6.6437 | -73.6536 | 2020-08-12 04:27:29 | Santander, Colombia | ||
662161 | 662161 | 2020-08-11 | Colombia | Sucre | 7739 | 400 | 4808 | 2531 | 8.814 | -74.7233 | 2020-08-12 04:27:29 | Sucre, Colombia | ||
662162 | 662162 | 2020-08-11 | Colombia | Tolima | 3846 | 90 | 2000 | 1756 | 4.0925 | -75.1545 | 2020-08-12 04:27:29 | Tolima, Colombia | ||
662163 | 662163 | 2020-08-11 | Colombia | Valle del Cauca | 32759 | 1268 | 19833 | 11658 | 3.8009 | -76.6413 | 2020-08-12 04:27:29 | Valle del Cauca, Colombia | ||
662164 | 662164 | 2020-08-11 | Colombia | Vaupes | 128 | 1 | 60 | 67 | 0.8554 | -70.812 | 2020-08-12 04:27:29 | Vaupes, Colombia | ||
662165 | 662165 | 2020-08-11 | Colombia | Vichada | 5 | 0 | 2 | 3 | 4.4234 | -69.2878 | 2020-08-12 04:27:29 | Vichada, Colombia | ||
662166 | 662166 | 2020-08-11 | Comoros | 399 | 7 | 379 | 13 | -11.6455 | 43.3333 | 2020-08-12 04:27:29 | Comoros | |||
662167 | 662167 | 2020-08-11 | Congo (Brazzaville) | 3745 | 60 | 1625 | 2060 | -0.228 | 15.8277 | 2020-08-12 04:27:29 | Congo (Brazzaville) | |||
662168 | 662168 | 2020-08-11 | Congo (Kinshasa) | 9499 | 225 | 8375 | 899 | -4.0383 | 21.7587 | 2020-08-12 04:27:29 | Congo (Kinshasa) | |||
662169 | 662169 | 2020-08-11 | Costa Rica | 24508 | 255 | 7971 | 16282 | 9.7489 | -83.7534 | 2020-08-12 04:27:29 | Costa Rica | |||
662170 | 662170 | 2020-08-11 | Cote d'Ivoire | 16847 | 105 | 13321 | 3421 | 7.54 | -5.5471 | 2020-08-12 04:27:29 | Cote d'Ivoire | |||
662171 | 662171 | 2020-08-11 | Croatia | 5740 | 160 | 4962 | 618 | 45.1 | 15.2 | 2020-08-12 04:27:29 | Croatia | |||
662172 | 662172 | 2020-08-11 | Cuba | 3093 | 88 | 2472 | 533 | 21.521757 | -77.78116700000002 | 2020-08-12 04:27:29 | Cuba | |||
662173 | 662173 | 2020-08-11 | Cyprus | 1252 | 19 | 870 | 363 | 35.1264 | 33.4299 | 2020-08-12 04:27:29 | Cyprus | |||
662174 | 662174 | 2020-08-11 | Czechia | 18783 | 391 | 13222 | 5170 | 49.8175 | 15.473 | 2020-08-12 04:27:29 | Czechia | |||
662175 | 662175 | 2020-08-11 | Denmark | Faroe Islands | 318 | 0 | 225 | 93 | 61.8926 | -6.9118 | 2020-08-12 04:27:29 | Faroe Islands, Denmark | ||
662176 | 662176 | 2020-08-11 | Denmark | Greenland | 14 | 0 | 14 | 0 | 71.7069 | -42.6043 | 2020-08-12 04:27:29 | Greenland, Denmark | ||
662177 | 662177 | 2020-08-11 | Denmark | 14959 | 621 | 12988 | 1350 | 56.2639 | 9.5018 | 2020-08-12 04:27:29 | Denmark | |||
662178 | 662178 | 2020-08-11 | Diamond Princess | 712 | 13 | 651 | 48 | 2020-08-12 04:27:29 | Diamond Princess | |||||
662179 | 662179 | 2020-08-11 | Djibouti | 5348 | 59 | 5133 | 156 | 11.8251 | 42.5903 | 2020-08-12 04:27:29 | Djibouti | |||
662180 | 662180 | 2020-08-11 | Dominica | 18 | 0 | 18 | 0 | 15.415 | -61.371 | 2020-08-12 04:27:29 | Dominica | |||
662181 | 662181 | 2020-08-11 | Dominican Republic | 81094 | 1346 | 45666 | 34082 | 18.7357 | -70.1627 | 2020-08-12 04:27:29 | Dominican Republic | |||
662182 | 662182 | 2020-08-11 | Ecuador | 95563 | 5951 | 78610 | 11002 | -1.8312 | -78.1834 | 2020-08-12 04:27:29 | Ecuador | |||
662183 | 662183 | 2020-08-11 | Egypt | 95834 | 5059 | 54888 | 35887 | 26.820553000000004 | 30.802498 | 2020-08-12 04:27:29 | Egypt | |||
662184 | 662184 | 2020-08-11 | El Salvador | 21269 | 570 | 9875 | 10824 | 13.7942 | -88.8965 | 2020-08-12 04:27:29 | El Salvador | |||
662185 | 662185 | 2020-08-11 | Equatorial Guinea | 4821 | 83 | 2182 | 2556 | 1.6508 | 10.2679 | 2020-08-12 04:27:29 | Equatorial Guinea | |||
662186 | 662186 | 2020-08-11 | Eritrea | 285 | 0 | 248 | 37 | 15.1794 | 39.7823 | 2020-08-12 04:27:29 | Eritrea | |||
662187 | 662187 | 2020-08-11 | Estonia | 2167 | 63 | 1968 | 136 | 58.5953 | 25.0136 | 2020-08-12 04:27:29 | Estonia | |||
662188 | 662188 | 2020-08-11 | Eswatini | 3410 | 63 | 1720 | 1627 | -26.5225 | 31.4659 | 2020-08-12 04:27:29 | Eswatini | |||
662189 | 662189 | 2020-08-11 | Ethiopia | 24175 | 440 | 10696 | 13039 | 9.145 | 40.4897 | 2020-08-12 04:27:29 | Ethiopia | |||
662190 | 662190 | 2020-08-11 | Fiji | 27 | 1 | 18 | 8 | -17.7134 | 178.065 | 2020-08-12 04:27:29 | Fiji | |||
662191 | 662191 | 2020-08-11 | Finland | 7694 | 313 | 6980 | 310 | 61.92411 | 25.748151 | 2020-08-12 04:27:29 | Finland | |||
662192 | 662192 | 2020-08-11 | France | French Guiana | 8360 | 49 | 7632 | 679 | 4.0 | -53.0 | 2020-08-12 04:27:29 | French Guiana, France | ||
662193 | 662193 | 2020-08-11 | France | French Polynesia | 112 | 0 | 62 | 50 | -17.6797 | 149.4068 | 2020-08-12 04:27:29 | French Polynesia, France | ||
662194 | 662194 | 2020-08-11 | France | Guadeloupe | 317 | 14 | 186 | 117 | 16.265 | -61.551 | 2020-08-12 04:27:29 | Guadeloupe, France | ||
662195 | 662195 | 2020-08-11 | France | Martinique | 336 | 16 | 98 | 222 | 14.6415 | -61.0242 | 2020-08-12 04:27:29 | Martinique, France | ||
662196 | 662196 | 2020-08-11 | France | Mayotte | 3091 | 39 | 2835 | 217 | -12.8275 | 45.166244 | 2020-08-12 04:27:29 | Mayotte, France | ||
662197 | 662197 | 2020-08-11 | France | New Caledonia | 23 | 0 | 22 | 1 | -20.904305 | 165.618042 | 2020-08-12 04:27:29 | New Caledonia, France | ||
662198 | 662198 | 2020-08-11 | France | Reunion | 702 | 5 | 631 | 66 | -21.1151 | 55.5364 | 2020-08-12 04:27:29 | Reunion, France | ||
662199 | 662199 | 2020-08-11 | France | Saint Barthelemy | 13 | 0 | 6 | 7 | 17.9 | -62.8333 | 2020-08-12 04:27:29 | Saint Barthelemy, France | ||
662200 | 662200 | 2020-08-11 | France | Saint Pierre and Miquelon | 4 | 0 | 1 | 3 | 46.8852 | -56.3159 | 2020-08-12 04:27:29 | Saint Pierre and Miquelon, France |
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]);