Events fields

Fields that are candidates for elimination are given in bold.

Fields on all documents

• _id: the event ID in the format AKE00000001 where AK is the uppercase jurisdiction ID
• _type: always event
• state: the jurisdiction ID, e.g. ak
• session: the legislative session
• description: a description of the event
• when: the time at which the event begins
• end: the time at which the event ends
• location: the event's location
• type: a code for the type of event, e.g. committee:hearing
• timezone: the event's timezone, e.g. America/Anchorage
• participants
• sources
• Metadata
  • created_at: the time at which the event was created
  • updated_at: the time at which the event was updated

Fields on more than 89% of documents

• documents
• related_bills
• sources.url
• Participants
  • participants.participant_type: committee or legislator
  • participants.id: the committee or legislator ID
  • participants.participant: the committee or legislator name
  • participants.type: chair, host or participant
  • participants.chamber: lower, upper, joint or other

Fields on less than 46% of documents

• country: always us
• level: always state
• +chamber:
• +agenda:
• participants.+committee_code:
• Related bills
  • related_bills.bill_id:
  • related_bills._scraped_bill_id:
  • related_bills.type:
  • related_bills.description:

Fields on less than 3% of documents

• _guid:
• _ical_feed:
• all_day:
• link: (+link more rarely)
• notes:
• status:
• +cancelled:
• +contact:
• +location_url:
• +media_contact:
• sources.retrieved
• Documents
  • documents.url:
  • documents.name:
  • documents.+type:
  • documents.+mimetype:
• Participants
  • participants._chamber:
  • participants.+position_name:
• Related bills
  • related_bills.id:
  • related_bills.+description:
  • related_bills.+type: