social_media
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
528 rows sorted by twitter descending
This data as json, copyable, CSV (advanced)
id | legislator_id | twitter ▲ | youtube_id | twitter_id | youtube | instagram_id | ||
---|---|---|---|---|---|---|---|---|
H001082 | Kevin Hern H001082 | repkevinhern | 1067818539179024386 | |||||
I000056 | Darrell Issa I000056 | repdarrellissa | 63650107 | |||||
C000537 | James Clyburn C000537 | WhipClyburn | jameseclyburn | UCIyU_UA_JEa14gvAwhquKqg | 188019606 | repjamesclyburn | ||
D000626 | Warren Davidson D000626 | WarrenDavidson | CongressmanWarrenDavidson | UCMzuyZWzk44YRNesFzPTeUw | 742735530287304704 | instawarrendavidson | ||
F000450 | Virginia Foxx F000450 | VirginiaFoxx | RepVirginiaFoxx | UCggineJcxJn80TRXxdQbx6w | 16256269 | repvirginiafoxx | repvirginiafoxx | |
B001260 | Vern Buchanan B001260 | VernBuchanan | CongressmanBuchanan | UCY4DEy41NxOTdcF8_XAVZvw | 20467163 | vernbuchanan | repvern | 344865327 |
D000482 | Michael Doyle D000482 | USRepMikeDoyle | usrepmikedoyle | UCni9vINmgerEeVXhKCC9qbA | 39249305 | CongressmanDoyle | ||
L000576 | Billy Long L000576 | USRepLong | Rep.Billy.Long | UCLQcbyxpHXXAsUJckscQY8g | 1444015610 | MOdistrict7 | ||
K000375 | William Keating K000375 | USRepKeating | Congressman.Keating | UC7KPV4xdxO2dms9vl6tETmg | 232992031 | RepBillKeating | ||
C001066 | Kathy Castor C001066 | USRepKCastor | USRepKathyCastor | UC_irxhmLqVenTFPxDxznG6g | 1880674038 | RepKathyCastor | ||
P000609 | Gary Palmer P000609 | USRepGaryPalmer | CongressmanGaryPalmer | UCYZfP-cNIvlJY3AcAc9OPpQ | 2861616083 | repgarypalmer | 1551536636 | |
C001053 | Tom Cole C001053 | TomColeOK04 | TomColeOK04 | UCvqzPm_YnNkfEHpm3SEMJMQ | 23124635 | reptomcole | TomColeOK04 | |
W000814 | Randy Weber W000814 | TXRandy14 | TXRandy14 | UCJSZRrAcd5i1bHLjR66PZdg | 1058051748 | TXRandy14 | TXRandy14 | |
S001176 | Steve Scalise S001176 | SteveScalise | RepSteveScalise | UCmYveHBVXVBRxl7GiCL-gjw | 1209417007 | RepSteveScalise | stevescalise | 1210937919 |
D000618 | Steve Daines D000618 | SteveDaines | SteveDainesMT | UC-ny-W5mEUGytiyMdXbQ20Q | 11651202 | SteveDainesMT | stevedaines | 371125857 |
P000610 | Stacey Plaskett P000610 | StaceyPlaskett | repstaceyplaskett | UC3V7biFZHDFHDFZy6cCSZUA | 2724095695 | stacey_plaskett | ||
P000197 | Nancy Pelosi P000197 | SpeakerPelosi | NancyPelosi | UCxPeEcH0xaCK9nBK98EFhDg | 15764644 | nancypelosi | ||
W000437 | Roger Wicker W000437 | SenatorWicker | SenatorWicker | UCIlKHiTjSkcQP_knBcXHWSg | 264219447 | SenatorWicker | senatorwicker | 367948073 |
W000790 | Raphael Warnock W000790 | SenatorWarnock | 1352287997853622273 | |||||
S001184 | Tim Scott S001184 | SenatorTimScott | SenatorTimScott | UCSfAsbG80CNInSKrtpKoL-w | 217543151 | SenatorTimScott | SenatorTimScott | |
T000464 | Jon Tester T000464 | SenatorTester | senatortester | UCgXAF-CON1coZFMxQkfj0fg | 515822213 | senatorjontester | ||
S001191 | Kyrsten Sinema S001191 | SenatorSinema | CongresswomanSinema | UC4NzhW7D4lQdukSGWmFnK9w | 1080844782 | repsinema | repsinema | |
S001181 | Jeanne Shaheen S001181 | SenatorShaheen | SenatorShaheen | UCjLZAZMbDrybHyttdEC9LFA | 109287731 | senatorshaheen | senatorshaheen | |
R000605 | Mike Rounds R000605 | SenatorRounds | SenatorMikeRounds | UC-pvzimyBdpdkcIfsicrfrQ | 2955485182 | |||
R000615 | Mitt Romney R000615 | SenatorRomney | 1078693601356509184 | |||||
R000584 | James Risch R000584 | SenatorRisch | senatorjimrisch | UCncKW8xyT5UbPNO27YuQnBA | 1096059529 | SenatorJamesRisch | ||
M000639 | Robert Menendez M000639 | SenatorMenendez | senatormenendez | UC0PV0K9Z5a9p3D5917KF5fw | 18695134 | SenatorMenendezNJ | senatormenendez | 433044338 |
M001198 | Roger Marshall M001198 | SenatorMarshall | 1336344005588738052 | |||||
L000570 | Ben Luján L000570 | SenatorLujan | 19318314 | |||||
L000174 | Patrick Leahy L000174 | SenatorLeahy | SenatorPatrickLeahy | UC46QHVobf7FO-tWehsRoDog | 242836537 | SenatorPatrickLeahy | senatorleahy | |
L000575 | James Lankford L000575 | SenatorLankford | SenatorLankford | UCz8T6sK5fEycyWmVz6Vpe5Q | 225921757 | SenatorLankford | senatorlankford | 1552251018 |
H000273 | John Hickenlooper H000273 | SenatorHick | 1318728336923787264 | |||||
H001076 | Margaret Hassan H001076 | SenatorHassan | SenatorHassan | 946549322 | ||||
H000601 | Bill Hagerty H000601 | SenatorHagerty | 1346873610875654147 | |||||
F000463 | Deb Fischer F000463 | SenatorFischer | senatordebfischer | UCrbEfZaG_WhB0PBHI1hefPQ | 1071402577 | senatordebfischer | senatorfischer | |
D000563 | Richard Durbin D000563 | SenatorDurbin | SenatorDurbin | UCkbixlNCxcKAffEhe3X5-lw | 247334603 | SenatorDurbin | ||
C001035 | Susan Collins C001035 | SenatorCollins | susancollins | UC6GYaBx5kT2r4PN8KENxC-w | 19726613 | SenatorSusanCollins | sensusancollins | |
C000174 | Thomas Carper C000174 | SenatorCarper | tomcarper | UCgLnvbKwu4B3navofj6Qvvw | 249787913 | senatorcarper | ||
C000141 | Benjamin Cardin C000141 | SenatorCardin | senatorbencardin | UCiQaJnMzlfzzG3VESgyZChA | 109071031 | senatorcardin | senatorcardin | |
C000127 | Maria Cantwell C000127 | SenatorCantwell | senatorcantwell | UCN52UDqKgvHRk39ncySrIMw | 117501995 | SenatorCantwell | ||
B001135 | Richard Burr B001135 | SenatorBurr | SenatorRichardBurr | UCOLLZpp-1womBSFDV2uLfag | 21157904 | SenatorRichardBurr | senatorburr | |
B001310 | Mike Braun B001310 | SenatorBraun | 1080870981877534720 | |||||
B001267 | Michael Bennet B001267 | SenatorBennet | senbennetco | UCXB3cljpMwTyCUyLr2ZVLow | 224285242 | SenatorBennet | SenBennetCO | |
B001230 | Tammy Baldwin B001230 | SenatorBaldwin | senatortammybaldwin | UC_XjYCRbbI2_TDDjJidwk0Q | 1074518754 | witammybaldwin | senatorbaldwin | |
M001183 | Joe Manchin M001183 | Sen_JoeManchin | JoeManchinIII | UCGyPK_ye2ptpzQgOjKIn7ag | 234374703 | SenatorJoeManchin | ||
W000802 | Sheldon Whitehouse W000802 | SenWhitehouse | SenatorWhitehouse | UCnG0N70SNBkNqvIMLodPTIA | 242555999 | SenatorWhitehouse | SenWhitehouse | |
W000817 | Elizabeth Warren W000817 | SenWarren | senatorelizabethwarren | UCTH9zV8Imw09J5bOoTR18_A | 970207298 | senelizabethwarren | senwarren | |
T000278 | Tommy Tuberville T000278 | SenTuberville | 1345739193721487362 | |||||
T000461 | Patrick Toomey T000461 | SenToomey | senatortoomey | UCDUM4FFU1p-_YuHqmBglyXw | 221162525 | sentoomey | ||
C001095 | Tom Cotton C001095 | SenTomCotton | SenatorTomCotton | UCXEk6mokWBajIpNatbjnwSg | 968650362 | RepTomCotton | ||
Y000064 | Todd Young Y000064 | SenToddYoung | SenatorToddYoung | UCuknj4PGn91gHDNAfboZEgQ | 234128524 | RepToddYoung | sentoddyoung | |
S001203 | Tina Smith S001203 | SenTinaSmith | USSenTinaSmith | 941000686275387392 | ||||
T000476 | Thom Tillis T000476 | SenThomTillis | SenatorThomTillis | UCUD9VGV4SSGWjGdbn37Ea2w | 2964174789 | senthomtillis | ||
C001098 | Ted Cruz C001098 | SenTedCruz | SenatorTedCruz | UCOTZ-6H1rri1lSsj6IzhUyw | 1074480192 | sentedcruz | ||
S000770 | Debbie Stabenow S000770 | SenStabenow | SenatorStabenow | UCFoDKCvxSwCUfDv-4Eg4K5A | 76456274 | senatorstabenow | ||
B000944 | Sherrod Brown B000944 | SenSherrodBrown | SenatorSherrodBrown | UCgy8jfERh-t_ixkKKoCmglQ | 43910797 | SherrodBrownOhio | ||
S000320 | Richard Shelby S000320 | SenShelby | RichardShelby | UCyMzDCRZrmhr_OGDjVuAeJw | 21111098 | SenatorRichardShelby | ||
S000148 | Charles Schumer S000148 | SenSchumer | senschumer | UC-ABttxh8uQv_10qmwGaidw | 17494010 | SenatorSchumer | ||
S001197 | Benjamin Sasse S001197 | SenSasse | SenatorSasse | UCYaNGwcM2Dl5yDcDqS6xV2g | 2962923040 | senatorsasse | 1636974433 | |
S000033 | Bernard Sanders S000033 | SenSanders | senatorsanders | UCD_DaKNac0Ta-2PeHuoQ1uA | 29442313 | senatorsanders | ||
R000595 | Marco Rubio R000595 | SenRubioPress | SenatorMarcoRubio | UCh8t7sV_DBKz4A-RkL9feyg | 229966028 | SenatorMarcoRubio | ||
J000293 | Ron Johnson J000293 | SenRonJohnson | senronjohnson | UCG9XyTVtOAs7VX_q_QVHoaw | 233737858 | SenatorRonJohnson | senronjohnson | |
P000449 | Robert Portman P000449 | SenRobPortman | senrobportman | UCwunkd8Zs-yAWKQwnwBp7ew | 18915145 | SenRobPortman | senrobportman | 370356159 |
S001217 | Rick Scott S001217 | SenRickScott | RickScottSenOffice | UC-Y9pFmW4PYGZHkC8lcqSkQ | 131546062 | |||
P000603 | Rand Paul P000603 | SenRandPaul | SenatorRandPaul | UCeM9I-20oWUs8daIIpsNHoQ | 1298624375692894210 | SenatorRandPaul | senatorrandpaul | 541357095 |
O000174 | Jon Ossoff O000174 | SenOssoff | 1356714265894408196 | |||||
M001169 | Christopher Murphy M001169 | SenMurphyOffice | chrismurphyct | UCbcEa40PIFpLpdDe06n3F3Q | 2853793517 | senchrismurphy | ||
L000577 | Mike Lee L000577 | SenMikeLee | senatormikelee | UCplVxs_j_sLAt0fkplXcl4A | 88784440 | senatormikelee | senmikelee | 391361701 |
M000133 | Edward Markey M000133 | SenMarkey | EdJMarkey | UCT1ujew5yQy2uMhGrjiKHoA | 21406834 | RepMarkey | ||
K000377 | Mark Kelly K000377 | SenMarkKelly | SenMarkKelly | 1324926274888888320 | ||||
L000571 | Cynthia Lummis L000571 | SenLummis | 22831059 | |||||
C001096 | Kevin Cramer C001096 | SenKevinCramer | CongressmanKevinCramer | UCqUPdO9XaAW-dvwwXKbIVdA | 1048784496 | kevincramer | repkevincramer | |
E000295 | Joni Ernst E000295 | SenJoniErnst | senjoniernst | UCLwrmtF_84FIcK3TyMs4MIw | 2856787757 | senjoniernst | 1582702853 | |
T000250 | John Thune T000250 | SenJohnThune | UCRu6lpRfxhkDGUrKDgQNZYQ | 296361085 | johnthune | senjohnthune | ||
K000393 | John Kennedy K000393 | SenJohnKennedy | JohnKennedyLouisiana | 816683274076614656 | SenJohnKennedy | |||
H001061 | John Hoeven H001061 | SenJohnHoeven | SenatorJohnHoeven | UC1kQIC2Q_Fq9_NRqdb6eHiw | 382791093 | senatorjohnhoevennd | senjohnhoeven | 1237544252 |
B001261 | John Barrasso B001261 | SenJohnBarrasso | johnbarrasso | UC80PfiCAB2Fe1MFayWlR6GQ | 202206694 | barrassowyo | ||
M001176 | Jeff Merkley M001176 | SenJeffMerkley | jeffmerkley | UCRoXttCJhMnLVCxCaa6VnNQ | 29201047 | SenatorJeffMerkley | senjeffmerkley | 501463589 |
R000608 | Jacky Rosen R000608 | SenJackyRosen | RepJackyRosen | 818554054309715969 | repjackyrosen | |||
R000122 | John Reed R000122 | SenJackReed | SenJackReed | UCT_aFVtsjxPwWKfO-PW_hPw | 486694111 | SenatorReed | ||
H001079 | Cindy Hyde-Smith H001079 | SenHydeSmith | UCJHxkJhGST0NTlkzJHWV03Q | 983348251972816896 | sencindyhydesmith | |||
H001089 | Joshua Hawley H001089 | SenHawleyPress | 1080960924687704064 | |||||
P000595 | Gary Peters P000595 | SenGaryPeters | SenGaryPeters | UC7LYNbnKSK2VZqQ98YROWHQ | 236511574 | RepGaryPeters | sengarypeters | 1640246681 |
F000062 | Dianne Feinstein F000062 | SenFeinstein | senatorfeinstein | UCtVC--6LR0ff2aOP8THpuEw | 476256944 | SenatorFeinstein | ||
D000622 | Tammy Duckworth D000622 | SenDuckworth | SenDuckworth | UCYRWRvUxtjaHnFMCbdd94tg | 1058520120 | repduckworth | SenDuckworth | 1387939090 |
S001198 | Dan Sullivan S001198 | SenDanSullivan | SenDanSullivan | UC7tXCm8gKlAhTFo2kuf5ylw | 2891210047 | sen_dansullivan | 1660873387 | |
C001113 | Catherine Cortez Masto C001113 | SenCortezMasto | SenatorCortezMasto | UCip_83SiKUqwnUT57VOXrCg | 811313565760163844 | |||
C001047 | Shelley Capito C001047 | SenCapito | senshelley | UCbiXdR4XQ3vD9Xp5lfR9QXw | 193794406 | sencapito | 1640447624 | |
S001194 | Brian Schatz S001194 | SenBrianSchatz | SenBrianSchatz | UC8-mSYp2WqBiB_5iwtwKfow | 1262099252 | senbrianschatz | ||
B001288 | Cory Booker B001288 | SenBooker | UC6FlymqNS1VettnVZa7goPA | 2167097881 | SenCoryBooker | |||
C001070 | Robert Casey C001070 | SenBobCasey | SenatorBobCasey | UCtVssXhx-KuZa-hSvnsnJ0A | 171598736 | SenatorBobCasey | senbobcasey | |
B001277 | Richard Blumenthal B001277 | SenBlumenthal | SenBlumenthal | UCHH-fn3_LVt0Q4od56rOi5g | 278124059 | SenatorBlumenthal | ||
C001075 | Bill Cassidy C001075 | SenBillCassidy | UCCEyGhUzxgkxFzWCY-rxz8g | 1017500185356853248 | SenatorBillCassidy | |||
K000383 | Angus King K000383 | SenAngusKing | SenatorAngusSKingJr | UCpp6lGvrmt0XU_lnD4Ak0gA | 1068481578 | SenatorAngusKing | ||
K000367 | Amy Klobuchar K000367 | SenAmyKlobuchar | UCvdeJsDsV51tFb_hVqvtYGA | 22044727 | senatorklobuchar | |||
P000145 | Alejandro Padilla P000145 | SenAlexPadilla | 1351236267707654145 | |||||
B000490 | Sanford Bishop B000490 | SanfordBishop | sanfordbishop | UCxF9veLBrkr_CqVq5eFYVGg | 249410485 | RepSanfordBishop | ||
B000575 | Roy Blunt B000575 | RoyBlunt | SenatorBlunt | UCFeLRzjhThTmaWzuh5qjpGA | 21269970 | SenatorBlunt | royblunt | 21185436 |
D000216 | Rosa DeLauro D000216 | RosaDeLauro | CongresswomanRosaDeLauro | UC9ROfGBm7kSLCEDYwFF6McQ | 140519774 | rosadelauro | ||
W000779 | Ron Wyden W000779 | RonWyden | UCsd3UEaoLoqX60P88BdpGGw | 250188760 | senronwyden | ronwyden | 9443881 |
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 );