ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
47 rows where cases = 871 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2170420 | 2170420 | 2022-01-31 | Haskell | Texas | 48207 | 871 | 37 |
2118323 | 2118323 | 2022-01-15 | Donley | Texas | 48129 | 871 | 20 |
2115210 | 2115210 | 2022-01-14 | San Augustine | Texas | 48405 | 871 | 38 |
1978644 | 1978644 | 2021-12-03 | Mills | Texas | 48333 | 871 | 28 |
1975394 | 1975394 | 2021-12-02 | Mills | Texas | 48333 | 871 | 28 |
1887638 | 1887638 | 2021-11-05 | Mills | Texas | 48333 | 871 | 28 |
1884388 | 1884388 | 2021-11-04 | Mills | Texas | 48333 | 871 | 28 |
1877775 | 1877775 | 2021-11-02 | Crane | Texas | 48103 | 871 | 18 |
1874526 | 1874526 | 2021-11-01 | Crane | Texas | 48103 | 871 | 18 |
1871277 | 1871277 | 2021-10-31 | Crane | Texas | 48103 | 871 | 18 |
1783667 | 1783667 | 2021-10-04 | Mitchell | Texas | 48335 | 871 | 36 |
1780418 | 1780418 | 2021-10-03 | Mitchell | Texas | 48335 | 871 | 36 |
1777168 | 1777168 | 2021-10-02 | Mitchell | Texas | 48335 | 871 | 36 |
1773918 | 1773918 | 2021-10-01 | Mitchell | Texas | 48335 | 871 | 36 |
1712228 | 1712228 | 2021-09-12 | San Saba | Texas | 48411 | 871 | 25 |
1708981 | 1708981 | 2021-09-11 | San Saba | Texas | 48411 | 871 | 25 |
1653799 | 1653799 | 2021-08-25 | Winkler | Texas | 48495 | 871 | 23 |
1624511 | 1624511 | 2021-08-16 | Refugio | Texas | 48391 | 871 | 23 |
1621264 | 1621264 | 2021-08-15 | Refugio | Texas | 48391 | 871 | 23 |
1601657 | 1601657 | 2021-08-09 | Franklin | Texas | 48159 | 871 | 26 |
1316048 | 1316048 | 2021-05-13 | Morris | Texas | 48343 | 871 | 33 |
1312802 | 1312802 | 2021-05-12 | Morris | Texas | 48343 | 871 | 33 |
1309555 | 1309555 | 2021-05-11 | Morris | Texas | 48343 | 871 | 33 |
1286910 | 1286910 | 2021-05-04 | Yoakum | Texas | 48501 | 871 | 26 |
1283664 | 1283664 | 2021-05-03 | Yoakum | Texas | 48501 | 871 | 26 |
1280417 | 1280417 | 2021-05-02 | Yoakum | Texas | 48501 | 871 | 26 |
1277170 | 1277170 | 2021-05-01 | Yoakum | Texas | 48501 | 871 | 26 |
1273923 | 1273923 | 2021-04-30 | Yoakum | Texas | 48501 | 871 | 26 |
1270676 | 1270676 | 2021-04-29 | Yoakum | Texas | 48501 | 871 | 26 |
1267429 | 1267429 | 2021-04-28 | Yoakum | Texas | 48501 | 871 | 26 |
1264182 | 1264182 | 2021-04-27 | Yoakum | Texas | 48501 | 871 | 26 |
1260935 | 1260935 | 2021-04-26 | Yoakum | Texas | 48501 | 871 | 26 |
1257688 | 1257688 | 2021-04-25 | Yoakum | Texas | 48501 | 871 | 27 |
1254441 | 1254441 | 2021-04-24 | Yoakum | Texas | 48501 | 871 | 27 |
1251194 | 1251194 | 2021-04-23 | Yoakum | Texas | 48501 | 871 | 27 |
1247947 | 1247947 | 2021-04-22 | Yoakum | Texas | 48501 | 871 | 27 |
1244700 | 1244700 | 2021-04-21 | Yoakum | Texas | 48501 | 871 | 27 |
1241453 | 1241453 | 2021-04-20 | Yoakum | Texas | 48501 | 871 | 27 |
880890 | 880890 | 2020-12-30 | Brewster | Texas | 48043 | 871 | 8 |
874400 | 874400 | 2020-12-28 | Brewster | Texas | 48043 | 871 | 7 |
871155 | 871155 | 2020-12-27 | Brewster | Texas | 48043 | 871 | 7 |
718679 | 718679 | 2020-11-10 | Fannin | Texas | 48147 | 871 | 22 |
657212 | 657212 | 2020-10-22 | Van Zandt | Texas | 48467 | 871 | 29 |
608342 | 608342 | 2020-10-07 | Brown | Texas | 48049 | 871 | 32 |
592339 | 592339 | 2020-10-02 | Waller | Texas | 48473 | 871 | 14 |
343704 | 343704 | 2020-07-17 | Hale | Texas | 48189 | 871 | 19 |
233481 | 233481 | 2020-06-12 | Moore | Texas | 48341 | 871 | 14 |
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);