About this Dataset

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
Organization: State of Oregon
Last updated: 2020-11-10T17:21:48.673524
Tags: ag, attorney-general, complaint, consumer, consumer-protection, department-of-justice, doj

Tables

Table 1

@usgov.state_of_oregon_oregon_consumer_complaints.table_1

757.75 kB
18,281 rows
16 columns

CREATE TABLE table_1 (
  "reference_no" VARCHAR  -- Reference No.,
  "status" VARCHAR,
  "date_open" TIMESTAMP,
  "date_closed" TIMESTAMP,
  "respondent" VARCHAR,
  "address_1" VARCHAR,
  "address_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" DOUBLE,
  "contactflagonaddr1" VARCHAR,
  "business_type" VARCHAR,
  "complaint_description" VARCHAR,
  "closing_description" VARCHAR,
  "location_by_zip" VARCHAR,
  "geo_data_location" VARCHAR
);