--
-- PostgreSQL database dump
--

-- Dumped from database version 9.5.1
-- Dumped by pg_dump version 9.5.1

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: census2000; Type: SCHEMA; Schema: -; Owner: census
--

CREATE SCHEMA census2000;


ALTER SCHEMA census2000 OWNER TO census;

SET search_path = census2000, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: sf10001; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10001 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text NOT NULL,
    p001001 bigint,
    p002001 bigint,
    p002002 bigint,
    p002003 bigint,
    p002004 bigint,
    p002005 bigint,
    p002006 bigint,
    p003001 bigint,
    p003002 bigint,
    p003003 bigint,
    p003004 bigint,
    p003005 bigint,
    p003006 bigint,
    p003007 bigint,
    p003008 bigint,
    p003009 bigint,
    p003010 bigint,
    p003011 bigint,
    p003012 bigint,
    p003013 bigint,
    p003014 bigint,
    p003015 bigint,
    p003016 bigint,
    p003017 bigint,
    p003018 bigint,
    p003019 bigint,
    p003020 bigint,
    p003021 bigint,
    p003022 bigint,
    p003023 bigint,
    p003024 bigint,
    p003025 bigint,
    p003026 bigint,
    p003027 bigint,
    p003028 bigint,
    p003029 bigint,
    p003030 bigint,
    p003031 bigint,
    p003032 bigint,
    p003033 bigint,
    p003034 bigint,
    p003035 bigint,
    p003036 bigint,
    p003037 bigint,
    p003038 bigint,
    p003039 bigint,
    p003040 bigint,
    p003041 bigint,
    p003042 bigint,
    p003043 bigint,
    p003044 bigint,
    p003045 bigint,
    p003046 bigint,
    p003047 bigint,
    p003048 bigint,
    p003049 bigint,
    p003050 bigint,
    p003051 bigint,
    p003052 bigint,
    p003053 bigint,
    p003054 bigint,
    p003055 bigint,
    p003056 bigint,
    p003057 bigint,
    p003058 bigint,
    p003059 bigint,
    p003060 bigint,
    p003061 bigint,
    p003062 bigint,
    p003063 bigint,
    p003064 bigint,
    p003065 bigint,
    p003066 bigint,
    p003067 bigint,
    p003068 bigint,
    p003069 bigint,
    p003070 bigint,
    p003071 bigint,
    p004001 bigint,
    p004002 bigint,
    p004003 bigint,
    p004004 bigint,
    p004005 bigint,
    p004006 bigint,
    p004007 bigint,
    p004008 bigint,
    p004009 bigint,
    p004010 bigint,
    p004011 bigint,
    p004012 bigint,
    p004013 bigint,
    p004014 bigint,
    p004015 bigint,
    p004016 bigint,
    p004017 bigint,
    p004018 bigint,
    p004019 bigint,
    p004020 bigint,
    p004021 bigint,
    p004022 bigint,
    p004023 bigint,
    p004024 bigint,
    p004025 bigint,
    p004026 bigint,
    p004027 bigint,
    p004028 bigint,
    p004029 bigint,
    p004030 bigint,
    p004031 bigint,
    p004032 bigint,
    p004033 bigint,
    p004034 bigint,
    p004035 bigint,
    p004036 bigint,
    p004037 bigint,
    p004038 bigint,
    p004039 bigint,
    p004040 bigint,
    p004041 bigint,
    p004042 bigint,
    p004043 bigint,
    p004044 bigint,
    p004045 bigint,
    p004046 bigint,
    p004047 bigint,
    p004048 bigint,
    p004049 bigint,
    p004050 bigint,
    p004051 bigint,
    p004052 bigint,
    p004053 bigint,
    p004054 bigint,
    p004055 bigint,
    p004056 bigint,
    p004057 bigint,
    p004058 bigint,
    p004059 bigint,
    p004060 bigint,
    p004061 bigint,
    p004062 bigint,
    p004063 bigint,
    p004064 bigint,
    p004065 bigint,
    p004066 bigint,
    p004067 bigint,
    p004068 bigint,
    p004069 bigint,
    p004070 bigint,
    p004071 bigint,
    p004072 bigint,
    p004073 bigint,
    p005001 bigint,
    p005002 bigint,
    p005003 bigint,
    p005004 bigint,
    p005005 bigint,
    p005006 bigint,
    p005007 bigint,
    p005008 bigint,
    p005009 bigint,
    p005010 bigint,
    p005011 bigint,
    p005012 bigint,
    p005013 bigint,
    p005014 bigint,
    p005015 bigint,
    p005016 bigint,
    p005017 bigint,
    p005018 bigint,
    p005019 bigint,
    p005020 bigint,
    p005021 bigint,
    p005022 bigint,
    p005023 bigint,
    p005024 bigint,
    p005025 bigint,
    p005026 bigint,
    p005027 bigint,
    p005028 bigint,
    p005029 bigint,
    p005030 bigint,
    p005031 bigint,
    p005032 bigint,
    p005033 bigint,
    p005034 bigint,
    p005035 bigint,
    p005036 bigint,
    p005037 bigint,
    p005038 bigint,
    p005039 bigint,
    p005040 bigint,
    p005041 bigint,
    p005042 bigint,
    p005043 bigint,
    p005044 bigint,
    p005045 bigint,
    p005046 bigint,
    p005047 bigint,
    p005048 bigint,
    p005049 bigint,
    p005050 bigint,
    p005051 bigint,
    p005052 bigint,
    p005053 bigint,
    p005054 bigint,
    p005055 bigint,
    p005056 bigint,
    p005057 bigint,
    p005058 bigint,
    p005059 bigint,
    p005060 bigint,
    p005061 bigint,
    p005062 bigint,
    p005063 bigint,
    p005064 bigint,
    p005065 bigint,
    p005066 bigint,
    p005067 bigint,
    p005068 bigint,
    p005069 bigint,
    p005070 bigint,
    p005071 bigint
);


ALTER TABLE sf10001 OWNER TO census;

--
-- Name: sf10002; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10002 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    p006001 bigint,
    p006002 bigint,
    p006003 bigint,
    p006004 bigint,
    p006005 bigint,
    p006006 bigint,
    p006007 bigint,
    p006008 bigint,
    p006009 bigint,
    p006010 bigint,
    p006011 bigint,
    p006012 bigint,
    p006013 bigint,
    p006014 bigint,
    p006015 bigint,
    p006016 bigint,
    p006017 bigint,
    p006018 bigint,
    p006019 bigint,
    p006020 bigint,
    p006021 bigint,
    p006022 bigint,
    p006023 bigint,
    p006024 bigint,
    p006025 bigint,
    p006026 bigint,
    p006027 bigint,
    p006028 bigint,
    p006029 bigint,
    p006030 bigint,
    p006031 bigint,
    p006032 bigint,
    p006033 bigint,
    p006034 bigint,
    p006035 bigint,
    p006036 bigint,
    p006037 bigint,
    p006038 bigint,
    p006039 bigint,
    p006040 bigint,
    p006041 bigint,
    p006042 bigint,
    p006043 bigint,
    p006044 bigint,
    p006045 bigint,
    p006046 bigint,
    p006047 bigint,
    p006048 bigint,
    p006049 bigint,
    p006050 bigint,
    p006051 bigint,
    p006052 bigint,
    p006053 bigint,
    p006054 bigint,
    p006055 bigint,
    p006056 bigint,
    p006057 bigint,
    p006058 bigint,
    p006059 bigint,
    p006060 bigint,
    p006061 bigint,
    p006062 bigint,
    p006063 bigint,
    p006064 bigint,
    p006065 bigint,
    p006066 bigint,
    p006067 bigint,
    p006068 bigint,
    p006069 bigint,
    p006070 bigint,
    p006071 bigint,
    p006072 bigint,
    p006073 bigint,
    p007001 bigint,
    p007002 bigint,
    p007003 bigint,
    p007004 bigint,
    p007005 bigint,
    p007006 bigint,
    p007007 bigint,
    p007008 bigint,
    p008001 bigint,
    p008002 bigint,
    p008003 bigint,
    p008004 bigint,
    p008005 bigint,
    p008006 bigint,
    p008007 bigint,
    p008008 bigint,
    p008009 bigint,
    p008010 bigint,
    p008011 bigint,
    p008012 bigint,
    p008013 bigint,
    p008014 bigint,
    p008015 bigint,
    p008016 bigint,
    p008017 bigint,
    p009001 bigint,
    p009002 bigint,
    p009003 bigint,
    p009004 bigint,
    p009005 bigint,
    p009006 bigint,
    p009007 bigint,
    p010001 bigint,
    p010002 bigint,
    p010003 bigint,
    p010004 bigint,
    p010005 bigint,
    p010006 bigint,
    p010007 bigint,
    p010008 bigint,
    p010009 bigint,
    p010010 bigint,
    p010011 bigint,
    p010012 bigint,
    p010013 bigint,
    p010014 bigint,
    p010015 bigint,
    p011001 bigint,
    p012001 bigint,
    p012002 bigint,
    p012003 bigint,
    p012004 bigint,
    p012005 bigint,
    p012006 bigint,
    p012007 bigint,
    p012008 bigint,
    p012009 bigint,
    p012010 bigint,
    p012011 bigint,
    p012012 bigint,
    p012013 bigint,
    p012014 bigint,
    p012015 bigint,
    p012016 bigint,
    p012017 bigint,
    p012018 bigint,
    p012019 bigint,
    p012020 bigint,
    p012021 bigint,
    p012022 bigint,
    p012023 bigint,
    p012024 bigint,
    p012025 bigint,
    p012026 bigint,
    p012027 bigint,
    p012028 bigint,
    p012029 bigint,
    p012030 bigint,
    p012031 bigint,
    p012032 bigint,
    p012033 bigint,
    p012034 bigint,
    p012035 bigint,
    p012036 bigint,
    p012037 bigint,
    p012038 bigint,
    p012039 bigint,
    p012040 bigint,
    p012041 bigint,
    p012042 bigint,
    p012043 bigint,
    p012044 bigint,
    p012045 bigint,
    p012046 bigint,
    p012047 bigint,
    p012048 bigint,
    p012049 bigint,
    p013001 double precision,
    p013002 double precision,
    p013003 double precision,
    p014001 bigint,
    p014002 bigint,
    p014003 bigint,
    p014004 bigint,
    p014005 bigint,
    p014006 bigint,
    p014007 bigint,
    p014008 bigint,
    p014009 bigint,
    p014010 bigint,
    p014011 bigint,
    p014012 bigint,
    p014013 bigint,
    p014014 bigint,
    p014015 bigint,
    p014016 bigint,
    p014017 bigint,
    p014018 bigint,
    p014019 bigint,
    p014020 bigint,
    p014021 bigint,
    p014022 bigint,
    p014023 bigint,
    p014024 bigint,
    p014025 bigint,
    p014026 bigint,
    p014027 bigint,
    p014028 bigint,
    p014029 bigint,
    p014030 bigint,
    p014031 bigint,
    p014032 bigint,
    p014033 bigint,
    p014034 bigint,
    p014035 bigint,
    p014036 bigint,
    p014037 bigint,
    p014038 bigint,
    p014039 bigint,
    p014040 bigint,
    p014041 bigint,
    p014042 bigint,
    p014043 bigint,
    p015001 bigint,
    p016001 bigint,
    p017001 double precision,
    p018001 bigint,
    p018002 bigint,
    p018003 bigint,
    p018004 bigint,
    p018005 bigint,
    p018006 bigint,
    p018007 bigint,
    p018008 bigint,
    p018009 bigint,
    p018010 bigint,
    p018011 bigint,
    p018012 bigint,
    p018013 bigint,
    p018014 bigint,
    p018015 bigint,
    p018016 bigint,
    p018017 bigint,
    p018018 bigint,
    p018019 bigint
);


ALTER TABLE sf10002 OWNER TO census;

--
-- Name: sf10003; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10003 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    p019001 bigint,
    p019002 bigint,
    p019003 bigint,
    p019004 bigint,
    p019005 bigint,
    p019006 bigint,
    p019007 bigint,
    p019008 bigint,
    p019009 bigint,
    p019010 bigint,
    p019011 bigint,
    p019012 bigint,
    p019013 bigint,
    p019014 bigint,
    p019015 bigint,
    p019016 bigint,
    p019017 bigint,
    p019018 bigint,
    p019019 bigint,
    p020001 bigint,
    p020002 bigint,
    p020003 bigint,
    p020004 bigint,
    p020005 bigint,
    p020006 bigint,
    p020007 bigint,
    p020008 bigint,
    p020009 bigint,
    p020010 bigint,
    p020011 bigint,
    p020012 bigint,
    p020013 bigint,
    p020014 bigint,
    p020015 bigint,
    p020016 bigint,
    p020017 bigint,
    p020018 bigint,
    p020019 bigint,
    p020020 bigint,
    p020021 bigint,
    p020022 bigint,
    p020023 bigint,
    p020024 bigint,
    p020025 bigint,
    p020026 bigint,
    p020027 bigint,
    p020028 bigint,
    p020029 bigint,
    p020030 bigint,
    p020031 bigint,
    p021001 bigint,
    p021002 bigint,
    p021003 bigint,
    p021004 bigint,
    p021005 bigint,
    p021006 bigint,
    p021007 bigint,
    p021008 bigint,
    p021009 bigint,
    p021010 bigint,
    p021011 bigint,
    p021012 bigint,
    p021013 bigint,
    p021014 bigint,
    p021015 bigint,
    p021016 bigint,
    p021017 bigint,
    p021018 bigint,
    p021019 bigint,
    p022001 bigint,
    p022002 bigint,
    p022003 bigint,
    p022004 bigint,
    p022005 bigint,
    p022006 bigint,
    p022007 bigint,
    p022008 bigint,
    p022009 bigint,
    p022010 bigint,
    p022011 bigint,
    p023001 bigint,
    p023002 bigint,
    p023003 bigint,
    p023004 bigint,
    p023005 bigint,
    p023006 bigint,
    p023007 bigint,
    p023008 bigint,
    p023009 bigint,
    p023010 bigint,
    p023011 bigint,
    p024001 bigint,
    p024002 bigint,
    p024003 bigint,
    p024004 bigint,
    p024005 bigint,
    p024006 bigint,
    p024007 bigint,
    p024008 bigint,
    p024009 bigint,
    p024010 bigint,
    p024011 bigint,
    p025001 bigint,
    p025002 bigint,
    p025003 bigint,
    p026001 bigint,
    p026002 bigint,
    p026003 bigint,
    p026004 bigint,
    p026005 bigint,
    p026006 bigint,
    p026007 bigint,
    p026008 bigint,
    p026009 bigint,
    p026010 bigint,
    p026011 bigint,
    p026012 bigint,
    p026013 bigint,
    p026014 bigint,
    p026015 bigint,
    p026016 bigint,
    p027001 bigint,
    p027002 bigint,
    p027003 bigint,
    p027004 bigint,
    p027005 bigint,
    p027006 bigint,
    p027007 bigint,
    p027008 bigint,
    p027009 bigint,
    p027010 bigint,
    p027011 bigint,
    p027012 bigint,
    p027013 bigint,
    p027014 bigint,
    p027015 bigint,
    p027016 bigint,
    p027017 bigint,
    p027018 bigint,
    p027019 bigint,
    p027020 bigint,
    p027021 bigint,
    p027022 bigint,
    p027023 bigint,
    p027024 bigint,
    p027025 bigint,
    p027026 bigint,
    p027027 bigint,
    p028001 bigint,
    p028002 bigint,
    p028003 bigint,
    p028004 bigint,
    p028005 bigint,
    p028006 bigint,
    p028007 bigint,
    p028008 bigint,
    p028009 bigint,
    p028010 bigint,
    p028011 bigint,
    p028012 bigint,
    p028013 bigint,
    p028014 bigint,
    p028015 bigint,
    p028016 bigint,
    p028017 bigint,
    p029001 bigint,
    p029002 bigint,
    p029003 bigint,
    p029004 bigint,
    p029005 bigint,
    p029006 bigint,
    p029007 bigint,
    p029008 bigint,
    p029009 bigint,
    p029010 bigint,
    p029011 bigint,
    p029012 bigint,
    p029013 bigint,
    p029014 bigint,
    p029015 bigint,
    p029016 bigint,
    p029017 bigint,
    p029018 bigint,
    p029019 bigint,
    p029020 bigint,
    p029021 bigint,
    p029022 bigint,
    p029023 bigint,
    p029024 bigint,
    p029025 bigint,
    p029026 bigint,
    p029027 bigint,
    p029028 bigint,
    p029029 bigint,
    p029030 bigint,
    p029031 bigint,
    p029032 bigint,
    p029033 bigint,
    p029034 bigint,
    p029035 bigint,
    p029036 bigint,
    p029037 bigint,
    p029038 bigint,
    p029039 bigint,
    p029040 bigint,
    p029041 bigint,
    p029042 bigint,
    p029043 bigint,
    p029044 bigint,
    p029045 bigint,
    p029046 bigint,
    p030001 bigint,
    p030002 bigint,
    p030003 bigint,
    p030004 bigint,
    p030005 bigint,
    p030006 bigint,
    p030007 bigint,
    p030008 bigint,
    p030009 bigint,
    p030010 bigint,
    p030011 bigint,
    p030012 bigint,
    p030013 bigint,
    p030014 bigint,
    p030015 bigint,
    p030016 bigint,
    p030017 bigint,
    p030018 bigint,
    p030019 bigint,
    p030020 bigint,
    p030021 bigint,
    p030022 bigint,
    p031001 bigint,
    p032001 bigint,
    p033001 double precision
);


ALTER TABLE sf10003 OWNER TO census;

--
-- Name: sf10004; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10004 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    p034001 bigint,
    p034002 bigint,
    p034003 bigint,
    p034004 bigint,
    p034005 bigint,
    p034006 bigint,
    p034007 bigint,
    p034008 bigint,
    p034009 bigint,
    p034010 bigint,
    p034011 bigint,
    p034012 bigint,
    p034013 bigint,
    p034014 bigint,
    p034015 bigint,
    p034016 bigint,
    p034017 bigint,
    p034018 bigint,
    p034019 bigint,
    p034020 bigint,
    p035001 bigint,
    p035002 bigint,
    p035003 bigint,
    p035004 bigint,
    p035005 bigint,
    p035006 bigint,
    p035007 bigint,
    p035008 bigint,
    p035009 bigint,
    p035010 bigint,
    p035011 bigint,
    p035012 bigint,
    p035013 bigint,
    p035014 bigint,
    p035015 bigint,
    p035016 bigint,
    p035017 bigint,
    p035018 bigint,
    p035019 bigint,
    p035020 bigint,
    p036001 bigint,
    p036002 bigint,
    p036003 bigint,
    p036004 bigint,
    p036005 bigint,
    p036006 bigint,
    p036007 bigint,
    p036008 bigint,
    p036009 bigint,
    p036010 bigint,
    p036011 bigint,
    p036012 bigint,
    p036013 bigint,
    p036014 bigint,
    p036015 bigint,
    p036016 bigint,
    p036017 bigint,
    p036018 bigint,
    p036019 bigint,
    p036020 bigint,
    p037001 bigint,
    p037002 bigint,
    p037003 bigint,
    p037004 bigint,
    p037005 bigint,
    p037006 bigint,
    p037007 bigint,
    p037008 bigint,
    p037009 bigint,
    p038001 bigint,
    p038002 bigint,
    p038003 bigint,
    p038004 bigint,
    p038005 bigint,
    p038006 bigint,
    p038007 bigint,
    p038008 bigint,
    p038009 bigint,
    p038010 bigint,
    p038011 bigint,
    p038012 bigint,
    p038013 bigint,
    p038014 bigint,
    p038015 bigint,
    p038016 bigint,
    p038017 bigint,
    p038018 bigint,
    p038019 bigint,
    p038020 bigint,
    p038021 bigint,
    p038022 bigint,
    p038023 bigint,
    p038024 bigint,
    p038025 bigint,
    p038026 bigint,
    p038027 bigint,
    p038028 bigint,
    p038029 bigint,
    p038030 bigint,
    p038031 bigint,
    p038032 bigint,
    p038033 bigint,
    p038034 bigint,
    p038035 bigint,
    p038036 bigint,
    p038037 bigint,
    p038038 bigint,
    p038039 bigint,
    p038040 bigint,
    p038041 bigint,
    p038042 bigint,
    p038043 bigint,
    p038044 bigint,
    p038045 bigint,
    p038046 bigint,
    p038047 bigint,
    p038048 bigint,
    p038049 bigint,
    p038050 bigint,
    p038051 bigint,
    p038052 bigint,
    p038053 bigint,
    p038054 bigint,
    p038055 bigint,
    p038056 bigint,
    p038057 bigint,
    p039001 bigint,
    p039002 bigint,
    p039003 bigint,
    p039004 bigint,
    p039005 bigint,
    p040001 bigint,
    p040002 bigint,
    p040003 bigint,
    p041001 bigint,
    p041002 bigint,
    p041003 bigint,
    p042001 bigint,
    p042002 bigint,
    p042003 bigint,
    p043001 bigint,
    p043002 bigint,
    p043003 bigint,
    p044001 bigint,
    p044002 bigint,
    p044003 bigint,
    p045001 bigint,
    p045002 bigint,
    p045003 bigint
);


ALTER TABLE sf10004 OWNER TO census;

--
-- Name: sf10005; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10005 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    p012a001 bigint,
    p012a002 bigint,
    p012a003 bigint,
    p012a004 bigint,
    p012a005 bigint,
    p012a006 bigint,
    p012a007 bigint,
    p012a008 bigint,
    p012a009 bigint,
    p012a010 bigint,
    p012a011 bigint,
    p012a012 bigint,
    p012a013 bigint,
    p012a014 bigint,
    p012a015 bigint,
    p012a016 bigint,
    p012a017 bigint,
    p012a018 bigint,
    p012a019 bigint,
    p012a020 bigint,
    p012a021 bigint,
    p012a022 bigint,
    p012a023 bigint,
    p012a024 bigint,
    p012a025 bigint,
    p012a026 bigint,
    p012a027 bigint,
    p012a028 bigint,
    p012a029 bigint,
    p012a030 bigint,
    p012a031 bigint,
    p012a032 bigint,
    p012a033 bigint,
    p012a034 bigint,
    p012a035 bigint,
    p012a036 bigint,
    p012a037 bigint,
    p012a038 bigint,
    p012a039 bigint,
    p012a040 bigint,
    p012a041 bigint,
    p012a042 bigint,
    p012a043 bigint,
    p012a044 bigint,
    p012a045 bigint,
    p012a046 bigint,
    p012a047 bigint,
    p012a048 bigint,
    p012a049 bigint,
    p012b001 bigint,
    p012b002 bigint,
    p012b003 bigint,
    p012b004 bigint,
    p012b005 bigint,
    p012b006 bigint,
    p012b007 bigint,
    p012b008 bigint,
    p012b009 bigint,
    p012b010 bigint,
    p012b011 bigint,
    p012b012 bigint,
    p012b013 bigint,
    p012b014 bigint,
    p012b015 bigint,
    p012b016 bigint,
    p012b017 bigint,
    p012b018 bigint,
    p012b019 bigint,
    p012b020 bigint,
    p012b021 bigint,
    p012b022 bigint,
    p012b023 bigint,
    p012b024 bigint,
    p012b025 bigint,
    p012b026 bigint,
    p012b027 bigint,
    p012b028 bigint,
    p012b029 bigint,
    p012b030 bigint,
    p012b031 bigint,
    p012b032 bigint,
    p012b033 bigint,
    p012b034 bigint,
    p012b035 bigint,
    p012b036 bigint,
    p012b037 bigint,
    p012b038 bigint,
    p012b039 bigint,
    p012b040 bigint,
    p012b041 bigint,
    p012b042 bigint,
    p012b043 bigint,
    p012b044 bigint,
    p012b045 bigint,
    p012b046 bigint,
    p012b047 bigint,
    p012b048 bigint,
    p012b049 bigint,
    p012c001 bigint,
    p012c002 bigint,
    p012c003 bigint,
    p012c004 bigint,
    p012c005 bigint,
    p012c006 bigint,
    p012c007 bigint,
    p012c008 bigint,
    p012c009 bigint,
    p012c010 bigint,
    p012c011 bigint,
    p012c012 bigint,
    p012c013 bigint,
    p012c014 bigint,
    p012c015 bigint,
    p012c016 bigint,
    p012c017 bigint,
    p012c018 bigint,
    p012c019 bigint,
    p012c020 bigint,
    p012c021 bigint,
    p012c022 bigint,
    p012c023 bigint,
    p012c024 bigint,
    p012c025 bigint,
    p012c026 bigint,
    p012c027 bigint,
    p012c028 bigint,
    p012c029 bigint,
    p012c030 bigint,
    p012c031 bigint,
    p012c032 bigint,
    p012c033 bigint,
    p012c034 bigint,
    p012c035 bigint,
    p012c036 bigint,
    p012c037 bigint,
    p012c038 bigint,
    p012c039 bigint,
    p012c040 bigint,
    p012c041 bigint,
    p012c042 bigint,
    p012c043 bigint,
    p012c044 bigint,
    p012c045 bigint,
    p012c046 bigint,
    p012c047 bigint,
    p012c048 bigint,
    p012c049 bigint,
    p012d001 bigint,
    p012d002 bigint,
    p012d003 bigint,
    p012d004 bigint,
    p012d005 bigint,
    p012d006 bigint,
    p012d007 bigint,
    p012d008 bigint,
    p012d009 bigint,
    p012d010 bigint,
    p012d011 bigint,
    p012d012 bigint,
    p012d013 bigint,
    p012d014 bigint,
    p012d015 bigint,
    p012d016 bigint,
    p012d017 bigint,
    p012d018 bigint,
    p012d019 bigint,
    p012d020 bigint,
    p012d021 bigint,
    p012d022 bigint,
    p012d023 bigint,
    p012d024 bigint,
    p012d025 bigint,
    p012d026 bigint,
    p012d027 bigint,
    p012d028 bigint,
    p012d029 bigint,
    p012d030 bigint,
    p012d031 bigint,
    p012d032 bigint,
    p012d033 bigint,
    p012d034 bigint,
    p012d035 bigint,
    p012d036 bigint,
    p012d037 bigint,
    p012d038 bigint,
    p012d039 bigint,
    p012d040 bigint,
    p012d041 bigint,
    p012d042 bigint,
    p012d043 bigint,
    p012d044 bigint,
    p012d045 bigint,
    p012d046 bigint,
    p012d047 bigint,
    p012d048 bigint,
    p012d049 bigint,
    p012e001 bigint,
    p012e002 bigint,
    p012e003 bigint,
    p012e004 bigint,
    p012e005 bigint,
    p012e006 bigint,
    p012e007 bigint,
    p012e008 bigint,
    p012e009 bigint,
    p012e010 bigint,
    p012e011 bigint,
    p012e012 bigint,
    p012e013 bigint,
    p012e014 bigint,
    p012e015 bigint,
    p012e016 bigint,
    p012e017 bigint,
    p012e018 bigint,
    p012e019 bigint,
    p012e020 bigint,
    p012e021 bigint,
    p012e022 bigint,
    p012e023 bigint,
    p012e024 bigint,
    p012e025 bigint,
    p012e026 bigint,
    p012e027 bigint,
    p012e028 bigint,
    p012e029 bigint,
    p012e030 bigint,
    p012e031 bigint,
    p012e032 bigint,
    p012e033 bigint,
    p012e034 bigint,
    p012e035 bigint,
    p012e036 bigint,
    p012e037 bigint,
    p012e038 bigint,
    p012e039 bigint,
    p012e040 bigint,
    p012e041 bigint,
    p012e042 bigint,
    p012e043 bigint,
    p012e044 bigint,
    p012e045 bigint,
    p012e046 bigint,
    p012e047 bigint,
    p012e048 bigint,
    p012e049 bigint
);


ALTER TABLE sf10005 OWNER TO census;

