ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 26017 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 230 ✖
- 31 36
- 0 30
- 355 27
- 354 19
- 2 15
- 353 14
- 577 14
- 581 14
- 30 13
- 29 11
- 367 11
- 346 10
- 55 8
- 46 7
- 365 7
- 370 7
- 467 7
- 556 7
- 564 7
- 575 7
- 582 7
- 584 7
- 9 6
- 41 6
- 62 6
- 16 5
- 27 5
- 35 5
- 43 5
- 48 5
- 50 5
- 52 5
- 54 5
- 281 5
- 294 5
- 363 5
- 366 5
- 373 5
- 387 5
- 391 5
- 423 5
- 471 5
- 510 5
- 531 5
- 540 5
- 562 5
- 570 5
- 19 4
- 24 4
- 68 4
- 80 4
- 173 4
- 236 4
- 283 4
- 297 4
- 300 4
- 309 4
- 313 4
- 351 4
- 4 3
- 6 3
- 22 3
- 28 3
- 36 3
- 39 3
- 45 3
- 66 3
- 79 3
- 89 3
- 164 3
- 180 3
- 187 3
- 193 3
- 218 3
- 253 3
- 274 3
- 287 3
- 296 3
- 299 3
- 302 3
- 307 3
- 311 3
- 312 3
- 322 3
- 341 3
- 343 3
- 344 3
- 348 3
- 356 3
- 359 3
- 368 3
- 379 3
- 397 3
- 407 3
- 415 3
- 435 3
- 449 3
- 456 3
- 492 3
- 516 3
- 548 3
- 572 3
- 588 3
- 8 2
- 10 2
- 15 2
- 23 2
- 40 2
- 42 2
- 51 2
- 53 2
- 65 2
- 81 2
- 91 2
- 111 2
- 119 2
- 133 2
- 141 2
- 230 2
- 246 2
- 263 2
- 275 2
- 277 2
- 284 2
- 288 2
- 292 2
- 293 2
- 298 2
- 308 2
- 316 2
- 319 2
- 321 2
- 323 2
- 328 2
- 330 2
- 340 2
- 345 2
- 352 2
- 357 2
- 358 2
- 360 2
- 361 2
- 364 2
- 376 2
- 377 2
- 380 2
- 385 2
- 389 2
- 393 2
- 399 2
- 404 2
- 411 2
- 413 2
- 418 2
- 426 2
- 430 2
- 436 2
- 444 2
- 454 2
- 455 2
- 461 2
- 478 2
- 485 2
- 493 2
- 500 2
- 514 2
- 515 2
- 523 2
- 538 2
- 544 2
- 551 2
- 561 2
- 569 2
- 571 2
- 573 2
- 3 1
- 12 1
- 14 1
- 26 1
- 32 1
- 57 1
- 59 1
- 60 1
- 63 1
- 71 1
- 72 1
- 73 1
- 76 1
- 78 1
- 83 1
- 88 1
- 92 1
- 98 1
- 107 1
- 120 1
- 127 1
- 128 1
- 146 1
- 150 1
- 154 1
- 157 1
- 159 1
- 186 1
- 199 1
- 201 1
- 207 1
- 208 1
- 223 1
- 225 1
- 240 1
- 257 1
- 258 1
- 259 1
- 262 1
- 264 1
- 266 1
- 267 1
- 268 1
- 269 1
- 290 1
- 306 1
- 310 1
- 314 1
- 315 1
- 324 1
- 325 1
- 327 1
- 331 1
- 334 1
- 335 1
state 1
- Michigan 792
fips 1
- 26017 · 792 ✖
county 1
- Bay 792
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500829 | 2500829 | 2022-05-13 | Bay | Michigan | 26017 | 27496 | 588 |
2497571 | 2497571 | 2022-05-12 | Bay | Michigan | 26017 | 27496 | 588 |
2494313 | 2494313 | 2022-05-11 | Bay | Michigan | 26017 | 27496 | 588 |
2491055 | 2491055 | 2022-05-10 | Bay | Michigan | 26017 | 27284 | 584 |
2487798 | 2487798 | 2022-05-09 | Bay | Michigan | 26017 | 27284 | 584 |
2484540 | 2484540 | 2022-05-08 | Bay | Michigan | 26017 | 27284 | 584 |
2481282 | 2481282 | 2022-05-07 | Bay | Michigan | 26017 | 27284 | 584 |
2478024 | 2478024 | 2022-05-06 | Bay | Michigan | 26017 | 27284 | 584 |
2474766 | 2474766 | 2022-05-05 | Bay | Michigan | 26017 | 27284 | 584 |
2471509 | 2471509 | 2022-05-04 | Bay | Michigan | 26017 | 27284 | 584 |
2468253 | 2468253 | 2022-05-03 | Bay | Michigan | 26017 | 27154 | 582 |
2464998 | 2464998 | 2022-05-02 | Bay | Michigan | 26017 | 27154 | 582 |
2461742 | 2461742 | 2022-05-01 | Bay | Michigan | 26017 | 27154 | 582 |
2458486 | 2458486 | 2022-04-30 | Bay | Michigan | 26017 | 27154 | 582 |
2455230 | 2455230 | 2022-04-29 | Bay | Michigan | 26017 | 27154 | 582 |
2451974 | 2451974 | 2022-04-28 | Bay | Michigan | 26017 | 27154 | 582 |
2448718 | 2448718 | 2022-04-27 | Bay | Michigan | 26017 | 27154 | 582 |
2445462 | 2445462 | 2022-04-26 | Bay | Michigan | 26017 | 27082 | 581 |
2442206 | 2442206 | 2022-04-25 | Bay | Michigan | 26017 | 27082 | 581 |
2438950 | 2438950 | 2022-04-24 | Bay | Michigan | 26017 | 27082 | 581 |
2435694 | 2435694 | 2022-04-23 | Bay | Michigan | 26017 | 27082 | 581 |
2432438 | 2432438 | 2022-04-22 | Bay | Michigan | 26017 | 27082 | 581 |
2429182 | 2429182 | 2022-04-21 | Bay | Michigan | 26017 | 27082 | 581 |
2425926 | 2425926 | 2022-04-20 | Bay | Michigan | 26017 | 27082 | 581 |
2422670 | 2422670 | 2022-04-19 | Bay | Michigan | 26017 | 27034 | 581 |
2419414 | 2419414 | 2022-04-18 | Bay | Michigan | 26017 | 27034 | 581 |
2416158 | 2416158 | 2022-04-17 | Bay | Michigan | 26017 | 27034 | 581 |
2412902 | 2412902 | 2022-04-16 | Bay | Michigan | 26017 | 27034 | 581 |
2409646 | 2409646 | 2022-04-15 | Bay | Michigan | 26017 | 27034 | 581 |
2406390 | 2406390 | 2022-04-14 | Bay | Michigan | 26017 | 27034 | 581 |
2403134 | 2403134 | 2022-04-13 | Bay | Michigan | 26017 | 27034 | 581 |
2399880 | 2399880 | 2022-04-12 | Bay | Michigan | 26017 | 26993 | 577 |
2396624 | 2396624 | 2022-04-11 | Bay | Michigan | 26017 | 26993 | 577 |
2393369 | 2393369 | 2022-04-10 | Bay | Michigan | 26017 | 26993 | 577 |
2390113 | 2390113 | 2022-04-09 | Bay | Michigan | 26017 | 26993 | 577 |
2386857 | 2386857 | 2022-04-08 | Bay | Michigan | 26017 | 26993 | 577 |
2383602 | 2383602 | 2022-04-07 | Bay | Michigan | 26017 | 26993 | 577 |
2380347 | 2380347 | 2022-04-06 | Bay | Michigan | 26017 | 26993 | 577 |
2377092 | 2377092 | 2022-04-05 | Bay | Michigan | 26017 | 26986 | 577 |
2373840 | 2373840 | 2022-04-04 | Bay | Michigan | 26017 | 26986 | 577 |
2370587 | 2370587 | 2022-04-03 | Bay | Michigan | 26017 | 26986 | 577 |
2367334 | 2367334 | 2022-04-02 | Bay | Michigan | 26017 | 26986 | 577 |
2364081 | 2364081 | 2022-04-01 | Bay | Michigan | 26017 | 26986 | 577 |
2360827 | 2360827 | 2022-03-31 | Bay | Michigan | 26017 | 26975 | 577 |
2357573 | 2357573 | 2022-03-30 | Bay | Michigan | 26017 | 26975 | 577 |
2354320 | 2354320 | 2022-03-29 | Bay | Michigan | 26017 | 26970 | 575 |
2351068 | 2351068 | 2022-03-28 | Bay | Michigan | 26017 | 26970 | 575 |
2347815 | 2347815 | 2022-03-27 | Bay | Michigan | 26017 | 26963 | 575 |
2344562 | 2344562 | 2022-03-26 | Bay | Michigan | 26017 | 26963 | 575 |
2341309 | 2341309 | 2022-03-25 | Bay | Michigan | 26017 | 26963 | 575 |
2338056 | 2338056 | 2022-03-24 | Bay | Michigan | 26017 | 26959 | 575 |
2334802 | 2334802 | 2022-03-23 | Bay | Michigan | 26017 | 26959 | 575 |
2331548 | 2331548 | 2022-03-22 | Bay | Michigan | 26017 | 26958 | 573 |
2328296 | 2328296 | 2022-03-21 | Bay | Michigan | 26017 | 26958 | 573 |
2325043 | 2325043 | 2022-03-20 | Bay | Michigan | 26017 | 26952 | 572 |
2321789 | 2321789 | 2022-03-19 | Bay | Michigan | 26017 | 26952 | 572 |
2318535 | 2318535 | 2022-03-18 | Bay | Michigan | 26017 | 26952 | 572 |
2315282 | 2315282 | 2022-03-17 | Bay | Michigan | 26017 | 26947 | 571 |
2312029 | 2312029 | 2022-03-16 | Bay | Michigan | 26017 | 26947 | 571 |
2308776 | 2308776 | 2022-03-15 | Bay | Michigan | 26017 | 26933 | 570 |
2305525 | 2305525 | 2022-03-14 | Bay | Michigan | 26017 | 26933 | 570 |
2302273 | 2302273 | 2022-03-13 | Bay | Michigan | 26017 | 26924 | 570 |
2299021 | 2299021 | 2022-03-12 | Bay | Michigan | 26017 | 26924 | 570 |
2295769 | 2295769 | 2022-03-11 | Bay | Michigan | 26017 | 26924 | 570 |
2292517 | 2292517 | 2022-03-10 | Bay | Michigan | 26017 | 26911 | 569 |
2289265 | 2289265 | 2022-03-09 | Bay | Michigan | 26017 | 26911 | 569 |
2286014 | 2286014 | 2022-03-08 | Bay | Michigan | 26017 | 26892 | 564 |
2282762 | 2282762 | 2022-03-07 | Bay | Michigan | 26017 | 26892 | 564 |
2279509 | 2279509 | 2022-03-06 | Bay | Michigan | 26017 | 26875 | 564 |
2276256 | 2276256 | 2022-03-05 | Bay | Michigan | 26017 | 26875 | 564 |
2273003 | 2273003 | 2022-03-04 | Bay | Michigan | 26017 | 26875 | 564 |
2269751 | 2269751 | 2022-03-03 | Bay | Michigan | 26017 | 26851 | 564 |
2266498 | 2266498 | 2022-03-02 | Bay | Michigan | 26017 | 26851 | 564 |
2263247 | 2263247 | 2022-03-01 | Bay | Michigan | 26017 | 26822 | 562 |
2259996 | 2259996 | 2022-02-28 | Bay | Michigan | 26017 | 26822 | 562 |
2256745 | 2256745 | 2022-02-27 | Bay | Michigan | 26017 | 26795 | 562 |
2253494 | 2253494 | 2022-02-26 | Bay | Michigan | 26017 | 26795 | 562 |
2250243 | 2250243 | 2022-02-25 | Bay | Michigan | 26017 | 26795 | 562 |
2246992 | 2246992 | 2022-02-24 | Bay | Michigan | 26017 | 26744 | 561 |
2243741 | 2243741 | 2022-02-23 | Bay | Michigan | 26017 | 26744 | 561 |
2240490 | 2240490 | 2022-02-22 | Bay | Michigan | 26017 | 26654 | 556 |
2237239 | 2237239 | 2022-02-21 | Bay | Michigan | 26017 | 26654 | 556 |
2233988 | 2233988 | 2022-02-20 | Bay | Michigan | 26017 | 26654 | 556 |
2230737 | 2230737 | 2022-02-19 | Bay | Michigan | 26017 | 26593 | 556 |
2227486 | 2227486 | 2022-02-18 | Bay | Michigan | 26017 | 26593 | 556 |
2224235 | 2224235 | 2022-02-17 | Bay | Michigan | 26017 | 26593 | 556 |
2220984 | 2220984 | 2022-02-16 | Bay | Michigan | 26017 | 26593 | 556 |
2217733 | 2217733 | 2022-02-15 | Bay | Michigan | 26017 | 26529 | 551 |
2214482 | 2214482 | 2022-02-14 | Bay | Michigan | 26017 | 26529 | 551 |
2211230 | 2211230 | 2022-02-13 | Bay | Michigan | 26017 | 26425 | 548 |
2207977 | 2207977 | 2022-02-12 | Bay | Michigan | 26017 | 26425 | 548 |
2204724 | 2204724 | 2022-02-11 | Bay | Michigan | 26017 | 26425 | 548 |
2201471 | 2201471 | 2022-02-10 | Bay | Michigan | 26017 | 26319 | 544 |
2198217 | 2198217 | 2022-02-09 | Bay | Michigan | 26017 | 26319 | 544 |
2194963 | 2194963 | 2022-02-08 | Bay | Michigan | 26017 | 26159 | 540 |
2191709 | 2191709 | 2022-02-07 | Bay | Michigan | 26017 | 26159 | 540 |
2188456 | 2188456 | 2022-02-06 | Bay | Michigan | 26017 | 26025 | 540 |
2185203 | 2185203 | 2022-02-05 | Bay | Michigan | 26017 | 26025 | 540 |
2181951 | 2181951 | 2022-02-04 | Bay | Michigan | 26017 | 26025 | 540 |
2178699 | 2178699 | 2022-02-03 | Bay | Michigan | 26017 | 25855 | 538 |
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);