Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
158 lines (157 sloc) 3.41 KB
-- H18. TENURE BY HOUSEHOLD TYPE BY AGE OF HOUSEHOLDER
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_h18 (
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,
h018001 INTEGER,
h018001_2000 INTEGER,
h018002 INTEGER,
h018002_2000 INTEGER,
h018003 INTEGER,
h018003_2000 INTEGER,
h018004 INTEGER,
h018004_2000 INTEGER,
h018005 INTEGER,
h018005_2000 INTEGER,
h018006 INTEGER,
h018006_2000 INTEGER,
h018007 INTEGER,
h018007_2000 INTEGER,
h018008 INTEGER,
h018008_2000 INTEGER,
h018009 INTEGER,
h018009_2000 INTEGER,
h018010 INTEGER,
h018010_2000 INTEGER,
h018011 INTEGER,
h018011_2000 INTEGER,
h018012 INTEGER,
h018012_2000 INTEGER,
h018013 INTEGER,
h018013_2000 INTEGER,
h018014 INTEGER,
h018014_2000 INTEGER,
h018015 INTEGER,
h018015_2000 INTEGER,
h018016 INTEGER,
h018016_2000 INTEGER,
h018017 INTEGER,
h018017_2000 INTEGER,
h018018 INTEGER,
h018018_2000 INTEGER,
h018019 INTEGER,
h018019_2000 INTEGER,
h018020 INTEGER,
h018020_2000 INTEGER,
h018021 INTEGER,
h018021_2000 INTEGER,
h018022 INTEGER,
h018022_2000 INTEGER,
h018023 INTEGER,
h018023_2000 INTEGER,
h018024 INTEGER,
h018024_2000 INTEGER,
h018025 INTEGER,
h018025_2000 INTEGER,
h018026 INTEGER,
h018026_2000 INTEGER,
h018027 INTEGER,
h018027_2000 INTEGER,
h018028 INTEGER,
h018028_2000 INTEGER,
h018029 INTEGER,
h018029_2000 INTEGER,
h018030 INTEGER,
h018030_2000 INTEGER,
h018031 INTEGER,
h018031_2000 INTEGER,
h018032 INTEGER,
h018032_2000 INTEGER,
h018033 INTEGER,
h018033_2000 INTEGER,
h018034 INTEGER,
h018034_2000 INTEGER,
h018035 INTEGER,
h018035_2000 INTEGER,
h018036 INTEGER,
h018036_2000 INTEGER,
h018037 INTEGER,
h018037_2000 INTEGER,
h018038 INTEGER,
h018038_2000 INTEGER,
h018039 INTEGER,
h018039_2000 INTEGER,
h018040 INTEGER,
h018040_2000 INTEGER,
h018041 INTEGER,
h018041_2000 INTEGER,
h018042 INTEGER,
h018042_2000 INTEGER,
h018043 INTEGER,
h018043_2000 INTEGER,
h018044 INTEGER,
h018044_2000 INTEGER,
h018045 INTEGER,
h018045_2000 INTEGER,
h018046 INTEGER,
h018046_2000 INTEGER,
h018047 INTEGER,
h018047_2000 INTEGER,
h018048 INTEGER,
h018048_2000 INTEGER,
h018049 INTEGER,
h018049_2000 INTEGER,
h018050 INTEGER,
h018050_2000 INTEGER,
h018051 INTEGER,
h018051_2000 INTEGER,
h018052 INTEGER,
h018052_2000 INTEGER,
h018053 INTEGER,
h018053_2000 INTEGER,
h018054 INTEGER,
h018054_2000 INTEGER,
h018055 INTEGER,
h018055_2000 INTEGER,
h018056 INTEGER,
h018056_2000 INTEGER,
h018057 INTEGER,
h018057_2000 INTEGER,
h018058 INTEGER,
h018058_2000 INTEGER,
h018059 INTEGER,
h018059_2000 INTEGER,
h018060 INTEGER,
h018060_2000 INTEGER,
h018061 INTEGER,
h018061_2000 INTEGER,
h018062 INTEGER,
h018062_2000 INTEGER,
h018063 INTEGER,
h018063_2000 INTEGER,
h018064 INTEGER,
h018064_2000 INTEGER,
h018065 INTEGER,
h018065_2000 INTEGER,
h018066 INTEGER,
h018066_2000 INTEGER,
h018067 INTEGER,
h018067_2000 INTEGER,
h018068 INTEGER,
h018068_2000 INTEGER,
h018069 INTEGER,
h018069_2000 INTEGER,
PRIMARY KEY (geoid)
);