ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Juneau City and Borough" and state = "Alaska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1413960 | 1413960 | 2021-06-13 | Juneau City and Borough | Alaska | 2110 | 1449 | 3 |
1410715 | 1410715 | 2021-06-12 | Juneau City and Borough | Alaska | 2110 | 1449 | 3 |
1407470 | 1407470 | 2021-06-11 | Juneau City and Borough | Alaska | 2110 | 1449 | 3 |
1404224 | 1404224 | 2021-06-10 | Juneau City and Borough | Alaska | 2110 | 1446 | 3 |
1400979 | 1400979 | 2021-06-09 | Juneau City and Borough | Alaska | 2110 | 1446 | 3 |
1397734 | 1397734 | 2021-06-08 | Juneau City and Borough | Alaska | 2110 | 1441 | 3 |
1394487 | 1394487 | 2021-06-07 | Juneau City and Borough | Alaska | 2110 | 1441 | 3 |
1391242 | 1391242 | 2021-06-06 | Juneau City and Borough | Alaska | 2110 | 1439 | 3 |
1387997 | 1387997 | 2021-06-05 | Juneau City and Borough | Alaska | 2110 | 1439 | 3 |
1384752 | 1384752 | 2021-06-04 | Juneau City and Borough | Alaska | 2110 | 1439 | 3 |
1381506 | 1381506 | 2021-06-03 | Juneau City and Borough | Alaska | 2110 | 1434 | 3 |
1378261 | 1378261 | 2021-06-02 | Juneau City and Borough | Alaska | 2110 | 1426 | 3 |
1375015 | 1375015 | 2021-06-01 | Juneau City and Borough | Alaska | 2110 | 1421 | 3 |
1371770 | 1371770 | 2021-05-31 | Juneau City and Borough | Alaska | 2110 | 1414 | 3 |
1368524 | 1368524 | 2021-05-30 | Juneau City and Borough | Alaska | 2110 | 1414 | 3 |
1365278 | 1365278 | 2021-05-29 | Juneau City and Borough | Alaska | 2110 | 1414 | 3 |
1362032 | 1362032 | 2021-05-28 | Juneau City and Borough | Alaska | 2110 | 1414 | 3 |
1358786 | 1358786 | 2021-05-27 | Juneau City and Borough | Alaska | 2110 | 1410 | 3 |
1355540 | 1355540 | 2021-05-26 | Juneau City and Borough | Alaska | 2110 | 1411 | 3 |
1352294 | 1352294 | 2021-05-25 | Juneau City and Borough | Alaska | 2110 | 1409 | 3 |
1349048 | 1349048 | 2021-05-24 | Juneau City and Borough | Alaska | 2110 | 1407 | 3 |
1345800 | 1345800 | 2021-05-23 | Juneau City and Borough | Alaska | 2110 | 1406 | 3 |
1342552 | 1342552 | 2021-05-22 | Juneau City and Borough | Alaska | 2110 | 1406 | 3 |
1339304 | 1339304 | 2021-05-21 | Juneau City and Borough | Alaska | 2110 | 1406 | 3 |
1336057 | 1336057 | 2021-05-20 | Juneau City and Borough | Alaska | 2110 | 1405 | 3 |
1332810 | 1332810 | 2021-05-19 | Juneau City and Borough | Alaska | 2110 | 1405 | 3 |
1329563 | 1329563 | 2021-05-18 | Juneau City and Borough | Alaska | 2110 | 1402 | 3 |
1326317 | 1326317 | 2021-05-17 | Juneau City and Borough | Alaska | 2110 | 1399 | 3 |
1323071 | 1323071 | 2021-05-16 | Juneau City and Borough | Alaska | 2110 | 1398 | 3 |
1319825 | 1319825 | 2021-05-15 | Juneau City and Borough | Alaska | 2110 | 1398 | 3 |
1316577 | 1316577 | 2021-05-14 | Juneau City and Borough | Alaska | 2110 | 1398 | 3 |
1313331 | 1313331 | 2021-05-13 | Juneau City and Borough | Alaska | 2110 | 1391 | 3 |
1310084 | 1310084 | 2021-05-12 | Juneau City and Borough | Alaska | 2110 | 1390 | 3 |
1306838 | 1306838 | 2021-05-11 | Juneau City and Borough | Alaska | 2110 | 1385 | 3 |
1303592 | 1303592 | 2021-05-10 | Juneau City and Borough | Alaska | 2110 | 1384 | 3 |
1300345 | 1300345 | 2021-05-09 | Juneau City and Borough | Alaska | 2110 | 1374 | 3 |
1297098 | 1297098 | 2021-05-08 | Juneau City and Borough | Alaska | 2110 | 1374 | 3 |
1293852 | 1293852 | 2021-05-07 | Juneau City and Borough | Alaska | 2110 | 1374 | 3 |
1290606 | 1290606 | 2021-05-06 | Juneau City and Borough | Alaska | 2110 | 1369 | 3 |
1287360 | 1287360 | 2021-05-05 | Juneau City and Borough | Alaska | 2110 | 1367 | 3 |
1284114 | 1284114 | 2021-05-04 | Juneau City and Borough | Alaska | 2110 | 1365 | 3 |
1280867 | 1280867 | 2021-05-03 | Juneau City and Borough | Alaska | 2110 | 1363 | 3 |
1277620 | 1277620 | 2021-05-02 | Juneau City and Borough | Alaska | 2110 | 1351 | 3 |
1274373 | 1274373 | 2021-05-01 | Juneau City and Borough | Alaska | 2110 | 1351 | 3 |
1271126 | 1271126 | 2021-04-30 | Juneau City and Borough | Alaska | 2110 | 1351 | 3 |
1267879 | 1267879 | 2021-04-29 | Juneau City and Borough | Alaska | 2110 | 1348 | 3 |
1264632 | 1264632 | 2021-04-28 | Juneau City and Borough | Alaska | 2110 | 1346 | 3 |
1261385 | 1261385 | 2021-04-27 | Juneau City and Borough | Alaska | 2110 | 1343 | 3 |
1258138 | 1258138 | 2021-04-26 | Juneau City and Borough | Alaska | 2110 | 1343 | 3 |
1254891 | 1254891 | 2021-04-25 | Juneau City and Borough | Alaska | 2110 | 1340 | 3 |
1251644 | 1251644 | 2021-04-24 | Juneau City and Borough | Alaska | 2110 | 1340 | 3 |
1248397 | 1248397 | 2021-04-23 | Juneau City and Borough | Alaska | 2110 | 1340 | 3 |
1245150 | 1245150 | 2021-04-22 | Juneau City and Borough | Alaska | 2110 | 1337 | 3 |
1241903 | 1241903 | 2021-04-21 | Juneau City and Borough | Alaska | 2110 | 1333 | 3 |
1238656 | 1238656 | 2021-04-20 | Juneau City and Borough | Alaska | 2110 | 1328 | 3 |
1235409 | 1235409 | 2021-04-19 | Juneau City and Borough | Alaska | 2110 | 1328 | 3 |
1232161 | 1232161 | 2021-04-18 | Juneau City and Borough | Alaska | 2110 | 1315 | 3 |
1228913 | 1228913 | 2021-04-17 | Juneau City and Borough | Alaska | 2110 | 1315 | 3 |
1225665 | 1225665 | 2021-04-16 | Juneau City and Borough | Alaska | 2110 | 1315 | 3 |
1222418 | 1222418 | 2021-04-15 | Juneau City and Borough | Alaska | 2110 | 1314 | 3 |
1219170 | 1219170 | 2021-04-14 | Juneau City and Borough | Alaska | 2110 | 1313 | 3 |
1215922 | 1215922 | 2021-04-13 | Juneau City and Borough | Alaska | 2110 | 1307 | 3 |
1212675 | 1212675 | 2021-04-12 | Juneau City and Borough | Alaska | 2110 | 1306 | 3 |
1209426 | 1209426 | 2021-04-11 | Juneau City and Borough | Alaska | 2110 | 1300 | 3 |
1206178 | 1206178 | 2021-04-10 | Juneau City and Borough | Alaska | 2110 | 1300 | 3 |
1202930 | 1202930 | 2021-04-09 | Juneau City and Borough | Alaska | 2110 | 1300 | 3 |
1199682 | 1199682 | 2021-04-08 | Juneau City and Borough | Alaska | 2110 | 1295 | 3 |
1196433 | 1196433 | 2021-04-07 | Juneau City and Borough | Alaska | 2110 | 1289 | 3 |
1193185 | 1193185 | 2021-04-06 | Juneau City and Borough | Alaska | 2110 | 1281 | 3 |
1189935 | 1189935 | 2021-04-05 | Juneau City and Borough | Alaska | 2110 | 1279 | 3 |
1186688 | 1186688 | 2021-04-04 | Juneau City and Borough | Alaska | 2110 | 1271 | 3 |
1183441 | 1183441 | 2021-04-03 | Juneau City and Borough | Alaska | 2110 | 1271 | 3 |
1180194 | 1180194 | 2021-04-02 | Juneau City and Borough | Alaska | 2110 | 1271 | 3 |
1176947 | 1176947 | 2021-04-01 | Juneau City and Borough | Alaska | 2110 | 1270 | 3 |
1173700 | 1173700 | 2021-03-31 | Juneau City and Borough | Alaska | 2110 | 1264 | 3 |
1170453 | 1170453 | 2021-03-30 | Juneau City and Borough | Alaska | 2110 | 1264 | 3 |
1167205 | 1167205 | 2021-03-29 | Juneau City and Borough | Alaska | 2110 | 1257 | 3 |
1163957 | 1163957 | 2021-03-28 | Juneau City and Borough | Alaska | 2110 | 1257 | 3 |
1160709 | 1160709 | 2021-03-27 | Juneau City and Borough | Alaska | 2110 | 1257 | 3 |
1157461 | 1157461 | 2021-03-26 | Juneau City and Borough | Alaska | 2110 | 1257 | 3 |
1154214 | 1154214 | 2021-03-25 | Juneau City and Borough | Alaska | 2110 | 1257 | 3 |
1150967 | 1150967 | 2021-03-24 | Juneau City and Borough | Alaska | 2110 | 1257 | 3 |
1147720 | 1147720 | 2021-03-23 | Juneau City and Borough | Alaska | 2110 | 1255 | 3 |
1144473 | 1144473 | 2021-03-22 | Juneau City and Borough | Alaska | 2110 | 1255 | 3 |
1141226 | 1141226 | 2021-03-21 | Juneau City and Borough | Alaska | 2110 | 1254 | 3 |
1137980 | 1137980 | 2021-03-20 | Juneau City and Borough | Alaska | 2110 | 1254 | 3 |
1134734 | 1134734 | 2021-03-19 | Juneau City and Borough | Alaska | 2110 | 1254 | 3 |
1131486 | 1131486 | 2021-03-18 | Juneau City and Borough | Alaska | 2110 | 1254 | 3 |
1128239 | 1128239 | 2021-03-17 | Juneau City and Borough | Alaska | 2110 | 1253 | 3 |
1124993 | 1124993 | 2021-03-16 | Juneau City and Borough | Alaska | 2110 | 1251 | 3 |
1121747 | 1121747 | 2021-03-15 | Juneau City and Borough | Alaska | 2110 | 1251 | 3 |
1118500 | 1118500 | 2021-03-14 | Juneau City and Borough | Alaska | 2110 | 1242 | 3 |
1115253 | 1115253 | 2021-03-13 | Juneau City and Borough | Alaska | 2110 | 1242 | 3 |
1112007 | 1112007 | 2021-03-12 | Juneau City and Borough | Alaska | 2110 | 1242 | 3 |
1108761 | 1108761 | 2021-03-11 | Juneau City and Borough | Alaska | 2110 | 1242 | 3 |
1105515 | 1105515 | 2021-03-10 | Juneau City and Borough | Alaska | 2110 | 1241 | 3 |
1102269 | 1102269 | 2021-03-09 | Juneau City and Borough | Alaska | 2110 | 1238 | 3 |
1099023 | 1099023 | 2021-03-08 | Juneau City and Borough | Alaska | 2110 | 1237 | 3 |
1095775 | 1095775 | 2021-03-07 | Juneau City and Borough | Alaska | 2110 | 1234 | 3 |
1092529 | 1092529 | 2021-03-06 | Juneau City and Borough | Alaska | 2110 | 1234 | 3 |
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);