ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
163 rows where deaths = 26 and fips = 48159 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1630889 | 1630889 | 2021-08-18 | Franklin | Texas | 48159 | 930 | 26 |
1627642 | 1627642 | 2021-08-17 | Franklin | Texas | 48159 | 922 | 26 |
1624395 | 1624395 | 2021-08-16 | Franklin | Texas | 48159 | 917 | 26 |
1621148 | 1621148 | 2021-08-15 | Franklin | Texas | 48159 | 917 | 26 |
1617900 | 1617900 | 2021-08-14 | Franklin | Texas | 48159 | 916 | 26 |
1614652 | 1614652 | 2021-08-13 | Franklin | Texas | 48159 | 904 | 26 |
1611403 | 1611403 | 2021-08-12 | Franklin | Texas | 48159 | 897 | 26 |
1608155 | 1608155 | 2021-08-11 | Franklin | Texas | 48159 | 889 | 26 |
1604906 | 1604906 | 2021-08-10 | Franklin | Texas | 48159 | 876 | 26 |
1601657 | 1601657 | 2021-08-09 | Franklin | Texas | 48159 | 871 | 26 |
1598409 | 1598409 | 2021-08-08 | Franklin | Texas | 48159 | 867 | 26 |
1595160 | 1595160 | 2021-08-07 | Franklin | Texas | 48159 | 866 | 26 |
1591911 | 1591911 | 2021-08-06 | Franklin | Texas | 48159 | 861 | 26 |
1588662 | 1588662 | 2021-08-05 | Franklin | Texas | 48159 | 859 | 26 |
1585412 | 1585412 | 2021-08-04 | Franklin | Texas | 48159 | 849 | 26 |
1582162 | 1582162 | 2021-08-03 | Franklin | Texas | 48159 | 843 | 26 |
1578913 | 1578913 | 2021-08-02 | Franklin | Texas | 48159 | 841 | 26 |
1575665 | 1575665 | 2021-08-01 | Franklin | Texas | 48159 | 838 | 26 |
1572417 | 1572417 | 2021-07-31 | Franklin | Texas | 48159 | 837 | 26 |
1569169 | 1569169 | 2021-07-30 | Franklin | Texas | 48159 | 835 | 26 |
1565921 | 1565921 | 2021-07-29 | Franklin | Texas | 48159 | 832 | 26 |
1562673 | 1562673 | 2021-07-28 | Franklin | Texas | 48159 | 827 | 26 |
1559425 | 1559425 | 2021-07-27 | Franklin | Texas | 48159 | 826 | 26 |
1556178 | 1556178 | 2021-07-26 | Franklin | Texas | 48159 | 825 | 26 |
1552931 | 1552931 | 2021-07-25 | Franklin | Texas | 48159 | 822 | 26 |
1549684 | 1549684 | 2021-07-24 | Franklin | Texas | 48159 | 822 | 26 |
1546437 | 1546437 | 2021-07-23 | Franklin | Texas | 48159 | 822 | 26 |
1543190 | 1543190 | 2021-07-22 | Franklin | Texas | 48159 | 822 | 26 |
1539942 | 1539942 | 2021-07-21 | Franklin | Texas | 48159 | 822 | 26 |
1536695 | 1536695 | 2021-07-20 | Franklin | Texas | 48159 | 821 | 26 |
1533447 | 1533447 | 2021-07-19 | Franklin | Texas | 48159 | 821 | 26 |
1530200 | 1530200 | 2021-07-18 | Franklin | Texas | 48159 | 821 | 26 |
1526953 | 1526953 | 2021-07-17 | Franklin | Texas | 48159 | 821 | 26 |
1523706 | 1523706 | 2021-07-16 | Franklin | Texas | 48159 | 820 | 26 |
1520458 | 1520458 | 2021-07-15 | Franklin | Texas | 48159 | 819 | 26 |
1517210 | 1517210 | 2021-07-14 | Franklin | Texas | 48159 | 819 | 26 |
1513963 | 1513963 | 2021-07-13 | Franklin | Texas | 48159 | 820 | 26 |
1510717 | 1510717 | 2021-07-12 | Franklin | Texas | 48159 | 819 | 26 |
1507470 | 1507470 | 2021-07-11 | Franklin | Texas | 48159 | 819 | 26 |
1504224 | 1504224 | 2021-07-10 | Franklin | Texas | 48159 | 817 | 26 |
1500978 | 1500978 | 2021-07-09 | Franklin | Texas | 48159 | 817 | 26 |
1497732 | 1497732 | 2021-07-08 | Franklin | Texas | 48159 | 817 | 26 |
1494485 | 1494485 | 2021-07-07 | Franklin | Texas | 48159 | 816 | 26 |
1491238 | 1491238 | 2021-07-06 | Franklin | Texas | 48159 | 816 | 26 |
1487991 | 1487991 | 2021-07-05 | Franklin | Texas | 48159 | 816 | 26 |
1484744 | 1484744 | 2021-07-04 | Franklin | Texas | 48159 | 816 | 26 |
1481498 | 1481498 | 2021-07-03 | Franklin | Texas | 48159 | 816 | 26 |
1478251 | 1478251 | 2021-07-02 | Franklin | Texas | 48159 | 814 | 26 |
1475005 | 1475005 | 2021-07-01 | Franklin | Texas | 48159 | 814 | 26 |
1471759 | 1471759 | 2021-06-30 | Franklin | Texas | 48159 | 814 | 26 |
1468514 | 1468514 | 2021-06-29 | Franklin | Texas | 48159 | 814 | 26 |
1465269 | 1465269 | 2021-06-28 | Franklin | Texas | 48159 | 814 | 26 |
1462024 | 1462024 | 2021-06-27 | Franklin | Texas | 48159 | 814 | 26 |
1458779 | 1458779 | 2021-06-26 | Franklin | Texas | 48159 | 814 | 26 |
1455534 | 1455534 | 2021-06-25 | Franklin | Texas | 48159 | 800 | 26 |
1452289 | 1452289 | 2021-06-24 | Franklin | Texas | 48159 | 785 | 26 |
1449043 | 1449043 | 2021-06-23 | Franklin | Texas | 48159 | 769 | 26 |
1445798 | 1445798 | 2021-06-22 | Franklin | Texas | 48159 | 760 | 26 |
1442553 | 1442553 | 2021-06-21 | Franklin | Texas | 48159 | 756 | 26 |
1439308 | 1439308 | 2021-06-20 | Franklin | Texas | 48159 | 756 | 26 |
1436061 | 1436061 | 2021-06-19 | Franklin | Texas | 48159 | 756 | 26 |
1432814 | 1432814 | 2021-06-18 | Franklin | Texas | 48159 | 742 | 26 |
1429568 | 1429568 | 2021-06-17 | Franklin | Texas | 48159 | 739 | 26 |
1426323 | 1426323 | 2021-06-16 | Franklin | Texas | 48159 | 739 | 26 |
1423076 | 1423076 | 2021-06-15 | Franklin | Texas | 48159 | 739 | 26 |
1419830 | 1419830 | 2021-06-14 | Franklin | Texas | 48159 | 739 | 26 |
1416585 | 1416585 | 2021-06-13 | Franklin | Texas | 48159 | 739 | 26 |
1413339 | 1413339 | 2021-06-12 | Franklin | Texas | 48159 | 739 | 26 |
1410094 | 1410094 | 2021-06-11 | Franklin | Texas | 48159 | 739 | 26 |
1406849 | 1406849 | 2021-06-10 | Franklin | Texas | 48159 | 739 | 26 |
1403603 | 1403603 | 2021-06-09 | Franklin | Texas | 48159 | 739 | 26 |
1400358 | 1400358 | 2021-06-08 | Franklin | Texas | 48159 | 739 | 26 |
1397113 | 1397113 | 2021-06-07 | Franklin | Texas | 48159 | 739 | 26 |
1393866 | 1393866 | 2021-06-06 | Franklin | Texas | 48159 | 739 | 26 |
1390621 | 1390621 | 2021-06-05 | Franklin | Texas | 48159 | 738 | 26 |
1387376 | 1387376 | 2021-06-04 | Franklin | Texas | 48159 | 737 | 26 |
1384131 | 1384131 | 2021-06-03 | Franklin | Texas | 48159 | 737 | 26 |
1380885 | 1380885 | 2021-06-02 | Franklin | Texas | 48159 | 738 | 26 |
1377640 | 1377640 | 2021-06-01 | Franklin | Texas | 48159 | 738 | 26 |
1374394 | 1374394 | 2021-05-31 | Franklin | Texas | 48159 | 736 | 26 |
1371149 | 1371149 | 2021-05-30 | Franklin | Texas | 48159 | 736 | 26 |
1367903 | 1367903 | 2021-05-29 | Franklin | Texas | 48159 | 736 | 26 |
1364657 | 1364657 | 2021-05-28 | Franklin | Texas | 48159 | 735 | 26 |
1361411 | 1361411 | 2021-05-27 | Franklin | Texas | 48159 | 735 | 26 |
1358165 | 1358165 | 2021-05-26 | Franklin | Texas | 48159 | 735 | 26 |
1354919 | 1354919 | 2021-05-25 | Franklin | Texas | 48159 | 735 | 26 |
1351673 | 1351673 | 2021-05-24 | Franklin | Texas | 48159 | 735 | 26 |
1348427 | 1348427 | 2021-05-23 | Franklin | Texas | 48159 | 733 | 26 |
1345179 | 1345179 | 2021-05-22 | Franklin | Texas | 48159 | 733 | 26 |
1341931 | 1341931 | 2021-05-21 | Franklin | Texas | 48159 | 733 | 26 |
1338683 | 1338683 | 2021-05-20 | Franklin | Texas | 48159 | 734 | 26 |
1335436 | 1335436 | 2021-05-19 | Franklin | Texas | 48159 | 734 | 26 |
1332189 | 1332189 | 2021-05-18 | Franklin | Texas | 48159 | 732 | 26 |
1328942 | 1328942 | 2021-05-17 | Franklin | Texas | 48159 | 732 | 26 |
1325696 | 1325696 | 2021-05-16 | Franklin | Texas | 48159 | 732 | 26 |
1322450 | 1322450 | 2021-05-15 | Franklin | Texas | 48159 | 731 | 26 |
1319204 | 1319204 | 2021-05-14 | Franklin | Texas | 48159 | 731 | 26 |
1315956 | 1315956 | 2021-05-13 | Franklin | Texas | 48159 | 731 | 26 |
1312710 | 1312710 | 2021-05-12 | Franklin | Texas | 48159 | 731 | 26 |
1309463 | 1309463 | 2021-05-11 | Franklin | Texas | 48159 | 731 | 26 |
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);