daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,955 rows where "day" is on date 2020-07-18 sorted by active descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region, day
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▲ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-07-18 | US | Mississippi | Jackson | 28059 | 1018 | 20 | 0 | 998 | 30.54020656 | -88.64184064 | 2020-07-19 04:34:58 | Jackson, Mississippi, US |
2020-07-18 | Chile | Maule | 7683 | 127 | 6560 | 996 | -35.5183 | -71.6885 | 2020-07-19 04:34:58 | Maule, Chile | ||
2020-07-18 | US | Texas | Gregg | 48183 | 537 | 15 | 0 | 993 | 32.47940482 | -94.81591935 | 2020-07-19 04:34:58 | Gregg, Texas, US |
2020-07-18 | Russia | Lipetsk Oblast | 4374 | 20 | 3364 | 990 | 52.6935178 | 39.1122664 | 2020-07-19 04:34:58 | Lipetsk Oblast, Russia | ||
2020-07-18 | US | Minnesota | Carlton | 27017 | 99 | 0 | 0 | 99 | 46.59180601 | -92.67601019 | 2020-07-19 04:34:58 | Carlton, Minnesota, US |
2020-07-18 | US | Minnesota | Douglas | 27041 | 99 | 0 | 0 | 99 | 45.93348491 | -95.45335469 | 2020-07-19 04:34:58 | Douglas, Minnesota, US |
2020-07-18 | US | Virginia | Powhatan | 51145 | 102 | 3 | 0 | 99 | 37.55016038 | -77.91267882 | 2020-07-19 04:34:58 | Powhatan, Virginia, US |
2020-07-18 | US | Ohio | Scioto | 39145 | 99 | 0 | 0 | 99 | 38.80270163 | -82.98907345 | 2020-07-19 04:34:58 | Scioto, Ohio, US |
2020-07-18 | US | North Dakota | Ward | 38101 | 103 | 1 | 0 | 99 | 48.22390169 | -101.5436763 | 2020-07-19 04:34:58 | Ward, North Dakota, US |
2020-07-18 | US | New York | Wyoming | 36121 | 104 | 5 | 0 | 99 | 42.70145109 | -78.22199579 | 2020-07-19 04:34:58 | Wyoming, New York, US |
2020-07-18 | Italy | Friuli Venezia Giulia | 3350 | 345 | 2906 | 99 | 45.6494354 | 13.76813649 | 2020-07-19 04:34:58 | Friuli Venezia Giulia, Italy | ||
2020-07-18 | Germany | Schleswig-Holstein | 3251 | 154 | 3000 | 99 | 54.2194 | 9.6961 | 2020-07-19 04:34:58 | Schleswig-Holstein, Germany | ||
2020-07-18 | US | Texas | Angelina | 48005 | 686 | 12 | 0 | 988 | 31.25457347 | -94.60901487 | 2020-07-19 04:34:58 | Angelina, Texas, US |
2020-07-18 | US | North Carolina | Granville | 37077 | 1012 | 25 | 0 | 987 | 36.30337451 | -78.65184241 | 2020-07-19 04:34:58 | Granville, North Carolina, US |
2020-07-18 | US | Georgia | Paulding | 13223 | 1003 | 16 | 0 | 987 | 33.91969522 | -84.86848792 | 2020-07-19 04:34:58 | Paulding, Georgia, US |
2020-07-18 | US | New Jersey | Hunterdon | 34019 | 1111 | 126 | 0 | 985 | 40.56335249 | -74.91284156 | 2020-07-19 04:34:58 | Hunterdon, New Jersey, US |
2020-07-18 | US | Mississippi | Neshoba | 28099 | 1065 | 81 | 0 | 984 | 32.75339664 | -89.11726492 | 2020-07-19 04:34:58 | Neshoba, Mississippi, US |
2020-07-18 | US | Pennsylvania | Bedford | 42009 | 102 | 4 | 0 | 98 | 40.00522157 | -78.48998442 | 2020-07-19 04:34:58 | Bedford, Pennsylvania, US |
2020-07-18 | US | Missouri | Camden | 29029 | 100 | 2 | 0 | 98 | 38.02199522 | -92.76083747 | 2020-07-19 04:34:58 | Camden, Missouri, US |
2020-07-18 | US | South Dakota | Charles Mix | 46023 | 98 | 0 | 0 | 98 | 43.20660134 | -98.58856175 | 2020-07-19 04:34:58 | Charles Mix, South Dakota, US |
2020-07-18 | US | Oklahoma | McIntosh | 40091 | 99 | 1 | 0 | 98 | 35.37235506 | -95.66599306 | 2020-07-19 04:34:58 | McIntosh, Oklahoma, US |
2020-07-18 | US | Oklahoma | Pontotoc | 40123 | 100 | 2 | 0 | 98 | 34.72959848 | -96.68337199 | 2020-07-19 04:34:58 | Pontotoc, Oklahoma, US |
2020-07-18 | US | Nebraska | Saunders | 31155 | 100 | 2 | 0 | 98 | 41.2278103 | -96.63773905 | 2020-07-19 04:34:58 | Saunders, Nebraska, US |
2020-07-18 | US | Tennessee | Weakley | 47183 | 108 | 1 | 0 | 98 | 36.29896232 | -88.71990865 | 2020-07-19 04:34:58 | Weakley, Tennessee, US |
2020-07-18 | US | Minnesota | Scott | 27139 | 986 | 7 | 0 | 979 | 44.6490231 | -93.53340251 | 2020-07-19 04:34:58 | Scott, Minnesota, US |
2020-07-18 | Peru | La Libertad | 12430 | 2657 | 0 | 9773 | -7.92139 | -78.370238 | 2020-07-19 04:34:58 | La Libertad, Peru | ||
2020-07-18 | US | South Carolina | Aiken | 45003 | 992 | 15 | 0 | 977 | 33.54338026 | -81.63645384 | 2020-07-19 04:34:58 | Aiken, South Carolina, US |
2020-07-18 | US | Idaho | Kootenai | 16055 | 977 | 1 | 0 | 976 | 47.67282258 | -116.7020872 | 2020-07-19 04:34:58 | Kootenai, Idaho, US |
2020-07-18 | US | North Carolina | Lee | 37105 | 984 | 8 | 0 | 976 | 35.47623147 | -79.17569362 | 2020-07-19 04:34:58 | Lee, North Carolina, US |
2020-07-18 | US | Virginia | Harrisonburg | 51660 | 1004 | 29 | 0 | 975 | 38.43542574 | -78.87536254 | 2020-07-19 04:34:58 | Harrisonburg, Virginia, US |
2020-07-18 | South Sudan | 2191 | 43 | 1175 | 973 | 6.8770000000000024 | 31.307 | 2020-07-19 04:34:58 | South Sudan | |||
2020-07-18 | US | Georgia | Coweta | 13077 | 988 | 16 | 0 | 972 | 33.35334302 | -84.76129976 | 2020-07-19 04:34:58 | Coweta, Georgia, US |
2020-07-18 | US | Mississippi | Lauderdale | 28075 | 1054 | 83 | 0 | 971 | 32.40419769 | -88.66229662 | 2020-07-19 04:34:58 | Lauderdale, Mississippi, US |
2020-07-18 | US | Pennsylvania | Clinton | 42035 | 102 | 5 | 0 | 97 | 41.23255967 | -77.63785995 | 2020-07-19 04:34:58 | Clinton, Pennsylvania, US |
2020-07-18 | US | Arkansas | Desha | 5041 | 98 | 1 | 0 | 97 | 33.83011025 | -91.25500948 | 2020-07-19 04:34:58 | Desha, Arkansas, US |
2020-07-18 | US | Nevada | Douglas | 32005 | 97 | 0 | 0 | 97 | 38.912862 | -119.6171333 | 2020-07-19 04:34:58 | Douglas, Nevada, US |
2020-07-18 | US | Texas | Duval | 48131 | 104 | 0 | 0 | 97 | 27.68184592 | -98.50864568 | 2020-07-19 04:34:58 | Duval, Texas, US |
2020-07-18 | US | West Virginia | Fayette | 54019 | 101 | 4 | 0 | 97 | 38.02974928 | -81.08286634 | 2020-07-19 04:34:58 | Fayette, West Virginia, US |
2020-07-18 | US | New Hampshire | Grafton | 33009 | 98 | 1 | 0 | 97 | 43.93779815 | -71.82057197 | 2020-07-19 04:34:58 | Grafton, New Hampshire, US |
2020-07-18 | US | Virginia | Halifax | 51083 | 98 | 1 | 0 | 97 | 36.76654925 | -78.93512622 | 2020-07-19 04:34:58 | Halifax, Virginia, US |
2020-07-18 | US | Iowa | Henry | 19087 | 100 | 3 | 0 | 97 | 40.98767962 | -91.54436349 | 2020-07-19 04:34:58 | Henry, Iowa, US |
2020-07-18 | US | Iowa | Marion | 19125 | 97 | 0 | 0 | 97 | 41.33445101 | -93.09934783 | 2020-07-19 04:34:58 | Marion, Iowa, US |
2020-07-18 | US | Illinois | McDonough | 17109 | 112 | 15 | 0 | 97 | 40.45674722 | -90.67775541 | 2020-07-19 04:34:58 | McDonough, Illinois, US |
2020-07-18 | US | Missouri | New Madrid | 29143 | 98 | 1 | 0 | 97 | 36.59666326 | -89.66070007 | 2020-07-19 04:34:58 | New Madrid, Missouri, US |
2020-07-18 | US | Idaho | Nez Perce | 16069 | 116 | 19 | 0 | 97 | 46.32638236 | -116.7500975 | 2020-07-19 04:34:58 | Nez Perce, Idaho, US |
2020-07-18 | US | Texas | Trinity | 48455 | 98 | 0 | 0 | 97 | 31.0879489 | -95.1367187 | 2020-07-19 04:34:58 | Trinity, Texas, US |
2020-07-18 | US | Texas | Johnson | 48251 | 917 | 7 | 0 | 966 | 32.37877812 | -97.36615819 | 2020-07-19 04:34:58 | Johnson, Texas, US |
2020-07-18 | US | Missouri | Buchanan | 29021 | 971 | 6 | 0 | 965 | 39.65816401 | -94.80138942 | 2020-07-19 04:34:58 | Buchanan, Missouri, US |
2020-07-18 | US | Texas | Titus | 48449 | 661 | 6 | 0 | 965 | 33.21339719 | -94.96797273 | 2020-07-19 04:34:58 | Titus, Texas, US |
2020-07-18 | US | Illinois | DuPage | 17043 | 10107 | 497 | 0 | 9610 | 41.85116968 | -88.08642662 | 2020-07-19 04:34:58 | DuPage, Illinois, US |
2020-07-18 | US | Michigan | Muskegon | 26121 | 1016 | 55 | 0 | 961 | 43.29123859 | -86.15176712 | 2020-07-19 04:34:58 | Muskegon, Michigan, US |
2020-07-18 | Colombia | La Guajira | 1420 | 74 | 386 | 960 | 11.3548 | -72.5205 | 2020-07-19 04:34:58 | La Guajira, Colombia | ||
2020-07-18 | US | Ohio | Ashland | 39005 | 100 | 4 | 0 | 96 | 40.84772277 | -82.27280781 | 2020-07-19 04:34:58 | Ashland, Ohio, US |
2020-07-18 | US | South Dakota | Buffalo | 46017 | 99 | 3 | 0 | 96 | 44.07657829 | -99.20814467 | 2020-07-19 04:34:58 | Buffalo, South Dakota, US |
2020-07-18 | US | Puerto Rico | Cidra | 72041 | 96 | 0 | 0 | 96 | 18.173559 | -66.161179 | 2020-07-19 04:34:58 | Cidra, Puerto Rico, US |
2020-07-18 | US | Pennsylvania | Clearfield | 42033 | 96 | 0 | 0 | 96 | 41.00110782 | -78.47592663 | 2020-07-19 04:34:58 | Clearfield, Pennsylvania, US |
2020-07-18 | US | Kansas | Cowley | 20035 | 97 | 1 | 0 | 96 | 37.23781842 | -96.83776647 | 2020-07-19 04:34:58 | Cowley, Kansas, US |
2020-07-18 | US | Virginia | Grayson | 51077 | 100 | 4 | 0 | 96 | 36.65677234 | -81.23215889 | 2020-07-19 04:34:58 | Grayson, Virginia, US |
2020-07-18 | US | Mississippi | Stone | 28131 | 98 | 2 | 0 | 96 | 30.79187949 | -89.11547539 | 2020-07-19 04:34:58 | Stone, Mississippi, US |
2020-07-18 | US | Vermont | Windham | 50025 | 99 | 3 | 0 | 96 | 42.986982 | -72.71268875 | 2020-07-19 04:34:58 | Windham, Vermont, US |
2020-07-18 | US | Kentucky | Woodford | 21239 | 96 | 0 | 0 | 96 | 38.04178222 | -84.7417556 | 2020-07-19 04:34:58 | Woodford, Kentucky, US |
2020-07-18 | Japan | Hokkaido | 1339 | 102 | 1141 | 96 | 43.385711 | 142.55231799999999 | 2020-07-19 04:34:58 | Hokkaido, Japan | ||
2020-07-18 | Eritrea | 251 | 0 | 155 | 96 | 15.1794 | 39.7823 | 2020-07-19 04:34:58 | Eritrea | |||
2020-07-18 | US | South Carolina | Greenwood | 45047 | 968 | 10 | 0 | 958 | 34.15272415 | -82.12715789 | 2020-07-19 04:34:58 | Greenwood, South Carolina, US |
2020-07-18 | US | New Mexico | Unassigned | 90035 | 955 | 0 | 0 | 955 | 36.60569702 | -108.7151824 | 2020-07-19 04:34:58 | Unassigned, New Mexico, US |
2020-07-18 | US | Louisiana | St. Mary | 22101 | 990 | 39 | 0 | 951 | 29.69262097 | -91.44702164 | 2020-07-19 04:34:58 | St. Mary, Louisiana, US |
2020-07-18 | Ukraine | Kiev Oblast | 3229 | 59 | 2219 | 951 | 50.053000000000004 | 30.7667 | 2020-07-19 04:34:58 | Kiev Oblast, Ukraine | ||
2020-07-18 | US | South Dakota | Clay | 46027 | 95 | 0 | 0 | 95 | 42.91296147 | -96.97656917 | 2020-07-19 04:34:58 | Clay, South Dakota, US |
2020-07-18 | US | Texas | Crockett | 48105 | 83 | 1 | 0 | 95 | 30.72367027 | -101.4134238 | 2020-07-19 04:34:58 | Crockett, Texas, US |
2020-07-18 | US | Puerto Rico | Guayama | 72057 | 95 | 0 | 0 | 95 | 18.007516 | -66.13390799999999 | 2020-07-19 04:34:58 | Guayama, Puerto Rico, US |
2020-07-18 | US | West Virginia | Raleigh | 54081 | 95 | 0 | 0 | 95 | 37.76936795 | -81.2456041 | 2020-07-19 04:34:58 | Raleigh, West Virginia, US |
2020-07-18 | Ukraine | Dnipropetrovsk Oblast | 1183 | 25 | 1063 | 95 | 48.4647 | 35.0462 | 2020-07-19 04:34:58 | Dnipropetrovsk Oblast, Ukraine | ||
2020-07-18 | Ukraine | Mykolaiv Oblast | 510 | 12 | 403 | 95 | 46.975 | 31.9946 | 2020-07-19 04:34:58 | Mykolaiv Oblast, Ukraine | ||
2020-07-18 | Kuwait | 58904 | 407 | 49020 | 9477 | 29.311659999999996 | 47.481766 | 2020-07-19 04:34:58 | Kuwait | |||
2020-07-18 | US | Kentucky | Kenton | 21117 | 981 | 37 | 0 | 944 | 38.93950319 | -84.53241199 | 2020-07-19 04:34:58 | Kenton, Kentucky, US |
2020-07-18 | US | Washington | Grant | 53025 | 950 | 7 | 0 | 943 | 47.20753737 | -119.4500749 | 2020-07-19 04:34:58 | Grant, Washington, US |
2020-07-18 | Russia | Krasnodar Krai | 7115 | 94 | 6078 | 943 | 45.7684014 | 39.0261044 | 2020-07-19 04:34:58 | Krasnodar Krai, Russia | ||
2020-07-18 | US | Georgia | DeKalb | 13089 | 9597 | 188 | 0 | 9409 | 33.76944049 | -84.22396017 | 2020-07-19 04:34:58 | DeKalb, Georgia, US |
2020-07-18 | US | Texas | Bastrop | 48021 | 870 | 12 | 0 | 940 | 30.10370699 | -97.31206354 | 2020-07-19 04:34:58 | Bastrop, Texas, US |
2020-07-18 | Russia | Dagestan Republic | 8735 | 424 | 7371 | 940 | 43.05749160000001 | 47.1332224 | 2020-07-19 04:34:58 | Dagestan Republic, Russia | ||
2020-07-18 | US | Arkansas | Clark | 5019 | 94 | 0 | 0 | 94 | 34.04613432 | -93.17484713 | 2020-07-19 04:34:58 | Clark, Arkansas, US |
2020-07-18 | US | Idaho | Gem | 16045 | 94 | 0 | 0 | 94 | 44.06482372 | -116.398376 | 2020-07-19 04:34:58 | Gem, Idaho, US |
2020-07-18 | US | Idaho | Gooding | 16047 | 95 | 1 | 0 | 94 | 42.96927962 | -114.8108306 | 2020-07-19 04:34:58 | Gooding, Idaho, US |
2020-07-18 | US | Georgia | Heard | 13149 | 97 | 3 | 0 | 94 | 33.29686567 | -85.12886832 | 2020-07-19 04:34:58 | Heard, Georgia, US |
2020-07-18 | US | Idaho | Madison | 16065 | 94 | 0 | 0 | 94 | 43.78141028 | -111.65384740000002 | 2020-07-19 04:34:58 | Madison, Idaho, US |
2020-07-18 | US | Kansas | McPherson | 20113 | 94 | 0 | 0 | 94 | 38.39184858 | -97.64769869 | 2020-07-19 04:34:58 | McPherson, Kansas, US |
2020-07-18 | India | Bihar | 25136 | 208 | 15536 | 9392 | 25.679658 | 85.60484 | 2020-07-19 04:34:58 | Bihar, India | ||
2020-07-18 | US | Arkansas | Jefferson | 5069 | 969 | 30 | 0 | 939 | 34.26767081 | -91.92619839 | 2020-07-19 04:34:58 | Jefferson, Arkansas, US |
2020-07-18 | US | Arkansas | St. Francis | 5123 | 942 | 3 | 0 | 939 | 35.02201976 | -90.74828138 | 2020-07-19 04:34:58 | St. Francis, Arkansas, US |
2020-07-18 | Mexico | Quintana Roo | 6096 | 786 | 4371 | 939 | 19.1817 | -88.4791 | 2020-07-19 04:34:58 | Quintana Roo, Mexico | ||
2020-07-18 | US | South Carolina | Kershaw | 45055 | 956 | 19 | 0 | 937 | 34.33988254 | -80.58763164 | 2020-07-19 04:34:58 | Kershaw, South Carolina, US |
2020-07-18 | Sweden | Varmland | 1007 | 71 | 0 | 936 | 59.7294 | 13.2354 | 2020-07-19 04:34:58 | Varmland, Sweden | ||
2020-07-18 | US | Illinois | Cook | 17031 | 98292 | 4774 | 0 | 93518 | 41.84144849 | -87.81658794 | 2020-07-19 04:34:58 | Cook, Illinois, US |
2020-07-18 | US | South Carolina | Georgetown | 45043 | 943 | 11 | 0 | 932 | 33.43443342 | -79.33202141 | 2020-07-19 04:34:58 | Georgetown, South Carolina, US |
2020-07-18 | US | Wyoming | Campbell | 56005 | 93 | 0 | 0 | 93 | 44.24886082 | -105.5474404 | 2020-07-19 04:34:58 | Campbell, Wyoming, US |
2020-07-18 | US | Texas | Freestone | 48161 | 77 | 0 | 0 | 93 | 31.70422788 | -96.15072516 | 2020-07-19 04:34:58 | Freestone, Texas, US |
2020-07-18 | US | Minnesota | Isanti | 27059 | 93 | 0 | 0 | 93 | 45.56181234 | -93.29487636 | 2020-07-19 04:34:58 | Isanti, Minnesota, US |
2020-07-18 | US | Minnesota | Murray | 27101 | 93 | 0 | 0 | 93 | 44.02216709 | -95.76328482 | 2020-07-19 04:34:58 | Murray, Minnesota, US |
2020-07-18 | US | Texas | Moore | 48341 | 962 | 15 | 0 | 925 | 35.83769242 | -101.8930281 | 2020-07-19 04:34:58 | Moore, Texas, US |
2020-07-18 | US | Arizona | Maricopa | 4013 | 93870 | 1444 | 0 | 92426 | 33.34835867 | -112.4918154 | 2020-07-19 04:34:58 | Maricopa, Arizona, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;