ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 1115 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174252 | 2174252 | 2022-02-02 | St. Clair | Alabama | 1115 | 24128 | 379 |
2171000 | 2171000 | 2022-02-01 | St. Clair | Alabama | 1115 | 24025 | 379 |
2167747 | 2167747 | 2022-01-31 | St. Clair | Alabama | 1115 | 23910 | 376 |
2164492 | 2164492 | 2022-01-30 | St. Clair | Alabama | 1115 | 23820 | 376 |
2161237 | 2161237 | 2022-01-29 | St. Clair | Alabama | 1115 | 23722 | 376 |
2157981 | 2157981 | 2022-01-28 | St. Clair | Alabama | 1115 | 22910 | 372 |
2154728 | 2154728 | 2022-01-27 | St. Clair | Alabama | 1115 | 22910 | 372 |
2151475 | 2151475 | 2022-01-26 | St. Clair | Alabama | 1115 | 22910 | 372 |
2148223 | 2148223 | 2022-01-25 | St. Clair | Alabama | 1115 | 22910 | 372 |
2144971 | 2144971 | 2022-01-24 | St. Clair | Alabama | 1115 | 22910 | 372 |
2141716 | 2141716 | 2022-01-23 | St. Clair | Alabama | 1115 | 22804 | 372 |
2138460 | 2138460 | 2022-01-22 | St. Clair | Alabama | 1115 | 22644 | 372 |
2135205 | 2135205 | 2022-01-21 | St. Clair | Alabama | 1115 | 22356 | 372 |
2131953 | 2131953 | 2022-01-20 | St. Clair | Alabama | 1115 | 22075 | 372 |
2128699 | 2128699 | 2022-01-19 | St. Clair | Alabama | 1115 | 21730 | 371 |
2125446 | 2125446 | 2022-01-18 | St. Clair | Alabama | 1115 | 21363 | 370 |
2122194 | 2122194 | 2022-01-17 | St. Clair | Alabama | 1115 | 21245 | 370 |
2118942 | 2118942 | 2022-01-16 | St. Clair | Alabama | 1115 | 21115 | 370 |
2115690 | 2115690 | 2022-01-15 | St. Clair | Alabama | 1115 | 20037 | 367 |
2112438 | 2112438 | 2022-01-14 | St. Clair | Alabama | 1115 | 20037 | 367 |
2109186 | 2109186 | 2022-01-13 | St. Clair | Alabama | 1115 | 20037 | 367 |
2105935 | 2105935 | 2022-01-12 | St. Clair | Alabama | 1115 | 20037 | 367 |
2102684 | 2102684 | 2022-01-11 | St. Clair | Alabama | 1115 | 19792 | 367 |
2099433 | 2099433 | 2022-01-10 | St. Clair | Alabama | 1115 | 19537 | 367 |
2096182 | 2096182 | 2022-01-09 | St. Clair | Alabama | 1115 | 19419 | 367 |
2092930 | 2092930 | 2022-01-08 | St. Clair | Alabama | 1115 | 19184 | 367 |
2089678 | 2089678 | 2022-01-07 | St. Clair | Alabama | 1115 | 19012 | 367 |
2086427 | 2086427 | 2022-01-06 | St. Clair | Alabama | 1115 | 18805 | 367 |
2083175 | 2083175 | 2022-01-05 | St. Clair | Alabama | 1115 | 18540 | 367 |
2079923 | 2079923 | 2022-01-04 | St. Clair | Alabama | 1115 | 18327 | 366 |
2076671 | 2076671 | 2022-01-03 | St. Clair | Alabama | 1115 | 18107 | 365 |
2073420 | 2073420 | 2022-01-02 | St. Clair | Alabama | 1115 | 18043 | 365 |
2070169 | 2070169 | 2022-01-01 | St. Clair | Alabama | 1115 | 17891 | 365 |
2066918 | 2066918 | 2021-12-31 | St. Clair | Alabama | 1115 | 17891 | 365 |
2063668 | 2063668 | 2021-12-30 | St. Clair | Alabama | 1115 | 17766 | 365 |
2060418 | 2060418 | 2021-12-29 | St. Clair | Alabama | 1115 | 17608 | 365 |
2057169 | 2057169 | 2021-12-28 | St. Clair | Alabama | 1115 | 17517 | 365 |
2053920 | 2053920 | 2021-12-27 | St. Clair | Alabama | 1115 | 17433 | 365 |
2050670 | 2050670 | 2021-12-26 | St. Clair | Alabama | 1115 | 17401 | 365 |
2047420 | 2047420 | 2021-12-25 | St. Clair | Alabama | 1115 | 17392 | 365 |
2044170 | 2044170 | 2021-12-24 | St. Clair | Alabama | 1115 | 17338 | 365 |
2040921 | 2040921 | 2021-12-23 | St. Clair | Alabama | 1115 | 17289 | 365 |
2037671 | 2037671 | 2021-12-22 | St. Clair | Alabama | 1115 | 17258 | 365 |
2034421 | 2034421 | 2021-12-21 | St. Clair | Alabama | 1115 | 17232 | 364 |
2031171 | 2031171 | 2021-12-20 | St. Clair | Alabama | 1115 | 17211 | 364 |
2027920 | 2027920 | 2021-12-19 | St. Clair | Alabama | 1115 | 17202 | 364 |
2024669 | 2024669 | 2021-12-18 | St. Clair | Alabama | 1115 | 17193 | 364 |
2021418 | 2021418 | 2021-12-17 | St. Clair | Alabama | 1115 | 17177 | 364 |
2018167 | 2018167 | 2021-12-16 | St. Clair | Alabama | 1115 | 17148 | 364 |
2014917 | 2014917 | 2021-12-15 | St. Clair | Alabama | 1115 | 17129 | 363 |
2011666 | 2011666 | 2021-12-14 | St. Clair | Alabama | 1115 | 17105 | 361 |
2008415 | 2008415 | 2021-12-13 | St. Clair | Alabama | 1115 | 17064 | 361 |
2005164 | 2005164 | 2021-12-12 | St. Clair | Alabama | 1115 | 17054 | 361 |
2001913 | 2001913 | 2021-12-11 | St. Clair | Alabama | 1115 | 17046 | 361 |
1998663 | 1998663 | 2021-12-10 | St. Clair | Alabama | 1115 | 17027 | 360 |
1995412 | 1995412 | 2021-12-09 | St. Clair | Alabama | 1115 | 17017 | 359 |
1992161 | 1992161 | 2021-12-08 | St. Clair | Alabama | 1115 | 16995 | 359 |
1988910 | 1988910 | 2021-12-07 | St. Clair | Alabama | 1115 | 16987 | 359 |
1985660 | 1985660 | 2021-12-06 | St. Clair | Alabama | 1115 | 16968 | 359 |
1982410 | 1982410 | 2021-12-05 | St. Clair | Alabama | 1115 | 16963 | 359 |
1979160 | 1979160 | 2021-12-04 | St. Clair | Alabama | 1115 | 16958 | 359 |
1975910 | 1975910 | 2021-12-03 | St. Clair | Alabama | 1115 | 16946 | 359 |
1972661 | 1972661 | 2021-12-02 | St. Clair | Alabama | 1115 | 16928 | 358 |
1969411 | 1969411 | 2021-12-01 | St. Clair | Alabama | 1115 | 16918 | 358 |
1966161 | 1966161 | 2021-11-30 | St. Clair | Alabama | 1115 | 16904 | 358 |
1962909 | 1962909 | 2021-11-29 | St. Clair | Alabama | 1115 | 16884 | 358 |
1959658 | 1959658 | 2021-11-28 | St. Clair | Alabama | 1115 | 16880 | 358 |
1956407 | 1956407 | 2021-11-27 | St. Clair | Alabama | 1115 | 16875 | 358 |
1953156 | 1953156 | 2021-11-26 | St. Clair | Alabama | 1115 | 16863 | 358 |
1949905 | 1949905 | 2021-11-25 | St. Clair | Alabama | 1115 | 16863 | 358 |
1946654 | 1946654 | 2021-11-24 | St. Clair | Alabama | 1115 | 16854 | 358 |
1943403 | 1943403 | 2021-11-23 | St. Clair | Alabama | 1115 | 16851 | 357 |
1940153 | 1940153 | 2021-11-22 | St. Clair | Alabama | 1115 | 16832 | 355 |
1936903 | 1936903 | 2021-11-21 | St. Clair | Alabama | 1115 | 16826 | 355 |
1933653 | 1933653 | 2021-11-20 | St. Clair | Alabama | 1115 | 16820 | 355 |
1930401 | 1930401 | 2021-11-19 | St. Clair | Alabama | 1115 | 16832 | 355 |
1927151 | 1927151 | 2021-11-18 | St. Clair | Alabama | 1115 | 16819 | 354 |
1923901 | 1923901 | 2021-11-17 | St. Clair | Alabama | 1115 | 16807 | 354 |
1920652 | 1920652 | 2021-11-16 | St. Clair | Alabama | 1115 | 16795 | 354 |
1917402 | 1917402 | 2021-11-15 | St. Clair | Alabama | 1115 | 16779 | 353 |
1914152 | 1914152 | 2021-11-14 | St. Clair | Alabama | 1115 | 16772 | 353 |
1910902 | 1910902 | 2021-11-13 | St. Clair | Alabama | 1115 | 16763 | 353 |
1907653 | 1907653 | 2021-11-12 | St. Clair | Alabama | 1115 | 16752 | 350 |
1904404 | 1904404 | 2021-11-11 | St. Clair | Alabama | 1115 | 16744 | 350 |
1901154 | 1901154 | 2021-11-10 | St. Clair | Alabama | 1115 | 16782 | 350 |
1897904 | 1897904 | 2021-11-09 | St. Clair | Alabama | 1115 | 16780 | 349 |
1894654 | 1894654 | 2021-11-08 | St. Clair | Alabama | 1115 | 16752 | 349 |
1891404 | 1891404 | 2021-11-07 | St. Clair | Alabama | 1115 | 16746 | 349 |
1888154 | 1888154 | 2021-11-06 | St. Clair | Alabama | 1115 | 16736 | 349 |
1884904 | 1884904 | 2021-11-05 | St. Clair | Alabama | 1115 | 16731 | 349 |
1881655 | 1881655 | 2021-11-04 | St. Clair | Alabama | 1115 | 16711 | 348 |
1878406 | 1878406 | 2021-11-03 | St. Clair | Alabama | 1115 | 16691 | 348 |
1875157 | 1875157 | 2021-11-02 | St. Clair | Alabama | 1115 | 16683 | 348 |
1871908 | 1871908 | 2021-11-01 | St. Clair | Alabama | 1115 | 16670 | 344 |
1868659 | 1868659 | 2021-10-31 | St. Clair | Alabama | 1115 | 16669 | 344 |
1865410 | 1865410 | 2021-10-30 | St. Clair | Alabama | 1115 | 16659 | 344 |
1862161 | 1862161 | 2021-10-29 | St. Clair | Alabama | 1115 | 16650 | 340 |
1858912 | 1858912 | 2021-10-28 | St. Clair | Alabama | 1115 | 16642 | 339 |
1855663 | 1855663 | 2021-10-27 | St. Clair | Alabama | 1115 | 16601 | 339 |
1852414 | 1852414 | 2021-10-26 | St. Clair | Alabama | 1115 | 16091 | 339 |
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);