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 |
---|---|---|---|---|---|---|---|
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 |
730021 | 730021 | 2020-11-14 | Lawrence | Kentucky | 21127 | 264 | 1 |
726778 | 726778 | 2020-11-13 | Lawrence | Kentucky | 21127 | 248 | 1 |
723535 | 723535 | 2020-11-12 | Lawrence | Kentucky | 21127 | 238 | 1 |
720292 | 720292 | 2020-11-11 | Lawrence | Kentucky | 21127 | 233 | 1 |
717049 | 717049 | 2020-11-10 | Lawrence | Kentucky | 21127 | 216 | 0 |
713805 | 713805 | 2020-11-09 | Lawrence | Kentucky | 21127 | 208 | 0 |
710561 | 710561 | 2020-11-08 | Lawrence | Kentucky | 21127 | 195 | 0 |
707317 | 707317 | 2020-11-07 | Lawrence | Kentucky | 21127 | 192 | 0 |
704074 | 704074 | 2020-11-06 | Lawrence | Kentucky | 21127 | 188 | 0 |
700832 | 700832 | 2020-11-05 | Lawrence | Kentucky | 21127 | 179 | 0 |
697588 | 697588 | 2020-11-04 | Lawrence | Kentucky | 21127 | 179 | 0 |
694345 | 694345 | 2020-11-03 | Lawrence | Kentucky | 21127 | 178 | 0 |
691103 | 691103 | 2020-11-02 | Lawrence | Kentucky | 21127 | 175 | 0 |
687858 | 687858 | 2020-11-01 | Lawrence | Kentucky | 21127 | 175 | 0 |
684614 | 684614 | 2020-10-31 | Lawrence | Kentucky | 21127 | 171 | 0 |
681371 | 681371 | 2020-10-30 | Lawrence | Kentucky | 21127 | 161 | 0 |
678127 | 678127 | 2020-10-29 | Lawrence | Kentucky | 21127 | 157 | 0 |
674885 | 674885 | 2020-10-28 | Lawrence | Kentucky | 21127 | 157 | 0 |
671642 | 671642 | 2020-10-27 | Lawrence | Kentucky | 21127 | 153 | 0 |
668400 | 668400 | 2020-10-26 | Lawrence | Kentucky | 21127 | 147 | 0 |
665156 | 665156 | 2020-10-25 | Lawrence | Kentucky | 21127 | 144 | 0 |
661911 | 661911 | 2020-10-24 | Lawrence | Kentucky | 21127 | 141 | 0 |
658667 | 658667 | 2020-10-23 | Lawrence | Kentucky | 21127 | 137 | 0 |
655422 | 655422 | 2020-10-22 | Lawrence | Kentucky | 21127 | 137 | 0 |
652177 | 652177 | 2020-10-21 | Lawrence | Kentucky | 21127 | 131 | 0 |
648932 | 648932 | 2020-10-20 | Lawrence | Kentucky | 21127 | 126 | 0 |
645688 | 645688 | 2020-10-19 | Lawrence | Kentucky | 21127 | 119 | 0 |
642441 | 642441 | 2020-10-18 | Lawrence | Kentucky | 21127 | 119 | 0 |
639194 | 639194 | 2020-10-17 | Lawrence | Kentucky | 21127 | 116 | 0 |
635948 | 635948 | 2020-10-16 | Lawrence | Kentucky | 21127 | 115 | 0 |
632702 | 632702 | 2020-10-15 | Lawrence | Kentucky | 21127 | 110 | 0 |
629458 | 629458 | 2020-10-14 | Lawrence | Kentucky | 21127 | 108 | 0 |
626214 | 626214 | 2020-10-13 | Lawrence | Kentucky | 21127 | 90 | 0 |
622972 | 622972 | 2020-10-12 | Lawrence | Kentucky | 21127 | 88 | 0 |
619728 | 619728 | 2020-10-11 | Lawrence | Kentucky | 21127 | 86 | 0 |
616486 | 616486 | 2020-10-10 | Lawrence | Kentucky | 21127 | 80 | 0 |
613245 | 613245 | 2020-10-09 | Lawrence | Kentucky | 21127 | 78 | 0 |
610003 | 610003 | 2020-10-08 | Lawrence | Kentucky | 21127 | 77 | 0 |
606761 | 606761 | 2020-10-07 | Lawrence | Kentucky | 21127 | 73 | 0 |
603519 | 603519 | 2020-10-06 | Lawrence | Kentucky | 21127 | 70 | 0 |
600276 | 600276 | 2020-10-05 | Lawrence | Kentucky | 21127 | 67 | 0 |
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);