ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where deaths = 491 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2372154 | 2372154 | 2022-04-03 | Randall | Texas | 48381 | 38126 | 491 |
2368901 | 2368901 | 2022-04-02 | Randall | Texas | 48381 | 38126 | 491 |
2365648 | 2365648 | 2022-04-01 | Randall | Texas | 48381 | 38126 | 491 |
2362395 | 2362395 | 2022-03-31 | Randall | Texas | 48381 | 38124 | 491 |
2313570 | 2313570 | 2022-03-16 | Midland | Texas | 48329 | 38620 | 491 |
2310317 | 2310317 | 2022-03-15 | Midland | Texas | 48329 | 38411 | 491 |
2307064 | 2307064 | 2022-03-14 | Midland | Texas | 48329 | 38217 | 491 |
2303813 | 2303813 | 2022-03-13 | Midland | Texas | 48329 | 38217 | 491 |
2300561 | 2300561 | 2022-03-12 | Midland | Texas | 48329 | 38217 | 491 |
2297309 | 2297309 | 2022-03-11 | Midland | Texas | 48329 | 38042 | 491 |
2294057 | 2294057 | 2022-03-10 | Midland | Texas | 48329 | 37790 | 491 |
2280989 | 2280989 | 2022-03-06 | Hays | Texas | 48209 | 59631 | 491 |
2277736 | 2277736 | 2022-03-05 | Hays | Texas | 48209 | 59631 | 491 |
2274483 | 2274483 | 2022-03-04 | Hays | Texas | 48209 | 59631 | 491 |
2147585 | 2147585 | 2022-01-24 | Comal | Texas | 48091 | 28591 | 491 |
2144331 | 2144331 | 2022-01-23 | Comal | Texas | 48091 | 28329 | 491 |
2141076 | 2141076 | 2022-01-22 | Comal | Texas | 48091 | 27964 | 491 |
2076059 | 2076059 | 2022-01-02 | Ellis | Texas | 48139 | 35546 | 491 |
2072808 | 2072808 | 2022-01-01 | Ellis | Texas | 48139 | 35546 | 491 |
2069557 | 2069557 | 2021-12-31 | Ellis | Texas | 48139 | 35546 | 491 |
2066306 | 2066306 | 2021-12-30 | Ellis | Texas | 48139 | 35546 | 491 |
2063056 | 2063056 | 2021-12-29 | Ellis | Texas | 48139 | 35408 | 491 |
1868067 | 1868067 | 2021-10-30 | Grayson | Texas | 48181 | 16228 | 491 |
1864818 | 1864818 | 2021-10-29 | Grayson | Texas | 48181 | 16228 | 491 |
1861569 | 1861569 | 2021-10-28 | Grayson | Texas | 48181 | 16190 | 491 |
1786840 | 1786840 | 2021-10-05 | Gregg | Texas | 48183 | 18783 | 491 |
1773971 | 1773971 | 2021-10-01 | Taylor | Texas | 48441 | 21722 | 491 |
1770721 | 1770721 | 2021-09-30 | Taylor | Texas | 48441 | 21653 | 491 |
1669978 | 1669978 | 2021-08-30 | Potter | Texas | 48375 | 20306 | 491 |
1640640 | 1640640 | 2021-08-21 | Galveston | Texas | 48167 | 51237 | 491 |
1582243 | 1582243 | 2021-08-03 | McLennan | Texas | 48309 | 29062 | 491 |
1578994 | 1578994 | 2021-08-02 | McLennan | Texas | 48309 | 28443 | 491 |
1575746 | 1575746 | 2021-08-01 | McLennan | Texas | 48309 | 28443 | 491 |
1572498 | 1572498 | 2021-07-31 | McLennan | Texas | 48309 | 28443 | 491 |
1569250 | 1569250 | 2021-07-30 | McLennan | Texas | 48309 | 28443 | 491 |
1562839 | 1562839 | 2021-07-28 | Williamson | Texas | 48491 | 50219 | 491 |
1536827 | 1536827 | 2021-07-20 | Smith | Texas | 48423 | 21115 | 491 |
1533579 | 1533579 | 2021-07-19 | Smith | Texas | 48423 | 21115 | 491 |
1530332 | 1530332 | 2021-07-18 | Smith | Texas | 48423 | 21020 | 491 |
871373 | 871373 | 2020-12-27 | Webb | Texas | 48479 | 25875 | 491 |
546815 | 546815 | 2020-09-18 | El Paso | Texas | 48141 | 22179 | 491 |
337315 | 337315 | 2020-07-15 | Harris | Texas | 48201 | 50370 | 491 |
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);