ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Delta" and fips = 26041 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2393381 | 2393381 | 2022-04-10 | Delta | Michigan | 26041 | 9921 | 157 |
2390125 | 2390125 | 2022-04-09 | Delta | Michigan | 26041 | 9921 | 157 |
2386869 | 2386869 | 2022-04-08 | Delta | Michigan | 26041 | 9921 | 157 |
2383614 | 2383614 | 2022-04-07 | Delta | Michigan | 26041 | 9921 | 157 |
2380359 | 2380359 | 2022-04-06 | Delta | Michigan | 26041 | 9921 | 157 |
2377104 | 2377104 | 2022-04-05 | Delta | Michigan | 26041 | 9917 | 155 |
2373852 | 2373852 | 2022-04-04 | Delta | Michigan | 26041 | 9917 | 155 |
2370599 | 2370599 | 2022-04-03 | Delta | Michigan | 26041 | 9917 | 155 |
2367346 | 2367346 | 2022-04-02 | Delta | Michigan | 26041 | 9917 | 155 |
2364093 | 2364093 | 2022-04-01 | Delta | Michigan | 26041 | 9917 | 155 |
2360839 | 2360839 | 2022-03-31 | Delta | Michigan | 26041 | 9920 | 155 |
2357585 | 2357585 | 2022-03-30 | Delta | Michigan | 26041 | 9920 | 155 |
2354332 | 2354332 | 2022-03-29 | Delta | Michigan | 26041 | 9919 | 155 |
2351080 | 2351080 | 2022-03-28 | Delta | Michigan | 26041 | 9919 | 155 |
2347827 | 2347827 | 2022-03-27 | Delta | Michigan | 26041 | 9915 | 155 |
2344574 | 2344574 | 2022-03-26 | Delta | Michigan | 26041 | 9915 | 155 |
2341321 | 2341321 | 2022-03-25 | Delta | Michigan | 26041 | 9915 | 155 |
2338068 | 2338068 | 2022-03-24 | Delta | Michigan | 26041 | 9915 | 155 |
2334814 | 2334814 | 2022-03-23 | Delta | Michigan | 26041 | 9915 | 155 |
2331560 | 2331560 | 2022-03-22 | Delta | Michigan | 26041 | 9916 | 154 |
2328308 | 2328308 | 2022-03-21 | Delta | Michigan | 26041 | 9916 | 154 |
2325055 | 2325055 | 2022-03-20 | Delta | Michigan | 26041 | 9912 | 154 |
2321801 | 2321801 | 2022-03-19 | Delta | Michigan | 26041 | 9912 | 154 |
2318547 | 2318547 | 2022-03-18 | Delta | Michigan | 26041 | 9912 | 154 |
2315294 | 2315294 | 2022-03-17 | Delta | Michigan | 26041 | 9909 | 154 |
2312041 | 2312041 | 2022-03-16 | Delta | Michigan | 26041 | 9909 | 154 |
2308788 | 2308788 | 2022-03-15 | Delta | Michigan | 26041 | 9909 | 154 |
2305537 | 2305537 | 2022-03-14 | Delta | Michigan | 26041 | 9909 | 154 |
2302285 | 2302285 | 2022-03-13 | Delta | Michigan | 26041 | 9904 | 154 |
2299033 | 2299033 | 2022-03-12 | Delta | Michigan | 26041 | 9904 | 154 |
2295781 | 2295781 | 2022-03-11 | Delta | Michigan | 26041 | 9904 | 154 |
2292529 | 2292529 | 2022-03-10 | Delta | Michigan | 26041 | 9897 | 155 |
2289277 | 2289277 | 2022-03-09 | Delta | Michigan | 26041 | 9897 | 155 |
2286026 | 2286026 | 2022-03-08 | Delta | Michigan | 26041 | 9894 | 153 |
2282774 | 2282774 | 2022-03-07 | Delta | Michigan | 26041 | 9894 | 153 |
2279521 | 2279521 | 2022-03-06 | Delta | Michigan | 26041 | 9888 | 153 |
2276268 | 2276268 | 2022-03-05 | Delta | Michigan | 26041 | 9888 | 153 |
2273015 | 2273015 | 2022-03-04 | Delta | Michigan | 26041 | 9888 | 153 |
2269763 | 2269763 | 2022-03-03 | Delta | Michigan | 26041 | 9882 | 153 |
2266510 | 2266510 | 2022-03-02 | Delta | Michigan | 26041 | 9882 | 153 |
2263259 | 2263259 | 2022-03-01 | Delta | Michigan | 26041 | 9869 | 153 |
2260008 | 2260008 | 2022-02-28 | Delta | Michigan | 26041 | 9869 | 153 |
2256757 | 2256757 | 2022-02-27 | Delta | Michigan | 26041 | 9861 | 153 |
2253506 | 2253506 | 2022-02-26 | Delta | Michigan | 26041 | 9861 | 153 |
2250255 | 2250255 | 2022-02-25 | Delta | Michigan | 26041 | 9861 | 153 |
2247004 | 2247004 | 2022-02-24 | Delta | Michigan | 26041 | 9850 | 153 |
2243753 | 2243753 | 2022-02-23 | Delta | Michigan | 26041 | 9850 | 153 |
2240502 | 2240502 | 2022-02-22 | Delta | Michigan | 26041 | 9829 | 151 |
2237251 | 2237251 | 2022-02-21 | Delta | Michigan | 26041 | 9829 | 151 |
2234000 | 2234000 | 2022-02-20 | Delta | Michigan | 26041 | 9829 | 151 |
2230749 | 2230749 | 2022-02-19 | Delta | Michigan | 26041 | 9805 | 149 |
2227498 | 2227498 | 2022-02-18 | Delta | Michigan | 26041 | 9805 | 149 |
2224247 | 2224247 | 2022-02-17 | Delta | Michigan | 26041 | 9805 | 149 |
2220996 | 2220996 | 2022-02-16 | Delta | Michigan | 26041 | 9805 | 149 |
2217745 | 2217745 | 2022-02-15 | Delta | Michigan | 26041 | 9771 | 148 |
2214494 | 2214494 | 2022-02-14 | Delta | Michigan | 26041 | 9771 | 148 |
2211242 | 2211242 | 2022-02-13 | Delta | Michigan | 26041 | 9745 | 149 |
2207989 | 2207989 | 2022-02-12 | Delta | Michigan | 26041 | 9745 | 149 |
2204736 | 2204736 | 2022-02-11 | Delta | Michigan | 26041 | 9745 | 149 |
2201483 | 2201483 | 2022-02-10 | Delta | Michigan | 26041 | 9684 | 148 |
2198229 | 2198229 | 2022-02-09 | Delta | Michigan | 26041 | 9684 | 148 |
2194975 | 2194975 | 2022-02-08 | Delta | Michigan | 26041 | 9625 | 148 |
2191721 | 2191721 | 2022-02-07 | Delta | Michigan | 26041 | 9625 | 148 |
2188468 | 2188468 | 2022-02-06 | Delta | Michigan | 26041 | 9573 | 148 |
2185215 | 2185215 | 2022-02-05 | Delta | Michigan | 26041 | 9573 | 148 |
2181963 | 2181963 | 2022-02-04 | Delta | Michigan | 26041 | 9573 | 148 |
2178711 | 2178711 | 2022-02-03 | Delta | Michigan | 26041 | 9506 | 145 |
2175459 | 2175459 | 2022-02-02 | Delta | Michigan | 26041 | 9506 | 145 |
2172206 | 2172206 | 2022-02-01 | Delta | Michigan | 26041 | 9356 | 144 |
2168953 | 2168953 | 2022-01-31 | Delta | Michigan | 26041 | 9356 | 144 |
2165698 | 2165698 | 2022-01-30 | Delta | Michigan | 26041 | 9309 | 144 |
2162443 | 2162443 | 2022-01-29 | Delta | Michigan | 26041 | 9309 | 144 |
2159188 | 2159188 | 2022-01-28 | Delta | Michigan | 26041 | 9309 | 144 |
2155934 | 2155934 | 2022-01-27 | Delta | Michigan | 26041 | 9209 | 143 |
2152681 | 2152681 | 2022-01-26 | Delta | Michigan | 26041 | 9209 | 143 |
2149429 | 2149429 | 2022-01-25 | Delta | Michigan | 26041 | 9033 | 143 |
2146177 | 2146177 | 2022-01-24 | Delta | Michigan | 26041 | 9033 | 143 |
2142922 | 2142922 | 2022-01-23 | Delta | Michigan | 26041 | 8858 | 143 |
2139667 | 2139667 | 2022-01-22 | Delta | Michigan | 26041 | 8858 | 143 |
2136411 | 2136411 | 2022-01-21 | Delta | Michigan | 26041 | 8858 | 143 |
2133159 | 2133159 | 2022-01-20 | Delta | Michigan | 26041 | 8591 | 140 |
2129906 | 2129906 | 2022-01-19 | Delta | Michigan | 26041 | 8591 | 140 |
2126652 | 2126652 | 2022-01-18 | Delta | Michigan | 26041 | 8014 | 139 |
2123400 | 2123400 | 2022-01-17 | Delta | Michigan | 26041 | 8014 | 139 |
2120148 | 2120148 | 2022-01-16 | Delta | Michigan | 26041 | 8014 | 139 |
2116896 | 2116896 | 2022-01-15 | Delta | Michigan | 26041 | 8014 | 139 |
2113645 | 2113645 | 2022-01-14 | Delta | Michigan | 26041 | 8014 | 139 |
2110393 | 2110393 | 2022-01-13 | Delta | Michigan | 26041 | 7862 | 139 |
2107142 | 2107142 | 2022-01-12 | Delta | Michigan | 26041 | 7862 | 139 |
2103891 | 2103891 | 2022-01-11 | Delta | Michigan | 26041 | 7678 | 138 |
2100640 | 2100640 | 2022-01-10 | Delta | Michigan | 26041 | 7678 | 138 |
2097389 | 2097389 | 2022-01-09 | Delta | Michigan | 26041 | 7491 | 138 |
2094137 | 2094137 | 2022-01-08 | Delta | Michigan | 26041 | 7491 | 138 |
2090885 | 2090885 | 2022-01-07 | Delta | Michigan | 26041 | 7491 | 138 |
2087634 | 2087634 | 2022-01-06 | Delta | Michigan | 26041 | 7369 | 137 |
2084382 | 2084382 | 2022-01-05 | Delta | Michigan | 26041 | 7369 | 137 |
2081130 | 2081130 | 2022-01-04 | Delta | Michigan | 26041 | 7252 | 137 |
2077878 | 2077878 | 2022-01-03 | Delta | Michigan | 26041 | 7252 | 137 |
2074627 | 2074627 | 2022-01-02 | Delta | Michigan | 26041 | 7154 | 135 |
2071376 | 2071376 | 2022-01-01 | Delta | Michigan | 26041 | 7154 | 135 |
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);