ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
254 rows where date = "2021-01-11" 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 |
---|---|---|---|---|---|---|---|
919814 | 919814 | 2021-01-11 | Anderson | Texas | 48001 | 5484 | 71 |
919815 | 919815 | 2021-01-11 | Andrews | Texas | 48003 | 1523 | 32 |
919816 | 919816 | 2021-01-11 | Angelina | Texas | 48005 | 6237 | 164 |
919817 | 919817 | 2021-01-11 | Aransas | Texas | 48007 | 810 | 25 |
919818 | 919818 | 2021-01-11 | Archer | Texas | 48009 | 648 | 6 |
919819 | 919819 | 2021-01-11 | Armstrong | Texas | 48011 | 116 | 5 |
919820 | 919820 | 2021-01-11 | Atascosa | Texas | 48013 | 3436 | 78 |
919821 | 919821 | 2021-01-11 | Austin | Texas | 48015 | 1224 | 15 |
919822 | 919822 | 2021-01-11 | Bailey | Texas | 48017 | 734 | 13 |
919823 | 919823 | 2021-01-11 | Bandera | Texas | 48019 | 746 | 15 |
919824 | 919824 | 2021-01-11 | Bastrop | Texas | 48021 | 4142 | 48 |
919825 | 919825 | 2021-01-11 | Baylor | Texas | 48023 | 240 | 7 |
919826 | 919826 | 2021-01-11 | Bee | Texas | 48025 | 2898 | 49 |
919827 | 919827 | 2021-01-11 | Bell | Texas | 48027 | 15499 | 182 |
919828 | 919828 | 2021-01-11 | Bexar | Texas | 48029 | 135116 | 1862 |
919829 | 919829 | 2021-01-11 | Blanco | Texas | 48031 | 305 | 9 |
919830 | 919830 | 2021-01-11 | Borden | Texas | 48033 | 18 | 0 |
919831 | 919831 | 2021-01-11 | Bosque | Texas | 48035 | 934 | 18 |
919832 | 919832 | 2021-01-11 | Bowie | Texas | 48037 | 4379 | 131 |
919833 | 919833 | 2021-01-11 | Brazoria | Texas | 48039 | 23990 | 255 |
919834 | 919834 | 2021-01-11 | Brazos | Texas | 48041 | 15320 | 147 |
919835 | 919835 | 2021-01-11 | Brewster | Texas | 48043 | 918 | 8 |
919836 | 919836 | 2021-01-11 | Briscoe | Texas | 48045 | 108 | 3 |
919837 | 919837 | 2021-01-11 | Brooks | Texas | 48047 | 652 | 29 |
919838 | 919838 | 2021-01-11 | Brown | Texas | 48049 | 3182 | 86 |
919839 | 919839 | 2021-01-11 | Burleson | Texas | 48051 | 1024 | 19 |
919840 | 919840 | 2021-01-11 | Burnet | Texas | 48053 | 2103 | 30 |
919841 | 919841 | 2021-01-11 | Caldwell | Texas | 48055 | 2625 | 50 |
919842 | 919842 | 2021-01-11 | Calhoun | Texas | 48057 | 1298 | 11 |
919843 | 919843 | 2021-01-11 | Callahan | Texas | 48059 | 902 | 24 |
919844 | 919844 | 2021-01-11 | Cameron | Texas | 48061 | 31347 | 1212 |
919845 | 919845 | 2021-01-11 | Camp | Texas | 48063 | 897 | 28 |
919846 | 919846 | 2021-01-11 | Carson | Texas | 48065 | 325 | 11 |
919847 | 919847 | 2021-01-11 | Cass | Texas | 48067 | 1386 | 54 |
919848 | 919848 | 2021-01-11 | Castro | Texas | 48069 | 824 | 19 |
919849 | 919849 | 2021-01-11 | Chambers | Texas | 48071 | 3165 | 28 |
919850 | 919850 | 2021-01-11 | Cherokee | Texas | 48073 | 3348 | 84 |
919851 | 919851 | 2021-01-11 | Childress | Texas | 48075 | 1260 | 11 |
919852 | 919852 | 2021-01-11 | Clay | Texas | 48077 | 823 | 12 |
919853 | 919853 | 2021-01-11 | Cochran | Texas | 48079 | 210 | 11 |
919854 | 919854 | 2021-01-11 | Coke | Texas | 48081 | 415 | 10 |
919855 | 919855 | 2021-01-11 | Coleman | Texas | 48083 | 533 | 16 |
919856 | 919856 | 2021-01-11 | Collin | Texas | 48085 | 57870 | 422 |
919857 | 919857 | 2021-01-11 | Collingsworth | Texas | 48087 | 229 | 6 |
919858 | 919858 | 2021-01-11 | Colorado | Texas | 48089 | 1146 | 16 |
919859 | 919859 | 2021-01-11 | Comal | Texas | 48091 | 6863 | 186 |
919860 | 919860 | 2021-01-11 | Comanche | Texas | 48093 | 1098 | 33 |
919861 | 919861 | 2021-01-11 | Concho | Texas | 48095 | 237 | 4 |
919862 | 919862 | 2021-01-11 | Cooke | Texas | 48097 | 2633 | 40 |
919863 | 919863 | 2021-01-11 | Coryell | Texas | 48099 | 4006 | 36 |
919864 | 919864 | 2021-01-11 | Cottle | Texas | 48101 | 168 | 6 |
919865 | 919865 | 2021-01-11 | Crane | Texas | 48103 | 536 | 10 |
919866 | 919866 | 2021-01-11 | Crockett | Texas | 48105 | 484 | 12 |
919867 | 919867 | 2021-01-11 | Crosby | Texas | 48107 | 379 | 22 |
919868 | 919868 | 2021-01-11 | Culberson | Texas | 48109 | 283 | 4 |
919869 | 919869 | 2021-01-11 | Dallam | Texas | 48111 | 465 | 19 |
919870 | 919870 | 2021-01-11 | Dallas | Texas | 48113 | 219086 | 2242 |
919871 | 919871 | 2021-01-11 | Dawson | Texas | 48115 | 1517 | 55 |
919872 | 919872 | 2021-01-11 | DeWitt | Texas | 48123 | 1526 | 50 |
919873 | 919873 | 2021-01-11 | Deaf Smith | Texas | 48117 | 2479 | 57 |
919874 | 919874 | 2021-01-11 | Delta | Texas | 48119 | 172 | 4 |
919875 | 919875 | 2021-01-11 | Denton | Texas | 48121 | 43580 | 393 |
919876 | 919876 | 2021-01-11 | Dickens | Texas | 48125 | 133 | 7 |
919877 | 919877 | 2021-01-11 | Dimmit | Texas | 48127 | 797 | 13 |
919878 | 919878 | 2021-01-11 | Donley | Texas | 48129 | 275 | 7 |
919879 | 919879 | 2021-01-11 | Duval | Texas | 48131 | 985 | 31 |
919880 | 919880 | 2021-01-11 | Eastland | Texas | 48133 | 910 | 17 |
919881 | 919881 | 2021-01-11 | Ector | Texas | 48135 | 11543 | 246 |
919882 | 919882 | 2021-01-11 | Edwards | Texas | 48137 | 200 | 3 |
919883 | 919883 | 2021-01-11 | El Paso | Texas | 48141 | 103787 | 1853 |
919884 | 919884 | 2021-01-11 | Ellis | Texas | 48139 | 14984 | 185 |
919885 | 919885 | 2021-01-11 | Erath | Texas | 48143 | 3262 | 34 |
919886 | 919886 | 2021-01-11 | Falls | Texas | 48145 | 1252 | 20 |
919887 | 919887 | 2021-01-11 | Fannin | Texas | 48147 | 2193 | 59 |
919888 | 919888 | 2021-01-11 | Fayette | Texas | 48149 | 1367 | 39 |
919889 | 919889 | 2021-01-11 | Fisher | Texas | 48151 | 250 | 10 |
919890 | 919890 | 2021-01-11 | Floyd | Texas | 48153 | 611 | 25 |
919891 | 919891 | 2021-01-11 | Foard | Texas | 48155 | 71 | 5 |
919892 | 919892 | 2021-01-11 | Fort Bend | Texas | 48157 | 40143 | 413 |
919893 | 919893 | 2021-01-11 | Franklin | Texas | 48159 | 520 | 15 |
919894 | 919894 | 2021-01-11 | Freestone | Texas | 48161 | 967 | 26 |
919895 | 919895 | 2021-01-11 | Frio | Texas | 48163 | 2021 | 19 |
919896 | 919896 | 2021-01-11 | Gaines | Texas | 48165 | 1279 | 32 |
919897 | 919897 | 2021-01-11 | Galveston | Texas | 48167 | 24028 | 231 |
919898 | 919898 | 2021-01-11 | Garza | Texas | 48169 | 276 | 17 |
919899 | 919899 | 2021-01-11 | Gillespie | Texas | 48171 | 1734 | 25 |
919900 | 919900 | 2021-01-11 | Glasscock | Texas | 48173 | 96 | 1 |
919901 | 919901 | 2021-01-11 | Goliad | Texas | 48175 | 299 | 8 |
919902 | 919902 | 2021-01-11 | Gonzales | Texas | 48177 | 1827 | 25 |
919903 | 919903 | 2021-01-11 | Gray | Texas | 48179 | 1723 | 39 |
919904 | 919904 | 2021-01-11 | Grayson | Texas | 48181 | 7922 | 194 |
919905 | 919905 | 2021-01-11 | Gregg | Texas | 48183 | 7446 | 199 |
919906 | 919906 | 2021-01-11 | Grimes | Texas | 48185 | 1899 | 48 |
919907 | 919907 | 2021-01-11 | Guadalupe | Texas | 48187 | 8325 | 116 |
919908 | 919908 | 2021-01-11 | Hale | Texas | 48189 | 5497 | 132 |
919909 | 919909 | 2021-01-11 | Hall | Texas | 48191 | 263 | 9 |
919910 | 919910 | 2021-01-11 | Hamilton | Texas | 48193 | 517 | 18 |
919911 | 919911 | 2021-01-11 | Hansford | Texas | 48195 | 662 | 15 |
919912 | 919912 | 2021-01-11 | Hardeman | Texas | 48197 | 276 | 9 |
919913 | 919913 | 2021-01-11 | Hardin | Texas | 48199 | 3809 | 58 |
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);