johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by admin2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
427281 | 427281 | 2020-09-07 | India | Goa | 21173 | 245 | 16427 | 4501 | 15.359682 | 74.057396 | 2020-09-08 04:28:25 | Goa, India | ||
427282 | 427282 | 2020-09-07 | India | Gujarat | 105509 | 3120 | 85907 | 16482 | 22.694884 | 71.590923 | 2020-09-08 04:28:25 | Gujarat, India | ||
427283 | 427283 | 2020-09-07 | India | Haryana | 78773 | 829 | 61611 | 16333 | 29.20004 | 76.332824 | 2020-09-08 04:28:25 | Haryana, India | ||
427284 | 427284 | 2020-09-07 | India | Himachal Pradesh | 7660 | 56 | 5370 | 2234 | 31.927213 | 77.233081 | 2020-09-08 04:28:25 | Himachal Pradesh, India | ||
427285 | 427285 | 2020-09-07 | India | Jammu and Kashmir | 44570 | 801 | 32760 | 11009 | 33.75943 | 76.612638 | 2020-09-08 04:28:25 | Jammu and Kashmir, India | ||
427286 | 427286 | 2020-09-07 | India | Jharkhand | 52620 | 482 | 37550 | 14588 | 23.654536 | 85.557631 | 2020-09-08 04:28:25 | Jharkhand, India | ||
427287 | 427287 | 2020-09-07 | India | Karnataka | 404324 | 6534 | 300770 | 97020 | 14.70518 | 76.166436 | 2020-09-08 04:28:25 | Karnataka, India | ||
427288 | 427288 | 2020-09-07 | India | Kerala | 89489 | 359 | 66997 | 22133 | 10.450898 | 76.405749 | 2020-09-08 04:28:25 | Kerala, India | ||
427289 | 427289 | 2020-09-07 | India | Ladakh | 3064 | 35 | 2211 | 818 | 34.1526 | 77.5771 | 2020-09-08 04:28:25 | Ladakh, India | ||
427290 | 427290 | 2020-09-07 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2020-09-08 04:28:25 | Lakshadweep, India | ||
427291 | 427291 | 2020-09-07 | India | Madhya Pradesh | 75459 | 1589 | 56909 | 16961 | 23.541513 | 78.289633 | 2020-09-08 04:28:25 | Madhya Pradesh, India | ||
427292 | 427292 | 2020-09-07 | India | Maharashtra | 923641 | 27027 | 659322 | 237292 | 19.449759 | 76.108221 | 2020-09-08 04:28:25 | Maharashtra, India | ||
427293 | 427293 | 2020-09-07 | India | Manipur | 7106 | 38 | 5358 | 1710 | 24.738975 | 93.882541 | 2020-09-08 04:28:25 | Manipur, India | ||
427294 | 427294 | 2020-09-07 | India | Meghalaya | 3034 | 17 | 1560 | 1457 | 25.536934 | 91.278882 | 2020-09-08 04:28:25 | Meghalaya, India | ||
427295 | 427295 | 2020-09-07 | India | Mizoram | 1114 | 0 | 735 | 379 | 23.309381 | 92.83822 | 2020-09-08 04:28:25 | Mizoram, India | ||
427296 | 427296 | 2020-09-07 | India | Nagaland | 4220 | 10 | 3685 | 525 | 26.06702 | 94.470302 | 2020-09-08 04:28:25 | Nagaland, India | ||
427297 | 427297 | 2020-09-07 | India | Odisha | 127892 | 556 | 99398 | 27938 | 20.505428 | 84.418059 | 2020-09-08 04:28:25 | Odisha, India | ||
427298 | 427298 | 2020-09-07 | India | Puducherry | 17316 | 325 | 12135 | 4856 | 11.882658 | 78.86498 | 2020-09-08 04:28:25 | Puducherry, India | ||
427299 | 427299 | 2020-09-07 | India | Punjab | 65583 | 1923 | 47020 | 16640 | 30.841465000000003 | 75.40879 | 2020-09-08 04:28:25 | Punjab, India | ||
427300 | 427300 | 2020-09-07 | India | Rajasthan | 92536 | 1151 | 76427 | 14958 | 26.583423 | 73.847973 | 2020-09-08 04:28:25 | Rajasthan, India | ||
427301 | 427301 | 2020-09-07 | India | Sikkim | 1939 | 5 | 1396 | 538 | 27.571671 | 88.472712 | 2020-09-08 04:28:25 | Sikkim, India | ||
427302 | 427302 | 2020-09-07 | India | Tamil Nadu | 469256 | 7925 | 410116 | 51215 | 11.006091 | 78.400624 | 2020-09-08 04:28:25 | Tamil Nadu, India | ||
427303 | 427303 | 2020-09-07 | India | Telangana | 145163 | 906 | 112587 | 31670 | 18.1124 | 79.0193 | 2020-09-08 04:28:25 | Telangana, India | ||
427304 | 427304 | 2020-09-07 | India | Tripura | 16135 | 152 | 9342 | 6641 | 23.746783 | 91.743565 | 2020-09-08 04:28:25 | Tripura, India | ||
427305 | 427305 | 2020-09-07 | India | Unknown | 0 | 0 | 0 | 0 | 2020-09-08 04:28:25 | Unknown, India | ||||
427306 | 427306 | 2020-09-07 | India | Uttar Pradesh | 271851 | 3976 | 205731 | 62144 | 26.925425 | 80.560982 | 2020-09-08 04:28:25 | Uttar Pradesh, India | ||
427307 | 427307 | 2020-09-07 | India | Uttarakhand | 25436 | 348 | 17123 | 7965 | 30.156447 | 79.197608 | 2020-09-08 04:28:25 | Uttarakhand, India | ||
427308 | 427308 | 2020-09-07 | India | West Bengal | 183865 | 3620 | 157029 | 23216 | 23.814082 | 87.979803 | 2020-09-08 04:28:25 | West Bengal, India | ||
427309 | 427309 | 2020-09-07 | Indonesia | 196989 | 8130 | 140652 | 48207 | -0.7893 | 113.9213 | 2020-09-08 04:28:25 | Indonesia | |||
427310 | 427310 | 2020-09-07 | Iran | 388810 | 22410 | 335572 | 30828 | 32.427908 | 53.68804599999999 | 2020-09-08 04:28:25 | Iran | |||
427311 | 427311 | 2020-09-07 | Iraq | 264684 | 7589 | 202859 | 54236 | 33.223191 | 43.679291 | 2020-09-08 04:28:25 | Iraq | |||
427312 | 427312 | 2020-09-07 | Ireland | 29774 | 1777 | 23364 | 4633 | 53.1424 | -7.6921 | 2020-09-08 04:28:25 | Ireland | |||
427313 | 427313 | 2020-09-07 | Israel | 134705 | 1054 | 105022 | 28629 | 31.046051 | 34.851612 | 2020-09-08 04:28:25 | Israel | |||
427314 | 427314 | 2020-09-07 | Italy | Abruzzo | 3906 | 472 | 2914 | 520 | 42.35122196 | 13.39843823 | 2020-09-08 04:28:25 | Abruzzo, Italy | ||
427315 | 427315 | 2020-09-07 | Italy | Basilicata | 565 | 28 | 418 | 119 | 40.63947052 | 15.80514834 | 2020-09-08 04:28:25 | Basilicata, Italy | ||
427316 | 427316 | 2020-09-07 | Italy | Calabria | 1640 | 98 | 1187 | 355 | 38.90597598 | 16.59440194 | 2020-09-08 04:28:25 | Calabria, Italy | ||
427317 | 427317 | 2020-09-07 | Italy | Campania | 8128 | 448 | 4490 | 3190 | 40.83956555 | 14.25084984 | 2020-09-08 04:28:25 | Campania, Italy | ||
427318 | 427318 | 2020-09-07 | Italy | Emilia-Romagna | 32760 | 4464 | 24803 | 3493 | 44.49436681 | 11.3417208 | 2020-09-08 04:28:25 | Emilia-Romagna, Italy | ||
427319 | 427319 | 2020-09-07 | Italy | Friuli Venezia Giulia | 3934 | 349 | 3123 | 462 | 45.6494354 | 13.76813649 | 2020-09-08 04:28:25 | Friuli Venezia Giulia, Italy | ||
427320 | 427320 | 2020-09-07 | Italy | Lazio | 12210 | 881 | 7294 | 4035 | 41.89277044 | 12.48366722 | 2020-09-08 04:28:25 | Lazio, Italy | ||
427321 | 427321 | 2020-09-07 | Italy | Liguria | 11351 | 1577 | 8951 | 823 | 44.41149315 | 8.9326992 | 2020-09-08 04:28:25 | Liguria, Italy | ||
427322 | 427322 | 2020-09-07 | Italy | Lombardia | 101814 | 16886 | 76818 | 8110 | 45.46679409 | 9.190347404 | 2020-09-08 04:28:25 | Lombardia, Italy | ||
427323 | 427323 | 2020-09-07 | Italy | Marche | 7369 | 988 | 5994 | 387 | 43.61675973 | 13.5188753 | 2020-09-08 04:28:25 | Marche, Italy | ||
427324 | 427324 | 2020-09-07 | Italy | Molise | 545 | 23 | 436 | 86 | 41.55774754 | 14.65916051 | 2020-09-08 04:28:25 | Molise, Italy | ||
427325 | 427325 | 2020-09-07 | Italy | P.A. Bolzano | 3003 | 292 | 2496 | 215 | 46.49933453 | 11.35662422 | 2020-09-08 04:28:25 | P.A. Bolzano, Italy | ||
427326 | 427326 | 2020-09-07 | Italy | P.A. Trento | 5349 | 405 | 4629 | 315 | 46.06893511 | 11.12123097 | 2020-09-08 04:28:25 | P.A. Trento, Italy | ||
427327 | 427327 | 2020-09-07 | Italy | Piemonte | 33293 | 4151 | 27390 | 1752 | 45.0732745 | 7.680687483 | 2020-09-08 04:28:25 | Piemonte, Italy | ||
427328 | 427328 | 2020-09-07 | Italy | Puglia | 5899 | 565 | 4137 | 1197 | 41.12559576 | 16.86736689 | 2020-09-08 04:28:25 | Puglia, Italy | ||
427329 | 427329 | 2020-09-07 | Italy | Sardegna | 2564 | 136 | 1286 | 1142 | 39.21531192 | 9.110616306 | 2020-09-08 04:28:25 | Sardegna, Italy | ||
427330 | 427330 | 2020-09-07 | Italy | Sicilia | 4765 | 289 | 3097 | 1379 | 38.11569725 | 13.362356699999998 | 2020-09-08 04:28:25 | Sicilia, Italy | ||
427331 | 427331 | 2020-09-07 | Italy | Toscana | 12499 | 1144 | 9285 | 2070 | 43.76923077 | 11.25588885 | 2020-09-08 04:28:25 | Toscana, Italy | ||
427332 | 427332 | 2020-09-07 | Italy | Umbria | 1928 | 81 | 1481 | 366 | 43.10675841 | 12.38824698 | 2020-09-08 04:28:25 | Umbria, Italy | ||
427333 | 427333 | 2020-09-07 | Italy | Valle d'Aosta | 1249 | 146 | 1069 | 34 | 45.73750286 | 7.320149366 | 2020-09-08 04:28:25 | Valle d'Aosta, Italy | ||
427334 | 427334 | 2020-09-07 | Italy | Veneto | 24013 | 2130 | 18940 | 2943 | 45.43490485 | 12.33845213 | 2020-09-08 04:28:25 | Veneto, Italy | ||
427335 | 427335 | 2020-09-07 | Jamaica | 3183 | 34 | 974 | 2175 | 18.1096 | -77.2975 | 2020-09-08 04:28:25 | Jamaica | |||
427336 | 427336 | 2020-09-07 | Japan | Aichi | 4784 | 74 | 4033 | 677 | 35.035551 | 137.211621 | 2020-09-08 04:28:25 | Aichi, Japan | ||
427337 | 427337 | 2020-09-07 | Japan | Akita | 50 | 0 | 47 | 3 | 39.748679 | 140.408228 | 2020-09-08 04:28:25 | Akita, Japan | ||
427338 | 427338 | 2020-09-07 | Japan | Aomori | 35 | 1 | 32 | 2 | 40.781541 | 140.828896 | 2020-09-08 04:28:25 | Aomori, Japan | ||
427339 | 427339 | 2020-09-07 | Japan | Chiba | 3211 | 64 | 2826 | 321 | 35.510141 | 140.198917 | 2020-09-08 04:28:25 | Chiba, Japan | ||
427340 | 427340 | 2020-09-07 | Japan | Ehime | 114 | 6 | 107 | 1 | 33.624835 | 132.856842 | 2020-09-08 04:28:25 | Ehime, Japan | ||
427341 | 427341 | 2020-09-07 | Japan | Fukui | 243 | 8 | 168 | 67 | 35.846614 | 136.22465400000002 | 2020-09-08 04:28:25 | Fukui, Japan | ||
427342 | 427342 | 2020-09-07 | Japan | Fukuoka | 4814 | 69 | 3997 | 748 | 33.526032 | 130.666949 | 2020-09-08 04:28:25 | Fukuoka, Japan | ||
427343 | 427343 | 2020-09-07 | Japan | Fukushima | 179 | 0 | 131 | 48 | 37.378867 | 140.223295 | 2020-09-08 04:28:25 | Fukushima, Japan | ||
427344 | 427344 | 2020-09-07 | Japan | Gifu | 564 | 10 | 532 | 22 | 35.778671 | 137.055925 | 2020-09-08 04:28:25 | Gifu, Japan | ||
427345 | 427345 | 2020-09-07 | Japan | Gunma | 491 | 19 | 392 | 80 | 36.504479 | 138.985605 | 2020-09-08 04:28:25 | Gunma, Japan | ||
427346 | 427346 | 2020-09-07 | Japan | Hiroshima | 460 | 3 | 447 | 10 | 34.605309000000005 | 132.788719 | 2020-09-08 04:28:25 | Hiroshima, Japan | ||
427347 | 427347 | 2020-09-07 | Japan | Hokkaido | 1834 | 105 | 1623 | 106 | 43.385711 | 142.552318 | 2020-09-08 04:28:25 | Hokkaido, Japan | ||
427348 | 427348 | 2020-09-07 | Japan | Hyogo | 2360 | 54 | 2163 | 143 | 35.039913 | 134.828057 | 2020-09-08 04:28:25 | Hyogo, Japan | ||
427349 | 427349 | 2020-09-07 | Japan | Ibaraki | 583 | 14 | 503 | 66 | 36.303588 | 140.319591 | 2020-09-08 04:28:25 | Ibaraki, Japan | ||
427350 | 427350 | 2020-09-07 | Japan | Ishikawa | 708 | 39 | 573 | 96 | 36.769464 | 136.771027 | 2020-09-08 04:28:25 | Ishikawa, Japan | ||
427351 | 427351 | 2020-09-07 | Japan | Iwate | 23 | 0 | 17 | 6 | 39.593287 | 141.361777 | 2020-09-08 04:28:25 | Iwate, Japan | ||
427352 | 427352 | 2020-09-07 | Japan | Kagawa | 86 | 2 | 73 | 11 | 34.217292 | 133.969047 | 2020-09-08 04:28:25 | Kagawa, Japan | ||
427353 | 427353 | 2020-09-07 | Japan | Kagoshima | 371 | 11 | 319 | 41 | 31.009484000000004 | 130.430665 | 2020-09-08 04:28:25 | Kagoshima, Japan | ||
427354 | 427354 | 2020-09-07 | Japan | Kanagawa | 5457 | 126 | 4716 | 615 | 35.415312 | 139.338983 | 2020-09-08 04:28:25 | Kanagawa, Japan | ||
427355 | 427355 | 2020-09-07 | Japan | Kochi | 132 | 3 | 118 | 11 | 33.422519 | 133.367307 | 2020-09-08 04:28:25 | Kochi, Japan | ||
427356 | 427356 | 2020-09-07 | Japan | Kumamoto | 547 | 8 | 474 | 65 | 32.608154 | 130.74523100000002 | 2020-09-08 04:28:25 | Kumamoto, Japan | ||
427357 | 427357 | 2020-09-07 | Japan | Kyoto | 1583 | 25 | 1340 | 218 | 35.253815 | 135.443341 | 2020-09-08 04:28:25 | Kyoto, Japan | ||
427358 | 427358 | 2020-09-07 | Japan | Mie | 435 | 3 | 346 | 86 | 34.508018 | 136.376013 | 2020-09-08 04:28:25 | Mie, Japan | ||
427359 | 427359 | 2020-09-07 | Japan | Miyagi | 249 | 2 | 192 | 55 | 38.446859 | 140.927086 | 2020-09-08 04:28:25 | Miyagi, Japan | ||
427360 | 427360 | 2020-09-07 | Japan | Miyazaki | 360 | 1 | 318 | 41 | 32.193203999999994 | 131.299374 | 2020-09-08 04:28:25 | Miyazaki, Japan | ||
427361 | 427361 | 2020-09-07 | Japan | Nagano | 290 | 1 | 230 | 59 | 36.132134 | 138.045528 | 2020-09-08 04:28:25 | Nagano, Japan | ||
427362 | 427362 | 2020-09-07 | Japan | Nagasaki | 234 | 3 | 201 | 30 | 33.235712 | 129.608033 | 2020-09-08 04:28:25 | Nagasaki, Japan | ||
427363 | 427363 | 2020-09-07 | Japan | Nara | 532 | 8 | 487 | 37 | 34.317451 | 135.871644 | 2020-09-08 04:28:25 | Nara, Japan | ||
427364 | 427364 | 2020-09-07 | Japan | Niigata | 144 | 0 | 137 | 7 | 37.521819 | 138.918647 | 2020-09-08 04:28:25 | Niigata, Japan | ||
427365 | 427365 | 2020-09-07 | Japan | Oita | 157 | 2 | 136 | 19 | 33.200697 | 131.43323999999998 | 2020-09-08 04:28:25 | Oita, Japan | ||
427366 | 427366 | 2020-09-07 | Japan | Okayama | 146 | 1 | 141 | 4 | 34.89246 | 133.826252 | 2020-09-08 04:28:25 | Okayama, Japan | ||
427367 | 427367 | 2020-09-07 | Japan | Okinawa | 2224 | 36 | 1847 | 341 | 25.768923 | 126.668016 | 2020-09-08 04:28:25 | Okinawa, Japan | ||
427368 | 427368 | 2020-09-07 | Japan | Osaka | 9088 | 166 | 7929 | 993 | 34.620965000000005 | 135.507481 | 2020-09-08 04:28:25 | Osaka, Japan | ||
427369 | 427369 | 2020-09-07 | Japan | Port Quarantine | 828 | 1 | 514 | 313 | 2020-09-08 04:28:25 | Port Quarantine, Japan | ||||
427370 | 427370 | 2020-09-07 | Japan | Saga | 241 | 0 | 230 | 11 | 33.286977 | 130.115738 | 2020-09-08 04:28:25 | Saga, Japan | ||
427371 | 427371 | 2020-09-07 | Japan | Saitama | 4132 | 94 | 3585 | 453 | 35.997101 | 139.347635 | 2020-09-08 04:28:25 | Saitama, Japan | ||
427372 | 427372 | 2020-09-07 | Japan | Shiga | 464 | 7 | 403 | 54 | 35.21582700000001 | 136.138064 | 2020-09-08 04:28:25 | Shiga, Japan | ||
427373 | 427373 | 2020-09-07 | Japan | Shimane | 137 | 0 | 137 | 0 | 35.07076 | 132.55406399999998 | 2020-09-08 04:28:25 | Shimane, Japan | ||
427374 | 427374 | 2020-09-07 | Japan | Shizuoka | 494 | 1 | 451 | 42 | 34.916975 | 138.40778400000002 | 2020-09-08 04:28:25 | Shizuoka, Japan | ||
427375 | 427375 | 2020-09-07 | Japan | Tochigi | 314 | 1 | 292 | 21 | 36.689912 | 139.819213 | 2020-09-08 04:28:25 | Tochigi, Japan | ||
427376 | 427376 | 2020-09-07 | Japan | Tokushima | 145 | 5 | 78 | 62 | 33.919178 | 134.242091 | 2020-09-08 04:28:25 | Tokushima, Japan | ||
427377 | 427377 | 2020-09-07 | Japan | Tokyo | 21845 | 372 | 18967 | 2506 | 35.711343 | 139.446921 | 2020-09-08 04:28:25 | Tokyo, Japan | ||
427378 | 427378 | 2020-09-07 | Japan | Tottori | 22 | 0 | 22 | 0 | 35.359069 | 133.863619 | 2020-09-08 04:28:25 | Tottori, Japan | ||
427379 | 427379 | 2020-09-07 | Japan | Toyama | 403 | 25 | 339 | 39 | 36.637464 | 137.26934599999998 | 2020-09-08 04:28:25 | Toyama, Japan | ||
427380 | 427380 | 2020-09-07 | Japan | Unknown | 8 | 0 | 8 | 0 | 2020-09-08 04:28:25 | Unknown, 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]);