--
-- Name: sf10006; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10006 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    p012f001 bigint,
    p012f002 bigint,
    p012f003 bigint,
    p012f004 bigint,
    p012f005 bigint,
    p012f006 bigint,
    p012f007 bigint,
    p012f008 bigint,
    p012f009 bigint,
    p012f010 bigint,
    p012f011 bigint,
    p012f012 bigint,
    p012f013 bigint,
    p012f014 bigint,
    p012f015 bigint,
    p012f016 bigint,
    p012f017 bigint,
    p012f018 bigint,
    p012f019 bigint,
    p012f020 bigint,
    p012f021 bigint,
    p012f022 bigint,
    p012f023 bigint,
    p012f024 bigint,
    p012f025 bigint,
    p012f026 bigint,
    p012f027 bigint,
    p012f028 bigint,
    p012f029 bigint,
    p012f030 bigint,
    p012f031 bigint,
    p012f032 bigint,
    p012f033 bigint,
    p012f034 bigint,
    p012f035 bigint,
    p012f036 bigint,
    p012f037 bigint,
    p012f038 bigint,
    p012f039 bigint,
    p012f040 bigint,
    p012f041 bigint,
    p012f042 bigint,
    p012f043 bigint,
    p012f044 bigint,
    p012f045 bigint,
    p012f046 bigint,
    p012f047 bigint,
    p012f048 bigint,
    p012f049 bigint,
    p012g001 bigint,
    p012g002 bigint,
    p012g003 bigint,
    p012g004 bigint,
    p012g005 bigint,
    p012g006 bigint,
    p012g007 bigint,
    p012g008 bigint,
    p012g009 bigint,
    p012g010 bigint,
    p012g011 bigint,
    p012g012 bigint,
    p012g013 bigint,
    p012g014 bigint,
    p012g015 bigint,
    p012g016 bigint,
    p012g017 bigint,
    p012g018 bigint,
    p012g019 bigint,
    p012g020 bigint,
    p012g021 bigint,
    p012g022 bigint,
    p012g023 bigint,
    p012g024 bigint,
    p012g025 bigint,
    p012g026 bigint,
    p012g027 bigint,
    p012g028 bigint,
    p012g029 bigint,
    p012g030 bigint,
    p012g031 bigint,
    p012g032 bigint,
    p012g033 bigint,
    p012g034 bigint,
    p012g035 bigint,
    p012g036 bigint,
    p012g037 bigint,
    p012g038 bigint,
    p012g039 bigint,
    p012g040 bigint,
    p012g041 bigint,
    p012g042 bigint,
    p012g043 bigint,
    p012g044 bigint,
    p012g045 bigint,
    p012g046 bigint,
    p012g047 bigint,
    p012g048 bigint,
    p012g049 bigint,
    p012h001 bigint,
    p012h002 bigint,
    p012h003 bigint,
    p012h004 bigint,
    p012h005 bigint,
    p012h006 bigint,
    p012h007 bigint,
    p012h008 bigint,
    p012h009 bigint,
    p012h010 bigint,
    p012h011 bigint,
    p012h012 bigint,
    p012h013 bigint,
    p012h014 bigint,
    p012h015 bigint,
    p012h016 bigint,
    p012h017 bigint,
    p012h018 bigint,
    p012h019 bigint,
    p012h020 bigint,
    p012h021 bigint,
    p012h022 bigint,
    p012h023 bigint,
    p012h024 bigint,
    p012h025 bigint,
    p012h026 bigint,
    p012h027 bigint,
    p012h028 bigint,
    p012h029 bigint,
    p012h030 bigint,
    p012h031 bigint,
    p012h032 bigint,
    p012h033 bigint,
    p012h034 bigint,
    p012h035 bigint,
    p012h036 bigint,
    p012h037 bigint,
    p012h038 bigint,
    p012h039 bigint,
    p012h040 bigint,
    p012h041 bigint,
    p012h042 bigint,
    p012h043 bigint,
    p012h044 bigint,
    p012h045 bigint,
    p012h046 bigint,
    p012h047 bigint,
    p012h048 bigint,
    p012h049 bigint,
    p012i001 bigint,
    p012i002 bigint,
    p012i003 bigint,
    p012i004 bigint,
    p012i005 bigint,
    p012i006 bigint,
    p012i007 bigint,
    p012i008 bigint,
    p012i009 bigint,
    p012i010 bigint,
    p012i011 bigint,
    p012i012 bigint,
    p012i013 bigint,
    p012i014 bigint,
    p012i015 bigint,
    p012i016 bigint,
    p012i017 bigint,
    p012i018 bigint,
    p012i019 bigint,
    p012i020 bigint,
    p012i021 bigint,
    p012i022 bigint,
    p012i023 bigint,
    p012i024 bigint,
    p012i025 bigint,
    p012i026 bigint,
    p012i027 bigint,
    p012i028 bigint,
    p012i029 bigint,
    p012i030 bigint,
    p012i031 bigint,
    p012i032 bigint,
    p012i033 bigint,
    p012i034 bigint,
    p012i035 bigint,
    p012i036 bigint,
    p012i037 bigint,
    p012i038 bigint,
    p012i039 bigint,
    p012i040 bigint,
    p012i041 bigint,
    p012i042 bigint,
    p012i043 bigint,
    p012i044 bigint,
    p012i045 bigint,
    p012i046 bigint,
    p012i047 bigint,
    p012i048 bigint,
    p012i049 bigint,
    p013a001 double precision,
    p013a002 double precision,
    p013a003 double precision,
    p013b001 double precision,
    p013b002 double precision,
    p013b003 double precision,
    p013c001 double precision,
    p013c002 double precision,
    p013c003 double precision,
    p013d001 double precision,
    p013d002 double precision,
    p013d003 double precision,
    p013e001 double precision,
    p013e002 double precision,
    p013e003 double precision,
    p013f001 double precision,
    p013f002 double precision,
    p013f003 double precision,
    p013g001 double precision,
    p013g002 double precision,
    p013g003 double precision,
    p013h001 double precision,
    p013h002 double precision,
    p013h003 double precision,
    p013i001 double precision,
    p013i002 double precision,
    p013i003 double precision,
    p015a001 bigint,
    p015b001 bigint,
    p015c001 bigint,
    p015d001 bigint,
    p015e001 bigint,
    p015f001 bigint,
    p015g001 bigint,
    p015h001 bigint,
    p015i001 bigint,
    p016a001 bigint,
    p016b001 bigint,
    p016c001 bigint,
    p016d001 bigint,
    p016e001 bigint,
    p016f001 bigint,
    p016g001 bigint,
    p016h001 bigint,
    p016i001 bigint
);


ALTER TABLE sf10006 OWNER TO census;

--
-- Name: sf10007; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10007 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    p017a001 double precision,
    p017b001 double precision,
    p017c001 double precision,
    p017d001 double precision,
    p017e001 double precision,
    p017f001 double precision,
    p017g001 double precision,
    p017h001 double precision,
    p017i001 double precision,
    p026a001 bigint,
    p026a002 bigint,
    p026a003 bigint,
    p026a004 bigint,
    p026a005 bigint,
    p026a006 bigint,
    p026a007 bigint,
    p026a008 bigint,
    p026a009 bigint,
    p026a010 bigint,
    p026a011 bigint,
    p026a012 bigint,
    p026a013 bigint,
    p026a014 bigint,
    p026a015 bigint,
    p026a016 bigint,
    p026b001 bigint,
    p026b002 bigint,
    p026b003 bigint,
    p026b004 bigint,
    p026b005 bigint,
    p026b006 bigint,
    p026b007 bigint,
    p026b008 bigint,
    p026b009 bigint,
    p026b010 bigint,
    p026b011 bigint,
    p026b012 bigint,
    p026b013 bigint,
    p026b014 bigint,
    p026b015 bigint,
    p026b016 bigint,
    p026c001 bigint,
    p026c002 bigint,
    p026c003 bigint,
    p026c004 bigint,
    p026c005 bigint,
    p026c006 bigint,
    p026c007 bigint,
    p026c008 bigint,
    p026c009 bigint,
    p026c010 bigint,
    p026c011 bigint,
    p026c012 bigint,
    p026c013 bigint,
    p026c014 bigint,
    p026c015 bigint,
    p026c016 bigint,
    p026d001 bigint,
    p026d002 bigint,
    p026d003 bigint,
    p026d004 bigint,
    p026d005 bigint,
    p026d006 bigint,
    p026d007 bigint,
    p026d008 bigint,
    p026d009 bigint,
    p026d010 bigint,
    p026d011 bigint,
    p026d012 bigint,
    p026d013 bigint,
    p026d014 bigint,
    p026d015 bigint,
    p026d016 bigint,
    p026e001 bigint,
    p026e002 bigint,
    p026e003 bigint,
    p026e004 bigint,
    p026e005 bigint,
    p026e006 bigint,
    p026e007 bigint,
    p026e008 bigint,
    p026e009 bigint,
    p026e010 bigint,
    p026e011 bigint,
    p026e012 bigint,
    p026e013 bigint,
    p026e014 bigint,
    p026e015 bigint,
    p026e016 bigint,
    p026f001 bigint,
    p026f002 bigint,
    p026f003 bigint,
    p026f004 bigint,
    p026f005 bigint,
    p026f006 bigint,
    p026f007 bigint,
    p026f008 bigint,
    p026f009 bigint,
    p026f010 bigint,
    p026f011 bigint,
    p026f012 bigint,
    p026f013 bigint,
    p026f014 bigint,
    p026f015 bigint,
    p026f016 bigint,
    p026g001 bigint,
    p026g002 bigint,
    p026g003 bigint,
    p026g004 bigint,
    p026g005 bigint,
    p026g006 bigint,
    p026g007 bigint,
    p026g008 bigint,
    p026g009 bigint,
    p026g010 bigint,
    p026g011 bigint,
    p026g012 bigint,
    p026g013 bigint,
    p026g014 bigint,
    p026g015 bigint,
    p026g016 bigint,
    p026h001 bigint,
    p026h002 bigint,
    p026h003 bigint,
    p026h004 bigint,
    p026h005 bigint,
    p026h006 bigint,
    p026h007 bigint,
    p026h008 bigint,
    p026h009 bigint,
    p026h010 bigint,
    p026h011 bigint,
    p026h012 bigint,
    p026h013 bigint,
    p026h014 bigint,
    p026h015 bigint,
    p026h016 bigint,
    p026i001 bigint,
    p026i002 bigint,
    p026i003 bigint,
    p026i004 bigint,
    p026i005 bigint,
    p026i006 bigint,
    p026i007 bigint,
    p026i008 bigint,
    p026i009 bigint,
    p026i010 bigint,
    p026i011 bigint,
    p026i012 bigint,
    p026i013 bigint,
    p026i014 bigint,
    p026i015 bigint,
    p026i016 bigint,
    p027a001 bigint,
    p027a002 bigint,
    p027a003 bigint,
    p027a004 bigint,
    p027a005 bigint,
    p027a006 bigint,
    p027a007 bigint,
    p027a008 bigint,
    p027a009 bigint,
    p027a010 bigint,
    p027a011 bigint,
    p027a012 bigint,
    p027a013 bigint,
    p027a014 bigint,
    p027a015 bigint,
    p027a016 bigint,
    p027a017 bigint,
    p027a018 bigint,
    p027a019 bigint,
    p027a020 bigint,
    p027a021 bigint,
    p027a022 bigint,
    p027a023 bigint,
    p027a024 bigint,
    p027a025 bigint,
    p027a026 bigint,
    p027a027 bigint,
    p027b001 bigint,
    p027b002 bigint,
    p027b003 bigint,
    p027b004 bigint,
    p027b005 bigint,
    p027b006 bigint,
    p027b007 bigint,
    p027b008 bigint,
    p027b009 bigint,
    p027b010 bigint,
    p027b011 bigint,
    p027b012 bigint,
    p027b013 bigint,
    p027b014 bigint,
    p027b015 bigint,
    p027b016 bigint,
    p027b017 bigint,
    p027b018 bigint,
    p027b019 bigint,
    p027b020 bigint,
    p027b021 bigint,
    p027b022 bigint,
    p027b023 bigint,
    p027b024 bigint,
    p027b025 bigint,
    p027b026 bigint,
    p027b027 bigint,
    p027c001 bigint,
    p027c002 bigint,
    p027c003 bigint,
    p027c004 bigint,
    p027c005 bigint,
    p027c006 bigint,
    p027c007 bigint,
    p027c008 bigint,
    p027c009 bigint,
    p027c010 bigint,
    p027c011 bigint,
    p027c012 bigint,
    p027c013 bigint,
    p027c014 bigint,
    p027c015 bigint,
    p027c016 bigint,
    p027c017 bigint,
    p027c018 bigint,
    p027c019 bigint,
    p027c020 bigint,
    p027c021 bigint,
    p027c022 bigint,
    p027c023 bigint,
    p027c024 bigint,
    p027c025 bigint,
    p027c026 bigint,
    p027c027 bigint
);


ALTER TABLE sf10007 OWNER TO census;

--
-- Name: sf10008; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10008 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    p027d001 bigint,
    p027d002 bigint,
    p027d003 bigint,
    p027d004 bigint,
    p027d005 bigint,
    p027d006 bigint,
    p027d007 bigint,
    p027d008 bigint,
    p027d009 bigint,
    p027d010 bigint,
    p027d011 bigint,
    p027d012 bigint,
    p027d013 bigint,
    p027d014 bigint,
    p027d015 bigint,
    p027d016 bigint,
    p027d017 bigint,
    p027d018 bigint,
    p027d019 bigint,
    p027d020 bigint,
    p027d021 bigint,
    p027d022 bigint,
    p027d023 bigint,
    p027d024 bigint,
    p027d025 bigint,
    p027d026 bigint,
    p027d027 bigint,
    p027e001 bigint,
    p027e002 bigint,
    p027e003 bigint,
    p027e004 bigint,
    p027e005 bigint,
    p027e006 bigint,
    p027e007 bigint,
    p027e008 bigint,
    p027e009 bigint,
    p027e010 bigint,
    p027e011 bigint,
    p027e012 bigint,
    p027e013 bigint,
    p027e014 bigint,
    p027e015 bigint,
    p027e016 bigint,
    p027e017 bigint,
    p027e018 bigint,
    p027e019 bigint,
    p027e020 bigint,
    p027e021 bigint,
    p027e022 bigint,
    p027e023 bigint,
    p027e024 bigint,
    p027e025 bigint,
    p027e026 bigint,
    p027e027 bigint,
    p027f001 bigint,
    p027f002 bigint,
    p027f003 bigint,
    p027f004 bigint,
    p027f005 bigint,
    p027f006 bigint,
    p027f007 bigint,
    p027f008 bigint,
    p027f009 bigint,
    p027f010 bigint,
    p027f011 bigint,
    p027f012 bigint,
    p027f013 bigint,
    p027f014 bigint,
    p027f015 bigint,
    p027f016 bigint,
    p027f017 bigint,
    p027f018 bigint,
    p027f019 bigint,
    p027f020 bigint,
    p027f021 bigint,
    p027f022 bigint,
    p027f023 bigint,
    p027f024 bigint,
    p027f025 bigint,
    p027f026 bigint,
    p027f027 bigint,
    p027g001 bigint,
    p027g002 bigint,
    p027g003 bigint,
    p027g004 bigint,
    p027g005 bigint,
    p027g006 bigint,
    p027g007 bigint,
    p027g008 bigint,
    p027g009 bigint,
    p027g010 bigint,
    p027g011 bigint,
    p027g012 bigint,
    p027g013 bigint,
    p027g014 bigint,
    p027g015 bigint,
    p027g016 bigint,
    p027g017 bigint,
    p027g018 bigint,
    p027g019 bigint,
    p027g020 bigint,
    p027g021 bigint,
    p027g022 bigint,
    p027g023 bigint,
    p027g024 bigint,
    p027g025 bigint,
    p027g026 bigint,
    p027g027 bigint,
    p027h001 bigint,
    p027h002 bigint,
    p027h003 bigint,
    p027h004 bigint,
    p027h005 bigint,
    p027h006 bigint,
    p027h007 bigint,
    p027h008 bigint,
    p027h009 bigint,
    p027h010 bigint,
    p027h011 bigint,
    p027h012 bigint,
    p027h013 bigint,
    p027h014 bigint,
    p027h015 bigint,
    p027h016 bigint,
    p027h017 bigint,
    p027h018 bigint,
    p027h019 bigint,
    p027h020 bigint,
    p027h021 bigint,
    p027h022 bigint,
    p027h023 bigint,
    p027h024 bigint,
    p027h025 bigint,
    p027h026 bigint,
    p027h027 bigint,
    p027i001 bigint,
    p027i002 bigint,
    p027i003 bigint,
    p027i004 bigint,
    p027i005 bigint,
    p027i006 bigint,
    p027i007 bigint,
    p027i008 bigint,
    p027i009 bigint,
    p027i010 bigint,
    p027i011 bigint,
    p027i012 bigint,
    p027i013 bigint,
    p027i014 bigint,
    p027i015 bigint,
    p027i016 bigint,
    p027i017 bigint,
    p027i018 bigint,
    p027i019 bigint,
    p027i020 bigint,
    p027i021 bigint,
    p027i022 bigint,
    p027i023 bigint,
    p027i024 bigint,
    p027i025 bigint,
    p027i026 bigint,
    p027i027 bigint,
    p028a001 bigint,
    p028a002 bigint,
    p028a003 bigint,
    p028a004 bigint,
    p028a005 bigint,
    p028a006 bigint,
    p028a007 bigint,
    p028a008 bigint,
    p028a009 bigint,
    p028a010 bigint,
    p028a011 bigint,
    p028a012 bigint,
    p028a013 bigint,
    p028a014 bigint,
    p028a015 bigint,
    p028a016 bigint,
    p028a017 bigint,
    p028b001 bigint,
    p028b002 bigint,
    p028b003 bigint,
    p028b004 bigint,
    p028b005 bigint,
    p028b006 bigint,
    p028b007 bigint,
    p028b008 bigint,
    p028b009 bigint,
    p028b010 bigint,
    p028b011 bigint,
    p028b012 bigint,
    p028b013 bigint,
    p028b014 bigint,
    p028b015 bigint,
    p028b016 bigint,
    p028b017 bigint,
    p028c001 bigint,
    p028c002 bigint,
    p028c003 bigint,
    p028c004 bigint,
    p028c005 bigint,
    p028c006 bigint,
    p028c007 bigint,
    p028c008 bigint,
    p028c009 bigint,
    p028c010 bigint,
    p028c011 bigint,
    p028c012 bigint,
    p028c013 bigint,
    p028c014 bigint,
    p028c015 bigint,
    p028c016 bigint,
    p028c017 bigint,
    p028d001 bigint,
    p028d002 bigint,
    p028d003 bigint,
    p028d004 bigint,
    p028d005 bigint,
    p028d006 bigint,
    p028d007 bigint,
    p028d008 bigint,
    p028d009 bigint,
    p028d010 bigint,
    p028d011 bigint,
    p028d012 bigint,
    p028d013 bigint,
    p028d014 bigint,
    p028d015 bigint,
    p028d016 bigint,
    p028d017 bigint,
    p028e001 bigint,
    p028e002 bigint,
    p028e003 bigint,
    p028e004 bigint,
    p028e005 bigint,
    p028e006 bigint,
    p028e007 bigint,
    p028e008 bigint,
    p028e009 bigint,
    p028e010 bigint,
    p028e011 bigint,
    p028e012 bigint,
    p028e013 bigint,
    p028e014 bigint,
    p028e015 bigint,
    p028e016 bigint,
    p028e017 bigint
);


ALTER TABLE sf10008 OWNER TO census;

--
-- Name: sf10009; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10009 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    p028f001 bigint,
    p028f002 bigint,
    p028f003 bigint,
    p028f004 bigint,
    p028f005 bigint,
    p028f006 bigint,
    p028f007 bigint,
    p028f008 bigint,
    p028f009 bigint,
    p028f010 bigint,
    p028f011 bigint,
    p028f012 bigint,
    p028f013 bigint,
    p028f014 bigint,
    p028f015 bigint,
    p028f016 bigint,
    p028f017 bigint,
    p028g001 bigint,
    p028g002 bigint,
    p028g003 bigint,
    p028g004 bigint,
    p028g005 bigint,
    p028g006 bigint,
    p028g007 bigint,
    p028g008 bigint,
    p028g009 bigint,
    p028g010 bigint,
    p028g011 bigint,
    p028g012 bigint,
    p028g013 bigint,
    p028g014 bigint,
    p028g015 bigint,
    p028g016 bigint,
    p028g017 bigint,
    p028h001 bigint,
    p028h002 bigint,
    p028h003 bigint,
    p028h004 bigint,
    p028h005 bigint,
    p028h006 bigint,
    p028h007 bigint,
    p028h008 bigint,
    p028h009 bigint,
    p028h010 bigint,
    p028h011 bigint,
    p028h012 bigint,
    p028h013 bigint,
    p028h014 bigint,
    p028h015 bigint,
    p028h016 bigint,
    p028h017 bigint,
    p028i001 bigint,
    p028i002 bigint,
    p028i003 bigint,
    p028i004 bigint,
    p028i005 bigint,
    p028i006 bigint,
    p028i007 bigint,
    p028i008 bigint,
    p028i009 bigint,
    p028i010 bigint,
    p028i011 bigint,
    p028i012 bigint,
    p028i013 bigint,
    p028i014 bigint,
    p028i015 bigint,
    p028i016 bigint,
    p028i017 bigint,
    p030a001 bigint,
    p030a002 bigint,
    p030a003 bigint,
    p030a004 bigint,
    p030a005 bigint,
    p030a006 bigint,
    p030a007 bigint,
    p030a008 bigint,
    p030a009 bigint,
    p030a010 bigint,
    p030a011 bigint,
    p030a012 bigint,
    p030a013 bigint,
    p030a014 bigint,
    p030a015 bigint,
    p030a016 bigint,
    p030a017 bigint,
    p030a018 bigint,
    p030a019 bigint,
    p030a020 bigint,
    p030a021 bigint,
    p030a022 bigint,
    p030b001 bigint,
    p030b002 bigint,
    p030b003 bigint,
    p030b004 bigint,
    p030b005 bigint,
    p030b006 bigint,
    p030b007 bigint,
    p030b008 bigint,
    p030b009 bigint,
    p030b010 bigint,
    p030b011 bigint,
    p030b012 bigint,
    p030b013 bigint,
    p030b014 bigint,
    p030b015 bigint,
    p030b016 bigint,
    p030b017 bigint,
    p030b018 bigint,
    p030b019 bigint,
    p030b020 bigint,
    p030b021 bigint,
    p030b022 bigint,
    p030c001 bigint,
    p030c002 bigint,
    p030c003 bigint,
    p030c004 bigint,
    p030c005 bigint,
    p030c006 bigint,
    p030c007 bigint,
    p030c008 bigint,
    p030c009 bigint,
    p030c010 bigint,
    p030c011 bigint,
    p030c012 bigint,
    p030c013 bigint,
    p030c014 bigint,
    p030c015 bigint,
    p030c016 bigint,
    p030c017 bigint,
    p030c018 bigint,
    p030c019 bigint,
    p030c020 bigint,
    p030c021 bigint,
    p030c022 bigint,
    p030d001 bigint,
    p030d002 bigint,
    p030d003 bigint,
    p030d004 bigint,
    p030d005 bigint,
    p030d006 bigint,
    p030d007 bigint,
    p030d008 bigint,
    p030d009 bigint,
    p030d010 bigint,
    p030d011 bigint,
    p030d012 bigint,
    p030d013 bigint,
    p030d014 bigint,
    p030d015 bigint,
    p030d016 bigint,
    p030d017 bigint,
    p030d018 bigint,
    p030d019 bigint,
    p030d020 bigint,
    p030d021 bigint,
    p030d022 bigint,
    p030e001 bigint,
    p030e002 bigint,
    p030e003 bigint,
    p030e004 bigint,
    p030e005 bigint,
    p030e006 bigint,
    p030e007 bigint,
    p030e008 bigint,
    p030e009 bigint,
    p030e010 bigint,
    p030e011 bigint,
    p030e012 bigint,
    p030e013 bigint,
    p030e014 bigint,
    p030e015 bigint,
    p030e016 bigint,
    p030e017 bigint,
    p030e018 bigint,
    p030e019 bigint,
    p030e020 bigint,
    p030e021 bigint,
    p030e022 bigint,
    p030f001 bigint,
    p030f002 bigint,
    p030f003 bigint,
    p030f004 bigint,
    p030f005 bigint,
    p030f006 bigint,
    p030f007 bigint,
    p030f008 bigint,
    p030f009 bigint,
    p030f010 bigint,
    p030f011 bigint,
    p030f012 bigint,
    p030f013 bigint,
    p030f014 bigint,
    p030f015 bigint,
    p030f016 bigint,
    p030f017 bigint,
    p030f018 bigint,
    p030f019 bigint,
    p030f020 bigint,
    p030f021 bigint,
    p030f022 bigint,
    p030g001 bigint,
    p030g002 bigint,
    p030g003 bigint,
    p030g004 bigint,
    p030g005 bigint,
    p030g006 bigint,
    p030g007 bigint,
    p030g008 bigint,
    p030g009 bigint,
    p030g010 bigint,
    p030g011 bigint,
    p030g012 bigint,
    p030g013 bigint,
    p030g014 bigint,
    p030g015 bigint,
    p030g016 bigint,
    p030g017 bigint,
    p030g018 bigint,
    p030g019 bigint,
    p030g020 bigint,
    p030g021 bigint,
    p030g022 bigint,
    p030h001 bigint,
    p030h002 bigint,
    p030h003 bigint,
    p030h004 bigint,
    p030h005 bigint,
    p030h006 bigint,
    p030h007 bigint,
    p030h008 bigint,
    p030h009 bigint,
    p030h010 bigint,
    p030h011 bigint,
    p030h012 bigint,
    p030h013 bigint,
    p030h014 bigint,
    p030h015 bigint,
    p030h016 bigint,
    p030h017 bigint,
    p030h018 bigint,
    p030h019 bigint,
    p030h020 bigint,
    p030h021 bigint,
    p030h022 bigint
);


ALTER TABLE sf10009 OWNER TO census;

--
-- Name: sf10010; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10010 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    p030i001 bigint,
    p030i002 bigint,
    p030i003 bigint,
    p030i004 bigint,
    p030i005 bigint,
    p030i006 bigint,
    p030i007 bigint,
    p030i008 bigint,
    p030i009 bigint,
    p030i010 bigint,
    p030i011 bigint,
    p030i012 bigint,
    p030i013 bigint,
    p030i014 bigint,
    p030i015 bigint,
    p030i016 bigint,
    p030i017 bigint,
    p030i018 bigint,
    p030i019 bigint,
    p030i020 bigint,
    p030i021 bigint,
    p030i022 bigint,
    p031a001 bigint,
    p031b001 bigint,
    p031c001 bigint,
    p031d001 bigint,
    p031e001 bigint,
    p031f001 bigint,
    p031g001 bigint,
    p031h001 bigint,
    p031i001 bigint,
    p032a001 bigint,
    p032b001 bigint,
    p032c001 bigint,
    p032d001 bigint,
    p032e001 bigint,
    p032f001 bigint,
    p032g001 bigint,
    p032h001 bigint,
    p032i001 bigint,
    p033a001 double precision,
    p033b001 double precision,
    p033c001 double precision,
    p033d001 double precision,
    p033e001 double precision,
    p033f001 double precision,
    p033g001 double precision,
    p033h001 double precision,
    p033i001 double precision,
    p034a001 bigint,
    p034a002 bigint,
    p034a003 bigint,
    p034a004 bigint,
    p034a005 bigint,
    p034a006 bigint,
    p034a007 bigint,
    p034a008 bigint,
    p034a009 bigint,
    p034a010 bigint,
    p034a011 bigint,
    p034a012 bigint,
    p034a013 bigint,
    p034a014 bigint,
    p034a015 bigint,
    p034a016 bigint,
    p034a017 bigint,
    p034a018 bigint,
    p034a019 bigint,
    p034a020 bigint,
    p034b001 bigint,
    p034b002 bigint,
    p034b003 bigint,
    p034b004 bigint,
    p034b005 bigint,
    p034b006 bigint,
    p034b007 bigint,
    p034b008 bigint,
    p034b009 bigint,
    p034b010 bigint,
    p034b011 bigint,
    p034b012 bigint,
    p034b013 bigint,
    p034b014 bigint,
    p034b015 bigint,
    p034b016 bigint,
    p034b017 bigint,
    p034b018 bigint,
    p034b019 bigint,
    p034b020 bigint,
    p034c001 bigint,
    p034c002 bigint,
    p034c003 bigint,
    p034c004 bigint,
    p034c005 bigint,
    p034c006 bigint,
    p034c007 bigint,
    p034c008 bigint,
    p034c009 bigint,
    p034c010 bigint,
    p034c011 bigint,
    p034c012 bigint,
    p034c013 bigint,
    p034c014 bigint,
    p034c015 bigint,
    p034c016 bigint,
    p034c017 bigint,
    p034c018 bigint,
    p034c019 bigint,
    p034c020 bigint,
    p034d001 bigint,
    p034d002 bigint,
    p034d003 bigint,
    p034d004 bigint,
    p034d005 bigint,
    p034d006 bigint,
    p034d007 bigint,
    p034d008 bigint,
    p034d009 bigint,
    p034d010 bigint,
    p034d011 bigint,
    p034d012 bigint,
    p034d013 bigint,
    p034d014 bigint,
    p034d015 bigint,
    p034d016 bigint,
    p034d017 bigint,
    p034d018 bigint,
    p034d019 bigint,
    p034d020 bigint,
    p034e001 bigint,
    p034e002 bigint,
    p034e003 bigint,
    p034e004 bigint,
    p034e005 bigint,
    p034e006 bigint,
    p034e007 bigint,
    p034e008 bigint,
    p034e009 bigint,
    p034e010 bigint,
    p034e011 bigint,
    p034e012 bigint,
    p034e013 bigint,
    p034e014 bigint,
    p034e015 bigint,
    p034e016 bigint,
    p034e017 bigint,
    p034e018 bigint,
    p034e019 bigint,
    p034e020 bigint,
    p034f001 bigint,
    p034f002 bigint,
    p034f003 bigint,
    p034f004 bigint,
    p034f005 bigint,
    p034f006 bigint,
    p034f007 bigint,
    p034f008 bigint,
    p034f009 bigint,
    p034f010 bigint,
    p034f011 bigint,
    p034f012 bigint,
    p034f013 bigint,
    p034f014 bigint,
    p034f015 bigint,
    p034f016 bigint,
    p034f017 bigint,
    p034f018 bigint,
    p034f019 bigint,
    p034f020 bigint,
    p034g001 bigint,
    p034g002 bigint,
    p034g003 bigint,
    p034g004 bigint,
    p034g005 bigint,
    p034g006 bigint,
    p034g007 bigint,
    p034g008 bigint,
    p034g009 bigint,
    p034g010 bigint,
    p034g011 bigint,
    p034g012 bigint,
    p034g013 bigint,
    p034g014 bigint,
    p034g015 bigint,
    p034g016 bigint,
    p034g017 bigint,
    p034g018 bigint,
    p034g019 bigint,
    p034g020 bigint,
    p034h001 bigint,
    p034h002 bigint,
    p034h003 bigint,
    p034h004 bigint,
    p034h005 bigint,
    p034h006 bigint,
    p034h007 bigint,
    p034h008 bigint,
    p034h009 bigint,
    p034h010 bigint,
    p034h011 bigint,
    p034h012 bigint,
    p034h013 bigint,
    p034h014 bigint,
    p034h015 bigint,
    p034h016 bigint,
    p034h017 bigint,
    p034h018 bigint,
    p034h019 bigint,
    p034h020 bigint,
    p034i001 bigint,
    p034i002 bigint,
    p034i003 bigint,
    p034i004 bigint,
    p034i005 bigint,
    p034i006 bigint,
    p034i007 bigint,
    p034i008 bigint,
    p034i009 bigint,
    p034i010 bigint,
    p034i011 bigint,
    p034i012 bigint,
    p034i013 bigint,
    p034i014 bigint,
    p034i015 bigint,
    p034i016 bigint,
    p034i017 bigint,
    p034i018 bigint,
    p034i019 bigint,
    p034i020 bigint
);


ALTER TABLE sf10010 OWNER TO census;

--
-- Name: sf10011; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10011 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    p035a001 bigint,
    p035a002 bigint,
    p035a003 bigint,
    p035a004 bigint,
    p035a005 bigint,
    p035a006 bigint,
    p035a007 bigint,
    p035a008 bigint,
    p035a009 bigint,
    p035a010 bigint,
    p035a011 bigint,
    p035a012 bigint,
    p035a013 bigint,
    p035a014 bigint,
    p035a015 bigint,
    p035a016 bigint,
    p035a017 bigint,
    p035a018 bigint,
    p035a019 bigint,
    p035a020 bigint,
    p035b001 bigint,
    p035b002 bigint,
    p035b003 bigint,
    p035b004 bigint,
    p035b005 bigint,
    p035b006 bigint,
    p035b007 bigint,
    p035b008 bigint,
    p035b009 bigint,
    p035b010 bigint,
    p035b011 bigint,
    p035b012 bigint,
    p035b013 bigint,
    p035b014 bigint,
    p035b015 bigint,
    p035b016 bigint,
    p035b017 bigint,
    p035b018 bigint,
    p035b019 bigint,
    p035b020 bigint,
    p035c001 bigint,
    p035c002 bigint,
    p035c003 bigint,
    p035c004 bigint,
    p035c005 bigint,
    p035c006 bigint,
    p035c007 bigint,
    p035c008 bigint,
    p035c009 bigint,
    p035c010 bigint,
    p035c011 bigint,
    p035c012 bigint,
    p035c013 bigint,
    p035c014 bigint,
    p035c015 bigint,
    p035c016 bigint,
    p035c017 bigint,
    p035c018 bigint,
    p035c019 bigint,
    p035c020 bigint,
    p035d001 bigint,
    p035d002 bigint,
    p035d003 bigint,
    p035d004 bigint,
    p035d005 bigint,
    p035d006 bigint,
    p035d007 bigint,
    p035d008 bigint,
    p035d009 bigint,
    p035d010 bigint,
    p035d011 bigint,
    p035d012 bigint,
    p035d013 bigint,
    p035d014 bigint,
    p035d015 bigint,
    p035d016 bigint,
    p035d017 bigint,
    p035d018 bigint,
    p035d019 bigint,
    p035d020 bigint,
    p035e001 bigint,
    p035e002 bigint,
    p035e003 bigint,
    p035e004 bigint,
    p035e005 bigint,
    p035e006 bigint,
    p035e007 bigint,
    p035e008 bigint,
    p035e009 bigint,
    p035e010 bigint,
    p035e011 bigint,
    p035e012 bigint,
    p035e013 bigint,
    p035e014 bigint,
    p035e015 bigint,
    p035e016 bigint,
    p035e017 bigint,
    p035e018 bigint,
    p035e019 bigint,
    p035e020 bigint,
    p035f001 bigint,
    p035f002 bigint,
    p035f003 bigint,
    p035f004 bigint,
    p035f005 bigint,
    p035f006 bigint,
    p035f007 bigint,
    p035f008 bigint,
    p035f009 bigint,
    p035f010 bigint,
    p035f011 bigint,
    p035f012 bigint,
    p035f013 bigint,
    p035f014 bigint,
    p035f015 bigint,
    p035f016 bigint,
    p035f017 bigint,
    p035f018 bigint,
    p035f019 bigint,
    p035f020 bigint,
    p035g001 bigint,
    p035g002 bigint,
    p035g003 bigint,
    p035g004 bigint,
    p035g005 bigint,
    p035g006 bigint,
    p035g007 bigint,
    p035g008 bigint,
    p035g009 bigint,
    p035g010 bigint,
    p035g011 bigint,
    p035g012 bigint,
    p035g013 bigint,
    p035g014 bigint,
    p035g015 bigint,
    p035g016 bigint,
    p035g017 bigint,
    p035g018 bigint,
    p035g019 bigint,
    p035g020 bigint,
    p035h001 bigint,
    p035h002 bigint,
    p035h003 bigint,
    p035h004 bigint,
    p035h005 bigint,
    p035h006 bigint,
    p035h007 bigint,
    p035h008 bigint,
    p035h009 bigint,
    p035h010 bigint,
    p035h011 bigint,
    p035h012 bigint,
    p035h013 bigint,
    p035h014 bigint,
    p035h015 bigint,
    p035h016 bigint,
    p035h017 bigint,
    p035h018 bigint,
    p035h019 bigint,
    p035h020 bigint,
    p035i001 bigint,
    p035i002 bigint,
    p035i003 bigint,
    p035i004 bigint,
    p035i005 bigint,
    p035i006 bigint,
    p035i007 bigint,
    p035i008 bigint,
    p035i009 bigint,
    p035i010 bigint,
    p035i011 bigint,
    p035i012 bigint,
    p035i013 bigint,
    p035i014 bigint,
    p035i015 bigint,
    p035i016 bigint,
    p035i017 bigint,
    p035i018 bigint,
    p035i019 bigint,
    p035i020 bigint
);


ALTER TABLE sf10011 OWNER TO census;

--
-- Name: sf10012; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10012 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct001001 bigint,
    pct001002 bigint,
    pct001003 bigint,
    pct001004 bigint,
    pct001005 bigint,
    pct001006 bigint,
    pct001007 bigint,
    pct001008 bigint,
    pct001009 bigint,
    pct001010 bigint,
    pct001011 bigint,
    pct001012 bigint,
    pct001013 bigint,
    pct001014 bigint,
    pct001015 bigint,
    pct001016 bigint,
    pct001017 bigint,
    pct001018 bigint,
    pct001019 bigint,
    pct001020 bigint,
    pct001021 bigint,
    pct001022 bigint,
    pct001023 bigint,
    pct001024 bigint,
    pct001025 bigint,
    pct001026 bigint,
    pct001027 bigint,
    pct001028 bigint,
    pct001029 bigint,
    pct001030 bigint,
    pct001031 bigint,
    pct001032 bigint,
    pct001033 bigint,
    pct001034 bigint,
    pct001035 bigint,
    pct001036 bigint,
    pct001037 bigint,
    pct001038 bigint,
    pct001039 bigint,
    pct001040 bigint,
    pct001041 bigint,
    pct001042 bigint,
    pct001043 bigint,
    pct001044 bigint,
    pct001045 bigint,
    pct001046 bigint,
    pct001047 bigint,
    pct002001 bigint,
    pct002002 bigint,
    pct002003 bigint,
    pct002004 bigint,
    pct002005 bigint,
    pct002006 bigint,
    pct002007 bigint,
    pct002008 bigint,
    pct002009 bigint,
    pct002010 bigint,
    pct002011 bigint,
    pct002012 bigint,
    pct002013 bigint,
    pct002014 bigint,
    pct002015 bigint,
    pct002016 bigint,
    pct002017 bigint,
    pct002018 bigint,
    pct002019 bigint,
    pct002020 bigint,
    pct002021 bigint,
    pct002022 bigint,
    pct002023 bigint,
    pct002024 bigint,
    pct002025 bigint,
    pct002026 bigint,
    pct002027 bigint,
    pct002028 bigint,
    pct002029 bigint,
    pct002030 bigint,
    pct002031 bigint,
    pct002032 bigint,
    pct002033 bigint,
    pct002034 bigint,
    pct002035 bigint,
    pct002036 bigint,
    pct002037 bigint,
    pct002038 bigint,
    pct002039 bigint,
    pct002040 bigint,
    pct002041 bigint,
    pct002042 bigint,
    pct002043 bigint,
    pct002044 bigint,
    pct002045 bigint,
    pct002046 bigint,
    pct002047 bigint,
    pct003001 bigint,
    pct003002 bigint,
    pct003003 bigint,
    pct003004 bigint,
    pct003005 bigint,
    pct003006 bigint,
    pct003007 bigint,
    pct003008 bigint,
    pct003009 bigint,
    pct003010 bigint,
    pct003011 bigint,
    pct003012 bigint,
    pct003013 bigint,
    pct003014 bigint,
    pct003015 bigint,
    pct003016 bigint,
    pct003017 bigint,
    pct003018 bigint,
    pct003019 bigint,
    pct003020 bigint,
    pct003021 bigint,
    pct003022 bigint,
    pct003023 bigint,
    pct003024 bigint,
    pct003025 bigint,
    pct003026 bigint,
    pct003027 bigint,
    pct003028 bigint,
    pct003029 bigint,
    pct003030 bigint,
    pct003031 bigint,
    pct003032 bigint,
    pct003033 bigint,
    pct003034 bigint,
    pct003035 bigint,
    pct003036 bigint,
    pct003037 bigint,
    pct003038 bigint,
    pct003039 bigint,
    pct003040 bigint,
    pct003041 bigint,
    pct003042 bigint,
    pct003043 bigint,
    pct003044 bigint,
    pct003045 bigint,
    pct003046 bigint,
    pct003047 bigint,
    pct004001 bigint,
    pct004002 bigint,
    pct004003 bigint,
    pct004004 bigint,
    pct004005 bigint,
    pct004006 bigint,
    pct004007 bigint,
    pct004008 bigint,
    pct004009 bigint,
    pct005001 bigint,
    pct005002 bigint,
    pct005003 bigint,
    pct005004 bigint,
    pct005005 bigint,
    pct005006 bigint,
    pct005007 bigint,
    pct005008 bigint,
    pct005009 bigint,
    pct005010 bigint,
    pct005011 bigint,
    pct005012 bigint,
    pct005013 bigint,
    pct005014 bigint,
    pct005015 bigint,
    pct005016 bigint,
    pct005017 bigint,
    pct005018 bigint,
    pct005019 bigint,
    pct006001 bigint,
    pct006002 bigint,
    pct006003 bigint,
    pct006004 bigint,
    pct006005 bigint,
    pct006006 bigint,
    pct006007 bigint,
    pct006008 bigint,
    pct006009 bigint,
    pct006010 bigint,
    pct006011 bigint,
    pct006012 bigint,
    pct006013 bigint,
    pct006014 bigint,
    pct006015 bigint,
    pct006016 bigint,
    pct006017 bigint,
    pct006018 bigint,
    pct006019 bigint,
    pct007001 bigint,
    pct007002 bigint,
    pct007003 bigint,
    pct007004 bigint,
    pct007005 bigint,
    pct007006 bigint,
    pct007007 bigint,
    pct007008 bigint,
    pct007009 bigint,
    pct007010 bigint,
    pct007011 bigint,
    pct007012 bigint,
    pct007013 bigint,
    pct007014 bigint,
    pct007015 bigint,
    pct007016 bigint,
    pct007017 bigint,
    pct007018 bigint,
    pct007019 bigint,
    pct008001 bigint,
    pct008002 bigint,
    pct008003 bigint,
    pct008004 bigint,
    pct008005 bigint,
    pct008006 bigint,
    pct008007 bigint,
    pct008008 bigint,
    pct008009 bigint,
    pct008010 bigint,
    pct008011 bigint,
    pct008012 bigint,
    pct008013 bigint,
    pct008014 bigint,
    pct009001 bigint,
    pct009002 bigint,
    pct009003 bigint,
    pct009004 bigint,
    pct009005 bigint,
    pct009006 bigint,
    pct009007 bigint,
    pct009008 bigint,
    pct009009 bigint,
    pct009010 bigint,
    pct009011 bigint,
    pct009012 bigint,
    pct009013 bigint,
    pct009014 bigint
);


ALTER TABLE sf10012 OWNER TO census;

--
-- Name: sf10013; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10013 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct010001 bigint,
    pct010002 bigint,
    pct010003 bigint,
    pct010004 bigint,
    pct010005 bigint,
    pct010006 bigint,
    pct010007 bigint,
    pct010008 bigint,
    pct010009 bigint,
    pct010010 bigint,
    pct010011 bigint,
    pct010012 bigint,
    pct010013 bigint,
    pct010014 bigint,
    pct011001 bigint,
    pct011002 bigint,
    pct011003 bigint,
    pct011004 bigint,
    pct011005 bigint,
    pct011006 bigint,
    pct011007 bigint,
    pct011008 bigint,
    pct011009 bigint,
    pct011010 bigint,
    pct011011 bigint,
    pct011012 bigint,
    pct011013 bigint,
    pct011014 bigint,
    pct011015 bigint,
    pct011016 bigint,
    pct011017 bigint,
    pct011018 bigint,
    pct011019 bigint,
    pct011020 bigint,
    pct011021 bigint,
    pct011022 bigint,
    pct011023 bigint,
    pct011024 bigint,
    pct011025 bigint,
    pct011026 bigint,
    pct011027 bigint,
    pct011028 bigint,
    pct011029 bigint,
    pct011030 bigint,
    pct011031 bigint
);


ALTER TABLE sf10013 OWNER TO census;

--
-- Name: sf10014; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10014 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct012001 bigint,
    pct012002 bigint,
    pct012003 bigint,
    pct012004 bigint,
    pct012005 bigint,
    pct012006 bigint,
    pct012007 bigint,
    pct012008 bigint,
    pct012009 bigint,
    pct012010 bigint,
    pct012011 bigint,
    pct012012 bigint,
    pct012013 bigint,
    pct012014 bigint,
    pct012015 bigint,
    pct012016 bigint,
    pct012017 bigint,
    pct012018 bigint,
    pct012019 bigint,
    pct012020 bigint,
    pct012021 bigint,
    pct012022 bigint,
    pct012023 bigint,
    pct012024 bigint,
    pct012025 bigint,
    pct012026 bigint,
    pct012027 bigint,
    pct012028 bigint,
    pct012029 bigint,
    pct012030 bigint,
    pct012031 bigint,
    pct012032 bigint,
    pct012033 bigint,
    pct012034 bigint,
    pct012035 bigint,
    pct012036 bigint,
    pct012037 bigint,
    pct012038 bigint,
    pct012039 bigint,
    pct012040 bigint,
    pct012041 bigint,
    pct012042 bigint,
    pct012043 bigint,
    pct012044 bigint,
    pct012045 bigint,
    pct012046 bigint,
    pct012047 bigint,
    pct012048 bigint,
    pct012049 bigint,
    pct012050 bigint,
    pct012051 bigint,
    pct012052 bigint,
    pct012053 bigint,
    pct012054 bigint,
    pct012055 bigint,
    pct012056 bigint,
    pct012057 bigint,
    pct012058 bigint,
    pct012059 bigint,
    pct012060 bigint,
    pct012061 bigint,
    pct012062 bigint,
    pct012063 bigint,
    pct012064 bigint,
    pct012065 bigint,
    pct012066 bigint,
    pct012067 bigint,
    pct012068 bigint,
    pct012069 bigint,
    pct012070 bigint,
    pct012071 bigint,
    pct012072 bigint,
    pct012073 bigint,
    pct012074 bigint,
    pct012075 bigint,
    pct012076 bigint,
    pct012077 bigint,
    pct012078 bigint,
    pct012079 bigint,
    pct012080 bigint,
    pct012081 bigint,
    pct012082 bigint,
    pct012083 bigint,
    pct012084 bigint,
    pct012085 bigint,
    pct012086 bigint,
    pct012087 bigint,
    pct012088 bigint,
    pct012089 bigint,
    pct012090 bigint,
    pct012091 bigint,
    pct012092 bigint,
    pct012093 bigint,
    pct012094 bigint,
    pct012095 bigint,
    pct012096 bigint,
    pct012097 bigint,
    pct012098 bigint,
    pct012099 bigint,
    pct012100 bigint,
    pct012101 bigint,
    pct012102 bigint,
    pct012103 bigint,
    pct012104 bigint,
    pct012105 bigint,
    pct012106 bigint,
    pct012107 bigint,
    pct012108 bigint,
    pct012109 bigint,
    pct012110 bigint,
    pct012111 bigint,
    pct012112 bigint,
    pct012113 bigint,
    pct012114 bigint,
    pct012115 bigint,
    pct012116 bigint,
    pct012117 bigint,
    pct012118 bigint,
    pct012119 bigint,
    pct012120 bigint,
    pct012121 bigint,
    pct012122 bigint,
    pct012123 bigint,
    pct012124 bigint,
    pct012125 bigint,
    pct012126 bigint,
    pct012127 bigint,
    pct012128 bigint,
    pct012129 bigint,
    pct012130 bigint,
    pct012131 bigint,
    pct012132 bigint,
    pct012133 bigint,
    pct012134 bigint,
    pct012135 bigint,
    pct012136 bigint,
    pct012137 bigint,
    pct012138 bigint,
    pct012139 bigint,
    pct012140 bigint,
    pct012141 bigint,
    pct012142 bigint,
    pct012143 bigint,
    pct012144 bigint,
    pct012145 bigint,
    pct012146 bigint,
    pct012147 bigint,
    pct012148 bigint,
    pct012149 bigint,
    pct012150 bigint,
    pct012151 bigint,
    pct012152 bigint,
    pct012153 bigint,
    pct012154 bigint,
    pct012155 bigint,
    pct012156 bigint,
    pct012157 bigint,
    pct012158 bigint,
    pct012159 bigint,
    pct012160 bigint,
    pct012161 bigint,
    pct012162 bigint,
    pct012163 bigint,
    pct012164 bigint,
    pct012165 bigint,
    pct012166 bigint,
    pct012167 bigint,
    pct012168 bigint,
    pct012169 bigint,
    pct012170 bigint,
    pct012171 bigint,
    pct012172 bigint,
    pct012173 bigint,
    pct012174 bigint,
    pct012175 bigint,
    pct012176 bigint,
    pct012177 bigint,
    pct012178 bigint,
    pct012179 bigint,
    pct012180 bigint,
    pct012181 bigint,
    pct012182 bigint,
    pct012183 bigint,
    pct012184 bigint,
    pct012185 bigint,
    pct012186 bigint,
    pct012187 bigint,
    pct012188 bigint,
    pct012189 bigint,
    pct012190 bigint,
    pct012191 bigint,
    pct012192 bigint,
    pct012193 bigint,
    pct012194 bigint,
    pct012195 bigint,
    pct012196 bigint,
    pct012197 bigint,
    pct012198 bigint,
    pct012199 bigint,
    pct012200 bigint,
    pct012201 bigint,
    pct012202 bigint,
    pct012203 bigint,
    pct012204 bigint,
    pct012205 bigint,
    pct012206 bigint,
    pct012207 bigint,
    pct012208 bigint,
    pct012209 bigint
);


ALTER TABLE sf10014 OWNER TO census;

--
-- Name: sf10015; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10015 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct013001 bigint,
    pct013002 bigint,
    pct013003 bigint,
    pct013004 bigint,
    pct013005 bigint,
    pct013006 bigint,
    pct013007 bigint,
    pct013008 bigint,
    pct013009 bigint,
    pct013010 bigint,
    pct013011 bigint,
    pct013012 bigint,
    pct013013 bigint,
    pct013014 bigint,
    pct013015 bigint,
    pct013016 bigint,
    pct013017 bigint,
    pct013018 bigint,
    pct013019 bigint,
    pct013020 bigint,
    pct013021 bigint,
    pct013022 bigint,
    pct013023 bigint,
    pct013024 bigint,
    pct013025 bigint,
    pct013026 bigint,
    pct013027 bigint,
    pct013028 bigint,
    pct013029 bigint,
    pct013030 bigint,
    pct013031 bigint,
    pct013032 bigint,
    pct013033 bigint,
    pct013034 bigint,
    pct013035 bigint,
    pct013036 bigint,
    pct013037 bigint,
    pct013038 bigint,
    pct013039 bigint,
    pct013040 bigint,
    pct013041 bigint,
    pct013042 bigint,
    pct013043 bigint,
    pct013044 bigint,
    pct013045 bigint,
    pct013046 bigint,
    pct013047 bigint,
    pct013048 bigint,
    pct013049 bigint,
    pct014001 bigint,
    pct014002 bigint,
    pct014003 bigint,
    pct014004 bigint,
    pct014005 bigint,
    pct014006 bigint,
    pct014007 bigint,
    pct015001 bigint,
    pct015002 bigint,
    pct015003 bigint,
    pct015004 bigint,
    pct015005 bigint,
    pct015006 bigint,
    pct015007 bigint,
    pct015008 bigint,
    pct015009 bigint,
    pct015010 bigint,
    pct015011 bigint,
    pct015012 bigint,
    pct015013 bigint,
    pct016001 bigint,
    pct016002 bigint,
    pct016003 bigint,
    pct016004 bigint,
    pct016005 bigint,
    pct016006 bigint,
    pct016007 bigint,
    pct016008 bigint,
    pct016009 bigint,
    pct016010 bigint,
    pct016011 bigint,
    pct016012 bigint,
    pct016013 bigint,
    pct016014 bigint,
    pct016015 bigint,
    pct016016 bigint,
    pct016017 bigint,
    pct016018 bigint,
    pct016019 bigint,
    pct016020 bigint,
    pct016021 bigint,
    pct016022 bigint,
    pct016023 bigint,
    pct016024 bigint,
    pct016025 bigint,
    pct016026 bigint,
    pct016027 bigint,
    pct016028 bigint,
    pct016029 bigint,
    pct016030 bigint,
    pct016031 bigint,
    pct016032 bigint,
    pct016033 bigint,
    pct016034 bigint,
    pct016035 bigint,
    pct016036 bigint,
    pct016037 bigint,
    pct016038 bigint,
    pct016039 bigint,
    pct016040 bigint,
    pct016041 bigint,
    pct016042 bigint,
    pct016043 bigint,
    pct016044 bigint,
    pct016045 bigint,
    pct016046 bigint,
    pct016047 bigint,
    pct016048 bigint,
    pct016049 bigint,
    pct016050 bigint,
    pct016051 bigint,
    pct016052 bigint,
    pct017001 bigint,
    pct017002 bigint,
    pct017003 bigint,
    pct017004 bigint,
    pct017005 bigint,
    pct017006 bigint,
    pct017007 bigint,
    pct017008 bigint,
    pct017009 bigint,
    pct017010 bigint,
    pct017011 bigint,
    pct017012 bigint,
    pct017013 bigint,
    pct017014 bigint,
    pct017015 bigint,
    pct017016 bigint,
    pct017017 bigint,
    pct017018 bigint,
    pct017019 bigint,
    pct017020 bigint,
    pct017021 bigint,
    pct017022 bigint,
    pct017023 bigint,
    pct017024 bigint,
    pct017025 bigint,
    pct017026 bigint,
    pct017027 bigint,
    pct017028 bigint,
    pct017029 bigint,
    pct017030 bigint,
    pct017031 bigint,
    pct017032 bigint,
    pct017033 bigint,
    pct017034 bigint,
    pct017035 bigint,
    pct017036 bigint,
    pct017037 bigint,
    pct017038 bigint,
    pct017039 bigint,
    pct017040 bigint,
    pct017041 bigint,
    pct017042 bigint,
    pct017043 bigint,
    pct017044 bigint,
    pct017045 bigint,
    pct017046 bigint,
    pct017047 bigint,
    pct017048 bigint,
    pct017049 bigint,
    pct017050 bigint,
    pct017051 bigint,
    pct017052 bigint,
    pct017053 bigint,
    pct017054 bigint,
    pct017055 bigint,
    pct017056 bigint,
    pct017057 bigint,
    pct017058 bigint,
    pct017059 bigint,
    pct017060 bigint,
    pct017061 bigint,
    pct017062 bigint,
    pct017063 bigint,
    pct017064 bigint,
    pct017065 bigint,
    pct017066 bigint,
    pct017067 bigint,
    pct017068 bigint,
    pct017069 bigint,
    pct017070 bigint,
    pct017071 bigint,
    pct017072 bigint,
    pct017073 bigint,
    pct017074 bigint,
    pct017075 bigint
);


ALTER TABLE sf10015 OWNER TO census;

