ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where deaths = 285 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2365707 | 2365707 | 2022-04-01 | Wood | Texas | 48499 | 7995 | 285 |
2362454 | 2362454 | 2022-03-31 | Wood | Texas | 48499 | 7995 | 285 |
1877904 | 1877904 | 2021-11-02 | Orange | Texas | 48361 | 13707 | 285 |
1874655 | 1874655 | 2021-11-01 | Orange | Texas | 48361 | 13701 | 285 |
1871406 | 1871406 | 2021-10-31 | Orange | Texas | 48361 | 13701 | 285 |
1858434 | 1858434 | 2021-10-27 | San Patricio | Texas | 48409 | 6973 | 285 |
1747854 | 1747854 | 2021-09-23 | Guadalupe | Texas | 48187 | 22409 | 285 |
1640721 | 1640721 | 2021-08-21 | Midland | Texas | 48329 | 21334 | 285 |
1637435 | 1637435 | 2021-08-20 | Kaufman | Texas | 48257 | 18763 | 285 |
1637471 | 1637471 | 2021-08-20 | Midland | Texas | 48329 | 21334 | 285 |
1634185 | 1634185 | 2021-08-19 | Kaufman | Texas | 48257 | 18703 | 285 |
1630938 | 1630938 | 2021-08-18 | Kaufman | Texas | 48257 | 18570 | 285 |
1624541 | 1624541 | 2021-08-16 | Tom Green | Texas | 48451 | 19423 | 285 |
1621294 | 1621294 | 2021-08-15 | Tom Green | Texas | 48451 | 19190 | 285 |
1410017 | 1410017 | 2021-06-11 | Angelina | Texas | 48005 | 8675 | 285 |
1173190 | 1173190 | 2021-03-30 | Randall | Texas | 48381 | 16448 | 285 |
1020515 | 1020515 | 2021-02-11 | Grayson | Texas | 48181 | 10381 | 285 |
978311 | 978311 | 2021-01-29 | Galveston | Texas | 48167 | 30058 | 285 |
965371 | 965371 | 2021-01-25 | Jefferson | Texas | 48245 | 16406 | 285 |
962126 | 962126 | 2021-01-24 | Jefferson | Texas | 48245 | 16406 | 285 |
916738 | 916738 | 2021-01-10 | Montgomery | Texas | 48339 | 29994 | 285 |
851851 | 851851 | 2020-12-21 | Potter | Texas | 48375 | 14686 | 285 |
407907 | 407907 | 2020-08-06 | El Paso | Texas | 48141 | 15596 | 285 |
398407 | 398407 | 2020-08-03 | Travis | Texas | 48453 | 21549 | 285 |
242700 | 242700 | 2020-06-15 | Dallas | Texas | 48113 | 14537 | 285 |
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);