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

778 rows where county = "Lincoln" and state = "Minnesota" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Minnesota · 778 ✖

fips 1

county 1

  • Lincoln · 778 ✖
Link rowid date ▲ county state fips cases deaths
2500945 2500945 2022-05-13 Lincoln Minnesota 27081 1220 6
2497687 2497687 2022-05-12 Lincoln Minnesota 27081 1219 6
2494429 2494429 2022-05-11 Lincoln Minnesota 27081 1219 6
2491171 2491171 2022-05-10 Lincoln Minnesota 27081 1219 6
2487914 2487914 2022-05-09 Lincoln Minnesota 27081 1218 6
2484656 2484656 2022-05-08 Lincoln Minnesota 27081 1217 6
2481398 2481398 2022-05-07 Lincoln Minnesota 27081 1217 6
2478140 2478140 2022-05-06 Lincoln Minnesota 27081 1217 6
2474882 2474882 2022-05-05 Lincoln Minnesota 27081 1217 6
2471625 2471625 2022-05-04 Lincoln Minnesota 27081 1217 6
2468369 2468369 2022-05-03 Lincoln Minnesota 27081 1217 6
2465114 2465114 2022-05-02 Lincoln Minnesota 27081 1216 6
2461858 2461858 2022-05-01 Lincoln Minnesota 27081 1216 6
2458602 2458602 2022-04-30 Lincoln Minnesota 27081 1216 6
2455346 2455346 2022-04-29 Lincoln Minnesota 27081 1216 6
2452090 2452090 2022-04-28 Lincoln Minnesota 27081 1216 6
2448834 2448834 2022-04-27 Lincoln Minnesota 27081 1216 6
2445578 2445578 2022-04-26 Lincoln Minnesota 27081 1216 6
2442322 2442322 2022-04-25 Lincoln Minnesota 27081 1215 6
2439066 2439066 2022-04-24 Lincoln Minnesota 27081 1215 6
2435810 2435810 2022-04-23 Lincoln Minnesota 27081 1215 6
2432554 2432554 2022-04-22 Lincoln Minnesota 27081 1215 6
2429298 2429298 2022-04-21 Lincoln Minnesota 27081 1215 6
2426042 2426042 2022-04-20 Lincoln Minnesota 27081 1215 6
2422786 2422786 2022-04-19 Lincoln Minnesota 27081 1215 6
2419530 2419530 2022-04-18 Lincoln Minnesota 27081 1215 6
2416274 2416274 2022-04-17 Lincoln Minnesota 27081 1214 6
2413018 2413018 2022-04-16 Lincoln Minnesota 27081 1214 6
2409762 2409762 2022-04-15 Lincoln Minnesota 27081 1214 6
2406506 2406506 2022-04-14 Lincoln Minnesota 27081 1213 6
2403250 2403250 2022-04-13 Lincoln Minnesota 27081 1213 6
2399996 2399996 2022-04-12 Lincoln Minnesota 27081 1213 6
2396740 2396740 2022-04-11 Lincoln Minnesota 27081 1213 6
2393485 2393485 2022-04-10 Lincoln Minnesota 27081 1213 6
2390229 2390229 2022-04-09 Lincoln Minnesota 27081 1213 6
2386973 2386973 2022-04-08 Lincoln Minnesota 27081 1213 6
2383718 2383718 2022-04-07 Lincoln Minnesota 27081 1213 6
2380463 2380463 2022-04-06 Lincoln Minnesota 27081 1213 6
2377208 2377208 2022-04-05 Lincoln Minnesota 27081 1212 6
2373956 2373956 2022-04-04 Lincoln Minnesota 27081 1212 6
2370703 2370703 2022-04-03 Lincoln Minnesota 27081 1212 6
2367450 2367450 2022-04-02 Lincoln Minnesota 27081 1212 6
2364197 2364197 2022-04-01 Lincoln Minnesota 27081 1212 6
2360943 2360943 2022-03-31 Lincoln Minnesota 27081 1212 6
2357689 2357689 2022-03-30 Lincoln Minnesota 27081 1212 6
2354436 2354436 2022-03-29 Lincoln Minnesota 27081 1212 6
2351184 2351184 2022-03-28 Lincoln Minnesota 27081 1212 6
2347931 2347931 2022-03-27 Lincoln Minnesota 27081 1212 6
2344678 2344678 2022-03-26 Lincoln Minnesota 27081 1212 6
2341425 2341425 2022-03-25 Lincoln Minnesota 27081 1212 6
2338172 2338172 2022-03-24 Lincoln Minnesota 27081 1212 6
2334918 2334918 2022-03-23 Lincoln Minnesota 27081 1212 6
2331664 2331664 2022-03-22 Lincoln Minnesota 27081 1212 6
2328412 2328412 2022-03-21 Lincoln Minnesota 27081 1212 6
2325159 2325159 2022-03-20 Lincoln Minnesota 27081 1212 6
2321905 2321905 2022-03-19 Lincoln Minnesota 27081 1212 6
2318651 2318651 2022-03-18 Lincoln Minnesota 27081 1212 6
2315398 2315398 2022-03-17 Lincoln Minnesota 27081 1212 6
2312145 2312145 2022-03-16 Lincoln Minnesota 27081 1212 6
2308892 2308892 2022-03-15 Lincoln Minnesota 27081 1212 6
2305641 2305641 2022-03-14 Lincoln Minnesota 27081 1211 6
2302389 2302389 2022-03-13 Lincoln Minnesota 27081 1210 6
2299137 2299137 2022-03-12 Lincoln Minnesota 27081 1210 6
2295885 2295885 2022-03-11 Lincoln Minnesota 27081 1210 6
2292633 2292633 2022-03-10 Lincoln Minnesota 27081 1205 6
2289381 2289381 2022-03-09 Lincoln Minnesota 27081 1205 6
2286130 2286130 2022-03-08 Lincoln Minnesota 27081 1203 6
2282878 2282878 2022-03-07 Lincoln Minnesota 27081 1203 6
2279625 2279625 2022-03-06 Lincoln Minnesota 27081 1203 6
2276372 2276372 2022-03-05 Lincoln Minnesota 27081 1203 6
2273119 2273119 2022-03-04 Lincoln Minnesota 27081 1203 6
2269867 2269867 2022-03-03 Lincoln Minnesota 27081 1203 6
2266614 2266614 2022-03-02 Lincoln Minnesota 27081 1203 6
2263363 2263363 2022-03-01 Lincoln Minnesota 27081 1201 6
2260112 2260112 2022-02-28 Lincoln Minnesota 27081 1199 6
2256861 2256861 2022-02-27 Lincoln Minnesota 27081 1198 6
2253610 2253610 2022-02-26 Lincoln Minnesota 27081 1198 6
2250359 2250359 2022-02-25 Lincoln Minnesota 27081 1198 6
2247108 2247108 2022-02-24 Lincoln Minnesota 27081 1198 6
2243857 2243857 2022-02-23 Lincoln Minnesota 27081 1199 6
2240606 2240606 2022-02-22 Lincoln Minnesota 27081 1198 6
2237355 2237355 2022-02-21 Lincoln Minnesota 27081 1198 6
2234104 2234104 2022-02-20 Lincoln Minnesota 27081 1198 6
2230853 2230853 2022-02-19 Lincoln Minnesota 27081 1198 6
2227602 2227602 2022-02-18 Lincoln Minnesota 27081 1198 6
2224351 2224351 2022-02-17 Lincoln Minnesota 27081 1194 6
2221100 2221100 2022-02-16 Lincoln Minnesota 27081 1192 6
2217849 2217849 2022-02-15 Lincoln Minnesota 27081 1191 6
2214598 2214598 2022-02-14 Lincoln Minnesota 27081 1187 6
2211346 2211346 2022-02-13 Lincoln Minnesota 27081 1186 6
2208093 2208093 2022-02-12 Lincoln Minnesota 27081 1186 6
2204840 2204840 2022-02-11 Lincoln Minnesota 27081 1186 6
2201587 2201587 2022-02-10 Lincoln Minnesota 27081 1185 6
2198333 2198333 2022-02-09 Lincoln Minnesota 27081 1184 5
2195079 2195079 2022-02-08 Lincoln Minnesota 27081 1180 5
2191825 2191825 2022-02-07 Lincoln Minnesota 27081 1173 5
2188572 2188572 2022-02-06 Lincoln Minnesota 27081 1169 5
2185319 2185319 2022-02-05 Lincoln Minnesota 27081 1169 5
2182067 2182067 2022-02-04 Lincoln Minnesota 27081 1169 5
2178815 2178815 2022-02-03 Lincoln Minnesota 27081 1167 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);