ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
254 rows where "date" is on date 2021-08-12 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1611324 | 1611324 | 2021-08-12 | Anderson | Texas | 48001 | 6318 | 135 |
1611325 | 1611325 | 2021-08-12 | Andrews | Texas | 48003 | 1966 | 47 |
1611326 | 1611326 | 2021-08-12 | Angelina | Texas | 48005 | 9530 | 292 |
1611327 | 1611327 | 2021-08-12 | Aransas | Texas | 48007 | 1648 | 46 |
1611328 | 1611328 | 2021-08-12 | Archer | Texas | 48009 | 850 | 12 |
1611329 | 1611329 | 2021-08-12 | Armstrong | Texas | 48011 | 228 | 7 |
1611330 | 1611330 | 2021-08-12 | Atascosa | Texas | 48013 | 6503 | 154 |
1611331 | 1611331 | 2021-08-12 | Austin | Texas | 48015 | 2464 | 39 |
1611332 | 1611332 | 2021-08-12 | Bailey | Texas | 48017 | 881 | 19 |
1611333 | 1611333 | 2021-08-12 | Bandera | Texas | 48019 | 1635 | 33 |
1611334 | 1611334 | 2021-08-12 | Bastrop | Texas | 48021 | 11054 | 110 |
1611335 | 1611335 | 2021-08-12 | Baylor | Texas | 48023 | 310 | 13 |
1611336 | 1611336 | 2021-08-12 | Bee | Texas | 48025 | 3984 | 76 |
1611337 | 1611337 | 2021-08-12 | Bell | Texas | 48027 | 28830 | 475 |
1611338 | 1611338 | 2021-08-12 | Bexar | Texas | 48029 | 257806 | 3739 |
1611339 | 1611339 | 2021-08-12 | Blanco | Texas | 48031 | 860 | 23 |
1611340 | 1611340 | 2021-08-12 | Borden | Texas | 48033 | 33 | 2 |
1611341 | 1611341 | 2021-08-12 | Bosque | Texas | 48035 | 1890 | 39 |
1611342 | 1611342 | 2021-08-12 | Bowie | Texas | 48037 | 8665 | 231 |
1611343 | 1611343 | 2021-08-12 | Brazoria | Texas | 48039 | 43780 | 561 |
1611344 | 1611344 | 2021-08-12 | Brazos | Texas | 48041 | 29565 | 272 |
1611345 | 1611345 | 2021-08-12 | Brewster | Texas | 48043 | 963 | 17 |
1611346 | 1611346 | 2021-08-12 | Briscoe | Texas | 48045 | 188 | 7 |
1611347 | 1611347 | 2021-08-12 | Brooks | Texas | 48047 | 953 | 37 |
1611348 | 1611348 | 2021-08-12 | Brown | Texas | 48049 | 4842 | 143 |
1611349 | 1611349 | 2021-08-12 | Burleson | Texas | 48051 | 2642 | 48 |
1611350 | 1611350 | 2021-08-12 | Burnet | Texas | 48053 | 5631 | 76 |
1611351 | 1611351 | 2021-08-12 | Caldwell | Texas | 48055 | 6430 | 105 |
1611352 | 1611352 | 2021-08-12 | Calhoun | Texas | 48057 | 2732 | 26 |
1611353 | 1611353 | 2021-08-12 | Callahan | Texas | 48059 | 1308 | 41 |
1611354 | 1611354 | 2021-08-12 | Cameron | Texas | 48061 | 54365 | 1728 |
1611355 | 1611355 | 2021-08-12 | Camp | Texas | 48063 | 1493 | 45 |
1611356 | 1611356 | 2021-08-12 | Carson | Texas | 48065 | 641 | 14 |
1611357 | 1611357 | 2021-08-12 | Cass | Texas | 48067 | 2665 | 87 |
1611358 | 1611358 | 2021-08-12 | Castro | Texas | 48069 | 1108 | 32 |
1611359 | 1611359 | 2021-08-12 | Chambers | Texas | 48071 | 6224 | 62 |
1611360 | 1611360 | 2021-08-12 | Cherokee | Texas | 48073 | 4737 | 149 |
1611361 | 1611361 | 2021-08-12 | Childress | Texas | 48075 | 1386 | 17 |
1611362 | 1611362 | 2021-08-12 | Clay | Texas | 48077 | 1102 | 17 |
1611363 | 1611363 | 2021-08-12 | Cochran | Texas | 48079 | 346 | 15 |
1611364 | 1611364 | 2021-08-12 | Coke | Texas | 48081 | 499 | 13 |
1611365 | 1611365 | 2021-08-12 | Coleman | Texas | 48083 | 836 | 36 |
1611366 | 1611366 | 2021-08-12 | Collin | Texas | 48085 | 100737 | 870 |
1611367 | 1611367 | 2021-08-12 | Collingsworth | Texas | 48087 | 340 | 9 |
1611368 | 1611368 | 2021-08-12 | Colorado | Texas | 48089 | 1973 | 33 |
1611369 | 1611369 | 2021-08-12 | Comal | Texas | 48091 | 13779 | 348 |
1611370 | 1611370 | 2021-08-12 | Comanche | Texas | 48093 | 1672 | 52 |
1611371 | 1611371 | 2021-08-12 | Concho | Texas | 48095 | 576 | 9 |
1611372 | 1611372 | 2021-08-12 | Cooke | Texas | 48097 | 4084 | 72 |
1611373 | 1611373 | 2021-08-12 | Coryell | Texas | 48099 | 8110 | 94 |
1611374 | 1611374 | 2021-08-12 | Cottle | Texas | 48101 | 195 | 7 |
1611375 | 1611375 | 2021-08-12 | Crane | Texas | 48103 | 606 | 14 |
1611376 | 1611376 | 2021-08-12 | Crockett | Texas | 48105 | 638 | 15 |
1611377 | 1611377 | 2021-08-12 | Crosby | Texas | 48107 | 808 | 29 |
1611378 | 1611378 | 2021-08-12 | Culberson | Texas | 48109 | 369 | 11 |
1611379 | 1611379 | 2021-08-12 | Dallam | Texas | 48111 | 997 | 26 |
1611380 | 1611380 | 2021-08-12 | Dallas | Texas | 48113 | 328289 | 4222 |
1611381 | 1611381 | 2021-08-12 | Dawson | Texas | 48115 | 1780 | 70 |
1611382 | 1611382 | 2021-08-12 | DeWitt | Texas | 48123 | 2078 | 63 |
1611383 | 1611383 | 2021-08-12 | Deaf Smith | Texas | 48117 | 3042 | 68 |
1611384 | 1611384 | 2021-08-12 | Delta | Texas | 48119 | 394 | 14 |
1611385 | 1611385 | 2021-08-12 | Denton | Texas | 48121 | 83129 | 799 |
1611386 | 1611386 | 2021-08-12 | Dickens | Texas | 48125 | 205 | 10 |
1611387 | 1611387 | 2021-08-12 | Dimmit | Texas | 48127 | 3219 | 39 |
1611388 | 1611388 | 2021-08-12 | Donley | Texas | 48129 | 438 | 15 |
1611389 | 1611389 | 2021-08-12 | Duval | Texas | 48131 | 1468 | 42 |
1611390 | 1611390 | 2021-08-12 | Eastland | Texas | 48133 | 1469 | 50 |
1611391 | 1611391 | 2021-08-12 | Ector | Texas | 48135 | 19478 | 391 |
1611392 | 1611392 | 2021-08-12 | Edwards | Texas | 48137 | 255 | 6 |
1611393 | 1611393 | 2021-08-12 | El Paso | Texas | 48141 | 139422 | 2765 |
1611394 | 1611394 | 2021-08-12 | Ellis | Texas | 48139 | 24820 | 329 |
1611395 | 1611395 | 2021-08-12 | Erath | Texas | 48143 | 4679 | 71 |
1611396 | 1611396 | 2021-08-12 | Falls | Texas | 48145 | 2181 | 33 |
1611397 | 1611397 | 2021-08-12 | Fannin | Texas | 48147 | 3693 | 112 |
1611398 | 1611398 | 2021-08-12 | Fayette | Texas | 48149 | 3055 | 71 |
1611399 | 1611399 | 2021-08-12 | Fisher | Texas | 48151 | 336 | 14 |
1611400 | 1611400 | 2021-08-12 | Floyd | Texas | 48153 | 969 | 30 |
1611401 | 1611401 | 2021-08-12 | Foard | Texas | 48155 | 137 | 10 |
1611402 | 1611402 | 2021-08-12 | Fort Bend | Texas | 48157 | 77422 | 760 |
1611403 | 1611403 | 2021-08-12 | Franklin | Texas | 48159 | 897 | 26 |
1611404 | 1611404 | 2021-08-12 | Freestone | Texas | 48161 | 2154 | 54 |
1611405 | 1611405 | 2021-08-12 | Frio | Texas | 48163 | 3207 | 55 |
1611406 | 1611406 | 2021-08-12 | Gaines | Texas | 48165 | 1537 | 46 |
1611407 | 1611407 | 2021-08-12 | Galveston | Texas | 48167 | 48185 | 473 |
1611408 | 1611408 | 2021-08-12 | Garza | Texas | 48169 | 575 | 22 |
1611409 | 1611409 | 2021-08-12 | Gillespie | Texas | 48171 | 2826 | 54 |
1611410 | 1611410 | 2021-08-12 | Glasscock | Texas | 48173 | 106 | 2 |
1611411 | 1611411 | 2021-08-12 | Goliad | Texas | 48175 | 533 | 16 |
1611412 | 1611412 | 2021-08-12 | Gonzales | Texas | 48177 | 2919 | 59 |
1611413 | 1611413 | 2021-08-12 | Gray | Texas | 48179 | 2629 | 58 |
1611414 | 1611414 | 2021-08-12 | Grayson | Texas | 48181 | 12312 | 352 |
1611415 | 1611415 | 2021-08-12 | Gregg | Texas | 48183 | 12644 | 368 |
1611416 | 1611416 | 2021-08-12 | Grimes | Texas | 48185 | 4250 | 74 |
1611417 | 1611417 | 2021-08-12 | Guadalupe | Texas | 48187 | 17847 | 231 |
1611418 | 1611418 | 2021-08-12 | Hale | Texas | 48189 | 6437 | 159 |
1611419 | 1611419 | 2021-08-12 | Hall | Texas | 48191 | 506 | 14 |
1611420 | 1611420 | 2021-08-12 | Hamilton | Texas | 48193 | 907 | 29 |
1611421 | 1611421 | 2021-08-12 | Hansford | Texas | 48195 | 960 | 24 |
1611422 | 1611422 | 2021-08-12 | Hardeman | Texas | 48197 | 402 | 12 |
1611423 | 1611423 | 2021-08-12 | Hardin | Texas | 48199 | 6959 | 121 |
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);