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-07-25 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1552852 | 1552852 | 2021-07-25 | Anderson | Texas | 48001 | 6212 | 133 |
1552853 | 1552853 | 2021-07-25 | Andrews | Texas | 48003 | 1866 | 47 |
1552854 | 1552854 | 2021-07-25 | Angelina | Texas | 48005 | 8900 | 288 |
1552855 | 1552855 | 2021-07-25 | Aransas | Texas | 48007 | 1410 | 43 |
1552856 | 1552856 | 2021-07-25 | Archer | Texas | 48009 | 820 | 12 |
1552857 | 1552857 | 2021-07-25 | Armstrong | Texas | 48011 | 216 | 7 |
1552858 | 1552858 | 2021-07-25 | Atascosa | Texas | 48013 | 6058 | 151 |
1552859 | 1552859 | 2021-07-25 | Austin | Texas | 48015 | 2310 | 37 |
1552860 | 1552860 | 2021-07-25 | Bailey | Texas | 48017 | 872 | 19 |
1552861 | 1552861 | 2021-07-25 | Bandera | Texas | 48019 | 1498 | 31 |
1552862 | 1552862 | 2021-07-25 | Bastrop | Texas | 48021 | 10108 | 106 |
1552863 | 1552863 | 2021-07-25 | Baylor | Texas | 48023 | 303 | 13 |
1552864 | 1552864 | 2021-07-25 | Bee | Texas | 48025 | 3619 | 75 |
1552865 | 1552865 | 2021-07-25 | Bell | Texas | 48027 | 26390 | 458 |
1552866 | 1552866 | 2021-07-25 | Bexar | Texas | 48029 | 233179 | 3670 |
1552867 | 1552867 | 2021-07-25 | Blanco | Texas | 48031 | 798 | 21 |
1552868 | 1552868 | 2021-07-25 | Borden | Texas | 48033 | 31 | 2 |
1552869 | 1552869 | 2021-07-25 | Bosque | Texas | 48035 | 1733 | 37 |
1552870 | 1552870 | 2021-07-25 | Bowie | Texas | 48037 | 8028 | 227 |
1552871 | 1552871 | 2021-07-25 | Brazoria | Texas | 48039 | 40090 | 541 |
1552872 | 1552872 | 2021-07-25 | Brazos | Texas | 48041 | 28487 | 265 |
1552873 | 1552873 | 2021-07-25 | Brewster | Texas | 48043 | 951 | 17 |
1552874 | 1552874 | 2021-07-25 | Briscoe | Texas | 48045 | 176 | 6 |
1552875 | 1552875 | 2021-07-25 | Brooks | Texas | 48047 | 886 | 36 |
1552876 | 1552876 | 2021-07-25 | Brown | Texas | 48049 | 4530 | 142 |
1552877 | 1552877 | 2021-07-25 | Burleson | Texas | 48051 | 2524 | 48 |
1552878 | 1552878 | 2021-07-25 | Burnet | Texas | 48053 | 5098 | 70 |
1552879 | 1552879 | 2021-07-25 | Caldwell | Texas | 48055 | 5909 | 100 |
1552880 | 1552880 | 2021-07-25 | Calhoun | Texas | 48057 | 2548 | 25 |
1552881 | 1552881 | 2021-07-25 | Callahan | Texas | 48059 | 1219 | 41 |
1552882 | 1552882 | 2021-07-25 | Cameron | Texas | 48061 | 43743 | 1705 |
1552883 | 1552883 | 2021-07-25 | Camp | Texas | 48063 | 1353 | 45 |
1552884 | 1552884 | 2021-07-25 | Carson | Texas | 48065 | 618 | 14 |
1552885 | 1552885 | 2021-07-25 | Cass | Texas | 48067 | 2339 | 85 |
1552886 | 1552886 | 2021-07-25 | Castro | Texas | 48069 | 1081 | 32 |
1552887 | 1552887 | 2021-07-25 | Chambers | Texas | 48071 | 5503 | 59 |
1552888 | 1552888 | 2021-07-25 | Cherokee | Texas | 48073 | 4418 | 148 |
1552889 | 1552889 | 2021-07-25 | Childress | Texas | 48075 | 1381 | 17 |
1552890 | 1552890 | 2021-07-25 | Clay | Texas | 48077 | 1059 | 17 |
1552891 | 1552891 | 2021-07-25 | Cochran | Texas | 48079 | 339 | 15 |
1552892 | 1552892 | 2021-07-25 | Coke | Texas | 48081 | 472 | 13 |
1552893 | 1552893 | 2021-07-25 | Coleman | Texas | 48083 | 787 | 34 |
1552894 | 1552894 | 2021-07-25 | Collin | Texas | 48085 | 95090 | 858 |
1552895 | 1552895 | 2021-07-25 | Collingsworth | Texas | 48087 | 331 | 9 |
1552896 | 1552896 | 2021-07-25 | Colorado | Texas | 48089 | 1824 | 33 |
1552897 | 1552897 | 2021-07-25 | Comal | Texas | 48091 | 12108 | 335 |
1552898 | 1552898 | 2021-07-25 | Comanche | Texas | 48093 | 1586 | 52 |
1552899 | 1552899 | 2021-07-25 | Concho | Texas | 48095 | 511 | 8 |
1552900 | 1552900 | 2021-07-25 | Cooke | Texas | 48097 | 3839 | 72 |
1552901 | 1552901 | 2021-07-25 | Coryell | Texas | 48099 | 7641 | 89 |
1552902 | 1552902 | 2021-07-25 | Cottle | Texas | 48101 | 191 | 7 |
1552903 | 1552903 | 2021-07-25 | Crane | Texas | 48103 | 570 | 12 |
1552904 | 1552904 | 2021-07-25 | Crockett | Texas | 48105 | 618 | 15 |
1552905 | 1552905 | 2021-07-25 | Crosby | Texas | 48107 | 769 | 29 |
1552906 | 1552906 | 2021-07-25 | Culberson | Texas | 48109 | 366 | 11 |
1552907 | 1552907 | 2021-07-25 | Dallam | Texas | 48111 | 993 | 26 |
1552908 | 1552908 | 2021-07-25 | Dallas | Texas | 48113 | 312154 | 4164 |
1552909 | 1552909 | 2021-07-25 | Dawson | Texas | 48115 | 1754 | 69 |
1552910 | 1552910 | 2021-07-25 | DeWitt | Texas | 48123 | 2011 | 61 |
1552911 | 1552911 | 2021-07-25 | Deaf Smith | Texas | 48117 | 2978 | 68 |
1552912 | 1552912 | 2021-07-25 | Delta | Texas | 48119 | 362 | 14 |
1552913 | 1552913 | 2021-07-25 | Denton | Texas | 48121 | 78793 | 788 |
1552914 | 1552914 | 2021-07-25 | Dickens | Texas | 48125 | 198 | 10 |
1552915 | 1552915 | 2021-07-25 | Dimmit | Texas | 48127 | 2890 | 37 |
1552916 | 1552916 | 2021-07-25 | Donley | Texas | 48129 | 429 | 15 |
1552917 | 1552917 | 2021-07-25 | Duval | Texas | 48131 | 1326 | 42 |
1552918 | 1552918 | 2021-07-25 | Eastland | Texas | 48133 | 1384 | 50 |
1552919 | 1552919 | 2021-07-25 | Ector | Texas | 48135 | 18064 | 379 |
1552920 | 1552920 | 2021-07-25 | Edwards | Texas | 48137 | 249 | 6 |
1552921 | 1552921 | 2021-07-25 | El Paso | Texas | 48141 | 137567 | 2756 |
1552922 | 1552922 | 2021-07-25 | Ellis | Texas | 48139 | 23367 | 325 |
1552923 | 1552923 | 2021-07-25 | Erath | Texas | 48143 | 4324 | 70 |
1552924 | 1552924 | 2021-07-25 | Falls | Texas | 48145 | 2105 | 33 |
1552925 | 1552925 | 2021-07-25 | Fannin | Texas | 48147 | 3518 | 109 |
1552926 | 1552926 | 2021-07-25 | Fayette | Texas | 48149 | 2848 | 69 |
1552927 | 1552927 | 2021-07-25 | Fisher | Texas | 48151 | 310 | 14 |
1552928 | 1552928 | 2021-07-25 | Floyd | Texas | 48153 | 909 | 30 |
1552929 | 1552929 | 2021-07-25 | Foard | Texas | 48155 | 124 | 10 |
1552930 | 1552930 | 2021-07-25 | Fort Bend | Texas | 48157 | 71519 | 733 |
1552931 | 1552931 | 2021-07-25 | Franklin | Texas | 48159 | 822 | 26 |
1552932 | 1552932 | 2021-07-25 | Freestone | Texas | 48161 | 2023 | 50 |
1552933 | 1552933 | 2021-07-25 | Frio | Texas | 48163 | 3006 | 53 |
1552934 | 1552934 | 2021-07-25 | Gaines | Texas | 48165 | 1475 | 46 |
1552935 | 1552935 | 2021-07-25 | Galveston | Texas | 48167 | 42809 | 456 |
1552936 | 1552936 | 2021-07-25 | Garza | Texas | 48169 | 560 | 22 |
1552937 | 1552937 | 2021-07-25 | Gillespie | Texas | 48171 | 2693 | 53 |
1552938 | 1552938 | 2021-07-25 | Glasscock | Texas | 48173 | 105 | 2 |
1552939 | 1552939 | 2021-07-25 | Goliad | Texas | 48175 | 497 | 16 |
1552940 | 1552940 | 2021-07-25 | Gonzales | Texas | 48177 | 2795 | 58 |
1552941 | 1552941 | 2021-07-25 | Gray | Texas | 48179 | 2580 | 58 |
1552942 | 1552942 | 2021-07-25 | Grayson | Texas | 48181 | 11720 | 348 |
1552943 | 1552943 | 2021-07-25 | Gregg | Texas | 48183 | 11806 | 363 |
1552944 | 1552944 | 2021-07-25 | Grimes | Texas | 48185 | 3878 | 74 |
1552945 | 1552945 | 2021-07-25 | Guadalupe | Texas | 48187 | 16351 | 224 |
1552946 | 1552946 | 2021-07-25 | Hale | Texas | 48189 | 6231 | 157 |
1552947 | 1552947 | 2021-07-25 | Hall | Texas | 48191 | 501 | 14 |
1552948 | 1552948 | 2021-07-25 | Hamilton | Texas | 48193 | 835 | 29 |
1552949 | 1552949 | 2021-07-25 | Hansford | Texas | 48195 | 953 | 24 |
1552950 | 1552950 | 2021-07-25 | Hardeman | Texas | 48197 | 386 | 12 |
1552951 | 1552951 | 2021-07-25 | Hardin | Texas | 48199 | 6399 | 118 |
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);