ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 21177 and state = "Kentucky" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
294449 | 294449 | 2020-07-02 | Muhlenberg | Kentucky | 21177 | 527 | 8 |
297607 | 297607 | 2020-07-03 | Muhlenberg | Kentucky | 21177 | 527 | 8 |
300769 | 300769 | 2020-07-04 | Muhlenberg | Kentucky | 21177 | 538 | 8 |
303933 | 303933 | 2020-07-05 | Muhlenberg | Kentucky | 21177 | 538 | 8 |
307100 | 307100 | 2020-07-06 | Muhlenberg | Kentucky | 21177 | 538 | 8 |
310268 | 310268 | 2020-07-07 | Muhlenberg | Kentucky | 21177 | 545 | 8 |
313438 | 313438 | 2020-07-08 | Muhlenberg | Kentucky | 21177 | 549 | 8 |
316612 | 316612 | 2020-07-09 | Muhlenberg | Kentucky | 21177 | 549 | 8 |
319787 | 319787 | 2020-07-10 | Muhlenberg | Kentucky | 21177 | 558 | 8 |
322966 | 322966 | 2020-07-11 | Muhlenberg | Kentucky | 21177 | 564 | 8 |
326149 | 326149 | 2020-07-12 | Muhlenberg | Kentucky | 21177 | 565 | 8 |
329335 | 329335 | 2020-07-13 | Muhlenberg | Kentucky | 21177 | 566 | 8 |
332522 | 332522 | 2020-07-14 | Muhlenberg | Kentucky | 21177 | 575 | 8 |
335715 | 335715 | 2020-07-15 | Muhlenberg | Kentucky | 21177 | 584 | 8 |
338911 | 338911 | 2020-07-16 | Muhlenberg | Kentucky | 21177 | 584 | 9 |
342107 | 342107 | 2020-07-17 | Muhlenberg | Kentucky | 21177 | 585 | 9 |
345307 | 345307 | 2020-07-18 | Muhlenberg | Kentucky | 21177 | 591 | 9 |
348508 | 348508 | 2020-07-19 | Muhlenberg | Kentucky | 21177 | 595 | 9 |
351708 | 351708 | 2020-07-20 | Muhlenberg | Kentucky | 21177 | 598 | 9 |
354910 | 354910 | 2020-07-21 | Muhlenberg | Kentucky | 21177 | 601 | 9 |
358113 | 358113 | 2020-07-22 | Muhlenberg | Kentucky | 21177 | 602 | 9 |
361318 | 361318 | 2020-07-23 | Muhlenberg | Kentucky | 21177 | 608 | 9 |
364525 | 364525 | 2020-07-24 | Muhlenberg | Kentucky | 21177 | 612 | 9 |
367732 | 367732 | 2020-07-25 | Muhlenberg | Kentucky | 21177 | 614 | 9 |
370942 | 370942 | 2020-07-26 | Muhlenberg | Kentucky | 21177 | 616 | 9 |
374154 | 374154 | 2020-07-27 | Muhlenberg | Kentucky | 21177 | 620 | 9 |
377369 | 377369 | 2020-07-28 | Muhlenberg | Kentucky | 21177 | 620 | 9 |
380586 | 380586 | 2020-07-29 | Muhlenberg | Kentucky | 21177 | 623 | 9 |
383803 | 383803 | 2020-07-30 | Muhlenberg | Kentucky | 21177 | 625 | 9 |
387021 | 387021 | 2020-07-31 | Muhlenberg | Kentucky | 21177 | 627 | 9 |
390238 | 390238 | 2020-08-01 | Muhlenberg | Kentucky | 21177 | 627 | 10 |
393455 | 393455 | 2020-08-02 | Muhlenberg | Kentucky | 21177 | 628 | 10 |
396671 | 396671 | 2020-08-03 | Muhlenberg | Kentucky | 21177 | 634 | 10 |
399886 | 399886 | 2020-08-04 | Muhlenberg | Kentucky | 21177 | 638 | 10 |
403103 | 403103 | 2020-08-05 | Muhlenberg | Kentucky | 21177 | 638 | 10 |
406321 | 406321 | 2020-08-06 | Muhlenberg | Kentucky | 21177 | 638 | 10 |
409541 | 409541 | 2020-08-07 | Muhlenberg | Kentucky | 21177 | 639 | 10 |
412761 | 412761 | 2020-08-08 | Muhlenberg | Kentucky | 21177 | 646 | 11 |
415981 | 415981 | 2020-08-09 | Muhlenberg | Kentucky | 21177 | 645 | 11 |
419202 | 419202 | 2020-08-10 | Muhlenberg | Kentucky | 21177 | 649 | 11 |
422424 | 422424 | 2020-08-11 | Muhlenberg | Kentucky | 21177 | 650 | 11 |
425645 | 425645 | 2020-08-12 | Muhlenberg | Kentucky | 21177 | 653 | 11 |
428869 | 428869 | 2020-08-13 | Muhlenberg | Kentucky | 21177 | 653 | 11 |
432097 | 432097 | 2020-08-14 | Muhlenberg | Kentucky | 21177 | 653 | 11 |
435322 | 435322 | 2020-08-15 | Muhlenberg | Kentucky | 21177 | 656 | 11 |
438547 | 438547 | 2020-08-16 | Muhlenberg | Kentucky | 21177 | 659 | 11 |
441774 | 441774 | 2020-08-17 | Muhlenberg | Kentucky | 21177 | 661 | 11 |
445000 | 445000 | 2020-08-18 | Muhlenberg | Kentucky | 21177 | 661 | 11 |
448227 | 448227 | 2020-08-19 | Muhlenberg | Kentucky | 21177 | 662 | 11 |
451455 | 451455 | 2020-08-20 | Muhlenberg | Kentucky | 21177 | 665 | 11 |
454683 | 454683 | 2020-08-21 | Muhlenberg | Kentucky | 21177 | 667 | 11 |
457911 | 457911 | 2020-08-22 | Muhlenberg | Kentucky | 21177 | 668 | 11 |
461138 | 461138 | 2020-08-23 | Muhlenberg | Kentucky | 21177 | 668 | 11 |
464369 | 464369 | 2020-08-24 | Muhlenberg | Kentucky | 21177 | 672 | 11 |
467598 | 467598 | 2020-08-25 | Muhlenberg | Kentucky | 21177 | 673 | 11 |
470827 | 470827 | 2020-08-26 | Muhlenberg | Kentucky | 21177 | 675 | 11 |
474059 | 474059 | 2020-08-27 | Muhlenberg | Kentucky | 21177 | 681 | 11 |
477292 | 477292 | 2020-08-28 | Muhlenberg | Kentucky | 21177 | 681 | 11 |
480525 | 480525 | 2020-08-29 | Muhlenberg | Kentucky | 21177 | 681 | 11 |
483759 | 483759 | 2020-08-30 | Muhlenberg | Kentucky | 21177 | 681 | 11 |
486994 | 486994 | 2020-08-31 | Muhlenberg | Kentucky | 21177 | 682 | 11 |
490227 | 490227 | 2020-09-01 | Muhlenberg | Kentucky | 21177 | 683 | 11 |
493461 | 493461 | 2020-09-02 | Muhlenberg | Kentucky | 21177 | 685 | 11 |
496694 | 496694 | 2020-09-03 | Muhlenberg | Kentucky | 21177 | 688 | 11 |
499928 | 499928 | 2020-09-04 | Muhlenberg | Kentucky | 21177 | 688 | 11 |
503161 | 503161 | 2020-09-05 | Muhlenberg | Kentucky | 21177 | 695 | 11 |
506395 | 506395 | 2020-09-06 | Muhlenberg | Kentucky | 21177 | 696 | 11 |
509628 | 509628 | 2020-09-07 | Muhlenberg | Kentucky | 21177 | 696 | 11 |
512860 | 512860 | 2020-09-08 | Muhlenberg | Kentucky | 21177 | 702 | 12 |
516093 | 516093 | 2020-09-09 | Muhlenberg | Kentucky | 21177 | 708 | 12 |
519328 | 519328 | 2020-09-10 | Muhlenberg | Kentucky | 21177 | 708 | 12 |
522565 | 522565 | 2020-09-11 | Muhlenberg | Kentucky | 21177 | 710 | 13 |
525801 | 525801 | 2020-09-12 | Muhlenberg | Kentucky | 21177 | 713 | 13 |
529037 | 529037 | 2020-09-13 | Muhlenberg | Kentucky | 21177 | 724 | 13 |
532274 | 532274 | 2020-09-14 | Muhlenberg | Kentucky | 21177 | 727 | 13 |
535509 | 535509 | 2020-09-15 | Muhlenberg | Kentucky | 21177 | 733 | 13 |
538746 | 538746 | 2020-09-16 | Muhlenberg | Kentucky | 21177 | 740 | 13 |
541982 | 541982 | 2020-09-17 | Muhlenberg | Kentucky | 21177 | 747 | 13 |
545218 | 545218 | 2020-09-18 | Muhlenberg | Kentucky | 21177 | 749 | 13 |
548456 | 548456 | 2020-09-19 | Muhlenberg | Kentucky | 21177 | 754 | 13 |
551695 | 551695 | 2020-09-20 | Muhlenberg | Kentucky | 21177 | 755 | 13 |
554934 | 554934 | 2020-09-21 | Muhlenberg | Kentucky | 21177 | 769 | 13 |
558171 | 558171 | 2020-09-22 | Muhlenberg | Kentucky | 21177 | 775 | 13 |
561407 | 561407 | 2020-09-23 | Muhlenberg | Kentucky | 21177 | 782 | 13 |
564647 | 564647 | 2020-09-24 | Muhlenberg | Kentucky | 21177 | 788 | 13 |
567887 | 567887 | 2020-09-25 | Muhlenberg | Kentucky | 21177 | 788 | 13 |
571129 | 571129 | 2020-09-26 | Muhlenberg | Kentucky | 21177 | 793 | 13 |
574372 | 574372 | 2020-09-27 | Muhlenberg | Kentucky | 21177 | 794 | 13 |
577614 | 577614 | 2020-09-28 | Muhlenberg | Kentucky | 21177 | 800 | 13 |
580855 | 580855 | 2020-09-29 | Muhlenberg | Kentucky | 21177 | 805 | 13 |
584095 | 584095 | 2020-09-30 | Muhlenberg | Kentucky | 21177 | 807 | 13 |
587335 | 587335 | 2020-10-01 | Muhlenberg | Kentucky | 21177 | 812 | 13 |
590576 | 590576 | 2020-10-02 | Muhlenberg | Kentucky | 21177 | 824 | 13 |
593817 | 593817 | 2020-10-03 | Muhlenberg | Kentucky | 21177 | 826 | 13 |
597059 | 597059 | 2020-10-04 | Muhlenberg | Kentucky | 21177 | 827 | 13 |
600301 | 600301 | 2020-10-05 | Muhlenberg | Kentucky | 21177 | 834 | 13 |
603544 | 603544 | 2020-10-06 | Muhlenberg | Kentucky | 21177 | 836 | 13 |
606786 | 606786 | 2020-10-07 | Muhlenberg | Kentucky | 21177 | 844 | 13 |
610028 | 610028 | 2020-10-08 | Muhlenberg | Kentucky | 21177 | 853 | 13 |
613270 | 613270 | 2020-10-09 | Muhlenberg | Kentucky | 21177 | 860 | 13 |
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);