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

771 rows where county = "Lincoln" and fips = 56023 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

  • 56023 · 771 ✖

county 1

  • Lincoln · 771 ✖
Link rowid date ▲ county state fips cases deaths
2502821 2502821 2022-05-13 Lincoln Wyoming 56023 3979 31
2499563 2499563 2022-05-12 Lincoln Wyoming 56023 3979 31
2496305 2496305 2022-05-11 Lincoln Wyoming 56023 3979 31
2493047 2493047 2022-05-10 Lincoln Wyoming 56023 3979 31
2489789 2489789 2022-05-09 Lincoln Wyoming 56023 3978 31
2486532 2486532 2022-05-08 Lincoln Wyoming 56023 3978 31
2483274 2483274 2022-05-07 Lincoln Wyoming 56023 3978 31
2480016 2480016 2022-05-06 Lincoln Wyoming 56023 3978 31
2476758 2476758 2022-05-05 Lincoln Wyoming 56023 3978 31
2473500 2473500 2022-05-04 Lincoln Wyoming 56023 3978 31
2470243 2470243 2022-05-03 Lincoln Wyoming 56023 3978 31
2466987 2466987 2022-05-02 Lincoln Wyoming 56023 3972 31
2463732 2463732 2022-05-01 Lincoln Wyoming 56023 3972 31
2460476 2460476 2022-04-30 Lincoln Wyoming 56023 3972 31
2457220 2457220 2022-04-29 Lincoln Wyoming 56023 3972 31
2453964 2453964 2022-04-28 Lincoln Wyoming 56023 3972 31
2450708 2450708 2022-04-27 Lincoln Wyoming 56023 3972 31
2447452 2447452 2022-04-26 Lincoln Wyoming 56023 3972 31
2444196 2444196 2022-04-25 Lincoln Wyoming 56023 3972 31
2440940 2440940 2022-04-24 Lincoln Wyoming 56023 3972 31
2437684 2437684 2022-04-23 Lincoln Wyoming 56023 3972 31
2434428 2434428 2022-04-22 Lincoln Wyoming 56023 3972 31
2431172 2431172 2022-04-21 Lincoln Wyoming 56023 3972 31
2427916 2427916 2022-04-20 Lincoln Wyoming 56023 3972 31
2424660 2424660 2022-04-19 Lincoln Wyoming 56023 3972 31
2421404 2421404 2022-04-18 Lincoln Wyoming 56023 3968 31
2418148 2418148 2022-04-17 Lincoln Wyoming 56023 3968 31
2414892 2414892 2022-04-16 Lincoln Wyoming 56023 3968 31
2411636 2411636 2022-04-15 Lincoln Wyoming 56023 3968 31
2408380 2408380 2022-04-14 Lincoln Wyoming 56023 3968 31
2405124 2405124 2022-04-13 Lincoln Wyoming 56023 3968 31
2401869 2401869 2022-04-12 Lincoln Wyoming 56023 3968 31
2398614 2398614 2022-04-11 Lincoln Wyoming 56023 3968 31
2395359 2395359 2022-04-10 Lincoln Wyoming 56023 3968 31
2392103 2392103 2022-04-09 Lincoln Wyoming 56023 3968 31
2388847 2388847 2022-04-08 Lincoln Wyoming 56023 3968 31
2385592 2385592 2022-04-07 Lincoln Wyoming 56023 3969 31
2382337 2382337 2022-04-06 Lincoln Wyoming 56023 3969 31
2379082 2379082 2022-04-05 Lincoln Wyoming 56023 3969 31
2375828 2375828 2022-04-04 Lincoln Wyoming 56023 3968 30
2372576 2372576 2022-04-03 Lincoln Wyoming 56023 3968 30
2369323 2369323 2022-04-02 Lincoln Wyoming 56023 3968 30
2366070 2366070 2022-04-01 Lincoln Wyoming 56023 3968 30
2362817 2362817 2022-03-31 Lincoln Wyoming 56023 3968 30
2359563 2359563 2022-03-30 Lincoln Wyoming 56023 3968 30
2356309 2356309 2022-03-29 Lincoln Wyoming 56023 3968 30
2353056 2353056 2022-03-28 Lincoln Wyoming 56023 3966 30
2349804 2349804 2022-03-27 Lincoln Wyoming 56023 3966 30
2346551 2346551 2022-03-26 Lincoln Wyoming 56023 3966 30
2343298 2343298 2022-03-25 Lincoln Wyoming 56023 3966 30
2340045 2340045 2022-03-24 Lincoln Wyoming 56023 3966 30
2336792 2336792 2022-03-23 Lincoln Wyoming 56023 3966 30
2333538 2333538 2022-03-22 Lincoln Wyoming 56023 3966 30
2330284 2330284 2022-03-21 Lincoln Wyoming 56023 3966 29
2327032 2327032 2022-03-20 Lincoln Wyoming 56023 3966 29
2323779 2323779 2022-03-19 Lincoln Wyoming 56023 3966 29
2320525 2320525 2022-03-18 Lincoln Wyoming 56023 3966 29
2317271 2317271 2022-03-17 Lincoln Wyoming 56023 3966 29
2314018 2314018 2022-03-16 Lincoln Wyoming 56023 3966 29
2310765 2310765 2022-03-15 Lincoln Wyoming 56023 3966 29
2307512 2307512 2022-03-14 Lincoln Wyoming 56023 3966 29
2304261 2304261 2022-03-13 Lincoln Wyoming 56023 3966 29
2301009 2301009 2022-03-12 Lincoln Wyoming 56023 3966 29
2297757 2297757 2022-03-11 Lincoln Wyoming 56023 3966 29
2294505 2294505 2022-03-10 Lincoln Wyoming 56023 3966 29
2291253 2291253 2022-03-09 Lincoln Wyoming 56023 3966 29
2288001 2288001 2022-03-08 Lincoln Wyoming 56023 3966 29
2284749 2284749 2022-03-07 Lincoln Wyoming 56023 3956 29
2281497 2281497 2022-03-06 Lincoln Wyoming 56023 3954 29
2278244 2278244 2022-03-05 Lincoln Wyoming 56023 3954 29
2274991 2274991 2022-03-04 Lincoln Wyoming 56023 3954 29
2271738 2271738 2022-03-03 Lincoln Wyoming 56023 3953 29
2268486 2268486 2022-03-02 Lincoln Wyoming 56023 3952 29
2265233 2265233 2022-03-01 Lincoln Wyoming 56023 3951 29
2261983 2261983 2022-02-28 Lincoln Wyoming 56023 3950 28
2258732 2258732 2022-02-27 Lincoln Wyoming 56023 3947 28
2255481 2255481 2022-02-26 Lincoln Wyoming 56023 3947 28
2252230 2252230 2022-02-25 Lincoln Wyoming 56023 3947 28
2248979 2248979 2022-02-24 Lincoln Wyoming 56023 3945 28
2245728 2245728 2022-02-23 Lincoln Wyoming 56023 3939 28
2242477 2242477 2022-02-22 Lincoln Wyoming 56023 3936 28
2239226 2239226 2022-02-21 Lincoln Wyoming 56023 3927 28
2235975 2235975 2022-02-20 Lincoln Wyoming 56023 3927 28
2232724 2232724 2022-02-19 Lincoln Wyoming 56023 3927 28
2229473 2229473 2022-02-18 Lincoln Wyoming 56023 3927 28
2226222 2226222 2022-02-17 Lincoln Wyoming 56023 3918 28
2222971 2222971 2022-02-16 Lincoln Wyoming 56023 3911 28
2219720 2219720 2022-02-15 Lincoln Wyoming 56023 3905 28
2216470 2216470 2022-02-14 Lincoln Wyoming 56023 3898 28
2213219 2213219 2022-02-13 Lincoln Wyoming 56023 3884 28
2209966 2209966 2022-02-12 Lincoln Wyoming 56023 3884 28
2206713 2206713 2022-02-11 Lincoln Wyoming 56023 3884 28
2203460 2203460 2022-02-10 Lincoln Wyoming 56023 3875 28
2200206 2200206 2022-02-09 Lincoln Wyoming 56023 3869 28
2196952 2196952 2022-02-08 Lincoln Wyoming 56023 3855 28
2193697 2193697 2022-02-07 Lincoln Wyoming 56023 3840 28
2190444 2190444 2022-02-06 Lincoln Wyoming 56023 3817 28
2187191 2187191 2022-02-05 Lincoln Wyoming 56023 3817 28
2183938 2183938 2022-02-04 Lincoln Wyoming 56023 3817 28
2180686 2180686 2022-02-03 Lincoln Wyoming 56023 3805 28

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