Skip to content
This repository
branch: master
Fetching contributors…

Cannot retrieve contributors at this time

file 117 lines (117 sloc) 2.941 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 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117
-- PCT13A. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (WHITE ALONE)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pct13a (
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,
pct013a001 INTEGER,
pct013a001_2000 INTEGER,
pct013a002 INTEGER,
pct013a002_2000 INTEGER,
pct013a003 INTEGER,
pct013a003_2000 INTEGER,
pct013a004 INTEGER,
pct013a004_2000 INTEGER,
pct013a005 INTEGER,
pct013a005_2000 INTEGER,
pct013a006 INTEGER,
pct013a006_2000 INTEGER,
pct013a007 INTEGER,
pct013a007_2000 INTEGER,
pct013a008 INTEGER,
pct013a008_2000 INTEGER,
pct013a009 INTEGER,
pct013a009_2000 INTEGER,
pct013a010 INTEGER,
pct013a010_2000 INTEGER,
pct013a011 INTEGER,
pct013a011_2000 INTEGER,
pct013a012 INTEGER,
pct013a012_2000 INTEGER,
pct013a013 INTEGER,
pct013a013_2000 INTEGER,
pct013a014 INTEGER,
pct013a014_2000 INTEGER,
pct013a015 INTEGER,
pct013a015_2000 INTEGER,
pct013a016 INTEGER,
pct013a016_2000 INTEGER,
pct013a017 INTEGER,
pct013a017_2000 INTEGER,
pct013a018 INTEGER,
pct013a018_2000 INTEGER,
pct013a019 INTEGER,
pct013a019_2000 INTEGER,
pct013a020 INTEGER,
pct013a020_2000 INTEGER,
pct013a021 INTEGER,
pct013a021_2000 INTEGER,
pct013a022 INTEGER,
pct013a022_2000 INTEGER,
pct013a023 INTEGER,
pct013a023_2000 INTEGER,
pct013a024 INTEGER,
pct013a024_2000 INTEGER,
pct013a025 INTEGER,
pct013a025_2000 INTEGER,
pct013a026 INTEGER,
pct013a026_2000 INTEGER,
pct013a027 INTEGER,
pct013a027_2000 INTEGER,
pct013a028 INTEGER,
pct013a028_2000 INTEGER,
pct013a029 INTEGER,
pct013a029_2000 INTEGER,
pct013a030 INTEGER,
pct013a030_2000 INTEGER,
pct013a031 INTEGER,
pct013a031_2000 INTEGER,
pct013a032 INTEGER,
pct013a032_2000 INTEGER,
pct013a033 INTEGER,
pct013a033_2000 INTEGER,
pct013a034 INTEGER,
pct013a034_2000 INTEGER,
pct013a035 INTEGER,
pct013a035_2000 INTEGER,
pct013a036 INTEGER,
pct013a036_2000 INTEGER,
pct013a037 INTEGER,
pct013a037_2000 INTEGER,
pct013a038 INTEGER,
pct013a038_2000 INTEGER,
pct013a039 INTEGER,
pct013a039_2000 INTEGER,
pct013a040 INTEGER,
pct013a040_2000 INTEGER,
pct013a041 INTEGER,
pct013a041_2000 INTEGER,
pct013a042 INTEGER,
pct013a042_2000 INTEGER,
pct013a043 INTEGER,
pct013a043_2000 INTEGER,
pct013a044 INTEGER,
pct013a044_2000 INTEGER,
pct013a045 INTEGER,
pct013a045_2000 INTEGER,
pct013a046 INTEGER,
pct013a046_2000 INTEGER,
pct013a047 INTEGER,
pct013a047_2000 INTEGER,
pct013a048 INTEGER,
pct013a048_2000 INTEGER,
pct013a049 INTEGER,
pct013a049_2000 INTEGER,
PRIMARY KEY (geoid)
);
Something went wrong with that request. Please try again.