ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where deaths = 523 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2287517 | 2287517 | 2022-03-08 | Kaufman | Texas | 48257 | 34960 | 523 |
2241910 | 2241910 | 2022-02-22 | Comal | Texas | 48091 | 31707 | 523 |
2186648 | 2186648 | 2022-02-05 | Ellis | Texas | 48139 | 47016 | 523 |
2183396 | 2183396 | 2022-02-04 | Ellis | Texas | 48139 | 46891 | 523 |
2180144 | 2180144 | 2022-02-03 | Ellis | Texas | 48139 | 46759 | 523 |
2024077 | 2024077 | 2021-12-17 | Grayson | Texas | 48181 | 16777 | 523 |
1920212 | 1920212 | 2021-11-15 | Wichita | Texas | 48485 | 22168 | 523 |
1916962 | 1916962 | 2021-11-14 | Wichita | Texas | 48485 | 22168 | 523 |
1913712 | 1913712 | 2021-11-13 | Wichita | Texas | 48485 | 22168 | 523 |
1910462 | 1910462 | 2021-11-12 | Wichita | Texas | 48485 | 22168 | 523 |
1835551 | 1835551 | 2021-10-20 | Ector | Texas | 48135 | 25548 | 523 |
1832302 | 1832302 | 2021-10-19 | Ector | Texas | 48135 | 25504 | 523 |
1819459 | 1819459 | 2021-10-15 | Taylor | Texas | 48441 | 22548 | 523 |
1669874 | 1669874 | 2021-08-30 | Galveston | Texas | 48167 | 53944 | 523 |
1666627 | 1666627 | 2021-08-29 | Galveston | Texas | 48167 | 53944 | 523 |
1660208 | 1660208 | 2021-08-27 | McLennan | Texas | 48309 | 33388 | 523 |
1650550 | 1650550 | 2021-08-24 | Williamson | Texas | 48491 | 59711 | 523 |
1647301 | 1647301 | 2021-08-23 | Williamson | Texas | 48491 | 59187 | 523 |
1186157 | 1186157 | 2021-04-03 | Montgomery | Texas | 48339 | 49605 | 523 |
907073 | 907073 | 2021-01-07 | Webb | Texas | 48479 | 27686 | 523 |
903827 | 903827 | 2021-01-06 | Webb | Texas | 48479 | 27686 | 523 |
864795 | 864795 | 2020-12-25 | Lubbock | Texas | 48303 | 40453 | 523 |
861550 | 861550 | 2020-12-24 | Lubbock | Texas | 48303 | 40453 | 523 |
858305 | 858305 | 2020-12-23 | Lubbock | Texas | 48303 | 40249 | 523 |
582453 | 582453 | 2020-09-29 | El Paso | Texas | 48141 | 24170 | 523 |
579214 | 579214 | 2020-09-28 | El Paso | Texas | 48141 | 23905 | 523 |
346866 | 346866 | 2020-07-18 | Dallas | Texas | 48113 | 40222 | 523 |
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);