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,489,783 rows sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, 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
676544 676544 2021-04-15 Zimbabwe       37422 1550 34961 911 -19.015438 29.154857 2021-04-16 04:20:46 Zimbabwe
676543 676543 2021-04-15 Zambia       90532 1230 88283 1019 -13.133897 27.849332 2021-04-16 04:20:46 Zambia
676542 676542 2021-04-15 Yemen       5657 1097 2178 2382 15.552727 48.516388 2021-04-16 04:20:46 Yemen
676541 676541 2021-04-15 West Bank and Gaza       276407 2937 241343 32127 31.9522 35.2332 2021-04-16 04:20:46 West Bank and Gaza
676540 676540 2021-04-15 Vietnam       2758 35 2445 278 14.058324 108.277199 2021-04-16 04:20:46 Vietnam
676539 676539 2021-04-15 Venezuela       179365 1853 161820 15692 6.4238 -66.5897 2021-04-16 04:20:46 Venezuela
676538 676538 2021-04-15 Vanuatu       3 0 1 2 -15.3767 166.9592 2021-04-16 04:20:46 Vanuatu
676537 676537 2021-04-15 Uzbekistan       85730 634 83462 1634 41.377491 64.585262 2021-04-16 04:20:46 Uzbekistan
676536 676536 2021-04-15 Uruguay       156499 1726 122637 32136 -32.5228 -55.7658 2021-04-16 04:20:46 Uruguay
676535 676535 2021-04-15 United Kingdom Wales     210681 5535 0 205146 52.1307 -3.7837 2021-04-16 04:20:46 Wales, United Kingdom
676534 676534 2021-04-15 United Kingdom Unknown     0 0 0 0     2021-04-16 04:20:46 Unknown, United Kingdom
676533 676533 2021-04-15 United Kingdom Turks and Caicos Islands     2367 17 2285 65 21.694000000000006 -71.7979 2021-04-16 04:20:46 Turks and Caicos Islands, United Kingdom
676532 676532 2021-04-15 United Kingdom Scotland     222897 7637 0 215260 56.4907 -4.2026 2021-04-16 04:20:46 Scotland, United Kingdom
676531 676531 2021-04-15 United Kingdom Saint Helena, Ascension and Tristan da Cunha     4 0 4 0 -7.9467 -14.3559 2021-03-14 23:25:24 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
676530 676530 2021-04-15 United Kingdom Northern Ireland     118732 2132 0 116600 54.7877 -6.4923 2021-04-16 04:20:46 Northern Ireland, United Kingdom
676529 676529 2021-04-15 United Kingdom Montserrat     20 1 19 0 16.742498 -62.187366 2021-04-16 04:20:46 Montserrat, United Kingdom
676528 676528 2021-04-15 United Kingdom Isle of Man     1575 29 1534 12 54.2361 -4.5481 2021-04-16 04:20:46 Isle of Man, United Kingdom
676527 676527 2021-04-15 United Kingdom Gibraltar     4290 94 4181 15 36.1408 -5.3536 2021-04-16 04:20:46 Gibraltar, United Kingdom
676526 676526 2021-04-15 United Kingdom Falkland Islands (Malvinas)     62 0 55 7 -51.7963 -59.5236 2021-04-16 04:20:46 Falkland Islands (Malvinas), United Kingdom
676525 676525 2021-04-15 United Kingdom England     3828666 111887 0 3716779 52.3555 -1.1743 2021-04-16 04:20:46 England, United Kingdom
676524 676524 2021-04-15 United Kingdom Channel Islands     4053 86 3956 11 49.3723 -2.3644 2021-04-16 04:20:46 Channel Islands, United Kingdom
676523 676523 2021-04-15 United Kingdom Cayman Islands     523 2 499 22 19.3133 -81.2546 2021-04-16 04:20:46 Cayman Islands, United Kingdom
676522 676522 2021-04-15 United Kingdom British Virgin Islands     178 1 159 18 18.4207 -64.64 2021-04-16 04:20:46 British Virgin Islands, United Kingdom
676521 676521 2021-04-15 United Kingdom Bermuda     2023 17 1140 866 32.3078 -64.7505 2021-04-16 04:20:46 Bermuda, United Kingdom
676520 676520 2021-04-15 United Kingdom Anguilla     25 0 22 3 18.2206 -63.0686 2021-04-16 04:20:46 Anguilla, United Kingdom
676519 676519 2021-04-15 United Arab Emirates       491423 1545 475012 14866 23.424076 53.847818 2021-04-16 04:20:46 United Arab Emirates
676518 676518 2021-04-15 Ukraine Zhytomyr Oblast     79504 1425 58736 19343 50.2547 28.6587 2021-04-16 04:20:46 Zhytomyr Oblast, Ukraine
676517 676517 2021-04-15 Ukraine Zaporizhia Oblast     87954 1650 71164 15140 47.8388 35.1396 2021-04-16 04:20:46 Zaporizhia Oblast, Ukraine
676516 676516 2021-04-15 Ukraine Zakarpattia Oblast     58249 1458 47624 9167 48.6208 22.2879 2021-04-16 04:20:46 Zakarpattia Oblast, Ukraine
676515 676515 2021-04-15 Ukraine Volyn Oblast     52415 885 43856 7674 50.7472 25.3254 2021-04-16 04:20:46 Volyn Oblast, Ukraine
676514 676514 2021-04-15 Ukraine Vinnytsia Oblast     64171 1343 43045 19783 49.2331 28.4682 2021-04-16 04:20:46 Vinnytsia Oblast, Ukraine
676513 676513 2021-04-15 Ukraine Ternopil Oblast     61894 955 50569 10370 49.5535 25.5948 2021-04-16 04:20:46 Ternopil Oblast, Ukraine
676512 676512 2021-04-15 Ukraine Sumy Oblast     66916 948 54798 11170 50.9077 34.7981 2021-04-16 04:20:46 Sumy Oblast, Ukraine
676511 676511 2021-04-15 Ukraine Sevastopol*     13725 587 12602 536 44.6054 33.522 2021-04-16 04:20:46 Sevastopol*, Ukraine
676510 676510 2021-04-15 Ukraine Rivne Oblast     65284 889 55553 8842 50.6199 26.2516 2021-04-16 04:20:46 Rivne Oblast, Ukraine
676509 676509 2021-04-15 Ukraine Poltava Oblast     64039 1350 52508 10181 49.5883 34.5514 2021-04-16 04:20:46 Poltava Oblast, Ukraine
676508 676508 2021-04-15 Ukraine Odessa Oblast     123449 2188 87990 33271 46.4846 30.7326 2021-04-16 04:20:46 Odessa Oblast, Ukraine
676507 676507 2021-04-15 Ukraine Mykolaiv Oblast     57632 1364 45597 10671 46.975 31.9946 2021-04-16 04:20:46 Mykolaiv Oblast, Ukraine
676506 676506 2021-04-15 Ukraine Lviv Oblast     120288 2950 87872 29466 49.8397 24.0297 2021-04-16 04:20:46 Lviv Oblast, Ukraine
676505 676505 2021-04-15 Ukraine Luhansk Oblast     20405 600 16375 3430 48.574 39.3078 2021-04-16 04:20:46 Luhansk Oblast, Ukraine
676504 676504 2021-04-15 Ukraine Kirovohrad Oblast     15502 539 9933 5030 48.5079 32.2623 2021-04-16 04:20:46 Kirovohrad Oblast, Ukraine
676503 676503 2021-04-15 Ukraine Kiev Oblast     109219 2010 85726 21483 50.053 30.7667 2021-04-16 04:20:46 Kiev Oblast, Ukraine
676502 676502 2021-04-15 Ukraine Kiev     181691 4072 113240 64379 50.4501 30.5234 2021-04-16 04:20:46 Kiev, Ukraine
676501 676501 2021-04-15 Ukraine Khmelnytskyi Oblast     76480 1400 58842 16238 49.423 26.9871 2021-04-16 04:20:46 Khmelnytskyi Oblast, Ukraine
676500 676500 2021-04-15 Ukraine Kherson Oblast     28028 786 22606 4636 46.6354 32.6169 2021-04-16 04:20:46 Kherson Oblast, Ukraine
676499 676499 2021-04-15 Ukraine Kharkiv Oblast     121086 2312 94319 24455 49.9935 36.2304 2021-04-16 04:20:46 Kharkiv Oblast, Ukraine
676498 676498 2021-04-15 Ukraine Ivano-Frankivsk Oblast     82252 1872 72599 7781 48.9226 24.7111 2021-04-16 04:20:46 Ivano-Frankivsk Oblast, Ukraine
676497 676497 2021-04-15 Ukraine Donetsk Oblast     69968 1484 53839 14645 48.0159 37.8028 2021-04-16 04:20:46 Donetsk Oblast, Ukraine
676496 676496 2021-04-15 Ukraine Dnipropetrovsk Oblast     107183 2776 81707 22700 48.4647 35.0462 2021-04-16 04:20:46 Dnipropetrovsk Oblast, Ukraine
676495 676495 2021-04-15 Ukraine Crimea Republic*     38964 1144 36320 1500 45.2835 34.2008 2021-04-16 04:20:46 Crimea Republic*, Ukraine
676494 676494 2021-04-15 Ukraine Chernivtsi Oblast     74555 1541 54607 18407 48.2917 25.9352 2021-04-16 04:20:46 Chernivtsi Oblast, Ukraine
676493 676493 2021-04-15 Ukraine Chernihiv Oblast     48586 988 36801 10797 51.4982 31.2893 2021-04-16 04:20:46 Chernihiv Oblast, Ukraine
676492 676492 2021-04-15 Ukraine Cherkasy Oblast     67015 873 53860 12282 49.4444 32.0598 2021-04-16 04:20:46 Cherkasy Oblast, Ukraine
676491 676491 2021-04-15 Uganda       41263 338 40898 27 1.373333 32.290275 2021-04-16 04:20:46 Uganda
676490 676490 2021-04-15 US Wyoming Weston 56045 646 5 0   43.83961191 -104.5674881 2021-04-16 04:20:46 Weston, Wyoming, US
676489 676489 2021-04-15 US Wyoming Washakie 56043 898 26 0   43.90451606 -107.68018700000002 2021-04-16 04:20:46 Washakie, Wyoming, US
676488 676488 2021-04-15 US Wyoming Unassigned 90056 0 0 0   44.79048913 -110.6563997 2021-04-16 04:20:46 Unassigned, Wyoming, US
676487 676487 2021-04-15 US Wyoming Uinta 56041 2155 12 0   41.2878183 -110.54757820000002 2021-04-16 04:20:46 Uinta, Wyoming, US
676486 676486 2021-04-15 US Wyoming Teton 56039 3689 9 0   43.93522482 -110.5890801 2021-04-16 04:20:46 Teton, Wyoming, US
676485 676485 2021-04-15 US Wyoming Sweetwater 56037 4119 37 0   41.65943896 -108.8827882 2021-04-16 04:20:46 Sweetwater, Wyoming, US
676484 676484 2021-04-15 US Wyoming Sublette 56035 750 7 0   42.76558279 -109.9130922 2021-04-16 04:20:46 Sublette, Wyoming, US
676483 676483 2021-04-15 US Wyoming Sheridan 56033 3098 31 0   44.79048913 -106.8862389 2021-04-16 04:20:46 Sheridan, Wyoming, US
676482 676482 2021-04-15 US Wyoming Platte 56031 617 11 0   42.13299116 -104.966331 2021-04-16 04:20:46 Platte, Wyoming, US
676481 676481 2021-04-15 US Wyoming Park 56029 2660 30 0   44.52157546 -109.5852825 2021-04-16 04:20:46 Park, Wyoming, US
676480 676480 2021-04-15 US Wyoming Niobrara 56027 150 2 0   43.05607708 -104.4758896 2021-04-16 04:20:46 Niobrara, Wyoming, US
676479 676479 2021-04-15 US Wyoming Natrona 56025 7876 135 0   42.96180148 -106.797885 2021-04-16 04:20:46 Natrona, Wyoming, US
676478 676478 2021-04-15 US Wyoming Lincoln 56023 1385 12 0   42.26376367 -110.6563997 2021-04-16 04:20:46 Lincoln, Wyoming, US
676477 676477 2021-04-15 US Wyoming Laramie 56021 8820 113 0   41.30702520000001 -104.6887497 2021-04-16 04:20:46 Laramie, Wyoming, US
676476 676476 2021-04-15 US Wyoming Johnson 56019 716 10 0   44.04057166 -106.5845174 2021-04-16 04:20:46 Johnson, Wyoming, US
676475 676475 2021-04-15 US Wyoming Hot Springs 56017 363 3 0   43.71930657 -108.4423174 2021-04-16 04:20:46 Hot Springs, Wyoming, US
676474 676474 2021-04-15 US Wyoming Goshen 56015 1178 23 0   42.08798185 -104.3534743 2021-04-16 04:20:46 Goshen, Wyoming, US
676473 676473 2021-04-15 US Wyoming Fremont 56013 5117 82 0   43.04183996 -108.6296893 2021-04-16 04:20:46 Fremont, Wyoming, US
676472 676472 2021-04-15 US Wyoming Crook 56011 428 12 0   44.58855102 -104.5697705 2021-04-16 04:20:46 Crook, Wyoming, US
676471 676471 2021-04-15 US Wyoming Converse 56009 990 17 0   42.97272268 -105.5081848 2021-04-16 04:20:46 Converse, Wyoming, US
676470 676470 2021-04-15 US Wyoming Carbon 56007 1537 23 0   41.69357844 -106.9326084 2021-04-16 04:20:46 Carbon, Wyoming, US
676469 676469 2021-04-15 US Wyoming Campbell 56005 4788 60 0   44.24886082 -105.5474404 2021-04-16 04:20:46 Campbell, Wyoming, US
676468 676468 2021-04-15 US Wyoming Big Horn 56003 1118 32 0   44.52405055 -107.9960365 2021-04-16 04:20:46 Big Horn, Wyoming, US
676467 676467 2021-04-15 US Wyoming Albany 56001 4105 11 0   41.65498705 -105.7235415 2021-04-16 04:20:46 Albany, Wyoming, US
676466 676466 2021-04-15 US Wisconsin Wood 55141 7333 90 0   44.45537896 -90.04158336 2021-04-16 04:20:46 Wood, Wisconsin, US
676465 676465 2021-04-15 US Wisconsin Winnebago 55139 20812 211 0   44.06886922 -88.64477096 2021-04-16 04:20:46 Winnebago, Wisconsin, US
676464 676464 2021-04-15 US Wisconsin Waushara 55137 2452 35 0   44.11324419 -89.24317107 2021-04-16 04:20:46 Waushara, Wisconsin, US
676463 676463 2021-04-15 US Wisconsin Waupaca 55135 5930 161 0   44.47068056 -88.96534501 2021-04-16 04:20:46 Waupaca, Wisconsin, US
676462 676462 2021-04-15 US Wisconsin Waukesha 55133 47717 558 0   43.01833055 -88.30431188 2021-04-16 04:20:46 Waukesha, Wisconsin, US
676461 676461 2021-04-15 US Wisconsin Washington 55131 16312 154 0   43.36863664 -88.22974712 2021-04-16 04:20:46 Washington, Wisconsin, US
676460 676460 2021-04-15 US Wisconsin Washburn 55129 1476 20 0   45.89838588 -91.79050449 2021-04-16 04:20:46 Washburn, Wisconsin, US
676459 676459 2021-04-15 US Wisconsin Walworth 55127 11941 155 0   42.66858202 -88.54163073 2021-04-16 04:20:46 Walworth, Wisconsin, US
676458 676458 2021-04-15 US Wisconsin Vilas 55125 2362 41 0   46.05467334 -89.51719204 2021-04-16 04:20:46 Vilas, Wisconsin, US
676457 676457 2021-04-15 US Wisconsin Vernon 55123 1964 42 0   43.59422667 -90.8324691 2021-04-16 04:20:46 Vernon, Wisconsin, US
676456 676456 2021-04-15 US Wisconsin Unassigned 90055 0 0 0   46.52868768 0.0 2021-04-16 04:20:46 Unassigned, Wisconsin, US
676455 676455 2021-04-15 US Wisconsin Trempealeau 55121 3594 42 0   44.30360275 -91.35893614 2021-04-16 04:20:46 Trempealeau, Wisconsin, US
676454 676454 2021-04-15 US Wisconsin Taylor 55119 2076 32 0   45.21179252 -90.5004405 2021-04-16 04:20:46 Taylor, Wisconsin, US
676453 676453 2021-04-15 US Wisconsin St. Croix 55109 8898 57 0   45.03437474 -92.45000068 2021-04-16 04:20:46 St. Croix, Wisconsin, US
676452 676452 2021-04-15 US Wisconsin Sheboygan 55117 14393 143 0   43.72099677 -87.94579284 2021-04-16 04:20:46 Sheboygan, Wisconsin, US
676451 676451 2021-04-15 US Wisconsin Shawano 55115 5230 81 0   44.78902246 -88.76443896 2021-04-16 04:20:46 Shawano, Wisconsin, US
676450 676450 2021-04-15 US Wisconsin Sawyer 55113 1634 25 0   45.87931905 -91.14504927 2021-04-16 04:20:46 Sawyer, Wisconsin, US
676449 676449 2021-04-15 US Wisconsin Sauk 55111 5910 52 0   43.42574087 -89.94966132 2021-04-16 04:20:46 Sauk, Wisconsin, US
676448 676448 2021-04-15 US Wisconsin Rusk 55107 1327 17 0   45.47498854 -91.1333012 2021-04-16 04:20:46 Rusk, Wisconsin, US
676447 676447 2021-04-15 US Wisconsin Rock 55105 16981 187 0   42.67151616 -89.07147900000002 2021-04-16 04:20:46 Rock, Wisconsin, US
676446 676446 2021-04-15 US Wisconsin Richland 55103 1359 15 0   43.3762778 -90.43012729 2021-04-16 04:20:46 Richland, Wisconsin, US
676445 676445 2021-04-15 US Wisconsin Racine 55101 23973 364 0   42.74753117 -88.05941254 2021-04-16 04:20:46 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]);