ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 26135 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 |
---|---|---|---|---|---|---|---|
22672 | 22672 | 2020-03-31 | Oscoda | Michigan | 26135 | 2 | 0 |
24852 | 24852 | 2020-04-01 | Oscoda | Michigan | 26135 | 2 | 0 |
27105 | 27105 | 2020-04-02 | Oscoda | Michigan | 26135 | 2 | 0 |
29424 | 29424 | 2020-04-03 | Oscoda | Michigan | 26135 | 2 | 0 |
31802 | 31802 | 2020-04-04 | Oscoda | Michigan | 26135 | 2 | 0 |
34227 | 34227 | 2020-04-05 | Oscoda | Michigan | 26135 | 2 | 0 |
36686 | 36686 | 2020-04-06 | Oscoda | Michigan | 26135 | 2 | 0 |
39195 | 39195 | 2020-04-07 | Oscoda | Michigan | 26135 | 2 | 0 |
41747 | 41747 | 2020-04-08 | Oscoda | Michigan | 26135 | 2 | 0 |
44323 | 44323 | 2020-04-09 | Oscoda | Michigan | 26135 | 3 | 0 |
46932 | 46932 | 2020-04-10 | Oscoda | Michigan | 26135 | 3 | 0 |
49576 | 49576 | 2020-04-11 | Oscoda | Michigan | 26135 | 4 | 0 |
52246 | 52246 | 2020-04-12 | Oscoda | Michigan | 26135 | 4 | 0 |
54928 | 54928 | 2020-04-13 | Oscoda | Michigan | 26135 | 4 | 0 |
57626 | 57626 | 2020-04-14 | Oscoda | Michigan | 26135 | 4 | 0 |
60336 | 60336 | 2020-04-15 | Oscoda | Michigan | 26135 | 4 | 0 |
63058 | 63058 | 2020-04-16 | Oscoda | Michigan | 26135 | 4 | 0 |
65796 | 65796 | 2020-04-17 | Oscoda | Michigan | 26135 | 4 | 0 |
68547 | 68547 | 2020-04-18 | Oscoda | Michigan | 26135 | 4 | 0 |
71311 | 71311 | 2020-04-19 | Oscoda | Michigan | 26135 | 5 | 0 |
74083 | 74083 | 2020-04-20 | Oscoda | Michigan | 26135 | 4 | 1 |
76863 | 76863 | 2020-04-21 | Oscoda | Michigan | 26135 | 4 | 0 |
79649 | 79649 | 2020-04-22 | Oscoda | Michigan | 26135 | 4 | 0 |
82444 | 82444 | 2020-04-23 | Oscoda | Michigan | 26135 | 4 | 0 |
85248 | 85248 | 2020-04-24 | Oscoda | Michigan | 26135 | 4 | 0 |
88058 | 88058 | 2020-04-25 | Oscoda | Michigan | 26135 | 4 | 0 |
90874 | 90874 | 2020-04-26 | Oscoda | Michigan | 26135 | 4 | 0 |
93695 | 93695 | 2020-04-27 | Oscoda | Michigan | 26135 | 4 | 0 |
96530 | 96530 | 2020-04-28 | Oscoda | Michigan | 26135 | 4 | 0 |
99376 | 99376 | 2020-04-29 | Oscoda | Michigan | 26135 | 4 | 0 |
102228 | 102228 | 2020-04-30 | Oscoda | Michigan | 26135 | 5 | 0 |
105088 | 105088 | 2020-05-01 | Oscoda | Michigan | 26135 | 5 | 0 |
107952 | 107952 | 2020-05-02 | Oscoda | Michigan | 26135 | 5 | 0 |
110824 | 110824 | 2020-05-03 | Oscoda | Michigan | 26135 | 5 | 0 |
113702 | 113702 | 2020-05-04 | Oscoda | Michigan | 26135 | 5 | 0 |
116583 | 116583 | 2020-05-05 | Oscoda | Michigan | 26135 | 5 | 0 |
119544 | 119544 | 2020-05-06 | Oscoda | Michigan | 26135 | 5 | 0 |
122516 | 122516 | 2020-05-07 | Oscoda | Michigan | 26135 | 5 | 0 |
125498 | 125498 | 2020-05-08 | Oscoda | Michigan | 26135 | 5 | 0 |
128485 | 128485 | 2020-05-09 | Oscoda | Michigan | 26135 | 5 | 1 |
131475 | 131475 | 2020-05-10 | Oscoda | Michigan | 26135 | 5 | 1 |
134466 | 134466 | 2020-05-11 | Oscoda | Michigan | 26135 | 5 | 1 |
137456 | 137456 | 2020-05-12 | Oscoda | Michigan | 26135 | 5 | 1 |
140450 | 140450 | 2020-05-13 | Oscoda | Michigan | 26135 | 5 | 1 |
143445 | 143445 | 2020-05-14 | Oscoda | Michigan | 26135 | 5 | 1 |
146445 | 146445 | 2020-05-15 | Oscoda | Michigan | 26135 | 5 | 1 |
149450 | 149450 | 2020-05-16 | Oscoda | Michigan | 26135 | 5 | 1 |
152461 | 152461 | 2020-05-17 | Oscoda | Michigan | 26135 | 5 | 1 |
155475 | 155475 | 2020-05-18 | Oscoda | Michigan | 26135 | 5 | 1 |
158493 | 158493 | 2020-05-19 | Oscoda | Michigan | 26135 | 5 | 1 |
161519 | 161519 | 2020-05-20 | Oscoda | Michigan | 26135 | 6 | 1 |
164548 | 164548 | 2020-05-21 | Oscoda | Michigan | 26135 | 5 | 1 |
167584 | 167584 | 2020-05-22 | Oscoda | Michigan | 26135 | 5 | 1 |
170621 | 170621 | 2020-05-23 | Oscoda | Michigan | 26135 | 5 | 1 |
173663 | 173663 | 2020-05-24 | Oscoda | Michigan | 26135 | 5 | 1 |
176706 | 176706 | 2020-05-25 | Oscoda | Michigan | 26135 | 5 | 1 |
179750 | 179750 | 2020-05-26 | Oscoda | Michigan | 26135 | 5 | 1 |
182796 | 182796 | 2020-05-27 | Oscoda | Michigan | 26135 | 5 | 1 |
185851 | 185851 | 2020-05-28 | Oscoda | Michigan | 26135 | 5 | 1 |
188909 | 188909 | 2020-05-29 | Oscoda | Michigan | 26135 | 5 | 1 |
191973 | 191973 | 2020-05-30 | Oscoda | Michigan | 26135 | 5 | 1 |
195041 | 195041 | 2020-05-31 | Oscoda | Michigan | 26135 | 5 | 1 |
198112 | 198112 | 2020-06-01 | Oscoda | Michigan | 26135 | 7 | 1 |
201185 | 201185 | 2020-06-02 | Oscoda | Michigan | 26135 | 7 | 1 |
204262 | 204262 | 2020-06-03 | Oscoda | Michigan | 26135 | 8 | 1 |
207343 | 207343 | 2020-06-04 | Oscoda | Michigan | 26135 | 8 | 1 |
210424 | 210424 | 2020-06-05 | Oscoda | Michigan | 26135 | 8 | 1 |
213508 | 213508 | 2020-06-06 | Oscoda | Michigan | 26135 | 8 | 1 |
216596 | 216596 | 2020-06-07 | Oscoda | Michigan | 26135 | 8 | 1 |
219688 | 219688 | 2020-06-08 | Oscoda | Michigan | 26135 | 8 | 1 |
222783 | 222783 | 2020-06-09 | Oscoda | Michigan | 26135 | 8 | 1 |
225881 | 225881 | 2020-06-10 | Oscoda | Michigan | 26135 | 8 | 1 |
228983 | 228983 | 2020-06-11 | Oscoda | Michigan | 26135 | 8 | 1 |
232087 | 232087 | 2020-06-12 | Oscoda | Michigan | 26135 | 8 | 1 |
235192 | 235192 | 2020-06-13 | Oscoda | Michigan | 26135 | 8 | 1 |
238299 | 238299 | 2020-06-14 | Oscoda | Michigan | 26135 | 8 | 1 |
241408 | 241408 | 2020-06-15 | Oscoda | Michigan | 26135 | 8 | 1 |
244519 | 244519 | 2020-06-16 | Oscoda | Michigan | 26135 | 8 | 1 |
247632 | 247632 | 2020-06-17 | Oscoda | Michigan | 26135 | 8 | 1 |
250744 | 250744 | 2020-06-18 | Oscoda | Michigan | 26135 | 9 | 1 |
253859 | 253859 | 2020-06-19 | Oscoda | Michigan | 26135 | 9 | 1 |
256979 | 256979 | 2020-06-20 | Oscoda | Michigan | 26135 | 9 | 1 |
260105 | 260105 | 2020-06-21 | Oscoda | Michigan | 26135 | 9 | 1 |
263234 | 263234 | 2020-06-22 | Oscoda | Michigan | 26135 | 9 | 1 |
266360 | 266360 | 2020-06-23 | Oscoda | Michigan | 26135 | 10 | 1 |
269493 | 269493 | 2020-06-24 | Oscoda | Michigan | 26135 | 12 | 1 |
272630 | 272630 | 2020-06-25 | Oscoda | Michigan | 26135 | 14 | 1 |
275773 | 275773 | 2020-06-26 | Oscoda | Michigan | 26135 | 15 | 1 |
278921 | 278921 | 2020-06-27 | Oscoda | Michigan | 26135 | 14 | 1 |
282069 | 282069 | 2020-06-28 | Oscoda | Michigan | 26135 | 16 | 1 |
285214 | 285214 | 2020-06-29 | Oscoda | Michigan | 26135 | 16 | 1 |
288364 | 288364 | 2020-06-30 | Oscoda | Michigan | 26135 | 18 | 1 |
291515 | 291515 | 2020-07-01 | Oscoda | Michigan | 26135 | 20 | 1 |
294669 | 294669 | 2020-07-02 | Oscoda | Michigan | 26135 | 21 | 1 |
297827 | 297827 | 2020-07-03 | Oscoda | Michigan | 26135 | 21 | 1 |
300990 | 300990 | 2020-07-04 | Oscoda | Michigan | 26135 | 21 | 1 |
304154 | 304154 | 2020-07-05 | Oscoda | Michigan | 26135 | 21 | 1 |
307321 | 307321 | 2020-07-06 | Oscoda | Michigan | 26135 | 21 | 1 |
310489 | 310489 | 2020-07-07 | Oscoda | Michigan | 26135 | 21 | 1 |
313659 | 313659 | 2020-07-08 | Oscoda | Michigan | 26135 | 22 | 1 |
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);