social_media

1 row where legislator_id = "B001292"

Clear filters
View and edit SQL
social_media

Filtered rows where legislator_id = "B001292"

TSV All 1 row
Tab-separated values, for pasting into Excel or Google Sheets
CSV All 1 row
Comma-separated values, for spreadsheets and other tools
  • JSON All 1 row
    Rows inside an object, with extra details
    View Download
  • JSON array All 1 row
    Just the rows, as an array of objects
    View Download
  • Newline-delimited JSON All 1 row
    One JSON object per line
    View Download
  • JSON object All 1 row
    Rows keyed by their primary key
    View Download

id ▼ legislator_id youtube_id youtube instagram instagram_id mastodon
B001292 B001292 UCPJGVbOVcAVGiBwq8qr_T9w   repdonbeyer   @RepDonBeyer@mas.to
Table schema 
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
);