johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
121 rows where "day" is on date 2020-07-05 and province_or_state = "Kentucky" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
414378 | 414378 | 2020-07-05 | US | Kentucky | Robertson | 21201 | 1 | 0 | 0 | 1 | 38.51923469 | -84.05055616 | 2020-07-06 04:33:57 | Robertson, Kentucky, US |
414387 | 414387 | 2020-07-05 | US | Kentucky | Rockcastle | 21203 | 21 | 0 | 0 | 21 | 37.36642393 | -84.31176452 | 2020-07-06 04:33:57 | Rockcastle, Kentucky, US |
414404 | 414404 | 2020-07-05 | US | Kentucky | Rowan | 21205 | 23 | 0 | 0 | 23 | 38.19484205 | -83.42088935 | 2020-07-06 04:33:57 | Rowan, Kentucky, US |
414413 | 414413 | 2020-07-05 | US | Kentucky | Russell | 21207 | 47 | 4 | 0 | 43 | 36.99308373 | -85.06070117 | 2020-07-06 04:33:57 | Russell, Kentucky, US |
414487 | 414487 | 2020-07-05 | US | Kentucky | Scott | 21209 | 99 | 0 | 0 | 99 | 38.29622293 | -84.5816631 | 2020-07-06 04:33:57 | Scott, Kentucky, US |
414522 | 414522 | 2020-07-05 | US | Kentucky | Shelby | 21211 | 433 | 16 | 0 | 417 | 38.21476019 | -85.194223 | 2020-07-06 04:33:57 | Shelby, Kentucky, US |
414544 | 414544 | 2020-07-05 | US | Kentucky | Simpson | 21213 | 80 | 3 | 0 | 77 | 36.74058474 | -86.58047435 | 2020-07-06 04:33:57 | Simpson, Kentucky, US |
414576 | 414576 | 2020-07-05 | US | Kentucky | Spencer | 21215 | 38 | 0 | 0 | 38 | 38.03223971 | -85.32749335 | 2020-07-06 04:33:57 | Spencer, Kentucky, US |
414697 | 414697 | 2020-07-05 | US | Kentucky | Taylor | 21217 | 43 | 1 | 0 | 42 | 37.3677562 | -85.3329931 | 2020-07-06 04:33:57 | Taylor, Kentucky, US |
414734 | 414734 | 2020-07-05 | US | Kentucky | Todd | 21219 | 26 | 0 | 0 | 26 | 36.8381152 | -87.17878374 | 2020-07-06 04:33:57 | Todd, Kentucky, US |
414754 | 414754 | 2020-07-05 | US | Kentucky | Trigg | 21221 | 26 | 0 | 0 | 26 | 36.80767017 | -87.87333656 | 2020-07-06 04:33:57 | Trigg, Kentucky, US |
414755 | 414755 | 2020-07-05 | US | Kentucky | Trimble | 21223 | 6 | 0 | 0 | 6 | 38.61056487 | -85.33775972 | 2020-07-06 04:33:57 | Trimble, Kentucky, US |
414796 | 414796 | 2020-07-05 | US | Kentucky | Unassigned | 90021 | 4 | 0 | 0 | 4 | 38.97065142 | 0.0 | 2020-07-06 04:33:57 | Unassigned, Kentucky, US |
414837 | 414837 | 2020-07-05 | US | Kentucky | Union | 21225 | 29 | 0 | 0 | 29 | 37.66166713 | -87.94300009 | 2020-07-06 04:33:57 | Union, Kentucky, US |
414913 | 414913 | 2020-07-05 | US | Kentucky | Warren | 21227 | 1583 | 14 | 0 | 1569 | 36.99903045 | -86.42672751 | 2020-07-06 04:33:57 | Warren, Kentucky, US |
414939 | 414939 | 2020-07-05 | US | Kentucky | Washington | 21229 | 25 | 0 | 0 | 25 | 37.75599461 | -85.17407732 | 2020-07-06 04:33:57 | Washington, Kentucky, US |
414971 | 414971 | 2020-07-05 | US | Kentucky | Wayne | 21231 | 16 | 0 | 0 | 16 | 36.80310688 | -84.8251971 | 2020-07-06 04:33:57 | Wayne, Kentucky, US |
414988 | 414988 | 2020-07-05 | US | Kentucky | Webster | 21233 | 42 | 0 | 0 | 42 | 37.52168356 | -87.67989953 | 2020-07-06 04:33:57 | Webster, Kentucky, US |
415022 | 415022 | 2020-07-05 | US | Kentucky | Whitley | 21235 | 32 | 0 | 0 | 32 | 36.75700531 | -84.14541217 | 2020-07-06 04:33:57 | Whitley, Kentucky, US |
415063 | 415063 | 2020-07-05 | US | Kentucky | Wolfe | 21237 | 4 | 0 | 0 | 4 | 37.73941626 | -83.49303612 | 2020-07-06 04:33:57 | Wolfe, Kentucky, US |
415070 | 415070 | 2020-07-05 | US | Kentucky | Woodford | 21239 | 73 | 0 | 0 | 73 | 38.04178222 | -84.7417556 | 2020-07-06 04:33:57 | Woodford, Kentucky, 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]);