Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
60 lines (59 sloc) 1.43 KB
-- P39H. FAMILY TYPE BY PRESENCE AND AGE OF RELATED 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_p39h (
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,
p039h001 INTEGER,
p039h001_2000 INTEGER,
p039h002 INTEGER,
p039h002_2000 INTEGER,
p039h003 INTEGER,
p039h003_2000 INTEGER,
p039h004 INTEGER,
p039h004_2000 INTEGER,
p039h005 INTEGER,
p039h005_2000 INTEGER,
p039h006 INTEGER,
p039h006_2000 INTEGER,
p039h007 INTEGER,
p039h007_2000 INTEGER,
p039h008 INTEGER,
p039h008_2000 INTEGER,
p039h009 INTEGER,
p039h009_2000 INTEGER,
p039h010 INTEGER,
p039h010_2000 INTEGER,
p039h011 INTEGER,
p039h011_2000 INTEGER,
p039h012 INTEGER,
p039h012_2000 INTEGER,
p039h013 INTEGER,
p039h013_2000 INTEGER,
p039h014 INTEGER,
p039h014_2000 INTEGER,
p039h015 INTEGER,
p039h015_2000 INTEGER,
p039h016 INTEGER,
p039h016_2000 INTEGER,
p039h017 INTEGER,
p039h017_2000 INTEGER,
p039h018 INTEGER,
p039h018_2000 INTEGER,
p039h019 INTEGER,
p039h019_2000 INTEGER,
p039h020 INTEGER,
p039h020_2000 INTEGER,
PRIMARY KEY (geoid)
);