ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
251 rows where date = "2020-09-02" 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 |
---|---|---|---|---|---|---|---|
494987 | 494987 | 2020-09-02 | Anderson | Texas | 48001 | 2527 | 18 |
494988 | 494988 | 2020-09-02 | Andrews | Texas | 48003 | 374 | 8 |
494989 | 494989 | 2020-09-02 | Angelina | Texas | 48005 | 2250 | 69 |
494990 | 494990 | 2020-09-02 | Aransas | Texas | 48007 | 217 | 18 |
494991 | 494991 | 2020-09-02 | Archer | Texas | 48009 | 53 | 1 |
494992 | 494992 | 2020-09-02 | Armstrong | Texas | 48011 | 11 | 0 |
494993 | 494993 | 2020-09-02 | Atascosa | Texas | 48013 | 572 | 27 |
494994 | 494994 | 2020-09-02 | Austin | Texas | 48015 | 419 | 6 |
494995 | 494995 | 2020-09-02 | Bailey | Texas | 48017 | 202 | 4 |
494996 | 494996 | 2020-09-02 | Bandera | Texas | 48019 | 109 | 5 |
494997 | 494997 | 2020-09-02 | Bastrop | Texas | 48021 | 1608 | 27 |
494998 | 494998 | 2020-09-02 | Baylor | Texas | 48023 | 15 | 0 |
494999 | 494999 | 2020-09-02 | Bee | Texas | 48025 | 1621 | 23 |
495000 | 495000 | 2020-09-02 | Bell | Texas | 48027 | 4896 | 65 |
495001 | 495001 | 2020-09-02 | Bexar | Texas | 48029 | 46925 | 1119 |
495002 | 495002 | 2020-09-02 | Blanco | Texas | 48031 | 129 | 5 |
495003 | 495003 | 2020-09-02 | Bosque | Texas | 48035 | 229 | 5 |
495004 | 495004 | 2020-09-02 | Bowie | Texas | 48037 | 1000 | 71 |
495005 | 495005 | 2020-09-02 | Brazoria | Texas | 48039 | 9592 | 139 |
495006 | 495006 | 2020-09-02 | Brazos | Texas | 48041 | 5301 | 56 |
495007 | 495007 | 2020-09-02 | Brewster | Texas | 48043 | 203 | 2 |
495008 | 495008 | 2020-09-02 | Briscoe | Texas | 48045 | 12 | 1 |
495009 | 495009 | 2020-09-02 | Brooks | Texas | 48047 | 239 | 16 |
495010 | 495010 | 2020-09-02 | Brown | Texas | 48049 | 654 | 26 |
495011 | 495011 | 2020-09-02 | Burleson | Texas | 48051 | 293 | 6 |
495012 | 495012 | 2020-09-02 | Burnet | Texas | 48053 | 675 | 12 |
495013 | 495013 | 2020-09-02 | Caldwell | Texas | 48055 | 1248 | 34 |
495014 | 495014 | 2020-09-02 | Calhoun | Texas | 48057 | 611 | 7 |
495015 | 495015 | 2020-09-02 | Callahan | Texas | 48059 | 71 | 3 |
495016 | 495016 | 2020-09-02 | Cameron | Texas | 48061 | 21342 | 775 |
495017 | 495017 | 2020-09-02 | Camp | Texas | 48063 | 316 | 8 |
495018 | 495018 | 2020-09-02 | Carson | Texas | 48065 | 17 | 0 |
495019 | 495019 | 2020-09-02 | Cass | Texas | 48067 | 261 | 12 |
495020 | 495020 | 2020-09-02 | Castro | Texas | 48069 | 229 | 4 |
495021 | 495021 | 2020-09-02 | Chambers | Texas | 48071 | 1155 | 12 |
495022 | 495022 | 2020-09-02 | Cherokee | Texas | 48073 | 1427 | 17 |
495023 | 495023 | 2020-09-02 | Childress | Texas | 48075 | 57 | 0 |
495024 | 495024 | 2020-09-02 | Clay | Texas | 48077 | 69 | 1 |
495025 | 495025 | 2020-09-02 | Cochran | Texas | 48079 | 37 | 1 |
495026 | 495026 | 2020-09-02 | Coke | Texas | 48081 | 49 | 3 |
495027 | 495027 | 2020-09-02 | Coleman | Texas | 48083 | 54 | 2 |
495028 | 495028 | 2020-09-02 | Collin | Texas | 48085 | 11119 | 114 |
495029 | 495029 | 2020-09-02 | Collingsworth | Texas | 48087 | 16 | 0 |
495030 | 495030 | 2020-09-02 | Colorado | Texas | 48089 | 448 | 3 |
495031 | 495031 | 2020-09-02 | Comal | Texas | 48091 | 3024 | 96 |
495032 | 495032 | 2020-09-02 | Comanche | Texas | 48093 | 218 | 3 |
495033 | 495033 | 2020-09-02 | Concho | Texas | 48095 | 58 | 1 |
495034 | 495034 | 2020-09-02 | Cooke | Texas | 48097 | 331 | 4 |
495035 | 495035 | 2020-09-02 | Coryell | Texas | 48099 | 1432 | 10 |
495036 | 495036 | 2020-09-02 | Cottle | Texas | 48101 | 18 | 2 |
495037 | 495037 | 2020-09-02 | Crane | Texas | 48103 | 71 | 2 |
495038 | 495038 | 2020-09-02 | Crockett | Texas | 48105 | 162 | 6 |
495039 | 495039 | 2020-09-02 | Crosby | Texas | 48107 | 81 | 1 |
495040 | 495040 | 2020-09-02 | Culberson | Texas | 48109 | 35 | 2 |
495041 | 495041 | 2020-09-02 | Dallam | Texas | 48111 | 210 | 8 |
495042 | 495042 | 2020-09-02 | Dallas | Texas | 48113 | 75635 | 973 |
495043 | 495043 | 2020-09-02 | Dawson | Texas | 48115 | 228 | 8 |
495044 | 495044 | 2020-09-02 | DeWitt | Texas | 48123 | 850 | 25 |
495045 | 495045 | 2020-09-02 | Deaf Smith | Texas | 48117 | 959 | 20 |
495046 | 495046 | 2020-09-02 | Delta | Texas | 48119 | 17 | 0 |
495047 | 495047 | 2020-09-02 | Denton | Texas | 48121 | 10340 | 134 |
495048 | 495048 | 2020-09-02 | Dickens | Texas | 48125 | 39 | 1 |
495049 | 495049 | 2020-09-02 | Dimmit | Texas | 48127 | 183 | 6 |
495050 | 495050 | 2020-09-02 | Donley | Texas | 48129 | 55 | 1 |
495051 | 495051 | 2020-09-02 | Duval | Texas | 48131 | 331 | 10 |
495052 | 495052 | 2020-09-02 | Eastland | Texas | 48133 | 117 | 3 |
495053 | 495053 | 2020-09-02 | Ector | Texas | 48135 | 4302 | 72 |
495054 | 495054 | 2020-09-02 | Edwards | Texas | 48137 | 34 | 1 |
495055 | 495055 | 2020-09-02 | El Paso | Texas | 48141 | 20611 | 439 |
495056 | 495056 | 2020-09-02 | Ellis | Texas | 48139 | 3828 | 58 |
495057 | 495057 | 2020-09-02 | Erath | Texas | 48143 | 704 | 10 |
495058 | 495058 | 2020-09-02 | Falls | Texas | 48145 | 169 | 3 |
495059 | 495059 | 2020-09-02 | Fannin | Texas | 48147 | 606 | 12 |
495060 | 495060 | 2020-09-02 | Fayette | Texas | 48149 | 375 | 16 |
495061 | 495061 | 2020-09-02 | Fisher | Texas | 48151 | 59 | 1 |
495062 | 495062 | 2020-09-02 | Floyd | Texas | 48153 | 99 | 7 |
495063 | 495063 | 2020-09-02 | Foard | Texas | 48155 | 3 | 0 |
495064 | 495064 | 2020-09-02 | Fort Bend | Texas | 48157 | 15036 | 240 |
495065 | 495065 | 2020-09-02 | Franklin | Texas | 48159 | 116 | 6 |
495066 | 495066 | 2020-09-02 | Freestone | Texas | 48161 | 386 | 1 |
495067 | 495067 | 2020-09-02 | Frio | Texas | 48163 | 641 | 7 |
495068 | 495068 | 2020-09-02 | Gaines | Texas | 48165 | 258 | 7 |
495069 | 495069 | 2020-09-02 | Galveston | Texas | 48167 | 10646 | 142 |
495070 | 495070 | 2020-09-02 | Garza | Texas | 48169 | 102 | 3 |
495071 | 495071 | 2020-09-02 | Gillespie | Texas | 48171 | 202 | 7 |
495072 | 495072 | 2020-09-02 | Glasscock | Texas | 48173 | 6 | 0 |
495073 | 495073 | 2020-09-02 | Goliad | Texas | 48175 | 121 | 6 |
495074 | 495074 | 2020-09-02 | Gonzales | Texas | 48177 | 817 | 13 |
495075 | 495075 | 2020-09-02 | Gray | Texas | 48179 | 244 | 4 |
495076 | 495076 | 2020-09-02 | Grayson | Texas | 48181 | 1527 | 28 |
495077 | 495077 | 2020-09-02 | Gregg | Texas | 48183 | 2001 | 51 |
495078 | 495078 | 2020-09-02 | Grimes | Texas | 48185 | 995 | 30 |
495079 | 495079 | 2020-09-02 | Guadalupe | Texas | 48187 | 1901 | 72 |
495080 | 495080 | 2020-09-02 | Hale | Texas | 48189 | 1651 | 47 |
495081 | 495081 | 2020-09-02 | Hall | Texas | 48191 | 16 | 1 |
495082 | 495082 | 2020-09-02 | Hamilton | Texas | 48193 | 105 | 3 |
495083 | 495083 | 2020-09-02 | Hansford | Texas | 48195 | 102 | 3 |
495084 | 495084 | 2020-09-02 | Hardeman | Texas | 48197 | 22 | 0 |
495085 | 495085 | 2020-09-02 | Hardin | Texas | 48199 | 1166 | 21 |
495086 | 495086 | 2020-09-02 | Harris | Texas | 48201 | 108085 | 2247 |
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);