ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Strafford" and state = "New Hampshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418916 | 1418916 | 2021-06-14 | Strafford | New Hampshire | 33017 | 9990 | 95 |
1415671 | 1415671 | 2021-06-13 | Strafford | New Hampshire | 33017 | 9976 | 95 |
1412425 | 1412425 | 2021-06-12 | Strafford | New Hampshire | 33017 | 9976 | 95 |
1409180 | 1409180 | 2021-06-11 | Strafford | New Hampshire | 33017 | 9976 | 95 |
1405935 | 1405935 | 2021-06-10 | Strafford | New Hampshire | 33017 | 9973 | 95 |
1402689 | 1402689 | 2021-06-09 | Strafford | New Hampshire | 33017 | 9966 | 94 |
1399444 | 1399444 | 2021-06-08 | Strafford | New Hampshire | 33017 | 9953 | 94 |
1396198 | 1396198 | 2021-06-07 | Strafford | New Hampshire | 33017 | 9952 | 94 |
1392952 | 1392952 | 2021-06-06 | Strafford | New Hampshire | 33017 | 9932 | 94 |
1389707 | 1389707 | 2021-06-05 | Strafford | New Hampshire | 33017 | 9932 | 94 |
1386462 | 1386462 | 2021-06-04 | Strafford | New Hampshire | 33017 | 9932 | 94 |
1383217 | 1383217 | 2021-06-03 | Strafford | New Hampshire | 33017 | 9924 | 94 |
1379971 | 1379971 | 2021-06-02 | Strafford | New Hampshire | 33017 | 9918 | 94 |
1376726 | 1376726 | 2021-06-01 | Strafford | New Hampshire | 33017 | 9914 | 94 |
1373480 | 1373480 | 2021-05-31 | Strafford | New Hampshire | 33017 | 9904 | 94 |
1370235 | 1370235 | 2021-05-30 | Strafford | New Hampshire | 33017 | 9904 | 94 |
1366989 | 1366989 | 2021-05-29 | Strafford | New Hampshire | 33017 | 9898 | 93 |
1363743 | 1363743 | 2021-05-28 | Strafford | New Hampshire | 33017 | 9887 | 92 |
1360497 | 1360497 | 2021-05-27 | Strafford | New Hampshire | 33017 | 9874 | 92 |
1357251 | 1357251 | 2021-05-26 | Strafford | New Hampshire | 33017 | 9854 | 90 |
1354005 | 1354005 | 2021-05-25 | Strafford | New Hampshire | 33017 | 9840 | 90 |
1350759 | 1350759 | 2021-05-24 | Strafford | New Hampshire | 33017 | 9831 | 90 |
1347513 | 1347513 | 2021-05-23 | Strafford | New Hampshire | 33017 | 9828 | 90 |
1344265 | 1344265 | 2021-05-22 | Strafford | New Hampshire | 33017 | 9817 | 90 |
1341017 | 1341017 | 2021-05-21 | Strafford | New Hampshire | 33017 | 9808 | 89 |
1337769 | 1337769 | 2021-05-20 | Strafford | New Hampshire | 33017 | 9793 | 89 |
1334522 | 1334522 | 2021-05-19 | Strafford | New Hampshire | 33017 | 9783 | 88 |
1331275 | 1331275 | 2021-05-18 | Strafford | New Hampshire | 33017 | 9773 | 88 |
1328028 | 1328028 | 2021-05-17 | Strafford | New Hampshire | 33017 | 9766 | 87 |
1324782 | 1324782 | 2021-05-16 | Strafford | New Hampshire | 33017 | 9758 | 87 |
1321536 | 1321536 | 2021-05-15 | Strafford | New Hampshire | 33017 | 9743 | 87 |
1318290 | 1318290 | 2021-05-14 | Strafford | New Hampshire | 33017 | 9734 | 87 |
1315042 | 1315042 | 2021-05-13 | Strafford | New Hampshire | 33017 | 9707 | 87 |
1311796 | 1311796 | 2021-05-12 | Strafford | New Hampshire | 33017 | 9685 | 85 |
1308549 | 1308549 | 2021-05-11 | Strafford | New Hampshire | 33017 | 9650 | 84 |
1305303 | 1305303 | 2021-05-10 | Strafford | New Hampshire | 33017 | 9640 | 82 |
1302057 | 1302057 | 2021-05-09 | Strafford | New Hampshire | 33017 | 9627 | 82 |
1298809 | 1298809 | 2021-05-08 | Strafford | New Hampshire | 33017 | 9605 | 82 |
1295563 | 1295563 | 2021-05-07 | Strafford | New Hampshire | 33017 | 9585 | 82 |
1292317 | 1292317 | 2021-05-06 | Strafford | New Hampshire | 33017 | 9552 | 82 |
1289071 | 1289071 | 2021-05-05 | Strafford | New Hampshire | 33017 | 9514 | 82 |
1285825 | 1285825 | 2021-05-04 | Strafford | New Hampshire | 33017 | 9502 | 82 |
1282579 | 1282579 | 2021-05-03 | Strafford | New Hampshire | 33017 | 9485 | 82 |
1279332 | 1279332 | 2021-05-02 | Strafford | New Hampshire | 33017 | 9474 | 82 |
1276085 | 1276085 | 2021-05-01 | Strafford | New Hampshire | 33017 | 9441 | 82 |
1272838 | 1272838 | 2021-04-30 | Strafford | New Hampshire | 33017 | 9401 | 81 |
1269591 | 1269591 | 2021-04-29 | Strafford | New Hampshire | 33017 | 9375 | 81 |
1266344 | 1266344 | 2021-04-28 | Strafford | New Hampshire | 33017 | 9349 | 80 |
1263097 | 1263097 | 2021-04-27 | Strafford | New Hampshire | 33017 | 9311 | 81 |
1259850 | 1259850 | 2021-04-26 | Strafford | New Hampshire | 33017 | 9285 | 79 |
1256603 | 1256603 | 2021-04-25 | Strafford | New Hampshire | 33017 | 9256 | 79 |
1253356 | 1253356 | 2021-04-24 | Strafford | New Hampshire | 33017 | 9218 | 79 |
1250109 | 1250109 | 2021-04-23 | Strafford | New Hampshire | 33017 | 9179 | 79 |
1246862 | 1246862 | 2021-04-22 | Strafford | New Hampshire | 33017 | 9141 | 77 |
1243615 | 1243615 | 2021-04-21 | Strafford | New Hampshire | 33017 | 9115 | 77 |
1240368 | 1240368 | 2021-04-20 | Strafford | New Hampshire | 33017 | 9074 | 76 |
1237121 | 1237121 | 2021-04-19 | Strafford | New Hampshire | 33017 | 9031 | 76 |
1233874 | 1233874 | 2021-04-18 | Strafford | New Hampshire | 33017 | 9002 | 76 |
1230626 | 1230626 | 2021-04-17 | Strafford | New Hampshire | 33017 | 8968 | 76 |
1227378 | 1227378 | 2021-04-16 | Strafford | New Hampshire | 33017 | 8930 | 76 |
1224130 | 1224130 | 2021-04-15 | Strafford | New Hampshire | 33017 | 8868 | 76 |
1220883 | 1220883 | 2021-04-14 | Strafford | New Hampshire | 33017 | 8811 | 76 |
1217635 | 1217635 | 2021-04-13 | Strafford | New Hampshire | 33017 | 8739 | 76 |
1214387 | 1214387 | 2021-04-12 | Strafford | New Hampshire | 33017 | 8695 | 76 |
1211140 | 1211140 | 2021-04-11 | Strafford | New Hampshire | 33017 | 8651 | 76 |
1207891 | 1207891 | 2021-04-10 | Strafford | New Hampshire | 33017 | 8591 | 76 |
1204643 | 1204643 | 2021-04-09 | Strafford | New Hampshire | 33017 | 8533 | 76 |
1201395 | 1201395 | 2021-04-08 | Strafford | New Hampshire | 33017 | 8442 | 76 |
1198146 | 1198146 | 2021-04-07 | Strafford | New Hampshire | 33017 | 8370 | 76 |
1194897 | 1194897 | 2021-04-06 | Strafford | New Hampshire | 33017 | 8321 | 76 |
1191648 | 1191648 | 2021-04-05 | Strafford | New Hampshire | 33017 | 8296 | 76 |
1188400 | 1188400 | 2021-04-04 | Strafford | New Hampshire | 33017 | 8249 | 76 |
1185153 | 1185153 | 2021-04-03 | Strafford | New Hampshire | 33017 | 8177 | 76 |
1181906 | 1181906 | 2021-04-02 | Strafford | New Hampshire | 33017 | 8136 | 76 |
1178659 | 1178659 | 2021-04-01 | Strafford | New Hampshire | 33017 | 8074 | 76 |
1175412 | 1175412 | 2021-03-31 | Strafford | New Hampshire | 33017 | 8017 | 76 |
1172165 | 1172165 | 2021-03-30 | Strafford | New Hampshire | 33017 | 7978 | 76 |
1168917 | 1168917 | 2021-03-29 | Strafford | New Hampshire | 33017 | 7944 | 76 |
1165669 | 1165669 | 2021-03-28 | Strafford | New Hampshire | 33017 | 7916 | 76 |
1162421 | 1162421 | 2021-03-27 | Strafford | New Hampshire | 33017 | 7884 | 76 |
1159173 | 1159173 | 2021-03-26 | Strafford | New Hampshire | 33017 | 7836 | 76 |
1155926 | 1155926 | 2021-03-25 | Strafford | New Hampshire | 33017 | 7798 | 76 |
1152679 | 1152679 | 2021-03-24 | Strafford | New Hampshire | 33017 | 7714 | 76 |
1149432 | 1149432 | 2021-03-23 | Strafford | New Hampshire | 33017 | 7674 | 76 |
1146185 | 1146185 | 2021-03-22 | Strafford | New Hampshire | 33017 | 7647 | 76 |
1142938 | 1142938 | 2021-03-21 | Strafford | New Hampshire | 33017 | 7623 | 76 |
1139691 | 1139691 | 2021-03-20 | Strafford | New Hampshire | 33017 | 7587 | 76 |
1136445 | 1136445 | 2021-03-19 | Strafford | New Hampshire | 33017 | 7537 | 76 |
1133199 | 1133199 | 2021-03-18 | Strafford | New Hampshire | 33017 | 7481 | 76 |
1129951 | 1129951 | 2021-03-17 | Strafford | New Hampshire | 33017 | 7455 | 76 |
1126704 | 1126704 | 2021-03-16 | Strafford | New Hampshire | 33017 | 7413 | 76 |
1123458 | 1123458 | 2021-03-15 | Strafford | New Hampshire | 33017 | 7400 | 76 |
1120211 | 1120211 | 2021-03-14 | Strafford | New Hampshire | 33017 | 7384 | 76 |
1116964 | 1116964 | 2021-03-13 | Strafford | New Hampshire | 33017 | 7355 | 76 |
1113718 | 1113718 | 2021-03-12 | Strafford | New Hampshire | 33017 | 7328 | 76 |
1110472 | 1110472 | 2021-03-11 | Strafford | New Hampshire | 33017 | 7294 | 76 |
1107226 | 1107226 | 2021-03-10 | Strafford | New Hampshire | 33017 | 7255 | 76 |
1103980 | 1103980 | 2021-03-09 | Strafford | New Hampshire | 33017 | 7240 | 76 |
1100734 | 1100734 | 2021-03-08 | Strafford | New Hampshire | 33017 | 7237 | 76 |
1097487 | 1097487 | 2021-03-07 | Strafford | New Hampshire | 33017 | 7214 | 76 |
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);