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

790 rows where fips = 27161 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 · 790 ✖

fips 1

  • 27161 · 790 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500986 2500986 2022-05-13 Waseca Minnesota 27161 5587 39
2497728 2497728 2022-05-12 Waseca Minnesota 27161 5585 39
2494470 2494470 2022-05-11 Waseca Minnesota 27161 5580 39
2491212 2491212 2022-05-10 Waseca Minnesota 27161 5577 39
2487955 2487955 2022-05-09 Waseca Minnesota 27161 5573 39
2484697 2484697 2022-05-08 Waseca Minnesota 27161 5572 39
2481439 2481439 2022-05-07 Waseca Minnesota 27161 5572 39
2478181 2478181 2022-05-06 Waseca Minnesota 27161 5572 39
2474923 2474923 2022-05-05 Waseca Minnesota 27161 5568 39
2471666 2471666 2022-05-04 Waseca Minnesota 27161 5566 39
2468410 2468410 2022-05-03 Waseca Minnesota 27161 5566 39
2465155 2465155 2022-05-02 Waseca Minnesota 27161 5564 39
2461899 2461899 2022-05-01 Waseca Minnesota 27161 5563 39
2458643 2458643 2022-04-30 Waseca Minnesota 27161 5563 39
2455387 2455387 2022-04-29 Waseca Minnesota 27161 5563 39
2452131 2452131 2022-04-28 Waseca Minnesota 27161 5563 39
2448875 2448875 2022-04-27 Waseca Minnesota 27161 5563 39
2445619 2445619 2022-04-26 Waseca Minnesota 27161 5561 39
2442363 2442363 2022-04-25 Waseca Minnesota 27161 5557 39
2439107 2439107 2022-04-24 Waseca Minnesota 27161 5557 39
2435851 2435851 2022-04-23 Waseca Minnesota 27161 5557 39
2432595 2432595 2022-04-22 Waseca Minnesota 27161 5557 39
2429339 2429339 2022-04-21 Waseca Minnesota 27161 5553 39
2426083 2426083 2022-04-20 Waseca Minnesota 27161 5548 39
2422827 2422827 2022-04-19 Waseca Minnesota 27161 5545 39
2419571 2419571 2022-04-18 Waseca Minnesota 27161 5541 39
2416315 2416315 2022-04-17 Waseca Minnesota 27161 5533 39
2413059 2413059 2022-04-16 Waseca Minnesota 27161 5533 39
2409803 2409803 2022-04-15 Waseca Minnesota 27161 5533 39
2406547 2406547 2022-04-14 Waseca Minnesota 27161 5530 39
2403291 2403291 2022-04-13 Waseca Minnesota 27161 5522 39
2400037 2400037 2022-04-12 Waseca Minnesota 27161 5517 39
2396781 2396781 2022-04-11 Waseca Minnesota 27161 5510 39
2393526 2393526 2022-04-10 Waseca Minnesota 27161 5505 39
2390270 2390270 2022-04-09 Waseca Minnesota 27161 5505 39
2387014 2387014 2022-04-08 Waseca Minnesota 27161 5505 39
2383759 2383759 2022-04-07 Waseca Minnesota 27161 5500 39
2380504 2380504 2022-04-06 Waseca Minnesota 27161 5496 39
2377249 2377249 2022-04-05 Waseca Minnesota 27161 5492 39
2373997 2373997 2022-04-04 Waseca Minnesota 27161 5484 39
2370744 2370744 2022-04-03 Waseca Minnesota 27161 5481 39
2367491 2367491 2022-04-02 Waseca Minnesota 27161 5481 39
2364238 2364238 2022-04-01 Waseca Minnesota 27161 5481 39
2360984 2360984 2022-03-31 Waseca Minnesota 27161 5479 39
2357730 2357730 2022-03-30 Waseca Minnesota 27161 5477 39
2354477 2354477 2022-03-29 Waseca Minnesota 27161 5477 39
2351225 2351225 2022-03-28 Waseca Minnesota 27161 5474 39
2347972 2347972 2022-03-27 Waseca Minnesota 27161 5473 39
2344719 2344719 2022-03-26 Waseca Minnesota 27161 5473 39
2341466 2341466 2022-03-25 Waseca Minnesota 27161 5473 39
2338213 2338213 2022-03-24 Waseca Minnesota 27161 5472 39
2334959 2334959 2022-03-23 Waseca Minnesota 27161 5471 39
2331705 2331705 2022-03-22 Waseca Minnesota 27161 5471 39
2328453 2328453 2022-03-21 Waseca Minnesota 27161 5470 39
2325200 2325200 2022-03-20 Waseca Minnesota 27161 5470 39
2321946 2321946 2022-03-19 Waseca Minnesota 27161 5470 39
2318692 2318692 2022-03-18 Waseca Minnesota 27161 5470 39
2315439 2315439 2022-03-17 Waseca Minnesota 27161 5470 39
2312186 2312186 2022-03-16 Waseca Minnesota 27161 5469 39
2308933 2308933 2022-03-15 Waseca Minnesota 27161 5465 39
2305682 2305682 2022-03-14 Waseca Minnesota 27161 5461 39
2302430 2302430 2022-03-13 Waseca Minnesota 27161 5460 39
2299178 2299178 2022-03-12 Waseca Minnesota 27161 5460 39
2295926 2295926 2022-03-11 Waseca Minnesota 27161 5460 39
2292674 2292674 2022-03-10 Waseca Minnesota 27161 5424 39
2289422 2289422 2022-03-09 Waseca Minnesota 27161 5422 39
2286171 2286171 2022-03-08 Waseca Minnesota 27161 5420 39
2282919 2282919 2022-03-07 Waseca Minnesota 27161 5417 39
2279666 2279666 2022-03-06 Waseca Minnesota 27161 5413 39
2276413 2276413 2022-03-05 Waseca Minnesota 27161 5413 39
2273160 2273160 2022-03-04 Waseca Minnesota 27161 5413 39
2269908 2269908 2022-03-03 Waseca Minnesota 27161 5413 39
2266655 2266655 2022-03-02 Waseca Minnesota 27161 5411 39
2263404 2263404 2022-03-01 Waseca Minnesota 27161 5407 39
2260153 2260153 2022-02-28 Waseca Minnesota 27161 5404 39
2256902 2256902 2022-02-27 Waseca Minnesota 27161 5400 39
2253651 2253651 2022-02-26 Waseca Minnesota 27161 5400 39
2250400 2250400 2022-02-25 Waseca Minnesota 27161 5400 39
2247149 2247149 2022-02-24 Waseca Minnesota 27161 5397 39
2243898 2243898 2022-02-23 Waseca Minnesota 27161 5394 39
2240647 2240647 2022-02-22 Waseca Minnesota 27161 5386 39
2237396 2237396 2022-02-21 Waseca Minnesota 27161 5376 39
2234145 2234145 2022-02-20 Waseca Minnesota 27161 5376 39
2230894 2230894 2022-02-19 Waseca Minnesota 27161 5376 39
2227643 2227643 2022-02-18 Waseca Minnesota 27161 5376 39
2224392 2224392 2022-02-17 Waseca Minnesota 27161 5371 38
2221141 2221141 2022-02-16 Waseca Minnesota 27161 5360 38
2217890 2217890 2022-02-15 Waseca Minnesota 27161 5354 38
2214639 2214639 2022-02-14 Waseca Minnesota 27161 5343 38
2211387 2211387 2022-02-13 Waseca Minnesota 27161 5332 38
2208134 2208134 2022-02-12 Waseca Minnesota 27161 5332 38
2204881 2204881 2022-02-11 Waseca Minnesota 27161 5332 38
2201628 2201628 2022-02-10 Waseca Minnesota 27161 5319 38
2198374 2198374 2022-02-09 Waseca Minnesota 27161 5306 38
2195120 2195120 2022-02-08 Waseca Minnesota 27161 5292 38
2191866 2191866 2022-02-07 Waseca Minnesota 27161 5266 38
2188613 2188613 2022-02-06 Waseca Minnesota 27161 5241 38
2185360 2185360 2022-02-05 Waseca Minnesota 27161 5241 38
2182108 2182108 2022-02-04 Waseca Minnesota 27161 5241 38
2178856 2178856 2022-02-03 Waseca Minnesota 27161 5209 38

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