ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,007 rows where deaths = 40 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- La Salle 69
- Floyd 59
- Live Oak 43
- Callahan 39
- Dallam 36
- Lee 34
- Bee 33
- McCulloch 27
- Navarro 26
- Robertson 25
- Runnels 22
- Franklin 21
- Galveston 20
- Shelby 20
- Caldwell 18
- Calhoun 18
- Reeves 17
- Aransas 16
- Mitchell 16
- Camp 15
- Castro 15
- Madison 14
- Crosby 13
- Red River 13
- Leon 12
- Yoakum 12
- Freestone 11
- Jasper 11
- Stephens 11
- Zapata 10
- …
state 1
- Texas · 1,007 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502262 | 2502262 | 2022-05-13 | Dallam | Texas | 48111 | 2155 | 40 |
2499004 | 2499004 | 2022-05-12 | Dallam | Texas | 48111 | 2155 | 40 |
2495746 | 2495746 | 2022-05-11 | Dallam | Texas | 48111 | 2155 | 40 |
2492488 | 2492488 | 2022-05-10 | Dallam | Texas | 48111 | 2155 | 40 |
2489230 | 2489230 | 2022-05-09 | Dallam | Texas | 48111 | 2155 | 40 |
2485973 | 2485973 | 2022-05-08 | Dallam | Texas | 48111 | 2155 | 40 |
2404567 | 2404567 | 2022-04-13 | Dallam | Texas | 48111 | 2153 | 40 |
2401312 | 2401312 | 2022-04-12 | Dallam | Texas | 48111 | 2153 | 40 |
2398057 | 2398057 | 2022-04-11 | Dallam | Texas | 48111 | 2152 | 40 |
2394802 | 2394802 | 2022-04-10 | Dallam | Texas | 48111 | 2152 | 40 |
2339488 | 2339488 | 2022-03-24 | Dallam | Texas | 48111 | 2148 | 40 |
2336234 | 2336234 | 2022-03-23 | Dallam | Texas | 48111 | 2148 | 40 |
2332980 | 2332980 | 2022-03-22 | Dallam | Texas | 48111 | 2147 | 40 |
2329727 | 2329727 | 2022-03-21 | Dallam | Texas | 48111 | 2147 | 40 |
2326475 | 2326475 | 2022-03-20 | Dallam | Texas | 48111 | 2147 | 40 |
2323222 | 2323222 | 2022-03-19 | Dallam | Texas | 48111 | 2147 | 40 |
2319968 | 2319968 | 2022-03-18 | Dallam | Texas | 48111 | 2147 | 40 |
2316714 | 2316714 | 2022-03-17 | Dallam | Texas | 48111 | 2141 | 40 |
2313461 | 2313461 | 2022-03-16 | Dallam | Texas | 48111 | 2132 | 40 |
2313485 | 2313485 | 2022-03-16 | Franklin | Texas | 48159 | 2160 | 40 |
2310208 | 2310208 | 2022-03-15 | Dallam | Texas | 48111 | 2132 | 40 |
2310232 | 2310232 | 2022-03-15 | Franklin | Texas | 48159 | 2158 | 40 |
2306955 | 2306955 | 2022-03-14 | Dallam | Texas | 48111 | 2129 | 40 |
2306979 | 2306979 | 2022-03-14 | Franklin | Texas | 48159 | 2150 | 40 |
2303704 | 2303704 | 2022-03-13 | Dallam | Texas | 48111 | 2129 | 40 |
2303728 | 2303728 | 2022-03-13 | Franklin | Texas | 48159 | 2150 | 40 |
2300452 | 2300452 | 2022-03-12 | Dallam | Texas | 48111 | 2129 | 40 |
2300476 | 2300476 | 2022-03-12 | Franklin | Texas | 48159 | 2150 | 40 |
2297200 | 2297200 | 2022-03-11 | Dallam | Texas | 48111 | 2129 | 40 |
2297224 | 2297224 | 2022-03-11 | Franklin | Texas | 48159 | 2140 | 40 |
2293948 | 2293948 | 2022-03-10 | Dallam | Texas | 48111 | 2128 | 40 |
2293972 | 2293972 | 2022-03-10 | Franklin | Texas | 48159 | 2140 | 40 |
2294041 | 2294041 | 2022-03-10 | Live Oak | Texas | 48297 | 2135 | 40 |
2290696 | 2290696 | 2022-03-09 | Dallam | Texas | 48111 | 2126 | 40 |
2290720 | 2290720 | 2022-03-09 | Franklin | Texas | 48159 | 2134 | 40 |
2290789 | 2290789 | 2022-03-09 | Live Oak | Texas | 48297 | 2135 | 40 |
2287444 | 2287444 | 2022-03-08 | Dallam | Texas | 48111 | 2126 | 40 |
2287468 | 2287468 | 2022-03-08 | Franklin | Texas | 48159 | 2123 | 40 |
2287537 | 2287537 | 2022-03-08 | Live Oak | Texas | 48297 | 2134 | 40 |
2284192 | 2284192 | 2022-03-07 | Dallam | Texas | 48111 | 2125 | 40 |
2284216 | 2284216 | 2022-03-07 | Franklin | Texas | 48159 | 2118 | 40 |
2284285 | 2284285 | 2022-03-07 | Live Oak | Texas | 48297 | 2134 | 40 |
2280940 | 2280940 | 2022-03-06 | Dallam | Texas | 48111 | 2125 | 40 |
2280964 | 2280964 | 2022-03-06 | Franklin | Texas | 48159 | 2116 | 40 |
2281033 | 2281033 | 2022-03-06 | Live Oak | Texas | 48297 | 2134 | 40 |
2277687 | 2277687 | 2022-03-05 | Dallam | Texas | 48111 | 2125 | 40 |
2277711 | 2277711 | 2022-03-05 | Franklin | Texas | 48159 | 2115 | 40 |
2277780 | 2277780 | 2022-03-05 | Live Oak | Texas | 48297 | 2134 | 40 |
2274434 | 2274434 | 2022-03-04 | Dallam | Texas | 48111 | 2122 | 40 |
2274458 | 2274458 | 2022-03-04 | Franklin | Texas | 48159 | 2112 | 40 |
2274527 | 2274527 | 2022-03-04 | Live Oak | Texas | 48297 | 2134 | 40 |
2271181 | 2271181 | 2022-03-03 | Dallam | Texas | 48111 | 2122 | 40 |
2271205 | 2271205 | 2022-03-03 | Franklin | Texas | 48159 | 2108 | 40 |
2271274 | 2271274 | 2022-03-03 | Live Oak | Texas | 48297 | 2134 | 40 |
2267929 | 2267929 | 2022-03-02 | Dallam | Texas | 48111 | 2122 | 40 |
2267953 | 2267953 | 2022-03-02 | Franklin | Texas | 48159 | 2103 | 40 |
2268022 | 2268022 | 2022-03-02 | Live Oak | Texas | 48297 | 2134 | 40 |
2268124 | 2268124 | 2022-03-02 | Yoakum | Texas | 48501 | 1056 | 40 |
2264676 | 2264676 | 2022-03-01 | Dallam | Texas | 48111 | 2122 | 40 |
2264700 | 2264700 | 2022-03-01 | Franklin | Texas | 48159 | 2102 | 40 |
2264769 | 2264769 | 2022-03-01 | Live Oak | Texas | 48297 | 2131 | 40 |
2264871 | 2264871 | 2022-03-01 | Yoakum | Texas | 48501 | 1056 | 40 |
2261426 | 2261426 | 2022-02-28 | Dallam | Texas | 48111 | 2117 | 40 |
2261450 | 2261450 | 2022-02-28 | Franklin | Texas | 48159 | 2102 | 40 |
2261519 | 2261519 | 2022-02-28 | Live Oak | Texas | 48297 | 2130 | 40 |
2261621 | 2261621 | 2022-02-28 | Yoakum | Texas | 48501 | 1055 | 40 |
2258175 | 2258175 | 2022-02-27 | Dallam | Texas | 48111 | 2117 | 40 |
2258199 | 2258199 | 2022-02-27 | Franklin | Texas | 48159 | 2101 | 40 |
2258268 | 2258268 | 2022-02-27 | Live Oak | Texas | 48297 | 2130 | 40 |
2258370 | 2258370 | 2022-02-27 | Yoakum | Texas | 48501 | 1055 | 40 |
2254948 | 2254948 | 2022-02-26 | Franklin | Texas | 48159 | 2098 | 40 |
2255017 | 2255017 | 2022-02-26 | Live Oak | Texas | 48297 | 2130 | 40 |
2255119 | 2255119 | 2022-02-26 | Yoakum | Texas | 48501 | 1054 | 40 |
2251697 | 2251697 | 2022-02-25 | Franklin | Texas | 48159 | 2097 | 40 |
2251766 | 2251766 | 2022-02-25 | Live Oak | Texas | 48297 | 2129 | 40 |
2251868 | 2251868 | 2022-02-25 | Yoakum | Texas | 48501 | 1054 | 40 |
2248446 | 2248446 | 2022-02-24 | Franklin | Texas | 48159 | 2094 | 40 |
2248515 | 2248515 | 2022-02-24 | Live Oak | Texas | 48297 | 2126 | 40 |
2248617 | 2248617 | 2022-02-24 | Yoakum | Texas | 48501 | 1053 | 40 |
2245264 | 2245264 | 2022-02-23 | Live Oak | Texas | 48297 | 2125 | 40 |
2245318 | 2245318 | 2022-02-23 | San Augustine | Texas | 48405 | 1040 | 40 |
2245366 | 2245366 | 2022-02-23 | Yoakum | Texas | 48501 | 1053 | 40 |
2242013 | 2242013 | 2022-02-22 | Live Oak | Texas | 48297 | 2124 | 40 |
2242067 | 2242067 | 2022-02-22 | San Augustine | Texas | 48405 | 1040 | 40 |
2242115 | 2242115 | 2022-02-22 | Yoakum | Texas | 48501 | 1053 | 40 |
2238762 | 2238762 | 2022-02-21 | Live Oak | Texas | 48297 | 2123 | 40 |
2238816 | 2238816 | 2022-02-21 | San Augustine | Texas | 48405 | 1038 | 40 |
2238828 | 2238828 | 2022-02-21 | Stephens | Texas | 48429 | 1793 | 40 |
2238864 | 2238864 | 2022-02-21 | Yoakum | Texas | 48501 | 1053 | 40 |
2235511 | 2235511 | 2022-02-20 | Live Oak | Texas | 48297 | 2122 | 40 |
2235565 | 2235565 | 2022-02-20 | San Augustine | Texas | 48405 | 1038 | 40 |
2235577 | 2235577 | 2022-02-20 | Stephens | Texas | 48429 | 1793 | 40 |
2235613 | 2235613 | 2022-02-20 | Yoakum | Texas | 48501 | 1052 | 40 |
2232260 | 2232260 | 2022-02-19 | Live Oak | Texas | 48297 | 2122 | 40 |
2232314 | 2232314 | 2022-02-19 | San Augustine | Texas | 48405 | 1037 | 40 |
2232326 | 2232326 | 2022-02-19 | Stephens | Texas | 48429 | 1793 | 40 |
2232362 | 2232362 | 2022-02-19 | Yoakum | Texas | 48501 | 1052 | 40 |
2229009 | 2229009 | 2022-02-18 | Live Oak | Texas | 48297 | 2120 | 40 |
2229063 | 2229063 | 2022-02-18 | San Augustine | Texas | 48405 | 1034 | 40 |
2229075 | 2229075 | 2022-02-18 | Stephens | Texas | 48429 | 1785 | 40 |
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);