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

Events fields

jpmckinney edited this page Apr 3, 2013 · 3 revisions

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 (participants._chamber also occurs rarely)

Fields on less than 46% of documents

  • country: always us
  • level: always state
  • +chamber: lower, upper, joint or other
  • +agenda
  • participants.+committee_code
  • Related bills
    • related_bills.bill_id: an abbreviation
    • related_bills._scraped_bill_id
    • related_bills.type: bill or consideration (related_bills.+type also occurs rarely)
    • related_bills.description (related_bills.+description also occurs rarely)

Fields on less than 3% of documents

  • _guid
  • _ical_feed: a URL to a vCalendar file
  • all_day: true or false
  • link (+link more rarely)
  • notes: notes about the event, e.g. a notice
  • status: confirmed or canceled (+cancelled more rarely)
  • +contact: contact person for the event, e.g. John Q. Public (555) 555-5555
  • +location_url: a Google Maps URL
  • +media_contact: media contact for the event, e.g. John Q. Public (555) 555-5555
  • sources.retrieved
  • Documents
  • Participants
    • participants.+position_name: either House Facilitator or Senate Facilitator for a single event
  • Related bills
    • related_bills.id