social_media
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
528 rows sorted by id descending
This data as json, copyable, CSV (advanced)
id ▲ | legislator_id | youtube_id | twitter_id | youtube | instagram_id | |||
---|---|---|---|---|---|---|---|---|
M001185 | Sean Maloney M001185 | RepSeanMaloney | RepSeanMaloney | UCNiVzzf4Vz-vCMPBcnjGuXQ | 1072467470 | repseanpatrickmaloney | ||
M001184 | Thomas Massie M001184 | RepThomasMassie | RepThomasMassie | UCpmXOtvvXC3GE8o9VxYNK7g | 975200486 | repthomasmassie | ||
M001183 | Joe Manchin M001183 | Sen_JoeManchin | JoeManchinIII | UCGyPK_ye2ptpzQgOjKIn7ag | 234374703 | SenatorJoeManchin | ||
M001180 | David McKinley M001180 | RepMcKinley | RepMcKinley | UCt7BWx4b8ubXa-PneAu103g | 240427862 | RepDavidMcKinley | ||
M001177 | Tom McClintock M001177 | RepMcClintock | 81125319109 | UCMh04KC4LfIzKoXh2Xws_pw | 50152441 | McClintockCA04 | ||
M001176 | Jeff Merkley M001176 | SenJeffMerkley | jeffmerkley | UCRoXttCJhMnLVCxCaa6VnNQ | 29201047 | SenatorJeffMerkley | senjeffmerkley | 501463589 |
M001169 | Christopher Murphy M001169 | SenMurphyOffice | chrismurphyct | UCbcEa40PIFpLpdDe06n3F3Q | 2853793517 | senchrismurphy | ||
M001166 | Jerry McNerney M001166 | RepMcNerney | jerrymcnerney | UClUOx6F8GKshxGBUBLkisug | 385429543 | RepJerryMcNerney | ||
M001165 | Kevin McCarthy M001165 | GOPLeader | CongressmanKevinMcCarthy | UCdJUZUFSLJRlUpE-91-6DsA | 19739126 | repkevinmccarthy | RepKevinMcCarthy | |
M001163 | Doris Matsui M001163 | DorisMatsui | doris.matsui | UCSqqxVkvskHq3cY2MCbTZsw | 38254095 | RepDorisMatsui | repdorismatsui | |
M001160 | Gwen Moore M001160 | RepGwenMoore | GwenSMoore | UCCs9o1XaSsCsqNpO0iO0_Ew | 22669526 | RepGwenMoore | RepGwenMoore | |
M001159 | Cathy McMorris Rodgers M001159 | CathyMcMorris | mcmorrisrodgers | UCRp0lwIxAhq2Ia9_YgRWUkg | 17976923 | mcmorrisrodgers | cathymcmorris | |
M001157 | Michael McCaul M001157 | RepMcCaul | michaeltmccaul | UCRw6sGE0PH7_FCeTT3PQRaA | 26424123 | MichaelTMcCaul | congressman_mccaul | |
M001156 | Patrick McHenry M001156 | PatrickMcHenry | CongressmanMcHenry | UCY3PTRhkSH-eoltxPVZKD-w | 27676828 | CongressmanMcHenry | reppatrickmchenry | 353406473 |
M001153 | Lisa Murkowski M001153 | LisaMurkowski | SenLisaMurkowski | UCaigku16AErqvD0wRuwGb9A | 18061669 | senatormurkowski | senlisamurkowski | |
M001143 | Betty McCollum M001143 | BettyMcCollum04 | repbettymccollum | UC3sZJSdiZo2EBHbsOlsnI7A | 516880804 | BMcCollum04 | repbettymccollum | |
M001137 | Gregory Meeks M001137 | RepGregoryMeeks | gregorymeeksny05 | UCljJnwgQS6Z6-NypDyqKJZQ | 22812754 | gwmeeks | repgregorymeeks | |
M001136 | Lisa McClain M001136 | RepLisaMcClain | 1344032292432437248 | |||||
M001135 | Kathy Manning M001135 | RepKManning | 1337115670161608712 | |||||
M001111 | Patty Murray M001111 | PattyMurray | UCb8jq3TvQ3AzKsexhWfFLoA | 293131808 | SenatorPattyMurray | senpattymurray | 426137845 | |
M000934 | Jerry Moran M000934 | JerryMoran | jerrymoran | UC1oRxeUPam6-53wPBZ3N02A | 18632666 | senatorjerrymoran | senjerrymoran | 298271065 |
M000871 | Tracey Mann M000871 | RepMann | 1345825008887721986 | |||||
M000687 | Kweisi Mfume M000687 | RepKweisiMfume | RepKweisiMfume | 1276209702322438148 | ||||
M000639 | Robert Menendez M000639 | SenatorMenendez | senatormenendez | UC0PV0K9Z5a9p3D5917KF5fw | 18695134 | SenatorMenendezNJ | senatormenendez | 433044338 |
M000355 | Mitch McConnell M000355 | McConnellPress | mitchmcconnell | 339822881 | mcconnellpress | |||
M000317 | Nicole Malliotakis M000317 | RepMalliotakis | 1344750588026900481 | |||||
M000312 | James McGovern M000312 | RepMcGovern | RepJimMcGovern | UCpiUqp2ZF64tXqgR_EQo27g | 242426145 | repjimmcgovern | repmcgovern | |
M000194 | Nancy Mace M000194 | RepNancyMace | 1343597700542038017 | |||||
M000133 | Edward Markey M000133 | SenMarkey | EdJMarkey | UCT1ujew5yQy2uMhGrjiKHoA | 21406834 | RepMarkey | ||
M000087 | Carolyn Maloney M000087 | RepMaloney | RepCarolynMaloney | 258900199 | carolynbmaloney | repmaloney | ||
L000595 | Julia Letlow L000595 | RepJuliaLetlow | 1382395679700439041 | |||||
L000593 | Mike Levin L000593 | RepMikeLevin | 1072134139560620033 | |||||
L000592 | Andy Levin L000592 | RepAndyLevin | 1080277407867772930 | |||||
L000591 | Elaine Luria L000591 | RepElaineLuria | 1080292515939565568 | |||||
L000590 | Susie Lee L000590 | RepSusieLee | 1079061579973439488 | |||||
L000589 | Debbie Lesko L000589 | RepDLesko | RepDebbieLesko | 996094929733652481 | ||||
L000588 | Conor Lamb L000588 | RepConorLamb | RepConorLamb | UC7hX59n_ixS1Bz3f8Je02yA | 984456621417000960 | |||
L000586 | Al Lawson L000586 | RepAlLawsonJr | RepAlLawsonJr | 818472418620608512 | ||||
L000585 | Darin LaHood L000585 | RepLaHood | replahood | UCVRbtFwaBGcixZIkygtalRw | 3686482216 | |||
L000583 | Barry Loudermilk L000583 | RepLoudermilk | reploudermilk | UC2Kfw8fjca8k3w3KpzL5tNg | 2914163523 | RepLoudermilk | ||
L000582 | Ted Lieu L000582 | RepTedLieu | RepTedLieu | UC9qcJxTqfDNBnVul1IojlFg | 3044993235 | RepTedLieu | ||
L000581 | Brenda Lawrence L000581 | RepLawrence | 395759603917487 | UCf0USy9GNigkB8O9sS1dodw | 2863006655 | repbrendalawrence | ||
L000579 | Alan Lowenthal L000579 | RepLowenthal | RepLowenthal | UC-GgROtn5Hxm1H9a6qvy_Wg | 1055730738 | RepLowenthal | RepLowenthal | |
L000578 | Doug LaMalfa L000578 | RepLaMalfa | RepLaMalfa | UCUzz1XDn862fxirervSB2Yw | 1069124515 | RepLaMalfa | repdouglamalfa | |
L000577 | Mike Lee L000577 | SenMikeLee | senatormikelee | UCplVxs_j_sLAt0fkplXcl4A | 88784440 | senatormikelee | senmikelee | 391361701 |
L000576 | Billy Long L000576 | USRepLong | Rep.Billy.Long | UCLQcbyxpHXXAsUJckscQY8g | 1444015610 | MOdistrict7 | ||
L000575 | James Lankford L000575 | SenatorLankford | SenatorLankford | UCz8T6sK5fEycyWmVz6Vpe5Q | 225921757 | SenatorLankford | senatorlankford | 1552251018 |
L000571 | Cynthia Lummis L000571 | SenLummis | 22831059 | |||||
L000570 | Ben Luján L000570 | SenatorLujan | 19318314 | |||||
L000569 | Blaine Luetkemeyer L000569 | RepBlaine | BlaineLuetkemeyer | UCifiiQclKbBBrkSbCnN6REg | 1849261916 | BLuetkemeyer | ||
L000566 | Robert Latta L000566 | BobLatta | boblatta | UCVSBVHoWu-eWnBBQaMKZ_sQ | 15394954 | CongressmanBobLatta | boblatta | 26367713 |
L000564 | Doug Lamborn L000564 | RepDLamborn | CongressmanDougLamborn | UCaYsGYMniq4nwBBMKFIwsow | 584012853 | CongressmanLamborn | douglamborn | |
L000562 | Stephen Lynch L000562 | RepStephenLynch | repstephenlynch | UCxL4zG0YWqC5XTO4af_FOgw | 310310133 | RepLynch | repstephenlynch | |
L000560 | Rick Larsen L000560 | RepRickLarsen | RepRickLarsen | UCMv7LsJtiyO4AJcbRux5CxQ | 404132211 | congressmanlarsen | repricklarsen | |
L000559 | James Langevin L000559 | JimLangevin | CongressmanJimLangevin | UCQ1sth-7umw1k-fSVqdfRTg | 18909919 | jimlangevin | ||
L000557 | John Larson L000557 | RepJohnLarson | RepJohnLarson | UCGPsvFF-9WfpdRSCcCrPLiQ | 50452197 | RepJohnLarson | RepJohnBLarson | |
L000551 | Barbara Lee L000551 | RepBarbaraLee | RepBarbaraLee | UCnRgK2MXAQOUau0JXqseeNA | 248735463 | RepLee | repbarbaralee | 1415801245 |
L000491 | Frank Lucas L000491 | RepFrankLucas | RepFrankLucas | UCdYZbKY8pkWAThqwC3fdVMg | 242772524 | RepFrankLucas | ||
L000397 | Zoe Lofgren L000397 | RepZoeLofgren | zoelofgren | UCOaQ79adORFcaTuJZoIFuZQ | 267938462 | RepZoeLofgren | ||
L000273 | Teresa Leger Fernandez L000273 | RepTeresaLF | 1345147845926670337 | |||||
L000266 | Jacob LaTurner L000266 | RepLaTurner | 1345850704800468993 | |||||
L000174 | Patrick Leahy L000174 | SenatorLeahy | SenatorPatrickLeahy | UC46QHVobf7FO-tWehsRoDog | 242836537 | SenatorPatrickLeahy | senatorleahy | |
K000397 | Young Kim K000397 | RepYoungKim | 1344677401465397249 | |||||
K000396 | Kaialiʻi Kahele K000396 | RepKahele | 1351966874377056257 | |||||
K000395 | Fred Keller K000395 | RepFredKeller | CongressmanFredKeller | UC_IluBx9m7HWoNhEYSoPQNQ | 1136060761422405633 | repfredkeller | ||
K000394 | Andy Kim K000394 | RepAndyKimNJ | 1078771848882593793 | |||||
K000393 | John Kennedy K000393 | SenJohnKennedy | JohnKennedyLouisiana | 816683274076614656 | SenJohnKennedy | |||
K000392 | David Kustoff K000392 | RepDavidKustoff | RepDavidKustoff | UCK6U4plOKKMrCjv_h59spGQ | 816012124505931780 | repdavidkustoff | ||
K000391 | Raja Krishnamoorthi K000391 | CongressmanRaja | congressmanraja | 814179031956488192 | congressmanraja | |||
K000389 | Ro Khanna K000389 | RepRoKhanna | RepRoKhanna | UCr4KOYv1o1oEQhy1jhhm3pQ | 816298918468259841 | reprokhanna | ||
K000388 | Trent Kelly K000388 | RepTrentKelly | reptrentkelly | UCtDrz-8tdg4ZgOAQHToSWaQ | 3317799825 | reptrentkelly | ||
K000386 | John Katko K000386 | RepJohnKatko | RepJohnKatko | 2966765501 | ||||
K000385 | Robin Kelly K000385 | RepRobinKelly | reprobinkelly | UCLhcNPX2nNQLNzwKW0nEykg | 1339931490 | reprobinkelly | ||
K000384 | Timothy Kaine K000384 | SenatorKaine | UC27LgTZlUnBQoNEQFZdn9LA | SenatorTimKaine | ||||
K000383 | Angus King K000383 | SenAngusKing | SenatorAngusSKingJr | UCpp6lGvrmt0XU_lnD4Ak0gA | 1068481578 | SenatorAngusKing | ||
K000382 | Ann Kuster K000382 | RepAnnieKuster | CongresswomanAnnieKuster | UCYAD_Eti2b5gXSicbgPsBYA | 1058717720 | RepKuster | ||
K000381 | Derek Kilmer K000381 | RepDerekKilmer | derek.kilmer | 1058917562 | ||||
K000380 | Daniel Kildee K000380 | RepDanKildee | RepDanKildee | UC_KpQ-n3IT5dL5ul21XA9Yw | 1045110018 | RepDanKildee | repdankildee | 582887115 |
K000378 | Adam Kinzinger K000378 | RepKinzinger | RepKinzinger | UCjDHxyjndxxhjuPWyEBc7UA | 219429281 | RepAdamKinzinger | ||
K000377 | Mark Kelly K000377 | SenMarkKelly | SenMarkKelly | 1324926274888888320 | ||||
K000376 | Mike Kelly K000376 | MikeKellyPA | 191056827594903 | UCoz6u3ooQxoijsWvhoQ0D-A | 935368364 | repmikekelly | ||
K000375 | William Keating K000375 | USRepKeating | Congressman.Keating | UC7KPV4xdxO2dms9vl6tETmg | 232992031 | RepBillKeating | ||
K000368 | Ann Kirkpatrick K000368 | RepKirkpatrick | 1081240074946252801 | |||||
K000367 | Amy Klobuchar K000367 | SenAmyKlobuchar | UCvdeJsDsV51tFb_hVqvtYGA | 22044727 | senatorklobuchar | |||
K000188 | Ron Kind K000188 | RepRonKind | repronkind | UC0_BilariURHwSHf9baGykg | 112740986 | RepRonKind | ||
K000009 | Marcy Kaptur K000009 | RepMarcyKaptur | RepresentativeMarcyKaptur | UCIJUNf22o09nO02oQPLKQ6w | 581141508 | USRepMarcyKaptur | repmarcykaptur | |
J000306 | Mondaire Jones J000306 | RepMondaire | 1345883634046279681 | |||||
J000305 | Sara Jacobs J000305 | RepSaraJacobs | 1345103905869455361 | |||||
J000304 | Ronny Jackson J000304 | RepRonnyJackson | 1341903465610686464 | |||||
J000302 | John Joyce J000302 | RepJohnJoyce | 1082311988926124036 | |||||
J000301 | Dusty Johnson J000301 | RepDustyJohnson | 1074782372594413569 | |||||
J000299 | Mike Johnson J000299 | RepMikeJohnson | RepMikeJohnson | UCzqBEpeIaDEfvAtsA53Fx2Q | 827279765287559171 | RepMikeJohnson | ||
J000298 | Pramila Jayapal J000298 | RepJayapal | RepJayapal | UCmyD0_-2Oowkfwc_Raghclw | 815733290955112448 | repjayapal | ||
J000295 | David Joyce J000295 | RepDaveJoyce | RepDaveJoyce | UCTu9xz2VYk-jtQv0TVsLyYA | 976969338 | repdavejoyce | repdavejoyce | 360743678 |
J000294 | Hakeem Jeffries J000294 | RepJeffries | RepHakeemJeffries | UCYVmbsjoNbQ4j-PCQIYgpWQ | 467823431 | |||
J000293 | Ron Johnson J000293 | SenRonJohnson | senronjohnson | UCG9XyTVtOAs7VX_q_QVHoaw | 233737858 | SenatorRonJohnson | senronjohnson | |
J000292 | Bill Johnson J000292 | RepBillJohnson | RepBillJohnson | UCtF08Ay71haDRoJosRN2P_Q | 211530910 | RepBillJohnson | repbilljohnson | 763495818 |
J000289 | Jim Jordan J000289 | Jim_Jordan | repjimjordan | UCPFBhS00ivPV585GlnNlyqA | 18166778 | RepJimJordan | ||
J000288 | Henry Johnson J000288 | RepHankJohnson | 115356957005 | UCqMici9I7nz_i-PN7eSYjwQ | 24745957 | RepHankJohnson | rephankjohnson | |
J000126 | Eddie Johnson J000126 | RepEBJ | CongresswomanEBJtx30 | UCVKp8BtjW708H4eXJJQgUYw | 168502762 | RepEddieBJohnson | repebj |
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 );