ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Adams" and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417687 | 1417687 | 2021-06-14 | Adams | Idaho | 16003 | 342 | 4 |
1414441 | 1414441 | 2021-06-13 | Adams | Idaho | 16003 | 342 | 4 |
1411196 | 1411196 | 2021-06-12 | Adams | Idaho | 16003 | 342 | 4 |
1407951 | 1407951 | 2021-06-11 | Adams | Idaho | 16003 | 342 | 4 |
1404705 | 1404705 | 2021-06-10 | Adams | Idaho | 16003 | 342 | 4 |
1401460 | 1401460 | 2021-06-09 | Adams | Idaho | 16003 | 342 | 4 |
1398215 | 1398215 | 2021-06-08 | Adams | Idaho | 16003 | 342 | 4 |
1394968 | 1394968 | 2021-06-07 | Adams | Idaho | 16003 | 341 | 4 |
1391723 | 1391723 | 2021-06-06 | Adams | Idaho | 16003 | 341 | 4 |
1388478 | 1388478 | 2021-06-05 | Adams | Idaho | 16003 | 341 | 4 |
1385233 | 1385233 | 2021-06-04 | Adams | Idaho | 16003 | 341 | 4 |
1381987 | 1381987 | 2021-06-03 | Adams | Idaho | 16003 | 341 | 4 |
1378742 | 1378742 | 2021-06-02 | Adams | Idaho | 16003 | 341 | 4 |
1375496 | 1375496 | 2021-06-01 | Adams | Idaho | 16003 | 341 | 4 |
1372251 | 1372251 | 2021-05-31 | Adams | Idaho | 16003 | 341 | 4 |
1369006 | 1369006 | 2021-05-30 | Adams | Idaho | 16003 | 341 | 4 |
1365760 | 1365760 | 2021-05-29 | Adams | Idaho | 16003 | 341 | 4 |
1362514 | 1362514 | 2021-05-28 | Adams | Idaho | 16003 | 341 | 4 |
1359267 | 1359267 | 2021-05-27 | Adams | Idaho | 16003 | 341 | 4 |
1356021 | 1356021 | 2021-05-26 | Adams | Idaho | 16003 | 341 | 4 |
1352775 | 1352775 | 2021-05-25 | Adams | Idaho | 16003 | 341 | 4 |
1349529 | 1349529 | 2021-05-24 | Adams | Idaho | 16003 | 341 | 4 |
1346282 | 1346282 | 2021-05-23 | Adams | Idaho | 16003 | 341 | 4 |
1343034 | 1343034 | 2021-05-22 | Adams | Idaho | 16003 | 341 | 4 |
1339786 | 1339786 | 2021-05-21 | Adams | Idaho | 16003 | 341 | 4 |
1336539 | 1336539 | 2021-05-20 | Adams | Idaho | 16003 | 341 | 4 |
1333292 | 1333292 | 2021-05-19 | Adams | Idaho | 16003 | 341 | 4 |
1330045 | 1330045 | 2021-05-18 | Adams | Idaho | 16003 | 341 | 4 |
1326798 | 1326798 | 2021-05-17 | Adams | Idaho | 16003 | 341 | 4 |
1323552 | 1323552 | 2021-05-16 | Adams | Idaho | 16003 | 341 | 4 |
1320306 | 1320306 | 2021-05-15 | Adams | Idaho | 16003 | 341 | 4 |
1317059 | 1317059 | 2021-05-14 | Adams | Idaho | 16003 | 341 | 4 |
1313812 | 1313812 | 2021-05-13 | Adams | Idaho | 16003 | 341 | 4 |
1310565 | 1310565 | 2021-05-12 | Adams | Idaho | 16003 | 341 | 4 |
1307319 | 1307319 | 2021-05-11 | Adams | Idaho | 16003 | 340 | 4 |
1304073 | 1304073 | 2021-05-10 | Adams | Idaho | 16003 | 339 | 4 |
1300826 | 1300826 | 2021-05-09 | Adams | Idaho | 16003 | 339 | 4 |
1297579 | 1297579 | 2021-05-08 | Adams | Idaho | 16003 | 339 | 4 |
1294333 | 1294333 | 2021-05-07 | Adams | Idaho | 16003 | 339 | 4 |
1291087 | 1291087 | 2021-05-06 | Adams | Idaho | 16003 | 339 | 4 |
1287841 | 1287841 | 2021-05-05 | Adams | Idaho | 16003 | 339 | 4 |
1284595 | 1284595 | 2021-05-04 | Adams | Idaho | 16003 | 339 | 4 |
1281348 | 1281348 | 2021-05-03 | Adams | Idaho | 16003 | 339 | 4 |
1278101 | 1278101 | 2021-05-02 | Adams | Idaho | 16003 | 339 | 4 |
1274854 | 1274854 | 2021-05-01 | Adams | Idaho | 16003 | 339 | 4 |
1271607 | 1271607 | 2021-04-30 | Adams | Idaho | 16003 | 339 | 4 |
1268360 | 1268360 | 2021-04-29 | Adams | Idaho | 16003 | 339 | 4 |
1265113 | 1265113 | 2021-04-28 | Adams | Idaho | 16003 | 339 | 4 |
1261866 | 1261866 | 2021-04-27 | Adams | Idaho | 16003 | 339 | 4 |
1258619 | 1258619 | 2021-04-26 | Adams | Idaho | 16003 | 339 | 4 |
1255372 | 1255372 | 2021-04-25 | Adams | Idaho | 16003 | 337 | 4 |
1252125 | 1252125 | 2021-04-24 | Adams | Idaho | 16003 | 337 | 4 |
1248878 | 1248878 | 2021-04-23 | Adams | Idaho | 16003 | 337 | 4 |
1245631 | 1245631 | 2021-04-22 | Adams | Idaho | 16003 | 337 | 4 |
1242384 | 1242384 | 2021-04-21 | Adams | Idaho | 16003 | 337 | 4 |
1239137 | 1239137 | 2021-04-20 | Adams | Idaho | 16003 | 337 | 4 |
1235890 | 1235890 | 2021-04-19 | Adams | Idaho | 16003 | 337 | 4 |
1232643 | 1232643 | 2021-04-18 | Adams | Idaho | 16003 | 336 | 4 |
1229394 | 1229394 | 2021-04-17 | Adams | Idaho | 16003 | 336 | 4 |
1226146 | 1226146 | 2021-04-16 | Adams | Idaho | 16003 | 336 | 4 |
1222899 | 1222899 | 2021-04-15 | Adams | Idaho | 16003 | 336 | 4 |
1219651 | 1219651 | 2021-04-14 | Adams | Idaho | 16003 | 336 | 4 |
1216403 | 1216403 | 2021-04-13 | Adams | Idaho | 16003 | 336 | 4 |
1213156 | 1213156 | 2021-04-12 | Adams | Idaho | 16003 | 336 | 4 |
1209908 | 1209908 | 2021-04-11 | Adams | Idaho | 16003 | 336 | 4 |
1206659 | 1206659 | 2021-04-10 | Adams | Idaho | 16003 | 336 | 4 |
1203411 | 1203411 | 2021-04-09 | Adams | Idaho | 16003 | 336 | 4 |
1200163 | 1200163 | 2021-04-08 | Adams | Idaho | 16003 | 336 | 4 |
1196914 | 1196914 | 2021-04-07 | Adams | Idaho | 16003 | 336 | 4 |
1193666 | 1193666 | 2021-04-06 | Adams | Idaho | 16003 | 336 | 4 |
1190416 | 1190416 | 2021-04-05 | Adams | Idaho | 16003 | 336 | 4 |
1187169 | 1187169 | 2021-04-04 | Adams | Idaho | 16003 | 336 | 4 |
1183922 | 1183922 | 2021-04-03 | Adams | Idaho | 16003 | 336 | 4 |
1180675 | 1180675 | 2021-04-02 | Adams | Idaho | 16003 | 336 | 4 |
1177428 | 1177428 | 2021-04-01 | Adams | Idaho | 16003 | 336 | 4 |
1174181 | 1174181 | 2021-03-31 | Adams | Idaho | 16003 | 336 | 4 |
1170934 | 1170934 | 2021-03-30 | Adams | Idaho | 16003 | 336 | 4 |
1167686 | 1167686 | 2021-03-29 | Adams | Idaho | 16003 | 336 | 4 |
1164438 | 1164438 | 2021-03-28 | Adams | Idaho | 16003 | 336 | 4 |
1161190 | 1161190 | 2021-03-27 | Adams | Idaho | 16003 | 336 | 4 |
1157942 | 1157942 | 2021-03-26 | Adams | Idaho | 16003 | 336 | 4 |
1154695 | 1154695 | 2021-03-25 | Adams | Idaho | 16003 | 336 | 4 |
1151448 | 1151448 | 2021-03-24 | Adams | Idaho | 16003 | 336 | 4 |
1148201 | 1148201 | 2021-03-23 | Adams | Idaho | 16003 | 336 | 4 |
1144954 | 1144954 | 2021-03-22 | Adams | Idaho | 16003 | 333 | 4 |
1141707 | 1141707 | 2021-03-21 | Adams | Idaho | 16003 | 332 | 4 |
1138461 | 1138461 | 2021-03-20 | Adams | Idaho | 16003 | 332 | 4 |
1135215 | 1135215 | 2021-03-19 | Adams | Idaho | 16003 | 332 | 4 |
1131968 | 1131968 | 2021-03-18 | Adams | Idaho | 16003 | 332 | 4 |
1128720 | 1128720 | 2021-03-17 | Adams | Idaho | 16003 | 332 | 4 |
1125474 | 1125474 | 2021-03-16 | Adams | Idaho | 16003 | 332 | 4 |
1122228 | 1122228 | 2021-03-15 | Adams | Idaho | 16003 | 332 | 4 |
1118981 | 1118981 | 2021-03-14 | Adams | Idaho | 16003 | 332 | 4 |
1115734 | 1115734 | 2021-03-13 | Adams | Idaho | 16003 | 332 | 4 |
1112488 | 1112488 | 2021-03-12 | Adams | Idaho | 16003 | 332 | 4 |
1109242 | 1109242 | 2021-03-11 | Adams | Idaho | 16003 | 332 | 4 |
1105996 | 1105996 | 2021-03-10 | Adams | Idaho | 16003 | 332 | 4 |
1102750 | 1102750 | 2021-03-09 | Adams | Idaho | 16003 | 332 | 4 |
1099504 | 1099504 | 2021-03-08 | Adams | Idaho | 16003 | 332 | 4 |
1096256 | 1096256 | 2021-03-07 | Adams | Idaho | 16003 | 331 | 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);