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

4,002 rows where last_update = "2022-09-01 04:21:03" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

These facets timed out: 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
2022-08-31 United Kingdom Pitcairn Islands     4 0 0 0 -24.3768 -128.3242 2022-09-01 04:21:03 Pitcairn Islands, United Kingdom
2022-08-31 Tuvalu       20 0 0 0 -7.1095 177.6493 2022-09-01 04:21:03 Tuvalu
2022-08-31 New Zealand Niue     71 0 0 0 -19.0544 -169.8672 2022-09-01 04:21:03 Niue, New Zealand
2022-08-31 Nauru       4610 1 0 0 -0.5228 166.9315 2022-09-01 04:21:03 Nauru
2022-08-31 Zimbabwe       256726 5596 0   -19.015438 29.154857 2022-09-01 04:21:03 Zimbabwe
2022-08-31 Zambia       332822 4016 0   -13.133897 27.849332 2022-09-01 04:21:03 Zambia
2022-08-31 Yemen       11926 2155 0   15.552727 48.516388 2022-09-01 04:21:03 Yemen
2022-08-31 Winter Olympics 2022       535 0 0   39.9042 116.4074 2022-09-01 04:21:03 Winter Olympics 2022
2022-08-31 West Bank and Gaza       702332 5704 0   31.9522 35.2332 2022-09-01 04:21:03 West Bank and Gaza
2022-08-31 Vietnam       11411679 43117 0   14.058324 108.277199 2022-09-01 04:21:03 Vietnam
2022-08-31 Venezuela       542508 5796 0   6.4238 -66.5897 2022-09-01 04:21:03 Venezuela
2022-08-31 Vanuatu       11815 14 0   -15.3767 166.9592 2022-09-01 04:21:03 Vanuatu
2022-08-31 Uzbekistan       243801 1637 0   41.377491 64.585262 2022-09-01 04:21:03 Uzbekistan
2022-08-31 Uruguay       979160 7445 0   -32.5228 -55.7658 2022-09-01 04:21:03 Uruguay
2022-08-31 United Kingdom Wales     883871 10774 0   52.1307 -3.7837 2022-09-01 04:21:03 Wales, United Kingdom
2022-08-31 United Kingdom Unknown     0 318 0   55.3781 -3.436 2022-09-01 04:21:03 Unknown, United Kingdom
2022-08-31 United Kingdom Turks and Caicos Islands     6369 36 0   21.694 -71.7979 2022-09-01 04:21:03 Turks and Caicos Islands, United Kingdom
2022-08-31 United Kingdom Scotland     2091313 15629 0   56.4907 -4.2026 2022-09-01 04:21:03 Scotland, United Kingdom
2022-08-31 United Kingdom Saint Helena, Ascension and Tristan da Cunha     7 0 0   -7.9467 -14.3559 2022-09-01 04:21:03 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
2022-08-31 United Kingdom Northern Ireland     713294 4844 0   54.7877 -6.4923 2022-09-01 04:21:03 Northern Ireland, United Kingdom
2022-08-31 United Kingdom Montserrat     1145 8 0   16.742498 -62.187366 2022-09-01 04:21:03 Montserrat, United Kingdom
2022-08-31 United Kingdom Jersey     58890 136 0   49.2138 -2.1358 2022-09-01 04:21:03 Jersey, United Kingdom
2022-08-31 United Kingdom Isle of Man     38008 116 0   54.2361 -4.5481 2022-09-01 04:21:03 Isle of Man, United Kingdom
2022-08-31 United Kingdom Guernsey     30767 62 0   49.448196 -2.58949 2022-09-01 04:21:03 Guernsey, United Kingdom
2022-08-31 United Kingdom Gibraltar     20049 107 0   36.1408 -5.3536 2022-09-01 04:21:03 Gibraltar, United Kingdom
2022-08-31 United Kingdom Falkland Islands (Malvinas)     1886 0 0   -51.7963 -59.5236 2022-09-01 04:21:03 Falkland Islands (Malvinas), United Kingdom
2022-08-31 United Kingdom England     19833314 175415 0   52.3555 -1.1743 2022-09-01 04:21:03 England, United Kingdom
2022-08-31 United Kingdom Channel Islands     0 0 0   49.3723 -2.3644 2022-09-01 04:21:03 Channel Islands, United Kingdom
2022-08-31 United Kingdom Cayman Islands     30057 29 0   19.3133 -81.2546 2022-09-01 04:21:03 Cayman Islands, United Kingdom
2022-08-31 United Kingdom British Virgin Islands     7291 64 0   18.4207 -64.64 2022-09-01 04:21:03 British Virgin Islands, United Kingdom
2022-08-31 United Kingdom Bermuda     17913 148 0   32.3078 -64.7505 2022-09-01 04:21:03 Bermuda, United Kingdom
2022-08-31 United Kingdom Anguilla     3837 11 0   18.2206 -63.0686 2022-09-01 04:21:03 Anguilla, United Kingdom
2022-08-31 United Arab Emirates       1015398 2341 0   23.424076 53.847818 2022-09-01 04:21:03 United Arab Emirates
2022-08-31 Ukraine Zhytomyr Oblast     192801 3538 0   50.2547 28.6587 2022-09-01 04:21:03 Zhytomyr Oblast, Ukraine
2022-08-31 Ukraine Zaporizhia Oblast     215070 5866 0   47.8388 35.1396 2022-09-01 04:21:03 Zaporizhia Oblast, Ukraine
2022-08-31 Ukraine Zakarpattia Oblast     112462 2724 0   48.6208 22.2879 2022-09-01 04:21:03 Zakarpattia Oblast, Ukraine
2022-08-31 Ukraine Volyn Oblast     132045 2394 0   50.7472 25.3254 2022-09-01 04:21:03 Volyn Oblast, Ukraine
2022-08-31 Ukraine Vinnytsia Oblast     149845 3546 0   49.2331 28.4682 2022-09-01 04:21:03 Vinnytsia Oblast, Ukraine
2022-08-31 Ukraine Unknown     235317 3298 0       2022-09-01 04:21:03 Unknown, Ukraine
2022-08-31 Ukraine Ternopil Oblast     146363 2391 0   49.5535 25.5948 2022-09-01 04:21:03 Ternopil Oblast, Ukraine
2022-08-31 Ukraine Sumy Oblast     182268 3208 0   50.9077 34.7981 2022-09-01 04:21:03 Sumy Oblast, Ukraine
2022-08-31 Ukraine Sevastopol*     89727 2425 0   44.6054 33.522 2022-09-01 04:21:03 Sevastopol*, Ukraine
2022-08-31 Ukraine Rivne Oblast     171031 2530 0   50.6199 26.2516 2022-09-01 04:21:03 Rivne Oblast, Ukraine
2022-08-31 Ukraine Poltava Oblast     179994 4181 0   49.5883 34.5514 2022-09-01 04:21:03 Poltava Oblast, Ukraine
2022-08-31 Ukraine Odessa Oblast     325462 5917 0   46.4846 30.7326 2022-09-01 04:21:03 Odessa Oblast, Ukraine
2022-08-31 Ukraine Mykolaiv Oblast     146174 3530 0   46.975 31.9946 2022-09-01 04:21:03 Mykolaiv Oblast, Ukraine
2022-08-31 Ukraine Lviv Oblast     303357 6569 0   49.8397 24.0297 2022-09-01 04:21:03 Lviv Oblast, Ukraine
2022-08-31 Ukraine Luhansk Oblast     80033 2392 0   48.574 39.3078 2022-09-01 04:21:03 Luhansk Oblast, Ukraine
2022-08-31 Ukraine Kirovohrad Oblast     45117 1741 0   48.5079 32.2623 2022-09-01 04:21:03 Kirovohrad Oblast, Ukraine
2022-08-31 Ukraine Kiev Oblast     226220 5019 0   50.053 30.7667 2022-09-01 04:21:03 Kiev Oblast, Ukraine
2022-08-31 Ukraine Kiev     445098 8966 0   50.4501 30.5234 2022-09-01 04:21:03 Kiev, Ukraine
2022-08-31 Ukraine Khmelnytskyi Oblast     201270 3703 0   49.423 26.9871 2022-09-01 04:21:03 Khmelnytskyi Oblast, Ukraine
2022-08-31 Ukraine Kherson Oblast     107686 2881 0   46.6354 32.6169 2022-09-01 04:21:03 Kherson Oblast, Ukraine
2022-08-31 Ukraine Kharkiv Oblast     305661 6858 0   49.9935 36.2304 2022-09-01 04:21:03 Kharkiv Oblast, Ukraine
2022-08-31 Ukraine Ivano-Frankivsk Oblast     181629 3476 0   48.9226 24.7111 2022-09-01 04:21:03 Ivano-Frankivsk Oblast, Ukraine
2022-08-31 Ukraine Donetsk Oblast     216052 5607 0   48.0159 37.8028 2022-09-01 04:21:03 Donetsk Oblast, Ukraine
2022-08-31 Ukraine Dnipropetrovsk Oblast     303551 9454 0   48.4647 35.0462 2022-09-01 04:21:03 Dnipropetrovsk Oblast, Ukraine
2022-08-31 Ukraine Crimea Republic*     194595 5363 0   45.2835 34.2008 2022-09-01 04:21:03 Crimea Republic*, Ukraine
2022-08-31 Ukraine Chernivtsi Oblast     150465 3290 0   48.2917 25.9352 2022-09-01 04:21:03 Chernivtsi Oblast, Ukraine
2022-08-31 Ukraine Chernihiv Oblast     126202 2751 0   51.4982 31.2893 2022-09-01 04:21:03 Chernihiv Oblast, Ukraine
2022-08-31 Ukraine Cherkasy Oblast     163768 2973 0   49.4444 32.0598 2022-09-01 04:21:03 Cherkasy Oblast, Ukraine
2022-08-31 Uganda       169396 3628 0   1.373333 32.290275 2022-09-01 04:21:03 Uganda
2022-08-31 US Wyoming Weston 56045 1790 20 0   43.83961191 -104.5674881 2022-09-01 04:21:03 Weston, Wyoming, US
2022-08-31 US Wyoming Washakie 56043 2631 47 0   43.90451606 -107.680187 2022-09-01 04:21:03 Washakie, Wyoming, US
2022-08-31 US Wyoming Unassigned 90056 0 0 0   44.79048913 -110.6563997 2022-09-01 04:21:03 Unassigned, Wyoming, US
2022-08-31 US Wyoming Uinta 56041 6061 40 0   41.2878183 -110.5475782 2022-09-01 04:21:03 Uinta, Wyoming, US
2022-08-31 US Wyoming Teton 56039 11526 16 0   43.93522482 -110.5890801 2022-09-01 04:21:03 Teton, Wyoming, US
2022-08-31 US Wyoming Sweetwater 56037 12063 130 0   41.65943896 -108.8827882 2022-09-01 04:21:03 Sweetwater, Wyoming, US
2022-08-31 US Wyoming Sublette 56035 2160 27 0   42.76558279 -109.9130922 2022-09-01 04:21:03 Sublette, Wyoming, US
2022-08-31 US Wyoming Sheridan 56033 9150 81 0   44.79048913 -106.8862389 2022-09-01 04:21:03 Sheridan, Wyoming, US
2022-08-31 US Wyoming Platte 56031 2127 43 0   42.13299116 -104.966331 2022-09-01 04:21:03 Platte, Wyoming, US
2022-08-31 US Wyoming Park 56029 7358 149 0   44.52157546 -109.5852825 2022-09-01 04:21:03 Park, Wyoming, US
2022-08-31 US Wyoming Niobrara 56027 750 10 0   43.05607708 -104.4758896 2022-09-01 04:21:03 Niobrara, Wyoming, US
2022-08-31 US Wyoming Natrona 56025 24367 284 0   42.96180148 -106.797885 2022-09-01 04:21:03 Natrona, Wyoming, US
2022-08-31 US Wyoming Lincoln 56023 4646 32 0   42.26376367 -110.6563997 2022-09-01 04:21:03 Lincoln, Wyoming, US
2022-08-31 US Wyoming Laramie 56021 29766 304 0   41.3070252 -104.6887497 2022-09-01 04:21:03 Laramie, Wyoming, US
2022-08-31 US Wyoming Johnson 56019 2142 20 0   44.04057166 -106.5845174 2022-09-01 04:21:03 Johnson, Wyoming, US
2022-08-31 US Wyoming Hot Springs 56017 1334 18 0   43.71930657 -108.4423174 2022-09-01 04:21:03 Hot Springs, Wyoming, US
2022-08-31 US Wyoming Goshen 56015 4355 57 0   42.08798185 -104.3534743 2022-09-01 04:21:03 Goshen, Wyoming, US
2022-08-31 US Wyoming Fremont 56013 15724 198 0   43.04183996 -108.6296893 2022-09-01 04:21:03 Fremont, Wyoming, US
2022-08-31 US Wyoming Crook 56011 1484 29 0   44.58855102 -104.5697705 2022-09-01 04:21:03 Crook, Wyoming, US
2022-08-31 US Wyoming Converse 56009 3439 56 0   42.97272268 -105.5081848 2022-09-01 04:21:03 Converse, Wyoming, US
2022-08-31 US Wyoming Carbon 56007 4854 54 0   41.69357844 -106.9326084 2022-09-01 04:21:03 Carbon, Wyoming, US
2022-08-31 US Wyoming Campbell 56005 13230 151 0   44.24886082 -105.5474404 2022-09-01 04:21:03 Campbell, Wyoming, US
2022-08-31 US Wyoming Big Horn 56003 2900 64 0   44.52405055 -107.9960365 2022-09-01 04:21:03 Big Horn, Wyoming, US
2022-08-31 US Wyoming Albany 56001 10971 51 0   41.65498705 -105.7235415 2022-09-01 04:21:03 Albany, Wyoming, US
2022-08-31 US Wisconsin Wood 55141 24499 244 0   44.45537896 -90.04158336 2022-09-01 04:21:03 Wood, Wisconsin, US
2022-08-31 US Wisconsin Winnebago 55139 58635 399 0   44.06886922 -88.64477096 2022-09-01 04:21:03 Winnebago, Wisconsin, US
2022-08-31 US Wisconsin Waushara 55137 7095 88 0   44.11324419 -89.24317107 2022-09-01 04:21:03 Waushara, Wisconsin, US
2022-08-31 US Wisconsin Waupaca 55135 15053 257 0   44.47068056 -88.96534501 2022-09-01 04:21:03 Waupaca, Wisconsin, US
2022-08-31 US Wisconsin Waukesha 55133 128827 1142 0   43.01833055 -88.30431188 2022-09-01 04:21:03 Waukesha, Wisconsin, US
2022-08-31 US Wisconsin Washington 55131 43106 349 0   43.36863664 -88.22974712 2022-09-01 04:21:03 Washington, Wisconsin, US
2022-08-31 US Wisconsin Washburn 55129 4603 47 0   45.89838588 -91.79050449 2022-09-01 04:21:03 Washburn, Wisconsin, US
2022-08-31 US Wisconsin Walworth 55127 30184 290 0   42.66858202 -88.54163073 2022-09-01 04:21:03 Walworth, Wisconsin, US
2022-08-31 US Wisconsin Vilas 55125 5967 94 0   46.05467334 -89.51719204 2022-09-01 04:21:03 Vilas, Wisconsin, US
2022-08-31 US Wisconsin Vernon 55123 6983 106 0   43.59422667 -90.8324691 2022-09-01 04:21:03 Vernon, Wisconsin, US
2022-08-31 US Wisconsin Unassigned 90055 0 0 0   46.52868768 0.0 2022-09-01 04:21:03 Unassigned, Wisconsin, US
2022-08-31 US Wisconsin Trempealeau 55121 9282 67 0   44.30360275 -91.35893614 2022-09-01 04:21:03 Trempealeau, Wisconsin, US
2022-08-31 US Wisconsin Taylor 55119 5343 73 0   45.21179252 -90.5004405 2022-09-01 04:21:03 Taylor, Wisconsin, US
2022-08-31 US Wisconsin St. Croix 55109 28322 155 0   45.03437474 -92.45000068 2022-09-01 04:21:03 St. Croix, 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;