social_media
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
528 rows sorted by twitter_id
This data as json, copyable, CSV (advanced)
id | legislator_id | youtube_id | twitter_id ▼ | youtube | instagram_id | |||
---|---|---|---|---|---|---|---|---|
J000294 | Hakeem Jeffries J000294 | RepJeffries | RepHakeemJeffries | UCYVmbsjoNbQ4j-PCQIYgpWQ | 467823431 | |||
F000062 | Dianne Feinstein F000062 | SenFeinstein | senatorfeinstein | UCtVC--6LR0ff2aOP8THpuEw | 476256944 | SenatorFeinstein | ||
R000486 | Lucille Roybal-Allard R000486 | RepRoybalAllard | RepRoybalAllard | UC_T_RXWeJ-smmpjdNLOaMcg | 479872233 | RepRoybalAllard | RepRoybalAllard | |
R000122 | John Reed R000122 | SenJackReed | SenJackReed | UCT_aFVtsjxPwWKfO-PW_hPw | 486694111 | SenatorReed | ||
T000464 | Jon Tester T000464 | SenatorTester | senatortester | UCgXAF-CON1coZFMxQkfj0fg | 515822213 | senatorjontester | ||
M001143 | Betty McCollum M001143 | BettyMcCollum04 | repbettymccollum | UC3sZJSdiZo2EBHbsOlsnI7A | 516880804 | BMcCollum04 | repbettymccollum | |
W000815 | Brad Wenstrup W000815 | RepBradWenstrup | RepBradWenstrup | UCaK7SeUvmHdHTMtF3HXb-jA | 518644221 | repbradwenstrup | repbradwenstrup | 305496379 |
R000395 | Harold Rogers R000395 | RepHalRogers | CongressmanHalRogers | UChVFKLZkRoHQDhp4zNvEezQ | 550401754 | RepHalRogers | rephalrogers | |
B001278 | Suzanne Bonamici B001278 | RepBonamici | congresswomanbonamici | UC0IkAeEiwgzSRTD1TDSvuBw | 558769636 | RepSuzanneBonamici | RepBonamici | |
D000631 | Madeleine Dean D000631 | RepDean | 567508925 | |||||
K000009 | Marcy Kaptur K000009 | RepMarcyKaptur | RepresentativeMarcyKaptur | UCIJUNf22o09nO02oQPLKQ6w | 581141508 | USRepMarcyKaptur | repmarcykaptur | |
L000564 | Doug Lamborn L000564 | RepDLamborn | CongressmanDougLamborn | UCaYsGYMniq4nwBBMKFIwsow | 584012853 | CongressmanLamborn | douglamborn | |
C000880 | Michael Crapo C000880 | MikeCrapo | mikecrapo | UCMHzKHg1BE7dEcFjnayw1lA | 600463589 | senatorcrapo | mikecrapo | 329357214 |
C001090 | Matthew Cartwright C001090 | RepCartwright | CongressmanMattCartwright | UCnAOvexSGLBnYidaFzguhTQ | 776664410 | repmattcartwright | ||
D000096 | Danny Davis D000096 | RepDannyDavis | CongressmanDKDavis | UCdhrT09_XMr31tuI8OcKsjQ | 789244177 | dannykdavis07 | ||
R000603 | David Rouzer R000603 | RepDavidRouzer | RepRouzer | UCBvOxpqoGi1HlHjX9v_gHZw | 834069080 | repdavidrouzer | ||
H001067 | Richard Hudson H001067 | RepRichHudson | RepRichHudson | UC9Q1qCvnQR7rHERjTjJl5Pg | 935033864 | RepRichHudson | ||
K000376 | Mike Kelly K000376 | MikeKellyPA | 191056827594903 | UCoz6u3ooQxoijsWvhoQ0D-A | 935368364 | repmikekelly | ||
S001193 | Eric Swalwell S001193 | RepSwalwell | CongressmanEricSwalwell | UCKvwsFNGD4sDkE_9g-2ft0w | 942156122 | ericswalwell | repswalwell | 338799200 |
H001076 | Margaret Hassan H001076 | SenatorHassan | SenatorHassan | 946549322 | ||||
B001287 | Ami Bera B001287 | RepBera | RepAmiBera | UClJCTCo53Zk6b4kUL-bbdzg | 950783972 | repamibera | ||
H001052 | Andy Harris H001052 | RepAndyHarrisMD | AndyHarrisMD | UCvUuV7FiJfJi1yux4qozgMg | 960962340 | RepAndyHarris | ||
C001095 | Tom Cotton C001095 | SenTomCotton | SenatorTomCotton | UCXEk6mokWBajIpNatbjnwSg | 968650362 | RepTomCotton | ||
W000817 | Elizabeth Warren W000817 | SenWarren | senatorelizabethwarren | UCTH9zV8Imw09J5bOoTR18_A | 970207298 | senelizabethwarren | senwarren | |
M001184 | Thomas Massie M001184 | RepThomasMassie | RepThomasMassie | UCpmXOtvvXC3GE8o9VxYNK7g | 975200486 | repthomasmassie | ||
J000295 | David Joyce J000295 | RepDaveJoyce | RepDaveJoyce | UCTu9xz2VYk-jtQv0TVsLyYA | 976969338 | repdavejoyce | repdavejoyce | 360743678 |
D000619 | Rodney Davis D000619 | RodneyDavis | RepRodneyDavis | UCiGPTfpwRxqQp0Bam5S8zwA | 993153006 | RepRodneyDavis | reprodneydavis | |
D000617 | Suzan DelBene D000617 | RepDelBene | RepDelBene | UCd00b7TpKDZIr-Ujhaktvjg | 995193054 | repdelbene | ||
F000471 | Scott Fitzgerald F000471 | RepFitzgerald | 1004891731 | |||||
T000472 | Mark Takano T000472 | RepMarkTakano | RepMarkTakano | UCJg4F1irmSFeKoXZBaZbX2w | 1037321378 | RepMarkTakano | repmarktakano | |
K000380 | Daniel Kildee K000380 | RepDanKildee | RepDanKildee | UC_KpQ-n3IT5dL5ul21XA9Yw | 1045110018 | RepDanKildee | repdankildee | 582887115 |
C001096 | Kevin Cramer C001096 | SenKevinCramer | CongressmanKevinCramer | UCqUPdO9XaAW-dvwwXKbIVdA | 1048784496 | kevincramer | repkevincramer | |
M001188 | Grace Meng M001188 | RepGraceMeng | repgracemeng | UCHg516zJKbIBtXFAJ0nu3XQ | 1051127714 | |||
W000812 | Ann Wagner W000812 | RepAnnWagner | RepAnnWagner | UCy2v2DXXvQnbRc8Zx77Dnsg | 1051446626 | repannwagner | ||
L000579 | Alan Lowenthal L000579 | RepLowenthal | RepLowenthal | UC-GgROtn5Hxm1H9a6qvy_Wg | 1055730738 | RepLowenthal | RepLowenthal | |
W000814 | Randy Weber W000814 | TXRandy14 | TXRandy14 | UCJSZRrAcd5i1bHLjR66PZdg | 1058051748 | TXRandy14 | TXRandy14 | |
R000597 | Tom Rice R000597 | RepTomRice | reptomrice | UCEmPVQphMGoXAfWJli68BEw | 1058345042 | RepTomRice | reptomrice | |
D000622 | Tammy Duckworth D000622 | SenDuckworth | SenDuckworth | UCYRWRvUxtjaHnFMCbdd94tg | 1058520120 | repduckworth | SenDuckworth | 1387939090 |
K000382 | Ann Kuster K000382 | RepAnnieKuster | CongresswomanAnnieKuster | UCYAD_Eti2b5gXSicbgPsBYA | 1058717720 | RepKuster | ||
K000381 | Derek Kilmer K000381 | RepDerekKilmer | derek.kilmer | 1058917562 | ||||
M001190 | Markwayne Mullin M001190 | RepMullin | RepMullin | UCLQlm-cbGbJj9baZC6oFsag | 1060370282 | |||
K000383 | Angus King K000383 | SenAngusKing | SenatorAngusSKingJr | UCpp6lGvrmt0XU_lnD4Ak0gA | 1068481578 | SenatorAngusKing | ||
L000578 | Doug LaMalfa L000578 | RepLaMalfa | RepLaMalfa | UCUzz1XDn862fxirervSB2Yw | 1069124515 | RepLaMalfa | repdouglamalfa | |
H001068 | Jared Huffman H001068 | RepHuffman | RepHuffman | UCJU6SP1ppp1ZhSiqZLiFgDA | 1071102246 | rephuffman | rephuffman | |
F000463 | Deb Fischer F000463 | SenatorFischer | senatordebfischer | UCrbEfZaG_WhB0PBHI1hefPQ | 1071402577 | senatordebfischer | senatorfischer | |
S001190 | Bradley Schneider S001190 | RepSchneider | CongressmanBradSchneider | 1071840474 | RepBradSchneider | repschneider | ||
S001192 | Chris Stewart S001192 | RepChrisStewart | RepChrisStewart | UCKYqzTvmQVWys-WhrCkbyPw | 1072008757 | repchrisstewart | repChrisStewart | |
M001185 | Sean Maloney M001185 | RepSeanMaloney | RepSeanMaloney | UCNiVzzf4Vz-vCMPBcnjGuXQ | 1072467470 | repseanpatrickmaloney | ||
V000131 | Marc Veasey V000131 | RepVeasey | CongressmanMarcVeasey | UC2CRp1KF5uljZyhDRPR-72Q | 1074129612 | marcveasey | repveasey | 676925345 |
C001098 | Ted Cruz C001098 | SenTedCruz | SenatorTedCruz | UCOTZ-6H1rri1lSsj6IzhUyw | 1074480192 | sentedcruz | ||
B001230 | Tammy Baldwin B001230 | SenatorBaldwin | senatortammybaldwin | UC_XjYCRbbI2_TDDjJidwk0Q | 1074518754 | witammybaldwin | senatorbaldwin | |
F000462 | Lois Frankel F000462 | RepLoisFrankel | RepLoisFrankel | UCEk5viAhxaW_2OK20-yBwzQ | 1077121945 | reploisfrankel | reploisfrankel | |
W000816 | Roger Williams W000816 | RepRWilliams | RepRogerWilliams | UCBtfmMMQarjtLB9U_pWMOhw | 1077446982 | |||
F000454 | Bill Foster F000454 | RepBillFoster | CongressmanBillFoster | UCicixINQr_-3cFHI2bJzFpQ | 1080509366 | RepBillFoster | ||
S001191 | Kyrsten Sinema S001191 | SenatorSinema | CongresswomanSinema | UC4NzhW7D4lQdukSGWmFnK9w | 1080844782 | repsinema | repsinema | |
B001282 | Garland Barr B001282 | RepAndyBarr | RepAndyBarr | UCVL2s6x7f7H0ZJ-uwU0pQ6Q | 1089334250 | RepAndyBarr | ||
R000599 | Raul Ruiz R000599 | RepRaulRuizMD | CongressmanRaulRuizMD | UCSDk-cyNPCo1iy6rweSPmBw | 1089859058 | repraulruiz | ||
B001286 | Cheri Bustos B001286 | RepCheri | RepCheri | UCrkOYuIsVeb4dvKeeO7jnaA | 1092979962 | RepCheri | ||
R000584 | James Risch R000584 | SenatorRisch | senatorjimrisch | UCncKW8xyT5UbPNO27YuQnBA | 1096059529 | SenatorJamesRisch | ||
H001046 | Martin Heinrich H001046 | MartinHeinrich | MartinHeinrich | UCBxh8IK5sMxY0Ln_0G2NYcg | 1099199839 | SenMartinHeinrich | senatormartinheinrich | 285288987 |
V000129 | David Valadao V000129 | RepDavidValadao | 1128514404 | |||||
P000608 | Scott Peters P000608 | RepScottPeters | RepScottPeters | UCQK77QJxW7Xr-S3zqeMd-0g | 1135486501 | repscottpeters | ||
W000797 | Debbie Wasserman Schultz W000797 | RepDWStweets | RepDWS | UCfHQiJVvMlYbVAxrMSLdO4w | 1140648348 | RepWassermanSchultz | RepDWSTweets | |
P000604 | Donald Payne P000604 | RepDonaldPayne | DonaldPayneJr | UCTG_SeYsOgbngjv1Donyu0w | 1155335864 | repdonaldpaynejr | ||
P000607 | Mark Pocan P000607 | RepMarkPocan | repmarkpocan | UCz5b47WER_u3dUGV_Zi70dQ | 1206227149 | repmarkpocan | repmarkpocan | 1422301608 |
S001176 | Steve Scalise S001176 | SteveScalise | RepSteveScalise | UCmYveHBVXVBRxl7GiCL-gjw | 1209417007 | RepSteveScalise | stevescalise | 1210937919 |
C001097 | Tony Cárdenas C001097 | RepCardenas | repcardenas | UCm6ug1-yvYGL0F6DvYxfFBA | 1222257180 | repcardenas | repcardenas | 1483357690 |
B001285 | Julia Brownley B001285 | RepBrownley | RepJuliaBrownley | UCFrC4Ouk5R6xQztS9PZin_A | 1243902714 | RepJuliaBrownley | ||
V000130 | Juan Vargas V000130 | RepJuanVargas | RepJuanVargas | UCpMthf8y7bEMJH_td0dznRQ | 1260172386 | RepJuanVargas | repjuanvargas | |
S001194 | Brian Schatz S001194 | SenBrianSchatz | SenBrianSchatz | UC8-mSYp2WqBiB_5iwtwKfow | 1262099252 | senbrianschatz | ||
K000385 | Robin Kelly K000385 | RepRobinKelly | reprobinkelly | UCLhcNPX2nNQLNzwKW0nEykg | 1339931490 | reprobinkelly | ||
W000800 | Peter Welch W000800 | PeterWelch | PeterWelch | UC0YfApJx6qNaAQ-ir93U8xA | 1410590874 | reppeterwelch | reppeterwelch | 1559860900 |
L000576 | Billy Long L000576 | USRepLong | Rep.Billy.Long | UCLQcbyxpHXXAsUJckscQY8g | 1444015610 | MOdistrict7 | ||
B001281 | Joyce Beatty B001281 | RepBeatty | RepJoyceBeatty | UCtVl3kb7Xvt3pY7l6x-M6LA | 1531521632 | repbeatty | 554027718 | |
S001195 | Jason Smith S001195 | RepJasonSmith | repjasonsmith | UCzj9-27Lr4gcqopmZAobXXg | 1623308912 | RepJasonSmith | ||
L000569 | Blaine Luetkemeyer L000569 | RepBlaine | BlaineLuetkemeyer | UCifiiQclKbBBrkSbCnN6REg | 1849261916 | BLuetkemeyer | ||
C001066 | Kathy Castor C001066 | USRepKCastor | USRepKathyCastor | UC_irxhmLqVenTFPxDxznG6g | 1880674038 | RepKathyCastor | ||
G000558 | Brett Guthrie G000558 | RepGuthrie | CongressmanGuthrie | UCdJhDw-YbdH0RHfWK0sIfiw | 1908143071 | BrettGuthrie | ||
B001288 | Cory Booker B001288 | SenBooker | UC6FlymqNS1VettnVZa7goPA | 2167097881 | SenCoryBooker | |||
C001101 | Katherine Clark C001101 | RepKClark | CongresswomanClark | UCgaI52w7QKI8LtkSeCCmSuw | 2293131060 | repkclark | ||
G000585 | Jimmy Gomez G000585 | RepJimmyGomez | RepJimmyGomez | 2371339658 | ||||
M001194 | John Moolenaar M001194 | RepMoolenaar | RepMoolenaar | UCnMvVN4a8roZu4crE0UW2DA | 2696643955 | RepMoolenaar | ||
P000610 | Stacey Plaskett P000610 | StaceyPlaskett | repstaceyplaskett | UC3V7biFZHDFHDFZy6cCSZUA | 2724095695 | stacey_plaskett | ||
Z000017 | Lee Zeldin Z000017 | RepLeeZeldin | RepLeeZeldin | UCHzZuesCPDka2NhZO8icqzA | 2750127259 | |||
W000821 | Bruce Westerman W000821 | RepWesterman | RepWesterman | UCNshPbmupCwP5a7Hi79jETQ | 2852998461 | |||
M001169 | Christopher Murphy M001169 | SenMurphyOffice | chrismurphyct | UCbcEa40PIFpLpdDe06n3F3Q | 2853793517 | senchrismurphy | ||
E000295 | Joni Ernst E000295 | SenJoniErnst | senjoniernst | UCLwrmtF_84FIcK3TyMs4MIw | 2856787757 | senjoniernst | 1582702853 | |
P000609 | Gary Palmer P000609 | USRepGaryPalmer | CongressmanGaryPalmer | UCYZfP-cNIvlJY3AcAc9OPpQ | 2861616083 | repgarypalmer | 1551536636 | |
B001297 | Ken Buck B001297 | RepKenBuck | repkenbuck | UCHK7Wcwij7NoxXGTeSHUWzg | 2862577383 | repkenbuck | ||
L000581 | Brenda Lawrence L000581 | RepLawrence | 395759603917487 | UCf0USy9GNigkB8O9sS1dodw | 2863006655 | repbrendalawrence | ||
S001198 | Dan Sullivan S001198 | SenDanSullivan | SenDanSullivan | UC7tXCm8gKlAhTFo2kuf5ylw | 2891210047 | sen_dansullivan | 1660873387 | |
L000583 | Barry Loudermilk L000583 | RepLoudermilk | reploudermilk | UC2Kfw8fjca8k3w3KpzL5tNg | 2914163523 | RepLoudermilk | ||
E000294 | Tom Emmer E000294 | RepTomEmmer | reptomemmer | 2914515430 | RepTomEmmer | reptomemmer | 1565640999 | |
A000370 | Alma Adams A000370 | RepAdams | CongresswomanAdams | UCPI9ao1Cr1nxEUD2r-usRjQ | 2916086925 | repadams | ||
B001291 | Brian Babin B001291 | RepBrianBabin | RepBrianBabin | UCPVEZgw-VbDRbLV1MRGVQNQ | 2929491549 | |||
N000189 | Dan Newhouse N000189 | RepNewhouse | RepNewhouse | UCllbsv_aoIaPS6W3aSonZlw | 2930635215 | |||
G000577 | Garret Graves G000577 | RepGarretGraves | CongressmanGarretGraves | UCQLg9GGwTDluEFJtXf8seTA | 2951574214 | instagravesla | ||
H001072 | J. Hill H001072 | RepFrenchHill | RepFrenchHill | UCT8uWroJtkwSsCJlVg0IKvQ | 2953974395 | repfrenchhill | ||
R000605 | Mike Rounds R000605 | SenatorRounds | SenatorMikeRounds | UC-pvzimyBdpdkcIfsicrfrQ | 2955485182 | |||
S001196 | Elise Stefanik S001196 | RepStefanik | RepEliseStefanik | UCHvf42C8Vw6QnjwO2L2ukKA | 2962813893 |
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 );