social_media
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
528 rows sorted by twitter_id descending
This data as json, copyable, CSV (advanced)
id | legislator_id | youtube_id | twitter_id ▲ | youtube | instagram_id | |||
---|---|---|---|---|---|---|---|---|
V000133 | Jefferson Van Drew V000133 | Congressman_JVD | 1468677099594698757 | |||||
C001126 | Mike Carey C001126 | RepMikeCarey | 1457745193197780993 | |||||
B001313 | Shontel Brown B001313 | RepShontelBrown | 1456381091598700556 | |||||
S001218 | Melanie Stansbury S001218 | Rep_Stansbury | 1404519992582942724 | |||||
L000595 | Julia Letlow L000595 | RepJuliaLetlow | 1382395679700439041 | |||||
E000071 | Jake Ellzey E000071 | RepEllzey | 1366523868253458437 | |||||
C001116 | Andrew Clyde C001116 | Rep_Clyde | 1357017361568694274 | |||||
O000174 | Jon Ossoff O000174 | SenOssoff | 1356714265894408196 | |||||
C001125 | Troy Carter C001125 | RepTroyCarter | 1352760304271241218 | |||||
W000790 | Raphael Warnock W000790 | SenatorWarnock | 1352287997853622273 | |||||
K000396 | Kaialiʻi Kahele K000396 | RepKahele | 1351966874377056257 | |||||
P000145 | Alejandro Padilla P000145 | SenAlexPadilla | 1351236267707654145 | |||||
R000305 | Deborah Ross R000305 | RepDeborahRoss | 1348683154815655940 | |||||
N000026 | Troy Nehls N000026 | RepTroyNehls | 1347318288850825217 | |||||
H000601 | Bill Hagerty H000601 | SenatorHagerty | 1346873610875654147 | |||||
M001214 | Frank Mrvan M001214 | RepMrvan | 1346205046036377601 | |||||
J000306 | Mondaire Jones J000306 | RepMondaire | 1345883634046279681 | |||||
L000266 | Jacob LaTurner L000266 | RepLaTurner | 1345850704800468993 | |||||
M000871 | Tracey Mann M000871 | RepMann | 1345825008887721986 | |||||
M001215 | Mariannette Miller-Meeks M001215 | RepMMM | 1345807954604412929 | |||||
B000668 | Cliff Bentz B000668 | RepBentz | 1345788865911656454 | |||||
H001086 | Diana Harshbarger H001086 | RepHarshbarger | 1345787285179162624 | |||||
T000278 | Tommy Tuberville T000278 | SenTuberville | 1345739193721487362 | |||||
G000595 | Robert Good G000595 | RepBobGood | 1345536897838436353 | |||||
W000788 | Nikema Williams W000788 | RepNikema | 1345461797361504259 | |||||
L000273 | Teresa Leger Fernandez L000273 | RepTeresaLF | 1345147845926670337 | |||||
F000446 | Randy Feenstra F000446 | RepFeenstra | 1345135363761852416 | |||||
J000305 | Sara Jacobs J000305 | RepSaraJacobs | 1345103905869455361 | |||||
S000929 | Victoria Spartz S000929 | RepSpartz | 1344845201479663621 | |||||
R000103 | Matthew Rosendale R000103 | RepRosendale | 1344751420139040783 | |||||
M000317 | Nicole Malliotakis M000317 | RepMalliotakis | 1344750588026900481 | |||||
K000397 | Young Kim K000397 | RepYoungKim | 1344677401465397249 | |||||
O000086 | Clarence Owens O000086 | RepBurgessOwens | 1344481217685692416 | |||||
H001084 | Yvette Herrell H001084 | RepHerrell | 1344416719260016641 | |||||
B001223 | Jamaal Bowman B001223 | RepBowman | 1344389506963808264 | |||||
F000470 | Michelle Fischbach F000470 | RepFischbach | 1344375287484723205 | |||||
G000596 | Marjorie Greene G000596 | RepMTG | 1344356576786866176 | |||||
G000597 | Andrew Garbarino G000597 | RepGarbarino | 1344349650447433729 | |||||
C001039 | Katherine Cammack C001039 | RepKatCammack | 1344325638983987201 | |||||
B000740 | Stephanie Bice B000740 | RepBice | 1344260196227555334 | |||||
M001136 | Lisa McClain M001136 | RepLisaMcClain | 1344032292432437248 | |||||
C001104 | Madison Cawthorn C001104 | RepCawthorn | 1344007696555663360 | |||||
D000032 | Byron Donalds D000032 | RepDonaldsPress | 1343968646050283522 | |||||
S001135 | Michelle Steel S001135 | RepSteel | 1343740146630451200 | |||||
G000593 | Carlos Gimenez G000593 | RepCarlos | 1343679195034103808 | |||||
F000472 | C. Franklin F000472 | RepFranklin | 1343664721384398849 | |||||
M001211 | Mary Miller M001211 | RepMaryMiller | 1343656635907125250 | |||||
S001159 | Marilyn Strickland S001159 | RepStricklandWA | 1343646545955213312 | |||||
G000594 | Ernest Gonzales G000594 | RepTonyGonzales | 1343627416120532992 | |||||
B001312 | Carolyn Bourdeaux B001312 | RepBourdeaux | 1343620645452595200 | |||||
M000194 | Nancy Mace M000194 | RepNancyMace | 1343597700542038017 | |||||
N000192 | Marie Newman N000192 | RepMarieNewman | 1343578440977494018 | |||||
F000246 | Patrick Fallon F000246 | RepPatFallon | 1343258042704527362 | |||||
B000825 | Lauren Boebert B000825 | RepBoebert | 1342989756611907584 | |||||
J000304 | Ronny Jackson J000304 | RepRonnyJackson | 1341903465610686464 | |||||
P000048 | August Pfluger P000048 | RepPfluger | 1341120751399809026 | |||||
C001054 | Jerry Carl C001054 | RepJerryCarl | 1341091420439015424 | |||||
H001091 | Ashley Hinson H001091 | RepAshleyHinson | 1340783304304410625 | |||||
V000134 | Beth Van Duyne V000134 | RepBethVanDuyne | 1339633259349745670 | |||||
M001212 | Barry Moore M001212 | RepBarryMoore | 1339006078688825344 | |||||
M001213 | Blake Moore M001213 | RepBlakeMoore | 1337452596093587462 | |||||
M001135 | Kathy Manning M001135 | RepKManning | 1337115670161608712 | |||||
M001198 | Roger Marshall M001198 | SenatorMarshall | 1336344005588738052 | |||||
M001186 | Peter Meijer M001186 | RepMeijer | 1334164871420796928 | |||||
A000148 | Jake Auchincloss A000148 | RepAuchincloss | 1330278736554582016 | |||||
S000168 | Maria Salazar S000168 | RepMariaSalazar | 1325928411689349120 | |||||
K000377 | Mark Kelly K000377 | SenMarkKelly | SenMarkKelly | 1324926274888888320 | ||||
H000273 | John Hickenlooper H000273 | SenatorHick | 1318728336923787264 | |||||
P000603 | Rand Paul P000603 | SenRandPaul | SenatorRandPaul | UCeM9I-20oWUs8daIIpsNHoQ | 1298624375692894210 | SenatorRandPaul | senatorrandpaul | 541357095 |
T000486 | Ritchie Torres T000486 | RepRitchie | 1276403757224546304 | |||||
J000020 | Chris Jacobs J000020 | RepJacobs | 1276232539510919168 | |||||
M000687 | Kweisi Mfume M000687 | RepKweisiMfume | RepKweisiMfume | 1276209702322438148 | ||||
C001108 | James Comer C001108 | RepJamesComer | congressmancomer | 1274852794206388225 | congressmancomer | |||
T000165 | Thomas Tiffany T000165 | RepTiffany | 1267841066335682562 | |||||
G000061 | Mike Garcia G000061 | RepMikeGarcia | RepMikeGarcia | 1262531473057423361 | ||||
B001311 | Dan Bishop B001311 | RepDanBishop | repdanbishop | 1176522535531360257 | ||||
M001210 | Gregory Murphy M001210 | RepGregMurphy | RepGregMurphy | 1173978070535024642 | ||||
K000395 | Fred Keller K000395 | RepFredKeller | CongressmanFredKeller | UC_IluBx9m7HWoNhEYSoPQNQ | 1136060761422405633 | repfredkeller | ||
B001307 | James Baird B001307 | RepJimBaird | 1086316494450032640 | |||||
C001117 | Sean Casten C001117 | RepCasten | 1083472286089396224 | |||||
S001214 | W. Steube S001214 | RepGregSteube | 1083125649609506816 | |||||
R000614 | Chip Roy R000614 | RepChipRoy | 1082790600292925440 | |||||
G000586 | Jesús García G000586 | RepChuyGarcia | 1082427779583541248 | |||||
W000823 | Michael Waltz W000823 | RepWaltzPress | 1082416697380913152 | |||||
M001208 | Lucy McBath M001208 | RepLucyMcBath | 1082380458976051202 | |||||
P000615 | Greg Pence P000615 | RepGregPence | 1082369392229400576 | |||||
O000173 | Ilhan Omar O000173 | Ilhan | 1082334352711790593 | |||||
J000302 | John Joyce J000302 | RepJohnJoyce | 1082311988926124036 | |||||
H001081 | Jahana Hayes H001081 | RepJahanaHayes | 1082086081238102018 | |||||
C001055 | Ed Case C001055 | RepEdCase | 1081350574589833221 | |||||
M001205 | Carol Miller M001205 | RepCarolMiller | 1081318716573470720 | |||||
R000612 | John Rose R000612 | RepJohnRose | 1081312310059253763 | |||||
G000591 | Michael Guest G000591 | RepMichaelGuest | 1081243468327018496 | |||||
K000368 | Ann Kirkpatrick K000368 | RepKirkpatrick | 1081240074946252801 | |||||
P000618 | Katie Porter P000618 | RepKatiePorter | 1081222837459996672 | |||||
H001089 | Joshua Hawley H001089 | SenHawleyPress | 1080960924687704064 | |||||
M001203 | Tom Malinowski M001203 | RepMalinowski | 1080898026418384897 | |||||
C001120 | Dan Crenshaw C001120 | RepDanCrenshaw | 1080894931311431682 | |||||
G000592 | Jared Golden G000592 | RepGolden | 1080891667308298240 | |||||
S001211 | Greg Stanton S001211 | RepGregStanton | 1080885078425784320 |
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 );