legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id_house_history
This data as json, copyable, CSV (advanced)
id_fec (array) >1000 ✖
- H0AL02087 1
- H0AL05049 1
- H0AL05163 1
- H0AL07060 1
- H0AL07086 1
- H0AR01083 1
- H0AR02107 1
- H0AR03055 1
- H0AR04038 1
- H0AS00018 1
- H0AZ01184 1
- H0AZ01259 1
- H0AZ03362 1
- H0CA08135 1
- H0CA10073 1
- H0CA10149 1
- H0CA11022 1
- H0CA14042 1
- H0CA15148 1
- H0CA19173 1
- H0CA25105 1
- H0CA27085 1
- H0CA31087 1
- H0CA32101 1
- H0CA33117 1
- H0CA48024 1
- H0CA48198 1
- H0CA49055 1
- H0CO04122 1
- H0CT03072 1
- H0DC00058 1
- H0DE01017 1
- H0FL02086 1
- H0FL02110 1
- H0FL04066 1
- H0FL05139 1
- H0FL08042 1
- H0FL08208 1
- H0FL12051 1
- H0FL12101 1
- H0FL15104 1
- H0FL17068 1
- H0FL18025 1
- H0FL19080 1
- H0FL24049 1
- H0FL25038 1
- H0FL26036 1
- H0GA03017 1
- H0GA04023 1
- H0GA05301 1
- H0GA05327 1
- H0GA06192 1
- H0GA07125 1
- H0GA07133 1
- H0GA08032 1
- H0GA08099 1
- H0GA09030 1
- H0HI01157 1
- H0HI02155 1
- H0IA01174 1
- H0IA04145 1
- H0ID01253 1
- H0IL05096 1
- H0IL08090 1
- H0IL10120 1
- H0IL10302 1
- H0IL11052 1
- H0IL14080 1
- H0IL15053 1
- H0IL15129 1
- H0IL16085 1
- H0IL17059 1
- H0IN01150 1
- H0IN02125 1
- H0IN02190 1
- H0IN03198 1
- H0IN04170 1
- H0IN05094 1
- H0IN05326 1
- H0IN08114 1
- H0IN09070 1
- H0KS01016 1
- H0KS01123 1
- H0KS02188 1
- H0KS03137 1
- H0KS04051 1
- H0KY05015 1
- H0LA01079 1
- H0LA01087 1
- H0LA02119 1
- H0LA03141 1
- H0MA04036 1
- H0MA10082 1
- H0MD07114 1
- H0MI01088 1
- H0MI02094 1
- H0MI03126 1
- H0MI03308 1
- H0MI08042 1
- H0MI10071 1
- H0MI10287 1
- H0MI13398 1
- H0MN00013 1
- H0MN01045 1
- H0MN04049 1
- H0MN07091 1
- H0MN08115 1
- H0MO00019 1
- H0MO01066 1
- H0MO02148 1
- H0MO04086 1
- H0MO06073 1
- H0MO07113 1
- H0MS01043 1
- H0MS04120 1
- H0MT00033 1
- H0NC02059 1
- H0NC02125 1
- H0NC03172 1
- H0ND00135 1
- H0NH01217 1
- H0NH02017 1
- H0NH02181 1
- H0NJ01066 1
- H0NJ03153 1
- H0NJ10026 1
- H0NM03102 1
- H0NV01078 1
- H0NV03058 1
- H0NY02085 1
- H0NY02234 1
- H0NY09072 1
- H0NY11078 1
- H0NY13074 1
- H0NY15160 1
- H0NY16010 1
- H0NY17174 1
- H0NY18065 1
- H0NY19139 1
- H0NY20079 1
- H0NY20095 1
- H0NY23081 1
- H0NY25078 1
- H0NY27090 1
- H0NY29054 1
- H0OH06189 1
- H0OH07021 1
- H0OH08029 1
- H0OH12062 1
- H0OH16097 1
- H0OH18077 1
- H0OK05114 1
- H0OR03026 1
- H0PA03271 1
- H0PA04220 1
- H0PA07082 1
- H0PA10078 1
- H0PA11050 1
- H0PA12132 1
- H0PA12181 1
- H0PA19053 1
- H0RI01073 1
- H0RI02071 1
- H0RI02139 1
- H0SC01071 1
- H0SC01279 1
- H0SC01394 1
- H0SC03077 1
- H0SC04257 1
- H0SC05031 1
- H0SD00054 1
- H0TN01118 1
- H0TN03254 1
- H0TN04195 1
- H0TN06257 1
- H0TN08246 1
- H0TX04037 1
- H0TX04219 1
- H0TX07055 1
- H0TX09077 1
- H0TX11230 1
- H0TX13228 1
- H0TX17104 1
- H0TX22302 1
- H0TX23086 1
- H0TX24209 1
- H0TX27061 1
- H0TX35015 1
- H0UT01205 1
- H0UT02096 1
- H0UT04076 1
- H0VA01052 1
- H0VA02084 1
- H0VA02118 1
- H0VA05095 1
- H0VA05160 1
- H0VA07042 1
- H0VA08040 1
- H0VA09055 1
- H0WA02080 1
- H0WA03161 1
- H0WA03187 1
- H0WA08046 1
- H0WA10034 1
- H0WI05113 1
- H0WI06061 1
- H0WI07051 1
- H0WI07101 1
- H0WI08075 1
- H0WV01072 1
- H0WV02138 1
- H1NV02017 1
- H2AK01158 1
- H2AL01077 1
- H2AL02067 1
- H2AL03032 1
- H2AL06035 1
- H2AR01022 1
- H2AR03176 1
- H2AZ01172 1
- H2AZ02055 1
- H2AZ06130 1
- H2AZ07070 1
- H2AZ08102 1
- H2AZ09019 1
- H2CA00104 1
- H2CA00120 1
- H2CA01045 1
- H2CA01144 1
- H2CA02142 1
- H2CA06028 1
- H2CA06259 1
- H2CA15094 1
- H2CA18056 1
- H2CA19054 1
- H2CA20094 1
- H2CA25036 1
- H2CA26026 1
- H2CA27107 1
- H2CA30143 1
- H2CA32099 1
- H2CA33048 1
- H2CA35118 1
- H2CA36439 1
- H2CA37023 1
- H2CA39078 1
- H2CA42023 1
- H2CA43245 1
- H2CA50026 1
- H2CA50034 1
- H2CA52089 1
- H2CO00019 1
- H2CO04045 1
- H2CT02112 1
- H2CT05131 1
- H2DE00072 1
- H2FL00250 1
- H2FL00292 1
- H2FL01100 1
- H2FL03056 1
- H2FL05127 1
- H2FL06109 1
- H2FL08055 1
- H2FL08063 1
- H2FL14053 1
- H2FL14194 1
- H2FL17056 1
- H2FL19037 1
- H2FL22072 1
- H2FL22080 1
- H2FL23021 1
- H2FL25018 1
- H2FL26057 1
- H2GA01157 1
- H2GA02031 1
- H2GA08038 1
- H2GA09036 1
- H2GA11149 1
- H2GA13012 1
- H2GU00033 1
- H2HI02110 1
- H2HI02128 1
- H2HI02508 1
- H2IA05072 1
- H2ID02034 1
- H2IL01042 1
- H2IL02172 1
- H2IL05092 1
- H2IL08039 1
- H2IL08088 1
- H2IL10068 1
- H2IL11124 1
- H2IL12122 1
- H2IL13120 1
- H2IL17071 1
- H2IL20026 1
- H2IL20042 1
- H2IN02295 1
- H2IN05025 1
- H2IN05082 1
- H2IN06023 1
- H2KY04071 1
- H2KY04121 1
- H2LA05084 1
- H2LA05126 1
- H2MA01020 1
- H2MA04073 1
- H2MA05054 1
- H2MA09072 1
- H2MA11060 1
- H2MD02160 1
- H2MD05155 1
- H2MD05361 1
- H2MD06054 1
- H2MD06195 1
- H2MD08126 1
- H2ME02097 1
- H2MI00037 1
- H2MI01068 1
- H2MI02066 1
- H2MI05119 1
- H2MI11042 1
- H2MI14111 1
- H2MI17023 1
- H2MN01223 1
- H2MN07014 1
- H2MN08111 1
- H2MO02102 1
- H2MT01060 1
- H2NC01081 1
- H2NC05074 1
- H2NC07096 1
- H2NC08185 1
- H2NC09134 1
- H2NC11080 1
- H2NC12021 1
- H2NC13029 1
- H2NC13110 1
- H2ND00057 1
- H2NE01118 1
- H2NJ02037 1
- H2NJ05014 1
- H2NJ10154 1
- H2NJ13075 1
- H2NM01144 1
- H2NM02126 1
- H2NV00050 1
- H2NV02395 1
- H2NV04011 1
- H2NY00010 1
- H2NY00036 1
- H2NY01067 1
- H2NY03089 1
- H2NY06116 1
- H2NY10092 1
- H2NY11017 1
- H2NY13096 1
- H2NY14037 1
- H2NY17071 1
- H2NY22139 1
- H2NY23137 1
- H2NY24036 1
- H2NY26080 1
- H2OH02085 1
- H2OH03067 1
- H2OH03091 1
- H2OH03125 1
- H2OH09031 1
- H2OH13033 1
- H2OH14064 1
- H2OH15046 1
- H2OH17109 1
- H2OK01093 1
- H2OK02083 1
- H2OK04055 1
- H2OR01133 1
- H2PA02055 1
- H2PA04135 1
- H2PA06080 1
- H2PA06114 1
- H2PA09035 1
- H2PA11098 1
- H2PA18143 1
- H2SC02042 1
- H2SC02059 1
- H2SC03057 1
- H2SC04022 1
- H2SC05052 1
- H2SC07066 1
- H2SD00092 1
- H2TN03052 1
- H2TN04027 1
- H2TN05131 1
- H2TN06030 1
- H2TN07103 1
- H2TX00015 1
- H2TX03118 1
- H2TX03126 1
- H2TX05121 1
- H2TX14149 1
- H2TX16185 1
- H2TX23082 1
- H2TX23124 1
- H2TX26093 1
- H2TX27026 1
- H2TX27190 1
- H2TX29030 1
- H2TX31044 1
- H2TX33040 1
- H2TX33073 1
- H2TX34113 1
- H2UT01094 1
- H2UT02324 1
- H2UT04023 1
- H2VA04052 1
- H2VA06115 1
- H2VA09010 1
- H2VI00082 1
- H2WA01054 1
- H2WA04041 1
- H2WA04090 1
- H2WA06129 1
- H2WI02124 1
- H2WV01029 1
- H3TX19021 1
- H4AL06098 1
- H4AR02141 1
- H4AR04048 1
- H4AS00036 1
- H4AZ01038 1
- H4AZ04016 1
- H4AZ04024 1
- H4AZ06045 1
- H4AZ07043 1
- H4CA11081 1
- H4CA12055 1
- H4CA16049 1
- H4CA17021 1
- H4CA20082 1
- H4CA23011 1
- H4CA25123 1
- H4CA33119 1
- H4CA35031 1
- H4CA45097 1
- H4CA49032 1
- H4CO03167 1
- H4FL02062 1
- H4FL13101 1
- H4FL14059 1
- H4FL15114 1
- H4FL20023 1
- H4GA06087 1
- H4GA08067 1
- H4GA10022 1
- H4GA11061 1
- H4GA12010 1
- H4HI01134 1
- H4IA03115 1
- H4IA05102 1
- H4IL03077 1
- H4IL07037 1
- H4IL11096 1
- H4IL18059 1
- H4IN01012 1
- H4IN02101 1
- H4IN04099 1
- H4KS02107 1
- H4KS04087 1
- H4KY01040 1
- H4KY02030 1
- H4KY06072 1
- H4LA00016 1
- H4LA03028 1
- H4LA05130 1
- H4LA06153 1
- H4LA07029 1
- H4MA03022 1
- H4MA05084 1
- H4MA06033 1
- H4MA06090 1
- H4ME02234 1
- H4MI03045 1
- H4MI04118 1
- H4MI04126 1
- H4MI07103 1
- H4MI11097 1
- H4MI12079 1
- H4MN06087 1
- H4MO05234 1
- H4MO08162 1
- H4MO09046 1
- H4MS01078 1
- H4MS02068 1
- H4MT00050 1
- H4MT01041 1
- H4NC01046 1
- H4NC05146 1
- H4NC06011 1
- H4NC06052 1
- H4NC09106 1
- H4NC10047 1
- H4NC12100 1
- H4NE01064 1
- H4NH02175 1
- H4NJ01084 1
- H4NJ03130 1
- H4NJ12149 1
- H4NJ13022 1
- H4NV04017 1
- H4NY04075 1
- H4NY07011 1
- H4NY11138 1
- H4NY21079 1
- H4NY22051 1
- H4NY24073 1
- H4NY27076 1
- H4NY29080 1
- H4OH02032 1
- H4OH19036 1
- H4OK02048 1
- H4OK02089 1
- H4OK05132 1
- H4OK06056 1
- H4PA08074 1
- H4PA13124 1
- H4PA15087 1
- H4PA18131 1
- H4PA21051 1
- H4PR00079 1
- H4RI01034 1
- H4SC01073 1
- H4SC03087 1
- H4TN04015 1
- H4TN06051 1
- H4TX02108 1
- H4TX04039 1
- H4TX04153 1
- H4TX06117 1
- H4TX09095 1
- H4TX10028 1
- H4TX10093 1
- H4TX13014 1
- H4TX18054 1
- H4TX19102 1
- H4TX19136 1
- H4TX24094 1
- H4TX28046 1
- H4VA02037 1
- H4VA07143 1
- H4VA10089 1
- H4VA11020 1
- H4VI00054 1
- H4WA04104 1
- H4WA05077 1
- H4WA08071 1
- H4WI04183 1
- H4WI06048 1
- H4WV02080 1
- H4WV03070 1
- H4WY00055 1
- H6AK00045 1
- H6AL04098 1
- H6AR01072 1
- H6AR02203 1
- H6AZ01199 1
- H6AZ05067 1
- H6AZ08038 1
- H6CA02010 1
- H6CA05195 1
- H6CA07043 1
- H6CA09023 1
- H6CA10088 1
- H6CA20152 1
- H6CA21028 1
- H6CA21135 1
- H6CA22125 1
- H6CA24048 1
- H6CA24113 1
- H6CA34112 1
- H6CA37222 1
- H6CA39020 1
- H6CA42099 1
- H6CA46033 1
- H6CA48039 1
- H6CO01141 1
- H6CO03139 1
- H6CO05159 1
- H6CO07023 1
- H6CT05124 1
- H6FL00046 1
- H6FL01119 1
- H6FL02208 1
- H6FL04105 1
- H6FL06035 1
- H6FL07140 1
- H6FL08213 1
- H6FL09070 1
- H6FL09179 1
- H6FL11126 1
- H6FL11134 1
- H6FL13148 1
- H6FL16059 1
- H6FL18097 1
- H6FL19038 1
- H6FL19087 1
- H6FL22040 1
- H6GA03113 1
- H6GA04129 1
- H6GA05217 1
- H6HI01121 1
- H6HI02244 1
- H6HI02251 1
- H6IA01098 1
- H6IA02146 1
- H6IA03144 1
- H6ID01177 1
- H6IL02124 1
- H6IL06117 1
- H6IL06141 1
- H6IL08147 1
- H6IL14095 1
- H6IL17155 1
- H6IL18088 1
- H6IN08210 1
- H6IN09176 1
- H6IN10141 1
- H6KS01096 1
- H6KS01146 1
- H6KS01179 1
- H6KY03124 1
- H6LA03148 1
- H6LA04138 1
- H6LA06083 1
- H6MA07101 1
- H6MD03177 1
- H6MD03292 1
- H6MD04183 1
- H6MD07020 1
- H6MD07160 1
- H6MD08457 1
- H6MD08549 1
- H6ME01157 1
- H6MI01028 1
- H6MI04113 1
- H6MI07108 1
- H6MI08163 1
- H6MI12181 1
- H6MI15127 1
- H6MI16034 1
- H6MN01174 1
- H6MN02149 1
- H6MN05183 1
- H6MN06074 1
- H6MN08047 1
- H6MO04141 1
- H6MO07128 1
- H6MO08084 1
- H6MS01131 1
- H6MS03046 1
- H6NC02080 1
- H6NC04037 1
- H6NC08111 1
- H6NC11172 1
- H6NE03115 1
- H6NH01230 1
- H6NJ05171 1
- H6NJ08118 1
- H6NJ09165 1
- H6NJ12136 1
- H6NJ12144 1
- H6NJ13191 1
- H6NV02164 1
- H6NV03139 1
- H6NV04020 1
- H6NY03031 1
- H6NY03247 1
- H6NY04112 1
- H6NY11174 1
- H6NY19029 1
- H6NY19144 1
- H6NY19169 1
- H6NY20167 1
- H6NY24128 1
- H6NY25125 1
- H6NY29168 1
- H6OH02086 1
- H6OH04082 1
- H6OH06095 1
- H6OH08315 1
- H6OH13133 1
- H6OH15104 1
- H6OH16029 1
- H6OH18157 1
- H6OH23033 1
- H6OK01102 1
- H6OK05160 1
- H6OR02116 1
- H6OR03064 1
- H6OR04047 1
- H6OR05069 1
- H6PA02171 1
- H6PA04110 1
- H6PA05091 1
- H6PA07105 1
- H6PA08194 1
- H6PA08277 1
- H6PA10109 1
- H6PA12030 1
- H6PA16197 1
- H6PA16320 1
- H6PR00082 1
- H6SD00044 1
- H6SD00085 1
- H6TN01313 1
- H6TN01388 1
- H6TN09068 1
- H6TX00115 1
- H6TX08100 1
- H6TX09033 1
- H6TX12060 1
- H6TX15055 1
- H6TX15162 1
- H6TX21012 1
- H6TX22101 1
- H6TX22143 1
- H6UT03042 1
- H6VA01117 1
- H6VA04061 1
- H6VA05068 1
- H6VA05142 1
- H6VA10050 1
- H6VT00160 1
- H6WA03135 1
- H6WA06021 1
- H6WA07458 1
- H6WA09025 1
- H6WI03099 1
- H6WI07033 1
- H6WI08122 1
- H6WI08155 1
- H6WV04057 1
- H8AL02130 1
- H8AL02171 1
- H8AL05109 1
- H8AZ01104 1
- H8AZ05097 1
- H8AZ08158 1
- H8AZ09040 1
- H8CA01109 1
- H8CA04152 1
- H8CA05035 1
- H8CA09060 1
- H8CA10126 1
- H8CA12098 1
- H8CA12171 1
- H8CA20059 1
- H8CA22089 1
- H8CA25074 1
- H8CA34068 1
- H8CA34266 1
- H8CA35032 1
- H8CA36097 1
- H8CA37079 1
- H8CA37137 1
- H8CA39240 1
- H8CA41063 1
- H8CA42061 1
- H8CA44034 1
- H8CA45130 1
- H8CA48035 1
- H8CA49058 1
- H8CA49074 1
- H8CA52052 1
- H8CO02087 1
- H8CO02137 1
- H8CO02160 1
- H8CO04067 1
- H8CO06054 1
- H8CO06138 1
- H8CT01046 1
- H8CT04057 1
- H8CT04172 1
- H8CT05245 1
- H8FL06056 1
- H8FL06148 1
- H8FL15107 1
- H8FL15230 1
- H8FL16022 1
- H8FL17053 1
- H8FL22038 1
- H8FL24026 1
- H8FL25015 1
- H8FL26039 1
- H8FL27185 1
- H8FL27193 1
- H8GA06146 1
- H8GA06195 1
- H8GA06286 1
- H8GA06393 1
- H8GA10049 1
- H8GU01020 1
- H8IA01094 1
- H8IA02043 1
- H8ID01090 1
- H8ID01124 1
- H8ID02064 1
- H8IL03102 1
- H8IL04134 1
- H8IL09067 1
- H8IL11113 1
- H8IL13051 1
- H8IL13069 1
- H8IL14067 1
- H8IL14174 1
- H8IL18043 1
- H8IL21021 1
- H8IN02060 1
- H8IN06129 1
- H8IN07184 1
- H8IN09032 1
- H8KS02090 1
- H8KS02199 1
- H8KS03049 1
- H8KS03155 1
- H8KS04112 1
- H8KY02031 1
- H8LA00017 1
- H8LA02054 1
- H8LA04134 1
- H8LA04225 1
- H8LA06022 1
- H8MA02041 1
- H8MA03106 1
- H8MA05143 1
- H8MA07032 1
- H8MA08071 1
- H8MD01037 1
- H8MD01086 1
- H8MD01094 1
- H8ME01120 1
- H8ME02185 1
- H8MI07096 1
- H8MI08102 1
- H8MI09068 1
- H8MI09118 1
- H8MI11254 1
- H8MI13243 1
- H8MI13250 1
- H8MN03077 1
- H8MN03143 1
- H8MN05239 1
- H8MN06047 1
- H8MN08043 1
- H8MO09153 1
- H8MP00041 1
- H8MS01061 1
- H8MS03067 1
- H8MS03125 1
- H8MS05047 1
- H8MT01182 1
- H8NC07044 1
- H8NC08042 1
- H8NC13067 1
- H8NE02139 1
- H8NH01210 1
- H8NJ02166 1
- H8NJ03073 1
- H8NJ03156 1
- H8NJ03206 1
- H8NJ04014 1
- H8NJ05052 1
- H8NJ06118 1
- H8NJ07124 1
- H8NJ07223 1
- H8NJ11142 1
- H8NM01174 1
- H8NM01224 1
- H8NM01257 1
- H8NM01331 1
- H8NM02032 1
- H8NM02156 1
- H8NM02248 1
- H8NM03097 1
- H8NM03196 1
- H8NV01071 1
- H8NV03036 1
- H8NY01148 1
- H8NY06048 1
- H8NY07046 1
- H8NY09091 1
- H8NY11113 1
- H8NY13028 1
- H8NY13077 1
- H8NY15148 1
- H8NY19058 1
- H8NY19181 1
- H8NY19223 1
- H8NY20056 1
- H8NY21203 1
- H8NY23084 1
- H8NY24066 1
- H8NY25105 1
- H8NY26095 1
- H8NY27036 1
- H8NY27077 1
- H8OH01043 1
- H8OH01068 1
- H8OH05036 1
- H8OH05044 1
- H8OH07065 1
- H8OH11067 1
- H8OH11141 1
- H8OH15076 1
- H8OH16058 1
- H8OH16124 1
- H8OK01157 1
- H8OK05109 1
- H8OR01072 1
- H8OR05107 1
- H8PA01153 1
- H8PA03084 1
- H8PA04116 1
- H8PA05071 1
- H8PA06087 1
- H8PA07200 1
- H8PA10147 1
- H8PA13125 1
- H8PA15096 1
- H8PA15229 1
- H8PA18181 1
- H8PA18199 1
- H8PR00062 1
- H8SC04250 1
- H8SC05158 1
- H8SD01055 1
- H8TN02069 1
- H8TN06094 1
- H8TN07076 1
- H8TN08033 1
- H8TX03123 1
- H8TX05144 1
- H8TX06035 1
- H8TX06233 1
- H8TX06266 1
- H8TX07140 1
- H8TX16109 1
- H8TX20077 1
- H8TX21307 1
- H8TX22107 1
- H8TX28013 1
- H8TX29052 1
- H8UT03089 1
- H8UT04053 1
- H8VA01147 1
- H8VA02046 1
- H8VA02111 1
- H8VA05106 1
- H8VA05171 1
- H8VA07094 1
- H8VA10106 1
- H8VA11062 1
- H8VT00034 1
- H8VT01016 1
- H8WA07132 1
- H8WA08189 1
- H8WI00018 1
- H8WI01024 1
- H8WI01156 1
- H8WI09050 1
- H8WV03097 1
- H8WY00106 1
- H8WY00148 1
- P00003483 1
- P00003806 1
- P20000741 1
- P20002978 1
- P80002801 1
- P80003023 1
- P80003247 1
- P80005721 1
- S0AL00156 1
- S0AL00230 1
- S0AR00028 1
- S0AR00150 1
- S0AZ00350 1
- S0CA00199 1
- S0CO00575 1
- S0CT00037 1
- S0FL00338 1
- S0FL00403 1
- S0GA00526 1
- S0GA00559 1
- S0HI00084 1
- S0IA00028 1
- S0ID00057 1
- S0IL00261 1
- S0IN00053 1
- S0IN00095 1
- S0KS00091 1
- S0KS00315 1
- …
id | name | id_bioguide | id_govtrack | id_icpsr | id_wikipedia | id_wikidata | id_google_entity_id | name_first | name_last | bio_birthday | bio_gender | id_house_history ▼ | name_middle | name_nickname | id_ballotpedia | name_suffix | id_bioguide_previous | id_house_history_alternate | other_names | id_thomas | id_cspan | id_votesmart | id_lis | name_official_full | id_opensecrets | id_fec | id_maplight | leadership_roles | family |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
D000298 | Nathaniel Dial | D000298 | 403421 | 2552 | Nathaniel B. Dial | Q1966712 | kg:/m/0d06g_ | Nathaniel | Dial | 1862-04-24 | M | Barksdale | |||||||||||||||||
D000308 | Mahlon Dickerson | D000308 | 403429 | 2561 | Mahlon Dickerson | Q879427 | kg:/m/03jkc9 | Mahlon | Dickerson | 1770-04-17 | M | ||||||||||||||||||
D000317 | Daniel Dickinson | D000317 | 403437 | 2569 | Daniel S. Dickinson | Q1162460 | kg:/m/04c7k9 | Daniel | Dickinson | 1800-09-11 | M | Stevens | |||||||||||||||||
D000341 | Charles Dietrich | D000341 | 403459 | 2591 | Charles Henry Dietrich | Q881216 | kg:/m/08m6vm | Charles | Dietrich | 1853-11-26 | M | Henry | |||||||||||||||||
D000347 | William Dillingham | D000347 | 403465 | 2597 | William P. Dillingham | Q881697 | kg:/m/0c6pv8 | William | Dillingham | 1843-12-12 | M | Paul | |||||||||||||||||
D000365 | John Dix | D000365 | 403482 | 2614 | John Adams Dix | Q720259 | kg:/m/03kw8x | John | Dix | 1798-07-24 | M | Adams | |||||||||||||||||
D000366 | Alan Dixon | D000366 | 403483 | 14902 | Alan J. Dixon | Q1886056 | kg:/m/049q6m | Alan | Dixon | 1927-07-07 | M | John | 01317 | S149 | |||||||||||||||
D000367 | Archibald Dixon | D000367 | 403484 | 2615 | Archibald Dixon | Q4786289 | kg:/m/09gyjk | Archibald | Dixon | 1802-04-02 | M | ||||||||||||||||||
D000376 | Nathan Dixon | D000376 | 403491 | 2622 | Nathan F. Dixon I | Q1966536 | kg:/m/0d1y_3 | Nathan | Dixon | 1774-12-13 | M | Fellows | |||||||||||||||||
D000405 | Joseph Dolph | D000405 | 403519 | 2649 | Joseph N. Dolph | Q1591635 | kg:/m/0d4fw6 | Joseph | Dolph | 1835-10-19 | M | Norton | |||||||||||||||||
D000407 | Pete Domenici | D000407 | 300036 | 14103 | Pete Domenici | Q964959 | kg:/m/01vjn1 | Pete | Domenici | 1932-05-07 | M | V. | 01319 | 53325 | S027 | N00006515 | [ "S8NM00010" ] |
||||||||||||
D000410 | Alvin Donahey | D000410 | 403523 | 2652 | A. Victor Donahey | Q279193 | kg:/m/033tsr | Alvin | Donahey | 1873-07-07 | M | Victor | |||||||||||||||||
D000414 | Forrest Donnell | D000414 | 403527 | 2656 | Forrest C. Donnell | Q884961 | kg:/m/03v57p | Forrest | Donnell | 1884-08-20 | M | C. | |||||||||||||||||
D000428 | James Doolittle | D000428 | 403540 | 2668 | James Rood Doolittle | Q1681056 | kg:/m/06jh3p | James | Doolittle | 1815-01-03 | M | Rood | |||||||||||||||||
D000441 | Stephen Dorsey | D000441 | 403551 | 2678 | Stephen Wallace Dorsey | Q2345172 | kg:/m/055hd2 | Stephen | Dorsey | 1842-02-28 | M | Wallace | |||||||||||||||||
D000456 | Paul Douglas | D000456 | 403566 | 2691 | Paul Douglas | Q1372141 | kg:/m/01s2pp | Paul | Douglas | 1892-03-26 | M | Howard | |||||||||||||||||
D000469 | Sheridan Downey | D000469 | 403579 | 2702 | Sheridan Downey | Q2278283 | kg:/m/03jlks | Sheridan | Downey | 1884-03-11 | M | ||||||||||||||||||
D000476 | Solomon Downs | D000476 | 403585 | 2708 | Solomon W. Downs | Q2299278 | kg:/m/0d32c0 | Solomon | Downs | M | Weathersbee | ||||||||||||||||||
D000484 | Charles Drake | D000484 | 403592 | 2715 | Charles D. Drake | Q1064028 | kg:/m/0d01ls | Charles | Drake | 1811-04-11 | M | Daniel | |||||||||||||||||
D000495 | Irving Drew | D000495 | 403602 | 2725 | Irving W. Drew | Q1673294 | kg:/m/0d7tvf | Irving | Drew | 1845-01-08 | M | Webster | |||||||||||||||||
D000507 | John Dryden | D000507 | 403614 | 2736 | John F. Dryden | Q5624820 | kg:/m/0csmf0 | John | Dryden | 1839-08-07 | M | Fairfield | |||||||||||||||||
D000511 | Charles Dudley | D000511 | 403621 | 2740 | Charles E. Dudley | Q5077087 | kg:/m/09w8ts | Charles | Dudley | 1780-05-23 | M | Edward | |||||||||||||||||
D000516 | James Duff | D000516 | 403626 | 2745 | James H. Duff | Q881621 | kg:/m/037rgj | James | Duff | 1883-01-21 | M | Henderson | |||||||||||||||||
D000518 | Francis Duffy | D000518 | 403628 | 2747 | F. Ryan Duffy | Q773402 | kg:/m/03blb_ | Francis | Duffy | 1888-06-23 | M | Ryan | |||||||||||||||||
D000522 | John Dulles | D000522 | 403632 | 2751 | John Foster Dulles | Q223677 | kg:/m/0ks3n | John | Dulles | 1888-02-25 | M | Foster | |||||||||||||||||
D000559 | Henry du Pont | D000559 | 403616 | 2781 | Henry A. du Pont | Q2152064 | kg:/m/06vrz8 | Henry | du Pont | 1838-07-30 | M | Algernon | |||||||||||||||||
D000560 | Thomas du Pont | D000560 | 403618 | 2782 | T. Coleman du Pont | Q2383282 | kg:/m/06vvv7 | Thomas | du Pont | 1863-12-11 | M | Coleman | |||||||||||||||||
D000566 | David Durenberger | D000566 | 403669 | 14703 | David Durenberger | Q1174268 | kg:/m/01l4v5 | David | Durenberger | 1934-08-19 | M | Ferdinand | 01321 | S133 | |||||||||||||||
D000574 | John Durkin | D000574 | 403677 | 14310 | John A. Durkin | Q995271 | kg:/m/061wy0 | John | Durkin | 1936-03-29 | M | Anthony | 01322 | ||||||||||||||||
D000596 | Mark Dayton | D000596 | 300032 | 40101 | Mark Dayton | Q513091 | kg:/m/01l42w | Mark | Dayton | 1947-01-26 | M | 01629 | S280 | N00013291 | |||||||||||||||
D000618 | Steve Daines | D000618 | 412549 | 21338 | Steve Daines | Q3200900 | kg:/m/03qlc5t | Steve | Daines | 1962-08-20 | M | Steve Daines | 02138 | 1034037 | 135720 | S375 | Steve Daines | N00033054 | [ "H2MT01060", "S2MT00096" ] |
1773 | |||||||||
D000619 | Rodney Davis | D000619 | 412536 | 21328 | Rodney Davis (politician) | Q134035 | kg:/m/0jwttjt | Rodney | Davis | 1970-01-05 | M | Rodney Davis (Illinois) | 02126 | 68337 | 9622 | Rodney Davis | N00034784 | [ "H2IL13120" ] |
1760 | ||||||||||
D000620 | John Delaney | D000620 | 412544 | 21334 | John Delaney (Maryland politician) | Q2688821 | kg:/m/09g8h5d | John | Delaney | 1963-04-16 | M | K. | John Delaney | 02133 | 68432 | 135143 | John K. Delaney | N00033897 | [ "H2MD06195" ] |
1768 | |||||||||
D000621 | Ron DeSantis | D000621 | 412526 | 21318 | Ron DeSantis | Q3105215 | kg:/m/0l8mn35 | Ron | DeSantis | 1978-09-14 | M | Ron DeSantis | 02116 | 79744 | 137630 | Ron DeSantis | N00034746 | [ "H2FL00292" ] |
1750 | ||||||||||
D000623 | Mark DeSaulnier | D000623 | 412613 | 21504 | Mark DeSaulnier | Q6767311 | kg:/m/0289gkw | Mark | DeSaulnier | 1952-03-31 | M | Mark DeSaulnier | 02227 | 61736 | 69477 | Mark DeSaulnier | N00030709 | [ "H0CA10073" ] |
2069 | ||||||||||
D000625 | Daniel Donovan | D000625 | 412672 | 21560 | Dan Donovan (politician) | Q5217998 | kg:/m/0c036qd | Daniel | Donovan | 1956-11-06 | M | M. | Daniel Donovan (New York) | Jr. | 02293 | 74763 | 127760 | Daniel M. Donovan, Jr. | N00036928 | [ "H6NY11174" ] |
2161 | ||||||||
D000626 | Warren Davidson | D000626 | 412675 | 21564 | Warren Davidson | Q24458117 | kg:/g/11cmmch3q8 | Warren | Davidson | 1970-03-01 | M | Warren Davidson | 02296 | 102555 | 166760 | Warren Davidson | N00038767 | [ "H6OH08315" ] |
2165 | ||||||||||
D000627 | Val Demings | D000627 | 412696 | 21713 | Val Demings | Q7909083 | kg:/m/0n52xwn | Val | Demings | 1957-03-12 | F | Butler | Val Demings | 623713 | 137637 | Val Butler Demings | N00033449 | [ "H2FL08063" ] |
2208 | ||||||||||
D000628 | Neal Dunn | D000628 | 412691 | 21714 | Neal Dunn | Q27733851 | kg:/g/11c2ld4vv7 | Neal | Dunn | 1953-02-16 | M | P. | Neal Dunn | 104529 | 166297 | Neal P. Dunn | N00037442 | [ "H6FL02208" ] |
2203 | ||||||||||
D000629 | Sharice Davids | D000629 | 412780 | 21914 | Sharice Davids | Q58322868 | kg:/g/11fgm1fq16 | Sharice | Davids | 1980-05-22 | F | Sharice Davids | 181201 | Sharice Davids | N00042626 | [ "H8KS03155" ] |
|||||||||||||
D000630 | Antonio Delgado | D000630 | 412805 | 21916 | Antonio Delgado (politician) | Q60428696 | kg:/g/11gzqgrp2f | Antonio | Delgado | 1977-01-19 | M | Antonio Delgado (New York) | 180313 | Antonio Delgado | N00040741 | [ "H8NY19181" ] |
|||||||||||||
D000631 | Madeleine Dean | D000631 | 412809 | 21915 | Madeleine Dean | Q6726900 | kg:/m/0nfwmy_ | Madeleine | Dean | 1959-06-06 | F | Madeleine Dean | 136484 | Madeleine Dean | N00042894 | [ "H8PA04116" ] |
|||||||||||||
E000004 | Thomas Eagleton | E000004 | 403700 | 12104 | Thomas Eagleton | Q3176929 | kg:/m/01qpdm | Thomas | Eagleton | 1929-09-04 | M | Francis | 01323 | ||||||||||||||||
E000009 | Joseph Earle | E000009 | 403705 | 2815 | Joseph H. Earle | Q477984 | kg:/m/0d0557 | Joseph | Earle | 1847-04-30 | M | Haynsworth | |||||||||||||||||
E000017 | John East | E000017 | 403713 | 14903 | John Porter East | Q1701454 | kg:/m/02km71 | John | East | 1931-05-05 | M | Porter | 01324 | ||||||||||||||||
E000018 | James Eastland | E000018 | 403714 | 2822 | James Eastland | Q723926 | kg:/m/0hj7r | James | Eastland | 1904-11-28 | M | Oliver | 01325 | ||||||||||||||||
E000024 | John Eaton | E000024 | 403720 | 2828 | John Eaton (politician) | Q878759 | kg:/m/01th2m | John | Eaton | 1790-06-18 | M | Henry | |||||||||||||||||
E000037 | Zales Ecton | E000037 | 403732 | 2838 | Zales Ecton | Q145051 | kg:/m/04w4rk | Zales | Ecton | 1898-04-01 | M | Nelson | |||||||||||||||||
E000044 | Walter Edge | E000044 | 403739 | 2844 | Walter Evans Edge | Q882266 | kg:/m/028_xs | Walter | Edge | 1873-11-20 | M | Evans | |||||||||||||||||
E000046 | Alonzo Edgerton | E000046 | 403741 | 2846 | Alonzo J. Edgerton | Q2602125 | kg:/m/01l_8p | Alonzo | Edgerton | 1827-06-07 | M | Jay | |||||||||||||||||
E000055 | James Edmondson | E000055 | 403750 | 10803 | J. Howard Edmondson | Q888066 | kg:/m/07tsts | James | Edmondson | 1925-09-27 | M | Howard | |||||||||||||||||
E000056 | George Edmunds | E000056 | 403751 | 2855 | George F. Edmunds | Q1507329 | kg:/m/03bgx5 | George | Edmunds | 1828-02-01 | M | Franklin | |||||||||||||||||
E000066 | Edward Edwards | E000066 | 403759 | 2863 | Edward I. Edwards | Q436902 | kg:/m/03zqq6 | Edward | Edwards | 1863-12-01 | M | Irving | |||||||||||||||||
E000071 | Jake Ellzey | E000071 | 456862 | Jake Ellzey | Q105061782 | Jake | Ellzey | 1970-01-24 | M | Jake Ellzey | Jake Ellzey | N00042243 | [ "H8TX06266" ] |
||||||||||||||||
E000075 | John Edwards | E000075 | 403764 | 2866 | John Edwards (Kentucky politician) | Q432795 | kg:/m/08rgfg | John | Edwards | M | |||||||||||||||||||
E000078 | Ninian Edwards | E000078 | 403770 | 2871 | Ninian Edwards | Q744084 | kg:/m/03bgz9 | Ninian | Edwards | 1775-03-17 | M | ||||||||||||||||||
E000109 | Davis Elkins | E000109 | 403800 | 2898 | Davis Elkins | Q732313 | kg:/m/0cxcz2 | Davis | Elkins | 1876-01-24 | M | ||||||||||||||||||
E000112 | Allen Ellender | E000112 | 403803 | 2901 | Allen J. Ellender | Q363276 | kg:/m/03bp8c | Allen | Ellender | 1890-09-24 | M | Joseph | |||||||||||||||||
E000114 | Christopher Ellery | E000114 | 403805 | 2903 | Christopher Ellery | Q447135 | kg:/m/0d2r5z | Christopher | Ellery | 1768-11-01 | M | ||||||||||||||||||
E000124 | John Elliott | E000124 | 403815 | 2913 | John Elliott (Georgia politician) | Q1486508 | kg:/m/0ct0n8 | John | Elliott | 1773-10-24 | M | ||||||||||||||||||
E000136 | Powhatan Ellis | E000136 | 403827 | 2925 | Powhatan Ellis | Q5709686 | kg:/m/0d4hjh | Powhatan | Ellis | 1790-01-17 | M | ||||||||||||||||||
E000202 | John Erickson | E000202 | 403889 | 2980 | John E. Erickson (Montana politician) | Q883531 | kg:/m/0bfpyg | John | Erickson | 1863-03-14 | M | Edward | |||||||||||||||||
E000206 | Richard Ernst | E000206 | 403893 | 2983 | Richard P. Ernst | Q2150336 | kg:/m/0689bd | Richard | Ernst | 1858-02-28 | M | Pretlow | |||||||||||||||||
E000229 | James Eustis | E000229 | 403914 | 3000 | James B. Eustis | Q1238888 | kg:/m/0d3gqt | James | Eustis | 1834-08-27 | M | Biddle | |||||||||||||||||
E000236 | Daniel Evans | E000236 | 403920 | 14916 | Daniel J. Evans | Q880613 | kg:/m/01nm3f | Daniel | Evans | 1925-10-16 | M | Jackson | 01327 | ||||||||||||||||
E000249 | Josiah Evans | E000249 | 403932 | 3015 | Josiah J. Evans | Q1708637 | kg:/m/0cp0_y | Josiah | Evans | 1786-11-27 | M | James | |||||||||||||||||
E000262 | William Evarts | E000262 | 403943 | 3024 | William M. Evarts | Q709167 | kg:/m/02vjsf | William | Evarts | 1818-02-06 | M | Maxwell | |||||||||||||||||
E000281 | Thomas Ewing | E000281 | 403959 | 3041 | Thomas Ewing | Q1335443 | kg:/m/0351xv | Thomas | Ewing | 1789-12-28 | M | ||||||||||||||||||
E000283 | William Ewing | E000283 | 403961 | 3043 | William Lee D. Ewing | Q734659 | kg:/m/0854cw | William | Ewing | 1795-08-31 | M | Lee Davidson | |||||||||||||||||
E000284 | J. Exon | E000284 | 403962 | 14704 | J. James Exon | Q881037 | kg:/m/03bw74 | J. | Exon | 1921-08-09 | M | James | 01328 | S129 | |||||||||||||||
E000285 | Michael Enzi | E000285 | 300041 | 49706 | Mike Enzi | Q432431 | kg:/m/021ph1 | Michael | Enzi | 1944-02-01 | M | B. | Mike Enzi | 01542 | 45824 | 558 | S254 | Michael B. Enzi | N00006249 | [ "S6WY00126" ] |
565 | ||||||||
E000286 | John Edwards | E000286 | 300039 | 49902 | John Edwards | Q217314 | kg:/m/01651q | John | Edwards | 1953-06-10 | M | Reid | 01573 | 21107 | S267 | N00002283 | |||||||||||||
E000292 | William Enyart | E000292 | 412535 | 21327 | William Enyart | Q797837 | kg:/m/0k2fvzd | William | Enyart | 1949-09-22 | M | L. | William Enyart | 02125 | 79286 | 110744 | William L. Enyart | N00034884 | [ "H2IL12122" ] |
1759 | |||||||||
E000294 | Tom Emmer | E000294 | 412639 | 21531 | Tom Emmer | Q7815723 | kg:/m/06w2w3l | Tom | Emmer | 1961-03-03 | M | Tom Emmer | 02253 | 75567 | 38894 | Tom Emmer | N00035440 | [ "H4MN06087" ] |
2095 | ||||||||||
E000296 | Dwight Evans | E000296 | 412677 | 21566 | Dwight Evans (politician) | Q5318148 | kg:/m/03y8h6m | Dwight | Evans | 1954-05-16 | M | Dwight Evans | 56729 | 9128 | Dwight Evans | N00038450 | [ "H6PA02171" ] |
2167 | |||||||||||
E000297 | Adriano Espaillat | E000297 | 412718 | 21715 | Adriano Espaillat | Q4685569 | kg:/m/06nfs2 | Adriano | Espaillat | 1954-09-27 | M | Adriano Espaillat | 68413 | 14379 | Adriano Espaillat | N00034549 | [ "H2NY13096" ] |
2230 | |||||||||||
E000299 | Veronica Escobar | E000299 | 412825 | 21917 | Veronica Escobar | Q52274267 | kg:/g/11ghdw9g9p | Veronica | Escobar | 1969-09-15 | F | Veronica Escobar | 99345 | Veronica Escobar | N00041702 | [ "H8TX16109" ] |
|||||||||||||
F000002 | James Fair | F000002 | 403964 | 3045 | James Graham Fair | Q3161114 | kg:/m/02kjtd | James | Fair | 1831-12-03 | M | Graham | |||||||||||||||||
F000003 | Charles Fairbanks | F000003 | 403965 | 3046 | Charles W. Fairbanks | Q270539 | kg:/m/0myr7 | Charles | Fairbanks | 1852-05-11 | M | Warren | |||||||||||||||||
F000011 | Albert Fall | F000011 | 403973 | 3053 | Albert B. Fall | Q1397640 | kg:/m/02qbq6 | Albert | Fall | 1861-11-26 | M | Bacon | |||||||||||||||||
F000013 | Paul Fannin | F000013 | 403975 | 10804 | Paul Fannin | Q888641 | kg:/m/04dt8k | Paul | Fannin | 1907-01-29 | M | Jones | 01330 | ||||||||||||||||
F000020 | James Farley | F000020 | 403982 | 3061 | James T. Farley | Q1681164 | kg:/m/03m0n8 | James | Farley | 1829-08-06 | M | Thompson | |||||||||||||||||
F000038 | Nathan Farwell | F000038 | 403999 | 3076 | Nathan A. Farwell | Q1549976 | kg:/m/0bnxp8 | Nathan | Farwell | 1812-02-24 | M | Allen | |||||||||||||||||
F000045 | Charles Faulkner | F000045 | 404005 | 3081 | Charles James Faulkner | Q1065023 | kg:/m/0cwlyd | Charles | Faulkner | 1847-09-21 | M | James | |||||||||||||||||
F000057 | William Feazel | F000057 | 404017 | 3090 | William C. Feazel | Q329366 | kg:/m/0d3hqs | William | Feazel | 1895-06-10 | M | Crosson | |||||||||||||||||
F000061 | Russell Feingold | F000061 | 300042 | 49309 | Russ Feingold | Q356475 | kg:/m/01nvvl | Russell | Feingold | 1953-03-02 | M | D. | Russ Feingold | 01331 | 53361 | S230 | N00000036 | [ "S8WI00026" ] |
|||||||||||
F000063 | Alpheus Felch | F000063 | 404021 | 3093 | Alpheus Felch | Q373179 | kg:/m/02w3th | Alpheus | Felch | 1804-09-28 | M | ||||||||||||||||||
F000074 | James Fenner | F000074 | 404032 | 3104 | James Fenner | Q880519 | kg:/m/0bjmgh | James | Fenner | 1771-01-22 | M | ||||||||||||||||||
F000081 | Homer Ferguson | F000081 | 404039 | 3110 | Homer S. Ferguson | Q1626032 | kg:/m/0368_j | Homer | Ferguson | 1889-02-25 | M | Samuel | |||||||||||||||||
F000084 | Bert Fernald | F000084 | 404042 | 3113 | Bert M. Fernald | Q370253 | kg:/m/0bpjqd | Bert | Fernald | 1858-04-03 | M | Manfred | |||||||||||||||||
F000092 | Woodbridge Ferris | F000092 | 404049 | 3120 | Woodbridge Nathan Ferris | Q880349 | kg:/m/01gc2c | Woodbridge | Ferris | 1853-01-06 | M | Nathan | |||||||||||||||||
F000106 | Richard Field | F000106 | 404063 | 3133 | Richard Stockton Field | Q2150704 | kg:/m/0b287f | Richard | Field | 1803-12-31 | M | Stockton | |||||||||||||||||
F000118 | William Finck | F000118 | 404074 | 3142 | William E. Finck | Q8008234 | kg:/m/02rm3kn | William | Finck | 1822-09-01 | M | Edward | |||||||||||||||||
F000122 | William Findlay | F000122 | 404078 | 3146 | William Findlay (governor) | Q731215 | kg:/m/0293dd | William | Findlay | 1768-06-20 | M | ||||||||||||||||||
F000167 | Thomas Fitzgerald | F000167 | 404122 | 3185 | Thomas Fitzgerald (American politician) | Q1587977 | kg:/m/02wqbg | Thomas | Fitzgerald | 1796-04-10 | M | ||||||||||||||||||
F000174 | Benjamin Fitzpatrick | F000174 | 404129 | 3192 | Benjamin Fitzpatrick | Q817483 | kg:/m/03f3xz | Benjamin | Fitzpatrick | 1802-06-30 | M | ||||||||||||||||||
F000186 | James Flanagan | F000186 | 404141 | 3203 | James W. Flanagan | Q437158 | kg:/m/07jjx6 | James | Flanagan | 1805-09-05 | M | Winright | |||||||||||||||||
F000190 | Ralph Flanders | F000190 | 404145 | 3206 | Ralph Flanders | Q201751 | kg:/m/03_fpt | Ralph | Flanders | 1880-09-28 | M | Edward | |||||||||||||||||
F000200 | Duncan Fletcher | F000200 | 404155 | 3216 | Duncan U. Fletcher | Q1265460 | kg:/m/08rsv5 | Duncan | Fletcher | 1859-01-06 | M | Upshaw | |||||||||||||||||
F000207 | Frank Flint | F000207 | 404162 | 3223 | Frank Putnam Flint | Q1443922 | kg:/m/03sgt1 | Frank | Flint | 1862-07-15 | M | Putnam |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [legislators] ( [id] TEXT PRIMARY KEY, [name] TEXT, [id_bioguide] TEXT, [id_govtrack] INTEGER, [id_icpsr] INTEGER, [id_wikipedia] TEXT, [id_wikidata] TEXT, [id_google_entity_id] TEXT, [name_first] TEXT, [name_last] TEXT, [bio_birthday] TEXT, [bio_gender] TEXT , [id_house_history] INTEGER, [name_middle] TEXT, [name_nickname] TEXT, [id_ballotpedia] TEXT, [name_suffix] TEXT, [id_bioguide_previous] TEXT, [id_house_history_alternate] INTEGER, [other_names] TEXT, [id_thomas] TEXT, [id_cspan] INTEGER, [id_votesmart] INTEGER, [id_lis] TEXT, [name_official_full] TEXT, [id_opensecrets] TEXT, [id_fec] TEXT, [id_maplight] INTEGER, [leadership_roles] TEXT, [family] TEXT);