Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
60 lines (59 sloc) 1.42 KB
-- P38H. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN (HISPANIC OR LATINO HOUSEHOLDER)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p38h (
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,
p038h001 INTEGER,
p038h001_2000 INTEGER,
p038h002 INTEGER,
p038h002_2000 INTEGER,
p038h003 INTEGER,
p038h003_2000 INTEGER,
p038h004 INTEGER,
p038h004_2000 INTEGER,
p038h005 INTEGER,
p038h005_2000 INTEGER,
p038h006 INTEGER,
p038h006_2000 INTEGER,
p038h007 INTEGER,
p038h007_2000 INTEGER,
p038h008 INTEGER,
p038h008_2000 INTEGER,
p038h009 INTEGER,
p038h009_2000 INTEGER,
p038h010 INTEGER,
p038h010_2000 INTEGER,
p038h011 INTEGER,
p038h011_2000 INTEGER,
p038h012 INTEGER,
p038h012_2000 INTEGER,
p038h013 INTEGER,
p038h013_2000 INTEGER,
p038h014 INTEGER,
p038h014_2000 INTEGER,
p038h015 INTEGER,
p038h015_2000 INTEGER,
p038h016 INTEGER,
p038h016_2000 INTEGER,
p038h017 INTEGER,
p038h017_2000 INTEGER,
p038h018 INTEGER,
p038h018_2000 INTEGER,
p038h019 INTEGER,
p038h019_2000 INTEGER,
p038h020 INTEGER,
p038h020_2000 INTEGER,
PRIMARY KEY (geoid)
);