ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 26117 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054807 | 1054807 | 2021-02-22 | Montcalm | Michigan | 26117 | 5583 | 92 |
1051560 | 1051560 | 2021-02-21 | Montcalm | Michigan | 26117 | 5579 | 92 |
1048313 | 1048313 | 2021-02-20 | Montcalm | Michigan | 26117 | 5579 | 92 |
1045067 | 1045067 | 2021-02-19 | Montcalm | Michigan | 26117 | 5576 | 92 |
1041822 | 1041822 | 2021-02-18 | Montcalm | Michigan | 26117 | 5565 | 92 |
1038577 | 1038577 | 2021-02-17 | Montcalm | Michigan | 26117 | 5563 | 90 |
1035332 | 1035332 | 2021-02-16 | Montcalm | Michigan | 26117 | 5559 | 90 |
1032087 | 1032087 | 2021-02-15 | Montcalm | Michigan | 26117 | 5548 | 90 |
1028840 | 1028840 | 2021-02-14 | Montcalm | Michigan | 26117 | 5541 | 90 |
1025594 | 1025594 | 2021-02-13 | Montcalm | Michigan | 26117 | 5541 | 90 |
1022349 | 1022349 | 2021-02-12 | Montcalm | Michigan | 26117 | 5532 | 90 |
1019104 | 1019104 | 2021-02-11 | Montcalm | Michigan | 26117 | 5519 | 90 |
1015859 | 1015859 | 2021-02-10 | Montcalm | Michigan | 26117 | 5512 | 90 |
1012614 | 1012614 | 2021-02-09 | Montcalm | Michigan | 26117 | 5502 | 90 |
1009369 | 1009369 | 2021-02-08 | Montcalm | Michigan | 26117 | 5495 | 90 |
1006122 | 1006122 | 2021-02-07 | Montcalm | Michigan | 26117 | 5487 | 90 |
1002876 | 1002876 | 2021-02-06 | Montcalm | Michigan | 26117 | 5487 | 90 |
999631 | 999631 | 2021-02-05 | Montcalm | Michigan | 26117 | 5481 | 90 |
996385 | 996385 | 2021-02-04 | Montcalm | Michigan | 26117 | 5477 | 90 |
993139 | 993139 | 2021-02-03 | Montcalm | Michigan | 26117 | 5472 | 90 |
989893 | 989893 | 2021-02-02 | Montcalm | Michigan | 26117 | 5463 | 90 |
986646 | 986646 | 2021-02-01 | Montcalm | Michigan | 26117 | 5459 | 90 |
983399 | 983399 | 2021-01-31 | Montcalm | Michigan | 26117 | 5451 | 90 |
980153 | 980153 | 2021-01-30 | Montcalm | Michigan | 26117 | 5451 | 90 |
976907 | 976907 | 2021-01-29 | Montcalm | Michigan | 26117 | 5446 | 88 |
973662 | 973662 | 2021-01-28 | Montcalm | Michigan | 26117 | 5442 | 88 |
970417 | 970417 | 2021-01-27 | Montcalm | Michigan | 26117 | 5432 | 89 |
967172 | 967172 | 2021-01-26 | Montcalm | Michigan | 26117 | 5431 | 89 |
963928 | 963928 | 2021-01-25 | Montcalm | Michigan | 26117 | 5423 | 87 |
960683 | 960683 | 2021-01-24 | Montcalm | Michigan | 26117 | 5417 | 86 |
957437 | 957437 | 2021-01-23 | Montcalm | Michigan | 26117 | 5417 | 86 |
954192 | 954192 | 2021-01-22 | Montcalm | Michigan | 26117 | 5407 | 84 |
950947 | 950947 | 2021-01-21 | Montcalm | Michigan | 26117 | 5403 | 84 |
947701 | 947701 | 2021-01-20 | Montcalm | Michigan | 26117 | 5384 | 84 |
944454 | 944454 | 2021-01-19 | Montcalm | Michigan | 26117 | 5377 | 84 |
941209 | 941209 | 2021-01-18 | Montcalm | Michigan | 26117 | 5367 | 84 |
937964 | 937964 | 2021-01-17 | Montcalm | Michigan | 26117 | 5354 | 84 |
934719 | 934719 | 2021-01-16 | Montcalm | Michigan | 26117 | 5354 | 84 |
931474 | 931474 | 2021-01-15 | Montcalm | Michigan | 26117 | 5339 | 84 |
928229 | 928229 | 2021-01-14 | Montcalm | Michigan | 26117 | 5315 | 84 |
924983 | 924983 | 2021-01-13 | Montcalm | Michigan | 26117 | 3458 | 78 |
921738 | 921738 | 2021-01-12 | Montcalm | Michigan | 26117 | 3447 | 78 |
918493 | 918493 | 2021-01-11 | Montcalm | Michigan | 26117 | 3436 | 74 |
915248 | 915248 | 2021-01-10 | Montcalm | Michigan | 26117 | 3411 | 74 |
912003 | 912003 | 2021-01-09 | Montcalm | Michigan | 26117 | 3411 | 74 |
908758 | 908758 | 2021-01-08 | Montcalm | Michigan | 26117 | 3389 | 71 |
905512 | 905512 | 2021-01-07 | Montcalm | Michigan | 26117 | 3368 | 71 |
902267 | 902267 | 2021-01-06 | Montcalm | Michigan | 26117 | 3347 | 71 |
899022 | 899022 | 2021-01-05 | Montcalm | Michigan | 26117 | 3325 | 71 |
895777 | 895777 | 2021-01-04 | Montcalm | Michigan | 26117 | 3301 | 70 |
892530 | 892530 | 2021-01-03 | Montcalm | Michigan | 26117 | 3264 | 70 |
889284 | 889284 | 2021-01-02 | Montcalm | Michigan | 26117 | 3264 | 70 |
886038 | 886038 | 2021-01-01 | Montcalm | Michigan | 26117 | 3205 | 65 |
882793 | 882793 | 2020-12-31 | Montcalm | Michigan | 26117 | 3205 | 65 |
879548 | 879548 | 2020-12-30 | Montcalm | Michigan | 26117 | 3205 | 65 |
876303 | 876303 | 2020-12-29 | Montcalm | Michigan | 26117 | 3187 | 65 |
873058 | 873058 | 2020-12-28 | Montcalm | Michigan | 26117 | 3158 | 63 |
869813 | 869813 | 2020-12-27 | Montcalm | Michigan | 26117 | 3133 | 62 |
866568 | 866568 | 2020-12-26 | Montcalm | Michigan | 26117 | 3133 | 62 |
863323 | 863323 | 2020-12-25 | Montcalm | Michigan | 26117 | 3086 | 59 |
860078 | 860078 | 2020-12-24 | Montcalm | Michigan | 26117 | 3086 | 59 |
856833 | 856833 | 2020-12-23 | Montcalm | Michigan | 26117 | 3086 | 59 |
853588 | 853588 | 2020-12-22 | Montcalm | Michigan | 26117 | 3064 | 59 |
850343 | 850343 | 2020-12-21 | Montcalm | Michigan | 26117 | 3052 | 57 |
847098 | 847098 | 2020-12-20 | Montcalm | Michigan | 26117 | 3028 | 56 |
843852 | 843852 | 2020-12-19 | Montcalm | Michigan | 26117 | 3028 | 56 |
840607 | 840607 | 2020-12-18 | Montcalm | Michigan | 26117 | 3028 | 53 |
837362 | 837362 | 2020-12-17 | Montcalm | Michigan | 26117 | 2987 | 53 |
834116 | 834116 | 2020-12-16 | Montcalm | Michigan | 26117 | 2963 | 50 |
830869 | 830869 | 2020-12-15 | Montcalm | Michigan | 26117 | 2916 | 49 |
827623 | 827623 | 2020-12-14 | Montcalm | Michigan | 26117 | 3059 | 44 |
824376 | 824376 | 2020-12-13 | Montcalm | Michigan | 26117 | 2846 | 40 |
821130 | 821130 | 2020-12-12 | Montcalm | Michigan | 26117 | 2846 | 40 |
817884 | 817884 | 2020-12-11 | Montcalm | Michigan | 26117 | 2796 | 38 |
814638 | 814638 | 2020-12-10 | Montcalm | Michigan | 26117 | 2748 | 39 |
811393 | 811393 | 2020-12-09 | Montcalm | Michigan | 26117 | 2706 | 36 |
808148 | 808148 | 2020-12-08 | Montcalm | Michigan | 26117 | 2658 | 35 |
804903 | 804903 | 2020-12-07 | Montcalm | Michigan | 26117 | 2642 | 33 |
801658 | 801658 | 2020-12-06 | Montcalm | Michigan | 26117 | 2546 | 32 |
798413 | 798413 | 2020-12-05 | Montcalm | Michigan | 26117 | 2546 | 32 |
795168 | 795168 | 2020-12-04 | Montcalm | Michigan | 26117 | 2503 | 31 |
791923 | 791923 | 2020-12-03 | Montcalm | Michigan | 26117 | 2174 | 28 |
788678 | 788678 | 2020-12-02 | Montcalm | Michigan | 26117 | 2148 | 26 |
785433 | 785433 | 2020-12-01 | Montcalm | Michigan | 26117 | 2054 | 25 |
782189 | 782189 | 2020-11-30 | Montcalm | Michigan | 26117 | 2020 | 25 |
778943 | 778943 | 2020-11-29 | Montcalm | Michigan | 26117 | 1974 | 24 |
775698 | 775698 | 2020-11-28 | Montcalm | Michigan | 26117 | 1974 | 24 |
772453 | 772453 | 2020-11-27 | Montcalm | Michigan | 26117 | 1944 | 24 |
769208 | 769208 | 2020-11-26 | Montcalm | Michigan | 26117 | 1723 | 23 |
765962 | 765962 | 2020-11-25 | Montcalm | Michigan | 26117 | 1723 | 23 |
762717 | 762717 | 2020-11-24 | Montcalm | Michigan | 26117 | 1682 | 22 |
759472 | 759472 | 2020-11-23 | Montcalm | Michigan | 26117 | 1667 | 22 |
756225 | 756225 | 2020-11-22 | Montcalm | Michigan | 26117 | 1540 | 21 |
752979 | 752979 | 2020-11-21 | Montcalm | Michigan | 26117 | 1540 | 21 |
749733 | 749733 | 2020-11-20 | Montcalm | Michigan | 26117 | 1502 | 21 |
746487 | 746487 | 2020-11-19 | Montcalm | Michigan | 26117 | 1455 | 21 |
743240 | 743240 | 2020-11-18 | Montcalm | Michigan | 26117 | 1407 | 21 |
739993 | 739993 | 2020-11-17 | Montcalm | Michigan | 26117 | 1379 | 19 |
736749 | 736749 | 2020-11-16 | Montcalm | Michigan | 26117 | 1337 | 17 |
733503 | 733503 | 2020-11-15 | Montcalm | Michigan | 26117 | 1259 | 16 |
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);