ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
142 rows where deaths = 170 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498975 | 2498975 | 2022-05-12 | Burnet | Texas | 48053 | 11091 | 170 |
2495717 | 2495717 | 2022-05-11 | Burnet | Texas | 48053 | 11086 | 170 |
2492459 | 2492459 | 2022-05-10 | Burnet | Texas | 48053 | 11085 | 170 |
2489201 | 2489201 | 2022-05-09 | Burnet | Texas | 48053 | 11084 | 170 |
2485944 | 2485944 | 2022-05-08 | Burnet | Texas | 48053 | 11075 | 170 |
2482686 | 2482686 | 2022-05-07 | Burnet | Texas | 48053 | 11073 | 170 |
2479428 | 2479428 | 2022-05-06 | Burnet | Texas | 48053 | 11070 | 170 |
2476170 | 2476170 | 2022-05-05 | Burnet | Texas | 48053 | 11068 | 170 |
2245143 | 2245143 | 2022-02-23 | Caldwell | Texas | 48055 | 14012 | 170 |
2241892 | 2241892 | 2022-02-22 | Caldwell | Texas | 48055 | 14006 | 170 |
2228934 | 2228934 | 2022-02-18 | Fannin | Texas | 48147 | 6622 | 170 |
2225683 | 2225683 | 2022-02-17 | Fannin | Texas | 48147 | 6618 | 170 |
2222432 | 2222432 | 2022-02-16 | Fannin | Texas | 48147 | 6612 | 170 |
2219337 | 2219337 | 2022-02-15 | Upshur | Texas | 48459 | 7426 | 170 |
2216086 | 2216086 | 2022-02-14 | Upshur | Texas | 48459 | 7409 | 170 |
2212835 | 2212835 | 2022-02-13 | Upshur | Texas | 48459 | 7407 | 170 |
2209582 | 2209582 | 2022-02-12 | Upshur | Texas | 48459 | 7405 | 170 |
2206329 | 2206329 | 2022-02-11 | Upshur | Texas | 48459 | 7369 | 170 |
2203076 | 2203076 | 2022-02-10 | Upshur | Texas | 48459 | 7354 | 170 |
2196496 | 2196496 | 2022-02-08 | Matagorda | Texas | 48321 | 7932 | 170 |
2193205 | 2193205 | 2022-02-07 | Jasper | Texas | 48241 | 5898 | 170 |
2193242 | 2193242 | 2022-02-07 | Matagorda | Texas | 48321 | 7911 | 170 |
2189951 | 2189951 | 2022-02-06 | Jasper | Texas | 48241 | 5891 | 170 |
2189988 | 2189988 | 2022-02-06 | Matagorda | Texas | 48321 | 7903 | 170 |
2186698 | 2186698 | 2022-02-05 | Jasper | Texas | 48241 | 5866 | 170 |
2186735 | 2186735 | 2022-02-05 | Matagorda | Texas | 48321 | 7891 | 170 |
2183446 | 2183446 | 2022-02-04 | Jasper | Texas | 48241 | 5858 | 170 |
2183483 | 2183483 | 2022-02-04 | Matagorda | Texas | 48321 | 7865 | 170 |
2180194 | 2180194 | 2022-02-03 | Jasper | Texas | 48241 | 5829 | 170 |
2180231 | 2180231 | 2022-02-03 | Matagorda | Texas | 48321 | 7845 | 170 |
2176943 | 2176943 | 2022-02-02 | Jasper | Texas | 48241 | 5804 | 170 |
2176980 | 2176980 | 2022-02-02 | Matagorda | Texas | 48321 | 7814 | 170 |
2173689 | 2173689 | 2022-02-01 | Jasper | Texas | 48241 | 5767 | 170 |
2173726 | 2173726 | 2022-02-01 | Matagorda | Texas | 48321 | 7780 | 170 |
2170437 | 2170437 | 2022-01-31 | Jasper | Texas | 48241 | 5749 | 170 |
2170474 | 2170474 | 2022-01-31 | Matagorda | Texas | 48321 | 7756 | 170 |
2167183 | 2167183 | 2022-01-30 | Jasper | Texas | 48241 | 5725 | 170 |
2167220 | 2167220 | 2022-01-30 | Matagorda | Texas | 48321 | 7740 | 170 |
2163965 | 2163965 | 2022-01-29 | Matagorda | Texas | 48321 | 7713 | 170 |
2160710 | 2160710 | 2022-01-28 | Matagorda | Texas | 48321 | 7698 | 170 |
2157330 | 2157330 | 2022-01-27 | Cass | Texas | 48067 | 5976 | 170 |
2157454 | 2157454 | 2022-01-27 | Matagorda | Texas | 48321 | 7664 | 170 |
2154077 | 2154077 | 2022-01-26 | Cass | Texas | 48067 | 5888 | 170 |
2154201 | 2154201 | 2022-01-26 | Matagorda | Texas | 48321 | 7637 | 170 |
2082541 | 2082541 | 2022-01-04 | Coryell | Texas | 48099 | 11329 | 170 |
2079289 | 2079289 | 2022-01-03 | Coryell | Texas | 48099 | 11257 | 170 |
2037097 | 2037097 | 2021-12-21 | Hill | Texas | 48217 | 5991 | 170 |
2033847 | 2033847 | 2021-12-20 | Hill | Texas | 48217 | 5983 | 170 |
2030597 | 2030597 | 2021-12-19 | Hill | Texas | 48217 | 5977 | 170 |
2027346 | 2027346 | 2021-12-18 | Hill | Texas | 48217 | 5974 | 170 |
2024095 | 2024095 | 2021-12-17 | Hill | Texas | 48217 | 5964 | 170 |
2020844 | 2020844 | 2021-12-16 | Hill | Texas | 48217 | 5962 | 170 |
2020898 | 2020898 | 2021-12-16 | Medina | Texas | 48325 | 7127 | 170 |
2017593 | 2017593 | 2021-12-15 | Hill | Texas | 48217 | 5956 | 170 |
2017647 | 2017647 | 2021-12-15 | Medina | Texas | 48325 | 7123 | 170 |
2014343 | 2014343 | 2021-12-14 | Hill | Texas | 48217 | 5951 | 170 |
2014397 | 2014397 | 2021-12-14 | Medina | Texas | 48325 | 7122 | 170 |
2011092 | 2011092 | 2021-12-13 | Hill | Texas | 48217 | 5942 | 170 |
2011146 | 2011146 | 2021-12-13 | Medina | Texas | 48325 | 7117 | 170 |
2007841 | 2007841 | 2021-12-12 | Hill | Texas | 48217 | 5942 | 170 |
2007895 | 2007895 | 2021-12-12 | Medina | Texas | 48325 | 7116 | 170 |
2004590 | 2004590 | 2021-12-11 | Hill | Texas | 48217 | 5938 | 170 |
2004644 | 2004644 | 2021-12-11 | Medina | Texas | 48325 | 7112 | 170 |
2001339 | 2001339 | 2021-12-10 | Hill | Texas | 48217 | 5929 | 170 |
2001393 | 2001393 | 2021-12-10 | Medina | Texas | 48325 | 7108 | 170 |
1998089 | 1998089 | 2021-12-09 | Hill | Texas | 48217 | 5906 | 170 |
1998143 | 1998143 | 2021-12-09 | Medina | Texas | 48325 | 7088 | 170 |
1994838 | 1994838 | 2021-12-08 | Hill | Texas | 48217 | 5900 | 170 |
1994892 | 1994892 | 2021-12-08 | Medina | Texas | 48325 | 7084 | 170 |
1991641 | 1991641 | 2021-12-07 | Medina | Texas | 48325 | 7081 | 170 |
1988390 | 1988390 | 2021-12-06 | Medina | Texas | 48325 | 7075 | 170 |
1985140 | 1985140 | 2021-12-05 | Medina | Texas | 48325 | 7073 | 170 |
1981890 | 1981890 | 2021-12-04 | Medina | Texas | 48325 | 7069 | 170 |
1978640 | 1978640 | 2021-12-03 | Medina | Texas | 48325 | 7063 | 170 |
1975390 | 1975390 | 2021-12-02 | Medina | Texas | 48325 | 7058 | 170 |
1972141 | 1972141 | 2021-12-01 | Medina | Texas | 48325 | 7057 | 170 |
1858240 | 1858240 | 2021-10-27 | Bastrop | Texas | 48021 | 14337 | 170 |
1832435 | 1832435 | 2021-10-19 | Rusk | Texas | 48401 | 8093 | 170 |
1816091 | 1816091 | 2021-10-14 | Harrison | Texas | 48203 | 9054 | 170 |
1816230 | 1816230 | 2021-10-14 | Wharton | Texas | 48481 | 6160 | 170 |
1812866 | 1812866 | 2021-10-13 | Jim Wells | Texas | 48249 | 7055 | 170 |
1812982 | 1812982 | 2021-10-13 | Wharton | Texas | 48481 | 6133 | 170 |
1770736 | 1770736 | 2021-09-30 | Walker | Texas | 48471 | 11641 | 170 |
1761002 | 1761002 | 2021-09-27 | Wise | Texas | 48497 | 10531 | 170 |
1757754 | 1757754 | 2021-09-26 | Wise | Texas | 48497 | 10531 | 170 |
1754506 | 1754506 | 2021-09-25 | Wise | Texas | 48497 | 10531 | 170 |
1744697 | 1744697 | 2021-09-22 | Polk | Texas | 48373 | 5562 | 170 |
1725050 | 1725050 | 2021-09-16 | Cherokee | Texas | 48073 | 6266 | 170 |
1725247 | 1725247 | 2021-09-16 | Van Zandt | Texas | 48467 | 6800 | 170 |
1722014 | 1722014 | 2021-09-15 | Wood | Texas | 48499 | 5586 | 170 |
1702373 | 1702373 | 2021-09-09 | Hale | Texas | 48189 | 7103 | 170 |
1673237 | 1673237 | 2021-08-31 | Rockwall | Texas | 48397 | 14375 | 170 |
1666724 | 1666724 | 2021-08-29 | Orange | Texas | 48361 | 11410 | 170 |
1663476 | 1663476 | 2021-08-28 | Orange | Texas | 48361 | 11410 | 170 |
1335530 | 1335530 | 2021-05-19 | Nacogdoches | Texas | 48347 | 4562 | 170 |
1332225 | 1332225 | 2021-05-18 | Hunt | Texas | 48231 | 6057 | 170 |
1332283 | 1332283 | 2021-05-18 | Nacogdoches | Texas | 48347 | 4561 | 170 |
1328978 | 1328978 | 2021-05-17 | Hunt | Texas | 48231 | 6053 | 170 |
1329036 | 1329036 | 2021-05-17 | Nacogdoches | Texas | 48347 | 4554 | 170 |
1325732 | 1325732 | 2021-05-16 | Hunt | Texas | 48231 | 6044 | 170 |
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);