ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 26135 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921747 | 921747 | 2021-01-12 | Oscoda | Michigan | 26135 | 331 | 19 |
918502 | 918502 | 2021-01-11 | Oscoda | Michigan | 26135 | 330 | 18 |
915257 | 915257 | 2021-01-10 | Oscoda | Michigan | 26135 | 330 | 18 |
912012 | 912012 | 2021-01-09 | Oscoda | Michigan | 26135 | 330 | 18 |
908767 | 908767 | 2021-01-08 | Oscoda | Michigan | 26135 | 329 | 18 |
905521 | 905521 | 2021-01-07 | Oscoda | Michigan | 26135 | 328 | 18 |
902276 | 902276 | 2021-01-06 | Oscoda | Michigan | 26135 | 327 | 16 |
899031 | 899031 | 2021-01-05 | Oscoda | Michigan | 26135 | 325 | 16 |
895786 | 895786 | 2021-01-04 | Oscoda | Michigan | 26135 | 322 | 16 |
892539 | 892539 | 2021-01-03 | Oscoda | Michigan | 26135 | 313 | 16 |
889293 | 889293 | 2021-01-02 | Oscoda | Michigan | 26135 | 313 | 16 |
886047 | 886047 | 2021-01-01 | Oscoda | Michigan | 26135 | 308 | 15 |
882802 | 882802 | 2020-12-31 | Oscoda | Michigan | 26135 | 308 | 15 |
879557 | 879557 | 2020-12-30 | Oscoda | Michigan | 26135 | 308 | 15 |
876312 | 876312 | 2020-12-29 | Oscoda | Michigan | 26135 | 307 | 15 |
873067 | 873067 | 2020-12-28 | Oscoda | Michigan | 26135 | 301 | 14 |
869822 | 869822 | 2020-12-27 | Oscoda | Michigan | 26135 | 288 | 14 |
866577 | 866577 | 2020-12-26 | Oscoda | Michigan | 26135 | 288 | 14 |
863332 | 863332 | 2020-12-25 | Oscoda | Michigan | 26135 | 283 | 14 |
860087 | 860087 | 2020-12-24 | Oscoda | Michigan | 26135 | 283 | 14 |
856842 | 856842 | 2020-12-23 | Oscoda | Michigan | 26135 | 283 | 14 |
853597 | 853597 | 2020-12-22 | Oscoda | Michigan | 26135 | 284 | 14 |
850352 | 850352 | 2020-12-21 | Oscoda | Michigan | 26135 | 282 | 14 |
847107 | 847107 | 2020-12-20 | Oscoda | Michigan | 26135 | 279 | 14 |
843861 | 843861 | 2020-12-19 | Oscoda | Michigan | 26135 | 279 | 14 |
840616 | 840616 | 2020-12-18 | Oscoda | Michigan | 26135 | 280 | 15 |
837371 | 837371 | 2020-12-17 | Oscoda | Michigan | 26135 | 278 | 15 |
834125 | 834125 | 2020-12-16 | Oscoda | Michigan | 26135 | 278 | 14 |
830878 | 830878 | 2020-12-15 | Oscoda | Michigan | 26135 | 275 | 14 |
827632 | 827632 | 2020-12-14 | Oscoda | Michigan | 26135 | 269 | 11 |
824385 | 824385 | 2020-12-13 | Oscoda | Michigan | 26135 | 261 | 11 |
821139 | 821139 | 2020-12-12 | Oscoda | Michigan | 26135 | 261 | 11 |
817893 | 817893 | 2020-12-11 | Oscoda | Michigan | 26135 | 258 | 11 |
814647 | 814647 | 2020-12-10 | Oscoda | Michigan | 26135 | 253 | 11 |
811402 | 811402 | 2020-12-09 | Oscoda | Michigan | 26135 | 251 | 10 |
808157 | 808157 | 2020-12-08 | Oscoda | Michigan | 26135 | 251 | 10 |
804912 | 804912 | 2020-12-07 | Oscoda | Michigan | 26135 | 247 | 10 |
801667 | 801667 | 2020-12-06 | Oscoda | Michigan | 26135 | 232 | 10 |
798422 | 798422 | 2020-12-05 | Oscoda | Michigan | 26135 | 232 | 10 |
795177 | 795177 | 2020-12-04 | Oscoda | Michigan | 26135 | 222 | 10 |
791932 | 791932 | 2020-12-03 | Oscoda | Michigan | 26135 | 208 | 10 |
788687 | 788687 | 2020-12-02 | Oscoda | Michigan | 26135 | 200 | 9 |
785442 | 785442 | 2020-12-01 | Oscoda | Michigan | 26135 | 190 | 8 |
782198 | 782198 | 2020-11-30 | Oscoda | Michigan | 26135 | 178 | 4 |
778952 | 778952 | 2020-11-29 | Oscoda | Michigan | 26135 | 156 | 4 |
775707 | 775707 | 2020-11-28 | Oscoda | Michigan | 26135 | 156 | 4 |
772462 | 772462 | 2020-11-27 | Oscoda | Michigan | 26135 | 149 | 4 |
769217 | 769217 | 2020-11-26 | Oscoda | Michigan | 26135 | 140 | 3 |
765971 | 765971 | 2020-11-25 | Oscoda | Michigan | 26135 | 140 | 3 |
762726 | 762726 | 2020-11-24 | Oscoda | Michigan | 26135 | 132 | 3 |
759481 | 759481 | 2020-11-23 | Oscoda | Michigan | 26135 | 125 | 3 |
756234 | 756234 | 2020-11-22 | Oscoda | Michigan | 26135 | 118 | 2 |
752988 | 752988 | 2020-11-21 | Oscoda | Michigan | 26135 | 118 | 2 |
749742 | 749742 | 2020-11-20 | Oscoda | Michigan | 26135 | 113 | 2 |
746496 | 746496 | 2020-11-19 | Oscoda | Michigan | 26135 | 111 | 2 |
743249 | 743249 | 2020-11-18 | Oscoda | Michigan | 26135 | 107 | 2 |
740002 | 740002 | 2020-11-17 | Oscoda | Michigan | 26135 | 100 | 2 |
736758 | 736758 | 2020-11-16 | Oscoda | Michigan | 26135 | 98 | 2 |
733512 | 733512 | 2020-11-15 | Oscoda | Michigan | 26135 | 91 | 2 |
730267 | 730267 | 2020-11-14 | Oscoda | Michigan | 26135 | 91 | 2 |
727024 | 727024 | 2020-11-13 | Oscoda | Michigan | 26135 | 89 | 2 |
723781 | 723781 | 2020-11-12 | Oscoda | Michigan | 26135 | 87 | 2 |
720538 | 720538 | 2020-11-11 | Oscoda | Michigan | 26135 | 85 | 2 |
717295 | 717295 | 2020-11-10 | Oscoda | Michigan | 26135 | 83 | 2 |
714051 | 714051 | 2020-11-09 | Oscoda | Michigan | 26135 | 78 | 2 |
710807 | 710807 | 2020-11-08 | Oscoda | Michigan | 26135 | 75 | 2 |
707563 | 707563 | 2020-11-07 | Oscoda | Michigan | 26135 | 75 | 2 |
704320 | 704320 | 2020-11-06 | Oscoda | Michigan | 26135 | 71 | 2 |
701078 | 701078 | 2020-11-05 | Oscoda | Michigan | 26135 | 67 | 2 |
697834 | 697834 | 2020-11-04 | Oscoda | Michigan | 26135 | 65 | 2 |
694591 | 694591 | 2020-11-03 | Oscoda | Michigan | 26135 | 64 | 2 |
691349 | 691349 | 2020-11-02 | Oscoda | Michigan | 26135 | 62 | 2 |
688104 | 688104 | 2020-11-01 | Oscoda | Michigan | 26135 | 60 | 2 |
684860 | 684860 | 2020-10-31 | Oscoda | Michigan | 26135 | 60 | 2 |
681617 | 681617 | 2020-10-30 | Oscoda | Michigan | 26135 | 60 | 2 |
678373 | 678373 | 2020-10-29 | Oscoda | Michigan | 26135 | 57 | 2 |
675131 | 675131 | 2020-10-28 | Oscoda | Michigan | 26135 | 56 | 2 |
671888 | 671888 | 2020-10-27 | Oscoda | Michigan | 26135 | 56 | 2 |
668646 | 668646 | 2020-10-26 | Oscoda | Michigan | 26135 | 58 | 1 |
665402 | 665402 | 2020-10-25 | Oscoda | Michigan | 26135 | 55 | 1 |
662157 | 662157 | 2020-10-24 | Oscoda | Michigan | 26135 | 55 | 1 |
658913 | 658913 | 2020-10-23 | Oscoda | Michigan | 26135 | 54 | 1 |
655668 | 655668 | 2020-10-22 | Oscoda | Michigan | 26135 | 54 | 1 |
652423 | 652423 | 2020-10-21 | Oscoda | Michigan | 26135 | 54 | 1 |
649178 | 649178 | 2020-10-20 | Oscoda | Michigan | 26135 | 54 | 1 |
645934 | 645934 | 2020-10-19 | Oscoda | Michigan | 26135 | 52 | 1 |
642687 | 642687 | 2020-10-18 | Oscoda | Michigan | 26135 | 50 | 1 |
639440 | 639440 | 2020-10-17 | Oscoda | Michigan | 26135 | 50 | 1 |
636194 | 636194 | 2020-10-16 | Oscoda | Michigan | 26135 | 50 | 1 |
632948 | 632948 | 2020-10-15 | Oscoda | Michigan | 26135 | 50 | 1 |
629703 | 629703 | 2020-10-14 | Oscoda | Michigan | 26135 | 50 | 1 |
626459 | 626459 | 2020-10-13 | Oscoda | Michigan | 26135 | 50 | 1 |
623217 | 623217 | 2020-10-12 | Oscoda | Michigan | 26135 | 50 | 1 |
619974 | 619974 | 2020-10-11 | Oscoda | Michigan | 26135 | 50 | 1 |
616732 | 616732 | 2020-10-10 | Oscoda | Michigan | 26135 | 50 | 1 |
613491 | 613491 | 2020-10-09 | Oscoda | Michigan | 26135 | 50 | 1 |
610249 | 610249 | 2020-10-08 | Oscoda | Michigan | 26135 | 50 | 1 |
607007 | 607007 | 2020-10-07 | Oscoda | Michigan | 26135 | 47 | 1 |
603764 | 603764 | 2020-10-06 | Oscoda | Michigan | 26135 | 35 | 1 |
600522 | 600522 | 2020-10-05 | Oscoda | Michigan | 26135 | 32 | 1 |
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);