johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
121 rows where "day" is on date 2020-03-23 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2146307 | 2146307 | 2020-03-23 | US | Kentucky | Robertson | 21201 | 0 | 0 | 0 | 0 | 38.51923469 | -84.05055616 | 2020-03-23 23:19:34 | Robertson, Kentucky, US |
2146316 | 2146316 | 2020-03-23 | US | Kentucky | Rockcastle | 21203 | 0 | 0 | 0 | 0 | 37.36642393 | -84.31176452 | 2020-03-23 23:19:34 | Rockcastle, Kentucky, US |
2146334 | 2146334 | 2020-03-23 | US | Kentucky | Rowan | 21205 | 0 | 0 | 0 | 0 | 38.19484205 | -83.42088935 | 2020-03-23 23:19:34 | Rowan, Kentucky, US |
2146343 | 2146343 | 2020-03-23 | US | Kentucky | Russell | 21207 | 0 | 0 | 0 | 0 | 36.99308373 | -85.06070117 | 2020-03-23 23:19:34 | Russell, Kentucky, US |
2146419 | 2146419 | 2020-03-23 | US | Kentucky | Scott | 21209 | 0 | 0 | 0 | 0 | 38.29622293 | -84.5816631 | 2020-03-23 23:19:34 | Scott, Kentucky, US |
2146456 | 2146456 | 2020-03-23 | US | Kentucky | Shelby | 21211 | 0 | 0 | 0 | 0 | 38.21476019 | -85.194223 | 2020-03-23 23:19:34 | Shelby, Kentucky, US |
2146478 | 2146478 | 2020-03-23 | US | Kentucky | Simpson | 21213 | 0 | 0 | 0 | 0 | 36.74058474 | -86.58047435 | 2020-03-23 23:19:34 | Simpson, Kentucky, US |
2146509 | 2146509 | 2020-03-23 | US | Kentucky | Spencer | 21215 | 1 | 0 | 0 | 1 | 38.03223971 | -85.32749335 | 2020-03-23 23:19:34 | Spencer, Kentucky, US |
2146632 | 2146632 | 2020-03-23 | US | Kentucky | Taylor | 21217 | 0 | 0 | 0 | 0 | 37.3677562 | -85.3329931 | 2020-03-23 23:19:34 | Taylor, Kentucky, US |
2146669 | 2146669 | 2020-03-23 | US | Kentucky | Todd | 21219 | 0 | 0 | 0 | 0 | 36.8381152 | -87.17878374 | 2020-03-23 23:19:34 | Todd, Kentucky, US |
2146689 | 2146689 | 2020-03-23 | US | Kentucky | Trigg | 21221 | 0 | 0 | 0 | 0 | 36.80767017 | -87.87333656 | 2020-03-23 23:19:34 | Trigg, Kentucky, US |
2146690 | 2146690 | 2020-03-23 | US | Kentucky | Trimble | 21223 | 0 | 0 | 0 | 0 | 38.61056487 | -85.33775972 | 2020-03-23 23:19:34 | Trimble, Kentucky, US |
2146722 | 2146722 | 2020-03-23 | US | Kentucky | Unassigned | 15 | 0 | 0 | 15 | 0.0 | 0.0 | 2020-03-23 23:19:34 | Unassigned, Kentucky, US | |
2146744 | 2146744 | 2020-03-23 | US | Kentucky | Union | 21225 | 0 | 0 | 0 | 0 | 37.66166713 | -87.94300009 | 2020-03-23 23:19:34 | Union, Kentucky, US |
2146821 | 2146821 | 2020-03-23 | US | Kentucky | Warren | 21227 | 4 | 0 | 0 | 4 | 36.99903045 | -86.42672751 | 2020-03-23 23:19:34 | Warren, Kentucky, US |
2146847 | 2146847 | 2020-03-23 | US | Kentucky | Washington | 21229 | 0 | 0 | 0 | 0 | 37.75599461 | -85.17407732 | 2020-03-23 23:19:34 | Washington, Kentucky, US |
2146880 | 2146880 | 2020-03-23 | US | Kentucky | Wayne | 21231 | 0 | 0 | 0 | 0 | 36.80310688 | -84.8251971 | 2020-03-23 23:19:34 | Wayne, Kentucky, US |
2146898 | 2146898 | 2020-03-23 | US | Kentucky | Webster | 21233 | 0 | 0 | 0 | 0 | 37.52168356 | -87.67989953 | 2020-03-23 23:19:34 | Webster, Kentucky, US |
2146932 | 2146932 | 2020-03-23 | US | Kentucky | Whitley | 21235 | 0 | 0 | 0 | 0 | 36.75700531 | -84.14541217 | 2020-03-23 23:19:34 | Whitley, Kentucky, US |
2146975 | 2146975 | 2020-03-23 | US | Kentucky | Wolfe | 21237 | 0 | 0 | 0 | 0 | 37.73941626 | -83.49303612 | 2020-03-23 23:19:34 | Wolfe, Kentucky, US |
2146982 | 2146982 | 2020-03-23 | US | Kentucky | Woodford | 21239 | 0 | 0 | 0 | 0 | 38.04178222 | -84.7417556 | 2020-03-23 23:19:34 | 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]);