legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id_icpsr
This data as json, copyable, CSV (advanced)
Suggested facets: bio_gender, name_nickname, name_suffix, name_official_full, bio_birthday (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
W000377 | James White | W000377 | 411538 | James White (North Carolina politician) | Q532708 | kg:/m/06t1db | James | White | 1749-06-16 | M | 23662 | ||||||||||||||||||
M000571 | William McMillan | M000571 | 407563 | William McMillan (congressman) | Q2579966 | kg:/m/0czh9d | William | McMillan | 1764-03-02 | M | 18038 | ||||||||||||||||||
F000054 | Paul Fearing | F000054 | 404014 | Paul Fearing | Q1278451 | kg:/m/0czh91 | Paul | Fearing | 1762-02-28 | M | 13033 | ||||||||||||||||||
G000428 | Thomas Greene | G000428 | 404776 | Thomas M. Green Jr. | Q2425959 | kg:/m/04gqgf0 | Thomas | Greene | 1758-02-26 | M | 14108 | Marston | |||||||||||||||||
H000986 | Narsworthy Hunter | H000986 | 412054 | Narsworthy Hunter | Q1965415 | kg:/m/02z2l7v | Narsworthy | Hunter | M | 15497 | |||||||||||||||||||
C000426 | Daniel Clark | C000426 | 412141 | Daniel Clark (Louisiana politician) | Q1160345 | kg:/m/01t003 | Daniel | Clark | M | 10985 | |||||||||||||||||||
P000052 | Benjamin Parke | P000052 | 408462 | Benjamin Parke | Q817644 | kg:/m/09tr42 | Benjamin | Parke | 1777-09-22 | M | 19341 | ||||||||||||||||||
D000240 | William Denning | D000240 | 403378 | William Denning | Q82219 | kg:/m/026nzyl | William | Denning | M | 12128 | |||||||||||||||||||
P000493 | Julien Poydras | P000493 | 408878 | Julien de Lallande Poydras | Q1712278 | kg:/m/01t00g | Julien | Poydras | 1740-04-03 | M | 19890 | de Lallande | |||||||||||||||||
D000273 | Jean Destréhan | D000273 | 403408 | Jean Noël Destréhan | Q435963 | kg:/m/0b079s | Jean | Destréhan | M | Noel | |||||||||||||||||||
B000612 | Shadrack Bond | B000612 | 401579 | Shadrach Bond | Q734759 | kg:/m/0507rx | Shadrack | Bond | 1773-11-24 | M | 9572 | ||||||||||||||||||
H000472 | Edward Hempstead | H000472 | 405335 | Edward Hempstead | Q1292504 | kg:/m/04wsn_ | Edward | Hempstead | 1780-06-03 | M | 14867 | ||||||||||||||||||
L000387 | Francis Locke | L000387 | 406879 | Francis Locke Jr. | Q269495 | kg:/m/02kl4c | Francis | Locke | 1776-10-31 | M | |||||||||||||||||||
E000022 | Rufus Easton | E000022 | 403718 | Rufus Easton | Q1300347 | kg:/m/02rz83p | Rufus | Easton | 1774-05-04 | M | 12628 | ||||||||||||||||||
L000118 | William Lattimore | L000118 | 406624 | William Lattimore | Q2579673 | kg:/m/02z2l7h | William | Lattimore | 1774-02-09 | M | 16744 | ||||||||||||||||||
S000862 | Benjamin Stephenson | S000862 | 412106 | Benjamin Stephenson (politician) | Q817696 | kg:/m/09jn0g | Benjamin | Stephenson | M | 22205 | |||||||||||||||||||
W000523 | Jonathan Williams | W000523 | 411680 | Jonathan Williams (engineer) | Q6274789 | kg:/m/0631j1 | Jonathan | Williams | 1750-05-20 | M | 23837 | ||||||||||||||||||
P000432 | Nathaniel Pope | P000432 | 408823 | Nathaniel Pope | Q4098442 | kg:/m/04xhcd | Nathaniel | Pope | 1784-01-05 | M | 19818 | ||||||||||||||||||
B000235 | James Bates | B000235 | 401230 | James Woodson Bates | Q692671 | kg:/m/0723j9 | James | Bates | 1788-08-25 | M | 9079 | Woodson | |||||||||||||||||
B001054 | Wingfield Bullock | B001054 | 412021 | Wingfield Bullock | Q2584413 | kg:/m/02rk0jg | Wingfield | Bullock | M | 10133 | |||||||||||||||||||
D000531 | James Duncan | D000531 | 403639 | James Duncan (Pennsylvania politician) | Q6132921 | kg:/m/027gwqz | James | Duncan | M | 12490 | |||||||||||||||||||
H000533 | Joseph Hernández | H000533 | 405395 | Joseph Marion Hernández | Q1707585 | kg:/m/086b__ | Joseph | Hernández | 1788-05-26 | M | 14946 | Marion | |||||||||||||||||
S000400 | Solomon Sibley | S000400 | 409894 | Solomon Sibley | Q991360 | kg:/m/03pksm | Solomon | Sibley | 1769-10-07 | M | 21635 | ||||||||||||||||||
T000438 | Selah Tuthill | T000438 | 411006 | Selah Tuthill | Q82465 | kg:/m/02rkwdy | Selah | Tuthill | 1771-10-26 | M | 23172 | ||||||||||||||||||
C000050 | Richard Call | C000050 | 402210 | Richard K. Call | Q885835 | kg:/m/04bk4q | Richard | Call | 1792-10-24 | M | 10503 | Keith | |||||||||||||||||
R000210 | Gabriel Richard | R000210 | 409186 | Gabriel Richard | Q1489605 | kg:/m/08p9zy | Gabriel | Richard | 1767-10-15 | M | 20343 | ||||||||||||||||||
C000712 | Henry Conway | C000712 | 402836 | Henry Wharton Conway | Q1607403 | kg:/m/01smrm | Henry | Conway | 1793-03-18 | M | 11345 | Wharton | |||||||||||||||||
E000237 | David Evans | E000237 | 403921 | David Ellicott Evans | Q5233341 | kg:/m/03cg7p_ | David | Evans | 1788-03-19 | M | 12893 | Ellicott | |||||||||||||||||
B000441 | John Biddle | B000441 | 401427 | John Biddle (Michigan politician) | Q665672 | kg:/m/0czw9w | John | Biddle | 1792-03-02 | M | 9346 | ||||||||||||||||||
W000631 | Austin Wing | W000631 | 411785 | Austin Eli Wing | Q781074 | kg:/m/026vz6l | Austin | Wing | 1792-02-03 | M | 23965 | Eli | |||||||||||||||||
S000446 | Thomas Singleton | S000446 | 412096 | Thomas D. Singleton | Q2423319 | kg:/m/02w14gt | Thomas | Singleton | M | 21694 | Day | ||||||||||||||||||
S000049 | John Sanford | S000049 | 409565 | John W. A. Sanford | Q1674403 | kg:/m/0279xfg | John | Sanford | 1798-08-28 | M | 21192 | W.A. | |||||||||||||||||
T000130 | James Terrell | T000130 | 410712 | James C. Terrell | Q1471732 | kg:/m/0279xjk | James | Terrell | 1806-11-07 | M | 22791 | C. | |||||||||||||||||
W000383 | Joseph White | W000383 | 411543 | Joseph M. White | Q1355238 | kg:/m/0b1pzj | Joseph | White | 1781-05-10 | M | 23669 | M. | |||||||||||||||||
C000318 | William Chapman | C000318 | 402460 | William W. Chapman | Q1415304 | kg:/m/02z4p8r | William | Chapman | 1808-08-11 | M | 10853 | Williams | |||||||||||||||||
D000472 | Charles Downing | D000472 | 412035 | Charles Downing | Q1064151 | kg:/m/0b1q2r | Charles | Downing | M | 12422 | |||||||||||||||||||
L000029 | John Lamar | L000029 | 406539 | John Basil Lamar | Q1699283 | kg:/m/0271652 | John | Lamar | 1812-11-05 | M | 16611 | Basil | |||||||||||||||||
M000196 | Morgan Martin | M000196 | 407216 | Morgan Lewis Martin | Q1947648 | kg:/m/0b6tmf | Morgan | Martin | 1805-03-31 | M | 17564 | Lewis | |||||||||||||||||
T000441 | John Tweedy | T000441 | 411009 | John Hubbard Tweedy | Q1700519 | kg:/m/0b6tnv | John | Tweedy | 1814-11-09 | M | 23175 | Hubbard | |||||||||||||||||
T000258 | Samuel Thurston | T000258 | 410833 | Samuel Thurston | Q2218900 | kg:/m/03bcbl | Samuel | Thurston | 1816-04-15 | M | 22947 | Royal | |||||||||||||||||
S000396 | Henry Sibley | S000396 | 409890 | Henry Hastings Sibley | Q880319 | kg:/m/01l6xh | Henry | Sibley | 1811-02-20 | M | 21631 | Hastings | |||||||||||||||||
W000255 | Richard Weightman | W000255 | 411423 | Richard Hanson Weightman | Q2149708 | kg:/m/02rjy9_ | Richard | Weightman | 1816-12-28 | M | 23522 | Hanson | |||||||||||||||||
G000168 | Napoleon Giddings | G000168 | 404535 | Napoleon Bonaparte Giddings | Q1964936 | kg:/m/02z38m2 | Napoleon | Giddings | 1816-01-02 | M | 13777 | Bonaparte | |||||||||||||||||
L000044 | Columbia Lancaster | L000044 | 406553 | Columbia Lancaster | Q1112496 | kg:/m/02rhdvg | Columbia | Lancaster | 1803-08-26 | M | 16637 | ||||||||||||||||||
A000192 | James Anderson | A000192 | 400847 | James Patton Anderson | Q1680958 | kg:/m/0gkv2p | James | Anderson | 1822-02-16 | M | 8522 | Patton | |||||||||||||||||
C000309 | Bird Chapman | C000309 | 402451 | Bird Beers Chapman | Q865044 | kg:/m/02z38n3 | Bird | Chapman | 1821-08-24 | M | 10842 | Beers | |||||||||||||||||
W000414 | John Whitfield | W000414 | 411573 | John Wilkins Whitfield | Q1702157 | kg:/m/0g2jgz | John | Whitfield | 1818-03-11 | M | 23705 | Wilkins | |||||||||||||||||
F000080 | Fenner Ferguson | F000080 | 404038 | Fenner Ferguson | Q1404772 | kg:/m/02z38p4 | Fenner | Ferguson | 1814-04-25 | M | 13068 | ||||||||||||||||||
K000219 | William Kingsbury | K000219 | 406379 | William W. Kingsbury | Q1552171 | kg:/m/0h18nn | William | Kingsbury | 1828-06-04 | M | 16352 | Wallace | |||||||||||||||||
E000220 | Experience Estabrook | E000220 | 403906 | Experience Estabrook | Q1384347 | kg:/m/02z38ph | Experience | Estabrook | 1813-04-30 | M | 12874 | ||||||||||||||||||
O000125 | Miguel Otero | O000125 | 408378 | Miguel Antonio Otero (born 1829) | Q1932568 | kg:/m/05yd_7 | Miguel | Otero | 1829-06-21 | M | 19218 | Antonio | |||||||||||||||||
P000085 | Marcus Parrott | P000085 | 408495 | Marcus Junius Parrott | Q1894216 | kg:/m/0g2jvq | Marcus | Parrott | 1828-10-27 | M | 19377 | Junius | |||||||||||||||||
S000881 | Isaac Stevens | S000881 | 410343 | Isaac Stevens | Q888719 | kg:/m/029n3n | Isaac | Stevens | 1818-03-25 | M | 22228 | Ingalls | |||||||||||||||||
B000412 | John Bernhisel | B000412 | 401399 | John Milton Bernhisel | Q446929 | kg:/m/0cszkx | John | Bernhisel | 1799-07-23 | M | 9311 | Milton | |||||||||||||||||
C000850 | John Cradlebaugh | C000850 | 402966 | John Cradlebaugh | Q989852 | kg:/m/0265pjz | John | Cradlebaugh | 1819-02-22 | M | 11519 | ||||||||||||||||||
W000213 | John Watts | W000213 | 411382 | John Sebrie Watts | Q1701708 | kg:/m/02rhkjr | John | Watts | 1816-01-19 | M | 23471 | Sebrie | |||||||||||||||||
B000369 | Hiram Bennet | B000369 | 401361 | Hiram Pitt Bennet | Q1421481 | kg:/m/02rhhm4 | Hiram | Bennet | 1826-09-02 | M | 9254 | Pitt | |||||||||||||||||
C000609 | George Cole | C000609 | 402738 | George Edward Cole | Q125387 | kg:/m/02rhghd | George | Cole | 1826-12-23 | M | 11212 | Edward | |||||||||||||||||
D000006 | Samuel Daily | D000006 | 403150 | Samuel Gordon Daily | Q2218316 | kg:/m/02z38qj | Samuel | Daily | M | 11840 | Gordon | ||||||||||||||||||
J000066 | William Jayne | J000066 | 405971 | William Jayne | Q1576708 | kg:/m/01s_q5 | William | Jayne | 1826-10-08 | M | 15775 | ||||||||||||||||||
K000225 | John Kinney | K000225 | 406384 | John F. Kinney | Q1700016 | kg:/m/02r5f68 | John | Kinney | 1816-04-02 | M | 16360 | Fitch | |||||||||||||||||
M001038 | Gordon Mott | M001038 | 408005 | Gordon Newell Mott | Q268564 | kg:/m/02rhh18 | Gordon | Mott | 1812-10-21 | M | 18626 | Newell | |||||||||||||||||
P000224 | Francisco Perea | P000224 | 408627 | Francisco Perea | Q1384732 | kg:/m/02rhg7h | Francisco | Perea | 1830-01-09 | M | 19555 | ||||||||||||||||||
P000458 | Charles Poston | P000458 | 408845 | Charles Debrille Poston | Q1064080 | kg:/m/02rhd3s | Charles | Poston | 1825-04-20 | M | 19849 | Debrille | |||||||||||||||||
T000292 | John Todd | T000292 | 410865 | John Blair Smith Todd | Q1699347 | kg:/m/09g52m | John | Todd | 1814-04-04 | M | 22988 | Blair Smith | |||||||||||||||||
W000086 | William Wallace | W000086 | 411265 | William H. Wallace | Q889378 | kg:/m/0d3mvd | William | Wallace | 1811-07-19 | M | 23315 | Henson | |||||||||||||||||
D000247 | Arthur Denny | D000247 | 403385 | Arthur A. Denny | Q1595543 | kg:/m/0b82cd | Arthur | Denny | 1822-06-20 | M | 12136 | Armstrong | |||||||||||||||||
M000551 | Samuel McLean | M000551 | 407543 | Samuel McLean (congressman) | Q2218662 | kg:/m/03c9cll | Samuel | McLean | 1826-08-07 | M | 18016 | ||||||||||||||||||
B000219 | Coles Bashford | B000219 | 401216 | Coles Bashford | Q882895 | kg:/m/037vjg | Coles | Bashford | 1816-01-24 | M | 9057 | ||||||||||||||||||
B001108 | Walter Burleigh | B001108 | 402053 | Walter A. Burleigh | Q2543402 | kg:/m/01s_n3 | Walter | Burleigh | 1820-10-25 | M | 10204 | Atwood | |||||||||||||||||
C000517 | Charles Clever | C000517 | 402652 | Charles P. Clever | Q215432 | kg:/m/02rhdf1 | Charles | Clever | 1830-02-23 | M | 11093 | P. | |||||||||||||||||
F000188 | Alvan Flanders | F000188 | 404143 | Alvan Flanders | Q448252 | kg:/m/02rgv4w | Alvan | Flanders | 1825-08-02 | M | 13207 | ||||||||||||||||||
H000710 | Edward Holbrook | H000710 | 405563 | Edward Dexter Holbrook | Q1292048 | kg:/m/02rhflj | Edward | Holbrook | 1836-05-06 | M | 15161 | Dexter | |||||||||||||||||
B000737 | Allen Bradford | B000737 | 401697 | Allen Alexander Bradford | Q1525819 | kg:/m/02rgv3v | Allen | Bradford | 1815-07-23 | M | 9735 | Alexander | |||||||||||||||||
C000337 | José Chaves | C000337 | 402477 | José Francisco Chaves | Q1360890 | kg:/m/02rlcmm | José | Chaves | 1833-06-27 | M | 10873 | Francisco | |||||||||||||||||
N000166 | Stephen Nuckolls | N000166 | 408247 | Stephen Friel Nuckolls | Q2344723 | kg:/m/02rjzgf | Stephen | Nuckolls | 1825-08-16 | M | 19039 | Friel | |||||||||||||||||
S000276 | Jacob Shafer | S000276 | 409775 | Jacob K. Shafer | Q1677538 | kg:/m/02rhj08 | Jacob | Shafer | 1823-12-26 | M | 21478 | K. | |||||||||||||||||
S000736 | Solomon Spink | S000736 | 410205 | Solomon L. Spink | Q477194 | kg:/m/01s_t8 | Solomon | Spink | 1831-03-20 | M | 22047 | Lewis | |||||||||||||||||
C000400 | William Clagett | C000400 | 402539 | William H. Clagett | Q2579039 | kg:/m/02rpk_g | William | Clagett | 1838-09-21 | M | 10953 | Horace | |||||||||||||||||
G000022 | José Gallegos | G000022 | 404398 | José Manuel Gallegos | Q1502564 | kg:/m/02rlcly | José | Gallegos | 1815-10-30 | M | 13591 | Manuel | |||||||||||||||||
G000064 | Selucius Garfielde | G000064 | 404437 | Selucius Garfielde | Q2268730 | kg:/m/02rjz98 | Selucius | Garfielde | 1822-12-08 | M | 13643 | ||||||||||||||||||
H000767 | William Hooper | H000767 | 405617 | William Henry Hooper | Q2579219 | kg:/m/02rj_l6 | William | Hooper | 1813-12-25 | M | 15233 | Henry | |||||||||||||||||
J000261 | William Jones | J000261 | 406153 | William Theopilus Jones | Q2580741 | kg:/m/02rk00n | William | Jones | 1842-02-20 | M | 16023 | Theopilus | |||||||||||||||||
M000662 | Samuel Merritt | M000662 | 407648 | Samuel Augustus Merritt | Q2217949 | kg:/m/02rjz1c | Samuel | Merritt | 1827-08-15 | M | 18150 | Augustus | |||||||||||||||||
A000283 | Moses Armstrong | A000283 | 400923 | Moses K. Armstrong | Q1949162 | kg:/m/01s_jt | Moses | Armstrong | 1832-09-19 | M | 8657 | Kimball | |||||||||||||||||
C000370 | Norton Chipman | C000370 | 402509 | Norton P. Chipman | Q2819666 | kg:/m/01s_tm | Norton | Chipman | 1834-03-07 | M | 10916 | Parker | |||||||||||||||||
M000435 | Obadiah McFadden | M000435 | 407435 | Obadiah B. McFadden | Q2008654 | kg:/m/02r8gn4 | Obadiah | McFadden | 1815-11-18 | M | 17871 | Benton | |||||||||||||||||
B000383 | Thomas Bennett | B000383 | 401374 | Thomas W. Bennett (territorial governor) | Q889361 | kg:/m/0d4c1t | Thomas | Bennett | 1831-02-16 | M | 9273 | Warren | |||||||||||||||||
S000840 | William Steele | S000840 | 410304 | William Randolph Steele | Q1393108 | kg:/m/02rj_yx | William | Steele | 1842-07-24 | M | 22178 | Randolph | |||||||||||||||||
C000777 | William Corlett | C000777 | 402897 | William Wellington Corlett | Q1304958 | kg:/m/02rk06h | William | Corlett | 1842-04-10 | M | 11425 | Wellington | |||||||||||||||||
F000073 | Stephen Fenn | F000073 | 404031 | Stephen Southmyd Fenn | Q2345078 | kg:/m/02rjzjh | Stephen | Fenn | 1820-03-28 | M | 13058 | Southmyd | |||||||||||||||||
J000037 | Orange Jacobs | J000037 | 405942 | Orange Jacobs | Q920857 | kg:/m/02rjxm9 | Orange | Jacobs | 1827-05-02 | M | 15736 | ||||||||||||||||||
K000164 | Jefferson Kidder | K000164 | 406328 | Jefferson P. Kidder | Q1686407 | kg:/m/01s_rk | Jefferson | Kidder | 1815-06-04 | M | 16282 | Parish | |||||||||||||||||
R000416 | Trinidad Romero | R000416 | 409382 | Trinidad Romero | Q2453462 | kg:/m/02rk0dp | Trinidad | Romero | 1835-06-15 | M | 20601 | ||||||||||||||||||
S000880 | Hiram Stevens | S000880 | 410342 | Hiram Sanford Stevens | Q1620134 | kg:/m/02rhhmh | Hiram | Stevens | 1832-03-20 | M | 22227 | Sanford | |||||||||||||||||
B000374 | Granville Bennett | B000374 | 401366 | Granville G. Bennett | Q1543274 | kg:/m/01s_kh | Granville | Bennett | 1833-10-09 | M | 9262 | Gaylord | |||||||||||||||||
C000092 | John Campbell | C000092 | 402247 | John G. Campbell | Q1700145 | kg:/m/02qfh3m | John | Campbell | 1827-06-25 | M | 10559 | Goulder | |||||||||||||||||
D000470 | Stephen Downey | D000470 | 403580 | Stephen Wheeler Downey | Q1802144 | kg:/m/0df_x7 | Stephen | Downey | 1839-07-25 | M | 12420 | Wheeler | |||||||||||||||||
O000124 | Mariano Otero | O000124 | 408377 | Mariano S. Otero | Q1897010 | kg:/m/02rjx56 | Mariano | Otero | 1844-08-29 | M | 19217 | Sabino | |||||||||||||||||
A000066 | George Ainslie | A000066 | 400726 | George Ainslie (delegate) | Q656981 | kg:/m/02w8yjc | George | Ainslie | 1838-10-30 | M | 8348 |
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);