ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 26069 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500855 | 2500855 | 2022-05-13 | Iosco | Michigan | 26069 | 4860 | 145 |
2497597 | 2497597 | 2022-05-12 | Iosco | Michigan | 26069 | 4860 | 145 |
2494339 | 2494339 | 2022-05-11 | Iosco | Michigan | 26069 | 4860 | 145 |
2491081 | 2491081 | 2022-05-10 | Iosco | Michigan | 26069 | 4829 | 143 |
2487824 | 2487824 | 2022-05-09 | Iosco | Michigan | 26069 | 4829 | 143 |
2484566 | 2484566 | 2022-05-08 | Iosco | Michigan | 26069 | 4829 | 143 |
2481308 | 2481308 | 2022-05-07 | Iosco | Michigan | 26069 | 4829 | 143 |
2478050 | 2478050 | 2022-05-06 | Iosco | Michigan | 26069 | 4829 | 143 |
2474792 | 2474792 | 2022-05-05 | Iosco | Michigan | 26069 | 4829 | 143 |
2471535 | 2471535 | 2022-05-04 | Iosco | Michigan | 26069 | 4829 | 143 |
2468279 | 2468279 | 2022-05-03 | Iosco | Michigan | 26069 | 4814 | 143 |
2465024 | 2465024 | 2022-05-02 | Iosco | Michigan | 26069 | 4814 | 143 |
2461768 | 2461768 | 2022-05-01 | Iosco | Michigan | 26069 | 4814 | 143 |
2458512 | 2458512 | 2022-04-30 | Iosco | Michigan | 26069 | 4814 | 143 |
2455256 | 2455256 | 2022-04-29 | Iosco | Michigan | 26069 | 4814 | 143 |
2452000 | 2452000 | 2022-04-28 | Iosco | Michigan | 26069 | 4814 | 143 |
2448744 | 2448744 | 2022-04-27 | Iosco | Michigan | 26069 | 4814 | 143 |
2445488 | 2445488 | 2022-04-26 | Iosco | Michigan | 26069 | 4810 | 142 |
2442232 | 2442232 | 2022-04-25 | Iosco | Michigan | 26069 | 4810 | 142 |
2438976 | 2438976 | 2022-04-24 | Iosco | Michigan | 26069 | 4810 | 142 |
2435720 | 2435720 | 2022-04-23 | Iosco | Michigan | 26069 | 4810 | 142 |
2432464 | 2432464 | 2022-04-22 | Iosco | Michigan | 26069 | 4810 | 142 |
2429208 | 2429208 | 2022-04-21 | Iosco | Michigan | 26069 | 4810 | 142 |
2425952 | 2425952 | 2022-04-20 | Iosco | Michigan | 26069 | 4810 | 142 |
2422696 | 2422696 | 2022-04-19 | Iosco | Michigan | 26069 | 4805 | 141 |
2419440 | 2419440 | 2022-04-18 | Iosco | Michigan | 26069 | 4805 | 141 |
2416184 | 2416184 | 2022-04-17 | Iosco | Michigan | 26069 | 4805 | 141 |
2412928 | 2412928 | 2022-04-16 | Iosco | Michigan | 26069 | 4805 | 141 |
2409672 | 2409672 | 2022-04-15 | Iosco | Michigan | 26069 | 4805 | 141 |
2406416 | 2406416 | 2022-04-14 | Iosco | Michigan | 26069 | 4805 | 141 |
2403160 | 2403160 | 2022-04-13 | Iosco | Michigan | 26069 | 4805 | 141 |
2399906 | 2399906 | 2022-04-12 | Iosco | Michigan | 26069 | 4799 | 141 |
2396650 | 2396650 | 2022-04-11 | Iosco | Michigan | 26069 | 4799 | 141 |
2393395 | 2393395 | 2022-04-10 | Iosco | Michigan | 26069 | 4799 | 141 |
2390139 | 2390139 | 2022-04-09 | Iosco | Michigan | 26069 | 4799 | 141 |
2386883 | 2386883 | 2022-04-08 | Iosco | Michigan | 26069 | 4799 | 141 |
2383628 | 2383628 | 2022-04-07 | Iosco | Michigan | 26069 | 4799 | 141 |
2380373 | 2380373 | 2022-04-06 | Iosco | Michigan | 26069 | 4799 | 141 |
2377118 | 2377118 | 2022-04-05 | Iosco | Michigan | 26069 | 4798 | 140 |
2373866 | 2373866 | 2022-04-04 | Iosco | Michigan | 26069 | 4798 | 140 |
2370613 | 2370613 | 2022-04-03 | Iosco | Michigan | 26069 | 4798 | 140 |
2367360 | 2367360 | 2022-04-02 | Iosco | Michigan | 26069 | 4798 | 140 |
2364107 | 2364107 | 2022-04-01 | Iosco | Michigan | 26069 | 4798 | 140 |
2360853 | 2360853 | 2022-03-31 | Iosco | Michigan | 26069 | 4797 | 139 |
2357599 | 2357599 | 2022-03-30 | Iosco | Michigan | 26069 | 4797 | 139 |
2354346 | 2354346 | 2022-03-29 | Iosco | Michigan | 26069 | 4797 | 139 |
2351094 | 2351094 | 2022-03-28 | Iosco | Michigan | 26069 | 4797 | 139 |
2347841 | 2347841 | 2022-03-27 | Iosco | Michigan | 26069 | 4798 | 139 |
2344588 | 2344588 | 2022-03-26 | Iosco | Michigan | 26069 | 4798 | 139 |
2341335 | 2341335 | 2022-03-25 | Iosco | Michigan | 26069 | 4798 | 139 |
2338082 | 2338082 | 2022-03-24 | Iosco | Michigan | 26069 | 4797 | 138 |
2334828 | 2334828 | 2022-03-23 | Iosco | Michigan | 26069 | 4797 | 138 |
2331574 | 2331574 | 2022-03-22 | Iosco | Michigan | 26069 | 4793 | 138 |
2328322 | 2328322 | 2022-03-21 | Iosco | Michigan | 26069 | 4793 | 138 |
2325069 | 2325069 | 2022-03-20 | Iosco | Michigan | 26069 | 4791 | 137 |
2321815 | 2321815 | 2022-03-19 | Iosco | Michigan | 26069 | 4791 | 137 |
2318561 | 2318561 | 2022-03-18 | Iosco | Michigan | 26069 | 4791 | 137 |
2315308 | 2315308 | 2022-03-17 | Iosco | Michigan | 26069 | 4786 | 137 |
2312055 | 2312055 | 2022-03-16 | Iosco | Michigan | 26069 | 4786 | 137 |
2308802 | 2308802 | 2022-03-15 | Iosco | Michigan | 26069 | 4786 | 136 |
2305551 | 2305551 | 2022-03-14 | Iosco | Michigan | 26069 | 4786 | 136 |
2302299 | 2302299 | 2022-03-13 | Iosco | Michigan | 26069 | 4784 | 136 |
2299047 | 2299047 | 2022-03-12 | Iosco | Michigan | 26069 | 4784 | 136 |
2295795 | 2295795 | 2022-03-11 | Iosco | Michigan | 26069 | 4784 | 136 |
2292543 | 2292543 | 2022-03-10 | Iosco | Michigan | 26069 | 4776 | 136 |
2289291 | 2289291 | 2022-03-09 | Iosco | Michigan | 26069 | 4776 | 136 |
2286040 | 2286040 | 2022-03-08 | Iosco | Michigan | 26069 | 4772 | 135 |
2282788 | 2282788 | 2022-03-07 | Iosco | Michigan | 26069 | 4772 | 135 |
2279535 | 2279535 | 2022-03-06 | Iosco | Michigan | 26069 | 4769 | 135 |
2276282 | 2276282 | 2022-03-05 | Iosco | Michigan | 26069 | 4769 | 135 |
2273029 | 2273029 | 2022-03-04 | Iosco | Michigan | 26069 | 4769 | 135 |
2269777 | 2269777 | 2022-03-03 | Iosco | Michigan | 26069 | 4763 | 134 |
2266524 | 2266524 | 2022-03-02 | Iosco | Michigan | 26069 | 4763 | 134 |
2263273 | 2263273 | 2022-03-01 | Iosco | Michigan | 26069 | 4757 | 134 |
2260022 | 2260022 | 2022-02-28 | Iosco | Michigan | 26069 | 4757 | 134 |
2256771 | 2256771 | 2022-02-27 | Iosco | Michigan | 26069 | 4750 | 133 |
2253520 | 2253520 | 2022-02-26 | Iosco | Michigan | 26069 | 4750 | 133 |
2250269 | 2250269 | 2022-02-25 | Iosco | Michigan | 26069 | 4750 | 133 |
2247018 | 2247018 | 2022-02-24 | Iosco | Michigan | 26069 | 4741 | 133 |
2243767 | 2243767 | 2022-02-23 | Iosco | Michigan | 26069 | 4741 | 133 |
2240516 | 2240516 | 2022-02-22 | Iosco | Michigan | 26069 | 4718 | 129 |
2237265 | 2237265 | 2022-02-21 | Iosco | Michigan | 26069 | 4718 | 129 |
2234014 | 2234014 | 2022-02-20 | Iosco | Michigan | 26069 | 4718 | 129 |
2230763 | 2230763 | 2022-02-19 | Iosco | Michigan | 26069 | 4705 | 129 |
2227512 | 2227512 | 2022-02-18 | Iosco | Michigan | 26069 | 4705 | 129 |
2224261 | 2224261 | 2022-02-17 | Iosco | Michigan | 26069 | 4705 | 129 |
2221010 | 2221010 | 2022-02-16 | Iosco | Michigan | 26069 | 4705 | 129 |
2217759 | 2217759 | 2022-02-15 | Iosco | Michigan | 26069 | 4665 | 129 |
2214508 | 2214508 | 2022-02-14 | Iosco | Michigan | 26069 | 4665 | 129 |
2211256 | 2211256 | 2022-02-13 | Iosco | Michigan | 26069 | 4644 | 129 |
2208003 | 2208003 | 2022-02-12 | Iosco | Michigan | 26069 | 4644 | 129 |
2204750 | 2204750 | 2022-02-11 | Iosco | Michigan | 26069 | 4644 | 129 |
2201497 | 2201497 | 2022-02-10 | Iosco | Michigan | 26069 | 4624 | 129 |
2198243 | 2198243 | 2022-02-09 | Iosco | Michigan | 26069 | 4624 | 129 |
2194989 | 2194989 | 2022-02-08 | Iosco | Michigan | 26069 | 4605 | 129 |
2191735 | 2191735 | 2022-02-07 | Iosco | Michigan | 26069 | 4605 | 129 |
2188482 | 2188482 | 2022-02-06 | Iosco | Michigan | 26069 | 4578 | 129 |
2185229 | 2185229 | 2022-02-05 | Iosco | Michigan | 26069 | 4578 | 129 |
2181977 | 2181977 | 2022-02-04 | Iosco | Michigan | 26069 | 4578 | 129 |
2178725 | 2178725 | 2022-02-03 | Iosco | Michigan | 26069 | 4528 | 128 |
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);