text: -- H16. TENURE BY HOUSEHOLD SIZE
  -- designed to work with the IRE Census bulk data exports
  -- see http://census.ire.org/data/bulkdata.html
  CREATE TABLE ire_h16 (
  	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, 
  	h016001 INTEGER, 
  	h016001_2000 INTEGER, 
  	h016002 INTEGER, 
  	h016002_2000 INTEGER, 
  	h016003 INTEGER, 
  	h016003_2000 INTEGER, 
  	h016004 INTEGER, 
  	h016004_2000 INTEGER, 
  	h016005 INTEGER, 
  	h016005_2000 INTEGER, 
  	h016006 INTEGER, 
  	h016006_2000 INTEGER, 
  	h016007 INTEGER, 
  	h016007_2000 INTEGER, 
  	h016008 INTEGER, 
  	h016008_2000 INTEGER, 
  	h016009 INTEGER, 
  	h016009_2000 INTEGER, 
  	h016010 INTEGER, 
  	h016010_2000 INTEGER, 
  	h016011 INTEGER, 
  	h016011_2000 INTEGER, 
  	h016012 INTEGER, 
  	h016012_2000 INTEGER, 
  	h016013 INTEGER, 
  	h016013_2000 INTEGER, 
  	h016014 INTEGER, 
  	h016014_2000 INTEGER, 
  	h016015 INTEGER, 
  	h016015_2000 INTEGER, 
  	h016016 INTEGER, 
  	h016016_2000 INTEGER, 
  	h016017 INTEGER, 
  	h016017_2000 INTEGER, 
  	PRIMARY KEY (geoid)
  );
  