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

753 rows where fips = 27113 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 · 753 ✖

fips 1

  • 27113 · 753 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500961 2500961 2022-05-13 Pennington Minnesota 27113 3687 41
2497703 2497703 2022-05-12 Pennington Minnesota 27113 3685 41
2494445 2494445 2022-05-11 Pennington Minnesota 27113 3673 41
2491187 2491187 2022-05-10 Pennington Minnesota 27113 3664 41
2487930 2487930 2022-05-09 Pennington Minnesota 27113 3659 41
2484672 2484672 2022-05-08 Pennington Minnesota 27113 3656 41
2481414 2481414 2022-05-07 Pennington Minnesota 27113 3656 41
2478156 2478156 2022-05-06 Pennington Minnesota 27113 3656 41
2474898 2474898 2022-05-05 Pennington Minnesota 27113 3645 41
2471641 2471641 2022-05-04 Pennington Minnesota 27113 3635 41
2468385 2468385 2022-05-03 Pennington Minnesota 27113 3628 41
2465130 2465130 2022-05-02 Pennington Minnesota 27113 3624 41
2461874 2461874 2022-05-01 Pennington Minnesota 27113 3620 41
2458618 2458618 2022-04-30 Pennington Minnesota 27113 3620 41
2455362 2455362 2022-04-29 Pennington Minnesota 27113 3620 41
2452106 2452106 2022-04-28 Pennington Minnesota 27113 3617 41
2448850 2448850 2022-04-27 Pennington Minnesota 27113 3604 41
2445594 2445594 2022-04-26 Pennington Minnesota 27113 3598 41
2442338 2442338 2022-04-25 Pennington Minnesota 27113 3594 41
2439082 2439082 2022-04-24 Pennington Minnesota 27113 3587 41
2435826 2435826 2022-04-23 Pennington Minnesota 27113 3587 41
2432570 2432570 2022-04-22 Pennington Minnesota 27113 3587 41
2429314 2429314 2022-04-21 Pennington Minnesota 27113 3574 41
2426058 2426058 2022-04-20 Pennington Minnesota 27113 3571 41
2422802 2422802 2022-04-19 Pennington Minnesota 27113 3568 41
2419546 2419546 2022-04-18 Pennington Minnesota 27113 3566 41
2416290 2416290 2022-04-17 Pennington Minnesota 27113 3560 41
2413034 2413034 2022-04-16 Pennington Minnesota 27113 3560 41
2409778 2409778 2022-04-15 Pennington Minnesota 27113 3560 41
2406522 2406522 2022-04-14 Pennington Minnesota 27113 3558 41
2403266 2403266 2022-04-13 Pennington Minnesota 27113 3552 41
2400012 2400012 2022-04-12 Pennington Minnesota 27113 3552 41
2396756 2396756 2022-04-11 Pennington Minnesota 27113 3550 41
2393501 2393501 2022-04-10 Pennington Minnesota 27113 3549 41
2390245 2390245 2022-04-09 Pennington Minnesota 27113 3549 41
2386989 2386989 2022-04-08 Pennington Minnesota 27113 3549 41
2383734 2383734 2022-04-07 Pennington Minnesota 27113 3549 41
2380479 2380479 2022-04-06 Pennington Minnesota 27113 3546 41
2377224 2377224 2022-04-05 Pennington Minnesota 27113 3545 41
2373972 2373972 2022-04-04 Pennington Minnesota 27113 3544 41
2370719 2370719 2022-04-03 Pennington Minnesota 27113 3543 41
2367466 2367466 2022-04-02 Pennington Minnesota 27113 3543 41
2364213 2364213 2022-04-01 Pennington Minnesota 27113 3543 41
2360959 2360959 2022-03-31 Pennington Minnesota 27113 3540 41
2357705 2357705 2022-03-30 Pennington Minnesota 27113 3536 41
2354452 2354452 2022-03-29 Pennington Minnesota 27113 3536 41
2351200 2351200 2022-03-28 Pennington Minnesota 27113 3532 41
2347947 2347947 2022-03-27 Pennington Minnesota 27113 3532 41
2344694 2344694 2022-03-26 Pennington Minnesota 27113 3532 41
2341441 2341441 2022-03-25 Pennington Minnesota 27113 3532 41
2338188 2338188 2022-03-24 Pennington Minnesota 27113 3532 41
2334934 2334934 2022-03-23 Pennington Minnesota 27113 3532 41
2331680 2331680 2022-03-22 Pennington Minnesota 27113 3532 41
2328428 2328428 2022-03-21 Pennington Minnesota 27113 3532 41
2325175 2325175 2022-03-20 Pennington Minnesota 27113 3532 41
2321921 2321921 2022-03-19 Pennington Minnesota 27113 3532 41
2318667 2318667 2022-03-18 Pennington Minnesota 27113 3532 41
2315414 2315414 2022-03-17 Pennington Minnesota 27113 3532 41
2312161 2312161 2022-03-16 Pennington Minnesota 27113 3532 41
2308908 2308908 2022-03-15 Pennington Minnesota 27113 3526 41
2305657 2305657 2022-03-14 Pennington Minnesota 27113 3525 41
2302405 2302405 2022-03-13 Pennington Minnesota 27113 3523 41
2299153 2299153 2022-03-12 Pennington Minnesota 27113 3523 41
2295901 2295901 2022-03-11 Pennington Minnesota 27113 3523 41
2292649 2292649 2022-03-10 Pennington Minnesota 27113 3506 41
2289397 2289397 2022-03-09 Pennington Minnesota 27113 3504 41
2286146 2286146 2022-03-08 Pennington Minnesota 27113 3504 41
2282894 2282894 2022-03-07 Pennington Minnesota 27113 3501 41
2279641 2279641 2022-03-06 Pennington Minnesota 27113 3498 40
2276388 2276388 2022-03-05 Pennington Minnesota 27113 3498 40
2273135 2273135 2022-03-04 Pennington Minnesota 27113 3498 40
2269883 2269883 2022-03-03 Pennington Minnesota 27113 3496 40
2266630 2266630 2022-03-02 Pennington Minnesota 27113 3495 40
2263379 2263379 2022-03-01 Pennington Minnesota 27113 3489 40
2260128 2260128 2022-02-28 Pennington Minnesota 27113 3476 40
2256877 2256877 2022-02-27 Pennington Minnesota 27113 3470 40
2253626 2253626 2022-02-26 Pennington Minnesota 27113 3470 40
2250375 2250375 2022-02-25 Pennington Minnesota 27113 3470 40
2247124 2247124 2022-02-24 Pennington Minnesota 27113 3459 40
2243873 2243873 2022-02-23 Pennington Minnesota 27113 3450 40
2240622 2240622 2022-02-22 Pennington Minnesota 27113 3433 39
2237371 2237371 2022-02-21 Pennington Minnesota 27113 3429 39
2234120 2234120 2022-02-20 Pennington Minnesota 27113 3429 39
2230869 2230869 2022-02-19 Pennington Minnesota 27113 3429 39
2227618 2227618 2022-02-18 Pennington Minnesota 27113 3429 39
2224367 2224367 2022-02-17 Pennington Minnesota 27113 3413 39
2221116 2221116 2022-02-16 Pennington Minnesota 27113 3405 39
2217865 2217865 2022-02-15 Pennington Minnesota 27113 3400 38
2214614 2214614 2022-02-14 Pennington Minnesota 27113 3388 38
2211362 2211362 2022-02-13 Pennington Minnesota 27113 3375 38
2208109 2208109 2022-02-12 Pennington Minnesota 27113 3375 38
2204856 2204856 2022-02-11 Pennington Minnesota 27113 3375 38
2201603 2201603 2022-02-10 Pennington Minnesota 27113 3358 38
2198349 2198349 2022-02-09 Pennington Minnesota 27113 3345 37
2195095 2195095 2022-02-08 Pennington Minnesota 27113 3322 36
2191841 2191841 2022-02-07 Pennington Minnesota 27113 3295 36
2188588 2188588 2022-02-06 Pennington Minnesota 27113 3281 36
2185335 2185335 2022-02-05 Pennington Minnesota 27113 3281 36
2182083 2182083 2022-02-04 Pennington Minnesota 27113 3281 36
2178831 2178831 2022-02-03 Pennington Minnesota 27113 3263 36

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