ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,565 rows where county = "Blount" 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 |
2339341 | 2339341 | 2022-03-24 | Blount | Tennessee | 47009 | 39027 | 418 |
2333554 | 2333554 | 2022-03-23 | Blount | Alabama | 1009 | 14890 | 230 |
2336087 | 2336087 | 2022-03-23 | Blount | Tennessee | 47009 | 39027 | 418 |
2330300 | 2330300 | 2022-03-22 | Blount | Alabama | 1009 | 14892 | 230 |
2332833 | 2332833 | 2022-03-22 | Blount | Tennessee | 47009 | 38990 | 413 |
2327048 | 2327048 | 2022-03-21 | Blount | Alabama | 1009 | 14891 | 230 |
2329580 | 2329580 | 2022-03-21 | Blount | Tennessee | 47009 | 38990 | 413 |
2323795 | 2323795 | 2022-03-20 | Blount | Alabama | 1009 | 14889 | 230 |
2326328 | 2326328 | 2022-03-20 | Blount | Tennessee | 47009 | 38990 | 413 |
2320541 | 2320541 | 2022-03-19 | Blount | Alabama | 1009 | 14889 | 230 |
2323075 | 2323075 | 2022-03-19 | Blount | Tennessee | 47009 | 38990 | 413 |
2317287 | 2317287 | 2022-03-18 | Blount | Alabama | 1009 | 14889 | 230 |
2319821 | 2319821 | 2022-03-18 | Blount | Tennessee | 47009 | 38990 | 413 |
2314034 | 2314034 | 2022-03-17 | Blount | Alabama | 1009 | 14883 | 228 |
2316567 | 2316567 | 2022-03-17 | Blount | Tennessee | 47009 | 38990 | 413 |
2310781 | 2310781 | 2022-03-16 | Blount | Alabama | 1009 | 14881 | 227 |
2313314 | 2313314 | 2022-03-16 | Blount | Tennessee | 47009 | 38990 | 413 |
2307528 | 2307528 | 2022-03-15 | Blount | Alabama | 1009 | 14879 | 228 |
2310061 | 2310061 | 2022-03-15 | Blount | Tennessee | 47009 | 38940 | 399 |
2304277 | 2304277 | 2022-03-14 | Blount | Alabama | 1009 | 14874 | 227 |
2306808 | 2306808 | 2022-03-14 | Blount | Tennessee | 47009 | 38940 | 399 |
2301025 | 2301025 | 2022-03-13 | Blount | Alabama | 1009 | 14869 | 227 |
2303557 | 2303557 | 2022-03-13 | Blount | Tennessee | 47009 | 38940 | 399 |
2297773 | 2297773 | 2022-03-12 | Blount | Alabama | 1009 | 14869 | 227 |
2300305 | 2300305 | 2022-03-12 | Blount | Tennessee | 47009 | 38940 | 399 |
2294521 | 2294521 | 2022-03-11 | Blount | Alabama | 1009 | 14869 | 227 |
2297053 | 2297053 | 2022-03-11 | Blount | Tennessee | 47009 | 38940 | 399 |
2291269 | 2291269 | 2022-03-10 | Blount | Alabama | 1009 | 14861 | 227 |
2293801 | 2293801 | 2022-03-10 | Blount | Tennessee | 47009 | 38940 | 399 |
2288017 | 2288017 | 2022-03-09 | Blount | Alabama | 1009 | 14856 | 227 |
2290549 | 2290549 | 2022-03-09 | Blount | Tennessee | 47009 | 38940 | 399 |
2284765 | 2284765 | 2022-03-08 | Blount | Alabama | 1009 | 14853 | 227 |
2287297 | 2287297 | 2022-03-08 | Blount | Tennessee | 47009 | 38827 | 396 |
2281513 | 2281513 | 2022-03-07 | Blount | Alabama | 1009 | 14848 | 223 |
2284045 | 2284045 | 2022-03-07 | Blount | Tennessee | 47009 | 38827 | 396 |
2278260 | 2278260 | 2022-03-06 | Blount | Alabama | 1009 | 14803 | 221 |
2280793 | 2280793 | 2022-03-06 | Blount | Tennessee | 47009 | 38827 | 396 |
2275007 | 2275007 | 2022-03-05 | Blount | Alabama | 1009 | 14803 | 221 |
2277540 | 2277540 | 2022-03-05 | Blount | Tennessee | 47009 | 38827 | 396 |
2271754 | 2271754 | 2022-03-04 | Blount | Alabama | 1009 | 14803 | 221 |
2274287 | 2274287 | 2022-03-04 | Blount | Tennessee | 47009 | 38827 | 396 |
2268502 | 2268502 | 2022-03-03 | Blount | Alabama | 1009 | 14799 | 221 |
2271034 | 2271034 | 2022-03-03 | Blount | Tennessee | 47009 | 38827 | 396 |
2265249 | 2265249 | 2022-03-02 | Blount | Alabama | 1009 | 14786 | 220 |
2267782 | 2267782 | 2022-03-02 | Blount | Tennessee | 47009 | 38827 | 396 |
2261999 | 2261999 | 2022-03-01 | Blount | Alabama | 1009 | 14772 | 219 |
2264529 | 2264529 | 2022-03-01 | Blount | Tennessee | 47009 | 38653 | 387 |
2258748 | 2258748 | 2022-02-28 | Blount | Alabama | 1009 | 14760 | 218 |
2261279 | 2261279 | 2022-02-28 | Blount | Tennessee | 47009 | 38653 | 387 |
2255497 | 2255497 | 2022-02-27 | Blount | Alabama | 1009 | 14757 | 218 |
2258028 | 2258028 | 2022-02-27 | Blount | Tennessee | 47009 | 38653 | 387 |
2252246 | 2252246 | 2022-02-26 | Blount | Alabama | 1009 | 14753 | 218 |
2254777 | 2254777 | 2022-02-26 | Blount | Tennessee | 47009 | 38653 | 387 |
2248995 | 2248995 | 2022-02-25 | Blount | Alabama | 1009 | 14734 | 217 |
2251526 | 2251526 | 2022-02-25 | Blount | Tennessee | 47009 | 38653 | 387 |
2245744 | 2245744 | 2022-02-24 | Blount | Alabama | 1009 | 14710 | 216 |
2248275 | 2248275 | 2022-02-24 | Blount | Tennessee | 47009 | 38653 | 387 |
2242493 | 2242493 | 2022-02-23 | Blount | Alabama | 1009 | 14706 | 216 |
2245024 | 2245024 | 2022-02-23 | Blount | Tennessee | 47009 | 38653 | 387 |
2239242 | 2239242 | 2022-02-22 | Blount | Alabama | 1009 | 14688 | 216 |
2241773 | 2241773 | 2022-02-22 | Blount | Tennessee | 47009 | 38344 | 375 |
2235991 | 2235991 | 2022-02-21 | Blount | Alabama | 1009 | 14682 | 216 |
2238522 | 2238522 | 2022-02-21 | Blount | Tennessee | 47009 | 38344 | 375 |
2232740 | 2232740 | 2022-02-20 | Blount | Alabama | 1009 | 14672 | 216 |
2235271 | 2235271 | 2022-02-20 | Blount | Tennessee | 47009 | 38344 | 375 |
2229489 | 2229489 | 2022-02-19 | Blount | Alabama | 1009 | 14663 | 216 |
2232020 | 2232020 | 2022-02-19 | Blount | Tennessee | 47009 | 38344 | 375 |
2226238 | 2226238 | 2022-02-18 | Blount | Alabama | 1009 | 14643 | 215 |
2228769 | 2228769 | 2022-02-18 | Blount | Tennessee | 47009 | 38344 | 375 |
2222987 | 2222987 | 2022-02-17 | Blount | Alabama | 1009 | 14632 | 215 |
2225518 | 2225518 | 2022-02-17 | Blount | Tennessee | 47009 | 38344 | 375 |
2219736 | 2219736 | 2022-02-16 | Blount | Alabama | 1009 | 14594 | 214 |
2222267 | 2222267 | 2022-02-16 | Blount | Tennessee | 47009 | 38344 | 375 |
2216486 | 2216486 | 2022-02-15 | Blount | Alabama | 1009 | 14575 | 213 |
2219016 | 2219016 | 2022-02-15 | Blount | Tennessee | 47009 | 37570 | 367 |
2213235 | 2213235 | 2022-02-14 | Blount | Alabama | 1009 | 14564 | 213 |
2215765 | 2215765 | 2022-02-14 | Blount | Tennessee | 47009 | 37570 | 367 |
2209982 | 2209982 | 2022-02-13 | Blount | Alabama | 1009 | 14556 | 213 |
2212514 | 2212514 | 2022-02-13 | Blount | Tennessee | 47009 | 37570 | 367 |
2206729 | 2206729 | 2022-02-12 | Blount | Alabama | 1009 | 14545 | 213 |
2209261 | 2209261 | 2022-02-12 | Blount | Tennessee | 47009 | 37570 | 367 |
2203476 | 2203476 | 2022-02-11 | Blount | Alabama | 1009 | 14516 | 212 |
2206008 | 2206008 | 2022-02-11 | Blount | Tennessee | 47009 | 37570 | 367 |
2200222 | 2200222 | 2022-02-10 | Blount | Alabama | 1009 | 14493 | 212 |
2202755 | 2202755 | 2022-02-10 | Blount | Tennessee | 47009 | 37570 | 367 |
2196968 | 2196968 | 2022-02-09 | Blount | Alabama | 1009 | 14447 | 212 |
2199501 | 2199501 | 2022-02-09 | Blount | Tennessee | 47009 | 37570 | 367 |
2193713 | 2193713 | 2022-02-08 | Blount | Alabama | 1009 | 14417 | 211 |
2196247 | 2196247 | 2022-02-08 | Blount | Tennessee | 47009 | 35689 | 357 |
2190460 | 2190460 | 2022-02-07 | Blount | Alabama | 1009 | 14366 | 211 |
2192993 | 2192993 | 2022-02-07 | Blount | Tennessee | 47009 | 35689 | 357 |
2187207 | 2187207 | 2022-02-06 | Blount | Alabama | 1009 | 14329 | 210 |
2189739 | 2189739 | 2022-02-06 | Blount | Tennessee | 47009 | 35689 | 357 |
2183954 | 2183954 | 2022-02-05 | Blount | Alabama | 1009 | 14329 | 210 |
2186486 | 2186486 | 2022-02-05 | Blount | Tennessee | 47009 | 35689 | 357 |
2180702 | 2180702 | 2022-02-04 | Blount | Alabama | 1009 | 14299 | 210 |
2183234 | 2183234 | 2022-02-04 | Blount | Tennessee | 47009 | 35689 | 357 |
2177451 | 2177451 | 2022-02-03 | Blount | Alabama | 1009 | 14158 | 208 |
2179982 | 2179982 | 2022-02-03 | Blount | Tennessee | 47009 | 35689 | 357 |
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);