ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
254 rows where date = "2021-08-24" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1650305 | 1650305 | 2021-08-24 | Anderson | Texas | 48001 | 6240 | 136 |
1650306 | 1650306 | 2021-08-24 | Andrews | Texas | 48003 | 2036 | 48 |
1650307 | 1650307 | 2021-08-24 | Angelina | Texas | 48005 | 10591 | 300 |
1650308 | 1650308 | 2021-08-24 | Aransas | Texas | 48007 | 1840 | 46 |
1650309 | 1650309 | 2021-08-24 | Archer | Texas | 48009 | 886 | 12 |
1650310 | 1650310 | 2021-08-24 | Armstrong | Texas | 48011 | 232 | 7 |
1650311 | 1650311 | 2021-08-24 | Atascosa | Texas | 48013 | 6969 | 158 |
1650312 | 1650312 | 2021-08-24 | Austin | Texas | 48015 | 2635 | 39 |
1650313 | 1650313 | 2021-08-24 | Bailey | Texas | 48017 | 897 | 20 |
1650314 | 1650314 | 2021-08-24 | Bandera | Texas | 48019 | 1783 | 35 |
1650315 | 1650315 | 2021-08-24 | Bastrop | Texas | 48021 | 11855 | 117 |
1650316 | 1650316 | 2021-08-24 | Baylor | Texas | 48023 | 311 | 13 |
1650317 | 1650317 | 2021-08-24 | Bee | Texas | 48025 | 4332 | 82 |
1650318 | 1650318 | 2021-08-24 | Bell | Texas | 48027 | 30915 | 503 |
1650319 | 1650319 | 2021-08-24 | Bexar | Texas | 48029 | 275179 | 3883 |
1650320 | 1650320 | 2021-08-24 | Blanco | Texas | 48031 | 926 | 23 |
1650321 | 1650321 | 2021-08-24 | Borden | Texas | 48033 | 33 | 2 |
1650322 | 1650322 | 2021-08-24 | Bosque | Texas | 48035 | 1991 | 42 |
1650323 | 1650323 | 2021-08-24 | Bowie | Texas | 48037 | 9383 | 236 |
1650324 | 1650324 | 2021-08-24 | Brazoria | Texas | 48039 | 46666 | 593 |
1650325 | 1650325 | 2021-08-24 | Brazos | Texas | 48041 | 30369 | 281 |
1650326 | 1650326 | 2021-08-24 | Brewster | Texas | 48043 | 984 | 18 |
1650327 | 1650327 | 2021-08-24 | Briscoe | Texas | 48045 | 193 | 7 |
1650328 | 1650328 | 2021-08-24 | Brooks | Texas | 48047 | 1004 | 38 |
1650329 | 1650329 | 2021-08-24 | Brown | Texas | 48049 | 5197 | 150 |
1650330 | 1650330 | 2021-08-24 | Burleson | Texas | 48051 | 2750 | 48 |
1650331 | 1650331 | 2021-08-24 | Burnet | Texas | 48053 | 6027 | 80 |
1650332 | 1650332 | 2021-08-24 | Caldwell | Texas | 48055 | 6802 | 111 |
1650333 | 1650333 | 2021-08-24 | Calhoun | Texas | 48057 | 3043 | 26 |
1650334 | 1650334 | 2021-08-24 | Callahan | Texas | 48059 | 1364 | 44 |
1650335 | 1650335 | 2021-08-24 | Cameron | Texas | 48061 | 57404 | 1750 |
1650336 | 1650336 | 2021-08-24 | Camp | Texas | 48063 | 1609 | 47 |
1650337 | 1650337 | 2021-08-24 | Carson | Texas | 48065 | 665 | 14 |
1650338 | 1650338 | 2021-08-24 | Cass | Texas | 48067 | 3028 | 95 |
1650339 | 1650339 | 2021-08-24 | Castro | Texas | 48069 | 1131 | 32 |
1650340 | 1650340 | 2021-08-24 | Chambers | Texas | 48071 | 6814 | 79 |
1650341 | 1650341 | 2021-08-24 | Cherokee | Texas | 48073 | 5140 | 151 |
1650342 | 1650342 | 2021-08-24 | Childress | Texas | 48075 | 1387 | 17 |
1650343 | 1650343 | 2021-08-24 | Clay | Texas | 48077 | 1138 | 18 |
1650344 | 1650344 | 2021-08-24 | Cochran | Texas | 48079 | 360 | 15 |
1650345 | 1650345 | 2021-08-24 | Coke | Texas | 48081 | 536 | 13 |
1650346 | 1650346 | 2021-08-24 | Coleman | Texas | 48083 | 883 | 36 |
1650347 | 1650347 | 2021-08-24 | Collin | Texas | 48085 | 106039 | 887 |
1650348 | 1650348 | 2021-08-24 | Collingsworth | Texas | 48087 | 347 | 9 |
1650349 | 1650349 | 2021-08-24 | Colorado | Texas | 48089 | 2100 | 34 |
1650350 | 1650350 | 2021-08-24 | Comal | Texas | 48091 | 15034 | 360 |
1650351 | 1650351 | 2021-08-24 | Comanche | Texas | 48093 | 1733 | 54 |
1650352 | 1650352 | 2021-08-24 | Concho | Texas | 48095 | 624 | 9 |
1650353 | 1650353 | 2021-08-24 | Cooke | Texas | 48097 | 4239 | 74 |
1650354 | 1650354 | 2021-08-24 | Coryell | Texas | 48099 | 8490 | 96 |
1650355 | 1650355 | 2021-08-24 | Cottle | Texas | 48101 | 200 | 7 |
1650356 | 1650356 | 2021-08-24 | Crane | Texas | 48103 | 650 | 14 |
1650357 | 1650357 | 2021-08-24 | Crockett | Texas | 48105 | 664 | 15 |
1650358 | 1650358 | 2021-08-24 | Crosby | Texas | 48107 | 835 | 29 |
1650359 | 1650359 | 2021-08-24 | Culberson | Texas | 48109 | 370 | 11 |
1650360 | 1650360 | 2021-08-24 | Dallam | Texas | 48111 | 1027 | 26 |
1650361 | 1650361 | 2021-08-24 | Dallas | Texas | 48113 | 340244 | 4308 |
1650362 | 1650362 | 2021-08-24 | Dawson | Texas | 48115 | 1825 | 70 |
1650363 | 1650363 | 2021-08-24 | DeWitt | Texas | 48123 | 2079 | 64 |
1650364 | 1650364 | 2021-08-24 | Deaf Smith | Texas | 48117 | 3098 | 68 |
1650365 | 1650365 | 2021-08-24 | Delta | Texas | 48119 | 435 | 14 |
1650366 | 1650366 | 2021-08-24 | Denton | Texas | 48121 | 86996 | 814 |
1650367 | 1650367 | 2021-08-24 | Dickens | Texas | 48125 | 210 | 10 |
1650368 | 1650368 | 2021-08-24 | Dimmit | Texas | 48127 | 3444 | 38 |
1650369 | 1650369 | 2021-08-24 | Donley | Texas | 48129 | 449 | 15 |
1650370 | 1650370 | 2021-08-24 | Duval | Texas | 48131 | 1626 | 44 |
1650371 | 1650371 | 2021-08-24 | Eastland | Texas | 48133 | 1583 | 53 |
1650372 | 1650372 | 2021-08-24 | Ector | Texas | 48135 | 20800 | 398 |
1650373 | 1650373 | 2021-08-24 | Edwards | Texas | 48137 | 263 | 6 |
1650374 | 1650374 | 2021-08-24 | El Paso | Texas | 48141 | 141043 | 2771 |
1650375 | 1650375 | 2021-08-24 | Ellis | Texas | 48139 | 26070 | 337 |
1650376 | 1650376 | 2021-08-24 | Erath | Texas | 48143 | 4921 | 72 |
1650377 | 1650377 | 2021-08-24 | Falls | Texas | 48145 | 2262 | 34 |
1650378 | 1650378 | 2021-08-24 | Fannin | Texas | 48147 | 3812 | 114 |
1650379 | 1650379 | 2021-08-24 | Fayette | Texas | 48149 | 3181 | 74 |
1650380 | 1650380 | 2021-08-24 | Fisher | Texas | 48151 | 348 | 14 |
1650381 | 1650381 | 2021-08-24 | Floyd | Texas | 48153 | 1000 | 30 |
1650382 | 1650382 | 2021-08-24 | Foard | Texas | 48155 | 143 | 10 |
1650383 | 1650383 | 2021-08-24 | Fort Bend | Texas | 48157 | 81393 | 780 |
1650384 | 1650384 | 2021-08-24 | Franklin | Texas | 48159 | 968 | 27 |
1650385 | 1650385 | 2021-08-24 | Freestone | Texas | 48161 | 2261 | 55 |
1650386 | 1650386 | 2021-08-24 | Frio | Texas | 48163 | 3372 | 57 |
1650387 | 1650387 | 2021-08-24 | Gaines | Texas | 48165 | 1634 | 46 |
1650388 | 1650388 | 2021-08-24 | Galveston | Texas | 48167 | 52035 | 496 |
1650389 | 1650389 | 2021-08-24 | Garza | Texas | 48169 | 603 | 22 |
1650390 | 1650390 | 2021-08-24 | Gillespie | Texas | 48171 | 2960 | 58 |
1650391 | 1650391 | 2021-08-24 | Glasscock | Texas | 48173 | 126 | 2 |
1650392 | 1650392 | 2021-08-24 | Goliad | Texas | 48175 | 568 | 17 |
1650393 | 1650393 | 2021-08-24 | Gonzales | Texas | 48177 | 3028 | 61 |
1650394 | 1650394 | 2021-08-24 | Gray | Texas | 48179 | 2774 | 60 |
1650395 | 1650395 | 2021-08-24 | Grayson | Texas | 48181 | 12878 | 362 |
1650396 | 1650396 | 2021-08-24 | Gregg | Texas | 48183 | 13993 | 378 |
1650397 | 1650397 | 2021-08-24 | Grimes | Texas | 48185 | 4468 | 74 |
1650398 | 1650398 | 2021-08-24 | Guadalupe | Texas | 48187 | 19199 | 243 |
1650399 | 1650399 | 2021-08-24 | Hale | Texas | 48189 | 6548 | 163 |
1650400 | 1650400 | 2021-08-24 | Hall | Texas | 48191 | 511 | 15 |
1650401 | 1650401 | 2021-08-24 | Hamilton | Texas | 48193 | 963 | 29 |
1650402 | 1650402 | 2021-08-24 | Hansford | Texas | 48195 | 996 | 24 |
1650403 | 1650403 | 2021-08-24 | Hardeman | Texas | 48197 | 413 | 12 |
1650404 | 1650404 | 2021-08-24 | Hardin | Texas | 48199 | 7476 | 129 |
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);