ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
759 rows where fips = 48035 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280184 | 1280184 | 2021-05-02 | Bosque | Texas | 48035 | 1665 | 33 |
1276937 | 1276937 | 2021-05-01 | Bosque | Texas | 48035 | 1665 | 33 |
1273690 | 1273690 | 2021-04-30 | Bosque | Texas | 48035 | 1665 | 33 |
1270443 | 1270443 | 2021-04-29 | Bosque | Texas | 48035 | 1665 | 33 |
1267196 | 1267196 | 2021-04-28 | Bosque | Texas | 48035 | 1663 | 33 |
1263949 | 1263949 | 2021-04-27 | Bosque | Texas | 48035 | 1661 | 33 |
1260702 | 1260702 | 2021-04-26 | Bosque | Texas | 48035 | 1661 | 33 |
1257455 | 1257455 | 2021-04-25 | Bosque | Texas | 48035 | 1661 | 33 |
1254208 | 1254208 | 2021-04-24 | Bosque | Texas | 48035 | 1661 | 33 |
1250961 | 1250961 | 2021-04-23 | Bosque | Texas | 48035 | 1658 | 33 |
1247714 | 1247714 | 2021-04-22 | Bosque | Texas | 48035 | 1656 | 33 |
1244467 | 1244467 | 2021-04-21 | Bosque | Texas | 48035 | 1654 | 33 |
1241220 | 1241220 | 2021-04-20 | Bosque | Texas | 48035 | 1654 | 33 |
1237973 | 1237973 | 2021-04-19 | Bosque | Texas | 48035 | 1652 | 33 |
1234726 | 1234726 | 2021-04-18 | Bosque | Texas | 48035 | 1652 | 33 |
1231478 | 1231478 | 2021-04-17 | Bosque | Texas | 48035 | 1652 | 33 |
1228230 | 1228230 | 2021-04-16 | Bosque | Texas | 48035 | 1652 | 33 |
1224982 | 1224982 | 2021-04-15 | Bosque | Texas | 48035 | 1652 | 33 |
1221735 | 1221735 | 2021-04-14 | Bosque | Texas | 48035 | 1652 | 33 |
1218487 | 1218487 | 2021-04-13 | Bosque | Texas | 48035 | 1650 | 33 |
1215239 | 1215239 | 2021-04-12 | Bosque | Texas | 48035 | 1650 | 33 |
1211992 | 1211992 | 2021-04-11 | Bosque | Texas | 48035 | 1645 | 33 |
1208743 | 1208743 | 2021-04-10 | Bosque | Texas | 48035 | 1645 | 33 |
1205495 | 1205495 | 2021-04-09 | Bosque | Texas | 48035 | 1644 | 33 |
1202247 | 1202247 | 2021-04-08 | Bosque | Texas | 48035 | 1643 | 33 |
1198998 | 1198998 | 2021-04-07 | Bosque | Texas | 48035 | 1641 | 33 |
1195749 | 1195749 | 2021-04-06 | Bosque | Texas | 48035 | 1639 | 33 |
1192501 | 1192501 | 2021-04-05 | Bosque | Texas | 48035 | 1637 | 33 |
1189252 | 1189252 | 2021-04-04 | Bosque | Texas | 48035 | 1637 | 33 |
1186005 | 1186005 | 2021-04-03 | Bosque | Texas | 48035 | 1637 | 33 |
1182758 | 1182758 | 2021-04-02 | Bosque | Texas | 48035 | 1636 | 33 |
1179511 | 1179511 | 2021-04-01 | Bosque | Texas | 48035 | 1636 | 33 |
1176264 | 1176264 | 2021-03-31 | Bosque | Texas | 48035 | 1636 | 33 |
1173017 | 1173017 | 2021-03-30 | Bosque | Texas | 48035 | 1635 | 33 |
1169770 | 1169770 | 2021-03-29 | Bosque | Texas | 48035 | 1634 | 33 |
1166522 | 1166522 | 2021-03-28 | Bosque | Texas | 48035 | 1632 | 33 |
1163274 | 1163274 | 2021-03-27 | Bosque | Texas | 48035 | 1632 | 33 |
1160025 | 1160025 | 2021-03-26 | Bosque | Texas | 48035 | 1631 | 33 |
1156778 | 1156778 | 2021-03-25 | Bosque | Texas | 48035 | 1631 | 33 |
1153531 | 1153531 | 2021-03-24 | Bosque | Texas | 48035 | 1627 | 33 |
1150284 | 1150284 | 2021-03-23 | Bosque | Texas | 48035 | 1627 | 33 |
1147037 | 1147037 | 2021-03-22 | Bosque | Texas | 48035 | 1623 | 33 |
1143790 | 1143790 | 2021-03-21 | Bosque | Texas | 48035 | 1621 | 33 |
1140543 | 1140543 | 2021-03-20 | Bosque | Texas | 48035 | 1621 | 33 |
1137297 | 1137297 | 2021-03-19 | Bosque | Texas | 48035 | 1618 | 33 |
1134051 | 1134051 | 2021-03-18 | Bosque | Texas | 48035 | 1618 | 33 |
1130803 | 1130803 | 2021-03-17 | Bosque | Texas | 48035 | 1618 | 32 |
1127556 | 1127556 | 2021-03-16 | Bosque | Texas | 48035 | 1615 | 32 |
1124310 | 1124310 | 2021-03-15 | Bosque | Texas | 48035 | 1615 | 32 |
1121064 | 1121064 | 2021-03-14 | Bosque | Texas | 48035 | 1613 | 32 |
1117817 | 1117817 | 2021-03-13 | Bosque | Texas | 48035 | 1613 | 32 |
1114570 | 1114570 | 2021-03-12 | Bosque | Texas | 48035 | 1612 | 31 |
1111324 | 1111324 | 2021-03-11 | Bosque | Texas | 48035 | 1611 | 31 |
1108078 | 1108078 | 2021-03-10 | Bosque | Texas | 48035 | 1608 | 31 |
1104832 | 1104832 | 2021-03-09 | Bosque | Texas | 48035 | 1608 | 31 |
1101586 | 1101586 | 2021-03-08 | Bosque | Texas | 48035 | 1603 | 31 |
1098340 | 1098340 | 2021-03-07 | Bosque | Texas | 48035 | 1602 | 31 |
1095092 | 1095092 | 2021-03-06 | Bosque | Texas | 48035 | 1602 | 31 |
1091846 | 1091846 | 2021-03-05 | Bosque | Texas | 48035 | 1601 | 31 |
1088600 | 1088600 | 2021-03-04 | Bosque | Texas | 48035 | 1600 | 31 |
1085355 | 1085355 | 2021-03-03 | Bosque | Texas | 48035 | 1597 | 31 |
1082109 | 1082109 | 2021-03-02 | Bosque | Texas | 48035 | 1596 | 31 |
1078863 | 1078863 | 2021-03-01 | Bosque | Texas | 48035 | 1595 | 30 |
1075618 | 1075618 | 2021-02-28 | Bosque | Texas | 48035 | 1592 | 30 |
1072372 | 1072372 | 2021-02-27 | Bosque | Texas | 48035 | 1592 | 30 |
1069126 | 1069126 | 2021-02-26 | Bosque | Texas | 48035 | 1591 | 30 |
1065881 | 1065881 | 2021-02-25 | Bosque | Texas | 48035 | 1583 | 30 |
1062636 | 1062636 | 2021-02-24 | Bosque | Texas | 48035 | 1580 | 29 |
1059391 | 1059391 | 2021-02-23 | Bosque | Texas | 48035 | 1573 | 29 |
1056145 | 1056145 | 2021-02-22 | Bosque | Texas | 48035 | 1571 | 28 |
1052899 | 1052899 | 2021-02-21 | Bosque | Texas | 48035 | 1571 | 28 |
1049652 | 1049652 | 2021-02-20 | Bosque | Texas | 48035 | 1571 | 28 |
1046405 | 1046405 | 2021-02-19 | Bosque | Texas | 48035 | 1571 | 28 |
1043160 | 1043160 | 2021-02-18 | Bosque | Texas | 48035 | 1566 | 28 |
1039915 | 1039915 | 2021-02-17 | Bosque | Texas | 48035 | 1566 | 28 |
1036670 | 1036670 | 2021-02-16 | Bosque | Texas | 48035 | 1564 | 28 |
1033425 | 1033425 | 2021-02-15 | Bosque | Texas | 48035 | 1549 | 28 |
1030179 | 1030179 | 2021-02-14 | Bosque | Texas | 48035 | 1549 | 28 |
1026932 | 1026932 | 2021-02-13 | Bosque | Texas | 48035 | 1549 | 28 |
1023687 | 1023687 | 2021-02-12 | Bosque | Texas | 48035 | 1543 | 28 |
1020442 | 1020442 | 2021-02-11 | Bosque | Texas | 48035 | 1539 | 28 |
1017197 | 1017197 | 2021-02-10 | Bosque | Texas | 48035 | 1536 | 28 |
1013952 | 1013952 | 2021-02-09 | Bosque | Texas | 48035 | 1525 | 27 |
1010707 | 1010707 | 2021-02-08 | Bosque | Texas | 48035 | 1523 | 27 |
1007461 | 1007461 | 2021-02-07 | Bosque | Texas | 48035 | 1516 | 27 |
1004215 | 1004215 | 2021-02-06 | Bosque | Texas | 48035 | 1512 | 27 |
1000969 | 1000969 | 2021-02-05 | Bosque | Texas | 48035 | 1507 | 27 |
997723 | 997723 | 2021-02-04 | Bosque | Texas | 48035 | 1504 | 26 |
994477 | 994477 | 2021-02-03 | Bosque | Texas | 48035 | 1491 | 26 |
991231 | 991231 | 2021-02-02 | Bosque | Texas | 48035 | 1483 | 26 |
987985 | 987985 | 2021-02-01 | Bosque | Texas | 48035 | 1463 | 25 |
984738 | 984738 | 2021-01-31 | Bosque | Texas | 48035 | 1040 | 24 |
981491 | 981491 | 2021-01-30 | Bosque | Texas | 48035 | 1037 | 24 |
978245 | 978245 | 2021-01-29 | Bosque | Texas | 48035 | 1037 | 24 |
975000 | 975000 | 2021-01-28 | Bosque | Texas | 48035 | 1032 | 24 |
971755 | 971755 | 2021-01-27 | Bosque | Texas | 48035 | 1026 | 23 |
968510 | 968510 | 2021-01-26 | Bosque | Texas | 48035 | 1025 | 22 |
965266 | 965266 | 2021-01-25 | Bosque | Texas | 48035 | 1018 | 22 |
962021 | 962021 | 2021-01-24 | Bosque | Texas | 48035 | 1018 | 22 |
958776 | 958776 | 2021-01-23 | Bosque | Texas | 48035 | 1018 | 21 |
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);