johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
121 rows where "last_update" is on date 2020-07-07 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2683914 | 2683914 | 2020-07-06 | US | Kentucky | Robertson | 21201 | 1 | 0 | 0 | 1 | 38.51923469 | -84.05055616 | 2020-07-07 04:34:00 | Robertson, Kentucky, US |
2683923 | 2683923 | 2020-07-06 | US | Kentucky | Rockcastle | 21203 | 27 | 0 | 0 | 27 | 37.36642393 | -84.31176452 | 2020-07-07 04:34:00 | Rockcastle, Kentucky, US |
2683940 | 2683940 | 2020-07-06 | US | Kentucky | Rowan | 21205 | 23 | 0 | 0 | 23 | 38.19484205 | -83.42088935 | 2020-07-07 04:34:00 | Rowan, Kentucky, US |
2683949 | 2683949 | 2020-07-06 | US | Kentucky | Russell | 21207 | 53 | 4 | 0 | 49 | 36.99308373 | -85.06070117 | 2020-07-07 04:34:00 | Russell, Kentucky, US |
2684023 | 2684023 | 2020-07-06 | US | Kentucky | Scott | 21209 | 101 | 0 | 0 | 101 | 38.29622293 | -84.5816631 | 2020-07-07 04:34:00 | Scott, Kentucky, US |
2684058 | 2684058 | 2020-07-06 | US | Kentucky | Shelby | 21211 | 524 | 17 | 0 | 507 | 38.21476019 | -85.194223 | 2020-07-07 04:34:00 | Shelby, Kentucky, US |
2684080 | 2684080 | 2020-07-06 | US | Kentucky | Simpson | 21213 | 79 | 3 | 0 | 76 | 36.74058474 | -86.58047435 | 2020-07-07 04:34:00 | Simpson, Kentucky, US |
2684112 | 2684112 | 2020-07-06 | US | Kentucky | Spencer | 21215 | 40 | 0 | 0 | 40 | 38.03223971 | -85.32749335 | 2020-07-07 04:34:00 | Spencer, Kentucky, US |
2684233 | 2684233 | 2020-07-06 | US | Kentucky | Taylor | 21217 | 45 | 1 | 0 | 44 | 37.3677562 | -85.3329931 | 2020-07-07 04:34:00 | Taylor, Kentucky, US |
2684270 | 2684270 | 2020-07-06 | US | Kentucky | Todd | 21219 | 26 | 0 | 0 | 26 | 36.8381152 | -87.17878374 | 2020-07-07 04:34:00 | Todd, Kentucky, US |
2684290 | 2684290 | 2020-07-06 | US | Kentucky | Trigg | 21221 | 26 | 0 | 0 | 26 | 36.80767017 | -87.87333656 | 2020-07-07 04:34:00 | Trigg, Kentucky, US |
2684291 | 2684291 | 2020-07-06 | US | Kentucky | Trimble | 21223 | 6 | 0 | 0 | 6 | 38.61056487 | -85.33775972 | 2020-07-07 04:34:00 | Trimble, Kentucky, US |
2684332 | 2684332 | 2020-07-06 | US | Kentucky | Unassigned | 90021 | 1 | 0 | 0 | 1 | 38.97065142 | 0.0 | 2020-07-07 04:34:00 | Unassigned, Kentucky, US |
2684373 | 2684373 | 2020-07-06 | US | Kentucky | Union | 21225 | 29 | 0 | 0 | 29 | 37.66166713 | -87.94300009 | 2020-07-07 04:34:00 | Union, Kentucky, US |
2684449 | 2684449 | 2020-07-06 | US | Kentucky | Warren | 21227 | 1632 | 14 | 0 | 1618 | 36.99903045 | -86.42672751 | 2020-07-07 04:34:00 | Warren, Kentucky, US |
2684475 | 2684475 | 2020-07-06 | US | Kentucky | Washington | 21229 | 27 | 0 | 0 | 27 | 37.75599461 | -85.17407732 | 2020-07-07 04:34:00 | Washington, Kentucky, US |
2684507 | 2684507 | 2020-07-06 | US | Kentucky | Wayne | 21231 | 20 | 0 | 0 | 20 | 36.80310688 | -84.8251971 | 2020-07-07 04:34:00 | Wayne, Kentucky, US |
2684524 | 2684524 | 2020-07-06 | US | Kentucky | Webster | 21233 | 45 | 0 | 0 | 45 | 37.52168356 | -87.67989953 | 2020-07-07 04:34:00 | Webster, Kentucky, US |
2684557 | 2684557 | 2020-07-06 | US | Kentucky | Whitley | 21235 | 40 | 0 | 0 | 40 | 36.75700531 | -84.14541217 | 2020-07-07 04:34:00 | Whitley, Kentucky, US |
2684598 | 2684598 | 2020-07-06 | US | Kentucky | Wolfe | 21237 | 4 | 0 | 0 | 4 | 37.73941626 | -83.49303612 | 2020-07-07 04:34:00 | Wolfe, Kentucky, US |
2684605 | 2684605 | 2020-07-06 | US | Kentucky | Woodford | 21239 | 74 | 0 | 0 | 74 | 38.04178222 | -84.7417556 | 2020-07-07 04:34:00 | 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]);