legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id_wikipedia
This data as json, copyable, CSV (advanced)
Suggested facets: name_nickname, name_suffix, name_official_full, bio_birthday (date), id_bioguide_previous (array)
id_fec (array) >1000 ✖
- H0AL01055 1
- 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
- H0CA03078 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
- H0CO03165 1
- H0CO04122 1
- H0CT03072 1
- H0DC00058 1
- H0DE01017 1
- H0FL02086 1
- H0FL02110 1
- H0FL03175 1
- H0FL04066 1
- H0FL05139 1
- H0FL08042 1
- H0FL08208 1
- H0FL12051 1
- H0FL12101 1
- H0FL15104 1
- H0FL17068 1
- H0FL18025 1
- H0FL19080 1
- H0FL19205 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
- H0GA09246 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
- H0KY06104 1
- H0LA01079 1
- H0LA01087 1
- H0LA02119 1
- H0LA03141 1
- H0MA04036 1
- H0MA04192 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
- H0NC09187 1
- H0NC11233 1
- H0ND00135 1
- H0ND01026 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
- H0NY16143 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
- H0OK05205 1
- H0OR02127 1
- H0OR03026 1
- H0PA03271 1
- H0PA04220 1
- H0PA06076 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
- H2AR04083 1
- H2AZ01172 1
- H2AZ02055 1
- H2AZ06130 1
- H2AZ07070 1
- H2AZ08094 1
- H2AZ08102 1
- H2AZ09019 1
- H2CA00104 1
- H2CA00120 1
- H2CA01045 1
- H2CA01144 1
- H2CA02142 1
- H2CA06028 1
- H2CA06259 1
- H2CA08164 1
- H2CA15094 1
- H2CA18056 1
- H2CA19054 1
- H2CA20094 1
- H2CA22231 1
- H2CA25036 1
- H2CA26026 1
- H2CA27107 1
- H2CA28113 1
- H2CA30143 1
- H2CA31125 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
- H2GA09150 1
- H2GA11149 1
- H2GA12121 1
- H2GA13012 1
- H2GU00033 1
- H2HI02110 1
- H2HI02128 1
- H2HI02508 1
- H2IA01055 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
- H2LA02149 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
- H2MI11133 1
- H2MI11190 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
- H2OH11169 1
- H2OH13033 1
- H2OH14064 1
- H2OH15046 1
- H2OH15228 1
- H2OH17109 1
- H2OK01093 1
- H2OK01143 1
- H2OK02083 1
- H2OK04055 1
- H2OR01133 1
- H2PA02055 1
- H2PA04135 1
- H2PA06080 1
- H2PA06114 1
- H2PA09035 1
- H2PA11098 1
- H2PA17079 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
- H2TX35011 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
- H4AL01123 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
- H4CO04090 1
- H4FL02062 1
- H4FL13101 1
- H4FL14059 1
- H4FL15114 1
- H4FL19074 1
- H4FL20023 1
- H4FL26038 1
- H4GA01039 1
- H4GA06087 1
- H4GA08067 1
- H4GA10022 1
- H4GA11061 1
- H4GA12010 1
- H4HI01134 1
- H4IA03115 1
- H4IA05102 1
- H4IL03077 1
- H4IL07037 1
- H4IL11096 1
- H4IL12060 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
- H4LA05221 1
- H4LA06153 1
- H4LA07029 1
- H4MA03022 1
- H4MA05084 1
- H4MA06033 1
- H4MA06090 1
- H4ME02234 1
- H4MI03045 1
- H4MI04118 1
- H4MI04126 1
- H4MI07103 1
- H4MI08135 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
- H4NE02054 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
- H4PA13199 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
- H4VA08224 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
- H6AZ05083 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
- H6CA24303 1
- H6CA34112 1
- H6CA37222 1
- H6CA39020 1
- H6CA42099 1
- H6CA44103 1
- H6CA46033 1
- H6CA46116 1
- H6CA48039 1
- H6CO01141 1
- H6CO03139 1
- H6CO05159 1
- H6CO07023 1
- H6CT05124 1
- H6DE00206 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
- H6FL13205 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
- H6IN03229 1
- H6IN08210 1
- H6IN09176 1
- H6IN10141 1
- H6KS01096 1
- H6KS01146 1
- H6KS01179 1
- H6KY01110 1
- H6KY03124 1
- H6LA03148 1
- H6LA04138 1
- H6LA06083 1
- H6MA07101 1
- H6MD03177 1
- H6MD03292 1
- H6MD04183 1
- H6MD04209 1
- H6MD07020 1
- H6MD07160 1
- H6MD08457 1
- H6MD08549 1
- H6ME01157 1
- H6MI01028 1
- H6MI01226 1
- H6MI04113 1
- H6MI07108 1
- H6MI08163 1
- H6MI12181 1
- H6MI15127 1
- H6MI16034 1
- H6MN01174 1
- H6MN02131 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
- H6NC13129 1
- H6ND00074 1
- H6NE02125 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
- H6TX02079 1
- H6TX08100 1
- H6TX09033 1
- H6TX12060 1
- H6TX15055 1
- H6TX15162 1
- H6TX19099 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
- H6WY00159 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
- H8CA10167 1
- H8CA12098 1
- H8CA12171 1
- H8CA20059 1
- H8CA22089 1
- H8CA25074 1
- H8CA34068 1
- H8CA34266 1
- H8CA35032 1
- H8CA36097 1
- H8CA37079 1
- H8CA37137 1
- H8CA39174 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
- H8CO06229 1
- H8CT01046 1
- H8CT04057 1
- H8CT04172 1
- H8CT05245 1
- H8FL06056 1
- H8FL06148 1
- H8FL15107 1
- H8FL15230 1
- H8FL16022 1
- H8FL17053 1
- H8FL20032 1
- H8FL22038 1
- H8FL24026 1
- H8FL25015 1
- H8FL26039 1
- H8FL27185 1
- H8FL27193 1
- H8GA06146 1
- H8GA06195 1
- H8GA06286 1
- H8GA06393 1
- H8GA07201 1
- H8GA10049 1
- H8GU01020 1
- H8IA01094 1
- H8IA02043 1
- H8IA03124 1
- H8ID01090 1
- H8ID01124 1
- H8ID02064 1
- H8IL03102 1
- H8IL04134 1
- H8IL06139 1
- H8IL09067 1
- H8IL11113 1
- H8IL13051 1
- H8IL13069 1
- H8IL14067 1
- H8IL14174 1
- H8IL18043 1
- H8IL21021 1
- H8IN02060 1
- H8IN04199 1
- H8IN06129 1
- H8IN07184 1
- H8IN09032 1
- H8KS02090 1
- H8KS02199 1
- H8KS03049 1
- H8KS03155 1
- H8KS04112 1
- H8KY02031 1
- H8LA00017 1
- H8LA02054 1
- H8LA02112 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
- H8MO01143 1
- H8MO09153 1
- H8MP00041 1
- H8MS01061 1
- H8MS03067 1
- H8MS03125 1
- H8MS05047 1
- H8MT01182 1
- H8NC07044 1
- H8NC08042 1
- H8NC13067 1
- H8ND00096 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
- H8NY22151 1
- H8NY23084 1
- H8NY24066 1
- H8NY25105 1
- H8NY26095 1
- H8NY27036 1
- H8NY27077 1
- H8NY29032 1
- H8OH01043 1
- H8OH01068 1
- H8OH05036 1
- H8OH05044 1
- H8OH07065 1
- H8OH11067 1
- H8OH11141 1
- H8OH12180 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
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
D000230 | Edward De Nivernais | D000230 | 403318 | Edward | De Nivernais | M | 12117 | James | |||||||||||||||||||||
G000594 | Ernest Gonzales | G000594 | 456849 | kg:/g/11fs52clcr | Ernest | Gonzales | 1980-10-10 | M | Anthony | Tony | Tony Gonzales | N00044592 | [ "H0TX35015" ] |
||||||||||||||||
S000126 | Andrew Schiffler | S000126 | 409634 | 8263 | A. C. Schiffler | Q278598 | kg:/m/02z9_kt | Andrew | Schiffler | 1889-08-10 | M | 21294 | Charles | ||||||||||||||||
M000016 | Anton Maciejewski | M000016 | 407045 | 5881 | A. F. Maciejewski | Q4647757 | kg:/m/02rk8rf | Anton | Maciejewski | 1893-01-03 | M | 17347 | Frank | ||||||||||||||||
M000893 | Arthur Moore | M000893 | 407865 | 6627 | A. Harry Moore | Q278701 | kg:/m/028__4 | Arthur | Moore | 1877-07-03 | M | Harry | |||||||||||||||||
M000554 | Atkins McLemore | M000554 | 407546 | 6342 | A. Jeff McLemore | Q278833 | kg:/m/02x6wgk | Atkins | McLemore | 1857-03-13 | M | 18019 | Jefferson | ||||||||||||||||
F000296 | A. Foster | F000296 | 412038 | 3298 | A. Lawrence Foster | Q4648096 | kg:/m/02rt345 | A. | Foster | 1802-09-17 | M | 13345 | Lawrence | ||||||||||||||||
A000114 | Asa Allen | A000114 | 400771 | 100 | A. Leonard Allen | Q278928 | kg:/m/0ds8jw | Asa | Allen | 1891-01-05 | M | 8419 | Leonard | ||||||||||||||||
P000035 | Alexander Palmer | P000035 | 408445 | 7172 | A. Mitchell Palmer | Q1354363 | kg:/m/02l09f | Alexander | Palmer | 1872-05-04 | M | 19322 | Mitchell | ||||||||||||||||
A000240 | Abram Andrew | A000240 | 400869 | 189 | A. Piatt Andrew | Q331023 | kg:/m/0b7sbq | Abram | Andrew | 1873-02-12 | M | 8599 | Piatt | Jr. | |||||||||||||||
C000162 | Albert Carnahan | C000162 | 402310 | 1517 | A. S. J. Carnahan | Q279153 | kg:/m/03ycb1 | Albert | Carnahan | 1897-01-09 | M | 10657 | Sidney Johnson | ||||||||||||||||
S000490 | Andrew Sloan | S000490 | 409978 | 8578 | A. Scott Sloan | Q279174 | kg:/m/02vrqsf | Andrew | Sloan | 1820-06-12 | M | 21750 | Scott | ||||||||||||||||
D000410 | Alvin Donahey | D000410 | 403523 | 2652 | A. Victor Donahey | Q279193 | kg:/m/033tsr | Alvin | Donahey | 1873-07-07 | M | Victor | |||||||||||||||||
N000133 | Albin Norblad | N000133 | 408217 | 6955 | A. Walter Norblad | Q2545675 | kg:/m/0273644 | Albin | Norblad | 1908-09-12 | M | 18996 | Walter | Jr. | |||||||||||||||
S000065 | Aaron Sargent | S000065 | 409577 | 8218 | Aaron A. Sargent | Q301711 | kg:/m/03lh1d | Aaron | Sargent | 1827-09-28 | M | 21214 | Augustus | ||||||||||||||||
B001133 | Aaron Burr | B001133 | 402077 | 1302 | Aaron Burr | Q179090 | kg:/m/0fsc6 | Aaron | Burr | 1756-02-06 | M | ||||||||||||||||||
P000241 | Aaron Perry | P000241 | 408644 | 7354 | Aaron F. Perry | Q301993 | kg:/m/02rlzkr | Aaron | Perry | 1815-01-01 | M | 19577 | Fyfe | ||||||||||||||||
S000875 | Aaron Stevens | S000875 | 410337 | 8905 | Aaron Fletcher Stevens | Q302017 | kg:/m/09c8g7 | Aaron | Stevens | 1819-08-09 | M | 22221 | Fletcher | ||||||||||||||||
C000852 | Aaron Cragin | C000852 | 402968 | 2129 | Aaron H. Cragin | Q302075 | kg:/m/0d4hfb | Aaron | Cragin | 1821-02-03 | M | 11523 | Harrison | ||||||||||||||||
H000006 | Aaron Hackley | H000006 | 404891 | 3896 | Aaron Hackley Jr. | Q3661160 | kg:/m/02rkln0 | Aaron | Hackley | 1783-05-06 | M | 14297 | Jr. | ||||||||||||||||
H000187 | Aaron Harding | H000187 | 405068 | 4055 | Aaron Harding | Q302082 | kg:/m/02q7p8q | Aaron | Harding | 1805-02-20 | M | 14517 | |||||||||||||||||
H000207 | Aaron Harlan | H000207 | 405086 | 4073 | Aaron Harlan | Q4662074 | kg:/m/02rlzl2 | Aaron | Harlan | 1802-09-08 | M | 14543 | |||||||||||||||||
H000659 | Aaron Hobart | H000659 | 405514 | 4467 | Aaron Hobart | Q302095 | kg:/m/02rgtxz | Aaron | Hobart | 1787-06-26 | M | 15100 | |||||||||||||||||
K000246 | Aaron Kitchell | K000246 | 406405 | 5303 | Aaron Kitchell | Q302196 | kg:/m/08z7gq | Aaron | Kitchell | 1744-07-10 | M | 16384 | |||||||||||||||||
F000258 | Aaron Ford | F000258 | 404210 | 3266 | Aaron L. Ford | Q201057 | kg:/m/02rtn5c | Aaron | Ford | 1903-12-21 | M | 13298 | Lane | ||||||||||||||||
L000524 | Aaron Lyle | L000524 | 407008 | 5846 | Aaron Lyle | Q4662225 | kg:/m/027gb9y | Aaron | Lyle | 1759-11-17 | M | 17248 | |||||||||||||||||
M000247 | Aaron Matson | M000247 | 407265 | 6080 | Aaron Matson | Q180092 | kg:/m/027y1nk | Aaron | Matson | M | 17628 | ||||||||||||||||||
O000041 | Aaron Ogden | O000041 | 408324 | 7029 | Aaron Ogden | Q302436 | kg:/m/070cr1 | Aaron | Ogden | 1756-12-03 | M | ||||||||||||||||||
S001179 | Aaron Schock | S001179 | 412314 | 20914 | Aaron Schock | Q302659 | kg:/m/0h6xzk | Aaron | Schock | 1981-05-28 | M | 22614 | Aaron Schock | 01920 | 1030003 | 33428 | Aaron Schock | N00029273 | [ "H8IL18043" ] |
796 | |||||||||
S000301 | Aaron Shaw | S000301 | 409800 | 8413 | Aaron Shaw (representative) | Q4662425 | kg:/m/03c2z9q | Aaron | Shaw | 1811-12-19 | M | 21509 | |||||||||||||||||
K000327 | Aaron Kreider | K000327 | 406481 | 5366 | Aaron Shenk Kreider | Q4662428 | kg:/m/0fykvt | Aaron | Kreider | 1863-06-26 | M | 16493 | Shenk | ||||||||||||||||
B000557 | Aaron Bliss | B000557 | 401531 | 794 | Aaron T. Bliss | Q302844 | kg:/m/03n_76 | Aaron | Bliss | 1837-05-22 | M | 9496 | Thomas | ||||||||||||||||
B000899 | Aaron Brown | B000899 | 401856 | 1094 | Aaron V. Brown | Q302874 | kg:/m/03jr0m | Aaron | Brown | 1795-08-15 | M | 9943 | Venable | ||||||||||||||||
C000568 | Aaron Cochrane | C000568 | 402697 | 1884 | Aaron Van Schaick Cochrane | Q4662500 | kg:/m/02rklpd | Aaron | Cochrane | 1858-03-14 | M | 11161 | Van Schaick | ||||||||||||||||
V000028 | Aaron Vanderpoel | V000028 | 411122 | 9605 | Aaron Vanderpoel | Q1383031 | kg:/m/02rklnq | Aaron | Vanderpoel | 1799-02-05 | M | 20912 | |||||||||||||||||
W000125 | Aaron Ward | W000125 | 411300 | 9806 | Aaron Ward (representative) | Q612451 | kg:/m/03cmws_ | Aaron | Ward | 1790-07-05 | M | 23362 | |||||||||||||||||
L000130 | Abbott Lawrence | L000130 | 406635 | 5507 | Abbott Lawrence | Q306762 | kg:/m/03drrz | Abbott | Lawrence | 1792-12-16 | M | 16760 | |||||||||||||||||
F000467 | Abby Finkenauer | F000467 | 412771 | 21918 | Abby Finkenauer | Q24435337 | kg:/g/11cmg58r7d | Abby | Finkenauer | 1988-12-27 | F | Abby Finkenauer | 151127 | Abby Finkenauer | N00040888 | [ "H8IA01094" ] |
|||||||||||||
G000253 | Abe Goff | G000253 | 404615 | 3644 | Abe Goff | Q318147 | kg:/m/07l8b0 | Abe | Goff | 1899-12-21 | M | 13882 | McGregor | ||||||||||||||||
W000461 | Abel Wilder | W000461 | 411618 | 10106 | Abel Carter Wilder | Q318396 | kg:/m/02rmb85 | Abel | Wilder | 1828-03-18 | M | 23766 | Carter | ||||||||||||||||
H000994 | Abel Huntington | H000994 | 405834 | 4765 | Abel Huntington | Q74349 | kg:/m/02rklpr | Abel | Huntington | 1777-02-21 | M | 15506 | |||||||||||||||||
F000297 | Abiel Foster | F000297 | 404246 | 3299 | Abiel Foster | Q320910 | kg:/m/03_fmd | Abiel | Foster | 1735-08-08 | M | 13346 | |||||||||||||||||
W000687 | Abiel Wood | W000687 | 411839 | 10317 | Abiel Wood | Q320912 | kg:/m/02rgty9 | Abiel | Wood | 1772-07-22 | M | 24035 | |||||||||||||||||
S001209 | Abigail Spanberger | S001209 | 412833 | 21966 | Abigail Spanberger | Q55603085 | kg:/g/11fgm1ffs7 | Abigail | Spanberger | 1979-08-07 | F | Davis | Abigail Spanberger | 179682 | Abigail Davis Spanberger | N00041418 | [ "H8VA07094" ] |
||||||||||||
B000453 | Abijah Bigelow | B000453 | 401438 | 703 | Abijah Bigelow | Q321172 | kg:/m/02rgtyn | Abijah | Bigelow | 1775-12-05 | M | 9360 | |||||||||||||||||
G000171 | Abijah Gilbert | G000171 | 404538 | 3571 | Abijah Gilbert | Q321179 | kg:/m/08yywv | Abijah | Gilbert | 1806-06-18 | M | ||||||||||||||||||
M000099 | Abijah Mann | M000099 | 407123 | 5955 | Abijah Mann Jr. | Q3388776 | kg:/m/02rklqf | Abijah | Mann | 1793-09-24 | M | 17453 | Jr. | ||||||||||||||||
H000188 | Abner Harding | H000188 | 405069 | 4056 | Abner C. Harding | Q4668116 | kg:/m/02rk8rs | Abner | Harding | 1807-02-10 | M | 14518 | Clark | ||||||||||||||||
H000416 | Abner Hazeltine | H000416 | 405282 | 4254 | Abner Hazeltine | Q4668137 | kg:/m/02rklqs | Abner | Hazeltine | 1793-06-10 | M | 14794 | |||||||||||||||||
L000011 | Abner Lacock | L000011 | 406521 | 5392 | Abner Lacock | Q322539 | kg:/m/08pllp | Abner | Lacock | 1770-07-09 | M | 16588 | |||||||||||||||||
L000270 | Abner Lewis | L000270 | 412063 | 5629 | Abner Lewis | Q4668144 | kg:/m/02rklr3 | Abner | Lewis | 1801-08-17 | M | 16927 | |||||||||||||||||
M000703 | Abner Mikva | M000703 | 407686 | 12025 | Abner Mikva | Q4320649 | kg:/m/04lmgt | Abner | Mikva | 1926-01-21 | M | 18209 | Joseph | 00803 | |||||||||||||||
T000062 | Abner Taylor | T000062 | 410648 | 9196 | Abner Taylor | Q4250429 | kg:/m/02rk8s3 | Abner | Taylor | M | 22711 | ||||||||||||||||||
S000395 | Abner Sibal | S000395 | 409889 | 10560 | Abner W. Sibal | Q322548 | kg:/m/02rgty_ | Abner | Sibal | 1921-04-11 | M | 21630 | Woodruff | ||||||||||||||||
B000142 | Abraham Barker | B000142 | 401143 | 434 | Abraham Andrews Barker | Q4668747 | kg:/m/0kt9m3 | Abraham | Barker | 1816-03-30 | M | 8954 | Andrews | ||||||||||||||||
V000083 | Abraham Venable | V000083 | 411139 | 9658 | Abraham B. Venable | Q329740 | kg:/m/08hxzf | Abraham | Venable | 1758-11-20 | M | 20975 | Bedford | ||||||||||||||||
B000084 | Abraham Baldwin | B000084 | 401086 | 379 | Abraham Baldwin | Q329766 | kg:/m/02myz5 | Abraham | Baldwin | 1754-11-22 | M | 8884 | |||||||||||||||||
B000581 | Abraham Bockee | B000581 | 401552 | 814 | Abraham Bockee | Q774493 | kg:/m/02rklrg | Abraham | Bockee | 1784-02-03 | M | 9528 | |||||||||||||||||
H000312 | Abraham Hasbrouck | H000312 | 405185 | 4167 | Abraham Bruyn Hasbrouck | Q1108127 | kg:/m/05lmhf | Abraham | Hasbrouck | 1791-11-29 | M | 14669 | Bruyn | ||||||||||||||||
C000418 | Abraham Clark | C000418 | 402557 | 1750 | Abraham Clark | Q329870 | kg:/m/01mpsy | Abraham | Clark | 1726-02-15 | M | 10975 | |||||||||||||||||
D000465 | Abraham Dowdney | D000465 | 403575 | 2699 | Abraham Dowdney | Q2377496 | kg:/m/08l3ky | Abraham | Dowdney | 1841-10-31 | M | 12414 | |||||||||||||||||
G000079 | Abraham Garrett | G000079 | 404451 | 3487 | Abraham Ellison Garrett | Q329956 | kg:/m/090c90 | Abraham | Garrett | 1830-03-06 | M | 13660 | Ellison | ||||||||||||||||
S000115 | Abraham Schenck | S000115 | 409623 | 8256 | Abraham H. Schenck | Q501769 | kg:/m/02rkls4 | Abraham | Schenck | 1775-01-22 | M | 21278 | Henry | ||||||||||||||||
S000509 | Abraham Smith | S000509 | 409995 | 8597 | Abraham Herr Smith | Q4668901 | kg:/m/0kt1lb | Abraham | Smith | 1815-03-07 | M | 21772 | Herr | ||||||||||||||||
H000313 | Abraham Hasbrouck | H000313 | 405186 | 4168 | Abraham J. Hasbrouck | Q1107855 | kg:/m/026tb2_ | Abraham | Hasbrouck | 1773-10-16 | M | 14670 | Joseph | ||||||||||||||||
H000805 | Abraham Hostetler | H000805 | 405654 | 4595 | Abraham J. Hostetler | Q330092 | kg:/m/02rkdqm | Abraham | Hostetler | 1818-11-22 | M | 15278 | Jonathan | Abram | |||||||||||||||
M001074 | Abraham Multer | M001074 | 408040 | 6792 | Abraham J. Multer | Q2633194 | kg:/m/0kswjz | Abraham | Multer | 1900-12-24 | M | 18670 | Jacob | ||||||||||||||||
K000025 | Abraham Kazen | K000025 | 406196 | 11023 | Abraham Kazen | Q330149 | kg:/m/027jcfb | Abraham | Kazen | 1919-01-17 | M | 16107 | Jr. | 00621 | |||||||||||||||
B000819 | Abraham Brick | B000819 | 401776 | 1023 | Abraham L. Brick | Q330197 | kg:/m/02rkdqz | Abraham | Brick | 1860-05-27 | M | 9841 | Lincoln | ||||||||||||||||
L000313 | Abraham Lincoln | L000313 | 406807 | 5666 | Abraham Lincoln | Q91 | kg:/m/0gzh | Abraham | Lincoln | 1809-02-12 | M | 16982 | |||||||||||||||||
K000052 | Abraham Keister | K000052 | 406222 | 5130 | Abraham Lincoln Keister | Q4669034 | kg:/m/0fzh5k | Abraham | Keister | 1852-09-10 | M | 16145 | Lincoln | ||||||||||||||||
S000122 | Abraham Schermerhorn | S000122 | 409630 | 8261 | Abraham M. Schermerhorn | Q4669068 | kg:/m/026_4f8 | Abraham | Schermerhorn | 1791-12-11 | M | 21287 | Maus | ||||||||||||||||
M000328 | Abraham McClellan | M000328 | 407338 | 6147 | Abraham McClellan (Tennessee politician) | Q330322 | kg:/m/0cglq4 | Abraham | McClellan | 1789-10-04 | M | 17732 | |||||||||||||||||
N000161 | Abraham Nott | N000161 | 408242 | 6979 | Abraham Nott | Q330433 | kg:/m/0265r27 | Abraham | Nott | 1768-02-05 | M | 19034 | |||||||||||||||||
G000380 | Abraham Grant | G000380 | 404731 | 3753 | Abraham P. Grant | Q3700962 | kg:/m/02rklsv | Abraham | Grant | 1804-04-05 | M | 14042 | Phineas | ||||||||||||||||
S000853 | Abraham Stephens | S000853 | 410316 | 8884 | Abraham P. Stephens | Q1156097 | kg:/m/02rkltj | Abraham | Stephens | 1796-02-18 | M | 22193 | P. | ||||||||||||||||
R000162 | Abraham Rencher | R000162 | 409139 | 7822 | Abraham Rencher | Q330537 | kg:/m/0b6zk9 | Abraham | Rencher | 1798-08-12 | M | 20285 | |||||||||||||||||
R000191 | Abraham Ribicoff | R000191 | 409167 | 7847 | Abraham Ribicoff | Q323417 | kg:/m/03gsnd | Abraham | Ribicoff | 1910-04-09 | M | 20323 | Alexander | 01422 | |||||||||||||||
M000474 | Abraham McIlvaine | M000474 | 407472 | 6273 | Abraham Robinson McIlvaine | Q4669151 | kg:/m/026f71v | Abraham | McIlvaine | 1804-08-14 | M | 17918 | Robinson | ||||||||||||||||
V000030 | Abraham Vanderveer | V000030 | 411123 | 9606 | Abraham Vanderveer | Q194717 | kg:/m/02rkltw | Abraham | Vanderveer | M | 20914 | ||||||||||||||||||
V000084 | Abraham Venable | V000084 | 411140 | 9659 | Abraham Watkins Venable | Q330690 | kg:/m/05kyds | Abraham | Venable | 1799-10-17 | M | 20976 | Watkins | ||||||||||||||||
P000053 | Abraham Parker | P000053 | 408463 | 7187 | Abraham X. Parker | Q4669238 | kg:/m/02rklvk | Abraham | Parker | 1831-11-14 | M | 19342 | X. | ||||||||||||||||
O000066 | Abram Olin | O000066 | 408339 | 7054 | Abram B. Olin | Q2592932 | kg:/m/02rklvx | Abram | Olin | 1808-09-21 | M | 19149 | Baldwin | ||||||||||||||||
C000658 | Abram Comingo | C000658 | 402785 | 1963 | Abram Comingo | Q331035 | kg:/m/02rxdnn | Abram | Comingo | 1820-01-09 | M | 11278 | |||||||||||||||||
F000402 | Abram Fulkerson | F000402 | 404344 | 3389 | Abram Fulkerson | Q331044 | kg:/m/0kt6qw | Abram | Fulkerson | 1834-05-13 | M | 13478 | |||||||||||||||||
H000552 | Abram Hewitt | H000552 | 405414 | 4375 | Abram Hewitt | Q2738550 | kg:/m/05c71d | Abram | Hewitt | 1822-07-31 | M | 14968 | Stevens | ||||||||||||||||
M000262 | Abram Maury | M000262 | 407280 | 6091 | Abram Poindexter Maury | Q331072 | kg:/m/0cglns | Abram | Maury | 1801-12-26 | M | 17646 | Poindexter | ||||||||||||||||
T000368 | Abram Trigg | T000368 | 410937 | 9468 | Abram Trigg | Q331081 | kg:/m/0fpml8 | Abram | Trigg | M | 23085 | ||||||||||||||||||
W000027 | Abram Wakeman | W000027 | 411206 | 9719 | Abram Wakeman | Q1383679 | kg:/m/02rklwy | Abram | Wakeman | 1824-05-31 | M | 23250 | |||||||||||||||||
W000486 | Abram Williams | W000486 | 411643 | 10131 | Abram Williams | Q331073 | kg:/m/03sg_0 | Abram | Williams | 1832-02-03 | M | Pease | |||||||||||||||||
C000319 | Absalom Chappell | C000319 | 402461 | 1661 | Absalom Harris Chappell | Q331703 | kg:/m/0gj6s7 | Absalom | Chappell | 1801-12-18 | M | Harris | |||||||||||||||||
T000050 | Absalom Tatom | T000050 | 410638 | 9187 | Absalom Tatom | Q331709 | kg:/m/04f9c4 | Absalom | Tatom | M | 22695 | ||||||||||||||||||
R000317 | Absalom Robertson | R000317 | 409288 | 7958 | Absalom Willis Robertson | Q331714 | kg:/m/03zxp3 | Absalom | Robertson | 1887-05-27 | M | 20478 | Willis | ||||||||||||||||
B000363 | Adam Benjamin | B000363 | 401355 | 14406 | Adam Benjamin Jr. | Q348740 | kg:/m/09jxd5 | Adam | Benjamin | 1935-08-06 | M | 9248 | Jr. | 00076 | |||||||||||||||
B000714 | Adam Boyd | B000714 | 401675 | 927 | Adam Boyd (politician) | Q224848 | kg:/m/0262rt9 | Adam | Boyd | 1746-03-21 | M | 9708 | |||||||||||||||||
L000358 | Adam Littlepage | L000358 | 406850 | 5708 | Adam Brown Littlepage | Q348905 | kg:/m/03c280c | Adam | Littlepage | 1859-04-14 | M | 17040 | Brown | ||||||||||||||||
P000477 | Adam Powell | P000477 | 408862 | 7568 | Adam Clayton Powell Jr. | Q1050018 | kg:/m/022xn8 | Adam | Powell | 1908-11-29 | M | 19872 | Clayton | Jr. | |||||||||||||||
H001000 | Adam Huntsman | H001000 | 405840 | 4771 | Adam Huntsman | Q349808 | kg:/m/0cglpg | Adam | Huntsman | 1786-02-11 | M | 15515 | |||||||||||||||||
G000242 | Adam Glossbrenner | G000242 | 404604 | 3633 | Adam John Glossbrenner | Q4679302 | kg:/m/0kt7g6 | Adam | Glossbrenner | 1810-08-31 | M | 13869 | John | ||||||||||||||||
K000192 | Adam King | K000192 | 406353 | 5252 | Adam King (congressman) | Q4679346 | kg:/m/026y992 | Adam | King | 1783-01-20 | M | 16318 |
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);