ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
109 rows where deaths = 195 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Brown 13
- Navarro 12
- Medina 10
- Bowie 6
- Hale 5
- Harrison 5
- Atascosa 4
- Denton 4
- Jefferson 4
- Anderson 3
- Bastrop 3
- Galveston 3
- Lamar 3
- Orange 3
- Parker 3
- Rockwall 3
- Guadalupe 2
- San Patricio 2
- Val Verde 2
- Wharton 2
- Bexar 1
- Brazoria 1
- Brazos 1
- Cass 1
- Hays 1
- Henderson 1
- Hunt 1
- Jim Wells 1
- Kaufman 1
- Lubbock 1
- …
state 1
- Texas · 109 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2358984 | 2358984 | 2022-03-30 | Cass | Texas | 48067 | 7202 | 195 |
2320075 | 2320075 | 2022-03-18 | Medina | Texas | 48325 | 10147 | 195 |
2316821 | 2316821 | 2022-03-17 | Medina | Texas | 48325 | 10133 | 195 |
2313568 | 2313568 | 2022-03-16 | Medina | Texas | 48325 | 10119 | 195 |
2310315 | 2310315 | 2022-03-15 | Medina | Texas | 48325 | 10107 | 195 |
2307062 | 2307062 | 2022-03-14 | Medina | Texas | 48325 | 10087 | 195 |
2303811 | 2303811 | 2022-03-13 | Medina | Texas | 48325 | 10086 | 195 |
2300559 | 2300559 | 2022-03-12 | Medina | Texas | 48325 | 10086 | 195 |
2297307 | 2297307 | 2022-03-11 | Medina | Texas | 48325 | 10077 | 195 |
2294055 | 2294055 | 2022-03-10 | Medina | Texas | 48325 | 10058 | 195 |
2290803 | 2290803 | 2022-03-09 | Medina | Texas | 48325 | 10038 | 195 |
2222483 | 2222483 | 2022-02-16 | Jim Wells | Texas | 48249 | 10879 | 195 |
2160794 | 2160794 | 2022-01-28 | Wharton | Texas | 48481 | 7934 | 195 |
2157538 | 2157538 | 2022-01-27 | Wharton | Texas | 48481 | 7876 | 195 |
2134531 | 2134531 | 2022-01-20 | Bastrop | Texas | 48021 | 19282 | 195 |
2131279 | 2131279 | 2022-01-19 | Bastrop | Texas | 48021 | 19060 | 195 |
2128025 | 2128025 | 2022-01-18 | Bastrop | Texas | 48021 | 18873 | 195 |
2128116 | 2128116 | 2022-01-18 | Harrison | Texas | 48203 | 11209 | 195 |
2124864 | 2124864 | 2022-01-17 | Harrison | Texas | 48203 | 11124 | 195 |
2121612 | 2121612 | 2022-01-16 | Harrison | Texas | 48203 | 11061 | 195 |
2118360 | 2118360 | 2022-01-15 | Harrison | Texas | 48203 | 11025 | 195 |
2115109 | 2115109 | 2022-01-14 | Harrison | Texas | 48203 | 10929 | 195 |
2092421 | 2092421 | 2022-01-07 | Navarro | Texas | 48349 | 9630 | 195 |
2089169 | 2089169 | 2022-01-06 | Navarro | Texas | 48349 | 9598 | 195 |
2085918 | 2085918 | 2022-01-05 | Navarro | Texas | 48349 | 9549 | 195 |
2082666 | 2082666 | 2022-01-04 | Navarro | Texas | 48349 | 9537 | 195 |
2079414 | 2079414 | 2022-01-03 | Navarro | Texas | 48349 | 9408 | 195 |
2076163 | 2076163 | 2022-01-02 | Navarro | Texas | 48349 | 9247 | 195 |
2072912 | 2072912 | 2022-01-01 | Navarro | Texas | 48349 | 9247 | 195 |
2069661 | 2069661 | 2021-12-31 | Navarro | Texas | 48349 | 9247 | 195 |
2066410 | 2066410 | 2021-12-30 | Navarro | Texas | 48349 | 9247 | 195 |
2063010 | 2063010 | 2021-12-29 | Brown | Texas | 48049 | 7389 | 195 |
2063160 | 2063160 | 2021-12-29 | Navarro | Texas | 48349 | 9235 | 195 |
2059760 | 2059760 | 2021-12-28 | Brown | Texas | 48049 | 7357 | 195 |
2059910 | 2059910 | 2021-12-28 | Navarro | Texas | 48349 | 9190 | 195 |
2056511 | 2056511 | 2021-12-27 | Brown | Texas | 48049 | 7352 | 195 |
2056661 | 2056661 | 2021-12-27 | Navarro | Texas | 48349 | 9170 | 195 |
2053262 | 2053262 | 2021-12-26 | Brown | Texas | 48049 | 7336 | 195 |
2050012 | 2050012 | 2021-12-25 | Brown | Texas | 48049 | 7336 | 195 |
2046762 | 2046762 | 2021-12-24 | Brown | Texas | 48049 | 7336 | 195 |
2043512 | 2043512 | 2021-12-23 | Brown | Texas | 48049 | 7336 | 195 |
2040263 | 2040263 | 2021-12-22 | Brown | Texas | 48049 | 7324 | 195 |
2037013 | 2037013 | 2021-12-21 | Brown | Texas | 48049 | 7304 | 195 |
2033763 | 2033763 | 2021-12-20 | Brown | Texas | 48049 | 7304 | 195 |
2030513 | 2030513 | 2021-12-19 | Brown | Texas | 48049 | 7304 | 195 |
2027262 | 2027262 | 2021-12-18 | Brown | Texas | 48049 | 7304 | 195 |
2024011 | 2024011 | 2021-12-17 | Brown | Texas | 48049 | 7304 | 195 |
1962320 | 1962320 | 2021-11-28 | Hale | Texas | 48189 | 8119 | 195 |
1959069 | 1959069 | 2021-11-27 | Hale | Texas | 48189 | 8119 | 195 |
1955818 | 1955818 | 2021-11-26 | Hale | Texas | 48189 | 8119 | 195 |
1952567 | 1952567 | 2021-11-25 | Hale | Texas | 48189 | 8119 | 195 |
1949316 | 1949316 | 2021-11-24 | Hale | Texas | 48189 | 8119 | 195 |
1832235 | 1832235 | 2021-10-19 | Anderson | Texas | 48001 | 7967 | 195 |
1828986 | 1828986 | 2021-10-18 | Anderson | Texas | 48001 | 7947 | 195 |
1825737 | 1825737 | 2021-10-17 | Anderson | Texas | 48001 | 7947 | 195 |
1825923 | 1825923 | 2021-10-17 | Polk | Texas | 48373 | 5885 | 195 |
1809726 | 1809726 | 2021-10-12 | Van Zandt | Texas | 48467 | 7814 | 195 |
1806249 | 1806249 | 2021-10-11 | Atascosa | Texas | 48013 | 8404 | 195 |
1806382 | 1806382 | 2021-10-11 | Lamar | Texas | 48277 | 8595 | 195 |
1802999 | 1802999 | 2021-10-10 | Atascosa | Texas | 48013 | 8404 | 195 |
1803132 | 1803132 | 2021-10-10 | Lamar | Texas | 48277 | 8595 | 195 |
1799750 | 1799750 | 2021-10-09 | Atascosa | Texas | 48013 | 8404 | 195 |
1799883 | 1799883 | 2021-10-09 | Lamar | Texas | 48277 | 8595 | 195 |
1796501 | 1796501 | 2021-10-08 | Atascosa | Texas | 48013 | 8404 | 195 |
1760952 | 1760952 | 2021-09-27 | Rockwall | Texas | 48397 | 16439 | 195 |
1757704 | 1757704 | 2021-09-26 | Rockwall | Texas | 48397 | 16439 | 195 |
1754456 | 1754456 | 2021-09-25 | Rockwall | Texas | 48397 | 16439 | 195 |
1741435 | 1741435 | 2021-09-21 | Nacogdoches | Texas | 48347 | 7158 | 195 |
1718697 | 1718697 | 2021-09-14 | Orange | Texas | 48361 | 12671 | 195 |
1715449 | 1715449 | 2021-09-13 | Orange | Texas | 48361 | 12608 | 195 |
1712203 | 1712203 | 2021-09-12 | Orange | Texas | 48361 | 12608 | 195 |
1692738 | 1692738 | 2021-09-06 | San Patricio | Texas | 48409 | 5834 | 195 |
1689489 | 1689489 | 2021-09-05 | San Patricio | Texas | 48409 | 5834 | 195 |
1660163 | 1660163 | 2021-08-27 | Hunt | Texas | 48231 | 7898 | 195 |
1566025 | 1566025 | 2021-07-29 | Parker | Texas | 48367 | 16996 | 195 |
1562777 | 1562777 | 2021-07-28 | Parker | Texas | 48367 | 16902 | 195 |
1559529 | 1559529 | 2021-07-27 | Parker | Texas | 48367 | 16875 | 195 |
1501005 | 1501005 | 2021-07-09 | Henderson | Texas | 48213 | 6101 | 195 |
1134052 | 1134052 | 2021-03-18 | Bowie | Texas | 48037 | 6740 | 195 |
1130804 | 1130804 | 2021-03-17 | Bowie | Texas | 48037 | 6735 | 195 |
1127557 | 1127557 | 2021-03-16 | Bowie | Texas | 48037 | 6732 | 195 |
1124311 | 1124311 | 2021-03-15 | Bowie | Texas | 48037 | 6715 | 195 |
1121065 | 1121065 | 2021-03-14 | Bowie | Texas | 48037 | 6711 | 195 |
1117818 | 1117818 | 2021-03-13 | Bowie | Texas | 48037 | 6703 | 195 |
1101662 | 1101662 | 2021-03-08 | Guadalupe | Texas | 48187 | 13482 | 195 |
1098416 | 1098416 | 2021-03-07 | Guadalupe | Texas | 48187 | 13480 | 195 |
1079078 | 1079078 | 2021-03-01 | Val Verde | Texas | 48465 | 7668 | 195 |
1075833 | 1075833 | 2021-02-28 | Val Verde | Texas | 48465 | 7668 | 195 |
1014063 | 1014063 | 2021-02-09 | Kaufman | Texas | 48257 | 13875 | 195 |
1004218 | 1004218 | 2021-02-06 | Brazos | Texas | 48041 | 19403 | 195 |
997810 | 997810 | 2021-02-04 | Hays | Texas | 48209 | 17019 | 195 |
897288 | 897288 | 2021-01-04 | Randall | Texas | 48381 | 14123 | 195 |
871376 | 871376 | 2020-12-27 | Wichita | Texas | 48485 | 9852 | 195 |
851909 | 851909 | 2020-12-21 | Williamson | Texas | 48491 | 19948 | 195 |
829027 | 829027 | 2020-12-14 | Galveston | Texas | 48167 | 17362 | 195 |
825781 | 825781 | 2020-12-13 | Galveston | Texas | 48167 | 17362 | 195 |
825820 | 825820 | 2020-12-13 | Jefferson | Texas | 48245 | 11689 | 195 |
822534 | 822534 | 2020-12-12 | Galveston | Texas | 48167 | 17131 | 195 |
822573 | 822573 | 2020-12-12 | Jefferson | Texas | 48245 | 11689 | 195 |
819327 | 819327 | 2020-12-11 | Jefferson | Texas | 48245 | 11553 | 195 |
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);