votes table:
legislator_name, year, bill_number, bill_title, prime_sponsor, vote (YEA/NAY), result (PASSED/FAILED), bill_id (year_bill_number)
legislators table:
name, chamber, party (D/R), district
Note: Always use bill_id for joins or filter by both year AND bill_number. Bill numbers are not unique across sessions.