social_media
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
528 rows sorted by instagram_id
This data as json, copyable, CSV (advanced)
id | legislator_id | youtube_id | twitter_id | youtube | instagram_id ▼ | |||
---|---|---|---|---|---|---|---|---|
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 | ||
J000293 | Ron Johnson J000293 | SenRonJohnson | senronjohnson | UCG9XyTVtOAs7VX_q_QVHoaw | 233737858 | SenatorRonJohnson | senronjohnson | |
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 | |||||
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 | ||
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 | ||
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 | |
L000569 | Blaine Luetkemeyer L000569 | RepBlaine | BlaineLuetkemeyer | UCifiiQclKbBBrkSbCnN6REg | 1849261916 | BLuetkemeyer | ||
L000570 | Ben Luján L000570 | SenatorLujan | 19318314 | |||||
L000571 | Cynthia Lummis L000571 | SenLummis | 22831059 | |||||
L000576 | Billy Long L000576 | USRepLong | Rep.Billy.Long | UCLQcbyxpHXXAsUJckscQY8g | 1444015610 | MOdistrict7 | ||
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 | ||
M000194 | Nancy Mace M000194 | RepNancyMace | 1343597700542038017 | |||||
M000312 | James McGovern M000312 | RepMcGovern | RepJimMcGovern | UCpiUqp2ZF64tXqgR_EQo27g | 242426145 | repjimmcgovern | repmcgovern | |
M000317 | Nicole Malliotakis M000317 | RepMalliotakis | 1344750588026900481 | |||||
M000355 | Mitch McConnell M000355 | McConnellPress | mitchmcconnell | 339822881 | mcconnellpress | |||
M000687 | Kweisi Mfume M000687 | RepKweisiMfume | RepKweisiMfume | 1276209702322438148 | ||||
M000871 | Tracey Mann M000871 | RepMann | 1345825008887721986 | |||||
M001135 | Kathy Manning M001135 | RepKManning | 1337115670161608712 | |||||
M001136 | Lisa McClain M001136 | RepLisaMcClain | 1344032292432437248 | |||||
M001137 | Gregory Meeks M001137 | RepGregoryMeeks | gregorymeeksny05 | UCljJnwgQS6Z6-NypDyqKJZQ | 22812754 | gwmeeks | repgregorymeeks | |
M001143 | Betty McCollum M001143 | BettyMcCollum04 | repbettymccollum | UC3sZJSdiZo2EBHbsOlsnI7A | 516880804 | BMcCollum04 | repbettymccollum | |
M001153 | Lisa Murkowski M001153 | LisaMurkowski | SenLisaMurkowski | UCaigku16AErqvD0wRuwGb9A | 18061669 | senatormurkowski | senlisamurkowski | |
M001157 | Michael McCaul M001157 | RepMcCaul | michaeltmccaul | UCRw6sGE0PH7_FCeTT3PQRaA | 26424123 | MichaelTMcCaul | congressman_mccaul | |
M001159 | Cathy McMorris Rodgers M001159 | CathyMcMorris | mcmorrisrodgers | UCRp0lwIxAhq2Ia9_YgRWUkg | 17976923 | mcmorrisrodgers | cathymcmorris | |
M001160 | Gwen Moore M001160 | RepGwenMoore | GwenSMoore | UCCs9o1XaSsCsqNpO0iO0_Ew | 22669526 | RepGwenMoore | RepGwenMoore |
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 );