ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Nicollet" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387310 | 387310 | 2020-07-31 | Nicollet | Minnesota | 27103 | 298 | 13 |
384092 | 384092 | 2020-07-30 | Nicollet | Minnesota | 27103 | 287 | 13 |
380875 | 380875 | 2020-07-29 | Nicollet | Minnesota | 27103 | 281 | 13 |
377658 | 377658 | 2020-07-28 | Nicollet | Minnesota | 27103 | 271 | 13 |
374443 | 374443 | 2020-07-27 | Nicollet | Minnesota | 27103 | 270 | 13 |
371231 | 371231 | 2020-07-26 | Nicollet | Minnesota | 27103 | 266 | 13 |
368021 | 368021 | 2020-07-25 | Nicollet | Minnesota | 27103 | 262 | 13 |
364813 | 364813 | 2020-07-24 | Nicollet | Minnesota | 27103 | 252 | 13 |
361606 | 361606 | 2020-07-23 | Nicollet | Minnesota | 27103 | 249 | 13 |
358401 | 358401 | 2020-07-22 | Nicollet | Minnesota | 27103 | 243 | 13 |
355198 | 355198 | 2020-07-21 | Nicollet | Minnesota | 27103 | 238 | 13 |
351996 | 351996 | 2020-07-20 | Nicollet | Minnesota | 27103 | 226 | 13 |
348796 | 348796 | 2020-07-19 | Nicollet | Minnesota | 27103 | 225 | 13 |
345595 | 345595 | 2020-07-18 | Nicollet | Minnesota | 27103 | 220 | 13 |
342395 | 342395 | 2020-07-17 | Nicollet | Minnesota | 27103 | 218 | 13 |
339199 | 339199 | 2020-07-16 | Nicollet | Minnesota | 27103 | 219 | 13 |
336003 | 336003 | 2020-07-15 | Nicollet | Minnesota | 27103 | 215 | 13 |
332810 | 332810 | 2020-07-14 | Nicollet | Minnesota | 27103 | 212 | 12 |
329623 | 329623 | 2020-07-13 | Nicollet | Minnesota | 27103 | 207 | 12 |
326437 | 326437 | 2020-07-12 | Nicollet | Minnesota | 27103 | 206 | 12 |
323254 | 323254 | 2020-07-11 | Nicollet | Minnesota | 27103 | 203 | 12 |
320075 | 320075 | 2020-07-10 | Nicollet | Minnesota | 27103 | 191 | 12 |
316900 | 316900 | 2020-07-09 | Nicollet | Minnesota | 27103 | 187 | 12 |
313726 | 313726 | 2020-07-08 | Nicollet | Minnesota | 27103 | 176 | 12 |
310556 | 310556 | 2020-07-07 | Nicollet | Minnesota | 27103 | 173 | 12 |
307388 | 307388 | 2020-07-06 | Nicollet | Minnesota | 27103 | 169 | 12 |
304221 | 304221 | 2020-07-05 | Nicollet | Minnesota | 27103 | 166 | 12 |
301057 | 301057 | 2020-07-04 | Nicollet | Minnesota | 27103 | 159 | 12 |
297894 | 297894 | 2020-07-03 | Nicollet | Minnesota | 27103 | 159 | 12 |
294736 | 294736 | 2020-07-02 | Nicollet | Minnesota | 27103 | 155 | 12 |
291582 | 291582 | 2020-07-01 | Nicollet | Minnesota | 27103 | 149 | 12 |
288431 | 288431 | 2020-06-30 | Nicollet | Minnesota | 27103 | 144 | 12 |
285281 | 285281 | 2020-06-29 | Nicollet | Minnesota | 27103 | 136 | 12 |
282136 | 282136 | 2020-06-28 | Nicollet | Minnesota | 27103 | 128 | 12 |
278988 | 278988 | 2020-06-27 | Nicollet | Minnesota | 27103 | 123 | 12 |
275840 | 275840 | 2020-06-26 | Nicollet | Minnesota | 27103 | 120 | 12 |
272697 | 272697 | 2020-06-25 | Nicollet | Minnesota | 27103 | 115 | 12 |
269560 | 269560 | 2020-06-24 | Nicollet | Minnesota | 27103 | 112 | 12 |
266427 | 266427 | 2020-06-23 | Nicollet | Minnesota | 27103 | 109 | 12 |
263301 | 263301 | 2020-06-22 | Nicollet | Minnesota | 27103 | 109 | 12 |
260172 | 260172 | 2020-06-21 | Nicollet | Minnesota | 27103 | 108 | 12 |
257046 | 257046 | 2020-06-20 | Nicollet | Minnesota | 27103 | 107 | 12 |
253926 | 253926 | 2020-06-19 | Nicollet | Minnesota | 27103 | 105 | 12 |
250811 | 250811 | 2020-06-18 | Nicollet | Minnesota | 27103 | 98 | 12 |
247699 | 247699 | 2020-06-17 | Nicollet | Minnesota | 27103 | 95 | 11 |
244586 | 244586 | 2020-06-16 | Nicollet | Minnesota | 27103 | 95 | 11 |
241475 | 241475 | 2020-06-15 | Nicollet | Minnesota | 27103 | 95 | 11 |
238366 | 238366 | 2020-06-14 | Nicollet | Minnesota | 27103 | 95 | 11 |
235259 | 235259 | 2020-06-13 | Nicollet | Minnesota | 27103 | 95 | 11 |
232153 | 232153 | 2020-06-12 | Nicollet | Minnesota | 27103 | 95 | 11 |
229049 | 229049 | 2020-06-11 | Nicollet | Minnesota | 27103 | 93 | 11 |
225947 | 225947 | 2020-06-10 | Nicollet | Minnesota | 27103 | 93 | 11 |
222849 | 222849 | 2020-06-09 | Nicollet | Minnesota | 27103 | 91 | 11 |
219754 | 219754 | 2020-06-08 | Nicollet | Minnesota | 27103 | 90 | 11 |
216662 | 216662 | 2020-06-07 | Nicollet | Minnesota | 27103 | 89 | 11 |
213574 | 213574 | 2020-06-06 | Nicollet | Minnesota | 27103 | 89 | 11 |
210490 | 210490 | 2020-06-05 | Nicollet | Minnesota | 27103 | 88 | 11 |
207409 | 207409 | 2020-06-04 | Nicollet | Minnesota | 27103 | 88 | 11 |
204328 | 204328 | 2020-06-03 | Nicollet | Minnesota | 27103 | 88 | 10 |
201251 | 201251 | 2020-06-02 | Nicollet | Minnesota | 27103 | 88 | 10 |
198178 | 198178 | 2020-06-01 | Nicollet | Minnesota | 27103 | 88 | 10 |
195107 | 195107 | 2020-05-31 | Nicollet | Minnesota | 27103 | 87 | 10 |
192039 | 192039 | 2020-05-30 | Nicollet | Minnesota | 27103 | 86 | 10 |
188975 | 188975 | 2020-05-29 | Nicollet | Minnesota | 27103 | 83 | 9 |
185917 | 185917 | 2020-05-28 | Nicollet | Minnesota | 27103 | 82 | 7 |
182862 | 182862 | 2020-05-27 | Nicollet | Minnesota | 27103 | 74 | 7 |
179816 | 179816 | 2020-05-26 | Nicollet | Minnesota | 27103 | 71 | 6 |
176772 | 176772 | 2020-05-25 | Nicollet | Minnesota | 27103 | 69 | 5 |
173729 | 173729 | 2020-05-24 | Nicollet | Minnesota | 27103 | 68 | 3 |
170687 | 170687 | 2020-05-23 | Nicollet | Minnesota | 27103 | 64 | 3 |
167649 | 167649 | 2020-05-22 | Nicollet | Minnesota | 27103 | 63 | 3 |
164613 | 164613 | 2020-05-21 | Nicollet | Minnesota | 27103 | 51 | 3 |
161584 | 161584 | 2020-05-20 | Nicollet | Minnesota | 27103 | 44 | 3 |
158558 | 158558 | 2020-05-19 | Nicollet | Minnesota | 27103 | 43 | 3 |
155540 | 155540 | 2020-05-18 | Nicollet | Minnesota | 27103 | 39 | 3 |
152526 | 152526 | 2020-05-17 | Nicollet | Minnesota | 27103 | 37 | 3 |
149515 | 149515 | 2020-05-16 | Nicollet | Minnesota | 27103 | 33 | 2 |
146510 | 146510 | 2020-05-15 | Nicollet | Minnesota | 27103 | 28 | 2 |
143510 | 143510 | 2020-05-14 | Nicollet | Minnesota | 27103 | 23 | 2 |
140515 | 140515 | 2020-05-13 | Nicollet | Minnesota | 27103 | 22 | 2 |
137521 | 137521 | 2020-05-12 | Nicollet | Minnesota | 27103 | 22 | 2 |
134531 | 134531 | 2020-05-11 | Nicollet | Minnesota | 27103 | 21 | 2 |
131540 | 131540 | 2020-05-10 | Nicollet | Minnesota | 27103 | 21 | 2 |
128550 | 128550 | 2020-05-09 | Nicollet | Minnesota | 27103 | 21 | 2 |
125563 | 125563 | 2020-05-08 | Nicollet | Minnesota | 27103 | 18 | 2 |
122581 | 122581 | 2020-05-07 | Nicollet | Minnesota | 27103 | 18 | 2 |
119607 | 119607 | 2020-05-06 | Nicollet | Minnesota | 27103 | 17 | 2 |
116647 | 116647 | 2020-05-05 | Nicollet | Minnesota | 27103 | 16 | 2 |
113766 | 113766 | 2020-05-04 | Nicollet | Minnesota | 27103 | 16 | 2 |
110887 | 110887 | 2020-05-03 | Nicollet | Minnesota | 27103 | 15 | 2 |
108016 | 108016 | 2020-05-02 | Nicollet | Minnesota | 27103 | 15 | 2 |
105151 | 105151 | 2020-05-01 | Nicollet | Minnesota | 27103 | 13 | 2 |
102290 | 102290 | 2020-04-30 | Nicollet | Minnesota | 27103 | 11 | 2 |
99438 | 99438 | 2020-04-29 | Nicollet | Minnesota | 27103 | 9 | 2 |
96592 | 96592 | 2020-04-28 | Nicollet | Minnesota | 27103 | 9 | 2 |
93757 | 93757 | 2020-04-27 | Nicollet | Minnesota | 27103 | 9 | 2 |
90936 | 90936 | 2020-04-26 | Nicollet | Minnesota | 27103 | 9 | 2 |
88120 | 88120 | 2020-04-25 | Nicollet | Minnesota | 27103 | 9 | 2 |
85310 | 85310 | 2020-04-24 | Nicollet | Minnesota | 27103 | 8 | 2 |
82506 | 82506 | 2020-04-23 | Nicollet | Minnesota | 27103 | 8 | 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);