ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,149 rows where deaths = 38 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Newton 88
- Live Oak 80
- Red River 71
- San Augustine 65
- Lynn 64
- Callahan 49
- Dimmit 38
- Ochiltree 35
- Castro 27
- McCulloch 26
- Sabine 26
- Runnels 24
- Presidio 22
- Bailey 20
- Reeves 20
- Zapata 20
- Uvalde 19
- San Jacinto 16
- Young 14
- Bosque 13
- Frio 13
- Matagorda 11
- Robertson 11
- Burleson 10
- Lee 10
- Austin 9
- Brooks 9
- Collin 9
- Falls 9
- Harrison 9
- …
state 1
- Texas · 1,149 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502359 | 2502359 | 2022-05-13 | Lynn | Texas | 48305 | 1556 | 38 |
2502396 | 2502396 | 2022-05-13 | Presidio | Texas | 48377 | 998 | 38 |
2499101 | 2499101 | 2022-05-12 | Lynn | Texas | 48305 | 1553 | 38 |
2499138 | 2499138 | 2022-05-12 | Presidio | Texas | 48377 | 997 | 38 |
2495843 | 2495843 | 2022-05-11 | Lynn | Texas | 48305 | 1553 | 38 |
2495880 | 2495880 | 2022-05-11 | Presidio | Texas | 48377 | 997 | 38 |
2492585 | 2492585 | 2022-05-10 | Lynn | Texas | 48305 | 1553 | 38 |
2492622 | 2492622 | 2022-05-10 | Presidio | Texas | 48377 | 997 | 38 |
2489327 | 2489327 | 2022-05-09 | Lynn | Texas | 48305 | 1553 | 38 |
2489364 | 2489364 | 2022-05-09 | Presidio | Texas | 48377 | 997 | 38 |
2486070 | 2486070 | 2022-05-08 | Lynn | Texas | 48305 | 1553 | 38 |
2486106 | 2486106 | 2022-05-08 | Presidio | Texas | 48377 | 997 | 38 |
2482812 | 2482812 | 2022-05-07 | Lynn | Texas | 48305 | 1553 | 38 |
2482848 | 2482848 | 2022-05-07 | Presidio | Texas | 48377 | 997 | 38 |
2479554 | 2479554 | 2022-05-06 | Lynn | Texas | 48305 | 1552 | 38 |
2479590 | 2479590 | 2022-05-06 | Presidio | Texas | 48377 | 997 | 38 |
2476296 | 2476296 | 2022-05-05 | Lynn | Texas | 48305 | 1552 | 38 |
2476332 | 2476332 | 2022-05-05 | Presidio | Texas | 48377 | 993 | 38 |
2473039 | 2473039 | 2022-05-04 | Lynn | Texas | 48305 | 1552 | 38 |
2473075 | 2473075 | 2022-05-04 | Presidio | Texas | 48377 | 984 | 38 |
2469783 | 2469783 | 2022-05-03 | Lynn | Texas | 48305 | 1551 | 38 |
2469819 | 2469819 | 2022-05-03 | Presidio | Texas | 48377 | 979 | 38 |
2466527 | 2466527 | 2022-05-02 | Lynn | Texas | 48305 | 1551 | 38 |
2466563 | 2466563 | 2022-05-02 | Presidio | Texas | 48377 | 978 | 38 |
2463272 | 2463272 | 2022-05-01 | Lynn | Texas | 48305 | 1551 | 38 |
2463308 | 2463308 | 2022-05-01 | Presidio | Texas | 48377 | 978 | 38 |
2460016 | 2460016 | 2022-04-30 | Lynn | Texas | 48305 | 1551 | 38 |
2460052 | 2460052 | 2022-04-30 | Presidio | Texas | 48377 | 978 | 38 |
2456760 | 2456760 | 2022-04-29 | Lynn | Texas | 48305 | 1551 | 38 |
2456796 | 2456796 | 2022-04-29 | Presidio | Texas | 48377 | 978 | 38 |
2453504 | 2453504 | 2022-04-28 | Lynn | Texas | 48305 | 1551 | 38 |
2453540 | 2453540 | 2022-04-28 | Presidio | Texas | 48377 | 978 | 38 |
2450248 | 2450248 | 2022-04-27 | Lynn | Texas | 48305 | 1551 | 38 |
2450284 | 2450284 | 2022-04-27 | Presidio | Texas | 48377 | 978 | 38 |
2446991 | 2446991 | 2022-04-26 | Lynn | Texas | 48305 | 1551 | 38 |
2447027 | 2447027 | 2022-04-26 | Presidio | Texas | 48377 | 978 | 38 |
2443736 | 2443736 | 2022-04-25 | Lynn | Texas | 48305 | 1551 | 38 |
2443772 | 2443772 | 2022-04-25 | Presidio | Texas | 48377 | 978 | 38 |
2440480 | 2440480 | 2022-04-24 | Lynn | Texas | 48305 | 1551 | 38 |
2440516 | 2440516 | 2022-04-24 | Presidio | Texas | 48377 | 977 | 38 |
2437224 | 2437224 | 2022-04-23 | Lynn | Texas | 48305 | 1551 | 38 |
2437260 | 2437260 | 2022-04-23 | Presidio | Texas | 48377 | 977 | 38 |
2433968 | 2433968 | 2022-04-22 | Lynn | Texas | 48305 | 1551 | 38 |
2434004 | 2434004 | 2022-04-22 | Presidio | Texas | 48377 | 977 | 38 |
2430712 | 2430712 | 2022-04-21 | Lynn | Texas | 48305 | 1551 | 38 |
2427456 | 2427456 | 2022-04-20 | Lynn | Texas | 48305 | 1551 | 38 |
2424200 | 2424200 | 2022-04-19 | Lynn | Texas | 48305 | 1551 | 38 |
2420944 | 2420944 | 2022-04-18 | Lynn | Texas | 48305 | 1551 | 38 |
2417688 | 2417688 | 2022-04-17 | Lynn | Texas | 48305 | 1548 | 38 |
2414432 | 2414432 | 2022-04-16 | Lynn | Texas | 48305 | 1548 | 38 |
2411176 | 2411176 | 2022-04-15 | Lynn | Texas | 48305 | 1548 | 38 |
2407920 | 2407920 | 2022-04-14 | Lynn | Texas | 48305 | 1548 | 38 |
2404664 | 2404664 | 2022-04-13 | Lynn | Texas | 48305 | 1548 | 38 |
2401409 | 2401409 | 2022-04-12 | Lynn | Texas | 48305 | 1548 | 38 |
2398154 | 2398154 | 2022-04-11 | Lynn | Texas | 48305 | 1546 | 38 |
2394899 | 2394899 | 2022-04-10 | Lynn | Texas | 48305 | 1546 | 38 |
2391643 | 2391643 | 2022-04-09 | Lynn | Texas | 48305 | 1546 | 38 |
2388387 | 2388387 | 2022-04-08 | Lynn | Texas | 48305 | 1545 | 38 |
2385132 | 2385132 | 2022-04-07 | Lynn | Texas | 48305 | 1539 | 38 |
2381877 | 2381877 | 2022-04-06 | Lynn | Texas | 48305 | 1539 | 38 |
2378622 | 2378622 | 2022-04-05 | Lynn | Texas | 48305 | 1539 | 38 |
2375368 | 2375368 | 2022-04-04 | Lynn | Texas | 48305 | 1533 | 38 |
2372116 | 2372116 | 2022-04-03 | Lynn | Texas | 48305 | 1533 | 38 |
2368863 | 2368863 | 2022-04-02 | Lynn | Texas | 48305 | 1533 | 38 |
2365610 | 2365610 | 2022-04-01 | Lynn | Texas | 48305 | 1533 | 38 |
2362357 | 2362357 | 2022-03-31 | Lynn | Texas | 48305 | 1533 | 38 |
2359103 | 2359103 | 2022-03-30 | Lynn | Texas | 48305 | 1533 | 38 |
2355849 | 2355849 | 2022-03-29 | Lynn | Texas | 48305 | 1533 | 38 |
2352596 | 2352596 | 2022-03-28 | Lynn | Texas | 48305 | 1529 | 38 |
2349344 | 2349344 | 2022-03-27 | Lynn | Texas | 48305 | 1529 | 38 |
2346091 | 2346091 | 2022-03-26 | Lynn | Texas | 48305 | 1529 | 38 |
2342838 | 2342838 | 2022-03-25 | Lynn | Texas | 48305 | 1519 | 38 |
2339585 | 2339585 | 2022-03-24 | Lynn | Texas | 48305 | 1486 | 38 |
2336331 | 2336331 | 2022-03-23 | Lynn | Texas | 48305 | 1483 | 38 |
2333077 | 2333077 | 2022-03-22 | Lynn | Texas | 48305 | 1466 | 38 |
2329824 | 2329824 | 2022-03-21 | Lynn | Texas | 48305 | 1460 | 38 |
2326572 | 2326572 | 2022-03-20 | Lynn | Texas | 48305 | 1460 | 38 |
2323319 | 2323319 | 2022-03-19 | Lynn | Texas | 48305 | 1460 | 38 |
2320065 | 2320065 | 2022-03-18 | Lynn | Texas | 48305 | 1460 | 38 |
2316811 | 2316811 | 2022-03-17 | Lynn | Texas | 48305 | 1458 | 38 |
2313558 | 2313558 | 2022-03-16 | Lynn | Texas | 48305 | 1458 | 38 |
2310161 | 2310161 | 2022-03-15 | Bailey | Texas | 48017 | 1403 | 38 |
2310305 | 2310305 | 2022-03-15 | Lynn | Texas | 48305 | 1458 | 38 |
2306908 | 2306908 | 2022-03-14 | Bailey | Texas | 48017 | 1400 | 38 |
2307052 | 2307052 | 2022-03-14 | Lynn | Texas | 48305 | 1458 | 38 |
2303657 | 2303657 | 2022-03-13 | Bailey | Texas | 48017 | 1400 | 38 |
2303801 | 2303801 | 2022-03-13 | Lynn | Texas | 48305 | 1458 | 38 |
2300405 | 2300405 | 2022-03-12 | Bailey | Texas | 48017 | 1400 | 38 |
2300549 | 2300549 | 2022-03-12 | Lynn | Texas | 48305 | 1458 | 38 |
2297153 | 2297153 | 2022-03-11 | Bailey | Texas | 48017 | 1399 | 38 |
2297297 | 2297297 | 2022-03-11 | Lynn | Texas | 48305 | 1458 | 38 |
2293901 | 2293901 | 2022-03-10 | Bailey | Texas | 48017 | 1395 | 38 |
2290649 | 2290649 | 2022-03-09 | Bailey | Texas | 48017 | 1385 | 38 |
2287397 | 2287397 | 2022-03-08 | Bailey | Texas | 48017 | 1382 | 38 |
2284145 | 2284145 | 2022-03-07 | Bailey | Texas | 48017 | 1381 | 38 |
2280893 | 2280893 | 2022-03-06 | Bailey | Texas | 48017 | 1381 | 38 |
2277640 | 2277640 | 2022-03-05 | Bailey | Texas | 48017 | 1381 | 38 |
2274387 | 2274387 | 2022-03-04 | Bailey | Texas | 48017 | 1380 | 38 |
2271134 | 2271134 | 2022-03-03 | Bailey | Texas | 48017 | 1380 | 38 |
2267882 | 2267882 | 2022-03-02 | Bailey | Texas | 48017 | 1380 | 38 |
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);