ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
254 rows where date = "2021-06-08" 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 |
---|---|---|---|---|---|---|---|
1400279 | 1400279 | 2021-06-08 | Anderson | Texas | 48001 | 6229 | 128 |
1400280 | 1400280 | 2021-06-08 | Andrews | Texas | 48003 | 1837 | 47 |
1400281 | 1400281 | 2021-06-08 | Angelina | Texas | 48005 | 8675 | 284 |
1400282 | 1400282 | 2021-06-08 | Aransas | Texas | 48007 | 1267 | 41 |
1400283 | 1400283 | 2021-06-08 | Archer | Texas | 48009 | 812 | 12 |
1400284 | 1400284 | 2021-06-08 | Armstrong | Texas | 48011 | 204 | 6 |
1400285 | 1400285 | 2021-06-08 | Atascosa | Texas | 48013 | 5840 | 150 |
1400286 | 1400286 | 2021-06-08 | Austin | Texas | 48015 | 2208 | 37 |
1400287 | 1400287 | 2021-06-08 | Bailey | Texas | 48017 | 842 | 19 |
1400288 | 1400288 | 2021-06-08 | Bandera | Texas | 48019 | 1432 | 28 |
1400289 | 1400289 | 2021-06-08 | Bastrop | Texas | 48021 | 9634 | 99 |
1400290 | 1400290 | 2021-06-08 | Baylor | Texas | 48023 | 299 | 13 |
1400291 | 1400291 | 2021-06-08 | Bee | Texas | 48025 | 3508 | 74 |
1400292 | 1400292 | 2021-06-08 | Bell | Texas | 48027 | 22634 | 435 |
1400293 | 1400293 | 2021-06-08 | Bexar | Texas | 48029 | 224197 | 3585 |
1400294 | 1400294 | 2021-06-08 | Blanco | Texas | 48031 | 761 | 20 |
1400295 | 1400295 | 2021-06-08 | Borden | Texas | 48033 | 30 | 2 |
1400296 | 1400296 | 2021-06-08 | Bosque | Texas | 48035 | 1690 | 35 |
1400297 | 1400297 | 2021-06-08 | Bowie | Texas | 48037 | 7111 | 222 |
1400298 | 1400298 | 2021-06-08 | Brazoria | Texas | 48039 | 38241 | 524 |
1400299 | 1400299 | 2021-06-08 | Brazos | Texas | 48041 | 27736 | 254 |
1400300 | 1400300 | 2021-06-08 | Brewster | Texas | 48043 | 936 | 16 |
1400301 | 1400301 | 2021-06-08 | Briscoe | Texas | 48045 | 167 | 6 |
1400302 | 1400302 | 2021-06-08 | Brooks | Texas | 48047 | 832 | 36 |
1400303 | 1400303 | 2021-06-08 | Brown | Texas | 48049 | 4314 | 138 |
1400304 | 1400304 | 2021-06-08 | Burleson | Texas | 48051 | 2448 | 48 |
1400305 | 1400305 | 2021-06-08 | Burnet | Texas | 48053 | 4809 | 66 |
1400306 | 1400306 | 2021-06-08 | Caldwell | Texas | 48055 | 5722 | 98 |
1400307 | 1400307 | 2021-06-08 | Calhoun | Texas | 48057 | 2445 | 25 |
1400308 | 1400308 | 2021-06-08 | Callahan | Texas | 48059 | 1208 | 40 |
1400309 | 1400309 | 2021-06-08 | Cameron | Texas | 48061 | 41422 | 1671 |
1400310 | 1400310 | 2021-06-08 | Camp | Texas | 48063 | 1263 | 44 |
1400311 | 1400311 | 2021-06-08 | Carson | Texas | 48065 | 563 | 14 |
1400312 | 1400312 | 2021-06-08 | Cass | Texas | 48067 | 1972 | 83 |
1400313 | 1400313 | 2021-06-08 | Castro | Texas | 48069 | 1037 | 32 |
1400314 | 1400314 | 2021-06-08 | Chambers | Texas | 48071 | 5160 | 50 |
1400315 | 1400315 | 2021-06-08 | Cherokee | Texas | 48073 | 4275 | 143 |
1400316 | 1400316 | 2021-06-08 | Childress | Texas | 48075 | 1377 | 17 |
1400317 | 1400317 | 2021-06-08 | Clay | Texas | 48077 | 1038 | 16 |
1400318 | 1400318 | 2021-06-08 | Cochran | Texas | 48079 | 325 | 15 |
1400319 | 1400319 | 2021-06-08 | Coke | Texas | 48081 | 467 | 13 |
1400320 | 1400320 | 2021-06-08 | Coleman | Texas | 48083 | 753 | 33 |
1400321 | 1400321 | 2021-06-08 | Collin | Texas | 48085 | 91521 | 835 |
1400322 | 1400322 | 2021-06-08 | Collingsworth | Texas | 48087 | 329 | 9 |
1400323 | 1400323 | 2021-06-08 | Colorado | Texas | 48089 | 1743 | 32 |
1400324 | 1400324 | 2021-06-08 | Comal | Texas | 48091 | 10969 | 323 |
1400325 | 1400325 | 2021-06-08 | Comanche | Texas | 48093 | 1562 | 51 |
1400326 | 1400326 | 2021-06-08 | Concho | Texas | 48095 | 472 | 8 |
1400327 | 1400327 | 2021-06-08 | Cooke | Texas | 48097 | 3788 | 72 |
1400328 | 1400328 | 2021-06-08 | Coryell | Texas | 48099 | 7317 | 86 |
1400329 | 1400329 | 2021-06-08 | Cottle | Texas | 48101 | 191 | 7 |
1400330 | 1400330 | 2021-06-08 | Crane | Texas | 48103 | 540 | 12 |
1400331 | 1400331 | 2021-06-08 | Crockett | Texas | 48105 | 590 | 15 |
1400332 | 1400332 | 2021-06-08 | Crosby | Texas | 48107 | 686 | 29 |
1400333 | 1400333 | 2021-06-08 | Culberson | Texas | 48109 | 364 | 11 |
1400334 | 1400334 | 2021-06-08 | Dallam | Texas | 48111 | 989 | 26 |
1400335 | 1400335 | 2021-06-08 | Dallas | Texas | 48113 | 303854 | 4089 |
1400336 | 1400336 | 2021-06-08 | Dawson | Texas | 48115 | 1740 | 69 |
1400337 | 1400337 | 2021-06-08 | DeWitt | Texas | 48123 | 1933 | 59 |
1400338 | 1400338 | 2021-06-08 | Deaf Smith | Texas | 48117 | 2887 | 68 |
1400339 | 1400339 | 2021-06-08 | Delta | Texas | 48119 | 323 | 12 |
1400340 | 1400340 | 2021-06-08 | Denton | Texas | 48121 | 76390 | 767 |
1400341 | 1400341 | 2021-06-08 | Dickens | Texas | 48125 | 187 | 10 |
1400342 | 1400342 | 2021-06-08 | Dimmit | Texas | 48127 | 2337 | 36 |
1400343 | 1400343 | 2021-06-08 | Donley | Texas | 48129 | 416 | 15 |
1400344 | 1400344 | 2021-06-08 | Duval | Texas | 48131 | 1272 | 41 |
1400345 | 1400345 | 2021-06-08 | Eastland | Texas | 48133 | 1363 | 50 |
1400346 | 1400346 | 2021-06-08 | Ector | Texas | 48135 | 17451 | 377 |
1400347 | 1400347 | 2021-06-08 | Edwards | Texas | 48137 | 253 | 6 |
1400348 | 1400348 | 2021-06-08 | El Paso | Texas | 48141 | 136257 | 2721 |
1400349 | 1400349 | 2021-06-08 | Ellis | Texas | 48139 | 23112 | 319 |
1400350 | 1400350 | 2021-06-08 | Erath | Texas | 48143 | 4224 | 70 |
1400351 | 1400351 | 2021-06-08 | Falls | Texas | 48145 | 2097 | 32 |
1400352 | 1400352 | 2021-06-08 | Fannin | Texas | 48147 | 3484 | 109 |
1400353 | 1400353 | 2021-06-08 | Fayette | Texas | 48149 | 2745 | 67 |
1400354 | 1400354 | 2021-06-08 | Fisher | Texas | 48151 | 305 | 14 |
1400355 | 1400355 | 2021-06-08 | Floyd | Texas | 48153 | 894 | 30 |
1400356 | 1400356 | 2021-06-08 | Foard | Texas | 48155 | 124 | 10 |
1400357 | 1400357 | 2021-06-08 | Fort Bend | Texas | 48157 | 69201 | 688 |
1400358 | 1400358 | 2021-06-08 | Franklin | Texas | 48159 | 739 | 26 |
1400359 | 1400359 | 2021-06-08 | Freestone | Texas | 48161 | 1964 | 50 |
1400360 | 1400360 | 2021-06-08 | Frio | Texas | 48163 | 2962 | 52 |
1400361 | 1400361 | 2021-06-08 | Gaines | Texas | 48165 | 1460 | 44 |
1400362 | 1400362 | 2021-06-08 | Galveston | Texas | 48167 | 40602 | 432 |
1400363 | 1400363 | 2021-06-08 | Garza | Texas | 48169 | 525 | 22 |
1400364 | 1400364 | 2021-06-08 | Gillespie | Texas | 48171 | 2600 | 51 |
1400365 | 1400365 | 2021-06-08 | Glasscock | Texas | 48173 | 104 | 2 |
1400366 | 1400366 | 2021-06-08 | Goliad | Texas | 48175 | 477 | 13 |
1400367 | 1400367 | 2021-06-08 | Gonzales | Texas | 48177 | 2758 | 57 |
1400368 | 1400368 | 2021-06-08 | Gray | Texas | 48179 | 2409 | 57 |
1400369 | 1400369 | 2021-06-08 | Grayson | Texas | 48181 | 11362 | 343 |
1400370 | 1400370 | 2021-06-08 | Gregg | Texas | 48183 | 11363 | 359 |
1400371 | 1400371 | 2021-06-08 | Grimes | Texas | 48185 | 3772 | 72 |
1400372 | 1400372 | 2021-06-08 | Guadalupe | Texas | 48187 | 15285 | 219 |
1400373 | 1400373 | 2021-06-08 | Hale | Texas | 48189 | 6160 | 156 |
1400374 | 1400374 | 2021-06-08 | Hall | Texas | 48191 | 495 | 14 |
1400375 | 1400375 | 2021-06-08 | Hamilton | Texas | 48193 | 783 | 27 |
1400376 | 1400376 | 2021-06-08 | Hansford | Texas | 48195 | 927 | 24 |
1400377 | 1400377 | 2021-06-08 | Hardeman | Texas | 48197 | 384 | 12 |
1400378 | 1400378 | 2021-06-08 | Hardin | Texas | 48199 | 5946 | 113 |
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);