Name: Export Import Bank Of US Authorization Data
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Export Import Bank Of US Authorization Data

Context

DataSet shares the information about approvals based on state and section of society.
With the help of this data set we can find which section or society, industry and state is progressing.

Content

Content of this data has information about amount which was approved , how much was disbursed based on approval.
Further information also includes beneficiary of deal based on industry, state, and sections of society.

Acknowledgements

https://catalog.data.gov/dataset/authorizations-from-10-01-2006-thru-06-30-2018

Inspiration

If there has been pattern of disbursement of amount of amount and how did it help ?
For eg. Florida received most disbursement in agro industry which benefitted most to small business owner.

Tables

Authorizations From 10–01–2006 Thru 3–31–2020

@kaggle.rahulkumar6_export_import_bank_of_us_authorization_data.authorizations_from_10_01_2006_thru_3_31_2020

2.5 MB
42,522 rows
34 columns

CREATE TABLE authorizations_from_10_01_2006_thru_3_31_2020 (
  "fiscal_year" BIGINT,
  "unique_identifier" VARCHAR,
  "deal_number" VARCHAR,
  "decision" VARCHAR,
  "decision_date" VARCHAR,
  "effective_date" TIMESTAMP,
  "expiration_date" VARCHAR,
  "brokered" VARCHAR,
  "deal_cancelled" VARCHAR,
  "country" VARCHAR,
  "program" VARCHAR,
  "policy_type" VARCHAR,
  "decision_authority" VARCHAR,
  "primary_export_product_naics_sic_code" VARCHAR,
  "product_description" VARCHAR,
  "term" VARCHAR,
  "primary_applicant" VARCHAR,
  "primary_lender" VARCHAR,
  "primary_exporter" VARCHAR,
  "primary_exporter_city" VARCHAR,
  "primary_exporter_state_code" VARCHAR,
  "primary_exporter_state_name" VARCHAR,
  "primary_borrower" VARCHAR,
  "primary_source_of_repayment_psor" VARCHAR  -- Primary Source Of Repayment (PSOR),
  "working_capital_delegated_authority" VARCHAR,
  "approved_declined_amount" DOUBLE,
  "disbursed_shipped_amount" DOUBLE,
  "undisbursed_exposure_amount" DOUBLE,
  "outstanding_exposure_amount" DOUBLE,
  "small_business_authorized_amount" DOUBLE,
  "woman_owned_authorized_amount" DOUBLE,
  "minority_owned_authorized_amount" DOUBLE,
  "loan_interest_rate" VARCHAR,
  "multiyear_working_capital_extension" VARCHAR
);