create_table.sql

CREATE TABLE cfpb_complaints (
    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
);

CREATE TABLE county_populations (
    state VARCHAR(2),
    county VARCHAR(39),
    year INTEGER,
    population INTEGER
);

CREATE TABLE zip_codes_and_counties (
    state VARCHAR(2),
    county VARCHAR(28),
    zip_code INTEGER
);