social_media

Table actions

528 rows

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ legislator_id youtube_id youtube instagram instagram_id mastodon
A000055 Robert Aderholt A000055 UC71CAgpg1gbLTew_pfTneGA RobertAderholt      
A000148 Jake Auchincloss A000148   RepAuchincloss      
A000369 Mark Amodei A000369 UCjOGx2iqSn1r3BQxaVgYhYw markamodeinv2 MarkAmodeiNV2    
A000370 Alma Adams A000370 UCPI9ao1Cr1nxEUD2r-usRjQ   repadams   @RepAdams@mastodon.social
A000371 Pete Aguilar A000371 UCxwbFLOlKDsXrwizV5jah7g        
A000372 Rick Allen A000372 UCZPoYXHFDAV17BGLMzGAmpg   Rep_RickAllen 1666787116  
A000375 Jodey Arrington A000375   UC3lif8TFPOe-tJ2-pE4Rp7Q repjodeyarrington    
A000379 Mark Alford A000379   @RepAlford RepMarkAlford    
A000380 Gabe Amo A000380     repgabeamo    
A000381 Yassamin Ansari A000381     RepYassAnsari    
A000382 Angela Alsobrooks A000382     sen_alsobrooks    
B000490 Sanford Bishop B000490 UCxF9veLBrkr_CqVq5eFYVGg RepSanfordBishop      
B000668 Cliff Bentz B000668     repbentz    
B000740 Stephanie Bice B000740          
B000825 Lauren Boebert B000825          
B001230 Tammy Baldwin B001230 UC_XjYCRbbI2_TDDjJidwk0Q witammybaldwin senatorbaldwin    
B001236 John Boozman B001236 UC9vWHKL5OfIYh6kIV0rF2yw BoozmanPressOffice johnboozman    
B001243 Marsha Blackburn B001243 UCvNnmu5mUm7xr8QXBlbtQ9w RepMarshaBlackburn marshablackburn    
B001257 Gus Bilirakis B001257 UC2z1uu1n4-60xXs5x1mvLJw RepGusBilirakis gusbilirakis    
B001260 Vern Buchanan B001260 UCY4DEy41NxOTdcF8_XAVZvw vernbuchanan repvern 344865327  
B001261 John Barrasso B001261 UC80PfiCAB2Fe1MFayWlR6GQ barrassowyo      
B001267 Michael Bennet B001267 UCXB3cljpMwTyCUyLr2ZVLow SenatorBennet SenBennetCO    
B001277 Richard Blumenthal B001277 UCHH-fn3_LVt0Q4od56rOi5g SenatorBlumenthal senblumenthal    
B001278 Suzanne Bonamici B001278 UC0IkAeEiwgzSRTD1TDSvuBw RepSuzanneBonamici RepBonamici    
B001281 Joyce Beatty B001281 UCtVl3kb7Xvt3pY7l6x-M6LA   repbeatty 554027718  
B001282 Garland Barr B001282 UCVL2s6x7f7H0ZJ-uwU0pQ6Q RepAndyBarr RepAndyBarr    
B001285 Julia Brownley B001285 UCFrC4Ouk5R6xQztS9PZin_A RepJuliaBrownley RepBrownley    
B001287 Ami Bera B001287 UClJCTCo53Zk6b4kUL-bbdzg repamibera repbera    
B001288 Cory Booker B001288 UC6FlymqNS1VettnVZa7goPA SenCoryBooker corybooker    
B001291 Brian Babin B001291 UCPVEZgw-VbDRbLV1MRGVQNQ        
B001292 Donald Beyer B001292 UCPJGVbOVcAVGiBwq8qr_T9w   repdonbeyer   @RepDonBeyer@mas.to
B001295 Mike Bost B001295 UCYA1psY06vSf3QadHuCrmjQ        
B001296 Brendan Boyle B001296 UCMP_Anj7lz4eZuSh8GwFqQQ        
B001298 Don Bacon B001298 UCR9abI1lZzAZ6HwQXc-dLFQ   RepDonBacon    
B001299 Jim Banks B001299 UC_FR6TySW9uxvhjozkis6Xg   repjimbanks    
B001300 Nanette Barragán B001300     repbarragan    
B001301 Jack Bergman B001301   RepJackBergman RepJackBergman    
B001302 Andy Biggs B001302 UCqSq9kWOxk9yNTeILBCVC1w   repandybiggs    
B001303 Lisa Blunt Rochester B001303     senlbr    
B001305 Ted Budd B001305   @sentedbudd sentedbudd    
B001306 Troy Balderson B001306   UCm6vJzx-mu4Xr56FnQKRz0w      
B001307 James Baird B001307   UCAe6fGhotC9J9tR_QONYzFA      
B001309 Tim Burchett B001309          
B001313 Shontel Brown B001313         @RepShontelBrown@mastodon.social
B001314 Aaron Bean B001314     RepAaronBean    
B001315 Nicole (Nikki) Budzinski B001315   UCp0Ykb-qUGx3ekTH9MIEK-w repnikki    
B001316 Eric Burlison B001316   UCuJFygzYhGiXMZHjhTQy20w RepEricBurlison    
B001317 Josh Brecheen B001317   UCSX3nV53o-1-e0nFA6pPs2w repbrecheen    
B001318 Becca Balint B001318   YouTubeChannelID repbeccab    
B001319 Katie Britt B001319   UCbrYQF8n5ftTPqn8ZNo5vYw senkatiebritt    
B001321 Tom Barrett B001321          
B001322 Michael Baumgartner B001322     repbaumgartner    
B001323 Nicholas Begich B001323     RepNickBegich    
B001324 Wesley Bell B001324          
B001325 Sheri Biggs B001325     RepSheriBiggs    
B001326 Janelle Bynum B001326     repbynum    
B001327 Robert Bresnahan B001327     RepBresnahan    
C000059 Ken Calvert C000059 UC5MEj7YOX_QdKoqD_HRxP3A RepKenCalvert repkencalvert    
C000127 Maria Cantwell C000127 UCN52UDqKgvHRk39ncySrIMw SenatorCantwell      
C000537 James Clyburn C000537 UCIyU_UA_JEa14gvAwhquKqg repjamesclyburn repjamesclyburn    
C000880 Michael Crapo C000880 UCMHzKHg1BE7dEcFjnayw1lA senatorcrapo mikecrapo 329357214  
C001035 Susan Collins C001035 UC6GYaBx5kT2r4PN8KENxC-w SenatorSusanCollins sensusancollins    
C001039 Katherine Cammack C001039     repkatcammack    
C001047 Shelley Capito C001047 UCbiXdR4XQ3vD9Xp5lfR9QXw   sencapito 1640447624  
C001051 John Carter C001051 UC9pkaOrhPfouzkJ8oAdI-1w repjohncarter judgecarter 456560563  
C001053 Tom Cole C001053 UCvqzPm_YnNkfEHpm3SEMJMQ reptomcole TomColeOK04    
C001055 Ed Case C001055   RepEdCase repedcase    
C001056 John Cornyn C001056 UCyQwLQavlOaJ64YuY_VMtiQ senjohncornyn      
C001059 Jim Costa C001059 UCVgXX23eJEai6GiBOKO6dvA RepJimCostaCA20      
C001061 Emanuel Cleaver C001061 UCVC-7CLFjXczoihr5FxDLsw repcleaver repcleaver    
C001063 Henry Cuellar C001063 UCVgEOdJx3tyILO9EjZ-heEQ henrycuellar RepCuellar    
C001066 Kathy Castor C001066 UC_irxhmLqVenTFPxDxznG6g RepKathyCastor usrepkathycastor    
C001067 Yvette Clarke C001067 UC8SuQiuL2P9fUHAxuRoTdUQ repyvetteclarke repyvettedclarke    
C001068 Steve Cohen C001068 UC_NJlnsOBjOameUwZk0rvsA repcohen repcohen    
C001069 Joe Courtney C001069 UCGVIfe1T2hO1Lx7ap5Wkv1w repcourtney repjoecourtney    
C001072 André Carson C001072 UCprUnnEgM2VUGmAKSaZXCSw repandrecarson repandrecarson    
C001075 Bill Cassidy C001075 UCCEyGhUzxgkxFzWCY-rxz8g SenatorBillCassidy senbillcassidy    
C001080 Judy Chu C001080 UCfcbYOvdEXZNelM8T05nK-w RepJudyChu repjudychu    
C001087 Eric Crawford C001087 UCLKAkVl4BHRK73lmDiIgPYg RepRickCrawford reprickcrawford 389864684  
C001088 Christopher Coons C001088 UC2lOVbsddn1HIkcDnmCw6tA senatorchriscoons senatorchriscoons 25194715  
C001091 Joaquin Castro C001091 UCsRxWnFdRiV2od1O5v5nEeQ JoaquinCastroTX joaquincastrotx 378492005 @Joaquincastrotx@mastodon.social
C001095 Tom Cotton C001095 UCXEk6mokWBajIpNatbjnwSg RepTomCotton      
C001096 Kevin Cramer C001096 UCqUPdO9XaAW-dvwwXKbIVdA kevincramer repkevincramer    
C001098 Ted Cruz C001098 UCOTZ-6H1rri1lSsj6IzhUyw sentedcruz sentedcruz    
C001101 Katherine Clark C001101 UCgaI52w7QKI8LtkSeCCmSuw   repkclark    
C001103 Earl Carter C001103 UCHQm49T6ikD_ioMAt50AwKQ   repbuddycarter    
C001108 James Comer C001108     congressmancomer    
C001110 J. Correa C001110 UCIKJJp4QJIDjnjodc23qKkw   reploucorrea    
C001112 Salud Carbajal C001112   repcarbajal repcarbajal    
C001113 Catherine Cortez Masto C001113 UCip_83SiKUqwnUT57VOXrCg   sencortezmasto    
C001114 John Curtis C001114 UChAQ4MD-HigmGnImSoAKBVA   repjohncurtis    
C001115 Michael Cloud C001115   RepCloudTX repcloudtx    
C001116 Andrew Clyde C001116   UC-o-UOnLuu8pZxZpShG4s7A repclyde    
C001117 Sean Casten C001117     repseancasten   @RepCasten@mastodon.social
C001118 Ben Cline C001118   @congressmanbencline8000 repbencline    
C001119 Angie Craig C001119          
C001120 Dan Crenshaw C001120   UC2XDiCjAHtJqnSEzrHAY5IQ dancrenshawtx    
C001121 Jason Crow C001121          
C001123 Gilbert Cisneros C001123     repgilcisneros    
C001125 Troy Carter C001125          

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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,
   [mastodon] TEXT
);