ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
47 rows where deaths = 267 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2342934 | 2342934 | 2022-03-25 | Wise | Texas | 48497 | 16886 | 267 |
2303759 | 2303759 | 2022-03-13 | Hood | Texas | 48221 | 13310 | 267 |
2300507 | 2300507 | 2022-03-12 | Hood | Texas | 48221 | 13306 | 267 |
2297255 | 2297255 | 2022-03-11 | Hood | Texas | 48221 | 13304 | 267 |
2294003 | 2294003 | 2022-03-10 | Hood | Texas | 48221 | 13300 | 267 |
2248600 | 2248600 | 2022-02-24 | Van Zandt | Texas | 48467 | 10162 | 267 |
2180306 | 2180306 | 2022-02-03 | Val Verde | Texas | 48465 | 13818 | 267 |
1806447 | 1806447 | 2021-10-11 | San Patricio | Texas | 48409 | 6864 | 267 |
1803197 | 1803197 | 2021-10-10 | San Patricio | Texas | 48409 | 6864 | 267 |
1799948 | 1799948 | 2021-10-09 | San Patricio | Texas | 48409 | 6864 | 267 |
1770684 | 1770684 | 2021-09-30 | Parker | Texas | 48367 | 22634 | 267 |
1725120 | 1725120 | 2021-09-16 | Henderson | Texas | 48213 | 8727 | 267 |
1715414 | 1715414 | 2021-09-13 | Liberty | Texas | 48291 | 11583 | 267 |
1712168 | 1712168 | 2021-09-12 | Liberty | Texas | 48291 | 11556 | 267 |
1595101 | 1595101 | 2021-08-07 | Brazos | Texas | 48041 | 29141 | 267 |
1523755 | 1523755 | 2021-07-16 | Kaufman | Texas | 48257 | 16694 | 267 |
1520507 | 1520507 | 2021-07-15 | Kaufman | Texas | 48257 | 16674 | 267 |
1517259 | 1517259 | 2021-07-14 | Kaufman | Texas | 48257 | 16640 | 267 |
1296562 | 1296562 | 2021-05-07 | Midland | Texas | 48329 | 17433 | 267 |
1293316 | 1293316 | 2021-05-06 | Midland | Texas | 48329 | 17433 | 267 |
1199206 | 1199206 | 2021-04-07 | Tom Green | Texas | 48451 | 16630 | 267 |
1195957 | 1195957 | 2021-04-06 | Tom Green | Texas | 48451 | 16619 | 267 |
1192709 | 1192709 | 2021-04-05 | Tom Green | Texas | 48451 | 16614 | 267 |
1189460 | 1189460 | 2021-04-04 | Tom Green | Texas | 48451 | 16604 | 267 |
1186213 | 1186213 | 2021-04-03 | Tom Green | Texas | 48451 | 16604 | 267 |
1182966 | 1182966 | 2021-04-02 | Tom Green | Texas | 48451 | 16604 | 267 |
1179719 | 1179719 | 2021-04-01 | Tom Green | Texas | 48451 | 16598 | 267 |
1176472 | 1176472 | 2021-03-31 | Tom Green | Texas | 48451 | 16591 | 267 |
1173225 | 1173225 | 2021-03-30 | Tom Green | Texas | 48451 | 16582 | 267 |
1137282 | 1137282 | 2021-03-19 | Angelina | Texas | 48005 | 8051 | 267 |
1134036 | 1134036 | 2021-03-18 | Angelina | Texas | 48005 | 8051 | 267 |
1130788 | 1130788 | 2021-03-17 | Angelina | Texas | 48005 | 8051 | 267 |
1049705 | 1049705 | 2021-02-20 | Ellis | Texas | 48139 | 20406 | 267 |
1046458 | 1046458 | 2021-02-19 | Ellis | Texas | 48139 | 20331 | 267 |
1043213 | 1043213 | 2021-02-18 | Ellis | Texas | 48139 | 20331 | 267 |
958842 | 958842 | 2021-01-23 | Galveston | Texas | 48167 | 28624 | 267 |
952510 | 952510 | 2021-01-21 | Wichita | Texas | 48485 | 13541 | 267 |
942597 | 942597 | 2021-01-18 | Ector | Texas | 48135 | 12222 | 267 |
939352 | 939352 | 2021-01-17 | Ector | Texas | 48135 | 12222 | 267 |
900512 | 900512 | 2021-01-05 | Montgomery | Texas | 48339 | 28812 | 267 |
887570 | 887570 | 2021-01-01 | Smith | Texas | 48423 | 12844 | 267 |
530643 | 530643 | 2020-09-13 | Fort Bend | Texas | 48157 | 15423 | 267 |
527565 | 527565 | 2020-09-12 | Webb | Texas | 48479 | 12580 | 267 |
346917 | 346917 | 2020-07-18 | Hidalgo | Texas | 48215 | 10884 | 267 |
343717 | 343717 | 2020-07-17 | Hidalgo | Texas | 48215 | 10884 | 267 |
230314 | 230314 | 2020-06-11 | Harris | Texas | 48201 | 15864 | 267 |
227210 | 227210 | 2020-06-10 | Harris | Texas | 48201 | 15552 | 267 |
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);