johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
121 rows where "day" is on date 2020-07-03 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2233602 | 2233602 | 2020-07-03 | US | Kentucky | Robertson | 21201 | 1 | 0 | 0 | 1 | 38.51923469 | -84.05055616 | 2020-07-04 04:33:51 | Robertson, Kentucky, US |
2233611 | 2233611 | 2020-07-03 | US | Kentucky | Rockcastle | 21203 | 21 | 0 | 0 | 21 | 37.36642393 | -84.31176452 | 2020-07-04 04:33:51 | Rockcastle, Kentucky, US |
2233628 | 2233628 | 2020-07-03 | US | Kentucky | Rowan | 21205 | 23 | 0 | 0 | 23 | 38.19484205 | -83.42088935 | 2020-07-04 04:33:51 | Rowan, Kentucky, US |
2233637 | 2233637 | 2020-07-03 | US | Kentucky | Russell | 21207 | 47 | 4 | 0 | 43 | 36.99308373 | -85.06070117 | 2020-07-04 04:33:51 | Russell, Kentucky, US |
2233711 | 2233711 | 2020-07-03 | US | Kentucky | Scott | 21209 | 99 | 0 | 0 | 99 | 38.29622293 | -84.5816631 | 2020-07-04 04:33:51 | Scott, Kentucky, US |
2233746 | 2233746 | 2020-07-03 | US | Kentucky | Shelby | 21211 | 433 | 16 | 0 | 417 | 38.21476019 | -85.194223 | 2020-07-04 04:33:51 | Shelby, Kentucky, US |
2233768 | 2233768 | 2020-07-03 | US | Kentucky | Simpson | 21213 | 80 | 3 | 0 | 77 | 36.74058474 | -86.58047435 | 2020-07-04 04:33:51 | Simpson, Kentucky, US |
2233800 | 2233800 | 2020-07-03 | US | Kentucky | Spencer | 21215 | 38 | 0 | 0 | 38 | 38.03223971 | -85.32749335 | 2020-07-04 04:33:51 | Spencer, Kentucky, US |
2233920 | 2233920 | 2020-07-03 | US | Kentucky | Taylor | 21217 | 43 | 1 | 0 | 42 | 37.3677562 | -85.3329931 | 2020-07-04 04:33:51 | Taylor, Kentucky, US |
2233957 | 2233957 | 2020-07-03 | US | Kentucky | Todd | 21219 | 26 | 0 | 0 | 26 | 36.8381152 | -87.17878374 | 2020-07-04 04:33:51 | Todd, Kentucky, US |
2233977 | 2233977 | 2020-07-03 | US | Kentucky | Trigg | 21221 | 26 | 0 | 0 | 26 | 36.80767017 | -87.87333656 | 2020-07-04 04:33:51 | Trigg, Kentucky, US |
2233978 | 2233978 | 2020-07-03 | US | Kentucky | Trimble | 21223 | 6 | 0 | 0 | 6 | 38.61056487 | -85.33775972 | 2020-07-04 04:33:51 | Trimble, Kentucky, US |
2234019 | 2234019 | 2020-07-03 | US | Kentucky | Unassigned | 90021 | 4 | 0 | 0 | 4 | 38.97065142 | 0.0 | 2020-07-04 04:33:51 | Unassigned, Kentucky, US |
2234060 | 2234060 | 2020-07-03 | US | Kentucky | Union | 21225 | 29 | 0 | 0 | 29 | 37.66166713 | -87.94300009 | 2020-07-04 04:33:51 | Union, Kentucky, US |
2234136 | 2234136 | 2020-07-03 | US | Kentucky | Warren | 21227 | 1583 | 14 | 0 | 1569 | 36.99903045 | -86.42672751 | 2020-07-04 04:33:51 | Warren, Kentucky, US |
2234162 | 2234162 | 2020-07-03 | US | Kentucky | Washington | 21229 | 25 | 0 | 0 | 25 | 37.75599461 | -85.17407732 | 2020-07-04 04:33:51 | Washington, Kentucky, US |
2234194 | 2234194 | 2020-07-03 | US | Kentucky | Wayne | 21231 | 16 | 0 | 0 | 16 | 36.80310688 | -84.8251971 | 2020-07-04 04:33:51 | Wayne, Kentucky, US |
2234211 | 2234211 | 2020-07-03 | US | Kentucky | Webster | 21233 | 42 | 0 | 0 | 42 | 37.52168356 | -87.67989953 | 2020-07-04 04:33:51 | Webster, Kentucky, US |
2234245 | 2234245 | 2020-07-03 | US | Kentucky | Whitley | 21235 | 32 | 0 | 0 | 32 | 36.75700531 | -84.14541217 | 2020-07-04 04:33:51 | Whitley, Kentucky, US |
2234286 | 2234286 | 2020-07-03 | US | Kentucky | Wolfe | 21237 | 4 | 0 | 0 | 4 | 37.73941626 | -83.49303612 | 2020-07-04 04:33:51 | Wolfe, Kentucky, US |
2234293 | 2234293 | 2020-07-03 | US | Kentucky | Woodford | 21239 | 73 | 0 | 0 | 73 | 38.04178222 | -84.7417556 | 2020-07-04 04:33:51 | 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]);