ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-12-14" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2012852 | 2012852 | 2021-12-14 | Alcona | Michigan | 26001 | 1379 | 51 |
2012853 | 2012853 | 2021-12-14 | Alger | Michigan | 26003 | 1180 | 9 |
2012854 | 2012854 | 2021-12-14 | Allegan | Michigan | 26005 | 19328 | 246 |
2012855 | 2012855 | 2021-12-14 | Alpena | Michigan | 26007 | 4323 | 95 |
2012856 | 2012856 | 2021-12-14 | Antrim | Michigan | 26009 | 3035 | 47 |
2012857 | 2012857 | 2021-12-14 | Arenac | Michigan | 26011 | 2259 | 49 |
2012858 | 2012858 | 2021-12-14 | Baraga | Michigan | 26013 | 1610 | 47 |
2012859 | 2012859 | 2021-12-14 | Barry | Michigan | 26015 | 10266 | 119 |
2012860 | 2012860 | 2021-12-14 | Bay | Michigan | 26017 | 18373 | 454 |
2012861 | 2012861 | 2021-12-14 | Benzie | Michigan | 26019 | 2284 | 45 |
2012862 | 2012862 | 2021-12-14 | Berrien | Michigan | 26021 | 23566 | 360 |
2012863 | 2012863 | 2021-12-14 | Branch | Michigan | 26023 | 9058 | 155 |
2012864 | 2012864 | 2021-12-14 | Calhoun | Michigan | 26025 | 23670 | 430 |
2012865 | 2012865 | 2021-12-14 | Cass | Michigan | 26027 | 8547 | 108 |
2012866 | 2012866 | 2021-12-14 | Charlevoix | Michigan | 26029 | 3273 | 47 |
2012867 | 2012867 | 2021-12-14 | Cheboygan | Michigan | 26031 | 3475 | 78 |
2012868 | 2012868 | 2021-12-14 | Chippewa | Michigan | 26033 | 7937 | 78 |
2012869 | 2012869 | 2021-12-14 | Clare | Michigan | 26035 | 4887 | 123 |
2012870 | 2012870 | 2021-12-14 | Clinton | Michigan | 26037 | 13321 | 145 |
2012871 | 2012871 | 2021-12-14 | Crawford | Michigan | 26039 | 1868 | 20 |
2012872 | 2012872 | 2021-12-14 | Delta | Michigan | 26041 | 6886 | 130 |
2012873 | 2012873 | 2021-12-14 | Dickinson | Michigan | 26043 | 4878 | 91 |
2012874 | 2012874 | 2021-12-14 | Eaton | Michigan | 26045 | 17272 | 298 |
2012875 | 2012875 | 2021-12-14 | Emmet | Michigan | 26047 | 4322 | 56 |
2012876 | 2012876 | 2021-12-14 | Genesee | Michigan | 26049 | 67065 | 1239 |
2012877 | 2012877 | 2021-12-14 | Gladwin | Michigan | 26051 | 3935 | 87 |
2012878 | 2012878 | 2021-12-14 | Gogebic | Michigan | 26053 | 2238 | 59 |
2012879 | 2012879 | 2021-12-14 | Grand Traverse | Michigan | 26055 | 11669 | 161 |
2012880 | 2012880 | 2021-12-14 | Gratiot | Michigan | 26057 | 10341 | 154 |
2012881 | 2012881 | 2021-12-14 | Hillsdale | Michigan | 26059 | 7926 | 158 |
2012882 | 2012882 | 2021-12-14 | Houghton | Michigan | 26061 | 5503 | 63 |
2012883 | 2012883 | 2021-12-14 | Huron | Michigan | 26063 | 6067 | 114 |
2012884 | 2012884 | 2021-12-14 | Ingham | Michigan | 26065 | 39111 | 544 |
2012885 | 2012885 | 2021-12-14 | Ionia | Michigan | 26067 | 14617 | 136 |
2012886 | 2012886 | 2021-12-14 | Iosco | Michigan | 26069 | 3697 | 107 |
2012887 | 2012887 | 2021-12-14 | Iron | Michigan | 26071 | 1803 | 70 |
2012888 | 2012888 | 2021-12-14 | Isabella | Michigan | 26073 | 10881 | 150 |
2012889 | 2012889 | 2021-12-14 | Jackson | Michigan | 26075 | 32806 | 428 |
2012890 | 2012890 | 2021-12-14 | Kalamazoo | Michigan | 26077 | 37181 | 512 |
2012891 | 2012891 | 2021-12-14 | Kalkaska | Michigan | 26079 | 2347 | 44 |
2012892 | 2012892 | 2021-12-14 | Kent | Michigan | 26081 | 116170 | 1179 |
2012893 | 2012893 | 2021-12-14 | Keweenaw | Michigan | 26083 | 386 | 9 |
2012894 | 2012894 | 2021-12-14 | Lake | Michigan | 26085 | 1323 | 28 |
2012895 | 2012895 | 2021-12-14 | Lapeer | Michigan | 26087 | 15221 | 306 |
2012896 | 2012896 | 2021-12-14 | Leelanau | Michigan | 26089 | 2353 | 37 |
2012897 | 2012897 | 2021-12-14 | Lenawee | Michigan | 26091 | 18369 | 238 |
2012898 | 2012898 | 2021-12-14 | Livingston | Michigan | 26093 | 31002 | 321 |
2012899 | 2012899 | 2021-12-14 | Luce | Michigan | 26095 | 1817 | 6 |
2012900 | 2012900 | 2021-12-14 | Mackinac | Michigan | 26097 | 1612 | 17 |
2012901 | 2012901 | 2021-12-14 | Macomb | Michigan | 26099 | 151341 | 3012 |
2012902 | 2012902 | 2021-12-14 | Manistee | Michigan | 26101 | 3128 | 54 |
2012903 | 2012903 | 2021-12-14 | Marquette | Michigan | 26103 | 9610 | 94 |
2012904 | 2012904 | 2021-12-14 | Mason | Michigan | 26105 | 4534 | 61 |
2012905 | 2012905 | 2021-12-14 | Mecosta | Michigan | 26107 | 6128 | 76 |
2012906 | 2012906 | 2021-12-14 | Menominee | Michigan | 26109 | 4052 | 58 |
2012907 | 2012907 | 2021-12-14 | Midland | Michigan | 26111 | 12826 | 169 |
2012908 | 2012908 | 2021-12-14 | Missaukee | Michigan | 26113 | 2170 | 44 |
2012909 | 2012909 | 2021-12-14 | Monroe | Michigan | 26115 | 25413 | 345 |
2012910 | 2012910 | 2021-12-14 | Montcalm | Michigan | 26117 | 13212 | 159 |
2012911 | 2012911 | 2021-12-14 | Montmorency | Michigan | 26119 | 1309 | 39 |
2012912 | 2012912 | 2021-12-14 | Muskegon | Michigan | 26121 | 30135 | 496 |
2012913 | 2012913 | 2021-12-14 | Newaygo | Michigan | 26123 | 8439 | 118 |
2012914 | 2012914 | 2021-12-14 | Oakland | Michigan | 26125 | 181037 | 2930 |
2012915 | 2012915 | 2021-12-14 | Oceana | Michigan | 26127 | 4769 | 78 |
2012916 | 2012916 | 2021-12-14 | Ogemaw | Michigan | 26129 | 3213 | 77 |
2012917 | 2012917 | 2021-12-14 | Ontonagon | Michigan | 26131 | 711 | 25 |
2012918 | 2012918 | 2021-12-14 | Osceola | Michigan | 26133 | 3751 | 53 |
2012919 | 2012919 | 2021-12-14 | Oscoda | Michigan | 26135 | 1146 | 49 |
2012920 | 2012920 | 2021-12-14 | Otsego | Michigan | 26137 | 4164 | 73 |
2012921 | 2012921 | 2021-12-14 | Ottawa | Michigan | 26139 | 53029 | 600 |
2012922 | 2012922 | 2021-12-14 | Presque Isle | Michigan | 26141 | 1682 | 50 |
2012923 | 2012923 | 2021-12-14 | Roscommon | Michigan | 26143 | 3507 | 94 |
2012924 | 2012924 | 2021-12-14 | Saginaw | Michigan | 26145 | 35162 | 748 |
2012925 | 2012925 | 2021-12-14 | Sanilac | Michigan | 26151 | 6475 | 157 |
2012926 | 2012926 | 2021-12-14 | Schoolcraft | Michigan | 26153 | 1133 | 7 |
2012927 | 2012927 | 2021-12-14 | Shiawassee | Michigan | 26155 | 12049 | 162 |
2012928 | 2012928 | 2021-12-14 | St. Clair | Michigan | 26147 | 28745 | 591 |
2012929 | 2012929 | 2021-12-14 | St. Joseph | Michigan | 26149 | 10453 | 144 |
2012930 | 2012930 | 2021-12-14 | Tuscola | Michigan | 26157 | 9538 | 228 |
2012931 | 2012931 | 2021-12-14 | Unknown | Michigan | 1881 | 24 | |
2012932 | 2012932 | 2021-12-14 | Van Buren | Michigan | 26159 | 11979 | 193 |
2012933 | 2012933 | 2021-12-14 | Washtenaw | Michigan | 26161 | 42437 | 373 |
2012934 | 2012934 | 2021-12-14 | Wayne | Michigan | 26163 | 245830 | 6137 |
2012935 | 2012935 | 2021-12-14 | Wexford | Michigan | 26165 | 4855 | 80 |
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);