ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
250 rows where "date" is on date 2020-07-18 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 |
---|---|---|---|---|---|---|---|
346811 | 346811 | 2020-07-18 | Anderson | Texas | 48001 | 2017 | 4 |
346812 | 346812 | 2020-07-18 | Andrews | Texas | 48003 | 187 | 2 |
346813 | 346813 | 2020-07-18 | Angelina | Texas | 48005 | 1000 | 12 |
346814 | 346814 | 2020-07-18 | Aransas | Texas | 48007 | 85 | 0 |
346815 | 346815 | 2020-07-18 | Archer | Texas | 48009 | 12 | 0 |
346816 | 346816 | 2020-07-18 | Armstrong | Texas | 48011 | 3 | 0 |
346817 | 346817 | 2020-07-18 | Atascosa | Texas | 48013 | 355 | 2 |
346818 | 346818 | 2020-07-18 | Austin | Texas | 48015 | 155 | 0 |
346819 | 346819 | 2020-07-18 | Bailey | Texas | 48017 | 120 | 1 |
346820 | 346820 | 2020-07-18 | Bandera | Texas | 48019 | 47 | 0 |
346821 | 346821 | 2020-07-18 | Bastrop | Texas | 48021 | 952 | 12 |
346822 | 346822 | 2020-07-18 | Baylor | Texas | 48023 | 1 | 0 |
346823 | 346823 | 2020-07-18 | Bee | Texas | 48025 | 218 | 1 |
346824 | 346824 | 2020-07-18 | Bell | Texas | 48027 | 2640 | 17 |
346825 | 346825 | 2020-07-18 | Bexar | Texas | 48029 | 28645 | 251 |
346826 | 346826 | 2020-07-18 | Blanco | Texas | 48031 | 68 | 1 |
346827 | 346827 | 2020-07-18 | Bosque | Texas | 48035 | 56 | 0 |
346828 | 346828 | 2020-07-18 | Bowie | Texas | 48037 | 596 | 29 |
346829 | 346829 | 2020-07-18 | Brazoria | Texas | 48039 | 4545 | 31 |
346830 | 346830 | 2020-07-18 | Brazos | Texas | 48041 | 3373 | 39 |
346831 | 346831 | 2020-07-18 | Brewster | Texas | 48043 | 161 | 1 |
346832 | 346832 | 2020-07-18 | Briscoe | Texas | 48045 | 9 | 1 |
346833 | 346833 | 2020-07-18 | Brooks | Texas | 48047 | 55 | 0 |
346834 | 346834 | 2020-07-18 | Brown | Texas | 48049 | 273 | 13 |
346835 | 346835 | 2020-07-18 | Burleson | Texas | 48051 | 182 | 0 |
346836 | 346836 | 2020-07-18 | Burnet | Texas | 48053 | 320 | 6 |
346837 | 346837 | 2020-07-18 | Caldwell | Texas | 48055 | 836 | 5 |
346838 | 346838 | 2020-07-18 | Calhoun | Texas | 48057 | 212 | 3 |
346839 | 346839 | 2020-07-18 | Callahan | Texas | 48059 | 32 | 2 |
346840 | 346840 | 2020-07-18 | Cameron | Texas | 48061 | 5891 | 96 |
346841 | 346841 | 2020-07-18 | Camp | Texas | 48063 | 163 | 2 |
346842 | 346842 | 2020-07-18 | Carson | Texas | 48065 | 10 | 0 |
346843 | 346843 | 2020-07-18 | Cass | Texas | 48067 | 84 | 3 |
346844 | 346844 | 2020-07-18 | Castro | Texas | 48069 | 142 | 1 |
346845 | 346845 | 2020-07-18 | Chambers | Texas | 48071 | 698 | 5 |
346846 | 346846 | 2020-07-18 | Cherokee | Texas | 48073 | 489 | 2 |
346847 | 346847 | 2020-07-18 | Childress | Texas | 48075 | 9 | 0 |
346848 | 346848 | 2020-07-18 | Clay | Texas | 48077 | 19 | 0 |
346849 | 346849 | 2020-07-18 | Cochran | Texas | 48079 | 9 | 0 |
346850 | 346850 | 2020-07-18 | Coke | Texas | 48081 | 9 | 1 |
346851 | 346851 | 2020-07-18 | Coleman | Texas | 48083 | 7 | 0 |
346852 | 346852 | 2020-07-18 | Collin | Texas | 48085 | 5291 | 64 |
346853 | 346853 | 2020-07-18 | Collingsworth | Texas | 48087 | 6 | 0 |
346854 | 346854 | 2020-07-18 | Colorado | Texas | 48089 | 189 | 0 |
346855 | 346855 | 2020-07-18 | Comal | Texas | 48091 | 1667 | 37 |
346856 | 346856 | 2020-07-18 | Comanche | Texas | 48093 | 44 | 1 |
346857 | 346857 | 2020-07-18 | Concho | Texas | 48095 | 17 | 0 |
346858 | 346858 | 2020-07-18 | Cooke | Texas | 48097 | 120 | 0 |
346859 | 346859 | 2020-07-18 | Coryell | Texas | 48099 | 426 | 3 |
346860 | 346860 | 2020-07-18 | Cottle | Texas | 48101 | 6 | 1 |
346861 | 346861 | 2020-07-18 | Crane | Texas | 48103 | 65 | 10 |
346862 | 346862 | 2020-07-18 | Crockett | Texas | 48105 | 96 | 1 |
346863 | 346863 | 2020-07-18 | Crosby | Texas | 48107 | 36 | 2 |
346864 | 346864 | 2020-07-18 | Culberson | Texas | 48109 | 13 | 1 |
346865 | 346865 | 2020-07-18 | Dallam | Texas | 48111 | 146 | 1 |
346866 | 346866 | 2020-07-18 | Dallas | Texas | 48113 | 40222 | 523 |
346867 | 346867 | 2020-07-18 | Dawson | Texas | 48115 | 106 | 1 |
346868 | 346868 | 2020-07-18 | DeWitt | Texas | 48123 | 306 | 7 |
346869 | 346869 | 2020-07-18 | Deaf Smith | Texas | 48117 | 439 | 17 |
346870 | 346870 | 2020-07-18 | Delta | Texas | 48119 | 9 | 0 |
346871 | 346871 | 2020-07-18 | Denton | Texas | 48121 | 4887 | 42 |
346872 | 346872 | 2020-07-18 | Dickens | Texas | 48125 | 4 | 0 |
346873 | 346873 | 2020-07-18 | Dimmit | Texas | 48127 | 55 | 0 |
346874 | 346874 | 2020-07-18 | Donley | Texas | 48129 | 35 | 0 |
346875 | 346875 | 2020-07-18 | Duval | Texas | 48131 | 97 | 0 |
346876 | 346876 | 2020-07-18 | Eastland | Texas | 48133 | 29 | 0 |
346877 | 346877 | 2020-07-18 | Ector | Texas | 48135 | 2305 | 27 |
346878 | 346878 | 2020-07-18 | Edwards | Texas | 48137 | 13 | 0 |
346879 | 346879 | 2020-07-18 | El Paso | Texas | 48141 | 11132 | 179 |
346880 | 346880 | 2020-07-18 | Ellis | Texas | 48139 | 1972 | 21 |
346881 | 346881 | 2020-07-18 | Erath | Texas | 48143 | 286 | 1 |
346882 | 346882 | 2020-07-18 | Falls | Texas | 48145 | 66 | 0 |
346883 | 346883 | 2020-07-18 | Fannin | Texas | 48147 | 165 | 8 |
346884 | 346884 | 2020-07-18 | Fayette | Texas | 48149 | 206 | 4 |
346885 | 346885 | 2020-07-18 | Fisher | Texas | 48151 | 22 | 1 |
346886 | 346886 | 2020-07-18 | Floyd | Texas | 48153 | 61 | 3 |
346887 | 346887 | 2020-07-18 | Foard | Texas | 48155 | 1 | 0 |
346888 | 346888 | 2020-07-18 | Fort Bend | Texas | 48157 | 5979 | 71 |
346889 | 346889 | 2020-07-18 | Franklin | Texas | 48159 | 66 | 1 |
346890 | 346890 | 2020-07-18 | Freestone | Texas | 48161 | 93 | 0 |
346891 | 346891 | 2020-07-18 | Frio | Texas | 48163 | 349 | 1 |
346892 | 346892 | 2020-07-18 | Gaines | Texas | 48165 | 57 | 0 |
346893 | 346893 | 2020-07-18 | Galveston | Texas | 48167 | 7125 | 58 |
346894 | 346894 | 2020-07-18 | Garza | Texas | 48169 | 60 | 1 |
346895 | 346895 | 2020-07-18 | Gillespie | Texas | 48171 | 120 | 0 |
346896 | 346896 | 2020-07-18 | Glasscock | Texas | 48173 | 6 | 0 |
346897 | 346897 | 2020-07-18 | Goliad | Texas | 48175 | 31 | 0 |
346898 | 346898 | 2020-07-18 | Gonzales | Texas | 48177 | 432 | 4 |
346899 | 346899 | 2020-07-18 | Gray | Texas | 48179 | 139 | 4 |
346900 | 346900 | 2020-07-18 | Grayson | Texas | 48181 | 844 | 8 |
346901 | 346901 | 2020-07-18 | Gregg | Texas | 48183 | 1034 | 16 |
346902 | 346902 | 2020-07-18 | Grimes | Texas | 48185 | 702 | 2 |
346903 | 346903 | 2020-07-18 | Guadalupe | Texas | 48187 | 1281 | 4 |
346904 | 346904 | 2020-07-18 | Hale | Texas | 48189 | 886 | 19 |
346905 | 346905 | 2020-07-18 | Hall | Texas | 48191 | 2 | 1 |
346906 | 346906 | 2020-07-18 | Hamilton | Texas | 48193 | 41 | 1 |
346907 | 346907 | 2020-07-18 | Hansford | Texas | 48195 | 43 | 2 |
346908 | 346908 | 2020-07-18 | Hardeman | Texas | 48197 | 6 | 0 |
346909 | 346909 | 2020-07-18 | Hardin | Texas | 48199 | 524 | 5 |
346910 | 346910 | 2020-07-18 | Harris | Texas | 48201 | 54806 | 533 |
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);