ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Pulaski" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
911802 | 911802 | 2021-01-09 | Pulaski | Kentucky | 21199 | 4350 | 65 |
908557 | 908557 | 2021-01-08 | Pulaski | Kentucky | 21199 | 4280 | 65 |
905311 | 905311 | 2021-01-07 | Pulaski | Kentucky | 21199 | 4176 | 65 |
902066 | 902066 | 2021-01-06 | Pulaski | Kentucky | 21199 | 4122 | 65 |
898821 | 898821 | 2021-01-05 | Pulaski | Kentucky | 21199 | 4037 | 65 |
895576 | 895576 | 2021-01-04 | Pulaski | Kentucky | 21199 | 3986 | 65 |
892329 | 892329 | 2021-01-03 | Pulaski | Kentucky | 21199 | 3938 | 63 |
889083 | 889083 | 2021-01-02 | Pulaski | Kentucky | 21199 | 3907 | 63 |
885837 | 885837 | 2021-01-01 | Pulaski | Kentucky | 21199 | 3875 | 62 |
882592 | 882592 | 2020-12-31 | Pulaski | Kentucky | 21199 | 3875 | 62 |
879347 | 879347 | 2020-12-30 | Pulaski | Kentucky | 21199 | 3875 | 62 |
876102 | 876102 | 2020-12-29 | Pulaski | Kentucky | 21199 | 3797 | 60 |
872857 | 872857 | 2020-12-28 | Pulaski | Kentucky | 21199 | 3718 | 60 |
869612 | 869612 | 2020-12-27 | Pulaski | Kentucky | 21199 | 3700 | 55 |
866367 | 866367 | 2020-12-26 | Pulaski | Kentucky | 21199 | 3660 | 55 |
863122 | 863122 | 2020-12-25 | Pulaski | Kentucky | 21199 | 3616 | 55 |
859877 | 859877 | 2020-12-24 | Pulaski | Kentucky | 21199 | 3616 | 55 |
856632 | 856632 | 2020-12-23 | Pulaski | Kentucky | 21199 | 3616 | 55 |
853387 | 853387 | 2020-12-22 | Pulaski | Kentucky | 21199 | 3526 | 54 |
850142 | 850142 | 2020-12-21 | Pulaski | Kentucky | 21199 | 3476 | 54 |
846897 | 846897 | 2020-12-20 | Pulaski | Kentucky | 21199 | 3419 | 52 |
843651 | 843651 | 2020-12-19 | Pulaski | Kentucky | 21199 | 3370 | 49 |
840406 | 840406 | 2020-12-18 | Pulaski | Kentucky | 21199 | 3314 | 49 |
837161 | 837161 | 2020-12-17 | Pulaski | Kentucky | 21199 | 3270 | 47 |
833915 | 833915 | 2020-12-16 | Pulaski | Kentucky | 21199 | 3132 | 43 |
830668 | 830668 | 2020-12-15 | Pulaski | Kentucky | 21199 | 3065 | 43 |
827422 | 827422 | 2020-12-14 | Pulaski | Kentucky | 21199 | 3022 | 40 |
824175 | 824175 | 2020-12-13 | Pulaski | Kentucky | 21199 | 2988 | 39 |
820929 | 820929 | 2020-12-12 | Pulaski | Kentucky | 21199 | 2948 | 39 |
817683 | 817683 | 2020-12-11 | Pulaski | Kentucky | 21199 | 2871 | 39 |
814437 | 814437 | 2020-12-10 | Pulaski | Kentucky | 21199 | 2818 | 31 |
811192 | 811192 | 2020-12-09 | Pulaski | Kentucky | 21199 | 2766 | 30 |
807947 | 807947 | 2020-12-08 | Pulaski | Kentucky | 21199 | 2698 | 30 |
804702 | 804702 | 2020-12-07 | Pulaski | Kentucky | 21199 | 2628 | 30 |
801457 | 801457 | 2020-12-06 | Pulaski | Kentucky | 21199 | 2571 | 29 |
798212 | 798212 | 2020-12-05 | Pulaski | Kentucky | 21199 | 2532 | 29 |
794967 | 794967 | 2020-12-04 | Pulaski | Kentucky | 21199 | 2455 | 25 |
791722 | 791722 | 2020-12-03 | Pulaski | Kentucky | 21199 | 2404 | 23 |
788477 | 788477 | 2020-12-02 | Pulaski | Kentucky | 21199 | 2341 | 21 |
785233 | 785233 | 2020-12-01 | Pulaski | Kentucky | 21199 | 2281 | 18 |
781988 | 781988 | 2020-11-30 | Pulaski | Kentucky | 21199 | 2236 | 18 |
778742 | 778742 | 2020-11-29 | Pulaski | Kentucky | 21199 | 2192 | 17 |
775497 | 775497 | 2020-11-28 | Pulaski | Kentucky | 21199 | 2141 | 17 |
772252 | 772252 | 2020-11-27 | Pulaski | Kentucky | 21199 | 2107 | 17 |
769007 | 769007 | 2020-11-26 | Pulaski | Kentucky | 21199 | 2062 | 17 |
765761 | 765761 | 2020-11-25 | Pulaski | Kentucky | 21199 | 2062 | 17 |
762516 | 762516 | 2020-11-24 | Pulaski | Kentucky | 21199 | 1992 | 14 |
759271 | 759271 | 2020-11-23 | Pulaski | Kentucky | 21199 | 1909 | 14 |
756024 | 756024 | 2020-11-22 | Pulaski | Kentucky | 21199 | 1862 | 14 |
752778 | 752778 | 2020-11-21 | Pulaski | Kentucky | 21199 | 1836 | 13 |
749532 | 749532 | 2020-11-20 | Pulaski | Kentucky | 21199 | 1791 | 13 |
746286 | 746286 | 2020-11-19 | Pulaski | Kentucky | 21199 | 1728 | 13 |
743039 | 743039 | 2020-11-18 | Pulaski | Kentucky | 21199 | 1629 | 13 |
739792 | 739792 | 2020-11-17 | Pulaski | Kentucky | 21199 | 1548 | 13 |
736548 | 736548 | 2020-11-16 | Pulaski | Kentucky | 21199 | 1524 | 13 |
733302 | 733302 | 2020-11-15 | Pulaski | Kentucky | 21199 | 1500 | 13 |
730057 | 730057 | 2020-11-14 | Pulaski | Kentucky | 21199 | 1476 | 13 |
726814 | 726814 | 2020-11-13 | Pulaski | Kentucky | 21199 | 1418 | 13 |
723571 | 723571 | 2020-11-12 | Pulaski | Kentucky | 21199 | 1396 | 13 |
720328 | 720328 | 2020-11-11 | Pulaski | Kentucky | 21199 | 1360 | 13 |
717085 | 717085 | 2020-11-10 | Pulaski | Kentucky | 21199 | 1314 | 13 |
713841 | 713841 | 2020-11-09 | Pulaski | Kentucky | 21199 | 1291 | 13 |
710597 | 710597 | 2020-11-08 | Pulaski | Kentucky | 21199 | 1268 | 13 |
707353 | 707353 | 2020-11-07 | Pulaski | Kentucky | 21199 | 1250 | 13 |
704110 | 704110 | 2020-11-06 | Pulaski | Kentucky | 21199 | 1224 | 13 |
700868 | 700868 | 2020-11-05 | Pulaski | Kentucky | 21199 | 1194 | 13 |
697624 | 697624 | 2020-11-04 | Pulaski | Kentucky | 21199 | 1162 | 13 |
694381 | 694381 | 2020-11-03 | Pulaski | Kentucky | 21199 | 1143 | 13 |
691139 | 691139 | 2020-11-02 | Pulaski | Kentucky | 21199 | 1118 | 13 |
687894 | 687894 | 2020-11-01 | Pulaski | Kentucky | 21199 | 1086 | 13 |
684650 | 684650 | 2020-10-31 | Pulaski | Kentucky | 21199 | 1074 | 13 |
681407 | 681407 | 2020-10-30 | Pulaski | Kentucky | 21199 | 1072 | 13 |
678163 | 678163 | 2020-10-29 | Pulaski | Kentucky | 21199 | 1064 | 13 |
674921 | 674921 | 2020-10-28 | Pulaski | Kentucky | 21199 | 1052 | 13 |
671678 | 671678 | 2020-10-27 | Pulaski | Kentucky | 21199 | 1029 | 13 |
668436 | 668436 | 2020-10-26 | Pulaski | Kentucky | 21199 | 1018 | 13 |
665192 | 665192 | 2020-10-25 | Pulaski | Kentucky | 21199 | 1011 | 13 |
661947 | 661947 | 2020-10-24 | Pulaski | Kentucky | 21199 | 1002 | 13 |
658703 | 658703 | 2020-10-23 | Pulaski | Kentucky | 21199 | 992 | 13 |
655458 | 655458 | 2020-10-22 | Pulaski | Kentucky | 21199 | 983 | 13 |
652213 | 652213 | 2020-10-21 | Pulaski | Kentucky | 21199 | 975 | 13 |
648968 | 648968 | 2020-10-20 | Pulaski | Kentucky | 21199 | 969 | 13 |
645724 | 645724 | 2020-10-19 | Pulaski | Kentucky | 21199 | 965 | 13 |
642477 | 642477 | 2020-10-18 | Pulaski | Kentucky | 21199 | 958 | 13 |
639230 | 639230 | 2020-10-17 | Pulaski | Kentucky | 21199 | 957 | 13 |
635984 | 635984 | 2020-10-16 | Pulaski | Kentucky | 21199 | 953 | 12 |
632738 | 632738 | 2020-10-15 | Pulaski | Kentucky | 21199 | 942 | 12 |
629494 | 629494 | 2020-10-14 | Pulaski | Kentucky | 21199 | 931 | 12 |
626250 | 626250 | 2020-10-13 | Pulaski | Kentucky | 21199 | 921 | 12 |
623008 | 623008 | 2020-10-12 | Pulaski | Kentucky | 21199 | 915 | 12 |
619764 | 619764 | 2020-10-11 | Pulaski | Kentucky | 21199 | 905 | 12 |
616522 | 616522 | 2020-10-10 | Pulaski | Kentucky | 21199 | 900 | 12 |
613281 | 613281 | 2020-10-09 | Pulaski | Kentucky | 21199 | 893 | 12 |
610039 | 610039 | 2020-10-08 | Pulaski | Kentucky | 21199 | 876 | 11 |
606797 | 606797 | 2020-10-07 | Pulaski | Kentucky | 21199 | 867 | 11 |
603555 | 603555 | 2020-10-06 | Pulaski | Kentucky | 21199 | 858 | 11 |
600312 | 600312 | 2020-10-05 | Pulaski | Kentucky | 21199 | 849 | 11 |
597070 | 597070 | 2020-10-04 | Pulaski | Kentucky | 21199 | 840 | 11 |
593828 | 593828 | 2020-10-03 | Pulaski | Kentucky | 21199 | 836 | 11 |
590587 | 590587 | 2020-10-02 | Pulaski | Kentucky | 21199 | 833 | 11 |
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);