home / covid

Menu
  • GraphQL API

johns_hopkins_csse_daily_reports

Table actions
  • GraphQL API for 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

3,105,956 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 >30

  • Texas 197,626
  • Georgia 127,017
  • Virginia 105,708
  • Kentucky 94,692
  • Missouri 91,010
  • Kansas 81,897
  • Illinois 81,493
  • North Carolina 79,521
  • Iowa 78,303
  • Tennessee 76,552
  • Indiana 73,412
  • Nebraska 71,901
  • Ohio 70,180
  • Minnesota 68,841
  • Michigan 68,357
  • Mississippi 65,459
  • Oklahoma 61,759
  • Arkansas 59,761
  • Wisconsin 57,332
  • Alabama 54,378
  • Puerto Rico 53,886
  • Pennsylvania 53,686
  • Florida 53,672
  • Louisiana 52,005
  • Colorado 51,428
  • South Dakota 51,421
  • New York 49,774
  • California 46,561
  • West Virginia 43,705
  • Montana 42,271
  • …

country_or_region >30

  • US 2,553,320
  • Russia 59,798
  • Japan 35,503
  • China 27,283
  • India 26,354
  • Colombia 24,607
  • Mexico 24,030
  • Brazil 19,841
  • Ukraine 19,503
  • Peru 18,881
  • Italy 15,581
  • Sweden 15,141
  • Spain 14,838
  • Malaysia 14,450
  • United Kingdom 14,030
  • Canada 12,659
  • Germany 12,636
  • Chile 12,505
  • Netherlands 12,051
  • France 9,296
  • Belgium 6,942
  • Australia 6,636
  • Pakistan 5,075
  • Denmark 2,408
  • New Zealand 1,663
  • Mainland China 1,517
  • Antarctica 850
  • Kiribati 850
  • Korea, North 850
  • Palau 850
  • …
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
1737149 1737149 2022-05-20 Zimbabwe       250469 5489 0   -19.015438 29.154857 2022-05-21 04:20:58 Zimbabwe
1737148 1737148 2022-05-20 Zambia       320945 3984 0   -13.133897 27.849332 2022-05-21 04:20:58 Zambia
1737147 1737147 2022-05-20 Yemen       11819 2149 0   15.552727 48.516388 2022-05-21 04:20:58 Yemen
1737146 1737146 2022-05-20 Winter Olympics 2022       535 0 0   39.9042 116.4074 2022-05-21 04:20:58 Winter Olympics 2022
1737145 1737145 2022-05-20 West Bank and Gaza       657456 5659 0   31.9522 35.2332 2022-05-21 04:20:58 West Bank and Gaza
1737144 1737144 2022-05-20 Vietnam       10706111 43075 0   14.058324 108.277199 2022-05-21 04:20:58 Vietnam
1737143 1737143 2022-05-20 Venezuela       523238 5716 0   6.4238 -66.5897 2022-05-21 04:20:58 Venezuela
1737142 1737142 2022-05-20 Vanuatu       8666 14 0   -15.3767 166.9592 2022-05-21 04:20:58 Vanuatu
1737141 1737141 2022-05-20 Uzbekistan       238868 1637 0   41.377491 64.585262 2022-05-21 04:20:58 Uzbekistan
1737140 1737140 2022-05-20 Uruguay       908078 7215 0   -32.5228 -55.7658 2022-05-21 04:20:58 Uruguay
1737139 1737139 2022-05-20 United Kingdom Wales     874178 7455 0   52.1307 -3.7837 2022-05-21 04:20:58 Wales, United Kingdom
1737138 1737138 2022-05-20 United Kingdom Unknown     1943263 12211 0       2022-05-21 04:20:58 Unknown, United Kingdom
1737137 1737137 2022-05-20 United Kingdom Turks and Caicos Islands     6097 36 0   21.694 -71.7979 2022-05-21 04:20:58 Turks and Caicos Islands, United Kingdom
1737136 1737136 2022-05-20 United Kingdom Scotland     1949599 12298 0   56.4907 -4.2026 2022-05-21 04:20:58 Scotland, United Kingdom
1737135 1737135 2022-05-20 United Kingdom Saint Helena, Ascension and Tristan da Cunha     4 0 0   -7.9467 -14.3559 2022-05-21 04:20:58 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
1737134 1737134 2022-05-20 United Kingdom Northern Ireland     713294 3445 0   54.7877 -6.4923 2022-05-21 04:20:58 Northern Ireland, United Kingdom
1737133 1737133 2022-05-20 United Kingdom Montserrat     861 4 0   16.742498 -62.187366 2022-05-21 04:20:58 Montserrat, United Kingdom
1737132 1737132 2022-05-20 United Kingdom Jersey     50439 129 0   49.2138 -2.1358 2022-05-21 04:20:58 Jersey, United Kingdom
1737131 1737131 2022-05-20 United Kingdom Isle of Man     32794 105 0   54.2361 -4.5481 2022-05-21 04:20:58 Isle of Man, United Kingdom
1737130 1737130 2022-05-20 United Kingdom Guernsey     25328 47 0   49.448196 -2.58949 2022-05-21 04:20:58 Guernsey, United Kingdom
1737129 1737129 2022-05-20 United Kingdom Gibraltar     18273 102 0   36.1408 -5.3536 2022-05-21 04:20:58 Gibraltar, United Kingdom
1737128 1737128 2022-05-20 United Kingdom Falkland Islands (Malvinas)     1512 0 0   -51.7963 -59.5236 2022-05-21 04:20:58 Falkland Islands (Malvinas), United Kingdom
1737127 1737127 2022-05-20 United Kingdom England     18701642 154779 0   52.3555 -1.1743 2022-05-21 04:20:58 England, United Kingdom
1737126 1737126 2022-05-20 United Kingdom Channel Islands     0 0 0   49.3723 -2.3644 2022-05-21 04:20:58 Channel Islands, United Kingdom
1737125 1737125 2022-05-20 United Kingdom Cayman Islands     24477 28 0   19.3133 -81.2546 2022-05-21 04:20:58 Cayman Islands, United Kingdom
1737124 1737124 2022-05-20 United Kingdom British Virgin Islands     6690 62 0   18.4207 -64.64 2022-05-21 04:20:58 British Virgin Islands, United Kingdom
1737123 1737123 2022-05-20 United Kingdom Bermuda     14442 137 0   32.3078 -64.7505 2022-05-21 04:20:58 Bermuda, United Kingdom
1737122 1737122 2022-05-20 United Kingdom Anguilla     3116 9 0   18.2206 -63.0686 2022-05-21 04:20:58 Anguilla, United Kingdom
1737121 1737121 2022-05-20 United Arab Emirates       904093 2302 0   23.424076 53.847818 2022-05-21 04:20:58 United Arab Emirates
1737120 1737120 2022-05-20 Ukraine Zhytomyr Oblast     192801 3538 0   50.2547 28.6587 2022-03-01 23:21:04 Zhytomyr Oblast, Ukraine
1737119 1737119 2022-05-20 Ukraine Zaporizhia Oblast     215070 5866 0   47.8388 35.1396 2022-03-01 23:21:04 Zaporizhia Oblast, Ukraine
1737118 1737118 2022-05-20 Ukraine Zakarpattia Oblast     112462 2724 0   48.6208 22.2879 2022-03-01 23:21:04 Zakarpattia Oblast, Ukraine
1737117 1737117 2022-05-20 Ukraine Volyn Oblast     132045 2394 0   50.7472 25.3254 2022-03-01 23:21:04 Volyn Oblast, Ukraine
1737116 1737116 2022-05-20 Ukraine Vinnytsia Oblast     149845 3546 0   49.2331 28.4682 2022-03-01 23:21:04 Vinnytsia Oblast, Ukraine
1737115 1737115 2022-05-20 Ukraine Ternopil Oblast     146363 2391 0   49.5535 25.5948 2022-03-01 23:21:04 Ternopil Oblast, Ukraine
1737114 1737114 2022-05-20 Ukraine Sumy Oblast     182268 3208 0   50.9077 34.7981 2022-03-01 23:21:04 Sumy Oblast, Ukraine
1737113 1737113 2022-05-20 Ukraine Sevastopol*     73298 2088 0   44.6054 33.522 2022-03-01 23:21:04 Sevastopol*, Ukraine
1737112 1737112 2022-05-20 Ukraine Rivne Oblast     171031 2530 0   50.6199 26.2516 2022-03-01 23:21:04 Rivne Oblast, Ukraine
1737111 1737111 2022-05-20 Ukraine Poltava Oblast     179994 4181 0   49.5883 34.5514 2022-03-01 23:21:04 Poltava Oblast, Ukraine
1737110 1737110 2022-05-20 Ukraine Odessa Oblast     325462 5917 0   46.4846 30.7326 2022-03-01 23:21:04 Odessa Oblast, Ukraine
1737109 1737109 2022-05-20 Ukraine Mykolaiv Oblast     146174 3530 0   46.975 31.9946 2022-03-01 23:21:04 Mykolaiv Oblast, Ukraine
1737108 1737108 2022-05-20 Ukraine Lviv Oblast     303357 6569 0   49.8397 24.0297 2022-03-01 23:21:04 Lviv Oblast, Ukraine
1737107 1737107 2022-05-20 Ukraine Luhansk Oblast     80033 2392 0   48.574 39.3078 2022-03-01 23:21:04 Luhansk Oblast, Ukraine
1737106 1737106 2022-05-20 Ukraine Kirovohrad Oblast     45117 1741 0   48.5079 32.2623 2022-03-01 23:21:04 Kirovohrad Oblast, Ukraine
1737105 1737105 2022-05-20 Ukraine Kiev Oblast     226220 5019 0   50.053 30.7667 2022-03-01 23:21:04 Kiev Oblast, Ukraine
1737104 1737104 2022-05-20 Ukraine Kiev     445098 8966 0   50.4501 30.5234 2022-03-01 23:21:04 Kiev, Ukraine
1737103 1737103 2022-05-20 Ukraine Khmelnytskyi Oblast     201270 3703 0   49.423 26.9871 2022-03-01 23:21:04 Khmelnytskyi Oblast, Ukraine
1737102 1737102 2022-05-20 Ukraine Kherson Oblast     107686 2881 0   46.6354 32.6169 2022-03-01 23:21:04 Kherson Oblast, Ukraine
1737101 1737101 2022-05-20 Ukraine Kharkiv Oblast     305661 6858 0   49.9935 36.2304 2022-03-01 23:21:04 Kharkiv Oblast, Ukraine
1737100 1737100 2022-05-20 Ukraine Ivano-Frankivsk Oblast     181629 3476 0   48.9226 24.7111 2022-03-01 23:21:04 Ivano-Frankivsk Oblast, Ukraine
1737099 1737099 2022-05-20 Ukraine Donetsk Oblast     216052 5607 0   48.0159 37.8028 2022-03-01 23:21:04 Donetsk Oblast, Ukraine
1737098 1737098 2022-05-20 Ukraine Dnipropetrovsk Oblast     303551 9454 0   48.4647 35.0462 2022-03-01 23:21:04 Dnipropetrovsk Oblast, Ukraine
1737097 1737097 2022-05-20 Ukraine Crimea Republic*     157596 4866 0   45.2835 34.2008 2022-03-01 23:21:04 Crimea Republic*, Ukraine
1737096 1737096 2022-05-20 Ukraine Chernivtsi Oblast     150465 3290 0   48.2917 25.9352 2022-03-01 23:21:04 Chernivtsi Oblast, Ukraine
1737095 1737095 2022-05-20 Ukraine Chernihiv Oblast     126202 2751 0   51.4982 31.2893 2022-03-01 23:21:04 Chernihiv Oblast, Ukraine
1737094 1737094 2022-05-20 Ukraine Cherkasy Oblast     163768 2973 0   49.4444 32.0598 2022-03-01 23:21:04 Cherkasy Oblast, Ukraine
1737093 1737093 2022-05-20 Uganda       164153 3598 0   1.373333 32.290275 2022-05-21 04:20:58 Uganda
1737092 1737092 2022-05-20 US Wyoming Weston 56045 1588 18 0   43.83961191 -104.5674881 2022-05-21 04:20:58 Weston, Wyoming, US
1737091 1737091 2022-05-20 US Wyoming Washakie 56043 2363 44 0   43.90451606 -107.680187 2022-05-21 04:20:58 Washakie, Wyoming, US
1737090 1737090 2022-05-20 US Wyoming Unassigned 90056 0 0 0   44.79048913 -110.6563997 2022-05-21 04:20:58 Unassigned, Wyoming, US
1737089 1737089 2022-05-20 US Wyoming Uinta 56041 5647 39 0   41.2878183 -110.5475782 2022-05-21 04:20:58 Uinta, Wyoming, US
1737088 1737088 2022-05-20 US Wyoming Teton 56039 10116 16 0   43.93522482 -110.5890801 2022-05-21 04:20:58 Teton, Wyoming, US
1737087 1737087 2022-05-20 US Wyoming Sweetwater 56037 11119 126 0   41.65943896 -108.8827882 2022-05-21 04:20:58 Sweetwater, Wyoming, US
1737086 1737086 2022-05-20 US Wyoming Sublette 56035 1927 27 0   42.76558279 -109.9130922 2022-05-21 04:20:58 Sublette, Wyoming, US
1737085 1737085 2022-05-20 US Wyoming Sheridan 56033 8107 79 0   44.79048913 -106.8862389 2022-05-21 04:20:58 Sheridan, Wyoming, US
1737084 1737084 2022-05-20 US Wyoming Platte 56031 1916 41 0   42.13299116 -104.966331 2022-05-21 04:20:58 Platte, Wyoming, US
1737083 1737083 2022-05-20 US Wyoming Park 56029 6821 144 0   44.52157546 -109.5852825 2022-05-21 04:20:58 Park, Wyoming, US
1737082 1737082 2022-05-20 US Wyoming Niobrara 56027 701 10 0   43.05607708 -104.4758896 2022-05-21 04:20:58 Niobrara, Wyoming, US
1737081 1737081 2022-05-20 US Wyoming Natrona 56025 22422 273 0   42.96180148 -106.797885 2022-05-21 04:20:58 Natrona, Wyoming, US
1737080 1737080 2022-05-20 US Wyoming Lincoln 56023 3988 31 0   42.26376367 -110.6563997 2022-05-21 04:20:58 Lincoln, Wyoming, US
1737079 1737079 2022-05-20 US Wyoming Laramie 56021 26382 292 0   41.3070252 -104.6887497 2022-05-21 04:20:58 Laramie, Wyoming, US
1737078 1737078 2022-05-20 US Wyoming Johnson 56019 1848 19 0   44.04057166 -106.5845174 2022-05-21 04:20:58 Johnson, Wyoming, US
1737077 1737077 2022-05-20 US Wyoming Hot Springs 56017 1161 16 0   43.71930657 -108.4423174 2022-05-21 04:20:58 Hot Springs, Wyoming, US
1737076 1737076 2022-05-20 US Wyoming Goshen 56015 3648 57 0   42.08798185 -104.3534743 2022-05-21 04:20:58 Goshen, Wyoming, US
1737075 1737075 2022-05-20 US Wyoming Fremont 56013 13832 193 0   43.04183996 -108.6296893 2022-05-21 04:20:58 Fremont, Wyoming, US
1737074 1737074 2022-05-20 US Wyoming Crook 56011 1352 29 0   44.58855102 -104.5697705 2022-05-21 04:20:58 Crook, Wyoming, US
1737073 1737073 2022-05-20 US Wyoming Converse 56009 3147 55 0   42.97272268 -105.5081848 2022-05-21 04:20:58 Converse, Wyoming, US
1737072 1737072 2022-05-20 US Wyoming Carbon 56007 4631 52 0   41.69357844 -106.9326084 2022-05-21 04:20:58 Carbon, Wyoming, US
1737071 1737071 2022-05-20 US Wyoming Campbell 56005 12131 149 0   44.24886082 -105.5474404 2022-05-21 04:20:58 Campbell, Wyoming, US
1737070 1737070 2022-05-20 US Wyoming Big Horn 56003 2591 61 0   44.52405055 -107.9960365 2022-05-21 04:20:58 Big Horn, Wyoming, US
1737069 1737069 2022-05-20 US Wyoming Albany 56001 9971 49 0   41.65498705 -105.7235415 2022-05-21 04:20:58 Albany, Wyoming, US
1737068 1737068 2022-05-20 US Wisconsin Wood 55141 21666 234 0   44.45537896 -90.04158336 2022-05-21 04:20:58 Wood, Wisconsin, US
1737067 1737067 2022-05-20 US Wisconsin Winnebago 55139 53496 383 0   44.06886922 -88.64477096 2022-05-21 04:20:58 Winnebago, Wisconsin, US
1737066 1737066 2022-05-20 US Wisconsin Waushara 55137 6569 87 0   44.11324419 -89.24317107 2022-05-21 04:20:58 Waushara, Wisconsin, US
1737065 1737065 2022-05-20 US Wisconsin Waupaca 55135 13923 252 0   44.47068056 -88.96534501 2022-05-21 04:20:58 Waupaca, Wisconsin, US
1737064 1737064 2022-05-20 US Wisconsin Waukesha 55133 117133 1094 0   43.01833055 -88.30431188 2022-05-21 04:20:58 Waukesha, Wisconsin, US
1737063 1737063 2022-05-20 US Wisconsin Washington 55131 39345 343 0   43.36863664 -88.22974712 2022-05-21 04:20:58 Washington, Wisconsin, US
1737062 1737062 2022-05-20 US Wisconsin Washburn 55129 4125 46 0   45.89838588 -91.79050449 2022-05-21 04:20:58 Washburn, Wisconsin, US
1737061 1737061 2022-05-20 US Wisconsin Walworth 55127 27543 282 0   42.66858202 -88.54163073 2022-05-21 04:20:58 Walworth, Wisconsin, US
1737060 1737060 2022-05-20 US Wisconsin Vilas 55125 5299 89 0   46.05467334 -89.51719204 2022-05-21 04:20:58 Vilas, Wisconsin, US
1737059 1737059 2022-05-20 US Wisconsin Vernon 55123 6285 98 0   43.59422667 -90.8324691 2022-05-21 04:20:58 Vernon, Wisconsin, US
1737058 1737058 2022-05-20 US Wisconsin Unassigned 90055 0 0 0   46.52868768 0.0 2022-05-21 04:20:58 Unassigned, Wisconsin, US
1737057 1737057 2022-05-20 US Wisconsin Trempealeau 55121 8594 66 0   44.30360275 -91.35893614 2022-05-21 04:20:58 Trempealeau, Wisconsin, US
1737056 1737056 2022-05-20 US Wisconsin Taylor 55119 4899 72 0   45.21179252 -90.5004405 2022-05-21 04:20:58 Taylor, Wisconsin, US
1737055 1737055 2022-05-20 US Wisconsin St. Croix 55109 25873 151 0   45.03437474 -92.45000068 2022-05-21 04:20:58 St. Croix, Wisconsin, US
1737054 1737054 2022-05-20 US Wisconsin Sheboygan 55117 33316 322 0   43.72099677 -87.94579284 2022-05-21 04:20:58 Sheboygan, Wisconsin, US
1737053 1737053 2022-05-20 US Wisconsin Shawano 55115 12068 152 0   44.78902246 -88.76443896 2022-05-21 04:20:58 Shawano, Wisconsin, US
1737052 1737052 2022-05-20 US Wisconsin Sawyer 55113 4693 62 0   45.87931905 -91.14504927 2022-05-21 04:20:58 Sawyer, Wisconsin, US
1737051 1737051 2022-05-20 US Wisconsin Sauk 55111 16741 136 0   43.42574087 -89.94966132 2022-05-21 04:20:58 Sauk, Wisconsin, US
1737050 1737050 2022-05-20 US Wisconsin Rusk 55107 3485 55 0   45.47498854 -91.1333012 2022-05-21 04:20:58 Rusk, 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] TEXT,
   [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 · Queries took 2346.055ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette