ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where deaths = 304 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1705549 | 1705549 | 2021-09-10 | Brazos | Texas | 48041 | 32524 | 304 |
1692698 | 1692698 | 2021-09-06 | Midland | Texas | 48329 | 22662 | 304 |
1676414 | 1676414 | 2021-09-01 | Kaufman | Texas | 48257 | 19741 | 304 |
1669793 | 1669793 | 2021-08-30 | Angelina | Texas | 48005 | 11155 | 304 |
1666546 | 1666546 | 2021-08-29 | Angelina | Texas | 48005 | 11155 | 304 |
1663298 | 1663298 | 2021-08-28 | Angelina | Texas | 48005 | 11155 | 304 |
1653656 | 1653656 | 2021-08-25 | Hays | Texas | 48209 | 27244 | 304 |
1543324 | 1543324 | 2021-07-22 | Starr | Texas | 48427 | 9685 | 304 |
1540076 | 1540076 | 2021-07-21 | Starr | Texas | 48427 | 9662 | 304 |
1536829 | 1536829 | 2021-07-20 | Starr | Texas | 48427 | 9646 | 304 |
1533581 | 1533581 | 2021-07-19 | Starr | Texas | 48427 | 9638 | 304 |
1530334 | 1530334 | 2021-07-18 | Starr | Texas | 48427 | 9638 | 304 |
1494619 | 1494619 | 2021-07-07 | Starr | Texas | 48427 | 9590 | 304 |
1491372 | 1491372 | 2021-07-06 | Starr | Texas | 48427 | 9580 | 304 |
1488125 | 1488125 | 2021-07-05 | Starr | Texas | 48427 | 9577 | 304 |
1484878 | 1484878 | 2021-07-04 | Starr | Texas | 48427 | 9577 | 304 |
1481632 | 1481632 | 2021-07-03 | Starr | Texas | 48427 | 9574 | 304 |
1478385 | 1478385 | 2021-07-02 | Starr | Texas | 48427 | 9569 | 304 |
1475139 | 1475139 | 2021-07-01 | Starr | Texas | 48427 | 9565 | 304 |
1471893 | 1471893 | 2021-06-30 | Starr | Texas | 48427 | 9564 | 304 |
1468648 | 1468648 | 2021-06-29 | Starr | Texas | 48427 | 9564 | 304 |
1465403 | 1465403 | 2021-06-28 | Starr | Texas | 48427 | 9564 | 304 |
1462158 | 1462158 | 2021-06-27 | Starr | Texas | 48427 | 9564 | 304 |
1458913 | 1458913 | 2021-06-26 | Starr | Texas | 48427 | 9564 | 304 |
1455668 | 1455668 | 2021-06-25 | Starr | Texas | 48427 | 9558 | 304 |
1452423 | 1452423 | 2021-06-24 | Starr | Texas | 48427 | 9560 | 304 |
1449177 | 1449177 | 2021-06-23 | Starr | Texas | 48427 | 9560 | 304 |
1445932 | 1445932 | 2021-06-22 | Starr | Texas | 48427 | 9556 | 304 |
1442687 | 1442687 | 2021-06-21 | Starr | Texas | 48427 | 9556 | 304 |
1439442 | 1439442 | 2021-06-20 | Starr | Texas | 48427 | 9556 | 304 |
1436195 | 1436195 | 2021-06-19 | Starr | Texas | 48427 | 9548 | 304 |
1432948 | 1432948 | 2021-06-18 | Starr | Texas | 48427 | 9548 | 304 |
1429702 | 1429702 | 2021-06-17 | Starr | Texas | 48427 | 9544 | 304 |
1426457 | 1426457 | 2021-06-16 | Starr | Texas | 48427 | 9541 | 304 |
1397224 | 1397224 | 2021-06-07 | Randall | Texas | 48381 | 16950 | 304 |
1393977 | 1393977 | 2021-06-06 | Randall | Texas | 48381 | 16939 | 304 |
1390732 | 1390732 | 2021-06-05 | Randall | Texas | 48381 | 16939 | 304 |
1387487 | 1387487 | 2021-06-04 | Randall | Texas | 48381 | 16939 | 304 |
1384242 | 1384242 | 2021-06-03 | Randall | Texas | 48381 | 16931 | 304 |
1380996 | 1380996 | 2021-06-02 | Randall | Texas | 48381 | 16927 | 304 |
1377751 | 1377751 | 2021-06-01 | Randall | Texas | 48381 | 16916 | 304 |
1374505 | 1374505 | 2021-05-31 | Randall | Texas | 48381 | 16913 | 304 |
1371260 | 1371260 | 2021-05-30 | Randall | Texas | 48381 | 16913 | 304 |
1368014 | 1368014 | 2021-05-29 | Randall | Texas | 48381 | 16913 | 304 |
1364768 | 1364768 | 2021-05-28 | Randall | Texas | 48381 | 16913 | 304 |
1147065 | 1147065 | 2021-03-22 | Comal | Texas | 48091 | 9524 | 304 |
1143818 | 1143818 | 2021-03-21 | Comal | Texas | 48091 | 9524 | 304 |
1140571 | 1140571 | 2021-03-20 | Comal | Texas | 48091 | 9524 | 304 |
1059464 | 1059464 | 2021-02-23 | Grayson | Texas | 48181 | 10635 | 304 |
1046513 | 1046513 | 2021-02-19 | Johnson | Texas | 48251 | 18149 | 304 |
1043268 | 1043268 | 2021-02-18 | Johnson | Texas | 48251 | 18149 | 304 |
1040023 | 1040023 | 2021-02-17 | Johnson | Texas | 48251 | 18157 | 304 |
1036778 | 1036778 | 2021-02-16 | Johnson | Texas | 48251 | 17909 | 304 |
1020438 | 1020438 | 2021-02-11 | Bell | Texas | 48027 | 19987 | 304 |
1014002 | 1014002 | 2021-02-09 | Ector | Texas | 48135 | 14724 | 304 |
1014018 | 1014018 | 2021-02-09 | Galveston | Texas | 48167 | 32317 | 304 |
978247 | 978247 | 2021-01-29 | Brazoria | Texas | 48039 | 28149 | 304 |
929719 | 929719 | 2021-01-14 | Montgomery | Texas | 48339 | 32575 | 304 |
881056 | 881056 | 2020-12-30 | Potter | Texas | 48375 | 15129 | 304 |
385348 | 385348 | 2020-07-30 | Cameron | Texas | 48061 | 10155 | 304 |
356631 | 356631 | 2020-07-21 | Tarrant | Texas | 48439 | 22665 | 304 |
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);