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-11-29 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1965478 | 1965478 | 2021-11-29 | Anderson | Texas | 48001 | 8110 | 205 |
1965479 | 1965479 | 2021-11-29 | Andrews | Texas | 48003 | 2920 | 65 |
1965480 | 1965480 | 2021-11-29 | Angelina | Texas | 48005 | 13896 | 419 |
1965481 | 1965481 | 2021-11-29 | Aransas | Texas | 48007 | 2623 | 67 |
1965482 | 1965482 | 2021-11-29 | Archer | Texas | 48009 | 1312 | 23 |
1965483 | 1965483 | 2021-11-29 | Armstrong | Texas | 48011 | 306 | 7 |
1965484 | 1965484 | 2021-11-29 | Atascosa | Texas | 48013 | 8716 | 206 |
1965485 | 1965485 | 2021-11-29 | Austin | Texas | 48015 | 3642 | 56 |
1965486 | 1965486 | 2021-11-29 | Bailey | Texas | 48017 | 1023 | 28 |
1965487 | 1965487 | 2021-11-29 | Bandera | Texas | 48019 | 2428 | 61 |
1965488 | 1965488 | 2021-11-29 | Bastrop | Texas | 48021 | 14461 | 184 |
1965489 | 1965489 | 2021-11-29 | Baylor | Texas | 48023 | 588 | 24 |
1965490 | 1965490 | 2021-11-29 | Bee | Texas | 48025 | 5351 | 133 |
1965491 | 1965491 | 2021-11-29 | Bell | Texas | 48027 | 39510 | 739 |
1965492 | 1965492 | 2021-11-29 | Bexar | Texas | 48029 | 327406 | 5269 |
1965493 | 1965493 | 2021-11-29 | Blanco | Texas | 48031 | 1276 | 28 |
1965494 | 1965494 | 2021-11-29 | Borden | Texas | 48033 | 43 | 2 |
1965495 | 1965495 | 2021-11-29 | Bosque | Texas | 48035 | 2457 | 57 |
1965496 | 1965496 | 2021-11-29 | Bowie | Texas | 48037 | 12904 | 344 |
1965497 | 1965497 | 2021-11-29 | Brazoria | Texas | 48039 | 60811 | 851 |
1965498 | 1965498 | 2021-11-29 | Brazos | Texas | 48041 | 39055 | 364 |
1965499 | 1965499 | 2021-11-29 | Brewster | Texas | 48043 | 1104 | 22 |
1965500 | 1965500 | 2021-11-29 | Briscoe | Texas | 48045 | 241 | 7 |
1965501 | 1965501 | 2021-11-29 | Brooks | Texas | 48047 | 1130 | 47 |
1965502 | 1965502 | 2021-11-29 | Brown | Texas | 48049 | 7137 | 191 |
1965503 | 1965503 | 2021-11-29 | Burleson | Texas | 48051 | 3320 | 60 |
1965504 | 1965504 | 2021-11-29 | Burnet | Texas | 48053 | 7544 | 130 |
1965505 | 1965505 | 2021-11-29 | Caldwell | Texas | 48055 | 8549 | 154 |
1965506 | 1965506 | 2021-11-29 | Calhoun | Texas | 48057 | 3911 | 37 |
1965507 | 1965507 | 2021-11-29 | Callahan | Texas | 48059 | 1884 | 57 |
1965508 | 1965508 | 2021-11-29 | Cameron | Texas | 48061 | 66915 | 2008 |
1965509 | 1965509 | 2021-11-29 | Camp | Texas | 48063 | 2047 | 67 |
1965510 | 1965510 | 2021-11-29 | Carson | Texas | 48065 | 846 | 24 |
1965511 | 1965511 | 2021-11-29 | Cass | Texas | 48067 | 4525 | 155 |
1965512 | 1965512 | 2021-11-29 | Castro | Texas | 48069 | 1384 | 38 |
1965513 | 1965513 | 2021-11-29 | Chambers | Texas | 48071 | 8856 | 99 |
1965514 | 1965514 | 2021-11-29 | Cherokee | Texas | 48073 | 6889 | 228 |
1965515 | 1965515 | 2021-11-29 | Childress | Texas | 48075 | 1749 | 21 |
1965516 | 1965516 | 2021-11-29 | Clay | Texas | 48077 | 1596 | 25 |
1965517 | 1965517 | 2021-11-29 | Cochran | Texas | 48079 | 490 | 19 |
1965518 | 1965518 | 2021-11-29 | Coke | Texas | 48081 | 684 | 18 |
1965519 | 1965519 | 2021-11-29 | Coleman | Texas | 48083 | 1182 | 54 |
1965520 | 1965520 | 2021-11-29 | Collin | Texas | 48085 | 133004 | 1165 |
1965521 | 1965521 | 2021-11-29 | Collingsworth | Texas | 48087 | 426 | 11 |
1965522 | 1965522 | 2021-11-29 | Colorado | Texas | 48089 | 2610 | 55 |
1965523 | 1965523 | 2021-11-29 | Comal | Texas | 48091 | 20177 | 466 |
1965524 | 1965524 | 2021-11-29 | Comanche | Texas | 48093 | 2368 | 66 |
1965525 | 1965525 | 2021-11-29 | Concho | Texas | 48095 | 714 | 10 |
1965526 | 1965526 | 2021-11-29 | Cooke | Texas | 48097 | 5180 | 105 |
1965527 | 1965527 | 2021-11-29 | Coryell | Texas | 48099 | 10788 | 166 |
1965528 | 1965528 | 2021-11-29 | Cottle | Texas | 48101 | 240 | 9 |
1965529 | 1965529 | 2021-11-29 | Crane | Texas | 48103 | 897 | 19 |
1965530 | 1965530 | 2021-11-29 | Crockett | Texas | 48105 | 789 | 16 |
1965531 | 1965531 | 2021-11-29 | Crosby | Texas | 48107 | 1058 | 37 |
1965532 | 1965532 | 2021-11-29 | Culberson | Texas | 48109 | 406 | 11 |
1965533 | 1965533 | 2021-11-29 | Dallam | Texas | 48111 | 1300 | 29 |
1965534 | 1965534 | 2021-11-29 | Dallas | Texas | 48113 | 412836 | 5595 |
1965535 | 1965535 | 2021-11-29 | Dawson | Texas | 48115 | 2208 | 80 |
1965536 | 1965536 | 2021-11-29 | DeWitt | Texas | 48123 | 3013 | 85 |
1965537 | 1965537 | 2021-11-29 | Deaf Smith | Texas | 48117 | 3523 | 85 |
1965538 | 1965538 | 2021-11-29 | Delta | Texas | 48119 | 635 | 22 |
1965539 | 1965539 | 2021-11-29 | Denton | Texas | 48121 | 110758 | 1057 |
1965540 | 1965540 | 2021-11-29 | Dickens | Texas | 48125 | 260 | 13 |
1965541 | 1965541 | 2021-11-29 | Dimmit | Texas | 48127 | 3808 | 46 |
1965542 | 1965542 | 2021-11-29 | Donley | Texas | 48129 | 634 | 18 |
1965543 | 1965543 | 2021-11-29 | Duval | Texas | 48131 | 1977 | 59 |
1965544 | 1965544 | 2021-11-29 | Eastland | Texas | 48133 | 2206 | 82 |
1965545 | 1965545 | 2021-11-29 | Ector | Texas | 48135 | 26403 | 553 |
1965546 | 1965546 | 2021-11-29 | Edwards | Texas | 48137 | 335 | 8 |
1965547 | 1965547 | 2021-11-29 | El Paso | Texas | 48141 | 159696 | 2943 |
1965548 | 1965548 | 2021-11-29 | Ellis | Texas | 48139 | 34071 | 480 |
1965549 | 1965549 | 2021-11-29 | Erath | Texas | 48143 | 6436 | 106 |
1965550 | 1965550 | 2021-11-29 | Falls | Texas | 48145 | 2608 | 50 |
1965551 | 1965551 | 2021-11-29 | Fannin | Texas | 48147 | 5069 | 153 |
1965552 | 1965552 | 2021-11-29 | Fayette | Texas | 48149 | 3639 | 93 |
1965553 | 1965553 | 2021-11-29 | Fisher | Texas | 48151 | 433 | 17 |
1965554 | 1965554 | 2021-11-29 | Floyd | Texas | 48153 | 1221 | 40 |
1965555 | 1965555 | 2021-11-29 | Foard | Texas | 48155 | 183 | 10 |
1965556 | 1965556 | 2021-11-29 | Fort Bend | Texas | 48157 | 101975 | 1019 |
1965557 | 1965557 | 2021-11-29 | Franklin | Texas | 48159 | 1360 | 37 |
1965558 | 1965558 | 2021-11-29 | Freestone | Texas | 48161 | 2783 | 72 |
1965559 | 1965559 | 2021-11-29 | Frio | Texas | 48163 | 4038 | 77 |
1965560 | 1965560 | 2021-11-29 | Gaines | Texas | 48165 | 2191 | 65 |
1965561 | 1965561 | 2021-11-29 | Galveston | Texas | 48167 | 65195 | 708 |
1965562 | 1965562 | 2021-11-29 | Garza | Texas | 48169 | 747 | 22 |
1965563 | 1965563 | 2021-11-29 | Gillespie | Texas | 48171 | 3628 | 82 |
1965564 | 1965564 | 2021-11-29 | Glasscock | Texas | 48173 | 156 | 3 |
1965565 | 1965565 | 2021-11-29 | Goliad | Texas | 48175 | 670 | 28 |
1965566 | 1965566 | 2021-11-29 | Gonzales | Texas | 48177 | 3579 | 85 |
1965567 | 1965567 | 2021-11-29 | Gray | Texas | 48179 | 3919 | 83 |
1965568 | 1965568 | 2021-11-29 | Grayson | Texas | 48181 | 16491 | 511 |
1965569 | 1965569 | 2021-11-29 | Gregg | Texas | 48183 | 19438 | 578 |
1965570 | 1965570 | 2021-11-29 | Grimes | Texas | 48185 | 5285 | 108 |
1965571 | 1965571 | 2021-11-29 | Guadalupe | Texas | 48187 | 24886 | 344 |
1965572 | 1965572 | 2021-11-29 | Hale | Texas | 48189 | 8119 | 196 |
1965573 | 1965573 | 2021-11-29 | Hall | Texas | 48191 | 576 | 15 |
1965574 | 1965574 | 2021-11-29 | Hamilton | Texas | 48193 | 1325 | 29 |
1965575 | 1965575 | 2021-11-29 | Hansford | Texas | 48195 | 1159 | 26 |
1965576 | 1965576 | 2021-11-29 | Hardeman | Texas | 48197 | 456 | 14 |
1965577 | 1965577 | 2021-11-29 | Hardin | Texas | 48199 | 10495 | 212 |
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);