ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
254 rows where date = "2021-11-19" 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 |
---|---|---|---|---|---|---|---|
1932970 | 1932970 | 2021-11-19 | Anderson | Texas | 48001 | 8082 | 204 |
1932971 | 1932971 | 2021-11-19 | Andrews | Texas | 48003 | 2920 | 64 |
1932972 | 1932972 | 2021-11-19 | Angelina | Texas | 48005 | 13852 | 418 |
1932973 | 1932973 | 2021-11-19 | Aransas | Texas | 48007 | 2610 | 66 |
1932974 | 1932974 | 2021-11-19 | Archer | Texas | 48009 | 1296 | 23 |
1932975 | 1932975 | 2021-11-19 | Armstrong | Texas | 48011 | 296 | 7 |
1932976 | 1932976 | 2021-11-19 | Atascosa | Texas | 48013 | 8684 | 206 |
1932977 | 1932977 | 2021-11-19 | Austin | Texas | 48015 | 3625 | 56 |
1932978 | 1932978 | 2021-11-19 | Bailey | Texas | 48017 | 1017 | 28 |
1932979 | 1932979 | 2021-11-19 | Bandera | Texas | 48019 | 2411 | 61 |
1932980 | 1932980 | 2021-11-19 | Bastrop | Texas | 48021 | 14463 | 183 |
1932981 | 1932981 | 2021-11-19 | Baylor | Texas | 48023 | 580 | 24 |
1932982 | 1932982 | 2021-11-19 | Bee | Texas | 48025 | 5344 | 132 |
1932983 | 1932983 | 2021-11-19 | Bell | Texas | 48027 | 39472 | 734 |
1932984 | 1932984 | 2021-11-19 | Bexar | Texas | 48029 | 325502 | 5248 |
1932985 | 1932985 | 2021-11-19 | Blanco | Texas | 48031 | 1270 | 28 |
1932986 | 1932986 | 2021-11-19 | Borden | Texas | 48033 | 43 | 2 |
1932987 | 1932987 | 2021-11-19 | Bosque | Texas | 48035 | 2447 | 57 |
1932988 | 1932988 | 2021-11-19 | Bowie | Texas | 48037 | 12848 | 342 |
1932989 | 1932989 | 2021-11-19 | Brazoria | Texas | 48039 | 60525 | 848 |
1932990 | 1932990 | 2021-11-19 | Brazos | Texas | 48041 | 38929 | 363 |
1932991 | 1932991 | 2021-11-19 | Brewster | Texas | 48043 | 1102 | 22 |
1932992 | 1932992 | 2021-11-19 | Briscoe | Texas | 48045 | 236 | 7 |
1932993 | 1932993 | 2021-11-19 | Brooks | Texas | 48047 | 1125 | 47 |
1932994 | 1932994 | 2021-11-19 | Brown | Texas | 48049 | 7137 | 191 |
1932995 | 1932995 | 2021-11-19 | Burleson | Texas | 48051 | 3301 | 60 |
1932996 | 1932996 | 2021-11-19 | Burnet | Texas | 48053 | 7494 | 130 |
1932997 | 1932997 | 2021-11-19 | Caldwell | Texas | 48055 | 8491 | 153 |
1932998 | 1932998 | 2021-11-19 | Calhoun | Texas | 48057 | 3911 | 36 |
1932999 | 1932999 | 2021-11-19 | Callahan | Texas | 48059 | 1874 | 57 |
1933000 | 1933000 | 2021-11-19 | Cameron | Texas | 48061 | 66674 | 1998 |
1933001 | 1933001 | 2021-11-19 | Camp | Texas | 48063 | 2036 | 67 |
1933002 | 1933002 | 2021-11-19 | Carson | Texas | 48065 | 824 | 24 |
1933003 | 1933003 | 2021-11-19 | Cass | Texas | 48067 | 4509 | 152 |
1933004 | 1933004 | 2021-11-19 | Castro | Texas | 48069 | 1362 | 38 |
1933005 | 1933005 | 2021-11-19 | Chambers | Texas | 48071 | 8856 | 99 |
1933006 | 1933006 | 2021-11-19 | Cherokee | Texas | 48073 | 6864 | 227 |
1933007 | 1933007 | 2021-11-19 | Childress | Texas | 48075 | 1608 | 21 |
1933008 | 1933008 | 2021-11-19 | Clay | Texas | 48077 | 1575 | 25 |
1933009 | 1933009 | 2021-11-19 | Cochran | Texas | 48079 | 479 | 19 |
1933010 | 1933010 | 2021-11-19 | Coke | Texas | 48081 | 683 | 18 |
1933011 | 1933011 | 2021-11-19 | Coleman | Texas | 48083 | 1170 | 54 |
1933012 | 1933012 | 2021-11-19 | Collin | Texas | 48085 | 131486 | 1158 |
1933013 | 1933013 | 2021-11-19 | Collingsworth | Texas | 48087 | 418 | 11 |
1933014 | 1933014 | 2021-11-19 | Colorado | Texas | 48089 | 2603 | 54 |
1933015 | 1933015 | 2021-11-19 | Comal | Texas | 48091 | 19996 | 464 |
1933016 | 1933016 | 2021-11-19 | Comanche | Texas | 48093 | 2332 | 66 |
1933017 | 1933017 | 2021-11-19 | Concho | Texas | 48095 | 714 | 10 |
1933018 | 1933018 | 2021-11-19 | Cooke | Texas | 48097 | 5175 | 105 |
1933019 | 1933019 | 2021-11-19 | Coryell | Texas | 48099 | 10801 | 166 |
1933020 | 1933020 | 2021-11-19 | Cottle | Texas | 48101 | 239 | 9 |
1933021 | 1933021 | 2021-11-19 | Crane | Texas | 48103 | 895 | 19 |
1933022 | 1933022 | 2021-11-19 | Crockett | Texas | 48105 | 785 | 16 |
1933023 | 1933023 | 2021-11-19 | Crosby | Texas | 48107 | 1034 | 37 |
1933024 | 1933024 | 2021-11-19 | Culberson | Texas | 48109 | 405 | 11 |
1933025 | 1933025 | 2021-11-19 | Dallam | Texas | 48111 | 1286 | 29 |
1933026 | 1933026 | 2021-11-19 | Dallas | Texas | 48113 | 411153 | 5552 |
1933027 | 1933027 | 2021-11-19 | Dawson | Texas | 48115 | 2200 | 80 |
1933028 | 1933028 | 2021-11-19 | DeWitt | Texas | 48123 | 3018 | 84 |
1933029 | 1933029 | 2021-11-19 | Deaf Smith | Texas | 48117 | 3479 | 84 |
1933030 | 1933030 | 2021-11-19 | Delta | Texas | 48119 | 625 | 22 |
1933031 | 1933031 | 2021-11-19 | Denton | Texas | 48121 | 110130 | 1043 |
1933032 | 1933032 | 2021-11-19 | Dickens | Texas | 48125 | 257 | 13 |
1933033 | 1933033 | 2021-11-19 | Dimmit | Texas | 48127 | 3800 | 46 |
1933034 | 1933034 | 2021-11-19 | Donley | Texas | 48129 | 617 | 18 |
1933035 | 1933035 | 2021-11-19 | Duval | Texas | 48131 | 1973 | 59 |
1933036 | 1933036 | 2021-11-19 | Eastland | Texas | 48133 | 2198 | 81 |
1933037 | 1933037 | 2021-11-19 | Ector | Texas | 48135 | 26286 | 551 |
1933038 | 1933038 | 2021-11-19 | Edwards | Texas | 48137 | 334 | 8 |
1933039 | 1933039 | 2021-11-19 | El Paso | Texas | 48141 | 155417 | 2920 |
1933040 | 1933040 | 2021-11-19 | Ellis | Texas | 48139 | 34023 | 477 |
1933041 | 1933041 | 2021-11-19 | Erath | Texas | 48143 | 6425 | 105 |
1933042 | 1933042 | 2021-11-19 | Falls | Texas | 48145 | 2604 | 50 |
1933043 | 1933043 | 2021-11-19 | Fannin | Texas | 48147 | 5056 | 153 |
1933044 | 1933044 | 2021-11-19 | Fayette | Texas | 48149 | 3626 | 93 |
1933045 | 1933045 | 2021-11-19 | Fisher | Texas | 48151 | 428 | 17 |
1933046 | 1933046 | 2021-11-19 | Floyd | Texas | 48153 | 1206 | 40 |
1933047 | 1933047 | 2021-11-19 | Foard | Texas | 48155 | 183 | 10 |
1933048 | 1933048 | 2021-11-19 | Fort Bend | Texas | 48157 | 101482 | 992 |
1933049 | 1933049 | 2021-11-19 | Franklin | Texas | 48159 | 1350 | 37 |
1933050 | 1933050 | 2021-11-19 | Freestone | Texas | 48161 | 2778 | 71 |
1933051 | 1933051 | 2021-11-19 | Frio | Texas | 48163 | 4014 | 75 |
1933052 | 1933052 | 2021-11-19 | Gaines | Texas | 48165 | 2184 | 64 |
1933053 | 1933053 | 2021-11-19 | Galveston | Texas | 48167 | 64948 | 705 |
1933054 | 1933054 | 2021-11-19 | Garza | Texas | 48169 | 741 | 22 |
1933055 | 1933055 | 2021-11-19 | Gillespie | Texas | 48171 | 3603 | 81 |
1933056 | 1933056 | 2021-11-19 | Glasscock | Texas | 48173 | 156 | 3 |
1933057 | 1933057 | 2021-11-19 | Goliad | Texas | 48175 | 670 | 28 |
1933058 | 1933058 | 2021-11-19 | Gonzales | Texas | 48177 | 3571 | 85 |
1933059 | 1933059 | 2021-11-19 | Gray | Texas | 48179 | 3757 | 83 |
1933060 | 1933060 | 2021-11-19 | Grayson | Texas | 48181 | 16428 | 505 |
1933061 | 1933061 | 2021-11-19 | Gregg | Texas | 48183 | 19384 | 573 |
1933062 | 1933062 | 2021-11-19 | Grimes | Texas | 48185 | 5249 | 108 |
1933063 | 1933063 | 2021-11-19 | Guadalupe | Texas | 48187 | 24781 | 344 |
1933064 | 1933064 | 2021-11-19 | Hale | Texas | 48189 | 8082 | 194 |
1933065 | 1933065 | 2021-11-19 | Hall | Texas | 48191 | 564 | 15 |
1933066 | 1933066 | 2021-11-19 | Hamilton | Texas | 48193 | 1320 | 29 |
1933067 | 1933067 | 2021-11-19 | Hansford | Texas | 48195 | 1154 | 26 |
1933068 | 1933068 | 2021-11-19 | Hardeman | Texas | 48197 | 456 | 14 |
1933069 | 1933069 | 2021-11-19 | Hardin | Texas | 48199 | 10466 | 212 |
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);