ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where fips = 21007 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418133 | 1418133 | 2021-06-14 | Ballard | Kentucky | 21007 | 416 | 9 |
1414887 | 1414887 | 2021-06-13 | Ballard | Kentucky | 21007 | 416 | 9 |
1411642 | 1411642 | 2021-06-12 | Ballard | Kentucky | 21007 | 416 | 9 |
1408397 | 1408397 | 2021-06-11 | Ballard | Kentucky | 21007 | 416 | 9 |
1405151 | 1405151 | 2021-06-10 | Ballard | Kentucky | 21007 | 416 | 9 |
1401906 | 1401906 | 2021-06-09 | Ballard | Kentucky | 21007 | 416 | 9 |
1398661 | 1398661 | 2021-06-08 | Ballard | Kentucky | 21007 | 416 | 9 |
1395414 | 1395414 | 2021-06-07 | Ballard | Kentucky | 21007 | 415 | 9 |
1392169 | 1392169 | 2021-06-06 | Ballard | Kentucky | 21007 | 412 | 9 |
1388924 | 1388924 | 2021-06-05 | Ballard | Kentucky | 21007 | 412 | 9 |
1385679 | 1385679 | 2021-06-04 | Ballard | Kentucky | 21007 | 411 | 9 |
1382433 | 1382433 | 2021-06-03 | Ballard | Kentucky | 21007 | 410 | 9 |
1379188 | 1379188 | 2021-06-02 | Ballard | Kentucky | 21007 | 410 | 9 |
1375942 | 1375942 | 2021-06-01 | Ballard | Kentucky | 21007 | 409 | 9 |
1372697 | 1372697 | 2021-05-31 | Ballard | Kentucky | 21007 | 409 | 9 |
1369452 | 1369452 | 2021-05-30 | Ballard | Kentucky | 21007 | 409 | 9 |
1366206 | 1366206 | 2021-05-29 | Ballard | Kentucky | 21007 | 409 | 9 |
1362960 | 1362960 | 2021-05-28 | Ballard | Kentucky | 21007 | 408 | 9 |
1359713 | 1359713 | 2021-05-27 | Ballard | Kentucky | 21007 | 407 | 9 |
1356467 | 1356467 | 2021-05-26 | Ballard | Kentucky | 21007 | 407 | 9 |
1353221 | 1353221 | 2021-05-25 | Ballard | Kentucky | 21007 | 407 | 9 |
1349975 | 1349975 | 2021-05-24 | Ballard | Kentucky | 21007 | 407 | 9 |
1346728 | 1346728 | 2021-05-23 | Ballard | Kentucky | 21007 | 407 | 9 |
1343480 | 1343480 | 2021-05-22 | Ballard | Kentucky | 21007 | 407 | 9 |
1340232 | 1340232 | 2021-05-21 | Ballard | Kentucky | 21007 | 407 | 9 |
1336985 | 1336985 | 2021-05-20 | Ballard | Kentucky | 21007 | 406 | 9 |
1333738 | 1333738 | 2021-05-19 | Ballard | Kentucky | 21007 | 404 | 9 |
1330491 | 1330491 | 2021-05-18 | Ballard | Kentucky | 21007 | 404 | 9 |
1327244 | 1327244 | 2021-05-17 | Ballard | Kentucky | 21007 | 403 | 9 |
1323998 | 1323998 | 2021-05-16 | Ballard | Kentucky | 21007 | 403 | 9 |
1320752 | 1320752 | 2021-05-15 | Ballard | Kentucky | 21007 | 402 | 9 |
1317505 | 1317505 | 2021-05-14 | Ballard | Kentucky | 21007 | 400 | 9 |
1314258 | 1314258 | 2021-05-13 | Ballard | Kentucky | 21007 | 399 | 9 |
1311011 | 1311011 | 2021-05-12 | Ballard | Kentucky | 21007 | 396 | 9 |
1307765 | 1307765 | 2021-05-11 | Ballard | Kentucky | 21007 | 396 | 9 |
1304519 | 1304519 | 2021-05-10 | Ballard | Kentucky | 21007 | 396 | 9 |
1301272 | 1301272 | 2021-05-09 | Ballard | Kentucky | 21007 | 396 | 8 |
1298025 | 1298025 | 2021-05-08 | Ballard | Kentucky | 21007 | 395 | 8 |
1294779 | 1294779 | 2021-05-07 | Ballard | Kentucky | 21007 | 396 | 8 |
1291533 | 1291533 | 2021-05-06 | Ballard | Kentucky | 21007 | 396 | 8 |
1288287 | 1288287 | 2021-05-05 | Ballard | Kentucky | 21007 | 395 | 8 |
1285041 | 1285041 | 2021-05-04 | Ballard | Kentucky | 21007 | 395 | 8 |
1281794 | 1281794 | 2021-05-03 | Ballard | Kentucky | 21007 | 395 | 8 |
1278547 | 1278547 | 2021-05-02 | Ballard | Kentucky | 21007 | 394 | 8 |
1275300 | 1275300 | 2021-05-01 | Ballard | Kentucky | 21007 | 394 | 8 |
1272053 | 1272053 | 2021-04-30 | Ballard | Kentucky | 21007 | 394 | 8 |
1268806 | 1268806 | 2021-04-29 | Ballard | Kentucky | 21007 | 393 | 8 |
1265559 | 1265559 | 2021-04-28 | Ballard | Kentucky | 21007 | 392 | 8 |
1262312 | 1262312 | 2021-04-27 | Ballard | Kentucky | 21007 | 392 | 8 |
1259065 | 1259065 | 2021-04-26 | Ballard | Kentucky | 21007 | 392 | 8 |
1255818 | 1255818 | 2021-04-25 | Ballard | Kentucky | 21007 | 392 | 8 |
1252571 | 1252571 | 2021-04-24 | Ballard | Kentucky | 21007 | 392 | 8 |
1249324 | 1249324 | 2021-04-23 | Ballard | Kentucky | 21007 | 391 | 8 |
1246077 | 1246077 | 2021-04-22 | Ballard | Kentucky | 21007 | 390 | 8 |
1242830 | 1242830 | 2021-04-21 | Ballard | Kentucky | 21007 | 389 | 8 |
1239583 | 1239583 | 2021-04-20 | Ballard | Kentucky | 21007 | 387 | 8 |
1236336 | 1236336 | 2021-04-19 | Ballard | Kentucky | 21007 | 387 | 8 |
1233089 | 1233089 | 2021-04-18 | Ballard | Kentucky | 21007 | 387 | 8 |
1229841 | 1229841 | 2021-04-17 | Ballard | Kentucky | 21007 | 387 | 8 |
1226593 | 1226593 | 2021-04-16 | Ballard | Kentucky | 21007 | 386 | 8 |
1223346 | 1223346 | 2021-04-15 | Ballard | Kentucky | 21007 | 385 | 8 |
1220098 | 1220098 | 2021-04-14 | Ballard | Kentucky | 21007 | 385 | 8 |
1216850 | 1216850 | 2021-04-13 | Ballard | Kentucky | 21007 | 385 | 8 |
1213603 | 1213603 | 2021-04-12 | Ballard | Kentucky | 21007 | 385 | 8 |
1210355 | 1210355 | 2021-04-11 | Ballard | Kentucky | 21007 | 385 | 8 |
1207106 | 1207106 | 2021-04-10 | Ballard | Kentucky | 21007 | 385 | 8 |
1203858 | 1203858 | 2021-04-09 | Ballard | Kentucky | 21007 | 384 | 8 |
1200610 | 1200610 | 2021-04-08 | Ballard | Kentucky | 21007 | 384 | 8 |
1197361 | 1197361 | 2021-04-07 | Ballard | Kentucky | 21007 | 384 | 8 |
1194113 | 1194113 | 2021-04-06 | Ballard | Kentucky | 21007 | 384 | 8 |
1190863 | 1190863 | 2021-04-05 | Ballard | Kentucky | 21007 | 384 | 8 |
1187616 | 1187616 | 2021-04-04 | Ballard | Kentucky | 21007 | 383 | 8 |
1184369 | 1184369 | 2021-04-03 | Ballard | Kentucky | 21007 | 383 | 8 |
1181122 | 1181122 | 2021-04-02 | Ballard | Kentucky | 21007 | 382 | 8 |
1177875 | 1177875 | 2021-04-01 | Ballard | Kentucky | 21007 | 377 | 8 |
1174628 | 1174628 | 2021-03-31 | Ballard | Kentucky | 21007 | 376 | 8 |
1171381 | 1171381 | 2021-03-30 | Ballard | Kentucky | 21007 | 374 | 8 |
1168133 | 1168133 | 2021-03-29 | Ballard | Kentucky | 21007 | 374 | 8 |
1164885 | 1164885 | 2021-03-28 | Ballard | Kentucky | 21007 | 374 | 8 |
1161637 | 1161637 | 2021-03-27 | Ballard | Kentucky | 21007 | 374 | 8 |
1158389 | 1158389 | 2021-03-26 | Ballard | Kentucky | 21007 | 373 | 8 |
1155142 | 1155142 | 2021-03-25 | Ballard | Kentucky | 21007 | 371 | 8 |
1151895 | 1151895 | 2021-03-24 | Ballard | Kentucky | 21007 | 371 | 8 |
1148648 | 1148648 | 2021-03-23 | Ballard | Kentucky | 21007 | 371 | 8 |
1145401 | 1145401 | 2021-03-22 | Ballard | Kentucky | 21007 | 370 | 8 |
1142154 | 1142154 | 2021-03-21 | Ballard | Kentucky | 21007 | 370 | 8 |
1138908 | 1138908 | 2021-03-20 | Ballard | Kentucky | 21007 | 370 | 8 |
1135662 | 1135662 | 2021-03-19 | Ballard | Kentucky | 21007 | 370 | 8 |
1132415 | 1132415 | 2021-03-18 | Ballard | Kentucky | 21007 | 370 | 7 |
1129167 | 1129167 | 2021-03-17 | Ballard | Kentucky | 21007 | 368 | 7 |
1125921 | 1125921 | 2021-03-16 | Ballard | Kentucky | 21007 | 367 | 7 |
1122675 | 1122675 | 2021-03-15 | Ballard | Kentucky | 21007 | 366 | 6 |
1119428 | 1119428 | 2021-03-14 | Ballard | Kentucky | 21007 | 366 | 6 |
1116181 | 1116181 | 2021-03-13 | Ballard | Kentucky | 21007 | 366 | 6 |
1112935 | 1112935 | 2021-03-12 | Ballard | Kentucky | 21007 | 361 | 6 |
1109689 | 1109689 | 2021-03-11 | Ballard | Kentucky | 21007 | 356 | 6 |
1106443 | 1106443 | 2021-03-10 | Ballard | Kentucky | 21007 | 356 | 5 |
1103197 | 1103197 | 2021-03-09 | Ballard | Kentucky | 21007 | 356 | 5 |
1099951 | 1099951 | 2021-03-08 | Ballard | Kentucky | 21007 | 352 | 5 |
1096703 | 1096703 | 2021-03-07 | Ballard | Kentucky | 21007 | 352 | 5 |
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);