ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
94 rows where deaths = 198 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Victoria 11
- Henderson 10
- Guadalupe 8
- Medina 8
- Val Verde 7
- Harrison 4
- Hays 4
- Wharton 4
- Bastrop 3
- Bowie 3
- Polk 3
- Brazos 2
- Galveston 2
- Hunt 2
- Jim Wells 2
- Lamar 2
- Van Zandt 2
- Wood 2
- Anderson 1
- Atascosa 1
- Cherokee 1
- Collin 1
- Fort Bend 1
- Hale 1
- Liberty 1
- Maverick 1
- McLennan 1
- Navarro 1
- Parker 1
- Rockwall 1
- …
state 1
- Texas · 94 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2479564 | 2479564 | 2022-05-06 | Medina | Texas | 48325 | 10258 | 198 |
2476306 | 2476306 | 2022-05-05 | Medina | Texas | 48325 | 10254 | 198 |
2473049 | 2473049 | 2022-05-04 | Medina | Texas | 48325 | 10252 | 198 |
2469793 | 2469793 | 2022-05-03 | Medina | Texas | 48325 | 10249 | 198 |
2466537 | 2466537 | 2022-05-02 | Medina | Texas | 48325 | 10249 | 198 |
2463282 | 2463282 | 2022-05-01 | Medina | Texas | 48325 | 10244 | 198 |
2460026 | 2460026 | 2022-04-30 | Medina | Texas | 48325 | 10242 | 198 |
2456770 | 2456770 | 2022-04-29 | Medina | Texas | 48325 | 10239 | 198 |
2238738 | 2238738 | 2022-02-21 | Jim Wells | Texas | 48249 | 10951 | 198 |
2235487 | 2235487 | 2022-02-20 | Jim Wells | Texas | 48249 | 10944 | 198 |
2183566 | 2183566 | 2022-02-04 | Wharton | Texas | 48481 | 8206 | 198 |
2180314 | 2180314 | 2022-02-03 | Wharton | Texas | 48481 | 8179 | 198 |
2177058 | 2177058 | 2022-02-02 | Walker | Texas | 48471 | 17603 | 198 |
2177063 | 2177063 | 2022-02-02 | Wharton | Texas | 48481 | 8113 | 198 |
2173810 | 2173810 | 2022-02-01 | Wharton | Texas | 48481 | 8080 | 198 |
2160563 | 2160563 | 2022-01-28 | Bastrop | Texas | 48021 | 20326 | 198 |
2157307 | 2157307 | 2022-01-27 | Bastrop | Texas | 48021 | 20274 | 198 |
2154054 | 2154054 | 2022-01-26 | Bastrop | Texas | 48021 | 20164 | 198 |
2154145 | 2154145 | 2022-01-26 | Harrison | Texas | 48203 | 11726 | 198 |
2150893 | 2150893 | 2022-01-25 | Harrison | Texas | 48203 | 11687 | 198 |
2147641 | 2147641 | 2022-01-24 | Harrison | Texas | 48203 | 11632 | 198 |
2144387 | 2144387 | 2022-01-23 | Harrison | Texas | 48203 | 11575 | 198 |
2134695 | 2134695 | 2022-01-20 | Navarro | Texas | 48349 | 10943 | 198 |
2020830 | 2020830 | 2021-12-16 | Hale | Texas | 48189 | 8267 | 198 |
1855167 | 1855167 | 2021-10-26 | Polk | Texas | 48373 | 5900 | 198 |
1851918 | 1851918 | 2021-10-25 | Polk | Texas | 48373 | 5900 | 198 |
1848668 | 1848668 | 2021-10-24 | Polk | Texas | 48373 | 5900 | 198 |
1838733 | 1838733 | 2021-10-21 | Anderson | Texas | 48001 | 7967 | 198 |
1815996 | 1815996 | 2021-10-14 | Atascosa | Texas | 48013 | 8470 | 198 |
1816129 | 1816129 | 2021-10-14 | Lamar | Texas | 48277 | 8674 | 198 |
1816223 | 1816223 | 2021-10-14 | Van Zandt | Texas | 48467 | 7814 | 198 |
1812881 | 1812881 | 2021-10-13 | Lamar | Texas | 48277 | 8661 | 198 |
1812975 | 1812975 | 2021-10-13 | Van Zandt | Texas | 48467 | 7814 | 198 |
1786785 | 1786785 | 2021-10-05 | Cherokee | Texas | 48073 | 6650 | 198 |
1786998 | 1786998 | 2021-10-05 | Wood | Texas | 48499 | 6257 | 198 |
1783749 | 1783749 | 2021-10-04 | Wood | Texas | 48499 | 6151 | 198 |
1764201 | 1764201 | 2021-09-28 | Rockwall | Texas | 48397 | 16598 | 198 |
1695986 | 1695986 | 2021-09-07 | San Patricio | Texas | 48409 | 5834 | 198 |
1666659 | 1666659 | 2021-08-29 | Hunt | Texas | 48231 | 8060 | 198 |
1663411 | 1663411 | 2021-08-28 | Hunt | Texas | 48231 | 7968 | 198 |
1592015 | 1592015 | 2021-08-06 | Parker | Texas | 48367 | 17486 | 198 |
1569196 | 1569196 | 2021-07-30 | Henderson | Texas | 48213 | 6396 | 198 |
1565948 | 1565948 | 2021-07-29 | Henderson | Texas | 48213 | 6231 | 198 |
1562700 | 1562700 | 2021-07-28 | Henderson | Texas | 48213 | 6231 | 198 |
1559452 | 1559452 | 2021-07-27 | Henderson | Texas | 48213 | 6231 | 198 |
1556205 | 1556205 | 2021-07-26 | Henderson | Texas | 48213 | 6231 | 198 |
1552958 | 1552958 | 2021-07-25 | Henderson | Texas | 48213 | 6198 | 198 |
1549711 | 1549711 | 2021-07-24 | Henderson | Texas | 48213 | 6198 | 198 |
1546464 | 1546464 | 2021-07-23 | Henderson | Texas | 48213 | 6198 | 198 |
1543217 | 1543217 | 2021-07-22 | Henderson | Texas | 48213 | 6159 | 198 |
1539969 | 1539969 | 2021-07-21 | Henderson | Texas | 48213 | 6159 | 198 |
1494551 | 1494551 | 2021-07-07 | Liberty | Texas | 48291 | 8228 | 198 |
1228447 | 1228447 | 2021-04-16 | Victoria | Texas | 48469 | 8355 | 198 |
1225199 | 1225199 | 2021-04-15 | Victoria | Texas | 48469 | 8336 | 198 |
1221952 | 1221952 | 2021-04-14 | Victoria | Texas | 48469 | 8319 | 198 |
1218704 | 1218704 | 2021-04-13 | Victoria | Texas | 48469 | 8295 | 198 |
1215456 | 1215456 | 2021-04-12 | Victoria | Texas | 48469 | 8272 | 198 |
1212209 | 1212209 | 2021-04-11 | Victoria | Texas | 48469 | 8272 | 198 |
1208960 | 1208960 | 2021-04-10 | Victoria | Texas | 48469 | 8272 | 198 |
1205712 | 1205712 | 2021-04-09 | Victoria | Texas | 48469 | 8259 | 198 |
1202464 | 1202464 | 2021-04-08 | Victoria | Texas | 48469 | 8238 | 198 |
1199215 | 1199215 | 2021-04-07 | Victoria | Texas | 48469 | 8187 | 198 |
1195966 | 1195966 | 2021-04-06 | Victoria | Texas | 48469 | 8187 | 198 |
1147038 | 1147038 | 2021-03-22 | Bowie | Texas | 48037 | 6761 | 198 |
1143791 | 1143791 | 2021-03-21 | Bowie | Texas | 48037 | 6760 | 198 |
1140544 | 1140544 | 2021-03-20 | Bowie | Texas | 48037 | 6754 | 198 |
1130879 | 1130879 | 2021-03-17 | Guadalupe | Texas | 48187 | 13694 | 198 |
1127632 | 1127632 | 2021-03-16 | Guadalupe | Texas | 48187 | 13647 | 198 |
1124386 | 1124386 | 2021-03-15 | Guadalupe | Texas | 48187 | 13618 | 198 |
1121140 | 1121140 | 2021-03-14 | Guadalupe | Texas | 48187 | 13618 | 198 |
1117893 | 1117893 | 2021-03-13 | Guadalupe | Texas | 48187 | 13618 | 198 |
1114646 | 1114646 | 2021-03-12 | Guadalupe | Texas | 48187 | 13602 | 198 |
1111400 | 1111400 | 2021-03-11 | Guadalupe | Texas | 48187 | 13580 | 198 |
1108154 | 1108154 | 2021-03-10 | Guadalupe | Texas | 48187 | 13557 | 198 |
1101801 | 1101801 | 2021-03-08 | Val Verde | Texas | 48465 | 7717 | 198 |
1098555 | 1098555 | 2021-03-07 | Val Verde | Texas | 48465 | 7717 | 198 |
1095307 | 1095307 | 2021-03-06 | Val Verde | Texas | 48465 | 7717 | 198 |
1092061 | 1092061 | 2021-03-05 | Val Verde | Texas | 48465 | 7717 | 198 |
1088815 | 1088815 | 2021-03-04 | Val Verde | Texas | 48465 | 7717 | 198 |
1085570 | 1085570 | 2021-03-03 | Val Verde | Texas | 48465 | 7668 | 198 |
1082324 | 1082324 | 2021-03-02 | Val Verde | Texas | 48465 | 7668 | 198 |
1017200 | 1017200 | 2021-02-10 | Brazos | Texas | 48041 | 19917 | 198 |
1013955 | 1013955 | 2021-02-09 | Brazos | Texas | 48041 | 19786 | 198 |
1010794 | 1010794 | 2021-02-08 | Hays | Texas | 48209 | 17338 | 198 |
1007548 | 1007548 | 2021-02-07 | Hays | Texas | 48209 | 17121 | 198 |
1004302 | 1004302 | 2021-02-06 | Hays | Texas | 48209 | 17121 | 198 |
1001056 | 1001056 | 2021-02-05 | Hays | Texas | 48209 | 17121 | 198 |
903746 | 903746 | 2021-01-06 | Maverick | Texas | 48323 | 6780 | 198 |
845257 | 845257 | 2020-12-19 | Galveston | Texas | 48167 | 18355 | 198 |
842011 | 842011 | 2020-12-18 | Galveston | Texas | 48167 | 18170 | 198 |
786914 | 786914 | 2020-12-01 | McLennan | Texas | 48309 | 14531 | 198 |
705673 | 705673 | 2020-11-06 | Collin | Texas | 48085 | 19701 | 198 |
449827 | 449827 | 2020-08-19 | Fort Bend | Texas | 48157 | 13605 | 198 |
245963 | 245963 | 2020-06-16 | Tarrant | Texas | 48439 | 7642 | 198 |
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);