ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
97 rows where deaths = 215 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Hardin 19
- Hood 14
- Atascosa 7
- Harrison 7
- Nacogdoches 5
- Williamson 4
- Anderson 3
- Bowie 3
- Lamar 3
- Val Verde 3
- Bastrop 2
- Brazos 2
- Denton 2
- Navarro 2
- Orange 2
- Victoria 2
- Angelina 1
- Grayson 1
- Hunt 1
- Jefferson 1
- Johnson 1
- Kaufman 1
- Liberty 1
- Montgomery 1
- Parker 1
- Rockwall 1
- San Patricio 1
- Smith 1
- Starr 1
- Tarrant 1
- …
state 1
- Texas · 97 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2248468 | 2248468 | 2022-02-24 | Harrison | Texas | 48203 | 12857 | 215 |
2248541 | 2248541 | 2022-02-24 | Navarro | Texas | 48349 | 12164 | 215 |
2245217 | 2245217 | 2022-02-23 | Harrison | Texas | 48203 | 12831 | 215 |
2245290 | 2245290 | 2022-02-23 | Navarro | Texas | 48349 | 12162 | 215 |
2241966 | 2241966 | 2022-02-22 | Harrison | Texas | 48203 | 12810 | 215 |
2238715 | 2238715 | 2022-02-21 | Harrison | Texas | 48203 | 12786 | 215 |
2235464 | 2235464 | 2022-02-20 | Harrison | Texas | 48203 | 12784 | 215 |
2232213 | 2232213 | 2022-02-19 | Harrison | Texas | 48203 | 12783 | 215 |
2228962 | 2228962 | 2022-02-18 | Harrison | Texas | 48203 | 12743 | 215 |
2215867 | 2215867 | 2022-02-14 | Bastrop | Texas | 48021 | 21382 | 215 |
2212616 | 2212616 | 2022-02-13 | Bastrop | Texas | 48021 | 21372 | 215 |
2157303 | 2157303 | 2022-01-27 | Atascosa | Texas | 48013 | 12106 | 215 |
2154050 | 2154050 | 2022-01-26 | Atascosa | Texas | 48013 | 12032 | 215 |
2150798 | 2150798 | 2022-01-25 | Atascosa | Texas | 48013 | 11955 | 215 |
2147546 | 2147546 | 2022-01-24 | Atascosa | Texas | 48013 | 11702 | 215 |
2144292 | 2144292 | 2022-01-23 | Atascosa | Texas | 48013 | 11570 | 215 |
2141037 | 2141037 | 2022-01-22 | Atascosa | Texas | 48013 | 11486 | 215 |
2137781 | 2137781 | 2022-01-21 | Atascosa | Texas | 48013 | 11308 | 215 |
2128015 | 2128015 | 2022-01-18 | Anderson | Texas | 48001 | 8874 | 215 |
2124763 | 2124763 | 2022-01-17 | Anderson | Texas | 48001 | 8851 | 215 |
2121511 | 2121511 | 2022-01-16 | Anderson | Texas | 48001 | 8802 | 215 |
2076088 | 2076088 | 2022-01-02 | Hardin | Texas | 48199 | 10652 | 215 |
2072837 | 2072837 | 2022-01-01 | Hardin | Texas | 48199 | 10652 | 215 |
2069586 | 2069586 | 2021-12-31 | Hardin | Texas | 48199 | 10652 | 215 |
2066335 | 2066335 | 2021-12-30 | Hardin | Texas | 48199 | 10652 | 215 |
2063085 | 2063085 | 2021-12-29 | Hardin | Texas | 48199 | 10647 | 215 |
2059835 | 2059835 | 2021-12-28 | Hardin | Texas | 48199 | 10638 | 215 |
2059846 | 2059846 | 2021-12-28 | Hood | Texas | 48221 | 10225 | 215 |
2056586 | 2056586 | 2021-12-27 | Hardin | Texas | 48199 | 10611 | 215 |
2056597 | 2056597 | 2021-12-27 | Hood | Texas | 48221 | 10186 | 215 |
2053337 | 2053337 | 2021-12-26 | Hardin | Texas | 48199 | 10577 | 215 |
2053348 | 2053348 | 2021-12-26 | Hood | Texas | 48221 | 10112 | 215 |
2050087 | 2050087 | 2021-12-25 | Hardin | Texas | 48199 | 10577 | 215 |
2050098 | 2050098 | 2021-12-25 | Hood | Texas | 48221 | 10112 | 215 |
2046837 | 2046837 | 2021-12-24 | Hardin | Texas | 48199 | 10577 | 215 |
2046848 | 2046848 | 2021-12-24 | Hood | Texas | 48221 | 10112 | 215 |
2043587 | 2043587 | 2021-12-23 | Hardin | Texas | 48199 | 10577 | 215 |
2043598 | 2043598 | 2021-12-23 | Hood | Texas | 48221 | 10112 | 215 |
2040338 | 2040338 | 2021-12-22 | Hardin | Texas | 48199 | 10573 | 215 |
2040349 | 2040349 | 2021-12-22 | Hood | Texas | 48221 | 10103 | 215 |
2037088 | 2037088 | 2021-12-21 | Hardin | Texas | 48199 | 10572 | 215 |
2037099 | 2037099 | 2021-12-21 | Hood | Texas | 48221 | 10092 | 215 |
2033838 | 2033838 | 2021-12-20 | Hardin | Texas | 48199 | 10567 | 215 |
2033849 | 2033849 | 2021-12-20 | Hood | Texas | 48221 | 10078 | 215 |
2030588 | 2030588 | 2021-12-19 | Hardin | Texas | 48199 | 10561 | 215 |
2030599 | 2030599 | 2021-12-19 | Hood | Texas | 48221 | 10065 | 215 |
2027337 | 2027337 | 2021-12-18 | Hardin | Texas | 48199 | 10560 | 215 |
2027348 | 2027348 | 2021-12-18 | Hood | Texas | 48221 | 10056 | 215 |
2024086 | 2024086 | 2021-12-17 | Hardin | Texas | 48199 | 10558 | 215 |
2024097 | 2024097 | 2021-12-17 | Hood | Texas | 48221 | 10038 | 215 |
2020835 | 2020835 | 2021-12-16 | Hardin | Texas | 48199 | 10557 | 215 |
2020846 | 2020846 | 2021-12-16 | Hood | Texas | 48221 | 10027 | 215 |
2017584 | 2017584 | 2021-12-15 | Hardin | Texas | 48199 | 10556 | 215 |
2017595 | 2017595 | 2021-12-15 | Hood | Texas | 48221 | 10013 | 215 |
1939609 | 1939609 | 2021-11-21 | Lamar | Texas | 48277 | 8952 | 215 |
1936359 | 1936359 | 2021-11-20 | Lamar | Texas | 48277 | 8952 | 215 |
1933109 | 1933109 | 2021-11-19 | Lamar | Texas | 48277 | 8952 | 215 |
1881206 | 1881206 | 2021-11-03 | Van Zandt | Texas | 48467 | 8069 | 215 |
1832433 | 1832433 | 2021-10-19 | Rockwall | Texas | 48397 | 17404 | 215 |
1819488 | 1819488 | 2021-10-15 | Wood | Texas | 48499 | 6393 | 215 |
1806416 | 1806416 | 2021-10-11 | Nacogdoches | Texas | 48347 | 7599 | 215 |
1803166 | 1803166 | 2021-10-10 | Nacogdoches | Texas | 48347 | 7599 | 215 |
1799917 | 1799917 | 2021-10-09 | Nacogdoches | Texas | 48347 | 7599 | 215 |
1796668 | 1796668 | 2021-10-08 | Nacogdoches | Texas | 48347 | 7584 | 215 |
1793419 | 1793419 | 2021-10-07 | Nacogdoches | Texas | 48347 | 7552 | 215 |
1738193 | 1738193 | 2021-09-20 | Orange | Texas | 48361 | 12892 | 215 |
1734943 | 1734943 | 2021-09-19 | Orange | Texas | 48361 | 12892 | 215 |
1708980 | 1708980 | 2021-09-11 | San Patricio | Texas | 48409 | 6205 | 215 |
1705644 | 1705644 | 2021-09-10 | Hunt | Texas | 48231 | 9167 | 215 |
1653735 | 1653735 | 2021-08-25 | Parker | Texas | 48367 | 18924 | 215 |
1630955 | 1630955 | 2021-08-18 | Liberty | Texas | 48291 | 9533 | 215 |
1368058 | 1368058 | 2021-05-29 | Victoria | Texas | 48469 | 9094 | 215 |
1364812 | 1364812 | 2021-05-28 | Victoria | Texas | 48469 | 9094 | 215 |
1325635 | 1325635 | 2021-05-16 | Bowie | Texas | 48037 | 7022 | 215 |
1322389 | 1322389 | 2021-05-15 | Bowie | Texas | 48037 | 7018 | 215 |
1319143 | 1319143 | 2021-05-14 | Bowie | Texas | 48037 | 7012 | 215 |
1208958 | 1208958 | 2021-04-10 | Val Verde | Texas | 48465 | 7797 | 215 |
1205710 | 1205710 | 2021-04-09 | Val Verde | Texas | 48465 | 7797 | 215 |
1202462 | 1202462 | 2021-04-08 | Val Verde | Texas | 48465 | 7797 | 215 |
1088603 | 1088603 | 2021-03-04 | Brazos | Texas | 48041 | 21360 | 215 |
1085358 | 1085358 | 2021-03-03 | Brazos | Texas | 48041 | 21243 | 215 |
1069237 | 1069237 | 2021-02-26 | Kaufman | Texas | 48257 | 14713 | 215 |
978230 | 978230 | 2021-01-29 | Angelina | Texas | 48005 | 7121 | 215 |
949148 | 949148 | 2021-01-20 | Johnson | Texas | 48251 | 15098 | 215 |
949236 | 949236 | 2021-01-20 | Starr | Texas | 48427 | 7579 | 215 |
929640 | 929640 | 2021-01-14 | Grayson | Texas | 48181 | 8458 | 215 |
900588 | 900588 | 2021-01-05 | Williamson | Texas | 48491 | 25233 | 215 |
897343 | 897343 | 2021-01-04 | Williamson | Texas | 48491 | 24482 | 215 |
894097 | 894097 | 2021-01-03 | Williamson | Texas | 48491 | 22884 | 215 |
890851 | 890851 | 2021-01-02 | Williamson | Texas | 48491 | 22884 | 215 |
880991 | 880991 | 2020-12-30 | Jefferson | Texas | 48245 | 13455 | 215 |
816170 | 816170 | 2020-12-10 | Smith | Texas | 48423 | 11059 | 215 |
793413 | 793413 | 2020-12-03 | Montgomery | Texas | 48339 | 18648 | 215 |
783571 | 783571 | 2020-11-30 | Denton | Texas | 48121 | 23644 | 215 |
780326 | 780326 | 2020-11-29 | Denton | Texas | 48121 | 23276 | 215 |
453214 | 453214 | 2020-08-20 | Webb | Texas | 48479 | 10047 | 215 |
270952 | 270952 | 2020-06-24 | Tarrant | Texas | 48439 | 9846 | 215 |
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);