ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
20 rows where deaths = 34, fips = 21121 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1268863 | 1268863 | 2021-04-29 | Knox | Kentucky | 21121 | 3345 | 34 |
1265616 | 1265616 | 2021-04-28 | Knox | Kentucky | 21121 | 3336 | 34 |
1262369 | 1262369 | 2021-04-27 | Knox | Kentucky | 21121 | 3337 | 34 |
1259122 | 1259122 | 2021-04-26 | Knox | Kentucky | 21121 | 3344 | 34 |
1255875 | 1255875 | 2021-04-25 | Knox | Kentucky | 21121 | 3339 | 34 |
1252628 | 1252628 | 2021-04-24 | Knox | Kentucky | 21121 | 3337 | 34 |
1249381 | 1249381 | 2021-04-23 | Knox | Kentucky | 21121 | 3341 | 34 |
1246134 | 1246134 | 2021-04-22 | Knox | Kentucky | 21121 | 3332 | 34 |
1242887 | 1242887 | 2021-04-21 | Knox | Kentucky | 21121 | 3326 | 34 |
1239640 | 1239640 | 2021-04-20 | Knox | Kentucky | 21121 | 3327 | 34 |
1236393 | 1236393 | 2021-04-19 | Knox | Kentucky | 21121 | 3329 | 34 |
1233146 | 1233146 | 2021-04-18 | Knox | Kentucky | 21121 | 3327 | 34 |
1229898 | 1229898 | 2021-04-17 | Knox | Kentucky | 21121 | 3326 | 34 |
1226650 | 1226650 | 2021-04-16 | Knox | Kentucky | 21121 | 3339 | 34 |
1223403 | 1223403 | 2021-04-15 | Knox | Kentucky | 21121 | 3335 | 34 |
1220155 | 1220155 | 2021-04-14 | Knox | Kentucky | 21121 | 3322 | 34 |
1216907 | 1216907 | 2021-04-13 | Knox | Kentucky | 21121 | 3335 | 34 |
1213660 | 1213660 | 2021-04-12 | Knox | Kentucky | 21121 | 3329 | 34 |
1210412 | 1210412 | 2021-04-11 | Knox | Kentucky | 21121 | 3321 | 34 |
1207163 | 1207163 | 2021-04-10 | Knox | Kentucky | 21121 | 3320 | 34 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);