ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
255 rows where "date" is on date 2022-01-26 and state = "Texas" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
2154178 | 2154178 | 2022-01-26 | King | Texas | 48269 | 39 | 0 |
2154174 | 2154174 | 2022-01-26 | Kenedy | Texas | 48261 | 68 | 2 |
2154060 | 2154060 | 2022-01-26 | Borden | Texas | 48033 | 92 | 2 |
2154194 | 2154194 | 2022-01-26 | Loving | Texas | 48301 | 95 | 0 |
2154265 | 2154265 | 2022-01-26 | Terrell | Texas | 48443 | 111 | 3 |
2154205 | 2154205 | 2022-01-26 | McMullen | Texas | 48311 | 147 | 8 |
2154240 | 2154240 | 2022-01-26 | Roberts | Texas | 48393 | 155 | 1 |
2154130 | 2154130 | 2022-01-26 | Glasscock | Texas | 48173 | 187 | 3 |
2154121 | 2154121 | 2022-01-26 | Foard | Texas | 48155 | 189 | 10 |
2154175 | 2154175 | 2022-01-26 | Kent | Texas | 48263 | 190 | 3 |
2154165 | 2154165 | 2022-01-26 | Jeff Davis | Texas | 48243 | 213 | 8 |
2154259 | 2154259 | 2022-01-26 | Sterling | Texas | 48431 | 238 | 5 |
2154267 | 2154267 | 2022-01-26 | Throckmorton | Texas | 48447 | 249 | 7 |
2154216 | 2154216 | 2022-01-26 | Motley | Texas | 48345 | 251 | 10 |
2154094 | 2154094 | 2022-01-26 | Cottle | Texas | 48101 | 267 | 9 |
2154260 | 2154260 | 2022-01-26 | Stonewall | Texas | 48433 | 303 | 7 |
2154161 | 2154161 | 2022-01-26 | Irion | Texas | 48235 | 380 | 2 |
2154106 | 2154106 | 2022-01-26 | Dickens | Texas | 48125 | 395 | 15 |
2154066 | 2154066 | 2022-01-26 | Briscoe | Texas | 48045 | 416 | 8 |
2154112 | 2154112 | 2022-01-26 | Edwards | Texas | 48137 | 416 | 10 |
2154254 | 2154254 | 2022-01-26 | Sherman | Texas | 48421 | 453 | 16 |
2154207 | 2154207 | 2022-01-26 | Menard | Texas | 48327 | 455 | 12 |
2154250 | 2154250 | 2022-01-26 | Schleicher | Texas | 48413 | 462 | 9 |
2154181 | 2154181 | 2022-01-26 | Knox | Texas | 48275 | 463 | 22 |
2154049 | 2154049 | 2022-01-26 | Armstrong | Texas | 48011 | 468 | 8 |
2154098 | 2154098 | 2022-01-26 | Culberson | Texas | 48109 | 481 | 13 |
2154223 | 2154223 | 2022-01-26 | Oldham | Texas | 48359 | 508 | 6 |
2154142 | 2154142 | 2022-01-26 | Hardeman | Texas | 48197 | 534 | 14 |
2154119 | 2154119 | 2022-01-26 | Fisher | Texas | 48151 | 550 | 20 |
2154191 | 2154191 | 2022-01-26 | Lipscomb | Texas | 48295 | 589 | 13 |
2154252 | 2154252 | 2022-01-26 | Shackelford | Texas | 48417 | 605 | 11 |
2154177 | 2154177 | 2022-01-26 | Kimble | Texas | 48267 | 609 | 12 |
2154087 | 2154087 | 2022-01-26 | Collingsworth | Texas | 48087 | 613 | 13 |
2154179 | 2154179 | 2022-01-26 | Kinney | Texas | 48271 | 683 | 10 |
2154200 | 2154200 | 2022-01-26 | Mason | Texas | 48319 | 714 | 9 |
2154261 | 2154261 | 2022-01-26 | Sutton | Texas | 48435 | 729 | 11 |
2154236 | 2154236 | 2022-01-26 | Real | Texas | 48385 | 732 | 22 |
2154275 | 2154275 | 2022-01-26 | Upton | Texas | 48461 | 748 | 16 |
2154055 | 2154055 | 2022-01-26 | Baylor | Texas | 48023 | 753 | 28 |
2154235 | 2154235 | 2022-01-26 | Reagan | Texas | 48383 | 775 | 11 |
2154083 | 2154083 | 2022-01-26 | Cochran | Texas | 48079 | 786 | 21 |
2154084 | 2154084 | 2022-01-26 | Coke | Texas | 48081 | 794 | 18 |
2154147 | 2154147 | 2022-01-26 | Haskell | Texas | 48207 | 849 | 37 |
2154158 | 2154158 | 2022-01-26 | Hudspeth | Texas | 48229 | 880 | 16 |
2154139 | 2154139 | 2022-01-26 | Hall | Texas | 48191 | 889 | 19 |
2154108 | 2154108 | 2022-01-26 | Donley | Texas | 48129 | 920 | 20 |
2154232 | 2154232 | 2022-01-26 | Presidio | Texas | 48377 | 925 | 32 |
2154091 | 2154091 | 2022-01-26 | Concho | Texas | 48095 | 976 | 10 |
2154246 | 2154246 | 2022-01-26 | San Augustine | Texas | 48405 | 985 | 38 |
2154096 | 2154096 | 2022-01-26 | Crockett | Texas | 48105 | 986 | 17 |
2154065 | 2154065 | 2022-01-26 | Brewster | Texas | 48043 | 995 | 25 |
2154149 | 2154149 | 2022-01-26 | Hemphill | Texas | 48211 | 1005 | 4 |
2154295 | 2154295 | 2022-01-26 | Yoakum | Texas | 48501 | 1007 | 37 |
2154131 | 2154131 | 2022-01-26 | Goliad | Texas | 48175 | 1031 | 28 |
2154199 | 2154199 | 2022-01-26 | Martin | Texas | 48317 | 1072 | 24 |
2154286 | 2154286 | 2022-01-26 | Wheeler | Texas | 48483 | 1097 | 15 |
2154095 | 2154095 | 2022-01-26 | Crane | Texas | 48103 | 1122 | 19 |
2154249 | 2154249 | 2022-01-26 | San Saba | Texas | 48411 | 1155 | 31 |
2154245 | 2154245 | 2022-01-26 | Sabine | Texas | 48403 | 1159 | 78 |
2154128 | 2154128 | 2022-01-26 | Garza | Texas | 48169 | 1163 | 25 |
2154203 | 2154203 | 2022-01-26 | McCulloch | Texas | 48307 | 1186 | 42 |
2154219 | 2154219 | 2022-01-26 | Newton | Texas | 48351 | 1186 | 56 |
2154146 | 2154146 | 2022-01-26 | Hartley | Texas | 48205 | 1217 | 3 |
2154196 | 2154196 | 2022-01-26 | Lynn | Texas | 48305 | 1299 | 31 |
2154052 | 2154052 | 2022-01-26 | Bailey | Texas | 48017 | 1322 | 31 |
2154210 | 2154210 | 2022-01-26 | Mills | Texas | 48333 | 1369 | 29 |
2154076 | 2154076 | 2022-01-26 | Carson | Texas | 48065 | 1370 | 31 |
2154162 | 2154162 | 2022-01-26 | Jack | Texas | 48237 | 1374 | 23 |
2154067 | 2154067 | 2022-01-26 | Brooks | Texas | 48047 | 1440 | 49 |
2154198 | 2154198 | 2022-01-26 | Marion | Texas | 48315 | 1488 | 55 |
2154085 | 2154085 | 2022-01-26 | Coleman | Texas | 48083 | 1521 | 64 |
2154141 | 2154141 | 2022-01-26 | Hansford | Texas | 48195 | 1551 | 27 |
2154239 | 2154239 | 2022-01-26 | Refugio | Texas | 48391 | 1594 | 31 |
2154104 | 2154104 | 2022-01-26 | Delta | Texas | 48119 | 1633 | 22 |
2154292 | 2154292 | 2022-01-26 | Winkler | Texas | 48495 | 1645 | 33 |
2154126 | 2154126 | 2022-01-26 | Gaines | Texas | 48165 | 1649 | 73 |
2154258 | 2154258 | 2022-01-26 | Stephens | Texas | 48429 | 1693 | 40 |
2154233 | 2154233 | 2022-01-26 | Rains | Texas | 48379 | 1698 | 51 |
2154097 | 2154097 | 2022-01-26 | Crosby | Texas | 48107 | 1744 | 44 |
2154211 | 2154211 | 2022-01-26 | Mitchell | Texas | 48335 | 1748 | 45 |
2154120 | 2154120 | 2022-01-26 | Floyd | Texas | 48153 | 1814 | 42 |
2154262 | 2154262 | 2022-01-26 | Swisher | Texas | 48437 | 1823 | 30 |
2154140 | 2154140 | 2022-01-26 | Hamilton | Texas | 48193 | 1868 | 29 |
2154167 | 2154167 | 2022-01-26 | Jim Hogg | Texas | 48247 | 1880 | 20 |
2154123 | 2154123 | 2022-01-26 | Franklin | Texas | 48159 | 1888 | 37 |
2154099 | 2154099 | 2022-01-26 | Dallam | Texas | 48111 | 1903 | 33 |
2154048 | 2154048 | 2022-01-26 | Archer | Texas | 48009 | 1925 | 24 |
2154082 | 2154082 | 2022-01-26 | Clay | Texas | 48077 | 1932 | 27 |
2154222 | 2154222 | 2022-01-26 | Ochiltree | Texas | 48357 | 1935 | 42 |
2154256 | 2154256 | 2022-01-26 | Somervell | Texas | 48425 | 1941 | 31 |
2154192 | 2154192 | 2022-01-26 | Live Oak | Texas | 48297 | 1989 | 39 |
2154237 | 2154237 | 2022-01-26 | Red River | Texas | 48387 | 2026 | 59 |
2154266 | 2154266 | 2022-01-26 | Terry | Texas | 48445 | 2035 | 79 |
2154182 | 2154182 | 2022-01-26 | La Salle | Texas | 48283 | 2041 | 41 |
2154228 | 2154228 | 2022-01-26 | Parmer | Texas | 48369 | 2098 | 46 |
2154243 | 2154243 | 2022-01-26 | Runnels | Texas | 48399 | 2119 | 59 |
2154078 | 2154078 | 2022-01-26 | Castro | Texas | 48069 | 2124 | 45 |
2154059 | 2154059 | 2022-01-26 | Blanco | Texas | 48031 | 2234 | 29 |
2154081 | 2154081 | 2022-01-26 | Childress | Texas | 48075 | 2238 | 26 |
2154215 | 2154215 | 2022-01-26 | Morris | Texas | 48343 | 2295 | 61 |
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);