home

nm_absentee_2026

Custom SQL query

Tables

snapshot_records

County, Election, VoterID, Status, Status Reason, LastName, FirstName, MiddleName, Suffix, YOB, Gender, Party, ResidenceAddress, HouseNumber, PreStreetDir, Street, StreetType, PostStreetDir, City, State, Zip, BallotMailingAddress, Address Line 2, BallotMailingCity, BallotMailingState, BallotMailingZip, BallotMailingCountry, Ballot Style, Precinct, Precinct Part, Congressional, Public Regulation, Education Commission, Senate, Legislative, Commissioner, Municipal, School, Absentee Voter Type, Application Sent, ApplicationReceived, Application Source, Application Status, Application Rejection Reason, Ballot Delivery Method, BallotSent, BallotReceived, Ballot Status, Ballot Rejection Reason, Vote Type, snapshot_sequence, source_file, file_type, record_key, high_density_flag

Many rows

snapshots

snapshot_sequence, source_file, file_type, row_count, loaded_at

80 rows

t_changes

County, Election, VoterID, Status, Status Reason, LastName, FirstName, MiddleName, Suffix, YOB, Gender, Party, ResidenceAddress, HouseNumber, PreStreetDir, Street, StreetType, PostStreetDir, City, State, Zip, BallotMailingAddress, Address Line 2, BallotMailingCity, BallotMailingState, BallotMailingZip, BallotMailingCountry, Ballot Style, Precinct, Precinct Part, Congressional, Public Regulation, Education Commission, Senate, Legislative, Commissioner, Municipal, School, Absentee Voter Type, Application Sent, ApplicationReceived, Application Source, Application Status, Application Rejection Reason, Ballot Delivery Method, BallotSent, BallotReceived, Ballot Status, Ballot Rejection Reason, Vote Type, snapshot_sequence, source_file, file_type, record_key, 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

518,691 rows

t_first_appearance

record_key, first_sequence, first_source_file, first_file_type, total_appearances, first_seen_seq, last_seen_seq

Many rows

t_high_density_addresses

VoterID, ResidenceAddress, voter_count, LastName, FirstName, MiddleName, YOB, Gender, Party, City, State, Zip

1,514 rows

t_high_density_flagged

County, Election, VoterID, Status, Status Reason, LastName, FirstName, MiddleName, Suffix, YOB, Gender, Party, ResidenceAddress, HouseNumber, PreStreetDir, Street, StreetType, PostStreetDir, City, State, Zip, BallotMailingAddress, Address Line 2, BallotMailingCity, BallotMailingState, BallotMailingZip, BallotMailingCountry, Ballot Style, Precinct, Precinct Part, Congressional, Public Regulation, Education Commission, Senate, Legislative, Commissioner, Municipal, School, Absentee Voter Type, Application Sent, ApplicationReceived, Application Source, Application Status, Application Rejection Reason, Ballot Delivery Method, BallotSent, BallotReceived, Ballot Status, Ballot Rejection Reason, Vote Type, snapshot_sequence, source_file, file_type, record_key, high_density_flag

22,760 rows

t_multi_ballot_voters

VoterID, distinct_keys, distinct_received_dates, distinct_vote_types, vote_types, activity_rows, first_activity_seq, last_activity_seq, early_and_day_of

135 rows

... and 1 hidden table

Powered by Datasette · Queries took 123.221ms