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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
287942 | 287942 | 2020-06-30 | Scott | Iowa | 19163 | 639 | 10 |
291092 | 291092 | 2020-07-01 | Scott | Iowa | 19163 | 673 | 10 |
294246 | 294246 | 2020-07-02 | Scott | Iowa | 19163 | 704 | 10 |
297404 | 297404 | 2020-07-03 | Scott | Iowa | 19163 | 748 | 10 |
300566 | 300566 | 2020-07-04 | Scott | Iowa | 19163 | 786 | 10 |
303730 | 303730 | 2020-07-05 | Scott | Iowa | 19163 | 799 | 10 |
306895 | 306895 | 2020-07-06 | Scott | Iowa | 19163 | 816 | 10 |
310063 | 310063 | 2020-07-07 | Scott | Iowa | 19163 | 845 | 10 |
313233 | 313233 | 2020-07-08 | Scott | Iowa | 19163 | 896 | 10 |
316407 | 316407 | 2020-07-09 | Scott | Iowa | 19163 | 935 | 10 |
319580 | 319580 | 2020-07-10 | Scott | Iowa | 19163 | 1004 | 10 |
322759 | 322759 | 2020-07-11 | Scott | Iowa | 19163 | 1037 | 10 |
325940 | 325940 | 2020-07-12 | Scott | Iowa | 19163 | 1084 | 10 |
329126 | 329126 | 2020-07-13 | Scott | Iowa | 19163 | 1098 | 10 |
332313 | 332313 | 2020-07-14 | Scott | Iowa | 19163 | 1126 | 10 |
335506 | 335506 | 2020-07-15 | Scott | Iowa | 19163 | 1174 | 10 |
338702 | 338702 | 2020-07-16 | Scott | Iowa | 19163 | 1226 | 10 |
341898 | 341898 | 2020-07-17 | Scott | Iowa | 19163 | 1254 | 10 |
345098 | 345098 | 2020-07-18 | Scott | Iowa | 19163 | 1277 | 10 |
348299 | 348299 | 2020-07-19 | Scott | Iowa | 19163 | 1290 | 10 |
351499 | 351499 | 2020-07-20 | Scott | Iowa | 19163 | 1318 | 11 |
354701 | 354701 | 2020-07-21 | Scott | Iowa | 19163 | 1335 | 11 |
357903 | 357903 | 2020-07-22 | Scott | Iowa | 19163 | 1365 | 11 |
361108 | 361108 | 2020-07-23 | Scott | Iowa | 19163 | 1398 | 11 |
364315 | 364315 | 2020-07-24 | Scott | Iowa | 19163 | 1434 | 11 |
367522 | 367522 | 2020-07-25 | Scott | Iowa | 19163 | 1458 | 11 |
370732 | 370732 | 2020-07-26 | Scott | Iowa | 19163 | 1483 | 11 |
373944 | 373944 | 2020-07-27 | Scott | Iowa | 19163 | 1491 | 11 |
377159 | 377159 | 2020-07-28 | Scott | Iowa | 19163 | 1500 | 11 |
380376 | 380376 | 2020-07-29 | Scott | Iowa | 19163 | 1525 | 11 |
383593 | 383593 | 2020-07-30 | Scott | Iowa | 19163 | 1542 | 11 |
386811 | 386811 | 2020-07-31 | Scott | Iowa | 19163 | 1557 | 12 |
390028 | 390028 | 2020-08-01 | Scott | Iowa | 19163 | 1576 | 12 |
393245 | 393245 | 2020-08-02 | Scott | Iowa | 19163 | 1590 | 12 |
396461 | 396461 | 2020-08-03 | Scott | Iowa | 19163 | 1593 | 12 |
399677 | 399677 | 2020-08-04 | Scott | Iowa | 19163 | 1615 | 12 |
402893 | 402893 | 2020-08-05 | Scott | Iowa | 19163 | 1636 | 13 |
406111 | 406111 | 2020-08-06 | Scott | Iowa | 19163 | 1655 | 14 |
409331 | 409331 | 2020-08-07 | Scott | Iowa | 19163 | 1662 | 14 |
412550 | 412550 | 2020-08-08 | Scott | Iowa | 19163 | 1705 | 14 |
415770 | 415770 | 2020-08-09 | Scott | Iowa | 19163 | 1718 | 14 |
418991 | 418991 | 2020-08-10 | Scott | Iowa | 19163 | 1727 | 14 |
422214 | 422214 | 2020-08-11 | Scott | Iowa | 19163 | 1743 | 14 |
425435 | 425435 | 2020-08-12 | Scott | Iowa | 19163 | 1758 | 14 |
428659 | 428659 | 2020-08-13 | Scott | Iowa | 19163 | 1784 | 15 |
431887 | 431887 | 2020-08-14 | Scott | Iowa | 19163 | 1809 | 15 |
435112 | 435112 | 2020-08-15 | Scott | Iowa | 19163 | 1842 | 15 |
438338 | 438338 | 2020-08-16 | Scott | Iowa | 19163 | 1853 | 15 |
441564 | 441564 | 2020-08-17 | Scott | Iowa | 19163 | 1863 | 16 |
444790 | 444790 | 2020-08-18 | Scott | Iowa | 19163 | 1874 | 17 |
448017 | 448017 | 2020-08-19 | Scott | Iowa | 19163 | 1903 | 17 |
451245 | 451245 | 2020-08-20 | Scott | Iowa | 19163 | 1933 | 17 |
454473 | 454473 | 2020-08-21 | Scott | Iowa | 19163 | 1970 | 18 |
457701 | 457701 | 2020-08-22 | Scott | Iowa | 19163 | 1992 | 18 |
467386 | 467386 | 2020-08-25 | Scott | Iowa | 19163 | 2025 | 18 |
460928 | 460928 | 2020-08-23 | Scott | Iowa | 19163 | 2002 | 19 |
464157 | 464157 | 2020-08-24 | Scott | Iowa | 19163 | 2015 | 19 |
470615 | 470615 | 2020-08-26 | Scott | Iowa | 19163 | 2061 | 19 |
473847 | 473847 | 2020-08-27 | Scott | Iowa | 19163 | 2110 | 19 |
477080 | 477080 | 2020-08-28 | Scott | Iowa | 19163 | 2146 | 20 |
480313 | 480313 | 2020-08-29 | Scott | Iowa | 19163 | 2180 | 20 |
483547 | 483547 | 2020-08-30 | Scott | Iowa | 19163 | 2208 | 21 |
486782 | 486782 | 2020-08-31 | Scott | Iowa | 19163 | 2238 | 21 |
490015 | 490015 | 2020-09-01 | Scott | Iowa | 19163 | 2249 | 21 |
493248 | 493248 | 2020-09-02 | Scott | Iowa | 19163 | 2259 | 21 |
496482 | 496482 | 2020-09-03 | Scott | Iowa | 19163 | 2300 | 21 |
499715 | 499715 | 2020-09-04 | Scott | Iowa | 19163 | 2334 | 22 |
502949 | 502949 | 2020-09-05 | Scott | Iowa | 19163 | 2363 | 23 |
506183 | 506183 | 2020-09-06 | Scott | Iowa | 19163 | 2381 | 23 |
509415 | 509415 | 2020-09-07 | Scott | Iowa | 19163 | 2383 | 23 |
512648 | 512648 | 2020-09-08 | Scott | Iowa | 19163 | 2392 | 23 |
515881 | 515881 | 2020-09-09 | Scott | Iowa | 19163 | 2409 | 24 |
519116 | 519116 | 2020-09-10 | Scott | Iowa | 19163 | 2447 | 25 |
522353 | 522353 | 2020-09-11 | Scott | Iowa | 19163 | 2490 | 25 |
525589 | 525589 | 2020-09-12 | Scott | Iowa | 19163 | 2512 | 25 |
528825 | 528825 | 2020-09-13 | Scott | Iowa | 19163 | 2525 | 25 |
532062 | 532062 | 2020-09-14 | Scott | Iowa | 19163 | 2534 | 26 |
535297 | 535297 | 2020-09-15 | Scott | Iowa | 19163 | 2550 | 26 |
538533 | 538533 | 2020-09-16 | Scott | Iowa | 19163 | 2601 | 26 |
541770 | 541770 | 2020-09-17 | Scott | Iowa | 19163 | 2647 | 27 |
545006 | 545006 | 2020-09-18 | Scott | Iowa | 19163 | 2711 | 27 |
548244 | 548244 | 2020-09-19 | Scott | Iowa | 19163 | 2765 | 27 |
551483 | 551483 | 2020-09-20 | Scott | Iowa | 19163 | 2797 | 27 |
554722 | 554722 | 2020-09-21 | Scott | Iowa | 19163 | 2818 | 27 |
557959 | 557959 | 2020-09-22 | Scott | Iowa | 19163 | 2836 | 28 |
561195 | 561195 | 2020-09-23 | Scott | Iowa | 19163 | 2879 | 28 |
564435 | 564435 | 2020-09-24 | Scott | Iowa | 19163 | 2927 | 28 |
567675 | 567675 | 2020-09-25 | Scott | Iowa | 19163 | 2971 | 28 |
570917 | 570917 | 2020-09-26 | Scott | Iowa | 19163 | 3011 | 28 |
574160 | 574160 | 2020-09-27 | Scott | Iowa | 19163 | 3020 | 28 |
577402 | 577402 | 2020-09-28 | Scott | Iowa | 19163 | 3045 | 28 |
580643 | 580643 | 2020-09-29 | Scott | Iowa | 19163 | 3095 | 28 |
583882 | 583882 | 2020-09-30 | Scott | Iowa | 19163 | 3128 | 29 |
587122 | 587122 | 2020-10-01 | Scott | Iowa | 19163 | 3193 | 29 |
590363 | 590363 | 2020-10-02 | Scott | Iowa | 19163 | 3254 | 29 |
593604 | 593604 | 2020-10-03 | Scott | Iowa | 19163 | 3299 | 29 |
596846 | 596846 | 2020-10-04 | Scott | Iowa | 19163 | 3311 | 29 |
600088 | 600088 | 2020-10-05 | Scott | Iowa | 19163 | 3327 | 29 |
603331 | 603331 | 2020-10-06 | Scott | Iowa | 19163 | 3362 | 29 |
606573 | 606573 | 2020-10-07 | Scott | Iowa | 19163 | 3407 | 29 |
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);