ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where deaths = 485 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2320103 | 2320103 | 2022-03-18 | Randall | Texas | 48381 | 37608 | 485 |
2316849 | 2316849 | 2022-03-17 | Randall | Texas | 48381 | 37603 | 485 |
2313596 | 2313596 | 2022-03-16 | Randall | Texas | 48381 | 37603 | 485 |
2310343 | 2310343 | 2022-03-15 | Randall | Texas | 48381 | 37593 | 485 |
2274543 | 2274543 | 2022-03-04 | Midland | Texas | 48329 | 37295 | 485 |
2264725 | 2264725 | 2022-03-01 | Hays | Texas | 48209 | 59550 | 485 |
2196467 | 2196467 | 2022-02-08 | Kaufman | Texas | 48257 | 34158 | 485 |
2089040 | 2089040 | 2022-01-06 | Comal | Texas | 48091 | 22763 | 485 |
2085789 | 2085789 | 2022-01-05 | Comal | Texas | 48091 | 22583 | 485 |
2082537 | 2082537 | 2022-01-04 | Comal | Texas | 48091 | 22437 | 485 |
2001301 | 2001301 | 2021-12-10 | Ellis | Texas | 48139 | 34380 | 485 |
1998051 | 1998051 | 2021-12-09 | Ellis | Texas | 48139 | 34233 | 485 |
1994800 | 1994800 | 2021-12-08 | Ellis | Texas | 48139 | 34221 | 485 |
1832477 | 1832477 | 2021-10-19 | Wichita | Texas | 48485 | 21692 | 485 |
1527119 | 1527119 | 2021-07-17 | Williamson | Texas | 48491 | 48185 | 485 |
1517291 | 1517291 | 2021-07-14 | McLennan | Texas | 48309 | 27984 | 485 |
1426455 | 1426455 | 2021-06-16 | Smith | Texas | 48423 | 20608 | 485 |
1423208 | 1423208 | 2021-06-15 | Smith | Texas | 48423 | 20608 | 485 |
1419962 | 1419962 | 2021-06-14 | Smith | Texas | 48423 | 20588 | 485 |
1416717 | 1416717 | 2021-06-13 | Smith | Texas | 48423 | 20588 | 485 |
868128 | 868128 | 2020-12-26 | Webb | Texas | 48479 | 25514 | 485 |
864883 | 864883 | 2020-12-25 | Webb | Texas | 48479 | 25514 | 485 |
861638 | 861638 | 2020-12-24 | Webb | Texas | 48479 | 25514 | 485 |
835588 | 835588 | 2020-12-16 | Lubbock | Texas | 48303 | 37786 | 485 |
427194 | 427194 | 2020-08-12 | Cameron | Texas | 48061 | 17316 | 485 |
337271 | 337271 | 2020-07-15 | Dallas | Texas | 48113 | 36969 | 485 |
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);