ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
459 rows where deaths = 79 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Nolan 32
- Cass 28
- Lamb 28
- Sabine 19
- Moore 18
- Guadalupe 17
- Jones 17
- San Jacinto 16
- Wilbarger 16
- Kerr 14
- Palo Pinto 14
- Milam 11
- San Patricio 11
- Uvalde 11
- Deaf Smith 9
- Gray 8
- Chambers 7
- Jim Wells 7
- Lavaca 7
- Terry 7
- Frio 6
- Waller 6
- Williamson 6
- Cameron 5
- Dawson 5
- DeWitt 5
- Fayette 5
- Gillespie 5
- Grimes 5
- Hockley 5
- …
state 1
- Texas · 459 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2287392 | 2287392 | 2022-03-08 | Aransas | Texas | 48007 | 4055 | 79 |
2284140 | 2284140 | 2022-03-07 | Aransas | Texas | 48007 | 4053 | 79 |
2280888 | 2280888 | 2022-03-06 | Aransas | Texas | 48007 | 4053 | 79 |
2277635 | 2277635 | 2022-03-05 | Aransas | Texas | 48007 | 4053 | 79 |
2228943 | 2228943 | 2022-02-18 | Gaines | Texas | 48165 | 1827 | 79 |
2229089 | 2229089 | 2022-02-18 | Tyler | Texas | 48457 | 3343 | 79 |
2225692 | 2225692 | 2022-02-17 | Gaines | Texas | 48165 | 1806 | 79 |
2225838 | 2225838 | 2022-02-17 | Tyler | Texas | 48457 | 3342 | 79 |
2222441 | 2222441 | 2022-02-16 | Gaines | Texas | 48165 | 1801 | 79 |
2222587 | 2222587 | 2022-02-16 | Tyler | Texas | 48457 | 3342 | 79 |
2219336 | 2219336 | 2022-02-15 | Tyler | Texas | 48457 | 3338 | 79 |
2209494 | 2209494 | 2022-02-12 | Lampasas | Texas | 48281 | 5417 | 79 |
2206241 | 2206241 | 2022-02-11 | Lampasas | Texas | 48281 | 5415 | 79 |
2202988 | 2202988 | 2022-02-10 | Lampasas | Texas | 48281 | 5398 | 79 |
2203048 | 2203048 | 2022-02-10 | Sabine | Texas | 48403 | 1214 | 79 |
2203090 | 2203090 | 2022-02-10 | Wilbarger | Texas | 48487 | 3397 | 79 |
2199734 | 2199734 | 2022-02-09 | Lampasas | Texas | 48281 | 5397 | 79 |
2199794 | 2199794 | 2022-02-09 | Sabine | Texas | 48403 | 1213 | 79 |
2199836 | 2199836 | 2022-02-09 | Wilbarger | Texas | 48487 | 3393 | 79 |
2196582 | 2196582 | 2022-02-08 | Wilbarger | Texas | 48487 | 3388 | 79 |
2193328 | 2193328 | 2022-02-07 | Wilbarger | Texas | 48487 | 3386 | 79 |
2190075 | 2190075 | 2022-02-06 | Wilbarger | Texas | 48487 | 3382 | 79 |
2186822 | 2186822 | 2022-02-05 | Wilbarger | Texas | 48487 | 3382 | 79 |
2183569 | 2183569 | 2022-02-04 | Wilbarger | Texas | 48487 | 3373 | 79 |
2180317 | 2180317 | 2022-02-03 | Wilbarger | Texas | 48487 | 3370 | 79 |
2176967 | 2176967 | 2022-02-02 | Leon | Texas | 48289 | 3543 | 79 |
2177066 | 2177066 | 2022-02-02 | Wilbarger | Texas | 48487 | 3360 | 79 |
2173813 | 2173813 | 2022-02-01 | Wilbarger | Texas | 48487 | 3357 | 79 |
2170561 | 2170561 | 2022-01-31 | Wilbarger | Texas | 48487 | 3344 | 79 |
2167307 | 2167307 | 2022-01-30 | Wilbarger | Texas | 48487 | 3343 | 79 |
2164030 | 2164030 | 2022-01-29 | Terry | Texas | 48445 | 2110 | 79 |
2164052 | 2164052 | 2022-01-29 | Wilbarger | Texas | 48487 | 3342 | 79 |
2160775 | 2160775 | 2022-01-28 | Terry | Texas | 48445 | 2049 | 79 |
2160797 | 2160797 | 2022-01-28 | Wilbarger | Texas | 48487 | 3311 | 79 |
2157519 | 2157519 | 2022-01-27 | Terry | Texas | 48445 | 2036 | 79 |
2157541 | 2157541 | 2022-01-27 | Wilbarger | Texas | 48487 | 3289 | 79 |
2154266 | 2154266 | 2022-01-26 | Terry | Texas | 48445 | 2035 | 79 |
2154288 | 2154288 | 2022-01-26 | Wilbarger | Texas | 48487 | 3276 | 79 |
2151014 | 2151014 | 2022-01-25 | Terry | Texas | 48445 | 2035 | 79 |
2147762 | 2147762 | 2022-01-24 | Terry | Texas | 48445 | 2033 | 79 |
2144508 | 2144508 | 2022-01-23 | Terry | Texas | 48445 | 2031 | 79 |
2141232 | 2141232 | 2022-01-22 | Sabine | Texas | 48403 | 1141 | 79 |
2137976 | 2137976 | 2022-01-21 | Sabine | Texas | 48403 | 1126 | 79 |
2134722 | 2134722 | 2022-01-20 | Sabine | Texas | 48403 | 1116 | 79 |
2131470 | 2131470 | 2022-01-19 | Sabine | Texas | 48403 | 1108 | 79 |
2128216 | 2128216 | 2022-01-18 | Sabine | Texas | 48403 | 1108 | 79 |
2124964 | 2124964 | 2022-01-17 | Sabine | Texas | 48403 | 1101 | 79 |
2121712 | 2121712 | 2022-01-16 | Sabine | Texas | 48403 | 1095 | 79 |
2118460 | 2118460 | 2022-01-15 | Sabine | Texas | 48403 | 1093 | 79 |
2115209 | 2115209 | 2022-01-14 | Sabine | Texas | 48403 | 1087 | 79 |
2111957 | 2111957 | 2022-01-13 | Sabine | Texas | 48403 | 1061 | 79 |
2108585 | 2108585 | 2022-01-12 | Frio | Texas | 48163 | 4492 | 79 |
2108705 | 2108705 | 2022-01-12 | Sabine | Texas | 48403 | 1059 | 79 |
2105334 | 2105334 | 2022-01-11 | Frio | Texas | 48163 | 4468 | 79 |
2105454 | 2105454 | 2022-01-11 | Sabine | Texas | 48403 | 1040 | 79 |
2102083 | 2102083 | 2022-01-10 | Frio | Texas | 48163 | 4440 | 79 |
2102203 | 2102203 | 2022-01-10 | Sabine | Texas | 48403 | 1033 | 79 |
2098832 | 2098832 | 2022-01-09 | Frio | Texas | 48163 | 4415 | 79 |
2098952 | 2098952 | 2022-01-09 | Sabine | Texas | 48403 | 1029 | 79 |
2095580 | 2095580 | 2022-01-08 | Frio | Texas | 48163 | 4401 | 79 |
2095700 | 2095700 | 2022-01-08 | Sabine | Texas | 48403 | 1027 | 79 |
2092328 | 2092328 | 2022-01-07 | Frio | Texas | 48163 | 4371 | 79 |
2092448 | 2092448 | 2022-01-07 | Sabine | Texas | 48403 | 1024 | 79 |
2089196 | 2089196 | 2022-01-06 | Sabine | Texas | 48403 | 1021 | 79 |
2076115 | 2076115 | 2022-01-02 | Jones | Texas | 48253 | 3392 | 79 |
2072864 | 2072864 | 2022-01-01 | Jones | Texas | 48253 | 3392 | 79 |
2069613 | 2069613 | 2021-12-31 | Jones | Texas | 48253 | 3392 | 79 |
2066362 | 2066362 | 2021-12-30 | Jones | Texas | 48253 | 3392 | 79 |
2063112 | 2063112 | 2021-12-29 | Jones | Texas | 48253 | 3384 | 79 |
2059862 | 2059862 | 2021-12-28 | Jones | Texas | 48253 | 3380 | 79 |
2056613 | 2056613 | 2021-12-27 | Jones | Texas | 48253 | 3372 | 79 |
2053364 | 2053364 | 2021-12-26 | Jones | Texas | 48253 | 3361 | 79 |
2050114 | 2050114 | 2021-12-25 | Jones | Texas | 48253 | 3361 | 79 |
2046864 | 2046864 | 2021-12-24 | Jones | Texas | 48253 | 3361 | 79 |
2043614 | 2043614 | 2021-12-23 | Jones | Texas | 48253 | 3361 | 79 |
2040365 | 2040365 | 2021-12-22 | Jones | Texas | 48253 | 3357 | 79 |
2037115 | 2037115 | 2021-12-21 | Jones | Texas | 48253 | 3356 | 79 |
2033865 | 2033865 | 2021-12-20 | Jones | Texas | 48253 | 3352 | 79 |
2030615 | 2030615 | 2021-12-19 | Jones | Texas | 48253 | 3350 | 79 |
2027364 | 2027364 | 2021-12-18 | Jones | Texas | 48253 | 3348 | 79 |
2024113 | 2024113 | 2021-12-17 | Jones | Texas | 48253 | 3340 | 79 |
1991628 | 1991628 | 2021-12-07 | Llano | Texas | 48299 | 2704 | 79 |
1988377 | 1988377 | 2021-12-06 | Llano | Texas | 48299 | 2702 | 79 |
1985127 | 1985127 | 2021-12-05 | Llano | Texas | 48299 | 2700 | 79 |
1962402 | 1962402 | 2021-11-28 | Nolan | Texas | 48353 | 2529 | 79 |
1959151 | 1959151 | 2021-11-27 | Nolan | Texas | 48353 | 2529 | 79 |
1955900 | 1955900 | 2021-11-26 | Nolan | Texas | 48353 | 2529 | 79 |
1952649 | 1952649 | 2021-11-25 | Nolan | Texas | 48353 | 2529 | 79 |
1949398 | 1949398 | 2021-11-24 | Nolan | Texas | 48353 | 2529 | 79 |
1946147 | 1946147 | 2021-11-23 | Nolan | Texas | 48353 | 2526 | 79 |
1942896 | 1942896 | 2021-11-22 | Nolan | Texas | 48353 | 2522 | 79 |
1939646 | 1939646 | 2021-11-21 | Nolan | Texas | 48353 | 2522 | 79 |
1936396 | 1936396 | 2021-11-20 | Nolan | Texas | 48353 | 2522 | 79 |
1933146 | 1933146 | 2021-11-19 | Nolan | Texas | 48353 | 2517 | 79 |
1929895 | 1929895 | 2021-11-18 | Nolan | Texas | 48353 | 2517 | 79 |
1926645 | 1926645 | 2021-11-17 | Nolan | Texas | 48353 | 2514 | 79 |
1923395 | 1923395 | 2021-11-16 | Nolan | Texas | 48353 | 2514 | 79 |
1920146 | 1920146 | 2021-11-15 | Nolan | Texas | 48353 | 2506 | 79 |
1916896 | 1916896 | 2021-11-14 | Nolan | Texas | 48353 | 2506 | 79 |
1913646 | 1913646 | 2021-11-13 | Nolan | Texas | 48353 | 2506 | 79 |
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);