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

511,855 rows sorted by day descending

View and edit SQL

Suggested facets: day (date)

These facets timed out: last_update

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
137702 2020-08-12 Zimbabwe       4893 122 1620 3151 -19.015438 29.154857 2020-08-13 04:29:15 Zimbabwe
137701 2020-08-12 Zambia       8501 246 7233 1022 -13.133897 27.849332 2020-08-13 04:29:15 Zambia
137700 2020-08-12 Yemen       1841 528 937 376 15.552727 48.516388 2020-08-13 04:29:15 Yemen
137699 2020-08-12 Western Sahara       10 1 8 1 24.2155 -12.8858 2020-08-13 04:29:15 Western Sahara
137698 2020-08-12 West Bank and Gaza       15184 105 8369 6710 31.9522 35.2332 2020-08-13 04:29:15 West Bank and Gaza
137697 2020-08-12 Vietnam       883 18 409 456 14.058324 108.277199 2020-08-13 04:29:15 Vietnam
137696 2020-08-12 Venezuela       29088 247 21042 7799 6.4238 -66.5897 2020-08-13 04:29:15 Venezuela
137695 2020-08-12 Uzbekistan       32654 211 25659 6784 41.377491 64.585262 2020-08-13 04:29:15 Uzbekistan
137694 2020-08-12 Uruguay       1393 37 1163 193 -32.5228 -55.7658 2020-08-13 04:29:15 Uruguay
137693 2020-08-12 United Kingdom Wales     17484 1586 0 15898 52.1307 -3.7837 2020-08-13 04:29:15 Wales, United Kingdom
137692 2020-08-12 United Kingdom Unknown     0 0 0 0     2020-08-13 04:29:15 Unknown, United Kingdom
137691 2020-08-12 United Kingdom Turks and Caicos Islands     241 2 46 193 21.694000000000006 -71.7979 2020-08-13 04:29:15 Turks and Caicos Islands, United Kingdom
137690 2020-08-12 United Kingdom Scotland     19126 2491 0 16635 56.4907 -4.2026 2020-08-13 04:29:15 Scotland, United Kingdom
137689 2020-08-12 United Kingdom Northern Ireland     6217 557 0 5660 54.7877 -6.4923 2020-08-13 04:29:15 Northern Ireland, United Kingdom
137688 2020-08-12 United Kingdom Montserrat     13 1 12 0 16.742498 -62.187366 2020-08-13 04:29:15 Montserrat, United Kingdom
137687 2020-08-12 United Kingdom Isle of Man     336 24 312 0 54.2361 -4.5481 2020-08-13 04:29:15 Isle of Man, United Kingdom
137686 2020-08-12 United Kingdom Gibraltar     203 0 187 16 36.1408 -5.3536 2020-08-13 04:29:15 Gibraltar, United Kingdom
137685 2020-08-12 United Kingdom Falkland Islands (Malvinas)     13 0 13 0 -51.7963 -59.5236 2020-08-13 04:29:15 Falkland Islands (Malvinas), United Kingdom
137684 2020-08-12 United Kingdom England     270971 42072 0 228899 52.3555 -1.1743 2020-08-13 04:29:15 England, United Kingdom
137683 2020-08-12 United Kingdom Channel Islands     603 47 545 11 49.3723 -2.3644 2020-08-13 04:29:15 Channel Islands, United Kingdom
137682 2020-08-12 United Kingdom Cayman Islands     203 1 202 0 19.3133 -81.2546 2020-08-13 04:29:15 Cayman Islands, United Kingdom
137681 2020-08-12 United Kingdom British Virgin Islands     9 1 7 1 18.4207 -64.64 2020-08-13 04:29:15 British Virgin Islands, United Kingdom
137680 2020-08-12 United Kingdom Bermuda     159 9 145 5 32.3078 -64.7505 2020-08-13 04:29:15 Bermuda, United Kingdom
137679 2020-08-12 United Kingdom Anguilla     3 0 3 0 18.2206 -63.0686 2020-08-13 04:29:15 Anguilla, United Kingdom
137678 2020-08-12 United Arab Emirates       63212 358 57193 5661 23.424076 53.847818 2020-08-13 04:29:15 United Arab Emirates
137677 2020-08-12 Ukraine Zhytomyr Oblast     2215 48 1574 593 50.2547 28.6587 2020-08-13 04:29:15 Zhytomyr Oblast, Ukraine
137676 2020-08-12 Ukraine Zaporizhia Oblast     971 22 680 269 47.8388 35.1396 2020-08-13 04:29:15 Zaporizhia Oblast, Ukraine
137675 2020-08-12 Ukraine Zakarpattia Oblast     5946 226 2563 3157 48.6208 22.2879 2020-08-13 04:29:15 Zakarpattia Oblast, Ukraine
137674 2020-08-12 Ukraine Volyn Oblast     4423 95 3260 1068 50.7472 25.3254 2020-08-13 04:29:15 Volyn Oblast, Ukraine
137673 2020-08-12 Ukraine Vinnytsia Oblast     3043 63 2303 677 49.2331 28.4682 2020-08-13 04:29:15 Vinnytsia Oblast, Ukraine
137672 2020-08-12 Ukraine Ternopil Oblast     3413 44 2255 1114 49.5535 25.5948 2020-08-13 04:29:15 Ternopil Oblast, Ukraine
137671 2020-08-12 Ukraine Sumy Oblast     716 10 426 280 50.9077 34.7981 2020-08-13 04:29:15 Sumy Oblast, Ukraine
137670 2020-08-12 Ukraine Sevastopol*     399 11 321 67 44.6054 33.522 2020-08-13 04:29:15 Sevastopol*, Ukraine
137669 2020-08-12 Ukraine Rivne Oblast     7114 106 5407 1601 50.6199 26.2516 2020-08-13 04:29:15 Rivne Oblast, Ukraine
137668 2020-08-12 Ukraine Poltava Oblast     514 15 372 127 49.5883 34.5514 2020-08-13 04:29:15 Poltava Oblast, Ukraine
137667 2020-08-12 Ukraine Odessa Oblast     4458 73 1463 2922 46.4846 30.7326 2020-08-13 04:29:15 Odessa Oblast, Ukraine
137666 2020-08-12 Ukraine Mykolaiv Oblast     744 18 493 233 46.975 31.9946 2020-08-13 04:29:15 Mykolaiv Oblast, Ukraine
137665 2020-08-12 Ukraine Lviv Oblast     11308 310 3040 7958 49.8397 24.0297 2020-08-13 04:29:15 Lviv Oblast, Ukraine
137664 2020-08-12 Ukraine Luhansk Oblast     160 1 117 42 48.574 39.3078 2020-08-13 04:29:15 Luhansk Oblast, Ukraine
137663 2020-08-12 Ukraine Kirovohrad Oblast     728 39 655 34 48.5079 32.2623 2020-08-13 04:29:15 Kirovohrad Oblast, Ukraine
137662 2020-08-12 Ukraine Kiev Oblast     4307 71 3021 1215 50.053 30.7667 2020-08-13 04:29:15 Kiev Oblast, Ukraine
137661 2020-08-12 Ukraine Kiev     9869 147 3278 6444 50.4501 30.5234 2020-08-13 04:29:15 Kiev, Ukraine
137660 2020-08-12 Ukraine Khmelnytskyi Oblast     1413 31 1045 337 49.423 26.9871 2020-08-13 04:29:15 Khmelnytskyi Oblast, Ukraine
137659 2020-08-12 Ukraine Kherson Oblast     276 5 213 58 46.6354 32.6169 2020-08-13 04:29:15 Kherson Oblast, Ukraine
137658 2020-08-12 Ukraine Kharkiv Oblast     5169 150 2552 2467 49.9935 36.2304 2020-08-13 04:29:15 Kharkiv Oblast, Ukraine
137657 2020-08-12 Ukraine Ivano-Frankivsk Oblast     6039 160 2372 3507 48.9226 24.7111 2020-08-13 04:29:15 Ivano-Frankivsk Oblast, Ukraine
137656 2020-08-12 Ukraine Donetsk Oblast     1011 13 780 218 48.0159 37.8028 2020-08-13 04:29:15 Donetsk Oblast, Ukraine
137655 2020-08-12 Ukraine Dnipropetrovsk Oblast     1602 36 1152 414 48.4647 35.0462 2020-08-13 04:29:15 Dnipropetrovsk Oblast, Ukraine
137654 2020-08-12 Ukraine Crimea Republic*     1557 18 1077 462 45.2835 34.2008 2020-08-13 04:29:15 Crimea Republic*, Ukraine
137653 2020-08-12 Ukraine Chernivtsi Oblast     6980 232 5312 1436 48.2917 25.9352 2020-08-13 04:29:15 Chernivtsi Oblast, Ukraine
137652 2020-08-12 Ukraine Chernihiv Oblast     1080 18 564 498 51.4982 31.2893 2020-08-13 04:29:15 Chernihiv Oblast, Ukraine
137651 2020-08-12 Ukraine Cherkasy Oblast     1049 37 789 223 49.4444 32.0598 2020-08-13 04:29:15 Cherkasy Oblast, Ukraine
137650 2020-08-12 Uganda       1332 9 1139 184 1.373333 32.290275 2020-08-13 04:29:15 Uganda
137649 2020-08-12 US Wyoming Weston 56045 5 0 0 5 43.83961191 -104.5674881 2020-08-13 04:29:15 Weston, Wyoming, US
137648 2020-08-12 US Wyoming Washakie 56043 82 0 0 82 43.90451606 -107.68018700000002 2020-08-13 04:29:15 Washakie, Wyoming, US
137647 2020-08-12 US Wyoming Unassigned 90056 0 28 0 -28 44.79048913 -110.6563997 2020-08-13 04:29:15 Unassigned, Wyoming, US
137646 2020-08-12 US Wyoming Uinta 56041 278 0 0 278 41.2878183 -110.54757820000002 2020-08-13 04:29:15 Uinta, Wyoming, US
137645 2020-08-12 US Wyoming Teton 56039 373 0 0 373 43.93522482 -110.5890801 2020-08-13 04:29:15 Teton, Wyoming, US
137644 2020-08-12 US Wyoming Sweetwater 56037 266 0 0 266 41.65943896 -108.8827882 2020-08-13 04:29:15 Sweetwater, Wyoming, US
137643 2020-08-12 US Wyoming Sublette 56035 40 0 0 40 42.76558279 -109.9130922 2020-08-13 04:29:15 Sublette, Wyoming, US
137642 2020-08-12 US Wyoming Sheridan 56033 73 0 0 73 44.79048913 -106.8862389 2020-08-13 04:29:15 Sheridan, Wyoming, US
137641 2020-08-12 US Wyoming Platte 56031 5 0 0 5 42.13299116 -104.966331 2020-08-13 04:29:15 Platte, Wyoming, US
137640 2020-08-12 US Wyoming Park 56029 135 0 0 135 44.52157546 -109.5852825 2020-08-13 04:29:15 Park, Wyoming, US
137639 2020-08-12 US Wyoming Niobrara 56027 2 0 0 2 43.05607708 -104.4758896 2020-08-13 04:29:15 Niobrara, Wyoming, US
137638 2020-08-12 US Wyoming Natrona 56025 238 0 0 238 42.96180148 -106.797885 2020-08-13 04:29:15 Natrona, Wyoming, US
137637 2020-08-12 US Wyoming Lincoln 56023 100 0 0 100 42.26376367 -110.6563997 2020-08-13 04:29:15 Lincoln, Wyoming, US
137636 2020-08-12 US Wyoming Laramie 56021 504 0 0 504 41.30702520000001 -104.6887497 2020-08-13 04:29:15 Laramie, Wyoming, US
137635 2020-08-12 US Wyoming Johnson 56019 24 1 0 23 44.04057166 -106.5845174 2020-08-13 04:29:15 Johnson, Wyoming, US
137634 2020-08-12 US Wyoming Hot Springs 56017 23 0 0 23 43.71930657 -108.4423174 2020-08-13 04:29:15 Hot Springs, Wyoming, US
137633 2020-08-12 US Wyoming Goshen 56015 34 0 0 34 42.08798185 -104.3534743 2020-08-13 04:29:15 Goshen, Wyoming, US
137632 2020-08-12 US Wyoming Fremont 56013 500 0 0 500 43.04183996 -108.6296893 2020-08-13 04:29:15 Fremont, Wyoming, US
137631 2020-08-12 US Wyoming Crook 56011 10 0 0 10 44.58855102 -104.5697705 2020-08-13 04:29:15 Crook, Wyoming, US
137630 2020-08-12 US Wyoming Converse 56009 31 0 0 31 42.97272268 -105.5081848 2020-08-13 04:29:15 Converse, Wyoming, US
137629 2020-08-12 US Wyoming Carbon 56007 105 0 0 105 41.69357844 -106.9326084 2020-08-13 04:29:15 Carbon, Wyoming, US
137628 2020-08-12 US Wyoming Campbell 56005 132 0 0 132 44.24886082 -105.5474404 2020-08-13 04:29:15 Campbell, Wyoming, US
137627 2020-08-12 US Wyoming Big Horn 56003 37 0 0 37 44.52405055 -107.9960365 2020-08-13 04:29:15 Big Horn, Wyoming, US
137626 2020-08-12 US Wyoming Albany 56001 89 0 0 89 41.65498705 -105.7235415 2020-08-13 04:29:15 Albany, Wyoming, US
137625 2020-08-12 US Wisconsin Wood 55141 327 2 0 325 44.45537896 -90.04158336 2020-08-13 04:29:15 Wood, Wisconsin, US
137624 2020-08-12 US Wisconsin Winnebago 55139 1216 18 0 1198 44.06886922 -88.64477096 2020-08-13 04:29:15 Winnebago, Wisconsin, US
137623 2020-08-12 US Wisconsin Waushara 55137 120 1 0 119 44.11324419 -89.24317107 2020-08-13 04:29:15 Waushara, Wisconsin, US
137622 2020-08-12 US Wisconsin Waupaca 55135 480 15 0 465 44.47068056 -88.96534501 2020-08-13 04:29:15 Waupaca, Wisconsin, US
137621 2020-08-12 US Wisconsin Waukesha 55133 4402 59 0 4343 43.01833055 -88.30431188 2020-08-13 04:29:15 Waukesha, Wisconsin, US
137620 2020-08-12 US Wisconsin Washington 55131 1115 22 0 1093 43.36863664 -88.22974712 2020-08-13 04:29:15 Washington, Wisconsin, US
137619 2020-08-12 US Wisconsin Washburn 55129 47 0 0 47 45.89838588 -91.79050449 2020-08-13 04:29:15 Washburn, Wisconsin, US
137618 2020-08-12 US Wisconsin Walworth 55127 1369 23 0 1346 42.66858202 -88.54163073 2020-08-13 04:29:15 Walworth, Wisconsin, US
137617 2020-08-12 US Wisconsin Vilas 55125 65 0 0 65 46.05467334 -89.51719204 2020-08-13 04:29:15 Vilas, Wisconsin, US
137616 2020-08-12 US Wisconsin Vernon 55123 67 0 0 67 43.59422667 -90.8324691 2020-08-13 04:29:15 Vernon, Wisconsin, US
137615 2020-08-12 US Wisconsin Unassigned 90055 0 0 0 0 46.52868768 0.0 2020-08-13 04:29:15 Unassigned, Wisconsin, US
137614 2020-08-12 US Wisconsin Trempealeau 55121 354 2 0 352 44.30360275 -91.35893614 2020-08-13 04:29:15 Trempealeau, Wisconsin, US
137613 2020-08-12 US Wisconsin Taylor 55119 73 1 0 72 45.21179252 -90.5004405 2020-08-13 04:29:15 Taylor, Wisconsin, US
137612 2020-08-12 US Wisconsin St. Croix 55109 514 5 0 509 45.03437474 -92.45000068 2020-08-13 04:29:15 St. Croix, Wisconsin, US
137611 2020-08-12 US Wisconsin Sheboygan 55117 786 8 0 778 43.72099677 -87.94579284 2020-08-13 04:29:15 Sheboygan, Wisconsin, US
137610 2020-08-12 US Wisconsin Shawano 55115 205 0 0 205 44.78902246 -88.76443896 2020-08-13 04:29:15 Shawano, Wisconsin, US
137609 2020-08-12 US Wisconsin Sawyer 55113 82 0 0 82 45.87931905 -91.14504927 2020-08-13 04:29:15 Sawyer, Wisconsin, US
137608 2020-08-12 US Wisconsin Sauk 55111 472 3 0 469 43.42574087 -89.94966132 2020-08-13 04:29:15 Sauk, Wisconsin, US
137607 2020-08-12 US Wisconsin Rusk 55107 21 1 0 20 45.47498854 -91.1333012 2020-08-13 04:29:15 Rusk, Wisconsin, US
137606 2020-08-12 US Wisconsin Rock 55105 1447 26 0 1421 42.67151616 -89.07147900000002 2020-08-13 04:29:15 Rock, Wisconsin, US
137605 2020-08-12 US Wisconsin Richland 55103 37 4 0 33 43.3762778 -90.43012729 2020-08-13 04:29:15 Richland, Wisconsin, US
137604 2020-08-12 US Wisconsin Racine 55101 3571 78 0 3493 42.74753117 -88.05941254 2020-08-13 04:29:15 Racine, Wisconsin, US
137603 2020-08-12 US Wisconsin Price 55099 33 0 0 33 45.68051754 -90.3609888 2020-08-13 04:29:15 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 4253.832ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette