ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where deaths = 301 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469863 | 2469863 | 2022-05-03 | Val Verde | Texas | 48465 | 14338 | 301 |
2466607 | 2466607 | 2022-05-02 | Val Verde | Texas | 48465 | 14338 | 301 |
2463352 | 2463352 | 2022-05-01 | Val Verde | Texas | 48465 | 14337 | 301 |
2460096 | 2460096 | 2022-04-30 | Val Verde | Texas | 48465 | 14337 | 301 |
2456840 | 2456840 | 2022-04-29 | Val Verde | Texas | 48465 | 14337 | 301 |
2453584 | 2453584 | 2022-04-28 | Val Verde | Texas | 48465 | 14336 | 301 |
2450328 | 2450328 | 2022-04-27 | Val Verde | Texas | 48465 | 14335 | 301 |
2447071 | 2447071 | 2022-04-26 | Val Verde | Texas | 48465 | 14334 | 301 |
2443816 | 2443816 | 2022-04-25 | Val Verde | Texas | 48465 | 14334 | 301 |
2440560 | 2440560 | 2022-04-24 | Val Verde | Texas | 48465 | 14334 | 301 |
2437304 | 2437304 | 2022-04-23 | Val Verde | Texas | 48465 | 14334 | 301 |
2434048 | 2434048 | 2022-04-22 | Val Verde | Texas | 48465 | 14332 | 301 |
2430792 | 2430792 | 2022-04-21 | Val Verde | Texas | 48465 | 14332 | 301 |
2427536 | 2427536 | 2022-04-20 | Val Verde | Texas | 48465 | 14332 | 301 |
2076193 | 2076193 | 2022-01-02 | San Patricio | Texas | 48409 | 7323 | 301 |
2072942 | 2072942 | 2022-01-01 | San Patricio | Texas | 48409 | 7323 | 301 |
2069691 | 2069691 | 2021-12-31 | San Patricio | Texas | 48409 | 7323 | 301 |
2066440 | 2066440 | 2021-12-30 | San Patricio | Texas | 48409 | 7323 | 301 |
2063190 | 2063190 | 2021-12-29 | San Patricio | Texas | 48409 | 7321 | 301 |
2059940 | 2059940 | 2021-12-28 | San Patricio | Texas | 48409 | 7312 | 301 |
2056691 | 2056691 | 2021-12-27 | San Patricio | Texas | 48409 | 7304 | 301 |
1994910 | 1994910 | 2021-12-08 | Orange | Texas | 48361 | 13883 | 301 |
1991659 | 1991659 | 2021-12-07 | Orange | Texas | 48361 | 13882 | 301 |
1790015 | 1790015 | 2021-10-06 | Bowie | Texas | 48037 | 12361 | 301 |
1777094 | 1777094 | 2021-10-02 | Guadalupe | Texas | 48187 | 23110 | 301 |
1777107 | 1777107 | 2021-10-02 | Henderson | Texas | 48213 | 9412 | 301 |
1754403 | 1754403 | 2021-09-25 | Liberty | Texas | 48291 | 12156 | 301 |
1699050 | 1699050 | 2021-09-08 | Brazos | Texas | 48041 | 32031 | 301 |
1686199 | 1686199 | 2021-09-04 | Midland | Texas | 48329 | 22662 | 301 |
1653554 | 1653554 | 2021-08-25 | Angelina | Texas | 48005 | 10842 | 301 |
1410228 | 1410228 | 2021-06-11 | Starr | Texas | 48427 | 9519 | 301 |
1406983 | 1406983 | 2021-06-10 | Starr | Texas | 48427 | 9510 | 301 |
1403737 | 1403737 | 2021-06-09 | Starr | Texas | 48427 | 9508 | 301 |
1400492 | 1400492 | 2021-06-08 | Starr | Texas | 48427 | 9503 | 301 |
1397247 | 1397247 | 2021-06-07 | Starr | Texas | 48427 | 9497 | 301 |
1394000 | 1394000 | 2021-06-06 | Starr | Texas | 48427 | 9497 | 301 |
1390755 | 1390755 | 2021-06-05 | Starr | Texas | 48427 | 9495 | 301 |
1329053 | 1329053 | 2021-05-17 | Randall | Texas | 48381 | 16823 | 301 |
1325807 | 1325807 | 2021-05-16 | Randall | Texas | 48381 | 16808 | 301 |
1322561 | 1322561 | 2021-05-15 | Randall | Texas | 48381 | 16808 | 301 |
1319315 | 1319315 | 2021-05-14 | Randall | Texas | 48381 | 16808 | 301 |
1316067 | 1316067 | 2021-05-13 | Randall | Texas | 48381 | 16800 | 301 |
1069200 | 1069200 | 2021-02-26 | Gregg | Texas | 48183 | 10669 | 301 |
1049725 | 1049725 | 2021-02-20 | Grayson | Texas | 48181 | 10630 | 301 |
1027040 | 1027040 | 2021-02-13 | Johnson | Texas | 48251 | 17909 | 301 |
1023795 | 1023795 | 2021-02-12 | Johnson | Texas | 48251 | 17869 | 301 |
1017193 | 1017193 | 2021-02-10 | Bell | Texas | 48027 | 19878 | 301 |
1010773 | 1010773 | 2021-02-08 | Galveston | Texas | 48167 | 32106 | 301 |
1007527 | 1007527 | 2021-02-07 | Galveston | Texas | 48167 | 32106 | 301 |
1004281 | 1004281 | 2021-02-06 | Galveston | Texas | 48167 | 31958 | 301 |
1001019 | 1001019 | 2021-02-05 | Ector | Texas | 48135 | 14279 | 301 |
994702 | 994702 | 2021-02-03 | Wichita | Texas | 48485 | 14077 | 301 |
975203 | 975203 | 2021-01-28 | Taylor | Texas | 48441 | 14308 | 301 |
926474 | 926474 | 2021-01-13 | Montgomery | Texas | 48339 | 32205 | 301 |
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);