ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where deaths = 447 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2381908 | 2381908 | 2022-04-06 | Parker | Texas | 48367 | 34341 | 447 |
2378653 | 2378653 | 2022-04-05 | Parker | Texas | 48367 | 34339 | 447 |
2375399 | 2375399 | 2022-04-04 | Parker | Texas | 48367 | 34322 | 447 |
2372147 | 2372147 | 2022-04-03 | Parker | Texas | 48367 | 34320 | 447 |
2238772 | 2238772 | 2022-02-21 | Maverick | Texas | 48323 | 20473 | 447 |
2235521 | 2235521 | 2022-02-20 | Maverick | Texas | 48323 | 20465 | 447 |
2232270 | 2232270 | 2022-02-19 | Maverick | Texas | 48323 | 20454 | 447 |
2229019 | 2229019 | 2022-02-18 | Maverick | Texas | 48323 | 20415 | 447 |
2170421 | 2170421 | 2022-01-31 | Hays | Texas | 48209 | 53842 | 447 |
2024115 | 2024115 | 2021-12-17 | Kaufman | Texas | 48257 | 24680 | 447 |
2020864 | 2020864 | 2021-12-16 | Kaufman | Texas | 48257 | 24656 | 447 |
2017613 | 2017613 | 2021-12-15 | Kaufman | Texas | 48257 | 24626 | 447 |
2014363 | 2014363 | 2021-12-14 | Kaufman | Texas | 48257 | 24596 | 447 |
2011112 | 2011112 | 2021-12-13 | Kaufman | Texas | 48257 | 24566 | 447 |
2007861 | 2007861 | 2021-12-12 | Kaufman | Texas | 48257 | 24545 | 447 |
2004610 | 2004610 | 2021-12-11 | Kaufman | Texas | 48257 | 24531 | 447 |
2001359 | 2001359 | 2021-12-10 | Kaufman | Texas | 48257 | 24516 | 447 |
1998109 | 1998109 | 2021-12-09 | Kaufman | Texas | 48257 | 24385 | 447 |
1731638 | 1731638 | 2021-09-18 | Johnson | Texas | 48251 | 25298 | 447 |
1562716 | 1562716 | 2021-07-28 | Jefferson | Texas | 48245 | 21388 | 447 |
1559468 | 1559468 | 2021-07-27 | Jefferson | Texas | 48245 | 21253 | 447 |
1556221 | 1556221 | 2021-07-26 | Jefferson | Texas | 48245 | 21168 | 447 |
1552974 | 1552974 | 2021-07-25 | Jefferson | Texas | 48245 | 21168 | 447 |
1549727 | 1549727 | 2021-07-24 | Jefferson | Texas | 48245 | 21146 | 447 |
1487995 | 1487995 | 2021-07-05 | Galveston | Texas | 48167 | 41239 | 447 |
1484748 | 1484748 | 2021-07-04 | Galveston | Texas | 48167 | 41239 | 447 |
1481502 | 1481502 | 2021-07-03 | Galveston | Texas | 48167 | 41239 | 447 |
1186199 | 1186199 | 2021-04-03 | Smith | Texas | 48423 | 19573 | 447 |
1182952 | 1182952 | 2021-04-02 | Smith | Texas | 48423 | 19573 | 447 |
1179705 | 1179705 | 2021-04-01 | Smith | Texas | 48423 | 19573 | 447 |
1173019 | 1173019 | 2021-03-30 | Brazoria | Texas | 48039 | 35462 | 447 |
1163502 | 1163502 | 2021-03-27 | Williamson | Texas | 48491 | 42823 | 447 |
1104975 | 1104975 | 2021-03-09 | McLennan | Texas | 48309 | 25428 | 447 |
417714 | 417714 | 2020-08-09 | Tarrant | Texas | 48439 | 33860 | 447 |
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);