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

781 rows where county = "Lincoln" 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 · 781 ✖

fips 1

county 1

  • Lincoln · 781 ✖
Link rowid date ▲ county state fips cases deaths
2502162 2502162 2022-05-13 Lincoln Tennessee 47103 10003 170
2498904 2498904 2022-05-12 Lincoln Tennessee 47103 10003 170
2495646 2495646 2022-05-11 Lincoln Tennessee 47103 10003 170
2492388 2492388 2022-05-10 Lincoln Tennessee 47103 9997 170
2489130 2489130 2022-05-09 Lincoln Tennessee 47103 9997 170
2485873 2485873 2022-05-08 Lincoln Tennessee 47103 9997 170
2482615 2482615 2022-05-07 Lincoln Tennessee 47103 9997 170
2479357 2479357 2022-05-06 Lincoln Tennessee 47103 9997 170
2476099 2476099 2022-05-05 Lincoln Tennessee 47103 9997 170
2472842 2472842 2022-05-04 Lincoln Tennessee 47103 9997 170
2469586 2469586 2022-05-03 Lincoln Tennessee 47103 9988 170
2466330 2466330 2022-05-02 Lincoln Tennessee 47103 9988 170
2463075 2463075 2022-05-01 Lincoln Tennessee 47103 9988 170
2459819 2459819 2022-04-30 Lincoln Tennessee 47103 9988 170
2456563 2456563 2022-04-29 Lincoln Tennessee 47103 9988 170
2453307 2453307 2022-04-28 Lincoln Tennessee 47103 9988 170
2450051 2450051 2022-04-27 Lincoln Tennessee 47103 9988 170
2446794 2446794 2022-04-26 Lincoln Tennessee 47103 9980 170
2443539 2443539 2022-04-25 Lincoln Tennessee 47103 9980 170
2440283 2440283 2022-04-24 Lincoln Tennessee 47103 9980 170
2437027 2437027 2022-04-23 Lincoln Tennessee 47103 9980 170
2433771 2433771 2022-04-22 Lincoln Tennessee 47103 9980 170
2430515 2430515 2022-04-21 Lincoln Tennessee 47103 9980 170
2427259 2427259 2022-04-20 Lincoln Tennessee 47103 9980 170
2424003 2424003 2022-04-19 Lincoln Tennessee 47103 9976 170
2420747 2420747 2022-04-18 Lincoln Tennessee 47103 9976 170
2417491 2417491 2022-04-17 Lincoln Tennessee 47103 9976 170
2414235 2414235 2022-04-16 Lincoln Tennessee 47103 9976 170
2410979 2410979 2022-04-15 Lincoln Tennessee 47103 9976 170
2407723 2407723 2022-04-14 Lincoln Tennessee 47103 9976 170
2404467 2404467 2022-04-13 Lincoln Tennessee 47103 9976 170
2401212 2401212 2022-04-12 Lincoln Tennessee 47103 9976 167
2397957 2397957 2022-04-11 Lincoln Tennessee 47103 9976 167
2394702 2394702 2022-04-10 Lincoln Tennessee 47103 9976 167
2391446 2391446 2022-04-09 Lincoln Tennessee 47103 9976 167
2388190 2388190 2022-04-08 Lincoln Tennessee 47103 9976 167
2384935 2384935 2022-04-07 Lincoln Tennessee 47103 9976 167
2381680 2381680 2022-04-06 Lincoln Tennessee 47103 9976 167
2378425 2378425 2022-04-05 Lincoln Tennessee 47103 9980 166
2375171 2375171 2022-04-04 Lincoln Tennessee 47103 9980 166
2371919 2371919 2022-04-03 Lincoln Tennessee 47103 9980 166
2368666 2368666 2022-04-02 Lincoln Tennessee 47103 9980 166
2365413 2365413 2022-04-01 Lincoln Tennessee 47103 9980 166
2362160 2362160 2022-03-31 Lincoln Tennessee 47103 9980 166
2358906 2358906 2022-03-30 Lincoln Tennessee 47103 9980 166
2355652 2355652 2022-03-29 Lincoln Tennessee 47103 9973 166
2352399 2352399 2022-03-28 Lincoln Tennessee 47103 9973 166
2349147 2349147 2022-03-27 Lincoln Tennessee 47103 9973 166
2345894 2345894 2022-03-26 Lincoln Tennessee 47103 9973 166
2342641 2342641 2022-03-25 Lincoln Tennessee 47103 9973 166
2339388 2339388 2022-03-24 Lincoln Tennessee 47103 9973 166
2336134 2336134 2022-03-23 Lincoln Tennessee 47103 9973 166
2332880 2332880 2022-03-22 Lincoln Tennessee 47103 9968 163
2329627 2329627 2022-03-21 Lincoln Tennessee 47103 9968 163
2326375 2326375 2022-03-20 Lincoln Tennessee 47103 9968 163
2323122 2323122 2022-03-19 Lincoln Tennessee 47103 9968 163
2319868 2319868 2022-03-18 Lincoln Tennessee 47103 9968 163
2316614 2316614 2022-03-17 Lincoln Tennessee 47103 9968 163
2313361 2313361 2022-03-16 Lincoln Tennessee 47103 9968 163
2310108 2310108 2022-03-15 Lincoln Tennessee 47103 9949 157
2306855 2306855 2022-03-14 Lincoln Tennessee 47103 9949 157
2303604 2303604 2022-03-13 Lincoln Tennessee 47103 9949 157
2300352 2300352 2022-03-12 Lincoln Tennessee 47103 9949 157
2297100 2297100 2022-03-11 Lincoln Tennessee 47103 9949 157
2293848 2293848 2022-03-10 Lincoln Tennessee 47103 9949 157
2290596 2290596 2022-03-09 Lincoln Tennessee 47103 9949 157
2287344 2287344 2022-03-08 Lincoln Tennessee 47103 9923 154
2284092 2284092 2022-03-07 Lincoln Tennessee 47103 9923 154
2280840 2280840 2022-03-06 Lincoln Tennessee 47103 9923 154
2277587 2277587 2022-03-05 Lincoln Tennessee 47103 9923 154
2274334 2274334 2022-03-04 Lincoln Tennessee 47103 9923 154
2271081 2271081 2022-03-03 Lincoln Tennessee 47103 9923 154
2267829 2267829 2022-03-02 Lincoln Tennessee 47103 9923 154
2264576 2264576 2022-03-01 Lincoln Tennessee 47103 9882 145
2261326 2261326 2022-02-28 Lincoln Tennessee 47103 9882 145
2258075 2258075 2022-02-27 Lincoln Tennessee 47103 9882 145
2254824 2254824 2022-02-26 Lincoln Tennessee 47103 9882 145
2251573 2251573 2022-02-25 Lincoln Tennessee 47103 9882 145
2248322 2248322 2022-02-24 Lincoln Tennessee 47103 9882 145
2245071 2245071 2022-02-23 Lincoln Tennessee 47103 9882 145
2241820 2241820 2022-02-22 Lincoln Tennessee 47103 9795 140
2238569 2238569 2022-02-21 Lincoln Tennessee 47103 9795 140
2235318 2235318 2022-02-20 Lincoln Tennessee 47103 9795 140
2232067 2232067 2022-02-19 Lincoln Tennessee 47103 9795 140
2228816 2228816 2022-02-18 Lincoln Tennessee 47103 9795 140
2225565 2225565 2022-02-17 Lincoln Tennessee 47103 9795 140
2222314 2222314 2022-02-16 Lincoln Tennessee 47103 9795 140
2219063 2219063 2022-02-15 Lincoln Tennessee 47103 9661 139
2215812 2215812 2022-02-14 Lincoln Tennessee 47103 9661 139
2212561 2212561 2022-02-13 Lincoln Tennessee 47103 9661 139
2209308 2209308 2022-02-12 Lincoln Tennessee 47103 9661 139
2206055 2206055 2022-02-11 Lincoln Tennessee 47103 9661 139
2202802 2202802 2022-02-10 Lincoln Tennessee 47103 9661 139
2199548 2199548 2022-02-09 Lincoln Tennessee 47103 9661 139
2196294 2196294 2022-02-08 Lincoln Tennessee 47103 9310 137
2193040 2193040 2022-02-07 Lincoln Tennessee 47103 9310 137
2189786 2189786 2022-02-06 Lincoln Tennessee 47103 9310 137
2186533 2186533 2022-02-05 Lincoln Tennessee 47103 9310 137
2183281 2183281 2022-02-04 Lincoln Tennessee 47103 9310 137
2180029 2180029 2022-02-03 Lincoln Tennessee 47103 9310 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);