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-08-18 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1630810 | 1630810 | 2021-08-18 | Anderson | Texas | 48001 | 6398 | 135 |
1630811 | 1630811 | 2021-08-18 | Andrews | Texas | 48003 | 2002 | 48 |
1630812 | 1630812 | 2021-08-18 | Angelina | Texas | 48005 | 10131 | 294 |
1630813 | 1630813 | 2021-08-18 | Aransas | Texas | 48007 | 1757 | 46 |
1630814 | 1630814 | 2021-08-18 | Archer | Texas | 48009 | 870 | 12 |
1630815 | 1630815 | 2021-08-18 | Armstrong | Texas | 48011 | 231 | 7 |
1630816 | 1630816 | 2021-08-18 | Atascosa | Texas | 48013 | 6802 | 156 |
1630817 | 1630817 | 2021-08-18 | Austin | Texas | 48015 | 2570 | 39 |
1630818 | 1630818 | 2021-08-18 | Bailey | Texas | 48017 | 889 | 19 |
1630819 | 1630819 | 2021-08-18 | Bandera | Texas | 48019 | 1729 | 34 |
1630820 | 1630820 | 2021-08-18 | Bastrop | Texas | 48021 | 11511 | 116 |
1630821 | 1630821 | 2021-08-18 | Baylor | Texas | 48023 | 311 | 13 |
1630822 | 1630822 | 2021-08-18 | Bee | Texas | 48025 | 4130 | 80 |
1630823 | 1630823 | 2021-08-18 | Bell | Texas | 48027 | 29645 | 488 |
1630824 | 1630824 | 2021-08-18 | Bexar | Texas | 48029 | 267642 | 3796 |
1630825 | 1630825 | 2021-08-18 | Blanco | Texas | 48031 | 895 | 23 |
1630826 | 1630826 | 2021-08-18 | Borden | Texas | 48033 | 33 | 2 |
1630827 | 1630827 | 2021-08-18 | Bosque | Texas | 48035 | 1953 | 40 |
1630828 | 1630828 | 2021-08-18 | Bowie | Texas | 48037 | 9050 | 232 |
1630829 | 1630829 | 2021-08-18 | Brazoria | Texas | 48039 | 45472 | 574 |
1630830 | 1630830 | 2021-08-18 | Brazos | Texas | 48041 | 29906 | 275 |
1630831 | 1630831 | 2021-08-18 | Brewster | Texas | 48043 | 984 | 18 |
1630832 | 1630832 | 2021-08-18 | Briscoe | Texas | 48045 | 191 | 7 |
1630833 | 1630833 | 2021-08-18 | Brooks | Texas | 48047 | 978 | 37 |
1630834 | 1630834 | 2021-08-18 | Brown | Texas | 48049 | 5011 | 144 |
1630835 | 1630835 | 2021-08-18 | Burleson | Texas | 48051 | 2707 | 48 |
1630836 | 1630836 | 2021-08-18 | Burnet | Texas | 48053 | 5835 | 79 |
1630837 | 1630837 | 2021-08-18 | Caldwell | Texas | 48055 | 6644 | 109 |
1630838 | 1630838 | 2021-08-18 | Calhoun | Texas | 48057 | 2923 | 26 |
1630839 | 1630839 | 2021-08-18 | Callahan | Texas | 48059 | 1342 | 42 |
1630840 | 1630840 | 2021-08-18 | Cameron | Texas | 48061 | 56077 | 1739 |
1630841 | 1630841 | 2021-08-18 | Camp | Texas | 48063 | 1550 | 45 |
1630842 | 1630842 | 2021-08-18 | Carson | Texas | 48065 | 652 | 14 |
1630843 | 1630843 | 2021-08-18 | Cass | Texas | 48067 | 2893 | 91 |
1630844 | 1630844 | 2021-08-18 | Castro | Texas | 48069 | 1122 | 32 |
1630845 | 1630845 | 2021-08-18 | Chambers | Texas | 48071 | 6567 | 69 |
1630846 | 1630846 | 2021-08-18 | Cherokee | Texas | 48073 | 4925 | 150 |
1630847 | 1630847 | 2021-08-18 | Childress | Texas | 48075 | 1384 | 17 |
1630848 | 1630848 | 2021-08-18 | Clay | Texas | 48077 | 1110 | 18 |
1630849 | 1630849 | 2021-08-18 | Cochran | Texas | 48079 | 352 | 15 |
1630850 | 1630850 | 2021-08-18 | Coke | Texas | 48081 | 512 | 13 |
1630851 | 1630851 | 2021-08-18 | Coleman | Texas | 48083 | 870 | 36 |
1630852 | 1630852 | 2021-08-18 | Collin | Texas | 48085 | 103653 | 878 |
1630853 | 1630853 | 2021-08-18 | Collingsworth | Texas | 48087 | 344 | 9 |
1630854 | 1630854 | 2021-08-18 | Colorado | Texas | 48089 | 2043 | 34 |
1630855 | 1630855 | 2021-08-18 | Comal | Texas | 48091 | 14309 | 353 |
1630856 | 1630856 | 2021-08-18 | Comanche | Texas | 48093 | 1724 | 52 |
1630857 | 1630857 | 2021-08-18 | Concho | Texas | 48095 | 602 | 9 |
1630858 | 1630858 | 2021-08-18 | Cooke | Texas | 48097 | 4177 | 72 |
1630859 | 1630859 | 2021-08-18 | Coryell | Texas | 48099 | 8404 | 95 |
1630860 | 1630860 | 2021-08-18 | Cottle | Texas | 48101 | 198 | 7 |
1630861 | 1630861 | 2021-08-18 | Crane | Texas | 48103 | 623 | 14 |
1630862 | 1630862 | 2021-08-18 | Crockett | Texas | 48105 | 652 | 15 |
1630863 | 1630863 | 2021-08-18 | Crosby | Texas | 48107 | 824 | 29 |
1630864 | 1630864 | 2021-08-18 | Culberson | Texas | 48109 | 370 | 11 |
1630865 | 1630865 | 2021-08-18 | Dallam | Texas | 48111 | 1004 | 26 |
1630866 | 1630866 | 2021-08-18 | Dallas | Texas | 48113 | 335523 | 4262 |
1630867 | 1630867 | 2021-08-18 | Dawson | Texas | 48115 | 1793 | 70 |
1630868 | 1630868 | 2021-08-18 | DeWitt | Texas | 48123 | 2082 | 64 |
1630869 | 1630869 | 2021-08-18 | Deaf Smith | Texas | 48117 | 3085 | 68 |
1630870 | 1630870 | 2021-08-18 | Delta | Texas | 48119 | 415 | 14 |
1630871 | 1630871 | 2021-08-18 | Denton | Texas | 48121 | 85030 | 805 |
1630872 | 1630872 | 2021-08-18 | Dickens | Texas | 48125 | 207 | 10 |
1630873 | 1630873 | 2021-08-18 | Dimmit | Texas | 48127 | 3342 | 38 |
1630874 | 1630874 | 2021-08-18 | Donley | Texas | 48129 | 440 | 15 |
1630875 | 1630875 | 2021-08-18 | Duval | Texas | 48131 | 1550 | 42 |
1630876 | 1630876 | 2021-08-18 | Eastland | Texas | 48133 | 1509 | 52 |
1630877 | 1630877 | 2021-08-18 | Ector | Texas | 48135 | 20130 | 393 |
1630878 | 1630878 | 2021-08-18 | Edwards | Texas | 48137 | 258 | 6 |
1630879 | 1630879 | 2021-08-18 | El Paso | Texas | 48141 | 140239 | 2769 |
1630880 | 1630880 | 2021-08-18 | Ellis | Texas | 48139 | 25580 | 333 |
1630881 | 1630881 | 2021-08-18 | Erath | Texas | 48143 | 4820 | 71 |
1630882 | 1630882 | 2021-08-18 | Falls | Texas | 48145 | 2221 | 34 |
1630883 | 1630883 | 2021-08-18 | Fannin | Texas | 48147 | 3751 | 112 |
1630884 | 1630884 | 2021-08-18 | Fayette | Texas | 48149 | 3129 | 72 |
1630885 | 1630885 | 2021-08-18 | Fisher | Texas | 48151 | 348 | 14 |
1630886 | 1630886 | 2021-08-18 | Floyd | Texas | 48153 | 989 | 30 |
1630887 | 1630887 | 2021-08-18 | Foard | Texas | 48155 | 141 | 10 |
1630888 | 1630888 | 2021-08-18 | Fort Bend | Texas | 48157 | 79714 | 769 |
1630889 | 1630889 | 2021-08-18 | Franklin | Texas | 48159 | 930 | 26 |
1630890 | 1630890 | 2021-08-18 | Freestone | Texas | 48161 | 2218 | 54 |
1630891 | 1630891 | 2021-08-18 | Frio | Texas | 48163 | 3340 | 57 |
1630892 | 1630892 | 2021-08-18 | Gaines | Texas | 48165 | 1566 | 46 |
1630893 | 1630893 | 2021-08-18 | Galveston | Texas | 48167 | 50243 | 483 |
1630894 | 1630894 | 2021-08-18 | Garza | Texas | 48169 | 596 | 22 |
1630895 | 1630895 | 2021-08-18 | Gillespie | Texas | 48171 | 2914 | 56 |
1630896 | 1630896 | 2021-08-18 | Glasscock | Texas | 48173 | 116 | 2 |
1630897 | 1630897 | 2021-08-18 | Goliad | Texas | 48175 | 547 | 16 |
1630898 | 1630898 | 2021-08-18 | Gonzales | Texas | 48177 | 2987 | 60 |
1630899 | 1630899 | 2021-08-18 | Gray | Texas | 48179 | 2678 | 59 |
1630900 | 1630900 | 2021-08-18 | Grayson | Texas | 48181 | 12608 | 355 |
1630901 | 1630901 | 2021-08-18 | Gregg | Texas | 48183 | 13296 | 373 |
1630902 | 1630902 | 2021-08-18 | Grimes | Texas | 48185 | 4370 | 74 |
1630903 | 1630903 | 2021-08-18 | Guadalupe | Texas | 48187 | 18676 | 234 |
1630904 | 1630904 | 2021-08-18 | Hale | Texas | 48189 | 6548 | 160 |
1630905 | 1630905 | 2021-08-18 | Hall | Texas | 48191 | 510 | 14 |
1630906 | 1630906 | 2021-08-18 | Hamilton | Texas | 48193 | 941 | 29 |
1630907 | 1630907 | 2021-08-18 | Hansford | Texas | 48195 | 983 | 24 |
1630908 | 1630908 | 2021-08-18 | Hardeman | Texas | 48197 | 406 | 12 |
1630909 | 1630909 | 2021-08-18 | Hardin | Texas | 48199 | 7109 | 122 |
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);