ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Branch", fips = 26023 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 |
---|---|---|---|---|---|---|---|
2500832 | 2500832 | 2022-05-13 | Branch | Michigan | 26023 | 12253 | 206 |
2497574 | 2497574 | 2022-05-12 | Branch | Michigan | 26023 | 12253 | 206 |
2494316 | 2494316 | 2022-05-11 | Branch | Michigan | 26023 | 12253 | 206 |
2491058 | 2491058 | 2022-05-10 | Branch | Michigan | 26023 | 12211 | 206 |
2487801 | 2487801 | 2022-05-09 | Branch | Michigan | 26023 | 12211 | 206 |
2484543 | 2484543 | 2022-05-08 | Branch | Michigan | 26023 | 12211 | 206 |
2481285 | 2481285 | 2022-05-07 | Branch | Michigan | 26023 | 12211 | 206 |
2478027 | 2478027 | 2022-05-06 | Branch | Michigan | 26023 | 12211 | 206 |
2474769 | 2474769 | 2022-05-05 | Branch | Michigan | 26023 | 12211 | 206 |
2471512 | 2471512 | 2022-05-04 | Branch | Michigan | 26023 | 12211 | 206 |
2468256 | 2468256 | 2022-05-03 | Branch | Michigan | 26023 | 12194 | 206 |
2465001 | 2465001 | 2022-05-02 | Branch | Michigan | 26023 | 12194 | 206 |
2461745 | 2461745 | 2022-05-01 | Branch | Michigan | 26023 | 12194 | 206 |
2458489 | 2458489 | 2022-04-30 | Branch | Michigan | 26023 | 12194 | 206 |
2455233 | 2455233 | 2022-04-29 | Branch | Michigan | 26023 | 12194 | 206 |
2451977 | 2451977 | 2022-04-28 | Branch | Michigan | 26023 | 12194 | 206 |
2448721 | 2448721 | 2022-04-27 | Branch | Michigan | 26023 | 12194 | 206 |
2445465 | 2445465 | 2022-04-26 | Branch | Michigan | 26023 | 12185 | 205 |
2442209 | 2442209 | 2022-04-25 | Branch | Michigan | 26023 | 12185 | 205 |
2438953 | 2438953 | 2022-04-24 | Branch | Michigan | 26023 | 12185 | 205 |
2435697 | 2435697 | 2022-04-23 | Branch | Michigan | 26023 | 12185 | 205 |
2432441 | 2432441 | 2022-04-22 | Branch | Michigan | 26023 | 12185 | 205 |
2429185 | 2429185 | 2022-04-21 | Branch | Michigan | 26023 | 12185 | 205 |
2425929 | 2425929 | 2022-04-20 | Branch | Michigan | 26023 | 12185 | 205 |
2422673 | 2422673 | 2022-04-19 | Branch | Michigan | 26023 | 12171 | 205 |
2419417 | 2419417 | 2022-04-18 | Branch | Michigan | 26023 | 12171 | 205 |
2416161 | 2416161 | 2022-04-17 | Branch | Michigan | 26023 | 12171 | 205 |
2412905 | 2412905 | 2022-04-16 | Branch | Michigan | 26023 | 12171 | 205 |
2409649 | 2409649 | 2022-04-15 | Branch | Michigan | 26023 | 12171 | 205 |
2406393 | 2406393 | 2022-04-14 | Branch | Michigan | 26023 | 12171 | 205 |
2403137 | 2403137 | 2022-04-13 | Branch | Michigan | 26023 | 12171 | 205 |
2399883 | 2399883 | 2022-04-12 | Branch | Michigan | 26023 | 12157 | 205 |
2396627 | 2396627 | 2022-04-11 | Branch | Michigan | 26023 | 12157 | 205 |
2393372 | 2393372 | 2022-04-10 | Branch | Michigan | 26023 | 12157 | 205 |
2390116 | 2390116 | 2022-04-09 | Branch | Michigan | 26023 | 12157 | 205 |
2386860 | 2386860 | 2022-04-08 | Branch | Michigan | 26023 | 12157 | 205 |
2383605 | 2383605 | 2022-04-07 | Branch | Michigan | 26023 | 12157 | 205 |
2380350 | 2380350 | 2022-04-06 | Branch | Michigan | 26023 | 12157 | 205 |
2377095 | 2377095 | 2022-04-05 | Branch | Michigan | 26023 | 12153 | 205 |
2373843 | 2373843 | 2022-04-04 | Branch | Michigan | 26023 | 12153 | 205 |
2370590 | 2370590 | 2022-04-03 | Branch | Michigan | 26023 | 12153 | 205 |
2367337 | 2367337 | 2022-04-02 | Branch | Michigan | 26023 | 12153 | 205 |
2364084 | 2364084 | 2022-04-01 | Branch | Michigan | 26023 | 12153 | 205 |
2360830 | 2360830 | 2022-03-31 | Branch | Michigan | 26023 | 12149 | 205 |
2357576 | 2357576 | 2022-03-30 | Branch | Michigan | 26023 | 12149 | 205 |
2354323 | 2354323 | 2022-03-29 | Branch | Michigan | 26023 | 12138 | 205 |
2351071 | 2351071 | 2022-03-28 | Branch | Michigan | 26023 | 12138 | 205 |
2347818 | 2347818 | 2022-03-27 | Branch | Michigan | 26023 | 12136 | 205 |
2344565 | 2344565 | 2022-03-26 | Branch | Michigan | 26023 | 12136 | 205 |
2341312 | 2341312 | 2022-03-25 | Branch | Michigan | 26023 | 12136 | 205 |
2338059 | 2338059 | 2022-03-24 | Branch | Michigan | 26023 | 12133 | 205 |
2334805 | 2334805 | 2022-03-23 | Branch | Michigan | 26023 | 12133 | 205 |
2331551 | 2331551 | 2022-03-22 | Branch | Michigan | 26023 | 12127 | 204 |
2328299 | 2328299 | 2022-03-21 | Branch | Michigan | 26023 | 12127 | 204 |
2325046 | 2325046 | 2022-03-20 | Branch | Michigan | 26023 | 12116 | 204 |
2321792 | 2321792 | 2022-03-19 | Branch | Michigan | 26023 | 12116 | 204 |
2318538 | 2318538 | 2022-03-18 | Branch | Michigan | 26023 | 12116 | 204 |
2315285 | 2315285 | 2022-03-17 | Branch | Michigan | 26023 | 12107 | 204 |
2312032 | 2312032 | 2022-03-16 | Branch | Michigan | 26023 | 12107 | 204 |
2308779 | 2308779 | 2022-03-15 | Branch | Michigan | 26023 | 12101 | 202 |
2305528 | 2305528 | 2022-03-14 | Branch | Michigan | 26023 | 12101 | 202 |
2302276 | 2302276 | 2022-03-13 | Branch | Michigan | 26023 | 12093 | 201 |
2299024 | 2299024 | 2022-03-12 | Branch | Michigan | 26023 | 12093 | 201 |
2295772 | 2295772 | 2022-03-11 | Branch | Michigan | 26023 | 12093 | 201 |
2292520 | 2292520 | 2022-03-10 | Branch | Michigan | 26023 | 12089 | 201 |
2289268 | 2289268 | 2022-03-09 | Branch | Michigan | 26023 | 12089 | 201 |
2286017 | 2286017 | 2022-03-08 | Branch | Michigan | 26023 | 12085 | 197 |
2282765 | 2282765 | 2022-03-07 | Branch | Michigan | 26023 | 12085 | 197 |
2279512 | 2279512 | 2022-03-06 | Branch | Michigan | 26023 | 12074 | 197 |
2276259 | 2276259 | 2022-03-05 | Branch | Michigan | 26023 | 12074 | 197 |
2273006 | 2273006 | 2022-03-04 | Branch | Michigan | 26023 | 12074 | 197 |
2269754 | 2269754 | 2022-03-03 | Branch | Michigan | 26023 | 12067 | 196 |
2266501 | 2266501 | 2022-03-02 | Branch | Michigan | 26023 | 12067 | 196 |
2263250 | 2263250 | 2022-03-01 | Branch | Michigan | 26023 | 12048 | 195 |
2259999 | 2259999 | 2022-02-28 | Branch | Michigan | 26023 | 12048 | 195 |
2256748 | 2256748 | 2022-02-27 | Branch | Michigan | 26023 | 12041 | 194 |
2253497 | 2253497 | 2022-02-26 | Branch | Michigan | 26023 | 12041 | 194 |
2250246 | 2250246 | 2022-02-25 | Branch | Michigan | 26023 | 12041 | 194 |
2246995 | 2246995 | 2022-02-24 | Branch | Michigan | 26023 | 12035 | 193 |
2243744 | 2243744 | 2022-02-23 | Branch | Michigan | 26023 | 12035 | 193 |
2240493 | 2240493 | 2022-02-22 | Branch | Michigan | 26023 | 12015 | 190 |
2237242 | 2237242 | 2022-02-21 | Branch | Michigan | 26023 | 12015 | 190 |
2233991 | 2233991 | 2022-02-20 | Branch | Michigan | 26023 | 12015 | 190 |
2230740 | 2230740 | 2022-02-19 | Branch | Michigan | 26023 | 11990 | 189 |
2227489 | 2227489 | 2022-02-18 | Branch | Michigan | 26023 | 11990 | 189 |
2224238 | 2224238 | 2022-02-17 | Branch | Michigan | 26023 | 11990 | 189 |
2220987 | 2220987 | 2022-02-16 | Branch | Michigan | 26023 | 11990 | 189 |
2217736 | 2217736 | 2022-02-15 | Branch | Michigan | 26023 | 11965 | 187 |
2214485 | 2214485 | 2022-02-14 | Branch | Michigan | 26023 | 11965 | 187 |
2211233 | 2211233 | 2022-02-13 | Branch | Michigan | 26023 | 11948 | 186 |
2207980 | 2207980 | 2022-02-12 | Branch | Michigan | 26023 | 11948 | 186 |
2204727 | 2204727 | 2022-02-11 | Branch | Michigan | 26023 | 11948 | 186 |
2201474 | 2201474 | 2022-02-10 | Branch | Michigan | 26023 | 11924 | 186 |
2198220 | 2198220 | 2022-02-09 | Branch | Michigan | 26023 | 11924 | 186 |
2194966 | 2194966 | 2022-02-08 | Branch | Michigan | 26023 | 11879 | 184 |
2191712 | 2191712 | 2022-02-07 | Branch | Michigan | 26023 | 11879 | 184 |
2188459 | 2188459 | 2022-02-06 | Branch | Michigan | 26023 | 11817 | 184 |
2185206 | 2185206 | 2022-02-05 | Branch | Michigan | 26023 | 11817 | 184 |
2181954 | 2181954 | 2022-02-04 | Branch | Michigan | 26023 | 11817 | 184 |
2178702 | 2178702 | 2022-02-03 | Branch | Michigan | 26023 | 11760 | 183 |
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);