--
-- Name: sf10016; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10016 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct012a001 bigint,
    pct012a002 bigint,
    pct012a003 bigint,
    pct012a004 bigint,
    pct012a005 bigint,
    pct012a006 bigint,
    pct012a007 bigint,
    pct012a008 bigint,
    pct012a009 bigint,
    pct012a010 bigint,
    pct012a011 bigint,
    pct012a012 bigint,
    pct012a013 bigint,
    pct012a014 bigint,
    pct012a015 bigint,
    pct012a016 bigint,
    pct012a017 bigint,
    pct012a018 bigint,
    pct012a019 bigint,
    pct012a020 bigint,
    pct012a021 bigint,
    pct012a022 bigint,
    pct012a023 bigint,
    pct012a024 bigint,
    pct012a025 bigint,
    pct012a026 bigint,
    pct012a027 bigint,
    pct012a028 bigint,
    pct012a029 bigint,
    pct012a030 bigint,
    pct012a031 bigint,
    pct012a032 bigint,
    pct012a033 bigint,
    pct012a034 bigint,
    pct012a035 bigint,
    pct012a036 bigint,
    pct012a037 bigint,
    pct012a038 bigint,
    pct012a039 bigint,
    pct012a040 bigint,
    pct012a041 bigint,
    pct012a042 bigint,
    pct012a043 bigint,
    pct012a044 bigint,
    pct012a045 bigint,
    pct012a046 bigint,
    pct012a047 bigint,
    pct012a048 bigint,
    pct012a049 bigint,
    pct012a050 bigint,
    pct012a051 bigint,
    pct012a052 bigint,
    pct012a053 bigint,
    pct012a054 bigint,
    pct012a055 bigint,
    pct012a056 bigint,
    pct012a057 bigint,
    pct012a058 bigint,
    pct012a059 bigint,
    pct012a060 bigint,
    pct012a061 bigint,
    pct012a062 bigint,
    pct012a063 bigint,
    pct012a064 bigint,
    pct012a065 bigint,
    pct012a066 bigint,
    pct012a067 bigint,
    pct012a068 bigint,
    pct012a069 bigint,
    pct012a070 bigint,
    pct012a071 bigint,
    pct012a072 bigint,
    pct012a073 bigint,
    pct012a074 bigint,
    pct012a075 bigint,
    pct012a076 bigint,
    pct012a077 bigint,
    pct012a078 bigint,
    pct012a079 bigint,
    pct012a080 bigint,
    pct012a081 bigint,
    pct012a082 bigint,
    pct012a083 bigint,
    pct012a084 bigint,
    pct012a085 bigint,
    pct012a086 bigint,
    pct012a087 bigint,
    pct012a088 bigint,
    pct012a089 bigint,
    pct012a090 bigint,
    pct012a091 bigint,
    pct012a092 bigint,
    pct012a093 bigint,
    pct012a094 bigint,
    pct012a095 bigint,
    pct012a096 bigint,
    pct012a097 bigint,
    pct012a098 bigint,
    pct012a099 bigint,
    pct012a100 bigint,
    pct012a101 bigint,
    pct012a102 bigint,
    pct012a103 bigint,
    pct012a104 bigint,
    pct012a105 bigint,
    pct012a106 bigint,
    pct012a107 bigint,
    pct012a108 bigint,
    pct012a109 bigint,
    pct012a110 bigint,
    pct012a111 bigint,
    pct012a112 bigint,
    pct012a113 bigint,
    pct012a114 bigint,
    pct012a115 bigint,
    pct012a116 bigint,
    pct012a117 bigint,
    pct012a118 bigint,
    pct012a119 bigint,
    pct012a120 bigint,
    pct012a121 bigint,
    pct012a122 bigint,
    pct012a123 bigint,
    pct012a124 bigint,
    pct012a125 bigint,
    pct012a126 bigint,
    pct012a127 bigint,
    pct012a128 bigint,
    pct012a129 bigint,
    pct012a130 bigint,
    pct012a131 bigint,
    pct012a132 bigint,
    pct012a133 bigint,
    pct012a134 bigint,
    pct012a135 bigint,
    pct012a136 bigint,
    pct012a137 bigint,
    pct012a138 bigint,
    pct012a139 bigint,
    pct012a140 bigint,
    pct012a141 bigint,
    pct012a142 bigint,
    pct012a143 bigint,
    pct012a144 bigint,
    pct012a145 bigint,
    pct012a146 bigint,
    pct012a147 bigint,
    pct012a148 bigint,
    pct012a149 bigint,
    pct012a150 bigint,
    pct012a151 bigint,
    pct012a152 bigint,
    pct012a153 bigint,
    pct012a154 bigint,
    pct012a155 bigint,
    pct012a156 bigint,
    pct012a157 bigint,
    pct012a158 bigint,
    pct012a159 bigint,
    pct012a160 bigint,
    pct012a161 bigint,
    pct012a162 bigint,
    pct012a163 bigint,
    pct012a164 bigint,
    pct012a165 bigint,
    pct012a166 bigint,
    pct012a167 bigint,
    pct012a168 bigint,
    pct012a169 bigint,
    pct012a170 bigint,
    pct012a171 bigint,
    pct012a172 bigint,
    pct012a173 bigint,
    pct012a174 bigint,
    pct012a175 bigint,
    pct012a176 bigint,
    pct012a177 bigint,
    pct012a178 bigint,
    pct012a179 bigint,
    pct012a180 bigint,
    pct012a181 bigint,
    pct012a182 bigint,
    pct012a183 bigint,
    pct012a184 bigint,
    pct012a185 bigint,
    pct012a186 bigint,
    pct012a187 bigint,
    pct012a188 bigint,
    pct012a189 bigint,
    pct012a190 bigint,
    pct012a191 bigint,
    pct012a192 bigint,
    pct012a193 bigint,
    pct012a194 bigint,
    pct012a195 bigint,
    pct012a196 bigint,
    pct012a197 bigint,
    pct012a198 bigint,
    pct012a199 bigint,
    pct012a200 bigint,
    pct012a201 bigint,
    pct012a202 bigint,
    pct012a203 bigint,
    pct012a204 bigint,
    pct012a205 bigint,
    pct012a206 bigint,
    pct012a207 bigint,
    pct012a208 bigint,
    pct012a209 bigint
);


ALTER TABLE sf10016 OWNER TO census;

--
-- Name: sf10017; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10017 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct012b001 bigint,
    pct012b002 bigint,
    pct012b003 bigint,
    pct012b004 bigint,
    pct012b005 bigint,
    pct012b006 bigint,
    pct012b007 bigint,
    pct012b008 bigint,
    pct012b009 bigint,
    pct012b010 bigint,
    pct012b011 bigint,
    pct012b012 bigint,
    pct012b013 bigint,
    pct012b014 bigint,
    pct012b015 bigint,
    pct012b016 bigint,
    pct012b017 bigint,
    pct012b018 bigint,
    pct012b019 bigint,
    pct012b020 bigint,
    pct012b021 bigint,
    pct012b022 bigint,
    pct012b023 bigint,
    pct012b024 bigint,
    pct012b025 bigint,
    pct012b026 bigint,
    pct012b027 bigint,
    pct012b028 bigint,
    pct012b029 bigint,
    pct012b030 bigint,
    pct012b031 bigint,
    pct012b032 bigint,
    pct012b033 bigint,
    pct012b034 bigint,
    pct012b035 bigint,
    pct012b036 bigint,
    pct012b037 bigint,
    pct012b038 bigint,
    pct012b039 bigint,
    pct012b040 bigint,
    pct012b041 bigint,
    pct012b042 bigint,
    pct012b043 bigint,
    pct012b044 bigint,
    pct012b045 bigint,
    pct012b046 bigint,
    pct012b047 bigint,
    pct012b048 bigint,
    pct012b049 bigint,
    pct012b050 bigint,
    pct012b051 bigint,
    pct012b052 bigint,
    pct012b053 bigint,
    pct012b054 bigint,
    pct012b055 bigint,
    pct012b056 bigint,
    pct012b057 bigint,
    pct012b058 bigint,
    pct012b059 bigint,
    pct012b060 bigint,
    pct012b061 bigint,
    pct012b062 bigint,
    pct012b063 bigint,
    pct012b064 bigint,
    pct012b065 bigint,
    pct012b066 bigint,
    pct012b067 bigint,
    pct012b068 bigint,
    pct012b069 bigint,
    pct012b070 bigint,
    pct012b071 bigint,
    pct012b072 bigint,
    pct012b073 bigint,
    pct012b074 bigint,
    pct012b075 bigint,
    pct012b076 bigint,
    pct012b077 bigint,
    pct012b078 bigint,
    pct012b079 bigint,
    pct012b080 bigint,
    pct012b081 bigint,
    pct012b082 bigint,
    pct012b083 bigint,
    pct012b084 bigint,
    pct012b085 bigint,
    pct012b086 bigint,
    pct012b087 bigint,
    pct012b088 bigint,
    pct012b089 bigint,
    pct012b090 bigint,
    pct012b091 bigint,
    pct012b092 bigint,
    pct012b093 bigint,
    pct012b094 bigint,
    pct012b095 bigint,
    pct012b096 bigint,
    pct012b097 bigint,
    pct012b098 bigint,
    pct012b099 bigint,
    pct012b100 bigint,
    pct012b101 bigint,
    pct012b102 bigint,
    pct012b103 bigint,
    pct012b104 bigint,
    pct012b105 bigint,
    pct012b106 bigint,
    pct012b107 bigint,
    pct012b108 bigint,
    pct012b109 bigint,
    pct012b110 bigint,
    pct012b111 bigint,
    pct012b112 bigint,
    pct012b113 bigint,
    pct012b114 bigint,
    pct012b115 bigint,
    pct012b116 bigint,
    pct012b117 bigint,
    pct012b118 bigint,
    pct012b119 bigint,
    pct012b120 bigint,
    pct012b121 bigint,
    pct012b122 bigint,
    pct012b123 bigint,
    pct012b124 bigint,
    pct012b125 bigint,
    pct012b126 bigint,
    pct012b127 bigint,
    pct012b128 bigint,
    pct012b129 bigint,
    pct012b130 bigint,
    pct012b131 bigint,
    pct012b132 bigint,
    pct012b133 bigint,
    pct012b134 bigint,
    pct012b135 bigint,
    pct012b136 bigint,
    pct012b137 bigint,
    pct012b138 bigint,
    pct012b139 bigint,
    pct012b140 bigint,
    pct012b141 bigint,
    pct012b142 bigint,
    pct012b143 bigint,
    pct012b144 bigint,
    pct012b145 bigint,
    pct012b146 bigint,
    pct012b147 bigint,
    pct012b148 bigint,
    pct012b149 bigint,
    pct012b150 bigint,
    pct012b151 bigint,
    pct012b152 bigint,
    pct012b153 bigint,
    pct012b154 bigint,
    pct012b155 bigint,
    pct012b156 bigint,
    pct012b157 bigint,
    pct012b158 bigint,
    pct012b159 bigint,
    pct012b160 bigint,
    pct012b161 bigint,
    pct012b162 bigint,
    pct012b163 bigint,
    pct012b164 bigint,
    pct012b165 bigint,
    pct012b166 bigint,
    pct012b167 bigint,
    pct012b168 bigint,
    pct012b169 bigint,
    pct012b170 bigint,
    pct012b171 bigint,
    pct012b172 bigint,
    pct012b173 bigint,
    pct012b174 bigint,
    pct012b175 bigint,
    pct012b176 bigint,
    pct012b177 bigint,
    pct012b178 bigint,
    pct012b179 bigint,
    pct012b180 bigint,
    pct012b181 bigint,
    pct012b182 bigint,
    pct012b183 bigint,
    pct012b184 bigint,
    pct012b185 bigint,
    pct012b186 bigint,
    pct012b187 bigint,
    pct012b188 bigint,
    pct012b189 bigint,
    pct012b190 bigint,
    pct012b191 bigint,
    pct012b192 bigint,
    pct012b193 bigint,
    pct012b194 bigint,
    pct012b195 bigint,
    pct012b196 bigint,
    pct012b197 bigint,
    pct012b198 bigint,
    pct012b199 bigint,
    pct012b200 bigint,
    pct012b201 bigint,
    pct012b202 bigint,
    pct012b203 bigint,
    pct012b204 bigint,
    pct012b205 bigint,
    pct012b206 bigint,
    pct012b207 bigint,
    pct012b208 bigint,
    pct012b209 bigint
);


ALTER TABLE sf10017 OWNER TO census;

--
-- Name: sf10018; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10018 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct012c001 bigint,
    pct012c002 bigint,
    pct012c003 bigint,
    pct012c004 bigint,
    pct012c005 bigint,
    pct012c006 bigint,
    pct012c007 bigint,
    pct012c008 bigint,
    pct012c009 bigint,
    pct012c010 bigint,
    pct012c011 bigint,
    pct012c012 bigint,
    pct012c013 bigint,
    pct012c014 bigint,
    pct012c015 bigint,
    pct012c016 bigint,
    pct012c017 bigint,
    pct012c018 bigint,
    pct012c019 bigint,
    pct012c020 bigint,
    pct012c021 bigint,
    pct012c022 bigint,
    pct012c023 bigint,
    pct012c024 bigint,
    pct012c025 bigint,
    pct012c026 bigint,
    pct012c027 bigint,
    pct012c028 bigint,
    pct012c029 bigint,
    pct012c030 bigint,
    pct012c031 bigint,
    pct012c032 bigint,
    pct012c033 bigint,
    pct012c034 bigint,
    pct012c035 bigint,
    pct012c036 bigint,
    pct012c037 bigint,
    pct012c038 bigint,
    pct012c039 bigint,
    pct012c040 bigint,
    pct012c041 bigint,
    pct012c042 bigint,
    pct012c043 bigint,
    pct012c044 bigint,
    pct012c045 bigint,
    pct012c046 bigint,
    pct012c047 bigint,
    pct012c048 bigint,
    pct012c049 bigint,
    pct012c050 bigint,
    pct012c051 bigint,
    pct012c052 bigint,
    pct012c053 bigint,
    pct012c054 bigint,
    pct012c055 bigint,
    pct012c056 bigint,
    pct012c057 bigint,
    pct012c058 bigint,
    pct012c059 bigint,
    pct012c060 bigint,
    pct012c061 bigint,
    pct012c062 bigint,
    pct012c063 bigint,
    pct012c064 bigint,
    pct012c065 bigint,
    pct012c066 bigint,
    pct012c067 bigint,
    pct012c068 bigint,
    pct012c069 bigint,
    pct012c070 bigint,
    pct012c071 bigint,
    pct012c072 bigint,
    pct012c073 bigint,
    pct012c074 bigint,
    pct012c075 bigint,
    pct012c076 bigint,
    pct012c077 bigint,
    pct012c078 bigint,
    pct012c079 bigint,
    pct012c080 bigint,
    pct012c081 bigint,
    pct012c082 bigint,
    pct012c083 bigint,
    pct012c084 bigint,
    pct012c085 bigint,
    pct012c086 bigint,
    pct012c087 bigint,
    pct012c088 bigint,
    pct012c089 bigint,
    pct012c090 bigint,
    pct012c091 bigint,
    pct012c092 bigint,
    pct012c093 bigint,
    pct012c094 bigint,
    pct012c095 bigint,
    pct012c096 bigint,
    pct012c097 bigint,
    pct012c098 bigint,
    pct012c099 bigint,
    pct012c100 bigint,
    pct012c101 bigint,
    pct012c102 bigint,
    pct012c103 bigint,
    pct012c104 bigint,
    pct012c105 bigint,
    pct012c106 bigint,
    pct012c107 bigint,
    pct012c108 bigint,
    pct012c109 bigint,
    pct012c110 bigint,
    pct012c111 bigint,
    pct012c112 bigint,
    pct012c113 bigint,
    pct012c114 bigint,
    pct012c115 bigint,
    pct012c116 bigint,
    pct012c117 bigint,
    pct012c118 bigint,
    pct012c119 bigint,
    pct012c120 bigint,
    pct012c121 bigint,
    pct012c122 bigint,
    pct012c123 bigint,
    pct012c124 bigint,
    pct012c125 bigint,
    pct012c126 bigint,
    pct012c127 bigint,
    pct012c128 bigint,
    pct012c129 bigint,
    pct012c130 bigint,
    pct012c131 bigint,
    pct012c132 bigint,
    pct012c133 bigint,
    pct012c134 bigint,
    pct012c135 bigint,
    pct012c136 bigint,
    pct012c137 bigint,
    pct012c138 bigint,
    pct012c139 bigint,
    pct012c140 bigint,
    pct012c141 bigint,
    pct012c142 bigint,
    pct012c143 bigint,
    pct012c144 bigint,
    pct012c145 bigint,
    pct012c146 bigint,
    pct012c147 bigint,
    pct012c148 bigint,
    pct012c149 bigint,
    pct012c150 bigint,
    pct012c151 bigint,
    pct012c152 bigint,
    pct012c153 bigint,
    pct012c154 bigint,
    pct012c155 bigint,
    pct012c156 bigint,
    pct012c157 bigint,
    pct012c158 bigint,
    pct012c159 bigint,
    pct012c160 bigint,
    pct012c161 bigint,
    pct012c162 bigint,
    pct012c163 bigint,
    pct012c164 bigint,
    pct012c165 bigint,
    pct012c166 bigint,
    pct012c167 bigint,
    pct012c168 bigint,
    pct012c169 bigint,
    pct012c170 bigint,
    pct012c171 bigint,
    pct012c172 bigint,
    pct012c173 bigint,
    pct012c174 bigint,
    pct012c175 bigint,
    pct012c176 bigint,
    pct012c177 bigint,
    pct012c178 bigint,
    pct012c179 bigint,
    pct012c180 bigint,
    pct012c181 bigint,
    pct012c182 bigint,
    pct012c183 bigint,
    pct012c184 bigint,
    pct012c185 bigint,
    pct012c186 bigint,
    pct012c187 bigint,
    pct012c188 bigint,
    pct012c189 bigint,
    pct012c190 bigint,
    pct012c191 bigint,
    pct012c192 bigint,
    pct012c193 bigint,
    pct012c194 bigint,
    pct012c195 bigint,
    pct012c196 bigint,
    pct012c197 bigint,
    pct012c198 bigint,
    pct012c199 bigint,
    pct012c200 bigint,
    pct012c201 bigint,
    pct012c202 bigint,
    pct012c203 bigint,
    pct012c204 bigint,
    pct012c205 bigint,
    pct012c206 bigint,
    pct012c207 bigint,
    pct012c208 bigint,
    pct012c209 bigint
);


ALTER TABLE sf10018 OWNER TO census;

--
-- Name: sf10019; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10019 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct012d001 bigint,
    pct012d002 bigint,
    pct012d003 bigint,
    pct012d004 bigint,
    pct012d005 bigint,
    pct012d006 bigint,
    pct012d007 bigint,
    pct012d008 bigint,
    pct012d009 bigint,
    pct012d010 bigint,
    pct012d011 bigint,
    pct012d012 bigint,
    pct012d013 bigint,
    pct012d014 bigint,
    pct012d015 bigint,
    pct012d016 bigint,
    pct012d017 bigint,
    pct012d018 bigint,
    pct012d019 bigint,
    pct012d020 bigint,
    pct012d021 bigint,
    pct012d022 bigint,
    pct012d023 bigint,
    pct012d024 bigint,
    pct012d025 bigint,
    pct012d026 bigint,
    pct012d027 bigint,
    pct012d028 bigint,
    pct012d029 bigint,
    pct012d030 bigint,
    pct012d031 bigint,
    pct012d032 bigint,
    pct012d033 bigint,
    pct012d034 bigint,
    pct012d035 bigint,
    pct012d036 bigint,
    pct012d037 bigint,
    pct012d038 bigint,
    pct012d039 bigint,
    pct012d040 bigint,
    pct012d041 bigint,
    pct012d042 bigint,
    pct012d043 bigint,
    pct012d044 bigint,
    pct012d045 bigint,
    pct012d046 bigint,
    pct012d047 bigint,
    pct012d048 bigint,
    pct012d049 bigint,
    pct012d050 bigint,
    pct012d051 bigint,
    pct012d052 bigint,
    pct012d053 bigint,
    pct012d054 bigint,
    pct012d055 bigint,
    pct012d056 bigint,
    pct012d057 bigint,
    pct012d058 bigint,
    pct012d059 bigint,
    pct012d060 bigint,
    pct012d061 bigint,
    pct012d062 bigint,
    pct012d063 bigint,
    pct012d064 bigint,
    pct012d065 bigint,
    pct012d066 bigint,
    pct012d067 bigint,
    pct012d068 bigint,
    pct012d069 bigint,
    pct012d070 bigint,
    pct012d071 bigint,
    pct012d072 bigint,
    pct012d073 bigint,
    pct012d074 bigint,
    pct012d075 bigint,
    pct012d076 bigint,
    pct012d077 bigint,
    pct012d078 bigint,
    pct012d079 bigint,
    pct012d080 bigint,
    pct012d081 bigint,
    pct012d082 bigint,
    pct012d083 bigint,
    pct012d084 bigint,
    pct012d085 bigint,
    pct012d086 bigint,
    pct012d087 bigint,
    pct012d088 bigint,
    pct012d089 bigint,
    pct012d090 bigint,
    pct012d091 bigint,
    pct012d092 bigint,
    pct012d093 bigint,
    pct012d094 bigint,
    pct012d095 bigint,
    pct012d096 bigint,
    pct012d097 bigint,
    pct012d098 bigint,
    pct012d099 bigint,
    pct012d100 bigint,
    pct012d101 bigint,
    pct012d102 bigint,
    pct012d103 bigint,
    pct012d104 bigint,
    pct012d105 bigint,
    pct012d106 bigint,
    pct012d107 bigint,
    pct012d108 bigint,
    pct012d109 bigint,
    pct012d110 bigint,
    pct012d111 bigint,
    pct012d112 bigint,
    pct012d113 bigint,
    pct012d114 bigint,
    pct012d115 bigint,
    pct012d116 bigint,
    pct012d117 bigint,
    pct012d118 bigint,
    pct012d119 bigint,
    pct012d120 bigint,
    pct012d121 bigint,
    pct012d122 bigint,
    pct012d123 bigint,
    pct012d124 bigint,
    pct012d125 bigint,
    pct012d126 bigint,
    pct012d127 bigint,
    pct012d128 bigint,
    pct012d129 bigint,
    pct012d130 bigint,
    pct012d131 bigint,
    pct012d132 bigint,
    pct012d133 bigint,
    pct012d134 bigint,
    pct012d135 bigint,
    pct012d136 bigint,
    pct012d137 bigint,
    pct012d138 bigint,
    pct012d139 bigint,
    pct012d140 bigint,
    pct012d141 bigint,
    pct012d142 bigint,
    pct012d143 bigint,
    pct012d144 bigint,
    pct012d145 bigint,
    pct012d146 bigint,
    pct012d147 bigint,
    pct012d148 bigint,
    pct012d149 bigint,
    pct012d150 bigint,
    pct012d151 bigint,
    pct012d152 bigint,
    pct012d153 bigint,
    pct012d154 bigint,
    pct012d155 bigint,
    pct012d156 bigint,
    pct012d157 bigint,
    pct012d158 bigint,
    pct012d159 bigint,
    pct012d160 bigint,
    pct012d161 bigint,
    pct012d162 bigint,
    pct012d163 bigint,
    pct012d164 bigint,
    pct012d165 bigint,
    pct012d166 bigint,
    pct012d167 bigint,
    pct012d168 bigint,
    pct012d169 bigint,
    pct012d170 bigint,
    pct012d171 bigint,
    pct012d172 bigint,
    pct012d173 bigint,
    pct012d174 bigint,
    pct012d175 bigint,
    pct012d176 bigint,
    pct012d177 bigint,
    pct012d178 bigint,
    pct012d179 bigint,
    pct012d180 bigint,
    pct012d181 bigint,
    pct012d182 bigint,
    pct012d183 bigint,
    pct012d184 bigint,
    pct012d185 bigint,
    pct012d186 bigint,
    pct012d187 bigint,
    pct012d188 bigint,
    pct012d189 bigint,
    pct012d190 bigint,
    pct012d191 bigint,
    pct012d192 bigint,
    pct012d193 bigint,
    pct012d194 bigint,
    pct012d195 bigint,
    pct012d196 bigint,
    pct012d197 bigint,
    pct012d198 bigint,
    pct012d199 bigint,
    pct012d200 bigint,
    pct012d201 bigint,
    pct012d202 bigint,
    pct012d203 bigint,
    pct012d204 bigint,
    pct012d205 bigint,
    pct012d206 bigint,
    pct012d207 bigint,
    pct012d208 bigint,
    pct012d209 bigint
);


ALTER TABLE sf10019 OWNER TO census;

--
-- Name: sf10020; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10020 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct012e001 bigint,
    pct012e002 bigint,
    pct012e003 bigint,
    pct012e004 bigint,
    pct012e005 bigint,
    pct012e006 bigint,
    pct012e007 bigint,
    pct012e008 bigint,
    pct012e009 bigint,
    pct012e010 bigint,
    pct012e011 bigint,
    pct012e012 bigint,
    pct012e013 bigint,
    pct012e014 bigint,
    pct012e015 bigint,
    pct012e016 bigint,
    pct012e017 bigint,
    pct012e018 bigint,
    pct012e019 bigint,
    pct012e020 bigint,
    pct012e021 bigint,
    pct012e022 bigint,
    pct012e023 bigint,
    pct012e024 bigint,
    pct012e025 bigint,
    pct012e026 bigint,
    pct012e027 bigint,
    pct012e028 bigint,
    pct012e029 bigint,
    pct012e030 bigint,
    pct012e031 bigint,
    pct012e032 bigint,
    pct012e033 bigint,
    pct012e034 bigint,
    pct012e035 bigint,
    pct012e036 bigint,
    pct012e037 bigint,
    pct012e038 bigint,
    pct012e039 bigint,
    pct012e040 bigint,
    pct012e041 bigint,
    pct012e042 bigint,
    pct012e043 bigint,
    pct012e044 bigint,
    pct012e045 bigint,
    pct012e046 bigint,
    pct012e047 bigint,
    pct012e048 bigint,
    pct012e049 bigint,
    pct012e050 bigint,
    pct012e051 bigint,
    pct012e052 bigint,
    pct012e053 bigint,
    pct012e054 bigint,
    pct012e055 bigint,
    pct012e056 bigint,
    pct012e057 bigint,
    pct012e058 bigint,
    pct012e059 bigint,
    pct012e060 bigint,
    pct012e061 bigint,
    pct012e062 bigint,
    pct012e063 bigint,
    pct012e064 bigint,
    pct012e065 bigint,
    pct012e066 bigint,
    pct012e067 bigint,
    pct012e068 bigint,
    pct012e069 bigint,
    pct012e070 bigint,
    pct012e071 bigint,
    pct012e072 bigint,
    pct012e073 bigint,
    pct012e074 bigint,
    pct012e075 bigint,
    pct012e076 bigint,
    pct012e077 bigint,
    pct012e078 bigint,
    pct012e079 bigint,
    pct012e080 bigint,
    pct012e081 bigint,
    pct012e082 bigint,
    pct012e083 bigint,
    pct012e084 bigint,
    pct012e085 bigint,
    pct012e086 bigint,
    pct012e087 bigint,
    pct012e088 bigint,
    pct012e089 bigint,
    pct012e090 bigint,
    pct012e091 bigint,
    pct012e092 bigint,
    pct012e093 bigint,
    pct012e094 bigint,
    pct012e095 bigint,
    pct012e096 bigint,
    pct012e097 bigint,
    pct012e098 bigint,
    pct012e099 bigint,
    pct012e100 bigint,
    pct012e101 bigint,
    pct012e102 bigint,
    pct012e103 bigint,
    pct012e104 bigint,
    pct012e105 bigint,
    pct012e106 bigint,
    pct012e107 bigint,
    pct012e108 bigint,
    pct012e109 bigint,
    pct012e110 bigint,
    pct012e111 bigint,
    pct012e112 bigint,
    pct012e113 bigint,
    pct012e114 bigint,
    pct012e115 bigint,
    pct012e116 bigint,
    pct012e117 bigint,
    pct012e118 bigint,
    pct012e119 bigint,
    pct012e120 bigint,
    pct012e121 bigint,
    pct012e122 bigint,
    pct012e123 bigint,
    pct012e124 bigint,
    pct012e125 bigint,
    pct012e126 bigint,
    pct012e127 bigint,
    pct012e128 bigint,
    pct012e129 bigint,
    pct012e130 bigint,
    pct012e131 bigint,
    pct012e132 bigint,
    pct012e133 bigint,
    pct012e134 bigint,
    pct012e135 bigint,
    pct012e136 bigint,
    pct012e137 bigint,
    pct012e138 bigint,
    pct012e139 bigint,
    pct012e140 bigint,
    pct012e141 bigint,
    pct012e142 bigint,
    pct012e143 bigint,
    pct012e144 bigint,
    pct012e145 bigint,
    pct012e146 bigint,
    pct012e147 bigint,
    pct012e148 bigint,
    pct012e149 bigint,
    pct012e150 bigint,
    pct012e151 bigint,
    pct012e152 bigint,
    pct012e153 bigint,
    pct012e154 bigint,
    pct012e155 bigint,
    pct012e156 bigint,
    pct012e157 bigint,
    pct012e158 bigint,
    pct012e159 bigint,
    pct012e160 bigint,
    pct012e161 bigint,
    pct012e162 bigint,
    pct012e163 bigint,
    pct012e164 bigint,
    pct012e165 bigint,
    pct012e166 bigint,
    pct012e167 bigint,
    pct012e168 bigint,
    pct012e169 bigint,
    pct012e170 bigint,
    pct012e171 bigint,
    pct012e172 bigint,
    pct012e173 bigint,
    pct012e174 bigint,
    pct012e175 bigint,
    pct012e176 bigint,
    pct012e177 bigint,
    pct012e178 bigint,
    pct012e179 bigint,
    pct012e180 bigint,
    pct012e181 bigint,
    pct012e182 bigint,
    pct012e183 bigint,
    pct012e184 bigint,
    pct012e185 bigint,
    pct012e186 bigint,
    pct012e187 bigint,
    pct012e188 bigint,
    pct012e189 bigint,
    pct012e190 bigint,
    pct012e191 bigint,
    pct012e192 bigint,
    pct012e193 bigint,
    pct012e194 bigint,
    pct012e195 bigint,
    pct012e196 bigint,
    pct012e197 bigint,
    pct012e198 bigint,
    pct012e199 bigint,
    pct012e200 bigint,
    pct012e201 bigint,
    pct012e202 bigint,
    pct012e203 bigint,
    pct012e204 bigint,
    pct012e205 bigint,
    pct012e206 bigint,
    pct012e207 bigint,
    pct012e208 bigint,
    pct012e209 bigint
);


ALTER TABLE sf10020 OWNER TO census;

