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 | |||
---|---|---|---|---|---|---|---|---|
C001051 | John Carter C001051 | JudgeCarter | judgecarter | UC9pkaOrhPfouzkJ8oAdI-1w | 18030431 | repjohncarter | judgecarter | 456560563 |
L000582 | Ted Lieu L000582 | RepTedLieu | RepTedLieu | UC9qcJxTqfDNBnVul1IojlFg | 3044993235 | RepTedLieu | ||
B001236 | John Boozman B001236 | JohnBoozman | JohnBoozman | UC9vWHKL5OfIYh6kIV0rF2yw | 5558312 | BoozmanPressOffice | johnboozman | |
H001053 | Vicky Hartzler H001053 | RepHartzler | Congresswoman.Hartzler | UCAvttUz6qBVEJiFt7p_MZxw | 237763317 | repvickyhartzler | rephartzler | 787899303 |
W000816 | Roger Williams W000816 | RepRWilliams | RepRogerWilliams | UCBtfmMMQarjtLB9U_pWMOhw | 1077446982 | |||
R000603 | David Rouzer R000603 | RepDavidRouzer | RepRouzer | UCBvOxpqoGi1HlHjX9v_gHZw | 834069080 | repdavidrouzer | ||
H001046 | Martin Heinrich H001046 | MartinHeinrich | MartinHeinrich | UCBxh8IK5sMxY0Ln_0G2NYcg | 1099199839 | SenMartinHeinrich | senatormartinheinrich | 285288987 |
C001075 | Bill Cassidy C001075 | SenBillCassidy | UCCEyGhUzxgkxFzWCY-rxz8g | 1017500185356853248 | SenatorBillCassidy | |||
H001047 | James Himes H001047 | CongressmanJimHimes | UCCeB6czh6nhCHxOMCk_V4yA | congressmanhimes | ||||
W000806 | Daniel Webster W000806 | RepWebster | RepWebster | UCCoX4VdU7U11eGEA0lbRtLw | 281540744 | repdanwebster | ||
M001160 | Gwen Moore M001160 | RepGwenMoore | GwenSMoore | UCCs9o1XaSsCsqNpO0iO0_Ew | 22669526 | RepGwenMoore | RepGwenMoore | |
S001168 | John Sarbanes S001168 | RepSarbanes | RepSarbanes | UCCypi0IDTr-XxlAXsJCdBZQ | 364415553 | RepJohnSarbanes | ||
Q000023 | Mike Quigley Q000023 | RepMikeQuigley | repmikequigley | UCDP13XegdoZ4bxYHxM34yAA | 56864092 | RepMikeQuigley | repmikequigley | 1403659583 |
T000461 | Patrick Toomey T000461 | SenToomey | senatortoomey | UCDUM4FFU1p-_YuHqmBglyXw | 221162525 | sentoomey | ||
S000033 | Bernard Sanders S000033 | SenSanders | senatorsanders | UCD_DaKNac0Ta-2PeHuoQ1uA | 29442313 | senatorsanders | ||
F000462 | Lois Frankel F000462 | RepLoisFrankel | RepLoisFrankel | UCEk5viAhxaW_2OK20-yBwzQ | 1077121945 | reploisfrankel | reploisfrankel | |
R000597 | Tom Rice R000597 | RepTomRice | reptomrice | UCEmPVQphMGoXAfWJli68BEw | 1058345042 | RepTomRice | reptomrice | |
B000575 | Roy Blunt B000575 | RoyBlunt | SenatorBlunt | UCFeLRzjhThTmaWzuh5qjpGA | 21269970 | SenatorBlunt | royblunt | 21185436 |
S000770 | Debbie Stabenow S000770 | SenStabenow | SenatorStabenow | UCFoDKCvxSwCUfDv-4Eg4K5A | 76456274 | senatorstabenow | ||
B001285 | Julia Brownley B001285 | RepBrownley | RepJuliaBrownley | UCFrC4Ouk5R6xQztS9PZin_A | 1243902714 | RepJuliaBrownley | ||
G000553 | Al Green G000553 | RepAlGreen | repalgreen | UCFtgMZm1YUXaZ8OtOj-GDjA | 156333623 | RepAlGreen | repalgreen | |
J000293 | Ron Johnson J000293 | SenRonJohnson | senronjohnson | UCG9XyTVtOAs7VX_q_QVHoaw | 233737858 | SenatorRonJohnson | senronjohnson | |
L000557 | John Larson L000557 | RepJohnLarson | RepJohnLarson | UCGPsvFF-9WfpdRSCcCrPLiQ | 50452197 | RepJohnLarson | RepJohnBLarson | |
C001069 | Joe Courtney C001069 | RepJoeCourtney | joecourtney | UCGVIfe1T2hO1Lx7ap5Wkv1w | 85396297 | repcourtney | repjoecourtney | |
R000600 | Aumua Amata Radewagen R000600 | RepAmata | aumuaamata | UCGdrLQbt1PYDTPsampx4t1A | 3026622545 | |||
M001183 | Joe Manchin M001183 | Sen_JoeManchin | JoeManchinIII | UCGyPK_ye2ptpzQgOjKIn7ag | 234374703 | SenatorJoeManchin | ||
R000575 | Mike Rogers R000575 | RepMikeRogersAL | CongressmanMikeDRogers | UCH-WUWuY0_dlKwJDSqKTJsg | 33977070 | MikeRogersAL03 | repmikerogersal | 259435765 |
B001277 | Richard Blumenthal B001277 | SenBlumenthal | SenBlumenthal | UCHH-fn3_LVt0Q4od56rOi5g | 278124059 | SenatorBlumenthal | ||
B001297 | Ken Buck B001297 | RepKenBuck | repkenbuck | UCHK7Wcwij7NoxXGTeSHUWzg | 2862577383 | repkenbuck | ||
C001103 | Earl Carter C001103 | RepBuddyCarter | congressmanbuddycarter | UCHQm49T6ikD_ioMAt50AwKQ | 2973870195 | |||
M001188 | Grace Meng M001188 | RepGraceMeng | repgracemeng | UCHg516zJKbIBtXFAJ0nu3XQ | 1051127714 | |||
S001201 | Thomas Suozzi S001201 | RepTomSuozzi | RepTomSuozzi | UCHjLmETJ7qXtciV7dlAzzgQ | 816705409486618624 | |||
S001185 | Terri Sewell S001185 | RepTerriSewell | RepSewell | UCHkEHtfrfUWOFtbUFQTQH7Q | 381152398 | RepSewell | ||
S001196 | Elise Stefanik S001196 | RepStefanik | RepEliseStefanik | UCHvf42C8Vw6QnjwO2L2ukKA | 2962813893 | |||
Z000017 | Lee Zeldin Z000017 | RepLeeZeldin | RepLeeZeldin | UCHzZuesCPDka2NhZO8icqzA | 2750127259 | |||
D000191 | Peter DeFazio D000191 | RepPeterDeFazio | RepPeterDeFazio | UCIF3HunhsVgTv7L2grnq2Rg | 252249233 | PeterDeFazio | ||
K000009 | Marcy Kaptur K000009 | RepMarcyKaptur | RepresentativeMarcyKaptur | UCIJUNf22o09nO02oQPLKQ6w | 581141508 | USRepMarcyKaptur | repmarcykaptur | |
C001110 | J. Correa C001110 | RepLouCorrea | RepLouCorrea | UCIKJJp4QJIDjnjodc23qKkw | 815985039485837312 | reploucorrea | ||
S001172 | Adrian Smith S001172 | RepAdrianSmith | UCIgn2z-hwxx_aeggnyhv54Q | 296245061 | RepAdrianSmith | RepAdrianSmith | ||
W000437 | Roger Wicker W000437 | SenatorWicker | SenatorWicker | UCIlKHiTjSkcQP_knBcXHWSg | 264219447 | SenatorWicker | senatorwicker | 367948073 |
W000804 | Robert Wittman W000804 | RobWittman | RepRobWittman | UCIqIb-OaTbkIdU426eYIdPg | 15356407 | RobWittman | reprobwittman | |
P000096 | Bill Pascrell P000096 | BillPascrell | pascrell | UCIy1Ru8oA14aRjpq6L3i-EQ | 74508260 | RepPascrell | ||
C000537 | James Clyburn C000537 | WhipClyburn | jameseclyburn | UCIyU_UA_JEa14gvAwhquKqg | 188019606 | repjamesclyburn | ||
H001056 | Jaime Herrera Beutler H001056 | HerreraBeutler | herrerabeutler | UCJEgiA9clfx0amrQUj0aBTQ | 242926427 | RepHerreraBeutler | herrerabeutler | |
H001079 | Cindy Hyde-Smith H001079 | SenHydeSmith | UCJHxkJhGST0NTlkzJHWV03Q | 983348251972816896 | sencindyhydesmith | |||
W000814 | Randy Weber W000814 | TXRandy14 | TXRandy14 | UCJSZRrAcd5i1bHLjR66PZdg | 1058051748 | TXRandy14 | TXRandy14 | |
H001068 | Jared Huffman H001068 | RepHuffman | RepHuffman | UCJU6SP1ppp1ZhSiqZLiFgDA | 1071102246 | rephuffman | rephuffman | |
P000593 | Ed Perlmutter P000593 | RepPerlmutter | RepPerlmutter | UCJXuMAzxngpEvDdvlE6wS5g | 20552026 | RepPerlmutter | ||
T000472 | Mark Takano T000472 | RepMarkTakano | RepMarkTakano | UCJg4F1irmSFeKoXZBaZbX2w | 1037321378 | RepMarkTakano | repmarktakano | |
C000266 | Steve Chabot C000266 | RepSteveChabot | RepSteveChabot | UCJpzm2DZDE1B6ruQLQc7q4g | 237750442 | congressmanchabot | repstevechabot | 481906395 |
K000392 | David Kustoff K000392 | RepDavidKustoff | RepDavidKustoff | UCK6U4plOKKMrCjv_h59spGQ | 816012124505931780 | repdavidkustoff | ||
S001192 | Chris Stewart S001192 | RepChrisStewart | RepChrisStewart | UCKYqzTvmQVWys-WhrCkbyPw | 1072008757 | repchrisstewart | repChrisStewart | |
S001193 | Eric Swalwell S001193 | RepSwalwell | CongressmanEricSwalwell | UCKvwsFNGD4sDkE_9g-2ft0w | 942156122 | ericswalwell | repswalwell | 338799200 |
C001087 | Eric Crawford C001087 | RepRickCrawford | RepRickCrawford | UCLKAkVl4BHRK73lmDiIgPYg | 233693291 | RepRickCrawford | reprickcrawford | 389864684 |
P000597 | Chellie Pingree P000597 | ChelliePingree | ChelliePingree | UCLKaWFM7I84WcreDRhhhkVg | 14984637 | congresswomanpingree | ||
L000576 | Billy Long L000576 | USRepLong | Rep.Billy.Long | UCLQcbyxpHXXAsUJckscQY8g | 1444015610 | MOdistrict7 | ||
M001190 | Markwayne Mullin M001190 | RepMullin | RepMullin | UCLQlm-cbGbJj9baZC6oFsag | 1060370282 | |||
R000602 | Kathleen Rice R000602 | RepKathleenRice | RepKathleenRice | UCLYLmjrGtzzCFXMWPBxHAug | 2970462034 | |||
K000385 | Robin Kelly K000385 | RepRobinKelly | reprobinkelly | UCLhcNPX2nNQLNzwKW0nEykg | 1339931490 | reprobinkelly | ||
E000295 | Joni Ernst E000295 | SenJoniErnst | senjoniernst | UCLwrmtF_84FIcK3TyMs4MIw | 2856787757 | senjoniernst | 1582702853 | |
C000880 | Michael Crapo C000880 | MikeCrapo | mikecrapo | UCMHzKHg1BE7dEcFjnayw1lA | 600463589 | senatorcrapo | mikecrapo | 329357214 |
B001296 | Brendan Boyle B001296 | CongBoyle | CongressmanBoyle | UCMP_Anj7lz4eZuSh8GwFqQQ | 4304448314 | |||
M001177 | Tom McClintock M001177 | RepMcClintock | 81125319109 | UCMh04KC4LfIzKoXh2Xws_pw | 50152441 | McClintockCA04 | ||
L000560 | Rick Larsen L000560 | RepRickLarsen | RepRickLarsen | UCMv7LsJtiyO4AJcbRux5CxQ | 404132211 | congressmanlarsen | repricklarsen | |
D000626 | Warren Davidson D000626 | WarrenDavidson | CongressmanWarrenDavidson | UCMzuyZWzk44YRNesFzPTeUw | 742735530287304704 | instawarrendavidson | ||
D000399 | Lloyd Doggett D000399 | RepLloydDoggett | lloyddoggett | UCN-kiLKyHPcfRVZ28sAHS_g | 153944899 | doggett | replloyddoggett | |
P000034 | Frank Pallone P000034 | FrankPallone | repfrankpallone | UCN0_wn9hs1LI3UKkji2PP2A | 31801993 | repfrankpallone | repfrankpallone | |
C000127 | Maria Cantwell C000127 | SenatorCantwell | senatorcantwell | UCN52UDqKgvHRk39ncySrIMw | 117501995 | SenatorCantwell | ||
T000467 | Glenn Thompson T000467 | CongressmanGT | CongressmanGT | UCNWX7lbWWvnNdzVMFI9DRiQ | 18967498 | CongressmanGT | congressman_gt | |
S001148 | Michael Simpson S001148 | CongMikeSimpson | 96007744606 | UCNXe0rJJeULTAP_7oyQNw8g | 76132891 | CongMikeSimpson | ||
M001185 | Sean Maloney M001185 | RepSeanMaloney | RepSeanMaloney | UCNiVzzf4Vz-vCMPBcnjGuXQ | 1072467470 | repseanpatrickmaloney | ||
W000821 | Bruce Westerman W000821 | RepWesterman | RepWesterman | UCNshPbmupCwP5a7Hi79jETQ | 2852998461 | |||
B001135 | Richard Burr B001135 | SenatorBurr | SenatorRichardBurr | UCOLLZpp-1womBSFDV2uLfag | 21157904 | SenatorRichardBurr | senatorburr | |
W000187 | Maxine Waters W000187 | RepMaxineWaters | MaxineWaters | UCOQ2js1VYFlo74n7Ns8WsLQ | 36686040 | MaxineWaters | repmaxinewaters | |
C001098 | Ted Cruz C001098 | SenTedCruz | SenatorTedCruz | UCOTZ-6H1rri1lSsj6IzhUyw | 1074480192 | sentedcruz | ||
L000397 | Zoe Lofgren L000397 | RepZoeLofgren | zoelofgren | UCOaQ79adORFcaTuJZoIFuZQ | 267938462 | RepZoeLofgren | ||
W000808 | Frederica Wilson W000808 | RepWilson | RepWilson | UCP5QBhng_lHv-vJgE_h7lpA | 234014087 | repfredericawilson | repwilson | |
J000289 | Jim Jordan J000289 | Jim_Jordan | repjimjordan | UCPFBhS00ivPV585GlnNlyqA | 18166778 | RepJimJordan | ||
A000370 | Alma Adams A000370 | RepAdams | CongresswomanAdams | UCPI9ao1Cr1nxEUD2r-usRjQ | 2916086925 | repadams | ||
B001292 | Donald Beyer B001292 | RepDonBeyer | RepDonBeyer | UCPJGVbOVcAVGiBwq8qr_T9w | 2962868158 | repdonbeyer | ||
B001291 | Brian Babin B001291 | RepBrianBabin | RepBrianBabin | UCPVEZgw-VbDRbLV1MRGVQNQ | 2929491549 | |||
N000179 | Grace Napolitano N000179 | GraceNapolitano | RepGraceNapolitano | UCPWjmiAIR04oQ8QMoOWcDtA | 161411080 | RepGraceNapolitano | repgracenapolitano | |
S000344 | Brad Sherman S000344 | BradSherman | 63158229861 | UCPisrz6-SLwVy2l9Mcy8kug | 30216513 | shermanca27 | ||
L000559 | James Langevin L000559 | JimLangevin | CongressmanJimLangevin | UCQ1sth-7umw1k-fSVqdfRTg | 18909919 | jimlangevin | ||
P000608 | Scott Peters P000608 | RepScottPeters | RepScottPeters | UCQK77QJxW7Xr-S3zqeMd-0g | 1135486501 | repscottpeters | ||
N000002 | Jerrold Nadler N000002 | RepJerryNadler | CongressmanNadler | UCQKj0qU1e7o2f5ftSh-c9aQ | 40302336 | congressmannadler | ||
G000577 | Garret Graves G000577 | RepGarretGraves | CongressmanGarretGraves | UCQLg9GGwTDluEFJtXf8seTA | 2951574214 | instagravesla | ||
H001058 | Bill Huizenga H001058 | RepHuizenga | RepHuizenga | UCQPlLLiMnysMmeJ5qUSSjQg | 233949261 | RepHuizenga | RepHuizenga | |
B001270 | Karen Bass B001270 | RepKarenBass | RepKarenBass | UCQZg7oxkV3Yag2emYPLhT2g | 239949176 | RepKarenBass | ||
B001298 | Don Bacon B001298 | RepDonBacon | RepDonBacon | UCR9abI1lZzAZ6HwQXc-dLFQ | 818975124460335106 | RepDonBacon | ||
D000628 | Neal Dunn D000628 | DrNealDunnFL2 | drnealdunnfl2 | UCRTGfrYP-RuDzJ2KGok7TRA | 815952318487298048 | |||
M001176 | Jeff Merkley M001176 | SenJeffMerkley | jeffmerkley | UCRoXttCJhMnLVCxCaa6VnNQ | 29201047 | SenatorJeffMerkley | senjeffmerkley | 501463589 |
M001159 | Cathy McMorris Rodgers M001159 | CathyMcMorris | mcmorrisrodgers | UCRp0lwIxAhq2Ia9_YgRWUkg | 17976923 | mcmorrisrodgers | cathymcmorris | |
T000250 | John Thune T000250 | SenJohnThune | UCRu6lpRfxhkDGUrKDgQNZYQ | 296361085 | johnthune | senjohnthune | ||
M001157 | Michael McCaul M001157 | RepMcCaul | michaeltmccaul | UCRw6sGE0PH7_FCeTT3PQRaA | 26424123 | MichaelTMcCaul | congressman_mccaul | |
G000559 | John Garamendi G000559 | RepGaramendi | repgaramendi | UCRym1qsO72C39gX6pBu4icg | 88806753 | garamendiCA10 | repgaramendi | |
R000599 | Raul Ruiz R000599 | RepRaulRuizMD | CongressmanRaulRuizMD | UCSDk-cyNPCo1iy6rweSPmBw | 1089859058 | repraulruiz | ||
H001038 | Brian Higgins H001038 | RepBrianHiggins | RepBrianHiggins | UCSGbv85HaaYYOrPGePtxwag | 33576489 | CongressmanHiggins | repbrianhiggins | |
S001184 | Tim Scott S001184 | SenatorTimScott | SenatorTimScott | UCSfAsbG80CNInSKrtpKoL-w | 217543151 | SenatorTimScott | SenatorTimScott | |
M001163 | Doris Matsui M001163 | DorisMatsui | doris.matsui | UCSqqxVkvskHq3cY2MCbTZsw | 38254095 | RepDorisMatsui | repdorismatsui |
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 );