social_media
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
528 rows sorted by twitter
This data as json, copyable, CSV (advanced)
id | legislator_id | twitter ▼ | youtube_id | twitter_id | youtube | instagram_id | ||
---|---|---|---|---|---|---|---|---|
M001212 | Barry Moore M001212 | RepBarryMoore | 1339006078688825344 | |||||
B001281 | Joyce Beatty B001281 | RepBeatty | RepJoyceBeatty | UCtVl3kb7Xvt3pY7l6x-M6LA | 1531521632 | repbeatty | 554027718 | |
C001118 | Ben Cline C001118 | RepBenCline | 1072158357237174272 | |||||
B000668 | Cliff Bentz B000668 | RepBentz | 1345788865911656454 | |||||
B001287 | Ami Bera B001287 | RepBera | RepAmiBera | UClJCTCo53Zk6b4kUL-bbdzg | 950783972 | repamibera | ||
V000134 | Beth Van Duyne V000134 | RepBethVanDuyne | 1339633259349745670 | |||||
B000740 | Stephanie Bice B000740 | RepBice | 1344260196227555334 | |||||
F000454 | Bill Foster F000454 | RepBillFoster | CongressmanBillFoster | UCicixINQr_-3cFHI2bJzFpQ | 1080509366 | RepBillFoster | ||
J000292 | Bill Johnson J000292 | RepBillJohnson | RepBillJohnson | UCtF08Ay71haDRoJosRN2P_Q | 211530910 | RepBillJohnson | repbilljohnson | 763495818 |
L000569 | Blaine Luetkemeyer L000569 | RepBlaine | BlaineLuetkemeyer | UCifiiQclKbBBrkSbCnN6REg | 1849261916 | BLuetkemeyer | ||
M001213 | Blake Moore M001213 | RepBlakeMoore | 1337452596093587462 | |||||
G000563 | Bob Gibbs G000563 | RepBobGibbs | RepBobGibbs | UC4J-kVbeE32Up-b_wTLEUmA | 234822928 | RepBobGibbs | repbobgibbs | |
G000595 | Robert Good G000595 | RepBobGood | 1345536897838436353 | |||||
R000515 | Bobby Rush R000515 | RepBobbyRush | congressmanbobbyrush | UCbWqxBnS_w_uFTdQAL0YH5g | 305216911 | CongressmanRush | ||
B000825 | Lauren Boebert B000825 | RepBoebert | 1342989756611907584 | |||||
B001278 | Suzanne Bonamici B001278 | RepBonamici | congresswomanbonamici | UC0IkAeEiwgzSRTD1TDSvuBw | 558769636 | RepSuzanneBonamici | RepBonamici | |
W000822 | Bonnie Watson Coleman W000822 | RepBonnie | RepBonnie | UCrxEaX0VKZKwg3930du2D5A | 2968451607 | repbonnie | ||
B001295 | Mike Bost B001295 | RepBost | RepBost | UCYA1psY06vSf3QadHuCrmjQ | 2964877294 | |||
B001312 | Carolyn Bourdeaux B001312 | RepBourdeaux | 1343620645452595200 | |||||
B001223 | Jamaal Bowman B001223 | RepBowman | 1344389506963808264 | |||||
W000815 | Brad Wenstrup W000815 | RepBradWenstrup | RepBradWenstrup | UCaK7SeUvmHdHTMtF3HXb-jA | 518644221 | repbradwenstrup | repbradwenstrup | 305496379 |
B001291 | Brian Babin B001291 | RepBrianBabin | RepBrianBabin | UCPVEZgw-VbDRbLV1MRGVQNQ | 2929491549 | |||
F000466 | Brian Fitzpatrick F000466 | RepBrianFitz | repbrianfitzpatrick | UCYMNcgHss4_Q5JY2vSvMpgw | 816303263586914304 | repbrianfitz | ||
H001038 | Brian Higgins H001038 | RepBrianHiggins | RepBrianHiggins | UCSGbv85HaaYYOrPGePtxwag | 33576489 | CongressmanHiggins | repbrianhiggins | |
M001199 | Brian Mast M001199 | RepBrianMast | repbrianmast | 814103950404239360 | repbrianmast | RepBrianMast | ||
B001285 | Julia Brownley B001285 | RepBrownley | RepJuliaBrownley | UCFrC4Ouk5R6xQztS9PZin_A | 1243902714 | RepJuliaBrownley | ||
S001213 | Bryan Steil S001213 | RepBryanSteil | 1075205691621720064 | |||||
C001103 | Earl Carter C001103 | RepBuddyCarter | congressmanbuddycarter | UCHQm49T6ikD_ioMAt50AwKQ | 2973870195 | |||
O000086 | Clarence Owens O000086 | RepBurgessOwens | 1344481217685692416 | |||||
C001112 | Salud Carbajal C001112 | RepCarbajal | repsaludcarbajal | 816157667882373120 | repcarbajal | repcarbajal | ||
C001097 | Tony Cárdenas C001097 | RepCardenas | repcardenas | UCm6ug1-yvYGL0F6DvYxfFBA | 1222257180 | repcardenas | repcardenas | 1483357690 |
G000593 | Carlos Gimenez G000593 | RepCarlos | 1343679195034103808 | |||||
M001205 | Carol Miller M001205 | RepCarolMiller | 1081318716573470720 | |||||
C001090 | Matthew Cartwright C001090 | RepCartwright | CongressmanMattCartwright | UCnAOvexSGLBnYidaFzguhTQ | 776664410 | repmattcartwright | ||
C001117 | Sean Casten C001117 | RepCasten | 1083472286089396224 | |||||
C001104 | Madison Cawthorn C001104 | RepCawthorn | 1344007696555663360 | |||||
B001286 | Cheri Bustos B001286 | RepCheri | RepCheri | UCrkOYuIsVeb4dvKeeO7jnaA | 1092979962 | RepCheri | ||
R000614 | Chip Roy R000614 | RepChipRoy | 1082790600292925440 | |||||
P000614 | Chris Pappas P000614 | RepChrisPappas | 1067748650485497862 | |||||
S001192 | Chris Stewart S001192 | RepChrisStewart | RepChrisStewart | UCKYqzTvmQVWys-WhrCkbyPw | 1072008757 | repchrisstewart | repChrisStewart | |
F000459 | Charles Fleischmann F000459 | RepChuck | repchuck | UCTtRrJkM-R-f2K0byCMvHgw | 235190657 | repchuck | ||
G000586 | Jesús García G000586 | RepChuyGarcia | 1082427779583541248 | |||||
C001084 | David Cicilline C001084 | RepCicilline | CongressmanDavidCicilline | UC3sCl46o8hYP69LnidNltuw | 462143773 | RepDavidCicilline | ||
A000378 | Cynthia Axne A000378 | RepCindyAxne | 1080865917377097728 | |||||
H001077 | Clay Higgins H001077 | RepClayHiggins | CongressmanClayHiggins | 843636970538618880 | RepClayHiggins | |||
C001061 | Emanuel Cleaver C001061 | RepCleaver | emanuelcleaverii | UCVC-7CLFjXczoihr5FxDLsw | 163570705 | repcleaver | ||
C001115 | Michael Cloud C001115 | RepCloudTX | 1039879658400112640 | |||||
C001068 | Steve Cohen C001068 | RepCohen | CongressmanSteveCohen | UC_NJlnsOBjOameUwZk0rvsA | 162069635 | repcohen | ||
A000376 | Colin Allred A000376 | RepColinAllred | 1078355119920562176 | |||||
L000588 | Conor Lamb L000588 | RepConorLamb | RepConorLamb | UC7hX59n_ixS1Bz3f8Je02yA | 984456621417000960 | |||
B001224 | Cori Bush B001224 | RepCori | 1002630999052865536 | |||||
C001063 | Henry Cuellar C001063 | RepCuellar | 152569121550 | UCVgEOdJx3tyILO9EjZ-heEQ | 210926192 | henrycuellar | ||
L000564 | Doug Lamborn L000564 | RepDLamborn | CongressmanDougLamborn | UCaYsGYMniq4nwBBMKFIwsow | 584012853 | CongressmanLamborn | douglamborn | |
L000589 | Debbie Lesko L000589 | RepDLesko | RepDebbieLesko | 996094929733652481 | ||||
W000797 | Debbie Wasserman Schultz W000797 | RepDWStweets | RepDWS | UCfHQiJVvMlYbVAxrMSLdO4w | 1140648348 | RepWassermanSchultz | RepDWSTweets | |
B001311 | Dan Bishop B001311 | RepDanBishop | repdanbishop | 1176522535531360257 | ||||
C001120 | Dan Crenshaw C001120 | RepDanCrenshaw | 1080894931311431682 | |||||
K000380 | Daniel Kildee K000380 | RepDanKildee | RepDanKildee | UC_KpQ-n3IT5dL5ul21XA9Yw | 1045110018 | RepDanKildee | repdankildee | 582887115 |
D000096 | Danny Davis D000096 | RepDannyDavis | CongressmanDKDavis | UCdhrT09_XMr31tuI8OcKsjQ | 789244177 | dannykdavis07 | ||
S001200 | Darren Soto S001200 | RepDarrenSoto | CongressmanDarrenSoto | 818713465653051392 | repdarrensoto | RepDarrenSoto | ||
J000295 | David Joyce J000295 | RepDaveJoyce | RepDaveJoyce | UCTu9xz2VYk-jtQv0TVsLyYA | 976969338 | repdavejoyce | repdavejoyce | 360743678 |
S001183 | David Schweikert S001183 | RepDavid | repdavidschweikert | UCVvuNVzkOUp7p_Pzkc6Zuvw | 229197216 | RepDavidSchweikert | repdavid | 181147397 |
P000523 | David Price P000523 | RepDavidEPrice | RepDavidEPrice | UCtX7bSXBLF9ge-Q955n5Vqw | 155669457 | RepDavidPrice | repdavideprice | |
K000392 | David Kustoff K000392 | RepDavidKustoff | RepDavidKustoff | UCK6U4plOKKMrCjv_h59spGQ | 816012124505931780 | repdavidkustoff | ||
R000603 | David Rouzer R000603 | RepDavidRouzer | RepRouzer | UCBvOxpqoGi1HlHjX9v_gHZw | 834069080 | repdavidrouzer | ||
S001157 | David Scott S001157 | RepDavidScott | 113303673339 | UCgf28zRkLSqAUiPuJhGdF0w | 168673083 | RepDavidScott | RepDavidScott | |
T000483 | David Trone T000483 | RepDavidTrone | 1080573351914061825 | |||||
V000129 | David Valadao V000129 | RepDavidValadao | 1128514404 | |||||
D000629 | Sharice Davids D000629 | RepDavids | 1080516116395499522 | |||||
D000623 | Mark DeSaulnier D000623 | RepDeSaulnier | RepMarkDeSaulnier | 2968007206 | repdesaulnier | |||
D000631 | Madeleine Dean D000631 | RepDean | 567508925 | |||||
P000616 | Dean Phillips P000616 | RepDeanPhillips | 1061310112013434882 | |||||
D000624 | Debbie Dingell D000624 | RepDebDingell | RepDebbieDingell | UCnoP3KLT-HOvzDfC1-I-9lQ | 2970279814 | repdingell | ||
R000305 | Deborah Ross R000305 | RepDeborahRoss | 1348683154815655940 | |||||
D000617 | Suzan DelBene D000617 | RepDelBene | RepDelBene | UCd00b7TpKDZIr-Ujhaktvjg | 995193054 | repdelbene | ||
K000381 | Derek Kilmer K000381 | RepDerekKilmer | derek.kilmer | 1058917562 | ||||
D000197 | Diana DeGette D000197 | RepDianaDeGette | DianaDeGette | UCWFQCRTHwsHg9P1Hf-EQtew | 28599820 | RepDianaDeGette | ||
T000468 | Dina Titus T000468 | RepDinaTitus | CongresswomanTitus | UC_US4jNqECuMSNrB7yVCbbw | 122174004 | CongresswomanTitus | dinatitusnv | 1110185253 |
B001298 | Don Bacon B001298 | RepDonBacon | RepDonBacon | UCR9abI1lZzAZ6HwQXc-dLFQ | 818975124460335106 | RepDonBacon | ||
B001292 | Donald Beyer B001292 | RepDonBeyer | RepDonBeyer | UCPJGVbOVcAVGiBwq8qr_T9w | 2962868158 | repdonbeyer | ||
P000604 | Donald Payne P000604 | RepDonaldPayne | DonaldPayneJr | UCTG_SeYsOgbngjv1Donyu0w | 1155335864 | repdonaldpaynejr | ||
D000032 | Byron Donalds D000032 | RepDonaldsPress | 1343968646050283522 | |||||
F000465 | A. Ferguson F000465 | RepDrewFerguson | RepDrewFerguson | UCuK7_j2sREWi_7wBAN477bg | 806583915012046854 | repdrewferguson | ||
J000301 | Dusty Johnson J000301 | RepDustyJohnson | 1074782372594413569 | |||||
E000296 | Dwight Evans E000296 | RepDwightEvans | RepDwightEvans | 90639372 | repdwightevans | |||
J000126 | Eddie Johnson J000126 | RepEBJ | CongresswomanEBJtx30 | UCVKp8BtjW708H4eXJJQgUYw | 168502762 | RepEddieBJohnson | repebj | |
C001055 | Ed Case C001055 | RepEdCase | 1081350574589833221 | |||||
L000591 | Elaine Luria L000591 | RepElaineLuria | 1080292515939565568 | |||||
E000071 | Jake Ellzey E000071 | RepEllzey | 1366523868253458437 | |||||
E000299 | Veronica Escobar E000299 | RepEscobar | 1075517806551154689 | |||||
E000297 | Adriano Espaillat E000297 | RepEspaillat | RepEspaillat | UCi0niBYFhEY70Dz8InbX5OQ | 817076257770835968 | repadrianoespaillat | ||
F000446 | Randy Feenstra F000446 | RepFeenstra | 1345135363761852416 | |||||
F000470 | Michelle Fischbach F000470 | RepFischbach | 1344375287484723205 | |||||
F000471 | Scott Fitzgerald F000471 | RepFitzgerald | 1004891731 | |||||
F000468 | Lizzie Fletcher F000468 | RepFletcher | 1075904377221722113 | |||||
L000491 | Frank Lucas L000491 | RepFrankLucas | RepFrankLucas | UCdYZbKY8pkWAThqwC3fdVMg | 242772524 | RepFrankLucas | ||
F000472 | C. Franklin F000472 | RepFranklin | 1343664721384398849 | |||||
K000395 | Fred Keller K000395 | RepFredKeller | CongressmanFredKeller | UC_IluBx9m7HWoNhEYSoPQNQ | 1136060761422405633 | repfredkeller | ||
U000031 | Fred Upton U000031 | RepFredUpton | RepFredUpton | UCsN16IzEo4ViZNEMgeCrQ7w | 124224165 | RepFredUpton | RepFredUpton | |
H001072 | J. Hill H001072 | RepFrenchHill | RepFrenchHill | UCT8uWroJtkwSsCJlVg0IKvQ | 2953974395 | repfrenchhill |
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 );