Skip to content
Find file
Fetching contributors…
Cannot retrieve contributors at this time
60 lines (59 sloc) 1.42 KB
-- P39D. FAMILY TYPE BY PRESENCE AND AGE OF RELATED 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_p39d (
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,
p039d001 INTEGER,
p039d001_2000 INTEGER,
p039d002 INTEGER,
p039d002_2000 INTEGER,
p039d003 INTEGER,
p039d003_2000 INTEGER,
p039d004 INTEGER,
p039d004_2000 INTEGER,
p039d005 INTEGER,
p039d005_2000 INTEGER,
p039d006 INTEGER,
p039d006_2000 INTEGER,
p039d007 INTEGER,
p039d007_2000 INTEGER,
p039d008 INTEGER,
p039d008_2000 INTEGER,
p039d009 INTEGER,
p039d009_2000 INTEGER,
p039d010 INTEGER,
p039d010_2000 INTEGER,
p039d011 INTEGER,
p039d011_2000 INTEGER,
p039d012 INTEGER,
p039d012_2000 INTEGER,
p039d013 INTEGER,
p039d013_2000 INTEGER,
p039d014 INTEGER,
p039d014_2000 INTEGER,
p039d015 INTEGER,
p039d015_2000 INTEGER,
p039d016 INTEGER,
p039d016_2000 INTEGER,
p039d017 INTEGER,
p039d017_2000 INTEGER,
p039d018 INTEGER,
p039d018_2000 INTEGER,
p039d019 INTEGER,
p039d019_2000 INTEGER,
p039d020 INTEGER,
p039d020_2000 INTEGER,
PRIMARY KEY (geoid)
);
Jump to Line
Something went wrong with that request. Please try again.