--
-- Name: sf10021; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10021 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct012f001 bigint,
    pct012f002 bigint,
    pct012f003 bigint,
    pct012f004 bigint,
    pct012f005 bigint,
    pct012f006 bigint,
    pct012f007 bigint,
    pct012f008 bigint,
    pct012f009 bigint,
    pct012f010 bigint,
    pct012f011 bigint,
    pct012f012 bigint,
    pct012f013 bigint,
    pct012f014 bigint,
    pct012f015 bigint,
    pct012f016 bigint,
    pct012f017 bigint,
    pct012f018 bigint,
    pct012f019 bigint,
    pct012f020 bigint,
    pct012f021 bigint,
    pct012f022 bigint,
    pct012f023 bigint,
    pct012f024 bigint,
    pct012f025 bigint,
    pct012f026 bigint,
    pct012f027 bigint,
    pct012f028 bigint,
    pct012f029 bigint,
    pct012f030 bigint,
    pct012f031 bigint,
    pct012f032 bigint,
    pct012f033 bigint,
    pct012f034 bigint,
    pct012f035 bigint,
    pct012f036 bigint,
    pct012f037 bigint,
    pct012f038 bigint,
    pct012f039 bigint,
    pct012f040 bigint,
    pct012f041 bigint,
    pct012f042 bigint,
    pct012f043 bigint,
    pct012f044 bigint,
    pct012f045 bigint,
    pct012f046 bigint,
    pct012f047 bigint,
    pct012f048 bigint,
    pct012f049 bigint,
    pct012f050 bigint,
    pct012f051 bigint,
    pct012f052 bigint,
    pct012f053 bigint,
    pct012f054 bigint,
    pct012f055 bigint,
    pct012f056 bigint,
    pct012f057 bigint,
    pct012f058 bigint,
    pct012f059 bigint,
    pct012f060 bigint,
    pct012f061 bigint,
    pct012f062 bigint,
    pct012f063 bigint,
    pct012f064 bigint,
    pct012f065 bigint,
    pct012f066 bigint,
    pct012f067 bigint,
    pct012f068 bigint,
    pct012f069 bigint,
    pct012f070 bigint,
    pct012f071 bigint,
    pct012f072 bigint,
    pct012f073 bigint,
    pct012f074 bigint,
    pct012f075 bigint,
    pct012f076 bigint,
    pct012f077 bigint,
    pct012f078 bigint,
    pct012f079 bigint,
    pct012f080 bigint,
    pct012f081 bigint,
    pct012f082 bigint,
    pct012f083 bigint,
    pct012f084 bigint,
    pct012f085 bigint,
    pct012f086 bigint,
    pct012f087 bigint,
    pct012f088 bigint,
    pct012f089 bigint,
    pct012f090 bigint,
    pct012f091 bigint,
    pct012f092 bigint,
    pct012f093 bigint,
    pct012f094 bigint,
    pct012f095 bigint,
    pct012f096 bigint,
    pct012f097 bigint,
    pct012f098 bigint,
    pct012f099 bigint,
    pct012f100 bigint,
    pct012f101 bigint,
    pct012f102 bigint,
    pct012f103 bigint,
    pct012f104 bigint,
    pct012f105 bigint,
    pct012f106 bigint,
    pct012f107 bigint,
    pct012f108 bigint,
    pct012f109 bigint,
    pct012f110 bigint,
    pct012f111 bigint,
    pct012f112 bigint,
    pct012f113 bigint,
    pct012f114 bigint,
    pct012f115 bigint,
    pct012f116 bigint,
    pct012f117 bigint,
    pct012f118 bigint,
    pct012f119 bigint,
    pct012f120 bigint,
    pct012f121 bigint,
    pct012f122 bigint,
    pct012f123 bigint,
    pct012f124 bigint,
    pct012f125 bigint,
    pct012f126 bigint,
    pct012f127 bigint,
    pct012f128 bigint,
    pct012f129 bigint,
    pct012f130 bigint,
    pct012f131 bigint,
    pct012f132 bigint,
    pct012f133 bigint,
    pct012f134 bigint,
    pct012f135 bigint,
    pct012f136 bigint,
    pct012f137 bigint,
    pct012f138 bigint,
    pct012f139 bigint,
    pct012f140 bigint,
    pct012f141 bigint,
    pct012f142 bigint,
    pct012f143 bigint,
    pct012f144 bigint,
    pct012f145 bigint,
    pct012f146 bigint,
    pct012f147 bigint,
    pct012f148 bigint,
    pct012f149 bigint,
    pct012f150 bigint,
    pct012f151 bigint,
    pct012f152 bigint,
    pct012f153 bigint,
    pct012f154 bigint,
    pct012f155 bigint,
    pct012f156 bigint,
    pct012f157 bigint,
    pct012f158 bigint,
    pct012f159 bigint,
    pct012f160 bigint,
    pct012f161 bigint,
    pct012f162 bigint,
    pct012f163 bigint,
    pct012f164 bigint,
    pct012f165 bigint,
    pct012f166 bigint,
    pct012f167 bigint,
    pct012f168 bigint,
    pct012f169 bigint,
    pct012f170 bigint,
    pct012f171 bigint,
    pct012f172 bigint,
    pct012f173 bigint,
    pct012f174 bigint,
    pct012f175 bigint,
    pct012f176 bigint,
    pct012f177 bigint,
    pct012f178 bigint,
    pct012f179 bigint,
    pct012f180 bigint,
    pct012f181 bigint,
    pct012f182 bigint,
    pct012f183 bigint,
    pct012f184 bigint,
    pct012f185 bigint,
    pct012f186 bigint,
    pct012f187 bigint,
    pct012f188 bigint,
    pct012f189 bigint,
    pct012f190 bigint,
    pct012f191 bigint,
    pct012f192 bigint,
    pct012f193 bigint,
    pct012f194 bigint,
    pct012f195 bigint,
    pct012f196 bigint,
    pct012f197 bigint,
    pct012f198 bigint,
    pct012f199 bigint,
    pct012f200 bigint,
    pct012f201 bigint,
    pct012f202 bigint,
    pct012f203 bigint,
    pct012f204 bigint,
    pct012f205 bigint,
    pct012f206 bigint,
    pct012f207 bigint,
    pct012f208 bigint,
    pct012f209 bigint
);


ALTER TABLE sf10021 OWNER TO census;

--
-- Name: sf10022; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10022 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct012g001 bigint,
    pct012g002 bigint,
    pct012g003 bigint,
    pct012g004 bigint,
    pct012g005 bigint,
    pct012g006 bigint,
    pct012g007 bigint,
    pct012g008 bigint,
    pct012g009 bigint,
    pct012g010 bigint,
    pct012g011 bigint,
    pct012g012 bigint,
    pct012g013 bigint,
    pct012g014 bigint,
    pct012g015 bigint,
    pct012g016 bigint,
    pct012g017 bigint,
    pct012g018 bigint,
    pct012g019 bigint,
    pct012g020 bigint,
    pct012g021 bigint,
    pct012g022 bigint,
    pct012g023 bigint,
    pct012g024 bigint,
    pct012g025 bigint,
    pct012g026 bigint,
    pct012g027 bigint,
    pct012g028 bigint,
    pct012g029 bigint,
    pct012g030 bigint,
    pct012g031 bigint,
    pct012g032 bigint,
    pct012g033 bigint,
    pct012g034 bigint,
    pct012g035 bigint,
    pct012g036 bigint,
    pct012g037 bigint,
    pct012g038 bigint,
    pct012g039 bigint,
    pct012g040 bigint,
    pct012g041 bigint,
    pct012g042 bigint,
    pct012g043 bigint,
    pct012g044 bigint,
    pct012g045 bigint,
    pct012g046 bigint,
    pct012g047 bigint,
    pct012g048 bigint,
    pct012g049 bigint,
    pct012g050 bigint,
    pct012g051 bigint,
    pct012g052 bigint,
    pct012g053 bigint,
    pct012g054 bigint,
    pct012g055 bigint,
    pct012g056 bigint,
    pct012g057 bigint,
    pct012g058 bigint,
    pct012g059 bigint,
    pct012g060 bigint,
    pct012g061 bigint,
    pct012g062 bigint,
    pct012g063 bigint,
    pct012g064 bigint,
    pct012g065 bigint,
    pct012g066 bigint,
    pct012g067 bigint,
    pct012g068 bigint,
    pct012g069 bigint,
    pct012g070 bigint,
    pct012g071 bigint,
    pct012g072 bigint,
    pct012g073 bigint,
    pct012g074 bigint,
    pct012g075 bigint,
    pct012g076 bigint,
    pct012g077 bigint,
    pct012g078 bigint,
    pct012g079 bigint,
    pct012g080 bigint,
    pct012g081 bigint,
    pct012g082 bigint,
    pct012g083 bigint,
    pct012g084 bigint,
    pct012g085 bigint,
    pct012g086 bigint,
    pct012g087 bigint,
    pct012g088 bigint,
    pct012g089 bigint,
    pct012g090 bigint,
    pct012g091 bigint,
    pct012g092 bigint,
    pct012g093 bigint,
    pct012g094 bigint,
    pct012g095 bigint,
    pct012g096 bigint,
    pct012g097 bigint,
    pct012g098 bigint,
    pct012g099 bigint,
    pct012g100 bigint,
    pct012g101 bigint,
    pct012g102 bigint,
    pct012g103 bigint,
    pct012g104 bigint,
    pct012g105 bigint,
    pct012g106 bigint,
    pct012g107 bigint,
    pct012g108 bigint,
    pct012g109 bigint,
    pct012g110 bigint,
    pct012g111 bigint,
    pct012g112 bigint,
    pct012g113 bigint,
    pct012g114 bigint,
    pct012g115 bigint,
    pct012g116 bigint,
    pct012g117 bigint,
    pct012g118 bigint,
    pct012g119 bigint,
    pct012g120 bigint,
    pct012g121 bigint,
    pct012g122 bigint,
    pct012g123 bigint,
    pct012g124 bigint,
    pct012g125 bigint,
    pct012g126 bigint,
    pct012g127 bigint,
    pct012g128 bigint,
    pct012g129 bigint,
    pct012g130 bigint,
    pct012g131 bigint,
    pct012g132 bigint,
    pct012g133 bigint,
    pct012g134 bigint,
    pct012g135 bigint,
    pct012g136 bigint,
    pct012g137 bigint,
    pct012g138 bigint,
    pct012g139 bigint,
    pct012g140 bigint,
    pct012g141 bigint,
    pct012g142 bigint,
    pct012g143 bigint,
    pct012g144 bigint,
    pct012g145 bigint,
    pct012g146 bigint,
    pct012g147 bigint,
    pct012g148 bigint,
    pct012g149 bigint,
    pct012g150 bigint,
    pct012g151 bigint,
    pct012g152 bigint,
    pct012g153 bigint,
    pct012g154 bigint,
    pct012g155 bigint,
    pct012g156 bigint,
    pct012g157 bigint,
    pct012g158 bigint,
    pct012g159 bigint,
    pct012g160 bigint,
    pct012g161 bigint,
    pct012g162 bigint,
    pct012g163 bigint,
    pct012g164 bigint,
    pct012g165 bigint,
    pct012g166 bigint,
    pct012g167 bigint,
    pct012g168 bigint,
    pct012g169 bigint,
    pct012g170 bigint,
    pct012g171 bigint,
    pct012g172 bigint,
    pct012g173 bigint,
    pct012g174 bigint,
    pct012g175 bigint,
    pct012g176 bigint,
    pct012g177 bigint,
    pct012g178 bigint,
    pct012g179 bigint,
    pct012g180 bigint,
    pct012g181 bigint,
    pct012g182 bigint,
    pct012g183 bigint,
    pct012g184 bigint,
    pct012g185 bigint,
    pct012g186 bigint,
    pct012g187 bigint,
    pct012g188 bigint,
    pct012g189 bigint,
    pct012g190 bigint,
    pct012g191 bigint,
    pct012g192 bigint,
    pct012g193 bigint,
    pct012g194 bigint,
    pct012g195 bigint,
    pct012g196 bigint,
    pct012g197 bigint,
    pct012g198 bigint,
    pct012g199 bigint,
    pct012g200 bigint,
    pct012g201 bigint,
    pct012g202 bigint,
    pct012g203 bigint,
    pct012g204 bigint,
    pct012g205 bigint,
    pct012g206 bigint,
    pct012g207 bigint,
    pct012g208 bigint,
    pct012g209 bigint
);


ALTER TABLE sf10022 OWNER TO census;

--
-- Name: sf10023; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10023 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct012h001 bigint,
    pct012h002 bigint,
    pct012h003 bigint,
    pct012h004 bigint,
    pct012h005 bigint,
    pct012h006 bigint,
    pct012h007 bigint,
    pct012h008 bigint,
    pct012h009 bigint,
    pct012h010 bigint,
    pct012h011 bigint,
    pct012h012 bigint,
    pct012h013 bigint,
    pct012h014 bigint,
    pct012h015 bigint,
    pct012h016 bigint,
    pct012h017 bigint,
    pct012h018 bigint,
    pct012h019 bigint,
    pct012h020 bigint,
    pct012h021 bigint,
    pct012h022 bigint,
    pct012h023 bigint,
    pct012h024 bigint,
    pct012h025 bigint,
    pct012h026 bigint,
    pct012h027 bigint,
    pct012h028 bigint,
    pct012h029 bigint,
    pct012h030 bigint,
    pct012h031 bigint,
    pct012h032 bigint,
    pct012h033 bigint,
    pct012h034 bigint,
    pct012h035 bigint,
    pct012h036 bigint,
    pct012h037 bigint,
    pct012h038 bigint,
    pct012h039 bigint,
    pct012h040 bigint,
    pct012h041 bigint,
    pct012h042 bigint,
    pct012h043 bigint,
    pct012h044 bigint,
    pct012h045 bigint,
    pct012h046 bigint,
    pct012h047 bigint,
    pct012h048 bigint,
    pct012h049 bigint,
    pct012h050 bigint,
    pct012h051 bigint,
    pct012h052 bigint,
    pct012h053 bigint,
    pct012h054 bigint,
    pct012h055 bigint,
    pct012h056 bigint,
    pct012h057 bigint,
    pct012h058 bigint,
    pct012h059 bigint,
    pct012h060 bigint,
    pct012h061 bigint,
    pct012h062 bigint,
    pct012h063 bigint,
    pct012h064 bigint,
    pct012h065 bigint,
    pct012h066 bigint,
    pct012h067 bigint,
    pct012h068 bigint,
    pct012h069 bigint,
    pct012h070 bigint,
    pct012h071 bigint,
    pct012h072 bigint,
    pct012h073 bigint,
    pct012h074 bigint,
    pct012h075 bigint,
    pct012h076 bigint,
    pct012h077 bigint,
    pct012h078 bigint,
    pct012h079 bigint,
    pct012h080 bigint,
    pct012h081 bigint,
    pct012h082 bigint,
    pct012h083 bigint,
    pct012h084 bigint,
    pct012h085 bigint,
    pct012h086 bigint,
    pct012h087 bigint,
    pct012h088 bigint,
    pct012h089 bigint,
    pct012h090 bigint,
    pct012h091 bigint,
    pct012h092 bigint,
    pct012h093 bigint,
    pct012h094 bigint,
    pct012h095 bigint,
    pct012h096 bigint,
    pct012h097 bigint,
    pct012h098 bigint,
    pct012h099 bigint,
    pct012h100 bigint,
    pct012h101 bigint,
    pct012h102 bigint,
    pct012h103 bigint,
    pct012h104 bigint,
    pct012h105 bigint,
    pct012h106 bigint,
    pct012h107 bigint,
    pct012h108 bigint,
    pct012h109 bigint,
    pct012h110 bigint,
    pct012h111 bigint,
    pct012h112 bigint,
    pct012h113 bigint,
    pct012h114 bigint,
    pct012h115 bigint,
    pct012h116 bigint,
    pct012h117 bigint,
    pct012h118 bigint,
    pct012h119 bigint,
    pct012h120 bigint,
    pct012h121 bigint,
    pct012h122 bigint,
    pct012h123 bigint,
    pct012h124 bigint,
    pct012h125 bigint,
    pct012h126 bigint,
    pct012h127 bigint,
    pct012h128 bigint,
    pct012h129 bigint,
    pct012h130 bigint,
    pct012h131 bigint,
    pct012h132 bigint,
    pct012h133 bigint,
    pct012h134 bigint,
    pct012h135 bigint,
    pct012h136 bigint,
    pct012h137 bigint,
    pct012h138 bigint,
    pct012h139 bigint,
    pct012h140 bigint,
    pct012h141 bigint,
    pct012h142 bigint,
    pct012h143 bigint,
    pct012h144 bigint,
    pct012h145 bigint,
    pct012h146 bigint,
    pct012h147 bigint,
    pct012h148 bigint,
    pct012h149 bigint,
    pct012h150 bigint,
    pct012h151 bigint,
    pct012h152 bigint,
    pct012h153 bigint,
    pct012h154 bigint,
    pct012h155 bigint,
    pct012h156 bigint,
    pct012h157 bigint,
    pct012h158 bigint,
    pct012h159 bigint,
    pct012h160 bigint,
    pct012h161 bigint,
    pct012h162 bigint,
    pct012h163 bigint,
    pct012h164 bigint,
    pct012h165 bigint,
    pct012h166 bigint,
    pct012h167 bigint,
    pct012h168 bigint,
    pct012h169 bigint,
    pct012h170 bigint,
    pct012h171 bigint,
    pct012h172 bigint,
    pct012h173 bigint,
    pct012h174 bigint,
    pct012h175 bigint,
    pct012h176 bigint,
    pct012h177 bigint,
    pct012h178 bigint,
    pct012h179 bigint,
    pct012h180 bigint,
    pct012h181 bigint,
    pct012h182 bigint,
    pct012h183 bigint,
    pct012h184 bigint,
    pct012h185 bigint,
    pct012h186 bigint,
    pct012h187 bigint,
    pct012h188 bigint,
    pct012h189 bigint,
    pct012h190 bigint,
    pct012h191 bigint,
    pct012h192 bigint,
    pct012h193 bigint,
    pct012h194 bigint,
    pct012h195 bigint,
    pct012h196 bigint,
    pct012h197 bigint,
    pct012h198 bigint,
    pct012h199 bigint,
    pct012h200 bigint,
    pct012h201 bigint,
    pct012h202 bigint,
    pct012h203 bigint,
    pct012h204 bigint,
    pct012h205 bigint,
    pct012h206 bigint,
    pct012h207 bigint,
    pct012h208 bigint,
    pct012h209 bigint
);


ALTER TABLE sf10023 OWNER TO census;

--
-- Name: sf10024; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10024 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct012i001 bigint,
    pct012i002 bigint,
    pct012i003 bigint,
    pct012i004 bigint,
    pct012i005 bigint,
    pct012i006 bigint,
    pct012i007 bigint,
    pct012i008 bigint,
    pct012i009 bigint,
    pct012i010 bigint,
    pct012i011 bigint,
    pct012i012 bigint,
    pct012i013 bigint,
    pct012i014 bigint,
    pct012i015 bigint,
    pct012i016 bigint,
    pct012i017 bigint,
    pct012i018 bigint,
    pct012i019 bigint,
    pct012i020 bigint,
    pct012i021 bigint,
    pct012i022 bigint,
    pct012i023 bigint,
    pct012i024 bigint,
    pct012i025 bigint,
    pct012i026 bigint,
    pct012i027 bigint,
    pct012i028 bigint,
    pct012i029 bigint,
    pct012i030 bigint,
    pct012i031 bigint,
    pct012i032 bigint,
    pct012i033 bigint,
    pct012i034 bigint,
    pct012i035 bigint,
    pct012i036 bigint,
    pct012i037 bigint,
    pct012i038 bigint,
    pct012i039 bigint,
    pct012i040 bigint,
    pct012i041 bigint,
    pct012i042 bigint,
    pct012i043 bigint,
    pct012i044 bigint,
    pct012i045 bigint,
    pct012i046 bigint,
    pct012i047 bigint,
    pct012i048 bigint,
    pct012i049 bigint,
    pct012i050 bigint,
    pct012i051 bigint,
    pct012i052 bigint,
    pct012i053 bigint,
    pct012i054 bigint,
    pct012i055 bigint,
    pct012i056 bigint,
    pct012i057 bigint,
    pct012i058 bigint,
    pct012i059 bigint,
    pct012i060 bigint,
    pct012i061 bigint,
    pct012i062 bigint,
    pct012i063 bigint,
    pct012i064 bigint,
    pct012i065 bigint,
    pct012i066 bigint,
    pct012i067 bigint,
    pct012i068 bigint,
    pct012i069 bigint,
    pct012i070 bigint,
    pct012i071 bigint,
    pct012i072 bigint,
    pct012i073 bigint,
    pct012i074 bigint,
    pct012i075 bigint,
    pct012i076 bigint,
    pct012i077 bigint,
    pct012i078 bigint,
    pct012i079 bigint,
    pct012i080 bigint,
    pct012i081 bigint,
    pct012i082 bigint,
    pct012i083 bigint,
    pct012i084 bigint,
    pct012i085 bigint,
    pct012i086 bigint,
    pct012i087 bigint,
    pct012i088 bigint,
    pct012i089 bigint,
    pct012i090 bigint,
    pct012i091 bigint,
    pct012i092 bigint,
    pct012i093 bigint,
    pct012i094 bigint,
    pct012i095 bigint,
    pct012i096 bigint,
    pct012i097 bigint,
    pct012i098 bigint,
    pct012i099 bigint,
    pct012i100 bigint,
    pct012i101 bigint,
    pct012i102 bigint,
    pct012i103 bigint,
    pct012i104 bigint,
    pct012i105 bigint,
    pct012i106 bigint,
    pct012i107 bigint,
    pct012i108 bigint,
    pct012i109 bigint,
    pct012i110 bigint,
    pct012i111 bigint,
    pct012i112 bigint,
    pct012i113 bigint,
    pct012i114 bigint,
    pct012i115 bigint,
    pct012i116 bigint,
    pct012i117 bigint,
    pct012i118 bigint,
    pct012i119 bigint,
    pct012i120 bigint,
    pct012i121 bigint,
    pct012i122 bigint,
    pct012i123 bigint,
    pct012i124 bigint,
    pct012i125 bigint,
    pct012i126 bigint,
    pct012i127 bigint,
    pct012i128 bigint,
    pct012i129 bigint,
    pct012i130 bigint,
    pct012i131 bigint,
    pct012i132 bigint,
    pct012i133 bigint,
    pct012i134 bigint,
    pct012i135 bigint,
    pct012i136 bigint,
    pct012i137 bigint,
    pct012i138 bigint,
    pct012i139 bigint,
    pct012i140 bigint,
    pct012i141 bigint,
    pct012i142 bigint,
    pct012i143 bigint,
    pct012i144 bigint,
    pct012i145 bigint,
    pct012i146 bigint,
    pct012i147 bigint,
    pct012i148 bigint,
    pct012i149 bigint,
    pct012i150 bigint,
    pct012i151 bigint,
    pct012i152 bigint,
    pct012i153 bigint,
    pct012i154 bigint,
    pct012i155 bigint,
    pct012i156 bigint,
    pct012i157 bigint,
    pct012i158 bigint,
    pct012i159 bigint,
    pct012i160 bigint,
    pct012i161 bigint,
    pct012i162 bigint,
    pct012i163 bigint,
    pct012i164 bigint,
    pct012i165 bigint,
    pct012i166 bigint,
    pct012i167 bigint,
    pct012i168 bigint,
    pct012i169 bigint,
    pct012i170 bigint,
    pct012i171 bigint,
    pct012i172 bigint,
    pct012i173 bigint,
    pct012i174 bigint,
    pct012i175 bigint,
    pct012i176 bigint,
    pct012i177 bigint,
    pct012i178 bigint,
    pct012i179 bigint,
    pct012i180 bigint,
    pct012i181 bigint,
    pct012i182 bigint,
    pct012i183 bigint,
    pct012i184 bigint,
    pct012i185 bigint,
    pct012i186 bigint,
    pct012i187 bigint,
    pct012i188 bigint,
    pct012i189 bigint,
    pct012i190 bigint,
    pct012i191 bigint,
    pct012i192 bigint,
    pct012i193 bigint,
    pct012i194 bigint,
    pct012i195 bigint,
    pct012i196 bigint,
    pct012i197 bigint,
    pct012i198 bigint,
    pct012i199 bigint,
    pct012i200 bigint,
    pct012i201 bigint,
    pct012i202 bigint,
    pct012i203 bigint,
    pct012i204 bigint,
    pct012i205 bigint,
    pct012i206 bigint,
    pct012i207 bigint,
    pct012i208 bigint,
    pct012i209 bigint
);


ALTER TABLE sf10024 OWNER TO census;

--
-- Name: sf10025; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10025 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct012j001 bigint,
    pct012j002 bigint,
    pct012j003 bigint,
    pct012j004 bigint,
    pct012j005 bigint,
    pct012j006 bigint,
    pct012j007 bigint,
    pct012j008 bigint,
    pct012j009 bigint,
    pct012j010 bigint,
    pct012j011 bigint,
    pct012j012 bigint,
    pct012j013 bigint,
    pct012j014 bigint,
    pct012j015 bigint,
    pct012j016 bigint,
    pct012j017 bigint,
    pct012j018 bigint,
    pct012j019 bigint,
    pct012j020 bigint,
    pct012j021 bigint,
    pct012j022 bigint,
    pct012j023 bigint,
    pct012j024 bigint,
    pct012j025 bigint,
    pct012j026 bigint,
    pct012j027 bigint,
    pct012j028 bigint,
    pct012j029 bigint,
    pct012j030 bigint,
    pct012j031 bigint,
    pct012j032 bigint,
    pct012j033 bigint,
    pct012j034 bigint,
    pct012j035 bigint,
    pct012j036 bigint,
    pct012j037 bigint,
    pct012j038 bigint,
    pct012j039 bigint,
    pct012j040 bigint,
    pct012j041 bigint,
    pct012j042 bigint,
    pct012j043 bigint,
    pct012j044 bigint,
    pct012j045 bigint,
    pct012j046 bigint,
    pct012j047 bigint,
    pct012j048 bigint,
    pct012j049 bigint,
    pct012j050 bigint,
    pct012j051 bigint,
    pct012j052 bigint,
    pct012j053 bigint,
    pct012j054 bigint,
    pct012j055 bigint,
    pct012j056 bigint,
    pct012j057 bigint,
    pct012j058 bigint,
    pct012j059 bigint,
    pct012j060 bigint,
    pct012j061 bigint,
    pct012j062 bigint,
    pct012j063 bigint,
    pct012j064 bigint,
    pct012j065 bigint,
    pct012j066 bigint,
    pct012j067 bigint,
    pct012j068 bigint,
    pct012j069 bigint,
    pct012j070 bigint,
    pct012j071 bigint,
    pct012j072 bigint,
    pct012j073 bigint,
    pct012j074 bigint,
    pct012j075 bigint,
    pct012j076 bigint,
    pct012j077 bigint,
    pct012j078 bigint,
    pct012j079 bigint,
    pct012j080 bigint,
    pct012j081 bigint,
    pct012j082 bigint,
    pct012j083 bigint,
    pct012j084 bigint,
    pct012j085 bigint,
    pct012j086 bigint,
    pct012j087 bigint,
    pct012j088 bigint,
    pct012j089 bigint,
    pct012j090 bigint,
    pct012j091 bigint,
    pct012j092 bigint,
    pct012j093 bigint,
    pct012j094 bigint,
    pct012j095 bigint,
    pct012j096 bigint,
    pct012j097 bigint,
    pct012j098 bigint,
    pct012j099 bigint,
    pct012j100 bigint,
    pct012j101 bigint,
    pct012j102 bigint,
    pct012j103 bigint,
    pct012j104 bigint,
    pct012j105 bigint,
    pct012j106 bigint,
    pct012j107 bigint,
    pct012j108 bigint,
    pct012j109 bigint,
    pct012j110 bigint,
    pct012j111 bigint,
    pct012j112 bigint,
    pct012j113 bigint,
    pct012j114 bigint,
    pct012j115 bigint,
    pct012j116 bigint,
    pct012j117 bigint,
    pct012j118 bigint,
    pct012j119 bigint,
    pct012j120 bigint,
    pct012j121 bigint,
    pct012j122 bigint,
    pct012j123 bigint,
    pct012j124 bigint,
    pct012j125 bigint,
    pct012j126 bigint,
    pct012j127 bigint,
    pct012j128 bigint,
    pct012j129 bigint,
    pct012j130 bigint,
    pct012j131 bigint,
    pct012j132 bigint,
    pct012j133 bigint,
    pct012j134 bigint,
    pct012j135 bigint,
    pct012j136 bigint,
    pct012j137 bigint,
    pct012j138 bigint,
    pct012j139 bigint,
    pct012j140 bigint,
    pct012j141 bigint,
    pct012j142 bigint,
    pct012j143 bigint,
    pct012j144 bigint,
    pct012j145 bigint,
    pct012j146 bigint,
    pct012j147 bigint,
    pct012j148 bigint,
    pct012j149 bigint,
    pct012j150 bigint,
    pct012j151 bigint,
    pct012j152 bigint,
    pct012j153 bigint,
    pct012j154 bigint,
    pct012j155 bigint,
    pct012j156 bigint,
    pct012j157 bigint,
    pct012j158 bigint,
    pct012j159 bigint,
    pct012j160 bigint,
    pct012j161 bigint,
    pct012j162 bigint,
    pct012j163 bigint,
    pct012j164 bigint,
    pct012j165 bigint,
    pct012j166 bigint,
    pct012j167 bigint,
    pct012j168 bigint,
    pct012j169 bigint,
    pct012j170 bigint,
    pct012j171 bigint,
    pct012j172 bigint,
    pct012j173 bigint,
    pct012j174 bigint,
    pct012j175 bigint,
    pct012j176 bigint,
    pct012j177 bigint,
    pct012j178 bigint,
    pct012j179 bigint,
    pct012j180 bigint,
    pct012j181 bigint,
    pct012j182 bigint,
    pct012j183 bigint,
    pct012j184 bigint,
    pct012j185 bigint,
    pct012j186 bigint,
    pct012j187 bigint,
    pct012j188 bigint,
    pct012j189 bigint,
    pct012j190 bigint,
    pct012j191 bigint,
    pct012j192 bigint,
    pct012j193 bigint,
    pct012j194 bigint,
    pct012j195 bigint,
    pct012j196 bigint,
    pct012j197 bigint,
    pct012j198 bigint,
    pct012j199 bigint,
    pct012j200 bigint,
    pct012j201 bigint,
    pct012j202 bigint,
    pct012j203 bigint,
    pct012j204 bigint,
    pct012j205 bigint,
    pct012j206 bigint,
    pct012j207 bigint,
    pct012j208 bigint,
    pct012j209 bigint
);


