ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
124 rows where cases = 38 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
571159 | 571159 | 2020-09-26 | Wolfe | Kentucky | 21237 | 38 | 0 |
561350 | 561350 | 2020-09-23 | Elliott | Kentucky | 21063 | 38 | 0 |
532197 | 532197 | 2020-09-14 | Bracken | Kentucky | 21023 | 38 | 0 |
496617 | 496617 | 2020-09-03 | Bracken | Kentucky | 21023 | 38 | 0 |
486977 | 486977 | 2020-08-31 | Lyon | Kentucky | 21143 | 38 | 4 |
467537 | 467537 | 2020-08-25 | Crittenden | Kentucky | 21055 | 38 | 1 |
467575 | 467575 | 2020-08-25 | Leslie | Kentucky | 21131 | 38 | 0 |
464308 | 464308 | 2020-08-24 | Crittenden | Kentucky | 21055 | 38 | 1 |
464346 | 464346 | 2020-08-24 | Leslie | Kentucky | 21131 | 38 | 0 |
461077 | 461077 | 2020-08-23 | Crittenden | Kentucky | 21055 | 38 | 1 |
461115 | 461115 | 2020-08-23 | Leslie | Kentucky | 21131 | 38 | 0 |
457850 | 457850 | 2020-08-22 | Crittenden | Kentucky | 21055 | 38 | 1 |
457888 | 457888 | 2020-08-22 | Leslie | Kentucky | 21131 | 38 | 0 |
454598 | 454598 | 2020-08-21 | Ballard | Kentucky | 21007 | 38 | 0 |
454607 | 454607 | 2020-08-21 | Breathitt | Kentucky | 21025 | 38 | 0 |
454622 | 454622 | 2020-08-21 | Crittenden | Kentucky | 21055 | 38 | 1 |
454664 | 454664 | 2020-08-21 | Livingston | Kentucky | 21139 | 38 | 1 |
454706 | 454706 | 2020-08-21 | Trimble | Kentucky | 21223 | 38 | 0 |
451370 | 451370 | 2020-08-20 | Ballard | Kentucky | 21007 | 38 | 0 |
451432 | 451432 | 2020-08-20 | Leslie | Kentucky | 21131 | 38 | 0 |
451436 | 451436 | 2020-08-20 | Livingston | Kentucky | 21139 | 38 | 1 |
451476 | 451476 | 2020-08-20 | Todd | Kentucky | 21219 | 38 | 0 |
451478 | 451478 | 2020-08-20 | Trimble | Kentucky | 21223 | 38 | 0 |
448142 | 448142 | 2020-08-19 | Ballard | Kentucky | 21007 | 38 | 0 |
448208 | 448208 | 2020-08-19 | Livingston | Kentucky | 21139 | 38 | 1 |
448248 | 448248 | 2020-08-19 | Todd | Kentucky | 21219 | 38 | 0 |
448250 | 448250 | 2020-08-19 | Trimble | Kentucky | 21223 | 38 | 0 |
444915 | 444915 | 2020-08-18 | Ballard | Kentucky | 21007 | 38 | 0 |
445021 | 445021 | 2020-08-18 | Todd | Kentucky | 21219 | 38 | 0 |
441749 | 441749 | 2020-08-17 | Lawrence | Kentucky | 21127 | 38 | 0 |
441751 | 441751 | 2020-08-17 | Leslie | Kentucky | 21131 | 38 | 0 |
441795 | 441795 | 2020-08-17 | Todd | Kentucky | 21219 | 38 | 0 |
438522 | 438522 | 2020-08-16 | Lawrence | Kentucky | 21127 | 38 | 0 |
435297 | 435297 | 2020-08-15 | Lawrence | Kentucky | 21127 | 38 | 0 |
428857 | 428857 | 2020-08-13 | Martin | Kentucky | 21159 | 38 | 0 |
409520 | 409520 | 2020-08-07 | Lewis | Kentucky | 21135 | 38 | 0 |
399877 | 399877 | 2020-08-04 | McCreary | Kentucky | 21147 | 38 | 0 |
396626 | 396626 | 2020-08-03 | Green | Kentucky | 21087 | 38 | 2 |
386992 | 386992 | 2020-07-31 | Knott | Kentucky | 21119 | 38 | 1 |
380581 | 380581 | 2020-07-29 | Mercer | Kentucky | 21167 | 38 | 0 |
380582 | 380582 | 2020-07-29 | Metcalfe | Kentucky | 21169 | 38 | 2 |
377364 | 377364 | 2020-07-28 | Mercer | Kentucky | 21167 | 38 | 0 |
377379 | 377379 | 2020-07-28 | Powell | Kentucky | 21197 | 38 | 0 |
374146 | 374146 | 2020-07-27 | McLean | Kentucky | 21149 | 38 | 0 |
374164 | 374164 | 2020-07-27 | Powell | Kentucky | 21197 | 38 | 0 |
358038 | 358038 | 2020-07-22 | Breckinridge | Kentucky | 21027 | 38 | 2 |
358070 | 358070 | 2020-07-22 | Hancock | Kentucky | 21091 | 38 | 0 |
358135 | 358135 | 2020-07-22 | Trigg | Kentucky | 21221 | 38 | 0 |
354835 | 354835 | 2020-07-21 | Breckinridge | Kentucky | 21027 | 38 | 2 |
354932 | 354932 | 2020-07-21 | Trigg | Kentucky | 21221 | 38 | 0 |
351633 | 351633 | 2020-07-20 | Breckinridge | Kentucky | 21027 | 38 | 2 |
351681 | 351681 | 2020-07-20 | Larue | Kentucky | 21123 | 38 | 1 |
345253 | 345253 | 2020-07-18 | Fleming | Kentucky | 21069 | 38 | 0 |
342035 | 342035 | 2020-07-17 | Caldwell | Kentucky | 21033 | 38 | 0 |
342120 | 342120 | 2020-07-17 | Rockcastle | Kentucky | 21203 | 38 | 0 |
342121 | 342121 | 2020-07-17 | Rowan | Kentucky | 21205 | 38 | 0 |
342133 | 342133 | 2020-07-17 | Washington | Kentucky | 21229 | 38 | 0 |
338839 | 338839 | 2020-07-16 | Caldwell | Kentucky | 21033 | 38 | 0 |
338937 | 338937 | 2020-07-16 | Washington | Kentucky | 21229 | 38 | 0 |
335742 | 335742 | 2020-07-15 | Wayne | Kentucky | 21231 | 38 | 0 |
329268 | 329268 | 2020-07-13 | Carter | Kentucky | 21043 | 38 | 0 |
326082 | 326082 | 2020-07-12 | Carter | Kentucky | 21043 | 38 | 0 |
316532 | 316532 | 2020-07-09 | Bourbon | Kentucky | 21017 | 38 | 1 |
316559 | 316559 | 2020-07-09 | Floyd | Kentucky | 21071 | 38 | 0 |
313385 | 313385 | 2020-07-08 | Floyd | Kentucky | 21071 | 38 | 0 |
307034 | 307034 | 2020-07-06 | Casey | Kentucky | 21045 | 38 | 0 |
307063 | 307063 | 2020-07-06 | Henry | Kentucky | 21103 | 38 | 2 |
303952 | 303952 | 2020-07-05 | Spencer | Kentucky | 21215 | 38 | 0 |
300788 | 300788 | 2020-07-04 | Spencer | Kentucky | 21215 | 38 | 0 |
297626 | 297626 | 2020-07-03 | Spencer | Kentucky | 21215 | 38 | 0 |
294446 | 294446 | 2020-07-02 | Monroe | Kentucky | 21171 | 38 | 1 |
288067 | 288067 | 2020-06-30 | Boyle | Kentucky | 21021 | 38 | 0 |
284918 | 284918 | 2020-06-29 | Boyle | Kentucky | 21021 | 38 | 0 |
281772 | 281772 | 2020-06-28 | Boyle | Kentucky | 21021 | 38 | 0 |
278624 | 278624 | 2020-06-27 | Boyle | Kentucky | 21021 | 38 | 0 |
275476 | 275476 | 2020-06-26 | Boyle | Kentucky | 21021 | 38 | 0 |
275573 | 275573 | 2020-06-26 | Taylor | Kentucky | 21217 | 38 | 1 |
272333 | 272333 | 2020-06-25 | Boyle | Kentucky | 21021 | 38 | 0 |
272430 | 272430 | 2020-06-25 | Taylor | Kentucky | 21217 | 38 | 1 |
256774 | 256774 | 2020-06-20 | Russell | Kentucky | 21207 | 38 | 4 |
256787 | 256787 | 2020-06-20 | Webster | Kentucky | 21233 | 38 | 0 |
253648 | 253648 | 2020-06-19 | Perry | Kentucky | 21193 | 38 | 1 |
253654 | 253654 | 2020-06-19 | Russell | Kentucky | 21207 | 38 | 4 |
250539 | 250539 | 2020-06-18 | Russell | Kentucky | 21207 | 38 | 4 |
247427 | 247427 | 2020-06-17 | Russell | Kentucky | 21207 | 38 | 4 |
244314 | 244314 | 2020-06-16 | Russell | Kentucky | 21207 | 38 | 4 |
241203 | 241203 | 2020-06-15 | Russell | Kentucky | 21207 | 38 | 4 |
238094 | 238094 | 2020-06-14 | Russell | Kentucky | 21207 | 38 | 4 |
234987 | 234987 | 2020-06-13 | Russell | Kentucky | 21207 | 38 | 4 |
231877 | 231877 | 2020-06-12 | Pike | Kentucky | 21195 | 38 | 2 |
228773 | 228773 | 2020-06-11 | Pike | Kentucky | 21195 | 38 | 2 |
225648 | 225648 | 2020-06-10 | Marion | Kentucky | 21155 | 38 | 0 |
225671 | 225671 | 2020-06-10 | Pike | Kentucky | 21195 | 38 | 2 |
222575 | 222575 | 2020-06-09 | Pike | Kentucky | 21195 | 38 | 2 |
200955 | 200955 | 2020-06-02 | Marshall | Kentucky | 21157 | 38 | 2 |
197844 | 197844 | 2020-06-01 | Franklin | Kentucky | 21073 | 38 | 0 |
197883 | 197883 | 2020-06-01 | Marshall | Kentucky | 21157 | 38 | 2 |
194773 | 194773 | 2020-05-31 | Franklin | Kentucky | 21073 | 38 | 0 |
194812 | 194812 | 2020-05-31 | Marshall | Kentucky | 21157 | 38 | 2 |
191705 | 191705 | 2020-05-30 | Franklin | Kentucky | 21073 | 38 | 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);