ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
655 rows where county = "Adams" and fips = 38001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1467816 | 1467816 | 2021-06-29 | Adams | North Dakota | 38001 | 271 | 3 |
1464571 | 1464571 | 2021-06-28 | Adams | North Dakota | 38001 | 271 | 3 |
1461326 | 1461326 | 2021-06-27 | Adams | North Dakota | 38001 | 271 | 3 |
1458081 | 1458081 | 2021-06-26 | Adams | North Dakota | 38001 | 271 | 3 |
1454836 | 1454836 | 2021-06-25 | Adams | North Dakota | 38001 | 271 | 3 |
1451591 | 1451591 | 2021-06-24 | Adams | North Dakota | 38001 | 271 | 3 |
1448345 | 1448345 | 2021-06-23 | Adams | North Dakota | 38001 | 271 | 3 |
1445100 | 1445100 | 2021-06-22 | Adams | North Dakota | 38001 | 271 | 3 |
1441855 | 1441855 | 2021-06-21 | Adams | North Dakota | 38001 | 271 | 3 |
1438610 | 1438610 | 2021-06-20 | Adams | North Dakota | 38001 | 271 | 3 |
1435363 | 1435363 | 2021-06-19 | Adams | North Dakota | 38001 | 271 | 3 |
1432116 | 1432116 | 2021-06-18 | Adams | North Dakota | 38001 | 271 | 3 |
1428870 | 1428870 | 2021-06-17 | Adams | North Dakota | 38001 | 270 | 3 |
1425625 | 1425625 | 2021-06-16 | Adams | North Dakota | 38001 | 270 | 3 |
1422378 | 1422378 | 2021-06-15 | Adams | North Dakota | 38001 | 270 | 3 |
1419132 | 1419132 | 2021-06-14 | Adams | North Dakota | 38001 | 270 | 3 |
1415887 | 1415887 | 2021-06-13 | Adams | North Dakota | 38001 | 270 | 3 |
1412641 | 1412641 | 2021-06-12 | Adams | North Dakota | 38001 | 270 | 3 |
1409396 | 1409396 | 2021-06-11 | Adams | North Dakota | 38001 | 270 | 3 |
1406151 | 1406151 | 2021-06-10 | Adams | North Dakota | 38001 | 270 | 3 |
1402905 | 1402905 | 2021-06-09 | Adams | North Dakota | 38001 | 270 | 3 |
1399660 | 1399660 | 2021-06-08 | Adams | North Dakota | 38001 | 270 | 3 |
1396415 | 1396415 | 2021-06-07 | Adams | North Dakota | 38001 | 270 | 3 |
1393168 | 1393168 | 2021-06-06 | Adams | North Dakota | 38001 | 270 | 3 |
1389923 | 1389923 | 2021-06-05 | Adams | North Dakota | 38001 | 270 | 3 |
1386678 | 1386678 | 2021-06-04 | Adams | North Dakota | 38001 | 270 | 3 |
1383433 | 1383433 | 2021-06-03 | Adams | North Dakota | 38001 | 270 | 3 |
1380187 | 1380187 | 2021-06-02 | Adams | North Dakota | 38001 | 270 | 3 |
1376942 | 1376942 | 2021-06-01 | Adams | North Dakota | 38001 | 270 | 3 |
1373696 | 1373696 | 2021-05-31 | Adams | North Dakota | 38001 | 270 | 3 |
1370451 | 1370451 | 2021-05-30 | Adams | North Dakota | 38001 | 270 | 3 |
1367205 | 1367205 | 2021-05-29 | Adams | North Dakota | 38001 | 270 | 3 |
1363959 | 1363959 | 2021-05-28 | Adams | North Dakota | 38001 | 270 | 3 |
1360713 | 1360713 | 2021-05-27 | Adams | North Dakota | 38001 | 270 | 3 |
1357467 | 1357467 | 2021-05-26 | Adams | North Dakota | 38001 | 270 | 3 |
1354221 | 1354221 | 2021-05-25 | Adams | North Dakota | 38001 | 270 | 3 |
1350975 | 1350975 | 2021-05-24 | Adams | North Dakota | 38001 | 270 | 3 |
1347729 | 1347729 | 2021-05-23 | Adams | North Dakota | 38001 | 270 | 3 |
1344481 | 1344481 | 2021-05-22 | Adams | North Dakota | 38001 | 270 | 3 |
1341233 | 1341233 | 2021-05-21 | Adams | North Dakota | 38001 | 270 | 3 |
1337985 | 1337985 | 2021-05-20 | Adams | North Dakota | 38001 | 270 | 3 |
1334738 | 1334738 | 2021-05-19 | Adams | North Dakota | 38001 | 270 | 3 |
1331491 | 1331491 | 2021-05-18 | Adams | North Dakota | 38001 | 270 | 3 |
1328244 | 1328244 | 2021-05-17 | Adams | North Dakota | 38001 | 270 | 3 |
1324998 | 1324998 | 2021-05-16 | Adams | North Dakota | 38001 | 270 | 3 |
1321752 | 1321752 | 2021-05-15 | Adams | North Dakota | 38001 | 270 | 3 |
1318506 | 1318506 | 2021-05-14 | Adams | North Dakota | 38001 | 270 | 3 |
1315258 | 1315258 | 2021-05-13 | Adams | North Dakota | 38001 | 270 | 3 |
1312012 | 1312012 | 2021-05-12 | Adams | North Dakota | 38001 | 270 | 3 |
1308765 | 1308765 | 2021-05-11 | Adams | North Dakota | 38001 | 270 | 3 |
1305519 | 1305519 | 2021-05-10 | Adams | North Dakota | 38001 | 269 | 3 |
1302273 | 1302273 | 2021-05-09 | Adams | North Dakota | 38001 | 269 | 3 |
1299025 | 1299025 | 2021-05-08 | Adams | North Dakota | 38001 | 269 | 3 |
1295779 | 1295779 | 2021-05-07 | Adams | North Dakota | 38001 | 269 | 3 |
1292533 | 1292533 | 2021-05-06 | Adams | North Dakota | 38001 | 269 | 3 |
1289287 | 1289287 | 2021-05-05 | Adams | North Dakota | 38001 | 269 | 3 |
1286041 | 1286041 | 2021-05-04 | Adams | North Dakota | 38001 | 269 | 3 |
1282795 | 1282795 | 2021-05-03 | Adams | North Dakota | 38001 | 269 | 3 |
1279548 | 1279548 | 2021-05-02 | Adams | North Dakota | 38001 | 269 | 3 |
1276301 | 1276301 | 2021-05-01 | Adams | North Dakota | 38001 | 269 | 3 |
1273054 | 1273054 | 2021-04-30 | Adams | North Dakota | 38001 | 269 | 3 |
1269807 | 1269807 | 2021-04-29 | Adams | North Dakota | 38001 | 269 | 3 |
1266560 | 1266560 | 2021-04-28 | Adams | North Dakota | 38001 | 269 | 3 |
1263313 | 1263313 | 2021-04-27 | Adams | North Dakota | 38001 | 269 | 3 |
1260066 | 1260066 | 2021-04-26 | Adams | North Dakota | 38001 | 269 | 3 |
1256819 | 1256819 | 2021-04-25 | Adams | North Dakota | 38001 | 269 | 3 |
1253572 | 1253572 | 2021-04-24 | Adams | North Dakota | 38001 | 269 | 3 |
1250325 | 1250325 | 2021-04-23 | Adams | North Dakota | 38001 | 269 | 3 |
1247078 | 1247078 | 2021-04-22 | Adams | North Dakota | 38001 | 269 | 3 |
1243831 | 1243831 | 2021-04-21 | Adams | North Dakota | 38001 | 269 | 3 |
1240584 | 1240584 | 2021-04-20 | Adams | North Dakota | 38001 | 269 | 3 |
1237337 | 1237337 | 2021-04-19 | Adams | North Dakota | 38001 | 269 | 3 |
1234090 | 1234090 | 2021-04-18 | Adams | North Dakota | 38001 | 269 | 3 |
1230842 | 1230842 | 2021-04-17 | Adams | North Dakota | 38001 | 269 | 3 |
1227594 | 1227594 | 2021-04-16 | Adams | North Dakota | 38001 | 269 | 3 |
1224346 | 1224346 | 2021-04-15 | Adams | North Dakota | 38001 | 269 | 3 |
1221099 | 1221099 | 2021-04-14 | Adams | North Dakota | 38001 | 269 | 3 |
1217851 | 1217851 | 2021-04-13 | Adams | North Dakota | 38001 | 269 | 3 |
1214603 | 1214603 | 2021-04-12 | Adams | North Dakota | 38001 | 269 | 3 |
1211356 | 1211356 | 2021-04-11 | Adams | North Dakota | 38001 | 269 | 3 |
1208107 | 1208107 | 2021-04-10 | Adams | North Dakota | 38001 | 269 | 3 |
1204859 | 1204859 | 2021-04-09 | Adams | North Dakota | 38001 | 269 | 3 |
1201611 | 1201611 | 2021-04-08 | Adams | North Dakota | 38001 | 269 | 3 |
1198362 | 1198362 | 2021-04-07 | Adams | North Dakota | 38001 | 269 | 3 |
1195113 | 1195113 | 2021-04-06 | Adams | North Dakota | 38001 | 268 | 3 |
1191865 | 1191865 | 2021-04-05 | Adams | North Dakota | 38001 | 268 | 3 |
1188616 | 1188616 | 2021-04-04 | Adams | North Dakota | 38001 | 268 | 3 |
1185369 | 1185369 | 2021-04-03 | Adams | North Dakota | 38001 | 268 | 3 |
1182122 | 1182122 | 2021-04-02 | Adams | North Dakota | 38001 | 268 | 3 |
1178875 | 1178875 | 2021-04-01 | Adams | North Dakota | 38001 | 268 | 3 |
1175628 | 1175628 | 2021-03-31 | Adams | North Dakota | 38001 | 268 | 3 |
1172381 | 1172381 | 2021-03-30 | Adams | North Dakota | 38001 | 268 | 3 |
1169134 | 1169134 | 2021-03-29 | Adams | North Dakota | 38001 | 268 | 3 |
1165886 | 1165886 | 2021-03-28 | Adams | North Dakota | 38001 | 268 | 3 |
1162638 | 1162638 | 2021-03-27 | Adams | North Dakota | 38001 | 267 | 3 |
1159389 | 1159389 | 2021-03-26 | Adams | North Dakota | 38001 | 267 | 3 |
1156142 | 1156142 | 2021-03-25 | Adams | North Dakota | 38001 | 267 | 3 |
1152895 | 1152895 | 2021-03-24 | Adams | North Dakota | 38001 | 267 | 3 |
1149648 | 1149648 | 2021-03-23 | Adams | North Dakota | 38001 | 267 | 3 |
1146401 | 1146401 | 2021-03-22 | Adams | North Dakota | 38001 | 267 | 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);