ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
255 rows where "date" is on date 2022-01-21 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2137775 | 2137775 | 2022-01-21 | Anderson | Texas | 48001 | 8987 | 217 |
2137776 | 2137776 | 2022-01-21 | Andrews | Texas | 48003 | 3475 | 68 |
2137777 | 2137777 | 2022-01-21 | Angelina | Texas | 48005 | 14203 | 435 |
2137778 | 2137778 | 2022-01-21 | Aransas | Texas | 48007 | 3282 | 69 |
2137779 | 2137779 | 2022-01-21 | Archer | Texas | 48009 | 1833 | 24 |
2137780 | 2137780 | 2022-01-21 | Armstrong | Texas | 48011 | 453 | 8 |
2137781 | 2137781 | 2022-01-21 | Atascosa | Texas | 48013 | 11308 | 215 |
2137782 | 2137782 | 2022-01-21 | Austin | Texas | 48015 | 4794 | 59 |
2137783 | 2137783 | 2022-01-21 | Bailey | Texas | 48017 | 1287 | 31 |
2137784 | 2137784 | 2022-01-21 | Bandera | Texas | 48019 | 3074 | 67 |
2137785 | 2137785 | 2022-01-21 | Bastrop | Texas | 48021 | 19517 | 196 |
2137786 | 2137786 | 2022-01-21 | Baylor | Texas | 48023 | 727 | 26 |
2137787 | 2137787 | 2022-01-21 | Bee | Texas | 48025 | 7300 | 139 |
2137788 | 2137788 | 2022-01-21 | Bell | Texas | 48027 | 54569 | 766 |
2137789 | 2137789 | 2022-01-21 | Bexar | Texas | 48029 | 459181 | 5450 |
2137790 | 2137790 | 2022-01-21 | Blanco | Texas | 48031 | 2121 | 29 |
2137791 | 2137791 | 2022-01-21 | Borden | Texas | 48033 | 90 | 2 |
2137792 | 2137792 | 2022-01-21 | Bosque | Texas | 48035 | 3454 | 60 |
2137793 | 2137793 | 2022-01-21 | Bowie | Texas | 48037 | 16824 | 364 |
2137794 | 2137794 | 2022-01-21 | Brazoria | Texas | 48039 | 84607 | 891 |
2137795 | 2137795 | 2022-01-21 | Brazos | Texas | 48041 | 52681 | 372 |
2137796 | 2137796 | 2022-01-21 | Brewster | Texas | 48043 | 975 | 25 |
2137797 | 2137797 | 2022-01-21 | Briscoe | Texas | 48045 | 401 | 8 |
2137798 | 2137798 | 2022-01-21 | Brooks | Texas | 48047 | 1390 | 48 |
2137799 | 2137799 | 2022-01-21 | Brown | Texas | 48049 | 10229 | 212 |
2137800 | 2137800 | 2022-01-21 | Burleson | Texas | 48051 | 4484 | 62 |
2137801 | 2137801 | 2022-01-21 | Burnet | Texas | 48053 | 9468 | 139 |
2137802 | 2137802 | 2022-01-21 | Caldwell | Texas | 48055 | 12099 | 161 |
2137803 | 2137803 | 2022-01-21 | Calhoun | Texas | 48057 | 4971 | 40 |
2137804 | 2137804 | 2022-01-21 | Callahan | Texas | 48059 | 2455 | 62 |
2137805 | 2137805 | 2022-01-21 | Cameron | Texas | 48061 | 85548 | 2029 |
2137806 | 2137806 | 2022-01-21 | Camp | Texas | 48063 | 2517 | 70 |
2137807 | 2137807 | 2022-01-21 | Carson | Texas | 48065 | 1336 | 31 |
2137808 | 2137808 | 2022-01-21 | Cass | Texas | 48067 | 5742 | 166 |
2137809 | 2137809 | 2022-01-21 | Castro | Texas | 48069 | 2068 | 45 |
2137810 | 2137810 | 2022-01-21 | Chambers | Texas | 48071 | 10814 | 105 |
2137811 | 2137811 | 2022-01-21 | Cherokee | Texas | 48073 | 7142 | 230 |
2137812 | 2137812 | 2022-01-21 | Childress | Texas | 48075 | 2200 | 26 |
2137813 | 2137813 | 2022-01-21 | Clay | Texas | 48077 | 1876 | 26 |
2137814 | 2137814 | 2022-01-21 | Cochran | Texas | 48079 | 741 | 21 |
2137815 | 2137815 | 2022-01-21 | Coke | Texas | 48081 | 774 | 18 |
2137816 | 2137816 | 2022-01-21 | Coleman | Texas | 48083 | 1487 | 62 |
2137817 | 2137817 | 2022-01-21 | Collin | Texas | 48085 | 178217 | 1261 |
2137818 | 2137818 | 2022-01-21 | Collingsworth | Texas | 48087 | 607 | 13 |
2137819 | 2137819 | 2022-01-21 | Colorado | Texas | 48089 | 3236 | 57 |
2137820 | 2137820 | 2022-01-21 | Comal | Texas | 48091 | 27707 | 490 |
2137821 | 2137821 | 2022-01-21 | Comanche | Texas | 48093 | 2881 | 70 |
2137822 | 2137822 | 2022-01-21 | Concho | Texas | 48095 | 954 | 10 |
2137823 | 2137823 | 2022-01-21 | Cooke | Texas | 48097 | 6548 | 114 |
2137824 | 2137824 | 2022-01-21 | Coryell | Texas | 48099 | 15105 | 176 |
2137825 | 2137825 | 2022-01-21 | Cottle | Texas | 48101 | 266 | 9 |
2137826 | 2137826 | 2022-01-21 | Crane | Texas | 48103 | 1084 | 19 |
2137827 | 2137827 | 2022-01-21 | Crockett | Texas | 48105 | 957 | 17 |
2137828 | 2137828 | 2022-01-21 | Crosby | Texas | 48107 | 1678 | 44 |
2137829 | 2137829 | 2022-01-21 | Culberson | Texas | 48109 | 465 | 13 |
2137830 | 2137830 | 2022-01-21 | Dallam | Texas | 48111 | 1870 | 34 |
2137831 | 2137831 | 2022-01-21 | Dallas | Texas | 48113 | 514880 | 5930 |
2137832 | 2137832 | 2022-01-21 | Dawson | Texas | 48115 | 2285 | 85 |
2137833 | 2137833 | 2022-01-21 | DeWitt | Texas | 48123 | 5896 | 86 |
2137834 | 2137834 | 2022-01-21 | Deaf Smith | Texas | 48117 | 3930 | 103 |
2137835 | 2137835 | 2022-01-21 | Delta | Texas | 48119 | 1576 | 22 |
2137836 | 2137836 | 2022-01-21 | Denton | Texas | 48121 | 149226 | 1130 |
2137837 | 2137837 | 2022-01-21 | Dickens | Texas | 48125 | 367 | 15 |
2137838 | 2137838 | 2022-01-21 | Dimmit | Texas | 48127 | 4866 | 48 |
2137839 | 2137839 | 2022-01-21 | Donley | Texas | 48129 | 888 | 20 |
2137840 | 2137840 | 2022-01-21 | Duval | Texas | 48131 | 2584 | 62 |
2137841 | 2137841 | 2022-01-21 | Eastland | Texas | 48133 | 2580 | 94 |
2137842 | 2137842 | 2022-01-21 | Ector | Texas | 48135 | 33804 | 598 |
2137843 | 2137843 | 2022-01-21 | Edwards | Texas | 48137 | 394 | 10 |
2137844 | 2137844 | 2022-01-21 | El Paso | Texas | 48141 | 175400 | 3306 |
2137845 | 2137845 | 2022-01-21 | Ellis | Texas | 48139 | 43302 | 508 |
2137846 | 2137846 | 2022-01-21 | Erath | Texas | 48143 | 7619 | 110 |
2137847 | 2137847 | 2022-01-21 | Falls | Texas | 48145 | 3374 | 55 |
2137848 | 2137848 | 2022-01-21 | Fannin | Texas | 48147 | 6063 | 157 |
2137849 | 2137849 | 2022-01-21 | Fayette | Texas | 48149 | 4318 | 94 |
2137850 | 2137850 | 2022-01-21 | Fisher | Texas | 48151 | 536 | 20 |
2137851 | 2137851 | 2022-01-21 | Floyd | Texas | 48153 | 1773 | 42 |
2137852 | 2137852 | 2022-01-21 | Foard | Texas | 48155 | 186 | 10 |
2137853 | 2137853 | 2022-01-21 | Fort Bend | Texas | 48157 | 156760 | 1086 |
2137854 | 2137854 | 2022-01-21 | Franklin | Texas | 48159 | 1849 | 37 |
2137855 | 2137855 | 2022-01-21 | Freestone | Texas | 48161 | 3506 | 76 |
2137856 | 2137856 | 2022-01-21 | Frio | Texas | 48163 | 4756 | 80 |
2137857 | 2137857 | 2022-01-21 | Gaines | Texas | 48165 | 1607 | 73 |
2137858 | 2137858 | 2022-01-21 | Galveston | Texas | 48167 | 86182 | 762 |
2137859 | 2137859 | 2022-01-21 | Garza | Texas | 48169 | 1118 | 25 |
2137860 | 2137860 | 2022-01-21 | Gillespie | Texas | 48171 | 4660 | 88 |
2137861 | 2137861 | 2022-01-21 | Glasscock | Texas | 48173 | 186 | 3 |
2137862 | 2137862 | 2022-01-21 | Goliad | Texas | 48175 | 963 | 28 |
2137863 | 2137863 | 2022-01-21 | Gonzales | Texas | 48177 | 4128 | 92 |
2137864 | 2137864 | 2022-01-21 | Gray | Texas | 48179 | 5620 | 107 |
2137865 | 2137865 | 2022-01-21 | Grayson | Texas | 48181 | 23593 | 549 |
2137866 | 2137866 | 2022-01-21 | Gregg | Texas | 48183 | 20936 | 595 |
2137867 | 2137867 | 2022-01-21 | Grimes | Texas | 48185 | 7441 | 111 |
2137868 | 2137868 | 2022-01-21 | Guadalupe | Texas | 48187 | 31700 | 351 |
2137869 | 2137869 | 2022-01-21 | Hale | Texas | 48189 | 5931 | 217 |
2137870 | 2137870 | 2022-01-21 | Hall | Texas | 48191 | 882 | 18 |
2137871 | 2137871 | 2022-01-21 | Hamilton | Texas | 48193 | 1796 | 29 |
2137872 | 2137872 | 2022-01-21 | Hansford | Texas | 48195 | 1534 | 27 |
2137873 | 2137873 | 2022-01-21 | Hardeman | Texas | 48197 | 521 | 14 |
2137874 | 2137874 | 2022-01-21 | Hardin | Texas | 48199 | 11143 | 222 |
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);