ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
119 rows where "date" is on date 2020-03-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 |
---|---|---|---|---|---|---|---|
19308 | 19308 | 2020-03-29 | Angelina | Texas | 48005 | 3 | 0 |
19309 | 19309 | 2020-03-29 | Atascosa | Texas | 48013 | 2 | 0 |
19310 | 19310 | 2020-03-29 | Austin | Texas | 48015 | 2 | 0 |
19311 | 19311 | 2020-03-29 | Bastrop | Texas | 48021 | 5 | 0 |
19312 | 19312 | 2020-03-29 | Bell | Texas | 48027 | 28 | 1 |
19313 | 19313 | 2020-03-29 | Bexar | Texas | 48029 | 140 | 5 |
19314 | 19314 | 2020-03-29 | Blanco | Texas | 48031 | 1 | 0 |
19315 | 19315 | 2020-03-29 | Bowie | Texas | 48037 | 3 | 0 |
19316 | 19316 | 2020-03-29 | Brazoria | Texas | 48039 | 61 | 0 |
19317 | 19317 | 2020-03-29 | Brazos | Texas | 48041 | 44 | 2 |
19318 | 19318 | 2020-03-29 | Brown | Texas | 48049 | 3 | 0 |
19319 | 19319 | 2020-03-29 | Burleson | Texas | 48051 | 1 | 0 |
19320 | 19320 | 2020-03-29 | Burnet | Texas | 48053 | 1 | 0 |
19321 | 19321 | 2020-03-29 | Caldwell | Texas | 48055 | 1 | 0 |
19322 | 19322 | 2020-03-29 | Calhoun | Texas | 48057 | 3 | 0 |
19323 | 19323 | 2020-03-29 | Cameron | Texas | 48061 | 20 | 0 |
19324 | 19324 | 2020-03-29 | Cass | Texas | 48067 | 2 | 0 |
19325 | 19325 | 2020-03-29 | Castro | Texas | 48069 | 8 | 0 |
19326 | 19326 | 2020-03-29 | Chambers | Texas | 48071 | 3 | 0 |
19327 | 19327 | 2020-03-29 | Cherokee | Texas | 48073 | 2 | 0 |
19328 | 19328 | 2020-03-29 | Collin | Texas | 48085 | 134 | 1 |
19329 | 19329 | 2020-03-29 | Comal | Texas | 48091 | 9 | 1 |
19330 | 19330 | 2020-03-29 | Coryell | Texas | 48099 | 1 | 0 |
19331 | 19331 | 2020-03-29 | Crane | Texas | 48103 | 1 | 0 |
19332 | 19332 | 2020-03-29 | Dallas | Texas | 48113 | 443 | 9 |
19333 | 19333 | 2020-03-29 | Dawson | Texas | 48115 | 1 | 0 |
19334 | 19334 | 2020-03-29 | DeWitt | Texas | 48123 | 3 | 0 |
19335 | 19335 | 2020-03-29 | Deaf Smith | Texas | 48117 | 2 | 0 |
19336 | 19336 | 2020-03-29 | Denton | Texas | 48121 | 165 | 2 |
19337 | 19337 | 2020-03-29 | Eastland | Texas | 48133 | 3 | 0 |
19338 | 19338 | 2020-03-29 | Ector | Texas | 48135 | 3 | 0 |
19339 | 19339 | 2020-03-29 | El Paso | Texas | 48141 | 40 | 0 |
19340 | 19340 | 2020-03-29 | Ellis | Texas | 48139 | 15 | 0 |
19341 | 19341 | 2020-03-29 | Erath | Texas | 48143 | 1 | 0 |
19342 | 19342 | 2020-03-29 | Falls | Texas | 48145 | 1 | 0 |
19343 | 19343 | 2020-03-29 | Fannin | Texas | 48147 | 1 | 0 |
19344 | 19344 | 2020-03-29 | Fayette | Texas | 48149 | 1 | 0 |
19345 | 19345 | 2020-03-29 | Fort Bend | Texas | 48157 | 119 | 1 |
19346 | 19346 | 2020-03-29 | Franklin | Texas | 48159 | 1 | 0 |
19347 | 19347 | 2020-03-29 | Gaines | Texas | 48165 | 1 | 0 |
19348 | 19348 | 2020-03-29 | Galveston | Texas | 48167 | 70 | 0 |
19349 | 19349 | 2020-03-29 | Grayson | Texas | 48181 | 3 | 0 |
19350 | 19350 | 2020-03-29 | Gregg | Texas | 48183 | 4 | 0 |
19351 | 19351 | 2020-03-29 | Grimes | Texas | 48185 | 2 | 0 |
19352 | 19352 | 2020-03-29 | Guadalupe | Texas | 48187 | 10 | 0 |
19353 | 19353 | 2020-03-29 | Hale | Texas | 48189 | 1 | 0 |
19354 | 19354 | 2020-03-29 | Hardin | Texas | 48199 | 9 | 1 |
19355 | 19355 | 2020-03-29 | Harris | Texas | 48201 | 526 | 4 |
19356 | 19356 | 2020-03-29 | Harrison | Texas | 48203 | 1 | 0 |
19357 | 19357 | 2020-03-29 | Hays | Texas | 48209 | 13 | 0 |
19358 | 19358 | 2020-03-29 | Henderson | Texas | 48213 | 1 | 0 |
19359 | 19359 | 2020-03-29 | Hidalgo | Texas | 48215 | 27 | 0 |
19360 | 19360 | 2020-03-29 | Hockley | Texas | 48219 | 7 | 0 |
19361 | 19361 | 2020-03-29 | Hood | Texas | 48221 | 2 | 0 |
19362 | 19362 | 2020-03-29 | Hopkins | Texas | 48223 | 1 | 0 |
19363 | 19363 | 2020-03-29 | Hunt | Texas | 48231 | 1 | 0 |
19364 | 19364 | 2020-03-29 | Jackson | Texas | 48239 | 1 | 0 |
19365 | 19365 | 2020-03-29 | Jefferson | Texas | 48245 | 16 | 0 |
19366 | 19366 | 2020-03-29 | Johnson | Texas | 48251 | 8 | 0 |
19367 | 19367 | 2020-03-29 | Karnes | Texas | 48255 | 2 | 0 |
19368 | 19368 | 2020-03-29 | Kaufman | Texas | 48257 | 2 | 0 |
19369 | 19369 | 2020-03-29 | Kendall | Texas | 48259 | 7 | 0 |
19370 | 19370 | 2020-03-29 | Kleberg | Texas | 48273 | 1 | 0 |
19371 | 19371 | 2020-03-29 | Lamar | Texas | 48277 | 3 | 0 |
19372 | 19372 | 2020-03-29 | Lamb | Texas | 48279 | 1 | 0 |
19373 | 19373 | 2020-03-29 | Lavaca | Texas | 48285 | 1 | 0 |
19374 | 19374 | 2020-03-29 | Liberty | Texas | 48291 | 2 | 0 |
19375 | 19375 | 2020-03-29 | Limestone | Texas | 48293 | 1 | 0 |
19376 | 19376 | 2020-03-29 | Llano | Texas | 48299 | 2 | 0 |
19377 | 19377 | 2020-03-29 | Lubbock | Texas | 48303 | 41 | 0 |
19378 | 19378 | 2020-03-29 | Lynn | Texas | 48305 | 1 | 0 |
19379 | 19379 | 2020-03-29 | Martin | Texas | 48317 | 1 | 0 |
19380 | 19380 | 2020-03-29 | Matagorda | Texas | 48321 | 12 | 1 |
19381 | 19381 | 2020-03-29 | Maverick | Texas | 48323 | 1 | 0 |
19382 | 19382 | 2020-03-29 | McLennan | Texas | 48309 | 36 | 0 |
19383 | 19383 | 2020-03-29 | Medina | Texas | 48325 | 3 | 0 |
19384 | 19384 | 2020-03-29 | Midland | Texas | 48329 | 11 | 1 |
19385 | 19385 | 2020-03-29 | Milam | Texas | 48331 | 2 | 0 |
19386 | 19386 | 2020-03-29 | Montague | Texas | 48337 | 1 | 0 |
19387 | 19387 | 2020-03-29 | Montgomery | Texas | 48339 | 64 | 0 |
19388 | 19388 | 2020-03-29 | Morris | Texas | 48343 | 1 | 0 |
19389 | 19389 | 2020-03-29 | Nacogdoches | Texas | 48347 | 2 | 0 |
19390 | 19390 | 2020-03-29 | Navarro | Texas | 48349 | 1 | 0 |
19391 | 19391 | 2020-03-29 | Nueces | Texas | 48355 | 21 | 0 |
19392 | 19392 | 2020-03-29 | Oldham | Texas | 48359 | 2 | 1 |
19393 | 19393 | 2020-03-29 | Orange | Texas | 48361 | 1 | 0 |
19394 | 19394 | 2020-03-29 | Parker | Texas | 48367 | 4 | 0 |
19395 | 19395 | 2020-03-29 | Polk | Texas | 48373 | 1 | 0 |
19396 | 19396 | 2020-03-29 | Potter | Texas | 48375 | 4 | 0 |
19397 | 19397 | 2020-03-29 | Randall | Texas | 48381 | 3 | 0 |
19398 | 19398 | 2020-03-29 | Robertson | Texas | 48395 | 2 | 0 |
19399 | 19399 | 2020-03-29 | Rockwall | Texas | 48397 | 4 | 0 |
19400 | 19400 | 2020-03-29 | Rusk | Texas | 48401 | 3 | 0 |
19401 | 19401 | 2020-03-29 | San Jacinto | Texas | 48407 | 1 | 0 |
19402 | 19402 | 2020-03-29 | San Patricio | Texas | 48409 | 1 | 0 |
19403 | 19403 | 2020-03-29 | Shelby | Texas | 48419 | 1 | 0 |
19404 | 19404 | 2020-03-29 | Smith | Texas | 48423 | 31 | 1 |
19405 | 19405 | 2020-03-29 | Starr | Texas | 48427 | 2 | 0 |
19406 | 19406 | 2020-03-29 | Swisher | Texas | 48437 | 1 | 0 |
19407 | 19407 | 2020-03-29 | Tarrant | Texas | 48439 | 139 | 1 |
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);