ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 26151 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500894 | 2500894 | 2022-05-13 | Sanilac | Michigan | 26151 | 8827 | 193 |
2497636 | 2497636 | 2022-05-12 | Sanilac | Michigan | 26151 | 8827 | 193 |
2494378 | 2494378 | 2022-05-11 | Sanilac | Michigan | 26151 | 8827 | 193 |
2491120 | 2491120 | 2022-05-10 | Sanilac | Michigan | 26151 | 8776 | 193 |
2487863 | 2487863 | 2022-05-09 | Sanilac | Michigan | 26151 | 8776 | 193 |
2484605 | 2484605 | 2022-05-08 | Sanilac | Michigan | 26151 | 8776 | 193 |
2481347 | 2481347 | 2022-05-07 | Sanilac | Michigan | 26151 | 8776 | 193 |
2478089 | 2478089 | 2022-05-06 | Sanilac | Michigan | 26151 | 8776 | 193 |
2474831 | 2474831 | 2022-05-05 | Sanilac | Michigan | 26151 | 8776 | 193 |
2471574 | 2471574 | 2022-05-04 | Sanilac | Michigan | 26151 | 8776 | 193 |
2468318 | 2468318 | 2022-05-03 | Sanilac | Michigan | 26151 | 8738 | 192 |
2465063 | 2465063 | 2022-05-02 | Sanilac | Michigan | 26151 | 8738 | 192 |
2461807 | 2461807 | 2022-05-01 | Sanilac | Michigan | 26151 | 8738 | 192 |
2458551 | 2458551 | 2022-04-30 | Sanilac | Michigan | 26151 | 8738 | 192 |
2455295 | 2455295 | 2022-04-29 | Sanilac | Michigan | 26151 | 8738 | 192 |
2452039 | 2452039 | 2022-04-28 | Sanilac | Michigan | 26151 | 8738 | 192 |
2448783 | 2448783 | 2022-04-27 | Sanilac | Michigan | 26151 | 8738 | 192 |
2445527 | 2445527 | 2022-04-26 | Sanilac | Michigan | 26151 | 8702 | 191 |
2442271 | 2442271 | 2022-04-25 | Sanilac | Michigan | 26151 | 8702 | 191 |
2439015 | 2439015 | 2022-04-24 | Sanilac | Michigan | 26151 | 8702 | 191 |
2435759 | 2435759 | 2022-04-23 | Sanilac | Michigan | 26151 | 8702 | 191 |
2432503 | 2432503 | 2022-04-22 | Sanilac | Michigan | 26151 | 8702 | 191 |
2429247 | 2429247 | 2022-04-21 | Sanilac | Michigan | 26151 | 8702 | 191 |
2425991 | 2425991 | 2022-04-20 | Sanilac | Michigan | 26151 | 8702 | 191 |
2422735 | 2422735 | 2022-04-19 | Sanilac | Michigan | 26151 | 8684 | 191 |
2419479 | 2419479 | 2022-04-18 | Sanilac | Michigan | 26151 | 8684 | 191 |
2416223 | 2416223 | 2022-04-17 | Sanilac | Michigan | 26151 | 8684 | 191 |
2412967 | 2412967 | 2022-04-16 | Sanilac | Michigan | 26151 | 8684 | 191 |
2409711 | 2409711 | 2022-04-15 | Sanilac | Michigan | 26151 | 8684 | 191 |
2406455 | 2406455 | 2022-04-14 | Sanilac | Michigan | 26151 | 8684 | 191 |
2403199 | 2403199 | 2022-04-13 | Sanilac | Michigan | 26151 | 8684 | 191 |
2399945 | 2399945 | 2022-04-12 | Sanilac | Michigan | 26151 | 8670 | 190 |
2396689 | 2396689 | 2022-04-11 | Sanilac | Michigan | 26151 | 8670 | 190 |
2393434 | 2393434 | 2022-04-10 | Sanilac | Michigan | 26151 | 8670 | 190 |
2390178 | 2390178 | 2022-04-09 | Sanilac | Michigan | 26151 | 8670 | 190 |
2386922 | 2386922 | 2022-04-08 | Sanilac | Michigan | 26151 | 8670 | 190 |
2383667 | 2383667 | 2022-04-07 | Sanilac | Michigan | 26151 | 8670 | 190 |
2380412 | 2380412 | 2022-04-06 | Sanilac | Michigan | 26151 | 8670 | 190 |
2377157 | 2377157 | 2022-04-05 | Sanilac | Michigan | 26151 | 8659 | 189 |
2373905 | 2373905 | 2022-04-04 | Sanilac | Michigan | 26151 | 8659 | 189 |
2370652 | 2370652 | 2022-04-03 | Sanilac | Michigan | 26151 | 8659 | 189 |
2367399 | 2367399 | 2022-04-02 | Sanilac | Michigan | 26151 | 8659 | 189 |
2364146 | 2364146 | 2022-04-01 | Sanilac | Michigan | 26151 | 8659 | 189 |
2360892 | 2360892 | 2022-03-31 | Sanilac | Michigan | 26151 | 8656 | 189 |
2357638 | 2357638 | 2022-03-30 | Sanilac | Michigan | 26151 | 8656 | 189 |
2354385 | 2354385 | 2022-03-29 | Sanilac | Michigan | 26151 | 8655 | 189 |
2351133 | 2351133 | 2022-03-28 | Sanilac | Michigan | 26151 | 8655 | 189 |
2347880 | 2347880 | 2022-03-27 | Sanilac | Michigan | 26151 | 8658 | 189 |
2344627 | 2344627 | 2022-03-26 | Sanilac | Michigan | 26151 | 8658 | 189 |
2341374 | 2341374 | 2022-03-25 | Sanilac | Michigan | 26151 | 8658 | 189 |
2338121 | 2338121 | 2022-03-24 | Sanilac | Michigan | 26151 | 8656 | 189 |
2334867 | 2334867 | 2022-03-23 | Sanilac | Michigan | 26151 | 8656 | 189 |
2331613 | 2331613 | 2022-03-22 | Sanilac | Michigan | 26151 | 8654 | 187 |
2328361 | 2328361 | 2022-03-21 | Sanilac | Michigan | 26151 | 8654 | 187 |
2325108 | 2325108 | 2022-03-20 | Sanilac | Michigan | 26151 | 8653 | 187 |
2321854 | 2321854 | 2022-03-19 | Sanilac | Michigan | 26151 | 8653 | 187 |
2318600 | 2318600 | 2022-03-18 | Sanilac | Michigan | 26151 | 8653 | 187 |
2315347 | 2315347 | 2022-03-17 | Sanilac | Michigan | 26151 | 8652 | 187 |
2312094 | 2312094 | 2022-03-16 | Sanilac | Michigan | 26151 | 8652 | 187 |
2308841 | 2308841 | 2022-03-15 | Sanilac | Michigan | 26151 | 8647 | 185 |
2305590 | 2305590 | 2022-03-14 | Sanilac | Michigan | 26151 | 8647 | 185 |
2302338 | 2302338 | 2022-03-13 | Sanilac | Michigan | 26151 | 8645 | 185 |
2299086 | 2299086 | 2022-03-12 | Sanilac | Michigan | 26151 | 8645 | 185 |
2295834 | 2295834 | 2022-03-11 | Sanilac | Michigan | 26151 | 8645 | 185 |
2292582 | 2292582 | 2022-03-10 | Sanilac | Michigan | 26151 | 8640 | 185 |
2289330 | 2289330 | 2022-03-09 | Sanilac | Michigan | 26151 | 8640 | 185 |
2286079 | 2286079 | 2022-03-08 | Sanilac | Michigan | 26151 | 8633 | 184 |
2282827 | 2282827 | 2022-03-07 | Sanilac | Michigan | 26151 | 8633 | 184 |
2279574 | 2279574 | 2022-03-06 | Sanilac | Michigan | 26151 | 8626 | 184 |
2276321 | 2276321 | 2022-03-05 | Sanilac | Michigan | 26151 | 8626 | 184 |
2273068 | 2273068 | 2022-03-04 | Sanilac | Michigan | 26151 | 8626 | 184 |
2269816 | 2269816 | 2022-03-03 | Sanilac | Michigan | 26151 | 8622 | 183 |
2266563 | 2266563 | 2022-03-02 | Sanilac | Michigan | 26151 | 8622 | 183 |
2263312 | 2263312 | 2022-03-01 | Sanilac | Michigan | 26151 | 8613 | 183 |
2260061 | 2260061 | 2022-02-28 | Sanilac | Michigan | 26151 | 8613 | 183 |
2256810 | 2256810 | 2022-02-27 | Sanilac | Michigan | 26151 | 8601 | 183 |
2253559 | 2253559 | 2022-02-26 | Sanilac | Michigan | 26151 | 8601 | 183 |
2250308 | 2250308 | 2022-02-25 | Sanilac | Michigan | 26151 | 8601 | 183 |
2247057 | 2247057 | 2022-02-24 | Sanilac | Michigan | 26151 | 8596 | 182 |
2243806 | 2243806 | 2022-02-23 | Sanilac | Michigan | 26151 | 8596 | 182 |
2240555 | 2240555 | 2022-02-22 | Sanilac | Michigan | 26151 | 8552 | 180 |
2237304 | 2237304 | 2022-02-21 | Sanilac | Michigan | 26151 | 8552 | 180 |
2234053 | 2234053 | 2022-02-20 | Sanilac | Michigan | 26151 | 8552 | 180 |
2230802 | 2230802 | 2022-02-19 | Sanilac | Michigan | 26151 | 8536 | 179 |
2227551 | 2227551 | 2022-02-18 | Sanilac | Michigan | 26151 | 8536 | 179 |
2224300 | 2224300 | 2022-02-17 | Sanilac | Michigan | 26151 | 8536 | 179 |
2221049 | 2221049 | 2022-02-16 | Sanilac | Michigan | 26151 | 8536 | 179 |
2217798 | 2217798 | 2022-02-15 | Sanilac | Michigan | 26151 | 8515 | 177 |
2214547 | 2214547 | 2022-02-14 | Sanilac | Michigan | 26151 | 8515 | 177 |
2211295 | 2211295 | 2022-02-13 | Sanilac | Michigan | 26151 | 8483 | 177 |
2208042 | 2208042 | 2022-02-12 | Sanilac | Michigan | 26151 | 8483 | 177 |
2204789 | 2204789 | 2022-02-11 | Sanilac | Michigan | 26151 | 8483 | 177 |
2201536 | 2201536 | 2022-02-10 | Sanilac | Michigan | 26151 | 8418 | 177 |
2198282 | 2198282 | 2022-02-09 | Sanilac | Michigan | 26151 | 8418 | 177 |
2195028 | 2195028 | 2022-02-08 | Sanilac | Michigan | 26151 | 8390 | 175 |
2191774 | 2191774 | 2022-02-07 | Sanilac | Michigan | 26151 | 8390 | 175 |
2188521 | 2188521 | 2022-02-06 | Sanilac | Michigan | 26151 | 8347 | 175 |
2185268 | 2185268 | 2022-02-05 | Sanilac | Michigan | 26151 | 8347 | 175 |
2182016 | 2182016 | 2022-02-04 | Sanilac | Michigan | 26151 | 8347 | 175 |
2178764 | 2178764 | 2022-02-03 | Sanilac | Michigan | 26151 | 8307 | 174 |
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);