ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
121 rows where deaths = 166 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2342712 | 2342712 | 2022-03-25 | Burnet | Texas | 48053 | 10803 | 166 |
2339459 | 2339459 | 2022-03-24 | Burnet | Texas | 48053 | 10802 | 166 |
2336205 | 2336205 | 2022-03-23 | Burnet | Texas | 48053 | 10794 | 166 |
2332951 | 2332951 | 2022-03-22 | Burnet | Texas | 48053 | 10779 | 166 |
2232225 | 2232225 | 2022-02-19 | Howard | Texas | 48227 | 6659 | 166 |
2228974 | 2228974 | 2022-02-18 | Howard | Texas | 48227 | 6629 | 166 |
2225723 | 2225723 | 2022-02-17 | Howard | Texas | 48227 | 6614 | 166 |
2222472 | 2222472 | 2022-02-16 | Howard | Texas | 48227 | 6598 | 166 |
2219221 | 2219221 | 2022-02-15 | Howard | Texas | 48227 | 6579 | 166 |
2215968 | 2215968 | 2022-02-14 | Hopkins | Texas | 48223 | 7040 | 166 |
2215970 | 2215970 | 2022-02-14 | Howard | Texas | 48227 | 6560 | 166 |
2212717 | 2212717 | 2022-02-13 | Hopkins | Texas | 48223 | 7038 | 166 |
2212719 | 2212719 | 2022-02-13 | Howard | Texas | 48227 | 6560 | 166 |
2209464 | 2209464 | 2022-02-12 | Hopkins | Texas | 48223 | 7031 | 166 |
2206211 | 2206211 | 2022-02-11 | Hopkins | Texas | 48223 | 7021 | 166 |
2202958 | 2202958 | 2022-02-10 | Hopkins | Texas | 48223 | 7009 | 166 |
2199704 | 2199704 | 2022-02-09 | Hopkins | Texas | 48223 | 7002 | 166 |
2196412 | 2196412 | 2022-02-08 | Fannin | Texas | 48147 | 6524 | 166 |
2193158 | 2193158 | 2022-02-07 | Fannin | Texas | 48147 | 6513 | 166 |
2193314 | 2193314 | 2022-02-07 | Upshur | Texas | 48459 | 7304 | 166 |
2189904 | 2189904 | 2022-02-06 | Fannin | Texas | 48147 | 6506 | 166 |
2190061 | 2190061 | 2022-02-06 | Upshur | Texas | 48459 | 7302 | 166 |
2186651 | 2186651 | 2022-02-05 | Fannin | Texas | 48147 | 6483 | 166 |
2186808 | 2186808 | 2022-02-05 | Upshur | Texas | 48459 | 7289 | 166 |
2183555 | 2183555 | 2022-02-04 | Upshur | Texas | 48459 | 7274 | 166 |
2180303 | 2180303 | 2022-02-03 | Upshur | Texas | 48459 | 7232 | 166 |
2170344 | 2170344 | 2022-01-31 | Caldwell | Texas | 48055 | 13084 | 166 |
2167090 | 2167090 | 2022-01-30 | Caldwell | Texas | 48055 | 13026 | 166 |
2163835 | 2163835 | 2022-01-29 | Caldwell | Texas | 48055 | 12956 | 166 |
2137808 | 2137808 | 2022-01-21 | Cass | Texas | 48067 | 5742 | 166 |
2134554 | 2134554 | 2022-01-20 | Cass | Texas | 48067 | 5668 | 166 |
2131302 | 2131302 | 2022-01-19 | Cass | Texas | 48067 | 5583 | 166 |
2128048 | 2128048 | 2022-01-18 | Cass | Texas | 48067 | 5503 | 166 |
2124920 | 2124920 | 2022-01-17 | Matagorda | Texas | 48321 | 7300 | 166 |
2121668 | 2121668 | 2022-01-16 | Matagorda | Texas | 48321 | 7248 | 166 |
2118416 | 2118416 | 2022-01-15 | Matagorda | Texas | 48321 | 7224 | 166 |
2105373 | 2105373 | 2022-01-11 | Jasper | Texas | 48241 | 4664 | 166 |
2102122 | 2102122 | 2022-01-10 | Jasper | Texas | 48241 | 4623 | 166 |
2098871 | 2098871 | 2022-01-09 | Jasper | Texas | 48241 | 4582 | 166 |
2095619 | 2095619 | 2022-01-08 | Jasper | Texas | 48241 | 4531 | 166 |
1965527 | 1965527 | 2021-11-29 | Coryell | Texas | 48099 | 10788 | 166 |
1962275 | 1962275 | 2021-11-28 | Coryell | Texas | 48099 | 10769 | 166 |
1959024 | 1959024 | 2021-11-27 | Coryell | Texas | 48099 | 10769 | 166 |
1955773 | 1955773 | 2021-11-26 | Coryell | Texas | 48099 | 10769 | 166 |
1952522 | 1952522 | 2021-11-25 | Coryell | Texas | 48099 | 10769 | 166 |
1949271 | 1949271 | 2021-11-24 | Coryell | Texas | 48099 | 10769 | 166 |
1946020 | 1946020 | 2021-11-23 | Coryell | Texas | 48099 | 10770 | 166 |
1942769 | 1942769 | 2021-11-22 | Coryell | Texas | 48099 | 10764 | 166 |
1939519 | 1939519 | 2021-11-21 | Coryell | Texas | 48099 | 10753 | 166 |
1936269 | 1936269 | 2021-11-20 | Coryell | Texas | 48099 | 10753 | 166 |
1933019 | 1933019 | 2021-11-19 | Coryell | Texas | 48099 | 10801 | 166 |
1929768 | 1929768 | 2021-11-18 | Coryell | Texas | 48099 | 10792 | 166 |
1926631 | 1926631 | 2021-11-17 | Medina | Texas | 48325 | 6970 | 166 |
1923381 | 1923381 | 2021-11-16 | Medina | Texas | 48325 | 6954 | 166 |
1920132 | 1920132 | 2021-11-15 | Medina | Texas | 48325 | 6939 | 166 |
1916882 | 1916882 | 2021-11-14 | Medina | Texas | 48325 | 6939 | 166 |
1913632 | 1913632 | 2021-11-13 | Medina | Texas | 48325 | 6939 | 166 |
1910328 | 1910328 | 2021-11-12 | Hill | Texas | 48217 | 5829 | 166 |
1910382 | 1910382 | 2021-11-12 | Medina | Texas | 48325 | 6939 | 166 |
1907133 | 1907133 | 2021-11-11 | Medina | Texas | 48325 | 6927 | 166 |
1903884 | 1903884 | 2021-11-10 | Medina | Texas | 48325 | 6927 | 166 |
1900634 | 1900634 | 2021-11-09 | Medina | Texas | 48325 | 6927 | 166 |
1897384 | 1897384 | 2021-11-08 | Medina | Texas | 48325 | 6930 | 166 |
1894134 | 1894134 | 2021-11-07 | Medina | Texas | 48325 | 6931 | 166 |
1890884 | 1890884 | 2021-11-06 | Medina | Texas | 48325 | 6931 | 166 |
1841992 | 1841992 | 2021-10-22 | Bastrop | Texas | 48021 | 14290 | 166 |
1816190 | 1816190 | 2021-10-14 | Rusk | Texas | 48401 | 8059 | 166 |
1812942 | 1812942 | 2021-10-13 | Rusk | Texas | 48401 | 8046 | 166 |
1799845 | 1799845 | 2021-10-09 | Harrison | Texas | 48203 | 9003 | 166 |
1793370 | 1793370 | 2021-10-07 | Jim Wells | Texas | 48249 | 6999 | 166 |
1760989 | 1760989 | 2021-09-27 | Walker | Texas | 48471 | 11402 | 166 |
1757741 | 1757741 | 2021-09-26 | Walker | Texas | 48471 | 11387 | 166 |
1747785 | 1747785 | 2021-09-23 | Brown | Texas | 48049 | 6491 | 166 |
1744535 | 1744535 | 2021-09-22 | Brown | Texas | 48049 | 6491 | 166 |
1741286 | 1741286 | 2021-09-21 | Brown | Texas | 48049 | 6491 | 166 |
1738037 | 1738037 | 2021-09-20 | Brown | Texas | 48049 | 6491 | 166 |
1734787 | 1734787 | 2021-09-19 | Brown | Texas | 48049 | 6491 | 166 |
1731537 | 1731537 | 2021-09-18 | Brown | Texas | 48049 | 6491 | 166 |
1728287 | 1728287 | 2021-09-17 | Brown | Texas | 48049 | 6491 | 166 |
1715518 | 1715518 | 2021-09-13 | Wood | Texas | 48499 | 5367 | 166 |
1712272 | 1712272 | 2021-09-12 | Wood | Texas | 48499 | 5367 | 166 |
1709025 | 1709025 | 2021-09-11 | Wood | Texas | 48499 | 5367 | 166 |
1699036 | 1699036 | 2021-09-08 | Atascosa | Texas | 48013 | 7735 | 166 |
1676380 | 1676380 | 2021-09-01 | Hale | Texas | 48189 | 6903 | 166 |
1656979 | 1656979 | 2021-08-26 | Orange | Texas | 48361 | 11168 | 166 |
1656997 | 1656997 | 2021-08-26 | Rockwall | Texas | 48397 | 14154 | 166 |
1273788 | 1273788 | 2021-04-30 | Hunt | Texas | 48231 | 5910 | 166 |
1270541 | 1270541 | 2021-04-29 | Hunt | Texas | 48231 | 5898 | 166 |
1267294 | 1267294 | 2021-04-28 | Hunt | Texas | 48231 | 5895 | 166 |
1264047 | 1264047 | 2021-04-27 | Hunt | Texas | 48231 | 5883 | 166 |
1260800 | 1260800 | 2021-04-26 | Hunt | Texas | 48231 | 5498 | 166 |
1257553 | 1257553 | 2021-04-25 | Hunt | Texas | 48231 | 5498 | 166 |
1254306 | 1254306 | 2021-04-24 | Hunt | Texas | 48231 | 5498 | 166 |
1251059 | 1251059 | 2021-04-23 | Hunt | Texas | 48231 | 5498 | 166 |
1228386 | 1228386 | 2021-04-16 | Nacogdoches | Texas | 48347 | 4420 | 166 |
1124438 | 1124438 | 2021-03-15 | Liberty | Texas | 48291 | 7246 | 166 |
1121192 | 1121192 | 2021-03-14 | Liberty | Texas | 48291 | 7234 | 166 |
1117945 | 1117945 | 2021-03-13 | Liberty | Texas | 48291 | 7226 | 166 |
1108244 | 1108244 | 2021-03-10 | Parker | Texas | 48367 | 15022 | 166 |
949043 | 949043 | 2021-01-20 | Brazos | Texas | 48041 | 17226 | 166 |
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);