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

743 rows where county = "Lincoln" and state = "Wisconsin" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Wisconsin · 743 ✖

fips 1

county 1

  • Lincoln · 743 ✖
Link rowid date ▲ county state fips cases deaths
2502772 2502772 2022-05-13 Lincoln Wisconsin 55069 7188 148
2499514 2499514 2022-05-12 Lincoln Wisconsin 55069 7174 148
2496256 2496256 2022-05-11 Lincoln Wisconsin 55069 7156 148
2492998 2492998 2022-05-10 Lincoln Wisconsin 55069 7145 148
2489740 2489740 2022-05-09 Lincoln Wisconsin 55069 7144 148
2486483 2486483 2022-05-08 Lincoln Wisconsin 55069 7111 148
2483225 2483225 2022-05-07 Lincoln Wisconsin 55069 7111 148
2479967 2479967 2022-05-06 Lincoln Wisconsin 55069 7111 148
2476709 2476709 2022-05-05 Lincoln Wisconsin 55069 7103 148
2473451 2473451 2022-05-04 Lincoln Wisconsin 55069 7097 148
2470194 2470194 2022-05-03 Lincoln Wisconsin 55069 7085 148
2466938 2466938 2022-05-02 Lincoln Wisconsin 55069 7079 148
2463683 2463683 2022-05-01 Lincoln Wisconsin 55069 7069 148
2460427 2460427 2022-04-30 Lincoln Wisconsin 55069 7069 148
2457171 2457171 2022-04-29 Lincoln Wisconsin 55069 7069 148
2453915 2453915 2022-04-28 Lincoln Wisconsin 55069 7060 148
2450659 2450659 2022-04-27 Lincoln Wisconsin 55069 7057 148
2447403 2447403 2022-04-26 Lincoln Wisconsin 55069 7053 148
2444147 2444147 2022-04-25 Lincoln Wisconsin 55069 7048 148
2440891 2440891 2022-04-24 Lincoln Wisconsin 55069 7041 148
2437635 2437635 2022-04-23 Lincoln Wisconsin 55069 7041 148
2434379 2434379 2022-04-22 Lincoln Wisconsin 55069 7041 148
2431123 2431123 2022-04-21 Lincoln Wisconsin 55069 7036 148
2427867 2427867 2022-04-20 Lincoln Wisconsin 55069 7034 148
2424611 2424611 2022-04-19 Lincoln Wisconsin 55069 7031 148
2421355 2421355 2022-04-18 Lincoln Wisconsin 55069 7027 148
2418099 2418099 2022-04-17 Lincoln Wisconsin 55069 7022 148
2414843 2414843 2022-04-16 Lincoln Wisconsin 55069 7022 148
2411587 2411587 2022-04-15 Lincoln Wisconsin 55069 7022 148
2408331 2408331 2022-04-14 Lincoln Wisconsin 55069 7022 148
2405075 2405075 2022-04-13 Lincoln Wisconsin 55069 7016 148
2401820 2401820 2022-04-12 Lincoln Wisconsin 55069 7014 148
2398565 2398565 2022-04-11 Lincoln Wisconsin 55069 7012 148
2395310 2395310 2022-04-10 Lincoln Wisconsin 55069 7010 148
2392054 2392054 2022-04-09 Lincoln Wisconsin 55069 7010 148
2388798 2388798 2022-04-08 Lincoln Wisconsin 55069 7010 148
2385543 2385543 2022-04-07 Lincoln Wisconsin 55069 7008 148
2382288 2382288 2022-04-06 Lincoln Wisconsin 55069 7006 148
2379033 2379033 2022-04-05 Lincoln Wisconsin 55069 7006 148
2375779 2375779 2022-04-04 Lincoln Wisconsin 55069 7005 147
2372527 2372527 2022-04-03 Lincoln Wisconsin 55069 7003 148
2369274 2369274 2022-04-02 Lincoln Wisconsin 55069 7003 148
2366021 2366021 2022-04-01 Lincoln Wisconsin 55069 7003 148
2362768 2362768 2022-03-31 Lincoln Wisconsin 55069 7002 148
2359514 2359514 2022-03-30 Lincoln Wisconsin 55069 7001 148
2356260 2356260 2022-03-29 Lincoln Wisconsin 55069 6999 148
2353007 2353007 2022-03-28 Lincoln Wisconsin 55069 6997 148
2349755 2349755 2022-03-27 Lincoln Wisconsin 55069 6996 147
2346502 2346502 2022-03-26 Lincoln Wisconsin 55069 6996 147
2343249 2343249 2022-03-25 Lincoln Wisconsin 55069 6996 147
2339996 2339996 2022-03-24 Lincoln Wisconsin 55069 6996 147
2336743 2336743 2022-03-23 Lincoln Wisconsin 55069 6995 147
2333489 2333489 2022-03-22 Lincoln Wisconsin 55069 6995 147
2330235 2330235 2022-03-21 Lincoln Wisconsin 55069 6993 147
2326983 2326983 2022-03-20 Lincoln Wisconsin 55069 6989 146
2323730 2323730 2022-03-19 Lincoln Wisconsin 55069 6989 146
2320476 2320476 2022-03-18 Lincoln Wisconsin 55069 6989 146
2317222 2317222 2022-03-17 Lincoln Wisconsin 55069 6989 146
2313969 2313969 2022-03-16 Lincoln Wisconsin 55069 6989 146
2310716 2310716 2022-03-15 Lincoln Wisconsin 55069 6986 146
2307463 2307463 2022-03-14 Lincoln Wisconsin 55069 6983 145
2304212 2304212 2022-03-13 Lincoln Wisconsin 55069 6982 144
2300960 2300960 2022-03-12 Lincoln Wisconsin 55069 6982 144
2297708 2297708 2022-03-11 Lincoln Wisconsin 55069 6982 144
2294456 2294456 2022-03-10 Lincoln Wisconsin 55069 6981 144
2291204 2291204 2022-03-09 Lincoln Wisconsin 55069 6979 142
2287952 2287952 2022-03-08 Lincoln Wisconsin 55069 6977 142
2284700 2284700 2022-03-07 Lincoln Wisconsin 55069 6978 139
2281448 2281448 2022-03-06 Lincoln Wisconsin 55069 6977 138
2278195 2278195 2022-03-05 Lincoln Wisconsin 55069 6977 138
2274942 2274942 2022-03-04 Lincoln Wisconsin 55069 6977 138
2271689 2271689 2022-03-03 Lincoln Wisconsin 55069 6976 138
2268437 2268437 2022-03-02 Lincoln Wisconsin 55069 6970 137
2265184 2265184 2022-03-01 Lincoln Wisconsin 55069 6960 136
2261934 2261934 2022-02-28 Lincoln Wisconsin 55069 6957 136
2258683 2258683 2022-02-27 Lincoln Wisconsin 55069 6948 136
2255432 2255432 2022-02-26 Lincoln Wisconsin 55069 6948 136
2252181 2252181 2022-02-25 Lincoln Wisconsin 55069 6948 136
2248930 2248930 2022-02-24 Lincoln Wisconsin 55069 6947 136
2245679 2245679 2022-02-23 Lincoln Wisconsin 55069 6941 136
2242428 2242428 2022-02-22 Lincoln Wisconsin 55069 6931 136
2239177 2239177 2022-02-21 Lincoln Wisconsin 55069 6927 136
2235926 2235926 2022-02-20 Lincoln Wisconsin 55069 6906 136
2232675 2232675 2022-02-19 Lincoln Wisconsin 55069 6906 136
2229424 2229424 2022-02-18 Lincoln Wisconsin 55069 6906 136
2226173 2226173 2022-02-17 Lincoln Wisconsin 55069 6895 136
2222922 2222922 2022-02-16 Lincoln Wisconsin 55069 6886 135
2219671 2219671 2022-02-15 Lincoln Wisconsin 55069 6874 134
2216421 2216421 2022-02-14 Lincoln Wisconsin 55069 6871 132
2213170 2213170 2022-02-13 Lincoln Wisconsin 55069 6854 132
2209917 2209917 2022-02-12 Lincoln Wisconsin 55069 6854 132
2206664 2206664 2022-02-11 Lincoln Wisconsin 55069 6854 132
2203411 2203411 2022-02-10 Lincoln Wisconsin 55069 6834 132
2200157 2200157 2022-02-09 Lincoln Wisconsin 55069 6825 131
2196903 2196903 2022-02-08 Lincoln Wisconsin 55069 6814 131
2193648 2193648 2022-02-07 Lincoln Wisconsin 55069 6804 131
2190395 2190395 2022-02-06 Lincoln Wisconsin 55069 6768 130
2187142 2187142 2022-02-05 Lincoln Wisconsin 55069 6768 130
2183889 2183889 2022-02-04 Lincoln Wisconsin 55069 6768 130
2180637 2180637 2022-02-03 Lincoln Wisconsin 55069 6738 130

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