ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2022-03-27" 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 |
---|---|---|---|---|---|---|---|
2347807 | 2347807 | 2022-03-27 | Alcona | Michigan | 26001 | 1727 | 71 |
2347808 | 2347808 | 2022-03-27 | Alger | Michigan | 26003 | 1864 | 13 |
2347809 | 2347809 | 2022-03-27 | Allegan | Michigan | 26005 | 27008 | 342 |
2347810 | 2347810 | 2022-03-27 | Alpena | Michigan | 26007 | 5584 | 135 |
2347811 | 2347811 | 2022-03-27 | Antrim | Michigan | 26009 | 4303 | 64 |
2347812 | 2347812 | 2022-03-27 | Arenac | Michigan | 26011 | 3195 | 67 |
2347813 | 2347813 | 2022-03-27 | Baraga | Michigan | 26013 | 2204 | 54 |
2347814 | 2347814 | 2022-03-27 | Barry | Michigan | 26015 | 14266 | 166 |
2347815 | 2347815 | 2022-03-27 | Bay | Michigan | 26017 | 26963 | 575 |
2347816 | 2347816 | 2022-03-27 | Benzie | Michigan | 26019 | 3420 | 65 |
2347817 | 2347817 | 2022-03-27 | Berrien | Michigan | 26021 | 34584 | 543 |
2347818 | 2347818 | 2022-03-27 | Branch | Michigan | 26023 | 12136 | 205 |
2347819 | 2347819 | 2022-03-27 | Calhoun | Michigan | 26025 | 34009 | 569 |
2347820 | 2347820 | 2022-03-27 | Cass | Michigan | 26027 | 11081 | 141 |
2347821 | 2347821 | 2022-03-27 | Charlevoix | Michigan | 26029 | 4901 | 60 |
2347822 | 2347822 | 2022-03-27 | Cheboygan | Michigan | 26031 | 4583 | 102 |
2347823 | 2347823 | 2022-03-27 | Chippewa | Michigan | 26033 | 11581 | 119 |
2347824 | 2347824 | 2022-03-27 | Clare | Michigan | 26035 | 6728 | 156 |
2347825 | 2347825 | 2022-03-27 | Clinton | Michigan | 26037 | 21139 | 207 |
2347826 | 2347826 | 2022-03-27 | Crawford | Michigan | 26039 | 2553 | 30 |
2347827 | 2347827 | 2022-03-27 | Delta | Michigan | 26041 | 9915 | 155 |
2347828 | 2347828 | 2022-03-27 | Dickinson | Michigan | 26043 | 7360 | 108 |
2347829 | 2347829 | 2022-03-27 | Eaton | Michigan | 26045 | 26689 | 393 |
2347830 | 2347830 | 2022-03-27 | Emmet | Michigan | 26047 | 6364 | 86 |
2347831 | 2347831 | 2022-03-27 | Genesee | Michigan | 26049 | 100916 | 1698 |
2347832 | 2347832 | 2022-03-27 | Gladwin | Michigan | 26051 | 5557 | 113 |
2347833 | 2347833 | 2022-03-27 | Gogebic | Michigan | 26053 | 3246 | 68 |
2347834 | 2347834 | 2022-03-27 | Grand Traverse | Michigan | 26055 | 17154 | 228 |
2347835 | 2347835 | 2022-03-27 | Gratiot | Michigan | 26057 | 13649 | 183 |
2347836 | 2347836 | 2022-03-27 | Hillsdale | Michigan | 26059 | 10314 | 204 |
2347837 | 2347837 | 2022-03-27 | Houghton | Michigan | 26061 | 7782 | 89 |
2347838 | 2347838 | 2022-03-27 | Huron | Michigan | 26063 | 7997 | 146 |
2347839 | 2347839 | 2022-03-27 | Ingham | Michigan | 26065 | 63718 | 753 |
2347840 | 2347840 | 2022-03-27 | Ionia | Michigan | 26067 | 19476 | 181 |
2347841 | 2347841 | 2022-03-27 | Iosco | Michigan | 26069 | 4798 | 139 |
2347842 | 2347842 | 2022-03-27 | Iron | Michigan | 26071 | 2643 | 87 |
2347843 | 2347843 | 2022-03-27 | Isabella | Michigan | 26073 | 15506 | 206 |
2347844 | 2347844 | 2022-03-27 | Jackson | Michigan | 26075 | 44485 | 579 |
2347845 | 2347845 | 2022-03-27 | Kalamazoo | Michigan | 26077 | 58867 | 666 |
2347846 | 2347846 | 2022-03-27 | Kalkaska | Michigan | 26079 | 3521 | 60 |
2347847 | 2347847 | 2022-03-27 | Kent | Michigan | 26081 | 166033 | 1505 |
2347848 | 2347848 | 2022-03-27 | Keweenaw | Michigan | 26083 | 510 | 13 |
2347849 | 2347849 | 2022-03-27 | Lake | Michigan | 26085 | 1838 | 37 |
2347850 | 2347850 | 2022-03-27 | Lapeer | Michigan | 26087 | 20757 | 425 |
2347851 | 2347851 | 2022-03-27 | Leelanau | Michigan | 26089 | 3567 | 52 |
2347852 | 2347852 | 2022-03-27 | Lenawee | Michigan | 26091 | 25873 | 322 |
2347853 | 2347853 | 2022-03-27 | Livingston | Michigan | 26093 | 45918 | 443 |
2347854 | 2347854 | 2022-03-27 | Luce | Michigan | 26095 | 2279 | 12 |
2347855 | 2347855 | 2022-03-27 | Mackinac | Michigan | 26097 | 2384 | 30 |
2347856 | 2347856 | 2022-03-27 | Macomb | Michigan | 26099 | 228541 | 3914 |
2347857 | 2347857 | 2022-03-27 | Manistee | Michigan | 26101 | 4451 | 88 |
2347858 | 2347858 | 2022-03-27 | Marquette | Michigan | 26103 | 15784 | 127 |
2347859 | 2347859 | 2022-03-27 | Mason | Michigan | 26105 | 6720 | 90 |
2347860 | 2347860 | 2022-03-27 | Mecosta | Michigan | 26107 | 8622 | 108 |
2347861 | 2347861 | 2022-03-27 | Menominee | Michigan | 26109 | 5614 | 69 |
2347862 | 2347862 | 2022-03-27 | Midland | Michigan | 26111 | 19003 | 223 |
2347863 | 2347863 | 2022-03-27 | Missaukee | Michigan | 26113 | 2902 | 59 |
2347864 | 2347864 | 2022-03-27 | Monroe | Michigan | 26115 | 37850 | 466 |
2347865 | 2347865 | 2022-03-27 | Montcalm | Michigan | 26117 | 17115 | 214 |
2347866 | 2347866 | 2022-03-27 | Montmorency | Michigan | 26119 | 1716 | 47 |
2347867 | 2347867 | 2022-03-27 | Muskegon | Michigan | 26121 | 41588 | 640 |
2347868 | 2347868 | 2022-03-27 | Newaygo | Michigan | 26123 | 11448 | 155 |
2347869 | 2347869 | 2022-03-27 | Oakland | Michigan | 26125 | 285014 | 3787 |
2347870 | 2347870 | 2022-03-27 | Oceana | Michigan | 26127 | 6313 | 89 |
2347871 | 2347871 | 2022-03-27 | Ogemaw | Michigan | 26129 | 4304 | 105 |
2347872 | 2347872 | 2022-03-27 | Ontonagon | Michigan | 26131 | 981 | 38 |
2347873 | 2347873 | 2022-03-27 | Osceola | Michigan | 26133 | 4980 | 80 |
2347874 | 2347874 | 2022-03-27 | Oscoda | Michigan | 26135 | 1431 | 54 |
2347875 | 2347875 | 2022-03-27 | Otsego | Michigan | 26137 | 5625 | 99 |
2347876 | 2347876 | 2022-03-27 | Ottawa | Michigan | 26139 | 74526 | 783 |
2347877 | 2347877 | 2022-03-27 | Presque Isle | Michigan | 26141 | 2063 | 57 |
2347878 | 2347878 | 2022-03-27 | Roscommon | Michigan | 26143 | 4607 | 113 |
2347879 | 2347879 | 2022-03-27 | Saginaw | Michigan | 26145 | 50254 | 940 |
2347880 | 2347880 | 2022-03-27 | Sanilac | Michigan | 26151 | 8658 | 189 |
2347881 | 2347881 | 2022-03-27 | Schoolcraft | Michigan | 26153 | 1748 | 17 |
2347882 | 2347882 | 2022-03-27 | Shiawassee | Michigan | 26155 | 17736 | 229 |
2347883 | 2347883 | 2022-03-27 | St. Clair | Michigan | 26147 | 40442 | 824 |
2347884 | 2347884 | 2022-03-27 | St. Joseph | Michigan | 26149 | 13641 | 205 |
2347885 | 2347885 | 2022-03-27 | Tuscola | Michigan | 26157 | 13197 | 275 |
2347886 | 2347886 | 2022-03-27 | Unknown | Michigan | 12034 | 37 | |
2347887 | 2347887 | 2022-03-27 | Van Buren | Michigan | 26159 | 16960 | 266 |
2347888 | 2347888 | 2022-03-27 | Washtenaw | Michigan | 26161 | 74854 | 512 |
2347889 | 2347889 | 2022-03-27 | Wayne | Michigan | 26163 | 397678 | 7862 |
2347890 | 2347890 | 2022-03-27 | Wexford | Michigan | 26165 | 7050 | 106 |
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);