ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
204 rows where date = "2020-04-26" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
91941 | 91941 | 2020-04-26 | Anderson | Texas | 48001 | 18 | 0 |
91942 | 91942 | 2020-04-26 | Andrews | Texas | 48003 | 19 | 0 |
91943 | 91943 | 2020-04-26 | Angelina | Texas | 48005 | 36 | 0 |
91944 | 91944 | 2020-04-26 | Aransas | Texas | 48007 | 2 | 0 |
91945 | 91945 | 2020-04-26 | Armstrong | Texas | 48011 | 2 | 0 |
91946 | 91946 | 2020-04-26 | Atascosa | Texas | 48013 | 14 | 1 |
91947 | 91947 | 2020-04-26 | Austin | Texas | 48015 | 12 | 0 |
91948 | 91948 | 2020-04-26 | Bandera | Texas | 48019 | 6 | 0 |
91949 | 91949 | 2020-04-26 | Bastrop | Texas | 48021 | 58 | 2 |
91950 | 91950 | 2020-04-26 | Bee | Texas | 48025 | 6 | 0 |
91951 | 91951 | 2020-04-26 | Bell | Texas | 48027 | 165 | 3 |
91952 | 91952 | 2020-04-26 | Bexar | Texas | 48029 | 1254 | 43 |
91953 | 91953 | 2020-04-26 | Blanco | Texas | 48031 | 6 | 0 |
91954 | 91954 | 2020-04-26 | Bosque | Texas | 48035 | 4 | 0 |
91955 | 91955 | 2020-04-26 | Bowie | Texas | 48037 | 93 | 7 |
91956 | 91956 | 2020-04-26 | Brazoria | Texas | 48039 | 449 | 3 |
91957 | 91957 | 2020-04-26 | Brazos | Texas | 48041 | 182 | 16 |
91958 | 91958 | 2020-04-26 | Brooks | Texas | 48047 | 1 | 0 |
91959 | 91959 | 2020-04-26 | Brown | Texas | 48049 | 17 | 1 |
91960 | 91960 | 2020-04-26 | Burleson | Texas | 48051 | 11 | 0 |
91961 | 91961 | 2020-04-26 | Burnet | Texas | 48053 | 14 | 0 |
91962 | 91962 | 2020-04-26 | Caldwell | Texas | 48055 | 11 | 0 |
91963 | 91963 | 2020-04-26 | Calhoun | Texas | 48057 | 26 | 2 |
91964 | 91964 | 2020-04-26 | Callahan | Texas | 48059 | 1 | 0 |
91965 | 91965 | 2020-04-26 | Cameron | Texas | 48061 | 366 | 14 |
91966 | 91966 | 2020-04-26 | Camp | Texas | 48063 | 6 | 0 |
91967 | 91967 | 2020-04-26 | Carson | Texas | 48065 | 1 | 0 |
91968 | 91968 | 2020-04-26 | Cass | Texas | 48067 | 16 | 2 |
91969 | 91969 | 2020-04-26 | Castro | Texas | 48069 | 13 | 1 |
91970 | 91970 | 2020-04-26 | Chambers | Texas | 48071 | 41 | 0 |
91971 | 91971 | 2020-04-26 | Cherokee | Texas | 48073 | 12 | 1 |
91972 | 91972 | 2020-04-26 | Childress | Texas | 48075 | 1 | 0 |
91973 | 91973 | 2020-04-26 | Clay | Texas | 48077 | 3 | 0 |
91974 | 91974 | 2020-04-26 | Cochran | Texas | 48079 | 1 | 0 |
91975 | 91975 | 2020-04-26 | Collin | Texas | 48085 | 663 | 17 |
91976 | 91976 | 2020-04-26 | Colorado | Texas | 48089 | 10 | 0 |
91977 | 91977 | 2020-04-26 | Comal | Texas | 48091 | 48 | 6 |
91978 | 91978 | 2020-04-26 | Comanche | Texas | 48093 | 3 | 0 |
91979 | 91979 | 2020-04-26 | Concho | Texas | 48095 | 1 | 0 |
91980 | 91980 | 2020-04-26 | Cooke | Texas | 48097 | 4 | 0 |
91981 | 91981 | 2020-04-26 | Coryell | Texas | 48099 | 105 | 1 |
91982 | 91982 | 2020-04-26 | Crane | Texas | 48103 | 2 | 0 |
91983 | 91983 | 2020-04-26 | Crosby | Texas | 48107 | 2 | 1 |
91984 | 91984 | 2020-04-26 | Dallam | Texas | 48111 | 8 | 1 |
91985 | 91985 | 2020-04-26 | Dallas | Texas | 48113 | 3014 | 82 |
91986 | 91986 | 2020-04-26 | Dawson | Texas | 48115 | 21 | 1 |
91987 | 91987 | 2020-04-26 | DeWitt | Texas | 48123 | 15 | 1 |
91988 | 91988 | 2020-04-26 | Deaf Smith | Texas | 48117 | 21 | 0 |
91989 | 91989 | 2020-04-26 | Delta | Texas | 48119 | 1 | 0 |
91990 | 91990 | 2020-04-26 | Denton | Texas | 48121 | 713 | 20 |
91991 | 91991 | 2020-04-26 | Dickens | Texas | 48125 | 1 | 0 |
91992 | 91992 | 2020-04-26 | Dimmit | Texas | 48127 | 1 | 0 |
91993 | 91993 | 2020-04-26 | Donley | Texas | 48129 | 24 | 0 |
91994 | 91994 | 2020-04-26 | Duval | Texas | 48131 | 2 | 0 |
91995 | 91995 | 2020-04-26 | Eastland | Texas | 48133 | 3 | 0 |
91996 | 91996 | 2020-04-26 | Ector | Texas | 48135 | 73 | 4 |
91997 | 91997 | 2020-04-26 | El Paso | Texas | 48141 | 802 | 12 |
91998 | 91998 | 2020-04-26 | Ellis | Texas | 48139 | 127 | 5 |
91999 | 91999 | 2020-04-26 | Erath | Texas | 48143 | 12 | 1 |
92000 | 92000 | 2020-04-26 | Falls | Texas | 48145 | 2 | 0 |
92001 | 92001 | 2020-04-26 | Fannin | Texas | 48147 | 15 | 0 |
92002 | 92002 | 2020-04-26 | Fayette | Texas | 48149 | 15 | 1 |
92003 | 92003 | 2020-04-26 | Floyd | Texas | 48153 | 3 | 0 |
92004 | 92004 | 2020-04-26 | Fort Bend | Texas | 48157 | 952 | 21 |
92005 | 92005 | 2020-04-26 | Franklin | Texas | 48159 | 1 | 0 |
92006 | 92006 | 2020-04-26 | Freestone | Texas | 48161 | 3 | 0 |
92007 | 92007 | 2020-04-26 | Frio | Texas | 48163 | 3 | 0 |
92008 | 92008 | 2020-04-26 | Gaines | Texas | 48165 | 2 | 0 |
92009 | 92009 | 2020-04-26 | Galveston | Texas | 48167 | 541 | 22 |
92010 | 92010 | 2020-04-26 | Gillespie | Texas | 48171 | 2 | 0 |
92011 | 92011 | 2020-04-26 | Goliad | Texas | 48175 | 7 | 0 |
92012 | 92012 | 2020-04-26 | Gonzales | Texas | 48177 | 12 | 1 |
92013 | 92013 | 2020-04-26 | Gray | Texas | 48179 | 37 | 0 |
92014 | 92014 | 2020-04-26 | Grayson | Texas | 48181 | 22 | 0 |
92015 | 92015 | 2020-04-26 | Gregg | Texas | 48183 | 62 | 0 |
92016 | 92016 | 2020-04-26 | Grimes | Texas | 48185 | 13 | 1 |
92017 | 92017 | 2020-04-26 | Guadalupe | Texas | 48187 | 68 | 0 |
92018 | 92018 | 2020-04-26 | Hale | Texas | 48189 | 19 | 4 |
92019 | 92019 | 2020-04-26 | Hamilton | Texas | 48193 | 5 | 0 |
92020 | 92020 | 2020-04-26 | Hansford | Texas | 48195 | 4 | 0 |
92021 | 92021 | 2020-04-26 | Hardin | Texas | 48199 | 95 | 3 |
92022 | 92022 | 2020-04-26 | Harris | Texas | 48201 | 5729 | 93 |
92023 | 92023 | 2020-04-26 | Harrison | Texas | 48203 | 71 | 2 |
92024 | 92024 | 2020-04-26 | Hartley | Texas | 48205 | 4 | 0 |
92025 | 92025 | 2020-04-26 | Hays | Texas | 48209 | 149 | 1 |
92026 | 92026 | 2020-04-26 | Hemphill | Texas | 48211 | 1 | 0 |
92027 | 92027 | 2020-04-26 | Henderson | Texas | 48213 | 24 | 0 |
92028 | 92028 | 2020-04-26 | Hidalgo | Texas | 48215 | 308 | 4 |
92029 | 92029 | 2020-04-26 | Hill | Texas | 48217 | 15 | 1 |
92030 | 92030 | 2020-04-26 | Hockley | Texas | 48219 | 20 | 1 |
92031 | 92031 | 2020-04-26 | Hood | Texas | 48221 | 17 | 3 |
92032 | 92032 | 2020-04-26 | Hopkins | Texas | 48223 | 4 | 0 |
92033 | 92033 | 2020-04-26 | Houston | Texas | 48225 | 4 | 0 |
92034 | 92034 | 2020-04-26 | Howard | Texas | 48227 | 4 | 1 |
92035 | 92035 | 2020-04-26 | Hunt | Texas | 48231 | 39 | 3 |
92036 | 92036 | 2020-04-26 | Hutchinson | Texas | 48233 | 11 | 0 |
92037 | 92037 | 2020-04-26 | Jack | Texas | 48237 | 4 | 0 |
92038 | 92038 | 2020-04-26 | Jackson | Texas | 48239 | 6 | 0 |
92039 | 92039 | 2020-04-26 | Jasper | Texas | 48241 | 12 | 1 |
92040 | 92040 | 2020-04-26 | Jefferson | Texas | 48245 | 266 | 18 |
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);