ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 26163 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636209 | 636209 | 2020-10-16 | Wayne | Michigan | 26163 | 37977 | 3019 |
632963 | 632963 | 2020-10-15 | Wayne | Michigan | 26163 | 37728 | 3019 |
629718 | 629718 | 2020-10-14 | Wayne | Michigan | 26163 | 37452 | 3013 |
626474 | 626474 | 2020-10-13 | Wayne | Michigan | 26163 | 37262 | 3012 |
623232 | 623232 | 2020-10-12 | Wayne | Michigan | 26163 | 37087 | 3008 |
619989 | 619989 | 2020-10-11 | Wayne | Michigan | 26163 | 36900 | 3008 |
616747 | 616747 | 2020-10-10 | Wayne | Michigan | 26163 | 36900 | 3008 |
613506 | 613506 | 2020-10-09 | Wayne | Michigan | 26163 | 36687 | 3006 |
610264 | 610264 | 2020-10-08 | Wayne | Michigan | 26163 | 36564 | 3004 |
607022 | 607022 | 2020-10-07 | Wayne | Michigan | 26163 | 36402 | 3003 |
603779 | 603779 | 2020-10-06 | Wayne | Michigan | 26163 | 36263 | 3004 |
600537 | 600537 | 2020-10-05 | Wayne | Michigan | 26163 | 36078 | 3000 |
597294 | 597294 | 2020-10-04 | Wayne | Michigan | 26163 | 35888 | 2997 |
594053 | 594053 | 2020-10-03 | Wayne | Michigan | 26163 | 35888 | 2997 |
590812 | 590812 | 2020-10-02 | Wayne | Michigan | 26163 | 35729 | 2993 |
587571 | 587571 | 2020-10-01 | Wayne | Michigan | 26163 | 35613 | 2992 |
584331 | 584331 | 2020-09-30 | Wayne | Michigan | 26163 | 35481 | 2986 |
581090 | 581090 | 2020-09-29 | Wayne | Michigan | 26163 | 35320 | 2984 |
577849 | 577849 | 2020-09-28 | Wayne | Michigan | 26163 | 35166 | 2980 |
574608 | 574608 | 2020-09-27 | Wayne | Michigan | 26163 | 35046 | 2979 |
571365 | 571365 | 2020-09-26 | Wayne | Michigan | 26163 | 35046 | 2979 |
568123 | 568123 | 2020-09-25 | Wayne | Michigan | 26163 | 34928 | 2975 |
564883 | 564883 | 2020-09-24 | Wayne | Michigan | 26163 | 34784 | 2972 |
561643 | 561643 | 2020-09-23 | Wayne | Michigan | 26163 | 34607 | 2970 |
558406 | 558406 | 2020-09-22 | Wayne | Michigan | 26163 | 34446 | 2965 |
555169 | 555169 | 2020-09-21 | Wayne | Michigan | 26163 | 34327 | 2961 |
551931 | 551931 | 2020-09-20 | Wayne | Michigan | 26163 | 34107 | 2957 |
548692 | 548692 | 2020-09-19 | Wayne | Michigan | 26163 | 34107 | 2957 |
545454 | 545454 | 2020-09-18 | Wayne | Michigan | 26163 | 34059 | 2953 |
542217 | 542217 | 2020-09-17 | Wayne | Michigan | 26163 | 33973 | 2953 |
538981 | 538981 | 2020-09-16 | Wayne | Michigan | 26163 | 33815 | 2951 |
535744 | 535744 | 2020-09-15 | Wayne | Michigan | 26163 | 33678 | 2948 |
532509 | 532509 | 2020-09-14 | Wayne | Michigan | 26163 | 33536 | 2944 |
529273 | 529273 | 2020-09-13 | Wayne | Michigan | 26163 | 33276 | 2943 |
526037 | 526037 | 2020-09-12 | Wayne | Michigan | 26163 | 33276 | 2943 |
522801 | 522801 | 2020-09-11 | Wayne | Michigan | 26163 | 33138 | 2942 |
519564 | 519564 | 2020-09-10 | Wayne | Michigan | 26163 | 32877 | 2941 |
516329 | 516329 | 2020-09-09 | Wayne | Michigan | 26163 | 32646 | 2931 |
513095 | 513095 | 2020-09-08 | Wayne | Michigan | 26163 | 32401 | 2899 |
509863 | 509863 | 2020-09-07 | Wayne | Michigan | 26163 | 32303 | 2898 |
506630 | 506630 | 2020-09-06 | Wayne | Michigan | 26163 | 31983 | 2898 |
503397 | 503397 | 2020-09-05 | Wayne | Michigan | 26163 | 31983 | 2898 |
500163 | 500163 | 2020-09-04 | Wayne | Michigan | 26163 | 31850 | 2897 |
496929 | 496929 | 2020-09-03 | Wayne | Michigan | 26163 | 31632 | 2895 |
493696 | 493696 | 2020-09-02 | Wayne | Michigan | 26163 | 31508 | 2891 |
490462 | 490462 | 2020-09-01 | Wayne | Michigan | 26163 | 31382 | 2891 |
487229 | 487229 | 2020-08-31 | Wayne | Michigan | 26163 | 31256 | 2885 |
483995 | 483995 | 2020-08-30 | Wayne | Michigan | 26163 | 31178 | 2883 |
480760 | 480760 | 2020-08-29 | Wayne | Michigan | 26163 | 31086 | 2882 |
477528 | 477528 | 2020-08-28 | Wayne | Michigan | 26163 | 30980 | 2876 |
474295 | 474295 | 2020-08-27 | Wayne | Michigan | 26163 | 30845 | 2874 |
471063 | 471063 | 2020-08-26 | Wayne | Michigan | 26163 | 30620 | 2866 |
467833 | 467833 | 2020-08-25 | Wayne | Michigan | 26163 | 30358 | 2865 |
464604 | 464604 | 2020-08-24 | Wayne | Michigan | 26163 | 30191 | 2862 |
461373 | 461373 | 2020-08-23 | Wayne | Michigan | 26163 | 30038 | 2859 |
458146 | 458146 | 2020-08-22 | Wayne | Michigan | 26163 | 29879 | 2859 |
454918 | 454918 | 2020-08-21 | Wayne | Michigan | 26163 | 29647 | 2854 |
451690 | 451690 | 2020-08-20 | Wayne | Michigan | 26163 | 29647 | 2854 |
448462 | 448462 | 2020-08-19 | Wayne | Michigan | 26163 | 29542 | 2849 |
445236 | 445236 | 2020-08-18 | Wayne | Michigan | 26163 | 29424 | 2847 |
442010 | 442010 | 2020-08-17 | Wayne | Michigan | 26163 | 29242 | 2841 |
438783 | 438783 | 2020-08-16 | Wayne | Michigan | 26163 | 29136 | 2841 |
435558 | 435558 | 2020-08-15 | Wayne | Michigan | 26163 | 29087 | 2839 |
432332 | 432332 | 2020-08-14 | Wayne | Michigan | 26163 | 28902 | 2837 |
429105 | 429105 | 2020-08-13 | Wayne | Michigan | 26163 | 28715 | 2835 |
425881 | 425881 | 2020-08-12 | Wayne | Michigan | 26163 | 28416 | 2830 |
422659 | 422659 | 2020-08-11 | Wayne | Michigan | 26163 | 28448 | 2830 |
419437 | 419437 | 2020-08-10 | Wayne | Michigan | 26163 | 28298 | 2828 |
416216 | 416216 | 2020-08-09 | Wayne | Michigan | 26163 | 28188 | 2826 |
412996 | 412996 | 2020-08-08 | Wayne | Michigan | 26163 | 28115 | 2828 |
409776 | 409776 | 2020-08-07 | Wayne | Michigan | 26163 | 27980 | 2829 |
406556 | 406556 | 2020-08-06 | Wayne | Michigan | 26163 | 27861 | 2823 |
403338 | 403338 | 2020-08-05 | Wayne | Michigan | 26163 | 27713 | 2811 |
400121 | 400121 | 2020-08-04 | Wayne | Michigan | 26163 | 27589 | 2811 |
396907 | 396907 | 2020-08-03 | Wayne | Michigan | 26163 | 27402 | 2807 |
393691 | 393691 | 2020-08-02 | Wayne | Michigan | 26163 | 27259 | 2804 |
390474 | 390474 | 2020-08-01 | Wayne | Michigan | 26163 | 27208 | 2805 |
387257 | 387257 | 2020-07-31 | Wayne | Michigan | 26163 | 27092 | 2804 |
384039 | 384039 | 2020-07-30 | Wayne | Michigan | 26163 | 26949 | 2800 |
380822 | 380822 | 2020-07-29 | Wayne | Michigan | 26163 | 26714 | 2794 |
377605 | 377605 | 2020-07-28 | Wayne | Michigan | 26163 | 26356 | 2791 |
374390 | 374390 | 2020-07-27 | Wayne | Michigan | 26163 | 26186 | 2785 |
371178 | 371178 | 2020-07-26 | Wayne | Michigan | 26163 | 26109 | 2784 |
367968 | 367968 | 2020-07-25 | Wayne | Michigan | 26163 | 25902 | 2784 |
364761 | 364761 | 2020-07-24 | Wayne | Michigan | 26163 | 25794 | 2791 |
361554 | 361554 | 2020-07-23 | Wayne | Michigan | 26163 | 25673 | 2790 |
358349 | 358349 | 2020-07-22 | Wayne | Michigan | 26163 | 25544 | 2786 |
355146 | 355146 | 2020-07-21 | Wayne | Michigan | 26163 | 25434 | 2784 |
351944 | 351944 | 2020-07-20 | Wayne | Michigan | 26163 | 25251 | 2783 |
348744 | 348744 | 2020-07-19 | Wayne | Michigan | 26163 | 25160 | 2783 |
345543 | 345543 | 2020-07-18 | Wayne | Michigan | 26163 | 25075 | 2782 |
342343 | 342343 | 2020-07-17 | Wayne | Michigan | 26163 | 24939 | 2776 |
339147 | 339147 | 2020-07-16 | Wayne | Michigan | 26163 | 24784 | 2772 |
335951 | 335951 | 2020-07-15 | Wayne | Michigan | 26163 | 24549 | 2764 |
332758 | 332758 | 2020-07-14 | Wayne | Michigan | 26163 | 24294 | 2764 |
329571 | 329571 | 2020-07-13 | Wayne | Michigan | 26163 | 24100 | 2763 |
326385 | 326385 | 2020-07-12 | Wayne | Michigan | 26163 | 24020 | 2761 |
323202 | 323202 | 2020-07-11 | Wayne | Michigan | 26163 | 23922 | 2760 |
320023 | 320023 | 2020-07-10 | Wayne | Michigan | 26163 | 23835 | 2750 |
316848 | 316848 | 2020-07-09 | Wayne | Michigan | 26163 | 23725 | 2746 |
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);