Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
42 lines (41 sloc) 1.04 KB
-- PCT19A. NONRELATIVES BY HOUSEHOLD TYPE (WHITE ALONE)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pct19a (
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,
pct019a001 INTEGER,
pct019a001_2000 INTEGER,
pct019a002 INTEGER,
pct019a002_2000 INTEGER,
pct019a003 INTEGER,
pct019a003_2000 INTEGER,
pct019a004 INTEGER,
pct019a004_2000 INTEGER,
pct019a005 INTEGER,
pct019a005_2000 INTEGER,
pct019a006 INTEGER,
pct019a006_2000 INTEGER,
pct019a007 INTEGER,
pct019a007_2000 INTEGER,
pct019a008 INTEGER,
pct019a008_2000 INTEGER,
pct019a009 INTEGER,
pct019a009_2000 INTEGER,
pct019a010 INTEGER,
pct019a010_2000 INTEGER,
pct019a011 INTEGER,
pct019a011_2000 INTEGER,
PRIMARY KEY (geoid)
);