HMDA create table

gistfile1.txt

CREATE TABLE hmda
(year integer,
respondent char(10),
agency integer,
loan_type integer,
property_type integer,
loan_purpose integer,
occupancy integer,
 loan_amount integer,
preapproval integer,
action_type integer,
msa_md integer,
state_code integer,
county_code integer,
census_tract_number char(8),
applicant_ethnicity integer,
co_applicant_ethnicity integer,
applicant_race_1 integer,
applicant_race_2 integer,
applicant_race_3 integer,
applicant_race_4 integer,
applicant_race_5 integer,
co_applicant_race_1 integer,
co_applicant_race_2 integer,
co_applicant_race_3 integer,
co_applicant_race_4 integer,
co_applicant_race_5 integer,
applicant_sex integer,
co_applicant_sex integer,
 applicant_income integer,
purchaser_type integer,
denial_reason_1 integer,
denial_reason_2 integer,
denial_reason_3 integer,
rate_spread varchar(10),
hoepa_status integer,
lien_status integer,
edit_status integer,
sequence_number integer,
population integer,
minority_population double precision,
hud_median_family_income integer,
tract_to_msa double precision,
number_of_owner_occupied_units integer,
number_of_family_units integer,
application_date_indicator integer);