social_media
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
528 rows
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | youtube_id | twitter_id | youtube | instagram_id | |||
---|---|---|---|---|---|---|---|---|
M000194 | Nancy Mace M000194 | RepNancyMace | 1343597700542038017 | |||||
M000312 | James McGovern M000312 | RepMcGovern | RepJimMcGovern | UCpiUqp2ZF64tXqgR_EQo27g | 242426145 | repjimmcgovern | repmcgovern | |
M000317 | Nicole Malliotakis M000317 | RepMalliotakis | 1344750588026900481 | |||||
M000355 | Mitch McConnell M000355 | McConnellPress | mitchmcconnell | 339822881 | mcconnellpress | |||
M000639 | Robert Menendez M000639 | SenatorMenendez | senatormenendez | UC0PV0K9Z5a9p3D5917KF5fw | 18695134 | SenatorMenendezNJ | senatormenendez | 433044338 |
M000687 | Kweisi Mfume M000687 | RepKweisiMfume | RepKweisiMfume | 1276209702322438148 | ||||
M000871 | Tracey Mann M000871 | RepMann | 1345825008887721986 | |||||
M000934 | Jerry Moran M000934 | JerryMoran | jerrymoran | UC1oRxeUPam6-53wPBZ3N02A | 18632666 | senatorjerrymoran | senjerrymoran | 298271065 |
M001111 | Patty Murray M001111 | PattyMurray | UCb8jq3TvQ3AzKsexhWfFLoA | 293131808 | SenatorPattyMurray | senpattymurray | 426137845 | |
M001135 | Kathy Manning M001135 | RepKManning | 1337115670161608712 | |||||
M001136 | Lisa McClain M001136 | RepLisaMcClain | 1344032292432437248 | |||||
M001137 | Gregory Meeks M001137 | RepGregoryMeeks | gregorymeeksny05 | UCljJnwgQS6Z6-NypDyqKJZQ | 22812754 | gwmeeks | repgregorymeeks | |
M001143 | Betty McCollum M001143 | BettyMcCollum04 | repbettymccollum | UC3sZJSdiZo2EBHbsOlsnI7A | 516880804 | BMcCollum04 | repbettymccollum | |
M001153 | Lisa Murkowski M001153 | LisaMurkowski | SenLisaMurkowski | UCaigku16AErqvD0wRuwGb9A | 18061669 | senatormurkowski | senlisamurkowski | |
M001156 | Patrick McHenry M001156 | PatrickMcHenry | CongressmanMcHenry | UCY3PTRhkSH-eoltxPVZKD-w | 27676828 | CongressmanMcHenry | reppatrickmchenry | 353406473 |
M001157 | Michael McCaul M001157 | RepMcCaul | michaeltmccaul | UCRw6sGE0PH7_FCeTT3PQRaA | 26424123 | MichaelTMcCaul | congressman_mccaul | |
M001159 | Cathy McMorris Rodgers M001159 | CathyMcMorris | mcmorrisrodgers | UCRp0lwIxAhq2Ia9_YgRWUkg | 17976923 | mcmorrisrodgers | cathymcmorris | |
M001160 | Gwen Moore M001160 | RepGwenMoore | GwenSMoore | UCCs9o1XaSsCsqNpO0iO0_Ew | 22669526 | RepGwenMoore | RepGwenMoore | |
M001163 | Doris Matsui M001163 | DorisMatsui | doris.matsui | UCSqqxVkvskHq3cY2MCbTZsw | 38254095 | RepDorisMatsui | repdorismatsui | |
M001165 | Kevin McCarthy M001165 | GOPLeader | CongressmanKevinMcCarthy | UCdJUZUFSLJRlUpE-91-6DsA | 19739126 | repkevinmccarthy | RepKevinMcCarthy | |
M001166 | Jerry McNerney M001166 | RepMcNerney | jerrymcnerney | UClUOx6F8GKshxGBUBLkisug | 385429543 | RepJerryMcNerney | ||
M001169 | Christopher Murphy M001169 | SenMurphyOffice | chrismurphyct | UCbcEa40PIFpLpdDe06n3F3Q | 2853793517 | senchrismurphy | ||
M001176 | Jeff Merkley M001176 | SenJeffMerkley | jeffmerkley | UCRoXttCJhMnLVCxCaa6VnNQ | 29201047 | SenatorJeffMerkley | senjeffmerkley | 501463589 |
M001177 | Tom McClintock M001177 | RepMcClintock | 81125319109 | UCMh04KC4LfIzKoXh2Xws_pw | 50152441 | McClintockCA04 | ||
M001180 | David McKinley M001180 | RepMcKinley | RepMcKinley | UCt7BWx4b8ubXa-PneAu103g | 240427862 | RepDavidMcKinley | ||
M001183 | Joe Manchin M001183 | Sen_JoeManchin | JoeManchinIII | UCGyPK_ye2ptpzQgOjKIn7ag | 234374703 | SenatorJoeManchin | ||
M001184 | Thomas Massie M001184 | RepThomasMassie | RepThomasMassie | UCpmXOtvvXC3GE8o9VxYNK7g | 975200486 | repthomasmassie | ||
M001185 | Sean Maloney M001185 | RepSeanMaloney | RepSeanMaloney | UCNiVzzf4Vz-vCMPBcnjGuXQ | 1072467470 | repseanpatrickmaloney | ||
M001186 | Peter Meijer M001186 | RepMeijer | 1334164871420796928 | |||||
M001188 | Grace Meng M001188 | RepGraceMeng | repgracemeng | UCHg516zJKbIBtXFAJ0nu3XQ | 1051127714 | |||
M001190 | Markwayne Mullin M001190 | RepMullin | RepMullin | UCLQlm-cbGbJj9baZC6oFsag | 1060370282 | |||
M001194 | John Moolenaar M001194 | RepMoolenaar | RepMoolenaar | UCnMvVN4a8roZu4crE0UW2DA | 2696643955 | RepMoolenaar | ||
M001195 | Alexander Mooney M001195 | RepAlexMooney | CongressmanAlexMooney | UCw9CGkF4Re3areluI43TGyA | 2964526557 | repalexmooney | ||
M001196 | Seth Moulton M001196 | RepMoulton | CongressmanSethMoulton | UC5w5qn7nj5Ljy69LTV7a_fQ | 3091316093 | repmoulton | ||
M001198 | Roger Marshall M001198 | SenatorMarshall | 1336344005588738052 | |||||
M001199 | Brian Mast M001199 | RepBrianMast | repbrianmast | 814103950404239360 | repbrianmast | RepBrianMast | ||
M001202 | Stephanie Murphy M001202 | RepStephMurphy | RepStephMurphy | 796183515998068736 | RepStephMurphy | RepStephMurphy | ||
M001203 | Tom Malinowski M001203 | RepMalinowski | 1080898026418384897 | |||||
M001204 | Daniel Meuser M001204 | RepMeuser | 1080574793630527505 | |||||
M001205 | Carol Miller M001205 | RepCarolMiller | 1081318716573470720 | |||||
M001206 | Joseph Morelle M001206 | RepJoeMorelle | 1064595993222615040 | |||||
M001208 | Lucy McBath M001208 | RepLucyMcBath | 1082380458976051202 | |||||
M001210 | Gregory Murphy M001210 | RepGregMurphy | RepGregMurphy | 1173978070535024642 | ||||
M001211 | Mary Miller M001211 | RepMaryMiller | 1343656635907125250 | |||||
M001212 | Barry Moore M001212 | RepBarryMoore | 1339006078688825344 | |||||
M001213 | Blake Moore M001213 | RepBlakeMoore | 1337452596093587462 | |||||
M001214 | Frank Mrvan M001214 | RepMrvan | 1346205046036377601 | |||||
M001215 | Mariannette Miller-Meeks M001215 | RepMMM | 1345807954604412929 | |||||
N000002 | Jerrold Nadler N000002 | RepJerryNadler | CongressmanNadler | UCQKj0qU1e7o2f5ftSh-c9aQ | 40302336 | congressmannadler | ||
N000015 | Richard Neal N000015 | RepRichardNeal | reprichardneal | UCZVtTydu0-MSK6G12GaKA4g | 442824717 | RepRichardENeal | ||
N000026 | Troy Nehls N000026 | RepTroyNehls | 1347318288850825217 | |||||
N000147 | Eleanor Norton N000147 | EleanorNorton | CongresswomanNorton | UChRrAXUGylfxJjbquC6aUjQ | 23600262 | EleanorHNorton | ||
N000179 | Grace Napolitano N000179 | GraceNapolitano | RepGraceNapolitano | UCPWjmiAIR04oQ8QMoOWcDtA | 161411080 | RepGraceNapolitano | repgracenapolitano | |
N000188 | Donald Norcross N000188 | DonaldNorcross | DonaldNorcrossNJ | UC7kXK_PyDiOT8YrdP0jYZHw | 3122099613 | donald_norcross | ||
N000189 | Dan Newhouse N000189 | RepNewhouse | RepNewhouse | UCllbsv_aoIaPS6W3aSonZlw | 2930635215 | |||
N000190 | Ralph Norman N000190 | RepRalphNorman | RepRalphNorman | 880480631108644864 | ||||
N000191 | Joe Neguse N000191 | RepJoeNeguse | 1078749802765139968 | |||||
N000192 | Marie Newman N000192 | RepMarieNewman | 1343578440977494018 | |||||
O000019 | Jay Obernolte O000019 | JayObernolte | 272482466 | |||||
O000086 | Clarence Owens O000086 | RepBurgessOwens | 1344481217685692416 | |||||
O000171 | Tom O’Halleran O000171 | RepOHalleran | repohalleran | 808416682972770304 | repohalleran | |||
O000172 | Alexandria Ocasio-Cortez O000172 | RepAOC | 1079104563280527364 | |||||
O000173 | Ilhan Omar O000173 | Ilhan | 1082334352711790593 | |||||
O000174 | Jon Ossoff O000174 | SenOssoff | 1356714265894408196 | |||||
P000034 | Frank Pallone P000034 | FrankPallone | repfrankpallone | UCN0_wn9hs1LI3UKkji2PP2A | 31801993 | repfrankpallone | repfrankpallone | |
P000048 | August Pfluger P000048 | RepPfluger | 1341120751399809026 | |||||
P000096 | Bill Pascrell P000096 | BillPascrell | pascrell | UCIy1Ru8oA14aRjpq6L3i-EQ | 74508260 | RepPascrell | ||
P000145 | Alejandro Padilla P000145 | SenAlexPadilla | 1351236267707654145 | |||||
P000197 | Nancy Pelosi P000197 | SpeakerPelosi | NancyPelosi | UCxPeEcH0xaCK9nBK98EFhDg | 15764644 | nancypelosi | ||
P000449 | Robert Portman P000449 | SenRobPortman | senrobportman | UCwunkd8Zs-yAWKQwnwBp7ew | 18915145 | SenRobPortman | senrobportman | 370356159 |
P000523 | David Price P000523 | RepDavidEPrice | RepDavidEPrice | UCtX7bSXBLF9ge-Q955n5Vqw | 155669457 | RepDavidPrice | repdavideprice | |
P000593 | Ed Perlmutter P000593 | RepPerlmutter | RepPerlmutter | UCJXuMAzxngpEvDdvlE6wS5g | 20552026 | RepPerlmutter | ||
P000595 | Gary Peters P000595 | SenGaryPeters | SenGaryPeters | UC7LYNbnKSK2VZqQ98YROWHQ | 236511574 | RepGaryPeters | sengarypeters | 1640246681 |
P000597 | Chellie Pingree P000597 | ChelliePingree | ChelliePingree | UCLKaWFM7I84WcreDRhhhkVg | 14984637 | congresswomanpingree | ||
P000599 | Bill Posey P000599 | CongBillPosey | bill.posey15 | UCoUwUkDpe1ZYd6tiaZfiMuA | 25086658 | CongressmanPosey | ||
P000601 | Steven Palazzo P000601 | CongPalazzo | stevenpalazzo | UCtPOy2vRbN2nD8dQPSOTXeA | 299883942 | CongressmanPalazzo | congressmanpalazzo | |
P000603 | Rand Paul P000603 | SenRandPaul | SenatorRandPaul | UCeM9I-20oWUs8daIIpsNHoQ | 1298624375692894210 | SenatorRandPaul | senatorrandpaul | 541357095 |
P000604 | Donald Payne P000604 | RepDonaldPayne | DonaldPayneJr | UCTG_SeYsOgbngjv1Donyu0w | 1155335864 | repdonaldpaynejr | ||
P000605 | Scott Perry P000605 | RepScottPerry | repscottperry | UCzgrU5PT_HHRgf5hXPen4dQ | 18773159 | RepScottPerry | repscottperry | 519463466 |
P000607 | Mark Pocan P000607 | RepMarkPocan | repmarkpocan | UCz5b47WER_u3dUGV_Zi70dQ | 1206227149 | repmarkpocan | repmarkpocan | 1422301608 |
P000608 | Scott Peters P000608 | RepScottPeters | RepScottPeters | UCQK77QJxW7Xr-S3zqeMd-0g | 1135486501 | repscottpeters | ||
P000609 | Gary Palmer P000609 | USRepGaryPalmer | CongressmanGaryPalmer | UCYZfP-cNIvlJY3AcAc9OPpQ | 2861616083 | repgarypalmer | 1551536636 | |
P000610 | Stacey Plaskett P000610 | StaceyPlaskett | repstaceyplaskett | UC3V7biFZHDFHDFZy6cCSZUA | 2724095695 | stacey_plaskett | ||
P000613 | Jimmy Panetta P000613 | RepJimmyPanetta | RepJimmyPanetta | UCmw-aERG51C96edMDPN7fXQ | 796736612554117120 | repjimmypanetta | ||
P000614 | Chris Pappas P000614 | RepChrisPappas | 1067748650485497862 | |||||
P000615 | Greg Pence P000615 | RepGregPence | 1082369392229400576 | |||||
P000616 | Dean Phillips P000616 | RepDeanPhillips | 1061310112013434882 | |||||
P000617 | Ayanna Pressley P000617 | RepPressley | 1080584229510172678 | |||||
P000618 | Katie Porter P000618 | RepKatiePorter | 1081222837459996672 | |||||
Q000023 | Mike Quigley Q000023 | RepMikeQuigley | repmikequigley | UCDP13XegdoZ4bxYHxM34yAA | 56864092 | RepMikeQuigley | repmikequigley | 1403659583 |
R000103 | Matthew Rosendale R000103 | RepRosendale | 1344751420139040783 | |||||
R000122 | John Reed R000122 | SenJackReed | SenJackReed | UCT_aFVtsjxPwWKfO-PW_hPw | 486694111 | SenatorReed | ||
R000305 | Deborah Ross R000305 | RepDeborahRoss | 1348683154815655940 | |||||
R000395 | Harold Rogers R000395 | RepHalRogers | CongressmanHalRogers | UChVFKLZkRoHQDhp4zNvEezQ | 550401754 | RepHalRogers | rephalrogers | |
R000486 | Lucille Roybal-Allard R000486 | RepRoybalAllard | RepRoybalAllard | UC_T_RXWeJ-smmpjdNLOaMcg | 479872233 | RepRoybalAllard | RepRoybalAllard | |
R000515 | Bobby Rush R000515 | RepBobbyRush | congressmanbobbyrush | UCbWqxBnS_w_uFTdQAL0YH5g | 305216911 | CongressmanRush | ||
R000575 | Mike Rogers R000575 | RepMikeRogersAL | CongressmanMikeDRogers | UCH-WUWuY0_dlKwJDSqKTJsg | 33977070 | MikeRogersAL03 | repmikerogersal | 259435765 |
R000576 | C. Ruppersberger R000576 | Call_Me_Dutch | DutchRupp | UCk2S9iSHNpo1E1A7qZ0SPIw | 305620929 | ruppersberger | dutchruppersberger | |
R000577 | Tim Ryan R000577 | RepTimRyan | timryan | UCjAFlYCheFKjGg_Pxc2VOFA | 13491312 | timryanvision | ||
R000584 | James Risch R000584 | SenatorRisch | senatorjimrisch | UCncKW8xyT5UbPNO27YuQnBA | 1096059529 | SenatorJamesRisch |
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 );