ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
250 rows where "date" is on date 2020-08-07 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
411058 | 411058 | 2020-08-07 | Anderson | Texas | 48001 | 2379 | 10 |
411059 | 411059 | 2020-08-07 | Andrews | Texas | 48003 | 279 | 6 |
411060 | 411060 | 2020-08-07 | Angelina | Texas | 48005 | 1796 | 43 |
411061 | 411061 | 2020-08-07 | Aransas | Texas | 48007 | 169 | 13 |
411062 | 411062 | 2020-08-07 | Archer | Texas | 48009 | 21 | 0 |
411063 | 411063 | 2020-08-07 | Armstrong | Texas | 48011 | 8 | 0 |
411064 | 411064 | 2020-08-07 | Atascosa | Texas | 48013 | 434 | 18 |
411065 | 411065 | 2020-08-07 | Austin | Texas | 48015 | 230 | 3 |
411066 | 411066 | 2020-08-07 | Bailey | Texas | 48017 | 170 | 4 |
411067 | 411067 | 2020-08-07 | Bandera | Texas | 48019 | 89 | 3 |
411068 | 411068 | 2020-08-07 | Bastrop | Texas | 48021 | 1350 | 21 |
411069 | 411069 | 2020-08-07 | Baylor | Texas | 48023 | 9 | 0 |
411070 | 411070 | 2020-08-07 | Bee | Texas | 48025 | 885 | 9 |
411071 | 411071 | 2020-08-07 | Bell | Texas | 48027 | 3785 | 36 |
411072 | 411072 | 2020-08-07 | Bexar | Texas | 48029 | 42311 | 739 |
411073 | 411073 | 2020-08-07 | Blanco | Texas | 48031 | 98 | 5 |
411074 | 411074 | 2020-08-07 | Bosque | Texas | 48035 | 155 | 2 |
411075 | 411075 | 2020-08-07 | Bowie | Texas | 48037 | 764 | 39 |
411076 | 411076 | 2020-08-07 | Brazoria | Texas | 48039 | 7090 | 88 |
411077 | 411077 | 2020-08-07 | Brazos | Texas | 48041 | 4024 | 47 |
411078 | 411078 | 2020-08-07 | Brewster | Texas | 48043 | 188 | 2 |
411079 | 411079 | 2020-08-07 | Briscoe | Texas | 48045 | 11 | 1 |
411080 | 411080 | 2020-08-07 | Brooks | Texas | 48047 | 99 | 2 |
411081 | 411081 | 2020-08-07 | Brown | Texas | 48049 | 391 | 24 |
411082 | 411082 | 2020-08-07 | Burleson | Texas | 48051 | 240 | 6 |
411083 | 411083 | 2020-08-07 | Burnet | Texas | 48053 | 551 | 9 |
411084 | 411084 | 2020-08-07 | Caldwell | Texas | 48055 | 1122 | 26 |
411085 | 411085 | 2020-08-07 | Calhoun | Texas | 48057 | 529 | 4 |
411086 | 411086 | 2020-08-07 | Callahan | Texas | 48059 | 46 | 3 |
411087 | 411087 | 2020-08-07 | Cameron | Texas | 48061 | 16290 | 415 |
411088 | 411088 | 2020-08-07 | Camp | Texas | 48063 | 229 | 5 |
411089 | 411089 | 2020-08-07 | Carson | Texas | 48065 | 15 | 0 |
411090 | 411090 | 2020-08-07 | Cass | Texas | 48067 | 171 | 8 |
411091 | 411091 | 2020-08-07 | Castro | Texas | 48069 | 197 | 4 |
411092 | 411092 | 2020-08-07 | Chambers | Texas | 48071 | 951 | 6 |
411093 | 411093 | 2020-08-07 | Cherokee | Texas | 48073 | 953 | 6 |
411094 | 411094 | 2020-08-07 | Childress | Texas | 48075 | 40 | 0 |
411095 | 411095 | 2020-08-07 | Clay | Texas | 48077 | 40 | 1 |
411096 | 411096 | 2020-08-07 | Cochran | Texas | 48079 | 31 | 0 |
411097 | 411097 | 2020-08-07 | Coke | Texas | 48081 | 42 | 1 |
411098 | 411098 | 2020-08-07 | Coleman | Texas | 48083 | 19 | 0 |
411099 | 411099 | 2020-08-07 | Collin | Texas | 48085 | 7268 | 89 |
411100 | 411100 | 2020-08-07 | Collingsworth | Texas | 48087 | 11 | 0 |
411101 | 411101 | 2020-08-07 | Colorado | Texas | 48089 | 272 | 2 |
411102 | 411102 | 2020-08-07 | Comal | Texas | 48091 | 2359 | 68 |
411103 | 411103 | 2020-08-07 | Comanche | Texas | 48093 | 141 | 3 |
411104 | 411104 | 2020-08-07 | Concho | Texas | 48095 | 28 | 0 |
411105 | 411105 | 2020-08-07 | Cooke | Texas | 48097 | 223 | 3 |
411106 | 411106 | 2020-08-07 | Coryell | Texas | 48099 | 660 | 5 |
411107 | 411107 | 2020-08-07 | Cottle | Texas | 48101 | 16 | 2 |
411108 | 411108 | 2020-08-07 | Crane | Texas | 48103 | 70 | 2 |
411109 | 411109 | 2020-08-07 | Crockett | Texas | 48105 | 155 | 3 |
411110 | 411110 | 2020-08-07 | Crosby | Texas | 48107 | 59 | 1 |
411111 | 411111 | 2020-08-07 | Culberson | Texas | 48109 | 17 | 2 |
411112 | 411112 | 2020-08-07 | Dallam | Texas | 48111 | 187 | 5 |
411113 | 411113 | 2020-08-07 | Dallas | Texas | 48113 | 55320 | 751 |
411114 | 411114 | 2020-08-07 | Dawson | Texas | 48115 | 143 | 4 |
411115 | 411115 | 2020-08-07 | DeWitt | Texas | 48123 | 643 | 18 |
411116 | 411116 | 2020-08-07 | Deaf Smith | Texas | 48117 | 750 | 19 |
411117 | 411117 | 2020-08-07 | Delta | Texas | 48119 | 16 | 0 |
411118 | 411118 | 2020-08-07 | Denton | Texas | 48121 | 7519 | 84 |
411119 | 411119 | 2020-08-07 | Dickens | Texas | 48125 | 4 | 1 |
411120 | 411120 | 2020-08-07 | Dimmit | Texas | 48127 | 146 | 3 |
411121 | 411121 | 2020-08-07 | Donley | Texas | 48129 | 48 | 0 |
411122 | 411122 | 2020-08-07 | Duval | Texas | 48131 | 164 | 6 |
411123 | 411123 | 2020-08-07 | Eastland | Texas | 48133 | 70 | 1 |
411124 | 411124 | 2020-08-07 | Ector | Texas | 48135 | 3531 | 56 |
411125 | 411125 | 2020-08-07 | Edwards | Texas | 48137 | 25 | 0 |
411126 | 411126 | 2020-08-07 | El Paso | Texas | 48141 | 15908 | 286 |
411127 | 411127 | 2020-08-07 | Ellis | Texas | 48139 | 2808 | 40 |
411128 | 411128 | 2020-08-07 | Erath | Texas | 48143 | 520 | 5 |
411129 | 411129 | 2020-08-07 | Falls | Texas | 48145 | 124 | 3 |
411130 | 411130 | 2020-08-07 | Fannin | Texas | 48147 | 242 | 8 |
411131 | 411131 | 2020-08-07 | Fayette | Texas | 48149 | 308 | 14 |
411132 | 411132 | 2020-08-07 | Fisher | Texas | 48151 | 26 | 1 |
411133 | 411133 | 2020-08-07 | Floyd | Texas | 48153 | 88 | 6 |
411134 | 411134 | 2020-08-07 | Foard | Texas | 48155 | 2 | 0 |
411135 | 411135 | 2020-08-07 | Fort Bend | Texas | 48157 | 9151 | 158 |
411136 | 411136 | 2020-08-07 | Franklin | Texas | 48159 | 90 | 2 |
411137 | 411137 | 2020-08-07 | Freestone | Texas | 48161 | 161 | 0 |
411138 | 411138 | 2020-08-07 | Frio | Texas | 48163 | 505 | 5 |
411139 | 411139 | 2020-08-07 | Gaines | Texas | 48165 | 158 | 3 |
411140 | 411140 | 2020-08-07 | Galveston | Texas | 48167 | 9291 | 111 |
411141 | 411141 | 2020-08-07 | Garza | Texas | 48169 | 99 | 3 |
411142 | 411142 | 2020-08-07 | Gillespie | Texas | 48171 | 175 | 6 |
411143 | 411143 | 2020-08-07 | Glasscock | Texas | 48173 | 6 | 0 |
411144 | 411144 | 2020-08-07 | Goliad | Texas | 48175 | 77 | 4 |
411145 | 411145 | 2020-08-07 | Gonzales | Texas | 48177 | 680 | 9 |
411146 | 411146 | 2020-08-07 | Gray | Texas | 48179 | 214 | 2 |
411147 | 411147 | 2020-08-07 | Grayson | Texas | 48181 | 1103 | 13 |
411148 | 411148 | 2020-08-07 | Gregg | Texas | 48183 | 1502 | 25 |
411149 | 411149 | 2020-08-07 | Grimes | Texas | 48185 | 872 | 21 |
411150 | 411150 | 2020-08-07 | Guadalupe | Texas | 48187 | 1673 | 52 |
411151 | 411151 | 2020-08-07 | Hale | Texas | 48189 | 1257 | 31 |
411152 | 411152 | 2020-08-07 | Hall | Texas | 48191 | 11 | 1 |
411153 | 411153 | 2020-08-07 | Hamilton | Texas | 48193 | 80 | 3 |
411154 | 411154 | 2020-08-07 | Hansford | Texas | 48195 | 69 | 2 |
411155 | 411155 | 2020-08-07 | Hardeman | Texas | 48197 | 17 | 0 |
411156 | 411156 | 2020-08-07 | Hardin | Texas | 48199 | 947 | 15 |
411157 | 411157 | 2020-08-07 | Harris | Texas | 48201 | 83183 | 1514 |
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);