ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
253 rows where date = "2020-10-16" 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 |
---|---|---|---|---|---|---|---|
637505 | 637505 | 2020-10-16 | Anderson | Texas | 48001 | 2906 | 38 |
637506 | 637506 | 2020-10-16 | Andrews | Texas | 48003 | 547 | 10 |
637507 | 637507 | 2020-10-16 | Angelina | Texas | 48005 | 2753 | 87 |
637508 | 637508 | 2020-10-16 | Aransas | Texas | 48007 | 340 | 18 |
637509 | 637509 | 2020-10-16 | Archer | Texas | 48009 | 106 | 1 |
637510 | 637510 | 2020-10-16 | Armstrong | Texas | 48011 | 18 | 1 |
637511 | 637511 | 2020-10-16 | Atascosa | Texas | 48013 | 1252 | 34 |
637512 | 637512 | 2020-10-16 | Austin | Texas | 48015 | 507 | 9 |
637513 | 637513 | 2020-10-16 | Bailey | Texas | 48017 | 256 | 5 |
637514 | 637514 | 2020-10-16 | Bandera | Texas | 48019 | 178 | 8 |
637515 | 637515 | 2020-10-16 | Bastrop | Texas | 48021 | 1939 | 31 |
637516 | 637516 | 2020-10-16 | Baylor | Texas | 48023 | 40 | 2 |
637517 | 637517 | 2020-10-16 | Bee | Texas | 48025 | 1831 | 37 |
637518 | 637518 | 2020-10-16 | Bell | Texas | 48027 | 6015 | 95 |
637519 | 637519 | 2020-10-16 | Bexar | Texas | 48029 | 60454 | 1376 |
637520 | 637520 | 2020-10-16 | Blanco | Texas | 48031 | 153 | 6 |
637521 | 637521 | 2020-10-16 | Borden | Texas | 48033 | 1 | 0 |
637522 | 637522 | 2020-10-16 | Bosque | Texas | 48035 | 381 | 9 |
637523 | 637523 | 2020-10-16 | Bowie | Texas | 48037 | 1654 | 74 |
637524 | 637524 | 2020-10-16 | Brazoria | Texas | 48039 | 11917 | 179 |
637525 | 637525 | 2020-10-16 | Brazos | Texas | 48041 | 8167 | 65 |
637526 | 637526 | 2020-10-16 | Brewster | Texas | 48043 | 245 | 5 |
637527 | 637527 | 2020-10-16 | Briscoe | Texas | 48045 | 17 | 1 |
637528 | 637528 | 2020-10-16 | Brooks | Texas | 48047 | 345 | 23 |
637529 | 637529 | 2020-10-16 | Brown | Texas | 48049 | 932 | 33 |
637530 | 637530 | 2020-10-16 | Burleson | Texas | 48051 | 410 | 6 |
637531 | 637531 | 2020-10-16 | Burnet | Texas | 48053 | 852 | 12 |
637532 | 637532 | 2020-10-16 | Caldwell | Texas | 48055 | 1681 | 37 |
637533 | 637533 | 2020-10-16 | Calhoun | Texas | 48057 | 877 | 9 |
637534 | 637534 | 2020-10-16 | Callahan | Texas | 48059 | 107 | 4 |
637535 | 637535 | 2020-10-16 | Cameron | Texas | 48061 | 23662 | 1063 |
637536 | 637536 | 2020-10-16 | Camp | Texas | 48063 | 381 | 13 |
637537 | 637537 | 2020-10-16 | Carson | Texas | 48065 | 47 | 0 |
637538 | 637538 | 2020-10-16 | Cass | Texas | 48067 | 454 | 20 |
637539 | 637539 | 2020-10-16 | Castro | Texas | 48069 | 278 | 6 |
637540 | 637540 | 2020-10-16 | Chambers | Texas | 48071 | 1497 | 19 |
637541 | 637541 | 2020-10-16 | Cherokee | Texas | 48073 | 1606 | 31 |
637542 | 637542 | 2020-10-16 | Childress | Texas | 48075 | 90 | 0 |
637543 | 637543 | 2020-10-16 | Clay | Texas | 48077 | 91 | 2 |
637544 | 637544 | 2020-10-16 | Cochran | Texas | 48079 | 79 | 1 |
637545 | 637545 | 2020-10-16 | Coke | Texas | 48081 | 80 | 4 |
637546 | 637546 | 2020-10-16 | Coleman | Texas | 48083 | 82 | 4 |
637547 | 637547 | 2020-10-16 | Collin | Texas | 48085 | 16751 | 169 |
637548 | 637548 | 2020-10-16 | Collingsworth | Texas | 48087 | 19 | 0 |
637549 | 637549 | 2020-10-16 | Colorado | Texas | 48089 | 494 | 4 |
637550 | 637550 | 2020-10-16 | Comal | Texas | 48091 | 3642 | 120 |
637551 | 637551 | 2020-10-16 | Comanche | Texas | 48093 | 336 | 5 |
637552 | 637552 | 2020-10-16 | Concho | Texas | 48095 | 139 | 2 |
637553 | 637553 | 2020-10-16 | Cooke | Texas | 48097 | 504 | 7 |
637554 | 637554 | 2020-10-16 | Coryell | Texas | 48099 | 1928 | 13 |
637555 | 637555 | 2020-10-16 | Cottle | Texas | 48101 | 33 | 3 |
637556 | 637556 | 2020-10-16 | Crane | Texas | 48103 | 73 | 2 |
637557 | 637557 | 2020-10-16 | Crockett | Texas | 48105 | 166 | 7 |
637558 | 637558 | 2020-10-16 | Crosby | Texas | 48107 | 103 | 5 |
637559 | 637559 | 2020-10-16 | Culberson | Texas | 48109 | 81 | 2 |
637560 | 637560 | 2020-10-16 | Dallam | Texas | 48111 | 327 | 10 |
637561 | 637561 | 2020-10-16 | Dallas | Texas | 48113 | 93328 | 1187 |
637562 | 637562 | 2020-10-16 | Dawson | Texas | 48115 | 697 | 15 |
637563 | 637563 | 2020-10-16 | DeWitt | Texas | 48123 | 1060 | 42 |
637564 | 637564 | 2020-10-16 | Deaf Smith | Texas | 48117 | 1217 | 25 |
637565 | 637565 | 2020-10-16 | Delta | Texas | 48119 | 32 | 0 |
637566 | 637566 | 2020-10-16 | Denton | Texas | 48121 | 15009 | 162 |
637567 | 637567 | 2020-10-16 | Dickens | Texas | 48125 | 51 | 2 |
637568 | 637568 | 2020-10-16 | Dimmit | Texas | 48127 | 272 | 7 |
637569 | 637569 | 2020-10-16 | Donley | Texas | 48129 | 81 | 1 |
637570 | 637570 | 2020-10-16 | Duval | Texas | 48131 | 469 | 20 |
637571 | 637571 | 2020-10-16 | Eastland | Texas | 48133 | 218 | 6 |
637572 | 637572 | 2020-10-16 | Ector | Texas | 48135 | 5613 | 108 |
637573 | 637573 | 2020-10-16 | Edwards | Texas | 48137 | 66 | 2 |
637574 | 637574 | 2020-10-16 | El Paso | Texas | 48141 | 31478 | 571 |
637575 | 637575 | 2020-10-16 | Ellis | Texas | 48139 | 4700 | 74 |
637576 | 637576 | 2020-10-16 | Erath | Texas | 48143 | 956 | 13 |
637577 | 637577 | 2020-10-16 | Falls | Texas | 48145 | 633 | 5 |
637578 | 637578 | 2020-10-16 | Fannin | Texas | 48147 | 733 | 16 |
637579 | 637579 | 2020-10-16 | Fayette | Texas | 48149 | 509 | 22 |
637580 | 637580 | 2020-10-16 | Fisher | Texas | 48151 | 85 | 3 |
637581 | 637581 | 2020-10-16 | Floyd | Texas | 48153 | 119 | 9 |
637582 | 637582 | 2020-10-16 | Foard | Texas | 48155 | 20 | 0 |
637583 | 637583 | 2020-10-16 | Fort Bend | Texas | 48157 | 17507 | 303 |
637584 | 637584 | 2020-10-16 | Franklin | Texas | 48159 | 170 | 6 |
637585 | 637585 | 2020-10-16 | Freestone | Texas | 48161 | 437 | 4 |
637586 | 637586 | 2020-10-16 | Frio | Texas | 48163 | 1011 | 9 |
637587 | 637587 | 2020-10-16 | Gaines | Texas | 48165 | 454 | 10 |
637588 | 637588 | 2020-10-16 | Galveston | Texas | 48167 | 12046 | 166 |
637589 | 637589 | 2020-10-16 | Garza | Texas | 48169 | 115 | 4 |
637590 | 637590 | 2020-10-16 | Gillespie | Texas | 48171 | 344 | 10 |
637591 | 637591 | 2020-10-16 | Glasscock | Texas | 48173 | 11 | 0 |
637592 | 637592 | 2020-10-16 | Goliad | Texas | 48175 | 157 | 6 |
637593 | 637593 | 2020-10-16 | Gonzales | Texas | 48177 | 1089 | 18 |
637594 | 637594 | 2020-10-16 | Gray | Texas | 48179 | 385 | 9 |
637595 | 637595 | 2020-10-16 | Grayson | Texas | 48181 | 2263 | 60 |
637596 | 637596 | 2020-10-16 | Gregg | Texas | 48183 | 3114 | 81 |
637597 | 637597 | 2020-10-16 | Grimes | Texas | 48185 | 1143 | 34 |
637598 | 637598 | 2020-10-16 | Guadalupe | Texas | 48187 | 3782 | 79 |
637599 | 637599 | 2020-10-16 | Hale | Texas | 48189 | 2259 | 60 |
637600 | 637600 | 2020-10-16 | Hall | Texas | 48191 | 36 | 1 |
637601 | 637601 | 2020-10-16 | Hamilton | Texas | 48193 | 179 | 4 |
637602 | 637602 | 2020-10-16 | Hansford | Texas | 48195 | 186 | 6 |
637603 | 637603 | 2020-10-16 | Hardeman | Texas | 48197 | 59 | 1 |
637604 | 637604 | 2020-10-16 | Hardin | Texas | 48199 | 1388 | 33 |
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);