ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Washington" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194517 | 1194517 | 2021-04-06 | Washington | Minnesota | 27163 | 23804 | 272 |
1191268 | 1191268 | 2021-04-05 | Washington | Minnesota | 27163 | 23674 | 272 |
1188020 | 1188020 | 2021-04-04 | Washington | Minnesota | 27163 | 23618 | 272 |
1184773 | 1184773 | 2021-04-03 | Washington | Minnesota | 27163 | 23618 | 272 |
1181527 | 1181527 | 2021-04-02 | Washington | Minnesota | 27163 | 23531 | 272 |
1178280 | 1178280 | 2021-04-01 | Washington | Minnesota | 27163 | 23424 | 272 |
1175033 | 1175033 | 2021-03-31 | Washington | Minnesota | 27163 | 23368 | 272 |
1171786 | 1171786 | 2021-03-30 | Washington | Minnesota | 27163 | 23283 | 272 |
1168538 | 1168538 | 2021-03-29 | Washington | Minnesota | 27163 | 23242 | 272 |
1165290 | 1165290 | 2021-03-28 | Washington | Minnesota | 27163 | 23176 | 272 |
1162042 | 1162042 | 2021-03-27 | Washington | Minnesota | 27163 | 23121 | 272 |
1158794 | 1158794 | 2021-03-26 | Washington | Minnesota | 27163 | 23061 | 272 |
1155547 | 1155547 | 2021-03-25 | Washington | Minnesota | 27163 | 22997 | 272 |
1152300 | 1152300 | 2021-03-24 | Washington | Minnesota | 27163 | 22929 | 272 |
1149053 | 1149053 | 2021-03-23 | Washington | Minnesota | 27163 | 22861 | 272 |
1145806 | 1145806 | 2021-03-22 | Washington | Minnesota | 27163 | 22820 | 271 |
1142559 | 1142559 | 2021-03-21 | Washington | Minnesota | 27163 | 22777 | 271 |
1139312 | 1139312 | 2021-03-20 | Washington | Minnesota | 27163 | 22733 | 270 |
1136066 | 1136066 | 2021-03-19 | Washington | Minnesota | 27163 | 22670 | 270 |
1132820 | 1132820 | 2021-03-18 | Washington | Minnesota | 27163 | 22618 | 270 |
1129572 | 1129572 | 2021-03-17 | Washington | Minnesota | 27163 | 22572 | 269 |
1126325 | 1126325 | 2021-03-16 | Washington | Minnesota | 27163 | 22530 | 268 |
1123079 | 1123079 | 2021-03-15 | Washington | Minnesota | 27163 | 22501 | 268 |
1119832 | 1119832 | 2021-03-14 | Washington | Minnesota | 27163 | 22482 | 268 |
1116585 | 1116585 | 2021-03-13 | Washington | Minnesota | 27163 | 22449 | 268 |
1113339 | 1113339 | 2021-03-12 | Washington | Minnesota | 27163 | 22417 | 268 |
1110093 | 1110093 | 2021-03-11 | Washington | Minnesota | 27163 | 22391 | 268 |
1106847 | 1106847 | 2021-03-10 | Washington | Minnesota | 27163 | 22353 | 267 |
1103601 | 1103601 | 2021-03-09 | Washington | Minnesota | 27163 | 22322 | 267 |
1100355 | 1100355 | 2021-03-08 | Washington | Minnesota | 27163 | 22264 | 262 |
1097108 | 1097108 | 2021-03-07 | Washington | Minnesota | 27163 | 22247 | 262 |
1093861 | 1093861 | 2021-03-06 | Washington | Minnesota | 27163 | 22208 | 262 |
1090615 | 1090615 | 2021-03-05 | Washington | Minnesota | 27163 | 22183 | 261 |
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 |
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);