ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
123 rows where date = "2020-03-30" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
21367 | 21367 | 2020-03-30 | Angelina | Texas | 48005 | 3 | 0 |
21368 | 21368 | 2020-03-30 | Atascosa | Texas | 48013 | 2 | 0 |
21369 | 21369 | 2020-03-30 | Austin | Texas | 48015 | 2 | 0 |
21370 | 21370 | 2020-03-30 | Bastrop | Texas | 48021 | 6 | 0 |
21371 | 21371 | 2020-03-30 | Bell | Texas | 48027 | 28 | 1 |
21372 | 21372 | 2020-03-30 | Bexar | Texas | 48029 | 157 | 5 |
21373 | 21373 | 2020-03-30 | Blanco | Texas | 48031 | 1 | 0 |
21374 | 21374 | 2020-03-30 | Bowie | Texas | 48037 | 4 | 0 |
21375 | 21375 | 2020-03-30 | Brazoria | Texas | 48039 | 61 | 0 |
21376 | 21376 | 2020-03-30 | Brazos | Texas | 48041 | 44 | 2 |
21377 | 21377 | 2020-03-30 | Brown | Texas | 48049 | 3 | 0 |
21378 | 21378 | 2020-03-30 | Burleson | Texas | 48051 | 1 | 0 |
21379 | 21379 | 2020-03-30 | Burnet | Texas | 48053 | 2 | 0 |
21380 | 21380 | 2020-03-30 | Caldwell | Texas | 48055 | 1 | 0 |
21381 | 21381 | 2020-03-30 | Calhoun | Texas | 48057 | 3 | 0 |
21382 | 21382 | 2020-03-30 | Cameron | Texas | 48061 | 20 | 0 |
21383 | 21383 | 2020-03-30 | Cass | Texas | 48067 | 2 | 0 |
21384 | 21384 | 2020-03-30 | Castro | Texas | 48069 | 8 | 0 |
21385 | 21385 | 2020-03-30 | Chambers | Texas | 48071 | 5 | 0 |
21386 | 21386 | 2020-03-30 | Cherokee | Texas | 48073 | 2 | 0 |
21387 | 21387 | 2020-03-30 | Collin | Texas | 48085 | 160 | 1 |
21388 | 21388 | 2020-03-30 | Comal | Texas | 48091 | 9 | 2 |
21389 | 21389 | 2020-03-30 | Coryell | Texas | 48099 | 1 | 0 |
21390 | 21390 | 2020-03-30 | Crane | Texas | 48103 | 1 | 0 |
21391 | 21391 | 2020-03-30 | Dallas | Texas | 48113 | 549 | 11 |
21392 | 21392 | 2020-03-30 | Dawson | Texas | 48115 | 1 | 0 |
21393 | 21393 | 2020-03-30 | DeWitt | Texas | 48123 | 3 | 0 |
21394 | 21394 | 2020-03-30 | Deaf Smith | Texas | 48117 | 2 | 0 |
21395 | 21395 | 2020-03-30 | Denton | Texas | 48121 | 191 | 3 |
21396 | 21396 | 2020-03-30 | Eastland | Texas | 48133 | 3 | 0 |
21397 | 21397 | 2020-03-30 | Ector | Texas | 48135 | 3 | 0 |
21398 | 21398 | 2020-03-30 | El Paso | Texas | 48141 | 47 | 0 |
21399 | 21399 | 2020-03-30 | Ellis | Texas | 48139 | 16 | 1 |
21400 | 21400 | 2020-03-30 | Erath | Texas | 48143 | 1 | 0 |
21401 | 21401 | 2020-03-30 | Falls | Texas | 48145 | 1 | 0 |
21402 | 21402 | 2020-03-30 | Fannin | Texas | 48147 | 1 | 0 |
21403 | 21403 | 2020-03-30 | Fayette | Texas | 48149 | 2 | 0 |
21404 | 21404 | 2020-03-30 | Fort Bend | Texas | 48157 | 119 | 1 |
21405 | 21405 | 2020-03-30 | Franklin | Texas | 48159 | 1 | 0 |
21406 | 21406 | 2020-03-30 | Gaines | Texas | 48165 | 1 | 0 |
21407 | 21407 | 2020-03-30 | Galveston | Texas | 48167 | 92 | 0 |
21408 | 21408 | 2020-03-30 | Grayson | Texas | 48181 | 6 | 0 |
21409 | 21409 | 2020-03-30 | Gregg | Texas | 48183 | 5 | 0 |
21410 | 21410 | 2020-03-30 | Grimes | Texas | 48185 | 2 | 0 |
21411 | 21411 | 2020-03-30 | Guadalupe | Texas | 48187 | 13 | 0 |
21412 | 21412 | 2020-03-30 | Hale | Texas | 48189 | 1 | 0 |
21413 | 21413 | 2020-03-30 | Hardin | Texas | 48199 | 9 | 1 |
21414 | 21414 | 2020-03-30 | Harris | Texas | 48201 | 563 | 7 |
21415 | 21415 | 2020-03-30 | Harrison | Texas | 48203 | 1 | 0 |
21416 | 21416 | 2020-03-30 | Hays | Texas | 48209 | 16 | 0 |
21417 | 21417 | 2020-03-30 | Henderson | Texas | 48213 | 1 | 0 |
21418 | 21418 | 2020-03-30 | Hidalgo | Texas | 48215 | 28 | 0 |
21419 | 21419 | 2020-03-30 | Hill | Texas | 48217 | 1 | 0 |
21420 | 21420 | 2020-03-30 | Hockley | Texas | 48219 | 7 | 0 |
21421 | 21421 | 2020-03-30 | Hood | Texas | 48221 | 3 | 0 |
21422 | 21422 | 2020-03-30 | Hopkins | Texas | 48223 | 2 | 0 |
21423 | 21423 | 2020-03-30 | Hunt | Texas | 48231 | 3 | 0 |
21424 | 21424 | 2020-03-30 | Jackson | Texas | 48239 | 1 | 0 |
21425 | 21425 | 2020-03-30 | Jefferson | Texas | 48245 | 18 | 0 |
21426 | 21426 | 2020-03-30 | Johnson | Texas | 48251 | 8 | 0 |
21427 | 21427 | 2020-03-30 | Karnes | Texas | 48255 | 2 | 0 |
21428 | 21428 | 2020-03-30 | Kaufman | Texas | 48257 | 3 | 0 |
21429 | 21429 | 2020-03-30 | Kendall | Texas | 48259 | 7 | 0 |
21430 | 21430 | 2020-03-30 | Kleberg | Texas | 48273 | 1 | 0 |
21431 | 21431 | 2020-03-30 | Lamar | Texas | 48277 | 3 | 0 |
21432 | 21432 | 2020-03-30 | Lamb | Texas | 48279 | 1 | 0 |
21433 | 21433 | 2020-03-30 | Lavaca | Texas | 48285 | 1 | 0 |
21434 | 21434 | 2020-03-30 | Leon | Texas | 48289 | 1 | 0 |
21435 | 21435 | 2020-03-30 | Liberty | Texas | 48291 | 2 | 0 |
21436 | 21436 | 2020-03-30 | Limestone | Texas | 48293 | 2 | 0 |
21437 | 21437 | 2020-03-30 | Llano | Texas | 48299 | 3 | 0 |
21438 | 21438 | 2020-03-30 | Lubbock | Texas | 48303 | 51 | 1 |
21439 | 21439 | 2020-03-30 | Lynn | Texas | 48305 | 2 | 0 |
21440 | 21440 | 2020-03-30 | Martin | Texas | 48317 | 1 | 0 |
21441 | 21441 | 2020-03-30 | Matagorda | Texas | 48321 | 13 | 1 |
21442 | 21442 | 2020-03-30 | Maverick | Texas | 48323 | 1 | 0 |
21443 | 21443 | 2020-03-30 | McLennan | Texas | 48309 | 39 | 0 |
21444 | 21444 | 2020-03-30 | Medina | Texas | 48325 | 3 | 0 |
21445 | 21445 | 2020-03-30 | Midland | Texas | 48329 | 13 | 1 |
21446 | 21446 | 2020-03-30 | Milam | Texas | 48331 | 2 | 0 |
21447 | 21447 | 2020-03-30 | Montague | Texas | 48337 | 1 | 0 |
21448 | 21448 | 2020-03-30 | Montgomery | Texas | 48339 | 66 | 0 |
21449 | 21449 | 2020-03-30 | Moore | Texas | 48341 | 1 | 0 |
21450 | 21450 | 2020-03-30 | Morris | Texas | 48343 | 1 | 0 |
21451 | 21451 | 2020-03-30 | Nacogdoches | Texas | 48347 | 2 | 0 |
21452 | 21452 | 2020-03-30 | Navarro | Texas | 48349 | 3 | 0 |
21453 | 21453 | 2020-03-30 | Nueces | Texas | 48355 | 22 | 0 |
21454 | 21454 | 2020-03-30 | Oldham | Texas | 48359 | 2 | 1 |
21455 | 21455 | 2020-03-30 | Orange | Texas | 48361 | 5 | 0 |
21456 | 21456 | 2020-03-30 | Parker | Texas | 48367 | 4 | 0 |
21457 | 21457 | 2020-03-30 | Polk | Texas | 48373 | 1 | 0 |
21458 | 21458 | 2020-03-30 | Potter | Texas | 48375 | 5 | 0 |
21459 | 21459 | 2020-03-30 | Randall | Texas | 48381 | 6 | 0 |
21460 | 21460 | 2020-03-30 | Robertson | Texas | 48395 | 2 | 0 |
21461 | 21461 | 2020-03-30 | Rockwall | Texas | 48397 | 4 | 0 |
21462 | 21462 | 2020-03-30 | Rusk | Texas | 48401 | 3 | 0 |
21463 | 21463 | 2020-03-30 | San Jacinto | Texas | 48407 | 1 | 0 |
21464 | 21464 | 2020-03-30 | San Patricio | Texas | 48409 | 1 | 0 |
21465 | 21465 | 2020-03-30 | Shelby | Texas | 48419 | 2 | 0 |
21466 | 21466 | 2020-03-30 | Smith | Texas | 48423 | 32 | 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);