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-07-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 |
---|---|---|---|---|---|---|---|
1549605 | 1549605 | 2021-07-24 | Anderson | Texas | 48001 | 6212 | 133 |
1549606 | 1549606 | 2021-07-24 | Andrews | Texas | 48003 | 1866 | 47 |
1549607 | 1549607 | 2021-07-24 | Angelina | Texas | 48005 | 8900 | 288 |
1549608 | 1549608 | 2021-07-24 | Aransas | Texas | 48007 | 1400 | 43 |
1549609 | 1549609 | 2021-07-24 | Archer | Texas | 48009 | 820 | 12 |
1549610 | 1549610 | 2021-07-24 | Armstrong | Texas | 48011 | 216 | 7 |
1549611 | 1549611 | 2021-07-24 | Atascosa | Texas | 48013 | 6058 | 151 |
1549612 | 1549612 | 2021-07-24 | Austin | Texas | 48015 | 2302 | 37 |
1549613 | 1549613 | 2021-07-24 | Bailey | Texas | 48017 | 872 | 19 |
1549614 | 1549614 | 2021-07-24 | Bandera | Texas | 48019 | 1498 | 31 |
1549615 | 1549615 | 2021-07-24 | Bastrop | Texas | 48021 | 10108 | 106 |
1549616 | 1549616 | 2021-07-24 | Baylor | Texas | 48023 | 303 | 13 |
1549617 | 1549617 | 2021-07-24 | Bee | Texas | 48025 | 3618 | 75 |
1549618 | 1549618 | 2021-07-24 | Bell | Texas | 48027 | 26390 | 458 |
1549619 | 1549619 | 2021-07-24 | Bexar | Texas | 48029 | 233179 | 3667 |
1549620 | 1549620 | 2021-07-24 | Blanco | Texas | 48031 | 798 | 21 |
1549621 | 1549621 | 2021-07-24 | Borden | Texas | 48033 | 31 | 2 |
1549622 | 1549622 | 2021-07-24 | Bosque | Texas | 48035 | 1733 | 37 |
1549623 | 1549623 | 2021-07-24 | Bowie | Texas | 48037 | 7999 | 227 |
1549624 | 1549624 | 2021-07-24 | Brazoria | Texas | 48039 | 40090 | 540 |
1549625 | 1549625 | 2021-07-24 | Brazos | Texas | 48041 | 28487 | 265 |
1549626 | 1549626 | 2021-07-24 | Brewster | Texas | 48043 | 951 | 17 |
1549627 | 1549627 | 2021-07-24 | Briscoe | Texas | 48045 | 176 | 6 |
1549628 | 1549628 | 2021-07-24 | Brooks | Texas | 48047 | 886 | 36 |
1549629 | 1549629 | 2021-07-24 | Brown | Texas | 48049 | 4530 | 142 |
1549630 | 1549630 | 2021-07-24 | Burleson | Texas | 48051 | 2524 | 48 |
1549631 | 1549631 | 2021-07-24 | Burnet | Texas | 48053 | 5098 | 70 |
1549632 | 1549632 | 2021-07-24 | Caldwell | Texas | 48055 | 5909 | 100 |
1549633 | 1549633 | 2021-07-24 | Calhoun | Texas | 48057 | 2548 | 25 |
1549634 | 1549634 | 2021-07-24 | Callahan | Texas | 48059 | 1219 | 41 |
1549635 | 1549635 | 2021-07-24 | Cameron | Texas | 48061 | 43743 | 1705 |
1549636 | 1549636 | 2021-07-24 | Camp | Texas | 48063 | 1351 | 45 |
1549637 | 1549637 | 2021-07-24 | Carson | Texas | 48065 | 618 | 14 |
1549638 | 1549638 | 2021-07-24 | Cass | Texas | 48067 | 2336 | 85 |
1549639 | 1549639 | 2021-07-24 | Castro | Texas | 48069 | 1081 | 32 |
1549640 | 1549640 | 2021-07-24 | Chambers | Texas | 48071 | 5503 | 59 |
1549641 | 1549641 | 2021-07-24 | Cherokee | Texas | 48073 | 4418 | 148 |
1549642 | 1549642 | 2021-07-24 | Childress | Texas | 48075 | 1381 | 17 |
1549643 | 1549643 | 2021-07-24 | Clay | Texas | 48077 | 1059 | 17 |
1549644 | 1549644 | 2021-07-24 | Cochran | Texas | 48079 | 339 | 15 |
1549645 | 1549645 | 2021-07-24 | Coke | Texas | 48081 | 472 | 13 |
1549646 | 1549646 | 2021-07-24 | Coleman | Texas | 48083 | 787 | 34 |
1549647 | 1549647 | 2021-07-24 | Collin | Texas | 48085 | 94824 | 857 |
1549648 | 1549648 | 2021-07-24 | Collingsworth | Texas | 48087 | 331 | 9 |
1549649 | 1549649 | 2021-07-24 | Colorado | Texas | 48089 | 1823 | 33 |
1549650 | 1549650 | 2021-07-24 | Comal | Texas | 48091 | 12108 | 335 |
1549651 | 1549651 | 2021-07-24 | Comanche | Texas | 48093 | 1586 | 52 |
1549652 | 1549652 | 2021-07-24 | Concho | Texas | 48095 | 510 | 8 |
1549653 | 1549653 | 2021-07-24 | Cooke | Texas | 48097 | 3839 | 72 |
1549654 | 1549654 | 2021-07-24 | Coryell | Texas | 48099 | 7641 | 89 |
1549655 | 1549655 | 2021-07-24 | Cottle | Texas | 48101 | 191 | 7 |
1549656 | 1549656 | 2021-07-24 | Crane | Texas | 48103 | 568 | 12 |
1549657 | 1549657 | 2021-07-24 | Crockett | Texas | 48105 | 617 | 15 |
1549658 | 1549658 | 2021-07-24 | Crosby | Texas | 48107 | 769 | 29 |
1549659 | 1549659 | 2021-07-24 | Culberson | Texas | 48109 | 366 | 11 |
1549660 | 1549660 | 2021-07-24 | Dallam | Texas | 48111 | 993 | 26 |
1549661 | 1549661 | 2021-07-24 | Dallas | Texas | 48113 | 312154 | 4160 |
1549662 | 1549662 | 2021-07-24 | Dawson | Texas | 48115 | 1754 | 69 |
1549663 | 1549663 | 2021-07-24 | DeWitt | Texas | 48123 | 2011 | 61 |
1549664 | 1549664 | 2021-07-24 | Deaf Smith | Texas | 48117 | 2978 | 68 |
1549665 | 1549665 | 2021-07-24 | Delta | Texas | 48119 | 361 | 14 |
1549666 | 1549666 | 2021-07-24 | Denton | Texas | 48121 | 78793 | 788 |
1549667 | 1549667 | 2021-07-24 | Dickens | Texas | 48125 | 198 | 10 |
1549668 | 1549668 | 2021-07-24 | Dimmit | Texas | 48127 | 2890 | 37 |
1549669 | 1549669 | 2021-07-24 | Donley | Texas | 48129 | 429 | 15 |
1549670 | 1549670 | 2021-07-24 | Duval | Texas | 48131 | 1327 | 42 |
1549671 | 1549671 | 2021-07-24 | Eastland | Texas | 48133 | 1384 | 50 |
1549672 | 1549672 | 2021-07-24 | Ector | Texas | 48135 | 18064 | 379 |
1549673 | 1549673 | 2021-07-24 | Edwards | Texas | 48137 | 249 | 6 |
1549674 | 1549674 | 2021-07-24 | El Paso | Texas | 48141 | 137552 | 2756 |
1549675 | 1549675 | 2021-07-24 | Ellis | Texas | 48139 | 23367 | 325 |
1549676 | 1549676 | 2021-07-24 | Erath | Texas | 48143 | 4324 | 70 |
1549677 | 1549677 | 2021-07-24 | Falls | Texas | 48145 | 2105 | 33 |
1549678 | 1549678 | 2021-07-24 | Fannin | Texas | 48147 | 3516 | 109 |
1549679 | 1549679 | 2021-07-24 | Fayette | Texas | 48149 | 2848 | 69 |
1549680 | 1549680 | 2021-07-24 | Fisher | Texas | 48151 | 310 | 14 |
1549681 | 1549681 | 2021-07-24 | Floyd | Texas | 48153 | 909 | 30 |
1549682 | 1549682 | 2021-07-24 | Foard | Texas | 48155 | 124 | 10 |
1549683 | 1549683 | 2021-07-24 | Fort Bend | Texas | 48157 | 71519 | 733 |
1549684 | 1549684 | 2021-07-24 | Franklin | Texas | 48159 | 822 | 26 |
1549685 | 1549685 | 2021-07-24 | Freestone | Texas | 48161 | 2023 | 50 |
1549686 | 1549686 | 2021-07-24 | Frio | Texas | 48163 | 3006 | 53 |
1549687 | 1549687 | 2021-07-24 | Gaines | Texas | 48165 | 1475 | 46 |
1549688 | 1549688 | 2021-07-24 | Galveston | Texas | 48167 | 42809 | 456 |
1549689 | 1549689 | 2021-07-24 | Garza | Texas | 48169 | 560 | 22 |
1549690 | 1549690 | 2021-07-24 | Gillespie | Texas | 48171 | 2693 | 53 |
1549691 | 1549691 | 2021-07-24 | Glasscock | Texas | 48173 | 105 | 2 |
1549692 | 1549692 | 2021-07-24 | Goliad | Texas | 48175 | 497 | 16 |
1549693 | 1549693 | 2021-07-24 | Gonzales | Texas | 48177 | 2795 | 58 |
1549694 | 1549694 | 2021-07-24 | Gray | Texas | 48179 | 2580 | 58 |
1549695 | 1549695 | 2021-07-24 | Grayson | Texas | 48181 | 11720 | 347 |
1549696 | 1549696 | 2021-07-24 | Gregg | Texas | 48183 | 11806 | 363 |
1549697 | 1549697 | 2021-07-24 | Grimes | Texas | 48185 | 3878 | 74 |
1549698 | 1549698 | 2021-07-24 | Guadalupe | Texas | 48187 | 16351 | 224 |
1549699 | 1549699 | 2021-07-24 | Hale | Texas | 48189 | 6231 | 157 |
1549700 | 1549700 | 2021-07-24 | Hall | Texas | 48191 | 501 | 14 |
1549701 | 1549701 | 2021-07-24 | Hamilton | Texas | 48193 | 835 | 29 |
1549702 | 1549702 | 2021-07-24 | Hansford | Texas | 48195 | 953 | 24 |
1549703 | 1549703 | 2021-07-24 | Hardeman | Texas | 48197 | 386 | 12 |
1549704 | 1549704 | 2021-07-24 | Hardin | Texas | 48199 | 6399 | 118 |
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);