ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Scott" and fips = 27139 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
79726 | 79726 | 2020-04-22 | Scott | Minnesota | 27139 | 28 | 1 |
76941 | 76941 | 2020-04-21 | Scott | Minnesota | 27139 | 27 | 1 |
74160 | 74160 | 2020-04-20 | Scott | Minnesota | 27139 | 27 | 1 |
71387 | 71387 | 2020-04-19 | Scott | Minnesota | 27139 | 25 | 1 |
68621 | 68621 | 2020-04-18 | Scott | Minnesota | 27139 | 23 | 1 |
65869 | 65869 | 2020-04-17 | Scott | Minnesota | 27139 | 23 | 1 |
63130 | 63130 | 2020-04-16 | Scott | Minnesota | 27139 | 20 | 1 |
60407 | 60407 | 2020-04-15 | Scott | Minnesota | 27139 | 20 | 1 |
57696 | 57696 | 2020-04-14 | Scott | Minnesota | 27139 | 20 | 1 |
54998 | 54998 | 2020-04-13 | Scott | Minnesota | 27139 | 20 | 1 |
52316 | 52316 | 2020-04-12 | Scott | Minnesota | 27139 | 20 | 1 |
49644 | 49644 | 2020-04-11 | Scott | Minnesota | 27139 | 20 | 1 |
46999 | 46999 | 2020-04-10 | Scott | Minnesota | 27139 | 19 | 1 |
44389 | 44389 | 2020-04-09 | Scott | Minnesota | 27139 | 19 | 1 |
41813 | 41813 | 2020-04-08 | Scott | Minnesota | 27139 | 17 | 1 |
39259 | 39259 | 2020-04-07 | Scott | Minnesota | 27139 | 16 | 1 |
36749 | 36749 | 2020-04-06 | Scott | Minnesota | 27139 | 15 | 1 |
34287 | 34287 | 2020-04-05 | Scott | Minnesota | 27139 | 13 | 1 |
31860 | 31860 | 2020-04-04 | Scott | Minnesota | 27139 | 12 | 1 |
29480 | 29480 | 2020-04-03 | Scott | Minnesota | 27139 | 11 | 1 |
27161 | 27161 | 2020-04-02 | Scott | Minnesota | 27139 | 10 | 0 |
24907 | 24907 | 2020-04-01 | Scott | Minnesota | 27139 | 10 | 0 |
22725 | 22725 | 2020-03-31 | Scott | Minnesota | 27139 | 10 | 0 |
20610 | 20610 | 2020-03-30 | Scott | Minnesota | 27139 | 10 | 0 |
18588 | 18588 | 2020-03-29 | Scott | Minnesota | 27139 | 9 | 0 |
16668 | 16668 | 2020-03-28 | Scott | Minnesota | 27139 | 8 | 0 |
14846 | 14846 | 2020-03-27 | Scott | Minnesota | 27139 | 7 | 0 |
13130 | 13130 | 2020-03-26 | Scott | Minnesota | 27139 | 6 | 0 |
11541 | 11541 | 2020-03-25 | Scott | Minnesota | 27139 | 6 | 0 |
10123 | 10123 | 2020-03-24 | Scott | Minnesota | 27139 | 5 | 0 |
8828 | 8828 | 2020-03-23 | Scott | Minnesota | 27139 | 5 | 0 |
7649 | 7649 | 2020-03-22 | Scott | Minnesota | 27139 | 3 | 0 |
6567 | 6567 | 2020-03-21 | Scott | Minnesota | 27139 | 2 | 0 |
5597 | 5597 | 2020-03-20 | Scott | Minnesota | 27139 | 2 | 0 |
4775 | 4775 | 2020-03-19 | Scott | Minnesota | 27139 | 1 | 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);