social_media

Table actions

Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette

528 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ legislator_id youtube_id youtube instagram instagram_id
A000055 Robert Aderholt A000055 UC71CAgpg1gbLTew_pfTneGA RobertAderholt    
A000148 Jake Auchincloss A000148        
A000369 Mark Amodei A000369 UCjOGx2iqSn1r3BQxaVgYhYw markamodeinv2 MarkAmodeiNV2  
A000370 Alma Adams A000370 UCPI9ao1Cr1nxEUD2r-usRjQ   repadams  
A000371 Pete Aguilar A000371 UCxwbFLOlKDsXrwizV5jah7g      
A000372 Rick Allen A000372 UCZPoYXHFDAV17BGLMzGAmpg   Rep_RickAllen 1666787116
A000375 Jodey Arrington A000375     repjodeyarrington  
A000376 Colin Allred A000376        
A000377 Kelly Armstrong A000377        
A000378 Cynthia Axne A000378        
B000490 Sanford Bishop B000490 UCxF9veLBrkr_CqVq5eFYVGg RepSanfordBishop    
B000574 Earl Blumenauer B000574 UCuziVoKuGn7feNA5VrpxsBQ RepBlumenauer    
B000575 Roy Blunt B000575 UCFeLRzjhThTmaWzuh5qjpGA SenatorBlunt royblunt 21185436
B000668 Cliff Bentz B000668        
B000740 Stephanie Bice B000740        
B000755 Kevin Brady B000755 UC6Ng0uMQEBVgXO_HF0NbfXA KBrady8 repkevinbrady 337613850
B000825 Lauren Boebert B000825        
B000944 Sherrod Brown B000944 UCgy8jfERh-t_ixkKKoCmglQ SherrodBrownOhio    
B001135 Richard Burr B001135 UCOLLZpp-1womBSFDV2uLfag SenatorRichardBurr senatorburr  
B001223 Jamaal Bowman B001223        
B001224 Cori Bush B001224        
B001230 Tammy Baldwin B001230 UC_XjYCRbbI2_TDDjJidwk0Q witammybaldwin senatorbaldwin  
B001236 John Boozman B001236 UC9vWHKL5OfIYh6kIV0rF2yw BoozmanPressOffice johnboozman  
B001243 Marsha Blackburn B001243 UCvNnmu5mUm7xr8QXBlbtQ9w RepMarshaBlackburn marshablackburn  
B001248 Michael Burgess B001248 UCvvO8lo-Nkc31cEEElqQvQw michaelcburgessmd repmichaelburgess  
B001251 George Butterfield B001251 UCbodCVgLfcbaep49L1M-mqA GKBNC01    
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  
B001270 Karen Bass B001270 UCQZg7oxkV3Yag2emYPLhT2g RepKarenBass    
B001274 Mo Brooks B001274 UCgsPSY0MpuQJq8vEqYUSt-g RepMoBrooks    
B001275 Larry Bucshon B001275 UC0bIliQs0LKZabNwvZ3gnhQ RepLarryBucshon    
B001277 Richard Blumenthal B001277 UCHH-fn3_LVt0Q4od56rOi5g SenatorBlumenthal    
B001278 Suzanne Bonamici B001278 UC0IkAeEiwgzSRTD1TDSvuBw RepSuzanneBonamici RepBonamici  
B001281 Joyce Beatty B001281 UCtVl3kb7Xvt3pY7l6x-M6LA   repbeatty 554027718
B001282 Garland Barr B001282 UCVL2s6x7f7H0ZJ-uwU0pQ6Q RepAndyBarr    
B001285 Julia Brownley B001285 UCFrC4Ouk5R6xQztS9PZin_A RepJuliaBrownley    
B001286 Cheri Bustos B001286 UCrkOYuIsVeb4dvKeeO7jnaA RepCheri    
B001287 Ami Bera B001287 UClJCTCo53Zk6b4kUL-bbdzg repamibera    
B001288 Cory Booker B001288 UC6FlymqNS1VettnVZa7goPA SenCoryBooker    
B001291 Brian Babin B001291 UCPVEZgw-VbDRbLV1MRGVQNQ      
B001292 Donald Beyer B001292 UCPJGVbOVcAVGiBwq8qr_T9w   repdonbeyer  
B001295 Mike Bost B001295 UCYA1psY06vSf3QadHuCrmjQ      
B001296 Brendan Boyle B001296 UCMP_Anj7lz4eZuSh8GwFqQQ      
B001297 Ken Buck B001297 UCHK7Wcwij7NoxXGTeSHUWzg   repkenbuck  
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        
B001304 Anthony Brown B001304   RepAnthonyBrown RepAnthonyBrown  
B001305 Ted Budd B001305        
B001306 Troy Balderson B001306        
B001307 James Baird B001307        
B001309 Tim Burchett B001309        
B001310 Mike Braun B001310        
B001311 Dan Bishop B001311        
B001312 Carolyn Bourdeaux B001312        
B001313 Shontel Brown B001313        
C000059 Ken Calvert C000059 UC5MEj7YOX_QdKoqD_HRxP3A RepKenCalvert repkencalvert  
C000127 Maria Cantwell C000127 UCN52UDqKgvHRk39ncySrIMw SenatorCantwell    
C000141 Benjamin Cardin C000141 UCiQaJnMzlfzzG3VESgyZChA senatorcardin senatorcardin  
C000174 Thomas Carper C000174 UCgLnvbKwu4B3navofj6Qvvw senatorcarper    
C000266 Steve Chabot C000266 UCJpzm2DZDE1B6ruQLQc7q4g congressmanchabot repstevechabot 481906395
C000537 James Clyburn C000537 UCIyU_UA_JEa14gvAwhquKqg repjamesclyburn    
C000754 Jim Cooper C000754 UCjplyIIQbNZcl013AyDfPNg RepJimCooper repjimcooper 1037212884
C000880 Michael Crapo C000880 UCMHzKHg1BE7dEcFjnayw1lA senatorcrapo mikecrapo 329357214
C001035 Susan Collins C001035 UC6GYaBx5kT2r4PN8KENxC-w SenatorSusanCollins sensusancollins  
C001039 Katherine Cammack C001039        
C001047 Shelley Capito C001047 UCbiXdR4XQ3vD9Xp5lfR9QXw   sencapito 1640447624
C001051 John Carter C001051 UC9pkaOrhPfouzkJ8oAdI-1w repjohncarter judgecarter 456560563
C001053 Tom Cole C001053 UCvqzPm_YnNkfEHpm3SEMJMQ reptomcole TomColeOK04  
C001054 Jerry Carl C001054        
C001055 Ed Case C001055        
C001056 John Cornyn C001056 UCyQwLQavlOaJ64YuY_VMtiQ senjohncornyn    
C001059 Jim Costa C001059 UCVgXX23eJEai6GiBOKO6dvA RepJimCostaCA20    
C001061 Emanuel Cleaver C001061 UCVC-7CLFjXczoihr5FxDLsw repcleaver    
C001063 Henry Cuellar C001063 UCVgEOdJx3tyILO9EjZ-heEQ henrycuellar    
C001066 Kathy Castor C001066 UC_irxhmLqVenTFPxDxznG6g RepKathyCastor    
C001067 Yvette Clarke C001067 UC8SuQiuL2P9fUHAxuRoTdUQ repyvetteclarke repyvettedclarke  
C001068 Steve Cohen C001068 UC_NJlnsOBjOameUwZk0rvsA repcohen    
C001069 Joe Courtney C001069 UCGVIfe1T2hO1Lx7ap5Wkv1w repcourtney repjoecourtney  
C001070 Robert Casey C001070 UCtVssXhx-KuZa-hSvnsnJ0A SenatorBobCasey senbobcasey  
C001072 André Carson C001072 UCprUnnEgM2VUGmAKSaZXCSw repandrecarson repandrecarson  
C001075 Bill Cassidy C001075 UCCEyGhUzxgkxFzWCY-rxz8g SenatorBillCassidy    
C001078 Gerald Connolly C001078 UC4WG9PlmoOeSLIuyVjs-RSA repconnolly    
C001080 Judy Chu C001080 UCfcbYOvdEXZNelM8T05nK-w RepJudyChu    
C001084 David Cicilline C001084 UC3sCl46o8hYP69LnidNltuw RepDavidCicilline    
C001087 Eric Crawford C001087 UCLKAkVl4BHRK73lmDiIgPYg RepRickCrawford reprickcrawford 389864684
C001088 Christopher Coons C001088 UC2lOVbsddn1HIkcDnmCw6tA senatorchriscoons senatorchriscoons 25194715
C001090 Matthew Cartwright C001090 UCnAOvexSGLBnYidaFzguhTQ   repmattcartwright  
C001091 Joaquin Castro C001091 UCsRxWnFdRiV2od1O5v5nEeQ JoaquinCastroTX joaquincastrotx 378492005
C001095 Tom Cotton C001095 UCXEk6mokWBajIpNatbjnwSg RepTomCotton    
C001096 Kevin Cramer C001096 UCqUPdO9XaAW-dvwwXKbIVdA kevincramer repkevincramer  
C001097 Tony Cárdenas C001097 UCm6ug1-yvYGL0F6DvYxfFBA repcardenas repcardenas 1483357690
C001098 Ted Cruz C001098 UCOTZ-6H1rri1lSsj6IzhUyw sentedcruz    
C001101 Katherine Clark C001101 UCgaI52w7QKI8LtkSeCCmSuw   repkclark  
C001103 Earl Carter C001103 UCHQm49T6ikD_ioMAt50AwKQ      

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
);