Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
52 lines (51 sloc) 1.25 KB
-- P28C. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p28c (
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,
p028c001 INTEGER,
p028c001_2000 INTEGER,
p028c002 INTEGER,
p028c002_2000 INTEGER,
p028c003 INTEGER,
p028c003_2000 INTEGER,
p028c004 INTEGER,
p028c004_2000 INTEGER,
p028c005 INTEGER,
p028c005_2000 INTEGER,
p028c006 INTEGER,
p028c006_2000 INTEGER,
p028c007 INTEGER,
p028c007_2000 INTEGER,
p028c008 INTEGER,
p028c008_2000 INTEGER,
p028c009 INTEGER,
p028c009_2000 INTEGER,
p028c010 INTEGER,
p028c010_2000 INTEGER,
p028c011 INTEGER,
p028c011_2000 INTEGER,
p028c012 INTEGER,
p028c012_2000 INTEGER,
p028c013 INTEGER,
p028c013_2000 INTEGER,
p028c014 INTEGER,
p028c014_2000 INTEGER,
p028c015 INTEGER,
p028c015_2000 INTEGER,
p028c016 INTEGER,
p028c016_2000 INTEGER,
PRIMARY KEY (geoid)
);