social_media
1 row where legislator_id = "B001260"
This data as json, CSV (advanced)
| id ▼ | legislator_id | youtube_id | twitter_id | youtube | instagram_id | mastodon | |||
|---|---|---|---|---|---|---|---|---|---|
| B001260 | B001260 | VernBuchanan | CongressmanBuchanan | UCY4DEy41NxOTdcF8_XAVZvw | 20467163 | vernbuchanan | repvern | 344865327 |
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
);