About this Dataset

Office Of Consumer Protection (OCP) Investigations Data

The Office of Consumer Protection (OCP) conducts investigations to ensure business compliance and to resolve complaints about consumer transactions that occur in Montgomery County, no matter where the consumer or the merchant are located. OCP staff determine the facts, make sure that businesses are properly registered, check if any laws were broken, and try to help the consumer and merchant come to an agreement to resolve any issues. This dataset provides information about business registration compliance audits, executive director-initiated investigations, and consumer complaint cases filed with OCP over the last three (3) years. The data includes information about the date the audit/ complaint was received, the assigned OCP consumer complaint case number, a description of the alleged conduct subject to the complaint, and the case status. The dataset also provides the Montgomery County Council District of the complainant, if applicable, and whether the complainant resides within a Montgomery County Council Equity Focus Area.
Organization: Montgomery County of Maryland
Last updated: 2025-04-05T16:32:25.326330
Tags: consumer-protection, investigation

Tables

Table 1

@usgov.montgomery_county_of_maryland_office_of_consumer_prote_1f5e1540.table_1

257.71 kB
3,522 rows
15 columns

CREATE TABLE table_1 (
  "date_complaint_received" TIMESTAMP,
  "ocp_case_number" VARCHAR,
  "case_status" VARCHAR,
  "merchant_name" VARCHAR,
  "complaint_industry" VARCHAR,
  "complainant_100_block_address" VARCHAR,
  "complainant_100_block_address2" VARCHAR,
  "complainant_city" VARCHAR,
  "complainant_state" VARCHAR,
  "consumer_zip" VARCHAR,
  "council_district" DOUBLE,
  "equity_focus_area" VARCHAR,
  "n_100_block_address_latitude" DOUBLE  -- 100 Block Address Latitude,
  "n_100_block_address_longitude" DOUBLE  -- 100 Block Address Longitude,
  "location" VARCHAR
);