Skip to content
Find file
Fetching contributors…
Cannot retrieve contributors at this time
60 lines (59 sloc) 1.43 KB
-- P38F. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN (SOME OTHER RACE ALONE HOUSEHOLDER)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p38f (
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,
p038f001 INTEGER,
p038f001_2000 INTEGER,
p038f002 INTEGER,
p038f002_2000 INTEGER,
p038f003 INTEGER,
p038f003_2000 INTEGER,
p038f004 INTEGER,
p038f004_2000 INTEGER,
p038f005 INTEGER,
p038f005_2000 INTEGER,
p038f006 INTEGER,
p038f006_2000 INTEGER,
p038f007 INTEGER,
p038f007_2000 INTEGER,
p038f008 INTEGER,
p038f008_2000 INTEGER,
p038f009 INTEGER,
p038f009_2000 INTEGER,
p038f010 INTEGER,
p038f010_2000 INTEGER,
p038f011 INTEGER,
p038f011_2000 INTEGER,
p038f012 INTEGER,
p038f012_2000 INTEGER,
p038f013 INTEGER,
p038f013_2000 INTEGER,
p038f014 INTEGER,
p038f014_2000 INTEGER,
p038f015 INTEGER,
p038f015_2000 INTEGER,
p038f016 INTEGER,
p038f016_2000 INTEGER,
p038f017 INTEGER,
p038f017_2000 INTEGER,
p038f018 INTEGER,
p038f018_2000 INTEGER,
p038f019 INTEGER,
p038f019_2000 INTEGER,
p038f020 INTEGER,
p038f020_2000 INTEGER,
PRIMARY KEY (geoid)
);
Something went wrong with that request. Please try again.