johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
91 rows where confirmed = 5 and "day" is on date 2020-05-02 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2043268 | 2043268 | 2020-05-02 | Canada | Northwest Territories | 5 | 0 | 0 | 5 | 64.8255 | -124.8457 | 2020-05-03 02:32:28 | Northwest Territories, Canada | ||
2043150 | 2043150 | 2020-05-02 | US | Texas | Winkler | 48495 | 5 | 0 | 0 | 3 | 31.85008651 | -103.04851629999999 | 2020-05-03 02:32:28 | Winkler, Texas, US |
2043110 | 2043110 | 2020-05-02 | US | Georgia | Wheeler | 13309 | 5 | 0 | 0 | 5 | 32.12009104 | -82.72574721 | 2020-05-03 02:32:28 | Wheeler, Georgia, US |
2043095 | 2043095 | 2020-05-02 | US | Nebraska | Webster | 31181 | 5 | 0 | 0 | 5 | 40.17642643 | -98.50019851 | 2020-05-03 02:32:28 | Webster, Nebraska, US |
2043043 | 2043043 | 2020-05-02 | US | Kentucky | Washington | 21229 | 5 | 0 | 0 | 5 | 37.75599461 | -85.17407732 | 2020-05-03 02:32:28 | Washington, Kentucky, US |
2043030 | 2043030 | 2020-05-02 | US | Minnesota | Waseca | 27161 | 5 | 0 | 0 | 5 | 44.02211116 | -93.58720034 | 2020-05-03 02:32:28 | Waseca, Minnesota, US |
2043008 | 2043008 | 2020-05-02 | US | South Dakota | Walworth | 46129 | 5 | 0 | 0 | 5 | 45.43019636 | -100.03075140000001 | 2020-05-03 02:32:28 | Walworth, South Dakota, US |
2042940 | 2042940 | 2020-05-02 | US | Florida | Union | 12125 | 5 | 0 | 0 | 5 | 30.04412971 | -82.37497443 | 2020-05-03 02:32:28 | Union, Florida, US |
2042738 | 2042738 | 2020-05-02 | US | Nebraska | Stanton | 31167 | 5 | 0 | 0 | 5 | 41.9169835 | -97.19394708 | 2020-05-03 02:32:28 | Stanton, Nebraska, US |
2042701 | 2042701 | 2020-05-02 | US | Indiana | Spencer | 18147 | 5 | 1 | 0 | 4 | 38.01519732 | -87.0079644 | 2020-05-03 02:32:28 | Spencer, Indiana, US |
2042676 | 2042676 | 2020-05-02 | US | California | Siskiyou | 6093 | 5 | 0 | 0 | 5 | 41.59198861 | -122.54074340000001 | 2020-05-03 02:32:28 | Siskiyou, California, US |
2042664 | 2042664 | 2020-05-02 | US | Kansas | Sherman | 20181 | 5 | 0 | 0 | 5 | 39.35147699 | -101.71976240000001 | 2020-05-03 02:32:28 | Sherman, Kansas, US |
2042645 | 2042645 | 2020-05-02 | US | Mississippi | Sharkey | 28125 | 5 | 0 | 0 | 5 | 32.88149103 | -90.81595379999999 | 2020-05-03 02:32:28 | Sharkey, Mississippi, US |
2042553 | 2042553 | 2020-05-02 | US | Virginia | Russell | 51167 | 5 | 0 | 0 | 5 | 36.93028320000001 | -82.10095486 | 2020-05-03 02:32:28 | Russell, Virginia, US |
2042514 | 2042514 | 2020-05-02 | US | Missouri | Ripley | 29181 | 5 | 0 | 0 | 5 | 36.65460667 | -90.85990261 | 2020-05-03 02:32:28 | Ripley, Missouri, US |
2042491 | 2042491 | 2020-05-02 | US | Minnesota | Renville | 27129 | 5 | 0 | 0 | 5 | 44.72836381 | -94.94553734 | 2020-05-03 02:32:28 | Renville, Minnesota, US |
2042481 | 2042481 | 2020-05-02 | US | Montana | Ravalli | 30081 | 5 | 0 | 0 | 5 | 46.08520862 | -114.11891640000002 | 2020-05-03 02:32:28 | Ravalli, Montana, US |
2042458 | 2042458 | 2020-05-02 | US | Georgia | Quitman | 13239 | 5 | 1 | 0 | 4 | 31.86728114 | -85.01773177 | 2020-05-03 02:32:28 | Quitman, Georgia, US |
2042349 | 2042349 | 2020-05-02 | US | Arkansas | Phillips | 5107 | 5 | 1 | 0 | 4 | 34.43268455 | -90.84800154 | 2020-05-03 02:32:28 | Phillips, Arkansas, US |
2042323 | 2042323 | 2020-05-02 | US | Kentucky | Pendleton | 21191 | 5 | 0 | 0 | 5 | 38.69607718 | -84.35599463 | 2020-05-03 02:32:28 | Pendleton, Kentucky, US |
2042297 | 2042297 | 2020-05-02 | US | Texas | Palo Pinto | 48363 | 5 | 1 | 0 | 7 | 32.75310985 | -98.31319001 | 2020-05-03 02:32:28 | Palo Pinto, Texas, US |
2042264 | 2042264 | 2020-05-02 | US | Michigan | Oscoda | 26135 | 5 | 0 | 0 | 5 | 44.68192279 | -84.12939244 | 2020-05-03 02:32:28 | Oscoda, Michigan, US |
2042258 | 2042258 | 2020-05-02 | US | Missouri | Osage | 29151 | 5 | 0 | 0 | 5 | 38.46036182 | -91.8613635 | 2020-05-03 02:32:28 | Osage, Missouri, US |
2042257 | 2042257 | 2020-05-02 | US | Kansas | Osage | 20139 | 5 | 0 | 0 | 5 | 38.65235984 | -95.72707998 | 2020-05-03 02:32:28 | Osage, Kansas, US |
2042190 | 2042190 | 2020-05-02 | US | Ohio | Noble | 39121 | 5 | 0 | 0 | 5 | 39.76818851 | -81.45937183 | 2020-05-03 02:32:28 | Noble, Ohio, US |
2042133 | 2042133 | 2020-05-02 | US | Illinois | Moultrie | 17139 | 5 | 0 | 0 | 5 | 39.64187451 | -88.62099969 | 2020-05-03 02:32:28 | Moultrie, Illinois, US |
2042119 | 2042119 | 2020-05-02 | US | Missouri | Morgan | 29141 | 5 | 0 | 0 | 5 | 38.4181765 | -92.88791859 | 2020-05-03 02:32:28 | Morgan, Missouri, US |
2042108 | 2042108 | 2020-05-02 | US | South Dakota | Moody | 46101 | 5 | 0 | 0 | 5 | 44.02266214 | -96.67081159 | 2020-05-03 02:32:28 | Moody, South Dakota, US |
2042105 | 2042105 | 2020-05-02 | US | Michigan | Montmorency | 26119 | 5 | 0 | 0 | 5 | 45.0275929 | -84.12696227 | 2020-05-03 02:32:28 | Montmorency, Michigan, US |
2042081 | 2042081 | 2020-05-02 | US | West Virginia | Monroe | 54063 | 5 | 0 | 0 | 5 | 37.56274716 | -80.54577965 | 2020-05-03 02:32:28 | Monroe, West Virginia, US |
2042074 | 2042074 | 2020-05-02 | US | Kentucky | Monroe | 21171 | 5 | 0 | 0 | 5 | 36.71225341 | -85.71596443 | 2020-05-03 02:32:28 | Monroe, Kentucky, US |
2042058 | 2042058 | 2020-05-02 | US | North Carolina | Mitchell | 37121 | 5 | 0 | 0 | 5 | 36.01059309 | -82.1582442 | 2020-05-03 02:32:28 | Mitchell, North Carolina, US |
2042026 | 2042026 | 2020-05-02 | US | Kansas | Miami | 20121 | 5 | 0 | 0 | 5 | 38.56383358 | -94.83832189 | 2020-05-03 02:32:28 | Miami, Kansas, US |
2042010 | 2042010 | 2020-05-02 | US | Michigan | Menominee | 26109 | 5 | 0 | 0 | 5 | 45.58038692 | -87.55370409 | 2020-05-03 02:32:28 | Menominee, Michigan, US |
2041923 | 2041923 | 2020-05-02 | US | Missouri | Marion | 29127 | 5 | 0 | 0 | 5 | 39.80601912 | -91.62203062 | 2020-05-03 02:32:28 | Marion, Missouri, US |
2041920 | 2041920 | 2020-05-02 | US | Kansas | Marion | 20115 | 5 | 1 | 0 | 4 | 38.35855394 | -97.09852509999999 | 2020-05-03 02:32:28 | Marion, Kansas, US |
2041838 | 2041838 | 2020-05-02 | US | Georgia | Long | 13183 | 5 | 0 | 0 | 5 | 31.75218791 | -81.74952375 | 2020-05-03 02:32:28 | Long, Georgia, US |
2041824 | 2041824 | 2020-05-02 | US | Kentucky | Livingston | 21139 | 5 | 0 | 0 | 5 | 37.21137452 | -88.34797529 | 2020-05-03 02:32:28 | Livingston, Kentucky, US |
2041818 | 2041818 | 2020-05-02 | US | Missouri | Linn | 29115 | 5 | 1 | 0 | 4 | 39.87001769 | -93.10704106 | 2020-05-03 02:32:28 | Linn, Missouri, US |
2041809 | 2041809 | 2020-05-02 | US | Oregon | Lincoln | 41041 | 5 | 0 | 0 | 5 | 44.64252874 | -123.86991200000001 | 2020-05-03 02:32:28 | Lincoln, Oregon, US |
2041797 | 2041797 | 2020-05-02 | US | Kentucky | Lincoln | 21137 | 5 | 1 | 0 | 4 | 37.45475628 | -84.6565327 | 2020-05-03 02:32:28 | Lincoln, Kentucky, US |
2041785 | 2041785 | 2020-05-02 | US | Virginia | Lexington | 51678 | 5 | 0 | 0 | 5 | 37.78258621 | -79.44262866 | 2020-05-03 02:32:28 | Lexington, Virginia, US |
2041730 | 2041730 | 2020-05-02 | US | Oklahoma | Latimer | 40077 | 5 | 1 | 0 | 4 | 34.87844729 | -95.25215049 | 2020-05-03 02:32:28 | Latimer, Oklahoma, US |
2041729 | 2041729 | 2020-05-02 | US | Idaho | Latah | 16057 | 5 | 0 | 0 | 5 | 46.81587887 | -116.71136979999999 | 2020-05-03 02:32:28 | Latah, Idaho, US |
2041727 | 2041727 | 2020-05-02 | US | Kentucky | Larue | 21123 | 5 | 0 | 0 | 5 | 37.54567114 | -85.70138352 | 2020-05-03 02:32:28 | Larue, Kentucky, US |
2041706 | 2041706 | 2020-05-02 | US | Montana | Lake | 30047 | 5 | 0 | 0 | 5 | 47.64514965 | -114.0898013 | 2020-05-03 02:32:28 | Lake, Montana, US |
2041660 | 2041660 | 2020-05-02 | US | Oklahoma | Kiowa | 40075 | 5 | 0 | 0 | 5 | 34.91671958 | -98.97720696 | 2020-05-03 02:32:28 | Kiowa, Oklahoma, US |
2041563 | 2041563 | 2020-05-02 | US | Idaho | Jefferson | 16051 | 5 | 0 | 0 | 5 | 43.82078483 | -112.3131749 | 2020-05-03 02:32:28 | Jefferson, Idaho, US |
2041531 | 2041531 | 2020-05-02 | US | Iowa | Jackson | 19097 | 5 | 0 | 0 | 5 | 42.17178824 | -90.57354837 | 2020-05-03 02:32:28 | Jackson, Iowa, US |
2041480 | 2041480 | 2020-05-02 | US | Missouri | Howell | 29091 | 5 | 0 | 0 | 5 | 36.77383887 | -91.88683935 | 2020-05-03 02:32:28 | Howell, Missouri, US |
2041463 | 2041463 | 2020-05-02 | US | Texas | Hopkins | 48223 | 5 | 0 | 0 | 6 | 33.14875072 | -95.56351139 | 2020-05-03 02:32:28 | Hopkins, Texas, US |
2041429 | 2041429 | 2020-05-02 | US | Ohio | Henry | 39069 | 5 | 1 | 0 | 4 | 41.333964200000004 | -84.06830637 | 2020-05-03 02:32:28 | Henry, Ohio, US |
2041413 | 2041413 | 2020-05-02 | US | Illinois | Henderson | 17071 | 5 | 0 | 0 | 5 | 40.81908672 | -90.92491462 | 2020-05-03 02:32:28 | Henderson, Illinois, US |
2041404 | 2041404 | 2020-05-02 | US | Oklahoma | Haskell | 40061 | 5 | 0 | 0 | 5 | 35.22257600000001 | -95.11513306 | 2020-05-03 02:32:28 | Haskell, Oklahoma, US |
2041394 | 2041394 | 2020-05-02 | US | Ohio | Harrison | 39067 | 5 | 0 | 0 | 5 | 40.29380509 | -81.09068544 | 2020-05-03 02:32:28 | Harrison, Ohio, US |
2041351 | 2041351 | 2020-05-02 | US | Texas | Hamilton | 48193 | 5 | 0 | 0 | 5 | 31.70470573 | -98.11083887 | 2020-05-03 02:32:28 | Hamilton, Texas, US |
2041305 | 2041305 | 2020-05-02 | US | Mississippi | Greene | 28041 | 5 | 1 | 0 | 4 | 31.21444233 | -88.63922281 | 2020-05-03 02:32:28 | Greene, Mississippi, US |
2041298 | 2041298 | 2020-05-02 | US | West Virginia | Greenbrier | 54025 | 5 | 0 | 0 | 5 | 37.9463652 | -80.45335881 | 2020-05-03 02:32:28 | Greenbrier, West Virginia, US |
2041288 | 2041288 | 2020-05-02 | US | Kansas | Gray | 20069 | 5 | 0 | 0 | 5 | 37.73836671 | -100.4369088 | 2020-05-03 02:32:28 | Gray, Kansas, US |
2041274 | 2041274 | 2020-05-02 | US | Kansas | Grant | 20067 | 5 | 0 | 0 | 5 | 37.56227336 | -101.3079758 | 2020-05-03 02:32:28 | Grant, Kansas, US |
2041268 | 2041268 | 2020-05-02 | US | Colorado | Grand | 8049 | 5 | 0 | 0 | 5 | 40.10603347 | -106.11780420000001 | 2020-05-03 02:32:28 | Grand, Colorado, US |
2041247 | 2041247 | 2020-05-02 | US | California | Glenn | 6021 | 5 | 0 | 0 | 5 | 39.59875897 | -122.3938452 | 2020-05-03 02:32:28 | Glenn, California, US |
2041236 | 2041236 | 2020-05-02 | US | Florida | Gilchrist | 12041 | 5 | 0 | 0 | 5 | 29.72856978 | -82.79880657 | 2020-05-03 02:32:28 | Gilchrist, Florida, US |
2041202 | 2041202 | 2020-05-02 | US | Pennsylvania | Fulton | 42057 | 5 | 0 | 0 | 5 | 39.92913544 | -78.11163677 | 2020-05-03 02:32:28 | Fulton, Pennsylvania, US |
2041173 | 2041173 | 2020-05-02 | US | Nebraska | Franklin | 31061 | 5 | 0 | 0 | 5 | 40.17636348 | -98.95299073 | 2020-05-03 02:32:28 | Franklin, Nebraska, US |
2041128 | 2041128 | 2020-05-02 | US | Texas | Fayette | 48149 | 5 | 1 | 0 | 14 | 29.87788372 | -96.92076062 | 2020-05-03 02:32:28 | Fayette, Texas, US |
2041103 | 2041103 | 2020-05-02 | US | Georgia | Evans | 13109 | 5 | 0 | 0 | 5 | 32.15328841 | -81.8870105 | 2020-05-03 02:32:28 | Evans, Georgia, US |
2041077 | 2041077 | 2020-05-02 | US | Pennsylvania | Elk | 42047 | 5 | 0 | 0 | 5 | 41.42822061 | -78.64524744 | 2020-05-03 02:32:28 | Elk, Pennsylvania, US |
2041061 | 2041061 | 2020-05-02 | US | Georgia | Echols | 13101 | 5 | 0 | 0 | 5 | 30.71101099 | -82.89687287 | 2020-05-03 02:32:28 | Echols, Georgia, US |
2040928 | 2040928 | 2020-05-02 | US | North Carolina | Currituck | 37053 | 5 | 0 | 0 | 5 | 36.36123664 | -75.95876401 | 2020-05-03 02:32:28 | Currituck, North Carolina, US |
2040920 | 2040920 | 2020-05-02 | US | Kentucky | Cumberland | 21057 | 5 | 0 | 0 | 5 | 36.78926125 | -85.39050034 | 2020-05-03 02:32:28 | Cumberland, Kentucky, US |
2040912 | 2040912 | 2020-05-02 | US | Wyoming | Crook | 56011 | 5 | 0 | 0 | 5 | 44.58855102 | -104.56977049999999 | 2020-05-03 02:32:28 | Crook, Wyoming, US |
2040894 | 2040894 | 2020-05-02 | US | Arkansas | Crawford | 5033 | 5 | 0 | 0 | 5 | 35.58928601 | -94.2446814 | 2020-05-03 02:32:28 | Crawford, Arkansas, US |
2040881 | 2040881 | 2020-05-02 | US | Oklahoma | Cotton | 40033 | 5 | 1 | 0 | 4 | 34.28845626 | -98.37053567 | 2020-05-03 02:32:28 | Cotton, Oklahoma, US |
2040840 | 2040840 | 2020-05-02 | US | New Mexico | Colfax | 35007 | 5 | 0 | 0 | 5 | 36.60569702 | -104.64726740000002 | 2020-05-03 02:32:28 | Colfax, New Mexico, US |
2040763 | 2040763 | 2020-05-02 | US | Tennessee | Claiborne | 47025 | 5 | 0 | 0 | 5 | 36.48319149 | -83.65947309 | 2020-05-03 02:32:28 | Claiborne, Tennessee, US |
2040739 | 2040739 | 2020-05-02 | US | Iowa | Chickasaw | 19037 | 5 | 0 | 0 | 5 | 43.06001295 | -92.31773347 | 2020-05-03 02:32:28 | Chickasaw, Iowa, US |
2040701 | 2040701 | 2020-05-02 | US | South Dakota | Charles Mix | 46023 | 5 | 0 | 0 | 5 | 43.20660134 | -98.58856175 | 2020-05-03 02:32:28 | Charles Mix, South Dakota, US |
2040698 | 2040698 | 2020-05-02 | US | Missouri | Chariton | 29041 | 5 | 0 | 0 | 5 | 39.51499357 | -92.9629191 | 2020-05-03 02:32:28 | Chariton, Missouri, US |
2040688 | 2040688 | 2020-05-02 | US | Missouri | Cedar | 29039 | 5 | 0 | 0 | 5 | 37.72391475 | -93.85445441 | 2020-05-03 02:32:28 | Cedar, Missouri, US |
2040660 | 2040660 | 2020-05-02 | US | Kentucky | Carter | 21043 | 5 | 0 | 0 | 5 | 38.31690743 | -83.05092385 | 2020-05-03 02:32:28 | Carter, Kentucky, US |
2040639 | 2040639 | 2020-05-02 | US | Wyoming | Carbon | 56007 | 5 | 0 | 0 | 5 | 41.69357844 | -106.9326084 | 2020-05-03 02:32:28 | Carbon, Wyoming, US |
2040578 | 2040578 | 2020-05-02 | US | Texas | Burnet | 48053 | 5 | 0 | 0 | 20 | 30.78801353 | -98.181887 | 2020-05-03 02:32:28 | Burnet, Texas, US |
2040462 | 2040462 | 2020-05-02 | US | Michigan | Benzie | 26019 | 5 | 0 | 0 | 5 | 44.63899297 | -86.01608482 | 2020-05-03 02:32:28 | Benzie, Michigan, US |
2040442 | 2040442 | 2020-05-02 | US | Oklahoma | Beckham | 40009 | 5 | 0 | 0 | 5 | 35.26862449 | -99.68128023 | 2020-05-03 02:32:28 | Beckham, Oklahoma, US |
2040429 | 2040429 | 2020-05-02 | US | Arkansas | Baxter | 5005 | 5 | 0 | 0 | 5 | 36.28784385 | -92.33782872 | 2020-05-03 02:32:28 | Baxter, Arkansas, US |
2040413 | 2040413 | 2020-05-02 | US | West Virginia | Barbour | 54001 | 5 | 1 | 0 | 4 | 39.1307219 | -80.00350858 | 2020-05-03 02:32:28 | Barbour, West Virginia, US |
2040374 | 2040374 | 2020-05-02 | US | North Carolina | Ashe | 37009 | 5 | 0 | 0 | 5 | 36.43296207 | -81.49862729 | 2020-05-03 02:32:28 | Ashe, North Carolina, US |
2040371 | 2040371 | 2020-05-02 | US | Maine | Aroostook | 23003 | 5 | 0 | 0 | 5 | 46.65926321 | -68.59841248 | 2020-05-03 02:32:28 | Aroostook, Maine, US |
2040320 | 2040320 | 2020-05-02 | US | Michigan | Alcona | 26001 | 5 | 1 | 0 | 4 | 44.6846864 | -83.59507875 | 2020-05-03 02:32:28 | Alcona, Michigan, US |
2040306 | 2040306 | 2020-05-02 | US | Ohio | Adams | 39001 | 5 | 0 | 0 | 5 | 38.84541072 | -83.4718964 | 2020-05-03 02:32:28 | Adams, Ohio, US |
Advanced export
JSON shape: default, array, newline-delimited
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]);