social_media
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
528 rows sorted by facebook descending
This data as json, copyable, CSV (advanced)
id | legislator_id | facebook ▲ | youtube_id | twitter_id | youtube | instagram_id | ||
---|---|---|---|---|---|---|---|---|
L000397 | Zoe Lofgren L000397 | RepZoeLofgren | zoelofgren | UCOaQ79adORFcaTuJZoIFuZQ | 267938462 | RepZoeLofgren | ||
D000482 | Michael Doyle D000482 | USRepMikeDoyle | usrepmikedoyle | UCni9vINmgerEeVXhKCC9qbA | 39249305 | CongressmanDoyle | ||
C000174 | Thomas Carper C000174 | SenatorCarper | tomcarper | UCgLnvbKwu4B3navofj6Qvvw | 249787913 | senatorcarper | ||
R000577 | Tim Ryan R000577 | RepTimRyan | timryan | UCjAFlYCheFKjGg_Pxc2VOFA | 13491312 | timryanvision | ||
C001035 | Susan Collins C001035 | SenatorCollins | susancollins | UC6GYaBx5kT2r4PN8KENxC-w | 19726613 | SenatorSusanCollins | sensusancollins | |
P000601 | Steven Palazzo P000601 | CongPalazzo | stevenpalazzo | UCtPOy2vRbN2nD8dQPSOTXeA | 299883942 | CongressmanPalazzo | congressmanpalazzo | |
C001047 | Shelley Capito C001047 | SenCapito | senshelley | UCbiXdR4XQ3vD9Xp5lfR9QXw | 193794406 | sencapito | 1640447624 | |
S000148 | Charles Schumer S000148 | SenSchumer | senschumer | UC-ABttxh8uQv_10qmwGaidw | 17494010 | SenatorSchumer | ||
J000293 | Ron Johnson J000293 | SenRonJohnson | senronjohnson | UCG9XyTVtOAs7VX_q_QVHoaw | 233737858 | SenatorRonJohnson | senronjohnson | |
P000449 | Robert Portman P000449 | SenRobPortman | senrobportman | UCwunkd8Zs-yAWKQwnwBp7ew | 18915145 | SenRobPortman | senrobportman | 370356159 |
E000295 | Joni Ernst E000295 | SenJoniErnst | senjoniernst | UCLwrmtF_84FIcK3TyMs4MIw | 2856787757 | senjoniernst | 1582702853 | |
B001267 | Michael Bennet B001267 | SenatorBennet | senbennetco | UCXB3cljpMwTyCUyLr2ZVLow | 224285242 | SenatorBennet | SenBennetCO | |
T000461 | Patrick Toomey T000461 | SenToomey | senatortoomey | UCDUM4FFU1p-_YuHqmBglyXw | 221162525 | sentoomey | ||
T000464 | Jon Tester T000464 | SenatorTester | senatortester | UCgXAF-CON1coZFMxQkfj0fg | 515822213 | senatorjontester | ||
B001230 | Tammy Baldwin B001230 | SenatorBaldwin | senatortammybaldwin | UC_XjYCRbbI2_TDDjJidwk0Q | 1074518754 | witammybaldwin | senatorbaldwin | |
S000033 | Bernard Sanders S000033 | SenSanders | senatorsanders | UCD_DaKNac0Ta-2PeHuoQ1uA | 29442313 | senatorsanders | ||
L000577 | Mike Lee L000577 | SenMikeLee | senatormikelee | UCplVxs_j_sLAt0fkplXcl4A | 88784440 | senatormikelee | senmikelee | 391361701 |
M000639 | Robert Menendez M000639 | SenatorMenendez | senatormenendez | UC0PV0K9Z5a9p3D5917KF5fw | 18695134 | SenatorMenendezNJ | senatormenendez | 433044338 |
R000584 | James Risch R000584 | SenatorRisch | senatorjimrisch | UCncKW8xyT5UbPNO27YuQnBA | 1096059529 | SenatorJamesRisch | ||
H001042 | Mazie Hirono H001042 | MazieHirono | senatorhirono | UCcoKhxad156flzPYJ8JMFOA | 92186819 | CongresswomanHirono | maziehirono | 304094084 |
F000062 | Dianne Feinstein F000062 | SenFeinstein | senatorfeinstein | UCtVC--6LR0ff2aOP8THpuEw | 476256944 | SenatorFeinstein | ||
W000817 | Elizabeth Warren W000817 | SenWarren | senatorelizabethwarren | UCTH9zV8Imw09J5bOoTR18_A | 970207298 | senelizabethwarren | senwarren | |
F000463 | Deb Fischer F000463 | SenatorFischer | senatordebfischer | UCrbEfZaG_WhB0PBHI1hefPQ | 1071402577 | senatordebfischer | senatorfischer | |
C001088 | Christopher Coons C001088 | ChrisCoons | senatorchriscoons | UC2lOVbsddn1HIkcDnmCw6tA | 15324851 | senatorchriscoons | senatorchriscoons | 25194715 |
C000127 | Maria Cantwell C000127 | SenatorCantwell | senatorcantwell | UCN52UDqKgvHRk39ncySrIMw | 117501995 | SenatorCantwell | ||
C000141 | Benjamin Cardin C000141 | SenatorCardin | senatorbencardin | UCiQaJnMzlfzzG3VESgyZChA | 109071031 | senatorcardin | senatorcardin | |
C001056 | John Cornyn C001056 | JohnCornyn | sen.johncornyn | UCyQwLQavlOaJ64YuY_VMtiQ | 13218102 | senjohncornyn | ||
B000490 | Sanford Bishop B000490 | SanfordBishop | sanfordbishop | UCxF9veLBrkr_CqVq5eFYVGg | 249410485 | RepSanfordBishop | ||
C001067 | Yvette Clarke C001067 | RepYvetteClarke | repyvettedclarke | UC8SuQiuL2P9fUHAxuRoTdUQ | 240812994 | repyvetteclarke | repyvettedclarke | |
H001074 | Trey Hollingsworth H001074 | RepTrey | reptrey | UCTgS8a_zLg8HpUnk5WXY5ag | 811986281177772032 | |||
K000388 | Trent Kelly K000388 | RepTrentKelly | reptrentkelly | UCtDrz-8tdg4ZgOAQHToSWaQ | 3317799825 | reptrentkelly | ||
R000597 | Tom Rice R000597 | RepTomRice | reptomrice | UCEmPVQphMGoXAfWJli68BEw | 1058345042 | RepTomRice | reptomrice | |
E000294 | Tom Emmer E000294 | RepTomEmmer | reptomemmer | 2914515430 | RepTomEmmer | reptomemmer | 1565640999 | |
L000562 | Stephen Lynch L000562 | RepStephenLynch | repstephenlynch | UCxL4zG0YWqC5XTO4af_FOgw | 310310133 | RepLynch | repstephenlynch | |
P000610 | Stacey Plaskett P000610 | StaceyPlaskett | repstaceyplaskett | UC3V7biFZHDFHDFZy6cCSZUA | 2724095695 | stacey_plaskett | ||
P000605 | Scott Perry P000605 | RepScottPerry | repscottperry | UCzgrU5PT_HHRgf5hXPen4dQ | 18773159 | RepScottPerry | repscottperry | 519463466 |
S001180 | Kurt Schrader S001180 | RepSchrader | repschrader | UCrWRXVaGJtcImc_kknuDsAw | 20545793 | repkurtschrader | ||
C001112 | Salud Carbajal C001112 | RepCarbajal | repsaludcarbajal | 816157667882373120 | repcarbajal | repcarbajal | ||
K000188 | Ron Kind K000188 | RepRonKind | repronkind | UC0_BilariURHwSHf9baGykg | 112740986 | RepRonKind | ||
K000385 | Robin Kelly K000385 | RepRobinKelly | reprobinkelly | UCLhcNPX2nNQLNzwKW0nEykg | 1339931490 | reprobinkelly | ||
N000015 | Richard Neal N000015 | RepRichardNeal | reprichardneal | UCZVtTydu0-MSK6G12GaKA4g | 442824717 | RepRichardENeal | ||
R000606 | Jamie Raskin R000606 | RepRaskin | repraskin | UChxDE6vho5BfBTOqiBsDmKg | 806906355214852096 | repraskin | ||
A000371 | Pete Aguilar A000371 | RepPeteAguilar | reppeteaguilar | UCxwbFLOlKDsXrwizV5jah7g | 3018670151 | |||
T000469 | Paul Tonko T000469 | RepPaulTonko | reppaultonko | UC3P2SGFmmuCYRsjeso0hOQQ | 84119348 | reppaultonko | reppaultonko | |
O000171 | Tom O’Halleran O000171 | RepOHalleran | repohalleran | 808416682972770304 | repohalleran | |||
Q000023 | Mike Quigley Q000023 | RepMikeQuigley | repmikequigley | UCDP13XegdoZ4bxYHxM34yAA | 56864092 | RepMikeQuigley | repmikequigley | 1403659583 |
P000607 | Mark Pocan P000607 | RepMarkPocan | repmarkpocan | UCz5b47WER_u3dUGV_Zi70dQ | 1206227149 | repmarkpocan | repmarkpocan | 1422301608 |
L000583 | Barry Loudermilk L000583 | RepLoudermilk | reploudermilk | UC2Kfw8fjca8k3w3KpzL5tNg | 2914163523 | RepLoudermilk | ||
C001109 | Liz Cheney C001109 | RepLizCheney | replizcheney | UCvL57Zp99QdDllF-KGziUAA | 816719802328715264 | |||
L000585 | Darin LaHood L000585 | RepLaHood | replahood | UCVRbtFwaBGcixZIkygtalRw | 3686482216 | |||
B001297 | Ken Buck B001297 | RepKenBuck | repkenbuck | UCHK7Wcwij7NoxXGTeSHUWzg | 2862577383 | repkenbuck | ||
J000289 | Jim Jordan J000289 | Jim_Jordan | repjimjordan | UCPFBhS00ivPV585GlnNlyqA | 18166778 | RepJimJordan | ||
S001195 | Jason Smith S001195 | RepJasonSmith | repjasonsmith | UCzj9-27Lr4gcqopmZAobXXg | 1623308912 | RepJasonSmith | ||
M001188 | Grace Meng M001188 | RepGraceMeng | repgracemeng | UCHg516zJKbIBtXFAJ0nu3XQ | 1051127714 | |||
G000565 | Paul Gosar G000565 | RepGosar | repgosar | UC5orqw_9acsKWSRbrqTDXBw | 240760644 | repgosar | REPGOSAR | |
G000559 | John Garamendi G000559 | RepGaramendi | repgaramendi | UCRym1qsO72C39gX6pBu4icg | 88806753 | garamendiCA10 | repgaramendi | |
P000034 | Frank Pallone P000034 | FrankPallone | repfrankpallone | UCN0_wn9hs1LI3UKkji2PP2A | 31801993 | repfrankpallone | repfrankpallone | |
S001183 | David Schweikert S001183 | RepDavid | repdavidschweikert | UCVvuNVzkOUp7p_Pzkc6Zuvw | 229197216 | RepDavidSchweikert | repdavid | 181147397 |
B001311 | Dan Bishop B001311 | RepDanBishop | repdanbishop | 1176522535531360257 | ||||
F000459 | Charles Fleischmann F000459 | RepChuck | repchuck | UCTtRrJkM-R-f2K0byCMvHgw | 235190657 | repchuck | ||
C001097 | Tony Cárdenas C001097 | RepCardenas | repcardenas | UCm6ug1-yvYGL0F6DvYxfFBA | 1222257180 | repcardenas | repcardenas | 1483357690 |
M001199 | Brian Mast M001199 | RepBrianMast | repbrianmast | 814103950404239360 | repbrianmast | RepBrianMast | ||
F000466 | Brian Fitzpatrick F000466 | RepBrianFitz | repbrianfitzpatrick | UCYMNcgHss4_Q5JY2vSvMpgw | 816303263586914304 | repbrianfitz | ||
M001143 | Betty McCollum M001143 | BettyMcCollum04 | repbettymccollum | UC3sZJSdiZo2EBHbsOlsnI7A | 516880804 | BMcCollum04 | repbettymccollum | |
G000553 | Al Green G000553 | RepAlGreen | repalgreen | UCFtgMZm1YUXaZ8OtOj-GDjA | 156333623 | RepAlGreen | repalgreen | |
P000096 | Bill Pascrell P000096 | BillPascrell | pascrell | UCIy1Ru8oA14aRjpq6L3i-EQ | 74508260 | RepPascrell | ||
M000355 | Mitch McConnell M000355 | McConnellPress | mitchmcconnell | 339822881 | mcconnellpress | |||
C000880 | Michael Crapo C000880 | MikeCrapo | mikecrapo | UCMHzKHg1BE7dEcFjnayw1lA | 600463589 | senatorcrapo | mikecrapo | 329357214 |
M001157 | Michael McCaul M001157 | RepMcCaul | michaeltmccaul | UCRw6sGE0PH7_FCeTT3PQRaA | 26424123 | MichaelTMcCaul | congressman_mccaul | |
B001248 | Michael Burgess B001248 | MichaelCBurgess | michaelcburgess | UCvvO8lo-Nkc31cEEElqQvQw | 15751083 | michaelcburgessmd | repmichaelburgess | |
D000600 | Mario Diaz-Balart D000600 | MarioDB | mdiazbalart | UCpEEd0Plxx5D78pI4a4mFTQ | 37094727 | MarioDiazBalart | repmariodb | 316477657 |
M001159 | Cathy McMorris Rodgers M001159 | CathyMcMorris | mcmorrisrodgers | UCRp0lwIxAhq2Ia9_YgRWUkg | 17976923 | mcmorrisrodgers | cathymcmorris | |
B001243 | Marsha Blackburn B001243 | MarshaBlackburn | marshablackburn | UCvNnmu5mUm7xr8QXBlbtQ9w | 278145569 | RepMarshaBlackburn | marshablackburn | |
D000399 | Lloyd Doggett D000399 | RepLloydDoggett | lloyddoggett | UCN-kiLKyHPcfRVZ28sAHS_g | 153944899 | doggett | replloyddoggett | |
B000755 | Kevin Brady B000755 | RepKevinBrady | kevinbrady | UC6Ng0uMQEBVgXO_HF0NbfXA | 19926675 | KBrady8 | repkevinbrady | 337613850 |
C001051 | John Carter C001051 | JudgeCarter | judgecarter | UC9pkaOrhPfouzkJ8oAdI-1w | 18030431 | repjohncarter | judgecarter | 456560563 |
B001261 | John Barrasso B001261 | SenJohnBarrasso | johnbarrasso | UC80PfiCAB2Fe1MFayWlR6GQ | 202206694 | barrassowyo | ||
C001069 | Joe Courtney C001069 | RepJoeCourtney | joecourtney | UCGVIfe1T2hO1Lx7ap5Wkv1w | 85396297 | repcourtney | repjoecourtney | |
I000024 | James Inhofe I000024 | JimInhofe | jiminhofe | UCk3W3ilX8vGG-300qzNpG7w | 7270292 | jiminhofepressoffice | ||
M000934 | Jerry Moran M000934 | JerryMoran | jerrymoran | UC1oRxeUPam6-53wPBZ3N02A | 18632666 | senatorjerrymoran | senjerrymoran | 298271065 |
M001166 | Jerry McNerney M001166 | RepMcNerney | jerrymcnerney | UClUOx6F8GKshxGBUBLkisug | 385429543 | RepJerryMcNerney | ||
M001176 | Jeff Merkley M001176 | SenJeffMerkley | jeffmerkley | UCRoXttCJhMnLVCxCaa6VnNQ | 29201047 | SenatorJeffMerkley | senjeffmerkley | 501463589 |
S001145 | Janice Schakowsky S001145 | JanSchakowsky | janschakowsky | UCuCHHPSENUEaaeH8n_CYDXQ | 24195214 | repschakowsky | ||
C000537 | James Clyburn C000537 | WhipClyburn | jameseclyburn | UCIyU_UA_JEa14gvAwhquKqg | 188019606 | repjamesclyburn | ||
H001056 | Jaime Herrera Beutler H001056 | HerreraBeutler | herrerabeutler | UCJEgiA9clfx0amrQUj0aBTQ | 242926427 | RepHerreraBeutler | herrerabeutler | |
M001137 | Gregory Meeks M001137 | RepGregoryMeeks | gregorymeeksny05 | UCljJnwgQS6Z6-NypDyqKJZQ | 22812754 | gwmeeks | repgregorymeeks | |
G000386 | Charles Grassley G000386 | ChuckGrassley | grassley | UCiCPRkcLMInpDeOqGkMTt4w | 10615232 | senchuckgrassley | senatorchuckgrassley | |
C001061 | Emanuel Cleaver C001061 | RepCleaver | emanuelcleaverii | UCVC-7CLFjXczoihr5FxDLsw | 163570705 | repcleaver | ||
D000628 | Neal Dunn D000628 | DrNealDunnFL2 | drnealdunnfl2 | UCRTGfrYP-RuDzJ2KGok7TRA | 815952318487298048 | |||
M001163 | Doris Matsui M001163 | DorisMatsui | doris.matsui | UCSqqxVkvskHq3cY2MCbTZsw | 38254095 | RepDorisMatsui | repdorismatsui | |
K000381 | Derek Kilmer K000381 | RepDerekKilmer | derek.kilmer | 1058917562 | ||||
B001278 | Suzanne Bonamici B001278 | RepBonamici | congresswomanbonamici | UC0IkAeEiwgzSRTD1TDSvuBw | 558769636 | RepSuzanneBonamici | RepBonamici | |
K000391 | Raja Krishnamoorthi K000391 | CongressmanRaja | congressmanraja | 814179031956488192 | congressmanraja | |||
B001251 | George Butterfield B001251 | GKButterfield | congressmangkbutterfield | UCbodCVgLfcbaep49L1M-mqA | 432676344 | GKBNC01 | ||
C001108 | James Comer C001108 | RepJamesComer | congressmancomer | 1274852794206388225 | congressmancomer | |||
C001103 | Earl Carter C001103 | RepBuddyCarter | congressmanbuddycarter | UCHQm49T6ikD_ioMAt50AwKQ | 2973870195 | |||
R000515 | Bobby Rush R000515 | RepBobbyRush | congressmanbobbyrush | UCbWqxBnS_w_uFTdQAL0YH5g | 305216911 | CongressmanRush | ||
V000128 | Chris Van Hollen V000128 | ChrisVanHollen | chrisvanhollen | UCkpfJWu1N9Okd6PE_NidtBQ | 18137749 | RepChrisVanHollen | chrisvanhollen | 268595235 |
M001169 | Christopher Murphy M001169 | SenMurphyOffice | chrismurphyct | UCbcEa40PIFpLpdDe06n3F3Q | 2853793517 | senchrismurphy | ||
L000566 | Robert Latta L000566 | BobLatta | boblatta | UCVSBVHoWu-eWnBBQaMKZ_sQ | 15394954 | CongressmanBobLatta | boblatta | 26367713 |
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 );