ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 19027 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930981 | 930981 | 2021-01-15 | Carroll | Iowa | 19027 | 2527 | 33 |
927736 | 927736 | 2021-01-14 | Carroll | Iowa | 19027 | 2524 | 33 |
924490 | 924490 | 2021-01-13 | Carroll | Iowa | 19027 | 2514 | 33 |
921245 | 921245 | 2021-01-12 | Carroll | Iowa | 19027 | 2507 | 33 |
918000 | 918000 | 2021-01-11 | Carroll | Iowa | 19027 | 2499 | 32 |
914755 | 914755 | 2021-01-10 | Carroll | Iowa | 19027 | 2484 | 32 |
911510 | 911510 | 2021-01-09 | Carroll | Iowa | 19027 | 2481 | 32 |
908265 | 908265 | 2021-01-08 | Carroll | Iowa | 19027 | 2475 | 32 |
905019 | 905019 | 2021-01-07 | Carroll | Iowa | 19027 | 2466 | 31 |
901774 | 901774 | 2021-01-06 | Carroll | Iowa | 19027 | 2446 | 31 |
898529 | 898529 | 2021-01-05 | Carroll | Iowa | 19027 | 2436 | 31 |
895284 | 895284 | 2021-01-04 | Carroll | Iowa | 19027 | 2424 | 31 |
892037 | 892037 | 2021-01-03 | Carroll | Iowa | 19027 | 2406 | 31 |
888791 | 888791 | 2021-01-02 | Carroll | Iowa | 19027 | 2397 | 31 |
885545 | 885545 | 2021-01-01 | Carroll | Iowa | 19027 | 2393 | 30 |
882300 | 882300 | 2020-12-31 | Carroll | Iowa | 19027 | 2386 | 30 |
879055 | 879055 | 2020-12-30 | Carroll | Iowa | 19027 | 2360 | 27 |
875810 | 875810 | 2020-12-29 | Carroll | Iowa | 19027 | 2355 | 27 |
872565 | 872565 | 2020-12-28 | Carroll | Iowa | 19027 | 2346 | 27 |
869320 | 869320 | 2020-12-27 | Carroll | Iowa | 19027 | 2326 | 27 |
866075 | 866075 | 2020-12-26 | Carroll | Iowa | 19027 | 2318 | 27 |
862830 | 862830 | 2020-12-25 | Carroll | Iowa | 19027 | 2310 | 27 |
859585 | 859585 | 2020-12-24 | Carroll | Iowa | 19027 | 2309 | 27 |
856340 | 856340 | 2020-12-23 | Carroll | Iowa | 19027 | 2300 | 27 |
853095 | 853095 | 2020-12-22 | Carroll | Iowa | 19027 | 2281 | 27 |
849850 | 849850 | 2020-12-21 | Carroll | Iowa | 19027 | 2277 | 27 |
846605 | 846605 | 2020-12-20 | Carroll | Iowa | 19027 | 2255 | 27 |
843359 | 843359 | 2020-12-19 | Carroll | Iowa | 19027 | 2254 | 27 |
840114 | 840114 | 2020-12-18 | Carroll | Iowa | 19027 | 2237 | 27 |
836869 | 836869 | 2020-12-17 | Carroll | Iowa | 19027 | 2228 | 27 |
833623 | 833623 | 2020-12-16 | Carroll | Iowa | 19027 | 2206 | 26 |
830376 | 830376 | 2020-12-15 | Carroll | Iowa | 19027 | 2189 | 26 |
827130 | 827130 | 2020-12-14 | Carroll | Iowa | 19027 | 2163 | 25 |
823883 | 823883 | 2020-12-13 | Carroll | Iowa | 19027 | 2156 | 22 |
820637 | 820637 | 2020-12-12 | Carroll | Iowa | 19027 | 2145 | 22 |
817391 | 817391 | 2020-12-11 | Carroll | Iowa | 19027 | 2135 | 22 |
814145 | 814145 | 2020-12-10 | Carroll | Iowa | 19027 | 2113 | 22 |
810900 | 810900 | 2020-12-09 | Carroll | Iowa | 19027 | 2101 | 22 |
807655 | 807655 | 2020-12-08 | Carroll | Iowa | 19027 | 2089 | 22 |
804410 | 804410 | 2020-12-07 | Carroll | Iowa | 19027 | 2087 | 26 |
801165 | 801165 | 2020-12-06 | Carroll | Iowa | 19027 | 2077 | 26 |
797920 | 797920 | 2020-12-05 | Carroll | Iowa | 19027 | 2073 | 26 |
794675 | 794675 | 2020-12-04 | Carroll | Iowa | 19027 | 2064 | 26 |
791430 | 791430 | 2020-12-03 | Carroll | Iowa | 19027 | 2046 | 25 |
788185 | 788185 | 2020-12-02 | Carroll | Iowa | 19027 | 2036 | 24 |
784941 | 784941 | 2020-12-01 | Carroll | Iowa | 19027 | 2012 | 22 |
781696 | 781696 | 2020-11-30 | Carroll | Iowa | 19027 | 1997 | 22 |
778450 | 778450 | 2020-11-29 | Carroll | Iowa | 19027 | 1985 | 22 |
775205 | 775205 | 2020-11-28 | Carroll | Iowa | 19027 | 1972 | 22 |
771960 | 771960 | 2020-11-27 | Carroll | Iowa | 19027 | 1966 | 22 |
768715 | 768715 | 2020-11-26 | Carroll | Iowa | 19027 | 1954 | 22 |
765469 | 765469 | 2020-11-25 | Carroll | Iowa | 19027 | 1949 | 21 |
762224 | 762224 | 2020-11-24 | Carroll | Iowa | 19027 | 1925 | 21 |
758979 | 758979 | 2020-11-23 | Carroll | Iowa | 19027 | 1910 | 20 |
755732 | 755732 | 2020-11-22 | Carroll | Iowa | 19027 | 1882 | 20 |
752486 | 752486 | 2020-11-21 | Carroll | Iowa | 19027 | 1863 | 20 |
749240 | 749240 | 2020-11-20 | Carroll | Iowa | 19027 | 1836 | 20 |
745994 | 745994 | 2020-11-19 | Carroll | Iowa | 19027 | 1821 | 15 |
742747 | 742747 | 2020-11-18 | Carroll | Iowa | 19027 | 1791 | 15 |
739500 | 739500 | 2020-11-17 | Carroll | Iowa | 19027 | 1773 | 14 |
736256 | 736256 | 2020-11-16 | Carroll | Iowa | 19027 | 1737 | 14 |
733010 | 733010 | 2020-11-15 | Carroll | Iowa | 19027 | 1712 | 14 |
729765 | 729765 | 2020-11-14 | Carroll | Iowa | 19027 | 1684 | 14 |
726522 | 726522 | 2020-11-13 | Carroll | Iowa | 19027 | 1663 | 14 |
723279 | 723279 | 2020-11-12 | Carroll | Iowa | 19027 | 1631 | 14 |
720036 | 720036 | 2020-11-11 | Carroll | Iowa | 19027 | 1610 | 14 |
716793 | 716793 | 2020-11-10 | Carroll | Iowa | 19027 | 1542 | 14 |
713549 | 713549 | 2020-11-09 | Carroll | Iowa | 19027 | 1517 | 14 |
710305 | 710305 | 2020-11-08 | Carroll | Iowa | 19027 | 1471 | 14 |
707061 | 707061 | 2020-11-07 | Carroll | Iowa | 19027 | 1441 | 14 |
703818 | 703818 | 2020-11-06 | Carroll | Iowa | 19027 | 1401 | 13 |
700576 | 700576 | 2020-11-05 | Carroll | Iowa | 19027 | 1364 | 13 |
697332 | 697332 | 2020-11-04 | Carroll | Iowa | 19027 | 1324 | 13 |
694090 | 694090 | 2020-11-03 | Carroll | Iowa | 19027 | 1298 | 13 |
690847 | 690847 | 2020-11-02 | Carroll | Iowa | 19027 | 1278 | 13 |
687602 | 687602 | 2020-11-01 | Carroll | Iowa | 19027 | 1265 | 13 |
684358 | 684358 | 2020-10-31 | Carroll | Iowa | 19027 | 1246 | 13 |
681115 | 681115 | 2020-10-30 | Carroll | Iowa | 19027 | 1232 | 13 |
677872 | 677872 | 2020-10-29 | Carroll | Iowa | 19027 | 1209 | 13 |
674629 | 674629 | 2020-10-28 | Carroll | Iowa | 19027 | 1191 | 13 |
671387 | 671387 | 2020-10-27 | Carroll | Iowa | 19027 | 1172 | 13 |
668144 | 668144 | 2020-10-26 | Carroll | Iowa | 19027 | 1156 | 12 |
664900 | 664900 | 2020-10-25 | Carroll | Iowa | 19027 | 1145 | 12 |
661655 | 661655 | 2020-10-24 | Carroll | Iowa | 19027 | 1116 | 12 |
658411 | 658411 | 2020-10-23 | Carroll | Iowa | 19027 | 1101 | 12 |
655166 | 655166 | 2020-10-22 | Carroll | Iowa | 19027 | 1075 | 12 |
651921 | 651921 | 2020-10-21 | Carroll | Iowa | 19027 | 1054 | 10 |
648677 | 648677 | 2020-10-20 | Carroll | Iowa | 19027 | 1038 | 8 |
645432 | 645432 | 2020-10-19 | Carroll | Iowa | 19027 | 1028 | 8 |
642185 | 642185 | 2020-10-18 | Carroll | Iowa | 19027 | 1023 | 8 |
638938 | 638938 | 2020-10-17 | Carroll | Iowa | 19027 | 1020 | 8 |
635692 | 635692 | 2020-10-16 | Carroll | Iowa | 19027 | 1001 | 8 |
632446 | 632446 | 2020-10-15 | Carroll | Iowa | 19027 | 987 | 7 |
629202 | 629202 | 2020-10-14 | Carroll | Iowa | 19027 | 956 | 7 |
625959 | 625959 | 2020-10-13 | Carroll | Iowa | 19027 | 938 | 6 |
622717 | 622717 | 2020-10-12 | Carroll | Iowa | 19027 | 928 | 6 |
619473 | 619473 | 2020-10-11 | Carroll | Iowa | 19027 | 912 | 6 |
616231 | 616231 | 2020-10-10 | Carroll | Iowa | 19027 | 905 | 6 |
612990 | 612990 | 2020-10-09 | Carroll | Iowa | 19027 | 877 | 6 |
609748 | 609748 | 2020-10-08 | Carroll | Iowa | 19027 | 859 | 5 |
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);