social_media
1 row where legislator_id = "B001323"
This data as json, CSV (advanced)
| id ▼ | legislator_id | youtube_id | twitter_id | youtube | instagram_id | mastodon | |||
|---|---|---|---|---|---|---|---|---|---|
| B001323 | B001323 | repnickbegich | RepNickBegich | RepNickBegich |
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,
"mastodon" TEXT
);