ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 26157 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636205 | 636205 | 2020-10-16 | Tuscola | Michigan | 26157 | 573 | 34 |
632959 | 632959 | 2020-10-15 | Tuscola | Michigan | 26157 | 557 | 34 |
629714 | 629714 | 2020-10-14 | Tuscola | Michigan | 26157 | 556 | 34 |
626470 | 626470 | 2020-10-13 | Tuscola | Michigan | 26157 | 548 | 34 |
623228 | 623228 | 2020-10-12 | Tuscola | Michigan | 26157 | 543 | 34 |
619985 | 619985 | 2020-10-11 | Tuscola | Michigan | 26157 | 541 | 33 |
616743 | 616743 | 2020-10-10 | Tuscola | Michigan | 26157 | 541 | 33 |
613502 | 613502 | 2020-10-09 | Tuscola | Michigan | 26157 | 538 | 33 |
610260 | 610260 | 2020-10-08 | Tuscola | Michigan | 26157 | 536 | 33 |
607018 | 607018 | 2020-10-07 | Tuscola | Michigan | 26157 | 530 | 33 |
603775 | 603775 | 2020-10-06 | Tuscola | Michigan | 26157 | 529 | 32 |
600533 | 600533 | 2020-10-05 | Tuscola | Michigan | 26157 | 530 | 31 |
597290 | 597290 | 2020-10-04 | Tuscola | Michigan | 26157 | 527 | 31 |
594049 | 594049 | 2020-10-03 | Tuscola | Michigan | 26157 | 527 | 31 |
590808 | 590808 | 2020-10-02 | Tuscola | Michigan | 26157 | 520 | 31 |
587567 | 587567 | 2020-10-01 | Tuscola | Michigan | 26157 | 514 | 31 |
584327 | 584327 | 2020-09-30 | Tuscola | Michigan | 26157 | 514 | 31 |
581086 | 581086 | 2020-09-29 | Tuscola | Michigan | 26157 | 515 | 31 |
577845 | 577845 | 2020-09-28 | Tuscola | Michigan | 26157 | 513 | 31 |
574604 | 574604 | 2020-09-27 | Tuscola | Michigan | 26157 | 509 | 31 |
571361 | 571361 | 2020-09-26 | Tuscola | Michigan | 26157 | 509 | 31 |
568119 | 568119 | 2020-09-25 | Tuscola | Michigan | 26157 | 510 | 31 |
564879 | 564879 | 2020-09-24 | Tuscola | Michigan | 26157 | 502 | 31 |
561639 | 561639 | 2020-09-23 | Tuscola | Michigan | 26157 | 497 | 31 |
558402 | 558402 | 2020-09-22 | Tuscola | Michigan | 26157 | 495 | 31 |
555165 | 555165 | 2020-09-21 | Tuscola | Michigan | 26157 | 493 | 31 |
551927 | 551927 | 2020-09-20 | Tuscola | Michigan | 26157 | 488 | 31 |
548688 | 548688 | 2020-09-19 | Tuscola | Michigan | 26157 | 488 | 31 |
545450 | 545450 | 2020-09-18 | Tuscola | Michigan | 26157 | 482 | 31 |
542213 | 542213 | 2020-09-17 | Tuscola | Michigan | 26157 | 479 | 31 |
538977 | 538977 | 2020-09-16 | Tuscola | Michigan | 26157 | 476 | 30 |
535740 | 535740 | 2020-09-15 | Tuscola | Michigan | 26157 | 474 | 29 |
532505 | 532505 | 2020-09-14 | Tuscola | Michigan | 26157 | 473 | 29 |
529269 | 529269 | 2020-09-13 | Tuscola | Michigan | 26157 | 471 | 29 |
526033 | 526033 | 2020-09-12 | Tuscola | Michigan | 26157 | 471 | 29 |
522797 | 522797 | 2020-09-11 | Tuscola | Michigan | 26157 | 469 | 29 |
519560 | 519560 | 2020-09-10 | Tuscola | Michigan | 26157 | 473 | 29 |
516325 | 516325 | 2020-09-09 | Tuscola | Michigan | 26157 | 469 | 29 |
513091 | 513091 | 2020-09-08 | Tuscola | Michigan | 26157 | 469 | 29 |
509859 | 509859 | 2020-09-07 | Tuscola | Michigan | 26157 | 469 | 29 |
506626 | 506626 | 2020-09-06 | Tuscola | Michigan | 26157 | 467 | 29 |
503393 | 503393 | 2020-09-05 | Tuscola | Michigan | 26157 | 467 | 29 |
500159 | 500159 | 2020-09-04 | Tuscola | Michigan | 26157 | 466 | 29 |
496925 | 496925 | 2020-09-03 | Tuscola | Michigan | 26157 | 462 | 29 |
493692 | 493692 | 2020-09-02 | Tuscola | Michigan | 26157 | 459 | 29 |
490458 | 490458 | 2020-09-01 | Tuscola | Michigan | 26157 | 455 | 29 |
487225 | 487225 | 2020-08-31 | Tuscola | Michigan | 26157 | 454 | 29 |
483991 | 483991 | 2020-08-30 | Tuscola | Michigan | 26157 | 451 | 29 |
480756 | 480756 | 2020-08-29 | Tuscola | Michigan | 26157 | 446 | 29 |
477524 | 477524 | 2020-08-28 | Tuscola | Michigan | 26157 | 442 | 29 |
474291 | 474291 | 2020-08-27 | Tuscola | Michigan | 26157 | 432 | 29 |
471059 | 471059 | 2020-08-26 | Tuscola | Michigan | 26157 | 431 | 29 |
467829 | 467829 | 2020-08-25 | Tuscola | Michigan | 26157 | 427 | 29 |
464600 | 464600 | 2020-08-24 | Tuscola | Michigan | 26157 | 422 | 29 |
461369 | 461369 | 2020-08-23 | Tuscola | Michigan | 26157 | 417 | 29 |
458142 | 458142 | 2020-08-22 | Tuscola | Michigan | 26157 | 415 | 29 |
454914 | 454914 | 2020-08-21 | Tuscola | Michigan | 26157 | 394 | 29 |
451686 | 451686 | 2020-08-20 | Tuscola | Michigan | 26157 | 394 | 29 |
448458 | 448458 | 2020-08-19 | Tuscola | Michigan | 26157 | 392 | 29 |
445232 | 445232 | 2020-08-18 | Tuscola | Michigan | 26157 | 391 | 29 |
442006 | 442006 | 2020-08-17 | Tuscola | Michigan | 26157 | 386 | 29 |
438779 | 438779 | 2020-08-16 | Tuscola | Michigan | 26157 | 385 | 29 |
435554 | 435554 | 2020-08-15 | Tuscola | Michigan | 26157 | 383 | 29 |
432328 | 432328 | 2020-08-14 | Tuscola | Michigan | 26157 | 377 | 29 |
429101 | 429101 | 2020-08-13 | Tuscola | Michigan | 26157 | 367 | 29 |
425877 | 425877 | 2020-08-12 | Tuscola | Michigan | 26157 | 362 | 29 |
422655 | 422655 | 2020-08-11 | Tuscola | Michigan | 26157 | 356 | 29 |
419433 | 419433 | 2020-08-10 | Tuscola | Michigan | 26157 | 356 | 29 |
416212 | 416212 | 2020-08-09 | Tuscola | Michigan | 26157 | 350 | 29 |
412992 | 412992 | 2020-08-08 | Tuscola | Michigan | 26157 | 342 | 29 |
409772 | 409772 | 2020-08-07 | Tuscola | Michigan | 26157 | 334 | 29 |
406552 | 406552 | 2020-08-06 | Tuscola | Michigan | 26157 | 330 | 29 |
403334 | 403334 | 2020-08-05 | Tuscola | Michigan | 26157 | 324 | 29 |
400117 | 400117 | 2020-08-04 | Tuscola | Michigan | 26157 | 322 | 29 |
396903 | 396903 | 2020-08-03 | Tuscola | Michigan | 26157 | 310 | 28 |
393687 | 393687 | 2020-08-02 | Tuscola | Michigan | 26157 | 307 | 27 |
390470 | 390470 | 2020-08-01 | Tuscola | Michigan | 26157 | 304 | 27 |
387253 | 387253 | 2020-07-31 | Tuscola | Michigan | 26157 | 300 | 27 |
384035 | 384035 | 2020-07-30 | Tuscola | Michigan | 26157 | 297 | 27 |
380818 | 380818 | 2020-07-29 | Tuscola | Michigan | 26157 | 292 | 27 |
377601 | 377601 | 2020-07-28 | Tuscola | Michigan | 26157 | 286 | 27 |
374386 | 374386 | 2020-07-27 | Tuscola | Michigan | 26157 | 276 | 27 |
371174 | 371174 | 2020-07-26 | Tuscola | Michigan | 26157 | 270 | 27 |
367964 | 367964 | 2020-07-25 | Tuscola | Michigan | 26157 | 268 | 27 |
364757 | 364757 | 2020-07-24 | Tuscola | Michigan | 26157 | 265 | 27 |
361550 | 361550 | 2020-07-23 | Tuscola | Michigan | 26157 | 262 | 27 |
358345 | 358345 | 2020-07-22 | Tuscola | Michigan | 26157 | 258 | 27 |
355142 | 355142 | 2020-07-21 | Tuscola | Michigan | 26157 | 254 | 27 |
351940 | 351940 | 2020-07-20 | Tuscola | Michigan | 26157 | 251 | 27 |
348740 | 348740 | 2020-07-19 | Tuscola | Michigan | 26157 | 251 | 27 |
345539 | 345539 | 2020-07-18 | Tuscola | Michigan | 26157 | 248 | 27 |
342339 | 342339 | 2020-07-17 | Tuscola | Michigan | 26157 | 247 | 27 |
339143 | 339143 | 2020-07-16 | Tuscola | Michigan | 26157 | 247 | 27 |
335947 | 335947 | 2020-07-15 | Tuscola | Michigan | 26157 | 244 | 27 |
332754 | 332754 | 2020-07-14 | Tuscola | Michigan | 26157 | 243 | 27 |
329567 | 329567 | 2020-07-13 | Tuscola | Michigan | 26157 | 244 | 27 |
326381 | 326381 | 2020-07-12 | Tuscola | Michigan | 26157 | 247 | 27 |
323198 | 323198 | 2020-07-11 | Tuscola | Michigan | 26157 | 246 | 27 |
320019 | 320019 | 2020-07-10 | Tuscola | Michigan | 26157 | 242 | 26 |
316844 | 316844 | 2020-07-09 | Tuscola | Michigan | 26157 | 243 | 26 |
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);