ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 26117 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387233 | 387233 | 2020-07-31 | Montcalm | Michigan | 26117 | 176 | 1 |
384015 | 384015 | 2020-07-30 | Montcalm | Michigan | 26117 | 177 | 1 |
380798 | 380798 | 2020-07-29 | Montcalm | Michigan | 26117 | 175 | 1 |
377581 | 377581 | 2020-07-28 | Montcalm | Michigan | 26117 | 175 | 1 |
374366 | 374366 | 2020-07-27 | Montcalm | Michigan | 26117 | 174 | 1 |
371154 | 371154 | 2020-07-26 | Montcalm | Michigan | 26117 | 170 | 1 |
367944 | 367944 | 2020-07-25 | Montcalm | Michigan | 26117 | 169 | 1 |
364737 | 364737 | 2020-07-24 | Montcalm | Michigan | 26117 | 170 | 1 |
361530 | 361530 | 2020-07-23 | Montcalm | Michigan | 26117 | 167 | 1 |
358325 | 358325 | 2020-07-22 | Montcalm | Michigan | 26117 | 162 | 1 |
355122 | 355122 | 2020-07-21 | Montcalm | Michigan | 26117 | 159 | 1 |
351920 | 351920 | 2020-07-20 | Montcalm | Michigan | 26117 | 157 | 1 |
348720 | 348720 | 2020-07-19 | Montcalm | Michigan | 26117 | 153 | 1 |
345519 | 345519 | 2020-07-18 | Montcalm | Michigan | 26117 | 149 | 1 |
342319 | 342319 | 2020-07-17 | Montcalm | Michigan | 26117 | 146 | 1 |
339123 | 339123 | 2020-07-16 | Montcalm | Michigan | 26117 | 137 | 1 |
335927 | 335927 | 2020-07-15 | Montcalm | Michigan | 26117 | 131 | 1 |
332734 | 332734 | 2020-07-14 | Montcalm | Michigan | 26117 | 130 | 1 |
329547 | 329547 | 2020-07-13 | Montcalm | Michigan | 26117 | 129 | 1 |
326361 | 326361 | 2020-07-12 | Montcalm | Michigan | 26117 | 127 | 1 |
323178 | 323178 | 2020-07-11 | Montcalm | Michigan | 26117 | 127 | 1 |
319999 | 319999 | 2020-07-10 | Montcalm | Michigan | 26117 | 124 | 1 |
316824 | 316824 | 2020-07-09 | Montcalm | Michigan | 26117 | 122 | 1 |
313650 | 313650 | 2020-07-08 | Montcalm | Michigan | 26117 | 120 | 1 |
310480 | 310480 | 2020-07-07 | Montcalm | Michigan | 26117 | 113 | 1 |
307312 | 307312 | 2020-07-06 | Montcalm | Michigan | 26117 | 111 | 1 |
304145 | 304145 | 2020-07-05 | Montcalm | Michigan | 26117 | 110 | 1 |
300981 | 300981 | 2020-07-04 | Montcalm | Michigan | 26117 | 104 | 1 |
297819 | 297819 | 2020-07-03 | Montcalm | Michigan | 26117 | 100 | 1 |
294661 | 294661 | 2020-07-02 | Montcalm | Michigan | 26117 | 98 | 1 |
291507 | 291507 | 2020-07-01 | Montcalm | Michigan | 26117 | 93 | 1 |
288356 | 288356 | 2020-06-30 | Montcalm | Michigan | 26117 | 90 | 1 |
285206 | 285206 | 2020-06-29 | Montcalm | Michigan | 26117 | 89 | 1 |
282061 | 282061 | 2020-06-28 | Montcalm | Michigan | 26117 | 88 | 1 |
278913 | 278913 | 2020-06-27 | Montcalm | Michigan | 26117 | 88 | 1 |
275765 | 275765 | 2020-06-26 | Montcalm | Michigan | 26117 | 87 | 1 |
272622 | 272622 | 2020-06-25 | Montcalm | Michigan | 26117 | 85 | 1 |
269485 | 269485 | 2020-06-24 | Montcalm | Michigan | 26117 | 85 | 1 |
266352 | 266352 | 2020-06-23 | Montcalm | Michigan | 26117 | 85 | 1 |
263226 | 263226 | 2020-06-22 | Montcalm | Michigan | 26117 | 85 | 1 |
260097 | 260097 | 2020-06-21 | Montcalm | Michigan | 26117 | 85 | 1 |
256971 | 256971 | 2020-06-20 | Montcalm | Michigan | 26117 | 85 | 1 |
253851 | 253851 | 2020-06-19 | Montcalm | Michigan | 26117 | 83 | 1 |
250736 | 250736 | 2020-06-18 | Montcalm | Michigan | 26117 | 83 | 1 |
247624 | 247624 | 2020-06-17 | Montcalm | Michigan | 26117 | 83 | 1 |
244511 | 244511 | 2020-06-16 | Montcalm | Michigan | 26117 | 83 | 1 |
241400 | 241400 | 2020-06-15 | Montcalm | Michigan | 26117 | 82 | 1 |
238291 | 238291 | 2020-06-14 | Montcalm | Michigan | 26117 | 82 | 1 |
235184 | 235184 | 2020-06-13 | Montcalm | Michigan | 26117 | 82 | 1 |
232079 | 232079 | 2020-06-12 | Montcalm | Michigan | 26117 | 82 | 1 |
228975 | 228975 | 2020-06-11 | Montcalm | Michigan | 26117 | 83 | 1 |
225873 | 225873 | 2020-06-10 | Montcalm | Michigan | 26117 | 83 | 1 |
222775 | 222775 | 2020-06-09 | Montcalm | Michigan | 26117 | 81 | 1 |
219680 | 219680 | 2020-06-08 | Montcalm | Michigan | 26117 | 80 | 1 |
216588 | 216588 | 2020-06-07 | Montcalm | Michigan | 26117 | 79 | 1 |
213500 | 213500 | 2020-06-06 | Montcalm | Michigan | 26117 | 78 | 1 |
210416 | 210416 | 2020-06-05 | Montcalm | Michigan | 26117 | 76 | 1 |
207335 | 207335 | 2020-06-04 | Montcalm | Michigan | 26117 | 71 | 1 |
204254 | 204254 | 2020-06-03 | Montcalm | Michigan | 26117 | 69 | 1 |
201177 | 201177 | 2020-06-02 | Montcalm | Michigan | 26117 | 68 | 1 |
198104 | 198104 | 2020-06-01 | Montcalm | Michigan | 26117 | 68 | 1 |
195033 | 195033 | 2020-05-31 | Montcalm | Michigan | 26117 | 68 | 1 |
191965 | 191965 | 2020-05-30 | Montcalm | Michigan | 26117 | 67 | 1 |
188901 | 188901 | 2020-05-29 | Montcalm | Michigan | 26117 | 67 | 1 |
185843 | 185843 | 2020-05-28 | Montcalm | Michigan | 26117 | 67 | 1 |
182788 | 182788 | 2020-05-27 | Montcalm | Michigan | 26117 | 67 | 1 |
179742 | 179742 | 2020-05-26 | Montcalm | Michigan | 26117 | 67 | 1 |
176698 | 176698 | 2020-05-25 | Montcalm | Michigan | 26117 | 67 | 1 |
173655 | 173655 | 2020-05-24 | Montcalm | Michigan | 26117 | 67 | 1 |
170613 | 170613 | 2020-05-23 | Montcalm | Michigan | 26117 | 68 | 1 |
167576 | 167576 | 2020-05-22 | Montcalm | Michigan | 26117 | 65 | 1 |
164540 | 164540 | 2020-05-21 | Montcalm | Michigan | 26117 | 64 | 1 |
161511 | 161511 | 2020-05-20 | Montcalm | Michigan | 26117 | 62 | 1 |
158485 | 158485 | 2020-05-19 | Montcalm | Michigan | 26117 | 58 | 1 |
155467 | 155467 | 2020-05-18 | Montcalm | Michigan | 26117 | 57 | 1 |
152453 | 152453 | 2020-05-17 | Montcalm | Michigan | 26117 | 53 | 1 |
149442 | 149442 | 2020-05-16 | Montcalm | Michigan | 26117 | 53 | 1 |
146437 | 146437 | 2020-05-15 | Montcalm | Michigan | 26117 | 52 | 1 |
143437 | 143437 | 2020-05-14 | Montcalm | Michigan | 26117 | 52 | 1 |
140442 | 140442 | 2020-05-13 | Montcalm | Michigan | 26117 | 52 | 1 |
137448 | 137448 | 2020-05-12 | Montcalm | Michigan | 26117 | 47 | 1 |
134458 | 134458 | 2020-05-11 | Montcalm | Michigan | 26117 | 46 | 1 |
131467 | 131467 | 2020-05-10 | Montcalm | Michigan | 26117 | 46 | 1 |
128477 | 128477 | 2020-05-09 | Montcalm | Michigan | 26117 | 46 | 1 |
125490 | 125490 | 2020-05-08 | Montcalm | Michigan | 26117 | 46 | 1 |
122508 | 122508 | 2020-05-07 | Montcalm | Michigan | 26117 | 46 | 1 |
119536 | 119536 | 2020-05-06 | Montcalm | Michigan | 26117 | 46 | 1 |
116575 | 116575 | 2020-05-05 | Montcalm | Michigan | 26117 | 46 | 1 |
113694 | 113694 | 2020-05-04 | Montcalm | Michigan | 26117 | 45 | 1 |
110816 | 110816 | 2020-05-03 | Montcalm | Michigan | 26117 | 44 | 1 |
107944 | 107944 | 2020-05-02 | Montcalm | Michigan | 26117 | 45 | 1 |
105080 | 105080 | 2020-05-01 | Montcalm | Michigan | 26117 | 40 | 1 |
102220 | 102220 | 2020-04-30 | Montcalm | Michigan | 26117 | 40 | 1 |
99368 | 99368 | 2020-04-29 | Montcalm | Michigan | 26117 | 38 | 1 |
96522 | 96522 | 2020-04-28 | Montcalm | Michigan | 26117 | 37 | 1 |
93687 | 93687 | 2020-04-27 | Montcalm | Michigan | 26117 | 32 | 1 |
90866 | 90866 | 2020-04-26 | Montcalm | Michigan | 26117 | 32 | 1 |
88050 | 88050 | 2020-04-25 | Montcalm | Michigan | 26117 | 29 | 1 |
85240 | 85240 | 2020-04-24 | Montcalm | Michigan | 26117 | 28 | 1 |
82436 | 82436 | 2020-04-23 | Montcalm | Michigan | 26117 | 28 | 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);