social_media
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
528 rows sorted by youtube
This data as json, copyable, CSV (advanced)
id | legislator_id | youtube_id | twitter_id | youtube ▼ | instagram_id | |||
---|---|---|---|---|---|---|---|---|
C001113 | Catherine Cortez Masto C001113 | SenCortezMasto | SenatorCortezMasto | UCip_83SiKUqwnUT57VOXrCg | 811313565760163844 | |||
C001114 | John Curtis C001114 | RepJohnCurtis | RepJohnCurtis | UChAQ4MD-HigmGnImSoAKBVA | 931614483050414080 | repjohncurtis | ||
C001115 | Michael Cloud C001115 | RepCloudTX | 1039879658400112640 | |||||
C001116 | Andrew Clyde C001116 | Rep_Clyde | 1357017361568694274 | |||||
C001117 | Sean Casten C001117 | RepCasten | 1083472286089396224 | |||||
C001118 | Ben Cline C001118 | RepBenCline | 1072158357237174272 | |||||
C001119 | Angie Craig C001119 | RepAngieCraig | 1080222360643485698 | |||||
C001120 | Dan Crenshaw C001120 | RepDanCrenshaw | 1080894931311431682 | |||||
C001121 | Jason Crow C001121 | RepJasonCrow | 1080191866509901826 | |||||
C001125 | Troy Carter C001125 | RepTroyCarter | 1352760304271241218 | |||||
C001126 | Mike Carey C001126 | RepMikeCarey | 1457745193197780993 | |||||
D000032 | Byron Donalds D000032 | RepDonaldsPress | 1343968646050283522 | |||||
D000617 | Suzan DelBene D000617 | RepDelBene | RepDelBene | UCd00b7TpKDZIr-Ujhaktvjg | 995193054 | repdelbene | ||
D000623 | Mark DeSaulnier D000623 | RepDeSaulnier | RepMarkDeSaulnier | 2968007206 | repdesaulnier | |||
D000624 | Debbie Dingell D000624 | RepDebDingell | RepDebbieDingell | UCnoP3KLT-HOvzDfC1-I-9lQ | 2970279814 | repdingell | ||
D000626 | Warren Davidson D000626 | WarrenDavidson | CongressmanWarrenDavidson | UCMzuyZWzk44YRNesFzPTeUw | 742735530287304704 | instawarrendavidson | ||
D000627 | Val Demings D000627 | RepValDemings | RepresentativeValDemings | UCkcshqwFNJG6XeduOforhig | 798973032362606600 | repvaldemings | ||
D000628 | Neal Dunn D000628 | DrNealDunnFL2 | drnealdunnfl2 | UCRTGfrYP-RuDzJ2KGok7TRA | 815952318487298048 | |||
D000629 | Sharice Davids D000629 | RepDavids | 1080516116395499522 | |||||
D000631 | Madeleine Dean D000631 | RepDean | 567508925 | |||||
E000071 | Jake Ellzey E000071 | RepEllzey | 1366523868253458437 | |||||
E000295 | Joni Ernst E000295 | SenJoniErnst | senjoniernst | UCLwrmtF_84FIcK3TyMs4MIw | 2856787757 | senjoniernst | 1582702853 | |
E000296 | Dwight Evans E000296 | RepDwightEvans | RepDwightEvans | 90639372 | repdwightevans | |||
E000297 | Adriano Espaillat E000297 | RepEspaillat | RepEspaillat | UCi0niBYFhEY70Dz8InbX5OQ | 817076257770835968 | repadrianoespaillat | ||
E000298 | Ron Estes E000298 | RepRonEstes | RepRonEstes | UC2clc28qcehIqotHQcthnWA | 854715071116849157 | RepRonEstes | ||
E000299 | Veronica Escobar E000299 | RepEscobar | 1075517806551154689 | |||||
F000246 | Patrick Fallon F000246 | RepPatFallon | 1343258042704527362 | |||||
F000446 | Randy Feenstra F000446 | RepFeenstra | 1345135363761852416 | |||||
F000465 | A. Ferguson F000465 | RepDrewFerguson | RepDrewFerguson | UCuK7_j2sREWi_7wBAN477bg | 806583915012046854 | repdrewferguson | ||
F000466 | Brian Fitzpatrick F000466 | RepBrianFitz | repbrianfitzpatrick | UCYMNcgHss4_Q5JY2vSvMpgw | 816303263586914304 | repbrianfitz | ||
F000468 | Lizzie Fletcher F000468 | RepFletcher | 1075904377221722113 | |||||
F000469 | Russ Fulcher F000469 | RepRussFulcher | 1078741899572240384 | |||||
F000470 | Michelle Fischbach F000470 | RepFischbach | 1344375287484723205 | |||||
F000471 | Scott Fitzgerald F000471 | RepFitzgerald | 1004891731 | |||||
F000472 | C. Franklin F000472 | RepFranklin | 1343664721384398849 | |||||
G000061 | Mike Garcia G000061 | RepMikeGarcia | RepMikeGarcia | 1262531473057423361 | ||||
G000546 | Sam Graves G000546 | RepSamGraves | 118514606128 | UCdg2ybvoHsSW6t7iJnKHlNg | 29766367 | repsamgraves | ||
G000574 | Ruben Gallego G000574 | RepRubenGallego | RepRubenGallego | 2966570782 | reprubengallego | |||
G000576 | Glenn Grothman G000576 | RepGrothman | RepGrothman | UCui4k83Cot4aeVW_8T33fgg | 2976606250 | |||
G000577 | Garret Graves G000577 | RepGarretGraves | CongressmanGarretGraves | UCQLg9GGwTDluEFJtXf8seTA | 2951574214 | instagravesla | ||
G000578 | Matt Gaetz G000578 | RepMattGaetz | CongressmanMattGaetz | UClqXcJew_A3s8qiX-T4a9CA | 818948638890217473 | Congressman_Matt_Gaetz | ||
G000579 | Mike Gallagher G000579 | RepGallagher | RepMikeGallagher | 815966620300480514 | ||||
G000581 | Vicente Gonzalez G000581 | RepGonzalez | USCongressmanVicenteGonzalez | UC5H6oYLKQ_xIXO5CG7fh4hw | 818536152588238849 | repvicentegonzaleztx | ||
G000582 | Jenniffer González-Colón G000582 | RepJenniffer | RepJennifferGonzalezColon | UCZj99h3-GNKjGGeyp7AJeXw | 819744763020775425 | |||
G000583 | Josh Gottheimer G000583 | RepJoshG | RepJoshG | 815310506596691968 | RepJoshG | |||
G000585 | Jimmy Gomez G000585 | RepJimmyGomez | RepJimmyGomez | 2371339658 | ||||
G000586 | Jesús García G000586 | RepChuyGarcia | 1082427779583541248 | |||||
G000587 | Sylvia Garcia G000587 | RepSylviaGarcia | 1080587263132733442 | |||||
G000588 | Anthony Gonzalez G000588 | RepAGonzalez | 1054381765224210432 | |||||
G000590 | Mark Green G000590 | RepMarkGreen | 1080477288955826176 | |||||
G000591 | Michael Guest G000591 | RepMichaelGuest | 1081243468327018496 | |||||
G000592 | Jared Golden G000592 | RepGolden | 1080891667308298240 | |||||
G000593 | Carlos Gimenez G000593 | RepCarlos | 1343679195034103808 | |||||
G000594 | Ernest Gonzales G000594 | RepTonyGonzales | 1343627416120532992 | |||||
G000595 | Robert Good G000595 | RepBobGood | 1345536897838436353 | |||||
G000596 | Marjorie Greene G000596 | RepMTG | 1344356576786866176 | |||||
G000597 | Andrew Garbarino G000597 | RepGarbarino | 1344349650447433729 | |||||
H000273 | John Hickenlooper H000273 | SenatorHick | 1318728336923787264 | |||||
H000601 | Bill Hagerty H000601 | SenatorHagerty | 1346873610875654147 | |||||
H001066 | Steven Horsford H001066 | RepHorsford | 389840566 | |||||
H001071 | Jody Hice H001071 | CongressmanHice | CongressmanJodyHice | UCzUMsS8DusN2QLpgweFthgQ | 2975091705 | rep_hice | ||
H001072 | J. Hill H001072 | RepFrenchHill | RepFrenchHill | UCT8uWroJtkwSsCJlVg0IKvQ | 2953974395 | repfrenchhill | ||
H001074 | Trey Hollingsworth H001074 | RepTrey | reptrey | UCTgS8a_zLg8HpUnk5WXY5ag | 811986281177772032 | |||
H001076 | Margaret Hassan H001076 | SenatorHassan | SenatorHassan | 946549322 | ||||
H001077 | Clay Higgins H001077 | RepClayHiggins | CongressmanClayHiggins | 843636970538618880 | RepClayHiggins | |||
H001079 | Cindy Hyde-Smith H001079 | SenHydeSmith | UCJHxkJhGST0NTlkzJHWV03Q | 983348251972816896 | sencindyhydesmith | |||
H001081 | Jahana Hayes H001081 | RepJahanaHayes | 1082086081238102018 | |||||
H001082 | Kevin Hern H001082 | repkevinhern | 1067818539179024386 | |||||
H001084 | Yvette Herrell H001084 | RepHerrell | 1344416719260016641 | |||||
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 | |||||
J000294 | Hakeem Jeffries J000294 | RepJeffries | RepHakeemJeffries | UCYVmbsjoNbQ4j-PCQIYgpWQ | 467823431 | |||
J000298 | Pramila Jayapal J000298 | RepJayapal | RepJayapal | UCmyD0_-2Oowkfwc_Raghclw | 815733290955112448 | repjayapal | ||
J000299 | Mike Johnson J000299 | RepMikeJohnson | RepMikeJohnson | UCzqBEpeIaDEfvAtsA53Fx2Q | 827279765287559171 | RepMikeJohnson | ||
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 | |||||
K000368 | Ann Kirkpatrick K000368 | RepKirkpatrick | 1081240074946252801 | |||||
K000377 | Mark Kelly K000377 | SenMarkKelly | SenMarkKelly | 1324926274888888320 | ||||
K000381 | Derek Kilmer K000381 | RepDerekKilmer | derek.kilmer | 1058917562 | ||||
K000385 | Robin Kelly K000385 | RepRobinKelly | reprobinkelly | UCLhcNPX2nNQLNzwKW0nEykg | 1339931490 | reprobinkelly | ||
K000386 | John Katko K000386 | RepJohnKatko | RepJohnKatko | 2966765501 | ||||
K000388 | Trent Kelly K000388 | RepTrentKelly | reptrentkelly | UCtDrz-8tdg4ZgOAQHToSWaQ | 3317799825 | reptrentkelly | ||
K000389 | Ro Khanna K000389 | RepRoKhanna | RepRoKhanna | UCr4KOYv1o1oEQhy1jhhm3pQ | 816298918468259841 | reprokhanna | ||
K000391 | Raja Krishnamoorthi K000391 | CongressmanRaja | congressmanraja | 814179031956488192 | congressmanraja | |||
K000392 | David Kustoff K000392 | RepDavidKustoff | RepDavidKustoff | UCK6U4plOKKMrCjv_h59spGQ | 816012124505931780 | repdavidkustoff | ||
K000393 | John Kennedy K000393 | SenJohnKennedy | JohnKennedyLouisiana | 816683274076614656 | SenJohnKennedy | |||
K000394 | Andy Kim K000394 | RepAndyKimNJ | 1078771848882593793 | |||||
K000395 | Fred Keller K000395 | RepFredKeller | CongressmanFredKeller | UC_IluBx9m7HWoNhEYSoPQNQ | 1136060761422405633 | repfredkeller | ||
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 |
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 );