social_media
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
528 rows sorted by id descending
This data as json, copyable, CSV (advanced)
id ▲ | legislator_id | youtube_id | twitter_id | youtube | instagram_id | |||
---|---|---|---|---|---|---|---|---|
S001148 | Michael Simpson S001148 | CongMikeSimpson | 96007744606 | UCNXe0rJJeULTAP_7oyQNw8g | 76132891 | CongMikeSimpson | ||
S001145 | Janice Schakowsky S001145 | JanSchakowsky | janschakowsky | UCuCHHPSENUEaaeH8n_CYDXQ | 24195214 | repschakowsky | ||
S001135 | Michelle Steel S001135 | RepSteel | 1343740146630451200 | |||||
S000929 | Victoria Spartz S000929 | RepSpartz | 1344845201479663621 | |||||
S000770 | Debbie Stabenow S000770 | SenStabenow | SenatorStabenow | UCFoDKCvxSwCUfDv-4Eg4K5A | 76456274 | senatorstabenow | ||
S000522 | Christopher Smith S000522 | RepChrisSmith | UCtCNUDo3-I1gsd_03ppDfZg | USRepChrisSmith | ||||
S000510 | Adam Smith S000510 | RepAdamSmith | RepAdamSmith | UCcrHso483LOfC6WwDnzAh-g | 58928690 | CongressmanAdamSmith | ||
S000344 | Brad Sherman S000344 | BradSherman | 63158229861 | UCPisrz6-SLwVy2l9Mcy8kug | 30216513 | shermanca27 | ||
S000320 | Richard Shelby S000320 | SenShelby | RichardShelby | UCyMzDCRZrmhr_OGDjVuAeJw | 21111098 | SenatorRichardShelby | ||
S000250 | Pete Sessions S000250 | PeteSessions | 24735461 | |||||
S000185 | Robert Scott S000185 | BobbyScott | RepBobbyScott | UCdNNcpw8arCsUp55JwK_QAA | 161791703 | repbobbyscott | repbobbyscott | 1173348983 |
S000168 | Maria Salazar S000168 | RepMariaSalazar | 1325928411689349120 | |||||
S000148 | Charles Schumer S000148 | SenSchumer | senschumer | UC-ABttxh8uQv_10qmwGaidw | 17494010 | SenatorSchumer | ||
S000033 | Bernard Sanders S000033 | SenSanders | senatorsanders | UCD_DaKNac0Ta-2PeHuoQ1uA | 29442313 | senatorsanders | ||
R000615 | Mitt Romney R000615 | SenatorRomney | 1078693601356509184 | |||||
R000614 | Chip Roy R000614 | RepChipRoy | 1082790600292925440 | |||||
R000612 | John Rose R000612 | RepJohnRose | 1081312310059253763 | |||||
R000610 | Guy Reschenthaler R000610 | GReschenthaler | 4205133682 | |||||
R000609 | John Rutherford R000609 | RepRutherfordFL | RepRutherfordFL | 828977216595849216 | ||||
R000608 | Jacky Rosen R000608 | SenJackyRosen | RepJackyRosen | 818554054309715969 | repjackyrosen | |||
R000606 | Jamie Raskin R000606 | RepRaskin | repraskin | UChxDE6vho5BfBTOqiBsDmKg | 806906355214852096 | repraskin | ||
R000605 | Mike Rounds R000605 | SenatorRounds | SenatorMikeRounds | UC-pvzimyBdpdkcIfsicrfrQ | 2955485182 | |||
R000603 | David Rouzer R000603 | RepDavidRouzer | RepRouzer | UCBvOxpqoGi1HlHjX9v_gHZw | 834069080 | repdavidrouzer | ||
R000602 | Kathleen Rice R000602 | RepKathleenRice | RepKathleenRice | UCLYLmjrGtzzCFXMWPBxHAug | 2970462034 | |||
R000600 | Aumua Amata Radewagen R000600 | RepAmata | aumuaamata | UCGdrLQbt1PYDTPsampx4t1A | 3026622545 | |||
R000599 | Raul Ruiz R000599 | RepRaulRuizMD | CongressmanRaulRuizMD | UCSDk-cyNPCo1iy6rweSPmBw | 1089859058 | repraulruiz | ||
R000597 | Tom Rice R000597 | RepTomRice | reptomrice | UCEmPVQphMGoXAfWJli68BEw | 1058345042 | RepTomRice | reptomrice | |
R000595 | Marco Rubio R000595 | SenRubioPress | SenatorMarcoRubio | UCh8t7sV_DBKz4A-RkL9feyg | 229966028 | SenatorMarcoRubio | ||
R000584 | James Risch R000584 | SenatorRisch | senatorjimrisch | UCncKW8xyT5UbPNO27YuQnBA | 1096059529 | SenatorJamesRisch | ||
R000577 | Tim Ryan R000577 | RepTimRyan | timryan | UCjAFlYCheFKjGg_Pxc2VOFA | 13491312 | timryanvision | ||
R000576 | C. Ruppersberger R000576 | Call_Me_Dutch | DutchRupp | UCk2S9iSHNpo1E1A7qZ0SPIw | 305620929 | ruppersberger | dutchruppersberger | |
R000575 | Mike Rogers R000575 | RepMikeRogersAL | CongressmanMikeDRogers | UCH-WUWuY0_dlKwJDSqKTJsg | 33977070 | MikeRogersAL03 | repmikerogersal | 259435765 |
R000515 | Bobby Rush R000515 | RepBobbyRush | congressmanbobbyrush | UCbWqxBnS_w_uFTdQAL0YH5g | 305216911 | CongressmanRush | ||
R000486 | Lucille Roybal-Allard R000486 | RepRoybalAllard | RepRoybalAllard | UC_T_RXWeJ-smmpjdNLOaMcg | 479872233 | RepRoybalAllard | RepRoybalAllard | |
R000395 | Harold Rogers R000395 | RepHalRogers | CongressmanHalRogers | UChVFKLZkRoHQDhp4zNvEezQ | 550401754 | RepHalRogers | rephalrogers | |
R000305 | Deborah Ross R000305 | RepDeborahRoss | 1348683154815655940 | |||||
R000122 | John Reed R000122 | SenJackReed | SenJackReed | UCT_aFVtsjxPwWKfO-PW_hPw | 486694111 | SenatorReed | ||
R000103 | Matthew Rosendale R000103 | RepRosendale | 1344751420139040783 | |||||
Q000023 | Mike Quigley Q000023 | RepMikeQuigley | repmikequigley | UCDP13XegdoZ4bxYHxM34yAA | 56864092 | RepMikeQuigley | repmikequigley | 1403659583 |
P000618 | Katie Porter P000618 | RepKatiePorter | 1081222837459996672 | |||||
P000617 | Ayanna Pressley P000617 | RepPressley | 1080584229510172678 | |||||
P000616 | Dean Phillips P000616 | RepDeanPhillips | 1061310112013434882 | |||||
P000615 | Greg Pence P000615 | RepGregPence | 1082369392229400576 | |||||
P000614 | Chris Pappas P000614 | RepChrisPappas | 1067748650485497862 | |||||
P000613 | Jimmy Panetta P000613 | RepJimmyPanetta | RepJimmyPanetta | UCmw-aERG51C96edMDPN7fXQ | 796736612554117120 | repjimmypanetta | ||
P000610 | Stacey Plaskett P000610 | StaceyPlaskett | repstaceyplaskett | UC3V7biFZHDFHDFZy6cCSZUA | 2724095695 | stacey_plaskett | ||
P000609 | Gary Palmer P000609 | USRepGaryPalmer | CongressmanGaryPalmer | UCYZfP-cNIvlJY3AcAc9OPpQ | 2861616083 | repgarypalmer | 1551536636 | |
P000608 | Scott Peters P000608 | RepScottPeters | RepScottPeters | UCQK77QJxW7Xr-S3zqeMd-0g | 1135486501 | repscottpeters | ||
P000607 | Mark Pocan P000607 | RepMarkPocan | repmarkpocan | UCz5b47WER_u3dUGV_Zi70dQ | 1206227149 | repmarkpocan | repmarkpocan | 1422301608 |
P000605 | Scott Perry P000605 | RepScottPerry | repscottperry | UCzgrU5PT_HHRgf5hXPen4dQ | 18773159 | RepScottPerry | repscottperry | 519463466 |
P000604 | Donald Payne P000604 | RepDonaldPayne | DonaldPayneJr | UCTG_SeYsOgbngjv1Donyu0w | 1155335864 | repdonaldpaynejr | ||
P000603 | Rand Paul P000603 | SenRandPaul | SenatorRandPaul | UCeM9I-20oWUs8daIIpsNHoQ | 1298624375692894210 | SenatorRandPaul | senatorrandpaul | 541357095 |
P000601 | Steven Palazzo P000601 | CongPalazzo | stevenpalazzo | UCtPOy2vRbN2nD8dQPSOTXeA | 299883942 | CongressmanPalazzo | congressmanpalazzo | |
P000599 | Bill Posey P000599 | CongBillPosey | bill.posey15 | UCoUwUkDpe1ZYd6tiaZfiMuA | 25086658 | CongressmanPosey | ||
P000597 | Chellie Pingree P000597 | ChelliePingree | ChelliePingree | UCLKaWFM7I84WcreDRhhhkVg | 14984637 | congresswomanpingree | ||
P000595 | Gary Peters P000595 | SenGaryPeters | SenGaryPeters | UC7LYNbnKSK2VZqQ98YROWHQ | 236511574 | RepGaryPeters | sengarypeters | 1640246681 |
P000593 | Ed Perlmutter P000593 | RepPerlmutter | RepPerlmutter | UCJXuMAzxngpEvDdvlE6wS5g | 20552026 | RepPerlmutter | ||
P000523 | David Price P000523 | RepDavidEPrice | RepDavidEPrice | UCtX7bSXBLF9ge-Q955n5Vqw | 155669457 | RepDavidPrice | repdavideprice | |
P000449 | Robert Portman P000449 | SenRobPortman | senrobportman | UCwunkd8Zs-yAWKQwnwBp7ew | 18915145 | SenRobPortman | senrobportman | 370356159 |
P000197 | Nancy Pelosi P000197 | SpeakerPelosi | NancyPelosi | UCxPeEcH0xaCK9nBK98EFhDg | 15764644 | nancypelosi | ||
P000145 | Alejandro Padilla P000145 | SenAlexPadilla | 1351236267707654145 | |||||
P000096 | Bill Pascrell P000096 | BillPascrell | pascrell | UCIy1Ru8oA14aRjpq6L3i-EQ | 74508260 | RepPascrell | ||
P000048 | August Pfluger P000048 | RepPfluger | 1341120751399809026 | |||||
P000034 | Frank Pallone P000034 | FrankPallone | repfrankpallone | UCN0_wn9hs1LI3UKkji2PP2A | 31801993 | repfrankpallone | repfrankpallone | |
O000174 | Jon Ossoff O000174 | SenOssoff | 1356714265894408196 | |||||
O000173 | Ilhan Omar O000173 | Ilhan | 1082334352711790593 | |||||
O000172 | Alexandria Ocasio-Cortez O000172 | RepAOC | 1079104563280527364 | |||||
O000171 | Tom O’Halleran O000171 | RepOHalleran | repohalleran | 808416682972770304 | repohalleran | |||
O000086 | Clarence Owens O000086 | RepBurgessOwens | 1344481217685692416 | |||||
O000019 | Jay Obernolte O000019 | JayObernolte | 272482466 | |||||
N000192 | Marie Newman N000192 | RepMarieNewman | 1343578440977494018 | |||||
N000191 | Joe Neguse N000191 | RepJoeNeguse | 1078749802765139968 | |||||
N000190 | Ralph Norman N000190 | RepRalphNorman | RepRalphNorman | 880480631108644864 | ||||
N000189 | Dan Newhouse N000189 | RepNewhouse | RepNewhouse | UCllbsv_aoIaPS6W3aSonZlw | 2930635215 | |||
N000188 | Donald Norcross N000188 | DonaldNorcross | DonaldNorcrossNJ | UC7kXK_PyDiOT8YrdP0jYZHw | 3122099613 | donald_norcross | ||
N000179 | Grace Napolitano N000179 | GraceNapolitano | RepGraceNapolitano | UCPWjmiAIR04oQ8QMoOWcDtA | 161411080 | RepGraceNapolitano | repgracenapolitano | |
N000147 | Eleanor Norton N000147 | EleanorNorton | CongresswomanNorton | UChRrAXUGylfxJjbquC6aUjQ | 23600262 | EleanorHNorton | ||
N000026 | Troy Nehls N000026 | RepTroyNehls | 1347318288850825217 | |||||
N000015 | Richard Neal N000015 | RepRichardNeal | reprichardneal | UCZVtTydu0-MSK6G12GaKA4g | 442824717 | RepRichardENeal | ||
N000002 | Jerrold Nadler N000002 | RepJerryNadler | CongressmanNadler | UCQKj0qU1e7o2f5ftSh-c9aQ | 40302336 | congressmannadler | ||
M001215 | Mariannette Miller-Meeks M001215 | RepMMM | 1345807954604412929 | |||||
M001214 | Frank Mrvan M001214 | RepMrvan | 1346205046036377601 | |||||
M001213 | Blake Moore M001213 | RepBlakeMoore | 1337452596093587462 | |||||
M001212 | Barry Moore M001212 | RepBarryMoore | 1339006078688825344 | |||||
M001211 | Mary Miller M001211 | RepMaryMiller | 1343656635907125250 | |||||
M001210 | Gregory Murphy M001210 | RepGregMurphy | RepGregMurphy | 1173978070535024642 | ||||
M001208 | Lucy McBath M001208 | RepLucyMcBath | 1082380458976051202 | |||||
M001206 | Joseph Morelle M001206 | RepJoeMorelle | 1064595993222615040 | |||||
M001205 | Carol Miller M001205 | RepCarolMiller | 1081318716573470720 | |||||
M001204 | Daniel Meuser M001204 | RepMeuser | 1080574793630527505 | |||||
M001203 | Tom Malinowski M001203 | RepMalinowski | 1080898026418384897 | |||||
M001202 | Stephanie Murphy M001202 | RepStephMurphy | RepStephMurphy | 796183515998068736 | RepStephMurphy | RepStephMurphy | ||
M001199 | Brian Mast M001199 | RepBrianMast | repbrianmast | 814103950404239360 | repbrianmast | RepBrianMast | ||
M001198 | Roger Marshall M001198 | SenatorMarshall | 1336344005588738052 | |||||
M001196 | Seth Moulton M001196 | RepMoulton | CongressmanSethMoulton | UC5w5qn7nj5Ljy69LTV7a_fQ | 3091316093 | repmoulton | ||
M001195 | Alexander Mooney M001195 | RepAlexMooney | CongressmanAlexMooney | UCw9CGkF4Re3areluI43TGyA | 2964526557 | repalexmooney | ||
M001194 | John Moolenaar M001194 | RepMoolenaar | RepMoolenaar | UCnMvVN4a8roZu4crE0UW2DA | 2696643955 | RepMoolenaar | ||
M001190 | Markwayne Mullin M001190 | RepMullin | RepMullin | UCLQlm-cbGbJj9baZC6oFsag | 1060370282 | |||
M001188 | Grace Meng M001188 | RepGraceMeng | repgracemeng | UCHg516zJKbIBtXFAJ0nu3XQ | 1051127714 | |||
M001186 | Peter Meijer M001186 | RepMeijer | 1334164871420796928 |
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 );