ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where deaths = 255 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2453491 | 2453491 | 2022-04-28 | Lamar | Texas | 48277 | 12488 | 255 |
2450235 | 2450235 | 2022-04-27 | Lamar | Texas | 48277 | 12488 | 255 |
2446978 | 2446978 | 2022-04-26 | Lamar | Texas | 48277 | 12487 | 255 |
2443723 | 2443723 | 2022-04-25 | Lamar | Texas | 48277 | 12486 | 255 |
2440467 | 2440467 | 2022-04-24 | Lamar | Texas | 48277 | 12486 | 255 |
2437211 | 2437211 | 2022-04-23 | Lamar | Texas | 48277 | 12486 | 255 |
2433955 | 2433955 | 2022-04-22 | Lamar | Texas | 48277 | 12486 | 255 |
2430699 | 2430699 | 2022-04-21 | Lamar | Texas | 48277 | 12486 | 255 |
2427443 | 2427443 | 2022-04-20 | Lamar | Texas | 48277 | 12485 | 255 |
2424187 | 2424187 | 2022-04-19 | Lamar | Texas | 48277 | 12485 | 255 |
2420931 | 2420931 | 2022-04-18 | Lamar | Texas | 48277 | 12484 | 255 |
2381864 | 2381864 | 2022-04-06 | Lamar | Texas | 48277 | 12483 | 255 |
2378609 | 2378609 | 2022-04-05 | Lamar | Texas | 48277 | 12483 | 255 |
2375355 | 2375355 | 2022-04-04 | Lamar | Texas | 48277 | 12478 | 255 |
2372103 | 2372103 | 2022-04-03 | Lamar | Texas | 48277 | 12478 | 255 |
2368850 | 2368850 | 2022-04-02 | Lamar | Texas | 48277 | 12478 | 255 |
2365597 | 2365597 | 2022-04-01 | Lamar | Texas | 48277 | 12478 | 255 |
2316832 | 2316832 | 2022-03-17 | Nacogdoches | Texas | 48347 | 12188 | 255 |
2313579 | 2313579 | 2022-03-16 | Nacogdoches | Texas | 48347 | 12180 | 255 |
2310326 | 2310326 | 2022-03-15 | Nacogdoches | Texas | 48347 | 12157 | 255 |
2307073 | 2307073 | 2022-03-14 | Nacogdoches | Texas | 48347 | 12141 | 255 |
2303822 | 2303822 | 2022-03-13 | Nacogdoches | Texas | 48347 | 12141 | 255 |
2300570 | 2300570 | 2022-03-12 | Nacogdoches | Texas | 48347 | 12140 | 255 |
2297318 | 2297318 | 2022-03-11 | Nacogdoches | Texas | 48347 | 12116 | 255 |
2294066 | 2294066 | 2022-03-10 | Nacogdoches | Texas | 48347 | 12110 | 255 |
2290814 | 2290814 | 2022-03-09 | Nacogdoches | Texas | 48347 | 12099 | 255 |
2287562 | 2287562 | 2022-03-08 | Nacogdoches | Texas | 48347 | 12031 | 255 |
2284310 | 2284310 | 2022-03-07 | Nacogdoches | Texas | 48347 | 12012 | 255 |
2281058 | 2281058 | 2022-03-06 | Nacogdoches | Texas | 48347 | 12010 | 255 |
2277805 | 2277805 | 2022-03-05 | Nacogdoches | Texas | 48347 | 12010 | 255 |
2274552 | 2274552 | 2022-03-04 | Nacogdoches | Texas | 48347 | 12005 | 255 |
2271299 | 2271299 | 2022-03-03 | Nacogdoches | Texas | 48347 | 11981 | 255 |
2268047 | 2268047 | 2022-03-02 | Nacogdoches | Texas | 48347 | 11963 | 255 |
2264794 | 2264794 | 2022-03-01 | Nacogdoches | Texas | 48347 | 11932 | 255 |
2261619 | 2261619 | 2022-02-28 | Wise | Texas | 48497 | 16735 | 255 |
2258368 | 2258368 | 2022-02-27 | Wise | Texas | 48497 | 16734 | 255 |
2238724 | 2238724 | 2022-02-21 | Hood | Texas | 48221 | 13196 | 255 |
2235473 | 2235473 | 2022-02-20 | Hood | Texas | 48221 | 13185 | 255 |
2160803 | 2160803 | 2022-01-28 | Wood | Texas | 48499 | 7482 | 255 |
1998213 | 1998213 | 2021-12-09 | Val Verde | Texas | 48465 | 10715 | 255 |
1994962 | 1994962 | 2021-12-08 | Val Verde | Texas | 48465 | 10715 | 255 |
1991711 | 1991711 | 2021-12-07 | Val Verde | Texas | 48465 | 10715 | 255 |
1988460 | 1988460 | 2021-12-06 | Val Verde | Texas | 48465 | 10714 | 255 |
1985210 | 1985210 | 2021-12-05 | Val Verde | Texas | 48465 | 10714 | 255 |
1981960 | 1981960 | 2021-12-04 | Val Verde | Texas | 48465 | 10712 | 255 |
1978710 | 1978710 | 2021-12-03 | Val Verde | Texas | 48465 | 10712 | 255 |
1975460 | 1975460 | 2021-12-02 | Val Verde | Texas | 48465 | 10711 | 255 |
1972211 | 1972211 | 2021-12-01 | Val Verde | Texas | 48465 | 10711 | 255 |
1968961 | 1968961 | 2021-11-30 | Val Verde | Texas | 48465 | 10711 | 255 |
1965710 | 1965710 | 2021-11-29 | Val Verde | Texas | 48465 | 10711 | 255 |
1962458 | 1962458 | 2021-11-28 | Val Verde | Texas | 48465 | 10650 | 255 |
1959207 | 1959207 | 2021-11-27 | Val Verde | Texas | 48465 | 10650 | 255 |
1955956 | 1955956 | 2021-11-26 | Val Verde | Texas | 48465 | 10650 | 255 |
1952705 | 1952705 | 2021-11-25 | Val Verde | Texas | 48465 | 10650 | 255 |
1949454 | 1949454 | 2021-11-24 | Val Verde | Texas | 48465 | 10650 | 255 |
1773955 | 1773955 | 2021-10-01 | San Patricio | Texas | 48409 | 6757 | 255 |
1770616 | 1770616 | 2021-09-30 | Hunt | Texas | 48231 | 10267 | 255 |
1682877 | 1682877 | 2021-09-03 | Guadalupe | Texas | 48187 | 20377 | 255 |
1679627 | 1679627 | 2021-09-02 | Guadalupe | Texas | 48187 | 20220 | 255 |
1663530 | 1663530 | 2021-08-28 | Victoria | Texas | 48469 | 11400 | 255 |
1660282 | 1660282 | 2021-08-27 | Victoria | Texas | 48469 | 11324 | 255 |
1419855 | 1419855 | 2021-06-14 | Hays | Texas | 48209 | 21054 | 255 |
1406790 | 1406790 | 2021-06-10 | Brazos | Texas | 48041 | 27773 | 255 |
1267307 | 1267307 | 2021-04-28 | Kaufman | Texas | 48257 | 15859 | 255 |
1264060 | 1264060 | 2021-04-27 | Kaufman | Texas | 48257 | 15807 | 255 |
1260813 | 1260813 | 2021-04-26 | Kaufman | Texas | 48257 | 15771 | 255 |
1257566 | 1257566 | 2021-04-25 | Kaufman | Texas | 48257 | 15771 | 255 |
1254319 | 1254319 | 2021-04-24 | Kaufman | Texas | 48257 | 15771 | 255 |
1251072 | 1251072 | 2021-04-23 | Kaufman | Texas | 48257 | 15768 | 255 |
1247825 | 1247825 | 2021-04-22 | Kaufman | Texas | 48257 | 15759 | 255 |
1085563 | 1085563 | 2021-03-03 | Tom Green | Texas | 48451 | 16379 | 255 |
991259 | 991259 | 2021-02-02 | Comal | Texas | 48091 | 8216 | 255 |
988013 | 988013 | 2021-02-01 | Comal | Texas | 48091 | 8130 | 255 |
988059 | 988059 | 2021-02-01 | Gregg | Texas | 48183 | 9839 | 255 |
984766 | 984766 | 2021-01-31 | Comal | Texas | 48091 | 8130 | 255 |
984812 | 984812 | 2021-01-31 | Gregg | Texas | 48183 | 9724 | 255 |
981519 | 981519 | 2021-01-30 | Comal | Texas | 48091 | 8130 | 255 |
981565 | 981565 | 2021-01-30 | Gregg | Texas | 48183 | 9724 | 255 |
933037 | 933037 | 2021-01-15 | Wichita | Texas | 48485 | 13179 | 255 |
929672 | 929672 | 2021-01-14 | Jefferson | Texas | 48245 | 15642 | 255 |
929795 | 929795 | 2021-01-14 | Williamson | Texas | 48491 | 29098 | 255 |
919833 | 919833 | 2021-01-11 | Brazoria | Texas | 48039 | 23990 | 255 |
916588 | 916588 | 2021-01-10 | Brazoria | Texas | 48039 | 23746 | 255 |
871303 | 871303 | 2020-12-27 | Montgomery | Texas | 48339 | 24366 | 255 |
868058 | 868058 | 2020-12-26 | Montgomery | Texas | 48339 | 24366 | 255 |
864813 | 864813 | 2020-12-25 | Montgomery | Texas | 48339 | 24366 | 255 |
861568 | 861568 | 2020-12-24 | Montgomery | Texas | 48339 | 24366 | 255 |
851824 | 851824 | 2020-12-21 | McLennan | Texas | 48309 | 17467 | 255 |
520934 | 520934 | 2020-09-10 | Fort Bend | Texas | 48157 | 15331 | 255 |
517698 | 517698 | 2020-09-09 | Fort Bend | Texas | 48157 | 15249 | 255 |
511389 | 511389 | 2020-09-07 | Webb | Texas | 48479 | 12131 | 255 |
379106 | 379106 | 2020-07-28 | Travis | Texas | 48453 | 19952 | 255 |
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);