ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where deaths = 202 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2277756 | 2277756 | 2022-03-05 | Jim Wells | Texas | 48249 | 11075 | 202 |
2274503 | 2274503 | 2022-03-04 | Jim Wells | Texas | 48249 | 11069 | 202 |
2248607 | 2248607 | 2022-02-24 | Wharton | Texas | 48481 | 8607 | 202 |
2245356 | 2245356 | 2022-02-23 | Wharton | Texas | 48481 | 8581 | 202 |
2242105 | 2242105 | 2022-02-22 | Wharton | Texas | 48481 | 8572 | 202 |
2238854 | 2238854 | 2022-02-21 | Wharton | Texas | 48481 | 8565 | 202 |
2235603 | 2235603 | 2022-02-20 | Wharton | Texas | 48481 | 8557 | 202 |
2232352 | 2232352 | 2022-02-19 | Wharton | Texas | 48481 | 8556 | 202 |
2229101 | 2229101 | 2022-02-18 | Wharton | Texas | 48481 | 8462 | 202 |
2225850 | 2225850 | 2022-02-17 | Wharton | Texas | 48481 | 8455 | 202 |
2222594 | 2222594 | 2022-02-16 | Walker | Texas | 48471 | 18025 | 202 |
2222599 | 2222599 | 2022-02-16 | Wharton | Texas | 48481 | 8448 | 202 |
2219343 | 2219343 | 2022-02-15 | Walker | Texas | 48471 | 17983 | 202 |
2219348 | 2219348 | 2022-02-15 | Wharton | Texas | 48481 | 8438 | 202 |
2216092 | 2216092 | 2022-02-14 | Walker | Texas | 48471 | 17971 | 202 |
2186778 | 2186778 | 2022-02-05 | Rusk | Texas | 48401 | 10216 | 202 |
2183526 | 2183526 | 2022-02-04 | Rusk | Texas | 48401 | 10192 | 202 |
2176833 | 2176833 | 2022-02-02 | Bastrop | Texas | 48021 | 20769 | 202 |
2167237 | 2167237 | 2022-01-30 | Navarro | Texas | 48349 | 11616 | 202 |
1926469 | 1926469 | 2021-11-17 | Anderson | Texas | 48001 | 8262 | 202 |
1897470 | 1897470 | 2021-11-08 | Wise | Texas | 48497 | 11436 | 202 |
1894220 | 1894220 | 2021-11-07 | Wise | Texas | 48497 | 11436 | 202 |
1890832 | 1890832 | 2021-11-06 | Hood | Texas | 48221 | 9768 | 202 |
1890970 | 1890970 | 2021-11-06 | Wise | Texas | 48497 | 11436 | 202 |
1887582 | 1887582 | 2021-11-05 | Hood | Texas | 48221 | 9762 | 202 |
1884332 | 1884332 | 2021-11-04 | Hood | Texas | 48221 | 9758 | 202 |
1854987 | 1854987 | 2021-10-26 | Atascosa | Texas | 48013 | 8533 | 202 |
1851738 | 1851738 | 2021-10-25 | Atascosa | Texas | 48013 | 8528 | 202 |
1848488 | 1848488 | 2021-10-24 | Atascosa | Texas | 48013 | 8521 | 202 |
1845238 | 1845238 | 2021-10-23 | Atascosa | Texas | 48013 | 8521 | 202 |
1841988 | 1841988 | 2021-10-22 | Atascosa | Texas | 48013 | 8521 | 202 |
1838872 | 1838872 | 2021-10-21 | Lamar | Texas | 48277 | 8779 | 202 |
1822587 | 1822587 | 2021-10-16 | Hardin | Texas | 48199 | 10288 | 202 |
1822721 | 1822721 | 2021-10-16 | Van Zandt | Texas | 48467 | 7857 | 202 |
1796531 | 1796531 | 2021-10-08 | Cherokee | Texas | 48073 | 6711 | 202 |
1773949 | 1773949 | 2021-10-01 | Rockwall | Texas | 48397 | 16768 | 202 |
1754431 | 1754431 | 2021-09-25 | Nacogdoches | Texas | 48347 | 7301 | 202 |
1725194 | 1725194 | 2021-09-16 | Orange | Texas | 48361 | 12839 | 202 |
1699234 | 1699234 | 2021-09-08 | San Patricio | Texas | 48409 | 5983 | 202 |
1679649 | 1679649 | 2021-09-02 | Hunt | Texas | 48231 | 8403 | 202 |
1591938 | 1591938 | 2021-08-06 | Henderson | Texas | 48213 | 6564 | 202 |
1588689 | 1588689 | 2021-08-05 | Henderson | Texas | 48213 | 6462 | 202 |
1510783 | 1510783 | 2021-07-12 | Liberty | Texas | 48291 | 8251 | 202 |
1507536 | 1507536 | 2021-07-11 | Liberty | Texas | 48291 | 8246 | 202 |
1504290 | 1504290 | 2021-07-10 | Liberty | Texas | 48291 | 8238 | 202 |
1501044 | 1501044 | 2021-07-09 | Liberty | Texas | 48291 | 8237 | 202 |
1497798 | 1497798 | 2021-07-08 | Liberty | Texas | 48291 | 8233 | 202 |
1173018 | 1173018 | 2021-03-30 | Bowie | Texas | 48037 | 6812 | 202 |
1169771 | 1169771 | 2021-03-29 | Bowie | Texas | 48037 | 6811 | 202 |
1166523 | 1166523 | 2021-03-28 | Bowie | Texas | 48037 | 6800 | 202 |
1127771 | 1127771 | 2021-03-16 | Val Verde | Texas | 48465 | 7763 | 202 |
1052986 | 1052986 | 2021-02-21 | Hays | Texas | 48209 | 17598 | 202 |
1049739 | 1049739 | 2021-02-20 | Hays | Texas | 48209 | 17598 | 202 |
1046408 | 1046408 | 2021-02-19 | Brazos | Texas | 48041 | 20054 | 202 |
1046492 | 1046492 | 2021-02-19 | Hays | Texas | 48209 | 17598 | 202 |
1043163 | 1043163 | 2021-02-18 | Brazos | Texas | 48041 | 20054 | 202 |
1043247 | 1043247 | 2021-02-18 | Hays | Texas | 48209 | 17598 | 202 |
1039918 | 1039918 | 2021-02-17 | Brazos | Texas | 48041 | 20054 | 202 |
1040002 | 1040002 | 2021-02-17 | Hays | Texas | 48209 | 17598 | 202 |
1036673 | 1036673 | 2021-02-16 | Brazos | Texas | 48041 | 20054 | 202 |
1036757 | 1036757 | 2021-02-16 | Hays | Texas | 48209 | 17598 | 202 |
1033428 | 1033428 | 2021-02-15 | Brazos | Texas | 48041 | 20054 | 202 |
1033512 | 1033512 | 2021-02-15 | Hays | Texas | 48209 | 17598 | 202 |
1030182 | 1030182 | 2021-02-14 | Brazos | Texas | 48041 | 20054 | 202 |
1030266 | 1030266 | 2021-02-14 | Hays | Texas | 48209 | 17598 | 202 |
1026935 | 1026935 | 2021-02-13 | Brazos | Texas | 48041 | 20054 | 202 |
1027019 | 1027019 | 2021-02-13 | Hays | Texas | 48209 | 17598 | 202 |
1023774 | 1023774 | 2021-02-12 | Hays | Texas | 48209 | 17617 | 202 |
1023798 | 1023798 | 2021-02-12 | Kaufman | Texas | 48257 | 14129 | 202 |
1020529 | 1020529 | 2021-02-11 | Hays | Texas | 48209 | 17617 | 202 |
945941 | 945941 | 2021-01-19 | Midland | Texas | 48329 | 13334 | 202 |
942694 | 942694 | 2021-01-18 | Midland | Texas | 48329 | 13334 | 202 |
939449 | 939449 | 2021-01-17 | Midland | Texas | 48329 | 13334 | 202 |
936204 | 936204 | 2021-01-16 | Midland | Texas | 48329 | 13334 | 202 |
932959 | 932959 | 2021-01-15 | Midland | Texas | 48329 | 13334 | 202 |
929714 | 929714 | 2021-01-14 | Midland | Texas | 48329 | 13334 | 202 |
910237 | 910237 | 2021-01-08 | Maverick | Texas | 48323 | 7036 | 202 |
900533 | 900533 | 2021-01-05 | Randall | Texas | 48381 | 14299 | 202 |
894072 | 894072 | 2021-01-03 | Taylor | Texas | 48441 | 11229 | 202 |
877866 | 877866 | 2020-12-29 | Wichita | Texas | 48485 | 10592 | 202 |
874624 | 874624 | 2020-12-28 | Williamson | Texas | 48491 | 21710 | 202 |
786773 | 786773 | 2020-12-01 | Brazoria | Texas | 48039 | 14574 | 202 |
760854 | 760854 | 2020-11-23 | Denton | Texas | 48121 | 21937 | 202 |
757609 | 757609 | 2020-11-22 | Denton | Texas | 48121 | 21453 | 202 |
754470 | 754470 | 2020-11-21 | Montgomery | Texas | 48339 | 15920 | 202 |
751224 | 751224 | 2020-11-20 | Montgomery | Texas | 48339 | 15920 | 202 |
679834 | 679834 | 2020-10-29 | Lubbock | Texas | 48303 | 18985 | 202 |
443531 | 443531 | 2020-08-17 | Webb | Texas | 48479 | 9646 | 202 |
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);