ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,845 rows where deaths = 7 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Cottle 222
- Briscoe 168
- Armstrong 153
- Stonewall 113
- Throckmorton 99
- Crockett 74
- Hemphill 72
- Parmer 65
- Presidio 63
- Dimmit 60
- Edwards 56
- Mason 50
- Kimble 49
- Upton 49
- Martin 46
- Calhoun 45
- Culberson 41
- Dickens 39
- Trinity 39
- Motley 37
- Comal 34
- Schleicher 33
- Blanco 29
- Randall 29
- Jim Hogg 28
- Castro 26
- Hamilton 26
- Wheeler 26
- Frio 24
- Victoria 24
- …
state 1
- Texas · 2,845 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502312 | 2502312 | 2022-05-13 | Hemphill | Texas | 48211 | 1239 | 7 |
2502424 | 2502424 | 2022-05-13 | Stonewall | Texas | 48433 | 362 | 7 |
2499054 | 2499054 | 2022-05-12 | Hemphill | Texas | 48211 | 1238 | 7 |
2499166 | 2499166 | 2022-05-12 | Stonewall | Texas | 48433 | 362 | 7 |
2495796 | 2495796 | 2022-05-11 | Hemphill | Texas | 48211 | 1238 | 7 |
2495908 | 2495908 | 2022-05-11 | Stonewall | Texas | 48433 | 362 | 7 |
2492538 | 2492538 | 2022-05-10 | Hemphill | Texas | 48211 | 1236 | 7 |
2492650 | 2492650 | 2022-05-10 | Stonewall | Texas | 48433 | 362 | 7 |
2489280 | 2489280 | 2022-05-09 | Hemphill | Texas | 48211 | 1236 | 7 |
2489392 | 2489392 | 2022-05-09 | Stonewall | Texas | 48433 | 362 | 7 |
2486023 | 2486023 | 2022-05-08 | Hemphill | Texas | 48211 | 1236 | 7 |
2486134 | 2486134 | 2022-05-08 | Stonewall | Texas | 48433 | 362 | 7 |
2482765 | 2482765 | 2022-05-07 | Hemphill | Texas | 48211 | 1236 | 7 |
2482876 | 2482876 | 2022-05-07 | Stonewall | Texas | 48433 | 362 | 7 |
2479507 | 2479507 | 2022-05-06 | Hemphill | Texas | 48211 | 1236 | 7 |
2479618 | 2479618 | 2022-05-06 | Stonewall | Texas | 48433 | 362 | 7 |
2476249 | 2476249 | 2022-05-05 | Hemphill | Texas | 48211 | 1236 | 7 |
2476360 | 2476360 | 2022-05-05 | Stonewall | Texas | 48433 | 362 | 7 |
2472992 | 2472992 | 2022-05-04 | Hemphill | Texas | 48211 | 1236 | 7 |
2473103 | 2473103 | 2022-05-04 | Stonewall | Texas | 48433 | 362 | 7 |
2469736 | 2469736 | 2022-05-03 | Hemphill | Texas | 48211 | 1236 | 7 |
2469847 | 2469847 | 2022-05-03 | Stonewall | Texas | 48433 | 362 | 7 |
2466480 | 2466480 | 2022-05-02 | Hemphill | Texas | 48211 | 1236 | 7 |
2466591 | 2466591 | 2022-05-02 | Stonewall | Texas | 48433 | 362 | 7 |
2463225 | 2463225 | 2022-05-01 | Hemphill | Texas | 48211 | 1236 | 7 |
2463336 | 2463336 | 2022-05-01 | Stonewall | Texas | 48433 | 362 | 7 |
2459969 | 2459969 | 2022-04-30 | Hemphill | Texas | 48211 | 1236 | 7 |
2460080 | 2460080 | 2022-04-30 | Stonewall | Texas | 48433 | 362 | 7 |
2456713 | 2456713 | 2022-04-29 | Hemphill | Texas | 48211 | 1236 | 7 |
2456824 | 2456824 | 2022-04-29 | Stonewall | Texas | 48433 | 359 | 7 |
2453457 | 2453457 | 2022-04-28 | Hemphill | Texas | 48211 | 1236 | 7 |
2453568 | 2453568 | 2022-04-28 | Stonewall | Texas | 48433 | 359 | 7 |
2450201 | 2450201 | 2022-04-27 | Hemphill | Texas | 48211 | 1236 | 7 |
2450312 | 2450312 | 2022-04-27 | Stonewall | Texas | 48433 | 359 | 7 |
2446944 | 2446944 | 2022-04-26 | Hemphill | Texas | 48211 | 1235 | 7 |
2447055 | 2447055 | 2022-04-26 | Stonewall | Texas | 48433 | 359 | 7 |
2443689 | 2443689 | 2022-04-25 | Hemphill | Texas | 48211 | 1235 | 7 |
2443800 | 2443800 | 2022-04-25 | Stonewall | Texas | 48433 | 359 | 7 |
2440433 | 2440433 | 2022-04-24 | Hemphill | Texas | 48211 | 1235 | 7 |
2440544 | 2440544 | 2022-04-24 | Stonewall | Texas | 48433 | 359 | 7 |
2437177 | 2437177 | 2022-04-23 | Hemphill | Texas | 48211 | 1235 | 7 |
2437288 | 2437288 | 2022-04-23 | Stonewall | Texas | 48433 | 359 | 7 |
2433921 | 2433921 | 2022-04-22 | Hemphill | Texas | 48211 | 1235 | 7 |
2434032 | 2434032 | 2022-04-22 | Stonewall | Texas | 48433 | 358 | 7 |
2430665 | 2430665 | 2022-04-21 | Hemphill | Texas | 48211 | 1235 | 7 |
2430776 | 2430776 | 2022-04-21 | Stonewall | Texas | 48433 | 358 | 7 |
2427409 | 2427409 | 2022-04-20 | Hemphill | Texas | 48211 | 1235 | 7 |
2427520 | 2427520 | 2022-04-20 | Stonewall | Texas | 48433 | 358 | 7 |
2424153 | 2424153 | 2022-04-19 | Hemphill | Texas | 48211 | 1235 | 7 |
2424264 | 2424264 | 2022-04-19 | Stonewall | Texas | 48433 | 358 | 7 |
2420897 | 2420897 | 2022-04-18 | Hemphill | Texas | 48211 | 1235 | 7 |
2421008 | 2421008 | 2022-04-18 | Stonewall | Texas | 48433 | 357 | 7 |
2417641 | 2417641 | 2022-04-17 | Hemphill | Texas | 48211 | 1235 | 7 |
2417752 | 2417752 | 2022-04-17 | Stonewall | Texas | 48433 | 357 | 7 |
2414385 | 2414385 | 2022-04-16 | Hemphill | Texas | 48211 | 1235 | 7 |
2414496 | 2414496 | 2022-04-16 | Stonewall | Texas | 48433 | 357 | 7 |
2411129 | 2411129 | 2022-04-15 | Hemphill | Texas | 48211 | 1235 | 7 |
2411240 | 2411240 | 2022-04-15 | Stonewall | Texas | 48433 | 357 | 7 |
2407873 | 2407873 | 2022-04-14 | Hemphill | Texas | 48211 | 1235 | 7 |
2407984 | 2407984 | 2022-04-14 | Stonewall | Texas | 48433 | 357 | 7 |
2404617 | 2404617 | 2022-04-13 | Hemphill | Texas | 48211 | 1235 | 7 |
2404728 | 2404728 | 2022-04-13 | Stonewall | Texas | 48433 | 356 | 7 |
2401362 | 2401362 | 2022-04-12 | Hemphill | Texas | 48211 | 1235 | 7 |
2401473 | 2401473 | 2022-04-12 | Stonewall | Texas | 48433 | 356 | 7 |
2398107 | 2398107 | 2022-04-11 | Hemphill | Texas | 48211 | 1235 | 7 |
2398218 | 2398218 | 2022-04-11 | Stonewall | Texas | 48433 | 356 | 7 |
2394852 | 2394852 | 2022-04-10 | Hemphill | Texas | 48211 | 1235 | 7 |
2394963 | 2394963 | 2022-04-10 | Stonewall | Texas | 48433 | 356 | 7 |
2391596 | 2391596 | 2022-04-09 | Hemphill | Texas | 48211 | 1235 | 7 |
2391707 | 2391707 | 2022-04-09 | Stonewall | Texas | 48433 | 356 | 7 |
2388340 | 2388340 | 2022-04-08 | Hemphill | Texas | 48211 | 1234 | 7 |
2388451 | 2388451 | 2022-04-08 | Stonewall | Texas | 48433 | 356 | 7 |
2385085 | 2385085 | 2022-04-07 | Hemphill | Texas | 48211 | 1232 | 7 |
2385196 | 2385196 | 2022-04-07 | Stonewall | Texas | 48433 | 355 | 7 |
2381830 | 2381830 | 2022-04-06 | Hemphill | Texas | 48211 | 1232 | 7 |
2381941 | 2381941 | 2022-04-06 | Stonewall | Texas | 48433 | 355 | 7 |
2378575 | 2378575 | 2022-04-05 | Hemphill | Texas | 48211 | 1232 | 7 |
2378686 | 2378686 | 2022-04-05 | Stonewall | Texas | 48433 | 355 | 7 |
2375321 | 2375321 | 2022-04-04 | Hemphill | Texas | 48211 | 1232 | 7 |
2375432 | 2375432 | 2022-04-04 | Stonewall | Texas | 48433 | 355 | 7 |
2372069 | 2372069 | 2022-04-03 | Hemphill | Texas | 48211 | 1232 | 7 |
2372180 | 2372180 | 2022-04-03 | Stonewall | Texas | 48433 | 355 | 7 |
2368816 | 2368816 | 2022-04-02 | Hemphill | Texas | 48211 | 1232 | 7 |
2368927 | 2368927 | 2022-04-02 | Stonewall | Texas | 48433 | 354 | 7 |
2365563 | 2365563 | 2022-04-01 | Hemphill | Texas | 48211 | 1232 | 7 |
2365674 | 2365674 | 2022-04-01 | Stonewall | Texas | 48433 | 354 | 7 |
2362310 | 2362310 | 2022-03-31 | Hemphill | Texas | 48211 | 1231 | 7 |
2362421 | 2362421 | 2022-03-31 | Stonewall | Texas | 48433 | 354 | 7 |
2359056 | 2359056 | 2022-03-30 | Hemphill | Texas | 48211 | 1231 | 7 |
2359167 | 2359167 | 2022-03-30 | Stonewall | Texas | 48433 | 354 | 7 |
2355802 | 2355802 | 2022-03-29 | Hemphill | Texas | 48211 | 1231 | 7 |
2355913 | 2355913 | 2022-03-29 | Stonewall | Texas | 48433 | 354 | 7 |
2352549 | 2352549 | 2022-03-28 | Hemphill | Texas | 48211 | 1231 | 7 |
2352660 | 2352660 | 2022-03-28 | Stonewall | Texas | 48433 | 354 | 7 |
2349297 | 2349297 | 2022-03-27 | Hemphill | Texas | 48211 | 1231 | 7 |
2349408 | 2349408 | 2022-03-27 | Stonewall | Texas | 48433 | 354 | 7 |
2346044 | 2346044 | 2022-03-26 | Hemphill | Texas | 48211 | 1231 | 7 |
2346155 | 2346155 | 2022-03-26 | Stonewall | Texas | 48433 | 354 | 7 |
2342791 | 2342791 | 2022-03-25 | Hemphill | Texas | 48211 | 1231 | 7 |
2342902 | 2342902 | 2022-03-25 | Stonewall | Texas | 48433 | 353 | 7 |
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);