ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
85 rows where "date" is on date 2020-03-25 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12111 | 12111 | 2020-03-25 | Atascosa | Texas | 48013 | 2 | 0 |
12112 | 12112 | 2020-03-25 | Austin | Texas | 48015 | 1 | 0 |
12113 | 12113 | 2020-03-25 | Bastrop | Texas | 48021 | 1 | 0 |
12114 | 12114 | 2020-03-25 | Bell | Texas | 48027 | 18 | 0 |
12115 | 12115 | 2020-03-25 | Bexar | Texas | 48029 | 69 | 1 |
12116 | 12116 | 2020-03-25 | Blanco | Texas | 48031 | 1 | 0 |
12117 | 12117 | 2020-03-25 | Bowie | Texas | 48037 | 1 | 0 |
12118 | 12118 | 2020-03-25 | Brazoria | Texas | 48039 | 19 | 0 |
12119 | 12119 | 2020-03-25 | Brazos | Texas | 48041 | 16 | 0 |
12120 | 12120 | 2020-03-25 | Brown | Texas | 48049 | 2 | 0 |
12121 | 12121 | 2020-03-25 | Burnet | Texas | 48053 | 1 | 0 |
12122 | 12122 | 2020-03-25 | Cameron | Texas | 48061 | 6 | 0 |
12123 | 12123 | 2020-03-25 | Cass | Texas | 48067 | 1 | 0 |
12124 | 12124 | 2020-03-25 | Castro | Texas | 48069 | 3 | 0 |
12125 | 12125 | 2020-03-25 | Chambers | Texas | 48071 | 2 | 0 |
12126 | 12126 | 2020-03-25 | Collin | Texas | 48085 | 66 | 1 |
12127 | 12127 | 2020-03-25 | Comal | Texas | 48091 | 5 | 0 |
12128 | 12128 | 2020-03-25 | Coryell | Texas | 48099 | 1 | 0 |
12129 | 12129 | 2020-03-25 | Crane | Texas | 48103 | 1 | 0 |
12130 | 12130 | 2020-03-25 | Dallas | Texas | 48113 | 169 | 6 |
12131 | 12131 | 2020-03-25 | DeWitt | Texas | 48123 | 1 | 0 |
12132 | 12132 | 2020-03-25 | Deaf Smith | Texas | 48117 | 2 | 0 |
12133 | 12133 | 2020-03-25 | Denton | Texas | 48121 | 70 | 0 |
12134 | 12134 | 2020-03-25 | Eastland | Texas | 48133 | 2 | 0 |
12135 | 12135 | 2020-03-25 | El Paso | Texas | 48141 | 12 | 0 |
12136 | 12136 | 2020-03-25 | Ellis | Texas | 48139 | 6 | 0 |
12137 | 12137 | 2020-03-25 | Erath | Texas | 48143 | 1 | 0 |
12138 | 12138 | 2020-03-25 | Falls | Texas | 48145 | 1 | 0 |
12139 | 12139 | 2020-03-25 | Fannin | Texas | 48147 | 1 | 0 |
12140 | 12140 | 2020-03-25 | Fayette | Texas | 48149 | 1 | 0 |
12141 | 12141 | 2020-03-25 | Fort Bend | Texas | 48157 | 54 | 0 |
12142 | 12142 | 2020-03-25 | Gaines | Texas | 48165 | 1 | 0 |
12143 | 12143 | 2020-03-25 | Galveston | Texas | 48167 | 22 | 0 |
12144 | 12144 | 2020-03-25 | Grayson | Texas | 48181 | 2 | 0 |
12145 | 12145 | 2020-03-25 | Gregg | Texas | 48183 | 1 | 0 |
12146 | 12146 | 2020-03-25 | Grimes | Texas | 48185 | 2 | 0 |
12147 | 12147 | 2020-03-25 | Guadalupe | Texas | 48187 | 4 | 0 |
12148 | 12148 | 2020-03-25 | Hale | Texas | 48189 | 1 | 0 |
12149 | 12149 | 2020-03-25 | Hardin | Texas | 48199 | 2 | 0 |
12150 | 12150 | 2020-03-25 | Harris | Texas | 48201 | 185 | 1 |
12151 | 12151 | 2020-03-25 | Hays | Texas | 48209 | 7 | 0 |
12152 | 12152 | 2020-03-25 | Hidalgo | Texas | 48215 | 2 | 0 |
12153 | 12153 | 2020-03-25 | Hockley | Texas | 48219 | 3 | 0 |
12154 | 12154 | 2020-03-25 | Hopkins | Texas | 48223 | 1 | 0 |
12155 | 12155 | 2020-03-25 | Hunt | Texas | 48231 | 1 | 0 |
12156 | 12156 | 2020-03-25 | Jefferson | Texas | 48245 | 7 | 0 |
12157 | 12157 | 2020-03-25 | Johnson | Texas | 48251 | 3 | 0 |
12158 | 12158 | 2020-03-25 | Kaufman | Texas | 48257 | 2 | 0 |
12159 | 12159 | 2020-03-25 | Kendall | Texas | 48259 | 3 | 0 |
12160 | 12160 | 2020-03-25 | Lamar | Texas | 48277 | 1 | 0 |
12161 | 12161 | 2020-03-25 | Lavaca | Texas | 48285 | 1 | 0 |
12162 | 12162 | 2020-03-25 | Liberty | Texas | 48291 | 1 | 0 |
12163 | 12163 | 2020-03-25 | Limestone | Texas | 48293 | 1 | 0 |
12164 | 12164 | 2020-03-25 | Llano | Texas | 48299 | 1 | 0 |
12165 | 12165 | 2020-03-25 | Lubbock | Texas | 48303 | 12 | 0 |
12166 | 12166 | 2020-03-25 | Matagorda | Texas | 48321 | 6 | 1 |
12167 | 12167 | 2020-03-25 | Maverick | Texas | 48323 | 1 | 0 |
12168 | 12168 | 2020-03-25 | McLennan | Texas | 48309 | 23 | 0 |
12169 | 12169 | 2020-03-25 | Medina | Texas | 48325 | 1 | 0 |
12170 | 12170 | 2020-03-25 | Midland | Texas | 48329 | 3 | 1 |
12171 | 12171 | 2020-03-25 | Milam | Texas | 48331 | 2 | 0 |
12172 | 12172 | 2020-03-25 | Montgomery | Texas | 48339 | 23 | 0 |
12173 | 12173 | 2020-03-25 | Morris | Texas | 48343 | 1 | 0 |
12174 | 12174 | 2020-03-25 | Nueces | Texas | 48355 | 10 | 0 |
12175 | 12175 | 2020-03-25 | Oldham | Texas | 48359 | 1 | 1 |
12176 | 12176 | 2020-03-25 | Orange | Texas | 48361 | 1 | 0 |
12177 | 12177 | 2020-03-25 | Parker | Texas | 48367 | 1 | 0 |
12178 | 12178 | 2020-03-25 | Potter | Texas | 48375 | 2 | 0 |
12179 | 12179 | 2020-03-25 | Robertson | Texas | 48395 | 1 | 0 |
12180 | 12180 | 2020-03-25 | Rusk | Texas | 48401 | 1 | 0 |
12181 | 12181 | 2020-03-25 | San Patricio | Texas | 48409 | 1 | 0 |
12182 | 12182 | 2020-03-25 | Smith | Texas | 48423 | 14 | 0 |
12183 | 12183 | 2020-03-25 | Tarrant | Texas | 48439 | 71 | 1 |
12184 | 12184 | 2020-03-25 | Terry | Texas | 48445 | 1 | 0 |
12185 | 12185 | 2020-03-25 | Tom Green | Texas | 48451 | 1 | 0 |
12186 | 12186 | 2020-03-25 | Travis | Texas | 48453 | 119 | 0 |
12187 | 12187 | 2020-03-25 | Upshur | Texas | 48459 | 1 | 0 |
12188 | 12188 | 2020-03-25 | Van Zandt | Texas | 48467 | 1 | 0 |
12189 | 12189 | 2020-03-25 | Victoria | Texas | 48469 | 3 | 0 |
12190 | 12190 | 2020-03-25 | Walker | Texas | 48471 | 1 | 0 |
12191 | 12191 | 2020-03-25 | Webb | Texas | 48479 | 8 | 0 |
12192 | 12192 | 2020-03-25 | Wharton | Texas | 48481 | 3 | 0 |
12193 | 12193 | 2020-03-25 | Wichita | Texas | 48485 | 6 | 0 |
12194 | 12194 | 2020-03-25 | Williamson | Texas | 48491 | 22 | 0 |
12195 | 12195 | 2020-03-25 | Wilson | Texas | 48493 | 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);