ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Grand Traverse" 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 |
---|---|---|---|---|---|---|---|
2500848 | 2500848 | 2022-05-13 | Grand Traverse | Michigan | 26055 | 17858 | 236 |
2497590 | 2497590 | 2022-05-12 | Grand Traverse | Michigan | 26055 | 17858 | 236 |
2494332 | 2494332 | 2022-05-11 | Grand Traverse | Michigan | 26055 | 17858 | 236 |
2491074 | 2491074 | 2022-05-10 | Grand Traverse | Michigan | 26055 | 17636 | 234 |
2487817 | 2487817 | 2022-05-09 | Grand Traverse | Michigan | 26055 | 17636 | 234 |
2484559 | 2484559 | 2022-05-08 | Grand Traverse | Michigan | 26055 | 17636 | 234 |
2481301 | 2481301 | 2022-05-07 | Grand Traverse | Michigan | 26055 | 17636 | 234 |
2478043 | 2478043 | 2022-05-06 | Grand Traverse | Michigan | 26055 | 17636 | 234 |
2474785 | 2474785 | 2022-05-05 | Grand Traverse | Michigan | 26055 | 17636 | 234 |
2471528 | 2471528 | 2022-05-04 | Grand Traverse | Michigan | 26055 | 17636 | 234 |
2468272 | 2468272 | 2022-05-03 | Grand Traverse | Michigan | 26055 | 17427 | 233 |
2465017 | 2465017 | 2022-05-02 | Grand Traverse | Michigan | 26055 | 17427 | 233 |
2461761 | 2461761 | 2022-05-01 | Grand Traverse | Michigan | 26055 | 17427 | 233 |
2458505 | 2458505 | 2022-04-30 | Grand Traverse | Michigan | 26055 | 17427 | 233 |
2455249 | 2455249 | 2022-04-29 | Grand Traverse | Michigan | 26055 | 17427 | 233 |
2451993 | 2451993 | 2022-04-28 | Grand Traverse | Michigan | 26055 | 17427 | 233 |
2448737 | 2448737 | 2022-04-27 | Grand Traverse | Michigan | 26055 | 17427 | 233 |
2445481 | 2445481 | 2022-04-26 | Grand Traverse | Michigan | 26055 | 17342 | 233 |
2442225 | 2442225 | 2022-04-25 | Grand Traverse | Michigan | 26055 | 17342 | 233 |
2438969 | 2438969 | 2022-04-24 | Grand Traverse | Michigan | 26055 | 17342 | 233 |
2435713 | 2435713 | 2022-04-23 | Grand Traverse | Michigan | 26055 | 17342 | 233 |
2432457 | 2432457 | 2022-04-22 | Grand Traverse | Michigan | 26055 | 17342 | 233 |
2429201 | 2429201 | 2022-04-21 | Grand Traverse | Michigan | 26055 | 17342 | 233 |
2425945 | 2425945 | 2022-04-20 | Grand Traverse | Michigan | 26055 | 17342 | 233 |
2422689 | 2422689 | 2022-04-19 | Grand Traverse | Michigan | 26055 | 17283 | 231 |
2419433 | 2419433 | 2022-04-18 | Grand Traverse | Michigan | 26055 | 17283 | 231 |
2416177 | 2416177 | 2022-04-17 | Grand Traverse | Michigan | 26055 | 17283 | 231 |
2412921 | 2412921 | 2022-04-16 | Grand Traverse | Michigan | 26055 | 17283 | 231 |
2409665 | 2409665 | 2022-04-15 | Grand Traverse | Michigan | 26055 | 17283 | 231 |
2406409 | 2406409 | 2022-04-14 | Grand Traverse | Michigan | 26055 | 17283 | 231 |
2403153 | 2403153 | 2022-04-13 | Grand Traverse | Michigan | 26055 | 17283 | 231 |
2399899 | 2399899 | 2022-04-12 | Grand Traverse | Michigan | 26055 | 17231 | 230 |
2396643 | 2396643 | 2022-04-11 | Grand Traverse | Michigan | 26055 | 17231 | 230 |
2393388 | 2393388 | 2022-04-10 | Grand Traverse | Michigan | 26055 | 17231 | 230 |
2390132 | 2390132 | 2022-04-09 | Grand Traverse | Michigan | 26055 | 17231 | 230 |
2386876 | 2386876 | 2022-04-08 | Grand Traverse | Michigan | 26055 | 17231 | 230 |
2383621 | 2383621 | 2022-04-07 | Grand Traverse | Michigan | 26055 | 17231 | 230 |
2380366 | 2380366 | 2022-04-06 | Grand Traverse | Michigan | 26055 | 17231 | 230 |
2377111 | 2377111 | 2022-04-05 | Grand Traverse | Michigan | 26055 | 17194 | 228 |
2373859 | 2373859 | 2022-04-04 | Grand Traverse | Michigan | 26055 | 17194 | 228 |
2370606 | 2370606 | 2022-04-03 | Grand Traverse | Michigan | 26055 | 17194 | 228 |
2367353 | 2367353 | 2022-04-02 | Grand Traverse | Michigan | 26055 | 17194 | 228 |
2364100 | 2364100 | 2022-04-01 | Grand Traverse | Michigan | 26055 | 17194 | 228 |
2360846 | 2360846 | 2022-03-31 | Grand Traverse | Michigan | 26055 | 17176 | 228 |
2357592 | 2357592 | 2022-03-30 | Grand Traverse | Michigan | 26055 | 17176 | 228 |
2354339 | 2354339 | 2022-03-29 | Grand Traverse | Michigan | 26055 | 17165 | 228 |
2351087 | 2351087 | 2022-03-28 | Grand Traverse | Michigan | 26055 | 17165 | 228 |
2347834 | 2347834 | 2022-03-27 | Grand Traverse | Michigan | 26055 | 17154 | 228 |
2344581 | 2344581 | 2022-03-26 | Grand Traverse | Michigan | 26055 | 17154 | 228 |
2341328 | 2341328 | 2022-03-25 | Grand Traverse | Michigan | 26055 | 17154 | 228 |
2338075 | 2338075 | 2022-03-24 | Grand Traverse | Michigan | 26055 | 17145 | 227 |
2334821 | 2334821 | 2022-03-23 | Grand Traverse | Michigan | 26055 | 17145 | 227 |
2331567 | 2331567 | 2022-03-22 | Grand Traverse | Michigan | 26055 | 17115 | 225 |
2328315 | 2328315 | 2022-03-21 | Grand Traverse | Michigan | 26055 | 17115 | 225 |
2325062 | 2325062 | 2022-03-20 | Grand Traverse | Michigan | 26055 | 17091 | 225 |
2321808 | 2321808 | 2022-03-19 | Grand Traverse | Michigan | 26055 | 17091 | 225 |
2318554 | 2318554 | 2022-03-18 | Grand Traverse | Michigan | 26055 | 17091 | 225 |
2315301 | 2315301 | 2022-03-17 | Grand Traverse | Michigan | 26055 | 17080 | 224 |
2312048 | 2312048 | 2022-03-16 | Grand Traverse | Michigan | 26055 | 17080 | 224 |
2308795 | 2308795 | 2022-03-15 | Grand Traverse | Michigan | 26055 | 17057 | 221 |
2305544 | 2305544 | 2022-03-14 | Grand Traverse | Michigan | 26055 | 17057 | 221 |
2302292 | 2302292 | 2022-03-13 | Grand Traverse | Michigan | 26055 | 17037 | 221 |
2299040 | 2299040 | 2022-03-12 | Grand Traverse | Michigan | 26055 | 17037 | 221 |
2295788 | 2295788 | 2022-03-11 | Grand Traverse | Michigan | 26055 | 17037 | 221 |
2292536 | 2292536 | 2022-03-10 | Grand Traverse | Michigan | 26055 | 17012 | 221 |
2289284 | 2289284 | 2022-03-09 | Grand Traverse | Michigan | 26055 | 17012 | 221 |
2286033 | 2286033 | 2022-03-08 | Grand Traverse | Michigan | 26055 | 17002 | 219 |
2282781 | 2282781 | 2022-03-07 | Grand Traverse | Michigan | 26055 | 17002 | 219 |
2279528 | 2279528 | 2022-03-06 | Grand Traverse | Michigan | 26055 | 16987 | 219 |
2276275 | 2276275 | 2022-03-05 | Grand Traverse | Michigan | 26055 | 16987 | 219 |
2273022 | 2273022 | 2022-03-04 | Grand Traverse | Michigan | 26055 | 16987 | 219 |
2269770 | 2269770 | 2022-03-03 | Grand Traverse | Michigan | 26055 | 16963 | 218 |
2266517 | 2266517 | 2022-03-02 | Grand Traverse | Michigan | 26055 | 16963 | 218 |
2263266 | 2263266 | 2022-03-01 | Grand Traverse | Michigan | 26055 | 16938 | 214 |
2260015 | 2260015 | 2022-02-28 | Grand Traverse | Michigan | 26055 | 16938 | 214 |
2256764 | 2256764 | 2022-02-27 | Grand Traverse | Michigan | 26055 | 16904 | 213 |
2253513 | 2253513 | 2022-02-26 | Grand Traverse | Michigan | 26055 | 16904 | 213 |
2250262 | 2250262 | 2022-02-25 | Grand Traverse | Michigan | 26055 | 16904 | 213 |
2247011 | 2247011 | 2022-02-24 | Grand Traverse | Michigan | 26055 | 16869 | 212 |
2243760 | 2243760 | 2022-02-23 | Grand Traverse | Michigan | 26055 | 16869 | 212 |
2240509 | 2240509 | 2022-02-22 | Grand Traverse | Michigan | 26055 | 16755 | 209 |
2237258 | 2237258 | 2022-02-21 | Grand Traverse | Michigan | 26055 | 16755 | 209 |
2234007 | 2234007 | 2022-02-20 | Grand Traverse | Michigan | 26055 | 16755 | 209 |
2230756 | 2230756 | 2022-02-19 | Grand Traverse | Michigan | 26055 | 16681 | 208 |
2227505 | 2227505 | 2022-02-18 | Grand Traverse | Michigan | 26055 | 16681 | 208 |
2224254 | 2224254 | 2022-02-17 | Grand Traverse | Michigan | 26055 | 16681 | 208 |
2221003 | 2221003 | 2022-02-16 | Grand Traverse | Michigan | 26055 | 16681 | 208 |
2217752 | 2217752 | 2022-02-15 | Grand Traverse | Michigan | 26055 | 16609 | 205 |
2214501 | 2214501 | 2022-02-14 | Grand Traverse | Michigan | 26055 | 16609 | 205 |
2211249 | 2211249 | 2022-02-13 | Grand Traverse | Michigan | 26055 | 16547 | 204 |
2207996 | 2207996 | 2022-02-12 | Grand Traverse | Michigan | 26055 | 16547 | 204 |
2204743 | 2204743 | 2022-02-11 | Grand Traverse | Michigan | 26055 | 16547 | 204 |
2201490 | 2201490 | 2022-02-10 | Grand Traverse | Michigan | 26055 | 16479 | 202 |
2198236 | 2198236 | 2022-02-09 | Grand Traverse | Michigan | 26055 | 16479 | 202 |
2194982 | 2194982 | 2022-02-08 | Grand Traverse | Michigan | 26055 | 16377 | 201 |
2191728 | 2191728 | 2022-02-07 | Grand Traverse | Michigan | 26055 | 16377 | 201 |
2188475 | 2188475 | 2022-02-06 | Grand Traverse | Michigan | 26055 | 16281 | 201 |
2185222 | 2185222 | 2022-02-05 | Grand Traverse | Michigan | 26055 | 16281 | 201 |
2181970 | 2181970 | 2022-02-04 | Grand Traverse | Michigan | 26055 | 16281 | 201 |
2178718 | 2178718 | 2022-02-03 | Grand Traverse | Michigan | 26055 | 16156 | 199 |
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);