ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
148 rows where cases = 24 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
668437 | 668437 | 2020-10-26 | Robertson | Kentucky | 21201 | 24 | 1 |
386945 | 386945 | 2020-07-31 | Breathitt | Kentucky | 21025 | 24 | 0 |
383727 | 383727 | 2020-07-30 | Breathitt | Kentucky | 21025 | 24 | 0 |
383767 | 383767 | 2020-07-30 | Hickman | Kentucky | 21105 | 24 | 0 |
380524 | 380524 | 2020-07-29 | Clinton | Kentucky | 21053 | 24 | 0 |
377363 | 377363 | 2020-07-28 | Menifee | Kentucky | 21165 | 24 | 0 |
374148 | 374148 | 2020-07-27 | Menifee | Kentucky | 21165 | 24 | 0 |
370911 | 370911 | 2020-07-26 | Johnson | Kentucky | 21115 | 24 | 0 |
367720 | 367720 | 2020-07-25 | Martin | Kentucky | 21159 | 24 | 0 |
367728 | 367728 | 2020-07-25 | Metcalfe | Kentucky | 21169 | 24 | 2 |
364516 | 364516 | 2020-07-24 | McCreary | Kentucky | 21147 | 24 | 0 |
364521 | 364521 | 2020-07-24 | Metcalfe | Kentucky | 21169 | 24 | 2 |
361241 | 361241 | 2020-07-23 | Bracken | Kentucky | 21023 | 24 | 0 |
361309 | 361309 | 2020-07-23 | McCreary | Kentucky | 21147 | 24 | 0 |
361317 | 361317 | 2020-07-23 | Morgan | Kentucky | 21175 | 24 | 0 |
358030 | 358030 | 2020-07-22 | Bath | Kentucky | 21011 | 24 | 1 |
358036 | 358036 | 2020-07-22 | Bracken | Kentucky | 21023 | 24 | 0 |
358112 | 358112 | 2020-07-22 | Morgan | Kentucky | 21175 | 24 | 0 |
358118 | 358118 | 2020-07-22 | Owen | Kentucky | 21187 | 24 | 0 |
354833 | 354833 | 2020-07-21 | Bracken | Kentucky | 21023 | 24 | 0 |
354909 | 354909 | 2020-07-21 | Morgan | Kentucky | 21175 | 24 | 0 |
351631 | 351631 | 2020-07-20 | Bracken | Kentucky | 21023 | 24 | 0 |
348431 | 348431 | 2020-07-19 | Bracken | Kentucky | 21023 | 24 | 0 |
345230 | 345230 | 2020-07-18 | Bracken | Kentucky | 21023 | 24 | 0 |
345278 | 345278 | 2020-07-18 | Knott | Kentucky | 21119 | 24 | 0 |
345288 | 345288 | 2020-07-18 | Livingston | Kentucky | 21139 | 24 | 0 |
342062 | 342062 | 2020-07-17 | Green | Kentucky | 21087 | 24 | 1 |
342078 | 342078 | 2020-07-17 | Knott | Kentucky | 21119 | 24 | 0 |
338890 | 338890 | 2020-07-16 | Lewis | Kentucky | 21135 | 24 | 0 |
338918 | 338918 | 2020-07-16 | Pendleton | Kentucky | 21191 | 24 | 0 |
335694 | 335694 | 2020-07-15 | Lewis | Kentucky | 21135 | 24 | 0 |
335698 | 335698 | 2020-07-15 | Lyon | Kentucky | 21143 | 24 | 3 |
332495 | 332495 | 2020-07-14 | Larue | Kentucky | 21123 | 24 | 1 |
332501 | 332501 | 2020-07-14 | Lewis | Kentucky | 21135 | 24 | 0 |
319801 | 319801 | 2020-07-10 | Rowan | Kentucky | 21205 | 24 | 0 |
316626 | 316626 | 2020-07-09 | Rowan | Kentucky | 21205 | 24 | 0 |
313387 | 313387 | 2020-07-08 | Fulton | Kentucky | 21075 | 24 | 1 |
313452 | 313452 | 2020-07-08 | Rowan | Kentucky | 21205 | 24 | 0 |
310217 | 310217 | 2020-07-07 | Fulton | Kentucky | 21075 | 24 | 0 |
307049 | 307049 | 2020-07-06 | Fulton | Kentucky | 21075 | 24 | 0 |
303882 | 303882 | 2020-07-05 | Fulton | Kentucky | 21075 | 24 | 0 |
303928 | 303928 | 2020-07-05 | Mercer | Kentucky | 21167 | 24 | 0 |
300718 | 300718 | 2020-07-04 | Fulton | Kentucky | 21075 | 24 | 0 |
300764 | 300764 | 2020-07-04 | Mercer | Kentucky | 21167 | 24 | 0 |
297556 | 297556 | 2020-07-03 | Fulton | Kentucky | 21075 | 24 | 0 |
297602 | 297602 | 2020-07-03 | Mercer | Kentucky | 21167 | 24 | 0 |
294374 | 294374 | 2020-07-02 | Breckinridge | Kentucky | 21027 | 24 | 2 |
294444 | 294444 | 2020-07-02 | Mercer | Kentucky | 21167 | 24 | 0 |
294475 | 294475 | 2020-07-02 | Washington | Kentucky | 21229 | 24 | 0 |
291220 | 291220 | 2020-07-01 | Breckinridge | Kentucky | 21027 | 24 | 2 |
291246 | 291246 | 2020-07-01 | Garrard | Kentucky | 21079 | 24 | 0 |
291254 | 291254 | 2020-07-01 | Harlan | Kentucky | 21095 | 24 | 2 |
291321 | 291321 | 2020-07-01 | Washington | Kentucky | 21229 | 24 | 0 |
288070 | 288070 | 2020-06-30 | Breckinridge | Kentucky | 21027 | 24 | 2 |
284921 | 284921 | 2020-06-29 | Breckinridge | Kentucky | 21027 | 24 | 2 |
285017 | 285017 | 2020-06-29 | Trigg | Kentucky | 21221 | 24 | 0 |
281775 | 281775 | 2020-06-28 | Breckinridge | Kentucky | 21027 | 24 | 2 |
281871 | 281871 | 2020-06-28 | Trigg | Kentucky | 21221 | 24 | 0 |
278627 | 278627 | 2020-06-27 | Breckinridge | Kentucky | 21027 | 24 | 2 |
278723 | 278723 | 2020-06-27 | Trigg | Kentucky | 21221 | 24 | 0 |
275479 | 275479 | 2020-06-26 | Breckinridge | Kentucky | 21027 | 24 | 2 |
275534 | 275534 | 2020-06-26 | Lincoln | Kentucky | 21137 | 24 | 1 |
275582 | 275582 | 2020-06-26 | Whitley | Kentucky | 21235 | 24 | 0 |
272336 | 272336 | 2020-06-25 | Breckinridge | Kentucky | 21027 | 24 | 2 |
272391 | 272391 | 2020-06-25 | Lincoln | Kentucky | 21137 | 24 | 1 |
272431 | 272431 | 2020-06-25 | Todd | Kentucky | 21219 | 24 | 0 |
272439 | 272439 | 2020-06-25 | Whitley | Kentucky | 21235 | 24 | 0 |
269200 | 269200 | 2020-06-24 | Breckinridge | Kentucky | 21027 | 24 | 2 |
269295 | 269295 | 2020-06-24 | Todd | Kentucky | 21219 | 24 | 0 |
269303 | 269303 | 2020-06-24 | Whitley | Kentucky | 21235 | 24 | 0 |
266067 | 266067 | 2020-06-23 | Breckinridge | Kentucky | 21027 | 24 | 2 |
266162 | 266162 | 2020-06-23 | Todd | Kentucky | 21219 | 24 | 0 |
262940 | 262940 | 2020-06-22 | Breckinridge | Kentucky | 21027 | 24 | 2 |
263004 | 263004 | 2020-06-22 | Mason | Kentucky | 21161 | 24 | 0 |
263008 | 263008 | 2020-06-22 | Meade | Kentucky | 21163 | 24 | 2 |
259811 | 259811 | 2020-06-21 | Breckinridge | Kentucky | 21027 | 24 | 2 |
259875 | 259875 | 2020-06-21 | Mason | Kentucky | 21161 | 24 | 0 |
259879 | 259879 | 2020-06-21 | Meade | Kentucky | 21163 | 24 | 2 |
256685 | 256685 | 2020-06-20 | Breckinridge | Kentucky | 21027 | 24 | 2 |
256749 | 256749 | 2020-06-20 | Mason | Kentucky | 21161 | 24 | 0 |
256753 | 256753 | 2020-06-20 | Meade | Kentucky | 21163 | 24 | 2 |
253633 | 253633 | 2020-06-19 | Meade | Kentucky | 21163 | 24 | 2 |
253663 | 253663 | 2020-06-19 | Union | Kentucky | 21225 | 24 | 0 |
250518 | 250518 | 2020-06-18 | Meade | Kentucky | 21163 | 24 | 2 |
247406 | 247406 | 2020-06-17 | Meade | Kentucky | 21163 | 24 | 2 |
244293 | 244293 | 2020-06-16 | Meade | Kentucky | 21163 | 24 | 2 |
241182 | 241182 | 2020-06-15 | Meade | Kentucky | 21163 | 24 | 2 |
238000 | 238000 | 2020-06-14 | Bourbon | Kentucky | 21017 | 24 | 1 |
238073 | 238073 | 2020-06-14 | Meade | Kentucky | 21163 | 24 | 2 |
234893 | 234893 | 2020-06-13 | Bourbon | Kentucky | 21017 | 24 | 1 |
234966 | 234966 | 2020-06-13 | Meade | Kentucky | 21163 | 24 | 2 |
228727 | 228727 | 2020-06-11 | Henry | Kentucky | 21103 | 24 | 1 |
228756 | 228756 | 2020-06-11 | McLean | Kentucky | 21149 | 24 | 0 |
225625 | 225625 | 2020-06-10 | Henry | Kentucky | 21103 | 24 | 1 |
225654 | 225654 | 2020-06-10 | McLean | Kentucky | 21149 | 24 | 0 |
222529 | 222529 | 2020-06-09 | Henry | Kentucky | 21103 | 24 | 1 |
222558 | 222558 | 2020-06-09 | McLean | Kentucky | 21149 | 24 | 0 |
219434 | 219434 | 2020-06-08 | Henry | Kentucky | 21103 | 24 | 0 |
219463 | 219463 | 2020-06-08 | McLean | Kentucky | 21149 | 24 | 0 |
216342 | 216342 | 2020-06-07 | Henry | Kentucky | 21103 | 24 | 0 |
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);