ALTER TABLE sf10025 OWNER TO census;

--
-- Name: sf10026; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10026 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct012k001 bigint,
    pct012k002 bigint,
    pct012k003 bigint,
    pct012k004 bigint,
    pct012k005 bigint,
    pct012k006 bigint,
    pct012k007 bigint,
    pct012k008 bigint,
    pct012k009 bigint,
    pct012k010 bigint,
    pct012k011 bigint,
    pct012k012 bigint,
    pct012k013 bigint,
    pct012k014 bigint,
    pct012k015 bigint,
    pct012k016 bigint,
    pct012k017 bigint,
    pct012k018 bigint,
    pct012k019 bigint,
    pct012k020 bigint,
    pct012k021 bigint,
    pct012k022 bigint,
    pct012k023 bigint,
    pct012k024 bigint,
    pct012k025 bigint,
    pct012k026 bigint,
    pct012k027 bigint,
    pct012k028 bigint,
    pct012k029 bigint,
    pct012k030 bigint,
    pct012k031 bigint,
    pct012k032 bigint,
    pct012k033 bigint,
    pct012k034 bigint,
    pct012k035 bigint,
    pct012k036 bigint,
    pct012k037 bigint,
    pct012k038 bigint,
    pct012k039 bigint,
    pct012k040 bigint,
    pct012k041 bigint,
    pct012k042 bigint,
    pct012k043 bigint,
    pct012k044 bigint,
    pct012k045 bigint,
    pct012k046 bigint,
    pct012k047 bigint,
    pct012k048 bigint,
    pct012k049 bigint,
    pct012k050 bigint,
    pct012k051 bigint,
    pct012k052 bigint,
    pct012k053 bigint,
    pct012k054 bigint,
    pct012k055 bigint,
    pct012k056 bigint,
    pct012k057 bigint,
    pct012k058 bigint,
    pct012k059 bigint,
    pct012k060 bigint,
    pct012k061 bigint,
    pct012k062 bigint,
    pct012k063 bigint,
    pct012k064 bigint,
    pct012k065 bigint,
    pct012k066 bigint,
    pct012k067 bigint,
    pct012k068 bigint,
    pct012k069 bigint,
    pct012k070 bigint,
    pct012k071 bigint,
    pct012k072 bigint,
    pct012k073 bigint,
    pct012k074 bigint,
    pct012k075 bigint,
    pct012k076 bigint,
    pct012k077 bigint,
    pct012k078 bigint,
    pct012k079 bigint,
    pct012k080 bigint,
    pct012k081 bigint,
    pct012k082 bigint,
    pct012k083 bigint,
    pct012k084 bigint,
    pct012k085 bigint,
    pct012k086 bigint,
    pct012k087 bigint,
    pct012k088 bigint,
    pct012k089 bigint,
    pct012k090 bigint,
    pct012k091 bigint,
    pct012k092 bigint,
    pct012k093 bigint,
    pct012k094 bigint,
    pct012k095 bigint,
    pct012k096 bigint,
    pct012k097 bigint,
    pct012k098 bigint,
    pct012k099 bigint,
    pct012k100 bigint,
    pct012k101 bigint,
    pct012k102 bigint,
    pct012k103 bigint,
    pct012k104 bigint,
    pct012k105 bigint,
    pct012k106 bigint,
    pct012k107 bigint,
    pct012k108 bigint,
    pct012k109 bigint,
    pct012k110 bigint,
    pct012k111 bigint,
    pct012k112 bigint,
    pct012k113 bigint,
    pct012k114 bigint,
    pct012k115 bigint,
    pct012k116 bigint,
    pct012k117 bigint,
    pct012k118 bigint,
    pct012k119 bigint,
    pct012k120 bigint,
    pct012k121 bigint,
    pct012k122 bigint,
    pct012k123 bigint,
    pct012k124 bigint,
    pct012k125 bigint,
    pct012k126 bigint,
    pct012k127 bigint,
    pct012k128 bigint,
    pct012k129 bigint,
    pct012k130 bigint,
    pct012k131 bigint,
    pct012k132 bigint,
    pct012k133 bigint,
    pct012k134 bigint,
    pct012k135 bigint,
    pct012k136 bigint,
    pct012k137 bigint,
    pct012k138 bigint,
    pct012k139 bigint,
    pct012k140 bigint,
    pct012k141 bigint,
    pct012k142 bigint,
    pct012k143 bigint,
    pct012k144 bigint,
    pct012k145 bigint,
    pct012k146 bigint,
    pct012k147 bigint,
    pct012k148 bigint,
    pct012k149 bigint,
    pct012k150 bigint,
    pct012k151 bigint,
    pct012k152 bigint,
    pct012k153 bigint,
    pct012k154 bigint,
    pct012k155 bigint,
    pct012k156 bigint,
    pct012k157 bigint,
    pct012k158 bigint,
    pct012k159 bigint,
    pct012k160 bigint,
    pct012k161 bigint,
    pct012k162 bigint,
    pct012k163 bigint,
    pct012k164 bigint,
    pct012k165 bigint,
    pct012k166 bigint,
    pct012k167 bigint,
    pct012k168 bigint,
    pct012k169 bigint,
    pct012k170 bigint,
    pct012k171 bigint,
    pct012k172 bigint,
    pct012k173 bigint,
    pct012k174 bigint,
    pct012k175 bigint,
    pct012k176 bigint,
    pct012k177 bigint,
    pct012k178 bigint,
    pct012k179 bigint,
    pct012k180 bigint,
    pct012k181 bigint,
    pct012k182 bigint,
    pct012k183 bigint,
    pct012k184 bigint,
    pct012k185 bigint,
    pct012k186 bigint,
    pct012k187 bigint,
    pct012k188 bigint,
    pct012k189 bigint,
    pct012k190 bigint,
    pct012k191 bigint,
    pct012k192 bigint,
    pct012k193 bigint,
    pct012k194 bigint,
    pct012k195 bigint,
    pct012k196 bigint,
    pct012k197 bigint,
    pct012k198 bigint,
    pct012k199 bigint,
    pct012k200 bigint,
    pct012k201 bigint,
    pct012k202 bigint,
    pct012k203 bigint,
    pct012k204 bigint,
    pct012k205 bigint,
    pct012k206 bigint,
    pct012k207 bigint,
    pct012k208 bigint,
    pct012k209 bigint
);


ALTER TABLE sf10026 OWNER TO census;

--
-- Name: sf10027; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10027 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct012l001 bigint,
    pct012l002 bigint,
    pct012l003 bigint,
    pct012l004 bigint,
    pct012l005 bigint,
    pct012l006 bigint,
    pct012l007 bigint,
    pct012l008 bigint,
    pct012l009 bigint,
    pct012l010 bigint,
    pct012l011 bigint,
    pct012l012 bigint,
    pct012l013 bigint,
    pct012l014 bigint,
    pct012l015 bigint,
    pct012l016 bigint,
    pct012l017 bigint,
    pct012l018 bigint,
    pct012l019 bigint,
    pct012l020 bigint,
    pct012l021 bigint,
    pct012l022 bigint,
    pct012l023 bigint,
    pct012l024 bigint,
    pct012l025 bigint,
    pct012l026 bigint,
    pct012l027 bigint,
    pct012l028 bigint,
    pct012l029 bigint,
    pct012l030 bigint,
    pct012l031 bigint,
    pct012l032 bigint,
    pct012l033 bigint,
    pct012l034 bigint,
    pct012l035 bigint,
    pct012l036 bigint,
    pct012l037 bigint,
    pct012l038 bigint,
    pct012l039 bigint,
    pct012l040 bigint,
    pct012l041 bigint,
    pct012l042 bigint,
    pct012l043 bigint,
    pct012l044 bigint,
    pct012l045 bigint,
    pct012l046 bigint,
    pct012l047 bigint,
    pct012l048 bigint,
    pct012l049 bigint,
    pct012l050 bigint,
    pct012l051 bigint,
    pct012l052 bigint,
    pct012l053 bigint,
    pct012l054 bigint,
    pct012l055 bigint,
    pct012l056 bigint,
    pct012l057 bigint,
    pct012l058 bigint,
    pct012l059 bigint,
    pct012l060 bigint,
    pct012l061 bigint,
    pct012l062 bigint,
    pct012l063 bigint,
    pct012l064 bigint,
    pct012l065 bigint,
    pct012l066 bigint,
    pct012l067 bigint,
    pct012l068 bigint,
    pct012l069 bigint,
    pct012l070 bigint,
    pct012l071 bigint,
    pct012l072 bigint,
    pct012l073 bigint,
    pct012l074 bigint,
    pct012l075 bigint,
    pct012l076 bigint,
    pct012l077 bigint,
    pct012l078 bigint,
    pct012l079 bigint,
    pct012l080 bigint,
    pct012l081 bigint,
    pct012l082 bigint,
    pct012l083 bigint,
    pct012l084 bigint,
    pct012l085 bigint,
    pct012l086 bigint,
    pct012l087 bigint,
    pct012l088 bigint,
    pct012l089 bigint,
    pct012l090 bigint,
    pct012l091 bigint,
    pct012l092 bigint,
    pct012l093 bigint,
    pct012l094 bigint,
    pct012l095 bigint,
    pct012l096 bigint,
    pct012l097 bigint,
    pct012l098 bigint,
    pct012l099 bigint,
    pct012l100 bigint,
    pct012l101 bigint,
    pct012l102 bigint,
    pct012l103 bigint,
    pct012l104 bigint,
    pct012l105 bigint,
    pct012l106 bigint,
    pct012l107 bigint,
    pct012l108 bigint,
    pct012l109 bigint,
    pct012l110 bigint,
    pct012l111 bigint,
    pct012l112 bigint,
    pct012l113 bigint,
    pct012l114 bigint,
    pct012l115 bigint,
    pct012l116 bigint,
    pct012l117 bigint,
    pct012l118 bigint,
    pct012l119 bigint,
    pct012l120 bigint,
    pct012l121 bigint,
    pct012l122 bigint,
    pct012l123 bigint,
    pct012l124 bigint,
    pct012l125 bigint,
    pct012l126 bigint,
    pct012l127 bigint,
    pct012l128 bigint,
    pct012l129 bigint,
    pct012l130 bigint,
    pct012l131 bigint,
    pct012l132 bigint,
    pct012l133 bigint,
    pct012l134 bigint,
    pct012l135 bigint,
    pct012l136 bigint,
    pct012l137 bigint,
    pct012l138 bigint,
    pct012l139 bigint,
    pct012l140 bigint,
    pct012l141 bigint,
    pct012l142 bigint,
    pct012l143 bigint,
    pct012l144 bigint,
    pct012l145 bigint,
    pct012l146 bigint,
    pct012l147 bigint,
    pct012l148 bigint,
    pct012l149 bigint,
    pct012l150 bigint,
    pct012l151 bigint,
    pct012l152 bigint,
    pct012l153 bigint,
    pct012l154 bigint,
    pct012l155 bigint,
    pct012l156 bigint,
    pct012l157 bigint,
    pct012l158 bigint,
    pct012l159 bigint,
    pct012l160 bigint,
    pct012l161 bigint,
    pct012l162 bigint,
    pct012l163 bigint,
    pct012l164 bigint,
    pct012l165 bigint,
    pct012l166 bigint,
    pct012l167 bigint,
    pct012l168 bigint,
    pct012l169 bigint,
    pct012l170 bigint,
    pct012l171 bigint,
    pct012l172 bigint,
    pct012l173 bigint,
    pct012l174 bigint,
    pct012l175 bigint,
    pct012l176 bigint,
    pct012l177 bigint,
    pct012l178 bigint,
    pct012l179 bigint,
    pct012l180 bigint,
    pct012l181 bigint,
    pct012l182 bigint,
    pct012l183 bigint,
    pct012l184 bigint,
    pct012l185 bigint,
    pct012l186 bigint,
    pct012l187 bigint,
    pct012l188 bigint,
    pct012l189 bigint,
    pct012l190 bigint,
    pct012l191 bigint,
    pct012l192 bigint,
    pct012l193 bigint,
    pct012l194 bigint,
    pct012l195 bigint,
    pct012l196 bigint,
    pct012l197 bigint,
    pct012l198 bigint,
    pct012l199 bigint,
    pct012l200 bigint,
    pct012l201 bigint,
    pct012l202 bigint,
    pct012l203 bigint,
    pct012l204 bigint,
    pct012l205 bigint,
    pct012l206 bigint,
    pct012l207 bigint,
    pct012l208 bigint,
    pct012l209 bigint
);


ALTER TABLE sf10027 OWNER TO census;

--
-- Name: sf10028; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10028 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct012m001 bigint,
    pct012m002 bigint,
    pct012m003 bigint,
    pct012m004 bigint,
    pct012m005 bigint,
    pct012m006 bigint,
    pct012m007 bigint,
    pct012m008 bigint,
    pct012m009 bigint,
    pct012m010 bigint,
    pct012m011 bigint,
    pct012m012 bigint,
    pct012m013 bigint,
    pct012m014 bigint,
    pct012m015 bigint,
    pct012m016 bigint,
    pct012m017 bigint,
    pct012m018 bigint,
    pct012m019 bigint,
    pct012m020 bigint,
    pct012m021 bigint,
    pct012m022 bigint,
    pct012m023 bigint,
    pct012m024 bigint,
    pct012m025 bigint,
    pct012m026 bigint,
    pct012m027 bigint,
    pct012m028 bigint,
    pct012m029 bigint,
    pct012m030 bigint,
    pct012m031 bigint,
    pct012m032 bigint,
    pct012m033 bigint,
    pct012m034 bigint,
    pct012m035 bigint,
    pct012m036 bigint,
    pct012m037 bigint,
    pct012m038 bigint,
    pct012m039 bigint,
    pct012m040 bigint,
    pct012m041 bigint,
    pct012m042 bigint,
    pct012m043 bigint,
    pct012m044 bigint,
    pct012m045 bigint,
    pct012m046 bigint,
    pct012m047 bigint,
    pct012m048 bigint,
    pct012m049 bigint,
    pct012m050 bigint,
    pct012m051 bigint,
    pct012m052 bigint,
    pct012m053 bigint,
    pct012m054 bigint,
    pct012m055 bigint,
    pct012m056 bigint,
    pct012m057 bigint,
    pct012m058 bigint,
    pct012m059 bigint,
    pct012m060 bigint,
    pct012m061 bigint,
    pct012m062 bigint,
    pct012m063 bigint,
    pct012m064 bigint,
    pct012m065 bigint,
    pct012m066 bigint,
    pct012m067 bigint,
    pct012m068 bigint,
    pct012m069 bigint,
    pct012m070 bigint,
    pct012m071 bigint,
    pct012m072 bigint,
    pct012m073 bigint,
    pct012m074 bigint,
    pct012m075 bigint,
    pct012m076 bigint,
    pct012m077 bigint,
    pct012m078 bigint,
    pct012m079 bigint,
    pct012m080 bigint,
    pct012m081 bigint,
    pct012m082 bigint,
    pct012m083 bigint,
    pct012m084 bigint,
    pct012m085 bigint,
    pct012m086 bigint,
    pct012m087 bigint,
    pct012m088 bigint,
    pct012m089 bigint,
    pct012m090 bigint,
    pct012m091 bigint,
    pct012m092 bigint,
    pct012m093 bigint,
    pct012m094 bigint,
    pct012m095 bigint,
    pct012m096 bigint,
    pct012m097 bigint,
    pct012m098 bigint,
    pct012m099 bigint,
    pct012m100 bigint,
    pct012m101 bigint,
    pct012m102 bigint,
    pct012m103 bigint,
    pct012m104 bigint,
    pct012m105 bigint,
    pct012m106 bigint,
    pct012m107 bigint,
    pct012m108 bigint,
    pct012m109 bigint,
    pct012m110 bigint,
    pct012m111 bigint,
    pct012m112 bigint,
    pct012m113 bigint,
    pct012m114 bigint,
    pct012m115 bigint,
    pct012m116 bigint,
    pct012m117 bigint,
    pct012m118 bigint,
    pct012m119 bigint,
    pct012m120 bigint,
    pct012m121 bigint,
    pct012m122 bigint,
    pct012m123 bigint,
    pct012m124 bigint,
    pct012m125 bigint,
    pct012m126 bigint,
    pct012m127 bigint,
    pct012m128 bigint,
    pct012m129 bigint,
    pct012m130 bigint,
    pct012m131 bigint,
    pct012m132 bigint,
    pct012m133 bigint,
    pct012m134 bigint,
    pct012m135 bigint,
    pct012m136 bigint,
    pct012m137 bigint,
    pct012m138 bigint,
    pct012m139 bigint,
    pct012m140 bigint,
    pct012m141 bigint,
    pct012m142 bigint,
    pct012m143 bigint,
    pct012m144 bigint,
    pct012m145 bigint,
    pct012m146 bigint,
    pct012m147 bigint,
    pct012m148 bigint,
    pct012m149 bigint,
    pct012m150 bigint,
    pct012m151 bigint,
    pct012m152 bigint,
    pct012m153 bigint,
    pct012m154 bigint,
    pct012m155 bigint,
    pct012m156 bigint,
    pct012m157 bigint,
    pct012m158 bigint,
    pct012m159 bigint,
    pct012m160 bigint,
    pct012m161 bigint,
    pct012m162 bigint,
    pct012m163 bigint,
    pct012m164 bigint,
    pct012m165 bigint,
    pct012m166 bigint,
    pct012m167 bigint,
    pct012m168 bigint,
    pct012m169 bigint,
    pct012m170 bigint,
    pct012m171 bigint,
    pct012m172 bigint,
    pct012m173 bigint,
    pct012m174 bigint,
    pct012m175 bigint,
    pct012m176 bigint,
    pct012m177 bigint,
    pct012m178 bigint,
    pct012m179 bigint,
    pct012m180 bigint,
    pct012m181 bigint,
    pct012m182 bigint,
    pct012m183 bigint,
    pct012m184 bigint,
    pct012m185 bigint,
    pct012m186 bigint,
    pct012m187 bigint,
    pct012m188 bigint,
    pct012m189 bigint,
    pct012m190 bigint,
    pct012m191 bigint,
    pct012m192 bigint,
    pct012m193 bigint,
    pct012m194 bigint,
    pct012m195 bigint,
    pct012m196 bigint,
    pct012m197 bigint,
    pct012m198 bigint,
    pct012m199 bigint,
    pct012m200 bigint,
    pct012m201 bigint,
    pct012m202 bigint,
    pct012m203 bigint,
    pct012m204 bigint,
    pct012m205 bigint,
    pct012m206 bigint,
    pct012m207 bigint,
    pct012m208 bigint,
    pct012m209 bigint
);


ALTER TABLE sf10028 OWNER TO census;

--
-- Name: sf10029; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10029 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct012n001 bigint,
    pct012n002 bigint,
    pct012n003 bigint,
    pct012n004 bigint,
    pct012n005 bigint,
    pct012n006 bigint,
    pct012n007 bigint,
    pct012n008 bigint,
    pct012n009 bigint,
    pct012n010 bigint,
    pct012n011 bigint,
    pct012n012 bigint,
    pct012n013 bigint,
    pct012n014 bigint,
    pct012n015 bigint,
    pct012n016 bigint,
    pct012n017 bigint,
    pct012n018 bigint,
    pct012n019 bigint,
    pct012n020 bigint,
    pct012n021 bigint,
    pct012n022 bigint,
    pct012n023 bigint,
    pct012n024 bigint,
    pct012n025 bigint,
    pct012n026 bigint,
    pct012n027 bigint,
    pct012n028 bigint,
    pct012n029 bigint,
    pct012n030 bigint,
    pct012n031 bigint,
    pct012n032 bigint,
    pct012n033 bigint,
    pct012n034 bigint,
    pct012n035 bigint,
    pct012n036 bigint,
    pct012n037 bigint,
    pct012n038 bigint,
    pct012n039 bigint,
    pct012n040 bigint,
    pct012n041 bigint,
    pct012n042 bigint,
    pct012n043 bigint,
    pct012n044 bigint,
    pct012n045 bigint,
    pct012n046 bigint,
    pct012n047 bigint,
    pct012n048 bigint,
    pct012n049 bigint,
    pct012n050 bigint,
    pct012n051 bigint,
    pct012n052 bigint,
    pct012n053 bigint,
    pct012n054 bigint,
    pct012n055 bigint,
    pct012n056 bigint,
    pct012n057 bigint,
    pct012n058 bigint,
    pct012n059 bigint,
    pct012n060 bigint,
    pct012n061 bigint,
    pct012n062 bigint,
    pct012n063 bigint,
    pct012n064 bigint,
    pct012n065 bigint,
    pct012n066 bigint,
    pct012n067 bigint,
    pct012n068 bigint,
    pct012n069 bigint,
    pct012n070 bigint,
    pct012n071 bigint,
    pct012n072 bigint,
    pct012n073 bigint,
    pct012n074 bigint,
    pct012n075 bigint,
    pct012n076 bigint,
    pct012n077 bigint,
    pct012n078 bigint,
    pct012n079 bigint,
    pct012n080 bigint,
    pct012n081 bigint,
    pct012n082 bigint,
    pct012n083 bigint,
    pct012n084 bigint,
    pct012n085 bigint,
    pct012n086 bigint,
    pct012n087 bigint,
    pct012n088 bigint,
    pct012n089 bigint,
    pct012n090 bigint,
    pct012n091 bigint,
    pct012n092 bigint,
    pct012n093 bigint,
    pct012n094 bigint,
    pct012n095 bigint,
    pct012n096 bigint,
    pct012n097 bigint,
    pct012n098 bigint,
    pct012n099 bigint,
    pct012n100 bigint,
    pct012n101 bigint,
    pct012n102 bigint,
    pct012n103 bigint,
    pct012n104 bigint,
    pct012n105 bigint,
    pct012n106 bigint,
    pct012n107 bigint,
    pct012n108 bigint,
    pct012n109 bigint,
    pct012n110 bigint,
    pct012n111 bigint,
    pct012n112 bigint,
    pct012n113 bigint,
    pct012n114 bigint,
    pct012n115 bigint,
    pct012n116 bigint,
    pct012n117 bigint,
    pct012n118 bigint,
    pct012n119 bigint,
    pct012n120 bigint,
    pct012n121 bigint,
    pct012n122 bigint,
    pct012n123 bigint,
    pct012n124 bigint,
    pct012n125 bigint,
    pct012n126 bigint,
    pct012n127 bigint,
    pct012n128 bigint,
    pct012n129 bigint,
    pct012n130 bigint,
    pct012n131 bigint,
    pct012n132 bigint,
    pct012n133 bigint,
    pct012n134 bigint,
    pct012n135 bigint,
    pct012n136 bigint,
    pct012n137 bigint,
    pct012n138 bigint,
    pct012n139 bigint,
    pct012n140 bigint,
    pct012n141 bigint,
    pct012n142 bigint,
    pct012n143 bigint,
    pct012n144 bigint,
    pct012n145 bigint,
    pct012n146 bigint,
    pct012n147 bigint,
    pct012n148 bigint,
    pct012n149 bigint,
    pct012n150 bigint,
    pct012n151 bigint,
    pct012n152 bigint,
    pct012n153 bigint,
    pct012n154 bigint,
    pct012n155 bigint,
    pct012n156 bigint,
    pct012n157 bigint,
    pct012n158 bigint,
    pct012n159 bigint,
    pct012n160 bigint,
    pct012n161 bigint,
    pct012n162 bigint,
    pct012n163 bigint,
    pct012n164 bigint,
    pct012n165 bigint,
    pct012n166 bigint,
    pct012n167 bigint,
    pct012n168 bigint,
    pct012n169 bigint,
    pct012n170 bigint,
    pct012n171 bigint,
    pct012n172 bigint,
    pct012n173 bigint,
    pct012n174 bigint,
    pct012n175 bigint,
    pct012n176 bigint,
    pct012n177 bigint,
    pct012n178 bigint,
    pct012n179 bigint,
    pct012n180 bigint,
    pct012n181 bigint,
    pct012n182 bigint,
    pct012n183 bigint,
    pct012n184 bigint,
    pct012n185 bigint,
    pct012n186 bigint,
    pct012n187 bigint,
    pct012n188 bigint,
    pct012n189 bigint,
    pct012n190 bigint,
    pct012n191 bigint,
    pct012n192 bigint,
    pct012n193 bigint,
    pct012n194 bigint,
    pct012n195 bigint,
    pct012n196 bigint,
    pct012n197 bigint,
    pct012n198 bigint,
    pct012n199 bigint,
    pct012n200 bigint,
    pct012n201 bigint,
    pct012n202 bigint,
    pct012n203 bigint,
    pct012n204 bigint,
    pct012n205 bigint,
    pct012n206 bigint,
    pct012n207 bigint,
    pct012n208 bigint,
    pct012n209 bigint
);


ALTER TABLE sf10029 OWNER TO census;

--
-- Name: sf10030; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10030 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct012o001 bigint,
    pct012o002 bigint,
    pct012o003 bigint,
    pct012o004 bigint,
    pct012o005 bigint,
    pct012o006 bigint,
    pct012o007 bigint,
    pct012o008 bigint,
    pct012o009 bigint,
    pct012o010 bigint,
    pct012o011 bigint,
    pct012o012 bigint,
    pct012o013 bigint,
    pct012o014 bigint,
    pct012o015 bigint,
    pct012o016 bigint,
    pct012o017 bigint,
    pct012o018 bigint,
    pct012o019 bigint,
    pct012o020 bigint,
    pct012o021 bigint,
    pct012o022 bigint,
    pct012o023 bigint,
    pct012o024 bigint,
    pct012o025 bigint,
    pct012o026 bigint,
    pct012o027 bigint,
    pct012o028 bigint,
    pct012o029 bigint,
    pct012o030 bigint,
    pct012o031 bigint,
    pct012o032 bigint,
    pct012o033 bigint,
    pct012o034 bigint,
    pct012o035 bigint,
    pct012o036 bigint,
    pct012o037 bigint,
    pct012o038 bigint,
    pct012o039 bigint,
    pct012o040 bigint,
    pct012o041 bigint,
    pct012o042 bigint,
    pct012o043 bigint,
    pct012o044 bigint,
    pct012o045 bigint,
    pct012o046 bigint,
    pct012o047 bigint,
    pct012o048 bigint,
    pct012o049 bigint,
    pct012o050 bigint,
    pct012o051 bigint,
    pct012o052 bigint,
    pct012o053 bigint,
    pct012o054 bigint,
    pct012o055 bigint,
    pct012o056 bigint,
    pct012o057 bigint,
    pct012o058 bigint,
    pct012o059 bigint,
    pct012o060 bigint,
    pct012o061 bigint,
    pct012o062 bigint,
    pct012o063 bigint,
    pct012o064 bigint,
    pct012o065 bigint,
    pct012o066 bigint,
    pct012o067 bigint,
    pct012o068 bigint,
    pct012o069 bigint,
    pct012o070 bigint,
    pct012o071 bigint,
    pct012o072 bigint,
    pct012o073 bigint,
    pct012o074 bigint,
    pct012o075 bigint,
    pct012o076 bigint,
    pct012o077 bigint,
    pct012o078 bigint,
    pct012o079 bigint,
    pct012o080 bigint,
    pct012o081 bigint,
    pct012o082 bigint,
    pct012o083 bigint,
    pct012o084 bigint,
    pct012o085 bigint,
    pct012o086 bigint,
    pct012o087 bigint,
    pct012o088 bigint,
    pct012o089 bigint,
    pct012o090 bigint,
    pct012o091 bigint,
    pct012o092 bigint,
    pct012o093 bigint,
    pct012o094 bigint,
    pct012o095 bigint,
    pct012o096 bigint,
    pct012o097 bigint,
    pct012o098 bigint,
    pct012o099 bigint,
    pct012o100 bigint,
    pct012o101 bigint,
    pct012o102 bigint,
    pct012o103 bigint,
    pct012o104 bigint,
    pct012o105 bigint,
    pct012o106 bigint,
    pct012o107 bigint,
    pct012o108 bigint,
    pct012o109 bigint,
    pct012o110 bigint,
    pct012o111 bigint,
    pct012o112 bigint,
    pct012o113 bigint,
    pct012o114 bigint,
    pct012o115 bigint,
    pct012o116 bigint,
    pct012o117 bigint,
    pct012o118 bigint,
    pct012o119 bigint,
    pct012o120 bigint,
    pct012o121 bigint,
    pct012o122 bigint,
    pct012o123 bigint,
    pct012o124 bigint,
    pct012o125 bigint,
    pct012o126 bigint,
    pct012o127 bigint,
    pct012o128 bigint,
    pct012o129 bigint,
    pct012o130 bigint,
    pct012o131 bigint,
    pct012o132 bigint,
    pct012o133 bigint,
    pct012o134 bigint,
    pct012o135 bigint,
    pct012o136 bigint,
    pct012o137 bigint,
    pct012o138 bigint,
    pct012o139 bigint,
    pct012o140 bigint,
    pct012o141 bigint,
    pct012o142 bigint,
    pct012o143 bigint,
    pct012o144 bigint,
    pct012o145 bigint,
    pct012o146 bigint,
    pct012o147 bigint,
    pct012o148 bigint,
    pct012o149 bigint,
    pct012o150 bigint,
    pct012o151 bigint,
    pct012o152 bigint,
    pct012o153 bigint,
    pct012o154 bigint,
    pct012o155 bigint,
    pct012o156 bigint,
    pct012o157 bigint,
    pct012o158 bigint,
    pct012o159 bigint,
    pct012o160 bigint,
    pct012o161 bigint,
    pct012o162 bigint,
    pct012o163 bigint,
    pct012o164 bigint,
    pct012o165 bigint,
    pct012o166 bigint,
    pct012o167 bigint,
    pct012o168 bigint,
    pct012o169 bigint,
    pct012o170 bigint,
    pct012o171 bigint,
    pct012o172 bigint,
    pct012o173 bigint,
    pct012o174 bigint,
    pct012o175 bigint,
    pct012o176 bigint,
    pct012o177 bigint,
    pct012o178 bigint,
    pct012o179 bigint,
    pct012o180 bigint,
    pct012o181 bigint,
    pct012o182 bigint,
    pct012o183 bigint,
    pct012o184 bigint,
    pct012o185 bigint,
    pct012o186 bigint,
    pct012o187 bigint,
    pct012o188 bigint,
    pct012o189 bigint,
    pct012o190 bigint,
    pct012o191 bigint,
    pct012o192 bigint,
    pct012o193 bigint,
    pct012o194 bigint,
    pct012o195 bigint,
    pct012o196 bigint,
    pct012o197 bigint,
    pct012o198 bigint,
    pct012o199 bigint,
    pct012o200 bigint,
    pct012o201 bigint,
    pct012o202 bigint,
    pct012o203 bigint,
    pct012o204 bigint,
    pct012o205 bigint,
    pct012o206 bigint,
    pct012o207 bigint,
    pct012o208 bigint,
    pct012o209 bigint
);


