ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where deaths = 252 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2326456 | 2326456 | 2022-03-20 | Cherokee | Texas | 48073 | 7933 | 252 |
2323203 | 2323203 | 2022-03-19 | Cherokee | Texas | 48073 | 7931 | 252 |
2319949 | 2319949 | 2022-03-18 | Cherokee | Texas | 48073 | 7931 | 252 |
2316695 | 2316695 | 2022-03-17 | Cherokee | Texas | 48073 | 7931 | 252 |
2313442 | 2313442 | 2022-03-16 | Cherokee | Texas | 48073 | 7930 | 252 |
2313545 | 2313545 | 2022-03-16 | Lamar | Texas | 48277 | 12461 | 252 |
2248540 | 2248540 | 2022-02-24 | Nacogdoches | Texas | 48347 | 11881 | 252 |
2245289 | 2245289 | 2022-02-23 | Nacogdoches | Texas | 48347 | 11866 | 252 |
2228971 | 2228971 | 2022-02-18 | Hood | Texas | 48221 | 13173 | 252 |
2225720 | 2225720 | 2022-02-17 | Hood | Texas | 48221 | 13166 | 252 |
2222469 | 2222469 | 2022-02-16 | Hood | Texas | 48221 | 13155 | 252 |
2196572 | 2196572 | 2022-02-08 | Van Zandt | Texas | 48467 | 10039 | 252 |
2193318 | 2193318 | 2022-02-07 | Van Zandt | Texas | 48467 | 10029 | 252 |
2190065 | 2190065 | 2022-02-06 | Van Zandt | Texas | 48467 | 10019 | 252 |
2186812 | 2186812 | 2022-02-05 | Van Zandt | Texas | 48467 | 9992 | 252 |
2157547 | 2157547 | 2022-01-27 | Wood | Texas | 48499 | 7436 | 252 |
2154294 | 2154294 | 2022-01-26 | Wood | Texas | 48499 | 7383 | 252 |
2151042 | 2151042 | 2022-01-25 | Wood | Texas | 48499 | 7353 | 252 |
1884454 | 1884454 | 2021-11-04 | Val Verde | Texas | 48465 | 10607 | 252 |
1881205 | 1881205 | 2021-11-03 | Val Verde | Texas | 48465 | 10607 | 252 |
1877956 | 1877956 | 2021-11-02 | Val Verde | Texas | 48465 | 10581 | 252 |
1874707 | 1874707 | 2021-11-01 | Val Verde | Texas | 48465 | 10581 | 252 |
1871458 | 1871458 | 2021-10-31 | Val Verde | Texas | 48465 | 10581 | 252 |
1868209 | 1868209 | 2021-10-30 | Val Verde | Texas | 48465 | 10581 | 252 |
1864960 | 1864960 | 2021-10-29 | Val Verde | Texas | 48465 | 10581 | 252 |
1790177 | 1790177 | 2021-10-06 | Orange | Texas | 48361 | 13472 | 252 |
1650539 | 1650539 | 2021-08-24 | Victoria | Texas | 48469 | 10976 | 252 |
1384156 | 1384156 | 2021-06-03 | Hays | Texas | 48209 | 20973 | 252 |
1380910 | 1380910 | 2021-06-02 | Hays | Texas | 48209 | 20960 | 252 |
1377581 | 1377581 | 2021-06-01 | Brazos | Texas | 48041 | 27605 | 252 |
1374335 | 1374335 | 2021-05-31 | Brazos | Texas | 48041 | 27567 | 252 |
1371090 | 1371090 | 2021-05-30 | Brazos | Texas | 48041 | 27567 | 252 |
1367844 | 1367844 | 2021-05-29 | Brazos | Texas | 48041 | 27567 | 252 |
1364598 | 1364598 | 2021-05-28 | Brazos | Texas | 48041 | 27567 | 252 |
1361352 | 1361352 | 2021-05-27 | Brazos | Texas | 48041 | 27533 | 252 |
1358106 | 1358106 | 2021-05-26 | Brazos | Texas | 48041 | 27512 | 252 |
1354860 | 1354860 | 2021-05-25 | Brazos | Texas | 48041 | 27481 | 252 |
1351614 | 1351614 | 2021-05-24 | Brazos | Texas | 48041 | 27481 | 252 |
1348368 | 1348368 | 2021-05-23 | Brazos | Texas | 48041 | 26828 | 252 |
1345120 | 1345120 | 2021-05-22 | Brazos | Texas | 48041 | 26828 | 252 |
1341872 | 1341872 | 2021-05-21 | Brazos | Texas | 48041 | 26828 | 252 |
1238084 | 1238084 | 2021-04-19 | Kaufman | Texas | 48257 | 15680 | 252 |
1234837 | 1234837 | 2021-04-18 | Kaufman | Texas | 48257 | 15680 | 252 |
1225093 | 1225093 | 2021-04-15 | Kaufman | Texas | 48257 | 15663 | 252 |
1114717 | 1114717 | 2021-03-12 | Midland | Texas | 48329 | 16699 | 252 |
1111471 | 1111471 | 2021-03-11 | Midland | Texas | 48329 | 16699 | 252 |
1108225 | 1108225 | 2021-03-10 | Midland | Texas | 48329 | 16699 | 252 |
1104979 | 1104979 | 2021-03-09 | Midland | Texas | 48329 | 16699 | 252 |
1079071 | 1079071 | 2021-03-01 | Tom Green | Texas | 48451 | 16353 | 252 |
1075826 | 1075826 | 2021-02-28 | Tom Green | Texas | 48451 | 16344 | 252 |
1072580 | 1072580 | 2021-02-27 | Tom Green | Texas | 48451 | 16337 | 252 |
1069111 | 1069111 | 2021-02-26 | Angelina | Texas | 48005 | 7913 | 252 |
1069334 | 1069334 | 2021-02-26 | Tom Green | Texas | 48451 | 16324 | 252 |
1066089 | 1066089 | 2021-02-25 | Tom Green | Texas | 48451 | 16310 | 252 |
1033621 | 1033621 | 2021-02-15 | Starr | Texas | 48427 | 8948 | 252 |
1030375 | 1030375 | 2021-02-14 | Starr | Texas | 48427 | 8948 | 252 |
1027128 | 1027128 | 2021-02-13 | Starr | Texas | 48427 | 8919 | 252 |
1023883 | 1023883 | 2021-02-12 | Starr | Texas | 48427 | 8884 | 252 |
994650 | 994650 | 2021-02-03 | Randall | Texas | 48381 | 15855 | 252 |
991404 | 991404 | 2021-02-02 | Randall | Texas | 48381 | 15807 | 252 |
971828 | 971828 | 2021-01-27 | Grayson | Texas | 48181 | 9524 | 252 |
971829 | 971829 | 2021-01-27 | Gregg | Texas | 48183 | 9409 | 252 |
871345 | 871345 | 2020-12-27 | Smith | Texas | 48423 | 12138 | 252 |
777061 | 777061 | 2020-11-28 | Collin | Texas | 48085 | 25566 | 252 |
508156 | 508156 | 2020-09-06 | Webb | Texas | 48479 | 12094 | 252 |
382169 | 382169 | 2020-07-29 | El Paso | Texas | 48141 | 13807 | 252 |
375890 | 375890 | 2020-07-27 | Travis | Texas | 48453 | 19720 | 252 |
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);