ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,509 rows where deaths = 10 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Foard 309
- Dickens 220
- Kinney 192
- Concho 134
- Upton 113
- Reagan 90
- Wheeler 78
- Gillespie 70
- Live Oak 70
- Calhoun 43
- Coke 40
- Dallam 38
- Andrews 35
- Edwards 33
- Brown 31
- Franklin 29
- Real 28
- Kendall 27
- Menard 27
- Brewster 26
- Yoakum 25
- Sabine 23
- Kerr 21
- Refugio 21
- Fisher 20
- Gray 20
- Lynn 20
- Hidalgo 19
- Jim Hogg 18
- Crane 16
- …
state 1
- Texas · 2,509 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499084 | 2499084 | 2022-05-12 | Kinney | Texas | 48271 | 741 | 10 |
2495826 | 2495826 | 2022-05-11 | Kinney | Texas | 48271 | 741 | 10 |
2492568 | 2492568 | 2022-05-10 | Kinney | Texas | 48271 | 741 | 10 |
2489310 | 2489310 | 2022-05-09 | Kinney | Texas | 48271 | 741 | 10 |
2486053 | 2486053 | 2022-05-08 | Kinney | Texas | 48271 | 741 | 10 |
2482795 | 2482795 | 2022-05-07 | Kinney | Texas | 48271 | 741 | 10 |
2479537 | 2479537 | 2022-05-06 | Kinney | Texas | 48271 | 741 | 10 |
2476279 | 2476279 | 2022-05-05 | Kinney | Texas | 48271 | 741 | 10 |
2473022 | 2473022 | 2022-05-04 | Kinney | Texas | 48271 | 741 | 10 |
2469766 | 2469766 | 2022-05-03 | Kinney | Texas | 48271 | 741 | 10 |
2466510 | 2466510 | 2022-05-02 | Kinney | Texas | 48271 | 741 | 10 |
2463255 | 2463255 | 2022-05-01 | Kinney | Texas | 48271 | 741 | 10 |
2459999 | 2459999 | 2022-04-30 | Kinney | Texas | 48271 | 741 | 10 |
2456743 | 2456743 | 2022-04-29 | Kinney | Texas | 48271 | 741 | 10 |
2453487 | 2453487 | 2022-04-28 | Kinney | Texas | 48271 | 741 | 10 |
2450231 | 2450231 | 2022-04-27 | Kinney | Texas | 48271 | 741 | 10 |
2446974 | 2446974 | 2022-04-26 | Kinney | Texas | 48271 | 740 | 10 |
2443719 | 2443719 | 2022-04-25 | Kinney | Texas | 48271 | 740 | 10 |
2440463 | 2440463 | 2022-04-24 | Kinney | Texas | 48271 | 740 | 10 |
2437207 | 2437207 | 2022-04-23 | Kinney | Texas | 48271 | 740 | 10 |
2433951 | 2433951 | 2022-04-22 | Kinney | Texas | 48271 | 740 | 10 |
2430695 | 2430695 | 2022-04-21 | Kinney | Texas | 48271 | 740 | 10 |
2427439 | 2427439 | 2022-04-20 | Kinney | Texas | 48271 | 740 | 10 |
2424183 | 2424183 | 2022-04-19 | Kinney | Texas | 48271 | 740 | 10 |
2420927 | 2420927 | 2022-04-18 | Kinney | Texas | 48271 | 740 | 10 |
2417671 | 2417671 | 2022-04-17 | Kinney | Texas | 48271 | 740 | 10 |
2414415 | 2414415 | 2022-04-16 | Kinney | Texas | 48271 | 740 | 10 |
2411159 | 2411159 | 2022-04-15 | Kinney | Texas | 48271 | 740 | 10 |
2407903 | 2407903 | 2022-04-14 | Kinney | Texas | 48271 | 740 | 10 |
2404647 | 2404647 | 2022-04-13 | Kinney | Texas | 48271 | 740 | 10 |
2401392 | 2401392 | 2022-04-12 | Kinney | Texas | 48271 | 740 | 10 |
2398137 | 2398137 | 2022-04-11 | Kinney | Texas | 48271 | 740 | 10 |
2394882 | 2394882 | 2022-04-10 | Kinney | Texas | 48271 | 740 | 10 |
2391626 | 2391626 | 2022-04-09 | Kinney | Texas | 48271 | 739 | 10 |
2388370 | 2388370 | 2022-04-08 | Kinney | Texas | 48271 | 739 | 10 |
2385115 | 2385115 | 2022-04-07 | Kinney | Texas | 48271 | 738 | 10 |
2381860 | 2381860 | 2022-04-06 | Kinney | Texas | 48271 | 738 | 10 |
2378605 | 2378605 | 2022-04-05 | Kinney | Texas | 48271 | 737 | 10 |
2375351 | 2375351 | 2022-04-04 | Kinney | Texas | 48271 | 737 | 10 |
2372099 | 2372099 | 2022-04-03 | Kinney | Texas | 48271 | 737 | 10 |
2368846 | 2368846 | 2022-04-02 | Kinney | Texas | 48271 | 737 | 10 |
2365593 | 2365593 | 2022-04-01 | Kinney | Texas | 48271 | 737 | 10 |
2362340 | 2362340 | 2022-03-31 | Kinney | Texas | 48271 | 737 | 10 |
2359086 | 2359086 | 2022-03-30 | Kinney | Texas | 48271 | 737 | 10 |
2355832 | 2355832 | 2022-03-29 | Kinney | Texas | 48271 | 737 | 10 |
2352579 | 2352579 | 2022-03-28 | Kinney | Texas | 48271 | 737 | 10 |
2349327 | 2349327 | 2022-03-27 | Kinney | Texas | 48271 | 737 | 10 |
2346074 | 2346074 | 2022-03-26 | Kinney | Texas | 48271 | 737 | 10 |
2342821 | 2342821 | 2022-03-25 | Kinney | Texas | 48271 | 737 | 10 |
2339568 | 2339568 | 2022-03-24 | Kinney | Texas | 48271 | 736 | 10 |
2336314 | 2336314 | 2022-03-23 | Kinney | Texas | 48271 | 736 | 10 |
2333060 | 2333060 | 2022-03-22 | Kinney | Texas | 48271 | 736 | 10 |
2329807 | 2329807 | 2022-03-21 | Kinney | Texas | 48271 | 736 | 10 |
2326555 | 2326555 | 2022-03-20 | Kinney | Texas | 48271 | 736 | 10 |
2323302 | 2323302 | 2022-03-19 | Kinney | Texas | 48271 | 736 | 10 |
2320048 | 2320048 | 2022-03-18 | Kinney | Texas | 48271 | 736 | 10 |
2316794 | 2316794 | 2022-03-17 | Kinney | Texas | 48271 | 736 | 10 |
2313541 | 2313541 | 2022-03-16 | Kinney | Texas | 48271 | 736 | 10 |
2310288 | 2310288 | 2022-03-15 | Kinney | Texas | 48271 | 736 | 10 |
2307035 | 2307035 | 2022-03-14 | Kinney | Texas | 48271 | 736 | 10 |
2303784 | 2303784 | 2022-03-13 | Kinney | Texas | 48271 | 736 | 10 |
2300532 | 2300532 | 2022-03-12 | Kinney | Texas | 48271 | 736 | 10 |
2297280 | 2297280 | 2022-03-11 | Kinney | Texas | 48271 | 736 | 10 |
2294028 | 2294028 | 2022-03-10 | Kinney | Texas | 48271 | 735 | 10 |
2290776 | 2290776 | 2022-03-09 | Kinney | Texas | 48271 | 735 | 10 |
2287524 | 2287524 | 2022-03-08 | Kinney | Texas | 48271 | 735 | 10 |
2284272 | 2284272 | 2022-03-07 | Kinney | Texas | 48271 | 733 | 10 |
2281020 | 2281020 | 2022-03-06 | Kinney | Texas | 48271 | 733 | 10 |
2277767 | 2277767 | 2022-03-05 | Kinney | Texas | 48271 | 733 | 10 |
2274514 | 2274514 | 2022-03-04 | Kinney | Texas | 48271 | 733 | 10 |
2271261 | 2271261 | 2022-03-03 | Kinney | Texas | 48271 | 732 | 10 |
2268009 | 2268009 | 2022-03-02 | Kinney | Texas | 48271 | 730 | 10 |
2264756 | 2264756 | 2022-03-01 | Kinney | Texas | 48271 | 726 | 10 |
2261506 | 2261506 | 2022-02-28 | Kinney | Texas | 48271 | 723 | 10 |
2258255 | 2258255 | 2022-02-27 | Kinney | Texas | 48271 | 723 | 10 |
2255004 | 2255004 | 2022-02-26 | Kinney | Texas | 48271 | 723 | 10 |
2251753 | 2251753 | 2022-02-25 | Kinney | Texas | 48271 | 723 | 10 |
2248502 | 2248502 | 2022-02-24 | Kinney | Texas | 48271 | 723 | 10 |
2245251 | 2245251 | 2022-02-23 | Kinney | Texas | 48271 | 722 | 10 |
2241933 | 2241933 | 2022-02-22 | Edwards | Texas | 48137 | 458 | 10 |
2242000 | 2242000 | 2022-02-22 | Kinney | Texas | 48271 | 722 | 10 |
2238682 | 2238682 | 2022-02-21 | Edwards | Texas | 48137 | 458 | 10 |
2238749 | 2238749 | 2022-02-21 | Kinney | Texas | 48271 | 721 | 10 |
2235431 | 2235431 | 2022-02-20 | Edwards | Texas | 48137 | 458 | 10 |
2235498 | 2235498 | 2022-02-20 | Kinney | Texas | 48271 | 720 | 10 |
2232180 | 2232180 | 2022-02-19 | Edwards | Texas | 48137 | 458 | 10 |
2232247 | 2232247 | 2022-02-19 | Kinney | Texas | 48271 | 720 | 10 |
2228929 | 2228929 | 2022-02-18 | Edwards | Texas | 48137 | 458 | 10 |
2228996 | 2228996 | 2022-02-18 | Kinney | Texas | 48271 | 720 | 10 |
2225678 | 2225678 | 2022-02-17 | Edwards | Texas | 48137 | 458 | 10 |
2225745 | 2225745 | 2022-02-17 | Kinney | Texas | 48271 | 719 | 10 |
2222427 | 2222427 | 2022-02-16 | Edwards | Texas | 48137 | 458 | 10 |
2222494 | 2222494 | 2022-02-16 | Kinney | Texas | 48271 | 717 | 10 |
2219176 | 2219176 | 2022-02-15 | Edwards | Texas | 48137 | 458 | 10 |
2219243 | 2219243 | 2022-02-15 | Kinney | Texas | 48271 | 717 | 10 |
2215925 | 2215925 | 2022-02-14 | Edwards | Texas | 48137 | 456 | 10 |
2215992 | 2215992 | 2022-02-14 | Kinney | Texas | 48271 | 717 | 10 |
2212674 | 2212674 | 2022-02-13 | Edwards | Texas | 48137 | 456 | 10 |
2212741 | 2212741 | 2022-02-13 | Kinney | Texas | 48271 | 717 | 10 |
2209421 | 2209421 | 2022-02-12 | Edwards | Texas | 48137 | 456 | 10 |
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);