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-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 |
---|---|---|---|---|---|---|---|
2232112 | 2232112 | 2022-02-19 | Anderson | Texas | 48001 | 9462 | 226 |
2232113 | 2232113 | 2022-02-19 | Andrews | Texas | 48003 | 3782 | 70 |
2232114 | 2232114 | 2022-02-19 | Angelina | Texas | 48005 | 15203 | 462 |
2232115 | 2232115 | 2022-02-19 | Aransas | Texas | 48007 | 3955 | 76 |
2232116 | 2232116 | 2022-02-19 | Archer | Texas | 48009 | 2081 | 27 |
2232117 | 2232117 | 2022-02-19 | Armstrong | Texas | 48011 | 493 | 8 |
2232118 | 2232118 | 2022-02-19 | Atascosa | Texas | 48013 | 13093 | 224 |
2232119 | 2232119 | 2022-02-19 | Austin | Texas | 48015 | 5437 | 70 |
2232120 | 2232120 | 2022-02-19 | Bailey | Texas | 48017 | 1368 | 37 |
2232121 | 2232121 | 2022-02-19 | Bandera | Texas | 48019 | 3493 | 73 |
2232122 | 2232122 | 2022-02-19 | Bastrop | Texas | 48021 | 21495 | 221 |
2232123 | 2232123 | 2022-02-19 | Baylor | Texas | 48023 | 804 | 32 |
2232124 | 2232124 | 2022-02-19 | Bee | Texas | 48025 | 8064 | 149 |
2232125 | 2232125 | 2022-02-19 | Bell | Texas | 48027 | 65826 | 841 |
2232126 | 2232126 | 2022-02-19 | Bexar | Texas | 48029 | 540313 | 5809 |
2232127 | 2232127 | 2022-02-19 | Blanco | Texas | 48031 | 2476 | 32 |
2232128 | 2232128 | 2022-02-19 | Borden | Texas | 48033 | 94 | 2 |
2232129 | 2232129 | 2022-02-19 | Bosque | Texas | 48035 | 3975 | 67 |
2232130 | 2232130 | 2022-02-19 | Bowie | Texas | 48037 | 19271 | 392 |
2232131 | 2232131 | 2022-02-19 | Brazoria | Texas | 48039 | 92255 | 957 |
2232132 | 2232132 | 2022-02-19 | Brazos | Texas | 48041 | 59403 | 396 |
2232133 | 2232133 | 2022-02-19 | Brewster | Texas | 48043 | 1043 | 26 |
2232134 | 2232134 | 2022-02-19 | Briscoe | Texas | 48045 | 444 | 8 |
2232135 | 2232135 | 2022-02-19 | Brooks | Texas | 48047 | 1575 | 50 |
2232136 | 2232136 | 2022-02-19 | Brown | Texas | 48049 | 11317 | 231 |
2232137 | 2232137 | 2022-02-19 | Burleson | Texas | 48051 | 4919 | 65 |
2232138 | 2232138 | 2022-02-19 | Burnet | Texas | 48053 | 10599 | 154 |
2232139 | 2232139 | 2022-02-19 | Caldwell | Texas | 48055 | 13987 | 169 |
2232140 | 2232140 | 2022-02-19 | Calhoun | Texas | 48057 | 5588 | 46 |
2232141 | 2232141 | 2022-02-19 | Callahan | Texas | 48059 | 2754 | 71 |
2232142 | 2232142 | 2022-02-19 | Cameron | Texas | 48061 | 97560 | 2029 |
2232143 | 2232143 | 2022-02-19 | Camp | Texas | 48063 | 2732 | 71 |
2232144 | 2232144 | 2022-02-19 | Carson | Texas | 48065 | 1462 | 34 |
2232145 | 2232145 | 2022-02-19 | Cass | Texas | 48067 | 6875 | 181 |
2232146 | 2232146 | 2022-02-19 | Castro | Texas | 48069 | 2251 | 46 |
2232147 | 2232147 | 2022-02-19 | Chambers | Texas | 48071 | 11567 | 111 |
2232148 | 2232148 | 2022-02-19 | Cherokee | Texas | 48073 | 7887 | 244 |
2232149 | 2232149 | 2022-02-19 | Childress | Texas | 48075 | 2488 | 28 |
2232150 | 2232150 | 2022-02-19 | Clay | Texas | 48077 | 2028 | 31 |
2232151 | 2232151 | 2022-02-19 | Cochran | Texas | 48079 | 845 | 22 |
2232152 | 2232152 | 2022-02-19 | Coke | Texas | 48081 | 828 | 19 |
2232153 | 2232153 | 2022-02-19 | Coleman | Texas | 48083 | 1572 | 68 |
2232154 | 2232154 | 2022-02-19 | Collin | Texas | 48085 | 202006 | 1408 |
2232155 | 2232155 | 2022-02-19 | Collingsworth | Texas | 48087 | 673 | 16 |
2232156 | 2232156 | 2022-02-19 | Colorado | Texas | 48089 | 3633 | 58 |
2232157 | 2232157 | 2022-02-19 | Comal | Texas | 48091 | 31653 | 521 |
2232158 | 2232158 | 2022-02-19 | Comanche | Texas | 48093 | 3120 | 75 |
2232159 | 2232159 | 2022-02-19 | Concho | Texas | 48095 | 1019 | 11 |
2232160 | 2232160 | 2022-02-19 | Cooke | Texas | 48097 | 7099 | 126 |
2232161 | 2232161 | 2022-02-19 | Coryell | Texas | 48099 | 17030 | 194 |
2232162 | 2232162 | 2022-02-19 | Cottle | Texas | 48101 | 275 | 9 |
2232163 | 2232163 | 2022-02-19 | Crane | Texas | 48103 | 1262 | 24 |
2232164 | 2232164 | 2022-02-19 | Crockett | Texas | 48105 | 1018 | 18 |
2232165 | 2232165 | 2022-02-19 | Crosby | Texas | 48107 | 1823 | 45 |
2232166 | 2232166 | 2022-02-19 | Culberson | Texas | 48109 | 508 | 14 |
2232167 | 2232167 | 2022-02-19 | Dallam | Texas | 48111 | 2095 | 39 |
2232168 | 2232168 | 2022-02-19 | Dallas | Texas | 48113 | 562735 | 6376 |
2232169 | 2232169 | 2022-02-19 | Dawson | Texas | 48115 | 2665 | 93 |
2232170 | 2232170 | 2022-02-19 | DeWitt | Texas | 48123 | 6390 | 94 |
2232171 | 2232171 | 2022-02-19 | Deaf Smith | Texas | 48117 | 4359 | 107 |
2232172 | 2232172 | 2022-02-19 | Delta | Texas | 48119 | 1763 | 24 |
2232173 | 2232173 | 2022-02-19 | Denton | Texas | 48121 | 175015 | 1269 |
2232174 | 2232174 | 2022-02-19 | Dickens | Texas | 48125 | 416 | 16 |
2232175 | 2232175 | 2022-02-19 | Dimmit | Texas | 48127 | 5617 | 50 |
2232176 | 2232176 | 2022-02-19 | Donley | Texas | 48129 | 1028 | 24 |
2232177 | 2232177 | 2022-02-19 | Duval | Texas | 48131 | 3242 | 67 |
2232178 | 2232178 | 2022-02-19 | Eastland | Texas | 48133 | 2737 | 105 |
2232179 | 2232179 | 2022-02-19 | Ector | Texas | 48135 | 36778 | 664 |
2232180 | 2232180 | 2022-02-19 | Edwards | Texas | 48137 | 458 | 10 |
2232181 | 2232181 | 2022-02-19 | El Paso | Texas | 48141 | 202438 | 3570 |
2232182 | 2232182 | 2022-02-19 | Ellis | Texas | 48139 | 47862 | 557 |
2232183 | 2232183 | 2022-02-19 | Erath | Texas | 48143 | 8431 | 117 |
2232184 | 2232184 | 2022-02-19 | Falls | Texas | 48145 | 3699 | 60 |
2232185 | 2232185 | 2022-02-19 | Fannin | Texas | 48147 | 6628 | 171 |
2232186 | 2232186 | 2022-02-19 | Fayette | Texas | 48149 | 4693 | 99 |
2232187 | 2232187 | 2022-02-19 | Fisher | Texas | 48151 | 600 | 22 |
2232188 | 2232188 | 2022-02-19 | Floyd | Texas | 48153 | 1884 | 47 |
2232189 | 2232189 | 2022-02-19 | Foard | Texas | 48155 | 198 | 11 |
2232190 | 2232190 | 2022-02-19 | Fort Bend | Texas | 48157 | 174809 | 1160 |
2232191 | 2232191 | 2022-02-19 | Franklin | Texas | 48159 | 2082 | 39 |
2232192 | 2232192 | 2022-02-19 | Freestone | Texas | 48161 | 3814 | 82 |
2232193 | 2232193 | 2022-02-19 | Frio | Texas | 48163 | 5483 | 86 |
2232194 | 2232194 | 2022-02-19 | Gaines | Texas | 48165 | 1851 | 80 |
2232195 | 2232195 | 2022-02-19 | Galveston | Texas | 48167 | 94282 | 818 |
2232196 | 2232196 | 2022-02-19 | Garza | Texas | 48169 | 1225 | 27 |
2232197 | 2232197 | 2022-02-19 | Gillespie | Texas | 48171 | 5175 | 104 |
2232198 | 2232198 | 2022-02-19 | Glasscock | Texas | 48173 | 197 | 3 |
2232199 | 2232199 | 2022-02-19 | Goliad | Texas | 48175 | 1156 | 31 |
2232200 | 2232200 | 2022-02-19 | Gonzales | Texas | 48177 | 4650 | 94 |
2232201 | 2232201 | 2022-02-19 | Gray | Texas | 48179 | 6019 | 122 |
2232202 | 2232202 | 2022-02-19 | Grayson | Texas | 48181 | 26925 | 599 |
2232203 | 2232203 | 2022-02-19 | Gregg | Texas | 48183 | 22914 | 643 |
2232204 | 2232204 | 2022-02-19 | Grimes | Texas | 48185 | 8373 | 116 |
2232205 | 2232205 | 2022-02-19 | Guadalupe | Texas | 48187 | 36412 | 377 |
2232206 | 2232206 | 2022-02-19 | Hale | Texas | 48189 | 6487 | 233 |
2232207 | 2232207 | 2022-02-19 | Hall | Texas | 48191 | 1029 | 21 |
2232208 | 2232208 | 2022-02-19 | Hamilton | Texas | 48193 | 1953 | 30 |
2232209 | 2232209 | 2022-02-19 | Hansford | Texas | 48195 | 1879 | 28 |
2232210 | 2232210 | 2022-02-19 | Hardeman | Texas | 48197 | 551 | 16 |
2232211 | 2232211 | 2022-02-19 | Hardin | Texas | 48199 | 11967 | 238 |
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);