ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
333 rows where deaths = 95 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Fayette 34
- Scurry 28
- Jasper 21
- Kleberg 19
- Gonzales 17
- Kerr 14
- Caldwell 11
- Fannin 11
- Nolan 11
- Howard 9
- Harrison 8
- Jim Wells 8
- Montague 7
- Bastrop 6
- Coryell 6
- Matagorda 6
- Victoria 6
- Kendall 5
- Moore 5
- Washington 5
- Gray 4
- Lavaca 4
- Midland 4
- San Jacinto 4
- San Patricio 4
- Waller 4
- Angelina 3
- Atascosa 3
- Cass 3
- Comal 3
- …
state 1
- Texas · 333 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2306988 | 2306988 | 2022-03-14 | Gonzales | Texas | 48177 | 4706 | 95 |
2303737 | 2303737 | 2022-03-13 | Gonzales | Texas | 48177 | 4706 | 95 |
2300485 | 2300485 | 2022-03-12 | Gonzales | Texas | 48177 | 4706 | 95 |
2297233 | 2297233 | 2022-03-11 | Gonzales | Texas | 48177 | 4706 | 95 |
2293981 | 2293981 | 2022-03-10 | Gonzales | Texas | 48177 | 4688 | 95 |
2290729 | 2290729 | 2022-03-09 | Gonzales | Texas | 48177 | 4683 | 95 |
2287477 | 2287477 | 2022-03-08 | Gonzales | Texas | 48177 | 4681 | 95 |
2284225 | 2284225 | 2022-03-07 | Gonzales | Texas | 48177 | 4679 | 95 |
2280973 | 2280973 | 2022-03-06 | Gonzales | Texas | 48177 | 4677 | 95 |
2277720 | 2277720 | 2022-03-05 | Gonzales | Texas | 48177 | 4677 | 95 |
2277808 | 2277808 | 2022-03-05 | Nolan | Texas | 48353 | 3048 | 95 |
2274467 | 2274467 | 2022-03-04 | Gonzales | Texas | 48177 | 4676 | 95 |
2274528 | 2274528 | 2022-03-04 | Llano | Texas | 48299 | 3850 | 95 |
2274555 | 2274555 | 2022-03-04 | Nolan | Texas | 48353 | 3047 | 95 |
2271214 | 2271214 | 2022-03-03 | Gonzales | Texas | 48177 | 4674 | 95 |
2271302 | 2271302 | 2022-03-03 | Nolan | Texas | 48353 | 3046 | 95 |
2267962 | 2267962 | 2022-03-02 | Gonzales | Texas | 48177 | 4673 | 95 |
2268050 | 2268050 | 2022-03-02 | Nolan | Texas | 48353 | 3046 | 95 |
2264709 | 2264709 | 2022-03-01 | Gonzales | Texas | 48177 | 4672 | 95 |
2264797 | 2264797 | 2022-03-01 | Nolan | Texas | 48353 | 3045 | 95 |
2261459 | 2261459 | 2022-02-28 | Gonzales | Texas | 48177 | 4670 | 95 |
2261547 | 2261547 | 2022-02-28 | Nolan | Texas | 48353 | 3045 | 95 |
2258208 | 2258208 | 2022-02-27 | Gonzales | Texas | 48177 | 4669 | 95 |
2258296 | 2258296 | 2022-02-27 | Nolan | Texas | 48353 | 3045 | 95 |
2254957 | 2254957 | 2022-02-26 | Gonzales | Texas | 48177 | 4669 | 95 |
2255045 | 2255045 | 2022-02-26 | Nolan | Texas | 48353 | 3045 | 95 |
2251794 | 2251794 | 2022-02-25 | Nolan | Texas | 48353 | 3045 | 95 |
2248543 | 2248543 | 2022-02-24 | Nolan | Texas | 48353 | 3042 | 95 |
2245292 | 2245292 | 2022-02-23 | Nolan | Texas | 48353 | 3041 | 95 |
2209518 | 2209518 | 2022-02-12 | Milam | Texas | 48331 | 4841 | 95 |
2209556 | 2209556 | 2022-02-12 | San Jacinto | Texas | 48407 | 5208 | 95 |
2206303 | 2206303 | 2022-02-11 | San Jacinto | Texas | 48407 | 5197 | 95 |
2203050 | 2203050 | 2022-02-10 | San Jacinto | Texas | 48407 | 5178 | 95 |
2199796 | 2199796 | 2022-02-09 | San Jacinto | Texas | 48407 | 5171 | 95 |
2193292 | 2193292 | 2022-02-07 | Scurry | Texas | 48415 | 4890 | 95 |
2190038 | 2190038 | 2022-02-06 | Scurry | Texas | 48415 | 4883 | 95 |
2186785 | 2186785 | 2022-02-05 | Scurry | Texas | 48415 | 4877 | 95 |
2183533 | 2183533 | 2022-02-04 | Scurry | Texas | 48415 | 4871 | 95 |
2180281 | 2180281 | 2022-02-03 | Scurry | Texas | 48415 | 4862 | 95 |
2177030 | 2177030 | 2022-02-02 | Scurry | Texas | 48415 | 4853 | 95 |
2173776 | 2173776 | 2022-02-01 | Scurry | Texas | 48415 | 4833 | 95 |
2170524 | 2170524 | 2022-01-31 | Scurry | Texas | 48415 | 4813 | 95 |
2170554 | 2170554 | 2022-01-31 | Waller | Texas | 48473 | 8887 | 95 |
2167270 | 2167270 | 2022-01-30 | Scurry | Texas | 48415 | 4802 | 95 |
2167300 | 2167300 | 2022-01-30 | Waller | Texas | 48473 | 8869 | 95 |
2164015 | 2164015 | 2022-01-29 | Scurry | Texas | 48415 | 4787 | 95 |
2164045 | 2164045 | 2022-01-29 | Waller | Texas | 48473 | 8841 | 95 |
2160760 | 2160760 | 2022-01-28 | Scurry | Texas | 48415 | 4762 | 95 |
2160790 | 2160790 | 2022-01-28 | Waller | Texas | 48473 | 8761 | 95 |
2157382 | 2157382 | 2022-01-27 | Gillespie | Texas | 48171 | 4816 | 95 |
2157504 | 2157504 | 2022-01-27 | Scurry | Texas | 48415 | 4736 | 95 |
2154156 | 2154156 | 2022-01-26 | Houston | Texas | 48225 | 3580 | 95 |
2154251 | 2154251 | 2022-01-26 | Scurry | Texas | 48415 | 4712 | 95 |
2150866 | 2150866 | 2022-01-25 | Fayette | Texas | 48149 | 4400 | 95 |
2150999 | 2150999 | 2022-01-25 | Scurry | Texas | 48415 | 4686 | 95 |
2147606 | 2147606 | 2022-01-24 | Eastland | Texas | 48133 | 2619 | 95 |
2147614 | 2147614 | 2022-01-24 | Fayette | Texas | 48149 | 4381 | 95 |
2147747 | 2147747 | 2022-01-24 | Scurry | Texas | 48415 | 4651 | 95 |
2144352 | 2144352 | 2022-01-23 | Eastland | Texas | 48133 | 2615 | 95 |
2144360 | 2144360 | 2022-01-23 | Fayette | Texas | 48149 | 4370 | 95 |
2144493 | 2144493 | 2022-01-23 | Scurry | Texas | 48415 | 4640 | 95 |
2141097 | 2141097 | 2022-01-22 | Eastland | Texas | 48133 | 2603 | 95 |
2141238 | 2141238 | 2022-01-22 | Scurry | Texas | 48415 | 4601 | 95 |
2137982 | 2137982 | 2022-01-21 | Scurry | Texas | 48415 | 4561 | 95 |
2134728 | 2134728 | 2022-01-20 | Scurry | Texas | 48415 | 4438 | 95 |
2131343 | 2131343 | 2022-01-19 | Fayette | Texas | 48149 | 4226 | 95 |
2131476 | 2131476 | 2022-01-19 | Scurry | Texas | 48415 | 4435 | 95 |
2128089 | 2128089 | 2022-01-18 | Fayette | Texas | 48149 | 4215 | 95 |
2128222 | 2128222 | 2022-01-18 | Scurry | Texas | 48415 | 4342 | 95 |
2124837 | 2124837 | 2022-01-17 | Fayette | Texas | 48149 | 4202 | 95 |
2124970 | 2124970 | 2022-01-17 | Scurry | Texas | 48415 | 4275 | 95 |
2121585 | 2121585 | 2022-01-16 | Fayette | Texas | 48149 | 4176 | 95 |
2121718 | 2121718 | 2022-01-16 | Scurry | Texas | 48415 | 4266 | 95 |
2118333 | 2118333 | 2022-01-15 | Fayette | Texas | 48149 | 4156 | 95 |
2118466 | 2118466 | 2022-01-15 | Scurry | Texas | 48415 | 4222 | 95 |
2115082 | 2115082 | 2022-01-14 | Fayette | Texas | 48149 | 4137 | 95 |
2115215 | 2115215 | 2022-01-14 | Scurry | Texas | 48415 | 4143 | 95 |
2111830 | 2111830 | 2022-01-13 | Fayette | Texas | 48149 | 4034 | 95 |
2111963 | 2111963 | 2022-01-13 | Scurry | Texas | 48415 | 4325 | 95 |
2108578 | 2108578 | 2022-01-12 | Fayette | Texas | 48149 | 3999 | 95 |
2108711 | 2108711 | 2022-01-12 | Scurry | Texas | 48415 | 4079 | 95 |
2105327 | 2105327 | 2022-01-11 | Fayette | Texas | 48149 | 3981 | 95 |
2105423 | 2105423 | 2022-01-11 | Moore | Texas | 48341 | 3926 | 95 |
2105460 | 2105460 | 2022-01-11 | Scurry | Texas | 48415 | 4068 | 95 |
2102076 | 2102076 | 2022-01-10 | Fayette | Texas | 48149 | 3966 | 95 |
2102172 | 2102172 | 2022-01-10 | Moore | Texas | 48341 | 3919 | 95 |
2098825 | 2098825 | 2022-01-09 | Fayette | Texas | 48149 | 3940 | 95 |
2098921 | 2098921 | 2022-01-09 | Moore | Texas | 48341 | 3913 | 95 |
2095573 | 2095573 | 2022-01-08 | Fayette | Texas | 48149 | 3928 | 95 |
2095669 | 2095669 | 2022-01-08 | Moore | Texas | 48341 | 3904 | 95 |
2092321 | 2092321 | 2022-01-07 | Fayette | Texas | 48149 | 3899 | 95 |
2092417 | 2092417 | 2022-01-07 | Moore | Texas | 48341 | 3893 | 95 |
2089069 | 2089069 | 2022-01-06 | Fayette | Texas | 48149 | 3881 | 95 |
2085818 | 2085818 | 2022-01-05 | Fayette | Texas | 48149 | 3870 | 95 |
2082566 | 2082566 | 2022-01-04 | Fayette | Texas | 48149 | 3835 | 95 |
2079314 | 2079314 | 2022-01-03 | Fayette | Texas | 48149 | 3826 | 95 |
2076063 | 2076063 | 2022-01-02 | Fayette | Texas | 48149 | 3746 | 95 |
2076078 | 2076078 | 2022-01-02 | Gray | Texas | 48179 | 4372 | 95 |
2072812 | 2072812 | 2022-01-01 | Fayette | Texas | 48149 | 3746 | 95 |
2072827 | 2072827 | 2022-01-01 | Gray | Texas | 48179 | 4372 | 95 |
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);