ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
254 rows where "date" is on date 2020-12-26 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
867889 | 867889 | 2020-12-26 | Anderson | Texas | 48001 | 4270 | 57 |
867890 | 867890 | 2020-12-26 | Andrews | Texas | 48003 | 1361 | 23 |
867891 | 867891 | 2020-12-26 | Angelina | Texas | 48005 | 5186 | 136 |
867892 | 867892 | 2020-12-26 | Aransas | Texas | 48007 | 691 | 22 |
867893 | 867893 | 2020-12-26 | Archer | Texas | 48009 | 494 | 5 |
867894 | 867894 | 2020-12-26 | Armstrong | Texas | 48011 | 105 | 5 |
867895 | 867895 | 2020-12-26 | Atascosa | Texas | 48013 | 2878 | 60 |
867896 | 867896 | 2020-12-26 | Austin | Texas | 48015 | 962 | 14 |
867897 | 867897 | 2020-12-26 | Bailey | Texas | 48017 | 715 | 11 |
867898 | 867898 | 2020-12-26 | Bandera | Texas | 48019 | 551 | 12 |
867899 | 867899 | 2020-12-26 | Bastrop | Texas | 48021 | 3557 | 42 |
867900 | 867900 | 2020-12-26 | Baylor | Texas | 48023 | 185 | 7 |
867901 | 867901 | 2020-12-26 | Bee | Texas | 48025 | 2548 | 44 |
867902 | 867902 | 2020-12-26 | Bell | Texas | 48027 | 11802 | 159 |
867903 | 867903 | 2020-12-26 | Bexar | Texas | 48029 | 106805 | 1685 |
867904 | 867904 | 2020-12-26 | Blanco | Texas | 48031 | 273 | 7 |
867905 | 867905 | 2020-12-26 | Borden | Texas | 48033 | 18 | 0 |
867906 | 867906 | 2020-12-26 | Bosque | Texas | 48035 | 742 | 16 |
867907 | 867907 | 2020-12-26 | Bowie | Texas | 48037 | 3816 | 119 |
867908 | 867908 | 2020-12-26 | Brazoria | Texas | 48039 | 19992 | 229 |
867909 | 867909 | 2020-12-26 | Brazos | Texas | 48041 | 13601 | 135 |
867910 | 867910 | 2020-12-26 | Brewster | Texas | 48043 | 869 | 7 |
867911 | 867911 | 2020-12-26 | Briscoe | Texas | 48045 | 87 | 2 |
867912 | 867912 | 2020-12-26 | Brooks | Texas | 48047 | 583 | 27 |
867913 | 867913 | 2020-12-26 | Brown | Texas | 48049 | 2543 | 62 |
867914 | 867914 | 2020-12-26 | Burleson | Texas | 48051 | 915 | 14 |
867915 | 867915 | 2020-12-26 | Burnet | Texas | 48053 | 1903 | 26 |
867916 | 867916 | 2020-12-26 | Caldwell | Texas | 48055 | 2292 | 40 |
867917 | 867917 | 2020-12-26 | Calhoun | Texas | 48057 | 1184 | 10 |
867918 | 867918 | 2020-12-26 | Callahan | Texas | 48059 | 700 | 15 |
867919 | 867919 | 2020-12-26 | Cameron | Texas | 48061 | 28875 | 1172 |
867920 | 867920 | 2020-12-26 | Camp | Texas | 48063 | 733 | 23 |
867921 | 867921 | 2020-12-26 | Carson | Texas | 48065 | 278 | 8 |
867922 | 867922 | 2020-12-26 | Cass | Texas | 48067 | 1261 | 45 |
867923 | 867923 | 2020-12-26 | Castro | Texas | 48069 | 768 | 13 |
867924 | 867924 | 2020-12-26 | Chambers | Texas | 48071 | 2627 | 26 |
867925 | 867925 | 2020-12-26 | Cherokee | Texas | 48073 | 2943 | 71 |
867926 | 867926 | 2020-12-26 | Childress | Texas | 48075 | 1181 | 7 |
867927 | 867927 | 2020-12-26 | Clay | Texas | 48077 | 638 | 10 |
867928 | 867928 | 2020-12-26 | Cochran | Texas | 48079 | 198 | 7 |
867929 | 867929 | 2020-12-26 | Coke | Texas | 48081 | 376 | 10 |
867930 | 867930 | 2020-12-26 | Coleman | Texas | 48083 | 342 | 15 |
867931 | 867931 | 2020-12-26 | Collin | Texas | 48085 | 45092 | 350 |
867932 | 867932 | 2020-12-26 | Collingsworth | Texas | 48087 | 206 | 5 |
867933 | 867933 | 2020-12-26 | Colorado | Texas | 48089 | 989 | 14 |
867934 | 867934 | 2020-12-26 | Comal | Texas | 48091 | 6000 | 146 |
867935 | 867935 | 2020-12-26 | Comanche | Texas | 48093 | 938 | 26 |
867936 | 867936 | 2020-12-26 | Concho | Texas | 48095 | 200 | 3 |
867937 | 867937 | 2020-12-26 | Cooke | Texas | 48097 | 2092 | 28 |
867938 | 867938 | 2020-12-26 | Coryell | Texas | 48099 | 3273 | 29 |
867939 | 867939 | 2020-12-26 | Cottle | Texas | 48101 | 139 | 5 |
867940 | 867940 | 2020-12-26 | Crane | Texas | 48103 | 497 | 9 |
867941 | 867941 | 2020-12-26 | Crockett | Texas | 48105 | 503 | 9 |
867942 | 867942 | 2020-12-26 | Crosby | Texas | 48107 | 326 | 18 |
867943 | 867943 | 2020-12-26 | Culberson | Texas | 48109 | 308 | 3 |
867944 | 867944 | 2020-12-26 | Dallam | Texas | 48111 | 486 | 18 |
867945 | 867945 | 2020-12-26 | Dallas | Texas | 48113 | 180806 | 1925 |
867946 | 867946 | 2020-12-26 | Dawson | Texas | 48115 | 1382 | 47 |
867947 | 867947 | 2020-12-26 | DeWitt | Texas | 48123 | 1411 | 47 |
867948 | 867948 | 2020-12-26 | Deaf Smith | Texas | 48117 | 2370 | 54 |
867949 | 867949 | 2020-12-26 | Delta | Texas | 48119 | 139 | 3 |
867950 | 867950 | 2020-12-26 | Denton | Texas | 48121 | 36813 | 320 |
867951 | 867951 | 2020-12-26 | Dickens | Texas | 48125 | 115 | 7 |
867952 | 867952 | 2020-12-26 | Dimmit | Texas | 48127 | 619 | 11 |
867953 | 867953 | 2020-12-26 | Donley | Texas | 48129 | 228 | 6 |
867954 | 867954 | 2020-12-26 | Duval | Texas | 48131 | 818 | 28 |
867955 | 867955 | 2020-12-26 | Eastland | Texas | 48133 | 770 | 14 |
867956 | 867956 | 2020-12-26 | Ector | Texas | 48135 | 11463 | 218 |
867957 | 867957 | 2020-12-26 | Edwards | Texas | 48137 | 182 | 2 |
867958 | 867958 | 2020-12-26 | El Paso | Texas | 48141 | 97053 | 1610 |
867959 | 867959 | 2020-12-26 | Ellis | Texas | 48139 | 11961 | 159 |
867960 | 867960 | 2020-12-26 | Erath | Texas | 48143 | 2809 | 29 |
867961 | 867961 | 2020-12-26 | Falls | Texas | 48145 | 1087 | 16 |
867962 | 867962 | 2020-12-26 | Fannin | Texas | 48147 | 1730 | 49 |
867963 | 867963 | 2020-12-26 | Fayette | Texas | 48149 | 1239 | 32 |
867964 | 867964 | 2020-12-26 | Fisher | Texas | 48151 | 212 | 9 |
867965 | 867965 | 2020-12-26 | Floyd | Texas | 48153 | 517 | 21 |
867966 | 867966 | 2020-12-26 | Foard | Texas | 48155 | 64 | 4 |
867967 | 867967 | 2020-12-26 | Fort Bend | Texas | 48157 | 33985 | 377 |
867968 | 867968 | 2020-12-26 | Franklin | Texas | 48159 | 415 | 11 |
867969 | 867969 | 2020-12-26 | Freestone | Texas | 48161 | 885 | 22 |
867970 | 867970 | 2020-12-26 | Frio | Texas | 48163 | 1731 | 12 |
867971 | 867971 | 2020-12-26 | Gaines | Texas | 48165 | 1201 | 26 |
867972 | 867972 | 2020-12-26 | Galveston | Texas | 48167 | 19806 | 211 |
867973 | 867973 | 2020-12-26 | Garza | Texas | 48169 | 251 | 16 |
867974 | 867974 | 2020-12-26 | Gillespie | Texas | 48171 | 1369 | 18 |
867975 | 867975 | 2020-12-26 | Glasscock | Texas | 48173 | 90 | 1 |
867976 | 867976 | 2020-12-26 | Goliad | Texas | 48175 | 272 | 8 |
867977 | 867977 | 2020-12-26 | Gonzales | Texas | 48177 | 1599 | 25 |
867978 | 867978 | 2020-12-26 | Gray | Texas | 48179 | 1645 | 31 |
867979 | 867979 | 2020-12-26 | Grayson | Texas | 48181 | 6311 | 153 |
867980 | 867980 | 2020-12-26 | Gregg | Texas | 48183 | 6548 | 154 |
867981 | 867981 | 2020-12-26 | Grimes | Texas | 48185 | 1745 | 41 |
867982 | 867982 | 2020-12-26 | Guadalupe | Texas | 48187 | 6791 | 102 |
867983 | 867983 | 2020-12-26 | Hale | Texas | 48189 | 4953 | 119 |
867984 | 867984 | 2020-12-26 | Hall | Texas | 48191 | 211 | 5 |
867985 | 867985 | 2020-12-26 | Hamilton | Texas | 48193 | 444 | 15 |
867986 | 867986 | 2020-12-26 | Hansford | Texas | 48195 | 561 | 12 |
867987 | 867987 | 2020-12-26 | Hardeman | Texas | 48197 | 242 | 8 |
867988 | 867988 | 2020-12-26 | Hardin | Texas | 48199 | 3178 | 48 |
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);