Skip to content
Find file
Fetching contributors…
Cannot retrieve contributors at this time
56 lines (55 sloc) 1.46 KB
-- PCT17. PRESENCE OF UNMARRIED PARTNER OF HOUSEHOLDER BY HOUSEHOLD TYPE FOR THE POPULATION UNDER 18 YEARS IN HOUSEHOLDS (EXCLUDING HOUSEHOLDERS, SPOUSES, AND UNMARRIED PARTNERS)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pct17 (
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,
pct017001 INTEGER,
pct017001_2000 INTEGER,
pct017002 INTEGER,
pct017002_2000 INTEGER,
pct017003 INTEGER,
pct017003_2000 INTEGER,
pct017004 INTEGER,
pct017004_2000 INTEGER,
pct017005 INTEGER,
pct017005_2000 INTEGER,
pct017006 INTEGER,
pct017006_2000 INTEGER,
pct017007 INTEGER,
pct017007_2000 INTEGER,
pct017008 INTEGER,
pct017008_2000 INTEGER,
pct017009 INTEGER,
pct017009_2000 INTEGER,
pct017010 INTEGER,
pct017010_2000 INTEGER,
pct017011 INTEGER,
pct017011_2000 INTEGER,
pct017012 INTEGER,
pct017012_2000 INTEGER,
pct017013 INTEGER,
pct017013_2000 INTEGER,
pct017014 INTEGER,
pct017014_2000 INTEGER,
pct017015 INTEGER,
pct017015_2000 INTEGER,
pct017016 INTEGER,
pct017016_2000 INTEGER,
pct017017 INTEGER,
pct017017_2000 INTEGER,
pct017018 INTEGER,
pct017018_2000 INTEGER,
PRIMARY KEY (geoid)
);
Something went wrong with that request. Please try again.