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,729,667 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
226597 226597 2021-06-14 Zimbabwe       40077 1635 37027 1415 -19.015438 29.154857 2021-06-15 04:22:22 Zimbabwe
226596 226596 2021-06-14 Zambia       113134 1416 98994 12724 -13.133897 27.849332 2021-06-15 04:22:22 Zambia
226595 226595 2021-06-14 Yemen       6863 1350 3765 1748 15.552727 48.516388 2021-06-15 04:22:22 Yemen
226594 226594 2021-06-14 West Bank and Gaza       311690 3539 304138 4013 31.9522 35.2332 2021-06-15 04:22:22 West Bank and Gaza
226593 226593 2021-06-14 Vietnam       10881 59 4236 6586 14.058324 108.277199 2021-06-15 04:22:22 Vietnam
226592 226592 2021-06-14 Venezuela       252883 2845 233028 17010 6.4238 -66.5897 2021-06-15 04:22:22 Venezuela
226591 226591 2021-06-14 Vanuatu       4 1 3 0 -15.3767 166.9592 2021-06-15 04:22:22 Vanuatu
226590 226590 2021-06-14 Uzbekistan       103813 708 99733 3372 41.377491 64.585262 2021-06-15 04:22:22 Uzbekistan
226589 226589 2021-06-14 Uruguay       340818 5036 303880 31902 -32.5228 -55.7658 2021-06-15 04:22:22 Uruguay
226588 226588 2021-06-14 United Kingdom Wales     214004 5572 0 208432 52.1307 -3.7837 2021-06-15 04:22:22 Wales, United Kingdom
226587 226587 2021-06-14 United Kingdom Unknown     0 0 0 0     2021-06-15 04:22:22 Unknown, United Kingdom
226586 226586 2021-06-14 United Kingdom Turks and Caicos Islands     2423 18 2389 16 21.694000000000006 -71.7979 2021-06-15 04:22:22 Turks and Caicos Islands, United Kingdom
226585 226585 2021-06-14 United Kingdom Scotland     247541 7681 0 239860 56.4907 -4.2026 2021-06-15 04:22:22 Scotland, United Kingdom
226584 226584 2021-06-14 United Kingdom Saint Helena, Ascension and Tristan da Cunha     4 0 4 0 -7.9467 -14.3559 2021-06-15 04:22:22 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
226583 226583 2021-06-14 United Kingdom Northern Ireland     123866 2155 0 121711 54.7877 -6.4923 2021-06-15 04:22:22 Northern Ireland, United Kingdom
226582 226582 2021-06-14 United Kingdom Montserrat     20 1 19 0 16.742498 -62.187366 2021-06-15 04:22:22 Montserrat, United Kingdom
226581 226581 2021-06-14 United Kingdom Isle of Man     1599 29 1566 4 54.2361 -4.5481 2021-06-15 04:22:22 Isle of Man, United Kingdom
226580 226580 2021-06-14 United Kingdom Gibraltar     4312 94 4205 13 36.1408 -5.3536 2021-06-15 04:22:22 Gibraltar, United Kingdom
226579 226579 2021-06-14 United Kingdom Falkland Islands (Malvinas)     63 0 63 0 -51.7963 -59.5236 2021-06-15 04:22:22 Falkland Islands (Malvinas), United Kingdom
226578 226578 2021-06-14 United Kingdom England     3988008 112499 0 3875509 52.3555 -1.1743 2021-06-15 04:22:22 England, United Kingdom
226577 226577 2021-06-14 United Kingdom Channel Islands     4112 86 3956 70 49.3723 -2.3644 2021-06-15 04:22:22 Channel Islands, United Kingdom
226576 226576 2021-06-14 United Kingdom Cayman Islands     593 2 581 10 19.3133 -81.2546 2021-06-15 04:22:22 Cayman Islands, United Kingdom
226575 226575 2021-06-14 United Kingdom British Virgin Islands     248 1 209 38 18.4207 -64.64 2021-06-15 04:22:22 British Virgin Islands, United Kingdom
226574 226574 2021-06-14 United Kingdom Bermuda     2498 33 2461 4 32.3078 -64.7505 2021-06-15 04:22:22 Bermuda, United Kingdom
226573 226573 2021-06-14 United Kingdom Anguilla     109 0 109 0 18.2206 -63.0686 2021-06-15 04:22:22 Anguilla, United Kingdom
226572 226572 2021-06-14 United Arab Emirates       599823 1730 579045 19048 23.424076 53.847818 2021-06-15 04:22:22 United Arab Emirates
226571 226571 2021-06-14 Ukraine Zhytomyr Oblast     88167 1773 85466 928 50.2547 28.6587 2021-06-15 04:22:22 Zhytomyr Oblast, Ukraine
226570 226570 2021-06-14 Ukraine Zaporizhia Oblast     104046 2400 100374 1272 47.8388 35.1396 2021-06-15 04:22:22 Zaporizhia Oblast, Ukraine
226569 226569 2021-06-14 Ukraine Zakarpattia Oblast     61939 1600 59641 698 48.6208 22.2879 2021-06-15 04:22:22 Zakarpattia Oblast, Ukraine
226568 226568 2021-06-14 Ukraine Volyn Oblast     61883 1177 59843 863 50.7472 25.3254 2021-06-15 04:22:22 Volyn Oblast, Ukraine
226567 226567 2021-06-14 Ukraine Vinnytsia Oblast     70879 1684 68621 574 49.2331 28.4682 2021-06-15 04:22:22 Vinnytsia Oblast, Ukraine
226566 226566 2021-06-14 Ukraine Ternopil Oblast     69909 1189 67748 972 49.5535 25.5948 2021-06-15 04:22:22 Ternopil Oblast, Ukraine
226565 226565 2021-06-14 Ukraine Sumy Oblast     77520 1301 75019 1200 50.9077 34.7981 2021-06-15 04:22:22 Sumy Oblast, Ukraine
226564 226564 2021-06-14 Ukraine Sevastopol*     15322 702 13959 661 44.6054 33.522 2021-06-15 04:22:22 Sevastopol*, Ukraine
226563 226563 2021-06-14 Ukraine Rivne Oblast     79172 1196 76882 1094 50.6199 26.2516 2021-06-15 04:22:22 Rivne Oblast, Ukraine
226562 226562 2021-06-14 Ukraine Poltava Oblast     77487 1830 74680 977 49.5883 34.5514 2021-06-15 04:22:22 Poltava Oblast, Ukraine
226561 226561 2021-06-14 Ukraine Odessa Oblast     140146 2940 134564 2642 46.4846 30.7326 2021-06-15 04:22:22 Odessa Oblast, Ukraine
226560 226560 2021-06-14 Ukraine Mykolaiv Oblast     69483 1822 66966 695 46.975 31.9946 2021-06-15 04:22:22 Mykolaiv Oblast, Ukraine
226559 226559 2021-06-14 Ukraine Lviv Oblast     136968 3618 131227 2123 49.8397 24.0297 2021-06-15 04:22:22 Lviv Oblast, Ukraine
226558 226558 2021-06-14 Ukraine Luhansk Oblast     26390 919 24755 716 48.574 39.3078 2021-06-15 04:22:22 Luhansk Oblast, Ukraine
226557 226557 2021-06-14 Ukraine Kirovohrad Oblast     20499 828 18457 1214 48.5079 32.2623 2021-06-15 04:22:22 Kirovohrad Oblast, Ukraine
226556 226556 2021-06-14 Ukraine Kiev Oblast     126703 2720 121855 2128 50.053 30.7667 2021-06-15 04:22:22 Kiev Oblast, Ukraine
226555 226555 2021-06-14 Ukraine Kiev     210938 5156 196874 8908 50.4501 30.5234 2021-06-15 04:22:22 Kiev, Ukraine
226554 226554 2021-06-14 Ukraine Khmelnytskyi Oblast     88530 1845 85574 1111 49.423 26.9871 2021-06-15 04:22:22 Khmelnytskyi Oblast, Ukraine
226553 226553 2021-06-14 Ukraine Kherson Oblast     35422 1109 32996 1317 46.6354 32.6169 2021-06-15 04:22:22 Kherson Oblast, Ukraine
226552 226552 2021-06-14 Ukraine Kharkiv Oblast     147901 3431 141315 3155 49.9935 36.2304 2021-06-15 04:22:22 Kharkiv Oblast, Ukraine
226551 226551 2021-06-14 Ukraine Ivano-Frankivsk Oblast     86552 2082 83395 1075 48.9226 24.7111 2021-06-15 04:22:22 Ivano-Frankivsk Oblast, Ukraine
226550 226550 2021-06-14 Ukraine Donetsk Oblast     90129 2310 86538 1281 48.0159 37.8028 2021-06-15 04:22:22 Donetsk Oblast, Ukraine
226549 226549 2021-06-14 Ukraine Dnipropetrovsk Oblast     134930 4368 127623 2939 48.4647 35.0462 2021-06-15 04:22:22 Dnipropetrovsk Oblast, Ukraine
226548 226548 2021-06-14 Ukraine Crimea Republic*     45037 1418 41652 1967 45.2835 34.2008 2021-06-15 04:22:22 Crimea Republic*, Ukraine
226547 226547 2021-06-14 Ukraine Chernivtsi Oblast     79705 1786 77159 760 48.2917 25.9352 2021-06-15 04:22:22 Chernivtsi Oblast, Ukraine
226546 226546 2021-06-14 Ukraine Chernihiv Oblast     57337 1327 55106 904 51.4982 31.2893 2021-06-15 04:22:22 Chernihiv Oblast, Ukraine
226545 226545 2021-06-14 Ukraine Cherkasy Oblast     81343 1281 77987 2075 49.4444 32.0598 2021-06-15 04:22:22 Cherkasy Oblast, Ukraine
226544 226544 2021-06-14 Uganda       63099 434 48480 14185 1.373333 32.290275 2021-06-15 04:22:22 Uganda
226543 226543 2021-06-14 US Wyoming Weston 56045 656 6 0   43.83961191 -104.5674881 2021-06-15 04:22:22 Weston, Wyoming, US
226542 226542 2021-06-14 US Wyoming Washakie 56043 924 26 0   43.90451606 -107.68018700000002 2021-06-15 04:22:22 Washakie, Wyoming, US
226541 226541 2021-06-14 US Wyoming Unassigned 90056 0 0 0   44.79048913 -110.6563997 2021-06-15 04:22:22 Unassigned, Wyoming, US
226540 226540 2021-06-14 US Wyoming Uinta 56041 2301 13 0   41.2878183 -110.54757820000002 2021-06-15 04:22:22 Uinta, Wyoming, US
226539 226539 2021-06-14 US Wyoming Teton 56039 3795 11 0   43.93522482 -110.5890801 2021-06-15 04:22:22 Teton, Wyoming, US
226538 226538 2021-06-14 US Wyoming Sweetwater 56037 4654 39 0   41.65943896 -108.8827882 2021-06-15 04:22:22 Sweetwater, Wyoming, US
226537 226537 2021-06-14 US Wyoming Sublette 56035 802 7 0   42.76558279 -109.9130922 2021-06-15 04:22:22 Sublette, Wyoming, US
226536 226536 2021-06-14 US Wyoming Sheridan 56033 3247 31 0   44.79048913 -106.8862389 2021-06-15 04:22:22 Sheridan, Wyoming, US
226535 226535 2021-06-14 US Wyoming Platte 56031 670 11 0   42.13299116 -104.966331 2021-06-15 04:22:22 Platte, Wyoming, US
226534 226534 2021-06-14 US Wyoming Park 56029 2882 30 0   44.52157546 -109.5852825 2021-06-15 04:22:22 Park, Wyoming, US
226533 226533 2021-06-14 US Wyoming Niobrara 56027 162 2 0   43.05607708 -104.4758896 2021-06-15 04:22:22 Niobrara, Wyoming, US
226532 226532 2021-06-14 US Wyoming Natrona 56025 8177 138 0   42.96180148 -106.797885 2021-06-15 04:22:22 Natrona, Wyoming, US
226531 226531 2021-06-14 US Wyoming Lincoln 56023 1415 12 0   42.26376367 -110.6563997 2021-06-15 04:22:22 Lincoln, Wyoming, US
226530 226530 2021-06-14 US Wyoming Laramie 56021 9932 117 0   41.30702520000001 -104.6887497 2021-06-15 04:22:22 Laramie, Wyoming, US
226529 226529 2021-06-14 US Wyoming Johnson 56019 735 10 0   44.04057166 -106.5845174 2021-06-15 04:22:22 Johnson, Wyoming, US
226528 226528 2021-06-14 US Wyoming Hot Springs 56017 370 3 0   43.71930657 -108.4423174 2021-06-15 04:22:22 Hot Springs, Wyoming, US
226527 226527 2021-06-14 US Wyoming Goshen 56015 1233 24 0   42.08798185 -104.3534743 2021-06-15 04:22:22 Goshen, Wyoming, US
226526 226526 2021-06-14 US Wyoming Fremont 56013 5274 84 0   43.04183996 -108.6296893 2021-06-15 04:22:22 Fremont, Wyoming, US
226525 226525 2021-06-14 US Wyoming Crook 56011 452 12 0   44.58855102 -104.5697705 2021-06-15 04:22:22 Crook, Wyoming, US
226524 226524 2021-06-14 US Wyoming Converse 56009 1029 17 0   42.97272268 -105.5081848 2021-06-15 04:22:22 Converse, Wyoming, US
226523 226523 2021-06-14 US Wyoming Carbon 56007 1620 23 0   41.69357844 -106.9326084 2021-06-15 04:22:22 Carbon, Wyoming, US
226522 226522 2021-06-14 US Wyoming Campbell 56005 5138 60 0   44.24886082 -105.5474404 2021-06-15 04:22:22 Campbell, Wyoming, US
226521 226521 2021-06-14 US Wyoming Big Horn 56003 1197 34 0   44.52405055 -107.9960365 2021-06-15 04:22:22 Big Horn, Wyoming, US
226520 226520 2021-06-14 US Wyoming Albany 56001 4569 15 0   41.65498705 -105.7235415 2021-06-15 04:22:22 Albany, Wyoming, US
226519 226519 2021-06-14 US Wisconsin Wood 55141 7700 103 0   44.45537896 -90.04158336 2021-06-15 04:22:22 Wood, Wisconsin, US
226518 226518 2021-06-14 US Wisconsin Winnebago 55139 21471 224 0   44.06886922 -88.64477096 2021-06-15 04:22:22 Winnebago, Wisconsin, US
226517 226517 2021-06-14 US Wisconsin Waushara 55137 2576 38 0   44.11324419 -89.24317107 2021-06-15 04:22:22 Waushara, Wisconsin, US
226516 226516 2021-06-14 US Wisconsin Waupaca 55135 6089 167 0   44.47068056 -88.96534501 2021-06-15 04:22:22 Waupaca, Wisconsin, US
226515 226515 2021-06-14 US Wisconsin Waukesha 55133 49173 620 0   43.01833055 -88.30431188 2021-06-15 04:22:22 Waukesha, Wisconsin, US
226514 226514 2021-06-14 US Wisconsin Washington 55131 16905 185 0   43.36863664 -88.22974712 2021-06-15 04:22:22 Washington, Wisconsin, US
226513 226513 2021-06-14 US Wisconsin Washburn 55129 1592 23 0   45.89838588 -91.79050449 2021-06-15 04:22:22 Washburn, Wisconsin, US
226512 226512 2021-06-14 US Wisconsin Walworth 55127 12481 165 0   42.66858202 -88.54163073 2021-06-15 04:22:22 Walworth, Wisconsin, US
226511 226511 2021-06-14 US Wisconsin Vilas 55125 2434 45 0   46.05467334 -89.51719204 2021-06-15 04:22:22 Vilas, Wisconsin, US
226510 226510 2021-06-14 US Wisconsin Vernon 55123 2019 43 0   43.59422667 -90.8324691 2021-06-15 04:22:22 Vernon, Wisconsin, US
226509 226509 2021-06-14 US Wisconsin Unassigned 90055 0 0 0   46.52868768 0.0 2021-06-15 04:22:22 Unassigned, Wisconsin, US
226508 226508 2021-06-14 US Wisconsin Trempealeau 55121 3668 47 0   44.30360275 -91.35893614 2021-06-15 04:22:22 Trempealeau, Wisconsin, US
226507 226507 2021-06-14 US Wisconsin Taylor 55119 2136 35 0   45.21179252 -90.5004405 2021-06-15 04:22:22 Taylor, Wisconsin, US
226506 226506 2021-06-14 US Wisconsin St. Croix 55109 9804 67 0   45.03437474 -92.45000068 2021-06-15 04:22:22 St. Croix, Wisconsin, US
226505 226505 2021-06-14 US Wisconsin Sheboygan 55117 14801 163 0   43.72099677 -87.94579284 2021-06-15 04:22:22 Sheboygan, Wisconsin, US
226504 226504 2021-06-14 US Wisconsin Shawano 55115 5334 85 0   44.78902246 -88.76443896 2021-06-15 04:22:22 Shawano, Wisconsin, US
226503 226503 2021-06-14 US Wisconsin Sawyer 55113 1848 28 0   45.87931905 -91.14504927 2021-06-15 04:22:22 Sawyer, Wisconsin, US
226502 226502 2021-06-14 US Wisconsin Sauk 55111 6230 56 0   43.42574087 -89.94966132 2021-06-15 04:22:22 Sauk, Wisconsin, US
226501 226501 2021-06-14 US Wisconsin Rusk 55107 1451 20 0   45.47498854 -91.1333012 2021-06-15 04:22:22 Rusk, Wisconsin, US
226500 226500 2021-06-14 US Wisconsin Rock 55105 18350 207 0   42.67151616 -89.07147900000002 2021-06-15 04:22:22 Rock, Wisconsin, US
226499 226499 2021-06-14 US Wisconsin Richland 55103 1401 16 0   43.3762778 -90.43012729 2021-06-15 04:22:22 Richland, Wisconsin, US
226498 226498 2021-06-14 US Wisconsin Racine 55101 25294 392 0   42.74753117 -88.05941254 2021-06-15 04:22:22 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]);