ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 26099 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054798 | 1054798 | 2021-02-22 | Macomb | Michigan | 26099 | 58609 | 1954 |
1051551 | 1051551 | 2021-02-21 | Macomb | Michigan | 26099 | 58439 | 1954 |
1048304 | 1048304 | 2021-02-20 | Macomb | Michigan | 26099 | 58439 | 1954 |
1045058 | 1045058 | 2021-02-19 | Macomb | Michigan | 26099 | 58344 | 1948 |
1041813 | 1041813 | 2021-02-18 | Macomb | Michigan | 26099 | 58222 | 1947 |
1038568 | 1038568 | 2021-02-17 | Macomb | Michigan | 26099 | 58117 | 1937 |
1035323 | 1035323 | 2021-02-16 | Macomb | Michigan | 26099 | 58014 | 1937 |
1032078 | 1032078 | 2021-02-15 | Macomb | Michigan | 26099 | 57933 | 1935 |
1028831 | 1028831 | 2021-02-14 | Macomb | Michigan | 26099 | 57832 | 1935 |
1025585 | 1025585 | 2021-02-13 | Macomb | Michigan | 26099 | 57832 | 1935 |
1022340 | 1022340 | 2021-02-12 | Macomb | Michigan | 26099 | 57754 | 1923 |
1019095 | 1019095 | 2021-02-11 | Macomb | Michigan | 26099 | 57655 | 1923 |
1015850 | 1015850 | 2021-02-10 | Macomb | Michigan | 26099 | 57522 | 1914 |
1012605 | 1012605 | 2021-02-09 | Macomb | Michigan | 26099 | 57397 | 1913 |
1009360 | 1009360 | 2021-02-08 | Macomb | Michigan | 26099 | 57326 | 1908 |
1006113 | 1006113 | 2021-02-07 | Macomb | Michigan | 26099 | 57141 | 1909 |
1002867 | 1002867 | 2021-02-06 | Macomb | Michigan | 26099 | 57141 | 1909 |
999622 | 999622 | 2021-02-05 | Macomb | Michigan | 26099 | 57048 | 1897 |
996376 | 996376 | 2021-02-04 | Macomb | Michigan | 26099 | 56914 | 1896 |
993130 | 993130 | 2021-02-03 | Macomb | Michigan | 26099 | 56670 | 1879 |
989884 | 989884 | 2021-02-02 | Macomb | Michigan | 26099 | 56553 | 1873 |
986637 | 986637 | 2021-02-01 | Macomb | Michigan | 26099 | 56432 | 1867 |
983390 | 983390 | 2021-01-31 | Macomb | Michigan | 26099 | 56229 | 1865 |
980144 | 980144 | 2021-01-30 | Macomb | Michigan | 26099 | 56229 | 1865 |
976898 | 976898 | 2021-01-29 | Macomb | Michigan | 26099 | 56112 | 1845 |
973653 | 973653 | 2021-01-28 | Macomb | Michigan | 26099 | 55946 | 1847 |
970408 | 970408 | 2021-01-27 | Macomb | Michigan | 26099 | 55767 | 1836 |
967163 | 967163 | 2021-01-26 | Macomb | Michigan | 26099 | 55605 | 1834 |
963919 | 963919 | 2021-01-25 | Macomb | Michigan | 26099 | 55367 | 1825 |
960674 | 960674 | 2021-01-24 | Macomb | Michigan | 26099 | 55141 | 1822 |
957428 | 957428 | 2021-01-23 | Macomb | Michigan | 26099 | 55141 | 1822 |
954183 | 954183 | 2021-01-22 | Macomb | Michigan | 26099 | 54942 | 1797 |
950938 | 950938 | 2021-01-21 | Macomb | Michigan | 26099 | 54692 | 1795 |
947692 | 947692 | 2021-01-20 | Macomb | Michigan | 26099 | 54488 | 1778 |
944445 | 944445 | 2021-01-19 | Macomb | Michigan | 26099 | 54255 | 1774 |
941200 | 941200 | 2021-01-18 | Macomb | Michigan | 26099 | 54076 | 1772 |
937955 | 937955 | 2021-01-17 | Macomb | Michigan | 26099 | 53777 | 1772 |
934710 | 934710 | 2021-01-16 | Macomb | Michigan | 26099 | 53777 | 1772 |
931465 | 931465 | 2021-01-15 | Macomb | Michigan | 26099 | 53629 | 1756 |
928220 | 928220 | 2021-01-14 | Macomb | Michigan | 26099 | 53401 | 1753 |
924974 | 924974 | 2021-01-13 | Macomb | Michigan | 26099 | 53063 | 1734 |
921729 | 921729 | 2021-01-12 | Macomb | Michigan | 26099 | 52793 | 1734 |
918484 | 918484 | 2021-01-11 | Macomb | Michigan | 26099 | 52638 | 1721 |
915239 | 915239 | 2021-01-10 | Macomb | Michigan | 26099 | 52238 | 1716 |
911994 | 911994 | 2021-01-09 | Macomb | Michigan | 26099 | 52238 | 1716 |
908749 | 908749 | 2021-01-08 | Macomb | Michigan | 26099 | 52050 | 1683 |
905503 | 905503 | 2021-01-07 | Macomb | Michigan | 26099 | 51731 | 1681 |
902258 | 902258 | 2021-01-06 | Macomb | Michigan | 26099 | 51470 | 1663 |
899013 | 899013 | 2021-01-05 | Macomb | Michigan | 26099 | 51026 | 1661 |
895768 | 895768 | 2021-01-04 | Macomb | Michigan | 26099 | 50859 | 1641 |
892521 | 892521 | 2021-01-03 | Macomb | Michigan | 26099 | 50395 | 1637 |
889275 | 889275 | 2021-01-02 | Macomb | Michigan | 26099 | 50395 | 1637 |
886029 | 886029 | 2021-01-01 | Macomb | Michigan | 26099 | 49744 | 1606 |
882784 | 882784 | 2020-12-31 | Macomb | Michigan | 26099 | 49744 | 1606 |
879539 | 879539 | 2020-12-30 | Macomb | Michigan | 26099 | 49744 | 1606 |
876294 | 876294 | 2020-12-29 | Macomb | Michigan | 26099 | 49460 | 1603 |
873049 | 873049 | 2020-12-28 | Macomb | Michigan | 26099 | 49156 | 1580 |
869804 | 869804 | 2020-12-27 | Macomb | Michigan | 26099 | 48947 | 1579 |
866559 | 866559 | 2020-12-26 | Macomb | Michigan | 26099 | 48947 | 1579 |
863314 | 863314 | 2020-12-25 | Macomb | Michigan | 26099 | 48331 | 1548 |
860069 | 860069 | 2020-12-24 | Macomb | Michigan | 26099 | 48331 | 1548 |
856824 | 856824 | 2020-12-23 | Macomb | Michigan | 26099 | 48331 | 1548 |
853579 | 853579 | 2020-12-22 | Macomb | Michigan | 26099 | 48035 | 1541 |
850334 | 850334 | 2020-12-21 | Macomb | Michigan | 26099 | 47803 | 1523 |
847089 | 847089 | 2020-12-20 | Macomb | Michigan | 26099 | 47426 | 1520 |
843843 | 843843 | 2020-12-19 | Macomb | Michigan | 26099 | 47426 | 1520 |
840598 | 840598 | 2020-12-18 | Macomb | Michigan | 26099 | 47154 | 1482 |
837353 | 837353 | 2020-12-17 | Macomb | Michigan | 26099 | 46832 | 1479 |
834107 | 834107 | 2020-12-16 | Macomb | Michigan | 26099 | 46496 | 1455 |
830860 | 830860 | 2020-12-15 | Macomb | Michigan | 26099 | 46118 | 1454 |
827614 | 827614 | 2020-12-14 | Macomb | Michigan | 26099 | 45516 | 1431 |
824367 | 824367 | 2020-12-13 | Macomb | Michigan | 26099 | 44931 | 1423 |
821121 | 821121 | 2020-12-12 | Macomb | Michigan | 26099 | 44931 | 1423 |
817875 | 817875 | 2020-12-11 | Macomb | Michigan | 26099 | 44527 | 1397 |
814629 | 814629 | 2020-12-10 | Macomb | Michigan | 26099 | 44119 | 1394 |
811384 | 811384 | 2020-12-09 | Macomb | Michigan | 26099 | 43582 | 1367 |
808139 | 808139 | 2020-12-08 | Macomb | Michigan | 26099 | 43035 | 1361 |
804894 | 804894 | 2020-12-07 | Macomb | Michigan | 26099 | 42376 | 1342 |
801649 | 801649 | 2020-12-06 | Macomb | Michigan | 26099 | 41547 | 1341 |
798404 | 798404 | 2020-12-05 | Macomb | Michigan | 26099 | 41547 | 1341 |
795159 | 795159 | 2020-12-04 | Macomb | Michigan | 26099 | 40931 | 1324 |
791914 | 791914 | 2020-12-03 | Macomb | Michigan | 26099 | 40060 | 1318 |
788669 | 788669 | 2020-12-02 | Macomb | Michigan | 26099 | 39490 | 1300 |
785424 | 785424 | 2020-12-01 | Macomb | Michigan | 26099 | 38600 | 1296 |
782180 | 782180 | 2020-11-30 | Macomb | Michigan | 26099 | 37952 | 1283 |
778934 | 778934 | 2020-11-29 | Macomb | Michigan | 26099 | 36826 | 1272 |
775689 | 775689 | 2020-11-28 | Macomb | Michigan | 26099 | 36826 | 1272 |
772444 | 772444 | 2020-11-27 | Macomb | Michigan | 26099 | 36060 | 1258 |
769199 | 769199 | 2020-11-26 | Macomb | Michigan | 26099 | 34215 | 1241 |
765953 | 765953 | 2020-11-25 | Macomb | Michigan | 26099 | 34215 | 1241 |
762708 | 762708 | 2020-11-24 | Macomb | Michigan | 26099 | 33790 | 1237 |
759463 | 759463 | 2020-11-23 | Macomb | Michigan | 26099 | 33116 | 1222 |
756216 | 756216 | 2020-11-22 | Macomb | Michigan | 26099 | 32074 | 1218 |
752970 | 752970 | 2020-11-21 | Macomb | Michigan | 26099 | 32074 | 1218 |
749724 | 749724 | 2020-11-20 | Macomb | Michigan | 26099 | 31410 | 1208 |
746478 | 746478 | 2020-11-19 | Macomb | Michigan | 26099 | 30457 | 1198 |
743231 | 743231 | 2020-11-18 | Macomb | Michigan | 26099 | 29863 | 1181 |
739984 | 739984 | 2020-11-17 | Macomb | Michigan | 26099 | 29309 | 1179 |
736740 | 736740 | 2020-11-16 | Macomb | Michigan | 26099 | 28504 | 1172 |
733494 | 733494 | 2020-11-15 | Macomb | Michigan | 26099 | 27445 | 1171 |
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);