johns_hopkins_csse_daily_reports

Table actions
⚠️ 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,142,479 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
1052121 1052121 2021-01-18 Zimbabwe       27892 773 17372 9747 -19.015438 29.154857 2021-01-19 05:22:15 Zimbabwe
1052120 1052120 2021-01-18 Zambia       38207 559 27327 10321 -13.133897 27.849332 2021-01-19 05:22:15 Zambia
1052119 1052119 2021-01-18 Yemen       2113 612 1421 80 15.552727 48.516388 2021-01-19 05:22:15 Yemen
1052118 1052118 2021-01-18 West Bank and Gaza       152555 1726 140075 10754 31.9522 35.2332 2021-01-19 05:22:15 West Bank and Gaza
1052117 1052117 2021-01-18 Vietnam       1539 35 1402 102 14.058324 108.277199 2021-01-19 05:22:15 Vietnam
1052116 1052116 2021-01-18 Venezuela       120444 1112 113328 6004 6.4238 -66.5897 2021-01-19 05:22:15 Venezuela
1052115 1052115 2021-01-18 Vanuatu       1 0 1 0 -15.3767 166.9592 2021-01-19 05:22:15 Vanuatu
1052114 1052114 2021-01-18 Uzbekistan       78036 619 76538 879 41.377491 64.585262 2021-01-19 05:22:15 Uzbekistan
1052113 1052113 2021-01-18 Uruguay       32863 319 24618 7926 -32.5228 -55.7658 2021-01-19 05:22:15 Uruguay
1052112 1052112 2021-01-18 United Kingdom Wales     181493 4294 0 177199 52.1307 -3.7837 2021-01-19 05:22:15 Wales, United Kingdom
1052111 1052111 2021-01-18 United Kingdom Unknown     0 0 0 0     2021-01-19 05:22:15 Unknown, United Kingdom
1052110 1052110 2021-01-18 United Kingdom Turks and Caicos Islands     1105 7 902 196 21.694000000000006 -71.7979 2021-01-19 05:22:15 Turks and Caicos Islands, United Kingdom
1052109 1052109 2021-01-18 United Kingdom Scotland     163762 5305 0 158457 56.4907 -4.2026 2021-01-19 05:22:15 Scotland, United Kingdom
1052108 1052108 2021-01-18 United Kingdom Northern Ireland     96001 1625 0 94376 54.7877 -6.4923 2021-01-19 05:22:15 Northern Ireland, United Kingdom
1052107 1052107 2021-01-18 United Kingdom Montserrat     13 1 12 0 16.742498 -62.187366 2021-01-19 05:22:15 Montserrat, United Kingdom
1052106 1052106 2021-01-18 United Kingdom Isle of Man     432 25 354 53 54.2361 -4.5481 2021-01-19 05:22:15 Isle of Man, United Kingdom
1052105 1052105 2021-01-18 United Kingdom Gibraltar     3712 45 2840 827 36.1408 -5.3536 2021-01-19 05:22:15 Gibraltar, United Kingdom
1052104 1052104 2021-01-18 United Kingdom Falkland Islands (Malvinas)     32 0 27 5 -51.7963 -59.5236 2021-01-19 05:22:15 Falkland Islands (Malvinas), United Kingdom
1052103 1052103 2021-01-18 United Kingdom England     2992238 78636 0 2913602 52.3555 -1.1743 2021-01-19 05:22:15 England, United Kingdom
1052102 1052102 2021-01-18 United Kingdom Channel Islands     3370 78 3073 219 49.3723 -2.3644 2021-01-19 05:22:15 Channel Islands, United Kingdom
1052101 1052101 2021-01-18 United Kingdom Cayman Islands     380 2 330 48 19.3133 -81.2546 2021-01-19 05:22:15 Cayman Islands, United Kingdom
1052100 1052100 2021-01-18 United Kingdom British Virgin Islands     114 1 95 18 18.4207 -64.64 2021-01-19 05:22:15 British Virgin Islands, United Kingdom
1052099 1052099 2021-01-18 United Kingdom Bermuda     683 12 598 73 32.3078 -64.7505 2021-01-19 05:22:15 Bermuda, United Kingdom
1052098 1052098 2021-01-18 United Kingdom Anguilla     15 0 15 0 18.2206 -63.0686 2021-01-19 05:22:15 Anguilla, United Kingdom
1052097 1052097 2021-01-18 United Arab Emirates       256732 751 228364 27617 23.424076 53.847818 2021-01-19 05:22:15 United Arab Emirates
1052096 1052096 2021-01-18 Ukraine Zhytomyr Oblast     42720 703 37061 4956 50.2547 28.6587 2021-01-19 05:22:15 Zhytomyr Oblast, Ukraine
1052095 1052095 2021-01-18 Ukraine Zaporizhia Oblast     62043 723 37349 23971 47.8388 35.1396 2021-01-19 05:22:15 Zaporizhia Oblast, Ukraine
1052094 1052094 2021-01-18 Ukraine Zakarpattia Oblast     29863 684 26475 2704 48.6208 22.2879 2021-01-19 05:22:15 Zakarpattia Oblast, Ukraine
1052093 1052093 2021-01-18 Ukraine Volyn Oblast     35394 555 32596 2243 50.7472 25.3254 2021-01-19 05:22:15 Volyn Oblast, Ukraine
1052092 1052092 2021-01-18 Ukraine Vinnytsia Oblast     25000 456 19466 5078 49.2331 28.4682 2021-01-19 05:22:15 Vinnytsia Oblast, Ukraine
1052091 1052091 2021-01-18 Ukraine Ternopil Oblast     36195 498 32716 2981 49.5535 25.5948 2021-01-19 05:22:15 Ternopil Oblast, Ukraine
1052090 1052090 2021-01-18 Ukraine Sumy Oblast     44384 578 39303 4503 50.9077 34.7981 2021-01-19 05:22:15 Sumy Oblast, Ukraine
1052089 1052089 2021-01-18 Ukraine Sevastopol*     8416 324 7600 492 44.6054 33.522 2021-01-19 05:22:15 Sevastopol*, Ukraine
1052088 1052088 2021-01-18 Ukraine Rivne Oblast     44149 542 40790 2817 50.6199 26.2516 2021-01-19 05:22:15 Rivne Oblast, Ukraine
1052087 1052087 2021-01-18 Ukraine Poltava Oblast     41189 832 33688 6669 49.5883 34.5514 2021-01-19 05:22:15 Poltava Oblast, Ukraine
1052086 1052086 2021-01-18 Ukraine Odessa Oblast     78557 1240 61339 15978 46.4846 30.7326 2021-01-19 05:22:15 Odessa Oblast, Ukraine
1052085 1052085 2021-01-18 Ukraine Mykolaiv Oblast     36778 603 17483 18692 46.975 31.9946 2021-01-19 05:22:15 Mykolaiv Oblast, Ukraine
1052084 1052084 2021-01-18 Ukraine Lviv Oblast     67495 1955 54494 11046 49.8397 24.0297 2021-01-19 05:22:15 Lviv Oblast, Ukraine
1052083 1052083 2021-01-18 Ukraine Luhansk Oblast     13042 354 9497 3191 48.574 39.3078 2021-01-19 05:22:15 Luhansk Oblast, Ukraine
1052082 1052082 2021-01-18 Ukraine Kirovohrad Oblast     9376 295 5541 3540 48.5079 32.2623 2021-01-19 05:22:15 Kirovohrad Oblast, Ukraine
1052081 1052081 2021-01-18 Ukraine Kiev Oblast     66338 1064 46363 18911 50.053 30.7667 2021-01-19 05:22:15 Kiev Oblast, Ukraine
1052080 1052080 2021-01-18 Ukraine Kiev     122997 2195 48073 72729 50.4501 30.5234 2021-01-19 05:22:15 Kiev, Ukraine
1052079 1052079 2021-01-18 Ukraine Khmelnytskyi Oblast     42395 739 37626 4030 49.423 26.9871 2021-01-19 05:22:15 Khmelnytskyi Oblast, Ukraine
1052078 1052078 2021-01-18 Ukraine Kherson Oblast     19801 518 14202 5081 46.6354 32.6169 2021-01-19 05:22:15 Kherson Oblast, Ukraine
1052077 1052077 2021-01-18 Ukraine Kharkiv Oblast     74796 1248 63196 10352 49.9935 36.2304 2021-01-19 05:22:15 Kharkiv Oblast, Ukraine
1052076 1052076 2021-01-18 Ukraine Ivano-Frankivsk Oblast     45360 868 39136 5356 48.9226 24.7111 2021-01-19 05:22:15 Ivano-Frankivsk Oblast, Ukraine
1052075 1052075 2021-01-18 Ukraine Donetsk Oblast     41817 762 35203 5852 48.0159 37.8028 2021-01-19 05:22:15 Donetsk Oblast, Ukraine
1052074 1052074 2021-01-18 Ukraine Dnipropetrovsk Oblast     64557 1645 49998 12914 48.4647 35.0462 2021-01-19 05:22:15 Dnipropetrovsk Oblast, Ukraine
1052073 1052073 2021-01-18 Ukraine Crimea Republic*     29762 654 23685 5423 45.2835 34.2008 2021-01-19 05:22:15 Crimea Republic*, Ukraine
1052072 1052072 2021-01-18 Ukraine Chernivtsi Oblast     43004 833 34023 8148 48.2917 25.9352 2021-01-19 05:22:15 Chernivtsi Oblast, Ukraine
1052071 1052071 2021-01-18 Ukraine Chernihiv Oblast     32544 498 21076 10970 51.4982 31.2893 2021-01-19 05:22:15 Chernihiv Oblast, Ukraine
1052070 1052070 2021-01-18 Ukraine Cherkasy Oblast     43922 481 34502 8939 49.4444 32.0598 2021-01-19 05:22:15 Cherkasy Oblast, Ukraine
1052069 1052069 2021-01-18 Uganda       38085 304 13083 24698 1.373333 32.290275 2021-01-19 05:22:15 Uganda
1052068 1052068 2021-01-18 US Wyoming Weston 56045 602 4 0 598 43.83961191 -104.5674881 2021-01-19 05:22:15 Weston, Wyoming, US
1052067 1052067 2021-01-18 US Wyoming Washakie 56043 844 23 0 821 43.90451606 -107.68018700000002 2021-01-19 05:22:15 Washakie, Wyoming, US
1052066 1052066 2021-01-18 US Wyoming Unassigned 90056 0 0 0 0 44.79048913 -110.6563997 2021-01-19 05:22:15 Unassigned, Wyoming, US
1052065 1052065 2021-01-18 US Wyoming Uinta 56041 1833 9 0 1824 41.2878183 -110.54757820000002 2021-01-19 05:22:15 Uinta, Wyoming, US
1052064 1052064 2021-01-18 US Wyoming Teton 56039 2753 4 0 2749 43.93522482 -110.5890801 2021-01-19 05:22:15 Teton, Wyoming, US
1052063 1052063 2021-01-18 US Wyoming Sweetwater 56037 3312 26 0 3286 41.65943896 -108.8827882 2021-01-19 05:22:15 Sweetwater, Wyoming, US
1052062 1052062 2021-01-18 US Wyoming Sublette 56035 634 7 0 627 42.76558279 -109.9130922 2021-01-19 05:22:15 Sublette, Wyoming, US
1052061 1052061 2021-01-18 US Wyoming Sheridan 56033 2802 17 0 2785 44.79048913 -106.8862389 2021-01-19 05:22:15 Sheridan, Wyoming, US
1052060 1052060 2021-01-18 US Wyoming Platte 56031 535 9 0 526 42.13299116 -104.966331 2021-01-19 05:22:15 Platte, Wyoming, US
1052059 1052059 2021-01-18 US Wyoming Park 56029 2462 16 0 2446 44.52157546 -109.5852825 2021-01-19 05:22:15 Park, Wyoming, US
1052058 1052058 2021-01-18 US Wyoming Niobrara 56027 145 2 0 143 43.05607708 -104.4758896 2021-01-19 05:22:15 Niobrara, Wyoming, US
1052057 1052057 2021-01-18 US Wyoming Natrona 56025 7176 103 0 7073 42.96180148 -106.797885 2021-01-19 05:22:15 Natrona, Wyoming, US
1052056 1052056 2021-01-18 US Wyoming Lincoln 56023 1063 11 0 1052 42.26376367 -110.6563997 2021-01-19 05:22:15 Lincoln, Wyoming, US
1052055 1052055 2021-01-18 US Wyoming Laramie 56021 7789 75 0 7714 41.30702520000001 -104.6887497 2021-01-19 05:22:15 Laramie, Wyoming, US
1052054 1052054 2021-01-18 US Wyoming Johnson 56019 593 9 0 584 44.04057166 -106.5845174 2021-01-19 05:22:15 Johnson, Wyoming, US
1052053 1052053 2021-01-18 US Wyoming Hot Springs 56017 333 2 0 331 43.71930657 -108.4423174 2021-01-19 05:22:15 Hot Springs, Wyoming, US
1052052 1052052 2021-01-18 US Wyoming Goshen 56015 1090 19 0 1071 42.08798185 -104.3534743 2021-01-19 05:22:15 Goshen, Wyoming, US
1052051 1052051 2021-01-18 US Wyoming Fremont 56013 4262 71 0 4191 43.04183996 -108.6296893 2021-01-19 05:22:15 Fremont, Wyoming, US
1052050 1052050 2021-01-18 US Wyoming Crook 56011 400 9 0 391 44.58855102 -104.5697705 2021-01-19 05:22:15 Crook, Wyoming, US
1052049 1052049 2021-01-18 US Wyoming Converse 56009 887 13 0 874 42.97272268 -105.5081848 2021-01-19 05:22:15 Converse, Wyoming, US
1052048 1052048 2021-01-18 US Wyoming Carbon 56007 1098 16 0 1082 41.69357844 -106.9326084 2021-01-19 05:22:15 Carbon, Wyoming, US
1052047 1052047 2021-01-18 US Wyoming Campbell 56005 4503 45 0 4458 44.24886082 -105.5474404 2021-01-19 05:22:15 Campbell, Wyoming, US
1052046 1052046 2021-01-18 US Wyoming Big Horn 56003 921 22 0 899 44.52405055 -107.9960365 2021-01-19 05:22:15 Big Horn, Wyoming, US
1052045 1052045 2021-01-18 US Wyoming Albany 56001 3671 10 0 3661 41.65498705 -105.7235415 2021-01-19 05:22:15 Albany, Wyoming, US
1052044 1052044 2021-01-18 US Wisconsin Wood 55141 6516 74 0 6442 44.45537896 -90.04158336 2021-01-19 05:22:15 Wood, Wisconsin, US
1052043 1052043 2021-01-18 US Wisconsin Winnebago 55139 18361 183 0 18178 44.06886922 -88.64477096 2021-01-19 05:22:15 Winnebago, Wisconsin, US
1052042 1052042 2021-01-18 US Wisconsin Waushara 55137 2210 26 0 2184 44.11324419 -89.24317107 2021-01-19 05:22:15 Waushara, Wisconsin, US
1052041 1052041 2021-01-18 US Wisconsin Waupaca 55135 5234 140 0 5094 44.47068056 -88.96534501 2021-01-19 05:22:15 Waupaca, Wisconsin, US
1052040 1052040 2021-01-18 US Wisconsin Waukesha 55133 41414 424 0 40990 43.01833055 -88.30431188 2021-01-19 05:22:15 Waukesha, Wisconsin, US
1052039 1052039 2021-01-18 US Wisconsin Washington 55131 14440 113 0 14327 43.36863664 -88.22974712 2021-01-19 05:22:15 Washington, Wisconsin, US
1052038 1052038 2021-01-18 US Wisconsin Washburn 55129 1227 17 0 1210 45.89838588 -91.79050449 2021-01-19 05:22:15 Washburn, Wisconsin, US
1052037 1052037 2021-01-18 US Wisconsin Walworth 55127 10459 126 0 10333 42.66858202 -88.54163073 2021-01-19 05:22:15 Walworth, Wisconsin, US
1052036 1052036 2021-01-18 US Wisconsin Vilas 55125 1906 33 0 1873 46.05467334 -89.51719204 2021-01-19 05:22:15 Vilas, Wisconsin, US
1052035 1052035 2021-01-18 US Wisconsin Vernon 55123 1728 34 0 1694 43.59422667 -90.8324691 2021-01-19 05:22:15 Vernon, Wisconsin, US
1052034 1052034 2021-01-18 US Wisconsin Unassigned 90055 0 0 0 0 46.52868768 0.0 2021-01-19 05:22:15 Unassigned, Wisconsin, US
1052033 1052033 2021-01-18 US Wisconsin Trempealeau 55121 3276 34 0 3242 44.30360275 -91.35893614 2021-01-19 05:22:15 Trempealeau, Wisconsin, US
1052032 1052032 2021-01-18 US Wisconsin Taylor 55119 1907 26 0 1881 45.21179252 -90.5004405 2021-01-19 05:22:15 Taylor, Wisconsin, US
1052031 1052031 2021-01-18 US Wisconsin St. Croix 55109 7211 37 0 7174 45.03437474 -92.45000068 2021-01-19 05:22:15 St. Croix, Wisconsin, US
1052030 1052030 2021-01-18 US Wisconsin Sheboygan 55117 12777 113 0 12664 43.72099677 -87.94579284 2021-01-19 05:22:15 Sheboygan, Wisconsin, US
1052029 1052029 2021-01-18 US Wisconsin Shawano 55115 4861 75 0 4786 44.78902246 -88.76443896 2021-01-19 05:22:15 Shawano, Wisconsin, US
1052028 1052028 2021-01-18 US Wisconsin Sawyer 55113 1364 17 0 1347 45.87931905 -91.14504927 2021-01-19 05:22:15 Sawyer, Wisconsin, US
1052027 1052027 2021-01-18 US Wisconsin Sauk 55111 5105 40 0 5065 43.42574087 -89.94966132 2021-01-19 05:22:15 Sauk, Wisconsin, US
1052026 1052026 2021-01-18 US Wisconsin Rusk 55107 1233 15 0 1218 45.47498854 -91.1333012 2021-01-19 05:22:15 Rusk, Wisconsin, US
1052025 1052025 2021-01-18 US Wisconsin Rock 55105 14526 140 0 14386 42.67151616 -89.07147900000002 2021-01-19 05:22:15 Rock, Wisconsin, US
1052024 1052024 2021-01-18 US Wisconsin Richland 55103 1220 13 0 1207 43.3762778 -90.43012729 2021-01-19 05:22:15 Richland, Wisconsin, US
1052023 1052023 2021-01-18 US Wisconsin Racine 55101 21488 293 0 21195 42.74753117 -88.05941254 2021-01-19 05:22:15 Racine, Wisconsin, US
1052022 1052022 2021-01-18 US Wisconsin Price 55099 1097 6 0 1091 45.68051754 -90.3609888 2021-01-19 05:22: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]);