⚠️ 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.

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

1,585,769 rows sorted by day descending

View and edit SQL

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

province_or_state

country_or_region

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
1552055 2021-05-09 Zimbabwe       38419 1576 36063 780 -19.015438 29.154857 2021-05-10 04:20:38 Zimbabwe
1552054 2021-05-09 Zambia       92092 1257 90428 407 -13.133897 27.849332 2021-05-10 04:20:38 Zambia
1552053 2021-05-09 Yemen       6482 1271 2992 2219 15.552727 48.516388 2021-05-10 04:20:38 Yemen
1552052 2021-05-09 West Bank and Gaza       301751 3358 286385 12008 31.9522 35.2332 2021-05-10 04:20:38 West Bank and Gaza
1552051 2021-05-09 Vietnam       3412 35 2602 775 14.058324 108.277199 2021-05-10 04:20:38 Vietnam
1552050 2021-05-09 Venezuela       207870 2291 190768 14811 6.4238 -66.5897 2021-05-10 04:20:38 Venezuela
1552049 2021-05-09 Vanuatu       4 1 3 0 -15.3767 166.9592 2021-05-10 04:20:38 Vanuatu
1552048 2021-05-09 Uzbekistan       94397 662 90053 3682 41.377491 64.585262 2021-05-10 04:20:38 Uzbekistan
1552047 2021-05-09 Uruguay       220683 3122 192114 25447 -32.5228 -55.7658 2021-05-10 04:20:38 Uruguay
1552046 2021-05-09 United Kingdom Wales     211827 5552 0 206275 52.1307 -3.7837 2021-05-10 04:20:38 Wales, United Kingdom
1552045 2021-05-09 United Kingdom Unknown     0 0 0 0     2021-05-10 04:20:38 Unknown, United Kingdom
1552044 2021-05-09 United Kingdom Turks and Caicos Islands     2402 17 2358 27 21.694000000000006 -71.7979 2021-05-10 04:20:38 Turks and Caicos Islands, United Kingdom
1552043 2021-05-09 United Kingdom Scotland     227672 7661 0 220011 56.4907 -4.2026 2021-05-10 04:20:38 Scotland, United Kingdom
1552042 2021-05-09 United Kingdom Saint Helena, Ascension and Tristan da Cunha     4 0 4 0 -7.9467 -14.3559 2021-05-10 04:20:38 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
1552041 2021-05-09 United Kingdom Northern Ireland     120946 2147 0 118799 54.7877 -6.4923 2021-05-10 04:20:38 Northern Ireland, United Kingdom
1552040 2021-05-09 United Kingdom Montserrat     20 1 19 0 16.742498 -62.187366 2021-05-10 04:20:38 Montserrat, United Kingdom
1552039 2021-05-09 United Kingdom Isle of Man     1590 29 1550 11 54.2361 -4.5481 2021-05-10 04:20:38 Isle of Man, United Kingdom
1552038 2021-05-09 United Kingdom Gibraltar     4286 94 4189 3 36.1408 -5.3536 2021-05-10 04:20:38 Gibraltar, United Kingdom
1552037 2021-05-09 United Kingdom Falkland Islands (Malvinas)     63 0 63 0 -51.7963 -59.5236 2021-05-10 04:20:38 Falkland Islands (Malvinas), United Kingdom
1552036 2021-05-09 United Kingdom England     3874415 112245 0 3762170 52.3555 -1.1743 2021-05-10 04:20:38 England, United Kingdom
1552035 2021-05-09 United Kingdom Channel Islands     4056 86 3956 14 49.3723 -2.3644 2021-05-10 04:20:38 Channel Islands, United Kingdom
1552034 2021-05-09 United Kingdom Cayman Islands     548 2 537 9 19.3133 -81.2546 2021-05-10 04:20:38 Cayman Islands, United Kingdom
1552033 2021-05-09 United Kingdom British Virgin Islands     216 1 191 24 18.4207 -64.64 2021-05-10 04:20:38 British Virgin Islands, United Kingdom
1552032 2021-05-09 United Kingdom Bermuda     2434 30 2095 309 32.3078 -64.7505 2021-05-10 04:20:38 Bermuda, United Kingdom
1552031 2021-05-09 United Kingdom Anguilla     99 0 49 50 18.2206 -63.0686 2021-05-10 04:20:38 Anguilla, United Kingdom
1552030 2021-05-09 United Arab Emirates       536017 1613 516329 18075 23.424076 53.847818 2021-05-10 04:20:38 United Arab Emirates
1552029 2021-05-09 Ukraine Zhytomyr Oblast     85613 1655 71484 12474 50.2547 28.6587 2021-05-10 04:20:38 Zhytomyr Oblast, Ukraine
1552028 2021-05-09 Ukraine Zaporizhia Oblast     98273 2030 83093 13150 47.8388 35.1396 2021-05-10 04:20:38 Zaporizhia Oblast, Ukraine
1552027 2021-05-09 Ukraine Zakarpattia Oblast     60534 1542 56181 2811 48.6208 22.2879 2021-05-10 04:20:38 Zakarpattia Oblast, Ukraine
1552026 2021-05-09 Ukraine Volyn Oblast     58544 1041 52420 5083 50.7472 25.3254 2021-05-10 04:20:38 Volyn Oblast, Ukraine
1552025 2021-05-09 Ukraine Vinnytsia Oblast     68889 1572 54340 12977 49.2331 28.4682 2021-05-10 04:20:38 Vinnytsia Oblast, Ukraine
1552024 2021-05-09 Ukraine Ternopil Oblast     67506 1107 60232 6167 49.5535 25.5948 2021-05-10 04:20:38 Ternopil Oblast, Ukraine
1552023 2021-05-09 Ukraine Sumy Oblast     74488 1178 67345 5965 50.9077 34.7981 2021-05-10 04:20:38 Sumy Oblast, Ukraine
1552022 2021-05-09 Ukraine Sevastopol*     14263 645 13181 437 44.6054 33.522 2021-05-10 04:20:38 Sevastopol*, Ukraine
1552021 2021-05-09 Ukraine Rivne Oblast     73634 1082 66357 6195 50.6199 26.2516 2021-05-10 04:20:38 Rivne Oblast, Ukraine
1552020 2021-05-09 Ukraine Poltava Oblast     73760 1626 64023 8111 49.5883 34.5514 2021-05-10 04:20:38 Poltava Oblast, Ukraine
1552019 2021-05-09 Ukraine Odessa Oblast     136318 2686 106277 27355 46.4846 30.7326 2021-05-10 04:20:38 Odessa Oblast, Ukraine
1552018 2021-05-09 Ukraine Mykolaiv Oblast     64915 1701 60112 3102 46.975 31.9946 2021-05-10 04:20:38 Mykolaiv Oblast, Ukraine
1552017 2021-05-09 Ukraine Lviv Oblast     131643 3373 109234 19036 49.8397 24.0297 2021-05-10 04:20:38 Lviv Oblast, Ukraine
1552016 2021-05-09 Ukraine Luhansk Oblast     24538 786 20017 3735 48.574 39.3078 2021-05-10 04:20:38 Luhansk Oblast, Ukraine
1552015 2021-05-09 Ukraine Kirovohrad Oblast     19111 707 12062 6342 48.5079 32.2623 2021-05-10 04:20:38 Kirovohrad Oblast, Ukraine
1552014 2021-05-09 Ukraine Kiev Oblast     120560 2512 106008 12040 50.053 30.7667 2021-05-10 04:20:38 Kiev Oblast, Ukraine
1552013 2021-05-09 Ukraine Kiev     198976 4818 128111 66047 50.4501 30.5234 2021-05-10 04:20:38 Kiev, Ukraine
1552012 2021-05-09 Ukraine Khmelnytskyi Oblast     85523 1692 74470 9361 49.423 26.9871 2021-05-10 04:20:38 Khmelnytskyi Oblast, Ukraine
1552011 2021-05-09 Ukraine Kherson Oblast     32319 970 26511 4838 46.6354 32.6169 2021-05-10 04:20:38 Kherson Oblast, Ukraine
1552010 2021-05-09 Ukraine Kharkiv Oblast     140382 2904 115178 22300 49.9935 36.2304 2021-05-10 04:20:38 Kharkiv Oblast, Ukraine
1552009 2021-05-09 Ukraine Ivano-Frankivsk Oblast     84589 1996 79410 3183 48.9226 24.7111 2021-05-10 04:20:38 Ivano-Frankivsk Oblast, Ukraine
1552008 2021-05-09 Ukraine Donetsk Oblast     83535 1879 68689 12967 48.0159 37.8028 2021-05-10 04:20:38 Donetsk Oblast, Ukraine
1552007 2021-05-09 Ukraine Dnipropetrovsk Oblast     126128 3552 103755 18821 48.4647 35.0462 2021-05-10 04:20:38 Dnipropetrovsk Oblast, Ukraine
1552006 2021-05-09 Ukraine Crimea Republic*     41378 1256 38239 1883 45.2835 34.2008 2021-05-10 04:20:38 Crimea Republic*, Ukraine
1552005 2021-05-09 Ukraine Chernivtsi Oblast     77856 1694 66255 9907 48.2917 25.9352 2021-05-10 04:20:38 Chernivtsi Oblast, Ukraine
1552004 2021-05-09 Ukraine Chernihiv Oblast     54736 1186 44659 8891 51.4982 31.2893 2021-05-10 04:20:38 Chernihiv Oblast, Ukraine
1552003 2021-05-09 Ukraine Cherkasy Oblast     77140 1104 63528 12508 49.4444 32.0598 2021-05-10 04:20:38 Cherkasy Oblast, Ukraine
1552002 2021-05-09 Uganda       42355 346 41924 85 1.373333 32.290275 2021-05-10 04:20:38 Uganda
1552001 2021-05-09 US Wyoming Weston 56045 651 5 0   43.83961191 -104.5674881 2021-05-10 04:20:38 Weston, Wyoming, US
1552000 2021-05-09 US Wyoming Washakie 56043 911 26 0   43.90451606 -107.68018700000002 2021-05-10 04:20:38 Washakie, Wyoming, US
1551999 2021-05-09 US Wyoming Unassigned 90056 0 0 0   44.79048913 -110.6563997 2021-05-10 04:20:38 Unassigned, Wyoming, US
1551998 2021-05-09 US Wyoming Uinta 56041 2217 13 0   41.2878183 -110.54757820000002 2021-05-10 04:20:38 Uinta, Wyoming, US
1551997 2021-05-09 US Wyoming Teton 56039 3751 9 0   43.93522482 -110.5890801 2021-05-10 04:20:38 Teton, Wyoming, US
1551996 2021-05-09 US Wyoming Sweetwater 56037 4285 38 0   41.65943896 -108.8827882 2021-05-10 04:20:38 Sweetwater, Wyoming, US
1551995 2021-05-09 US Wyoming Sublette 56035 782 7 0   42.76558279 -109.9130922 2021-05-10 04:20:38 Sublette, Wyoming, US
1551994 2021-05-09 US Wyoming Sheridan 56033 3157 31 0   44.79048913 -106.8862389 2021-05-10 04:20:38 Sheridan, Wyoming, US
1551993 2021-05-09 US Wyoming Platte 56031 624 11 0   42.13299116 -104.966331 2021-05-10 04:20:38 Platte, Wyoming, US
1551992 2021-05-09 US Wyoming Park 56029 2728 30 0   44.52157546 -109.5852825 2021-05-10 04:20:38 Park, Wyoming, US
1551991 2021-05-09 US Wyoming Niobrara 56027 161 2 0   43.05607708 -104.4758896 2021-05-10 04:20:38 Niobrara, Wyoming, US
1551990 2021-05-09 US Wyoming Natrona 56025 7980 136 0   42.96180148 -106.797885 2021-05-10 04:20:38 Natrona, Wyoming, US
1551989 2021-05-09 US Wyoming Lincoln 56023 1405 12 0   42.26376367 -110.6563997 2021-05-10 04:20:38 Lincoln, Wyoming, US
1551988 2021-05-09 US Wyoming Laramie 56021 9148 113 0   41.30702520000001 -104.6887497 2021-05-10 04:20:38 Laramie, Wyoming, US
1551987 2021-05-09 US Wyoming Johnson 56019 718 10 0   44.04057166 -106.5845174 2021-05-10 04:20:38 Johnson, Wyoming, US
1551986 2021-05-09 US Wyoming Hot Springs 56017 368 3 0   43.71930657 -108.4423174 2021-05-10 04:20:38 Hot Springs, Wyoming, US
1551985 2021-05-09 US Wyoming Goshen 56015 1206 24 0   42.08798185 -104.3534743 2021-05-10 04:20:38 Goshen, Wyoming, US
1551984 2021-05-09 US Wyoming Fremont 56013 5179 84 0   43.04183996 -108.6296893 2021-05-10 04:20:38 Fremont, Wyoming, US
1551983 2021-05-09 US Wyoming Crook 56011 429 12 0   44.58855102 -104.5697705 2021-05-10 04:20:38 Crook, Wyoming, US
1551982 2021-05-09 US Wyoming Converse 56009 1001 17 0   42.97272268 -105.5081848 2021-05-10 04:20:38 Converse, Wyoming, US
1551981 2021-05-09 US Wyoming Carbon 56007 1586 23 0   41.69357844 -106.9326084 2021-05-10 04:20:38 Carbon, Wyoming, US
1551980 2021-05-09 US Wyoming Campbell 56005 4853 60 0   44.24886082 -105.5474404 2021-05-10 04:20:38 Campbell, Wyoming, US
1551979 2021-05-09 US Wyoming Big Horn 56003 1154 32 0   44.52405055 -107.9960365 2021-05-10 04:20:38 Big Horn, Wyoming, US
1551978 2021-05-09 US Wyoming Albany 56001 4329 12 0   41.65498705 -105.7235415 2021-05-10 04:20:38 Albany, Wyoming, US
1551977 2021-05-09 US Wisconsin Wood 55141 7541 93 0   44.45537896 -90.04158336 2021-05-10 04:20:38 Wood, Wisconsin, US
1551976 2021-05-09 US Wisconsin Winnebago 55139 21220 219 0   44.06886922 -88.64477096 2021-05-10 04:20:38 Winnebago, Wisconsin, US
1551975 2021-05-09 US Wisconsin Waushara 55137 2497 37 0   44.11324419 -89.24317107 2021-05-10 04:20:38 Waushara, Wisconsin, US
1551974 2021-05-09 US Wisconsin Waupaca 55135 6015 164 0   44.47068056 -88.96534501 2021-05-10 04:20:38 Waupaca, Wisconsin, US
1551973 2021-05-09 US Wisconsin Waukesha 55133 48672 578 0   43.01833055 -88.30431188 2021-05-10 04:20:38 Waukesha, Wisconsin, US
1551972 2021-05-09 US Wisconsin Washington 55131 16719 167 0   43.36863664 -88.22974712 2021-05-10 04:20:38 Washington, Wisconsin, US
1551971 2021-05-09 US Wisconsin Washburn 55129 1546 21 0   45.89838588 -91.79050449 2021-05-10 04:20:38 Washburn, Wisconsin, US
1551970 2021-05-09 US Wisconsin Walworth 55127 12286 159 0   42.66858202 -88.54163073 2021-05-10 04:20:38 Walworth, Wisconsin, US
1551969 2021-05-09 US Wisconsin Vilas 55125 2395 41 0   46.05467334 -89.51719204 2021-05-10 04:20:38 Vilas, Wisconsin, US
1551968 2021-05-09 US Wisconsin Vernon 55123 1992 42 0   43.59422667 -90.8324691 2021-05-10 04:20:38 Vernon, Wisconsin, US
1551967 2021-05-09 US Wisconsin Unassigned 90055 0 0 0   46.52868768 0.0 2021-05-10 04:20:38 Unassigned, Wisconsin, US
1551966 2021-05-09 US Wisconsin Trempealeau 55121 3643 45 0   44.30360275 -91.35893614 2021-05-10 04:20:38 Trempealeau, Wisconsin, US
1551965 2021-05-09 US Wisconsin Taylor 55119 2105 32 0   45.21179252 -90.5004405 2021-05-10 04:20:38 Taylor, Wisconsin, US
1551964 2021-05-09 US Wisconsin St. Croix 55109 9521 60 0   45.03437474 -92.45000068 2021-05-10 04:20:38 St. Croix, Wisconsin, US
1551963 2021-05-09 US Wisconsin Sheboygan 55117 14645 153 0   43.72099677 -87.94579284 2021-05-10 04:20:38 Sheboygan, Wisconsin, US
1551962 2021-05-09 US Wisconsin Shawano 55115 5275 83 0   44.78902246 -88.76443896 2021-05-10 04:20:38 Shawano, Wisconsin, US
1551961 2021-05-09 US Wisconsin Sawyer 55113 1742 26 0   45.87931905 -91.14504927 2021-05-10 04:20:38 Sawyer, Wisconsin, US
1551960 2021-05-09 US Wisconsin Sauk 55111 6100 54 0   43.42574087 -89.94966132 2021-05-10 04:20:38 Sauk, Wisconsin, US
1551959 2021-05-09 US Wisconsin Rusk 55107 1369 18 0   45.47498854 -91.1333012 2021-05-10 04:20:38 Rusk, Wisconsin, US
1551958 2021-05-09 US Wisconsin Rock 55105 17907 193 0   42.67151616 -89.07147900000002 2021-05-10 04:20:38 Rock, Wisconsin, US
1551957 2021-05-09 US Wisconsin Richland 55103 1377 15 0   43.3762778 -90.43012729 2021-05-10 04:20:38 Richland, Wisconsin, US
1551956 2021-05-09 US Wisconsin Racine 55101 24790 375 0   42.74753117 -88.05941254 2021-05-10 04:20:38 Racine, Wisconsin, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);