social_media
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
528 rows sorted by youtube_id
This data as json, copyable, CSV (advanced)
id | legislator_id | youtube_id ▼ | twitter_id | youtube | instagram_id | |||
---|---|---|---|---|---|---|---|---|
P000616 | Dean Phillips P000616 | RepDeanPhillips | 1061310112013434882 | |||||
P000617 | Ayanna Pressley P000617 | RepPressley | 1080584229510172678 | |||||
P000618 | Katie Porter P000618 | RepKatiePorter | 1081222837459996672 | |||||
R000103 | Matthew Rosendale R000103 | RepRosendale | 1344751420139040783 | |||||
R000305 | Deborah Ross R000305 | RepDeborahRoss | 1348683154815655940 | |||||
R000608 | Jacky Rosen R000608 | SenJackyRosen | RepJackyRosen | 818554054309715969 | repjackyrosen | |||
R000609 | John Rutherford R000609 | RepRutherfordFL | RepRutherfordFL | 828977216595849216 | ||||
R000610 | Guy Reschenthaler R000610 | GReschenthaler | 4205133682 | |||||
R000612 | John Rose R000612 | RepJohnRose | 1081312310059253763 | |||||
R000614 | Chip Roy R000614 | RepChipRoy | 1082790600292925440 | |||||
R000615 | Mitt Romney R000615 | SenatorRomney | 1078693601356509184 | |||||
S000168 | Maria Salazar S000168 | RepMariaSalazar | 1325928411689349120 | |||||
S000250 | Pete Sessions S000250 | PeteSessions | 24735461 | |||||
S000929 | Victoria Spartz S000929 | RepSpartz | 1344845201479663621 | |||||
S001135 | Michelle Steel S001135 | RepSteel | 1343740146630451200 | |||||
S001159 | Marilyn Strickland S001159 | RepStricklandWA | 1343646545955213312 | |||||
S001190 | Bradley Schneider S001190 | RepSchneider | CongressmanBradSchneider | 1071840474 | RepBradSchneider | repschneider | ||
S001200 | Darren Soto S001200 | RepDarrenSoto | CongressmanDarrenSoto | 818713465653051392 | repdarrensoto | RepDarrenSoto | ||
S001203 | Tina Smith S001203 | SenTinaSmith | USSenTinaSmith | 941000686275387392 | ||||
S001205 | Mary Scanlon S001205 | RepMGS | 1067541214671577093 | |||||
S001207 | Mikie Sherrill S001207 | RepSherrill | 1080569698536878081 | |||||
S001208 | Elissa Slotkin S001208 | RepSlotkin | 1078401427347857408 | |||||
S001209 | Abigail Spanberger S001209 | RepSpanberger | 1078771401497161728 | |||||
S001211 | Greg Stanton S001211 | RepGregStanton | 1080885078425784320 | |||||
S001212 | Pete Stauber S001212 | RepPeteStauber | 1075830599007510535 | |||||
S001213 | Bryan Steil S001213 | RepBryanSteil | 1075205691621720064 | |||||
S001214 | W. Steube S001214 | RepGregSteube | 1083125649609506816 | |||||
S001215 | Haley Stevens S001215 | RepHaleyStevens | 1076161611033968640 | |||||
S001216 | Kim Schrier S001216 | RepKimSchrier | 1080462532815532032 | |||||
S001218 | Melanie Stansbury S001218 | Rep_Stansbury | 1404519992582942724 | |||||
T000165 | Thomas Tiffany T000165 | RepTiffany | 1267841066335682562 | |||||
T000278 | Tommy Tuberville T000278 | SenTuberville | 1345739193721487362 | |||||
T000478 | Claudia Tenney T000478 | RepTenney | 797201048490430465 | |||||
T000479 | Van Taylor T000479 | RepVanTaylor | 1075040139351597056 | |||||
T000480 | William Timmons T000480 | RepTimmons | 1079770852302958592 | |||||
T000481 | Rashida Tlaib T000481 | RepRashida | 1079769536730140672 | |||||
T000482 | Lori Trahan T000482 | RepLoriTrahan | 1079802482640019456 | |||||
T000483 | David Trone T000483 | RepDavidTrone | 1080573351914061825 | |||||
T000486 | Ritchie Torres T000486 | RepRitchie | 1276403757224546304 | |||||
U000040 | Lauren Underwood U000040 | RepUnderwood | 1080539438508400642 | |||||
V000129 | David Valadao V000129 | RepDavidValadao | 1128514404 | |||||
V000133 | Jefferson Van Drew V000133 | Congressman_JVD | 1468677099594698757 | |||||
V000134 | Beth Van Duyne V000134 | RepBethVanDuyne | 1339633259349745670 | |||||
W000788 | Nikema Williams W000788 | RepNikema | 1345461797361504259 | |||||
W000790 | Raphael Warnock W000790 | SenatorWarnock | 1352287997853622273 | |||||
W000823 | Michael Waltz W000823 | RepWaltzPress | 1082416697380913152 | |||||
W000825 | Jennifer Wexton W000825 | RepWexton | 1017819745880543238 | |||||
W000826 | Susan Wild W000826 | RepSusanWild | 1069636653353000962 | |||||
T000463 | Michael Turner T000463 | RepMikeTurner | RepMikeTurner | UC-6Ss-aZ3OPisf9GdVGtN8g | 51228911 | CongressmanTurner | repmiketurner | |
S000148 | Charles Schumer S000148 | SenSchumer | senschumer | UC-ABttxh8uQv_10qmwGaidw | 17494010 | SenatorSchumer | ||
L000579 | Alan Lowenthal L000579 | RepLowenthal | RepLowenthal | UC-GgROtn5Hxm1H9a6qvy_Wg | 1055730738 | RepLowenthal | RepLowenthal | |
S001217 | Rick Scott S001217 | SenRickScott | RickScottSenOffice | UC-Y9pFmW4PYGZHkC8lcqSkQ | 131546062 | |||
S001177 | Gregorio Sablan S001177 | Kilili_Sablan | 153423912663 | UC-fbzxBSiC98eAE2goaANVQ | 926446070812602371 | CongressmanSablan | kilili_sablan | |
D000618 | Steve Daines D000618 | SteveDaines | SteveDainesMT | UC-ny-W5mEUGytiyMdXbQ20Q | 11651202 | SteveDainesMT | stevedaines | 371125857 |
R000605 | Mike Rounds R000605 | SenatorRounds | SenatorMikeRounds | UC-pvzimyBdpdkcIfsicrfrQ | 2955485182 | |||
G000552 | Louie Gohmert G000552 | RepLouieGohmert | 50375006903 | UC0HMa6X3iMhMq96kkRLLTog | 22055226 | GohmertTX01 | ||
B001278 | Suzanne Bonamici B001278 | RepBonamici | congresswomanbonamici | UC0IkAeEiwgzSRTD1TDSvuBw | 558769636 | RepSuzanneBonamici | RepBonamici | |
M000639 | Robert Menendez M000639 | SenatorMenendez | senatormenendez | UC0PV0K9Z5a9p3D5917KF5fw | 18695134 | SenatorMenendezNJ | senatormenendez | 433044338 |
W000800 | Peter Welch W000800 | PeterWelch | PeterWelch | UC0YfApJx6qNaAQ-ir93U8xA | 1410590874 | reppeterwelch | reppeterwelch | 1559860900 |
K000188 | Ron Kind K000188 | RepRonKind | repronkind | UC0_BilariURHwSHf9baGykg | 112740986 | RepRonKind | ||
B001275 | Larry Bucshon B001275 | RepLarryBucshon | RepLarryBucshon | UC0bIliQs0LKZabNwvZ3gnhQ | 234812598 | RepLarryBucshon | ||
H001061 | John Hoeven H001061 | SenJohnHoeven | SenatorJohnHoeven | UC1kQIC2Q_Fq9_NRqdb6eHiw | 382791093 | senatorjohnhoevennd | senjohnhoeven | 1237544252 |
M000934 | Jerry Moran M000934 | JerryMoran | jerrymoran | UC1oRxeUPam6-53wPBZ3N02A | 18632666 | senatorjerrymoran | senjerrymoran | 298271065 |
D000615 | Jeff Duncan D000615 | RepJeffDuncan | RepJeffDuncan | UC1tuXL6ymImdpKYGEAH83QA | 240393970 | congjeffduncan | repjeffduncan | 382897929 |
K000384 | Timothy Kaine K000384 | SenatorKaine | UC27LgTZlUnBQoNEQFZdn9LA | SenatorTimKaine | ||||
V000131 | Marc Veasey V000131 | RepVeasey | CongressmanMarcVeasey | UC2CRp1KF5uljZyhDRPR-72Q | 1074129612 | marcveasey | repveasey | 676925345 |
L000583 | Barry Loudermilk L000583 | RepLoudermilk | reploudermilk | UC2Kfw8fjca8k3w3KpzL5tNg | 2914163523 | RepLoudermilk | ||
E000298 | Ron Estes E000298 | RepRonEstes | RepRonEstes | UC2clc28qcehIqotHQcthnWA | 854715071116849157 | RepRonEstes | ||
C001088 | Christopher Coons C001088 | ChrisCoons | senatorchriscoons | UC2lOVbsddn1HIkcDnmCw6tA | 15324851 | senatorchriscoons | senatorchriscoons | 25194715 |
B001257 | Gus Bilirakis B001257 | RepGusBilirakis | GusBilirakis | UC2z1uu1n4-60xXs5x1mvLJw | 26051676 | RepGusBilirakis | gusbilirakis | |
T000469 | Paul Tonko T000469 | RepPaulTonko | reppaultonko | UC3P2SGFmmuCYRsjeso0hOQQ | 84119348 | reppaultonko | reppaultonko | |
P000610 | Stacey Plaskett P000610 | StaceyPlaskett | repstaceyplaskett | UC3V7biFZHDFHDFZy6cCSZUA | 2724095695 | stacey_plaskett | ||
W000795 | Joe Wilson W000795 | RepJoeWilson | JoeWilson | UC3aR1B8m7Z1uycO65yDnpCg | 254082173 | RepJoeWilson | repjoewilson | 519685522 |
C001084 | David Cicilline C001084 | RepCicilline | CongressmanDavidCicilline | UC3sCl46o8hYP69LnidNltuw | 462143773 | RepDavidCicilline | ||
M001143 | Betty McCollum M001143 | BettyMcCollum04 | repbettymccollum | UC3sZJSdiZo2EBHbsOlsnI7A | 516880804 | BMcCollum04 | repbettymccollum | |
L000174 | Patrick Leahy L000174 | SenatorLeahy | SenatorPatrickLeahy | UC46QHVobf7FO-tWehsRoDog | 242836537 | SenatorPatrickLeahy | senatorleahy | |
G000563 | Bob Gibbs G000563 | RepBobGibbs | RepBobGibbs | UC4J-kVbeE32Up-b_wTLEUmA | 234822928 | RepBobGibbs | repbobgibbs | |
S001191 | Kyrsten Sinema S001191 | SenatorSinema | CongresswomanSinema | UC4NzhW7D4lQdukSGWmFnK9w | 1080844782 | repsinema | repsinema | |
C001078 | Gerald Connolly C001078 | GerryConnolly | CongressmanGerryConnolly | UC4WG9PlmoOeSLIuyVjs-RSA | 78445977 | repconnolly | ||
G000581 | Vicente Gonzalez G000581 | RepGonzalez | USCongressmanVicenteGonzalez | UC5H6oYLKQ_xIXO5CG7fh4hw | 818536152588238849 | repvicentegonzaleztx | ||
S001189 | Austin Scott S001189 | AustinScottGA08 | RepAustinScott | UC5M7eKHKQStktMyjieiHYZQ | 234797704 | RepAustinScott | ||
C000059 | Ken Calvert C000059 | KenCalvert | 70063393423 | UC5MEj7YOX_QdKoqD_HRxP3A | 22545491 | RepKenCalvert | repkencalvert | |
G000565 | Paul Gosar G000565 | RepGosar | repgosar | UC5orqw_9acsKWSRbrqTDXBw | 240760644 | repgosar | REPGOSAR | |
M001196 | Seth Moulton M001196 | RepMoulton | CongressmanSethMoulton | UC5w5qn7nj5Ljy69LTV7a_fQ | 3091316093 | repmoulton | ||
B001288 | Cory Booker B001288 | SenBooker | UC6FlymqNS1VettnVZa7goPA | 2167097881 | SenCoryBooker | |||
C001035 | Susan Collins C001035 | SenatorCollins | susancollins | UC6GYaBx5kT2r4PN8KENxC-w | 19726613 | SenatorSusanCollins | sensusancollins | |
B000755 | Kevin Brady B000755 | RepKevinBrady | kevinbrady | UC6Ng0uMQEBVgXO_HF0NbfXA | 19926675 | KBrady8 | repkevinbrady | 337613850 |
T000460 | Mike Thompson T000460 | RepThompson | RepMikeThompson | UC6pGbtqHZYZmScFGSz5bbdg | 303861808 | CongressmanMThompson | ||
A000055 | Robert Aderholt A000055 | Robert_Aderholt | RobertAderholt | UC71CAgpg1gbLTew_pfTneGA | 76452765 | RobertAderholt | ||
K000375 | William Keating K000375 | USRepKeating | Congressman.Keating | UC7KPV4xdxO2dms9vl6tETmg | 232992031 | RepBillKeating | ||
P000595 | Gary Peters P000595 | SenGaryPeters | SenGaryPeters | UC7LYNbnKSK2VZqQ98YROWHQ | 236511574 | RepGaryPeters | sengarypeters | 1640246681 |
L000588 | Conor Lamb L000588 | RepConorLamb | RepConorLamb | UC7hX59n_ixS1Bz3f8Je02yA | 984456621417000960 | |||
N000188 | Donald Norcross N000188 | DonaldNorcross | DonaldNorcrossNJ | UC7kXK_PyDiOT8YrdP0jYZHw | 3122099613 | donald_norcross | ||
S001198 | Dan Sullivan S001198 | SenDanSullivan | SenDanSullivan | UC7tXCm8gKlAhTFo2kuf5ylw | 2891210047 | sen_dansullivan | 1660873387 | |
S001194 | Brian Schatz S001194 | SenBrianSchatz | SenBrianSchatz | UC8-mSYp2WqBiB_5iwtwKfow | 1262099252 | senbrianschatz | ||
B001261 | John Barrasso B001261 | SenJohnBarrasso | johnbarrasso | UC80PfiCAB2Fe1MFayWlR6GQ | 202206694 | barrassowyo | ||
G000551 | Raúl Grijalva G000551 | RepRaulGrijalva | Rep.Grijalva | UC8JZLnXS21bhNbcvpoM8O7g | 28602948 | raulgrijalvaaz07 | ||
C001067 | Yvette Clarke C001067 | RepYvetteClarke | repyvettedclarke | UC8SuQiuL2P9fUHAxuRoTdUQ | 240812994 | repyvetteclarke | repyvettedclarke | |
H001067 | Richard Hudson H001067 | RepRichHudson | RepRichHudson | UC9Q1qCvnQR7rHERjTjJl5Pg | 935033864 | RepRichHudson | ||
D000216 | Rosa DeLauro D000216 | RosaDeLauro | CongresswomanRosaDeLauro | UC9ROfGBm7kSLCEDYwFF6McQ | 140519774 | rosadelauro |
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 );