ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-12-07" 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 |
---|---|---|---|---|---|---|---|
804845 | 804845 | 2020-12-07 | Alcona | Michigan | 26001 | 273 | 7 |
804846 | 804846 | 2020-12-07 | Alger | Michigan | 26003 | 379 | 2 |
804847 | 804847 | 2020-12-07 | Allegan | Michigan | 26005 | 4624 | 40 |
804848 | 804848 | 2020-12-07 | Alpena | Michigan | 26007 | 878 | 18 |
804849 | 804849 | 2020-12-07 | Antrim | Michigan | 26009 | 501 | 6 |
804850 | 804850 | 2020-12-07 | Arenac | Michigan | 26011 | 511 | 19 |
804851 | 804851 | 2020-12-07 | Baraga | Michigan | 26013 | 573 | 24 |
804852 | 804852 | 2020-12-07 | Barry | Michigan | 26015 | 2494 | 17 |
804853 | 804853 | 2020-12-07 | Bay | Michigan | 26017 | 5129 | 120 |
804854 | 804854 | 2020-12-07 | Benzie | Michigan | 26019 | 519 | 10 |
804855 | 804855 | 2020-12-07 | Berrien | Michigan | 26021 | 7758 | 127 |
804856 | 804856 | 2020-12-07 | Branch | Michigan | 26023 | 3384 | 66 |
804857 | 804857 | 2020-12-07 | Calhoun | Michigan | 26025 | 6671 | 135 |
804858 | 804858 | 2020-12-07 | Cass | Michigan | 26027 | 2529 | 31 |
804859 | 804859 | 2020-12-07 | Charlevoix | Michigan | 26029 | 718 | 7 |
804860 | 804860 | 2020-12-07 | Cheboygan | Michigan | 26031 | 593 | 22 |
804861 | 804861 | 2020-12-07 | Chippewa | Michigan | 26033 | 2356 | 14 |
804862 | 804862 | 2020-12-07 | Clare | Michigan | 26035 | 901 | 27 |
804863 | 804863 | 2020-12-07 | Clinton | Michigan | 26037 | 3153 | 29 |
804864 | 804864 | 2020-12-07 | Crawford | Michigan | 26039 | 398 | 5 |
804865 | 804865 | 2020-12-07 | Delta | Michigan | 26041 | 2647 | 65 |
804866 | 804866 | 2020-12-07 | Dickinson | Michigan | 26043 | 1907 | 56 |
804867 | 804867 | 2020-12-07 | Eaton | Michigan | 26045 | 3689 | 56 |
804868 | 804868 | 2020-12-07 | Emmet | Michigan | 26047 | 1080 | 28 |
804869 | 804869 | 2020-12-07 | Genesee | Michigan | 26049 | 17148 | 470 |
804870 | 804870 | 2020-12-07 | Gladwin | Michigan | 26051 | 946 | 14 |
804871 | 804871 | 2020-12-07 | Gogebic | Michigan | 26053 | 876 | 24 |
804872 | 804872 | 2020-12-07 | Grand Traverse | Michigan | 26055 | 2310 | 24 |
804873 | 804873 | 2020-12-07 | Gratiot | Michigan | 26057 | 3598 | 44 |
804874 | 804874 | 2020-12-07 | Hillsdale | Michigan | 26059 | 1960 | 44 |
804875 | 804875 | 2020-12-07 | Houghton | Michigan | 26061 | 1704 | 16 |
804876 | 804876 | 2020-12-07 | Huron | Michigan | 26063 | 1035 | 16 |
804877 | 804877 | 2020-12-07 | Ingham | Michigan | 26065 | 10149 | 128 |
804878 | 804878 | 2020-12-07 | Ionia | Michigan | 26067 | 4261 | 27 |
804879 | 804879 | 2020-12-07 | Iosco | Michigan | 26069 | 892 | 30 |
804880 | 804880 | 2020-12-07 | Iron | Michigan | 26071 | 756 | 36 |
804881 | 804881 | 2020-12-07 | Isabella | Michigan | 26073 | 2782 | 26 |
804882 | 804882 | 2020-12-07 | Jackson | Michigan | 26075 | 8751 | 131 |
804883 | 804883 | 2020-12-07 | Kalamazoo | Michigan | 26077 | 10383 | 180 |
804884 | 804884 | 2020-12-07 | Kalkaska | Michigan | 26079 | 408 | 7 |
804885 | 804885 | 2020-12-07 | Kent | Michigan | 26081 | 37011 | 414 |
804886 | 804886 | 2020-12-07 | Keweenaw | Michigan | 26083 | 78 | 2 |
804887 | 804887 | 2020-12-07 | Lake | Michigan | 26085 | 230 | 6 |
804888 | 804888 | 2020-12-07 | Lapeer | Michigan | 26087 | 3355 | 71 |
804889 | 804889 | 2020-12-07 | Leelanau | Michigan | 26089 | 445 | 3 |
804890 | 804890 | 2020-12-07 | Lenawee | Michigan | 26091 | 4242 | 40 |
804891 | 804891 | 2020-12-07 | Livingston | Michigan | 26093 | 6490 | 53 |
804892 | 804892 | 2020-12-07 | Luce | Michigan | 26095 | 961 | 0 |
804893 | 804893 | 2020-12-07 | Mackinac | Michigan | 26097 | 328 | 1 |
804894 | 804894 | 2020-12-07 | Macomb | Michigan | 26099 | 42376 | 1342 |
804895 | 804895 | 2020-12-07 | Manistee | Michigan | 26101 | 465 | 9 |
804896 | 804896 | 2020-12-07 | Marquette | Michigan | 26103 | 4026 | 36 |
804897 | 804897 | 2020-12-07 | Mason | Michigan | 26105 | 707 | 12 |
804898 | 804898 | 2020-12-07 | Mecosta | Michigan | 26107 | 1386 | 12 |
804899 | 804899 | 2020-12-07 | Menominee | Michigan | 26109 | 1425 | 19 |
804900 | 804900 | 2020-12-07 | Midland | Michigan | 26111 | 3315 | 31 |
804901 | 804901 | 2020-12-07 | Missaukee | Michigan | 26113 | 336 | 6 |
804902 | 804902 | 2020-12-07 | Monroe | Michigan | 26115 | 6134 | 98 |
804903 | 804903 | 2020-12-07 | Montcalm | Michigan | 26117 | 2642 | 33 |
804904 | 804904 | 2020-12-07 | Montmorency | Michigan | 26119 | 226 | 2 |
804905 | 804905 | 2020-12-07 | Muskegon | Michigan | 26121 | 9891 | 206 |
804906 | 804906 | 2020-12-07 | Newaygo | Michigan | 26123 | 1871 | 23 |
804907 | 804907 | 2020-12-07 | Oakland | Michigan | 26125 | 51468 | 1415 |
804908 | 804908 | 2020-12-07 | Oceana | Michigan | 26127 | 1362 | 29 |
804909 | 804909 | 2020-12-07 | Ogemaw | Michigan | 26129 | 689 | 18 |
804910 | 804910 | 2020-12-07 | Ontonagon | Michigan | 26131 | 294 | 15 |
804911 | 804911 | 2020-12-07 | Osceola | Michigan | 26133 | 637 | 11 |
804912 | 804912 | 2020-12-07 | Oscoda | Michigan | 26135 | 247 | 10 |
804913 | 804913 | 2020-12-07 | Otsego | Michigan | 26137 | 846 | 19 |
804914 | 804914 | 2020-12-07 | Ottawa | Michigan | 26139 | 15650 | 184 |
804915 | 804915 | 2020-12-07 | Presque Isle | Michigan | 26141 | 362 | 4 |
804916 | 804916 | 2020-12-07 | Roscommon | Michigan | 26143 | 770 | 21 |
804917 | 804917 | 2020-12-07 | Saginaw | Michigan | 26145 | 9947 | 281 |
804918 | 804918 | 2020-12-07 | Sanilac | Michigan | 26151 | 1110 | 24 |
804919 | 804919 | 2020-12-07 | Schoolcraft | Michigan | 26153 | 194 | 2 |
804920 | 804920 | 2020-12-07 | Shiawassee | Michigan | 26155 | 2361 | 49 |
804921 | 804921 | 2020-12-07 | St. Clair | Michigan | 26147 | 5480 | 106 |
804922 | 804922 | 2020-12-07 | St. Joseph | Michigan | 26149 | 2880 | 37 |
804923 | 804923 | 2020-12-07 | Tuscola | Michigan | 26157 | 1999 | 64 |
804924 | 804924 | 2020-12-07 | Unknown | Michigan | 2374 | 11 | |
804925 | 804925 | 2020-12-07 | Van Buren | Michigan | 26159 | 3299 | 55 |
804926 | 804926 | 2020-12-07 | Washtenaw | Michigan | 26161 | 11629 | 152 |
804927 | 804927 | 2020-12-07 | Wayne | Michigan | 26163 | 71527 | 3323 |
804928 | 804928 | 2020-12-07 | Wexford | Michigan | 26165 | 772 | 18 |
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);