johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
62 rows where confirmed = 9162 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2417723 | 2417723 | 2022-12-05 | US | South Carolina | Union | 45087 | 9162 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-06 04:21:03 | Union, South Carolina, US | |
721331 | 721331 | 2022-12-04 | US | South Carolina | Union | 45087 | 9162 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-05 04:20:58 | Union, South Carolina, US | |
2819620 | 2819620 | 2022-12-03 | US | South Carolina | Union | 45087 | 9162 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-04 04:20:56 | Union, South Carolina, US | |
836476 | 836476 | 2022-12-02 | US | South Carolina | Union | 45087 | 9162 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-03 04:21:02 | Union, South Carolina, US | |
2139006 | 2139006 | 2022-12-01 | US | South Carolina | Union | 45087 | 9162 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-02 04:21:07 | Union, South Carolina, US | |
1967422 | 1967422 | 2022-11-30 | US | South Carolina | Union | 45087 | 9162 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-01 04:21:03 | Union, South Carolina, US | |
2560117 | 2560117 | 2022-11-29 | US | West Virginia | Wyoming | 54109 | 9162 | 133 | 0 | 37.612327 | -81.54511071 | 2022-11-30 04:21:07 | Wyoming, West Virginia, US | |
2559436 | 2559436 | 2022-11-29 | US | South Carolina | Union | 45087 | 9162 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-11-30 04:21:07 | Union, South Carolina, US | |
133065 | 133065 | 2022-10-04 | US | North Carolina | Dare | 37055 | 9162 | 30 | 0 | 35.66520691 | -75.71767334 | 2022-10-05 04:23:06 | Dare, North Carolina, US | |
2688012 | 2688012 | 2022-10-03 | US | North Carolina | Dare | 37055 | 9162 | 30 | 0 | 35.66520691 | -75.71767334 | 2022-10-04 04:22:55 | Dare, North Carolina, US | |
2262079 | 2262079 | 2022-10-02 | US | North Carolina | Dare | 37055 | 9162 | 30 | 0 | 35.66520691 | -75.71767334 | 2022-10-03 04:23:11 | Dare, North Carolina, US | |
2997605 | 2997605 | 2022-10-01 | US | North Carolina | Dare | 37055 | 9162 | 30 | 0 | 35.66520691 | -75.71767334 | 2022-10-02 04:21:23 | Dare, North Carolina, US | |
855931 | 855931 | 2022-09-30 | US | North Carolina | Dare | 37055 | 9162 | 30 | 0 | 35.66520691 | -75.71767334 | 2022-10-01 04:23:01 | Dare, North Carolina, US | |
2377857 | 2377857 | 2022-09-29 | US | North Carolina | Dare | 37055 | 9162 | 30 | 0 | 35.66520691 | -75.71767334 | 2022-09-30 04:23:09 | Dare, North Carolina, US | |
1562408 | 1562408 | 2022-09-28 | US | North Carolina | Dare | 37055 | 9162 | 30 | 0 | 35.66520691 | -75.71767334 | 2022-09-29 04:22:34 | Dare, North Carolina, US | |
3109758 | 3109758 | 2022-07-13 | Saint Vincent and the Grenadines | 9162 | 114 | 0 | 12.9843 | -61.2872 | 2022-07-14 04:20:57 | Saint Vincent and the Grenadines | ||||
2792489 | 2792489 | 2022-07-10 | US | Washington | Okanogan | 53047 | 9162 | 127 | 0 | 48.54855019 | -119.7387224 | 2022-07-11 04:20:46 | Okanogan, Washington, US | |
145442 | 145442 | 2022-07-09 | US | Washington | Okanogan | 53047 | 9162 | 127 | 0 | 48.54855019 | -119.7387224 | 2022-07-10 04:20:54 | Okanogan, Washington, US | |
1420542 | 1420542 | 2022-07-08 | US | Washington | Okanogan | 53047 | 9162 | 127 | 0 | 48.54855019 | -119.7387224 | 2022-07-09 04:20:59 | Okanogan, Washington, US | |
2492968 | 2492968 | 2022-06-29 | US | Tennessee | Hardin | 47071 | 9162 | 154 | 0 | 35.19732531 | -88.18593755 | 2022-06-30 04:21:01 | Hardin, Tennessee, US | |
560563 | 560563 | 2022-06-16 | US | Minnesota | Polk | 27119 | 9162 | 109 | 0 | 47.77372465 | -96.40134647 | 2022-06-17 04:20:56 | Polk, Minnesota, US | |
560506 | 560506 | 2022-06-16 | US | Minnesota | Becker | 27005 | 9162 | 95 | 0 | 46.93479392 | -95.67158144 | 2022-06-17 04:20:56 | Becker, Minnesota, US | |
3024437 | 3024437 | 2022-03-23 | US | New Hampshire | Sullivan | 33019 | 9162 | 67 | 0 | 43.36094111 | -72.22203125 | 2022-03-24 04:20:43 | Sullivan, New Hampshire, US | |
1907359 | 1907359 | 2022-03-22 | US | New Hampshire | Sullivan | 33019 | 9162 | 67 | 0 | 43.36094111 | -72.22203125 | 2022-03-23 04:20:48 | Sullivan, New Hampshire, US | |
3240482 | 3240482 | 2022-03-21 | US | New Hampshire | Carroll | 33003 | 9162 | 56 | 0 | 43.87498583 | -71.20430216 | 2022-03-22 04:20:54 | Carroll, New Hampshire, US | |
2094326 | 2094326 | 2022-03-05 | US | New York | Chenango | 36017 | 9162 | 117 | 0 | 42.49430041 | -75.60887553 | 2022-03-06 04:20:49 | Chenango, New York, US | |
3855945 | 3855945 | 2022-02-18 | Monaco | 9162 | 51 | 0 | 43.7333 | 7.4167 | 2022-02-19 04:21:11 | Monaco | ||||
1363580 | 1363580 | 2022-02-08 | US | Iowa | Muscatine | 19139 | 9162 | 128 | 0 | 41.48370744 | -91.11216970000001 | 2022-02-09 04:21:04 | Muscatine, Iowa, US | |
72318 | 72318 | 2022-02-07 | US | Iowa | Muscatine | 19139 | 9162 | 128 | 0 | 41.48370744 | -91.11216970000001 | 2022-02-08 04:21:15 | Muscatine, Iowa, US | |
2013934 | 2013934 | 2022-02-06 | US | Iowa | Muscatine | 19139 | 9162 | 128 | 0 | 41.48370744 | -91.11216970000001 | 2022-02-07 04:21:05 | Muscatine, Iowa, US | |
1295263 | 1295263 | 2022-02-05 | US | Iowa | Muscatine | 19139 | 9162 | 128 | 0 | 41.48370744 | -91.11216970000001 | 2022-02-06 04:21:00 | Muscatine, Iowa, US | |
2328591 | 2328591 | 2022-02-04 | US | Iowa | Muscatine | 19139 | 9162 | 128 | 0 | 41.48370744 | -91.11216970000001 | 2022-02-05 04:21:05 | Muscatine, Iowa, US | |
2475182 | 2475182 | 2022-02-03 | US | Iowa | Muscatine | 19139 | 9162 | 128 | 0 | 41.48370744 | -91.11216970000001 | 2022-02-04 04:21:10 | Muscatine, Iowa, US | |
460607 | 460607 | 2022-02-02 | US | Iowa | Muscatine | 19139 | 9162 | 128 | 0 | 41.48370744 | -91.11216970000001 | 2022-02-03 04:21:21 | Muscatine, Iowa, US | |
1142019 | 1142019 | 2022-01-23 | US | Indiana | Knox | 18083 | 9162 | 125 | 0 | 38.68861576 | -87.4194665 | 2022-01-24 04:21:12 | Knox, Indiana, US | |
2833937 | 2833937 | 2022-01-22 | US | Indiana | Knox | 18083 | 9162 | 125 | 0 | 38.68861576 | -87.4194665 | 2022-01-23 04:21:13 | Knox, Indiana, US | |
3426055 | 3426055 | 2022-01-21 | US | Indiana | Knox | 18083 | 9162 | 125 | 0 | 38.68861576 | -87.4194665 | 2022-01-22 04:21:13 | Knox, Indiana, US | |
1695101 | 1695101 | 2022-01-10 | US | Puerto Rico | Toa Baja | 72137 | 9162 | 0 | 0 | 18.431445999999998 | -66.213553 | 2022-01-11 04:22:01 | Toa Baja, Puerto Rico, US | |
1392598 | 1392598 | 2022-01-07 | US | Tennessee | Fayette | 47047 | 9162 | 135 | 0 | 35.19615831 | -89.41399032 | 2022-01-08 04:21:53 | Fayette, Tennessee, US | |
2114997 | 2114997 | 2021-12-26 | US | Virginia | Albemarle | 51003 | 9162 | 115 | 0 | 38.02080697 | -78.55481085 | 2021-12-27 04:21:58 | Albemarle, Virginia, US | |
3608369 | 3608369 | 2021-12-25 | US | Virginia | Albemarle | 51003 | 9162 | 115 | 0 | 38.02080697 | -78.55481085 | 2021-12-26 04:21:50 | Albemarle, Virginia, US | |
2966687 | 2966687 | 2021-12-24 | US | Virginia | Albemarle | 51003 | 9162 | 115 | 0 | 38.02080697 | -78.55481085 | 2021-12-25 04:21:37 | Albemarle, Virginia, US | |
1336113 | 1336113 | 2021-09-28 | US | Mississippi | Pearl River | 28109 | 9162 | 226 | 0 | 30.77090935 | -89.58677275 | 2021-09-29 04:21:45 | Pearl River, Mississippi, US | |
179331 | 179331 | 2021-09-02 | US | Kansas | Leavenworth | 20103 | 9162 | 108 | 0 | 39.20183497 | -95.03620809 | 2021-09-03 04:21:20 | Leavenworth, Kansas, US | |
68366 | 68366 | 2021-09-01 | US | Kansas | Leavenworth | 20103 | 9162 | 108 | 0 | 39.20183497 | -95.03620809 | 2021-09-02 04:21:15 | Leavenworth, Kansas, US | |
1485778 | 1485778 | 2021-08-13 | US | New York | Chautauqua | 36013 | 9162 | 147 | 0 | 42.22769210000001 | -79.36691763 | 2021-08-14 04:21:25 | Chautauqua, New York, US | |
1893939 | 1893939 | 2021-06-30 | US | Georgia | Fayette | 13113 | 9162 | 176 | 0 | 33.41357794 | -84.49089434 | 2021-07-01 04:21:19 | Fayette, Georgia, US | |
2424420 | 2424420 | 2021-06-23 | US | Louisiana | St. Landry | 22097 | 9162 | 261 | 0 | 30.59724262 | -92.00135806 | 2021-06-24 04:21:55 | St. Landry, Louisiana, US | |
564564 | 564564 | 2021-06-22 | US | Massachusetts | Hampshire | 25015 | 9162 | 235 | 0 | 42.33997957 | -72.65898478 | 2021-06-23 04:21:46 | Hampshire, Massachusetts, US | |
1311814 | 1311814 | 2021-05-26 | US | Michigan | Lapeer | 26087 | 9162 | 196 | 0 | 43.09052506 | -83.22153148 | 2021-05-27 04:20:59 | Lapeer, Michigan, US | |
887975 | 887975 | 2021-04-26 | Colombia | Putumayo | 9162 | 342 | 8549 | 271 | 0.436 | -75.5277 | 2021-04-27 04:20:52 | Putumayo, Colombia | ||
3245696 | 3245696 | 2021-04-21 | US | Virginia | Montgomery | 51121 | 9162 | 89 | 0 | 37.17746986 | -80.37868691 | 2021-04-22 04:20:53 | Montgomery, Virginia, US | |
2022152 | 2022152 | 2021-04-20 | US | Kentucky | Madison | 21151 | 9162 | 109 | 0 | 37.71659336 | -84.27220275 | 2021-04-21 04:21:14 | Madison, Kentucky, US | |
3085676 | 3085676 | 2021-04-05 | US | Alabama | Lauderdale | 1077 | 9162 | 227 | 0 | 34.90171875 | -87.65624729 | 2021-04-06 04:20:32 | Lauderdale, Alabama, US | |
1305595 | 1305595 | 2021-04-01 | US | Wisconsin | Jefferson | 55055 | 9162 | 125 | 0 | 43.02054068 | -88.77529134 | 2021-04-02 04:20:36 | Jefferson, Wisconsin, US | |
615506 | 615506 | 2021-02-08 | US | Mississippi | Madison | 28089 | 9162 | 186 | 0 | 8976 | 32.63389156 | -90.03513564 | 2021-02-09 05:23:30 | Madison, Mississippi, US |
976150 | 976150 | 2021-02-06 | US | Iowa | Story | 19169 | 9162 | 43 | 0 | 9119 | 42.03621213 | -93.46499005 | 2021-02-07 05:23:00 | Story, Iowa, US |
2544043 | 2544043 | 2021-01-07 | US | Pennsylvania | Beaver | 42007 | 9162 | 269 | 0 | 8893 | 40.6825484 | -80.34921611 | 2021-01-08 05:22:42 | Beaver, Pennsylvania, US |
2614746 | 2614746 | 2020-09-26 | US | Florida | Pasco | 12101 | 9162 | 208 | 0 | 8954 | 28.30810945 | -82.40227529 | 2020-09-27 04:23:00 | Pasco, Florida, US |
3045378 | 3045378 | 2020-07-02 | Peru | Loreto | 9162 | 2288 | 0 | 6874 | -4.124847 | -74.424115 | 2020-07-03 04:33:54 | Loreto, Peru | ||
1691322 | 1691322 | 2020-06-19 | Pakistan | Balochistan | 9162 | 100 | 3289 | 5773 | 28.328492 | 65.898403 | 2020-06-20 04:33:19 | Balochistan, Pakistan | ||
3638738 | 3638738 | 2020-05-30 | Colombia | Capital District | 9162 | 250 | 2918 | 5994 | 4.711 | -74.0721 | 2020-05-31 02:32:45 | Capital District, Colombia |
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]);