Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
branch: master
Fetching contributors…

Cannot retrieve contributors at this time

60 lines (59 sloc) 1.493 kb
-- P39E. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p39e (
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,
p039e001 INTEGER,
p039e001_2000 INTEGER,
p039e002 INTEGER,
p039e002_2000 INTEGER,
p039e003 INTEGER,
p039e003_2000 INTEGER,
p039e004 INTEGER,
p039e004_2000 INTEGER,
p039e005 INTEGER,
p039e005_2000 INTEGER,
p039e006 INTEGER,
p039e006_2000 INTEGER,
p039e007 INTEGER,
p039e007_2000 INTEGER,
p039e008 INTEGER,
p039e008_2000 INTEGER,
p039e009 INTEGER,
p039e009_2000 INTEGER,
p039e010 INTEGER,
p039e010_2000 INTEGER,
p039e011 INTEGER,
p039e011_2000 INTEGER,
p039e012 INTEGER,
p039e012_2000 INTEGER,
p039e013 INTEGER,
p039e013_2000 INTEGER,
p039e014 INTEGER,
p039e014_2000 INTEGER,
p039e015 INTEGER,
p039e015_2000 INTEGER,
p039e016 INTEGER,
p039e016_2000 INTEGER,
p039e017 INTEGER,
p039e017_2000 INTEGER,
p039e018 INTEGER,
p039e018_2000 INTEGER,
p039e019 INTEGER,
p039e019_2000 INTEGER,
p039e020 INTEGER,
p039e020_2000 INTEGER,
PRIMARY KEY (geoid)
);
Jump to Line
Something went wrong with that request. Please try again.