Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Browse files

Merge branch 'master' of github.com:ireapps/census into pl

  • Loading branch information...
commit 1387f270e99b4b676946296642e12377686573f6 2 parents e8ef373 + fe298ed
@onyxfish onyxfish authored
Showing with 41,432 additions and 20,159 deletions.
  1. +4 −2 censusweb/config/staging/apache
  2. +3 −3 censusweb/fabfile.py
  3. +4 −4 censusweb/media/js/browser.js
  4. +8 −4 censusweb/media/js/data.js
  5. +16 −0 dataprocessing/batch_20110802.sh
  6. +5 −1 tools/README.rst
  7. +9,147 −9,147 tools/sql/all_sf1_files.sql
  8. +10,897 −10,897 tools/sql/all_sf1_tables_as_views.sql
  9. +71 −0 tools/sql/generate_export_ddl.py
  10. +101 −101 tools/sql/geo_2010.sql
  11. +21 −0 tools/sql/ire_export/ire_H1.sql
  12. +21 −0 tools/sql/ire_export/ire_H10.sql
  13. +27 −0 tools/sql/ire_export/ire_H11.sql
  14. +27 −0 tools/sql/ire_export/ire_H11A.sql
  15. +27 −0 tools/sql/ire_export/ire_H11B.sql
  16. +27 −0 tools/sql/ire_export/ire_H11C.sql
  17. +27 −0 tools/sql/ire_export/ire_H11D.sql
  18. +27 −0 tools/sql/ire_export/ire_H11E.sql
  19. +27 −0 tools/sql/ire_export/ire_H11F.sql
  20. +27 −0 tools/sql/ire_export/ire_H11G.sql
  21. +27 −0 tools/sql/ire_export/ire_H11H.sql
  22. +27 −0 tools/sql/ire_export/ire_H11I.sql
  23. +25 −0 tools/sql/ire_export/ire_H12.sql
  24. +25 −0 tools/sql/ire_export/ire_H12A.sql
  25. +25 −0 tools/sql/ire_export/ire_H12B.sql
  26. +25 −0 tools/sql/ire_export/ire_H12C.sql
  27. +25 −0 tools/sql/ire_export/ire_H12D.sql
  28. +25 −0 tools/sql/ire_export/ire_H12E.sql
  29. +25 −0 tools/sql/ire_export/ire_H12F.sql
  30. +25 −0 tools/sql/ire_export/ire_H12G.sql
  31. +25 −0 tools/sql/ire_export/ire_H12H.sql
  32. +25 −0 tools/sql/ire_export/ire_H12I.sql
  33. +35 −0 tools/sql/ire_export/ire_H13.sql
  34. +53 −0 tools/sql/ire_export/ire_H14.sql
  35. +33 −0 tools/sql/ire_export/ire_H15.sql
  36. +53 −0 tools/sql/ire_export/ire_H16.sql
  37. +53 −0 tools/sql/ire_export/ire_H16A.sql
  38. +53 −0 tools/sql/ire_export/ire_H16B.sql
  39. +53 −0 tools/sql/ire_export/ire_H16C.sql
  40. +53 −0 tools/sql/ire_export/ire_H16D.sql
  41. +53 −0 tools/sql/ire_export/ire_H16E.sql
  42. +53 −0 tools/sql/ire_export/ire_H16F.sql
  43. +53 −0 tools/sql/ire_export/ire_H16G.sql
  44. +53 −0 tools/sql/ire_export/ire_H16H.sql
  45. +53 −0 tools/sql/ire_export/ire_H16I.sql
  46. +61 −0 tools/sql/ire_export/ire_H17.sql
  47. +61 −0 tools/sql/ire_export/ire_H17A.sql
  48. +61 −0 tools/sql/ire_export/ire_H17B.sql
  49. +61 −0 tools/sql/ire_export/ire_H17C.sql
  50. +61 −0 tools/sql/ire_export/ire_H17D.sql
  51. +61 −0 tools/sql/ire_export/ire_H17E.sql
  52. +61 −0 tools/sql/ire_export/ire_H17F.sql
  53. +61 −0 tools/sql/ire_export/ire_H17G.sql
  54. +61 −0 tools/sql/ire_export/ire_H17H.sql
  55. +61 −0 tools/sql/ire_export/ire_H17I.sql
  56. +157 −0 tools/sql/ire_export/ire_H18.sql
  57. +33 −0 tools/sql/ire_export/ire_H19.sql
  58. +31 −0 tools/sql/ire_export/ire_H2.sql
  59. +25 −0 tools/sql/ire_export/ire_H20.sql
  60. +25 −0 tools/sql/ire_export/ire_H21.sql
  61. +25 −0 tools/sql/ire_export/ire_H22.sql
  62. +25 −0 tools/sql/ire_export/ire_H3.sql
  63. +27 −0 tools/sql/ire_export/ire_H4.sql
  64. +35 −0 tools/sql/ire_export/ire_H5.sql
  65. +35 −0 tools/sql/ire_export/ire_H6.sql
  66. +53 −0 tools/sql/ire_export/ire_H7.sql
  67. +33 −0 tools/sql/ire_export/ire_H8.sql
  68. +49 −0 tools/sql/ire_export/ire_H9.sql
  69. +89 −0 tools/sql/ire_export/ire_HCT1.sql
  70. +45 −0 tools/sql/ire_export/ire_HCT2.sql
  71. +45 −0 tools/sql/ire_export/ire_HCT3.sql
  72. +45 −0 tools/sql/ire_export/ire_HCT4.sql
  73. +21 −0 tools/sql/ire_export/ire_P1.sql
  74. +161 −0 tools/sql/ire_export/ire_P10.sql
  75. +165 −0 tools/sql/ire_export/ire_P11.sql
  76. +117 −0 tools/sql/ire_export/ire_P12.sql
  77. +117 −0 tools/sql/ire_export/ire_P12A.sql
  78. +117 −0 tools/sql/ire_export/ire_P12B.sql
  79. +117 −0 tools/sql/ire_export/ire_P12C.sql
  80. +117 −0 tools/sql/ire_export/ire_P12D.sql
  81. +117 −0 tools/sql/ire_export/ire_P12E.sql
  82. +117 −0 tools/sql/ire_export/ire_P12F.sql
  83. +117 −0 tools/sql/ire_export/ire_P12G.sql
  84. +117 −0 tools/sql/ire_export/ire_P12H.sql
  85. +117 −0 tools/sql/ire_export/ire_P12I.sql
  86. +25 −0 tools/sql/ire_export/ire_P13.sql
  87. +25 −0 tools/sql/ire_export/ire_P13A.sql
  88. +25 −0 tools/sql/ire_export/ire_P13B.sql
  89. +25 −0 tools/sql/ire_export/ire_P13C.sql
  90. +25 −0 tools/sql/ire_export/ire_P13D.sql
  91. +25 −0 tools/sql/ire_export/ire_P13E.sql
  92. +25 −0 tools/sql/ire_export/ire_P13F.sql
  93. +25 −0 tools/sql/ire_export/ire_P13G.sql
  94. +25 −0 tools/sql/ire_export/ire_P13H.sql
  95. +25 −0 tools/sql/ire_export/ire_P13I.sql
  96. +105 −0 tools/sql/ire_export/ire_P14.sql
  97. +53 −0 tools/sql/ire_export/ire_P15.sql
  98. +25 −0 tools/sql/ire_export/ire_P16.sql
  99. +25 −0 tools/sql/ire_export/ire_P16A.sql
  100. +25 −0 tools/sql/ire_export/ire_P16B.sql
  101. +25 −0 tools/sql/ire_export/ire_P16C.sql
  102. +25 −0 tools/sql/ire_export/ire_P16D.sql
  103. +25 −0 tools/sql/ire_export/ire_P16E.sql
  104. +25 −0 tools/sql/ire_export/ire_P16F.sql
  105. +25 −0 tools/sql/ire_export/ire_P16G.sql
  106. +25 −0 tools/sql/ire_export/ire_P16H.sql
  107. +25 −0 tools/sql/ire_export/ire_P16I.sql
  108. +25 −0 tools/sql/ire_export/ire_P17.sql
  109. +25 −0 tools/sql/ire_export/ire_P17A.sql
  110. +25 −0 tools/sql/ire_export/ire_P17B.sql
  111. +25 −0 tools/sql/ire_export/ire_P17C.sql
  112. +25 −0 tools/sql/ire_export/ire_P17D.sql
  113. +25 −0 tools/sql/ire_export/ire_P17E.sql
  114. +25 −0 tools/sql/ire_export/ire_P17F.sql
  115. +25 −0 tools/sql/ire_export/ire_P17G.sql
  116. +25 −0 tools/sql/ire_export/ire_P17H.sql
  117. +25 −0 tools/sql/ire_export/ire_P17I.sql
  118. +37 −0 tools/sql/ire_export/ire_P18.sql
  119. +37 −0 tools/sql/ire_export/ire_P18A.sql
  120. +37 −0 tools/sql/ire_export/ire_P18B.sql
  121. +37 −0 tools/sql/ire_export/ire_P18C.sql
  122. +37 −0 tools/sql/ire_export/ire_P18D.sql
  123. +37 −0 tools/sql/ire_export/ire_P18E.sql
  124. +37 −0 tools/sql/ire_export/ire_P18F.sql
  125. +37 −0 tools/sql/ire_export/ire_P18G.sql
  126. +37 −0 tools/sql/ire_export/ire_P18H.sql
  127. +37 −0 tools/sql/ire_export/ire_P18I.sql
  128. +57 −0 tools/sql/ire_export/ire_P19.sql
  129. +31 −0 tools/sql/ire_export/ire_P2.sql
  130. +87 −0 tools/sql/ire_export/ire_P20.sql
  131. +81 −0 tools/sql/ire_export/ire_P21.sql
  132. +61 −0 tools/sql/ire_export/ire_P22.sql
  133. +49 −0 tools/sql/ire_export/ire_P23.sql
  134. +41 −0 tools/sql/ire_export/ire_P24.sql
  135. +41 −0 tools/sql/ire_export/ire_P25.sql
  136. +41 −0 tools/sql/ire_export/ire_P26.sql
  137. +25 −0 tools/sql/ire_export/ire_P27.sql
  138. +51 −0 tools/sql/ire_export/ire_P28.sql
  139. +51 −0 tools/sql/ire_export/ire_P28A.sql
  140. +51 −0 tools/sql/ire_export/ire_P28B.sql
  141. +51 −0 tools/sql/ire_export/ire_P28C.sql
  142. +51 −0 tools/sql/ire_export/ire_P28D.sql
  143. +51 −0 tools/sql/ire_export/ire_P28E.sql
  144. +51 −0 tools/sql/ire_export/ire_P28F.sql
  145. +51 −0 tools/sql/ire_export/ire_P28G.sql
  146. +51 −0 tools/sql/ire_export/ire_P28H.sql
  147. +51 −0 tools/sql/ire_export/ire_P28I.sql
  148. +75 −0 tools/sql/ire_export/ire_P29.sql
  149. +75 −0 tools/sql/ire_export/ire_P29A.sql
  150. +75 −0 tools/sql/ire_export/ire_P29B.sql
  151. +75 −0 tools/sql/ire_export/ire_P29C.sql
  152. +75 −0 tools/sql/ire_export/ire_P29D.sql
  153. +75 −0 tools/sql/ire_export/ire_P29E.sql
  154. +75 −0 tools/sql/ire_export/ire_P29F.sql
  155. +75 −0 tools/sql/ire_export/ire_P29G.sql
  156. +75 −0 tools/sql/ire_export/ire_P29H.sql
  157. +75 −0 tools/sql/ire_export/ire_P29I.sql
  158. +35 −0 tools/sql/ire_export/ire_P3.sql
  159. +45 −0 tools/sql/ire_export/ire_P30.sql
  160. +51 −0 tools/sql/ire_export/ire_P31.sql
  161. +51 −0 tools/sql/ire_export/ire_P31A.sql
  162. +51 −0 tools/sql/ire_export/ire_P31B.sql
  163. +51 −0 tools/sql/ire_export/ire_P31C.sql
  164. +51 −0 tools/sql/ire_export/ire_P31D.sql
  165. +51 −0 tools/sql/ire_export/ire_P31E.sql
  166. +51 −0 tools/sql/ire_export/ire_P31F.sql
  167. +51 −0 tools/sql/ire_export/ire_P31G.sql
  168. +51 −0 tools/sql/ire_export/ire_P31H.sql
  169. +51 −0 tools/sql/ire_export/ire_P31I.sql
  170. +109 −0 tools/sql/ire_export/ire_P32.sql
  171. +33 −0 tools/sql/ire_export/ire_P33.sql
  172. +63 −0 tools/sql/ire_export/ire_P34.sql
  173. +63 −0 tools/sql/ire_export/ire_P34A.sql
  174. +63 −0 tools/sql/ire_export/ire_P34B.sql
  175. +63 −0 tools/sql/ire_export/ire_P34C.sql
  176. +63 −0 tools/sql/ire_export/ire_P34D.sql
  177. +63 −0 tools/sql/ire_export/ire_P34E.sql
  178. +63 −0 tools/sql/ire_export/ire_P34F.sql
  179. +63 −0 tools/sql/ire_export/ire_P34G.sql
  180. +63 −0 tools/sql/ire_export/ire_P34H.sql
  181. +63 −0 tools/sql/ire_export/ire_P34I.sql
  182. +21 −0 tools/sql/ire_export/ire_P35.sql
  183. +21 −0 tools/sql/ire_export/ire_P35A.sql
  184. +21 −0 tools/sql/ire_export/ire_P35B.sql
  185. +21 −0 tools/sql/ire_export/ire_P35C.sql
  186. +21 −0 tools/sql/ire_export/ire_P35D.sql
  187. +21 −0 tools/sql/ire_export/ire_P35E.sql
  188. +21 −0 tools/sql/ire_export/ire_P35F.sql
  189. +21 −0 tools/sql/ire_export/ire_P35G.sql
  190. +21 −0 tools/sql/ire_export/ire_P35H.sql
  191. +21 −0 tools/sql/ire_export/ire_P35I.sql
  192. +25 −0 tools/sql/ire_export/ire_P36.sql
  193. +25 −0 tools/sql/ire_export/ire_P36A.sql
  194. +25 −0 tools/sql/ire_export/ire_P36B.sql
  195. +25 −0 tools/sql/ire_export/ire_P36C.sql
  196. +25 −0 tools/sql/ire_export/ire_P36D.sql
  197. +25 −0 tools/sql/ire_export/ire_P36E.sql
  198. +25 −0 tools/sql/ire_export/ire_P36F.sql
  199. +25 −0 tools/sql/ire_export/ire_P36G.sql
  200. +25 −0 tools/sql/ire_export/ire_P36H.sql
  201. +25 −0 tools/sql/ire_export/ire_P36I.sql
  202. +25 −0 tools/sql/ire_export/ire_P37.sql
  203. +25 −0 tools/sql/ire_export/ire_P37A.sql
  204. +25 −0 tools/sql/ire_export/ire_P37B.sql
  205. +25 −0 tools/sql/ire_export/ire_P37C.sql
  206. +25 −0 tools/sql/ire_export/ire_P37D.sql
  207. +25 −0 tools/sql/ire_export/ire_P37E.sql
  208. +25 −0 tools/sql/ire_export/ire_P37F.sql
  209. +25 −0 tools/sql/ire_export/ire_P37G.sql
  210. +25 −0 tools/sql/ire_export/ire_P37H.sql
  211. +25 −0 tools/sql/ire_export/ire_P37I.sql
  212. +59 −0 tools/sql/ire_export/ire_P38.sql
  213. +59 −0 tools/sql/ire_export/ire_P38A.sql
  214. +59 −0 tools/sql/ire_export/ire_P38B.sql
  215. +59 −0 tools/sql/ire_export/ire_P38C.sql
  216. +59 −0 tools/sql/ire_export/ire_P38D.sql
  217. +59 −0 tools/sql/ire_export/ire_P38E.sql
  218. +59 −0 tools/sql/ire_export/ire_P38F.sql
  219. +59 −0 tools/sql/ire_export/ire_P38G.sql
  220. +59 −0 tools/sql/ire_export/ire_P38H.sql
  221. +59 −0 tools/sql/ire_export/ire_P38I.sql
  222. +59 −0 tools/sql/ire_export/ire_P39.sql
  223. +59 −0 tools/sql/ire_export/ire_P39A.sql
  224. +59 −0 tools/sql/ire_export/ire_P39B.sql
  225. +59 −0 tools/sql/ire_export/ire_P39C.sql
  226. +59 −0 tools/sql/ire_export/ire_P39D.sql
  227. +59 −0 tools/sql/ire_export/ire_P39E.sql
  228. +59 −0 tools/sql/ire_export/ire_P39F.sql
  229. +59 −0 tools/sql/ire_export/ire_P39G.sql
  230. +59 −0 tools/sql/ire_export/ire_P39H.sql
  231. +59 −0 tools/sql/ire_export/ire_P39I.sql
  232. +25 −0 tools/sql/ire_export/ire_P4.sql
  233. +59 −0 tools/sql/ire_export/ire_P40.sql
  234. +31 −0 tools/sql/ire_export/ire_P41.sql
  235. +39 −0 tools/sql/ire_export/ire_P42.sql
  236. +145 −0 tools/sql/ire_export/ire_P43.sql
  237. +25 −0 tools/sql/ire_export/ire_P44.sql
  238. +25 −0 tools/sql/ire_export/ire_P45.sql
  239. +25 −0 tools/sql/ire_export/ire_P46.sql
  240. +25 −0 tools/sql/ire_export/ire_P47.sql
  241. +25 −0 tools/sql/ire_export/ire_P48.sql
  242. +25 −0 tools/sql/ire_export/ire_P49.sql
  243. +53 −0 tools/sql/ire_export/ire_P5.sql
  244. +25 −0 tools/sql/ire_export/ire_P50.sql
  245. +25 −0 tools/sql/ire_export/ire_P51.sql
  246. +33 −0 tools/sql/ire_export/ire_P6.sql
  247. +49 −0 tools/sql/ire_export/ire_P7.sql
  248. +161 −0 tools/sql/ire_export/ire_P8.sql
  249. +165 −0 tools/sql/ire_export/ire_P9.sql
  250. +97 −0 tools/sql/ire_export/ire_PCO1.sql
  251. +97 −0 tools/sql/ire_export/ire_PCO10.sql
  252. +97 −0 tools/sql/ire_export/ire_PCO2.sql
  253. +97 −0 tools/sql/ire_export/ire_PCO3.sql
  254. +97 −0 tools/sql/ire_export/ire_PCO4.sql
  255. +97 −0 tools/sql/ire_export/ire_PCO5.sql
  256. +97 −0 tools/sql/ire_export/ire_PCO6.sql
  257. +97 −0 tools/sql/ire_export/ire_PCO7.sql
  258. +97 −0 tools/sql/ire_export/ire_PCO8.sql
  259. +97 −0 tools/sql/ire_export/ire_PCO9.sql
  260. +127 −0 tools/sql/ire_export/ire_PCT1.sql
  261. +47 −0 tools/sql/ire_export/ire_PCT10.sql
  262. +81 −0 tools/sql/ire_export/ire_PCT11.sql
  263. +437 −0 tools/sql/ire_export/ire_PCT12.sql
  264. +437 −0 tools/sql/ire_export/ire_PCT12A.sql
  265. +437 −0 tools/sql/ire_export/ire_PCT12B.sql
  266. +437 −0 tools/sql/ire_export/ire_PCT12C.sql
  267. +437 −0 tools/sql/ire_export/ire_PCT12D.sql
  268. +437 −0 tools/sql/ire_export/ire_PCT12E.sql
  269. +437 −0 tools/sql/ire_export/ire_PCT12F.sql
  270. +437 −0 tools/sql/ire_export/ire_PCT12G.sql
  271. +437 −0 tools/sql/ire_export/ire_PCT12H.sql
  272. +437 −0 tools/sql/ire_export/ire_PCT12I.sql
  273. +437 −0 tools/sql/ire_export/ire_PCT12J.sql
  274. +437 −0 tools/sql/ire_export/ire_PCT12K.sql
  275. +437 −0 tools/sql/ire_export/ire_PCT12L.sql
  276. +437 −0 tools/sql/ire_export/ire_PCT12M.sql
  277. +437 −0 tools/sql/ire_export/ire_PCT12N.sql
  278. +437 −0 tools/sql/ire_export/ire_PCT12O.sql
  279. +117 −0 tools/sql/ire_export/ire_PCT13.sql
  280. +117 −0 tools/sql/ire_export/ire_PCT13A.sql
  281. +117 −0 tools/sql/ire_export/ire_PCT13B.sql
  282. +117 −0 tools/sql/ire_export/ire_PCT13C.sql
  283. +117 −0 tools/sql/ire_export/ire_PCT13D.sql
  284. +117 −0 tools/sql/ire_export/ire_PCT13E.sql
  285. +117 −0 tools/sql/ire_export/ire_PCT13F.sql
  286. +117 −0 tools/sql/ire_export/ire_PCT13G.sql
  287. +117 −0 tools/sql/ire_export/ire_PCT13H.sql
  288. +117 −0 tools/sql/ire_export/ire_PCT13I.sql
  289. +25 −0 tools/sql/ire_export/ire_PCT14.sql
  290. +25 −0 tools/sql/ire_export/ire_PCT14A.sql
  291. +25 −0 tools/sql/ire_export/ire_PCT14B.sql
  292. +25 −0 tools/sql/ire_export/ire_PCT14C.sql
  293. +25 −0 tools/sql/ire_export/ire_PCT14D.sql
  294. +25 −0 tools/sql/ire_export/ire_PCT14E.sql
  295. +25 −0 tools/sql/ire_export/ire_PCT14F.sql
  296. +25 −0 tools/sql/ire_export/ire_PCT14G.sql
  297. +25 −0 tools/sql/ire_export/ire_PCT14H.sql
  298. +25 −0 tools/sql/ire_export/ire_PCT14I.sql
  299. +87 −0 tools/sql/ire_export/ire_PCT15.sql
  300. +71 −0 tools/sql/ire_export/ire_PCT16.sql
