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 2022-01-06 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2088995 | 2088995 | 2022-01-06 | Anderson | Texas | 48001 | 8590 | 209 |
2088996 | 2088996 | 2022-01-06 | Andrews | Texas | 48003 | 3191 | 67 |
2088997 | 2088997 | 2022-01-06 | Angelina | Texas | 48005 | 14292 | 428 |
2088998 | 2088998 | 2022-01-06 | Aransas | Texas | 48007 | 2823 | 68 |
2088999 | 2088999 | 2022-01-06 | Archer | Texas | 48009 | 1506 | 24 |
2089000 | 2089000 | 2022-01-06 | Armstrong | Texas | 48011 | 353 | 8 |
2089001 | 2089001 | 2022-01-06 | Atascosa | Texas | 48013 | 9254 | 213 |
2089002 | 2089002 | 2022-01-06 | Austin | Texas | 48015 | 4198 | 58 |
2089003 | 2089003 | 2022-01-06 | Bailey | Texas | 48017 | 1137 | 31 |
2089004 | 2089004 | 2022-01-06 | Bandera | Texas | 48019 | 2670 | 65 |
2089005 | 2089005 | 2022-01-06 | Bastrop | Texas | 48021 | 15923 | 194 |
2089006 | 2089006 | 2022-01-06 | Baylor | Texas | 48023 | 628 | 25 |
2089007 | 2089007 | 2022-01-06 | Bee | Texas | 48025 | 5669 | 137 |
2089008 | 2089008 | 2022-01-06 | Bell | Texas | 48027 | 43301 | 756 |
2089009 | 2089009 | 2022-01-06 | Bexar | Texas | 48029 | 364052 | 5363 |
2089010 | 2089010 | 2022-01-06 | Blanco | Texas | 48031 | 1536 | 28 |
2089011 | 2089011 | 2022-01-06 | Borden | Texas | 48033 | 56 | 2 |
2089012 | 2089012 | 2022-01-06 | Bosque | Texas | 48035 | 2714 | 59 |
2089013 | 2089013 | 2022-01-06 | Bowie | Texas | 48037 | 14052 | 356 |
2089014 | 2089014 | 2022-01-06 | Brazoria | Texas | 48039 | 73137 | 877 |
2089015 | 2089015 | 2022-01-06 | Brazos | Texas | 48041 | 44709 | 368 |
2089016 | 2089016 | 2022-01-06 | Brewster | Texas | 48043 | 1124 | 24 |
2089017 | 2089017 | 2022-01-06 | Briscoe | Texas | 48045 | 275 | 7 |
2089018 | 2089018 | 2022-01-06 | Brooks | Texas | 48047 | 1185 | 47 |
2089019 | 2089019 | 2022-01-06 | Brown | Texas | 48049 | 7580 | 196 |
2089020 | 2089020 | 2022-01-06 | Burleson | Texas | 48051 | 3538 | 61 |
2089021 | 2089021 | 2022-01-06 | Burnet | Texas | 48053 | 8129 | 137 |
2089022 | 2089022 | 2022-01-06 | Caldwell | Texas | 48055 | 9732 | 159 |
2089023 | 2089023 | 2022-01-06 | Calhoun | Texas | 48057 | 4137 | 40 |
2089024 | 2089024 | 2022-01-06 | Callahan | Texas | 48059 | 2108 | 61 |
2089025 | 2089025 | 2022-01-06 | Cameron | Texas | 48061 | 71132 | 2029 |
2089026 | 2089026 | 2022-01-06 | Camp | Texas | 48063 | 2275 | 69 |
2089027 | 2089027 | 2022-01-06 | Carson | Texas | 48065 | 965 | 29 |
2089028 | 2089028 | 2022-01-06 | Cass | Texas | 48067 | 4933 | 163 |
2089029 | 2089029 | 2022-01-06 | Castro | Texas | 48069 | 1514 | 42 |
2089030 | 2089030 | 2022-01-06 | Chambers | Texas | 48071 | 9708 | 102 |
2089031 | 2089031 | 2022-01-06 | Cherokee | Texas | 48073 | 7127 | 230 |
2089032 | 2089032 | 2022-01-06 | Childress | Texas | 48075 | 1916 | 24 |
2089033 | 2089033 | 2022-01-06 | Clay | Texas | 48077 | 1680 | 26 |
2089034 | 2089034 | 2022-01-06 | Cochran | Texas | 48079 | 544 | 21 |
2089035 | 2089035 | 2022-01-06 | Coke | Texas | 48081 | 743 | 18 |
2089036 | 2089036 | 2022-01-06 | Coleman | Texas | 48083 | 1266 | 59 |
2089037 | 2089037 | 2022-01-06 | Collin | Texas | 48085 | 152472 | 1222 |
2089038 | 2089038 | 2022-01-06 | Collingsworth | Texas | 48087 | 482 | 11 |
2089039 | 2089039 | 2022-01-06 | Colorado | Texas | 48089 | 2886 | 56 |
2089040 | 2089040 | 2022-01-06 | Comal | Texas | 48091 | 22763 | 485 |
2089041 | 2089041 | 2022-01-06 | Comanche | Texas | 48093 | 2478 | 67 |
2089042 | 2089042 | 2022-01-06 | Concho | Texas | 48095 | 801 | 10 |
2089043 | 2089043 | 2022-01-06 | Cooke | Texas | 48097 | 5598 | 111 |
2089044 | 2089044 | 2022-01-06 | Coryell | Texas | 48099 | 11464 | 172 |
2089045 | 2089045 | 2022-01-06 | Cottle | Texas | 48101 | 257 | 9 |
2089046 | 2089046 | 2022-01-06 | Crane | Texas | 48103 | 1041 | 19 |
2089047 | 2089047 | 2022-01-06 | Crockett | Texas | 48105 | 863 | 17 |
2089048 | 2089048 | 2022-01-06 | Crosby | Texas | 48107 | 1188 | 42 |
2089049 | 2089049 | 2022-01-06 | Culberson | Texas | 48109 | 424 | 13 |
2089050 | 2089050 | 2022-01-06 | Dallam | Texas | 48111 | 1444 | 33 |
2089051 | 2089051 | 2022-01-06 | Dallas | Texas | 48113 | 465748 | 5799 |
2089052 | 2089052 | 2022-01-06 | Dawson | Texas | 48115 | 2368 | 83 |
2089053 | 2089053 | 2022-01-06 | DeWitt | Texas | 48123 | 3181 | 86 |
2089054 | 2089054 | 2022-01-06 | Deaf Smith | Texas | 48117 | 3805 | 101 |
2089055 | 2089055 | 2022-01-06 | Delta | Texas | 48119 | 794 | 22 |
2089056 | 2089056 | 2022-01-06 | Denton | Texas | 48121 | 126785 | 1094 |
2089057 | 2089057 | 2022-01-06 | Dickens | Texas | 48125 | 288 | 15 |
2089058 | 2089058 | 2022-01-06 | Dimmit | Texas | 48127 | 4099 | 47 |
2089059 | 2089059 | 2022-01-06 | Donley | Texas | 48129 | 751 | 18 |
2089060 | 2089060 | 2022-01-06 | Duval | Texas | 48131 | 2120 | 62 |
2089061 | 2089061 | 2022-01-06 | Eastland | Texas | 48133 | 2397 | 91 |
2089062 | 2089062 | 2022-01-06 | Ector | Texas | 48135 | 29235 | 577 |
2089063 | 2089063 | 2022-01-06 | Edwards | Texas | 48137 | 352 | 9 |
2089064 | 2089064 | 2022-01-06 | El Paso | Texas | 48141 | 172015 | 3187 |
2089065 | 2089065 | 2022-01-06 | Ellis | Texas | 48139 | 37817 | 494 |
2089066 | 2089066 | 2022-01-06 | Erath | Texas | 48143 | 6881 | 109 |
2089067 | 2089067 | 2022-01-06 | Falls | Texas | 48145 | 2741 | 52 |
2089068 | 2089068 | 2022-01-06 | Fannin | Texas | 48147 | 5350 | 155 |
2089069 | 2089069 | 2022-01-06 | Fayette | Texas | 48149 | 3881 | 95 |
2089070 | 2089070 | 2022-01-06 | Fisher | Texas | 48151 | 464 | 20 |
2089071 | 2089071 | 2022-01-06 | Floyd | Texas | 48153 | 1357 | 40 |
2089072 | 2089072 | 2022-01-06 | Foard | Texas | 48155 | 195 | 10 |
2089073 | 2089073 | 2022-01-06 | Fort Bend | Texas | 48157 | 130060 | 1066 |
2089074 | 2089074 | 2022-01-06 | Franklin | Texas | 48159 | 1511 | 37 |
2089075 | 2089075 | 2022-01-06 | Freestone | Texas | 48161 | 2967 | 74 |
2089076 | 2089076 | 2022-01-06 | Frio | Texas | 48163 | 4347 | 78 |
2089077 | 2089077 | 2022-01-06 | Gaines | Texas | 48165 | 2239 | 71 |
2089078 | 2089078 | 2022-01-06 | Galveston | Texas | 48167 | 76694 | 731 |
2089079 | 2089079 | 2022-01-06 | Garza | Texas | 48169 | 783 | 25 |
2089080 | 2089080 | 2022-01-06 | Gillespie | Texas | 48171 | 3938 | 84 |
2089081 | 2089081 | 2022-01-06 | Glasscock | Texas | 48173 | 172 | 3 |
2089082 | 2089082 | 2022-01-06 | Goliad | Texas | 48175 | 718 | 28 |
2089083 | 2089083 | 2022-01-06 | Gonzales | Texas | 48177 | 3734 | 89 |
2089084 | 2089084 | 2022-01-06 | Gray | Texas | 48179 | 4515 | 99 |
2089085 | 2089085 | 2022-01-06 | Grayson | Texas | 48181 | 18254 | 537 |
2089086 | 2089086 | 2022-01-06 | Gregg | Texas | 48183 | 20410 | 591 |
2089087 | 2089087 | 2022-01-06 | Grimes | Texas | 48185 | 5962 | 110 |
2089088 | 2089088 | 2022-01-06 | Guadalupe | Texas | 48187 | 27091 | 348 |
2089089 | 2089089 | 2022-01-06 | Hale | Texas | 48189 | 8579 | 206 |
2089090 | 2089090 | 2022-01-06 | Hall | Texas | 48191 | 669 | 16 |
2089091 | 2089091 | 2022-01-06 | Hamilton | Texas | 48193 | 1492 | 29 |
2089092 | 2089092 | 2022-01-06 | Hansford | Texas | 48195 | 1290 | 27 |
2089093 | 2089093 | 2022-01-06 | Hardeman | Texas | 48197 | 469 | 14 |
2089094 | 2089094 | 2022-01-06 | Hardin | Texas | 48199 | 11015 | 216 |
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);