ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Lawrence" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917232 | 917232 | 2021-01-11 | Lawrence | Alabama | 1079 | 2340 | 44 |
913987 | 913987 | 2021-01-10 | Lawrence | Alabama | 1079 | 2324 | 44 |
910742 | 910742 | 2021-01-09 | Lawrence | Alabama | 1079 | 2315 | 44 |
907497 | 907497 | 2021-01-08 | Lawrence | Alabama | 1079 | 2263 | 44 |
904251 | 904251 | 2021-01-07 | Lawrence | Alabama | 1079 | 2217 | 44 |
901006 | 901006 | 2021-01-06 | Lawrence | Alabama | 1079 | 2181 | 44 |
897761 | 897761 | 2021-01-05 | Lawrence | Alabama | 1079 | 2149 | 43 |
894515 | 894515 | 2021-01-04 | Lawrence | Alabama | 1079 | 2128 | 43 |
891269 | 891269 | 2021-01-03 | Lawrence | Alabama | 1079 | 2115 | 43 |
888022 | 888022 | 2021-01-02 | Lawrence | Alabama | 1079 | 2102 | 43 |
884777 | 884777 | 2021-01-01 | Lawrence | Alabama | 1079 | 2082 | 43 |
881532 | 881532 | 2020-12-31 | Lawrence | Alabama | 1079 | 2044 | 42 |
878287 | 878287 | 2020-12-30 | Lawrence | Alabama | 1079 | 2005 | 42 |
875042 | 875042 | 2020-12-29 | Lawrence | Alabama | 1079 | 1978 | 42 |
871797 | 871797 | 2020-12-28 | Lawrence | Alabama | 1079 | 1958 | 42 |
868552 | 868552 | 2020-12-27 | Lawrence | Alabama | 1079 | 1939 | 42 |
865307 | 865307 | 2020-12-26 | Lawrence | Alabama | 1079 | 1924 | 42 |
862062 | 862062 | 2020-12-25 | Lawrence | Alabama | 1079 | 1921 | 42 |
858817 | 858817 | 2020-12-24 | Lawrence | Alabama | 1079 | 1907 | 42 |
855572 | 855572 | 2020-12-23 | Lawrence | Alabama | 1079 | 1859 | 41 |
852327 | 852327 | 2020-12-22 | Lawrence | Alabama | 1079 | 1819 | 40 |
849082 | 849082 | 2020-12-21 | Lawrence | Alabama | 1079 | 1783 | 40 |
845837 | 845837 | 2020-12-20 | Lawrence | Alabama | 1079 | 1757 | 40 |
842591 | 842591 | 2020-12-19 | Lawrence | Alabama | 1079 | 1739 | 40 |
839346 | 839346 | 2020-12-18 | Lawrence | Alabama | 1079 | 1708 | 39 |
836101 | 836101 | 2020-12-17 | Lawrence | Alabama | 1079 | 1672 | 37 |
832855 | 832855 | 2020-12-16 | Lawrence | Alabama | 1079 | 1635 | 37 |
829608 | 829608 | 2020-12-15 | Lawrence | Alabama | 1079 | 1617 | 37 |
826362 | 826362 | 2020-12-14 | Lawrence | Alabama | 1079 | 1596 | 37 |
823115 | 823115 | 2020-12-13 | Lawrence | Alabama | 1079 | 1585 | 37 |
819869 | 819869 | 2020-12-12 | Lawrence | Alabama | 1079 | 1569 | 37 |
816623 | 816623 | 2020-12-11 | Lawrence | Alabama | 1079 | 1541 | 36 |
813377 | 813377 | 2020-12-10 | Lawrence | Alabama | 1079 | 1525 | 36 |
810133 | 810133 | 2020-12-09 | Lawrence | Alabama | 1079 | 1480 | 36 |
806888 | 806888 | 2020-12-08 | Lawrence | Alabama | 1079 | 1453 | 36 |
803643 | 803643 | 2020-12-07 | Lawrence | Alabama | 1079 | 1431 | 36 |
800398 | 800398 | 2020-12-06 | Lawrence | Alabama | 1079 | 1422 | 36 |
797153 | 797153 | 2020-12-05 | Lawrence | Alabama | 1079 | 1421 | 36 |
793908 | 793908 | 2020-12-04 | Lawrence | Alabama | 1079 | 1399 | 36 |
790663 | 790663 | 2020-12-03 | Lawrence | Alabama | 1079 | 1373 | 36 |
787418 | 787418 | 2020-12-02 | Lawrence | Alabama | 1079 | 1353 | 36 |
784174 | 784174 | 2020-12-01 | Lawrence | Alabama | 1079 | 1334 | 36 |
780929 | 780929 | 2020-11-30 | Lawrence | Alabama | 1079 | 1316 | 36 |
777683 | 777683 | 2020-11-29 | Lawrence | Alabama | 1079 | 1296 | 36 |
774438 | 774438 | 2020-11-28 | Lawrence | Alabama | 1079 | 1279 | 36 |
771193 | 771193 | 2020-11-27 | Lawrence | Alabama | 1079 | 1273 | 36 |
767947 | 767947 | 2020-11-26 | Lawrence | Alabama | 1079 | 1263 | 36 |
764702 | 764702 | 2020-11-25 | Lawrence | Alabama | 1079 | 1248 | 36 |
761457 | 761457 | 2020-11-24 | Lawrence | Alabama | 1079 | 1239 | 36 |
758212 | 758212 | 2020-11-23 | Lawrence | Alabama | 1079 | 1224 | 36 |
754965 | 754965 | 2020-11-22 | Lawrence | Alabama | 1079 | 1214 | 36 |
751719 | 751719 | 2020-11-21 | Lawrence | Alabama | 1079 | 1201 | 36 |
748473 | 748473 | 2020-11-20 | Lawrence | Alabama | 1079 | 1179 | 36 |
745227 | 745227 | 2020-11-19 | Lawrence | Alabama | 1079 | 1152 | 35 |
741980 | 741980 | 2020-11-18 | Lawrence | Alabama | 1079 | 1124 | 35 |
738733 | 738733 | 2020-11-17 | Lawrence | Alabama | 1079 | 1098 | 35 |
735489 | 735489 | 2020-11-16 | Lawrence | Alabama | 1079 | 1080 | 35 |
732243 | 732243 | 2020-11-15 | Lawrence | Alabama | 1079 | 1076 | 35 |
728998 | 728998 | 2020-11-14 | Lawrence | Alabama | 1079 | 1071 | 35 |
725755 | 725755 | 2020-11-13 | Lawrence | Alabama | 1079 | 1050 | 35 |
722512 | 722512 | 2020-11-12 | Lawrence | Alabama | 1079 | 1037 | 35 |
719269 | 719269 | 2020-11-11 | Lawrence | Alabama | 1079 | 1028 | 35 |
716026 | 716026 | 2020-11-10 | Lawrence | Alabama | 1079 | 1014 | 35 |
712782 | 712782 | 2020-11-09 | Lawrence | Alabama | 1079 | 1007 | 35 |
709538 | 709538 | 2020-11-08 | Lawrence | Alabama | 1079 | 1003 | 35 |
706294 | 706294 | 2020-11-07 | Lawrence | Alabama | 1079 | 995 | 35 |
703051 | 703051 | 2020-11-06 | Lawrence | Alabama | 1079 | 983 | 34 |
699808 | 699808 | 2020-11-05 | Lawrence | Alabama | 1079 | 977 | 34 |
696564 | 696564 | 2020-11-04 | Lawrence | Alabama | 1079 | 968 | 34 |
693322 | 693322 | 2020-11-03 | Lawrence | Alabama | 1079 | 958 | 33 |
690079 | 690079 | 2020-11-02 | Lawrence | Alabama | 1079 | 946 | 33 |
686834 | 686834 | 2020-11-01 | Lawrence | Alabama | 1079 | 941 | 33 |
683590 | 683590 | 2020-10-31 | Lawrence | Alabama | 1079 | 916 | 33 |
680347 | 680347 | 2020-10-30 | Lawrence | Alabama | 1079 | 899 | 33 |
677104 | 677104 | 2020-10-29 | Lawrence | Alabama | 1079 | 885 | 33 |
673861 | 673861 | 2020-10-28 | Lawrence | Alabama | 1079 | 877 | 33 |
670619 | 670619 | 2020-10-27 | Lawrence | Alabama | 1079 | 869 | 33 |
667376 | 667376 | 2020-10-26 | Lawrence | Alabama | 1079 | 861 | 32 |
664131 | 664131 | 2020-10-25 | Lawrence | Alabama | 1079 | 858 | 32 |
660887 | 660887 | 2020-10-24 | Lawrence | Alabama | 1079 | 850 | 32 |
657643 | 657643 | 2020-10-23 | Lawrence | Alabama | 1079 | 837 | 32 |
654398 | 654398 | 2020-10-22 | Lawrence | Alabama | 1079 | 821 | 31 |
651153 | 651153 | 2020-10-21 | Lawrence | Alabama | 1079 | 811 | 31 |
647909 | 647909 | 2020-10-20 | Lawrence | Alabama | 1079 | 800 | 31 |
644664 | 644664 | 2020-10-19 | Lawrence | Alabama | 1079 | 792 | 30 |
641416 | 641416 | 2020-10-18 | Lawrence | Alabama | 1079 | 788 | 30 |
638169 | 638169 | 2020-10-17 | Lawrence | Alabama | 1079 | 782 | 30 |
634924 | 634924 | 2020-10-16 | Lawrence | Alabama | 1079 | 772 | 30 |
631679 | 631679 | 2020-10-15 | Lawrence | Alabama | 1079 | 759 | 30 |
628435 | 628435 | 2020-10-14 | Lawrence | Alabama | 1079 | 748 | 28 |
625192 | 625192 | 2020-10-13 | Lawrence | Alabama | 1079 | 741 | 28 |
621949 | 621949 | 2020-10-12 | Lawrence | Alabama | 1079 | 729 | 28 |
618706 | 618706 | 2020-10-11 | Lawrence | Alabama | 1079 | 716 | 28 |
615464 | 615464 | 2020-10-10 | Lawrence | Alabama | 1079 | 711 | 28 |
612223 | 612223 | 2020-10-09 | Lawrence | Alabama | 1079 | 699 | 26 |
608981 | 608981 | 2020-10-08 | Lawrence | Alabama | 1079 | 689 | 26 |
605738 | 605738 | 2020-10-07 | Lawrence | Alabama | 1079 | 685 | 26 |
602496 | 602496 | 2020-10-06 | Lawrence | Alabama | 1079 | 676 | 26 |
599253 | 599253 | 2020-10-05 | Lawrence | Alabama | 1079 | 662 | 26 |
596010 | 596010 | 2020-10-04 | Lawrence | Alabama | 1079 | 652 | 26 |
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);