ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
671 rows where fips = 53023 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420197 | 1420197 | 2021-06-14 | Garfield | Washington | 53023 | 126 | 5 |
1416952 | 1416952 | 2021-06-13 | Garfield | Washington | 53023 | 126 | 5 |
1413706 | 1413706 | 2021-06-12 | Garfield | Washington | 53023 | 126 | 5 |
1410461 | 1410461 | 2021-06-11 | Garfield | Washington | 53023 | 126 | 5 |
1407216 | 1407216 | 2021-06-10 | Garfield | Washington | 53023 | 126 | 5 |
1403970 | 1403970 | 2021-06-09 | Garfield | Washington | 53023 | 126 | 5 |
1400725 | 1400725 | 2021-06-08 | Garfield | Washington | 53023 | 125 | 5 |
1397480 | 1397480 | 2021-06-07 | Garfield | Washington | 53023 | 125 | 5 |
1394233 | 1394233 | 2021-06-06 | Garfield | Washington | 53023 | 125 | 5 |
1390988 | 1390988 | 2021-06-05 | Garfield | Washington | 53023 | 125 | 5 |
1387743 | 1387743 | 2021-06-04 | Garfield | Washington | 53023 | 125 | 5 |
1384498 | 1384498 | 2021-06-03 | Garfield | Washington | 53023 | 124 | 5 |
1381252 | 1381252 | 2021-06-02 | Garfield | Washington | 53023 | 124 | 5 |
1378007 | 1378007 | 2021-06-01 | Garfield | Washington | 53023 | 124 | 5 |
1374761 | 1374761 | 2021-05-31 | Garfield | Washington | 53023 | 124 | 5 |
1371516 | 1371516 | 2021-05-30 | Garfield | Washington | 53023 | 124 | 5 |
1368270 | 1368270 | 2021-05-29 | Garfield | Washington | 53023 | 124 | 5 |
1365024 | 1365024 | 2021-05-28 | Garfield | Washington | 53023 | 124 | 5 |
1361778 | 1361778 | 2021-05-27 | Garfield | Washington | 53023 | 123 | 5 |
1358532 | 1358532 | 2021-05-26 | Garfield | Washington | 53023 | 123 | 5 |
1355286 | 1355286 | 2021-05-25 | Garfield | Washington | 53023 | 123 | 5 |
1352040 | 1352040 | 2021-05-24 | Garfield | Washington | 53023 | 123 | 5 |
1348794 | 1348794 | 2021-05-23 | Garfield | Washington | 53023 | 123 | 5 |
1345546 | 1345546 | 2021-05-22 | Garfield | Washington | 53023 | 123 | 5 |
1342298 | 1342298 | 2021-05-21 | Garfield | Washington | 53023 | 123 | 5 |
1339050 | 1339050 | 2021-05-20 | Garfield | Washington | 53023 | 123 | 5 |
1335803 | 1335803 | 2021-05-19 | Garfield | Washington | 53023 | 123 | 5 |
1332556 | 1332556 | 2021-05-18 | Garfield | Washington | 53023 | 123 | 5 |
1329309 | 1329309 | 2021-05-17 | Garfield | Washington | 53023 | 123 | 5 |
1326063 | 1326063 | 2021-05-16 | Garfield | Washington | 53023 | 123 | 5 |
1322817 | 1322817 | 2021-05-15 | Garfield | Washington | 53023 | 123 | 5 |
1319571 | 1319571 | 2021-05-14 | Garfield | Washington | 53023 | 123 | 5 |
1316323 | 1316323 | 2021-05-13 | Garfield | Washington | 53023 | 122 | 5 |
1313077 | 1313077 | 2021-05-12 | Garfield | Washington | 53023 | 122 | 5 |
1309830 | 1309830 | 2021-05-11 | Garfield | Washington | 53023 | 122 | 5 |
1306584 | 1306584 | 2021-05-10 | Garfield | Washington | 53023 | 122 | 5 |
1303338 | 1303338 | 2021-05-09 | Garfield | Washington | 53023 | 122 | 5 |
1300091 | 1300091 | 2021-05-08 | Garfield | Washington | 53023 | 122 | 5 |
1296844 | 1296844 | 2021-05-07 | Garfield | Washington | 53023 | 122 | 5 |
1293598 | 1293598 | 2021-05-06 | Garfield | Washington | 53023 | 122 | 5 |
1290352 | 1290352 | 2021-05-05 | Garfield | Washington | 53023 | 121 | 5 |
1287106 | 1287106 | 2021-05-04 | Garfield | Washington | 53023 | 121 | 5 |
1283860 | 1283860 | 2021-05-03 | Garfield | Washington | 53023 | 121 | 5 |
1280613 | 1280613 | 2021-05-02 | Garfield | Washington | 53023 | 121 | 5 |
1277366 | 1277366 | 2021-05-01 | Garfield | Washington | 53023 | 121 | 5 |
1274119 | 1274119 | 2021-04-30 | Garfield | Washington | 53023 | 120 | 5 |
1270872 | 1270872 | 2021-04-29 | Garfield | Washington | 53023 | 120 | 5 |
1267625 | 1267625 | 2021-04-28 | Garfield | Washington | 53023 | 120 | 5 |
1264378 | 1264378 | 2021-04-27 | Garfield | Washington | 53023 | 120 | 5 |
1261131 | 1261131 | 2021-04-26 | Garfield | Washington | 53023 | 120 | 5 |
1257884 | 1257884 | 2021-04-25 | Garfield | Washington | 53023 | 120 | 5 |
1254637 | 1254637 | 2021-04-24 | Garfield | Washington | 53023 | 120 | 5 |
1251390 | 1251390 | 2021-04-23 | Garfield | Washington | 53023 | 120 | 5 |
1248143 | 1248143 | 2021-04-22 | Garfield | Washington | 53023 | 120 | 5 |
1244896 | 1244896 | 2021-04-21 | Garfield | Washington | 53023 | 120 | 5 |
1241649 | 1241649 | 2021-04-20 | Garfield | Washington | 53023 | 120 | 5 |
1238402 | 1238402 | 2021-04-19 | Garfield | Washington | 53023 | 120 | 5 |
1235155 | 1235155 | 2021-04-18 | Garfield | Washington | 53023 | 120 | 5 |
1231907 | 1231907 | 2021-04-17 | Garfield | Washington | 53023 | 120 | 5 |
1228659 | 1228659 | 2021-04-16 | Garfield | Washington | 53023 | 120 | 5 |
1225411 | 1225411 | 2021-04-15 | Garfield | Washington | 53023 | 120 | 5 |
1222164 | 1222164 | 2021-04-14 | Garfield | Washington | 53023 | 120 | 5 |
1218916 | 1218916 | 2021-04-13 | Garfield | Washington | 53023 | 120 | 5 |
1215668 | 1215668 | 2021-04-12 | Garfield | Washington | 53023 | 120 | 5 |
1212421 | 1212421 | 2021-04-11 | Garfield | Washington | 53023 | 120 | 5 |
1209172 | 1209172 | 2021-04-10 | Garfield | Washington | 53023 | 120 | 5 |
1205924 | 1205924 | 2021-04-09 | Garfield | Washington | 53023 | 120 | 5 |
1202676 | 1202676 | 2021-04-08 | Garfield | Washington | 53023 | 120 | 5 |
1199428 | 1199428 | 2021-04-07 | Garfield | Washington | 53023 | 120 | 5 |
1196179 | 1196179 | 2021-04-06 | Garfield | Washington | 53023 | 120 | 5 |
1192931 | 1192931 | 2021-04-05 | Garfield | Washington | 53023 | 120 | 5 |
1189681 | 1189681 | 2021-04-04 | Garfield | Washington | 53023 | 120 | 5 |
1186434 | 1186434 | 2021-04-03 | Garfield | Washington | 53023 | 120 | 5 |
1183187 | 1183187 | 2021-04-02 | Garfield | Washington | 53023 | 120 | 5 |
1179940 | 1179940 | 2021-04-01 | Garfield | Washington | 53023 | 120 | 5 |
1176693 | 1176693 | 2021-03-31 | Garfield | Washington | 53023 | 120 | 5 |
1173446 | 1173446 | 2021-03-30 | Garfield | Washington | 53023 | 120 | 5 |
1170199 | 1170199 | 2021-03-29 | Garfield | Washington | 53023 | 120 | 5 |
1166951 | 1166951 | 2021-03-28 | Garfield | Washington | 53023 | 120 | 5 |
1163703 | 1163703 | 2021-03-27 | Garfield | Washington | 53023 | 120 | 5 |
1160455 | 1160455 | 2021-03-26 | Garfield | Washington | 53023 | 120 | 5 |
1157207 | 1157207 | 2021-03-25 | Garfield | Washington | 53023 | 120 | 5 |
1153960 | 1153960 | 2021-03-24 | Garfield | Washington | 53023 | 120 | 5 |
1150713 | 1150713 | 2021-03-23 | Garfield | Washington | 53023 | 120 | 5 |
1147466 | 1147466 | 2021-03-22 | Garfield | Washington | 53023 | 119 | 5 |
1144219 | 1144219 | 2021-03-21 | Garfield | Washington | 53023 | 119 | 5 |
1140972 | 1140972 | 2021-03-20 | Garfield | Washington | 53023 | 119 | 5 |
1137726 | 1137726 | 2021-03-19 | Garfield | Washington | 53023 | 119 | 5 |
1134480 | 1134480 | 2021-03-18 | Garfield | Washington | 53023 | 117 | 5 |
1131232 | 1131232 | 2021-03-17 | Garfield | Washington | 53023 | 117 | 5 |
1127985 | 1127985 | 2021-03-16 | Garfield | Washington | 53023 | 117 | 4 |
1124739 | 1124739 | 2021-03-15 | Garfield | Washington | 53023 | 117 | 4 |
1121493 | 1121493 | 2021-03-14 | Garfield | Washington | 53023 | 117 | 4 |
1118246 | 1118246 | 2021-03-13 | Garfield | Washington | 53023 | 117 | 4 |
1114999 | 1114999 | 2021-03-12 | Garfield | Washington | 53023 | 117 | 4 |
1111753 | 1111753 | 2021-03-11 | Garfield | Washington | 53023 | 117 | 4 |
1108507 | 1108507 | 2021-03-10 | Garfield | Washington | 53023 | 117 | 4 |
1105261 | 1105261 | 2021-03-09 | Garfield | Washington | 53023 | 117 | 4 |
1102015 | 1102015 | 2021-03-08 | Garfield | Washington | 53023 | 117 | 4 |
1098769 | 1098769 | 2021-03-07 | Garfield | Washington | 53023 | 117 | 4 |
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);