social_media

Table actions Table actions

519 rows

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ legislator_id youtube_id youtube instagram instagram_id mastodon
C001126 C001126   @congressmanmikecarey      
C001129 C001129     repmikecollins    
C001130 C001130     RepJasmine    
C001131 C001131     RepCasar    
C001132 C001132   @rep.elicrane      
C001133 C001133   UCD329AYGX7YnMMSUaTKWHwA repjuanciscomani    
C001136 C001136          
C001137 C001137     repjeffcrank    
D000032 D000032   UCjy0W7sksMz37IYY27tAZNQ byrondonalds    
D000096 D000096 UCdhrT09_XMr31tuI8OcKsjQ dannykdavis07      
D000197 D000197 UCWFQCRTHwsHg9P1Hf-EQtew RepDianaDeGette      
D000216 D000216 UC9ROfGBm7kSLCEDYwFF6McQ rosadelauro      
D000230 D000230     RepDonDavis    
D000399 D000399 UCN-kiLKyHPcfRVZ28sAHS_g doggett replloyddoggett    
D000530 D000530     RepDeluzio    
D000563 D000563 UCkbixlNCxcKAffEhe3X5-lw SenatorDurbin      
D000594 D000594   @RepMonicaDLC RepMonicaDLC    
D000600 D000600 UCpEEd0Plxx5D78pI4a4mFTQ MarioDiazBalart repmariodb 316477657  
D000616 D000616 UCvjuSLoi3hS0ECQvJLhwOkA ScottDesJarlaisTN04 desjarlaistn04 260930821  
D000617 D000617 UCd00b7TpKDZIr-Ujhaktvjg   repdelbene    
D000618 D000618 UC-ny-W5mEUGytiyMdXbQ20Q SteveDainesMT stevedaines 371125857  
D000622 D000622 UCYRWRvUxtjaHnFMCbdd94tg repduckworth SenDuckworth 1387939090  
D000623 D000623     repdesaulnier    
D000624 D000624 UCnoP3KLT-HOvzDfC1-I-9lQ   repdingell    
D000626 D000626 UCMzuyZWzk44YRNesFzPTeUw   instawarrendavidson    
D000628 D000628 UCRTGfrYP-RuDzJ2KGok7TRA        
D000629 D000629          
D000631 D000631   UCHj4veUyhPzzOW-Jvn7MqUg repmadeleinedean    
D000634 D000634     reptroydowning    
D000635 D000635     repdexteror    
E000071 E000071          
E000235 E000235   UCseRXy2_n4j97lndfkQ_hAw repmikeezell    
E000246 E000246     repchuckedwards    
E000294 E000294   RepTomEmmer reptomemmer 1565640999  
E000295 E000295 UCLwrmtF_84FIcK3TyMs4MIw   senjoniernst 1582702853  
E000296 E000296     repdwightevans    
E000297 E000297 UCi0niBYFhEY70Dz8InbX5OQ   repadrianoespaillat    
E000298 E000298 UC2clc28qcehIqotHQcthnWA   RepRonEstes    
E000299 E000299   UC46TX2P8K0CA_4gZv8_R2Og repescobar    
E000300 E000300     RepGabeEvans    
E000301 E000301     RepSarahElfreth    
F000110 F000110     repcleofields_    
F000246 F000246   RepPatFallon RepPatFallon    
F000446 F000446          
F000450 F000450 UCggineJcxJn80TRXxdQbx6w repvirginiafoxx repvirginiafoxx    
F000454 F000454 UCicixINQr_-3cFHI2bJzFpQ RepBillFoster      
F000459 F000459 UCTtRrJkM-R-f2K0byCMvHgw repchuck      
F000462 F000462 UCEk5viAhxaW_2OK20-yBwzQ reploisfrankel reploisfrankel    
F000463 F000463 UCrbEfZaG_WhB0PBHI1hefPQ senatordebfischer senatorfischer    
F000466 F000466 UCYMNcgHss4_Q5JY2vSvMpgw   repbrianfitz    
F000468 F000468   UCIWDLoDPvawP118TNWi-9rg repfletcher    
F000469 F000469   UCx2AS0O5frzPB8D6TqJ3Mqg RepRussFulcher    
F000470 F000470   UCAxs5zhFdAkGbkRnuC3osDw repfischbach    
F000471 F000471          
F000472 F000472   @RepFranklin RepFranklin    
F000474 F000474          
F000475 F000475   @repfinstad repfinstad    
F000476 F000476     RepMaxwellFrost    
F000477 F000477   @RepValerieFoushee repvaleriefoushee    
F000478 F000478   @reprussellfry reprussellfry    
F000479 F000479     senfettermanpa    
F000480 F000480     repvincefong    
F000481 F000481     repscfigures    
F000482 F000482     RepJulieFedorchak    
F000483 F000483     RepLauraFriedman    
G000359 G000359 UClLGZMA5Ei2Z8fR1PLEx6yQ USSenLindseyGraham      
G000386 G000386 UCiCPRkcLMInpDeOqGkMTt4w senchuckgrassley senatorchuckgrassley    
G000546 G000546 UCdg2ybvoHsSW6t7iJnKHlNg   repsamgraves    
G000553 G000553 UCFtgMZm1YUXaZ8OtOj-GDjA RepAlGreen repalgreen    
G000555 G000555 UCVEloQogVsmnkd5vxJInmYg KirstenEGillibrand senkirstengillibrand    
G000558 G000558 UCdJhDw-YbdH0RHfWK0sIfiw BrettGuthrie repguthrie    
G000559 G000559 UCRym1qsO72C39gX6pBu4icg garamendiCA10 repgaramendi    
G000565 G000565 UC5orqw_9acsKWSRbrqTDXBw repgosar REPGOSAR    
G000568 G000568 UCzxqD7EY_Rdvbc0spbaYkJA RepMorganGriffith hmorgangriffith    
G000574 G000574     reprubengallego    
G000576 G000576 UCui4k83Cot4aeVW_8T33fgg   repglenngrothman    
G000581 G000581 UC5H6oYLKQ_xIXO5CG7fh4hw   repvicentegonzaleztx    
G000583 G000583     RepJoshG    
G000585 G000585   UCOmm091WM6D01xTdzsWNvbQ repjimmygomez    
G000586 G000586          
G000587 G000587          
G000589 G000589   UCaEs0pYlL_1cLlPBHfl0RIg      
G000591 G000591          
G000592 G000592          
G000593 G000593     repcarlosfl    
G000597 G000597          
G000598 G000598     RepRobertGarcia    
G000599 G000599     repdangoldman    
G000600 G000600   @repmgp repmgp    
G000601 G000601     repcraiggoldman    
G000602 G000602     replauragillen    
G000603 G000603     repbrandongill    
G000604 G000604     repgoodlander    
G000605 G000605     repadamgrayca    
H000273 H000273   UCU6pcq-AZA9wnmIPBj6ePwQ senatorhick    
H000601 H000601   UCqLlLx05ScUwxVHvevyaDFg senatorhagerty    
H000874 H000874 UCvxgqX65cdhHNjJn64cgY9g LeaderHoyer repstenyhoyer 51616645  
H001042 H001042 UCcoKhxad156flzPYJ8JMFOA CongresswomanHirono maziehirono 304094084  
H001046 H001046 UCBxh8IK5sMxY0Ln_0G2NYcg SenMartinHeinrich senatormartinheinrich 285288987  
H001047 H001047 UCCeB6czh6nhCHxOMCk_V4yA congressmanhimes repjimhimes   @RepJimHimes@mastodon.social

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
);