Skip to content
This repository
branch: master
Fetching contributors…

Cannot retrieve contributors at this time

file 61 lines (61 sloc) 1.478 kb
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61
-- H17D. TENURE BY AGE OF HOUSEHOLDER (ASIAN ALONE HOUSEHOLDER)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_h17d (
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,
h017d001 INTEGER,
h017d001_2000 INTEGER,
h017d002 INTEGER,
h017d002_2000 INTEGER,
h017d003 INTEGER,
h017d003_2000 INTEGER,
h017d004 INTEGER,
h017d004_2000 INTEGER,
h017d005 INTEGER,
h017d005_2000 INTEGER,
h017d006 INTEGER,
h017d006_2000 INTEGER,
h017d007 INTEGER,
h017d007_2000 INTEGER,
h017d008 INTEGER,
h017d008_2000 INTEGER,
h017d009 INTEGER,
h017d009_2000 INTEGER,
h017d010 INTEGER,
h017d010_2000 INTEGER,
h017d011 INTEGER,
h017d011_2000 INTEGER,
h017d012 INTEGER,
h017d012_2000 INTEGER,
h017d013 INTEGER,
h017d013_2000 INTEGER,
h017d014 INTEGER,
h017d014_2000 INTEGER,
h017d015 INTEGER,
h017d015_2000 INTEGER,
h017d016 INTEGER,
h017d016_2000 INTEGER,
h017d017 INTEGER,
h017d017_2000 INTEGER,
h017d018 INTEGER,
h017d018_2000 INTEGER,
h017d019 INTEGER,
h017d019_2000 INTEGER,
h017d020 INTEGER,
h017d020_2000 INTEGER,
h017d021 INTEGER,
h017d021_2000 INTEGER,
PRIMARY KEY (geoid)
);
Something went wrong with that request. Please try again.