text: -- PCT19G. NONRELATIVES BY HOUSEHOLD TYPE (TWO OR MORE RACES)
  -- designed to work with the IRE Census bulk data exports
  -- see http://census.ire.org/data/bulkdata.html
  CREATE TABLE ire_pct19g (
  	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, 
  	pct019g001 INTEGER, 
  	pct019g001_2000 INTEGER, 
  	pct019g002 INTEGER, 
  	pct019g002_2000 INTEGER, 
  	pct019g003 INTEGER, 
  	pct019g003_2000 INTEGER, 
  	pct019g004 INTEGER, 
  	pct019g004_2000 INTEGER, 
  	pct019g005 INTEGER, 
  	pct019g005_2000 INTEGER, 
  	pct019g006 INTEGER, 
  	pct019g006_2000 INTEGER, 
  	pct019g007 INTEGER, 
  	pct019g007_2000 INTEGER, 
  	pct019g008 INTEGER, 
  	pct019g008_2000 INTEGER, 
  	pct019g009 INTEGER, 
  	pct019g009_2000 INTEGER, 
  	pct019g010 INTEGER, 
  	pct019g010_2000 INTEGER, 
  	pct019g011 INTEGER, 
  	pct019g011_2000 INTEGER, 
  	PRIMARY KEY (geoid)
  );
  