daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

796,500 rows sorted by day descending

View and edit SQL

Suggested facets: day (date), last_update (date)

province_or_state

country_or_region

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-10-23 Zimbabwe       8257 236 7771 250 -19.015438 29.154857 2020-10-24 04:24:46 Zimbabwe
2020-10-23 Zambia       16095 346 15179 570 -13.133897 27.849332 2020-10-24 04:24:46 Zambia
2020-10-23 Yemen       2060 599 1354 107 15.552727 48.516388 2020-10-24 04:24:46 Yemen
2020-10-23 Western Sahara       10 1 8 1 24.2155 -12.8858 2020-10-24 04:24:46 Western Sahara
2020-10-23 West Bank and Gaza       49579 439 42850 6290 31.9522 35.2332 2020-10-24 04:24:46 West Bank and Gaza
2020-10-23 Vietnam       1148 35 1049 64 14.058324 108.277199 2020-10-24 04:24:46 Vietnam
2020-10-23 Venezuela       88718 764 82899 5055 6.4238 -66.5897 2020-10-24 04:24:46 Venezuela
2020-10-23 Uzbekistan       64724 542 61957 2225 41.377491 64.585262 2020-10-24 04:24:46 Uzbekistan
2020-10-23 Uruguay       2759 53 2241 465 -32.5228 -55.7658 2020-10-24 04:24:46 Uruguay
2020-10-23 United Kingdom Wales     40253 1756 0 38497 52.1307 -3.7837 2020-10-24 04:24:46 Wales, United Kingdom
2020-10-23 United Kingdom Unknown     0 0 0 0     2020-10-24 04:24:46 Unknown, United Kingdom
2020-10-23 United Kingdom Turks and Caicos Islands     699 6 689 4 21.694000000000006 -71.7979 2020-10-24 04:24:46 Turks and Caicos Islands, United Kingdom
2020-10-23 United Kingdom Scotland     54016 2688 0 51328 56.4907 -4.2026 2020-10-24 04:24:46 Scotland, United Kingdom
2020-10-23 United Kingdom Northern Ireland     32286 639 0 31647 54.7877 -6.4923 2020-10-24 04:24:46 Northern Ireland, United Kingdom
2020-10-23 United Kingdom Montserrat     13 1 12 0 16.742498 -62.187366 2020-10-24 04:24:46 Montserrat, United Kingdom
2020-10-23 United Kingdom Isle of Man     348 24 321 3 54.2361 -4.5481 2020-10-24 04:24:46 Isle of Man, United Kingdom
2020-10-23 United Kingdom Gibraltar     641 0 500 141 36.1408 -5.3536 2020-10-24 04:24:46 Gibraltar, United Kingdom
2020-10-23 United Kingdom Falkland Islands (Malvinas)     13 0 13 0 -51.7963 -59.5236 2020-10-24 04:24:46 Falkland Islands (Malvinas), United Kingdom
2020-10-23 United Kingdom England     704443 39488 0 664955 52.3555 -1.1743 2020-10-24 04:24:46 England, United Kingdom
2020-10-23 United Kingdom Channel Islands     795 48 659 88 49.3723 -2.3644 2020-10-24 04:24:46 Channel Islands, United Kingdom
2020-10-23 United Kingdom Cayman Islands     239 1 215 23 19.3133 -81.2546 2020-10-24 04:24:46 Cayman Islands, United Kingdom
2020-10-23 United Kingdom British Virgin Islands     71 1 70 0 18.4207 -64.64 2020-10-24 04:24:46 British Virgin Islands, United Kingdom
2020-10-23 United Kingdom Bermuda     190 9 175 6 32.3078 -64.7505 2020-10-24 04:24:46 Bermuda, United Kingdom
2020-10-23 United Kingdom Anguilla     3 0 3 0 18.2206 -63.0686 2020-10-24 04:24:46 Anguilla, United Kingdom
2020-10-23 United Arab Emirates       122273 475 115068 6730 23.424076 53.847818 2020-10-24 04:24:46 United Arab Emirates
2020-10-23 Ukraine Zhytomyr Oblast     11264 188 6222 4854 50.2547 28.6587 2020-10-24 04:24:46 Zhytomyr Oblast, Ukraine
2020-10-23 Ukraine Zaporizhia Oblast     7495 97 1867 5531 47.8388 35.1396 2020-10-24 04:24:46 Zaporizhia Oblast, Ukraine
2020-10-23 Ukraine Zakarpattia Oblast     12541 346 5791 6404 48.6208 22.2879 2020-10-24 04:24:46 Zakarpattia Oblast, Ukraine
2020-10-23 Ukraine Volyn Oblast     11792 233 6772 4787 50.7472 25.3254 2020-10-24 04:24:46 Volyn Oblast, Ukraine
2020-10-23 Ukraine Vinnytsia Oblast     8923 158 5487 3278 49.2331 28.4682 2020-10-24 04:24:46 Vinnytsia Oblast, Ukraine
2020-10-23 Ukraine Ternopil Oblast     18613 237 13574 4802 49.5535 25.5948 2020-10-24 04:24:46 Ternopil Oblast, Ukraine
2020-10-23 Ukraine Sumy Oblast     9888 146 3069 6673 50.9077 34.7981 2020-10-24 04:24:46 Sumy Oblast, Ukraine
2020-10-23 Ukraine Sevastopol*     1856 55 1224 577 44.6054 33.522 2020-10-24 04:24:46 Sevastopol*, Ukraine
2020-10-23 Ukraine Rivne Oblast     16985 207 13117 3661 50.6199 26.2516 2020-10-24 04:24:46 Rivne Oblast, Ukraine
2020-10-23 Ukraine Poltava Oblast     7532 139 2455 4938 49.5883 34.5514 2020-10-24 04:24:46 Poltava Oblast, Ukraine
2020-10-23 Ukraine Odessa Oblast     21128 314 3270 17544 46.4846 30.7326 2020-10-24 04:24:46 Odessa Oblast, Ukraine
2020-10-23 Ukraine Mykolaiv Oblast     6602 124 1625 4853 46.975 31.9946 2020-10-24 04:24:46 Mykolaiv Oblast, Ukraine
2020-10-23 Ukraine Lviv Oblast     26399 753 10422 15224 49.8397 24.0297 2020-10-24 04:24:46 Lviv Oblast, Ukraine
2020-10-23 Ukraine Luhansk Oblast     2985 57 1025 1903 48.574 39.3078 2020-10-24 04:24:46 Luhansk Oblast, Ukraine
2020-10-23 Ukraine Kirovohrad Oblast     1858 77 1077 704 48.5079 32.2623 2020-10-24 04:24:46 Kirovohrad Oblast, Ukraine
2020-10-23 Ukraine Kiev Oblast     13958 319 7528 6111 50.053 30.7667 2020-10-24 04:24:46 Kiev Oblast, Ukraine
2020-10-23 Ukraine Kiev     33135 656 11489 20990 50.4501 30.5234 2020-10-24 04:24:46 Kiev, Ukraine
2020-10-23 Ukraine Khmelnytskyi Oblast     12413 191 5479 6743 49.423 26.9871 2020-10-24 04:24:46 Khmelnytskyi Oblast, Ukraine
2020-10-23 Ukraine Kherson Oblast     2951 62 1255 1634 46.6354 32.6169 2020-10-24 04:24:46 Kherson Oblast, Ukraine
2020-10-23 Ukraine Kharkiv Oblast     31592 480 6097 25015 49.9935 36.2304 2020-10-24 04:24:46 Kharkiv Oblast, Ukraine
2020-10-23 Ukraine Ivano-Frankivsk Oblast     17705 404 9016 8285 48.9226 24.7111 2020-10-24 04:24:46 Ivano-Frankivsk Oblast, Ukraine
2020-10-23 Ukraine Donetsk Oblast     8160 87 1345 6728 48.0159 37.8028 2020-10-24 04:24:46 Donetsk Oblast, Ukraine
2020-10-23 Ukraine Dnipropetrovsk Oblast     12380 299 5293 6788 48.4647 35.0462 2020-10-24 04:24:46 Dnipropetrovsk Oblast, Ukraine
2020-10-23 Ukraine Crimea Republic*     7790 117 4291 3382 45.2835 34.2008 2020-10-24 04:24:46 Crimea Republic*, Ukraine
2020-10-23 Ukraine Chernivtsi Oblast     18811 424 9783 8604 48.2917 25.9352 2020-10-24 04:24:46 Chernivtsi Oblast, Ukraine
2020-10-23 Ukraine Chernihiv Oblast     7582 87 1376 6119 51.4982 31.2893 2020-10-24 04:24:46 Chernihiv Oblast, Ukraine
2020-10-23 Ukraine Cherkasy Oblast     7704 79 3144 4481 49.4444 32.0598 2020-10-24 04:24:46 Cherkasy Oblast, Ukraine
2020-10-23 Uganda       11163 99 7269 3795 1.373333 32.290275 2020-10-24 04:24:46 Uganda
2020-10-23 US Wyoming Weston 56045 121 0 0 121 43.83961191 -104.5674881 2020-10-24 04:24:46 Weston, Wyoming, US
2020-10-23 US Wyoming Washakie 56043 144 7 0 137 43.90451606 -107.68018700000002 2020-10-24 04:24:46 Washakie, Wyoming, US
2020-10-23 US Wyoming Unassigned 90056 0 0 0 0 44.79048913 -110.6563997 2020-10-24 04:24:46 Unassigned, Wyoming, US
2020-10-23 US Wyoming Uinta 56041 425 3 0 422 41.2878183 -110.54757820000002 2020-10-24 04:24:46 Uinta, Wyoming, US
2020-10-23 US Wyoming Teton 56039 740 1 0 739 43.93522482 -110.5890801 2020-10-24 04:24:46 Teton, Wyoming, US
2020-10-23 US Wyoming Sweetwater 56037 451 2 0 449 41.65943896 -108.8827882 2020-10-24 04:24:46 Sweetwater, Wyoming, US
2020-10-23 US Wyoming Sublette 56035 158 1 0 157 42.76558279 -109.9130922 2020-10-24 04:24:46 Sublette, Wyoming, US
2020-10-23 US Wyoming Sheridan 56033 634 4 0 630 44.79048913 -106.8862389 2020-10-24 04:24:46 Sheridan, Wyoming, US
2020-10-23 US Wyoming Platte 56031 115 1 0 114 42.13299116 -104.966331 2020-10-24 04:24:46 Platte, Wyoming, US
2020-10-23 US Wyoming Park 56029 536 3 0 533 44.52157546 -109.5852825 2020-10-24 04:24:46 Park, Wyoming, US
2020-10-23 US Wyoming Niobrara 56027 7 0 0 7 43.05607708 -104.4758896 2020-10-24 04:24:46 Niobrara, Wyoming, US
2020-10-23 US Wyoming Natrona 56025 1193 9 0 1184 42.96180148 -106.797885 2020-10-24 04:24:46 Natrona, Wyoming, US
2020-10-23 US Wyoming Lincoln 56023 326 2 0 324 42.26376367 -110.6563997 2020-10-24 04:24:46 Lincoln, Wyoming, US
2020-10-23 US Wyoming Laramie 56021 1366 4 0 1362 41.30702520000001 -104.6887497 2020-10-24 04:24:46 Laramie, Wyoming, US
2020-10-23 US Wyoming Johnson 56019 83 2 0 81 44.04057166 -106.5845174 2020-10-24 04:24:46 Johnson, Wyoming, US
2020-10-23 US Wyoming Hot Springs 56017 49 0 0 49 43.71930657 -108.4423174 2020-10-24 04:24:46 Hot Springs, Wyoming, US
2020-10-23 US Wyoming Goshen 56015 148 3 0 145 42.08798185 -104.3534743 2020-10-24 04:24:46 Goshen, Wyoming, US
2020-10-23 US Wyoming Fremont 56013 1189 15 0 1174 43.04183996 -108.6296893 2020-10-24 04:24:46 Fremont, Wyoming, US
2020-10-23 US Wyoming Crook 56011 98 1 0 97 44.58855102 -104.5697705 2020-10-24 04:24:46 Crook, Wyoming, US
2020-10-23 US Wyoming Converse 56009 283 0 0 283 42.97272268 -105.5081848 2020-10-24 04:24:46 Converse, Wyoming, US
2020-10-23 US Wyoming Carbon 56007 299 2 0 297 41.69357844 -106.9326084 2020-10-24 04:24:46 Carbon, Wyoming, US
2020-10-23 US Wyoming Campbell 56005 765 3 0 762 44.24886082 -105.5474404 2020-10-24 04:24:46 Campbell, Wyoming, US
2020-10-23 US Wyoming Big Horn 56003 201 2 0 199 44.52405055 -107.9960365 2020-10-24 04:24:46 Big Horn, Wyoming, US
2020-10-23 US Wyoming Albany 56001 1214 3 0 1211 41.65498705 -105.7235415 2020-10-24 04:24:46 Albany, Wyoming, US
2020-10-23 US Wisconsin Wood 55141 1536 9 0 1527 44.45537896 -90.04158336 2020-10-24 04:24:46 Wood, Wisconsin, US
2020-10-23 US Wisconsin Winnebago 55139 8159 54 0 8105 44.06886922 -88.64477096 2020-10-24 04:24:46 Winnebago, Wisconsin, US
2020-10-23 US Wisconsin Waushara 55137 906 5 0 901 44.11324419 -89.24317107 2020-10-24 04:24:46 Waushara, Wisconsin, US
2020-10-23 US Wisconsin Waupaca 55135 2149 38 0 2111 44.47068056 -88.96534501 2020-10-24 04:24:46 Waupaca, Wisconsin, US
2020-10-23 US Wisconsin Waukesha 55133 11389 112 0 11277 43.01833055 -88.30431188 2020-10-24 04:24:46 Waukesha, Wisconsin, US
2020-10-23 US Wisconsin Washington 55131 4076 43 0 4033 43.36863664 -88.22974712 2020-10-24 04:24:46 Washington, Wisconsin, US
2020-10-23 US Wisconsin Washburn 55129 217 2 0 215 45.89838588 -91.79050449 2020-10-24 04:24:46 Washburn, Wisconsin, US
2020-10-23 US Wisconsin Walworth 55127 3213 37 0 3176 42.66858202 -88.54163073 2020-10-24 04:24:46 Walworth, Wisconsin, US
2020-10-23 US Wisconsin Vilas 55125 509 5 0 504 46.05467334 -89.51719204 2020-10-24 04:24:46 Vilas, Wisconsin, US
2020-10-23 US Wisconsin Vernon 55123 463 3 0 460 43.59422667 -90.8324691 2020-10-24 04:24:46 Vernon, Wisconsin, US
2020-10-23 US Wisconsin Unassigned 90055 0 0 0 0 46.52868768 0.0 2020-10-24 04:24:46 Unassigned, Wisconsin, US
2020-10-23 US Wisconsin Trempealeau 55121 961 2 0 959 44.30360275 -91.35893614 2020-10-24 04:24:46 Trempealeau, Wisconsin, US
2020-10-23 US Wisconsin Taylor 55119 424 7 0 417 45.21179252 -90.5004405 2020-10-24 04:24:46 Taylor, Wisconsin, US
2020-10-23 US Wisconsin St. Croix 55109 1609 10 0 1599 45.03437474 -92.45000068 2020-10-24 04:24:46 St. Croix, Wisconsin, US
2020-10-23 US Wisconsin Sheboygan 55117 4202 24 0 4178 43.72099677 -87.94579284 2020-10-24 04:24:46 Sheboygan, Wisconsin, US
2020-10-23 US Wisconsin Shawano 55115 2215 17 0 2198 44.78902246 -88.76443896 2020-10-24 04:24:46 Shawano, Wisconsin, US
2020-10-23 US Wisconsin Sawyer 55113 356 1 0 355 45.87931905 -91.14504927 2020-10-24 04:24:46 Sawyer, Wisconsin, US
2020-10-23 US Wisconsin Sauk 55111 1586 7 0 1579 43.42574087 -89.94966132 2020-10-24 04:24:46 Sauk, Wisconsin, US
2020-10-23 US Wisconsin Rusk 55107 182 1 0 181 45.47498854 -91.1333012 2020-10-24 04:24:46 Rusk, Wisconsin, US
2020-10-23 US Wisconsin Rock 55105 4520 41 0 4479 42.67151616 -89.07147900000002 2020-10-24 04:24:46 Rock, Wisconsin, US
2020-10-23 US Wisconsin Richland 55103 422 6 0 416 43.3762778 -90.43012729 2020-10-24 04:24:46 Richland, Wisconsin, US
2020-10-23 US Wisconsin Racine 55101 6814 107 0 6707 42.74753117 -88.05941254 2020-10-24 04:24:46 Racine, Wisconsin, US
2020-10-23 US Wisconsin Price 55099 329 1 0 328 45.68051754 -90.3609888 2020-10-24 04:24:46 Price, Wisconsin, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;
Powered by Datasette · Query took 4044.18ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette