social_media
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
528 rows sorted by instagram descending
This data as json, copyable, CSV (advanced)
id | legislator_id | youtube_id | twitter_id | youtube | instagram ▲ | instagram_id | ||
---|---|---|---|---|---|---|---|---|
P000613 | Jimmy Panetta P000613 | RepJimmyPanetta | RepJimmyPanetta | UCmw-aERG51C96edMDPN7fXQ | 796736612554117120 | repjimmypanetta | ||
C000754 | Jim Cooper C000754 | RepJimCooper | JimCooper | UCjplyIIQbNZcl013AyDfPNg | 22523087 | RepJimCooper | repjimcooper | 1037212884 |
B001299 | Jim Banks B001299 | RepJimBanks | RepJimBanks | UC_FR6TySW9uxvhjozkis6Xg | 816131319033950208 | repjimbanks | ||
D000615 | Jeff Duncan D000615 | RepJeffDuncan | RepJeffDuncan | UC1tuXL6ymImdpKYGEAH83QA | 240393970 | congjeffduncan | repjeffduncan | 382897929 |
J000298 | Pramila Jayapal J000298 | RepJayapal | RepJayapal | UCmyD0_-2Oowkfwc_Raghclw | 815733290955112448 | repjayapal | ||
R000608 | Jacky Rosen R000608 | SenJackyRosen | RepJackyRosen | 818554054309715969 | repjackyrosen | |||
H001068 | Jared Huffman H001068 | RepHuffman | RepHuffman | UCJU6SP1ppp1ZhSiqZLiFgDA | 1071102246 | rephuffman | rephuffman | |
H001053 | Vicky Hartzler H001053 | RepHartzler | Congresswoman.Hartzler | UCAvttUz6qBVEJiFt7p_MZxw | 237763317 | repvickyhartzler | rephartzler | 787899303 |
J000288 | Henry Johnson J000288 | RepHankJohnson | 115356957005 | UCqMici9I7nz_i-PN7eSYjwQ | 24745957 | RepHankJohnson | rephankjohnson | |
R000395 | Harold Rogers R000395 | RepHalRogers | CongressmanHalRogers | UChVFKLZkRoHQDhp4zNvEezQ | 550401754 | RepHalRogers | rephalrogers | |
M001137 | Gregory Meeks M001137 | RepGregoryMeeks | gregorymeeksny05 | UCljJnwgQS6Z6-NypDyqKJZQ | 22812754 | gwmeeks | repgregorymeeks | |
N000179 | Grace Napolitano N000179 | GraceNapolitano | RepGraceNapolitano | UCPWjmiAIR04oQ8QMoOWcDtA | 161411080 | RepGraceNapolitano | repgracenapolitano | |
P000609 | Gary Palmer P000609 | USRepGaryPalmer | CongressmanGaryPalmer | UCYZfP-cNIvlJY3AcAc9OPpQ | 2861616083 | repgarypalmer | 1551536636 | |
G000559 | John Garamendi G000559 | RepGaramendi | repgaramendi | UCRym1qsO72C39gX6pBu4icg | 88806753 | garamendiCA10 | repgaramendi | |
H001072 | J. Hill H001072 | RepFrenchHill | RepFrenchHill | UCT8uWroJtkwSsCJlVg0IKvQ | 2953974395 | repfrenchhill | ||
K000395 | Fred Keller K000395 | RepFredKeller | CongressmanFredKeller | UC_IluBx9m7HWoNhEYSoPQNQ | 1136060761422405633 | repfredkeller | ||
P000034 | Frank Pallone P000034 | FrankPallone | repfrankpallone | UCN0_wn9hs1LI3UKkji2PP2A | 31801993 | repfrankpallone | repfrankpallone | |
J000126 | Eddie Johnson J000126 | RepEBJ | CongresswomanEBJtx30 | UCVKp8BtjW708H4eXJJQgUYw | 168502762 | RepEddieBJohnson | repebj | |
E000296 | Dwight Evans E000296 | RepDwightEvans | RepDwightEvans | 90639372 | repdwightevans | |||
F000465 | A. Ferguson F000465 | RepDrewFerguson | RepDrewFerguson | UCuK7_j2sREWi_7wBAN477bg | 806583915012046854 | repdrewferguson | ||
L000578 | Doug LaMalfa L000578 | RepLaMalfa | RepLaMalfa | UCUzz1XDn862fxirervSB2Yw | 1069124515 | RepLaMalfa | repdouglamalfa | |
M001163 | Doris Matsui M001163 | DorisMatsui | doris.matsui | UCSqqxVkvskHq3cY2MCbTZsw | 38254095 | RepDorisMatsui | repdorismatsui | |
B001292 | Donald Beyer B001292 | RepDonBeyer | RepDonBeyer | UCPJGVbOVcAVGiBwq8qr_T9w | 2962868158 | repdonbeyer | ||
P000604 | Donald Payne P000604 | RepDonaldPayne | DonaldPayneJr | UCTG_SeYsOgbngjv1Donyu0w | 1155335864 | repdonaldpaynejr | ||
D000624 | Debbie Dingell D000624 | RepDebDingell | RepDebbieDingell | UCnoP3KLT-HOvzDfC1-I-9lQ | 2970279814 | repdingell | ||
D000623 | Mark DeSaulnier D000623 | RepDeSaulnier | RepMarkDeSaulnier | 2968007206 | repdesaulnier | |||
D000617 | Suzan DelBene D000617 | RepDelBene | RepDelBene | UCd00b7TpKDZIr-Ujhaktvjg | 995193054 | repdelbene | ||
R000603 | David Rouzer R000603 | RepDavidRouzer | RepRouzer | UCBvOxpqoGi1HlHjX9v_gHZw | 834069080 | repdavidrouzer | ||
K000392 | David Kustoff K000392 | RepDavidKustoff | RepDavidKustoff | UCK6U4plOKKMrCjv_h59spGQ | 816012124505931780 | repdavidkustoff | ||
P000523 | David Price P000523 | RepDavidEPrice | RepDavidEPrice | UCtX7bSXBLF9ge-Q955n5Vqw | 155669457 | RepDavidPrice | repdavideprice | |
S001183 | David Schweikert S001183 | RepDavid | repdavidschweikert | UCVvuNVzkOUp7p_Pzkc6Zuvw | 229197216 | RepDavidSchweikert | repdavid | 181147397 |
J000295 | David Joyce J000295 | RepDaveJoyce | RepDaveJoyce | UCTu9xz2VYk-jtQv0TVsLyYA | 976969338 | repdavejoyce | repdavejoyce | 360743678 |
K000380 | Daniel Kildee K000380 | RepDanKildee | RepDanKildee | UC_KpQ-n3IT5dL5ul21XA9Yw | 1045110018 | RepDanKildee | repdankildee | 582887115 |
C001097 | Tony Cárdenas C001097 | RepCardenas | repcardenas | UCm6ug1-yvYGL0F6DvYxfFBA | 1222257180 | repcardenas | repcardenas | 1483357690 |
C001112 | Salud Carbajal C001112 | RepCarbajal | repsaludcarbajal | 816157667882373120 | repcarbajal | repcarbajal | ||
H001038 | Brian Higgins H001038 | RepBrianHiggins | RepBrianHiggins | UCSGbv85HaaYYOrPGePtxwag | 33576489 | CongressmanHiggins | repbrianhiggins | |
F000466 | Brian Fitzpatrick F000466 | RepBrianFitz | repbrianfitzpatrick | UCYMNcgHss4_Q5JY2vSvMpgw | 816303263586914304 | repbrianfitz | ||
L000581 | Brenda Lawrence L000581 | RepLawrence | 395759603917487 | UCf0USy9GNigkB8O9sS1dodw | 2863006655 | repbrendalawrence | ||
W000815 | Brad Wenstrup W000815 | RepBradWenstrup | RepBradWenstrup | UCaK7SeUvmHdHTMtF3HXb-jA | 518644221 | repbradwenstrup | repbradwenstrup | 305496379 |
W000822 | Bonnie Watson Coleman W000822 | RepBonnie | RepBonnie | UCrxEaX0VKZKwg3930du2D5A | 2968451607 | repbonnie | ||
G000563 | Bob Gibbs G000563 | RepBobGibbs | RepBobGibbs | UC4J-kVbeE32Up-b_wTLEUmA | 234822928 | RepBobGibbs | repbobgibbs | |
S000185 | Robert Scott S000185 | BobbyScott | RepBobbyScott | UCdNNcpw8arCsUp55JwK_QAA | 161791703 | repbobbyscott | repbobbyscott | 1173348983 |
J000292 | Bill Johnson J000292 | RepBillJohnson | RepBillJohnson | UCtF08Ay71haDRoJosRN2P_Q | 211530910 | RepBillJohnson | repbilljohnson | 763495818 |
M001143 | Betty McCollum M001143 | BettyMcCollum04 | repbettymccollum | UC3sZJSdiZo2EBHbsOlsnI7A | 516880804 | BMcCollum04 | repbettymccollum | |
B001281 | Joyce Beatty B001281 | RepBeatty | RepJoyceBeatty | UCtVl3kb7Xvt3pY7l6x-M6LA | 1531521632 | repbeatty | 554027718 | |
B001300 | Nanette Barragán B001300 | RepBarragan | CongresswomanBarragan | 816833925456789505 | repbarragan | |||
L000551 | Barbara Lee L000551 | RepBarbaraLee | RepBarbaraLee | UCnRgK2MXAQOUau0JXqseeNA | 248735463 | RepLee | repbarbaralee | 1415801245 |
W000812 | Ann Wagner W000812 | RepAnnWagner | RepAnnWagner | UCy2v2DXXvQnbRc8Zx77Dnsg | 1051446626 | repannwagner | ||
B001302 | Andy Biggs B001302 | RepAndyBiggsAZ | RepAndyBiggs | UCqSq9kWOxk9yNTeILBCVC1w | 816652616625168388 | repandybiggs | ||
C001072 | André Carson C001072 | RepAndreCarson | CongressmanAndreCarson | UCprUnnEgM2VUGmAKSaZXCSw | 199325935 | repandrecarson | repandrecarson | |
G000553 | Al Green G000553 | RepAlGreen | repalgreen | UCFtgMZm1YUXaZ8OtOj-GDjA | 156333623 | RepAlGreen | repalgreen | |
M001195 | Alexander Mooney M001195 | RepAlexMooney | CongressmanAlexMooney | UCw9CGkF4Re3areluI43TGyA | 2964526557 | repalexmooney | ||
E000297 | Adriano Espaillat E000297 | RepEspaillat | RepEspaillat | UCi0niBYFhEY70Dz8InbX5OQ | 817076257770835968 | repadrianoespaillat | ||
A000370 | Alma Adams A000370 | RepAdams | CongresswomanAdams | UCPI9ao1Cr1nxEUD2r-usRjQ | 2916086925 | repadams | ||
H001071 | Jody Hice H001071 | CongressmanHice | CongressmanJodyHice | UCzUMsS8DusN2QLpgweFthgQ | 2975091705 | rep_hice | ||
S001192 | Chris Stewart S001192 | RepChrisStewart | RepChrisStewart | UCKYqzTvmQVWys-WhrCkbyPw | 1072008757 | repchrisstewart | repChrisStewart | |
C000880 | Michael Crapo C000880 | MikeCrapo | mikecrapo | UCMHzKHg1BE7dEcFjnayw1lA | 600463589 | senatorcrapo | mikecrapo | 329357214 |
S001204 | Michael San Nicolas S001204 | GuamCongressman | CongressmanMichaelF.Q.SanNicolas | UCVroMJWH3jsh4shPSlp24sw | 346509049 | michael.fq.san.nicolas | ||
M000355 | Mitch McConnell M000355 | McConnellPress | mitchmcconnell | 339822881 | mcconnellpress | |||
H001042 | Mazie Hirono H001042 | MazieHirono | senatorhirono | UCcoKhxad156flzPYJ8JMFOA | 92186819 | CongresswomanHirono | maziehirono | 304094084 |
B001243 | Marsha Blackburn B001243 | MarshaBlackburn | marshablackburn | UCvNnmu5mUm7xr8QXBlbtQ9w | 278145569 | RepMarshaBlackburn | marshablackburn | |
S001177 | Gregorio Sablan S001177 | Kilili_Sablan | 153423912663 | UC-fbzxBSiC98eAE2goaANVQ | 926446070812602371 | CongressmanSablan | kilili_sablan | |
C001051 | John Carter C001051 | JudgeCarter | judgecarter | UC9pkaOrhPfouzkJ8oAdI-1w | 18030431 | repjohncarter | judgecarter | 456560563 |
B001236 | John Boozman B001236 | JohnBoozman | JohnBoozman | UC9vWHKL5OfIYh6kIV0rF2yw | 5558312 | BoozmanPressOffice | johnboozman | |
C001091 | Joaquin Castro C001091 | JoaquinCastrotx | 326420614138023 | UCsRxWnFdRiV2od1O5v5nEeQ | 231510077 | JoaquinCastroTX | joaquincastrotx | 378492005 |
S001175 | Jackie Speier S001175 | RepSpeier | JackieSpeier | UCevmyTb0HSO8irVaR2gYyoA | 24913074 | jackiespeierca12 | jackiespeier | |
D000626 | Warren Davidson D000626 | WarrenDavidson | CongressmanWarrenDavidson | UCMzuyZWzk44YRNesFzPTeUw | 742735530287304704 | instawarrendavidson | ||
G000577 | Garret Graves G000577 | RepGarretGraves | CongressmanGarretGraves | UCQLg9GGwTDluEFJtXf8seTA | 2951574214 | instagravesla | ||
G000568 | H. Griffith G000568 | RepMGriffith | RepMorganGriffith | UCzxqD7EY_Rdvbc0spbaYkJA | 234057152 | RepMorganGriffith | hmorgangriffith | |
H001056 | Jaime Herrera Beutler H001056 | HerreraBeutler | herrerabeutler | UCJEgiA9clfx0amrQUj0aBTQ | 242926427 | RepHerreraBeutler | herrerabeutler | |
B001257 | Gus Bilirakis B001257 | RepGusBilirakis | GusBilirakis | UC2z1uu1n4-60xXs5x1mvLJw | 26051676 | RepGusBilirakis | gusbilirakis | |
R000576 | C. Ruppersberger R000576 | Call_Me_Dutch | DutchRupp | UCk2S9iSHNpo1E1A7qZ0SPIw | 305620929 | ruppersberger | dutchruppersberger | |
L000564 | Doug Lamborn L000564 | RepDLamborn | CongressmanDougLamborn | UCaYsGYMniq4nwBBMKFIwsow | 584012853 | CongressmanLamborn | douglamborn | |
N000188 | Donald Norcross N000188 | DonaldNorcross | DonaldNorcrossNJ | UC7kXK_PyDiOT8YrdP0jYZHw | 3122099613 | donald_norcross | ||
T000468 | Dina Titus T000468 | RepDinaTitus | CongresswomanTitus | UC_US4jNqECuMSNrB7yVCbbw | 122174004 | CongresswomanTitus | dinatitusnv | 1110185253 |
D000616 | Scott DesJarlais D000616 | DesJarlaisTN04 | ScottDesJarlaisTN04 | UCvjuSLoi3hS0ECQvJLhwOkA | 235312723 | ScottDesJarlaisTN04 | desjarlaistn04 | 260930821 |
K000391 | Raja Krishnamoorthi K000391 | CongressmanRaja | congressmanraja | 814179031956488192 | congressmanraja | |||
P000601 | Steven Palazzo P000601 | CongPalazzo | stevenpalazzo | UCtPOy2vRbN2nD8dQPSOTXeA | 299883942 | CongressmanPalazzo | congressmanpalazzo | |
C001108 | James Comer C001108 | RepJamesComer | congressmancomer | 1274852794206388225 | congressmancomer | |||
M001157 | Michael McCaul M001157 | RepMcCaul | michaeltmccaul | UCRw6sGE0PH7_FCeTT3PQRaA | 26424123 | MichaelTMcCaul | congressman_mccaul | |
T000467 | Glenn Thompson T000467 | CongressmanGT | CongressmanGT | UCNWX7lbWWvnNdzVMFI9DRiQ | 18967498 | CongressmanGT | congressman_gt | |
V000128 | Chris Van Hollen V000128 | ChrisVanHollen | chrisvanhollen | UCkpfJWu1N9Okd6PE_NidtBQ | 18137749 | RepChrisVanHollen | chrisvanhollen | 268595235 |
M001159 | Cathy McMorris Rodgers M001159 | CathyMcMorris | mcmorrisrodgers | UCRp0lwIxAhq2Ia9_YgRWUkg | 17976923 | mcmorrisrodgers | cathymcmorris | |
L000566 | Robert Latta L000566 | BobLatta | boblatta | UCVSBVHoWu-eWnBBQaMKZ_sQ | 15394954 | CongressmanBobLatta | boblatta | 26367713 |
T000193 | Bennie Thompson T000193 | BennieGThompson | CongressmanBennieGThompson | UCzt2pBxh0dI24kYrWretXRw | 82453460 | RepBennieThompson | benniegthompson | 347410575 |
C001053 | Tom Cole C001053 | TomColeOK04 | TomColeOK04 | UCvqzPm_YnNkfEHpm3SEMJMQ | 23124635 | reptomcole | TomColeOK04 | |
W000814 | Randy Weber W000814 | TXRandy14 | TXRandy14 | UCJSZRrAcd5i1bHLjR66PZdg | 1058051748 | TXRandy14 | TXRandy14 | |
S001184 | Tim Scott S001184 | SenatorTimScott | SenatorTimScott | UCSfAsbG80CNInSKrtpKoL-w | 217543151 | SenatorTimScott | SenatorTimScott | |
W000802 | Sheldon Whitehouse W000802 | SenWhitehouse | SenatorWhitehouse | UCnG0N70SNBkNqvIMLodPTIA | 242555999 | SenatorWhitehouse | SenWhitehouse | |
K000393 | John Kennedy K000393 | SenJohnKennedy | JohnKennedyLouisiana | 816683274076614656 | SenJohnKennedy | |||
D000622 | Tammy Duckworth D000622 | SenDuckworth | SenDuckworth | UCYRWRvUxtjaHnFMCbdd94tg | 1058520120 | repduckworth | SenDuckworth | 1387939090 |
B001267 | Michael Bennet B001267 | SenatorBennet | senbennetco | UCXB3cljpMwTyCUyLr2ZVLow | 224285242 | SenatorBennet | SenBennetCO | |
A000372 | Rick Allen A000372 | RepRickAllen | CongressmanRickAllen | UCZPoYXHFDAV17BGLMzGAmpg | 2964287128 | Rep_RickAllen | 1666787116 | |
L000582 | Ted Lieu L000582 | RepTedLieu | RepTedLieu | UC9qcJxTqfDNBnVul1IojlFg | 3044993235 | RepTedLieu | ||
M001202 | Stephanie Murphy M001202 | RepStephMurphy | RepStephMurphy | 796183515998068736 | RepStephMurphy | RepStephMurphy | ||
R000486 | Lucille Roybal-Allard R000486 | RepRoybalAllard | RepRoybalAllard | UC_T_RXWeJ-smmpjdNLOaMcg | 479872233 | RepRoybalAllard | RepRoybalAllard | |
E000298 | Ron Estes E000298 | RepRonEstes | RepRonEstes | UC2clc28qcehIqotHQcthnWA | 854715071116849157 | RepRonEstes | ||
M001194 | John Moolenaar M001194 | RepMoolenaar | RepMoolenaar | UCnMvVN4a8roZu4crE0UW2DA | 2696643955 | RepMoolenaar | ||
J000299 | Mike Johnson J000299 | RepMikeJohnson | RepMikeJohnson | UCzqBEpeIaDEfvAtsA53Fx2Q | 827279765287559171 | RepMikeJohnson | ||
L000579 | Alan Lowenthal L000579 | RepLowenthal | RepLowenthal | UC-GgROtn5Hxm1H9a6qvy_Wg | 1055730738 | RepLowenthal | RepLowenthal |
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 );