social_media
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
528 rows
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | youtube_id | twitter_id | youtube | instagram_id | |||
---|---|---|---|---|---|---|---|---|
H001046 | Martin Heinrich H001046 | MartinHeinrich | MartinHeinrich | UCBxh8IK5sMxY0Ln_0G2NYcg | 1099199839 | SenMartinHeinrich | senatormartinheinrich | 285288987 |
H001047 | James Himes H001047 | CongressmanJimHimes | UCCeB6czh6nhCHxOMCk_V4yA | congressmanhimes | ||||
H001052 | Andy Harris H001052 | RepAndyHarrisMD | AndyHarrisMD | UCvUuV7FiJfJi1yux4qozgMg | 960962340 | RepAndyHarris | ||
H001053 | Vicky Hartzler H001053 | RepHartzler | Congresswoman.Hartzler | UCAvttUz6qBVEJiFt7p_MZxw | 237763317 | repvickyhartzler | rephartzler | 787899303 |
H001056 | Jaime Herrera Beutler H001056 | HerreraBeutler | herrerabeutler | UCJEgiA9clfx0amrQUj0aBTQ | 242926427 | RepHerreraBeutler | herrerabeutler | |
H001058 | Bill Huizenga H001058 | RepHuizenga | RepHuizenga | UCQPlLLiMnysMmeJ5qUSSjQg | 233949261 | RepHuizenga | RepHuizenga | |
H001061 | John Hoeven H001061 | SenJohnHoeven | SenatorJohnHoeven | UC1kQIC2Q_Fq9_NRqdb6eHiw | 382791093 | senatorjohnhoevennd | senjohnhoeven | 1237544252 |
H001066 | Steven Horsford H001066 | RepHorsford | 389840566 | |||||
H001067 | Richard Hudson H001067 | RepRichHudson | RepRichHudson | UC9Q1qCvnQR7rHERjTjJl5Pg | 935033864 | RepRichHudson | ||
H001068 | Jared Huffman H001068 | RepHuffman | RepHuffman | UCJU6SP1ppp1ZhSiqZLiFgDA | 1071102246 | rephuffman | rephuffman | |
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 | |||||
I000024 | James Inhofe I000024 | JimInhofe | jiminhofe | UCk3W3ilX8vGG-300qzNpG7w | 7270292 | jiminhofepressoffice | ||
I000056 | Darrell Issa I000056 | repdarrellissa | 63650107 | |||||
J000020 | Chris Jacobs J000020 | RepJacobs | 1276232539510919168 | |||||
J000032 | Sheila Jackson Lee J000032 | JacksonLeeTX18 | CongresswomanSheilaJacksonLee | UCi_S-mOZaEco2Zb9guf_8Iw | 80612021 | TX18SJL | ||
J000126 | Eddie Johnson J000126 | RepEBJ | CongresswomanEBJtx30 | UCVKp8BtjW708H4eXJJQgUYw | 168502762 | RepEddieBJohnson | repebj | |
J000288 | Henry Johnson J000288 | RepHankJohnson | 115356957005 | UCqMici9I7nz_i-PN7eSYjwQ | 24745957 | RepHankJohnson | rephankjohnson | |
J000289 | Jim Jordan J000289 | Jim_Jordan | repjimjordan | UCPFBhS00ivPV585GlnNlyqA | 18166778 | RepJimJordan | ||
J000292 | Bill Johnson J000292 | RepBillJohnson | RepBillJohnson | UCtF08Ay71haDRoJosRN2P_Q | 211530910 | RepBillJohnson | repbilljohnson | 763495818 |
J000293 | Ron Johnson J000293 | SenRonJohnson | senronjohnson | UCG9XyTVtOAs7VX_q_QVHoaw | 233737858 | SenatorRonJohnson | senronjohnson | |
J000294 | Hakeem Jeffries J000294 | RepJeffries | RepHakeemJeffries | UCYVmbsjoNbQ4j-PCQIYgpWQ | 467823431 | |||
J000295 | David Joyce J000295 | RepDaveJoyce | RepDaveJoyce | UCTu9xz2VYk-jtQv0TVsLyYA | 976969338 | repdavejoyce | repdavejoyce | 360743678 |
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 | |||||
K000009 | Marcy Kaptur K000009 | RepMarcyKaptur | RepresentativeMarcyKaptur | UCIJUNf22o09nO02oQPLKQ6w | 581141508 | USRepMarcyKaptur | repmarcykaptur | |
K000188 | Ron Kind K000188 | RepRonKind | repronkind | UC0_BilariURHwSHf9baGykg | 112740986 | RepRonKind | ||
K000367 | Amy Klobuchar K000367 | SenAmyKlobuchar | UCvdeJsDsV51tFb_hVqvtYGA | 22044727 | senatorklobuchar | |||
K000368 | Ann Kirkpatrick K000368 | RepKirkpatrick | 1081240074946252801 | |||||
K000375 | William Keating K000375 | USRepKeating | Congressman.Keating | UC7KPV4xdxO2dms9vl6tETmg | 232992031 | RepBillKeating | ||
K000376 | Mike Kelly K000376 | MikeKellyPA | 191056827594903 | UCoz6u3ooQxoijsWvhoQ0D-A | 935368364 | repmikekelly | ||
K000377 | Mark Kelly K000377 | SenMarkKelly | SenMarkKelly | 1324926274888888320 | ||||
K000378 | Adam Kinzinger K000378 | RepKinzinger | RepKinzinger | UCjDHxyjndxxhjuPWyEBc7UA | 219429281 | RepAdamKinzinger | ||
K000380 | Daniel Kildee K000380 | RepDanKildee | RepDanKildee | UC_KpQ-n3IT5dL5ul21XA9Yw | 1045110018 | RepDanKildee | repdankildee | 582887115 |
K000381 | Derek Kilmer K000381 | RepDerekKilmer | derek.kilmer | 1058917562 | ||||
K000382 | Ann Kuster K000382 | RepAnnieKuster | CongresswomanAnnieKuster | UCYAD_Eti2b5gXSicbgPsBYA | 1058717720 | RepKuster | ||
K000383 | Angus King K000383 | SenAngusKing | SenatorAngusSKingJr | UCpp6lGvrmt0XU_lnD4Ak0gA | 1068481578 | SenatorAngusKing | ||
K000384 | Timothy Kaine K000384 | SenatorKaine | UC27LgTZlUnBQoNEQFZdn9LA | SenatorTimKaine | ||||
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 | |||||
L000174 | Patrick Leahy L000174 | SenatorLeahy | SenatorPatrickLeahy | UC46QHVobf7FO-tWehsRoDog | 242836537 | SenatorPatrickLeahy | senatorleahy | |
L000266 | Jacob LaTurner L000266 | RepLaTurner | 1345850704800468993 | |||||
L000273 | Teresa Leger Fernandez L000273 | RepTeresaLF | 1345147845926670337 | |||||
L000397 | Zoe Lofgren L000397 | RepZoeLofgren | zoelofgren | UCOaQ79adORFcaTuJZoIFuZQ | 267938462 | RepZoeLofgren | ||
L000491 | Frank Lucas L000491 | RepFrankLucas | RepFrankLucas | UCdYZbKY8pkWAThqwC3fdVMg | 242772524 | RepFrankLucas | ||
L000551 | Barbara Lee L000551 | RepBarbaraLee | RepBarbaraLee | UCnRgK2MXAQOUau0JXqseeNA | 248735463 | RepLee | repbarbaralee | 1415801245 |
L000557 | John Larson L000557 | RepJohnLarson | RepJohnLarson | UCGPsvFF-9WfpdRSCcCrPLiQ | 50452197 | RepJohnLarson | RepJohnBLarson | |
L000559 | James Langevin L000559 | JimLangevin | CongressmanJimLangevin | UCQ1sth-7umw1k-fSVqdfRTg | 18909919 | jimlangevin | ||
L000560 | Rick Larsen L000560 | RepRickLarsen | RepRickLarsen | UCMv7LsJtiyO4AJcbRux5CxQ | 404132211 | congressmanlarsen | repricklarsen | |
L000562 | Stephen Lynch L000562 | RepStephenLynch | repstephenlynch | UCxL4zG0YWqC5XTO4af_FOgw | 310310133 | RepLynch | repstephenlynch | |
L000564 | Doug Lamborn L000564 | RepDLamborn | CongressmanDougLamborn | UCaYsGYMniq4nwBBMKFIwsow | 584012853 | CongressmanLamborn | douglamborn | |
L000566 | Robert Latta L000566 | BobLatta | boblatta | UCVSBVHoWu-eWnBBQaMKZ_sQ | 15394954 | CongressmanBobLatta | boblatta | 26367713 |
L000569 | Blaine Luetkemeyer L000569 | RepBlaine | BlaineLuetkemeyer | UCifiiQclKbBBrkSbCnN6REg | 1849261916 | BLuetkemeyer | ||
L000570 | Ben Luján L000570 | SenatorLujan | 19318314 | |||||
L000571 | Cynthia Lummis L000571 | SenLummis | 22831059 | |||||
L000575 | James Lankford L000575 | SenatorLankford | SenatorLankford | UCz8T6sK5fEycyWmVz6Vpe5Q | 225921757 | SenatorLankford | senatorlankford | 1552251018 |
L000576 | Billy Long L000576 | USRepLong | Rep.Billy.Long | UCLQcbyxpHXXAsUJckscQY8g | 1444015610 | MOdistrict7 | ||
L000577 | Mike Lee L000577 | SenMikeLee | senatormikelee | UCplVxs_j_sLAt0fkplXcl4A | 88784440 | senatormikelee | senmikelee | 391361701 |
L000578 | Doug LaMalfa L000578 | RepLaMalfa | RepLaMalfa | UCUzz1XDn862fxirervSB2Yw | 1069124515 | RepLaMalfa | repdouglamalfa | |
L000579 | Alan Lowenthal L000579 | RepLowenthal | RepLowenthal | UC-GgROtn5Hxm1H9a6qvy_Wg | 1055730738 | RepLowenthal | RepLowenthal | |
L000581 | Brenda Lawrence L000581 | RepLawrence | 395759603917487 | UCf0USy9GNigkB8O9sS1dodw | 2863006655 | repbrendalawrence | ||
L000582 | Ted Lieu L000582 | RepTedLieu | RepTedLieu | UC9qcJxTqfDNBnVul1IojlFg | 3044993235 | RepTedLieu | ||
L000583 | Barry Loudermilk L000583 | RepLoudermilk | reploudermilk | UC2Kfw8fjca8k3w3KpzL5tNg | 2914163523 | RepLoudermilk | ||
L000585 | Darin LaHood L000585 | RepLaHood | replahood | UCVRbtFwaBGcixZIkygtalRw | 3686482216 | |||
L000586 | Al Lawson L000586 | RepAlLawsonJr | RepAlLawsonJr | 818472418620608512 | ||||
L000588 | Conor Lamb L000588 | RepConorLamb | RepConorLamb | UC7hX59n_ixS1Bz3f8Je02yA | 984456621417000960 | |||
L000589 | Debbie Lesko L000589 | RepDLesko | RepDebbieLesko | 996094929733652481 | ||||
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 | |||||
M000087 | Carolyn Maloney M000087 | RepMaloney | RepCarolynMaloney | 258900199 | carolynbmaloney | repmaloney | ||
M000133 | Edward Markey M000133 | SenMarkey | EdJMarkey | UCT1ujew5yQy2uMhGrjiKHoA | 21406834 | RepMarkey |
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 );