ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Elmore" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174219 | 2174219 | 2022-02-02 | Elmore | Alabama | 1051 | 22220 | 311 |
2170967 | 2170967 | 2022-02-01 | Elmore | Alabama | 1051 | 22136 | 308 |
2167714 | 2167714 | 2022-01-31 | Elmore | Alabama | 1051 | 22052 | 308 |
2164459 | 2164459 | 2022-01-30 | Elmore | Alabama | 1051 | 21817 | 308 |
2161204 | 2161204 | 2022-01-29 | Elmore | Alabama | 1051 | 21654 | 308 |
2157948 | 2157948 | 2022-01-28 | Elmore | Alabama | 1051 | 20438 | 302 |
2154695 | 2154695 | 2022-01-27 | Elmore | Alabama | 1051 | 20438 | 302 |
2151442 | 2151442 | 2022-01-26 | Elmore | Alabama | 1051 | 20438 | 302 |
2148190 | 2148190 | 2022-01-25 | Elmore | Alabama | 1051 | 20438 | 302 |
2144938 | 2144938 | 2022-01-24 | Elmore | Alabama | 1051 | 20438 | 302 |
2141683 | 2141683 | 2022-01-23 | Elmore | Alabama | 1051 | 20336 | 302 |
2138427 | 2138427 | 2022-01-22 | Elmore | Alabama | 1051 | 20228 | 302 |
2135172 | 2135172 | 2022-01-21 | Elmore | Alabama | 1051 | 19985 | 302 |
2131920 | 2131920 | 2022-01-20 | Elmore | Alabama | 1051 | 19717 | 302 |
2128666 | 2128666 | 2022-01-19 | Elmore | Alabama | 1051 | 19456 | 302 |
2125413 | 2125413 | 2022-01-18 | Elmore | Alabama | 1051 | 19233 | 301 |
2122161 | 2122161 | 2022-01-17 | Elmore | Alabama | 1051 | 19132 | 301 |
2118909 | 2118909 | 2022-01-16 | Elmore | Alabama | 1051 | 19028 | 301 |
2115657 | 2115657 | 2022-01-15 | Elmore | Alabama | 1051 | 18318 | 301 |
2112405 | 2112405 | 2022-01-14 | Elmore | Alabama | 1051 | 18318 | 301 |
2109153 | 2109153 | 2022-01-13 | Elmore | Alabama | 1051 | 18318 | 301 |
2105902 | 2105902 | 2022-01-12 | Elmore | Alabama | 1051 | 18318 | 301 |
2102651 | 2102651 | 2022-01-11 | Elmore | Alabama | 1051 | 18148 | 301 |
2099400 | 2099400 | 2022-01-10 | Elmore | Alabama | 1051 | 18022 | 301 |
2096149 | 2096149 | 2022-01-09 | Elmore | Alabama | 1051 | 17952 | 301 |
2092897 | 2092897 | 2022-01-08 | Elmore | Alabama | 1051 | 17796 | 301 |
2089645 | 2089645 | 2022-01-07 | Elmore | Alabama | 1051 | 17669 | 299 |
2086394 | 2086394 | 2022-01-06 | Elmore | Alabama | 1051 | 17451 | 299 |
2083142 | 2083142 | 2022-01-05 | Elmore | Alabama | 1051 | 17258 | 298 |
2079890 | 2079890 | 2022-01-04 | Elmore | Alabama | 1051 | 17109 | 298 |
2076638 | 2076638 | 2022-01-03 | Elmore | Alabama | 1051 | 16997 | 297 |
2073387 | 2073387 | 2022-01-02 | Elmore | Alabama | 1051 | 16899 | 297 |
2070136 | 2070136 | 2022-01-01 | Elmore | Alabama | 1051 | 16730 | 297 |
2066885 | 2066885 | 2021-12-31 | Elmore | Alabama | 1051 | 16730 | 297 |
2063635 | 2063635 | 2021-12-30 | Elmore | Alabama | 1051 | 16638 | 297 |
2060385 | 2060385 | 2021-12-29 | Elmore | Alabama | 1051 | 16570 | 297 |
2057136 | 2057136 | 2021-12-28 | Elmore | Alabama | 1051 | 16489 | 297 |
2053887 | 2053887 | 2021-12-27 | Elmore | Alabama | 1051 | 16432 | 297 |
2050637 | 2050637 | 2021-12-26 | Elmore | Alabama | 1051 | 16406 | 297 |
2047387 | 2047387 | 2021-12-25 | Elmore | Alabama | 1051 | 16396 | 297 |
2044137 | 2044137 | 2021-12-24 | Elmore | Alabama | 1051 | 16364 | 297 |
2040888 | 2040888 | 2021-12-23 | Elmore | Alabama | 1051 | 16312 | 296 |
2037638 | 2037638 | 2021-12-22 | Elmore | Alabama | 1051 | 16259 | 296 |
2034388 | 2034388 | 2021-12-21 | Elmore | Alabama | 1051 | 16233 | 296 |
2031138 | 2031138 | 2021-12-20 | Elmore | Alabama | 1051 | 16199 | 296 |
2027887 | 2027887 | 2021-12-19 | Elmore | Alabama | 1051 | 16186 | 296 |
2024636 | 2024636 | 2021-12-18 | Elmore | Alabama | 1051 | 16169 | 296 |
2021385 | 2021385 | 2021-12-17 | Elmore | Alabama | 1051 | 16143 | 296 |
2018134 | 2018134 | 2021-12-16 | Elmore | Alabama | 1051 | 16131 | 296 |
2014884 | 2014884 | 2021-12-15 | Elmore | Alabama | 1051 | 16117 | 296 |
2011633 | 2011633 | 2021-12-14 | Elmore | Alabama | 1051 | 16109 | 296 |
2008382 | 2008382 | 2021-12-13 | Elmore | Alabama | 1051 | 16039 | 296 |
2005131 | 2005131 | 2021-12-12 | Elmore | Alabama | 1051 | 16034 | 296 |
2001880 | 2001880 | 2021-12-11 | Elmore | Alabama | 1051 | 16031 | 296 |
1998630 | 1998630 | 2021-12-10 | Elmore | Alabama | 1051 | 15993 | 295 |
1995379 | 1995379 | 2021-12-09 | Elmore | Alabama | 1051 | 15970 | 295 |
1992128 | 1992128 | 2021-12-08 | Elmore | Alabama | 1051 | 15980 | 295 |
1988877 | 1988877 | 2021-12-07 | Elmore | Alabama | 1051 | 15967 | 295 |
1985627 | 1985627 | 2021-12-06 | Elmore | Alabama | 1051 | 15952 | 295 |
1982377 | 1982377 | 2021-12-05 | Elmore | Alabama | 1051 | 15948 | 295 |
1979127 | 1979127 | 2021-12-04 | Elmore | Alabama | 1051 | 15940 | 295 |
1975877 | 1975877 | 2021-12-03 | Elmore | Alabama | 1051 | 15948 | 295 |
1972628 | 1972628 | 2021-12-02 | Elmore | Alabama | 1051 | 15927 | 295 |
1969378 | 1969378 | 2021-12-01 | Elmore | Alabama | 1051 | 15917 | 295 |
1966128 | 1966128 | 2021-11-30 | Elmore | Alabama | 1051 | 15912 | 294 |
1962876 | 1962876 | 2021-11-29 | Elmore | Alabama | 1051 | 15904 | 294 |
1959625 | 1959625 | 2021-11-28 | Elmore | Alabama | 1051 | 15904 | 294 |
1956374 | 1956374 | 2021-11-27 | Elmore | Alabama | 1051 | 15904 | 294 |
1953123 | 1953123 | 2021-11-26 | Elmore | Alabama | 1051 | 15902 | 294 |
1949872 | 1949872 | 2021-11-25 | Elmore | Alabama | 1051 | 15902 | 294 |
1946621 | 1946621 | 2021-11-24 | Elmore | Alabama | 1051 | 15894 | 294 |
1943370 | 1943370 | 2021-11-23 | Elmore | Alabama | 1051 | 15902 | 294 |
1940120 | 1940120 | 2021-11-22 | Elmore | Alabama | 1051 | 15899 | 294 |
1936870 | 1936870 | 2021-11-21 | Elmore | Alabama | 1051 | 15892 | 294 |
1933620 | 1933620 | 2021-11-20 | Elmore | Alabama | 1051 | 15886 | 294 |
1930368 | 1930368 | 2021-11-19 | Elmore | Alabama | 1051 | 15888 | 294 |
1927118 | 1927118 | 2021-11-18 | Elmore | Alabama | 1051 | 15900 | 294 |
1923868 | 1923868 | 2021-11-17 | Elmore | Alabama | 1051 | 15911 | 294 |
1920619 | 1920619 | 2021-11-16 | Elmore | Alabama | 1051 | 15871 | 294 |
1917369 | 1917369 | 2021-11-15 | Elmore | Alabama | 1051 | 15825 | 294 |
1914119 | 1914119 | 2021-11-14 | Elmore | Alabama | 1051 | 15821 | 294 |
1910869 | 1910869 | 2021-11-13 | Elmore | Alabama | 1051 | 15815 | 294 |
1907620 | 1907620 | 2021-11-12 | Elmore | Alabama | 1051 | 15757 | 291 |
1904371 | 1904371 | 2021-11-11 | Elmore | Alabama | 1051 | 15730 | 291 |
1901121 | 1901121 | 2021-11-10 | Elmore | Alabama | 1051 | 15719 | 290 |
1897871 | 1897871 | 2021-11-09 | Elmore | Alabama | 1051 | 15703 | 290 |
1894621 | 1894621 | 2021-11-08 | Elmore | Alabama | 1051 | 15647 | 289 |
1891371 | 1891371 | 2021-11-07 | Elmore | Alabama | 1051 | 15644 | 289 |
1888121 | 1888121 | 2021-11-06 | Elmore | Alabama | 1051 | 15643 | 289 |
1884871 | 1884871 | 2021-11-05 | Elmore | Alabama | 1051 | 15617 | 288 |
1881622 | 1881622 | 2021-11-04 | Elmore | Alabama | 1051 | 15553 | 288 |
1878373 | 1878373 | 2021-11-03 | Elmore | Alabama | 1051 | 15529 | 288 |
1875124 | 1875124 | 2021-11-02 | Elmore | Alabama | 1051 | 15507 | 288 |
1871875 | 1871875 | 2021-11-01 | Elmore | Alabama | 1051 | 15495 | 288 |
1868626 | 1868626 | 2021-10-31 | Elmore | Alabama | 1051 | 15488 | 288 |
1865377 | 1865377 | 2021-10-30 | Elmore | Alabama | 1051 | 15482 | 288 |
1862128 | 1862128 | 2021-10-29 | Elmore | Alabama | 1051 | 15466 | 288 |
1858879 | 1858879 | 2021-10-28 | Elmore | Alabama | 1051 | 15439 | 288 |
1855630 | 1855630 | 2021-10-27 | Elmore | Alabama | 1051 | 15341 | 286 |
1852381 | 1852381 | 2021-10-26 | Elmore | Alabama | 1051 | 15292 | 286 |
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);