Baselight

Export Import Bank Of US Authorization Data

Export Import Bank of US Authorization Data from 2006 to 2020

@kaggle.rahulkumar6_export_import_bank_of_us_authorization_data

Loading...
Loading...

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.38 MB
  • 42522 rows
  • 34 columns
Loading...

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,
  "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
);

Share link

Anyone who has the link will be able to view this.