ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 857 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2160656 | 2160656 | 2022-01-28 | Haskell | Texas | 48207 | 857 | 37 |
2134635 | 2134635 | 2022-01-20 | Hudspeth | Texas | 48229 | 857 | 16 |
1975383 | 1975383 | 2021-12-02 | Martin | Texas | 48317 | 857 | 24 |
1929871 | 1929871 | 2021-11-18 | Lynn | Texas | 48305 | 857 | 27 |
1861581 | 1861581 | 2021-10-28 | Hartley | Texas | 48205 | 857 | 2 |
1858332 | 1858332 | 2021-10-27 | Hartley | Texas | 48205 | 857 | 2 |
1855083 | 1855083 | 2021-10-26 | Hartley | Texas | 48205 | 857 | 2 |
1832286 | 1832286 | 2021-10-19 | Crane | Texas | 48103 | 857 | 17 |
1806409 | 1806409 | 2021-10-11 | Mills | Texas | 48333 | 857 | 26 |
1718640 | 1718640 | 2021-09-14 | Jim Hogg | Texas | 48247 | 857 | 19 |
1676474 | 1676474 | 2021-09-01 | Presidio | Texas | 48377 | 857 | 25 |
1614768 | 1614768 | 2021-08-13 | Refugio | Texas | 48391 | 857 | 23 |
1328939 | 1328939 | 2021-05-17 | Floyd | Texas | 48153 | 857 | 30 |
1325693 | 1325693 | 2021-05-16 | Floyd | Texas | 48153 | 857 | 30 |
1322447 | 1322447 | 2021-05-15 | Floyd | Texas | 48153 | 857 | 30 |
1238127 | 1238127 | 2021-04-19 | Morris | Texas | 48343 | 857 | 33 |
1231632 | 1231632 | 2021-04-17 | Morris | Texas | 48343 | 857 | 33 |
1202327 | 1202327 | 2021-04-08 | Hansford | Texas | 48195 | 857 | 23 |
1013956 | 1013956 | 2021-02-09 | Brewster | Texas | 48043 | 857 | 10 |
1010711 | 1010711 | 2021-02-08 | Brewster | Texas | 48043 | 857 | 10 |
1010724 | 1010724 | 2021-02-08 | Castro | Texas | 48069 | 857 | 26 |
1007478 | 1007478 | 2021-02-07 | Castro | Texas | 48069 | 857 | 26 |
1004232 | 1004232 | 2021-02-06 | Castro | Texas | 48069 | 857 | 26 |
1000986 | 1000986 | 2021-02-05 | Castro | Texas | 48069 | 857 | 26 |
997740 | 997740 | 2021-02-04 | Castro | Texas | 48069 | 857 | 26 |
929694 | 929694 | 2021-01-14 | Leon | Texas | 48289 | 857 | 28 |
906851 | 906851 | 2021-01-07 | Bosque | Texas | 48035 | 857 | 18 |
660250 | 660250 | 2020-10-23 | Burnet | Texas | 48053 | 857 | 13 |
653967 | 653967 | 2020-10-21 | Van Zandt | Texas | 48467 | 857 | 28 |
611588 | 611588 | 2020-10-08 | Calhoun | Texas | 48057 | 857 | 8 |
239678 | 239678 | 2020-06-14 | Lubbock | Texas | 48303 | 857 | 51 |
202484 | 202484 | 2020-06-02 | Galveston | Texas | 48167 | 857 | 37 |
97666 | 97666 | 2020-04-28 | El Paso | Texas | 48141 | 857 | 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);