ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 26011 and state = "Michigan" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
22622 | 22622 | 2020-03-31 | Arenac | Michigan | 26011 | 1 | 0 |
24801 | 24801 | 2020-04-01 | Arenac | Michigan | 26011 | 1 | 0 |
27053 | 27053 | 2020-04-02 | Arenac | Michigan | 26011 | 1 | 0 |
29371 | 29371 | 2020-04-03 | Arenac | Michigan | 26011 | 2 | 0 |
31749 | 31749 | 2020-04-04 | Arenac | Michigan | 26011 | 3 | 0 |
34174 | 34174 | 2020-04-05 | Arenac | Michigan | 26011 | 3 | 0 |
36633 | 36633 | 2020-04-06 | Arenac | Michigan | 26011 | 3 | 0 |
39141 | 39141 | 2020-04-07 | Arenac | Michigan | 26011 | 3 | 0 |
41693 | 41693 | 2020-04-08 | Arenac | Michigan | 26011 | 4 | 0 |
44269 | 44269 | 2020-04-09 | Arenac | Michigan | 26011 | 4 | 0 |
46877 | 46877 | 2020-04-10 | Arenac | Michigan | 26011 | 4 | 0 |
49520 | 49520 | 2020-04-11 | Arenac | Michigan | 26011 | 4 | 0 |
52190 | 52190 | 2020-04-12 | Arenac | Michigan | 26011 | 5 | 0 |
54871 | 54871 | 2020-04-13 | Arenac | Michigan | 26011 | 5 | 0 |
57569 | 57569 | 2020-04-14 | Arenac | Michigan | 26011 | 5 | 0 |
60279 | 60279 | 2020-04-15 | Arenac | Michigan | 26011 | 7 | 0 |
63000 | 63000 | 2020-04-16 | Arenac | Michigan | 26011 | 7 | 0 |
65738 | 65738 | 2020-04-17 | Arenac | Michigan | 26011 | 7 | 0 |
68488 | 68488 | 2020-04-18 | Arenac | Michigan | 26011 | 9 | 0 |
71252 | 71252 | 2020-04-19 | Arenac | Michigan | 26011 | 11 | 0 |
74024 | 74024 | 2020-04-20 | Arenac | Michigan | 26011 | 12 | 1 |
76804 | 76804 | 2020-04-21 | Arenac | Michigan | 26011 | 13 | 1 |
79590 | 79590 | 2020-04-22 | Arenac | Michigan | 26011 | 13 | 1 |
82385 | 82385 | 2020-04-23 | Arenac | Michigan | 26011 | 15 | 1 |
85189 | 85189 | 2020-04-24 | Arenac | Michigan | 26011 | 16 | 1 |
87999 | 87999 | 2020-04-25 | Arenac | Michigan | 26011 | 16 | 1 |
90815 | 90815 | 2020-04-26 | Arenac | Michigan | 26011 | 16 | 1 |
93636 | 93636 | 2020-04-27 | Arenac | Michigan | 26011 | 15 | 1 |
96471 | 96471 | 2020-04-28 | Arenac | Michigan | 26011 | 18 | 1 |
99317 | 99317 | 2020-04-29 | Arenac | Michigan | 26011 | 18 | 1 |
102169 | 102169 | 2020-04-30 | Arenac | Michigan | 26011 | 24 | 1 |
105029 | 105029 | 2020-05-01 | Arenac | Michigan | 26011 | 26 | 1 |
107893 | 107893 | 2020-05-02 | Arenac | Michigan | 26011 | 29 | 1 |
110765 | 110765 | 2020-05-03 | Arenac | Michigan | 26011 | 28 | 1 |
113643 | 113643 | 2020-05-04 | Arenac | Michigan | 26011 | 28 | 1 |
116524 | 116524 | 2020-05-05 | Arenac | Michigan | 26011 | 27 | 1 |
119485 | 119485 | 2020-05-06 | Arenac | Michigan | 26011 | 27 | 1 |
122457 | 122457 | 2020-05-07 | Arenac | Michigan | 26011 | 27 | 1 |
125439 | 125439 | 2020-05-08 | Arenac | Michigan | 26011 | 27 | 1 |
128426 | 128426 | 2020-05-09 | Arenac | Michigan | 26011 | 27 | 1 |
131416 | 131416 | 2020-05-10 | Arenac | Michigan | 26011 | 27 | 1 |
134407 | 134407 | 2020-05-11 | Arenac | Michigan | 26011 | 27 | 1 |
137397 | 137397 | 2020-05-12 | Arenac | Michigan | 26011 | 28 | 1 |
140391 | 140391 | 2020-05-13 | Arenac | Michigan | 26011 | 28 | 1 |
143386 | 143386 | 2020-05-14 | Arenac | Michigan | 26011 | 29 | 1 |
146386 | 146386 | 2020-05-15 | Arenac | Michigan | 26011 | 29 | 1 |
149391 | 149391 | 2020-05-16 | Arenac | Michigan | 26011 | 30 | 1 |
152402 | 152402 | 2020-05-17 | Arenac | Michigan | 26011 | 30 | 1 |
155416 | 155416 | 2020-05-18 | Arenac | Michigan | 26011 | 31 | 1 |
158434 | 158434 | 2020-05-19 | Arenac | Michigan | 26011 | 31 | 1 |
161460 | 161460 | 2020-05-20 | Arenac | Michigan | 26011 | 32 | 1 |
164489 | 164489 | 2020-05-21 | Arenac | Michigan | 26011 | 32 | 1 |
167525 | 167525 | 2020-05-22 | Arenac | Michigan | 26011 | 32 | 1 |
170562 | 170562 | 2020-05-23 | Arenac | Michigan | 26011 | 32 | 1 |
173604 | 173604 | 2020-05-24 | Arenac | Michigan | 26011 | 32 | 1 |
176647 | 176647 | 2020-05-25 | Arenac | Michigan | 26011 | 33 | 1 |
179691 | 179691 | 2020-05-26 | Arenac | Michigan | 26011 | 33 | 1 |
182737 | 182737 | 2020-05-27 | Arenac | Michigan | 26011 | 33 | 1 |
185792 | 185792 | 2020-05-28 | Arenac | Michigan | 26011 | 33 | 1 |
188850 | 188850 | 2020-05-29 | Arenac | Michigan | 26011 | 34 | 1 |
191914 | 191914 | 2020-05-30 | Arenac | Michigan | 26011 | 34 | 1 |
194982 | 194982 | 2020-05-31 | Arenac | Michigan | 26011 | 34 | 1 |
198053 | 198053 | 2020-06-01 | Arenac | Michigan | 26011 | 34 | 1 |
201125 | 201125 | 2020-06-02 | Arenac | Michigan | 26011 | 34 | 1 |
204202 | 204202 | 2020-06-03 | Arenac | Michigan | 26011 | 34 | 1 |
207283 | 207283 | 2020-06-04 | Arenac | Michigan | 26011 | 34 | 1 |
210364 | 210364 | 2020-06-05 | Arenac | Michigan | 26011 | 38 | 1 |
213448 | 213448 | 2020-06-06 | Arenac | Michigan | 26011 | 38 | 1 |
216536 | 216536 | 2020-06-07 | Arenac | Michigan | 26011 | 38 | 1 |
219628 | 219628 | 2020-06-08 | Arenac | Michigan | 26011 | 38 | 1 |
222723 | 222723 | 2020-06-09 | Arenac | Michigan | 26011 | 38 | 1 |
225820 | 225820 | 2020-06-10 | Arenac | Michigan | 26011 | 38 | 1 |
228922 | 228922 | 2020-06-11 | Arenac | Michigan | 26011 | 38 | 1 |
232026 | 232026 | 2020-06-12 | Arenac | Michigan | 26011 | 38 | 1 |
235131 | 235131 | 2020-06-13 | Arenac | Michigan | 26011 | 38 | 1 |
238238 | 238238 | 2020-06-14 | Arenac | Michigan | 26011 | 38 | 1 |
241347 | 241347 | 2020-06-15 | Arenac | Michigan | 26011 | 38 | 1 |
244458 | 244458 | 2020-06-16 | Arenac | Michigan | 26011 | 38 | 1 |
247571 | 247571 | 2020-06-17 | Arenac | Michigan | 26011 | 38 | 1 |
250683 | 250683 | 2020-06-18 | Arenac | Michigan | 26011 | 38 | 1 |
253798 | 253798 | 2020-06-19 | Arenac | Michigan | 26011 | 38 | 1 |
256918 | 256918 | 2020-06-20 | Arenac | Michigan | 26011 | 38 | 2 |
260044 | 260044 | 2020-06-21 | Arenac | Michigan | 26011 | 38 | 2 |
263173 | 263173 | 2020-06-22 | Arenac | Michigan | 26011 | 38 | 2 |
266299 | 266299 | 2020-06-23 | Arenac | Michigan | 26011 | 38 | 2 |
269432 | 269432 | 2020-06-24 | Arenac | Michigan | 26011 | 38 | 2 |
272569 | 272569 | 2020-06-25 | Arenac | Michigan | 26011 | 38 | 2 |
275712 | 275712 | 2020-06-26 | Arenac | Michigan | 26011 | 38 | 2 |
278860 | 278860 | 2020-06-27 | Arenac | Michigan | 26011 | 38 | 2 |
282008 | 282008 | 2020-06-28 | Arenac | Michigan | 26011 | 39 | 2 |
285153 | 285153 | 2020-06-29 | Arenac | Michigan | 26011 | 38 | 2 |
288303 | 288303 | 2020-06-30 | Arenac | Michigan | 26011 | 38 | 2 |
291454 | 291454 | 2020-07-01 | Arenac | Michigan | 26011 | 39 | 2 |
294608 | 294608 | 2020-07-02 | Arenac | Michigan | 26011 | 38 | 2 |
297766 | 297766 | 2020-07-03 | Arenac | Michigan | 26011 | 38 | 2 |
300928 | 300928 | 2020-07-04 | Arenac | Michigan | 26011 | 38 | 2 |
304092 | 304092 | 2020-07-05 | Arenac | Michigan | 26011 | 38 | 2 |
307259 | 307259 | 2020-07-06 | Arenac | Michigan | 26011 | 38 | 2 |
310427 | 310427 | 2020-07-07 | Arenac | Michigan | 26011 | 38 | 2 |
313597 | 313597 | 2020-07-08 | Arenac | Michigan | 26011 | 38 | 2 |
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);