About this Dataset

CGB - Consumer Complaints Data

Individual informal consumer complaint data detailing complaints filed with the Consumer Help Center beginning October 31, 2014. This data represents information selected by the consumer. The FCC does not verify the facts alleged in these complaints.
Organization: Federal Communications Commission
Last updated: 2020-11-12T13:20:14.525774
Tags: fcc, fcc-consumer-complaints, fcc-consumer-inquiry

Tables

Table 1

@usgov.fcc_gov_cgb_consumer_complaints_data.table_1

141.54 MB
3,211,260 rows
16 columns

CREATE TABLE table_1 (
  "ticket_id" BIGINT,
  "ticket_created" VARCHAR,
  "date_created" TIMESTAMP,
  "date_of_issue" VARCHAR,
  "time_of_issue" VARCHAR,
  "form" VARCHAR,
  "method" VARCHAR,
  "issue" VARCHAR,
  "caller_id_number" VARCHAR,
  "type_of_call_or_messge" VARCHAR,
  "advertiser_business_number" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "location_center_point_of_the_zip_code" VARCHAR  -- Location (Center Point Of The Zip Code),
  "type_of_property_goods_or_services" VARCHAR
);