ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where county = "Knox", deaths = 17 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1559483 | 1559483 | 2021-07-27 | Knox | Texas | 48275 | 265 | 17 |
1556236 | 1556236 | 2021-07-26 | Knox | Texas | 48275 | 265 | 17 |
1552989 | 1552989 | 2021-07-25 | Knox | Texas | 48275 | 265 | 17 |
1549742 | 1549742 | 2021-07-24 | Knox | Texas | 48275 | 265 | 17 |
1546495 | 1546495 | 2021-07-23 | Knox | Texas | 48275 | 265 | 17 |
1543248 | 1543248 | 2021-07-22 | Knox | Texas | 48275 | 265 | 17 |
1540000 | 1540000 | 2021-07-21 | Knox | Texas | 48275 | 265 | 17 |
1536753 | 1536753 | 2021-07-20 | Knox | Texas | 48275 | 265 | 17 |
1533505 | 1533505 | 2021-07-19 | Knox | Texas | 48275 | 265 | 17 |
1530258 | 1530258 | 2021-07-18 | Knox | Texas | 48275 | 265 | 17 |
1527011 | 1527011 | 2021-07-17 | Knox | Texas | 48275 | 265 | 17 |
1523764 | 1523764 | 2021-07-16 | Knox | Texas | 48275 | 264 | 17 |
1520516 | 1520516 | 2021-07-15 | Knox | Texas | 48275 | 263 | 17 |
1517268 | 1517268 | 2021-07-14 | Knox | Texas | 48275 | 263 | 17 |
1514021 | 1514021 | 2021-07-13 | Knox | Texas | 48275 | 264 | 17 |
1510775 | 1510775 | 2021-07-12 | Knox | Texas | 48275 | 264 | 17 |
1507528 | 1507528 | 2021-07-11 | Knox | Texas | 48275 | 264 | 17 |
1504282 | 1504282 | 2021-07-10 | Knox | Texas | 48275 | 264 | 17 |
1501036 | 1501036 | 2021-07-09 | Knox | Texas | 48275 | 264 | 17 |
1497790 | 1497790 | 2021-07-08 | Knox | Texas | 48275 | 264 | 17 |
1494543 | 1494543 | 2021-07-07 | Knox | Texas | 48275 | 264 | 17 |
1491296 | 1491296 | 2021-07-06 | Knox | Texas | 48275 | 263 | 17 |
1488049 | 1488049 | 2021-07-05 | Knox | Texas | 48275 | 263 | 17 |
1484802 | 1484802 | 2021-07-04 | Knox | Texas | 48275 | 263 | 17 |
1481556 | 1481556 | 2021-07-03 | Knox | Texas | 48275 | 263 | 17 |
1478309 | 1478309 | 2021-07-02 | Knox | Texas | 48275 | 263 | 17 |
1475063 | 1475063 | 2021-07-01 | Knox | Texas | 48275 | 263 | 17 |
1471817 | 1471817 | 2021-06-30 | Knox | Texas | 48275 | 263 | 17 |
1468572 | 1468572 | 2021-06-29 | Knox | Texas | 48275 | 262 | 17 |
1465327 | 1465327 | 2021-06-28 | Knox | Texas | 48275 | 262 | 17 |
1462082 | 1462082 | 2021-06-27 | Knox | Texas | 48275 | 262 | 17 |
1458837 | 1458837 | 2021-06-26 | Knox | Texas | 48275 | 262 | 17 |
1455592 | 1455592 | 2021-06-25 | Knox | Texas | 48275 | 262 | 17 |
1452347 | 1452347 | 2021-06-24 | Knox | Texas | 48275 | 262 | 17 |
1449101 | 1449101 | 2021-06-23 | Knox | Texas | 48275 | 262 | 17 |
1445856 | 1445856 | 2021-06-22 | Knox | Texas | 48275 | 263 | 17 |
1442611 | 1442611 | 2021-06-21 | Knox | Texas | 48275 | 263 | 17 |
1439366 | 1439366 | 2021-06-20 | Knox | Texas | 48275 | 263 | 17 |
1436119 | 1436119 | 2021-06-19 | Knox | Texas | 48275 | 263 | 17 |
1432872 | 1432872 | 2021-06-18 | Knox | Texas | 48275 | 263 | 17 |
1429626 | 1429626 | 2021-06-17 | Knox | Texas | 48275 | 263 | 17 |
1426381 | 1426381 | 2021-06-16 | Knox | Texas | 48275 | 263 | 17 |
1423134 | 1423134 | 2021-06-15 | Knox | Texas | 48275 | 263 | 17 |
1419888 | 1419888 | 2021-06-14 | Knox | Texas | 48275 | 263 | 17 |
1416643 | 1416643 | 2021-06-13 | Knox | Texas | 48275 | 263 | 17 |
1413397 | 1413397 | 2021-06-12 | Knox | Texas | 48275 | 263 | 17 |
1410152 | 1410152 | 2021-06-11 | Knox | Texas | 48275 | 263 | 17 |
1406907 | 1406907 | 2021-06-10 | Knox | Texas | 48275 | 263 | 17 |
1403661 | 1403661 | 2021-06-09 | Knox | Texas | 48275 | 263 | 17 |
1400416 | 1400416 | 2021-06-08 | Knox | Texas | 48275 | 263 | 17 |
1397171 | 1397171 | 2021-06-07 | Knox | Texas | 48275 | 263 | 17 |
1393924 | 1393924 | 2021-06-06 | Knox | Texas | 48275 | 263 | 17 |
1390679 | 1390679 | 2021-06-05 | Knox | Texas | 48275 | 263 | 17 |
1387434 | 1387434 | 2021-06-04 | Knox | Texas | 48275 | 263 | 17 |
1384189 | 1384189 | 2021-06-03 | Knox | Texas | 48275 | 263 | 17 |
1380943 | 1380943 | 2021-06-02 | Knox | Texas | 48275 | 263 | 17 |
1377698 | 1377698 | 2021-06-01 | Knox | Texas | 48275 | 263 | 17 |
1374452 | 1374452 | 2021-05-31 | Knox | Texas | 48275 | 263 | 17 |
1371207 | 1371207 | 2021-05-30 | Knox | Texas | 48275 | 263 | 17 |
1367961 | 1367961 | 2021-05-29 | Knox | Texas | 48275 | 263 | 17 |
1364715 | 1364715 | 2021-05-28 | Knox | Texas | 48275 | 263 | 17 |
1361469 | 1361469 | 2021-05-27 | Knox | Texas | 48275 | 263 | 17 |
1358223 | 1358223 | 2021-05-26 | Knox | Texas | 48275 | 263 | 17 |
1354977 | 1354977 | 2021-05-25 | Knox | Texas | 48275 | 263 | 17 |
1351731 | 1351731 | 2021-05-24 | Knox | Texas | 48275 | 261 | 17 |
1348485 | 1348485 | 2021-05-23 | Knox | Texas | 48275 | 261 | 17 |
1345237 | 1345237 | 2021-05-22 | Knox | Texas | 48275 | 261 | 17 |
1341989 | 1341989 | 2021-05-21 | Knox | Texas | 48275 | 261 | 17 |
1338741 | 1338741 | 2021-05-20 | Knox | Texas | 48275 | 261 | 17 |
1335494 | 1335494 | 2021-05-19 | Knox | Texas | 48275 | 261 | 17 |
1332247 | 1332247 | 2021-05-18 | Knox | Texas | 48275 | 261 | 17 |
1329000 | 1329000 | 2021-05-17 | Knox | Texas | 48275 | 258 | 17 |
1325754 | 1325754 | 2021-05-16 | Knox | Texas | 48275 | 258 | 17 |
1322508 | 1322508 | 2021-05-15 | Knox | Texas | 48275 | 258 | 17 |
1319262 | 1319262 | 2021-05-14 | Knox | Texas | 48275 | 258 | 17 |
1316014 | 1316014 | 2021-05-13 | Knox | Texas | 48275 | 258 | 17 |
1312768 | 1312768 | 2021-05-12 | Knox | Texas | 48275 | 258 | 17 |
1309521 | 1309521 | 2021-05-11 | Knox | Texas | 48275 | 258 | 17 |
1306275 | 1306275 | 2021-05-10 | Knox | Texas | 48275 | 258 | 17 |
1303029 | 1303029 | 2021-05-09 | Knox | Texas | 48275 | 258 | 17 |
1299782 | 1299782 | 2021-05-08 | Knox | Texas | 48275 | 258 | 17 |
1296535 | 1296535 | 2021-05-07 | Knox | Texas | 48275 | 258 | 17 |
1293289 | 1293289 | 2021-05-06 | Knox | Texas | 48275 | 258 | 17 |
1290043 | 1290043 | 2021-05-05 | Knox | Texas | 48275 | 258 | 17 |
1286797 | 1286797 | 2021-05-04 | Knox | Texas | 48275 | 258 | 17 |
1283551 | 1283551 | 2021-05-03 | Knox | Texas | 48275 | 258 | 17 |
1280304 | 1280304 | 2021-05-02 | Knox | Texas | 48275 | 258 | 17 |
1277057 | 1277057 | 2021-05-01 | Knox | Texas | 48275 | 258 | 17 |
1273810 | 1273810 | 2021-04-30 | Knox | Texas | 48275 | 258 | 17 |
1270563 | 1270563 | 2021-04-29 | Knox | Texas | 48275 | 258 | 17 |
1267316 | 1267316 | 2021-04-28 | Knox | Texas | 48275 | 258 | 17 |
1264069 | 1264069 | 2021-04-27 | Knox | Texas | 48275 | 257 | 17 |
1260822 | 1260822 | 2021-04-26 | Knox | Texas | 48275 | 257 | 17 |
1257575 | 1257575 | 2021-04-25 | Knox | Texas | 48275 | 257 | 17 |
1254328 | 1254328 | 2021-04-24 | Knox | Texas | 48275 | 257 | 17 |
1251081 | 1251081 | 2021-04-23 | Knox | Texas | 48275 | 257 | 17 |
1247834 | 1247834 | 2021-04-22 | Knox | Texas | 48275 | 257 | 17 |
1244587 | 1244587 | 2021-04-21 | Knox | Texas | 48275 | 257 | 17 |
1241340 | 1241340 | 2021-04-20 | Knox | Texas | 48275 | 257 | 17 |
1238093 | 1238093 | 2021-04-19 | Knox | Texas | 48275 | 287 | 17 |
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);