ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Saginaw" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636199 | 636199 | 2020-10-16 | Saginaw | Michigan | 26145 | 3342 | 148 |
632953 | 632953 | 2020-10-15 | Saginaw | Michigan | 26145 | 3316 | 148 |
629708 | 629708 | 2020-10-14 | Saginaw | Michigan | 26145 | 3280 | 148 |
626464 | 626464 | 2020-10-13 | Saginaw | Michigan | 26145 | 3253 | 147 |
623222 | 623222 | 2020-10-12 | Saginaw | Michigan | 26145 | 3212 | 144 |
619979 | 619979 | 2020-10-11 | Saginaw | Michigan | 26145 | 3187 | 144 |
616737 | 616737 | 2020-10-10 | Saginaw | Michigan | 26145 | 3187 | 144 |
613496 | 613496 | 2020-10-09 | Saginaw | Michigan | 26145 | 3176 | 143 |
610254 | 610254 | 2020-10-08 | Saginaw | Michigan | 26145 | 3154 | 143 |
607012 | 607012 | 2020-10-07 | Saginaw | Michigan | 26145 | 3129 | 143 |
603769 | 603769 | 2020-10-06 | Saginaw | Michigan | 26145 | 3115 | 143 |
600527 | 600527 | 2020-10-05 | Saginaw | Michigan | 26145 | 3098 | 141 |
597284 | 597284 | 2020-10-04 | Saginaw | Michigan | 26145 | 3074 | 141 |
594043 | 594043 | 2020-10-03 | Saginaw | Michigan | 26145 | 3074 | 141 |
590802 | 590802 | 2020-10-02 | Saginaw | Michigan | 26145 | 3049 | 141 |
587561 | 587561 | 2020-10-01 | Saginaw | Michigan | 26145 | 3035 | 140 |
584321 | 584321 | 2020-09-30 | Saginaw | Michigan | 26145 | 3007 | 140 |
581080 | 581080 | 2020-09-29 | Saginaw | Michigan | 26145 | 2995 | 140 |
577839 | 577839 | 2020-09-28 | Saginaw | Michigan | 26145 | 2975 | 139 |
574598 | 574598 | 2020-09-27 | Saginaw | Michigan | 26145 | 2936 | 139 |
571355 | 571355 | 2020-09-26 | Saginaw | Michigan | 26145 | 2936 | 139 |
568113 | 568113 | 2020-09-25 | Saginaw | Michigan | 26145 | 2925 | 139 |
564873 | 564873 | 2020-09-24 | Saginaw | Michigan | 26145 | 2906 | 139 |
561633 | 561633 | 2020-09-23 | Saginaw | Michigan | 26145 | 2898 | 139 |
558396 | 558396 | 2020-09-22 | Saginaw | Michigan | 26145 | 2886 | 139 |
555159 | 555159 | 2020-09-21 | Saginaw | Michigan | 26145 | 2880 | 140 |
551921 | 551921 | 2020-09-20 | Saginaw | Michigan | 26145 | 2867 | 138 |
548682 | 548682 | 2020-09-19 | Saginaw | Michigan | 26145 | 2867 | 138 |
545444 | 545444 | 2020-09-18 | Saginaw | Michigan | 26145 | 2855 | 138 |
542207 | 542207 | 2020-09-17 | Saginaw | Michigan | 26145 | 2850 | 138 |
538971 | 538971 | 2020-09-16 | Saginaw | Michigan | 26145 | 2825 | 138 |
535734 | 535734 | 2020-09-15 | Saginaw | Michigan | 26145 | 2809 | 137 |
532499 | 532499 | 2020-09-14 | Saginaw | Michigan | 26145 | 2805 | 136 |
529263 | 529263 | 2020-09-13 | Saginaw | Michigan | 26145 | 2761 | 134 |
526027 | 526027 | 2020-09-12 | Saginaw | Michigan | 26145 | 2761 | 134 |
522791 | 522791 | 2020-09-11 | Saginaw | Michigan | 26145 | 2747 | 133 |
519554 | 519554 | 2020-09-10 | Saginaw | Michigan | 26145 | 2725 | 133 |
516319 | 516319 | 2020-09-09 | Saginaw | Michigan | 26145 | 2696 | 133 |
513085 | 513085 | 2020-09-08 | Saginaw | Michigan | 26145 | 2683 | 133 |
509853 | 509853 | 2020-09-07 | Saginaw | Michigan | 26145 | 2668 | 133 |
506620 | 506620 | 2020-09-06 | Saginaw | Michigan | 26145 | 2642 | 133 |
503387 | 503387 | 2020-09-05 | Saginaw | Michigan | 26145 | 2642 | 133 |
500153 | 500153 | 2020-09-04 | Saginaw | Michigan | 26145 | 2627 | 132 |
496919 | 496919 | 2020-09-03 | Saginaw | Michigan | 26145 | 2588 | 132 |
493686 | 493686 | 2020-09-02 | Saginaw | Michigan | 26145 | 2562 | 132 |
490452 | 490452 | 2020-09-01 | Saginaw | Michigan | 26145 | 2543 | 132 |
487219 | 487219 | 2020-08-31 | Saginaw | Michigan | 26145 | 2532 | 133 |
483985 | 483985 | 2020-08-30 | Saginaw | Michigan | 26145 | 2510 | 133 |
480750 | 480750 | 2020-08-29 | Saginaw | Michigan | 26145 | 2499 | 133 |
477518 | 477518 | 2020-08-28 | Saginaw | Michigan | 26145 | 2483 | 131 |
474285 | 474285 | 2020-08-27 | Saginaw | Michigan | 26145 | 2453 | 131 |
471053 | 471053 | 2020-08-26 | Saginaw | Michigan | 26145 | 2433 | 130 |
467823 | 467823 | 2020-08-25 | Saginaw | Michigan | 26145 | 2411 | 130 |
464594 | 464594 | 2020-08-24 | Saginaw | Michigan | 26145 | 2391 | 130 |
461363 | 461363 | 2020-08-23 | Saginaw | Michigan | 26145 | 2362 | 130 |
458136 | 458136 | 2020-08-22 | Saginaw | Michigan | 26145 | 2345 | 130 |
454908 | 454908 | 2020-08-21 | Saginaw | Michigan | 26145 | 2268 | 129 |
451680 | 451680 | 2020-08-20 | Saginaw | Michigan | 26145 | 2268 | 129 |
448452 | 448452 | 2020-08-19 | Saginaw | Michigan | 26145 | 2237 | 129 |
445226 | 445226 | 2020-08-18 | Saginaw | Michigan | 26145 | 2215 | 128 |
442000 | 442000 | 2020-08-17 | Saginaw | Michigan | 26145 | 2192 | 128 |
438773 | 438773 | 2020-08-16 | Saginaw | Michigan | 26145 | 2182 | 128 |
435548 | 435548 | 2020-08-15 | Saginaw | Michigan | 26145 | 2162 | 128 |
432322 | 432322 | 2020-08-14 | Saginaw | Michigan | 26145 | 2156 | 128 |
429095 | 429095 | 2020-08-13 | Saginaw | Michigan | 26145 | 2119 | 128 |
425871 | 425871 | 2020-08-12 | Saginaw | Michigan | 26145 | 2075 | 128 |
422649 | 422649 | 2020-08-11 | Saginaw | Michigan | 26145 | 2058 | 128 |
419427 | 419427 | 2020-08-10 | Saginaw | Michigan | 26145 | 2036 | 130 |
416206 | 416206 | 2020-08-09 | Saginaw | Michigan | 26145 | 2014 | 131 |
412986 | 412986 | 2020-08-08 | Saginaw | Michigan | 26145 | 1990 | 131 |
409766 | 409766 | 2020-08-07 | Saginaw | Michigan | 26145 | 1957 | 130 |
406546 | 406546 | 2020-08-06 | Saginaw | Michigan | 26145 | 1938 | 130 |
403328 | 403328 | 2020-08-05 | Saginaw | Michigan | 26145 | 1912 | 129 |
400111 | 400111 | 2020-08-04 | Saginaw | Michigan | 26145 | 1887 | 129 |
396897 | 396897 | 2020-08-03 | Saginaw | Michigan | 26145 | 1859 | 129 |
393681 | 393681 | 2020-08-02 | Saginaw | Michigan | 26145 | 1849 | 129 |
390464 | 390464 | 2020-08-01 | Saginaw | Michigan | 26145 | 1840 | 129 |
387247 | 387247 | 2020-07-31 | Saginaw | Michigan | 26145 | 1826 | 129 |
384029 | 384029 | 2020-07-30 | Saginaw | Michigan | 26145 | 1811 | 129 |
380812 | 380812 | 2020-07-29 | Saginaw | Michigan | 26145 | 1796 | 126 |
377595 | 377595 | 2020-07-28 | Saginaw | Michigan | 26145 | 1782 | 125 |
374380 | 374380 | 2020-07-27 | Saginaw | Michigan | 26145 | 1759 | 124 |
371168 | 371168 | 2020-07-26 | Saginaw | Michigan | 26145 | 1742 | 124 |
367958 | 367958 | 2020-07-25 | Saginaw | Michigan | 26145 | 1695 | 124 |
364751 | 364751 | 2020-07-24 | Saginaw | Michigan | 26145 | 1688 | 124 |
361544 | 361544 | 2020-07-23 | Saginaw | Michigan | 26145 | 1659 | 124 |
358339 | 358339 | 2020-07-22 | Saginaw | Michigan | 26145 | 1621 | 125 |
355136 | 355136 | 2020-07-21 | Saginaw | Michigan | 26145 | 1606 | 125 |
351934 | 351934 | 2020-07-20 | Saginaw | Michigan | 26145 | 1588 | 125 |
348734 | 348734 | 2020-07-19 | Saginaw | Michigan | 26145 | 1567 | 125 |
345533 | 345533 | 2020-07-18 | Saginaw | Michigan | 26145 | 1556 | 125 |
342333 | 342333 | 2020-07-17 | Saginaw | Michigan | 26145 | 1515 | 125 |
339137 | 339137 | 2020-07-16 | Saginaw | Michigan | 26145 | 1488 | 125 |
335941 | 335941 | 2020-07-15 | Saginaw | Michigan | 26145 | 1460 | 125 |
332748 | 332748 | 2020-07-14 | Saginaw | Michigan | 26145 | 1435 | 125 |
329561 | 329561 | 2020-07-13 | Saginaw | Michigan | 26145 | 1421 | 125 |
326375 | 326375 | 2020-07-12 | Saginaw | Michigan | 26145 | 1404 | 124 |
323192 | 323192 | 2020-07-11 | Saginaw | Michigan | 26145 | 1395 | 124 |
320013 | 320013 | 2020-07-10 | Saginaw | Michigan | 26145 | 1375 | 124 |
316838 | 316838 | 2020-07-09 | Saginaw | Michigan | 26145 | 1364 | 124 |
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);