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,467,892 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 >30

  • Texas 220,576
  • Georgia 141,507
  • Virginia 117,768
  • Kentucky 105,582
  • Missouri 101,540
  • Kansas 91,527
  • Illinois 90,853
  • North Carolina 88,611
  • Iowa 87,303
  • Tennessee 85,282
  • Indiana 81,782
  • Nebraska 80,361
  • Ohio 78,190
  • Minnesota 76,761
  • Michigan 76,187
  • Mississippi 72,929
  • Oklahoma 68,869
  • Arkansas 66,601
  • Wisconsin 63,902
  • Puerto Rico 61,086
  • Alabama 60,588
  • Pennsylvania 59,806
  • Florida 59,792
  • Louisiana 57,945
  • South Dakota 57,451
  • Colorado 57,368
  • New York 55,534
  • California 51,961
  • West Virginia 48,745
  • Montana 47,401
  • …

country_or_region >30

  • US 2,848,430
  • Russia 67,268
  • Japan 39,913
  • China 30,343
  • India 29,684
  • Colombia 27,667
  • Mexico 27,000
  • Ukraine 22,873
  • Brazil 22,271
  • Peru 21,221
  • Italy 17,471
  • Sweden 17,031
  • Spain 16,638
  • Malaysia 15,980
  • United Kingdom 15,650
  • Germany 14,166
  • Canada 14,099
  • Chile 14,035
  • Netherlands 13,581
  • France 10,376
  • Belgium 8,022
  • Australia 7,356
  • Pakistan 5,705
  • Denmark 2,678
  • New Zealand 1,849
  • Mainland China 1,517
  • Antarctica 940
  • Kiribati 940
  • Korea, North 940
  • Palau 940
  • …
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
651259 651259 2022-08-18 Zimbabwe       256579 5589 0   -19.015438 29.154857 2022-08-19 04:20:54 Zimbabwe
651258 651258 2022-08-18 Zambia       332264 4016 0   -13.133897 27.849332 2022-08-19 04:20:54 Zambia
651257 651257 2022-08-18 Yemen       11914 2152 0   15.552727 48.516388 2022-08-19 04:20:54 Yemen
651256 651256 2022-08-18 Winter Olympics 2022       535 0 0   39.9042 116.4074 2022-08-19 04:20:54 Winter Olympics 2022
651255 651255 2022-08-18 West Bank and Gaza       697447 5691 0   31.9522 35.2332 2022-08-19 04:20:54 West Bank and Gaza
651254 651254 2022-08-18 Vietnam       11376571 43103 0   14.058324 108.277199 2022-08-19 04:20:54 Vietnam
651253 651253 2022-08-18 Venezuela       540796 5781 0   6.4238 -66.5897 2022-08-19 04:20:54 Venezuela
651252 651252 2022-08-18 Vanuatu       11753 14 0   -15.3767 166.9592 2022-08-19 04:20:54 Vanuatu
651251 651251 2022-08-18 Uzbekistan       243623 1637 0   41.377491 64.585262 2022-08-19 04:20:54 Uzbekistan
651250 651250 2022-08-18 Uruguay       975264 7429 0   -32.5228 -55.7658 2022-08-19 04:20:54 Uruguay
651249 651249 2022-08-18 United Kingdom Wales     883018 7739 0   52.1307 -3.7837 2022-08-19 04:20:54 Wales, United Kingdom
651248 651248 2022-08-18 United Kingdom Unknown     0 0 0       2022-08-19 04:20:54 Unknown, United Kingdom
651247 651247 2022-08-18 United Kingdom Turks and Caicos Islands     6351 36 0   21.694 -71.7979 2022-08-19 04:20:54 Turks and Caicos Islands, United Kingdom
651246 651246 2022-08-18 United Kingdom Scotland     2083741 12389 0   56.4907 -4.2026 2022-08-19 04:20:54 Scotland, United Kingdom
651245 651245 2022-08-18 United Kingdom Saint Helena, Ascension and Tristan da Cunha     4 0 0   -7.9467 -14.3559 2022-08-19 04:20:54 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
651244 651244 2022-08-18 United Kingdom Northern Ireland     713294 3445 0   54.7877 -6.4923 2022-08-19 04:20:54 Northern Ireland, United Kingdom
651243 651243 2022-08-18 United Kingdom Montserrat     1106 8 0   16.742498 -62.187366 2022-08-19 04:20:54 Montserrat, United Kingdom
651242 651242 2022-08-18 United Kingdom Jersey     58536 135 0   49.2138 -2.1358 2022-08-19 04:20:54 Jersey, United Kingdom
651241 651241 2022-08-18 United Kingdom Isle of Man     37794 115 0   54.2361 -4.5481 2022-08-19 04:20:54 Isle of Man, United Kingdom
651240 651240 2022-08-18 United Kingdom Guernsey     30519 62 0   49.448196 -2.58949 2022-08-19 04:20:54 Guernsey, United Kingdom
651239 651239 2022-08-18 United Kingdom Gibraltar     20049 107 0   36.1408 -5.3536 2022-08-19 04:20:54 Gibraltar, United Kingdom
651238 651238 2022-08-18 United Kingdom Falkland Islands (Malvinas)     1881 0 0   -51.7963 -59.5236 2022-08-19 04:20:54 Falkland Islands (Malvinas), United Kingdom
651237 651237 2022-08-18 United Kingdom England     19780734 163445 0   52.3555 -1.1743 2022-08-19 04:20:54 England, United Kingdom
651236 651236 2022-08-18 United Kingdom Channel Islands     0 0 0   49.3723 -2.3644 2022-08-19 04:20:54 Channel Islands, United Kingdom
651235 651235 2022-08-18 United Kingdom Cayman Islands     29907 29 0   19.3133 -81.2546 2022-08-19 04:20:54 Cayman Islands, United Kingdom
651234 651234 2022-08-18 United Kingdom British Virgin Islands     7131 63 0   18.4207 -64.64 2022-08-19 04:20:54 British Virgin Islands, United Kingdom
651233 651233 2022-08-18 United Kingdom Bermuda     17674 148 0   32.3078 -64.7505 2022-08-19 04:20:54 Bermuda, United Kingdom
651232 651232 2022-08-18 United Kingdom Anguilla     3746 10 0   18.2206 -63.0686 2022-08-19 04:20:54 Anguilla, United Kingdom
651231 651231 2022-08-18 United Arab Emirates       1007742 2341 0   23.424076 53.847818 2022-08-19 04:20:54 United Arab Emirates
651230 651230 2022-08-18 Ukraine Zhytomyr Oblast     192801 3538 0   50.2547 28.6587 2022-08-19 04:20:54 Zhytomyr Oblast, Ukraine
651229 651229 2022-08-18 Ukraine Zaporizhia Oblast     215070 5866 0   47.8388 35.1396 2022-08-19 04:20:54 Zaporizhia Oblast, Ukraine
651228 651228 2022-08-18 Ukraine Zakarpattia Oblast     112462 2724 0   48.6208 22.2879 2022-08-19 04:20:54 Zakarpattia Oblast, Ukraine
651227 651227 2022-08-18 Ukraine Volyn Oblast     132045 2394 0   50.7472 25.3254 2022-08-19 04:20:54 Volyn Oblast, Ukraine
651226 651226 2022-08-18 Ukraine Vinnytsia Oblast     149845 3546 0   49.2331 28.4682 2022-08-19 04:20:54 Vinnytsia Oblast, Ukraine
651225 651225 2022-08-18 Ukraine Unknown     220765 3238 0       2022-08-19 04:20:54 Unknown, Ukraine
651224 651224 2022-08-18 Ukraine Ternopil Oblast     146363 2391 0   49.5535 25.5948 2022-08-19 04:20:54 Ternopil Oblast, Ukraine
651223 651223 2022-08-18 Ukraine Sumy Oblast     182268 3208 0   50.9077 34.7981 2022-08-19 04:20:54 Sumy Oblast, Ukraine
651222 651222 2022-08-18 Ukraine Sevastopol*     87181 2415 0   44.6054 33.522 2022-08-19 04:20:54 Sevastopol*, Ukraine
651221 651221 2022-08-18 Ukraine Rivne Oblast     171031 2530 0   50.6199 26.2516 2022-08-19 04:20:54 Rivne Oblast, Ukraine
651220 651220 2022-08-18 Ukraine Poltava Oblast     179994 4181 0   49.5883 34.5514 2022-08-19 04:20:54 Poltava Oblast, Ukraine
651219 651219 2022-08-18 Ukraine Odessa Oblast     325462 5917 0   46.4846 30.7326 2022-08-19 04:20:54 Odessa Oblast, Ukraine
651218 651218 2022-08-18 Ukraine Mykolaiv Oblast     146174 3530 0   46.975 31.9946 2022-08-19 04:20:54 Mykolaiv Oblast, Ukraine
651217 651217 2022-08-18 Ukraine Lviv Oblast     303357 6569 0   49.8397 24.0297 2022-08-19 04:20:54 Lviv Oblast, Ukraine
651216 651216 2022-08-18 Ukraine Luhansk Oblast     80033 2392 0   48.574 39.3078 2022-08-19 04:20:54 Luhansk Oblast, Ukraine
651215 651215 2022-08-18 Ukraine Kirovohrad Oblast     45117 1741 0   48.5079 32.2623 2022-08-19 04:20:54 Kirovohrad Oblast, Ukraine
651214 651214 2022-08-18 Ukraine Kiev Oblast     226220 5019 0   50.053 30.7667 2022-08-19 04:20:54 Kiev Oblast, Ukraine
651213 651213 2022-08-18 Ukraine Kiev     445098 8966 0   50.4501 30.5234 2022-08-19 04:20:54 Kiev, Ukraine
651212 651212 2022-08-18 Ukraine Khmelnytskyi Oblast     201270 3703 0   49.423 26.9871 2022-08-19 04:20:54 Khmelnytskyi Oblast, Ukraine
651211 651211 2022-08-18 Ukraine Kherson Oblast     107686 2881 0   46.6354 32.6169 2022-08-19 04:20:54 Kherson Oblast, Ukraine
651210 651210 2022-08-18 Ukraine Kharkiv Oblast     305661 6858 0   49.9935 36.2304 2022-08-19 04:20:54 Kharkiv Oblast, Ukraine
651209 651209 2022-08-18 Ukraine Ivano-Frankivsk Oblast     181629 3476 0   48.9226 24.7111 2022-08-19 04:20:54 Ivano-Frankivsk Oblast, Ukraine
651208 651208 2022-08-18 Ukraine Donetsk Oblast     216052 5607 0   48.0159 37.8028 2022-08-19 04:20:54 Donetsk Oblast, Ukraine
651207 651207 2022-08-18 Ukraine Dnipropetrovsk Oblast     303551 9454 0   48.4647 35.0462 2022-08-19 04:20:54 Dnipropetrovsk Oblast, Ukraine
651206 651206 2022-08-18 Ukraine Crimea Republic*     189143 5353 0   45.2835 34.2008 2022-08-19 04:20:54 Crimea Republic*, Ukraine
651205 651205 2022-08-18 Ukraine Chernivtsi Oblast     150465 3290 0   48.2917 25.9352 2022-08-19 04:20:54 Chernivtsi Oblast, Ukraine
651204 651204 2022-08-18 Ukraine Chernihiv Oblast     126202 2751 0   51.4982 31.2893 2022-08-19 04:20:54 Chernihiv Oblast, Ukraine
651203 651203 2022-08-18 Ukraine Cherkasy Oblast     163768 2973 0   49.4444 32.0598 2022-08-19 04:20:54 Cherkasy Oblast, Ukraine
651202 651202 2022-08-18 Uganda       169396 3628 0   1.373333 32.290275 2022-08-19 04:20:54 Uganda
651201 651201 2022-08-18 US Wyoming Weston 56045 1765 20 0   43.83961191 -104.5674881 2022-08-19 04:20:54 Weston, Wyoming, US
651200 651200 2022-08-18 US Wyoming Washakie 56043 2598 47 0   43.90451606 -107.680187 2022-08-19 04:20:54 Washakie, Wyoming, US
651199 651199 2022-08-18 US Wyoming Unassigned 90056 0 0 0   44.79048913 -110.6563997 2022-08-19 04:20:54 Unassigned, Wyoming, US
651198 651198 2022-08-18 US Wyoming Uinta 56041 6036 40 0   41.2878183 -110.5475782 2022-08-19 04:20:54 Uinta, Wyoming, US
651197 651197 2022-08-18 US Wyoming Teton 56039 11439 16 0   43.93522482 -110.5890801 2022-08-19 04:20:54 Teton, Wyoming, US
651196 651196 2022-08-18 US Wyoming Sweetwater 56037 11982 129 0   41.65943896 -108.8827882 2022-08-19 04:20:54 Sweetwater, Wyoming, US
651195 651195 2022-08-18 US Wyoming Sublette 56035 2150 27 0   42.76558279 -109.9130922 2022-08-19 04:20:54 Sublette, Wyoming, US
651194 651194 2022-08-18 US Wyoming Sheridan 56033 9073 81 0   44.79048913 -106.8862389 2022-08-19 04:20:54 Sheridan, Wyoming, US
651193 651193 2022-08-18 US Wyoming Platte 56031 2114 42 0   42.13299116 -104.966331 2022-08-19 04:20:54 Platte, Wyoming, US
651192 651192 2022-08-18 US Wyoming Park 56029 7319 149 0   44.52157546 -109.5852825 2022-08-19 04:20:54 Park, Wyoming, US
651191 651191 2022-08-18 US Wyoming Niobrara 56027 747 10 0   43.05607708 -104.4758896 2022-08-19 04:20:54 Niobrara, Wyoming, US
651190 651190 2022-08-18 US Wyoming Natrona 56025 24215 281 0   42.96180148 -106.797885 2022-08-19 04:20:54 Natrona, Wyoming, US
651189 651189 2022-08-18 US Wyoming Lincoln 56023 4594 32 0   42.26376367 -110.6563997 2022-08-19 04:20:54 Lincoln, Wyoming, US
651188 651188 2022-08-18 US Wyoming Laramie 56021 29549 302 0   41.3070252 -104.6887497 2022-08-19 04:20:54 Laramie, Wyoming, US
651187 651187 2022-08-18 US Wyoming Johnson 56019 2123 20 0   44.04057166 -106.5845174 2022-08-19 04:20:54 Johnson, Wyoming, US
651186 651186 2022-08-18 US Wyoming Hot Springs 56017 1325 18 0   43.71930657 -108.4423174 2022-08-19 04:20:54 Hot Springs, Wyoming, US
651185 651185 2022-08-18 US Wyoming Goshen 56015 4313 57 0   42.08798185 -104.3534743 2022-08-19 04:20:54 Goshen, Wyoming, US
651184 651184 2022-08-18 US Wyoming Fremont 56013 15575 197 0   43.04183996 -108.6296893 2022-08-19 04:20:54 Fremont, Wyoming, US
651183 651183 2022-08-18 US Wyoming Crook 56011 1460 29 0   44.58855102 -104.5697705 2022-08-19 04:20:54 Crook, Wyoming, US
651182 651182 2022-08-18 US Wyoming Converse 56009 3398 56 0   42.97272268 -105.5081848 2022-08-19 04:20:54 Converse, Wyoming, US
651181 651181 2022-08-18 US Wyoming Carbon 56007 4829 53 0   41.69357844 -106.9326084 2022-08-19 04:20:54 Carbon, Wyoming, US
651180 651180 2022-08-18 US Wyoming Campbell 56005 13123 150 0   44.24886082 -105.5474404 2022-08-19 04:20:54 Campbell, Wyoming, US
651179 651179 2022-08-18 US Wyoming Big Horn 56003 2868 64 0   44.52405055 -107.9960365 2022-08-19 04:20:54 Big Horn, Wyoming, US
651178 651178 2022-08-18 US Wyoming Albany 56001 10892 51 0   41.65498705 -105.7235415 2022-08-19 04:20:54 Albany, Wyoming, US
651177 651177 2022-08-18 US Wisconsin Wood 55141 24163 243 0   44.45537896 -90.04158336 2022-08-19 04:20:54 Wood, Wisconsin, US
651176 651176 2022-08-18 US Wisconsin Winnebago 55139 58034 397 0   44.06886922 -88.64477096 2022-08-19 04:20:54 Winnebago, Wisconsin, US
651175 651175 2022-08-18 US Wisconsin Waushara 55137 7022 87 0   44.11324419 -89.24317107 2022-08-19 04:20:54 Waushara, Wisconsin, US
651174 651174 2022-08-18 US Wisconsin Waupaca 55135 14885 257 0   44.47068056 -88.96534501 2022-08-19 04:20:54 Waupaca, Wisconsin, US
651173 651173 2022-08-18 US Wisconsin Waukesha 55133 127823 1139 0   43.01833055 -88.30431188 2022-08-19 04:20:54 Waukesha, Wisconsin, US
651172 651172 2022-08-18 US Wisconsin Washington 55131 42714 348 0   43.36863664 -88.22974712 2022-08-19 04:20:54 Washington, Wisconsin, US
651171 651171 2022-08-18 US Wisconsin Washburn 55129 4555 47 0   45.89838588 -91.79050449 2022-08-19 04:20:54 Washburn, Wisconsin, US
651170 651170 2022-08-18 US Wisconsin Walworth 55127 29783 290 0   42.66858202 -88.54163073 2022-08-19 04:20:54 Walworth, Wisconsin, US
651169 651169 2022-08-18 US Wisconsin Vilas 55125 5898 91 0   46.05467334 -89.51719204 2022-08-19 04:20:54 Vilas, Wisconsin, US
651168 651168 2022-08-18 US Wisconsin Vernon 55123 6912 104 0   43.59422667 -90.8324691 2022-08-19 04:20:54 Vernon, Wisconsin, US
651167 651167 2022-08-18 US Wisconsin Unassigned 90055 0 0 0   46.52868768 0.0 2022-08-19 04:20:54 Unassigned, Wisconsin, US
651166 651166 2022-08-18 US Wisconsin Trempealeau 55121 9167 67 0   44.30360275 -91.35893614 2022-08-19 04:20:54 Trempealeau, Wisconsin, US
651165 651165 2022-08-18 US Wisconsin Taylor 55119 5258 73 0   45.21179252 -90.5004405 2022-08-19 04:20:54 Taylor, Wisconsin, US
651164 651164 2022-08-18 US Wisconsin St. Croix 55109 28037 155 0   45.03437474 -92.45000068 2022-08-19 04:20:54 St. Croix, Wisconsin, US
651163 651163 2022-08-18 US Wisconsin Sheboygan 55117 36201 339 0   43.72099677 -87.94579284 2022-08-19 04:20:54 Sheboygan, Wisconsin, US
651162 651162 2022-08-18 US Wisconsin Shawano 55115 12813 156 0   44.78902246 -88.76443896 2022-08-19 04:20:54 Shawano, Wisconsin, US
651161 651161 2022-08-18 US Wisconsin Sawyer 55113 5336 63 0   45.87931905 -91.14504927 2022-08-19 04:20:54 Sawyer, Wisconsin, US
651160 651160 2022-08-18 US Wisconsin Sauk 55111 18502 140 0   43.42574087 -89.94966132 2022-08-19 04:20:54 Sauk, 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]);
Powered by Datasette · Queries took 3007.907ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette