ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

759 rows where county = "Moore" and state = "Tennessee" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Tennessee · 759 ✖

fips 1

county 1

  • Moore · 759 ✖
Link rowid date ▲ county state fips cases deaths
2502174 2502174 2022-05-13 Moore Tennessee 47127 2239 40
2498916 2498916 2022-05-12 Moore Tennessee 47127 2239 40
2495658 2495658 2022-05-11 Moore Tennessee 47127 2239 40
2492400 2492400 2022-05-10 Moore Tennessee 47127 2238 40
2489142 2489142 2022-05-09 Moore Tennessee 47127 2238 40
2485885 2485885 2022-05-08 Moore Tennessee 47127 2238 40
2482627 2482627 2022-05-07 Moore Tennessee 47127 2238 40
2479369 2479369 2022-05-06 Moore Tennessee 47127 2238 40
2476111 2476111 2022-05-05 Moore Tennessee 47127 2238 40
2472854 2472854 2022-05-04 Moore Tennessee 47127 2238 40
2469598 2469598 2022-05-03 Moore Tennessee 47127 2238 40
2466342 2466342 2022-05-02 Moore Tennessee 47127 2238 40
2463087 2463087 2022-05-01 Moore Tennessee 47127 2238 40
2459831 2459831 2022-04-30 Moore Tennessee 47127 2238 40
2456575 2456575 2022-04-29 Moore Tennessee 47127 2238 40
2453319 2453319 2022-04-28 Moore Tennessee 47127 2238 40
2450063 2450063 2022-04-27 Moore Tennessee 47127 2238 40
2446806 2446806 2022-04-26 Moore Tennessee 47127 2238 40
2443551 2443551 2022-04-25 Moore Tennessee 47127 2238 40
2440295 2440295 2022-04-24 Moore Tennessee 47127 2238 40
2437039 2437039 2022-04-23 Moore Tennessee 47127 2238 40
2433783 2433783 2022-04-22 Moore Tennessee 47127 2238 40
2430527 2430527 2022-04-21 Moore Tennessee 47127 2238 40
2427271 2427271 2022-04-20 Moore Tennessee 47127 2238 40
2424015 2424015 2022-04-19 Moore Tennessee 47127 2238 40
2420759 2420759 2022-04-18 Moore Tennessee 47127 2238 40
2417503 2417503 2022-04-17 Moore Tennessee 47127 2238 40
2414247 2414247 2022-04-16 Moore Tennessee 47127 2238 40
2410991 2410991 2022-04-15 Moore Tennessee 47127 2238 40
2407735 2407735 2022-04-14 Moore Tennessee 47127 2238 40
2404479 2404479 2022-04-13 Moore Tennessee 47127 2238 40
2401224 2401224 2022-04-12 Moore Tennessee 47127 2238 39
2397969 2397969 2022-04-11 Moore Tennessee 47127 2238 39
2394714 2394714 2022-04-10 Moore Tennessee 47127 2238 39
2391458 2391458 2022-04-09 Moore Tennessee 47127 2238 39
2388202 2388202 2022-04-08 Moore Tennessee 47127 2238 39
2384947 2384947 2022-04-07 Moore Tennessee 47127 2238 39
2381692 2381692 2022-04-06 Moore Tennessee 47127 2238 39
2378437 2378437 2022-04-05 Moore Tennessee 47127 2237 39
2375183 2375183 2022-04-04 Moore Tennessee 47127 2237 39
2371931 2371931 2022-04-03 Moore Tennessee 47127 2237 39
2368678 2368678 2022-04-02 Moore Tennessee 47127 2237 39
2365425 2365425 2022-04-01 Moore Tennessee 47127 2237 39
2362172 2362172 2022-03-31 Moore Tennessee 47127 2237 39
2358918 2358918 2022-03-30 Moore Tennessee 47127 2237 39
2355664 2355664 2022-03-29 Moore Tennessee 47127 2237 40
2352411 2352411 2022-03-28 Moore Tennessee 47127 2237 40
2349159 2349159 2022-03-27 Moore Tennessee 47127 2237 40
2345906 2345906 2022-03-26 Moore Tennessee 47127 2237 40
2342653 2342653 2022-03-25 Moore Tennessee 47127 2237 40
2339400 2339400 2022-03-24 Moore Tennessee 47127 2237 40
2336146 2336146 2022-03-23 Moore Tennessee 47127 2237 40
2332892 2332892 2022-03-22 Moore Tennessee 47127 2236 40
2329639 2329639 2022-03-21 Moore Tennessee 47127 2236 40
2326387 2326387 2022-03-20 Moore Tennessee 47127 2236 40
2323134 2323134 2022-03-19 Moore Tennessee 47127 2236 40
2319880 2319880 2022-03-18 Moore Tennessee 47127 2236 40
2316626 2316626 2022-03-17 Moore Tennessee 47127 2236 40
2313373 2313373 2022-03-16 Moore Tennessee 47127 2236 40
2310120 2310120 2022-03-15 Moore Tennessee 47127 2235 39
2306867 2306867 2022-03-14 Moore Tennessee 47127 2235 39
2303616 2303616 2022-03-13 Moore Tennessee 47127 2235 39
2300364 2300364 2022-03-12 Moore Tennessee 47127 2235 39
2297112 2297112 2022-03-11 Moore Tennessee 47127 2235 39
2293860 2293860 2022-03-10 Moore Tennessee 47127 2235 39
2290608 2290608 2022-03-09 Moore Tennessee 47127 2235 39
2287356 2287356 2022-03-08 Moore Tennessee 47127 2225 37
2284104 2284104 2022-03-07 Moore Tennessee 47127 2225 37
2280852 2280852 2022-03-06 Moore Tennessee 47127 2225 37
2277599 2277599 2022-03-05 Moore Tennessee 47127 2225 37
2274346 2274346 2022-03-04 Moore Tennessee 47127 2225 37
2271093 2271093 2022-03-03 Moore Tennessee 47127 2225 37
2267841 2267841 2022-03-02 Moore Tennessee 47127 2225 37
2264588 2264588 2022-03-01 Moore Tennessee 47127 2208 37
2261338 2261338 2022-02-28 Moore Tennessee 47127 2208 37
2258087 2258087 2022-02-27 Moore Tennessee 47127 2208 37
2254836 2254836 2022-02-26 Moore Tennessee 47127 2208 37
2251585 2251585 2022-02-25 Moore Tennessee 47127 2208 37
2248334 2248334 2022-02-24 Moore Tennessee 47127 2208 37
2245083 2245083 2022-02-23 Moore Tennessee 47127 2208 37
2241832 2241832 2022-02-22 Moore Tennessee 47127 2186 36
2238581 2238581 2022-02-21 Moore Tennessee 47127 2186 36
2235330 2235330 2022-02-20 Moore Tennessee 47127 2186 36
2232079 2232079 2022-02-19 Moore Tennessee 47127 2186 36
2228828 2228828 2022-02-18 Moore Tennessee 47127 2186 36
2225577 2225577 2022-02-17 Moore Tennessee 47127 2186 36
2222326 2222326 2022-02-16 Moore Tennessee 47127 2186 36
2219075 2219075 2022-02-15 Moore Tennessee 47127 2157 36
2215824 2215824 2022-02-14 Moore Tennessee 47127 2157 36
2212573 2212573 2022-02-13 Moore Tennessee 47127 2157 36
2209320 2209320 2022-02-12 Moore Tennessee 47127 2157 36
2206067 2206067 2022-02-11 Moore Tennessee 47127 2157 36
2202814 2202814 2022-02-10 Moore Tennessee 47127 2157 36
2199560 2199560 2022-02-09 Moore Tennessee 47127 2157 36
2196306 2196306 2022-02-08 Moore Tennessee 47127 2050 35
2193052 2193052 2022-02-07 Moore Tennessee 47127 2050 35
2189798 2189798 2022-02-06 Moore Tennessee 47127 2050 35
2186545 2186545 2022-02-05 Moore Tennessee 47127 2050 35
2183293 2183293 2022-02-04 Moore Tennessee 47127 2050 35
2180041 2180041 2022-02-03 Moore Tennessee 47127 2050 35

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);