social_media
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
528 rows sorted by facebook
This data as json, copyable, CSV (advanced)
id | legislator_id | facebook ▼ | youtube_id | twitter_id | youtube | instagram_id | ||
---|---|---|---|---|---|---|---|---|
H001085 | Chrissy Houlahan H001085 | RepHoulahan | 1052896620797460481 | |||||
H001086 | Diana Harshbarger H001086 | RepHarshbarger | 1345787285179162624 | |||||
H001089 | Joshua Hawley H001089 | SenHawleyPress | 1080960924687704064 | |||||
H001090 | Josh Harder H001090 | RepJoshHarder | 1080851152151953410 | |||||
H001091 | Ashley Hinson H001091 | RepAshleyHinson | 1340783304304410625 | |||||
I000056 | Darrell Issa I000056 | repdarrellissa | 63650107 | |||||
J000020 | Chris Jacobs J000020 | RepJacobs | 1276232539510919168 | |||||
J000301 | Dusty Johnson J000301 | RepDustyJohnson | 1074782372594413569 | |||||
J000302 | John Joyce J000302 | RepJohnJoyce | 1082311988926124036 | |||||
J000304 | Ronny Jackson J000304 | RepRonnyJackson | 1341903465610686464 | |||||
J000305 | Sara Jacobs J000305 | RepSaraJacobs | 1345103905869455361 | |||||
J000306 | Mondaire Jones J000306 | RepMondaire | 1345883634046279681 | |||||
K000367 | Amy Klobuchar K000367 | SenAmyKlobuchar | UCvdeJsDsV51tFb_hVqvtYGA | 22044727 | senatorklobuchar | |||
K000368 | Ann Kirkpatrick K000368 | RepKirkpatrick | 1081240074946252801 | |||||
K000394 | Andy Kim K000394 | RepAndyKimNJ | 1078771848882593793 | |||||
K000396 | Kaialiʻi Kahele K000396 | RepKahele | 1351966874377056257 | |||||
K000397 | Young Kim K000397 | RepYoungKim | 1344677401465397249 | |||||
L000266 | Jacob LaTurner L000266 | RepLaTurner | 1345850704800468993 | |||||
L000273 | Teresa Leger Fernandez L000273 | RepTeresaLF | 1345147845926670337 | |||||
L000570 | Ben Luján L000570 | SenatorLujan | 19318314 | |||||
L000571 | Cynthia Lummis L000571 | SenLummis | 22831059 | |||||
L000590 | Susie Lee L000590 | RepSusieLee | 1079061579973439488 | |||||
L000591 | Elaine Luria L000591 | RepElaineLuria | 1080292515939565568 | |||||
L000592 | Andy Levin L000592 | RepAndyLevin | 1080277407867772930 | |||||
L000593 | Mike Levin L000593 | RepMikeLevin | 1072134139560620033 | |||||
L000595 | Julia Letlow L000595 | RepJuliaLetlow | 1382395679700439041 | |||||
M000194 | Nancy Mace M000194 | RepNancyMace | 1343597700542038017 | |||||
M000317 | Nicole Malliotakis M000317 | RepMalliotakis | 1344750588026900481 | |||||
M000871 | Tracey Mann M000871 | RepMann | 1345825008887721986 | |||||
M001111 | Patty Murray M001111 | PattyMurray | UCb8jq3TvQ3AzKsexhWfFLoA | 293131808 | SenatorPattyMurray | senpattymurray | 426137845 | |
M001135 | Kathy Manning M001135 | RepKManning | 1337115670161608712 | |||||
M001136 | Lisa McClain M001136 | RepLisaMcClain | 1344032292432437248 | |||||
M001186 | Peter Meijer M001186 | RepMeijer | 1334164871420796928 | |||||
M001198 | Roger Marshall M001198 | SenatorMarshall | 1336344005588738052 | |||||
M001203 | Tom Malinowski M001203 | RepMalinowski | 1080898026418384897 | |||||
M001204 | Daniel Meuser M001204 | RepMeuser | 1080574793630527505 | |||||
M001205 | Carol Miller M001205 | RepCarolMiller | 1081318716573470720 | |||||
M001206 | Joseph Morelle M001206 | RepJoeMorelle | 1064595993222615040 | |||||
M001208 | Lucy McBath M001208 | RepLucyMcBath | 1082380458976051202 | |||||
M001211 | Mary Miller M001211 | RepMaryMiller | 1343656635907125250 | |||||
M001212 | Barry Moore M001212 | RepBarryMoore | 1339006078688825344 | |||||
M001213 | Blake Moore M001213 | RepBlakeMoore | 1337452596093587462 | |||||
M001214 | Frank Mrvan M001214 | RepMrvan | 1346205046036377601 | |||||
M001215 | Mariannette Miller-Meeks M001215 | RepMMM | 1345807954604412929 | |||||
N000026 | Troy Nehls N000026 | RepTroyNehls | 1347318288850825217 | |||||
N000191 | Joe Neguse N000191 | RepJoeNeguse | 1078749802765139968 | |||||
N000192 | Marie Newman N000192 | RepMarieNewman | 1343578440977494018 | |||||
O000019 | Jay Obernolte O000019 | JayObernolte | 272482466 | |||||
O000086 | Clarence Owens O000086 | RepBurgessOwens | 1344481217685692416 | |||||
O000172 | Alexandria Ocasio-Cortez O000172 | RepAOC | 1079104563280527364 | |||||
O000173 | Ilhan Omar O000173 | Ilhan | 1082334352711790593 | |||||
O000174 | Jon Ossoff O000174 | SenOssoff | 1356714265894408196 | |||||
P000048 | August Pfluger P000048 | RepPfluger | 1341120751399809026 | |||||
P000145 | Alejandro Padilla P000145 | SenAlexPadilla | 1351236267707654145 | |||||
P000614 | Chris Pappas P000614 | RepChrisPappas | 1067748650485497862 | |||||
P000615 | Greg Pence P000615 | RepGregPence | 1082369392229400576 | |||||
P000616 | Dean Phillips P000616 | RepDeanPhillips | 1061310112013434882 | |||||
P000617 | Ayanna Pressley P000617 | RepPressley | 1080584229510172678 | |||||
P000618 | Katie Porter P000618 | RepKatiePorter | 1081222837459996672 | |||||
R000103 | Matthew Rosendale R000103 | RepRosendale | 1344751420139040783 | |||||
R000305 | Deborah Ross R000305 | RepDeborahRoss | 1348683154815655940 | |||||
R000610 | Guy Reschenthaler R000610 | GReschenthaler | 4205133682 | |||||
R000612 | John Rose R000612 | RepJohnRose | 1081312310059253763 | |||||
R000614 | Chip Roy R000614 | RepChipRoy | 1082790600292925440 | |||||
R000615 | Mitt Romney R000615 | SenatorRomney | 1078693601356509184 | |||||
S000168 | Maria Salazar S000168 | RepMariaSalazar | 1325928411689349120 | |||||
S000250 | Pete Sessions S000250 | PeteSessions | 24735461 | |||||
S000929 | Victoria Spartz S000929 | RepSpartz | 1344845201479663621 | |||||
S001135 | Michelle Steel S001135 | RepSteel | 1343740146630451200 | |||||
S001159 | Marilyn Strickland S001159 | RepStricklandWA | 1343646545955213312 | |||||
S001172 | Adrian Smith S001172 | RepAdrianSmith | UCIgn2z-hwxx_aeggnyhv54Q | 296245061 | RepAdrianSmith | RepAdrianSmith | ||
S001205 | Mary Scanlon S001205 | RepMGS | 1067541214671577093 | |||||
S001207 | Mikie Sherrill S001207 | RepSherrill | 1080569698536878081 | |||||
S001208 | Elissa Slotkin S001208 | RepSlotkin | 1078401427347857408 | |||||
S001209 | Abigail Spanberger S001209 | RepSpanberger | 1078771401497161728 | |||||
S001211 | Greg Stanton S001211 | RepGregStanton | 1080885078425784320 | |||||
S001212 | Pete Stauber S001212 | RepPeteStauber | 1075830599007510535 | |||||
S001213 | Bryan Steil S001213 | RepBryanSteil | 1075205691621720064 | |||||
S001214 | W. Steube S001214 | RepGregSteube | 1083125649609506816 | |||||
S001215 | Haley Stevens S001215 | RepHaleyStevens | 1076161611033968640 | |||||
S001216 | Kim Schrier S001216 | RepKimSchrier | 1080462532815532032 | |||||
S001218 | Melanie Stansbury S001218 | Rep_Stansbury | 1404519992582942724 | |||||
T000165 | Thomas Tiffany T000165 | RepTiffany | 1267841066335682562 | |||||
T000250 | John Thune T000250 | SenJohnThune | UCRu6lpRfxhkDGUrKDgQNZYQ | 296361085 | johnthune | senjohnthune | ||
T000278 | Tommy Tuberville T000278 | SenTuberville | 1345739193721487362 | |||||
T000478 | Claudia Tenney T000478 | RepTenney | 797201048490430465 | |||||
T000479 | Van Taylor T000479 | RepVanTaylor | 1075040139351597056 | |||||
T000480 | William Timmons T000480 | RepTimmons | 1079770852302958592 | |||||
T000481 | Rashida Tlaib T000481 | RepRashida | 1079769536730140672 | |||||
T000482 | Lori Trahan T000482 | RepLoriTrahan | 1079802482640019456 | |||||
T000483 | David Trone T000483 | RepDavidTrone | 1080573351914061825 | |||||
T000486 | Ritchie Torres T000486 | RepRitchie | 1276403757224546304 | |||||
U000040 | Lauren Underwood U000040 | RepUnderwood | 1080539438508400642 | |||||
V000129 | David Valadao V000129 | RepDavidValadao | 1128514404 | |||||
V000133 | Jefferson Van Drew V000133 | Congressman_JVD | 1468677099594698757 | |||||
V000134 | Beth Van Duyne V000134 | RepBethVanDuyne | 1339633259349745670 | |||||
W000779 | Ron Wyden W000779 | RonWyden | UCsd3UEaoLoqX60P88BdpGGw | 250188760 | senronwyden | ronwyden | 9443881 | |
W000788 | Nikema Williams W000788 | RepNikema | 1345461797361504259 | |||||
W000790 | Raphael Warnock W000790 | SenatorWarnock | 1352287997853622273 | |||||
W000823 | Michael Waltz W000823 | RepWaltzPress | 1082416697380913152 |
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 );