Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
84 lines (83 sloc) 2.09 KB
-- PCT20C. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE (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_pct20c (
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,
pct020c001 INTEGER,
pct020c001_2000 INTEGER,
pct020c002 INTEGER,
pct020c002_2000 INTEGER,
pct020c003 INTEGER,
pct020c003_2000 INTEGER,
pct020c004 INTEGER,
pct020c004_2000 INTEGER,
pct020c005 INTEGER,
pct020c005_2000 INTEGER,
pct020c006 INTEGER,
pct020c006_2000 INTEGER,
pct020c007 INTEGER,
pct020c007_2000 INTEGER,
pct020c008 INTEGER,
pct020c008_2000 INTEGER,
pct020c009 INTEGER,
pct020c009_2000 INTEGER,
pct020c010 INTEGER,
pct020c010_2000 INTEGER,
pct020c011 INTEGER,
pct020c011_2000 INTEGER,
pct020c012 INTEGER,
pct020c012_2000 INTEGER,
pct020c013 INTEGER,
pct020c013_2000 INTEGER,
pct020c014 INTEGER,
pct020c014_2000 INTEGER,
pct020c015 INTEGER,
pct020c015_2000 INTEGER,
pct020c016 INTEGER,
pct020c016_2000 INTEGER,
pct020c017 INTEGER,
pct020c017_2000 INTEGER,
pct020c018 INTEGER,
pct020c018_2000 INTEGER,
pct020c019 INTEGER,
pct020c019_2000 INTEGER,
pct020c020 INTEGER,
pct020c020_2000 INTEGER,
pct020c021 INTEGER,
pct020c021_2000 INTEGER,
pct020c022 INTEGER,
pct020c022_2000 INTEGER,
pct020c023 INTEGER,
pct020c023_2000 INTEGER,
pct020c024 INTEGER,
pct020c024_2000 INTEGER,
pct020c025 INTEGER,
pct020c025_2000 INTEGER,
pct020c026 INTEGER,
pct020c026_2000 INTEGER,
pct020c027 INTEGER,
pct020c027_2000 INTEGER,
pct020c028 INTEGER,
pct020c028_2000 INTEGER,
pct020c029 INTEGER,
pct020c029_2000 INTEGER,
pct020c030 INTEGER,
pct020c030_2000 INTEGER,
pct020c031 INTEGER,
pct020c031_2000 INTEGER,
pct020c032 INTEGER,
pct020c032_2000 INTEGER,
PRIMARY KEY (geoid)
);