covid

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Custom SQL query returning 101 rows (hide)

rowiddaycountry_or_regionprovince_or_stateadmin2fipsconfirmeddeathsrecoveredactivelatitudelongitudelast_updatecombined_key
764776 2020-10-24 Zimbabwe       8269 236 7785 248 -19.015438 29.154857 2020-10-25 04:24:36 Zimbabwe
764775 2020-10-24 Zambia       16117 348 15179 590 -13.133897 27.849332 2020-10-25 04:24:36 Zambia
764774 2020-10-24 Yemen       2060 599 1360 101 15.552727 48.516388 2020-10-25 04:24:36 Yemen
764773 2020-10-24 Western Sahara       10 1 8 1 24.2155 -12.8858 2020-10-25 04:24:36 Western Sahara
764772 2020-10-24 West Bank and Gaza       49989 443 43232 6314 31.9522 35.2332 2020-10-25 04:24:36 West Bank and Gaza
764771 2020-10-24 Vietnam       1160 35 1051 74 14.058324 108.277199 2020-10-25 04:24:36 Vietnam
764770 2020-10-24 Venezuela       89142 770 83443 4929 6.4238 -66.5897 2020-10-25 04:24:36 Venezuela
764769 2020-10-24 Uzbekistan       64923 544 62033 2346 41.377491 64.585262 2020-10-25 04:24:36 Uzbekistan
764768 2020-10-24 Uruguay       2807 53 2301 453 -32.5228 -55.7658 2020-10-25 04:24:36 Uruguay
764767 2020-10-24 United Kingdom Wales     41577 1772 0 39805 52.1307 -3.7837 2020-10-25 04:24:36 Wales, United Kingdom
764766 2020-10-24 United Kingdom Unknown     0 0 0 0     2020-10-25 04:24:36 Unknown, United Kingdom
764765 2020-10-24 United Kingdom Turks and Caicos Islands     701 6 689 6 21.694000000000006 -71.7979 2020-10-25 04:24:36 Turks and Caicos Islands, United Kingdom
764764 2020-10-24 United Kingdom Scotland     55449 2699 0 52750 56.4907 -4.2026 2020-10-25 04:24:36 Scotland, United Kingdom
764763 2020-10-24 United Kingdom Northern Ireland     33209 645 0 32564 54.7877 -6.4923 2020-10-25 04:24:36 Northern Ireland, United Kingdom
764762 2020-10-24 United Kingdom Montserrat     13 1 12 0 16.742498 -62.187366 2020-10-25 04:24:36 Montserrat, United Kingdom
764761 2020-10-24 United Kingdom Isle of Man     348 24 321 3 54.2361 -4.5481 2020-10-25 04:24:36 Isle of Man, United Kingdom
764760 2020-10-24 United Kingdom Gibraltar     660 0 507 153 36.1408 -5.3536 2020-10-25 04:24:36 Gibraltar, United Kingdom
764759 2020-10-24 United Kingdom Falkland Islands (Malvinas)     13 0 13 0 -51.7963 -59.5236 2020-10-25 04:24:36 Falkland Islands (Malvinas), United Kingdom
764758 2020-10-24 United Kingdom England     723775 39629 0 684146 52.3555 -1.1743 2020-10-25 04:24:36 England, United Kingdom
764757 2020-10-24 United Kingdom Channel Islands     795 48 671 76 49.3723 -2.3644 2020-10-25 04:24:36 Channel Islands, United Kingdom
764756 2020-10-24 United Kingdom Cayman Islands     239 1 215 23 19.3133 -81.2546 2020-10-25 04:24:36 Cayman Islands, United Kingdom
764755 2020-10-24 United Kingdom British Virgin Islands     71 1 70 0 18.4207 -64.64 2020-10-25 04:24:36 British Virgin Islands, United Kingdom
764754 2020-10-24 United Kingdom Bermuda     190 9 175 6 32.3078 -64.7505 2020-10-25 04:24:36 Bermuda, United Kingdom
764753 2020-10-24 United Kingdom Anguilla     3 0 3 0 18.2206 -63.0686 2020-10-25 04:24:36 Anguilla, United Kingdom
764752 2020-10-24 United Arab Emirates       123764 475 116894 6395 23.424076 53.847818 2020-10-25 04:24:36 United Arab Emirates
764751 2020-10-24 Ukraine Zhytomyr Oblast     11748 193 6245 5310 50.2547 28.6587 2020-10-25 04:24:36 Zhytomyr Oblast, Ukraine
764750 2020-10-24 Ukraine Zaporizhia Oblast     7792 97 1867 5828 47.8388 35.1396 2020-10-25 04:24:36 Zaporizhia Oblast, Ukraine
764749 2020-10-24 Ukraine Zakarpattia Oblast     12801 348 5791 6662 48.6208 22.2879 2020-10-25 04:24:36 Zakarpattia Oblast, Ukraine
764748 2020-10-24 Ukraine Volyn Oblast     12009 238 6914 4857 50.7472 25.3254 2020-10-25 04:24:36 Volyn Oblast, Ukraine
764747 2020-10-24 Ukraine Vinnytsia Oblast     9081 163 5601 3317 49.2331 28.4682 2020-10-25 04:24:36 Vinnytsia Oblast, Ukraine
764746 2020-10-24 Ukraine Ternopil Oblast     18849 238 13830 4781 49.5535 25.5948 2020-10-25 04:24:36 Ternopil Oblast, Ukraine
764745 2020-10-24 Ukraine Sumy Oblast     10112 146 3142 6824 50.9077 34.7981 2020-10-25 04:24:36 Sumy Oblast, Ukraine
764744 2020-10-24 Ukraine Sevastopol*     1913 56 1262 595 44.6054 33.522 2020-10-25 04:24:36 Sevastopol*, Ukraine
764743 2020-10-24 Ukraine Rivne Oblast     17257 211 13230 3816 50.6199 26.2516 2020-10-25 04:24:36 Rivne Oblast, Ukraine
764742 2020-10-24 Ukraine Poltava Oblast     7694 149 2750 4795 49.5883 34.5514 2020-10-25 04:24:36 Poltava Oblast, Ukraine
764741 2020-10-24 Ukraine Odessa Oblast     21491 324 3271 17896 46.4846 30.7326 2020-10-25 04:24:36 Odessa Oblast, Ukraine
764740 2020-10-24 Ukraine Mykolaiv Oblast     6790 126 1640 5024 46.975 31.9946 2020-10-25 04:24:36 Mykolaiv Oblast, Ukraine
764739 2020-10-24 Ukraine Lviv Oblast     26868 767 10624 15477 49.8397 24.0297 2020-10-25 04:24:36 Lviv Oblast, Ukraine
764738 2020-10-24 Ukraine Luhansk Oblast     3083 58 1038 1987 48.574 39.3078 2020-10-25 04:24:36 Luhansk Oblast, Ukraine
764737 2020-10-24 Ukraine Kirovohrad Oblast     1955 77 1085 793 48.5079 32.2623 2020-10-25 04:24:36 Kirovohrad Oblast, Ukraine
764736 2020-10-24 Ukraine Kiev Oblast     14247 329 7563 6355 50.053 30.7667 2020-10-25 04:24:36 Kiev Oblast, Ukraine
764735 2020-10-24 Ukraine Kiev     33695 674 11686 21335 50.4501 30.5234 2020-10-25 04:24:36 Kiev, Ukraine
764734 2020-10-24 Ukraine Khmelnytskyi Oblast     12863 197 5674 6992 49.423 26.9871 2020-10-25 04:24:36 Khmelnytskyi Oblast, Ukraine
764733 2020-10-24 Ukraine Kherson Oblast     3061 63 1328 1670 46.6354 32.6169 2020-10-25 04:24:36 Kherson Oblast, Ukraine
764732 2020-10-24 Ukraine Kharkiv Oblast     32112 487 6194 25431 49.9935 36.2304 2020-10-25 04:24:36 Kharkiv Oblast, Ukraine
764731 2020-10-24 Ukraine Ivano-Frankivsk Oblast     17984 409 9136 8439 48.9226 24.7111 2020-10-25 04:24:36 Ivano-Frankivsk Oblast, Ukraine
764730 2020-10-24 Ukraine Donetsk Oblast     8410 87 1377 6946 48.0159 37.8028 2020-10-25 04:24:36 Donetsk Oblast, Ukraine
764729 2020-10-24 Ukraine Dnipropetrovsk Oblast     12685 308 5294 7083 48.4647 35.0462 2020-10-25 04:24:36 Dnipropetrovsk Oblast, Ukraine
764728 2020-10-24 Ukraine Crimea Republic*     7994 118 4401 3475 45.2835 34.2008 2020-10-25 04:24:36 Crimea Republic*, Ukraine
764727 2020-10-24 Ukraine Chernivtsi Oblast     19116 431 9862 8823 48.2917 25.9352 2020-10-25 04:24:36 Chernivtsi Oblast, Ukraine
764726 2020-10-24 Ukraine Chernihiv Oblast     7786 87 1423 6276 51.4982 31.2893 2020-10-25 04:24:36 Chernihiv Oblast, Ukraine
764725 2020-10-24 Ukraine Cherkasy Oblast     7921 82 3190 4649 49.4444 32.0598 2020-10-25 04:24:36 Cherkasy Oblast, Ukraine
764724 2020-10-24 Uganda       11297 99 7281 3917 1.373333 32.290275 2020-10-25 04:24:36 Uganda
764723 2020-10-24 US Wyoming Weston 56045 127 0 0 127 43.83961191 -104.5674881 2020-10-25 04:24:36 Weston, Wyoming, US
764722 2020-10-24 US Wyoming Washakie 56043 145 7 0 138 43.90451606 -107.68018700000002 2020-10-25 04:24:36 Washakie, Wyoming, US
764721 2020-10-24 US Wyoming Unassigned 90056 0 0 0 0 44.79048913 -110.6563997 2020-10-25 04:24:36 Unassigned, Wyoming, US
764720 2020-10-24 US Wyoming Uinta 56041 428 3 0 425 41.2878183 -110.54757820000002 2020-10-25 04:24:36 Uinta, Wyoming, US
764719 2020-10-24 US Wyoming Teton 56039 743 1 0 742 43.93522482 -110.5890801 2020-10-25 04:24:36 Teton, Wyoming, US
764718 2020-10-24 US Wyoming Sweetwater 56037 456 2 0 454 41.65943896 -108.8827882 2020-10-25 04:24:36 Sweetwater, Wyoming, US
764717 2020-10-24 US Wyoming Sublette 56035 158 1 0 157 42.76558279 -109.9130922 2020-10-25 04:24:36 Sublette, Wyoming, US
764716 2020-10-24 US Wyoming Sheridan 56033 659 4 0 655 44.79048913 -106.8862389 2020-10-25 04:24:36 Sheridan, Wyoming, US
764715 2020-10-24 US Wyoming Platte 56031 117 1 0 116 42.13299116 -104.966331 2020-10-25 04:24:36 Platte, Wyoming, US
764714 2020-10-24 US Wyoming Park 56029 547 3 0 544 44.52157546 -109.5852825 2020-10-25 04:24:36 Park, Wyoming, US
764713 2020-10-24 US Wyoming Niobrara 56027 7 0 0 7 43.05607708 -104.4758896 2020-10-25 04:24:36 Niobrara, Wyoming, US
764712 2020-10-24 US Wyoming Natrona 56025 1231 9 0 1222 42.96180148 -106.797885 2020-10-25 04:24:36 Natrona, Wyoming, US
764711 2020-10-24 US Wyoming Lincoln 56023 328 2 0 326 42.26376367 -110.6563997 2020-10-25 04:24:36 Lincoln, Wyoming, US
764710 2020-10-24 US Wyoming Laramie 56021 1407 4 0 1403 41.30702520000001 -104.6887497 2020-10-25 04:24:36 Laramie, Wyoming, US
764709 2020-10-24 US Wyoming Johnson 56019 88 2 0 86 44.04057166 -106.5845174 2020-10-25 04:24:36 Johnson, Wyoming, US
764708 2020-10-24 US Wyoming Hot Springs 56017 50 0 0 50 43.71930657 -108.4423174 2020-10-25 04:24:36 Hot Springs, Wyoming, US
764707 2020-10-24 US Wyoming Goshen 56015 152 3 0 149 42.08798185 -104.3534743 2020-10-25 04:24:36 Goshen, Wyoming, US
764706 2020-10-24 US Wyoming Fremont 56013 1212 15 0 1197 43.04183996 -108.6296893 2020-10-25 04:24:36 Fremont, Wyoming, US
764705 2020-10-24 US Wyoming Crook 56011 100 1 0 99 44.58855102 -104.5697705 2020-10-25 04:24:36 Crook, Wyoming, US
764704 2020-10-24 US Wyoming Converse 56009 286 0 0 286 42.97272268 -105.5081848 2020-10-25 04:24:36 Converse, Wyoming, US
764703 2020-10-24 US Wyoming Carbon 56007 304 2 0 302 41.69357844 -106.9326084 2020-10-25 04:24:36 Carbon, Wyoming, US
764702 2020-10-24 US Wyoming Campbell 56005 805 3 0 802 44.24886082 -105.5474404 2020-10-25 04:24:36 Campbell, Wyoming, US
764701 2020-10-24 US Wyoming Big Horn 56003 208 2 0 206 44.52405055 -107.9960365 2020-10-25 04:24:36 Big Horn, Wyoming, US
764700 2020-10-24 US Wyoming Albany 56001 1247 3 0 1244 41.65498705 -105.7235415 2020-10-25 04:24:36 Albany, Wyoming, US
764699 2020-10-24 US Wisconsin Wood 55141 1572 9 0 1563 44.45537896 -90.04158336 2020-10-25 04:24:36 Wood, Wisconsin, US
764698 2020-10-24 US Wisconsin Winnebago 55139 8281 55 0 8226 44.06886922 -88.64477096 2020-10-25 04:24:36 Winnebago, Wisconsin, US
764697 2020-10-24 US Wisconsin Waushara 55137 945 5 0 940 44.11324419 -89.24317107 2020-10-25 04:24:36 Waushara, Wisconsin, US
764696 2020-10-24 US Wisconsin Waupaca 55135 2261 39 0 2222 44.47068056 -88.96534501 2020-10-25 04:24:36 Waupaca, Wisconsin, US
764695 2020-10-24 US Wisconsin Waukesha 55133 11615 112 0 11503 43.01833055 -88.30431188 2020-10-25 04:24:36 Waukesha, Wisconsin, US
764694 2020-10-24 US Wisconsin Washington 55131 4198 43 0 4155 43.36863664 -88.22974712 2020-10-25 04:24:36 Washington, Wisconsin, US
764693 2020-10-24 US Wisconsin Washburn 55129 223 2 0 221 45.89838588 -91.79050449 2020-10-25 04:24:36 Washburn, Wisconsin, US
764692 2020-10-24 US Wisconsin Walworth 55127 3282 37 0 3245 42.66858202 -88.54163073 2020-10-25 04:24:36 Walworth, Wisconsin, US
764691 2020-10-24 US Wisconsin Vilas 55125 521 5 0 516 46.05467334 -89.51719204 2020-10-25 04:24:36 Vilas, Wisconsin, US
764690 2020-10-24 US Wisconsin Vernon 55123 463 2 0 461 43.59422667 -90.8324691 2020-10-25 04:24:36 Vernon, Wisconsin, US
764689 2020-10-24 US Wisconsin Unassigned 90055 0 0 0 0 46.52868768 0.0 2020-10-25 04:24:36 Unassigned, Wisconsin, US
764688 2020-10-24 US Wisconsin Trempealeau 55121 965 2 0 963 44.30360275 -91.35893614 2020-10-25 04:24:36 Trempealeau, Wisconsin, US
764687 2020-10-24 US Wisconsin Taylor 55119 449 7 0 442 45.21179252 -90.5004405 2020-10-25 04:24:36 Taylor, Wisconsin, US
764686 2020-10-24 US Wisconsin St. Croix 55109 1669 11 0 1658 45.03437474 -92.45000068 2020-10-25 04:24:36 St. Croix, Wisconsin, US
764685 2020-10-24 US Wisconsin Sheboygan 55117 4375 24 0 4351 43.72099677 -87.94579284 2020-10-25 04:24:36 Sheboygan, Wisconsin, US
764684 2020-10-24 US Wisconsin Shawano 55115 2287 18 0 2269 44.78902246 -88.76443896 2020-10-25 04:24:36 Shawano, Wisconsin, US
764683 2020-10-24 US Wisconsin Sawyer 55113 362 2 0 360 45.87931905 -91.14504927 2020-10-25 04:24:36 Sawyer, Wisconsin, US
764682 2020-10-24 US Wisconsin Sauk 55111 1611 7 0 1604 43.42574087 -89.94966132 2020-10-25 04:24:36 Sauk, Wisconsin, US
764681 2020-10-24 US Wisconsin Rusk 55107 190 1 0 189 45.47498854 -91.1333012 2020-10-25 04:24:36 Rusk, Wisconsin, US
764680 2020-10-24 US Wisconsin Rock 55105 4607 42 0 4565 42.67151616 -89.07147900000002 2020-10-25 04:24:36 Rock, Wisconsin, US
764679 2020-10-24 US Wisconsin Richland 55103 433 8 0 425 43.3762778 -90.43012729 2020-10-25 04:24:36 Richland, Wisconsin, US
764678 2020-10-24 US Wisconsin Racine 55101 6948 107 0 6841 42.74753117 -88.05941254 2020-10-25 04:24:36 Racine, Wisconsin, US
764677 2020-10-24 US Wisconsin Price 55099 335 1 0 334 45.68051754 -90.3609888 2020-10-25 04:24:36 Price, Wisconsin, US
764676 2020-10-24 US Wisconsin Portage 55097 2565 19 0 2546 44.47558711 -89.50152965 2020-10-25 04:24:36 Portage, Wisconsin, US
Powered by Datasette · Query took 2.217ms · About: simonw/covid-19-datasette