home / legislators

Menu
  • GraphQL API

social_media

Table actions
  • GraphQL API for social_media

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 twitter facebook youtube_id twitter_id youtube instagram instagram_id
A000055 Robert Aderholt A000055 Robert_Aderholt RobertAderholt UC71CAgpg1gbLTew_pfTneGA 76452765 RobertAderholt    
A000148 Jake Auchincloss A000148 RepAuchincloss     1330278736554582016      
A000369 Mark Amodei A000369 MarkAmodeiNV2 MarkAmodeiNV2 UCjOGx2iqSn1r3BQxaVgYhYw 402719755 markamodeinv2 MarkAmodeiNV2  
A000370 Alma Adams A000370 RepAdams CongresswomanAdams UCPI9ao1Cr1nxEUD2r-usRjQ 2916086925   repadams  
A000371 Pete Aguilar A000371 RepPeteAguilar reppeteaguilar UCxwbFLOlKDsXrwizV5jah7g 3018670151      
A000372 Rick Allen A000372 RepRickAllen CongressmanRickAllen UCZPoYXHFDAV17BGLMzGAmpg 2964287128   Rep_RickAllen 1666787116
A000375 Jodey Arrington A000375 RepArrington JodeyArrington   816284664658874368   repjodeyarrington  
A000376 Colin Allred A000376 RepColinAllred     1078355119920562176      
A000377 Kelly Armstrong A000377 RepArmstrongND     1080515866255593472      
A000378 Cynthia Axne A000378 RepCindyAxne     1080865917377097728      
B000490 Sanford Bishop B000490 SanfordBishop sanfordbishop UCxF9veLBrkr_CqVq5eFYVGg 249410485 RepSanfordBishop    
B000574 Earl Blumenauer B000574 BlumenauerMedia   UCuziVoKuGn7feNA5VrpxsBQ 137823987 RepBlumenauer    
B000575 Roy Blunt B000575 RoyBlunt SenatorBlunt UCFeLRzjhThTmaWzuh5qjpGA 21269970 SenatorBlunt royblunt 21185436
B000668 Cliff Bentz B000668 RepBentz     1345788865911656454      
B000740 Stephanie Bice B000740 RepBice     1344260196227555334      
B000755 Kevin Brady B000755 RepKevinBrady kevinbrady UC6Ng0uMQEBVgXO_HF0NbfXA 19926675 KBrady8 repkevinbrady 337613850
B000825 Lauren Boebert B000825 RepBoebert     1342989756611907584      
B000944 Sherrod Brown B000944 SenSherrodBrown SenatorSherrodBrown UCgy8jfERh-t_ixkKKoCmglQ 43910797 SherrodBrownOhio    
B001135 Richard Burr B001135 SenatorBurr SenatorRichardBurr UCOLLZpp-1womBSFDV2uLfag 21157904 SenatorRichardBurr senatorburr  
B001223 Jamaal Bowman B001223 RepBowman     1344389506963808264      
B001224 Cori Bush B001224 RepCori     1002630999052865536      
B001230 Tammy Baldwin B001230 SenatorBaldwin senatortammybaldwin UC_XjYCRbbI2_TDDjJidwk0Q 1074518754 witammybaldwin senatorbaldwin  
B001236 John Boozman B001236 JohnBoozman JohnBoozman UC9vWHKL5OfIYh6kIV0rF2yw 5558312 BoozmanPressOffice johnboozman  
B001243 Marsha Blackburn B001243 MarshaBlackburn marshablackburn UCvNnmu5mUm7xr8QXBlbtQ9w 278145569 RepMarshaBlackburn marshablackburn  
B001248 Michael Burgess B001248 MichaelCBurgess michaelcburgess UCvvO8lo-Nkc31cEEElqQvQw 15751083 michaelcburgessmd repmichaelburgess  
B001251 George Butterfield B001251 GKButterfield congressmangkbutterfield UCbodCVgLfcbaep49L1M-mqA 432676344 GKBNC01    
B001257 Gus Bilirakis B001257 RepGusBilirakis GusBilirakis UC2z1uu1n4-60xXs5x1mvLJw 26051676 RepGusBilirakis gusbilirakis  
B001260 Vern Buchanan B001260 VernBuchanan CongressmanBuchanan UCY4DEy41NxOTdcF8_XAVZvw 20467163 vernbuchanan repvern 344865327
B001261 John Barrasso B001261 SenJohnBarrasso johnbarrasso UC80PfiCAB2Fe1MFayWlR6GQ 202206694 barrassowyo    
B001267 Michael Bennet B001267 SenatorBennet senbennetco UCXB3cljpMwTyCUyLr2ZVLow 224285242 SenatorBennet SenBennetCO  
B001270 Karen Bass B001270 RepKarenBass RepKarenBass UCQZg7oxkV3Yag2emYPLhT2g 239949176 RepKarenBass    
B001274 Mo Brooks B001274 RepMoBrooks RepMoBrooks UCgsPSY0MpuQJq8vEqYUSt-g 237299871 RepMoBrooks    
B001275 Larry Bucshon B001275 RepLarryBucshon RepLarryBucshon UC0bIliQs0LKZabNwvZ3gnhQ 234812598 RepLarryBucshon    
B001277 Richard Blumenthal B001277 SenBlumenthal SenBlumenthal UCHH-fn3_LVt0Q4od56rOi5g 278124059 SenatorBlumenthal    
B001278 Suzanne Bonamici B001278 RepBonamici congresswomanbonamici UC0IkAeEiwgzSRTD1TDSvuBw 558769636 RepSuzanneBonamici RepBonamici  
B001281 Joyce Beatty B001281 RepBeatty RepJoyceBeatty UCtVl3kb7Xvt3pY7l6x-M6LA 1531521632   repbeatty 554027718
B001282 Garland Barr B001282 RepAndyBarr RepAndyBarr UCVL2s6x7f7H0ZJ-uwU0pQ6Q 1089334250 RepAndyBarr    
B001285 Julia Brownley B001285 RepBrownley RepJuliaBrownley UCFrC4Ouk5R6xQztS9PZin_A 1243902714 RepJuliaBrownley    
B001286 Cheri Bustos B001286 RepCheri RepCheri UCrkOYuIsVeb4dvKeeO7jnaA 1092979962 RepCheri    
B001287 Ami Bera B001287 RepBera RepAmiBera UClJCTCo53Zk6b4kUL-bbdzg 950783972 repamibera    
B001288 Cory Booker B001288 SenBooker   UC6FlymqNS1VettnVZa7goPA 2167097881 SenCoryBooker    
B001291 Brian Babin B001291 RepBrianBabin RepBrianBabin UCPVEZgw-VbDRbLV1MRGVQNQ 2929491549      
B001292 Donald Beyer B001292 RepDonBeyer RepDonBeyer UCPJGVbOVcAVGiBwq8qr_T9w 2962868158   repdonbeyer  
B001295 Mike Bost B001295 RepBost RepBost UCYA1psY06vSf3QadHuCrmjQ 2964877294      
B001296 Brendan Boyle B001296 CongBoyle CongressmanBoyle UCMP_Anj7lz4eZuSh8GwFqQQ 4304448314      
B001297 Ken Buck B001297 RepKenBuck repkenbuck UCHK7Wcwij7NoxXGTeSHUWzg 2862577383   repkenbuck  
B001298 Don Bacon B001298 RepDonBacon RepDonBacon UCR9abI1lZzAZ6HwQXc-dLFQ 818975124460335106   RepDonBacon  
B001299 Jim Banks B001299 RepJimBanks RepJimBanks UC_FR6TySW9uxvhjozkis6Xg 816131319033950208   repjimbanks  
B001300 Nanette Barragán B001300 RepBarragan CongresswomanBarragan   816833925456789505   repbarragan  
B001301 Jack Bergman B001301 RepJackBergman RepJackBergman   815241612154417152 RepJackBergman RepJackBergman  
B001302 Andy Biggs B001302 RepAndyBiggsAZ RepAndyBiggs UCqSq9kWOxk9yNTeILBCVC1w 816652616625168388   repandybiggs  
B001303 Lisa Blunt Rochester B001303 RepLBR Rep.BluntRochester   817050219007328258      
B001304 Anthony Brown B001304 RepAnthonyBrown RepAnthonyBrown   823552974253342721 RepAnthonyBrown RepAnthonyBrown  
B001305 Ted Budd B001305 RepTedBudd RepTedBudd   817138492614524928      
B001306 Troy Balderson B001306 RepBalderson     1037341536592310272      
B001307 James Baird B001307 RepJimBaird     1086316494450032640      
B001309 Tim Burchett B001309 RepTimBurchett     1028854804087492613      
B001310 Mike Braun B001310 SenatorBraun     1080870981877534720      
B001311 Dan Bishop B001311 RepDanBishop repdanbishop   1176522535531360257      
B001312 Carolyn Bourdeaux B001312 RepBourdeaux     1343620645452595200      
B001313 Shontel Brown B001313 RepShontelBrown     1456381091598700556      
C000059 Ken Calvert C000059 KenCalvert 70063393423 UC5MEj7YOX_QdKoqD_HRxP3A 22545491 RepKenCalvert repkencalvert  
C000127 Maria Cantwell C000127 SenatorCantwell senatorcantwell UCN52UDqKgvHRk39ncySrIMw 117501995 SenatorCantwell    
C000141 Benjamin Cardin C000141 SenatorCardin senatorbencardin UCiQaJnMzlfzzG3VESgyZChA 109071031 senatorcardin senatorcardin  
C000174 Thomas Carper C000174 SenatorCarper tomcarper UCgLnvbKwu4B3navofj6Qvvw 249787913 senatorcarper    
C000266 Steve Chabot C000266 RepSteveChabot RepSteveChabot UCJpzm2DZDE1B6ruQLQc7q4g 237750442 congressmanchabot repstevechabot 481906395
C000537 James Clyburn C000537 WhipClyburn jameseclyburn UCIyU_UA_JEa14gvAwhquKqg 188019606 repjamesclyburn    
C000754 Jim Cooper C000754 RepJimCooper JimCooper UCjplyIIQbNZcl013AyDfPNg 22523087 RepJimCooper repjimcooper 1037212884
C000880 Michael Crapo C000880 MikeCrapo mikecrapo UCMHzKHg1BE7dEcFjnayw1lA 600463589 senatorcrapo mikecrapo 329357214
C001035 Susan Collins C001035 SenatorCollins susancollins UC6GYaBx5kT2r4PN8KENxC-w 19726613 SenatorSusanCollins sensusancollins  
C001039 Katherine Cammack C001039 RepKatCammack     1344325638983987201      
C001047 Shelley Capito C001047 SenCapito senshelley UCbiXdR4XQ3vD9Xp5lfR9QXw 193794406   sencapito 1640447624
C001051 John Carter C001051 JudgeCarter judgecarter UC9pkaOrhPfouzkJ8oAdI-1w 18030431 repjohncarter judgecarter 456560563
C001053 Tom Cole C001053 TomColeOK04 TomColeOK04 UCvqzPm_YnNkfEHpm3SEMJMQ 23124635 reptomcole TomColeOK04  
C001054 Jerry Carl C001054 RepJerryCarl     1341091420439015424      
C001055 Ed Case C001055 RepEdCase     1081350574589833221      
C001056 John Cornyn C001056 JohnCornyn sen.johncornyn UCyQwLQavlOaJ64YuY_VMtiQ 13218102 senjohncornyn    
C001059 Jim Costa C001059 RepJimCosta RepJimCosta UCVgXX23eJEai6GiBOKO6dvA 245451804 RepJimCostaCA20    
C001061 Emanuel Cleaver C001061 RepCleaver emanuelcleaverii UCVC-7CLFjXczoihr5FxDLsw 163570705 repcleaver    
C001063 Henry Cuellar C001063 RepCuellar 152569121550 UCVgEOdJx3tyILO9EjZ-heEQ 210926192 henrycuellar    
C001066 Kathy Castor C001066 USRepKCastor USRepKathyCastor UC_irxhmLqVenTFPxDxznG6g 1880674038 RepKathyCastor    
C001067 Yvette Clarke C001067 RepYvetteClarke repyvettedclarke UC8SuQiuL2P9fUHAxuRoTdUQ 240812994 repyvetteclarke repyvettedclarke  
C001068 Steve Cohen C001068 RepCohen CongressmanSteveCohen UC_NJlnsOBjOameUwZk0rvsA 162069635 repcohen    
C001069 Joe Courtney C001069 RepJoeCourtney joecourtney UCGVIfe1T2hO1Lx7ap5Wkv1w 85396297 repcourtney repjoecourtney  
C001070 Robert Casey C001070 SenBobCasey SenatorBobCasey UCtVssXhx-KuZa-hSvnsnJ0A 171598736 SenatorBobCasey senbobcasey  
C001072 André Carson C001072 RepAndreCarson CongressmanAndreCarson UCprUnnEgM2VUGmAKSaZXCSw 199325935 repandrecarson repandrecarson  
C001075 Bill Cassidy C001075 SenBillCassidy   UCCEyGhUzxgkxFzWCY-rxz8g 1017500185356853248 SenatorBillCassidy    
C001078 Gerald Connolly C001078 GerryConnolly CongressmanGerryConnolly UC4WG9PlmoOeSLIuyVjs-RSA 78445977 repconnolly    
C001080 Judy Chu C001080 RepJudyChu RepJudyChu UCfcbYOvdEXZNelM8T05nK-w 193732179 RepJudyChu    
C001084 David Cicilline C001084 RepCicilline CongressmanDavidCicilline UC3sCl46o8hYP69LnidNltuw 462143773 RepDavidCicilline    
C001087 Eric Crawford C001087 RepRickCrawford RepRickCrawford UCLKAkVl4BHRK73lmDiIgPYg 233693291 RepRickCrawford reprickcrawford 389864684
C001088 Christopher Coons C001088 ChrisCoons senatorchriscoons UC2lOVbsddn1HIkcDnmCw6tA 15324851 senatorchriscoons senatorchriscoons 25194715
C001090 Matthew Cartwright C001090 RepCartwright CongressmanMattCartwright UCnAOvexSGLBnYidaFzguhTQ 776664410   repmattcartwright  
C001091 Joaquin Castro C001091 JoaquinCastrotx 326420614138023 UCsRxWnFdRiV2od1O5v5nEeQ 231510077 JoaquinCastroTX joaquincastrotx 378492005
C001095 Tom Cotton C001095 SenTomCotton SenatorTomCotton UCXEk6mokWBajIpNatbjnwSg 968650362 RepTomCotton    
C001096 Kevin Cramer C001096 SenKevinCramer CongressmanKevinCramer UCqUPdO9XaAW-dvwwXKbIVdA 1048784496 kevincramer repkevincramer  
C001097 Tony Cárdenas C001097 RepCardenas repcardenas UCm6ug1-yvYGL0F6DvYxfFBA 1222257180 repcardenas repcardenas 1483357690
C001098 Ted Cruz C001098 SenTedCruz SenatorTedCruz UCOTZ-6H1rri1lSsj6IzhUyw 1074480192 sentedcruz    
C001101 Katherine Clark C001101 RepKClark CongresswomanClark UCgaI52w7QKI8LtkSeCCmSuw 2293131060   repkclark  
C001103 Earl Carter C001103 RepBuddyCarter congressmanbuddycarter UCHQm49T6ikD_ioMAt50AwKQ 2973870195      

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
);
Powered by Datasette · Queries took 16.918ms · Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette