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

789 rows where fips = 27013 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 · 789 ✖

fips 1

  • 27013 · 789 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500911 2500911 2022-05-13 Blue Earth Minnesota 27013 18332 101
2497653 2497653 2022-05-12 Blue Earth Minnesota 27013 18315 100
2494395 2494395 2022-05-11 Blue Earth Minnesota 27013 18299 100
2491137 2491137 2022-05-10 Blue Earth Minnesota 27013 18288 100
2487880 2487880 2022-05-09 Blue Earth Minnesota 27013 18256 100
2484622 2484622 2022-05-08 Blue Earth Minnesota 27013 18233 100
2481364 2481364 2022-05-07 Blue Earth Minnesota 27013 18233 100
2478106 2478106 2022-05-06 Blue Earth Minnesota 27013 18233 100
2474848 2474848 2022-05-05 Blue Earth Minnesota 27013 18221 100
2471591 2471591 2022-05-04 Blue Earth Minnesota 27013 18208 100
2468335 2468335 2022-05-03 Blue Earth Minnesota 27013 18194 100
2465080 2465080 2022-05-02 Blue Earth Minnesota 27013 18177 100
2461824 2461824 2022-05-01 Blue Earth Minnesota 27013 18170 100
2458568 2458568 2022-04-30 Blue Earth Minnesota 27013 18170 100
2455312 2455312 2022-04-29 Blue Earth Minnesota 27013 18170 100
2452056 2452056 2022-04-28 Blue Earth Minnesota 27013 18151 100
2448800 2448800 2022-04-27 Blue Earth Minnesota 27013 18123 100
2445544 2445544 2022-04-26 Blue Earth Minnesota 27013 18111 99
2442288 2442288 2022-04-25 Blue Earth Minnesota 27013 18084 98
2439032 2439032 2022-04-24 Blue Earth Minnesota 27013 18061 98
2435776 2435776 2022-04-23 Blue Earth Minnesota 27013 18061 98
2432520 2432520 2022-04-22 Blue Earth Minnesota 27013 18061 98
2429264 2429264 2022-04-21 Blue Earth Minnesota 27013 18035 98
2426008 2426008 2022-04-20 Blue Earth Minnesota 27013 18014 98
2422752 2422752 2022-04-19 Blue Earth Minnesota 27013 18006 98
2419496 2419496 2022-04-18 Blue Earth Minnesota 27013 17983 98
2416240 2416240 2022-04-17 Blue Earth Minnesota 27013 17968 98
2412984 2412984 2022-04-16 Blue Earth Minnesota 27013 17968 98
2409728 2409728 2022-04-15 Blue Earth Minnesota 27013 17968 98
2406472 2406472 2022-04-14 Blue Earth Minnesota 27013 17955 98
2403216 2403216 2022-04-13 Blue Earth Minnesota 27013 17942 98
2399962 2399962 2022-04-12 Blue Earth Minnesota 27013 17935 98
2396706 2396706 2022-04-11 Blue Earth Minnesota 27013 17906 98
2393451 2393451 2022-04-10 Blue Earth Minnesota 27013 17893 98
2390195 2390195 2022-04-09 Blue Earth Minnesota 27013 17893 98
2386939 2386939 2022-04-08 Blue Earth Minnesota 27013 17893 98
2383684 2383684 2022-04-07 Blue Earth Minnesota 27013 17884 98
2380429 2380429 2022-04-06 Blue Earth Minnesota 27013 17873 98
2377174 2377174 2022-04-05 Blue Earth Minnesota 27013 17871 98
2373922 2373922 2022-04-04 Blue Earth Minnesota 27013 17856 98
2370669 2370669 2022-04-03 Blue Earth Minnesota 27013 17852 98
2367416 2367416 2022-04-02 Blue Earth Minnesota 27013 17852 98
2364163 2364163 2022-04-01 Blue Earth Minnesota 27013 17852 98
2360909 2360909 2022-03-31 Blue Earth Minnesota 27013 17850 98
2357655 2357655 2022-03-30 Blue Earth Minnesota 27013 17846 98
2354402 2354402 2022-03-29 Blue Earth Minnesota 27013 17843 98
2351150 2351150 2022-03-28 Blue Earth Minnesota 27013 17829 98
2347897 2347897 2022-03-27 Blue Earth Minnesota 27013 17822 98
2344644 2344644 2022-03-26 Blue Earth Minnesota 27013 17822 98
2341391 2341391 2022-03-25 Blue Earth Minnesota 27013 17822 98
2338138 2338138 2022-03-24 Blue Earth Minnesota 27013 17811 98
2334884 2334884 2022-03-23 Blue Earth Minnesota 27013 17804 98
2331630 2331630 2022-03-22 Blue Earth Minnesota 27013 17800 98
2328378 2328378 2022-03-21 Blue Earth Minnesota 27013 17785 98
2325125 2325125 2022-03-20 Blue Earth Minnesota 27013 17784 98
2321871 2321871 2022-03-19 Blue Earth Minnesota 27013 17784 98
2318617 2318617 2022-03-18 Blue Earth Minnesota 27013 17784 98
2315364 2315364 2022-03-17 Blue Earth Minnesota 27013 17780 97
2312111 2312111 2022-03-16 Blue Earth Minnesota 27013 17778 97
2308858 2308858 2022-03-15 Blue Earth Minnesota 27013 17770 97
2305607 2305607 2022-03-14 Blue Earth Minnesota 27013 17765 97
2302355 2302355 2022-03-13 Blue Earth Minnesota 27013 17758 97
2299103 2299103 2022-03-12 Blue Earth Minnesota 27013 17758 97
2295851 2295851 2022-03-11 Blue Earth Minnesota 27013 17758 97
2292599 2292599 2022-03-10 Blue Earth Minnesota 27013 17569 97
2289347 2289347 2022-03-09 Blue Earth Minnesota 27013 17552 97
2286096 2286096 2022-03-08 Blue Earth Minnesota 27013 17545 97
2282844 2282844 2022-03-07 Blue Earth Minnesota 27013 17528 97
2279591 2279591 2022-03-06 Blue Earth Minnesota 27013 17500 96
2276338 2276338 2022-03-05 Blue Earth Minnesota 27013 17500 96
2273085 2273085 2022-03-04 Blue Earth Minnesota 27013 17500 96
2269833 2269833 2022-03-03 Blue Earth Minnesota 27013 17487 96
2266580 2266580 2022-03-02 Blue Earth Minnesota 27013 17476 94
2263329 2263329 2022-03-01 Blue Earth Minnesota 27013 17469 94
2260078 2260078 2022-02-28 Blue Earth Minnesota 27013 17444 93
2256827 2256827 2022-02-27 Blue Earth Minnesota 27013 17433 91
2253576 2253576 2022-02-26 Blue Earth Minnesota 27013 17433 91
2250325 2250325 2022-02-25 Blue Earth Minnesota 27013 17433 91
2247074 2247074 2022-02-24 Blue Earth Minnesota 27013 17413 91
2243823 2243823 2022-02-23 Blue Earth Minnesota 27013 17401 91
2240572 2240572 2022-02-22 Blue Earth Minnesota 27013 17346 91
2237321 2237321 2022-02-21 Blue Earth Minnesota 27013 17266 91
2234070 2234070 2022-02-20 Blue Earth Minnesota 27013 17266 91
2230819 2230819 2022-02-19 Blue Earth Minnesota 27013 17266 91
2227568 2227568 2022-02-18 Blue Earth Minnesota 27013 17266 91
2224317 2224317 2022-02-17 Blue Earth Minnesota 27013 17210 90
2221066 2221066 2022-02-16 Blue Earth Minnesota 27013 17189 89
2217815 2217815 2022-02-15 Blue Earth Minnesota 27013 17177 89
2214564 2214564 2022-02-14 Blue Earth Minnesota 27013 17117 89
2211312 2211312 2022-02-13 Blue Earth Minnesota 27013 17057 88
2208059 2208059 2022-02-12 Blue Earth Minnesota 27013 17057 88
2204806 2204806 2022-02-11 Blue Earth Minnesota 27013 17057 88
2201553 2201553 2022-02-10 Blue Earth Minnesota 27013 17016 88
2198299 2198299 2022-02-09 Blue Earth Minnesota 27013 16944 88
2195045 2195045 2022-02-08 Blue Earth Minnesota 27013 16842 88
2191791 2191791 2022-02-07 Blue Earth Minnesota 27013 16696 88
2188538 2188538 2022-02-06 Blue Earth Minnesota 27013 16605 88
2185285 2185285 2022-02-05 Blue Earth Minnesota 27013 16605 88
2182033 2182033 2022-02-04 Blue Earth Minnesota 27013 16605 88
2178781 2178781 2022-02-03 Blue Earth Minnesota 27013 16517 88

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