ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Scott" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054382 | 1054382 | 2021-02-22 | Scott | Iowa | 19163 | 16852 | 202 |
1051135 | 1051135 | 2021-02-21 | Scott | Iowa | 19163 | 16852 | 200 |
1047888 | 1047888 | 2021-02-20 | Scott | Iowa | 19163 | 16852 | 200 |
1044643 | 1044643 | 2021-02-19 | Scott | Iowa | 19163 | 16852 | 200 |
1041398 | 1041398 | 2021-02-18 | Scott | Iowa | 19163 | 16841 | 199 |
1038153 | 1038153 | 2021-02-17 | Scott | Iowa | 19163 | 16817 | 197 |
1034908 | 1034908 | 2021-02-16 | Scott | Iowa | 19163 | 16795 | 197 |
1031662 | 1031662 | 2021-02-15 | Scott | Iowa | 19163 | 16759 | 196 |
1028415 | 1028415 | 2021-02-14 | Scott | Iowa | 19163 | 16737 | 196 |
1025170 | 1025170 | 2021-02-13 | Scott | Iowa | 19163 | 16726 | 196 |
1021925 | 1021925 | 2021-02-12 | Scott | Iowa | 19163 | 16699 | 195 |
1018680 | 1018680 | 2021-02-11 | Scott | Iowa | 19163 | 16636 | 194 |
1015435 | 1015435 | 2021-02-10 | Scott | Iowa | 19163 | 16616 | 194 |
1012190 | 1012190 | 2021-02-09 | Scott | Iowa | 19163 | 16569 | 191 |
1008944 | 1008944 | 2021-02-08 | Scott | Iowa | 19163 | 16530 | 189 |
1005698 | 1005698 | 2021-02-07 | Scott | Iowa | 19163 | 16500 | 189 |
1002452 | 1002452 | 2021-02-06 | Scott | Iowa | 19163 | 16492 | 189 |
999206 | 999206 | 2021-02-05 | Scott | Iowa | 19163 | 16465 | 187 |
995960 | 995960 | 2021-02-04 | Scott | Iowa | 19163 | 16444 | 186 |
992714 | 992714 | 2021-02-03 | Scott | Iowa | 19163 | 16388 | 183 |
989468 | 989468 | 2021-02-02 | Scott | Iowa | 19163 | 16341 | 182 |
986221 | 986221 | 2021-02-01 | Scott | Iowa | 19163 | 16277 | 182 |
982974 | 982974 | 2021-01-31 | Scott | Iowa | 19163 | 16229 | 180 |
979728 | 979728 | 2021-01-30 | Scott | Iowa | 19163 | 16214 | 178 |
976482 | 976482 | 2021-01-29 | Scott | Iowa | 19163 | 16131 | 177 |
973237 | 973237 | 2021-01-28 | Scott | Iowa | 19163 | 16096 | 173 |
969992 | 969992 | 2021-01-27 | Scott | Iowa | 19163 | 16058 | 172 |
966748 | 966748 | 2021-01-26 | Scott | Iowa | 19163 | 15975 | 172 |
963503 | 963503 | 2021-01-25 | Scott | Iowa | 19163 | 15900 | 172 |
960258 | 960258 | 2021-01-24 | Scott | Iowa | 19163 | 15872 | 172 |
957012 | 957012 | 2021-01-23 | Scott | Iowa | 19163 | 15838 | 172 |
953767 | 953767 | 2021-01-22 | Scott | Iowa | 19163 | 15787 | 171 |
950522 | 950522 | 2021-01-21 | Scott | Iowa | 19163 | 15694 | 167 |
947276 | 947276 | 2021-01-20 | Scott | Iowa | 19163 | 15566 | 166 |
944029 | 944029 | 2021-01-19 | Scott | Iowa | 19163 | 15444 | 163 |
940784 | 940784 | 2021-01-18 | Scott | Iowa | 19163 | 15414 | 163 |
937539 | 937539 | 2021-01-17 | Scott | Iowa | 19163 | 15387 | 163 |
934294 | 934294 | 2021-01-16 | Scott | Iowa | 19163 | 15355 | 163 |
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 |
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);