ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
720 rows where deaths = 57 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Gonzales 83
- Terry 57
- Gray 52
- Bosque 38
- Callahan 37
- Colorado 26
- Chambers 24
- Frio 19
- Austin 18
- Red River 17
- Newton 16
- Rains 14
- Walker 14
- Cooke 11
- DeWitt 11
- Fayette 11
- Pecos 11
- Reeves 11
- Waller 11
- Kleberg 10
- Hale 9
- Coleman 8
- Jones 8
- Morris 8
- Anderson 7
- Duval 7
- Freestone 7
- Henderson 7
- Washington 7
- Bandera 6
- …
state 1
- Texas · 720 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2307089 | 2307089 | 2022-03-14 | Rains | Texas | 48379 | 1831 | 57 |
2303838 | 2303838 | 2022-03-13 | Rains | Texas | 48379 | 1830 | 57 |
2300586 | 2300586 | 2022-03-12 | Rains | Texas | 48379 | 1829 | 57 |
2297334 | 2297334 | 2022-03-11 | Rains | Texas | 48379 | 1829 | 57 |
2294082 | 2294082 | 2022-03-10 | Rains | Texas | 48379 | 1829 | 57 |
2290830 | 2290830 | 2022-03-09 | Rains | Texas | 48379 | 1829 | 57 |
2287578 | 2287578 | 2022-03-08 | Rains | Texas | 48379 | 1829 | 57 |
2284326 | 2284326 | 2022-03-07 | Rains | Texas | 48379 | 1829 | 57 |
2281074 | 2281074 | 2022-03-06 | Rains | Texas | 48379 | 1825 | 57 |
2277821 | 2277821 | 2022-03-05 | Rains | Texas | 48379 | 1825 | 57 |
2274568 | 2274568 | 2022-03-04 | Rains | Texas | 48379 | 1824 | 57 |
2271315 | 2271315 | 2022-03-03 | Rains | Texas | 48379 | 1824 | 57 |
2268063 | 2268063 | 2022-03-02 | Rains | Texas | 48379 | 1824 | 57 |
2264810 | 2264810 | 2022-03-01 | Rains | Texas | 48379 | 1824 | 57 |
2248542 | 2248542 | 2022-02-24 | Newton | Texas | 48351 | 1341 | 57 |
2245291 | 2245291 | 2022-02-23 | Newton | Texas | 48351 | 1341 | 57 |
2241984 | 2241984 | 2022-02-22 | Jackson | Texas | 48239 | 3207 | 57 |
2242040 | 2242040 | 2022-02-22 | Newton | Texas | 48351 | 1341 | 57 |
2238789 | 2238789 | 2022-02-21 | Newton | Texas | 48351 | 1341 | 57 |
2235538 | 2235538 | 2022-02-20 | Newton | Texas | 48351 | 1341 | 57 |
2232287 | 2232287 | 2022-02-19 | Newton | Texas | 48351 | 1341 | 57 |
2229036 | 2229036 | 2022-02-18 | Newton | Texas | 48351 | 1341 | 57 |
2225785 | 2225785 | 2022-02-17 | Newton | Texas | 48351 | 1335 | 57 |
2222534 | 2222534 | 2022-02-16 | Newton | Texas | 48351 | 1333 | 57 |
2219262 | 2219262 | 2022-02-15 | Marion | Texas | 48315 | 1607 | 57 |
2219283 | 2219283 | 2022-02-15 | Newton | Texas | 48351 | 1330 | 57 |
2216032 | 2216032 | 2022-02-14 | Newton | Texas | 48351 | 1329 | 57 |
2212781 | 2212781 | 2022-02-13 | Newton | Texas | 48351 | 1328 | 57 |
2209528 | 2209528 | 2022-02-12 | Newton | Texas | 48351 | 1325 | 57 |
2206275 | 2206275 | 2022-02-11 | Newton | Texas | 48351 | 1323 | 57 |
2202891 | 2202891 | 2022-02-10 | Colorado | Texas | 48089 | 3550 | 57 |
2203022 | 2203022 | 2022-02-10 | Newton | Texas | 48351 | 1321 | 57 |
2199637 | 2199637 | 2022-02-09 | Colorado | Texas | 48089 | 3544 | 57 |
2199768 | 2199768 | 2022-02-09 | Newton | Texas | 48351 | 1314 | 57 |
2196383 | 2196383 | 2022-02-08 | Colorado | Texas | 48089 | 3539 | 57 |
2196411 | 2196411 | 2022-02-08 | Falls | Texas | 48145 | 3641 | 57 |
2193129 | 2193129 | 2022-02-07 | Colorado | Texas | 48089 | 3534 | 57 |
2193157 | 2193157 | 2022-02-07 | Falls | Texas | 48145 | 3638 | 57 |
2189875 | 2189875 | 2022-02-06 | Colorado | Texas | 48089 | 3524 | 57 |
2189903 | 2189903 | 2022-02-06 | Falls | Texas | 48145 | 3638 | 57 |
2186622 | 2186622 | 2022-02-05 | Colorado | Texas | 48089 | 3515 | 57 |
2186650 | 2186650 | 2022-02-05 | Falls | Texas | 48145 | 3636 | 57 |
2183370 | 2183370 | 2022-02-04 | Colorado | Texas | 48089 | 3498 | 57 |
2183398 | 2183398 | 2022-02-04 | Falls | Texas | 48145 | 3621 | 57 |
2180118 | 2180118 | 2022-02-03 | Colorado | Texas | 48089 | 3468 | 57 |
2176867 | 2176867 | 2022-02-02 | Colorado | Texas | 48089 | 3432 | 57 |
2173613 | 2173613 | 2022-02-01 | Colorado | Texas | 48089 | 3419 | 57 |
2170361 | 2170361 | 2022-01-31 | Colorado | Texas | 48089 | 3395 | 57 |
2167107 | 2167107 | 2022-01-30 | Colorado | Texas | 48089 | 3385 | 57 |
2163852 | 2163852 | 2022-01-29 | Colorado | Texas | 48089 | 3369 | 57 |
2160597 | 2160597 | 2022-01-28 | Colorado | Texas | 48089 | 3344 | 57 |
2157341 | 2157341 | 2022-01-27 | Colorado | Texas | 48089 | 3335 | 57 |
2154088 | 2154088 | 2022-01-26 | Colorado | Texas | 48089 | 3318 | 57 |
2150836 | 2150836 | 2022-01-25 | Colorado | Texas | 48089 | 3309 | 57 |
2147584 | 2147584 | 2022-01-24 | Colorado | Texas | 48089 | 3294 | 57 |
2144330 | 2144330 | 2022-01-23 | Colorado | Texas | 48089 | 3288 | 57 |
2141075 | 2141075 | 2022-01-22 | Colorado | Texas | 48089 | 3264 | 57 |
2137819 | 2137819 | 2022-01-21 | Colorado | Texas | 48089 | 3236 | 57 |
2134565 | 2134565 | 2022-01-20 | Colorado | Texas | 48089 | 3200 | 57 |
2131313 | 2131313 | 2022-01-19 | Colorado | Texas | 48089 | 3168 | 57 |
2131468 | 2131468 | 2022-01-19 | Runnels | Texas | 48399 | 2012 | 57 |
2128059 | 2128059 | 2022-01-18 | Colorado | Texas | 48089 | 3159 | 57 |
2128214 | 2128214 | 2022-01-18 | Runnels | Texas | 48399 | 1985 | 57 |
2124807 | 2124807 | 2022-01-17 | Colorado | Texas | 48089 | 3151 | 57 |
2124962 | 2124962 | 2022-01-17 | Runnels | Texas | 48399 | 1978 | 57 |
2121555 | 2121555 | 2022-01-16 | Colorado | Texas | 48089 | 3138 | 57 |
2121710 | 2121710 | 2022-01-16 | Runnels | Texas | 48399 | 1976 | 57 |
2118458 | 2118458 | 2022-01-15 | Runnels | Texas | 48399 | 1961 | 57 |
2115207 | 2115207 | 2022-01-14 | Runnels | Texas | 48399 | 1951 | 57 |
2079247 | 2079247 | 2022-01-03 | Austin | Texas | 48015 | 4058 | 57 |
2075996 | 2075996 | 2022-01-02 | Austin | Texas | 48015 | 3927 | 57 |
2076182 | 2076182 | 2022-01-02 | Red River | Texas | 48387 | 1534 | 57 |
2072745 | 2072745 | 2022-01-01 | Austin | Texas | 48015 | 3927 | 57 |
2072931 | 2072931 | 2022-01-01 | Red River | Texas | 48387 | 1534 | 57 |
2069494 | 2069494 | 2021-12-31 | Austin | Texas | 48015 | 3927 | 57 |
2069680 | 2069680 | 2021-12-31 | Red River | Texas | 48387 | 1534 | 57 |
2066243 | 2066243 | 2021-12-30 | Austin | Texas | 48015 | 3927 | 57 |
2066429 | 2066429 | 2021-12-30 | Red River | Texas | 48387 | 1534 | 57 |
2062993 | 2062993 | 2021-12-29 | Austin | Texas | 48015 | 3917 | 57 |
2063179 | 2063179 | 2021-12-29 | Red River | Texas | 48387 | 1528 | 57 |
2059743 | 2059743 | 2021-12-28 | Austin | Texas | 48015 | 3905 | 57 |
2059929 | 2059929 | 2021-12-28 | Red River | Texas | 48387 | 1528 | 57 |
2056494 | 2056494 | 2021-12-27 | Austin | Texas | 48015 | 3887 | 57 |
2056680 | 2056680 | 2021-12-27 | Red River | Texas | 48387 | 1523 | 57 |
2053245 | 2053245 | 2021-12-26 | Austin | Texas | 48015 | 3852 | 57 |
2053431 | 2053431 | 2021-12-26 | Red River | Texas | 48387 | 1511 | 57 |
2049995 | 2049995 | 2021-12-25 | Austin | Texas | 48015 | 3852 | 57 |
2050181 | 2050181 | 2021-12-25 | Red River | Texas | 48387 | 1511 | 57 |
2046745 | 2046745 | 2021-12-24 | Austin | Texas | 48015 | 3852 | 57 |
2046931 | 2046931 | 2021-12-24 | Red River | Texas | 48387 | 1511 | 57 |
2043495 | 2043495 | 2021-12-23 | Austin | Texas | 48015 | 3852 | 57 |
2043681 | 2043681 | 2021-12-23 | Red River | Texas | 48387 | 1511 | 57 |
2040246 | 2040246 | 2021-12-22 | Austin | Texas | 48015 | 3832 | 57 |
2040432 | 2040432 | 2021-12-22 | Red River | Texas | 48387 | 1503 | 57 |
2036996 | 2036996 | 2021-12-21 | Austin | Texas | 48015 | 3823 | 57 |
2037182 | 2037182 | 2021-12-21 | Red River | Texas | 48387 | 1501 | 57 |
2033746 | 2033746 | 2021-12-20 | Austin | Texas | 48015 | 3800 | 57 |
2033756 | 2033756 | 2021-12-20 | Bosque | Texas | 48035 | 2542 | 57 |
2033932 | 2033932 | 2021-12-20 | Red River | Texas | 48387 | 1500 | 57 |
2030496 | 2030496 | 2021-12-19 | Austin | Texas | 48015 | 3796 | 57 |
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);