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

782 rows where fips = 27011 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 · 782 ✖

fips 1

  • 27011 · 782 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500910 2500910 2022-05-13 Big Stone Minnesota 27011 1425 9
2497652 2497652 2022-05-12 Big Stone Minnesota 27011 1423 9
2494394 2494394 2022-05-11 Big Stone Minnesota 27011 1421 9
2491136 2491136 2022-05-10 Big Stone Minnesota 27011 1421 9
2487879 2487879 2022-05-09 Big Stone Minnesota 27011 1420 9
2484621 2484621 2022-05-08 Big Stone Minnesota 27011 1414 9
2481363 2481363 2022-05-07 Big Stone Minnesota 27011 1414 9
2478105 2478105 2022-05-06 Big Stone Minnesota 27011 1414 9
2474847 2474847 2022-05-05 Big Stone Minnesota 27011 1411 9
2471590 2471590 2022-05-04 Big Stone Minnesota 27011 1408 9
2468334 2468334 2022-05-03 Big Stone Minnesota 27011 1408 9
2465079 2465079 2022-05-02 Big Stone Minnesota 27011 1406 9
2461823 2461823 2022-05-01 Big Stone Minnesota 27011 1406 9
2458567 2458567 2022-04-30 Big Stone Minnesota 27011 1406 9
2455311 2455311 2022-04-29 Big Stone Minnesota 27011 1406 9
2452055 2452055 2022-04-28 Big Stone Minnesota 27011 1404 9
2448799 2448799 2022-04-27 Big Stone Minnesota 27011 1401 8
2445543 2445543 2022-04-26 Big Stone Minnesota 27011 1400 8
2442287 2442287 2022-04-25 Big Stone Minnesota 27011 1397 8
2439031 2439031 2022-04-24 Big Stone Minnesota 27011 1393 8
2435775 2435775 2022-04-23 Big Stone Minnesota 27011 1393 8
2432519 2432519 2022-04-22 Big Stone Minnesota 27011 1393 8
2429263 2429263 2022-04-21 Big Stone Minnesota 27011 1393 8
2426007 2426007 2022-04-20 Big Stone Minnesota 27011 1391 8
2422751 2422751 2022-04-19 Big Stone Minnesota 27011 1388 8
2419495 2419495 2022-04-18 Big Stone Minnesota 27011 1387 8
2416239 2416239 2022-04-17 Big Stone Minnesota 27011 1386 8
2412983 2412983 2022-04-16 Big Stone Minnesota 27011 1386 8
2409727 2409727 2022-04-15 Big Stone Minnesota 27011 1386 8
2406471 2406471 2022-04-14 Big Stone Minnesota 27011 1385 8
2403215 2403215 2022-04-13 Big Stone Minnesota 27011 1385 8
2399961 2399961 2022-04-12 Big Stone Minnesota 27011 1383 8
2396705 2396705 2022-04-11 Big Stone Minnesota 27011 1382 8
2393450 2393450 2022-04-10 Big Stone Minnesota 27011 1382 8
2390194 2390194 2022-04-09 Big Stone Minnesota 27011 1382 8
2386938 2386938 2022-04-08 Big Stone Minnesota 27011 1382 8
2383683 2383683 2022-04-07 Big Stone Minnesota 27011 1382 8
2380428 2380428 2022-04-06 Big Stone Minnesota 27011 1382 8
2377173 2377173 2022-04-05 Big Stone Minnesota 27011 1380 8
2373921 2373921 2022-04-04 Big Stone Minnesota 27011 1380 8
2370668 2370668 2022-04-03 Big Stone Minnesota 27011 1380 8
2367415 2367415 2022-04-02 Big Stone Minnesota 27011 1380 8
2364162 2364162 2022-04-01 Big Stone Minnesota 27011 1380 8
2360908 2360908 2022-03-31 Big Stone Minnesota 27011 1379 8
2357654 2357654 2022-03-30 Big Stone Minnesota 27011 1379 8
2354401 2354401 2022-03-29 Big Stone Minnesota 27011 1379 8
2351149 2351149 2022-03-28 Big Stone Minnesota 27011 1379 8
2347896 2347896 2022-03-27 Big Stone Minnesota 27011 1379 8
2344643 2344643 2022-03-26 Big Stone Minnesota 27011 1379 8
2341390 2341390 2022-03-25 Big Stone Minnesota 27011 1379 8
2338137 2338137 2022-03-24 Big Stone Minnesota 27011 1379 8
2334883 2334883 2022-03-23 Big Stone Minnesota 27011 1379 8
2331629 2331629 2022-03-22 Big Stone Minnesota 27011 1377 8
2328377 2328377 2022-03-21 Big Stone Minnesota 27011 1377 8
2325124 2325124 2022-03-20 Big Stone Minnesota 27011 1377 8
2321870 2321870 2022-03-19 Big Stone Minnesota 27011 1377 8
2318616 2318616 2022-03-18 Big Stone Minnesota 27011 1377 8
2315363 2315363 2022-03-17 Big Stone Minnesota 27011 1377 8
2312110 2312110 2022-03-16 Big Stone Minnesota 27011 1376 8
2308857 2308857 2022-03-15 Big Stone Minnesota 27011 1375 8
2305606 2305606 2022-03-14 Big Stone Minnesota 27011 1375 8
2302354 2302354 2022-03-13 Big Stone Minnesota 27011 1375 8
2299102 2299102 2022-03-12 Big Stone Minnesota 27011 1375 8
2295850 2295850 2022-03-11 Big Stone Minnesota 27011 1375 8
2292598 2292598 2022-03-10 Big Stone Minnesota 27011 1369 8
2289346 2289346 2022-03-09 Big Stone Minnesota 27011 1368 8
2286095 2286095 2022-03-08 Big Stone Minnesota 27011 1368 8
2282843 2282843 2022-03-07 Big Stone Minnesota 27011 1368 8
2279590 2279590 2022-03-06 Big Stone Minnesota 27011 1368 8
2276337 2276337 2022-03-05 Big Stone Minnesota 27011 1368 8
2273084 2273084 2022-03-04 Big Stone Minnesota 27011 1368 8
2269832 2269832 2022-03-03 Big Stone Minnesota 27011 1366 8
2266579 2266579 2022-03-02 Big Stone Minnesota 27011 1365 8
2263328 2263328 2022-03-01 Big Stone Minnesota 27011 1363 8
2260077 2260077 2022-02-28 Big Stone Minnesota 27011 1363 8
2256826 2256826 2022-02-27 Big Stone Minnesota 27011 1362 8
2253575 2253575 2022-02-26 Big Stone Minnesota 27011 1362 8
2250324 2250324 2022-02-25 Big Stone Minnesota 27011 1362 8
2247073 2247073 2022-02-24 Big Stone Minnesota 27011 1361 8
2243822 2243822 2022-02-23 Big Stone Minnesota 27011 1357 8
2240571 2240571 2022-02-22 Big Stone Minnesota 27011 1356 8
2237320 2237320 2022-02-21 Big Stone Minnesota 27011 1356 8
2234069 2234069 2022-02-20 Big Stone Minnesota 27011 1356 8
2230818 2230818 2022-02-19 Big Stone Minnesota 27011 1356 8
2227567 2227567 2022-02-18 Big Stone Minnesota 27011 1356 8
2224316 2224316 2022-02-17 Big Stone Minnesota 27011 1347 8
2221065 2221065 2022-02-16 Big Stone Minnesota 27011 1343 8
2217814 2217814 2022-02-15 Big Stone Minnesota 27011 1343 8
2214563 2214563 2022-02-14 Big Stone Minnesota 27011 1335 8
2211311 2211311 2022-02-13 Big Stone Minnesota 27011 1331 8
2208058 2208058 2022-02-12 Big Stone Minnesota 27011 1331 8
2204805 2204805 2022-02-11 Big Stone Minnesota 27011 1331 8
2201552 2201552 2022-02-10 Big Stone Minnesota 27011 1324 8
2198298 2198298 2022-02-09 Big Stone Minnesota 27011 1321 8
2195044 2195044 2022-02-08 Big Stone Minnesota 27011 1314 8
2191790 2191790 2022-02-07 Big Stone Minnesota 27011 1308 8
2188537 2188537 2022-02-06 Big Stone Minnesota 27011 1296 8
2185284 2185284 2022-02-05 Big Stone Minnesota 27011 1296 8
2182032 2182032 2022-02-04 Big Stone Minnesota 27011 1296 8
2178780 2178780 2022-02-03 Big Stone Minnesota 27011 1291 8

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