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
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2247182 | 2247182 | 2021-04-07 | Chile | Coquimbo | 28163 | 534 | 26647 | 982 | -29.959 | -71.3389 | 2021-04-08 04:21:13 | Coquimbo, Chile | ||
2247183 | 2247183 | 2021-04-07 | Chile | Los Lagos | 62736 | 826 | 60491 | 1419 | -41.9198 | -72.1416 | 2021-04-08 04:21:13 | Los Lagos, Chile | ||
2247184 | 2247184 | 2021-04-07 | Chile | Los Rios | 29118 | 322 | 27377 | 1419 | -40.231 | -72.3311 | 2021-04-08 04:21:13 | Los Rios, Chile | ||
2247185 | 2247185 | 2021-04-07 | Chile | Magallanes | 23371 | 353 | 22758 | 260 | -52.368 | -70.9863 | 2021-04-08 04:21:13 | Magallanes, Chile | ||
2247186 | 2247186 | 2021-04-07 | Chile | Maule | 57629 | 1025 | 53443 | 3161 | -35.5183 | -71.6885 | 2021-04-08 04:21:13 | Maule, Chile | ||
2247187 | 2247187 | 2021-04-07 | Chile | Metropolitana | 438293 | 13098 | 410457 | 14738 | -33.4376 | -70.6505 | 2021-04-08 04:21:13 | Metropolitana, Chile | ||
2247188 | 2247188 | 2021-04-07 | Chile | Nuble | 22423 | 415 | 21149 | 859 | -36.7226 | -71.7622 | 2021-04-08 04:21:13 | Nuble, Chile | ||
2247189 | 2247189 | 2021-04-07 | Chile | OHiggins | 40639 | 917 | 37780 | 1942 | -34.5755 | -71.0022 | 2021-04-08 04:21:13 | OHiggins, Chile | ||
2247190 | 2247190 | 2021-04-07 | Chile | Tarapaca | 30009 | 533 | 28384 | 1092 | -19.9232 | -69.5132 | 2021-04-08 04:21:13 | Tarapaca, Chile | ||
2247191 | 2247191 | 2021-04-07 | Chile | Unknown | 46 | 1 | 46 | 0 | 2021-04-08 04:21:13 | Unknown, Chile | ||||
2247192 | 2247192 | 2021-04-07 | Chile | Valparaiso | 70605 | 1969 | 64806 | 3830 | -33.0472 | -71.6127 | 2021-04-08 04:21:13 | Valparaiso, Chile | ||
2247193 | 2247193 | 2021-04-07 | China | Anhui | 994 | 6 | 988 | 0 | 31.8257 | 117.2264 | 2021-04-08 04:21:13 | Anhui, China | ||
2247194 | 2247194 | 2021-04-07 | China | Beijing | 1053 | 9 | 1038 | 6 | 40.1824 | 116.4142 | 2021-04-08 04:21:13 | Beijing, China | ||
2247195 | 2247195 | 2021-04-07 | China | Chongqing | 591 | 6 | 585 | 0 | 30.0572 | 107.874 | 2021-04-08 04:21:13 | Chongqing, China | ||
2247196 | 2247196 | 2021-04-07 | China | Fujian | 573 | 1 | 554 | 18 | 26.0789 | 117.9874 | 2021-04-08 04:21:13 | Fujian, China | ||
2247197 | 2247197 | 2021-04-07 | China | Gansu | 193 | 2 | 189 | 2 | 35.7518 | 104.2861 | 2021-04-08 04:21:13 | Gansu, China | ||
2247198 | 2247198 | 2021-04-07 | China | Guangdong | 2291 | 8 | 2242 | 41 | 23.3417 | 113.4244 | 2021-04-08 04:21:13 | Guangdong, China | ||
2247199 | 2247199 | 2021-04-07 | China | Guangxi | 267 | 2 | 265 | 0 | 23.8298 | 108.7881 | 2021-04-08 04:21:13 | Guangxi, China | ||
2247200 | 2247200 | 2021-04-07 | China | Guizhou | 147 | 2 | 145 | 0 | 26.8154 | 106.8748 | 2021-04-08 04:21:13 | Guizhou, China | ||
2247201 | 2247201 | 2021-04-07 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-08 04:21:13 | Hainan, China | ||
2247202 | 2247202 | 2021-04-07 | China | Hebei | 1317 | 7 | 1310 | 0 | 37.8957 | 114.9042 | 2021-04-08 04:21:13 | Hebei, China | ||
2247203 | 2247203 | 2021-04-07 | China | Heilongjiang | 1610 | 13 | 1597 | 0 | 47.862 | 127.7615 | 2021-04-08 04:21:13 | Heilongjiang, China | ||
2247204 | 2247204 | 2021-04-07 | China | Henan | 1311 | 22 | 1283 | 6 | 33.882 | 113.614 | 2021-04-08 04:21:13 | Henan, China | ||
2247205 | 2247205 | 2021-04-07 | China | Hong Kong | 11539 | 205 | 11163 | 171 | 22.3 | 114.2 | 2021-04-08 04:21:13 | Hong Kong, China | ||
2247206 | 2247206 | 2021-04-07 | China | Hubei | 68153 | 4512 | 63639 | 2 | 30.9756 | 112.2707 | 2021-04-08 04:21:13 | Hubei, China | ||
2247207 | 2247207 | 2021-04-07 | China | Hunan | 1043 | 4 | 1033 | 6 | 27.6104 | 111.7088 | 2021-04-08 04:21:13 | Hunan, China | ||
2247208 | 2247208 | 2021-04-07 | China | Inner Mongolia | 377 | 1 | 370 | 6 | 44.0935 | 113.9448 | 2021-04-08 04:21:13 | Inner Mongolia, China | ||
2247209 | 2247209 | 2021-04-07 | China | Jiangsu | 716 | 0 | 707 | 9 | 32.9711 | 119.455 | 2021-04-08 04:21:13 | Jiangsu, China | ||
2247210 | 2247210 | 2021-04-07 | China | Jiangxi | 937 | 1 | 936 | 0 | 27.614 | 115.7221 | 2021-04-08 04:21:13 | Jiangxi, China | ||
2247211 | 2247211 | 2021-04-07 | China | Jilin | 573 | 3 | 570 | 0 | 43.6661 | 126.1923 | 2021-04-08 04:21:13 | Jilin, China | ||
2247212 | 2247212 | 2021-04-07 | China | Liaoning | 407 | 2 | 405 | 0 | 41.2956 | 122.6085 | 2021-04-08 04:21:13 | Liaoning, China | ||
2247213 | 2247213 | 2021-04-07 | China | Macau | 49 | 0 | 48 | 1 | 22.1667 | 113.55 | 2021-04-08 04:21:13 | Macau, China | ||
2247214 | 2247214 | 2021-04-07 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2021-04-08 04:21:13 | Ningxia, China | ||
2247215 | 2247215 | 2021-04-07 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2021-04-08 04:21:13 | Qinghai, China | ||
2247216 | 2247216 | 2021-04-07 | China | Shaanxi | 573 | 3 | 560 | 10 | 35.1917 | 108.8701 | 2021-04-08 04:21:13 | Shaanxi, China | ||
2247217 | 2247217 | 2021-04-07 | China | Shandong | 871 | 7 | 862 | 2 | 36.3427 | 118.1498 | 2021-04-08 04:21:13 | Shandong, China | ||
2247218 | 2247218 | 2021-04-07 | China | Shanghai | 1913 | 7 | 1860 | 46 | 31.202 | 121.4491 | 2021-04-08 04:21:13 | Shanghai, China | ||
2247219 | 2247219 | 2021-04-07 | China | Shanxi | 245 | 0 | 240 | 5 | 37.5777 | 112.2922 | 2021-04-08 04:21:13 | Shanxi, China | ||
2247220 | 2247220 | 2021-04-07 | China | Sichuan | 954 | 3 | 933 | 18 | 30.6171 | 102.7103 | 2021-04-08 04:21:13 | Sichuan, China | ||
2247221 | 2247221 | 2021-04-07 | China | Tianjin | 375 | 3 | 366 | 6 | 39.3054 | 117.323 | 2021-04-08 04:21:13 | Tianjin, China | ||
2247222 | 2247222 | 2021-04-07 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2021-04-08 04:21:13 | Tibet, China | ||
2247223 | 2247223 | 2021-04-07 | China | Unknown | 8489 | 0 | 0 | 0 | 2021-04-08 04:21:13 | Unknown, China | ||||
2247224 | 2247224 | 2021-04-07 | China | Xinjiang | 980 | 3 | 977 | 0 | 41.1129 | 85.2401 | 2021-04-08 04:21:13 | Xinjiang, China | ||
2247225 | 2247225 | 2021-04-07 | China | Yunnan | 312 | 2 | 231 | 79 | 24.974 | 101.487 | 2021-04-08 04:21:13 | Yunnan, China | ||
2247226 | 2247226 | 2021-04-07 | China | Zhejiang | 1324 | 1 | 1320 | 3 | 29.1832 | 120.0934 | 2021-04-08 04:21:13 | Zhejiang, China | ||
2247227 | 2247227 | 2021-04-07 | Colombia | Amazonas | 5919 | 225 | 5633 | 61 | -1.4429 | -71.5724 | 2021-04-08 04:21:13 | Amazonas, Colombia | ||
2247228 | 2247228 | 2021-04-07 | Colombia | Antioquia | 393199 | 7328 | 366125 | 19746 | 7.1986 | -75.3412 | 2021-04-08 04:21:13 | Antioquia, Colombia | ||
2247229 | 2247229 | 2021-04-07 | Colombia | Arauca | 5800 | 173 | 5533 | 94 | 7.0762 | -70.7105 | 2021-04-08 04:21:13 | Arauca, Colombia | ||
2247230 | 2247230 | 2021-04-07 | Colombia | Atlantico | 169730 | 4842 | 154218 | 10670 | 10.6966 | -74.8741 | 2021-04-08 04:21:13 | Atlantico, Colombia | ||
2247231 | 2247231 | 2021-04-07 | Colombia | Bolivar | 70730 | 1419 | 68566 | 745 | 8.6704 | -74.03 | 2021-04-08 04:21:13 | Bolivar, Colombia | ||
2247232 | 2247232 | 2021-04-07 | Colombia | Boyaca | 48698 | 1170 | 46700 | 828 | 5.4545 | -73.362 | 2021-04-08 04:21:13 | Boyaca, Colombia | ||
2247233 | 2247233 | 2021-04-07 | Colombia | Caldas | 51034 | 1028 | 48756 | 1250 | 5.2983 | -75.2479 | 2021-04-08 04:21:13 | Caldas, Colombia | ||
2247234 | 2247234 | 2021-04-07 | Colombia | Capital District | 699076 | 14567 | 667488 | 17021 | 4.711 | -74.0721 | 2021-04-08 04:21:13 | Capital District, Colombia | ||
2247235 | 2247235 | 2021-04-07 | Colombia | Caqueta | 17227 | 651 | 16375 | 201 | 0.8699 | -73.8419 | 2021-04-08 04:21:13 | Caqueta, Colombia | ||
2247236 | 2247236 | 2021-04-07 | Colombia | Casanare | 13285 | 309 | 12690 | 286 | 5.7589 | -71.5724 | 2021-04-08 04:21:13 | Casanare, Colombia | ||
2247237 | 2247237 | 2021-04-07 | Colombia | Cauca | 28413 | 781 | 27146 | 486 | 2.705 | -76.82600000000002 | 2021-04-08 04:21:13 | Cauca, Colombia | ||
2247238 | 2247238 | 2021-04-07 | Colombia | Cesar | 44664 | 1265 | 42598 | 801 | 9.3373 | -73.6536 | 2021-04-08 04:21:13 | Cesar, Colombia | ||
2247239 | 2247239 | 2021-04-07 | Colombia | Choco | 6818 | 205 | 6503 | 110 | 5.2528 | -76.82600000000002 | 2021-04-08 04:21:13 | Choco, Colombia | ||
2247240 | 2247240 | 2021-04-07 | Colombia | Cordoba | 44659 | 2056 | 41394 | 1209 | 8.0493 | -75.574 | 2021-04-08 04:21:13 | Cordoba, Colombia | ||
2247241 | 2247241 | 2021-04-07 | Colombia | Cundinamarca | 112627 | 3095 | 108036 | 1496 | 5.026 | -74.03 | 2021-04-08 04:21:13 | Cundinamarca, Colombia | ||
2247242 | 2247242 | 2021-04-07 | Colombia | Guainia | 1339 | 22 | 1311 | 6 | 2.5854 | -68.5247 | 2021-04-08 04:21:13 | Guainia, Colombia | ||
2247243 | 2247243 | 2021-04-07 | Colombia | Guaviare | 2302 | 40 | 2254 | 8 | 1.0654 | -73.2603 | 2021-04-08 04:21:13 | Guaviare, Colombia | ||
2247244 | 2247244 | 2021-04-07 | Colombia | Huila | 51297 | 1800 | 49113 | 384 | 2.5359 | -75.5277 | 2021-04-08 04:21:13 | Huila, Colombia | ||
2247245 | 2247245 | 2021-04-07 | Colombia | La Guajira | 19737 | 690 | 18489 | 558 | 11.3548 | -72.5205 | 2021-04-08 04:21:13 | La Guajira, Colombia | ||
2247246 | 2247246 | 2021-04-07 | Colombia | Magdalena | 47548 | 1731 | 44091 | 1726 | 10.4113 | -74.4057 | 2021-04-08 04:21:13 | Magdalena, Colombia | ||
2247247 | 2247247 | 2021-04-07 | Colombia | Meta | 44171 | 1008 | 42784 | 379 | 3.272 | -73.0877 | 2021-04-08 04:21:13 | Meta, Colombia | ||
2247248 | 2247248 | 2021-04-07 | Colombia | Narino | 50705 | 1704 | 48148 | 853 | 1.2892 | -77.3579 | 2021-04-08 04:21:13 | Narino, Colombia | ||
2247249 | 2247249 | 2021-04-07 | Colombia | Norte de Santander | 52322 | 2773 | 48958 | 591 | 7.9463 | -72.8988 | 2021-04-08 04:21:13 | Norte de Santander, Colombia | ||
2247250 | 2247250 | 2021-04-07 | Colombia | Putumayo | 8289 | 326 | 7860 | 103 | 0.436 | -75.5277 | 2021-04-08 04:21:13 | Putumayo, Colombia | ||
2247251 | 2247251 | 2021-04-07 | Colombia | Quindio | 35515 | 1064 | 33886 | 565 | 4.461 | -75.6674 | 2021-04-08 04:21:13 | Quindio, Colombia | ||
2247252 | 2247252 | 2021-04-07 | Colombia | Risaralda | 50237 | 1228 | 48032 | 977 | 5.3158 | -75.9928 | 2021-04-08 04:21:13 | Risaralda, Colombia | ||
2247253 | 2247253 | 2021-04-07 | Colombia | San Andres y Providencia | 2860 | 46 | 2784 | 30 | 12.5567 | -81.7185 | 2021-04-08 04:21:13 | San Andres y Providencia, Colombia | ||
2247254 | 2247254 | 2021-04-07 | Colombia | Santander | 95308 | 3511 | 90013 | 1784 | 6.6437 | -73.6536 | 2021-04-08 04:21:13 | Santander, Colombia | ||
2247255 | 2247255 | 2021-04-07 | Colombia | Sucre | 23683 | 870 | 22267 | 546 | 8.814 | -74.7233 | 2021-04-08 04:21:13 | Sucre, Colombia | ||
2247256 | 2247256 | 2021-04-07 | Colombia | Tolima | 66942 | 2161 | 64046 | 735 | 4.0925 | -75.1545 | 2021-04-08 04:21:13 | Tolima, Colombia | ||
2247257 | 2247257 | 2021-04-07 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-04-08 04:21:13 | Unknown, Colombia | ||||
2247258 | 2247258 | 2021-04-07 | Colombia | Valle del Cauca | 212816 | 6643 | 201085 | 5088 | 3.8009 | -76.6413 | 2021-04-08 04:21:13 | Valle del Cauca, Colombia | ||
2247259 | 2247259 | 2021-04-07 | Colombia | Vaupes | 1169 | 13 | 1145 | 11 | 0.8554 | -70.812 | 2021-04-08 04:21:13 | Vaupes, Colombia | ||
2247260 | 2247260 | 2021-04-07 | Colombia | Vichada | 1498 | 23 | 1444 | 31 | 4.4234 | -69.2878 | 2021-04-08 04:21:13 | Vichada, Colombia | ||
2247261 | 2247261 | 2021-04-07 | Comoros | 3758 | 146 | 3568 | 44 | -11.6455 | 43.3333 | 2021-04-08 04:21:13 | Comoros | |||
2247262 | 2247262 | 2021-04-07 | Congo (Brazzaville) | 10084 | 137 | 8208 | 1739 | -0.228 | 15.8277 | 2021-04-08 04:21:13 | Congo (Brazzaville) | |||
2247263 | 2247263 | 2021-04-07 | Congo (Kinshasa) | 28410 | 745 | 25841 | 1824 | -4.0383 | 21.7587 | 2021-04-08 04:21:13 | Congo (Kinshasa) | |||
2247264 | 2247264 | 2021-04-07 | Costa Rica | 219846 | 3000 | 193857 | 22989 | 9.7489 | -83.7534 | 2021-04-08 04:21:13 | Costa Rica | |||
2247265 | 2247265 | 2021-04-07 | Cote d'Ivoire | 44880 | 257 | 43446 | 1177 | 7.54 | -5.5471 | 2021-04-08 04:21:13 | Cote d'Ivoire | |||
2247266 | 2247266 | 2021-04-07 | Croatia | 282548 | 6149 | 265038 | 11361 | 45.1 | 15.2 | 2021-04-08 04:21:13 | Croatia | |||
2247267 | 2247267 | 2021-04-07 | Cuba | 82601 | 442 | 76883 | 5276 | 21.521757 | -77.78116700000002 | 2021-04-08 04:21:13 | Cuba | |||
2247268 | 2247268 | 2021-04-07 | Cyprus | 49806 | 265 | 2057 | 47484 | 35.1264 | 33.4299 | 2021-04-08 04:21:13 | Cyprus | |||
2247269 | 2247269 | 2021-04-07 | Czechia | 1560777 | 27329 | 1430816 | 102632 | 49.8175 | 15.473 | 2021-04-08 04:21:13 | Czechia | |||
2247270 | 2247270 | 2021-04-07 | Denmark | Faroe Islands | 661 | 1 | 660 | 0 | 61.8926 | -6.9118 | 2021-04-08 04:21:13 | Faroe Islands, Denmark | ||
2247271 | 2247271 | 2021-04-07 | Denmark | Greenland | 31 | 0 | 31 | 0 | 71.7069 | -42.6043 | 2021-04-08 04:21:13 | Greenland, Denmark | ||
2247272 | 2247272 | 2021-04-07 | Denmark | 234931 | 2435 | 223824 | 8672 | 56.2639 | 9.5018 | 2021-04-08 04:21:13 | Denmark | |||
2247273 | 2247273 | 2021-04-07 | Diamond Princess | 712 | 13 | 699 | 0 | 2021-04-08 04:21:13 | Diamond Princess | |||||
2247274 | 2247274 | 2021-04-07 | Djibouti | 9306 | 90 | 7225 | 1991 | 11.8251 | 42.5903 | 2021-04-08 04:21:13 | Djibouti | |||
2247275 | 2247275 | 2021-04-07 | Dominica | 165 | 0 | 159 | 6 | 15.415 | -61.371 | 2021-04-08 04:21:13 | Dominica | |||
2247276 | 2247276 | 2021-04-07 | Dominican Republic | 254937 | 3369 | 214943 | 36625 | 18.7357 | -70.1627 | 2021-04-08 04:21:13 | Dominican Republic | |||
2247277 | 2247277 | 2021-04-07 | Ecuador | 339604 | 17057 | 290314 | 32233 | -1.8312 | -78.1834 | 2021-04-08 04:21:13 | Ecuador | |||
2247278 | 2247278 | 2021-04-07 | Egypt | 207293 | 12290 | 157450 | 37553 | 26.820553000000004 | 30.802498 | 2021-04-08 04:21:13 | Egypt | |||
2247279 | 2247279 | 2021-04-07 | El Salvador | 65491 | 2037 | 62340 | 1114 | 13.7942 | -88.8965 | 2021-04-08 04:21:13 | El Salvador | |||
2247280 | 2247280 | 2021-04-07 | Equatorial Guinea | 7059 | 104 | 6683 | 272 | 1.6508 | 10.2679 | 2021-04-08 04:21:13 | Equatorial Guinea | |||
2247281 | 2247281 | 2021-04-07 | Eritrea | 3374 | 10 | 3138 | 226 | 15.1794 | 39.7823 | 2021-04-08 04:21:13 | Eritrea |
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]);