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

785 rows where fips = 27025 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 · 785 ✖

fips 1

  • 27025 · 785 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500917 2500917 2022-05-13 Chisago Minnesota 27025 14845 120
2497659 2497659 2022-05-12 Chisago Minnesota 27025 14815 120
2494401 2494401 2022-05-11 Chisago Minnesota 27025 14794 120
2491143 2491143 2022-05-10 Chisago Minnesota 27025 14777 120
2487886 2487886 2022-05-09 Chisago Minnesota 27025 14753 120
2484628 2484628 2022-05-08 Chisago Minnesota 27025 14726 120
2481370 2481370 2022-05-07 Chisago Minnesota 27025 14726 120
2478112 2478112 2022-05-06 Chisago Minnesota 27025 14726 120
2474854 2474854 2022-05-05 Chisago Minnesota 27025 14703 120
2471597 2471597 2022-05-04 Chisago Minnesota 27025 14687 120
2468341 2468341 2022-05-03 Chisago Minnesota 27025 14663 120
2465086 2465086 2022-05-02 Chisago Minnesota 27025 14647 120
2461830 2461830 2022-05-01 Chisago Minnesota 27025 14635 120
2458574 2458574 2022-04-30 Chisago Minnesota 27025 14635 120
2455318 2455318 2022-04-29 Chisago Minnesota 27025 14635 120
2452062 2452062 2022-04-28 Chisago Minnesota 27025 14618 120
2448806 2448806 2022-04-27 Chisago Minnesota 27025 14602 120
2445550 2445550 2022-04-26 Chisago Minnesota 27025 14596 120
2442294 2442294 2022-04-25 Chisago Minnesota 27025 14580 120
2439038 2439038 2022-04-24 Chisago Minnesota 27025 14570 120
2435782 2435782 2022-04-23 Chisago Minnesota 27025 14570 120
2432526 2432526 2022-04-22 Chisago Minnesota 27025 14570 120
2429270 2429270 2022-04-21 Chisago Minnesota 27025 14556 120
2426014 2426014 2022-04-20 Chisago Minnesota 27025 14546 120
2422758 2422758 2022-04-19 Chisago Minnesota 27025 14535 120
2419502 2419502 2022-04-18 Chisago Minnesota 27025 14530 120
2416246 2416246 2022-04-17 Chisago Minnesota 27025 14529 120
2412990 2412990 2022-04-16 Chisago Minnesota 27025 14529 120
2409734 2409734 2022-04-15 Chisago Minnesota 27025 14529 120
2406478 2406478 2022-04-14 Chisago Minnesota 27025 14525 120
2403222 2403222 2022-04-13 Chisago Minnesota 27025 14518 120
2399968 2399968 2022-04-12 Chisago Minnesota 27025 14517 120
2396712 2396712 2022-04-11 Chisago Minnesota 27025 14509 120
2393457 2393457 2022-04-10 Chisago Minnesota 27025 14507 120
2390201 2390201 2022-04-09 Chisago Minnesota 27025 14507 120
2386945 2386945 2022-04-08 Chisago Minnesota 27025 14507 120
2383690 2383690 2022-04-07 Chisago Minnesota 27025 14502 120
2380435 2380435 2022-04-06 Chisago Minnesota 27025 14498 120
2377180 2377180 2022-04-05 Chisago Minnesota 27025 14495 120
2373928 2373928 2022-04-04 Chisago Minnesota 27025 14490 120
2370675 2370675 2022-04-03 Chisago Minnesota 27025 14489 120
2367422 2367422 2022-04-02 Chisago Minnesota 27025 14489 120
2364169 2364169 2022-04-01 Chisago Minnesota 27025 14489 120
2360915 2360915 2022-03-31 Chisago Minnesota 27025 14487 120
2357661 2357661 2022-03-30 Chisago Minnesota 27025 14484 120
2354408 2354408 2022-03-29 Chisago Minnesota 27025 14483 120
2351156 2351156 2022-03-28 Chisago Minnesota 27025 14478 120
2347903 2347903 2022-03-27 Chisago Minnesota 27025 14473 120
2344650 2344650 2022-03-26 Chisago Minnesota 27025 14473 120
2341397 2341397 2022-03-25 Chisago Minnesota 27025 14473 120
2338144 2338144 2022-03-24 Chisago Minnesota 27025 14467 120
2334890 2334890 2022-03-23 Chisago Minnesota 27025 14463 120
2331636 2331636 2022-03-22 Chisago Minnesota 27025 14462 120
2328384 2328384 2022-03-21 Chisago Minnesota 27025 14455 120
2325131 2325131 2022-03-20 Chisago Minnesota 27025 14450 120
2321877 2321877 2022-03-19 Chisago Minnesota 27025 14450 120
2318623 2318623 2022-03-18 Chisago Minnesota 27025 14450 120
2315370 2315370 2022-03-17 Chisago Minnesota 27025 14448 119
2312117 2312117 2022-03-16 Chisago Minnesota 27025 14449 119
2308864 2308864 2022-03-15 Chisago Minnesota 27025 14439 119
2305613 2305613 2022-03-14 Chisago Minnesota 27025 14436 118
2302361 2302361 2022-03-13 Chisago Minnesota 27025 14432 118
2299109 2299109 2022-03-12 Chisago Minnesota 27025 14432 118
2295857 2295857 2022-03-11 Chisago Minnesota 27025 14432 118
2292605 2292605 2022-03-10 Chisago Minnesota 27025 14416 118
2289353 2289353 2022-03-09 Chisago Minnesota 27025 14415 118
2286102 2286102 2022-03-08 Chisago Minnesota 27025 14411 118
2282850 2282850 2022-03-07 Chisago Minnesota 27025 14407 117
2279597 2279597 2022-03-06 Chisago Minnesota 27025 14403 117
2276344 2276344 2022-03-05 Chisago Minnesota 27025 14403 117
2273091 2273091 2022-03-04 Chisago Minnesota 27025 14403 117
2269839 2269839 2022-03-03 Chisago Minnesota 27025 14396 117
2266586 2266586 2022-03-02 Chisago Minnesota 27025 14388 117
2263335 2263335 2022-03-01 Chisago Minnesota 27025 14388 116
2260084 2260084 2022-02-28 Chisago Minnesota 27025 14369 116
2256833 2256833 2022-02-27 Chisago Minnesota 27025 14359 116
2253582 2253582 2022-02-26 Chisago Minnesota 27025 14359 116
2250331 2250331 2022-02-25 Chisago Minnesota 27025 14359 116
2247080 2247080 2022-02-24 Chisago Minnesota 27025 14352 116
2243829 2243829 2022-02-23 Chisago Minnesota 27025 14345 116
2240578 2240578 2022-02-22 Chisago Minnesota 27025 14320 116
2237327 2237327 2022-02-21 Chisago Minnesota 27025 14283 116
2234076 2234076 2022-02-20 Chisago Minnesota 27025 14283 116
2230825 2230825 2022-02-19 Chisago Minnesota 27025 14283 116
2227574 2227574 2022-02-18 Chisago Minnesota 27025 14283 116
2224323 2224323 2022-02-17 Chisago Minnesota 27025 14245 115
2221072 2221072 2022-02-16 Chisago Minnesota 27025 14222 115
2217821 2217821 2022-02-15 Chisago Minnesota 27025 14201 115
2214570 2214570 2022-02-14 Chisago Minnesota 27025 14133 114
2211318 2211318 2022-02-13 Chisago Minnesota 27025 14008 114
2208065 2208065 2022-02-12 Chisago Minnesota 27025 14008 114
2204812 2204812 2022-02-11 Chisago Minnesota 27025 14008 114
2201559 2201559 2022-02-10 Chisago Minnesota 27025 13981 114
2198305 2198305 2022-02-09 Chisago Minnesota 27025 13939 114
2195051 2195051 2022-02-08 Chisago Minnesota 27025 13861 114
2191797 2191797 2022-02-07 Chisago Minnesota 27025 13716 114
2188544 2188544 2022-02-06 Chisago Minnesota 27025 13642 114
2185291 2185291 2022-02-05 Chisago Minnesota 27025 13642 114
2182039 2182039 2022-02-04 Chisago Minnesota 27025 13642 114
2178787 2178787 2022-02-03 Chisago Minnesota 27025 13558 114

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