ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Washington" and fips = 27163 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1087370 | 1087370 | 2021-03-04 | Washington | Minnesota | 27163 | 22156 | 259 |
1084125 | 1084125 | 2021-03-03 | Washington | Minnesota | 27163 | 22121 | 258 |
1080879 | 1080879 | 2021-03-02 | Washington | Minnesota | 27163 | 22078 | 256 |
1077633 | 1077633 | 2021-03-01 | Washington | Minnesota | 27163 | 22065 | 255 |
1074387 | 1074387 | 2021-02-28 | Washington | Minnesota | 27163 | 22027 | 255 |
1071141 | 1071141 | 2021-02-27 | Washington | Minnesota | 27163 | 21986 | 254 |
1067896 | 1067896 | 2021-02-26 | Washington | Minnesota | 27163 | 21952 | 253 |
1064651 | 1064651 | 2021-02-25 | Washington | Minnesota | 27163 | 21896 | 253 |
1061407 | 1061407 | 2021-02-24 | Washington | Minnesota | 27163 | 21862 | 253 |
1058161 | 1058161 | 2021-02-23 | Washington | Minnesota | 27163 | 21824 | 253 |
1054915 | 1054915 | 2021-02-22 | Washington | Minnesota | 27163 | 21791 | 253 |
1051668 | 1051668 | 2021-02-21 | Washington | Minnesota | 27163 | 21769 | 253 |
1048421 | 1048421 | 2021-02-20 | Washington | Minnesota | 27163 | 21719 | 253 |
1045175 | 1045175 | 2021-02-19 | Washington | Minnesota | 27163 | 21665 | 251 |
1041930 | 1041930 | 2021-02-18 | Washington | Minnesota | 27163 | 21622 | 251 |
1038685 | 1038685 | 2021-02-17 | Washington | Minnesota | 27163 | 21587 | 250 |
1035440 | 1035440 | 2021-02-16 | Washington | Minnesota | 27163 | 21554 | 249 |
1032195 | 1032195 | 2021-02-15 | Washington | Minnesota | 27163 | 21542 | 249 |
1028948 | 1028948 | 2021-02-14 | Washington | Minnesota | 27163 | 21518 | 249 |
1025702 | 1025702 | 2021-02-13 | Washington | Minnesota | 27163 | 21475 | 249 |
1022457 | 1022457 | 2021-02-12 | Washington | Minnesota | 27163 | 21407 | 249 |
1019212 | 1019212 | 2021-02-11 | Washington | Minnesota | 27163 | 21353 | 249 |
1015967 | 1015967 | 2021-02-10 | Washington | Minnesota | 27163 | 21306 | 248 |
1012722 | 1012722 | 2021-02-09 | Washington | Minnesota | 27163 | 21281 | 247 |
1009477 | 1009477 | 2021-02-08 | Washington | Minnesota | 27163 | 21266 | 247 |
1006230 | 1006230 | 2021-02-07 | Washington | Minnesota | 27163 | 21229 | 247 |
1002984 | 1002984 | 2021-02-06 | Washington | Minnesota | 27163 | 21181 | 246 |
999739 | 999739 | 2021-02-05 | Washington | Minnesota | 27163 | 21127 | 246 |
996493 | 996493 | 2021-02-04 | Washington | Minnesota | 27163 | 21083 | 243 |
993247 | 993247 | 2021-02-03 | Washington | Minnesota | 27163 | 21005 | 242 |
990001 | 990001 | 2021-02-02 | Washington | Minnesota | 27163 | 20982 | 242 |
986754 | 986754 | 2021-02-01 | Washington | Minnesota | 27163 | 20950 | 242 |
983507 | 983507 | 2021-01-31 | Washington | Minnesota | 27163 | 20904 | 242 |
980261 | 980261 | 2021-01-30 | Washington | Minnesota | 27163 | 20854 | 242 |
977015 | 977015 | 2021-01-29 | Washington | Minnesota | 27163 | 20795 | 241 |
973770 | 973770 | 2021-01-28 | Washington | Minnesota | 27163 | 20741 | 240 |
970525 | 970525 | 2021-01-27 | Washington | Minnesota | 27163 | 20678 | 239 |
967280 | 967280 | 2021-01-26 | Washington | Minnesota | 27163 | 20627 | 237 |
964036 | 964036 | 2021-01-25 | Washington | Minnesota | 27163 | 20579 | 237 |
960791 | 960791 | 2021-01-24 | Washington | Minnesota | 27163 | 20533 | 237 |
957545 | 957545 | 2021-01-23 | Washington | Minnesota | 27163 | 20471 | 234 |
954300 | 954300 | 2021-01-22 | Washington | Minnesota | 27163 | 20363 | 231 |
951055 | 951055 | 2021-01-21 | Washington | Minnesota | 27163 | 20282 | 231 |
947809 | 947809 | 2021-01-20 | Washington | Minnesota | 27163 | 20220 | 230 |
944562 | 944562 | 2021-01-19 | Washington | Minnesota | 27163 | 20164 | 228 |
941317 | 941317 | 2021-01-18 | Washington | Minnesota | 27163 | 20116 | 227 |
938072 | 938072 | 2021-01-17 | Washington | Minnesota | 27163 | 20066 | 227 |
934827 | 934827 | 2021-01-16 | Washington | Minnesota | 27163 | 20004 | 225 |
931582 | 931582 | 2021-01-15 | Washington | Minnesota | 27163 | 19904 | 223 |
928337 | 928337 | 2021-01-14 | Washington | Minnesota | 27163 | 19827 | 221 |
925091 | 925091 | 2021-01-13 | Washington | Minnesota | 27163 | 19750 | 220 |
921846 | 921846 | 2021-01-12 | Washington | Minnesota | 27163 | 19687 | 213 |
918601 | 918601 | 2021-01-11 | Washington | Minnesota | 27163 | 19630 | 213 |
915356 | 915356 | 2021-01-10 | Washington | Minnesota | 27163 | 19581 | 213 |
912111 | 912111 | 2021-01-09 | Washington | Minnesota | 27163 | 19449 | 211 |
908866 | 908866 | 2021-01-08 | Washington | Minnesota | 27163 | 19302 | 209 |
905620 | 905620 | 2021-01-07 | Washington | Minnesota | 27163 | 19199 | 207 |
902375 | 902375 | 2021-01-06 | Washington | Minnesota | 27163 | 19111 | 203 |
899130 | 899130 | 2021-01-05 | Washington | Minnesota | 27163 | 19010 | 198 |
895885 | 895885 | 2021-01-04 | Washington | Minnesota | 27163 | 18907 | 196 |
892638 | 892638 | 2021-01-03 | Washington | Minnesota | 27163 | 18762 | 194 |
889392 | 889392 | 2021-01-02 | Washington | Minnesota | 27163 | 18610 | 192 |
886146 | 886146 | 2021-01-01 | Washington | Minnesota | 27163 | 18467 | 190 |
882901 | 882901 | 2020-12-31 | Washington | Minnesota | 27163 | 18467 | 190 |
879656 | 879656 | 2020-12-30 | Washington | Minnesota | 27163 | 18379 | 187 |
876411 | 876411 | 2020-12-29 | Washington | Minnesota | 27163 | 18288 | 181 |
873166 | 873166 | 2020-12-28 | Washington | Minnesota | 27163 | 18248 | 180 |
869921 | 869921 | 2020-12-27 | Washington | Minnesota | 27163 | 18206 | 180 |
866676 | 866676 | 2020-12-26 | Washington | Minnesota | 27163 | 18086 | 177 |
863431 | 863431 | 2020-12-25 | Washington | Minnesota | 27163 | 17984 | 176 |
860186 | 860186 | 2020-12-24 | Washington | Minnesota | 27163 | 17984 | 176 |
856941 | 856941 | 2020-12-23 | Washington | Minnesota | 27163 | 17913 | 174 |
853696 | 853696 | 2020-12-22 | Washington | Minnesota | 27163 | 17863 | 173 |
850451 | 850451 | 2020-12-21 | Washington | Minnesota | 27163 | 17786 | 171 |
847206 | 847206 | 2020-12-20 | Washington | Minnesota | 27163 | 17691 | 170 |
843960 | 843960 | 2020-12-19 | Washington | Minnesota | 27163 | 17568 | 167 |
840715 | 840715 | 2020-12-18 | Washington | Minnesota | 27163 | 17451 | 163 |
837470 | 837470 | 2020-12-17 | Washington | Minnesota | 27163 | 17316 | 159 |
834224 | 834224 | 2020-12-16 | Washington | Minnesota | 27163 | 17203 | 154 |
830977 | 830977 | 2020-12-15 | Washington | Minnesota | 27163 | 17090 | 150 |
827731 | 827731 | 2020-12-14 | Washington | Minnesota | 27163 | 16968 | 150 |
824484 | 824484 | 2020-12-13 | Washington | Minnesota | 27163 | 16830 | 150 |
821238 | 821238 | 2020-12-12 | Washington | Minnesota | 27163 | 16666 | 146 |
817992 | 817992 | 2020-12-11 | Washington | Minnesota | 27163 | 16452 | 144 |
814746 | 814746 | 2020-12-10 | Washington | Minnesota | 27163 | 16277 | 139 |
811501 | 811501 | 2020-12-09 | Washington | Minnesota | 27163 | 16123 | 134 |
808256 | 808256 | 2020-12-08 | Washington | Minnesota | 27163 | 15946 | 134 |
805011 | 805011 | 2020-12-07 | Washington | Minnesota | 27163 | 15876 | 132 |
801766 | 801766 | 2020-12-06 | Washington | Minnesota | 27163 | 15590 | 130 |
798521 | 798521 | 2020-12-05 | Washington | Minnesota | 27163 | 15307 | 127 |
795276 | 795276 | 2020-12-04 | Washington | Minnesota | 27163 | 15094 | 125 |
792031 | 792031 | 2020-12-03 | Washington | Minnesota | 27163 | 14864 | 125 |
788786 | 788786 | 2020-12-02 | Washington | Minnesota | 27163 | 14590 | 120 |
785541 | 785541 | 2020-12-01 | Washington | Minnesota | 27163 | 14370 | 117 |
782297 | 782297 | 2020-11-30 | Washington | Minnesota | 27163 | 14207 | 116 |
779051 | 779051 | 2020-11-29 | Washington | Minnesota | 27163 | 13999 | 115 |
775806 | 775806 | 2020-11-28 | Washington | Minnesota | 27163 | 13529 | 113 |
772561 | 772561 | 2020-11-27 | Washington | Minnesota | 27163 | 13220 | 111 |
769316 | 769316 | 2020-11-26 | Washington | Minnesota | 27163 | 13066 | 109 |
766070 | 766070 | 2020-11-25 | Washington | Minnesota | 27163 | 13066 | 109 |
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);