Spaces:

vectara
/

cfpb-assistant

Sleeping

App Files Files Community

cfpb-assistant / create_table.sql

david-oplatka

Add Population Data Tables

b1222b7 almost 2 years ago

Raw History Blame Contribute Delete

621 Bytes

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
);

	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
	);