ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Oakland" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054811 | 1054811 | 2021-02-22 | Oakland | Michigan | 26125 | 73922 | 1977 |
1051564 | 1051564 | 2021-02-21 | Oakland | Michigan | 26125 | 73744 | 1977 |
1048317 | 1048317 | 2021-02-20 | Oakland | Michigan | 26125 | 73744 | 1977 |
1045071 | 1045071 | 2021-02-19 | Oakland | Michigan | 26125 | 73653 | 1965 |
1041826 | 1041826 | 2021-02-18 | Oakland | Michigan | 26125 | 73470 | 1965 |
1038581 | 1038581 | 2021-02-17 | Oakland | Michigan | 26125 | 73290 | 1955 |
1035336 | 1035336 | 2021-02-16 | Oakland | Michigan | 26125 | 73116 | 1955 |
1032091 | 1032091 | 2021-02-15 | Oakland | Michigan | 26125 | 72987 | 1954 |
1028844 | 1028844 | 2021-02-14 | Oakland | Michigan | 26125 | 72810 | 1953 |
1025598 | 1025598 | 2021-02-13 | Oakland | Michigan | 26125 | 72810 | 1953 |
1022353 | 1022353 | 2021-02-12 | Oakland | Michigan | 26125 | 72750 | 1944 |
1019108 | 1019108 | 2021-02-11 | Oakland | Michigan | 26125 | 72577 | 1944 |
1015863 | 1015863 | 2021-02-10 | Oakland | Michigan | 26125 | 72411 | 1933 |
1012618 | 1012618 | 2021-02-09 | Oakland | Michigan | 26125 | 72246 | 1933 |
1009373 | 1009373 | 2021-02-08 | Oakland | Michigan | 26125 | 72077 | 1926 |
1006126 | 1006126 | 2021-02-07 | Oakland | Michigan | 26125 | 71810 | 1925 |
1002880 | 1002880 | 2021-02-06 | Oakland | Michigan | 26125 | 71810 | 1925 |
999635 | 999635 | 2021-02-05 | Oakland | Michigan | 26125 | 71677 | 1916 |
996389 | 996389 | 2021-02-04 | Oakland | Michigan | 26125 | 71441 | 1914 |
993143 | 993143 | 2021-02-03 | Oakland | Michigan | 26125 | 71177 | 1907 |
989897 | 989897 | 2021-02-02 | Oakland | Michigan | 26125 | 71009 | 1906 |
986650 | 986650 | 2021-02-01 | Oakland | Michigan | 26125 | 70804 | 1898 |
983403 | 983403 | 2021-01-31 | Oakland | Michigan | 26125 | 70447 | 1898 |
980157 | 980157 | 2021-01-30 | Oakland | Michigan | 26125 | 70447 | 1898 |
976911 | 976911 | 2021-01-29 | Oakland | Michigan | 26125 | 70269 | 1889 |
973666 | 973666 | 2021-01-28 | Oakland | Michigan | 26125 | 70023 | 1891 |
970421 | 970421 | 2021-01-27 | Oakland | Michigan | 26125 | 69772 | 1878 |
967176 | 967176 | 2021-01-26 | Oakland | Michigan | 26125 | 69558 | 1877 |
963932 | 963932 | 2021-01-25 | Oakland | Michigan | 26125 | 69285 | 1869 |
960687 | 960687 | 2021-01-24 | Oakland | Michigan | 26125 | 68958 | 1866 |
957441 | 957441 | 2021-01-23 | Oakland | Michigan | 26125 | 68958 | 1866 |
954196 | 954196 | 2021-01-22 | Oakland | Michigan | 26125 | 68795 | 1836 |
950951 | 950951 | 2021-01-21 | Oakland | Michigan | 26125 | 68496 | 1838 |
947705 | 947705 | 2021-01-20 | Oakland | Michigan | 26125 | 68244 | 1816 |
944458 | 944458 | 2021-01-19 | Oakland | Michigan | 26125 | 67987 | 1814 |
941213 | 941213 | 2021-01-18 | Oakland | Michigan | 26125 | 67674 | 1812 |
937968 | 937968 | 2021-01-17 | Oakland | Michigan | 26125 | 67307 | 1809 |
934723 | 934723 | 2021-01-16 | Oakland | Michigan | 26125 | 67307 | 1809 |
931478 | 931478 | 2021-01-15 | Oakland | Michigan | 26125 | 66986 | 1792 |
928233 | 928233 | 2021-01-14 | Oakland | Michigan | 26125 | 66619 | 1787 |
924987 | 924987 | 2021-01-13 | Oakland | Michigan | 26125 | 66226 | 1764 |
921742 | 921742 | 2021-01-12 | Oakland | Michigan | 26125 | 65837 | 1763 |
918497 | 918497 | 2021-01-11 | Oakland | Michigan | 26125 | 65546 | 1751 |
915252 | 915252 | 2021-01-10 | Oakland | Michigan | 26125 | 64880 | 1754 |
912007 | 912007 | 2021-01-09 | Oakland | Michigan | 26125 | 64880 | 1754 |
908762 | 908762 | 2021-01-08 | Oakland | Michigan | 26125 | 64666 | 1717 |
905516 | 905516 | 2021-01-07 | Oakland | Michigan | 26125 | 64221 | 1715 |
902271 | 902271 | 2021-01-06 | Oakland | Michigan | 26125 | 63751 | 1680 |
899026 | 899026 | 2021-01-05 | Oakland | Michigan | 26125 | 63188 | 1677 |
895781 | 895781 | 2021-01-04 | Oakland | Michigan | 26125 | 62826 | 1661 |
892534 | 892534 | 2021-01-03 | Oakland | Michigan | 26125 | 62094 | 1659 |
889288 | 889288 | 2021-01-02 | Oakland | Michigan | 26125 | 62094 | 1659 |
886042 | 886042 | 2021-01-01 | Oakland | Michigan | 26125 | 61195 | 1636 |
882797 | 882797 | 2020-12-31 | Oakland | Michigan | 26125 | 61195 | 1636 |
879552 | 879552 | 2020-12-30 | Oakland | Michigan | 26125 | 61195 | 1636 |
876307 | 876307 | 2020-12-29 | Oakland | Michigan | 26125 | 60724 | 1632 |
873062 | 873062 | 2020-12-28 | Oakland | Michigan | 26125 | 60147 | 1606 |
869817 | 869817 | 2020-12-27 | Oakland | Michigan | 26125 | 59724 | 1604 |
866572 | 866572 | 2020-12-26 | Oakland | Michigan | 26125 | 59724 | 1604 |
863327 | 863327 | 2020-12-25 | Oakland | Michigan | 26125 | 58949 | 1572 |
860082 | 860082 | 2020-12-24 | Oakland | Michigan | 26125 | 58949 | 1572 |
856837 | 856837 | 2020-12-23 | Oakland | Michigan | 26125 | 58949 | 1572 |
853592 | 853592 | 2020-12-22 | Oakland | Michigan | 26125 | 58636 | 1564 |
850347 | 850347 | 2020-12-21 | Oakland | Michigan | 26125 | 58249 | 1546 |
847102 | 847102 | 2020-12-20 | Oakland | Michigan | 26125 | 57698 | 1543 |
843856 | 843856 | 2020-12-19 | Oakland | Michigan | 26125 | 57698 | 1543 |
840611 | 840611 | 2020-12-18 | Oakland | Michigan | 26125 | 57285 | 1514 |
837366 | 837366 | 2020-12-17 | Oakland | Michigan | 26125 | 56825 | 1511 |
834120 | 834120 | 2020-12-16 | Oakland | Michigan | 26125 | 56343 | 1495 |
830873 | 830873 | 2020-12-15 | Oakland | Michigan | 26125 | 55885 | 1490 |
827627 | 827627 | 2020-12-14 | Oakland | Michigan | 26125 | 55183 | 1478 |
824380 | 824380 | 2020-12-13 | Oakland | Michigan | 26125 | 54497 | 1476 |
821134 | 821134 | 2020-12-12 | Oakland | Michigan | 26125 | 54497 | 1476 |
817888 | 817888 | 2020-12-11 | Oakland | Michigan | 26125 | 54042 | 1463 |
814642 | 814642 | 2020-12-10 | Oakland | Michigan | 26125 | 53510 | 1462 |
811397 | 811397 | 2020-12-09 | Oakland | Michigan | 26125 | 52856 | 1440 |
808152 | 808152 | 2020-12-08 | Oakland | Michigan | 26125 | 52330 | 1437 |
804907 | 804907 | 2020-12-07 | Oakland | Michigan | 26125 | 51468 | 1415 |
801662 | 801662 | 2020-12-06 | Oakland | Michigan | 26125 | 50593 | 1414 |
798417 | 798417 | 2020-12-05 | Oakland | Michigan | 26125 | 50593 | 1414 |
795172 | 795172 | 2020-12-04 | Oakland | Michigan | 26125 | 50014 | 1398 |
791927 | 791927 | 2020-12-03 | Oakland | Michigan | 26125 | 49136 | 1395 |
788682 | 788682 | 2020-12-02 | Oakland | Michigan | 26125 | 48402 | 1375 |
785437 | 785437 | 2020-12-01 | Oakland | Michigan | 26125 | 47475 | 1367 |
782193 | 782193 | 2020-11-30 | Oakland | Michigan | 26125 | 46874 | 1364 |
778947 | 778947 | 2020-11-29 | Oakland | Michigan | 26125 | 45701 | 1358 |
775702 | 775702 | 2020-11-28 | Oakland | Michigan | 26125 | 45701 | 1358 |
772457 | 772457 | 2020-11-27 | Oakland | Michigan | 26125 | 44624 | 1344 |
769212 | 769212 | 2020-11-26 | Oakland | Michigan | 26125 | 42850 | 1332 |
765966 | 765966 | 2020-11-25 | Oakland | Michigan | 26125 | 42850 | 1332 |
762721 | 762721 | 2020-11-24 | Oakland | Michigan | 26125 | 42349 | 1322 |
759476 | 759476 | 2020-11-23 | Oakland | Michigan | 26125 | 41470 | 1311 |
756229 | 756229 | 2020-11-22 | Oakland | Michigan | 26125 | 40381 | 1310 |
752983 | 752983 | 2020-11-21 | Oakland | Michigan | 26125 | 40381 | 1310 |
749737 | 749737 | 2020-11-20 | Oakland | Michigan | 26125 | 39629 | 1302 |
746491 | 746491 | 2020-11-19 | Oakland | Michigan | 26125 | 38325 | 1299 |
743244 | 743244 | 2020-11-18 | Oakland | Michigan | 26125 | 37587 | 1287 |
739997 | 739997 | 2020-11-17 | Oakland | Michigan | 26125 | 36983 | 1285 |
736753 | 736753 | 2020-11-16 | Oakland | Michigan | 26125 | 36020 | 1283 |
733507 | 733507 | 2020-11-15 | Oakland | Michigan | 26125 | 34658 | 1282 |
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);