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-29 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1565842 | 1565842 | 2021-07-29 | Anderson | Texas | 48001 | 6210 | 133 |
1565843 | 1565843 | 2021-07-29 | Andrews | Texas | 48003 | 1894 | 47 |
1565844 | 1565844 | 2021-07-29 | Angelina | Texas | 48005 | 9034 | 289 |
1565845 | 1565845 | 2021-07-29 | Aransas | Texas | 48007 | 1428 | 43 |
1565846 | 1565846 | 2021-07-29 | Archer | Texas | 48009 | 822 | 12 |
1565847 | 1565847 | 2021-07-29 | Armstrong | Texas | 48011 | 219 | 7 |
1565848 | 1565848 | 2021-07-29 | Atascosa | Texas | 48013 | 6173 | 152 |
1565849 | 1565849 | 2021-07-29 | Austin | Texas | 48015 | 2334 | 38 |
1565850 | 1565850 | 2021-07-29 | Bailey | Texas | 48017 | 874 | 19 |
1565851 | 1565851 | 2021-07-29 | Bandera | Texas | 48019 | 1531 | 31 |
1565852 | 1565852 | 2021-07-29 | Bastrop | Texas | 48021 | 10308 | 105 |
1565853 | 1565853 | 2021-07-29 | Baylor | Texas | 48023 | 305 | 13 |
1565854 | 1565854 | 2021-07-29 | Bee | Texas | 48025 | 3645 | 75 |
1565855 | 1565855 | 2021-07-29 | Bell | Texas | 48027 | 26908 | 461 |
1565856 | 1565856 | 2021-07-29 | Bexar | Texas | 48029 | 239062 | 3677 |
1565857 | 1565857 | 2021-07-29 | Blanco | Texas | 48031 | 810 | 21 |
1565858 | 1565858 | 2021-07-29 | Borden | Texas | 48033 | 32 | 2 |
1565859 | 1565859 | 2021-07-29 | Bosque | Texas | 48035 | 1770 | 37 |
1565860 | 1565860 | 2021-07-29 | Bowie | Texas | 48037 | 8134 | 227 |
1565861 | 1565861 | 2021-07-29 | Brazoria | Texas | 48039 | 40694 | 542 |
1565862 | 1565862 | 2021-07-29 | Brazos | Texas | 48041 | 28692 | 265 |
1565863 | 1565863 | 2021-07-29 | Brewster | Texas | 48043 | 951 | 17 |
1565864 | 1565864 | 2021-07-29 | Briscoe | Texas | 48045 | 182 | 7 |
1565865 | 1565865 | 2021-07-29 | Brooks | Texas | 48047 | 890 | 37 |
1565866 | 1565866 | 2021-07-29 | Brown | Texas | 48049 | 4530 | 142 |
1565867 | 1565867 | 2021-07-29 | Burleson | Texas | 48051 | 2546 | 48 |
1565868 | 1565868 | 2021-07-29 | Burnet | Texas | 48053 | 5190 | 72 |
1565869 | 1565869 | 2021-07-29 | Caldwell | Texas | 48055 | 6010 | 100 |
1565870 | 1565870 | 2021-07-29 | Calhoun | Texas | 48057 | 2572 | 25 |
1565871 | 1565871 | 2021-07-29 | Callahan | Texas | 48059 | 1235 | 41 |
1565872 | 1565872 | 2021-07-29 | Cameron | Texas | 48061 | 44176 | 1706 |
1565873 | 1565873 | 2021-07-29 | Camp | Texas | 48063 | 1376 | 45 |
1565874 | 1565874 | 2021-07-29 | Carson | Texas | 48065 | 622 | 14 |
1565875 | 1565875 | 2021-07-29 | Cass | Texas | 48067 | 2388 | 85 |
1565876 | 1565876 | 2021-07-29 | Castro | Texas | 48069 | 1088 | 32 |
1565877 | 1565877 | 2021-07-29 | Chambers | Texas | 48071 | 5573 | 59 |
1565878 | 1565878 | 2021-07-29 | Cherokee | Texas | 48073 | 4481 | 148 |
1565879 | 1565879 | 2021-07-29 | Childress | Texas | 48075 | 1377 | 17 |
1565880 | 1565880 | 2021-07-29 | Clay | Texas | 48077 | 1073 | 17 |
1565881 | 1565881 | 2021-07-29 | Cochran | Texas | 48079 | 340 | 15 |
1565882 | 1565882 | 2021-07-29 | Coke | Texas | 48081 | 474 | 13 |
1565883 | 1565883 | 2021-07-29 | Coleman | Texas | 48083 | 799 | 35 |
1565884 | 1565884 | 2021-07-29 | Collin | Texas | 48085 | 96066 | 861 |
1565885 | 1565885 | 2021-07-29 | Collingsworth | Texas | 48087 | 334 | 9 |
1565886 | 1565886 | 2021-07-29 | Colorado | Texas | 48089 | 1854 | 33 |
1565887 | 1565887 | 2021-07-29 | Comal | Texas | 48091 | 12494 | 335 |
1565888 | 1565888 | 2021-07-29 | Comanche | Texas | 48093 | 1601 | 52 |
1565889 | 1565889 | 2021-07-29 | Concho | Texas | 48095 | 516 | 8 |
1565890 | 1565890 | 2021-07-29 | Cooke | Texas | 48097 | 3869 | 72 |
1565891 | 1565891 | 2021-07-29 | Coryell | Texas | 48099 | 7755 | 89 |
1565892 | 1565892 | 2021-07-29 | Cottle | Texas | 48101 | 193 | 7 |
1565893 | 1565893 | 2021-07-29 | Crane | Texas | 48103 | 575 | 12 |
1565894 | 1565894 | 2021-07-29 | Crockett | Texas | 48105 | 618 | 15 |
1565895 | 1565895 | 2021-07-29 | Crosby | Texas | 48107 | 779 | 29 |
1565896 | 1565896 | 2021-07-29 | Culberson | Texas | 48109 | 367 | 11 |
1565897 | 1565897 | 2021-07-29 | Dallam | Texas | 48111 | 995 | 26 |
1565898 | 1565898 | 2021-07-29 | Dallas | Texas | 48113 | 315361 | 4170 |
1565899 | 1565899 | 2021-07-29 | Dawson | Texas | 48115 | 1757 | 69 |
1565900 | 1565900 | 2021-07-29 | DeWitt | Texas | 48123 | 2049 | 61 |
1565901 | 1565901 | 2021-07-29 | Deaf Smith | Texas | 48117 | 3000 | 68 |
1565902 | 1565902 | 2021-07-29 | Delta | Texas | 48119 | 368 | 14 |
1565903 | 1565903 | 2021-07-29 | Denton | Texas | 48121 | 79563 | 790 |
1565904 | 1565904 | 2021-07-29 | Dickens | Texas | 48125 | 198 | 10 |
1565905 | 1565905 | 2021-07-29 | Dimmit | Texas | 48127 | 2948 | 37 |
1565906 | 1565906 | 2021-07-29 | Donley | Texas | 48129 | 431 | 15 |
1565907 | 1565907 | 2021-07-29 | Duval | Texas | 48131 | 1373 | 42 |
1565908 | 1565908 | 2021-07-29 | Eastland | Texas | 48133 | 1387 | 50 |
1565909 | 1565909 | 2021-07-29 | Ector | Texas | 48135 | 18329 | 381 |
1565910 | 1565910 | 2021-07-29 | Edwards | Texas | 48137 | 252 | 6 |
1565911 | 1565911 | 2021-07-29 | El Paso | Texas | 48141 | 137937 | 2758 |
1565912 | 1565912 | 2021-07-29 | Ellis | Texas | 48139 | 23613 | 325 |
1565913 | 1565913 | 2021-07-29 | Erath | Texas | 48143 | 4388 | 70 |
1565914 | 1565914 | 2021-07-29 | Falls | Texas | 48145 | 2115 | 33 |
1565915 | 1565915 | 2021-07-29 | Fannin | Texas | 48147 | 3553 | 109 |
1565916 | 1565916 | 2021-07-29 | Fayette | Texas | 48149 | 2892 | 69 |
1565917 | 1565917 | 2021-07-29 | Fisher | Texas | 48151 | 314 | 14 |
1565918 | 1565918 | 2021-07-29 | Floyd | Texas | 48153 | 917 | 30 |
1565919 | 1565919 | 2021-07-29 | Foard | Texas | 48155 | 126 | 10 |
1565920 | 1565920 | 2021-07-29 | Fort Bend | Texas | 48157 | 72819 | 741 |
1565921 | 1565921 | 2021-07-29 | Franklin | Texas | 48159 | 832 | 26 |
1565922 | 1565922 | 2021-07-29 | Freestone | Texas | 48161 | 2047 | 51 |
1565923 | 1565923 | 2021-07-29 | Frio | Texas | 48163 | 3051 | 53 |
1565924 | 1565924 | 2021-07-29 | Gaines | Texas | 48165 | 1486 | 46 |
1565925 | 1565925 | 2021-07-29 | Galveston | Texas | 48167 | 43864 | 459 |
1565926 | 1565926 | 2021-07-29 | Garza | Texas | 48169 | 562 | 22 |
1565927 | 1565927 | 2021-07-29 | Gillespie | Texas | 48171 | 2721 | 53 |
1565928 | 1565928 | 2021-07-29 | Glasscock | Texas | 48173 | 105 | 2 |
1565929 | 1565929 | 2021-07-29 | Goliad | Texas | 48175 | 503 | 16 |
1565930 | 1565930 | 2021-07-29 | Gonzales | Texas | 48177 | 2817 | 59 |
1565931 | 1565931 | 2021-07-29 | Gray | Texas | 48179 | 2594 | 58 |
1565932 | 1565932 | 2021-07-29 | Grayson | Texas | 48181 | 11774 | 348 |
1565933 | 1565933 | 2021-07-29 | Gregg | Texas | 48183 | 11887 | 364 |
1565934 | 1565934 | 2021-07-29 | Grimes | Texas | 48185 | 4074 | 74 |
1565935 | 1565935 | 2021-07-29 | Guadalupe | Texas | 48187 | 16628 | 224 |
1565936 | 1565936 | 2021-07-29 | Hale | Texas | 48189 | 6278 | 157 |
1565937 | 1565937 | 2021-07-29 | Hall | Texas | 48191 | 502 | 14 |
1565938 | 1565938 | 2021-07-29 | Hamilton | Texas | 48193 | 845 | 29 |
1565939 | 1565939 | 2021-07-29 | Hansford | Texas | 48195 | 955 | 24 |
1565940 | 1565940 | 2021-07-29 | Hardeman | Texas | 48197 | 389 | 12 |
1565941 | 1565941 | 2021-07-29 | Hardin | Texas | 48199 | 6502 | 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);