ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
253 rows where "date" is on date 2020-11-11 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 |
---|---|---|---|---|---|---|---|
721849 | 721849 | 2020-11-11 | Anderson | Texas | 48001 | 3035 | 42 |
721850 | 721850 | 2020-11-11 | Andrews | Texas | 48003 | 781 | 11 |
721851 | 721851 | 2020-11-11 | Angelina | Texas | 48005 | 3170 | 93 |
721852 | 721852 | 2020-11-11 | Aransas | Texas | 48007 | 369 | 18 |
721853 | 721853 | 2020-11-11 | Archer | Texas | 48009 | 187 | 1 |
721854 | 721854 | 2020-11-11 | Armstrong | Texas | 48011 | 33 | 1 |
721855 | 721855 | 2020-11-11 | Atascosa | Texas | 48013 | 1338 | 37 |
721856 | 721856 | 2020-11-11 | Austin | Texas | 48015 | 533 | 10 |
721857 | 721857 | 2020-11-11 | Bailey | Texas | 48017 | 385 | 5 |
721858 | 721858 | 2020-11-11 | Bandera | Texas | 48019 | 205 | 10 |
721859 | 721859 | 2020-11-11 | Bastrop | Texas | 48021 | 2101 | 33 |
721860 | 721860 | 2020-11-11 | Baylor | Texas | 48023 | 47 | 4 |
721861 | 721861 | 2020-11-11 | Bee | Texas | 48025 | 1908 | 39 |
721862 | 721862 | 2020-11-11 | Bell | Texas | 48027 | 7088 | 104 |
721863 | 721863 | 2020-11-11 | Bexar | Texas | 48029 | 68388 | 1438 |
721864 | 721864 | 2020-11-11 | Blanco | Texas | 48031 | 170 | 6 |
721865 | 721865 | 2020-11-11 | Borden | Texas | 48033 | 3 | 0 |
721866 | 721866 | 2020-11-11 | Bosque | Texas | 48035 | 469 | 14 |
721867 | 721867 | 2020-11-11 | Bowie | Texas | 48037 | 2269 | 87 |
721868 | 721868 | 2020-11-11 | Brazoria | Texas | 48039 | 13059 | 189 |
721869 | 721869 | 2020-11-11 | Brazos | Texas | 48041 | 9543 | 85 |
721870 | 721870 | 2020-11-11 | Brewster | Texas | 48043 | 290 | 5 |
721871 | 721871 | 2020-11-11 | Briscoe | Texas | 48045 | 25 | 1 |
721872 | 721872 | 2020-11-11 | Brooks | Texas | 48047 | 377 | 25 |
721873 | 721873 | 2020-11-11 | Brown | Texas | 48049 | 1259 | 35 |
721874 | 721874 | 2020-11-11 | Burleson | Texas | 48051 | 514 | 6 |
721875 | 721875 | 2020-11-11 | Burnet | Texas | 48053 | 1164 | 16 |
721876 | 721876 | 2020-11-11 | Caldwell | Texas | 48055 | 1772 | 39 |
721877 | 721877 | 2020-11-11 | Calhoun | Texas | 48057 | 948 | 9 |
721878 | 721878 | 2020-11-11 | Callahan | Texas | 48059 | 172 | 6 |
721879 | 721879 | 2020-11-11 | Cameron | Texas | 48061 | 24825 | 1096 |
721880 | 721880 | 2020-11-11 | Camp | Texas | 48063 | 424 | 13 |
721881 | 721881 | 2020-11-11 | Carson | Texas | 48065 | 71 | 1 |
721882 | 721882 | 2020-11-11 | Cass | Texas | 48067 | 655 | 32 |
721883 | 721883 | 2020-11-11 | Castro | Texas | 48069 | 378 | 7 |
721884 | 721884 | 2020-11-11 | Chambers | Texas | 48071 | 1670 | 20 |
721885 | 721885 | 2020-11-11 | Cherokee | Texas | 48073 | 1689 | 45 |
721886 | 721886 | 2020-11-11 | Childress | Texas | 48075 | 770 | 0 |
721887 | 721887 | 2020-11-11 | Clay | Texas | 48077 | 159 | 3 |
721888 | 721888 | 2020-11-11 | Cochran | Texas | 48079 | 133 | 4 |
721889 | 721889 | 2020-11-11 | Coke | Texas | 48081 | 137 | 8 |
721890 | 721890 | 2020-11-11 | Coleman | Texas | 48083 | 141 | 5 |
721891 | 721891 | 2020-11-11 | Collin | Texas | 48085 | 20888 | 205 |
721892 | 721892 | 2020-11-11 | Collingsworth | Texas | 48087 | 22 | 0 |
721893 | 721893 | 2020-11-11 | Colorado | Texas | 48089 | 523 | 4 |
721894 | 721894 | 2020-11-11 | Comal | Texas | 48091 | 4005 | 124 |
721895 | 721895 | 2020-11-11 | Comanche | Texas | 48093 | 403 | 5 |
721896 | 721896 | 2020-11-11 | Concho | Texas | 48095 | 147 | 2 |
721897 | 721897 | 2020-11-11 | Cooke | Texas | 48097 | 617 | 9 |
721898 | 721898 | 2020-11-11 | Coryell | Texas | 48099 | 2111 | 14 |
721899 | 721899 | 2020-11-11 | Cottle | Texas | 48101 | 45 | 4 |
721900 | 721900 | 2020-11-11 | Crane | Texas | 48103 | 90 | 6 |
721901 | 721901 | 2020-11-11 | Crockett | Texas | 48105 | 169 | 7 |
721902 | 721902 | 2020-11-11 | Crosby | Texas | 48107 | 150 | 13 |
721903 | 721903 | 2020-11-11 | Culberson | Texas | 48109 | 134 | 3 |
721904 | 721904 | 2020-11-11 | Dallam | Texas | 48111 | 414 | 10 |
721905 | 721905 | 2020-11-11 | Dallas | Texas | 48113 | 114308 | 1341 |
721906 | 721906 | 2020-11-11 | Dawson | Texas | 48115 | 1014 | 24 |
721907 | 721907 | 2020-11-11 | DeWitt | Texas | 48123 | 1128 | 44 |
721908 | 721908 | 2020-11-11 | Deaf Smith | Texas | 48117 | 1533 | 32 |
721909 | 721909 | 2020-11-11 | Delta | Texas | 48119 | 43 | 0 |
721910 | 721910 | 2020-11-11 | Denton | Texas | 48121 | 18892 | 190 |
721911 | 721911 | 2020-11-11 | Dickens | Texas | 48125 | 60 | 2 |
721912 | 721912 | 2020-11-11 | Dimmit | Texas | 48127 | 313 | 8 |
721913 | 721913 | 2020-11-11 | Donley | Texas | 48129 | 93 | 1 |
721914 | 721914 | 2020-11-11 | Duval | Texas | 48131 | 536 | 22 |
721915 | 721915 | 2020-11-11 | Eastland | Texas | 48133 | 303 | 9 |
721916 | 721916 | 2020-11-11 | Ector | Texas | 48135 | 7804 | 125 |
721917 | 721917 | 2020-11-11 | Edwards | Texas | 48137 | 78 | 2 |
721918 | 721918 | 2020-11-11 | El Paso | Texas | 48141 | 67484 | 729 |
721919 | 721919 | 2020-11-11 | Ellis | Texas | 48139 | 5530 | 95 |
721920 | 721920 | 2020-11-11 | Erath | Texas | 48143 | 1177 | 18 |
721921 | 721921 | 2020-11-11 | Falls | Texas | 48145 | 709 | 10 |
721922 | 721922 | 2020-11-11 | Fannin | Texas | 48147 | 877 | 23 |
721923 | 721923 | 2020-11-11 | Fayette | Texas | 48149 | 556 | 23 |
721924 | 721924 | 2020-11-11 | Fisher | Texas | 48151 | 138 | 4 |
721925 | 721925 | 2020-11-11 | Floyd | Texas | 48153 | 160 | 10 |
721926 | 721926 | 2020-11-11 | Foard | Texas | 48155 | 24 | 1 |
721927 | 721927 | 2020-11-11 | Fort Bend | Texas | 48157 | 19149 | 318 |
721928 | 721928 | 2020-11-11 | Franklin | Texas | 48159 | 236 | 10 |
721929 | 721929 | 2020-11-11 | Freestone | Texas | 48161 | 478 | 5 |
721930 | 721930 | 2020-11-11 | Frio | Texas | 48163 | 1032 | 9 |
721931 | 721931 | 2020-11-11 | Gaines | Texas | 48165 | 668 | 13 |
721932 | 721932 | 2020-11-11 | Galveston | Texas | 48167 | 13260 | 171 |
721933 | 721933 | 2020-11-11 | Garza | Texas | 48169 | 149 | 10 |
721934 | 721934 | 2020-11-11 | Gillespie | Texas | 48171 | 401 | 10 |
721935 | 721935 | 2020-11-11 | Glasscock | Texas | 48173 | 16 | 0 |
721936 | 721936 | 2020-11-11 | Goliad | Texas | 48175 | 166 | 6 |
721937 | 721937 | 2020-11-11 | Gonzales | Texas | 48177 | 1152 | 20 |
721938 | 721938 | 2020-11-11 | Gray | Texas | 48179 | 1054 | 12 |
721939 | 721939 | 2020-11-11 | Grayson | Texas | 48181 | 3206 | 87 |
721940 | 721940 | 2020-11-11 | Gregg | Texas | 48183 | 4026 | 96 |
721941 | 721941 | 2020-11-11 | Grimes | Texas | 48185 | 1248 | 37 |
721942 | 721942 | 2020-11-11 | Guadalupe | Texas | 48187 | 3996 | 83 |
721943 | 721943 | 2020-11-11 | Hale | Texas | 48189 | 3190 | 71 |
721944 | 721944 | 2020-11-11 | Hall | Texas | 48191 | 52 | 2 |
721945 | 721945 | 2020-11-11 | Hamilton | Texas | 48193 | 240 | 7 |
721946 | 721946 | 2020-11-11 | Hansford | Texas | 48195 | 216 | 8 |
721947 | 721947 | 2020-11-11 | Hardeman | Texas | 48197 | 72 | 3 |
721948 | 721948 | 2020-11-11 | Hardin | Texas | 48199 | 1494 | 36 |
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);