Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
60 lines (59 sloc) 1.36 KB
-- P39. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p39 (
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,
p039001 INTEGER,
p039001_2000 INTEGER,
p039002 INTEGER,
p039002_2000 INTEGER,
p039003 INTEGER,
p039003_2000 INTEGER,
p039004 INTEGER,
p039004_2000 INTEGER,
p039005 INTEGER,
p039005_2000 INTEGER,
p039006 INTEGER,
p039006_2000 INTEGER,
p039007 INTEGER,
p039007_2000 INTEGER,
p039008 INTEGER,
p039008_2000 INTEGER,
p039009 INTEGER,
p039009_2000 INTEGER,
p039010 INTEGER,
p039010_2000 INTEGER,
p039011 INTEGER,
p039011_2000 INTEGER,
p039012 INTEGER,
p039012_2000 INTEGER,
p039013 INTEGER,
p039013_2000 INTEGER,
p039014 INTEGER,
p039014_2000 INTEGER,
p039015 INTEGER,
p039015_2000 INTEGER,
p039016 INTEGER,
p039016_2000 INTEGER,
p039017 INTEGER,
p039017_2000 INTEGER,
p039018 INTEGER,
p039018_2000 INTEGER,
p039019 INTEGER,
p039019_2000 INTEGER,
p039020 INTEGER,
p039020_2000 INTEGER,
PRIMARY KEY (geoid)
);