Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
42 lines (41 sloc) 1.04 KB
-- PCT19D. NONRELATIVES BY HOUSEHOLD TYPE (ASIAN ALONE)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pct19d (
geoid VARCHAR(11) NOT NULL,
sumlev VARCHAR(3) NOT NULL,
state VARCHAR(2) NOT NULL,
county VARCHAR(3),
cbsa VARCHAR(5),
csa VARCHAR(3),
necta VARCHAR(5),
cnecta VARCHAR(3),
name VARCHAR(90) NOT NULL,
pop100 INTEGER NOT NULL,
hu100 INTEGER NOT NULL,
pop100_2000 INTEGER,
hu100_2000 INTEGER,
pct019d001 INTEGER,
pct019d001_2000 INTEGER,
pct019d002 INTEGER,
pct019d002_2000 INTEGER,
pct019d003 INTEGER,
pct019d003_2000 INTEGER,
pct019d004 INTEGER,
pct019d004_2000 INTEGER,
pct019d005 INTEGER,
pct019d005_2000 INTEGER,
pct019d006 INTEGER,
pct019d006_2000 INTEGER,
pct019d007 INTEGER,
pct019d007_2000 INTEGER,
pct019d008 INTEGER,
pct019d008_2000 INTEGER,
pct019d009 INTEGER,
pct019d009_2000 INTEGER,
pct019d010 INTEGER,
pct019d010_2000 INTEGER,
pct019d011 INTEGER,
pct019d011_2000 INTEGER,
PRIMARY KEY (geoid)
);