ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
255 rows where "date" is on date 2022-01-19 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2131269 | 2131269 | 2022-01-19 | Anderson | Texas | 48001 | 8893 | 216 |
2131270 | 2131270 | 2022-01-19 | Andrews | Texas | 48003 | 3425 | 68 |
2131271 | 2131271 | 2022-01-19 | Angelina | Texas | 48005 | 13995 | 434 |
2131272 | 2131272 | 2022-01-19 | Aransas | Texas | 48007 | 3202 | 69 |
2131273 | 2131273 | 2022-01-19 | Archer | Texas | 48009 | 1797 | 24 |
2131274 | 2131274 | 2022-01-19 | Armstrong | Texas | 48011 | 448 | 8 |
2131275 | 2131275 | 2022-01-19 | Atascosa | Texas | 48013 | 11015 | 214 |
2131276 | 2131276 | 2022-01-19 | Austin | Texas | 48015 | 4728 | 59 |
2131277 | 2131277 | 2022-01-19 | Bailey | Texas | 48017 | 1279 | 31 |
2131278 | 2131278 | 2022-01-19 | Bandera | Texas | 48019 | 3028 | 65 |
2131279 | 2131279 | 2022-01-19 | Bastrop | Texas | 48021 | 19060 | 195 |
2131280 | 2131280 | 2022-01-19 | Baylor | Texas | 48023 | 708 | 26 |
2131281 | 2131281 | 2022-01-19 | Bee | Texas | 48025 | 7161 | 138 |
2131282 | 2131282 | 2022-01-19 | Bell | Texas | 48027 | 53324 | 762 |
2131283 | 2131283 | 2022-01-19 | Bexar | Texas | 48029 | 446704 | 5426 |
2131284 | 2131284 | 2022-01-19 | Blanco | Texas | 48031 | 2016 | 28 |
2131285 | 2131285 | 2022-01-19 | Borden | Texas | 48033 | 86 | 2 |
2131286 | 2131286 | 2022-01-19 | Bosque | Texas | 48035 | 3253 | 59 |
2131287 | 2131287 | 2022-01-19 | Bowie | Texas | 48037 | 16449 | 362 |
2131288 | 2131288 | 2022-01-19 | Brazoria | Texas | 48039 | 83641 | 887 |
2131289 | 2131289 | 2022-01-19 | Brazos | Texas | 48041 | 51550 | 370 |
2131290 | 2131290 | 2022-01-19 | Brewster | Texas | 48043 | 973 | 24 |
2131291 | 2131291 | 2022-01-19 | Briscoe | Texas | 48045 | 387 | 8 |
2131292 | 2131292 | 2022-01-19 | Brooks | Texas | 48047 | 1316 | 48 |
2131293 | 2131293 | 2022-01-19 | Brown | Texas | 48049 | 9121 | 205 |
2131294 | 2131294 | 2022-01-19 | Burleson | Texas | 48051 | 4416 | 62 |
2131295 | 2131295 | 2022-01-19 | Burnet | Texas | 48053 | 9372 | 139 |
2131296 | 2131296 | 2022-01-19 | Caldwell | Texas | 48055 | 11822 | 160 |
2131297 | 2131297 | 2022-01-19 | Calhoun | Texas | 48057 | 4857 | 40 |
2131298 | 2131298 | 2022-01-19 | Callahan | Texas | 48059 | 2408 | 62 |
2131299 | 2131299 | 2022-01-19 | Cameron | Texas | 48061 | 83362 | 2029 |
2131300 | 2131300 | 2022-01-19 | Camp | Texas | 48063 | 2477 | 69 |
2131301 | 2131301 | 2022-01-19 | Carson | Texas | 48065 | 1316 | 30 |
2131302 | 2131302 | 2022-01-19 | Cass | Texas | 48067 | 5583 | 166 |
2131303 | 2131303 | 2022-01-19 | Castro | Texas | 48069 | 2006 | 45 |
2131304 | 2131304 | 2022-01-19 | Chambers | Texas | 48071 | 10615 | 105 |
2131305 | 2131305 | 2022-01-19 | Cherokee | Texas | 48073 | 6990 | 230 |
2131306 | 2131306 | 2022-01-19 | Childress | Texas | 48075 | 2186 | 26 |
2131307 | 2131307 | 2022-01-19 | Clay | Texas | 48077 | 1850 | 26 |
2131308 | 2131308 | 2022-01-19 | Cochran | Texas | 48079 | 726 | 21 |
2131309 | 2131309 | 2022-01-19 | Coke | Texas | 48081 | 762 | 18 |
2131310 | 2131310 | 2022-01-19 | Coleman | Texas | 48083 | 1477 | 61 |
2131311 | 2131311 | 2022-01-19 | Collin | Texas | 48085 | 174766 | 1251 |
2131312 | 2131312 | 2022-01-19 | Collingsworth | Texas | 48087 | 599 | 13 |
2131313 | 2131313 | 2022-01-19 | Colorado | Texas | 48089 | 3168 | 57 |
2131314 | 2131314 | 2022-01-19 | Comal | Texas | 48091 | 27042 | 490 |
2131315 | 2131315 | 2022-01-19 | Comanche | Texas | 48093 | 2827 | 69 |
2131316 | 2131316 | 2022-01-19 | Concho | Texas | 48095 | 941 | 10 |
2131317 | 2131317 | 2022-01-19 | Cooke | Texas | 48097 | 6434 | 114 |
2131318 | 2131318 | 2022-01-19 | Coryell | Texas | 48099 | 14801 | 173 |
2131319 | 2131319 | 2022-01-19 | Cottle | Texas | 48101 | 264 | 9 |
2131320 | 2131320 | 2022-01-19 | Crane | Texas | 48103 | 1043 | 19 |
2131321 | 2131321 | 2022-01-19 | Crockett | Texas | 48105 | 939 | 17 |
2131322 | 2131322 | 2022-01-19 | Crosby | Texas | 48107 | 1666 | 42 |
2131323 | 2131323 | 2022-01-19 | Culberson | Texas | 48109 | 457 | 13 |
2131324 | 2131324 | 2022-01-19 | Dallam | Texas | 48111 | 1868 | 34 |
2131325 | 2131325 | 2022-01-19 | Dallas | Texas | 48113 | 507067 | 5903 |
2131326 | 2131326 | 2022-01-19 | Dawson | Texas | 48115 | 2256 | 83 |
2131327 | 2131327 | 2022-01-19 | DeWitt | Texas | 48123 | 5673 | 86 |
2131328 | 2131328 | 2022-01-19 | Deaf Smith | Texas | 48117 | 3874 | 103 |
2131329 | 2131329 | 2022-01-19 | Delta | Texas | 48119 | 1556 | 22 |
2131330 | 2131330 | 2022-01-19 | Denton | Texas | 48121 | 146253 | 1127 |
2131331 | 2131331 | 2022-01-19 | Dickens | Texas | 48125 | 361 | 15 |
2131332 | 2131332 | 2022-01-19 | Dimmit | Texas | 48127 | 4745 | 48 |
2131333 | 2131333 | 2022-01-19 | Donley | Texas | 48129 | 882 | 20 |
2131334 | 2131334 | 2022-01-19 | Duval | Texas | 48131 | 2493 | 62 |
2131335 | 2131335 | 2022-01-19 | Eastland | Texas | 48133 | 2541 | 92 |
2131336 | 2131336 | 2022-01-19 | Ector | Texas | 48135 | 33221 | 589 |
2131337 | 2131337 | 2022-01-19 | Edwards | Texas | 48137 | 391 | 9 |
2131338 | 2131338 | 2022-01-19 | El Paso | Texas | 48141 | 172163 | 3291 |
2131339 | 2131339 | 2022-01-19 | Ellis | Texas | 48139 | 42685 | 506 |
2131340 | 2131340 | 2022-01-19 | Erath | Texas | 48143 | 7468 | 110 |
2131341 | 2131341 | 2022-01-19 | Falls | Texas | 48145 | 3283 | 54 |
2131342 | 2131342 | 2022-01-19 | Fannin | Texas | 48147 | 5976 | 157 |
2131343 | 2131343 | 2022-01-19 | Fayette | Texas | 48149 | 4226 | 95 |
2131344 | 2131344 | 2022-01-19 | Fisher | Texas | 48151 | 529 | 20 |
2131345 | 2131345 | 2022-01-19 | Floyd | Texas | 48153 | 1739 | 42 |
2131346 | 2131346 | 2022-01-19 | Foard | Texas | 48155 | 183 | 10 |
2131347 | 2131347 | 2022-01-19 | Fort Bend | Texas | 48157 | 154596 | 1080 |
2131348 | 2131348 | 2022-01-19 | Franklin | Texas | 48159 | 1794 | 37 |
2131349 | 2131349 | 2022-01-19 | Freestone | Texas | 48161 | 3466 | 76 |
2131350 | 2131350 | 2022-01-19 | Frio | Texas | 48163 | 4679 | 80 |
2131351 | 2131351 | 2022-01-19 | Gaines | Texas | 48165 | 1594 | 73 |
2131352 | 2131352 | 2022-01-19 | Galveston | Texas | 48167 | 85047 | 756 |
2131353 | 2131353 | 2022-01-19 | Garza | Texas | 48169 | 1096 | 25 |
2131354 | 2131354 | 2022-01-19 | Gillespie | Texas | 48171 | 4582 | 86 |
2131355 | 2131355 | 2022-01-19 | Glasscock | Texas | 48173 | 184 | 3 |
2131356 | 2131356 | 2022-01-19 | Goliad | Texas | 48175 | 933 | 28 |
2131357 | 2131357 | 2022-01-19 | Gonzales | Texas | 48177 | 4077 | 92 |
2131358 | 2131358 | 2022-01-19 | Gray | Texas | 48179 | 5525 | 106 |
2131359 | 2131359 | 2022-01-19 | Grayson | Texas | 48181 | 23196 | 548 |
2131360 | 2131360 | 2022-01-19 | Gregg | Texas | 48183 | 20602 | 594 |
2131361 | 2131361 | 2022-01-19 | Grimes | Texas | 48185 | 7332 | 111 |
2131362 | 2131362 | 2022-01-19 | Guadalupe | Texas | 48187 | 31004 | 350 |
2131363 | 2131363 | 2022-01-19 | Hale | Texas | 48189 | 5801 | 214 |
2131364 | 2131364 | 2022-01-19 | Hall | Texas | 48191 | 875 | 18 |
2131365 | 2131365 | 2022-01-19 | Hamilton | Texas | 48193 | 1765 | 29 |
2131366 | 2131366 | 2022-01-19 | Hansford | Texas | 48195 | 1526 | 27 |
2131367 | 2131367 | 2022-01-19 | Hardeman | Texas | 48197 | 517 | 14 |
2131368 | 2131368 | 2022-01-19 | Hardin | Texas | 48199 | 11000 | 222 |
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);