ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Blount" and fips = 1009 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2336808 | 2336808 | 2022-03-24 | Blount | Alabama | 1009 | 14894 | 230 |
2333554 | 2333554 | 2022-03-23 | Blount | Alabama | 1009 | 14890 | 230 |
2330300 | 2330300 | 2022-03-22 | Blount | Alabama | 1009 | 14892 | 230 |
2327048 | 2327048 | 2022-03-21 | Blount | Alabama | 1009 | 14891 | 230 |
2323795 | 2323795 | 2022-03-20 | Blount | Alabama | 1009 | 14889 | 230 |
2320541 | 2320541 | 2022-03-19 | Blount | Alabama | 1009 | 14889 | 230 |
2317287 | 2317287 | 2022-03-18 | Blount | Alabama | 1009 | 14889 | 230 |
2314034 | 2314034 | 2022-03-17 | Blount | Alabama | 1009 | 14883 | 228 |
2310781 | 2310781 | 2022-03-16 | Blount | Alabama | 1009 | 14881 | 227 |
2307528 | 2307528 | 2022-03-15 | Blount | Alabama | 1009 | 14879 | 228 |
2304277 | 2304277 | 2022-03-14 | Blount | Alabama | 1009 | 14874 | 227 |
2301025 | 2301025 | 2022-03-13 | Blount | Alabama | 1009 | 14869 | 227 |
2297773 | 2297773 | 2022-03-12 | Blount | Alabama | 1009 | 14869 | 227 |
2294521 | 2294521 | 2022-03-11 | Blount | Alabama | 1009 | 14869 | 227 |
2291269 | 2291269 | 2022-03-10 | Blount | Alabama | 1009 | 14861 | 227 |
2288017 | 2288017 | 2022-03-09 | Blount | Alabama | 1009 | 14856 | 227 |
2284765 | 2284765 | 2022-03-08 | Blount | Alabama | 1009 | 14853 | 227 |
2281513 | 2281513 | 2022-03-07 | Blount | Alabama | 1009 | 14848 | 223 |
2278260 | 2278260 | 2022-03-06 | Blount | Alabama | 1009 | 14803 | 221 |
2275007 | 2275007 | 2022-03-05 | Blount | Alabama | 1009 | 14803 | 221 |
2271754 | 2271754 | 2022-03-04 | Blount | Alabama | 1009 | 14803 | 221 |
2268502 | 2268502 | 2022-03-03 | Blount | Alabama | 1009 | 14799 | 221 |
2265249 | 2265249 | 2022-03-02 | Blount | Alabama | 1009 | 14786 | 220 |
2261999 | 2261999 | 2022-03-01 | Blount | Alabama | 1009 | 14772 | 219 |
2258748 | 2258748 | 2022-02-28 | Blount | Alabama | 1009 | 14760 | 218 |
2255497 | 2255497 | 2022-02-27 | Blount | Alabama | 1009 | 14757 | 218 |
2252246 | 2252246 | 2022-02-26 | Blount | Alabama | 1009 | 14753 | 218 |
2248995 | 2248995 | 2022-02-25 | Blount | Alabama | 1009 | 14734 | 217 |
2245744 | 2245744 | 2022-02-24 | Blount | Alabama | 1009 | 14710 | 216 |
2242493 | 2242493 | 2022-02-23 | Blount | Alabama | 1009 | 14706 | 216 |
2239242 | 2239242 | 2022-02-22 | Blount | Alabama | 1009 | 14688 | 216 |
2235991 | 2235991 | 2022-02-21 | Blount | Alabama | 1009 | 14682 | 216 |
2232740 | 2232740 | 2022-02-20 | Blount | Alabama | 1009 | 14672 | 216 |
2229489 | 2229489 | 2022-02-19 | Blount | Alabama | 1009 | 14663 | 216 |
2226238 | 2226238 | 2022-02-18 | Blount | Alabama | 1009 | 14643 | 215 |
2222987 | 2222987 | 2022-02-17 | Blount | Alabama | 1009 | 14632 | 215 |
2219736 | 2219736 | 2022-02-16 | Blount | Alabama | 1009 | 14594 | 214 |
2216486 | 2216486 | 2022-02-15 | Blount | Alabama | 1009 | 14575 | 213 |
2213235 | 2213235 | 2022-02-14 | Blount | Alabama | 1009 | 14564 | 213 |
2209982 | 2209982 | 2022-02-13 | Blount | Alabama | 1009 | 14556 | 213 |
2206729 | 2206729 | 2022-02-12 | Blount | Alabama | 1009 | 14545 | 213 |
2203476 | 2203476 | 2022-02-11 | Blount | Alabama | 1009 | 14516 | 212 |
2200222 | 2200222 | 2022-02-10 | Blount | Alabama | 1009 | 14493 | 212 |
2196968 | 2196968 | 2022-02-09 | Blount | Alabama | 1009 | 14447 | 212 |
2193713 | 2193713 | 2022-02-08 | Blount | Alabama | 1009 | 14417 | 211 |
2190460 | 2190460 | 2022-02-07 | Blount | Alabama | 1009 | 14366 | 211 |
2187207 | 2187207 | 2022-02-06 | Blount | Alabama | 1009 | 14329 | 210 |
2183954 | 2183954 | 2022-02-05 | Blount | Alabama | 1009 | 14329 | 210 |
2180702 | 2180702 | 2022-02-04 | Blount | Alabama | 1009 | 14299 | 210 |
2177451 | 2177451 | 2022-02-03 | Blount | Alabama | 1009 | 14158 | 208 |
2174198 | 2174198 | 2022-02-02 | Blount | Alabama | 1009 | 14158 | 208 |
2170946 | 2170946 | 2022-02-01 | Blount | Alabama | 1009 | 14096 | 207 |
2167693 | 2167693 | 2022-01-31 | Blount | Alabama | 1009 | 14056 | 207 |
2164438 | 2164438 | 2022-01-30 | Blount | Alabama | 1009 | 13981 | 207 |
2161183 | 2161183 | 2022-01-29 | Blount | Alabama | 1009 | 13930 | 207 |
2157927 | 2157927 | 2022-01-28 | Blount | Alabama | 1009 | 13427 | 204 |
2154674 | 2154674 | 2022-01-27 | Blount | Alabama | 1009 | 13427 | 204 |
2151421 | 2151421 | 2022-01-26 | Blount | Alabama | 1009 | 13427 | 204 |
2148169 | 2148169 | 2022-01-25 | Blount | Alabama | 1009 | 13427 | 204 |
2144917 | 2144917 | 2022-01-24 | Blount | Alabama | 1009 | 13427 | 204 |
2141662 | 2141662 | 2022-01-23 | Blount | Alabama | 1009 | 13362 | 204 |
2138406 | 2138406 | 2022-01-22 | Blount | Alabama | 1009 | 13259 | 204 |
2135151 | 2135151 | 2022-01-21 | Blount | Alabama | 1009 | 13131 | 204 |
2131899 | 2131899 | 2022-01-20 | Blount | Alabama | 1009 | 13005 | 204 |
2128645 | 2128645 | 2022-01-19 | Blount | Alabama | 1009 | 12825 | 203 |
2125392 | 2125392 | 2022-01-18 | Blount | Alabama | 1009 | 12648 | 203 |
2122140 | 2122140 | 2022-01-17 | Blount | Alabama | 1009 | 12579 | 203 |
2118888 | 2118888 | 2022-01-16 | Blount | Alabama | 1009 | 12520 | 203 |
2115636 | 2115636 | 2022-01-15 | Blount | Alabama | 1009 | 12068 | 202 |
2112384 | 2112384 | 2022-01-14 | Blount | Alabama | 1009 | 12068 | 202 |
2109132 | 2109132 | 2022-01-13 | Blount | Alabama | 1009 | 12068 | 202 |
2105881 | 2105881 | 2022-01-12 | Blount | Alabama | 1009 | 12068 | 202 |
2102630 | 2102630 | 2022-01-11 | Blount | Alabama | 1009 | 11965 | 202 |
2099379 | 2099379 | 2022-01-10 | Blount | Alabama | 1009 | 11893 | 202 |
2096128 | 2096128 | 2022-01-09 | Blount | Alabama | 1009 | 11828 | 202 |
2092876 | 2092876 | 2022-01-08 | Blount | Alabama | 1009 | 11749 | 202 |
2089624 | 2089624 | 2022-01-07 | Blount | Alabama | 1009 | 11690 | 199 |
2086373 | 2086373 | 2022-01-06 | Blount | Alabama | 1009 | 11587 | 198 |
2083121 | 2083121 | 2022-01-05 | Blount | Alabama | 1009 | 11497 | 198 |
2079869 | 2079869 | 2022-01-04 | Blount | Alabama | 1009 | 11430 | 198 |
2076617 | 2076617 | 2022-01-03 | Blount | Alabama | 1009 | 11368 | 198 |
2073366 | 2073366 | 2022-01-02 | Blount | Alabama | 1009 | 11338 | 198 |
2070115 | 2070115 | 2022-01-01 | Blount | Alabama | 1009 | 11256 | 198 |
2066864 | 2066864 | 2021-12-31 | Blount | Alabama | 1009 | 11256 | 198 |
2063614 | 2063614 | 2021-12-30 | Blount | Alabama | 1009 | 11193 | 198 |
2060364 | 2060364 | 2021-12-29 | Blount | Alabama | 1009 | 11128 | 198 |
2057115 | 2057115 | 2021-12-28 | Blount | Alabama | 1009 | 11096 | 197 |
2053866 | 2053866 | 2021-12-27 | Blount | Alabama | 1009 | 11072 | 197 |
2050616 | 2050616 | 2021-12-26 | Blount | Alabama | 1009 | 11064 | 197 |
2047366 | 2047366 | 2021-12-25 | Blount | Alabama | 1009 | 11053 | 197 |
2044116 | 2044116 | 2021-12-24 | Blount | Alabama | 1009 | 11041 | 197 |
2040867 | 2040867 | 2021-12-23 | Blount | Alabama | 1009 | 11031 | 197 |
2037617 | 2037617 | 2021-12-22 | Blount | Alabama | 1009 | 11002 | 197 |
2034367 | 2034367 | 2021-12-21 | Blount | Alabama | 1009 | 10990 | 197 |
2031117 | 2031117 | 2021-12-20 | Blount | Alabama | 1009 | 10969 | 195 |
2027866 | 2027866 | 2021-12-19 | Blount | Alabama | 1009 | 10959 | 195 |
2024615 | 2024615 | 2021-12-18 | Blount | Alabama | 1009 | 10954 | 195 |
2021364 | 2021364 | 2021-12-17 | Blount | Alabama | 1009 | 10941 | 194 |
2018113 | 2018113 | 2021-12-16 | Blount | Alabama | 1009 | 10919 | 194 |
2014863 | 2014863 | 2021-12-15 | Blount | Alabama | 1009 | 10904 | 193 |
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);