ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,420 rows where deaths = 29 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Hamilton 212
- Crosby 141
- Hansford 73
- Floyd 63
- San Saba 55
- Brewster 52
- Madison 43
- Dallam 36
- Falls 35
- Yoakum 35
- Ochiltree 29
- Wilson 26
- San Augustine 24
- Castro 23
- Lynn 23
- Mitchell 22
- Winkler 22
- Carson 20
- Stephens 19
- Mills 18
- Brooks 14
- Zapata 14
- La Salle 13
- Rains 13
- Rusk 12
- Blanco 11
- Robertson 11
- Grimes 10
- Newton 10
- Bailey 9
- …
state 1
- Texas · 1,420 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502228 | 2502228 | 2022-05-13 | Brewster | Texas | 48043 | 1079 | 29 |
2502304 | 2502304 | 2022-05-13 | Hansford | Texas | 48195 | 1929 | 29 |
2498970 | 2498970 | 2022-05-12 | Brewster | Texas | 48043 | 1076 | 29 |
2499046 | 2499046 | 2022-05-12 | Hansford | Texas | 48195 | 1929 | 29 |
2495712 | 2495712 | 2022-05-11 | Brewster | Texas | 48043 | 1074 | 29 |
2495788 | 2495788 | 2022-05-11 | Hansford | Texas | 48195 | 1929 | 29 |
2492454 | 2492454 | 2022-05-10 | Brewster | Texas | 48043 | 1070 | 29 |
2492530 | 2492530 | 2022-05-10 | Hansford | Texas | 48195 | 1929 | 29 |
2489196 | 2489196 | 2022-05-09 | Brewster | Texas | 48043 | 1070 | 29 |
2489272 | 2489272 | 2022-05-09 | Hansford | Texas | 48195 | 1929 | 29 |
2485939 | 2485939 | 2022-05-08 | Brewster | Texas | 48043 | 1070 | 29 |
2486015 | 2486015 | 2022-05-08 | Hansford | Texas | 48195 | 1929 | 29 |
2482681 | 2482681 | 2022-05-07 | Brewster | Texas | 48043 | 1070 | 29 |
2482757 | 2482757 | 2022-05-07 | Hansford | Texas | 48195 | 1929 | 29 |
2479423 | 2479423 | 2022-05-06 | Brewster | Texas | 48043 | 1070 | 29 |
2479499 | 2479499 | 2022-05-06 | Hansford | Texas | 48195 | 1929 | 29 |
2476165 | 2476165 | 2022-05-05 | Brewster | Texas | 48043 | 1069 | 29 |
2476241 | 2476241 | 2022-05-05 | Hansford | Texas | 48195 | 1929 | 29 |
2472908 | 2472908 | 2022-05-04 | Brewster | Texas | 48043 | 1068 | 29 |
2472984 | 2472984 | 2022-05-04 | Hansford | Texas | 48195 | 1929 | 29 |
2469652 | 2469652 | 2022-05-03 | Brewster | Texas | 48043 | 1068 | 29 |
2469728 | 2469728 | 2022-05-03 | Hansford | Texas | 48195 | 1929 | 29 |
2466396 | 2466396 | 2022-05-02 | Brewster | Texas | 48043 | 1066 | 29 |
2466472 | 2466472 | 2022-05-02 | Hansford | Texas | 48195 | 1929 | 29 |
2463141 | 2463141 | 2022-05-01 | Brewster | Texas | 48043 | 1066 | 29 |
2463217 | 2463217 | 2022-05-01 | Hansford | Texas | 48195 | 1929 | 29 |
2459885 | 2459885 | 2022-04-30 | Brewster | Texas | 48043 | 1066 | 29 |
2459961 | 2459961 | 2022-04-30 | Hansford | Texas | 48195 | 1929 | 29 |
2456629 | 2456629 | 2022-04-29 | Brewster | Texas | 48043 | 1066 | 29 |
2456705 | 2456705 | 2022-04-29 | Hansford | Texas | 48195 | 1929 | 29 |
2453373 | 2453373 | 2022-04-28 | Brewster | Texas | 48043 | 1066 | 29 |
2453449 | 2453449 | 2022-04-28 | Hansford | Texas | 48195 | 1929 | 29 |
2450117 | 2450117 | 2022-04-27 | Brewster | Texas | 48043 | 1066 | 29 |
2450193 | 2450193 | 2022-04-27 | Hansford | Texas | 48195 | 1929 | 29 |
2446860 | 2446860 | 2022-04-26 | Brewster | Texas | 48043 | 1066 | 29 |
2446936 | 2446936 | 2022-04-26 | Hansford | Texas | 48195 | 1929 | 29 |
2443605 | 2443605 | 2022-04-25 | Brewster | Texas | 48043 | 1066 | 29 |
2443681 | 2443681 | 2022-04-25 | Hansford | Texas | 48195 | 1929 | 29 |
2440349 | 2440349 | 2022-04-24 | Brewster | Texas | 48043 | 1066 | 29 |
2440425 | 2440425 | 2022-04-24 | Hansford | Texas | 48195 | 1929 | 29 |
2437093 | 2437093 | 2022-04-23 | Brewster | Texas | 48043 | 1066 | 29 |
2437169 | 2437169 | 2022-04-23 | Hansford | Texas | 48195 | 1929 | 29 |
2433837 | 2433837 | 2022-04-22 | Brewster | Texas | 48043 | 1066 | 29 |
2433913 | 2433913 | 2022-04-22 | Hansford | Texas | 48195 | 1929 | 29 |
2430581 | 2430581 | 2022-04-21 | Brewster | Texas | 48043 | 1065 | 29 |
2430657 | 2430657 | 2022-04-21 | Hansford | Texas | 48195 | 1927 | 29 |
2427325 | 2427325 | 2022-04-20 | Brewster | Texas | 48043 | 1065 | 29 |
2427401 | 2427401 | 2022-04-20 | Hansford | Texas | 48195 | 1926 | 29 |
2424069 | 2424069 | 2022-04-19 | Brewster | Texas | 48043 | 1065 | 29 |
2424145 | 2424145 | 2022-04-19 | Hansford | Texas | 48195 | 1925 | 29 |
2420813 | 2420813 | 2022-04-18 | Brewster | Texas | 48043 | 1065 | 29 |
2420889 | 2420889 | 2022-04-18 | Hansford | Texas | 48195 | 1924 | 29 |
2417557 | 2417557 | 2022-04-17 | Brewster | Texas | 48043 | 1065 | 29 |
2417633 | 2417633 | 2022-04-17 | Hansford | Texas | 48195 | 1922 | 29 |
2414301 | 2414301 | 2022-04-16 | Brewster | Texas | 48043 | 1065 | 29 |
2414377 | 2414377 | 2022-04-16 | Hansford | Texas | 48195 | 1922 | 29 |
2411045 | 2411045 | 2022-04-15 | Brewster | Texas | 48043 | 1065 | 29 |
2411121 | 2411121 | 2022-04-15 | Hansford | Texas | 48195 | 1922 | 29 |
2407789 | 2407789 | 2022-04-14 | Brewster | Texas | 48043 | 1065 | 29 |
2407865 | 2407865 | 2022-04-14 | Hansford | Texas | 48195 | 1922 | 29 |
2404533 | 2404533 | 2022-04-13 | Brewster | Texas | 48043 | 1065 | 29 |
2404609 | 2404609 | 2022-04-13 | Hansford | Texas | 48195 | 1922 | 29 |
2401278 | 2401278 | 2022-04-12 | Brewster | Texas | 48043 | 1065 | 29 |
2401354 | 2401354 | 2022-04-12 | Hansford | Texas | 48195 | 1921 | 29 |
2398023 | 2398023 | 2022-04-11 | Brewster | Texas | 48043 | 1064 | 29 |
2398099 | 2398099 | 2022-04-11 | Hansford | Texas | 48195 | 1921 | 29 |
2394768 | 2394768 | 2022-04-10 | Brewster | Texas | 48043 | 1064 | 29 |
2394844 | 2394844 | 2022-04-10 | Hansford | Texas | 48195 | 1920 | 29 |
2391512 | 2391512 | 2022-04-09 | Brewster | Texas | 48043 | 1064 | 29 |
2391588 | 2391588 | 2022-04-09 | Hansford | Texas | 48195 | 1920 | 29 |
2388256 | 2388256 | 2022-04-08 | Brewster | Texas | 48043 | 1062 | 29 |
2388332 | 2388332 | 2022-04-08 | Hansford | Texas | 48195 | 1919 | 29 |
2385001 | 2385001 | 2022-04-07 | Brewster | Texas | 48043 | 1062 | 29 |
2385077 | 2385077 | 2022-04-07 | Hansford | Texas | 48195 | 1919 | 29 |
2381746 | 2381746 | 2022-04-06 | Brewster | Texas | 48043 | 1062 | 29 |
2381822 | 2381822 | 2022-04-06 | Hansford | Texas | 48195 | 1919 | 29 |
2378491 | 2378491 | 2022-04-05 | Brewster | Texas | 48043 | 1062 | 29 |
2378567 | 2378567 | 2022-04-05 | Hansford | Texas | 48195 | 1919 | 29 |
2375237 | 2375237 | 2022-04-04 | Brewster | Texas | 48043 | 1062 | 29 |
2375313 | 2375313 | 2022-04-04 | Hansford | Texas | 48195 | 1919 | 29 |
2371985 | 2371985 | 2022-04-03 | Brewster | Texas | 48043 | 1062 | 29 |
2372061 | 2372061 | 2022-04-03 | Hansford | Texas | 48195 | 1919 | 29 |
2368732 | 2368732 | 2022-04-02 | Brewster | Texas | 48043 | 1062 | 29 |
2368808 | 2368808 | 2022-04-02 | Hansford | Texas | 48195 | 1919 | 29 |
2365479 | 2365479 | 2022-04-01 | Brewster | Texas | 48043 | 1061 | 29 |
2365555 | 2365555 | 2022-04-01 | Hansford | Texas | 48195 | 1919 | 29 |
2362226 | 2362226 | 2022-03-31 | Brewster | Texas | 48043 | 1060 | 29 |
2362302 | 2362302 | 2022-03-31 | Hansford | Texas | 48195 | 1919 | 29 |
2358972 | 2358972 | 2022-03-30 | Brewster | Texas | 48043 | 1057 | 29 |
2359048 | 2359048 | 2022-03-30 | Hansford | Texas | 48195 | 1919 | 29 |
2355718 | 2355718 | 2022-03-29 | Brewster | Texas | 48043 | 1057 | 29 |
2355794 | 2355794 | 2022-03-29 | Hansford | Texas | 48195 | 1919 | 29 |
2352465 | 2352465 | 2022-03-28 | Brewster | Texas | 48043 | 1056 | 29 |
2352541 | 2352541 | 2022-03-28 | Hansford | Texas | 48195 | 1919 | 29 |
2349213 | 2349213 | 2022-03-27 | Brewster | Texas | 48043 | 1056 | 29 |
2349289 | 2349289 | 2022-03-27 | Hansford | Texas | 48195 | 1919 | 29 |
2345960 | 2345960 | 2022-03-26 | Brewster | Texas | 48043 | 1056 | 29 |
2346036 | 2346036 | 2022-03-26 | Hansford | Texas | 48195 | 1919 | 29 |
2342707 | 2342707 | 2022-03-25 | Brewster | Texas | 48043 | 1056 | 29 |
2342783 | 2342783 | 2022-03-25 | Hansford | Texas | 48195 | 1919 | 29 |
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);