ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Scott" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387327 | 387327 | 2020-07-31 | Scott | Minnesota | 27139 | 1296 | 12 |
384109 | 384109 | 2020-07-30 | Scott | Minnesota | 27139 | 1272 | 11 |
380892 | 380892 | 2020-07-29 | Scott | Minnesota | 27139 | 1249 | 11 |
377675 | 377675 | 2020-07-28 | Scott | Minnesota | 27139 | 1217 | 11 |
374460 | 374460 | 2020-07-27 | Scott | Minnesota | 27139 | 1198 | 11 |
371248 | 371248 | 2020-07-26 | Scott | Minnesota | 27139 | 1176 | 11 |
368038 | 368038 | 2020-07-25 | Scott | Minnesota | 27139 | 1144 | 11 |
364830 | 364830 | 2020-07-24 | Scott | Minnesota | 27139 | 1119 | 10 |
361623 | 361623 | 2020-07-23 | Scott | Minnesota | 27139 | 1094 | 9 |
358418 | 358418 | 2020-07-22 | Scott | Minnesota | 27139 | 1072 | 8 |
355215 | 355215 | 2020-07-21 | Scott | Minnesota | 27139 | 1046 | 8 |
352013 | 352013 | 2020-07-20 | Scott | Minnesota | 27139 | 1022 | 8 |
348813 | 348813 | 2020-07-19 | Scott | Minnesota | 27139 | 1010 | 7 |
345612 | 345612 | 2020-07-18 | Scott | Minnesota | 27139 | 986 | 7 |
342412 | 342412 | 2020-07-17 | Scott | Minnesota | 27139 | 977 | 7 |
339216 | 339216 | 2020-07-16 | Scott | Minnesota | 27139 | 965 | 7 |
336020 | 336020 | 2020-07-15 | Scott | Minnesota | 27139 | 953 | 4 |
332827 | 332827 | 2020-07-14 | Scott | Minnesota | 27139 | 923 | 4 |
329640 | 329640 | 2020-07-13 | Scott | Minnesota | 27139 | 899 | 4 |
326454 | 326454 | 2020-07-12 | Scott | Minnesota | 27139 | 881 | 4 |
323271 | 323271 | 2020-07-11 | Scott | Minnesota | 27139 | 858 | 4 |
320092 | 320092 | 2020-07-10 | Scott | Minnesota | 27139 | 823 | 4 |
316917 | 316917 | 2020-07-09 | Scott | Minnesota | 27139 | 803 | 4 |
313743 | 313743 | 2020-07-08 | Scott | Minnesota | 27139 | 783 | 4 |
310573 | 310573 | 2020-07-07 | Scott | Minnesota | 27139 | 762 | 4 |
307405 | 307405 | 2020-07-06 | Scott | Minnesota | 27139 | 734 | 4 |
304238 | 304238 | 2020-07-05 | Scott | Minnesota | 27139 | 715 | 4 |
301074 | 301074 | 2020-07-04 | Scott | Minnesota | 27139 | 700 | 4 |
297911 | 297911 | 2020-07-03 | Scott | Minnesota | 27139 | 700 | 4 |
294753 | 294753 | 2020-07-02 | Scott | Minnesota | 27139 | 684 | 4 |
291599 | 291599 | 2020-07-01 | Scott | Minnesota | 27139 | 671 | 4 |
288448 | 288448 | 2020-06-30 | Scott | Minnesota | 27139 | 658 | 4 |
285298 | 285298 | 2020-06-29 | Scott | Minnesota | 27139 | 641 | 4 |
282153 | 282153 | 2020-06-28 | Scott | Minnesota | 27139 | 637 | 4 |
279005 | 279005 | 2020-06-27 | Scott | Minnesota | 27139 | 627 | 4 |
275857 | 275857 | 2020-06-26 | Scott | Minnesota | 27139 | 616 | 4 |
272714 | 272714 | 2020-06-25 | Scott | Minnesota | 27139 | 609 | 4 |
269577 | 269577 | 2020-06-24 | Scott | Minnesota | 27139 | 603 | 4 |
266444 | 266444 | 2020-06-23 | Scott | Minnesota | 27139 | 595 | 4 |
263318 | 263318 | 2020-06-22 | Scott | Minnesota | 27139 | 587 | 4 |
260189 | 260189 | 2020-06-21 | Scott | Minnesota | 27139 | 570 | 4 |
257063 | 257063 | 2020-06-20 | Scott | Minnesota | 27139 | 561 | 4 |
253943 | 253943 | 2020-06-19 | Scott | Minnesota | 27139 | 555 | 4 |
250828 | 250828 | 2020-06-18 | Scott | Minnesota | 27139 | 551 | 4 |
247716 | 247716 | 2020-06-17 | Scott | Minnesota | 27139 | 546 | 4 |
244603 | 244603 | 2020-06-16 | Scott | Minnesota | 27139 | 541 | 4 |
241492 | 241492 | 2020-06-15 | Scott | Minnesota | 27139 | 536 | 4 |
238383 | 238383 | 2020-06-14 | Scott | Minnesota | 27139 | 528 | 4 |
235276 | 235276 | 2020-06-13 | Scott | Minnesota | 27139 | 526 | 4 |
232170 | 232170 | 2020-06-12 | Scott | Minnesota | 27139 | 525 | 4 |
229066 | 229066 | 2020-06-11 | Scott | Minnesota | 27139 | 517 | 4 |
225964 | 225964 | 2020-06-10 | Scott | Minnesota | 27139 | 504 | 3 |
222866 | 222866 | 2020-06-09 | Scott | Minnesota | 27139 | 496 | 2 |
219771 | 219771 | 2020-06-08 | Scott | Minnesota | 27139 | 493 | 2 |
216679 | 216679 | 2020-06-07 | Scott | Minnesota | 27139 | 486 | 2 |
213591 | 213591 | 2020-06-06 | Scott | Minnesota | 27139 | 483 | 2 |
210507 | 210507 | 2020-06-05 | Scott | Minnesota | 27139 | 471 | 2 |
207426 | 207426 | 2020-06-04 | Scott | Minnesota | 27139 | 460 | 2 |
204345 | 204345 | 2020-06-03 | Scott | Minnesota | 27139 | 455 | 2 |
201268 | 201268 | 2020-06-02 | Scott | Minnesota | 27139 | 442 | 2 |
198195 | 198195 | 2020-06-01 | Scott | Minnesota | 27139 | 436 | 2 |
195124 | 195124 | 2020-05-31 | Scott | Minnesota | 27139 | 426 | 2 |
192056 | 192056 | 2020-05-30 | Scott | Minnesota | 27139 | 408 | 2 |
188992 | 188992 | 2020-05-29 | Scott | Minnesota | 27139 | 394 | 2 |
185934 | 185934 | 2020-05-28 | Scott | Minnesota | 27139 | 383 | 2 |
182879 | 182879 | 2020-05-27 | Scott | Minnesota | 27139 | 379 | 2 |
179833 | 179833 | 2020-05-26 | Scott | Minnesota | 27139 | 374 | 2 |
176789 | 176789 | 2020-05-25 | Scott | Minnesota | 27139 | 358 | 2 |
173746 | 173746 | 2020-05-24 | Scott | Minnesota | 27139 | 346 | 2 |
170704 | 170704 | 2020-05-23 | Scott | Minnesota | 27139 | 334 | 2 |
167666 | 167666 | 2020-05-22 | Scott | Minnesota | 27139 | 316 | 2 |
164630 | 164630 | 2020-05-21 | Scott | Minnesota | 27139 | 298 | 2 |
161601 | 161601 | 2020-05-20 | Scott | Minnesota | 27139 | 291 | 2 |
158575 | 158575 | 2020-05-19 | Scott | Minnesota | 27139 | 271 | 1 |
155557 | 155557 | 2020-05-18 | Scott | Minnesota | 27139 | 259 | 1 |
152543 | 152543 | 2020-05-17 | Scott | Minnesota | 27139 | 238 | 1 |
149532 | 149532 | 2020-05-16 | Scott | Minnesota | 27139 | 223 | 1 |
146527 | 146527 | 2020-05-15 | Scott | Minnesota | 27139 | 207 | 1 |
143527 | 143527 | 2020-05-14 | Scott | Minnesota | 27139 | 186 | 1 |
140532 | 140532 | 2020-05-13 | Scott | Minnesota | 27139 | 168 | 1 |
137538 | 137538 | 2020-05-12 | Scott | Minnesota | 27139 | 168 | 1 |
134548 | 134548 | 2020-05-11 | Scott | Minnesota | 27139 | 155 | 1 |
131557 | 131557 | 2020-05-10 | Scott | Minnesota | 27139 | 140 | 1 |
128567 | 128567 | 2020-05-09 | Scott | Minnesota | 27139 | 129 | 1 |
125580 | 125580 | 2020-05-08 | Scott | Minnesota | 27139 | 121 | 1 |
122598 | 122598 | 2020-05-07 | Scott | Minnesota | 27139 | 100 | 1 |
119624 | 119624 | 2020-05-06 | Scott | Minnesota | 27139 | 90 | 1 |
116664 | 116664 | 2020-05-05 | Scott | Minnesota | 27139 | 74 | 1 |
113782 | 113782 | 2020-05-04 | Scott | Minnesota | 27139 | 63 | 1 |
110903 | 110903 | 2020-05-03 | Scott | Minnesota | 27139 | 58 | 1 |
108032 | 108032 | 2020-05-02 | Scott | Minnesota | 27139 | 52 | 1 |
105167 | 105167 | 2020-05-01 | Scott | Minnesota | 27139 | 46 | 1 |
102306 | 102306 | 2020-04-30 | Scott | Minnesota | 27139 | 44 | 1 |
99454 | 99454 | 2020-04-29 | Scott | Minnesota | 27139 | 41 | 1 |
96608 | 96608 | 2020-04-28 | Scott | Minnesota | 27139 | 36 | 1 |
93773 | 93773 | 2020-04-27 | Scott | Minnesota | 27139 | 35 | 1 |
90952 | 90952 | 2020-04-26 | Scott | Minnesota | 27139 | 32 | 1 |
88136 | 88136 | 2020-04-25 | Scott | Minnesota | 27139 | 32 | 1 |
85326 | 85326 | 2020-04-24 | Scott | Minnesota | 27139 | 30 | 1 |
82522 | 82522 | 2020-04-23 | Scott | Minnesota | 27139 | 29 | 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);