social_media
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
528 rows sorted by youtube
This data as json, copyable, CSV (advanced)
id | legislator_id | youtube_id | twitter_id | youtube ▼ | instagram_id | |||
---|---|---|---|---|---|---|---|---|
R000600 | Aumua Amata Radewagen R000600 | RepAmata | aumuaamata | UCGdrLQbt1PYDTPsampx4t1A | 3026622545 | |||
E000295 | Joni Ernst E000295 | SenJoniErnst | senjoniernst | UCLwrmtF_84FIcK3TyMs4MIw | 2856787757 | senjoniernst | 1582702853 | |
T000476 | Thom Tillis T000476 | SenThomTillis | SenatorThomTillis | UCUD9VGV4SSGWjGdbn37Ea2w | 2964174789 | senthomtillis | ||
S001217 | Rick Scott S001217 | SenRickScott | RickScottSenOffice | UC-Y9pFmW4PYGZHkC8lcqSkQ | 131546062 | |||
M000355 | Mitch McConnell M000355 | McConnellPress | mitchmcconnell | 339822881 | mcconnellpress | |||
L000570 | Ben Luján L000570 | SenatorLujan | 19318314 | |||||
C001047 | Shelley Capito C001047 | SenCapito | senshelley | UCbiXdR4XQ3vD9Xp5lfR9QXw | 193794406 | sencapito | 1640447624 | |
D000617 | Suzan DelBene D000617 | RepDelBene | RepDelBene | UCd00b7TpKDZIr-Ujhaktvjg | 995193054 | repdelbene | ||
M001190 | Markwayne Mullin M001190 | RepMullin | RepMullin | UCLQlm-cbGbJj9baZC6oFsag | 1060370282 | |||
M001188 | Grace Meng M001188 | RepGraceMeng | repgracemeng | UCHg516zJKbIBtXFAJ0nu3XQ | 1051127714 | |||
M001185 | Sean Maloney M001185 | RepSeanMaloney | RepSeanMaloney | UCNiVzzf4Vz-vCMPBcnjGuXQ | 1072467470 | repseanpatrickmaloney | ||
J000294 | Hakeem Jeffries J000294 | RepJeffries | RepHakeemJeffries | UCYVmbsjoNbQ4j-PCQIYgpWQ | 467823431 | |||
K000381 | Derek Kilmer K000381 | RepDerekKilmer | derek.kilmer | 1058917562 | ||||
C001090 | Matthew Cartwright C001090 | RepCartwright | CongressmanMattCartwright | UCnAOvexSGLBnYidaFzguhTQ | 776664410 | repmattcartwright | ||
W000812 | Ann Wagner W000812 | RepAnnWagner | RepAnnWagner | UCy2v2DXXvQnbRc8Zx77Dnsg | 1051446626 | repannwagner | ||
G000546 | Sam Graves G000546 | RepSamGraves | 118514606128 | UCdg2ybvoHsSW6t7iJnKHlNg | 29766367 | repsamgraves | ||
W000816 | Roger Williams W000816 | RepRWilliams | RepRogerWilliams | UCBtfmMMQarjtLB9U_pWMOhw | 1077446982 | |||
P000604 | Donald Payne P000604 | RepDonaldPayne | DonaldPayneJr | UCTG_SeYsOgbngjv1Donyu0w | 1155335864 | repdonaldpaynejr | ||
P000608 | Scott Peters P000608 | RepScottPeters | RepScottPeters | UCQK77QJxW7Xr-S3zqeMd-0g | 1135486501 | repscottpeters | ||
K000385 | Robin Kelly K000385 | RepRobinKelly | reprobinkelly | UCLhcNPX2nNQLNzwKW0nEykg | 1339931490 | reprobinkelly | ||
B001281 | Joyce Beatty B001281 | RepBeatty | RepJoyceBeatty | UCtVl3kb7Xvt3pY7l6x-M6LA | 1531521632 | repbeatty | 554027718 | |
S001203 | Tina Smith S001203 | SenTinaSmith | USSenTinaSmith | 941000686275387392 | ||||
C001101 | Katherine Clark C001101 | RepKClark | CongresswomanClark | UCgaI52w7QKI8LtkSeCCmSuw | 2293131060 | repkclark | ||
N000189 | Dan Newhouse N000189 | RepNewhouse | RepNewhouse | UCllbsv_aoIaPS6W3aSonZlw | 2930635215 | |||
L000583 | Barry Loudermilk L000583 | RepLoudermilk | reploudermilk | UC2Kfw8fjca8k3w3KpzL5tNg | 2914163523 | RepLoudermilk | ||
C001103 | Earl Carter C001103 | RepBuddyCarter | congressmanbuddycarter | UCHQm49T6ikD_ioMAt50AwKQ | 2973870195 | |||
B001295 | Mike Bost B001295 | RepBost | RepBost | UCYA1psY06vSf3QadHuCrmjQ | 2964877294 | |||
A000370 | Alma Adams A000370 | RepAdams | CongresswomanAdams | UCPI9ao1Cr1nxEUD2r-usRjQ | 2916086925 | repadams | ||
M001194 | John Moolenaar M001194 | RepMoolenaar | RepMoolenaar | UCnMvVN4a8roZu4crE0UW2DA | 2696643955 | RepMoolenaar | ||
S001196 | Elise Stefanik S001196 | RepStefanik | RepEliseStefanik | UCHvf42C8Vw6QnjwO2L2ukKA | 2962813893 | |||
R000603 | David Rouzer R000603 | RepDavidRouzer | RepRouzer | UCBvOxpqoGi1HlHjX9v_gHZw | 834069080 | repdavidrouzer | ||
P000609 | Gary Palmer P000609 | USRepGaryPalmer | CongressmanGaryPalmer | UCYZfP-cNIvlJY3AcAc9OPpQ | 2861616083 | repgarypalmer | 1551536636 | |
Z000017 | Lee Zeldin Z000017 | RepLeeZeldin | RepLeeZeldin | UCHzZuesCPDka2NhZO8icqzA | 2750127259 | |||
K000386 | John Katko K000386 | RepJohnKatko | RepJohnKatko | 2966765501 | ||||
W000821 | Bruce Westerman W000821 | RepWesterman | RepWesterman | UCNshPbmupCwP5a7Hi79jETQ | 2852998461 | |||
H001072 | J. Hill H001072 | RepFrenchHill | RepFrenchHill | UCT8uWroJtkwSsCJlVg0IKvQ | 2953974395 | repfrenchhill | ||
B001291 | Brian Babin B001291 | RepBrianBabin | RepBrianBabin | UCPVEZgw-VbDRbLV1MRGVQNQ | 2929491549 | |||
M001195 | Alexander Mooney M001195 | RepAlexMooney | CongressmanAlexMooney | UCw9CGkF4Re3areluI43TGyA | 2964526557 | repalexmooney | ||
B001297 | Ken Buck B001297 | RepKenBuck | repkenbuck | UCHK7Wcwij7NoxXGTeSHUWzg | 2862577383 | repkenbuck | ||
R000602 | Kathleen Rice R000602 | RepKathleenRice | RepKathleenRice | UCLYLmjrGtzzCFXMWPBxHAug | 2970462034 | |||
D000624 | Debbie Dingell D000624 | RepDebDingell | RepDebbieDingell | UCnoP3KLT-HOvzDfC1-I-9lQ | 2970279814 | repdingell | ||
T000474 | Norma Torres T000474 | NormaJTorres | RepNormaTorres | UCvWY4qKP6--o3pIJY7hhKDg | 236279233 | repnormatorres | ||
S001197 | Benjamin Sasse S001197 | SenSasse | SenatorSasse | UCYaNGwcM2Dl5yDcDqS6xV2g | 2962923040 | senatorsasse | 1636974433 | |
S001198 | Dan Sullivan S001198 | SenDanSullivan | SenDanSullivan | UC7tXCm8gKlAhTFo2kuf5ylw | 2891210047 | sen_dansullivan | 1660873387 | |
A000372 | Rick Allen A000372 | RepRickAllen | CongressmanRickAllen | UCZPoYXHFDAV17BGLMzGAmpg | 2964287128 | Rep_RickAllen | 1666787116 | |
R000605 | Mike Rounds R000605 | SenatorRounds | SenatorMikeRounds | UC-pvzimyBdpdkcIfsicrfrQ | 2955485182 | |||
B001296 | Brendan Boyle B001296 | CongBoyle | CongressmanBoyle | UCMP_Anj7lz4eZuSh8GwFqQQ | 4304448314 | |||
H001071 | Jody Hice H001071 | CongressmanHice | CongressmanJodyHice | UCzUMsS8DusN2QLpgweFthgQ | 2975091705 | rep_hice | ||
A000371 | Pete Aguilar A000371 | RepPeteAguilar | reppeteaguilar | UCxwbFLOlKDsXrwizV5jah7g | 3018670151 | |||
G000574 | Ruben Gallego G000574 | RepRubenGallego | RepRubenGallego | 2966570782 | reprubengallego | |||
P000610 | Stacey Plaskett P000610 | StaceyPlaskett | repstaceyplaskett | UC3V7biFZHDFHDFZy6cCSZUA | 2724095695 | stacey_plaskett | ||
W000822 | Bonnie Watson Coleman W000822 | RepBonnie | RepBonnie | UCrxEaX0VKZKwg3930du2D5A | 2968451607 | repbonnie | ||
L000582 | Ted Lieu L000582 | RepTedLieu | RepTedLieu | UC9qcJxTqfDNBnVul1IojlFg | 3044993235 | RepTedLieu | ||
G000577 | Garret Graves G000577 | RepGarretGraves | CongressmanGarretGraves | UCQLg9GGwTDluEFJtXf8seTA | 2951574214 | instagravesla | ||
D000623 | Mark DeSaulnier D000623 | RepDeSaulnier | RepMarkDeSaulnier | 2968007206 | repdesaulnier | |||
M001196 | Seth Moulton M001196 | RepMoulton | CongressmanSethMoulton | UC5w5qn7nj5Ljy69LTV7a_fQ | 3091316093 | repmoulton | ||
B001292 | Donald Beyer B001292 | RepDonBeyer | RepDonBeyer | UCPJGVbOVcAVGiBwq8qr_T9w | 2962868158 | repdonbeyer | ||
G000576 | Glenn Grothman G000576 | RepGrothman | RepGrothman | UCui4k83Cot4aeVW_8T33fgg | 2976606250 | |||
N000188 | Donald Norcross N000188 | DonaldNorcross | DonaldNorcrossNJ | UC7kXK_PyDiOT8YrdP0jYZHw | 3122099613 | donald_norcross | ||
L000581 | Brenda Lawrence L000581 | RepLawrence | 395759603917487 | UCf0USy9GNigkB8O9sS1dodw | 2863006655 | repbrendalawrence | ||
K000388 | Trent Kelly K000388 | RepTrentKelly | reptrentkelly | UCtDrz-8tdg4ZgOAQHToSWaQ | 3317799825 | reptrentkelly | ||
L000585 | Darin LaHood L000585 | RepLaHood | replahood | UCVRbtFwaBGcixZIkygtalRw | 3686482216 | |||
B001299 | Jim Banks B001299 | RepJimBanks | RepJimBanks | UC_FR6TySW9uxvhjozkis6Xg | 816131319033950208 | repjimbanks | ||
D000627 | Val Demings D000627 | RepValDemings | RepresentativeValDemings | UCkcshqwFNJG6XeduOforhig | 798973032362606600 | repvaldemings | ||
B001303 | Lisa Blunt Rochester B001303 | RepLBR | Rep.BluntRochester | 817050219007328258 | ||||
R000606 | Jamie Raskin R000606 | RepRaskin | repraskin | UChxDE6vho5BfBTOqiBsDmKg | 806906355214852096 | repraskin | ||
P000613 | Jimmy Panetta P000613 | RepJimmyPanetta | RepJimmyPanetta | UCmw-aERG51C96edMDPN7fXQ | 796736612554117120 | repjimmypanetta | ||
D000628 | Neal Dunn D000628 | DrNealDunnFL2 | drnealdunnfl2 | UCRTGfrYP-RuDzJ2KGok7TRA | 815952318487298048 | |||
B001300 | Nanette Barragán B001300 | RepBarragan | CongresswomanBarragan | 816833925456789505 | repbarragan | |||
B001302 | Andy Biggs B001302 | RepAndyBiggsAZ | RepAndyBiggs | UCqSq9kWOxk9yNTeILBCVC1w | 816652616625168388 | repandybiggs | ||
D000626 | Warren Davidson D000626 | WarrenDavidson | CongressmanWarrenDavidson | UCMzuyZWzk44YRNesFzPTeUw | 742735530287304704 | instawarrendavidson | ||
F000465 | A. Ferguson F000465 | RepDrewFerguson | RepDrewFerguson | UCuK7_j2sREWi_7wBAN477bg | 806583915012046854 | repdrewferguson | ||
G000581 | Vicente Gonzalez G000581 | RepGonzalez | USCongressmanVicenteGonzalez | UC5H6oYLKQ_xIXO5CG7fh4hw | 818536152588238849 | repvicentegonzaleztx | ||
G000583 | Josh Gottheimer G000583 | RepJoshG | RepJoshG | 815310506596691968 | RepJoshG | |||
C001113 | Catherine Cortez Masto C001113 | SenCortezMasto | SenatorCortezMasto | UCip_83SiKUqwnUT57VOXrCg | 811313565760163844 | |||
K000389 | Ro Khanna K000389 | RepRoKhanna | RepRoKhanna | UCr4KOYv1o1oEQhy1jhhm3pQ | 816298918468259841 | reprokhanna | ||
G000582 | Jenniffer González-Colón G000582 | RepJenniffer | RepJennifferGonzalezColon | UCZj99h3-GNKjGGeyp7AJeXw | 819744763020775425 | |||
H001074 | Trey Hollingsworth H001074 | RepTrey | reptrey | UCTgS8a_zLg8HpUnk5WXY5ag | 811986281177772032 | |||
A000375 | Jodey Arrington A000375 | RepArrington | JodeyArrington | 816284664658874368 | repjodeyarrington | |||
C001109 | Liz Cheney C001109 | RepLizCheney | replizcheney | UCvL57Zp99QdDllF-KGziUAA | 816719802328715264 | |||
S001201 | Thomas Suozzi S001201 | RepTomSuozzi | RepTomSuozzi | UCHjLmETJ7qXtciV7dlAzzgQ | 816705409486618624 | |||
B001305 | Ted Budd B001305 | RepTedBudd | RepTedBudd | 817138492614524928 | ||||
J000298 | Pramila Jayapal J000298 | RepJayapal | RepJayapal | UCmyD0_-2Oowkfwc_Raghclw | 815733290955112448 | repjayapal | ||
F000466 | Brian Fitzpatrick F000466 | RepBrianFitz | repbrianfitzpatrick | UCYMNcgHss4_Q5JY2vSvMpgw | 816303263586914304 | repbrianfitz | ||
O000171 | Tom O’Halleran O000171 | RepOHalleran | repohalleran | 808416682972770304 | repohalleran | |||
K000393 | John Kennedy K000393 | SenJohnKennedy | JohnKennedyLouisiana | 816683274076614656 | SenJohnKennedy | |||
L000586 | Al Lawson L000586 | RepAlLawsonJr | RepAlLawsonJr | 818472418620608512 | ||||
K000391 | Raja Krishnamoorthi K000391 | CongressmanRaja | congressmanraja | 814179031956488192 | congressmanraja | |||
H001076 | Margaret Hassan H001076 | SenatorHassan | SenatorHassan | 946549322 | ||||
E000297 | Adriano Espaillat E000297 | RepEspaillat | RepEspaillat | UCi0niBYFhEY70Dz8InbX5OQ | 817076257770835968 | repadrianoespaillat | ||
K000392 | David Kustoff K000392 | RepDavidKustoff | RepDavidKustoff | UCK6U4plOKKMrCjv_h59spGQ | 816012124505931780 | repdavidkustoff | ||
G000578 | Matt Gaetz G000578 | RepMattGaetz | CongressmanMattGaetz | UClqXcJew_A3s8qiX-T4a9CA | 818948638890217473 | Congressman_Matt_Gaetz | ||
G000579 | Mike Gallagher G000579 | RepGallagher | RepMikeGallagher | 815966620300480514 | ||||
C001108 | James Comer C001108 | RepJamesComer | congressmancomer | 1274852794206388225 | congressmancomer | |||
M001198 | Roger Marshall M001198 | SenatorMarshall | 1336344005588738052 | |||||
E000296 | Dwight Evans E000296 | RepDwightEvans | RepDwightEvans | 90639372 | repdwightevans | |||
R000609 | John Rutherford R000609 | RepRutherfordFL | RepRutherfordFL | 828977216595849216 | ||||
J000299 | Mike Johnson J000299 | RepMikeJohnson | RepMikeJohnson | UCzqBEpeIaDEfvAtsA53Fx2Q | 827279765287559171 | RepMikeJohnson | ||
R000608 | Jacky Rosen R000608 | SenJackyRosen | RepJackyRosen | 818554054309715969 | repjackyrosen | |||
C001110 | J. Correa C001110 | RepLouCorrea | RepLouCorrea | UCIKJJp4QJIDjnjodc23qKkw | 815985039485837312 | reploucorrea |
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 );