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)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499579 | 2499579 | 2022-05-13 | Blount | Alabama | 1009 | 15005 | 243 |
2496321 | 2496321 | 2022-05-12 | Blount | Alabama | 1009 | 15004 | 243 |
2493063 | 2493063 | 2022-05-11 | Blount | Alabama | 1009 | 14999 | 243 |
2489805 | 2489805 | 2022-05-10 | Blount | Alabama | 1009 | 14994 | 243 |
2486548 | 2486548 | 2022-05-09 | Blount | Alabama | 1009 | 14988 | 243 |
2483290 | 2483290 | 2022-05-08 | Blount | Alabama | 1009 | 14985 | 243 |
2480032 | 2480032 | 2022-05-07 | Blount | Alabama | 1009 | 14985 | 243 |
2476774 | 2476774 | 2022-05-06 | Blount | Alabama | 1009 | 14985 | 243 |
2473516 | 2473516 | 2022-05-05 | Blount | Alabama | 1009 | 14985 | 243 |
2470259 | 2470259 | 2022-05-04 | Blount | Alabama | 1009 | 14983 | 243 |
2467003 | 2467003 | 2022-05-03 | Blount | Alabama | 1009 | 14981 | 243 |
2463748 | 2463748 | 2022-05-02 | Blount | Alabama | 1009 | 14979 | 243 |
2460492 | 2460492 | 2022-05-01 | Blount | Alabama | 1009 | 14980 | 243 |
2457236 | 2457236 | 2022-04-30 | Blount | Alabama | 1009 | 14980 | 243 |
2453980 | 2453980 | 2022-04-29 | Blount | Alabama | 1009 | 14980 | 243 |
2450724 | 2450724 | 2022-04-28 | Blount | Alabama | 1009 | 14977 | 243 |
2447468 | 2447468 | 2022-04-27 | Blount | Alabama | 1009 | 14976 | 243 |
2444212 | 2444212 | 2022-04-26 | Blount | Alabama | 1009 | 14968 | 243 |
2440956 | 2440956 | 2022-04-25 | Blount | Alabama | 1009 | 14967 | 243 |
2437700 | 2437700 | 2022-04-24 | Blount | Alabama | 1009 | 14967 | 243 |
2434444 | 2434444 | 2022-04-23 | Blount | Alabama | 1009 | 14967 | 243 |
2431188 | 2431188 | 2022-04-22 | Blount | Alabama | 1009 | 14967 | 243 |
2427932 | 2427932 | 2022-04-21 | Blount | Alabama | 1009 | 14967 | 243 |
2424676 | 2424676 | 2022-04-20 | Blount | Alabama | 1009 | 14963 | 243 |
2421420 | 2421420 | 2022-04-19 | Blount | Alabama | 1009 | 14961 | 243 |
2418164 | 2418164 | 2022-04-18 | Blount | Alabama | 1009 | 14959 | 242 |
2414908 | 2414908 | 2022-04-17 | Blount | Alabama | 1009 | 14959 | 242 |
2411652 | 2411652 | 2022-04-16 | Blount | Alabama | 1009 | 14959 | 242 |
2408396 | 2408396 | 2022-04-15 | Blount | Alabama | 1009 | 14959 | 242 |
2405140 | 2405140 | 2022-04-14 | Blount | Alabama | 1009 | 14953 | 241 |
2401885 | 2401885 | 2022-04-13 | Blount | Alabama | 1009 | 14935 | 241 |
2398630 | 2398630 | 2022-04-12 | Blount | Alabama | 1009 | 14934 | 241 |
2395375 | 2395375 | 2022-04-11 | Blount | Alabama | 1009 | 14934 | 239 |
2392119 | 2392119 | 2022-04-10 | Blount | Alabama | 1009 | 14929 | 239 |
2388863 | 2388863 | 2022-04-09 | Blount | Alabama | 1009 | 14929 | 239 |
2385608 | 2385608 | 2022-04-08 | Blount | Alabama | 1009 | 14929 | 239 |
2382353 | 2382353 | 2022-04-07 | Blount | Alabama | 1009 | 14926 | 239 |
2379098 | 2379098 | 2022-04-06 | Blount | Alabama | 1009 | 14905 | 237 |
2375844 | 2375844 | 2022-04-05 | Blount | Alabama | 1009 | 14903 | 237 |
2372592 | 2372592 | 2022-04-04 | Blount | Alabama | 1009 | 14902 | 237 |
2369339 | 2369339 | 2022-04-03 | Blount | Alabama | 1009 | 14901 | 237 |
2366086 | 2366086 | 2022-04-02 | Blount | Alabama | 1009 | 14901 | 237 |
2362833 | 2362833 | 2022-04-01 | Blount | Alabama | 1009 | 14901 | 237 |
2359579 | 2359579 | 2022-03-31 | Blount | Alabama | 1009 | 14900 | 236 |
2356325 | 2356325 | 2022-03-30 | Blount | Alabama | 1009 | 14899 | 236 |
2353072 | 2353072 | 2022-03-29 | Blount | Alabama | 1009 | 14899 | 236 |
2349820 | 2349820 | 2022-03-28 | Blount | Alabama | 1009 | 14898 | 235 |
2346567 | 2346567 | 2022-03-27 | Blount | Alabama | 1009 | 14896 | 233 |
2343314 | 2343314 | 2022-03-26 | Blount | Alabama | 1009 | 14896 | 233 |
2340061 | 2340061 | 2022-03-25 | Blount | Alabama | 1009 | 14896 | 233 |
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 |
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);