t_high_density_flagged

22,760 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address Line 2, BallotMailingState, BallotMailingCountry, Congressional, Public Regulation, Education Commission, Senate, Legislative, Commissioner, Municipal, School, Absentee Voter Type, Application Source, Application Status, Application Rejection Reason, Ballot Delivery Method, BallotSent, BallotReceived, Ballot Status, Ballot Rejection Reason, Vote Type, file_type, ApplicationReceived (date), BallotSent (date), BallotReceived (date)

Next page

CREATE TABLE t_high_density_flagged(
  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,
  high_density_flag TEXT
);
CREATE INDEX idx_t_hd_flagged_voter ON t_high_density_flagged(VoterID);