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,321,891 rows sorted by day descending

✎ View and edit SQL

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

Suggested facets: last_update (date)

These facets timed out: day

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
904349 904349 2021-03-04 Zimbabwe       36223 1483 33632 1108 -19.015438 29.154857 2021-03-05 05:26:29 Zimbabwe
904348 904348 2021-03-04 Zambia       80687 1109 76498 3080 -13.133897 27.849332 2021-03-05 05:26:29 Zambia
904347 904347 2021-03-04 Yemen       2375 645 1435 295 15.552727 48.516388 2021-03-05 05:26:29 Yemen
904346 904346 2021-03-04 West Bank and Gaza       191203 2091 171318 17794 31.9522 35.2332 2021-03-05 05:26:29 West Bank and Gaza
904345 904345 2021-03-04 Vietnam       2488 35 1920 533 14.058324 108.277199 2021-03-05 05:26:29 Vietnam
904344 904344 2021-03-04 Venezuela       140960 1364 133034 6562 6.4238 -66.5897 2021-03-05 05:26:29 Venezuela
904343 904343 2021-03-04 Vanuatu       1 0 1 0 -15.3767 166.9592 2021-03-05 05:26:29 Vanuatu
904342 904342 2021-03-04 Uzbekistan       80035 622 78722 691 41.377491 64.585262 2021-03-05 05:26:29 Uzbekistan
904341 904341 2021-03-04 Uruguay       60945 631 52612 7702 -32.5228 -55.7658 2021-03-05 05:26:29 Uruguay
904340 904340 2021-03-04 United Kingdom Wales     204463 5366 0 199097 52.1307 -3.7837 2021-03-05 05:26:29 Wales, United Kingdom
904339 904339 2021-03-04 United Kingdom Unknown     0 0 0 0     2021-03-05 05:26:29 Unknown, United Kingdom
904338 904338 2021-03-04 United Kingdom Turks and Caicos Islands     2161 14 1976 171 21.694000000000006 -71.7979 2021-03-05 05:26:29 Turks and Caicos Islands, United Kingdom
904337 904337 2021-03-04 United Kingdom Scotland     204055 7398 0 196657 56.4907 -4.2026 2021-03-05 05:26:29 Scotland, United Kingdom
904336 904336 2021-03-04 United Kingdom Saint Helena, Ascension and Tristan da Cunha     4 0 4 0 -7.9467 -14.3559 2021-03-05 05:26:29 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
904335 904335 2021-03-04 United Kingdom Northern Ireland     113169 2066 0 111103 54.7877 -6.4923 2021-03-05 05:26:29 Northern Ireland, United Kingdom
904334 904334 2021-03-04 United Kingdom Montserrat     20 1 13 6 16.742498 -62.187366 2021-03-05 05:26:29 Montserrat, United Kingdom
904333 904333 2021-03-04 United Kingdom Isle of Man     546 25 416 105 54.2361 -4.5481 2021-03-05 05:26:29 Isle of Man, United Kingdom
904332 904332 2021-03-04 United Kingdom Gibraltar     4243 93 4128 22 36.1408 -5.3536 2021-03-05 05:26:29 Gibraltar, United Kingdom
904331 904331 2021-03-04 United Kingdom Falkland Islands (Malvinas)     54 0 51 3 -51.7963 -59.5236 2021-03-05 05:26:29 Falkland Islands (Malvinas), United Kingdom
904330 904330 2021-03-04 United Kingdom England     3679671 109195 0 3570476 52.3555 -1.1743 2021-03-05 05:26:29 England, United Kingdom
904329 904329 2021-03-04 United Kingdom Channel Islands     4041 86 3948 7 49.3723 -2.3644 2021-03-05 05:26:29 Channel Islands, United Kingdom
904328 904328 2021-03-04 United Kingdom Cayman Islands     448 2 425 21 19.3133 -81.2546 2021-03-05 05:26:29 Cayman Islands, United Kingdom
904327 904327 2021-03-04 United Kingdom British Virgin Islands     153 1 131 21 18.4207 -64.64 2021-03-05 05:26:29 British Virgin Islands, United Kingdom
904326 904326 2021-03-04 United Kingdom Bermuda     718 12 685 21 32.3078 -64.7505 2021-03-05 05:26:29 Bermuda, United Kingdom
904325 904325 2021-03-04 United Kingdom Anguilla     18 0 18 0 18.2206 -63.0686 2021-03-05 05:26:29 Anguilla, United Kingdom
904324 904324 2021-03-04 United Arab Emirates       402205 1286 387278 13641 23.424076 53.847818 2021-03-05 05:26:29 United Arab Emirates
904323 904323 2021-03-04 Ukraine Zhytomyr Oblast     52854 861 44940 7053 50.2547 28.6587 2021-03-05 05:26:29 Zhytomyr Oblast, Ukraine
904322 904322 2021-03-04 Ukraine Zaporizhia Oblast     70247 1184 65684 3379 47.8388 35.1396 2021-03-05 05:26:29 Zaporizhia Oblast, Ukraine
904321 904321 2021-03-04 Ukraine Zakarpattia Oblast     42091 956 31547 9588 48.6208 22.2879 2021-03-05 05:26:29 Zakarpattia Oblast, Ukraine
904320 904320 2021-03-04 Ukraine Volyn Oblast     40659 652 37346 2661 50.7472 25.3254 2021-03-05 05:26:29 Volyn Oblast, Ukraine
904319 904319 2021-03-04 Ukraine Vinnytsia Oblast     39067 688 28285 10094 49.2331 28.4682 2021-03-05 05:26:29 Vinnytsia Oblast, Ukraine
904318 904318 2021-03-04 Ukraine Ternopil Oblast     43223 612 39075 3536 49.5535 25.5948 2021-03-05 05:26:29 Ternopil Oblast, Ukraine
904317 904317 2021-03-04 Ukraine Sumy Oblast     49152 680 46388 2084 50.9077 34.7981 2021-03-05 05:26:29 Sumy Oblast, Ukraine
904316 904316 2021-03-04 Ukraine Sevastopol*     12176 506 11351 319 44.6054 33.522 2021-03-05 05:26:29 Sevastopol*, Ukraine
904315 904315 2021-03-04 Ukraine Rivne Oblast     49484 631 47051 1802 50.6199 26.2516 2021-03-05 05:26:29 Rivne Oblast, Ukraine
904314 904314 2021-03-04 Ukraine Poltava Oblast     46754 991 42708 3055 49.5883 34.5514 2021-03-05 05:26:29 Poltava Oblast, Ukraine
904313 904313 2021-03-04 Ukraine Odessa Oblast     87210 1460 79567 6183 46.4846 30.7326 2021-03-05 05:26:29 Odessa Oblast, Ukraine
904312 904312 2021-03-04 Ukraine Mykolaiv Oblast     42939 802 36910 5227 46.975 31.9946 2021-03-05 05:26:29 Mykolaiv Oblast, Ukraine
904311 904311 2021-03-04 Ukraine Lviv Oblast     80575 2308 70057 8210 49.8397 24.0297 2021-03-05 05:26:29 Lviv Oblast, Ukraine
904310 904310 2021-03-04 Ukraine Luhansk Oblast     15119 470 13995 654 48.574 39.3078 2021-03-05 05:26:29 Luhansk Oblast, Ukraine
904309 904309 2021-03-04 Ukraine Kirovohrad Oblast     10835 379 8099 2357 48.5079 32.2623 2021-03-05 05:26:29 Kirovohrad Oblast, Ukraine
904308 904308 2021-03-04 Ukraine Kiev Oblast     76978 1276 69869 5833 50.053 30.7667 2021-03-05 05:26:29 Kiev Oblast, Ukraine
904307 904307 2021-03-04 Ukraine Kiev     140006 2718 95695 41593 50.4501 30.5234 2021-03-05 05:26:29 Kiev, Ukraine
904306 904306 2021-03-04 Ukraine Khmelnytskyi Oblast     48914 902 45078 2934 49.423 26.9871 2021-03-05 05:26:29 Khmelnytskyi Oblast, Ukraine
904305 904305 2021-03-04 Ukraine Kherson Oblast     21823 649 20361 813 46.6354 32.6169 2021-03-05 05:26:29 Kherson Oblast, Ukraine
904304 904304 2021-03-04 Ukraine Kharkiv Oblast     85039 1619 77486 5934 49.9935 36.2304 2021-03-05 05:26:29 Kharkiv Oblast, Ukraine
904303 904303 2021-03-04 Ukraine Ivano-Frankivsk Oblast     67024 1212 50269 15543 48.9226 24.7111 2021-03-05 05:26:29 Ivano-Frankivsk Oblast, Ukraine
904302 904302 2021-03-04 Ukraine Donetsk Oblast     47978 1076 44617 2285 48.0159 37.8028 2021-03-05 05:26:29 Donetsk Oblast, Ukraine
904301 904301 2021-03-04 Ukraine Dnipropetrovsk Oblast     74679 2015 68828 3836 48.4647 35.0462 2021-03-05 05:26:29 Dnipropetrovsk Oblast, Ukraine
904300 904300 2021-03-04 Ukraine Crimea Republic*     35989 949 32323 2717 45.2835 34.2008 2021-03-05 05:26:29 Crimea Republic*, Ukraine
904299 904299 2021-03-04 Ukraine Chernivtsi Oblast     56754 1046 45585 10123 48.2917 25.9352 2021-03-05 05:26:29 Chernivtsi Oblast, Ukraine
904298 904298 2021-03-04 Ukraine Chernihiv Oblast     36188 762 31379 4047 51.4982 31.2893 2021-03-05 05:26:29 Chernihiv Oblast, Ukraine
904297 904297 2021-03-04 Ukraine Cherkasy Oblast     49170 642 46054 2474 49.4444 32.0598 2021-03-05 05:26:29 Cherkasy Oblast, Ukraine
904296 904296 2021-03-04 Uganda       40426 334 15052 25040 1.373333 32.290275 2021-03-05 05:26:29 Uganda
904295 904295 2021-03-04 US Wyoming Weston 56045 623 5 0 618 43.83961191 -104.5674881 2021-03-05 05:26:29 Weston, Wyoming, US
904294 904294 2021-03-04 US Wyoming Washakie 56043 887 26 0 861 43.90451606 -107.68018700000002 2021-03-05 05:26:29 Washakie, Wyoming, US
904293 904293 2021-03-04 US Wyoming Unassigned 90056 0 0 0 0 44.79048913 -110.6563997 2021-03-05 05:26:29 Unassigned, Wyoming, US
904292 904292 2021-03-04 US Wyoming Uinta 56041 2070 12 0 2058 41.2878183 -110.54757820000002 2021-03-05 05:26:29 Uinta, Wyoming, US
904291 904291 2021-03-04 US Wyoming Teton 56039 3368 9 0 3359 43.93522482 -110.5890801 2021-03-05 05:26:29 Teton, Wyoming, US
904290 904290 2021-03-04 US Wyoming Sweetwater 56037 3811 36 0 3775 41.65943896 -108.8827882 2021-03-05 05:26:29 Sweetwater, Wyoming, US
904289 904289 2021-03-04 US Wyoming Sublette 56035 679 7 0 672 42.76558279 -109.9130922 2021-03-05 05:26:29 Sublette, Wyoming, US
904288 904288 2021-03-04 US Wyoming Sheridan 56033 3030 30 0 3000 44.79048913 -106.8862389 2021-03-05 05:26:29 Sheridan, Wyoming, US
904287 904287 2021-03-04 US Wyoming Platte 56031 596 11 0 585 42.13299116 -104.966331 2021-03-05 05:26:29 Platte, Wyoming, US
904286 904286 2021-03-04 US Wyoming Park 56029 2623 27 0 2596 44.52157546 -109.5852825 2021-03-05 05:26:29 Park, Wyoming, US
904285 904285 2021-03-04 US Wyoming Niobrara 56027 150 2 0 148 43.05607708 -104.4758896 2021-03-05 05:26:29 Niobrara, Wyoming, US
904284 904284 2021-03-04 US Wyoming Natrona 56025 7718 132 0 7586 42.96180148 -106.797885 2021-03-05 05:26:29 Natrona, Wyoming, US
904283 904283 2021-03-04 US Wyoming Lincoln 56023 1244 11 0 1233 42.26376367 -110.6563997 2021-03-05 05:26:29 Lincoln, Wyoming, US
904282 904282 2021-03-04 US Wyoming Laramie 56021 8243 109 0 8134 41.30702520000001 -104.6887497 2021-03-05 05:26:29 Laramie, Wyoming, US
904281 904281 2021-03-04 US Wyoming Johnson 56019 712 9 0 703 44.04057166 -106.5845174 2021-03-05 05:26:29 Johnson, Wyoming, US
904280 904280 2021-03-04 US Wyoming Hot Springs 56017 360 3 0 357 43.71930657 -108.4423174 2021-03-05 05:26:29 Hot Springs, Wyoming, US
904279 904279 2021-03-04 US Wyoming Goshen 56015 1151 23 0 1128 42.08798185 -104.3534743 2021-03-05 05:26:29 Goshen, Wyoming, US
904278 904278 2021-03-04 US Wyoming Fremont 56013 4891 82 0 4809 43.04183996 -108.6296893 2021-03-05 05:26:29 Fremont, Wyoming, US
904277 904277 2021-03-04 US Wyoming Crook 56011 418 11 0 407 44.58855102 -104.5697705 2021-03-05 05:26:29 Crook, Wyoming, US
904276 904276 2021-03-04 US Wyoming Converse 56009 970 16 0 954 42.97272268 -105.5081848 2021-03-05 05:26:29 Converse, Wyoming, US
904275 904275 2021-03-04 US Wyoming Carbon 56007 1472 22 0 1450 41.69357844 -106.9326084 2021-03-05 05:26:29 Carbon, Wyoming, US
904274 904274 2021-03-04 US Wyoming Campbell 56005 4678 57 0 4621 44.24886082 -105.5474404 2021-03-05 05:26:29 Campbell, Wyoming, US
904273 904273 2021-03-04 US Wyoming Big Horn 56003 1079 31 0 1048 44.52405055 -107.9960365 2021-03-05 05:26:29 Big Horn, Wyoming, US
904272 904272 2021-03-04 US Wyoming Albany 56001 3912 11 0 3901 41.65498705 -105.7235415 2021-03-05 05:26:29 Albany, Wyoming, US
904271 904271 2021-03-04 US Wisconsin Wood 55141 7155 87 0 7068 44.45537896 -90.04158336 2021-03-05 05:26:29 Wood, Wisconsin, US
904270 904270 2021-03-04 US Wisconsin Winnebago 55139 19844 204 0 19640 44.06886922 -88.64477096 2021-03-05 05:26:29 Winnebago, Wisconsin, US
904269 904269 2021-03-04 US Wisconsin Waushara 55137 2411 35 0 2376 44.11324419 -89.24317107 2021-03-05 05:26:29 Waushara, Wisconsin, US
904268 904268 2021-03-04 US Wisconsin Waupaca 55135 5697 154 0 5543 44.47068056 -88.96534501 2021-03-05 05:26:29 Waupaca, Wisconsin, US
904267 904267 2021-03-04 US Wisconsin Waukesha 55133 45031 527 0 44504 43.01833055 -88.30431188 2021-03-05 05:26:29 Waukesha, Wisconsin, US
904266 904266 2021-03-04 US Wisconsin Washington 55131 15594 143 0 15451 43.36863664 -88.22974712 2021-03-05 05:26:29 Washington, Wisconsin, US
904265 904265 2021-03-04 US Wisconsin Washburn 55129 1372 20 0 1352 45.89838588 -91.79050449 2021-03-05 05:26:29 Washburn, Wisconsin, US
904264 904264 2021-03-04 US Wisconsin Walworth 55127 11276 148 0 11128 42.66858202 -88.54163073 2021-03-05 05:26:29 Walworth, Wisconsin, US
904263 904263 2021-03-04 US Wisconsin Vilas 55125 2277 40 0 2237 46.05467334 -89.51719204 2021-03-05 05:26:29 Vilas, Wisconsin, US
904262 904262 2021-03-04 US Wisconsin Vernon 55123 1899 40 0 1859 43.59422667 -90.8324691 2021-03-05 05:26:29 Vernon, Wisconsin, US
904261 904261 2021-03-04 US Wisconsin Unassigned 90055 0 0 0 0 46.52868768 0.0 2021-03-05 05:26:29 Unassigned, Wisconsin, US
904260 904260 2021-03-04 US Wisconsin Trempealeau 55121 3494 39 0 3455 44.30360275 -91.35893614 2021-03-05 05:26:29 Trempealeau, Wisconsin, US
904259 904259 2021-03-04 US Wisconsin Taylor 55119 2013 30 0 1983 45.21179252 -90.5004405 2021-03-05 05:26:29 Taylor, Wisconsin, US
904258 904258 2021-03-04 US Wisconsin St. Croix 55109 8039 47 0 7992 45.03437474 -92.45000068 2021-03-05 05:26:29 St. Croix, Wisconsin, US
904257 904257 2021-03-04 US Wisconsin Sheboygan 55117 13719 139 0 13580 43.72099677 -87.94579284 2021-03-05 05:26:29 Sheboygan, Wisconsin, US
904256 904256 2021-03-04 US Wisconsin Shawano 55115 5102 81 0 5021 44.78902246 -88.76443896 2021-03-05 05:26:29 Shawano, Wisconsin, US
904255 904255 2021-03-04 US Wisconsin Sawyer 55113 1557 21 0 1536 45.87931905 -91.14504927 2021-03-05 05:26:29 Sawyer, Wisconsin, US
904254 904254 2021-03-04 US Wisconsin Sauk 55111 5545 48 0 5497 43.42574087 -89.94966132 2021-03-05 05:26:29 Sauk, Wisconsin, US
904253 904253 2021-03-04 US Wisconsin Rusk 55107 1298 17 0 1281 45.47498854 -91.1333012 2021-03-05 05:26:29 Rusk, Wisconsin, US
904252 904252 2021-03-04 US Wisconsin Rock 55105 15981 173 0 15808 42.67151616 -89.07147900000002 2021-03-05 05:26:29 Rock, Wisconsin, US
904251 904251 2021-03-04 US Wisconsin Richland 55103 1323 15 0 1308 43.3762778 -90.43012729 2021-03-05 05:26:29 Richland, Wisconsin, US
904250 904250 2021-03-04 US Wisconsin Racine 55101 23019 352 0 22667 42.74753117 -88.05941254 2021-03-05 05:26:29 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] 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]);