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 |
---|---|---|---|---|---|---|---|
1079509 | 1079509 | 2021-03-02 | Lawrence | Alabama | 1079 | 2836 | 84 |
1076264 | 1076264 | 2021-03-01 | Lawrence | Alabama | 1079 | 2834 | 84 |
1073018 | 1073018 | 2021-02-28 | Lawrence | Alabama | 1079 | 2829 | 84 |
1069772 | 1069772 | 2021-02-27 | Lawrence | Alabama | 1079 | 2826 | 84 |
1066527 | 1066527 | 2021-02-26 | Lawrence | Alabama | 1079 | 2822 | 84 |
1063282 | 1063282 | 2021-02-25 | Lawrence | Alabama | 1079 | 2813 | 84 |
1060037 | 1060037 | 2021-02-24 | Lawrence | Alabama | 1079 | 2812 | 84 |
1056791 | 1056791 | 2021-02-23 | Lawrence | Alabama | 1079 | 2806 | 85 |
1053545 | 1053545 | 2021-02-22 | Lawrence | Alabama | 1079 | 2798 | 85 |
1050298 | 1050298 | 2021-02-21 | Lawrence | Alabama | 1079 | 2795 | 85 |
1047051 | 1047051 | 2021-02-20 | Lawrence | Alabama | 1079 | 2794 | 85 |
1043806 | 1043806 | 2021-02-19 | Lawrence | Alabama | 1079 | 2790 | 85 |
1040561 | 1040561 | 2021-02-18 | Lawrence | Alabama | 1079 | 2787 | 85 |
1037316 | 1037316 | 2021-02-17 | Lawrence | Alabama | 1079 | 2781 | 85 |
1034071 | 1034071 | 2021-02-16 | Lawrence | Alabama | 1079 | 2781 | 84 |
1030825 | 1030825 | 2021-02-15 | Lawrence | Alabama | 1079 | 2780 | 84 |
1027578 | 1027578 | 2021-02-14 | Lawrence | Alabama | 1079 | 2777 | 84 |
1024333 | 1024333 | 2021-02-13 | Lawrence | Alabama | 1079 | 2771 | 84 |
1021088 | 1021088 | 2021-02-12 | Lawrence | Alabama | 1079 | 2762 | 84 |
1017843 | 1017843 | 2021-02-11 | Lawrence | Alabama | 1079 | 2755 | 83 |
1014598 | 1014598 | 2021-02-10 | Lawrence | Alabama | 1079 | 2746 | 83 |
1011353 | 1011353 | 2021-02-09 | Lawrence | Alabama | 1079 | 2734 | 79 |
1008107 | 1008107 | 2021-02-08 | Lawrence | Alabama | 1079 | 2729 | 78 |
1004861 | 1004861 | 2021-02-07 | Lawrence | Alabama | 1079 | 2723 | 78 |
1001615 | 1001615 | 2021-02-06 | Lawrence | Alabama | 1079 | 2717 | 78 |
998369 | 998369 | 2021-02-05 | Lawrence | Alabama | 1079 | 2708 | 78 |
995123 | 995123 | 2021-02-04 | Lawrence | Alabama | 1079 | 2699 | 77 |
991877 | 991877 | 2021-02-03 | Lawrence | Alabama | 1079 | 2682 | 76 |
988631 | 988631 | 2021-02-02 | Lawrence | Alabama | 1079 | 2665 | 73 |
985384 | 985384 | 2021-02-01 | Lawrence | Alabama | 1079 | 2654 | 70 |
982137 | 982137 | 2021-01-31 | Lawrence | Alabama | 1079 | 2647 | 70 |
978891 | 978891 | 2021-01-30 | Lawrence | Alabama | 1079 | 2628 | 69 |
975646 | 975646 | 2021-01-29 | Lawrence | Alabama | 1079 | 2628 | 69 |
972401 | 972401 | 2021-01-28 | Lawrence | Alabama | 1079 | 2616 | 61 |
969156 | 969156 | 2021-01-27 | Lawrence | Alabama | 1079 | 2597 | 59 |
965912 | 965912 | 2021-01-26 | Lawrence | Alabama | 1079 | 2569 | 58 |
962667 | 962667 | 2021-01-25 | Lawrence | Alabama | 1079 | 2558 | 55 |
959422 | 959422 | 2021-01-24 | Lawrence | Alabama | 1079 | 2541 | 55 |
956176 | 956176 | 2021-01-23 | Lawrence | Alabama | 1079 | 2533 | 55 |
952931 | 952931 | 2021-01-22 | Lawrence | Alabama | 1079 | 2507 | 52 |
949686 | 949686 | 2021-01-21 | Lawrence | Alabama | 1079 | 2491 | 50 |
946440 | 946440 | 2021-01-20 | Lawrence | Alabama | 1079 | 2466 | 49 |
943193 | 943193 | 2021-01-19 | Lawrence | Alabama | 1079 | 2452 | 47 |
939948 | 939948 | 2021-01-18 | Lawrence | Alabama | 1079 | 2442 | 47 |
936703 | 936703 | 2021-01-17 | Lawrence | Alabama | 1079 | 2436 | 47 |
933458 | 933458 | 2021-01-16 | Lawrence | Alabama | 1079 | 2425 | 47 |
930213 | 930213 | 2021-01-15 | Lawrence | Alabama | 1079 | 2404 | 47 |
926968 | 926968 | 2021-01-14 | Lawrence | Alabama | 1079 | 2393 | 45 |
923722 | 923722 | 2021-01-13 | Lawrence | Alabama | 1079 | 2368 | 45 |
920477 | 920477 | 2021-01-12 | Lawrence | Alabama | 1079 | 2351 | 45 |
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 |
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);