ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
86 rows where deaths = 216 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Bowie 10
- Polk 9
- Van Zandt 8
- Guadalupe 7
- Hood 5
- Navarro 5
- Atascosa 4
- Hardin 4
- Montgomery 4
- Wood 4
- Anderson 2
- Fort Bend 2
- Rockwall 2
- San Patricio 2
- Victoria 2
- Bastrop 1
- Galveston 1
- Gregg 1
- Harris 1
- Hays 1
- Henderson 1
- Kaufman 1
- Liberty 1
- Maverick 1
- Nacogdoches 1
- Parker 1
- Potter 1
- Rusk 1
- Tom Green 1
- Wichita 1
- …
state 1
- Texas · 86 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2264795 | 2264795 | 2022-03-01 | Navarro | Texas | 48349 | 12251 | 216 |
2261545 | 2261545 | 2022-02-28 | Navarro | Texas | 48349 | 12212 | 216 |
2258294 | 2258294 | 2022-02-27 | Navarro | Texas | 48349 | 12209 | 216 |
2255043 | 2255043 | 2022-02-26 | Navarro | Texas | 48349 | 12182 | 216 |
2251792 | 2251792 | 2022-02-25 | Navarro | Texas | 48349 | 12168 | 216 |
2229061 | 2229061 | 2022-02-18 | Rusk | Texas | 48401 | 10427 | 216 |
2219118 | 2219118 | 2022-02-15 | Bastrop | Texas | 48021 | 21420 | 216 |
2170323 | 2170323 | 2022-01-31 | Atascosa | Texas | 48013 | 12468 | 216 |
2167069 | 2167069 | 2022-01-30 | Atascosa | Texas | 48013 | 12433 | 216 |
2163814 | 2163814 | 2022-01-29 | Atascosa | Texas | 48013 | 12357 | 216 |
2160559 | 2160559 | 2022-01-28 | Atascosa | Texas | 48013 | 12196 | 216 |
2134521 | 2134521 | 2022-01-20 | Anderson | Texas | 48001 | 8945 | 216 |
2131269 | 2131269 | 2022-01-19 | Anderson | Texas | 48001 | 8893 | 216 |
2089094 | 2089094 | 2022-01-06 | Hardin | Texas | 48199 | 11015 | 216 |
2085843 | 2085843 | 2022-01-05 | Hardin | Texas | 48199 | 10991 | 216 |
2082591 | 2082591 | 2022-01-04 | Hardin | Texas | 48199 | 10902 | 216 |
2079339 | 2079339 | 2022-01-03 | Hardin | Texas | 48199 | 10863 | 216 |
2079488 | 2079488 | 2022-01-03 | Wise | Texas | 48497 | 12316 | 216 |
2076099 | 2076099 | 2022-01-02 | Hood | Texas | 48221 | 10261 | 216 |
2072848 | 2072848 | 2022-01-01 | Hood | Texas | 48221 | 10261 | 216 |
2069597 | 2069597 | 2021-12-31 | Hood | Texas | 48221 | 10261 | 216 |
2066346 | 2066346 | 2021-12-30 | Hood | Texas | 48221 | 10261 | 216 |
2063096 | 2063096 | 2021-12-29 | Hood | Texas | 48221 | 10235 | 216 |
1972165 | 1972165 | 2021-12-01 | Polk | Texas | 48373 | 5969 | 216 |
1968915 | 1968915 | 2021-11-30 | Polk | Texas | 48373 | 5966 | 216 |
1965664 | 1965664 | 2021-11-29 | Polk | Texas | 48373 | 5966 | 216 |
1962412 | 1962412 | 2021-11-28 | Polk | Texas | 48373 | 5960 | 216 |
1959161 | 1959161 | 2021-11-27 | Polk | Texas | 48373 | 5960 | 216 |
1955910 | 1955910 | 2021-11-26 | Polk | Texas | 48373 | 5960 | 216 |
1952659 | 1952659 | 2021-11-25 | Polk | Texas | 48373 | 5960 | 216 |
1949408 | 1949408 | 2021-11-24 | Polk | Texas | 48373 | 5960 | 216 |
1946157 | 1946157 | 2021-11-23 | Polk | Texas | 48373 | 5960 | 216 |
1907204 | 1907204 | 2021-11-11 | Van Zandt | Texas | 48467 | 8126 | 216 |
1903955 | 1903955 | 2021-11-10 | Van Zandt | Texas | 48467 | 8126 | 216 |
1900705 | 1900705 | 2021-11-09 | Van Zandt | Texas | 48467 | 8126 | 216 |
1897455 | 1897455 | 2021-11-08 | Van Zandt | Texas | 48467 | 8088 | 216 |
1894205 | 1894205 | 2021-11-07 | Van Zandt | Texas | 48467 | 8088 | 216 |
1890955 | 1890955 | 2021-11-06 | Van Zandt | Texas | 48467 | 8088 | 216 |
1887705 | 1887705 | 2021-11-05 | Van Zandt | Texas | 48467 | 8088 | 216 |
1884455 | 1884455 | 2021-11-04 | Van Zandt | Texas | 48467 | 8069 | 216 |
1838931 | 1838931 | 2021-10-21 | Rockwall | Texas | 48397 | 17463 | 216 |
1835682 | 1835682 | 2021-10-20 | Rockwall | Texas | 48397 | 17430 | 216 |
1832484 | 1832484 | 2021-10-19 | Wood | Texas | 48499 | 6417 | 216 |
1829235 | 1829235 | 2021-10-18 | Wood | Texas | 48499 | 6393 | 216 |
1825986 | 1825986 | 2021-10-17 | Wood | Texas | 48499 | 6393 | 216 |
1822737 | 1822737 | 2021-10-16 | Wood | Texas | 48499 | 6393 | 216 |
1809666 | 1809666 | 2021-10-12 | Nacogdoches | Texas | 48347 | 7623 | 216 |
1715473 | 1715473 | 2021-09-13 | San Patricio | Texas | 48409 | 6205 | 216 |
1712227 | 1712227 | 2021-09-12 | San Patricio | Texas | 48409 | 6205 | 216 |
1656905 | 1656905 | 2021-08-26 | Henderson | Texas | 48213 | 7285 | 216 |
1656982 | 1656982 | 2021-08-26 | Parker | Texas | 48367 | 19066 | 216 |
1634202 | 1634202 | 2021-08-19 | Liberty | Texas | 48291 | 9601 | 216 |
1380899 | 1380899 | 2021-06-02 | Guadalupe | Texas | 48187 | 15179 | 216 |
1377654 | 1377654 | 2021-06-01 | Guadalupe | Texas | 48187 | 15114 | 216 |
1374408 | 1374408 | 2021-05-31 | Guadalupe | Texas | 48187 | 15114 | 216 |
1374549 | 1374549 | 2021-05-31 | Victoria | Texas | 48469 | 9094 | 216 |
1371163 | 1371163 | 2021-05-30 | Guadalupe | Texas | 48187 | 15114 | 216 |
1371304 | 1371304 | 2021-05-30 | Victoria | Texas | 48469 | 9094 | 216 |
1367917 | 1367917 | 2021-05-29 | Guadalupe | Texas | 48187 | 15114 | 216 |
1364671 | 1364671 | 2021-05-28 | Guadalupe | Texas | 48187 | 15109 | 216 |
1361425 | 1361425 | 2021-05-27 | Guadalupe | Texas | 48187 | 15093 | 216 |
1358104 | 1358104 | 2021-05-26 | Bowie | Texas | 48037 | 7066 | 216 |
1354858 | 1354858 | 2021-05-25 | Bowie | Texas | 48037 | 7064 | 216 |
1351612 | 1351612 | 2021-05-24 | Bowie | Texas | 48037 | 7061 | 216 |
1348366 | 1348366 | 2021-05-23 | Bowie | Texas | 48037 | 7054 | 216 |
1345118 | 1345118 | 2021-05-22 | Bowie | Texas | 48037 | 7050 | 216 |
1341870 | 1341870 | 2021-05-21 | Bowie | Texas | 48037 | 7039 | 216 |
1338622 | 1338622 | 2021-05-20 | Bowie | Texas | 48037 | 7036 | 216 |
1335375 | 1335375 | 2021-05-19 | Bowie | Texas | 48037 | 7030 | 216 |
1332128 | 1332128 | 2021-05-18 | Bowie | Texas | 48037 | 7027 | 216 |
1328881 | 1328881 | 2021-05-17 | Bowie | Texas | 48037 | 7025 | 216 |
1078950 | 1078950 | 2021-03-01 | Hays | Texas | 48209 | 18138 | 216 |
1072483 | 1072483 | 2021-02-27 | Kaufman | Texas | 48257 | 14760 | 216 |
968718 | 968718 | 2021-01-26 | Tom Green | Texas | 48451 | 15439 | 216 |
936131 | 936131 | 2021-01-16 | Gregg | Texas | 48183 | 8451 | 216 |
929708 | 929708 | 2021-01-14 | Maverick | Texas | 48323 | 7678 | 216 |
884356 | 884356 | 2020-12-31 | Wichita | Texas | 48485 | 11047 | 216 |
880952 | 880952 | 2020-12-30 | Galveston | Texas | 48167 | 21117 | 216 |
806393 | 806393 | 2020-12-07 | Montgomery | Texas | 48339 | 19584 | 216 |
803148 | 803148 | 2020-12-06 | Montgomery | Texas | 48339 | 18934 | 216 |
799903 | 799903 | 2020-12-05 | Montgomery | Texas | 48339 | 18934 | 216 |
796658 | 796658 | 2020-12-04 | Montgomery | Texas | 48339 | 18934 | 216 |
790186 | 790186 | 2020-12-02 | Potter | Texas | 48375 | 13062 | 216 |
465968 | 465968 | 2020-08-24 | Fort Bend | Texas | 48157 | 14640 | 216 |
462739 | 462739 | 2020-08-23 | Fort Bend | Texas | 48157 | 14034 | 216 |
165841 | 165841 | 2020-05-21 | Harris | Texas | 48201 | 10283 | 216 |
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);