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] FLOAT,
   [longitude] FLOAT,
   [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])
)