Skip to content
Find file
Fetching contributors…
Cannot retrieve contributors at this time
60 lines (59 sloc) 1.42 KB
-- P38A. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN (WHITE ALONE HOUSEHOLDER)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p38a (
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,
p038a001 INTEGER,
p038a001_2000 INTEGER,
p038a002 INTEGER,
p038a002_2000 INTEGER,
p038a003 INTEGER,
p038a003_2000 INTEGER,
p038a004 INTEGER,
p038a004_2000 INTEGER,
p038a005 INTEGER,
p038a005_2000 INTEGER,
p038a006 INTEGER,
p038a006_2000 INTEGER,
p038a007 INTEGER,
p038a007_2000 INTEGER,
p038a008 INTEGER,
p038a008_2000 INTEGER,
p038a009 INTEGER,
p038a009_2000 INTEGER,
p038a010 INTEGER,
p038a010_2000 INTEGER,
p038a011 INTEGER,
p038a011_2000 INTEGER,
p038a012 INTEGER,
p038a012_2000 INTEGER,
p038a013 INTEGER,
p038a013_2000 INTEGER,
p038a014 INTEGER,
p038a014_2000 INTEGER,
p038a015 INTEGER,
p038a015_2000 INTEGER,
p038a016 INTEGER,
p038a016_2000 INTEGER,
p038a017 INTEGER,
p038a017_2000 INTEGER,
p038a018 INTEGER,
p038a018_2000 INTEGER,
p038a019 INTEGER,
p038a019_2000 INTEGER,
p038a020 INTEGER,
p038a020_2000 INTEGER,
PRIMARY KEY (geoid)
);
Something went wrong with that request. Please try again.