ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 26143 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 |
---|---|---|---|---|---|---|---|
7623 | 7623 | 2020-03-22 | Roscommon | Michigan | 26143 | 1 | 0 |
8799 | 8799 | 2020-03-23 | Roscommon | Michigan | 26143 | 1 | 0 |
10093 | 10093 | 2020-03-24 | Roscommon | Michigan | 26143 | 1 | 0 |
11508 | 11508 | 2020-03-25 | Roscommon | Michigan | 26143 | 1 | 0 |
13095 | 13095 | 2020-03-26 | Roscommon | Michigan | 26143 | 1 | 0 |
14807 | 14807 | 2020-03-27 | Roscommon | Michigan | 26143 | 1 | 0 |
16628 | 16628 | 2020-03-28 | Roscommon | Michigan | 26143 | 1 | 0 |
18544 | 18544 | 2020-03-29 | Roscommon | Michigan | 26143 | 1 | 0 |
20563 | 20563 | 2020-03-30 | Roscommon | Michigan | 26143 | 1 | 0 |
22675 | 22675 | 2020-03-31 | Roscommon | Michigan | 26143 | 1 | 0 |
24855 | 24855 | 2020-04-01 | Roscommon | Michigan | 26143 | 1 | 0 |
27108 | 27108 | 2020-04-02 | Roscommon | Michigan | 26143 | 1 | 0 |
29427 | 29427 | 2020-04-03 | Roscommon | Michigan | 26143 | 2 | 0 |
31805 | 31805 | 2020-04-04 | Roscommon | Michigan | 26143 | 2 | 0 |
34230 | 34230 | 2020-04-05 | Roscommon | Michigan | 26143 | 5 | 0 |
36690 | 36690 | 2020-04-06 | Roscommon | Michigan | 26143 | 5 | 0 |
39199 | 39199 | 2020-04-07 | Roscommon | Michigan | 26143 | 6 | 0 |
41751 | 41751 | 2020-04-08 | Roscommon | Michigan | 26143 | 6 | 0 |
44327 | 44327 | 2020-04-09 | Roscommon | Michigan | 26143 | 8 | 0 |
46936 | 46936 | 2020-04-10 | Roscommon | Michigan | 26143 | 8 | 0 |
49580 | 49580 | 2020-04-11 | Roscommon | Michigan | 26143 | 8 | 0 |
52250 | 52250 | 2020-04-12 | Roscommon | Michigan | 26143 | 9 | 0 |
54932 | 54932 | 2020-04-13 | Roscommon | Michigan | 26143 | 9 | 0 |
57630 | 57630 | 2020-04-14 | Roscommon | Michigan | 26143 | 9 | 0 |
60340 | 60340 | 2020-04-15 | Roscommon | Michigan | 26143 | 9 | 0 |
63062 | 63062 | 2020-04-16 | Roscommon | Michigan | 26143 | 9 | 0 |
65800 | 65800 | 2020-04-17 | Roscommon | Michigan | 26143 | 9 | 0 |
68551 | 68551 | 2020-04-18 | Roscommon | Michigan | 26143 | 9 | 0 |
71315 | 71315 | 2020-04-19 | Roscommon | Michigan | 26143 | 10 | 0 |
74087 | 74087 | 2020-04-20 | Roscommon | Michigan | 26143 | 11 | 0 |
76867 | 76867 | 2020-04-21 | Roscommon | Michigan | 26143 | 11 | 0 |
79653 | 79653 | 2020-04-22 | Roscommon | Michigan | 26143 | 11 | 0 |
82448 | 82448 | 2020-04-23 | Roscommon | Michigan | 26143 | 11 | 0 |
85252 | 85252 | 2020-04-24 | Roscommon | Michigan | 26143 | 12 | 0 |
88062 | 88062 | 2020-04-25 | Roscommon | Michigan | 26143 | 13 | 0 |
90878 | 90878 | 2020-04-26 | Roscommon | Michigan | 26143 | 13 | 0 |
93699 | 93699 | 2020-04-27 | Roscommon | Michigan | 26143 | 13 | 0 |
96534 | 96534 | 2020-04-28 | Roscommon | Michigan | 26143 | 14 | 0 |
99380 | 99380 | 2020-04-29 | Roscommon | Michigan | 26143 | 15 | 0 |
102232 | 102232 | 2020-04-30 | Roscommon | Michigan | 26143 | 16 | 0 |
105092 | 105092 | 2020-05-01 | Roscommon | Michigan | 26143 | 16 | 0 |
107956 | 107956 | 2020-05-02 | Roscommon | Michigan | 26143 | 17 | 0 |
110828 | 110828 | 2020-05-03 | Roscommon | Michigan | 26143 | 17 | 0 |
113706 | 113706 | 2020-05-04 | Roscommon | Michigan | 26143 | 18 | 0 |
116587 | 116587 | 2020-05-05 | Roscommon | Michigan | 26143 | 18 | 0 |
119548 | 119548 | 2020-05-06 | Roscommon | Michigan | 26143 | 18 | 0 |
122520 | 122520 | 2020-05-07 | Roscommon | Michigan | 26143 | 18 | 0 |
125502 | 125502 | 2020-05-08 | Roscommon | Michigan | 26143 | 20 | 0 |
128489 | 128489 | 2020-05-09 | Roscommon | Michigan | 26143 | 20 | 0 |
131479 | 131479 | 2020-05-10 | Roscommon | Michigan | 26143 | 20 | 0 |
134470 | 134470 | 2020-05-11 | Roscommon | Michigan | 26143 | 20 | 0 |
137460 | 137460 | 2020-05-12 | Roscommon | Michigan | 26143 | 20 | 0 |
140454 | 140454 | 2020-05-13 | Roscommon | Michigan | 26143 | 20 | 0 |
143449 | 143449 | 2020-05-14 | Roscommon | Michigan | 26143 | 20 | 0 |
146449 | 146449 | 2020-05-15 | Roscommon | Michigan | 26143 | 21 | 0 |
149454 | 149454 | 2020-05-16 | Roscommon | Michigan | 26143 | 21 | 0 |
152465 | 152465 | 2020-05-17 | Roscommon | Michigan | 26143 | 21 | 0 |
155479 | 155479 | 2020-05-18 | Roscommon | Michigan | 26143 | 21 | 0 |
158497 | 158497 | 2020-05-19 | Roscommon | Michigan | 26143 | 21 | 0 |
161523 | 161523 | 2020-05-20 | Roscommon | Michigan | 26143 | 21 | 0 |
164552 | 164552 | 2020-05-21 | Roscommon | Michigan | 26143 | 21 | 0 |
167588 | 167588 | 2020-05-22 | Roscommon | Michigan | 26143 | 21 | 0 |
170625 | 170625 | 2020-05-23 | Roscommon | Michigan | 26143 | 21 | 0 |
173667 | 173667 | 2020-05-24 | Roscommon | Michigan | 26143 | 21 | 0 |
176710 | 176710 | 2020-05-25 | Roscommon | Michigan | 26143 | 21 | 0 |
179754 | 179754 | 2020-05-26 | Roscommon | Michigan | 26143 | 21 | 0 |
182800 | 182800 | 2020-05-27 | Roscommon | Michigan | 26143 | 21 | 0 |
185855 | 185855 | 2020-05-28 | Roscommon | Michigan | 26143 | 21 | 0 |
188913 | 188913 | 2020-05-29 | Roscommon | Michigan | 26143 | 21 | 0 |
191977 | 191977 | 2020-05-30 | Roscommon | Michigan | 26143 | 21 | 0 |
195045 | 195045 | 2020-05-31 | Roscommon | Michigan | 26143 | 21 | 0 |
198116 | 198116 | 2020-06-01 | Roscommon | Michigan | 26143 | 21 | 0 |
201189 | 201189 | 2020-06-02 | Roscommon | Michigan | 26143 | 21 | 0 |
204266 | 204266 | 2020-06-03 | Roscommon | Michigan | 26143 | 21 | 0 |
207347 | 207347 | 2020-06-04 | Roscommon | Michigan | 26143 | 21 | 0 |
210428 | 210428 | 2020-06-05 | Roscommon | Michigan | 26143 | 24 | 0 |
213512 | 213512 | 2020-06-06 | Roscommon | Michigan | 26143 | 24 | 0 |
216600 | 216600 | 2020-06-07 | Roscommon | Michigan | 26143 | 24 | 0 |
219692 | 219692 | 2020-06-08 | Roscommon | Michigan | 26143 | 24 | 0 |
222787 | 222787 | 2020-06-09 | Roscommon | Michigan | 26143 | 24 | 0 |
225885 | 225885 | 2020-06-10 | Roscommon | Michigan | 26143 | 24 | 0 |
228987 | 228987 | 2020-06-11 | Roscommon | Michigan | 26143 | 24 | 0 |
232091 | 232091 | 2020-06-12 | Roscommon | Michigan | 26143 | 25 | 0 |
235196 | 235196 | 2020-06-13 | Roscommon | Michigan | 26143 | 25 | 0 |
238303 | 238303 | 2020-06-14 | Roscommon | Michigan | 26143 | 25 | 0 |
241412 | 241412 | 2020-06-15 | Roscommon | Michigan | 26143 | 25 | 0 |
244523 | 244523 | 2020-06-16 | Roscommon | Michigan | 26143 | 25 | 0 |
247636 | 247636 | 2020-06-17 | Roscommon | Michigan | 26143 | 25 | 0 |
250748 | 250748 | 2020-06-18 | Roscommon | Michigan | 26143 | 25 | 0 |
253863 | 253863 | 2020-06-19 | Roscommon | Michigan | 26143 | 26 | 0 |
256983 | 256983 | 2020-06-20 | Roscommon | Michigan | 26143 | 26 | 0 |
260109 | 260109 | 2020-06-21 | Roscommon | Michigan | 26143 | 26 | 0 |
263238 | 263238 | 2020-06-22 | Roscommon | Michigan | 26143 | 26 | 0 |
266364 | 266364 | 2020-06-23 | Roscommon | Michigan | 26143 | 26 | 0 |
269497 | 269497 | 2020-06-24 | Roscommon | Michigan | 26143 | 26 | 0 |
272634 | 272634 | 2020-06-25 | Roscommon | Michigan | 26143 | 26 | 0 |
275777 | 275777 | 2020-06-26 | Roscommon | Michigan | 26143 | 26 | 0 |
278925 | 278925 | 2020-06-27 | Roscommon | Michigan | 26143 | 26 | 0 |
282073 | 282073 | 2020-06-28 | Roscommon | Michigan | 26143 | 26 | 0 |
285218 | 285218 | 2020-06-29 | Roscommon | Michigan | 26143 | 26 | 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);