ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Carroll" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054314 | 1054314 | 2021-02-22 | Carroll | Iowa | 19027 | 2639 | 48 |
1051067 | 1051067 | 2021-02-21 | Carroll | Iowa | 19027 | 2639 | 47 |
1047820 | 1047820 | 2021-02-20 | Carroll | Iowa | 19027 | 2639 | 47 |
1044575 | 1044575 | 2021-02-19 | Carroll | Iowa | 19027 | 2639 | 47 |
1041330 | 1041330 | 2021-02-18 | Carroll | Iowa | 19027 | 2637 | 47 |
1038085 | 1038085 | 2021-02-17 | Carroll | Iowa | 19027 | 2635 | 47 |
1034840 | 1034840 | 2021-02-16 | Carroll | Iowa | 19027 | 2629 | 47 |
1031594 | 1031594 | 2021-02-15 | Carroll | Iowa | 19027 | 2628 | 47 |
1028347 | 1028347 | 2021-02-14 | Carroll | Iowa | 19027 | 2626 | 47 |
1025102 | 1025102 | 2021-02-13 | Carroll | Iowa | 19027 | 2624 | 47 |
1021857 | 1021857 | 2021-02-12 | Carroll | Iowa | 19027 | 2622 | 46 |
1018612 | 1018612 | 2021-02-11 | Carroll | Iowa | 19027 | 2620 | 46 |
1015367 | 1015367 | 2021-02-10 | Carroll | Iowa | 19027 | 2620 | 45 |
1012122 | 1012122 | 2021-02-09 | Carroll | Iowa | 19027 | 2619 | 45 |
1008876 | 1008876 | 2021-02-08 | Carroll | Iowa | 19027 | 2612 | 45 |
1005630 | 1005630 | 2021-02-07 | Carroll | Iowa | 19027 | 2608 | 45 |
1002384 | 1002384 | 2021-02-06 | Carroll | Iowa | 19027 | 2608 | 45 |
999138 | 999138 | 2021-02-05 | Carroll | Iowa | 19027 | 2609 | 45 |
995892 | 995892 | 2021-02-04 | Carroll | Iowa | 19027 | 2603 | 45 |
992646 | 992646 | 2021-02-03 | Carroll | Iowa | 19027 | 2600 | 45 |
989400 | 989400 | 2021-02-02 | Carroll | Iowa | 19027 | 2600 | 43 |
986153 | 986153 | 2021-02-01 | Carroll | Iowa | 19027 | 2596 | 43 |
982906 | 982906 | 2021-01-31 | Carroll | Iowa | 19027 | 2595 | 43 |
979660 | 979660 | 2021-01-30 | Carroll | Iowa | 19027 | 2596 | 40 |
976414 | 976414 | 2021-01-29 | Carroll | Iowa | 19027 | 2593 | 36 |
973169 | 973169 | 2021-01-28 | Carroll | Iowa | 19027 | 2593 | 36 |
969924 | 969924 | 2021-01-27 | Carroll | Iowa | 19027 | 2592 | 34 |
966680 | 966680 | 2021-01-26 | Carroll | Iowa | 19027 | 2589 | 34 |
963435 | 963435 | 2021-01-25 | Carroll | Iowa | 19027 | 2587 | 34 |
960190 | 960190 | 2021-01-24 | Carroll | Iowa | 19027 | 2584 | 34 |
956944 | 956944 | 2021-01-23 | Carroll | Iowa | 19027 | 2582 | 34 |
953699 | 953699 | 2021-01-22 | Carroll | Iowa | 19027 | 2580 | 34 |
950454 | 950454 | 2021-01-21 | Carroll | Iowa | 19027 | 2573 | 34 |
947208 | 947208 | 2021-01-20 | Carroll | Iowa | 19027 | 2559 | 34 |
943961 | 943961 | 2021-01-19 | Carroll | Iowa | 19027 | 2555 | 34 |
940716 | 940716 | 2021-01-18 | Carroll | Iowa | 19027 | 2540 | 34 |
937471 | 937471 | 2021-01-17 | Carroll | Iowa | 19027 | 2535 | 34 |
934226 | 934226 | 2021-01-16 | Carroll | Iowa | 19027 | 2530 | 34 |
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 |
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);