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-08-14 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1617821 | 1617821 | 2021-08-14 | Anderson | Texas | 48001 | 6364 | 135 |
1617822 | 1617822 | 2021-08-14 | Andrews | Texas | 48003 | 1966 | 47 |
1617823 | 1617823 | 2021-08-14 | Angelina | Texas | 48005 | 9839 | 294 |
1617824 | 1617824 | 2021-08-14 | Aransas | Texas | 48007 | 1683 | 46 |
1617825 | 1617825 | 2021-08-14 | Archer | Texas | 48009 | 854 | 12 |
1617826 | 1617826 | 2021-08-14 | Armstrong | Texas | 48011 | 229 | 7 |
1617827 | 1617827 | 2021-08-14 | Atascosa | Texas | 48013 | 6576 | 155 |
1617828 | 1617828 | 2021-08-14 | Austin | Texas | 48015 | 2500 | 39 |
1617829 | 1617829 | 2021-08-14 | Bailey | Texas | 48017 | 886 | 19 |
1617830 | 1617830 | 2021-08-14 | Bandera | Texas | 48019 | 1678 | 34 |
1617831 | 1617831 | 2021-08-14 | Bastrop | Texas | 48021 | 11228 | 111 |
1617832 | 1617832 | 2021-08-14 | Baylor | Texas | 48023 | 310 | 13 |
1617833 | 1617833 | 2021-08-14 | Bee | Texas | 48025 | 4028 | 77 |
1617834 | 1617834 | 2021-08-14 | Bell | Texas | 48027 | 29221 | 480 |
1617835 | 1617835 | 2021-08-14 | Bexar | Texas | 48029 | 259648 | 3766 |
1617836 | 1617836 | 2021-08-14 | Blanco | Texas | 48031 | 878 | 23 |
1617837 | 1617837 | 2021-08-14 | Borden | Texas | 48033 | 33 | 2 |
1617838 | 1617838 | 2021-08-14 | Bosque | Texas | 48035 | 1927 | 39 |
1617839 | 1617839 | 2021-08-14 | Bowie | Texas | 48037 | 8807 | 231 |
1617840 | 1617840 | 2021-08-14 | Brazoria | Texas | 48039 | 44478 | 566 |
1617841 | 1617841 | 2021-08-14 | Brazos | Texas | 48041 | 29665 | 274 |
1617842 | 1617842 | 2021-08-14 | Brewster | Texas | 48043 | 968 | 18 |
1617843 | 1617843 | 2021-08-14 | Briscoe | Texas | 48045 | 190 | 7 |
1617844 | 1617844 | 2021-08-14 | Brooks | Texas | 48047 | 964 | 37 |
1617845 | 1617845 | 2021-08-14 | Brown | Texas | 48049 | 5011 | 144 |
1617846 | 1617846 | 2021-08-14 | Burleson | Texas | 48051 | 2667 | 48 |
1617847 | 1617847 | 2021-08-14 | Burnet | Texas | 48053 | 5690 | 76 |
1617848 | 1617848 | 2021-08-14 | Caldwell | Texas | 48055 | 6478 | 107 |
1617849 | 1617849 | 2021-08-14 | Calhoun | Texas | 48057 | 2794 | 26 |
1617850 | 1617850 | 2021-08-14 | Callahan | Texas | 48059 | 1316 | 41 |
1617851 | 1617851 | 2021-08-14 | Cameron | Texas | 48061 | 55180 | 1731 |
1617852 | 1617852 | 2021-08-14 | Camp | Texas | 48063 | 1515 | 45 |
1617853 | 1617853 | 2021-08-14 | Carson | Texas | 48065 | 646 | 14 |
1617854 | 1617854 | 2021-08-14 | Cass | Texas | 48067 | 2756 | 90 |
1617855 | 1617855 | 2021-08-14 | Castro | Texas | 48069 | 1116 | 32 |
1617856 | 1617856 | 2021-08-14 | Chambers | Texas | 48071 | 6224 | 62 |
1617857 | 1617857 | 2021-08-14 | Cherokee | Texas | 48073 | 4827 | 150 |
1617858 | 1617858 | 2021-08-14 | Childress | Texas | 48075 | 1384 | 17 |
1617859 | 1617859 | 2021-08-14 | Clay | Texas | 48077 | 1104 | 17 |
1617860 | 1617860 | 2021-08-14 | Cochran | Texas | 48079 | 348 | 15 |
1617861 | 1617861 | 2021-08-14 | Coke | Texas | 48081 | 501 | 13 |
1617862 | 1617862 | 2021-08-14 | Coleman | Texas | 48083 | 859 | 36 |
1617863 | 1617863 | 2021-08-14 | Collin | Texas | 48085 | 101641 | 875 |
1617864 | 1617864 | 2021-08-14 | Collingsworth | Texas | 48087 | 341 | 9 |
1617865 | 1617865 | 2021-08-14 | Colorado | Texas | 48089 | 1999 | 34 |
1617866 | 1617866 | 2021-08-14 | Comal | Texas | 48091 | 13976 | 351 |
1617867 | 1617867 | 2021-08-14 | Comanche | Texas | 48093 | 1687 | 52 |
1617868 | 1617868 | 2021-08-14 | Concho | Texas | 48095 | 587 | 9 |
1617869 | 1617869 | 2021-08-14 | Cooke | Texas | 48097 | 4120 | 72 |
1617870 | 1617870 | 2021-08-14 | Coryell | Texas | 48099 | 8175 | 95 |
1617871 | 1617871 | 2021-08-14 | Cottle | Texas | 48101 | 196 | 7 |
1617872 | 1617872 | 2021-08-14 | Crane | Texas | 48103 | 611 | 14 |
1617873 | 1617873 | 2021-08-14 | Crockett | Texas | 48105 | 647 | 15 |
1617874 | 1617874 | 2021-08-14 | Crosby | Texas | 48107 | 816 | 29 |
1617875 | 1617875 | 2021-08-14 | Culberson | Texas | 48109 | 369 | 11 |
1617876 | 1617876 | 2021-08-14 | Dallam | Texas | 48111 | 1005 | 26 |
1617877 | 1617877 | 2021-08-14 | Dallas | Texas | 48113 | 330213 | 4240 |
1617878 | 1617878 | 2021-08-14 | Dawson | Texas | 48115 | 1786 | 70 |
1617879 | 1617879 | 2021-08-14 | DeWitt | Texas | 48123 | 2081 | 63 |
1617880 | 1617880 | 2021-08-14 | Deaf Smith | Texas | 48117 | 3056 | 68 |
1617881 | 1617881 | 2021-08-14 | Delta | Texas | 48119 | 404 | 14 |
1617882 | 1617882 | 2021-08-14 | Denton | Texas | 48121 | 83509 | 800 |
1617883 | 1617883 | 2021-08-14 | Dickens | Texas | 48125 | 206 | 10 |
1617884 | 1617884 | 2021-08-14 | Dimmit | Texas | 48127 | 3235 | 39 |
1617885 | 1617885 | 2021-08-14 | Donley | Texas | 48129 | 438 | 15 |
1617886 | 1617886 | 2021-08-14 | Duval | Texas | 48131 | 1485 | 42 |
1617887 | 1617887 | 2021-08-14 | Eastland | Texas | 48133 | 1478 | 51 |
1617888 | 1617888 | 2021-08-14 | Ector | Texas | 48135 | 19745 | 392 |
1617889 | 1617889 | 2021-08-14 | Edwards | Texas | 48137 | 256 | 6 |
1617890 | 1617890 | 2021-08-14 | El Paso | Texas | 48141 | 139730 | 2767 |
1617891 | 1617891 | 2021-08-14 | Ellis | Texas | 48139 | 24992 | 331 |
1617892 | 1617892 | 2021-08-14 | Erath | Texas | 48143 | 4734 | 71 |
1617893 | 1617893 | 2021-08-14 | Falls | Texas | 48145 | 2183 | 34 |
1617894 | 1617894 | 2021-08-14 | Fannin | Texas | 48147 | 3714 | 112 |
1617895 | 1617895 | 2021-08-14 | Fayette | Texas | 48149 | 3083 | 71 |
1617896 | 1617896 | 2021-08-14 | Fisher | Texas | 48151 | 337 | 14 |
1617897 | 1617897 | 2021-08-14 | Floyd | Texas | 48153 | 972 | 30 |
1617898 | 1617898 | 2021-08-14 | Foard | Texas | 48155 | 137 | 10 |
1617899 | 1617899 | 2021-08-14 | Fort Bend | Texas | 48157 | 77656 | 760 |
1617900 | 1617900 | 2021-08-14 | Franklin | Texas | 48159 | 916 | 26 |
1617901 | 1617901 | 2021-08-14 | Freestone | Texas | 48161 | 2173 | 54 |
1617902 | 1617902 | 2021-08-14 | Frio | Texas | 48163 | 3265 | 57 |
1617903 | 1617903 | 2021-08-14 | Gaines | Texas | 48165 | 1550 | 46 |
1617904 | 1617904 | 2021-08-14 | Galveston | Texas | 48167 | 48919 | 476 |
1617905 | 1617905 | 2021-08-14 | Garza | Texas | 48169 | 584 | 22 |
1617906 | 1617906 | 2021-08-14 | Gillespie | Texas | 48171 | 2857 | 54 |
1617907 | 1617907 | 2021-08-14 | Glasscock | Texas | 48173 | 110 | 2 |
1617908 | 1617908 | 2021-08-14 | Goliad | Texas | 48175 | 533 | 16 |
1617909 | 1617909 | 2021-08-14 | Gonzales | Texas | 48177 | 2955 | 60 |
1617910 | 1617910 | 2021-08-14 | Gray | Texas | 48179 | 2641 | 58 |
1617911 | 1617911 | 2021-08-14 | Grayson | Texas | 48181 | 12312 | 353 |
1617912 | 1617912 | 2021-08-14 | Gregg | Texas | 48183 | 12938 | 370 |
1617913 | 1617913 | 2021-08-14 | Grimes | Texas | 48185 | 4283 | 74 |
1617914 | 1617914 | 2021-08-14 | Guadalupe | Texas | 48187 | 18181 | 233 |
1617915 | 1617915 | 2021-08-14 | Hale | Texas | 48189 | 6437 | 160 |
1617916 | 1617916 | 2021-08-14 | Hall | Texas | 48191 | 509 | 14 |
1617917 | 1617917 | 2021-08-14 | Hamilton | Texas | 48193 | 922 | 29 |
1617918 | 1617918 | 2021-08-14 | Hansford | Texas | 48195 | 968 | 24 |
1617919 | 1617919 | 2021-08-14 | Hardeman | Texas | 48197 | 403 | 12 |
1617920 | 1617920 | 2021-08-14 | Hardin | Texas | 48199 | 7082 | 122 |
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);