ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
253 rows where "date" is on date 2020-10-29 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
679684 | 679684 | 2020-10-29 | Anderson | Texas | 48001 | 2970 | 39 |
679685 | 679685 | 2020-10-29 | Andrews | Texas | 48003 | 655 | 10 |
679686 | 679686 | 2020-10-29 | Angelina | Texas | 48005 | 2922 | 92 |
679687 | 679687 | 2020-10-29 | Aransas | Texas | 48007 | 350 | 18 |
679688 | 679688 | 2020-10-29 | Archer | Texas | 48009 | 160 | 1 |
679689 | 679689 | 2020-10-29 | Armstrong | Texas | 48011 | 27 | 1 |
679690 | 679690 | 2020-10-29 | Atascosa | Texas | 48013 | 1292 | 35 |
679691 | 679691 | 2020-10-29 | Austin | Texas | 48015 | 514 | 10 |
679692 | 679692 | 2020-10-29 | Bailey | Texas | 48017 | 296 | 5 |
679693 | 679693 | 2020-10-29 | Bandera | Texas | 48019 | 185 | 8 |
679694 | 679694 | 2020-10-29 | Bastrop | Texas | 48021 | 2011 | 31 |
679695 | 679695 | 2020-10-29 | Baylor | Texas | 48023 | 43 | 3 |
679696 | 679696 | 2020-10-29 | Bee | Texas | 48025 | 1865 | 39 |
679697 | 679697 | 2020-10-29 | Bell | Texas | 48027 | 6496 | 100 |
679698 | 679698 | 2020-10-29 | Bexar | Texas | 48029 | 65435 | 1409 |
679699 | 679699 | 2020-10-29 | Blanco | Texas | 48031 | 162 | 6 |
679700 | 679700 | 2020-10-29 | Borden | Texas | 48033 | 2 | 0 |
679701 | 679701 | 2020-10-29 | Bosque | Texas | 48035 | 413 | 11 |
679702 | 679702 | 2020-10-29 | Bowie | Texas | 48037 | 1963 | 78 |
679703 | 679703 | 2020-10-29 | Brazoria | Texas | 48039 | 12387 | 184 |
679704 | 679704 | 2020-10-29 | Brazos | Texas | 48041 | 8707 | 73 |
679705 | 679705 | 2020-10-29 | Brewster | Texas | 48043 | 249 | 5 |
679706 | 679706 | 2020-10-29 | Briscoe | Texas | 48045 | 22 | 1 |
679707 | 679707 | 2020-10-29 | Brooks | Texas | 48047 | 359 | 23 |
679708 | 679708 | 2020-10-29 | Brown | Texas | 48049 | 1042 | 35 |
679709 | 679709 | 2020-10-29 | Burleson | Texas | 48051 | 475 | 6 |
679710 | 679710 | 2020-10-29 | Burnet | Texas | 48053 | 1083 | 15 |
679711 | 679711 | 2020-10-29 | Caldwell | Texas | 48055 | 1705 | 37 |
679712 | 679712 | 2020-10-29 | Calhoun | Texas | 48057 | 932 | 9 |
679713 | 679713 | 2020-10-29 | Callahan | Texas | 48059 | 137 | 4 |
679714 | 679714 | 2020-10-29 | Cameron | Texas | 48061 | 24221 | 1083 |
679715 | 679715 | 2020-10-29 | Camp | Texas | 48063 | 399 | 13 |
679716 | 679716 | 2020-10-29 | Carson | Texas | 48065 | 58 | 0 |
679717 | 679717 | 2020-10-29 | Cass | Texas | 48067 | 537 | 23 |
679718 | 679718 | 2020-10-29 | Castro | Texas | 48069 | 311 | 7 |
679719 | 679719 | 2020-10-29 | Chambers | Texas | 48071 | 1571 | 20 |
679720 | 679720 | 2020-10-29 | Cherokee | Texas | 48073 | 1643 | 38 |
679721 | 679721 | 2020-10-29 | Childress | Texas | 48075 | 122 | 0 |
679722 | 679722 | 2020-10-29 | Clay | Texas | 48077 | 125 | 3 |
679723 | 679723 | 2020-10-29 | Cochran | Texas | 48079 | 109 | 1 |
679724 | 679724 | 2020-10-29 | Coke | Texas | 48081 | 128 | 6 |
679725 | 679725 | 2020-10-29 | Coleman | Texas | 48083 | 93 | 4 |
679726 | 679726 | 2020-10-29 | Collin | Texas | 48085 | 18247 | 181 |
679727 | 679727 | 2020-10-29 | Collingsworth | Texas | 48087 | 22 | 0 |
679728 | 679728 | 2020-10-29 | Colorado | Texas | 48089 | 504 | 4 |
679729 | 679729 | 2020-10-29 | Comal | Texas | 48091 | 3764 | 120 |
679730 | 679730 | 2020-10-29 | Comanche | Texas | 48093 | 371 | 5 |
679731 | 679731 | 2020-10-29 | Concho | Texas | 48095 | 144 | 2 |
679732 | 679732 | 2020-10-29 | Cooke | Texas | 48097 | 566 | 9 |
679733 | 679733 | 2020-10-29 | Coryell | Texas | 48099 | 1976 | 13 |
679734 | 679734 | 2020-10-29 | Cottle | Texas | 48101 | 40 | 3 |
679735 | 679735 | 2020-10-29 | Crane | Texas | 48103 | 77 | 4 |
679736 | 679736 | 2020-10-29 | Crockett | Texas | 48105 | 166 | 7 |
679737 | 679737 | 2020-10-29 | Crosby | Texas | 48107 | 123 | 7 |
679738 | 679738 | 2020-10-29 | Culberson | Texas | 48109 | 102 | 2 |
679739 | 679739 | 2020-10-29 | Dallam | Texas | 48111 | 371 | 10 |
679740 | 679740 | 2020-10-29 | Dallas | Texas | 48113 | 101051 | 1243 |
679741 | 679741 | 2020-10-29 | Dawson | Texas | 48115 | 870 | 18 |
679742 | 679742 | 2020-10-29 | DeWitt | Texas | 48123 | 1086 | 44 |
679743 | 679743 | 2020-10-29 | Deaf Smith | Texas | 48117 | 1349 | 26 |
679744 | 679744 | 2020-10-29 | Delta | Texas | 48119 | 35 | 0 |
679745 | 679745 | 2020-10-29 | Denton | Texas | 48121 | 16718 | 174 |
679746 | 679746 | 2020-10-29 | Dickens | Texas | 48125 | 51 | 2 |
679747 | 679747 | 2020-10-29 | Dimmit | Texas | 48127 | 293 | 7 |
679748 | 679748 | 2020-10-29 | Donley | Texas | 48129 | 99 | 1 |
679749 | 679749 | 2020-10-29 | Duval | Texas | 48131 | 492 | 21 |
679750 | 679750 | 2020-10-29 | Eastland | Texas | 48133 | 256 | 8 |
679751 | 679751 | 2020-10-29 | Ector | Texas | 48135 | 6486 | 121 |
679752 | 679752 | 2020-10-29 | Edwards | Texas | 48137 | 72 | 2 |
679753 | 679753 | 2020-10-29 | El Paso | Texas | 48141 | 45039 | 612 |
679754 | 679754 | 2020-10-29 | Ellis | Texas | 48139 | 4999 | 79 |
679755 | 679755 | 2020-10-29 | Erath | Texas | 48143 | 1042 | 15 |
679756 | 679756 | 2020-10-29 | Falls | Texas | 48145 | 686 | 5 |
679757 | 679757 | 2020-10-29 | Fannin | Texas | 48147 | 793 | 20 |
679758 | 679758 | 2020-10-29 | Fayette | Texas | 48149 | 524 | 22 |
679759 | 679759 | 2020-10-29 | Fisher | Texas | 48151 | 107 | 3 |
679760 | 679760 | 2020-10-29 | Floyd | Texas | 48153 | 142 | 9 |
679761 | 679761 | 2020-10-29 | Foard | Texas | 48155 | 22 | 1 |
679762 | 679762 | 2020-10-29 | Fort Bend | Texas | 48157 | 18302 | 309 |
679763 | 679763 | 2020-10-29 | Franklin | Texas | 48159 | 221 | 7 |
679764 | 679764 | 2020-10-29 | Freestone | Texas | 48161 | 460 | 4 |
679765 | 679765 | 2020-10-29 | Frio | Texas | 48163 | 1017 | 9 |
679766 | 679766 | 2020-10-29 | Gaines | Texas | 48165 | 543 | 11 |
679767 | 679767 | 2020-10-29 | Galveston | Texas | 48167 | 12606 | 169 |
679768 | 679768 | 2020-10-29 | Garza | Texas | 48169 | 126 | 8 |
679769 | 679769 | 2020-10-29 | Gillespie | Texas | 48171 | 367 | 10 |
679770 | 679770 | 2020-10-29 | Glasscock | Texas | 48173 | 13 | 0 |
679771 | 679771 | 2020-10-29 | Goliad | Texas | 48175 | 166 | 6 |
679772 | 679772 | 2020-10-29 | Gonzales | Texas | 48177 | 1128 | 20 |
679773 | 679773 | 2020-10-29 | Gray | Texas | 48179 | 495 | 10 |
679774 | 679774 | 2020-10-29 | Grayson | Texas | 48181 | 2661 | 71 |
679775 | 679775 | 2020-10-29 | Gregg | Texas | 48183 | 3486 | 87 |
679776 | 679776 | 2020-10-29 | Grimes | Texas | 48185 | 1191 | 36 |
679777 | 679777 | 2020-10-29 | Guadalupe | Texas | 48187 | 3899 | 81 |
679778 | 679778 | 2020-10-29 | Hale | Texas | 48189 | 2632 | 65 |
679779 | 679779 | 2020-10-29 | Hall | Texas | 48191 | 47 | 1 |
679780 | 679780 | 2020-10-29 | Hamilton | Texas | 48193 | 201 | 5 |
679781 | 679781 | 2020-10-29 | Hansford | Texas | 48195 | 216 | 6 |
679782 | 679782 | 2020-10-29 | Hardeman | Texas | 48197 | 63 | 3 |
679783 | 679783 | 2020-10-29 | Hardin | Texas | 48199 | 1452 | 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);