ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 26037 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636145 | 636145 | 2020-10-16 | Clinton | Michigan | 26037 | 857 | 14 |
632899 | 632899 | 2020-10-15 | Clinton | Michigan | 26037 | 844 | 14 |
629654 | 629654 | 2020-10-14 | Clinton | Michigan | 26037 | 821 | 14 |
626410 | 626410 | 2020-10-13 | Clinton | Michigan | 26037 | 815 | 14 |
623168 | 623168 | 2020-10-12 | Clinton | Michigan | 26037 | 805 | 14 |
619925 | 619925 | 2020-10-11 | Clinton | Michigan | 26037 | 789 | 14 |
616683 | 616683 | 2020-10-10 | Clinton | Michigan | 26037 | 789 | 14 |
613442 | 613442 | 2020-10-09 | Clinton | Michigan | 26037 | 779 | 14 |
610200 | 610200 | 2020-10-08 | Clinton | Michigan | 26037 | 770 | 14 |
606958 | 606958 | 2020-10-07 | Clinton | Michigan | 26037 | 762 | 14 |
603715 | 603715 | 2020-10-06 | Clinton | Michigan | 26037 | 754 | 14 |
600473 | 600473 | 2020-10-05 | Clinton | Michigan | 26037 | 746 | 14 |
597230 | 597230 | 2020-10-04 | Clinton | Michigan | 26037 | 738 | 14 |
593989 | 593989 | 2020-10-03 | Clinton | Michigan | 26037 | 738 | 14 |
590748 | 590748 | 2020-10-02 | Clinton | Michigan | 26037 | 727 | 14 |
587507 | 587507 | 2020-10-01 | Clinton | Michigan | 26037 | 703 | 14 |
584267 | 584267 | 2020-09-30 | Clinton | Michigan | 26037 | 699 | 14 |
581026 | 581026 | 2020-09-29 | Clinton | Michigan | 26037 | 691 | 14 |
577785 | 577785 | 2020-09-28 | Clinton | Michigan | 26037 | 681 | 14 |
574544 | 574544 | 2020-09-27 | Clinton | Michigan | 26037 | 677 | 14 |
571301 | 571301 | 2020-09-26 | Clinton | Michigan | 26037 | 677 | 14 |
568059 | 568059 | 2020-09-25 | Clinton | Michigan | 26037 | 669 | 13 |
564819 | 564819 | 2020-09-24 | Clinton | Michigan | 26037 | 661 | 13 |
561579 | 561579 | 2020-09-23 | Clinton | Michigan | 26037 | 658 | 13 |
558342 | 558342 | 2020-09-22 | Clinton | Michigan | 26037 | 648 | 13 |
555105 | 555105 | 2020-09-21 | Clinton | Michigan | 26037 | 633 | 13 |
551867 | 551867 | 2020-09-20 | Clinton | Michigan | 26037 | 620 | 13 |
548628 | 548628 | 2020-09-19 | Clinton | Michigan | 26037 | 620 | 13 |
545390 | 545390 | 2020-09-18 | Clinton | Michigan | 26037 | 616 | 13 |
542153 | 542153 | 2020-09-17 | Clinton | Michigan | 26037 | 611 | 13 |
538917 | 538917 | 2020-09-16 | Clinton | Michigan | 26037 | 601 | 13 |
535680 | 535680 | 2020-09-15 | Clinton | Michigan | 26037 | 594 | 13 |
532445 | 532445 | 2020-09-14 | Clinton | Michigan | 26037 | 589 | 13 |
529209 | 529209 | 2020-09-13 | Clinton | Michigan | 26037 | 591 | 13 |
525973 | 525973 | 2020-09-12 | Clinton | Michigan | 26037 | 591 | 13 |
522737 | 522737 | 2020-09-11 | Clinton | Michigan | 26037 | 587 | 13 |
519500 | 519500 | 2020-09-10 | Clinton | Michigan | 26037 | 576 | 13 |
516265 | 516265 | 2020-09-09 | Clinton | Michigan | 26037 | 568 | 13 |
513031 | 513031 | 2020-09-08 | Clinton | Michigan | 26037 | 563 | 13 |
509799 | 509799 | 2020-09-07 | Clinton | Michigan | 26037 | 558 | 13 |
506566 | 506566 | 2020-09-06 | Clinton | Michigan | 26037 | 546 | 13 |
503333 | 503333 | 2020-09-05 | Clinton | Michigan | 26037 | 546 | 13 |
500099 | 500099 | 2020-09-04 | Clinton | Michigan | 26037 | 535 | 13 |
496865 | 496865 | 2020-09-03 | Clinton | Michigan | 26037 | 520 | 13 |
493632 | 493632 | 2020-09-02 | Clinton | Michigan | 26037 | 505 | 13 |
490398 | 490398 | 2020-09-01 | Clinton | Michigan | 26037 | 499 | 13 |
487165 | 487165 | 2020-08-31 | Clinton | Michigan | 26037 | 488 | 13 |
483931 | 483931 | 2020-08-30 | Clinton | Michigan | 26037 | 488 | 13 |
480696 | 480696 | 2020-08-29 | Clinton | Michigan | 26037 | 482 | 13 |
477464 | 477464 | 2020-08-28 | Clinton | Michigan | 26037 | 476 | 13 |
474231 | 474231 | 2020-08-27 | Clinton | Michigan | 26037 | 469 | 13 |
470999 | 470999 | 2020-08-26 | Clinton | Michigan | 26037 | 466 | 13 |
467769 | 467769 | 2020-08-25 | Clinton | Michigan | 26037 | 461 | 13 |
464540 | 464540 | 2020-08-24 | Clinton | Michigan | 26037 | 456 | 13 |
461309 | 461309 | 2020-08-23 | Clinton | Michigan | 26037 | 452 | 13 |
458082 | 458082 | 2020-08-22 | Clinton | Michigan | 26037 | 447 | 13 |
454854 | 454854 | 2020-08-21 | Clinton | Michigan | 26037 | 442 | 13 |
451626 | 451626 | 2020-08-20 | Clinton | Michigan | 26037 | 442 | 13 |
448398 | 448398 | 2020-08-19 | Clinton | Michigan | 26037 | 441 | 13 |
445172 | 445172 | 2020-08-18 | Clinton | Michigan | 26037 | 443 | 13 |
441946 | 441946 | 2020-08-17 | Clinton | Michigan | 26037 | 440 | 13 |
438719 | 438719 | 2020-08-16 | Clinton | Michigan | 26037 | 439 | 13 |
435494 | 435494 | 2020-08-15 | Clinton | Michigan | 26037 | 436 | 13 |
432268 | 432268 | 2020-08-14 | Clinton | Michigan | 26037 | 431 | 13 |
429041 | 429041 | 2020-08-13 | Clinton | Michigan | 26037 | 430 | 13 |
425817 | 425817 | 2020-08-12 | Clinton | Michigan | 26037 | 426 | 13 |
422595 | 422595 | 2020-08-11 | Clinton | Michigan | 26037 | 425 | 13 |
419373 | 419373 | 2020-08-10 | Clinton | Michigan | 26037 | 423 | 13 |
416152 | 416152 | 2020-08-09 | Clinton | Michigan | 26037 | 423 | 13 |
412932 | 412932 | 2020-08-08 | Clinton | Michigan | 26037 | 422 | 13 |
409712 | 409712 | 2020-08-07 | Clinton | Michigan | 26037 | 422 | 13 |
406492 | 406492 | 2020-08-06 | Clinton | Michigan | 26037 | 421 | 13 |
403274 | 403274 | 2020-08-05 | Clinton | Michigan | 26037 | 419 | 13 |
400057 | 400057 | 2020-08-04 | Clinton | Michigan | 26037 | 416 | 13 |
396843 | 396843 | 2020-08-03 | Clinton | Michigan | 26037 | 414 | 13 |
393627 | 393627 | 2020-08-02 | Clinton | Michigan | 26037 | 413 | 13 |
390410 | 390410 | 2020-08-01 | Clinton | Michigan | 26037 | 412 | 13 |
387193 | 387193 | 2020-07-31 | Clinton | Michigan | 26037 | 404 | 13 |
383975 | 383975 | 2020-07-30 | Clinton | Michigan | 26037 | 397 | 13 |
380758 | 380758 | 2020-07-29 | Clinton | Michigan | 26037 | 388 | 12 |
377541 | 377541 | 2020-07-28 | Clinton | Michigan | 26037 | 380 | 12 |
374326 | 374326 | 2020-07-27 | Clinton | Michigan | 26037 | 367 | 12 |
371114 | 371114 | 2020-07-26 | Clinton | Michigan | 26037 | 359 | 12 |
367904 | 367904 | 2020-07-25 | Clinton | Michigan | 26037 | 353 | 12 |
364697 | 364697 | 2020-07-24 | Clinton | Michigan | 26037 | 349 | 12 |
361490 | 361490 | 2020-07-23 | Clinton | Michigan | 26037 | 338 | 12 |
358285 | 358285 | 2020-07-22 | Clinton | Michigan | 26037 | 334 | 12 |
355082 | 355082 | 2020-07-21 | Clinton | Michigan | 26037 | 332 | 12 |
351880 | 351880 | 2020-07-20 | Clinton | Michigan | 26037 | 331 | 12 |
348680 | 348680 | 2020-07-19 | Clinton | Michigan | 26037 | 326 | 12 |
345479 | 345479 | 2020-07-18 | Clinton | Michigan | 26037 | 325 | 12 |
342279 | 342279 | 2020-07-17 | Clinton | Michigan | 26037 | 319 | 12 |
339083 | 339083 | 2020-07-16 | Clinton | Michigan | 26037 | 314 | 12 |
335887 | 335887 | 2020-07-15 | Clinton | Michigan | 26037 | 305 | 12 |
332694 | 332694 | 2020-07-14 | Clinton | Michigan | 26037 | 296 | 12 |
329507 | 329507 | 2020-07-13 | Clinton | Michigan | 26037 | 294 | 12 |
326321 | 326321 | 2020-07-12 | Clinton | Michigan | 26037 | 291 | 12 |
323138 | 323138 | 2020-07-11 | Clinton | Michigan | 26037 | 290 | 12 |
319959 | 319959 | 2020-07-10 | Clinton | Michigan | 26037 | 282 | 12 |
316784 | 316784 | 2020-07-09 | Clinton | Michigan | 26037 | 279 | 12 |
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);