ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
126 rows where deaths = 188 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2271159 | 2271159 | 2022-03-03 | Cass | Texas | 48067 | 7027 | 188 |
2202896 | 2202896 | 2022-02-10 | Coryell | Texas | 48099 | 16893 | 188 |
2199717 | 2199717 | 2022-02-09 | Jim Wells | Texas | 48249 | 10705 | 188 |
2196463 | 2196463 | 2022-02-08 | Jim Wells | Texas | 48249 | 10682 | 188 |
2193209 | 2193209 | 2022-02-07 | Jim Wells | Texas | 48249 | 10643 | 188 |
2189955 | 2189955 | 2022-02-06 | Jim Wells | Texas | 48249 | 10612 | 188 |
2183450 | 2183450 | 2022-02-04 | Jim Wells | Texas | 48249 | 10528 | 188 |
2180198 | 2180198 | 2022-02-03 | Jim Wells | Texas | 48249 | 10458 | 188 |
2059837 | 2059837 | 2021-12-28 | Harrison | Texas | 48203 | 9507 | 188 |
2059971 | 2059971 | 2021-12-28 | Walker | Texas | 48471 | 12317 | 188 |
2056588 | 2056588 | 2021-12-27 | Harrison | Texas | 48203 | 9488 | 188 |
2056722 | 2056722 | 2021-12-27 | Walker | Texas | 48471 | 12298 | 188 |
2053339 | 2053339 | 2021-12-26 | Harrison | Texas | 48203 | 9469 | 188 |
2053473 | 2053473 | 2021-12-26 | Walker | Texas | 48471 | 12088 | 188 |
2050089 | 2050089 | 2021-12-25 | Harrison | Texas | 48203 | 9469 | 188 |
2050223 | 2050223 | 2021-12-25 | Walker | Texas | 48471 | 12088 | 188 |
2046839 | 2046839 | 2021-12-24 | Harrison | Texas | 48203 | 9469 | 188 |
2046973 | 2046973 | 2021-12-24 | Walker | Texas | 48471 | 12088 | 188 |
2043589 | 2043589 | 2021-12-23 | Harrison | Texas | 48203 | 9469 | 188 |
2043723 | 2043723 | 2021-12-23 | Walker | Texas | 48471 | 12088 | 188 |
2040340 | 2040340 | 2021-12-22 | Harrison | Texas | 48203 | 9449 | 188 |
2040474 | 2040474 | 2021-12-22 | Walker | Texas | 48471 | 12040 | 188 |
2037090 | 2037090 | 2021-12-21 | Harrison | Texas | 48203 | 9435 | 188 |
2037224 | 2037224 | 2021-12-21 | Walker | Texas | 48471 | 12006 | 188 |
2033840 | 2033840 | 2021-12-20 | Harrison | Texas | 48203 | 9430 | 188 |
2033974 | 2033974 | 2021-12-20 | Walker | Texas | 48471 | 11990 | 188 |
2030590 | 2030590 | 2021-12-19 | Harrison | Texas | 48203 | 9424 | 188 |
2030724 | 2030724 | 2021-12-19 | Walker | Texas | 48471 | 11979 | 188 |
2027339 | 2027339 | 2021-12-18 | Harrison | Texas | 48203 | 9421 | 188 |
2027473 | 2027473 | 2021-12-18 | Walker | Texas | 48471 | 11965 | 188 |
2024088 | 2024088 | 2021-12-17 | Harrison | Texas | 48203 | 9414 | 188 |
2024222 | 2024222 | 2021-12-17 | Walker | Texas | 48471 | 11956 | 188 |
2020746 | 2020746 | 2021-12-16 | Bastrop | Texas | 48021 | 14661 | 188 |
2020837 | 2020837 | 2021-12-16 | Harrison | Texas | 48203 | 9402 | 188 |
2017586 | 2017586 | 2021-12-15 | Harrison | Texas | 48203 | 9390 | 188 |
2014336 | 2014336 | 2021-12-14 | Harrison | Texas | 48203 | 9370 | 188 |
2011085 | 2011085 | 2021-12-13 | Harrison | Texas | 48203 | 9354 | 188 |
2007834 | 2007834 | 2021-12-12 | Harrison | Texas | 48203 | 9350 | 188 |
2004583 | 2004583 | 2021-12-11 | Harrison | Texas | 48203 | 9349 | 188 |
2001332 | 2001332 | 2021-12-10 | Harrison | Texas | 48203 | 9335 | 188 |
1998082 | 1998082 | 2021-12-09 | Harrison | Texas | 48203 | 9310 | 188 |
1994831 | 1994831 | 2021-12-08 | Harrison | Texas | 48203 | 9290 | 188 |
1965678 | 1965678 | 2021-11-29 | Rusk | Texas | 48401 | 8169 | 188 |
1962426 | 1962426 | 2021-11-28 | Rusk | Texas | 48401 | 8163 | 188 |
1959175 | 1959175 | 2021-11-27 | Rusk | Texas | 48401 | 8163 | 188 |
1955924 | 1955924 | 2021-11-26 | Rusk | Texas | 48401 | 8163 | 188 |
1952673 | 1952673 | 2021-11-25 | Rusk | Texas | 48401 | 8163 | 188 |
1949422 | 1949422 | 2021-11-24 | Rusk | Texas | 48401 | 8163 | 188 |
1946171 | 1946171 | 2021-11-23 | Rusk | Texas | 48401 | 8167 | 188 |
1942920 | 1942920 | 2021-11-22 | Rusk | Texas | 48401 | 8160 | 188 |
1939670 | 1939670 | 2021-11-21 | Rusk | Texas | 48401 | 8160 | 188 |
1926709 | 1926709 | 2021-11-17 | Wharton | Texas | 48481 | 6307 | 188 |
1920144 | 1920144 | 2021-11-15 | Navarro | Texas | 48349 | 8805 | 188 |
1916894 | 1916894 | 2021-11-14 | Navarro | Texas | 48349 | 8805 | 188 |
1913644 | 1913644 | 2021-11-13 | Navarro | Texas | 48349 | 8805 | 188 |
1910394 | 1910394 | 2021-11-12 | Navarro | Texas | 48349 | 8790 | 188 |
1907145 | 1907145 | 2021-11-11 | Navarro | Texas | 48349 | 8790 | 188 |
1861573 | 1861573 | 2021-10-28 | Hale | Texas | 48189 | 7894 | 188 |
1829234 | 1829234 | 2021-10-18 | Wise | Texas | 48497 | 11056 | 188 |
1825985 | 1825985 | 2021-10-17 | Wise | Texas | 48497 | 11056 | 188 |
1822736 | 1822736 | 2021-10-16 | Wise | Texas | 48497 | 11056 | 188 |
1819487 | 1819487 | 2021-10-15 | Wise | Texas | 48497 | 11026 | 188 |
1816100 | 1816100 | 2021-10-14 | Hood | Texas | 48221 | 9480 | 188 |
1816176 | 1816176 | 2021-10-14 | Polk | Texas | 48373 | 5858 | 188 |
1812852 | 1812852 | 2021-10-13 | Hood | Texas | 48221 | 9463 | 188 |
1812928 | 1812928 | 2021-10-13 | Polk | Texas | 48373 | 5858 | 188 |
1809603 | 1809603 | 2021-10-12 | Hood | Texas | 48221 | 9440 | 188 |
1809679 | 1809679 | 2021-10-12 | Polk | Texas | 48373 | 5855 | 188 |
1799744 | 1799744 | 2021-10-09 | Anderson | Texas | 48001 | 7884 | 188 |
1799843 | 1799843 | 2021-10-09 | Hardin | Texas | 48199 | 10241 | 188 |
1796495 | 1796495 | 2021-10-08 | Anderson | Texas | 48001 | 7884 | 188 |
1767391 | 1767391 | 2021-09-29 | Lamar | Texas | 48277 | 8473 | 188 |
1764009 | 1764009 | 2021-09-28 | Atascosa | Texas | 48013 | 8203 | 188 |
1760760 | 1760760 | 2021-09-27 | Atascosa | Texas | 48013 | 8189 | 188 |
1757512 | 1757512 | 2021-09-26 | Atascosa | Texas | 48013 | 8168 | 188 |
1754264 | 1754264 | 2021-09-25 | Atascosa | Texas | 48013 | 8168 | 188 |
1751016 | 1751016 | 2021-09-24 | Atascosa | Texas | 48013 | 8168 | 188 |
1725212 | 1725212 | 2021-09-16 | Rockwall | Texas | 48397 | 15853 | 188 |
1715442 | 1715442 | 2021-09-13 | Nacogdoches | Texas | 48347 | 6728 | 188 |
1712196 | 1712196 | 2021-09-12 | Nacogdoches | Texas | 48347 | 6728 | 188 |
1708949 | 1708949 | 2021-09-11 | Nacogdoches | Texas | 48347 | 6728 | 188 |
1699210 | 1699210 | 2021-09-08 | Orange | Texas | 48361 | 12267 | 188 |
1695962 | 1695962 | 2021-09-07 | Orange | Texas | 48361 | 12220 | 188 |
1637422 | 1637422 | 2021-08-20 | Hunt | Texas | 48231 | 7489 | 188 |
1452393 | 1452393 | 2021-06-24 | Parker | Texas | 48367 | 16147 | 188 |
1449147 | 1449147 | 2021-06-23 | Parker | Texas | 48367 | 16123 | 188 |
1445902 | 1445902 | 2021-06-22 | Parker | Texas | 48367 | 16121 | 188 |
1442657 | 1442657 | 2021-06-21 | Parker | Texas | 48367 | 16099 | 188 |
1439412 | 1439412 | 2021-06-20 | Parker | Texas | 48367 | 16099 | 188 |
1436165 | 1436165 | 2021-06-19 | Parker | Texas | 48367 | 16099 | 188 |
1380951 | 1380951 | 2021-06-02 | Liberty | Texas | 48291 | 7994 | 188 |
1377706 | 1377706 | 2021-06-01 | Liberty | Texas | 48291 | 8030 | 188 |
1315983 | 1315983 | 2021-05-13 | Henderson | Texas | 48213 | 5908 | 188 |
1312737 | 1312737 | 2021-05-12 | Henderson | Texas | 48213 | 5908 | 188 |
1309490 | 1309490 | 2021-05-11 | Henderson | Texas | 48213 | 5908 | 188 |
1121281 | 1121281 | 2021-03-14 | Victoria | Texas | 48469 | 8011 | 188 |
1118034 | 1118034 | 2021-03-13 | Victoria | Texas | 48469 | 8011 | 188 |
1114787 | 1114787 | 2021-03-12 | Victoria | Texas | 48469 | 8003 | 188 |
1078939 | 1078939 | 2021-03-01 | Guadalupe | Texas | 48187 | 13309 | 188 |
1075694 | 1075694 | 2021-02-28 | Guadalupe | Texas | 48187 | 13309 | 188 |
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);