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-01-19 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 |
---|---|---|---|---|---|---|---|
945777 | 945777 | 2021-01-19 | Anderson | Texas | 48001 | 5575 | 75 |
945778 | 945778 | 2021-01-19 | Andrews | Texas | 48003 | 1606 | 37 |
945779 | 945779 | 2021-01-19 | Angelina | Texas | 48005 | 6765 | 193 |
945780 | 945780 | 2021-01-19 | Aransas | Texas | 48007 | 895 | 26 |
945781 | 945781 | 2021-01-19 | Archer | Texas | 48009 | 694 | 10 |
945782 | 945782 | 2021-01-19 | Armstrong | Texas | 48011 | 128 | 6 |
945783 | 945783 | 2021-01-19 | Atascosa | Texas | 48013 | 3781 | 90 |
945784 | 945784 | 2021-01-19 | Austin | Texas | 48015 | 1404 | 18 |
945785 | 945785 | 2021-01-19 | Bailey | Texas | 48017 | 742 | 15 |
945786 | 945786 | 2021-01-19 | Bandera | Texas | 48019 | 820 | 20 |
945787 | 945787 | 2021-01-19 | Bastrop | Texas | 48021 | 4373 | 57 |
945788 | 945788 | 2021-01-19 | Baylor | Texas | 48023 | 274 | 9 |
945789 | 945789 | 2021-01-19 | Bee | Texas | 48025 | 3082 | 53 |
945790 | 945790 | 2021-01-19 | Bell | Texas | 48027 | 16965 | 214 |
945791 | 945791 | 2021-01-19 | Bexar | Texas | 48029 | 152243 | 2040 |
945792 | 945792 | 2021-01-19 | Blanco | Texas | 48031 | 318 | 11 |
945793 | 945793 | 2021-01-19 | Borden | Texas | 48033 | 18 | 0 |
945794 | 945794 | 2021-01-19 | Bosque | Texas | 48035 | 988 | 20 |
945795 | 945795 | 2021-01-19 | Bowie | Texas | 48037 | 4876 | 139 |
945796 | 945796 | 2021-01-19 | Brazoria | Texas | 48039 | 26046 | 277 |
945797 | 945797 | 2021-01-19 | Brazos | Texas | 48041 | 17093 | 162 |
945798 | 945798 | 2021-01-19 | Brewster | Texas | 48043 | 945 | 8 |
945799 | 945799 | 2021-01-19 | Briscoe | Texas | 48045 | 114 | 3 |
945800 | 945800 | 2021-01-19 | Brooks | Texas | 48047 | 685 | 29 |
945801 | 945801 | 2021-01-19 | Brown | Texas | 48049 | 3490 | 95 |
945802 | 945802 | 2021-01-19 | Burleson | Texas | 48051 | 1093 | 22 |
945803 | 945803 | 2021-01-19 | Burnet | Texas | 48053 | 2196 | 34 |
945804 | 945804 | 2021-01-19 | Caldwell | Texas | 48055 | 2738 | 55 |
945805 | 945805 | 2021-01-19 | Calhoun | Texas | 48057 | 1361 | 13 |
945806 | 945806 | 2021-01-19 | Callahan | Texas | 48059 | 931 | 28 |
945807 | 945807 | 2021-01-19 | Cameron | Texas | 48061 | 33057 | 1236 |
945808 | 945808 | 2021-01-19 | Camp | Texas | 48063 | 969 | 32 |
945809 | 945809 | 2021-01-19 | Carson | Texas | 48065 | 331 | 11 |
945810 | 945810 | 2021-01-19 | Cass | Texas | 48067 | 1499 | 59 |
945811 | 945811 | 2021-01-19 | Castro | Texas | 48069 | 832 | 22 |
945812 | 945812 | 2021-01-19 | Chambers | Texas | 48071 | 3473 | 31 |
945813 | 945813 | 2021-01-19 | Cherokee | Texas | 48073 | 3491 | 92 |
945814 | 945814 | 2021-01-19 | Childress | Texas | 48075 | 1292 | 13 |
945815 | 945815 | 2021-01-19 | Clay | Texas | 48077 | 874 | 13 |
945816 | 945816 | 2021-01-19 | Cochran | Texas | 48079 | 216 | 12 |
945817 | 945817 | 2021-01-19 | Coke | Texas | 48081 | 430 | 10 |
945818 | 945818 | 2021-01-19 | Coleman | Texas | 48083 | 579 | 20 |
945819 | 945819 | 2021-01-19 | Collin | Texas | 48085 | 64721 | 483 |
945820 | 945820 | 2021-01-19 | Collingsworth | Texas | 48087 | 238 | 8 |
945821 | 945821 | 2021-01-19 | Colorado | Texas | 48089 | 1251 | 17 |
945822 | 945822 | 2021-01-19 | Comal | Texas | 48091 | 7314 | 220 |
945823 | 945823 | 2021-01-19 | Comanche | Texas | 48093 | 1118 | 36 |
945824 | 945824 | 2021-01-19 | Concho | Texas | 48095 | 245 | 4 |
945825 | 945825 | 2021-01-19 | Cooke | Texas | 48097 | 2806 | 48 |
945826 | 945826 | 2021-01-19 | Coryell | Texas | 48099 | 4319 | 45 |
945827 | 945827 | 2021-01-19 | Cottle | Texas | 48101 | 176 | 7 |
945828 | 945828 | 2021-01-19 | Crane | Texas | 48103 | 487 | 11 |
945829 | 945829 | 2021-01-19 | Crockett | Texas | 48105 | 472 | 13 |
945830 | 945830 | 2021-01-19 | Crosby | Texas | 48107 | 383 | 22 |
945831 | 945831 | 2021-01-19 | Culberson | Texas | 48109 | 294 | 4 |
945832 | 945832 | 2021-01-19 | Dallam | Texas | 48111 | 466 | 20 |
945833 | 945833 | 2021-01-19 | Dallas | Texas | 48113 | 236214 | 2453 |
945834 | 945834 | 2021-01-19 | Dawson | Texas | 48115 | 1575 | 59 |
945835 | 945835 | 2021-01-19 | DeWitt | Texas | 48123 | 1553 | 50 |
945836 | 945836 | 2021-01-19 | Deaf Smith | Texas | 48117 | 2522 | 60 |
945837 | 945837 | 2021-01-19 | Delta | Texas | 48119 | 213 | 5 |
945838 | 945838 | 2021-01-19 | Denton | Texas | 48121 | 47336 | 439 |
945839 | 945839 | 2021-01-19 | Dickens | Texas | 48125 | 136 | 7 |
945840 | 945840 | 2021-01-19 | Dimmit | Texas | 48127 | 904 | 13 |
945841 | 945841 | 2021-01-19 | Donley | Texas | 48129 | 289 | 8 |
945842 | 945842 | 2021-01-19 | Duval | Texas | 48131 | 1058 | 32 |
945843 | 945843 | 2021-01-19 | Eastland | Texas | 48133 | 972 | 23 |
945844 | 945844 | 2021-01-19 | Ector | Texas | 48135 | 12222 | 269 |
945845 | 945845 | 2021-01-19 | Edwards | Texas | 48137 | 207 | 3 |
945846 | 945846 | 2021-01-19 | El Paso | Texas | 48141 | 107552 | 1940 |
945847 | 945847 | 2021-01-19 | Ellis | Texas | 48139 | 16403 | 201 |
945848 | 945848 | 2021-01-19 | Erath | Texas | 48143 | 3470 | 42 |
945849 | 945849 | 2021-01-19 | Falls | Texas | 48145 | 1308 | 22 |
945850 | 945850 | 2021-01-19 | Fannin | Texas | 48147 | 2439 | 66 |
945851 | 945851 | 2021-01-19 | Fayette | Texas | 48149 | 1447 | 43 |
945852 | 945852 | 2021-01-19 | Fisher | Texas | 48151 | 266 | 10 |
945853 | 945853 | 2021-01-19 | Floyd | Texas | 48153 | 631 | 25 |
945854 | 945854 | 2021-01-19 | Foard | Texas | 48155 | 91 | 5 |
945855 | 945855 | 2021-01-19 | Fort Bend | Texas | 48157 | 45514 | 439 |
945856 | 945856 | 2021-01-19 | Franklin | Texas | 48159 | 565 | 16 |
945857 | 945857 | 2021-01-19 | Freestone | Texas | 48161 | 988 | 30 |
945858 | 945858 | 2021-01-19 | Frio | Texas | 48163 | 2148 | 24 |
945859 | 945859 | 2021-01-19 | Gaines | Texas | 48165 | 1302 | 36 |
945860 | 945860 | 2021-01-19 | Galveston | Texas | 48167 | 26898 | 251 |
945861 | 945861 | 2021-01-19 | Garza | Texas | 48169 | 278 | 18 |
945862 | 945862 | 2021-01-19 | Gillespie | Texas | 48171 | 1830 | 32 |
945863 | 945863 | 2021-01-19 | Glasscock | Texas | 48173 | 94 | 1 |
945864 | 945864 | 2021-01-19 | Goliad | Texas | 48175 | 299 | 9 |
945865 | 945865 | 2021-01-19 | Gonzales | Texas | 48177 | 1962 | 29 |
945866 | 945866 | 2021-01-19 | Gray | Texas | 48179 | 1773 | 40 |
945867 | 945867 | 2021-01-19 | Grayson | Texas | 48181 | 8983 | 225 |
945868 | 945868 | 2021-01-19 | Gregg | Texas | 48183 | 8818 | 221 |
945869 | 945869 | 2021-01-19 | Grimes | Texas | 48185 | 1979 | 52 |
945870 | 945870 | 2021-01-19 | Guadalupe | Texas | 48187 | 9123 | 128 |
945871 | 945871 | 2021-01-19 | Hale | Texas | 48189 | 5668 | 135 |
945872 | 945872 | 2021-01-19 | Hall | Texas | 48191 | 353 | 11 |
945873 | 945873 | 2021-01-19 | Hamilton | Texas | 48193 | 546 | 21 |
945874 | 945874 | 2021-01-19 | Hansford | Texas | 48195 | 673 | 17 |
945875 | 945875 | 2021-01-19 | Hardeman | Texas | 48197 | 319 | 9 |
945876 | 945876 | 2021-01-19 | Hardin | Texas | 48199 | 4080 | 69 |
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);