ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Clinton" and state = "Michigan" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4744 | 4744 | 2020-03-19 | Clinton | Michigan | 26037 | 1 | 0 |
5563 | 5563 | 2020-03-20 | Clinton | Michigan | 26037 | 1 | 0 |
6528 | 6528 | 2020-03-21 | Clinton | Michigan | 26037 | 2 | 0 |
7605 | 7605 | 2020-03-22 | Clinton | Michigan | 26037 | 2 | 0 |
8778 | 8778 | 2020-03-23 | Clinton | Michigan | 26037 | 2 | 0 |
10067 | 10067 | 2020-03-24 | Clinton | Michigan | 26037 | 5 | 0 |
11479 | 11479 | 2020-03-25 | Clinton | Michigan | 26037 | 6 | 0 |
13060 | 13060 | 2020-03-26 | Clinton | Michigan | 26037 | 7 | 0 |
14769 | 14769 | 2020-03-27 | Clinton | Michigan | 26037 | 8 | 0 |
16589 | 16589 | 2020-03-28 | Clinton | Michigan | 26037 | 13 | 0 |
18505 | 18505 | 2020-03-29 | Clinton | Michigan | 26037 | 14 | 0 |
20522 | 20522 | 2020-03-30 | Clinton | Michigan | 26037 | 19 | 0 |
22633 | 22633 | 2020-03-31 | Clinton | Michigan | 26037 | 24 | 0 |
24812 | 24812 | 2020-04-01 | Clinton | Michigan | 26037 | 33 | 0 |
27064 | 27064 | 2020-04-02 | Clinton | Michigan | 26037 | 43 | 1 |
29382 | 29382 | 2020-04-03 | Clinton | Michigan | 26037 | 49 | 1 |
31760 | 31760 | 2020-04-04 | Clinton | Michigan | 26037 | 54 | 1 |
34185 | 34185 | 2020-04-05 | Clinton | Michigan | 26037 | 55 | 1 |
36644 | 36644 | 2020-04-06 | Clinton | Michigan | 26037 | 56 | 1 |
39152 | 39152 | 2020-04-07 | Clinton | Michigan | 26037 | 73 | 1 |
41704 | 41704 | 2020-04-08 | Clinton | Michigan | 26037 | 82 | 1 |
44280 | 44280 | 2020-04-09 | Clinton | Michigan | 26037 | 85 | 1 |
46888 | 46888 | 2020-04-10 | Clinton | Michigan | 26037 | 90 | 3 |
49531 | 49531 | 2020-04-11 | Clinton | Michigan | 26037 | 90 | 3 |
52201 | 52201 | 2020-04-12 | Clinton | Michigan | 26037 | 91 | 3 |
54882 | 54882 | 2020-04-13 | Clinton | Michigan | 26037 | 93 | 4 |
57580 | 57580 | 2020-04-14 | Clinton | Michigan | 26037 | 98 | 4 |
60290 | 60290 | 2020-04-15 | Clinton | Michigan | 26037 | 100 | 5 |
63012 | 63012 | 2020-04-16 | Clinton | Michigan | 26037 | 102 | 6 |
65750 | 65750 | 2020-04-17 | Clinton | Michigan | 26037 | 103 | 6 |
68501 | 68501 | 2020-04-18 | Clinton | Michigan | 26037 | 103 | 6 |
71265 | 71265 | 2020-04-19 | Clinton | Michigan | 26037 | 103 | 6 |
74037 | 74037 | 2020-04-20 | Clinton | Michigan | 26037 | 104 | 7 |
76817 | 76817 | 2020-04-21 | Clinton | Michigan | 26037 | 105 | 7 |
79603 | 79603 | 2020-04-22 | Clinton | Michigan | 26037 | 106 | 7 |
82398 | 82398 | 2020-04-23 | Clinton | Michigan | 26037 | 105 | 8 |
85202 | 85202 | 2020-04-24 | Clinton | Michigan | 26037 | 106 | 9 |
88012 | 88012 | 2020-04-25 | Clinton | Michigan | 26037 | 106 | 9 |
90828 | 90828 | 2020-04-26 | Clinton | Michigan | 26037 | 109 | 9 |
93649 | 93649 | 2020-04-27 | Clinton | Michigan | 26037 | 112 | 9 |
96484 | 96484 | 2020-04-28 | Clinton | Michigan | 26037 | 114 | 9 |
99330 | 99330 | 2020-04-29 | Clinton | Michigan | 26037 | 117 | 9 |
102182 | 102182 | 2020-04-30 | Clinton | Michigan | 26037 | 118 | 9 |
105042 | 105042 | 2020-05-01 | Clinton | Michigan | 26037 | 118 | 9 |
107906 | 107906 | 2020-05-02 | Clinton | Michigan | 26037 | 118 | 10 |
110778 | 110778 | 2020-05-03 | Clinton | Michigan | 26037 | 118 | 10 |
113656 | 113656 | 2020-05-04 | Clinton | Michigan | 26037 | 119 | 10 |
116537 | 116537 | 2020-05-05 | Clinton | Michigan | 26037 | 120 | 10 |
119498 | 119498 | 2020-05-06 | Clinton | Michigan | 26037 | 123 | 10 |
122470 | 122470 | 2020-05-07 | Clinton | Michigan | 26037 | 126 | 10 |
125452 | 125452 | 2020-05-08 | Clinton | Michigan | 26037 | 126 | 10 |
128439 | 128439 | 2020-05-09 | Clinton | Michigan | 26037 | 127 | 10 |
131429 | 131429 | 2020-05-10 | Clinton | Michigan | 26037 | 126 | 10 |
134420 | 134420 | 2020-05-11 | Clinton | Michigan | 26037 | 128 | 10 |
137410 | 137410 | 2020-05-12 | Clinton | Michigan | 26037 | 126 | 10 |
140404 | 140404 | 2020-05-13 | Clinton | Michigan | 26037 | 127 | 10 |
143399 | 143399 | 2020-05-14 | Clinton | Michigan | 26037 | 129 | 10 |
146399 | 146399 | 2020-05-15 | Clinton | Michigan | 26037 | 132 | 10 |
149404 | 149404 | 2020-05-16 | Clinton | Michigan | 26037 | 132 | 10 |
152415 | 152415 | 2020-05-17 | Clinton | Michigan | 26037 | 134 | 10 |
155429 | 155429 | 2020-05-18 | Clinton | Michigan | 26037 | 135 | 10 |
158447 | 158447 | 2020-05-19 | Clinton | Michigan | 26037 | 136 | 10 |
161473 | 161473 | 2020-05-20 | Clinton | Michigan | 26037 | 136 | 10 |
164502 | 164502 | 2020-05-21 | Clinton | Michigan | 26037 | 137 | 10 |
167538 | 167538 | 2020-05-22 | Clinton | Michigan | 26037 | 136 | 10 |
170575 | 170575 | 2020-05-23 | Clinton | Michigan | 26037 | 137 | 10 |
173617 | 173617 | 2020-05-24 | Clinton | Michigan | 26037 | 138 | 10 |
176660 | 176660 | 2020-05-25 | Clinton | Michigan | 26037 | 138 | 10 |
179704 | 179704 | 2020-05-26 | Clinton | Michigan | 26037 | 138 | 10 |
182750 | 182750 | 2020-05-27 | Clinton | Michigan | 26037 | 142 | 10 |
185805 | 185805 | 2020-05-28 | Clinton | Michigan | 26037 | 139 | 10 |
188863 | 188863 | 2020-05-29 | Clinton | Michigan | 26037 | 139 | 10 |
191927 | 191927 | 2020-05-30 | Clinton | Michigan | 26037 | 139 | 10 |
194995 | 194995 | 2020-05-31 | Clinton | Michigan | 26037 | 139 | 11 |
198066 | 198066 | 2020-06-01 | Clinton | Michigan | 26037 | 140 | 11 |
201138 | 201138 | 2020-06-02 | Clinton | Michigan | 26037 | 140 | 11 |
204215 | 204215 | 2020-06-03 | Clinton | Michigan | 26037 | 141 | 11 |
207296 | 207296 | 2020-06-04 | Clinton | Michigan | 26037 | 142 | 11 |
210377 | 210377 | 2020-06-05 | Clinton | Michigan | 26037 | 181 | 11 |
213461 | 213461 | 2020-06-06 | Clinton | Michigan | 26037 | 182 | 11 |
216549 | 216549 | 2020-06-07 | Clinton | Michigan | 26037 | 182 | 11 |
219641 | 219641 | 2020-06-08 | Clinton | Michigan | 26037 | 183 | 11 |
222736 | 222736 | 2020-06-09 | Clinton | Michigan | 26037 | 186 | 11 |
225833 | 225833 | 2020-06-10 | Clinton | Michigan | 26037 | 187 | 11 |
228935 | 228935 | 2020-06-11 | Clinton | Michigan | 26037 | 188 | 11 |
232039 | 232039 | 2020-06-12 | Clinton | Michigan | 26037 | 188 | 11 |
235144 | 235144 | 2020-06-13 | Clinton | Michigan | 26037 | 188 | 11 |
238251 | 238251 | 2020-06-14 | Clinton | Michigan | 26037 | 190 | 11 |
241360 | 241360 | 2020-06-15 | Clinton | Michigan | 26037 | 190 | 11 |
244471 | 244471 | 2020-06-16 | Clinton | Michigan | 26037 | 190 | 11 |
247584 | 247584 | 2020-06-17 | Clinton | Michigan | 26037 | 191 | 11 |
250696 | 250696 | 2020-06-18 | Clinton | Michigan | 26037 | 193 | 11 |
253811 | 253811 | 2020-06-19 | Clinton | Michigan | 26037 | 195 | 11 |
256931 | 256931 | 2020-06-20 | Clinton | Michigan | 26037 | 199 | 11 |
260057 | 260057 | 2020-06-21 | Clinton | Michigan | 26037 | 201 | 11 |
263186 | 263186 | 2020-06-22 | Clinton | Michigan | 26037 | 201 | 11 |
266312 | 266312 | 2020-06-23 | Clinton | Michigan | 26037 | 204 | 11 |
269445 | 269445 | 2020-06-24 | Clinton | Michigan | 26037 | 205 | 11 |
272582 | 272582 | 2020-06-25 | Clinton | Michigan | 26037 | 207 | 12 |
275725 | 275725 | 2020-06-26 | Clinton | Michigan | 26037 | 214 | 12 |
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);