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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1370430 | 1370430 | 2022-09-21 | India | Kerala | 6791486 | 71036 | 0 | 10.450898 | 76.405749 | 2022-09-22 04:22:56 | Kerala, India | |||
1370431 | 1370431 | 2022-09-21 | India | Ladakh | 29317 | 230 | 0 | 34.1526 | 77.5771 | 2022-09-22 04:22:56 | Ladakh, India | |||
1370432 | 1370432 | 2022-09-21 | India | Lakshadweep | 11415 | 52 | 0 | 13.6999972 | 72.1833326 | 2022-09-22 04:22:56 | Lakshadweep, India | |||
1370433 | 1370433 | 2022-09-21 | India | Madhya Pradesh | 1054134 | 10771 | 0 | 23.541513 | 78.289633 | 2022-09-22 04:22:56 | Madhya Pradesh, India | |||
1370434 | 1370434 | 2022-09-21 | India | Maharashtra | 8117024 | 148319 | 0 | 19.449759 | 76.108221 | 2022-09-22 04:22:56 | Maharashtra, India | |||
1370435 | 1370435 | 2022-09-21 | India | Manipur | 139796 | 2148 | 0 | 24.738975 | 93.882541 | 2022-09-22 04:22:56 | Manipur, India | |||
1370436 | 1370436 | 2022-09-21 | India | Meghalaya | 96636 | 1622 | 0 | 25.536934 | 91.278882 | 2022-09-22 04:22:56 | Meghalaya, India | |||
1370437 | 1370437 | 2022-09-21 | India | Mizoram | 238189 | 723 | 0 | 23.309381 | 92.83822 | 2022-09-22 04:22:56 | Mizoram, India | |||
1370438 | 1370438 | 2022-09-21 | India | Nagaland | 35949 | 781 | 0 | 26.06702 | 94.470302 | 2022-09-22 04:22:56 | Nagaland, India | |||
1370439 | 1370439 | 2022-09-21 | India | Odisha | 1332281 | 9186 | 0 | 20.505428 | 84.418059 | 2022-09-22 04:22:56 | Odisha, India | |||
1370440 | 1370440 | 2022-09-21 | India | Puducherry | 174087 | 1972 | 0 | 11.882658 | 78.86498 | 2022-09-22 04:22:56 | Puducherry, India | |||
1370441 | 1370441 | 2022-09-21 | India | Punjab | 784347 | 17911 | 0 | 30.841465 | 75.40879 | 2022-09-22 04:22:56 | Punjab, India | |||
1370442 | 1370442 | 2022-09-21 | India | Rajasthan | 1312595 | 9637 | 0 | 26.583423 | 73.847973 | 2022-09-22 04:22:56 | Rajasthan, India | |||
1370443 | 1370443 | 2022-09-21 | India | Sikkim | 44081 | 495 | 0 | 27.571671 | 88.472712 | 2022-09-22 04:22:56 | Sikkim, India | |||
1370444 | 1370444 | 2022-09-21 | India | Tamil Nadu | 3578317 | 38041 | 0 | 11.006091 | 78.400624 | 2022-09-22 04:22:56 | Tamil Nadu, India | |||
1370445 | 1370445 | 2022-09-21 | India | Telangana | 837015 | 4111 | 0 | 18.1124 | 79.0193 | 2022-09-22 04:22:56 | Telangana, India | |||
1370446 | 1370446 | 2022-09-21 | India | Tripura | 107763 | 938 | 0 | 23.746783 | 91.743565 | 2022-09-22 04:22:56 | Tripura, India | |||
1370447 | 1370447 | 2022-09-21 | India | Unknown | 0 | 0 | 0 | 2022-09-22 04:22:56 | Unknown, India | |||||
1370448 | 1370448 | 2022-09-21 | India | Uttar Pradesh | 2125692 | 23619 | 0 | 26.925425 | 80.560982 | 2022-09-22 04:22:56 | Uttar Pradesh, India | |||
1370449 | 1370449 | 2022-09-21 | India | Uttarakhand | 449066 | 7748 | 0 | 30.156447 | 79.197608 | 2022-09-22 04:22:56 | Uttarakhand, India | |||
1370450 | 1370450 | 2022-09-21 | India | West Bengal | 2111857 | 21492 | 0 | 23.814082 | 87.979803 | 2022-09-22 04:22:56 | West Bengal, India | |||
1370451 | 1370451 | 2022-09-21 | Indonesia | 6415328 | 157948 | 0 | -0.7893 | 113.9213 | 2022-09-22 04:22:56 | Indonesia | ||||
1370452 | 1370452 | 2022-09-21 | Iran | 7545351 | 144358 | 0 | 32.427908 | 53.688046 | 2022-09-22 04:22:56 | Iran | ||||
1370453 | 1370453 | 2022-09-21 | Iraq | 2459249 | 25352 | 0 | 33.223191 | 43.679291 | 2022-09-22 04:22:56 | Iraq | ||||
1370454 | 1370454 | 2022-09-21 | Ireland | 1662008 | 7922 | 0 | 53.1424 | -7.6921 | 2022-09-22 04:22:56 | Ireland | ||||
1370455 | 1370455 | 2022-09-21 | Israel | 4654317 | 11681 | 0 | 31.046051 | 34.851612 | 2022-09-22 04:22:56 | Israel | ||||
1370456 | 1370456 | 2022-09-21 | Italy | Abruzzo | 551869 | 3659 | 0 | 42.35122196 | 13.39843823 | 2022-09-22 04:22:56 | Abruzzo, Italy | |||
1370457 | 1370457 | 2022-09-21 | Italy | Basilicata | 182365 | 985 | 0 | 40.63947052 | 15.80514834 | 2022-09-22 04:22:56 | Basilicata, Italy | |||
1370458 | 1370458 | 2022-09-21 | Italy | Calabria | 551804 | 2996 | 0 | 38.90597598 | 16.59440194 | 2022-09-22 04:22:56 | Calabria, Italy | |||
1370459 | 1370459 | 2022-09-21 | Italy | Campania | 2214944 | 11209 | 0 | 40.83956555 | 14.25084984 | 2022-09-22 04:22:56 | Campania, Italy | |||
1370460 | 1370460 | 2022-09-21 | Italy | Emilia-Romagna | 1847075 | 17993 | 0 | 44.49436681 | 11.3417208 | 2022-09-22 04:22:56 | Emilia-Romagna, Italy | |||
1370461 | 1370461 | 2022-09-21 | Italy | Friuli Venezia Giulia | 485200 | 5420 | 0 | 45.6494354 | 13.76813649 | 2022-09-22 04:22:56 | Friuli Venezia Giulia, Italy | |||
1370462 | 1370462 | 2022-09-21 | Italy | Lazio | 2050000 | 12064 | 0 | 41.89277044 | 12.48366722 | 2022-09-22 04:22:56 | Lazio, Italy | |||
1370463 | 1370463 | 2022-09-21 | Italy | Liguria | 569714 | 5572 | 0 | 44.41149315 | 8.9326992 | 2022-09-22 04:22:56 | Liguria, Italy | |||
1370464 | 1370464 | 2022-09-21 | Italy | Lombardia | 3528736 | 42449 | 0 | 45.46679409 | 9.190347404 | 2022-09-22 04:22:56 | Lombardia, Italy | |||
1370465 | 1370465 | 2022-09-21 | Italy | Marche | 615070 | 4108 | 0 | 43.61675973 | 13.5188753 | 2022-09-22 04:22:56 | Marche, Italy | |||
1370466 | 1370466 | 2022-09-21 | Italy | Molise | 89298 | 678 | 0 | 41.55774754 | 14.65916051 | 2022-09-22 04:22:56 | Molise, Italy | |||
1370467 | 1370467 | 2022-09-21 | Italy | P.A. Bolzano | 260097 | 1539 | 0 | 46.49933453 | 11.35662422 | 2022-09-22 04:22:56 | P.A. Bolzano, Italy | |||
1370468 | 1370468 | 2022-09-21 | Italy | P.A. Trento | 209453 | 1596 | 0 | 46.06893511 | 11.12123097 | 2022-09-22 04:22:56 | P.A. Trento, Italy | |||
1370469 | 1370469 | 2022-09-21 | Italy | Piemonte | 1455764 | 13615 | 0 | 45.0732745 | 7.680687483 | 2022-09-22 04:22:56 | Piemonte, Italy | |||
1370470 | 1370470 | 2022-09-21 | Italy | Puglia | 1469719 | 9060 | 0 | 41.12559576 | 16.86736689 | 2022-09-22 04:22:56 | Puglia, Italy | |||
1370471 | 1370471 | 2022-09-21 | Italy | Sardegna | 446101 | 2757 | 0 | 39.21531192 | 9.110616306 | 2022-09-22 04:22:56 | Sardegna, Italy | |||
1370472 | 1370472 | 2022-09-21 | Italy | Sicilia | 1640614 | 12182 | 0 | 38.11569725 | 13.3623567 | 2022-09-22 04:22:56 | Sicilia, Italy | |||
1370473 | 1370473 | 2022-09-21 | Italy | Toscana | 1393170 | 10731 | 0 | 43.76923077 | 11.25588885 | 2022-09-22 04:22:56 | Toscana, Italy | |||
1370474 | 1370474 | 2022-09-21 | Italy | Umbria | 372226 | 2105 | 0 | 43.10675841 | 12.38824698 | 2022-09-22 04:22:56 | Umbria, Italy | |||
1370475 | 1370475 | 2022-09-21 | Italy | Valle d'Aosta | 44207 | 550 | 0 | 45.73750286 | 7.320149366 | 2022-09-22 04:22:56 | Valle d'Aosta, Italy | |||
1370476 | 1370476 | 2022-09-21 | Italy | Veneto | 2241420 | 15447 | 0 | 45.43490485 | 12.33845213 | 2022-09-22 04:22:56 | Veneto, Italy | |||
1370477 | 1370477 | 2022-09-21 | Jamaica | 151405 | 3299 | 0 | 18.1096 | -77.2975 | 2022-09-22 04:22:56 | Jamaica | ||||
1370478 | 1370478 | 2022-09-21 | Japan | Aichi | 1340314 | 2829 | 0 | 35.035551 | 137.211621 | 2022-09-22 04:22:56 | Aichi, Japan | |||
1370479 | 1370479 | 2022-09-21 | Japan | Akita | 96353 | 214 | 0 | 39.748679 | 140.408228 | 2022-09-22 04:22:56 | Akita, Japan | |||
1370480 | 1370480 | 2022-09-21 | Japan | Aomori | 159962 | 288 | 0 | 40.781541 | 140.828896 | 2022-09-22 04:22:56 | Aomori, Japan | |||
1370481 | 1370481 | 2022-09-21 | Japan | Chiba | 926287 | 2515 | 0 | 35.510141 | 140.198917 | 2022-09-22 04:22:56 | Chiba, Japan | |||
1370482 | 1370482 | 2022-09-21 | Japan | Ehime | 158401 | 287 | 0 | 33.624835 | 132.856842 | 2022-09-22 04:22:56 | Ehime, Japan | |||
1370483 | 1370483 | 2022-09-21 | Japan | Fukui | 110887 | 96 | 0 | 35.846614 | 136.224654 | 2022-09-22 04:22:56 | Fukui, Japan | |||
1370484 | 1370484 | 2022-09-21 | Japan | Fukuoka | 1065156 | 1916 | 0 | 33.526032 | 130.666949 | 2022-09-22 04:22:56 | Fukuoka, Japan | |||
1370485 | 1370485 | 2022-09-21 | Japan | Fukushima | 180802 | 260 | 0 | 37.378867 | 140.223295 | 2022-09-22 04:22:56 | Fukushima, Japan | |||
1370486 | 1370486 | 2022-09-21 | Japan | Gifu | 284257 | 574 | 0 | 35.778671 | 137.055925 | 2022-09-22 04:22:56 | Gifu, Japan | |||
1370487 | 1370487 | 2022-09-21 | Japan | Gunma | 229919 | 462 | 0 | 36.504479 | 138.985605 | 2022-09-22 04:22:56 | Gunma, Japan | |||
1370488 | 1370488 | 2022-09-21 | Japan | Hiroshima | 417986 | 738 | 0 | 34.605309 | 132.788719 | 2022-09-22 04:22:56 | Hiroshima, Japan | |||
1370489 | 1370489 | 2022-09-21 | Japan | Hokkaido | 724866 | 2553 | 0 | 43.385711 | 142.552318 | 2022-09-22 04:22:56 | Hokkaido, Japan | |||
1370490 | 1370490 | 2022-09-21 | Japan | Hyogo | 991841 | 2834 | 0 | 35.039913 | 134.828057 | 2022-09-22 04:22:56 | Hyogo, Japan | |||
1370491 | 1370491 | 2022-09-21 | Japan | Ibaraki | 353031 | 661 | 0 | 36.303588 | 140.319591 | 2022-09-22 04:22:56 | Ibaraki, Japan | |||
1370492 | 1370492 | 2022-09-21 | Japan | Ishikawa | 156931 | 277 | 0 | 36.769464 | 136.771027 | 2022-09-22 04:22:56 | Ishikawa, Japan | |||
1370493 | 1370493 | 2022-09-21 | Japan | Iwate | 104856 | 190 | 0 | 39.593287 | 141.361777 | 2022-09-22 04:22:56 | Iwate, Japan | |||
1370494 | 1370494 | 2022-09-21 | Japan | Kagawa | 139046 | 284 | 0 | 34.217292 | 133.969047 | 2022-09-22 04:22:56 | Kagawa, Japan | |||
1370495 | 1370495 | 2022-09-21 | Japan | Kagoshima | 294047 | 526 | 0 | 31.009484 | 130.430665 | 2022-09-22 04:22:56 | Kagoshima, Japan | |||
1370496 | 1370496 | 2022-09-21 | Japan | Kanagawa | 1458323 | 2953 | 0 | 35.415312 | 139.338983 | 2022-09-22 04:22:56 | Kanagawa, Japan | |||
1370497 | 1370497 | 2022-09-21 | Japan | Kochi | 97882 | 293 | 0 | 33.422519 | 133.367307 | 2022-09-22 04:22:56 | Kochi, Japan | |||
1370498 | 1370498 | 2022-09-21 | Japan | Kumamoto | 324311 | 618 | 0 | 32.608154 | 130.745231 | 2022-09-22 04:22:56 | Kumamoto, Japan | |||
1370499 | 1370499 | 2022-09-21 | Japan | Kyoto | 468962 | 1026 | 0 | 35.253815 | 135.443341 | 2022-09-22 04:22:56 | Kyoto, Japan | |||
1370500 | 1370500 | 2022-09-21 | Japan | Mie | 246002 | 514 | 0 | 34.508018 | 136.376013 | 2022-09-22 04:22:56 | Mie, Japan | |||
1370501 | 1370501 | 2022-09-21 | Japan | Miyagi | 252614 | 381 | 0 | 38.446859 | 140.927086 | 2022-09-22 04:22:56 | Miyagi, Japan | |||
1370502 | 1370502 | 2022-09-21 | Japan | Miyazaki | 191187 | 353 | 0 | 32.193204 | 131.299374 | 2022-09-22 04:22:56 | Miyazaki, Japan | |||
1370503 | 1370503 | 2022-09-21 | Japan | Nagano | 200855 | 334 | 0 | 36.132134 | 138.045528 | 2022-09-22 04:22:56 | Nagano, Japan | |||
1370504 | 1370504 | 2022-09-21 | Japan | Nagasaki | 208621 | 321 | 0 | 33.235712 | 129.608033 | 2022-09-22 04:22:56 | Nagasaki, Japan | |||
1370505 | 1370505 | 2022-09-21 | Japan | Nara | 215769 | 519 | 0 | 34.317451 | 135.871644 | 2022-09-22 04:22:56 | Nara, Japan | |||
1370506 | 1370506 | 2022-09-21 | Japan | Niigata | 225879 | 151 | 0 | 37.521819 | 138.918647 | 2022-09-22 04:22:56 | Niigata, Japan | |||
1370507 | 1370507 | 2022-09-21 | Japan | Oita | 172533 | 342 | 0 | 33.200697 | 131.43324 | 2022-09-22 04:22:56 | Oita, Japan | |||
1370508 | 1370508 | 2022-09-21 | Japan | Okayama | 266997 | 399 | 0 | 34.89246 | 133.826252 | 2022-09-22 04:22:56 | Okayama, Japan | |||
1370509 | 1370509 | 2022-09-21 | Japan | Okinawa | 495726 | 700 | 0 | 25.768923 | 126.668016 | 2022-09-22 04:22:56 | Okinawa, Japan | |||
1370510 | 1370510 | 2022-09-21 | Japan | Osaka | 2063524 | 6376 | 0 | 34.620965 | 135.507481 | 2022-09-22 04:22:56 | Osaka, Japan | |||
1370511 | 1370511 | 2022-09-21 | Japan | Port Quarantine | 21991 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
1370512 | 1370512 | 2022-09-21 | Japan | Saga | 154705 | 218 | 0 | 33.286977 | 130.115738 | 2022-09-22 04:22:56 | Saga, Japan | |||
1370513 | 1370513 | 2022-09-21 | Japan | Saitama | 1163383 | 2341 | 0 | 35.997101 | 139.347635 | 2022-09-22 04:22:56 | Saitama, Japan | |||
1370514 | 1370514 | 2022-09-21 | Japan | Shiga | 227843 | 309 | 0 | 35.215827 | 136.138064 | 2022-09-22 04:22:56 | Shiga, Japan | |||
1370515 | 1370515 | 2022-09-21 | Japan | Shimane | 80326 | 92 | 0 | 35.07076 | 132.554064 | 2022-09-22 04:22:56 | Shimane, Japan | |||
1370516 | 1370516 | 2022-09-21 | Japan | Shizuoka | 481650 | 736 | 0 | 34.916975 | 138.407784 | 2022-09-22 04:22:56 | Shizuoka, Japan | |||
1370517 | 1370517 | 2022-09-21 | Japan | Tochigi | 218379 | 484 | 0 | 36.689912 | 139.819213 | 2022-09-22 04:22:56 | Tochigi, Japan | |||
1370518 | 1370518 | 2022-09-21 | Japan | Tokushima | 90968 | 168 | 0 | 33.919178 | 134.242091 | 2022-09-22 04:22:56 | Tokushima, Japan | |||
1370519 | 1370519 | 2022-09-21 | Japan | Tokyo | 3116227 | 5753 | 0 | 35.711343 | 139.446921 | 2022-09-22 04:22:56 | Tokyo, Japan | |||
1370520 | 1370520 | 2022-09-21 | Japan | Tottori | 61020 | 71 | 0 | 35.359069 | 133.863619 | 2022-09-22 04:22:56 | Tottori, Japan | |||
1370521 | 1370521 | 2022-09-21 | Japan | Toyama | 125198 | 171 | 0 | 36.637464 | 137.269346 | 2022-09-22 04:22:56 | Toyama, Japan | |||
1370522 | 1370522 | 2022-09-21 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
1370523 | 1370523 | 2022-09-21 | Japan | Wakayama | 130120 | 246 | 0 | 33.911879 | 135.505446 | 2022-09-22 04:22:56 | Wakayama, Japan | |||
1370524 | 1370524 | 2022-09-21 | Japan | Yamagata | 101452 | 188 | 0 | 38.448396 | 140.102154 | 2022-09-22 04:22:56 | Yamagata, Japan | |||
1370525 | 1370525 | 2022-09-21 | Japan | Yamaguchi | 159281 | 378 | 0 | 34.20119 | 131.573293 | 2022-09-22 04:22:56 | Yamaguchi, Japan | |||
1370526 | 1370526 | 2022-09-21 | Japan | Yamanashi | 94018 | 152 | 0 | 35.612364 | 138.611489 | 2022-09-22 04:22:56 | Yamanashi, Japan | |||
1370527 | 1370527 | 2022-09-21 | Jordan | 1745032 | 14116 | 0 | 31.24 | 36.51 | 2022-09-22 04:22:56 | Jordan | ||||
1370528 | 1370528 | 2022-09-21 | Kazakhstan | 1482749 | 19048 | 0 | 48.0196 | 66.9237 | 2022-09-22 04:22:56 | Kazakhstan | ||||
1370529 | 1370529 | 2022-09-21 | Kenya | 338371 | 5675 | 0 | -0.0236 | 37.9062 | 2022-09-22 04:22:56 | Kenya |
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]);