daily_reports (view)
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)
province_or_state >30
- Texas 254,491
- Georgia 162,920
- Virginia 135,590
- Kentucky 121,675
- Missouri 117,101
- Kansas 105,758
- Illinois 104,685
- North Carolina 102,044
- Iowa 100,603
- Tennessee 98,183
- Indiana 94,151
- Nebraska 92,863
- Ohio 90,027
- Minnesota 88,465
- Michigan 87,758
- Mississippi 83,968
- Oklahoma 79,376
- Arkansas 76,709
- Wisconsin 73,611
- Puerto Rico 71,726
- Alabama 69,765
- Pennsylvania 68,850
- Florida 68,836
- Louisiana 66,723
- South Dakota 66,362
- Colorado 66,146
- New York 64,046
- California 59,941
- West Virginia 56,193
- Montana 54,982
- …
country_or_region >30
- US 3,284,537
- Russia 78,307
- Japan 46,430
- China 34,865
- India 34,605
- Colombia 32,189
- Mexico 31,389
- Ukraine 26,597
- Brazil 25,862
- Peru 24,679
- Italy 20,264
- Sweden 19,824
- United Kingdom 19,730
- Spain 19,298
- Malaysia 18,241
- Germany 16,427
- Chile 16,296
- Canada 16,227
- Netherlands 15,842
- France 11,972
- Belgium 9,618
- Australia 8,420
- Pakistan 6,636
- New Zealand 3,188
- Denmark 3,077
- Mainland China 1,517
- Antarctica 1,073
- Kiribati 1,073
- Korea, North 1,073
- Nauru 1,073
- …
day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | Italy | Marche | 124773 | 3154 | 0 | 43.61675973 | 13.5188753 | 2021-12-03 04:23:05 | Marche, Italy | |||
2021-12-02 | Italy | Molise | 15255 | 504 | 0 | 41.55774754 | 14.65916051 | 2021-12-03 04:23:05 | Molise, Italy | |||
2021-12-02 | Italy | P.A. Bolzano | 89347 | 1245 | 0 | 46.49933453 | 11.35662422 | 2021-12-03 04:23:05 | P.A. Bolzano, Italy | |||
2021-12-02 | Italy | P.A. Trento | 52489 | 1392 | 0 | 46.06893511 | 11.12123097 | 2021-12-03 04:23:05 | P.A. Trento, Italy | |||
2021-12-02 | Italy | Piemonte | 401394 | 11895 | 0 | 45.0732745 | 7.680687483 | 2021-12-03 04:23:05 | Piemonte, Italy | |||
2021-12-02 | Italy | Puglia | 280056 | 6889 | 0 | 41.12559576 | 16.86736689 | 2021-12-03 04:23:05 | Puglia, Italy | |||
2021-12-02 | Italy | Sardegna | 79160 | 1697 | 0 | 39.21531192 | 9.110616306 | 2021-12-03 04:23:05 | Sardegna, Italy | |||
2021-12-02 | Italy | Sicilia | 325626 | 7218 | 0 | 38.11569725 | 13.362356699999998 | 2021-12-03 04:23:05 | Sicilia, Italy | |||
2021-12-02 | Italy | Toscana | 302670 | 7415 | 0 | 43.76923077 | 11.25588885 | 2021-12-03 04:23:05 | Toscana, Italy | |||
2021-12-02 | Italy | Umbria | 67732 | 1492 | 0 | 43.10675841 | 12.38824698 | 2021-12-03 04:23:05 | Umbria, Italy | |||
2021-12-02 | Italy | Valle d'Aosta | 13321 | 479 | 0 | 45.73750286 | 7.320149366 | 2021-12-03 04:23:05 | Valle d'Aosta, Italy | |||
2021-12-02 | Italy | Veneto | 522687 | 11983 | 0 | 45.43490485 | 12.33845213 | 2021-12-03 04:23:05 | Veneto, Italy | |||
2021-12-02 | Jamaica | 91304 | 2402 | 0 | 18.1096 | -77.2975 | 2021-12-03 04:23:05 | Jamaica | ||||
2021-12-02 | Japan | Aichi | 106899 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-03 04:23:05 | Aichi, Japan | |||
2021-12-02 | Japan | Akita | 1927 | 27 | 0 | 39.748678999999996 | 140.408228 | 2021-12-03 04:23:05 | Akita, Japan | |||
2021-12-02 | Japan | Aomori | 5897 | 38 | 0 | 40.781541 | 140.828896 | 2021-12-03 04:23:05 | Aomori, Japan | |||
2021-12-02 | Japan | Chiba | 100466 | 1028 | 0 | 35.510141 | 140.198917 | 2021-12-03 04:23:05 | Chiba, Japan | |||
2021-12-02 | Japan | Ehime | 5412 | 82 | 0 | 33.624835 | 132.856842 | 2021-12-03 04:23:05 | Ehime, Japan | |||
2021-12-02 | Japan | Fukui | 3115 | 38 | 0 | 35.846614 | 136.22465400000002 | 2021-12-03 04:23:05 | Fukui, Japan | |||
2021-12-02 | Japan | Fukuoka | 74628 | 625 | 0 | 33.526032 | 130.666949 | 2021-12-03 04:23:05 | Fukuoka, Japan | |||
2021-12-02 | Japan | Fukushima | 9487 | 176 | 0 | 37.378867 | 140.223295 | 2021-12-03 04:23:05 | Fukushima, Japan | |||
2021-12-02 | Japan | Gifu | 18919 | 218 | 0 | 35.778671 | 137.055925 | 2021-12-03 04:23:05 | Gifu, Japan | |||
2021-12-02 | Japan | Gunma | 16906 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-12-03 04:23:05 | Gunma, Japan | |||
2021-12-02 | Japan | Hiroshima | 22175 | 202 | 0 | 34.605309000000005 | 132.788719 | 2021-12-03 04:23:05 | Hiroshima, Japan | |||
2021-12-02 | Japan | Hokkaido | 61157 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-12-03 04:23:05 | Hokkaido, Japan | |||
2021-12-02 | Japan | Hyogo | 78696 | 1396 | 0 | 35.039913 | 134.828057 | 2021-12-03 04:23:05 | Hyogo, Japan | |||
2021-12-02 | Japan | Ibaraki | 24449 | 220 | 0 | 36.303588 | 140.319591 | 2021-12-03 04:23:05 | Ibaraki, Japan | |||
2021-12-02 | Japan | Ishikawa | 7969 | 129 | 0 | 36.769464 | 136.771027 | 2021-12-03 04:23:05 | Ishikawa, Japan | |||
2021-12-02 | Japan | Iwate | 3487 | 53 | 0 | 39.593287 | 141.361777 | 2021-12-03 04:23:05 | Iwate, Japan | |||
2021-12-02 | Japan | Kagawa | 4702 | 38 | 0 | 34.217292 | 133.969047 | 2021-12-03 04:23:05 | Kagawa, Japan | |||
2021-12-02 | Japan | Kagoshima | 9103 | 66 | 0 | 31.009484000000004 | 130.430665 | 2021-12-03 04:23:05 | Kagoshima, Japan | |||
2021-12-02 | Japan | Kanagawa | 169295 | 1314 | 0 | 35.415312 | 139.338983 | 2021-12-03 04:23:05 | Kanagawa, Japan | |||
2021-12-02 | Japan | Kochi | 4167 | 33 | 0 | 33.422519 | 133.367307 | 2021-12-03 04:23:05 | Kochi, Japan | |||
2021-12-02 | Japan | Kumamoto | 14395 | 136 | 0 | 32.608154 | 130.74523100000002 | 2021-12-03 04:23:05 | Kumamoto, Japan | |||
2021-12-02 | Japan | Kyoto | 35991 | 291 | 0 | 35.253815 | 135.443341 | 2021-12-03 04:23:05 | Kyoto, Japan | |||
2021-12-02 | Japan | Mie | 14813 | 163 | 0 | 34.508018 | 136.376013 | 2021-12-03 04:23:05 | Mie, Japan | |||
2021-12-02 | Japan | Miyagi | 16280 | 118 | 0 | 38.446859 | 140.927086 | 2021-12-03 04:23:05 | Miyagi, Japan | |||
2021-12-02 | Japan | Miyazaki | 6137 | 41 | 0 | 32.193203999999994 | 131.299374 | 2021-12-03 04:23:05 | Miyazaki, Japan | |||
2021-12-02 | Japan | Nagano | 8885 | 97 | 0 | 36.132134 | 138.045528 | 2021-12-03 04:23:05 | Nagano, Japan | |||
2021-12-02 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-03 04:23:05 | Nagasaki, Japan | |||
2021-12-02 | Japan | Nara | 15646 | 149 | 0 | 34.317451 | 135.871644 | 2021-12-03 04:23:05 | Nara, Japan | |||
2021-12-02 | Japan | Niigata | 8030 | 61 | 0 | 37.521819 | 138.918647 | 2021-12-03 04:23:05 | Niigata, Japan | |||
2021-12-02 | Japan | Oita | 8187 | 84 | 0 | 33.200697 | 131.43323999999998 | 2021-12-03 04:23:05 | Oita, Japan | |||
2021-12-02 | Japan | Okayama | 15543 | 136 | 0 | 34.89246 | 133.826252 | 2021-12-03 04:23:05 | Okayama, Japan | |||
2021-12-02 | Japan | Okinawa | 50317 | 398 | 0 | 25.768923 | 126.668016 | 2021-12-03 04:23:05 | Okinawa, Japan | |||
2021-12-02 | Japan | Osaka | 203166 | 3064 | 0 | 34.620965000000005 | 135.507481 | 2021-12-03 04:23:05 | Osaka, Japan | |||
2021-12-02 | Japan | Port Quarantine | 4629 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
2021-12-02 | Japan | Saga | 5866 | 30 | 0 | 33.286977 | 130.115738 | 2021-12-03 04:23:05 | Saga, Japan | |||
2021-12-02 | Japan | Saitama | 115854 | 1057 | 0 | 35.997101 | 139.347635 | 2021-12-03 04:23:05 | Saitama, Japan | |||
2021-12-02 | Japan | Shiga | 12432 | 104 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-12-03 04:23:05 | Shiga, Japan | |||
2021-12-02 | Japan | Shimane | 1732 | 5 | 0 | 35.07076 | 132.55406399999998 | 2021-12-03 04:23:05 | Shimane, Japan | |||
2021-12-02 | Japan | Shizuoka | 26791 | 209 | 0 | 34.916975 | 138.40778400000002 | 2021-12-03 04:23:05 | Shizuoka, Japan | |||
2021-12-02 | Japan | Tochigi | 15485 | 117 | 0 | 36.689912 | 139.819213 | 2021-12-03 04:23:05 | Tochigi, Japan | |||
2021-12-02 | Japan | Tokushima | 3291 | 66 | 0 | 33.919178 | 134.242091 | 2021-12-03 04:23:05 | Tokushima, Japan | |||
2021-12-02 | Japan | Tokyo | 382207 | 3167 | 0 | 35.711343 | 139.446921 | 2021-12-03 04:23:05 | Tokyo, Japan | |||
2021-12-02 | Japan | Tottori | 1669 | 5 | 0 | 35.359069 | 133.863619 | 2021-12-03 04:23:05 | Tottori, Japan | |||
2021-12-02 | Japan | Toyama | 4868 | 52 | 0 | 36.637464 | 137.26934599999998 | 2021-12-03 04:23:05 | Toyama, Japan | |||
2021-12-02 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
2021-12-02 | Japan | Wakayama | 5303 | 62 | 0 | 33.911879 | 135.505446 | 2021-12-03 04:23:05 | Wakayama, Japan | |||
2021-12-02 | Japan | Yamagata | 3582 | 56 | 0 | 38.448396 | 140.102154 | 2021-12-03 04:23:05 | Yamagata, Japan | |||
2021-12-02 | Japan | Yamaguchi | 5792 | 93 | 0 | 34.201190000000004 | 131.573293 | 2021-12-03 04:23:05 | Yamaguchi, Japan | |||
2021-12-02 | Japan | Yamanashi | 5156 | 29 | 0 | 35.612364 | 138.61148899999998 | 2021-12-03 04:23:05 | Yamanashi, Japan | |||
2021-12-02 | Jordan | 963655 | 11661 | 0 | 31.24 | 36.51 | 2021-12-03 04:23:05 | Jordan | ||||
2021-12-02 | Kazakhstan | 1056517 | 17871 | 0 | 48.0196 | 66.9237 | 2021-12-03 04:23:05 | Kazakhstan | ||||
2021-12-02 | Kenya | 255260 | 5335 | 0 | -0.0236 | 37.9062 | 2021-12-03 04:23:05 | Kenya | ||||
2021-12-02 | Kiribati | 2 | 0 | 0 | -3.3704 | -168.734 | 2021-12-03 04:23:05 | Kiribati | ||||
2021-12-02 | Korea, South | 462555 | 3739 | 0 | 35.90775700000001 | 127.766922 | 2021-12-03 04:23:05 | Korea, South | ||||
2021-12-02 | Kosovo | 161115 | 2984 | 0 | 42.602636 | 20.902977 | 2021-12-03 04:23:05 | Kosovo | ||||
2021-12-02 | Kuwait | 413419 | 2465 | 0 | 29.311659999999996 | 47.481766 | 2021-12-03 04:23:05 | Kuwait | ||||
2021-12-02 | Kyrgyzstan | 183460 | 2752 | 0 | 41.20438 | 74.766098 | 2021-12-03 04:23:05 | Kyrgyzstan | ||||
2021-12-02 | Laos | 76496 | 186 | 0 | 19.856270000000002 | 102.495496 | 2021-12-03 04:23:05 | Laos | ||||
2021-12-02 | Latvia | 255402 | 4232 | 0 | 56.8796 | 24.6032 | 2021-12-03 04:23:05 | Latvia | ||||
2021-12-02 | Lebanon | 674000 | 8745 | 0 | 33.8547 | 35.8623 | 2021-12-03 04:23:05 | Lebanon | ||||
2021-12-02 | Lesotho | 21807 | 663 | 0 | -29.61 | 28.2336 | 2021-12-03 04:23:05 | Lesotho | ||||
2021-12-02 | Liberia | 5824 | 287 | 0 | 6.4280550000000005 | -9.429499 | 2021-12-03 04:23:05 | Liberia | ||||
2021-12-02 | Libya | 373739 | 5476 | 0 | 26.3351 | 17.228331 | 2021-12-03 04:23:05 | Libya | ||||
2021-12-02 | Liechtenstein | 4809 | 62 | 0 | 47.14 | 9.55 | 2021-12-03 04:23:05 | Liechtenstein | ||||
2021-12-02 | Lithuania | 477674 | 6803 | 0 | 55.1694 | 23.8813 | 2021-12-03 04:23:05 | Lithuania | ||||
2021-12-02 | Luxembourg | 90336 | 879 | 0 | 49.8153 | 6.1296 | 2021-12-03 04:23:05 | Luxembourg | ||||
2021-12-02 | MS Zaandam | 9 | 2 | 0 | 2021-12-03 04:23:05 | MS Zaandam | ||||||
2021-12-02 | Madagascar | 44330 | 967 | 0 | -18.766947000000002 | 46.869107 | 2021-12-03 04:23:05 | Madagascar | ||||
2021-12-02 | Malawi | 61936 | 2307 | 0 | -13.2543 | 34.3015 | 2021-12-03 04:23:05 | Malawi | ||||
2021-12-02 | Malaysia | Johor | 233086 | 3777 | 0 | 1.4854 | 103.7618 | 2021-12-03 04:23:05 | Johor, Malaysia | |||
2021-12-02 | Malaysia | Kedah | 160530 | 2092 | 0 | 6.1184 | 100.3685 | 2021-12-03 04:23:05 | Kedah, Malaysia | |||
2021-12-02 | Malaysia | Kelantan | 157699 | 1178 | 0 | 6.1254 | 102.2381 | 2021-12-03 04:23:05 | Kelantan, Malaysia | |||
2021-12-02 | Malaysia | Melaka | 71448 | 938 | 0 | 2.1896 | 102.2501 | 2021-12-03 04:23:05 | Melaka, Malaysia | |||
2021-12-02 | Malaysia | Negeri Sembilan | 108958 | 1276 | 0 | 2.7258 | 101.9424 | 2021-12-03 04:23:05 | Negeri Sembilan, Malaysia | |||
2021-12-02 | Malaysia | Pahang | 87306 | 716 | 0 | 3.8126 | 103.3256 | 2021-12-03 04:23:05 | Pahang, Malaysia | |||
2021-12-02 | Malaysia | Perak | 123433 | 1272 | 0 | 4.5921 | 101.0901 | 2021-12-03 04:23:05 | Perak, Malaysia | |||
2021-12-02 | Malaysia | Perlis | 6421 | 124 | 0 | 6.4449 | 100.2048 | 2021-12-03 04:23:05 | Perlis, Malaysia | |||
2021-12-02 | Malaysia | Pulau Pinang | 153744 | 1659 | 0 | 5.4141 | 100.3288 | 2021-12-03 04:23:05 | Pulau Pinang, Malaysia | |||
2021-12-02 | Malaysia | Sabah | 234127 | 2696 | 0 | 5.9788 | 116.0753 | 2021-12-03 04:23:05 | Sabah, Malaysia | |||
2021-12-02 | Malaysia | Sarawak | 250932 | 1590 | 0 | 1.5533 | 110.3592 | 2021-12-03 04:23:05 | Sarawak, Malaysia | |||
2021-12-02 | Malaysia | Selangor | 756781 | 9808 | 0 | 3.0738 | 101.5183 | 2021-12-03 04:23:05 | Selangor, Malaysia | |||
2021-12-02 | Malaysia | Terengganu | 76887 | 605 | 0 | 5.3117 | 103.1324 | 2021-12-03 04:23:05 | Terengganu, Malaysia | |||
2021-12-02 | Malaysia | Unknown | 0 | 0 | 0 | 2021-12-03 04:23:05 | Unknown, Malaysia | |||||
2021-12-02 | Malaysia | W.P. Kuala Lumpur | 203561 | 2619 | 0 | 3.139 | 101.6869 | 2021-12-03 04:23:05 | W.P. Kuala Lumpur, Malaysia | |||
2021-12-02 | Malaysia | W.P. Labuan | 10523 | 150 | 0 | 5.2831 | 115.2308 | 2021-12-03 04:23:05 | W.P. Labuan, Malaysia | |||
2021-12-02 | Malaysia | W.P. Putrajaya | 8591 | 21 | 0 | 2.9264 | 101.6964 | 2021-12-03 04:23:05 | W.P. Putrajaya, Malaysia | |||
2021-12-02 | Maldives | 91893 | 251 | 0 | 3.2028 | 73.2207 | 2021-12-03 04:23:05 | Maldives |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;