ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where deaths = 10, fips = 20189 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1564207 | 1564207 | 2021-07-29 | Stevens | Kansas | 20189 | 587 | 10 |
1560959 | 1560959 | 2021-07-28 | Stevens | Kansas | 20189 | 587 | 10 |
1557712 | 1557712 | 2021-07-27 | Stevens | Kansas | 20189 | 587 | 10 |
1554465 | 1554465 | 2021-07-26 | Stevens | Kansas | 20189 | 587 | 10 |
1551218 | 1551218 | 2021-07-25 | Stevens | Kansas | 20189 | 587 | 10 |
1547971 | 1547971 | 2021-07-24 | Stevens | Kansas | 20189 | 587 | 10 |
1544724 | 1544724 | 2021-07-23 | Stevens | Kansas | 20189 | 587 | 10 |
1541476 | 1541476 | 2021-07-22 | Stevens | Kansas | 20189 | 587 | 10 |
1538229 | 1538229 | 2021-07-21 | Stevens | Kansas | 20189 | 587 | 10 |
1534981 | 1534981 | 2021-07-20 | Stevens | Kansas | 20189 | 587 | 10 |
1531734 | 1531734 | 2021-07-19 | Stevens | Kansas | 20189 | 587 | 10 |
1528487 | 1528487 | 2021-07-18 | Stevens | Kansas | 20189 | 587 | 10 |
1525240 | 1525240 | 2021-07-17 | Stevens | Kansas | 20189 | 587 | 10 |
1521992 | 1521992 | 2021-07-16 | Stevens | Kansas | 20189 | 587 | 10 |
1518744 | 1518744 | 2021-07-15 | Stevens | Kansas | 20189 | 587 | 10 |
1515497 | 1515497 | 2021-07-14 | Stevens | Kansas | 20189 | 586 | 10 |
1512251 | 1512251 | 2021-07-13 | Stevens | Kansas | 20189 | 586 | 10 |
1509004 | 1509004 | 2021-07-12 | Stevens | Kansas | 20189 | 586 | 10 |
1505758 | 1505758 | 2021-07-11 | Stevens | Kansas | 20189 | 586 | 10 |
1502512 | 1502512 | 2021-07-10 | Stevens | Kansas | 20189 | 586 | 10 |
1499266 | 1499266 | 2021-07-09 | Stevens | Kansas | 20189 | 586 | 10 |
1496019 | 1496019 | 2021-07-08 | Stevens | Kansas | 20189 | 586 | 10 |
1492773 | 1492773 | 2021-07-07 | Stevens | Kansas | 20189 | 586 | 10 |
1489526 | 1489526 | 2021-07-06 | Stevens | Kansas | 20189 | 586 | 10 |
1486279 | 1486279 | 2021-07-05 | Stevens | Kansas | 20189 | 586 | 10 |
1483033 | 1483033 | 2021-07-04 | Stevens | Kansas | 20189 | 586 | 10 |
1479786 | 1479786 | 2021-07-03 | Stevens | Kansas | 20189 | 586 | 10 |
1476540 | 1476540 | 2021-07-02 | Stevens | Kansas | 20189 | 586 | 10 |
1473294 | 1473294 | 2021-07-01 | Stevens | Kansas | 20189 | 586 | 10 |
1470048 | 1470048 | 2021-06-30 | Stevens | Kansas | 20189 | 586 | 10 |
1466803 | 1466803 | 2021-06-29 | Stevens | Kansas | 20189 | 586 | 10 |
1463558 | 1463558 | 2021-06-28 | Stevens | Kansas | 20189 | 586 | 10 |
1460313 | 1460313 | 2021-06-27 | Stevens | Kansas | 20189 | 586 | 10 |
1457068 | 1457068 | 2021-06-26 | Stevens | Kansas | 20189 | 586 | 10 |
1453823 | 1453823 | 2021-06-25 | Stevens | Kansas | 20189 | 586 | 10 |
1450577 | 1450577 | 2021-06-24 | Stevens | Kansas | 20189 | 586 | 10 |
1447332 | 1447332 | 2021-06-23 | Stevens | Kansas | 20189 | 586 | 10 |
1444087 | 1444087 | 2021-06-22 | Stevens | Kansas | 20189 | 586 | 10 |
1440842 | 1440842 | 2021-06-21 | Stevens | Kansas | 20189 | 586 | 10 |
1437595 | 1437595 | 2021-06-20 | Stevens | Kansas | 20189 | 586 | 10 |
1434348 | 1434348 | 2021-06-19 | Stevens | Kansas | 20189 | 586 | 10 |
1431102 | 1431102 | 2021-06-18 | Stevens | Kansas | 20189 | 586 | 10 |
1427857 | 1427857 | 2021-06-17 | Stevens | Kansas | 20189 | 586 | 10 |
1424612 | 1424612 | 2021-06-16 | Stevens | Kansas | 20189 | 586 | 10 |
1421364 | 1421364 | 2021-06-15 | Stevens | Kansas | 20189 | 586 | 10 |
1418119 | 1418119 | 2021-06-14 | Stevens | Kansas | 20189 | 586 | 10 |
1414873 | 1414873 | 2021-06-13 | Stevens | Kansas | 20189 | 586 | 10 |
1411628 | 1411628 | 2021-06-12 | Stevens | Kansas | 20189 | 586 | 10 |
1408383 | 1408383 | 2021-06-11 | Stevens | Kansas | 20189 | 586 | 10 |
1405137 | 1405137 | 2021-06-10 | Stevens | Kansas | 20189 | 586 | 10 |
1401892 | 1401892 | 2021-06-09 | Stevens | Kansas | 20189 | 586 | 10 |
1398647 | 1398647 | 2021-06-08 | Stevens | Kansas | 20189 | 586 | 10 |
1395400 | 1395400 | 2021-06-07 | Stevens | Kansas | 20189 | 586 | 10 |
1392155 | 1392155 | 2021-06-06 | Stevens | Kansas | 20189 | 586 | 10 |
1388910 | 1388910 | 2021-06-05 | Stevens | Kansas | 20189 | 586 | 10 |
1385665 | 1385665 | 2021-06-04 | Stevens | Kansas | 20189 | 586 | 10 |
1382419 | 1382419 | 2021-06-03 | Stevens | Kansas | 20189 | 586 | 10 |
1379174 | 1379174 | 2021-06-02 | Stevens | Kansas | 20189 | 586 | 10 |
1375928 | 1375928 | 2021-06-01 | Stevens | Kansas | 20189 | 586 | 10 |
1372683 | 1372683 | 2021-05-31 | Stevens | Kansas | 20189 | 586 | 10 |
1369438 | 1369438 | 2021-05-30 | Stevens | Kansas | 20189 | 586 | 10 |
1366192 | 1366192 | 2021-05-29 | Stevens | Kansas | 20189 | 586 | 10 |
1362946 | 1362946 | 2021-05-28 | Stevens | Kansas | 20189 | 586 | 10 |
1359699 | 1359699 | 2021-05-27 | Stevens | Kansas | 20189 | 586 | 10 |
1356453 | 1356453 | 2021-05-26 | Stevens | Kansas | 20189 | 586 | 10 |
1353207 | 1353207 | 2021-05-25 | Stevens | Kansas | 20189 | 586 | 10 |
1349961 | 1349961 | 2021-05-24 | Stevens | Kansas | 20189 | 586 | 10 |
1346714 | 1346714 | 2021-05-23 | Stevens | Kansas | 20189 | 586 | 10 |
1343466 | 1343466 | 2021-05-22 | Stevens | Kansas | 20189 | 586 | 10 |
1340218 | 1340218 | 2021-05-21 | Stevens | Kansas | 20189 | 586 | 10 |
1336971 | 1336971 | 2021-05-20 | Stevens | Kansas | 20189 | 586 | 10 |
1333724 | 1333724 | 2021-05-19 | Stevens | Kansas | 20189 | 586 | 10 |
1330477 | 1330477 | 2021-05-18 | Stevens | Kansas | 20189 | 586 | 10 |
1327230 | 1327230 | 2021-05-17 | Stevens | Kansas | 20189 | 586 | 10 |
1323984 | 1323984 | 2021-05-16 | Stevens | Kansas | 20189 | 586 | 10 |
1320738 | 1320738 | 2021-05-15 | Stevens | Kansas | 20189 | 586 | 10 |
1317491 | 1317491 | 2021-05-14 | Stevens | Kansas | 20189 | 586 | 10 |
1314244 | 1314244 | 2021-05-13 | Stevens | Kansas | 20189 | 586 | 10 |
1310997 | 1310997 | 2021-05-12 | Stevens | Kansas | 20189 | 586 | 10 |
1307751 | 1307751 | 2021-05-11 | Stevens | Kansas | 20189 | 586 | 10 |
1304505 | 1304505 | 2021-05-10 | Stevens | Kansas | 20189 | 586 | 10 |
1301258 | 1301258 | 2021-05-09 | Stevens | Kansas | 20189 | 586 | 10 |
1298011 | 1298011 | 2021-05-08 | Stevens | Kansas | 20189 | 586 | 10 |
1294765 | 1294765 | 2021-05-07 | Stevens | Kansas | 20189 | 586 | 10 |
1291519 | 1291519 | 2021-05-06 | Stevens | Kansas | 20189 | 586 | 10 |
1288273 | 1288273 | 2021-05-05 | Stevens | Kansas | 20189 | 586 | 10 |
1285027 | 1285027 | 2021-05-04 | Stevens | Kansas | 20189 | 586 | 10 |
1281780 | 1281780 | 2021-05-03 | Stevens | Kansas | 20189 | 586 | 10 |
1278533 | 1278533 | 2021-05-02 | Stevens | Kansas | 20189 | 586 | 10 |
1275286 | 1275286 | 2021-05-01 | Stevens | Kansas | 20189 | 586 | 10 |
1272039 | 1272039 | 2021-04-30 | Stevens | Kansas | 20189 | 586 | 10 |
1268792 | 1268792 | 2021-04-29 | Stevens | Kansas | 20189 | 586 | 10 |
1265545 | 1265545 | 2021-04-28 | Stevens | Kansas | 20189 | 586 | 10 |
1262298 | 1262298 | 2021-04-27 | Stevens | Kansas | 20189 | 586 | 10 |
1259051 | 1259051 | 2021-04-26 | Stevens | Kansas | 20189 | 586 | 10 |
1255804 | 1255804 | 2021-04-25 | Stevens | Kansas | 20189 | 586 | 10 |
1252557 | 1252557 | 2021-04-24 | Stevens | Kansas | 20189 | 586 | 10 |
1249310 | 1249310 | 2021-04-23 | Stevens | Kansas | 20189 | 586 | 10 |
1246063 | 1246063 | 2021-04-22 | Stevens | Kansas | 20189 | 586 | 10 |
1242816 | 1242816 | 2021-04-21 | Stevens | Kansas | 20189 | 586 | 10 |
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);