johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by active
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32338 | 32338 | 2021-08-25 | Germany | Thuringen | 130000 | 4394 | 0 | 51.011 | 10.8453 | 2021-08-26 04:21:28 | Thuringen, Germany | |||
32339 | 32339 | 2021-08-25 | Germany | Unknown | 9184 | 0 | 0 | 2021-08-26 04:21:28 | Unknown, Germany | |||||
32340 | 32340 | 2021-08-25 | Ghana | 115525 | 982 | 0 | 7.9465 | -1.0232 | 2021-08-26 04:21:28 | Ghana | ||||
32341 | 32341 | 2021-08-25 | Greece | 570077 | 13509 | 0 | 39.0742 | 21.8243 | 2021-08-26 04:21:28 | Greece | ||||
32342 | 32342 | 2021-08-25 | Grenada | 266 | 1 | 0 | 12.1165 | -61.678999999999995 | 2021-08-26 04:21:28 | Grenada | ||||
32343 | 32343 | 2021-08-25 | Guatemala | 450150 | 11615 | 0 | 15.7835 | -90.2308 | 2021-08-26 04:21:28 | Guatemala | ||||
32344 | 32344 | 2021-08-25 | Guinea | 29022 | 318 | 0 | 9.9456 | -9.6966 | 2021-08-26 04:21:28 | Guinea | ||||
32345 | 32345 | 2021-08-25 | Guinea-Bissau | 5634 | 110 | 0 | 11.8037 | -15.1804 | 2021-08-26 04:21:28 | Guinea-Bissau | ||||
32346 | 32346 | 2021-08-25 | Guyana | 24713 | 602 | 0 | 4.860416000000002 | -58.93018000000001 | 2021-08-26 04:21:28 | Guyana | ||||
32347 | 32347 | 2021-08-25 | Haiti | 20916 | 586 | 0 | 18.9712 | -72.2852 | 2021-08-26 04:21:28 | Haiti | ||||
32348 | 32348 | 2021-08-25 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-08-26 04:21:28 | Holy See | ||||
32349 | 32349 | 2021-08-25 | Honduras | 331372 | 8704 | 0 | 15.2 | -86.2419 | 2021-08-26 04:21:28 | Honduras | ||||
32350 | 32350 | 2021-08-25 | Hungary | 811337 | 30055 | 0 | 47.1625 | 19.5033 | 2021-08-26 04:21:28 | Hungary | ||||
32351 | 32351 | 2021-08-25 | Iceland | 10341 | 30 | 0 | 64.9631 | -19.0208 | 2021-08-26 04:21:28 | Iceland | ||||
32352 | 32352 | 2021-08-25 | India | Andaman and Nicobar Islands | 7560 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-08-26 04:21:28 | Andaman and Nicobar Islands, India | |||
32353 | 32353 | 2021-08-25 | India | Andhra Pradesh | 2006191 | 13766 | 0 | 15.9129 | 79.74 | 2021-08-26 04:21:28 | Andhra Pradesh, India | |||
32354 | 32354 | 2021-08-25 | India | Arunachal Pradesh | 52525 | 259 | 0 | 27.768456 | 96.384277 | 2021-08-26 04:21:28 | Arunachal Pradesh, India | |||
32355 | 32355 | 2021-08-25 | India | Assam | 586378 | 5607 | 0 | 26.357149 | 92.83044100000001 | 2021-08-26 04:21:28 | Assam, India | |||
32356 | 32356 | 2021-08-25 | India | Bihar | 725636 | 9650 | 0 | 25.679658 | 85.60484 | 2021-08-26 04:21:28 | Bihar, India | |||
32357 | 32357 | 2021-08-25 | India | Chandigarh | 65071 | 812 | 0 | 30.733839 | 76.76827800000002 | 2021-08-26 04:21:28 | Chandigarh, India | |||
32358 | 32358 | 2021-08-25 | India | Chhattisgarh | 1004282 | 13555 | 0 | 21.264705 | 82.035366 | 2021-08-26 04:21:28 | Chhattisgarh, India | |||
32359 | 32359 | 2021-08-25 | India | Dadra and Nagar Haveli and Daman and Diu | 10660 | 4 | 0 | 20.194742 | 73.080901 | 2021-08-26 04:21:28 | Dadra and Nagar Haveli and Daman and Diu, India | |||
32360 | 32360 | 2021-08-25 | India | Delhi | 1437550 | 25080 | 0 | 28.646519 | 77.10898 | 2021-08-26 04:21:28 | Delhi, India | |||
32361 | 32361 | 2021-08-25 | India | Goa | 173434 | 3187 | 0 | 15.359682000000001 | 74.057396 | 2021-08-26 04:21:28 | Goa, India | |||
32362 | 32362 | 2021-08-25 | India | Gujarat | 825347 | 10080 | 0 | 22.694884 | 71.590923 | 2021-08-26 04:21:28 | Gujarat, India | |||
32363 | 32363 | 2021-08-25 | India | Haryana | 770395 | 9670 | 0 | 29.20004 | 76.332824 | 2021-08-26 04:21:28 | Haryana, India | |||
32364 | 32364 | 2021-08-25 | India | Himachal Pradesh | 212458 | 3579 | 0 | 31.927213000000002 | 77.233081 | 2021-08-26 04:21:28 | Himachal Pradesh, India | |||
32365 | 32365 | 2021-08-25 | India | Jammu and Kashmir | 324546 | 4404 | 0 | 33.75943 | 76.612638 | 2021-08-26 04:21:28 | Jammu and Kashmir, India | |||
32366 | 32366 | 2021-08-25 | India | Jharkhand | 347763 | 5132 | 0 | 23.654536 | 85.557631 | 2021-08-26 04:21:28 | Jharkhand, India | |||
32367 | 32367 | 2021-08-25 | India | Karnataka | 2942250 | 37206 | 0 | 14.705179999999999 | 76.166436 | 2021-08-26 04:21:28 | Karnataka, India | |||
32368 | 32368 | 2021-08-25 | India | Kerala | 3883429 | 19972 | 0 | 10.450898 | 76.405749 | 2021-08-26 04:21:28 | Kerala, India | |||
32369 | 32369 | 2021-08-25 | India | Ladakh | 20515 | 207 | 0 | 34.1526 | 77.5771 | 2021-08-26 04:21:28 | Ladakh, India | |||
32370 | 32370 | 2021-08-25 | India | Lakshadweep | 10327 | 51 | 0 | 13.699997199999999 | 72.18333259999999 | 2021-08-26 04:21:28 | Lakshadweep, India | |||
32371 | 32371 | 2021-08-25 | India | Madhya Pradesh | 792114 | 10516 | 0 | 23.541513000000002 | 78.289633 | 2021-08-26 04:21:28 | Madhya Pradesh, India | |||
32372 | 32372 | 2021-08-25 | India | Maharashtra | 6437680 | 136571 | 0 | 19.449759 | 76.108221 | 2021-08-26 04:21:28 | Maharashtra, India | |||
32373 | 32373 | 2021-08-25 | India | Manipur | 111975 | 1763 | 0 | 24.738975 | 93.882541 | 2021-08-26 04:21:28 | Manipur, India | |||
32374 | 32374 | 2021-08-25 | India | Meghalaya | 74586 | 1292 | 0 | 25.536934 | 91.278882 | 2021-08-26 04:21:28 | Meghalaya, India | |||
32375 | 32375 | 2021-08-25 | India | Mizoram | 54851 | 202 | 0 | 23.309381 | 92.83821999999999 | 2021-08-26 04:21:28 | Mizoram, India | |||
32376 | 32376 | 2021-08-25 | India | Nagaland | 29718 | 612 | 0 | 26.06702 | 94.470302 | 2021-08-26 04:21:28 | Nagaland, India | |||
32377 | 32377 | 2021-08-25 | India | Odisha | 1003210 | 7562 | 0 | 20.505428 | 84.418059 | 2021-08-26 04:21:28 | Odisha, India | |||
32378 | 32378 | 2021-08-25 | India | Puducherry | 123078 | 1809 | 0 | 11.882658000000001 | 78.86498 | 2021-08-26 04:21:28 | Puducherry, India | |||
32379 | 32379 | 2021-08-25 | India | Punjab | 600378 | 16358 | 0 | 30.841465000000003 | 75.40879 | 2021-08-26 04:21:28 | Punjab, India | |||
32380 | 32380 | 2021-08-25 | India | Rajasthan | 954048 | 8954 | 0 | 26.583423 | 73.847973 | 2021-08-26 04:21:28 | Rajasthan, India | |||
32381 | 32381 | 2021-08-25 | India | Sikkim | 29524 | 367 | 0 | 27.571671000000002 | 88.472712 | 2021-08-26 04:21:28 | Sikkim, India | |||
32382 | 32382 | 2021-08-25 | India | Tamil Nadu | 2605647 | 34788 | 0 | 11.006091 | 78.400624 | 2021-08-26 04:21:28 | Tamil Nadu, India | |||
32383 | 32383 | 2021-08-25 | India | Telangana | 656098 | 3864 | 0 | 18.1124 | 79.0193 | 2021-08-26 04:21:28 | Telangana, India | |||
32384 | 32384 | 2021-08-25 | India | Tripura | 82498 | 793 | 0 | 23.746782999999997 | 91.743565 | 2021-08-26 04:21:28 | Tripura, India | |||
32385 | 32385 | 2021-08-25 | India | Unknown | 0 | 0 | 0 | 2021-08-26 04:21:28 | Unknown, India | |||||
32386 | 32386 | 2021-08-25 | India | Uttar Pradesh | 1709173 | 22794 | 0 | 26.925425 | 80.560982 | 2021-08-26 04:21:28 | Uttar Pradesh, India | |||
32387 | 32387 | 2021-08-25 | India | Uttarakhand | 342818 | 7377 | 0 | 30.156446999999996 | 79.197608 | 2021-08-26 04:21:28 | Uttarakhand, India | |||
32388 | 32388 | 2021-08-25 | India | West Bengal | 1544817 | 18393 | 0 | 23.814082 | 87.979803 | 2021-08-26 04:21:28 | West Bengal, India | |||
32389 | 32389 | 2021-08-25 | Indonesia | 4026837 | 129293 | 0 | -0.7893 | 113.9213 | 2021-08-26 04:21:28 | Indonesia | ||||
32390 | 32390 | 2021-08-25 | Iran | 4796377 | 104022 | 0 | 32.427908 | 53.68804599999999 | 2021-08-26 04:21:28 | Iran | ||||
32391 | 32391 | 2021-08-25 | Iraq | 1847697 | 20410 | 0 | 33.223191 | 43.679291 | 2021-08-26 04:21:28 | Iraq | ||||
32392 | 32392 | 2021-08-25 | Ireland | 342329 | 5092 | 0 | 53.1424 | -7.6921 | 2021-08-26 04:21:28 | Ireland | ||||
32393 | 32393 | 2021-08-25 | Israel | 1017825 | 6908 | 0 | 31.046051000000002 | 34.851612 | 2021-08-26 04:21:28 | Israel | ||||
32394 | 32394 | 2021-08-25 | Italy | Abruzzo | 78544 | 2523 | 0 | 42.35122196 | 13.39843823 | 2021-08-26 04:21:28 | Abruzzo, Italy | |||
32395 | 32395 | 2021-08-25 | Italy | Basilicata | 28599 | 597 | 0 | 40.63947052 | 15.80514834 | 2021-08-26 04:21:28 | Basilicata, Italy | |||
32396 | 32396 | 2021-08-25 | Italy | Calabria | 76132 | 1301 | 0 | 38.90597598 | 16.59440194 | 2021-08-26 04:21:28 | Calabria, Italy | |||
32397 | 32397 | 2021-08-25 | Italy | Campania | 442853 | 7709 | 0 | 40.83956555 | 14.25084984 | 2021-08-26 04:21:28 | Campania, Italy | |||
32398 | 32398 | 2021-08-25 | Italy | Emilia-Romagna | 408320 | 13334 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-26 04:21:28 | Emilia-Romagna, Italy | |||
32399 | 32399 | 2021-08-25 | Italy | Friuli Venezia Giulia | 110231 | 3797 | 0 | 45.6494354 | 13.76813649 | 2021-08-26 04:21:28 | Friuli Venezia Giulia, Italy | |||
32400 | 32400 | 2021-08-25 | Italy | Lazio | 372124 | 8494 | 0 | 41.89277044 | 12.48366722 | 2021-08-26 04:21:28 | Lazio, Italy | |||
32401 | 32401 | 2021-08-25 | Italy | Liguria | 108999 | 4381 | 0 | 44.41149315 | 8.9326992 | 2021-08-26 04:21:28 | Liguria, Italy | |||
32402 | 32402 | 2021-08-25 | Italy | Lombardia | 866485 | 33892 | 0 | 45.46679409 | 9.190347404 | 2021-08-26 04:21:28 | Lombardia, Italy | |||
32403 | 32403 | 2021-08-25 | Italy | Marche | 109494 | 3045 | 0 | 43.61675973 | 13.5188753 | 2021-08-26 04:21:28 | Marche, Italy | |||
32404 | 32404 | 2021-08-25 | Italy | Molise | 14160 | 494 | 0 | 41.55774754 | 14.65916051 | 2021-08-26 04:21:28 | Molise, Italy | |||
32405 | 32405 | 2021-08-25 | Italy | P.A. Bolzano | 74767 | 1184 | 0 | 46.49933453 | 11.35662422 | 2021-08-26 04:21:28 | P.A. Bolzano, Italy | |||
32406 | 32406 | 2021-08-25 | Italy | P.A. Trento | 47278 | 1365 | 0 | 46.06893511 | 11.12123097 | 2021-08-26 04:21:28 | P.A. Trento, Italy | |||
32407 | 32407 | 2021-08-25 | Italy | Piemonte | 371162 | 11711 | 0 | 45.0732745 | 7.680687483 | 2021-08-26 04:21:28 | Piemonte, Italy | |||
32408 | 32408 | 2021-08-25 | Italy | Puglia | 262141 | 6697 | 0 | 41.12559576 | 16.86736689 | 2021-08-26 04:21:28 | Puglia, Italy | |||
32409 | 32409 | 2021-08-25 | Italy | Sardegna | 70340 | 1564 | 0 | 39.21531192 | 9.110616306 | 2021-08-26 04:21:28 | Sardegna, Italy | |||
32410 | 32410 | 2021-08-25 | Italy | Sicilia | 268573 | 6259 | 0 | 38.11569725 | 13.362356699999998 | 2021-08-26 04:21:28 | Sicilia, Italy | |||
32411 | 32411 | 2021-08-25 | Italy | Toscana | 267976 | 6993 | 0 | 43.76923077 | 11.25588885 | 2021-08-26 04:21:28 | Toscana, Italy | |||
32412 | 32412 | 2021-08-25 | Italy | Umbria | 61110 | 1428 | 0 | 43.10675841 | 12.38824698 | 2021-08-26 04:21:28 | Umbria, Italy | |||
32413 | 32413 | 2021-08-25 | Italy | Valle d'Aosta | 11997 | 473 | 0 | 45.73750286 | 7.320149366 | 2021-08-26 04:21:28 | Valle d'Aosta, Italy | |||
32414 | 32414 | 2021-08-25 | Italy | Veneto | 451111 | 11673 | 0 | 45.43490485 | 12.33845213 | 2021-08-26 04:21:28 | Veneto, Italy | |||
32415 | 32415 | 2021-08-25 | Jamaica | 63831 | 1431 | 0 | 18.1096 | -77.2975 | 2021-08-26 04:21:28 | Jamaica | ||||
32416 | 32416 | 2021-08-25 | Japan | Aichi | 72840 | 1032 | 0 | 35.035551 | 137.211621 | 2021-08-26 04:21:28 | Aichi, Japan | |||
32417 | 32417 | 2021-08-25 | Japan | Akita | 1500 | 21 | 0 | 39.748678999999996 | 140.408228 | 2021-08-26 04:21:28 | Akita, Japan | |||
32418 | 32418 | 2021-08-25 | Japan | Aomori | 3811 | 33 | 0 | 40.781541 | 140.828896 | 2021-08-26 04:21:28 | Aomori, Japan | |||
32419 | 32419 | 2021-08-25 | Japan | Chiba | 78798 | 809 | 0 | 35.510141 | 140.198917 | 2021-08-26 04:21:28 | Chiba, Japan | |||
32420 | 32420 | 2021-08-25 | Japan | Ehime | 4349 | 78 | 0 | 33.624835 | 132.856842 | 2021-08-26 04:21:28 | Ehime, Japan | |||
32421 | 32421 | 2021-08-25 | Japan | Fukui | 2348 | 36 | 0 | 35.846614 | 136.22465400000002 | 2021-08-26 04:21:28 | Fukui, Japan | |||
32422 | 32422 | 2021-08-25 | Japan | Fukuoka | 59855 | 558 | 0 | 33.526032 | 130.666949 | 2021-08-26 04:21:28 | Fukuoka, Japan | |||
32423 | 32423 | 2021-08-25 | Japan | Fukushima | 8242 | 165 | 0 | 37.378867 | 140.223295 | 2021-08-26 04:21:28 | Fukushima, Japan | |||
32424 | 32424 | 2021-08-25 | Japan | Gifu | 13667 | 195 | 0 | 35.778671 | 137.055925 | 2021-08-26 04:21:28 | Gifu, Japan | |||
32425 | 32425 | 2021-08-25 | Japan | Gunma | 13559 | 158 | 0 | 36.504478999999996 | 138.985605 | 2021-08-26 04:21:28 | Gunma, Japan | |||
32426 | 32426 | 2021-08-25 | Japan | Hiroshima | 16828 | 180 | 0 | 34.605309000000005 | 132.788719 | 2021-08-26 04:21:28 | Hiroshima, Japan | |||
32427 | 32427 | 2021-08-25 | Japan | Hokkaido | 54534 | 1437 | 0 | 43.385711 | 142.55231799999999 | 2021-08-26 04:21:28 | Hokkaido, Japan | |||
32428 | 32428 | 2021-08-25 | Japan | Hyogo | 59959 | 1333 | 0 | 35.039913 | 134.828057 | 2021-08-26 04:21:28 | Hyogo, Japan | |||
32429 | 32429 | 2021-08-25 | Japan | Ibaraki | 19139 | 182 | 0 | 36.303588 | 140.319591 | 2021-08-26 04:21:28 | Ibaraki, Japan | |||
32430 | 32430 | 2021-08-25 | Japan | Ishikawa | 6948 | 123 | 0 | 36.769464 | 136.771027 | 2021-08-26 04:21:28 | Ishikawa, Japan | |||
32431 | 32431 | 2021-08-25 | Japan | Iwate | 2780 | 48 | 0 | 39.593287 | 141.361777 | 2021-08-26 04:21:28 | Iwate, Japan | |||
32432 | 32432 | 2021-08-25 | Japan | Kagawa | 3828 | 34 | 0 | 34.217292 | 133.969047 | 2021-08-26 04:21:28 | Kagawa, Japan | |||
32433 | 32433 | 2021-08-25 | Japan | Kagoshima | 7352 | 44 | 0 | 31.009484000000004 | 130.430665 | 2021-08-26 04:21:28 | Kagoshima, Japan | |||
32434 | 32434 | 2021-08-25 | Japan | Kanagawa | 134472 | 1084 | 0 | 35.415312 | 139.338983 | 2021-08-26 04:21:28 | Kanagawa, Japan | |||
32435 | 32435 | 2021-08-25 | Japan | Kochi | 3006 | 31 | 0 | 33.422519 | 133.367307 | 2021-08-26 04:21:28 | Kochi, Japan | |||
32436 | 32436 | 2021-08-25 | Japan | Kumamoto | 11244 | 123 | 0 | 32.608154 | 130.74523100000002 | 2021-08-26 04:21:28 | Kumamoto, Japan | |||
32437 | 32437 | 2021-08-25 | Japan | Kyoto | 27257 | 251 | 0 | 35.253815 | 135.443341 | 2021-08-26 04:21:28 | Kyoto, Japan |
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]);