ALTER TABLE sf10030 OWNER TO census;

--
-- Name: sf10031; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10031 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct013a001 bigint,
    pct013a002 bigint,
    pct013a003 bigint,
    pct013a004 bigint,
    pct013a005 bigint,
    pct013a006 bigint,
    pct013a007 bigint,
    pct013a008 bigint,
    pct013a009 bigint,
    pct013a010 bigint,
    pct013a011 bigint,
    pct013a012 bigint,
    pct013a013 bigint,
    pct013a014 bigint,
    pct013a015 bigint,
    pct013a016 bigint,
    pct013a017 bigint,
    pct013a018 bigint,
    pct013a019 bigint,
    pct013a020 bigint,
    pct013a021 bigint,
    pct013a022 bigint,
    pct013a023 bigint,
    pct013a024 bigint,
    pct013a025 bigint,
    pct013a026 bigint,
    pct013a027 bigint,
    pct013a028 bigint,
    pct013a029 bigint,
    pct013a030 bigint,
    pct013a031 bigint,
    pct013a032 bigint,
    pct013a033 bigint,
    pct013a034 bigint,
    pct013a035 bigint,
    pct013a036 bigint,
    pct013a037 bigint,
    pct013a038 bigint,
    pct013a039 bigint,
    pct013a040 bigint,
    pct013a041 bigint,
    pct013a042 bigint,
    pct013a043 bigint,
    pct013a044 bigint,
    pct013a045 bigint,
    pct013a046 bigint,
    pct013a047 bigint,
    pct013a048 bigint,
    pct013a049 bigint,
    pct013b001 bigint,
    pct013b002 bigint,
    pct013b003 bigint,
    pct013b004 bigint,
    pct013b005 bigint,
    pct013b006 bigint,
    pct013b007 bigint,
    pct013b008 bigint,
    pct013b009 bigint,
    pct013b010 bigint,
    pct013b011 bigint,
    pct013b012 bigint,
    pct013b013 bigint,
    pct013b014 bigint,
    pct013b015 bigint,
    pct013b016 bigint,
    pct013b017 bigint,
    pct013b018 bigint,
    pct013b019 bigint,
    pct013b020 bigint,
    pct013b021 bigint,
    pct013b022 bigint,
    pct013b023 bigint,
    pct013b024 bigint,
    pct013b025 bigint,
    pct013b026 bigint,
    pct013b027 bigint,
    pct013b028 bigint,
    pct013b029 bigint,
    pct013b030 bigint,
    pct013b031 bigint,
    pct013b032 bigint,
    pct013b033 bigint,
    pct013b034 bigint,
    pct013b035 bigint,
    pct013b036 bigint,
    pct013b037 bigint,
    pct013b038 bigint,
    pct013b039 bigint,
    pct013b040 bigint,
    pct013b041 bigint,
    pct013b042 bigint,
    pct013b043 bigint,
    pct013b044 bigint,
    pct013b045 bigint,
    pct013b046 bigint,
    pct013b047 bigint,
    pct013b048 bigint,
    pct013b049 bigint,
    pct013c001 bigint,
    pct013c002 bigint,
    pct013c003 bigint,
    pct013c004 bigint,
    pct013c005 bigint,
    pct013c006 bigint,
    pct013c007 bigint,
    pct013c008 bigint,
    pct013c009 bigint,
    pct013c010 bigint,
    pct013c011 bigint,
    pct013c012 bigint,
    pct013c013 bigint,
    pct013c014 bigint,
    pct013c015 bigint,
    pct013c016 bigint,
    pct013c017 bigint,
    pct013c018 bigint,
    pct013c019 bigint,
    pct013c020 bigint,
    pct013c021 bigint,
    pct013c022 bigint,
    pct013c023 bigint,
    pct013c024 bigint,
    pct013c025 bigint,
    pct013c026 bigint,
    pct013c027 bigint,
    pct013c028 bigint,
    pct013c029 bigint,
    pct013c030 bigint,
    pct013c031 bigint,
    pct013c032 bigint,
    pct013c033 bigint,
    pct013c034 bigint,
    pct013c035 bigint,
    pct013c036 bigint,
    pct013c037 bigint,
    pct013c038 bigint,
    pct013c039 bigint,
    pct013c040 bigint,
    pct013c041 bigint,
    pct013c042 bigint,
    pct013c043 bigint,
    pct013c044 bigint,
    pct013c045 bigint,
    pct013c046 bigint,
    pct013c047 bigint,
    pct013c048 bigint,
    pct013c049 bigint,
    pct013d001 bigint,
    pct013d002 bigint,
    pct013d003 bigint,
    pct013d004 bigint,
    pct013d005 bigint,
    pct013d006 bigint,
    pct013d007 bigint,
    pct013d008 bigint,
    pct013d009 bigint,
    pct013d010 bigint,
    pct013d011 bigint,
    pct013d012 bigint,
    pct013d013 bigint,
    pct013d014 bigint,
    pct013d015 bigint,
    pct013d016 bigint,
    pct013d017 bigint,
    pct013d018 bigint,
    pct013d019 bigint,
    pct013d020 bigint,
    pct013d021 bigint,
    pct013d022 bigint,
    pct013d023 bigint,
    pct013d024 bigint,
    pct013d025 bigint,
    pct013d026 bigint,
    pct013d027 bigint,
    pct013d028 bigint,
    pct013d029 bigint,
    pct013d030 bigint,
    pct013d031 bigint,
    pct013d032 bigint,
    pct013d033 bigint,
    pct013d034 bigint,
    pct013d035 bigint,
    pct013d036 bigint,
    pct013d037 bigint,
    pct013d038 bigint,
    pct013d039 bigint,
    pct013d040 bigint,
    pct013d041 bigint,
    pct013d042 bigint,
    pct013d043 bigint,
    pct013d044 bigint,
    pct013d045 bigint,
    pct013d046 bigint,
    pct013d047 bigint,
    pct013d048 bigint,
    pct013d049 bigint,
    pct013e001 bigint,
    pct013e002 bigint,
    pct013e003 bigint,
    pct013e004 bigint,
    pct013e005 bigint,
    pct013e006 bigint,
    pct013e007 bigint,
    pct013e008 bigint,
    pct013e009 bigint,
    pct013e010 bigint,
    pct013e011 bigint,
    pct013e012 bigint,
    pct013e013 bigint,
    pct013e014 bigint,
    pct013e015 bigint,
    pct013e016 bigint,
    pct013e017 bigint,
    pct013e018 bigint,
    pct013e019 bigint,
    pct013e020 bigint,
    pct013e021 bigint,
    pct013e022 bigint,
    pct013e023 bigint,
    pct013e024 bigint,
    pct013e025 bigint,
    pct013e026 bigint,
    pct013e027 bigint,
    pct013e028 bigint,
    pct013e029 bigint,
    pct013e030 bigint,
    pct013e031 bigint,
    pct013e032 bigint,
    pct013e033 bigint,
    pct013e034 bigint,
    pct013e035 bigint,
    pct013e036 bigint,
    pct013e037 bigint,
    pct013e038 bigint,
    pct013e039 bigint,
    pct013e040 bigint,
    pct013e041 bigint,
    pct013e042 bigint,
    pct013e043 bigint,
    pct013e044 bigint,
    pct013e045 bigint,
    pct013e046 bigint,
    pct013e047 bigint,
    pct013e048 bigint,
    pct013e049 bigint
);


ALTER TABLE sf10031 OWNER TO census;

--
-- Name: sf10032; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10032 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct013f001 bigint,
    pct013f002 bigint,
    pct013f003 bigint,
    pct013f004 bigint,
    pct013f005 bigint,
    pct013f006 bigint,
    pct013f007 bigint,
    pct013f008 bigint,
    pct013f009 bigint,
    pct013f010 bigint,
    pct013f011 bigint,
    pct013f012 bigint,
    pct013f013 bigint,
    pct013f014 bigint,
    pct013f015 bigint,
    pct013f016 bigint,
    pct013f017 bigint,
    pct013f018 bigint,
    pct013f019 bigint,
    pct013f020 bigint,
    pct013f021 bigint,
    pct013f022 bigint,
    pct013f023 bigint,
    pct013f024 bigint,
    pct013f025 bigint,
    pct013f026 bigint,
    pct013f027 bigint,
    pct013f028 bigint,
    pct013f029 bigint,
    pct013f030 bigint,
    pct013f031 bigint,
    pct013f032 bigint,
    pct013f033 bigint,
    pct013f034 bigint,
    pct013f035 bigint,
    pct013f036 bigint,
    pct013f037 bigint,
    pct013f038 bigint,
    pct013f039 bigint,
    pct013f040 bigint,
    pct013f041 bigint,
    pct013f042 bigint,
    pct013f043 bigint,
    pct013f044 bigint,
    pct013f045 bigint,
    pct013f046 bigint,
    pct013f047 bigint,
    pct013f048 bigint,
    pct013f049 bigint,
    pct013g001 bigint,
    pct013g002 bigint,
    pct013g003 bigint,
    pct013g004 bigint,
    pct013g005 bigint,
    pct013g006 bigint,
    pct013g007 bigint,
    pct013g008 bigint,
    pct013g009 bigint,
    pct013g010 bigint,
    pct013g011 bigint,
    pct013g012 bigint,
    pct013g013 bigint,
    pct013g014 bigint,
    pct013g015 bigint,
    pct013g016 bigint,
    pct013g017 bigint,
    pct013g018 bigint,
    pct013g019 bigint,
    pct013g020 bigint,
    pct013g021 bigint,
    pct013g022 bigint,
    pct013g023 bigint,
    pct013g024 bigint,
    pct013g025 bigint,
    pct013g026 bigint,
    pct013g027 bigint,
    pct013g028 bigint,
    pct013g029 bigint,
    pct013g030 bigint,
    pct013g031 bigint,
    pct013g032 bigint,
    pct013g033 bigint,
    pct013g034 bigint,
    pct013g035 bigint,
    pct013g036 bigint,
    pct013g037 bigint,
    pct013g038 bigint,
    pct013g039 bigint,
    pct013g040 bigint,
    pct013g041 bigint,
    pct013g042 bigint,
    pct013g043 bigint,
    pct013g044 bigint,
    pct013g045 bigint,
    pct013g046 bigint,
    pct013g047 bigint,
    pct013g048 bigint,
    pct013g049 bigint,
    pct013h001 bigint,
    pct013h002 bigint,
    pct013h003 bigint,
    pct013h004 bigint,
    pct013h005 bigint,
    pct013h006 bigint,
    pct013h007 bigint,
    pct013h008 bigint,
    pct013h009 bigint,
    pct013h010 bigint,
    pct013h011 bigint,
    pct013h012 bigint,
    pct013h013 bigint,
    pct013h014 bigint,
    pct013h015 bigint,
    pct013h016 bigint,
    pct013h017 bigint,
    pct013h018 bigint,
    pct013h019 bigint,
    pct013h020 bigint,
    pct013h021 bigint,
    pct013h022 bigint,
    pct013h023 bigint,
    pct013h024 bigint,
    pct013h025 bigint,
    pct013h026 bigint,
    pct013h027 bigint,
    pct013h028 bigint,
    pct013h029 bigint,
    pct013h030 bigint,
    pct013h031 bigint,
    pct013h032 bigint,
    pct013h033 bigint,
    pct013h034 bigint,
    pct013h035 bigint,
    pct013h036 bigint,
    pct013h037 bigint,
    pct013h038 bigint,
    pct013h039 bigint,
    pct013h040 bigint,
    pct013h041 bigint,
    pct013h042 bigint,
    pct013h043 bigint,
    pct013h044 bigint,
    pct013h045 bigint,
    pct013h046 bigint,
    pct013h047 bigint,
    pct013h048 bigint,
    pct013h049 bigint,
    pct013i001 bigint,
    pct013i002 bigint,
    pct013i003 bigint,
    pct013i004 bigint,
    pct013i005 bigint,
    pct013i006 bigint,
    pct013i007 bigint,
    pct013i008 bigint,
    pct013i009 bigint,
    pct013i010 bigint,
    pct013i011 bigint,
    pct013i012 bigint,
    pct013i013 bigint,
    pct013i014 bigint,
    pct013i015 bigint,
    pct013i016 bigint,
    pct013i017 bigint,
    pct013i018 bigint,
    pct013i019 bigint,
    pct013i020 bigint,
    pct013i021 bigint,
    pct013i022 bigint,
    pct013i023 bigint,
    pct013i024 bigint,
    pct013i025 bigint,
    pct013i026 bigint,
    pct013i027 bigint,
    pct013i028 bigint,
    pct013i029 bigint,
    pct013i030 bigint,
    pct013i031 bigint,
    pct013i032 bigint,
    pct013i033 bigint,
    pct013i034 bigint,
    pct013i035 bigint,
    pct013i036 bigint,
    pct013i037 bigint,
    pct013i038 bigint,
    pct013i039 bigint,
    pct013i040 bigint,
    pct013i041 bigint,
    pct013i042 bigint,
    pct013i043 bigint,
    pct013i044 bigint,
    pct013i045 bigint,
    pct013i046 bigint,
    pct013i047 bigint,
    pct013i048 bigint,
    pct013i049 bigint,
    pct015a001 bigint,
    pct015a002 bigint,
    pct015a003 bigint,
    pct015a004 bigint,
    pct015a005 bigint,
    pct015a006 bigint,
    pct015a007 bigint,
    pct015a008 bigint,
    pct015a009 bigint,
    pct015a010 bigint,
    pct015a011 bigint,
    pct015a012 bigint,
    pct015a013 bigint,
    pct015b001 bigint,
    pct015b002 bigint,
    pct015b003 bigint,
    pct015b004 bigint,
    pct015b005 bigint,
    pct015b006 bigint,
    pct015b007 bigint,
    pct015b008 bigint,
    pct015b009 bigint,
    pct015b010 bigint,
    pct015b011 bigint,
    pct015b012 bigint,
    pct015b013 bigint,
    pct015c001 bigint,
    pct015c002 bigint,
    pct015c003 bigint,
    pct015c004 bigint,
    pct015c005 bigint,
    pct015c006 bigint,
    pct015c007 bigint,
    pct015c008 bigint,
    pct015c009 bigint,
    pct015c010 bigint,
    pct015c011 bigint,
    pct015c012 bigint,
    pct015c013 bigint
);


ALTER TABLE sf10032 OWNER TO census;

--
-- Name: sf10033; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10033 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct015d001 bigint,
    pct015d002 bigint,
    pct015d003 bigint,
    pct015d004 bigint,
    pct015d005 bigint,
    pct015d006 bigint,
    pct015d007 bigint,
    pct015d008 bigint,
    pct015d009 bigint,
    pct015d010 bigint,
    pct015d011 bigint,
    pct015d012 bigint,
    pct015d013 bigint,
    pct015e001 bigint,
    pct015e002 bigint,
    pct015e003 bigint,
    pct015e004 bigint,
    pct015e005 bigint,
    pct015e006 bigint,
    pct015e007 bigint,
    pct015e008 bigint,
    pct015e009 bigint,
    pct015e010 bigint,
    pct015e011 bigint,
    pct015e012 bigint,
    pct015e013 bigint,
    pct015f001 bigint,
    pct015f002 bigint,
    pct015f003 bigint,
    pct015f004 bigint,
    pct015f005 bigint,
    pct015f006 bigint,
    pct015f007 bigint,
    pct015f008 bigint,
    pct015f009 bigint,
    pct015f010 bigint,
    pct015f011 bigint,
    pct015f012 bigint,
    pct015f013 bigint,
    pct015g001 bigint,
    pct015g002 bigint,
    pct015g003 bigint,
    pct015g004 bigint,
    pct015g005 bigint,
    pct015g006 bigint,
    pct015g007 bigint,
    pct015g008 bigint,
    pct015g009 bigint,
    pct015g010 bigint,
    pct015g011 bigint,
    pct015g012 bigint,
    pct015g013 bigint,
    pct015h001 bigint,
    pct015h002 bigint,
    pct015h003 bigint,
    pct015h004 bigint,
    pct015h005 bigint,
    pct015h006 bigint,
    pct015h007 bigint,
    pct015h008 bigint,
    pct015h009 bigint,
    pct015h010 bigint,
    pct015h011 bigint,
    pct015h012 bigint,
    pct015h013 bigint,
    pct015i001 bigint,
    pct015i002 bigint,
    pct015i003 bigint,
    pct015i004 bigint,
    pct015i005 bigint,
    pct015i006 bigint,
    pct015i007 bigint,
    pct015i008 bigint,
    pct015i009 bigint,
    pct015i010 bigint,
    pct015i011 bigint,
    pct015i012 bigint,
    pct015i013 bigint,
    pct017a001 bigint,
    pct017a002 bigint,
    pct017a003 bigint,
    pct017a004 bigint,
    pct017a005 bigint,
    pct017a006 bigint,
    pct017a007 bigint,
    pct017a008 bigint,
    pct017a009 bigint,
    pct017a010 bigint,
    pct017a011 bigint,
    pct017a012 bigint,
    pct017a013 bigint,
    pct017a014 bigint,
    pct017a015 bigint,
    pct017a016 bigint,
    pct017a017 bigint,
    pct017a018 bigint,
    pct017a019 bigint,
    pct017a020 bigint,
    pct017a021 bigint,
    pct017a022 bigint,
    pct017a023 bigint,
    pct017a024 bigint,
    pct017a025 bigint,
    pct017a026 bigint,
    pct017a027 bigint,
    pct017a028 bigint,
    pct017a029 bigint,
    pct017a030 bigint,
    pct017a031 bigint,
    pct017a032 bigint,
    pct017a033 bigint,
    pct017a034 bigint,
    pct017a035 bigint,
    pct017a036 bigint,
    pct017a037 bigint,
    pct017a038 bigint,
    pct017a039 bigint,
    pct017a040 bigint,
    pct017a041 bigint,
    pct017a042 bigint,
    pct017a043 bigint,
    pct017a044 bigint,
    pct017a045 bigint,
    pct017a046 bigint,
    pct017a047 bigint,
    pct017a048 bigint,
    pct017a049 bigint,
    pct017a050 bigint,
    pct017a051 bigint,
    pct017a052 bigint,
    pct017a053 bigint,
    pct017a054 bigint,
    pct017a055 bigint,
    pct017a056 bigint,
    pct017a057 bigint,
    pct017a058 bigint,
    pct017a059 bigint,
    pct017a060 bigint,
    pct017a061 bigint,
    pct017a062 bigint,
    pct017a063 bigint,
    pct017a064 bigint,
    pct017a065 bigint,
    pct017a066 bigint,
    pct017a067 bigint,
    pct017a068 bigint,
    pct017a069 bigint,
    pct017a070 bigint,
    pct017a071 bigint,
    pct017a072 bigint,
    pct017a073 bigint,
    pct017a074 bigint,
    pct017a075 bigint,
    pct017b001 bigint,
    pct017b002 bigint,
    pct017b003 bigint,
    pct017b004 bigint,
    pct017b005 bigint,
    pct017b006 bigint,
    pct017b007 bigint,
    pct017b008 bigint,
    pct017b009 bigint,
    pct017b010 bigint,
    pct017b011 bigint,
    pct017b012 bigint,
    pct017b013 bigint,
    pct017b014 bigint,
    pct017b015 bigint,
    pct017b016 bigint,
    pct017b017 bigint,
    pct017b018 bigint,
    pct017b019 bigint,
    pct017b020 bigint,
    pct017b021 bigint,
    pct017b022 bigint,
    pct017b023 bigint,
    pct017b024 bigint,
    pct017b025 bigint,
    pct017b026 bigint,
    pct017b027 bigint,
    pct017b028 bigint,
    pct017b029 bigint,
    pct017b030 bigint,
    pct017b031 bigint,
    pct017b032 bigint,
    pct017b033 bigint,
    pct017b034 bigint,
    pct017b035 bigint,
    pct017b036 bigint,
    pct017b037 bigint,
    pct017b038 bigint,
    pct017b039 bigint,
    pct017b040 bigint,
    pct017b041 bigint,
    pct017b042 bigint,
    pct017b043 bigint,
    pct017b044 bigint,
    pct017b045 bigint,
    pct017b046 bigint,
    pct017b047 bigint,
    pct017b048 bigint,
    pct017b049 bigint,
    pct017b050 bigint,
    pct017b051 bigint,
    pct017b052 bigint,
    pct017b053 bigint,
    pct017b054 bigint,
    pct017b055 bigint,
    pct017b056 bigint,
    pct017b057 bigint,
    pct017b058 bigint,
    pct017b059 bigint,
    pct017b060 bigint,
    pct017b061 bigint,
    pct017b062 bigint,
    pct017b063 bigint,
    pct017b064 bigint,
    pct017b065 bigint,
    pct017b066 bigint,
    pct017b067 bigint,
    pct017b068 bigint,
    pct017b069 bigint,
    pct017b070 bigint,
    pct017b071 bigint,
    pct017b072 bigint,
    pct017b073 bigint,
    pct017b074 bigint,
    pct017b075 bigint
);


ALTER TABLE sf10033 OWNER TO census;

--
-- Name: sf10034; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10034 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct017c001 bigint,
    pct017c002 bigint,
    pct017c003 bigint,
    pct017c004 bigint,
    pct017c005 bigint,
    pct017c006 bigint,
    pct017c007 bigint,
    pct017c008 bigint,
    pct017c009 bigint,
    pct017c010 bigint,
    pct017c011 bigint,
    pct017c012 bigint,
    pct017c013 bigint,
    pct017c014 bigint,
    pct017c015 bigint,
    pct017c016 bigint,
    pct017c017 bigint,
    pct017c018 bigint,
    pct017c019 bigint,
    pct017c020 bigint,
    pct017c021 bigint,
    pct017c022 bigint,
    pct017c023 bigint,
    pct017c024 bigint,
    pct017c025 bigint,
    pct017c026 bigint,
    pct017c027 bigint,
    pct017c028 bigint,
    pct017c029 bigint,
    pct017c030 bigint,
    pct017c031 bigint,
    pct017c032 bigint,
    pct017c033 bigint,
    pct017c034 bigint,
    pct017c035 bigint,
    pct017c036 bigint,
    pct017c037 bigint,
    pct017c038 bigint,
    pct017c039 bigint,
    pct017c040 bigint,
    pct017c041 bigint,
    pct017c042 bigint,
    pct017c043 bigint,
    pct017c044 bigint,
    pct017c045 bigint,
    pct017c046 bigint,
    pct017c047 bigint,
    pct017c048 bigint,
    pct017c049 bigint,
    pct017c050 bigint,
    pct017c051 bigint,
    pct017c052 bigint,
    pct017c053 bigint,
    pct017c054 bigint,
    pct017c055 bigint,
    pct017c056 bigint,
    pct017c057 bigint,
    pct017c058 bigint,
    pct017c059 bigint,
    pct017c060 bigint,
    pct017c061 bigint,
    pct017c062 bigint,
    pct017c063 bigint,
    pct017c064 bigint,
    pct017c065 bigint,
    pct017c066 bigint,
    pct017c067 bigint,
    pct017c068 bigint,
    pct017c069 bigint,
    pct017c070 bigint,
    pct017c071 bigint,
    pct017c072 bigint,
    pct017c073 bigint,
    pct017c074 bigint,
    pct017c075 bigint,
    pct017d001 bigint,
    pct017d002 bigint,
    pct017d003 bigint,
    pct017d004 bigint,
    pct017d005 bigint,
    pct017d006 bigint,
    pct017d007 bigint,
    pct017d008 bigint,
    pct017d009 bigint,
    pct017d010 bigint,
    pct017d011 bigint,
    pct017d012 bigint,
    pct017d013 bigint,
    pct017d014 bigint,
    pct017d015 bigint,
    pct017d016 bigint,
    pct017d017 bigint,
    pct017d018 bigint,
    pct017d019 bigint,
    pct017d020 bigint,
    pct017d021 bigint,
    pct017d022 bigint,
    pct017d023 bigint,
    pct017d024 bigint,
    pct017d025 bigint,
    pct017d026 bigint,
    pct017d027 bigint,
    pct017d028 bigint,
    pct017d029 bigint,
    pct017d030 bigint,
    pct017d031 bigint,
    pct017d032 bigint,
    pct017d033 bigint,
    pct017d034 bigint,
    pct017d035 bigint,
    pct017d036 bigint,
    pct017d037 bigint,
    pct017d038 bigint,
    pct017d039 bigint,
    pct017d040 bigint,
    pct017d041 bigint,
    pct017d042 bigint,
    pct017d043 bigint,
    pct017d044 bigint,
    pct017d045 bigint,
    pct017d046 bigint,
    pct017d047 bigint,
    pct017d048 bigint,
    pct017d049 bigint,
    pct017d050 bigint,
    pct017d051 bigint,
    pct017d052 bigint,
    pct017d053 bigint,
    pct017d054 bigint,
    pct017d055 bigint,
    pct017d056 bigint,
    pct017d057 bigint,
    pct017d058 bigint,
    pct017d059 bigint,
    pct017d060 bigint,
    pct017d061 bigint,
    pct017d062 bigint,
    pct017d063 bigint,
    pct017d064 bigint,
    pct017d065 bigint,
    pct017d066 bigint,
    pct017d067 bigint,
    pct017d068 bigint,
    pct017d069 bigint,
    pct017d070 bigint,
    pct017d071 bigint,
    pct017d072 bigint,
    pct017d073 bigint,
    pct017d074 bigint,
    pct017d075 bigint,
    pct017e001 bigint,
    pct017e002 bigint,
    pct017e003 bigint,
    pct017e004 bigint,
    pct017e005 bigint,
    pct017e006 bigint,
    pct017e007 bigint,
    pct017e008 bigint,
    pct017e009 bigint,
    pct017e010 bigint,
    pct017e011 bigint,
    pct017e012 bigint,
    pct017e013 bigint,
    pct017e014 bigint,
    pct017e015 bigint,
    pct017e016 bigint,
    pct017e017 bigint,
    pct017e018 bigint,
    pct017e019 bigint,
    pct017e020 bigint,
    pct017e021 bigint,
    pct017e022 bigint,
    pct017e023 bigint,
    pct017e024 bigint,
    pct017e025 bigint,
    pct017e026 bigint,
    pct017e027 bigint,
    pct017e028 bigint,
    pct017e029 bigint,
    pct017e030 bigint,
    pct017e031 bigint,
    pct017e032 bigint,
    pct017e033 bigint,
    pct017e034 bigint,
    pct017e035 bigint,
    pct017e036 bigint,
    pct017e037 bigint,
    pct017e038 bigint,
    pct017e039 bigint,
    pct017e040 bigint,
    pct017e041 bigint,
    pct017e042 bigint,
    pct017e043 bigint,
    pct017e044 bigint,
    pct017e045 bigint,
    pct017e046 bigint,
    pct017e047 bigint,
    pct017e048 bigint,
    pct017e049 bigint,
    pct017e050 bigint,
    pct017e051 bigint,
    pct017e052 bigint,
    pct017e053 bigint,
    pct017e054 bigint,
    pct017e055 bigint,
    pct017e056 bigint,
    pct017e057 bigint,
    pct017e058 bigint,
    pct017e059 bigint,
    pct017e060 bigint,
    pct017e061 bigint,
    pct017e062 bigint,
    pct017e063 bigint,
    pct017e064 bigint,
    pct017e065 bigint,
    pct017e066 bigint,
    pct017e067 bigint,
    pct017e068 bigint,
    pct017e069 bigint,
    pct017e070 bigint,
    pct017e071 bigint,
    pct017e072 bigint,
    pct017e073 bigint,
    pct017e074 bigint,
    pct017e075 bigint
);


