social_media
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
528 rows sorted by youtube_id
This data as json, copyable, CSV (advanced)
id | legislator_id | youtube_id ▼ | twitter_id | youtube | instagram_id | |||
---|---|---|---|---|---|---|---|---|
M000355 | Mitch McConnell M000355 | McConnellPress | mitchmcconnell | 339822881 | mcconnellpress | |||
M000087 | Carolyn Maloney M000087 | RepMaloney | RepCarolynMaloney | 258900199 | carolynbmaloney | repmaloney | ||
L000570 | Ben Luján L000570 | SenatorLujan | 19318314 | |||||
K000381 | Derek Kilmer K000381 | RepDerekKilmer | derek.kilmer | 1058917562 | ||||
S001203 | Tina Smith S001203 | SenTinaSmith | USSenTinaSmith | 941000686275387392 | ||||
E000294 | Tom Emmer E000294 | RepTomEmmer | reptomemmer | 2914515430 | RepTomEmmer | reptomemmer | 1565640999 | |
K000386 | John Katko K000386 | RepJohnKatko | RepJohnKatko | 2966765501 | ||||
G000574 | Ruben Gallego G000574 | RepRubenGallego | RepRubenGallego | 2966570782 | reprubengallego | |||
D000623 | Mark DeSaulnier D000623 | RepDeSaulnier | RepMarkDeSaulnier | 2968007206 | repdesaulnier | |||
B001303 | Lisa Blunt Rochester B001303 | RepLBR | Rep.BluntRochester | 817050219007328258 | ||||
B001300 | Nanette Barragán B001300 | RepBarragan | CongresswomanBarragan | 816833925456789505 | repbarragan | |||
M001199 | Brian Mast M001199 | RepBrianMast | repbrianmast | 814103950404239360 | repbrianmast | RepBrianMast | ||
G000583 | Josh Gottheimer G000583 | RepJoshG | RepJoshG | 815310506596691968 | RepJoshG | |||
M001202 | Stephanie Murphy M001202 | RepStephMurphy | RepStephMurphy | 796183515998068736 | RepStephMurphy | RepStephMurphy | ||
A000375 | Jodey Arrington A000375 | RepArrington | JodeyArrington | 816284664658874368 | repjodeyarrington | |||
C001112 | Salud Carbajal C001112 | RepCarbajal | repsaludcarbajal | 816157667882373120 | repcarbajal | repcarbajal | ||
S001190 | Bradley Schneider S001190 | RepSchneider | CongressmanBradSchneider | 1071840474 | RepBradSchneider | repschneider | ||
B001305 | Ted Budd B001305 | RepTedBudd | RepTedBudd | 817138492614524928 | ||||
O000171 | Tom O’Halleran O000171 | RepOHalleran | repohalleran | 808416682972770304 | repohalleran | |||
K000393 | John Kennedy K000393 | SenJohnKennedy | JohnKennedyLouisiana | 816683274076614656 | SenJohnKennedy | |||
L000586 | Al Lawson L000586 | RepAlLawsonJr | RepAlLawsonJr | 818472418620608512 | ||||
K000391 | Raja Krishnamoorthi K000391 | CongressmanRaja | congressmanraja | 814179031956488192 | congressmanraja | |||
H001076 | Margaret Hassan H001076 | SenatorHassan | SenatorHassan | 946549322 | ||||
S001200 | Darren Soto S001200 | RepDarrenSoto | CongressmanDarrenSoto | 818713465653051392 | repdarrensoto | RepDarrenSoto | ||
B001301 | Jack Bergman B001301 | RepJackBergman | RepJackBergman | 815241612154417152 | RepJackBergman | RepJackBergman | ||
G000579 | Mike Gallagher G000579 | RepGallagher | RepMikeGallagher | 815966620300480514 | ||||
C001108 | James Comer C001108 | RepJamesComer | congressmancomer | 1274852794206388225 | congressmancomer | |||
M001198 | Roger Marshall M001198 | SenatorMarshall | 1336344005588738052 | |||||
E000296 | Dwight Evans E000296 | RepDwightEvans | RepDwightEvans | 90639372 | repdwightevans | |||
R000609 | John Rutherford R000609 | RepRutherfordFL | RepRutherfordFL | 828977216595849216 | ||||
R000608 | Jacky Rosen R000608 | SenJackyRosen | RepJackyRosen | 818554054309715969 | repjackyrosen | |||
H001077 | Clay Higgins H001077 | RepClayHiggins | CongressmanClayHiggins | 843636970538618880 | RepClayHiggins | |||
B001304 | Anthony Brown B001304 | RepAnthonyBrown | RepAnthonyBrown | 823552974253342721 | RepAnthonyBrown | RepAnthonyBrown | ||
G000585 | Jimmy Gomez G000585 | RepJimmyGomez | RepJimmyGomez | 2371339658 | ||||
N000190 | Ralph Norman N000190 | RepRalphNorman | RepRalphNorman | 880480631108644864 | ||||
L000589 | Debbie Lesko L000589 | RepDLesko | RepDebbieLesko | 996094929733652481 | ||||
C001115 | Michael Cloud C001115 | RepCloudTX | 1039879658400112640 | |||||
A000377 | Kelly Armstrong A000377 | RepArmstrongND | 1080515866255593472 | |||||
S001212 | Pete Stauber S001212 | RepPeteStauber | 1075830599007510535 | |||||
L000591 | Elaine Luria L000591 | RepElaineLuria | 1080292515939565568 | |||||
B001306 | Troy Balderson B001306 | RepBalderson | 1037341536592310272 | |||||
A000376 | Colin Allred A000376 | RepColinAllred | 1078355119920562176 | |||||
C001118 | Ben Cline C001118 | RepBenCline | 1072158357237174272 | |||||
H001066 | Steven Horsford H001066 | RepHorsford | 389840566 | |||||
H001082 | Kevin Hern H001082 | repkevinhern | 1067818539179024386 | |||||
L000593 | Mike Levin L000593 | RepMikeLevin | 1072134139560620033 | |||||
M001206 | Joseph Morelle M001206 | RepJoeMorelle | 1064595993222615040 | |||||
N000191 | Joe Neguse N000191 | RepJoeNeguse | 1078749802765139968 | |||||
S001209 | Abigail Spanberger S001209 | RepSpanberger | 1078771401497161728 | |||||
S001213 | Bryan Steil S001213 | RepBryanSteil | 1075205691621720064 | |||||
W000826 | Susan Wild W000826 | RepSusanWild | 1069636653353000962 | |||||
R000615 | Mitt Romney R000615 | SenatorRomney | 1078693601356509184 | |||||
A000378 | Cynthia Axne A000378 | RepCindyAxne | 1080865917377097728 | |||||
B001309 | Tim Burchett B001309 | RepTimBurchett | 1028854804087492613 | |||||
C001119 | Angie Craig C001119 | RepAngieCraig | 1080222360643485698 | |||||
C001120 | Dan Crenshaw C001120 | RepDanCrenshaw | 1080894931311431682 | |||||
C001121 | Jason Crow C001121 | RepJasonCrow | 1080191866509901826 | |||||
D000629 | Sharice Davids D000629 | RepDavids | 1080516116395499522 | |||||
B001310 | Mike Braun B001310 | SenatorBraun | 1080870981877534720 | |||||
E000299 | Veronica Escobar E000299 | RepEscobar | 1075517806551154689 | |||||
F000468 | Lizzie Fletcher F000468 | RepFletcher | 1075904377221722113 | |||||
F000469 | Russ Fulcher F000469 | RepRussFulcher | 1078741899572240384 | |||||
G000587 | Sylvia Garcia G000587 | RepSylviaGarcia | 1080587263132733442 | |||||
G000590 | Mark Green G000590 | RepMarkGreen | 1080477288955826176 | |||||
G000592 | Jared Golden G000592 | RepGolden | 1080891667308298240 | |||||
H001085 | Chrissy Houlahan H001085 | RepHoulahan | 1052896620797460481 | |||||
H001090 | Josh Harder H001090 | RepJoshHarder | 1080851152151953410 | |||||
J000301 | Dusty Johnson J000301 | RepDustyJohnson | 1074782372594413569 | |||||
L000590 | Susie Lee L000590 | RepSusieLee | 1079061579973439488 | |||||
L000592 | Andy Levin L000592 | RepAndyLevin | 1080277407867772930 | |||||
M001204 | Daniel Meuser M001204 | RepMeuser | 1080574793630527505 | |||||
P000616 | Dean Phillips P000616 | RepDeanPhillips | 1061310112013434882 | |||||
P000617 | Ayanna Pressley P000617 | RepPressley | 1080584229510172678 | |||||
S001207 | Mikie Sherrill S001207 | RepSherrill | 1080569698536878081 | |||||
S001208 | Elissa Slotkin S001208 | RepSlotkin | 1078401427347857408 | |||||
S001211 | Greg Stanton S001211 | RepGregStanton | 1080885078425784320 | |||||
S001215 | Haley Stevens S001215 | RepHaleyStevens | 1076161611033968640 | |||||
S001216 | Kim Schrier S001216 | RepKimSchrier | 1080462532815532032 | |||||
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 | |||||
U000040 | Lauren Underwood U000040 | RepUnderwood | 1080539438508400642 | |||||
W000825 | Jennifer Wexton W000825 | RepWexton | 1017819745880543238 | |||||
K000368 | Ann Kirkpatrick K000368 | RepKirkpatrick | 1081240074946252801 | |||||
H001081 | Jahana Hayes H001081 | RepJahanaHayes | 1082086081238102018 | |||||
D000631 | Madeleine Dean D000631 | RepDean | 567508925 | |||||
P000614 | Chris Pappas P000614 | RepChrisPappas | 1067748650485497862 | |||||
P000618 | Katie Porter P000618 | RepKatiePorter | 1081222837459996672 | |||||
R000612 | John Rose R000612 | RepJohnRose | 1081312310059253763 | |||||
S001205 | Mary Scanlon S001205 | RepMGS | 1067541214671577093 | |||||
O000172 | Alexandria Ocasio-Cortez O000172 | RepAOC | 1079104563280527364 | |||||
J000302 | John Joyce J000302 | RepJohnJoyce | 1082311988926124036 | |||||
G000591 | Michael Guest G000591 | RepMichaelGuest | 1081243468327018496 | |||||
C001117 | Sean Casten C001117 | RepCasten | 1083472286089396224 | |||||
M001203 | Tom Malinowski M001203 | RepMalinowski | 1080898026418384897 | |||||
M001205 | Carol Miller M001205 | RepCarolMiller | 1081318716573470720 | |||||
M001208 | Lucy McBath M001208 | RepLucyMcBath | 1082380458976051202 | |||||
P000615 | Greg Pence P000615 | RepGregPence | 1082369392229400576 |
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 );