ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Clearwater" and fips = 27029 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 |
---|---|---|---|---|---|---|---|
2500919 | 2500919 | 2022-05-13 | Clearwater | Minnesota | 27029 | 2175 | 30 |
2497661 | 2497661 | 2022-05-12 | Clearwater | Minnesota | 27029 | 2175 | 30 |
2494403 | 2494403 | 2022-05-11 | Clearwater | Minnesota | 27029 | 2175 | 30 |
2491145 | 2491145 | 2022-05-10 | Clearwater | Minnesota | 27029 | 2174 | 30 |
2487888 | 2487888 | 2022-05-09 | Clearwater | Minnesota | 27029 | 2173 | 30 |
2484630 | 2484630 | 2022-05-08 | Clearwater | Minnesota | 27029 | 2169 | 30 |
2481372 | 2481372 | 2022-05-07 | Clearwater | Minnesota | 27029 | 2169 | 30 |
2478114 | 2478114 | 2022-05-06 | Clearwater | Minnesota | 27029 | 2169 | 30 |
2474856 | 2474856 | 2022-05-05 | Clearwater | Minnesota | 27029 | 2169 | 30 |
2471599 | 2471599 | 2022-05-04 | Clearwater | Minnesota | 27029 | 2167 | 30 |
2468343 | 2468343 | 2022-05-03 | Clearwater | Minnesota | 27029 | 2167 | 30 |
2465088 | 2465088 | 2022-05-02 | Clearwater | Minnesota | 27029 | 2166 | 30 |
2461832 | 2461832 | 2022-05-01 | Clearwater | Minnesota | 27029 | 2165 | 30 |
2458576 | 2458576 | 2022-04-30 | Clearwater | Minnesota | 27029 | 2165 | 30 |
2455320 | 2455320 | 2022-04-29 | Clearwater | Minnesota | 27029 | 2165 | 30 |
2452064 | 2452064 | 2022-04-28 | Clearwater | Minnesota | 27029 | 2165 | 30 |
2448808 | 2448808 | 2022-04-27 | Clearwater | Minnesota | 27029 | 2163 | 30 |
2445552 | 2445552 | 2022-04-26 | Clearwater | Minnesota | 27029 | 2162 | 30 |
2442296 | 2442296 | 2022-04-25 | Clearwater | Minnesota | 27029 | 2161 | 30 |
2439040 | 2439040 | 2022-04-24 | Clearwater | Minnesota | 27029 | 2158 | 30 |
2435784 | 2435784 | 2022-04-23 | Clearwater | Minnesota | 27029 | 2158 | 30 |
2432528 | 2432528 | 2022-04-22 | Clearwater | Minnesota | 27029 | 2158 | 30 |
2429272 | 2429272 | 2022-04-21 | Clearwater | Minnesota | 27029 | 2157 | 30 |
2426016 | 2426016 | 2022-04-20 | Clearwater | Minnesota | 27029 | 2157 | 30 |
2422760 | 2422760 | 2022-04-19 | Clearwater | Minnesota | 27029 | 2155 | 30 |
2419504 | 2419504 | 2022-04-18 | Clearwater | Minnesota | 27029 | 2155 | 30 |
2416248 | 2416248 | 2022-04-17 | Clearwater | Minnesota | 27029 | 2155 | 30 |
2412992 | 2412992 | 2022-04-16 | Clearwater | Minnesota | 27029 | 2155 | 30 |
2409736 | 2409736 | 2022-04-15 | Clearwater | Minnesota | 27029 | 2155 | 30 |
2406480 | 2406480 | 2022-04-14 | Clearwater | Minnesota | 27029 | 2154 | 30 |
2403224 | 2403224 | 2022-04-13 | Clearwater | Minnesota | 27029 | 2154 | 30 |
2399970 | 2399970 | 2022-04-12 | Clearwater | Minnesota | 27029 | 2154 | 30 |
2396714 | 2396714 | 2022-04-11 | Clearwater | Minnesota | 27029 | 2154 | 30 |
2393459 | 2393459 | 2022-04-10 | Clearwater | Minnesota | 27029 | 2153 | 30 |
2390203 | 2390203 | 2022-04-09 | Clearwater | Minnesota | 27029 | 2153 | 30 |
2386947 | 2386947 | 2022-04-08 | Clearwater | Minnesota | 27029 | 2153 | 30 |
2383692 | 2383692 | 2022-04-07 | Clearwater | Minnesota | 27029 | 2153 | 30 |
2380437 | 2380437 | 2022-04-06 | Clearwater | Minnesota | 27029 | 2153 | 30 |
2377182 | 2377182 | 2022-04-05 | Clearwater | Minnesota | 27029 | 2153 | 30 |
2373930 | 2373930 | 2022-04-04 | Clearwater | Minnesota | 27029 | 2152 | 30 |
2370677 | 2370677 | 2022-04-03 | Clearwater | Minnesota | 27029 | 2152 | 30 |
2367424 | 2367424 | 2022-04-02 | Clearwater | Minnesota | 27029 | 2152 | 30 |
2364171 | 2364171 | 2022-04-01 | Clearwater | Minnesota | 27029 | 2152 | 30 |
2360917 | 2360917 | 2022-03-31 | Clearwater | Minnesota | 27029 | 2152 | 30 |
2357663 | 2357663 | 2022-03-30 | Clearwater | Minnesota | 27029 | 2150 | 30 |
2354410 | 2354410 | 2022-03-29 | Clearwater | Minnesota | 27029 | 2149 | 30 |
2351158 | 2351158 | 2022-03-28 | Clearwater | Minnesota | 27029 | 2148 | 30 |
2347905 | 2347905 | 2022-03-27 | Clearwater | Minnesota | 27029 | 2148 | 30 |
2344652 | 2344652 | 2022-03-26 | Clearwater | Minnesota | 27029 | 2148 | 30 |
2341399 | 2341399 | 2022-03-25 | Clearwater | Minnesota | 27029 | 2148 | 30 |
2338146 | 2338146 | 2022-03-24 | Clearwater | Minnesota | 27029 | 2148 | 30 |
2334892 | 2334892 | 2022-03-23 | Clearwater | Minnesota | 27029 | 2148 | 30 |
2331638 | 2331638 | 2022-03-22 | Clearwater | Minnesota | 27029 | 2148 | 30 |
2328386 | 2328386 | 2022-03-21 | Clearwater | Minnesota | 27029 | 2145 | 30 |
2325133 | 2325133 | 2022-03-20 | Clearwater | Minnesota | 27029 | 2144 | 30 |
2321879 | 2321879 | 2022-03-19 | Clearwater | Minnesota | 27029 | 2144 | 30 |
2318625 | 2318625 | 2022-03-18 | Clearwater | Minnesota | 27029 | 2144 | 30 |
2315372 | 2315372 | 2022-03-17 | Clearwater | Minnesota | 27029 | 2143 | 30 |
2312119 | 2312119 | 2022-03-16 | Clearwater | Minnesota | 27029 | 2143 | 30 |
2308866 | 2308866 | 2022-03-15 | Clearwater | Minnesota | 27029 | 2142 | 30 |
2305615 | 2305615 | 2022-03-14 | Clearwater | Minnesota | 27029 | 2142 | 30 |
2302363 | 2302363 | 2022-03-13 | Clearwater | Minnesota | 27029 | 2142 | 30 |
2299111 | 2299111 | 2022-03-12 | Clearwater | Minnesota | 27029 | 2142 | 30 |
2295859 | 2295859 | 2022-03-11 | Clearwater | Minnesota | 27029 | 2142 | 30 |
2292607 | 2292607 | 2022-03-10 | Clearwater | Minnesota | 27029 | 2127 | 30 |
2289355 | 2289355 | 2022-03-09 | Clearwater | Minnesota | 27029 | 2126 | 30 |
2286104 | 2286104 | 2022-03-08 | Clearwater | Minnesota | 27029 | 2126 | 30 |
2282852 | 2282852 | 2022-03-07 | Clearwater | Minnesota | 27029 | 2124 | 30 |
2279599 | 2279599 | 2022-03-06 | Clearwater | Minnesota | 27029 | 2117 | 30 |
2276346 | 2276346 | 2022-03-05 | Clearwater | Minnesota | 27029 | 2117 | 30 |
2273093 | 2273093 | 2022-03-04 | Clearwater | Minnesota | 27029 | 2117 | 30 |
2269841 | 2269841 | 2022-03-03 | Clearwater | Minnesota | 27029 | 2110 | 30 |
2266588 | 2266588 | 2022-03-02 | Clearwater | Minnesota | 27029 | 2109 | 30 |
2263337 | 2263337 | 2022-03-01 | Clearwater | Minnesota | 27029 | 2107 | 30 |
2260086 | 2260086 | 2022-02-28 | Clearwater | Minnesota | 27029 | 2107 | 30 |
2256835 | 2256835 | 2022-02-27 | Clearwater | Minnesota | 27029 | 2106 | 30 |
2253584 | 2253584 | 2022-02-26 | Clearwater | Minnesota | 27029 | 2106 | 30 |
2250333 | 2250333 | 2022-02-25 | Clearwater | Minnesota | 27029 | 2106 | 30 |
2247082 | 2247082 | 2022-02-24 | Clearwater | Minnesota | 27029 | 2105 | 30 |
2243831 | 2243831 | 2022-02-23 | Clearwater | Minnesota | 27029 | 2104 | 30 |
2240580 | 2240580 | 2022-02-22 | Clearwater | Minnesota | 27029 | 2100 | 29 |
2237329 | 2237329 | 2022-02-21 | Clearwater | Minnesota | 27029 | 2097 | 29 |
2234078 | 2234078 | 2022-02-20 | Clearwater | Minnesota | 27029 | 2097 | 29 |
2230827 | 2230827 | 2022-02-19 | Clearwater | Minnesota | 27029 | 2097 | 29 |
2227576 | 2227576 | 2022-02-18 | Clearwater | Minnesota | 27029 | 2097 | 29 |
2224325 | 2224325 | 2022-02-17 | Clearwater | Minnesota | 27029 | 2087 | 29 |
2221074 | 2221074 | 2022-02-16 | Clearwater | Minnesota | 27029 | 2083 | 29 |
2217823 | 2217823 | 2022-02-15 | Clearwater | Minnesota | 27029 | 2079 | 29 |
2214572 | 2214572 | 2022-02-14 | Clearwater | Minnesota | 27029 | 2069 | 29 |
2211320 | 2211320 | 2022-02-13 | Clearwater | Minnesota | 27029 | 2055 | 29 |
2208067 | 2208067 | 2022-02-12 | Clearwater | Minnesota | 27029 | 2055 | 29 |
2204814 | 2204814 | 2022-02-11 | Clearwater | Minnesota | 27029 | 2055 | 29 |
2201561 | 2201561 | 2022-02-10 | Clearwater | Minnesota | 27029 | 2050 | 29 |
2198307 | 2198307 | 2022-02-09 | Clearwater | Minnesota | 27029 | 2044 | 29 |
2195053 | 2195053 | 2022-02-08 | Clearwater | Minnesota | 27029 | 2037 | 29 |
2191799 | 2191799 | 2022-02-07 | Clearwater | Minnesota | 27029 | 2023 | 29 |
2188546 | 2188546 | 2022-02-06 | Clearwater | Minnesota | 27029 | 2013 | 29 |
2185293 | 2185293 | 2022-02-05 | Clearwater | Minnesota | 27029 | 2013 | 29 |
2182041 | 2182041 | 2022-02-04 | Clearwater | Minnesota | 27029 | 2013 | 29 |
2178789 | 2178789 | 2022-02-03 | Clearwater | Minnesota | 27029 | 2001 | 29 |
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);