ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
145 rows where deaths = 169 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2472913 | 2472913 | 2022-05-04 | Burnet | Texas | 48053 | 11061 | 169 |
2469657 | 2469657 | 2022-05-03 | Burnet | Texas | 48053 | 11059 | 169 |
2466401 | 2466401 | 2022-05-02 | Burnet | Texas | 48053 | 11058 | 169 |
2463146 | 2463146 | 2022-05-01 | Burnet | Texas | 48053 | 11057 | 169 |
2459890 | 2459890 | 2022-04-30 | Burnet | Texas | 48053 | 11053 | 169 |
2456634 | 2456634 | 2022-04-29 | Burnet | Texas | 48053 | 11044 | 169 |
2453378 | 2453378 | 2022-04-28 | Burnet | Texas | 48053 | 11036 | 169 |
2450122 | 2450122 | 2022-04-27 | Burnet | Texas | 48053 | 11030 | 169 |
2446865 | 2446865 | 2022-04-26 | Burnet | Texas | 48053 | 11023 | 169 |
2443610 | 2443610 | 2022-04-25 | Burnet | Texas | 48053 | 11015 | 169 |
2440354 | 2440354 | 2022-04-24 | Burnet | Texas | 48053 | 11014 | 169 |
2437098 | 2437098 | 2022-04-23 | Burnet | Texas | 48053 | 11011 | 169 |
2433842 | 2433842 | 2022-04-22 | Burnet | Texas | 48053 | 11004 | 169 |
2248480 | 2248480 | 2022-02-24 | Howard | Texas | 48227 | 6679 | 169 |
2245229 | 2245229 | 2022-02-23 | Howard | Texas | 48227 | 6676 | 169 |
2238641 | 2238641 | 2022-02-21 | Caldwell | Texas | 48055 | 13997 | 169 |
2238746 | 2238746 | 2022-02-21 | Kerr | Texas | 48265 | 9391 | 169 |
2235390 | 2235390 | 2022-02-20 | Caldwell | Texas | 48055 | 13991 | 169 |
2235495 | 2235495 | 2022-02-20 | Kerr | Texas | 48265 | 9387 | 169 |
2232139 | 2232139 | 2022-02-19 | Caldwell | Texas | 48055 | 13987 | 169 |
2232244 | 2232244 | 2022-02-19 | Kerr | Texas | 48265 | 9384 | 169 |
2228888 | 2228888 | 2022-02-18 | Caldwell | Texas | 48055 | 13977 | 169 |
2225637 | 2225637 | 2022-02-17 | Caldwell | Texas | 48055 | 13965 | 169 |
2219181 | 2219181 | 2022-02-15 | Fannin | Texas | 48147 | 6604 | 169 |
2163928 | 2163928 | 2022-01-29 | Jasper | Texas | 48241 | 5685 | 169 |
2160673 | 2160673 | 2022-01-28 | Jasper | Texas | 48241 | 5656 | 169 |
2157417 | 2157417 | 2022-01-27 | Jasper | Texas | 48241 | 5630 | 169 |
2154164 | 2154164 | 2022-01-26 | Jasper | Texas | 48241 | 5602 | 169 |
2150825 | 2150825 | 2022-01-25 | Cass | Texas | 48067 | 5870 | 169 |
2150912 | 2150912 | 2022-01-25 | Jasper | Texas | 48241 | 5591 | 169 |
2147573 | 2147573 | 2022-01-24 | Cass | Texas | 48067 | 5830 | 169 |
2144319 | 2144319 | 2022-01-23 | Cass | Texas | 48067 | 5813 | 169 |
2076038 | 2076038 | 2022-01-02 | Coryell | Texas | 48099 | 11088 | 169 |
2072787 | 2072787 | 2022-01-01 | Coryell | Texas | 48099 | 11088 | 169 |
2069536 | 2069536 | 2021-12-31 | Coryell | Texas | 48099 | 11088 | 169 |
2066285 | 2066285 | 2021-12-30 | Coryell | Texas | 48099 | 11088 | 169 |
2063035 | 2063035 | 2021-12-29 | Coryell | Texas | 48099 | 11083 | 169 |
2059785 | 2059785 | 2021-12-28 | Coryell | Texas | 48099 | 11065 | 169 |
2056536 | 2056536 | 2021-12-27 | Coryell | Texas | 48099 | 11057 | 169 |
2053287 | 2053287 | 2021-12-26 | Coryell | Texas | 48099 | 10982 | 169 |
2050037 | 2050037 | 2021-12-25 | Coryell | Texas | 48099 | 10982 | 169 |
2046787 | 2046787 | 2021-12-24 | Coryell | Texas | 48099 | 10982 | 169 |
2043537 | 2043537 | 2021-12-23 | Coryell | Texas | 48099 | 10982 | 169 |
2040288 | 2040288 | 2021-12-22 | Coryell | Texas | 48099 | 10974 | 169 |
2037038 | 2037038 | 2021-12-21 | Coryell | Texas | 48099 | 10963 | 169 |
2033788 | 2033788 | 2021-12-20 | Coryell | Texas | 48099 | 10956 | 169 |
2030538 | 2030538 | 2021-12-19 | Coryell | Texas | 48099 | 10949 | 169 |
2027287 | 2027287 | 2021-12-18 | Coryell | Texas | 48099 | 10928 | 169 |
2024036 | 2024036 | 2021-12-17 | Coryell | Texas | 48099 | 10916 | 169 |
1991587 | 1991587 | 2021-12-07 | Hill | Texas | 48217 | 5889 | 169 |
1988336 | 1988336 | 2021-12-06 | Hill | Texas | 48217 | 5889 | 169 |
1985086 | 1985086 | 2021-12-05 | Hill | Texas | 48217 | 5889 | 169 |
1981836 | 1981836 | 2021-12-04 | Hill | Texas | 48217 | 5889 | 169 |
1978586 | 1978586 | 2021-12-03 | Hill | Texas | 48217 | 5886 | 169 |
1975336 | 1975336 | 2021-12-02 | Hill | Texas | 48217 | 5883 | 169 |
1972087 | 1972087 | 2021-12-01 | Hill | Texas | 48217 | 5880 | 169 |
1968891 | 1968891 | 2021-11-30 | Medina | Texas | 48325 | 7054 | 169 |
1965640 | 1965640 | 2021-11-29 | Medina | Texas | 48325 | 7018 | 169 |
1854991 | 1854991 | 2021-10-26 | Bastrop | Texas | 48021 | 14321 | 169 |
1809617 | 1809617 | 2021-10-12 | Jim Wells | Texas | 48249 | 7041 | 169 |
1806367 | 1806367 | 2021-10-11 | Jim Wells | Texas | 48249 | 7033 | 169 |
1803117 | 1803117 | 2021-10-10 | Jim Wells | Texas | 48249 | 7033 | 169 |
1799868 | 1799868 | 2021-10-09 | Jim Wells | Texas | 48249 | 7025 | 169 |
1796619 | 1796619 | 2021-10-08 | Jim Wells | Texas | 48249 | 7021 | 169 |
1773925 | 1773925 | 2021-10-01 | Navarro | Texas | 48349 | 8432 | 169 |
1770675 | 1770675 | 2021-09-30 | Navarro | Texas | 48349 | 8412 | 169 |
1764102 | 1764102 | 2021-09-28 | Hardin | Texas | 48199 | 10027 | 169 |
1760754 | 1760754 | 2021-09-27 | Anderson | Texas | 48001 | 7707 | 169 |
1757506 | 1757506 | 2021-09-26 | Anderson | Texas | 48001 | 7707 | 169 |
1751258 | 1751258 | 2021-09-24 | Wise | Texas | 48497 | 10449 | 169 |
1748009 | 1748009 | 2021-09-23 | Wise | Texas | 48497 | 10449 | 169 |
1744621 | 1744621 | 2021-09-22 | Hood | Texas | 48221 | 8971 | 169 |
1741372 | 1741372 | 2021-09-21 | Hood | Texas | 48221 | 8965 | 169 |
1741448 | 1741448 | 2021-09-21 | Polk | Texas | 48373 | 5562 | 169 |
1721801 | 1721801 | 2021-09-15 | Cherokee | Texas | 48073 | 6229 | 169 |
1679673 | 1679673 | 2021-09-02 | Lamar | Texas | 48277 | 7197 | 169 |
1676425 | 1676425 | 2021-09-01 | Lamar | Texas | 48277 | 7197 | 169 |
1673178 | 1673178 | 2021-08-31 | Lamar | Texas | 48277 | 7038 | 169 |
1669989 | 1669989 | 2021-08-30 | Rockwall | Texas | 48397 | 14203 | 169 |
1666742 | 1666742 | 2021-08-29 | Rockwall | Texas | 48397 | 14203 | 169 |
1663494 | 1663494 | 2021-08-28 | Rockwall | Texas | 48397 | 14203 | 169 |
1660246 | 1660246 | 2021-08-27 | Rockwall | Texas | 48397 | 14203 | 169 |
1309557 | 1309557 | 2021-05-11 | Nacogdoches | Texas | 48347 | 4535 | 169 |
1306311 | 1306311 | 2021-05-10 | Nacogdoches | Texas | 48347 | 4534 | 169 |
1303065 | 1303065 | 2021-05-09 | Nacogdoches | Texas | 48347 | 4531 | 169 |
1299818 | 1299818 | 2021-05-08 | Nacogdoches | Texas | 48347 | 4525 | 169 |
1296571 | 1296571 | 2021-05-07 | Nacogdoches | Texas | 48347 | 4518 | 169 |
1293325 | 1293325 | 2021-05-06 | Nacogdoches | Texas | 48347 | 4517 | 169 |
1290079 | 1290079 | 2021-05-05 | Nacogdoches | Texas | 48347 | 4516 | 169 |
1286833 | 1286833 | 2021-05-04 | Nacogdoches | Texas | 48347 | 4514 | 169 |
1156906 | 1156906 | 2021-03-25 | Liberty | Texas | 48291 | 7350 | 169 |
1153659 | 1153659 | 2021-03-24 | Liberty | Texas | 48291 | 7342 | 169 |
1150412 | 1150412 | 2021-03-23 | Liberty | Texas | 48291 | 7326 | 169 |
1150450 | 1150450 | 2021-03-23 | Parker | Texas | 48367 | 15188 | 169 |
1147165 | 1147165 | 2021-03-22 | Liberty | Texas | 48291 | 7323 | 169 |
1147203 | 1147203 | 2021-03-22 | Parker | Texas | 48367 | 15170 | 169 |
1143918 | 1143918 | 2021-03-21 | Liberty | Texas | 48291 | 7312 | 169 |
1143956 | 1143956 | 2021-03-21 | Parker | Texas | 48367 | 15170 | 169 |
1140671 | 1140671 | 2021-03-20 | Liberty | Texas | 48291 | 7288 | 169 |
1140709 | 1140709 | 2021-03-20 | Parker | Texas | 48367 | 15170 | 169 |
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);