social_media
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
528 rows sorted by instagram_id descending
This data as json, copyable, CSV (advanced)
id | legislator_id | youtube_id | twitter_id | youtube | instagram_id ▲ | |||
---|---|---|---|---|---|---|---|---|
A000372 | Rick Allen A000372 | RepRickAllen | CongressmanRickAllen | UCZPoYXHFDAV17BGLMzGAmpg | 2964287128 | Rep_RickAllen | 1666787116 | |
S001198 | Dan Sullivan S001198 | SenDanSullivan | SenDanSullivan | UC7tXCm8gKlAhTFo2kuf5ylw | 2891210047 | sen_dansullivan | 1660873387 | |
C001047 | Shelley Capito C001047 | SenCapito | senshelley | UCbiXdR4XQ3vD9Xp5lfR9QXw | 193794406 | sencapito | 1640447624 | |
P000595 | Gary Peters P000595 | SenGaryPeters | SenGaryPeters | UC7LYNbnKSK2VZqQ98YROWHQ | 236511574 | RepGaryPeters | sengarypeters | 1640246681 |
S001197 | Benjamin Sasse S001197 | SenSasse | SenatorSasse | UCYaNGwcM2Dl5yDcDqS6xV2g | 2962923040 | senatorsasse | 1636974433 | |
E000295 | Joni Ernst E000295 | SenJoniErnst | senjoniernst | UCLwrmtF_84FIcK3TyMs4MIw | 2856787757 | senjoniernst | 1582702853 | |
E000294 | Tom Emmer E000294 | RepTomEmmer | reptomemmer | 2914515430 | RepTomEmmer | reptomemmer | 1565640999 | |
W000800 | Peter Welch W000800 | PeterWelch | PeterWelch | UC0YfApJx6qNaAQ-ir93U8xA | 1410590874 | reppeterwelch | reppeterwelch | 1559860900 |
L000575 | James Lankford L000575 | SenatorLankford | SenatorLankford | UCz8T6sK5fEycyWmVz6Vpe5Q | 225921757 | SenatorLankford | senatorlankford | 1552251018 |
P000609 | Gary Palmer P000609 | USRepGaryPalmer | CongressmanGaryPalmer | UCYZfP-cNIvlJY3AcAc9OPpQ | 2861616083 | repgarypalmer | 1551536636 | |
C001097 | Tony Cárdenas C001097 | RepCardenas | repcardenas | UCm6ug1-yvYGL0F6DvYxfFBA | 1222257180 | repcardenas | repcardenas | 1483357690 |
P000607 | Mark Pocan P000607 | RepMarkPocan | repmarkpocan | UCz5b47WER_u3dUGV_Zi70dQ | 1206227149 | repmarkpocan | repmarkpocan | 1422301608 |
L000551 | Barbara Lee L000551 | RepBarbaraLee | RepBarbaraLee | UCnRgK2MXAQOUau0JXqseeNA | 248735463 | RepLee | repbarbaralee | 1415801245 |
Q000023 | Mike Quigley Q000023 | RepMikeQuigley | repmikequigley | UCDP13XegdoZ4bxYHxM34yAA | 56864092 | RepMikeQuigley | repmikequigley | 1403659583 |
D000622 | Tammy Duckworth D000622 | SenDuckworth | SenDuckworth | UCYRWRvUxtjaHnFMCbdd94tg | 1058520120 | repduckworth | SenDuckworth | 1387939090 |
H001061 | John Hoeven H001061 | SenJohnHoeven | SenatorJohnHoeven | UC1kQIC2Q_Fq9_NRqdb6eHiw | 382791093 | senatorjohnhoevennd | senjohnhoeven | 1237544252 |
S001176 | Steve Scalise S001176 | SteveScalise | RepSteveScalise | UCmYveHBVXVBRxl7GiCL-gjw | 1209417007 | RepSteveScalise | stevescalise | 1210937919 |
S000185 | Robert Scott S000185 | BobbyScott | RepBobbyScott | UCdNNcpw8arCsUp55JwK_QAA | 161791703 | repbobbyscott | repbobbyscott | 1173348983 |
T000468 | Dina Titus T000468 | RepDinaTitus | CongresswomanTitus | UC_US4jNqECuMSNrB7yVCbbw | 122174004 | CongresswomanTitus | dinatitusnv | 1110185253 |
C000754 | Jim Cooper C000754 | RepJimCooper | JimCooper | UCjplyIIQbNZcl013AyDfPNg | 22523087 | RepJimCooper | repjimcooper | 1037212884 |
H001053 | Vicky Hartzler H001053 | RepHartzler | Congresswoman.Hartzler | UCAvttUz6qBVEJiFt7p_MZxw | 237763317 | repvickyhartzler | rephartzler | 787899303 |
J000292 | Bill Johnson J000292 | RepBillJohnson | RepBillJohnson | UCtF08Ay71haDRoJosRN2P_Q | 211530910 | RepBillJohnson | repbilljohnson | 763495818 |
V000131 | Marc Veasey V000131 | RepVeasey | CongressmanMarcVeasey | UC2CRp1KF5uljZyhDRPR-72Q | 1074129612 | marcveasey | repveasey | 676925345 |
K000380 | Daniel Kildee K000380 | RepDanKildee | RepDanKildee | UC_KpQ-n3IT5dL5ul21XA9Yw | 1045110018 | RepDanKildee | repdankildee | 582887115 |
B001281 | Joyce Beatty B001281 | RepBeatty | RepJoyceBeatty | UCtVl3kb7Xvt3pY7l6x-M6LA | 1531521632 | repbeatty | 554027718 | |
P000603 | Rand Paul P000603 | SenRandPaul | SenatorRandPaul | UCeM9I-20oWUs8daIIpsNHoQ | 1298624375692894210 | SenatorRandPaul | senatorrandpaul | 541357095 |
W000795 | Joe Wilson W000795 | RepJoeWilson | JoeWilson | UC3aR1B8m7Z1uycO65yDnpCg | 254082173 | RepJoeWilson | repjoewilson | 519685522 |
P000605 | Scott Perry P000605 | RepScottPerry | repscottperry | UCzgrU5PT_HHRgf5hXPen4dQ | 18773159 | RepScottPerry | repscottperry | 519463466 |
W000805 | Mark Warner W000805 | MarkWarner | MarkRWarner | UCwyivNlEGf4sGd1oDLfY5jw | 7429102 | SenatorMarkWarner | senatorwarner | 515327940 |
M001176 | Jeff Merkley M001176 | SenJeffMerkley | jeffmerkley | UCRoXttCJhMnLVCxCaa6VnNQ | 29201047 | SenatorJeffMerkley | senjeffmerkley | 501463589 |
C000266 | Steve Chabot C000266 | RepSteveChabot | RepSteveChabot | UCJpzm2DZDE1B6ruQLQc7q4g | 237750442 | congressmanchabot | repstevechabot | 481906395 |
C001051 | John Carter C001051 | JudgeCarter | judgecarter | UC9pkaOrhPfouzkJ8oAdI-1w | 18030431 | repjohncarter | judgecarter | 456560563 |
M000639 | Robert Menendez M000639 | SenatorMenendez | senatormenendez | UC0PV0K9Z5a9p3D5917KF5fw | 18695134 | SenatorMenendezNJ | senatormenendez | 433044338 |
M001111 | Patty Murray M001111 | PattyMurray | UCb8jq3TvQ3AzKsexhWfFLoA | 293131808 | SenatorPattyMurray | senpattymurray | 426137845 | |
L000577 | Mike Lee L000577 | SenMikeLee | senatormikelee | UCplVxs_j_sLAt0fkplXcl4A | 88784440 | senatormikelee | senmikelee | 391361701 |
C001087 | Eric Crawford C001087 | RepRickCrawford | RepRickCrawford | UCLKAkVl4BHRK73lmDiIgPYg | 233693291 | RepRickCrawford | reprickcrawford | 389864684 |
D000615 | Jeff Duncan D000615 | RepJeffDuncan | RepJeffDuncan | UC1tuXL6ymImdpKYGEAH83QA | 240393970 | congjeffduncan | repjeffduncan | 382897929 |
C001091 | Joaquin Castro C001091 | JoaquinCastrotx | 326420614138023 | UCsRxWnFdRiV2od1O5v5nEeQ | 231510077 | JoaquinCastroTX | joaquincastrotx | 378492005 |
D000618 | Steve Daines D000618 | SteveDaines | SteveDainesMT | UC-ny-W5mEUGytiyMdXbQ20Q | 11651202 | SteveDainesMT | stevedaines | 371125857 |
P000449 | Robert Portman P000449 | SenRobPortman | senrobportman | UCwunkd8Zs-yAWKQwnwBp7ew | 18915145 | SenRobPortman | senrobportman | 370356159 |
W000437 | Roger Wicker W000437 | SenatorWicker | SenatorWicker | UCIlKHiTjSkcQP_knBcXHWSg | 264219447 | SenatorWicker | senatorwicker | 367948073 |
J000295 | David Joyce J000295 | RepDaveJoyce | RepDaveJoyce | UCTu9xz2VYk-jtQv0TVsLyYA | 976969338 | repdavejoyce | repdavejoyce | 360743678 |
M001156 | Patrick McHenry M001156 | PatrickMcHenry | CongressmanMcHenry | UCY3PTRhkSH-eoltxPVZKD-w | 27676828 | CongressmanMcHenry | reppatrickmchenry | 353406473 |
T000193 | Bennie Thompson T000193 | BennieGThompson | CongressmanBennieGThompson | UCzt2pBxh0dI24kYrWretXRw | 82453460 | RepBennieThompson | benniegthompson | 347410575 |
B001260 | Vern Buchanan B001260 | VernBuchanan | CongressmanBuchanan | UCY4DEy41NxOTdcF8_XAVZvw | 20467163 | vernbuchanan | repvern | 344865327 |
S001193 | Eric Swalwell S001193 | RepSwalwell | CongressmanEricSwalwell | UCKvwsFNGD4sDkE_9g-2ft0w | 942156122 | ericswalwell | repswalwell | 338799200 |
B000755 | Kevin Brady B000755 | RepKevinBrady | kevinbrady | UC6Ng0uMQEBVgXO_HF0NbfXA | 19926675 | KBrady8 | repkevinbrady | 337613850 |
C000880 | Michael Crapo C000880 | MikeCrapo | mikecrapo | UCMHzKHg1BE7dEcFjnayw1lA | 600463589 | senatorcrapo | mikecrapo | 329357214 |
D000600 | Mario Diaz-Balart D000600 | MarioDB | mdiazbalart | UCpEEd0Plxx5D78pI4a4mFTQ | 37094727 | MarioDiazBalart | repmariodb | 316477657 |
W000815 | Brad Wenstrup W000815 | RepBradWenstrup | RepBradWenstrup | UCaK7SeUvmHdHTMtF3HXb-jA | 518644221 | repbradwenstrup | repbradwenstrup | 305496379 |
H001042 | Mazie Hirono H001042 | MazieHirono | senatorhirono | UCcoKhxad156flzPYJ8JMFOA | 92186819 | CongresswomanHirono | maziehirono | 304094084 |
M000934 | Jerry Moran M000934 | JerryMoran | jerrymoran | UC1oRxeUPam6-53wPBZ3N02A | 18632666 | senatorjerrymoran | senjerrymoran | 298271065 |
H001046 | Martin Heinrich H001046 | MartinHeinrich | MartinHeinrich | UCBxh8IK5sMxY0Ln_0G2NYcg | 1099199839 | SenMartinHeinrich | senatormartinheinrich | 285288987 |
V000128 | Chris Van Hollen V000128 | ChrisVanHollen | chrisvanhollen | UCkpfJWu1N9Okd6PE_NidtBQ | 18137749 | RepChrisVanHollen | chrisvanhollen | 268595235 |
D000616 | Scott DesJarlais D000616 | DesJarlaisTN04 | ScottDesJarlaisTN04 | UCvjuSLoi3hS0ECQvJLhwOkA | 235312723 | ScottDesJarlaisTN04 | desjarlaistn04 | 260930821 |
R000575 | Mike Rogers R000575 | RepMikeRogersAL | CongressmanMikeDRogers | UCH-WUWuY0_dlKwJDSqKTJsg | 33977070 | MikeRogersAL03 | repmikerogersal | 259435765 |
S001183 | David Schweikert S001183 | RepDavid | repdavidschweikert | UCVvuNVzkOUp7p_Pzkc6Zuvw | 229197216 | RepDavidSchweikert | repdavid | 181147397 |
H000874 | Steny Hoyer H000874 | LeaderHoyer | WhipHoyer | UCvxgqX65cdhHNjJn64cgY9g | 22012091 | LeaderHoyer | repstenyhoyer | 51616645 |
L000566 | Robert Latta L000566 | BobLatta | boblatta | UCVSBVHoWu-eWnBBQaMKZ_sQ | 15394954 | CongressmanBobLatta | boblatta | 26367713 |
C001088 | Christopher Coons C001088 | ChrisCoons | senatorchriscoons | UC2lOVbsddn1HIkcDnmCw6tA | 15324851 | senatorchriscoons | senatorchriscoons | 25194715 |
B000575 | Roy Blunt B000575 | RoyBlunt | SenatorBlunt | UCFeLRzjhThTmaWzuh5qjpGA | 21269970 | SenatorBlunt | royblunt | 21185436 |
W000779 | Ron Wyden W000779 | RonWyden | UCsd3UEaoLoqX60P88BdpGGw | 250188760 | senronwyden | ronwyden | 9443881 | |
R000600 | Aumua Amata Radewagen R000600 | RepAmata | aumuaamata | UCGdrLQbt1PYDTPsampx4t1A | 3026622545 | |||
Y000064 | Todd Young Y000064 | SenToddYoung | SenatorToddYoung | UCuknj4PGn91gHDNAfboZEgQ | 234128524 | RepToddYoung | sentoddyoung | |
T000476 | Thom Tillis T000476 | SenThomTillis | SenatorThomTillis | UCUD9VGV4SSGWjGdbn37Ea2w | 2964174789 | senthomtillis | ||
Y000062 | John Yarmuth Y000062 | RepJohnYarmuth | 214258646163 | UCy5KW4yrEfEiyZRX45Eoxkg | 384913290 | RepJohnYarmuth | ||
W000809 | Steve Womack W000809 | Rep_SteveWomack | RepSteveWomack | UCXJbUDLYX-wGIhRuN66hqZw | 234469322 | CongressmanWomack | ||
W000808 | Frederica Wilson W000808 | RepWilson | RepWilson | UCP5QBhng_lHv-vJgE_h7lpA | 234014087 | repfredericawilson | repwilson | |
W000806 | Daniel Webster W000806 | RepWebster | RepWebster | UCCoX4VdU7U11eGEA0lbRtLw | 281540744 | repdanwebster | ||
W000804 | Robert Wittman W000804 | RobWittman | RepRobWittman | UCIqIb-OaTbkIdU426eYIdPg | 15356407 | RobWittman | reprobwittman | |
W000802 | Sheldon Whitehouse W000802 | SenWhitehouse | SenatorWhitehouse | UCnG0N70SNBkNqvIMLodPTIA | 242555999 | SenatorWhitehouse | SenWhitehouse | |
W000798 | Tim Walberg W000798 | RepWalberg | RepWalberg | UChpf3_3Wn8f3qSJbsYXrhvg | 237862972 | RepWalberg | repwalberg | |
W000797 | Debbie Wasserman Schultz W000797 | RepDWStweets | RepDWS | UCfHQiJVvMlYbVAxrMSLdO4w | 1140648348 | RepWassermanSchultz | RepDWSTweets | |
W000187 | Maxine Waters W000187 | RepMaxineWaters | MaxineWaters | UCOQ2js1VYFlo74n7Ns8WsLQ | 36686040 | MaxineWaters | repmaxinewaters | |
V000081 | Nydia Velázquez V000081 | NydiaVelazquez | 8037068318 | UCqMKPkKeeHFOOiZ9vxhXGVg | 164369297 | nydiavelazquez | ||
U000031 | Fred Upton U000031 | RepFredUpton | RepFredUpton | UCsN16IzEo4ViZNEMgeCrQ7w | 124224165 | RepFredUpton | RepFredUpton | |
T000469 | Paul Tonko T000469 | RepPaulTonko | reppaultonko | UC3P2SGFmmuCYRsjeso0hOQQ | 84119348 | reppaultonko | reppaultonko | |
T000467 | Glenn Thompson T000467 | CongressmanGT | CongressmanGT | UCNWX7lbWWvnNdzVMFI9DRiQ | 18967498 | CongressmanGT | congressman_gt | |
T000464 | Jon Tester T000464 | SenatorTester | senatortester | UCgXAF-CON1coZFMxQkfj0fg | 515822213 | senatorjontester | ||
T000463 | Michael Turner T000463 | RepMikeTurner | RepMikeTurner | UC-6Ss-aZ3OPisf9GdVGtN8g | 51228911 | CongressmanTurner | repmiketurner | |
T000461 | Patrick Toomey T000461 | SenToomey | senatortoomey | UCDUM4FFU1p-_YuHqmBglyXw | 221162525 | sentoomey | ||
T000460 | Mike Thompson T000460 | RepThompson | RepMikeThompson | UC6pGbtqHZYZmScFGSz5bbdg | 303861808 | CongressmanMThompson | ||
T000250 | John Thune T000250 | SenJohnThune | UCRu6lpRfxhkDGUrKDgQNZYQ | 296361085 | johnthune | senjohnthune | ||
S001189 | Austin Scott S001189 | AustinScottGA08 | RepAustinScott | UC5M7eKHKQStktMyjieiHYZQ | 234797704 | RepAustinScott | ||
S001185 | Terri Sewell S001185 | RepTerriSewell | RepSewell | UCHkEHtfrfUWOFtbUFQTQH7Q | 381152398 | RepSewell | ||
S001184 | Tim Scott S001184 | SenatorTimScott | SenatorTimScott | UCSfAsbG80CNInSKrtpKoL-w | 217543151 | SenatorTimScott | SenatorTimScott | |
S001181 | Jeanne Shaheen S001181 | SenatorShaheen | SenatorShaheen | UCjLZAZMbDrybHyttdEC9LFA | 109287731 | senatorshaheen | senatorshaheen | |
S001180 | Kurt Schrader S001180 | RepSchrader | repschrader | UCrWRXVaGJtcImc_kknuDsAw | 20545793 | repkurtschrader | ||
S001177 | Gregorio Sablan S001177 | Kilili_Sablan | 153423912663 | UC-fbzxBSiC98eAE2goaANVQ | 926446070812602371 | CongressmanSablan | kilili_sablan | |
S001175 | Jackie Speier S001175 | RepSpeier | JackieSpeier | UCevmyTb0HSO8irVaR2gYyoA | 24913074 | jackiespeierca12 | jackiespeier | |
S001172 | Adrian Smith S001172 | RepAdrianSmith | UCIgn2z-hwxx_aeggnyhv54Q | 296245061 | RepAdrianSmith | RepAdrianSmith | ||
S001165 | Albio Sires S001165 | RepSires | 81058818750 | UCfdEcWPNGoIxpYoTANF4PBA | 18696134 | RepSiresNJ13 | ||
S001157 | David Scott S001157 | RepDavidScott | 113303673339 | UCgf28zRkLSqAUiPuJhGdF0w | 168673083 | RepDavidScott | RepDavidScott | |
S001156 | Linda Sánchez S001156 | RepLindaSanchez | CongresswomanLindaSanchez | UCu1K6uHxjMgj2mvzM7O9-ow | 312134473 | LindaTSanchez | ||
S001150 | Adam Schiff S001150 | RepAdamSchiff | RepAdamSchiff | UCadiUi-KZoFk1K5ZDsluLcA | 29501253 | adamschiff | RepAdamSchiff | |
S001148 | Michael Simpson S001148 | CongMikeSimpson | 96007744606 | UCNXe0rJJeULTAP_7oyQNw8g | 76132891 | CongMikeSimpson | ||
S001145 | Janice Schakowsky S001145 | JanSchakowsky | janschakowsky | UCuCHHPSENUEaaeH8n_CYDXQ | 24195214 | repschakowsky | ||
S001217 | Rick Scott S001217 | SenRickScott | RickScottSenOffice | UC-Y9pFmW4PYGZHkC8lcqSkQ | 131546062 | |||
S000770 | Debbie Stabenow S000770 | SenStabenow | SenatorStabenow | UCFoDKCvxSwCUfDv-4Eg4K5A | 76456274 | senatorstabenow | ||
S000510 | Adam Smith S000510 | RepAdamSmith | RepAdamSmith | UCcrHso483LOfC6WwDnzAh-g | 58928690 | CongressmanAdamSmith |
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 );