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

54 lines (53 sloc) 1.331 kB
-- H16E. TENURE BY HOUSEHOLD SIZE (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_h16e (
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,
h016e001 INTEGER,
h016e001_2000 INTEGER,
h016e002 INTEGER,
h016e002_2000 INTEGER,
h016e003 INTEGER,
h016e003_2000 INTEGER,
h016e004 INTEGER,
h016e004_2000 INTEGER,
h016e005 INTEGER,
h016e005_2000 INTEGER,
h016e006 INTEGER,
h016e006_2000 INTEGER,
h016e007 INTEGER,
h016e007_2000 INTEGER,
h016e008 INTEGER,
h016e008_2000 INTEGER,
h016e009 INTEGER,
h016e009_2000 INTEGER,
h016e010 INTEGER,
h016e010_2000 INTEGER,
h016e011 INTEGER,
h016e011_2000 INTEGER,
h016e012 INTEGER,
h016e012_2000 INTEGER,
h016e013 INTEGER,
h016e013_2000 INTEGER,
h016e014 INTEGER,
h016e014_2000 INTEGER,
h016e015 INTEGER,
h016e015_2000 INTEGER,
h016e016 INTEGER,
h016e016_2000 INTEGER,
h016e017 INTEGER,
h016e017_2000 INTEGER,
PRIMARY KEY (geoid)
);
Jump to Line
Something went wrong with that request. Please try again.