ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Llano" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419900 | 1419900 | 2021-06-14 | Llano | Texas | 48299 | 1691 | 52 |
1416655 | 1416655 | 2021-06-13 | Llano | Texas | 48299 | 1690 | 52 |
1413409 | 1413409 | 2021-06-12 | Llano | Texas | 48299 | 1690 | 52 |
1410164 | 1410164 | 2021-06-11 | Llano | Texas | 48299 | 1689 | 52 |
1406919 | 1406919 | 2021-06-10 | Llano | Texas | 48299 | 1687 | 52 |
1403673 | 1403673 | 2021-06-09 | Llano | Texas | 48299 | 1684 | 52 |
1400428 | 1400428 | 2021-06-08 | Llano | Texas | 48299 | 1684 | 52 |
1397183 | 1397183 | 2021-06-07 | Llano | Texas | 48299 | 1683 | 52 |
1393936 | 1393936 | 2021-06-06 | Llano | Texas | 48299 | 1683 | 52 |
1390691 | 1390691 | 2021-06-05 | Llano | Texas | 48299 | 1683 | 52 |
1387446 | 1387446 | 2021-06-04 | Llano | Texas | 48299 | 1682 | 52 |
1384201 | 1384201 | 2021-06-03 | Llano | Texas | 48299 | 1690 | 52 |
1380955 | 1380955 | 2021-06-02 | Llano | Texas | 48299 | 1691 | 52 |
1377710 | 1377710 | 2021-06-01 | Llano | Texas | 48299 | 1688 | 51 |
1374464 | 1374464 | 2021-05-31 | Llano | Texas | 48299 | 1688 | 51 |
1371219 | 1371219 | 2021-05-30 | Llano | Texas | 48299 | 1688 | 51 |
1367973 | 1367973 | 2021-05-29 | Llano | Texas | 48299 | 1688 | 51 |
1364727 | 1364727 | 2021-05-28 | Llano | Texas | 48299 | 1688 | 51 |
1361481 | 1361481 | 2021-05-27 | Llano | Texas | 48299 | 1688 | 51 |
1358235 | 1358235 | 2021-05-26 | Llano | Texas | 48299 | 1688 | 51 |
1354989 | 1354989 | 2021-05-25 | Llano | Texas | 48299 | 1688 | 51 |
1351743 | 1351743 | 2021-05-24 | Llano | Texas | 48299 | 1688 | 51 |
1348497 | 1348497 | 2021-05-23 | Llano | Texas | 48299 | 1687 | 51 |
1345249 | 1345249 | 2021-05-22 | Llano | Texas | 48299 | 1687 | 51 |
1342001 | 1342001 | 2021-05-21 | Llano | Texas | 48299 | 1687 | 51 |
1338753 | 1338753 | 2021-05-20 | Llano | Texas | 48299 | 1686 | 51 |
1335506 | 1335506 | 2021-05-19 | Llano | Texas | 48299 | 1678 | 51 |
1332259 | 1332259 | 2021-05-18 | Llano | Texas | 48299 | 1678 | 51 |
1329012 | 1329012 | 2021-05-17 | Llano | Texas | 48299 | 1675 | 51 |
1325766 | 1325766 | 2021-05-16 | Llano | Texas | 48299 | 1672 | 51 |
1322520 | 1322520 | 2021-05-15 | Llano | Texas | 48299 | 1672 | 51 |
1319274 | 1319274 | 2021-05-14 | Llano | Texas | 48299 | 1671 | 51 |
1316026 | 1316026 | 2021-05-13 | Llano | Texas | 48299 | 1671 | 51 |
1312780 | 1312780 | 2021-05-12 | Llano | Texas | 48299 | 1666 | 51 |
1309533 | 1309533 | 2021-05-11 | Llano | Texas | 48299 | 1666 | 51 |
1306287 | 1306287 | 2021-05-10 | Llano | Texas | 48299 | 1666 | 51 |
1303041 | 1303041 | 2021-05-09 | Llano | Texas | 48299 | 1659 | 51 |
1299794 | 1299794 | 2021-05-08 | Llano | Texas | 48299 | 1659 | 51 |
1296547 | 1296547 | 2021-05-07 | Llano | Texas | 48299 | 1657 | 51 |
1293301 | 1293301 | 2021-05-06 | Llano | Texas | 48299 | 1656 | 51 |
1290055 | 1290055 | 2021-05-05 | Llano | Texas | 48299 | 1656 | 51 |
1286809 | 1286809 | 2021-05-04 | Llano | Texas | 48299 | 1654 | 51 |
1283563 | 1283563 | 2021-05-03 | Llano | Texas | 48299 | 1654 | 51 |
1280316 | 1280316 | 2021-05-02 | Llano | Texas | 48299 | 1650 | 51 |
1277069 | 1277069 | 2021-05-01 | Llano | Texas | 48299 | 1650 | 51 |
1273822 | 1273822 | 2021-04-30 | Llano | Texas | 48299 | 1648 | 51 |
1270575 | 1270575 | 2021-04-29 | Llano | Texas | 48299 | 1645 | 51 |
1267328 | 1267328 | 2021-04-28 | Llano | Texas | 48299 | 1645 | 51 |
1264081 | 1264081 | 2021-04-27 | Llano | Texas | 48299 | 1645 | 51 |
1260834 | 1260834 | 2021-04-26 | Llano | Texas | 48299 | 1644 | 51 |
1257587 | 1257587 | 2021-04-25 | Llano | Texas | 48299 | 1642 | 51 |
1254340 | 1254340 | 2021-04-24 | Llano | Texas | 48299 | 1642 | 51 |
1251093 | 1251093 | 2021-04-23 | Llano | Texas | 48299 | 1641 | 51 |
1247846 | 1247846 | 2021-04-22 | Llano | Texas | 48299 | 1637 | 51 |
1244599 | 1244599 | 2021-04-21 | Llano | Texas | 48299 | 1635 | 51 |
1241352 | 1241352 | 2021-04-20 | Llano | Texas | 48299 | 1634 | 51 |
1238105 | 1238105 | 2021-04-19 | Llano | Texas | 48299 | 1631 | 51 |
1234858 | 1234858 | 2021-04-18 | Llano | Texas | 48299 | 1630 | 51 |
1231610 | 1231610 | 2021-04-17 | Llano | Texas | 48299 | 1630 | 51 |
1228362 | 1228362 | 2021-04-16 | Llano | Texas | 48299 | 1630 | 51 |
1225114 | 1225114 | 2021-04-15 | Llano | Texas | 48299 | 1630 | 51 |
1221867 | 1221867 | 2021-04-14 | Llano | Texas | 48299 | 1629 | 51 |
1218619 | 1218619 | 2021-04-13 | Llano | Texas | 48299 | 1625 | 50 |
1215371 | 1215371 | 2021-04-12 | Llano | Texas | 48299 | 1622 | 50 |
1212124 | 1212124 | 2021-04-11 | Llano | Texas | 48299 | 1616 | 50 |
1208875 | 1208875 | 2021-04-10 | Llano | Texas | 48299 | 1616 | 50 |
1205627 | 1205627 | 2021-04-09 | Llano | Texas | 48299 | 1615 | 50 |
1202379 | 1202379 | 2021-04-08 | Llano | Texas | 48299 | 1612 | 50 |
1199130 | 1199130 | 2021-04-07 | Llano | Texas | 48299 | 1611 | 50 |
1195881 | 1195881 | 2021-04-06 | Llano | Texas | 48299 | 1611 | 50 |
1192633 | 1192633 | 2021-04-05 | Llano | Texas | 48299 | 1608 | 50 |
1189384 | 1189384 | 2021-04-04 | Llano | Texas | 48299 | 1607 | 50 |
1186137 | 1186137 | 2021-04-03 | Llano | Texas | 48299 | 1607 | 50 |
1182890 | 1182890 | 2021-04-02 | Llano | Texas | 48299 | 1600 | 50 |
1179643 | 1179643 | 2021-04-01 | Llano | Texas | 48299 | 1598 | 50 |
1176396 | 1176396 | 2021-03-31 | Llano | Texas | 48299 | 1598 | 50 |
1173149 | 1173149 | 2021-03-30 | Llano | Texas | 48299 | 1598 | 50 |
1169902 | 1169902 | 2021-03-29 | Llano | Texas | 48299 | 1595 | 50 |
1166654 | 1166654 | 2021-03-28 | Llano | Texas | 48299 | 1592 | 50 |
1163406 | 1163406 | 2021-03-27 | Llano | Texas | 48299 | 1592 | 50 |
1160157 | 1160157 | 2021-03-26 | Llano | Texas | 48299 | 1590 | 50 |
1156910 | 1156910 | 2021-03-25 | Llano | Texas | 48299 | 1587 | 50 |
1153663 | 1153663 | 2021-03-24 | Llano | Texas | 48299 | 1582 | 50 |
1150416 | 1150416 | 2021-03-23 | Llano | Texas | 48299 | 1581 | 50 |
1147169 | 1147169 | 2021-03-22 | Llano | Texas | 48299 | 1580 | 50 |
1143922 | 1143922 | 2021-03-21 | Llano | Texas | 48299 | 1577 | 50 |
1140675 | 1140675 | 2021-03-20 | Llano | Texas | 48299 | 1577 | 49 |
1137429 | 1137429 | 2021-03-19 | Llano | Texas | 48299 | 1574 | 49 |
1134183 | 1134183 | 2021-03-18 | Llano | Texas | 48299 | 1573 | 49 |
1130935 | 1130935 | 2021-03-17 | Llano | Texas | 48299 | 1569 | 49 |
1127688 | 1127688 | 2021-03-16 | Llano | Texas | 48299 | 1560 | 49 |
1124442 | 1124442 | 2021-03-15 | Llano | Texas | 48299 | 1560 | 49 |
1121196 | 1121196 | 2021-03-14 | Llano | Texas | 48299 | 1555 | 49 |
1117949 | 1117949 | 2021-03-13 | Llano | Texas | 48299 | 1555 | 49 |
1114702 | 1114702 | 2021-03-12 | Llano | Texas | 48299 | 1555 | 49 |
1111456 | 1111456 | 2021-03-11 | Llano | Texas | 48299 | 1553 | 48 |
1108210 | 1108210 | 2021-03-10 | Llano | Texas | 48299 | 1551 | 48 |
1104964 | 1104964 | 2021-03-09 | Llano | Texas | 48299 | 1540 | 48 |
1101718 | 1101718 | 2021-03-08 | Llano | Texas | 48299 | 1539 | 48 |
1098472 | 1098472 | 2021-03-07 | Llano | Texas | 48299 | 1536 | 48 |
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);