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

779 rows where county = "Lincoln" and state = "Oklahoma" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Oklahoma · 779 ✖

fips 1

county 1

  • Lincoln · 779 ✖
Link rowid date ▲ county state fips cases deaths
2501773 2501773 2022-05-13 Lincoln Oklahoma 40081 7897 140
2498515 2498515 2022-05-12 Lincoln Oklahoma 40081 7897 140
2495257 2495257 2022-05-11 Lincoln Oklahoma 40081 7887 140
2491999 2491999 2022-05-10 Lincoln Oklahoma 40081 7887 140
2488741 2488741 2022-05-09 Lincoln Oklahoma 40081 7887 140
2485484 2485484 2022-05-08 Lincoln Oklahoma 40081 7887 140
2482226 2482226 2022-05-07 Lincoln Oklahoma 40081 7887 140
2478968 2478968 2022-05-06 Lincoln Oklahoma 40081 7887 140
2475710 2475710 2022-05-05 Lincoln Oklahoma 40081 7887 140
2472453 2472453 2022-05-04 Lincoln Oklahoma 40081 7883 138
2469197 2469197 2022-05-03 Lincoln Oklahoma 40081 7883 138
2465941 2465941 2022-05-02 Lincoln Oklahoma 40081 7883 138
2462686 2462686 2022-05-01 Lincoln Oklahoma 40081 7883 138
2459430 2459430 2022-04-30 Lincoln Oklahoma 40081 7883 138
2456174 2456174 2022-04-29 Lincoln Oklahoma 40081 7883 138
2452918 2452918 2022-04-28 Lincoln Oklahoma 40081 7883 138
2449662 2449662 2022-04-27 Lincoln Oklahoma 40081 7872 138
2446405 2446405 2022-04-26 Lincoln Oklahoma 40081 7872 138
2443150 2443150 2022-04-25 Lincoln Oklahoma 40081 7872 138
2439894 2439894 2022-04-24 Lincoln Oklahoma 40081 7872 138
2436638 2436638 2022-04-23 Lincoln Oklahoma 40081 7872 138
2433382 2433382 2022-04-22 Lincoln Oklahoma 40081 7872 138
2430126 2430126 2022-04-21 Lincoln Oklahoma 40081 7872 138
2426870 2426870 2022-04-20 Lincoln Oklahoma 40081 7857 138
2423614 2423614 2022-04-19 Lincoln Oklahoma 40081 7857 138
2420357 2420357 2022-04-18 Lincoln Oklahoma 40081 7857 138
2417102 2417102 2022-04-17 Lincoln Oklahoma 40081 7857 138
2413846 2413846 2022-04-16 Lincoln Oklahoma 40081 7857 138
2410590 2410590 2022-04-15 Lincoln Oklahoma 40081 7857 138
2407334 2407334 2022-04-14 Lincoln Oklahoma 40081 7857 138
2404078 2404078 2022-04-13 Lincoln Oklahoma 40081 7848 138
2400823 2400823 2022-04-12 Lincoln Oklahoma 40081 7848 138
2397568 2397568 2022-04-11 Lincoln Oklahoma 40081 7848 138
2394313 2394313 2022-04-10 Lincoln Oklahoma 40081 7848 138
2391057 2391057 2022-04-09 Lincoln Oklahoma 40081 7848 138
2387801 2387801 2022-04-08 Lincoln Oklahoma 40081 7848 138
2384546 2384546 2022-04-07 Lincoln Oklahoma 40081 7848 138
2381291 2381291 2022-04-06 Lincoln Oklahoma 40081 7842 135
2378036 2378036 2022-04-05 Lincoln Oklahoma 40081 7842 135
2374782 2374782 2022-04-04 Lincoln Oklahoma 40081 7842 135
2371530 2371530 2022-04-03 Lincoln Oklahoma 40081 7842 135
2368277 2368277 2022-04-02 Lincoln Oklahoma 40081 7842 135
2365024 2365024 2022-04-01 Lincoln Oklahoma 40081 7842 135
2361771 2361771 2022-03-31 Lincoln Oklahoma 40081 7842 135
2358517 2358517 2022-03-30 Lincoln Oklahoma 40081 7839 135
2355263 2355263 2022-03-29 Lincoln Oklahoma 40081 7839 135
2352010 2352010 2022-03-28 Lincoln Oklahoma 40081 7839 135
2348758 2348758 2022-03-27 Lincoln Oklahoma 40081 7839 135
2345505 2345505 2022-03-26 Lincoln Oklahoma 40081 7839 135
2342252 2342252 2022-03-25 Lincoln Oklahoma 40081 7839 135
2338999 2338999 2022-03-24 Lincoln Oklahoma 40081 7839 135
2335745 2335745 2022-03-23 Lincoln Oklahoma 40081 7819 130
2332491 2332491 2022-03-22 Lincoln Oklahoma 40081 7819 130
2329238 2329238 2022-03-21 Lincoln Oklahoma 40081 7819 130
2325986 2325986 2022-03-20 Lincoln Oklahoma 40081 7819 130
2322733 2322733 2022-03-19 Lincoln Oklahoma 40081 7819 130
2319479 2319479 2022-03-18 Lincoln Oklahoma 40081 7819 130
2316225 2316225 2022-03-17 Lincoln Oklahoma 40081 7819 130
2312972 2312972 2022-03-16 Lincoln Oklahoma 40081 7810 129
2309719 2309719 2022-03-15 Lincoln Oklahoma 40081 7810 129
2306466 2306466 2022-03-14 Lincoln Oklahoma 40081 7810 129
2303215 2303215 2022-03-13 Lincoln Oklahoma 40081 7810 129
2299963 2299963 2022-03-12 Lincoln Oklahoma 40081 7810 129
2296711 2296711 2022-03-11 Lincoln Oklahoma 40081 7810 129
2293459 2293459 2022-03-10 Lincoln Oklahoma 40081 7810 129
2290207 2290207 2022-03-09 Lincoln Oklahoma 40081 7772 127
2286955 2286955 2022-03-08 Lincoln Oklahoma 40081 7772 127
2283703 2283703 2022-03-07 Lincoln Oklahoma 40081 7772 127
2280451 2280451 2022-03-06 Lincoln Oklahoma 40081 7772 127
2277198 2277198 2022-03-05 Lincoln Oklahoma 40081 7772 127
2273945 2273945 2022-03-04 Lincoln Oklahoma 40081 7772 127
2270692 2270692 2022-03-03 Lincoln Oklahoma 40081 7772 127
2267440 2267440 2022-03-02 Lincoln Oklahoma 40081 7772 127
2264187 2264187 2022-03-01 Lincoln Oklahoma 40081 7710 124
2260937 2260937 2022-02-28 Lincoln Oklahoma 40081 7710 124
2257686 2257686 2022-02-27 Lincoln Oklahoma 40081 7710 124
2254435 2254435 2022-02-26 Lincoln Oklahoma 40081 7710 124
2251184 2251184 2022-02-25 Lincoln Oklahoma 40081 7710 124
2247933 2247933 2022-02-24 Lincoln Oklahoma 40081 7710 124
2244682 2244682 2022-02-23 Lincoln Oklahoma 40081 7710 124
2241431 2241431 2022-02-22 Lincoln Oklahoma 40081 7664 123
2238180 2238180 2022-02-21 Lincoln Oklahoma 40081 7664 123
2234929 2234929 2022-02-20 Lincoln Oklahoma 40081 7664 123
2231678 2231678 2022-02-19 Lincoln Oklahoma 40081 7664 123
2228427 2228427 2022-02-18 Lincoln Oklahoma 40081 7664 123
2225176 2225176 2022-02-17 Lincoln Oklahoma 40081 7664 123
2221925 2221925 2022-02-16 Lincoln Oklahoma 40081 7664 123
2218674 2218674 2022-02-15 Lincoln Oklahoma 40081 7548 120
2215423 2215423 2022-02-14 Lincoln Oklahoma 40081 7548 120
2212172 2212172 2022-02-13 Lincoln Oklahoma 40081 7548 120
2208919 2208919 2022-02-12 Lincoln Oklahoma 40081 7548 120
2205666 2205666 2022-02-11 Lincoln Oklahoma 40081 7548 120
2202413 2202413 2022-02-10 Lincoln Oklahoma 40081 7548 120
2199159 2199159 2022-02-09 Lincoln Oklahoma 40081 7548 120
2195905 2195905 2022-02-08 Lincoln Oklahoma 40081 7382 119
2192651 2192651 2022-02-07 Lincoln Oklahoma 40081 7382 119
2189397 2189397 2022-02-06 Lincoln Oklahoma 40081 7382 119
2186144 2186144 2022-02-05 Lincoln Oklahoma 40081 7382 119
2182892 2182892 2022-02-04 Lincoln Oklahoma 40081 7382 119
2179640 2179640 2022-02-03 Lincoln Oklahoma 40081 7382 119

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