ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
254 rows where "date" is on date 2021-10-24 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1848482 | 1848482 | 2021-10-24 | Anderson | Texas | 48001 | 8001 | 199 |
1848483 | 1848483 | 2021-10-24 | Andrews | Texas | 48003 | 2795 | 53 |
1848484 | 1848484 | 2021-10-24 | Angelina | Texas | 48005 | 13665 | 397 |
1848485 | 1848485 | 2021-10-24 | Aransas | Texas | 48007 | 2590 | 66 |
1848486 | 1848486 | 2021-10-24 | Archer | Texas | 48009 | 1237 | 19 |
1848487 | 1848487 | 2021-10-24 | Armstrong | Texas | 48011 | 285 | 7 |
1848488 | 1848488 | 2021-10-24 | Atascosa | Texas | 48013 | 8521 | 202 |
1848489 | 1848489 | 2021-10-24 | Austin | Texas | 48015 | 3484 | 51 |
1848490 | 1848490 | 2021-10-24 | Bailey | Texas | 48017 | 1004 | 23 |
1848491 | 1848491 | 2021-10-24 | Bandera | Texas | 48019 | 2309 | 51 |
1848492 | 1848492 | 2021-10-24 | Bastrop | Texas | 48021 | 14298 | 167 |
1848493 | 1848493 | 2021-10-24 | Baylor | Texas | 48023 | 551 | 21 |
1848494 | 1848494 | 2021-10-24 | Bee | Texas | 48025 | 5293 | 127 |
1848495 | 1848495 | 2021-10-24 | Bell | Texas | 48027 | 38344 | 702 |
1848496 | 1848496 | 2021-10-24 | Bexar | Texas | 48029 | 319170 | 5070 |
1848497 | 1848497 | 2021-10-24 | Blanco | Texas | 48031 | 1305 | 28 |
1848498 | 1848498 | 2021-10-24 | Borden | Texas | 48033 | 42 | 2 |
1848499 | 1848499 | 2021-10-24 | Bosque | Texas | 48035 | 2426 | 55 |
1848500 | 1848500 | 2021-10-24 | Bowie | Texas | 48037 | 12687 | 318 |
1848501 | 1848501 | 2021-10-24 | Brazoria | Texas | 48039 | 59168 | 815 |
1848502 | 1848502 | 2021-10-24 | Brazos | Texas | 48041 | 38518 | 350 |
1848503 | 1848503 | 2021-10-24 | Brewster | Texas | 48043 | 1090 | 20 |
1848504 | 1848504 | 2021-10-24 | Briscoe | Texas | 48045 | 218 | 7 |
1848505 | 1848505 | 2021-10-24 | Brooks | Texas | 48047 | 1119 | 47 |
1848506 | 1848506 | 2021-10-24 | Brown | Texas | 48049 | 6987 | 183 |
1848507 | 1848507 | 2021-10-24 | Burleson | Texas | 48051 | 3260 | 59 |
1848508 | 1848508 | 2021-10-24 | Burnet | Texas | 48053 | 7355 | 121 |
1848509 | 1848509 | 2021-10-24 | Caldwell | Texas | 48055 | 8376 | 150 |
1848510 | 1848510 | 2021-10-24 | Calhoun | Texas | 48057 | 3906 | 36 |
1848511 | 1848511 | 2021-10-24 | Callahan | Texas | 48059 | 1790 | 53 |
1848512 | 1848512 | 2021-10-24 | Cameron | Texas | 48061 | 65498 | 1961 |
1848513 | 1848513 | 2021-10-24 | Camp | Texas | 48063 | 2012 | 65 |
1848514 | 1848514 | 2021-10-24 | Carson | Texas | 48065 | 778 | 24 |
1848515 | 1848515 | 2021-10-24 | Cass | Texas | 48067 | 4464 | 144 |
1848516 | 1848516 | 2021-10-24 | Castro | Texas | 48069 | 1312 | 37 |
1848517 | 1848517 | 2021-10-24 | Chambers | Texas | 48071 | 8755 | 97 |
1848518 | 1848518 | 2021-10-24 | Cherokee | Texas | 48073 | 6784 | 217 |
1848519 | 1848519 | 2021-10-24 | Childress | Texas | 48075 | 1572 | 20 |
1848520 | 1848520 | 2021-10-24 | Clay | Texas | 48077 | 1537 | 23 |
1848521 | 1848521 | 2021-10-24 | Cochran | Texas | 48079 | 442 | 18 |
1848522 | 1848522 | 2021-10-24 | Coke | Texas | 48081 | 675 | 16 |
1848523 | 1848523 | 2021-10-24 | Coleman | Texas | 48083 | 1091 | 53 |
1848524 | 1848524 | 2021-10-24 | Collin | Texas | 48085 | 128614 | 1115 |
1848525 | 1848525 | 2021-10-24 | Collingsworth | Texas | 48087 | 390 | 11 |
1848526 | 1848526 | 2021-10-24 | Colorado | Texas | 48089 | 2538 | 51 |
1848527 | 1848527 | 2021-10-24 | Comal | Texas | 48091 | 19304 | 444 |
1848528 | 1848528 | 2021-10-24 | Comanche | Texas | 48093 | 2182 | 64 |
1848529 | 1848529 | 2021-10-24 | Concho | Texas | 48095 | 702 | 10 |
1848530 | 1848530 | 2021-10-24 | Cooke | Texas | 48097 | 5081 | 100 |
1848531 | 1848531 | 2021-10-24 | Coryell | Texas | 48099 | 10757 | 156 |
1848532 | 1848532 | 2021-10-24 | Cottle | Texas | 48101 | 227 | 9 |
1848533 | 1848533 | 2021-10-24 | Crane | Texas | 48103 | 860 | 18 |
1848534 | 1848534 | 2021-10-24 | Crockett | Texas | 48105 | 780 | 16 |
1848535 | 1848535 | 2021-10-24 | Crosby | Texas | 48107 | 992 | 36 |
1848536 | 1848536 | 2021-10-24 | Culberson | Texas | 48109 | 388 | 11 |
1848537 | 1848537 | 2021-10-24 | Dallam | Texas | 48111 | 1205 | 30 |
1848538 | 1848538 | 2021-10-24 | Dallas | Texas | 48113 | 402022 | 5279 |
1848539 | 1848539 | 2021-10-24 | Dawson | Texas | 48115 | 2143 | 77 |
1848540 | 1848540 | 2021-10-24 | DeWitt | Texas | 48123 | 2952 | 82 |
1848541 | 1848541 | 2021-10-24 | Deaf Smith | Texas | 48117 | 3382 | 75 |
1848542 | 1848542 | 2021-10-24 | Delta | Texas | 48119 | 607 | 21 |
1848543 | 1848543 | 2021-10-24 | Denton | Texas | 48121 | 106582 | 1001 |
1848544 | 1848544 | 2021-10-24 | Dickens | Texas | 48125 | 248 | 13 |
1848545 | 1848545 | 2021-10-24 | Dimmit | Texas | 48127 | 3777 | 45 |
1848546 | 1848546 | 2021-10-24 | Donley | Texas | 48129 | 579 | 18 |
1848547 | 1848547 | 2021-10-24 | Duval | Texas | 48131 | 1947 | 57 |
1848548 | 1848548 | 2021-10-24 | Eastland | Texas | 48133 | 2147 | 77 |
1848549 | 1848549 | 2021-10-24 | Ector | Texas | 48135 | 25606 | 525 |
1848550 | 1848550 | 2021-10-24 | Edwards | Texas | 48137 | 325 | 7 |
1848551 | 1848551 | 2021-10-24 | El Paso | Texas | 48141 | 148172 | 2863 |
1848552 | 1848552 | 2021-10-24 | Ellis | Texas | 48139 | 33241 | 455 |
1848553 | 1848553 | 2021-10-24 | Erath | Texas | 48143 | 6284 | 100 |
1848554 | 1848554 | 2021-10-24 | Falls | Texas | 48145 | 2615 | 45 |
1848555 | 1848555 | 2021-10-24 | Fannin | Texas | 48147 | 4965 | 149 |
1848556 | 1848556 | 2021-10-24 | Fayette | Texas | 48149 | 3588 | 92 |
1848557 | 1848557 | 2021-10-24 | Fisher | Texas | 48151 | 434 | 16 |
1848558 | 1848558 | 2021-10-24 | Floyd | Texas | 48153 | 1168 | 38 |
1848559 | 1848559 | 2021-10-24 | Foard | Texas | 48155 | 181 | 10 |
1848560 | 1848560 | 2021-10-24 | Fort Bend | Texas | 48157 | 99485 | 951 |
1848561 | 1848561 | 2021-10-24 | Franklin | Texas | 48159 | 1324 | 35 |
1848562 | 1848562 | 2021-10-24 | Freestone | Texas | 48161 | 2744 | 67 |
1848563 | 1848563 | 2021-10-24 | Frio | Texas | 48163 | 3920 | 69 |
1848564 | 1848564 | 2021-10-24 | Gaines | Texas | 48165 | 2131 | 60 |
1848565 | 1848565 | 2021-10-24 | Galveston | Texas | 48167 | 63882 | 692 |
1848566 | 1848566 | 2021-10-24 | Garza | Texas | 48169 | 719 | 22 |
1848567 | 1848567 | 2021-10-24 | Gillespie | Texas | 48171 | 3515 | 77 |
1848568 | 1848568 | 2021-10-24 | Glasscock | Texas | 48173 | 154 | 3 |
1848569 | 1848569 | 2021-10-24 | Goliad | Texas | 48175 | 699 | 28 |
1848570 | 1848570 | 2021-10-24 | Gonzales | Texas | 48177 | 3535 | 83 |
1848571 | 1848571 | 2021-10-24 | Gray | Texas | 48179 | 3486 | 79 |
1848572 | 1848572 | 2021-10-24 | Grayson | Texas | 48181 | 16104 | 480 |
1848573 | 1848573 | 2021-10-24 | Gregg | Texas | 48183 | 19173 | 538 |
1848574 | 1848574 | 2021-10-24 | Grimes | Texas | 48185 | 5139 | 105 |
1848575 | 1848575 | 2021-10-24 | Guadalupe | Texas | 48187 | 24262 | 333 |
1848576 | 1848576 | 2021-10-24 | Hale | Texas | 48189 | 7875 | 187 |
1848577 | 1848577 | 2021-10-24 | Hall | Texas | 48191 | 541 | 15 |
1848578 | 1848578 | 2021-10-24 | Hamilton | Texas | 48193 | 1302 | 29 |
1848579 | 1848579 | 2021-10-24 | Hansford | Texas | 48195 | 1127 | 26 |
1848580 | 1848580 | 2021-10-24 | Hardeman | Texas | 48197 | 450 | 14 |
1848581 | 1848581 | 2021-10-24 | Hardin | Texas | 48199 | 10343 | 204 |
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);