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

736 rows where county = "Lincoln" and fips = 32017 sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

fips 1

  • 32017 · 736 ✖

county 1

  • Lincoln · 736 ✖
Link rowid date ▲ county state fips cases deaths
2501352 2501352 2022-05-13 Lincoln Nevada 32017 550 7
2498094 2498094 2022-05-12 Lincoln Nevada 32017 550 7
2494836 2494836 2022-05-11 Lincoln Nevada 32017 550 7
2491578 2491578 2022-05-10 Lincoln Nevada 32017 548 7
2488320 2488320 2022-05-09 Lincoln Nevada 32017 548 7
2485063 2485063 2022-05-08 Lincoln Nevada 32017 548 7
2481805 2481805 2022-05-07 Lincoln Nevada 32017 548 7
2478547 2478547 2022-05-06 Lincoln Nevada 32017 548 7
2475289 2475289 2022-05-05 Lincoln Nevada 32017 548 7
2472032 2472032 2022-05-04 Lincoln Nevada 32017 548 7
2468776 2468776 2022-05-03 Lincoln Nevada 32017 548 7
2465520 2465520 2022-05-02 Lincoln Nevada 32017 548 7
2462265 2462265 2022-05-01 Lincoln Nevada 32017 548 7
2459009 2459009 2022-04-30 Lincoln Nevada 32017 548 7
2455753 2455753 2022-04-29 Lincoln Nevada 32017 548 7
2452497 2452497 2022-04-28 Lincoln Nevada 32017 548 7
2449241 2449241 2022-04-27 Lincoln Nevada 32017 548 7
2445984 2445984 2022-04-26 Lincoln Nevada 32017 546 7
2442729 2442729 2022-04-25 Lincoln Nevada 32017 546 7
2439473 2439473 2022-04-24 Lincoln Nevada 32017 546 7
2436217 2436217 2022-04-23 Lincoln Nevada 32017 546 7
2432961 2432961 2022-04-22 Lincoln Nevada 32017 546 7
2429705 2429705 2022-04-21 Lincoln Nevada 32017 546 7
2426449 2426449 2022-04-20 Lincoln Nevada 32017 546 7
2423193 2423193 2022-04-19 Lincoln Nevada 32017 549 7
2419936 2419936 2022-04-18 Lincoln Nevada 32017 549 7
2416681 2416681 2022-04-17 Lincoln Nevada 32017 549 7
2413425 2413425 2022-04-16 Lincoln Nevada 32017 549 7
2410169 2410169 2022-04-15 Lincoln Nevada 32017 549 7
2406913 2406913 2022-04-14 Lincoln Nevada 32017 549 7
2403657 2403657 2022-04-13 Lincoln Nevada 32017 549 7
2400402 2400402 2022-04-12 Lincoln Nevada 32017 550 7
2397147 2397147 2022-04-11 Lincoln Nevada 32017 550 7
2393892 2393892 2022-04-10 Lincoln Nevada 32017 550 7
2390636 2390636 2022-04-09 Lincoln Nevada 32017 550 7
2387380 2387380 2022-04-08 Lincoln Nevada 32017 550 7
2384125 2384125 2022-04-07 Lincoln Nevada 32017 550 7
2380870 2380870 2022-04-06 Lincoln Nevada 32017 550 7
2377615 2377615 2022-04-05 Lincoln Nevada 32017 550 7
2374362 2374362 2022-04-04 Lincoln Nevada 32017 550 7
2371110 2371110 2022-04-03 Lincoln Nevada 32017 550 7
2367857 2367857 2022-04-02 Lincoln Nevada 32017 550 7
2364604 2364604 2022-04-01 Lincoln Nevada 32017 550 7
2361350 2361350 2022-03-31 Lincoln Nevada 32017 550 7
2358096 2358096 2022-03-30 Lincoln Nevada 32017 550 7
2354843 2354843 2022-03-29 Lincoln Nevada 32017 550 7
2351590 2351590 2022-03-28 Lincoln Nevada 32017 550 7
2348338 2348338 2022-03-27 Lincoln Nevada 32017 550 7
2345085 2345085 2022-03-26 Lincoln Nevada 32017 550 7
2341832 2341832 2022-03-25 Lincoln Nevada 32017 550 7
2338579 2338579 2022-03-24 Lincoln Nevada 32017 550 7
2335325 2335325 2022-03-23 Lincoln Nevada 32017 550 7
2332071 2332071 2022-03-22 Lincoln Nevada 32017 549 7
2328818 2328818 2022-03-21 Lincoln Nevada 32017 549 7
2325566 2325566 2022-03-20 Lincoln Nevada 32017 549 7
2322312 2322312 2022-03-19 Lincoln Nevada 32017 549 7
2319058 2319058 2022-03-18 Lincoln Nevada 32017 549 7
2315805 2315805 2022-03-17 Lincoln Nevada 32017 549 7
2312552 2312552 2022-03-16 Lincoln Nevada 32017 549 7
2309299 2309299 2022-03-15 Lincoln Nevada 32017 958 7
2306047 2306047 2022-03-14 Lincoln Nevada 32017 958 7
2302796 2302796 2022-03-13 Lincoln Nevada 32017 958 7
2299544 2299544 2022-03-12 Lincoln Nevada 32017 958 7
2296292 2296292 2022-03-11 Lincoln Nevada 32017 958 7
2293040 2293040 2022-03-10 Lincoln Nevada 32017 958 7
2289788 2289788 2022-03-09 Lincoln Nevada 32017 958 7
2286536 2286536 2022-03-08 Lincoln Nevada 32017 956 7
2283284 2283284 2022-03-07 Lincoln Nevada 32017 956 7
2280031 2280031 2022-03-06 Lincoln Nevada 32017 956 7
2276778 2276778 2022-03-05 Lincoln Nevada 32017 956 7
2273525 2273525 2022-03-04 Lincoln Nevada 32017 956 7
2270273 2270273 2022-03-03 Lincoln Nevada 32017 956 7
2267020 2267020 2022-03-02 Lincoln Nevada 32017 956 7
2263769 2263769 2022-03-01 Lincoln Nevada 32017 954 7
2260518 2260518 2022-02-28 Lincoln Nevada 32017 954 7
2257267 2257267 2022-02-27 Lincoln Nevada 32017 954 5
2254016 2254016 2022-02-26 Lincoln Nevada 32017 954 5
2250765 2250765 2022-02-25 Lincoln Nevada 32017 954 5
2247514 2247514 2022-02-24 Lincoln Nevada 32017 954 5
2244263 2244263 2022-02-23 Lincoln Nevada 32017 954 5
2241012 2241012 2022-02-22 Lincoln Nevada 32017 954 5
2237761 2237761 2022-02-21 Lincoln Nevada 32017 953 5
2234510 2234510 2022-02-20 Lincoln Nevada 32017 953 5
2231259 2231259 2022-02-19 Lincoln Nevada 32017 953 5
2228008 2228008 2022-02-18 Lincoln Nevada 32017 953 5
2224757 2224757 2022-02-17 Lincoln Nevada 32017 953 5
2221506 2221506 2022-02-16 Lincoln Nevada 32017 950 5
2218255 2218255 2022-02-15 Lincoln Nevada 32017 950 5
2215004 2215004 2022-02-14 Lincoln Nevada 32017 950 5
2211752 2211752 2022-02-13 Lincoln Nevada 32017 950 5
2208499 2208499 2022-02-12 Lincoln Nevada 32017 950 5
2205246 2205246 2022-02-11 Lincoln Nevada 32017 950 5
2201993 2201993 2022-02-10 Lincoln Nevada 32017 949 5
2198739 2198739 2022-02-09 Lincoln Nevada 32017 995 5
2195485 2195485 2022-02-08 Lincoln Nevada 32017 937 5
2192231 2192231 2022-02-07 Lincoln Nevada 32017 929 5
2188978 2188978 2022-02-06 Lincoln Nevada 32017 929 5
2185725 2185725 2022-02-05 Lincoln Nevada 32017 929 5
2182473 2182473 2022-02-04 Lincoln Nevada 32017 929 5
2179221 2179221 2022-02-03 Lincoln Nevada 32017 929 5

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