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

Suggested facets: last_update (date)

These facets timed out: day

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 2020-08-11 US South Carolina Allendale 45005 232 5 0 227 32.98837386 -81.35321066 2020-08-12 04:27:29 Allendale, South Carolina, US
500083 2020-08-11 US Minnesota Traverse 27155 11 0 0 11 45.77298854 -96.47062949 2020-08-12 04:27:29 Traverse, Minnesota, US
500082 2020-08-11 US Minnesota Steele 27147 351 2 0 349 44.02240351 -93.22627088 2020-08-12 04:27:29 Steele, Minnesota, US
500081 2020-08-11 US Minnesota Roseau 27135 52 0 0 52 48.77501878 -95.81079919 2020-08-12 04:27:29 Roseau, Minnesota, US
500080 2020-08-11 US Minnesota Red Lake 27125 24 0 0 24 47.87197525 -96.09561104 2020-08-12 04:27:29 Red Lake, Minnesota, US
500079 2020-08-11 US Minnesota Jackson 27063 79 0 0 79 43.67423373 -95.15398258 2020-08-12 04:27:29 Jackson, Minnesota, US
500078 2020-08-11 US Minnesota Hennepin 27053 19569 839 0 18730 45.00761521 -93.47694895 2020-08-12 04:27:29 Hennepin, Minnesota, US
500077 2020-08-11 Peru Lima     244520 9993 0 234527 -11.766533 -76.60449799999998 2020-08-12 04:27:29 Lima, Peru
500076 2020-08-11 Peru Cusco     6879 152 0 6727 -13.191068 -72.153609 2020-08-12 04:27:29 Cusco, Peru
500075 2020-08-11 US Florida Glades 12043 406 3 0 403 26.95635849 -81.18996211 2020-08-12 04:27:29 Glades, Florida, US
500074 2020-08-11 US Florida Monroe 12087 1548 13 0 1535 25.20904673 -81.07812416 2020-08-12 04:27:29 Monroe, Florida, US
500073 2020-08-11 US Florida Lee 12071 16718 351 0 16367 26.58410348 -81.88399313 2020-08-12 04:27:29 Lee, Florida, US
500072 2020-08-11 US Florida Polk 12105 14645 326 0 14319 27.95027105 -81.69732947 2020-08-12 04:27:29 Polk, Florida, US
500071 2020-08-11 US Florida Brevard 12009 6190 157 0 6033 28.29409504 -80.73091022 2020-08-12 04:27:29 Brevard, Florida, US
500070 2020-08-11 US Florida Bradford 12007 519 4 0 515 29.95079741 -82.16611613 2020-08-12 04:27:29 Bradford, Florida, US
500069 2020-08-11 US Florida Dixie 12029 562 4 0 558 29.60631086 -83.15724673 2020-08-12 04:27:29 Dixie, Florida, US
500068 2020-08-11 US Florida Bay 12005 4523 52 0 4471 30.26548745 -85.62122584 2020-08-12 04:27:29 Bay, Florida, US
500067 2020-08-11 US Massachusetts Middlesex 25017 26565 2006 0 24559 42.48607732 -71.39049229 2020-08-12 04:27:29 Middlesex, Massachusetts, US
500066 2020-08-11 Russia Perm Krai     6637 177 4722 1738 58.5951603 56.3159546 2020-08-12 04:27:29 Perm Krai, Russia
500065 2020-08-11 Russia Chuvashia Republic     7108 64 4450 2594 55.4259922 47.0849429 2020-08-12 04:27:29 Chuvashia Republic, Russia
500064 2020-08-11 Russia Samara Oblast     7320 110 5518 1692 53.2128813 50.8914633 2020-08-12 04:27:29 Samara Oblast, Russia
500063 2020-08-11 Russia Orenburg Oblast     8066 57 6399 1610 52.02692620000001 54.7276647 2020-08-12 04:27:29 Orenburg Oblast, Russia
500062 2020-08-11 Russia Krasnodar Krai     9465 132 8158 1175 45.7684014 39.0261044 2020-08-12 04:27:29 Krasnodar Krai, Russia
500061 2020-08-11 Russia Altai Krai     10185 95 8362 1728 52.6932243 82.69314240000001 2020-08-12 04:27:29 Altai Krai, Russia
500060 2020-08-11 Russia Novosibirsk Oblast     10334 292 8624 1418 54.9720169 79.48139240000002 2020-08-12 04:27:29 Novosibirsk Oblast, Russia
500059 2020-08-11 US New Mexico McKinley 35031 4067 227 0 3840 35.58007720000001 -108.262245 2020-08-12 04:27:29 McKinley, New Mexico, US
500058 2020-08-11 US New Mexico Lea 35025 830 5 0 825 32.79215361 -103.4123733 2020-08-12 04:27:29 Lea, New Mexico, US
500057 2020-08-11 US New Mexico Hidalgo 35023 90 0 0 90 31.91383467 -108.7151824 2020-08-12 04:27:29 Hidalgo, New Mexico, US
500056 2020-08-11 US Tennessee Hickman 47081 272 0 0 272 35.80609681 -87.47643507 2020-08-12 04:27:29 Hickman, Tennessee, US
500055 2020-08-11 Ukraine Sevastopol*     391 11 316 64 44.6054 33.522 2020-08-12 04:27:29 Sevastopol*, Ukraine
500054 2020-08-11 Ukraine Odessa Oblast     4364 73 1442 2849 46.4846 30.7326 2020-08-12 04:27:29 Odessa Oblast, Ukraine
500053 2020-08-11 Brazil Tocantins     32289 461 19845 11983 -10.1753 -48.2982 2020-08-12 04:27:29 Tocantins, Brazil
500052 2020-08-11 Brazil Espirito Santo     93069 2764 80509 9796 -19.1834 -40.3089 2020-08-12 04:27:29 Espirito Santo, Brazil
500051 2020-08-11 Brazil Distrito Federal     126069 1762 109598 14709 -15.7998 -47.8645 2020-08-12 04:27:29 Distrito Federal, Brazil
500050 2020-08-11 Brazil Ceara     188657 7979 162744 17934 -5.4984 -39.3206 2020-08-12 04:27:29 Ceara, Brazil
500049 2020-08-11 US New Jersey Unassigned 90034 660 0 0 660 41.13891592 0.0 2020-08-12 04:27:29 Unassigned, New Jersey, US
500048 2020-08-11 US New Jersey Gloucester 34015 3283 213 0 3070 39.71581067 -75.13995546 2020-08-12 04:27:29 Gloucester, New Jersey, US
500047 2020-08-11 US New Jersey Bergen 34003 20864 2038 0 18826 40.96010917 -74.07164325 2020-08-12 04:27:29 Bergen, New Jersey, US
500046 2020-08-11 United Kingdom Falkland Islands (Malvinas)     13 0 13 0 -51.7963 -59.5236 2020-08-12 04:27:29 Falkland Islands (Malvinas), United Kingdom
500045 2020-08-11 Grenada       24 0 23 1 12.1165 -61.679 2020-08-12 04:27:29 Grenada
500044 2020-08-11 US Louisiana Washington 22117 1293 58 0 1235 30.85288548 -90.03866652 2020-08-12 04:27:29 Washington, Louisiana, US
500043 2020-08-11 US Louisiana Tensas 22107 91 0 0 91 32.00760749 -91.32915234 2020-08-12 04:27:29 Tensas, Louisiana, US
500042 2020-08-11 US Louisiana St. Helena 22091 275 2 0 273 30.82210324 -90.71013176 2020-08-12 04:27:29 St. Helena, Louisiana, US
500041 2020-08-11 US Louisiana Richland 22083 604 8 0 596 32.41391005 -91.76634876 2020-08-12 04:27:29 Richland, Louisiana, US
500040 2020-08-11 US Louisiana Pointe Coupee 22077 810 32 0 778 30.71409502 -91.60209535 2020-08-12 04:27:29 Pointe Coupee, Louisiana, US
500039 2020-08-11 US Louisiana Madison 22065 618 6 0 612 32.36918118 -91.23973355 2020-08-12 04:27:29 Madison, Louisiana, US
500038 2020-08-11 US Louisiana Lincoln 22061 806 31 0 775 32.6003154 -92.6659741 2020-08-12 04:27:29 Lincoln, Louisiana, US
500037 2020-08-11 US Louisiana Iberia 22045 2561 73 0 2488 29.86803617 -91.75871777 2020-08-12 04:27:29 Iberia, Louisiana, US
500036 2020-08-11 US Louisiana Franklin 22041 940 19 0 921 32.13675181 -91.67589857 2020-08-12 04:27:29 Franklin, Louisiana, US
500035 2020-08-11 US Nevada Unassigned 90032 0 0 0 0 41.40692186 0.0 2020-08-12 04:27:29 Unassigned, Nevada, US
500034 2020-08-11 US Nevada Nye 32023 408 9 0 399 38.04264256 -116.4722702 2020-08-12 04:27:29 Nye, Nevada, US
500033 2020-08-11 US Nevada Mineral 32021 11 0 0 11 38.53841696 -118.4344506 2020-08-12 04:27:29 Mineral, Nevada, US
500032 2020-08-11 US Nevada Humboldt 32013 104 4 0 100 41.40692186 -118.1109427 2020-08-12 04:27:29 Humboldt, Nevada, US
500031 2020-08-11 US Nevada Carson City 32510 357 8 0 349 39.15509045 -119.7480219 2020-08-12 04:27:29 Carson City, Nevada, US
500030 2020-08-11 US Ohio Gallia 39053 70 1 0 69 38.82708533 -82.31647569 2020-08-12 04:27:29 Gallia, Ohio, US
500029 2020-08-11 US Ohio Carroll 39019 113 5 0 108 40.5789686 -81.09178213 2020-08-12 04:27:29 Carroll, Ohio, US
500028 2020-08-11 US Ohio Auglaize 39011 263 6 0 257 40.55998859 -84.22421429999999 2020-08-12 04:27:29 Auglaize, Ohio, US
500027 2020-08-11 US Ohio Brown 39015 146 2 0 144 38.93416837 -83.86788395 2020-08-12 04:27:29 Brown, Ohio, US
500026 2020-08-11 US Ohio Hocking 39073 118 9 0 109 39.49537927 -82.47991446 2020-08-12 04:27:29 Hocking, Ohio, US
500025 2020-08-11 US Ohio Lucas 39095 5448 326 0 5122 41.62101218 -83.65468618 2020-08-12 04:27:29 Lucas, Ohio, US
500024 2020-08-11 US Ohio Noble 39121 16 0 0 16 39.76818851 -81.45937183 2020-08-12 04:27:29 Noble, Ohio, US
500023 2020-08-11 US Ohio Morgan 39115 30 0 0 30 39.62081738 -81.85308173 2020-08-12 04:27:29 Morgan, Ohio, US
500022 2020-08-11 US Ohio Scioto 39145 242 1 0 241 38.80270163 -82.98907345 2020-08-12 04:27:29 Scioto, Ohio, US
500021 2020-08-11 US Ohio Henry 39069 122 2 0 120 41.3339642 -84.06830637 2020-08-12 04:27:29 Henry, Ohio, US
500020 2020-08-11 US Ohio Monroe 39111 94 18 0 76 39.72984936 -81.08464734 2020-08-12 04:27:29 Monroe, Ohio, US
500019 2020-08-11 US Ohio Preble 39135 207 2 0 205 39.7420247 -84.64787018 2020-08-12 04:27:29 Preble, Ohio, US
500018 2020-08-11 US Ohio Delaware 39041 1344 19 0 1325 40.27942393 -83.00457058 2020-08-12 04:27:29 Delaware, Ohio, US
500017 2020-08-11 US Ohio Meigs 39105 54 0 0 54 39.09224872 -82.0305041 2020-08-12 04:27:29 Meigs, Ohio, US
500016 2020-08-11 US Ohio Ross 39141 494 4 0 490 39.33705391 -83.06000914 2020-08-12 04:27:29 Ross, Ohio, US
500015 2020-08-11 US Wisconsin Milwaukee 55079 21331 458 0 20873 43.00486062 -87.96733172 2020-08-12 04:27:29 Milwaukee, Wisconsin, US
500014 2020-08-11 US Wisconsin Dane 55025 4578 38 0 4540 43.06601594 -89.41733797 2020-08-12 04:27:29 Dane, Wisconsin, US
500013 2020-08-11 US Wisconsin Brown 55009 4340 54 0 4286 44.4526553 -88.00411844 2020-08-12 04:27:29 Brown, Wisconsin, US
500012 2020-08-11 US Wisconsin Washington 55131 1108 22 0 1086 43.36863664 -88.22974712 2020-08-12 04:27:29 Washington, Wisconsin, US
500011 2020-08-11 US Wisconsin Marathon 55073 662 10 0 652 44.89792533 -89.75863384 2020-08-12 04:27:29 Marathon, Wisconsin, US
500010 2020-08-11 US Wisconsin Marinette 55075 432 4 0 428 45.38553432 -88.03324599999998 2020-08-12 04:27:29 Marinette, Wisconsin, US
500009 2020-08-11 US Wisconsin Oconto 55083 259 0 0 259 45.02715345 -88.26807503 2020-08-12 04:27:29 Oconto, Wisconsin, US
500008 2020-08-11 US Wisconsin Lafayette 55065 147 0 0 147 42.66005229 -90.1317729 2020-08-12 04:27:29 Lafayette, Wisconsin, US
500007 2020-08-11 US Wisconsin Langlade 55067 63 1 0 62 45.26271619 -89.07483625 2020-08-12 04:27:29 Langlade, Wisconsin, US
500006 2020-08-11 US Missouri Texas 29215 57 0 0 57 37.31728859 -91.96564727 2020-08-12 04:27:29 Texas, Missouri, US
500005 2020-08-11 US Missouri Buchanan 29021 1092 10 0 1082 39.65816401 -94.80138942 2020-08-12 04:27:29 Buchanan, Missouri, US
500004 2020-08-11 US Missouri St. Francois 29187 392 2 0 390 37.81214171 -90.47598685 2020-08-12 04:27:29 St. Francois, Missouri, US
500003 2020-08-11 US Minnesota Goodhue 27049 199 9 0 190 44.40849741 -92.7234195 2020-08-12 04:27:29 Goodhue, Minnesota, US
500002 2020-08-11 US Minnesota Faribault 27043 89 0 0 89 43.67381499 -93.94787458 2020-08-12 04:27:29 Faribault, Minnesota, US
500001 2020-08-11 US Minnesota Clearwater 27029 14 0 0 14 47.57992111 -95.37790562 2020-08-12 04:27:29 Clearwater, Minnesota, US
500000 2020-08-11 US Minnesota Clay 27027 788 40 0 748 46.89289518 -96.48761922 2020-08-12 04:27:29 Clay, Minnesota, US
499999 2020-08-11 US Minnesota Cass 27021 74 2 0 72 46.95043611 -94.32603968 2020-08-12 04:27:29 Cass, Minnesota, US
499998 2020-08-11 US Minnesota Benton 27009 320 3 0 317 45.69804958 -93.99514135 2020-08-12 04:27:29 Benton, Minnesota, US
499997 2020-08-11 US Minnesota Anoka 27003 3752 115 0 3637 45.27476015 -93.24604565 2020-08-12 04:27:29 Anoka, Minnesota, US
499996 2020-08-11 Peru Unknown     0 0 329404 -329404     2020-08-12 04:27:29 Unknown, Peru
499995 2020-08-11 Peru Ancash     14068 889 0 13179 -9.407125 -77.67179499999997 2020-08-12 04:27:29 Ancash, Peru
499994 2020-08-11 US Florida Collier 12021 10487 143 0 10344 26.11091986 -81.34687065 2020-08-12 04:27:29 Collier, Florida, US
499993 2020-08-11 US Florida Wakulla 12129 726 5 0 721 30.16548905 -84.39895211 2020-08-12 04:27:29 Wakulla, Florida, US
499992 2020-08-11 US Florida Lafayette 12067 189 2 0 187 29.98484137 -83.18166636 2020-08-12 04:27:29 Lafayette, Florida, US
499991 2020-08-11 US Florida Seminole 12117 7219 130 0 7089 28.7158582 -81.24060348 2020-08-12 04:27:29 Seminole, Florida, US
499990 2020-08-11 US Florida Martin 12085 3852 99 0 3753 27.0772071 -80.43109784 2020-08-12 04:27:29 Martin, Florida, US
499989 2020-08-11 US Florida Pasco 12101 7172 131 0 7041 28.30810945 -82.40227529 2020-08-12 04:27:29 Pasco, Florida, US
499988 2020-08-11 US Florida Okaloosa 12091 3587 45 0 3542 30.69143028 -86.59267105 2020-08-12 04:27:29 Okaloosa, Florida, US
499987 2020-08-11 US Massachusetts Unassigned 90025 326 6 0 320 42.6687626 0.0 2020-08-12 04:27:29 Unassigned, Massachusetts, US
499986 2020-08-11 US Massachusetts Worcester 25027 13686 1007 0 12679 42.35026951 -71.90493363 2020-08-12 04:27:29 Worcester, Massachusetts, US
499985 2020-08-11 US Massachusetts Bristol 25005 9408 637 0 8771 41.79228404 -71.10872211 2020-08-12 04:27:29 Bristol, Massachusetts, 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 4402.227ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette