Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
46 lines (45 sloc) 1.11 KB
-- HCT3. TENURE BY PRESENCE AND AGE OF RELATED CHILDREN
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_hct3 (
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,
hct003001 INTEGER,
hct003001_2000 INTEGER,
hct003002 INTEGER,
hct003002_2000 INTEGER,
hct003003 INTEGER,
hct003003_2000 INTEGER,
hct003004 INTEGER,
hct003004_2000 INTEGER,
hct003005 INTEGER,
hct003005_2000 INTEGER,
hct003006 INTEGER,
hct003006_2000 INTEGER,
hct003007 INTEGER,
hct003007_2000 INTEGER,
hct003008 INTEGER,
hct003008_2000 INTEGER,
hct003009 INTEGER,
hct003009_2000 INTEGER,
hct003010 INTEGER,
hct003010_2000 INTEGER,
hct003011 INTEGER,
hct003011_2000 INTEGER,
hct003012 INTEGER,
hct003012_2000 INTEGER,
hct003013 INTEGER,
hct003013_2000 INTEGER,
PRIMARY KEY (geoid)
);