COLUMN_KEY_DICTIONARY = {
    "contributedby": "full_name",
    "amount": "donation_amount",
    "rcvddate": "donation_date",
    "address1": "addr1",
    "address2": "addr2",
    "state": "state",
    "city": "city",
    "zip": "zip",
    "contributor": "full_name",
    "contributiondate": "donation_date",
    "zipcode": "zip",
    "contributor_payee": "full_name",
    "date": "donation_date",
    "address": "addr1",
    "contributor_address": "full_address",
    "first_name": "first_name",
    "last_business_name": "last_name",
    "transactionname": "full_name",
    "transactiondate": "donation_date",
    "contributor_name": "full_name",
    "start_date": "donation_date",
    "contributor_state": "state",
    "contributor_city": "city",
    "contributor_zip_code": "zip",
    "transaction_date": "donation_date",
    "contributor_first_name": "first_name",
    "contributor_last_name": "last_name",
    "number_and_street": "addr1",
    "receipt_date": "donation_date",
    "contributor_address_line_1": "addr1",
    "contributor_address_line_2": "addr2",
    "contribution_date": "donation_date",
    "contribution_amount": "donation_amount",
    "contributor_zip": "zip",
    "contributor_street_1": "addr1",
    "contributor_street_2": "addr2",
    "contribution_receipt_amount": "donation_amount",
    "contribution_receipt_date": "donation_date",
    "entity_nam_f": "first_name",
    "entity_nam_l": "last_name",
    "entity_adr1": "addr1",
    "entity_adr2": "addr2",
    "entity_city": "city",
    "entity_st": "state",
    "entity_zip4": "zip",
    "tran_date": "donation_date",
    "cash_amount": "donation_amount",
    "lastname": "last_name",
    "firstname": "first_name",
    "address_1": "addr1",
    "address_2": "addr2",
    "zip_code": "zip",
    "contributedbyname": "full_name",
    "contributedbyaddress1": "addr1",
    "contributedbyaddress2": "addr2",
    "contributedbycity": "city",
    "contributedbystate": "state",
    "contributedbyzip": "zip",
    "from_name": "full_name",
    "from_address": "addr1",
    "from_state": "state",
    "from_city": "city",
    "from_zip": "zip",
    "contributorfirstname": "first_name",
    "contributorlastname": "last_name",
    "receiptdate": "donation_date",
    "contributorname": "full_name",
    "contributoraddr1": "addr1",
    "contributoraddr2": "addr2",
    "contributionamt": "donation_amount",
    "contributorstate": "state",
    "contributorcity": "city",
    "contributorzip": "zip",
    "contributor_last_business_name": "last_name",
    "amount_received": "donation_amount",
    "name": "full_name",
    "address_line_1": "addr1",
    "address_line_2": "addr2",
    "postal_code": "zip",
    "contrib_zip": "zip",
    "date_paid": "donation_date",
    "street_line_1": "addr1",
    "street_line_2": "addr2",
    "date_occured": "donation_date",
    "addressstreet": "addr1",
    "addressstreet2": "addr2",
    "addressstateid": "state",
    "addresscity": "city",
    "addresszip": "zip",
    "contributor_or_source": "full_name",
    "city_state": "full_address",
    "mi": "middle_name",
    "street": "addr1",
    "contributionamount": "donation_amount",
    "addr_line1": "addr1",
    "addr_line2": "addr2",
    "tran_amt": "donation_amount",
    "line1": "addr1",
    "line2": "addr2",
    "town_city": "city",
    "contributor_recipient": "full_name",
    "addressline1": "addr1",
    "addressline2": "addr2",
    "statecode": "state",
    "street_address_1": "addr1",
    "street_address_2": "addr2",
    "contributor_last_name_organization_maxlen=36_": "last_name",
    'contributor_first_name_maxlen=20_': "first_name",
    'contributor_state_maxlen=2_': "state",
    'contributor_zip_maxlen=10_': "zip",
    'contributor_city_maxlen=20_': "city",
    "contributor_address_maxlen=61_": "addr1",
    "$amount_of_contribution_maxlen=13_": "donation_amount",
    "date_of_contribution_maxlen=10_": "donation_date",
    "amnt": "donation_amount",
    "donor_name": "full_name",
    "donor_address": "full_address",
    "address": "full_address",
    "city_state_zip_code": "city",
    "payment_amount": "donation_amount",
    "payment_received_date": "donation_date",
    "name_": "full_name",
    "transaction_date_": "donation_date",
    "amount_": "donation_amount",
    "contributor_address_1": "addr1",
    "contributor_address_2": "addr2",
    "transaction_amount": "donation_amount",
    "donor": "full_name"
}

PREFERRED_HEADERS = [
    "donation_date",
    "donation_amount",
    "full_address",
    "addr1",
    "addr2",
    "city",
    "state",
    "zip",
    "full_name",
    "first_name",
    "middle_name",
    "last_name",
    "phone1",
    "phone2",
    "email1",
    "email2",
]