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-04-22 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1247697 | 1247697 | 2021-04-22 | Anderson | Texas | 48001 | 6075 | 118 |
1247698 | 1247698 | 2021-04-22 | Andrews | Texas | 48003 | 1812 | 47 |
1247699 | 1247699 | 2021-04-22 | Angelina | Texas | 48005 | 8421 | 276 |
1247700 | 1247700 | 2021-04-22 | Aransas | Texas | 48007 | 1236 | 38 |
1247701 | 1247701 | 2021-04-22 | Archer | Texas | 48009 | 795 | 12 |
1247702 | 1247702 | 2021-04-22 | Armstrong | Texas | 48011 | 183 | 6 |
1247703 | 1247703 | 2021-04-22 | Atascosa | Texas | 48013 | 5707 | 150 |
1247704 | 1247704 | 2021-04-22 | Austin | Texas | 48015 | 2117 | 34 |
1247705 | 1247705 | 2021-04-22 | Bailey | Texas | 48017 | 821 | 19 |
1247706 | 1247706 | 2021-04-22 | Bandera | Texas | 48019 | 1369 | 27 |
1247707 | 1247707 | 2021-04-22 | Bastrop | Texas | 48021 | 9184 | 91 |
1247708 | 1247708 | 2021-04-22 | Baylor | Texas | 48023 | 296 | 12 |
1247709 | 1247709 | 2021-04-22 | Bee | Texas | 48025 | 3479 | 72 |
1247710 | 1247710 | 2021-04-22 | Bell | Texas | 48027 | 22134 | 424 |
1247711 | 1247711 | 2021-04-22 | Bexar | Texas | 48029 | 214643 | 3441 |
1247712 | 1247712 | 2021-04-22 | Blanco | Texas | 48031 | 721 | 20 |
1247713 | 1247713 | 2021-04-22 | Borden | Texas | 48033 | 31 | 2 |
1247714 | 1247714 | 2021-04-22 | Bosque | Texas | 48035 | 1656 | 33 |
1247715 | 1247715 | 2021-04-22 | Bowie | Texas | 48037 | 6901 | 210 |
1247716 | 1247716 | 2021-04-22 | Brazoria | Texas | 48039 | 36811 | 478 |
1247717 | 1247717 | 2021-04-22 | Brazos | Texas | 48041 | 26094 | 246 |
1247718 | 1247718 | 2021-04-22 | Brewster | Texas | 48043 | 920 | 16 |
1247719 | 1247719 | 2021-04-22 | Briscoe | Texas | 48045 | 158 | 5 |
1247720 | 1247720 | 2021-04-22 | Brooks | Texas | 48047 | 791 | 36 |
1247721 | 1247721 | 2021-04-22 | Brown | Texas | 48049 | 4217 | 136 |
1247722 | 1247722 | 2021-04-22 | Burleson | Texas | 48051 | 2367 | 44 |
1247723 | 1247723 | 2021-04-22 | Burnet | Texas | 48053 | 4642 | 63 |
1247724 | 1247724 | 2021-04-22 | Caldwell | Texas | 48055 | 5503 | 96 |
1247725 | 1247725 | 2021-04-22 | Calhoun | Texas | 48057 | 2253 | 23 |
1247726 | 1247726 | 2021-04-22 | Callahan | Texas | 48059 | 1180 | 39 |
1247727 | 1247727 | 2021-04-22 | Cameron | Texas | 48061 | 39886 | 1602 |
1247728 | 1247728 | 2021-04-22 | Camp | Texas | 48063 | 1229 | 42 |
1247729 | 1247729 | 2021-04-22 | Carson | Texas | 48065 | 519 | 14 |
1247730 | 1247730 | 2021-04-22 | Cass | Texas | 48067 | 1902 | 81 |
1247731 | 1247731 | 2021-04-22 | Castro | Texas | 48069 | 981 | 32 |
1247732 | 1247732 | 2021-04-22 | Chambers | Texas | 48071 | 4890 | 48 |
1247733 | 1247733 | 2021-04-22 | Cherokee | Texas | 48073 | 4143 | 136 |
1247734 | 1247734 | 2021-04-22 | Childress | Texas | 48075 | 1388 | 17 |
1247735 | 1247735 | 2021-04-22 | Clay | Texas | 48077 | 1026 | 16 |
1247736 | 1247736 | 2021-04-22 | Cochran | Texas | 48079 | 303 | 15 |
1247737 | 1247737 | 2021-04-22 | Coke | Texas | 48081 | 459 | 12 |
1247738 | 1247738 | 2021-04-22 | Coleman | Texas | 48083 | 739 | 32 |
1247739 | 1247739 | 2021-04-22 | Collin | Texas | 48085 | 88926 | 812 |
1247740 | 1247740 | 2021-04-22 | Collingsworth | Texas | 48087 | 322 | 9 |
1247741 | 1247741 | 2021-04-22 | Colorado | Texas | 48089 | 1704 | 30 |
1247742 | 1247742 | 2021-04-22 | Comal | Texas | 48091 | 10059 | 313 |
1247743 | 1247743 | 2021-04-22 | Comanche | Texas | 48093 | 1525 | 51 |
1247744 | 1247744 | 2021-04-22 | Concho | Texas | 48095 | 375 | 8 |
1247745 | 1247745 | 2021-04-22 | Cooke | Texas | 48097 | 3661 | 70 |
1247746 | 1247746 | 2021-04-22 | Coryell | Texas | 48099 | 7150 | 85 |
1247747 | 1247747 | 2021-04-22 | Cottle | Texas | 48101 | 190 | 7 |
1247748 | 1247748 | 2021-04-22 | Crane | Texas | 48103 | 526 | 12 |
1247749 | 1247749 | 2021-04-22 | Crockett | Texas | 48105 | 573 | 15 |
1247750 | 1247750 | 2021-04-22 | Crosby | Texas | 48107 | 653 | 29 |
1247751 | 1247751 | 2021-04-22 | Culberson | Texas | 48109 | 360 | 10 |
1247752 | 1247752 | 2021-04-22 | Dallam | Texas | 48111 | 961 | 24 |
1247753 | 1247753 | 2021-04-22 | Dallas | Texas | 48113 | 296606 | 3951 |
1247754 | 1247754 | 2021-04-22 | Dawson | Texas | 48115 | 1730 | 68 |
1247755 | 1247755 | 2021-04-22 | DeWitt | Texas | 48123 | 1901 | 59 |
1247756 | 1247756 | 2021-04-22 | Deaf Smith | Texas | 48117 | 2796 | 66 |
1247757 | 1247757 | 2021-04-22 | Delta | Texas | 48119 | 315 | 11 |
1247758 | 1247758 | 2021-04-22 | Denton | Texas | 48121 | 73704 | 742 |
1247759 | 1247759 | 2021-04-22 | Dickens | Texas | 48125 | 180 | 10 |
1247760 | 1247760 | 2021-04-22 | Dimmit | Texas | 48127 | 2073 | 31 |
1247761 | 1247761 | 2021-04-22 | Donley | Texas | 48129 | 384 | 15 |
1247762 | 1247762 | 2021-04-22 | Duval | Texas | 48131 | 1232 | 41 |
1247763 | 1247763 | 2021-04-22 | Eastland | Texas | 48133 | 1337 | 48 |
1247764 | 1247764 | 2021-04-22 | Ector | Texas | 48135 | 16955 | 366 |
1247765 | 1247765 | 2021-04-22 | Edwards | Texas | 48137 | 248 | 6 |
1247766 | 1247766 | 2021-04-22 | El Paso | Texas | 48141 | 133037 | 2636 |
1247767 | 1247767 | 2021-04-22 | Ellis | Texas | 48139 | 22454 | 310 |
1247768 | 1247768 | 2021-04-22 | Erath | Texas | 48143 | 4140 | 68 |
1247769 | 1247769 | 2021-04-22 | Falls | Texas | 48145 | 2084 | 32 |
1247770 | 1247770 | 2021-04-22 | Fannin | Texas | 48147 | 3466 | 108 |
1247771 | 1247771 | 2021-04-22 | Fayette | Texas | 48149 | 2654 | 60 |
1247772 | 1247772 | 2021-04-22 | Fisher | Texas | 48151 | 298 | 14 |
1247773 | 1247773 | 2021-04-22 | Floyd | Texas | 48153 | 844 | 30 |
1247774 | 1247774 | 2021-04-22 | Foard | Texas | 48155 | 121 | 10 |
1247775 | 1247775 | 2021-04-22 | Fort Bend | Texas | 48157 | 66052 | 653 |
1247776 | 1247776 | 2021-04-22 | Franklin | Texas | 48159 | 717 | 26 |
1247777 | 1247777 | 2021-04-22 | Freestone | Texas | 48161 | 1850 | 49 |
1247778 | 1247778 | 2021-04-22 | Frio | Texas | 48163 | 2816 | 49 |
1247779 | 1247779 | 2021-04-22 | Gaines | Texas | 48165 | 1431 | 43 |
1247780 | 1247780 | 2021-04-22 | Galveston | Texas | 48167 | 38491 | 402 |
1247781 | 1247781 | 2021-04-22 | Garza | Texas | 48169 | 487 | 22 |
1247782 | 1247782 | 2021-04-22 | Gillespie | Texas | 48171 | 2531 | 49 |
1247783 | 1247783 | 2021-04-22 | Glasscock | Texas | 48173 | 104 | 2 |
1247784 | 1247784 | 2021-04-22 | Goliad | Texas | 48175 | 436 | 13 |
1247785 | 1247785 | 2021-04-22 | Gonzales | Texas | 48177 | 2707 | 57 |
1247786 | 1247786 | 2021-04-22 | Gray | Texas | 48179 | 2299 | 56 |
1247787 | 1247787 | 2021-04-22 | Grayson | Texas | 48181 | 11218 | 340 |
1247788 | 1247788 | 2021-04-22 | Gregg | Texas | 48183 | 11038 | 351 |
1247789 | 1247789 | 2021-04-22 | Grimes | Texas | 48185 | 3599 | 67 |
1247790 | 1247790 | 2021-04-22 | Guadalupe | Texas | 48187 | 14408 | 208 |
1247791 | 1247791 | 2021-04-22 | Hale | Texas | 48189 | 6101 | 155 |
1247792 | 1247792 | 2021-04-22 | Hall | Texas | 48191 | 462 | 14 |
1247793 | 1247793 | 2021-04-22 | Hamilton | Texas | 48193 | 768 | 26 |
1247794 | 1247794 | 2021-04-22 | Hansford | Texas | 48195 | 893 | 24 |
1247795 | 1247795 | 2021-04-22 | Hardeman | Texas | 48197 | 373 | 12 |
1247796 | 1247796 | 2021-04-22 | Hardin | Texas | 48199 | 5613 | 110 |
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);