Oregon Consumer Complaints

Consumer complaints registered with the Oregon Dept. of Justice. The database of consumer complaints is derived from consumer contacts for the years of 2017 - 2019 and is for informational purposes only. This dataset may not offer a completely accurate or comprehensive account of every incident. Several factors, including a company’s size and volume of transactions, may affect the likelihood of a consumer complaint being filed. The number of complaints about a business may not be a reliable measure as to whether it is appropriately conducting business.

The information in this dataset is updated as soon as possible. However, recently submitted complaints may not be immediately available.

The statements in this dataset do not necessarily reflect the opinion of the DOJ.

For more information, see http://www.doj.state.or.us/finfraud/index.shtml

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"oregon-gov/oregon-consumer-complaints-2ix7-8hwk\".\"oregon_consumer_complaints\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.