ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 21111 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090263 | 1090263 | 2021-03-05 | Jefferson | Kentucky | 21111 | 74857 | 943 |
1087018 | 1087018 | 2021-03-04 | Jefferson | Kentucky | 21111 | 74714 | 939 |
1083772 | 1083772 | 2021-03-03 | Jefferson | Kentucky | 21111 | 74543 | 928 |
1080526 | 1080526 | 2021-03-02 | Jefferson | Kentucky | 21111 | 74391 | 924 |
1077281 | 1077281 | 2021-03-01 | Jefferson | Kentucky | 21111 | 74287 | 918 |
1074035 | 1074035 | 2021-02-28 | Jefferson | Kentucky | 21111 | 74241 | 918 |
1070789 | 1070789 | 2021-02-27 | Jefferson | Kentucky | 21111 | 74015 | 918 |
1067544 | 1067544 | 2021-02-26 | Jefferson | Kentucky | 21111 | 73885 | 916 |
1064299 | 1064299 | 2021-02-25 | Jefferson | Kentucky | 21111 | 73700 | 909 |
1061054 | 1061054 | 2021-02-24 | Jefferson | Kentucky | 21111 | 73488 | 902 |
1057808 | 1057808 | 2021-02-23 | Jefferson | Kentucky | 21111 | 73334 | 895 |
1054562 | 1054562 | 2021-02-22 | Jefferson | Kentucky | 21111 | 73173 | 888 |
1051315 | 1051315 | 2021-02-21 | Jefferson | Kentucky | 21111 | 73060 | 886 |
1048068 | 1048068 | 2021-02-20 | Jefferson | Kentucky | 21111 | 72916 | 884 |
1044823 | 1044823 | 2021-02-19 | Jefferson | Kentucky | 21111 | 72692 | 883 |
1041578 | 1041578 | 2021-02-18 | Jefferson | Kentucky | 21111 | 72316 | 882 |
1038333 | 1038333 | 2021-02-17 | Jefferson | Kentucky | 21111 | 72152 | 877 |
1035088 | 1035088 | 2021-02-16 | Jefferson | Kentucky | 21111 | 72010 | 871 |
1031842 | 1031842 | 2021-02-15 | Jefferson | Kentucky | 21111 | 72010 | 868 |
1028595 | 1028595 | 2021-02-14 | Jefferson | Kentucky | 21111 | 71860 | 867 |
1025350 | 1025350 | 2021-02-13 | Jefferson | Kentucky | 21111 | 71598 | 866 |
1022105 | 1022105 | 2021-02-12 | Jefferson | Kentucky | 21111 | 71511 | 857 |
1018860 | 1018860 | 2021-02-11 | Jefferson | Kentucky | 21111 | 71126 | 856 |
1015615 | 1015615 | 2021-02-10 | Jefferson | Kentucky | 21111 | 70796 | 851 |
1012370 | 1012370 | 2021-02-09 | Jefferson | Kentucky | 21111 | 70516 | 849 |
1009124 | 1009124 | 2021-02-08 | Jefferson | Kentucky | 21111 | 70058 | 845 |
1005878 | 1005878 | 2021-02-07 | Jefferson | Kentucky | 21111 | 69759 | 845 |
1002632 | 1002632 | 2021-02-06 | Jefferson | Kentucky | 21111 | 69691 | 844 |
999386 | 999386 | 2021-02-05 | Jefferson | Kentucky | 21111 | 69399 | 828 |
996140 | 996140 | 2021-02-04 | Jefferson | Kentucky | 21111 | 68861 | 825 |
992894 | 992894 | 2021-02-03 | Jefferson | Kentucky | 21111 | 68205 | 820 |
989648 | 989648 | 2021-02-02 | Jefferson | Kentucky | 21111 | 68205 | 815 |
986401 | 986401 | 2021-02-01 | Jefferson | Kentucky | 21111 | 67838 | 808 |
983154 | 983154 | 2021-01-31 | Jefferson | Kentucky | 21111 | 67578 | 808 |
979908 | 979908 | 2021-01-30 | Jefferson | Kentucky | 21111 | 67244 | 808 |
976662 | 976662 | 2021-01-29 | Jefferson | Kentucky | 21111 | 66657 | 794 |
973417 | 973417 | 2021-01-28 | Jefferson | Kentucky | 21111 | 66549 | 793 |
970172 | 970172 | 2021-01-27 | Jefferson | Kentucky | 21111 | 66104 | 788 |
966928 | 966928 | 2021-01-26 | Jefferson | Kentucky | 21111 | 65633 | 787 |
963683 | 963683 | 2021-01-25 | Jefferson | Kentucky | 21111 | 65226 | 773 |
960438 | 960438 | 2021-01-24 | Jefferson | Kentucky | 21111 | 64386 | 773 |
957192 | 957192 | 2021-01-23 | Jefferson | Kentucky | 21111 | 64311 | 770 |
953947 | 953947 | 2021-01-22 | Jefferson | Kentucky | 21111 | 63750 | 758 |
950702 | 950702 | 2021-01-21 | Jefferson | Kentucky | 21111 | 63192 | 754 |
947456 | 947456 | 2021-01-20 | Jefferson | Kentucky | 21111 | 62534 | 752 |
944209 | 944209 | 2021-01-19 | Jefferson | Kentucky | 21111 | 62115 | 747 |
940964 | 940964 | 2021-01-18 | Jefferson | Kentucky | 21111 | 61778 | 746 |
937719 | 937719 | 2021-01-17 | Jefferson | Kentucky | 21111 | 61424 | 746 |
934474 | 934474 | 2021-01-16 | Jefferson | Kentucky | 21111 | 61065 | 745 |
931229 | 931229 | 2021-01-15 | Jefferson | Kentucky | 21111 | 60457 | 740 |
927984 | 927984 | 2021-01-14 | Jefferson | Kentucky | 21111 | 59780 | 732 |
924738 | 924738 | 2021-01-13 | Jefferson | Kentucky | 21111 | 59234 | 729 |
921493 | 921493 | 2021-01-12 | Jefferson | Kentucky | 21111 | 58666 | 726 |
918248 | 918248 | 2021-01-11 | Jefferson | Kentucky | 21111 | 58281 | 719 |
915003 | 915003 | 2021-01-10 | Jefferson | Kentucky | 21111 | 57745 | 715 |
911758 | 911758 | 2021-01-09 | Jefferson | Kentucky | 21111 | 57201 | 715 |
908513 | 908513 | 2021-01-08 | Jefferson | Kentucky | 21111 | 56422 | 702 |
905267 | 905267 | 2021-01-07 | Jefferson | Kentucky | 21111 | 55958 | 694 |
902022 | 902022 | 2021-01-06 | Jefferson | Kentucky | 21111 | 55135 | 690 |
898777 | 898777 | 2021-01-05 | Jefferson | Kentucky | 21111 | 54541 | 679 |
895532 | 895532 | 2021-01-04 | Jefferson | Kentucky | 21111 | 54121 | 670 |
892285 | 892285 | 2021-01-03 | Jefferson | Kentucky | 21111 | 53647 | 658 |
889039 | 889039 | 2021-01-02 | Jefferson | Kentucky | 21111 | 53247 | 658 |
885793 | 885793 | 2021-01-01 | Jefferson | Kentucky | 21111 | 52883 | 658 |
882548 | 882548 | 2020-12-31 | Jefferson | Kentucky | 21111 | 52277 | 658 |
879303 | 879303 | 2020-12-30 | Jefferson | Kentucky | 21111 | 51652 | 649 |
876058 | 876058 | 2020-12-29 | Jefferson | Kentucky | 21111 | 51221 | 639 |
872813 | 872813 | 2020-12-28 | Jefferson | Kentucky | 21111 | 50823 | 635 |
869568 | 869568 | 2020-12-27 | Jefferson | Kentucky | 21111 | 50679 | 630 |
866323 | 866323 | 2020-12-26 | Jefferson | Kentucky | 21111 | 50460 | 630 |
863078 | 863078 | 2020-12-25 | Jefferson | Kentucky | 21111 | 50283 | 630 |
859833 | 859833 | 2020-12-24 | Jefferson | Kentucky | 21111 | 49900 | 628 |
856588 | 856588 | 2020-12-23 | Jefferson | Kentucky | 21111 | 49514 | 622 |
853343 | 853343 | 2020-12-22 | Jefferson | Kentucky | 21111 | 49153 | 617 |
850098 | 850098 | 2020-12-21 | Jefferson | Kentucky | 21111 | 48689 | 612 |
846853 | 846853 | 2020-12-20 | Jefferson | Kentucky | 21111 | 48228 | 612 |
843607 | 843607 | 2020-12-19 | Jefferson | Kentucky | 21111 | 47935 | 612 |
840362 | 840362 | 2020-12-18 | Jefferson | Kentucky | 21111 | 47639 | 610 |
837117 | 837117 | 2020-12-17 | Jefferson | Kentucky | 21111 | 47086 | 597 |
833871 | 833871 | 2020-12-16 | Jefferson | Kentucky | 21111 | 46791 | 593 |
830624 | 830624 | 2020-12-15 | Jefferson | Kentucky | 21111 | 46440 | 582 |
827378 | 827378 | 2020-12-14 | Jefferson | Kentucky | 21111 | 45974 | 578 |
824131 | 824131 | 2020-12-13 | Jefferson | Kentucky | 21111 | 45564 | 578 |
820885 | 820885 | 2020-12-12 | Jefferson | Kentucky | 21111 | 45006 | 578 |
817639 | 817639 | 2020-12-11 | Jefferson | Kentucky | 21111 | 44421 | 564 |
814393 | 814393 | 2020-12-10 | Jefferson | Kentucky | 21111 | 43771 | 553 |
811148 | 811148 | 2020-12-09 | Jefferson | Kentucky | 21111 | 42993 | 548 |
807903 | 807903 | 2020-12-08 | Jefferson | Kentucky | 21111 | 42795 | 539 |
804658 | 804658 | 2020-12-07 | Jefferson | Kentucky | 21111 | 42296 | 530 |
801413 | 801413 | 2020-12-06 | Jefferson | Kentucky | 21111 | 41964 | 530 |
798168 | 798168 | 2020-12-05 | Jefferson | Kentucky | 21111 | 41452 | 529 |
794923 | 794923 | 2020-12-04 | Jefferson | Kentucky | 21111 | 40908 | 524 |
791678 | 791678 | 2020-12-03 | Jefferson | Kentucky | 21111 | 40295 | 523 |
788433 | 788433 | 2020-12-02 | Jefferson | Kentucky | 21111 | 39683 | 511 |
785189 | 785189 | 2020-12-01 | Jefferson | Kentucky | 21111 | 39014 | 505 |
781944 | 781944 | 2020-11-30 | Jefferson | Kentucky | 21111 | 38452 | 500 |
778698 | 778698 | 2020-11-29 | Jefferson | Kentucky | 21111 | 38030 | 500 |
775453 | 775453 | 2020-11-28 | Jefferson | Kentucky | 21111 | 37614 | 499 |
772208 | 772208 | 2020-11-27 | Jefferson | Kentucky | 21111 | 36666 | 499 |
768963 | 768963 | 2020-11-26 | Jefferson | Kentucky | 21111 | 36218 | 499 |
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);