Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
62 lines (61 sloc) 1.47 KB
-- H17C. TENURE BY AGE OF HOUSEHOLDER (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_h17c (
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,
h017c001 INTEGER,
h017c001_2000 INTEGER,
h017c002 INTEGER,
h017c002_2000 INTEGER,
h017c003 INTEGER,
h017c003_2000 INTEGER,
h017c004 INTEGER,
h017c004_2000 INTEGER,
h017c005 INTEGER,
h017c005_2000 INTEGER,
h017c006 INTEGER,
h017c006_2000 INTEGER,
h017c007 INTEGER,
h017c007_2000 INTEGER,
h017c008 INTEGER,
h017c008_2000 INTEGER,
h017c009 INTEGER,
h017c009_2000 INTEGER,
h017c010 INTEGER,
h017c010_2000 INTEGER,
h017c011 INTEGER,
h017c011_2000 INTEGER,
h017c012 INTEGER,
h017c012_2000 INTEGER,
h017c013 INTEGER,
h017c013_2000 INTEGER,
h017c014 INTEGER,
h017c014_2000 INTEGER,
h017c015 INTEGER,
h017c015_2000 INTEGER,
h017c016 INTEGER,
h017c016_2000 INTEGER,
h017c017 INTEGER,
h017c017_2000 INTEGER,
h017c018 INTEGER,
h017c018_2000 INTEGER,
h017c019 INTEGER,
h017c019_2000 INTEGER,
h017c020 INTEGER,
h017c020_2000 INTEGER,
h017c021 INTEGER,
h017c021_2000 INTEGER,
PRIMARY KEY (geoid)
);