Skip to content
This repository has been archived by the owner on Feb 1, 2020. It is now read-only.

Votes fields

jpmckinney edited this page Mar 7, 2013 · 8 revisions

Fields that are candidates for elimination are given in bold.

Fields on all documents

  • _id: the vote ID in the format AKV00000001 where AK is the uppercase jurisdiction ID
  • _type: always vote
  • Hierarchy
  • vote_id: same as _id
  • bill_id: the bill ID in the format AKB00000001
  • motion: the text of the motion on which legislators are voting
  • date: the date on which the vote was taken
  • _voters: the IDs of legislators who voted
  • passed: a boolean indicating whether the vote passed
  • yes_count: the number of "yes" votes
  • yes_votes: the legislators voting "yes"
  • no_count: the number of "no" votes
  • no_votes: the legislators voting "no"
  • other_count: the number of "other" votes
  • other_votes: the legislators voting "other"
  • sources

Fields on more than 33% of documents

The yes_votes, no_votes and other_votes fields are arrays of objects whose keys are:

  • leg_id: the legislator ID
  • name: the legislator's name, often in "Last name, First name" format

Fields on more than 10% of documents

  • +threshold: 1/2 or 2/3 (+vote_type also occurs rarely, see below)
  • committee_id: the committee ID
  • committee: the committee name

Fields on less than 7% of documents

  • _vote_id: an identifier used by the legislature for the vote (+filename, +record and record more rarely)
  • bill_chamber: lower or upper
  • sources.retrieved
  • +action: a description of the action relating to the vote
  • +actual_vote: what is this for?
  • +amended: Y or the empty string ("")
  • +bill_id: the bill's abbreviation
  • +bill_session: the bill's session always equal to the vote's session, although sometimes expressed in YY format
  • +country: always us
  • +EMER: E or W/O what does this mean?
  • +level: always state
  • +location: always the empty string ("")
  • +method: record or viva voce (method more rarely, see also +voice_vote)
  • +moved: the name of the legislator who moved the motion, often only the last name
  • +rcs_num: Revision Control System (RCS) number?
  • +seconded: the name of the legislator who seconded the motion, often only the last name
  • +voice_vote: a boolean indicating whether it was a voice vote
  • +vote_type: the type of vote, e.g.
    • Two-Thirds Majority or (2/3)
    • Three-Fifths Majority or (3/5)
    • Three-Fourths Majority or (3/4)
    • SM (simple majority?)
    • Voice
  • +other_vote_detail
    • +other_vote_detail.A: the names of absent legislators
    • +other_vote_detail.E: the names of excused legislators
    • +other_vote_detail.NV: the names of legislators who are not voting
    • +other_vote_detail.P: the names of present legislators
  • Other types of votes
    • +absent: the number of absent legislators
    • +AB: the names of absent legislators
    • +excused: the number of excused legislators
    • +E: the names of excused legislators (+EXC more rarely)
    • +not_voting: the number of legislators who are not voting
    • +NV: the names of legislators who are not voting
    • +present: the number of present legislators
    • +P: the names of present legislators
    • +vacant: the number of vacant legislators
    • +V: the names of vacant legislators
    • +skip_votes: the names of legislators who skipped the vote