ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2022-05-09" 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 |
---|---|---|---|---|---|---|---|
2487790 | 2487790 | 2022-05-09 | Alcona | Michigan | 26001 | 1738 | 71 |
2487791 | 2487791 | 2022-05-09 | Alger | Michigan | 26003 | 1870 | 13 |
2487792 | 2487792 | 2022-05-09 | Allegan | Michigan | 26005 | 27287 | 349 |
2487793 | 2487793 | 2022-05-09 | Alpena | Michigan | 26007 | 5767 | 139 |
2487794 | 2487794 | 2022-05-09 | Antrim | Michigan | 26009 | 4413 | 65 |
2487795 | 2487795 | 2022-05-09 | Arenac | Michigan | 26011 | 3242 | 67 |
2487796 | 2487796 | 2022-05-09 | Baraga | Michigan | 26013 | 2219 | 54 |
2487797 | 2487797 | 2022-05-09 | Barry | Michigan | 26015 | 14443 | 169 |
2487798 | 2487798 | 2022-05-09 | Bay | Michigan | 26017 | 27284 | 584 |
2487799 | 2487799 | 2022-05-09 | Benzie | Michigan | 26019 | 3474 | 68 |
2487800 | 2487800 | 2022-05-09 | Berrien | Michigan | 26021 | 35114 | 557 |
2487801 | 2487801 | 2022-05-09 | Branch | Michigan | 26023 | 12211 | 206 |
2487802 | 2487802 | 2022-05-09 | Calhoun | Michigan | 26025 | 34687 | 575 |
2487803 | 2487803 | 2022-05-09 | Cass | Michigan | 26027 | 11165 | 145 |
2487804 | 2487804 | 2022-05-09 | Charlevoix | Michigan | 26029 | 4968 | 60 |
2487805 | 2487805 | 2022-05-09 | Cheboygan | Michigan | 26031 | 4667 | 103 |
2487806 | 2487806 | 2022-05-09 | Chippewa | Michigan | 26033 | 11738 | 120 |
2487807 | 2487807 | 2022-05-09 | Clare | Michigan | 26035 | 6790 | 157 |
2487808 | 2487808 | 2022-05-09 | Clinton | Michigan | 26037 | 21647 | 207 |
2487809 | 2487809 | 2022-05-09 | Crawford | Michigan | 26039 | 2596 | 31 |
2487810 | 2487810 | 2022-05-09 | Delta | Michigan | 26041 | 9984 | 157 |
2487811 | 2487811 | 2022-05-09 | Dickinson | Michigan | 26043 | 7447 | 109 |
2487812 | 2487812 | 2022-05-09 | Eaton | Michigan | 26045 | 27231 | 403 |
2487813 | 2487813 | 2022-05-09 | Emmet | Michigan | 26047 | 6502 | 87 |
2487814 | 2487814 | 2022-05-09 | Genesee | Michigan | 26049 | 102660 | 1715 |
2487815 | 2487815 | 2022-05-09 | Gladwin | Michigan | 26051 | 5608 | 114 |
2487816 | 2487816 | 2022-05-09 | Gogebic | Michigan | 26053 | 3278 | 69 |
2487817 | 2487817 | 2022-05-09 | Grand Traverse | Michigan | 26055 | 17636 | 234 |
2487818 | 2487818 | 2022-05-09 | Gratiot | Michigan | 26057 | 13780 | 192 |
2487819 | 2487819 | 2022-05-09 | Hillsdale | Michigan | 26059 | 10417 | 204 |
2487820 | 2487820 | 2022-05-09 | Houghton | Michigan | 26061 | 7922 | 92 |
2487821 | 2487821 | 2022-05-09 | Huron | Michigan | 26063 | 8078 | 145 |
2487822 | 2487822 | 2022-05-09 | Ingham | Michigan | 26065 | 65479 | 767 |
2487823 | 2487823 | 2022-05-09 | Ionia | Michigan | 26067 | 19720 | 181 |
2487824 | 2487824 | 2022-05-09 | Iosco | Michigan | 26069 | 4829 | 143 |
2487825 | 2487825 | 2022-05-09 | Iron | Michigan | 26071 | 2659 | 87 |
2487826 | 2487826 | 2022-05-09 | Isabella | Michigan | 26073 | 15730 | 210 |
2487827 | 2487827 | 2022-05-09 | Jackson | Michigan | 26075 | 45207 | 588 |
2487828 | 2487828 | 2022-05-09 | Kalamazoo | Michigan | 26077 | 60229 | 673 |
2487829 | 2487829 | 2022-05-09 | Kalkaska | Michigan | 26079 | 3582 | 61 |
2487830 | 2487830 | 2022-05-09 | Kent | Michigan | 26081 | 168797 | 1532 |
2487831 | 2487831 | 2022-05-09 | Keweenaw | Michigan | 26083 | 520 | 14 |
2487832 | 2487832 | 2022-05-09 | Lake | Michigan | 26085 | 1870 | 37 |
2487833 | 2487833 | 2022-05-09 | Lapeer | Michigan | 26087 | 20983 | 427 |
2487834 | 2487834 | 2022-05-09 | Leelanau | Michigan | 26089 | 3654 | 55 |
2487835 | 2487835 | 2022-05-09 | Lenawee | Michigan | 26091 | 26296 | 330 |
2487836 | 2487836 | 2022-05-09 | Livingston | Michigan | 26093 | 47139 | 450 |
2487837 | 2487837 | 2022-05-09 | Luce | Michigan | 26095 | 2298 | 14 |
2487838 | 2487838 | 2022-05-09 | Mackinac | Michigan | 26097 | 2439 | 31 |
2487839 | 2487839 | 2022-05-09 | Macomb | Michigan | 26099 | 235909 | 3963 |
2487840 | 2487840 | 2022-05-09 | Manistee | Michigan | 26101 | 4500 | 90 |
2487841 | 2487841 | 2022-05-09 | Marquette | Michigan | 26103 | 16088 | 131 |
2487842 | 2487842 | 2022-05-09 | Mason | Michigan | 26105 | 6823 | 96 |
2487843 | 2487843 | 2022-05-09 | Mecosta | Michigan | 26107 | 8730 | 107 |
2487844 | 2487844 | 2022-05-09 | Menominee | Michigan | 26109 | 5656 | 70 |
2487845 | 2487845 | 2022-05-09 | Midland | Michigan | 26111 | 19254 | 225 |
2487846 | 2487846 | 2022-05-09 | Missaukee | Michigan | 26113 | 2922 | 60 |
2487847 | 2487847 | 2022-05-09 | Monroe | Michigan | 26115 | 38646 | 475 |
2487848 | 2487848 | 2022-05-09 | Montcalm | Michigan | 26117 | 17268 | 216 |
2487849 | 2487849 | 2022-05-09 | Montmorency | Michigan | 26119 | 1745 | 48 |
2487850 | 2487850 | 2022-05-09 | Muskegon | Michigan | 26121 | 42236 | 649 |
2487851 | 2487851 | 2022-05-09 | Newaygo | Michigan | 26123 | 11553 | 158 |
2487852 | 2487852 | 2022-05-09 | Oakland | Michigan | 26125 | 296058 | 3845 |
2487853 | 2487853 | 2022-05-09 | Oceana | Michigan | 26127 | 6384 | 90 |
2487854 | 2487854 | 2022-05-09 | Ogemaw | Michigan | 26129 | 4343 | 106 |
2487855 | 2487855 | 2022-05-09 | Ontonagon | Michigan | 26131 | 1000 | 38 |
2487856 | 2487856 | 2022-05-09 | Osceola | Michigan | 26133 | 5035 | 80 |
2487857 | 2487857 | 2022-05-09 | Oscoda | Michigan | 26135 | 1444 | 55 |
2487858 | 2487858 | 2022-05-09 | Otsego | Michigan | 26137 | 5704 | 100 |
2487859 | 2487859 | 2022-05-09 | Ottawa | Michigan | 26139 | 75716 | 783 |
2487860 | 2487860 | 2022-05-09 | Presque Isle | Michigan | 26141 | 2072 | 58 |
2487861 | 2487861 | 2022-05-09 | Roscommon | Michigan | 26143 | 4656 | 114 |
2487862 | 2487862 | 2022-05-09 | Saginaw | Michigan | 26145 | 50871 | 954 |
2487863 | 2487863 | 2022-05-09 | Sanilac | Michigan | 26151 | 8776 | 193 |
2487864 | 2487864 | 2022-05-09 | Schoolcraft | Michigan | 26153 | 1754 | 16 |
2487865 | 2487865 | 2022-05-09 | Shiawassee | Michigan | 26155 | 17988 | 231 |
2487866 | 2487866 | 2022-05-09 | St. Clair | Michigan | 26147 | 41369 | 833 |
2487867 | 2487867 | 2022-05-09 | St. Joseph | Michigan | 26149 | 13757 | 208 |
2487868 | 2487868 | 2022-05-09 | Tuscola | Michigan | 26157 | 13270 | 277 |
2487869 | 2487869 | 2022-05-09 | Unknown | Michigan | 16871 | 79 | |
2487870 | 2487870 | 2022-05-09 | Van Buren | Michigan | 26159 | 17239 | 273 |
2487871 | 2487871 | 2022-05-09 | Washtenaw | Michigan | 26161 | 81889 | 520 |
2487872 | 2487872 | 2022-05-09 | Wayne | Michigan | 26163 | 410946 | 7955 |
2487873 | 2487873 | 2022-05-09 | Wexford | Michigan | 26165 | 7125 | 107 |
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);