social_media

1 row where legislator_id = "A000375"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ legislator_id youtube_id youtube instagram instagram_id mastodon
A000375 A000375   UC3lif8TFPOe-tJ2-pE4Rp7Q repjodeyarrington    

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