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-18 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1828986 | 1828986 | 2021-10-18 | Anderson | Texas | 48001 | 7947 | 195 |
1828987 | 1828987 | 2021-10-18 | Andrews | Texas | 48003 | 2766 | 53 |
1828988 | 1828988 | 2021-10-18 | Angelina | Texas | 48005 | 13624 | 389 |
1828989 | 1828989 | 2021-10-18 | Aransas | Texas | 48007 | 2585 | 63 |
1828990 | 1828990 | 2021-10-18 | Archer | Texas | 48009 | 1225 | 19 |
1828991 | 1828991 | 2021-10-18 | Armstrong | Texas | 48011 | 279 | 7 |
1828992 | 1828992 | 2021-10-18 | Atascosa | Texas | 48013 | 8485 | 200 |
1828993 | 1828993 | 2021-10-18 | Austin | Texas | 48015 | 3449 | 51 |
1828994 | 1828994 | 2021-10-18 | Bailey | Texas | 48017 | 999 | 23 |
1828995 | 1828995 | 2021-10-18 | Bandera | Texas | 48019 | 2275 | 51 |
1828996 | 1828996 | 2021-10-18 | Bastrop | Texas | 48021 | 14230 | 164 |
1828997 | 1828997 | 2021-10-18 | Baylor | Texas | 48023 | 542 | 19 |
1828998 | 1828998 | 2021-10-18 | Bee | Texas | 48025 | 5281 | 123 |
1828999 | 1828999 | 2021-10-18 | Bell | Texas | 48027 | 38125 | 684 |
1829000 | 1829000 | 2021-10-18 | Bexar | Texas | 48029 | 318138 | 4976 |
1829001 | 1829001 | 2021-10-18 | Blanco | Texas | 48031 | 1302 | 28 |
1829002 | 1829002 | 2021-10-18 | Borden | Texas | 48033 | 42 | 2 |
1829003 | 1829003 | 2021-10-18 | Bosque | Texas | 48035 | 2417 | 55 |
1829004 | 1829004 | 2021-10-18 | Bowie | Texas | 48037 | 12611 | 316 |
1829005 | 1829005 | 2021-10-18 | Brazoria | Texas | 48039 | 59077 | 804 |
1829006 | 1829006 | 2021-10-18 | Brazos | Texas | 48041 | 38382 | 350 |
1829007 | 1829007 | 2021-10-18 | Brewster | Texas | 48043 | 1083 | 19 |
1829008 | 1829008 | 2021-10-18 | Briscoe | Texas | 48045 | 216 | 7 |
1829009 | 1829009 | 2021-10-18 | Brooks | Texas | 48047 | 1117 | 47 |
1829010 | 1829010 | 2021-10-18 | Brown | Texas | 48049 | 6934 | 182 |
1829011 | 1829011 | 2021-10-18 | Burleson | Texas | 48051 | 3244 | 59 |
1829012 | 1829012 | 2021-10-18 | Burnet | Texas | 48053 | 7323 | 116 |
1829013 | 1829013 | 2021-10-18 | Caldwell | Texas | 48055 | 8354 | 146 |
1829014 | 1829014 | 2021-10-18 | Calhoun | Texas | 48057 | 3889 | 35 |
1829015 | 1829015 | 2021-10-18 | Callahan | Texas | 48059 | 1756 | 53 |
1829016 | 1829016 | 2021-10-18 | Cameron | Texas | 48061 | 65079 | 1952 |
1829017 | 1829017 | 2021-10-18 | Camp | Texas | 48063 | 1997 | 64 |
1829018 | 1829018 | 2021-10-18 | Carson | Texas | 48065 | 766 | 24 |
1829019 | 1829019 | 2021-10-18 | Cass | Texas | 48067 | 4439 | 142 |
1829020 | 1829020 | 2021-10-18 | Castro | Texas | 48069 | 1294 | 35 |
1829021 | 1829021 | 2021-10-18 | Chambers | Texas | 48071 | 8719 | 96 |
1829022 | 1829022 | 2021-10-18 | Cherokee | Texas | 48073 | 6758 | 210 |
1829023 | 1829023 | 2021-10-18 | Childress | Texas | 48075 | 1545 | 20 |
1829024 | 1829024 | 2021-10-18 | Clay | Texas | 48077 | 1517 | 23 |
1829025 | 1829025 | 2021-10-18 | Cochran | Texas | 48079 | 438 | 18 |
1829026 | 1829026 | 2021-10-18 | Coke | Texas | 48081 | 674 | 16 |
1829027 | 1829027 | 2021-10-18 | Coleman | Texas | 48083 | 1041 | 52 |
1829028 | 1829028 | 2021-10-18 | Collin | Texas | 48085 | 127723 | 1081 |
1829029 | 1829029 | 2021-10-18 | Collingsworth | Texas | 48087 | 387 | 11 |
1829030 | 1829030 | 2021-10-18 | Colorado | Texas | 48089 | 2526 | 51 |
1829031 | 1829031 | 2021-10-18 | Comal | Texas | 48091 | 19093 | 441 |
1829032 | 1829032 | 2021-10-18 | Comanche | Texas | 48093 | 2135 | 64 |
1829033 | 1829033 | 2021-10-18 | Concho | Texas | 48095 | 702 | 10 |
1829034 | 1829034 | 2021-10-18 | Cooke | Texas | 48097 | 5044 | 98 |
1829035 | 1829035 | 2021-10-18 | Coryell | Texas | 48099 | 10689 | 154 |
1829036 | 1829036 | 2021-10-18 | Cottle | Texas | 48101 | 226 | 9 |
1829037 | 1829037 | 2021-10-18 | Crane | Texas | 48103 | 855 | 17 |
1829038 | 1829038 | 2021-10-18 | Crockett | Texas | 48105 | 779 | 16 |
1829039 | 1829039 | 2021-10-18 | Crosby | Texas | 48107 | 990 | 36 |
1829040 | 1829040 | 2021-10-18 | Culberson | Texas | 48109 | 387 | 11 |
1829041 | 1829041 | 2021-10-18 | Dallam | Texas | 48111 | 1192 | 29 |
1829042 | 1829042 | 2021-10-18 | Dallas | Texas | 48113 | 398928 | 5172 |
1829043 | 1829043 | 2021-10-18 | Dawson | Texas | 48115 | 2122 | 76 |
1829044 | 1829044 | 2021-10-18 | DeWitt | Texas | 48123 | 2953 | 81 |
1829045 | 1829045 | 2021-10-18 | Deaf Smith | Texas | 48117 | 3364 | 74 |
1829046 | 1829046 | 2021-10-18 | Delta | Texas | 48119 | 599 | 20 |
1829047 | 1829047 | 2021-10-18 | Denton | Texas | 48121 | 105437 | 973 |
1829048 | 1829048 | 2021-10-18 | Dickens | Texas | 48125 | 245 | 12 |
1829049 | 1829049 | 2021-10-18 | Dimmit | Texas | 48127 | 3765 | 45 |
1829050 | 1829050 | 2021-10-18 | Donley | Texas | 48129 | 568 | 18 |
1829051 | 1829051 | 2021-10-18 | Duval | Texas | 48131 | 1949 | 56 |
1829052 | 1829052 | 2021-10-18 | Eastland | Texas | 48133 | 2106 | 76 |
1829053 | 1829053 | 2021-10-18 | Ector | Texas | 48135 | 25438 | 519 |
1829054 | 1829054 | 2021-10-18 | Edwards | Texas | 48137 | 325 | 7 |
1829055 | 1829055 | 2021-10-18 | El Paso | Texas | 48141 | 147301 | 2843 |
1829056 | 1829056 | 2021-10-18 | Ellis | Texas | 48139 | 32780 | 438 |
1829057 | 1829057 | 2021-10-18 | Erath | Texas | 48143 | 6236 | 100 |
1829058 | 1829058 | 2021-10-18 | Falls | Texas | 48145 | 2612 | 43 |
1829059 | 1829059 | 2021-10-18 | Fannin | Texas | 48147 | 4912 | 143 |
1829060 | 1829060 | 2021-10-18 | Fayette | Texas | 48149 | 3582 | 92 |
1829061 | 1829061 | 2021-10-18 | Fisher | Texas | 48151 | 411 | 16 |
1829062 | 1829062 | 2021-10-18 | Floyd | Texas | 48153 | 1147 | 37 |
1829063 | 1829063 | 2021-10-18 | Foard | Texas | 48155 | 181 | 10 |
1829064 | 1829064 | 2021-10-18 | Fort Bend | Texas | 48157 | 98432 | 942 |
1829065 | 1829065 | 2021-10-18 | Franklin | Texas | 48159 | 1306 | 34 |
1829066 | 1829066 | 2021-10-18 | Freestone | Texas | 48161 | 2728 | 66 |
1829067 | 1829067 | 2021-10-18 | Frio | Texas | 48163 | 3892 | 68 |
1829068 | 1829068 | 2021-10-18 | Gaines | Texas | 48165 | 2120 | 59 |
1829069 | 1829069 | 2021-10-18 | Galveston | Texas | 48167 | 63533 | 685 |
1829070 | 1829070 | 2021-10-18 | Garza | Texas | 48169 | 706 | 22 |
1829071 | 1829071 | 2021-10-18 | Gillespie | Texas | 48171 | 3502 | 77 |
1829072 | 1829072 | 2021-10-18 | Glasscock | Texas | 48173 | 152 | 3 |
1829073 | 1829073 | 2021-10-18 | Goliad | Texas | 48175 | 699 | 28 |
1829074 | 1829074 | 2021-10-18 | Gonzales | Texas | 48177 | 3530 | 83 |
1829075 | 1829075 | 2021-10-18 | Gray | Texas | 48179 | 3448 | 77 |
1829076 | 1829076 | 2021-10-18 | Grayson | Texas | 48181 | 16000 | 469 |
1829077 | 1829077 | 2021-10-18 | Gregg | Texas | 48183 | 19096 | 528 |
1829078 | 1829078 | 2021-10-18 | Grimes | Texas | 48185 | 5127 | 103 |
1829079 | 1829079 | 2021-10-18 | Guadalupe | Texas | 48187 | 23994 | 326 |
1829080 | 1829080 | 2021-10-18 | Hale | Texas | 48189 | 7820 | 185 |
1829081 | 1829081 | 2021-10-18 | Hall | Texas | 48191 | 540 | 15 |
1829082 | 1829082 | 2021-10-18 | Hamilton | Texas | 48193 | 1295 | 29 |
1829083 | 1829083 | 2021-10-18 | Hansford | Texas | 48195 | 1111 | 26 |
1829084 | 1829084 | 2021-10-18 | Hardeman | Texas | 48197 | 449 | 13 |
1829085 | 1829085 | 2021-10-18 | Hardin | Texas | 48199 | 10288 | 203 |
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);