ALTER TABLE sf10034 OWNER TO census;

--
-- Name: sf10035; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10035 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct017f001 bigint,
    pct017f002 bigint,
    pct017f003 bigint,
    pct017f004 bigint,
    pct017f005 bigint,
    pct017f006 bigint,
    pct017f007 bigint,
    pct017f008 bigint,
    pct017f009 bigint,
    pct017f010 bigint,
    pct017f011 bigint,
    pct017f012 bigint,
    pct017f013 bigint,
    pct017f014 bigint,
    pct017f015 bigint,
    pct017f016 bigint,
    pct017f017 bigint,
    pct017f018 bigint,
    pct017f019 bigint,
    pct017f020 bigint,
    pct017f021 bigint,
    pct017f022 bigint,
    pct017f023 bigint,
    pct017f024 bigint,
    pct017f025 bigint,
    pct017f026 bigint,
    pct017f027 bigint,
    pct017f028 bigint,
    pct017f029 bigint,
    pct017f030 bigint,
    pct017f031 bigint,
    pct017f032 bigint,
    pct017f033 bigint,
    pct017f034 bigint,
    pct017f035 bigint,
    pct017f036 bigint,
    pct017f037 bigint,
    pct017f038 bigint,
    pct017f039 bigint,
    pct017f040 bigint,
    pct017f041 bigint,
    pct017f042 bigint,
    pct017f043 bigint,
    pct017f044 bigint,
    pct017f045 bigint,
    pct017f046 bigint,
    pct017f047 bigint,
    pct017f048 bigint,
    pct017f049 bigint,
    pct017f050 bigint,
    pct017f051 bigint,
    pct017f052 bigint,
    pct017f053 bigint,
    pct017f054 bigint,
    pct017f055 bigint,
    pct017f056 bigint,
    pct017f057 bigint,
    pct017f058 bigint,
    pct017f059 bigint,
    pct017f060 bigint,
    pct017f061 bigint,
    pct017f062 bigint,
    pct017f063 bigint,
    pct017f064 bigint,
    pct017f065 bigint,
    pct017f066 bigint,
    pct017f067 bigint,
    pct017f068 bigint,
    pct017f069 bigint,
    pct017f070 bigint,
    pct017f071 bigint,
    pct017f072 bigint,
    pct017f073 bigint,
    pct017f074 bigint,
    pct017f075 bigint,
    pct017g001 bigint,
    pct017g002 bigint,
    pct017g003 bigint,
    pct017g004 bigint,
    pct017g005 bigint,
    pct017g006 bigint,
    pct017g007 bigint,
    pct017g008 bigint,
    pct017g009 bigint,
    pct017g010 bigint,
    pct017g011 bigint,
    pct017g012 bigint,
    pct017g013 bigint,
    pct017g014 bigint,
    pct017g015 bigint,
    pct017g016 bigint,
    pct017g017 bigint,
    pct017g018 bigint,
    pct017g019 bigint,
    pct017g020 bigint,
    pct017g021 bigint,
    pct017g022 bigint,
    pct017g023 bigint,
    pct017g024 bigint,
    pct017g025 bigint,
    pct017g026 bigint,
    pct017g027 bigint,
    pct017g028 bigint,
    pct017g029 bigint,
    pct017g030 bigint,
    pct017g031 bigint,
    pct017g032 bigint,
    pct017g033 bigint,
    pct017g034 bigint,
    pct017g035 bigint,
    pct017g036 bigint,
    pct017g037 bigint,
    pct017g038 bigint,
    pct017g039 bigint,
    pct017g040 bigint,
    pct017g041 bigint,
    pct017g042 bigint,
    pct017g043 bigint,
    pct017g044 bigint,
    pct017g045 bigint,
    pct017g046 bigint,
    pct017g047 bigint,
    pct017g048 bigint,
    pct017g049 bigint,
    pct017g050 bigint,
    pct017g051 bigint,
    pct017g052 bigint,
    pct017g053 bigint,
    pct017g054 bigint,
    pct017g055 bigint,
    pct017g056 bigint,
    pct017g057 bigint,
    pct017g058 bigint,
    pct017g059 bigint,
    pct017g060 bigint,
    pct017g061 bigint,
    pct017g062 bigint,
    pct017g063 bigint,
    pct017g064 bigint,
    pct017g065 bigint,
    pct017g066 bigint,
    pct017g067 bigint,
    pct017g068 bigint,
    pct017g069 bigint,
    pct017g070 bigint,
    pct017g071 bigint,
    pct017g072 bigint,
    pct017g073 bigint,
    pct017g074 bigint,
    pct017g075 bigint,
    pct017h001 bigint,
    pct017h002 bigint,
    pct017h003 bigint,
    pct017h004 bigint,
    pct017h005 bigint,
    pct017h006 bigint,
    pct017h007 bigint,
    pct017h008 bigint,
    pct017h009 bigint,
    pct017h010 bigint,
    pct017h011 bigint,
    pct017h012 bigint,
    pct017h013 bigint,
    pct017h014 bigint,
    pct017h015 bigint,
    pct017h016 bigint,
    pct017h017 bigint,
    pct017h018 bigint,
    pct017h019 bigint,
    pct017h020 bigint,
    pct017h021 bigint,
    pct017h022 bigint,
    pct017h023 bigint,
    pct017h024 bigint,
    pct017h025 bigint,
    pct017h026 bigint,
    pct017h027 bigint,
    pct017h028 bigint,
    pct017h029 bigint,
    pct017h030 bigint,
    pct017h031 bigint,
    pct017h032 bigint,
    pct017h033 bigint,
    pct017h034 bigint,
    pct017h035 bigint,
    pct017h036 bigint,
    pct017h037 bigint,
    pct017h038 bigint,
    pct017h039 bigint,
    pct017h040 bigint,
    pct017h041 bigint,
    pct017h042 bigint,
    pct017h043 bigint,
    pct017h044 bigint,
    pct017h045 bigint,
    pct017h046 bigint,
    pct017h047 bigint,
    pct017h048 bigint,
    pct017h049 bigint,
    pct017h050 bigint,
    pct017h051 bigint,
    pct017h052 bigint,
    pct017h053 bigint,
    pct017h054 bigint,
    pct017h055 bigint,
    pct017h056 bigint,
    pct017h057 bigint,
    pct017h058 bigint,
    pct017h059 bigint,
    pct017h060 bigint,
    pct017h061 bigint,
    pct017h062 bigint,
    pct017h063 bigint,
    pct017h064 bigint,
    pct017h065 bigint,
    pct017h066 bigint,
    pct017h067 bigint,
    pct017h068 bigint,
    pct017h069 bigint,
    pct017h070 bigint,
    pct017h071 bigint,
    pct017h072 bigint,
    pct017h073 bigint,
    pct017h074 bigint,
    pct017h075 bigint
);


ALTER TABLE sf10035 OWNER TO census;

--
-- Name: sf10036; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10036 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    pct017i001 bigint,
    pct017i002 bigint,
    pct017i003 bigint,
    pct017i004 bigint,
    pct017i005 bigint,
    pct017i006 bigint,
    pct017i007 bigint,
    pct017i008 bigint,
    pct017i009 bigint,
    pct017i010 bigint,
    pct017i011 bigint,
    pct017i012 bigint,
    pct017i013 bigint,
    pct017i014 bigint,
    pct017i015 bigint,
    pct017i016 bigint,
    pct017i017 bigint,
    pct017i018 bigint,
    pct017i019 bigint,
    pct017i020 bigint,
    pct017i021 bigint,
    pct017i022 bigint,
    pct017i023 bigint,
    pct017i024 bigint,
    pct017i025 bigint,
    pct017i026 bigint,
    pct017i027 bigint,
    pct017i028 bigint,
    pct017i029 bigint,
    pct017i030 bigint,
    pct017i031 bigint,
    pct017i032 bigint,
    pct017i033 bigint,
    pct017i034 bigint,
    pct017i035 bigint,
    pct017i036 bigint,
    pct017i037 bigint,
    pct017i038 bigint,
    pct017i039 bigint,
    pct017i040 bigint,
    pct017i041 bigint,
    pct017i042 bigint,
    pct017i043 bigint,
    pct017i044 bigint,
    pct017i045 bigint,
    pct017i046 bigint,
    pct017i047 bigint,
    pct017i048 bigint,
    pct017i049 bigint,
    pct017i050 bigint,
    pct017i051 bigint,
    pct017i052 bigint,
    pct017i053 bigint,
    pct017i054 bigint,
    pct017i055 bigint,
    pct017i056 bigint,
    pct017i057 bigint,
    pct017i058 bigint,
    pct017i059 bigint,
    pct017i060 bigint,
    pct017i061 bigint,
    pct017i062 bigint,
    pct017i063 bigint,
    pct017i064 bigint,
    pct017i065 bigint,
    pct017i066 bigint,
    pct017i067 bigint,
    pct017i068 bigint,
    pct017i069 bigint,
    pct017i070 bigint,
    pct017i071 bigint,
    pct017i072 bigint,
    pct017i073 bigint,
    pct017i074 bigint,
    pct017i075 bigint
);


ALTER TABLE sf10036 OWNER TO census;

--
-- Name: sf10037; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10037 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    h001001 bigint,
    h002001 bigint,
    h002002 bigint,
    h002003 bigint,
    h002004 bigint,
    h002005 bigint,
    h002006 bigint,
    h003001 bigint,
    h003002 bigint,
    h003003 bigint,
    h004001 bigint,
    h004002 bigint,
    h004003 bigint,
    h005001 bigint,
    h005002 bigint,
    h005003 bigint,
    h005004 bigint,
    h005005 bigint,
    h005006 bigint,
    h005007 bigint,
    h006001 bigint,
    h006002 bigint,
    h006003 bigint,
    h006004 bigint,
    h006005 bigint,
    h006006 bigint,
    h006007 bigint,
    h006008 bigint,
    h007001 bigint,
    h007002 bigint,
    h007003 bigint,
    h007004 bigint,
    h007005 bigint,
    h007006 bigint,
    h007007 bigint,
    h007008 bigint,
    h007009 bigint,
    h007010 bigint,
    h007011 bigint,
    h007012 bigint,
    h007013 bigint,
    h007014 bigint,
    h007015 bigint,
    h007016 bigint,
    h007017 bigint,
    h008001 bigint,
    h008002 bigint,
    h008003 bigint,
    h008004 bigint,
    h008005 bigint,
    h008006 bigint,
    h008007 bigint,
    h009001 bigint,
    h009002 bigint,
    h009003 bigint,
    h009004 bigint,
    h009005 bigint,
    h009006 bigint,
    h009007 bigint,
    h009008 bigint,
    h009009 bigint,
    h009010 bigint,
    h009011 bigint,
    h009012 bigint,
    h009013 bigint,
    h009014 bigint,
    h009015 bigint,
    h010001 bigint,
    h011001 bigint,
    h011002 bigint,
    h011003 bigint,
    h012001 double precision,
    h012002 double precision,
    h012003 double precision,
    h013001 bigint,
    h013002 bigint,
    h013003 bigint,
    h013004 bigint,
    h013005 bigint,
    h013006 bigint,
    h013007 bigint,
    h013008 bigint,
    h014001 bigint,
    h014002 bigint,
    h014003 bigint,
    h014004 bigint,
    h014005 bigint,
    h014006 bigint,
    h014007 bigint,
    h014008 bigint,
    h014009 bigint,
    h014010 bigint,
    h014011 bigint,
    h014012 bigint,
    h014013 bigint,
    h014014 bigint,
    h014015 bigint,
    h014016 bigint,
    h014017 bigint,
    h015001 bigint,
    h015002 bigint,
    h015003 bigint,
    h015004 bigint,
    h015005 bigint,
    h015006 bigint,
    h015007 bigint,
    h015008 bigint,
    h015009 bigint,
    h015010 bigint,
    h015011 bigint,
    h015012 bigint,
    h015013 bigint,
    h015014 bigint,
    h015015 bigint,
    h015016 bigint,
    h015017 bigint,
    h016001 bigint,
    h016002 bigint,
    h016003 bigint,
    h016004 bigint,
    h016005 bigint,
    h016006 bigint,
    h016007 bigint,
    h016008 bigint,
    h016009 bigint,
    h016010 bigint,
    h016011 bigint,
    h016012 bigint,
    h016013 bigint,
    h016014 bigint,
    h016015 bigint,
    h016016 bigint,
    h016017 bigint,
    h016018 bigint,
    h016019 bigint,
    h017001 bigint,
    h017002 bigint,
    h017003 bigint,
    h017004 bigint,
    h017005 bigint,
    h017006 bigint,
    h017007 bigint,
    h017008 bigint,
    h017009 bigint,
    h017010 bigint,
    h017011 bigint,
    h017012 bigint,
    h017013 bigint,
    h017014 bigint,
    h017015 bigint,
    h017016 bigint,
    h017017 bigint,
    h017018 bigint,
    h017019 bigint,
    h017020 bigint,
    h017021 bigint,
    h017022 bigint,
    h017023 bigint,
    h017024 bigint,
    h017025 bigint,
    h017026 bigint,
    h017027 bigint,
    h017028 bigint,
    h017029 bigint,
    h017030 bigint,
    h017031 bigint,
    h017032 bigint,
    h017033 bigint,
    h017034 bigint,
    h017035 bigint,
    h017036 bigint,
    h017037 bigint,
    h017038 bigint,
    h017039 bigint,
    h017040 bigint,
    h017041 bigint,
    h017042 bigint,
    h017043 bigint,
    h017044 bigint,
    h017045 bigint,
    h017046 bigint,
    h017047 bigint,
    h017048 bigint,
    h017049 bigint,
    h017050 bigint,
    h017051 bigint,
    h017052 bigint,
    h017053 bigint,
    h017054 bigint,
    h017055 bigint,
    h017056 bigint,
    h017057 bigint,
    h017058 bigint,
    h017059 bigint,
    h017060 bigint,
    h017061 bigint,
    h017062 bigint,
    h017063 bigint,
    h017064 bigint,
    h017065 bigint,
    h017066 bigint,
    h017067 bigint,
    h017068 bigint,
    h017069 bigint,
    h018001 bigint,
    h018002 bigint,
    h018003 bigint,
    h019001 bigint,
    h019002 bigint,
    h019003 bigint,
    h019004 bigint,
    h019005 bigint,
    h020001 bigint,
    h020002 bigint,
    h020003 bigint,
    h020004 bigint,
    h020005 bigint
);


ALTER TABLE sf10037 OWNER TO census;

--
-- Name: sf10038; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10038 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    h011a001 bigint,
    h011a002 bigint,
    h011a003 bigint,
    h011b001 bigint,
    h011b002 bigint,
    h011b003 bigint,
    h011c001 bigint,
    h011c002 bigint,
    h011c003 bigint,
    h011d001 bigint,
    h011d002 bigint,
    h011d003 bigint,
    h011e001 bigint,
    h011e002 bigint,
    h011e003 bigint,
    h011f001 bigint,
    h011f002 bigint,
    h011f003 bigint,
    h011g001 bigint,
    h011g002 bigint,
    h011g003 bigint,
    h011h001 bigint,
    h011h002 bigint,
    h011h003 bigint,
    h011i001 bigint,
    h011i002 bigint,
    h011i003 bigint,
    h012a001 double precision,
    h012a002 double precision,
    h012a003 double precision,
    h012b001 double precision,
    h012b002 double precision,
    h012b003 double precision,
    h012c001 double precision,
    h012c002 double precision,
    h012c003 double precision,
    h012d001 double precision,
    h012d002 double precision,
    h012d003 double precision,
    h012e001 double precision,
    h012e002 double precision,
    h012e003 double precision,
    h012f001 double precision,
    h012f002 double precision,
    h012f003 double precision,
    h012g001 double precision,
    h012g002 double precision,
    h012g003 double precision,
    h012h001 double precision,
    h012h002 double precision,
    h012h003 double precision,
    h012i001 double precision,
    h012i002 double precision,
    h012i003 double precision,
    h015a001 bigint,
    h015a002 bigint,
    h015a003 bigint,
    h015a004 bigint,
    h015a005 bigint,
    h015a006 bigint,
    h015a007 bigint,
    h015a008 bigint,
    h015a009 bigint,
    h015a010 bigint,
    h015a011 bigint,
    h015a012 bigint,
    h015a013 bigint,
    h015a014 bigint,
    h015a015 bigint,
    h015a016 bigint,
    h015a017 bigint,
    h015b001 bigint,
    h015b002 bigint,
    h015b003 bigint,
    h015b004 bigint,
    h015b005 bigint,
    h015b006 bigint,
    h015b007 bigint,
    h015b008 bigint,
    h015b009 bigint,
    h015b010 bigint,
    h015b011 bigint,
    h015b012 bigint,
    h015b013 bigint,
    h015b014 bigint,
    h015b015 bigint,
    h015b016 bigint,
    h015b017 bigint,
    h015c001 bigint,
    h015c002 bigint,
    h015c003 bigint,
    h015c004 bigint,
    h015c005 bigint,
    h015c006 bigint,
    h015c007 bigint,
    h015c008 bigint,
    h015c009 bigint,
    h015c010 bigint,
    h015c011 bigint,
    h015c012 bigint,
    h015c013 bigint,
    h015c014 bigint,
    h015c015 bigint,
    h015c016 bigint,
    h015c017 bigint,
    h015d001 bigint,
    h015d002 bigint,
    h015d003 bigint,
    h015d004 bigint,
    h015d005 bigint,
    h015d006 bigint,
    h015d007 bigint,
    h015d008 bigint,
    h015d009 bigint,
    h015d010 bigint,
    h015d011 bigint,
    h015d012 bigint,
    h015d013 bigint,
    h015d014 bigint,
    h015d015 bigint,
    h015d016 bigint,
    h015d017 bigint,
    h015e001 bigint,
    h015e002 bigint,
    h015e003 bigint,
    h015e004 bigint,
    h015e005 bigint,
    h015e006 bigint,
    h015e007 bigint,
    h015e008 bigint,
    h015e009 bigint,
    h015e010 bigint,
    h015e011 bigint,
    h015e012 bigint,
    h015e013 bigint,
    h015e014 bigint,
    h015e015 bigint,
    h015e016 bigint,
    h015e017 bigint,
    h015f001 bigint,
    h015f002 bigint,
    h015f003 bigint,
    h015f004 bigint,
    h015f005 bigint,
    h015f006 bigint,
    h015f007 bigint,
    h015f008 bigint,
    h015f009 bigint,
    h015f010 bigint,
    h015f011 bigint,
    h015f012 bigint,
    h015f013 bigint,
    h015f014 bigint,
    h015f015 bigint,
    h015f016 bigint,
    h015f017 bigint,
    h015g001 bigint,
    h015g002 bigint,
    h015g003 bigint,
    h015g004 bigint,
    h015g005 bigint,
    h015g006 bigint,
    h015g007 bigint,
    h015g008 bigint,
    h015g009 bigint,
    h015g010 bigint,
    h015g011 bigint,
    h015g012 bigint,
    h015g013 bigint,
    h015g014 bigint,
    h015g015 bigint,
    h015g016 bigint,
    h015g017 bigint,
    h015h001 bigint,
    h015h002 bigint,
    h015h003 bigint,
    h015h004 bigint,
    h015h005 bigint,
    h015h006 bigint,
    h015h007 bigint,
    h015h008 bigint,
    h015h009 bigint,
    h015h010 bigint,
    h015h011 bigint,
    h015h012 bigint,
    h015h013 bigint,
    h015h014 bigint,
    h015h015 bigint,
    h015h016 bigint,
    h015h017 bigint,
    h015i001 bigint,
    h015i002 bigint,
    h015i003 bigint,
    h015i004 bigint,
    h015i005 bigint,
    h015i006 bigint,
    h015i007 bigint,
    h015i008 bigint,
    h015i009 bigint,
    h015i010 bigint,
    h015i011 bigint,
    h015i012 bigint,
    h015i013 bigint,
    h015i014 bigint,
    h015i015 bigint,
    h015i016 bigint,
    h015i017 bigint
);


ALTER TABLE sf10038 OWNER TO census;

--
-- Name: sf10039; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf10039 (
    fileid text,
    stusab text,
    chariter text,
    cifsn text,
    logrecno text,
    h016a001 bigint,
    h016a002 bigint,
    h016a003 bigint,
    h016a004 bigint,
    h016a005 bigint,
    h016a006 bigint,
    h016a007 bigint,
    h016a008 bigint,
    h016a009 bigint,
    h016a010 bigint,
    h016a011 bigint,
    h016a012 bigint,
    h016a013 bigint,
    h016a014 bigint,
    h016a015 bigint,
    h016a016 bigint,
    h016a017 bigint,
    h016a018 bigint,
    h016a019 bigint,
    h016b001 bigint,
    h016b002 bigint,
    h016b003 bigint,
    h016b004 bigint,
    h016b005 bigint,
    h016b006 bigint,
    h016b007 bigint,
    h016b008 bigint,
    h016b009 bigint,
    h016b010 bigint,
    h016b011 bigint,
    h016b012 bigint,
    h016b013 bigint,
    h016b014 bigint,
    h016b015 bigint,
    h016b016 bigint,
    h016b017 bigint,
    h016b018 bigint,
    h016b019 bigint,
    h016c001 bigint,
    h016c002 bigint,
    h016c003 bigint,
    h016c004 bigint,
    h016c005 bigint,
    h016c006 bigint,
    h016c007 bigint,
    h016c008 bigint,
    h016c009 bigint,
    h016c010 bigint,
    h016c011 bigint,
    h016c012 bigint,
    h016c013 bigint,
    h016c014 bigint,
    h016c015 bigint,
    h016c016 bigint,
    h016c017 bigint,
    h016c018 bigint,
    h016c019 bigint,
    h016d001 bigint,
    h016d002 bigint,
    h016d003 bigint,
    h016d004 bigint,
    h016d005 bigint,
    h016d006 bigint,
    h016d007 bigint,
    h016d008 bigint,
    h016d009 bigint,
    h016d010 bigint,
    h016d011 bigint,
    h016d012 bigint,
    h016d013 bigint,
    h016d014 bigint,
    h016d015 bigint,
    h016d016 bigint,
    h016d017 bigint,
    h016d018 bigint,
    h016d019 bigint,
    h016e001 bigint,
    h016e002 bigint,
    h016e003 bigint,
    h016e004 bigint,
    h016e005 bigint,
    h016e006 bigint,
    h016e007 bigint,
    h016e008 bigint,
    h016e009 bigint,
    h016e010 bigint,
    h016e011 bigint,
    h016e012 bigint,
    h016e013 bigint,
    h016e014 bigint,
    h016e015 bigint,
    h016e016 bigint,
    h016e017 bigint,
    h016e018 bigint,
    h016e019 bigint,
    h016f001 bigint,
    h016f002 bigint,
    h016f003 bigint,
    h016f004 bigint,
    h016f005 bigint,
    h016f006 bigint,
    h016f007 bigint,
    h016f008 bigint,
    h016f009 bigint,
    h016f010 bigint,
    h016f011 bigint,
    h016f012 bigint,
    h016f013 bigint,
    h016f014 bigint,
    h016f015 bigint,
    h016f016 bigint,
    h016f017 bigint,
    h016f018 bigint,
    h016f019 bigint,
    h016g001 bigint,
    h016g002 bigint,
    h016g003 bigint,
    h016g004 bigint,
    h016g005 bigint,
    h016g006 bigint,
    h016g007 bigint,
    h016g008 bigint,
    h016g009 bigint,
    h016g010 bigint,
    h016g011 bigint,
    h016g012 bigint,
    h016g013 bigint,
    h016g014 bigint,
    h016g015 bigint,
    h016g016 bigint,
    h016g017 bigint,
    h016g018 bigint,
    h016g019 bigint,
    h016h001 bigint,
    h016h002 bigint,
    h016h003 bigint,
    h016h004 bigint,
    h016h005 bigint,
    h016h006 bigint,
    h016h007 bigint,
    h016h008 bigint,
    h016h009 bigint,
    h016h010 bigint,
    h016h011 bigint,
    h016h012 bigint,
    h016h013 bigint,
    h016h014 bigint,
    h016h015 bigint,
    h016h016 bigint,
    h016h017 bigint,
    h016h018 bigint,
    h016h019 bigint,
    h016i001 bigint,
    h016i002 bigint,
    h016i003 bigint,
    h016i004 bigint,
    h016i005 bigint,
    h016i006 bigint,
    h016i007 bigint,
    h016i008 bigint,
    h016i009 bigint,
    h016i010 bigint,
    h016i011 bigint,
    h016i012 bigint,
    h016i013 bigint,
    h016i014 bigint,
    h016i015 bigint,
    h016i016 bigint,
    h016i017 bigint,
    h016i018 bigint,
    h016i019 bigint
);


ALTER TABLE sf10039 OWNER TO census;

--
-- Name: sf1geo; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE sf1geo (
    fileid text,
    stusab text,
    sumlev text,
    geocomp text,
    chariter text,
    cifsn text,
    logrecno text NOT NULL,
    region text,
    division text,
    statece text,
    state text,
    county text,
    countysc text,
    cousub text,
    cousubcc text,
    cousubsc text,
    place text,
    placecc text,
    placedc text,
    placesc text,
    tract text,
    blkgrp text,
    block text,
    iuc text,
    concit text,
    concitcc text,
    concitsc text,
    aianhh text,
    aianhhfp text,
    aianhhcc text,
    aihhtli text,
    aitsce text,
    aits text,
    aitscc text,
    anrc text,
    anrccc text,
    msacmsa text,
    masc text,
    cmsa text,
    macci text,
    pmsa text,
    necma text,
    necmacci text,
    necmasc text,
    exi text,
    ua text,
    uasc text,
    uatype text,
    ur text,
    cd106 text,
    cd108 text,
    cd109 text,
    cd110 text,
    sldu text,
    sldl text,
    vtd text,
    vtdi text,
    zcta3 text,
    zcta5 text,
    submcd text,
    submcdcc text,
    arealand text,
    areawatr text,
    name text,
    funcstat text,
    gcuni text,
    pop100 text,
    hu100 text,
    intptlat text,
    intptlon text,
    lsadc text,
    partflag text,
    sdelm text,
    sdsec text,
    sduni text,
    taz text,
    uga text,
    puma5 text,
    puma1 text,
    reserve2 text,
    macc text,
    uacp text,
    reserved text,
    geoid00 text
);


ALTER TABLE sf1geo OWNER TO census;

--
-- Name: tmp_geoheader; Type: TABLE; Schema: census2000; Owner: census
--

CREATE TABLE tmp_geoheader (
    line text
);


ALTER TABLE tmp_geoheader OWNER TO census;

--
-- Name: sf10001_pkey; Type: CONSTRAINT; Schema: census2000; Owner: census
--

ALTER TABLE ONLY sf10001
    ADD CONSTRAINT sf10001_pkey PRIMARY KEY (logrecno);


--
-- Name: sf1geo_pkey; Type: CONSTRAINT; Schema: census2000; Owner: census
--

ALTER TABLE ONLY sf1geo
    ADD CONSTRAINT sf1geo_pkey PRIMARY KEY (logrecno);


--
-- Name: sf1geo_geoid00_idx; Type: INDEX; Schema: census2000; Owner: census
--

CREATE INDEX sf1geo_geoid00_idx ON sf1geo USING btree (geoid00);


--
-- Name: sf1geo_sumlev_idx; Type: INDEX; Schema: census2000; Owner: census
--

CREATE INDEX sf1geo_sumlev_idx ON sf1geo USING btree (sumlev);


--
-- PostgreSQL database dump complete
--

