johns_hopkins_csse_daily_reports

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

669,915 rows sorted by day descending

✎ View and edit SQL

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

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
111905 111905 2020-09-21 Zimbabwe       7683 225 5924 1534 -19.015438 29.154857 2020-09-22 04:23:11 Zimbabwe
111904 111904 2020-09-21 Zambia       14175 331 13629 215 -13.133897 27.849332 2020-09-22 04:23:11 Zambia
111903 111903 2020-09-21 Yemen       2028 586 1235 207 15.552727 48.516388 2020-09-22 04:23:11 Yemen
111902 111902 2020-09-21 Western Sahara       10 1 8 1 24.2155 -12.8858 2020-09-22 04:23:11 Western Sahara
111901 111901 2020-09-21 West Bank and Gaza       36151 265 24428 11458 31.9522 35.2332 2020-09-22 04:23:11 West Bank and Gaza
111900 111900 2020-09-21 Vietnam       1068 35 947 86 14.058324 108.277199 2020-09-22 04:23:11 Vietnam
111899 111899 2020-09-21 Venezuela       67443 555 56726 10162 6.4238 -66.5897 2020-09-22 04:23:11 Venezuela
111898 111898 2020-09-21 Uzbekistan       52070 437 48369 3264 41.377491 64.585262 2020-09-22 04:23:11 Uzbekistan
111897 111897 2020-09-21 Uruguay       1927 46 1634 247 -32.5228 -55.7658 2020-09-22 04:23:11 Uruguay
111896 111896 2020-09-21 United Kingdom Wales     20878 1603 0 19275 52.1307 -3.7837 2020-09-22 04:23:11 Wales, United Kingdom
111895 111895 2020-09-21 United Kingdom Unknown     0 0 0 0     2020-09-22 04:23:11 Unknown, United Kingdom
111894 111894 2020-09-21 United Kingdom Turks and Caicos Islands     668 5 572 91 21.694000000000006 -71.7979 2020-09-22 04:23:11 Turks and Caicos Islands, United Kingdom
111893 111893 2020-09-21 United Kingdom Scotland     24626 2505 0 22121 56.4907 -4.2026 2020-09-22 04:23:11 Scotland, United Kingdom
111892 111892 2020-09-21 United Kingdom Northern Ireland     9466 577 0 8889 54.7877 -6.4923 2020-09-22 04:23:11 Northern Ireland, United Kingdom
111891 111891 2020-09-21 United Kingdom Montserrat     13 1 12 0 16.742498 -62.187366 2020-09-22 04:23:11 Montserrat, United Kingdom
111890 111890 2020-09-21 United Kingdom Isle of Man     340 24 312 4 54.2361 -4.5481 2020-09-22 04:23:11 Isle of Man, United Kingdom
111889 111889 2020-09-21 United Kingdom Gibraltar     350 0 323 27 36.1408 -5.3536 2020-09-22 04:23:11 Gibraltar, United Kingdom
111888 111888 2020-09-21 United Kingdom Falkland Islands (Malvinas)     13 0 13 0 -51.7963 -59.5236 2020-09-22 04:23:11 Falkland Islands (Malvinas), United Kingdom
111887 111887 2020-09-21 United Kingdom England     343655 37103 0 306552 52.3555 -1.1743 2020-09-22 04:23:11 England, United Kingdom
111886 111886 2020-09-21 United Kingdom Channel Islands     652 48 575 29 49.3723 -2.3644 2020-09-22 04:23:11 Channel Islands, United Kingdom
111885 111885 2020-09-21 United Kingdom Cayman Islands     209 1 204 4 19.3133 -81.2546 2020-09-22 04:23:11 Cayman Islands, United Kingdom
111884 111884 2020-09-21 United Kingdom British Virgin Islands     69 1 48 20 18.4207 -64.64 2020-09-22 04:23:11 British Virgin Islands, United Kingdom
111883 111883 2020-09-21 United Kingdom Bermuda     180 9 166 5 32.3078 -64.7505 2020-09-22 04:23:11 Bermuda, United Kingdom
111882 111882 2020-09-21 United Kingdom Anguilla     3 0 3 0 18.2206 -63.0686 2020-09-22 04:23:11 Anguilla, United Kingdom
111881 111881 2020-09-21 United Arab Emirates       85595 405 75086 10104 23.424076 53.847818 2020-09-22 04:23:11 United Arab Emirates
111880 111880 2020-09-21 Ukraine Zhytomyr Oblast     5059 91 2489 2479 50.2547 28.6587 2020-09-22 04:23:11 Zhytomyr Oblast, Ukraine
111879 111879 2020-09-21 Ukraine Zaporizhia Oblast     2934 42 1097 1795 47.8388 35.1396 2020-09-22 04:23:11 Zaporizhia Oblast, Ukraine
111878 111878 2020-09-21 Ukraine Zakarpattia Oblast     9189 292 4110 4787 48.6208 22.2879 2020-09-22 04:23:11 Zakarpattia Oblast, Ukraine
111877 111877 2020-09-21 Ukraine Volyn Oblast     6936 146 4807 1983 50.7472 25.3254 2020-09-22 04:23:11 Volyn Oblast, Ukraine
111876 111876 2020-09-21 Ukraine Vinnytsia Oblast     5322 101 3493 1728 49.2331 28.4682 2020-09-22 04:23:11 Vinnytsia Oblast, Ukraine
111875 111875 2020-09-21 Ukraine Ternopil Oblast     11439 139 5124 6176 49.5535 25.5948 2020-09-22 04:23:11 Ternopil Oblast, Ukraine
111874 111874 2020-09-21 Ukraine Sumy Oblast     3117 51 1315 1751 50.9077 34.7981 2020-09-22 04:23:11 Sumy Oblast, Ukraine
111873 111873 2020-09-21 Ukraine Sevastopol*     818 22 541 255 44.6054 33.522 2020-09-22 04:23:11 Sevastopol*, Ukraine
111872 111872 2020-09-21 Ukraine Rivne Oblast     11242 151 8719 2372 50.6199 26.2516 2020-09-22 04:23:11 Rivne Oblast, Ukraine
111871 111871 2020-09-21 Ukraine Poltava Oblast     1534 33 723 778 49.5883 34.5514 2020-09-22 04:23:11 Poltava Oblast, Ukraine
111870 111870 2020-09-21 Ukraine Odessa Oblast     11610 160 2427 9023 46.4846 30.7326 2020-09-22 04:23:11 Odessa Oblast, Ukraine
111869 111869 2020-09-21 Ukraine Mykolaiv Oblast     2551 63 819 1669 46.975 31.9946 2020-09-22 04:23:11 Mykolaiv Oblast, Ukraine
111868 111868 2020-09-21 Ukraine Lviv Oblast     18518 526 6114 11878 49.8397 24.0297 2020-09-22 04:23:11 Lviv Oblast, Ukraine
111867 111867 2020-09-21 Ukraine Luhansk Oblast     759 5 401 353 48.574 39.3078 2020-09-22 04:23:11 Luhansk Oblast, Ukraine
111866 111866 2020-09-21 Ukraine Kirovohrad Oblast     993 54 787 152 48.5079 32.2623 2020-09-22 04:23:11 Kirovohrad Oblast, Ukraine
111865 111865 2020-09-21 Ukraine Kiev Oblast     7880 159 4969 2752 50.053 30.7667 2020-09-22 04:23:11 Kiev Oblast, Ukraine
111864 111864 2020-09-21 Ukraine Kiev     19758 318 5868 13572 50.4501 30.5234 2020-09-22 04:23:11 Kiev, Ukraine
111863 111863 2020-09-21 Ukraine Khmelnytskyi Oblast     4823 93 2060 2670 49.423 26.9871 2020-09-22 04:23:11 Khmelnytskyi Oblast, Ukraine
111862 111862 2020-09-21 Ukraine Kherson Oblast     818 20 442 356 46.6354 32.6169 2020-09-22 04:23:11 Kherson Oblast, Ukraine
111861 111861 2020-09-21 Ukraine Kharkiv Oblast     15133 301 4248 10584 49.9935 36.2304 2020-09-22 04:23:11 Kharkiv Oblast, Ukraine
111860 111860 2020-09-21 Ukraine Ivano-Frankivsk Oblast     12538 280 5406 6852 48.9226 24.7111 2020-09-22 04:23:11 Ivano-Frankivsk Oblast, Ukraine
111859 111859 2020-09-21 Ukraine Donetsk Oblast     2480 43 998 1439 48.0159 37.8028 2020-09-22 04:23:11 Donetsk Oblast, Ukraine
111858 111858 2020-09-21 Ukraine Dnipropetrovsk Oblast     4118 89 2018 2011 48.4647 35.0462 2020-09-22 04:23:11 Dnipropetrovsk Oblast, Ukraine
111857 111857 2020-09-21 Ukraine Crimea Republic*     3729 47 2406 1276 45.2835 34.2008 2020-09-22 04:23:11 Crimea Republic*, Ukraine
111856 111856 2020-09-21 Ukraine Chernivtsi Oblast     13165 332 7605 5228 48.2917 25.9352 2020-09-22 04:23:11 Chernivtsi Oblast, Ukraine
111855 111855 2020-09-21 Ukraine Chernihiv Oblast     3341 46 738 2557 51.4982 31.2893 2020-09-22 04:23:11 Chernihiv Oblast, Ukraine
111854 111854 2020-09-21 Ukraine Cherkasy Oblast     3096 48 1407 1641 49.4444 32.0598 2020-09-22 04:23:11 Cherkasy Oblast, Ukraine
111853 111853 2020-09-21 Uganda       6468 63 2731 3674 1.373333 32.290275 2020-09-22 04:23:11 Uganda
111852 111852 2020-09-21 US Wyoming Weston 56045 23 0 0 23 43.83961191 -104.5674881 2020-09-22 04:23:11 Weston, Wyoming, US
111851 111851 2020-09-21 US Wyoming Washakie 56043 113 6 0 107 43.90451606 -107.68018700000002 2020-09-22 04:23:11 Washakie, Wyoming, US
111850 111850 2020-09-21 US Wyoming Unassigned 90056 0 0 0 0 44.79048913 -110.6563997 2020-09-22 04:23:11 Unassigned, Wyoming, US
111849 111849 2020-09-21 US Wyoming Uinta 56041 335 2 0 333 41.2878183 -110.54757820000002 2020-09-22 04:23:11 Uinta, Wyoming, US
111848 111848 2020-09-21 US Wyoming Teton 56039 504 1 0 503 43.93522482 -110.5890801 2020-09-22 04:23:11 Teton, Wyoming, US
111847 111847 2020-09-21 US Wyoming Sweetwater 56037 323 2 0 321 41.65943896 -108.8827882 2020-09-22 04:23:11 Sweetwater, Wyoming, US
111846 111846 2020-09-21 US Wyoming Sublette 56035 71 1 0 70 42.76558279 -109.9130922 2020-09-22 04:23:11 Sublette, Wyoming, US
111845 111845 2020-09-21 US Wyoming Sheridan 56033 253 4 0 249 44.79048913 -106.8862389 2020-09-22 04:23:11 Sheridan, Wyoming, US
111844 111844 2020-09-21 US Wyoming Platte 56031 20 1 0 19 42.13299116 -104.966331 2020-09-22 04:23:11 Platte, Wyoming, US
111843 111843 2020-09-21 US Wyoming Park 56029 205 2 0 203 44.52157546 -109.5852825 2020-09-22 04:23:11 Park, Wyoming, US
111842 111842 2020-09-21 US Wyoming Niobrara 56027 3 0 0 3 43.05607708 -104.4758896 2020-09-22 04:23:11 Niobrara, Wyoming, US
111841 111841 2020-09-21 US Wyoming Natrona 56025 451 4 0 447 42.96180148 -106.797885 2020-09-22 04:23:11 Natrona, Wyoming, US
111840 111840 2020-09-21 US Wyoming Lincoln 56023 142 1 0 141 42.26376367 -110.6563997 2020-09-22 04:23:11 Lincoln, Wyoming, US
111839 111839 2020-09-21 US Wyoming Laramie 56021 652 4 0 648 41.30702520000001 -104.6887497 2020-09-22 04:23:11 Laramie, Wyoming, US
111838 111838 2020-09-21 US Wyoming Johnson 56019 30 1 0 29 44.04057166 -106.5845174 2020-09-22 04:23:11 Johnson, Wyoming, US
111837 111837 2020-09-21 US Wyoming Hot Springs 56017 37 0 0 37 43.71930657 -108.4423174 2020-09-22 04:23:11 Hot Springs, Wyoming, US
111836 111836 2020-09-21 US Wyoming Goshen 56015 80 2 0 78 42.08798185 -104.3534743 2020-09-22 04:23:11 Goshen, Wyoming, US
111835 111835 2020-09-21 US Wyoming Fremont 56013 666 14 0 652 43.04183996 -108.6296893 2020-09-22 04:23:11 Fremont, Wyoming, US
111834 111834 2020-09-21 US Wyoming Crook 56011 34 0 0 34 44.58855102 -104.5697705 2020-09-22 04:23:11 Crook, Wyoming, US
111833 111833 2020-09-21 US Wyoming Converse 56009 100 0 0 100 42.97272268 -105.5081848 2020-09-22 04:23:11 Converse, Wyoming, US
111832 111832 2020-09-21 US Wyoming Carbon 56007 216 2 0 214 41.69357844 -106.9326084 2020-09-22 04:23:11 Carbon, Wyoming, US
111831 111831 2020-09-21 US Wyoming Campbell 56005 250 1 0 249 44.24886082 -105.5474404 2020-09-22 04:23:11 Campbell, Wyoming, US
111830 111830 2020-09-21 US Wyoming Big Horn 56003 51 1 0 50 44.52405055 -107.9960365 2020-09-22 04:23:11 Big Horn, Wyoming, US
111829 111829 2020-09-21 US Wyoming Albany 56001 385 0 0 385 41.65498705 -105.7235415 2020-09-22 04:23:11 Albany, Wyoming, US
111828 111828 2020-09-21 US Wisconsin Wood 55141 692 4 0 688 44.45537896 -90.04158336 2020-09-22 04:23:11 Wood, Wisconsin, US
111827 111827 2020-09-21 US Wisconsin Winnebago 55139 2822 23 0 2799 44.06886922 -88.64477096 2020-09-22 04:23:11 Winnebago, Wisconsin, US
111826 111826 2020-09-21 US Wisconsin Waushara 55137 275 2 0 273 44.11324419 -89.24317107 2020-09-22 04:23:11 Waushara, Wisconsin, US
111825 111825 2020-09-21 US Wisconsin Waupaca 55135 920 20 0 900 44.47068056 -88.96534501 2020-09-22 04:23:11 Waupaca, Wisconsin, US
111824 111824 2020-09-21 US Wisconsin Waukesha 55133 6664 85 0 6579 43.01833055 -88.30431188 2020-09-22 04:23:11 Waukesha, Wisconsin, US
111823 111823 2020-09-21 US Wisconsin Washington 55131 2268 32 0 2236 43.36863664 -88.22974712 2020-09-22 04:23:11 Washington, Wisconsin, US
111822 111822 2020-09-21 US Wisconsin Washburn 55129 92 1 0 91 45.89838588 -91.79050449 2020-09-22 04:23:11 Washburn, Wisconsin, US
111821 111821 2020-09-21 US Wisconsin Walworth 55127 2458 34 0 2424 42.66858202 -88.54163073 2020-09-22 04:23:11 Walworth, Wisconsin, US
111820 111820 2020-09-21 US Wisconsin Vilas 55125 172 1 0 171 46.05467334 -89.51719204 2020-09-22 04:23:11 Vilas, Wisconsin, US
111819 111819 2020-09-21 US Wisconsin Vernon 55123 180 0 0 180 43.59422667 -90.8324691 2020-09-22 04:23:11 Vernon, Wisconsin, US
111818 111818 2020-09-21 US Wisconsin Unassigned 90055 0 0 0 0 46.52868768 0.0 2020-09-22 04:23:11 Unassigned, Wisconsin, US
111817 111817 2020-09-21 US Wisconsin Trempealeau 55121 536 2 0 534 44.30360275 -91.35893614 2020-09-22 04:23:11 Trempealeau, Wisconsin, US
111816 111816 2020-09-21 US Wisconsin Taylor 55119 151 3 0 148 45.21179252 -90.5004405 2020-09-22 04:23:11 Taylor, Wisconsin, US
111815 111815 2020-09-21 US Wisconsin St. Croix 55109 833 8 0 825 45.03437474 -92.45000068 2020-09-22 04:23:11 St. Croix, Wisconsin, US
111814 111814 2020-09-21 US Wisconsin Sheboygan 55117 1454 14 0 1440 43.72099677 -87.94579284 2020-09-22 04:23:11 Sheboygan, Wisconsin, US
111813 111813 2020-09-21 US Wisconsin Shawano 55115 588 1 0 587 44.78902246 -88.76443896 2020-09-22 04:23:11 Shawano, Wisconsin, US
111812 111812 2020-09-21 US Wisconsin Sawyer 55113 195 1 0 194 45.87931905 -91.14504927 2020-09-22 04:23:11 Sawyer, Wisconsin, US
111811 111811 2020-09-21 US Wisconsin Sauk 55111 806 3 0 803 43.42574087 -89.94966132 2020-09-22 04:23:11 Sauk, Wisconsin, US
111810 111810 2020-09-21 US Wisconsin Rusk 55107 50 1 0 49 45.47498854 -91.1333012 2020-09-22 04:23:11 Rusk, Wisconsin, US
111809 111809 2020-09-21 US Wisconsin Rock 55105 2268 32 0 2236 42.67151616 -89.07147900000002 2020-09-22 04:23:11 Rock, Wisconsin, US
111808 111808 2020-09-21 US Wisconsin Richland 55103 92 4 0 88 43.3762778 -90.43012729 2020-09-22 04:23:11 Richland, Wisconsin, US
111807 111807 2020-09-21 US Wisconsin Racine 55101 4512 94 0 4418 42.74753117 -88.05941254 2020-09-22 04:23:11 Racine, Wisconsin, US
111806 111806 2020-09-21 US Wisconsin Price 55099 51 0 0 51 45.68051754 -90.3609888 2020-09-22 04:23:11 Price, 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] INTEGER,
   [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]);
Powered by Datasette · Query took 3955.945ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette