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

507,912 rows sorted by day descending

✎ View and edit SQL

This data as json, 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
500084 500084 2020-08-11 Zimbabwe       4818 104 1524 3190 -19.015438 29.154857 2020-08-12 04:27:29 Zimbabwe
500083 500083 2020-08-11 Zambia       8275 241 7004 1030 -13.133897 27.849332 2020-08-12 04:27:29 Zambia
500082 500082 2020-08-11 Yemen       1831 523 915 393 15.552727 48.516388 2020-08-12 04:27:29 Yemen
500081 500081 2020-08-11 Western Sahara       10 1 8 1 24.2155 -12.8858 2020-08-12 04:27:29 Western Sahara
500080 500080 2020-08-11 West Bank and Gaza       14875 104 8181 6590 31.9522 35.2332 2020-08-12 04:27:29 West Bank and Gaza
500079 500079 2020-08-11 Vietnam       866 16 451 399 14.058324 108.277199 2020-08-12 04:27:29 Vietnam
500078 500078 2020-08-11 Venezuela       27938 238 19706 7994 6.4238 -66.5897 2020-08-12 04:27:29 Venezuela
500077 500077 2020-08-11 Uzbekistan       31747 204 23704 7839 41.377491 64.585262 2020-08-12 04:27:29 Uzbekistan
500076 500076 2020-08-11 US Wyoming Weston 56045 5 0 0 5 43.83961191 -104.5674881 2020-08-12 04:27:29 Weston, Wyoming, US
500075 500075 2020-08-11 US Wyoming Washakie 56043 79 0 0 79 43.90451606 -107.68018700000002 2020-08-12 04:27:29 Washakie, Wyoming, US
500074 500074 2020-08-11 US Wyoming Unassigned 90056 0 28 0 -28 44.79048913 -110.6563997 2020-08-12 04:27:29 Unassigned, Wyoming, US
500073 500073 2020-08-11 US Wyoming Uinta 56041 279 0 0 279 41.2878183 -110.54757820000002 2020-08-12 04:27:29 Uinta, Wyoming, US
500072 500072 2020-08-11 US Wyoming Teton 56039 372 0 0 372 43.93522482 -110.5890801 2020-08-12 04:27:29 Teton, Wyoming, US
500071 500071 2020-08-11 US Wyoming Sweetwater 56037 267 0 0 267 41.65943896 -108.8827882 2020-08-12 04:27:29 Sweetwater, Wyoming, US
500070 500070 2020-08-11 US Wyoming Sublette 56035 39 0 0 39 42.76558279 -109.9130922 2020-08-12 04:27:29 Sublette, Wyoming, US
500069 500069 2020-08-11 US Wyoming Sheridan 56033 73 0 0 73 44.79048913 -106.8862389 2020-08-12 04:27:29 Sheridan, Wyoming, US
500068 500068 2020-08-11 US Wyoming Platte 56031 5 0 0 5 42.13299116 -104.966331 2020-08-12 04:27:29 Platte, Wyoming, US
500067 500067 2020-08-11 US Wyoming Park 56029 135 0 0 135 44.52157546 -109.5852825 2020-08-12 04:27:29 Park, Wyoming, US
500066 500066 2020-08-11 US Wyoming Niobrara 56027 2 0 0 2 43.05607708 -104.4758896 2020-08-12 04:27:29 Niobrara, Wyoming, US
500065 500065 2020-08-11 US Wyoming Natrona 56025 238 0 0 238 42.96180148 -106.797885 2020-08-12 04:27:29 Natrona, Wyoming, US
500064 500064 2020-08-11 US Wyoming Lincoln 56023 103 0 0 103 42.26376367 -110.6563997 2020-08-12 04:27:29 Lincoln, Wyoming, US
500063 500063 2020-08-11 US Wyoming Laramie 56021 500 0 0 500 41.30702520000001 -104.6887497 2020-08-12 04:27:29 Laramie, Wyoming, US
500062 500062 2020-08-11 US Wyoming Johnson 56019 24 1 0 23 44.04057166 -106.5845174 2020-08-12 04:27:29 Johnson, Wyoming, US
500061 500061 2020-08-11 US Wyoming Hot Springs 56017 23 0 0 23 43.71930657 -108.4423174 2020-08-12 04:27:29 Hot Springs, Wyoming, US
500060 500060 2020-08-11 US Wyoming Goshen 56015 34 0 0 34 42.08798185 -104.3534743 2020-08-12 04:27:29 Goshen, Wyoming, US
500059 500059 2020-08-11 US Wyoming Fremont 56013 497 0 0 497 43.04183996 -108.6296893 2020-08-12 04:27:29 Fremont, Wyoming, US
500058 500058 2020-08-11 US Wyoming Crook 56011 10 0 0 10 44.58855102 -104.5697705 2020-08-12 04:27:29 Crook, Wyoming, US
500057 500057 2020-08-11 US Wyoming Converse 56009 31 0 0 31 42.97272268 -105.5081848 2020-08-12 04:27:29 Converse, Wyoming, US
500056 500056 2020-08-11 US Wyoming Carbon 56007 103 0 0 103 41.69357844 -106.9326084 2020-08-12 04:27:29 Carbon, Wyoming, US
500055 500055 2020-08-11 US Wyoming Campbell 56005 129 0 0 129 44.24886082 -105.5474404 2020-08-12 04:27:29 Campbell, Wyoming, US
500054 500054 2020-08-11 US Wyoming Big Horn 56003 37 0 0 37 44.52405055 -107.9960365 2020-08-12 04:27:29 Big Horn, Wyoming, US
500053 500053 2020-08-11 US Wyoming Albany 56001 88 0 0 88 41.65498705 -105.7235415 2020-08-12 04:27:29 Albany, Wyoming, US
500052 500052 2020-08-11 US Wisconsin Wood 55141 322 2 0 320 44.45537896 -90.04158336 2020-08-12 04:27:29 Wood, Wisconsin, US
500051 500051 2020-08-11 US Wisconsin Winnebago 55139 1212 18 0 1194 44.06886922 -88.64477096 2020-08-12 04:27:29 Winnebago, Wisconsin, US
500050 500050 2020-08-11 US Wisconsin Waushara 55137 120 1 0 119 44.11324419 -89.24317107 2020-08-12 04:27:29 Waushara, Wisconsin, US
500049 500049 2020-08-11 US Wisconsin Waupaca 55135 473 15 0 458 44.47068056 -88.96534501 2020-08-12 04:27:29 Waupaca, Wisconsin, US
500048 500048 2020-08-11 US Wisconsin Waukesha 55133 4354 59 0 4295 43.01833055 -88.30431188 2020-08-12 04:27:29 Waukesha, Wisconsin, US
500047 500047 2020-08-11 US Wisconsin Washington 55131 1108 22 0 1086 43.36863664 -88.22974712 2020-08-12 04:27:29 Washington, Wisconsin, US
500046 500046 2020-08-11 US Wisconsin Washburn 55129 47 0 0 47 45.89838588 -91.79050449 2020-08-12 04:27:29 Washburn, Wisconsin, US
500045 500045 2020-08-11 US Wisconsin Walworth 55127 1359 23 0 1336 42.66858202 -88.54163073 2020-08-12 04:27:29 Walworth, Wisconsin, US
500044 500044 2020-08-11 US Wisconsin Vilas 55125 60 0 0 60 46.05467334 -89.51719204 2020-08-12 04:27:29 Vilas, Wisconsin, US
500043 500043 2020-08-11 US Wisconsin Vernon 55123 66 0 0 66 43.59422667 -90.8324691 2020-08-12 04:27:29 Vernon, Wisconsin, US
500042 500042 2020-08-11 US Wisconsin Unassigned 90055 0 0 0 0 46.52868768 0.0 2020-08-12 04:27:29 Unassigned, Wisconsin, US
500041 500041 2020-08-11 US Wisconsin Trempealeau 55121 345 2 0 343 44.30360275 -91.35893614 2020-08-12 04:27:29 Trempealeau, Wisconsin, US
500040 500040 2020-08-11 US Wisconsin Taylor 55119 71 1 0 70 45.21179252 -90.5004405 2020-08-12 04:27:29 Taylor, Wisconsin, US
500039 500039 2020-08-11 US Wisconsin St. Croix 55109 512 5 0 507 45.03437474 -92.45000068 2020-08-12 04:27:29 St. Croix, Wisconsin, US
500038 500038 2020-08-11 US Wisconsin Sheboygan 55117 776 8 0 768 43.72099677 -87.94579284 2020-08-12 04:27:29 Sheboygan, Wisconsin, US
500037 500037 2020-08-11 US Wisconsin Shawano 55115 204 0 0 204 44.78902246 -88.76443896 2020-08-12 04:27:29 Shawano, Wisconsin, US
500036 500036 2020-08-11 US Wisconsin Sawyer 55113 76 0 0 76 45.87931905 -91.14504927 2020-08-12 04:27:29 Sawyer, Wisconsin, US
500035 500035 2020-08-11 US Wisconsin Sauk 55111 452 3 0 449 43.42574087 -89.94966132 2020-08-12 04:27:29 Sauk, Wisconsin, US
500034 500034 2020-08-11 US Wisconsin Rusk 55107 21 1 0 20 45.47498854 -91.1333012 2020-08-12 04:27:29 Rusk, Wisconsin, US
500033 500033 2020-08-11 US Wisconsin Rock 55105 1444 26 0 1418 42.67151616 -89.07147900000002 2020-08-12 04:27:29 Rock, Wisconsin, US
500032 500032 2020-08-11 US Wisconsin Richland 55103 37 4 0 33 43.3762778 -90.43012729 2020-08-12 04:27:29 Richland, Wisconsin, US
500031 500031 2020-08-11 US Wisconsin Racine 55101 3567 79 0 3488 42.74753117 -88.05941254 2020-08-12 04:27:29 Racine, Wisconsin, US
500030 500030 2020-08-11 US Wisconsin Price 55099 33 0 0 33 45.68051754 -90.3609888 2020-08-12 04:27:29 Price, Wisconsin, US
500029 500029 2020-08-11 US Wisconsin Portage 55097 426 0 0 426 44.47558711 -89.50152965 2020-08-12 04:27:29 Portage, Wisconsin, US
500028 500028 2020-08-11 US Wisconsin Polk 55095 137 2 0 135 45.46130348 -92.44182875 2020-08-12 04:27:29 Polk, Wisconsin, US
500027 500027 2020-08-11 US Wisconsin Pierce 55093 224 3 0 221 44.71850291 -92.4224416 2020-08-12 04:27:29 Pierce, Wisconsin, US
500026 500026 2020-08-11 US Wisconsin Pepin 55091 42 0 0 42 44.58307413 -91.99949611 2020-08-12 04:27:29 Pepin, Wisconsin, US
500025 500025 2020-08-11 US Wisconsin Ozaukee 55089 716 17 0 699 43.38352225 -87.94625009 2020-08-12 04:27:29 Ozaukee, Wisconsin, US
500024 500024 2020-08-11 US Wisconsin Outagamie 55087 1299 14 0 1285 44.41578887 -88.46565023 2020-08-12 04:27:29 Outagamie, Wisconsin, US
500023 500023 2020-08-11 US Wisconsin Oneida 55085 153 0 0 153 45.70677897 -89.51944105 2020-08-12 04:27:29 Oneida, Wisconsin, US
500022 500022 2020-08-11 US Wisconsin Oconto 55083 259 0 0 259 45.02715345 -88.26807503 2020-08-12 04:27:29 Oconto, Wisconsin, US
500021 500021 2020-08-11 US Wisconsin Monroe 55081 245 2 0 243 43.94641218 -90.618819 2020-08-12 04:27:29 Monroe, Wisconsin, US
500020 500020 2020-08-11 US Wisconsin Milwaukee 55079 21331 458 0 20873 43.00486062 -87.96733172 2020-08-12 04:27:29 Milwaukee, Wisconsin, US
500019 500019 2020-08-11 US Wisconsin Menominee 55078 25 0 0 25 45.00422544 -88.70950714 2020-08-12 04:27:29 Menominee, Wisconsin, US
500018 500018 2020-08-11 US Wisconsin Marquette 55077 80 1 0 79 43.81911946 -89.40073763 2020-08-12 04:27:29 Marquette, Wisconsin, US
500017 500017 2020-08-11 US Wisconsin Marinette 55075 432 4 0 428 45.38553432 -88.03324599999998 2020-08-12 04:27:29 Marinette, Wisconsin, US
500016 500016 2020-08-11 US Wisconsin Marathon 55073 662 10 0 652 44.89792533 -89.75863384 2020-08-12 04:27:29 Marathon, Wisconsin, US
500015 500015 2020-08-11 US Wisconsin Manitowoc 55071 351 1 0 350 44.11946801 -87.80928853 2020-08-12 04:27:29 Manitowoc, Wisconsin, US
500014 500014 2020-08-11 US Wisconsin Lincoln 55069 69 0 0 69 45.33737523 -89.73411273 2020-08-12 04:27:29 Lincoln, Wisconsin, US
500013 500013 2020-08-11 US Wisconsin Langlade 55067 63 1 0 62 45.26271619 -89.07483625 2020-08-12 04:27:29 Langlade, Wisconsin, US
500012 500012 2020-08-11 US Wisconsin Lafayette 55065 147 0 0 147 42.66005229 -90.1317729 2020-08-12 04:27:29 Lafayette, Wisconsin, US
500011 500011 2020-08-11 US Wisconsin La Crosse 55063 921 1 0 920 43.90632465 -91.11451093 2020-08-12 04:27:29 La Crosse, Wisconsin, US
500010 500010 2020-08-11 US Wisconsin Kewaunee 55061 135 2 0 133 44.51727459 -87.61468386 2020-08-12 04:27:29 Kewaunee, Wisconsin, US
500009 500009 2020-08-11 US Wisconsin Kenosha 55059 2692 60 0 2632 42.57639354 -88.04051686 2020-08-12 04:27:29 Kenosha, Wisconsin, US
500008 500008 2020-08-11 US Wisconsin Juneau 55057 138 1 0 137 43.92456975 -90.11120239 2020-08-12 04:27:29 Juneau, Wisconsin, US
500007 500007 2020-08-11 US Wisconsin Jefferson 55055 647 5 0 642 43.02054068 -88.77529134 2020-08-12 04:27:29 Jefferson, Wisconsin, US
500006 500006 2020-08-11 US Wisconsin Jackson 55053 58 1 0 57 44.31864893 -90.80566792 2020-08-12 04:27:29 Jackson, Wisconsin, US
500005 500005 2020-08-11 US Wisconsin Iron 55051 76 1 0 75 46.26302338 -90.24295041 2020-08-12 04:27:29 Iron, Wisconsin, US
500004 500004 2020-08-11 US Wisconsin Iowa 55049 83 0 0 83 43.00050278 -90.13469017 2020-08-12 04:27:29 Iowa, Wisconsin, US
500003 500003 2020-08-11 US Wisconsin Green Lake 55047 57 0 0 57 43.80025981 -89.04679553 2020-08-12 04:27:29 Green Lake, Wisconsin, US
500002 500002 2020-08-11 US Wisconsin Green 55045 169 1 0 168 42.6794956 -89.60243287 2020-08-12 04:27:29 Green, Wisconsin, US
500001 500001 2020-08-11 US Wisconsin Grant 55043 362 15 0 347 42.8671731 -90.7063218 2020-08-12 04:27:29 Grant, Wisconsin, US
500000 500000 2020-08-11 US Wisconsin Forest 55041 60 4 0 56 45.66678019 -88.77084892 2020-08-12 04:27:29 Forest, Wisconsin, US
499999 499999 2020-08-11 US Wisconsin Fond du Lac 55039 676 7 0 669 43.75354908 -88.48885325 2020-08-12 04:27:29 Fond du Lac, Wisconsin, US
499998 499998 2020-08-11 US Wisconsin Florence 55037 8 0 0 8 45.84963535 -88.39804137 2020-08-12 04:27:29 Florence, Wisconsin, US
499997 499997 2020-08-11 US Wisconsin Eau Claire 55035 596 4 0 592 44.726614 -91.28609183 2020-08-12 04:27:29 Eau Claire, Wisconsin, US
499996 499996 2020-08-11 US Wisconsin Dunn 55033 128 0 0 128 44.94562799 -91.8962481 2020-08-12 04:27:29 Dunn, Wisconsin, US
499995 499995 2020-08-11 US Wisconsin Douglas 55031 191 0 0 191 46.43222285 -91.91595768 2020-08-12 04:27:29 Douglas, Wisconsin, US
499994 499994 2020-08-11 US Wisconsin Door 55029 107 3 0 104 44.95856458 -87.30002707 2020-08-12 04:27:29 Door, Wisconsin, US
499993 499993 2020-08-11 US Wisconsin Dodge 55027 845 5 0 840 43.41576662 -88.70928178 2020-08-12 04:27:29 Dodge, Wisconsin, US
499992 499992 2020-08-11 US Wisconsin Dane 55025 4578 38 0 4540 43.06601594 -89.41733797 2020-08-12 04:27:29 Dane, Wisconsin, US
499991 499991 2020-08-11 US Wisconsin Crawford 55023 76 0 0 76 43.23870316 -90.93073686 2020-08-12 04:27:29 Crawford, Wisconsin, US
499990 499990 2020-08-11 US Wisconsin Columbia 55021 255 2 0 253 43.46492199 -89.33589004 2020-08-12 04:27:29 Columbia, Wisconsin, US
499989 499989 2020-08-11 US Wisconsin Clark 55019 189 8 0 181 44.73483377 -90.61207486 2020-08-12 04:27:29 Clark, Wisconsin, US
499988 499988 2020-08-11 US Wisconsin Chippewa 55017 241 0 0 241 45.06939744 -91.28068855 2020-08-12 04:27:29 Chippewa, Wisconsin, US
499987 499987 2020-08-11 US Wisconsin Calumet 55015 334 2 0 332 44.0816316 -88.21780273 2020-08-12 04:27:29 Calumet, Wisconsin, US
499986 499986 2020-08-11 US Wisconsin Burnett 55013 22 1 0 21 45.86303537 -92.36711412 2020-08-12 04:27:29 Burnett, Wisconsin, US
499985 499985 2020-08-11 US Wisconsin Buffalo 55011 44 2 0 42 44.37835084 -91.75332578 2020-08-12 04:27:29 Buffalo, 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 · Query took 3227.509ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette