t_changes

518,691 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ApplicationReceived (date), BallotSent (date), BallotReceived (date), prev_ballot_received (date), prev_ballot_sent (date)

Next page

CREATE TABLE t_changes(
  County TEXT,
  Election TEXT,
  VoterID TEXT,
  Status TEXT,
  "Status Reason" TEXT,
  LastName TEXT,
  FirstName TEXT,
  MiddleName TEXT,
  Suffix TEXT,
  YOB TEXT,
  Gender TEXT,
  Party TEXT,
  ResidenceAddress TEXT,
  HouseNumber TEXT,
  PreStreetDir TEXT,
  Street TEXT,
  StreetType TEXT,
  PostStreetDir TEXT,
  City TEXT,
  State TEXT,
  Zip TEXT,
  BallotMailingAddress TEXT,
  "Address Line 2" TEXT,
  BallotMailingCity TEXT,
  BallotMailingState TEXT,
  BallotMailingZip TEXT,
  BallotMailingCountry TEXT,
  "Ballot Style" TEXT,
  Precinct TEXT,
  "Precinct Part" TEXT,
  Congressional TEXT,
  "Public Regulation" TEXT,
  "Education Commission" TEXT,
  Senate TEXT,
  Legislative TEXT,
  Commissioner TEXT,
  Municipal TEXT,
  School TEXT,
  "Absentee Voter Type" TEXT,
  "Application Sent" TEXT,
  ApplicationReceived TEXT,
  "Application Source" TEXT,
  "Application Status" TEXT,
  "Application Rejection Reason" TEXT,
  "Ballot Delivery Method" TEXT,
  BallotSent TEXT,
  BallotReceived TEXT,
  "Ballot Status" TEXT,
  "Ballot Rejection Reason" TEXT,
  "Vote Type" TEXT,
  snapshot_sequence INT,
  source_file TEXT,
  file_type TEXT,
  record_key TEXT,
  prev_sequence,
  prev_ballot_status,
  prev_ballot_received,
  prev_ballot_sent,
  prev_application_status,
  prev_vote_type,
  prev_status,
  prev_ballot_rejection_reason,
  prev_application_rejection_reason
);
CREATE INDEX idx_t_changes_key ON t_changes(record_key);
CREATE INDEX idx_t_changes_voter ON t_changes(VoterID);