Database

Schema

CREATE TABLE "campaign_summary" 
(
  "campaign_id"         INTEGER,
  "summary_level"          TEXT,
  "summary_value"          REAL,
  "summary_type"           TEXT
);

CREATE TABLE "campaign_info" 
(
  "campaign_id"         INTEGER,
  "election_year"       TEXT,
  "election_cycle"      TEXT,
  "candidate_id"        INTEGER,
  "candidate_position"  TEXT,
  "candidate_party"     TEXT
);

CREATE TABLE "candidate_info"
(
  "candidate_id"        INTEGER,
  "candidate_name"      TEXT
);

It's a SQLite DB and lives on our server at /srv/leverage/leverage.sqlite