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 |
---|---|---|---|---|---|---|---|
931049 | 931049 | 2021-01-15 | Scott | Iowa | 19163 | 15300 | 161 |
927804 | 927804 | 2021-01-14 | Scott | Iowa | 19163 | 15228 | 161 |
924558 | 924558 | 2021-01-13 | Scott | Iowa | 19163 | 15133 | 158 |
921313 | 921313 | 2021-01-12 | Scott | Iowa | 19163 | 15081 | 156 |
918068 | 918068 | 2021-01-11 | Scott | Iowa | 19163 | 14992 | 155 |
914823 | 914823 | 2021-01-10 | Scott | Iowa | 19163 | 14965 | 155 |
911578 | 911578 | 2021-01-09 | Scott | Iowa | 19163 | 14951 | 154 |
908333 | 908333 | 2021-01-08 | Scott | Iowa | 19163 | 14871 | 154 |
905087 | 905087 | 2021-01-07 | Scott | Iowa | 19163 | 14794 | 153 |
901842 | 901842 | 2021-01-06 | Scott | Iowa | 19163 | 14557 | 153 |
898597 | 898597 | 2021-01-05 | Scott | Iowa | 19163 | 14393 | 153 |
895352 | 895352 | 2021-01-04 | Scott | Iowa | 19163 | 14366 | 153 |
892105 | 892105 | 2021-01-03 | Scott | Iowa | 19163 | 14293 | 152 |
888859 | 888859 | 2021-01-02 | Scott | Iowa | 19163 | 14264 | 152 |
885613 | 885613 | 2021-01-01 | Scott | Iowa | 19163 | 14197 | 152 |
882368 | 882368 | 2020-12-31 | Scott | Iowa | 19163 | 14110 | 152 |
879123 | 879123 | 2020-12-30 | Scott | Iowa | 19163 | 14016 | 147 |
875878 | 875878 | 2020-12-29 | Scott | Iowa | 19163 | 13976 | 147 |
872633 | 872633 | 2020-12-28 | Scott | Iowa | 19163 | 13845 | 147 |
869388 | 869388 | 2020-12-27 | Scott | Iowa | 19163 | 13822 | 147 |
866143 | 866143 | 2020-12-26 | Scott | Iowa | 19163 | 13800 | 146 |
862898 | 862898 | 2020-12-25 | Scott | Iowa | 19163 | 13763 | 146 |
859653 | 859653 | 2020-12-24 | Scott | Iowa | 19163 | 13725 | 146 |
856408 | 856408 | 2020-12-23 | Scott | Iowa | 19163 | 13660 | 142 |
853163 | 853163 | 2020-12-22 | Scott | Iowa | 19163 | 13598 | 141 |
849918 | 849918 | 2020-12-21 | Scott | Iowa | 19163 | 13534 | 139 |
846673 | 846673 | 2020-12-20 | Scott | Iowa | 19163 | 13501 | 139 |
843427 | 843427 | 2020-12-19 | Scott | Iowa | 19163 | 13467 | 136 |
840182 | 840182 | 2020-12-18 | Scott | Iowa | 19163 | 13337 | 128 |
836937 | 836937 | 2020-12-17 | Scott | Iowa | 19163 | 13197 | 128 |
833691 | 833691 | 2020-12-16 | Scott | Iowa | 19163 | 13149 | 121 |
830444 | 830444 | 2020-12-15 | Scott | Iowa | 19163 | 12998 | 120 |
827198 | 827198 | 2020-12-14 | Scott | Iowa | 19163 | 12952 | 118 |
823951 | 823951 | 2020-12-13 | Scott | Iowa | 19163 | 12929 | 116 |
820705 | 820705 | 2020-12-12 | Scott | Iowa | 19163 | 12819 | 116 |
817459 | 817459 | 2020-12-11 | Scott | Iowa | 19163 | 12739 | 116 |
814213 | 814213 | 2020-12-10 | Scott | Iowa | 19163 | 12610 | 113 |
810968 | 810968 | 2020-12-09 | Scott | Iowa | 19163 | 12468 | 108 |
807723 | 807723 | 2020-12-08 | Scott | Iowa | 19163 | 12281 | 104 |
804478 | 804478 | 2020-12-07 | Scott | Iowa | 19163 | 12269 | 100 |
801233 | 801233 | 2020-12-06 | Scott | Iowa | 19163 | 12228 | 99 |
797988 | 797988 | 2020-12-05 | Scott | Iowa | 19163 | 12101 | 95 |
794743 | 794743 | 2020-12-04 | Scott | Iowa | 19163 | 11966 | 95 |
791498 | 791498 | 2020-12-03 | Scott | Iowa | 19163 | 11847 | 92 |
788253 | 788253 | 2020-12-02 | Scott | Iowa | 19163 | 11661 | 89 |
785009 | 785009 | 2020-12-01 | Scott | Iowa | 19163 | 11530 | 87 |
781764 | 781764 | 2020-11-30 | Scott | Iowa | 19163 | 11328 | 87 |
778518 | 778518 | 2020-11-29 | Scott | Iowa | 19163 | 11248 | 86 |
775273 | 775273 | 2020-11-28 | Scott | Iowa | 19163 | 11163 | 85 |
772028 | 772028 | 2020-11-27 | Scott | Iowa | 19163 | 11002 | 84 |
768783 | 768783 | 2020-11-26 | Scott | Iowa | 19163 | 10856 | 83 |
765537 | 765537 | 2020-11-25 | Scott | Iowa | 19163 | 10689 | 81 |
762292 | 762292 | 2020-11-24 | Scott | Iowa | 19163 | 10560 | 81 |
759047 | 759047 | 2020-11-23 | Scott | Iowa | 19163 | 10403 | 75 |
755800 | 755800 | 2020-11-22 | Scott | Iowa | 19163 | 10220 | 75 |
752554 | 752554 | 2020-11-21 | Scott | Iowa | 19163 | 10087 | 75 |
749308 | 749308 | 2020-11-20 | Scott | Iowa | 19163 | 9830 | 69 |
746062 | 746062 | 2020-11-19 | Scott | Iowa | 19163 | 9490 | 68 |
742815 | 742815 | 2020-11-18 | Scott | Iowa | 19163 | 9208 | 66 |
739568 | 739568 | 2020-11-17 | Scott | Iowa | 19163 | 8964 | 64 |
736324 | 736324 | 2020-11-16 | Scott | Iowa | 19163 | 8748 | 60 |
733078 | 733078 | 2020-11-15 | Scott | Iowa | 19163 | 8642 | 58 |
729833 | 729833 | 2020-11-14 | Scott | Iowa | 19163 | 8452 | 58 |
726590 | 726590 | 2020-11-13 | Scott | Iowa | 19163 | 8069 | 58 |
723347 | 723347 | 2020-11-12 | Scott | Iowa | 19163 | 7778 | 56 |
720104 | 720104 | 2020-11-11 | Scott | Iowa | 19163 | 7351 | 54 |
716861 | 716861 | 2020-11-10 | Scott | Iowa | 19163 | 7066 | 54 |
713617 | 713617 | 2020-11-09 | Scott | Iowa | 19163 | 6812 | 52 |
710373 | 710373 | 2020-11-08 | Scott | Iowa | 19163 | 6614 | 51 |
707129 | 707129 | 2020-11-07 | Scott | Iowa | 19163 | 6288 | 51 |
703886 | 703886 | 2020-11-06 | Scott | Iowa | 19163 | 6064 | 51 |
700644 | 700644 | 2020-11-05 | Scott | Iowa | 19163 | 5885 | 51 |
697400 | 697400 | 2020-11-04 | Scott | Iowa | 19163 | 5521 | 51 |
694158 | 694158 | 2020-11-03 | Scott | Iowa | 19163 | 5422 | 50 |
690915 | 690915 | 2020-11-02 | Scott | Iowa | 19163 | 5343 | 48 |
687670 | 687670 | 2020-11-01 | Scott | Iowa | 19163 | 5277 | 45 |
684426 | 684426 | 2020-10-31 | Scott | Iowa | 19163 | 5167 | 43 |
681183 | 681183 | 2020-10-30 | Scott | Iowa | 19163 | 5026 | 43 |
677940 | 677940 | 2020-10-29 | Scott | Iowa | 19163 | 4899 | 43 |
674697 | 674697 | 2020-10-28 | Scott | Iowa | 19163 | 4766 | 42 |
671455 | 671455 | 2020-10-27 | Scott | Iowa | 19163 | 4684 | 41 |
668212 | 668212 | 2020-10-26 | Scott | Iowa | 19163 | 4566 | 39 |
664968 | 664968 | 2020-10-25 | Scott | Iowa | 19163 | 4541 | 38 |
661723 | 661723 | 2020-10-24 | Scott | Iowa | 19163 | 4454 | 38 |
658479 | 658479 | 2020-10-23 | Scott | Iowa | 19163 | 4350 | 38 |
655234 | 655234 | 2020-10-22 | Scott | Iowa | 19163 | 4280 | 37 |
651989 | 651989 | 2020-10-21 | Scott | Iowa | 19163 | 4141 | 37 |
648745 | 648745 | 2020-10-20 | Scott | Iowa | 19163 | 4108 | 37 |
645500 | 645500 | 2020-10-19 | Scott | Iowa | 19163 | 4042 | 34 |
642253 | 642253 | 2020-10-18 | Scott | Iowa | 19163 | 4024 | 33 |
639006 | 639006 | 2020-10-17 | Scott | Iowa | 19163 | 3985 | 33 |
635760 | 635760 | 2020-10-16 | Scott | Iowa | 19163 | 3919 | 33 |
632514 | 632514 | 2020-10-15 | Scott | Iowa | 19163 | 3832 | 32 |
629270 | 629270 | 2020-10-14 | Scott | Iowa | 19163 | 3763 | 32 |
626027 | 626027 | 2020-10-13 | Scott | Iowa | 19163 | 3676 | 32 |
622785 | 622785 | 2020-10-12 | Scott | Iowa | 19163 | 3618 | 30 |
619541 | 619541 | 2020-10-11 | Scott | Iowa | 19163 | 3603 | 29 |
616299 | 616299 | 2020-10-10 | Scott | Iowa | 19163 | 3542 | 29 |
613058 | 613058 | 2020-10-09 | Scott | Iowa | 19163 | 3498 | 29 |
609816 | 609816 | 2020-10-08 | Scott | Iowa | 19163 | 3450 | 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);