ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where cases = 566 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175297 | 2175297 | 2022-02-02 | Robertson | Kentucky | 21201 | 566 | 20 |
1876153 | 1876153 | 2021-11-02 | Hickman | Kentucky | 21105 | 566 | 19 |
1869655 | 1869655 | 2021-10-31 | Hickman | Kentucky | 21105 | 566 | 19 |
1866406 | 1866406 | 2021-10-30 | Hickman | Kentucky | 21105 | 566 | 19 |
1863157 | 1863157 | 2021-10-29 | Hickman | Kentucky | 21105 | 566 | 19 |
1697426 | 1697426 | 2021-09-08 | Carlisle | Kentucky | 21039 | 566 | 10 |
1694178 | 1694178 | 2021-09-07 | Carlisle | Kentucky | 21039 | 566 | 10 |
1587077 | 1587077 | 2021-08-05 | Wolfe | Kentucky | 21237 | 566 | 7 |
1018916 | 1018916 | 2021-02-11 | Trimble | Kentucky | 21223 | 566 | 3 |
973400 | 973400 | 2021-01-28 | Gallatin | Kentucky | 21077 | 566 | 16 |
911748 | 911748 | 2021-01-09 | Hancock | Kentucky | 21091 | 566 | 13 |
846811 | 846811 | 2020-12-20 | Breckinridge | Kentucky | 21027 | 566 | 4 |
798139 | 798139 | 2020-12-05 | Clinton | Kentucky | 21053 | 566 | 15 |
785250 | 785250 | 2020-12-01 | Webster | Kentucky | 21233 | 566 | 7 |
772192 | 772192 | 2020-11-27 | Garrard | Kentucky | 21079 | 566 | 4 |
746270 | 746270 | 2020-11-19 | Mercer | Kentucky | 21167 | 566 | 6 |
713752 | 713752 | 2020-11-09 | Boyle | Kentucky | 21021 | 566 | 0 |
697599 | 697599 | 2020-11-04 | Marion | Kentucky | 21155 | 566 | 11 |
691082 | 691082 | 2020-11-02 | Grayson | Kentucky | 21085 | 566 | 16 |
687796 | 687796 | 2020-11-01 | Allen | Kentucky | 21003 | 566 | 12 |
648916 | 648916 | 2020-10-20 | Harlan | Kentucky | 21095 | 566 | 13 |
532222 | 532222 | 2020-09-14 | Franklin | Kentucky | 21073 | 566 | 11 |
528985 | 528985 | 2020-09-13 | Franklin | Kentucky | 21073 | 566 | 11 |
480541 | 480541 | 2020-08-29 | Scott | Kentucky | 21209 | 566 | 5 |
329335 | 329335 | 2020-07-13 | Muhlenberg | Kentucky | 21177 | 566 | 8 |
188663 | 188663 | 2020-05-29 | Kenton | Kentucky | 21117 | 566 | 33 |
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);