social_media
1 row where legislator_id = "C001069"
This data as json, CSV (advanced)
| id ▼ | legislator_id | youtube_id | twitter_id | youtube | instagram_id | mastodon | |||
|---|---|---|---|---|---|---|---|---|---|
| C001069 | C001069 | RepJoeCourtney | joecourtney | UCGVIfe1T2hO1Lx7ap5Wkv1w | 85396297 | repcourtney | repjoecourtney |
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
);