home / legislators / social_media

Menu
  • GraphQL API

social_media

Table actions Table actions
  • GraphQL API for social_media

1 row where legislator_id = "C001069"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ legislator_id twitter facebook youtube_id twitter_id youtube instagram instagram_id mastodon
C001069 C001069 RepJoeCourtney joecourtney UCGVIfe1T2hO1Lx7ap5Wkv1w 85396297 repcourtney repjoecourtney    

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
);
Powered by Datasette · How this site works · Code of conduct