create_table.sql

CREATE TABLE cfpb_complanints (
    complaint_id INTEGER PRIMARY KEY,
    company VARCHAR(37),
    state VARCHAR(2),
    zip_code INTEGER,
    product VARCHAR(76),
    sub_product VARCHAR(48),
    issue VARCHAR(80),
    sub_issue VARCHAR(145),
    date_submitted TEXT,
    date_received TEXT,
    report_method VARCHAR(12),
    complaint_status VARCHAR(31),
    timely_response INTEGER
);