ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 26101 and state = "Michigan" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
10084 | 10084 | 2020-03-24 | Manistee | Michigan | 26101 | 1 | 0 |
11498 | 11498 | 2020-03-25 | Manistee | Michigan | 26101 | 1 | 0 |
13081 | 13081 | 2020-03-26 | Manistee | Michigan | 26101 | 1 | 0 |
14793 | 14793 | 2020-03-27 | Manistee | Michigan | 26101 | 1 | 0 |
16613 | 16613 | 2020-03-28 | Manistee | Michigan | 26101 | 1 | 0 |
18529 | 18529 | 2020-03-29 | Manistee | Michigan | 26101 | 1 | 0 |
20548 | 20548 | 2020-03-30 | Manistee | Michigan | 26101 | 1 | 0 |
22659 | 22659 | 2020-03-31 | Manistee | Michigan | 26101 | 1 | 0 |
24839 | 24839 | 2020-04-01 | Manistee | Michigan | 26101 | 1 | 0 |
27092 | 27092 | 2020-04-02 | Manistee | Michigan | 26101 | 1 | 0 |
29411 | 29411 | 2020-04-03 | Manistee | Michigan | 26101 | 1 | 0 |
31789 | 31789 | 2020-04-04 | Manistee | Michigan | 26101 | 4 | 0 |
34214 | 34214 | 2020-04-05 | Manistee | Michigan | 26101 | 4 | 0 |
36673 | 36673 | 2020-04-06 | Manistee | Michigan | 26101 | 6 | 0 |
39181 | 39181 | 2020-04-07 | Manistee | Michigan | 26101 | 9 | 0 |
41733 | 41733 | 2020-04-08 | Manistee | Michigan | 26101 | 9 | 0 |
44309 | 44309 | 2020-04-09 | Manistee | Michigan | 26101 | 9 | 0 |
46917 | 46917 | 2020-04-10 | Manistee | Michigan | 26101 | 9 | 0 |
49561 | 49561 | 2020-04-11 | Manistee | Michigan | 26101 | 9 | 0 |
52231 | 52231 | 2020-04-12 | Manistee | Michigan | 26101 | 10 | 0 |
54912 | 54912 | 2020-04-13 | Manistee | Michigan | 26101 | 10 | 0 |
57610 | 57610 | 2020-04-14 | Manistee | Michigan | 26101 | 10 | 0 |
60320 | 60320 | 2020-04-15 | Manistee | Michigan | 26101 | 10 | 0 |
63042 | 63042 | 2020-04-16 | Manistee | Michigan | 26101 | 11 | 0 |
65780 | 65780 | 2020-04-17 | Manistee | Michigan | 26101 | 11 | 0 |
68531 | 68531 | 2020-04-18 | Manistee | Michigan | 26101 | 11 | 0 |
71295 | 71295 | 2020-04-19 | Manistee | Michigan | 26101 | 11 | 0 |
74067 | 74067 | 2020-04-20 | Manistee | Michigan | 26101 | 11 | 0 |
76847 | 76847 | 2020-04-21 | Manistee | Michigan | 26101 | 11 | 0 |
79633 | 79633 | 2020-04-22 | Manistee | Michigan | 26101 | 11 | 0 |
82428 | 82428 | 2020-04-23 | Manistee | Michigan | 26101 | 12 | 0 |
85232 | 85232 | 2020-04-24 | Manistee | Michigan | 26101 | 12 | 0 |
88042 | 88042 | 2020-04-25 | Manistee | Michigan | 26101 | 12 | 0 |
90858 | 90858 | 2020-04-26 | Manistee | Michigan | 26101 | 11 | 0 |
93679 | 93679 | 2020-04-27 | Manistee | Michigan | 26101 | 11 | 0 |
96514 | 96514 | 2020-04-28 | Manistee | Michigan | 26101 | 11 | 0 |
99360 | 99360 | 2020-04-29 | Manistee | Michigan | 26101 | 11 | 0 |
102212 | 102212 | 2020-04-30 | Manistee | Michigan | 26101 | 11 | 0 |
105072 | 105072 | 2020-05-01 | Manistee | Michigan | 26101 | 11 | 0 |
107936 | 107936 | 2020-05-02 | Manistee | Michigan | 26101 | 11 | 0 |
110808 | 110808 | 2020-05-03 | Manistee | Michigan | 26101 | 11 | 0 |
113686 | 113686 | 2020-05-04 | Manistee | Michigan | 26101 | 11 | 0 |
116567 | 116567 | 2020-05-05 | Manistee | Michigan | 26101 | 11 | 0 |
119528 | 119528 | 2020-05-06 | Manistee | Michigan | 26101 | 11 | 0 |
122500 | 122500 | 2020-05-07 | Manistee | Michigan | 26101 | 11 | 0 |
125482 | 125482 | 2020-05-08 | Manistee | Michigan | 26101 | 11 | 0 |
128469 | 128469 | 2020-05-09 | Manistee | Michigan | 26101 | 11 | 0 |
131459 | 131459 | 2020-05-10 | Manistee | Michigan | 26101 | 11 | 0 |
134450 | 134450 | 2020-05-11 | Manistee | Michigan | 26101 | 11 | 0 |
137440 | 137440 | 2020-05-12 | Manistee | Michigan | 26101 | 11 | 0 |
140434 | 140434 | 2020-05-13 | Manistee | Michigan | 26101 | 11 | 0 |
143429 | 143429 | 2020-05-14 | Manistee | Michigan | 26101 | 11 | 0 |
146429 | 146429 | 2020-05-15 | Manistee | Michigan | 26101 | 20 | 0 |
149434 | 149434 | 2020-05-16 | Manistee | Michigan | 26101 | 20 | 0 |
152445 | 152445 | 2020-05-17 | Manistee | Michigan | 26101 | 20 | 0 |
155459 | 155459 | 2020-05-18 | Manistee | Michigan | 26101 | 20 | 0 |
158477 | 158477 | 2020-05-19 | Manistee | Michigan | 26101 | 20 | 0 |
161503 | 161503 | 2020-05-20 | Manistee | Michigan | 26101 | 20 | 0 |
164532 | 164532 | 2020-05-21 | Manistee | Michigan | 26101 | 20 | 0 |
167568 | 167568 | 2020-05-22 | Manistee | Michigan | 26101 | 20 | 0 |
170605 | 170605 | 2020-05-23 | Manistee | Michigan | 26101 | 20 | 0 |
173647 | 173647 | 2020-05-24 | Manistee | Michigan | 26101 | 20 | 0 |
176690 | 176690 | 2020-05-25 | Manistee | Michigan | 26101 | 20 | 0 |
179734 | 179734 | 2020-05-26 | Manistee | Michigan | 26101 | 20 | 0 |
182780 | 182780 | 2020-05-27 | Manistee | Michigan | 26101 | 20 | 0 |
185835 | 185835 | 2020-05-28 | Manistee | Michigan | 26101 | 20 | 0 |
188893 | 188893 | 2020-05-29 | Manistee | Michigan | 26101 | 20 | 0 |
191957 | 191957 | 2020-05-30 | Manistee | Michigan | 26101 | 20 | 0 |
195025 | 195025 | 2020-05-31 | Manistee | Michigan | 26101 | 20 | 0 |
198096 | 198096 | 2020-06-01 | Manistee | Michigan | 26101 | 24 | 0 |
201169 | 201169 | 2020-06-02 | Manistee | Michigan | 26101 | 24 | 0 |
204246 | 204246 | 2020-06-03 | Manistee | Michigan | 26101 | 24 | 0 |
207327 | 207327 | 2020-06-04 | Manistee | Michigan | 26101 | 24 | 0 |
210408 | 210408 | 2020-06-05 | Manistee | Michigan | 26101 | 24 | 1 |
213492 | 213492 | 2020-06-06 | Manistee | Michigan | 26101 | 24 | 1 |
216580 | 216580 | 2020-06-07 | Manistee | Michigan | 26101 | 24 | 1 |
219672 | 219672 | 2020-06-08 | Manistee | Michigan | 26101 | 24 | 1 |
222767 | 222767 | 2020-06-09 | Manistee | Michigan | 26101 | 24 | 1 |
225865 | 225865 | 2020-06-10 | Manistee | Michigan | 26101 | 24 | 1 |
228967 | 228967 | 2020-06-11 | Manistee | Michigan | 26101 | 24 | 1 |
232071 | 232071 | 2020-06-12 | Manistee | Michigan | 26101 | 24 | 1 |
235176 | 235176 | 2020-06-13 | Manistee | Michigan | 26101 | 24 | 1 |
238283 | 238283 | 2020-06-14 | Manistee | Michigan | 26101 | 24 | 1 |
241392 | 241392 | 2020-06-15 | Manistee | Michigan | 26101 | 24 | 1 |
244503 | 244503 | 2020-06-16 | Manistee | Michigan | 26101 | 24 | 1 |
247616 | 247616 | 2020-06-17 | Manistee | Michigan | 26101 | 24 | 1 |
250728 | 250728 | 2020-06-18 | Manistee | Michigan | 26101 | 24 | 1 |
253843 | 253843 | 2020-06-19 | Manistee | Michigan | 26101 | 26 | 0 |
256963 | 256963 | 2020-06-20 | Manistee | Michigan | 26101 | 27 | 0 |
260089 | 260089 | 2020-06-21 | Manistee | Michigan | 26101 | 27 | 0 |
263218 | 263218 | 2020-06-22 | Manistee | Michigan | 26101 | 27 | 0 |
266344 | 266344 | 2020-06-23 | Manistee | Michigan | 26101 | 28 | 1 |
269477 | 269477 | 2020-06-24 | Manistee | Michigan | 26101 | 28 | 1 |
272614 | 272614 | 2020-06-25 | Manistee | Michigan | 26101 | 28 | 0 |
275757 | 275757 | 2020-06-26 | Manistee | Michigan | 26101 | 28 | 0 |
278905 | 278905 | 2020-06-27 | Manistee | Michigan | 26101 | 28 | 0 |
282053 | 282053 | 2020-06-28 | Manistee | Michigan | 26101 | 28 | 0 |
285198 | 285198 | 2020-06-29 | Manistee | Michigan | 26101 | 30 | 0 |
288348 | 288348 | 2020-06-30 | Manistee | Michigan | 26101 | 31 | 0 |
291499 | 291499 | 2020-07-01 | Manistee | Michigan | 26101 | 31 | 0 |
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);