Schema for legislators

CREATE TABLE "legislators" (
   "id" TEXT PRIMARY KEY,
   "name" TEXT,
   "id_bioguide" TEXT,
   "id_govtrack" INTEGER,
   "id_icpsr" INTEGER,
   "id_wikipedia" TEXT,
   "id_wikidata" TEXT,
   "id_google_entity_id" TEXT,
   "name_first" TEXT,
   "name_last" TEXT,
   "bio_birthday" TEXT,
   "bio_gender" TEXT
, "id_house_history" INTEGER, "name_middle" TEXT, "id_ballotpedia" TEXT, "name_nickname" TEXT, "name_suffix" TEXT, "id_bioguide_previous" TEXT, "id_house_history_alternate" INTEGER, "other_names" TEXT, "id_thomas" TEXT, "id_cspan" INTEGER, "id_votesmart" INTEGER, "id_lis" TEXT, "id_fec" TEXT, "name_official_full" TEXT, "id_opensecrets" TEXT, "id_maplight" INTEGER, "leadership_roles" TEXT, "family" TEXT, "id_pictorial" INTEGER);
CREATE TABLE "legislator_terms" (
   "legislator_id" TEXT REFERENCES "legislators"("id"),
   "type" TEXT,
   "state" TEXT,
   "start" TEXT,
   "end" TEXT,
   "class" INTEGER,
   "party" TEXT
, "district" INTEGER, "how" TEXT, "party_affiliations" TEXT, "caucus" TEXT, "url" TEXT, "address" TEXT, "phone" TEXT, "fax" TEXT, "contact_form" TEXT, "office" TEXT, "state_rank" TEXT, "rss_url" TEXT, "end-type" TEXT);
CREATE TABLE "offices" (
   "id" TEXT PRIMARY KEY,
   "legislator_id" TEXT REFERENCES "legislators"("id"),
   "address" TEXT,
   "suite" TEXT,
   "city" TEXT,
   "state" TEXT,
   "zip" TEXT,
   "latitude" REAL,
   "longitude" REAL,
   "fax" TEXT,
   "phone" TEXT,
   "building" TEXT
, "hours" TEXT);
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
);
CREATE TABLE "executives" (
   "id" INTEGER PRIMARY KEY,
   "name" TEXT,
   "id_bioguide" TEXT,
   "id_govtrack" INTEGER,
   "id_icpsr_prez" INTEGER,
   "name_first" TEXT,
   "name_last" TEXT,
   "bio_birthday" TEXT,
   "bio_gender" TEXT
, "id_icpsr" INTEGER, "name_suffix" TEXT, "name_middle" TEXT, "id_thomas" TEXT, "name_nickname" TEXT, "id_lis" TEXT, "id_wikidata" TEXT, "id_wikipedia" TEXT, "id_cspan" INTEGER, "id_opensecrets" TEXT, "id_votesmart" INTEGER, "id_fec" TEXT, "id_google_entity_id" TEXT, "id_ballotpedia" TEXT, "id_house_history" INTEGER, "id_maplight" INTEGER, "name_official_full" TEXT, "id_pictorial" INTEGER);
CREATE TABLE "executive_terms" (
   "type" TEXT,
   "start" TEXT,
   "end" TEXT,
   "party" TEXT,
   "how" TEXT,
   "executive_id" INTEGER REFERENCES "executives"("id")
)