ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 26139 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636196 | 636196 | 2020-10-16 | Ottawa | Michigan | 26139 | 4259 | 70 |
632950 | 632950 | 2020-10-15 | Ottawa | Michigan | 26139 | 4187 | 70 |
629705 | 629705 | 2020-10-14 | Ottawa | Michigan | 26139 | 4104 | 70 |
626461 | 626461 | 2020-10-13 | Ottawa | Michigan | 26139 | 4061 | 70 |
623219 | 623219 | 2020-10-12 | Ottawa | Michigan | 26139 | 4022 | 70 |
619976 | 619976 | 2020-10-11 | Ottawa | Michigan | 26139 | 3967 | 70 |
616734 | 616734 | 2020-10-10 | Ottawa | Michigan | 26139 | 3939 | 70 |
613493 | 613493 | 2020-10-09 | Ottawa | Michigan | 26139 | 3895 | 70 |
610251 | 610251 | 2020-10-08 | Ottawa | Michigan | 26139 | 3836 | 69 |
607009 | 607009 | 2020-10-07 | Ottawa | Michigan | 26139 | 3784 | 69 |
603766 | 603766 | 2020-10-06 | Ottawa | Michigan | 26139 | 3746 | 67 |
600524 | 600524 | 2020-10-05 | Ottawa | Michigan | 26139 | 3710 | 67 |
597281 | 597281 | 2020-10-04 | Ottawa | Michigan | 26139 | 3682 | 67 |
594040 | 594040 | 2020-10-03 | Ottawa | Michigan | 26139 | 3651 | 67 |
590799 | 590799 | 2020-10-02 | Ottawa | Michigan | 26139 | 3610 | 67 |
587558 | 587558 | 2020-10-01 | Ottawa | Michigan | 26139 | 3570 | 67 |
584318 | 584318 | 2020-09-30 | Ottawa | Michigan | 26139 | 3533 | 66 |
581077 | 581077 | 2020-09-29 | Ottawa | Michigan | 26139 | 3498 | 66 |
577836 | 577836 | 2020-09-28 | Ottawa | Michigan | 26139 | 3474 | 66 |
574595 | 574595 | 2020-09-27 | Ottawa | Michigan | 26139 | 3436 | 66 |
571352 | 571352 | 2020-09-26 | Ottawa | Michigan | 26139 | 3409 | 66 |
568110 | 568110 | 2020-09-25 | Ottawa | Michigan | 26139 | 3383 | 66 |
564870 | 564870 | 2020-09-24 | Ottawa | Michigan | 26139 | 3354 | 66 |
561630 | 561630 | 2020-09-23 | Ottawa | Michigan | 26139 | 3316 | 66 |
558393 | 558393 | 2020-09-22 | Ottawa | Michigan | 26139 | 3272 | 66 |
555156 | 555156 | 2020-09-21 | Ottawa | Michigan | 26139 | 3233 | 66 |
551918 | 551918 | 2020-09-20 | Ottawa | Michigan | 26139 | 3187 | 66 |
548679 | 548679 | 2020-09-19 | Ottawa | Michigan | 26139 | 3162 | 65 |
545441 | 545441 | 2020-09-18 | Ottawa | Michigan | 26139 | 3142 | 65 |
542204 | 542204 | 2020-09-17 | Ottawa | Michigan | 26139 | 3100 | 65 |
538968 | 538968 | 2020-09-16 | Ottawa | Michigan | 26139 | 3058 | 67 |
535731 | 535731 | 2020-09-15 | Ottawa | Michigan | 26139 | 3019 | 65 |
532496 | 532496 | 2020-09-14 | Ottawa | Michigan | 26139 | 2968 | 65 |
529260 | 529260 | 2020-09-13 | Ottawa | Michigan | 26139 | 2934 | 65 |
526024 | 526024 | 2020-09-12 | Ottawa | Michigan | 26139 | 2898 | 65 |
522788 | 522788 | 2020-09-11 | Ottawa | Michigan | 26139 | 2870 | 64 |
519551 | 519551 | 2020-09-10 | Ottawa | Michigan | 26139 | 2754 | 64 |
516316 | 516316 | 2020-09-09 | Ottawa | Michigan | 26139 | 2695 | 64 |
513082 | 513082 | 2020-09-08 | Ottawa | Michigan | 26139 | 2641 | 64 |
509850 | 509850 | 2020-09-07 | Ottawa | Michigan | 26139 | 2582 | 64 |
506617 | 506617 | 2020-09-06 | Ottawa | Michigan | 26139 | 2558 | 64 |
503384 | 503384 | 2020-09-05 | Ottawa | Michigan | 26139 | 2526 | 64 |
500150 | 500150 | 2020-09-04 | Ottawa | Michigan | 26139 | 2440 | 64 |
496916 | 496916 | 2020-09-03 | Ottawa | Michigan | 26139 | 2362 | 63 |
493683 | 493683 | 2020-09-02 | Ottawa | Michigan | 26139 | 2300 | 63 |
490449 | 490449 | 2020-09-01 | Ottawa | Michigan | 26139 | 2245 | 63 |
487216 | 487216 | 2020-08-31 | Ottawa | Michigan | 26139 | 2177 | 63 |
483982 | 483982 | 2020-08-30 | Ottawa | Michigan | 26139 | 2133 | 63 |
480747 | 480747 | 2020-08-29 | Ottawa | Michigan | 26139 | 2104 | 64 |
477515 | 477515 | 2020-08-28 | Ottawa | Michigan | 26139 | 2087 | 63 |
474282 | 474282 | 2020-08-27 | Ottawa | Michigan | 26139 | 2058 | 63 |
471050 | 471050 | 2020-08-26 | Ottawa | Michigan | 26139 | 2038 | 63 |
467820 | 467820 | 2020-08-25 | Ottawa | Michigan | 26139 | 2021 | 63 |
464591 | 464591 | 2020-08-24 | Ottawa | Michigan | 26139 | 2014 | 63 |
461360 | 461360 | 2020-08-23 | Ottawa | Michigan | 26139 | 2009 | 63 |
458133 | 458133 | 2020-08-22 | Ottawa | Michigan | 26139 | 1988 | 63 |
454905 | 454905 | 2020-08-21 | Ottawa | Michigan | 26139 | 1979 | 62 |
451677 | 451677 | 2020-08-20 | Ottawa | Michigan | 26139 | 1978 | 61 |
448449 | 448449 | 2020-08-19 | Ottawa | Michigan | 26139 | 1970 | 60 |
445223 | 445223 | 2020-08-18 | Ottawa | Michigan | 26139 | 1955 | 59 |
441997 | 441997 | 2020-08-17 | Ottawa | Michigan | 26139 | 1942 | 59 |
438770 | 438770 | 2020-08-16 | Ottawa | Michigan | 26139 | 1937 | 59 |
435545 | 435545 | 2020-08-15 | Ottawa | Michigan | 26139 | 1921 | 59 |
432319 | 432319 | 2020-08-14 | Ottawa | Michigan | 26139 | 1903 | 59 |
429092 | 429092 | 2020-08-13 | Ottawa | Michigan | 26139 | 1884 | 59 |
425868 | 425868 | 2020-08-12 | Ottawa | Michigan | 26139 | 1874 | 58 |
422646 | 422646 | 2020-08-11 | Ottawa | Michigan | 26139 | 1860 | 56 |
419424 | 419424 | 2020-08-10 | Ottawa | Michigan | 26139 | 1853 | 56 |
416203 | 416203 | 2020-08-09 | Ottawa | Michigan | 26139 | 1845 | 56 |
412983 | 412983 | 2020-08-08 | Ottawa | Michigan | 26139 | 1813 | 56 |
409763 | 409763 | 2020-08-07 | Ottawa | Michigan | 26139 | 1803 | 56 |
406543 | 406543 | 2020-08-06 | Ottawa | Michigan | 26139 | 1792 | 55 |
403325 | 403325 | 2020-08-05 | Ottawa | Michigan | 26139 | 1782 | 55 |
400108 | 400108 | 2020-08-04 | Ottawa | Michigan | 26139 | 1759 | 54 |
396894 | 396894 | 2020-08-03 | Ottawa | Michigan | 26139 | 1757 | 54 |
393678 | 393678 | 2020-08-02 | Ottawa | Michigan | 26139 | 1747 | 54 |
390461 | 390461 | 2020-08-01 | Ottawa | Michigan | 26139 | 1739 | 54 |
387244 | 387244 | 2020-07-31 | Ottawa | Michigan | 26139 | 1686 | 54 |
384026 | 384026 | 2020-07-30 | Ottawa | Michigan | 26139 | 1669 | 54 |
380809 | 380809 | 2020-07-29 | Ottawa | Michigan | 26139 | 1656 | 54 |
377592 | 377592 | 2020-07-28 | Ottawa | Michigan | 26139 | 1638 | 54 |
374377 | 374377 | 2020-07-27 | Ottawa | Michigan | 26139 | 1622 | 53 |
371165 | 371165 | 2020-07-26 | Ottawa | Michigan | 26139 | 1612 | 53 |
367955 | 367955 | 2020-07-25 | Ottawa | Michigan | 26139 | 1583 | 53 |
364748 | 364748 | 2020-07-24 | Ottawa | Michigan | 26139 | 1578 | 53 |
361541 | 361541 | 2020-07-23 | Ottawa | Michigan | 26139 | 1568 | 53 |
358336 | 358336 | 2020-07-22 | Ottawa | Michigan | 26139 | 1547 | 53 |
355133 | 355133 | 2020-07-21 | Ottawa | Michigan | 26139 | 1531 | 53 |
351931 | 351931 | 2020-07-20 | Ottawa | Michigan | 26139 | 1498 | 53 |
348731 | 348731 | 2020-07-19 | Ottawa | Michigan | 26139 | 1473 | 53 |
345530 | 345530 | 2020-07-18 | Ottawa | Michigan | 26139 | 1443 | 53 |
342330 | 342330 | 2020-07-17 | Ottawa | Michigan | 26139 | 1424 | 53 |
339134 | 339134 | 2020-07-16 | Ottawa | Michigan | 26139 | 1400 | 53 |
335938 | 335938 | 2020-07-15 | Ottawa | Michigan | 26139 | 1381 | 53 |
332745 | 332745 | 2020-07-14 | Ottawa | Michigan | 26139 | 1357 | 53 |
329558 | 329558 | 2020-07-13 | Ottawa | Michigan | 26139 | 1314 | 53 |
326372 | 326372 | 2020-07-12 | Ottawa | Michigan | 26139 | 1306 | 52 |
323189 | 323189 | 2020-07-11 | Ottawa | Michigan | 26139 | 1291 | 52 |
320010 | 320010 | 2020-07-10 | Ottawa | Michigan | 26139 | 1250 | 52 |
316835 | 316835 | 2020-07-09 | Ottawa | Michigan | 26139 | 1220 | 52 |
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);