ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where deaths = 22, fips = 53017 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1361775 | 1361775 | 2021-05-27 | Douglas | Washington | 53017 | 3688 | 22 |
1358529 | 1358529 | 2021-05-26 | Douglas | Washington | 53017 | 3684 | 22 |
1355283 | 1355283 | 2021-05-25 | Douglas | Washington | 53017 | 3682 | 22 |
1352037 | 1352037 | 2021-05-24 | Douglas | Washington | 53017 | 3682 | 22 |
1348791 | 1348791 | 2021-05-23 | Douglas | Washington | 53017 | 3678 | 22 |
1345543 | 1345543 | 2021-05-22 | Douglas | Washington | 53017 | 3675 | 22 |
1342295 | 1342295 | 2021-05-21 | Douglas | Washington | 53017 | 3675 | 22 |
1339047 | 1339047 | 2021-05-20 | Douglas | Washington | 53017 | 3675 | 22 |
1335800 | 1335800 | 2021-05-19 | Douglas | Washington | 53017 | 3675 | 22 |
1332553 | 1332553 | 2021-05-18 | Douglas | Washington | 53017 | 3672 | 22 |
1329306 | 1329306 | 2021-05-17 | Douglas | Washington | 53017 | 3672 | 22 |
1326060 | 1326060 | 2021-05-16 | Douglas | Washington | 53017 | 3665 | 22 |
1322814 | 1322814 | 2021-05-15 | Douglas | Washington | 53017 | 3665 | 22 |
1319568 | 1319568 | 2021-05-14 | Douglas | Washington | 53017 | 3665 | 22 |
1316320 | 1316320 | 2021-05-13 | Douglas | Washington | 53017 | 3659 | 22 |
1313074 | 1313074 | 2021-05-12 | Douglas | Washington | 53017 | 3658 | 22 |
1309827 | 1309827 | 2021-05-11 | Douglas | Washington | 53017 | 3658 | 22 |
1306581 | 1306581 | 2021-05-10 | Douglas | Washington | 53017 | 3655 | 22 |
1303335 | 1303335 | 2021-05-09 | Douglas | Washington | 53017 | 3645 | 22 |
1300088 | 1300088 | 2021-05-08 | Douglas | Washington | 53017 | 3645 | 22 |
1296841 | 1296841 | 2021-05-07 | Douglas | Washington | 53017 | 3645 | 22 |
1293595 | 1293595 | 2021-05-06 | Douglas | Washington | 53017 | 3635 | 22 |
1251387 | 1251387 | 2021-04-23 | Douglas | Washington | 53017 | 3546 | 22 |
1248140 | 1248140 | 2021-04-22 | Douglas | Washington | 53017 | 3546 | 22 |
1244893 | 1244893 | 2021-04-21 | Douglas | Washington | 53017 | 3546 | 22 |
1241646 | 1241646 | 2021-04-20 | Douglas | Washington | 53017 | 3546 | 22 |
1238399 | 1238399 | 2021-04-19 | Douglas | Washington | 53017 | 3546 | 22 |
1235152 | 1235152 | 2021-04-18 | Douglas | Washington | 53017 | 3546 | 22 |
1231904 | 1231904 | 2021-04-17 | Douglas | Washington | 53017 | 3546 | 22 |
1228656 | 1228656 | 2021-04-16 | Douglas | Washington | 53017 | 3546 | 22 |
1225408 | 1225408 | 2021-04-15 | Douglas | Washington | 53017 | 3538 | 22 |
1222161 | 1222161 | 2021-04-14 | Douglas | Washington | 53017 | 3524 | 22 |
1218913 | 1218913 | 2021-04-13 | Douglas | Washington | 53017 | 3524 | 22 |
1215665 | 1215665 | 2021-04-12 | Douglas | Washington | 53017 | 3511 | 22 |
1212418 | 1212418 | 2021-04-11 | Douglas | Washington | 53017 | 3507 | 22 |
1209169 | 1209169 | 2021-04-10 | Douglas | Washington | 53017 | 3507 | 22 |
1205921 | 1205921 | 2021-04-09 | Douglas | Washington | 53017 | 3507 | 22 |
1202673 | 1202673 | 2021-04-08 | Douglas | Washington | 53017 | 3498 | 22 |
1199425 | 1199425 | 2021-04-07 | Douglas | Washington | 53017 | 3498 | 22 |
1196176 | 1196176 | 2021-04-06 | Douglas | Washington | 53017 | 3489 | 22 |
1192928 | 1192928 | 2021-04-05 | Douglas | Washington | 53017 | 3475 | 22 |
1189678 | 1189678 | 2021-04-04 | Douglas | Washington | 53017 | 3465 | 22 |
1186431 | 1186431 | 2021-04-03 | Douglas | Washington | 53017 | 3465 | 22 |
1183184 | 1183184 | 2021-04-02 | Douglas | Washington | 53017 | 3465 | 22 |
1179937 | 1179937 | 2021-04-01 | Douglas | Washington | 53017 | 3456 | 22 |
1176690 | 1176690 | 2021-03-31 | Douglas | Washington | 53017 | 3447 | 22 |
1173443 | 1173443 | 2021-03-30 | Douglas | Washington | 53017 | 3433 | 22 |
1170196 | 1170196 | 2021-03-29 | Douglas | Washington | 53017 | 3412 | 22 |
1166948 | 1166948 | 2021-03-28 | Douglas | Washington | 53017 | 3406 | 22 |
1163700 | 1163700 | 2021-03-27 | Douglas | Washington | 53017 | 3406 | 22 |
1160452 | 1160452 | 2021-03-26 | Douglas | Washington | 53017 | 3406 | 22 |
1157204 | 1157204 | 2021-03-25 | Douglas | Washington | 53017 | 3396 | 22 |
1153957 | 1153957 | 2021-03-24 | Douglas | Washington | 53017 | 3390 | 22 |
1150710 | 1150710 | 2021-03-23 | Douglas | Washington | 53017 | 3378 | 22 |
1147463 | 1147463 | 2021-03-22 | Douglas | Washington | 53017 | 3364 | 22 |
1144216 | 1144216 | 2021-03-21 | Douglas | Washington | 53017 | 3358 | 22 |
1140969 | 1140969 | 2021-03-20 | Douglas | Washington | 53017 | 3358 | 22 |
1137723 | 1137723 | 2021-03-19 | Douglas | Washington | 53017 | 3358 | 22 |
1134477 | 1134477 | 2021-03-18 | Douglas | Washington | 53017 | 3350 | 22 |
1131229 | 1131229 | 2021-03-17 | Douglas | Washington | 53017 | 3337 | 22 |
1127982 | 1127982 | 2021-03-16 | Douglas | Washington | 53017 | 3324 | 22 |
1124736 | 1124736 | 2021-03-15 | Douglas | Washington | 53017 | 3309 | 22 |
1121490 | 1121490 | 2021-03-14 | Douglas | Washington | 53017 | 3305 | 22 |
1118243 | 1118243 | 2021-03-13 | Douglas | Washington | 53017 | 3305 | 22 |
1114996 | 1114996 | 2021-03-12 | Douglas | Washington | 53017 | 3305 | 22 |
1111750 | 1111750 | 2021-03-11 | Douglas | Washington | 53017 | 3303 | 22 |
1108504 | 1108504 | 2021-03-10 | Douglas | Washington | 53017 | 3293 | 22 |
1059817 | 1059817 | 2021-02-23 | Douglas | Washington | 53017 | 3222 | 22 |
1056571 | 1056571 | 2021-02-22 | Douglas | Washington | 53017 | 3208 | 22 |
1053325 | 1053325 | 2021-02-21 | Douglas | Washington | 53017 | 3207 | 22 |
1050078 | 1050078 | 2021-02-20 | Douglas | Washington | 53017 | 3207 | 22 |
1046831 | 1046831 | 2021-02-19 | Douglas | Washington | 53017 | 3207 | 22 |
1043586 | 1043586 | 2021-02-18 | Douglas | Washington | 53017 | 3204 | 22 |
1040341 | 1040341 | 2021-02-17 | Douglas | Washington | 53017 | 3200 | 22 |
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);