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

Bills fields

jpmckinney edited this page Apr 19, 2013 · 28 revisions

Fields that are candidates for elimination are given in bold.

Fields on all documents

  • _id: the bill ID in the format AKB00000001 where AK is the uppercase jurisdiction ID
  • _all_ids: all IDs of merged documents plus this document's _id
  • _type: always bill
  • type: a list describing the type of document, e.g. appointment
  • bill_id: an abbreviation
  • documents
  • sponsors
  • versions
  • Hierarchy
    • state: the jurisdiction ID, e.g. ak
    • chamber: lower or upper
    • _term: why the underscore?
    • session
  • Title
    • title
    • alternate_titles (+extended_title, +official_title and +short_title also occur rarely)
  • Actions
    • actions
    • action_dates
    • action_dates.first: the date on which the first action was taken
    • action_dates.last: the date on which an action was most recently taken
    • action_dates.passed_lower
    • action_dates.passed_upper
    • action_dates.signed
  • Sources
    • sources
    • sources.url
  • Metadata
    • created_at
    • updated_at

Fields on more than 97% of documents

  • _current_term: true or false
  • _current_session: true or false
  • subjects (+subject also occurs rarely)
  • Actions
    • actions.type: the types of action taken, e.g. bill:introduced
    • actions.date: the date on which the action was taken
    • actions.action: the description of the action
    • actions.actor: executive or other or begins with lower or upper
  • Sponsors
    • sponsors.leg_id: the legislator ID
    • sponsors.type: primary or cosponsor
    • sponsors.name: the sponsor's name, often only the last name
  • Versions

Fields on more than 3% of documents

  • country: always us
  • level: always state
  • scraped_subjects
  • summary
  • Actions
    • actions.related_entities
    • actions.related_entities.type: committee or legislator
    • actions.related_entities.id: the committee or legislator ID
    • actions.related_entities.name: the committee or legislator name
    • actions.related_votes
    • actions.committee: the committee ID
    • actions._scraped_committee_name: the native committee name
    • actions.+action_number (actions.+action_num more rarely)
  • Companions: Although most bills have at most one companion, in NY this is not the case
    • companions: a bill has up to three companion bills (+companion more rarely)
    • companions.chamber: always null, but lower, upper or null according to schema
    • companions.session
    • companions.bill_id: an abbreviation
    • companions.internal_id: a bill ID
  • Documents
    • documents.doc_id: the document ID in the format AKD00000001 where AK is the uppercase jurisdiction ID, which refers to a private S3 URL
    • documents.url (documents.+source more rarely)
    • documents.name
  • Sources
    • sources.retrieved
  • Sponsors
    • sponsors.chamber: lower or upper
    • sponsors.official_type: the native type, e.g. P as opposed to primary
    • sponsors.+main_sponsor_url (sponsors.+sponsor_link more rarely)
  • Versions
    • versions._oyster_id

Fields on less than 3% of documents

  • _guid
  • alternate_bill_ids (+alternate_bill_ids more rarely)
  • +companion_bill_ids
  • +referral
  • +status
  • +impact_clause
  • +type_
  • +final_disposition
  • +bill_lr
  • +description
  • +requester
  • +drafter
  • +fiscal_notes
  • +by_request_of
  • +chapter and +volume_chapter
  • Colon fields?
    • +bill_draft_number:
    • +category:
    • +fiscal_note_probable:
    • +preintroduction_required:
    • +transmittal_date:
  • Actions
    • actions._vote_id
    • actions._code_id
    • actions._code
    • actions.+abbrv
    • actions.+absent_voters (actions.+absent more rarely)
    • actions.+actor_info
    • actions.+actor_info.details
    • actions.+actor_info.committee_code
    • actions.+amendment
    • actions.+assigned_ctty
    • actions.+bill_id
    • actions.+bills
    • actions.+brief_action_name
    • actions.+chapter
    • actions.+chaptered_version
    • actions.+comment
    • actions.+concur
    • actions.+day
    • actions.+effective_date
    • actions.+excused_voters (actions.+excused more rarely)
    • actions.+from_committee
    • actions.+no_votes
    • actions.+not_voting
    • actions.+pass_fail
    • actions.+session_laws
    • actions.+signed_chamber
    • actions.+vacant
    • actions.+version
    • actions.+veto_memo
    • actions.+vote_threshold
    • actions.+yes_votes
  • Documents
    • documents.mimetype
    • documents.+date
    • documents.+type
  • Sponsors
    • sponsors.committee_id: a sponsor may be a committee or a person
    • sponsors._code
    • sponsors.+leg_url
  • Versions
    • versions._version_id
    • versions._internal_document_id
    • versions.+date
  • +conference_committee (conference_committee more rarely)
    • +conference_committee. lower (conference_committee.lower more rarely)
    • +conference_committee. upper (conference_committee.upper more rarely)