ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where cases = 473 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1622696 | 1622696 | 2021-08-16 | Ballard | Kentucky | 21007 | 473 | 10 |
1307781 | 1307781 | 2021-05-11 | Carlisle | Kentucky | 21039 | 473 | 9 |
1304535 | 1304535 | 2021-05-10 | Carlisle | Kentucky | 21039 | 473 | 9 |
1301288 | 1301288 | 2021-05-09 | Carlisle | Kentucky | 21039 | 473 | 9 |
1298041 | 1298041 | 2021-05-08 | Carlisle | Kentucky | 21039 | 473 | 9 |
1288366 | 1288366 | 2021-05-05 | Menifee | Kentucky | 21165 | 473 | 16 |
1158480 | 1158480 | 2021-03-26 | Owsley | Kentucky | 21189 | 473 | 12 |
1106530 | 1106530 | 2021-03-10 | Nicholas | Kentucky | 21181 | 473 | 6 |
1051331 | 1051331 | 2021-02-21 | Lyon | Kentucky | 21143 | 473 | 13 |
746195 | 746195 | 2020-11-19 | Bourbon | Kentucky | 21017 | 473 | 1 |
739733 | 739733 | 2020-11-17 | Grant | Kentucky | 21081 | 473 | 6 |
733246 | 733246 | 2020-11-15 | Green | Kentucky | 21087 | 473 | 10 |
713827 | 713827 | 2020-11-09 | Monroe | Kentucky | 21171 | 473 | 5 |
710601 | 710601 | 2020-11-08 | Russell | Kentucky | 21207 | 473 | 7 |
577617 | 577617 | 2020-09-28 | Ohio | Kentucky | 21183 | 473 | 9 |
548457 | 548457 | 2020-09-19 | Nelson | Kentucky | 21179 | 473 | 4 |
461103 | 461103 | 2020-08-23 | Hopkins | Kentucky | 21107 | 473 | 37 |
457876 | 457876 | 2020-08-22 | Hopkins | Kentucky | 21107 | 473 | 37 |
377327 | 377327 | 2020-07-28 | Hardin | Kentucky | 21093 | 473 | 8 |
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);