ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 1117 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174251 | 2174251 | 2022-02-02 | Shelby | Alabama | 1117 | 56816 | 402 |
2170999 | 2170999 | 2022-02-01 | Shelby | Alabama | 1117 | 56605 | 401 |
2167746 | 2167746 | 2022-01-31 | Shelby | Alabama | 1117 | 56338 | 397 |
2164491 | 2164491 | 2022-01-30 | Shelby | Alabama | 1117 | 56043 | 397 |
2161236 | 2161236 | 2022-01-29 | Shelby | Alabama | 1117 | 55747 | 397 |
2157980 | 2157980 | 2022-01-28 | Shelby | Alabama | 1117 | 53229 | 394 |
2154727 | 2154727 | 2022-01-27 | Shelby | Alabama | 1117 | 53229 | 394 |
2151474 | 2151474 | 2022-01-26 | Shelby | Alabama | 1117 | 53229 | 394 |
2148222 | 2148222 | 2022-01-25 | Shelby | Alabama | 1117 | 53229 | 394 |
2144970 | 2144970 | 2022-01-24 | Shelby | Alabama | 1117 | 53229 | 394 |
2141715 | 2141715 | 2022-01-23 | Shelby | Alabama | 1117 | 52906 | 394 |
2138459 | 2138459 | 2022-01-22 | Shelby | Alabama | 1117 | 52479 | 394 |
2135204 | 2135204 | 2022-01-21 | Shelby | Alabama | 1117 | 51659 | 394 |
2131952 | 2131952 | 2022-01-20 | Shelby | Alabama | 1117 | 50904 | 390 |
2128698 | 2128698 | 2022-01-19 | Shelby | Alabama | 1117 | 50124 | 389 |
2125445 | 2125445 | 2022-01-18 | Shelby | Alabama | 1117 | 49328 | 388 |
2122193 | 2122193 | 2022-01-17 | Shelby | Alabama | 1117 | 49000 | 388 |
2118941 | 2118941 | 2022-01-16 | Shelby | Alabama | 1117 | 48566 | 388 |
2115689 | 2115689 | 2022-01-15 | Shelby | Alabama | 1117 | 46249 | 383 |
2112437 | 2112437 | 2022-01-14 | Shelby | Alabama | 1117 | 46249 | 383 |
2109185 | 2109185 | 2022-01-13 | Shelby | Alabama | 1117 | 46249 | 383 |
2105934 | 2105934 | 2022-01-12 | Shelby | Alabama | 1117 | 46249 | 383 |
2102683 | 2102683 | 2022-01-11 | Shelby | Alabama | 1117 | 45723 | 383 |
2099432 | 2099432 | 2022-01-10 | Shelby | Alabama | 1117 | 45367 | 383 |
2096181 | 2096181 | 2022-01-09 | Shelby | Alabama | 1117 | 45064 | 383 |
2092929 | 2092929 | 2022-01-08 | Shelby | Alabama | 1117 | 44475 | 383 |
2089677 | 2089677 | 2022-01-07 | Shelby | Alabama | 1117 | 44077 | 383 |
2086426 | 2086426 | 2022-01-06 | Shelby | Alabama | 1117 | 43602 | 381 |
2083174 | 2083174 | 2022-01-05 | Shelby | Alabama | 1117 | 43006 | 381 |
2079922 | 2079922 | 2022-01-04 | Shelby | Alabama | 1117 | 42492 | 381 |
2076670 | 2076670 | 2022-01-03 | Shelby | Alabama | 1117 | 42193 | 381 |
2073419 | 2073419 | 2022-01-02 | Shelby | Alabama | 1117 | 41944 | 381 |
2070168 | 2070168 | 2022-01-01 | Shelby | Alabama | 1117 | 41228 | 381 |
2066917 | 2066917 | 2021-12-31 | Shelby | Alabama | 1117 | 41228 | 381 |
2063667 | 2063667 | 2021-12-30 | Shelby | Alabama | 1117 | 40799 | 381 |
2060417 | 2060417 | 2021-12-29 | Shelby | Alabama | 1117 | 40346 | 381 |
2057168 | 2057168 | 2021-12-28 | Shelby | Alabama | 1117 | 40007 | 380 |
2053919 | 2053919 | 2021-12-27 | Shelby | Alabama | 1117 | 39755 | 379 |
2050669 | 2050669 | 2021-12-26 | Shelby | Alabama | 1117 | 39664 | 379 |
2047419 | 2047419 | 2021-12-25 | Shelby | Alabama | 1117 | 39618 | 379 |
2044169 | 2044169 | 2021-12-24 | Shelby | Alabama | 1117 | 39451 | 379 |
2040920 | 2040920 | 2021-12-23 | Shelby | Alabama | 1117 | 39294 | 379 |
2037670 | 2037670 | 2021-12-22 | Shelby | Alabama | 1117 | 39137 | 378 |
2034420 | 2034420 | 2021-12-21 | Shelby | Alabama | 1117 | 39051 | 378 |
2031170 | 2031170 | 2021-12-20 | Shelby | Alabama | 1117 | 38982 | 378 |
2027919 | 2027919 | 2021-12-19 | Shelby | Alabama | 1117 | 38921 | 378 |
2024668 | 2024668 | 2021-12-18 | Shelby | Alabama | 1117 | 38889 | 378 |
2021417 | 2021417 | 2021-12-17 | Shelby | Alabama | 1117 | 38857 | 378 |
2018166 | 2018166 | 2021-12-16 | Shelby | Alabama | 1117 | 38794 | 378 |
2014916 | 2014916 | 2021-12-15 | Shelby | Alabama | 1117 | 38752 | 377 |
2011665 | 2011665 | 2021-12-14 | Shelby | Alabama | 1117 | 38733 | 375 |
2008414 | 2008414 | 2021-12-13 | Shelby | Alabama | 1117 | 38637 | 375 |
2005163 | 2005163 | 2021-12-12 | Shelby | Alabama | 1117 | 38615 | 375 |
2001912 | 2001912 | 2021-12-11 | Shelby | Alabama | 1117 | 38593 | 375 |
1998662 | 1998662 | 2021-12-10 | Shelby | Alabama | 1117 | 38558 | 373 |
1995411 | 1995411 | 2021-12-09 | Shelby | Alabama | 1117 | 38530 | 373 |
1992160 | 1992160 | 2021-12-08 | Shelby | Alabama | 1117 | 38507 | 373 |
1988909 | 1988909 | 2021-12-07 | Shelby | Alabama | 1117 | 38474 | 373 |
1985659 | 1985659 | 2021-12-06 | Shelby | Alabama | 1117 | 38454 | 371 |
1982409 | 1982409 | 2021-12-05 | Shelby | Alabama | 1117 | 38446 | 371 |
1979159 | 1979159 | 2021-12-04 | Shelby | Alabama | 1117 | 38435 | 371 |
1975909 | 1975909 | 2021-12-03 | Shelby | Alabama | 1117 | 38413 | 371 |
1972660 | 1972660 | 2021-12-02 | Shelby | Alabama | 1117 | 38395 | 371 |
1969410 | 1969410 | 2021-12-01 | Shelby | Alabama | 1117 | 38372 | 371 |
1966160 | 1966160 | 2021-11-30 | Shelby | Alabama | 1117 | 38351 | 369 |
1962908 | 1962908 | 2021-11-29 | Shelby | Alabama | 1117 | 38338 | 368 |
1959657 | 1959657 | 2021-11-28 | Shelby | Alabama | 1117 | 38328 | 368 |
1956406 | 1956406 | 2021-11-27 | Shelby | Alabama | 1117 | 38325 | 368 |
1953155 | 1953155 | 2021-11-26 | Shelby | Alabama | 1117 | 38313 | 368 |
1949904 | 1949904 | 2021-11-25 | Shelby | Alabama | 1117 | 38313 | 368 |
1946653 | 1946653 | 2021-11-24 | Shelby | Alabama | 1117 | 38310 | 368 |
1943402 | 1943402 | 2021-11-23 | Shelby | Alabama | 1117 | 38281 | 368 |
1940152 | 1940152 | 2021-11-22 | Shelby | Alabama | 1117 | 38275 | 368 |
1936902 | 1936902 | 2021-11-21 | Shelby | Alabama | 1117 | 38255 | 368 |
1933652 | 1933652 | 2021-11-20 | Shelby | Alabama | 1117 | 38242 | 368 |
1930400 | 1930400 | 2021-11-19 | Shelby | Alabama | 1117 | 38202 | 367 |
1927150 | 1927150 | 2021-11-18 | Shelby | Alabama | 1117 | 38189 | 365 |
1923900 | 1923900 | 2021-11-17 | Shelby | Alabama | 1117 | 38153 | 365 |
1920651 | 1920651 | 2021-11-16 | Shelby | Alabama | 1117 | 38122 | 365 |
1917401 | 1917401 | 2021-11-15 | Shelby | Alabama | 1117 | 38101 | 365 |
1914151 | 1914151 | 2021-11-14 | Shelby | Alabama | 1117 | 38094 | 365 |
1910901 | 1910901 | 2021-11-13 | Shelby | Alabama | 1117 | 38082 | 365 |
1907652 | 1907652 | 2021-11-12 | Shelby | Alabama | 1117 | 38084 | 362 |
1904403 | 1904403 | 2021-11-11 | Shelby | Alabama | 1117 | 38050 | 362 |
1901153 | 1901153 | 2021-11-10 | Shelby | Alabama | 1117 | 38042 | 362 |
1897903 | 1897903 | 2021-11-09 | Shelby | Alabama | 1117 | 38045 | 361 |
1894653 | 1894653 | 2021-11-08 | Shelby | Alabama | 1117 | 38006 | 361 |
1891403 | 1891403 | 2021-11-07 | Shelby | Alabama | 1117 | 37995 | 361 |
1888153 | 1888153 | 2021-11-06 | Shelby | Alabama | 1117 | 37972 | 361 |
1884903 | 1884903 | 2021-11-05 | Shelby | Alabama | 1117 | 37978 | 362 |
1881654 | 1881654 | 2021-11-04 | Shelby | Alabama | 1117 | 37956 | 359 |
1878405 | 1878405 | 2021-11-03 | Shelby | Alabama | 1117 | 37929 | 358 |
1875156 | 1875156 | 2021-11-02 | Shelby | Alabama | 1117 | 37914 | 358 |
1871907 | 1871907 | 2021-11-01 | Shelby | Alabama | 1117 | 37905 | 359 |
1868658 | 1868658 | 2021-10-31 | Shelby | Alabama | 1117 | 37885 | 359 |
1865409 | 1865409 | 2021-10-30 | Shelby | Alabama | 1117 | 37867 | 359 |
1862160 | 1862160 | 2021-10-29 | Shelby | Alabama | 1117 | 37837 | 355 |
1858911 | 1858911 | 2021-10-28 | Shelby | Alabama | 1117 | 37832 | 353 |
1855662 | 1855662 | 2021-10-27 | Shelby | Alabama | 1117 | 37787 | 350 |
1852413 | 1852413 | 2021-10-26 | Shelby | Alabama | 1117 | 37685 | 350 |
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);