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 | ||
---|---|---|---|---|---|---|---|---|
G000579 | Mike Gallagher G000579 | RepGallagher | RepMikeGallagher | 815966620300480514 | ||||
G000559 | John Garamendi G000559 | RepGaramendi | repgaramendi | UCRym1qsO72C39gX6pBu4icg | 88806753 | garamendiCA10 | repgaramendi | |
G000597 | Andrew Garbarino G000597 | RepGarbarino | 1344349650447433729 | |||||
G000577 | Garret Graves G000577 | RepGarretGraves | CongressmanGarretGraves | UCQLg9GGwTDluEFJtXf8seTA | 2951574214 | instagravesla | ||
G000592 | Jared Golden G000592 | RepGolden | 1080891667308298240 | |||||
G000581 | Vicente Gonzalez G000581 | RepGonzalez | USCongressmanVicenteGonzalez | UC5H6oYLKQ_xIXO5CG7fh4hw | 818536152588238849 | repvicentegonzaleztx | ||
G000565 | Paul Gosar G000565 | RepGosar | repgosar | UC5orqw_9acsKWSRbrqTDXBw | 240760644 | repgosar | REPGOSAR | |
M001188 | Grace Meng M001188 | RepGraceMeng | repgracemeng | UCHg516zJKbIBtXFAJ0nu3XQ | 1051127714 | |||
M001210 | Gregory Murphy M001210 | RepGregMurphy | RepGregMurphy | 1173978070535024642 | ||||
P000615 | Greg Pence P000615 | RepGregPence | 1082369392229400576 | |||||
S001211 | Greg Stanton S001211 | RepGregStanton | 1080885078425784320 | |||||
S001214 | W. Steube S001214 | RepGregSteube | 1083125649609506816 | |||||
M001137 | Gregory Meeks M001137 | RepGregoryMeeks | gregorymeeksny05 | UCljJnwgQS6Z6-NypDyqKJZQ | 22812754 | gwmeeks | repgregorymeeks | |
G000576 | Glenn Grothman G000576 | RepGrothman | RepGrothman | UCui4k83Cot4aeVW_8T33fgg | 2976606250 | |||
B001257 | Gus Bilirakis B001257 | RepGusBilirakis | GusBilirakis | UC2z1uu1n4-60xXs5x1mvLJw | 26051676 | RepGusBilirakis | gusbilirakis | |
G000558 | Brett Guthrie G000558 | RepGuthrie | CongressmanGuthrie | UCdJhDw-YbdH0RHfWK0sIfiw | 1908143071 | BrettGuthrie | ||
M001160 | Gwen Moore M001160 | RepGwenMoore | GwenSMoore | UCCs9o1XaSsCsqNpO0iO0_Ew | 22669526 | RepGwenMoore | RepGwenMoore | |
R000395 | Harold Rogers R000395 | RepHalRogers | CongressmanHalRogers | UChVFKLZkRoHQDhp4zNvEezQ | 550401754 | RepHalRogers | rephalrogers | |
S001215 | Haley Stevens S001215 | RepHaleyStevens | 1076161611033968640 | |||||
J000288 | Henry Johnson J000288 | RepHankJohnson | 115356957005 | UCqMici9I7nz_i-PN7eSYjwQ | 24745957 | RepHankJohnson | rephankjohnson | |
H001086 | Diana Harshbarger H001086 | RepHarshbarger | 1345787285179162624 | |||||
H001053 | Vicky Hartzler H001053 | RepHartzler | Congresswoman.Hartzler | UCAvttUz6qBVEJiFt7p_MZxw | 237763317 | repvickyhartzler | rephartzler | 787899303 |
H001084 | Yvette Herrell H001084 | RepHerrell | 1344416719260016641 | |||||
H001066 | Steven Horsford H001066 | RepHorsford | 389840566 | |||||
H001085 | Chrissy Houlahan H001085 | RepHoulahan | 1052896620797460481 | |||||
H001068 | Jared Huffman H001068 | RepHuffman | RepHuffman | UCJU6SP1ppp1ZhSiqZLiFgDA | 1071102246 | rephuffman | rephuffman | |
H001058 | Bill Huizenga H001058 | RepHuizenga | RepHuizenga | UCQPlLLiMnysMmeJ5qUSSjQg | 233949261 | RepHuizenga | RepHuizenga | |
B001301 | Jack Bergman B001301 | RepJackBergman | RepJackBergman | 815241612154417152 | RepJackBergman | RepJackBergman | ||
J000020 | Chris Jacobs J000020 | RepJacobs | 1276232539510919168 | |||||
H001081 | Jahana Hayes H001081 | RepJahanaHayes | 1082086081238102018 | |||||
C001108 | James Comer C001108 | RepJamesComer | congressmancomer | 1274852794206388225 | congressmancomer | |||
C001121 | Jason Crow C001121 | RepJasonCrow | 1080191866509901826 | |||||
S001195 | Jason Smith S001195 | RepJasonSmith | repjasonsmith | UCzj9-27Lr4gcqopmZAobXXg | 1623308912 | RepJasonSmith | ||
J000298 | Pramila Jayapal J000298 | RepJayapal | RepJayapal | UCmyD0_-2Oowkfwc_Raghclw | 815733290955112448 | repjayapal | ||
D000615 | Jeff Duncan D000615 | RepJeffDuncan | RepJeffDuncan | UC1tuXL6ymImdpKYGEAH83QA | 240393970 | congjeffduncan | repjeffduncan | 382897929 |
J000294 | Hakeem Jeffries J000294 | RepJeffries | RepHakeemJeffries | UCYVmbsjoNbQ4j-PCQIYgpWQ | 467823431 | |||
G000582 | Jenniffer González-Colón G000582 | RepJenniffer | RepJennifferGonzalezColon | UCZj99h3-GNKjGGeyp7AJeXw | 819744763020775425 | |||
C001054 | Jerry Carl C001054 | RepJerryCarl | 1341091420439015424 | |||||
N000002 | Jerrold Nadler N000002 | RepJerryNadler | CongressmanNadler | UCQKj0qU1e7o2f5ftSh-c9aQ | 40302336 | congressmannadler | ||
B001307 | James Baird B001307 | RepJimBaird | 1086316494450032640 | |||||
B001299 | Jim Banks B001299 | RepJimBanks | RepJimBanks | UC_FR6TySW9uxvhjozkis6Xg | 816131319033950208 | repjimbanks | ||
C000754 | Jim Cooper C000754 | RepJimCooper | JimCooper | UCjplyIIQbNZcl013AyDfPNg | 22523087 | RepJimCooper | repjimcooper | 1037212884 |
C001059 | Jim Costa C001059 | RepJimCosta | RepJimCosta | UCVgXX23eJEai6GiBOKO6dvA | 245451804 | RepJimCostaCA20 | ||
G000585 | Jimmy Gomez G000585 | RepJimmyGomez | RepJimmyGomez | 2371339658 | ||||
P000613 | Jimmy Panetta P000613 | RepJimmyPanetta | RepJimmyPanetta | UCmw-aERG51C96edMDPN7fXQ | 796736612554117120 | repjimmypanetta | ||
C001069 | Joe Courtney C001069 | RepJoeCourtney | joecourtney | UCGVIfe1T2hO1Lx7ap5Wkv1w | 85396297 | repcourtney | repjoecourtney | |
M001206 | Joseph Morelle M001206 | RepJoeMorelle | 1064595993222615040 | |||||
N000191 | Joe Neguse N000191 | RepJoeNeguse | 1078749802765139968 | |||||
W000795 | Joe Wilson W000795 | RepJoeWilson | JoeWilson | UC3aR1B8m7Z1uycO65yDnpCg | 254082173 | RepJoeWilson | repjoewilson | 519685522 |
C001114 | John Curtis C001114 | RepJohnCurtis | RepJohnCurtis | UChAQ4MD-HigmGnImSoAKBVA | 931614483050414080 | repjohncurtis | ||
J000302 | John Joyce J000302 | RepJohnJoyce | 1082311988926124036 | |||||
K000386 | John Katko K000386 | RepJohnKatko | RepJohnKatko | 2966765501 | ||||
L000557 | John Larson L000557 | RepJohnLarson | RepJohnLarson | UCGPsvFF-9WfpdRSCcCrPLiQ | 50452197 | RepJohnLarson | RepJohnBLarson | |
R000612 | John Rose R000612 | RepJohnRose | 1081312310059253763 | |||||
Y000062 | John Yarmuth Y000062 | RepJohnYarmuth | 214258646163 | UCy5KW4yrEfEiyZRX45Eoxkg | 384913290 | RepJohnYarmuth | ||
G000583 | Josh Gottheimer G000583 | RepJoshG | RepJoshG | 815310506596691968 | RepJoshG | |||
H001090 | Josh Harder H001090 | RepJoshHarder | 1080851152151953410 | |||||
V000130 | Juan Vargas V000130 | RepJuanVargas | RepJuanVargas | UCpMthf8y7bEMJH_td0dznRQ | 1260172386 | RepJuanVargas | repjuanvargas | |
C001080 | Judy Chu C001080 | RepJudyChu | RepJudyChu | UCfcbYOvdEXZNelM8T05nK-w | 193732179 | RepJudyChu | ||
L000595 | Julia Letlow L000595 | RepJuliaLetlow | 1382395679700439041 | |||||
C001101 | Katherine Clark C001101 | RepKClark | CongresswomanClark | UCgaI52w7QKI8LtkSeCCmSuw | 2293131060 | repkclark | ||
M001135 | Kathy Manning M001135 | RepKManning | 1337115670161608712 | |||||
K000396 | Kaialiʻi Kahele K000396 | RepKahele | 1351966874377056257 | |||||
B001270 | Karen Bass B001270 | RepKarenBass | RepKarenBass | UCQZg7oxkV3Yag2emYPLhT2g | 239949176 | RepKarenBass | ||
C001039 | Katherine Cammack C001039 | RepKatCammack | 1344325638983987201 | |||||
R000602 | Kathleen Rice R000602 | RepKathleenRice | RepKathleenRice | UCLYLmjrGtzzCFXMWPBxHAug | 2970462034 | |||
P000618 | Katie Porter P000618 | RepKatiePorter | 1081222837459996672 | |||||
G000377 | Kay Granger G000377 | RepKayGranger | RepKayGranger | UCsRMtemAkyLh78MPES6gMVQ | 161743731 | RepKayGranger | repkaygranger | |
B001297 | Ken Buck B001297 | RepKenBuck | repkenbuck | UCHK7Wcwij7NoxXGTeSHUWzg | 2862577383 | repkenbuck | ||
B000755 | Kevin Brady B000755 | RepKevinBrady | kevinbrady | UC6Ng0uMQEBVgXO_HF0NbfXA | 19926675 | KBrady8 | repkevinbrady | 337613850 |
S001216 | Kim Schrier S001216 | RepKimSchrier | 1080462532815532032 | |||||
K000378 | Adam Kinzinger K000378 | RepKinzinger | RepKinzinger | UCjDHxyjndxxhjuPWyEBc7UA | 219429281 | RepAdamKinzinger | ||
K000368 | Ann Kirkpatrick K000368 | RepKirkpatrick | 1081240074946252801 | |||||
M000687 | Kweisi Mfume M000687 | RepKweisiMfume | RepKweisiMfume | 1276209702322438148 | ||||
B001303 | Lisa Blunt Rochester B001303 | RepLBR | Rep.BluntRochester | 817050219007328258 | ||||
L000585 | Darin LaHood L000585 | RepLaHood | replahood | UCVRbtFwaBGcixZIkygtalRw | 3686482216 | |||
L000578 | Doug LaMalfa L000578 | RepLaMalfa | RepLaMalfa | UCUzz1XDn862fxirervSB2Yw | 1069124515 | RepLaMalfa | repdouglamalfa | |
L000266 | Jacob LaTurner L000266 | RepLaTurner | 1345850704800468993 | |||||
B001275 | Larry Bucshon B001275 | RepLarryBucshon | RepLarryBucshon | UC0bIliQs0LKZabNwvZ3gnhQ | 234812598 | RepLarryBucshon | ||
L000581 | Brenda Lawrence L000581 | RepLawrence | 395759603917487 | UCf0USy9GNigkB8O9sS1dodw | 2863006655 | repbrendalawrence | ||
Z000017 | Lee Zeldin Z000017 | RepLeeZeldin | RepLeeZeldin | UCHzZuesCPDka2NhZO8icqzA | 2750127259 | |||
S001156 | Linda Sánchez S001156 | RepLindaSanchez | CongresswomanLindaSanchez | UCu1K6uHxjMgj2mvzM7O9-ow | 312134473 | LindaTSanchez | ||
M001136 | Lisa McClain M001136 | RepLisaMcClain | 1344032292432437248 | |||||
C001109 | Liz Cheney C001109 | RepLizCheney | replizcheney | UCvL57Zp99QdDllF-KGziUAA | 816719802328715264 | |||
D000399 | Lloyd Doggett D000399 | RepLloydDoggett | lloyddoggett | UCN-kiLKyHPcfRVZ28sAHS_g | 153944899 | doggett | replloyddoggett | |
F000462 | Lois Frankel F000462 | RepLoisFrankel | RepLoisFrankel | UCEk5viAhxaW_2OK20-yBwzQ | 1077121945 | reploisfrankel | reploisfrankel | |
T000482 | Lori Trahan T000482 | RepLoriTrahan | 1079802482640019456 | |||||
C001110 | J. Correa C001110 | RepLouCorrea | RepLouCorrea | UCIKJJp4QJIDjnjodc23qKkw | 815985039485837312 | reploucorrea | ||
L000583 | Barry Loudermilk L000583 | RepLoudermilk | reploudermilk | UC2Kfw8fjca8k3w3KpzL5tNg | 2914163523 | RepLoudermilk | ||
G000552 | Louie Gohmert G000552 | RepLouieGohmert | 50375006903 | UC0HMa6X3iMhMq96kkRLLTog | 22055226 | GohmertTX01 | ||
L000579 | Alan Lowenthal L000579 | RepLowenthal | RepLowenthal | UC-GgROtn5Hxm1H9a6qvy_Wg | 1055730738 | RepLowenthal | RepLowenthal | |
M001208 | Lucy McBath M001208 | RepLucyMcBath | 1082380458976051202 | |||||
S001205 | Mary Scanlon S001205 | RepMGS | 1067541214671577093 | |||||
G000568 | H. Griffith G000568 | RepMGriffith | RepMorganGriffith | UCzxqD7EY_Rdvbc0spbaYkJA | 234057152 | RepMorganGriffith | hmorgangriffith | |
M001215 | Mariannette Miller-Meeks M001215 | RepMMM | 1345807954604412929 | |||||
G000596 | Marjorie Greene G000596 | RepMTG | 1344356576786866176 | |||||
M001203 | Tom Malinowski M001203 | RepMalinowski | 1080898026418384897 | |||||
M000317 | Nicole Malliotakis M000317 | RepMalliotakis | 1344750588026900481 | |||||
M000087 | Carolyn Maloney M000087 | RepMaloney | RepCarolynMaloney | 258900199 | carolynbmaloney | repmaloney | ||
M000871 | Tracey Mann M000871 | RepMann | 1345825008887721986 |
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 );