social_media
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
528 rows sorted by instagram
This data as json, copyable, CSV (advanced)
id | legislator_id | youtube_id | twitter_id | youtube | instagram ▼ | instagram_id | ||
---|---|---|---|---|---|---|---|---|
W000821 | Bruce Westerman W000821 | RepWesterman | RepWesterman | UCNshPbmupCwP5a7Hi79jETQ | 2852998461 | |||
W000823 | Michael Waltz W000823 | RepWaltzPress | 1082416697380913152 | |||||
W000825 | Jennifer Wexton W000825 | RepWexton | 1017819745880543238 | |||||
W000826 | Susan Wild W000826 | RepSusanWild | 1069636653353000962 | |||||
Y000062 | John Yarmuth Y000062 | RepJohnYarmuth | 214258646163 | UCy5KW4yrEfEiyZRX45Eoxkg | 384913290 | RepJohnYarmuth | ||
Z000017 | Lee Zeldin Z000017 | RepLeeZeldin | RepLeeZeldin | UCHzZuesCPDka2NhZO8icqzA | 2750127259 | |||
G000578 | Matt Gaetz G000578 | RepMattGaetz | CongressmanMattGaetz | UClqXcJew_A3s8qiX-T4a9CA | 818948638890217473 | Congressman_Matt_Gaetz | ||
A000369 | Mark Amodei A000369 | MarkAmodeiNV2 | MarkAmodeiNV2 | UCjOGx2iqSn1r3BQxaVgYhYw | 402719755 | markamodeinv2 | MarkAmodeiNV2 | |
G000565 | Paul Gosar G000565 | RepGosar | repgosar | UC5orqw_9acsKWSRbrqTDXBw | 240760644 | repgosar | REPGOSAR | |
S001150 | Adam Schiff S001150 | RepAdamSchiff | RepAdamSchiff | UCadiUi-KZoFk1K5ZDsluLcA | 29501253 | adamschiff | RepAdamSchiff | |
S001172 | Adrian Smith S001172 | RepAdrianSmith | UCIgn2z-hwxx_aeggnyhv54Q | 296245061 | RepAdrianSmith | RepAdrianSmith | ||
E000215 | Anna Eshoo E000215 | RepAnnaEshoo | RepAnnaEshoo | UCjRvhco2d59GBgA78IIIaYQ | 249348006 | RepAnnaEshoo | RepAnnaEshoo | |
B001304 | Anthony Brown B001304 | RepAnthonyBrown | RepAnthonyBrown | 823552974253342721 | RepAnthonyBrown | RepAnthonyBrown | ||
B001278 | Suzanne Bonamici B001278 | RepBonamici | congresswomanbonamici | UC0IkAeEiwgzSRTD1TDSvuBw | 558769636 | RepSuzanneBonamici | RepBonamici | |
M001199 | Brian Mast M001199 | RepBrianMast | repbrianmast | 814103950404239360 | repbrianmast | RepBrianMast | ||
H001077 | Clay Higgins H001077 | RepClayHiggins | CongressmanClayHiggins | 843636970538618880 | RepClayHiggins | |||
W000797 | Debbie Wasserman Schultz W000797 | RepDWStweets | RepDWS | UCfHQiJVvMlYbVAxrMSLdO4w | 1140648348 | RepWassermanSchultz | RepDWSTweets | |
S001200 | Darren Soto S001200 | RepDarrenSoto | CongressmanDarrenSoto | 818713465653051392 | repdarrensoto | RepDarrenSoto | ||
S001157 | David Scott S001157 | RepDavidScott | 113303673339 | UCgf28zRkLSqAUiPuJhGdF0w | 168673083 | RepDavidScott | RepDavidScott | |
B001298 | Don Bacon B001298 | RepDonBacon | RepDonBacon | UCR9abI1lZzAZ6HwQXc-dLFQ | 818975124460335106 | RepDonBacon | ||
U000031 | Fred Upton U000031 | RepFredUpton | RepFredUpton | UCsN16IzEo4ViZNEMgeCrQ7w | 124224165 | RepFredUpton | RepFredUpton | |
M001160 | Gwen Moore M001160 | RepGwenMoore | GwenSMoore | UCCs9o1XaSsCsqNpO0iO0_Ew | 22669526 | RepGwenMoore | RepGwenMoore | |
H001058 | Bill Huizenga H001058 | RepHuizenga | RepHuizenga | UCQPlLLiMnysMmeJ5qUSSjQg | 233949261 | RepHuizenga | RepHuizenga | |
B001301 | Jack Bergman B001301 | RepJackBergman | RepJackBergman | 815241612154417152 | RepJackBergman | RepJackBergman | ||
L000557 | John Larson L000557 | RepJohnLarson | RepJohnLarson | UCGPsvFF-9WfpdRSCcCrPLiQ | 50452197 | RepJohnLarson | RepJohnBLarson | |
G000583 | Josh Gottheimer G000583 | RepJoshG | RepJoshG | 815310506596691968 | RepJoshG | |||
M001165 | Kevin McCarthy M001165 | GOPLeader | CongressmanKevinMcCarthy | UCdJUZUFSLJRlUpE-91-6DsA | 19739126 | repkevinmccarthy | RepKevinMcCarthy | |
L000583 | Barry Loudermilk L000583 | RepLoudermilk | reploudermilk | UC2Kfw8fjca8k3w3KpzL5tNg | 2914163523 | RepLoudermilk | ||
L000579 | Alan Lowenthal L000579 | RepLowenthal | RepLowenthal | UC-GgROtn5Hxm1H9a6qvy_Wg | 1055730738 | RepLowenthal | RepLowenthal | |
J000299 | Mike Johnson J000299 | RepMikeJohnson | RepMikeJohnson | UCzqBEpeIaDEfvAtsA53Fx2Q | 827279765287559171 | RepMikeJohnson | ||
M001194 | John Moolenaar M001194 | RepMoolenaar | RepMoolenaar | UCnMvVN4a8roZu4crE0UW2DA | 2696643955 | RepMoolenaar | ||
E000298 | Ron Estes E000298 | RepRonEstes | RepRonEstes | UC2clc28qcehIqotHQcthnWA | 854715071116849157 | RepRonEstes | ||
R000486 | Lucille Roybal-Allard R000486 | RepRoybalAllard | RepRoybalAllard | UC_T_RXWeJ-smmpjdNLOaMcg | 479872233 | RepRoybalAllard | RepRoybalAllard | |
M001202 | Stephanie Murphy M001202 | RepStephMurphy | RepStephMurphy | 796183515998068736 | RepStephMurphy | RepStephMurphy | ||
L000582 | Ted Lieu L000582 | RepTedLieu | RepTedLieu | UC9qcJxTqfDNBnVul1IojlFg | 3044993235 | RepTedLieu | ||
A000372 | Rick Allen A000372 | RepRickAllen | CongressmanRickAllen | UCZPoYXHFDAV17BGLMzGAmpg | 2964287128 | Rep_RickAllen | 1666787116 | |
B001267 | Michael Bennet B001267 | SenatorBennet | senbennetco | UCXB3cljpMwTyCUyLr2ZVLow | 224285242 | SenatorBennet | SenBennetCO | |
D000622 | Tammy Duckworth D000622 | SenDuckworth | SenDuckworth | UCYRWRvUxtjaHnFMCbdd94tg | 1058520120 | repduckworth | SenDuckworth | 1387939090 |
K000393 | John Kennedy K000393 | SenJohnKennedy | JohnKennedyLouisiana | 816683274076614656 | SenJohnKennedy | |||
W000802 | Sheldon Whitehouse W000802 | SenWhitehouse | SenatorWhitehouse | UCnG0N70SNBkNqvIMLodPTIA | 242555999 | SenatorWhitehouse | SenWhitehouse | |
S001184 | Tim Scott S001184 | SenatorTimScott | SenatorTimScott | UCSfAsbG80CNInSKrtpKoL-w | 217543151 | SenatorTimScott | SenatorTimScott | |
W000814 | Randy Weber W000814 | TXRandy14 | TXRandy14 | UCJSZRrAcd5i1bHLjR66PZdg | 1058051748 | TXRandy14 | TXRandy14 | |
C001053 | Tom Cole C001053 | TomColeOK04 | TomColeOK04 | UCvqzPm_YnNkfEHpm3SEMJMQ | 23124635 | reptomcole | TomColeOK04 | |
T000193 | Bennie Thompson T000193 | BennieGThompson | CongressmanBennieGThompson | UCzt2pBxh0dI24kYrWretXRw | 82453460 | RepBennieThompson | benniegthompson | 347410575 |
L000566 | Robert Latta L000566 | BobLatta | boblatta | UCVSBVHoWu-eWnBBQaMKZ_sQ | 15394954 | CongressmanBobLatta | boblatta | 26367713 |
M001159 | Cathy McMorris Rodgers M001159 | CathyMcMorris | mcmorrisrodgers | UCRp0lwIxAhq2Ia9_YgRWUkg | 17976923 | mcmorrisrodgers | cathymcmorris | |
V000128 | Chris Van Hollen V000128 | ChrisVanHollen | chrisvanhollen | UCkpfJWu1N9Okd6PE_NidtBQ | 18137749 | RepChrisVanHollen | chrisvanhollen | 268595235 |
T000467 | Glenn Thompson T000467 | CongressmanGT | CongressmanGT | UCNWX7lbWWvnNdzVMFI9DRiQ | 18967498 | CongressmanGT | congressman_gt | |
M001157 | Michael McCaul M001157 | RepMcCaul | michaeltmccaul | UCRw6sGE0PH7_FCeTT3PQRaA | 26424123 | MichaelTMcCaul | congressman_mccaul | |
C001108 | James Comer C001108 | RepJamesComer | congressmancomer | 1274852794206388225 | congressmancomer | |||
P000601 | Steven Palazzo P000601 | CongPalazzo | stevenpalazzo | UCtPOy2vRbN2nD8dQPSOTXeA | 299883942 | CongressmanPalazzo | congressmanpalazzo | |
K000391 | Raja Krishnamoorthi K000391 | CongressmanRaja | congressmanraja | 814179031956488192 | congressmanraja | |||
D000616 | Scott DesJarlais D000616 | DesJarlaisTN04 | ScottDesJarlaisTN04 | UCvjuSLoi3hS0ECQvJLhwOkA | 235312723 | ScottDesJarlaisTN04 | desjarlaistn04 | 260930821 |
T000468 | Dina Titus T000468 | RepDinaTitus | CongresswomanTitus | UC_US4jNqECuMSNrB7yVCbbw | 122174004 | CongresswomanTitus | dinatitusnv | 1110185253 |
N000188 | Donald Norcross N000188 | DonaldNorcross | DonaldNorcrossNJ | UC7kXK_PyDiOT8YrdP0jYZHw | 3122099613 | donald_norcross | ||
L000564 | Doug Lamborn L000564 | RepDLamborn | CongressmanDougLamborn | UCaYsGYMniq4nwBBMKFIwsow | 584012853 | CongressmanLamborn | douglamborn | |
R000576 | C. Ruppersberger R000576 | Call_Me_Dutch | DutchRupp | UCk2S9iSHNpo1E1A7qZ0SPIw | 305620929 | ruppersberger | dutchruppersberger | |
B001257 | Gus Bilirakis B001257 | RepGusBilirakis | GusBilirakis | UC2z1uu1n4-60xXs5x1mvLJw | 26051676 | RepGusBilirakis | gusbilirakis | |
H001056 | Jaime Herrera Beutler H001056 | HerreraBeutler | herrerabeutler | UCJEgiA9clfx0amrQUj0aBTQ | 242926427 | RepHerreraBeutler | herrerabeutler | |
G000568 | H. Griffith G000568 | RepMGriffith | RepMorganGriffith | UCzxqD7EY_Rdvbc0spbaYkJA | 234057152 | RepMorganGriffith | hmorgangriffith | |
G000577 | Garret Graves G000577 | RepGarretGraves | CongressmanGarretGraves | UCQLg9GGwTDluEFJtXf8seTA | 2951574214 | instagravesla | ||
D000626 | Warren Davidson D000626 | WarrenDavidson | CongressmanWarrenDavidson | UCMzuyZWzk44YRNesFzPTeUw | 742735530287304704 | instawarrendavidson | ||
S001175 | Jackie Speier S001175 | RepSpeier | JackieSpeier | UCevmyTb0HSO8irVaR2gYyoA | 24913074 | jackiespeierca12 | jackiespeier | |
C001091 | Joaquin Castro C001091 | JoaquinCastrotx | 326420614138023 | UCsRxWnFdRiV2od1O5v5nEeQ | 231510077 | JoaquinCastroTX | joaquincastrotx | 378492005 |
B001236 | John Boozman B001236 | JohnBoozman | JohnBoozman | UC9vWHKL5OfIYh6kIV0rF2yw | 5558312 | BoozmanPressOffice | johnboozman | |
C001051 | John Carter C001051 | JudgeCarter | judgecarter | UC9pkaOrhPfouzkJ8oAdI-1w | 18030431 | repjohncarter | judgecarter | 456560563 |
S001177 | Gregorio Sablan S001177 | Kilili_Sablan | 153423912663 | UC-fbzxBSiC98eAE2goaANVQ | 926446070812602371 | CongressmanSablan | kilili_sablan | |
B001243 | Marsha Blackburn B001243 | MarshaBlackburn | marshablackburn | UCvNnmu5mUm7xr8QXBlbtQ9w | 278145569 | RepMarshaBlackburn | marshablackburn | |
H001042 | Mazie Hirono H001042 | MazieHirono | senatorhirono | UCcoKhxad156flzPYJ8JMFOA | 92186819 | CongresswomanHirono | maziehirono | 304094084 |
M000355 | Mitch McConnell M000355 | McConnellPress | mitchmcconnell | 339822881 | mcconnellpress | |||
S001204 | Michael San Nicolas S001204 | GuamCongressman | CongressmanMichaelF.Q.SanNicolas | UCVroMJWH3jsh4shPSlp24sw | 346509049 | michael.fq.san.nicolas | ||
C000880 | Michael Crapo C000880 | MikeCrapo | mikecrapo | UCMHzKHg1BE7dEcFjnayw1lA | 600463589 | senatorcrapo | mikecrapo | 329357214 |
S001192 | Chris Stewart S001192 | RepChrisStewart | RepChrisStewart | UCKYqzTvmQVWys-WhrCkbyPw | 1072008757 | repchrisstewart | repChrisStewart | |
H001071 | Jody Hice H001071 | CongressmanHice | CongressmanJodyHice | UCzUMsS8DusN2QLpgweFthgQ | 2975091705 | rep_hice | ||
A000370 | Alma Adams A000370 | RepAdams | CongresswomanAdams | UCPI9ao1Cr1nxEUD2r-usRjQ | 2916086925 | repadams | ||
E000297 | Adriano Espaillat E000297 | RepEspaillat | RepEspaillat | UCi0niBYFhEY70Dz8InbX5OQ | 817076257770835968 | repadrianoespaillat | ||
M001195 | Alexander Mooney M001195 | RepAlexMooney | CongressmanAlexMooney | UCw9CGkF4Re3areluI43TGyA | 2964526557 | repalexmooney | ||
G000553 | Al Green G000553 | RepAlGreen | repalgreen | UCFtgMZm1YUXaZ8OtOj-GDjA | 156333623 | RepAlGreen | repalgreen | |
C001072 | André Carson C001072 | RepAndreCarson | CongressmanAndreCarson | UCprUnnEgM2VUGmAKSaZXCSw | 199325935 | repandrecarson | repandrecarson | |
B001302 | Andy Biggs B001302 | RepAndyBiggsAZ | RepAndyBiggs | UCqSq9kWOxk9yNTeILBCVC1w | 816652616625168388 | repandybiggs | ||
W000812 | Ann Wagner W000812 | RepAnnWagner | RepAnnWagner | UCy2v2DXXvQnbRc8Zx77Dnsg | 1051446626 | repannwagner | ||
L000551 | Barbara Lee L000551 | RepBarbaraLee | RepBarbaraLee | UCnRgK2MXAQOUau0JXqseeNA | 248735463 | RepLee | repbarbaralee | 1415801245 |
B001300 | Nanette Barragán B001300 | RepBarragan | CongresswomanBarragan | 816833925456789505 | repbarragan | |||
B001281 | Joyce Beatty B001281 | RepBeatty | RepJoyceBeatty | UCtVl3kb7Xvt3pY7l6x-M6LA | 1531521632 | repbeatty | 554027718 | |
M001143 | Betty McCollum M001143 | BettyMcCollum04 | repbettymccollum | UC3sZJSdiZo2EBHbsOlsnI7A | 516880804 | BMcCollum04 | repbettymccollum | |
J000292 | Bill Johnson J000292 | RepBillJohnson | RepBillJohnson | UCtF08Ay71haDRoJosRN2P_Q | 211530910 | RepBillJohnson | repbilljohnson | 763495818 |
S000185 | Robert Scott S000185 | BobbyScott | RepBobbyScott | UCdNNcpw8arCsUp55JwK_QAA | 161791703 | repbobbyscott | repbobbyscott | 1173348983 |
G000563 | Bob Gibbs G000563 | RepBobGibbs | RepBobGibbs | UC4J-kVbeE32Up-b_wTLEUmA | 234822928 | RepBobGibbs | repbobgibbs | |
W000822 | Bonnie Watson Coleman W000822 | RepBonnie | RepBonnie | UCrxEaX0VKZKwg3930du2D5A | 2968451607 | repbonnie | ||
W000815 | Brad Wenstrup W000815 | RepBradWenstrup | RepBradWenstrup | UCaK7SeUvmHdHTMtF3HXb-jA | 518644221 | repbradwenstrup | repbradwenstrup | 305496379 |
L000581 | Brenda Lawrence L000581 | RepLawrence | 395759603917487 | UCf0USy9GNigkB8O9sS1dodw | 2863006655 | repbrendalawrence | ||
F000466 | Brian Fitzpatrick F000466 | RepBrianFitz | repbrianfitzpatrick | UCYMNcgHss4_Q5JY2vSvMpgw | 816303263586914304 | repbrianfitz | ||
H001038 | Brian Higgins H001038 | RepBrianHiggins | RepBrianHiggins | UCSGbv85HaaYYOrPGePtxwag | 33576489 | CongressmanHiggins | repbrianhiggins | |
C001112 | Salud Carbajal C001112 | RepCarbajal | repsaludcarbajal | 816157667882373120 | repcarbajal | repcarbajal | ||
C001097 | Tony Cárdenas C001097 | RepCardenas | repcardenas | UCm6ug1-yvYGL0F6DvYxfFBA | 1222257180 | repcardenas | repcardenas | 1483357690 |
K000380 | Daniel Kildee K000380 | RepDanKildee | RepDanKildee | UC_KpQ-n3IT5dL5ul21XA9Yw | 1045110018 | RepDanKildee | repdankildee | 582887115 |
J000295 | David Joyce J000295 | RepDaveJoyce | RepDaveJoyce | UCTu9xz2VYk-jtQv0TVsLyYA | 976969338 | repdavejoyce | repdavejoyce | 360743678 |
S001183 | David Schweikert S001183 | RepDavid | repdavidschweikert | UCVvuNVzkOUp7p_Pzkc6Zuvw | 229197216 | RepDavidSchweikert | repdavid | 181147397 |
P000523 | David Price P000523 | RepDavidEPrice | RepDavidEPrice | UCtX7bSXBLF9ge-Q955n5Vqw | 155669457 | RepDavidPrice | repdavideprice | |
K000392 | David Kustoff K000392 | RepDavidKustoff | RepDavidKustoff | UCK6U4plOKKMrCjv_h59spGQ | 816012124505931780 | repdavidkustoff |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [social_media] ( [id] TEXT PRIMARY KEY, [legislator_id] TEXT REFERENCES [legislators]([id]), [twitter] TEXT, [facebook] TEXT, [youtube_id] TEXT, [twitter_id] INTEGER, [youtube] TEXT, [instagram] TEXT, [instagram_id] INTEGER );