Dataset: CGB - Consumer Complaints Data

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

134.98 MB
3211260 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,
  "type_of_property_goods_or_services" VARCHAR
);