ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 26073 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500857 | 2500857 | 2022-05-13 | Isabella | Michigan | 26073 | 15890 | 211 |
2497599 | 2497599 | 2022-05-12 | Isabella | Michigan | 26073 | 15890 | 211 |
2494341 | 2494341 | 2022-05-11 | Isabella | Michigan | 26073 | 15890 | 211 |
2491083 | 2491083 | 2022-05-10 | Isabella | Michigan | 26073 | 15730 | 210 |
2487826 | 2487826 | 2022-05-09 | Isabella | Michigan | 26073 | 15730 | 210 |
2484568 | 2484568 | 2022-05-08 | Isabella | Michigan | 26073 | 15730 | 210 |
2481310 | 2481310 | 2022-05-07 | Isabella | Michigan | 26073 | 15730 | 210 |
2478052 | 2478052 | 2022-05-06 | Isabella | Michigan | 26073 | 15730 | 210 |
2474794 | 2474794 | 2022-05-05 | Isabella | Michigan | 26073 | 15730 | 210 |
2471537 | 2471537 | 2022-05-04 | Isabella | Michigan | 26073 | 15730 | 210 |
2468281 | 2468281 | 2022-05-03 | Isabella | Michigan | 26073 | 15632 | 208 |
2465026 | 2465026 | 2022-05-02 | Isabella | Michigan | 26073 | 15632 | 208 |
2461770 | 2461770 | 2022-05-01 | Isabella | Michigan | 26073 | 15632 | 208 |
2458514 | 2458514 | 2022-04-30 | Isabella | Michigan | 26073 | 15632 | 208 |
2455258 | 2455258 | 2022-04-29 | Isabella | Michigan | 26073 | 15632 | 208 |
2452002 | 2452002 | 2022-04-28 | Isabella | Michigan | 26073 | 15632 | 208 |
2448746 | 2448746 | 2022-04-27 | Isabella | Michigan | 26073 | 15632 | 208 |
2445490 | 2445490 | 2022-04-26 | Isabella | Michigan | 26073 | 15584 | 208 |
2442234 | 2442234 | 2022-04-25 | Isabella | Michigan | 26073 | 15584 | 208 |
2438978 | 2438978 | 2022-04-24 | Isabella | Michigan | 26073 | 15584 | 208 |
2435722 | 2435722 | 2022-04-23 | Isabella | Michigan | 26073 | 15584 | 208 |
2432466 | 2432466 | 2022-04-22 | Isabella | Michigan | 26073 | 15584 | 208 |
2429210 | 2429210 | 2022-04-21 | Isabella | Michigan | 26073 | 15584 | 208 |
2425954 | 2425954 | 2022-04-20 | Isabella | Michigan | 26073 | 15584 | 208 |
2422698 | 2422698 | 2022-04-19 | Isabella | Michigan | 26073 | 15556 | 208 |
2419442 | 2419442 | 2022-04-18 | Isabella | Michigan | 26073 | 15556 | 208 |
2416186 | 2416186 | 2022-04-17 | Isabella | Michigan | 26073 | 15556 | 208 |
2412930 | 2412930 | 2022-04-16 | Isabella | Michigan | 26073 | 15556 | 208 |
2409674 | 2409674 | 2022-04-15 | Isabella | Michigan | 26073 | 15556 | 208 |
2406418 | 2406418 | 2022-04-14 | Isabella | Michigan | 26073 | 15556 | 208 |
2403162 | 2403162 | 2022-04-13 | Isabella | Michigan | 26073 | 15556 | 208 |
2399908 | 2399908 | 2022-04-12 | Isabella | Michigan | 26073 | 15533 | 207 |
2396652 | 2396652 | 2022-04-11 | Isabella | Michigan | 26073 | 15533 | 207 |
2393397 | 2393397 | 2022-04-10 | Isabella | Michigan | 26073 | 15533 | 207 |
2390141 | 2390141 | 2022-04-09 | Isabella | Michigan | 26073 | 15533 | 207 |
2386885 | 2386885 | 2022-04-08 | Isabella | Michigan | 26073 | 15533 | 207 |
2383630 | 2383630 | 2022-04-07 | Isabella | Michigan | 26073 | 15533 | 207 |
2380375 | 2380375 | 2022-04-06 | Isabella | Michigan | 26073 | 15533 | 207 |
2377120 | 2377120 | 2022-04-05 | Isabella | Michigan | 26073 | 15518 | 207 |
2373868 | 2373868 | 2022-04-04 | Isabella | Michigan | 26073 | 15518 | 207 |
2370615 | 2370615 | 2022-04-03 | Isabella | Michigan | 26073 | 15518 | 207 |
2367362 | 2367362 | 2022-04-02 | Isabella | Michigan | 26073 | 15518 | 207 |
2364109 | 2364109 | 2022-04-01 | Isabella | Michigan | 26073 | 15518 | 207 |
2360855 | 2360855 | 2022-03-31 | Isabella | Michigan | 26073 | 15511 | 207 |
2357601 | 2357601 | 2022-03-30 | Isabella | Michigan | 26073 | 15511 | 207 |
2354348 | 2354348 | 2022-03-29 | Isabella | Michigan | 26073 | 15510 | 206 |
2351096 | 2351096 | 2022-03-28 | Isabella | Michigan | 26073 | 15510 | 206 |
2347843 | 2347843 | 2022-03-27 | Isabella | Michigan | 26073 | 15506 | 206 |
2344590 | 2344590 | 2022-03-26 | Isabella | Michigan | 26073 | 15506 | 206 |
2341337 | 2341337 | 2022-03-25 | Isabella | Michigan | 26073 | 15506 | 206 |
2338084 | 2338084 | 2022-03-24 | Isabella | Michigan | 26073 | 15503 | 205 |
2334830 | 2334830 | 2022-03-23 | Isabella | Michigan | 26073 | 15503 | 205 |
2331576 | 2331576 | 2022-03-22 | Isabella | Michigan | 26073 | 15494 | 203 |
2328324 | 2328324 | 2022-03-21 | Isabella | Michigan | 26073 | 15494 | 203 |
2325071 | 2325071 | 2022-03-20 | Isabella | Michigan | 26073 | 15485 | 203 |
2321817 | 2321817 | 2022-03-19 | Isabella | Michigan | 26073 | 15485 | 203 |
2318563 | 2318563 | 2022-03-18 | Isabella | Michigan | 26073 | 15485 | 203 |
2315310 | 2315310 | 2022-03-17 | Isabella | Michigan | 26073 | 15479 | 202 |
2312057 | 2312057 | 2022-03-16 | Isabella | Michigan | 26073 | 15479 | 202 |
2308804 | 2308804 | 2022-03-15 | Isabella | Michigan | 26073 | 15474 | 199 |
2305553 | 2305553 | 2022-03-14 | Isabella | Michigan | 26073 | 15474 | 199 |
2302301 | 2302301 | 2022-03-13 | Isabella | Michigan | 26073 | 15469 | 199 |
2299049 | 2299049 | 2022-03-12 | Isabella | Michigan | 26073 | 15469 | 199 |
2295797 | 2295797 | 2022-03-11 | Isabella | Michigan | 26073 | 15469 | 199 |
2292545 | 2292545 | 2022-03-10 | Isabella | Michigan | 26073 | 15461 | 199 |
2289293 | 2289293 | 2022-03-09 | Isabella | Michigan | 26073 | 15461 | 199 |
2286042 | 2286042 | 2022-03-08 | Isabella | Michigan | 26073 | 15454 | 199 |
2282790 | 2282790 | 2022-03-07 | Isabella | Michigan | 26073 | 15454 | 199 |
2279537 | 2279537 | 2022-03-06 | Isabella | Michigan | 26073 | 15450 | 199 |
2276284 | 2276284 | 2022-03-05 | Isabella | Michigan | 26073 | 15450 | 199 |
2273031 | 2273031 | 2022-03-04 | Isabella | Michigan | 26073 | 15450 | 199 |
2269779 | 2269779 | 2022-03-03 | Isabella | Michigan | 26073 | 15439 | 198 |
2266526 | 2266526 | 2022-03-02 | Isabella | Michigan | 26073 | 15439 | 198 |
2263275 | 2263275 | 2022-03-01 | Isabella | Michigan | 26073 | 15426 | 194 |
2260024 | 2260024 | 2022-02-28 | Isabella | Michigan | 26073 | 15426 | 194 |
2256773 | 2256773 | 2022-02-27 | Isabella | Michigan | 26073 | 15412 | 194 |
2253522 | 2253522 | 2022-02-26 | Isabella | Michigan | 26073 | 15412 | 194 |
2250271 | 2250271 | 2022-02-25 | Isabella | Michigan | 26073 | 15412 | 194 |
2247020 | 2247020 | 2022-02-24 | Isabella | Michigan | 26073 | 15393 | 194 |
2243769 | 2243769 | 2022-02-23 | Isabella | Michigan | 26073 | 15393 | 194 |
2240518 | 2240518 | 2022-02-22 | Isabella | Michigan | 26073 | 15316 | 193 |
2237267 | 2237267 | 2022-02-21 | Isabella | Michigan | 26073 | 15316 | 193 |
2234016 | 2234016 | 2022-02-20 | Isabella | Michigan | 26073 | 15316 | 193 |
2230765 | 2230765 | 2022-02-19 | Isabella | Michigan | 26073 | 15272 | 191 |
2227514 | 2227514 | 2022-02-18 | Isabella | Michigan | 26073 | 15272 | 191 |
2224263 | 2224263 | 2022-02-17 | Isabella | Michigan | 26073 | 15272 | 191 |
2221012 | 2221012 | 2022-02-16 | Isabella | Michigan | 26073 | 15272 | 191 |
2217761 | 2217761 | 2022-02-15 | Isabella | Michigan | 26073 | 15238 | 188 |
2214510 | 2214510 | 2022-02-14 | Isabella | Michigan | 26073 | 15238 | 188 |
2211258 | 2211258 | 2022-02-13 | Isabella | Michigan | 26073 | 15185 | 187 |
2208005 | 2208005 | 2022-02-12 | Isabella | Michigan | 26073 | 15185 | 187 |
2204752 | 2204752 | 2022-02-11 | Isabella | Michigan | 26073 | 15185 | 187 |
2201499 | 2201499 | 2022-02-10 | Isabella | Michigan | 26073 | 15122 | 186 |
2198245 | 2198245 | 2022-02-09 | Isabella | Michigan | 26073 | 15122 | 186 |
2194991 | 2194991 | 2022-02-08 | Isabella | Michigan | 26073 | 15029 | 185 |
2191737 | 2191737 | 2022-02-07 | Isabella | Michigan | 26073 | 15029 | 185 |
2188484 | 2188484 | 2022-02-06 | Isabella | Michigan | 26073 | 14942 | 185 |
2185231 | 2185231 | 2022-02-05 | Isabella | Michigan | 26073 | 14942 | 185 |
2181979 | 2181979 | 2022-02-04 | Isabella | Michigan | 26073 | 14942 | 185 |
2178727 | 2178727 | 2022-02-03 | Isabella | Michigan | 26073 | 14840 | 184 |
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);