ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Jackson" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174229 | 2174229 | 2022-02-02 | Jackson | Alabama | 1071 | 14184 | 211 |
2170977 | 2170977 | 2022-02-01 | Jackson | Alabama | 1071 | 14098 | 211 |
2167724 | 2167724 | 2022-01-31 | Jackson | Alabama | 1071 | 13988 | 210 |
2164469 | 2164469 | 2022-01-30 | Jackson | Alabama | 1071 | 13947 | 210 |
2161214 | 2161214 | 2022-01-29 | Jackson | Alabama | 1071 | 13861 | 210 |
2157958 | 2157958 | 2022-01-28 | Jackson | Alabama | 1071 | 13095 | 207 |
2154705 | 2154705 | 2022-01-27 | Jackson | Alabama | 1071 | 13095 | 207 |
2151452 | 2151452 | 2022-01-26 | Jackson | Alabama | 1071 | 13095 | 207 |
2148200 | 2148200 | 2022-01-25 | Jackson | Alabama | 1071 | 13095 | 207 |
2144948 | 2144948 | 2022-01-24 | Jackson | Alabama | 1071 | 13095 | 207 |
2141693 | 2141693 | 2022-01-23 | Jackson | Alabama | 1071 | 13032 | 207 |
2138437 | 2138437 | 2022-01-22 | Jackson | Alabama | 1071 | 12902 | 207 |
2135182 | 2135182 | 2022-01-21 | Jackson | Alabama | 1071 | 12682 | 207 |
2131930 | 2131930 | 2022-01-20 | Jackson | Alabama | 1071 | 12445 | 207 |
2128676 | 2128676 | 2022-01-19 | Jackson | Alabama | 1071 | 12176 | 207 |
2125423 | 2125423 | 2022-01-18 | Jackson | Alabama | 1071 | 11954 | 207 |
2122171 | 2122171 | 2022-01-17 | Jackson | Alabama | 1071 | 11857 | 207 |
2118919 | 2118919 | 2022-01-16 | Jackson | Alabama | 1071 | 11809 | 207 |
2115667 | 2115667 | 2022-01-15 | Jackson | Alabama | 1071 | 11314 | 204 |
2112415 | 2112415 | 2022-01-14 | Jackson | Alabama | 1071 | 11314 | 204 |
2109163 | 2109163 | 2022-01-13 | Jackson | Alabama | 1071 | 11314 | 204 |
2105912 | 2105912 | 2022-01-12 | Jackson | Alabama | 1071 | 11314 | 204 |
2102661 | 2102661 | 2022-01-11 | Jackson | Alabama | 1071 | 11225 | 203 |
2099410 | 2099410 | 2022-01-10 | Jackson | Alabama | 1071 | 11143 | 203 |
2096159 | 2096159 | 2022-01-09 | Jackson | Alabama | 1071 | 11121 | 203 |
2092907 | 2092907 | 2022-01-08 | Jackson | Alabama | 1071 | 11060 | 203 |
2089655 | 2089655 | 2022-01-07 | Jackson | Alabama | 1071 | 11010 | 202 |
2086404 | 2086404 | 2022-01-06 | Jackson | Alabama | 1071 | 10916 | 202 |
2083152 | 2083152 | 2022-01-05 | Jackson | Alabama | 1071 | 10840 | 201 |
2079900 | 2079900 | 2022-01-04 | Jackson | Alabama | 1071 | 10763 | 201 |
2076648 | 2076648 | 2022-01-03 | Jackson | Alabama | 1071 | 10711 | 201 |
2073397 | 2073397 | 2022-01-02 | Jackson | Alabama | 1071 | 10699 | 201 |
2070146 | 2070146 | 2022-01-01 | Jackson | Alabama | 1071 | 10637 | 201 |
2066895 | 2066895 | 2021-12-31 | Jackson | Alabama | 1071 | 10637 | 201 |
2063645 | 2063645 | 2021-12-30 | Jackson | Alabama | 1071 | 10577 | 201 |
2060395 | 2060395 | 2021-12-29 | Jackson | Alabama | 1071 | 10539 | 201 |
2057146 | 2057146 | 2021-12-28 | Jackson | Alabama | 1071 | 10508 | 200 |
2053897 | 2053897 | 2021-12-27 | Jackson | Alabama | 1071 | 10489 | 200 |
2050647 | 2050647 | 2021-12-26 | Jackson | Alabama | 1071 | 10485 | 200 |
2047397 | 2047397 | 2021-12-25 | Jackson | Alabama | 1071 | 10482 | 200 |
2044147 | 2044147 | 2021-12-24 | Jackson | Alabama | 1071 | 10462 | 200 |
2040898 | 2040898 | 2021-12-23 | Jackson | Alabama | 1071 | 10437 | 200 |
2037648 | 2037648 | 2021-12-22 | Jackson | Alabama | 1071 | 10412 | 200 |
2034398 | 2034398 | 2021-12-21 | Jackson | Alabama | 1071 | 10398 | 200 |
2031148 | 2031148 | 2021-12-20 | Jackson | Alabama | 1071 | 10368 | 200 |
2027897 | 2027897 | 2021-12-19 | Jackson | Alabama | 1071 | 10362 | 200 |
2024646 | 2024646 | 2021-12-18 | Jackson | Alabama | 1071 | 10360 | 200 |
2021395 | 2021395 | 2021-12-17 | Jackson | Alabama | 1071 | 10354 | 200 |
2018144 | 2018144 | 2021-12-16 | Jackson | Alabama | 1071 | 10345 | 200 |
2014894 | 2014894 | 2021-12-15 | Jackson | Alabama | 1071 | 10328 | 199 |
2011643 | 2011643 | 2021-12-14 | Jackson | Alabama | 1071 | 10317 | 199 |
2008392 | 2008392 | 2021-12-13 | Jackson | Alabama | 1071 | 10301 | 199 |
2005141 | 2005141 | 2021-12-12 | Jackson | Alabama | 1071 | 10297 | 199 |
2001890 | 2001890 | 2021-12-11 | Jackson | Alabama | 1071 | 10294 | 199 |
1998640 | 1998640 | 2021-12-10 | Jackson | Alabama | 1071 | 10273 | 197 |
1995389 | 1995389 | 2021-12-09 | Jackson | Alabama | 1071 | 10258 | 196 |
1992138 | 1992138 | 2021-12-08 | Jackson | Alabama | 1071 | 10245 | 196 |
1988887 | 1988887 | 2021-12-07 | Jackson | Alabama | 1071 | 10237 | 196 |
1985637 | 1985637 | 2021-12-06 | Jackson | Alabama | 1071 | 10221 | 196 |
1982387 | 1982387 | 2021-12-05 | Jackson | Alabama | 1071 | 10217 | 196 |
1979137 | 1979137 | 2021-12-04 | Jackson | Alabama | 1071 | 10214 | 196 |
1975887 | 1975887 | 2021-12-03 | Jackson | Alabama | 1071 | 10204 | 195 |
1972638 | 1972638 | 2021-12-02 | Jackson | Alabama | 1071 | 10191 | 195 |
1969388 | 1969388 | 2021-12-01 | Jackson | Alabama | 1071 | 10177 | 194 |
1966138 | 1966138 | 2021-11-30 | Jackson | Alabama | 1071 | 10170 | 194 |
1962886 | 1962886 | 2021-11-29 | Jackson | Alabama | 1071 | 10162 | 194 |
1959635 | 1959635 | 2021-11-28 | Jackson | Alabama | 1071 | 10161 | 194 |
1956384 | 1956384 | 2021-11-27 | Jackson | Alabama | 1071 | 10157 | 194 |
1953133 | 1953133 | 2021-11-26 | Jackson | Alabama | 1071 | 10151 | 194 |
1949882 | 1949882 | 2021-11-25 | Jackson | Alabama | 1071 | 10151 | 194 |
1946631 | 1946631 | 2021-11-24 | Jackson | Alabama | 1071 | 10157 | 194 |
1943380 | 1943380 | 2021-11-23 | Jackson | Alabama | 1071 | 10162 | 194 |
1940130 | 1940130 | 2021-11-22 | Jackson | Alabama | 1071 | 10152 | 195 |
1936880 | 1936880 | 2021-11-21 | Jackson | Alabama | 1071 | 10148 | 195 |
1933630 | 1933630 | 2021-11-20 | Jackson | Alabama | 1071 | 10146 | 195 |
1930378 | 1930378 | 2021-11-19 | Jackson | Alabama | 1071 | 10137 | 194 |
1927128 | 1927128 | 2021-11-18 | Jackson | Alabama | 1071 | 10139 | 194 |
1923878 | 1923878 | 2021-11-17 | Jackson | Alabama | 1071 | 10136 | 194 |
1920629 | 1920629 | 2021-11-16 | Jackson | Alabama | 1071 | 10140 | 194 |
1917379 | 1917379 | 2021-11-15 | Jackson | Alabama | 1071 | 10143 | 194 |
1914129 | 1914129 | 2021-11-14 | Jackson | Alabama | 1071 | 10134 | 194 |
1910879 | 1910879 | 2021-11-13 | Jackson | Alabama | 1071 | 10131 | 194 |
1907630 | 1907630 | 2021-11-12 | Jackson | Alabama | 1071 | 10137 | 194 |
1904381 | 1904381 | 2021-11-11 | Jackson | Alabama | 1071 | 10131 | 194 |
1901131 | 1901131 | 2021-11-10 | Jackson | Alabama | 1071 | 10111 | 193 |
1897881 | 1897881 | 2021-11-09 | Jackson | Alabama | 1071 | 10122 | 192 |
1894631 | 1894631 | 2021-11-08 | Jackson | Alabama | 1071 | 10118 | 192 |
1891381 | 1891381 | 2021-11-07 | Jackson | Alabama | 1071 | 10117 | 192 |
1888131 | 1888131 | 2021-11-06 | Jackson | Alabama | 1071 | 10116 | 192 |
1884881 | 1884881 | 2021-11-05 | Jackson | Alabama | 1071 | 10118 | 192 |
1881632 | 1881632 | 2021-11-04 | Jackson | Alabama | 1071 | 10119 | 191 |
1878383 | 1878383 | 2021-11-03 | Jackson | Alabama | 1071 | 10094 | 189 |
1875134 | 1875134 | 2021-11-02 | Jackson | Alabama | 1071 | 10087 | 188 |
1871885 | 1871885 | 2021-11-01 | Jackson | Alabama | 1071 | 10059 | 188 |
1868636 | 1868636 | 2021-10-31 | Jackson | Alabama | 1071 | 10059 | 188 |
1865387 | 1865387 | 2021-10-30 | Jackson | Alabama | 1071 | 10055 | 188 |
1862138 | 1862138 | 2021-10-29 | Jackson | Alabama | 1071 | 10058 | 186 |
1858889 | 1858889 | 2021-10-28 | Jackson | Alabama | 1071 | 10054 | 185 |
1855640 | 1855640 | 2021-10-27 | Jackson | Alabama | 1071 | 9987 | 185 |
1852391 | 1852391 | 2021-10-26 | Jackson | Alabama | 1071 | 9909 | 185 |
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);