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-03-23 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2336179 | 2336179 | 2022-03-23 | Anderson | Texas | 48001 | 9523 | 234 |
2336180 | 2336180 | 2022-03-23 | Andrews | Texas | 48003 | 3790 | 71 |
2336181 | 2336181 | 2022-03-23 | Angelina | Texas | 48005 | 15291 | 479 |
2336182 | 2336182 | 2022-03-23 | Aransas | Texas | 48007 | 4081 | 81 |
2336183 | 2336183 | 2022-03-23 | Archer | Texas | 48009 | 2121 | 28 |
2336184 | 2336184 | 2022-03-23 | Armstrong | Texas | 48011 | 517 | 9 |
2336185 | 2336185 | 2022-03-23 | Atascosa | Texas | 48013 | 13465 | 231 |
2336186 | 2336186 | 2022-03-23 | Austin | Texas | 48015 | 5678 | 73 |
2336187 | 2336187 | 2022-03-23 | Bailey | Texas | 48017 | 1442 | 39 |
2336188 | 2336188 | 2022-03-23 | Bandera | Texas | 48019 | 3581 | 75 |
2336189 | 2336189 | 2022-03-23 | Bastrop | Texas | 48021 | 21659 | 232 |
2336190 | 2336190 | 2022-03-23 | Baylor | Texas | 48023 | 809 | 32 |
2336191 | 2336191 | 2022-03-23 | Bee | Texas | 48025 | 8252 | 152 |
2336192 | 2336192 | 2022-03-23 | Bell | Texas | 48027 | 66740 | 882 |
2336193 | 2336193 | 2022-03-23 | Bexar | Texas | 48029 | 551869 | 6049 |
2336194 | 2336194 | 2022-03-23 | Blanco | Texas | 48031 | 2523 | 34 |
2336195 | 2336195 | 2022-03-23 | Borden | Texas | 48033 | 97 | 2 |
2336196 | 2336196 | 2022-03-23 | Bosque | Texas | 48035 | 4051 | 70 |
2336197 | 2336197 | 2022-03-23 | Bowie | Texas | 48037 | 20038 | 428 |
2336198 | 2336198 | 2022-03-23 | Brazoria | Texas | 48039 | 93118 | 978 |
2336199 | 2336199 | 2022-03-23 | Brazos | Texas | 48041 | 60119 | 405 |
2336200 | 2336200 | 2022-03-23 | Brewster | Texas | 48043 | 1056 | 29 |
2336201 | 2336201 | 2022-03-23 | Briscoe | Texas | 48045 | 454 | 8 |
2336202 | 2336202 | 2022-03-23 | Brooks | Texas | 48047 | 1609 | 51 |
2336203 | 2336203 | 2022-03-23 | Brown | Texas | 48049 | 11390 | 250 |
2336204 | 2336204 | 2022-03-23 | Burleson | Texas | 48051 | 5001 | 66 |
2336205 | 2336205 | 2022-03-23 | Burnet | Texas | 48053 | 10794 | 166 |
2336206 | 2336206 | 2022-03-23 | Caldwell | Texas | 48055 | 14137 | 175 |
2336207 | 2336207 | 2022-03-23 | Calhoun | Texas | 48057 | 5685 | 48 |
2336208 | 2336208 | 2022-03-23 | Callahan | Texas | 48059 | 2793 | 72 |
2336209 | 2336209 | 2022-03-23 | Cameron | Texas | 48061 | 100491 | 2029 |
2336210 | 2336210 | 2022-03-23 | Camp | Texas | 48063 | 2832 | 74 |
2336211 | 2336211 | 2022-03-23 | Carson | Texas | 48065 | 1519 | 34 |
2336212 | 2336212 | 2022-03-23 | Cass | Texas | 48067 | 7193 | 194 |
2336213 | 2336213 | 2022-03-23 | Castro | Texas | 48069 | 2278 | 47 |
2336214 | 2336214 | 2022-03-23 | Chambers | Texas | 48071 | 11655 | 112 |
2336215 | 2336215 | 2022-03-23 | Cherokee | Texas | 48073 | 7935 | 253 |
2336216 | 2336216 | 2022-03-23 | Childress | Texas | 48075 | 2622 | 31 |
2336217 | 2336217 | 2022-03-23 | Clay | Texas | 48077 | 2052 | 34 |
2336218 | 2336218 | 2022-03-23 | Cochran | Texas | 48079 | 878 | 23 |
2336219 | 2336219 | 2022-03-23 | Coke | Texas | 48081 | 832 | 19 |
2336220 | 2336220 | 2022-03-23 | Coleman | Texas | 48083 | 1621 | 69 |
2336221 | 2336221 | 2022-03-23 | Collin | Texas | 48085 | 208040 | 1481 |
2336222 | 2336222 | 2022-03-23 | Collingsworth | Texas | 48087 | 701 | 16 |
2336223 | 2336223 | 2022-03-23 | Colorado | Texas | 48089 | 3774 | 62 |
2336224 | 2336224 | 2022-03-23 | Comal | Texas | 48091 | 33349 | 544 |
2336225 | 2336225 | 2022-03-23 | Comanche | Texas | 48093 | 3293 | 78 |
2336226 | 2336226 | 2022-03-23 | Concho | Texas | 48095 | 1074 | 11 |
2336227 | 2336227 | 2022-03-23 | Cooke | Texas | 48097 | 7249 | 131 |
2336228 | 2336228 | 2022-03-23 | Coryell | Texas | 48099 | 17168 | 210 |
2336229 | 2336229 | 2022-03-23 | Cottle | Texas | 48101 | 281 | 9 |
2336230 | 2336230 | 2022-03-23 | Crane | Texas | 48103 | 1270 | 24 |
2336231 | 2336231 | 2022-03-23 | Crockett | Texas | 48105 | 1020 | 19 |
2336232 | 2336232 | 2022-03-23 | Crosby | Texas | 48107 | 1869 | 45 |
2336233 | 2336233 | 2022-03-23 | Culberson | Texas | 48109 | 509 | 14 |
2336234 | 2336234 | 2022-03-23 | Dallam | Texas | 48111 | 2148 | 40 |
2336235 | 2336235 | 2022-03-23 | Dallas | Texas | 48113 | 568019 | 6673 |
2336236 | 2336236 | 2022-03-23 | Dawson | Texas | 48115 | 2800 | 93 |
2336237 | 2336237 | 2022-03-23 | DeWitt | Texas | 48123 | 6444 | 98 |
2336238 | 2336238 | 2022-03-23 | Deaf Smith | Texas | 48117 | 4784 | 111 |
2336239 | 2336239 | 2022-03-23 | Delta | Texas | 48119 | 1800 | 25 |
2336240 | 2336240 | 2022-03-23 | Denton | Texas | 48121 | 178681 | 1340 |
2336241 | 2336241 | 2022-03-23 | Dickens | Texas | 48125 | 445 | 16 |
2336242 | 2336242 | 2022-03-23 | Dimmit | Texas | 48127 | 5742 | 51 |
2336243 | 2336243 | 2022-03-23 | Donley | Texas | 48129 | 1139 | 26 |
2336244 | 2336244 | 2022-03-23 | Duval | Texas | 48131 | 3328 | 69 |
2336245 | 2336245 | 2022-03-23 | Eastland | Texas | 48133 | 2789 | 113 |
2336246 | 2336246 | 2022-03-23 | Ector | Texas | 48135 | 37243 | 693 |
2336247 | 2336247 | 2022-03-23 | Edwards | Texas | 48137 | 465 | 11 |
2336248 | 2336248 | 2022-03-23 | El Paso | Texas | 48141 | 206955 | 3698 |
2336249 | 2336249 | 2022-03-23 | Ellis | Texas | 48139 | 48617 | 575 |
2336250 | 2336250 | 2022-03-23 | Erath | Texas | 48143 | 8653 | 123 |
2336251 | 2336251 | 2022-03-23 | Falls | Texas | 48145 | 3754 | 63 |
2336252 | 2336252 | 2022-03-23 | Fannin | Texas | 48147 | 6820 | 183 |
2336253 | 2336253 | 2022-03-23 | Fayette | Texas | 48149 | 4755 | 104 |
2336254 | 2336254 | 2022-03-23 | Fisher | Texas | 48151 | 606 | 24 |
2336255 | 2336255 | 2022-03-23 | Floyd | Texas | 48153 | 1944 | 48 |
2336256 | 2336256 | 2022-03-23 | Foard | Texas | 48155 | 199 | 11 |
2336257 | 2336257 | 2022-03-23 | Fort Bend | Texas | 48157 | 179955 | 1214 |
2336258 | 2336258 | 2022-03-23 | Franklin | Texas | 48159 | 2165 | 42 |
2336259 | 2336259 | 2022-03-23 | Freestone | Texas | 48161 | 3854 | 82 |
2336260 | 2336260 | 2022-03-23 | Frio | Texas | 48163 | 5756 | 93 |
2336261 | 2336261 | 2022-03-23 | Gaines | Texas | 48165 | 2024 | 83 |
2336262 | 2336262 | 2022-03-23 | Galveston | Texas | 48167 | 95250 | 841 |
2336263 | 2336263 | 2022-03-23 | Garza | Texas | 48169 | 1262 | 27 |
2336264 | 2336264 | 2022-03-23 | Gillespie | Texas | 48171 | 5329 | 107 |
2336265 | 2336265 | 2022-03-23 | Glasscock | Texas | 48173 | 198 | 3 |
2336266 | 2336266 | 2022-03-23 | Goliad | Texas | 48175 | 1197 | 32 |
2336267 | 2336267 | 2022-03-23 | Gonzales | Texas | 48177 | 4714 | 97 |
2336268 | 2336268 | 2022-03-23 | Gray | Texas | 48179 | 6165 | 124 |
2336269 | 2336269 | 2022-03-23 | Grayson | Texas | 48181 | 27066 | 621 |
2336270 | 2336270 | 2022-03-23 | Gregg | Texas | 48183 | 23092 | 671 |
2336271 | 2336271 | 2022-03-23 | Grimes | Texas | 48185 | 8444 | 119 |
2336272 | 2336272 | 2022-03-23 | Guadalupe | Texas | 48187 | 37854 | 397 |
2336273 | 2336273 | 2022-03-23 | Hale | Texas | 48189 | 6535 | 244 |
2336274 | 2336274 | 2022-03-23 | Hall | Texas | 48191 | 1088 | 23 |
2336275 | 2336275 | 2022-03-23 | Hamilton | Texas | 48193 | 1959 | 32 |
2336276 | 2336276 | 2022-03-23 | Hansford | Texas | 48195 | 1919 | 29 |
2336277 | 2336277 | 2022-03-23 | Hardeman | Texas | 48197 | 555 | 19 |
2336278 | 2336278 | 2022-03-23 | Hardin | Texas | 48199 | 12015 | 248 |
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);