ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where deaths = 71 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Hutchinson 80
- Pecos 59
- Andrews 58
- Montague 55
- Coleman 44
- Bowie 37
- Leon 25
- Austin 22
- Reeves 22
- Willacy 17
- Erath 15
- Camp 14
- Moore 14
- Shelby 14
- Palo Pinto 12
- Llano 11
- Panola 11
- Wharton 11
- Grimes 10
- Lampasas 9
- Robertson 9
- Lavaca 8
- Nolan 8
- Aransas 7
- Freestone 7
- Frio 7
- Hale 7
- Cherokee 6
- Fayette 6
- Gaines 6
- …
state 1
- Texas · 771 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502248 | 2502248 | 2022-05-13 | Coleman | Texas | 48083 | 1646 | 71 |
2502392 | 2502392 | 2022-05-13 | Pecos | Texas | 48371 | 2749 | 71 |
2498990 | 2498990 | 2022-05-12 | Coleman | Texas | 48083 | 1645 | 71 |
2499134 | 2499134 | 2022-05-12 | Pecos | Texas | 48371 | 2749 | 71 |
2495732 | 2495732 | 2022-05-11 | Coleman | Texas | 48083 | 1644 | 71 |
2495876 | 2495876 | 2022-05-11 | Pecos | Texas | 48371 | 2748 | 71 |
2492474 | 2492474 | 2022-05-10 | Coleman | Texas | 48083 | 1642 | 71 |
2492618 | 2492618 | 2022-05-10 | Pecos | Texas | 48371 | 2748 | 71 |
2489216 | 2489216 | 2022-05-09 | Coleman | Texas | 48083 | 1642 | 71 |
2489360 | 2489360 | 2022-05-09 | Pecos | Texas | 48371 | 2746 | 71 |
2485959 | 2485959 | 2022-05-08 | Coleman | Texas | 48083 | 1642 | 71 |
2486103 | 2486103 | 2022-05-08 | Pecos | Texas | 48371 | 2746 | 71 |
2482701 | 2482701 | 2022-05-07 | Coleman | Texas | 48083 | 1642 | 71 |
2482845 | 2482845 | 2022-05-07 | Pecos | Texas | 48371 | 2746 | 71 |
2479443 | 2479443 | 2022-05-06 | Coleman | Texas | 48083 | 1640 | 71 |
2479587 | 2479587 | 2022-05-06 | Pecos | Texas | 48371 | 2745 | 71 |
2476185 | 2476185 | 2022-05-05 | Coleman | Texas | 48083 | 1640 | 71 |
2476329 | 2476329 | 2022-05-05 | Pecos | Texas | 48371 | 2744 | 71 |
2472928 | 2472928 | 2022-05-04 | Coleman | Texas | 48083 | 1639 | 71 |
2473072 | 2473072 | 2022-05-04 | Pecos | Texas | 48371 | 2744 | 71 |
2469672 | 2469672 | 2022-05-03 | Coleman | Texas | 48083 | 1638 | 71 |
2469816 | 2469816 | 2022-05-03 | Pecos | Texas | 48371 | 2744 | 71 |
2466416 | 2466416 | 2022-05-02 | Coleman | Texas | 48083 | 1638 | 71 |
2466560 | 2466560 | 2022-05-02 | Pecos | Texas | 48371 | 2744 | 71 |
2463161 | 2463161 | 2022-05-01 | Coleman | Texas | 48083 | 1638 | 71 |
2463305 | 2463305 | 2022-05-01 | Pecos | Texas | 48371 | 2744 | 71 |
2459905 | 2459905 | 2022-04-30 | Coleman | Texas | 48083 | 1638 | 71 |
2460049 | 2460049 | 2022-04-30 | Pecos | Texas | 48371 | 2744 | 71 |
2456649 | 2456649 | 2022-04-29 | Coleman | Texas | 48083 | 1638 | 71 |
2456793 | 2456793 | 2022-04-29 | Pecos | Texas | 48371 | 2744 | 71 |
2453393 | 2453393 | 2022-04-28 | Coleman | Texas | 48083 | 1638 | 71 |
2453537 | 2453537 | 2022-04-28 | Pecos | Texas | 48371 | 2744 | 71 |
2450097 | 2450097 | 2022-04-27 | Andrews | Texas | 48003 | 3801 | 71 |
2450137 | 2450137 | 2022-04-27 | Coleman | Texas | 48083 | 1637 | 71 |
2450281 | 2450281 | 2022-04-27 | Pecos | Texas | 48371 | 2744 | 71 |
2446840 | 2446840 | 2022-04-26 | Andrews | Texas | 48003 | 3801 | 71 |
2446880 | 2446880 | 2022-04-26 | Coleman | Texas | 48083 | 1637 | 71 |
2447024 | 2447024 | 2022-04-26 | Pecos | Texas | 48371 | 2744 | 71 |
2443585 | 2443585 | 2022-04-25 | Andrews | Texas | 48003 | 3801 | 71 |
2443625 | 2443625 | 2022-04-25 | Coleman | Texas | 48083 | 1637 | 71 |
2443769 | 2443769 | 2022-04-25 | Pecos | Texas | 48371 | 2742 | 71 |
2440329 | 2440329 | 2022-04-24 | Andrews | Texas | 48003 | 3801 | 71 |
2440369 | 2440369 | 2022-04-24 | Coleman | Texas | 48083 | 1637 | 71 |
2440513 | 2440513 | 2022-04-24 | Pecos | Texas | 48371 | 2742 | 71 |
2437073 | 2437073 | 2022-04-23 | Andrews | Texas | 48003 | 3801 | 71 |
2437113 | 2437113 | 2022-04-23 | Coleman | Texas | 48083 | 1637 | 71 |
2437257 | 2437257 | 2022-04-23 | Pecos | Texas | 48371 | 2742 | 71 |
2433817 | 2433817 | 2022-04-22 | Andrews | Texas | 48003 | 3801 | 71 |
2433857 | 2433857 | 2022-04-22 | Coleman | Texas | 48083 | 1637 | 71 |
2434001 | 2434001 | 2022-04-22 | Pecos | Texas | 48371 | 2742 | 71 |
2430561 | 2430561 | 2022-04-21 | Andrews | Texas | 48003 | 3799 | 71 |
2430601 | 2430601 | 2022-04-21 | Coleman | Texas | 48083 | 1636 | 71 |
2430745 | 2430745 | 2022-04-21 | Pecos | Texas | 48371 | 2741 | 71 |
2427305 | 2427305 | 2022-04-20 | Andrews | Texas | 48003 | 3793 | 71 |
2427345 | 2427345 | 2022-04-20 | Coleman | Texas | 48083 | 1636 | 71 |
2427489 | 2427489 | 2022-04-20 | Pecos | Texas | 48371 | 2740 | 71 |
2424049 | 2424049 | 2022-04-19 | Andrews | Texas | 48003 | 3793 | 71 |
2424089 | 2424089 | 2022-04-19 | Coleman | Texas | 48083 | 1635 | 71 |
2424233 | 2424233 | 2022-04-19 | Pecos | Texas | 48371 | 2740 | 71 |
2420793 | 2420793 | 2022-04-18 | Andrews | Texas | 48003 | 3793 | 71 |
2420833 | 2420833 | 2022-04-18 | Coleman | Texas | 48083 | 1634 | 71 |
2420977 | 2420977 | 2022-04-18 | Pecos | Texas | 48371 | 2739 | 71 |
2417537 | 2417537 | 2022-04-17 | Andrews | Texas | 48003 | 3793 | 71 |
2417577 | 2417577 | 2022-04-17 | Coleman | Texas | 48083 | 1632 | 71 |
2417721 | 2417721 | 2022-04-17 | Pecos | Texas | 48371 | 2738 | 71 |
2414281 | 2414281 | 2022-04-16 | Andrews | Texas | 48003 | 3793 | 71 |
2414321 | 2414321 | 2022-04-16 | Coleman | Texas | 48083 | 1632 | 71 |
2414465 | 2414465 | 2022-04-16 | Pecos | Texas | 48371 | 2738 | 71 |
2411025 | 2411025 | 2022-04-15 | Andrews | Texas | 48003 | 3793 | 71 |
2411065 | 2411065 | 2022-04-15 | Coleman | Texas | 48083 | 1632 | 71 |
2411209 | 2411209 | 2022-04-15 | Pecos | Texas | 48371 | 2738 | 71 |
2407769 | 2407769 | 2022-04-14 | Andrews | Texas | 48003 | 3793 | 71 |
2407809 | 2407809 | 2022-04-14 | Coleman | Texas | 48083 | 1632 | 71 |
2407953 | 2407953 | 2022-04-14 | Pecos | Texas | 48371 | 2738 | 71 |
2404513 | 2404513 | 2022-04-13 | Andrews | Texas | 48003 | 3793 | 71 |
2404553 | 2404553 | 2022-04-13 | Coleman | Texas | 48083 | 1631 | 71 |
2404697 | 2404697 | 2022-04-13 | Pecos | Texas | 48371 | 2738 | 71 |
2401258 | 2401258 | 2022-04-12 | Andrews | Texas | 48003 | 3793 | 71 |
2401298 | 2401298 | 2022-04-12 | Coleman | Texas | 48083 | 1630 | 71 |
2401442 | 2401442 | 2022-04-12 | Pecos | Texas | 48371 | 2738 | 71 |
2398003 | 2398003 | 2022-04-11 | Andrews | Texas | 48003 | 3793 | 71 |
2398043 | 2398043 | 2022-04-11 | Coleman | Texas | 48083 | 1629 | 71 |
2398187 | 2398187 | 2022-04-11 | Pecos | Texas | 48371 | 2738 | 71 |
2394748 | 2394748 | 2022-04-10 | Andrews | Texas | 48003 | 3793 | 71 |
2394788 | 2394788 | 2022-04-10 | Coleman | Texas | 48083 | 1629 | 71 |
2394932 | 2394932 | 2022-04-10 | Pecos | Texas | 48371 | 2738 | 71 |
2391492 | 2391492 | 2022-04-09 | Andrews | Texas | 48003 | 3793 | 71 |
2391532 | 2391532 | 2022-04-09 | Coleman | Texas | 48083 | 1629 | 71 |
2391676 | 2391676 | 2022-04-09 | Pecos | Texas | 48371 | 2738 | 71 |
2388236 | 2388236 | 2022-04-08 | Andrews | Texas | 48003 | 3793 | 71 |
2388276 | 2388276 | 2022-04-08 | Coleman | Texas | 48083 | 1628 | 71 |
2388420 | 2388420 | 2022-04-08 | Pecos | Texas | 48371 | 2737 | 71 |
2384981 | 2384981 | 2022-04-07 | Andrews | Texas | 48003 | 3793 | 71 |
2385021 | 2385021 | 2022-04-07 | Coleman | Texas | 48083 | 1626 | 71 |
2385165 | 2385165 | 2022-04-07 | Pecos | Texas | 48371 | 2735 | 71 |
2381726 | 2381726 | 2022-04-06 | Andrews | Texas | 48003 | 3793 | 71 |
2381766 | 2381766 | 2022-04-06 | Coleman | Texas | 48083 | 1624 | 71 |
2381910 | 2381910 | 2022-04-06 | Pecos | Texas | 48371 | 2735 | 71 |
2378471 | 2378471 | 2022-04-05 | Andrews | Texas | 48003 | 3793 | 71 |
2378511 | 2378511 | 2022-04-05 | Coleman | Texas | 48083 | 1624 | 71 |
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);