johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,015 rows where "day" is on date 2021-09-19 sorted by province_or_state
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region, day
Link | rowid | day | country_or_region | province_or_state ▼ | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1814462 | 1814462 | 2021-09-19 | Afghanistan | 154487 | 7186 | 0 | 33.93911 | 67.709953 | 2021-09-20 04:21:22 | Afghanistan | ||||
1814463 | 1814463 | 2021-09-19 | Albania | 162953 | 2580 | 0 | 41.1533 | 20.1683 | 2021-09-20 04:21:22 | Albania | ||||
1814464 | 1814464 | 2021-09-19 | Algeria | 201600 | 5694 | 0 | 28.0339 | 1.6596 | 2021-09-20 04:21:22 | Algeria | ||||
1814465 | 1814465 | 2021-09-19 | Andorra | 15124 | 130 | 0 | 42.5063 | 1.5218 | 2021-09-20 04:21:22 | Andorra | ||||
1814466 | 1814466 | 2021-09-19 | Angola | 52307 | 1388 | 0 | -11.2027 | 17.8739 | 2021-09-20 04:21:22 | Angola | ||||
1814467 | 1814467 | 2021-09-19 | Antigua and Barbuda | 2603 | 55 | 0 | 17.0608 | -61.7964 | 2021-09-20 04:21:22 | Antigua and Barbuda | ||||
1814468 | 1814468 | 2021-09-19 | Argentina | 5239232 | 114428 | 0 | -38.4161 | -63.6167 | 2021-09-20 04:21:22 | Argentina | ||||
1814469 | 1814469 | 2021-09-19 | Armenia | 253600 | 5131 | 0 | 40.0691 | 45.0382 | 2021-09-20 04:21:22 | Armenia | ||||
1814478 | 1814478 | 2021-09-19 | Austria | 718988 | 13379 | 0 | 47.5162 | 14.5501 | 2021-09-20 04:21:22 | Austria | ||||
1814479 | 1814479 | 2021-09-19 | Azerbaijan | 467173 | 6227 | 0 | 40.1431 | 47.5769 | 2021-09-20 04:21:22 | Azerbaijan | ||||
1814480 | 1814480 | 2021-09-19 | Bahamas | 20030 | 504 | 0 | 25.025885 | -78.035889 | 2021-09-20 04:21:22 | Bahamas | ||||
1814481 | 1814481 | 2021-09-19 | Bahrain | 274264 | 1388 | 0 | 26.0275 | 50.55 | 2021-09-20 04:21:22 | Bahrain | ||||
1814482 | 1814482 | 2021-09-19 | Bangladesh | 1542683 | 27225 | 0 | 23.685 | 90.3563 | 2021-09-20 04:21:22 | Bangladesh | ||||
1814483 | 1814483 | 2021-09-19 | Barbados | 6527 | 58 | 0 | 13.1939 | -59.5432 | 2021-09-20 04:21:22 | Barbados | ||||
1814484 | 1814484 | 2021-09-19 | Belarus | 516428 | 4004 | 0 | 53.7098 | 27.9534 | 2021-09-20 04:21:22 | Belarus | ||||
1814497 | 1814497 | 2021-09-19 | Belize | 18532 | 389 | 0 | 17.1899 | -88.4976 | 2021-09-20 04:21:22 | Belize | ||||
1814498 | 1814498 | 2021-09-19 | Benin | 21450 | 146 | 0 | 9.3077 | 2.3158 | 2021-09-20 04:21:22 | Benin | ||||
1814499 | 1814499 | 2021-09-19 | Bhutan | 2597 | 3 | 0 | 27.5142 | 90.4336 | 2021-09-20 04:21:22 | Bhutan | ||||
1814500 | 1814500 | 2021-09-19 | Bolivia | 497100 | 18659 | 0 | -16.2902 | -63.5887 | 2021-09-20 04:21:22 | Bolivia | ||||
1814501 | 1814501 | 2021-09-19 | Bosnia and Herzegovina | 225857 | 10203 | 0 | 43.9159 | 17.6791 | 2021-09-20 04:21:22 | Bosnia and Herzegovina | ||||
1814502 | 1814502 | 2021-09-19 | Botswana | 172252 | 2343 | 0 | -22.3285 | 24.6849 | 2021-09-20 04:21:22 | Botswana | ||||
1814530 | 1814530 | 2021-09-19 | Brunei | 5047 | 26 | 0 | 4.5353 | 114.7277 | 2021-09-20 04:21:22 | Brunei | ||||
1814531 | 1814531 | 2021-09-19 | Bulgaria | 482186 | 20028 | 0 | 42.7339 | 25.4858 | 2021-09-20 04:21:22 | Bulgaria | ||||
1814532 | 1814532 | 2021-09-19 | Burkina Faso | 14041 | 172 | 0 | 12.2383 | -1.5616 | 2021-09-20 04:21:22 | Burkina Faso | ||||
1814533 | 1814533 | 2021-09-19 | Burma | 446573 | 17073 | 0 | 21.9162 | 95.956 | 2021-09-20 04:21:22 | Burma | ||||
1814534 | 1814534 | 2021-09-19 | Burundi | 14189 | 38 | 0 | -3.3731 | 29.9189 | 2021-09-20 04:21:22 | Burundi | ||||
1814535 | 1814535 | 2021-09-19 | Cabo Verde | 37108 | 330 | 0 | 16.5388 | -23.0418 | 2021-09-20 04:21:22 | Cabo Verde | ||||
1814536 | 1814536 | 2021-09-19 | Cambodia | 104094 | 2109 | 0 | 11.55 | 104.9167 | 2021-09-20 04:21:22 | Cambodia | ||||
1814537 | 1814537 | 2021-09-19 | Cameroon | 85414 | 1368 | 0 | 3.8480000000000003 | 11.5021 | 2021-09-20 04:21:22 | Cameroon | ||||
1814554 | 1814554 | 2021-09-19 | Central African Republic | 11309 | 100 | 0 | 6.6111 | 20.9394 | 2021-09-20 04:21:22 | Central African Republic | ||||
1814555 | 1814555 | 2021-09-19 | Chad | 5029 | 174 | 0 | 15.4542 | 18.7322 | 2021-09-20 04:21:22 | Chad | ||||
1814641 | 1814641 | 2021-09-19 | Comoros | 4106 | 147 | 0 | -11.6455 | 43.3333 | 2021-09-20 04:21:22 | Comoros | ||||
1814642 | 1814642 | 2021-09-19 | Congo (Brazzaville) | 13701 | 183 | 0 | -0.228 | 15.8277 | 2021-09-20 04:21:22 | Congo (Brazzaville) | ||||
1814643 | 1814643 | 2021-09-19 | Congo (Kinshasa) | 56387 | 1068 | 0 | -4.0383 | 21.7587 | 2021-09-20 04:21:22 | Congo (Kinshasa) | ||||
1814644 | 1814644 | 2021-09-19 | Costa Rica | 505163 | 5949 | 0 | 9.7489 | -83.7534 | 2021-09-20 04:21:22 | Costa Rica | ||||
1814645 | 1814645 | 2021-09-19 | Cote d'Ivoire | 59020 | 566 | 0 | 7.54 | -5.5471 | 2021-09-20 04:21:22 | Cote d'Ivoire | ||||
1814646 | 1814646 | 2021-09-19 | Croatia | 391984 | 8500 | 0 | 45.1 | 15.2 | 2021-09-20 04:21:22 | Croatia | ||||
1814647 | 1814647 | 2021-09-19 | Cuba | 801367 | 6796 | 0 | 21.521757 | -77.78116700000002 | 2021-09-20 04:21:22 | Cuba | ||||
1814648 | 1814648 | 2021-09-19 | Cyprus | 118863 | 547 | 0 | 35.1264 | 33.4299 | 2021-09-20 04:21:22 | Cyprus | ||||
1814649 | 1814649 | 2021-09-19 | Czechia | 1686182 | 30430 | 0 | 49.8175 | 15.472999999999999 | 2021-09-20 04:21:22 | Czechia | ||||
1814652 | 1814652 | 2021-09-19 | Denmark | 354645 | 2628 | 0 | 56.2639 | 9.5018 | 2021-09-20 04:21:22 | Denmark | ||||
1814653 | 1814653 | 2021-09-19 | Diamond Princess | 712 | 13 | 0 | 2021-09-20 04:21:22 | Diamond Princess | ||||||
1814654 | 1814654 | 2021-09-19 | Djibouti | 12040 | 159 | 0 | 11.8251 | 42.5903 | 2021-09-20 04:21:22 | Djibouti | ||||
1814655 | 1814655 | 2021-09-19 | Dominica | 2758 | 8 | 0 | 15.415 | -61.371 | 2021-09-20 04:21:22 | Dominica | ||||
1814656 | 1814656 | 2021-09-19 | Dominican Republic | 355150 | 4028 | 0 | 18.7357 | -70.1627 | 2021-09-20 04:21:22 | Dominican Republic | ||||
1814657 | 1814657 | 2021-09-19 | Ecuador | 507003 | 32661 | 0 | -1.8312 | -78.1834 | 2021-09-20 04:21:22 | Ecuador | ||||
1814658 | 1814658 | 2021-09-19 | Egypt | 296929 | 16970 | 0 | 26.820553000000004 | 30.802497999999996 | 2021-09-20 04:21:22 | Egypt | ||||
1814659 | 1814659 | 2021-09-19 | El Salvador | 99701 | 3102 | 0 | 13.7942 | -88.8965 | 2021-09-20 04:21:22 | El Salvador | ||||
1814660 | 1814660 | 2021-09-19 | Equatorial Guinea | 11063 | 137 | 0 | 1.6508 | 10.2679 | 2021-09-20 04:21:22 | Equatorial Guinea | ||||
1814661 | 1814661 | 2021-09-19 | Eritrea | 6671 | 40 | 0 | 15.1794 | 39.7823 | 2021-09-20 04:21:22 | Eritrea | ||||
1814662 | 1814662 | 2021-09-19 | Estonia | 149776 | 1326 | 0 | 58.5953 | 25.0136 | 2021-09-20 04:21:22 | Estonia | ||||
1814663 | 1814663 | 2021-09-19 | Eswatini | 45380 | 1195 | 0 | -26.5225 | 31.4659 | 2021-09-20 04:21:22 | Eswatini | ||||
1814664 | 1814664 | 2021-09-19 | Ethiopia | 332961 | 5130 | 0 | 9.145 | 40.4897 | 2021-09-20 04:21:22 | Ethiopia | ||||
1814665 | 1814665 | 2021-09-19 | Fiji | 49959 | 566 | 0 | -17.7134 | 178.065 | 2021-09-20 04:21:22 | Fiji | ||||
1814666 | 1814666 | 2021-09-19 | Finland | 136809 | 1087 | 0 | 61.92411 | 25.748151 | 2021-09-20 04:21:22 | Finland | ||||
1814678 | 1814678 | 2021-09-19 | France | 6792074 | 113993 | 0 | 46.2276 | 2.2137 | 2021-09-20 04:21:22 | France | ||||
1814679 | 1814679 | 2021-09-19 | Gabon | 27643 | 175 | 0 | -0.8037 | 11.6094 | 2021-09-20 04:21:22 | Gabon | ||||
1814680 | 1814680 | 2021-09-19 | Gambia | 9888 | 332 | 0 | 13.4432 | -15.3101 | 2021-09-20 04:21:22 | Gambia | ||||
1814681 | 1814681 | 2021-09-19 | Georgia | 595264 | 8541 | 0 | 42.3154 | 43.3569 | 2021-09-20 04:21:22 | Georgia | ||||
1814699 | 1814699 | 2021-09-19 | Ghana | 125261 | 1121 | 0 | 7.9465 | -1.0232 | 2021-09-20 04:21:22 | Ghana | ||||
1814700 | 1814700 | 2021-09-19 | Greece | 630784 | 14466 | 0 | 39.0742 | 21.8243 | 2021-09-20 04:21:22 | Greece | ||||
1814701 | 1814701 | 2021-09-19 | Grenada | 3841 | 50 | 0 | 12.1165 | -61.678999999999995 | 2021-09-20 04:21:22 | Grenada | ||||
1814702 | 1814702 | 2021-09-19 | Guatemala | 529422 | 13040 | 0 | 15.7835 | -90.2308 | 2021-09-20 04:21:22 | Guatemala | ||||
1814703 | 1814703 | 2021-09-19 | Guinea | 30136 | 370 | 0 | 9.9456 | -9.6966 | 2021-09-20 04:21:22 | Guinea | ||||
1814704 | 1814704 | 2021-09-19 | Guinea-Bissau | 6080 | 130 | 0 | 11.8037 | -15.1804 | 2021-09-20 04:21:22 | Guinea-Bissau | ||||
1814705 | 1814705 | 2021-09-19 | Guyana | 29553 | 725 | 0 | 4.860416000000002 | -58.93018000000001 | 2021-09-20 04:21:22 | Guyana | ||||
1814706 | 1814706 | 2021-09-19 | Haiti | 21508 | 607 | 0 | 18.9712 | -72.2852 | 2021-09-20 04:21:22 | Haiti | ||||
1814707 | 1814707 | 2021-09-19 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-09-20 04:21:22 | Holy See | ||||
1814708 | 1814708 | 2021-09-19 | Honduras | 357654 | 9491 | 0 | 15.2 | -86.2419 | 2021-09-20 04:21:22 | Honduras | ||||
1814709 | 1814709 | 2021-09-19 | Hungary | 817159 | 30123 | 0 | 47.1625 | 19.5033 | 2021-09-20 04:21:22 | Hungary | ||||
1814710 | 1814710 | 2021-09-19 | Iceland | 11404 | 33 | 0 | 64.9631 | -19.0208 | 2021-09-20 04:21:22 | Iceland | ||||
1814748 | 1814748 | 2021-09-19 | Indonesia | 4190763 | 140468 | 0 | -0.7893 | 113.9213 | 2021-09-20 04:21:22 | Indonesia | ||||
1814749 | 1814749 | 2021-09-19 | Iran | 5424835 | 117182 | 0 | 32.427908 | 53.68804599999999 | 2021-09-20 04:21:22 | Iran | ||||
1814750 | 1814750 | 2021-09-19 | Iraq | 1975220 | 21822 | 0 | 33.223191 | 43.679291 | 2021-09-20 04:21:22 | Iraq | ||||
1814751 | 1814751 | 2021-09-19 | Ireland | 375367 | 5179 | 0 | 53.1424 | -7.6921 | 2021-09-20 04:21:22 | Ireland | ||||
1814752 | 1814752 | 2021-09-19 | Israel | 1228129 | 7541 | 0 | 31.046051000000002 | 34.851612 | 2021-09-20 04:21:22 | Israel | ||||
1814774 | 1814774 | 2021-09-19 | Jamaica | 79673 | 1791 | 0 | 18.1096 | -77.2975 | 2021-09-20 04:21:22 | Jamaica | ||||
1814824 | 1814824 | 2021-09-19 | Jordan | 813601 | 10616 | 0 | 31.24 | 36.51 | 2021-09-20 04:21:22 | Jordan | ||||
1814825 | 1814825 | 2021-09-19 | Kazakhstan | 936954 | 15031 | 0 | 48.0196 | 66.9237 | 2021-09-20 04:21:22 | Kazakhstan | ||||
1814826 | 1814826 | 2021-09-19 | Kenya | 246530 | 4989 | 0 | -0.0236 | 37.9062 | 2021-09-20 04:21:22 | Kenya | ||||
1814827 | 1814827 | 2021-09-19 | Kiribati | 2 | 0 | 0 | -3.3704 | -168.734 | 2021-09-20 04:21:22 | Kiribati | ||||
1814828 | 1814828 | 2021-09-19 | Korea, South | 287536 | 2409 | 0 | 35.90775700000001 | 127.766922 | 2021-09-20 04:21:22 | Korea, South | ||||
1814829 | 1814829 | 2021-09-19 | Kosovo | 159107 | 2899 | 0 | 42.602636 | 20.902977 | 2021-09-20 04:21:22 | Kosovo | ||||
1814830 | 1814830 | 2021-09-19 | Kuwait | 411180 | 2439 | 0 | 29.311659999999996 | 47.481766 | 2021-09-20 04:21:22 | Kuwait | ||||
1814831 | 1814831 | 2021-09-19 | Kyrgyzstan | 177722 | 2588 | 0 | 41.20438 | 74.766098 | 2021-09-20 04:21:22 | Kyrgyzstan | ||||
1814832 | 1814832 | 2021-09-19 | Laos | 19185 | 16 | 0 | 19.856270000000002 | 102.495496 | 2021-09-20 04:21:22 | Laos | ||||
1814833 | 1814833 | 2021-09-19 | Latvia | 150560 | 2640 | 0 | 56.8796 | 24.6032 | 2021-09-20 04:21:22 | Latvia | ||||
1814834 | 1814834 | 2021-09-19 | Lebanon | 618278 | 8236 | 0 | 33.8547 | 35.8623 | 2021-09-20 04:21:22 | Lebanon | ||||
1814835 | 1814835 | 2021-09-19 | Lesotho | 14395 | 403 | 0 | -29.61 | 28.2336 | 2021-09-20 04:21:22 | Lesotho | ||||
1814836 | 1814836 | 2021-09-19 | Liberia | 5904 | 283 | 0 | 6.4280550000000005 | -9.429499 | 2021-09-20 04:21:22 | Liberia | ||||
1814837 | 1814837 | 2021-09-19 | Libya | 330945 | 4501 | 0 | 26.3351 | 17.228331 | 2021-09-20 04:21:22 | Libya | ||||
1814838 | 1814838 | 2021-09-19 | Liechtenstein | 3528 | 58 | 0 | 47.14 | 9.55 | 2021-09-20 04:21:22 | Liechtenstein | ||||
1814839 | 1814839 | 2021-09-19 | Lithuania | 317090 | 4794 | 0 | 55.1694 | 23.8813 | 2021-09-20 04:21:22 | Lithuania | ||||
1814840 | 1814840 | 2021-09-19 | Luxembourg | 77189 | 834 | 0 | 49.8153 | 6.1296 | 2021-09-20 04:21:22 | Luxembourg | ||||
1814841 | 1814841 | 2021-09-19 | MS Zaandam | 9 | 2 | 0 | 2021-09-20 04:21:22 | MS Zaandam | ||||||
1814842 | 1814842 | 2021-09-19 | Madagascar | 42898 | 958 | 0 | -18.766947000000002 | 46.869107 | 2021-09-20 04:21:22 | Madagascar | ||||
1814843 | 1814843 | 2021-09-19 | Malawi | 61363 | 2261 | 0 | -13.2543 | 34.3015 | 2021-09-20 04:21:22 | Malawi | ||||
1814844 | 1814844 | 2021-09-19 | Maldives | 83576 | 229 | 0 | 3.2028 | 73.2207 | 2021-09-20 04:21:22 | Maldives | ||||
1814845 | 1814845 | 2021-09-19 | Mali | 15068 | 545 | 0 | 17.570692 | -3.996166000000001 | 2021-09-20 04:21:22 | Mali | ||||
1814846 | 1814846 | 2021-09-19 | Malta | 36972 | 453 | 0 | 35.9375 | 14.3754 | 2021-09-20 04:21:22 | Malta |
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]);