text: -- P31D. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS (ASIAN ALONE)
  -- designed to work with the IRE Census bulk data exports
  -- see http://census.ire.org/data/bulkdata.html
  CREATE TABLE ire_p31d (
  	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, 
  	p031d001 INTEGER, 
  	p031d001_2000 INTEGER, 
  	p031d002 INTEGER, 
  	p031d002_2000 INTEGER, 
  	p031d003 INTEGER, 
  	p031d003_2000 INTEGER, 
  	p031d004 INTEGER, 
  	p031d004_2000 INTEGER, 
  	p031d005 INTEGER, 
  	p031d005_2000 INTEGER, 
  	p031d006 INTEGER, 
  	p031d006_2000 INTEGER, 
  	p031d007 INTEGER, 
  	p031d007_2000 INTEGER, 
  	p031d008 INTEGER, 
  	p031d008_2000 INTEGER, 
  	p031d009 INTEGER, 
  	p031d009_2000 INTEGER, 
  	p031d010 INTEGER, 
  	p031d010_2000 INTEGER, 
  	p031d011 INTEGER, 
  	p031d011_2000 INTEGER, 
  	p031d012 INTEGER, 
  	p031d012_2000 INTEGER, 
  	p031d013 INTEGER, 
  	p031d013_2000 INTEGER, 
  	p031d014 INTEGER, 
  	p031d014_2000 INTEGER, 
  	p031d015 INTEGER, 
  	p031d015_2000 INTEGER, 
  	p031d016 INTEGER, 
  	p031d016_2000 INTEGER, 
  	PRIMARY KEY (geoid)
  );
  