social_media

Table actions

528 rows

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ legislator_id youtube_id youtube instagram instagram_id mastodon
C001126 Mike Carey C001126   @congressmanmikecarey      
C001127 Sheila Cherfilus-McCormick C001127          
C001129 Mike Collins C001129     repmikecollins    
C001130 Jasmine Crockett C001130     RepJasmine    
C001131 Gregorio Casar C001131     RepCasar    
C001132 Eli Crane C001132   @rep.elicrane      
C001133 Juan Ciscomani C001133   UCD329AYGX7YnMMSUaTKWHwA repjuanciscomani    
C001136 Herbert Conaway C001136          
C001137 Jeff Crank C001137     repjeffcrank    
D000032 Byron Donalds D000032   UCjy0W7sksMz37IYY27tAZNQ byrondonalds    
D000096 Danny Davis D000096 UCdhrT09_XMr31tuI8OcKsjQ dannykdavis07      
D000197 Diana DeGette D000197 UCWFQCRTHwsHg9P1Hf-EQtew RepDianaDeGette      
D000216 Rosa DeLauro D000216 UC9ROfGBm7kSLCEDYwFF6McQ rosadelauro      
D000230 Donald Davis D000230     RepDonDavis    
D000399 Lloyd Doggett D000399 UCN-kiLKyHPcfRVZ28sAHS_g doggett replloyddoggett    
D000530 Chris Deluzio D000530     RepDeluzio    
D000563 Richard Durbin D000563 UCkbixlNCxcKAffEhe3X5-lw SenatorDurbin      
D000594 Mónica De La Cruz D000594   @RepMonicaDLC RepMonicaDLC    
D000600 Mario Diaz-Balart D000600 UCpEEd0Plxx5D78pI4a4mFTQ MarioDiazBalart repmariodb 316477657  
D000616 Scott DesJarlais D000616 UCvjuSLoi3hS0ECQvJLhwOkA ScottDesJarlaisTN04 desjarlaistn04 260930821  
D000617 Suzan DelBene D000617 UCd00b7TpKDZIr-Ujhaktvjg   repdelbene    
D000618 Steve Daines D000618 UC-ny-W5mEUGytiyMdXbQ20Q SteveDainesMT stevedaines 371125857  
D000622 Tammy Duckworth D000622 UCYRWRvUxtjaHnFMCbdd94tg repduckworth SenDuckworth 1387939090  
D000623 Mark DeSaulnier D000623     repdesaulnier    
D000624 Debbie Dingell D000624 UCnoP3KLT-HOvzDfC1-I-9lQ   repdingell    
D000626 Warren Davidson D000626 UCMzuyZWzk44YRNesFzPTeUw   instawarrendavidson    
D000628 Neal Dunn D000628 UCRTGfrYP-RuDzJ2KGok7TRA        
D000629 Sharice Davids D000629          
D000631 Madeleine Dean D000631   UCHj4veUyhPzzOW-Jvn7MqUg repmadeleinedean    
D000634 Troy Downing D000634     reptroydowning    
D000635 Maxine Dexter D000635     repdexteror    
E000071 Jake Ellzey E000071          
E000235 Mike Ezell E000235   UCseRXy2_n4j97lndfkQ_hAw repmikeezell    
E000246 Charles (Chuck) Edwards E000246     repchuckedwards    
E000294 Tom Emmer E000294   RepTomEmmer reptomemmer 1565640999  
E000295 Joni Ernst E000295 UCLwrmtF_84FIcK3TyMs4MIw   senjoniernst 1582702853  
E000296 Dwight Evans E000296     repdwightevans    
E000297 Adriano Espaillat E000297 UCi0niBYFhEY70Dz8InbX5OQ   repadrianoespaillat    
E000298 Ron Estes E000298 UC2clc28qcehIqotHQcthnWA   RepRonEstes    
E000299 Veronica Escobar E000299   UC46TX2P8K0CA_4gZv8_R2Og repescobar    
E000300 Gabe Evans E000300     RepGabeEvans    
E000301 Sarah Elfreth E000301     RepSarahElfreth    
F000110 Cleo Fields F000110     repcleofields_    
F000246 Patrick Fallon F000246   RepPatFallon RepPatFallon    
F000446 Randy Feenstra F000446          
F000450 Virginia Foxx F000450 UCggineJcxJn80TRXxdQbx6w repvirginiafoxx repvirginiafoxx    
F000454 Bill Foster F000454 UCicixINQr_-3cFHI2bJzFpQ RepBillFoster      
F000459 Charles Fleischmann F000459 UCTtRrJkM-R-f2K0byCMvHgw repchuck      
F000462 Lois Frankel F000462 UCEk5viAhxaW_2OK20-yBwzQ reploisfrankel reploisfrankel    
F000463 Deb Fischer F000463 UCrbEfZaG_WhB0PBHI1hefPQ senatordebfischer senatorfischer    
F000466 Brian Fitzpatrick F000466 UCYMNcgHss4_Q5JY2vSvMpgw   repbrianfitz    
F000468 Lizzie Fletcher F000468   UCIWDLoDPvawP118TNWi-9rg repfletcher    
F000469 Russ Fulcher F000469   UCx2AS0O5frzPB8D6TqJ3Mqg RepRussFulcher    
F000470 Michelle Fischbach F000470   UCAxs5zhFdAkGbkRnuC3osDw repfischbach    
F000471 Scott Fitzgerald F000471          
F000472 C. Franklin F000472   @RepFranklin RepFranklin    
F000474 Mike Flood F000474          
F000475 Brad Finstad F000475   @repfinstad repfinstad    
F000476 Maxwell Frost F000476     RepMaxwellFrost    
F000477 Valerie Foushee F000477   @RepValerieFoushee repvaleriefoushee    
F000478 Russell Fry F000478   @reprussellfry reprussellfry    
F000479 John Fetterman F000479     senfettermanpa    
F000480 Vince Fong F000480     repvincefong    
F000481 Shomari Figures F000481     repscfigures    
F000482 Julie Fedorchak F000482     RepJulieFedorchak    
F000483 Laura Friedman F000483     RepLauraFriedman    
G000359 Lindsey Graham G000359 UClLGZMA5Ei2Z8fR1PLEx6yQ USSenLindseyGraham      
G000386 Charles Grassley G000386 UCiCPRkcLMInpDeOqGkMTt4w senchuckgrassley senatorchuckgrassley    
G000546 Sam Graves G000546 UCdg2ybvoHsSW6t7iJnKHlNg   repsamgraves    
G000553 Al Green G000553 UCFtgMZm1YUXaZ8OtOj-GDjA RepAlGreen repalgreen    
G000555 Kirsten Gillibrand G000555 UCVEloQogVsmnkd5vxJInmYg KirstenEGillibrand senkirstengillibrand    
G000558 Brett Guthrie G000558 UCdJhDw-YbdH0RHfWK0sIfiw BrettGuthrie repguthrie    
G000559 John Garamendi G000559 UCRym1qsO72C39gX6pBu4icg garamendiCA10 repgaramendi    
G000565 Paul Gosar G000565 UC5orqw_9acsKWSRbrqTDXBw repgosar REPGOSAR    
G000568 H. Griffith G000568 UCzxqD7EY_Rdvbc0spbaYkJA RepMorganGriffith hmorgangriffith    
G000574 Ruben Gallego G000574     reprubengallego    
G000576 Glenn Grothman G000576 UCui4k83Cot4aeVW_8T33fgg   repglenngrothman    
G000581 Vicente Gonzalez G000581 UC5H6oYLKQ_xIXO5CG7fh4hw   repvicentegonzaleztx    
G000583 Josh Gottheimer G000583     RepJoshG    
G000585 Jimmy Gomez G000585   UCOmm091WM6D01xTdzsWNvbQ repjimmygomez    
G000586 Jesús García G000586          
G000587 Sylvia Garcia G000587          
G000589 Lance Gooden G000589   UCaEs0pYlL_1cLlPBHfl0RIg      
G000590 Mark Green G000590   UC5kpqepPIdUNaMtfGb-7MwA repmarkgreen    
G000591 Michael Guest G000591          
G000592 Jared Golden G000592          
G000593 Carlos Gimenez G000593     repcarlosfl    
G000594 Ernest Gonzales G000594          
G000596 Marjorie Greene G000596     repmtg    
G000597 Andrew Garbarino G000597          
G000598 Robert Garcia G000598     RepRobertGarcia    
G000599 Dan Goldman G000599     repdangoldman    
G000600 Marie Gluesenkamp Perez G000600   @repmgp repmgp    
G000601 Craig Goldman G000601     repcraiggoldman    
G000602 Laura Gillen G000602     replauragillen    
G000603 Brandon Gill G000603     repbrandongill    
G000604 Maggie Goodlander G000604     repgoodlander    
G000605 Adam Gray G000605     repadamgrayca    
H000273 John Hickenlooper H000273   UCU6pcq-AZA9wnmIPBj6ePwQ senatorhick    
H000601 Bill Hagerty H000601   UCqLlLx05ScUwxVHvevyaDFg senatorhagerty    

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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,
   [mastodon] TEXT
);