ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 26035 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921697 | 921697 | 2021-01-12 | Clare | Michigan | 26035 | 1340 | 57 |
918452 | 918452 | 2021-01-11 | Clare | Michigan | 26035 | 1325 | 57 |
915207 | 915207 | 2021-01-10 | Clare | Michigan | 26035 | 1312 | 57 |
911962 | 911962 | 2021-01-09 | Clare | Michigan | 26035 | 1312 | 57 |
908717 | 908717 | 2021-01-08 | Clare | Michigan | 26035 | 1295 | 46 |
905471 | 905471 | 2021-01-07 | Clare | Michigan | 26035 | 1282 | 46 |
902226 | 902226 | 2021-01-06 | Clare | Michigan | 26035 | 1271 | 45 |
898981 | 898981 | 2021-01-05 | Clare | Michigan | 26035 | 1262 | 44 |
895736 | 895736 | 2021-01-04 | Clare | Michigan | 26035 | 1253 | 42 |
892489 | 892489 | 2021-01-03 | Clare | Michigan | 26035 | 1240 | 42 |
889243 | 889243 | 2021-01-02 | Clare | Michigan | 26035 | 1240 | 42 |
885997 | 885997 | 2021-01-01 | Clare | Michigan | 26035 | 1224 | 41 |
882752 | 882752 | 2020-12-31 | Clare | Michigan | 26035 | 1224 | 41 |
879507 | 879507 | 2020-12-30 | Clare | Michigan | 26035 | 1224 | 41 |
876262 | 876262 | 2020-12-29 | Clare | Michigan | 26035 | 1219 | 41 |
873017 | 873017 | 2020-12-28 | Clare | Michigan | 26035 | 1200 | 39 |
869772 | 869772 | 2020-12-27 | Clare | Michigan | 26035 | 1181 | 37 |
866527 | 866527 | 2020-12-26 | Clare | Michigan | 26035 | 1181 | 37 |
863282 | 863282 | 2020-12-25 | Clare | Michigan | 26035 | 1164 | 37 |
860037 | 860037 | 2020-12-24 | Clare | Michigan | 26035 | 1164 | 37 |
856792 | 856792 | 2020-12-23 | Clare | Michigan | 26035 | 1164 | 37 |
853547 | 853547 | 2020-12-22 | Clare | Michigan | 26035 | 1154 | 36 |
850302 | 850302 | 2020-12-21 | Clare | Michigan | 26035 | 1141 | 32 |
847057 | 847057 | 2020-12-20 | Clare | Michigan | 26035 | 1119 | 30 |
843811 | 843811 | 2020-12-19 | Clare | Michigan | 26035 | 1119 | 30 |
840566 | 840566 | 2020-12-18 | Clare | Michigan | 26035 | 1102 | 29 |
837321 | 837321 | 2020-12-17 | Clare | Michigan | 26035 | 1079 | 29 |
834075 | 834075 | 2020-12-16 | Clare | Michigan | 26035 | 1051 | 28 |
830828 | 830828 | 2020-12-15 | Clare | Michigan | 26035 | 1038 | 28 |
827582 | 827582 | 2020-12-14 | Clare | Michigan | 26035 | 1023 | 28 |
824335 | 824335 | 2020-12-13 | Clare | Michigan | 26035 | 990 | 28 |
821089 | 821089 | 2020-12-12 | Clare | Michigan | 26035 | 990 | 28 |
817843 | 817843 | 2020-12-11 | Clare | Michigan | 26035 | 982 | 27 |
814597 | 814597 | 2020-12-10 | Clare | Michigan | 26035 | 963 | 27 |
811352 | 811352 | 2020-12-09 | Clare | Michigan | 26035 | 941 | 26 |
808107 | 808107 | 2020-12-08 | Clare | Michigan | 26035 | 924 | 27 |
804862 | 804862 | 2020-12-07 | Clare | Michigan | 26035 | 901 | 27 |
801617 | 801617 | 2020-12-06 | Clare | Michigan | 26035 | 876 | 26 |
798372 | 798372 | 2020-12-05 | Clare | Michigan | 26035 | 876 | 26 |
795127 | 795127 | 2020-12-04 | Clare | Michigan | 26035 | 868 | 26 |
791882 | 791882 | 2020-12-03 | Clare | Michigan | 26035 | 843 | 26 |
788637 | 788637 | 2020-12-02 | Clare | Michigan | 26035 | 809 | 26 |
785392 | 785392 | 2020-12-01 | Clare | Michigan | 26035 | 789 | 26 |
782148 | 782148 | 2020-11-30 | Clare | Michigan | 26035 | 771 | 25 |
778902 | 778902 | 2020-11-29 | Clare | Michigan | 26035 | 745 | 25 |
775657 | 775657 | 2020-11-28 | Clare | Michigan | 26035 | 745 | 25 |
772412 | 772412 | 2020-11-27 | Clare | Michigan | 26035 | 733 | 25 |
769167 | 769167 | 2020-11-26 | Clare | Michigan | 26035 | 696 | 24 |
765921 | 765921 | 2020-11-25 | Clare | Michigan | 26035 | 696 | 24 |
762676 | 762676 | 2020-11-24 | Clare | Michigan | 26035 | 668 | 23 |
759431 | 759431 | 2020-11-23 | Clare | Michigan | 26035 | 656 | 22 |
756184 | 756184 | 2020-11-22 | Clare | Michigan | 26035 | 624 | 22 |
752938 | 752938 | 2020-11-21 | Clare | Michigan | 26035 | 624 | 22 |
749692 | 749692 | 2020-11-20 | Clare | Michigan | 26035 | 610 | 22 |
746446 | 746446 | 2020-11-19 | Clare | Michigan | 26035 | 592 | 22 |
743199 | 743199 | 2020-11-18 | Clare | Michigan | 26035 | 575 | 22 |
739952 | 739952 | 2020-11-17 | Clare | Michigan | 26035 | 564 | 22 |
736708 | 736708 | 2020-11-16 | Clare | Michigan | 26035 | 554 | 23 |
733462 | 733462 | 2020-11-15 | Clare | Michigan | 26035 | 525 | 23 |
730217 | 730217 | 2020-11-14 | Clare | Michigan | 26035 | 525 | 23 |
726974 | 726974 | 2020-11-13 | Clare | Michigan | 26035 | 497 | 20 |
723731 | 723731 | 2020-11-12 | Clare | Michigan | 26035 | 462 | 19 |
720488 | 720488 | 2020-11-11 | Clare | Michigan | 26035 | 452 | 19 |
717245 | 717245 | 2020-11-10 | Clare | Michigan | 26035 | 432 | 19 |
714001 | 714001 | 2020-11-09 | Clare | Michigan | 26035 | 424 | 18 |
710757 | 710757 | 2020-11-08 | Clare | Michigan | 26035 | 403 | 17 |
707513 | 707513 | 2020-11-07 | Clare | Michigan | 26035 | 403 | 17 |
704270 | 704270 | 2020-11-06 | Clare | Michigan | 26035 | 389 | 17 |
701028 | 701028 | 2020-11-05 | Clare | Michigan | 26035 | 383 | 17 |
697784 | 697784 | 2020-11-04 | Clare | Michigan | 26035 | 363 | 17 |
694541 | 694541 | 2020-11-03 | Clare | Michigan | 26035 | 346 | 14 |
691299 | 691299 | 2020-11-02 | Clare | Michigan | 26035 | 344 | 14 |
688054 | 688054 | 2020-11-01 | Clare | Michigan | 26035 | 319 | 14 |
684810 | 684810 | 2020-10-31 | Clare | Michigan | 26035 | 319 | 14 |
681567 | 681567 | 2020-10-30 | Clare | Michigan | 26035 | 309 | 13 |
678323 | 678323 | 2020-10-29 | Clare | Michigan | 26035 | 301 | 13 |
675081 | 675081 | 2020-10-28 | Clare | Michigan | 26035 | 291 | 11 |
671838 | 671838 | 2020-10-27 | Clare | Michigan | 26035 | 276 | 11 |
668596 | 668596 | 2020-10-26 | Clare | Michigan | 26035 | 267 | 11 |
665352 | 665352 | 2020-10-25 | Clare | Michigan | 26035 | 254 | 10 |
662107 | 662107 | 2020-10-24 | Clare | Michigan | 26035 | 254 | 10 |
658863 | 658863 | 2020-10-23 | Clare | Michigan | 26035 | 244 | 9 |
655618 | 655618 | 2020-10-22 | Clare | Michigan | 26035 | 235 | 9 |
652373 | 652373 | 2020-10-21 | Clare | Michigan | 26035 | 221 | 9 |
649128 | 649128 | 2020-10-20 | Clare | Michigan | 26035 | 219 | 8 |
645884 | 645884 | 2020-10-19 | Clare | Michigan | 26035 | 215 | 8 |
642637 | 642637 | 2020-10-18 | Clare | Michigan | 26035 | 198 | 6 |
639390 | 639390 | 2020-10-17 | Clare | Michigan | 26035 | 198 | 6 |
636144 | 636144 | 2020-10-16 | Clare | Michigan | 26035 | 198 | 6 |
632898 | 632898 | 2020-10-15 | Clare | Michigan | 26035 | 189 | 6 |
629653 | 629653 | 2020-10-14 | Clare | Michigan | 26035 | 168 | 6 |
626409 | 626409 | 2020-10-13 | Clare | Michigan | 26035 | 169 | 6 |
623167 | 623167 | 2020-10-12 | Clare | Michigan | 26035 | 152 | 6 |
619924 | 619924 | 2020-10-11 | Clare | Michigan | 26035 | 149 | 6 |
616682 | 616682 | 2020-10-10 | Clare | Michigan | 26035 | 149 | 6 |
613441 | 613441 | 2020-10-09 | Clare | Michigan | 26035 | 136 | 6 |
610199 | 610199 | 2020-10-08 | Clare | Michigan | 26035 | 128 | 6 |
606957 | 606957 | 2020-10-07 | Clare | Michigan | 26035 | 126 | 5 |
603714 | 603714 | 2020-10-06 | Clare | Michigan | 26035 | 125 | 5 |
600472 | 600472 | 2020-10-05 | Clare | Michigan | 26035 | 123 | 4 |
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);