member_votes

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

8,387,712 rows sorted by congress descending

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: vote_cast

Next page

CREATE TABLE member_votes (
    congress INTEGER NOT NULL,
    chamber TEXT NOT NULL,
    session INTEGER NOT NULL,
    roll_call_number INTEGER NOT NULL,
    bioguide_id TEXT,
    member_name TEXT,
    party TEXT,
    state TEXT,
    vote_cast TEXT,
    FOREIGN KEY (congress, chamber, session, roll_call_number)
        REFERENCES roll_call_votes(congress, chamber, session, roll_call_number)
);
CREATE INDEX idx_mv_bioguide ON member_votes(bioguide_id);
CREATE INDEX idx_mv_vote ON member_votes(congress, chamber, session, roll_call_number);
CREATE INDEX idx_mv_party ON member_votes(party);