Skip to content
Find file
Fetching contributors…
Cannot retrieve contributors at this time
60 lines (59 sloc) 1.42 KB
-- P38D. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN (ASIAN ALONE HOUSEHOLDER)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p38d (
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,
p038d001 INTEGER,
p038d001_2000 INTEGER,
p038d002 INTEGER,
p038d002_2000 INTEGER,
p038d003 INTEGER,
p038d003_2000 INTEGER,
p038d004 INTEGER,
p038d004_2000 INTEGER,
p038d005 INTEGER,
p038d005_2000 INTEGER,
p038d006 INTEGER,
p038d006_2000 INTEGER,
p038d007 INTEGER,
p038d007_2000 INTEGER,
p038d008 INTEGER,
p038d008_2000 INTEGER,
p038d009 INTEGER,
p038d009_2000 INTEGER,
p038d010 INTEGER,
p038d010_2000 INTEGER,
p038d011 INTEGER,
p038d011_2000 INTEGER,
p038d012 INTEGER,
p038d012_2000 INTEGER,
p038d013 INTEGER,
p038d013_2000 INTEGER,
p038d014 INTEGER,
p038d014_2000 INTEGER,
p038d015 INTEGER,
p038d015_2000 INTEGER,
p038d016 INTEGER,
p038d016_2000 INTEGER,
p038d017 INTEGER,
p038d017_2000 INTEGER,
p038d018 INTEGER,
p038d018_2000 INTEGER,
p038d019 INTEGER,
p038d019_2000 INTEGER,
p038d020 INTEGER,
p038d020_2000 INTEGER,
PRIMARY KEY (geoid)
);
Something went wrong with that request. Please try again.