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-02-07 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2193085 | 2193085 | 2022-02-07 | Anderson | Texas | 48001 | 9391 | 220 |
2193086 | 2193086 | 2022-02-07 | Andrews | Texas | 48003 | 3755 | 69 |
2193087 | 2193087 | 2022-02-07 | Angelina | Texas | 48005 | 15086 | 449 |
2193088 | 2193088 | 2022-02-07 | Aransas | Texas | 48007 | 3809 | 72 |
2193089 | 2193089 | 2022-02-07 | Archer | Texas | 48009 | 2050 | 25 |
2193090 | 2193090 | 2022-02-07 | Armstrong | Texas | 48011 | 481 | 8 |
2193091 | 2193091 | 2022-02-07 | Atascosa | Texas | 48013 | 12804 | 220 |
2193092 | 2193092 | 2022-02-07 | Austin | Texas | 48015 | 5314 | 64 |
2193093 | 2193093 | 2022-02-07 | Bailey | Texas | 48017 | 1348 | 33 |
2193094 | 2193094 | 2022-02-07 | Bandera | Texas | 48019 | 3410 | 70 |
2193095 | 2193095 | 2022-02-07 | Bastrop | Texas | 48021 | 21004 | 206 |
2193096 | 2193096 | 2022-02-07 | Baylor | Texas | 48023 | 788 | 28 |
2193097 | 2193097 | 2022-02-07 | Bee | Texas | 48025 | 7918 | 142 |
2193098 | 2193098 | 2022-02-07 | Bell | Texas | 48027 | 64913 | 794 |
2193099 | 2193099 | 2022-02-07 | Bexar | Texas | 48029 | 527675 | 5612 |
2193100 | 2193100 | 2022-02-07 | Blanco | Texas | 48031 | 2402 | 30 |
2193101 | 2193101 | 2022-02-07 | Borden | Texas | 48033 | 94 | 2 |
2193102 | 2193102 | 2022-02-07 | Bosque | Texas | 48035 | 3819 | 63 |
2193103 | 2193103 | 2022-02-07 | Bowie | Texas | 48037 | 18505 | 376 |
2193104 | 2193104 | 2022-02-07 | Brazoria | Texas | 48039 | 90772 | 928 |
2193105 | 2193105 | 2022-02-07 | Brazos | Texas | 48041 | 58349 | 382 |
2193106 | 2193106 | 2022-02-07 | Brewster | Texas | 48043 | 1016 | 25 |
2193107 | 2193107 | 2022-02-07 | Briscoe | Texas | 48045 | 427 | 8 |
2193108 | 2193108 | 2022-02-07 | Brooks | Texas | 48047 | 1520 | 49 |
2193109 | 2193109 | 2022-02-07 | Brown | Texas | 48049 | 11237 | 219 |
2193110 | 2193110 | 2022-02-07 | Burleson | Texas | 48051 | 4851 | 63 |
2193111 | 2193111 | 2022-02-07 | Burnet | Texas | 48053 | 10334 | 145 |
2193112 | 2193112 | 2022-02-07 | Caldwell | Texas | 48055 | 13687 | 167 |
2193113 | 2193113 | 2022-02-07 | Calhoun | Texas | 48057 | 5486 | 42 |
2193114 | 2193114 | 2022-02-07 | Callahan | Texas | 48059 | 2717 | 66 |
2193115 | 2193115 | 2022-02-07 | Cameron | Texas | 48061 | 94489 | 2029 |
2193116 | 2193116 | 2022-02-07 | Camp | Texas | 48063 | 2667 | 70 |
2193117 | 2193117 | 2022-02-07 | Carson | Texas | 48065 | 1416 | 31 |
2193118 | 2193118 | 2022-02-07 | Cass | Texas | 48067 | 6441 | 177 |
2193119 | 2193119 | 2022-02-07 | Castro | Texas | 48069 | 2215 | 46 |
2193120 | 2193120 | 2022-02-07 | Chambers | Texas | 48071 | 11430 | 106 |
2193121 | 2193121 | 2022-02-07 | Cherokee | Texas | 48073 | 7786 | 236 |
2193122 | 2193122 | 2022-02-07 | Childress | Texas | 48075 | 2326 | 27 |
2193123 | 2193123 | 2022-02-07 | Clay | Texas | 48077 | 2007 | 27 |
2193124 | 2193124 | 2022-02-07 | Cochran | Texas | 48079 | 822 | 21 |
2193125 | 2193125 | 2022-02-07 | Coke | Texas | 48081 | 816 | 18 |
2193126 | 2193126 | 2022-02-07 | Coleman | Texas | 48083 | 1556 | 65 |
2193127 | 2193127 | 2022-02-07 | Collin | Texas | 48085 | 197502 | 1346 |
2193128 | 2193128 | 2022-02-07 | Collingsworth | Texas | 48087 | 636 | 13 |
2193129 | 2193129 | 2022-02-07 | Colorado | Texas | 48089 | 3534 | 57 |
2193130 | 2193130 | 2022-02-07 | Comal | Texas | 48091 | 30872 | 504 |
2193131 | 2193131 | 2022-02-07 | Comanche | Texas | 48093 | 3085 | 75 |
2193132 | 2193132 | 2022-02-07 | Concho | Texas | 48095 | 1002 | 11 |
2193133 | 2193133 | 2022-02-07 | Cooke | Texas | 48097 | 7012 | 120 |
2193134 | 2193134 | 2022-02-07 | Coryell | Texas | 48099 | 16811 | 180 |
2193135 | 2193135 | 2022-02-07 | Cottle | Texas | 48101 | 275 | 9 |
2193136 | 2193136 | 2022-02-07 | Crane | Texas | 48103 | 1233 | 21 |
2193137 | 2193137 | 2022-02-07 | Crockett | Texas | 48105 | 1014 | 17 |
2193138 | 2193138 | 2022-02-07 | Crosby | Texas | 48107 | 1805 | 44 |
2193139 | 2193139 | 2022-02-07 | Culberson | Texas | 48109 | 502 | 13 |
2193140 | 2193140 | 2022-02-07 | Dallam | Texas | 48111 | 1986 | 36 |
2193141 | 2193141 | 2022-02-07 | Dallas | Texas | 48113 | 555210 | 6128 |
2193142 | 2193142 | 2022-02-07 | Dawson | Texas | 48115 | 2425 | 91 |
2193143 | 2193143 | 2022-02-07 | DeWitt | Texas | 48123 | 6321 | 87 |
2193144 | 2193144 | 2022-02-07 | Deaf Smith | Texas | 48117 | 4088 | 105 |
2193145 | 2193145 | 2022-02-07 | Delta | Texas | 48119 | 1741 | 24 |
2193146 | 2193146 | 2022-02-07 | Denton | Texas | 48121 | 168469 | 1209 |
2193147 | 2193147 | 2022-02-07 | Dickens | Texas | 48125 | 412 | 15 |
2193148 | 2193148 | 2022-02-07 | Dimmit | Texas | 48127 | 5474 | 50 |
2193149 | 2193149 | 2022-02-07 | Donley | Texas | 48129 | 956 | 22 |
2193150 | 2193150 | 2022-02-07 | Duval | Texas | 48131 | 3112 | 64 |
2193151 | 2193151 | 2022-02-07 | Eastland | Texas | 48133 | 2702 | 98 |
2193152 | 2193152 | 2022-02-07 | Ector | Texas | 48135 | 36434 | 625 |
2193153 | 2193153 | 2022-02-07 | Edwards | Texas | 48137 | 454 | 10 |
2193154 | 2193154 | 2022-02-07 | El Paso | Texas | 48141 | 199319 | 3448 |
2193155 | 2193155 | 2022-02-07 | Ellis | Texas | 48139 | 47185 | 524 |
2193156 | 2193156 | 2022-02-07 | Erath | Texas | 48143 | 8220 | 114 |
2193157 | 2193157 | 2022-02-07 | Falls | Texas | 48145 | 3638 | 57 |
2193158 | 2193158 | 2022-02-07 | Fannin | Texas | 48147 | 6513 | 166 |
2193159 | 2193159 | 2022-02-07 | Fayette | Texas | 48149 | 4581 | 98 |
2193160 | 2193160 | 2022-02-07 | Fisher | Texas | 48151 | 579 | 20 |
2193161 | 2193161 | 2022-02-07 | Floyd | Texas | 48153 | 1864 | 46 |
2193162 | 2193162 | 2022-02-07 | Foard | Texas | 48155 | 195 | 11 |
2193163 | 2193163 | 2022-02-07 | Fort Bend | Texas | 48157 | 169331 | 1122 |
2193164 | 2193164 | 2022-02-07 | Franklin | Texas | 48159 | 2020 | 37 |
2193165 | 2193165 | 2022-02-07 | Freestone | Texas | 48161 | 3767 | 80 |
2193166 | 2193166 | 2022-02-07 | Frio | Texas | 48163 | 5297 | 84 |
2193167 | 2193167 | 2022-02-07 | Gaines | Texas | 48165 | 1738 | 78 |
2193168 | 2193168 | 2022-02-07 | Galveston | Texas | 48167 | 92231 | 797 |
2193169 | 2193169 | 2022-02-07 | Garza | Texas | 48169 | 1211 | 26 |
2193170 | 2193170 | 2022-02-07 | Gillespie | Texas | 48171 | 5060 | 100 |
2193171 | 2193171 | 2022-02-07 | Glasscock | Texas | 48173 | 193 | 3 |
2193172 | 2193172 | 2022-02-07 | Goliad | Texas | 48175 | 1127 | 29 |
2193173 | 2193173 | 2022-02-07 | Gonzales | Texas | 48177 | 4620 | 92 |
2193174 | 2193174 | 2022-02-07 | Gray | Texas | 48179 | 5910 | 110 |
2193175 | 2193175 | 2022-02-07 | Grayson | Texas | 48181 | 26640 | 567 |
2193176 | 2193176 | 2022-02-07 | Gregg | Texas | 48183 | 22630 | 612 |
2193177 | 2193177 | 2022-02-07 | Grimes | Texas | 48185 | 8224 | 114 |
2193178 | 2193178 | 2022-02-07 | Guadalupe | Texas | 48187 | 35406 | 365 |
2193179 | 2193179 | 2022-02-07 | Hale | Texas | 48189 | 6409 | 225 |
2193180 | 2193180 | 2022-02-07 | Hall | Texas | 48191 | 924 | 20 |
2193181 | 2193181 | 2022-02-07 | Hamilton | Texas | 48193 | 1933 | 29 |
2193182 | 2193182 | 2022-02-07 | Hansford | Texas | 48195 | 1846 | 27 |
2193183 | 2193183 | 2022-02-07 | Hardeman | Texas | 48197 | 550 | 14 |
2193184 | 2193184 | 2022-02-07 | Hardin | Texas | 48199 | 11819 | 226 |
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);