ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
7,639 rows where deaths = 1 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Roberts 456
- Irion 245
- Oldham 208
- Briscoe 154
- Hall 153
- Crosby 134
- Fisher 120
- Erath 115
- Castro 114
- Kent 114
- Limestone 112
- Montague 112
- Dawson 109
- Ward 107
- Donley 105
- Hockley 103
- Young 103
- McMullen 101
- Howard 98
- Kleberg 97
- Stonewall 96
- Tom Green 95
- Lavaca 93
- Comanche 88
- Hill 85
- Van Zandt 85
- Lynn 84
- Armstrong 83
- Martin 83
- Milam 83
- …
state 1
- Texas · 7,639 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502357 | 2502357 | 2022-05-13 | Loving | Texas | 48301 | 196 | 1 |
2499099 | 2499099 | 2022-05-12 | Loving | Texas | 48301 | 196 | 1 |
2495841 | 2495841 | 2022-05-11 | Loving | Texas | 48301 | 195 | 1 |
2492583 | 2492583 | 2022-05-10 | Loving | Texas | 48301 | 195 | 1 |
2489325 | 2489325 | 2022-05-09 | Loving | Texas | 48301 | 195 | 1 |
2486068 | 2486068 | 2022-05-08 | Loving | Texas | 48301 | 194 | 1 |
2482810 | 2482810 | 2022-05-07 | Loving | Texas | 48301 | 192 | 1 |
2479552 | 2479552 | 2022-05-06 | Loving | Texas | 48301 | 191 | 1 |
2476294 | 2476294 | 2022-05-05 | Loving | Texas | 48301 | 191 | 1 |
2473037 | 2473037 | 2022-05-04 | Loving | Texas | 48301 | 190 | 1 |
2469781 | 2469781 | 2022-05-03 | Loving | Texas | 48301 | 189 | 1 |
2466525 | 2466525 | 2022-05-02 | Loving | Texas | 48301 | 187 | 1 |
2463270 | 2463270 | 2022-05-01 | Loving | Texas | 48301 | 186 | 1 |
2460014 | 2460014 | 2022-04-30 | Loving | Texas | 48301 | 186 | 1 |
2456758 | 2456758 | 2022-04-29 | Loving | Texas | 48301 | 186 | 1 |
2453502 | 2453502 | 2022-04-28 | Loving | Texas | 48301 | 186 | 1 |
2450246 | 2450246 | 2022-04-27 | Loving | Texas | 48301 | 186 | 1 |
2446989 | 2446989 | 2022-04-26 | Loving | Texas | 48301 | 186 | 1 |
2443734 | 2443734 | 2022-04-25 | Loving | Texas | 48301 | 186 | 1 |
2440478 | 2440478 | 2022-04-24 | Loving | Texas | 48301 | 186 | 1 |
2437222 | 2437222 | 2022-04-23 | Loving | Texas | 48301 | 186 | 1 |
2433966 | 2433966 | 2022-04-22 | Loving | Texas | 48301 | 186 | 1 |
2430710 | 2430710 | 2022-04-21 | Loving | Texas | 48301 | 186 | 1 |
2427454 | 2427454 | 2022-04-20 | Loving | Texas | 48301 | 185 | 1 |
2424198 | 2424198 | 2022-04-19 | Loving | Texas | 48301 | 185 | 1 |
2420942 | 2420942 | 2022-04-18 | Loving | Texas | 48301 | 185 | 1 |
2417686 | 2417686 | 2022-04-17 | Loving | Texas | 48301 | 185 | 1 |
2414430 | 2414430 | 2022-04-16 | Loving | Texas | 48301 | 185 | 1 |
2411174 | 2411174 | 2022-04-15 | Loving | Texas | 48301 | 185 | 1 |
2407918 | 2407918 | 2022-04-14 | Loving | Texas | 48301 | 185 | 1 |
2404662 | 2404662 | 2022-04-13 | Loving | Texas | 48301 | 185 | 1 |
2401407 | 2401407 | 2022-04-12 | Loving | Texas | 48301 | 185 | 1 |
2398152 | 2398152 | 2022-04-11 | Loving | Texas | 48301 | 184 | 1 |
2394897 | 2394897 | 2022-04-10 | Loving | Texas | 48301 | 184 | 1 |
2391641 | 2391641 | 2022-04-09 | Loving | Texas | 48301 | 182 | 1 |
2388385 | 2388385 | 2022-04-08 | Loving | Texas | 48301 | 182 | 1 |
2385130 | 2385130 | 2022-04-07 | Loving | Texas | 48301 | 180 | 1 |
2381875 | 2381875 | 2022-04-06 | Loving | Texas | 48301 | 178 | 1 |
2378620 | 2378620 | 2022-04-05 | Loving | Texas | 48301 | 175 | 1 |
2375366 | 2375366 | 2022-04-04 | Loving | Texas | 48301 | 173 | 1 |
2372114 | 2372114 | 2022-04-03 | Loving | Texas | 48301 | 171 | 1 |
2368861 | 2368861 | 2022-04-02 | Loving | Texas | 48301 | 171 | 1 |
2365608 | 2365608 | 2022-04-01 | Loving | Texas | 48301 | 171 | 1 |
2362355 | 2362355 | 2022-03-31 | Loving | Texas | 48301 | 171 | 1 |
2359101 | 2359101 | 2022-03-30 | Loving | Texas | 48301 | 171 | 1 |
2355847 | 2355847 | 2022-03-29 | Loving | Texas | 48301 | 171 | 1 |
2352594 | 2352594 | 2022-03-28 | Loving | Texas | 48301 | 171 | 1 |
2349342 | 2349342 | 2022-03-27 | Loving | Texas | 48301 | 171 | 1 |
2346089 | 2346089 | 2022-03-26 | Loving | Texas | 48301 | 170 | 1 |
2342836 | 2342836 | 2022-03-25 | Loving | Texas | 48301 | 170 | 1 |
2339583 | 2339583 | 2022-03-24 | Loving | Texas | 48301 | 170 | 1 |
2336329 | 2336329 | 2022-03-23 | Loving | Texas | 48301 | 170 | 1 |
2333075 | 2333075 | 2022-03-22 | Loving | Texas | 48301 | 169 | 1 |
2329822 | 2329822 | 2022-03-21 | Loving | Texas | 48301 | 168 | 1 |
2326570 | 2326570 | 2022-03-20 | Loving | Texas | 48301 | 168 | 1 |
2323317 | 2323317 | 2022-03-19 | Loving | Texas | 48301 | 167 | 1 |
2320063 | 2320063 | 2022-03-18 | Loving | Texas | 48301 | 167 | 1 |
2316809 | 2316809 | 2022-03-17 | Loving | Texas | 48301 | 167 | 1 |
2313556 | 2313556 | 2022-03-16 | Loving | Texas | 48301 | 167 | 1 |
2310303 | 2310303 | 2022-03-15 | Loving | Texas | 48301 | 166 | 1 |
2307050 | 2307050 | 2022-03-14 | Loving | Texas | 48301 | 166 | 1 |
2303799 | 2303799 | 2022-03-13 | Loving | Texas | 48301 | 166 | 1 |
2300547 | 2300547 | 2022-03-12 | Loving | Texas | 48301 | 166 | 1 |
2297295 | 2297295 | 2022-03-11 | Loving | Texas | 48301 | 166 | 1 |
2294043 | 2294043 | 2022-03-10 | Loving | Texas | 48301 | 166 | 1 |
2290791 | 2290791 | 2022-03-09 | Loving | Texas | 48301 | 166 | 1 |
2287539 | 2287539 | 2022-03-08 | Loving | Texas | 48301 | 165 | 1 |
2284287 | 2284287 | 2022-03-07 | Loving | Texas | 48301 | 165 | 1 |
2281035 | 2281035 | 2022-03-06 | Loving | Texas | 48301 | 165 | 1 |
2277782 | 2277782 | 2022-03-05 | Loving | Texas | 48301 | 165 | 1 |
2274529 | 2274529 | 2022-03-04 | Loving | Texas | 48301 | 165 | 1 |
2248563 | 2248563 | 2022-02-24 | Roberts | Texas | 48393 | 170 | 1 |
2245312 | 2245312 | 2022-02-23 | Roberts | Texas | 48393 | 170 | 1 |
2242061 | 2242061 | 2022-02-22 | Roberts | Texas | 48393 | 166 | 1 |
2238810 | 2238810 | 2022-02-21 | Roberts | Texas | 48393 | 166 | 1 |
2235559 | 2235559 | 2022-02-20 | Roberts | Texas | 48393 | 166 | 1 |
2232308 | 2232308 | 2022-02-19 | Roberts | Texas | 48393 | 166 | 1 |
2229057 | 2229057 | 2022-02-18 | Roberts | Texas | 48393 | 165 | 1 |
2225806 | 2225806 | 2022-02-17 | Roberts | Texas | 48393 | 165 | 1 |
2222555 | 2222555 | 2022-02-16 | Roberts | Texas | 48393 | 164 | 1 |
2219304 | 2219304 | 2022-02-15 | Roberts | Texas | 48393 | 163 | 1 |
2216053 | 2216053 | 2022-02-14 | Roberts | Texas | 48393 | 163 | 1 |
2212802 | 2212802 | 2022-02-13 | Roberts | Texas | 48393 | 163 | 1 |
2209549 | 2209549 | 2022-02-12 | Roberts | Texas | 48393 | 163 | 1 |
2206296 | 2206296 | 2022-02-11 | Roberts | Texas | 48393 | 163 | 1 |
2203043 | 2203043 | 2022-02-10 | Roberts | Texas | 48393 | 163 | 1 |
2199789 | 2199789 | 2022-02-09 | Roberts | Texas | 48393 | 161 | 1 |
2196535 | 2196535 | 2022-02-08 | Roberts | Texas | 48393 | 161 | 1 |
2193281 | 2193281 | 2022-02-07 | Roberts | Texas | 48393 | 161 | 1 |
2190027 | 2190027 | 2022-02-06 | Roberts | Texas | 48393 | 161 | 1 |
2186774 | 2186774 | 2022-02-05 | Roberts | Texas | 48393 | 160 | 1 |
2183522 | 2183522 | 2022-02-04 | Roberts | Texas | 48393 | 160 | 1 |
2180270 | 2180270 | 2022-02-03 | Roberts | Texas | 48393 | 159 | 1 |
2177019 | 2177019 | 2022-02-02 | Roberts | Texas | 48393 | 159 | 1 |
2173765 | 2173765 | 2022-02-01 | Roberts | Texas | 48393 | 159 | 1 |
2170513 | 2170513 | 2022-01-31 | Roberts | Texas | 48393 | 156 | 1 |
2167259 | 2167259 | 2022-01-30 | Roberts | Texas | 48393 | 156 | 1 |
2164004 | 2164004 | 2022-01-29 | Roberts | Texas | 48393 | 156 | 1 |
2160749 | 2160749 | 2022-01-28 | Roberts | Texas | 48393 | 156 | 1 |
2157493 | 2157493 | 2022-01-27 | Roberts | Texas | 48393 | 155 | 1 |
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);