ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,331 rows where deaths = 27 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Haskell 118
- Ochiltree 98
- Yoakum 90
- Bandera 76
- Hamilton 67
- Hansford 65
- Lynn 60
- Garza 59
- San Saba 30
- Walker 29
- Rains 27
- Franklin 23
- Winkler 23
- Brooks 22
- Shelby 22
- Madison 20
- Coleman 19
- Clay 18
- Childress 17
- Jack 15
- Bastrop 14
- Blanco 14
- Panola 14
- Trinity 14
- Presidio 13
- Mills 12
- Austin 11
- Brewster 11
- Jefferson 11
- Swisher 11
- …
state 1
- Texas · 1,331 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2398086 | 2398086 | 2022-04-11 | Garza | Texas | 48169 | 1270 | 27 |
2394831 | 2394831 | 2022-04-10 | Garza | Texas | 48169 | 1270 | 27 |
2391575 | 2391575 | 2022-04-09 | Garza | Texas | 48169 | 1270 | 27 |
2388319 | 2388319 | 2022-04-08 | Garza | Texas | 48169 | 1270 | 27 |
2385064 | 2385064 | 2022-04-07 | Garza | Texas | 48169 | 1269 | 27 |
2381809 | 2381809 | 2022-04-06 | Garza | Texas | 48169 | 1268 | 27 |
2378554 | 2378554 | 2022-04-05 | Garza | Texas | 48169 | 1268 | 27 |
2375300 | 2375300 | 2022-04-04 | Garza | Texas | 48169 | 1266 | 27 |
2372048 | 2372048 | 2022-04-03 | Garza | Texas | 48169 | 1266 | 27 |
2368795 | 2368795 | 2022-04-02 | Garza | Texas | 48169 | 1266 | 27 |
2365542 | 2365542 | 2022-04-01 | Garza | Texas | 48169 | 1266 | 27 |
2362289 | 2362289 | 2022-03-31 | Garza | Texas | 48169 | 1266 | 27 |
2359035 | 2359035 | 2022-03-30 | Garza | Texas | 48169 | 1266 | 27 |
2355781 | 2355781 | 2022-03-29 | Garza | Texas | 48169 | 1264 | 27 |
2352528 | 2352528 | 2022-03-28 | Garza | Texas | 48169 | 1263 | 27 |
2349276 | 2349276 | 2022-03-27 | Garza | Texas | 48169 | 1262 | 27 |
2346023 | 2346023 | 2022-03-26 | Garza | Texas | 48169 | 1262 | 27 |
2342770 | 2342770 | 2022-03-25 | Garza | Texas | 48169 | 1262 | 27 |
2339517 | 2339517 | 2022-03-24 | Garza | Texas | 48169 | 1262 | 27 |
2336263 | 2336263 | 2022-03-23 | Garza | Texas | 48169 | 1262 | 27 |
2333009 | 2333009 | 2022-03-22 | Garza | Texas | 48169 | 1262 | 27 |
2329756 | 2329756 | 2022-03-21 | Garza | Texas | 48169 | 1262 | 27 |
2326504 | 2326504 | 2022-03-20 | Garza | Texas | 48169 | 1262 | 27 |
2323251 | 2323251 | 2022-03-19 | Garza | Texas | 48169 | 1262 | 27 |
2319997 | 2319997 | 2022-03-18 | Garza | Texas | 48169 | 1259 | 27 |
2316743 | 2316743 | 2022-03-17 | Garza | Texas | 48169 | 1252 | 27 |
2313490 | 2313490 | 2022-03-16 | Garza | Texas | 48169 | 1252 | 27 |
2310237 | 2310237 | 2022-03-15 | Garza | Texas | 48169 | 1242 | 27 |
2306921 | 2306921 | 2022-03-14 | Brewster | Texas | 48043 | 1054 | 27 |
2306984 | 2306984 | 2022-03-14 | Garza | Texas | 48169 | 1239 | 27 |
2303670 | 2303670 | 2022-03-13 | Brewster | Texas | 48043 | 1054 | 27 |
2303733 | 2303733 | 2022-03-13 | Garza | Texas | 48169 | 1239 | 27 |
2300418 | 2300418 | 2022-03-12 | Brewster | Texas | 48043 | 1054 | 27 |
2300481 | 2300481 | 2022-03-12 | Garza | Texas | 48169 | 1239 | 27 |
2297166 | 2297166 | 2022-03-11 | Brewster | Texas | 48043 | 1054 | 27 |
2297229 | 2297229 | 2022-03-11 | Garza | Texas | 48169 | 1236 | 27 |
2293914 | 2293914 | 2022-03-10 | Brewster | Texas | 48043 | 1054 | 27 |
2293977 | 2293977 | 2022-03-10 | Garza | Texas | 48169 | 1233 | 27 |
2290662 | 2290662 | 2022-03-09 | Brewster | Texas | 48043 | 1053 | 27 |
2290725 | 2290725 | 2022-03-09 | Garza | Texas | 48169 | 1233 | 27 |
2287410 | 2287410 | 2022-03-08 | Brewster | Texas | 48043 | 1053 | 27 |
2287473 | 2287473 | 2022-03-08 | Garza | Texas | 48169 | 1232 | 27 |
2284158 | 2284158 | 2022-03-07 | Brewster | Texas | 48043 | 1053 | 27 |
2284221 | 2284221 | 2022-03-07 | Garza | Texas | 48169 | 1232 | 27 |
2280906 | 2280906 | 2022-03-06 | Brewster | Texas | 48043 | 1052 | 27 |
2280969 | 2280969 | 2022-03-06 | Garza | Texas | 48169 | 1232 | 27 |
2277653 | 2277653 | 2022-03-05 | Brewster | Texas | 48043 | 1052 | 27 |
2277716 | 2277716 | 2022-03-05 | Garza | Texas | 48169 | 1232 | 27 |
2274400 | 2274400 | 2022-03-04 | Brewster | Texas | 48043 | 1052 | 27 |
2274463 | 2274463 | 2022-03-04 | Garza | Texas | 48169 | 1230 | 27 |
2274497 | 2274497 | 2022-03-04 | Jack | Texas | 48237 | 1491 | 27 |
2271210 | 2271210 | 2022-03-03 | Garza | Texas | 48169 | 1229 | 27 |
2271244 | 2271244 | 2022-03-03 | Jack | Texas | 48237 | 1490 | 27 |
2267958 | 2267958 | 2022-03-02 | Garza | Texas | 48169 | 1227 | 27 |
2267992 | 2267992 | 2022-03-02 | Jack | Texas | 48237 | 1486 | 27 |
2264705 | 2264705 | 2022-03-01 | Garza | Texas | 48169 | 1227 | 27 |
2264739 | 2264739 | 2022-03-01 | Jack | Texas | 48237 | 1486 | 27 |
2261455 | 2261455 | 2022-02-28 | Garza | Texas | 48169 | 1227 | 27 |
2261489 | 2261489 | 2022-02-28 | Jack | Texas | 48237 | 1482 | 27 |
2258204 | 2258204 | 2022-02-27 | Garza | Texas | 48169 | 1227 | 27 |
2258238 | 2258238 | 2022-02-27 | Jack | Texas | 48237 | 1481 | 27 |
2254953 | 2254953 | 2022-02-26 | Garza | Texas | 48169 | 1227 | 27 |
2254987 | 2254987 | 2022-02-26 | Jack | Texas | 48237 | 1481 | 27 |
2251702 | 2251702 | 2022-02-25 | Garza | Texas | 48169 | 1226 | 27 |
2251736 | 2251736 | 2022-02-25 | Jack | Texas | 48237 | 1478 | 27 |
2248451 | 2248451 | 2022-02-24 | Garza | Texas | 48169 | 1225 | 27 |
2248485 | 2248485 | 2022-02-24 | Jack | Texas | 48237 | 1477 | 27 |
2245200 | 2245200 | 2022-02-23 | Garza | Texas | 48169 | 1225 | 27 |
2245234 | 2245234 | 2022-02-23 | Jack | Texas | 48237 | 1476 | 27 |
2241869 | 2241869 | 2022-02-22 | Archer | Texas | 48009 | 2084 | 27 |
2241949 | 2241949 | 2022-02-22 | Garza | Texas | 48169 | 1225 | 27 |
2241983 | 2241983 | 2022-02-22 | Jack | Texas | 48237 | 1473 | 27 |
2238618 | 2238618 | 2022-02-21 | Archer | Texas | 48009 | 2083 | 27 |
2238698 | 2238698 | 2022-02-21 | Garza | Texas | 48169 | 1225 | 27 |
2238732 | 2238732 | 2022-02-21 | Jack | Texas | 48237 | 1472 | 27 |
2235367 | 2235367 | 2022-02-20 | Archer | Texas | 48009 | 2083 | 27 |
2235447 | 2235447 | 2022-02-20 | Garza | Texas | 48169 | 1225 | 27 |
2235481 | 2235481 | 2022-02-20 | Jack | Texas | 48237 | 1472 | 27 |
2232116 | 2232116 | 2022-02-19 | Archer | Texas | 48009 | 2081 | 27 |
2232196 | 2232196 | 2022-02-19 | Garza | Texas | 48169 | 1225 | 27 |
2232230 | 2232230 | 2022-02-19 | Jack | Texas | 48237 | 1472 | 27 |
2228865 | 2228865 | 2022-02-18 | Archer | Texas | 48009 | 2081 | 27 |
2228945 | 2228945 | 2022-02-18 | Garza | Texas | 48169 | 1221 | 27 |
2228979 | 2228979 | 2022-02-18 | Jack | Texas | 48237 | 1468 | 27 |
2225614 | 2225614 | 2022-02-17 | Archer | Texas | 48009 | 2079 | 27 |
2225694 | 2225694 | 2022-02-17 | Garza | Texas | 48169 | 1221 | 27 |
2222363 | 2222363 | 2022-02-16 | Archer | Texas | 48009 | 2076 | 27 |
2222443 | 2222443 | 2022-02-16 | Garza | Texas | 48169 | 1221 | 27 |
2219192 | 2219192 | 2022-02-15 | Garza | Texas | 48169 | 1219 | 27 |
2215894 | 2215894 | 2022-02-14 | Childress | Texas | 48075 | 2380 | 27 |
2215941 | 2215941 | 2022-02-14 | Garza | Texas | 48169 | 1219 | 27 |
2212643 | 2212643 | 2022-02-13 | Childress | Texas | 48075 | 2380 | 27 |
2212690 | 2212690 | 2022-02-13 | Garza | Texas | 48169 | 1219 | 27 |
2209390 | 2209390 | 2022-02-12 | Childress | Texas | 48075 | 2377 | 27 |
2209391 | 2209391 | 2022-02-12 | Clay | Texas | 48077 | 2023 | 27 |
2209437 | 2209437 | 2022-02-12 | Garza | Texas | 48169 | 1217 | 27 |
2206137 | 2206137 | 2022-02-11 | Childress | Texas | 48075 | 2375 | 27 |
2206138 | 2206138 | 2022-02-11 | Clay | Texas | 48077 | 2018 | 27 |
2206197 | 2206197 | 2022-02-11 | Hansford | Texas | 48195 | 1863 | 27 |
2202884 | 2202884 | 2022-02-10 | Childress | Texas | 48075 | 2359 | 27 |
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);