ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "Pipestone" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500963 | 2500963 | 2022-05-13 | Pipestone | Minnesota | 27117 | 2013 | 34 |
2497705 | 2497705 | 2022-05-12 | Pipestone | Minnesota | 27117 | 2012 | 34 |
2494447 | 2494447 | 2022-05-11 | Pipestone | Minnesota | 27117 | 2012 | 34 |
2491189 | 2491189 | 2022-05-10 | Pipestone | Minnesota | 27117 | 2012 | 34 |
2487932 | 2487932 | 2022-05-09 | Pipestone | Minnesota | 27117 | 2011 | 34 |
2484674 | 2484674 | 2022-05-08 | Pipestone | Minnesota | 27117 | 2011 | 34 |
2481416 | 2481416 | 2022-05-07 | Pipestone | Minnesota | 27117 | 2011 | 34 |
2478158 | 2478158 | 2022-05-06 | Pipestone | Minnesota | 27117 | 2011 | 34 |
2474900 | 2474900 | 2022-05-05 | Pipestone | Minnesota | 27117 | 2008 | 34 |
2471643 | 2471643 | 2022-05-04 | Pipestone | Minnesota | 27117 | 2008 | 34 |
2468387 | 2468387 | 2022-05-03 | Pipestone | Minnesota | 27117 | 2008 | 34 |
2465132 | 2465132 | 2022-05-02 | Pipestone | Minnesota | 27117 | 2005 | 34 |
2461876 | 2461876 | 2022-05-01 | Pipestone | Minnesota | 27117 | 2002 | 34 |
2458620 | 2458620 | 2022-04-30 | Pipestone | Minnesota | 27117 | 2002 | 34 |
2455364 | 2455364 | 2022-04-29 | Pipestone | Minnesota | 27117 | 2002 | 34 |
2452108 | 2452108 | 2022-04-28 | Pipestone | Minnesota | 27117 | 2002 | 34 |
2448852 | 2448852 | 2022-04-27 | Pipestone | Minnesota | 27117 | 2000 | 34 |
2445596 | 2445596 | 2022-04-26 | Pipestone | Minnesota | 27117 | 1991 | 34 |
2442340 | 2442340 | 2022-04-25 | Pipestone | Minnesota | 27117 | 1991 | 34 |
2439084 | 2439084 | 2022-04-24 | Pipestone | Minnesota | 27117 | 1990 | 34 |
2435828 | 2435828 | 2022-04-23 | Pipestone | Minnesota | 27117 | 1990 | 34 |
2432572 | 2432572 | 2022-04-22 | Pipestone | Minnesota | 27117 | 1990 | 34 |
2429316 | 2429316 | 2022-04-21 | Pipestone | Minnesota | 27117 | 1990 | 34 |
2426060 | 2426060 | 2022-04-20 | Pipestone | Minnesota | 27117 | 1990 | 34 |
2422804 | 2422804 | 2022-04-19 | Pipestone | Minnesota | 27117 | 1990 | 34 |
2419548 | 2419548 | 2022-04-18 | Pipestone | Minnesota | 27117 | 1989 | 34 |
2416292 | 2416292 | 2022-04-17 | Pipestone | Minnesota | 27117 | 1989 | 34 |
2413036 | 2413036 | 2022-04-16 | Pipestone | Minnesota | 27117 | 1989 | 34 |
2409780 | 2409780 | 2022-04-15 | Pipestone | Minnesota | 27117 | 1989 | 34 |
2406524 | 2406524 | 2022-04-14 | Pipestone | Minnesota | 27117 | 1989 | 34 |
2403268 | 2403268 | 2022-04-13 | Pipestone | Minnesota | 27117 | 1989 | 34 |
2400014 | 2400014 | 2022-04-12 | Pipestone | Minnesota | 27117 | 1988 | 34 |
2396758 | 2396758 | 2022-04-11 | Pipestone | Minnesota | 27117 | 1988 | 34 |
2393503 | 2393503 | 2022-04-10 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2390247 | 2390247 | 2022-04-09 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2386991 | 2386991 | 2022-04-08 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2383736 | 2383736 | 2022-04-07 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2380481 | 2380481 | 2022-04-06 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2377226 | 2377226 | 2022-04-05 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2373974 | 2373974 | 2022-04-04 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2370721 | 2370721 | 2022-04-03 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2367468 | 2367468 | 2022-04-02 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2364215 | 2364215 | 2022-04-01 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2360961 | 2360961 | 2022-03-31 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2357707 | 2357707 | 2022-03-30 | Pipestone | Minnesota | 27117 | 1985 | 34 |
2354454 | 2354454 | 2022-03-29 | Pipestone | Minnesota | 27117 | 1985 | 34 |
2351202 | 2351202 | 2022-03-28 | Pipestone | Minnesota | 27117 | 1985 | 34 |
2347949 | 2347949 | 2022-03-27 | Pipestone | Minnesota | 27117 | 1983 | 34 |
2344696 | 2344696 | 2022-03-26 | Pipestone | Minnesota | 27117 | 1983 | 34 |
2341443 | 2341443 | 2022-03-25 | Pipestone | Minnesota | 27117 | 1983 | 34 |
2338190 | 2338190 | 2022-03-24 | Pipestone | Minnesota | 27117 | 1983 | 34 |
2334936 | 2334936 | 2022-03-23 | Pipestone | Minnesota | 27117 | 1983 | 34 |
2331682 | 2331682 | 2022-03-22 | Pipestone | Minnesota | 27117 | 1983 | 34 |
2328430 | 2328430 | 2022-03-21 | Pipestone | Minnesota | 27117 | 1982 | 34 |
2325177 | 2325177 | 2022-03-20 | Pipestone | Minnesota | 27117 | 1982 | 34 |
2321923 | 2321923 | 2022-03-19 | Pipestone | Minnesota | 27117 | 1982 | 34 |
2318669 | 2318669 | 2022-03-18 | Pipestone | Minnesota | 27117 | 1982 | 34 |
2315416 | 2315416 | 2022-03-17 | Pipestone | Minnesota | 27117 | 1982 | 34 |
2312163 | 2312163 | 2022-03-16 | Pipestone | Minnesota | 27117 | 1981 | 34 |
2308910 | 2308910 | 2022-03-15 | Pipestone | Minnesota | 27117 | 1981 | 34 |
2305659 | 2305659 | 2022-03-14 | Pipestone | Minnesota | 27117 | 1981 | 34 |
2302407 | 2302407 | 2022-03-13 | Pipestone | Minnesota | 27117 | 1981 | 34 |
2299155 | 2299155 | 2022-03-12 | Pipestone | Minnesota | 27117 | 1981 | 34 |
2295903 | 2295903 | 2022-03-11 | Pipestone | Minnesota | 27117 | 1981 | 34 |
2292651 | 2292651 | 2022-03-10 | Pipestone | Minnesota | 27117 | 1979 | 34 |
2289399 | 2289399 | 2022-03-09 | Pipestone | Minnesota | 27117 | 1979 | 34 |
2286148 | 2286148 | 2022-03-08 | Pipestone | Minnesota | 27117 | 1979 | 34 |
2282896 | 2282896 | 2022-03-07 | Pipestone | Minnesota | 27117 | 1979 | 34 |
2279643 | 2279643 | 2022-03-06 | Pipestone | Minnesota | 27117 | 1977 | 34 |
2276390 | 2276390 | 2022-03-05 | Pipestone | Minnesota | 27117 | 1977 | 34 |
2273137 | 2273137 | 2022-03-04 | Pipestone | Minnesota | 27117 | 1977 | 34 |
2269885 | 2269885 | 2022-03-03 | Pipestone | Minnesota | 27117 | 1976 | 34 |
2266632 | 2266632 | 2022-03-02 | Pipestone | Minnesota | 27117 | 1975 | 34 |
2263381 | 2263381 | 2022-03-01 | Pipestone | Minnesota | 27117 | 1975 | 34 |
2260130 | 2260130 | 2022-02-28 | Pipestone | Minnesota | 27117 | 1973 | 34 |
2256879 | 2256879 | 2022-02-27 | Pipestone | Minnesota | 27117 | 1972 | 34 |
2253628 | 2253628 | 2022-02-26 | Pipestone | Minnesota | 27117 | 1972 | 34 |
2250377 | 2250377 | 2022-02-25 | Pipestone | Minnesota | 27117 | 1972 | 34 |
2247126 | 2247126 | 2022-02-24 | Pipestone | Minnesota | 27117 | 1971 | 34 |
2243875 | 2243875 | 2022-02-23 | Pipestone | Minnesota | 27117 | 1970 | 34 |
2240624 | 2240624 | 2022-02-22 | Pipestone | Minnesota | 27117 | 1969 | 34 |
2237373 | 2237373 | 2022-02-21 | Pipestone | Minnesota | 27117 | 1966 | 34 |
2234122 | 2234122 | 2022-02-20 | Pipestone | Minnesota | 27117 | 1966 | 34 |
2230871 | 2230871 | 2022-02-19 | Pipestone | Minnesota | 27117 | 1966 | 34 |
2227620 | 2227620 | 2022-02-18 | Pipestone | Minnesota | 27117 | 1966 | 34 |
2224369 | 2224369 | 2022-02-17 | Pipestone | Minnesota | 27117 | 1960 | 34 |
2221118 | 2221118 | 2022-02-16 | Pipestone | Minnesota | 27117 | 1955 | 33 |
2217867 | 2217867 | 2022-02-15 | Pipestone | Minnesota | 27117 | 1955 | 33 |
2214616 | 2214616 | 2022-02-14 | Pipestone | Minnesota | 27117 | 1951 | 33 |
2211364 | 2211364 | 2022-02-13 | Pipestone | Minnesota | 27117 | 1946 | 33 |
2208111 | 2208111 | 2022-02-12 | Pipestone | Minnesota | 27117 | 1946 | 33 |
2204858 | 2204858 | 2022-02-11 | Pipestone | Minnesota | 27117 | 1946 | 33 |
2201605 | 2201605 | 2022-02-10 | Pipestone | Minnesota | 27117 | 1942 | 33 |
2198351 | 2198351 | 2022-02-09 | Pipestone | Minnesota | 27117 | 1931 | 33 |
2195097 | 2195097 | 2022-02-08 | Pipestone | Minnesota | 27117 | 1926 | 33 |
2191843 | 2191843 | 2022-02-07 | Pipestone | Minnesota | 27117 | 1919 | 33 |
2188590 | 2188590 | 2022-02-06 | Pipestone | Minnesota | 27117 | 1911 | 33 |
2185337 | 2185337 | 2022-02-05 | Pipestone | Minnesota | 27117 | 1911 | 33 |
2182085 | 2182085 | 2022-02-04 | Pipestone | Minnesota | 27117 | 1911 | 33 |
2178833 | 2178833 | 2022-02-03 | Pipestone | Minnesota | 27117 | 1907 | 33 |
Advanced export
JSON shape: default, array, newline-delimited
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);