daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by province_or_state
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 | Marshall Islands | 4 | 0 | 0 | 7.1315 | 171.1845 | 2021-12-03 04:23:05 | Marshall Islands | ||||
2021-12-02 | Mauritania | 39408 | 835 | 0 | 21.0079 | -10.9408 | 2021-12-03 04:23:05 | Mauritania | ||||
2021-12-02 | Mauritius | 56048 | 568 | 0 | -20.348404000000002 | 57.552152 | 2021-12-03 04:23:05 | Mauritius | ||||
2021-12-02 | Micronesia | 1 | 0 | 0 | 7.4256 | 150.5508 | 2021-12-03 04:23:05 | Micronesia | ||||
2021-12-02 | Moldova | 365165 | 9162 | 0 | 47.4116 | 28.3699 | 2021-12-03 04:23:05 | Moldova | ||||
2021-12-02 | Monaco | 3820 | 36 | 0 | 43.7333 | 7.4167 | 2021-12-03 04:23:05 | Monaco | ||||
2021-12-02 | Mongolia | 672184 | 1935 | 0 | 46.8625 | 103.8467 | 2021-12-03 04:23:05 | Mongolia | ||||
2021-12-02 | Montenegro | 157869 | 2314 | 0 | 42.708678000000006 | 19.37439 | 2021-12-03 04:23:05 | Montenegro | ||||
2021-12-02 | Morocco | 950223 | 14782 | 0 | 31.7917 | -7.0926 | 2021-12-03 04:23:05 | Morocco | ||||
2021-12-02 | Mozambique | 151652 | 1941 | 0 | -18.665695 | 35.529562 | 2021-12-03 04:23:05 | Mozambique | ||||
2021-12-02 | Namibia | 129243 | 3573 | 0 | -22.9576 | 18.4904 | 2021-12-03 04:23:05 | Namibia | ||||
2021-12-02 | Nepal | 821949 | 11535 | 0 | 28.1667 | 84.25 | 2021-12-03 04:23:05 | Nepal | ||||
2021-12-02 | New Zealand | 11992 | 41 | 0 | -40.9006 | 174.886 | 2021-12-03 04:23:05 | New Zealand | ||||
2021-12-02 | Nicaragua | 13397 | 213 | 0 | 12.865416 | -85.207229 | 2021-12-03 04:23:05 | Nicaragua | ||||
2021-12-02 | Niger | 7056 | 261 | 0 | 17.607789 | 8.081666 | 2021-12-03 04:23:05 | Niger | ||||
2021-12-02 | Nigeria | 214270 | 2978 | 0 | 9.082 | 8.6753 | 2021-12-03 04:23:05 | Nigeria | ||||
2021-12-02 | North Macedonia | 216328 | 7609 | 0 | 41.6086 | 21.7453 | 2021-12-03 04:23:05 | North Macedonia | ||||
2021-12-02 | Norway | 275763 | 1093 | 0 | 60.472 | 8.4689 | 2021-12-03 04:23:05 | Norway | ||||
2021-12-02 | Oman | 304581 | 4113 | 0 | 21.512583 | 55.92325500000001 | 2021-12-03 04:23:05 | Oman | ||||
2021-12-02 | Palau | 8 | 0 | 0 | 7.515 | 134.5825 | 2021-12-03 04:23:05 | Palau | ||||
2021-12-02 | Panama | 478275 | 7370 | 0 | 8.538 | -80.7821 | 2021-12-03 04:23:05 | Panama | ||||
2021-12-02 | Papua New Guinea | 35354 | 550 | 0 | -6.314993 | 143.95555 | 2021-12-03 04:23:05 | Papua New Guinea | ||||
2021-12-02 | Paraguay | 463199 | 16475 | 0 | -23.4425 | -58.4438 | 2021-12-03 04:23:05 | Paraguay | ||||
2021-12-02 | Philippines | 2833473 | 48752 | 0 | 12.879721 | 121.77401699999999 | 2021-12-03 04:23:05 | Philippines | ||||
2021-12-02 | Poland | 3596491 | 84656 | 0 | 51.9194 | 19.1451 | 2021-12-03 04:23:05 | Poland | ||||
2021-12-02 | Portugal | 1154817 | 18471 | 0 | 39.3999 | -8.2245 | 2021-12-03 04:23:05 | Portugal | ||||
2021-12-02 | Qatar | 243758 | 611 | 0 | 25.3548 | 51.1839 | 2021-12-03 04:23:05 | Qatar | ||||
2021-12-02 | Romania | 1781957 | 56684 | 0 | 45.9432 | 24.9668 | 2021-12-03 04:23:05 | Romania | ||||
2021-12-02 | Rwanda | 100381 | 1343 | 0 | -1.9403 | 29.8739 | 2021-12-03 04:23:05 | Rwanda | ||||
2021-12-02 | Saint Kitts and Nevis | 2787 | 28 | 0 | 17.357822 | -62.782998 | 2021-12-03 04:23:05 | Saint Kitts and Nevis | ||||
2021-12-02 | Saint Lucia | 13017 | 280 | 0 | 13.9094 | -60.9789 | 2021-12-03 04:23:05 | Saint Lucia | ||||
2021-12-02 | Saint Vincent and the Grenadines | 5579 | 74 | 0 | 12.9843 | -61.2872 | 2021-12-03 04:23:05 | Saint Vincent and the Grenadines | ||||
2021-12-02 | Samoa | 3 | 0 | 0 | -13.759 | -172.1046 | 2021-12-03 04:23:05 | Samoa | ||||
2021-12-02 | San Marino | 6118 | 93 | 0 | 43.9424 | 12.4578 | 2021-12-03 04:23:05 | San Marino | ||||
2021-12-02 | Sao Tome and Principe | 3732 | 56 | 0 | 0.1864 | 6.6131 | 2021-12-03 04:23:05 | Sao Tome and Principe | ||||
2021-12-02 | Saudi Arabia | 549810 | 8839 | 0 | 23.885942 | 45.079162 | 2021-12-03 04:23:05 | Saudi Arabia | ||||
2021-12-02 | Senegal | 73996 | 1886 | 0 | 14.4974 | -14.4524 | 2021-12-03 04:23:05 | Senegal | ||||
2021-12-02 | Serbia | 1259005 | 11792 | 0 | 44.0165 | 21.0059 | 2021-12-03 04:23:05 | Serbia | ||||
2021-12-02 | Seychelles | 23537 | 127 | 0 | -4.6796 | 55.492 | 2021-12-03 04:23:05 | Seychelles | ||||
2021-12-02 | Sierra Leone | 6402 | 121 | 0 | 8.460555000000001 | -11.779889 | 2021-12-03 04:23:05 | Sierra Leone | ||||
2021-12-02 | Singapore | 267150 | 735 | 0 | 1.2833 | 103.8333 | 2021-12-03 04:23:05 | Singapore | ||||
2021-12-02 | Slovakia | 1192439 | 14606 | 0 | 48.669 | 19.699 | 2021-12-03 04:23:05 | Slovakia | ||||
2021-12-02 | Slovenia | 425288 | 5255 | 0 | 46.1512 | 14.9955 | 2021-12-03 04:23:05 | Slovenia | ||||
2021-12-02 | Solomon Islands | 20 | 0 | 0 | -9.6457 | 160.1562 | 2021-12-03 04:23:05 | Solomon Islands | ||||
2021-12-02 | Somalia | 23016 | 1327 | 0 | 5.152149 | 46.199616 | 2021-12-03 04:23:05 | Somalia | ||||
2021-12-02 | South Africa | 2988148 | 89915 | 0 | -30.5595 | 22.9375 | 2021-12-03 04:23:05 | South Africa | ||||
2021-12-02 | South Sudan | 12777 | 133 | 0 | 6.8770000000000024 | 31.307 | 2021-12-03 04:23:05 | South Sudan | ||||
2021-12-02 | Sri Lanka | 565471 | 14399 | 0 | 7.873054 | 80.77179699999998 | 2021-12-03 04:23:05 | Sri Lanka | ||||
2021-12-02 | Sudan | 43489 | 3164 | 0 | 12.8628 | 30.2176 | 2021-12-03 04:23:05 | Sudan | ||||
2021-12-02 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-12-03 04:23:05 | Summer Olympics 2020 | ||||
2021-12-02 | Suriname | 50929 | 1169 | 0 | 3.9193 | -56.0278 | 2021-12-03 04:23:05 | Suriname | ||||
2021-12-02 | Switzerland | 1034675 | 11566 | 0 | 46.8182 | 8.2275 | 2021-12-03 04:23:05 | Switzerland | ||||
2021-12-02 | Syria | 48357 | 2760 | 0 | 34.802075 | 38.99681500000001 | 2021-12-03 04:23:05 | Syria | ||||
2021-12-02 | Taiwan* | 16626 | 848 | 0 | 23.7 | 121.0 | 2021-12-03 04:23:05 | Taiwan* | ||||
2021-12-02 | Tajikistan | 17493 | 125 | 0 | 38.861 | 71.2761 | 2021-12-03 04:23:05 | Tajikistan | ||||
2021-12-02 | Tanzania | 26270 | 730 | 0 | -6.369028 | 34.888822 | 2021-12-03 04:23:05 | Tanzania | ||||
2021-12-02 | Thailand | 2125729 | 20847 | 0 | 15.870032 | 100.992541 | 2021-12-03 04:23:05 | Thailand | ||||
2021-12-02 | Timor-Leste | 19825 | 122 | 0 | -8.874217 | 125.727539 | 2021-12-03 04:23:05 | Timor-Leste | ||||
2021-12-02 | Togo | 26282 | 243 | 0 | 8.6195 | 0.8248 | 2021-12-03 04:23:05 | Togo | ||||
2021-12-02 | Tonga | 1 | 0 | 0 | -21.179000000000002 | -175.1982 | 2021-12-03 04:23:05 | Tonga | ||||
2021-12-02 | Trinidad and Tobago | 72775 | 2198 | 0 | 10.6918 | -61.2225 | 2021-12-03 04:23:05 | Trinidad and Tobago | ||||
2021-12-02 | Tunisia | 717908 | 25381 | 0 | 33.886917 | 9.537499 | 2021-12-03 04:23:05 | Tunisia | ||||
2021-12-02 | Turkey | 8839891 | 77230 | 0 | 38.9637 | 35.2433 | 2021-12-03 04:23:05 | Turkey | ||||
2021-12-02 | Uganda | 127618 | 3252 | 0 | 1.373333 | 32.290275 | 2021-12-03 04:23:05 | Uganda | ||||
2021-12-02 | United Arab Emirates | 742109 | 2148 | 0 | 23.424076 | 53.847818000000004 | 2021-12-03 04:23:05 | United Arab Emirates | ||||
2021-12-02 | Uruguay | 400275 | 6132 | 0 | -32.5228 | -55.7658 | 2021-12-03 04:23:05 | Uruguay | ||||
2021-12-02 | Uzbekistan | 193633 | 1409 | 0 | 41.377491 | 64.585262 | 2021-12-03 04:23:05 | Uzbekistan | ||||
2021-12-02 | Vanuatu | 6 | 1 | 0 | -15.3767 | 166.9592 | 2021-12-03 04:23:05 | Vanuatu | ||||
2021-12-02 | Venezuela | 433208 | 5170 | 0 | 6.4238 | -66.5897 | 2021-12-03 04:23:05 | Venezuela | ||||
2021-12-02 | Vietnam | 1266288 | 25658 | 0 | 14.058323999999999 | 108.277199 | 2021-12-03 04:23:05 | Vietnam | ||||
2021-12-02 | West Bank and Gaza | 461157 | 4806 | 0 | 31.9522 | 35.2332 | 2021-12-03 04:23:05 | West Bank and Gaza | ||||
2021-12-02 | Yemen | 10006 | 1950 | 0 | 15.552726999999999 | 48.516388 | 2021-12-03 04:23:05 | Yemen | ||||
2021-12-02 | Zambia | 210220 | 3667 | 0 | -13.133897 | 27.849332 | 2021-12-03 04:23:05 | Zambia | ||||
2021-12-02 | Zimbabwe | 136379 | 4707 | 0 | -19.015438 | 29.154857 | 2021-12-03 04:23:05 | Zimbabwe | ||||
2021-12-02 | Winter Olympics 2022 | 0 | 0 | 0 | 0 | 39.9042 | 116.4074 | 2021-12-03 04:23:05 | Winter Olympics 2022 | |||
2021-12-02 | Antarctica | 0 | 0 | 0 | 0 | -71.9499 | 23.347 | 2021-12-03 04:23:05 | Antarctica | |||
2021-12-02 | Korea, North | 0 | 0 | 0 | 0 | 40.3399 | 127.5101 | 2021-12-03 04:23:05 | Korea, North | |||
2021-12-02 | Nauru | 0 | 0 | 0 | 0 | -0.5228 | 166.9315 | 2021-12-03 04:23:05 | Nauru | |||
2021-12-02 | Tuvalu | 0 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2021-12-03 04:23:05 | Tuvalu | |||
2021-10-28 | Afghanistan | 156166 | 7268 | 0 | 33.93911 | 67.709953 | 2021-10-29 04:22:03 | Afghanistan | ||||
2021-10-28 | Albania | 183873 | 2902 | 0 | 41.1533 | 20.1683 | 2021-10-29 04:22:03 | Albania | ||||
2021-10-28 | Algeria | 206160 | 5907 | 0 | 28.0339 | 1.6596 | 2021-10-29 04:22:03 | Algeria | ||||
2021-10-28 | Andorra | 15505 | 130 | 0 | 42.5063 | 1.5218 | 2021-10-29 04:22:03 | Andorra | ||||
2021-10-28 | Angola | 64226 | 1705 | 0 | -11.2027 | 17.8739 | 2021-10-29 04:22:03 | Angola | ||||
2021-10-28 | Antigua and Barbuda | 4040 | 102 | 0 | 17.0608 | -61.7964 | 2021-10-29 04:22:03 | Antigua and Barbuda | ||||
2021-10-28 | Argentina | 5286074 | 115916 | 0 | -38.4161 | -63.6167 | 2021-10-29 04:22:03 | Argentina | ||||
2021-10-28 | Armenia | 302450 | 6189 | 0 | 40.0691 | 45.0382 | 2021-10-29 04:22:03 | Armenia | ||||
2021-10-28 | Austria | 806032 | 13886 | 0 | 47.5162 | 14.5501 | 2021-10-29 04:22:03 | Austria | ||||
2021-10-28 | Azerbaijan | 524788 | 6995 | 0 | 40.1431 | 47.5769 | 2021-10-29 04:22:03 | Azerbaijan | ||||
2021-10-28 | Bahamas | 22351 | 643 | 0 | 25.025885 | -78.035889 | 2021-10-29 04:22:03 | Bahamas | ||||
2021-10-28 | Bahrain | 276718 | 1393 | 0 | 26.0275 | 50.55 | 2021-10-29 04:22:03 | Bahrain | ||||
2021-10-28 | Bangladesh | 1568857 | 27847 | 0 | 23.685 | 90.3563 | 2021-10-29 04:22:03 | Bangladesh | ||||
2021-10-28 | Barbados | 16782 | 151 | 0 | 13.1939 | -59.5432 | 2021-10-29 04:22:03 | Barbados | ||||
2021-10-28 | Belarus | 594203 | 4580 | 0 | 53.7098 | 27.9534 | 2021-10-29 04:22:03 | Belarus | ||||
2021-10-28 | Belize | 26625 | 491 | 0 | 17.1899 | -88.4976 | 2021-10-29 04:22:03 | Belize | ||||
2021-10-28 | Benin | 24749 | 161 | 0 | 9.3077 | 2.3158 | 2021-10-29 04:22:03 | Benin | ||||
2021-10-28 | Bhutan | 2621 | 3 | 0 | 27.5142 | 90.4336 | 2021-10-29 04:22:03 | Bhutan | ||||
2021-10-28 | Bolivia | 511854 | 18911 | 0 | -16.2902 | -63.5887 | 2021-10-29 04:22:03 | Bolivia | ||||
2021-10-28 | Bosnia and Herzegovina | 252083 | 11477 | 0 | 43.9159 | 17.6791 | 2021-10-29 04:22:03 | Bosnia and Herzegovina | ||||
2021-10-28 | Botswana | 186594 | 2406 | 0 | -22.3285 | 24.6849 | 2021-10-29 04:22:03 | Botswana |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;