ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

84 rows where "date" is on date 2021-03-11 and state = "Michigan" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

state 1

  • Michigan · 84 ✖
Link rowid date ▲ county state fips cases deaths
1109927 1109927 2021-03-11 Alcona Michigan 26001 434 24
1109928 1109928 2021-03-11 Alger Michigan 26003 584 5
1109929 1109929 2021-03-11 Allegan Michigan 26005 7492 118
1109930 1109930 2021-03-11 Alpena Michigan 26007 1510 48
1109931 1109931 2021-03-11 Antrim Michigan 26009 1001 20
1109932 1109932 2021-03-11 Arenac Michigan 26011 769 25
1109933 1109933 2021-03-11 Baraga Michigan 26013 783 33
1109934 1109934 2021-03-11 Barry Michigan 26015 3862 48
1109935 1109935 2021-03-11 Bay Michigan 26017 7631 296
1109936 1109936 2021-03-11 Benzie Michigan 26019 939 32
1109937 1109937 2021-03-11 Berrien Michigan 26021 11870 245
1109938 1109938 2021-03-11 Branch Michigan 26023 4650 111
1109939 1109939 2021-03-11 Calhoun Michigan 26025 10036 237
1109940 1109940 2021-03-11 Cass Michigan 26027 4157 65
1109941 1109941 2021-03-11 Charlevoix Michigan 26029 1079 13
1109942 1109942 2021-03-11 Cheboygan Michigan 26031 1074 38
1109943 1109943 2021-03-11 Chippewa Michigan 26033 4899 43
1109944 1109944 2021-03-11 Clare Michigan 26035 1633 69
1109945 1109945 2021-03-11 Clinton Michigan 26037 5194 72
1109946 1109946 2021-03-11 Crawford Michigan 26039 612 5
1109947 1109947 2021-03-11 Delta Michigan 26041 3179 85
1109948 1109948 2021-03-11 Dickinson Michigan 26043 2377 70
1109949 1109949 2021-03-11 Eaton Michigan 26045 6496 156
1109950 1109950 2021-03-11 Emmet Michigan 26047 1571 39
1109951 1109951 2021-03-11 Genesee Michigan 26049 26528 760
1109952 1109952 2021-03-11 Gladwin Michigan 26051 1503 43
1109953 1109953 2021-03-11 Gogebic Michigan 26053 1294 49
1109954 1109954 2021-03-11 Grand Traverse Michigan 26055 4478 71
1109955 1109955 2021-03-11 Gratiot Michigan 26057 5697 108
1109956 1109956 2021-03-11 Hillsdale Michigan 26059 3421 77
1109957 1109957 2021-03-11 Houghton Michigan 26061 2689 40
1109958 1109958 2021-03-11 Huron Michigan 26063 2298 59
1109959 1109959 2021-03-11 Ingham Michigan 26065 16961 283
1109960 1109960 2021-03-11 Ionia Michigan 26067 7178 76
1109961 1109961 2021-03-11 Iosco Michigan 26069 1289 67
1109962 1109962 2021-03-11 Iron Michigan 26071 927 49
1109963 1109963 2021-03-11 Isabella Michigan 26073 4095 73
1109964 1109964 2021-03-11 Jackson Michigan 26075 14617 255
1109965 1109965 2021-03-11 Kalamazoo Michigan 26077 15556 323
1109966 1109966 2021-03-11 Kalkaska Michigan 26079 663 15
1109967 1109967 2021-03-11 Kent Michigan 26081 52729 724
1109968 1109968 2021-03-11 Keweenaw Michigan 26083 146 2
1109969 1109969 2021-03-11 Lake Michigan 26085 375 11
1109970 1109970 2021-03-11 Lapeer Michigan 26087 5820 131
1109971 1109971 2021-03-11 Leelanau Michigan 26089 911 15
1109972 1109972 2021-03-11 Lenawee Michigan 26091 7934 130
1109973 1109973 2021-03-11 Livingston Michigan 26093 10801 149
1109974 1109974 2021-03-11 Luce Michigan 26095 1092 2
1109975 1109975 2021-03-11 Mackinac Michigan 26097 450 3
1109976 1109976 2021-03-11 Macomb Michigan 26099 61625 1991
1109977 1109977 2021-03-11 Manistee Michigan 26101 1552 23
1109978 1109978 2021-03-11 Marquette Michigan 26103 4845 57
1109979 1109979 2021-03-11 Mason Michigan 26105 1260 26
1109980 1109980 2021-03-11 Mecosta Michigan 26107 2063 21
1109981 1109981 2021-03-11 Menominee Michigan 26109 1893 38
1109982 1109982 2021-03-11 Midland Michigan 26111 5164 66
1109983 1109983 2021-03-11 Missaukee Michigan 26113 846 18
1109984 1109984 2021-03-11 Monroe Michigan 26115 10234 205
1109985 1109985 2021-03-11 Montcalm Michigan 26117 5704 96
1109986 1109986 2021-03-11 Montmorency Michigan 26119 368 18
1109987 1109987 2021-03-11 Muskegon Michigan 26121 12793 317
1109988 1109988 2021-03-11 Newaygo Michigan 26123 3002 52
1109989 1109989 2021-03-11 Oakland Michigan 26125 76969 2022
1109990 1109990 2021-03-11 Oceana Michigan 26127 1905 50
1109991 1109991 2021-03-11 Ogemaw Michigan 26129 1126 34
1109992 1109992 2021-03-11 Ontonagon Michigan 26131 418 20
1109993 1109993 2021-03-11 Osceola Michigan 26133 1094 23
1109994 1109994 2021-03-11 Oscoda Michigan 26135 403 19
1109995 1109995 2021-03-11 Otsego Michigan 26137 1272 27
1109996 1109996 2021-03-11 Ottawa Michigan 26139 22778 358
1109997 1109997 2021-03-11 Presque Isle Michigan 26141 671 28
1109998 1109998 2021-03-11 Roscommon Michigan 26143 1216 34
1109999 1109999 2021-03-11 Saginaw Michigan 26145 16326 534
1110000 1110000 2021-03-11 Sanilac Michigan 26151 2223 77
1110001 1110001 2021-03-11 Schoolcraft Michigan 26153 264 5
1110002 1110002 2021-03-11 Shiawassee Michigan 26155 3936 83
1110003 1110003 2021-03-11 St. Clair Michigan 26147 9114 261
1110004 1110004 2021-03-11 St. Joseph Michigan 26149 4873 87
1110005 1110005 2021-03-11 Tuscola Michigan 26157 3346 139
1110006 1110006 2021-03-11 Unknown Michigan   0 13
1110007 1110007 2021-03-11 Van Buren Michigan 26159 5095 97
1110008 1110008 2021-03-11 Washtenaw Michigan 26161 19806 253
1110009 1110009 2021-03-11 Wayne Michigan 26163 105068 4187
1110010 1110010 2021-03-11 Wexford Michigan 26165 1543 21

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);