ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where deaths = 298 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2388467 | 2388467 | 2022-04-08 | Val Verde | Texas | 48465 | 14313 | 298 |
2385212 | 2385212 | 2022-04-07 | Val Verde | Texas | 48465 | 14310 | 298 |
2381957 | 2381957 | 2022-04-06 | Val Verde | Texas | 48465 | 14309 | 298 |
2378702 | 2378702 | 2022-04-05 | Val Verde | Texas | 48465 | 14306 | 298 |
2375448 | 2375448 | 2022-04-04 | Val Verde | Texas | 48465 | 14305 | 298 |
2372196 | 2372196 | 2022-04-03 | Val Verde | Texas | 48465 | 14304 | 298 |
2368943 | 2368943 | 2022-04-02 | Val Verde | Texas | 48465 | 14303 | 298 |
2365690 | 2365690 | 2022-04-01 | Val Verde | Texas | 48465 | 14301 | 298 |
2362437 | 2362437 | 2022-03-31 | Val Verde | Texas | 48465 | 14300 | 298 |
2359183 | 2359183 | 2022-03-30 | Val Verde | Texas | 48465 | 14299 | 298 |
2033943 | 2033943 | 2021-12-20 | San Patricio | Texas | 48409 | 7245 | 298 |
2030693 | 2030693 | 2021-12-19 | San Patricio | Texas | 48409 | 7243 | 298 |
2027442 | 2027442 | 2021-12-18 | San Patricio | Texas | 48409 | 7237 | 298 |
2024191 | 2024191 | 2021-12-17 | San Patricio | Texas | 48409 | 7232 | 298 |
2020940 | 2020940 | 2021-12-16 | San Patricio | Texas | 48409 | 7231 | 298 |
2017689 | 2017689 | 2021-12-15 | San Patricio | Texas | 48409 | 7229 | 298 |
2014439 | 2014439 | 2021-12-14 | San Patricio | Texas | 48409 | 7223 | 298 |
2011188 | 2011188 | 2021-12-13 | San Patricio | Texas | 48409 | 7223 | 298 |
2007937 | 2007937 | 2021-12-12 | San Patricio | Texas | 48409 | 7223 | 298 |
2004686 | 2004686 | 2021-12-11 | San Patricio | Texas | 48409 | 7223 | 298 |
2001435 | 2001435 | 2021-12-10 | San Patricio | Texas | 48409 | 7218 | 298 |
1998185 | 1998185 | 2021-12-09 | San Patricio | Texas | 48409 | 7197 | 298 |
1994934 | 1994934 | 2021-12-08 | San Patricio | Texas | 48409 | 7194 | 298 |
1991683 | 1991683 | 2021-12-07 | San Patricio | Texas | 48409 | 7194 | 298 |
1988408 | 1988408 | 2021-12-06 | Orange | Texas | 48361 | 13872 | 298 |
1988432 | 1988432 | 2021-12-06 | San Patricio | Texas | 48409 | 7188 | 298 |
1985158 | 1985158 | 2021-12-05 | Orange | Texas | 48361 | 13872 | 298 |
1985182 | 1985182 | 2021-12-05 | San Patricio | Texas | 48409 | 7186 | 298 |
1981908 | 1981908 | 2021-12-04 | Orange | Texas | 48361 | 13871 | 298 |
1981932 | 1981932 | 2021-12-04 | San Patricio | Texas | 48409 | 7186 | 298 |
1978682 | 1978682 | 2021-12-03 | San Patricio | Texas | 48409 | 7183 | 298 |
1975432 | 1975432 | 2021-12-02 | San Patricio | Texas | 48409 | 7182 | 298 |
1972183 | 1972183 | 2021-12-01 | San Patricio | Texas | 48409 | 7180 | 298 |
1968933 | 1968933 | 2021-11-30 | San Patricio | Texas | 48409 | 7179 | 298 |
1965682 | 1965682 | 2021-11-29 | San Patricio | Texas | 48409 | 7167 | 298 |
1835667 | 1835667 | 2021-10-20 | Parker | Texas | 48367 | 23924 | 298 |
1751155 | 1751155 | 2021-09-24 | Liberty | Texas | 48291 | 12109 | 298 |
1682804 | 1682804 | 2021-09-03 | Brazos | Texas | 48041 | 31599 | 298 |
1679698 | 1679698 | 2021-09-02 | Midland | Texas | 48329 | 22662 | 298 |
1660273 | 1660273 | 2021-08-27 | Tom Green | Texas | 48451 | 21175 | 298 |
1647160 | 1647160 | 2021-08-23 | Hays | Texas | 48209 | 26803 | 298 |
1381019 | 1381019 | 2021-06-02 | Starr | Texas | 48427 | 9476 | 298 |
1377774 | 1377774 | 2021-06-01 | Starr | Texas | 48427 | 9472 | 298 |
1374528 | 1374528 | 2021-05-31 | Starr | Texas | 48427 | 9472 | 298 |
1371283 | 1371283 | 2021-05-30 | Starr | Texas | 48427 | 9472 | 298 |
1368037 | 1368037 | 2021-05-29 | Starr | Texas | 48427 | 9470 | 298 |
1364791 | 1364791 | 2021-05-28 | Starr | Texas | 48427 | 9464 | 298 |
1361545 | 1361545 | 2021-05-27 | Starr | Texas | 48427 | 9469 | 298 |
1358299 | 1358299 | 2021-05-26 | Starr | Texas | 48427 | 9469 | 298 |
1355053 | 1355053 | 2021-05-25 | Starr | Texas | 48427 | 9464 | 298 |
1351807 | 1351807 | 2021-05-24 | Starr | Texas | 48427 | 9460 | 298 |
1348561 | 1348561 | 2021-05-23 | Starr | Texas | 48427 | 9460 | 298 |
1345313 | 1345313 | 2021-05-22 | Starr | Texas | 48427 | 9456 | 298 |
1309574 | 1309574 | 2021-05-11 | Randall | Texas | 48381 | 16777 | 298 |
1306328 | 1306328 | 2021-05-10 | Randall | Texas | 48381 | 16762 | 298 |
1303082 | 1303082 | 2021-05-09 | Randall | Texas | 48381 | 16752 | 298 |
1299835 | 1299835 | 2021-05-08 | Randall | Texas | 48381 | 16752 | 298 |
1296588 | 1296588 | 2021-05-07 | Randall | Texas | 48381 | 16752 | 298 |
1293342 | 1293342 | 2021-05-06 | Randall | Texas | 48381 | 16747 | 298 |
1114598 | 1114598 | 2021-03-12 | Comal | Texas | 48091 | 9398 | 298 |
1111352 | 1111352 | 2021-03-11 | Comal | Texas | 48091 | 9359 | 298 |
1108106 | 1108106 | 2021-03-10 | Comal | Texas | 48091 | 9348 | 298 |
1104860 | 1104860 | 2021-03-09 | Comal | Texas | 48091 | 9326 | 298 |
1001035 | 1001035 | 2021-02-05 | Galveston | Texas | 48167 | 31758 | 298 |
997773 | 997773 | 2021-02-04 | Ector | Texas | 48135 | 14098 | 298 |
994527 | 994527 | 2021-02-03 | Ector | Texas | 48135 | 13889 | 298 |
933006 | 933006 | 2021-01-15 | Smith | Texas | 48423 | 15407 | 298 |
877811 | 877811 | 2020-12-29 | Potter | Texas | 48375 | 15037 | 298 |
822493 | 822493 | 2020-12-12 | Collin | Texas | 48085 | 34709 | 298 |
417721 | 417721 | 2020-08-09 | Travis | Texas | 48453 | 22724 | 298 |
414500 | 414500 | 2020-08-08 | Travis | Texas | 48453 | 22602 | 298 |
362842 | 362842 | 2020-07-23 | Bexar | Texas | 48029 | 34645 | 298 |
350226 | 350226 | 2020-07-19 | Tarrant | Texas | 48439 | 21617 | 298 |
248967 | 248967 | 2020-06-17 | Harris | Texas | 48201 | 18157 | 298 |
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);