ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
724 rows where fips = 2997 and state = "Alaska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1413955 | 1413955 | 2021-06-13 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 200 | 0 |
1410710 | 1410710 | 2021-06-12 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 200 | 0 |
1407465 | 1407465 | 2021-06-11 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 200 | 0 |
1404219 | 1404219 | 2021-06-10 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 199 | 0 |
1400974 | 1400974 | 2021-06-09 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 199 | 0 |
1397729 | 1397729 | 2021-06-08 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 198 | 0 |
1394482 | 1394482 | 2021-06-07 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 198 | 0 |
1391237 | 1391237 | 2021-06-06 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1387992 | 1387992 | 2021-06-05 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1384747 | 1384747 | 2021-06-04 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1381501 | 1381501 | 2021-06-03 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1378256 | 1378256 | 2021-06-02 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1375010 | 1375010 | 2021-06-01 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1371765 | 1371765 | 2021-05-31 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1368519 | 1368519 | 2021-05-30 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1365273 | 1365273 | 2021-05-29 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1362027 | 1362027 | 2021-05-28 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1358781 | 1358781 | 2021-05-27 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1355535 | 1355535 | 2021-05-26 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1352289 | 1352289 | 2021-05-25 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1349043 | 1349043 | 2021-05-24 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1345795 | 1345795 | 2021-05-23 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1342547 | 1342547 | 2021-05-22 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1339299 | 1339299 | 2021-05-21 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1336052 | 1336052 | 2021-05-20 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1332805 | 1332805 | 2021-05-19 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1329558 | 1329558 | 2021-05-18 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1326312 | 1326312 | 2021-05-17 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1323066 | 1323066 | 2021-05-16 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 195 | 0 |
1319820 | 1319820 | 2021-05-15 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 195 | 0 |
1316572 | 1316572 | 2021-05-14 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 195 | 0 |
1313326 | 1313326 | 2021-05-13 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 195 | 0 |
1310079 | 1310079 | 2021-05-12 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 195 | 0 |
1306833 | 1306833 | 2021-05-11 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 195 | 0 |
1303587 | 1303587 | 2021-05-10 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 195 | 0 |
1300340 | 1300340 | 2021-05-09 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 194 | 0 |
1297093 | 1297093 | 2021-05-08 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 194 | 0 |
1293847 | 1293847 | 2021-05-07 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 194 | 0 |
1290601 | 1290601 | 2021-05-06 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 194 | 0 |
1287355 | 1287355 | 2021-05-05 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 194 | 0 |
1284109 | 1284109 | 2021-05-04 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 194 | 0 |
1280862 | 1280862 | 2021-05-03 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 194 | 0 |
1277615 | 1277615 | 2021-05-02 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 194 | 0 |
1274368 | 1274368 | 2021-05-01 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 194 | 0 |
1271121 | 1271121 | 2021-04-30 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 194 | 0 |
1267874 | 1267874 | 2021-04-29 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 194 | 0 |
1264627 | 1264627 | 2021-04-28 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 194 | 0 |
1261380 | 1261380 | 2021-04-27 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 192 | 0 |
1258133 | 1258133 | 2021-04-26 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 192 | 0 |
1254886 | 1254886 | 2021-04-25 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 192 | 0 |
1251639 | 1251639 | 2021-04-24 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 192 | 0 |
1248392 | 1248392 | 2021-04-23 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 192 | 0 |
1245145 | 1245145 | 2021-04-22 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 192 | 0 |
1241898 | 1241898 | 2021-04-21 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 192 | 0 |
1238651 | 1238651 | 2021-04-20 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 192 | 0 |
1235404 | 1235404 | 2021-04-19 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 192 | 0 |
1232156 | 1232156 | 2021-04-18 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 192 | 0 |
1228908 | 1228908 | 2021-04-17 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 192 | 0 |
1225660 | 1225660 | 2021-04-16 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 192 | 0 |
1222413 | 1222413 | 2021-04-15 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 193 | 0 |
1219165 | 1219165 | 2021-04-14 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 189 | 0 |
1215917 | 1215917 | 2021-04-13 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 188 | 0 |
1212670 | 1212670 | 2021-04-12 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 187 | 0 |
1209421 | 1209421 | 2021-04-11 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 187 | 0 |
1206173 | 1206173 | 2021-04-10 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 187 | 0 |
1202925 | 1202925 | 2021-04-09 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 187 | 0 |
1199677 | 1199677 | 2021-04-08 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 187 | 0 |
1196428 | 1196428 | 2021-04-07 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 187 | 0 |
1193180 | 1193180 | 2021-04-06 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 187 | 0 |
1189930 | 1189930 | 2021-04-05 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 187 | 0 |
1186683 | 1186683 | 2021-04-04 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 186 | 0 |
1183436 | 1183436 | 2021-04-03 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 186 | 0 |
1180189 | 1180189 | 2021-04-02 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 186 | 0 |
1176942 | 1176942 | 2021-04-01 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 186 | 0 |
1173695 | 1173695 | 2021-03-31 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 184 | 0 |
1170448 | 1170448 | 2021-03-30 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 184 | 0 |
1167200 | 1167200 | 2021-03-29 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 184 | 0 |
1163952 | 1163952 | 2021-03-28 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 184 | 0 |
1160704 | 1160704 | 2021-03-27 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 184 | 0 |
1157456 | 1157456 | 2021-03-26 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 184 | 0 |
1154209 | 1154209 | 2021-03-25 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 184 | 0 |
1150962 | 1150962 | 2021-03-24 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 184 | 0 |
1147715 | 1147715 | 2021-03-23 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 184 | 0 |
1144468 | 1144468 | 2021-03-22 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 184 | 0 |
1141221 | 1141221 | 2021-03-21 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 176 | 0 |
1137975 | 1137975 | 2021-03-20 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 176 | 0 |
1134729 | 1134729 | 2021-03-19 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 176 | 0 |
1131481 | 1131481 | 2021-03-18 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 176 | 0 |
1128234 | 1128234 | 2021-03-17 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 176 | 0 |
1124988 | 1124988 | 2021-03-16 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 176 | 0 |
1121742 | 1121742 | 2021-03-15 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 176 | 0 |
1118495 | 1118495 | 2021-03-14 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 176 | 0 |
1115248 | 1115248 | 2021-03-13 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 176 | 0 |
1112002 | 1112002 | 2021-03-12 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 176 | 0 |
1108756 | 1108756 | 2021-03-11 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 176 | 0 |
1105510 | 1105510 | 2021-03-10 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 176 | 0 |
1102264 | 1102264 | 2021-03-09 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 176 | 0 |
1099018 | 1099018 | 2021-03-08 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 176 | 0 |
1095770 | 1095770 | 2021-03-07 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 176 | 0 |
1092524 | 1092524 | 2021-03-06 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 176 | 0 |
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);