Find file
Fetching contributors…
Cannot retrieve contributors at this time
62 lines (61 sloc) 1.61 KB
-- PCT22C. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER (AMERICAN INDIAN AND ALASKA NATIVE ALONE)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pct22c (
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,
pct022c001 INTEGER,
pct022c001_2000 INTEGER,
pct022c002 INTEGER,
pct022c002_2000 INTEGER,
pct022c003 INTEGER,
pct022c003_2000 INTEGER,
pct022c004 INTEGER,
pct022c004_2000 INTEGER,
pct022c005 INTEGER,
pct022c005_2000 INTEGER,
pct022c006 INTEGER,
pct022c006_2000 INTEGER,
pct022c007 INTEGER,
pct022c007_2000 INTEGER,
pct022c008 INTEGER,
pct022c008_2000 INTEGER,
pct022c009 INTEGER,
pct022c009_2000 INTEGER,
pct022c010 INTEGER,
pct022c010_2000 INTEGER,
pct022c011 INTEGER,
pct022c011_2000 INTEGER,
pct022c012 INTEGER,
pct022c012_2000 INTEGER,
pct022c013 INTEGER,
pct022c013_2000 INTEGER,
pct022c014 INTEGER,
pct022c014_2000 INTEGER,
pct022c015 INTEGER,
pct022c015_2000 INTEGER,
pct022c016 INTEGER,
pct022c016_2000 INTEGER,
pct022c017 INTEGER,
pct022c017_2000 INTEGER,
pct022c018 INTEGER,
pct022c018_2000 INTEGER,
pct022c019 INTEGER,
pct022c019_2000 INTEGER,
pct022c020 INTEGER,
pct022c020_2000 INTEGER,
pct022c021 INTEGER,
pct022c021_2000 INTEGER,
PRIMARY KEY (geoid)
);