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 | ||
---|---|---|---|---|---|---|---|---|
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 | ||
W000817 | Elizabeth Warren W000817 | SenWarren | senatorelizabethwarren | UCTH9zV8Imw09J5bOoTR18_A | 970207298 | senelizabethwarren | senwarren | |
Y000064 | Todd Young Y000064 | SenToddYoung | SenatorToddYoung | UCuknj4PGn91gHDNAfboZEgQ | 234128524 | RepToddYoung | sentoddyoung | |
T000476 | Thom Tillis T000476 | SenThomTillis | SenatorThomTillis | UCUD9VGV4SSGWjGdbn37Ea2w | 2964174789 | senthomtillis | ||
C001035 | Susan Collins C001035 | SenatorCollins | susancollins | UC6GYaBx5kT2r4PN8KENxC-w | 19726613 | SenatorSusanCollins | sensusancollins | |
J000293 | Ron Johnson J000293 | SenRonJohnson | senronjohnson | UCG9XyTVtOAs7VX_q_QVHoaw | 233737858 | SenatorRonJohnson | senronjohnson | |
P000449 | Robert Portman P000449 | SenRobPortman | senrobportman | UCwunkd8Zs-yAWKQwnwBp7ew | 18915145 | SenRobPortman | senrobportman | 370356159 |
M001111 | Patty Murray M001111 | PattyMurray | UCb8jq3TvQ3AzKsexhWfFLoA | 293131808 | SenatorPattyMurray | senpattymurray | 426137845 | |
L000577 | Mike Lee L000577 | SenMikeLee | senatormikelee | UCplVxs_j_sLAt0fkplXcl4A | 88784440 | senatormikelee | senmikelee | 391361701 |
M001153 | Lisa Murkowski M001153 | LisaMurkowski | SenLisaMurkowski | UCaigku16AErqvD0wRuwGb9A | 18061669 | senatormurkowski | senlisamurkowski | |
E000295 | Joni Ernst E000295 | SenJoniErnst | senjoniernst | UCLwrmtF_84FIcK3TyMs4MIw | 2856787757 | senjoniernst | 1582702853 | |
T000250 | John Thune T000250 | SenJohnThune | UCRu6lpRfxhkDGUrKDgQNZYQ | 296361085 | johnthune | senjohnthune | ||
H001061 | John Hoeven H001061 | SenJohnHoeven | SenatorJohnHoeven | UC1kQIC2Q_Fq9_NRqdb6eHiw | 382791093 | senatorjohnhoevennd | senjohnhoeven | 1237544252 |
M000934 | Jerry Moran M000934 | JerryMoran | jerrymoran | UC1oRxeUPam6-53wPBZ3N02A | 18632666 | senatorjerrymoran | senjerrymoran | 298271065 |
M001176 | Jeff Merkley M001176 | SenJeffMerkley | jeffmerkley | UCRoXttCJhMnLVCxCaa6VnNQ | 29201047 | SenatorJeffMerkley | senjeffmerkley | 501463589 |
P000595 | Gary Peters P000595 | SenGaryPeters | SenGaryPeters | UC7LYNbnKSK2VZqQ98YROWHQ | 236511574 | RepGaryPeters | sengarypeters | 1640246681 |
H001079 | Cindy Hyde-Smith H001079 | SenHydeSmith | UCJHxkJhGST0NTlkzJHWV03Q | 983348251972816896 | sencindyhydesmith | |||
C001047 | Shelley Capito C001047 | SenCapito | senshelley | UCbiXdR4XQ3vD9Xp5lfR9QXw | 193794406 | sencapito | 1640447624 | |
C001070 | Robert Casey C001070 | SenBobCasey | SenatorBobCasey | UCtVssXhx-KuZa-hSvnsnJ0A | 171598736 | SenatorBobCasey | senbobcasey | |
W000437 | Roger Wicker W000437 | SenatorWicker | SenatorWicker | UCIlKHiTjSkcQP_knBcXHWSg | 264219447 | SenatorWicker | senatorwicker | 367948073 |
W000805 | Mark Warner W000805 | MarkWarner | MarkRWarner | UCwyivNlEGf4sGd1oDLfY5jw | 7429102 | SenatorMarkWarner | senatorwarner | 515327940 |
S001181 | Jeanne Shaheen S001181 | SenatorShaheen | SenatorShaheen | UCjLZAZMbDrybHyttdEC9LFA | 109287731 | senatorshaheen | senatorshaheen | |
S001197 | Benjamin Sasse S001197 | SenSasse | SenatorSasse | UCYaNGwcM2Dl5yDcDqS6xV2g | 2962923040 | senatorsasse | 1636974433 | |
P000603 | Rand Paul P000603 | SenRandPaul | SenatorRandPaul | UCeM9I-20oWUs8daIIpsNHoQ | 1298624375692894210 | SenatorRandPaul | senatorrandpaul | 541357095 |
M000639 | Robert Menendez M000639 | SenatorMenendez | senatormenendez | UC0PV0K9Z5a9p3D5917KF5fw | 18695134 | SenatorMenendezNJ | senatormenendez | 433044338 |
H001046 | Martin Heinrich H001046 | MartinHeinrich | MartinHeinrich | UCBxh8IK5sMxY0Ln_0G2NYcg | 1099199839 | SenMartinHeinrich | senatormartinheinrich | 285288987 |
L000174 | Patrick Leahy L000174 | SenatorLeahy | SenatorPatrickLeahy | UC46QHVobf7FO-tWehsRoDog | 242836537 | SenatorPatrickLeahy | senatorleahy | |
L000575 | James Lankford L000575 | SenatorLankford | SenatorLankford | UCz8T6sK5fEycyWmVz6Vpe5Q | 225921757 | SenatorLankford | senatorlankford | 1552251018 |
F000463 | Deb Fischer F000463 | SenatorFischer | senatordebfischer | UCrbEfZaG_WhB0PBHI1hefPQ | 1071402577 | senatordebfischer | senatorfischer | |
G000386 | Charles Grassley G000386 | ChuckGrassley | grassley | UCiCPRkcLMInpDeOqGkMTt4w | 10615232 | senchuckgrassley | senatorchuckgrassley | |
C001088 | Christopher Coons C001088 | ChrisCoons | senatorchriscoons | UC2lOVbsddn1HIkcDnmCw6tA | 15324851 | senatorchriscoons | senatorchriscoons | 25194715 |
C000141 | Benjamin Cardin C000141 | SenatorCardin | senatorbencardin | UCiQaJnMzlfzzG3VESgyZChA | 109071031 | senatorcardin | senatorcardin | |
B001135 | Richard Burr B001135 | SenatorBurr | SenatorRichardBurr | UCOLLZpp-1womBSFDV2uLfag | 21157904 | SenatorRichardBurr | senatorburr | |
B001230 | Tammy Baldwin B001230 | SenatorBaldwin | senatortammybaldwin | UC_XjYCRbbI2_TDDjJidwk0Q | 1074518754 | witammybaldwin | senatorbaldwin | |
S001198 | Dan Sullivan S001198 | SenDanSullivan | SenDanSullivan | UC7tXCm8gKlAhTFo2kuf5ylw | 2891210047 | sen_dansullivan | 1660873387 | |
B000575 | Roy Blunt B000575 | RoyBlunt | SenatorBlunt | UCFeLRzjhThTmaWzuh5qjpGA | 21269970 | SenatorBlunt | royblunt | 21185436 |
W000779 | Ron Wyden W000779 | RonWyden | UCsd3UEaoLoqX60P88BdpGGw | 250188760 | senronwyden | ronwyden | 9443881 | |
C001067 | Yvette Clarke C001067 | RepYvetteClarke | repyvettedclarke | UC8SuQiuL2P9fUHAxuRoTdUQ | 240812994 | repyvetteclarke | repyvettedclarke | |
W000808 | Frederica Wilson W000808 | RepWilson | RepWilson | UCP5QBhng_lHv-vJgE_h7lpA | 234014087 | repfredericawilson | repwilson | |
W000798 | Tim Walberg W000798 | RepWalberg | RepWalberg | UChpf3_3Wn8f3qSJbsYXrhvg | 237862972 | RepWalberg | repwalberg | |
F000450 | Virginia Foxx F000450 | VirginiaFoxx | RepVirginiaFoxx | UCggineJcxJn80TRXxdQbx6w | 16256269 | repvirginiafoxx | repvirginiafoxx | |
G000581 | Vicente Gonzalez G000581 | RepGonzalez | USCongressmanVicenteGonzalez | UC5H6oYLKQ_xIXO5CG7fh4hw | 818536152588238849 | repvicentegonzaleztx | ||
B001260 | Vern Buchanan B001260 | VernBuchanan | CongressmanBuchanan | UCY4DEy41NxOTdcF8_XAVZvw | 20467163 | vernbuchanan | repvern | 344865327 |
V000131 | Marc Veasey V000131 | RepVeasey | CongressmanMarcVeasey | UC2CRp1KF5uljZyhDRPR-72Q | 1074129612 | marcveasey | repveasey | 676925345 |
D000627 | Val Demings D000627 | RepValDemings | RepresentativeValDemings | UCkcshqwFNJG6XeduOforhig | 798973032362606600 | repvaldemings | ||
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 | |
S001193 | Eric Swalwell S001193 | RepSwalwell | CongressmanEricSwalwell | UCKvwsFNGD4sDkE_9g-2ft0w | 942156122 | ericswalwell | repswalwell | 338799200 |
C000266 | Steve Chabot C000266 | RepSteveChabot | RepSteveChabot | UCJpzm2DZDE1B6ruQLQc7q4g | 237750442 | congressmanchabot | repstevechabot | 481906395 |
L000562 | Stephen Lynch L000562 | RepStephenLynch | repstephenlynch | UCxL4zG0YWqC5XTO4af_FOgw | 310310133 | RepLynch | repstephenlynch | |
H000874 | Steny Hoyer H000874 | LeaderHoyer | WhipHoyer | UCvxgqX65cdhHNjJn64cgY9g | 22012091 | LeaderHoyer | repstenyhoyer | 51616645 |
S001191 | Kyrsten Sinema S001191 | SenatorSinema | CongresswomanSinema | UC4NzhW7D4lQdukSGWmFnK9w | 1080844782 | repsinema | repsinema | |
M001185 | Sean Maloney M001185 | RepSeanMaloney | RepSeanMaloney | UCNiVzzf4Vz-vCMPBcnjGuXQ | 1072467470 | repseanpatrickmaloney | ||
P000608 | Scott Peters P000608 | RepScottPeters | RepScottPeters | UCQK77QJxW7Xr-S3zqeMd-0g | 1135486501 | repscottpeters | ||
P000605 | Scott Perry P000605 | RepScottPerry | repscottperry | UCzgrU5PT_HHRgf5hXPen4dQ | 18773159 | RepScottPerry | repscottperry | 519463466 |
S001190 | Bradley Schneider S001190 | RepSchneider | CongressmanBradSchneider | 1071840474 | RepBradSchneider | repschneider | ||
G000546 | Sam Graves G000546 | RepSamGraves | 118514606128 | UCdg2ybvoHsSW6t7iJnKHlNg | 29766367 | repsamgraves | ||
G000574 | Ruben Gallego G000574 | RepRubenGallego | RepRubenGallego | 2966570782 | reprubengallego | |||
K000389 | Ro Khanna K000389 | RepRoKhanna | RepRoKhanna | UCr4KOYv1o1oEQhy1jhhm3pQ | 816298918468259841 | reprokhanna | ||
D000619 | Rodney Davis D000619 | RodneyDavis | RepRodneyDavis | UCiGPTfpwRxqQp0Bam5S8zwA | 993153006 | RepRodneyDavis | reprodneydavis | |
W000804 | Robert Wittman W000804 | RobWittman | RepRobWittman | UCIqIb-OaTbkIdU426eYIdPg | 15356407 | RobWittman | reprobwittman | |
K000385 | Robin Kelly K000385 | RepRobinKelly | reprobinkelly | UCLhcNPX2nNQLNzwKW0nEykg | 1339931490 | reprobinkelly | ||
L000560 | Rick Larsen L000560 | RepRickLarsen | RepRickLarsen | UCMv7LsJtiyO4AJcbRux5CxQ | 404132211 | congressmanlarsen | repricklarsen | |
C001087 | Eric Crawford C001087 | RepRickCrawford | RepRickCrawford | UCLKAkVl4BHRK73lmDiIgPYg | 233693291 | RepRickCrawford | reprickcrawford | 389864684 |
R000606 | Jamie Raskin R000606 | RepRaskin | repraskin | UChxDE6vho5BfBTOqiBsDmKg | 806906355214852096 | repraskin | ||
W000800 | Peter Welch W000800 | PeterWelch | PeterWelch | UC0YfApJx6qNaAQ-ir93U8xA | 1410590874 | reppeterwelch | reppeterwelch | 1559860900 |
T000469 | Paul Tonko T000469 | RepPaulTonko | reppaultonko | UC3P2SGFmmuCYRsjeso0hOQQ | 84119348 | reppaultonko | reppaultonko | |
M001156 | Patrick McHenry M001156 | PatrickMcHenry | CongressmanMcHenry | UCY3PTRhkSH-eoltxPVZKD-w | 27676828 | CongressmanMcHenry | reppatrickmchenry | 353406473 |
O000171 | Tom O’Halleran O000171 | RepOHalleran | repohalleran | 808416682972770304 | repohalleran | |||
T000474 | Norma Torres T000474 | NormaJTorres | RepNormaTorres | UCvWY4qKP6--o3pIJY7hhKDg | 236279233 | repnormatorres | ||
M001196 | Seth Moulton M001196 | RepMoulton | CongressmanSethMoulton | UC5w5qn7nj5Ljy69LTV7a_fQ | 3091316093 | repmoulton | ||
T000463 | Michael Turner T000463 | RepMikeTurner | RepMikeTurner | UC-6Ss-aZ3OPisf9GdVGtN8g | 51228911 | CongressmanTurner | repmiketurner | |
R000575 | Mike Rogers R000575 | RepMikeRogersAL | CongressmanMikeDRogers | UCH-WUWuY0_dlKwJDSqKTJsg | 33977070 | MikeRogersAL03 | repmikerogersal | 259435765 |
Q000023 | Mike Quigley Q000023 | RepMikeQuigley | repmikequigley | UCDP13XegdoZ4bxYHxM34yAA | 56864092 | RepMikeQuigley | repmikequigley | 1403659583 |
B001248 | Michael Burgess B001248 | MichaelCBurgess | michaelcburgess | UCvvO8lo-Nkc31cEEElqQvQw | 15751083 | michaelcburgessmd | repmichaelburgess | |
M000312 | James McGovern M000312 | RepMcGovern | RepJimMcGovern | UCpiUqp2ZF64tXqgR_EQo27g | 242426145 | repjimmcgovern | repmcgovern | |
W000187 | Maxine Waters W000187 | RepMaxineWaters | MaxineWaters | UCOQ2js1VYFlo74n7Ns8WsLQ | 36686040 | MaxineWaters | repmaxinewaters | |
C001090 | Matthew Cartwright C001090 | RepCartwright | CongressmanMattCartwright | UCnAOvexSGLBnYidaFzguhTQ | 776664410 | repmattcartwright | ||
T000472 | Mark Takano T000472 | RepMarkTakano | RepMarkTakano | UCJg4F1irmSFeKoXZBaZbX2w | 1037321378 | RepMarkTakano | repmarktakano | |
P000607 | Mark Pocan P000607 | RepMarkPocan | repmarkpocan | UCz5b47WER_u3dUGV_Zi70dQ | 1206227149 | repmarkpocan | repmarkpocan | 1422301608 |
D000600 | Mario Diaz-Balart D000600 | MarioDB | mdiazbalart | UCpEEd0Plxx5D78pI4a4mFTQ | 37094727 | MarioDiazBalart | repmariodb | 316477657 |
K000009 | Marcy Kaptur K000009 | RepMarcyKaptur | RepresentativeMarcyKaptur | UCIJUNf22o09nO02oQPLKQ6w | 581141508 | USRepMarcyKaptur | repmarcykaptur | |
M000087 | Carolyn Maloney M000087 | RepMaloney | RepCarolynMaloney | 258900199 | carolynbmaloney | repmaloney | ||
C001110 | J. Correa C001110 | RepLouCorrea | RepLouCorrea | UCIKJJp4QJIDjnjodc23qKkw | 815985039485837312 | reploucorrea | ||
F000462 | Lois Frankel F000462 | RepLoisFrankel | RepLoisFrankel | UCEk5viAhxaW_2OK20-yBwzQ | 1077121945 | reploisfrankel | reploisfrankel | |
D000399 | Lloyd Doggett D000399 | RepLloydDoggett | lloyddoggett | UCN-kiLKyHPcfRVZ28sAHS_g | 153944899 | doggett | replloyddoggett | |
C001096 | Kevin Cramer C001096 | SenKevinCramer | CongressmanKevinCramer | UCqUPdO9XaAW-dvwwXKbIVdA | 1048784496 | kevincramer | repkevincramer | |
B000755 | Kevin Brady B000755 | RepKevinBrady | kevinbrady | UC6Ng0uMQEBVgXO_HF0NbfXA | 19926675 | KBrady8 | repkevinbrady | 337613850 |
C000059 | Ken Calvert C000059 | KenCalvert | 70063393423 | UC5MEj7YOX_QdKoqD_HRxP3A | 22545491 | RepKenCalvert | repkencalvert | |
B001297 | Ken Buck B001297 | RepKenBuck | repkenbuck | UCHK7Wcwij7NoxXGTeSHUWzg | 2862577383 | repkenbuck | ||
C001101 | Katherine Clark C001101 | RepKClark | CongresswomanClark | UCgaI52w7QKI8LtkSeCCmSuw | 2293131060 | repkclark | ||
G000377 | Kay Granger G000377 | RepKayGranger | RepKayGranger | UCsRMtemAkyLh78MPES6gMVQ | 161743731 | RepKayGranger | repkaygranger | |
V000130 | Juan Vargas V000130 | RepJuanVargas | RepJuanVargas | UCpMthf8y7bEMJH_td0dznRQ | 1260172386 | RepJuanVargas | repjuanvargas | |
C001114 | John Curtis C001114 | RepJohnCurtis | RepJohnCurtis | UChAQ4MD-HigmGnImSoAKBVA | 931614483050414080 | repjohncurtis | ||
W000795 | Joe Wilson W000795 | RepJoeWilson | JoeWilson | UC3aR1B8m7Z1uycO65yDnpCg | 254082173 | RepJoeWilson | repjoewilson | 519685522 |
C001069 | Joe Courtney C001069 | RepJoeCourtney | joecourtney | UCGVIfe1T2hO1Lx7ap5Wkv1w | 85396297 | repcourtney | repjoecourtney | |
A000375 | Jodey Arrington A000375 | RepArrington | JodeyArrington | 816284664658874368 | repjodeyarrington |
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 );