ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
254 rows where date = "2021-03-23" 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 |
---|---|---|---|---|---|---|---|
1150267 | 1150267 | 2021-03-23 | Anderson | Texas | 48001 | 6080 | 112 |
1150268 | 1150268 | 2021-03-23 | Andrews | Texas | 48003 | 1733 | 47 |
1150269 | 1150269 | 2021-03-23 | Angelina | Texas | 48005 | 8164 | 268 |
1150270 | 1150270 | 2021-03-23 | Aransas | Texas | 48007 | 1177 | 35 |
1150271 | 1150271 | 2021-03-23 | Archer | Texas | 48009 | 788 | 12 |
1150272 | 1150272 | 2021-03-23 | Armstrong | Texas | 48011 | 153 | 6 |
1150273 | 1150273 | 2021-03-23 | Atascosa | Texas | 48013 | 5512 | 143 |
1150274 | 1150274 | 2021-03-23 | Austin | Texas | 48015 | 1977 | 34 |
1150275 | 1150275 | 2021-03-23 | Bailey | Texas | 48017 | 813 | 18 |
1150276 | 1150276 | 2021-03-23 | Bandera | Texas | 48019 | 1307 | 27 |
1150277 | 1150277 | 2021-03-23 | Bastrop | Texas | 48021 | 8721 | 88 |
1150278 | 1150278 | 2021-03-23 | Baylor | Texas | 48023 | 293 | 11 |
1150279 | 1150279 | 2021-03-23 | Bee | Texas | 48025 | 3451 | 68 |
1150280 | 1150280 | 2021-03-23 | Bell | Texas | 48027 | 21294 | 408 |
1150281 | 1150281 | 2021-03-23 | Bexar | Texas | 48029 | 202861 | 3225 |
1150282 | 1150282 | 2021-03-23 | Blanco | Texas | 48031 | 697 | 19 |
1150283 | 1150283 | 2021-03-23 | Borden | Texas | 48033 | 30 | 2 |
1150284 | 1150284 | 2021-03-23 | Bosque | Texas | 48035 | 1627 | 33 |
1150285 | 1150285 | 2021-03-23 | Bowie | Texas | 48037 | 6767 | 199 |
1150286 | 1150286 | 2021-03-23 | Brazoria | Texas | 48039 | 34979 | 434 |
1150287 | 1150287 | 2021-03-23 | Brazos | Texas | 48041 | 22582 | 233 |
1150288 | 1150288 | 2021-03-23 | Brewster | Texas | 48043 | 898 | 12 |
1150289 | 1150289 | 2021-03-23 | Briscoe | Texas | 48045 | 138 | 5 |
1150290 | 1150290 | 2021-03-23 | Brooks | Texas | 48047 | 772 | 36 |
1150291 | 1150291 | 2021-03-23 | Brown | Texas | 48049 | 4209 | 133 |
1150292 | 1150292 | 2021-03-23 | Burleson | Texas | 48051 | 2284 | 38 |
1150293 | 1150293 | 2021-03-23 | Burnet | Texas | 48053 | 4442 | 61 |
1150294 | 1150294 | 2021-03-23 | Caldwell | Texas | 48055 | 5319 | 92 |
1150295 | 1150295 | 2021-03-23 | Calhoun | Texas | 48057 | 2103 | 20 |
1150296 | 1150296 | 2021-03-23 | Callahan | Texas | 48059 | 1157 | 38 |
1150297 | 1150297 | 2021-03-23 | Cameron | Texas | 48061 | 38255 | 1565 |
1150298 | 1150298 | 2021-03-23 | Camp | Texas | 48063 | 1201 | 42 |
1150299 | 1150299 | 2021-03-23 | Carson | Texas | 48065 | 421 | 14 |
1150300 | 1150300 | 2021-03-23 | Cass | Texas | 48067 | 1822 | 79 |
1150301 | 1150301 | 2021-03-23 | Castro | Texas | 48069 | 913 | 30 |
1150302 | 1150302 | 2021-03-23 | Chambers | Texas | 48071 | 4550 | 47 |
1150303 | 1150303 | 2021-03-23 | Cherokee | Texas | 48073 | 4087 | 132 |
1150304 | 1150304 | 2021-03-23 | Childress | Texas | 48075 | 1342 | 17 |
1150305 | 1150305 | 2021-03-23 | Clay | Texas | 48077 | 1017 | 16 |
1150306 | 1150306 | 2021-03-23 | Cochran | Texas | 48079 | 259 | 14 |
1150307 | 1150307 | 2021-03-23 | Coke | Texas | 48081 | 441 | 12 |
1150308 | 1150308 | 2021-03-23 | Coleman | Texas | 48083 | 735 | 31 |
1150309 | 1150309 | 2021-03-23 | Collin | Texas | 48085 | 85885 | 784 |
1150310 | 1150310 | 2021-03-23 | Collingsworth | Texas | 48087 | 272 | 9 |
1150311 | 1150311 | 2021-03-23 | Colorado | Texas | 48089 | 1623 | 25 |
1150312 | 1150312 | 2021-03-23 | Comal | Texas | 48091 | 9556 | 305 |
1150313 | 1150313 | 2021-03-23 | Comanche | Texas | 48093 | 1511 | 51 |
1150314 | 1150314 | 2021-03-23 | Concho | Texas | 48095 | 367 | 8 |
1150315 | 1150315 | 2021-03-23 | Cooke | Texas | 48097 | 3598 | 65 |
1150316 | 1150316 | 2021-03-23 | Coryell | Texas | 48099 | 6959 | 83 |
1150317 | 1150317 | 2021-03-23 | Cottle | Texas | 48101 | 190 | 7 |
1150318 | 1150318 | 2021-03-23 | Crane | Texas | 48103 | 515 | 12 |
1150319 | 1150319 | 2021-03-23 | Crockett | Texas | 48105 | 573 | 15 |
1150320 | 1150320 | 2021-03-23 | Crosby | Texas | 48107 | 536 | 28 |
1150321 | 1150321 | 2021-03-23 | Culberson | Texas | 48109 | 352 | 8 |
1150322 | 1150322 | 2021-03-23 | Dallam | Texas | 48111 | 929 | 24 |
1150323 | 1150323 | 2021-03-23 | Dallas | Texas | 48113 | 288928 | 3783 |
1150324 | 1150324 | 2021-03-23 | Dawson | Texas | 48115 | 1716 | 68 |
1150325 | 1150325 | 2021-03-23 | DeWitt | Texas | 48123 | 1898 | 58 |
1150326 | 1150326 | 2021-03-23 | Deaf Smith | Texas | 48117 | 2746 | 64 |
1150327 | 1150327 | 2021-03-23 | Delta | Texas | 48119 | 307 | 11 |
1150328 | 1150328 | 2021-03-23 | Denton | Texas | 48121 | 71200 | 712 |
1150329 | 1150329 | 2021-03-23 | Dickens | Texas | 48125 | 157 | 10 |
1150330 | 1150330 | 2021-03-23 | Dimmit | Texas | 48127 | 1596 | 28 |
1150331 | 1150331 | 2021-03-23 | Donley | Texas | 48129 | 353 | 15 |
1150332 | 1150332 | 2021-03-23 | Duval | Texas | 48131 | 1195 | 39 |
1150333 | 1150333 | 2021-03-23 | Eastland | Texas | 48133 | 1320 | 47 |
1150334 | 1150334 | 2021-03-23 | Ector | Texas | 48135 | 16559 | 349 |
1150335 | 1150335 | 2021-03-23 | Edwards | Texas | 48137 | 246 | 4 |
1150336 | 1150336 | 2021-03-23 | El Paso | Texas | 48141 | 128252 | 2520 |
1150337 | 1150337 | 2021-03-23 | Ellis | Texas | 48139 | 21691 | 300 |
1150338 | 1150338 | 2021-03-23 | Erath | Texas | 48143 | 4038 | 67 |
1150339 | 1150339 | 2021-03-23 | Falls | Texas | 48145 | 2036 | 29 |
1150340 | 1150340 | 2021-03-23 | Fannin | Texas | 48147 | 3395 | 105 |
1150341 | 1150341 | 2021-03-23 | Fayette | Texas | 48149 | 2447 | 56 |
1150342 | 1150342 | 2021-03-23 | Fisher | Texas | 48151 | 290 | 14 |
1150343 | 1150343 | 2021-03-23 | Floyd | Texas | 48153 | 779 | 29 |
1150344 | 1150344 | 2021-03-23 | Foard | Texas | 48155 | 120 | 9 |
1150345 | 1150345 | 2021-03-23 | Fort Bend | Texas | 48157 | 62354 | 617 |
1150346 | 1150346 | 2021-03-23 | Franklin | Texas | 48159 | 704 | 26 |
1150347 | 1150347 | 2021-03-23 | Freestone | Texas | 48161 | 1791 | 48 |
1150348 | 1150348 | 2021-03-23 | Frio | Texas | 48163 | 2710 | 47 |
1150349 | 1150349 | 2021-03-23 | Gaines | Texas | 48165 | 1416 | 42 |
1150350 | 1150350 | 2021-03-23 | Galveston | Texas | 48167 | 36559 | 384 |
1150351 | 1150351 | 2021-03-23 | Garza | Texas | 48169 | 381 | 22 |
1150352 | 1150352 | 2021-03-23 | Gillespie | Texas | 48171 | 2480 | 48 |
1150353 | 1150353 | 2021-03-23 | Glasscock | Texas | 48173 | 99 | 2 |
1150354 | 1150354 | 2021-03-23 | Goliad | Texas | 48175 | 433 | 13 |
1150355 | 1150355 | 2021-03-23 | Gonzales | Texas | 48177 | 2663 | 55 |
1150356 | 1150356 | 2021-03-23 | Gray | Texas | 48179 | 2023 | 54 |
1150357 | 1150357 | 2021-03-23 | Grayson | Texas | 48181 | 11019 | 335 |
1150358 | 1150358 | 2021-03-23 | Gregg | Texas | 48183 | 10843 | 338 |
1150359 | 1150359 | 2021-03-23 | Grimes | Texas | 48185 | 3497 | 66 |
1150360 | 1150360 | 2021-03-23 | Guadalupe | Texas | 48187 | 13742 | 200 |
1150361 | 1150361 | 2021-03-23 | Hale | Texas | 48189 | 6067 | 153 |
1150362 | 1150362 | 2021-03-23 | Hall | Texas | 48191 | 426 | 14 |
1150363 | 1150363 | 2021-03-23 | Hamilton | Texas | 48193 | 753 | 26 |
1150364 | 1150364 | 2021-03-23 | Hansford | Texas | 48195 | 835 | 23 |
1150365 | 1150365 | 2021-03-23 | Hardeman | Texas | 48197 | 367 | 12 |
1150366 | 1150366 | 2021-03-23 | Hardin | Texas | 48199 | 5266 | 102 |
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);