social_media
1 row where legislator_id = "C001080"
This data as json, CSV (advanced)
| id ▼ | legislator_id | youtube_id | twitter_id | youtube | instagram_id | mastodon | |||
|---|---|---|---|---|---|---|---|---|---|
| C001080 | C001080 | RepJudyChu | RepJudyChu | UCfcbYOvdEXZNelM8T05nK-w | 193732179 | RepJudyChu | repjudychu |
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
);