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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
1370379 | 1370379 | 2022-09-21 | France | St Martin | 11941 | 63 | 0 | 18.0708 | -63.0501 | 2022-09-22 04:22:56 | St Martin, France | |||
1370380 | 1370380 | 2022-09-21 | France | Wallis and Futuna | 761 | 7 | 0 | -14.2938 | -178.1165 | 2022-09-22 04:22:56 | Wallis and Futuna, France | |||
1370381 | 1370381 | 2022-09-21 | France | 34036366 | 151321 | 0 | 46.2276 | 2.2137 | 2022-09-22 04:22:56 | France | ||||
1370382 | 1370382 | 2022-09-21 | Gabon | 48682 | 306 | 0 | -0.8037 | 11.6094 | 2022-09-22 04:22:56 | Gabon | ||||
1370383 | 1370383 | 2022-09-21 | Gambia | 12508 | 372 | 0 | 13.4432 | -15.3101 | 2022-09-22 04:22:56 | Gambia | ||||
1370384 | 1370384 | 2022-09-21 | Georgia | 1762206 | 16856 | 0 | 42.3154 | 43.3569 | 2022-09-22 04:22:56 | Georgia | ||||
1370385 | 1370385 | 2022-09-21 | Germany | Baden-Wurttemberg | 4449661 | 17229 | 0 | 48.6616 | 9.3501 | 2022-09-22 04:22:56 | Baden-Wurttemberg, Germany | |||
1370386 | 1370386 | 2022-09-21 | Germany | Bayern | 5944219 | 25740 | 0 | 48.7904 | 11.4979 | 2022-09-22 04:22:56 | Bayern, Germany | |||
1370387 | 1370387 | 2022-09-21 | Germany | Berlin | 1252496 | 4799 | 0 | 52.52 | 13.405 | 2022-09-22 04:22:56 | Berlin, Germany | |||
1370388 | 1370388 | 2022-09-21 | Germany | Brandenburg | 942904 | 5894 | 0 | 52.4125 | 12.5316 | 2022-09-22 04:22:56 | Brandenburg, Germany | |||
1370389 | 1370389 | 2022-09-21 | Germany | Bremen | 256059 | 835 | 0 | 53.0793 | 8.8017 | 2022-09-22 04:22:56 | Bremen, Germany | |||
1370390 | 1370390 | 2022-09-21 | Germany | Hamburg | 722173 | 3028 | 0 | 53.5511 | 9.9937 | 2022-09-22 04:22:56 | Hamburg, Germany | |||
1370391 | 1370391 | 2022-09-21 | Germany | Hessen | 2467914 | 11042 | 0 | 50.6521 | 9.1624 | 2022-09-22 04:22:56 | Hessen, Germany | |||
1370392 | 1370392 | 2022-09-21 | Germany | Mecklenburg-Vorpommern | 598217 | 2448 | 0 | 53.6127 | 12.4296 | 2022-09-22 04:22:56 | Mecklenburg-Vorpommern, Germany | |||
1370393 | 1370393 | 2022-09-21 | Germany | Niedersachsen | 3171331 | 10721 | 0 | 52.6367 | 9.8451 | 2022-09-22 04:22:56 | Niedersachsen, Germany | |||
1370394 | 1370394 | 2022-09-21 | Germany | Nordrhein-Westfalen | 6728217 | 27305 | 0 | 51.4332 | 7.6616 | 2022-09-22 04:22:56 | Nordrhein-Westfalen, Germany | |||
1370395 | 1370395 | 2022-09-21 | Germany | Rheinland-Pfalz | 1483026 | 6138 | 0 | 50.1183 | 7.309 | 2022-09-22 04:22:56 | Rheinland-Pfalz, Germany | |||
1370396 | 1370396 | 2022-09-21 | Germany | Saarland | 406628 | 1843 | 0 | 49.3964 | 7.023 | 2022-09-22 04:22:56 | Saarland, Germany | |||
1370397 | 1370397 | 2022-09-21 | Germany | Sachsen | 1743614 | 15982 | 0 | 51.1045 | 13.2017 | 2022-09-22 04:22:56 | Sachsen, Germany | |||
1370398 | 1370398 | 2022-09-21 | Germany | Sachsen-Anhalt | 834683 | 5697 | 0 | 51.9503 | 11.6923 | 2022-09-22 04:22:56 | Sachsen-Anhalt, Germany | |||
1370399 | 1370399 | 2022-09-21 | Germany | Schleswig-Holstein | 1002734 | 2864 | 0 | 54.2194 | 9.6961 | 2022-09-22 04:22:56 | Schleswig-Holstein, Germany | |||
1370400 | 1370400 | 2022-09-21 | Germany | Thuringen | 793432 | 7604 | 0 | 51.011 | 10.8453 | 2022-09-22 04:22:56 | Thuringen, Germany | |||
1370401 | 1370401 | 2022-09-21 | Germany | Unknown | 0 | 0 | 0 | 2022-09-22 04:22:56 | Unknown, Germany | |||||
1370402 | 1370402 | 2022-09-21 | Ghana | 168813 | 1459 | 0 | 7.9465 | -1.0232 | 2022-09-22 04:22:56 | Ghana | ||||
1370403 | 1370403 | 2022-09-21 | Greece | 4875215 | 33010 | 0 | 39.0742 | 21.8243 | 2022-09-22 04:22:56 | Greece | ||||
1370404 | 1370404 | 2022-09-21 | Grenada | 19516 | 236 | 0 | 12.1165 | -61.679 | 2022-09-22 04:22:56 | Grenada | ||||
1370405 | 1370405 | 2022-09-21 | Guatemala | 1117364 | 19737 | 0 | 15.7835 | -90.2308 | 2022-09-22 04:22:56 | Guatemala | ||||
1370406 | 1370406 | 2022-09-21 | Guinea | 37652 | 449 | 0 | 9.9456 | -9.6966 | 2022-09-22 04:22:56 | Guinea | ||||
1370407 | 1370407 | 2022-09-21 | Guinea-Bissau | 8796 | 175 | 0 | 11.8037 | -15.1804 | 2022-09-22 04:22:56 | Guinea-Bissau | ||||
1370408 | 1370408 | 2022-09-21 | Guyana | 71287 | 1281 | 0 | 4.860416 | -58.93018 | 2022-09-22 04:22:56 | Guyana | ||||
1370409 | 1370409 | 2022-09-21 | Haiti | 33721 | 857 | 0 | 18.9712 | -72.2852 | 2022-09-22 04:22:56 | Haiti | ||||
1370410 | 1370410 | 2022-09-21 | Holy See | 29 | 0 | 0 | 41.9029 | 12.4534 | 2022-09-22 04:22:56 | Holy See | ||||
1370411 | 1370411 | 2022-09-21 | Honduras | 456035 | 10992 | 0 | 15.2 | -86.2419 | 2022-09-22 04:22:56 | Honduras | ||||
1370412 | 1370412 | 2022-09-21 | Hungary | 2082750 | 47457 | 0 | 47.1625 | 19.5033 | 2022-09-22 04:22:56 | Hungary | ||||
1370413 | 1370413 | 2022-09-21 | Iceland | 205454 | 213 | 0 | 64.9631 | -19.0208 | 2022-09-22 04:22:56 | Iceland | ||||
1370414 | 1370414 | 2022-09-21 | India | Andaman and Nicobar Islands | 10639 | 129 | 0 | 11.225999 | 92.968178 | 2022-09-22 04:22:56 | Andaman and Nicobar Islands, India | |||
1370415 | 1370415 | 2022-09-21 | India | Andhra Pradesh | 2338006 | 14733 | 0 | 15.9129 | 79.74 | 2022-09-22 04:22:56 | Andhra Pradesh, India |
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]);