ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

23,396 rows where state = "Texas" sorted by date descending

View and edit SQL

fips

county

state

  • Texas · 23,396
Link rowid date ▲ county state fips cases deaths
318936 2020-07-11 Anderson Texas 48001 1796 3
318937 2020-07-11 Andrews Texas 48003 155 2
318938 2020-07-11 Angelina Texas 48005 743 9
318939 2020-07-11 Aransas Texas 48007 50 0
318940 2020-07-11 Archer Texas 48009 10 0
318941 2020-07-11 Armstrong Texas 48011 3 0
318942 2020-07-11 Atascosa Texas 48013 207 2
318943 2020-07-11 Austin Texas 48015 128 0
318944 2020-07-11 Bailey Texas 48017 112 1
318945 2020-07-11 Bandera Texas 48019 44 0
318946 2020-07-11 Bastrop Texas 48021 727 11
318947 2020-07-11 Baylor Texas 48023 1 0
318948 2020-07-11 Bee Texas 48025 135 0
318949 2020-07-11 Bell Texas 48027 2083 14
318950 2020-07-11 Bexar Texas 48029 19149 175
318951 2020-07-11 Blanco Texas 48031 49 1
318952 2020-07-11 Bosque Texas 48035 41 0
318953 2020-07-11 Bowie Texas 48037 496 26
318954 2020-07-11 Brazoria Texas 48039 3358 25
318955 2020-07-11 Brazos Texas 48041 2961 35
318956 2020-07-11 Brewster Texas 48043 150 1
318957 2020-07-11 Briscoe Texas 48045 9 1
318958 2020-07-11 Brooks Texas 48047 37 0
318959 2020-07-11 Brown Texas 48049 171 13
318960 2020-07-11 Burleson Texas 48051 148 0
318961 2020-07-11 Burnet Texas 48053 230 3
318962 2020-07-11 Caldwell Texas 48055 645 5
318963 2020-07-11 Calhoun Texas 48057 153 3
318964 2020-07-11 Callahan Texas 48059 27 2
318965 2020-07-11 Cameron Texas 48061 3854 79
318966 2020-07-11 Camp Texas 48063 131 2
318967 2020-07-11 Carson Texas 48065 10 0
318968 2020-07-11 Cass Texas 48067 57 3
318969 2020-07-11 Castro Texas 48069 120 1
318970 2020-07-11 Chambers Texas 48071 590 2
318971 2020-07-11 Cherokee Texas 48073 357 2
318972 2020-07-11 Childress Texas 48075 7 0
318973 2020-07-11 Clay Texas 48077 16 0
318974 2020-07-11 Cochran Texas 48079 6 0
318975 2020-07-11 Coke Texas 48081 6 1
318976 2020-07-11 Coleman Texas 48083 5 0
318977 2020-07-11 Collin Texas 48085 4459 56
318978 2020-07-11 Collingsworth Texas 48087 6 0
318979 2020-07-11 Colorado Texas 48089 161 0
318980 2020-07-11 Comal Texas 48091 1282 22
318981 2020-07-11 Comanche Texas 48093 26 1
318982 2020-07-11 Concho Texas 48095 13 0
318983 2020-07-11 Cooke Texas 48097 87 0
318984 2020-07-11 Coryell Texas 48099 398 2
318985 2020-07-11 Cottle Texas 48101 4 1
318986 2020-07-11 Crane Texas 48103 64 9
318987 2020-07-11 Crockett Texas 48105 35 0
318988 2020-07-11 Crosby Texas 48107 35 2
318989 2020-07-11 Culberson Texas 48109 6 1
318990 2020-07-11 Dallam Texas 48111 116 1
318991 2020-07-11 Dallas Texas 48113 32626 449
318992 2020-07-11 Dawson Texas 48115 83 1
318993 2020-07-11 DeWitt Texas 48123 159 3
318994 2020-07-11 Deaf Smith Texas 48117 409 17
318995 2020-07-11 Delta Texas 48119 7 0
318996 2020-07-11 Denton Texas 48121 3937 40
318997 2020-07-11 Dickens Texas 48125 2 0
318998 2020-07-11 Dimmit Texas 48127 31 0
318999 2020-07-11 Donley Texas 48129 32 0
319000 2020-07-11 Duval Texas 48131 75 0
319001 2020-07-11 Eastland Texas 48133 20 0
319002 2020-07-11 Ector Texas 48135 1829 14
319003 2020-07-11 Edwards Texas 48137 4 0
319004 2020-07-11 El Paso Texas 48141 9099 150
319005 2020-07-11 Ellis Texas 48139 1510 20
319006 2020-07-11 Erath Texas 48143 216 1
319007 2020-07-11 Falls Texas 48145 56 0
319008 2020-07-11 Fannin Texas 48147 137 8
319009 2020-07-11 Fayette Texas 48149 151 3
319010 2020-07-11 Fisher Texas 48151 13 1
319011 2020-07-11 Floyd Texas 48153 52 1
319012 2020-07-11 Foard Texas 48155 1 0
319013 2020-07-11 Fort Bend Texas 48157 4758 62
319014 2020-07-11 Franklin Texas 48159 55 1
319015 2020-07-11 Freestone Texas 48161 73 0
319016 2020-07-11 Frio Texas 48163 338 0
319017 2020-07-11 Gaines Texas 48165 43 0
319018 2020-07-11 Galveston Texas 48167 5873 54
319019 2020-07-11 Garza Texas 48169 21 1
319020 2020-07-11 Gillespie Texas 48171 65 0
319021 2020-07-11 Glasscock Texas 48173 6 0
319022 2020-07-11 Goliad Texas 48175 30 0
319023 2020-07-11 Gonzales Texas 48177 323 4
319024 2020-07-11 Gray Texas 48179 133 4
319025 2020-07-11 Grayson Texas 48181 731 7
319026 2020-07-11 Gregg Texas 48183 788 14
319027 2020-07-11 Grimes Texas 48185 642 2
319028 2020-07-11 Guadalupe Texas 48187 1014 3
319029 2020-07-11 Hale Texas 48189 763 11
319030 2020-07-11 Hall Texas 48191 2 1
319031 2020-07-11 Hamilton Texas 48193 32 1
319032 2020-07-11 Hansford Texas 48195 35 2
319033 2020-07-11 Hardeman Texas 48197 5 0
319034 2020-07-11 Hardin Texas 48199 404 5
319035 2020-07-11 Harris Texas 48201 43939 455

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 1146.222ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette