ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Lawrence" and fips = 21127 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054570 | 1054570 | 2021-02-22 | Lawrence | Kentucky | 21127 | 1202 | 18 |
1051323 | 1051323 | 2021-02-21 | Lawrence | Kentucky | 21127 | 1201 | 18 |
1048076 | 1048076 | 2021-02-20 | Lawrence | Kentucky | 21127 | 1198 | 17 |
1044831 | 1044831 | 2021-02-19 | Lawrence | Kentucky | 21127 | 1195 | 17 |
1041586 | 1041586 | 2021-02-18 | Lawrence | Kentucky | 21127 | 1193 | 17 |
1038341 | 1038341 | 2021-02-17 | Lawrence | Kentucky | 21127 | 1193 | 17 |
1035096 | 1035096 | 2021-02-16 | Lawrence | Kentucky | 21127 | 1187 | 17 |
1031850 | 1031850 | 2021-02-15 | Lawrence | Kentucky | 21127 | 1184 | 17 |
1028603 | 1028603 | 2021-02-14 | Lawrence | Kentucky | 21127 | 1184 | 17 |
1025358 | 1025358 | 2021-02-13 | Lawrence | Kentucky | 21127 | 1182 | 17 |
1022113 | 1022113 | 2021-02-12 | Lawrence | Kentucky | 21127 | 1183 | 17 |
1018868 | 1018868 | 2021-02-11 | Lawrence | Kentucky | 21127 | 1180 | 16 |
1015623 | 1015623 | 2021-02-10 | Lawrence | Kentucky | 21127 | 1174 | 14 |
1012378 | 1012378 | 2021-02-09 | Lawrence | Kentucky | 21127 | 1156 | 13 |
1009132 | 1009132 | 2021-02-08 | Lawrence | Kentucky | 21127 | 1140 | 13 |
1005886 | 1005886 | 2021-02-07 | Lawrence | Kentucky | 21127 | 1139 | 13 |
1002640 | 1002640 | 2021-02-06 | Lawrence | Kentucky | 21127 | 1135 | 12 |
999394 | 999394 | 2021-02-05 | Lawrence | Kentucky | 21127 | 1121 | 12 |
996148 | 996148 | 2021-02-04 | Lawrence | Kentucky | 21127 | 1114 | 12 |
992902 | 992902 | 2021-02-03 | Lawrence | Kentucky | 21127 | 1100 | 11 |
989656 | 989656 | 2021-02-02 | Lawrence | Kentucky | 21127 | 1089 | 11 |
986409 | 986409 | 2021-02-01 | Lawrence | Kentucky | 21127 | 1079 | 11 |
983162 | 983162 | 2021-01-31 | Lawrence | Kentucky | 21127 | 1080 | 10 |
979916 | 979916 | 2021-01-30 | Lawrence | Kentucky | 21127 | 1074 | 10 |
976670 | 976670 | 2021-01-29 | Lawrence | Kentucky | 21127 | 1062 | 10 |
973425 | 973425 | 2021-01-28 | Lawrence | Kentucky | 21127 | 1059 | 8 |
970180 | 970180 | 2021-01-27 | Lawrence | Kentucky | 21127 | 1054 | 8 |
966936 | 966936 | 2021-01-26 | Lawrence | Kentucky | 21127 | 1045 | 8 |
963691 | 963691 | 2021-01-25 | Lawrence | Kentucky | 21127 | 1038 | 8 |
960446 | 960446 | 2021-01-24 | Lawrence | Kentucky | 21127 | 1038 | 8 |
957200 | 957200 | 2021-01-23 | Lawrence | Kentucky | 21127 | 1031 | 8 |
953955 | 953955 | 2021-01-22 | Lawrence | Kentucky | 21127 | 1024 | 8 |
950710 | 950710 | 2021-01-21 | Lawrence | Kentucky | 21127 | 1021 | 5 |
947464 | 947464 | 2021-01-20 | Lawrence | Kentucky | 21127 | 1014 | 5 |
944217 | 944217 | 2021-01-19 | Lawrence | Kentucky | 21127 | 1001 | 5 |
940972 | 940972 | 2021-01-18 | Lawrence | Kentucky | 21127 | 999 | 5 |
937727 | 937727 | 2021-01-17 | Lawrence | Kentucky | 21127 | 997 | 5 |
934482 | 934482 | 2021-01-16 | Lawrence | Kentucky | 21127 | 993 | 5 |
931237 | 931237 | 2021-01-15 | Lawrence | Kentucky | 21127 | 987 | 5 |
927992 | 927992 | 2021-01-14 | Lawrence | Kentucky | 21127 | 977 | 5 |
924746 | 924746 | 2021-01-13 | Lawrence | Kentucky | 21127 | 964 | 5 |
921501 | 921501 | 2021-01-12 | Lawrence | Kentucky | 21127 | 947 | 5 |
918256 | 918256 | 2021-01-11 | Lawrence | Kentucky | 21127 | 932 | 5 |
915011 | 915011 | 2021-01-10 | Lawrence | Kentucky | 21127 | 932 | 5 |
911766 | 911766 | 2021-01-09 | Lawrence | Kentucky | 21127 | 925 | 5 |
908521 | 908521 | 2021-01-08 | Lawrence | Kentucky | 21127 | 911 | 5 |
905275 | 905275 | 2021-01-07 | Lawrence | Kentucky | 21127 | 906 | 5 |
902030 | 902030 | 2021-01-06 | Lawrence | Kentucky | 21127 | 894 | 5 |
898785 | 898785 | 2021-01-05 | Lawrence | Kentucky | 21127 | 876 | 5 |
895540 | 895540 | 2021-01-04 | Lawrence | Kentucky | 21127 | 846 | 5 |
892293 | 892293 | 2021-01-03 | Lawrence | Kentucky | 21127 | 837 | 5 |
889047 | 889047 | 2021-01-02 | Lawrence | Kentucky | 21127 | 825 | 5 |
885801 | 885801 | 2021-01-01 | Lawrence | Kentucky | 21127 | 758 | 5 |
882556 | 882556 | 2020-12-31 | Lawrence | Kentucky | 21127 | 758 | 5 |
879311 | 879311 | 2020-12-30 | Lawrence | Kentucky | 21127 | 758 | 5 |
876066 | 876066 | 2020-12-29 | Lawrence | Kentucky | 21127 | 731 | 4 |
872821 | 872821 | 2020-12-28 | Lawrence | Kentucky | 21127 | 690 | 4 |
869576 | 869576 | 2020-12-27 | Lawrence | Kentucky | 21127 | 690 | 4 |
866331 | 866331 | 2020-12-26 | Lawrence | Kentucky | 21127 | 679 | 4 |
863086 | 863086 | 2020-12-25 | Lawrence | Kentucky | 21127 | 641 | 4 |
859841 | 859841 | 2020-12-24 | Lawrence | Kentucky | 21127 | 641 | 4 |
856596 | 856596 | 2020-12-23 | Lawrence | Kentucky | 21127 | 641 | 4 |
853351 | 853351 | 2020-12-22 | Lawrence | Kentucky | 21127 | 629 | 4 |
850106 | 850106 | 2020-12-21 | Lawrence | Kentucky | 21127 | 623 | 4 |
846861 | 846861 | 2020-12-20 | Lawrence | Kentucky | 21127 | 618 | 4 |
843615 | 843615 | 2020-12-19 | Lawrence | Kentucky | 21127 | 613 | 4 |
840370 | 840370 | 2020-12-18 | Lawrence | Kentucky | 21127 | 601 | 4 |
837125 | 837125 | 2020-12-17 | Lawrence | Kentucky | 21127 | 592 | 4 |
833879 | 833879 | 2020-12-16 | Lawrence | Kentucky | 21127 | 576 | 4 |
830632 | 830632 | 2020-12-15 | Lawrence | Kentucky | 21127 | 564 | 4 |
827386 | 827386 | 2020-12-14 | Lawrence | Kentucky | 21127 | 557 | 4 |
824139 | 824139 | 2020-12-13 | Lawrence | Kentucky | 21127 | 557 | 3 |
820893 | 820893 | 2020-12-12 | Lawrence | Kentucky | 21127 | 549 | 2 |
817647 | 817647 | 2020-12-11 | Lawrence | Kentucky | 21127 | 541 | 2 |
814401 | 814401 | 2020-12-10 | Lawrence | Kentucky | 21127 | 530 | 2 |
811156 | 811156 | 2020-12-09 | Lawrence | Kentucky | 21127 | 515 | 2 |
807911 | 807911 | 2020-12-08 | Lawrence | Kentucky | 21127 | 511 | 2 |
804666 | 804666 | 2020-12-07 | Lawrence | Kentucky | 21127 | 499 | 2 |
801421 | 801421 | 2020-12-06 | Lawrence | Kentucky | 21127 | 495 | 2 |
798176 | 798176 | 2020-12-05 | Lawrence | Kentucky | 21127 | 478 | 2 |
794931 | 794931 | 2020-12-04 | Lawrence | Kentucky | 21127 | 464 | 2 |
791686 | 791686 | 2020-12-03 | Lawrence | Kentucky | 21127 | 448 | 1 |
788441 | 788441 | 2020-12-02 | Lawrence | Kentucky | 21127 | 434 | 1 |
785197 | 785197 | 2020-12-01 | Lawrence | Kentucky | 21127 | 418 | 1 |
781952 | 781952 | 2020-11-30 | Lawrence | Kentucky | 21127 | 396 | 1 |
778706 | 778706 | 2020-11-29 | Lawrence | Kentucky | 21127 | 392 | 1 |
775461 | 775461 | 2020-11-28 | Lawrence | Kentucky | 21127 | 386 | 1 |
772216 | 772216 | 2020-11-27 | Lawrence | Kentucky | 21127 | 381 | 1 |
768971 | 768971 | 2020-11-26 | Lawrence | Kentucky | 21127 | 362 | 1 |
765725 | 765725 | 2020-11-25 | Lawrence | Kentucky | 21127 | 362 | 1 |
762480 | 762480 | 2020-11-24 | Lawrence | Kentucky | 21127 | 357 | 1 |
759235 | 759235 | 2020-11-23 | Lawrence | Kentucky | 21127 | 349 | 1 |
755988 | 755988 | 2020-11-22 | Lawrence | Kentucky | 21127 | 345 | 1 |
752742 | 752742 | 2020-11-21 | Lawrence | Kentucky | 21127 | 339 | 1 |
749496 | 749496 | 2020-11-20 | Lawrence | Kentucky | 21127 | 331 | 1 |
746250 | 746250 | 2020-11-19 | Lawrence | Kentucky | 21127 | 313 | 1 |
743003 | 743003 | 2020-11-18 | Lawrence | Kentucky | 21127 | 299 | 1 |
739756 | 739756 | 2020-11-17 | Lawrence | Kentucky | 21127 | 286 | 1 |
736512 | 736512 | 2020-11-16 | Lawrence | Kentucky | 21127 | 273 | 1 |
733266 | 733266 | 2020-11-15 | Lawrence | Kentucky | 21127 | 268 | 1 |
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);