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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1370279 | 1370279 | 2022-09-21 | China | Fujian | 4281 | 1 | 0 | 26.0789 | 117.9874 | 2022-09-22 04:22:56 | Fujian, China | |||
1370280 | 1370280 | 2022-09-21 | China | Gansu | 1350 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-22 04:22:56 | Gansu, China | |||
1370281 | 1370281 | 2022-09-21 | China | Guangdong | 9827 | 8 | 0 | 23.3417 | 113.4244 | 2022-09-22 04:22:56 | Guangdong, China | |||
1370282 | 1370282 | 2022-09-21 | China | Guangxi | 2328 | 2 | 0 | 23.8298 | 108.7881 | 2022-09-22 04:22:56 | Guangxi, China | |||
1370283 | 1370283 | 2022-09-21 | China | Guizhou | 407 | 2 | 0 | 26.8154 | 106.8748 | 2022-09-22 04:22:56 | Guizhou, China | |||
1370284 | 1370284 | 2022-09-21 | China | Hainan | 8954 | 6 | 0 | 19.1959 | 109.7453 | 2022-09-22 04:22:56 | Hainan, China | |||
1370285 | 1370285 | 2022-09-21 | China | Hebei | 2027 | 7 | 0 | 37.8957 | 114.9042 | 2022-09-22 04:22:56 | Hebei, China | |||
1370286 | 1370286 | 2022-09-21 | China | Heilongjiang | 3268 | 13 | 0 | 47.862 | 127.7615 | 2022-09-22 04:22:56 | Heilongjiang, China | |||
1370287 | 1370287 | 2022-09-21 | China | Henan | 3325 | 22 | 0 | 33.882 | 113.614 | 2022-09-22 04:22:56 | Henan, China | |||
1370288 | 1370288 | 2022-09-21 | China | Hong Kong | 1725036 | 9917 | 0 | 22.3 | 114.2 | 2022-09-22 04:22:56 | Hong Kong, China | |||
1370289 | 1370289 | 2022-09-21 | China | Hubei | 68427 | 4512 | 0 | 30.9756 | 112.2707 | 2022-09-22 04:22:56 | Hubei, China | |||
1370290 | 1370290 | 2022-09-21 | China | Hunan | 1451 | 4 | 0 | 27.6104 | 111.7088 | 2022-09-22 04:22:56 | Hunan, China | |||
1370291 | 1370291 | 2022-09-21 | China | Inner Mongolia | 2755 | 1 | 0 | 44.0935 | 113.9448 | 2022-09-22 04:22:56 | Inner Mongolia, China | |||
1370292 | 1370292 | 2022-09-21 | China | Jiangsu | 2380 | 0 | 0 | 32.9711 | 119.455 | 2022-09-22 04:22:56 | Jiangsu, China | |||
1370293 | 1370293 | 2022-09-21 | China | Jiangxi | 1495 | 1 | 0 | 27.614 | 115.7221 | 2022-09-22 04:22:56 | Jiangxi, China | |||
1370294 | 1370294 | 2022-09-21 | China | Jilin | 40329 | 5 | 0 | 43.6661 | 126.1923 | 2022-09-22 04:22:56 | Jilin, China | |||
1370295 | 1370295 | 2022-09-21 | China | Liaoning | 1883 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-22 04:22:56 | Liaoning, China | |||
1370296 | 1370296 | 2022-09-21 | China | Macau | 793 | 6 | 0 | 22.1667 | 113.55 | 2022-09-22 04:22:56 | Macau, China | |||
1370297 | 1370297 | 2022-09-21 | China | Ningxia | 126 | 0 | 0 | 37.2692 | 106.1655 | 2022-09-22 04:22:56 | Ningxia, China | |||
1370298 | 1370298 | 2022-09-21 | China | Qinghai | 233 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-22 04:22:56 | Qinghai, China | |||
1370299 | 1370299 | 2022-09-21 | China | Shaanxi | 3724 | 3 | 0 | 35.1917 | 108.8701 | 2022-09-22 04:22:56 | Shaanxi, China | |||
1370300 | 1370300 | 2022-09-21 | China | Shandong | 3082 | 7 | 0 | 36.3427 | 118.1498 | 2022-09-22 04:22:56 | Shandong, China | |||
1370301 | 1370301 | 2022-09-21 | China | Shanghai | 64038 | 595 | 0 | 31.202 | 121.4491 | 2022-09-22 04:22:56 | Shanghai, China | |||
1370302 | 1370302 | 2022-09-21 | China | Shanxi | 469 | 0 | 0 | 37.5777 | 112.2922 | 2022-09-22 04:22:56 | Shanxi, China | |||
1370303 | 1370303 | 2022-09-21 | China | Sichuan | 5347 | 3 | 0 | 30.6171 | 102.7103 | 2022-09-22 04:22:56 | Sichuan, China | |||
1370304 | 1370304 | 2022-09-21 | China | Tianjin | 2307 | 3 | 0 | 39.3054 | 117.323 | 2022-09-22 04:22:56 | Tianjin, China | |||
1370305 | 1370305 | 2022-09-21 | China | Tibet | 1308 | 0 | 0 | 31.6927 | 88.0924 | 2022-09-22 04:22:56 | Tibet, China | |||
1370306 | 1370306 | 2022-09-21 | China | Unknown | 734695 | 0 | 0 | 2022-09-22 04:22:56 | Unknown, China | |||||
1370307 | 1370307 | 2022-09-21 | China | Xinjiang | 1168 | 3 | 0 | 41.1129 | 85.2401 | 2022-09-22 04:22:56 | Xinjiang, China | |||
1370308 | 1370308 | 2022-09-21 | China | Yunnan | 2358 | 2 | 0 | 24.974 | 101.487 | 2022-09-22 04:22:56 | Yunnan, China | |||
1370309 | 1370309 | 2022-09-21 | China | Zhejiang | 3404 | 1 | 0 | 29.1832 | 120.0934 | 2022-09-22 04:22:56 | Zhejiang, China | |||
1370310 | 1370310 | 2022-09-21 | Colombia | Amazonas | 7812 | 265 | 0 | -1.4429 | -71.5724 | 2022-09-22 04:22:56 | Amazonas, Colombia | |||
1370311 | 1370311 | 2022-09-21 | Colombia | Antioquia | 943234 | 18491 | 0 | 7.1986 | -75.3412 | 2022-09-22 04:22:56 | Antioquia, Colombia | |||
1370312 | 1370312 | 2022-09-21 | Colombia | Arauca | 16978 | 554 | 0 | 7.0762 | -70.7105 | 2022-09-22 04:22:56 | Arauca, Colombia | |||
1370313 | 1370313 | 2022-09-21 | Colombia | Atlantico | 415804 | 10202 | 0 | 10.6966 | -74.8741 | 2022-09-22 04:22:56 | Atlantico, Colombia | |||
1370314 | 1370314 | 2022-09-21 | Colombia | Bolivar | 202817 | 3265 | 0 | 8.6704 | -74.03 | 2022-09-22 04:22:56 | Bolivar, Colombia | |||
1370315 | 1370315 | 2022-09-21 | Colombia | Boyaca | 129279 | 2865 | 0 | 5.4545 | -73.362 | 2022-09-22 04:22:56 | Boyaca, Colombia | |||
1370316 | 1370316 | 2022-09-21 | Colombia | Caldas | 119311 | 2563 | 0 | 5.2983 | -75.2479 | 2022-09-22 04:22:56 | Caldas, Colombia | |||
1370317 | 1370317 | 2022-09-21 | Colombia | Capital District | 1852577 | 29817 | 0 | 4.711 | -74.0721 | 2022-09-22 04:22:56 | Capital District, Colombia | |||
1370318 | 1370318 | 2022-09-21 | Colombia | Caqueta | 25584 | 1039 | 0 | 0.8699 | -73.8419 | 2022-09-22 04:22:56 | Caqueta, Colombia | |||
1370319 | 1370319 | 2022-09-21 | Colombia | Casanare | 42817 | 1022 | 0 | 5.7589 | -71.5724 | 2022-09-22 04:22:56 | Casanare, Colombia | |||
1370320 | 1370320 | 2022-09-21 | Colombia | Cauca | 76135 | 1844 | 0 | 2.705 | -76.826 | 2022-09-22 04:22:56 | Cauca, Colombia | |||
1370321 | 1370321 | 2022-09-21 | Colombia | Cesar | 108674 | 2681 | 0 | 9.3373 | -73.6536 | 2022-09-22 04:22:56 | Cesar, Colombia | |||
1370322 | 1370322 | 2022-09-21 | Colombia | Choco | 18828 | 429 | 0 | 5.2528 | -76.826 | 2022-09-22 04:22:56 | Choco, Colombia | |||
1370323 | 1370323 | 2022-09-21 | Colombia | Cordoba | 121928 | 3951 | 0 | 8.0493 | -75.574 | 2022-09-22 04:22:56 | Cordoba, Colombia | |||
1370324 | 1370324 | 2022-09-21 | Colombia | Cundinamarca | 327647 | 7356 | 0 | 5.026 | -74.03 | 2022-09-22 04:22:56 | Cundinamarca, Colombia | |||
1370325 | 1370325 | 2022-09-21 | Colombia | Guainia | 2792 | 37 | 0 | 2.5854 | -68.5247 | 2022-09-22 04:22:56 | Guainia, Colombia | |||
1370326 | 1370326 | 2022-09-21 | Colombia | Guaviare | 5655 | 105 | 0 | 1.0654 | -73.2603 | 2022-09-22 04:22:56 | Guaviare, Colombia | |||
1370327 | 1370327 | 2022-09-21 | Colombia | Huila | 103003 | 3579 | 0 | 2.5359 | -75.5277 | 2022-09-22 04:22:56 | Huila, Colombia | |||
1370328 | 1370328 | 2022-09-21 | Colombia | La Guajira | 57867 | 1543 | 0 | 11.3548 | -72.5205 | 2022-09-22 04:22:56 | La Guajira, Colombia | |||
1370329 | 1370329 | 2022-09-21 | Colombia | Magdalena | 117386 | 3643 | 0 | 10.4113 | -74.4057 | 2022-09-22 04:22:56 | Magdalena, Colombia | |||
1370330 | 1370330 | 2022-09-21 | Colombia | Meta | 107381 | 2592 | 0 | 3.272 | -73.0877 | 2022-09-22 04:22:56 | Meta, Colombia | |||
1370331 | 1370331 | 2022-09-21 | Colombia | Narino | 107651 | 3383 | 0 | 1.2892 | -77.3579 | 2022-09-22 04:22:56 | Narino, Colombia | |||
1370332 | 1370332 | 2022-09-21 | Colombia | Norte de Santander | 124312 | 5174 | 0 | 7.9463 | -72.8988 | 2022-09-22 04:22:56 | Norte de Santander, Colombia | |||
1370333 | 1370333 | 2022-09-21 | Colombia | Putumayo | 21756 | 787 | 0 | 0.436 | -75.5277 | 2022-09-22 04:22:56 | Putumayo, Colombia | |||
1370334 | 1370334 | 2022-09-21 | Colombia | Quindio | 72688 | 2076 | 0 | 4.461 | -75.6674 | 2022-09-22 04:22:56 | Quindio, Colombia | |||
1370335 | 1370335 | 2022-09-21 | Colombia | Risaralda | 109450 | 2496 | 0 | 5.3158 | -75.9928 | 2022-09-22 04:22:56 | Risaralda, Colombia | |||
1370336 | 1370336 | 2022-09-21 | Colombia | San Andres y Providencia | 10333 | 156 | 0 | 12.5567 | -81.7185 | 2022-09-22 04:22:56 | San Andres y Providencia, Colombia | |||
1370337 | 1370337 | 2022-09-21 | Colombia | Santander | 293287 | 8302 | 0 | 6.6437 | -73.6536 | 2022-09-22 04:22:56 | Santander, Colombia | |||
1370338 | 1370338 | 2022-09-21 | Colombia | Sucre | 66908 | 1740 | 0 | 8.814 | -74.7233 | 2022-09-22 04:22:56 | Sucre, Colombia | |||
1370339 | 1370339 | 2022-09-21 | Colombia | Tolima | 126845 | 4075 | 0 | 4.0925 | -75.1545 | 2022-09-22 04:22:56 | Tolima, Colombia | |||
1370340 | 1370340 | 2022-09-21 | Colombia | Unknown | 0 | 300 | 0 | 2022-09-22 04:22:56 | Unknown, Colombia | |||||
1370341 | 1370341 | 2022-09-21 | Colombia | Valle del Cauca | 563412 | 15328 | 0 | 3.8009 | -76.6413 | 2022-09-22 04:22:56 | Valle del Cauca, Colombia | |||
1370342 | 1370342 | 2022-09-21 | Colombia | Vaupes | 1950 | 22 | 0 | 0.8554 | -70.812 | 2022-09-22 04:22:56 | Vaupes, Colombia | |||
1370343 | 1370343 | 2022-09-21 | Colombia | Vichada | 3461 | 64 | 0 | 4.4234 | -69.2878 | 2022-09-22 04:22:56 | Vichada, Colombia | |||
1370344 | 1370344 | 2022-09-21 | Comoros | 8471 | 161 | 0 | -11.6455 | 43.3333 | 2022-09-22 04:22:56 | Comoros | ||||
1370345 | 1370345 | 2022-09-21 | Congo (Brazzaville) | 24837 | 386 | 0 | -0.228 | 15.8277 | 2022-09-22 04:22:56 | Congo (Brazzaville) | ||||
1370346 | 1370346 | 2022-09-21 | Congo (Kinshasa) | 92809 | 1442 | 0 | -4.0383 | 21.7587 | 2022-09-22 04:22:56 | Congo (Kinshasa) | ||||
1370347 | 1370347 | 2022-09-21 | Costa Rica | 1111969 | 8933 | 0 | 9.7489 | -83.7534 | 2022-09-22 04:22:56 | Costa Rica | ||||
1370348 | 1370348 | 2022-09-21 | Cote d'Ivoire | 87081 | 823 | 0 | 7.54 | -5.5471 | 2022-09-22 04:22:56 | Cote d'Ivoire | ||||
1370349 | 1370349 | 2022-09-21 | Croatia | 1226323 | 16854 | 0 | 45.1 | 15.2 | 2022-09-22 04:22:56 | Croatia | ||||
1370350 | 1370350 | 2022-09-21 | Cuba | 1111080 | 8530 | 0 | 21.521757 | -77.781167 | 2022-09-22 04:22:56 | Cuba | ||||
1370351 | 1370351 | 2022-09-21 | Cyprus | 582381 | 1178 | 0 | 35.1264 | 33.4299 | 2022-09-22 04:22:56 | Cyprus | ||||
1370352 | 1370352 | 2022-09-21 | Czechia | 4409510 | 40990 | 0 | 49.8175 | 15.473 | 2022-09-22 04:22:56 | Czechia | ||||
1370353 | 1370353 | 2022-09-21 | Denmark | Faroe Islands | 34658 | 28 | 0 | 61.8926 | -6.9118 | 2022-09-22 04:22:56 | Faroe Islands, Denmark | |||
1370354 | 1370354 | 2022-09-21 | Denmark | Greenland | 11971 | 21 | 0 | 71.7069 | -42.6043 | 2022-09-22 04:22:56 | Greenland, Denmark | |||
1370355 | 1370355 | 2022-09-21 | Denmark | 3289119 | 7016 | 0 | 56.2639 | 9.5018 | 2022-09-22 04:22:56 | Denmark | ||||
1370356 | 1370356 | 2022-09-21 | Diamond Princess | 712 | 13 | 0 | 2022-09-22 04:22:56 | Diamond Princess | ||||||
1370357 | 1370357 | 2022-09-21 | Djibouti | 15690 | 189 | 0 | 11.8251 | 42.5903 | 2022-09-22 04:22:56 | Djibouti | ||||
1370358 | 1370358 | 2022-09-21 | Dominica | 14852 | 68 | 0 | 15.415 | -61.371 | 2022-09-22 04:22:56 | Dominica | ||||
1370359 | 1370359 | 2022-09-21 | Dominican Republic | 644356 | 4384 | 0 | 18.7357 | -70.1627 | 2022-09-22 04:22:56 | Dominican Republic | ||||
1370360 | 1370360 | 2022-09-21 | Ecuador | 1002057 | 35887 | 0 | -1.8312 | -78.1834 | 2022-09-22 04:22:56 | Ecuador | ||||
1370361 | 1370361 | 2022-09-21 | Egypt | 515645 | 24797 | 0 | 26.820553 | 30.802498 | 2022-09-22 04:22:56 | Egypt | ||||
1370362 | 1370362 | 2022-09-21 | El Salvador | 201785 | 4229 | 0 | 13.7942 | -88.8965 | 2022-09-22 04:22:56 | El Salvador | ||||
1370363 | 1370363 | 2022-09-21 | Equatorial Guinea | 17006 | 183 | 0 | 1.6508 | 10.2679 | 2022-09-22 04:22:56 | Equatorial Guinea | ||||
1370364 | 1370364 | 2022-09-21 | Eritrea | 10168 | 103 | 0 | 15.1794 | 39.7823 | 2022-09-22 04:22:56 | Eritrea | ||||
1370365 | 1370365 | 2022-09-21 | Estonia | 600796 | 2667 | 0 | 58.5953 | 25.0136 | 2022-09-22 04:22:56 | Estonia | ||||
1370366 | 1370366 | 2022-09-21 | Eswatini | 73379 | 1422 | 0 | -26.5225 | 31.4659 | 2022-09-22 04:22:56 | Eswatini | ||||
1370367 | 1370367 | 2022-09-21 | Ethiopia | 493478 | 7572 | 0 | 9.145 | 40.4897 | 2022-09-22 04:22:56 | Ethiopia | ||||
1370368 | 1370368 | 2022-09-21 | Fiji | 68223 | 878 | 0 | -17.7134 | 178.065 | 2022-09-22 04:22:56 | Fiji | ||||
1370369 | 1370369 | 2022-09-21 | Finland | 1277473 | 5858 | 0 | 61.92411 | 25.748151 | 2022-09-22 04:22:56 | Finland | ||||
1370370 | 1370370 | 2022-09-21 | France | French Guiana | 93925 | 410 | 0 | 4.0 | -53.0 | 2022-09-22 04:22:56 | French Guiana, France | |||
1370371 | 1370371 | 2022-09-21 | France | French Polynesia | 76588 | 649 | 0 | -17.6797 | -149.4068 | 2022-09-22 04:22:56 | French Polynesia, France | |||
1370372 | 1370372 | 2022-09-21 | France | Guadeloupe | 191997 | 986 | 0 | 16.265 | -61.551 | 2022-09-22 04:22:56 | Guadeloupe, France | |||
1370373 | 1370373 | 2022-09-21 | France | Martinique | 219529 | 1036 | 0 | 14.6415 | -61.0242 | 2022-09-22 04:22:56 | Martinique, France | |||
1370374 | 1370374 | 2022-09-21 | France | Mayotte | 40204 | 187 | 0 | -12.8275 | 45.166244 | 2022-09-22 04:22:56 | Mayotte, France | |||
1370375 | 1370375 | 2022-09-21 | France | New Caledonia | 74275 | 314 | 0 | -20.904305 | 165.618042 | 2022-09-22 04:22:56 | New Caledonia, France | |||
1370376 | 1370376 | 2022-09-21 | France | Reunion | 474623 | 884 | 0 | -21.1151 | 55.5364 | 2022-09-22 04:22:56 | Reunion, France | |||
1370377 | 1370377 | 2022-09-21 | France | Saint Barthelemy | 5263 | 6 | 0 | 17.9 | -62.8333 | 2022-09-22 04:22:56 | Saint Barthelemy, France | |||
1370378 | 1370378 | 2022-09-21 | France | Saint Pierre and Miquelon | 3188 | 1 | 0 | 46.8852 | -56.3159 | 2022-09-22 04:22:56 | 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]);