ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
251 rows where "date" is on date 2020-09-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 |
---|---|---|---|---|---|---|---|
533801 | 533801 | 2020-09-14 | Anderson | Texas | 48001 | 2762 | 24 |
533802 | 533802 | 2020-09-14 | Andrews | Texas | 48003 | 400 | 8 |
533803 | 533803 | 2020-09-14 | Angelina | Texas | 48005 | 2367 | 77 |
533804 | 533804 | 2020-09-14 | Aransas | Texas | 48007 | 302 | 18 |
533805 | 533805 | 2020-09-14 | Archer | Texas | 48009 | 67 | 1 |
533806 | 533806 | 2020-09-14 | Armstrong | Texas | 48011 | 12 | 1 |
533807 | 533807 | 2020-09-14 | Atascosa | Texas | 48013 | 615 | 30 |
533808 | 533808 | 2020-09-14 | Austin | Texas | 48015 | 460 | 9 |
533809 | 533809 | 2020-09-14 | Bailey | Texas | 48017 | 204 | 4 |
533810 | 533810 | 2020-09-14 | Bandera | Texas | 48019 | 113 | 7 |
533811 | 533811 | 2020-09-14 | Bastrop | Texas | 48021 | 1691 | 28 |
533812 | 533812 | 2020-09-14 | Baylor | Texas | 48023 | 14 | 0 |
533813 | 533813 | 2020-09-14 | Bee | Texas | 48025 | 1814 | 27 |
533814 | 533814 | 2020-09-14 | Bell | Texas | 48027 | 5100 | 75 |
533815 | 533815 | 2020-09-14 | Bexar | Texas | 48029 | 50028 | 1205 |
533816 | 533816 | 2020-09-14 | Blanco | Texas | 48031 | 135 | 5 |
533817 | 533817 | 2020-09-14 | Bosque | Texas | 48035 | 263 | 6 |
533818 | 533818 | 2020-09-14 | Bowie | Texas | 48037 | 1177 | 71 |
533819 | 533819 | 2020-09-14 | Brazoria | Texas | 48039 | 10545 | 155 |
533820 | 533820 | 2020-09-14 | Brazos | Texas | 48041 | 6291 | 60 |
533821 | 533821 | 2020-09-14 | Brewster | Texas | 48043 | 212 | 2 |
533822 | 533822 | 2020-09-14 | Briscoe | Texas | 48045 | 12 | 1 |
533823 | 533823 | 2020-09-14 | Brooks | Texas | 48047 | 282 | 20 |
533824 | 533824 | 2020-09-14 | Brown | Texas | 48049 | 721 | 26 |
533825 | 533825 | 2020-09-14 | Burleson | Texas | 48051 | 312 | 6 |
533826 | 533826 | 2020-09-14 | Burnet | Texas | 48053 | 680 | 12 |
533827 | 533827 | 2020-09-14 | Caldwell | Texas | 48055 | 1412 | 34 |
533828 | 533828 | 2020-09-14 | Calhoun | Texas | 48057 | 618 | 7 |
533829 | 533829 | 2020-09-14 | Callahan | Texas | 48059 | 75 | 3 |
533830 | 533830 | 2020-09-14 | Cameron | Texas | 48061 | 22152 | 843 |
533831 | 533831 | 2020-09-14 | Camp | Texas | 48063 | 335 | 9 |
533832 | 533832 | 2020-09-14 | Carson | Texas | 48065 | 17 | 0 |
533833 | 533833 | 2020-09-14 | Cass | Texas | 48067 | 291 | 14 |
533834 | 533834 | 2020-09-14 | Castro | Texas | 48069 | 241 | 5 |
533835 | 533835 | 2020-09-14 | Chambers | Texas | 48071 | 1220 | 14 |
533836 | 533836 | 2020-09-14 | Cherokee | Texas | 48073 | 1467 | 24 |
533837 | 533837 | 2020-09-14 | Childress | Texas | 48075 | 63 | 0 |
533838 | 533838 | 2020-09-14 | Clay | Texas | 48077 | 72 | 1 |
533839 | 533839 | 2020-09-14 | Cochran | Texas | 48079 | 47 | 1 |
533840 | 533840 | 2020-09-14 | Coke | Texas | 48081 | 50 | 3 |
533841 | 533841 | 2020-09-14 | Coleman | Texas | 48083 | 61 | 3 |
533842 | 533842 | 2020-09-14 | Collin | Texas | 48085 | 12239 | 124 |
533843 | 533843 | 2020-09-14 | Collingsworth | Texas | 48087 | 18 | 0 |
533844 | 533844 | 2020-09-14 | Colorado | Texas | 48089 | 460 | 4 |
533845 | 533845 | 2020-09-14 | Comal | Texas | 48091 | 3203 | 114 |
533846 | 533846 | 2020-09-14 | Comanche | Texas | 48093 | 238 | 3 |
533847 | 533847 | 2020-09-14 | Concho | Texas | 48095 | 62 | 2 |
533848 | 533848 | 2020-09-14 | Cooke | Texas | 48097 | 358 | 5 |
533849 | 533849 | 2020-09-14 | Coryell | Texas | 48099 | 1767 | 11 |
533850 | 533850 | 2020-09-14 | Cottle | Texas | 48101 | 20 | 2 |
533851 | 533851 | 2020-09-14 | Crane | Texas | 48103 | 71 | 2 |
533852 | 533852 | 2020-09-14 | Crockett | Texas | 48105 | 164 | 6 |
533853 | 533853 | 2020-09-14 | Crosby | Texas | 48107 | 83 | 1 |
533854 | 533854 | 2020-09-14 | Culberson | Texas | 48109 | 39 | 2 |
533855 | 533855 | 2020-09-14 | Dallam | Texas | 48111 | 219 | 8 |
533856 | 533856 | 2020-09-14 | Dallas | Texas | 48113 | 79263 | 1046 |
533857 | 533857 | 2020-09-14 | Dawson | Texas | 48115 | 268 | 8 |
533858 | 533858 | 2020-09-14 | DeWitt | Texas | 48123 | 937 | 29 |
533859 | 533859 | 2020-09-14 | Deaf Smith | Texas | 48117 | 1001 | 20 |
533860 | 533860 | 2020-09-14 | Delta | Texas | 48119 | 22 | 0 |
533861 | 533861 | 2020-09-14 | Denton | Texas | 48121 | 11130 | 142 |
533862 | 533862 | 2020-09-14 | Dickens | Texas | 48125 | 48 | 2 |
533863 | 533863 | 2020-09-14 | Dimmit | Texas | 48127 | 190 | 7 |
533864 | 533864 | 2020-09-14 | Donley | Texas | 48129 | 59 | 1 |
533865 | 533865 | 2020-09-14 | Duval | Texas | 48131 | 405 | 14 |
533866 | 533866 | 2020-09-14 | Eastland | Texas | 48133 | 144 | 3 |
533867 | 533867 | 2020-09-14 | Ector | Texas | 48135 | 4473 | 87 |
533868 | 533868 | 2020-09-14 | Edwards | Texas | 48137 | 34 | 1 |
533869 | 533869 | 2020-09-14 | El Paso | Texas | 48141 | 21731 | 482 |
533870 | 533870 | 2020-09-14 | Ellis | Texas | 48139 | 3998 | 62 |
533871 | 533871 | 2020-09-14 | Erath | Texas | 48143 | 760 | 11 |
533872 | 533872 | 2020-09-14 | Falls | Texas | 48145 | 186 | 3 |
533873 | 533873 | 2020-09-14 | Fannin | Texas | 48147 | 641 | 12 |
533874 | 533874 | 2020-09-14 | Fayette | Texas | 48149 | 396 | 18 |
533875 | 533875 | 2020-09-14 | Fisher | Texas | 48151 | 62 | 1 |
533876 | 533876 | 2020-09-14 | Floyd | Texas | 48153 | 100 | 9 |
533877 | 533877 | 2020-09-14 | Foard | Texas | 48155 | 5 | 0 |
533878 | 533878 | 2020-09-14 | Fort Bend | Texas | 48157 | 15471 | 268 |
533879 | 533879 | 2020-09-14 | Franklin | Texas | 48159 | 123 | 6 |
533880 | 533880 | 2020-09-14 | Freestone | Texas | 48161 | 393 | 1 |
533881 | 533881 | 2020-09-14 | Frio | Texas | 48163 | 664 | 8 |
533882 | 533882 | 2020-09-14 | Gaines | Texas | 48165 | 279 | 8 |
533883 | 533883 | 2020-09-14 | Galveston | Texas | 48167 | 11301 | 151 |
533884 | 533884 | 2020-09-14 | Garza | Texas | 48169 | 102 | 4 |
533885 | 533885 | 2020-09-14 | Gillespie | Texas | 48171 | 210 | 9 |
533886 | 533886 | 2020-09-14 | Glasscock | Texas | 48173 | 6 | 0 |
533887 | 533887 | 2020-09-14 | Goliad | Texas | 48175 | 129 | 6 |
533888 | 533888 | 2020-09-14 | Gonzales | Texas | 48177 | 822 | 14 |
533889 | 533889 | 2020-09-14 | Gray | Texas | 48179 | 258 | 5 |
533890 | 533890 | 2020-09-14 | Grayson | Texas | 48181 | 1577 | 33 |
533891 | 533891 | 2020-09-14 | Gregg | Texas | 48183 | 2012 | 59 |
533892 | 533892 | 2020-09-14 | Grimes | Texas | 48185 | 1061 | 31 |
533893 | 533893 | 2020-09-14 | Guadalupe | Texas | 48187 | 1941 | 76 |
533894 | 533894 | 2020-09-14 | Hale | Texas | 48189 | 1753 | 51 |
533895 | 533895 | 2020-09-14 | Hall | Texas | 48191 | 19 | 1 |
533896 | 533896 | 2020-09-14 | Hamilton | Texas | 48193 | 108 | 4 |
533897 | 533897 | 2020-09-14 | Hansford | Texas | 48195 | 108 | 4 |
533898 | 533898 | 2020-09-14 | Hardeman | Texas | 48197 | 24 | 0 |
533899 | 533899 | 2020-09-14 | Hardin | Texas | 48199 | 1258 | 27 |
533900 | 533900 | 2020-09-14 | Harris | Texas | 48201 | 117568 | 2423 |
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);