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

693,645 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
595052 595052 2020-09-27 Zimbabwe       7812 227 6106 1479 -19.015438 29.154857 9/28/20 4:23 Zimbabwe
595051 595051 2020-09-27 Zambia       14641 332 13784 525 -13.133897 27.849332 9/28/20 4:23 Zambia
595050 595050 2020-09-27 Yemen       2030 587 1266 177 15.552727 48.516388 9/28/20 4:23 Yemen
595049 595049 2020-09-27 Western Sahara       10 1 8 1 24.2155 -12.8858 9/28/20 4:23 Western Sahara
595048 595048 2020-09-27 West Bank and Gaza       38703 291 29068 9344 31.9522 35.2332 9/28/20 4:23 West Bank and Gaza
595047 595047 2020-09-27 Vietnam       1074 35 999 40 14.058324 108.277199 9/28/20 4:23 Vietnam
595046 595046 2020-09-27 Venezuela       72691 606 62427 9658 6.4238 -66.5897 9/28/20 4:23 Venezuela
595045 595045 2020-09-27 Uzbekistan       55320 458 51829 3033 41.377491 64.585262 9/28/20 4:23 Uzbekistan
595044 595044 2020-09-27 Uruguay       2008 47 1728 233 -32.5228 -55.7658 9/28/20 4:23 Uruguay
595043 595043 2020-09-27 United Kingdom Wales     22945 1612 0 21333 52.1307 -3.7837 9/28/20 4:23 Wales, United Kingdom
595042 595042 2020-09-27 United Kingdom Unknown     0 0 0 0     9/28/20 4:23 Unknown, United Kingdom
595041 595041 2020-09-27 United Kingdom Turks and Caicos Islands     682 5 620 57 21.694 -71.7979 9/28/20 4:23 Turks and Caicos Islands, United Kingdom
595040 595040 2020-09-27 United Kingdom Scotland     27576 2512 0 25064 56.4907 -4.2026 9/28/20 4:23 Scotland, United Kingdom
595039 595039 2020-09-27 United Kingdom Northern Ireland     10729 578 0 10151 54.7877 -6.4923 9/28/20 4:23 Northern Ireland, United Kingdom
595038 595038 2020-09-27 United Kingdom Montserrat     13 1 12 0 16.742498 -62.187366 9/28/20 4:23 Montserrat, United Kingdom
595037 595037 2020-09-27 United Kingdom Isle of Man     340 24 314 2 54.2361 -4.5481 9/28/20 4:23 Isle of Man, United Kingdom
595036 595036 2020-09-27 United Kingdom Gibraltar     379 0 341 38 36.1408 -5.3536 9/28/20 4:23 Gibraltar, United Kingdom
595035 595035 2020-09-27 United Kingdom Falkland Islands (Malvinas)     13 0 13 0 -51.7963 -59.5236 9/28/20 4:23 Falkland Islands (Malvinas), United Kingdom
595034 595034 2020-09-27 United Kingdom England     373719 37286 0 336433 52.3555 -1.1743 9/28/20 4:23 England, United Kingdom
595033 595033 2020-09-27 United Kingdom Channel Islands     656 48 600 8 49.3723 -2.3644 9/28/20 4:23 Channel Islands, United Kingdom
595032 595032 2020-09-27 United Kingdom Cayman Islands     210 1 207 2 19.3133 -81.2546 9/28/20 4:23 Cayman Islands, United Kingdom
595031 595031 2020-09-27 United Kingdom British Virgin Islands     71 1 62 8 18.4207 -64.64 9/28/20 4:23 British Virgin Islands, United Kingdom
595030 595030 2020-09-27 United Kingdom Bermuda     181 9 167 5 32.3078 -64.7505 9/28/20 4:23 Bermuda, United Kingdom
595029 595029 2020-09-27 United Kingdom Anguilla     3 0 3 0 18.2206 -63.0686 9/28/20 4:23 Anguilla, United Kingdom
595028 595028 2020-09-27 United Arab Emirates       91469 412 80544 10513 23.424076 53.847818 9/28/20 4:23 United Arab Emirates
595027 595027 2020-09-27 Ukraine Zhytomyr Oblast     5656 103 3162 2391 50.2547 28.6587 9/28/20 4:23 Zhytomyr Oblast, Ukraine
595026 595026 2020-09-27 Ukraine Zaporizhia Oblast     3663 58 1223 2382 47.8388 35.1396 9/28/20 4:23 Zaporizhia Oblast, Ukraine
595025 595025 2020-09-27 Ukraine Zakarpattia Oblast     9632 303 4484 4845 48.6208 22.2879 9/28/20 4:23 Zakarpattia Oblast, Ukraine
595024 595024 2020-09-27 Ukraine Volyn Oblast     7632 162 5100 2370 50.7472 25.3254 9/28/20 4:23 Volyn Oblast, Ukraine
595023 595023 2020-09-27 Ukraine Vinnytsia Oblast     5900 113 3778 2009 49.2331 28.4682 9/28/20 4:23 Vinnytsia Oblast, Ukraine
595022 595022 2020-09-27 Ukraine Ternopil Oblast     12986 157 6960 5869 49.5535 25.5948 9/28/20 4:23 Ternopil Oblast, Ukraine
595021 595021 2020-09-27 Ukraine Sumy Oblast     3672 63 1614 1995 50.9077 34.7981 9/28/20 4:23 Sumy Oblast, Ukraine
595020 595020 2020-09-27 Ukraine Sevastopol*     946 26 605 315 44.6054 33.522 9/28/20 4:23 Sevastopol*, Ukraine
595019 595019 2020-09-27 Ukraine Rivne Oblast     12032 161 9603 2268 50.6199 26.2516 9/28/20 4:23 Rivne Oblast, Ukraine
595018 595018 2020-09-27 Ukraine Poltava Oblast     1910 36 954 920 49.5883 34.5514 9/28/20 4:23 Poltava Oblast, Ukraine
595017 595017 2020-09-27 Ukraine Odessa Oblast     12876 187 2520 10169 46.4846 30.7326 9/28/20 4:23 Odessa Oblast, Ukraine
595016 595016 2020-09-27 Ukraine Mykolaiv Oblast     2980 73 986 1921 46.975 31.9946 9/28/20 4:23 Mykolaiv Oblast, Ukraine
595015 595015 2020-09-27 Ukraine Lviv Oblast     19784 555 6625 12604 49.8397 24.0297 9/28/20 4:23 Lviv Oblast, Ukraine
595014 595014 2020-09-27 Ukraine Luhansk Oblast     974 11 516 447 48.574 39.3078 9/28/20 4:23 Luhansk Oblast, Ukraine
595013 595013 2020-09-27 Ukraine Kirovohrad Oblast     1074 56 844 174 48.5079 32.2623 9/28/20 4:23 Kirovohrad Oblast, Ukraine
595012 595012 2020-09-27 Ukraine Kiev Oblast     8714 172 5346 3196 50.053 30.7667 9/28/20 4:23 Kiev Oblast, Ukraine
595011 595011 2020-09-27 Ukraine Kiev     21815 361 6482 14972 50.4501 30.5234 9/28/20 4:23 Kiev, Ukraine
595010 595010 2020-09-27 Ukraine Khmelnytskyi Oblast     5622 103 2351 3168 49.423 26.9871 9/28/20 4:23 Khmelnytskyi Oblast, Ukraine
595009 595009 2020-09-27 Ukraine Kherson Oblast     1049 23 559 467 46.6354 32.6169 9/28/20 4:23 Kherson Oblast, Ukraine
595008 595008 2020-09-27 Ukraine Kharkiv Oblast     17364 331 4325 12708 49.9935 36.2304 9/28/20 4:23 Kharkiv Oblast, Ukraine
595007 595007 2020-09-27 Ukraine Ivano-Frankivsk Oblast     13335 303 6194 6838 48.9226 24.7111 9/28/20 4:23 Ivano-Frankivsk Oblast, Ukraine
595006 595006 2020-09-27 Ukraine Donetsk Oblast     3016 56 1076 1884 48.0159 37.8028 9/28/20 4:23 Donetsk Oblast, Ukraine
595005 595005 2020-09-27 Ukraine Dnipropetrovsk Oblast     5285 106 2782 2397 48.4647 35.0462 9/28/20 4:23 Dnipropetrovsk Oblast, Ukraine
595004 595004 2020-09-27 Ukraine Crimea Republic*     4219 59 2692 1468 45.2835 34.2008 9/28/20 4:23 Crimea Republic*, Ukraine
595003 595003 2020-09-27 Ukraine Chernivtsi Oblast     14009 352 7959 5698 48.2917 25.9352 9/28/20 4:23 Chernivtsi Oblast, Ukraine
595002 595002 2020-09-27 Ukraine Chernihiv Oblast     3960 61 841 3058 51.4982 31.2893 9/28/20 4:23 Chernihiv Oblast, Ukraine
595001 595001 2020-09-27 Ukraine Cherkasy Oblast     3694 53 1598 2043 49.4444 32.0598 9/28/20 4:23 Cherkasy Oblast, Ukraine
595000 595000 2020-09-27 Uganda       7530 73 3647 3810 1.373333 32.290275 9/28/20 4:23 Uganda
594999 594999 2020-09-27 US Wyoming Weston 56045 36 0 0 36 43.83961191 -104.5674881 9/28/20 4:23 Weston, Wyoming, US
594998 594998 2020-09-27 US Wyoming Washakie 56043 115 6 0 109 43.90451606 -107.680187 9/28/20 4:23 Washakie, Wyoming, US
594997 594997 2020-09-27 US Wyoming Unassigned 90056 0 0 0 0 44.79048913 -110.6563997 9/28/20 4:23 Unassigned, Wyoming, US
594996 594996 2020-09-27 US Wyoming Uinta 56041 352 2 0 350 41.2878183 -110.5475782 9/28/20 4:23 Uinta, Wyoming, US
594995 594995 2020-09-27 US Wyoming Teton 56039 554 1 0 553 43.93522482 -110.5890801 9/28/20 4:23 Teton, Wyoming, US
594994 594994 2020-09-27 US Wyoming Sweetwater 56037 335 2 0 333 41.65943896 -108.8827882 9/28/20 4:23 Sweetwater, Wyoming, US
594993 594993 2020-09-27 US Wyoming Sublette 56035 97 1 0 96 42.76558279 -109.9130922 9/28/20 4:23 Sublette, Wyoming, US
594992 594992 2020-09-27 US Wyoming Sheridan 56033 289 4 0 285 44.79048913 -106.8862389 9/28/20 4:23 Sheridan, Wyoming, US
594991 594991 2020-09-27 US Wyoming Platte 56031 28 1 0 27 42.13299116 -104.966331 9/28/20 4:23 Platte, Wyoming, US
594990 594990 2020-09-27 US Wyoming Park 56029 236 2 0 234 44.52157546 -109.5852825 9/28/20 4:23 Park, Wyoming, US
594989 594989 2020-09-27 US Wyoming Niobrara 56027 4 0 0 4 43.05607708 -104.4758896 9/28/20 4:23 Niobrara, Wyoming, US
594988 594988 2020-09-27 US Wyoming Natrona 56025 559 4 0 555 42.96180148 -106.797885 9/28/20 4:23 Natrona, Wyoming, US
594987 594987 2020-09-27 US Wyoming Lincoln 56023 177 1 0 176 42.26376367 -110.6563997 9/28/20 4:23 Lincoln, Wyoming, US
594986 594986 2020-09-27 US Wyoming Laramie 56021 695 4 0 691 41.3070252 -104.6887497 9/28/20 4:23 Laramie, Wyoming, US
594985 594985 2020-09-27 US Wyoming Johnson 56019 36 1 0 35 44.04057166 -106.5845174 9/28/20 4:23 Johnson, Wyoming, US
594984 594984 2020-09-27 US Wyoming Hot Springs 56017 38 0 0 38 43.71930657 -108.4423174 9/28/20 4:23 Hot Springs, Wyoming, US
594983 594983 2020-09-27 US Wyoming Goshen 56015 98 2 0 96 42.08798185 -104.3534743 9/28/20 4:23 Goshen, Wyoming, US
594982 594982 2020-09-27 US Wyoming Fremont 56013 716 14 0 702 43.04183996 -108.6296893 9/28/20 4:23 Fremont, Wyoming, US
594981 594981 2020-09-27 US Wyoming Crook 56011 44 0 0 44 44.58855102 -104.5697705 9/28/20 4:23 Crook, Wyoming, US
594980 594980 2020-09-27 US Wyoming Converse 56009 115 0 0 115 42.97272268 -105.5081848 9/28/20 4:23 Converse, Wyoming, US
594979 594979 2020-09-27 US Wyoming Carbon 56007 228 2 0 226 41.69357844 -106.9326084 9/28/20 4:23 Carbon, Wyoming, US
594978 594978 2020-09-27 US Wyoming Campbell 56005 303 1 0 302 44.24886082 -105.5474404 9/28/20 4:23 Campbell, Wyoming, US
594977 594977 2020-09-27 US Wyoming Big Horn 56003 58 2 0 56 44.52405055 -107.9960365 9/28/20 4:23 Big Horn, Wyoming, US
594976 594976 2020-09-27 US Wyoming Albany 56001 520 0 0 520 41.65498705 -105.7235415 9/28/20 4:23 Albany, Wyoming, US
594975 594975 2020-09-27 US Wisconsin Wood 55141 826 5 0 821 44.45537896 -90.04158336 9/28/20 4:23 Wood, Wisconsin, US
594974 594974 2020-09-27 US Wisconsin Winnebago 55139 3681 26 0 3655 44.06886922 -88.64477096 9/28/20 4:23 Winnebago, Wisconsin, US
594973 594973 2020-09-27 US Wisconsin Waushara 55137 348 2 0 346 44.11324419 -89.24317107 9/28/20 4:23 Waushara, Wisconsin, US
594972 594972 2020-09-27 US Wisconsin Waupaca 55135 1043 20 0 1023 44.47068056 -88.96534501 9/28/20 4:23 Waupaca, Wisconsin, US
594971 594971 2020-09-27 US Wisconsin Waukesha 55133 7362 87 0 7275 43.01833055 -88.30431188 9/28/20 4:23 Waukesha, Wisconsin, US
594970 594970 2020-09-27 US Wisconsin Washington 55131 2604 32 0 2572 43.36863664 -88.22974712 9/28/20 4:23 Washington, Wisconsin, US
594969 594969 2020-09-27 US Wisconsin Washburn 55129 102 1 0 101 45.89838588 -91.79050449 9/28/20 4:23 Washburn, Wisconsin, US
594968 594968 2020-09-27 US Wisconsin Walworth 55127 2584 35 0 2549 42.66858202 -88.54163073 9/28/20 4:23 Walworth, Wisconsin, US
594967 594967 2020-09-27 US Wisconsin Vilas 55125 212 1 0 211 46.05467334 -89.51719204 9/28/20 4:23 Vilas, Wisconsin, US
594966 594966 2020-09-27 US Wisconsin Vernon 55123 228 0 0 228 43.59422667 -90.8324691 9/28/20 4:23 Vernon, Wisconsin, US
594965 594965 2020-09-27 US Wisconsin Unassigned 90055 0 0 0 0 46.52868768 0.0 9/28/20 4:23 Unassigned, Wisconsin, US
594964 594964 2020-09-27 US Wisconsin Trempealeau 55121 630 2 0 628 44.30360275 -91.35893614 9/28/20 4:23 Trempealeau, Wisconsin, US
594963 594963 2020-09-27 US Wisconsin Taylor 55119 184 4 0 180 45.21179252 -90.5004405 9/28/20 4:23 Taylor, Wisconsin, US
594962 594962 2020-09-27 US Wisconsin St. Croix 55109 914 8 0 906 45.03437474 -92.45000068 9/28/20 4:23 St. Croix, Wisconsin, US
594961 594961 2020-09-27 US Wisconsin Sheboygan 55117 1578 16 0 1562 43.72099677 -87.94579284 9/28/20 4:23 Sheboygan, Wisconsin, US
594960 594960 2020-09-27 US Wisconsin Shawano 55115 864 1 0 863 44.78902246 -88.76443896 9/28/20 4:23 Shawano, Wisconsin, US
594959 594959 2020-09-27 US Wisconsin Sawyer 55113 211 1 0 210 45.87931905 -91.14504927 9/28/20 4:23 Sawyer, Wisconsin, US
594958 594958 2020-09-27 US Wisconsin Sauk 55111 902 3 0 899 43.42574087 -89.94966132 9/28/20 4:23 Sauk, Wisconsin, US
594957 594957 2020-09-27 US Wisconsin Rusk 55107 61 1 0 60 45.47498854 -91.1333012 9/28/20 4:23 Rusk, Wisconsin, US
594956 594956 2020-09-27 US Wisconsin Rock 55105 2540 32 0 2508 42.67151616 -89.071479 9/28/20 4:23 Rock, Wisconsin, US
594955 594955 2020-09-27 US Wisconsin Richland 55103 134 4 0 130 43.3762778 -90.43012729 9/28/20 4:23 Richland, Wisconsin, US
594954 594954 2020-09-27 US Wisconsin Racine 55101 4857 95 0 4762 42.74753117 -88.05941254 9/28/20 4:23 Racine, Wisconsin, US
594953 594953 2020-09-27 US Wisconsin Price 55099 107 0 0 107 45.68051754 -90.3609888 9/28/20 4:23 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 3862.887ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette