-CREATE TABLE hmda_user.modifiedlar2018
-(
+-- SCHEMA: hmda_user
+
+-- DROP SCHEMA hmda_user ;
+
+CREATE SCHEMA hmda_user AUTHORIZATION hmda_user;
+
+--
+-- PostgreSQL database dump
+--
+
+-- Dumped from database version 10.6
+-- Dumped by pg_dump version 10.5
+
+-- Started on 2019-06-05 11:44:49 EDT
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET idle_in_transaction_session_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SELECT pg_catalog.set_config('search_path', '', false);
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+SET row_security = off;
+
+SET default_tablespace = '';
+
+SET default_with_oids = false;
+
+--
+-- TOC entry 282 (class 1259 OID 22057)
+-- Name: modifiedlar2018; Type: TABLE; Schema: hmda_user; Owner: hmda_user
+--
+
+CREATE TABLE hmda_user.modifiedlar2018 (
     id integer NOT NULL,
     lei character varying NOT NULL,
     loan_type integer,

    interest_rate character varying,
    payment_penalty character varying,
    debt_to_incode character varying,
    loan_value_ratio character  varying,
    loan_term character varying,
    rate_spread_intro character varying,
    baloon_payment integer,

    state character varying,
    county character varying,
    tract character varying,
    ethnicity_applicant_1 character varying,
    ethnicity_applicant_2 character varying,
    ethnicity_applicant_3 character varying,
    ethnicity_applicant_4 character varying,
    ethnicity_applicant_5 character varying,
    ethnicity_observed_applicant integer,
    ethnicity_co_applicant_1 character varying,
    ethnicity_co_applicant_2 character varying,
    ethnicity_co_applicant_3 character varying,
    ethnicity_co_applicant_4 character varying,
    ethnicity_co_applicant_5 character varying,
    ethnicity_observed_co_applicant integer,
    race_applicant_1 character varying,
    race_applicant_2 character varying,
    race_applicant_3 character varying,
    race_applicant_4 character varying,
    race_applicant_5 character varying,
    race_co_applicant_1 character varying,
    race_co_applicant_2 character varying,
    race_co_applicant_3 character varying,
    race_co_applicant_4 character varying,
    race_co_applicant_5 character varying,
    race_observed_applicant integer,
    race_observed_co_applicant integer,
    sex_applicant integer,
