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

787 rows where county = "Rice" 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 · 787 ✖

fips 1

county 1

  • Rice · 787 ✖
Link rowid date ▲ county state fips cases deaths
2500970 2500970 2022-05-13 Rice Minnesota 27131 18357 176
2497712 2497712 2022-05-12 Rice Minnesota 27131 18330 176
2494454 2494454 2022-05-11 Rice Minnesota 27131 18307 176
2491196 2491196 2022-05-10 Rice Minnesota 27131 18278 176
2487939 2487939 2022-05-09 Rice Minnesota 27131 18219 176
2484681 2484681 2022-05-08 Rice Minnesota 27131 18171 176
2481423 2481423 2022-05-07 Rice Minnesota 27131 18171 176
2478165 2478165 2022-05-06 Rice Minnesota 27131 18171 176
2474907 2474907 2022-05-05 Rice Minnesota 27131 18134 176
2471650 2471650 2022-05-04 Rice Minnesota 27131 18103 176
2468394 2468394 2022-05-03 Rice Minnesota 27131 18085 176
2465139 2465139 2022-05-02 Rice Minnesota 27131 18062 176
2461883 2461883 2022-05-01 Rice Minnesota 27131 18052 176
2458627 2458627 2022-04-30 Rice Minnesota 27131 18052 176
2455371 2455371 2022-04-29 Rice Minnesota 27131 18052 176
2452115 2452115 2022-04-28 Rice Minnesota 27131 18041 176
2448859 2448859 2022-04-27 Rice Minnesota 27131 18023 175
2445603 2445603 2022-04-26 Rice Minnesota 27131 18015 175
2442347 2442347 2022-04-25 Rice Minnesota 27131 17996 175
2439091 2439091 2022-04-24 Rice Minnesota 27131 17985 175
2435835 2435835 2022-04-23 Rice Minnesota 27131 17985 175
2432579 2432579 2022-04-22 Rice Minnesota 27131 17985 175
2429323 2429323 2022-04-21 Rice Minnesota 27131 17974 175
2426067 2426067 2022-04-20 Rice Minnesota 27131 17962 175
2422811 2422811 2022-04-19 Rice Minnesota 27131 17953 175
2419555 2419555 2022-04-18 Rice Minnesota 27131 17940 175
2416299 2416299 2022-04-17 Rice Minnesota 27131 17929 175
2413043 2413043 2022-04-16 Rice Minnesota 27131 17929 175
2409787 2409787 2022-04-15 Rice Minnesota 27131 17929 175
2406531 2406531 2022-04-14 Rice Minnesota 27131 17925 175
2403275 2403275 2022-04-13 Rice Minnesota 27131 17917 175
2400021 2400021 2022-04-12 Rice Minnesota 27131 17910 175
2396765 2396765 2022-04-11 Rice Minnesota 27131 17902 175
2393510 2393510 2022-04-10 Rice Minnesota 27131 17898 175
2390254 2390254 2022-04-09 Rice Minnesota 27131 17898 175
2386998 2386998 2022-04-08 Rice Minnesota 27131 17898 175
2383743 2383743 2022-04-07 Rice Minnesota 27131 17894 174
2380488 2380488 2022-04-06 Rice Minnesota 27131 17884 174
2377233 2377233 2022-04-05 Rice Minnesota 27131 17874 173
2373981 2373981 2022-04-04 Rice Minnesota 27131 17867 173
2370728 2370728 2022-04-03 Rice Minnesota 27131 17865 173
2367475 2367475 2022-04-02 Rice Minnesota 27131 17865 173
2364222 2364222 2022-04-01 Rice Minnesota 27131 17865 173
2360968 2360968 2022-03-31 Rice Minnesota 27131 17855 173
2357714 2357714 2022-03-30 Rice Minnesota 27131 17853 173
2354461 2354461 2022-03-29 Rice Minnesota 27131 17851 173
2351209 2351209 2022-03-28 Rice Minnesota 27131 17842 173
2347956 2347956 2022-03-27 Rice Minnesota 27131 17836 172
2344703 2344703 2022-03-26 Rice Minnesota 27131 17836 172
2341450 2341450 2022-03-25 Rice Minnesota 27131 17836 172
2338197 2338197 2022-03-24 Rice Minnesota 27131 17830 172
2334943 2334943 2022-03-23 Rice Minnesota 27131 17821 172
2331689 2331689 2022-03-22 Rice Minnesota 27131 17805 172
2328437 2328437 2022-03-21 Rice Minnesota 27131 17794 172
2325184 2325184 2022-03-20 Rice Minnesota 27131 17787 172
2321930 2321930 2022-03-19 Rice Minnesota 27131 17787 172
2318676 2318676 2022-03-18 Rice Minnesota 27131 17787 172
2315423 2315423 2022-03-17 Rice Minnesota 27131 17773 171
2312170 2312170 2022-03-16 Rice Minnesota 27131 17764 171
2308917 2308917 2022-03-15 Rice Minnesota 27131 17743 171
2305666 2305666 2022-03-14 Rice Minnesota 27131 17712 171
2302414 2302414 2022-03-13 Rice Minnesota 27131 17704 171
2299162 2299162 2022-03-12 Rice Minnesota 27131 17704 171
2295910 2295910 2022-03-11 Rice Minnesota 27131 17704 171
2292658 2292658 2022-03-10 Rice Minnesota 27131 17626 171
2289406 2289406 2022-03-09 Rice Minnesota 27131 17604 171
2286155 2286155 2022-03-08 Rice Minnesota 27131 17595 171
2282903 2282903 2022-03-07 Rice Minnesota 27131 17554 171
2279650 2279650 2022-03-06 Rice Minnesota 27131 17514 171
2276397 2276397 2022-03-05 Rice Minnesota 27131 17514 171
2273144 2273144 2022-03-04 Rice Minnesota 27131 17514 171
2269892 2269892 2022-03-03 Rice Minnesota 27131 17451 170
2266639 2266639 2022-03-02 Rice Minnesota 27131 17436 168
2263388 2263388 2022-03-01 Rice Minnesota 27131 17419 168
2260137 2260137 2022-02-28 Rice Minnesota 27131 17406 168
2256886 2256886 2022-02-27 Rice Minnesota 27131 17401 167
2253635 2253635 2022-02-26 Rice Minnesota 27131 17401 167
2250384 2250384 2022-02-25 Rice Minnesota 27131 17401 167
2247133 2247133 2022-02-24 Rice Minnesota 27131 17390 167
2243882 2243882 2022-02-23 Rice Minnesota 27131 17374 167
2240631 2240631 2022-02-22 Rice Minnesota 27131 17349 167
2237380 2237380 2022-02-21 Rice Minnesota 27131 17347 167
2234129 2234129 2022-02-20 Rice Minnesota 27131 17347 167
2230878 2230878 2022-02-19 Rice Minnesota 27131 17347 167
2227627 2227627 2022-02-18 Rice Minnesota 27131 17347 167
2224376 2224376 2022-02-17 Rice Minnesota 27131 17280 167
2221125 2221125 2022-02-16 Rice Minnesota 27131 17261 167
2217874 2217874 2022-02-15 Rice Minnesota 27131 17254 167
2214623 2214623 2022-02-14 Rice Minnesota 27131 17201 165
2211371 2211371 2022-02-13 Rice Minnesota 27131 17137 165
2208118 2208118 2022-02-12 Rice Minnesota 27131 17137 165
2204865 2204865 2022-02-11 Rice Minnesota 27131 17137 165
2201612 2201612 2022-02-10 Rice Minnesota 27131 17084 164
2198358 2198358 2022-02-09 Rice Minnesota 27131 17021 163
2195104 2195104 2022-02-08 Rice Minnesota 27131 16955 163
2191850 2191850 2022-02-07 Rice Minnesota 27131 16826 163
2188597 2188597 2022-02-06 Rice Minnesota 27131 16755 163
2185344 2185344 2022-02-05 Rice Minnesota 27131 16755 163
2182092 2182092 2022-02-04 Rice Minnesota 27131 16755 163
2178840 2178840 2022-02-03 Rice Minnesota 27131 16667 163

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