ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Franklin" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635921 | 635921 | 2020-10-16 | Franklin | Kentucky | 21073 | 779 | 13 |
632675 | 632675 | 2020-10-15 | Franklin | Kentucky | 21073 | 771 | 13 |
629431 | 629431 | 2020-10-14 | Franklin | Kentucky | 21073 | 768 | 13 |
626187 | 626187 | 2020-10-13 | Franklin | Kentucky | 21073 | 765 | 12 |
622945 | 622945 | 2020-10-12 | Franklin | Kentucky | 21073 | 763 | 12 |
619701 | 619701 | 2020-10-11 | Franklin | Kentucky | 21073 | 762 | 12 |
616459 | 616459 | 2020-10-10 | Franklin | Kentucky | 21073 | 760 | 12 |
613218 | 613218 | 2020-10-09 | Franklin | Kentucky | 21073 | 754 | 12 |
609976 | 609976 | 2020-10-08 | Franklin | Kentucky | 21073 | 749 | 12 |
606734 | 606734 | 2020-10-07 | Franklin | Kentucky | 21073 | 742 | 12 |
603492 | 603492 | 2020-10-06 | Franklin | Kentucky | 21073 | 731 | 12 |
600249 | 600249 | 2020-10-05 | Franklin | Kentucky | 21073 | 719 | 12 |
597007 | 597007 | 2020-10-04 | Franklin | Kentucky | 21073 | 715 | 11 |
593765 | 593765 | 2020-10-03 | Franklin | Kentucky | 21073 | 712 | 12 |
590524 | 590524 | 2020-10-02 | Franklin | Kentucky | 21073 | 701 | 12 |
587283 | 587283 | 2020-10-01 | Franklin | Kentucky | 21073 | 677 | 12 |
584043 | 584043 | 2020-09-30 | Franklin | Kentucky | 21073 | 672 | 11 |
580803 | 580803 | 2020-09-29 | Franklin | Kentucky | 21073 | 667 | 12 |
577562 | 577562 | 2020-09-28 | Franklin | Kentucky | 21073 | 654 | 12 |
574320 | 574320 | 2020-09-27 | Franklin | Kentucky | 21073 | 652 | 12 |
571077 | 571077 | 2020-09-26 | Franklin | Kentucky | 21073 | 653 | 12 |
567835 | 567835 | 2020-09-25 | Franklin | Kentucky | 21073 | 635 | 11 |
564595 | 564595 | 2020-09-24 | Franklin | Kentucky | 21073 | 628 | 12 |
561355 | 561355 | 2020-09-23 | Franklin | Kentucky | 21073 | 606 | 12 |
558119 | 558119 | 2020-09-22 | Franklin | Kentucky | 21073 | 604 | 12 |
554882 | 554882 | 2020-09-21 | Franklin | Kentucky | 21073 | 597 | 12 |
551643 | 551643 | 2020-09-20 | Franklin | Kentucky | 21073 | 595 | 11 |
548404 | 548404 | 2020-09-19 | Franklin | Kentucky | 21073 | 594 | 11 |
545166 | 545166 | 2020-09-18 | Franklin | Kentucky | 21073 | 590 | 11 |
541930 | 541930 | 2020-09-17 | Franklin | Kentucky | 21073 | 585 | 12 |
538694 | 538694 | 2020-09-16 | Franklin | Kentucky | 21073 | 582 | 11 |
535457 | 535457 | 2020-09-15 | Franklin | Kentucky | 21073 | 577 | 11 |
532222 | 532222 | 2020-09-14 | Franklin | Kentucky | 21073 | 566 | 11 |
528985 | 528985 | 2020-09-13 | Franklin | Kentucky | 21073 | 566 | 11 |
525749 | 525749 | 2020-09-12 | Franklin | Kentucky | 21073 | 559 | 11 |
522513 | 522513 | 2020-09-11 | Franklin | Kentucky | 21073 | 547 | 11 |
519276 | 519276 | 2020-09-10 | Franklin | Kentucky | 21073 | 536 | 11 |
516041 | 516041 | 2020-09-09 | Franklin | Kentucky | 21073 | 526 | 11 |
512808 | 512808 | 2020-09-08 | Franklin | Kentucky | 21073 | 516 | 11 |
509576 | 509576 | 2020-09-07 | Franklin | Kentucky | 21073 | 513 | 11 |
506343 | 506343 | 2020-09-06 | Franklin | Kentucky | 21073 | 513 | 11 |
503109 | 503109 | 2020-09-05 | Franklin | Kentucky | 21073 | 510 | 11 |
499876 | 499876 | 2020-09-04 | Franklin | Kentucky | 21073 | 507 | 11 |
496642 | 496642 | 2020-09-03 | Franklin | Kentucky | 21073 | 498 | 11 |
493409 | 493409 | 2020-09-02 | Franklin | Kentucky | 21073 | 483 | 11 |
490175 | 490175 | 2020-09-01 | Franklin | Kentucky | 21073 | 481 | 11 |
486942 | 486942 | 2020-08-31 | Franklin | Kentucky | 21073 | 466 | 11 |
483707 | 483707 | 2020-08-30 | Franklin | Kentucky | 21073 | 466 | 11 |
480473 | 480473 | 2020-08-29 | Franklin | Kentucky | 21073 | 461 | 11 |
477240 | 477240 | 2020-08-28 | Franklin | Kentucky | 21073 | 457 | 11 |
474007 | 474007 | 2020-08-27 | Franklin | Kentucky | 21073 | 451 | 11 |
470775 | 470775 | 2020-08-26 | Franklin | Kentucky | 21073 | 448 | 11 |
467546 | 467546 | 2020-08-25 | Franklin | Kentucky | 21073 | 442 | 11 |
464317 | 464317 | 2020-08-24 | Franklin | Kentucky | 21073 | 433 | 11 |
461086 | 461086 | 2020-08-23 | Franklin | Kentucky | 21073 | 428 | 11 |
457859 | 457859 | 2020-08-22 | Franklin | Kentucky | 21073 | 428 | 11 |
454631 | 454631 | 2020-08-21 | Franklin | Kentucky | 21073 | 416 | 11 |
451403 | 451403 | 2020-08-20 | Franklin | Kentucky | 21073 | 405 | 11 |
448175 | 448175 | 2020-08-19 | Franklin | Kentucky | 21073 | 400 | 11 |
444948 | 444948 | 2020-08-18 | Franklin | Kentucky | 21073 | 375 | 11 |
441722 | 441722 | 2020-08-17 | Franklin | Kentucky | 21073 | 357 | 11 |
438495 | 438495 | 2020-08-16 | Franklin | Kentucky | 21073 | 349 | 9 |
435270 | 435270 | 2020-08-15 | Franklin | Kentucky | 21073 | 349 | 9 |
432045 | 432045 | 2020-08-14 | Franklin | Kentucky | 21073 | 348 | 9 |
428817 | 428817 | 2020-08-13 | Franklin | Kentucky | 21073 | 343 | 7 |
425593 | 425593 | 2020-08-12 | Franklin | Kentucky | 21073 | 329 | 7 |
422372 | 422372 | 2020-08-11 | Franklin | Kentucky | 21073 | 323 | 7 |
419150 | 419150 | 2020-08-10 | Franklin | Kentucky | 21073 | 315 | 7 |
415929 | 415929 | 2020-08-09 | Franklin | Kentucky | 21073 | 302 | 7 |
412709 | 412709 | 2020-08-08 | Franklin | Kentucky | 21073 | 296 | 7 |
409489 | 409489 | 2020-08-07 | Franklin | Kentucky | 21073 | 291 | 7 |
406269 | 406269 | 2020-08-06 | Franklin | Kentucky | 21073 | 278 | 7 |
403051 | 403051 | 2020-08-05 | Franklin | Kentucky | 21073 | 269 | 5 |
399834 | 399834 | 2020-08-04 | Franklin | Kentucky | 21073 | 260 | 5 |
396619 | 396619 | 2020-08-03 | Franklin | Kentucky | 21073 | 257 | 5 |
393403 | 393403 | 2020-08-02 | Franklin | Kentucky | 21073 | 255 | 5 |
390186 | 390186 | 2020-08-01 | Franklin | Kentucky | 21073 | 250 | 5 |
386969 | 386969 | 2020-07-31 | Franklin | Kentucky | 21073 | 245 | 5 |
383751 | 383751 | 2020-07-30 | Franklin | Kentucky | 21073 | 238 | 5 |
380534 | 380534 | 2020-07-29 | Franklin | Kentucky | 21073 | 227 | 5 |
377317 | 377317 | 2020-07-28 | Franklin | Kentucky | 21073 | 223 | 5 |
374102 | 374102 | 2020-07-27 | Franklin | Kentucky | 21073 | 216 | 5 |
370890 | 370890 | 2020-07-26 | Franklin | Kentucky | 21073 | 213 | 5 |
367680 | 367680 | 2020-07-25 | Franklin | Kentucky | 21073 | 211 | 5 |
364473 | 364473 | 2020-07-24 | Franklin | Kentucky | 21073 | 200 | 5 |
361266 | 361266 | 2020-07-23 | Franklin | Kentucky | 21073 | 200 | 5 |
358061 | 358061 | 2020-07-22 | Franklin | Kentucky | 21073 | 198 | 5 |
354858 | 354858 | 2020-07-21 | Franklin | Kentucky | 21073 | 190 | 5 |
351656 | 351656 | 2020-07-20 | Franklin | Kentucky | 21073 | 187 | 5 |
348456 | 348456 | 2020-07-19 | Franklin | Kentucky | 21073 | 186 | 5 |
345255 | 345255 | 2020-07-18 | Franklin | Kentucky | 21073 | 181 | 5 |
342055 | 342055 | 2020-07-17 | Franklin | Kentucky | 21073 | 176 | 5 |
338859 | 338859 | 2020-07-16 | Franklin | Kentucky | 21073 | 169 | 4 |
335663 | 335663 | 2020-07-15 | Franklin | Kentucky | 21073 | 169 | 4 |
332470 | 332470 | 2020-07-14 | Franklin | Kentucky | 21073 | 168 | 4 |
329283 | 329283 | 2020-07-13 | Franklin | Kentucky | 21073 | 164 | 4 |
326097 | 326097 | 2020-07-12 | Franklin | Kentucky | 21073 | 163 | 4 |
322914 | 322914 | 2020-07-11 | Franklin | Kentucky | 21073 | 163 | 4 |
319735 | 319735 | 2020-07-10 | Franklin | Kentucky | 21073 | 159 | 4 |
316560 | 316560 | 2020-07-09 | Franklin | Kentucky | 21073 | 156 | 4 |
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);