ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
255 rows where "date" is on date 2022-01-18 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2128015 | 2128015 | 2022-01-18 | Anderson | Texas | 48001 | 8874 | 215 |
2128016 | 2128016 | 2022-01-18 | Andrews | Texas | 48003 | 3386 | 67 |
2128017 | 2128017 | 2022-01-18 | Angelina | Texas | 48005 | 13940 | 433 |
2128018 | 2128018 | 2022-01-18 | Aransas | Texas | 48007 | 3150 | 69 |
2128019 | 2128019 | 2022-01-18 | Archer | Texas | 48009 | 1785 | 24 |
2128020 | 2128020 | 2022-01-18 | Armstrong | Texas | 48011 | 447 | 8 |
2128021 | 2128021 | 2022-01-18 | Atascosa | Texas | 48013 | 10855 | 214 |
2128022 | 2128022 | 2022-01-18 | Austin | Texas | 48015 | 4698 | 58 |
2128023 | 2128023 | 2022-01-18 | Bailey | Texas | 48017 | 1276 | 31 |
2128024 | 2128024 | 2022-01-18 | Bandera | Texas | 48019 | 3010 | 65 |
2128025 | 2128025 | 2022-01-18 | Bastrop | Texas | 48021 | 18873 | 195 |
2128026 | 2128026 | 2022-01-18 | Baylor | Texas | 48023 | 704 | 26 |
2128027 | 2128027 | 2022-01-18 | Bee | Texas | 48025 | 7115 | 138 |
2128028 | 2128028 | 2022-01-18 | Bell | Texas | 48027 | 52674 | 761 |
2128029 | 2128029 | 2022-01-18 | Bexar | Texas | 48029 | 439392 | 5418 |
2128030 | 2128030 | 2022-01-18 | Blanco | Texas | 48031 | 1993 | 28 |
2128031 | 2128031 | 2022-01-18 | Borden | Texas | 48033 | 85 | 2 |
2128032 | 2128032 | 2022-01-18 | Bosque | Texas | 48035 | 3235 | 59 |
2128033 | 2128033 | 2022-01-18 | Bowie | Texas | 48037 | 16364 | 362 |
2128034 | 2128034 | 2022-01-18 | Brazoria | Texas | 48039 | 83069 | 885 |
2128035 | 2128035 | 2022-01-18 | Brazos | Texas | 48041 | 51025 | 370 |
2128036 | 2128036 | 2022-01-18 | Brewster | Texas | 48043 | 970 | 24 |
2128037 | 2128037 | 2022-01-18 | Briscoe | Texas | 48045 | 385 | 8 |
2128038 | 2128038 | 2022-01-18 | Brooks | Texas | 48047 | 1299 | 48 |
2128039 | 2128039 | 2022-01-18 | Brown | Texas | 48049 | 9121 | 205 |
2128040 | 2128040 | 2022-01-18 | Burleson | Texas | 48051 | 4385 | 61 |
2128041 | 2128041 | 2022-01-18 | Burnet | Texas | 48053 | 9268 | 139 |
2128042 | 2128042 | 2022-01-18 | Caldwell | Texas | 48055 | 11647 | 159 |
2128043 | 2128043 | 2022-01-18 | Calhoun | Texas | 48057 | 4816 | 40 |
2128044 | 2128044 | 2022-01-18 | Callahan | Texas | 48059 | 2387 | 62 |
2128045 | 2128045 | 2022-01-18 | Cameron | Texas | 48061 | 82951 | 2029 |
2128046 | 2128046 | 2022-01-18 | Camp | Texas | 48063 | 2460 | 69 |
2128047 | 2128047 | 2022-01-18 | Carson | Texas | 48065 | 1310 | 30 |
2128048 | 2128048 | 2022-01-18 | Cass | Texas | 48067 | 5503 | 166 |
2128049 | 2128049 | 2022-01-18 | Castro | Texas | 48069 | 2002 | 45 |
2128050 | 2128050 | 2022-01-18 | Chambers | Texas | 48071 | 10296 | 105 |
2128051 | 2128051 | 2022-01-18 | Cherokee | Texas | 48073 | 6948 | 230 |
2128052 | 2128052 | 2022-01-18 | Childress | Texas | 48075 | 2181 | 25 |
2128053 | 2128053 | 2022-01-18 | Clay | Texas | 48077 | 1838 | 26 |
2128054 | 2128054 | 2022-01-18 | Cochran | Texas | 48079 | 713 | 21 |
2128055 | 2128055 | 2022-01-18 | Coke | Texas | 48081 | 753 | 18 |
2128056 | 2128056 | 2022-01-18 | Coleman | Texas | 48083 | 1472 | 61 |
2128057 | 2128057 | 2022-01-18 | Collin | Texas | 48085 | 173083 | 1248 |
2128058 | 2128058 | 2022-01-18 | Collingsworth | Texas | 48087 | 596 | 13 |
2128059 | 2128059 | 2022-01-18 | Colorado | Texas | 48089 | 3159 | 57 |
2128060 | 2128060 | 2022-01-18 | Comal | Texas | 48091 | 26734 | 490 |
2128061 | 2128061 | 2022-01-18 | Comanche | Texas | 48093 | 2821 | 69 |
2128062 | 2128062 | 2022-01-18 | Concho | Texas | 48095 | 931 | 10 |
2128063 | 2128063 | 2022-01-18 | Cooke | Texas | 48097 | 6383 | 114 |
2128064 | 2128064 | 2022-01-18 | Coryell | Texas | 48099 | 14692 | 173 |
2128065 | 2128065 | 2022-01-18 | Cottle | Texas | 48101 | 264 | 9 |
2128066 | 2128066 | 2022-01-18 | Crane | Texas | 48103 | 1033 | 19 |
2128067 | 2128067 | 2022-01-18 | Crockett | Texas | 48105 | 913 | 17 |
2128068 | 2128068 | 2022-01-18 | Crosby | Texas | 48107 | 1661 | 42 |
2128069 | 2128069 | 2022-01-18 | Culberson | Texas | 48109 | 455 | 13 |
2128070 | 2128070 | 2022-01-18 | Dallam | Texas | 48111 | 1868 | 34 |
2128071 | 2128071 | 2022-01-18 | Dallas | Texas | 48113 | 502972 | 5883 |
2128072 | 2128072 | 2022-01-18 | Dawson | Texas | 48115 | 2233 | 83 |
2128073 | 2128073 | 2022-01-18 | DeWitt | Texas | 48123 | 5639 | 86 |
2128074 | 2128074 | 2022-01-18 | Deaf Smith | Texas | 48117 | 3852 | 103 |
2128075 | 2128075 | 2022-01-18 | Delta | Texas | 48119 | 1540 | 22 |
2128076 | 2128076 | 2022-01-18 | Denton | Texas | 48121 | 144701 | 1124 |
2128077 | 2128077 | 2022-01-18 | Dickens | Texas | 48125 | 360 | 15 |
2128078 | 2128078 | 2022-01-18 | Dimmit | Texas | 48127 | 4690 | 48 |
2128079 | 2128079 | 2022-01-18 | Donley | Texas | 48129 | 877 | 20 |
2128080 | 2128080 | 2022-01-18 | Duval | Texas | 48131 | 2475 | 62 |
2128081 | 2128081 | 2022-01-18 | Eastland | Texas | 48133 | 2529 | 91 |
2128082 | 2128082 | 2022-01-18 | Ector | Texas | 48135 | 32895 | 587 |
2128083 | 2128083 | 2022-01-18 | Edwards | Texas | 48137 | 389 | 9 |
2128084 | 2128084 | 2022-01-18 | El Paso | Texas | 48141 | 170175 | 3280 |
2128085 | 2128085 | 2022-01-18 | Ellis | Texas | 48139 | 42209 | 504 |
2128086 | 2128086 | 2022-01-18 | Erath | Texas | 48143 | 7411 | 110 |
2128087 | 2128087 | 2022-01-18 | Falls | Texas | 48145 | 3273 | 54 |
2128088 | 2128088 | 2022-01-18 | Fannin | Texas | 48147 | 5913 | 157 |
2128089 | 2128089 | 2022-01-18 | Fayette | Texas | 48149 | 4215 | 95 |
2128090 | 2128090 | 2022-01-18 | Fisher | Texas | 48151 | 528 | 20 |
2128091 | 2128091 | 2022-01-18 | Floyd | Texas | 48153 | 1731 | 42 |
2128092 | 2128092 | 2022-01-18 | Foard | Texas | 48155 | 183 | 10 |
2128093 | 2128093 | 2022-01-18 | Fort Bend | Texas | 48157 | 153761 | 1080 |
2128094 | 2128094 | 2022-01-18 | Franklin | Texas | 48159 | 1780 | 37 |
2128095 | 2128095 | 2022-01-18 | Freestone | Texas | 48161 | 3441 | 76 |
2128096 | 2128096 | 2022-01-18 | Frio | Texas | 48163 | 4622 | 80 |
2128097 | 2128097 | 2022-01-18 | Gaines | Texas | 48165 | 1582 | 72 |
2128098 | 2128098 | 2022-01-18 | Galveston | Texas | 48167 | 84572 | 753 |
2128099 | 2128099 | 2022-01-18 | Garza | Texas | 48169 | 1087 | 25 |
2128100 | 2128100 | 2022-01-18 | Gillespie | Texas | 48171 | 4542 | 86 |
2128101 | 2128101 | 2022-01-18 | Glasscock | Texas | 48173 | 184 | 3 |
2128102 | 2128102 | 2022-01-18 | Goliad | Texas | 48175 | 926 | 28 |
2128103 | 2128103 | 2022-01-18 | Gonzales | Texas | 48177 | 4058 | 92 |
2128104 | 2128104 | 2022-01-18 | Gray | Texas | 48179 | 5468 | 106 |
2128105 | 2128105 | 2022-01-18 | Grayson | Texas | 48181 | 22846 | 548 |
2128106 | 2128106 | 2022-01-18 | Gregg | Texas | 48183 | 20491 | 593 |
2128107 | 2128107 | 2022-01-18 | Grimes | Texas | 48185 | 7276 | 111 |
2128108 | 2128108 | 2022-01-18 | Guadalupe | Texas | 48187 | 30764 | 349 |
2128109 | 2128109 | 2022-01-18 | Hale | Texas | 48189 | 5748 | 214 |
2128110 | 2128110 | 2022-01-18 | Hall | Texas | 48191 | 873 | 18 |
2128111 | 2128111 | 2022-01-18 | Hamilton | Texas | 48193 | 1730 | 29 |
2128112 | 2128112 | 2022-01-18 | Hansford | Texas | 48195 | 1523 | 27 |
2128113 | 2128113 | 2022-01-18 | Hardeman | Texas | 48197 | 515 | 14 |
2128114 | 2128114 | 2022-01-18 | Hardin | Texas | 48199 | 10977 | 222 |
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);