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 |
---|---|---|---|---|---|---|---|
2174233 | 2174233 | 2022-02-02 | Lawrence | Alabama | 1079 | 7158 | 144 |
2170981 | 2170981 | 2022-02-01 | Lawrence | Alabama | 1079 | 7126 | 143 |
2167728 | 2167728 | 2022-01-31 | Lawrence | Alabama | 1079 | 7088 | 143 |
2164473 | 2164473 | 2022-01-30 | Lawrence | Alabama | 1079 | 7062 | 143 |
2161218 | 2161218 | 2022-01-29 | Lawrence | Alabama | 1079 | 7022 | 143 |
2157962 | 2157962 | 2022-01-28 | Lawrence | Alabama | 1079 | 6648 | 140 |
2154709 | 2154709 | 2022-01-27 | Lawrence | Alabama | 1079 | 6648 | 140 |
2151456 | 2151456 | 2022-01-26 | Lawrence | Alabama | 1079 | 6648 | 140 |
2148204 | 2148204 | 2022-01-25 | Lawrence | Alabama | 1079 | 6648 | 140 |
2144952 | 2144952 | 2022-01-24 | Lawrence | Alabama | 1079 | 6648 | 140 |
2141697 | 2141697 | 2022-01-23 | Lawrence | Alabama | 1079 | 6611 | 140 |
2138441 | 2138441 | 2022-01-22 | Lawrence | Alabama | 1079 | 6549 | 140 |
2135186 | 2135186 | 2022-01-21 | Lawrence | Alabama | 1079 | 6421 | 140 |
2131934 | 2131934 | 2022-01-20 | Lawrence | Alabama | 1079 | 6294 | 140 |
2128680 | 2128680 | 2022-01-19 | Lawrence | Alabama | 1079 | 6103 | 140 |
2125427 | 2125427 | 2022-01-18 | Lawrence | Alabama | 1079 | 5959 | 140 |
2122175 | 2122175 | 2022-01-17 | Lawrence | Alabama | 1079 | 5934 | 140 |
2118923 | 2118923 | 2022-01-16 | Lawrence | Alabama | 1079 | 5873 | 140 |
2115671 | 2115671 | 2022-01-15 | Lawrence | Alabama | 1079 | 5522 | 138 |
2112419 | 2112419 | 2022-01-14 | Lawrence | Alabama | 1079 | 5522 | 138 |
2109167 | 2109167 | 2022-01-13 | Lawrence | Alabama | 1079 | 5522 | 138 |
2105916 | 2105916 | 2022-01-12 | Lawrence | Alabama | 1079 | 5522 | 138 |
2102665 | 2102665 | 2022-01-11 | Lawrence | Alabama | 1079 | 5490 | 138 |
2099414 | 2099414 | 2022-01-10 | Lawrence | Alabama | 1079 | 5458 | 138 |
2096163 | 2096163 | 2022-01-09 | Lawrence | Alabama | 1079 | 5432 | 138 |
2092911 | 2092911 | 2022-01-08 | Lawrence | Alabama | 1079 | 5385 | 138 |
2089659 | 2089659 | 2022-01-07 | Lawrence | Alabama | 1079 | 5354 | 138 |
2086408 | 2086408 | 2022-01-06 | Lawrence | Alabama | 1079 | 5295 | 136 |
2083156 | 2083156 | 2022-01-05 | Lawrence | Alabama | 1079 | 5231 | 136 |
2079904 | 2079904 | 2022-01-04 | Lawrence | Alabama | 1079 | 5174 | 136 |
2076652 | 2076652 | 2022-01-03 | Lawrence | Alabama | 1079 | 5145 | 136 |
2073401 | 2073401 | 2022-01-02 | Lawrence | Alabama | 1079 | 5130 | 136 |
2070150 | 2070150 | 2022-01-01 | Lawrence | Alabama | 1079 | 5071 | 136 |
2066899 | 2066899 | 2021-12-31 | Lawrence | Alabama | 1079 | 5071 | 136 |
2063649 | 2063649 | 2021-12-30 | Lawrence | Alabama | 1079 | 5046 | 136 |
2060399 | 2060399 | 2021-12-29 | Lawrence | Alabama | 1079 | 5009 | 136 |
2057150 | 2057150 | 2021-12-28 | Lawrence | Alabama | 1079 | 4976 | 135 |
2053901 | 2053901 | 2021-12-27 | Lawrence | Alabama | 1079 | 4964 | 135 |
2050651 | 2050651 | 2021-12-26 | Lawrence | Alabama | 1079 | 4959 | 135 |
2047401 | 2047401 | 2021-12-25 | Lawrence | Alabama | 1079 | 4955 | 135 |
2044151 | 2044151 | 2021-12-24 | Lawrence | Alabama | 1079 | 4944 | 135 |
2040902 | 2040902 | 2021-12-23 | Lawrence | Alabama | 1079 | 4934 | 134 |
2037652 | 2037652 | 2021-12-22 | Lawrence | Alabama | 1079 | 4930 | 134 |
2034402 | 2034402 | 2021-12-21 | Lawrence | Alabama | 1079 | 4922 | 133 |
2031152 | 2031152 | 2021-12-20 | Lawrence | Alabama | 1079 | 4915 | 133 |
2027901 | 2027901 | 2021-12-19 | Lawrence | Alabama | 1079 | 4913 | 133 |
2024650 | 2024650 | 2021-12-18 | Lawrence | Alabama | 1079 | 4910 | 133 |
2021399 | 2021399 | 2021-12-17 | Lawrence | Alabama | 1079 | 4908 | 133 |
2018148 | 2018148 | 2021-12-16 | Lawrence | Alabama | 1079 | 4900 | 133 |
2014898 | 2014898 | 2021-12-15 | Lawrence | Alabama | 1079 | 4895 | 131 |
2011647 | 2011647 | 2021-12-14 | Lawrence | Alabama | 1079 | 4892 | 130 |
2008396 | 2008396 | 2021-12-13 | Lawrence | Alabama | 1079 | 4886 | 130 |
2005145 | 2005145 | 2021-12-12 | Lawrence | Alabama | 1079 | 4886 | 130 |
2001894 | 2001894 | 2021-12-11 | Lawrence | Alabama | 1079 | 4882 | 130 |
1998644 | 1998644 | 2021-12-10 | Lawrence | Alabama | 1079 | 4877 | 130 |
1995393 | 1995393 | 2021-12-09 | Lawrence | Alabama | 1079 | 4868 | 130 |
1992142 | 1992142 | 2021-12-08 | Lawrence | Alabama | 1079 | 4863 | 130 |
1988891 | 1988891 | 2021-12-07 | Lawrence | Alabama | 1079 | 4857 | 130 |
1985641 | 1985641 | 2021-12-06 | Lawrence | Alabama | 1079 | 4852 | 130 |
1982391 | 1982391 | 2021-12-05 | Lawrence | Alabama | 1079 | 4852 | 130 |
1979141 | 1979141 | 2021-12-04 | Lawrence | Alabama | 1079 | 4850 | 130 |
1975891 | 1975891 | 2021-12-03 | Lawrence | Alabama | 1079 | 4845 | 130 |
1972642 | 1972642 | 2021-12-02 | Lawrence | Alabama | 1079 | 4841 | 130 |
1969392 | 1969392 | 2021-12-01 | Lawrence | Alabama | 1079 | 4836 | 130 |
1966142 | 1966142 | 2021-11-30 | Lawrence | Alabama | 1079 | 4831 | 129 |
1962890 | 1962890 | 2021-11-29 | Lawrence | Alabama | 1079 | 4826 | 129 |
1959639 | 1959639 | 2021-11-28 | Lawrence | Alabama | 1079 | 4826 | 129 |
1956388 | 1956388 | 2021-11-27 | Lawrence | Alabama | 1079 | 4826 | 129 |
1953137 | 1953137 | 2021-11-26 | Lawrence | Alabama | 1079 | 4826 | 129 |
1949886 | 1949886 | 2021-11-25 | Lawrence | Alabama | 1079 | 4826 | 129 |
1946635 | 1946635 | 2021-11-24 | Lawrence | Alabama | 1079 | 4819 | 127 |
1943384 | 1943384 | 2021-11-23 | Lawrence | Alabama | 1079 | 4806 | 127 |
1940134 | 1940134 | 2021-11-22 | Lawrence | Alabama | 1079 | 4790 | 127 |
1936884 | 1936884 | 2021-11-21 | Lawrence | Alabama | 1079 | 4785 | 127 |
1933634 | 1933634 | 2021-11-20 | Lawrence | Alabama | 1079 | 4784 | 127 |
1930382 | 1930382 | 2021-11-19 | Lawrence | Alabama | 1079 | 4780 | 127 |
1927132 | 1927132 | 2021-11-18 | Lawrence | Alabama | 1079 | 4748 | 127 |
1923882 | 1923882 | 2021-11-17 | Lawrence | Alabama | 1079 | 4735 | 126 |
1920633 | 1920633 | 2021-11-16 | Lawrence | Alabama | 1079 | 4727 | 126 |
1917383 | 1917383 | 2021-11-15 | Lawrence | Alabama | 1079 | 4721 | 126 |
1914133 | 1914133 | 2021-11-14 | Lawrence | Alabama | 1079 | 4720 | 126 |
1910883 | 1910883 | 2021-11-13 | Lawrence | Alabama | 1079 | 4718 | 126 |
1907634 | 1907634 | 2021-11-12 | Lawrence | Alabama | 1079 | 4708 | 125 |
1904385 | 1904385 | 2021-11-11 | Lawrence | Alabama | 1079 | 4703 | 125 |
1901135 | 1901135 | 2021-11-10 | Lawrence | Alabama | 1079 | 4696 | 125 |
1897885 | 1897885 | 2021-11-09 | Lawrence | Alabama | 1079 | 4690 | 123 |
1894635 | 1894635 | 2021-11-08 | Lawrence | Alabama | 1079 | 4668 | 121 |
1891385 | 1891385 | 2021-11-07 | Lawrence | Alabama | 1079 | 4665 | 121 |
1888135 | 1888135 | 2021-11-06 | Lawrence | Alabama | 1079 | 4662 | 121 |
1884885 | 1884885 | 2021-11-05 | Lawrence | Alabama | 1079 | 4641 | 121 |
1881636 | 1881636 | 2021-11-04 | Lawrence | Alabama | 1079 | 4629 | 120 |
1878387 | 1878387 | 2021-11-03 | Lawrence | Alabama | 1079 | 4613 | 120 |
1875138 | 1875138 | 2021-11-02 | Lawrence | Alabama | 1079 | 4596 | 118 |
1871889 | 1871889 | 2021-11-01 | Lawrence | Alabama | 1079 | 4574 | 118 |
1868640 | 1868640 | 2021-10-31 | Lawrence | Alabama | 1079 | 4572 | 118 |
1865391 | 1865391 | 2021-10-30 | Lawrence | Alabama | 1079 | 4571 | 118 |
1862142 | 1862142 | 2021-10-29 | Lawrence | Alabama | 1079 | 4562 | 117 |
1858893 | 1858893 | 2021-10-28 | Lawrence | Alabama | 1079 | 4558 | 117 |
1855644 | 1855644 | 2021-10-27 | Lawrence | Alabama | 1079 | 4533 | 117 |
1852395 | 1852395 | 2021-10-26 | Lawrence | Alabama | 1079 | 4352 | 117 |
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);