ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
246 rows where "date" is on date 2020-07-03 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 |
---|---|---|---|---|---|---|---|
299088 | 299088 | 2020-07-03 | Anderson | Texas | 48001 | 1072 | 2 |
299089 | 299089 | 2020-07-03 | Andrews | Texas | 48003 | 90 | 0 |
299090 | 299090 | 2020-07-03 | Angelina | Texas | 48005 | 541 | 9 |
299091 | 299091 | 2020-07-03 | Aransas | Texas | 48007 | 31 | 0 |
299092 | 299092 | 2020-07-03 | Archer | Texas | 48009 | 8 | 0 |
299093 | 299093 | 2020-07-03 | Armstrong | Texas | 48011 | 3 | 0 |
299094 | 299094 | 2020-07-03 | Atascosa | Texas | 48013 | 116 | 2 |
299095 | 299095 | 2020-07-03 | Austin | Texas | 48015 | 88 | 0 |
299096 | 299096 | 2020-07-03 | Bailey | Texas | 48017 | 102 | 1 |
299097 | 299097 | 2020-07-03 | Bandera | Texas | 48019 | 23 | 0 |
299098 | 299098 | 2020-07-03 | Bastrop | Texas | 48021 | 457 | 6 |
299099 | 299099 | 2020-07-03 | Baylor | Texas | 48023 | 1 | 0 |
299100 | 299100 | 2020-07-03 | Bee | Texas | 48025 | 55 | 0 |
299101 | 299101 | 2020-07-03 | Bell | Texas | 48027 | 1480 | 13 |
299102 | 299102 | 2020-07-03 | Bexar | Texas | 48029 | 14224 | 117 |
299103 | 299103 | 2020-07-03 | Blanco | Texas | 48031 | 31 | 1 |
299104 | 299104 | 2020-07-03 | Bosque | Texas | 48035 | 16 | 0 |
299105 | 299105 | 2020-07-03 | Bowie | Texas | 48037 | 444 | 17 |
299106 | 299106 | 2020-07-03 | Brazoria | Texas | 48039 | 2516 | 22 |
299107 | 299107 | 2020-07-03 | Brazos | Texas | 48041 | 2331 | 31 |
299108 | 299108 | 2020-07-03 | Brewster | Texas | 48043 | 143 | 1 |
299109 | 299109 | 2020-07-03 | Briscoe | Texas | 48045 | 3 | 0 |
299110 | 299110 | 2020-07-03 | Brooks | Texas | 48047 | 6 | 0 |
299111 | 299111 | 2020-07-03 | Brown | Texas | 48049 | 87 | 11 |
299112 | 299112 | 2020-07-03 | Burleson | Texas | 48051 | 86 | 0 |
299113 | 299113 | 2020-07-03 | Burnet | Texas | 48053 | 143 | 3 |
299114 | 299114 | 2020-07-03 | Caldwell | Texas | 48055 | 383 | 2 |
299115 | 299115 | 2020-07-03 | Calhoun | Texas | 48057 | 96 | 3 |
299116 | 299116 | 2020-07-03 | Callahan | Texas | 48059 | 18 | 2 |
299117 | 299117 | 2020-07-03 | Cameron | Texas | 48061 | 2692 | 63 |
299118 | 299118 | 2020-07-03 | Camp | Texas | 48063 | 122 | 1 |
299119 | 299119 | 2020-07-03 | Carson | Texas | 48065 | 7 | 0 |
299120 | 299120 | 2020-07-03 | Cass | Texas | 48067 | 44 | 2 |
299121 | 299121 | 2020-07-03 | Castro | Texas | 48069 | 97 | 1 |
299122 | 299122 | 2020-07-03 | Chambers | Texas | 48071 | 352 | 2 |
299123 | 299123 | 2020-07-03 | Cherokee | Texas | 48073 | 188 | 2 |
299124 | 299124 | 2020-07-03 | Childress | Texas | 48075 | 7 | 0 |
299125 | 299125 | 2020-07-03 | Clay | Texas | 48077 | 9 | 0 |
299126 | 299126 | 2020-07-03 | Cochran | Texas | 48079 | 1 | 0 |
299127 | 299127 | 2020-07-03 | Coke | Texas | 48081 | 5 | 1 |
299128 | 299128 | 2020-07-03 | Coleman | Texas | 48083 | 3 | 0 |
299129 | 299129 | 2020-07-03 | Collin | Texas | 48085 | 3321 | 45 |
299130 | 299130 | 2020-07-03 | Collingsworth | Texas | 48087 | 6 | 0 |
299131 | 299131 | 2020-07-03 | Colorado | Texas | 48089 | 100 | 0 |
299132 | 299132 | 2020-07-03 | Comal | Texas | 48091 | 907 | 9 |
299133 | 299133 | 2020-07-03 | Comanche | Texas | 48093 | 21 | 1 |
299134 | 299134 | 2020-07-03 | Concho | Texas | 48095 | 9 | 0 |
299135 | 299135 | 2020-07-03 | Cooke | Texas | 48097 | 60 | 0 |
299136 | 299136 | 2020-07-03 | Coryell | Texas | 48099 | 336 | 2 |
299137 | 299137 | 2020-07-03 | Cottle | Texas | 48101 | 4 | 1 |
299138 | 299138 | 2020-07-03 | Crane | Texas | 48103 | 58 | 9 |
299139 | 299139 | 2020-07-03 | Crockett | Texas | 48105 | 13 | 0 |
299140 | 299140 | 2020-07-03 | Crosby | Texas | 48107 | 26 | 1 |
299141 | 299141 | 2020-07-03 | Culberson | Texas | 48109 | 3 | 0 |
299142 | 299142 | 2020-07-03 | Dallam | Texas | 48111 | 91 | 1 |
299143 | 299143 | 2020-07-03 | Dallas | Texas | 48113 | 23675 | 393 |
299144 | 299144 | 2020-07-03 | Dawson | Texas | 48115 | 59 | 1 |
299145 | 299145 | 2020-07-03 | DeWitt | Texas | 48123 | 96 | 1 |
299146 | 299146 | 2020-07-03 | Deaf Smith | Texas | 48117 | 337 | 17 |
299147 | 299147 | 2020-07-03 | Delta | Texas | 48119 | 7 | 0 |
299148 | 299148 | 2020-07-03 | Denton | Texas | 48121 | 3184 | 37 |
299149 | 299149 | 2020-07-03 | Dickens | Texas | 48125 | 2 | 0 |
299150 | 299150 | 2020-07-03 | Dimmit | Texas | 48127 | 13 | 0 |
299151 | 299151 | 2020-07-03 | Donley | Texas | 48129 | 27 | 0 |
299152 | 299152 | 2020-07-03 | Duval | Texas | 48131 | 54 | 0 |
299153 | 299153 | 2020-07-03 | Eastland | Texas | 48133 | 11 | 0 |
299154 | 299154 | 2020-07-03 | Ector | Texas | 48135 | 1092 | 9 |
299155 | 299155 | 2020-07-03 | Edwards | Texas | 48137 | 2 | 0 |
299156 | 299156 | 2020-07-03 | El Paso | Texas | 48141 | 6665 | 135 |
299157 | 299157 | 2020-07-03 | Ellis | Texas | 48139 | 978 | 19 |
299158 | 299158 | 2020-07-03 | Erath | Texas | 48143 | 133 | 1 |
299159 | 299159 | 2020-07-03 | Falls | Texas | 48145 | 31 | 0 |
299160 | 299160 | 2020-07-03 | Fannin | Texas | 48147 | 109 | 7 |
299161 | 299161 | 2020-07-03 | Fayette | Texas | 48149 | 96 | 2 |
299162 | 299162 | 2020-07-03 | Fisher | Texas | 48151 | 10 | 1 |
299163 | 299163 | 2020-07-03 | Floyd | Texas | 48153 | 34 | 0 |
299164 | 299164 | 2020-07-03 | Fort Bend | Texas | 48157 | 4120 | 56 |
299165 | 299165 | 2020-07-03 | Franklin | Texas | 48159 | 50 | 0 |
299166 | 299166 | 2020-07-03 | Freestone | Texas | 48161 | 33 | 0 |
299167 | 299167 | 2020-07-03 | Frio | Texas | 48163 | 225 | 0 |
299168 | 299168 | 2020-07-03 | Gaines | Texas | 48165 | 26 | 0 |
299169 | 299169 | 2020-07-03 | Galveston | Texas | 48167 | 3990 | 46 |
299170 | 299170 | 2020-07-03 | Garza | Texas | 48169 | 12 | 0 |
299171 | 299171 | 2020-07-03 | Gillespie | Texas | 48171 | 42 | 0 |
299172 | 299172 | 2020-07-03 | Glasscock | Texas | 48173 | 5 | 0 |
299173 | 299173 | 2020-07-03 | Goliad | Texas | 48175 | 15 | 0 |
299174 | 299174 | 2020-07-03 | Gonzales | Texas | 48177 | 301 | 4 |
299175 | 299175 | 2020-07-03 | Gray | Texas | 48179 | 119 | 4 |
299176 | 299176 | 2020-07-03 | Grayson | Texas | 48181 | 617 | 5 |
299177 | 299177 | 2020-07-03 | Gregg | Texas | 48183 | 417 | 14 |
299178 | 299178 | 2020-07-03 | Grimes | Texas | 48185 | 551 | 2 |
299179 | 299179 | 2020-07-03 | Guadalupe | Texas | 48187 | 768 | 2 |
299180 | 299180 | 2020-07-03 | Hale | Texas | 48189 | 427 | 7 |
299181 | 299181 | 2020-07-03 | Hall | Texas | 48191 | 2 | 1 |
299182 | 299182 | 2020-07-03 | Hamilton | Texas | 48193 | 21 | 1 |
299183 | 299183 | 2020-07-03 | Hansford | Texas | 48195 | 31 | 2 |
299184 | 299184 | 2020-07-03 | Hardeman | Texas | 48197 | 5 | 0 |
299185 | 299185 | 2020-07-03 | Hardin | Texas | 48199 | 260 | 5 |
299186 | 299186 | 2020-07-03 | Harris | Texas | 48201 | 35316 | 395 |
299187 | 299187 | 2020-07-03 | Harrison | Texas | 48203 | 327 | 30 |
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);