ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Clay" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174207 | 2174207 | 2022-02-02 | Clay | Alabama | 1027 | 3932 | 72 |
2170955 | 2170955 | 2022-02-01 | Clay | Alabama | 1027 | 3919 | 72 |
2167702 | 2167702 | 2022-01-31 | Clay | Alabama | 1027 | 3902 | 72 |
2164447 | 2164447 | 2022-01-30 | Clay | Alabama | 1027 | 3881 | 72 |
2161192 | 2161192 | 2022-01-29 | Clay | Alabama | 1027 | 3869 | 72 |
2157936 | 2157936 | 2022-01-28 | Clay | Alabama | 1027 | 3620 | 71 |
2154683 | 2154683 | 2022-01-27 | Clay | Alabama | 1027 | 3620 | 71 |
2151430 | 2151430 | 2022-01-26 | Clay | Alabama | 1027 | 3620 | 71 |
2148178 | 2148178 | 2022-01-25 | Clay | Alabama | 1027 | 3620 | 71 |
2144926 | 2144926 | 2022-01-24 | Clay | Alabama | 1027 | 3620 | 71 |
2141671 | 2141671 | 2022-01-23 | Clay | Alabama | 1027 | 3604 | 71 |
2138415 | 2138415 | 2022-01-22 | Clay | Alabama | 1027 | 3567 | 71 |
2135160 | 2135160 | 2022-01-21 | Clay | Alabama | 1027 | 3499 | 71 |
2131908 | 2131908 | 2022-01-20 | Clay | Alabama | 1027 | 3442 | 70 |
2128654 | 2128654 | 2022-01-19 | Clay | Alabama | 1027 | 3358 | 70 |
2125401 | 2125401 | 2022-01-18 | Clay | Alabama | 1027 | 3258 | 70 |
2122149 | 2122149 | 2022-01-17 | Clay | Alabama | 1027 | 3207 | 70 |
2118897 | 2118897 | 2022-01-16 | Clay | Alabama | 1027 | 3193 | 70 |
2115645 | 2115645 | 2022-01-15 | Clay | Alabama | 1027 | 3002 | 70 |
2112393 | 2112393 | 2022-01-14 | Clay | Alabama | 1027 | 3002 | 70 |
2109141 | 2109141 | 2022-01-13 | Clay | Alabama | 1027 | 3002 | 70 |
2105890 | 2105890 | 2022-01-12 | Clay | Alabama | 1027 | 3002 | 70 |
2102639 | 2102639 | 2022-01-11 | Clay | Alabama | 1027 | 2950 | 70 |
2099388 | 2099388 | 2022-01-10 | Clay | Alabama | 1027 | 2910 | 70 |
2096137 | 2096137 | 2022-01-09 | Clay | Alabama | 1027 | 2901 | 70 |
2092885 | 2092885 | 2022-01-08 | Clay | Alabama | 1027 | 2846 | 70 |
2089633 | 2089633 | 2022-01-07 | Clay | Alabama | 1027 | 2834 | 69 |
2086382 | 2086382 | 2022-01-06 | Clay | Alabama | 1027 | 2801 | 69 |
2083130 | 2083130 | 2022-01-05 | Clay | Alabama | 1027 | 2756 | 69 |
2079878 | 2079878 | 2022-01-04 | Clay | Alabama | 1027 | 2723 | 69 |
2076626 | 2076626 | 2022-01-03 | Clay | Alabama | 1027 | 2690 | 69 |
2073375 | 2073375 | 2022-01-02 | Clay | Alabama | 1027 | 2687 | 69 |
2070124 | 2070124 | 2022-01-01 | Clay | Alabama | 1027 | 2658 | 69 |
2066873 | 2066873 | 2021-12-31 | Clay | Alabama | 1027 | 2658 | 69 |
2063623 | 2063623 | 2021-12-30 | Clay | Alabama | 1027 | 2633 | 69 |
2060373 | 2060373 | 2021-12-29 | Clay | Alabama | 1027 | 2610 | 69 |
2057124 | 2057124 | 2021-12-28 | Clay | Alabama | 1027 | 2602 | 69 |
2053875 | 2053875 | 2021-12-27 | Clay | Alabama | 1027 | 2584 | 69 |
2050625 | 2050625 | 2021-12-26 | Clay | Alabama | 1027 | 2575 | 69 |
2047375 | 2047375 | 2021-12-25 | Clay | Alabama | 1027 | 2573 | 69 |
2044125 | 2044125 | 2021-12-24 | Clay | Alabama | 1027 | 2569 | 69 |
2040876 | 2040876 | 2021-12-23 | Clay | Alabama | 1027 | 2567 | 69 |
2037626 | 2037626 | 2021-12-22 | Clay | Alabama | 1027 | 2562 | 69 |
2034376 | 2034376 | 2021-12-21 | Clay | Alabama | 1027 | 2562 | 69 |
2031126 | 2031126 | 2021-12-20 | Clay | Alabama | 1027 | 2560 | 69 |
2027875 | 2027875 | 2021-12-19 | Clay | Alabama | 1027 | 2556 | 69 |
2024624 | 2024624 | 2021-12-18 | Clay | Alabama | 1027 | 2555 | 69 |
2021373 | 2021373 | 2021-12-17 | Clay | Alabama | 1027 | 2549 | 69 |
2018122 | 2018122 | 2021-12-16 | Clay | Alabama | 1027 | 2546 | 69 |
2014872 | 2014872 | 2021-12-15 | Clay | Alabama | 1027 | 2540 | 69 |
2011621 | 2011621 | 2021-12-14 | Clay | Alabama | 1027 | 2539 | 69 |
2008370 | 2008370 | 2021-12-13 | Clay | Alabama | 1027 | 2535 | 69 |
2005119 | 2005119 | 2021-12-12 | Clay | Alabama | 1027 | 2535 | 69 |
2001868 | 2001868 | 2021-12-11 | Clay | Alabama | 1027 | 2535 | 69 |
1998618 | 1998618 | 2021-12-10 | Clay | Alabama | 1027 | 2535 | 69 |
1995367 | 1995367 | 2021-12-09 | Clay | Alabama | 1027 | 2534 | 69 |
1992116 | 1992116 | 2021-12-08 | Clay | Alabama | 1027 | 2532 | 69 |
1988865 | 1988865 | 2021-12-07 | Clay | Alabama | 1027 | 2531 | 69 |
1985615 | 1985615 | 2021-12-06 | Clay | Alabama | 1027 | 2531 | 69 |
1982365 | 1982365 | 2021-12-05 | Clay | Alabama | 1027 | 2530 | 69 |
1979115 | 1979115 | 2021-12-04 | Clay | Alabama | 1027 | 2529 | 69 |
1975865 | 1975865 | 2021-12-03 | Clay | Alabama | 1027 | 2520 | 69 |
1972616 | 1972616 | 2021-12-02 | Clay | Alabama | 1027 | 2516 | 69 |
1969366 | 1969366 | 2021-12-01 | Clay | Alabama | 1027 | 2511 | 69 |
1966116 | 1966116 | 2021-11-30 | Clay | Alabama | 1027 | 2511 | 69 |
1962864 | 1962864 | 2021-11-29 | Clay | Alabama | 1027 | 2508 | 69 |
1959613 | 1959613 | 2021-11-28 | Clay | Alabama | 1027 | 2508 | 69 |
1956362 | 1956362 | 2021-11-27 | Clay | Alabama | 1027 | 2508 | 69 |
1953111 | 1953111 | 2021-11-26 | Clay | Alabama | 1027 | 2508 | 69 |
1949860 | 1949860 | 2021-11-25 | Clay | Alabama | 1027 | 2508 | 69 |
1946609 | 1946609 | 2021-11-24 | Clay | Alabama | 1027 | 2508 | 69 |
1943358 | 1943358 | 2021-11-23 | Clay | Alabama | 1027 | 2509 | 69 |
1940108 | 1940108 | 2021-11-22 | Clay | Alabama | 1027 | 2508 | 69 |
1936858 | 1936858 | 2021-11-21 | Clay | Alabama | 1027 | 2508 | 69 |
1933608 | 1933608 | 2021-11-20 | Clay | Alabama | 1027 | 2508 | 69 |
1930356 | 1930356 | 2021-11-19 | Clay | Alabama | 1027 | 2507 | 69 |
1927106 | 1927106 | 2021-11-18 | Clay | Alabama | 1027 | 2502 | 69 |
1923856 | 1923856 | 2021-11-17 | Clay | Alabama | 1027 | 2501 | 69 |
1920607 | 1920607 | 2021-11-16 | Clay | Alabama | 1027 | 2496 | 69 |
1917357 | 1917357 | 2021-11-15 | Clay | Alabama | 1027 | 2497 | 70 |
1914107 | 1914107 | 2021-11-14 | Clay | Alabama | 1027 | 2495 | 70 |
1910857 | 1910857 | 2021-11-13 | Clay | Alabama | 1027 | 2495 | 70 |
1907608 | 1907608 | 2021-11-12 | Clay | Alabama | 1027 | 2488 | 70 |
1904359 | 1904359 | 2021-11-11 | Clay | Alabama | 1027 | 2487 | 70 |
1901109 | 1901109 | 2021-11-10 | Clay | Alabama | 1027 | 2484 | 70 |
1897859 | 1897859 | 2021-11-09 | Clay | Alabama | 1027 | 2484 | 70 |
1894609 | 1894609 | 2021-11-08 | Clay | Alabama | 1027 | 2480 | 70 |
1891359 | 1891359 | 2021-11-07 | Clay | Alabama | 1027 | 2480 | 70 |
1888109 | 1888109 | 2021-11-06 | Clay | Alabama | 1027 | 2479 | 70 |
1884859 | 1884859 | 2021-11-05 | Clay | Alabama | 1027 | 2476 | 69 |
1881610 | 1881610 | 2021-11-04 | Clay | Alabama | 1027 | 2473 | 69 |
1878361 | 1878361 | 2021-11-03 | Clay | Alabama | 1027 | 2472 | 69 |
1875112 | 1875112 | 2021-11-02 | Clay | Alabama | 1027 | 2473 | 69 |
1871863 | 1871863 | 2021-11-01 | Clay | Alabama | 1027 | 2468 | 68 |
1868614 | 1868614 | 2021-10-31 | Clay | Alabama | 1027 | 2468 | 68 |
1865365 | 1865365 | 2021-10-30 | Clay | Alabama | 1027 | 2465 | 68 |
1862116 | 1862116 | 2021-10-29 | Clay | Alabama | 1027 | 2458 | 68 |
1858867 | 1858867 | 2021-10-28 | Clay | Alabama | 1027 | 2458 | 68 |
1855618 | 1855618 | 2021-10-27 | Clay | Alabama | 1027 | 2454 | 68 |
1852369 | 1852369 | 2021-10-26 | Clay | Alabama | 1027 | 2455 | 68 |
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);