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-05-09 and state = "Texas" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
2489309 | 2489309 | 2022-05-09 | King | Texas | 48269 | 51 | 0 |
2489361 | 2489361 | 2022-05-09 | Pending County Assignment | Texas | 48999 | 65 | 0 |
2489325 | 2489325 | 2022-05-09 | Loving | Texas | 48301 | 195 | 1 |
2489191 | 2489191 | 2022-05-09 | Borden | Texas | 48033 | 99 | 2 |
2489305 | 2489305 | 2022-05-09 | Kenedy | Texas | 48261 | 86 | 2 |
2489372 | 2489372 | 2022-05-09 | Roberts | Texas | 48393 | 175 | 2 |
2489261 | 2489261 | 2022-05-09 | Glasscock | Texas | 48173 | 199 | 3 |
2489277 | 2489277 | 2022-05-09 | Hartley | Texas | 48205 | 1364 | 3 |
2489292 | 2489292 | 2022-05-09 | Irion | Texas | 48235 | 445 | 3 |
2489397 | 2489397 | 2022-05-09 | Terrell | Texas | 48443 | 121 | 3 |
2489306 | 2489306 | 2022-05-09 | Kent | Texas | 48263 | 210 | 4 |
2489354 | 2489354 | 2022-05-09 | Oldham | Texas | 48359 | 565 | 6 |
2489391 | 2489391 | 2022-05-09 | Sterling | Texas | 48431 | 245 | 6 |
2489280 | 2489280 | 2022-05-09 | Hemphill | Texas | 48211 | 1236 | 7 |
2489392 | 2489392 | 2022-05-09 | Stonewall | Texas | 48433 | 362 | 7 |
2489197 | 2489197 | 2022-05-09 | Briscoe | Texas | 48045 | 465 | 8 |
2489399 | 2489399 | 2022-05-09 | Throckmorton | Texas | 48447 | 270 | 8 |
2489180 | 2489180 | 2022-05-09 | Armstrong | Texas | 48011 | 555 | 9 |
2489225 | 2489225 | 2022-05-09 | Cottle | Texas | 48101 | 319 | 9 |
2489296 | 2489296 | 2022-05-09 | Jeff Davis | Texas | 48243 | 223 | 9 |
2489336 | 2489336 | 2022-05-09 | McMullen | Texas | 48311 | 169 | 9 |
2489382 | 2489382 | 2022-05-09 | Schleicher | Texas | 48413 | 528 | 9 |
2489310 | 2489310 | 2022-05-09 | Kinney | Texas | 48271 | 741 | 10 |
2489222 | 2489222 | 2022-05-09 | Concho | Texas | 48095 | 1084 | 11 |
2489243 | 2489243 | 2022-05-09 | Edwards | Texas | 48137 | 467 | 11 |
2489252 | 2489252 | 2022-05-09 | Foard | Texas | 48155 | 208 | 11 |
2489331 | 2489331 | 2022-05-09 | Mason | Texas | 48319 | 787 | 12 |
2489338 | 2489338 | 2022-05-09 | Menard | Texas | 48327 | 513 | 12 |
2489384 | 2489384 | 2022-05-09 | Shackelford | Texas | 48417 | 689 | 12 |
2489393 | 2489393 | 2022-05-09 | Sutton | Texas | 48435 | 847 | 12 |
2489347 | 2489347 | 2022-05-09 | Motley | Texas | 48345 | 286 | 13 |
2489229 | 2489229 | 2022-05-09 | Culberson | Texas | 48109 | 513 | 14 |
2489367 | 2489367 | 2022-05-09 | Reagan | Texas | 48383 | 859 | 14 |
2489308 | 2489308 | 2022-05-09 | Kimble | Texas | 48267 | 714 | 15 |
2489322 | 2489322 | 2022-05-09 | Lipscomb | Texas | 48295 | 720 | 15 |
2489218 | 2489218 | 2022-05-09 | Collingsworth | Texas | 48087 | 702 | 16 |
2489237 | 2489237 | 2022-05-09 | Dickens | Texas | 48125 | 453 | 16 |
2489386 | 2489386 | 2022-05-09 | Sherman | Texas | 48421 | 499 | 16 |
2489289 | 2489289 | 2022-05-09 | Hudspeth | Texas | 48229 | 989 | 18 |
2489406 | 2489406 | 2022-05-09 | Upton | Texas | 48461 | 833 | 18 |
2489227 | 2489227 | 2022-05-09 | Crockett | Texas | 48105 | 1091 | 19 |
2489273 | 2489273 | 2022-05-09 | Hardeman | Texas | 48197 | 556 | 19 |
2489215 | 2489215 | 2022-05-09 | Coke | Texas | 48081 | 842 | 20 |
2489298 | 2489298 | 2022-05-09 | Jim Hogg | Texas | 48247 | 2644 | 22 |
2489214 | 2489214 | 2022-05-09 | Cochran | Texas | 48079 | 891 | 23 |
2489270 | 2489270 | 2022-05-09 | Hall | Texas | 48191 | 1101 | 23 |
2489417 | 2489417 | 2022-05-09 | Wheeler | Texas | 48483 | 1193 | 23 |
2489226 | 2489226 | 2022-05-09 | Crane | Texas | 48103 | 1283 | 24 |
2489250 | 2489250 | 2022-05-09 | Fisher | Texas | 48151 | 609 | 24 |
2489235 | 2489235 | 2022-05-09 | Delta | Texas | 48119 | 1819 | 25 |
2489312 | 2489312 | 2022-05-09 | Knox | Texas | 48275 | 492 | 25 |
2489368 | 2489368 | 2022-05-09 | Real | Texas | 48385 | 817 | 25 |
2489239 | 2489239 | 2022-05-09 | Donley | Texas | 48129 | 1153 | 26 |
2489330 | 2489330 | 2022-05-09 | Martin | Texas | 48317 | 1207 | 26 |
2489179 | 2489179 | 2022-05-09 | Archer | Texas | 48009 | 2204 | 28 |
2489259 | 2489259 | 2022-05-09 | Garza | Texas | 48169 | 1276 | 28 |
2489293 | 2489293 | 2022-05-09 | Jack | Texas | 48237 | 1517 | 28 |
2489196 | 2489196 | 2022-05-09 | Brewster | Texas | 48043 | 1070 | 29 |
2489272 | 2489272 | 2022-05-09 | Hansford | Texas | 48195 | 1929 | 29 |
2489186 | 2489186 | 2022-05-09 | Baylor | Texas | 48023 | 818 | 32 |
2489262 | 2489262 | 2022-05-09 | Goliad | Texas | 48175 | 1211 | 32 |
2489212 | 2489212 | 2022-05-09 | Childress | Texas | 48075 | 2638 | 33 |
2489271 | 2489271 | 2022-05-09 | Hamilton | Texas | 48193 | 1971 | 33 |
2489190 | 2489190 | 2022-05-09 | Blanco | Texas | 48031 | 2561 | 34 |
2489394 | 2489394 | 2022-05-09 | Swisher | Texas | 48437 | 2285 | 34 |
2489423 | 2489423 | 2022-05-09 | Winkler | Texas | 48495 | 1846 | 34 |
2489213 | 2489213 | 2022-05-09 | Clay | Texas | 48077 | 2094 | 35 |
2489381 | 2489381 | 2022-05-09 | San Saba | Texas | 48411 | 1241 | 35 |
2489207 | 2489207 | 2022-05-09 | Carson | Texas | 48065 | 1531 | 36 |
2489371 | 2489371 | 2022-05-09 | Refugio | Texas | 48391 | 1781 | 36 |
2489388 | 2489388 | 2022-05-09 | Somervell | Texas | 48425 | 2115 | 36 |
2489341 | 2489341 | 2022-05-09 | Mills | Texas | 48333 | 1475 | 37 |
2489327 | 2489327 | 2022-05-09 | Lynn | Texas | 48305 | 1553 | 38 |
2489364 | 2489364 | 2022-05-09 | Presidio | Texas | 48377 | 997 | 38 |
2489183 | 2489183 | 2022-05-09 | Bailey | Texas | 48017 | 1511 | 39 |
2489278 | 2489278 | 2022-05-09 | Haskell | Texas | 48207 | 897 | 39 |
2489230 | 2489230 | 2022-05-09 | Dallam | Texas | 48111 | 2155 | 40 |
2489254 | 2489254 | 2022-05-09 | Franklin | Texas | 48159 | 2228 | 42 |
2489323 | 2489323 | 2022-05-09 | Live Oak | Texas | 48297 | 2152 | 42 |
2489426 | 2489426 | 2022-05-09 | Yoakum | Texas | 48501 | 1313 | 42 |
2489413 | 2489413 | 2022-05-09 | Ward | Texas | 48475 | 2829 | 43 |
2489378 | 2489378 | 2022-05-09 | San Augustine | Texas | 48405 | 1077 | 44 |
2489228 | 2489228 | 2022-05-09 | Crosby | Texas | 48107 | 1893 | 45 |
2489390 | 2489390 | 2022-05-09 | Stephens | Texas | 48429 | 1844 | 45 |
2489209 | 2489209 | 2022-05-09 | Castro | Texas | 48069 | 2296 | 47 |
2489334 | 2489334 | 2022-05-09 | McCulloch | Texas | 48307 | 1308 | 47 |
2489203 | 2489203 | 2022-05-09 | Calhoun | Texas | 48057 | 5722 | 48 |
2489251 | 2489251 | 2022-05-09 | Floyd | Texas | 48153 | 1960 | 48 |
2489313 | 2489313 | 2022-05-09 | La Salle | Texas | 48283 | 2416 | 48 |
2489342 | 2489342 | 2022-05-09 | Mitchell | Texas | 48335 | 1864 | 48 |
2489353 | 2489353 | 2022-05-09 | Ochiltree | Texas | 48357 | 2424 | 48 |
2489238 | 2489238 | 2022-05-09 | Dimmit | Texas | 48127 | 5759 | 51 |
2489198 | 2489198 | 2022-05-09 | Brooks | Texas | 48047 | 1642 | 52 |
2489359 | 2489359 | 2022-05-09 | Parmer | Texas | 48369 | 2363 | 52 |
2489328 | 2489328 | 2022-05-09 | Madison | Texas | 48313 | 3773 | 54 |
2489428 | 2489428 | 2022-05-09 | Zapata | Texas | 48505 | 3739 | 55 |
2489294 | 2489294 | 2022-05-09 | Jackson | Texas | 48239 | 3257 | 59 |
2489365 | 2489365 | 2022-05-09 | Rains | Texas | 48379 | 1839 | 59 |
2489318 | 2489318 | 2022-05-09 | Lee | Texas | 48287 | 4270 | 60 |
2489329 | 2489329 | 2022-05-09 | Marion | Texas | 48315 | 1690 | 60 |
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);