ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
181 rows where "date" is on date 2020-04-13 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 |
---|---|---|---|---|---|---|---|
55939 | 55939 | 2020-04-13 | Anderson | Texas | 48001 | 3 | 0 |
55940 | 55940 | 2020-04-13 | Andrews | Texas | 48003 | 12 | 0 |
55941 | 55941 | 2020-04-13 | Angelina | Texas | 48005 | 16 | 0 |
55942 | 55942 | 2020-04-13 | Aransas | Texas | 48007 | 2 | 0 |
55943 | 55943 | 2020-04-13 | Atascosa | Texas | 48013 | 9 | 0 |
55944 | 55944 | 2020-04-13 | Austin | Texas | 48015 | 11 | 0 |
55945 | 55945 | 2020-04-13 | Bandera | Texas | 48019 | 2 | 0 |
55946 | 55946 | 2020-04-13 | Bastrop | Texas | 48021 | 27 | 1 |
55947 | 55947 | 2020-04-13 | Bee | Texas | 48025 | 2 | 0 |
55948 | 55948 | 2020-04-13 | Bell | Texas | 48027 | 101 | 3 |
55949 | 55949 | 2020-04-13 | Bexar | Texas | 48029 | 783 | 27 |
55950 | 55950 | 2020-04-13 | Blanco | Texas | 48031 | 4 | 0 |
55951 | 55951 | 2020-04-13 | Bowie | Texas | 48037 | 51 | 5 |
55952 | 55952 | 2020-04-13 | Brazoria | Texas | 48039 | 250 | 2 |
55953 | 55953 | 2020-04-13 | Brazos | Texas | 48041 | 143 | 12 |
55954 | 55954 | 2020-04-13 | Brown | Texas | 48049 | 10 | 1 |
55955 | 55955 | 2020-04-13 | Burleson | Texas | 48051 | 6 | 0 |
55956 | 55956 | 2020-04-13 | Burnet | Texas | 48053 | 6 | 0 |
55957 | 55957 | 2020-04-13 | Caldwell | Texas | 48055 | 6 | 0 |
55958 | 55958 | 2020-04-13 | Calhoun | Texas | 48057 | 15 | 0 |
55959 | 55959 | 2020-04-13 | Callahan | Texas | 48059 | 1 | 0 |
55960 | 55960 | 2020-04-13 | Cameron | Texas | 48061 | 195 | 3 |
55961 | 55961 | 2020-04-13 | Camp | Texas | 48063 | 3 | 0 |
55962 | 55962 | 2020-04-13 | Cass | Texas | 48067 | 5 | 2 |
55963 | 55963 | 2020-04-13 | Castro | Texas | 48069 | 11 | 1 |
55964 | 55964 | 2020-04-13 | Chambers | Texas | 48071 | 29 | 0 |
55965 | 55965 | 2020-04-13 | Cherokee | Texas | 48073 | 6 | 0 |
55966 | 55966 | 2020-04-13 | Clay | Texas | 48077 | 3 | 0 |
55967 | 55967 | 2020-04-13 | Collin | Texas | 48085 | 472 | 10 |
55968 | 55968 | 2020-04-13 | Colorado | Texas | 48089 | 7 | 0 |
55969 | 55969 | 2020-04-13 | Comal | Texas | 48091 | 38 | 6 |
55970 | 55970 | 2020-04-13 | Comanche | Texas | 48093 | 3 | 0 |
55971 | 55971 | 2020-04-13 | Concho | Texas | 48095 | 1 | 0 |
55972 | 55972 | 2020-04-13 | Cooke | Texas | 48097 | 1 | 0 |
55973 | 55973 | 2020-04-13 | Coryell | Texas | 48099 | 34 | 0 |
55974 | 55974 | 2020-04-13 | Crane | Texas | 48103 | 2 | 0 |
55975 | 55975 | 2020-04-13 | Crosby | Texas | 48107 | 1 | 0 |
55976 | 55976 | 2020-04-13 | Dallam | Texas | 48111 | 1 | 0 |
55977 | 55977 | 2020-04-13 | Dallas | Texas | 48113 | 1788 | 32 |
55978 | 55978 | 2020-04-13 | Dawson | Texas | 48115 | 8 | 1 |
55979 | 55979 | 2020-04-13 | DeWitt | Texas | 48123 | 9 | 0 |
55980 | 55980 | 2020-04-13 | Deaf Smith | Texas | 48117 | 8 | 0 |
55981 | 55981 | 2020-04-13 | Delta | Texas | 48119 | 1 | 0 |
55982 | 55982 | 2020-04-13 | Denton | Texas | 48121 | 507 | 13 |
55983 | 55983 | 2020-04-13 | Dickens | Texas | 48125 | 1 | 0 |
55984 | 55984 | 2020-04-13 | Dimmit | Texas | 48127 | 1 | 0 |
55985 | 55985 | 2020-04-13 | Donley | Texas | 48129 | 23 | 0 |
55986 | 55986 | 2020-04-13 | Eastland | Texas | 48133 | 3 | 0 |
55987 | 55987 | 2020-04-13 | Ector | Texas | 48135 | 45 | 2 |
55988 | 55988 | 2020-04-13 | El Paso | Texas | 48141 | 300 | 2 |
55989 | 55989 | 2020-04-13 | Ellis | Texas | 48139 | 73 | 3 |
55990 | 55990 | 2020-04-13 | Erath | Texas | 48143 | 12 | 1 |
55991 | 55991 | 2020-04-13 | Falls | Texas | 48145 | 1 | 0 |
55992 | 55992 | 2020-04-13 | Fannin | Texas | 48147 | 5 | 0 |
55993 | 55993 | 2020-04-13 | Fayette | Texas | 48149 | 17 | 0 |
55994 | 55994 | 2020-04-13 | Floyd | Texas | 48153 | 1 | 0 |
55995 | 55995 | 2020-04-13 | Fort Bend | Texas | 48157 | 543 | 12 |
55996 | 55996 | 2020-04-13 | Franklin | Texas | 48159 | 1 | 0 |
55997 | 55997 | 2020-04-13 | Frio | Texas | 48163 | 1 | 0 |
55998 | 55998 | 2020-04-13 | Gaines | Texas | 48165 | 2 | 0 |
55999 | 55999 | 2020-04-13 | Galveston | Texas | 48167 | 377 | 9 |
56000 | 56000 | 2020-04-13 | Gillespie | Texas | 48171 | 2 | 0 |
56001 | 56001 | 2020-04-13 | Goliad | Texas | 48175 | 4 | 0 |
56002 | 56002 | 2020-04-13 | Gonzales | Texas | 48177 | 2 | 0 |
56003 | 56003 | 2020-04-13 | Gray | Texas | 48179 | 13 | 0 |
56004 | 56004 | 2020-04-13 | Grayson | Texas | 48181 | 17 | 0 |
56005 | 56005 | 2020-04-13 | Gregg | Texas | 48183 | 39 | 0 |
56006 | 56006 | 2020-04-13 | Grimes | Texas | 48185 | 7 | 0 |
56007 | 56007 | 2020-04-13 | Guadalupe | Texas | 48187 | 49 | 0 |
56008 | 56008 | 2020-04-13 | Hale | Texas | 48189 | 11 | 2 |
56009 | 56009 | 2020-04-13 | Hamilton | Texas | 48193 | 2 | 0 |
56010 | 56010 | 2020-04-13 | Hansford | Texas | 48195 | 1 | 0 |
56011 | 56011 | 2020-04-13 | Hardin | Texas | 48199 | 61 | 2 |
56012 | 56012 | 2020-04-13 | Harris | Texas | 48201 | 3747 | 46 |
56013 | 56013 | 2020-04-13 | Harrison | Texas | 48203 | 16 | 2 |
56014 | 56014 | 2020-04-13 | Hays | Texas | 48209 | 93 | 1 |
56015 | 56015 | 2020-04-13 | Hemphill | Texas | 48211 | 1 | 0 |
56016 | 56016 | 2020-04-13 | Henderson | Texas | 48213 | 10 | 0 |
56017 | 56017 | 2020-04-13 | Hidalgo | Texas | 48215 | 190 | 1 |
56018 | 56018 | 2020-04-13 | Hill | Texas | 48217 | 8 | 0 |
56019 | 56019 | 2020-04-13 | Hockley | Texas | 48219 | 14 | 1 |
56020 | 56020 | 2020-04-13 | Hood | Texas | 48221 | 16 | 1 |
56021 | 56021 | 2020-04-13 | Hopkins | Texas | 48223 | 4 | 0 |
56022 | 56022 | 2020-04-13 | Howard | Texas | 48227 | 1 | 1 |
56023 | 56023 | 2020-04-13 | Hunt | Texas | 48231 | 18 | 1 |
56024 | 56024 | 2020-04-13 | Hutchinson | Texas | 48233 | 3 | 0 |
56025 | 56025 | 2020-04-13 | Jack | Texas | 48237 | 1 | 0 |
56026 | 56026 | 2020-04-13 | Jackson | Texas | 48239 | 4 | 0 |
56027 | 56027 | 2020-04-13 | Jasper | Texas | 48241 | 7 | 1 |
56028 | 56028 | 2020-04-13 | Jefferson | Texas | 48245 | 124 | 6 |
56029 | 56029 | 2020-04-13 | Jim Wells | Texas | 48249 | 2 | 0 |
56030 | 56030 | 2020-04-13 | Johnson | Texas | 48251 | 35 | 1 |
56031 | 56031 | 2020-04-13 | Jones | Texas | 48253 | 2 | 0 |
56032 | 56032 | 2020-04-13 | Karnes | Texas | 48255 | 2 | 0 |
56033 | 56033 | 2020-04-13 | Kaufman | Texas | 48257 | 28 | 0 |
56034 | 56034 | 2020-04-13 | Kendall | Texas | 48259 | 11 | 0 |
56035 | 56035 | 2020-04-13 | Kerr | Texas | 48265 | 2 | 0 |
56036 | 56036 | 2020-04-13 | Kleberg | Texas | 48273 | 2 | 1 |
56037 | 56037 | 2020-04-13 | Knox | Texas | 48275 | 1 | 0 |
56038 | 56038 | 2020-04-13 | Lamar | Texas | 48277 | 8 | 0 |
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);