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

76 lines (75 sloc) 1.811 kB
-- P29C. HOUSEHOLD TYPE BY RELATIONSHIP (AMERICAN INDIAN AND ALASKA NATIVE ALONE)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p29c (
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,
p029c001 INTEGER,
p029c001_2000 INTEGER,
p029c002 INTEGER,
p029c002_2000 INTEGER,
p029c003 INTEGER,
p029c003_2000 INTEGER,
p029c004 INTEGER,
p029c004_2000 INTEGER,
p029c005 INTEGER,
p029c005_2000 INTEGER,
p029c006 INTEGER,
p029c006_2000 INTEGER,
p029c007 INTEGER,
p029c007_2000 INTEGER,
p029c008 INTEGER,
p029c008_2000 INTEGER,
p029c009 INTEGER,
p029c009_2000 INTEGER,
p029c010 INTEGER,
p029c010_2000 INTEGER,
p029c011 INTEGER,
p029c011_2000 INTEGER,
p029c012 INTEGER,
p029c012_2000 INTEGER,
p029c013 INTEGER,
p029c013_2000 INTEGER,
p029c014 INTEGER,
p029c014_2000 INTEGER,
p029c015 INTEGER,
p029c015_2000 INTEGER,
p029c016 INTEGER,
p029c016_2000 INTEGER,
p029c017 INTEGER,
p029c017_2000 INTEGER,
p029c018 INTEGER,
p029c018_2000 INTEGER,
p029c019 INTEGER,
p029c019_2000 INTEGER,
p029c020 INTEGER,
p029c020_2000 INTEGER,
p029c021 INTEGER,
p029c021_2000 INTEGER,
p029c022 INTEGER,
p029c022_2000 INTEGER,
p029c023 INTEGER,
p029c023_2000 INTEGER,
p029c024 INTEGER,
p029c024_2000 INTEGER,
p029c025 INTEGER,
p029c025_2000 INTEGER,
p029c026 INTEGER,
p029c026_2000 INTEGER,
p029c027 INTEGER,
p029c027_2000 INTEGER,
p029c028 INTEGER,
p029c028_2000 INTEGER,
PRIMARY KEY (geoid)
);
Jump to Line
Something went wrong with that request. Please try again.