home / covid

Menu
  • GraphQL API

ny_times_us_counties

Table actions
  • GraphQL API for ny_times_us_counties
⚠️ 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

772 rows where county = "Lincoln" and fips = 21137 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Kentucky 772

fips 1

  • 21137 · 772 ✖

county 1

  • Lincoln · 772 ✖
Link rowid date ▲ county state fips cases deaths
2500647 2500647 2022-05-13 Lincoln Kentucky 21137 6487 137
2497389 2497389 2022-05-12 Lincoln Kentucky 21137 6487 137
2494131 2494131 2022-05-11 Lincoln Kentucky 21137 6487 137
2490873 2490873 2022-05-10 Lincoln Kentucky 21137 6487 137
2487616 2487616 2022-05-09 Lincoln Kentucky 21137 6487 137
2484358 2484358 2022-05-08 Lincoln Kentucky 21137 6474 135
2481100 2481100 2022-05-07 Lincoln Kentucky 21137 6474 135
2477842 2477842 2022-05-06 Lincoln Kentucky 21137 6474 135
2474584 2474584 2022-05-05 Lincoln Kentucky 21137 6474 135
2471327 2471327 2022-05-04 Lincoln Kentucky 21137 6474 135
2468071 2468071 2022-05-03 Lincoln Kentucky 21137 6474 135
2464816 2464816 2022-05-02 Lincoln Kentucky 21137 6474 135
2461560 2461560 2022-05-01 Lincoln Kentucky 21137 6452 133
2458304 2458304 2022-04-30 Lincoln Kentucky 21137 6452 133
2455048 2455048 2022-04-29 Lincoln Kentucky 21137 6452 133
2451792 2451792 2022-04-28 Lincoln Kentucky 21137 6452 133
2448536 2448536 2022-04-27 Lincoln Kentucky 21137 6452 133
2445280 2445280 2022-04-26 Lincoln Kentucky 21137 6452 133
2442024 2442024 2022-04-25 Lincoln Kentucky 21137 6452 133
2438768 2438768 2022-04-24 Lincoln Kentucky 21137 6425 130
2435512 2435512 2022-04-23 Lincoln Kentucky 21137 6425 130
2432256 2432256 2022-04-22 Lincoln Kentucky 21137 6425 130
2429000 2429000 2022-04-21 Lincoln Kentucky 21137 6425 130
2425744 2425744 2022-04-20 Lincoln Kentucky 21137 6425 130
2422488 2422488 2022-04-19 Lincoln Kentucky 21137 6425 130
2419232 2419232 2022-04-18 Lincoln Kentucky 21137 6425 130
2415976 2415976 2022-04-17 Lincoln Kentucky 21137 6393 129
2412720 2412720 2022-04-16 Lincoln Kentucky 21137 6393 129
2409464 2409464 2022-04-15 Lincoln Kentucky 21137 6393 129
2406208 2406208 2022-04-14 Lincoln Kentucky 21137 6393 129
2402952 2402952 2022-04-13 Lincoln Kentucky 21137 6393 129
2399698 2399698 2022-04-12 Lincoln Kentucky 21137 6393 129
2396442 2396442 2022-04-11 Lincoln Kentucky 21137 6393 129
2393187 2393187 2022-04-10 Lincoln Kentucky 21137 6373 127
2389931 2389931 2022-04-09 Lincoln Kentucky 21137 6373 127
2386675 2386675 2022-04-08 Lincoln Kentucky 21137 6373 127
2383420 2383420 2022-04-07 Lincoln Kentucky 21137 6373 127
2380165 2380165 2022-04-06 Lincoln Kentucky 21137 6373 127
2376910 2376910 2022-04-05 Lincoln Kentucky 21137 6373 127
2373658 2373658 2022-04-04 Lincoln Kentucky 21137 6373 127
2370405 2370405 2022-04-03 Lincoln Kentucky 21137 6351 127
2367152 2367152 2022-04-02 Lincoln Kentucky 21137 6351 127
2363899 2363899 2022-04-01 Lincoln Kentucky 21137 6351 127
2360645 2360645 2022-03-31 Lincoln Kentucky 21137 6351 127
2357391 2357391 2022-03-30 Lincoln Kentucky 21137 6351 127
2354138 2354138 2022-03-29 Lincoln Kentucky 21137 6351 127
2350886 2350886 2022-03-28 Lincoln Kentucky 21137 6351 127
2347633 2347633 2022-03-27 Lincoln Kentucky 21137 6308 126
2344380 2344380 2022-03-26 Lincoln Kentucky 21137 6308 126
2341127 2341127 2022-03-25 Lincoln Kentucky 21137 6308 126
2337874 2337874 2022-03-24 Lincoln Kentucky 21137 6308 126
2334620 2334620 2022-03-23 Lincoln Kentucky 21137 6308 126
2331366 2331366 2022-03-22 Lincoln Kentucky 21137 6308 126
2328114 2328114 2022-03-21 Lincoln Kentucky 21137 6308 126
2324861 2324861 2022-03-20 Lincoln Kentucky 21137 6270 125
2321607 2321607 2022-03-19 Lincoln Kentucky 21137 6270 125
2318353 2318353 2022-03-18 Lincoln Kentucky 21137 6270 125
2315100 2315100 2022-03-17 Lincoln Kentucky 21137 6270 125
2311847 2311847 2022-03-16 Lincoln Kentucky 21137 6270 125
2308594 2308594 2022-03-15 Lincoln Kentucky 21137 6270 125
2305343 2305343 2022-03-14 Lincoln Kentucky 21137 6270 125
2302091 2302091 2022-03-13 Lincoln Kentucky 21137 6215 121
2298839 2298839 2022-03-12 Lincoln Kentucky 21137 6215 121
2295587 2295587 2022-03-11 Lincoln Kentucky 21137 6215 121
2292335 2292335 2022-03-10 Lincoln Kentucky 21137 6215 121
2289083 2289083 2022-03-09 Lincoln Kentucky 21137 6215 121
2285832 2285832 2022-03-08 Lincoln Kentucky 21137 6215 121
2282580 2282580 2022-03-07 Lincoln Kentucky 21137 6215 121
2279327 2279327 2022-03-06 Lincoln Kentucky 21137 6209 121
2276074 2276074 2022-03-05 Lincoln Kentucky 21137 6209 121
2272821 2272821 2022-03-04 Lincoln Kentucky 21137 6209 121
2269569 2269569 2022-03-03 Lincoln Kentucky 21137 6206 121
2266316 2266316 2022-03-02 Lincoln Kentucky 21137 6195 121
2263065 2263065 2022-03-01 Lincoln Kentucky 21137 6184 121
2259814 2259814 2022-02-28 Lincoln Kentucky 21137 6167 121
2256563 2256563 2022-02-27 Lincoln Kentucky 21137 6144 120
2253312 2253312 2022-02-26 Lincoln Kentucky 21137 6144 120
2250061 2250061 2022-02-25 Lincoln Kentucky 21137 6144 120
2246810 2246810 2022-02-24 Lincoln Kentucky 21137 6121 120
2243559 2243559 2022-02-23 Lincoln Kentucky 21137 6121 120
2240308 2240308 2022-02-22 Lincoln Kentucky 21137 6114 120
2237057 2237057 2022-02-21 Lincoln Kentucky 21137 6096 120
2233806 2233806 2022-02-20 Lincoln Kentucky 21137 6072 118
2230555 2230555 2022-02-19 Lincoln Kentucky 21137 6072 118
2227304 2227304 2022-02-18 Lincoln Kentucky 21137 6072 118
2224053 2224053 2022-02-17 Lincoln Kentucky 21137 6042 118
2220802 2220802 2022-02-16 Lincoln Kentucky 21137 6020 118
2217551 2217551 2022-02-15 Lincoln Kentucky 21137 5990 118
2214300 2214300 2022-02-14 Lincoln Kentucky 21137 5977 118
2211048 2211048 2022-02-13 Lincoln Kentucky 21137 5892 118
2207795 2207795 2022-02-12 Lincoln Kentucky 21137 5892 118
2204542 2204542 2022-02-11 Lincoln Kentucky 21137 5892 118
2201289 2201289 2022-02-10 Lincoln Kentucky 21137 5868 118
2198035 2198035 2022-02-09 Lincoln Kentucky 21137 5837 118
2194781 2194781 2022-02-08 Lincoln Kentucky 21137 5814 116
2191527 2191527 2022-02-07 Lincoln Kentucky 21137 5791 115
2188274 2188274 2022-02-06 Lincoln Kentucky 21137 5735 113
2185021 2185021 2022-02-05 Lincoln Kentucky 21137 5735 113
2181769 2181769 2022-02-04 Lincoln Kentucky 21137 5735 113
2178518 2178518 2022-02-03 Lincoln Kentucky 21137 5698 113

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);
Powered by Datasette · Queries took 183.151ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette