ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Scott" and fips = 19163 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386811 | 386811 | 2020-07-31 | Scott | Iowa | 19163 | 1557 | 12 |
383593 | 383593 | 2020-07-30 | Scott | Iowa | 19163 | 1542 | 11 |
380376 | 380376 | 2020-07-29 | Scott | Iowa | 19163 | 1525 | 11 |
377159 | 377159 | 2020-07-28 | Scott | Iowa | 19163 | 1500 | 11 |
373944 | 373944 | 2020-07-27 | Scott | Iowa | 19163 | 1491 | 11 |
370732 | 370732 | 2020-07-26 | Scott | Iowa | 19163 | 1483 | 11 |
367522 | 367522 | 2020-07-25 | Scott | Iowa | 19163 | 1458 | 11 |
364315 | 364315 | 2020-07-24 | Scott | Iowa | 19163 | 1434 | 11 |
361108 | 361108 | 2020-07-23 | Scott | Iowa | 19163 | 1398 | 11 |
357903 | 357903 | 2020-07-22 | Scott | Iowa | 19163 | 1365 | 11 |
354701 | 354701 | 2020-07-21 | Scott | Iowa | 19163 | 1335 | 11 |
351499 | 351499 | 2020-07-20 | Scott | Iowa | 19163 | 1318 | 11 |
348299 | 348299 | 2020-07-19 | Scott | Iowa | 19163 | 1290 | 10 |
345098 | 345098 | 2020-07-18 | Scott | Iowa | 19163 | 1277 | 10 |
341898 | 341898 | 2020-07-17 | Scott | Iowa | 19163 | 1254 | 10 |
338702 | 338702 | 2020-07-16 | Scott | Iowa | 19163 | 1226 | 10 |
335506 | 335506 | 2020-07-15 | Scott | Iowa | 19163 | 1174 | 10 |
332313 | 332313 | 2020-07-14 | Scott | Iowa | 19163 | 1126 | 10 |
329126 | 329126 | 2020-07-13 | Scott | Iowa | 19163 | 1098 | 10 |
325940 | 325940 | 2020-07-12 | Scott | Iowa | 19163 | 1084 | 10 |
322759 | 322759 | 2020-07-11 | Scott | Iowa | 19163 | 1037 | 10 |
319580 | 319580 | 2020-07-10 | Scott | Iowa | 19163 | 1004 | 10 |
316407 | 316407 | 2020-07-09 | Scott | Iowa | 19163 | 935 | 10 |
313233 | 313233 | 2020-07-08 | Scott | Iowa | 19163 | 896 | 10 |
310063 | 310063 | 2020-07-07 | Scott | Iowa | 19163 | 845 | 10 |
306895 | 306895 | 2020-07-06 | Scott | Iowa | 19163 | 816 | 10 |
303730 | 303730 | 2020-07-05 | Scott | Iowa | 19163 | 799 | 10 |
300566 | 300566 | 2020-07-04 | Scott | Iowa | 19163 | 786 | 10 |
297404 | 297404 | 2020-07-03 | Scott | Iowa | 19163 | 748 | 10 |
294246 | 294246 | 2020-07-02 | Scott | Iowa | 19163 | 704 | 10 |
291092 | 291092 | 2020-07-01 | Scott | Iowa | 19163 | 673 | 10 |
287942 | 287942 | 2020-06-30 | Scott | Iowa | 19163 | 639 | 10 |
284793 | 284793 | 2020-06-29 | Scott | Iowa | 19163 | 618 | 10 |
281648 | 281648 | 2020-06-28 | Scott | Iowa | 19163 | 598 | 10 |
278500 | 278500 | 2020-06-27 | Scott | Iowa | 19163 | 580 | 10 |
275352 | 275352 | 2020-06-26 | Scott | Iowa | 19163 | 561 | 10 |
272210 | 272210 | 2020-06-25 | Scott | Iowa | 19163 | 516 | 10 |
269073 | 269073 | 2020-06-24 | Scott | Iowa | 19163 | 488 | 10 |
265943 | 265943 | 2020-06-23 | Scott | Iowa | 19163 | 460 | 10 |
262815 | 262815 | 2020-06-22 | Scott | Iowa | 19163 | 451 | 10 |
259688 | 259688 | 2020-06-21 | Scott | Iowa | 19163 | 447 | 10 |
256562 | 256562 | 2020-06-20 | Scott | Iowa | 19163 | 435 | 10 |
253442 | 253442 | 2020-06-19 | Scott | Iowa | 19163 | 431 | 10 |
250327 | 250327 | 2020-06-18 | Scott | Iowa | 19163 | 421 | 10 |
247215 | 247215 | 2020-06-17 | Scott | Iowa | 19163 | 417 | 10 |
244102 | 244102 | 2020-06-16 | Scott | Iowa | 19163 | 409 | 10 |
240991 | 240991 | 2020-06-15 | Scott | Iowa | 19163 | 407 | 10 |
237883 | 237883 | 2020-06-14 | Scott | Iowa | 19163 | 406 | 10 |
234776 | 234776 | 2020-06-13 | Scott | Iowa | 19163 | 407 | 10 |
231670 | 231670 | 2020-06-12 | Scott | Iowa | 19163 | 404 | 10 |
228567 | 228567 | 2020-06-11 | Scott | Iowa | 19163 | 400 | 10 |
225465 | 225465 | 2020-06-10 | Scott | Iowa | 19163 | 398 | 10 |
222370 | 222370 | 2020-06-09 | Scott | Iowa | 19163 | 393 | 10 |
219275 | 219275 | 2020-06-08 | Scott | Iowa | 19163 | 393 | 10 |
216183 | 216183 | 2020-06-07 | Scott | Iowa | 19163 | 388 | 10 |
213096 | 213096 | 2020-06-06 | Scott | Iowa | 19163 | 386 | 10 |
210011 | 210011 | 2020-06-05 | Scott | Iowa | 19163 | 385 | 10 |
206930 | 206930 | 2020-06-04 | Scott | Iowa | 19163 | 382 | 10 |
203850 | 203850 | 2020-06-03 | Scott | Iowa | 19163 | 369 | 10 |
200774 | 200774 | 2020-06-02 | Scott | Iowa | 19163 | 364 | 10 |
197701 | 197701 | 2020-06-01 | Scott | Iowa | 19163 | 362 | 10 |
194631 | 194631 | 2020-05-31 | Scott | Iowa | 19163 | 361 | 10 |
191564 | 191564 | 2020-05-30 | Scott | Iowa | 19163 | 359 | 10 |
188499 | 188499 | 2020-05-29 | Scott | Iowa | 19163 | 358 | 10 |
185441 | 185441 | 2020-05-28 | Scott | Iowa | 19163 | 355 | 10 |
182387 | 182387 | 2020-05-27 | Scott | Iowa | 19163 | 348 | 10 |
179342 | 179342 | 2020-05-26 | Scott | Iowa | 19163 | 341 | 9 |
176298 | 176298 | 2020-05-25 | Scott | Iowa | 19163 | 338 | 9 |
173254 | 173254 | 2020-05-24 | Scott | Iowa | 19163 | 334 | 9 |
170213 | 170213 | 2020-05-23 | Scott | Iowa | 19163 | 329 | 9 |
167176 | 167176 | 2020-05-22 | Scott | Iowa | 19163 | 329 | 9 |
164143 | 164143 | 2020-05-21 | Scott | Iowa | 19163 | 323 | 9 |
161115 | 161115 | 2020-05-20 | Scott | Iowa | 19163 | 320 | 8 |
158089 | 158089 | 2020-05-19 | Scott | Iowa | 19163 | 309 | 8 |
155072 | 155072 | 2020-05-18 | Scott | Iowa | 19163 | 309 | 8 |
152060 | 152060 | 2020-05-17 | Scott | Iowa | 19163 | 307 | 8 |
149049 | 149049 | 2020-05-16 | Scott | Iowa | 19163 | 301 | 8 |
146045 | 146045 | 2020-05-15 | Scott | Iowa | 19163 | 297 | 8 |
143045 | 143045 | 2020-05-14 | Scott | Iowa | 19163 | 293 | 8 |
140049 | 140049 | 2020-05-13 | Scott | Iowa | 19163 | 291 | 8 |
137056 | 137056 | 2020-05-12 | Scott | Iowa | 19163 | 286 | 8 |
134066 | 134066 | 2020-05-11 | Scott | Iowa | 19163 | 286 | 8 |
131076 | 131076 | 2020-05-10 | Scott | Iowa | 19163 | 280 | 8 |
128085 | 128085 | 2020-05-09 | Scott | Iowa | 19163 | 279 | 8 |
125098 | 125098 | 2020-05-08 | Scott | Iowa | 19163 | 276 | 8 |
122116 | 122116 | 2020-05-07 | Scott | Iowa | 19163 | 274 | 7 |
119146 | 119146 | 2020-05-06 | Scott | Iowa | 19163 | 260 | 7 |
116186 | 116186 | 2020-05-05 | Scott | Iowa | 19163 | 255 | 7 |
113303 | 113303 | 2020-05-04 | Scott | Iowa | 19163 | 245 | 7 |
110428 | 110428 | 2020-05-03 | Scott | Iowa | 19163 | 241 | 7 |
107557 | 107557 | 2020-05-02 | Scott | Iowa | 19163 | 236 | 7 |
104692 | 104692 | 2020-05-01 | Scott | Iowa | 19163 | 230 | 7 |
101833 | 101833 | 2020-04-30 | Scott | Iowa | 19163 | 226 | 6 |
98982 | 98982 | 2020-04-29 | Scott | Iowa | 19163 | 222 | 5 |
96137 | 96137 | 2020-04-28 | Scott | Iowa | 19163 | 218 | 5 |
93305 | 93305 | 2020-04-27 | Scott | Iowa | 19163 | 216 | 5 |
90485 | 90485 | 2020-04-26 | Scott | Iowa | 19163 | 209 | 5 |
87669 | 87669 | 2020-04-25 | Scott | Iowa | 19163 | 207 | 5 |
84859 | 84859 | 2020-04-24 | Scott | Iowa | 19163 | 197 | 4 |
82059 | 82059 | 2020-04-23 | Scott | Iowa | 19163 | 189 | 3 |
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);