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 2021-11-03 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1880973 | 1880973 | 2021-11-03 | Anderson | Texas | 48001 | 8056 | 199 |
1880974 | 1880974 | 2021-11-03 | Andrews | Texas | 48003 | 2897 | 56 |
1880975 | 1880975 | 2021-11-03 | Angelina | Texas | 48005 | 13748 | 406 |
1880976 | 1880976 | 2021-11-03 | Aransas | Texas | 48007 | 2600 | 66 |
1880977 | 1880977 | 2021-11-03 | Archer | Texas | 48009 | 1271 | 22 |
1880978 | 1880978 | 2021-11-03 | Armstrong | Texas | 48011 | 287 | 7 |
1880979 | 1880979 | 2021-11-03 | Atascosa | Texas | 48013 | 8566 | 204 |
1880980 | 1880980 | 2021-11-03 | Austin | Texas | 48015 | 3540 | 53 |
1880981 | 1880981 | 2021-11-03 | Bailey | Texas | 48017 | 1006 | 25 |
1880982 | 1880982 | 2021-11-03 | Bandera | Texas | 48019 | 2333 | 54 |
1880983 | 1880983 | 2021-11-03 | Bastrop | Texas | 48021 | 14403 | 175 |
1880984 | 1880984 | 2021-11-03 | Baylor | Texas | 48023 | 568 | 24 |
1880985 | 1880985 | 2021-11-03 | Bee | Texas | 48025 | 5318 | 127 |
1880986 | 1880986 | 2021-11-03 | Bell | Texas | 48027 | 38808 | 714 |
1880987 | 1880987 | 2021-11-03 | Bexar | Texas | 48029 | 322157 | 5139 |
1880988 | 1880988 | 2021-11-03 | Blanco | Texas | 48031 | 1274 | 28 |
1880989 | 1880989 | 2021-11-03 | Borden | Texas | 48033 | 42 | 2 |
1880990 | 1880990 | 2021-11-03 | Bosque | Texas | 48035 | 2434 | 56 |
1880991 | 1880991 | 2021-11-03 | Bowie | Texas | 48037 | 12740 | 329 |
1880992 | 1880992 | 2021-11-03 | Brazoria | Texas | 48039 | 59916 | 833 |
1880993 | 1880993 | 2021-11-03 | Brazos | Texas | 48041 | 38660 | 359 |
1880994 | 1880994 | 2021-11-03 | Brewster | Texas | 48043 | 1097 | 22 |
1880995 | 1880995 | 2021-11-03 | Briscoe | Texas | 48045 | 232 | 7 |
1880996 | 1880996 | 2021-11-03 | Brooks | Texas | 48047 | 1125 | 47 |
1880997 | 1880997 | 2021-11-03 | Brown | Texas | 48049 | 7038 | 186 |
1880998 | 1880998 | 2021-11-03 | Burleson | Texas | 48051 | 3278 | 59 |
1880999 | 1880999 | 2021-11-03 | Burnet | Texas | 48053 | 7414 | 127 |
1881000 | 1881000 | 2021-11-03 | Caldwell | Texas | 48055 | 8404 | 152 |
1881001 | 1881001 | 2021-11-03 | Calhoun | Texas | 48057 | 3911 | 36 |
1881002 | 1881002 | 2021-11-03 | Callahan | Texas | 48059 | 1851 | 55 |
1881003 | 1881003 | 2021-11-03 | Cameron | Texas | 48061 | 66052 | 1975 |
1881004 | 1881004 | 2021-11-03 | Camp | Texas | 48063 | 2021 | 67 |
1881005 | 1881005 | 2021-11-03 | Carson | Texas | 48065 | 787 | 24 |
1881006 | 1881006 | 2021-11-03 | Cass | Texas | 48067 | 4490 | 147 |
1881007 | 1881007 | 2021-11-03 | Castro | Texas | 48069 | 1342 | 37 |
1881008 | 1881008 | 2021-11-03 | Chambers | Texas | 48071 | 8826 | 98 |
1881009 | 1881009 | 2021-11-03 | Cherokee | Texas | 48073 | 6826 | 222 |
1881010 | 1881010 | 2021-11-03 | Childress | Texas | 48075 | 1602 | 21 |
1881011 | 1881011 | 2021-11-03 | Clay | Texas | 48077 | 1554 | 23 |
1881012 | 1881012 | 2021-11-03 | Cochran | Texas | 48079 | 451 | 18 |
1881013 | 1881013 | 2021-11-03 | Coke | Texas | 48081 | 678 | 17 |
1881014 | 1881014 | 2021-11-03 | Coleman | Texas | 48083 | 1160 | 54 |
1881015 | 1881015 | 2021-11-03 | Collin | Texas | 48085 | 129803 | 1131 |
1881016 | 1881016 | 2021-11-03 | Collingsworth | Texas | 48087 | 399 | 11 |
1881017 | 1881017 | 2021-11-03 | Colorado | Texas | 48089 | 2561 | 51 |
1881018 | 1881018 | 2021-11-03 | Comal | Texas | 48091 | 19618 | 455 |
1881019 | 1881019 | 2021-11-03 | Comanche | Texas | 48093 | 2235 | 64 |
1881020 | 1881020 | 2021-11-03 | Concho | Texas | 48095 | 704 | 10 |
1881021 | 1881021 | 2021-11-03 | Cooke | Texas | 48097 | 5153 | 101 |
1881022 | 1881022 | 2021-11-03 | Coryell | Texas | 48099 | 10766 | 162 |
1881023 | 1881023 | 2021-11-03 | Cottle | Texas | 48101 | 228 | 9 |
1881024 | 1881024 | 2021-11-03 | Crane | Texas | 48103 | 872 | 18 |
1881025 | 1881025 | 2021-11-03 | Crockett | Texas | 48105 | 781 | 16 |
1881026 | 1881026 | 2021-11-03 | Crosby | Texas | 48107 | 1012 | 37 |
1881027 | 1881027 | 2021-11-03 | Culberson | Texas | 48109 | 392 | 11 |
1881028 | 1881028 | 2021-11-03 | Dallam | Texas | 48111 | 1225 | 30 |
1881029 | 1881029 | 2021-11-03 | Dallas | Texas | 48113 | 406078 | 5389 |
1881030 | 1881030 | 2021-11-03 | Dawson | Texas | 48115 | 2176 | 78 |
1881031 | 1881031 | 2021-11-03 | DeWitt | Texas | 48123 | 2948 | 82 |
1881032 | 1881032 | 2021-11-03 | Deaf Smith | Texas | 48117 | 3414 | 79 |
1881033 | 1881033 | 2021-11-03 | Delta | Texas | 48119 | 615 | 21 |
1881034 | 1881034 | 2021-11-03 | Denton | Texas | 48121 | 108279 | 1015 |
1881035 | 1881035 | 2021-11-03 | Dickens | Texas | 48125 | 249 | 13 |
1881036 | 1881036 | 2021-11-03 | Dimmit | Texas | 48127 | 3783 | 46 |
1881037 | 1881037 | 2021-11-03 | Donley | Texas | 48129 | 592 | 18 |
1881038 | 1881038 | 2021-11-03 | Duval | Texas | 48131 | 1956 | 58 |
1881039 | 1881039 | 2021-11-03 | Eastland | Texas | 48133 | 2175 | 78 |
1881040 | 1881040 | 2021-11-03 | Ector | Texas | 48135 | 25841 | 536 |
1881041 | 1881041 | 2021-11-03 | Edwards | Texas | 48137 | 325 | 7 |
1881042 | 1881042 | 2021-11-03 | El Paso | Texas | 48141 | 150030 | 2881 |
1881043 | 1881043 | 2021-11-03 | Ellis | Texas | 48139 | 33828 | 467 |
1881044 | 1881044 | 2021-11-03 | Erath | Texas | 48143 | 6359 | 102 |
1881045 | 1881045 | 2021-11-03 | Falls | Texas | 48145 | 2616 | 48 |
1881046 | 1881046 | 2021-11-03 | Fannin | Texas | 48147 | 5021 | 152 |
1881047 | 1881047 | 2021-11-03 | Fayette | Texas | 48149 | 3599 | 93 |
1881048 | 1881048 | 2021-11-03 | Fisher | Texas | 48151 | 419 | 16 |
1881049 | 1881049 | 2021-11-03 | Floyd | Texas | 48153 | 1181 | 39 |
1881050 | 1881050 | 2021-11-03 | Foard | Texas | 48155 | 181 | 10 |
1881051 | 1881051 | 2021-11-03 | Fort Bend | Texas | 48157 | 100421 | 979 |
1881052 | 1881052 | 2021-11-03 | Franklin | Texas | 48159 | 1342 | 35 |
1881053 | 1881053 | 2021-11-03 | Freestone | Texas | 48161 | 2765 | 68 |
1881054 | 1881054 | 2021-11-03 | Frio | Texas | 48163 | 3949 | 71 |
1881055 | 1881055 | 2021-11-03 | Gaines | Texas | 48165 | 2168 | 60 |
1881056 | 1881056 | 2021-11-03 | Galveston | Texas | 48167 | 64343 | 698 |
1881057 | 1881057 | 2021-11-03 | Garza | Texas | 48169 | 723 | 22 |
1881058 | 1881058 | 2021-11-03 | Gillespie | Texas | 48171 | 3533 | 79 |
1881059 | 1881059 | 2021-11-03 | Glasscock | Texas | 48173 | 155 | 3 |
1881060 | 1881060 | 2021-11-03 | Goliad | Texas | 48175 | 699 | 28 |
1881061 | 1881061 | 2021-11-03 | Gonzales | Texas | 48177 | 3549 | 85 |
1881062 | 1881062 | 2021-11-03 | Gray | Texas | 48179 | 3532 | 80 |
1881063 | 1881063 | 2021-11-03 | Grayson | Texas | 48181 | 16291 | 495 |
1881064 | 1881064 | 2021-11-03 | Gregg | Texas | 48183 | 19295 | 547 |
1881065 | 1881065 | 2021-11-03 | Grimes | Texas | 48185 | 5171 | 107 |
1881066 | 1881066 | 2021-11-03 | Guadalupe | Texas | 48187 | 24448 | 338 |
1881067 | 1881067 | 2021-11-03 | Hale | Texas | 48189 | 7986 | 190 |
1881068 | 1881068 | 2021-11-03 | Hall | Texas | 48191 | 552 | 15 |
1881069 | 1881069 | 2021-11-03 | Hamilton | Texas | 48193 | 1310 | 29 |
1881070 | 1881070 | 2021-11-03 | Hansford | Texas | 48195 | 1136 | 25 |
1881071 | 1881071 | 2021-11-03 | Hardeman | Texas | 48197 | 454 | 14 |
1881072 | 1881072 | 2021-11-03 | Hardin | Texas | 48199 | 10389 | 209 |
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);