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 county = "Benton" 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

county 1

  • Benton · 789 ✖
Link rowid date ▲ county state fips cases deaths
2500909 2500909 2022-05-13 Benton Minnesota 27009 14298 174
2497651 2497651 2022-05-12 Benton Minnesota 27009 14284 174
2494393 2494393 2022-05-11 Benton Minnesota 27009 14260 174
2491135 2491135 2022-05-10 Benton Minnesota 27009 14253 174
2487878 2487878 2022-05-09 Benton Minnesota 27009 14228 174
2484620 2484620 2022-05-08 Benton Minnesota 27009 14204 174
2481362 2481362 2022-05-07 Benton Minnesota 27009 14204 174
2478104 2478104 2022-05-06 Benton Minnesota 27009 14204 174
2474846 2474846 2022-05-05 Benton Minnesota 27009 14193 174
2471589 2471589 2022-05-04 Benton Minnesota 27009 14178 174
2468333 2468333 2022-05-03 Benton Minnesota 27009 14162 174
2465078 2465078 2022-05-02 Benton Minnesota 27009 14144 174
2461822 2461822 2022-05-01 Benton Minnesota 27009 14136 174
2458566 2458566 2022-04-30 Benton Minnesota 27009 14136 174
2455310 2455310 2022-04-29 Benton Minnesota 27009 14136 174
2452054 2452054 2022-04-28 Benton Minnesota 27009 14118 174
2448798 2448798 2022-04-27 Benton Minnesota 27009 14104 174
2445542 2445542 2022-04-26 Benton Minnesota 27009 14096 174
2442286 2442286 2022-04-25 Benton Minnesota 27009 14077 174
2439030 2439030 2022-04-24 Benton Minnesota 27009 14068 174
2435774 2435774 2022-04-23 Benton Minnesota 27009 14068 174
2432518 2432518 2022-04-22 Benton Minnesota 27009 14068 174
2429262 2429262 2022-04-21 Benton Minnesota 27009 14055 174
2426006 2426006 2022-04-20 Benton Minnesota 27009 14045 174
2422750 2422750 2022-04-19 Benton Minnesota 27009 14041 174
2419494 2419494 2022-04-18 Benton Minnesota 27009 14032 174
2416238 2416238 2022-04-17 Benton Minnesota 27009 14031 174
2412982 2412982 2022-04-16 Benton Minnesota 27009 14031 174
2409726 2409726 2022-04-15 Benton Minnesota 27009 14031 174
2406470 2406470 2022-04-14 Benton Minnesota 27009 14029 174
2403214 2403214 2022-04-13 Benton Minnesota 27009 14025 174
2399960 2399960 2022-04-12 Benton Minnesota 27009 14022 174
2396704 2396704 2022-04-11 Benton Minnesota 27009 14013 174
2393449 2393449 2022-04-10 Benton Minnesota 27009 14010 174
2390193 2390193 2022-04-09 Benton Minnesota 27009 14010 174
2386937 2386937 2022-04-08 Benton Minnesota 27009 14010 174
2383682 2383682 2022-04-07 Benton Minnesota 27009 14008 174
2380427 2380427 2022-04-06 Benton Minnesota 27009 14005 174
2377172 2377172 2022-04-05 Benton Minnesota 27009 14002 174
2373920 2373920 2022-04-04 Benton Minnesota 27009 13996 174
2370667 2370667 2022-04-03 Benton Minnesota 27009 13995 174
2367414 2367414 2022-04-02 Benton Minnesota 27009 13995 174
2364161 2364161 2022-04-01 Benton Minnesota 27009 13995 174
2360907 2360907 2022-03-31 Benton Minnesota 27009 13987 174
2357653 2357653 2022-03-30 Benton Minnesota 27009 13986 174
2354400 2354400 2022-03-29 Benton Minnesota 27009 13985 174
2351148 2351148 2022-03-28 Benton Minnesota 27009 13980 174
2347895 2347895 2022-03-27 Benton Minnesota 27009 13977 174
2344642 2344642 2022-03-26 Benton Minnesota 27009 13977 174
2341389 2341389 2022-03-25 Benton Minnesota 27009 13977 174
2338136 2338136 2022-03-24 Benton Minnesota 27009 13976 174
2334882 2334882 2022-03-23 Benton Minnesota 27009 13975 174
2331628 2331628 2022-03-22 Benton Minnesota 27009 13973 174
2328376 2328376 2022-03-21 Benton Minnesota 27009 13969 174
2325123 2325123 2022-03-20 Benton Minnesota 27009 13965 174
2321869 2321869 2022-03-19 Benton Minnesota 27009 13965 174
2318615 2318615 2022-03-18 Benton Minnesota 27009 13965 174
2315362 2315362 2022-03-17 Benton Minnesota 27009 13960 174
2312109 2312109 2022-03-16 Benton Minnesota 27009 13957 174
2308856 2308856 2022-03-15 Benton Minnesota 27009 13954 174
2305605 2305605 2022-03-14 Benton Minnesota 27009 13929 174
2302353 2302353 2022-03-13 Benton Minnesota 27009 13924 173
2299101 2299101 2022-03-12 Benton Minnesota 27009 13924 173
2295849 2295849 2022-03-11 Benton Minnesota 27009 13924 173
2292597 2292597 2022-03-10 Benton Minnesota 27009 13819 173
2289345 2289345 2022-03-09 Benton Minnesota 27009 13815 172
2286094 2286094 2022-03-08 Benton Minnesota 27009 13813 169
2282842 2282842 2022-03-07 Benton Minnesota 27009 13799 169
2279589 2279589 2022-03-06 Benton Minnesota 27009 13793 168
2276336 2276336 2022-03-05 Benton Minnesota 27009 13793 168
2273083 2273083 2022-03-04 Benton Minnesota 27009 13793 168
2269831 2269831 2022-03-03 Benton Minnesota 27009 13787 168
2266578 2266578 2022-03-02 Benton Minnesota 27009 13782 168
2263327 2263327 2022-03-01 Benton Minnesota 27009 13776 168
2260076 2260076 2022-02-28 Benton Minnesota 27009 13761 167
2256825 2256825 2022-02-27 Benton Minnesota 27009 13748 166
2253574 2253574 2022-02-26 Benton Minnesota 27009 13748 166
2250323 2250323 2022-02-25 Benton Minnesota 27009 13748 166
2247072 2247072 2022-02-24 Benton Minnesota 27009 13743 165
2243821 2243821 2022-02-23 Benton Minnesota 27009 13737 165
2240570 2240570 2022-02-22 Benton Minnesota 27009 13707 165
2237319 2237319 2022-02-21 Benton Minnesota 27009 13690 165
2234068 2234068 2022-02-20 Benton Minnesota 27009 13690 165
2230817 2230817 2022-02-19 Benton Minnesota 27009 13690 165
2227566 2227566 2022-02-18 Benton Minnesota 27009 13690 165
2224315 2224315 2022-02-17 Benton Minnesota 27009 13654 165
2221064 2221064 2022-02-16 Benton Minnesota 27009 13637 165
2217813 2217813 2022-02-15 Benton Minnesota 27009 13618 165
2214562 2214562 2022-02-14 Benton Minnesota 27009 13555 164
2211310 2211310 2022-02-13 Benton Minnesota 27009 13447 164
2208057 2208057 2022-02-12 Benton Minnesota 27009 13447 164
2204804 2204804 2022-02-11 Benton Minnesota 27009 13447 164
2201551 2201551 2022-02-10 Benton Minnesota 27009 13396 164
2198297 2198297 2022-02-09 Benton Minnesota 27009 13359 163
2195043 2195043 2022-02-08 Benton Minnesota 27009 13284 163
2191789 2191789 2022-02-07 Benton Minnesota 27009 13186 163
2188536 2188536 2022-02-06 Benton Minnesota 27009 13116 162
2185283 2185283 2022-02-05 Benton Minnesota 27009 13116 162
2182031 2182031 2022-02-04 Benton Minnesota 27009 13116 162
2178779 2178779 2022-02-03 Benton Minnesota 27009 13047 162

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