ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
6,668 rows where deaths = 2 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Hartley 616
- Kenedy 599
- Borden 464
- Glasscock 216
- Terrell 198
- Kent 175
- Hemphill 153
- Irion 142
- Throckmorton 136
- Mason 116
- Hansford 109
- Oldham 106
- Edwards 100
- Culberson 96
- Crane 94
- Ochiltree 92
- Schleicher 90
- Concho 86
- Medina 82
- Palo Pinto 82
- Roberts 78
- Wichita 78
- Coryell 76
- Jasper 75
- Dickens 70
- Cherokee 69
- Navarro 66
- Brewster 61
- Atascosa 59
- Cottle 59
- …
state 1
- Texas · 6,668 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502223 | 2502223 | 2022-05-13 | Borden | Texas | 48033 | 100 | 2 |
2502337 | 2502337 | 2022-05-13 | Kenedy | Texas | 48261 | 86 | 2 |
2502404 | 2502404 | 2022-05-13 | Roberts | Texas | 48393 | 175 | 2 |
2498965 | 2498965 | 2022-05-12 | Borden | Texas | 48033 | 100 | 2 |
2499079 | 2499079 | 2022-05-12 | Kenedy | Texas | 48261 | 86 | 2 |
2499146 | 2499146 | 2022-05-12 | Roberts | Texas | 48393 | 175 | 2 |
2495707 | 2495707 | 2022-05-11 | Borden | Texas | 48033 | 100 | 2 |
2495821 | 2495821 | 2022-05-11 | Kenedy | Texas | 48261 | 86 | 2 |
2495888 | 2495888 | 2022-05-11 | Roberts | Texas | 48393 | 175 | 2 |
2492449 | 2492449 | 2022-05-10 | Borden | Texas | 48033 | 99 | 2 |
2492563 | 2492563 | 2022-05-10 | Kenedy | Texas | 48261 | 86 | 2 |
2492630 | 2492630 | 2022-05-10 | Roberts | Texas | 48393 | 175 | 2 |
2489191 | 2489191 | 2022-05-09 | Borden | Texas | 48033 | 99 | 2 |
2489305 | 2489305 | 2022-05-09 | Kenedy | Texas | 48261 | 86 | 2 |
2489372 | 2489372 | 2022-05-09 | Roberts | Texas | 48393 | 175 | 2 |
2485934 | 2485934 | 2022-05-08 | Borden | Texas | 48033 | 99 | 2 |
2486048 | 2486048 | 2022-05-08 | Kenedy | Texas | 48261 | 86 | 2 |
2486114 | 2486114 | 2022-05-08 | Roberts | Texas | 48393 | 175 | 2 |
2482676 | 2482676 | 2022-05-07 | Borden | Texas | 48033 | 99 | 2 |
2482790 | 2482790 | 2022-05-07 | Kenedy | Texas | 48261 | 86 | 2 |
2482856 | 2482856 | 2022-05-07 | Roberts | Texas | 48393 | 175 | 2 |
2479418 | 2479418 | 2022-05-06 | Borden | Texas | 48033 | 99 | 2 |
2479532 | 2479532 | 2022-05-06 | Kenedy | Texas | 48261 | 86 | 2 |
2479598 | 2479598 | 2022-05-06 | Roberts | Texas | 48393 | 175 | 2 |
2476160 | 2476160 | 2022-05-05 | Borden | Texas | 48033 | 99 | 2 |
2476274 | 2476274 | 2022-05-05 | Kenedy | Texas | 48261 | 86 | 2 |
2476340 | 2476340 | 2022-05-05 | Roberts | Texas | 48393 | 175 | 2 |
2472903 | 2472903 | 2022-05-04 | Borden | Texas | 48033 | 98 | 2 |
2473017 | 2473017 | 2022-05-04 | Kenedy | Texas | 48261 | 85 | 2 |
2473083 | 2473083 | 2022-05-04 | Roberts | Texas | 48393 | 175 | 2 |
2469647 | 2469647 | 2022-05-03 | Borden | Texas | 48033 | 98 | 2 |
2469761 | 2469761 | 2022-05-03 | Kenedy | Texas | 48261 | 85 | 2 |
2469827 | 2469827 | 2022-05-03 | Roberts | Texas | 48393 | 175 | 2 |
2466391 | 2466391 | 2022-05-02 | Borden | Texas | 48033 | 98 | 2 |
2466505 | 2466505 | 2022-05-02 | Kenedy | Texas | 48261 | 85 | 2 |
2466571 | 2466571 | 2022-05-02 | Roberts | Texas | 48393 | 175 | 2 |
2463136 | 2463136 | 2022-05-01 | Borden | Texas | 48033 | 98 | 2 |
2463250 | 2463250 | 2022-05-01 | Kenedy | Texas | 48261 | 85 | 2 |
2463316 | 2463316 | 2022-05-01 | Roberts | Texas | 48393 | 175 | 2 |
2459880 | 2459880 | 2022-04-30 | Borden | Texas | 48033 | 98 | 2 |
2459994 | 2459994 | 2022-04-30 | Kenedy | Texas | 48261 | 85 | 2 |
2460060 | 2460060 | 2022-04-30 | Roberts | Texas | 48393 | 175 | 2 |
2456624 | 2456624 | 2022-04-29 | Borden | Texas | 48033 | 98 | 2 |
2456738 | 2456738 | 2022-04-29 | Kenedy | Texas | 48261 | 85 | 2 |
2456804 | 2456804 | 2022-04-29 | Roberts | Texas | 48393 | 175 | 2 |
2453368 | 2453368 | 2022-04-28 | Borden | Texas | 48033 | 98 | 2 |
2453482 | 2453482 | 2022-04-28 | Kenedy | Texas | 48261 | 85 | 2 |
2453548 | 2453548 | 2022-04-28 | Roberts | Texas | 48393 | 175 | 2 |
2450112 | 2450112 | 2022-04-27 | Borden | Texas | 48033 | 98 | 2 |
2450226 | 2450226 | 2022-04-27 | Kenedy | Texas | 48261 | 85 | 2 |
2450292 | 2450292 | 2022-04-27 | Roberts | Texas | 48393 | 175 | 2 |
2446855 | 2446855 | 2022-04-26 | Borden | Texas | 48033 | 98 | 2 |
2446969 | 2446969 | 2022-04-26 | Kenedy | Texas | 48261 | 85 | 2 |
2447035 | 2447035 | 2022-04-26 | Roberts | Texas | 48393 | 175 | 2 |
2443600 | 2443600 | 2022-04-25 | Borden | Texas | 48033 | 98 | 2 |
2443714 | 2443714 | 2022-04-25 | Kenedy | Texas | 48261 | 85 | 2 |
2443780 | 2443780 | 2022-04-25 | Roberts | Texas | 48393 | 175 | 2 |
2440344 | 2440344 | 2022-04-24 | Borden | Texas | 48033 | 98 | 2 |
2440458 | 2440458 | 2022-04-24 | Kenedy | Texas | 48261 | 85 | 2 |
2440524 | 2440524 | 2022-04-24 | Roberts | Texas | 48393 | 175 | 2 |
2437088 | 2437088 | 2022-04-23 | Borden | Texas | 48033 | 98 | 2 |
2437202 | 2437202 | 2022-04-23 | Kenedy | Texas | 48261 | 85 | 2 |
2437268 | 2437268 | 2022-04-23 | Roberts | Texas | 48393 | 175 | 2 |
2433832 | 2433832 | 2022-04-22 | Borden | Texas | 48033 | 98 | 2 |
2433946 | 2433946 | 2022-04-22 | Kenedy | Texas | 48261 | 85 | 2 |
2434012 | 2434012 | 2022-04-22 | Roberts | Texas | 48393 | 175 | 2 |
2430576 | 2430576 | 2022-04-21 | Borden | Texas | 48033 | 98 | 2 |
2430690 | 2430690 | 2022-04-21 | Kenedy | Texas | 48261 | 85 | 2 |
2430756 | 2430756 | 2022-04-21 | Roberts | Texas | 48393 | 175 | 2 |
2427320 | 2427320 | 2022-04-20 | Borden | Texas | 48033 | 98 | 2 |
2427434 | 2427434 | 2022-04-20 | Kenedy | Texas | 48261 | 85 | 2 |
2427500 | 2427500 | 2022-04-20 | Roberts | Texas | 48393 | 175 | 2 |
2424064 | 2424064 | 2022-04-19 | Borden | Texas | 48033 | 98 | 2 |
2424178 | 2424178 | 2022-04-19 | Kenedy | Texas | 48261 | 85 | 2 |
2424244 | 2424244 | 2022-04-19 | Roberts | Texas | 48393 | 175 | 2 |
2420808 | 2420808 | 2022-04-18 | Borden | Texas | 48033 | 98 | 2 |
2420922 | 2420922 | 2022-04-18 | Kenedy | Texas | 48261 | 84 | 2 |
2420988 | 2420988 | 2022-04-18 | Roberts | Texas | 48393 | 175 | 2 |
2417552 | 2417552 | 2022-04-17 | Borden | Texas | 48033 | 98 | 2 |
2417666 | 2417666 | 2022-04-17 | Kenedy | Texas | 48261 | 83 | 2 |
2417732 | 2417732 | 2022-04-17 | Roberts | Texas | 48393 | 175 | 2 |
2414296 | 2414296 | 2022-04-16 | Borden | Texas | 48033 | 98 | 2 |
2414410 | 2414410 | 2022-04-16 | Kenedy | Texas | 48261 | 83 | 2 |
2414476 | 2414476 | 2022-04-16 | Roberts | Texas | 48393 | 175 | 2 |
2411040 | 2411040 | 2022-04-15 | Borden | Texas | 48033 | 98 | 2 |
2411154 | 2411154 | 2022-04-15 | Kenedy | Texas | 48261 | 83 | 2 |
2411220 | 2411220 | 2022-04-15 | Roberts | Texas | 48393 | 175 | 2 |
2407784 | 2407784 | 2022-04-14 | Borden | Texas | 48033 | 98 | 2 |
2407898 | 2407898 | 2022-04-14 | Kenedy | Texas | 48261 | 83 | 2 |
2407964 | 2407964 | 2022-04-14 | Roberts | Texas | 48393 | 175 | 2 |
2404528 | 2404528 | 2022-04-13 | Borden | Texas | 48033 | 98 | 2 |
2404642 | 2404642 | 2022-04-13 | Kenedy | Texas | 48261 | 83 | 2 |
2404708 | 2404708 | 2022-04-13 | Roberts | Texas | 48393 | 175 | 2 |
2401273 | 2401273 | 2022-04-12 | Borden | Texas | 48033 | 98 | 2 |
2401387 | 2401387 | 2022-04-12 | Kenedy | Texas | 48261 | 83 | 2 |
2401453 | 2401453 | 2022-04-12 | Roberts | Texas | 48393 | 175 | 2 |
2398018 | 2398018 | 2022-04-11 | Borden | Texas | 48033 | 98 | 2 |
2398132 | 2398132 | 2022-04-11 | Kenedy | Texas | 48261 | 83 | 2 |
2398198 | 2398198 | 2022-04-11 | Roberts | Texas | 48393 | 174 | 2 |
2394763 | 2394763 | 2022-04-10 | Borden | Texas | 48033 | 98 | 2 |
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);