Legislative Measure Tracking Information Available on the Internet
NOTE: Starting in January, 2013, a new electronic bill book application will be implemented and available on the Legislative Website. The application (OLIS-Oregon Legislative Information System) will run concurrently with the Legislative website for 2013 and will provide centralized information about bills and committees. OLIS will include:
- Measure information including sponsors, measure summary, and amendments.
- Measure analysis, including Staff measure summaries, fiscal impacts and revenue impact statements
- Meeting materials, including proposed amendments, testimony and other exhibits
- Committee Membership
- Committee agendas by meeting date
- Recording logs for Committee meetings
- Committee exhibits
New information not currently on our website include:
- Current committee location of a measure
- Measure history, including committee votes and chamber votes
*************************************************************************************************************
*************************************************************************************************************
As a service to our customers outside of the State Capitol, Legislative Administration is placing a set of four delimited text files on our FTP site. These files, which are in addition to the regular publication documents available on our web site, are set up so they can be easily imported into nearly any database system, spreadsheet application, or word processing table for further searching and formatting of reports. The files can be obtained via anonymous ftp at landru.leg.state.or.us/pub.
The file names are measures.txt, meashistory.txt, meascommeeting.txt, and measthird.txt. The files are updated at approximately 5:30 am the day following each session day and contain the most up-to-date information at that time. The files are created in a text only format, delimited by the character ä (ascii character 132). The first row of each file contains the field names.
A fifth delimited text file is now available, upd_measures.txt. The new file will be updated hourly and will have the same structure as the measures.txt file. By updating this new file hourly, the new bill introductions will be included in the file soon after they are introduced during the day. Therefore, this file will more closely match the content posted to our website, namely the text of all introduced measures in PDF and HTML. Please note, however, that this file will contain some measures which will not yet be in the meashistory.txt file.
For more information on this file format, please contact Rick Butler at rick.l.butler@state.or.us. If you have any other questions, please let me know, Shane Walker, 503.986.1223. If you wish to be on a notification list for updates or changes to these files, please send your email address to shane.walker@state.or.us.
NOTE: The data contained in these files is offered for your convenience, the data is not official until the Final Status Report is available after session.
The files are set up in the following format:
MEASURES.TXT |
||
| Field Name |
Description |
Type |
| Meas_Prefix |
HB, SB, HJR, HJM, HCR, HM, SJR, SJM, SCR, SM, |
Char(3) |
| Comp_Key |
Primary key field which can be used to link the three files Consists of: prefix(3 chars), number(4 chars), session identifier(1 char) e.g.: HB 20510 Session Identifier: 0 - regular session, 1 - first special session , 2 - second special session, etc. |
Char(8) |
| Meas_Number |
0001, 2069 |
Smallint |
| Catch_Line |
The first sentence of the measure summary. |
Long VarChar (up to 32,767 chars) |
| Relating_to |
Relating to clause specified in the measure. |
Long VarChar (up to 32,767 chars) |
MEASHISTORY.TXT |
||
| Field Name |
Example |
Type |
| Comp_Key |
Foreign Key to Measures.txt (see description above) |
Char(8) |
| Meas_Prefix |
See above |
Char(3) |
| Meas_Number |
See above |
Smallint |
| House_Of_Action |
J - Joint, S - Senate, H - House |
Char(1) |
| Action_Date |
Date specified action occurred on (01/11/1999) |
Date |
| Action_Time |
Time specified action occurred (13:00:00) |
Time |
| Action_Text |
Action description (e.g. First reading. Referred to Speaker's desk.) |
Long VarChar (up to 32,767 chars) |
MEASCOMMEETING.TXT |
||
| Field Name |
Example |
Type |
| Commit_Type |
Type of committee (see possible values below) |
Char(2) |
| Commit_Name_Uppercse |
Actual committee name in uppercase |
Char(100) |
| Measure_Prefix |
See above |
Char(3) |
| Measure_Number |
See above |
Smallint |
| Meeting_Type |
Type of meeting (see possible values below) |
Char(3) |
| Meeting_Date |
Date of meeting, can be past, present or future (1/21/1999) |
Date |
| Meeting_Time |
Time of meeting (13:00:00) |
Time |
| Meeting_Location |
Hearing room where meeting is or was held (HR C) |
Char(4) |
| Comp_key |
Foreign Key to Measures.txt (see description above) |
Char(8) |
| Agenda_Item_No |
Determines sequence of agenda items in a particular meeting (e.g. 05, 10) |
Smallint |
|
MEASTHIRD.TXT |
||
| Field Name | Description | Type |
| Date | Date of Third Reading | Char(18) |
| Chamber | House or Senate | Char(6) |
| Order of Business | The Senate and the House of Representatives have specific 'orders of business' set forth by their Senate and House rules which they must follow each floor session. Each order of business has its own set of rules (whether or not a bill is assigned to it; how long a member may speak under it; etc.). The orders of business are in a specific order and all bills must follow the order throughout their life cycle in the legislative process unless a rules suspension is allowed. | Char(60) |
| Measure_Prefix | HB, SB, HJR, HJM, HCR, HM, SJR, SJM, SCR, SM | Char(3) |
| Measure_Number | 0001, 2069 | Smallint |
| Version | A, B, C (blank = intro) | char(1) |
| Carrier | Last Name of Member who will carry the measure for the third reading | Char(30) |
| Comp_key | Foreign Key to measures.txt (see description above) | Char(8) |
COMMIT_TYPE CODES |
|
| Code |
Value |
| S |
Senate Committee |
| SS |
Senate Subcommittee |
| SC |
Senate Conference Committee |
| SX |
Senate Special Committee |
| H |
House Committee |
| HS |
House Subcommittee |
| HC |
House Conference Committee |
| HX |
House Special Committee |
| J |
Joint Committee |
| JS |
Joint Subcommittee |
| JX |
Joint Special Committee |
MEETING_TYPE CODES |
|
Code |
Value |
PUB |
Public Hearing |
PAW |
Public Hearing and Work Session |
INF |
Informational Meeting |
ORG |
Organizational Meeting |
PPW |
Public Hearing and Possible Work Session |
PRW |
Possible Reconsideration and Work Session |
WGR |
Work Group |
WRK |
Work Session |
ORI |
Orientation Meeting |
FLD |
Field Trip |
PUM |
Public Meeting |
AHW |
Adhoc Work Group |
EXA |
Executive Appointment |
EXS |
Executive Appointments |
ERA |
Executive Reappointment |
ERS |
Executive Reappointments |
JWM |
Informational Meeting |
| PWK | Possible Work Session |
Contact information and answers to frequently asked questions about the legislature, legislative process other government agencies. The staff of the Oregon Legislature cannot respond to public requests for legal advice. To understand and protect your legal rights, consult your private lawyer. |
