ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 19163 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535297 | 535297 | 2020-09-15 | Scott | Iowa | 19163 | 2550 | 26 |
532062 | 532062 | 2020-09-14 | Scott | Iowa | 19163 | 2534 | 26 |
528825 | 528825 | 2020-09-13 | Scott | Iowa | 19163 | 2525 | 25 |
525589 | 525589 | 2020-09-12 | Scott | Iowa | 19163 | 2512 | 25 |
522353 | 522353 | 2020-09-11 | Scott | Iowa | 19163 | 2490 | 25 |
519116 | 519116 | 2020-09-10 | Scott | Iowa | 19163 | 2447 | 25 |
515881 | 515881 | 2020-09-09 | Scott | Iowa | 19163 | 2409 | 24 |
512648 | 512648 | 2020-09-08 | Scott | Iowa | 19163 | 2392 | 23 |
509415 | 509415 | 2020-09-07 | Scott | Iowa | 19163 | 2383 | 23 |
506183 | 506183 | 2020-09-06 | Scott | Iowa | 19163 | 2381 | 23 |
502949 | 502949 | 2020-09-05 | Scott | Iowa | 19163 | 2363 | 23 |
499715 | 499715 | 2020-09-04 | Scott | Iowa | 19163 | 2334 | 22 |
496482 | 496482 | 2020-09-03 | Scott | Iowa | 19163 | 2300 | 21 |
493248 | 493248 | 2020-09-02 | Scott | Iowa | 19163 | 2259 | 21 |
490015 | 490015 | 2020-09-01 | Scott | Iowa | 19163 | 2249 | 21 |
486782 | 486782 | 2020-08-31 | Scott | Iowa | 19163 | 2238 | 21 |
483547 | 483547 | 2020-08-30 | Scott | Iowa | 19163 | 2208 | 21 |
480313 | 480313 | 2020-08-29 | Scott | Iowa | 19163 | 2180 | 20 |
477080 | 477080 | 2020-08-28 | Scott | Iowa | 19163 | 2146 | 20 |
473847 | 473847 | 2020-08-27 | Scott | Iowa | 19163 | 2110 | 19 |
470615 | 470615 | 2020-08-26 | Scott | Iowa | 19163 | 2061 | 19 |
467386 | 467386 | 2020-08-25 | Scott | Iowa | 19163 | 2025 | 18 |
464157 | 464157 | 2020-08-24 | Scott | Iowa | 19163 | 2015 | 19 |
460928 | 460928 | 2020-08-23 | Scott | Iowa | 19163 | 2002 | 19 |
457701 | 457701 | 2020-08-22 | Scott | Iowa | 19163 | 1992 | 18 |
454473 | 454473 | 2020-08-21 | Scott | Iowa | 19163 | 1970 | 18 |
451245 | 451245 | 2020-08-20 | Scott | Iowa | 19163 | 1933 | 17 |
448017 | 448017 | 2020-08-19 | Scott | Iowa | 19163 | 1903 | 17 |
444790 | 444790 | 2020-08-18 | Scott | Iowa | 19163 | 1874 | 17 |
441564 | 441564 | 2020-08-17 | Scott | Iowa | 19163 | 1863 | 16 |
438338 | 438338 | 2020-08-16 | Scott | Iowa | 19163 | 1853 | 15 |
435112 | 435112 | 2020-08-15 | Scott | Iowa | 19163 | 1842 | 15 |
431887 | 431887 | 2020-08-14 | Scott | Iowa | 19163 | 1809 | 15 |
428659 | 428659 | 2020-08-13 | Scott | Iowa | 19163 | 1784 | 15 |
425435 | 425435 | 2020-08-12 | Scott | Iowa | 19163 | 1758 | 14 |
422214 | 422214 | 2020-08-11 | Scott | Iowa | 19163 | 1743 | 14 |
418991 | 418991 | 2020-08-10 | Scott | Iowa | 19163 | 1727 | 14 |
415770 | 415770 | 2020-08-09 | Scott | Iowa | 19163 | 1718 | 14 |
412550 | 412550 | 2020-08-08 | Scott | Iowa | 19163 | 1705 | 14 |
409331 | 409331 | 2020-08-07 | Scott | Iowa | 19163 | 1662 | 14 |
406111 | 406111 | 2020-08-06 | Scott | Iowa | 19163 | 1655 | 14 |
402893 | 402893 | 2020-08-05 | Scott | Iowa | 19163 | 1636 | 13 |
399677 | 399677 | 2020-08-04 | Scott | Iowa | 19163 | 1615 | 12 |
396461 | 396461 | 2020-08-03 | Scott | Iowa | 19163 | 1593 | 12 |
393245 | 393245 | 2020-08-02 | Scott | Iowa | 19163 | 1590 | 12 |
390028 | 390028 | 2020-08-01 | Scott | Iowa | 19163 | 1576 | 12 |
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 |
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);