Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
42 lines (41 sloc) 1.07 KB
-- PCT19C. NONRELATIVES BY HOUSEHOLD TYPE (AMERICAN INDIAN AND ALASKA NATIVE ALONE)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pct19c (
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,
pct019c001 INTEGER,
pct019c001_2000 INTEGER,
pct019c002 INTEGER,
pct019c002_2000 INTEGER,
pct019c003 INTEGER,
pct019c003_2000 INTEGER,
pct019c004 INTEGER,
pct019c004_2000 INTEGER,
pct019c005 INTEGER,
pct019c005_2000 INTEGER,
pct019c006 INTEGER,
pct019c006_2000 INTEGER,
pct019c007 INTEGER,
pct019c007_2000 INTEGER,
pct019c008 INTEGER,
pct019c008_2000 INTEGER,
pct019c009 INTEGER,
pct019c009_2000 INTEGER,
pct019c010 INTEGER,
pct019c010_2000 INTEGER,
pct019c011 INTEGER,
pct019c011_2000 INTEGER,
PRIMARY KEY (geoid)
);