social_media
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
528 rows sorted by id descending
This data as json, copyable, CSV (advanced)
id ▲ | legislator_id | youtube_id | twitter_id | youtube | instagram_id | |||
---|---|---|---|---|---|---|---|---|
Z000017 | Lee Zeldin Z000017 | RepLeeZeldin | RepLeeZeldin | UCHzZuesCPDka2NhZO8icqzA | 2750127259 | |||
Y000064 | Todd Young Y000064 | SenToddYoung | SenatorToddYoung | UCuknj4PGn91gHDNAfboZEgQ | 234128524 | RepToddYoung | sentoddyoung | |
Y000062 | John Yarmuth Y000062 | RepJohnYarmuth | 214258646163 | UCy5KW4yrEfEiyZRX45Eoxkg | 384913290 | RepJohnYarmuth | ||
W000826 | Susan Wild W000826 | RepSusanWild | 1069636653353000962 | |||||
W000825 | Jennifer Wexton W000825 | RepWexton | 1017819745880543238 | |||||
W000823 | Michael Waltz W000823 | RepWaltzPress | 1082416697380913152 | |||||
W000822 | Bonnie Watson Coleman W000822 | RepBonnie | RepBonnie | UCrxEaX0VKZKwg3930du2D5A | 2968451607 | repbonnie | ||
W000821 | Bruce Westerman W000821 | RepWesterman | RepWesterman | UCNshPbmupCwP5a7Hi79jETQ | 2852998461 | |||
W000817 | Elizabeth Warren W000817 | SenWarren | senatorelizabethwarren | UCTH9zV8Imw09J5bOoTR18_A | 970207298 | senelizabethwarren | senwarren | |
W000816 | Roger Williams W000816 | RepRWilliams | RepRogerWilliams | UCBtfmMMQarjtLB9U_pWMOhw | 1077446982 | |||
W000815 | Brad Wenstrup W000815 | RepBradWenstrup | RepBradWenstrup | UCaK7SeUvmHdHTMtF3HXb-jA | 518644221 | repbradwenstrup | repbradwenstrup | 305496379 |
W000814 | Randy Weber W000814 | TXRandy14 | TXRandy14 | UCJSZRrAcd5i1bHLjR66PZdg | 1058051748 | TXRandy14 | TXRandy14 | |
W000812 | Ann Wagner W000812 | RepAnnWagner | RepAnnWagner | UCy2v2DXXvQnbRc8Zx77Dnsg | 1051446626 | repannwagner | ||
W000809 | Steve Womack W000809 | Rep_SteveWomack | RepSteveWomack | UCXJbUDLYX-wGIhRuN66hqZw | 234469322 | CongressmanWomack | ||
W000808 | Frederica Wilson W000808 | RepWilson | RepWilson | UCP5QBhng_lHv-vJgE_h7lpA | 234014087 | repfredericawilson | repwilson | |
W000806 | Daniel Webster W000806 | RepWebster | RepWebster | UCCoX4VdU7U11eGEA0lbRtLw | 281540744 | repdanwebster | ||
W000805 | Mark Warner W000805 | MarkWarner | MarkRWarner | UCwyivNlEGf4sGd1oDLfY5jw | 7429102 | SenatorMarkWarner | senatorwarner | 515327940 |
W000804 | Robert Wittman W000804 | RobWittman | RepRobWittman | UCIqIb-OaTbkIdU426eYIdPg | 15356407 | RobWittman | reprobwittman | |
W000802 | Sheldon Whitehouse W000802 | SenWhitehouse | SenatorWhitehouse | UCnG0N70SNBkNqvIMLodPTIA | 242555999 | SenatorWhitehouse | SenWhitehouse | |
W000800 | Peter Welch W000800 | PeterWelch | PeterWelch | UC0YfApJx6qNaAQ-ir93U8xA | 1410590874 | reppeterwelch | reppeterwelch | 1559860900 |
W000798 | Tim Walberg W000798 | RepWalberg | RepWalberg | UChpf3_3Wn8f3qSJbsYXrhvg | 237862972 | RepWalberg | repwalberg | |
W000797 | Debbie Wasserman Schultz W000797 | RepDWStweets | RepDWS | UCfHQiJVvMlYbVAxrMSLdO4w | 1140648348 | RepWassermanSchultz | RepDWSTweets | |
W000795 | Joe Wilson W000795 | RepJoeWilson | JoeWilson | UC3aR1B8m7Z1uycO65yDnpCg | 254082173 | RepJoeWilson | repjoewilson | 519685522 |
W000790 | Raphael Warnock W000790 | SenatorWarnock | 1352287997853622273 | |||||
W000788 | Nikema Williams W000788 | RepNikema | 1345461797361504259 | |||||
W000779 | Ron Wyden W000779 | RonWyden | UCsd3UEaoLoqX60P88BdpGGw | 250188760 | senronwyden | ronwyden | 9443881 | |
W000437 | Roger Wicker W000437 | SenatorWicker | SenatorWicker | UCIlKHiTjSkcQP_knBcXHWSg | 264219447 | SenatorWicker | senatorwicker | 367948073 |
W000187 | Maxine Waters W000187 | RepMaxineWaters | MaxineWaters | UCOQ2js1VYFlo74n7Ns8WsLQ | 36686040 | MaxineWaters | repmaxinewaters | |
V000134 | Beth Van Duyne V000134 | RepBethVanDuyne | 1339633259349745670 | |||||
V000133 | Jefferson Van Drew V000133 | Congressman_JVD | 1468677099594698757 | |||||
V000131 | Marc Veasey V000131 | RepVeasey | CongressmanMarcVeasey | UC2CRp1KF5uljZyhDRPR-72Q | 1074129612 | marcveasey | repveasey | 676925345 |
V000130 | Juan Vargas V000130 | RepJuanVargas | RepJuanVargas | UCpMthf8y7bEMJH_td0dznRQ | 1260172386 | RepJuanVargas | repjuanvargas | |
V000129 | David Valadao V000129 | RepDavidValadao | 1128514404 | |||||
V000128 | Chris Van Hollen V000128 | ChrisVanHollen | chrisvanhollen | UCkpfJWu1N9Okd6PE_NidtBQ | 18137749 | RepChrisVanHollen | chrisvanhollen | 268595235 |
V000081 | Nydia Velázquez V000081 | NydiaVelazquez | 8037068318 | UCqMKPkKeeHFOOiZ9vxhXGVg | 164369297 | nydiavelazquez | ||
U000040 | Lauren Underwood U000040 | RepUnderwood | 1080539438508400642 | |||||
U000031 | Fred Upton U000031 | RepFredUpton | RepFredUpton | UCsN16IzEo4ViZNEMgeCrQ7w | 124224165 | RepFredUpton | RepFredUpton | |
T000486 | Ritchie Torres T000486 | RepRitchie | 1276403757224546304 | |||||
T000483 | David Trone T000483 | RepDavidTrone | 1080573351914061825 | |||||
T000482 | Lori Trahan T000482 | RepLoriTrahan | 1079802482640019456 | |||||
T000481 | Rashida Tlaib T000481 | RepRashida | 1079769536730140672 | |||||
T000480 | William Timmons T000480 | RepTimmons | 1079770852302958592 | |||||
T000479 | Van Taylor T000479 | RepVanTaylor | 1075040139351597056 | |||||
T000478 | Claudia Tenney T000478 | RepTenney | 797201048490430465 | |||||
T000476 | Thom Tillis T000476 | SenThomTillis | SenatorThomTillis | UCUD9VGV4SSGWjGdbn37Ea2w | 2964174789 | senthomtillis | ||
T000474 | Norma Torres T000474 | NormaJTorres | RepNormaTorres | UCvWY4qKP6--o3pIJY7hhKDg | 236279233 | repnormatorres | ||
T000472 | Mark Takano T000472 | RepMarkTakano | RepMarkTakano | UCJg4F1irmSFeKoXZBaZbX2w | 1037321378 | RepMarkTakano | repmarktakano | |
T000469 | Paul Tonko T000469 | RepPaulTonko | reppaultonko | UC3P2SGFmmuCYRsjeso0hOQQ | 84119348 | reppaultonko | reppaultonko | |
T000468 | Dina Titus T000468 | RepDinaTitus | CongresswomanTitus | UC_US4jNqECuMSNrB7yVCbbw | 122174004 | CongresswomanTitus | dinatitusnv | 1110185253 |
T000467 | Glenn Thompson T000467 | CongressmanGT | CongressmanGT | UCNWX7lbWWvnNdzVMFI9DRiQ | 18967498 | CongressmanGT | congressman_gt | |
T000464 | Jon Tester T000464 | SenatorTester | senatortester | UCgXAF-CON1coZFMxQkfj0fg | 515822213 | senatorjontester | ||
T000463 | Michael Turner T000463 | RepMikeTurner | RepMikeTurner | UC-6Ss-aZ3OPisf9GdVGtN8g | 51228911 | CongressmanTurner | repmiketurner | |
T000461 | Patrick Toomey T000461 | SenToomey | senatortoomey | UCDUM4FFU1p-_YuHqmBglyXw | 221162525 | sentoomey | ||
T000460 | Mike Thompson T000460 | RepThompson | RepMikeThompson | UC6pGbtqHZYZmScFGSz5bbdg | 303861808 | CongressmanMThompson | ||
T000278 | Tommy Tuberville T000278 | SenTuberville | 1345739193721487362 | |||||
T000250 | John Thune T000250 | SenJohnThune | UCRu6lpRfxhkDGUrKDgQNZYQ | 296361085 | johnthune | senjohnthune | ||
T000193 | Bennie Thompson T000193 | BennieGThompson | CongressmanBennieGThompson | UCzt2pBxh0dI24kYrWretXRw | 82453460 | RepBennieThompson | benniegthompson | 347410575 |
T000165 | Thomas Tiffany T000165 | RepTiffany | 1267841066335682562 | |||||
S001218 | Melanie Stansbury S001218 | Rep_Stansbury | 1404519992582942724 | |||||
S001217 | Rick Scott S001217 | SenRickScott | RickScottSenOffice | UC-Y9pFmW4PYGZHkC8lcqSkQ | 131546062 | |||
S001216 | Kim Schrier S001216 | RepKimSchrier | 1080462532815532032 | |||||
S001215 | Haley Stevens S001215 | RepHaleyStevens | 1076161611033968640 | |||||
S001214 | W. Steube S001214 | RepGregSteube | 1083125649609506816 | |||||
S001213 | Bryan Steil S001213 | RepBryanSteil | 1075205691621720064 | |||||
S001212 | Pete Stauber S001212 | RepPeteStauber | 1075830599007510535 | |||||
S001211 | Greg Stanton S001211 | RepGregStanton | 1080885078425784320 | |||||
S001209 | Abigail Spanberger S001209 | RepSpanberger | 1078771401497161728 | |||||
S001208 | Elissa Slotkin S001208 | RepSlotkin | 1078401427347857408 | |||||
S001207 | Mikie Sherrill S001207 | RepSherrill | 1080569698536878081 | |||||
S001205 | Mary Scanlon S001205 | RepMGS | 1067541214671577093 | |||||
S001204 | Michael San Nicolas S001204 | GuamCongressman | CongressmanMichaelF.Q.SanNicolas | UCVroMJWH3jsh4shPSlp24sw | 346509049 | michael.fq.san.nicolas | ||
S001203 | Tina Smith S001203 | SenTinaSmith | USSenTinaSmith | 941000686275387392 | ||||
S001201 | Thomas Suozzi S001201 | RepTomSuozzi | RepTomSuozzi | UCHjLmETJ7qXtciV7dlAzzgQ | 816705409486618624 | |||
S001200 | Darren Soto S001200 | RepDarrenSoto | CongressmanDarrenSoto | 818713465653051392 | repdarrensoto | RepDarrenSoto | ||
S001199 | Lloyd Smucker S001199 | RepSmucker | RepSmucker | UCs5iMvWy-oTHyf5HuwB7FCg | 41417564 | |||
S001198 | Dan Sullivan S001198 | SenDanSullivan | SenDanSullivan | UC7tXCm8gKlAhTFo2kuf5ylw | 2891210047 | sen_dansullivan | 1660873387 | |
S001197 | Benjamin Sasse S001197 | SenSasse | SenatorSasse | UCYaNGwcM2Dl5yDcDqS6xV2g | 2962923040 | senatorsasse | 1636974433 | |
S001196 | Elise Stefanik S001196 | RepStefanik | RepEliseStefanik | UCHvf42C8Vw6QnjwO2L2ukKA | 2962813893 | |||
S001195 | Jason Smith S001195 | RepJasonSmith | repjasonsmith | UCzj9-27Lr4gcqopmZAobXXg | 1623308912 | RepJasonSmith | ||
S001194 | Brian Schatz S001194 | SenBrianSchatz | SenBrianSchatz | UC8-mSYp2WqBiB_5iwtwKfow | 1262099252 | senbrianschatz | ||
S001193 | Eric Swalwell S001193 | RepSwalwell | CongressmanEricSwalwell | UCKvwsFNGD4sDkE_9g-2ft0w | 942156122 | ericswalwell | repswalwell | 338799200 |
S001192 | Chris Stewart S001192 | RepChrisStewart | RepChrisStewart | UCKYqzTvmQVWys-WhrCkbyPw | 1072008757 | repchrisstewart | repChrisStewart | |
S001191 | Kyrsten Sinema S001191 | SenatorSinema | CongresswomanSinema | UC4NzhW7D4lQdukSGWmFnK9w | 1080844782 | repsinema | repsinema | |
S001190 | Bradley Schneider S001190 | RepSchneider | CongressmanBradSchneider | 1071840474 | RepBradSchneider | repschneider | ||
S001189 | Austin Scott S001189 | AustinScottGA08 | RepAustinScott | UC5M7eKHKQStktMyjieiHYZQ | 234797704 | RepAustinScott | ||
S001185 | Terri Sewell S001185 | RepTerriSewell | RepSewell | UCHkEHtfrfUWOFtbUFQTQH7Q | 381152398 | RepSewell | ||
S001184 | Tim Scott S001184 | SenatorTimScott | SenatorTimScott | UCSfAsbG80CNInSKrtpKoL-w | 217543151 | SenatorTimScott | SenatorTimScott | |
S001183 | David Schweikert S001183 | RepDavid | repdavidschweikert | UCVvuNVzkOUp7p_Pzkc6Zuvw | 229197216 | RepDavidSchweikert | repdavid | 181147397 |
S001181 | Jeanne Shaheen S001181 | SenatorShaheen | SenatorShaheen | UCjLZAZMbDrybHyttdEC9LFA | 109287731 | senatorshaheen | senatorshaheen | |
S001180 | Kurt Schrader S001180 | RepSchrader | repschrader | UCrWRXVaGJtcImc_kknuDsAw | 20545793 | repkurtschrader | ||
S001177 | Gregorio Sablan S001177 | Kilili_Sablan | 153423912663 | UC-fbzxBSiC98eAE2goaANVQ | 926446070812602371 | CongressmanSablan | kilili_sablan | |
S001176 | Steve Scalise S001176 | SteveScalise | RepSteveScalise | UCmYveHBVXVBRxl7GiCL-gjw | 1209417007 | RepSteveScalise | stevescalise | 1210937919 |
S001175 | Jackie Speier S001175 | RepSpeier | JackieSpeier | UCevmyTb0HSO8irVaR2gYyoA | 24913074 | jackiespeierca12 | jackiespeier | |
S001172 | Adrian Smith S001172 | RepAdrianSmith | UCIgn2z-hwxx_aeggnyhv54Q | 296245061 | RepAdrianSmith | RepAdrianSmith | ||
S001168 | John Sarbanes S001168 | RepSarbanes | RepSarbanes | UCCypi0IDTr-XxlAXsJCdBZQ | 364415553 | RepJohnSarbanes | ||
S001165 | Albio Sires S001165 | RepSires | 81058818750 | UCfdEcWPNGoIxpYoTANF4PBA | 18696134 | RepSiresNJ13 | ||
S001159 | Marilyn Strickland S001159 | RepStricklandWA | 1343646545955213312 | |||||
S001157 | David Scott S001157 | RepDavidScott | 113303673339 | UCgf28zRkLSqAUiPuJhGdF0w | 168673083 | RepDavidScott | RepDavidScott | |
S001156 | Linda Sánchez S001156 | RepLindaSanchez | CongresswomanLindaSanchez | UCu1K6uHxjMgj2mvzM7O9-ow | 312134473 | LindaTSanchez | ||
S001150 | Adam Schiff S001150 | RepAdamSchiff | RepAdamSchiff | UCadiUi-KZoFk1K5ZDsluLcA | 29501253 | adamschiff | RepAdamSchiff |
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 );