This file contains all authorizations approved between 10/01/2006 and 12/31/2016 Please note that the asterisked Working Capital transactions were extended during the period of EXIM Bank’s lapse in authority in conformance with original authorization agreements. These deals were originally authorized before the lapse as multiyear facilities with annual extensions. This record represents the extension of the prior authorization. EXIM did not authorize new business during its lapse in authority.
This dataset has the following 33 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Fiscal Year | fiscal_year | number | Fiscal Year of the decision on a deal. | 2007 2008 2009 2010 2011 view top 100 |
| Unique Identifier | unique_identifier | text | A unique identifier attached to each deal. | 09673570ST1001 09673883ST1001 09673917ST1001 09674700MT1001 09674758MT1001 view top 100 |
| Deal Number | deal_number | text | The deal identifier typically used in documents relating to a deal. | 673570 673883 673917 674700 674758 view top 100 |
| Decision | decision | text | Whether a deal was Approved or Declined | Approved Declined view top 100 |
| Decision Date | decision_date | calendar_date | The date of approval or denial. | 2017-11-03T00:00:00 2018-04-06T00:00:00 2018-06-20T00:00:00 2018-04-23T00:00:00 2017-12-04T00:00:00 view top 100 |
| Expiration Date | expiration_date | calendar_date | The expiration date for a guarantee or insurance policy. | 2016-07-01T00:00:00 2016-05-01T00:00:00 2016-06-01T00:00:00 2017-05-01T00:00:00 2017-04-01T00:00:00 view top 100 |
| Brokered | brokered | text | A flag showing whether an insurance policy was brokered or not. | No Yes view top 100 |
| Deal Cancelled | deal_cancelled | text | A flag showing if an approved transaction was cancelled after approval. | No Yes view top 100 |
| Country | country | text | The country where the credit risk is. This is typically the country of the buyer on a deal except for Working Capital guarantees or multibuyer insurance policies where the buyer is not known. | United States Nigeria Ghana India Guatemala view top 100 |
| Program | program | text | The financing program that was applied for. | Working Capital Guarantee Insurance Loan view top 100 |
| Policy Type | policy_type | text | A code for the insurance policy type. (Policy Type decryption is listed below this table.) Note: this only applies to the Insurance program. | N/A ENB ESC ENV MTR view top 100 |
| Decision Authority | decision_authority | text | The level of authority that made the decision on the deal. | Individual Delegated Authority Loan/Credit Committee Board view top 100 |
| Primary Export Product NAICS/SIC code | primary_export_product_naics_sic_code | text | The industry code of the product that was exported when reported to EXIM Bank. A Standard Industry Classification code (SIC) is 4 digits, whereas the North American Industry Classification System code (NAICS) is 6. | 423830 333132 336411 N/A 213112 view top 100 |
| Product Description | product_description | text | A generic description of the product that was exported. | Industrial Machinery And Equipment Merchant Whole Oil And Gas Field Machinery And Equipment Manufac Engineering Services Aircraft Manufacturing N/A view top 100 |
| Term | term | text | The length of the financing on a deal. | Short Term Medium Term Long Term view top 100 |
| Primary Applicant | primary_applicant | text | The company name of principal Applicant on a deal. Note: for Working Capital Delegated Authority transactions the Primary Lender serves as the Primary Applicant for the Primary Exporter. | Amegy Bank National Association Air Tractor, Inc. Frost Bank ZB, National Association Comerica Bank view top 100 |
| Primary Lender | primary_lender | text | The company name of principal Lender on a deal. | Frost National Bank Amegy Bank National Association N/A Wells Fargo Bank, N.A. Ex-Im Bank view top 100 |
| Primary Exporter | primary_exporter | text | The company name of principal Exporter on a deal. | Air Tractor, Inc. Montachem International, Inc. Humco Holding Group, Inc. Unisert Multi Wall Systems, Inc. Star Cargo Inc view top 100 |
| Primary Exporter City | primary_exporter_city | text | The city of the Primary Exporter. | San Antonio Houston Irving Austin Fort Worth view top 100 |
| Primary Exporter State Code | primary_exporter_state_code | text | The state abbreviation of the Primary Exporter. | TX view top 100 |
| Primary Exporter State Name | primary_exporter_state_name | text | The state name of the Primary Exporter. | Texas view top 100 |
| Primary Borrower | primary_borrower | text | The company name of principal Borrower on a deal. | Multiple - Borrowers Generon Igs, Inc. Qri Group, Llc Mr. Valmor Da Cunha Mr. Mauricius Claudino Barbosa Silva view top 100 |
| Primary Source of Repayment (PSOR) | primary_source_of_repayment_psor | text | The primary borrower or guarantor responsible for repayment. | Multiple - PSORs Generon Igs, Inc. Qri Group, Llc Mr. Valmor Da Cunha Cabaca Aviacao Agricola Ltda. view top 100 |
| Working Capital Delegated Authority | working_capital_delegated_authority | text | A flag showing whether a Working Capital deal was decided under its' Delegated Authority program. | Yes view top 100 |
| Approved/Declined Amount | approved_declined_amount | number | The amount of financing approved or declined. | 450000 900000 300000 200000 500000 view top 100 |
| Disbursed/Shipped Amount | disbursed_shipped_amount | number | The amount of the loan or guarantee that has been disbursed or the amount that has been shipped on an insurance policy as of the date this data set was generated. | 0 1800000 900000 9000000 3600000 view top 100 |
| Undisbursed Exposure Amount | undisbursed_exposure_amount | number | The difference between the Approved Amount and the Disbursed/Shipped Amount as of the date this data set was generated. | 0 200000 100000 300000 500000 view top 100 |
| Outstanding Exposure Amount | outstanding_exposure_amount | number | The portion of the Disbursed/Shipped Amount that has not been repaid as of the date this data set was generated. | 0 900000 3600000 1350000 2700000 view top 100 |
| Small Business Authorized Amount | small_business_authorized_amount | number | The portion of an approved amount that assisted a small business. | 0 450000 900000 500000 300000 view top 100 |
| Woman Owned Authorized Amount | woman_owned_authorized_amount | number | The portion of an approved amount that assisted a woman owned company. | 0 500000 300000 175000 450000 view top 100 |
| Minority Owned Authorized Amount | minority_owned_authorized_amount | number | The portion of an approved amount that assisted a minority owned company. | 6300000 0 2700000 1350000 900000 view top 100 |
| Loan Interest Rate | loan_interest_rate | text | The interest rate being applied to a Direct Loan. | N/A Floating Rate 3.81 3.92 2.78 view top 100 |
| Multiyear Working Capital Extension | multiyear_working_capital_extension | text | The asterisk (*) indicates that the deal shown is an extension of a previouslyapproved multi-year Working Capital facility. | * view top 100 |