ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Kalkaska" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500860 | 2500860 | 2022-05-13 | Kalkaska | Michigan | 26079 | 3623 | 61 |
2497602 | 2497602 | 2022-05-12 | Kalkaska | Michigan | 26079 | 3623 | 61 |
2494344 | 2494344 | 2022-05-11 | Kalkaska | Michigan | 26079 | 3623 | 61 |
2491086 | 2491086 | 2022-05-10 | Kalkaska | Michigan | 26079 | 3582 | 61 |
2487829 | 2487829 | 2022-05-09 | Kalkaska | Michigan | 26079 | 3582 | 61 |
2484571 | 2484571 | 2022-05-08 | Kalkaska | Michigan | 26079 | 3582 | 61 |
2481313 | 2481313 | 2022-05-07 | Kalkaska | Michigan | 26079 | 3582 | 61 |
2478055 | 2478055 | 2022-05-06 | Kalkaska | Michigan | 26079 | 3582 | 61 |
2474797 | 2474797 | 2022-05-05 | Kalkaska | Michigan | 26079 | 3582 | 61 |
2471540 | 2471540 | 2022-05-04 | Kalkaska | Michigan | 26079 | 3582 | 61 |
2468284 | 2468284 | 2022-05-03 | Kalkaska | Michigan | 26079 | 3564 | 60 |
2465029 | 2465029 | 2022-05-02 | Kalkaska | Michigan | 26079 | 3564 | 60 |
2461773 | 2461773 | 2022-05-01 | Kalkaska | Michigan | 26079 | 3564 | 60 |
2458517 | 2458517 | 2022-04-30 | Kalkaska | Michigan | 26079 | 3564 | 60 |
2455261 | 2455261 | 2022-04-29 | Kalkaska | Michigan | 26079 | 3564 | 60 |
2452005 | 2452005 | 2022-04-28 | Kalkaska | Michigan | 26079 | 3564 | 60 |
2448749 | 2448749 | 2022-04-27 | Kalkaska | Michigan | 26079 | 3564 | 60 |
2445493 | 2445493 | 2022-04-26 | Kalkaska | Michigan | 26079 | 3547 | 60 |
2442237 | 2442237 | 2022-04-25 | Kalkaska | Michigan | 26079 | 3547 | 60 |
2438981 | 2438981 | 2022-04-24 | Kalkaska | Michigan | 26079 | 3547 | 60 |
2435725 | 2435725 | 2022-04-23 | Kalkaska | Michigan | 26079 | 3547 | 60 |
2432469 | 2432469 | 2022-04-22 | Kalkaska | Michigan | 26079 | 3547 | 60 |
2429213 | 2429213 | 2022-04-21 | Kalkaska | Michigan | 26079 | 3547 | 60 |
2425957 | 2425957 | 2022-04-20 | Kalkaska | Michigan | 26079 | 3547 | 60 |
2422701 | 2422701 | 2022-04-19 | Kalkaska | Michigan | 26079 | 3533 | 60 |
2419445 | 2419445 | 2022-04-18 | Kalkaska | Michigan | 26079 | 3533 | 60 |
2416189 | 2416189 | 2022-04-17 | Kalkaska | Michigan | 26079 | 3533 | 60 |
2412933 | 2412933 | 2022-04-16 | Kalkaska | Michigan | 26079 | 3533 | 60 |
2409677 | 2409677 | 2022-04-15 | Kalkaska | Michigan | 26079 | 3533 | 60 |
2406421 | 2406421 | 2022-04-14 | Kalkaska | Michigan | 26079 | 3533 | 60 |
2403165 | 2403165 | 2022-04-13 | Kalkaska | Michigan | 26079 | 3533 | 60 |
2399911 | 2399911 | 2022-04-12 | Kalkaska | Michigan | 26079 | 3529 | 60 |
2396655 | 2396655 | 2022-04-11 | Kalkaska | Michigan | 26079 | 3529 | 60 |
2393400 | 2393400 | 2022-04-10 | Kalkaska | Michigan | 26079 | 3529 | 60 |
2390144 | 2390144 | 2022-04-09 | Kalkaska | Michigan | 26079 | 3529 | 60 |
2386888 | 2386888 | 2022-04-08 | Kalkaska | Michigan | 26079 | 3529 | 60 |
2383633 | 2383633 | 2022-04-07 | Kalkaska | Michigan | 26079 | 3529 | 60 |
2380378 | 2380378 | 2022-04-06 | Kalkaska | Michigan | 26079 | 3529 | 60 |
2377123 | 2377123 | 2022-04-05 | Kalkaska | Michigan | 26079 | 3523 | 60 |
2373871 | 2373871 | 2022-04-04 | Kalkaska | Michigan | 26079 | 3523 | 60 |
2370618 | 2370618 | 2022-04-03 | Kalkaska | Michigan | 26079 | 3523 | 60 |
2367365 | 2367365 | 2022-04-02 | Kalkaska | Michigan | 26079 | 3523 | 60 |
2364112 | 2364112 | 2022-04-01 | Kalkaska | Michigan | 26079 | 3523 | 60 |
2360858 | 2360858 | 2022-03-31 | Kalkaska | Michigan | 26079 | 3522 | 60 |
2357604 | 2357604 | 2022-03-30 | Kalkaska | Michigan | 26079 | 3522 | 60 |
2354351 | 2354351 | 2022-03-29 | Kalkaska | Michigan | 26079 | 3523 | 60 |
2351099 | 2351099 | 2022-03-28 | Kalkaska | Michigan | 26079 | 3523 | 60 |
2347846 | 2347846 | 2022-03-27 | Kalkaska | Michigan | 26079 | 3521 | 60 |
2344593 | 2344593 | 2022-03-26 | Kalkaska | Michigan | 26079 | 3521 | 60 |
2341340 | 2341340 | 2022-03-25 | Kalkaska | Michigan | 26079 | 3521 | 60 |
2338087 | 2338087 | 2022-03-24 | Kalkaska | Michigan | 26079 | 3518 | 60 |
2334833 | 2334833 | 2022-03-23 | Kalkaska | Michigan | 26079 | 3518 | 60 |
2331579 | 2331579 | 2022-03-22 | Kalkaska | Michigan | 26079 | 3514 | 60 |
2328327 | 2328327 | 2022-03-21 | Kalkaska | Michigan | 26079 | 3514 | 60 |
2325074 | 2325074 | 2022-03-20 | Kalkaska | Michigan | 26079 | 3511 | 60 |
2321820 | 2321820 | 2022-03-19 | Kalkaska | Michigan | 26079 | 3511 | 60 |
2318566 | 2318566 | 2022-03-18 | Kalkaska | Michigan | 26079 | 3511 | 60 |
2315313 | 2315313 | 2022-03-17 | Kalkaska | Michigan | 26079 | 3511 | 59 |
2312060 | 2312060 | 2022-03-16 | Kalkaska | Michigan | 26079 | 3511 | 59 |
2308807 | 2308807 | 2022-03-15 | Kalkaska | Michigan | 26079 | 3509 | 59 |
2305556 | 2305556 | 2022-03-14 | Kalkaska | Michigan | 26079 | 3509 | 59 |
2302304 | 2302304 | 2022-03-13 | Kalkaska | Michigan | 26079 | 3502 | 59 |
2299052 | 2299052 | 2022-03-12 | Kalkaska | Michigan | 26079 | 3502 | 59 |
2295800 | 2295800 | 2022-03-11 | Kalkaska | Michigan | 26079 | 3502 | 59 |
2292548 | 2292548 | 2022-03-10 | Kalkaska | Michigan | 26079 | 3497 | 59 |
2289296 | 2289296 | 2022-03-09 | Kalkaska | Michigan | 26079 | 3497 | 59 |
2286045 | 2286045 | 2022-03-08 | Kalkaska | Michigan | 26079 | 3496 | 57 |
2282793 | 2282793 | 2022-03-07 | Kalkaska | Michigan | 26079 | 3496 | 57 |
2279540 | 2279540 | 2022-03-06 | Kalkaska | Michigan | 26079 | 3491 | 55 |
2276287 | 2276287 | 2022-03-05 | Kalkaska | Michigan | 26079 | 3491 | 55 |
2273034 | 2273034 | 2022-03-04 | Kalkaska | Michigan | 26079 | 3491 | 55 |
2269782 | 2269782 | 2022-03-03 | Kalkaska | Michigan | 26079 | 3489 | 54 |
2266529 | 2266529 | 2022-03-02 | Kalkaska | Michigan | 26079 | 3489 | 54 |
2263278 | 2263278 | 2022-03-01 | Kalkaska | Michigan | 26079 | 3481 | 53 |
2260027 | 2260027 | 2022-02-28 | Kalkaska | Michigan | 26079 | 3481 | 53 |
2256776 | 2256776 | 2022-02-27 | Kalkaska | Michigan | 26079 | 3480 | 53 |
2253525 | 2253525 | 2022-02-26 | Kalkaska | Michigan | 26079 | 3480 | 53 |
2250274 | 2250274 | 2022-02-25 | Kalkaska | Michigan | 26079 | 3480 | 53 |
2247023 | 2247023 | 2022-02-24 | Kalkaska | Michigan | 26079 | 3473 | 53 |
2243772 | 2243772 | 2022-02-23 | Kalkaska | Michigan | 26079 | 3473 | 53 |
2240521 | 2240521 | 2022-02-22 | Kalkaska | Michigan | 26079 | 3458 | 53 |
2237270 | 2237270 | 2022-02-21 | Kalkaska | Michigan | 26079 | 3458 | 53 |
2234019 | 2234019 | 2022-02-20 | Kalkaska | Michigan | 26079 | 3458 | 53 |
2230768 | 2230768 | 2022-02-19 | Kalkaska | Michigan | 26079 | 3450 | 53 |
2227517 | 2227517 | 2022-02-18 | Kalkaska | Michigan | 26079 | 3450 | 53 |
2224266 | 2224266 | 2022-02-17 | Kalkaska | Michigan | 26079 | 3450 | 53 |
2221015 | 2221015 | 2022-02-16 | Kalkaska | Michigan | 26079 | 3450 | 53 |
2217764 | 2217764 | 2022-02-15 | Kalkaska | Michigan | 26079 | 3439 | 53 |
2214513 | 2214513 | 2022-02-14 | Kalkaska | Michigan | 26079 | 3439 | 53 |
2211261 | 2211261 | 2022-02-13 | Kalkaska | Michigan | 26079 | 3431 | 52 |
2208008 | 2208008 | 2022-02-12 | Kalkaska | Michigan | 26079 | 3431 | 52 |
2204755 | 2204755 | 2022-02-11 | Kalkaska | Michigan | 26079 | 3431 | 52 |
2201502 | 2201502 | 2022-02-10 | Kalkaska | Michigan | 26079 | 3411 | 52 |
2198248 | 2198248 | 2022-02-09 | Kalkaska | Michigan | 26079 | 3411 | 52 |
2194994 | 2194994 | 2022-02-08 | Kalkaska | Michigan | 26079 | 3385 | 51 |
2191740 | 2191740 | 2022-02-07 | Kalkaska | Michigan | 26079 | 3385 | 51 |
2188487 | 2188487 | 2022-02-06 | Kalkaska | Michigan | 26079 | 3367 | 50 |
2185234 | 2185234 | 2022-02-05 | Kalkaska | Michigan | 26079 | 3367 | 50 |
2181982 | 2181982 | 2022-02-04 | Kalkaska | Michigan | 26079 | 3367 | 50 |
2178730 | 2178730 | 2022-02-03 | Kalkaska | Michigan | 26079 | 3343 | 49 |
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);