ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
251 rows where "date" is on date 2020-08-31 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 |
---|---|---|---|---|---|---|---|
488520 | 488520 | 2020-08-31 | Anderson | Texas | 48001 | 2502 | 18 |
488521 | 488521 | 2020-08-31 | Andrews | Texas | 48003 | 367 | 8 |
488522 | 488522 | 2020-08-31 | Angelina | Texas | 48005 | 2250 | 67 |
488523 | 488523 | 2020-08-31 | Aransas | Texas | 48007 | 212 | 18 |
488524 | 488524 | 2020-08-31 | Archer | Texas | 48009 | 49 | 0 |
488525 | 488525 | 2020-08-31 | Armstrong | Texas | 48011 | 11 | 0 |
488526 | 488526 | 2020-08-31 | Atascosa | Texas | 48013 | 568 | 27 |
488527 | 488527 | 2020-08-31 | Austin | Texas | 48015 | 417 | 6 |
488528 | 488528 | 2020-08-31 | Bailey | Texas | 48017 | 202 | 4 |
488529 | 488529 | 2020-08-31 | Bandera | Texas | 48019 | 109 | 4 |
488530 | 488530 | 2020-08-31 | Bastrop | Texas | 48021 | 1582 | 27 |
488531 | 488531 | 2020-08-31 | Baylor | Texas | 48023 | 16 | 0 |
488532 | 488532 | 2020-08-31 | Bee | Texas | 48025 | 1605 | 22 |
488533 | 488533 | 2020-08-31 | Bell | Texas | 48027 | 4768 | 64 |
488534 | 488534 | 2020-08-31 | Bexar | Texas | 48029 | 46453 | 1086 |
488535 | 488535 | 2020-08-31 | Blanco | Texas | 48031 | 125 | 5 |
488536 | 488536 | 2020-08-31 | Bosque | Texas | 48035 | 216 | 5 |
488537 | 488537 | 2020-08-31 | Bowie | Texas | 48037 | 970 | 69 |
488538 | 488538 | 2020-08-31 | Brazoria | Texas | 48039 | 9389 | 138 |
488539 | 488539 | 2020-08-31 | Brazos | Texas | 48041 | 5137 | 55 |
488540 | 488540 | 2020-08-31 | Brewster | Texas | 48043 | 191 | 2 |
488541 | 488541 | 2020-08-31 | Briscoe | Texas | 48045 | 12 | 1 |
488542 | 488542 | 2020-08-31 | Brooks | Texas | 48047 | 215 | 16 |
488543 | 488543 | 2020-08-31 | Brown | Texas | 48049 | 634 | 26 |
488544 | 488544 | 2020-08-31 | Burleson | Texas | 48051 | 288 | 6 |
488545 | 488545 | 2020-08-31 | Burnet | Texas | 48053 | 666 | 12 |
488546 | 488546 | 2020-08-31 | Caldwell | Texas | 48055 | 1230 | 32 |
488547 | 488547 | 2020-08-31 | Calhoun | Texas | 48057 | 603 | 7 |
488548 | 488548 | 2020-08-31 | Callahan | Texas | 48059 | 88 | 3 |
488549 | 488549 | 2020-08-31 | Cameron | Texas | 48061 | 21048 | 757 |
488550 | 488550 | 2020-08-31 | Camp | Texas | 48063 | 296 | 8 |
488551 | 488551 | 2020-08-31 | Carson | Texas | 48065 | 17 | 0 |
488552 | 488552 | 2020-08-31 | Cass | Texas | 48067 | 257 | 11 |
488553 | 488553 | 2020-08-31 | Castro | Texas | 48069 | 227 | 4 |
488554 | 488554 | 2020-08-31 | Chambers | Texas | 48071 | 1123 | 11 |
488555 | 488555 | 2020-08-31 | Cherokee | Texas | 48073 | 1408 | 16 |
488556 | 488556 | 2020-08-31 | Childress | Texas | 48075 | 57 | 0 |
488557 | 488557 | 2020-08-31 | Clay | Texas | 48077 | 63 | 1 |
488558 | 488558 | 2020-08-31 | Cochran | Texas | 48079 | 37 | 1 |
488559 | 488559 | 2020-08-31 | Coke | Texas | 48081 | 49 | 3 |
488560 | 488560 | 2020-08-31 | Coleman | Texas | 48083 | 52 | 2 |
488561 | 488561 | 2020-08-31 | Collin | Texas | 48085 | 10989 | 112 |
488562 | 488562 | 2020-08-31 | Collingsworth | Texas | 48087 | 16 | 0 |
488563 | 488563 | 2020-08-31 | Colorado | Texas | 48089 | 444 | 3 |
488564 | 488564 | 2020-08-31 | Comal | Texas | 48091 | 2969 | 95 |
488565 | 488565 | 2020-08-31 | Comanche | Texas | 48093 | 214 | 3 |
488566 | 488566 | 2020-08-31 | Concho | Texas | 48095 | 55 | 1 |
488567 | 488567 | 2020-08-31 | Cooke | Texas | 48097 | 318 | 4 |
488568 | 488568 | 2020-08-31 | Coryell | Texas | 48099 | 1151 | 10 |
488569 | 488569 | 2020-08-31 | Cottle | Texas | 48101 | 18 | 2 |
488570 | 488570 | 2020-08-31 | Crane | Texas | 48103 | 70 | 2 |
488571 | 488571 | 2020-08-31 | Crockett | Texas | 48105 | 162 | 6 |
488572 | 488572 | 2020-08-31 | Crosby | Texas | 48107 | 81 | 1 |
488573 | 488573 | 2020-08-31 | Culberson | Texas | 48109 | 23 | 2 |
488574 | 488574 | 2020-08-31 | Dallam | Texas | 48111 | 208 | 7 |
488575 | 488575 | 2020-08-31 | Dallas | Texas | 48113 | 74576 | 947 |
488576 | 488576 | 2020-08-31 | Dawson | Texas | 48115 | 207 | 8 |
488577 | 488577 | 2020-08-31 | DeWitt | Texas | 48123 | 844 | 25 |
488578 | 488578 | 2020-08-31 | Deaf Smith | Texas | 48117 | 948 | 20 |
488579 | 488579 | 2020-08-31 | Delta | Texas | 48119 | 17 | 0 |
488580 | 488580 | 2020-08-31 | Denton | Texas | 48121 | 10125 | 131 |
488581 | 488581 | 2020-08-31 | Dickens | Texas | 48125 | 27 | 1 |
488582 | 488582 | 2020-08-31 | Dimmit | Texas | 48127 | 180 | 6 |
488583 | 488583 | 2020-08-31 | Donley | Texas | 48129 | 55 | 1 |
488584 | 488584 | 2020-08-31 | Duval | Texas | 48131 | 259 | 10 |
488585 | 488585 | 2020-08-31 | Eastland | Texas | 48133 | 130 | 2 |
488586 | 488586 | 2020-08-31 | Ector | Texas | 48135 | 4241 | 70 |
488587 | 488587 | 2020-08-31 | Edwards | Texas | 48137 | 34 | 1 |
488588 | 488588 | 2020-08-31 | El Paso | Texas | 48141 | 20460 | 428 |
488589 | 488589 | 2020-08-31 | Ellis | Texas | 48139 | 3758 | 56 |
488590 | 488590 | 2020-08-31 | Erath | Texas | 48143 | 667 | 9 |
488591 | 488591 | 2020-08-31 | Falls | Texas | 48145 | 166 | 3 |
488592 | 488592 | 2020-08-31 | Fannin | Texas | 48147 | 585 | 12 |
488593 | 488593 | 2020-08-31 | Fayette | Texas | 48149 | 370 | 16 |
488594 | 488594 | 2020-08-31 | Fisher | Texas | 48151 | 58 | 1 |
488595 | 488595 | 2020-08-31 | Floyd | Texas | 48153 | 100 | 7 |
488596 | 488596 | 2020-08-31 | Foard | Texas | 48155 | 3 | 0 |
488597 | 488597 | 2020-08-31 | Fort Bend | Texas | 48157 | 14957 | 237 |
488598 | 488598 | 2020-08-31 | Franklin | Texas | 48159 | 111 | 4 |
488599 | 488599 | 2020-08-31 | Freestone | Texas | 48161 | 384 | 1 |
488600 | 488600 | 2020-08-31 | Frio | Texas | 48163 | 633 | 7 |
488601 | 488601 | 2020-08-31 | Gaines | Texas | 48165 | 247 | 7 |
488602 | 488602 | 2020-08-31 | Galveston | Texas | 48167 | 10575 | 140 |
488603 | 488603 | 2020-08-31 | Garza | Texas | 48169 | 102 | 3 |
488604 | 488604 | 2020-08-31 | Gillespie | Texas | 48171 | 198 | 6 |
488605 | 488605 | 2020-08-31 | Glasscock | Texas | 48173 | 6 | 0 |
488606 | 488606 | 2020-08-31 | Goliad | Texas | 48175 | 121 | 6 |
488607 | 488607 | 2020-08-31 | Gonzales | Texas | 48177 | 813 | 13 |
488608 | 488608 | 2020-08-31 | Gray | Texas | 48179 | 242 | 4 |
488609 | 488609 | 2020-08-31 | Grayson | Texas | 48181 | 1483 | 25 |
488610 | 488610 | 2020-08-31 | Gregg | Texas | 48183 | 2001 | 48 |
488611 | 488611 | 2020-08-31 | Grimes | Texas | 48185 | 983 | 30 |
488612 | 488612 | 2020-08-31 | Guadalupe | Texas | 48187 | 1899 | 72 |
488613 | 488613 | 2020-08-31 | Hale | Texas | 48189 | 1618 | 45 |
488614 | 488614 | 2020-08-31 | Hall | Texas | 48191 | 16 | 1 |
488615 | 488615 | 2020-08-31 | Hamilton | Texas | 48193 | 101 | 3 |
488616 | 488616 | 2020-08-31 | Hansford | Texas | 48195 | 102 | 3 |
488617 | 488617 | 2020-08-31 | Hardeman | Texas | 48197 | 22 | 0 |
488618 | 488618 | 2020-08-31 | Hardin | Texas | 48199 | 1254 | 19 |
488619 | 488619 | 2020-08-31 | Harris | Texas | 48201 | 106595 | 2192 |
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);