ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Lauderdale" and state = "Tennessee" 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 |
---|---|---|---|---|---|---|---|
2502159 | 2502159 | 2022-05-13 | Lauderdale | Tennessee | 47097 | 7764 | 106 |
2498901 | 2498901 | 2022-05-12 | Lauderdale | Tennessee | 47097 | 7764 | 106 |
2495643 | 2495643 | 2022-05-11 | Lauderdale | Tennessee | 47097 | 7764 | 106 |
2492385 | 2492385 | 2022-05-10 | Lauderdale | Tennessee | 47097 | 7752 | 106 |
2489127 | 2489127 | 2022-05-09 | Lauderdale | Tennessee | 47097 | 7752 | 106 |
2485870 | 2485870 | 2022-05-08 | Lauderdale | Tennessee | 47097 | 7752 | 106 |
2482612 | 2482612 | 2022-05-07 | Lauderdale | Tennessee | 47097 | 7752 | 106 |
2479354 | 2479354 | 2022-05-06 | Lauderdale | Tennessee | 47097 | 7752 | 106 |
2476096 | 2476096 | 2022-05-05 | Lauderdale | Tennessee | 47097 | 7752 | 106 |
2472839 | 2472839 | 2022-05-04 | Lauderdale | Tennessee | 47097 | 7752 | 106 |
2469583 | 2469583 | 2022-05-03 | Lauderdale | Tennessee | 47097 | 7746 | 105 |
2466327 | 2466327 | 2022-05-02 | Lauderdale | Tennessee | 47097 | 7746 | 105 |
2463072 | 2463072 | 2022-05-01 | Lauderdale | Tennessee | 47097 | 7746 | 105 |
2459816 | 2459816 | 2022-04-30 | Lauderdale | Tennessee | 47097 | 7746 | 105 |
2456560 | 2456560 | 2022-04-29 | Lauderdale | Tennessee | 47097 | 7746 | 105 |
2453304 | 2453304 | 2022-04-28 | Lauderdale | Tennessee | 47097 | 7746 | 105 |
2450048 | 2450048 | 2022-04-27 | Lauderdale | Tennessee | 47097 | 7746 | 105 |
2446791 | 2446791 | 2022-04-26 | Lauderdale | Tennessee | 47097 | 7743 | 105 |
2443536 | 2443536 | 2022-04-25 | Lauderdale | Tennessee | 47097 | 7743 | 105 |
2440280 | 2440280 | 2022-04-24 | Lauderdale | Tennessee | 47097 | 7743 | 105 |
2437024 | 2437024 | 2022-04-23 | Lauderdale | Tennessee | 47097 | 7743 | 105 |
2433768 | 2433768 | 2022-04-22 | Lauderdale | Tennessee | 47097 | 7743 | 105 |
2430512 | 2430512 | 2022-04-21 | Lauderdale | Tennessee | 47097 | 7743 | 105 |
2427256 | 2427256 | 2022-04-20 | Lauderdale | Tennessee | 47097 | 7743 | 105 |
2424000 | 2424000 | 2022-04-19 | Lauderdale | Tennessee | 47097 | 7742 | 104 |
2420744 | 2420744 | 2022-04-18 | Lauderdale | Tennessee | 47097 | 7742 | 104 |
2417488 | 2417488 | 2022-04-17 | Lauderdale | Tennessee | 47097 | 7742 | 104 |
2414232 | 2414232 | 2022-04-16 | Lauderdale | Tennessee | 47097 | 7742 | 104 |
2410976 | 2410976 | 2022-04-15 | Lauderdale | Tennessee | 47097 | 7742 | 104 |
2407720 | 2407720 | 2022-04-14 | Lauderdale | Tennessee | 47097 | 7742 | 104 |
2404464 | 2404464 | 2022-04-13 | Lauderdale | Tennessee | 47097 | 7742 | 104 |
2401209 | 2401209 | 2022-04-12 | Lauderdale | Tennessee | 47097 | 7737 | 103 |
2397954 | 2397954 | 2022-04-11 | Lauderdale | Tennessee | 47097 | 7737 | 103 |
2394699 | 2394699 | 2022-04-10 | Lauderdale | Tennessee | 47097 | 7737 | 103 |
2391443 | 2391443 | 2022-04-09 | Lauderdale | Tennessee | 47097 | 7737 | 103 |
2388187 | 2388187 | 2022-04-08 | Lauderdale | Tennessee | 47097 | 7737 | 103 |
2384932 | 2384932 | 2022-04-07 | Lauderdale | Tennessee | 47097 | 7737 | 103 |
2381677 | 2381677 | 2022-04-06 | Lauderdale | Tennessee | 47097 | 7737 | 103 |
2378422 | 2378422 | 2022-04-05 | Lauderdale | Tennessee | 47097 | 7738 | 103 |
2375168 | 2375168 | 2022-04-04 | Lauderdale | Tennessee | 47097 | 7738 | 103 |
2371916 | 2371916 | 2022-04-03 | Lauderdale | Tennessee | 47097 | 7738 | 103 |
2368663 | 2368663 | 2022-04-02 | Lauderdale | Tennessee | 47097 | 7738 | 103 |
2365410 | 2365410 | 2022-04-01 | Lauderdale | Tennessee | 47097 | 7738 | 103 |
2362157 | 2362157 | 2022-03-31 | Lauderdale | Tennessee | 47097 | 7738 | 103 |
2358903 | 2358903 | 2022-03-30 | Lauderdale | Tennessee | 47097 | 7738 | 103 |
2355649 | 2355649 | 2022-03-29 | Lauderdale | Tennessee | 47097 | 7733 | 103 |
2352396 | 2352396 | 2022-03-28 | Lauderdale | Tennessee | 47097 | 7733 | 103 |
2349144 | 2349144 | 2022-03-27 | Lauderdale | Tennessee | 47097 | 7733 | 103 |
2345891 | 2345891 | 2022-03-26 | Lauderdale | Tennessee | 47097 | 7733 | 103 |
2342638 | 2342638 | 2022-03-25 | Lauderdale | Tennessee | 47097 | 7733 | 103 |
2339385 | 2339385 | 2022-03-24 | Lauderdale | Tennessee | 47097 | 7733 | 103 |
2336131 | 2336131 | 2022-03-23 | Lauderdale | Tennessee | 47097 | 7733 | 103 |
2332877 | 2332877 | 2022-03-22 | Lauderdale | Tennessee | 47097 | 7729 | 103 |
2329624 | 2329624 | 2022-03-21 | Lauderdale | Tennessee | 47097 | 7729 | 103 |
2326372 | 2326372 | 2022-03-20 | Lauderdale | Tennessee | 47097 | 7729 | 103 |
2323119 | 2323119 | 2022-03-19 | Lauderdale | Tennessee | 47097 | 7729 | 103 |
2319865 | 2319865 | 2022-03-18 | Lauderdale | Tennessee | 47097 | 7729 | 103 |
2316611 | 2316611 | 2022-03-17 | Lauderdale | Tennessee | 47097 | 7729 | 103 |
2313358 | 2313358 | 2022-03-16 | Lauderdale | Tennessee | 47097 | 7729 | 103 |
2310105 | 2310105 | 2022-03-15 | Lauderdale | Tennessee | 47097 | 7713 | 99 |
2306852 | 2306852 | 2022-03-14 | Lauderdale | Tennessee | 47097 | 7713 | 99 |
2303601 | 2303601 | 2022-03-13 | Lauderdale | Tennessee | 47097 | 7713 | 99 |
2300349 | 2300349 | 2022-03-12 | Lauderdale | Tennessee | 47097 | 7713 | 99 |
2297097 | 2297097 | 2022-03-11 | Lauderdale | Tennessee | 47097 | 7713 | 99 |
2293845 | 2293845 | 2022-03-10 | Lauderdale | Tennessee | 47097 | 7713 | 99 |
2290593 | 2290593 | 2022-03-09 | Lauderdale | Tennessee | 47097 | 7713 | 99 |
2287341 | 2287341 | 2022-03-08 | Lauderdale | Tennessee | 47097 | 7692 | 99 |
2284089 | 2284089 | 2022-03-07 | Lauderdale | Tennessee | 47097 | 7692 | 99 |
2280837 | 2280837 | 2022-03-06 | Lauderdale | Tennessee | 47097 | 7692 | 99 |
2277584 | 2277584 | 2022-03-05 | Lauderdale | Tennessee | 47097 | 7692 | 99 |
2274331 | 2274331 | 2022-03-04 | Lauderdale | Tennessee | 47097 | 7692 | 99 |
2271078 | 2271078 | 2022-03-03 | Lauderdale | Tennessee | 47097 | 7692 | 99 |
2267826 | 2267826 | 2022-03-02 | Lauderdale | Tennessee | 47097 | 7692 | 99 |
2264573 | 2264573 | 2022-03-01 | Lauderdale | Tennessee | 47097 | 7648 | 92 |
2261323 | 2261323 | 2022-02-28 | Lauderdale | Tennessee | 47097 | 7648 | 92 |
2258072 | 2258072 | 2022-02-27 | Lauderdale | Tennessee | 47097 | 7648 | 92 |
2254821 | 2254821 | 2022-02-26 | Lauderdale | Tennessee | 47097 | 7648 | 92 |
2251570 | 2251570 | 2022-02-25 | Lauderdale | Tennessee | 47097 | 7648 | 92 |
2248319 | 2248319 | 2022-02-24 | Lauderdale | Tennessee | 47097 | 7648 | 92 |
2245068 | 2245068 | 2022-02-23 | Lauderdale | Tennessee | 47097 | 7648 | 92 |
2241817 | 2241817 | 2022-02-22 | Lauderdale | Tennessee | 47097 | 7603 | 91 |
2238566 | 2238566 | 2022-02-21 | Lauderdale | Tennessee | 47097 | 7603 | 91 |
2235315 | 2235315 | 2022-02-20 | Lauderdale | Tennessee | 47097 | 7603 | 91 |
2232064 | 2232064 | 2022-02-19 | Lauderdale | Tennessee | 47097 | 7603 | 91 |
2228813 | 2228813 | 2022-02-18 | Lauderdale | Tennessee | 47097 | 7603 | 91 |
2225562 | 2225562 | 2022-02-17 | Lauderdale | Tennessee | 47097 | 7603 | 91 |
2222311 | 2222311 | 2022-02-16 | Lauderdale | Tennessee | 47097 | 7603 | 91 |
2219060 | 2219060 | 2022-02-15 | Lauderdale | Tennessee | 47097 | 7500 | 90 |
2215809 | 2215809 | 2022-02-14 | Lauderdale | Tennessee | 47097 | 7500 | 90 |
2212558 | 2212558 | 2022-02-13 | Lauderdale | Tennessee | 47097 | 7500 | 90 |
2209305 | 2209305 | 2022-02-12 | Lauderdale | Tennessee | 47097 | 7500 | 90 |
2206052 | 2206052 | 2022-02-11 | Lauderdale | Tennessee | 47097 | 7500 | 90 |
2202799 | 2202799 | 2022-02-10 | Lauderdale | Tennessee | 47097 | 7500 | 90 |
2199545 | 2199545 | 2022-02-09 | Lauderdale | Tennessee | 47097 | 7500 | 90 |
2196291 | 2196291 | 2022-02-08 | Lauderdale | Tennessee | 47097 | 7303 | 86 |
2193037 | 2193037 | 2022-02-07 | Lauderdale | Tennessee | 47097 | 7303 | 86 |
2189783 | 2189783 | 2022-02-06 | Lauderdale | Tennessee | 47097 | 7303 | 86 |
2186530 | 2186530 | 2022-02-05 | Lauderdale | Tennessee | 47097 | 7303 | 86 |
2183278 | 2183278 | 2022-02-04 | Lauderdale | Tennessee | 47097 | 7303 | 86 |
2180026 | 2180026 | 2022-02-03 | Lauderdale | Tennessee | 47097 | 7303 | 86 |
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);