ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-07-02" 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 |
---|---|---|---|---|---|---|---|
1476792 | 1476792 | 2021-07-02 | Alcona | Michigan | 26001 | 739 | 33 |
1476793 | 1476793 | 2021-07-02 | Alger | Michigan | 26003 | 670 | 7 |
1476794 | 1476794 | 2021-07-02 | Allegan | Michigan | 26005 | 11191 | 161 |
1476795 | 1476795 | 2021-07-02 | Alpena | Michigan | 26007 | 2273 | 63 |
1476796 | 1476796 | 2021-07-02 | Antrim | Michigan | 26009 | 1636 | 30 |
1476797 | 1476797 | 2021-07-02 | Arenac | Michigan | 26011 | 1209 | 29 |
1476798 | 1476798 | 2021-07-02 | Baraga | Michigan | 26013 | 994 | 40 |
1476799 | 1476799 | 2021-07-02 | Barry | Michigan | 26015 | 5965 | 69 |
1476800 | 1476800 | 2021-07-02 | Bay | Michigan | 26017 | 11267 | 355 |
1476801 | 1476801 | 2021-07-02 | Benzie | Michigan | 26019 | 1284 | 36 |
1476802 | 1476802 | 2021-07-02 | Berrien | Michigan | 26021 | 15617 | 293 |
1476803 | 1476803 | 2021-07-02 | Branch | Michigan | 26023 | 5768 | 121 |
1476804 | 1476804 | 2021-07-02 | Calhoun | Michigan | 26025 | 14573 | 318 |
1476805 | 1476805 | 2021-07-02 | Cass | Michigan | 26027 | 5504 | 77 |
1476806 | 1476806 | 2021-07-02 | Charlevoix | Michigan | 26029 | 1682 | 22 |
1476807 | 1476807 | 2021-07-02 | Cheboygan | Michigan | 26031 | 1931 | 46 |
1476808 | 1476808 | 2021-07-02 | Chippewa | Michigan | 26033 | 5634 | 50 |
1476809 | 1476809 | 2021-07-02 | Clare | Michigan | 26035 | 2482 | 85 |
1476810 | 1476810 | 2021-07-02 | Clinton | Michigan | 26037 | 7659 | 93 |
1476811 | 1476811 | 2021-07-02 | Crawford | Michigan | 26039 | 995 | 14 |
1476812 | 1476812 | 2021-07-02 | Delta | Michigan | 26041 | 4057 | 95 |
1476813 | 1476813 | 2021-07-02 | Dickinson | Michigan | 26043 | 2755 | 74 |
1476814 | 1476814 | 2021-07-02 | Eaton | Michigan | 26045 | 10157 | 212 |
1476815 | 1476815 | 2021-07-02 | Emmet | Michigan | 26047 | 2384 | 43 |
1476816 | 1476816 | 2021-07-02 | Genesee | Michigan | 26049 | 41760 | 971 |
1476817 | 1476817 | 2021-07-02 | Gladwin | Michigan | 26051 | 2305 | 61 |
1476818 | 1476818 | 2021-07-02 | Gogebic | Michigan | 26053 | 1406 | 52 |
1476819 | 1476819 | 2021-07-02 | Grand Traverse | Michigan | 26055 | 6480 | 99 |
1476820 | 1476820 | 2021-07-02 | Gratiot | Michigan | 26057 | 6987 | 125 |
1476821 | 1476821 | 2021-07-02 | Hillsdale | Michigan | 26059 | 4403 | 93 |
1476822 | 1476822 | 2021-07-02 | Houghton | Michigan | 26061 | 3143 | 43 |
1476823 | 1476823 | 2021-07-02 | Huron | Michigan | 26063 | 4093 | 82 |
1476824 | 1476824 | 2021-07-02 | Ingham | Michigan | 26065 | 24913 | 392 |
1476825 | 1476825 | 2021-07-02 | Ionia | Michigan | 26067 | 9352 | 85 |
1476826 | 1476826 | 2021-07-02 | Iosco | Michigan | 26069 | 2007 | 74 |
1476827 | 1476827 | 2021-07-02 | Iron | Michigan | 26071 | 1054 | 53 |
1476828 | 1476828 | 2021-07-02 | Isabella | Michigan | 26073 | 6340 | 100 |
1476829 | 1476829 | 2021-07-02 | Jackson | Michigan | 26075 | 21058 | 324 |
1476830 | 1476830 | 2021-07-02 | Kalamazoo | Michigan | 26077 | 23198 | 402 |
1476831 | 1476831 | 2021-07-02 | Kalkaska | Michigan | 26079 | 1144 | 27 |
1476832 | 1476832 | 2021-07-02 | Kent | Michigan | 26081 | 73734 | 860 |
1476833 | 1476833 | 2021-07-02 | Keweenaw | Michigan | 26083 | 174 | 2 |
1476834 | 1476834 | 2021-07-02 | Lake | Michigan | 26085 | 638 | 16 |
1476835 | 1476835 | 2021-07-02 | Lapeer | Michigan | 26087 | 9768 | 215 |
1476836 | 1476836 | 2021-07-02 | Leelanau | Michigan | 26089 | 1243 | 19 |
1476837 | 1476837 | 2021-07-02 | Lenawee | Michigan | 26091 | 10854 | 178 |
1476838 | 1476838 | 2021-07-02 | Livingston | Michigan | 26093 | 16808 | 197 |
1476839 | 1476839 | 2021-07-02 | Luce | Michigan | 26095 | 1338 | 6 |
1476840 | 1476840 | 2021-07-02 | Mackinac | Michigan | 26097 | 714 | 3 |
1476841 | 1476841 | 2021-07-02 | Macomb | Michigan | 26099 | 100674 | 2498 |
1476842 | 1476842 | 2021-07-02 | Manistee | Michigan | 26101 | 1981 | 24 |
1476843 | 1476843 | 2021-07-02 | Marquette | Michigan | 26103 | 5940 | 65 |
1476844 | 1476844 | 2021-07-02 | Mason | Michigan | 26105 | 2140 | 37 |
1476845 | 1476845 | 2021-07-02 | Mecosta | Michigan | 26107 | 3217 | 36 |
1476846 | 1476846 | 2021-07-02 | Menominee | Michigan | 26109 | 2130 | 43 |
1476847 | 1476847 | 2021-07-02 | Midland | Michigan | 26111 | 7577 | 94 |
1476848 | 1476848 | 2021-07-02 | Missaukee | Michigan | 26113 | 1513 | 27 |
1476849 | 1476849 | 2021-07-02 | Monroe | Michigan | 26115 | 15436 | 264 |
1476850 | 1476850 | 2021-07-02 | Montcalm | Michigan | 26117 | 8211 | 120 |
1476851 | 1476851 | 2021-07-02 | Montmorency | Michigan | 26119 | 618 | 20 |
1476852 | 1476852 | 2021-07-02 | Muskegon | Michigan | 26121 | 18439 | 382 |
1476853 | 1476853 | 2021-07-02 | Newaygo | Michigan | 26123 | 4901 | 68 |
1476854 | 1476854 | 2021-07-02 | Oakland | Michigan | 26125 | 118774 | 2447 |
1476855 | 1476855 | 2021-07-02 | Oceana | Michigan | 26127 | 2769 | 60 |
1476856 | 1476856 | 2021-07-02 | Ogemaw | Michigan | 26129 | 1747 | 43 |
1476857 | 1476857 | 2021-07-02 | Ontonagon | Michigan | 26131 | 482 | 21 |
1476858 | 1476858 | 2021-07-02 | Osceola | Michigan | 26133 | 1962 | 31 |
1476859 | 1476859 | 2021-07-02 | Oscoda | Michigan | 26135 | 691 | 31 |
1476860 | 1476860 | 2021-07-02 | Otsego | Michigan | 26137 | 2363 | 41 |
1476861 | 1476861 | 2021-07-02 | Ottawa | Michigan | 26139 | 32947 | 441 |
1476862 | 1476862 | 2021-07-02 | Presque Isle | Michigan | 26141 | 1057 | 34 |
1476863 | 1476863 | 2021-07-02 | Roscommon | Michigan | 26143 | 1900 | 55 |
1476864 | 1476864 | 2021-07-02 | Saginaw | Michigan | 26145 | 22529 | 634 |
1476865 | 1476865 | 2021-07-02 | Sanilac | Michigan | 26151 | 4261 | 125 |
1476866 | 1476866 | 2021-07-02 | Schoolcraft | Michigan | 26153 | 438 | 5 |
1476867 | 1476867 | 2021-07-02 | Shiawassee | Michigan | 26155 | 6438 | 107 |
1476868 | 1476868 | 2021-07-02 | St. Clair | Michigan | 26147 | 18507 | 448 |
1476869 | 1476869 | 2021-07-02 | St. Joseph | Michigan | 26149 | 6256 | 101 |
1476870 | 1476870 | 2021-07-02 | Tuscola | Michigan | 26157 | 5668 | 174 |
1476871 | 1476871 | 2021-07-02 | Unknown | Michigan | 737 | 15 | |
1476872 | 1476872 | 2021-07-02 | Van Buren | Michigan | 26159 | 7149 | 130 |
1476873 | 1476873 | 2021-07-02 | Washtenaw | Michigan | 26161 | 27150 | 310 |
1476874 | 1476874 | 2021-07-02 | Wayne | Michigan | 26163 | 166128 | 5171 |
1476875 | 1476875 | 2021-07-02 | Wexford | Michigan | 26165 | 2903 | 48 |
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);