Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
60 lines (59 sloc) 1.45 KB
-- P39C. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p39c (
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,
p039c001 INTEGER,
p039c001_2000 INTEGER,
p039c002 INTEGER,
p039c002_2000 INTEGER,
p039c003 INTEGER,
p039c003_2000 INTEGER,
p039c004 INTEGER,
p039c004_2000 INTEGER,
p039c005 INTEGER,
p039c005_2000 INTEGER,
p039c006 INTEGER,
p039c006_2000 INTEGER,
p039c007 INTEGER,
p039c007_2000 INTEGER,
p039c008 INTEGER,
p039c008_2000 INTEGER,
p039c009 INTEGER,
p039c009_2000 INTEGER,
p039c010 INTEGER,
p039c010_2000 INTEGER,
p039c011 INTEGER,
p039c011_2000 INTEGER,
p039c012 INTEGER,
p039c012_2000 INTEGER,
p039c013 INTEGER,
p039c013_2000 INTEGER,
p039c014 INTEGER,
p039c014_2000 INTEGER,
p039c015 INTEGER,
p039c015_2000 INTEGER,
p039c016 INTEGER,
p039c016_2000 INTEGER,
p039c017 INTEGER,
p039c017_2000 INTEGER,
p039c018 INTEGER,
p039c018_2000 INTEGER,
p039c019 INTEGER,
p039c019_2000 INTEGER,
p039c020 INTEGER,
p039c020_2000 INTEGER,
PRIMARY KEY (geoid)
);