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)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499579 | 2499579 | 2022-05-13 | Blount | Alabama | 1009 | 15005 | 243 |
2502115 | 2502115 | 2022-05-13 | Blount | Tennessee | 47009 | 39310 | 440 |
2496321 | 2496321 | 2022-05-12 | Blount | Alabama | 1009 | 15004 | 243 |
2498857 | 2498857 | 2022-05-12 | Blount | Tennessee | 47009 | 39310 | 440 |
2493063 | 2493063 | 2022-05-11 | Blount | Alabama | 1009 | 14999 | 243 |
2495599 | 2495599 | 2022-05-11 | Blount | Tennessee | 47009 | 39310 | 440 |
2489805 | 2489805 | 2022-05-10 | Blount | Alabama | 1009 | 14994 | 243 |
2492341 | 2492341 | 2022-05-10 | Blount | Tennessee | 47009 | 39251 | 439 |
2486548 | 2486548 | 2022-05-09 | Blount | Alabama | 1009 | 14988 | 243 |
2489083 | 2489083 | 2022-05-09 | Blount | Tennessee | 47009 | 39251 | 439 |
2483290 | 2483290 | 2022-05-08 | Blount | Alabama | 1009 | 14985 | 243 |
2485826 | 2485826 | 2022-05-08 | Blount | Tennessee | 47009 | 39251 | 439 |
2480032 | 2480032 | 2022-05-07 | Blount | Alabama | 1009 | 14985 | 243 |
2482568 | 2482568 | 2022-05-07 | Blount | Tennessee | 47009 | 39251 | 439 |
2476774 | 2476774 | 2022-05-06 | Blount | Alabama | 1009 | 14985 | 243 |
2479310 | 2479310 | 2022-05-06 | Blount | Tennessee | 47009 | 39251 | 439 |
2473516 | 2473516 | 2022-05-05 | Blount | Alabama | 1009 | 14985 | 243 |
2476052 | 2476052 | 2022-05-05 | Blount | Tennessee | 47009 | 39251 | 439 |
2470259 | 2470259 | 2022-05-04 | Blount | Alabama | 1009 | 14983 | 243 |
2472795 | 2472795 | 2022-05-04 | Blount | Tennessee | 47009 | 39251 | 439 |
2467003 | 2467003 | 2022-05-03 | Blount | Alabama | 1009 | 14981 | 243 |
2469539 | 2469539 | 2022-05-03 | Blount | Tennessee | 47009 | 39189 | 438 |
2463748 | 2463748 | 2022-05-02 | Blount | Alabama | 1009 | 14979 | 243 |
2466283 | 2466283 | 2022-05-02 | Blount | Tennessee | 47009 | 39189 | 438 |
2460492 | 2460492 | 2022-05-01 | Blount | Alabama | 1009 | 14980 | 243 |
2463028 | 2463028 | 2022-05-01 | Blount | Tennessee | 47009 | 39189 | 438 |
2457236 | 2457236 | 2022-04-30 | Blount | Alabama | 1009 | 14980 | 243 |
2459772 | 2459772 | 2022-04-30 | Blount | Tennessee | 47009 | 39189 | 438 |
2453980 | 2453980 | 2022-04-29 | Blount | Alabama | 1009 | 14980 | 243 |
2456516 | 2456516 | 2022-04-29 | Blount | Tennessee | 47009 | 39189 | 438 |
2450724 | 2450724 | 2022-04-28 | Blount | Alabama | 1009 | 14977 | 243 |
2453260 | 2453260 | 2022-04-28 | Blount | Tennessee | 47009 | 39189 | 438 |
2447468 | 2447468 | 2022-04-27 | Blount | Alabama | 1009 | 14976 | 243 |
2450004 | 2450004 | 2022-04-27 | Blount | Tennessee | 47009 | 39189 | 438 |
2444212 | 2444212 | 2022-04-26 | Blount | Alabama | 1009 | 14968 | 243 |
2446747 | 2446747 | 2022-04-26 | Blount | Tennessee | 47009 | 39149 | 436 |
2440956 | 2440956 | 2022-04-25 | Blount | Alabama | 1009 | 14967 | 243 |
2443492 | 2443492 | 2022-04-25 | Blount | Tennessee | 47009 | 39149 | 436 |
2437700 | 2437700 | 2022-04-24 | Blount | Alabama | 1009 | 14967 | 243 |
2440236 | 2440236 | 2022-04-24 | Blount | Tennessee | 47009 | 39149 | 436 |
2434444 | 2434444 | 2022-04-23 | Blount | Alabama | 1009 | 14967 | 243 |
2436980 | 2436980 | 2022-04-23 | Blount | Tennessee | 47009 | 39149 | 436 |
2431188 | 2431188 | 2022-04-22 | Blount | Alabama | 1009 | 14967 | 243 |
2433724 | 2433724 | 2022-04-22 | Blount | Tennessee | 47009 | 39149 | 436 |
2427932 | 2427932 | 2022-04-21 | Blount | Alabama | 1009 | 14967 | 243 |
2430468 | 2430468 | 2022-04-21 | Blount | Tennessee | 47009 | 39149 | 436 |
2424676 | 2424676 | 2022-04-20 | Blount | Alabama | 1009 | 14963 | 243 |
2427212 | 2427212 | 2022-04-20 | Blount | Tennessee | 47009 | 39149 | 436 |
2421420 | 2421420 | 2022-04-19 | Blount | Alabama | 1009 | 14961 | 243 |
2423956 | 2423956 | 2022-04-19 | Blount | Tennessee | 47009 | 39108 | 432 |
2418164 | 2418164 | 2022-04-18 | Blount | Alabama | 1009 | 14959 | 242 |
2420700 | 2420700 | 2022-04-18 | Blount | Tennessee | 47009 | 39108 | 432 |
2414908 | 2414908 | 2022-04-17 | Blount | Alabama | 1009 | 14959 | 242 |
2417444 | 2417444 | 2022-04-17 | Blount | Tennessee | 47009 | 39108 | 432 |
2411652 | 2411652 | 2022-04-16 | Blount | Alabama | 1009 | 14959 | 242 |
2414188 | 2414188 | 2022-04-16 | Blount | Tennessee | 47009 | 39108 | 432 |
2408396 | 2408396 | 2022-04-15 | Blount | Alabama | 1009 | 14959 | 242 |
2410932 | 2410932 | 2022-04-15 | Blount | Tennessee | 47009 | 39108 | 432 |
2405140 | 2405140 | 2022-04-14 | Blount | Alabama | 1009 | 14953 | 241 |
2407676 | 2407676 | 2022-04-14 | Blount | Tennessee | 47009 | 39108 | 432 |
2401885 | 2401885 | 2022-04-13 | Blount | Alabama | 1009 | 14935 | 241 |
2404420 | 2404420 | 2022-04-13 | Blount | Tennessee | 47009 | 39108 | 432 |
2398630 | 2398630 | 2022-04-12 | Blount | Alabama | 1009 | 14934 | 241 |
2401165 | 2401165 | 2022-04-12 | Blount | Tennessee | 47009 | 39079 | 420 |
2395375 | 2395375 | 2022-04-11 | Blount | Alabama | 1009 | 14934 | 239 |
2397910 | 2397910 | 2022-04-11 | Blount | Tennessee | 47009 | 39079 | 420 |
2392119 | 2392119 | 2022-04-10 | Blount | Alabama | 1009 | 14929 | 239 |
2394655 | 2394655 | 2022-04-10 | Blount | Tennessee | 47009 | 39079 | 420 |
2388863 | 2388863 | 2022-04-09 | Blount | Alabama | 1009 | 14929 | 239 |
2391399 | 2391399 | 2022-04-09 | Blount | Tennessee | 47009 | 39079 | 420 |
2385608 | 2385608 | 2022-04-08 | Blount | Alabama | 1009 | 14929 | 239 |
2388143 | 2388143 | 2022-04-08 | Blount | Tennessee | 47009 | 39079 | 420 |
2382353 | 2382353 | 2022-04-07 | Blount | Alabama | 1009 | 14926 | 239 |
2384888 | 2384888 | 2022-04-07 | Blount | Tennessee | 47009 | 39079 | 420 |
2379098 | 2379098 | 2022-04-06 | Blount | Alabama | 1009 | 14905 | 237 |
2381633 | 2381633 | 2022-04-06 | Blount | Tennessee | 47009 | 39079 | 420 |
2375844 | 2375844 | 2022-04-05 | Blount | Alabama | 1009 | 14903 | 237 |
2378378 | 2378378 | 2022-04-05 | Blount | Tennessee | 47009 | 39053 | 418 |
2372592 | 2372592 | 2022-04-04 | Blount | Alabama | 1009 | 14902 | 237 |
2375124 | 2375124 | 2022-04-04 | Blount | Tennessee | 47009 | 39053 | 418 |
2369339 | 2369339 | 2022-04-03 | Blount | Alabama | 1009 | 14901 | 237 |
2371872 | 2371872 | 2022-04-03 | Blount | Tennessee | 47009 | 39053 | 418 |
2366086 | 2366086 | 2022-04-02 | Blount | Alabama | 1009 | 14901 | 237 |
2368619 | 2368619 | 2022-04-02 | Blount | Tennessee | 47009 | 39053 | 418 |
2362833 | 2362833 | 2022-04-01 | Blount | Alabama | 1009 | 14901 | 237 |
2365366 | 2365366 | 2022-04-01 | Blount | Tennessee | 47009 | 39053 | 418 |
2359579 | 2359579 | 2022-03-31 | Blount | Alabama | 1009 | 14900 | 236 |
2362113 | 2362113 | 2022-03-31 | Blount | Tennessee | 47009 | 39053 | 418 |
2356325 | 2356325 | 2022-03-30 | Blount | Alabama | 1009 | 14899 | 236 |
2358859 | 2358859 | 2022-03-30 | Blount | Tennessee | 47009 | 39053 | 418 |
2353072 | 2353072 | 2022-03-29 | Blount | Alabama | 1009 | 14899 | 236 |
2355605 | 2355605 | 2022-03-29 | Blount | Tennessee | 47009 | 39027 | 418 |
2349820 | 2349820 | 2022-03-28 | Blount | Alabama | 1009 | 14898 | 235 |
2352352 | 2352352 | 2022-03-28 | Blount | Tennessee | 47009 | 39027 | 418 |
2346567 | 2346567 | 2022-03-27 | Blount | Alabama | 1009 | 14896 | 233 |
2349100 | 2349100 | 2022-03-27 | Blount | Tennessee | 47009 | 39027 | 418 |
2343314 | 2343314 | 2022-03-26 | Blount | Alabama | 1009 | 14896 | 233 |
2345847 | 2345847 | 2022-03-26 | Blount | Tennessee | 47009 | 39027 | 418 |
2340061 | 2340061 | 2022-03-25 | Blount | Alabama | 1009 | 14896 | 233 |
2342594 | 2342594 | 2022-03-25 | Blount | Tennessee | 47009 | 39027 | 418 |
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);