ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
251 rows where "date" is on date 2020-09-19 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 |
---|---|---|---|---|---|---|---|
549986 | 549986 | 2020-09-19 | Anderson | Texas | 48001 | 1741 | 31 |
549987 | 549987 | 2020-09-19 | Andrews | Texas | 48003 | 412 | 8 |
549988 | 549988 | 2020-09-19 | Angelina | Texas | 48005 | 2435 | 79 |
549989 | 549989 | 2020-09-19 | Aransas | Texas | 48007 | 316 | 18 |
549990 | 549990 | 2020-09-19 | Archer | Texas | 48009 | 69 | 1 |
549991 | 549991 | 2020-09-19 | Armstrong | Texas | 48011 | 12 | 1 |
549992 | 549992 | 2020-09-19 | Atascosa | Texas | 48013 | 627 | 30 |
549993 | 549993 | 2020-09-19 | Austin | Texas | 48015 | 484 | 9 |
549994 | 549994 | 2020-09-19 | Bailey | Texas | 48017 | 206 | 5 |
549995 | 549995 | 2020-09-19 | Bandera | Texas | 48019 | 112 | 7 |
549996 | 549996 | 2020-09-19 | Bastrop | Texas | 48021 | 1788 | 28 |
549997 | 549997 | 2020-09-19 | Baylor | Texas | 48023 | 14 | 0 |
549998 | 549998 | 2020-09-19 | Bee | Texas | 48025 | 1813 | 30 |
549999 | 549999 | 2020-09-19 | Bell | Texas | 48027 | 5306 | 79 |
550000 | 550000 | 2020-09-19 | Bexar | Texas | 48029 | 50772 | 1244 |
550001 | 550001 | 2020-09-19 | Blanco | Texas | 48031 | 141 | 5 |
550002 | 550002 | 2020-09-19 | Bosque | Texas | 48035 | 294 | 6 |
550003 | 550003 | 2020-09-19 | Bowie | Texas | 48037 | 1244 | 71 |
550004 | 550004 | 2020-09-19 | Brazoria | Texas | 48039 | 10976 | 158 |
550005 | 550005 | 2020-09-19 | Brazos | Texas | 48041 | 6678 | 62 |
550006 | 550006 | 2020-09-19 | Brewster | Texas | 48043 | 214 | 2 |
550007 | 550007 | 2020-09-19 | Briscoe | Texas | 48045 | 12 | 1 |
550008 | 550008 | 2020-09-19 | Brooks | Texas | 48047 | 298 | 22 |
550009 | 550009 | 2020-09-19 | Brown | Texas | 48049 | 761 | 26 |
550010 | 550010 | 2020-09-19 | Burleson | Texas | 48051 | 326 | 6 |
550011 | 550011 | 2020-09-19 | Burnet | Texas | 48053 | 701 | 12 |
550012 | 550012 | 2020-09-19 | Caldwell | Texas | 48055 | 1488 | 35 |
550013 | 550013 | 2020-09-19 | Calhoun | Texas | 48057 | 626 | 7 |
550014 | 550014 | 2020-09-19 | Callahan | Texas | 48059 | 84 | 3 |
550015 | 550015 | 2020-09-19 | Cameron | Texas | 48061 | 22405 | 869 |
550016 | 550016 | 2020-09-19 | Camp | Texas | 48063 | 349 | 10 |
550017 | 550017 | 2020-09-19 | Carson | Texas | 48065 | 18 | 0 |
550018 | 550018 | 2020-09-19 | Cass | Texas | 48067 | 312 | 17 |
550019 | 550019 | 2020-09-19 | Castro | Texas | 48069 | 249 | 5 |
550020 | 550020 | 2020-09-19 | Chambers | Texas | 48071 | 1261 | 15 |
550021 | 550021 | 2020-09-19 | Cherokee | Texas | 48073 | 1522 | 28 |
550022 | 550022 | 2020-09-19 | Childress | Texas | 48075 | 66 | 0 |
550023 | 550023 | 2020-09-19 | Clay | Texas | 48077 | 76 | 1 |
550024 | 550024 | 2020-09-19 | Cochran | Texas | 48079 | 48 | 1 |
550025 | 550025 | 2020-09-19 | Coke | Texas | 48081 | 51 | 3 |
550026 | 550026 | 2020-09-19 | Coleman | Texas | 48083 | 67 | 3 |
550027 | 550027 | 2020-09-19 | Collin | Texas | 48085 | 12843 | 137 |
550028 | 550028 | 2020-09-19 | Collingsworth | Texas | 48087 | 18 | 0 |
550029 | 550029 | 2020-09-19 | Colorado | Texas | 48089 | 478 | 4 |
550030 | 550030 | 2020-09-19 | Comal | Texas | 48091 | 3296 | 116 |
550031 | 550031 | 2020-09-19 | Comanche | Texas | 48093 | 280 | 3 |
550032 | 550032 | 2020-09-19 | Concho | Texas | 48095 | 89 | 2 |
550033 | 550033 | 2020-09-19 | Cooke | Texas | 48097 | 395 | 5 |
550034 | 550034 | 2020-09-19 | Coryell | Texas | 48099 | 1792 | 12 |
550035 | 550035 | 2020-09-19 | Cottle | Texas | 48101 | 25 | 2 |
550036 | 550036 | 2020-09-19 | Crane | Texas | 48103 | 71 | 2 |
550037 | 550037 | 2020-09-19 | Crockett | Texas | 48105 | 164 | 6 |
550038 | 550038 | 2020-09-19 | Crosby | Texas | 48107 | 86 | 3 |
550039 | 550039 | 2020-09-19 | Culberson | Texas | 48109 | 51 | 2 |
550040 | 550040 | 2020-09-19 | Dallam | Texas | 48111 | 232 | 8 |
550041 | 550041 | 2020-09-19 | Dallas | Texas | 48113 | 80917 | 1083 |
550042 | 550042 | 2020-09-19 | Dawson | Texas | 48115 | 353 | 9 |
550043 | 550043 | 2020-09-19 | DeWitt | Texas | 48123 | 975 | 33 |
550044 | 550044 | 2020-09-19 | Deaf Smith | Texas | 48117 | 1036 | 20 |
550045 | 550045 | 2020-09-19 | Delta | Texas | 48119 | 24 | 0 |
550046 | 550046 | 2020-09-19 | Denton | Texas | 48121 | 11501 | 148 |
550047 | 550047 | 2020-09-19 | Dickens | Texas | 48125 | 48 | 2 |
550048 | 550048 | 2020-09-19 | Dimmit | Texas | 48127 | 195 | 7 |
550049 | 550049 | 2020-09-19 | Donley | Texas | 48129 | 59 | 1 |
550050 | 550050 | 2020-09-19 | Duval | Texas | 48131 | 419 | 14 |
550051 | 550051 | 2020-09-19 | Eastland | Texas | 48133 | 158 | 3 |
550052 | 550052 | 2020-09-19 | Ector | Texas | 48135 | 4601 | 92 |
550053 | 550053 | 2020-09-19 | Edwards | Texas | 48137 | 34 | 1 |
550054 | 550054 | 2020-09-19 | El Paso | Texas | 48141 | 22329 | 497 |
550055 | 550055 | 2020-09-19 | Ellis | Texas | 48139 | 4192 | 66 |
550056 | 550056 | 2020-09-19 | Erath | Texas | 48143 | 804 | 12 |
550057 | 550057 | 2020-09-19 | Falls | Texas | 48145 | 222 | 5 |
550058 | 550058 | 2020-09-19 | Fannin | Texas | 48147 | 656 | 14 |
550059 | 550059 | 2020-09-19 | Fayette | Texas | 48149 | 460 | 18 |
550060 | 550060 | 2020-09-19 | Fisher | Texas | 48151 | 64 | 1 |
550061 | 550061 | 2020-09-19 | Floyd | Texas | 48153 | 106 | 9 |
550062 | 550062 | 2020-09-19 | Foard | Texas | 48155 | 9 | 0 |
550063 | 550063 | 2020-09-19 | Fort Bend | Texas | 48157 | 15789 | 277 |
550064 | 550064 | 2020-09-19 | Franklin | Texas | 48159 | 130 | 6 |
550065 | 550065 | 2020-09-19 | Freestone | Texas | 48161 | 404 | 2 |
550066 | 550066 | 2020-09-19 | Frio | Texas | 48163 | 671 | 8 |
550067 | 550067 | 2020-09-19 | Gaines | Texas | 48165 | 313 | 8 |
550068 | 550068 | 2020-09-19 | Galveston | Texas | 48167 | 11450 | 153 |
550069 | 550069 | 2020-09-19 | Garza | Texas | 48169 | 103 | 4 |
550070 | 550070 | 2020-09-19 | Gillespie | Texas | 48171 | 213 | 10 |
550071 | 550071 | 2020-09-19 | Glasscock | Texas | 48173 | 7 | 0 |
550072 | 550072 | 2020-09-19 | Goliad | Texas | 48175 | 154 | 6 |
550073 | 550073 | 2020-09-19 | Gonzales | Texas | 48177 | 822 | 16 |
550074 | 550074 | 2020-09-19 | Gray | Texas | 48179 | 283 | 5 |
550075 | 550075 | 2020-09-19 | Grayson | Texas | 48181 | 1791 | 36 |
550076 | 550076 | 2020-09-19 | Gregg | Texas | 48183 | 2131 | 59 |
550077 | 550077 | 2020-09-19 | Grimes | Texas | 48185 | 1067 | 31 |
550078 | 550078 | 2020-09-19 | Guadalupe | Texas | 48187 | 1958 | 76 |
550079 | 550079 | 2020-09-19 | Hale | Texas | 48189 | 1797 | 57 |
550080 | 550080 | 2020-09-19 | Hall | Texas | 48191 | 24 | 1 |
550081 | 550081 | 2020-09-19 | Hamilton | Texas | 48193 | 115 | 4 |
550082 | 550082 | 2020-09-19 | Hansford | Texas | 48195 | 111 | 4 |
550083 | 550083 | 2020-09-19 | Hardeman | Texas | 48197 | 24 | 0 |
550084 | 550084 | 2020-09-19 | Hardin | Texas | 48199 | 1317 | 28 |
550085 | 550085 | 2020-09-19 | Harris | Texas | 48201 | 123264 | 2498 |
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);