ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Lapeer" and fips = 26087 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 |
---|---|---|---|---|---|---|---|
2500864 | 2500864 | 2022-05-13 | Lapeer | Michigan | 26087 | 21122 | 427 |
2497606 | 2497606 | 2022-05-12 | Lapeer | Michigan | 26087 | 21122 | 427 |
2494348 | 2494348 | 2022-05-11 | Lapeer | Michigan | 26087 | 21122 | 427 |
2491090 | 2491090 | 2022-05-10 | Lapeer | Michigan | 26087 | 20983 | 427 |
2487833 | 2487833 | 2022-05-09 | Lapeer | Michigan | 26087 | 20983 | 427 |
2484575 | 2484575 | 2022-05-08 | Lapeer | Michigan | 26087 | 20983 | 427 |
2481317 | 2481317 | 2022-05-07 | Lapeer | Michigan | 26087 | 20983 | 427 |
2478059 | 2478059 | 2022-05-06 | Lapeer | Michigan | 26087 | 20983 | 427 |
2474801 | 2474801 | 2022-05-05 | Lapeer | Michigan | 26087 | 20983 | 427 |
2471544 | 2471544 | 2022-05-04 | Lapeer | Michigan | 26087 | 20983 | 427 |
2468288 | 2468288 | 2022-05-03 | Lapeer | Michigan | 26087 | 20909 | 427 |
2465033 | 2465033 | 2022-05-02 | Lapeer | Michigan | 26087 | 20909 | 427 |
2461777 | 2461777 | 2022-05-01 | Lapeer | Michigan | 26087 | 20909 | 427 |
2458521 | 2458521 | 2022-04-30 | Lapeer | Michigan | 26087 | 20909 | 427 |
2455265 | 2455265 | 2022-04-29 | Lapeer | Michigan | 26087 | 20909 | 427 |
2452009 | 2452009 | 2022-04-28 | Lapeer | Michigan | 26087 | 20909 | 427 |
2448753 | 2448753 | 2022-04-27 | Lapeer | Michigan | 26087 | 20909 | 427 |
2445497 | 2445497 | 2022-04-26 | Lapeer | Michigan | 26087 | 20857 | 427 |
2442241 | 2442241 | 2022-04-25 | Lapeer | Michigan | 26087 | 20857 | 427 |
2438985 | 2438985 | 2022-04-24 | Lapeer | Michigan | 26087 | 20857 | 427 |
2435729 | 2435729 | 2022-04-23 | Lapeer | Michigan | 26087 | 20857 | 427 |
2432473 | 2432473 | 2022-04-22 | Lapeer | Michigan | 26087 | 20857 | 427 |
2429217 | 2429217 | 2022-04-21 | Lapeer | Michigan | 26087 | 20857 | 427 |
2425961 | 2425961 | 2022-04-20 | Lapeer | Michigan | 26087 | 20857 | 427 |
2422705 | 2422705 | 2022-04-19 | Lapeer | Michigan | 26087 | 20811 | 427 |
2419449 | 2419449 | 2022-04-18 | Lapeer | Michigan | 26087 | 20811 | 427 |
2416193 | 2416193 | 2022-04-17 | Lapeer | Michigan | 26087 | 20811 | 427 |
2412937 | 2412937 | 2022-04-16 | Lapeer | Michigan | 26087 | 20811 | 427 |
2409681 | 2409681 | 2022-04-15 | Lapeer | Michigan | 26087 | 20811 | 427 |
2406425 | 2406425 | 2022-04-14 | Lapeer | Michigan | 26087 | 20811 | 427 |
2403169 | 2403169 | 2022-04-13 | Lapeer | Michigan | 26087 | 20811 | 427 |
2399915 | 2399915 | 2022-04-12 | Lapeer | Michigan | 26087 | 20784 | 427 |
2396659 | 2396659 | 2022-04-11 | Lapeer | Michigan | 26087 | 20784 | 427 |
2393404 | 2393404 | 2022-04-10 | Lapeer | Michigan | 26087 | 20784 | 427 |
2390148 | 2390148 | 2022-04-09 | Lapeer | Michigan | 26087 | 20784 | 427 |
2386892 | 2386892 | 2022-04-08 | Lapeer | Michigan | 26087 | 20784 | 427 |
2383637 | 2383637 | 2022-04-07 | Lapeer | Michigan | 26087 | 20784 | 427 |
2380382 | 2380382 | 2022-04-06 | Lapeer | Michigan | 26087 | 20784 | 427 |
2377127 | 2377127 | 2022-04-05 | Lapeer | Michigan | 26087 | 20768 | 426 |
2373875 | 2373875 | 2022-04-04 | Lapeer | Michigan | 26087 | 20768 | 426 |
2370622 | 2370622 | 2022-04-03 | Lapeer | Michigan | 26087 | 20768 | 426 |
2367369 | 2367369 | 2022-04-02 | Lapeer | Michigan | 26087 | 20768 | 426 |
2364116 | 2364116 | 2022-04-01 | Lapeer | Michigan | 26087 | 20768 | 426 |
2360862 | 2360862 | 2022-03-31 | Lapeer | Michigan | 26087 | 20766 | 426 |
2357608 | 2357608 | 2022-03-30 | Lapeer | Michigan | 26087 | 20766 | 426 |
2354355 | 2354355 | 2022-03-29 | Lapeer | Michigan | 26087 | 20756 | 426 |
2351103 | 2351103 | 2022-03-28 | Lapeer | Michigan | 26087 | 20756 | 426 |
2347850 | 2347850 | 2022-03-27 | Lapeer | Michigan | 26087 | 20757 | 425 |
2344597 | 2344597 | 2022-03-26 | Lapeer | Michigan | 26087 | 20757 | 425 |
2341344 | 2341344 | 2022-03-25 | Lapeer | Michigan | 26087 | 20757 | 425 |
2338091 | 2338091 | 2022-03-24 | Lapeer | Michigan | 26087 | 20750 | 424 |
2334837 | 2334837 | 2022-03-23 | Lapeer | Michigan | 26087 | 20750 | 424 |
2331583 | 2331583 | 2022-03-22 | Lapeer | Michigan | 26087 | 20732 | 422 |
2328331 | 2328331 | 2022-03-21 | Lapeer | Michigan | 26087 | 20732 | 422 |
2325078 | 2325078 | 2022-03-20 | Lapeer | Michigan | 26087 | 20729 | 422 |
2321824 | 2321824 | 2022-03-19 | Lapeer | Michigan | 26087 | 20729 | 422 |
2318570 | 2318570 | 2022-03-18 | Lapeer | Michigan | 26087 | 20729 | 422 |
2315317 | 2315317 | 2022-03-17 | Lapeer | Michigan | 26087 | 20719 | 419 |
2312064 | 2312064 | 2022-03-16 | Lapeer | Michigan | 26087 | 20719 | 419 |
2308811 | 2308811 | 2022-03-15 | Lapeer | Michigan | 26087 | 20706 | 418 |
2305560 | 2305560 | 2022-03-14 | Lapeer | Michigan | 26087 | 20706 | 418 |
2302308 | 2302308 | 2022-03-13 | Lapeer | Michigan | 26087 | 20696 | 418 |
2299056 | 2299056 | 2022-03-12 | Lapeer | Michigan | 26087 | 20696 | 418 |
2295804 | 2295804 | 2022-03-11 | Lapeer | Michigan | 26087 | 20696 | 418 |
2292552 | 2292552 | 2022-03-10 | Lapeer | Michigan | 26087 | 20685 | 418 |
2289300 | 2289300 | 2022-03-09 | Lapeer | Michigan | 26087 | 20685 | 418 |
2286049 | 2286049 | 2022-03-08 | Lapeer | Michigan | 26087 | 20666 | 416 |
2282797 | 2282797 | 2022-03-07 | Lapeer | Michigan | 26087 | 20666 | 416 |
2279544 | 2279544 | 2022-03-06 | Lapeer | Michigan | 26087 | 20659 | 416 |
2276291 | 2276291 | 2022-03-05 | Lapeer | Michigan | 26087 | 20659 | 416 |
2273038 | 2273038 | 2022-03-04 | Lapeer | Michigan | 26087 | 20659 | 416 |
2269786 | 2269786 | 2022-03-03 | Lapeer | Michigan | 26087 | 20653 | 416 |
2266533 | 2266533 | 2022-03-02 | Lapeer | Michigan | 26087 | 20653 | 416 |
2263282 | 2263282 | 2022-03-01 | Lapeer | Michigan | 26087 | 20621 | 414 |
2260031 | 2260031 | 2022-02-28 | Lapeer | Michigan | 26087 | 20621 | 414 |
2256780 | 2256780 | 2022-02-27 | Lapeer | Michigan | 26087 | 20614 | 414 |
2253529 | 2253529 | 2022-02-26 | Lapeer | Michigan | 26087 | 20614 | 414 |
2250278 | 2250278 | 2022-02-25 | Lapeer | Michigan | 26087 | 20614 | 414 |
2247027 | 2247027 | 2022-02-24 | Lapeer | Michigan | 26087 | 20583 | 410 |
2243776 | 2243776 | 2022-02-23 | Lapeer | Michigan | 26087 | 20583 | 410 |
2240525 | 2240525 | 2022-02-22 | Lapeer | Michigan | 26087 | 20529 | 406 |
2237274 | 2237274 | 2022-02-21 | Lapeer | Michigan | 26087 | 20529 | 406 |
2234023 | 2234023 | 2022-02-20 | Lapeer | Michigan | 26087 | 20529 | 406 |
2230772 | 2230772 | 2022-02-19 | Lapeer | Michigan | 26087 | 20501 | 405 |
2227521 | 2227521 | 2022-02-18 | Lapeer | Michigan | 26087 | 20501 | 405 |
2224270 | 2224270 | 2022-02-17 | Lapeer | Michigan | 26087 | 20501 | 405 |
2221019 | 2221019 | 2022-02-16 | Lapeer | Michigan | 26087 | 20501 | 405 |
2217768 | 2217768 | 2022-02-15 | Lapeer | Michigan | 26087 | 20440 | 402 |
2214517 | 2214517 | 2022-02-14 | Lapeer | Michigan | 26087 | 20440 | 402 |
2211265 | 2211265 | 2022-02-13 | Lapeer | Michigan | 26087 | 20397 | 402 |
2208012 | 2208012 | 2022-02-12 | Lapeer | Michigan | 26087 | 20397 | 402 |
2204759 | 2204759 | 2022-02-11 | Lapeer | Michigan | 26087 | 20397 | 402 |
2201506 | 2201506 | 2022-02-10 | Lapeer | Michigan | 26087 | 20351 | 398 |
2198252 | 2198252 | 2022-02-09 | Lapeer | Michigan | 26087 | 20351 | 398 |
2194998 | 2194998 | 2022-02-08 | Lapeer | Michigan | 26087 | 20268 | 395 |
2191744 | 2191744 | 2022-02-07 | Lapeer | Michigan | 26087 | 20268 | 395 |
2188491 | 2188491 | 2022-02-06 | Lapeer | Michigan | 26087 | 20201 | 395 |
2185238 | 2185238 | 2022-02-05 | Lapeer | Michigan | 26087 | 20201 | 395 |
2181986 | 2181986 | 2022-02-04 | Lapeer | Michigan | 26087 | 20201 | 395 |
2178734 | 2178734 | 2022-02-03 | Lapeer | Michigan | 26087 | 20128 | 391 |
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);