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

791 rows where fips = 27129 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 · 791 ✖

fips 1

  • 27129 · 791 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500969 2500969 2022-05-13 Renville Minnesota 27129 3783 56
2497711 2497711 2022-05-12 Renville Minnesota 27129 3783 56
2494453 2494453 2022-05-11 Renville Minnesota 27129 3779 56
2491195 2491195 2022-05-10 Renville Minnesota 27129 3776 56
2487938 2487938 2022-05-09 Renville Minnesota 27129 3770 56
2484680 2484680 2022-05-08 Renville Minnesota 27129 3769 56
2481422 2481422 2022-05-07 Renville Minnesota 27129 3769 56
2478164 2478164 2022-05-06 Renville Minnesota 27129 3769 56
2474906 2474906 2022-05-05 Renville Minnesota 27129 3765 56
2471649 2471649 2022-05-04 Renville Minnesota 27129 3762 56
2468393 2468393 2022-05-03 Renville Minnesota 27129 3758 56
2465138 2465138 2022-05-02 Renville Minnesota 27129 3754 56
2461882 2461882 2022-05-01 Renville Minnesota 27129 3752 56
2458626 2458626 2022-04-30 Renville Minnesota 27129 3752 56
2455370 2455370 2022-04-29 Renville Minnesota 27129 3752 56
2452114 2452114 2022-04-28 Renville Minnesota 27129 3751 56
2448858 2448858 2022-04-27 Renville Minnesota 27129 3749 56
2445602 2445602 2022-04-26 Renville Minnesota 27129 3748 56
2442346 2442346 2022-04-25 Renville Minnesota 27129 3746 56
2439090 2439090 2022-04-24 Renville Minnesota 27129 3746 56
2435834 2435834 2022-04-23 Renville Minnesota 27129 3746 56
2432578 2432578 2022-04-22 Renville Minnesota 27129 3746 56
2429322 2429322 2022-04-21 Renville Minnesota 27129 3746 56
2426066 2426066 2022-04-20 Renville Minnesota 27129 3744 56
2422810 2422810 2022-04-19 Renville Minnesota 27129 3743 56
2419554 2419554 2022-04-18 Renville Minnesota 27129 3739 56
2416298 2416298 2022-04-17 Renville Minnesota 27129 3736 56
2413042 2413042 2022-04-16 Renville Minnesota 27129 3736 56
2409786 2409786 2022-04-15 Renville Minnesota 27129 3736 56
2406530 2406530 2022-04-14 Renville Minnesota 27129 3736 56
2403274 2403274 2022-04-13 Renville Minnesota 27129 3735 56
2400020 2400020 2022-04-12 Renville Minnesota 27129 3735 56
2396764 2396764 2022-04-11 Renville Minnesota 27129 3733 56
2393509 2393509 2022-04-10 Renville Minnesota 27129 3732 56
2390253 2390253 2022-04-09 Renville Minnesota 27129 3732 56
2386997 2386997 2022-04-08 Renville Minnesota 27129 3732 56
2383742 2383742 2022-04-07 Renville Minnesota 27129 3731 56
2380487 2380487 2022-04-06 Renville Minnesota 27129 3731 56
2377232 2377232 2022-04-05 Renville Minnesota 27129 3731 56
2373980 2373980 2022-04-04 Renville Minnesota 27129 3730 56
2370727 2370727 2022-04-03 Renville Minnesota 27129 3728 56
2367474 2367474 2022-04-02 Renville Minnesota 27129 3728 56
2364221 2364221 2022-04-01 Renville Minnesota 27129 3728 56
2360967 2360967 2022-03-31 Renville Minnesota 27129 3728 56
2357713 2357713 2022-03-30 Renville Minnesota 27129 3728 56
2354460 2354460 2022-03-29 Renville Minnesota 27129 3728 56
2351208 2351208 2022-03-28 Renville Minnesota 27129 3727 56
2347955 2347955 2022-03-27 Renville Minnesota 27129 3727 56
2344702 2344702 2022-03-26 Renville Minnesota 27129 3727 56
2341449 2341449 2022-03-25 Renville Minnesota 27129 3727 56
2338196 2338196 2022-03-24 Renville Minnesota 27129 3727 56
2334942 2334942 2022-03-23 Renville Minnesota 27129 3726 56
2331688 2331688 2022-03-22 Renville Minnesota 27129 3726 56
2328436 2328436 2022-03-21 Renville Minnesota 27129 3723 56
2325183 2325183 2022-03-20 Renville Minnesota 27129 3722 56
2321929 2321929 2022-03-19 Renville Minnesota 27129 3722 56
2318675 2318675 2022-03-18 Renville Minnesota 27129 3722 56
2315422 2315422 2022-03-17 Renville Minnesota 27129 3722 56
2312169 2312169 2022-03-16 Renville Minnesota 27129 3721 56
2308916 2308916 2022-03-15 Renville Minnesota 27129 3718 56
2305665 2305665 2022-03-14 Renville Minnesota 27129 3713 56
2302413 2302413 2022-03-13 Renville Minnesota 27129 3713 56
2299161 2299161 2022-03-12 Renville Minnesota 27129 3713 56
2295909 2295909 2022-03-11 Renville Minnesota 27129 3713 56
2292657 2292657 2022-03-10 Renville Minnesota 27129 3641 56
2289405 2289405 2022-03-09 Renville Minnesota 27129 3640 56
2286154 2286154 2022-03-08 Renville Minnesota 27129 3639 56
2282902 2282902 2022-03-07 Renville Minnesota 27129 3633 56
2279649 2279649 2022-03-06 Renville Minnesota 27129 3631 56
2276396 2276396 2022-03-05 Renville Minnesota 27129 3631 56
2273143 2273143 2022-03-04 Renville Minnesota 27129 3631 56
2269891 2269891 2022-03-03 Renville Minnesota 27129 3630 56
2266638 2266638 2022-03-02 Renville Minnesota 27129 3626 56
2263387 2263387 2022-03-01 Renville Minnesota 27129 3616 56
2260136 2260136 2022-02-28 Renville Minnesota 27129 3606 56
2256885 2256885 2022-02-27 Renville Minnesota 27129 3603 55
2253634 2253634 2022-02-26 Renville Minnesota 27129 3603 55
2250383 2250383 2022-02-25 Renville Minnesota 27129 3603 55
2247132 2247132 2022-02-24 Renville Minnesota 27129 3598 55
2243881 2243881 2022-02-23 Renville Minnesota 27129 3593 55
2240630 2240630 2022-02-22 Renville Minnesota 27129 3570 55
2237379 2237379 2022-02-21 Renville Minnesota 27129 3574 55
2234128 2234128 2022-02-20 Renville Minnesota 27129 3574 55
2230877 2230877 2022-02-19 Renville Minnesota 27129 3574 55
2227626 2227626 2022-02-18 Renville Minnesota 27129 3574 55
2224375 2224375 2022-02-17 Renville Minnesota 27129 3546 54
2221124 2221124 2022-02-16 Renville Minnesota 27129 3538 54
2217873 2217873 2022-02-15 Renville Minnesota 27129 3533 54
2214622 2214622 2022-02-14 Renville Minnesota 27129 3511 54
2211370 2211370 2022-02-13 Renville Minnesota 27129 3488 54
2208117 2208117 2022-02-12 Renville Minnesota 27129 3488 54
2204864 2204864 2022-02-11 Renville Minnesota 27129 3488 54
2201611 2201611 2022-02-10 Renville Minnesota 27129 3480 54
2198357 2198357 2022-02-09 Renville Minnesota 27129 3480 54
2195103 2195103 2022-02-08 Renville Minnesota 27129 3461 54
2191849 2191849 2022-02-07 Renville Minnesota 27129 3438 54
2188596 2188596 2022-02-06 Renville Minnesota 27129 3421 54
2185343 2185343 2022-02-05 Renville Minnesota 27129 3421 54
2182091 2182091 2022-02-04 Renville Minnesota 27129 3421 54
2178839 2178839 2022-02-03 Renville Minnesota 27129 3403 53

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