ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,986 rows where deaths = 8 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Reagan 228
- Motley 225
- Sutton 198
- Concho 155
- Briscoe 123
- McMullen 123
- Armstrong 87
- Throckmorton 87
- Mason 70
- Knox 64
- Real 55
- Kinney 46
- Edwards 45
- Bandera 42
- Morris 42
- Sabine 42
- San Jacinto 42
- Parmer 37
- Andrews 36
- Brewster 36
- Trinity 35
- Culberson 34
- Fannin 33
- Hudspeth 33
- Dimmit 32
- Collingsworth 29
- Hopkins 28
- Red River 28
- Dawson 26
- Victoria 26
- …
state 1
- Texas · 2,986 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502229 | 2502229 | 2022-05-13 | Briscoe | Texas | 48045 | 465 | 8 |
2502431 | 2502431 | 2022-05-13 | Throckmorton | Texas | 48447 | 271 | 8 |
2498971 | 2498971 | 2022-05-12 | Briscoe | Texas | 48045 | 465 | 8 |
2499173 | 2499173 | 2022-05-12 | Throckmorton | Texas | 48447 | 271 | 8 |
2495713 | 2495713 | 2022-05-11 | Briscoe | Texas | 48045 | 465 | 8 |
2495915 | 2495915 | 2022-05-11 | Throckmorton | Texas | 48447 | 271 | 8 |
2492455 | 2492455 | 2022-05-10 | Briscoe | Texas | 48045 | 465 | 8 |
2492657 | 2492657 | 2022-05-10 | Throckmorton | Texas | 48447 | 271 | 8 |
2489197 | 2489197 | 2022-05-09 | Briscoe | Texas | 48045 | 465 | 8 |
2489399 | 2489399 | 2022-05-09 | Throckmorton | Texas | 48447 | 270 | 8 |
2485940 | 2485940 | 2022-05-08 | Briscoe | Texas | 48045 | 465 | 8 |
2486141 | 2486141 | 2022-05-08 | Throckmorton | Texas | 48447 | 270 | 8 |
2482682 | 2482682 | 2022-05-07 | Briscoe | Texas | 48045 | 465 | 8 |
2482883 | 2482883 | 2022-05-07 | Throckmorton | Texas | 48447 | 270 | 8 |
2479424 | 2479424 | 2022-05-06 | Briscoe | Texas | 48045 | 465 | 8 |
2479625 | 2479625 | 2022-05-06 | Throckmorton | Texas | 48447 | 270 | 8 |
2476166 | 2476166 | 2022-05-05 | Briscoe | Texas | 48045 | 465 | 8 |
2476367 | 2476367 | 2022-05-05 | Throckmorton | Texas | 48447 | 270 | 8 |
2472909 | 2472909 | 2022-05-04 | Briscoe | Texas | 48045 | 465 | 8 |
2473110 | 2473110 | 2022-05-04 | Throckmorton | Texas | 48447 | 270 | 8 |
2469653 | 2469653 | 2022-05-03 | Briscoe | Texas | 48045 | 465 | 8 |
2469854 | 2469854 | 2022-05-03 | Throckmorton | Texas | 48447 | 270 | 8 |
2466397 | 2466397 | 2022-05-02 | Briscoe | Texas | 48045 | 465 | 8 |
2466598 | 2466598 | 2022-05-02 | Throckmorton | Texas | 48447 | 270 | 8 |
2463142 | 2463142 | 2022-05-01 | Briscoe | Texas | 48045 | 465 | 8 |
2463343 | 2463343 | 2022-05-01 | Throckmorton | Texas | 48447 | 270 | 8 |
2459886 | 2459886 | 2022-04-30 | Briscoe | Texas | 48045 | 465 | 8 |
2460087 | 2460087 | 2022-04-30 | Throckmorton | Texas | 48447 | 270 | 8 |
2456630 | 2456630 | 2022-04-29 | Briscoe | Texas | 48045 | 465 | 8 |
2456831 | 2456831 | 2022-04-29 | Throckmorton | Texas | 48447 | 270 | 8 |
2453374 | 2453374 | 2022-04-28 | Briscoe | Texas | 48045 | 465 | 8 |
2453575 | 2453575 | 2022-04-28 | Throckmorton | Texas | 48447 | 269 | 8 |
2450118 | 2450118 | 2022-04-27 | Briscoe | Texas | 48045 | 465 | 8 |
2450319 | 2450319 | 2022-04-27 | Throckmorton | Texas | 48447 | 269 | 8 |
2446861 | 2446861 | 2022-04-26 | Briscoe | Texas | 48045 | 465 | 8 |
2447062 | 2447062 | 2022-04-26 | Throckmorton | Texas | 48447 | 269 | 8 |
2443606 | 2443606 | 2022-04-25 | Briscoe | Texas | 48045 | 465 | 8 |
2443807 | 2443807 | 2022-04-25 | Throckmorton | Texas | 48447 | 269 | 8 |
2440350 | 2440350 | 2022-04-24 | Briscoe | Texas | 48045 | 465 | 8 |
2440551 | 2440551 | 2022-04-24 | Throckmorton | Texas | 48447 | 269 | 8 |
2437094 | 2437094 | 2022-04-23 | Briscoe | Texas | 48045 | 465 | 8 |
2437295 | 2437295 | 2022-04-23 | Throckmorton | Texas | 48447 | 269 | 8 |
2433838 | 2433838 | 2022-04-22 | Briscoe | Texas | 48045 | 465 | 8 |
2434039 | 2434039 | 2022-04-22 | Throckmorton | Texas | 48447 | 269 | 8 |
2430582 | 2430582 | 2022-04-21 | Briscoe | Texas | 48045 | 465 | 8 |
2430783 | 2430783 | 2022-04-21 | Throckmorton | Texas | 48447 | 269 | 8 |
2427326 | 2427326 | 2022-04-20 | Briscoe | Texas | 48045 | 464 | 8 |
2427527 | 2427527 | 2022-04-20 | Throckmorton | Texas | 48447 | 269 | 8 |
2424070 | 2424070 | 2022-04-19 | Briscoe | Texas | 48045 | 463 | 8 |
2424271 | 2424271 | 2022-04-19 | Throckmorton | Texas | 48447 | 269 | 8 |
2420814 | 2420814 | 2022-04-18 | Briscoe | Texas | 48045 | 463 | 8 |
2421015 | 2421015 | 2022-04-18 | Throckmorton | Texas | 48447 | 269 | 8 |
2417558 | 2417558 | 2022-04-17 | Briscoe | Texas | 48045 | 463 | 8 |
2417759 | 2417759 | 2022-04-17 | Throckmorton | Texas | 48447 | 269 | 8 |
2414302 | 2414302 | 2022-04-16 | Briscoe | Texas | 48045 | 463 | 8 |
2414503 | 2414503 | 2022-04-16 | Throckmorton | Texas | 48447 | 269 | 8 |
2411046 | 2411046 | 2022-04-15 | Briscoe | Texas | 48045 | 463 | 8 |
2411247 | 2411247 | 2022-04-15 | Throckmorton | Texas | 48447 | 269 | 8 |
2407790 | 2407790 | 2022-04-14 | Briscoe | Texas | 48045 | 463 | 8 |
2407991 | 2407991 | 2022-04-14 | Throckmorton | Texas | 48447 | 269 | 8 |
2404534 | 2404534 | 2022-04-13 | Briscoe | Texas | 48045 | 463 | 8 |
2404735 | 2404735 | 2022-04-13 | Throckmorton | Texas | 48447 | 269 | 8 |
2401279 | 2401279 | 2022-04-12 | Briscoe | Texas | 48045 | 462 | 8 |
2401480 | 2401480 | 2022-04-12 | Throckmorton | Texas | 48447 | 269 | 8 |
2398024 | 2398024 | 2022-04-11 | Briscoe | Texas | 48045 | 462 | 8 |
2398225 | 2398225 | 2022-04-11 | Throckmorton | Texas | 48447 | 269 | 8 |
2394769 | 2394769 | 2022-04-10 | Briscoe | Texas | 48045 | 462 | 8 |
2394970 | 2394970 | 2022-04-10 | Throckmorton | Texas | 48447 | 269 | 8 |
2391513 | 2391513 | 2022-04-09 | Briscoe | Texas | 48045 | 462 | 8 |
2391714 | 2391714 | 2022-04-09 | Throckmorton | Texas | 48447 | 269 | 8 |
2388257 | 2388257 | 2022-04-08 | Briscoe | Texas | 48045 | 462 | 8 |
2388458 | 2388458 | 2022-04-08 | Throckmorton | Texas | 48447 | 269 | 8 |
2385002 | 2385002 | 2022-04-07 | Briscoe | Texas | 48045 | 462 | 8 |
2385203 | 2385203 | 2022-04-07 | Throckmorton | Texas | 48447 | 269 | 8 |
2381747 | 2381747 | 2022-04-06 | Briscoe | Texas | 48045 | 461 | 8 |
2381948 | 2381948 | 2022-04-06 | Throckmorton | Texas | 48447 | 269 | 8 |
2378492 | 2378492 | 2022-04-05 | Briscoe | Texas | 48045 | 461 | 8 |
2378693 | 2378693 | 2022-04-05 | Throckmorton | Texas | 48447 | 269 | 8 |
2375238 | 2375238 | 2022-04-04 | Briscoe | Texas | 48045 | 461 | 8 |
2375439 | 2375439 | 2022-04-04 | Throckmorton | Texas | 48447 | 269 | 8 |
2371986 | 2371986 | 2022-04-03 | Briscoe | Texas | 48045 | 456 | 8 |
2372187 | 2372187 | 2022-04-03 | Throckmorton | Texas | 48447 | 269 | 8 |
2368733 | 2368733 | 2022-04-02 | Briscoe | Texas | 48045 | 456 | 8 |
2368934 | 2368934 | 2022-04-02 | Throckmorton | Texas | 48447 | 269 | 8 |
2365480 | 2365480 | 2022-04-01 | Briscoe | Texas | 48045 | 455 | 8 |
2365681 | 2365681 | 2022-04-01 | Throckmorton | Texas | 48447 | 269 | 8 |
2362227 | 2362227 | 2022-03-31 | Briscoe | Texas | 48045 | 455 | 8 |
2362428 | 2362428 | 2022-03-31 | Throckmorton | Texas | 48447 | 268 | 8 |
2358973 | 2358973 | 2022-03-30 | Briscoe | Texas | 48045 | 455 | 8 |
2359174 | 2359174 | 2022-03-30 | Throckmorton | Texas | 48447 | 268 | 8 |
2355719 | 2355719 | 2022-03-29 | Briscoe | Texas | 48045 | 455 | 8 |
2355920 | 2355920 | 2022-03-29 | Throckmorton | Texas | 48447 | 268 | 8 |
2352466 | 2352466 | 2022-03-28 | Briscoe | Texas | 48045 | 455 | 8 |
2352667 | 2352667 | 2022-03-28 | Throckmorton | Texas | 48447 | 268 | 8 |
2349214 | 2349214 | 2022-03-27 | Briscoe | Texas | 48045 | 455 | 8 |
2349415 | 2349415 | 2022-03-27 | Throckmorton | Texas | 48447 | 268 | 8 |
2345961 | 2345961 | 2022-03-26 | Briscoe | Texas | 48045 | 455 | 8 |
2346162 | 2346162 | 2022-03-26 | Throckmorton | Texas | 48447 | 268 | 8 |
2342708 | 2342708 | 2022-03-25 | Briscoe | Texas | 48045 | 455 | 8 |
2342909 | 2342909 | 2022-03-25 | Throckmorton | Texas | 48447 | 268 | 8 |
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);