ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 21179 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535510 | 535510 | 2020-09-15 | Nelson | Kentucky | 21179 | 454 | 4 |
532275 | 532275 | 2020-09-14 | Nelson | Kentucky | 21179 | 449 | 4 |
529038 | 529038 | 2020-09-13 | Nelson | Kentucky | 21179 | 440 | 4 |
525802 | 525802 | 2020-09-12 | Nelson | Kentucky | 21179 | 440 | 4 |
522566 | 522566 | 2020-09-11 | Nelson | Kentucky | 21179 | 440 | 4 |
519329 | 519329 | 2020-09-10 | Nelson | Kentucky | 21179 | 435 | 4 |
516094 | 516094 | 2020-09-09 | Nelson | Kentucky | 21179 | 422 | 3 |
512861 | 512861 | 2020-09-08 | Nelson | Kentucky | 21179 | 418 | 3 |
509629 | 509629 | 2020-09-07 | Nelson | Kentucky | 21179 | 403 | 3 |
506396 | 506396 | 2020-09-06 | Nelson | Kentucky | 21179 | 403 | 3 |
503162 | 503162 | 2020-09-05 | Nelson | Kentucky | 21179 | 403 | 3 |
499929 | 499929 | 2020-09-04 | Nelson | Kentucky | 21179 | 403 | 3 |
496695 | 496695 | 2020-09-03 | Nelson | Kentucky | 21179 | 394 | 3 |
493462 | 493462 | 2020-09-02 | Nelson | Kentucky | 21179 | 390 | 2 |
490228 | 490228 | 2020-09-01 | Nelson | Kentucky | 21179 | 385 | 2 |
486995 | 486995 | 2020-08-31 | Nelson | Kentucky | 21179 | 338 | 2 |
483760 | 483760 | 2020-08-30 | Nelson | Kentucky | 21179 | 331 | 2 |
480526 | 480526 | 2020-08-29 | Nelson | Kentucky | 21179 | 331 | 2 |
477293 | 477293 | 2020-08-28 | Nelson | Kentucky | 21179 | 330 | 2 |
474060 | 474060 | 2020-08-27 | Nelson | Kentucky | 21179 | 326 | 2 |
470828 | 470828 | 2020-08-26 | Nelson | Kentucky | 21179 | 324 | 2 |
467599 | 467599 | 2020-08-25 | Nelson | Kentucky | 21179 | 323 | 2 |
464370 | 464370 | 2020-08-24 | Nelson | Kentucky | 21179 | 316 | 2 |
461139 | 461139 | 2020-08-23 | Nelson | Kentucky | 21179 | 312 | 2 |
457912 | 457912 | 2020-08-22 | Nelson | Kentucky | 21179 | 312 | 2 |
454684 | 454684 | 2020-08-21 | Nelson | Kentucky | 21179 | 307 | 2 |
451456 | 451456 | 2020-08-20 | Nelson | Kentucky | 21179 | 299 | 2 |
448228 | 448228 | 2020-08-19 | Nelson | Kentucky | 21179 | 291 | 2 |
445001 | 445001 | 2020-08-18 | Nelson | Kentucky | 21179 | 289 | 2 |
441775 | 441775 | 2020-08-17 | Nelson | Kentucky | 21179 | 280 | 2 |
438548 | 438548 | 2020-08-16 | Nelson | Kentucky | 21179 | 264 | 2 |
435323 | 435323 | 2020-08-15 | Nelson | Kentucky | 21179 | 264 | 2 |
432098 | 432098 | 2020-08-14 | Nelson | Kentucky | 21179 | 264 | 2 |
428870 | 428870 | 2020-08-13 | Nelson | Kentucky | 21179 | 255 | 2 |
425646 | 425646 | 2020-08-12 | Nelson | Kentucky | 21179 | 252 | 2 |
422425 | 422425 | 2020-08-11 | Nelson | Kentucky | 21179 | 247 | 2 |
419203 | 419203 | 2020-08-10 | Nelson | Kentucky | 21179 | 229 | 2 |
415982 | 415982 | 2020-08-09 | Nelson | Kentucky | 21179 | 223 | 2 |
412762 | 412762 | 2020-08-08 | Nelson | Kentucky | 21179 | 223 | 2 |
409542 | 409542 | 2020-08-07 | Nelson | Kentucky | 21179 | 223 | 2 |
406322 | 406322 | 2020-08-06 | Nelson | Kentucky | 21179 | 213 | 2 |
403104 | 403104 | 2020-08-05 | Nelson | Kentucky | 21179 | 205 | 2 |
399887 | 399887 | 2020-08-04 | Nelson | Kentucky | 21179 | 197 | 2 |
396672 | 396672 | 2020-08-03 | Nelson | Kentucky | 21179 | 191 | 2 |
393456 | 393456 | 2020-08-02 | Nelson | Kentucky | 21179 | 189 | 2 |
390239 | 390239 | 2020-08-01 | Nelson | Kentucky | 21179 | 187 | 2 |
387022 | 387022 | 2020-07-31 | Nelson | Kentucky | 21179 | 186 | 2 |
383804 | 383804 | 2020-07-30 | Nelson | Kentucky | 21179 | 181 | 2 |
380587 | 380587 | 2020-07-29 | Nelson | Kentucky | 21179 | 178 | 2 |
377370 | 377370 | 2020-07-28 | Nelson | Kentucky | 21179 | 177 | 2 |
374155 | 374155 | 2020-07-27 | Nelson | Kentucky | 21179 | 177 | 2 |
370943 | 370943 | 2020-07-26 | Nelson | Kentucky | 21179 | 175 | 2 |
367733 | 367733 | 2020-07-25 | Nelson | Kentucky | 21179 | 173 | 2 |
364526 | 364526 | 2020-07-24 | Nelson | Kentucky | 21179 | 168 | 2 |
361319 | 361319 | 2020-07-23 | Nelson | Kentucky | 21179 | 162 | 2 |
358114 | 358114 | 2020-07-22 | Nelson | Kentucky | 21179 | 159 | 2 |
354911 | 354911 | 2020-07-21 | Nelson | Kentucky | 21179 | 151 | 2 |
351709 | 351709 | 2020-07-20 | Nelson | Kentucky | 21179 | 147 | 2 |
348509 | 348509 | 2020-07-19 | Nelson | Kentucky | 21179 | 145 | 2 |
345308 | 345308 | 2020-07-18 | Nelson | Kentucky | 21179 | 137 | 2 |
342108 | 342108 | 2020-07-17 | Nelson | Kentucky | 21179 | 134 | 2 |
338912 | 338912 | 2020-07-16 | Nelson | Kentucky | 21179 | 130 | 2 |
335716 | 335716 | 2020-07-15 | Nelson | Kentucky | 21179 | 126 | 2 |
332523 | 332523 | 2020-07-14 | Nelson | Kentucky | 21179 | 123 | 2 |
329336 | 329336 | 2020-07-13 | Nelson | Kentucky | 21179 | 116 | 2 |
326150 | 326150 | 2020-07-12 | Nelson | Kentucky | 21179 | 115 | 2 |
322967 | 322967 | 2020-07-11 | Nelson | Kentucky | 21179 | 114 | 2 |
319788 | 319788 | 2020-07-10 | Nelson | Kentucky | 21179 | 109 | 2 |
316613 | 316613 | 2020-07-09 | Nelson | Kentucky | 21179 | 105 | 2 |
313439 | 313439 | 2020-07-08 | Nelson | Kentucky | 21179 | 97 | 2 |
310269 | 310269 | 2020-07-07 | Nelson | Kentucky | 21179 | 93 | 2 |
307101 | 307101 | 2020-07-06 | Nelson | Kentucky | 21179 | 90 | 2 |
303934 | 303934 | 2020-07-05 | Nelson | Kentucky | 21179 | 81 | 1 |
300770 | 300770 | 2020-07-04 | Nelson | Kentucky | 21179 | 81 | 1 |
297608 | 297608 | 2020-07-03 | Nelson | Kentucky | 21179 | 81 | 1 |
294450 | 294450 | 2020-07-02 | Nelson | Kentucky | 21179 | 77 | 1 |
291296 | 291296 | 2020-07-01 | Nelson | Kentucky | 21179 | 76 | 1 |
288146 | 288146 | 2020-06-30 | Nelson | Kentucky | 21179 | 74 | 1 |
284997 | 284997 | 2020-06-29 | Nelson | Kentucky | 21179 | 70 | 1 |
281851 | 281851 | 2020-06-28 | Nelson | Kentucky | 21179 | 69 | 1 |
278703 | 278703 | 2020-06-27 | Nelson | Kentucky | 21179 | 69 | 1 |
275555 | 275555 | 2020-06-26 | Nelson | Kentucky | 21179 | 67 | 1 |
272412 | 272412 | 2020-06-25 | Nelson | Kentucky | 21179 | 67 | 1 |
269276 | 269276 | 2020-06-24 | Nelson | Kentucky | 21179 | 65 | 1 |
266143 | 266143 | 2020-06-23 | Nelson | Kentucky | 21179 | 60 | 1 |
263016 | 263016 | 2020-06-22 | Nelson | Kentucky | 21179 | 54 | 1 |
259887 | 259887 | 2020-06-21 | Nelson | Kentucky | 21179 | 53 | 1 |
256761 | 256761 | 2020-06-20 | Nelson | Kentucky | 21179 | 53 | 1 |
253641 | 253641 | 2020-06-19 | Nelson | Kentucky | 21179 | 50 | 1 |
250526 | 250526 | 2020-06-18 | Nelson | Kentucky | 21179 | 50 | 1 |
247414 | 247414 | 2020-06-17 | Nelson | Kentucky | 21179 | 49 | 1 |
244301 | 244301 | 2020-06-16 | Nelson | Kentucky | 21179 | 48 | 1 |
241190 | 241190 | 2020-06-15 | Nelson | Kentucky | 21179 | 48 | 1 |
238081 | 238081 | 2020-06-14 | Nelson | Kentucky | 21179 | 48 | 1 |
234974 | 234974 | 2020-06-13 | Nelson | Kentucky | 21179 | 48 | 1 |
231869 | 231869 | 2020-06-12 | Nelson | Kentucky | 21179 | 47 | 1 |
228765 | 228765 | 2020-06-11 | Nelson | Kentucky | 21179 | 47 | 1 |
225663 | 225663 | 2020-06-10 | Nelson | Kentucky | 21179 | 47 | 1 |
222567 | 222567 | 2020-06-09 | Nelson | Kentucky | 21179 | 45 | 1 |
219472 | 219472 | 2020-06-08 | Nelson | Kentucky | 21179 | 45 | 1 |
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);