ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
253 rows where date = "2020-11-05" 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 |
---|---|---|---|---|---|---|---|
702388 | 702388 | 2020-11-05 | Anderson | Texas | 48001 | 3011 | 41 |
702389 | 702389 | 2020-11-05 | Andrews | Texas | 48003 | 726 | 11 |
702390 | 702390 | 2020-11-05 | Angelina | Texas | 48005 | 3008 | 93 |
702391 | 702391 | 2020-11-05 | Aransas | Texas | 48007 | 360 | 18 |
702392 | 702392 | 2020-11-05 | Archer | Texas | 48009 | 171 | 1 |
702393 | 702393 | 2020-11-05 | Armstrong | Texas | 48011 | 29 | 1 |
702394 | 702394 | 2020-11-05 | Atascosa | Texas | 48013 | 1294 | 37 |
702395 | 702395 | 2020-11-05 | Austin | Texas | 48015 | 523 | 10 |
702396 | 702396 | 2020-11-05 | Bailey | Texas | 48017 | 334 | 5 |
702397 | 702397 | 2020-11-05 | Bandera | Texas | 48019 | 196 | 9 |
702398 | 702398 | 2020-11-05 | Bastrop | Texas | 48021 | 2059 | 33 |
702399 | 702399 | 2020-11-05 | Baylor | Texas | 48023 | 46 | 4 |
702400 | 702400 | 2020-11-05 | Bee | Texas | 48025 | 1874 | 39 |
702401 | 702401 | 2020-11-05 | Bell | Texas | 48027 | 6770 | 103 |
702402 | 702402 | 2020-11-05 | Bexar | Texas | 48029 | 66921 | 1424 |
702403 | 702403 | 2020-11-05 | Blanco | Texas | 48031 | 166 | 6 |
702404 | 702404 | 2020-11-05 | Borden | Texas | 48033 | 3 | 0 |
702405 | 702405 | 2020-11-05 | Bosque | Texas | 48035 | 425 | 12 |
702406 | 702406 | 2020-11-05 | Bowie | Texas | 48037 | 2153 | 87 |
702407 | 702407 | 2020-11-05 | Brazoria | Texas | 48039 | 12731 | 187 |
702408 | 702408 | 2020-11-05 | Brazos | Texas | 48041 | 9127 | 78 |
702409 | 702409 | 2020-11-05 | Brewster | Texas | 48043 | 271 | 5 |
702410 | 702410 | 2020-11-05 | Briscoe | Texas | 48045 | 25 | 1 |
702411 | 702411 | 2020-11-05 | Brooks | Texas | 48047 | 366 | 25 |
702412 | 702412 | 2020-11-05 | Brown | Texas | 48049 | 1160 | 35 |
702413 | 702413 | 2020-11-05 | Burleson | Texas | 48051 | 494 | 6 |
702414 | 702414 | 2020-11-05 | Burnet | Texas | 48053 | 1120 | 15 |
702415 | 702415 | 2020-11-05 | Caldwell | Texas | 48055 | 1749 | 38 |
702416 | 702416 | 2020-11-05 | Calhoun | Texas | 48057 | 939 | 9 |
702417 | 702417 | 2020-11-05 | Callahan | Texas | 48059 | 147 | 6 |
702418 | 702418 | 2020-11-05 | Cameron | Texas | 48061 | 24478 | 1089 |
702419 | 702419 | 2020-11-05 | Camp | Texas | 48063 | 411 | 13 |
702420 | 702420 | 2020-11-05 | Carson | Texas | 48065 | 62 | 1 |
702421 | 702421 | 2020-11-05 | Cass | Texas | 48067 | 581 | 28 |
702422 | 702422 | 2020-11-05 | Castro | Texas | 48069 | 339 | 7 |
702423 | 702423 | 2020-11-05 | Chambers | Texas | 48071 | 1627 | 20 |
702424 | 702424 | 2020-11-05 | Cherokee | Texas | 48073 | 1668 | 42 |
702425 | 702425 | 2020-11-05 | Childress | Texas | 48075 | 135 | 0 |
702426 | 702426 | 2020-11-05 | Clay | Texas | 48077 | 138 | 3 |
702427 | 702427 | 2020-11-05 | Cochran | Texas | 48079 | 131 | 3 |
702428 | 702428 | 2020-11-05 | Coke | Texas | 48081 | 133 | 7 |
702429 | 702429 | 2020-11-05 | Coleman | Texas | 48083 | 102 | 4 |
702430 | 702430 | 2020-11-05 | Collin | Texas | 48085 | 19480 | 196 |
702431 | 702431 | 2020-11-05 | Collingsworth | Texas | 48087 | 22 | 0 |
702432 | 702432 | 2020-11-05 | Colorado | Texas | 48089 | 510 | 4 |
702433 | 702433 | 2020-11-05 | Comal | Texas | 48091 | 3879 | 121 |
702434 | 702434 | 2020-11-05 | Comanche | Texas | 48093 | 386 | 5 |
702435 | 702435 | 2020-11-05 | Concho | Texas | 48095 | 144 | 2 |
702436 | 702436 | 2020-11-05 | Cooke | Texas | 48097 | 593 | 9 |
702437 | 702437 | 2020-11-05 | Coryell | Texas | 48099 | 2036 | 14 |
702438 | 702438 | 2020-11-05 | Cottle | Texas | 48101 | 42 | 3 |
702439 | 702439 | 2020-11-05 | Crane | Texas | 48103 | 83 | 5 |
702440 | 702440 | 2020-11-05 | Crockett | Texas | 48105 | 167 | 7 |
702441 | 702441 | 2020-11-05 | Crosby | Texas | 48107 | 133 | 9 |
702442 | 702442 | 2020-11-05 | Culberson | Texas | 48109 | 129 | 3 |
702443 | 702443 | 2020-11-05 | Dallam | Texas | 48111 | 412 | 10 |
702444 | 702444 | 2020-11-05 | Dallas | Texas | 48113 | 106494 | 1293 |
702445 | 702445 | 2020-11-05 | Dawson | Texas | 48115 | 958 | 20 |
702446 | 702446 | 2020-11-05 | DeWitt | Texas | 48123 | 1111 | 44 |
702447 | 702447 | 2020-11-05 | Deaf Smith | Texas | 48117 | 1454 | 28 |
702448 | 702448 | 2020-11-05 | Delta | Texas | 48119 | 40 | 0 |
702449 | 702449 | 2020-11-05 | Denton | Texas | 48121 | 17842 | 179 |
702450 | 702450 | 2020-11-05 | Dickens | Texas | 48125 | 58 | 2 |
702451 | 702451 | 2020-11-05 | Dimmit | Texas | 48127 | 297 | 8 |
702452 | 702452 | 2020-11-05 | Donley | Texas | 48129 | 92 | 1 |
702453 | 702453 | 2020-11-05 | Duval | Texas | 48131 | 511 | 21 |
702454 | 702454 | 2020-11-05 | Eastland | Texas | 48133 | 279 | 8 |
702455 | 702455 | 2020-11-05 | Ector | Texas | 48135 | 7261 | 121 |
702456 | 702456 | 2020-11-05 | Edwards | Texas | 48137 | 72 | 2 |
702457 | 702457 | 2020-11-05 | El Paso | Texas | 48141 | 58429 | 676 |
702458 | 702458 | 2020-11-05 | Ellis | Texas | 48139 | 5190 | 85 |
702459 | 702459 | 2020-11-05 | Erath | Texas | 48143 | 1115 | 18 |
702460 | 702460 | 2020-11-05 | Falls | Texas | 48145 | 708 | 6 |
702461 | 702461 | 2020-11-05 | Fannin | Texas | 48147 | 834 | 20 |
702462 | 702462 | 2020-11-05 | Fayette | Texas | 48149 | 547 | 23 |
702463 | 702463 | 2020-11-05 | Fisher | Texas | 48151 | 125 | 4 |
702464 | 702464 | 2020-11-05 | Floyd | Texas | 48153 | 140 | 9 |
702465 | 702465 | 2020-11-05 | Foard | Texas | 48155 | 22 | 1 |
702466 | 702466 | 2020-11-05 | Fort Bend | Texas | 48157 | 18802 | 313 |
702467 | 702467 | 2020-11-05 | Franklin | Texas | 48159 | 229 | 8 |
702468 | 702468 | 2020-11-05 | Freestone | Texas | 48161 | 471 | 5 |
702469 | 702469 | 2020-11-05 | Frio | Texas | 48163 | 1026 | 9 |
702470 | 702470 | 2020-11-05 | Gaines | Texas | 48165 | 620 | 12 |
702471 | 702471 | 2020-11-05 | Galveston | Texas | 48167 | 12979 | 169 |
702472 | 702472 | 2020-11-05 | Garza | Texas | 48169 | 139 | 10 |
702473 | 702473 | 2020-11-05 | Gillespie | Texas | 48171 | 369 | 10 |
702474 | 702474 | 2020-11-05 | Glasscock | Texas | 48173 | 14 | 0 |
702475 | 702475 | 2020-11-05 | Goliad | Texas | 48175 | 165 | 6 |
702476 | 702476 | 2020-11-05 | Gonzales | Texas | 48177 | 1144 | 20 |
702477 | 702477 | 2020-11-05 | Gray | Texas | 48179 | 560 | 10 |
702478 | 702478 | 2020-11-05 | Grayson | Texas | 48181 | 2919 | 78 |
702479 | 702479 | 2020-11-05 | Gregg | Texas | 48183 | 3715 | 88 |
702480 | 702480 | 2020-11-05 | Grimes | Texas | 48185 | 1230 | 36 |
702481 | 702481 | 2020-11-05 | Guadalupe | Texas | 48187 | 3917 | 83 |
702482 | 702482 | 2020-11-05 | Hale | Texas | 48189 | 2907 | 70 |
702483 | 702483 | 2020-11-05 | Hall | Texas | 48191 | 47 | 1 |
702484 | 702484 | 2020-11-05 | Hamilton | Texas | 48193 | 215 | 7 |
702485 | 702485 | 2020-11-05 | Hansford | Texas | 48195 | 207 | 8 |
702486 | 702486 | 2020-11-05 | Hardeman | Texas | 48197 | 65 | 3 |
702487 | 702487 | 2020-11-05 | Hardin | Texas | 48199 | 1476 | 35 |
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);