ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,192 rows where deaths = 16 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Sherman 166
- Jack 153
- Clay 147
- Jim Hogg 108
- Dickens 95
- Collingsworth 85
- Crockett 74
- Jackson 73
- Brewster 71
- Hudspeth 59
- Lipscomb 59
- Fisher 56
- Refugio 56
- Goliad 38
- Bailey 35
- Coke 35
- Limestone 34
- Bosque 28
- Newton 28
- Hill 27
- Madison 24
- Zavala 24
- Cochran 21
- Garza 20
- Karnes 20
- Rockwall 19
- Floyd 18
- Brazos 17
- Live Oak 17
- Aransas 16
- …
state 1
- Texas · 2,192 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502250 | 2502250 | 2022-05-13 | Collingsworth | Texas | 48087 | 702 | 16 |
2502269 | 2502269 | 2022-05-13 | Dickens | Texas | 48125 | 453 | 16 |
2502354 | 2502354 | 2022-05-13 | Lipscomb | Texas | 48295 | 720 | 16 |
2502418 | 2502418 | 2022-05-13 | Sherman | Texas | 48421 | 499 | 16 |
2498992 | 2498992 | 2022-05-12 | Collingsworth | Texas | 48087 | 702 | 16 |
2499011 | 2499011 | 2022-05-12 | Dickens | Texas | 48125 | 453 | 16 |
2499096 | 2499096 | 2022-05-12 | Lipscomb | Texas | 48295 | 720 | 16 |
2499160 | 2499160 | 2022-05-12 | Sherman | Texas | 48421 | 499 | 16 |
2495734 | 2495734 | 2022-05-11 | Collingsworth | Texas | 48087 | 702 | 16 |
2495753 | 2495753 | 2022-05-11 | Dickens | Texas | 48125 | 453 | 16 |
2495838 | 2495838 | 2022-05-11 | Lipscomb | Texas | 48295 | 720 | 16 |
2495902 | 2495902 | 2022-05-11 | Sherman | Texas | 48421 | 499 | 16 |
2492476 | 2492476 | 2022-05-10 | Collingsworth | Texas | 48087 | 702 | 16 |
2492495 | 2492495 | 2022-05-10 | Dickens | Texas | 48125 | 453 | 16 |
2492644 | 2492644 | 2022-05-10 | Sherman | Texas | 48421 | 499 | 16 |
2489218 | 2489218 | 2022-05-09 | Collingsworth | Texas | 48087 | 702 | 16 |
2489237 | 2489237 | 2022-05-09 | Dickens | Texas | 48125 | 453 | 16 |
2489386 | 2489386 | 2022-05-09 | Sherman | Texas | 48421 | 499 | 16 |
2485961 | 2485961 | 2022-05-08 | Collingsworth | Texas | 48087 | 702 | 16 |
2485980 | 2485980 | 2022-05-08 | Dickens | Texas | 48125 | 453 | 16 |
2486128 | 2486128 | 2022-05-08 | Sherman | Texas | 48421 | 499 | 16 |
2482703 | 2482703 | 2022-05-07 | Collingsworth | Texas | 48087 | 702 | 16 |
2482722 | 2482722 | 2022-05-07 | Dickens | Texas | 48125 | 453 | 16 |
2482870 | 2482870 | 2022-05-07 | Sherman | Texas | 48421 | 499 | 16 |
2479445 | 2479445 | 2022-05-06 | Collingsworth | Texas | 48087 | 702 | 16 |
2479464 | 2479464 | 2022-05-06 | Dickens | Texas | 48125 | 453 | 16 |
2479612 | 2479612 | 2022-05-06 | Sherman | Texas | 48421 | 499 | 16 |
2476187 | 2476187 | 2022-05-05 | Collingsworth | Texas | 48087 | 702 | 16 |
2476206 | 2476206 | 2022-05-05 | Dickens | Texas | 48125 | 453 | 16 |
2476354 | 2476354 | 2022-05-05 | Sherman | Texas | 48421 | 499 | 16 |
2472930 | 2472930 | 2022-05-04 | Collingsworth | Texas | 48087 | 702 | 16 |
2472949 | 2472949 | 2022-05-04 | Dickens | Texas | 48125 | 453 | 16 |
2473034 | 2473034 | 2022-05-04 | Lipscomb | Texas | 48295 | 720 | 16 |
2473097 | 2473097 | 2022-05-04 | Sherman | Texas | 48421 | 499 | 16 |
2469674 | 2469674 | 2022-05-03 | Collingsworth | Texas | 48087 | 702 | 16 |
2469693 | 2469693 | 2022-05-03 | Dickens | Texas | 48125 | 452 | 16 |
2469778 | 2469778 | 2022-05-03 | Lipscomb | Texas | 48295 | 720 | 16 |
2469841 | 2469841 | 2022-05-03 | Sherman | Texas | 48421 | 499 | 16 |
2466418 | 2466418 | 2022-05-02 | Collingsworth | Texas | 48087 | 702 | 16 |
2466437 | 2466437 | 2022-05-02 | Dickens | Texas | 48125 | 452 | 16 |
2466522 | 2466522 | 2022-05-02 | Lipscomb | Texas | 48295 | 720 | 16 |
2466585 | 2466585 | 2022-05-02 | Sherman | Texas | 48421 | 499 | 16 |
2463163 | 2463163 | 2022-05-01 | Collingsworth | Texas | 48087 | 702 | 16 |
2463182 | 2463182 | 2022-05-01 | Dickens | Texas | 48125 | 452 | 16 |
2463267 | 2463267 | 2022-05-01 | Lipscomb | Texas | 48295 | 720 | 16 |
2463330 | 2463330 | 2022-05-01 | Sherman | Texas | 48421 | 499 | 16 |
2459907 | 2459907 | 2022-04-30 | Collingsworth | Texas | 48087 | 702 | 16 |
2459926 | 2459926 | 2022-04-30 | Dickens | Texas | 48125 | 452 | 16 |
2460011 | 2460011 | 2022-04-30 | Lipscomb | Texas | 48295 | 720 | 16 |
2460074 | 2460074 | 2022-04-30 | Sherman | Texas | 48421 | 499 | 16 |
2456651 | 2456651 | 2022-04-29 | Collingsworth | Texas | 48087 | 702 | 16 |
2456670 | 2456670 | 2022-04-29 | Dickens | Texas | 48125 | 452 | 16 |
2456755 | 2456755 | 2022-04-29 | Lipscomb | Texas | 48295 | 720 | 16 |
2456818 | 2456818 | 2022-04-29 | Sherman | Texas | 48421 | 499 | 16 |
2453395 | 2453395 | 2022-04-28 | Collingsworth | Texas | 48087 | 702 | 16 |
2453414 | 2453414 | 2022-04-28 | Dickens | Texas | 48125 | 452 | 16 |
2453499 | 2453499 | 2022-04-28 | Lipscomb | Texas | 48295 | 720 | 16 |
2453562 | 2453562 | 2022-04-28 | Sherman | Texas | 48421 | 499 | 16 |
2450139 | 2450139 | 2022-04-27 | Collingsworth | Texas | 48087 | 702 | 16 |
2450158 | 2450158 | 2022-04-27 | Dickens | Texas | 48125 | 452 | 16 |
2450243 | 2450243 | 2022-04-27 | Lipscomb | Texas | 48295 | 720 | 16 |
2450306 | 2450306 | 2022-04-27 | Sherman | Texas | 48421 | 499 | 16 |
2446882 | 2446882 | 2022-04-26 | Collingsworth | Texas | 48087 | 702 | 16 |
2446901 | 2446901 | 2022-04-26 | Dickens | Texas | 48125 | 452 | 16 |
2446986 | 2446986 | 2022-04-26 | Lipscomb | Texas | 48295 | 720 | 16 |
2447049 | 2447049 | 2022-04-26 | Sherman | Texas | 48421 | 499 | 16 |
2443627 | 2443627 | 2022-04-25 | Collingsworth | Texas | 48087 | 702 | 16 |
2443646 | 2443646 | 2022-04-25 | Dickens | Texas | 48125 | 452 | 16 |
2443731 | 2443731 | 2022-04-25 | Lipscomb | Texas | 48295 | 720 | 16 |
2443794 | 2443794 | 2022-04-25 | Sherman | Texas | 48421 | 499 | 16 |
2440371 | 2440371 | 2022-04-24 | Collingsworth | Texas | 48087 | 702 | 16 |
2440390 | 2440390 | 2022-04-24 | Dickens | Texas | 48125 | 452 | 16 |
2440475 | 2440475 | 2022-04-24 | Lipscomb | Texas | 48295 | 720 | 16 |
2440538 | 2440538 | 2022-04-24 | Sherman | Texas | 48421 | 499 | 16 |
2437115 | 2437115 | 2022-04-23 | Collingsworth | Texas | 48087 | 702 | 16 |
2437134 | 2437134 | 2022-04-23 | Dickens | Texas | 48125 | 452 | 16 |
2437219 | 2437219 | 2022-04-23 | Lipscomb | Texas | 48295 | 720 | 16 |
2437282 | 2437282 | 2022-04-23 | Sherman | Texas | 48421 | 499 | 16 |
2433859 | 2433859 | 2022-04-22 | Collingsworth | Texas | 48087 | 702 | 16 |
2433878 | 2433878 | 2022-04-22 | Dickens | Texas | 48125 | 451 | 16 |
2433963 | 2433963 | 2022-04-22 | Lipscomb | Texas | 48295 | 720 | 16 |
2434026 | 2434026 | 2022-04-22 | Sherman | Texas | 48421 | 499 | 16 |
2430603 | 2430603 | 2022-04-21 | Collingsworth | Texas | 48087 | 702 | 16 |
2430622 | 2430622 | 2022-04-21 | Dickens | Texas | 48125 | 451 | 16 |
2430707 | 2430707 | 2022-04-21 | Lipscomb | Texas | 48295 | 720 | 16 |
2430770 | 2430770 | 2022-04-21 | Sherman | Texas | 48421 | 498 | 16 |
2427347 | 2427347 | 2022-04-20 | Collingsworth | Texas | 48087 | 702 | 16 |
2427366 | 2427366 | 2022-04-20 | Dickens | Texas | 48125 | 451 | 16 |
2427451 | 2427451 | 2022-04-20 | Lipscomb | Texas | 48295 | 720 | 16 |
2427514 | 2427514 | 2022-04-20 | Sherman | Texas | 48421 | 498 | 16 |
2424091 | 2424091 | 2022-04-19 | Collingsworth | Texas | 48087 | 702 | 16 |
2424110 | 2424110 | 2022-04-19 | Dickens | Texas | 48125 | 450 | 16 |
2424195 | 2424195 | 2022-04-19 | Lipscomb | Texas | 48295 | 720 | 16 |
2424258 | 2424258 | 2022-04-19 | Sherman | Texas | 48421 | 498 | 16 |
2420835 | 2420835 | 2022-04-18 | Collingsworth | Texas | 48087 | 701 | 16 |
2420854 | 2420854 | 2022-04-18 | Dickens | Texas | 48125 | 450 | 16 |
2420939 | 2420939 | 2022-04-18 | Lipscomb | Texas | 48295 | 720 | 16 |
2421002 | 2421002 | 2022-04-18 | Sherman | Texas | 48421 | 498 | 16 |
2417579 | 2417579 | 2022-04-17 | Collingsworth | Texas | 48087 | 701 | 16 |
2417598 | 2417598 | 2022-04-17 | Dickens | Texas | 48125 | 450 | 16 |
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);