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

784 rows where fips = 27157 and state = "Minnesota" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Minnesota · 784 ✖

fips 1

  • 27157 · 784 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500984 2500984 2022-05-13 Wabasha Minnesota 27157 5795 16
2497726 2497726 2022-05-12 Wabasha Minnesota 27157 5783 16
2494468 2494468 2022-05-11 Wabasha Minnesota 27157 5773 16
2491210 2491210 2022-05-10 Wabasha Minnesota 27157 5769 16
2487953 2487953 2022-05-09 Wabasha Minnesota 27157 5749 16
2484695 2484695 2022-05-08 Wabasha Minnesota 27157 5738 16
2481437 2481437 2022-05-07 Wabasha Minnesota 27157 5738 16
2478179 2478179 2022-05-06 Wabasha Minnesota 27157 5738 16
2474921 2474921 2022-05-05 Wabasha Minnesota 27157 5722 16
2471664 2471664 2022-05-04 Wabasha Minnesota 27157 5714 16
2468408 2468408 2022-05-03 Wabasha Minnesota 27157 5703 16
2465153 2465153 2022-05-02 Wabasha Minnesota 27157 5691 16
2461897 2461897 2022-05-01 Wabasha Minnesota 27157 5685 16
2458641 2458641 2022-04-30 Wabasha Minnesota 27157 5685 16
2455385 2455385 2022-04-29 Wabasha Minnesota 27157 5685 16
2452129 2452129 2022-04-28 Wabasha Minnesota 27157 5678 16
2448873 2448873 2022-04-27 Wabasha Minnesota 27157 5668 16
2445617 2445617 2022-04-26 Wabasha Minnesota 27157 5661 16
2442361 2442361 2022-04-25 Wabasha Minnesota 27157 5647 16
2439105 2439105 2022-04-24 Wabasha Minnesota 27157 5636 16
2435849 2435849 2022-04-23 Wabasha Minnesota 27157 5636 16
2432593 2432593 2022-04-22 Wabasha Minnesota 27157 5636 16
2429337 2429337 2022-04-21 Wabasha Minnesota 27157 5618 16
2426081 2426081 2022-04-20 Wabasha Minnesota 27157 5607 16
2422825 2422825 2022-04-19 Wabasha Minnesota 27157 5606 16
2419569 2419569 2022-04-18 Wabasha Minnesota 27157 5594 16
2416313 2416313 2022-04-17 Wabasha Minnesota 27157 5589 16
2413057 2413057 2022-04-16 Wabasha Minnesota 27157 5589 16
2409801 2409801 2022-04-15 Wabasha Minnesota 27157 5589 16
2406545 2406545 2022-04-14 Wabasha Minnesota 27157 5583 16
2403289 2403289 2022-04-13 Wabasha Minnesota 27157 5583 16
2400035 2400035 2022-04-12 Wabasha Minnesota 27157 5579 16
2396779 2396779 2022-04-11 Wabasha Minnesota 27157 5570 16
2393524 2393524 2022-04-10 Wabasha Minnesota 27157 5569 16
2390268 2390268 2022-04-09 Wabasha Minnesota 27157 5569 16
2387012 2387012 2022-04-08 Wabasha Minnesota 27157 5569 16
2383757 2383757 2022-04-07 Wabasha Minnesota 27157 5569 16
2380502 2380502 2022-04-06 Wabasha Minnesota 27157 5568 16
2377247 2377247 2022-04-05 Wabasha Minnesota 27157 5568 16
2373995 2373995 2022-04-04 Wabasha Minnesota 27157 5567 16
2370742 2370742 2022-04-03 Wabasha Minnesota 27157 5564 16
2367489 2367489 2022-04-02 Wabasha Minnesota 27157 5564 16
2364236 2364236 2022-04-01 Wabasha Minnesota 27157 5564 16
2360982 2360982 2022-03-31 Wabasha Minnesota 27157 5564 16
2357728 2357728 2022-03-30 Wabasha Minnesota 27157 5561 16
2354475 2354475 2022-03-29 Wabasha Minnesota 27157 5560 16
2351223 2351223 2022-03-28 Wabasha Minnesota 27157 5554 16
2347970 2347970 2022-03-27 Wabasha Minnesota 27157 5552 16
2344717 2344717 2022-03-26 Wabasha Minnesota 27157 5552 16
2341464 2341464 2022-03-25 Wabasha Minnesota 27157 5552 16
2338211 2338211 2022-03-24 Wabasha Minnesota 27157 5547 16
2334957 2334957 2022-03-23 Wabasha Minnesota 27157 5546 16
2331703 2331703 2022-03-22 Wabasha Minnesota 27157 5546 16
2328451 2328451 2022-03-21 Wabasha Minnesota 27157 5538 16
2325198 2325198 2022-03-20 Wabasha Minnesota 27157 5538 16
2321944 2321944 2022-03-19 Wabasha Minnesota 27157 5538 16
2318690 2318690 2022-03-18 Wabasha Minnesota 27157 5538 16
2315437 2315437 2022-03-17 Wabasha Minnesota 27157 5535 16
2312184 2312184 2022-03-16 Wabasha Minnesota 27157 5533 16
2308931 2308931 2022-03-15 Wabasha Minnesota 27157 5527 16
2305680 2305680 2022-03-14 Wabasha Minnesota 27157 5526 16
2302428 2302428 2022-03-13 Wabasha Minnesota 27157 5521 16
2299176 2299176 2022-03-12 Wabasha Minnesota 27157 5521 16
2295924 2295924 2022-03-11 Wabasha Minnesota 27157 5521 16
2292672 2292672 2022-03-10 Wabasha Minnesota 27157 5509 16
2289420 2289420 2022-03-09 Wabasha Minnesota 27157 5503 16
2286169 2286169 2022-03-08 Wabasha Minnesota 27157 5501 16
2282917 2282917 2022-03-07 Wabasha Minnesota 27157 5494 16
2279664 2279664 2022-03-06 Wabasha Minnesota 27157 5494 16
2276411 2276411 2022-03-05 Wabasha Minnesota 27157 5494 16
2273158 2273158 2022-03-04 Wabasha Minnesota 27157 5494 16
2269906 2269906 2022-03-03 Wabasha Minnesota 27157 5488 16
2266653 2266653 2022-03-02 Wabasha Minnesota 27157 5479 16
2263402 2263402 2022-03-01 Wabasha Minnesota 27157 5471 16
2260151 2260151 2022-02-28 Wabasha Minnesota 27157 5457 16
2256900 2256900 2022-02-27 Wabasha Minnesota 27157 5447 16
2253649 2253649 2022-02-26 Wabasha Minnesota 27157 5447 16
2250398 2250398 2022-02-25 Wabasha Minnesota 27157 5447 16
2247147 2247147 2022-02-24 Wabasha Minnesota 27157 5428 16
2243896 2243896 2022-02-23 Wabasha Minnesota 27157 5426 16
2240645 2240645 2022-02-22 Wabasha Minnesota 27157 5401 16
2237394 2237394 2022-02-21 Wabasha Minnesota 27157 5376 16
2234143 2234143 2022-02-20 Wabasha Minnesota 27157 5376 16
2230892 2230892 2022-02-19 Wabasha Minnesota 27157 5376 16
2227641 2227641 2022-02-18 Wabasha Minnesota 27157 5376 16
2224390 2224390 2022-02-17 Wabasha Minnesota 27157 5346 16
2221139 2221139 2022-02-16 Wabasha Minnesota 27157 5341 16
2217888 2217888 2022-02-15 Wabasha Minnesota 27157 5340 16
2214637 2214637 2022-02-14 Wabasha Minnesota 27157 5320 16
2211385 2211385 2022-02-13 Wabasha Minnesota 27157 5300 16
2208132 2208132 2022-02-12 Wabasha Minnesota 27157 5300 16
2204879 2204879 2022-02-11 Wabasha Minnesota 27157 5300 16
2201626 2201626 2022-02-10 Wabasha Minnesota 27157 5283 16
2198372 2198372 2022-02-09 Wabasha Minnesota 27157 5264 16
2195118 2195118 2022-02-08 Wabasha Minnesota 27157 5250 15
2191864 2191864 2022-02-07 Wabasha Minnesota 27157 5209 15
2188611 2188611 2022-02-06 Wabasha Minnesota 27157 5183 15
2185358 2185358 2022-02-05 Wabasha Minnesota 27157 5183 15
2182106 2182106 2022-02-04 Wabasha Minnesota 27157 5183 15
2178854 2178854 2022-02-03 Wabasha Minnesota 27157 5159 15

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