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 2022-02-10 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2202847 | 2202847 | 2022-02-10 | Anderson | Texas | 48001 | 9402 | 221 |
2202848 | 2202848 | 2022-02-10 | Andrews | Texas | 48003 | 3768 | 70 |
2202849 | 2202849 | 2022-02-10 | Angelina | Texas | 48005 | 15126 | 456 |
2202850 | 2202850 | 2022-02-10 | Aransas | Texas | 48007 | 3876 | 73 |
2202851 | 2202851 | 2022-02-10 | Archer | Texas | 48009 | 2064 | 26 |
2202852 | 2202852 | 2022-02-10 | Armstrong | Texas | 48011 | 489 | 8 |
2202853 | 2202853 | 2022-02-10 | Atascosa | Texas | 48013 | 12902 | 221 |
2202854 | 2202854 | 2022-02-10 | Austin | Texas | 48015 | 5347 | 65 |
2202855 | 2202855 | 2022-02-10 | Bailey | Texas | 48017 | 1350 | 34 |
2202856 | 2202856 | 2022-02-10 | Bandera | Texas | 48019 | 3448 | 71 |
2202857 | 2202857 | 2022-02-10 | Bastrop | Texas | 48021 | 21149 | 211 |
2202858 | 2202858 | 2022-02-10 | Baylor | Texas | 48023 | 791 | 30 |
2202859 | 2202859 | 2022-02-10 | Bee | Texas | 48025 | 7960 | 144 |
2202860 | 2202860 | 2022-02-10 | Bell | Texas | 48027 | 65242 | 809 |
2202861 | 2202861 | 2022-02-10 | Bexar | Texas | 48029 | 532001 | 5665 |
2202862 | 2202862 | 2022-02-10 | Blanco | Texas | 48031 | 2419 | 32 |
2202863 | 2202863 | 2022-02-10 | Borden | Texas | 48033 | 94 | 2 |
2202864 | 2202864 | 2022-02-10 | Bosque | Texas | 48035 | 3915 | 65 |
2202865 | 2202865 | 2022-02-10 | Bowie | Texas | 48037 | 18793 | 382 |
2202866 | 2202866 | 2022-02-10 | Brazoria | Texas | 48039 | 91226 | 938 |
2202867 | 2202867 | 2022-02-10 | Brazos | Texas | 48041 | 58858 | 384 |
2202868 | 2202868 | 2022-02-10 | Brewster | Texas | 48043 | 1020 | 25 |
2202869 | 2202869 | 2022-02-10 | Briscoe | Texas | 48045 | 433 | 8 |
2202870 | 2202870 | 2022-02-10 | Brooks | Texas | 48047 | 1539 | 50 |
2202871 | 2202871 | 2022-02-10 | Brown | Texas | 48049 | 11237 | 219 |
2202872 | 2202872 | 2022-02-10 | Burleson | Texas | 48051 | 4868 | 63 |
2202873 | 2202873 | 2022-02-10 | Burnet | Texas | 48053 | 10432 | 149 |
2202874 | 2202874 | 2022-02-10 | Caldwell | Texas | 48055 | 13795 | 167 |
2202875 | 2202875 | 2022-02-10 | Calhoun | Texas | 48057 | 5512 | 43 |
2202876 | 2202876 | 2022-02-10 | Callahan | Texas | 48059 | 2730 | 67 |
2202877 | 2202877 | 2022-02-10 | Cameron | Texas | 48061 | 95353 | 2029 |
2202878 | 2202878 | 2022-02-10 | Camp | Texas | 48063 | 2690 | 70 |
2202879 | 2202879 | 2022-02-10 | Carson | Texas | 48065 | 1431 | 32 |
2202880 | 2202880 | 2022-02-10 | Cass | Texas | 48067 | 6661 | 178 |
2202881 | 2202881 | 2022-02-10 | Castro | Texas | 48069 | 2231 | 46 |
2202882 | 2202882 | 2022-02-10 | Chambers | Texas | 48071 | 11492 | 108 |
2202883 | 2202883 | 2022-02-10 | Cherokee | Texas | 48073 | 7825 | 238 |
2202884 | 2202884 | 2022-02-10 | Childress | Texas | 48075 | 2359 | 27 |
2202885 | 2202885 | 2022-02-10 | Clay | Texas | 48077 | 2016 | 27 |
2202886 | 2202886 | 2022-02-10 | Cochran | Texas | 48079 | 827 | 21 |
2202887 | 2202887 | 2022-02-10 | Coke | Texas | 48081 | 818 | 19 |
2202888 | 2202888 | 2022-02-10 | Coleman | Texas | 48083 | 1566 | 67 |
2202889 | 2202889 | 2022-02-10 | Collin | Texas | 48085 | 199019 | 1360 |
2202890 | 2202890 | 2022-02-10 | Collingsworth | Texas | 48087 | 647 | 14 |
2202891 | 2202891 | 2022-02-10 | Colorado | Texas | 48089 | 3550 | 57 |
2202892 | 2202892 | 2022-02-10 | Comal | Texas | 48091 | 31124 | 514 |
2202893 | 2202893 | 2022-02-10 | Comanche | Texas | 48093 | 3101 | 75 |
2202894 | 2202894 | 2022-02-10 | Concho | Texas | 48095 | 1006 | 11 |
2202895 | 2202895 | 2022-02-10 | Cooke | Texas | 48097 | 7040 | 123 |
2202896 | 2202896 | 2022-02-10 | Coryell | Texas | 48099 | 16893 | 188 |
2202897 | 2202897 | 2022-02-10 | Cottle | Texas | 48101 | 275 | 9 |
2202898 | 2202898 | 2022-02-10 | Crane | Texas | 48103 | 1242 | 21 |
2202899 | 2202899 | 2022-02-10 | Crockett | Texas | 48105 | 1015 | 17 |
2202900 | 2202900 | 2022-02-10 | Crosby | Texas | 48107 | 1813 | 44 |
2202901 | 2202901 | 2022-02-10 | Culberson | Texas | 48109 | 506 | 14 |
2202902 | 2202902 | 2022-02-10 | Dallam | Texas | 48111 | 2018 | 37 |
2202903 | 2202903 | 2022-02-10 | Dallas | Texas | 48113 | 557007 | 6209 |
2202904 | 2202904 | 2022-02-10 | Dawson | Texas | 48115 | 2531 | 92 |
2202905 | 2202905 | 2022-02-10 | DeWitt | Texas | 48123 | 6345 | 91 |
2202906 | 2202906 | 2022-02-10 | Deaf Smith | Texas | 48117 | 4277 | 105 |
2202907 | 2202907 | 2022-02-10 | Delta | Texas | 48119 | 1753 | 24 |
2202908 | 2202908 | 2022-02-10 | Denton | Texas | 48121 | 172160 | 1232 |
2202909 | 2202909 | 2022-02-10 | Dickens | Texas | 48125 | 412 | 16 |
2202910 | 2202910 | 2022-02-10 | Dimmit | Texas | 48127 | 5506 | 50 |
2202911 | 2202911 | 2022-02-10 | Donley | Texas | 48129 | 978 | 23 |
2202912 | 2202912 | 2022-02-10 | Duval | Texas | 48131 | 3155 | 66 |
2202913 | 2202913 | 2022-02-10 | Eastland | Texas | 48133 | 2715 | 100 |
2202914 | 2202914 | 2022-02-10 | Ector | Texas | 48135 | 36587 | 631 |
2202915 | 2202915 | 2022-02-10 | Edwards | Texas | 48137 | 456 | 10 |
2202916 | 2202916 | 2022-02-10 | El Paso | Texas | 48141 | 200199 | 3495 |
2202917 | 2202917 | 2022-02-10 | Ellis | Texas | 48139 | 47406 | 534 |
2202918 | 2202918 | 2022-02-10 | Erath | Texas | 48143 | 8301 | 115 |
2202919 | 2202919 | 2022-02-10 | Falls | Texas | 48145 | 3654 | 58 |
2202920 | 2202920 | 2022-02-10 | Fannin | Texas | 48147 | 6554 | 167 |
2202921 | 2202921 | 2022-02-10 | Fayette | Texas | 48149 | 4656 | 98 |
2202922 | 2202922 | 2022-02-10 | Fisher | Texas | 48151 | 591 | 22 |
2202923 | 2202923 | 2022-02-10 | Floyd | Texas | 48153 | 1872 | 46 |
2202924 | 2202924 | 2022-02-10 | Foard | Texas | 48155 | 198 | 11 |
2202925 | 2202925 | 2022-02-10 | Fort Bend | Texas | 48157 | 170783 | 1135 |
2202926 | 2202926 | 2022-02-10 | Franklin | Texas | 48159 | 2040 | 37 |
2202927 | 2202927 | 2022-02-10 | Freestone | Texas | 48161 | 3783 | 81 |
2202928 | 2202928 | 2022-02-10 | Frio | Texas | 48163 | 5359 | 84 |
2202929 | 2202929 | 2022-02-10 | Gaines | Texas | 48165 | 1776 | 78 |
2202930 | 2202930 | 2022-02-10 | Galveston | Texas | 48167 | 92957 | 806 |
2202931 | 2202931 | 2022-02-10 | Garza | Texas | 48169 | 1214 | 26 |
2202932 | 2202932 | 2022-02-10 | Gillespie | Texas | 48171 | 5095 | 101 |
2202933 | 2202933 | 2022-02-10 | Glasscock | Texas | 48173 | 194 | 3 |
2202934 | 2202934 | 2022-02-10 | Goliad | Texas | 48175 | 1141 | 30 |
2202935 | 2202935 | 2022-02-10 | Gonzales | Texas | 48177 | 4634 | 93 |
2202936 | 2202936 | 2022-02-10 | Gray | Texas | 48179 | 5948 | 112 |
2202937 | 2202937 | 2022-02-10 | Grayson | Texas | 48181 | 26750 | 578 |
2202938 | 2202938 | 2022-02-10 | Gregg | Texas | 48183 | 22751 | 618 |
2202939 | 2202939 | 2022-02-10 | Grimes | Texas | 48185 | 8277 | 115 |
2202940 | 2202940 | 2022-02-10 | Guadalupe | Texas | 48187 | 35758 | 368 |
2202941 | 2202941 | 2022-02-10 | Hale | Texas | 48189 | 6440 | 230 |
2202942 | 2202942 | 2022-02-10 | Hall | Texas | 48191 | 963 | 21 |
2202943 | 2202943 | 2022-02-10 | Hamilton | Texas | 48193 | 1937 | 30 |
2202944 | 2202944 | 2022-02-10 | Hansford | Texas | 48195 | 1857 | 27 |
2202945 | 2202945 | 2022-02-10 | Hardeman | Texas | 48197 | 550 | 14 |
2202946 | 2202946 | 2022-02-10 | Hardin | Texas | 48199 | 11865 | 228 |
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);