ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
254 rows where date = "2021-11-22" 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 |
---|---|---|---|---|---|---|---|
1942720 | 1942720 | 2021-11-22 | Anderson | Texas | 48001 | 8099 | 205 |
1942721 | 1942721 | 2021-11-22 | Andrews | Texas | 48003 | 2920 | 64 |
1942722 | 1942722 | 2021-11-22 | Angelina | Texas | 48005 | 13852 | 418 |
1942723 | 1942723 | 2021-11-22 | Aransas | Texas | 48007 | 2612 | 67 |
1942724 | 1942724 | 2021-11-22 | Archer | Texas | 48009 | 1297 | 23 |
1942725 | 1942725 | 2021-11-22 | Armstrong | Texas | 48011 | 296 | 7 |
1942726 | 1942726 | 2021-11-22 | Atascosa | Texas | 48013 | 8716 | 206 |
1942727 | 1942727 | 2021-11-22 | Austin | Texas | 48015 | 3631 | 56 |
1942728 | 1942728 | 2021-11-22 | Bailey | Texas | 48017 | 1017 | 28 |
1942729 | 1942729 | 2021-11-22 | Bandera | Texas | 48019 | 2428 | 61 |
1942730 | 1942730 | 2021-11-22 | Bastrop | Texas | 48021 | 14391 | 183 |
1942731 | 1942731 | 2021-11-22 | Baylor | Texas | 48023 | 580 | 24 |
1942732 | 1942732 | 2021-11-22 | Bee | Texas | 48025 | 5344 | 132 |
1942733 | 1942733 | 2021-11-22 | Bell | Texas | 48027 | 39510 | 734 |
1942734 | 1942734 | 2021-11-22 | Bexar | Texas | 48029 | 326147 | 5254 |
1942735 | 1942735 | 2021-11-22 | Blanco | Texas | 48031 | 1272 | 28 |
1942736 | 1942736 | 2021-11-22 | Borden | Texas | 48033 | 43 | 2 |
1942737 | 1942737 | 2021-11-22 | Bosque | Texas | 48035 | 2452 | 57 |
1942738 | 1942738 | 2021-11-22 | Bowie | Texas | 48037 | 12858 | 342 |
1942739 | 1942739 | 2021-11-22 | Brazoria | Texas | 48039 | 60623 | 850 |
1942740 | 1942740 | 2021-11-22 | Brazos | Texas | 48041 | 38954 | 363 |
1942741 | 1942741 | 2021-11-22 | Brewster | Texas | 48043 | 1103 | 22 |
1942742 | 1942742 | 2021-11-22 | Briscoe | Texas | 48045 | 238 | 7 |
1942743 | 1942743 | 2021-11-22 | Brooks | Texas | 48047 | 1127 | 47 |
1942744 | 1942744 | 2021-11-22 | Brown | Texas | 48049 | 7137 | 191 |
1942745 | 1942745 | 2021-11-22 | Burleson | Texas | 48051 | 3307 | 60 |
1942746 | 1942746 | 2021-11-22 | Burnet | Texas | 48053 | 7505 | 130 |
1942747 | 1942747 | 2021-11-22 | Caldwell | Texas | 48055 | 8513 | 153 |
1942748 | 1942748 | 2021-11-22 | Calhoun | Texas | 48057 | 3911 | 36 |
1942749 | 1942749 | 2021-11-22 | Callahan | Texas | 48059 | 1876 | 57 |
1942750 | 1942750 | 2021-11-22 | Cameron | Texas | 48061 | 66674 | 2000 |
1942751 | 1942751 | 2021-11-22 | Camp | Texas | 48063 | 2038 | 67 |
1942752 | 1942752 | 2021-11-22 | Carson | Texas | 48065 | 831 | 24 |
1942753 | 1942753 | 2021-11-22 | Cass | Texas | 48067 | 4513 | 154 |
1942754 | 1942754 | 2021-11-22 | Castro | Texas | 48069 | 1364 | 38 |
1942755 | 1942755 | 2021-11-22 | Chambers | Texas | 48071 | 8856 | 99 |
1942756 | 1942756 | 2021-11-22 | Cherokee | Texas | 48073 | 6887 | 227 |
1942757 | 1942757 | 2021-11-22 | Childress | Texas | 48075 | 1608 | 21 |
1942758 | 1942758 | 2021-11-22 | Clay | Texas | 48077 | 1575 | 25 |
1942759 | 1942759 | 2021-11-22 | Cochran | Texas | 48079 | 482 | 19 |
1942760 | 1942760 | 2021-11-22 | Coke | Texas | 48081 | 683 | 18 |
1942761 | 1942761 | 2021-11-22 | Coleman | Texas | 48083 | 1173 | 54 |
1942762 | 1942762 | 2021-11-22 | Collin | Texas | 48085 | 131717 | 1158 |
1942763 | 1942763 | 2021-11-22 | Collingsworth | Texas | 48087 | 420 | 11 |
1942764 | 1942764 | 2021-11-22 | Colorado | Texas | 48089 | 2604 | 54 |
1942765 | 1942765 | 2021-11-22 | Comal | Texas | 48091 | 20026 | 464 |
1942766 | 1942766 | 2021-11-22 | Comanche | Texas | 48093 | 2333 | 66 |
1942767 | 1942767 | 2021-11-22 | Concho | Texas | 48095 | 714 | 10 |
1942768 | 1942768 | 2021-11-22 | Cooke | Texas | 48097 | 5177 | 105 |
1942769 | 1942769 | 2021-11-22 | Coryell | Texas | 48099 | 10764 | 166 |
1942770 | 1942770 | 2021-11-22 | Cottle | Texas | 48101 | 239 | 9 |
1942771 | 1942771 | 2021-11-22 | Crane | Texas | 48103 | 895 | 19 |
1942772 | 1942772 | 2021-11-22 | Crockett | Texas | 48105 | 786 | 16 |
1942773 | 1942773 | 2021-11-22 | Crosby | Texas | 48107 | 1034 | 37 |
1942774 | 1942774 | 2021-11-22 | Culberson | Texas | 48109 | 405 | 11 |
1942775 | 1942775 | 2021-11-22 | Dallam | Texas | 48111 | 1286 | 29 |
1942776 | 1942776 | 2021-11-22 | Dallas | Texas | 48113 | 411446 | 5561 |
1942777 | 1942777 | 2021-11-22 | Dawson | Texas | 48115 | 2200 | 80 |
1942778 | 1942778 | 2021-11-22 | DeWitt | Texas | 48123 | 3018 | 84 |
1942779 | 1942779 | 2021-11-22 | Deaf Smith | Texas | 48117 | 3486 | 84 |
1942780 | 1942780 | 2021-11-22 | Delta | Texas | 48119 | 628 | 22 |
1942781 | 1942781 | 2021-11-22 | Denton | Texas | 48121 | 110306 | 1044 |
1942782 | 1942782 | 2021-11-22 | Dickens | Texas | 48125 | 257 | 13 |
1942783 | 1942783 | 2021-11-22 | Dimmit | Texas | 48127 | 3808 | 46 |
1942784 | 1942784 | 2021-11-22 | Donley | Texas | 48129 | 618 | 18 |
1942785 | 1942785 | 2021-11-22 | Duval | Texas | 48131 | 1975 | 59 |
1942786 | 1942786 | 2021-11-22 | Eastland | Texas | 48133 | 2200 | 81 |
1942787 | 1942787 | 2021-11-22 | Ector | Texas | 48135 | 26311 | 551 |
1942788 | 1942788 | 2021-11-22 | Edwards | Texas | 48137 | 335 | 8 |
1942789 | 1942789 | 2021-11-22 | El Paso | Texas | 48141 | 156448 | 2929 |
1942790 | 1942790 | 2021-11-22 | Ellis | Texas | 48139 | 34028 | 478 |
1942791 | 1942791 | 2021-11-22 | Erath | Texas | 48143 | 6427 | 105 |
1942792 | 1942792 | 2021-11-22 | Falls | Texas | 48145 | 2603 | 50 |
1942793 | 1942793 | 2021-11-22 | Fannin | Texas | 48147 | 5057 | 153 |
1942794 | 1942794 | 2021-11-22 | Fayette | Texas | 48149 | 3631 | 93 |
1942795 | 1942795 | 2021-11-22 | Fisher | Texas | 48151 | 431 | 17 |
1942796 | 1942796 | 2021-11-22 | Floyd | Texas | 48153 | 1207 | 40 |
1942797 | 1942797 | 2021-11-22 | Foard | Texas | 48155 | 183 | 10 |
1942798 | 1942798 | 2021-11-22 | Fort Bend | Texas | 48157 | 101551 | 1006 |
1942799 | 1942799 | 2021-11-22 | Franklin | Texas | 48159 | 1351 | 37 |
1942800 | 1942800 | 2021-11-22 | Freestone | Texas | 48161 | 2779 | 71 |
1942801 | 1942801 | 2021-11-22 | Frio | Texas | 48163 | 4034 | 76 |
1942802 | 1942802 | 2021-11-22 | Gaines | Texas | 48165 | 2184 | 65 |
1942803 | 1942803 | 2021-11-22 | Galveston | Texas | 48167 | 64999 | 707 |
1942804 | 1942804 | 2021-11-22 | Garza | Texas | 48169 | 742 | 22 |
1942805 | 1942805 | 2021-11-22 | Gillespie | Texas | 48171 | 3628 | 82 |
1942806 | 1942806 | 2021-11-22 | Glasscock | Texas | 48173 | 156 | 3 |
1942807 | 1942807 | 2021-11-22 | Goliad | Texas | 48175 | 670 | 28 |
1942808 | 1942808 | 2021-11-22 | Gonzales | Texas | 48177 | 3579 | 85 |
1942809 | 1942809 | 2021-11-22 | Gray | Texas | 48179 | 3782 | 83 |
1942810 | 1942810 | 2021-11-22 | Grayson | Texas | 48181 | 16432 | 507 |
1942811 | 1942811 | 2021-11-22 | Gregg | Texas | 48183 | 19402 | 575 |
1942812 | 1942812 | 2021-11-22 | Grimes | Texas | 48185 | 5274 | 108 |
1942813 | 1942813 | 2021-11-22 | Guadalupe | Texas | 48187 | 24886 | 344 |
1942814 | 1942814 | 2021-11-22 | Hale | Texas | 48189 | 8100 | 194 |
1942815 | 1942815 | 2021-11-22 | Hall | Texas | 48191 | 566 | 15 |
1942816 | 1942816 | 2021-11-22 | Hamilton | Texas | 48193 | 1322 | 29 |
1942817 | 1942817 | 2021-11-22 | Hansford | Texas | 48195 | 1155 | 26 |
1942818 | 1942818 | 2021-11-22 | Hardeman | Texas | 48197 | 456 | 14 |
1942819 | 1942819 | 2021-11-22 | Hardin | Texas | 48199 | 10466 | 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);