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 2021-12-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 |
---|---|---|---|---|---|---|---|
1988228 | 1988228 | 2021-12-06 | Anderson | Texas | 48001 | 8126 | 206 |
1988229 | 1988229 | 2021-12-06 | Andrews | Texas | 48003 | 2932 | 65 |
1988230 | 1988230 | 2021-12-06 | Angelina | Texas | 48005 | 13907 | 422 |
1988231 | 1988231 | 2021-12-06 | Aransas | Texas | 48007 | 2638 | 67 |
1988232 | 1988232 | 2021-12-06 | Archer | Texas | 48009 | 1324 | 24 |
1988233 | 1988233 | 2021-12-06 | Armstrong | Texas | 48011 | 313 | 7 |
1988234 | 1988234 | 2021-12-06 | Atascosa | Texas | 48013 | 8771 | 208 |
1988235 | 1988235 | 2021-12-06 | Austin | Texas | 48015 | 3665 | 56 |
1988236 | 1988236 | 2021-12-06 | Bailey | Texas | 48017 | 1032 | 28 |
1988237 | 1988237 | 2021-12-06 | Bandera | Texas | 48019 | 2475 | 61 |
1988238 | 1988238 | 2021-12-06 | Bastrop | Texas | 48021 | 14506 | 186 |
1988239 | 1988239 | 2021-12-06 | Baylor | Texas | 48023 | 593 | 24 |
1988240 | 1988240 | 2021-12-06 | Bee | Texas | 48025 | 5373 | 134 |
1988241 | 1988241 | 2021-12-06 | Bell | Texas | 48027 | 39628 | 742 |
1988242 | 1988242 | 2021-12-06 | Bexar | Texas | 48029 | 329136 | 5282 |
1988243 | 1988243 | 2021-12-06 | Blanco | Texas | 48031 | 1297 | 28 |
1988244 | 1988244 | 2021-12-06 | Borden | Texas | 48033 | 43 | 2 |
1988245 | 1988245 | 2021-12-06 | Bosque | Texas | 48035 | 2468 | 57 |
1988246 | 1988246 | 2021-12-06 | Bowie | Texas | 48037 | 12971 | 346 |
1988247 | 1988247 | 2021-12-06 | Brazoria | Texas | 48039 | 61022 | 855 |
1988248 | 1988248 | 2021-12-06 | Brazos | Texas | 48041 | 39194 | 366 |
1988249 | 1988249 | 2021-12-06 | Brewster | Texas | 48043 | 1106 | 23 |
1988250 | 1988250 | 2021-12-06 | Briscoe | Texas | 48045 | 253 | 7 |
1988251 | 1988251 | 2021-12-06 | Brooks | Texas | 48047 | 1134 | 47 |
1988252 | 1988252 | 2021-12-06 | Brown | Texas | 48049 | 7202 | 193 |
1988253 | 1988253 | 2021-12-06 | Burleson | Texas | 48051 | 3323 | 60 |
1988254 | 1988254 | 2021-12-06 | Burnet | Texas | 48053 | 7596 | 132 |
1988255 | 1988255 | 2021-12-06 | Caldwell | Texas | 48055 | 8573 | 156 |
1988256 | 1988256 | 2021-12-06 | Calhoun | Texas | 48057 | 3915 | 37 |
1988257 | 1988257 | 2021-12-06 | Callahan | Texas | 48059 | 1919 | 57 |
1988258 | 1988258 | 2021-12-06 | Cameron | Texas | 48061 | 67134 | 2009 |
1988259 | 1988259 | 2021-12-06 | Camp | Texas | 48063 | 2070 | 67 |
1988260 | 1988260 | 2021-12-06 | Carson | Texas | 48065 | 862 | 26 |
1988261 | 1988261 | 2021-12-06 | Cass | Texas | 48067 | 4536 | 157 |
1988262 | 1988262 | 2021-12-06 | Castro | Texas | 48069 | 1406 | 40 |
1988263 | 1988263 | 2021-12-06 | Chambers | Texas | 48071 | 8908 | 100 |
1988264 | 1988264 | 2021-12-06 | Cherokee | Texas | 48073 | 6893 | 228 |
1988265 | 1988265 | 2021-12-06 | Childress | Texas | 48075 | 1777 | 22 |
1988266 | 1988266 | 2021-12-06 | Clay | Texas | 48077 | 1601 | 25 |
1988267 | 1988267 | 2021-12-06 | Cochran | Texas | 48079 | 497 | 19 |
1988268 | 1988268 | 2021-12-06 | Coke | Texas | 48081 | 692 | 18 |
1988269 | 1988269 | 2021-12-06 | Coleman | Texas | 48083 | 1190 | 55 |
1988270 | 1988270 | 2021-12-06 | Collin | Texas | 48085 | 133653 | 1175 |
1988271 | 1988271 | 2021-12-06 | Collingsworth | Texas | 48087 | 435 | 11 |
1988272 | 1988272 | 2021-12-06 | Colorado | Texas | 48089 | 2621 | 55 |
1988273 | 1988273 | 2021-12-06 | Comal | Texas | 48091 | 20365 | 470 |
1988274 | 1988274 | 2021-12-06 | Comanche | Texas | 48093 | 2381 | 66 |
1988275 | 1988275 | 2021-12-06 | Concho | Texas | 48095 | 741 | 10 |
1988276 | 1988276 | 2021-12-06 | Cooke | Texas | 48097 | 5212 | 105 |
1988277 | 1988277 | 2021-12-06 | Coryell | Texas | 48099 | 10828 | 167 |
1988278 | 1988278 | 2021-12-06 | Cottle | Texas | 48101 | 245 | 9 |
1988279 | 1988279 | 2021-12-06 | Crane | Texas | 48103 | 951 | 19 |
1988280 | 1988280 | 2021-12-06 | Crockett | Texas | 48105 | 793 | 17 |
1988281 | 1988281 | 2021-12-06 | Crosby | Texas | 48107 | 1072 | 39 |
1988282 | 1988282 | 2021-12-06 | Culberson | Texas | 48109 | 408 | 11 |
1988283 | 1988283 | 2021-12-06 | Dallam | Texas | 48111 | 1331 | 29 |
1988284 | 1988284 | 2021-12-06 | Dallas | Texas | 48113 | 414089 | 5626 |
1988285 | 1988285 | 2021-12-06 | Dawson | Texas | 48115 | 2218 | 80 |
1988286 | 1988286 | 2021-12-06 | DeWitt | Texas | 48123 | 3015 | 85 |
1988287 | 1988287 | 2021-12-06 | Deaf Smith | Texas | 48117 | 3554 | 87 |
1988288 | 1988288 | 2021-12-06 | Delta | Texas | 48119 | 652 | 22 |
1988289 | 1988289 | 2021-12-06 | Denton | Texas | 48121 | 111758 | 1068 |
1988290 | 1988290 | 2021-12-06 | Dickens | Texas | 48125 | 265 | 13 |
1988291 | 1988291 | 2021-12-06 | Dimmit | Texas | 48127 | 3819 | 46 |
1988292 | 1988292 | 2021-12-06 | Donley | Texas | 48129 | 652 | 18 |
1988293 | 1988293 | 2021-12-06 | Duval | Texas | 48131 | 1988 | 60 |
1988294 | 1988294 | 2021-12-06 | Eastland | Texas | 48133 | 2240 | 83 |
1988295 | 1988295 | 2021-12-06 | Ector | Texas | 48135 | 26763 | 555 |
1988296 | 1988296 | 2021-12-06 | Edwards | Texas | 48137 | 336 | 8 |
1988297 | 1988297 | 2021-12-06 | El Paso | Texas | 48141 | 161605 | 2978 |
1988298 | 1988298 | 2021-12-06 | Ellis | Texas | 48139 | 34173 | 482 |
1988299 | 1988299 | 2021-12-06 | Erath | Texas | 48143 | 6469 | 108 |
1988300 | 1988300 | 2021-12-06 | Falls | Texas | 48145 | 2610 | 50 |
1988301 | 1988301 | 2021-12-06 | Fannin | Texas | 48147 | 5089 | 153 |
1988302 | 1988302 | 2021-12-06 | Fayette | Texas | 48149 | 3649 | 93 |
1988303 | 1988303 | 2021-12-06 | Fisher | Texas | 48151 | 442 | 19 |
1988304 | 1988304 | 2021-12-06 | Floyd | Texas | 48153 | 1245 | 40 |
1988305 | 1988305 | 2021-12-06 | Foard | Texas | 48155 | 186 | 10 |
1988306 | 1988306 | 2021-12-06 | Fort Bend | Texas | 48157 | 103117 | 1031 |
1988307 | 1988307 | 2021-12-06 | Franklin | Texas | 48159 | 1366 | 37 |
1988308 | 1988308 | 2021-12-06 | Freestone | Texas | 48161 | 2788 | 73 |
1988309 | 1988309 | 2021-12-06 | Frio | Texas | 48163 | 4140 | 77 |
1988310 | 1988310 | 2021-12-06 | Gaines | Texas | 48165 | 2192 | 65 |
1988311 | 1988311 | 2021-12-06 | Galveston | Texas | 48167 | 65405 | 712 |
1988312 | 1988312 | 2021-12-06 | Garza | Texas | 48169 | 751 | 23 |
1988313 | 1988313 | 2021-12-06 | Gillespie | Texas | 48171 | 3671 | 82 |
1988314 | 1988314 | 2021-12-06 | Glasscock | Texas | 48173 | 157 | 3 |
1988315 | 1988315 | 2021-12-06 | Goliad | Texas | 48175 | 670 | 28 |
1988316 | 1988316 | 2021-12-06 | Gonzales | Texas | 48177 | 3600 | 85 |
1988317 | 1988317 | 2021-12-06 | Gray | Texas | 48179 | 4007 | 85 |
1988318 | 1988318 | 2021-12-06 | Grayson | Texas | 48181 | 16600 | 515 |
1988319 | 1988319 | 2021-12-06 | Gregg | Texas | 48183 | 19475 | 581 |
1988320 | 1988320 | 2021-12-06 | Grimes | Texas | 48185 | 5299 | 108 |
1988321 | 1988321 | 2021-12-06 | Guadalupe | Texas | 48187 | 25096 | 346 |
1988322 | 1988322 | 2021-12-06 | Hale | Texas | 48189 | 8149 | 197 |
1988323 | 1988323 | 2021-12-06 | Hall | Texas | 48191 | 584 | 15 |
1988324 | 1988324 | 2021-12-06 | Hamilton | Texas | 48193 | 1326 | 29 |
1988325 | 1988325 | 2021-12-06 | Hansford | Texas | 48195 | 1168 | 26 |
1988326 | 1988326 | 2021-12-06 | Hardeman | Texas | 48197 | 458 | 14 |
1988327 | 1988327 | 2021-12-06 | Hardin | Texas | 48199 | 10512 | 212 |
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);