ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
47 rows where deaths = 302 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499182 | 2499182 | 2022-05-12 | Val Verde | Texas | 48465 | 14362 | 302 |
2495924 | 2495924 | 2022-05-11 | Val Verde | Texas | 48465 | 14359 | 302 |
2492666 | 2492666 | 2022-05-10 | Val Verde | Texas | 48465 | 14357 | 302 |
2489408 | 2489408 | 2022-05-09 | Val Verde | Texas | 48465 | 14343 | 302 |
2486150 | 2486150 | 2022-05-08 | Val Verde | Texas | 48465 | 14343 | 302 |
2482892 | 2482892 | 2022-05-07 | Val Verde | Texas | 48465 | 14340 | 302 |
2479634 | 2479634 | 2022-05-06 | Val Verde | Texas | 48465 | 14340 | 302 |
2476376 | 2476376 | 2022-05-05 | Val Verde | Texas | 48465 | 14339 | 302 |
2473119 | 2473119 | 2022-05-04 | Val Verde | Texas | 48465 | 14339 | 302 |
2095703 | 2095703 | 2022-01-08 | San Patricio | Texas | 48409 | 7853 | 302 |
2092451 | 2092451 | 2022-01-07 | San Patricio | Texas | 48409 | 7756 | 302 |
2089199 | 2089199 | 2022-01-06 | San Patricio | Texas | 48409 | 7700 | 302 |
2085948 | 2085948 | 2022-01-05 | San Patricio | Texas | 48409 | 7630 | 302 |
2082696 | 2082696 | 2022-01-04 | San Patricio | Texas | 48409 | 7568 | 302 |
2079444 | 2079444 | 2022-01-03 | San Patricio | Texas | 48409 | 7533 | 302 |
1998161 | 1998161 | 2021-12-09 | Orange | Texas | 48361 | 13884 | 302 |
1793264 | 1793264 | 2021-10-07 | Bowie | Texas | 48037 | 12396 | 302 |
1786855 | 1786855 | 2021-10-05 | Henderson | Texas | 48213 | 9481 | 302 |
1783593 | 1783593 | 2021-10-04 | Guadalupe | Texas | 48187 | 23122 | 302 |
1783606 | 1783606 | 2021-10-04 | Henderson | Texas | 48213 | 9412 | 302 |
1780344 | 1780344 | 2021-10-03 | Guadalupe | Texas | 48187 | 23110 | 302 |
1780357 | 1780357 | 2021-10-03 | Henderson | Texas | 48213 | 9412 | 302 |
1670016 | 1670016 | 2021-08-30 | Tom Green | Texas | 48451 | 21556 | 302 |
1666769 | 1666769 | 2021-08-29 | Tom Green | Texas | 48451 | 21175 | 302 |
1656801 | 1656801 | 2021-08-26 | Angelina | Texas | 48005 | 10842 | 302 |
1423210 | 1423210 | 2021-06-15 | Starr | Texas | 48427 | 9537 | 302 |
1419964 | 1419964 | 2021-06-14 | Starr | Texas | 48427 | 9536 | 302 |
1416719 | 1416719 | 2021-06-13 | Starr | Texas | 48427 | 9536 | 302 |
1413473 | 1413473 | 2021-06-12 | Starr | Texas | 48427 | 9526 | 302 |
1160078 | 1160078 | 2021-03-26 | Ellis | Texas | 48139 | 22033 | 302 |
1156831 | 1156831 | 2021-03-25 | Ellis | Texas | 48139 | 21729 | 302 |
1153584 | 1153584 | 2021-03-24 | Ellis | Texas | 48139 | 21721 | 302 |
1127584 | 1127584 | 2021-03-16 | Comal | Texas | 48091 | 9454 | 302 |
1124338 | 1124338 | 2021-03-15 | Comal | Texas | 48091 | 9415 | 302 |
1121092 | 1121092 | 2021-03-14 | Comal | Texas | 48091 | 9415 | 302 |
1117845 | 1117845 | 2021-03-13 | Comal | Texas | 48091 | 9415 | 302 |
1056218 | 1056218 | 2021-02-22 | Grayson | Texas | 48181 | 10630 | 302 |
1052972 | 1052972 | 2021-02-21 | Grayson | Texas | 48181 | 10630 | 302 |
1010757 | 1010757 | 2021-02-08 | Ector | Texas | 48135 | 14488 | 302 |
1007511 | 1007511 | 2021-02-07 | Ector | Texas | 48135 | 14488 | 302 |
1004265 | 1004265 | 2021-02-06 | Ector | Texas | 48135 | 14488 | 302 |
988090 | 988090 | 2021-02-01 | Jefferson | Texas | 48245 | 16928 | 302 |
984843 | 984843 | 2021-01-31 | Jefferson | Texas | 48245 | 16928 | 302 |
968738 | 968738 | 2021-01-26 | Williamson | Texas | 48491 | 34263 | 302 |
832233 | 832233 | 2020-12-15 | Collin | Texas | 48085 | 36640 | 302 |
589102 | 589102 | 2020-10-01 | Webb | Texas | 48479 | 14000 | 302 |
248925 | 248925 | 2020-06-17 | Dallas | Texas | 48113 | 15256 | 302 |
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);