ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
250 rows where date = "2020-08-06" 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 |
---|---|---|---|---|---|---|---|
407839 | 407839 | 2020-08-06 | Anderson | Texas | 48001 | 2353 | 10 |
407840 | 407840 | 2020-08-06 | Andrews | Texas | 48003 | 277 | 6 |
407841 | 407841 | 2020-08-06 | Angelina | Texas | 48005 | 1795 | 40 |
407842 | 407842 | 2020-08-06 | Aransas | Texas | 48007 | 165 | 13 |
407843 | 407843 | 2020-08-06 | Archer | Texas | 48009 | 21 | 0 |
407844 | 407844 | 2020-08-06 | Armstrong | Texas | 48011 | 7 | 0 |
407845 | 407845 | 2020-08-06 | Atascosa | Texas | 48013 | 425 | 16 |
407846 | 407846 | 2020-08-06 | Austin | Texas | 48015 | 223 | 3 |
407847 | 407847 | 2020-08-06 | Bailey | Texas | 48017 | 168 | 4 |
407848 | 407848 | 2020-08-06 | Bandera | Texas | 48019 | 89 | 3 |
407849 | 407849 | 2020-08-06 | Bastrop | Texas | 48021 | 1344 | 20 |
407850 | 407850 | 2020-08-06 | Baylor | Texas | 48023 | 8 | 0 |
407851 | 407851 | 2020-08-06 | Bee | Texas | 48025 | 704 | 9 |
407852 | 407852 | 2020-08-06 | Bell | Texas | 48027 | 3733 | 33 |
407853 | 407853 | 2020-08-06 | Bexar | Texas | 48029 | 41951 | 705 |
407854 | 407854 | 2020-08-06 | Blanco | Texas | 48031 | 98 | 5 |
407855 | 407855 | 2020-08-06 | Bosque | Texas | 48035 | 152 | 2 |
407856 | 407856 | 2020-08-06 | Bowie | Texas | 48037 | 707 | 38 |
407857 | 407857 | 2020-08-06 | Brazoria | Texas | 48039 | 6988 | 85 |
407858 | 407858 | 2020-08-06 | Brazos | Texas | 48041 | 3997 | 46 |
407859 | 407859 | 2020-08-06 | Brewster | Texas | 48043 | 186 | 2 |
407860 | 407860 | 2020-08-06 | Briscoe | Texas | 48045 | 11 | 1 |
407861 | 407861 | 2020-08-06 | Brooks | Texas | 48047 | 95 | 1 |
407862 | 407862 | 2020-08-06 | Brown | Texas | 48049 | 388 | 23 |
407863 | 407863 | 2020-08-06 | Burleson | Texas | 48051 | 236 | 6 |
407864 | 407864 | 2020-08-06 | Burnet | Texas | 48053 | 552 | 8 |
407865 | 407865 | 2020-08-06 | Caldwell | Texas | 48055 | 1118 | 26 |
407866 | 407866 | 2020-08-06 | Calhoun | Texas | 48057 | 526 | 4 |
407867 | 407867 | 2020-08-06 | Callahan | Texas | 48059 | 46 | 3 |
407868 | 407868 | 2020-08-06 | Cameron | Texas | 48061 | 15865 | 405 |
407869 | 407869 | 2020-08-06 | Camp | Texas | 48063 | 221 | 5 |
407870 | 407870 | 2020-08-06 | Carson | Texas | 48065 | 14 | 0 |
407871 | 407871 | 2020-08-06 | Cass | Texas | 48067 | 166 | 8 |
407872 | 407872 | 2020-08-06 | Castro | Texas | 48069 | 190 | 4 |
407873 | 407873 | 2020-08-06 | Chambers | Texas | 48071 | 941 | 6 |
407874 | 407874 | 2020-08-06 | Cherokee | Texas | 48073 | 953 | 5 |
407875 | 407875 | 2020-08-06 | Childress | Texas | 48075 | 37 | 0 |
407876 | 407876 | 2020-08-06 | Clay | Texas | 48077 | 38 | 1 |
407877 | 407877 | 2020-08-06 | Cochran | Texas | 48079 | 31 | 0 |
407878 | 407878 | 2020-08-06 | Coke | Texas | 48081 | 40 | 1 |
407879 | 407879 | 2020-08-06 | Coleman | Texas | 48083 | 18 | 0 |
407880 | 407880 | 2020-08-06 | Collin | Texas | 48085 | 7074 | 87 |
407881 | 407881 | 2020-08-06 | Collingsworth | Texas | 48087 | 8 | 0 |
407882 | 407882 | 2020-08-06 | Colorado | Texas | 48089 | 265 | 2 |
407883 | 407883 | 2020-08-06 | Comal | Texas | 48091 | 2313 | 67 |
407884 | 407884 | 2020-08-06 | Comanche | Texas | 48093 | 141 | 3 |
407885 | 407885 | 2020-08-06 | Concho | Texas | 48095 | 26 | 0 |
407886 | 407886 | 2020-08-06 | Cooke | Texas | 48097 | 212 | 3 |
407887 | 407887 | 2020-08-06 | Coryell | Texas | 48099 | 654 | 5 |
407888 | 407888 | 2020-08-06 | Cottle | Texas | 48101 | 14 | 2 |
407889 | 407889 | 2020-08-06 | Crane | Texas | 48103 | 71 | 2 |
407890 | 407890 | 2020-08-06 | Crockett | Texas | 48105 | 157 | 3 |
407891 | 407891 | 2020-08-06 | Crosby | Texas | 48107 | 59 | 1 |
407892 | 407892 | 2020-08-06 | Culberson | Texas | 48109 | 17 | 2 |
407893 | 407893 | 2020-08-06 | Dallam | Texas | 48111 | 187 | 5 |
407894 | 407894 | 2020-08-06 | Dallas | Texas | 48113 | 54731 | 739 |
407895 | 407895 | 2020-08-06 | Dawson | Texas | 48115 | 140 | 4 |
407896 | 407896 | 2020-08-06 | DeWitt | Texas | 48123 | 643 | 15 |
407897 | 407897 | 2020-08-06 | Deaf Smith | Texas | 48117 | 730 | 19 |
407898 | 407898 | 2020-08-06 | Delta | Texas | 48119 | 16 | 0 |
407899 | 407899 | 2020-08-06 | Denton | Texas | 48121 | 7374 | 82 |
407900 | 407900 | 2020-08-06 | Dickens | Texas | 48125 | 4 | 1 |
407901 | 407901 | 2020-08-06 | Dimmit | Texas | 48127 | 142 | 3 |
407902 | 407902 | 2020-08-06 | Donley | Texas | 48129 | 46 | 0 |
407903 | 407903 | 2020-08-06 | Duval | Texas | 48131 | 164 | 6 |
407904 | 407904 | 2020-08-06 | Eastland | Texas | 48133 | 65 | 1 |
407905 | 407905 | 2020-08-06 | Ector | Texas | 48135 | 3512 | 54 |
407906 | 407906 | 2020-08-06 | Edwards | Texas | 48137 | 25 | 0 |
407907 | 407907 | 2020-08-06 | El Paso | Texas | 48141 | 15596 | 285 |
407908 | 407908 | 2020-08-06 | Ellis | Texas | 48139 | 2739 | 38 |
407909 | 407909 | 2020-08-06 | Erath | Texas | 48143 | 507 | 5 |
407910 | 407910 | 2020-08-06 | Falls | Texas | 48145 | 123 | 3 |
407911 | 407911 | 2020-08-06 | Fannin | Texas | 48147 | 237 | 8 |
407912 | 407912 | 2020-08-06 | Fayette | Texas | 48149 | 303 | 14 |
407913 | 407913 | 2020-08-06 | Fisher | Texas | 48151 | 26 | 1 |
407914 | 407914 | 2020-08-06 | Floyd | Texas | 48153 | 88 | 5 |
407915 | 407915 | 2020-08-06 | Foard | Texas | 48155 | 2 | 0 |
407916 | 407916 | 2020-08-06 | Fort Bend | Texas | 48157 | 8878 | 153 |
407917 | 407917 | 2020-08-06 | Franklin | Texas | 48159 | 90 | 1 |
407918 | 407918 | 2020-08-06 | Freestone | Texas | 48161 | 150 | 0 |
407919 | 407919 | 2020-08-06 | Frio | Texas | 48163 | 497 | 5 |
407920 | 407920 | 2020-08-06 | Gaines | Texas | 48165 | 149 | 0 |
407921 | 407921 | 2020-08-06 | Galveston | Texas | 48167 | 9230 | 110 |
407922 | 407922 | 2020-08-06 | Garza | Texas | 48169 | 99 | 3 |
407923 | 407923 | 2020-08-06 | Gillespie | Texas | 48171 | 176 | 5 |
407924 | 407924 | 2020-08-06 | Glasscock | Texas | 48173 | 6 | 0 |
407925 | 407925 | 2020-08-06 | Goliad | Texas | 48175 | 77 | 4 |
407926 | 407926 | 2020-08-06 | Gonzales | Texas | 48177 | 670 | 9 |
407927 | 407927 | 2020-08-06 | Gray | Texas | 48179 | 211 | 2 |
407928 | 407928 | 2020-08-06 | Grayson | Texas | 48181 | 1092 | 13 |
407929 | 407929 | 2020-08-06 | Gregg | Texas | 48183 | 1458 | 24 |
407930 | 407930 | 2020-08-06 | Grimes | Texas | 48185 | 858 | 20 |
407931 | 407931 | 2020-08-06 | Guadalupe | Texas | 48187 | 1670 | 51 |
407932 | 407932 | 2020-08-06 | Hale | Texas | 48189 | 1257 | 31 |
407933 | 407933 | 2020-08-06 | Hall | Texas | 48191 | 10 | 1 |
407934 | 407934 | 2020-08-06 | Hamilton | Texas | 48193 | 57 | 3 |
407935 | 407935 | 2020-08-06 | Hansford | Texas | 48195 | 64 | 2 |
407936 | 407936 | 2020-08-06 | Hardeman | Texas | 48197 | 17 | 0 |
407937 | 407937 | 2020-08-06 | Hardin | Texas | 48199 | 925 | 13 |
407938 | 407938 | 2020-08-06 | Harris | Texas | 48201 | 81919 | 1459 |
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);