Legislators fields

Fields that are candidates for elimination are given in bold.

Fields on all documents

• _id: the person ID in the format AKL000001 where AK is the uppercase jurisdiction ID
• _all_ids: all IDs of merged documents plus this document's _id
• _type: always person
• _scraped_name: mostly same as full_name
• leg_id: same as _id
• active: true or false, whether the legislator has any roles
• Jurisdiction
  • state: the jurisdiction ID, e.g. ak
• Name
  • full_name
  • first_name
  • middle_name: mostly ""
  • last_name
  • suffixes: mostly "" (suffix or +suffix also occur rarely)
• Roles
  • roles: may be an empty array
• Offices
  • offices (+capitol_office and +district_offices – with subfields street, city, zip and phone – also occur rarely)
• URLs
  • sources
  • sources.url
• Metadata
  • created_at
  • updated_at

Fields on more than half of documents

• email (+email and +email_address also occur rarely)
• Jurisdiction
  • country: always us
  • level: always state
  • chamber
  • district: if the legislator is active (+district, +disctict_name and +district_name also occur rarely)
  • party: if the legislator is active (+party also occurs rarely)
• Roles
  • roles.type
  • roles.state
  • roles.chamber: lower, upper or joint
  • roles.district
  • roles.term
  • roles.party
  • roles.start_date
  • roles.end_date
  • roles.committee
  • roles.committee_id
  • roles.position
  • roles.subcommittee
  • old_roles
• Offices
  • offices.type: capitol or district
  • offices.name
  • offices.address (office_address occurs in about 1 in 7 documents) (+address, +capital_address, +capitol_address, +city, +county, +district_address, +full_address, +office, +office_address, +office_loc, +room, +zip and +zipcode also occur rarely)
  • offices.phone (office_phone occurs in about 1 in 5 and +phone in about 1 in 7 documents) (+bis_phone, +business_phone, +capital_phone, +capitol_phone, +district_phone, +home_phone, +office_phone, offices.+cellphone, offices.+home_phone, +other_phone and +phone_number also occur rarely)
  • offices.fax: mostly null (+fax, +fax_number and +office_fax also occur rarely)
  • offices.email: mostly null
• URLs
  • url: (+additional_info_url, +leg_url, offices.+url, +url and +website also occur rarely)
  • photo_url (+photo, +image_url and +img_url also occur rarely)
• Crosswalk IDs
  • transparencydata_id: see _contributions_start_year, _total_contributions and _yearly_contributions
  • votesmart_id
• Internal
  • _locked_fields

Fields on less than 15% of documents

• csrfmiddlewaretoken
• +biography
• +end_date
• +gender: Male or Female
• +leg_status: Active, Deceased or Resigned
• +legal_position
• +notice (+notice more rarely)
• +occupation (occupation and +profession more rarely)
• +org_info
• +resident_county
• +role
• +start_year
• +sworn_in_date
• +town_represented
• Name
  • nickname: mostly ""
  • +title: always ""
• Roles
  • roles.country: always us
  • roles.level: always state
  • roles.other_parties
• URLs
  • sources.retrieved
  • sources.+page: a note describing the link
  • +contact_form
  • +facebook_url
• Crosswalk IDs
  • nimsp_id (not maintained, redundant with transparencydata_id)
  • nimsp_candidate_id (not maintained, redundant with transparencydata_id)
  • +oregon_member_id
• Internal?
  • _code
  • _guid