snapshot_records

21,296,447 rows

✎ View and edit SQL

This data as json, CSV (advanced)

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

Next page

CREATE TABLE snapshot_records (
            "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 INTEGER NOT NULL,
            source_file TEXT NOT NULL,
            file_type TEXT NOT NULL,
            record_key TEXT NOT NULL
        , high_density_flag TEXT);
CREATE INDEX idx_record_key ON snapshot_records(record_key);
CREATE INDEX idx_snapshot_seq ON snapshot_records(snapshot_sequence);
CREATE INDEX idx_voterid ON snapshot_records(VoterID);
CREATE INDEX idx_key_seq ON snapshot_records(record_key, snapshot_sequence);
CREATE INDEX idx_record_key_seq ON snapshot_records(record_key, snapshot_sequence);