ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
230 rows where date = "2020-05-29" 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 |
---|---|---|---|---|---|---|---|
190124 | 190124 | 2020-05-29 | Anderson | Texas | 48001 | 72 | 0 |
190125 | 190125 | 2020-05-29 | Andrews | Texas | 48003 | 27 | 0 |
190126 | 190126 | 2020-05-29 | Angelina | Texas | 48005 | 203 | 4 |
190127 | 190127 | 2020-05-29 | Aransas | Texas | 48007 | 5 | 0 |
190128 | 190128 | 2020-05-29 | Archer | Texas | 48009 | 1 | 0 |
190129 | 190129 | 2020-05-29 | Armstrong | Texas | 48011 | 3 | 0 |
190130 | 190130 | 2020-05-29 | Atascosa | Texas | 48013 | 36 | 2 |
190131 | 190131 | 2020-05-29 | Austin | Texas | 48015 | 25 | 0 |
190132 | 190132 | 2020-05-29 | Bailey | Texas | 48017 | 16 | 0 |
190133 | 190133 | 2020-05-29 | Bandera | Texas | 48019 | 6 | 0 |
190134 | 190134 | 2020-05-29 | Bastrop | Texas | 48021 | 200 | 3 |
190135 | 190135 | 2020-05-29 | Bee | Texas | 48025 | 9 | 0 |
190136 | 190136 | 2020-05-29 | Bell | Texas | 48027 | 345 | 3 |
190137 | 190137 | 2020-05-29 | Bexar | Texas | 48029 | 2648 | 72 |
190138 | 190138 | 2020-05-29 | Blanco | Texas | 48031 | 9 | 0 |
190139 | 190139 | 2020-05-29 | Bosque | Texas | 48035 | 6 | 0 |
190140 | 190140 | 2020-05-29 | Bowie | Texas | 48037 | 191 | 12 |
190141 | 190141 | 2020-05-29 | Brazoria | Texas | 48039 | 894 | 12 |
190142 | 190142 | 2020-05-29 | Brazos | Texas | 48041 | 470 | 19 |
190143 | 190143 | 2020-05-29 | Brewster | Texas | 48043 | 1 | 0 |
190144 | 190144 | 2020-05-29 | Briscoe | Texas | 48045 | 1 | 0 |
190145 | 190145 | 2020-05-29 | Brooks | Texas | 48047 | 1 | 0 |
190146 | 190146 | 2020-05-29 | Brown | Texas | 48049 | 58 | 9 |
190147 | 190147 | 2020-05-29 | Burleson | Texas | 48051 | 24 | 0 |
190148 | 190148 | 2020-05-29 | Burnet | Texas | 48053 | 35 | 0 |
190149 | 190149 | 2020-05-29 | Caldwell | Texas | 48055 | 63 | 0 |
190150 | 190150 | 2020-05-29 | Calhoun | Texas | 48057 | 37 | 3 |
190151 | 190151 | 2020-05-29 | Callahan | Texas | 48059 | 9 | 1 |
190152 | 190152 | 2020-05-29 | Cameron | Texas | 48061 | 743 | 35 |
190153 | 190153 | 2020-05-29 | Camp | Texas | 48063 | 81 | 0 |
190154 | 190154 | 2020-05-29 | Carson | Texas | 48065 | 6 | 0 |
190155 | 190155 | 2020-05-29 | Cass | Texas | 48067 | 29 | 0 |
190156 | 190156 | 2020-05-29 | Castro | Texas | 48069 | 32 | 1 |
190157 | 190157 | 2020-05-29 | Chambers | Texas | 48071 | 67 | 0 |
190158 | 190158 | 2020-05-29 | Cherokee | Texas | 48073 | 44 | 2 |
190159 | 190159 | 2020-05-29 | Childress | Texas | 48075 | 2 | 0 |
190160 | 190160 | 2020-05-29 | Clay | Texas | 48077 | 3 | 0 |
190161 | 190161 | 2020-05-29 | Cochran | Texas | 48079 | 1 | 0 |
190162 | 190162 | 2020-05-29 | Coke | Texas | 48081 | 1 | 0 |
190163 | 190163 | 2020-05-29 | Coleman | Texas | 48083 | 3 | 0 |
190164 | 190164 | 2020-05-29 | Collin | Texas | 48085 | 1278 | 34 |
190165 | 190165 | 2020-05-29 | Collingsworth | Texas | 48087 | 5 | 0 |
190166 | 190166 | 2020-05-29 | Colorado | Texas | 48089 | 22 | 0 |
190167 | 190167 | 2020-05-29 | Comal | Texas | 48091 | 94 | 7 |
190168 | 190168 | 2020-05-29 | Comanche | Texas | 48093 | 11 | 1 |
190169 | 190169 | 2020-05-29 | Concho | Texas | 48095 | 1 | 0 |
190170 | 190170 | 2020-05-29 | Cooke | Texas | 48097 | 14 | 0 |
190171 | 190171 | 2020-05-29 | Coryell | Texas | 48099 | 230 | 2 |
190172 | 190172 | 2020-05-29 | Cottle | Texas | 48101 | 4 | 1 |
190173 | 190173 | 2020-05-29 | Crane | Texas | 48103 | 22 | 2 |
190174 | 190174 | 2020-05-29 | Crosby | Texas | 48107 | 3 | 1 |
190175 | 190175 | 2020-05-29 | Dallam | Texas | 48111 | 25 | 0 |
190176 | 190176 | 2020-05-29 | Dallas | Texas | 48113 | 9787 | 223 |
190177 | 190177 | 2020-05-29 | Dawson | Texas | 48115 | 41 | 1 |
190178 | 190178 | 2020-05-29 | DeWitt | Texas | 48123 | 17 | 1 |
190179 | 190179 | 2020-05-29 | Deaf Smith | Texas | 48117 | 162 | 13 |
190180 | 190180 | 2020-05-29 | Delta | Texas | 48119 | 1 | 0 |
190181 | 190181 | 2020-05-29 | Denton | Texas | 48121 | 1329 | 30 |
190182 | 190182 | 2020-05-29 | Dickens | Texas | 48125 | 1 | 0 |
190183 | 190183 | 2020-05-29 | Dimmit | Texas | 48127 | 1 | 0 |
190184 | 190184 | 2020-05-29 | Donley | Texas | 48129 | 26 | 0 |
190185 | 190185 | 2020-05-29 | Duval | Texas | 48131 | 5 | 0 |
190186 | 190186 | 2020-05-29 | Eastland | Texas | 48133 | 6 | 0 |
190187 | 190187 | 2020-05-29 | Ector | Texas | 48135 | 160 | 5 |
190188 | 190188 | 2020-05-29 | El Paso | Texas | 48141 | 2623 | 77 |
190189 | 190189 | 2020-05-29 | Ellis | Texas | 48139 | 309 | 14 |
190190 | 190190 | 2020-05-29 | Erath | Texas | 48143 | 16 | 1 |
190191 | 190191 | 2020-05-29 | Falls | Texas | 48145 | 6 | 0 |
190192 | 190192 | 2020-05-29 | Fannin | Texas | 48147 | 38 | 2 |
190193 | 190193 | 2020-05-29 | Fayette | Texas | 48149 | 34 | 2 |
190194 | 190194 | 2020-05-29 | Fisher | Texas | 48151 | 2 | 1 |
190195 | 190195 | 2020-05-29 | Floyd | Texas | 48153 | 11 | 0 |
190196 | 190196 | 2020-05-29 | Fort Bend | Texas | 48157 | 1832 | 41 |
190197 | 190197 | 2020-05-29 | Franklin | Texas | 48159 | 13 | 0 |
190198 | 190198 | 2020-05-29 | Freestone | Texas | 48161 | 10 | 0 |
190199 | 190199 | 2020-05-29 | Frio | Texas | 48163 | 37 | 0 |
190200 | 190200 | 2020-05-29 | Gaines | Texas | 48165 | 7 | 0 |
190201 | 190201 | 2020-05-29 | Galveston | Texas | 48167 | 795 | 32 |
190202 | 190202 | 2020-05-29 | Garza | Texas | 48169 | 5 | 0 |
190203 | 190203 | 2020-05-29 | Gillespie | Texas | 48171 | 5 | 0 |
190204 | 190204 | 2020-05-29 | Glasscock | Texas | 48173 | 1 | 0 |
190205 | 190205 | 2020-05-29 | Goliad | Texas | 48175 | 7 | 0 |
190206 | 190206 | 2020-05-29 | Gonzales | Texas | 48177 | 118 | 2 |
190207 | 190207 | 2020-05-29 | Gray | Texas | 48179 | 96 | 2 |
190208 | 190208 | 2020-05-29 | Grayson | Texas | 48181 | 323 | 2 |
190209 | 190209 | 2020-05-29 | Gregg | Texas | 48183 | 249 | 6 |
190210 | 190210 | 2020-05-29 | Grimes | Texas | 48185 | 114 | 1 |
190211 | 190211 | 2020-05-29 | Guadalupe | Texas | 48187 | 129 | 0 |
190212 | 190212 | 2020-05-29 | Hale | Texas | 48189 | 57 | 4 |
190213 | 190213 | 2020-05-29 | Hall | Texas | 48191 | 2 | 0 |
190214 | 190214 | 2020-05-29 | Hamilton | Texas | 48193 | 7 | 1 |
190215 | 190215 | 2020-05-29 | Hansford | Texas | 48195 | 18 | 2 |
190216 | 190216 | 2020-05-29 | Hardeman | Texas | 48197 | 1 | 0 |
190217 | 190217 | 2020-05-29 | Hardin | Texas | 48199 | 138 | 5 |
190218 | 190218 | 2020-05-29 | Harris | Texas | 48201 | 12009 | 228 |
190219 | 190219 | 2020-05-29 | Harrison | Texas | 48203 | 239 | 24 |
190220 | 190220 | 2020-05-29 | Hartley | Texas | 48205 | 11 | 2 |
190221 | 190221 | 2020-05-29 | Haskell | Texas | 48207 | 3 | 0 |
190222 | 190222 | 2020-05-29 | Hays | Texas | 48209 | 329 | 4 |
190223 | 190223 | 2020-05-29 | Hemphill | Texas | 48211 | 1 | 0 |
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);