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

4,006,353 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 254,491
  • Georgia 162,920
  • Virginia 135,590
  • Kentucky 121,675
  • Missouri 117,101
  • Kansas 105,758
  • Illinois 104,685
  • North Carolina 102,044
  • Iowa 100,603
  • Tennessee 98,183
  • Indiana 94,151
  • Nebraska 92,863
  • Ohio 90,027
  • Minnesota 88,465
  • Michigan 87,758
  • Mississippi 83,968
  • Oklahoma 79,376
  • Arkansas 76,709
  • Wisconsin 73,611
  • Puerto Rico 71,726
  • Alabama 69,765
  • Pennsylvania 68,850
  • Florida 68,836
  • Louisiana 66,723
  • South Dakota 66,362
  • Colorado 66,146
  • New York 64,046
  • California 59,941
  • West Virginia 56,193
  • Montana 54,982
  • …

country_or_region >30

  • US 3,284,537
  • Russia 78,307
  • Japan 46,430
  • China 34,865
  • India 34,605
  • Colombia 32,189
  • Mexico 31,389
  • Ukraine 26,597
  • Brazil 25,862
  • Peru 24,679
  • Italy 20,264
  • Sweden 19,824
  • United Kingdom 19,730
  • Spain 19,298
  • Malaysia 18,241
  • Germany 16,427
  • Chile 16,296
  • Canada 16,227
  • Netherlands 15,842
  • France 11,972
  • Belgium 9,618
  • Australia 8,420
  • Pakistan 6,636
  • New Zealand 3,188
  • Denmark 3,077
  • Mainland China 1,517
  • Antarctica 1,073
  • Kiribati 1,073
  • Korea, North 1,073
  • Nauru 1,073
  • …
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2756589 2756589 2022-12-29 Zimbabwe       259981 5637 0   -19.015438 29.154857 2022-12-30 04:21:04 Zimbabwe
2756588 2756588 2022-12-29 Zambia       334294 4023 0   -13.133897 27.849332 2022-12-30 04:21:04 Zambia
2756587 2756587 2022-12-29 Yemen       11945 2159 0   15.552727 48.516388 2022-12-30 04:21:04 Yemen
2756586 2756586 2022-12-29 Winter Olympics 2022       535 0 0   39.9042 116.4074 2022-12-30 04:21:04 Winter Olympics 2022
2756585 2756585 2022-12-29 West Bank and Gaza       703228 5708 0   31.9522 35.2332 2022-12-30 04:21:04 West Bank and Gaza
2756584 2756584 2022-12-29 Vietnam       11525013 43184 0   14.058324 108.277199 2022-12-30 04:21:04 Vietnam
2756583 2756583 2022-12-29 Venezuela       550388 5831 0   6.4238 -66.5897 2022-12-30 04:21:04 Venezuela
2756582 2756582 2022-12-29 Vanuatu       12013 14 0   -15.3767 166.9592 2022-12-30 04:21:04 Vanuatu
2756581 2756581 2022-12-29 Uzbekistan       249217 1637 0   41.377491 64.585262 2022-12-30 04:21:04 Uzbekistan
2756580 2756580 2022-12-29 Uruguay       1011988 7562 0   -32.5228 -55.7658 2022-12-30 04:21:04 Uruguay
2756579 2756579 2022-12-29 United Kingdom Wales     892752 11108 0   52.1307 -3.7837 2022-12-30 04:21:04 Wales, United Kingdom
2756578 2756578 2022-12-29 United Kingdom Unknown     0 326 0   55.3781 -3.436 2022-12-30 04:21:04 Unknown, United Kingdom
2756577 2756577 2022-12-29 United Kingdom Turks and Caicos Islands     6479 36 0   21.694 -71.7979 2022-12-30 04:21:04 Turks and Caicos Islands, United Kingdom
2756576 2756576 2022-12-29 United Kingdom Scotland     2136695 16187 0   56.4907 -4.2026 2022-12-30 04:21:04 Scotland, United Kingdom
2756575 2756575 2022-12-29 United Kingdom Saint Helena, Ascension and Tristan da Cunha     2166 0 0   -7.9467 -14.3559 2022-12-26 23:21:06 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
2756574 2756574 2022-12-29 United Kingdom Pitcairn Islands     4 0 0   -24.3768 -128.3242 2022-12-30 04:21:04 Pitcairn Islands, United Kingdom
2756573 2756573 2022-12-29 United Kingdom Northern Ireland     713294 4986 0   54.7877 -6.4923 2022-12-30 04:21:04 Northern Ireland, United Kingdom
2756572 2756572 2022-12-29 United Kingdom Montserrat     1403 8 0   16.742498 -62.187366 2022-12-30 04:21:04 Montserrat, United Kingdom
2756571 2756571 2022-12-29 United Kingdom Jersey     65130 146 0   49.2138 -2.1358 2022-12-30 04:21:04 Jersey, United Kingdom
2756570 2756570 2022-12-29 United Kingdom Isle of Man     38008 116 0   54.2361 -4.5481 2022-12-30 04:21:04 Isle of Man, United Kingdom
2756569 2756569 2022-12-29 United Kingdom Guernsey     33910 66 0   49.448196 -2.58949 2022-12-30 04:21:04 Guernsey, United Kingdom
2756568 2756568 2022-12-29 United Kingdom Gibraltar     20275 110 0   36.1408 -5.3536 2022-12-30 04:21:04 Gibraltar, United Kingdom
2756567 2756567 2022-12-29 United Kingdom Falkland Islands (Malvinas)     1930 0 0   -51.7963 -59.5236 2022-12-30 04:21:04 Falkland Islands (Malvinas), United Kingdom
2756566 2756566 2022-12-29 United Kingdom England     20392339 180642 0   52.3555 -1.1743 2022-12-30 04:21:04 England, United Kingdom
2756565 2756565 2022-12-29 United Kingdom Channel Islands     0 0 0   49.3723 -2.3644 2022-12-30 04:21:04 Channel Islands, United Kingdom
2756564 2756564 2022-12-29 United Kingdom Cayman Islands     31472 37 0   19.3133 -81.2546 2022-12-30 04:21:04 Cayman Islands, United Kingdom
2756563 2756563 2022-12-29 United Kingdom British Virgin Islands     7305 64 0   18.4207 -64.64 2022-12-30 04:21:04 British Virgin Islands, United Kingdom
2756562 2756562 2022-12-29 United Kingdom Bermuda     18622 153 0   32.3078 -64.7505 2022-12-30 04:21:04 Bermuda, United Kingdom
2756561 2756561 2022-12-29 United Kingdom Anguilla     3904 12 0   18.2206 -63.0686 2022-12-30 04:21:04 Anguilla, United Kingdom
2756560 2756560 2022-12-29 United Arab Emirates       1046850 2348 0   23.424076 53.847818 2022-12-30 04:21:04 United Arab Emirates
2756559 2756559 2022-12-29 Ukraine Zhytomyr Oblast     192801 3538 0   50.2547 28.6587 2022-12-30 04:21:04 Zhytomyr Oblast, Ukraine
2756558 2756558 2022-12-29 Ukraine Zaporizhia Oblast     215070 5866 0   47.8388 35.1396 2022-12-30 04:21:04 Zaporizhia Oblast, Ukraine
2756557 2756557 2022-12-29 Ukraine Zakarpattia Oblast     112462 2724 0   48.6208 22.2879 2022-12-30 04:21:04 Zakarpattia Oblast, Ukraine
2756556 2756556 2022-12-29 Ukraine Volyn Oblast     132045 2394 0   50.7472 25.3254 2022-12-30 04:21:04 Volyn Oblast, Ukraine
2756555 2756555 2022-12-29 Ukraine Vinnytsia Oblast     149845 3546 0   49.2331 28.4682 2022-12-30 04:21:04 Vinnytsia Oblast, Ukraine
2756554 2756554 2022-12-29 Ukraine Unknown     545114 5261 0       2022-12-30 04:21:04 Unknown, Ukraine
2756553 2756553 2022-12-29 Ukraine Ternopil Oblast     146363 2391 0   49.5535 25.5948 2022-12-30 04:21:04 Ternopil Oblast, Ukraine
2756552 2756552 2022-12-29 Ukraine Sumy Oblast     182268 3208 0   50.9077 34.7981 2022-12-30 04:21:04 Sumy Oblast, Ukraine
2756551 2756551 2022-12-29 Ukraine Sevastopol*     97198 2510 0   44.6054 33.522 2022-12-30 04:21:04 Sevastopol*, Ukraine
2756550 2756550 2022-12-29 Ukraine Rivne Oblast     171031 2530 0   50.6199 26.2516 2022-12-30 04:21:04 Rivne Oblast, Ukraine
2756549 2756549 2022-12-29 Ukraine Poltava Oblast     179994 4181 0   49.5883 34.5514 2022-12-30 04:21:04 Poltava Oblast, Ukraine
2756548 2756548 2022-12-29 Ukraine Odessa Oblast     325462 5917 0   46.4846 30.7326 2022-12-30 04:21:04 Odessa Oblast, Ukraine
2756547 2756547 2022-12-29 Ukraine Mykolaiv Oblast     146174 3530 0   46.975 31.9946 2022-12-30 04:21:04 Mykolaiv Oblast, Ukraine
2756546 2756546 2022-12-29 Ukraine Lviv Oblast     303357 6569 0   49.8397 24.0297 2022-12-30 04:21:04 Lviv Oblast, Ukraine
2756545 2756545 2022-12-29 Ukraine Luhansk Oblast     80033 2392 0   48.574 39.3078 2022-12-30 04:21:04 Luhansk Oblast, Ukraine
2756544 2756544 2022-12-29 Ukraine Kirovohrad Oblast     45117 1741 0   48.5079 32.2623 2022-12-30 04:21:04 Kirovohrad Oblast, Ukraine
2756543 2756543 2022-12-29 Ukraine Kiev Oblast     226220 5019 0   50.053 30.7667 2022-12-30 04:21:04 Kiev Oblast, Ukraine
2756542 2756542 2022-12-29 Ukraine Kiev     445098 8966 0   50.4501 30.5234 2022-12-30 04:21:04 Kiev, Ukraine
2756541 2756541 2022-12-29 Ukraine Khmelnytskyi Oblast     201270 3703 0   49.423 26.9871 2022-12-30 04:21:04 Khmelnytskyi Oblast, Ukraine
2756540 2756540 2022-12-29 Ukraine Kherson Oblast     107686 2881 0   46.6354 32.6169 2022-12-30 04:21:04 Kherson Oblast, Ukraine
2756539 2756539 2022-12-29 Ukraine Kharkiv Oblast     305661 6858 0   49.9935 36.2304 2022-12-30 04:21:04 Kharkiv Oblast, Ukraine
2756538 2756538 2022-12-29 Ukraine Ivano-Frankivsk Oblast     181629 3476 0   48.9226 24.7111 2022-12-30 04:21:04 Ivano-Frankivsk Oblast, Ukraine
2756537 2756537 2022-12-29 Ukraine Donetsk Oblast     216052 5607 0   48.0159 37.8028 2022-12-30 04:21:04 Donetsk Oblast, Ukraine
2756536 2756536 2022-12-29 Ukraine Dnipropetrovsk Oblast     303551 9454 0   48.4647 35.0462 2022-12-30 04:21:04 Dnipropetrovsk Oblast, Ukraine
2756535 2756535 2022-12-29 Ukraine Crimea Republic*     210676 5412 0   45.2835 34.2008 2022-12-30 04:21:04 Crimea Republic*, Ukraine
2756534 2756534 2022-12-29 Ukraine Chernivtsi Oblast     150465 3290 0   48.2917 25.9352 2022-12-30 04:21:04 Chernivtsi Oblast, Ukraine
2756533 2756533 2022-12-29 Ukraine Chernihiv Oblast     126202 2751 0   51.4982 31.2893 2022-12-30 04:21:04 Chernihiv Oblast, Ukraine
2756532 2756532 2022-12-29 Ukraine Cherkasy Oblast     163768 2973 0   49.4444 32.0598 2022-12-30 04:21:04 Cherkasy Oblast, Ukraine
2756531 2756531 2022-12-29 Uganda       169985 3630 0   1.373333 32.290275 2022-12-30 04:21:04 Uganda
2756530 2756530 2022-12-29 US Wyoming Weston 56045 1880 22 0   43.83961191 -104.5674881 2022-12-30 04:21:04 Weston, Wyoming, US
2756529 2756529 2022-12-29 US Wyoming Washakie 56043 2722 47 0   43.90451606 -107.680187 2022-12-30 04:21:04 Washakie, Wyoming, US
2756528 2756528 2022-12-29 US Wyoming Unassigned 90056 0 0 0   44.79048913 -110.6563997 2022-12-30 04:21:04 Unassigned, Wyoming, US
2756527 2756527 2022-12-29 US Wyoming Uinta 56041 6305 43 0   41.2878183 -110.5475782 2022-12-30 04:21:04 Uinta, Wyoming, US
2756526 2756526 2022-12-29 US Wyoming Teton 56039 12010 16 0   43.93522482 -110.5890801 2022-12-30 04:21:04 Teton, Wyoming, US
2756525 2756525 2022-12-29 US Wyoming Sweetwater 56037 12410 136 0   41.65943896 -108.8827882 2022-12-30 04:21:04 Sweetwater, Wyoming, US
2756524 2756524 2022-12-29 US Wyoming Sublette 56035 2295 28 0   42.76558279 -109.9130922 2022-12-30 04:21:04 Sublette, Wyoming, US
2756523 2756523 2022-12-29 US Wyoming Sheridan 56033 9723 86 0   44.79048913 -106.8862389 2022-12-30 04:21:04 Sheridan, Wyoming, US
2756522 2756522 2022-12-29 US Wyoming Platte 56031 2247 44 0   42.13299116 -104.966331 2022-12-30 04:21:04 Platte, Wyoming, US
2756521 2756521 2022-12-29 US Wyoming Park 56029 7611 151 0   44.52157546 -109.5852825 2022-12-30 04:21:04 Park, Wyoming, US
2756520 2756520 2022-12-29 US Wyoming Niobrara 56027 858 11 0   43.05607708 -104.4758896 2022-12-30 04:21:04 Niobrara, Wyoming, US
2756519 2756519 2022-12-29 US Wyoming Natrona 56025 25543 298 0   42.96180148 -106.797885 2022-12-30 04:21:04 Natrona, Wyoming, US
2756518 2756518 2022-12-29 US Wyoming Lincoln 56023 4849 35 0   42.26376367 -110.6563997 2022-12-30 04:21:04 Lincoln, Wyoming, US
2756517 2756517 2022-12-29 US Wyoming Laramie 56021 31151 318 0   41.3070252 -104.6887497 2022-12-30 04:21:04 Laramie, Wyoming, US
2756516 2756516 2022-12-29 US Wyoming Johnson 56019 2310 21 0   44.04057166 -106.5845174 2022-12-30 04:21:04 Johnson, Wyoming, US
2756515 2756515 2022-12-29 US Wyoming Hot Springs 56017 1425 20 0   43.71930657 -108.4423174 2022-12-30 04:21:04 Hot Springs, Wyoming, US
2756514 2756514 2022-12-29 US Wyoming Goshen 56015 4588 62 0   42.08798185 -104.3534743 2022-12-30 04:21:04 Goshen, Wyoming, US
2756513 2756513 2022-12-29 US Wyoming Fremont 56013 16633 203 0   43.04183996 -108.6296893 2022-12-30 04:21:04 Fremont, Wyoming, US
2756512 2756512 2022-12-29 US Wyoming Crook 56011 1544 31 0   44.58855102 -104.5697705 2022-12-30 04:21:04 Crook, Wyoming, US
2756511 2756511 2022-12-29 US Wyoming Converse 56009 3640 57 0   42.97272268 -105.5081848 2022-12-30 04:21:04 Converse, Wyoming, US
2756510 2756510 2022-12-29 US Wyoming Carbon 56007 4975 55 0   41.69357844 -106.9326084 2022-12-30 04:21:04 Carbon, Wyoming, US
2756509 2756509 2022-12-29 US Wyoming Campbell 56005 13666 156 0   44.24886082 -105.5474404 2022-12-30 04:21:04 Campbell, Wyoming, US
2756508 2756508 2022-12-29 US Wyoming Big Horn 56003 3046 64 0   44.52405055 -107.9960365 2022-12-30 04:21:04 Big Horn, Wyoming, US
2756507 2756507 2022-12-29 US Wyoming Albany 56001 11416 54 0   41.65498705 -105.7235415 2022-12-30 04:21:04 Albany, Wyoming, US
2756506 2756506 2022-12-29 US Wisconsin Wood 55141 26240 258 0   44.45537896 -90.04158336 2022-12-30 04:21:04 Wood, Wisconsin, US
2756505 2756505 2022-12-29 US Wisconsin Winnebago 55139 62617 410 0   44.06886922 -88.64477096 2022-12-30 04:21:04 Winnebago, Wisconsin, US
2756504 2756504 2022-12-29 US Wisconsin Waushara 55137 7535 92 0   44.11324419 -89.24317107 2022-12-30 04:21:04 Waushara, Wisconsin, US
2756503 2756503 2022-12-29 US Wisconsin Waupaca 55135 16073 262 0   44.47068056 -88.96534501 2022-12-30 04:21:04 Waupaca, Wisconsin, US
2756502 2756502 2022-12-29 US Wisconsin Waukesha 55133 136875 1205 0   43.01833055 -88.30431188 2022-12-30 04:21:04 Waukesha, Wisconsin, US
2756501 2756501 2022-12-29 US Wisconsin Washington 55131 45890 359 0   43.36863664 -88.22974712 2022-12-30 04:21:04 Washington, Wisconsin, US
2756500 2756500 2022-12-29 US Wisconsin Washburn 55129 4925 51 0   45.89838588 -91.79050449 2022-12-30 04:21:04 Washburn, Wisconsin, US
2756499 2756499 2022-12-29 US Wisconsin Walworth 55127 32581 300 0   42.66858202 -88.54163073 2022-12-30 04:21:04 Walworth, Wisconsin, US
2756498 2756498 2022-12-29 US Wisconsin Vilas 55125 6369 103 0   46.05467334 -89.51719204 2022-12-30 04:21:04 Vilas, Wisconsin, US
2756497 2756497 2022-12-29 US Wisconsin Vernon 55123 7484 115 0   43.59422667 -90.8324691 2022-12-30 04:21:04 Vernon, Wisconsin, US
2756496 2756496 2022-12-29 US Wisconsin Unassigned 90055 0 0 0   46.52868768 0.0 2022-12-30 04:21:04 Unassigned, Wisconsin, US
2756495 2756495 2022-12-29 US Wisconsin Trempealeau 55121 9740 72 0   44.30360275 -91.35893614 2022-12-30 04:21:04 Trempealeau, Wisconsin, US
2756494 2756494 2022-12-29 US Wisconsin Taylor 55119 5671 78 0   45.21179252 -90.5004405 2022-12-30 04:21:04 Taylor, Wisconsin, US
2756493 2756493 2022-12-29 US Wisconsin St. Croix 55109 30166 160 0   45.03437474 -92.45000068 2022-12-30 04:21:04 St. Croix, Wisconsin, US
2756492 2756492 2022-12-29 US Wisconsin Sheboygan 55117 38729 352 0   43.72099677 -87.94579284 2022-12-30 04:21:04 Sheboygan, Wisconsin, US
2756491 2756491 2022-12-29 US Wisconsin Shawano 55115 13908 163 0   44.78902246 -88.76443896 2022-12-30 04:21:04 Shawano, Wisconsin, US
2756490 2756490 2022-12-29 US Wisconsin Sawyer 55113 5855 66 0   45.87931905 -91.14504927 2022-12-30 04:21:04 Sawyer, 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 2041.962ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette