ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,198 rows where deaths = 39 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Lee 96
- Haskell 87
- San Jacinto 84
- Bailey 59
- Runnels 46
- Duval 36
- Caldwell 34
- Stephens 34
- Potter 32
- Lavaca 29
- Ochiltree 27
- Robertson 27
- Bee 24
- Calhoun 23
- Callahan 22
- Live Oak 22
- Austin 19
- Uvalde 19
- Zapata 17
- McCulloch 16
- Floyd 15
- Reeves 15
- Anderson 14
- Ward 14
- Bastrop 12
- Crosby 12
- Mitchell 12
- Aransas 11
- Harrison 11
- Panola 11
- …
state 1
- Texas · 1,198 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502215 | 2502215 | 2022-05-13 | Bailey | Texas | 48017 | 1511 | 39 |
2502310 | 2502310 | 2022-05-13 | Haskell | Texas | 48207 | 897 | 39 |
2498957 | 2498957 | 2022-05-12 | Bailey | Texas | 48017 | 1511 | 39 |
2499052 | 2499052 | 2022-05-12 | Haskell | Texas | 48207 | 897 | 39 |
2495699 | 2495699 | 2022-05-11 | Bailey | Texas | 48017 | 1511 | 39 |
2495794 | 2495794 | 2022-05-11 | Haskell | Texas | 48207 | 897 | 39 |
2492441 | 2492441 | 2022-05-10 | Bailey | Texas | 48017 | 1511 | 39 |
2492536 | 2492536 | 2022-05-10 | Haskell | Texas | 48207 | 897 | 39 |
2489183 | 2489183 | 2022-05-09 | Bailey | Texas | 48017 | 1511 | 39 |
2489278 | 2489278 | 2022-05-09 | Haskell | Texas | 48207 | 897 | 39 |
2485926 | 2485926 | 2022-05-08 | Bailey | Texas | 48017 | 1511 | 39 |
2486021 | 2486021 | 2022-05-08 | Haskell | Texas | 48207 | 897 | 39 |
2482668 | 2482668 | 2022-05-07 | Bailey | Texas | 48017 | 1511 | 39 |
2482763 | 2482763 | 2022-05-07 | Haskell | Texas | 48207 | 897 | 39 |
2479410 | 2479410 | 2022-05-06 | Bailey | Texas | 48017 | 1511 | 39 |
2479505 | 2479505 | 2022-05-06 | Haskell | Texas | 48207 | 897 | 39 |
2476152 | 2476152 | 2022-05-05 | Bailey | Texas | 48017 | 1511 | 39 |
2476247 | 2476247 | 2022-05-05 | Haskell | Texas | 48207 | 897 | 39 |
2472895 | 2472895 | 2022-05-04 | Bailey | Texas | 48017 | 1476 | 39 |
2472990 | 2472990 | 2022-05-04 | Haskell | Texas | 48207 | 897 | 39 |
2469639 | 2469639 | 2022-05-03 | Bailey | Texas | 48017 | 1475 | 39 |
2469734 | 2469734 | 2022-05-03 | Haskell | Texas | 48207 | 896 | 39 |
2466383 | 2466383 | 2022-05-02 | Bailey | Texas | 48017 | 1475 | 39 |
2466478 | 2466478 | 2022-05-02 | Haskell | Texas | 48207 | 896 | 39 |
2463128 | 2463128 | 2022-05-01 | Bailey | Texas | 48017 | 1475 | 39 |
2463223 | 2463223 | 2022-05-01 | Haskell | Texas | 48207 | 896 | 39 |
2459872 | 2459872 | 2022-04-30 | Bailey | Texas | 48017 | 1475 | 39 |
2459967 | 2459967 | 2022-04-30 | Haskell | Texas | 48207 | 896 | 39 |
2456616 | 2456616 | 2022-04-29 | Bailey | Texas | 48017 | 1475 | 39 |
2456711 | 2456711 | 2022-04-29 | Haskell | Texas | 48207 | 896 | 39 |
2453360 | 2453360 | 2022-04-28 | Bailey | Texas | 48017 | 1475 | 39 |
2453455 | 2453455 | 2022-04-28 | Haskell | Texas | 48207 | 896 | 39 |
2450104 | 2450104 | 2022-04-27 | Bailey | Texas | 48017 | 1475 | 39 |
2450199 | 2450199 | 2022-04-27 | Haskell | Texas | 48207 | 896 | 39 |
2446847 | 2446847 | 2022-04-26 | Bailey | Texas | 48017 | 1475 | 39 |
2446942 | 2446942 | 2022-04-26 | Haskell | Texas | 48207 | 896 | 39 |
2443592 | 2443592 | 2022-04-25 | Bailey | Texas | 48017 | 1475 | 39 |
2443687 | 2443687 | 2022-04-25 | Haskell | Texas | 48207 | 896 | 39 |
2440336 | 2440336 | 2022-04-24 | Bailey | Texas | 48017 | 1475 | 39 |
2440431 | 2440431 | 2022-04-24 | Haskell | Texas | 48207 | 896 | 39 |
2437080 | 2437080 | 2022-04-23 | Bailey | Texas | 48017 | 1475 | 39 |
2437175 | 2437175 | 2022-04-23 | Haskell | Texas | 48207 | 896 | 39 |
2433824 | 2433824 | 2022-04-22 | Bailey | Texas | 48017 | 1475 | 39 |
2433919 | 2433919 | 2022-04-22 | Haskell | Texas | 48207 | 896 | 39 |
2430568 | 2430568 | 2022-04-21 | Bailey | Texas | 48017 | 1475 | 39 |
2430663 | 2430663 | 2022-04-21 | Haskell | Texas | 48207 | 896 | 39 |
2427312 | 2427312 | 2022-04-20 | Bailey | Texas | 48017 | 1475 | 39 |
2427407 | 2427407 | 2022-04-20 | Haskell | Texas | 48207 | 896 | 39 |
2424056 | 2424056 | 2022-04-19 | Bailey | Texas | 48017 | 1475 | 39 |
2424151 | 2424151 | 2022-04-19 | Haskell | Texas | 48207 | 896 | 39 |
2420800 | 2420800 | 2022-04-18 | Bailey | Texas | 48017 | 1475 | 39 |
2420895 | 2420895 | 2022-04-18 | Haskell | Texas | 48207 | 896 | 39 |
2417544 | 2417544 | 2022-04-17 | Bailey | Texas | 48017 | 1475 | 39 |
2417639 | 2417639 | 2022-04-17 | Haskell | Texas | 48207 | 896 | 39 |
2414288 | 2414288 | 2022-04-16 | Bailey | Texas | 48017 | 1475 | 39 |
2414383 | 2414383 | 2022-04-16 | Haskell | Texas | 48207 | 896 | 39 |
2411032 | 2411032 | 2022-04-15 | Bailey | Texas | 48017 | 1475 | 39 |
2411127 | 2411127 | 2022-04-15 | Haskell | Texas | 48207 | 896 | 39 |
2407776 | 2407776 | 2022-04-14 | Bailey | Texas | 48017 | 1475 | 39 |
2407871 | 2407871 | 2022-04-14 | Haskell | Texas | 48207 | 896 | 39 |
2404520 | 2404520 | 2022-04-13 | Bailey | Texas | 48017 | 1475 | 39 |
2404615 | 2404615 | 2022-04-13 | Haskell | Texas | 48207 | 896 | 39 |
2401265 | 2401265 | 2022-04-12 | Bailey | Texas | 48017 | 1475 | 39 |
2401360 | 2401360 | 2022-04-12 | Haskell | Texas | 48207 | 895 | 39 |
2398010 | 2398010 | 2022-04-11 | Bailey | Texas | 48017 | 1475 | 39 |
2398105 | 2398105 | 2022-04-11 | Haskell | Texas | 48207 | 895 | 39 |
2394755 | 2394755 | 2022-04-10 | Bailey | Texas | 48017 | 1475 | 39 |
2394850 | 2394850 | 2022-04-10 | Haskell | Texas | 48207 | 895 | 39 |
2391499 | 2391499 | 2022-04-09 | Bailey | Texas | 48017 | 1475 | 39 |
2391594 | 2391594 | 2022-04-09 | Haskell | Texas | 48207 | 895 | 39 |
2388243 | 2388243 | 2022-04-08 | Bailey | Texas | 48017 | 1463 | 39 |
2388338 | 2388338 | 2022-04-08 | Haskell | Texas | 48207 | 895 | 39 |
2384988 | 2384988 | 2022-04-07 | Bailey | Texas | 48017 | 1463 | 39 |
2385083 | 2385083 | 2022-04-07 | Haskell | Texas | 48207 | 895 | 39 |
2381733 | 2381733 | 2022-04-06 | Bailey | Texas | 48017 | 1463 | 39 |
2381828 | 2381828 | 2022-04-06 | Haskell | Texas | 48207 | 895 | 39 |
2378478 | 2378478 | 2022-04-05 | Bailey | Texas | 48017 | 1463 | 39 |
2378573 | 2378573 | 2022-04-05 | Haskell | Texas | 48207 | 895 | 39 |
2375224 | 2375224 | 2022-04-04 | Bailey | Texas | 48017 | 1463 | 39 |
2375319 | 2375319 | 2022-04-04 | Haskell | Texas | 48207 | 895 | 39 |
2371972 | 2371972 | 2022-04-03 | Bailey | Texas | 48017 | 1463 | 39 |
2372067 | 2372067 | 2022-04-03 | Haskell | Texas | 48207 | 895 | 39 |
2368719 | 2368719 | 2022-04-02 | Bailey | Texas | 48017 | 1463 | 39 |
2368814 | 2368814 | 2022-04-02 | Haskell | Texas | 48207 | 895 | 39 |
2365466 | 2365466 | 2022-04-01 | Bailey | Texas | 48017 | 1462 | 39 |
2365561 | 2365561 | 2022-04-01 | Haskell | Texas | 48207 | 894 | 39 |
2362213 | 2362213 | 2022-03-31 | Bailey | Texas | 48017 | 1462 | 39 |
2362308 | 2362308 | 2022-03-31 | Haskell | Texas | 48207 | 894 | 39 |
2358959 | 2358959 | 2022-03-30 | Bailey | Texas | 48017 | 1462 | 39 |
2359054 | 2359054 | 2022-03-30 | Haskell | Texas | 48207 | 894 | 39 |
2355705 | 2355705 | 2022-03-29 | Bailey | Texas | 48017 | 1461 | 39 |
2355800 | 2355800 | 2022-03-29 | Haskell | Texas | 48207 | 893 | 39 |
2352452 | 2352452 | 2022-03-28 | Bailey | Texas | 48017 | 1451 | 39 |
2352547 | 2352547 | 2022-03-28 | Haskell | Texas | 48207 | 893 | 39 |
2349200 | 2349200 | 2022-03-27 | Bailey | Texas | 48017 | 1451 | 39 |
2349295 | 2349295 | 2022-03-27 | Haskell | Texas | 48207 | 893 | 39 |
2345947 | 2345947 | 2022-03-26 | Bailey | Texas | 48017 | 1451 | 39 |
2346042 | 2346042 | 2022-03-26 | Haskell | Texas | 48207 | 893 | 39 |
2342694 | 2342694 | 2022-03-25 | Bailey | Texas | 48017 | 1451 | 39 |
2342789 | 2342789 | 2022-03-25 | Haskell | Texas | 48207 | 893 | 39 |
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);