Sorry, we could not display the entire diff because too many files (341) changed.
View
6 censusweb/config/staging/apache
@@ -1,5 +1,7 @@
<VirtualHost *:8080>
ServerName censusweb.beta.tribapps.com
+ ServerAlias census.beta.tribapps.com
+ ServerAlias census.tribapps.com
ServerAlias www.censusweb.beta.tribapps.com
SetEnv DEPLOYMENT_TARGET staging
@@ -26,8 +28,8 @@
RewriteEngine on
# canonical hostname
- RewriteCond %{HTTP_HOST} !^censusweb.beta.tribapps.com [NC]
- RewriteRule ^/(.*) http://censusweb.beta.tribapps.com/$1 [L,R]
+ RewriteCond %{HTTP_HOST} !^census.tribapps.com [NC]
+ RewriteRule ^/(.*) http://census.tribapps.com/$1 [L,R]
RewriteCond %{REQUEST_URI} /maintenance.html$
RewriteRule $ / [R=302,L]
View
6 censusweb/fabfile.py
@@ -45,11 +45,11 @@ def staging():
Work on staging environment
"""
env.settings = 'staging'
- env.hosts = ['censusweb.beta.tribapps.com']
+ env.hosts = ['census.tribapps.com']
env.user = 'ubuntu'
env.s3_bucket = 'media-beta.tribapps.com'
- env.site_domain = 'censusweb.beta.tribapps.com'
- env.cache_server = 'censusweb.beta.tribapps.com'
+ env.site_domain = 'census.tribapps.com'
+ env.cache_server = 'census.tribapps.com'
"""
Branches
View
8 censusweb/media/js/browser.js
@@ -4,7 +4,7 @@ $(function(){
Backbone.history.start()
if ( !location.hash )
location.hash=""
- }
+ };
ReportController = Backbone.Controller.extend({
routes: {
@@ -60,7 +60,7 @@ $(function(){
$("#ajax-loader").hide();
}
- })
+ });
Browser = Backbone.View.extend({
tagName: "aside",
@@ -132,5 +132,5 @@ $(function(){
defaultTables: function() {
window.location.hash = window.DEFAULT_TABLES;
}
- })
-})
+ });
+});
View
12 censusweb/media/js/data.js
@@ -106,7 +106,7 @@ $(function(){
// Browser handles displaying reports
$("#ajax-loader").hide();
- startBrowser();
+ window.startBrowser();
}
});
});
@@ -253,14 +253,18 @@ $(function(){
// Table mouseover row highlighting.
$('.report td').live('mouseover mouseleave', function(e) {
if (e.type == 'mouseover') {
- status = ''
+ var status = '';
$(this).addClass("selected");
$(this).parent().addClass("highlight");
status = $(this).parent().find('.label').text();
if ($(this).index() > 0) {
$("colgroup", $(this).parents("table")).eq($(this).index()).addClass("highlight"); //column
- status += ', ' + $($(this).parents("table").find('.locationdef')[Math.ceil($(this).index()/4) - 1]).clone().find('*').remove().end().text().trim();
- status += ', ' + $($(this).parents("table").find('.subhead')[$(this).index() - 1]).text().trim();
+ try {
+ status += ', ' + $($(this).parents("table").find('.locationdef')[Math.ceil($(this).index()/4) - 1]).clone().find('*').remove().end().text().trim();
+ status += ', ' + $($(this).parents("table").find('.subhead')[$(this).index() - 1]).text().trim();
+ } catch(e) {
+ // IE doesn't seem to like this?
+ }
}
$('#status').show().text(status);
} else {
View
16 dataprocessing/batch_20110802.sh
@@ -0,0 +1,16 @@
+#!/bin/bash
+# 17 IL
+./batch_sf.sh "Illinois" production
+./deploy_data.py staging
+./deploy_lookups.py staging
+./deploy_labels.py staging
+# 46 SD
+./batch_sf.sh "South Dakota" production
+# 32 NV
+./batch_sf.sh "Nevada" production
+# 41 OR
+./batch_sf.sh "Oregon" production
+# 18 IN
+./batch_sf.sh "Indiana" production
+# 53 WA
+./batch_sf.sh "Washington" production
View
6 tools/README.rst
@@ -15,7 +15,11 @@ For the geoheader files, which are fixed width, you may find useful the csvkit l
NOTE: Take care with character encoding. Some place names (such as those with Spanish words) contain non-ASCII characters. The Census Bureau encodes the files using "latin-1" encoding.
The in2csv example above handles this correctly. in2csv always writes output files in UTF-8, so adjust your database load scripts accordingly.
-Thanks to Ron Campbell of the Orange County Register for contributing the basis of **geo_2010.sql**
+Thanks to Ron Campbell of the Orange County Register for contributing the basis of **geo_2010.sql** Thanks to Mike Stucka of the Telegraph of Macon for suggestions to clarify the SQL and make it more compatible.
+
+Note that the column IDs do not exactly match the values printed in the SF1 technical documentation. Our method was to zero-pad digits to three positions, but we made no allowance for the occasional presence of letters qualifying race/ethnic variations on certain tables. Therefore, our column lengths vary in length somewhat compared to the SF1 versions of the labels. (If anyone is motivated to create an alternate SQL file or view which maintains tighter consistency with the SF1 technical documentation, please feel free to send a file or issue a pull request.)
+
+The column names in our SQL files align with the metadata files described below.
SAS
===
View
18,294 tools/sql/all_sf1_files.sql
9,147 additions, 9,147 deletions not shown
View
21,794 tools/sql/all_sf1_tables_as_views.sql
10,897 additions, 10,897 deletions not shown
View
71 tools/sql/generate_export_ddl.py
@@ -0,0 +1,71 @@
+#!/usr/bin/env python
+"""
+Generate SQL "Create table" files for all of the SF1 tables, with column format compatible with
+the bulk download files available at http://census.ire.org/data/bulkdata.html
+
+Note that all table names and column names will be forced to lowercase for maximum interoperability
+between databases.
+"""
+from sqlalchemy import Column, MetaData, Table
+from sqlalchemy import Float, Integer, String
+from sqlalchemy.schema import CreateTable
+
+import json
+
+import os.path
+import sys
+
+LABELS = json.load(open("../metadata/sf1_labels.json"))
+
+def _create_base_table(name):
+ """Provide the common columns for all of our exports"""
+ metadata = MetaData()
+ sql_table = Table(name.lower(), metadata)
+ sql_table.append_column(Column('geoid', String(length=11), primary_key=True))
+ sql_table.append_column(Column('sumlev', String(length=3), nullable=False))
+ sql_table.append_column(Column('state', String(length=2), nullable=False))
+ sql_table.append_column(Column('county', String(length=3)))
+ sql_table.append_column(Column('cbsa', String(length=5)))
+ sql_table.append_column(Column('csa', String(length=3)))
+ sql_table.append_column(Column('necta', String(length=5)))
+ sql_table.append_column(Column('cnecta', String(length=3)))
+ sql_table.append_column(Column('name', String(length=90), nullable=False))
+ sql_table.append_column(Column('pop100', Integer, nullable=False))
+ sql_table.append_column(Column('hu100', Integer, nullable=False))
+ sql_table.append_column(Column('pop100_2000', Integer, nullable=True))
+ sql_table.append_column(Column('hu100_2000', Integer, nullable=True))
+ return sql_table
+
+def sqlalchemy_for_table(table_code,table_name_prefix='ire_'):
+ table_labels = LABELS[table_code]
+ if table_labels['name'].find('AVERAGE') != -1 or table_labels['name'].find('MEDIAN') != -1:
+ col_type = Float
+ else:
+ col_type = Integer
+ sql_table = _create_base_table("%s%s" % (table_name_prefix,table_code))
+ for label in sorted(table_labels['labels']):
+ sql_table.append_column(Column(label.lower(), col_type))
+ sql_table.append_column(Column("%s_2000" % label.lower(), col_type))
+ return sql_table
+
+def sql_for_table(table_code,table_name_prefix='ire_'):
+ sql_table = sqlalchemy_for_table(table_code,table_name_prefix)
+ return unicode(CreateTable(sql_table).compile(dialect=None)).strip()
+
+if __name__ == "__main__":
+ try:
+ output_dir = sys.argv[1]
+ except:
+ output_dir = '.'
+
+ table_name_prefix = 'ire_'
+
+ for table_code in sorted(LABELS):
+ table_name = LABELS[table_code]['name']
+ fn = os.path.join(output_dir,"%s%s.sql" % (table_name_prefix,table_code))
+ with open(fn,"w") as f:
+ f.write("-- %s. %s\n" % (table_code,table_name))
+ f.write("-- designed to work with the IRE Census bulk data exports\n")
+ f.write("-- see http://census.ire.org/data/bulkdata.html\n")
+ f.write(sql_for_table(table_code))
+ f.write(';\n')
View
202 tools/sql/geo_2010.sql
@@ -1,103 +1,103 @@
CREATE TABLE geo2010 (
- "FILEID" VARCHAR(6) NOT NULL,
- "STUSAB" VARCHAR(2) NOT NULL,
- "SUMLEV" VARCHAR(3) NOT NULL,
- "GEOCOMP" VARCHAR(2) NOT NULL,
- "CHARITER" VARCHAR(3) NOT NULL,
- "CIFSN" VARCHAR(3),
- "LOGRECNO" VARCHAR(7) NOT NULL,
- "REGION" VARCHAR(1),
- "DIVISION" VARCHAR(1),
- "STATE" VARCHAR(2),
- "COUNTY" VARCHAR(3),
- "COUNTYCC" VARCHAR(2),
- "COUNTYSC" VARCHAR(2),
- "COUSUB" VARCHAR(5),
- "COUSUBCC" VARCHAR(2),
- "COUSUBSC" VARCHAR(2),
- "PLACE" VARCHAR(5),
- "PLACECC" VARCHAR(2),
- "PLACESC" VARCHAR(2),
- "TRACT" VARCHAR(6),
- "BLKGRP" VARCHAR(1),
- "BLOCK" VARCHAR(4),
- "IUC" VARCHAR(2),
- "CONCIT" VARCHAR(5),
- "CONCITCC" VARCHAR(2),
- "CONCITSC" VARCHAR(2),
- "AIANHH" VARCHAR(4),
- "AIANHHFP" VARCHAR(5),
- "AIANHHCC" VARCHAR(2),
- "AIHHTLI" VARCHAR(1),
- "AITSCE" VARCHAR(3),
- "AITS" VARCHAR(5),
- "AITSCC" VARCHAR(2),
- "TTRACT" VARCHAR(6),
- "TBLKGRP" VARCHAR(1),
- "ANRC" VARCHAR(5),
- "ANRCCC" VARCHAR(2),
- "CBSA" VARCHAR(5),
- "CBSASC" VARCHAR(2),
- "METDIV" VARCHAR(5),
- "CSA" VARCHAR(3),
- "NECTA" VARCHAR(5),
- "NECTASC" VARCHAR(2),
- "NECTADIV" VARCHAR(5),
- "CNECTA" VARCHAR(3),
- "CBSAPCI" VARCHAR(1),
- "NECTAPCI" VARCHAR(1),
- "UA" VARCHAR(5),
- "UASC" VARCHAR(2),
- "UATYPE" VARCHAR(1),
- "UR" VARCHAR(1),
- "CD" VARCHAR(2),
- "SLDU" VARCHAR(3),
- "SLDL" VARCHAR(3),
- "VTD" VARCHAR(6),
- "VDT1" VARCHAR(1),
- "RESERVE2" VARCHAR(3),
- "ZCTA5" VARCHAR(5),
- "SUBMCD" VARCHAR(5),
- "SUBMCDCC" VARCHAR(2),
- "SDELM" VARCHAR(5),
- "SDSEC" VARCHAR(5),
- "SDUNI" VARCHAR(5),
- "AREALAND" VARCHAR(14),
- "AREAWATR" VARCHAR(14),
- "NAME" VARCHAR(90),
- "FUNCSTAT" VARCHAR(1),
- "GCUNI" VARCHAR(1),
- "POP100" VARCHAR(9),
- "HU100" VARCHAR(9),
- "INTPTLAT" VARCHAR(11),
- "INTPTLON" VARCHAR(12),
- "LSADC" VARCHAR(2),
- "PARTFLAG" VARCHAR(1),
- "RESERVE3" VARCHAR(6),
- "UGA" VARCHAR(5),
- "STATENS" VARCHAR(8),
- "COUNTYNS" VARCHAR(8),
- "COUSUBNS" VARCHAR(8),
- "PLACENS" VARCHAR(8),
- "CONCITNS" VARCHAR(8),
- "AIANHHNS" VARCHAR(8),
- "AITSNS" VARCHAR(8),
- "ANRCNS" VARCHAR(8),
- "SUBMCDNS" VARCHAR(8),
- "CD113" VARCHAR(2),
- "CD114" VARCHAR(2),
- "CD115" VARCHAR(2),
- "SLDU2" VARCHAR(3),
- "SLDU3" VARCHAR(3),
- "SLDU4" VARCHAR(3),
- "SLDL2" VARCHAR(3),
- "SLDL3" VARCHAR(3),
- "SLDL4" VARCHAR(3),
- "AIANHHLSC" VARCHAR(2),
- "CSASC" VARCHAR(2),
- "CNECTASC" VARCHAR(2),
- "MEMI" VARCHAR(1),
- "NMEMI" VARCHAR(1),
- "PUMA" VARCHAR(5),
- "RESERVED" VARCHAR(18)
+ FILEID VARCHAR(6) NOT NULL,
+ STUSAB VARCHAR(2) NOT NULL,
+ SUMLEV VARCHAR(3) NOT NULL,
+ GEOCOMP VARCHAR(2) NOT NULL,
+ CHARITER VARCHAR(3) NOT NULL,
+ CIFSN VARCHAR(2),
+ LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
+ REGION VARCHAR(1),
+ DIVISION VARCHAR(1),
+ STATE VARCHAR(2),
+ COUNTY VARCHAR(3),
+ COUNTYCC VARCHAR(2),
+ COUNTYSC VARCHAR(2),
+ COUSUB VARCHAR(5),
+ COUSUBCC VARCHAR(2),
+ COUSUBSC VARCHAR(2),
+ PLACE VARCHAR(5),
+ PLACECC VARCHAR(2),
+ PLACESC VARCHAR(2),
+ TRACT VARCHAR(6),
+ BLKGRP VARCHAR(1),
+ BLOCK VARCHAR(4),
+ IUC VARCHAR(2),
+ CONCIT VARCHAR(5),
+ CONCITCC VARCHAR(2),
+ CONCITSC VARCHAR(2),
+ AIANHH VARCHAR(4),
+ AIANHHFP VARCHAR(5),
+ AIANHHCC VARCHAR(2),
+ AIHHTLI VARCHAR(1),
+ AITSCE VARCHAR(3),
+ AITS VARCHAR(5),
+ AITSCC VARCHAR(2),
+ TTRACT VARCHAR(6),
+ TBLKGRP VARCHAR(1),
+ ANRC VARCHAR(5),
+ ANRCCC VARCHAR(2),
+ CBSA VARCHAR(5),
+ CBSASC VARCHAR(2),
+ METDIV VARCHAR(5),
+ CSA VARCHAR(3),
+ NECTA VARCHAR(5),
+ NECTASC VARCHAR(2),
+ NECTADIV VARCHAR(5),
+ CNECTA VARCHAR(3),
+ CBSAPCI VARCHAR(1),
+ NECTAPCI VARCHAR(1),
+ UA VARCHAR(5),
+ UASC VARCHAR(2),
+ UATYPE VARCHAR(1),
+ UR VARCHAR(1),
+ CD VARCHAR(2),
+ SLDU VARCHAR(3),
+ SLDL VARCHAR(3),
+ VTD VARCHAR(6),
+ VDT1 VARCHAR(1),
+ RESERVE2 VARCHAR(3),
+ ZCTA5 VARCHAR(5),
+ SUBMCD VARCHAR(5),
+ SUBMCDCC VARCHAR(2),
+ SDELM VARCHAR(5),
+ SDSEC VARCHAR(5),
+ SDUNI VARCHAR(5),
+ AREALAND VARCHAR(14),
+ AREAWATR VARCHAR(14),
+ NAME VARCHAR(90),
+ FUNCSTAT VARCHAR(1),
+ GCUNI VARCHAR(1),
+ POP100 VARCHAR(9),
+ HU100 VARCHAR(9),
+ INTPTLAT VARCHAR(11),
+ INTPTLON VARCHAR(12),
+ LSADC VARCHAR(2),
+ PARTFLAG VARCHAR(1),
+ RESERVE3 VARCHAR(6),
+ UGA VARCHAR(5),
+ STATENS VARCHAR(8),
+ COUNTYNS VARCHAR(8),
+ COUSUBNS VARCHAR(8),
+ PLACENS VARCHAR(8),
+ CONCITNS VARCHAR(8),
+ AIANHHNS VARCHAR(8),
+ AITSNS VARCHAR(8),
+ ANRCNS VARCHAR(8),
+ SUBMCDNS VARCHAR(8),
+ CD113 VARCHAR(2),
+ CD114 VARCHAR(2),
+ CD115 VARCHAR(2),
+ SLDU2 VARCHAR(3),
+ SLDU3 VARCHAR(3),
+ SLDU4 VARCHAR(3),
+ SLDL2 VARCHAR(3),
+ SLDL3 VARCHAR(3),
+ SLDL4 VARCHAR(3),
+ AIANHHLSC VARCHAR(2),
+ CSASC VARCHAR(2),
+ CNECTASC VARCHAR(2),
+ MEMI VARCHAR(1),
+ NMEMI VARCHAR(1),
+ PUMA VARCHAR(5),
+ RESERVED VARCHAR(18)
);
View
21 tools/sql/ire_export/ire_H1.sql
@@ -0,0 +1,21 @@
+-- H1. HOUSING UNITS
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h1 (
+ 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,
+ h001001 INTEGER,
+ h001001_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
21 tools/sql/ire_export/ire_H10.sql
@@ -0,0 +1,21 @@
+-- H10. TOTAL POPULATION IN OCCUPIED HOUSING UNITS
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h10 (
+ 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,
+ h010001 INTEGER,
+ h010001_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
27 tools/sql/ire_export/ire_H11.sql
@@ -0,0 +1,27 @@
+-- H11. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h11 (
+ 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,
+ h011001 INTEGER,
+ h011001_2000 INTEGER,
+ h011002 INTEGER,
+ h011002_2000 INTEGER,
+ h011003 INTEGER,
+ h011003_2000 INTEGER,
+ h011004 INTEGER,
+ h011004_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
27 tools/sql/ire_export/ire_H11A.sql
@@ -0,0 +1,27 @@
+-- H11A. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (WHITE ALONE HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h11a (
+ 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,
+ h011a001 INTEGER,
+ h011a001_2000 INTEGER,
+ h011a002 INTEGER,
+ h011a002_2000 INTEGER,
+ h011a003 INTEGER,
+ h011a003_2000 INTEGER,
+ h011a004 INTEGER,
+ h011a004_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
27 tools/sql/ire_export/ire_H11B.sql
@@ -0,0 +1,27 @@
+-- H11B. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h11b (
+ 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,
+ h011b001 INTEGER,
+ h011b001_2000 INTEGER,
+ h011b002 INTEGER,
+ h011b002_2000 INTEGER,
+ h011b003 INTEGER,
+ h011b003_2000 INTEGER,
+ h011b004 INTEGER,
+ h011b004_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
27 tools/sql/ire_export/ire_H11C.sql
@@ -0,0 +1,27 @@
+-- H11C. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h11c (
+ 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,
+ h011c001 INTEGER,
+ h011c001_2000 INTEGER,
+ h011c002 INTEGER,
+ h011c002_2000 INTEGER,
+ h011c003 INTEGER,
+ h011c003_2000 INTEGER,
+ h011c004 INTEGER,
+ h011c004_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
27 tools/sql/ire_export/ire_H11D.sql
@@ -0,0 +1,27 @@
+-- H11D. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (ASIAN ALONE HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h11d (
+ 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,
+ h011d001 INTEGER,
+ h011d001_2000 INTEGER,
+ h011d002 INTEGER,
+ h011d002_2000 INTEGER,
+ h011d003 INTEGER,
+ h011d003_2000 INTEGER,
+ h011d004 INTEGER,
+ h011d004_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
27 tools/sql/ire_export/ire_H11E.sql
@@ -0,0 +1,27 @@
+-- H11E. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h11e (
+ 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,
+ h011e001 INTEGER,
+ h011e001_2000 INTEGER,
+ h011e002 INTEGER,
+ h011e002_2000 INTEGER,
+ h011e003 INTEGER,
+ h011e003_2000 INTEGER,
+ h011e004 INTEGER,
+ h011e004_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
27 tools/sql/ire_export/ire_H11F.sql
@@ -0,0 +1,27 @@
+-- H11F. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (SOME OTHER RACE ALONE HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h11f (
+ 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,
+ h011f001 INTEGER,
+ h011f001_2000 INTEGER,
+ h011f002 INTEGER,
+ h011f002_2000 INTEGER,
+ h011f003 INTEGER,
+ h011f003_2000 INTEGER,
+ h011f004 INTEGER,
+ h011f004_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
27 tools/sql/ire_export/ire_H11G.sql
@@ -0,0 +1,27 @@
+-- H11G. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (TWO OR MORE RACES HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h11g (
+ 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,
+ h011g001 INTEGER,
+ h011g001_2000 INTEGER,
+ h011g002 INTEGER,
+ h011g002_2000 INTEGER,
+ h011g003 INTEGER,
+ h011g003_2000 INTEGER,
+ h011g004 INTEGER,
+ h011g004_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
27 tools/sql/ire_export/ire_H11H.sql
@@ -0,0 +1,27 @@
+-- H11H. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (HISPANIC OR LATINO HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h11h (
+ 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,
+ h011h001 INTEGER,
+ h011h001_2000 INTEGER,
+ h011h002 INTEGER,
+ h011h002_2000 INTEGER,
+ h011h003 INTEGER,
+ h011h003_2000 INTEGER,
+ h011h004 INTEGER,
+ h011h004_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
27 tools/sql/ire_export/ire_H11I.sql
@@ -0,0 +1,27 @@
+-- H11I. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h11i (
+ 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,
+ h011i001 INTEGER,
+ h011i001_2000 INTEGER,
+ h011i002 INTEGER,
+ h011i002_2000 INTEGER,
+ h011i003 INTEGER,
+ h011i003_2000 INTEGER,
+ h011i004 INTEGER,
+ h011i004_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
25 tools/sql/ire_export/ire_H12.sql
@@ -0,0 +1,25 @@
+-- H12. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h12 (
+ 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,
+ h012001 FLOAT,
+ h012001_2000 FLOAT,
+ h012002 FLOAT,
+ h012002_2000 FLOAT,
+ h012003 FLOAT,
+ h012003_2000 FLOAT,
+ PRIMARY KEY (geoid)
+);
View
25 tools/sql/ire_export/ire_H12A.sql
@@ -0,0 +1,25 @@
+-- H12A. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (WHITE ALONE HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h12a (
+ 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,
+ h012a001 FLOAT,
+ h012a001_2000 FLOAT,
+ h012a002 FLOAT,
+ h012a002_2000 FLOAT,
+ h012a003 FLOAT,
+ h012a003_2000 FLOAT,
+ PRIMARY KEY (geoid)
+);
View
25 tools/sql/ire_export/ire_H12B.sql
@@ -0,0 +1,25 @@
+-- H12B. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h12b (
+ 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,
+ h012b001 FLOAT,
+ h012b001_2000 FLOAT,
+ h012b002 FLOAT,
+ h012b002_2000 FLOAT,
+ h012b003 FLOAT,
+ h012b003_2000 FLOAT,
+ PRIMARY KEY (geoid)
+);
View
25 tools/sql/ire_export/ire_H12C.sql
@@ -0,0 +1,25 @@
+-- H12C. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h12c (
+ 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,
+ h012c001 FLOAT,
+ h012c001_2000 FLOAT,
+ h012c002 FLOAT,
+ h012c002_2000 FLOAT,
+ h012c003 FLOAT,
+ h012c003_2000 FLOAT,
+ PRIMARY KEY (geoid)
+);
View
25 tools/sql/ire_export/ire_H12D.sql
@@ -0,0 +1,25 @@
+-- H12D. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (ASIAN ALONE HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h12d (
+ 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,
+ h012d001 FLOAT,
+ h012d001_2000 FLOAT,
+ h012d002 FLOAT,
+ h012d002_2000 FLOAT,
+ h012d003 FLOAT,
+ h012d003_2000 FLOAT,
+ PRIMARY KEY (geoid)
+);
View
25 tools/sql/ire_export/ire_H12E.sql
@@ -0,0 +1,25 @@
+-- H12E. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h12e (
+ 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,
+ h012e001 FLOAT,
+ h012e001_2000 FLOAT,
+ h012e002 FLOAT,
+ h012e002_2000 FLOAT,
+ h012e003 FLOAT,
+ h012e003_2000 FLOAT,
+ PRIMARY KEY (geoid)
+);
View
25 tools/sql/ire_export/ire_H12F.sql
@@ -0,0 +1,25 @@
+-- H12F. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (SOME OTHER RACE ALONE HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h12f (
+ 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,
+ h012f001 FLOAT,
+ h012f001_2000 FLOAT,
+ h012f002 FLOAT,
+ h012f002_2000 FLOAT,
+ h012f003 FLOAT,
+ h012f003_2000 FLOAT,
+ PRIMARY KEY (geoid)
+);
View
25 tools/sql/ire_export/ire_H12G.sql
@@ -0,0 +1,25 @@
+-- H12G. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (TWO OR MORE RACES HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h12g (
+ 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,
+ h012g001 FLOAT,
+ h012g001_2000 FLOAT,
+ h012g002 FLOAT,
+ h012g002_2000 FLOAT,
+ h012g003 FLOAT,
+ h012g003_2000 FLOAT,
+ PRIMARY KEY (geoid)
+);
View
25 tools/sql/ire_export/ire_H12H.sql
@@ -0,0 +1,25 @@
+-- H12H. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (HISPANIC OR LATINO HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h12h (
+ 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,
+ h012h001 FLOAT,
+ h012h001_2000 FLOAT,
+ h012h002 FLOAT,
+ h012h002_2000 FLOAT,
+ h012h003 FLOAT,
+ h012h003_2000 FLOAT,
+ PRIMARY KEY (geoid)
+);
View
25 tools/sql/ire_export/ire_H12I.sql
@@ -0,0 +1,25 @@
+-- H12I. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h12i (
+ 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,
+ h012i001 FLOAT,
+ h012i001_2000 FLOAT,
+ h012i002 FLOAT,
+ h012i002_2000 FLOAT,
+ h012i003 FLOAT,
+ h012i003_2000 FLOAT,
+ PRIMARY KEY (geoid)
+);
View
35 tools/sql/ire_export/ire_H13.sql
@@ -0,0 +1,35 @@
+-- H13. HOUSEHOLD SIZE
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h13 (
+ 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,
+ h013001 INTEGER,
+ h013001_2000 INTEGER,
+ h013002 INTEGER,
+ h013002_2000 INTEGER,
+ h013003 INTEGER,
+ h013003_2000 INTEGER,
+ h013004 INTEGER,
+ h013004_2000 INTEGER,
+ h013005 INTEGER,
+ h013005_2000 INTEGER,
+ h013006 INTEGER,
+ h013006_2000 INTEGER,
+ h013007 INTEGER,
+ h013007_2000 INTEGER,
+ h013008 INTEGER,
+ h013008_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
53 tools/sql/ire_export/ire_H14.sql
@@ -0,0 +1,53 @@
+-- H14. TENURE BY RACE OF HOUSEHOLDER
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h14 (
+ 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,
+ h014001 INTEGER,
+ h014001_2000 INTEGER,
+ h014002 INTEGER,
+ h014002_2000 INTEGER,
+ h014003 INTEGER,
+ h014003_2000 INTEGER,
+ h014004 INTEGER,
+ h014004_2000 INTEGER,
+ h014005 INTEGER,
+ h014005_2000 INTEGER,
+ h014006 INTEGER,
+ h014006_2000 INTEGER,
+ h014007 INTEGER,
+ h014007_2000 INTEGER,
+ h014008 INTEGER,
+ h014008_2000 INTEGER,
+ h014009 INTEGER,
+ h014009_2000 INTEGER,
+ h014010 INTEGER,
+ h014010_2000 INTEGER,
+ h014011 INTEGER,
+ h014011_2000 INTEGER,
+ h014012 INTEGER,
+ h014012_2000 INTEGER,
+ h014013 INTEGER,
+ h014013_2000 INTEGER,
+ h014014 INTEGER,
+ h014014_2000 INTEGER,
+ h014015 INTEGER,
+ h014015_2000 INTEGER,
+ h014016 INTEGER,
+ h014016_2000 INTEGER,
+ h014017 INTEGER,
+ h014017_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
33 tools/sql/ire_export/ire_H15.sql
@@ -0,0 +1,33 @@
+-- H15. TENURE BY HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h15 (
+ 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,
+ h015001 INTEGER,
+ h015001_2000 INTEGER,
+ h015002 INTEGER,
+ h015002_2000 INTEGER,
+ h015003 INTEGER,
+ h015003_2000 INTEGER,
+ h015004 INTEGER,
+ h015004_2000 INTEGER,
+ h015005 INTEGER,
+ h015005_2000 INTEGER,
+ h015006 INTEGER,
+ h015006_2000 INTEGER,
+ h015007 INTEGER,
+ h015007_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
53 tools/sql/ire_export/ire_H16.sql
@@ -0,0 +1,53 @@
+-- H16. TENURE BY HOUSEHOLD SIZE
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h16 (
+ 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,
+ h016001 INTEGER,
+ h016001_2000 INTEGER,
+ h016002 INTEGER,
+ h016002_2000 INTEGER,
+ h016003 INTEGER,
+ h016003_2000 INTEGER,
+ h016004 INTEGER,
+ h016004_2000 INTEGER,
+ h016005 INTEGER,
+ h016005_2000 INTEGER,
+ h016006 INTEGER,
+ h016006_2000 INTEGER,
+ h016007 INTEGER,
+ h016007_2000 INTEGER,
+ h016008 INTEGER,
+ h016008_2000 INTEGER,
+ h016009 INTEGER,
+ h016009_2000 INTEGER,
+ h016010 INTEGER,
+ h016010_2000 INTEGER,
+ h016011 INTEGER,
+ h016011_2000 INTEGER,
+ h016012 INTEGER,
+ h016012_2000 INTEGER,
+ h016013 INTEGER,
+ h016013_2000 INTEGER,
+ h016014 INTEGER,
+ h016014_2000 INTEGER,
+ h016015 INTEGER,
+ h016015_2000 INTEGER,
+ h016016 INTEGER,
+ h016016_2000 INTEGER,
+ h016017 INTEGER,
+ h016017_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
53 tools/sql/ire_export/ire_H16A.sql
@@ -0,0 +1,53 @@
+-- H16A. TENURE BY HOUSEHOLD SIZE (WHITE ALONE HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h16a (
+ 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,
+ h016a001 INTEGER,
+ h016a001_2000 INTEGER,
+ h016a002 INTEGER,
+ h016a002_2000 INTEGER,
+ h016a003 INTEGER,
+ h016a003_2000 INTEGER,
+ h016a004 INTEGER,
+ h016a004_2000 INTEGER,
+ h016a005 INTEGER,
+ h016a005_2000 INTEGER,
+ h016a006 INTEGER,
+ h016a006_2000 INTEGER,
+ h016a007 INTEGER,
+ h016a007_2000 INTEGER,
+ h016a008 INTEGER,
+ h016a008_2000 INTEGER,
+ h016a009 INTEGER,
+ h016a009_2000 INTEGER,
+ h016a010 INTEGER,
+ h016a010_2000 INTEGER,
+ h016a011 INTEGER,
+ h016a011_2000 INTEGER,
+ h016a012 INTEGER,
+ h016a012_2000 INTEGER,
+ h016a013 INTEGER,
+ h016a013_2000 INTEGER,
+ h016a014 INTEGER,
+ h016a014_2000 INTEGER,
+ h016a015 INTEGER,
+ h016a015_2000 INTEGER,
+ h016a016 INTEGER,
+ h016a016_2000 INTEGER,
+ h016a017 INTEGER,
+ h016a017_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
53 tools/sql/ire_export/ire_H16B.sql
@@ -0,0 +1,53 @@
+-- H16B. TENURE BY HOUSEHOLD SIZE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h16b (
+ 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,
+ h016b001 INTEGER,
+ h016b001_2000 INTEGER,
+ h016b002 INTEGER,
+ h016b002_2000 INTEGER,
+ h016b003 INTEGER,
+ h016b003_2000 INTEGER,
+ h016b004 INTEGER,
+ h016b004_2000 INTEGER,
+ h016b005 INTEGER,
+ h016b005_2000 INTEGER,
+ h016b006 INTEGER,
+ h016b006_2000 INTEGER,
+ h016b007 INTEGER,
+ h016b007_2000 INTEGER,
+ h016b008 INTEGER,
+ h016b008_2000 INTEGER,
+ h016b009 INTEGER,
+ h016b009_2000 INTEGER,
+ h016b010 INTEGER,
+ h016b010_2000 INTEGER,
+ h016b011 INTEGER,
+ h016b011_2000 INTEGER,
+ h016b012 INTEGER,
+ h016b012_2000 INTEGER,
+ h016b013 INTEGER,
+ h016b013_2000 INTEGER,
+ h016b014 INTEGER,
+ h016b014_2000 INTEGER,
+ h016b015 INTEGER,
+ h016b015_2000 INTEGER,
+ h016b016 INTEGER,
+ h016b016_2000 INTEGER,
+ h016b017 INTEGER,
+ h016b017_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
53 tools/sql/ire_export/ire_H16C.sql
@@ -0,0 +1,53 @@
+-- H16C. TENURE BY HOUSEHOLD SIZE (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h16c (
+ 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,
+ h016c001 INTEGER,
+ h016c001_2000 INTEGER,
+ h016c002 INTEGER,
+ h016c002_2000 INTEGER,
+ h016c003 INTEGER,
+ h016c003_2000 INTEGER,
+ h016c004 INTEGER,
+ h016c004_2000 INTEGER,
+ h016c005 INTEGER,
+ h016c005_2000 INTEGER,
+ h016c006 INTEGER,
+ h016c006_2000 INTEGER,
+ h016c007 INTEGER,
+ h016c007_2000 INTEGER,
+ h016c008 INTEGER,
+ h016c008_2000 INTEGER,
+ h016c009 INTEGER,
+ h016c009_2000 INTEGER,
+ h016c010 INTEGER,
+ h016c010_2000 INTEGER,
+ h016c011 INTEGER,
+ h016c011_2000 INTEGER,
+ h016c012 INTEGER,
+ h016c012_2000 INTEGER,
+ h016c013 INTEGER,
+ h016c013_2000 INTEGER,
+ h016c014 INTEGER,
+ h016c014_2000 INTEGER,
+ h016c015 INTEGER,
+ h016c015_2000 INTEGER,
+ h016c016 INTEGER,
+ h016c016_2000 INTEGER,
+ h016c017 INTEGER,
+ h016c017_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
53 tools/sql/ire_export/ire_H16D.sql
@@ -0,0 +1,53 @@
+-- H16D. TENURE BY HOUSEHOLD SIZE (ASIAN ALONE HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h16d (
+ 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,
+ h016d001 INTEGER,
+ h016d001_2000 INTEGER,
+ h016d002 INTEGER,
+ h016d002_2000 INTEGER,
+ h016d003 INTEGER,
+ h016d003_2000 INTEGER,
+ h016d004 INTEGER,
+ h016d004_2000 INTEGER,
+ h016d005 INTEGER,
+ h016d005_2000 INTEGER,
+ h016d006 INTEGER,
+ h016d006_2000 INTEGER,
+ h016d007 INTEGER,
+ h016d007_2000 INTEGER,
+ h016d008 INTEGER,
+ h016d008_2000 INTEGER,
+ h016d009 INTEGER,
+ h016d009_2000 INTEGER,
+ h016d010 INTEGER,
+ h016d010_2000 INTEGER,
+ h016d011 INTEGER,
+ h016d011_2000 INTEGER,
+ h016d012 INTEGER,
+ h016d012_2000 INTEGER,
+ h016d013 INTEGER,
+ h016d013_2000 INTEGER,
+ h016d014 INTEGER,
+ h016d014_2000 INTEGER,
+ h016d015 INTEGER,
+ h016d015_2000 INTEGER,
+ h016d016 INTEGER,
+ h016d016_2000 INTEGER,
+ h016d017 INTEGER,
+ h016d017_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
53 tools/sql/ire_export/ire_H16E.sql
@@ -0,0 +1,53 @@
+-- H16E. TENURE BY HOUSEHOLD SIZE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h16e (
+ 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,
+ h016e001 INTEGER,
+ h016e001_2000 INTEGER,
+ h016e002 INTEGER,
+ h016e002_2000 INTEGER,
+ h016e003 INTEGER,
+ h016e003_2000 INTEGER,
+ h016e004 INTEGER,
+ h016e004_2000 INTEGER,
+ h016e005 INTEGER,
+ h016e005_2000 INTEGER,
+ h016e006 INTEGER,
+ h016e006_2000 INTEGER,
+ h016e007 INTEGER,
+ h016e007_2000 INTEGER,
+ h016e008 INTEGER,
+ h016e008_2000 INTEGER,
+ h016e009 INTEGER,
+ h016e009_2000 INTEGER,
+ h016e010 INTEGER,
+ h016e010_2000 INTEGER,
+ h016e011 INTEGER,
+ h016e011_2000 INTEGER,
+ h016e012 INTEGER,
+ h016e012_2000 INTEGER,
+ h016e013 INTEGER,
+ h016e013_2000 INTEGER,
+ h016e014 INTEGER,
+ h016e014_2000 INTEGER,
+ h016e015 INTEGER,
+ h016e015_2000 INTEGER,
+ h016e016 INTEGER,
+ h016e016_2000 INTEGER,
+ h016e017 INTEGER,
+ h016e017_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
53 tools/sql/ire_export/ire_H16F.sql
@@ -0,0 +1,53 @@
+-- H16F. TENURE BY HOUSEHOLD SIZE (SOME OTHER RACE ALONE HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h16f (
+ 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,
+ h016f001 INTEGER,
+ h016f001_2000 INTEGER,
+ h016f002 INTEGER,
+ h016f002_2000 INTEGER,
+ h016f003 INTEGER,
+ h016f003_2000 INTEGER,
+ h016f004 INTEGER,
+ h016f004_2000 INTEGER,
+ h016f005 INTEGER,
+ h016f005_2000 INTEGER,
+ h016f006 INTEGER,
+ h016f006_2000 INTEGER,
+ h016f007 INTEGER,
+ h016f007_2000 INTEGER,
+ h016f008 INTEGER,
+ h016f008_2000 INTEGER,
+ h016f009 INTEGER,
+ h016f009_2000 INTEGER,
+ h016f010 INTEGER,
+ h016f010_2000 INTEGER,
+ h016f011 INTEGER,
+ h016f011_2000 INTEGER,
+ h016f012 INTEGER,
+ h016f012_2000 INTEGER,
+ h016f013 INTEGER,
+ h016f013_2000 INTEGER,
+ h016f014 INTEGER,
+ h016f014_2000 INTEGER,
+ h016f015 INTEGER,
+ h016f015_2000 INTEGER,
+ h016f016 INTEGER,
+ h016f016_2000 INTEGER,
+ h016f017 INTEGER,
+ h016f017_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
53 tools/sql/ire_export/ire_H16G.sql
@@ -0,0 +1,53 @@
+-- H16G. TENURE BY HOUSEHOLD SIZE (TWO OR MORE RACES HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h16g (
+ 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,
+ h016g001 INTEGER,
+ h016g001_2000 INTEGER,
+ h016g002 INTEGER,
+ h016g002_2000 INTEGER,
+ h016g003 INTEGER,
+ h016g003_2000 INTEGER,
+ h016g004 INTEGER,
+ h016g004_2000 INTEGER,
+ h016g005 INTEGER,
+ h016g005_2000 INTEGER,
+ h016g006 INTEGER,
+ h016g006_2000 INTEGER,
+ h016g007 INTEGER,
+ h016g007_2000 INTEGER,
+ h016g008 INTEGER,
+ h016g008_2000 INTEGER,
+ h016g009 INTEGER,
+ h016g009_2000 INTEGER,
+ h016g010 INTEGER,
+ h016g010_2000 INTEGER,
+ h016g011 INTEGER,
+ h016g011_2000 INTEGER,
+ h016g012 INTEGER,
+ h016g012_2000 INTEGER,
+ h016g013 INTEGER,
+ h016g013_2000 INTEGER,
+ h016g014 INTEGER,
+ h016g014_2000 INTEGER,
+ h016g015 INTEGER,
+ h016g015_2000 INTEGER,
+ h016g016 INTEGER,
+ h016g016_2000 INTEGER,
+ h016g017 INTEGER,
+ h016g017_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
53 tools/sql/ire_export/ire_H16H.sql
@@ -0,0 +1,53 @@
+-- H16H. TENURE BY HOUSEHOLD SIZE (HISPANIC OR LATINO HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h16h (
+ 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,
+ h016h001 INTEGER,
+ h016h001_2000 INTEGER,
+ h016h002 INTEGER,
+ h016h002_2000 INTEGER,
+ h016h003 INTEGER,
+ h016h003_2000 INTEGER,
+ h016h004 INTEGER,
+ h016h004_2000 INTEGER,
+ h016h005 INTEGER,
+ h016h005_2000 INTEGER,
+ h016h006 INTEGER,
+ h016h006_2000 INTEGER,
+ h016h007 INTEGER,
+ h016h007_2000 INTEGER,
+ h016h008 INTEGER,
+ h016h008_2000 INTEGER,
+ h016h009 INTEGER,
+ h016h009_2000 INTEGER,
+ h016h010 INTEGER,
+ h016h010_2000 INTEGER,
+ h016h011 INTEGER,
+ h016h011_2000 INTEGER,
+ h016h012 INTEGER,
+ h016h012_2000 INTEGER,
+ h016h013 INTEGER,
+ h016h013_2000 INTEGER,
+ h016h014 INTEGER,
+ h016h014_2000 INTEGER,
+ h016h015 INTEGER,
+ h016h015_2000 INTEGER,
+ h016h016 INTEGER,
+ h016h016_2000 INTEGER,
+ h016h017 INTEGER,
+ h016h017_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
53 tools/sql/ire_export/ire_H16I.sql
@@ -0,0 +1,53 @@
+-- H16I. TENURE BY HOUSEHOLD SIZE (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h16i (
+ 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,
+ h016i001 INTEGER,
+ h016i001_2000 INTEGER,
+ h016i002 INTEGER,
+ h016i002_2000 INTEGER,
+ h016i003 INTEGER,
+ h016i003_2000 INTEGER,
+ h016i004 INTEGER,
+ h016i004_2000 INTEGER,
+ h016i005 INTEGER,
+ h016i005_2000 INTEGER,
+ h016i006 INTEGER,
+ h016i006_2000 INTEGER,
+ h016i007 INTEGER,
+ h016i007_2000 INTEGER,
+ h016i008 INTEGER,
+ h016i008_2000 INTEGER,
+ h016i009 INTEGER,
+ h016i009_2000 INTEGER,
+ h016i010 INTEGER,
+ h016i010_2000 INTEGER,
+ h016i011 INTEGER,
+ h016i011_2000 INTEGER,
+ h016i012 INTEGER,
+ h016i012_2000 INTEGER,
+ h016i013 INTEGER,
+ h016i013_2000 INTEGER,
+ h016i014 INTEGER,
+ h016i014_2000 INTEGER,
+ h016i015 INTEGER,
+ h016i015_2000 INTEGER,
+ h016i016 INTEGER,
+ h016i016_2000 INTEGER,
+ h016i017 INTEGER,
+ h016i017_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
61 tools/sql/ire_export/ire_H17.sql
@@ -0,0 +1,61 @@
+-- H17. TENURE BY AGE OF HOUSEHOLDER
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h17 (
+ 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,
+ h017001 INTEGER,
+ h017001_2000 INTEGER,
+ h017002 INTEGER,
+ h017002_2000 INTEGER,
+ h017003 INTEGER,
+ h017003_2000 INTEGER,
+ h017004 INTEGER,
+ h017004_2000 INTEGER,
+ h017005 INTEGER,
+ h017005_2000 INTEGER,
+ h017006 INTEGER,
+ h017006_2000 INTEGER,
+ h017007 INTEGER,
+ h017007_2000 INTEGER,
+ h017008 INTEGER,
+ h017008_2000 INTEGER,
+ h017009 INTEGER,
+ h017009_2000 INTEGER,
+ h017010 INTEGER,
+ h017010_2000 INTEGER,
+ h017011 INTEGER,
+ h017011_2000 INTEGER,
+ h017012 INTEGER,
+ h017012_2000 INTEGER,
+ h017013 INTEGER,
+ h017013_2000 INTEGER,
+ h017014 INTEGER,
+ h017014_2000 INTEGER,
+ h017015 INTEGER,
+ h017015_2000 INTEGER,
+ h017016 INTEGER,
+ h017016_2000 INTEGER,
+ h017017 INTEGER,
+ h017017_2000 INTEGER,
+ h017018 INTEGER,
+ h017018_2000 INTEGER,
+ h017019 INTEGER,
+ h017019_2000 INTEGER,
+ h017020 INTEGER,
+ h017020_2000 INTEGER,
+ h017021 INTEGER,
+ h017021_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
61 tools/sql/ire_export/ire_H17A.sql
@@ -0,0 +1,61 @@
+-- H17A. TENURE BY AGE OF HOUSEHOLDER (WHITE ALONE HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h17a (
+ 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,
+ h017a001 INTEGER,
+ h017a001_2000 INTEGER,
+ h017a002 INTEGER,
+ h017a002_2000 INTEGER,
+ h017a003 INTEGER,
+ h017a003_2000 INTEGER,
+ h017a004 INTEGER,
+ h017a004_2000 INTEGER,
+ h017a005 INTEGER,
+ h017a005_2000 INTEGER,
+ h017a006 INTEGER,
+ h017a006_2000 INTEGER,
+ h017a007 INTEGER,
+ h017a007_2000 INTEGER,
+ h017a008 INTEGER,
+ h017a008_2000 INTEGER,
+ h017a009 INTEGER,
+ h017a009_2000 INTEGER,
+ h017a010 INTEGER,
+ h017a010_2000 INTEGER,
+ h017a011 INTEGER,
+ h017a011_2000 INTEGER,
+ h017a012 INTEGER,
+ h017a012_2000 INTEGER,
+ h017a013 INTEGER,
+ h017a013_2000 INTEGER,
+ h017a014 INTEGER,
+ h017a014_2000 INTEGER,
+ h017a015 INTEGER,
+ h017a015_2000 INTEGER,
+ h017a016 INTEGER,
+ h017a016_2000 INTEGER,
+ h017a017 INTEGER,
+ h017a017_2000 INTEGER,
+ h017a018 INTEGER,
+ h017a018_2000 INTEGER,
+ h017a019 INTEGER,
+ h017a019_2000 INTEGER,
+ h017a020 INTEGER,
+ h017a020_2000 INTEGER,
+ h017a021 INTEGER,
+ h017a021_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
61 tools/sql/ire_export/ire_H17B.sql
@@ -0,0 +1,61 @@
+-- H17B. TENURE BY AGE OF HOUSEHOLDER (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h17b (
+ 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,
+ h017b001 INTEGER,
+ h017b001_2000 INTEGER,
+ h017b002 INTEGER,
+ h017b002_2000 INTEGER,
+ h017b003 INTEGER,
+ h017b003_2000 INTEGER,
+ h017b004 INTEGER,
+ h017b004_2000 INTEGER,
+ h017b005 INTEGER,
+ h017b005_2000 INTEGER,
+ h017b006 INTEGER,
+ h017b006_2000 INTEGER,
+ h017b007 INTEGER,
+ h017b007_2000 INTEGER,
+ h017b008 INTEGER,
+ h017b008_2000 INTEGER,
+ h017b009 INTEGER,
+ h017b009_2000 INTEGER,
+ h017b010 INTEGER,
+ h017b010_2000 INTEGER,
+ h017b011 INTEGER,
+ h017b011_2000 INTEGER,
+ h017b012 INTEGER,
+ h017b012_2000 INTEGER,
+ h017b013 INTEGER,
+ h017b013_2000 INTEGER,
+ h017b014 INTEGER,
+ h017b014_2000 INTEGER,
+ h017b015 INTEGER,
+ h017b015_2000 INTEGER,
+ h017b016 INTEGER,
+ h017b016_2000 INTEGER,
+ h017b017 INTEGER,
+ h017b017_2000 INTEGER,
+ h017b018 INTEGER,
+ h017b018_2000 INTEGER,
+ h017b019 INTEGER,
+ h017b019_2000 INTEGER,
+ h017b020 INTEGER,
+ h017b020_2000 INTEGER,
+ h017b021 INTEGER,
+ h017b021_2000 INTEGER,
+ PRIMARY KEY (geoid)
+);
View
61 tools/sql/ire_export/ire_H17C.sql
@@ -0,0 +1,61 @@
+-- H17C. TENURE BY AGE OF HOUSEHOLDER (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER)
+-- designed to work with the IRE Census bulk data exports
+-- see http://census.ire.org/data/bulkdata.html
+CREATE TABLE ire_h17c (
+ 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,
+ h017c001 INTEGER,
+ h017c001_2000 INTEGER,
+ h017c002 INTEGER,
+ h017c002_2000 INTEGER,
+ h017c003 INTEGER,