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

784 rows where county = "Carroll" 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 · 784 ✖

fips 1

county 1

  • Carroll · 784 ✖
Link rowid date ▲ county state fips cases deaths
2502119 2502119 2022-05-13 Carroll Tennessee 47017 8978 156
2498861 2498861 2022-05-12 Carroll Tennessee 47017 8978 156
2495603 2495603 2022-05-11 Carroll Tennessee 47017 8978 156
2492345 2492345 2022-05-10 Carroll Tennessee 47017 8972 156
2489087 2489087 2022-05-09 Carroll Tennessee 47017 8972 156
2485830 2485830 2022-05-08 Carroll Tennessee 47017 8972 156
2482572 2482572 2022-05-07 Carroll Tennessee 47017 8972 156
2479314 2479314 2022-05-06 Carroll Tennessee 47017 8972 156
2476056 2476056 2022-05-05 Carroll Tennessee 47017 8972 156
2472799 2472799 2022-05-04 Carroll Tennessee 47017 8972 156
2469543 2469543 2022-05-03 Carroll Tennessee 47017 8963 156
2466287 2466287 2022-05-02 Carroll Tennessee 47017 8963 156
2463032 2463032 2022-05-01 Carroll Tennessee 47017 8963 156
2459776 2459776 2022-04-30 Carroll Tennessee 47017 8963 156
2456520 2456520 2022-04-29 Carroll Tennessee 47017 8963 156
2453264 2453264 2022-04-28 Carroll Tennessee 47017 8963 156
2450008 2450008 2022-04-27 Carroll Tennessee 47017 8963 156
2446751 2446751 2022-04-26 Carroll Tennessee 47017 8957 156
2443496 2443496 2022-04-25 Carroll Tennessee 47017 8957 156
2440240 2440240 2022-04-24 Carroll Tennessee 47017 8957 156
2436984 2436984 2022-04-23 Carroll Tennessee 47017 8957 156
2433728 2433728 2022-04-22 Carroll Tennessee 47017 8957 156
2430472 2430472 2022-04-21 Carroll Tennessee 47017 8957 156
2427216 2427216 2022-04-20 Carroll Tennessee 47017 8957 156
2423960 2423960 2022-04-19 Carroll Tennessee 47017 8956 156
2420704 2420704 2022-04-18 Carroll Tennessee 47017 8956 156
2417448 2417448 2022-04-17 Carroll Tennessee 47017 8956 156
2414192 2414192 2022-04-16 Carroll Tennessee 47017 8956 156
2410936 2410936 2022-04-15 Carroll Tennessee 47017 8956 156
2407680 2407680 2022-04-14 Carroll Tennessee 47017 8956 156
2404424 2404424 2022-04-13 Carroll Tennessee 47017 8956 156
2401169 2401169 2022-04-12 Carroll Tennessee 47017 8948 156
2397914 2397914 2022-04-11 Carroll Tennessee 47017 8948 156
2394659 2394659 2022-04-10 Carroll Tennessee 47017 8948 156
2391403 2391403 2022-04-09 Carroll Tennessee 47017 8948 156
2388147 2388147 2022-04-08 Carroll Tennessee 47017 8948 156
2384892 2384892 2022-04-07 Carroll Tennessee 47017 8948 156
2381637 2381637 2022-04-06 Carroll Tennessee 47017 8948 156
2378382 2378382 2022-04-05 Carroll Tennessee 47017 8947 156
2375128 2375128 2022-04-04 Carroll Tennessee 47017 8947 156
2371876 2371876 2022-04-03 Carroll Tennessee 47017 8947 156
2368623 2368623 2022-04-02 Carroll Tennessee 47017 8947 156
2365370 2365370 2022-04-01 Carroll Tennessee 47017 8947 156
2362117 2362117 2022-03-31 Carroll Tennessee 47017 8947 156
2358863 2358863 2022-03-30 Carroll Tennessee 47017 8947 156
2355609 2355609 2022-03-29 Carroll Tennessee 47017 8940 155
2352356 2352356 2022-03-28 Carroll Tennessee 47017 8940 155
2349104 2349104 2022-03-27 Carroll Tennessee 47017 8940 155
2345851 2345851 2022-03-26 Carroll Tennessee 47017 8940 155
2342598 2342598 2022-03-25 Carroll Tennessee 47017 8940 155
2339345 2339345 2022-03-24 Carroll Tennessee 47017 8940 155
2336091 2336091 2022-03-23 Carroll Tennessee 47017 8940 155
2332837 2332837 2022-03-22 Carroll Tennessee 47017 8926 155
2329584 2329584 2022-03-21 Carroll Tennessee 47017 8926 155
2326332 2326332 2022-03-20 Carroll Tennessee 47017 8926 155
2323079 2323079 2022-03-19 Carroll Tennessee 47017 8926 155
2319825 2319825 2022-03-18 Carroll Tennessee 47017 8926 155
2316571 2316571 2022-03-17 Carroll Tennessee 47017 8926 155
2313318 2313318 2022-03-16 Carroll Tennessee 47017 8926 155
2310065 2310065 2022-03-15 Carroll Tennessee 47017 8914 150
2306812 2306812 2022-03-14 Carroll Tennessee 47017 8914 150
2303561 2303561 2022-03-13 Carroll Tennessee 47017 8914 150
2300309 2300309 2022-03-12 Carroll Tennessee 47017 8914 150
2297057 2297057 2022-03-11 Carroll Tennessee 47017 8914 150
2293805 2293805 2022-03-10 Carroll Tennessee 47017 8914 150
2290553 2290553 2022-03-09 Carroll Tennessee 47017 8914 150
2287301 2287301 2022-03-08 Carroll Tennessee 47017 8871 147
2284049 2284049 2022-03-07 Carroll Tennessee 47017 8871 147
2280797 2280797 2022-03-06 Carroll Tennessee 47017 8871 147
2277544 2277544 2022-03-05 Carroll Tennessee 47017 8871 147
2274291 2274291 2022-03-04 Carroll Tennessee 47017 8871 147
2271038 2271038 2022-03-03 Carroll Tennessee 47017 8871 147
2267786 2267786 2022-03-02 Carroll Tennessee 47017 8871 147
2264533 2264533 2022-03-01 Carroll Tennessee 47017 8811 145
2261283 2261283 2022-02-28 Carroll Tennessee 47017 8811 145
2258032 2258032 2022-02-27 Carroll Tennessee 47017 8811 145
2254781 2254781 2022-02-26 Carroll Tennessee 47017 8811 145
2251530 2251530 2022-02-25 Carroll Tennessee 47017 8811 145
2248279 2248279 2022-02-24 Carroll Tennessee 47017 8811 145
2245028 2245028 2022-02-23 Carroll Tennessee 47017 8811 145
2241777 2241777 2022-02-22 Carroll Tennessee 47017 8716 140
2238526 2238526 2022-02-21 Carroll Tennessee 47017 8716 140
2235275 2235275 2022-02-20 Carroll Tennessee 47017 8716 140
2232024 2232024 2022-02-19 Carroll Tennessee 47017 8716 140
2228773 2228773 2022-02-18 Carroll Tennessee 47017 8716 140
2225522 2225522 2022-02-17 Carroll Tennessee 47017 8716 140
2222271 2222271 2022-02-16 Carroll Tennessee 47017 8716 140
2219020 2219020 2022-02-15 Carroll Tennessee 47017 8576 137
2215769 2215769 2022-02-14 Carroll Tennessee 47017 8576 137
2212518 2212518 2022-02-13 Carroll Tennessee 47017 8576 137
2209265 2209265 2022-02-12 Carroll Tennessee 47017 8576 137
2206012 2206012 2022-02-11 Carroll Tennessee 47017 8576 137
2202759 2202759 2022-02-10 Carroll Tennessee 47017 8576 137
2199505 2199505 2022-02-09 Carroll Tennessee 47017 8576 137
2196251 2196251 2022-02-08 Carroll Tennessee 47017 8246 137
2192997 2192997 2022-02-07 Carroll Tennessee 47017 8246 137
2189743 2189743 2022-02-06 Carroll Tennessee 47017 8246 137
2186490 2186490 2022-02-05 Carroll Tennessee 47017 8246 137
2183238 2183238 2022-02-04 Carroll Tennessee 47017 8246 137
2179986 2179986 2022-02-03 Carroll Tennessee 47017 8246 137

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