ORPIN: If you want to “Follow the Money”

“Deep Throat” famously told Woodward and Bernstein that if they wanted to get to the bottom of the developing Watergate story, they should “Follow the Money.” In Oregon, a significant share of the public contracting is reported through a system called ORPIN.

Below is a top-level summary on ORPIN, with links, on the page linked from the Oregon Transparency website.

There’s no explanation why the data is so old and has not been updated for 2015 yet, but for the citizen who wants to investigate further into Oregon governmental doings, this is still a great data mine to start with, if only to acquaint you with the data streams that you should be able to access with a little persistence.

ORPIN – Contracts Report as of June 30, 2014

ORPIN Contracts Report

The State Procurement Office in the Department of Administrative Services (DAS) is the central procurement authority for those state agencies that are subject to DAS authority. The office develops, establishes and administers statewide contracts for goods and services on behalf of state government and Oregon Cooperative Procurement Program (ORCPP) members. The reports and descriptions listed below reflect the diversity of the environment in state government contracting and procurement.

State law gives many agencies authority to enter into contracts outside the State Procurement Office. Examples include the Oregon Lottery, Oregon Judicial Department, Oregon Department of Transportation, and the Oregon University System.

This report provides information on contracts and amendments to contracts issued from July 1, 2013 – June 30, 2014, for state agencies who are subject to DAS contracting authority. These agencies must report their contracting activity through the Oregon Procurement Information Network (ORPIN) system. The contract values reflected in this report are estimates.

Note: This report may not include contract information for the Oregon Judicial Department, Oregon State Lottery, Oregon University System, Oregon State Treasurer, or semi-independent state agencies, boards, and commissions. Some executive branch agencies have independent contracting authority for specific goods and services (e.g., Transportation, Secretary of State, State Treasurer, Human Services, Fish and Wildlife, Parks and Recreation, Aviation, Economic and Community Development, Housing, Corrections, Veterans Affairs, Military, Education, and state agencies “specifically authorized” by any law outside the Code to “enter into a contract”). Thus, the ORPIN system may not capture contract information about those activities.

ODOT ORPIN Contract Report
This ORPIN report provides information on some contracts and amendments issued for ODOT from July 1, 2013 – June 30, 2014. The contract values reflected in the report are estimates only.

Due to ODOT’s independent contracting authority, and associated independent systems for capturing contract information, ORPIN may not reflect data for some of the following types of contracting:

  • Purchases made by Purchase Order (under $75,000)
  • Work Order Contracts issued against price agreements not originally recorded in ORPIN
  • SB 338 Go Oregon! (less than $50,000)
  • Highway Construction Contracting

Click here for more information about the Oregon Procurement Information Network (ORPIN) and Database.  
There are two levels of access to ORPIN: “Anonymous Browser” and “Subscription”. “Anonymous” provides access to summary information while “Subscription” provides the user theability to view and download detailed contract information for current and expired contracts. (Note: In previous years, ORPIN had a fee for the “Subscription” access. There is no longer a fee for this.)

ORPIN Contracts Report as of June 30, 2014
Click on the following link to view or download a .csv file of this data. 
ORPIN Contracts Report (.csv)

Note: CSV stands for comma-separated values and may also be referred to as character-separated values. The CSV format is beneficial as it can be read by any spreadsheet program. As it is a plain text file, it can also be read by word processors or simple notepad programs.
 
ORPIN – Contracts Report (Data Viewer)

This will open up a new window and redirect you to the data.oregon.gov website, where you will be able to use a wide range of tools to visualize and download data, or create graphs and maps, or filter data, etc.  
 
Contracts: ORPIN: As of June 30, 2014

Data Viewer – Additional Guidelines
For more views of the data, to download the file in various formats, or to print the data, click on MENU in the top right hand corner of the viewer. You may also select “Discuss this Dataset” via the MENU and leave comments about the data.

(Note: See the data.oregon.gov data moderation policy prior to leaving comments.)
         
The data stored on data.oregon.gov is powered by the Socrata platform. You can find additional resources on how to use the platform to socialize data by visiting the Socrata Knowledge Base and Community Forums.  

ODOT – Highway Construction Contract Awards Report

ODOT – Highway Construction Contract Awards Report as of June 30, 2014
These reports provide information on Highway Construction contracts issued through ODOT-specific contracting authority, during the period of July 1, 2013 – June 30, 2014, for the Oregon Department of Transportation. The contract values in this report are amounts awarded to the contractor at the time of bid; they do not reflect final contract price or possible change orders issued after award.
Click here for: Information about contracting with ODOT.
 
To view or download a .csv file of this data, click on the following link.
ODOT – Highway Construction Contract Awards Report (.csv)

Note: CSV stands for comma-separated values and may also be referred to as character-separated values. The CSV format is beneficial as it can be read by any spreadsheet program. As it is a plain text file, it can also be read by word processors or simple notepad programs.
______________________________________________________________ 
 
Construction: Contracts: ODOT: FY 2014
 
Data Viewer – Additional Guidelines
For more views of the data, to download the file in various formats, or to print the data, click on MENU in the top right hand corner of the viewer. You may also select “Discuss this Dataset” via the MENU and leave comments about the data.
(Note: See the data.oregon.gov data moderation policy prior to leaving comments.)
         
The data stored on data.oregon.gov is powered by the Socrata platform. You can find additional resources on how to use the platform to socialize data by visiting the Socrata Knowledge Base and Community Forums.

Lottery Commission – Contract Activity

