ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 1127 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174257 | 2174257 | 2022-02-02 | Walker | Alabama | 1127 | 17677 | 398 |
2171005 | 2171005 | 2022-02-01 | Walker | Alabama | 1127 | 17620 | 397 |
2167752 | 2167752 | 2022-01-31 | Walker | Alabama | 1127 | 17395 | 395 |
2164497 | 2164497 | 2022-01-30 | Walker | Alabama | 1127 | 17272 | 395 |
2161242 | 2161242 | 2022-01-29 | Walker | Alabama | 1127 | 17075 | 395 |
2157986 | 2157986 | 2022-01-28 | Walker | Alabama | 1127 | 15805 | 392 |
2154733 | 2154733 | 2022-01-27 | Walker | Alabama | 1127 | 15805 | 392 |
2151480 | 2151480 | 2022-01-26 | Walker | Alabama | 1127 | 15805 | 392 |
2148228 | 2148228 | 2022-01-25 | Walker | Alabama | 1127 | 15805 | 392 |
2144976 | 2144976 | 2022-01-24 | Walker | Alabama | 1127 | 15805 | 392 |
2141721 | 2141721 | 2022-01-23 | Walker | Alabama | 1127 | 15687 | 392 |
2138465 | 2138465 | 2022-01-22 | Walker | Alabama | 1127 | 15540 | 392 |
2135210 | 2135210 | 2022-01-21 | Walker | Alabama | 1127 | 15206 | 392 |
2131958 | 2131958 | 2022-01-20 | Walker | Alabama | 1127 | 14984 | 392 |
2128704 | 2128704 | 2022-01-19 | Walker | Alabama | 1127 | 14726 | 392 |
2125451 | 2125451 | 2022-01-18 | Walker | Alabama | 1127 | 14304 | 392 |
2122199 | 2122199 | 2022-01-17 | Walker | Alabama | 1127 | 14154 | 392 |
2118947 | 2118947 | 2022-01-16 | Walker | Alabama | 1127 | 14076 | 392 |
2115695 | 2115695 | 2022-01-15 | Walker | Alabama | 1127 | 13579 | 392 |
2112443 | 2112443 | 2022-01-14 | Walker | Alabama | 1127 | 13579 | 392 |
2109191 | 2109191 | 2022-01-13 | Walker | Alabama | 1127 | 13579 | 392 |
2105940 | 2105940 | 2022-01-12 | Walker | Alabama | 1127 | 13579 | 392 |
2102689 | 2102689 | 2022-01-11 | Walker | Alabama | 1127 | 13484 | 392 |
2099438 | 2099438 | 2022-01-10 | Walker | Alabama | 1127 | 13397 | 392 |
2096187 | 2096187 | 2022-01-09 | Walker | Alabama | 1127 | 13365 | 392 |
2092935 | 2092935 | 2022-01-08 | Walker | Alabama | 1127 | 13256 | 392 |
2089683 | 2089683 | 2022-01-07 | Walker | Alabama | 1127 | 13196 | 391 |
2086432 | 2086432 | 2022-01-06 | Walker | Alabama | 1127 | 13075 | 391 |
2083180 | 2083180 | 2022-01-05 | Walker | Alabama | 1127 | 12930 | 390 |
2079928 | 2079928 | 2022-01-04 | Walker | Alabama | 1127 | 12861 | 390 |
2076676 | 2076676 | 2022-01-03 | Walker | Alabama | 1127 | 12791 | 388 |
2073425 | 2073425 | 2022-01-02 | Walker | Alabama | 1127 | 12757 | 388 |
2070174 | 2070174 | 2022-01-01 | Walker | Alabama | 1127 | 12635 | 388 |
2066923 | 2066923 | 2021-12-31 | Walker | Alabama | 1127 | 12635 | 388 |
2063673 | 2063673 | 2021-12-30 | Walker | Alabama | 1127 | 12588 | 388 |
2060423 | 2060423 | 2021-12-29 | Walker | Alabama | 1127 | 12542 | 388 |
2057174 | 2057174 | 2021-12-28 | Walker | Alabama | 1127 | 12511 | 388 |
2053925 | 2053925 | 2021-12-27 | Walker | Alabama | 1127 | 12484 | 388 |
2050675 | 2050675 | 2021-12-26 | Walker | Alabama | 1127 | 12478 | 388 |
2047425 | 2047425 | 2021-12-25 | Walker | Alabama | 1127 | 12473 | 388 |
2044175 | 2044175 | 2021-12-24 | Walker | Alabama | 1127 | 12457 | 388 |
2040926 | 2040926 | 2021-12-23 | Walker | Alabama | 1127 | 12441 | 388 |
2037676 | 2037676 | 2021-12-22 | Walker | Alabama | 1127 | 12426 | 388 |
2034426 | 2034426 | 2021-12-21 | Walker | Alabama | 1127 | 12410 | 388 |
2031176 | 2031176 | 2021-12-20 | Walker | Alabama | 1127 | 12381 | 387 |
2027925 | 2027925 | 2021-12-19 | Walker | Alabama | 1127 | 12375 | 387 |
2024674 | 2024674 | 2021-12-18 | Walker | Alabama | 1127 | 12363 | 387 |
2021423 | 2021423 | 2021-12-17 | Walker | Alabama | 1127 | 12347 | 386 |
2018172 | 2018172 | 2021-12-16 | Walker | Alabama | 1127 | 12342 | 386 |
2014922 | 2014922 | 2021-12-15 | Walker | Alabama | 1127 | 12322 | 386 |
2011671 | 2011671 | 2021-12-14 | Walker | Alabama | 1127 | 12304 | 386 |
2008420 | 2008420 | 2021-12-13 | Walker | Alabama | 1127 | 12292 | 386 |
2005169 | 2005169 | 2021-12-12 | Walker | Alabama | 1127 | 12286 | 386 |
2001918 | 2001918 | 2021-12-11 | Walker | Alabama | 1127 | 12272 | 386 |
1998668 | 1998668 | 2021-12-10 | Walker | Alabama | 1127 | 12258 | 383 |
1995417 | 1995417 | 2021-12-09 | Walker | Alabama | 1127 | 12245 | 380 |
1992166 | 1992166 | 2021-12-08 | Walker | Alabama | 1127 | 12223 | 380 |
1988915 | 1988915 | 2021-12-07 | Walker | Alabama | 1127 | 12202 | 380 |
1985665 | 1985665 | 2021-12-06 | Walker | Alabama | 1127 | 12180 | 380 |
1982415 | 1982415 | 2021-12-05 | Walker | Alabama | 1127 | 12170 | 380 |
1979165 | 1979165 | 2021-12-04 | Walker | Alabama | 1127 | 12168 | 380 |
1975915 | 1975915 | 2021-12-03 | Walker | Alabama | 1127 | 12138 | 380 |
1972666 | 1972666 | 2021-12-02 | Walker | Alabama | 1127 | 12119 | 380 |
1969416 | 1969416 | 2021-12-01 | Walker | Alabama | 1127 | 12081 | 380 |
1966166 | 1966166 | 2021-11-30 | Walker | Alabama | 1127 | 12067 | 380 |
1962914 | 1962914 | 2021-11-29 | Walker | Alabama | 1127 | 12030 | 380 |
1959663 | 1959663 | 2021-11-28 | Walker | Alabama | 1127 | 12029 | 380 |
1956412 | 1956412 | 2021-11-27 | Walker | Alabama | 1127 | 12020 | 380 |
1953161 | 1953161 | 2021-11-26 | Walker | Alabama | 1127 | 12011 | 380 |
1949910 | 1949910 | 2021-11-25 | Walker | Alabama | 1127 | 12011 | 380 |
1946659 | 1946659 | 2021-11-24 | Walker | Alabama | 1127 | 11992 | 380 |
1943408 | 1943408 | 2021-11-23 | Walker | Alabama | 1127 | 11978 | 379 |
1940158 | 1940158 | 2021-11-22 | Walker | Alabama | 1127 | 11956 | 379 |
1936908 | 1936908 | 2021-11-21 | Walker | Alabama | 1127 | 11949 | 379 |
1933658 | 1933658 | 2021-11-20 | Walker | Alabama | 1127 | 11943 | 379 |
1930406 | 1930406 | 2021-11-19 | Walker | Alabama | 1127 | 11928 | 379 |
1927156 | 1927156 | 2021-11-18 | Walker | Alabama | 1127 | 11916 | 378 |
1923906 | 1923906 | 2021-11-17 | Walker | Alabama | 1127 | 11890 | 377 |
1920657 | 1920657 | 2021-11-16 | Walker | Alabama | 1127 | 11883 | 377 |
1917407 | 1917407 | 2021-11-15 | Walker | Alabama | 1127 | 11850 | 377 |
1914157 | 1914157 | 2021-11-14 | Walker | Alabama | 1127 | 11847 | 377 |
1910907 | 1910907 | 2021-11-13 | Walker | Alabama | 1127 | 11836 | 377 |
1907658 | 1907658 | 2021-11-12 | Walker | Alabama | 1127 | 11824 | 376 |
1904409 | 1904409 | 2021-11-11 | Walker | Alabama | 1127 | 11808 | 376 |
1901159 | 1901159 | 2021-11-10 | Walker | Alabama | 1127 | 11781 | 376 |
1897909 | 1897909 | 2021-11-09 | Walker | Alabama | 1127 | 11770 | 376 |
1894659 | 1894659 | 2021-11-08 | Walker | Alabama | 1127 | 11658 | 375 |
1891409 | 1891409 | 2021-11-07 | Walker | Alabama | 1127 | 11638 | 375 |
1888159 | 1888159 | 2021-11-06 | Walker | Alabama | 1127 | 11623 | 375 |
1884909 | 1884909 | 2021-11-05 | Walker | Alabama | 1127 | 11608 | 375 |
1881660 | 1881660 | 2021-11-04 | Walker | Alabama | 1127 | 11591 | 375 |
1878411 | 1878411 | 2021-11-03 | Walker | Alabama | 1127 | 11502 | 372 |
1875162 | 1875162 | 2021-11-02 | Walker | Alabama | 1127 | 11477 | 371 |
1871913 | 1871913 | 2021-11-01 | Walker | Alabama | 1127 | 11450 | 371 |
1868664 | 1868664 | 2021-10-31 | Walker | Alabama | 1127 | 11443 | 371 |
1865415 | 1865415 | 2021-10-30 | Walker | Alabama | 1127 | 11435 | 371 |
1862166 | 1862166 | 2021-10-29 | Walker | Alabama | 1127 | 11423 | 370 |
1858917 | 1858917 | 2021-10-28 | Walker | Alabama | 1127 | 11391 | 370 |
1855668 | 1855668 | 2021-10-27 | Walker | Alabama | 1127 | 11351 | 370 |
1852419 | 1852419 | 2021-10-26 | Walker | Alabama | 1127 | 11255 | 370 |
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);