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.48 kB
-- P38C. FAMILY TYPE BY PRESENCE AND AGE OF OWN 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_p38c (
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,
p038c001 INTEGER,
p038c001_2000 INTEGER,
p038c002 INTEGER,
p038c002_2000 INTEGER,
p038c003 INTEGER,
p038c003_2000 INTEGER,
p038c004 INTEGER,
p038c004_2000 INTEGER,
p038c005 INTEGER,
p038c005_2000 INTEGER,
p038c006 INTEGER,
p038c006_2000 INTEGER,
p038c007 INTEGER,
p038c007_2000 INTEGER,
p038c008 INTEGER,
p038c008_2000 INTEGER,
p038c009 INTEGER,
p038c009_2000 INTEGER,
p038c010 INTEGER,
p038c010_2000 INTEGER,
p038c011 INTEGER,
p038c011_2000 INTEGER,
p038c012 INTEGER,
p038c012_2000 INTEGER,
p038c013 INTEGER,
p038c013_2000 INTEGER,
p038c014 INTEGER,
p038c014_2000 INTEGER,
p038c015 INTEGER,
p038c015_2000 INTEGER,
p038c016 INTEGER,
p038c016_2000 INTEGER,
p038c017 INTEGER,
p038c017_2000 INTEGER,
p038c018 INTEGER,
p038c018_2000 INTEGER,
p038c019 INTEGER,
p038c019_2000 INTEGER,
p038c020 INTEGER,
p038c020_2000 INTEGER,
PRIMARY KEY (geoid)
);
Jump to Line
Something went wrong with that request. Please try again.