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

786 rows where county = "Mower" 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 · 786 ✖

fips 1

county 1

  • Mower · 786 ✖
Link rowid date ▲ county state fips cases deaths
2500954 2500954 2022-05-13 Mower Minnesota 27099 12083 74
2497696 2497696 2022-05-12 Mower Minnesota 27099 12070 73
2494438 2494438 2022-05-11 Mower Minnesota 27099 12057 73
2491180 2491180 2022-05-10 Mower Minnesota 27099 12046 73
2487923 2487923 2022-05-09 Mower Minnesota 27099 12029 73
2484665 2484665 2022-05-08 Mower Minnesota 27099 12017 73
2481407 2481407 2022-05-07 Mower Minnesota 27099 12017 73
2478149 2478149 2022-05-06 Mower Minnesota 27099 12017 73
2474891 2474891 2022-05-05 Mower Minnesota 27099 12006 73
2471634 2471634 2022-05-04 Mower Minnesota 27099 11987 73
2468378 2468378 2022-05-03 Mower Minnesota 27099 11975 73
2465123 2465123 2022-05-02 Mower Minnesota 27099 11964 73
2461867 2461867 2022-05-01 Mower Minnesota 27099 11956 73
2458611 2458611 2022-04-30 Mower Minnesota 27099 11956 73
2455355 2455355 2022-04-29 Mower Minnesota 27099 11956 73
2452099 2452099 2022-04-28 Mower Minnesota 27099 11937 73
2448843 2448843 2022-04-27 Mower Minnesota 27099 11926 73
2445587 2445587 2022-04-26 Mower Minnesota 27099 11918 73
2442331 2442331 2022-04-25 Mower Minnesota 27099 11902 73
2439075 2439075 2022-04-24 Mower Minnesota 27099 11892 73
2435819 2435819 2022-04-23 Mower Minnesota 27099 11892 73
2432563 2432563 2022-04-22 Mower Minnesota 27099 11892 73
2429307 2429307 2022-04-21 Mower Minnesota 27099 11884 73
2426051 2426051 2022-04-20 Mower Minnesota 27099 11877 73
2422795 2422795 2022-04-19 Mower Minnesota 27099 11871 73
2419539 2419539 2022-04-18 Mower Minnesota 27099 11867 73
2416283 2416283 2022-04-17 Mower Minnesota 27099 11865 73
2413027 2413027 2022-04-16 Mower Minnesota 27099 11865 73
2409771 2409771 2022-04-15 Mower Minnesota 27099 11865 73
2406515 2406515 2022-04-14 Mower Minnesota 27099 11863 73
2403259 2403259 2022-04-13 Mower Minnesota 27099 11857 73
2400005 2400005 2022-04-12 Mower Minnesota 27099 11851 73
2396749 2396749 2022-04-11 Mower Minnesota 27099 11848 73
2393494 2393494 2022-04-10 Mower Minnesota 27099 11845 72
2390238 2390238 2022-04-09 Mower Minnesota 27099 11845 72
2386982 2386982 2022-04-08 Mower Minnesota 27099 11845 72
2383727 2383727 2022-04-07 Mower Minnesota 27099 11841 72
2380472 2380472 2022-04-06 Mower Minnesota 27099 11836 72
2377217 2377217 2022-04-05 Mower Minnesota 27099 11834 72
2373965 2373965 2022-04-04 Mower Minnesota 27099 11826 72
2370712 2370712 2022-04-03 Mower Minnesota 27099 11824 72
2367459 2367459 2022-04-02 Mower Minnesota 27099 11824 72
2364206 2364206 2022-04-01 Mower Minnesota 27099 11824 72
2360952 2360952 2022-03-31 Mower Minnesota 27099 11823 72
2357698 2357698 2022-03-30 Mower Minnesota 27099 11820 72
2354445 2354445 2022-03-29 Mower Minnesota 27099 11817 71
2351193 2351193 2022-03-28 Mower Minnesota 27099 11812 71
2347940 2347940 2022-03-27 Mower Minnesota 27099 11809 71
2344687 2344687 2022-03-26 Mower Minnesota 27099 11809 71
2341434 2341434 2022-03-25 Mower Minnesota 27099 11809 71
2338181 2338181 2022-03-24 Mower Minnesota 27099 11807 71
2334927 2334927 2022-03-23 Mower Minnesota 27099 11801 71
2331673 2331673 2022-03-22 Mower Minnesota 27099 11795 71
2328421 2328421 2022-03-21 Mower Minnesota 27099 11790 71
2325168 2325168 2022-03-20 Mower Minnesota 27099 11788 70
2321914 2321914 2022-03-19 Mower Minnesota 27099 11788 70
2318660 2318660 2022-03-18 Mower Minnesota 27099 11788 70
2315407 2315407 2022-03-17 Mower Minnesota 27099 11783 70
2312154 2312154 2022-03-16 Mower Minnesota 27099 11781 70
2308901 2308901 2022-03-15 Mower Minnesota 27099 11773 70
2305650 2305650 2022-03-14 Mower Minnesota 27099 11770 70
2302398 2302398 2022-03-13 Mower Minnesota 27099 11768 70
2299146 2299146 2022-03-12 Mower Minnesota 27099 11768 70
2295894 2295894 2022-03-11 Mower Minnesota 27099 11768 70
2292642 2292642 2022-03-10 Mower Minnesota 27099 11760 70
2289390 2289390 2022-03-09 Mower Minnesota 27099 11759 70
2286139 2286139 2022-03-08 Mower Minnesota 27099 11754 70
2282887 2282887 2022-03-07 Mower Minnesota 27099 11745 69
2279634 2279634 2022-03-06 Mower Minnesota 27099 11737 69
2276381 2276381 2022-03-05 Mower Minnesota 27099 11737 69
2273128 2273128 2022-03-04 Mower Minnesota 27099 11737 69
2269876 2269876 2022-03-03 Mower Minnesota 27099 11734 69
2266623 2266623 2022-03-02 Mower Minnesota 27099 11723 69
2263372 2263372 2022-03-01 Mower Minnesota 27099 11716 68
2260121 2260121 2022-02-28 Mower Minnesota 27099 11702 68
2256870 2256870 2022-02-27 Mower Minnesota 27099 11692 68
2253619 2253619 2022-02-26 Mower Minnesota 27099 11692 68
2250368 2250368 2022-02-25 Mower Minnesota 27099 11692 68
2247117 2247117 2022-02-24 Mower Minnesota 27099 11682 68
2243866 2243866 2022-02-23 Mower Minnesota 27099 11676 67
2240615 2240615 2022-02-22 Mower Minnesota 27099 11638 67
2237364 2237364 2022-02-21 Mower Minnesota 27099 11624 67
2234113 2234113 2022-02-20 Mower Minnesota 27099 11624 67
2230862 2230862 2022-02-19 Mower Minnesota 27099 11624 67
2227611 2227611 2022-02-18 Mower Minnesota 27099 11624 67
2224360 2224360 2022-02-17 Mower Minnesota 27099 11604 67
2221109 2221109 2022-02-16 Mower Minnesota 27099 11586 66
2217858 2217858 2022-02-15 Mower Minnesota 27099 11577 65
2214607 2214607 2022-02-14 Mower Minnesota 27099 11543 64
2211355 2211355 2022-02-13 Mower Minnesota 27099 11497 64
2208102 2208102 2022-02-12 Mower Minnesota 27099 11497 64
2204849 2204849 2022-02-11 Mower Minnesota 27099 11497 64
2201596 2201596 2022-02-10 Mower Minnesota 27099 11472 64
2198342 2198342 2022-02-09 Mower Minnesota 27099 11448 64
2195088 2195088 2022-02-08 Mower Minnesota 27099 11412 64
2191834 2191834 2022-02-07 Mower Minnesota 27099 11352 64
2188581 2188581 2022-02-06 Mower Minnesota 27099 11318 63
2185328 2185328 2022-02-05 Mower Minnesota 27099 11318 63
2182076 2182076 2022-02-04 Mower Minnesota 27099 11318 63
2178824 2178824 2022-02-03 Mower Minnesota 27099 11266 60

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