ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 21199 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090307 | 1090307 | 2021-03-05 | Pulaski | Kentucky | 21199 | 5820 | 88 |
1087062 | 1087062 | 2021-03-04 | Pulaski | Kentucky | 21199 | 5802 | 87 |
1083816 | 1083816 | 2021-03-03 | Pulaski | Kentucky | 21199 | 5794 | 87 |
1080570 | 1080570 | 2021-03-02 | Pulaski | Kentucky | 21199 | 5783 | 87 |
1077325 | 1077325 | 2021-03-01 | Pulaski | Kentucky | 21199 | 5773 | 87 |
1074079 | 1074079 | 2021-02-28 | Pulaski | Kentucky | 21199 | 5764 | 87 |
1070833 | 1070833 | 2021-02-27 | Pulaski | Kentucky | 21199 | 5764 | 87 |
1067588 | 1067588 | 2021-02-26 | Pulaski | Kentucky | 21199 | 5760 | 87 |
1064343 | 1064343 | 2021-02-25 | Pulaski | Kentucky | 21199 | 5753 | 87 |
1061098 | 1061098 | 2021-02-24 | Pulaski | Kentucky | 21199 | 5740 | 87 |
1057852 | 1057852 | 2021-02-23 | Pulaski | Kentucky | 21199 | 5723 | 84 |
1054606 | 1054606 | 2021-02-22 | Pulaski | Kentucky | 21199 | 5687 | 84 |
1051359 | 1051359 | 2021-02-21 | Pulaski | Kentucky | 21199 | 5662 | 84 |
1048112 | 1048112 | 2021-02-20 | Pulaski | Kentucky | 21199 | 5662 | 84 |
1044867 | 1044867 | 2021-02-19 | Pulaski | Kentucky | 21199 | 5655 | 84 |
1041622 | 1041622 | 2021-02-18 | Pulaski | Kentucky | 21199 | 5645 | 84 |
1038377 | 1038377 | 2021-02-17 | Pulaski | Kentucky | 21199 | 5634 | 84 |
1035132 | 1035132 | 2021-02-16 | Pulaski | Kentucky | 21199 | 5618 | 82 |
1031886 | 1031886 | 2021-02-15 | Pulaski | Kentucky | 21199 | 5609 | 82 |
1028639 | 1028639 | 2021-02-14 | Pulaski | Kentucky | 21199 | 5578 | 81 |
1025394 | 1025394 | 2021-02-13 | Pulaski | Kentucky | 21199 | 5578 | 81 |
1022149 | 1022149 | 2021-02-12 | Pulaski | Kentucky | 21199 | 5553 | 80 |
1018904 | 1018904 | 2021-02-11 | Pulaski | Kentucky | 21199 | 5529 | 79 |
1015659 | 1015659 | 2021-02-10 | Pulaski | Kentucky | 21199 | 5513 | 79 |
1012414 | 1012414 | 2021-02-09 | Pulaski | Kentucky | 21199 | 5472 | 79 |
1009168 | 1009168 | 2021-02-08 | Pulaski | Kentucky | 21199 | 5428 | 78 |
1005922 | 1005922 | 2021-02-07 | Pulaski | Kentucky | 21199 | 5403 | 77 |
1002676 | 1002676 | 2021-02-06 | Pulaski | Kentucky | 21199 | 5403 | 77 |
999430 | 999430 | 2021-02-05 | Pulaski | Kentucky | 21199 | 5372 | 77 |
996184 | 996184 | 2021-02-04 | Pulaski | Kentucky | 21199 | 5338 | 77 |
992938 | 992938 | 2021-02-03 | Pulaski | Kentucky | 21199 | 5308 | 77 |
989692 | 989692 | 2021-02-02 | Pulaski | Kentucky | 21199 | 5276 | 77 |
986445 | 986445 | 2021-02-01 | Pulaski | Kentucky | 21199 | 5225 | 77 |
983198 | 983198 | 2021-01-31 | Pulaski | Kentucky | 21199 | 5191 | 76 |
979952 | 979952 | 2021-01-30 | Pulaski | Kentucky | 21199 | 5174 | 76 |
976706 | 976706 | 2021-01-29 | Pulaski | Kentucky | 21199 | 5139 | 75 |
973461 | 973461 | 2021-01-28 | Pulaski | Kentucky | 21199 | 5108 | 74 |
970216 | 970216 | 2021-01-27 | Pulaski | Kentucky | 21199 | 5068 | 74 |
966972 | 966972 | 2021-01-26 | Pulaski | Kentucky | 21199 | 5035 | 73 |
963727 | 963727 | 2021-01-25 | Pulaski | Kentucky | 21199 | 5013 | 73 |
960482 | 960482 | 2021-01-24 | Pulaski | Kentucky | 21199 | 4995 | 73 |
957236 | 957236 | 2021-01-23 | Pulaski | Kentucky | 21199 | 4959 | 73 |
953991 | 953991 | 2021-01-22 | Pulaski | Kentucky | 21199 | 4915 | 73 |
950746 | 950746 | 2021-01-21 | Pulaski | Kentucky | 21199 | 4869 | 72 |
947500 | 947500 | 2021-01-20 | Pulaski | Kentucky | 21199 | 4834 | 69 |
944253 | 944253 | 2021-01-19 | Pulaski | Kentucky | 21199 | 4789 | 69 |
941008 | 941008 | 2021-01-18 | Pulaski | Kentucky | 21199 | 4736 | 68 |
937763 | 937763 | 2021-01-17 | Pulaski | Kentucky | 21199 | 4715 | 66 |
934518 | 934518 | 2021-01-16 | Pulaski | Kentucky | 21199 | 4674 | 66 |
931273 | 931273 | 2021-01-15 | Pulaski | Kentucky | 21199 | 4652 | 66 |
928028 | 928028 | 2021-01-14 | Pulaski | Kentucky | 21199 | 4596 | 66 |
924782 | 924782 | 2021-01-13 | Pulaski | Kentucky | 21199 | 4557 | 65 |
921537 | 921537 | 2021-01-12 | Pulaski | Kentucky | 21199 | 4494 | 65 |
918292 | 918292 | 2021-01-11 | Pulaski | Kentucky | 21199 | 4459 | 65 |
915047 | 915047 | 2021-01-10 | Pulaski | Kentucky | 21199 | 4396 | 65 |
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 |
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);