social_media
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
528 rows sorted by facebook
This data as json, copyable, CSV (advanced)
id | legislator_id | facebook ▼ | youtube_id | twitter_id | youtube | instagram_id | ||
---|---|---|---|---|---|---|---|---|
W000825 | Jennifer Wexton W000825 | RepWexton | 1017819745880543238 | |||||
W000826 | Susan Wild W000826 | RepSusanWild | 1069636653353000962 | |||||
S001157 | David Scott S001157 | RepDavidScott | 113303673339 | UCgf28zRkLSqAUiPuJhGdF0w | 168673083 | RepDavidScott | RepDavidScott | |
J000288 | Henry Johnson J000288 | RepHankJohnson | 115356957005 | UCqMici9I7nz_i-PN7eSYjwQ | 24745957 | RepHankJohnson | rephankjohnson | |
G000546 | Sam Graves G000546 | RepSamGraves | 118514606128 | UCdg2ybvoHsSW6t7iJnKHlNg | 29766367 | repsamgraves | ||
C001063 | Henry Cuellar C001063 | RepCuellar | 152569121550 | UCVgEOdJx3tyILO9EjZ-heEQ | 210926192 | henrycuellar | ||
S001177 | Gregorio Sablan S001177 | Kilili_Sablan | 153423912663 | UC-fbzxBSiC98eAE2goaANVQ | 926446070812602371 | CongressmanSablan | kilili_sablan | |
K000376 | Mike Kelly K000376 | MikeKellyPA | 191056827594903 | UCoz6u3ooQxoijsWvhoQ0D-A | 935368364 | repmikekelly | ||
Y000062 | John Yarmuth Y000062 | RepJohnYarmuth | 214258646163 | UCy5KW4yrEfEiyZRX45Eoxkg | 384913290 | RepJohnYarmuth | ||
C001091 | Joaquin Castro C001091 | JoaquinCastrotx | 326420614138023 | UCsRxWnFdRiV2od1O5v5nEeQ | 231510077 | JoaquinCastroTX | joaquincastrotx | 378492005 |
L000581 | Brenda Lawrence L000581 | RepLawrence | 395759603917487 | UCf0USy9GNigkB8O9sS1dodw | 2863006655 | repbrendalawrence | ||
G000552 | Louie Gohmert G000552 | RepLouieGohmert | 50375006903 | UC0HMa6X3iMhMq96kkRLLTog | 22055226 | GohmertTX01 | ||
S000344 | Brad Sherman S000344 | BradSherman | 63158229861 | UCPisrz6-SLwVy2l9Mcy8kug | 30216513 | shermanca27 | ||
C000059 | Ken Calvert C000059 | KenCalvert | 70063393423 | UC5MEj7YOX_QdKoqD_HRxP3A | 22545491 | RepKenCalvert | repkencalvert | |
V000081 | Nydia Velázquez V000081 | NydiaVelazquez | 8037068318 | UCqMKPkKeeHFOOiZ9vxhXGVg | 164369297 | nydiavelazquez | ||
S001165 | Albio Sires S001165 | RepSires | 81058818750 | UCfdEcWPNGoIxpYoTANF4PBA | 18696134 | RepSiresNJ13 | ||
M001177 | Tom McClintock M001177 | RepMcClintock | 81125319109 | UCMh04KC4LfIzKoXh2Xws_pw | 50152441 | McClintockCA04 | ||
S001148 | Michael Simpson S001148 | CongMikeSimpson | 96007744606 | UCNXe0rJJeULTAP_7oyQNw8g | 76132891 | CongMikeSimpson | ||
H001052 | Andy Harris H001052 | RepAndyHarrisMD | AndyHarrisMD | UCvUuV7FiJfJi1yux4qozgMg | 960962340 | RepAndyHarris | ||
L000569 | Blaine Luetkemeyer L000569 | RepBlaine | BlaineLuetkemeyer | UCifiiQclKbBBrkSbCnN6REg | 1849261916 | BLuetkemeyer | ||
P000597 | Chellie Pingree P000597 | ChelliePingree | ChelliePingree | UCLKaWFM7I84WcreDRhhhkVg | 14984637 | congresswomanpingree | ||
K000375 | William Keating K000375 | USRepKeating | Congressman.Keating | UC7KPV4xdxO2dms9vl6tETmg | 232992031 | RepBillKeating | ||
M001195 | Alexander Mooney M001195 | RepAlexMooney | CongressmanAlexMooney | UCw9CGkF4Re3areluI43TGyA | 2964526557 | repalexmooney | ||
C001072 | André Carson C001072 | RepAndreCarson | CongressmanAndreCarson | UCprUnnEgM2VUGmAKSaZXCSw | 199325935 | repandrecarson | repandrecarson | |
T000193 | Bennie Thompson T000193 | BennieGThompson | CongressmanBennieGThompson | UCzt2pBxh0dI24kYrWretXRw | 82453460 | RepBennieThompson | benniegthompson | 347410575 |
F000454 | Bill Foster F000454 | RepBillFoster | CongressmanBillFoster | UCicixINQr_-3cFHI2bJzFpQ | 1080509366 | RepBillFoster | ||
B001296 | Brendan Boyle B001296 | CongBoyle | CongressmanBoyle | UCMP_Anj7lz4eZuSh8GwFqQQ | 4304448314 | |||
S001190 | Bradley Schneider S001190 | RepSchneider | CongressmanBradSchneider | 1071840474 | RepBradSchneider | repschneider | ||
B001260 | Vern Buchanan B001260 | VernBuchanan | CongressmanBuchanan | UCY4DEy41NxOTdcF8_XAVZvw | 20467163 | vernbuchanan | repvern | 344865327 |
H001077 | Clay Higgins H001077 | RepClayHiggins | CongressmanClayHiggins | 843636970538618880 | RepClayHiggins | |||
D000096 | Danny Davis D000096 | RepDannyDavis | CongressmanDKDavis | UCdhrT09_XMr31tuI8OcKsjQ | 789244177 | dannykdavis07 | ||
S001200 | Darren Soto S001200 | RepDarrenSoto | CongressmanDarrenSoto | 818713465653051392 | repdarrensoto | RepDarrenSoto | ||
C001084 | David Cicilline C001084 | RepCicilline | CongressmanDavidCicilline | UC3sCl46o8hYP69LnidNltuw | 462143773 | RepDavidCicilline | ||
L000564 | Doug Lamborn L000564 | RepDLamborn | CongressmanDougLamborn | UCaYsGYMniq4nwBBMKFIwsow | 584012853 | CongressmanLamborn | douglamborn | |
S001193 | Eric Swalwell S001193 | RepSwalwell | CongressmanEricSwalwell | UCKvwsFNGD4sDkE_9g-2ft0w | 942156122 | ericswalwell | repswalwell | 338799200 |
K000395 | Fred Keller K000395 | RepFredKeller | CongressmanFredKeller | UC_IluBx9m7HWoNhEYSoPQNQ | 1136060761422405633 | repfredkeller | ||
T000467 | Glenn Thompson T000467 | CongressmanGT | CongressmanGT | UCNWX7lbWWvnNdzVMFI9DRiQ | 18967498 | CongressmanGT | congressman_gt | |
G000577 | Garret Graves G000577 | RepGarretGraves | CongressmanGarretGraves | UCQLg9GGwTDluEFJtXf8seTA | 2951574214 | instagravesla | ||
P000609 | Gary Palmer P000609 | USRepGaryPalmer | CongressmanGaryPalmer | UCYZfP-cNIvlJY3AcAc9OPpQ | 2861616083 | repgarypalmer | 1551536636 | |
C001078 | Gerald Connolly C001078 | GerryConnolly | CongressmanGerryConnolly | UC4WG9PlmoOeSLIuyVjs-RSA | 78445977 | repconnolly | ||
G000558 | Brett Guthrie G000558 | RepGuthrie | CongressmanGuthrie | UCdJhDw-YbdH0RHfWK0sIfiw | 1908143071 | BrettGuthrie | ||
R000395 | Harold Rogers R000395 | RepHalRogers | CongressmanHalRogers | UChVFKLZkRoHQDhp4zNvEezQ | 550401754 | RepHalRogers | rephalrogers | |
H001047 | James Himes H001047 | CongressmanJimHimes | UCCeB6czh6nhCHxOMCk_V4yA | congressmanhimes | ||||
L000559 | James Langevin L000559 | JimLangevin | CongressmanJimLangevin | UCQ1sth-7umw1k-fSVqdfRTg | 18909919 | jimlangevin | ||
H001071 | Jody Hice H001071 | CongressmanHice | CongressmanJodyHice | UCzUMsS8DusN2QLpgweFthgQ | 2975091705 | rep_hice | ||
C001096 | Kevin Cramer C001096 | SenKevinCramer | CongressmanKevinCramer | UCqUPdO9XaAW-dvwwXKbIVdA | 1048784496 | kevincramer | repkevincramer | |
M001165 | Kevin McCarthy M001165 | GOPLeader | CongressmanKevinMcCarthy | UCdJUZUFSLJRlUpE-91-6DsA | 19739126 | repkevinmccarthy | RepKevinMcCarthy | |
V000131 | Marc Veasey V000131 | RepVeasey | CongressmanMarcVeasey | UC2CRp1KF5uljZyhDRPR-72Q | 1074129612 | marcveasey | repveasey | 676925345 |
C001090 | Matthew Cartwright C001090 | RepCartwright | CongressmanMattCartwright | UCnAOvexSGLBnYidaFzguhTQ | 776664410 | repmattcartwright | ||
G000578 | Matt Gaetz G000578 | RepMattGaetz | CongressmanMattGaetz | UClqXcJew_A3s8qiX-T4a9CA | 818948638890217473 | Congressman_Matt_Gaetz | ||
M001156 | Patrick McHenry M001156 | PatrickMcHenry | CongressmanMcHenry | UCY3PTRhkSH-eoltxPVZKD-w | 27676828 | CongressmanMcHenry | reppatrickmchenry | 353406473 |
S001204 | Michael San Nicolas S001204 | GuamCongressman | CongressmanMichaelF.Q.SanNicolas | UCVroMJWH3jsh4shPSlp24sw | 346509049 | michael.fq.san.nicolas | ||
R000575 | Mike Rogers R000575 | RepMikeRogersAL | CongressmanMikeDRogers | UCH-WUWuY0_dlKwJDSqKTJsg | 33977070 | MikeRogersAL03 | repmikerogersal | 259435765 |
N000002 | Jerrold Nadler N000002 | RepJerryNadler | CongressmanNadler | UCQKj0qU1e7o2f5ftSh-c9aQ | 40302336 | congressmannadler | ||
R000599 | Raul Ruiz R000599 | RepRaulRuizMD | CongressmanRaulRuizMD | UCSDk-cyNPCo1iy6rweSPmBw | 1089859058 | repraulruiz | ||
A000372 | Rick Allen A000372 | RepRickAllen | CongressmanRickAllen | UCZPoYXHFDAV17BGLMzGAmpg | 2964287128 | Rep_RickAllen | 1666787116 | |
M001196 | Seth Moulton M001196 | RepMoulton | CongressmanSethMoulton | UC5w5qn7nj5Ljy69LTV7a_fQ | 3091316093 | repmoulton | ||
C001068 | Steve Cohen C001068 | RepCohen | CongressmanSteveCohen | UC_NJlnsOBjOameUwZk0rvsA | 162069635 | repcohen | ||
D000626 | Warren Davidson D000626 | WarrenDavidson | CongressmanWarrenDavidson | UCMzuyZWzk44YRNesFzPTeUw | 742735530287304704 | instawarrendavidson | ||
H001053 | Vicky Hartzler H001053 | RepHartzler | Congresswoman.Hartzler | UCAvttUz6qBVEJiFt7p_MZxw | 237763317 | repvickyhartzler | rephartzler | 787899303 |
A000370 | Alma Adams A000370 | RepAdams | CongresswomanAdams | UCPI9ao1Cr1nxEUD2r-usRjQ | 2916086925 | repadams | ||
K000382 | Ann Kuster K000382 | RepAnnieKuster | CongresswomanAnnieKuster | UCYAD_Eti2b5gXSicbgPsBYA | 1058717720 | RepKuster | ||
B001300 | Nanette Barragán B001300 | RepBarragan | CongresswomanBarragan | 816833925456789505 | repbarragan | |||
C001101 | Katherine Clark C001101 | RepKClark | CongresswomanClark | UCgaI52w7QKI8LtkSeCCmSuw | 2293131060 | repkclark | ||
J000126 | Eddie Johnson J000126 | RepEBJ | CongresswomanEBJtx30 | UCVKp8BtjW708H4eXJJQgUYw | 168502762 | RepEddieBJohnson | repebj | |
S001156 | Linda Sánchez S001156 | RepLindaSanchez | CongresswomanLindaSanchez | UCu1K6uHxjMgj2mvzM7O9-ow | 312134473 | LindaTSanchez | ||
N000147 | Eleanor Norton N000147 | EleanorNorton | CongresswomanNorton | UChRrAXUGylfxJjbquC6aUjQ | 23600262 | EleanorHNorton | ||
D000216 | Rosa DeLauro D000216 | RosaDeLauro | CongresswomanRosaDeLauro | UC9ROfGBm7kSLCEDYwFF6McQ | 140519774 | rosadelauro | ||
J000032 | Sheila Jackson Lee J000032 | JacksonLeeTX18 | CongresswomanSheilaJacksonLee | UCi_S-mOZaEco2Zb9guf_8Iw | 80612021 | TX18SJL | ||
S001191 | Kyrsten Sinema S001191 | SenatorSinema | CongresswomanSinema | UC4NzhW7D4lQdukSGWmFnK9w | 1080844782 | repsinema | repsinema | |
T000468 | Dina Titus T000468 | RepDinaTitus | CongresswomanTitus | UC_US4jNqECuMSNrB7yVCbbw | 122174004 | CongresswomanTitus | dinatitusnv | 1110185253 |
D000197 | Diana DeGette D000197 | RepDianaDeGette | DianaDeGette | UCWFQCRTHwsHg9P1Hf-EQtew | 28599820 | RepDianaDeGette | ||
N000188 | Donald Norcross N000188 | DonaldNorcross | DonaldNorcrossNJ | UC7kXK_PyDiOT8YrdP0jYZHw | 3122099613 | donald_norcross | ||
P000604 | Donald Payne P000604 | RepDonaldPayne | DonaldPayneJr | UCTG_SeYsOgbngjv1Donyu0w | 1155335864 | repdonaldpaynejr | ||
R000576 | C. Ruppersberger R000576 | Call_Me_Dutch | DutchRupp | UCk2S9iSHNpo1E1A7qZ0SPIw | 305620929 | ruppersberger | dutchruppersberger | |
M000133 | Edward Markey M000133 | SenMarkey | EdJMarkey | UCT1ujew5yQy2uMhGrjiKHoA | 21406834 | RepMarkey | ||
B001257 | Gus Bilirakis B001257 | RepGusBilirakis | GusBilirakis | UC2z1uu1n4-60xXs5x1mvLJw | 26051676 | RepGusBilirakis | gusbilirakis | |
M001160 | Gwen Moore M001160 | RepGwenMoore | GwenSMoore | UCCs9o1XaSsCsqNpO0iO0_Ew | 22669526 | RepGwenMoore | RepGwenMoore | |
S001175 | Jackie Speier S001175 | RepSpeier | JackieSpeier | UCevmyTb0HSO8irVaR2gYyoA | 24913074 | jackiespeierca12 | jackiespeier | |
C000754 | Jim Cooper C000754 | RepJimCooper | JimCooper | UCjplyIIQbNZcl013AyDfPNg | 22523087 | RepJimCooper | repjimcooper | 1037212884 |
A000375 | Jodey Arrington A000375 | RepArrington | JodeyArrington | 816284664658874368 | repjodeyarrington | |||
M001183 | Joe Manchin M001183 | Sen_JoeManchin | JoeManchinIII | UCGyPK_ye2ptpzQgOjKIn7ag | 234374703 | SenatorJoeManchin | ||
W000795 | Joe Wilson W000795 | RepJoeWilson | JoeWilson | UC3aR1B8m7Z1uycO65yDnpCg | 254082173 | RepJoeWilson | repjoewilson | 519685522 |
B001236 | John Boozman B001236 | JohnBoozman | JohnBoozman | UC9vWHKL5OfIYh6kIV0rF2yw | 5558312 | BoozmanPressOffice | johnboozman | |
K000393 | John Kennedy K000393 | SenJohnKennedy | JohnKennedyLouisiana | 816683274076614656 | SenJohnKennedy | |||
A000369 | Mark Amodei A000369 | MarkAmodeiNV2 | MarkAmodeiNV2 | UCjOGx2iqSn1r3BQxaVgYhYw | 402719755 | markamodeinv2 | MarkAmodeiNV2 | |
W000805 | Mark Warner W000805 | MarkWarner | MarkRWarner | UCwyivNlEGf4sGd1oDLfY5jw | 7429102 | SenatorMarkWarner | senatorwarner | 515327940 |
H001046 | Martin Heinrich H001046 | MartinHeinrich | MartinHeinrich | UCBxh8IK5sMxY0Ln_0G2NYcg | 1099199839 | SenMartinHeinrich | senatormartinheinrich | 285288987 |
W000187 | Maxine Waters W000187 | RepMaxineWaters | MaxineWaters | UCOQ2js1VYFlo74n7Ns8WsLQ | 36686040 | MaxineWaters | repmaxinewaters | |
P000197 | Nancy Pelosi P000197 | SpeakerPelosi | NancyPelosi | UCxPeEcH0xaCK9nBK98EFhDg | 15764644 | nancypelosi | ||
W000800 | Peter Welch W000800 | PeterWelch | PeterWelch | UC0YfApJx6qNaAQ-ir93U8xA | 1410590874 | reppeterwelch | reppeterwelch | 1559860900 |
L000576 | Billy Long L000576 | USRepLong | Rep.Billy.Long | UCLQcbyxpHXXAsUJckscQY8g | 1444015610 | MOdistrict7 | ||
B001303 | Lisa Blunt Rochester B001303 | RepLBR | Rep.BluntRochester | 817050219007328258 | ||||
G000551 | Raúl Grijalva G000551 | RepRaulGrijalva | Rep.Grijalva | UC8JZLnXS21bhNbcvpoM8O7g | 28602948 | raulgrijalvaaz07 | ||
S001150 | Adam Schiff S001150 | RepAdamSchiff | RepAdamSchiff | UCadiUi-KZoFk1K5ZDsluLcA | 29501253 | adamschiff | RepAdamSchiff | |
S000510 | Adam Smith S000510 | RepAdamSmith | RepAdamSmith | UCcrHso483LOfC6WwDnzAh-g | 58928690 | CongressmanAdamSmith | ||
L000586 | Al Lawson L000586 | RepAlLawsonJr | RepAlLawsonJr | 818472418620608512 | ||||
B001287 | Ami Bera B001287 | RepBera | RepAmiBera | UClJCTCo53Zk6b4kUL-bbdzg | 950783972 | repamibera | ||
B001282 | Garland Barr B001282 | RepAndyBarr | RepAndyBarr | UCVL2s6x7f7H0ZJ-uwU0pQ6Q | 1089334250 | RepAndyBarr | ||
B001302 | Andy Biggs B001302 | RepAndyBiggsAZ | RepAndyBiggs | UCqSq9kWOxk9yNTeILBCVC1w | 816652616625168388 | repandybiggs |
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 );