ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
237 rows where "date" is on date 2020-06-13 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 |
---|---|---|---|---|---|---|---|
236428 | 236428 | 2020-06-13 | Anderson | Texas | 48001 | 102 | 0 |
236429 | 236429 | 2020-06-13 | Andrews | Texas | 48003 | 28 | 0 |
236430 | 236430 | 2020-06-13 | Angelina | Texas | 48005 | 309 | 5 |
236431 | 236431 | 2020-06-13 | Aransas | Texas | 48007 | 6 | 0 |
236432 | 236432 | 2020-06-13 | Archer | Texas | 48009 | 3 | 0 |
236433 | 236433 | 2020-06-13 | Armstrong | Texas | 48011 | 2 | 0 |
236434 | 236434 | 2020-06-13 | Atascosa | Texas | 48013 | 42 | 2 |
236435 | 236435 | 2020-06-13 | Austin | Texas | 48015 | 34 | 0 |
236436 | 236436 | 2020-06-13 | Bailey | Texas | 48017 | 34 | 0 |
236437 | 236437 | 2020-06-13 | Bandera | Texas | 48019 | 7 | 0 |
236438 | 236438 | 2020-06-13 | Bastrop | Texas | 48021 | 293 | 4 |
236439 | 236439 | 2020-06-13 | Baylor | Texas | 48023 | 1 | 0 |
236440 | 236440 | 2020-06-13 | Bee | Texas | 48025 | 31 | 0 |
236441 | 236441 | 2020-06-13 | Bell | Texas | 48027 | 605 | 6 |
236442 | 236442 | 2020-06-13 | Bexar | Texas | 48029 | 4254 | 88 |
236443 | 236443 | 2020-06-13 | Blanco | Texas | 48031 | 11 | 1 |
236444 | 236444 | 2020-06-13 | Bosque | Texas | 48035 | 7 | 0 |
236445 | 236445 | 2020-06-13 | Bowie | Texas | 48037 | 370 | 13 |
236446 | 236446 | 2020-06-13 | Brazoria | Texas | 48039 | 1109 | 16 |
236447 | 236447 | 2020-06-13 | Brazos | Texas | 48041 | 781 | 25 |
236448 | 236448 | 2020-06-13 | Brewster | Texas | 48043 | 4 | 0 |
236449 | 236449 | 2020-06-13 | Briscoe | Texas | 48045 | 1 | 0 |
236450 | 236450 | 2020-06-13 | Brooks | Texas | 48047 | 1 | 0 |
236451 | 236451 | 2020-06-13 | Brown | Texas | 48049 | 60 | 10 |
236452 | 236452 | 2020-06-13 | Burleson | Texas | 48051 | 41 | 0 |
236453 | 236453 | 2020-06-13 | Burnet | Texas | 48053 | 61 | 1 |
236454 | 236454 | 2020-06-13 | Caldwell | Texas | 48055 | 95 | 0 |
236455 | 236455 | 2020-06-13 | Calhoun | Texas | 48057 | 46 | 3 |
236456 | 236456 | 2020-06-13 | Callahan | Texas | 48059 | 13 | 2 |
236457 | 236457 | 2020-06-13 | Cameron | Texas | 48061 | 1081 | 44 |
236458 | 236458 | 2020-06-13 | Camp | Texas | 48063 | 105 | 1 |
236459 | 236459 | 2020-06-13 | Carson | Texas | 48065 | 6 | 0 |
236460 | 236460 | 2020-06-13 | Cass | Texas | 48067 | 34 | 1 |
236461 | 236461 | 2020-06-13 | Castro | Texas | 48069 | 42 | 1 |
236462 | 236462 | 2020-06-13 | Chambers | Texas | 48071 | 106 | 0 |
236463 | 236463 | 2020-06-13 | Cherokee | Texas | 48073 | 54 | 2 |
236464 | 236464 | 2020-06-13 | Childress | Texas | 48075 | 6 | 0 |
236465 | 236465 | 2020-06-13 | Clay | Texas | 48077 | 5 | 0 |
236466 | 236466 | 2020-06-13 | Cochran | Texas | 48079 | 1 | 0 |
236467 | 236467 | 2020-06-13 | Coke | Texas | 48081 | 4 | 0 |
236468 | 236468 | 2020-06-13 | Coleman | Texas | 48083 | 3 | 0 |
236469 | 236469 | 2020-06-13 | Collin | Texas | 48085 | 1647 | 37 |
236470 | 236470 | 2020-06-13 | Collingsworth | Texas | 48087 | 5 | 0 |
236471 | 236471 | 2020-06-13 | Colorado | Texas | 48089 | 33 | 0 |
236472 | 236472 | 2020-06-13 | Comal | Texas | 48091 | 191 | 7 |
236473 | 236473 | 2020-06-13 | Comanche | Texas | 48093 | 12 | 1 |
236474 | 236474 | 2020-06-13 | Concho | Texas | 48095 | 1 | 0 |
236475 | 236475 | 2020-06-13 | Cooke | Texas | 48097 | 23 | 0 |
236476 | 236476 | 2020-06-13 | Coryell | Texas | 48099 | 299 | 2 |
236477 | 236477 | 2020-06-13 | Cottle | Texas | 48101 | 4 | 1 |
236478 | 236478 | 2020-06-13 | Crane | Texas | 48103 | 32 | 5 |
236479 | 236479 | 2020-06-13 | Crockett | Texas | 48105 | 5 | 0 |
236480 | 236480 | 2020-06-13 | Crosby | Texas | 48107 | 4 | 1 |
236481 | 236481 | 2020-06-13 | Dallam | Texas | 48111 | 35 | 0 |
236482 | 236482 | 2020-06-13 | Dallas | Texas | 48113 | 13930 | 283 |
236483 | 236483 | 2020-06-13 | Dawson | Texas | 48115 | 45 | 1 |
236484 | 236484 | 2020-06-13 | DeWitt | Texas | 48123 | 28 | 1 |
236485 | 236485 | 2020-06-13 | Deaf Smith | Texas | 48117 | 212 | 14 |
236486 | 236486 | 2020-06-13 | Delta | Texas | 48119 | 2 | 0 |
236487 | 236487 | 2020-06-13 | Denton | Texas | 48121 | 1719 | 36 |
236488 | 236488 | 2020-06-13 | Dickens | Texas | 48125 | 2 | 0 |
236489 | 236489 | 2020-06-13 | Dimmit | Texas | 48127 | 1 | 0 |
236490 | 236490 | 2020-06-13 | Donley | Texas | 48129 | 28 | 0 |
236491 | 236491 | 2020-06-13 | Duval | Texas | 48131 | 5 | 0 |
236492 | 236492 | 2020-06-13 | Eastland | Texas | 48133 | 7 | 0 |
236493 | 236493 | 2020-06-13 | Ector | Texas | 48135 | 273 | 6 |
236494 | 236494 | 2020-06-13 | El Paso | Texas | 48141 | 3794 | 100 |
236495 | 236495 | 2020-06-13 | Ellis | Texas | 48139 | 448 | 19 |
236496 | 236496 | 2020-06-13 | Erath | Texas | 48143 | 36 | 1 |
236497 | 236497 | 2020-06-13 | Falls | Texas | 48145 | 14 | 0 |
236498 | 236498 | 2020-06-13 | Fannin | Texas | 48147 | 54 | 2 |
236499 | 236499 | 2020-06-13 | Fayette | Texas | 48149 | 43 | 2 |
236500 | 236500 | 2020-06-13 | Fisher | Texas | 48151 | 2 | 1 |
236501 | 236501 | 2020-06-13 | Floyd | Texas | 48153 | 16 | 1 |
236502 | 236502 | 2020-06-13 | Fort Bend | Texas | 48157 | 2385 | 49 |
236503 | 236503 | 2020-06-13 | Franklin | Texas | 48159 | 27 | 0 |
236504 | 236504 | 2020-06-13 | Freestone | Texas | 48161 | 15 | 0 |
236505 | 236505 | 2020-06-13 | Frio | Texas | 48163 | 64 | 0 |
236506 | 236506 | 2020-06-13 | Gaines | Texas | 48165 | 14 | 0 |
236507 | 236507 | 2020-06-13 | Galveston | Texas | 48167 | 1237 | 40 |
236508 | 236508 | 2020-06-13 | Garza | Texas | 48169 | 6 | 0 |
236509 | 236509 | 2020-06-13 | Gillespie | Texas | 48171 | 6 | 0 |
236510 | 236510 | 2020-06-13 | Glasscock | Texas | 48173 | 2 | 0 |
236511 | 236511 | 2020-06-13 | Goliad | Texas | 48175 | 7 | 0 |
236512 | 236512 | 2020-06-13 | Gonzales | Texas | 48177 | 165 | 4 |
236513 | 236513 | 2020-06-13 | Gray | Texas | 48179 | 111 | 3 |
236514 | 236514 | 2020-06-13 | Grayson | Texas | 48181 | 433 | 4 |
236515 | 236515 | 2020-06-13 | Gregg | Texas | 48183 | 284 | 12 |
236516 | 236516 | 2020-06-13 | Grimes | Texas | 48185 | 271 | 2 |
236517 | 236517 | 2020-06-13 | Guadalupe | Texas | 48187 | 165 | 0 |
236518 | 236518 | 2020-06-13 | Hale | Texas | 48189 | 76 | 5 |
236519 | 236519 | 2020-06-13 | Hall | Texas | 48191 | 2 | 1 |
236520 | 236520 | 2020-06-13 | Hamilton | Texas | 48193 | 11 | 1 |
236521 | 236521 | 2020-06-13 | Hansford | Texas | 48195 | 21 | 2 |
236522 | 236522 | 2020-06-13 | Hardeman | Texas | 48197 | 4 | 0 |
236523 | 236523 | 2020-06-13 | Hardin | Texas | 48199 | 146 | 5 |
236524 | 236524 | 2020-06-13 | Harris | Texas | 48201 | 16568 | 275 |
236525 | 236525 | 2020-06-13 | Harrison | Texas | 48203 | 268 | 28 |
236526 | 236526 | 2020-06-13 | Hartley | Texas | 48205 | 13 | 2 |
236527 | 236527 | 2020-06-13 | Haskell | Texas | 48207 | 4 | 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);