This report contains a list of all contracts and contract amendments executed by Lottery during the period July 1, 2013 through June 30, 2014 with a value greater than $5,000. The data was extracted from Lottery’s financial/procurement system, Microsoft Dynamics AX.

Lottery categorizes its procurements as either “Goods”, “Services”, or “Interagency/ Interstate/Intergovernmental”.  The dollar values in this report represent the total not-to-exceed amount of the contract and not what was actually paid to the contractor.
Click on the following link to view or download a .csv file of this data. 
Contracts: Oregon Lottery Commission: Fiscal Year 2014 (.csv) 

Note: CSV stands for comma-separated values and may also be referred to as character-separated values. The CSV format is beneficial as it can be read by any spreadsheet program. As it is a plain text file, it can also be read by word processors or simple notepad programs.

Data Viewer – Guidelines
Clicking on the link above will open up a new window and redirect you to the data.oregon.gov website. You will be able to use a wide range of tools to visualize and download data, or create graphs and maps, or filter data, etc.  The data stored on data.oregon.gov is powered by the Socrata platform. You can find additional resources on how to use the platform to socialize data by visiting the Socrata Knowledge Base and Community Forums.Back to Top

Oregon Judicial Department – Contracts 
 
This report provides contracting information on contracts and amendments issued from July 1, 2013 – June 30, 2014, for the Oregon Judicial Department. The contract values reflected in this report are estimates.  
Click on the following link to view or download a .csv file of this data. 
Contracts: Oregon Judicial Department: Fiscal Year 2014 (.csv) 

Note: CSV stands for comma-separated values and may also be referred to as character-separated values. The CSV format is beneficial as it can be read by any spreadsheet program. As it is a plain text file, it can also be read by word processors or simple notepad programs.
 
Data Viewer – Guidelines
Clicking on the link above will open up a new window and redirect you to the data.oregon.gov website. You will be able to use a wide range of tools to visualize and download data, or create graphs and maps, or filter data, etc.  The data stored on data.oregon.gov is powered by the Socrata platform. You can find additional resources on how to use the platform to socialize data by visiting the Socrata Knowledge Base and Community Forums.ack to Top
 
Oregon Office of the State Treasurer – Contracts

Click on the following link to view or download a .csv file of this data. 
Contracts: State Treasurer: Fiscal Year 2014 (.csv)

Note: CSV stands for comma-separated values and may also be referred to as character-separated values. The CSV format is beneficial as it can be read by any spreadsheet program. As it is a plain text file, it can also be read by word processors or simple notepad programs.
 
Data Viewer – Guidelines
Clicking on the link above will open up a new window and redirect you to the data.oregon.gov website. You will be able to use a wide range of tools to visualize and download data, or create graphs and maps, or filter data, etc.  The data stored on data.oregon.gov is powered by the Socrata platform. You can find additional resources on how to use the platform to socialize data by visiting the Socrata Knowledge Base and Community Forums.

Expired Contracts Report – ORPIN
 
The following data is provided as an extract from the Statewide Procurement System (Oregon Procurement Information Network – ORPIN). It is a complete list of contracts that expired on or before June 30, 2014 and represents the full extent of electronic records of expired contracts that are tracked within ORPIN. The contract values reflected in the report are estimates only.

Note: A number of contracts may indicate an “Amendment Date” that may exceed the “Expiration Date”.  In these instances, the “Amendment Date” reflects an automated system time/date stamp that the system appended to the contract when the electronic version was accessed or modified, not necessarily when the legal instrument (the contract itself) was modified.

Note: This report may not include contract information for the Oregon Judicial Department, Oregon State Lottery, Oregon University System, Oregon State Treasurer, or semi-independent state agencies, boards, and commissions. Some executive branch agencies have independent contracting authority for specific goods and services (e.g., Transportation, Secretary of State, State Treasurer, Human Services, Fish and Wildlife, Parks and Recreation, Aviation, Economic and Community Development, Housing, Corrections, Veterans Affairs, Military, Education, and state agencies “specifically authorized” by any law outside the Code to “enter into a contract”). Thus, the ORPIN system may not capture contract information about those activities.

Click on the following link to view or download a .csv file of this data. 

OPRIN Expired Contracts (.csv)

Note: CSV stands for comma-separated values and may also be referred to as character-separated values. The CSV format is beneficial as it can be read by any spreadsheet program. As it is a plain text file, it can also be read by word processors or simple notepad programs.
 
Data Viewer – Guidelines
Clicking on the link above will open up a new window and redirect you to the data.oregon.gov website. You will be able to use a wide range of tools to visualize and download data, or create graphs and maps, or filter data, etc.  The data stored on data.oregon.gov is powered by the Socrata platform. You can find additional resources on how to use the platform to socialize data by visiting the Socrata Knowledge Base and Community Forums.Back to Top

Historical Information: Contracts \ Oregon University System (OUS)
*Note: Changes within the Oregon University System (OUS)
 
In 2014 and 2015 there were many governance changes within higher education, including statutory amendments that no longer require public universities to report through the transparency website. 
 
For more information about these changes and the new Governance Structure, click on the following link: http://www.ous.edu.

Direct access to contract information from previous years can be found on the Oregon.gov transparency website through the Website History link.
 
Historical Information

The Oregon.gov/transparency site is updated annually. The hyperlinks below provide direct access to information from recent years. Additional information can be found through the Website History link.
 
Contract Information by Fiscal Year
2014
2013
2012
2011
2010
2009