ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where cases = 1308 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2370340 | 2370340 | 2022-04-03 | Ballard | Kentucky | 21007 | 1308 | 28 |
2367087 | 2367087 | 2022-04-02 | Ballard | Kentucky | 21007 | 1308 | 28 |
2363834 | 2363834 | 2022-04-01 | Ballard | Kentucky | 21007 | 1308 | 28 |
2360580 | 2360580 | 2022-03-31 | Ballard | Kentucky | 21007 | 1308 | 28 |
2357326 | 2357326 | 2022-03-30 | Ballard | Kentucky | 21007 | 1308 | 28 |
2354073 | 2354073 | 2022-03-29 | Ballard | Kentucky | 21007 | 1308 | 28 |
2350821 | 2350821 | 2022-03-28 | Ballard | Kentucky | 21007 | 1308 | 28 |
1791717 | 1791717 | 2021-10-07 | Owen | Kentucky | 21187 | 1308 | 22 |
1746217 | 1746217 | 2021-09-23 | McLean | Kentucky | 21149 | 1308 | 33 |
1580502 | 1580502 | 2021-08-03 | Green | Kentucky | 21087 | 1308 | 18 |
1577253 | 1577253 | 2021-08-02 | Green | Kentucky | 21087 | 1308 | 18 |
1561034 | 1561034 | 2021-07-28 | Lee | Kentucky | 21129 | 1308 | 26 |
1557787 | 1557787 | 2021-07-27 | Lee | Kentucky | 21129 | 1308 | 26 |
1554540 | 1554540 | 2021-07-26 | Lee | Kentucky | 21129 | 1308 | 26 |
1551293 | 1551293 | 2021-07-25 | Lee | Kentucky | 21129 | 1308 | 26 |
1548046 | 1548046 | 2021-07-24 | Lee | Kentucky | 21129 | 1308 | 26 |
1544799 | 1544799 | 2021-07-23 | Lee | Kentucky | 21129 | 1308 | 26 |
1337092 | 1337092 | 2021-05-20 | Trigg | Kentucky | 21221 | 1308 | 14 |
1333845 | 1333845 | 2021-05-19 | Trigg | Kentucky | 21221 | 1308 | 14 |
1294830 | 1294830 | 2021-05-07 | Jackson | Kentucky | 21109 | 1308 | 32 |
1197409 | 1197409 | 2021-04-07 | Henry | Kentucky | 21103 | 1308 | 11 |
1194222 | 1194222 | 2021-04-06 | Union | Kentucky | 21225 | 1308 | 15 |
1190972 | 1190972 | 2021-04-05 | Union | Kentucky | 21225 | 1308 | 15 |
1145420 | 1145420 | 2021-03-22 | Casey | Kentucky | 21045 | 1308 | 34 |
1142173 | 1142173 | 2021-03-21 | Casey | Kentucky | 21045 | 1308 | 34 |
1138927 | 1138927 | 2021-03-20 | Casey | Kentucky | 21045 | 1308 | 34 |
1135681 | 1135681 | 2021-03-19 | Casey | Kentucky | 21045 | 1308 | 34 |
1054621 | 1054621 | 2021-02-22 | Washington | Kentucky | 21229 | 1308 | 29 |
1005900 | 1005900 | 2021-02-07 | Mason | Kentucky | 21161 | 1308 | 26 |
979960 | 979960 | 2021-01-30 | Spencer | Kentucky | 21215 | 1308 | 5 |
928032 | 928032 | 2021-01-14 | Russell | Kentucky | 21207 | 1308 | 36 |
908459 | 908459 | 2021-01-08 | Allen | Kentucky | 21003 | 1308 | 19 |
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);