FDIC - Banks In Kentucky

Bank institutions established in Kentucky state

@kaggle.donnetew_fdic_banks_in_kentucky

Table List

1 table(57.08 KB)

Ky Fdic Institutions

@kaggle.donnetew_fdic_banks_in_kentucky.ky_fdic_institutions

57.08 KB
549 rows
21 columns

fdic_certificate_number FDIC Certificate Number	institution Institution	status Status	established_date Established Date	established_year Established Year	last_updated Last Updated	effective_date Effective Date	end_effective_date End Effective Date	regulator Regulator	city City	address Address	bank_charter_class Bank Charter Class	chartering_agency Chartering Agency	county_name County Name	fdic_supervisory_region FDIC Supervisory Region	fed_reserve_district Fed Reserve District	insurance_fund_membership Insurance Fund Membership	state_chartered State Chartered	state_name State Name	fdic_url FDIC URL
11338	1st Independence Bank	Inactive	Tue Jan 01 1907 00:00:00 GMT+0000 (Coordinated Universal Time)	1907	Tue Nov 18 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Nov 15 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Nov 15 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	FDIC	Louisville	8620 Biggin Hill Lane	NM	STATE	Jefferson	Chicago	Chicago	DIF	true	Kentucky	https://banks.data.fdic.gov/bankfind-suite/bankfind/details/11338
57869	1st Trust Bank, Inc.	Active	Mon Dec 13 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	2004	Fri Oct 26 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Oct 16 2018 00:00:00 GMT+0000 (Coordinated Universal Time)		FDIC	Hazard	44 Commerce Drive	NM	STATE	Perry	Chicago	Chicago	DIF	true	Kentucky	https://banks.data.fdic.gov/bankfind-suite/bankfind/details/57869
27948	Acme Federal Savings and Loan Association	Inactive	Wed Jan 01 1908 00:00:00 GMT+0000 (Coordinated Universal Time)	1908	Fri Jul 17 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun May 31 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun May 31 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	OTS	Covington	2040 Madison Ave	SL	OTS	Kenton	Chicago	Chicago	SAIF		Kentucky	https://banks.data.fdic.gov/bankfind-suite/bankfind/details/27948
2730	Adairville Banking Company	Inactive	Fri Jan 01 1886 00:00:00 GMT+0000 (Coordinated Universal Time)	1886	Tue Jul 05 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 10 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 10 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	FDIC	Adairville	Public Square	NM	STATE	Logan	Chicago	Chicago	BIF	true	Kentucky	https://banks.data.fdic.gov/bankfind-suite/bankfind/details/2730
30196	Alliance Bank	Inactive	Tue Jan 01 1935 00:00:00 GMT+0000 (Coordinated Universal Time)	1935	Mon Dec 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 02 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 02 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	FDIC	Somerset	124 North Main St	NM	STATE	Pulaski	Chicago	Dallas	SAIF	true	Kentucky	https://banks.data.fdic.gov/bankfind-suite/bankfind/details/30196
57424	Alliance Banking Company	Inactive	Wed Mar 12 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	2003	Wed Jan 13 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	FDIC	Winchester	695 Bullion Boulevard	NM	STATE	Clark	Chicago	Chicago	DIF	true	Kentucky	https://banks.data.fdic.gov/bankfind-suite/bankfind/details/57424
35568	American Bank & Trust Company, Inc.	Active	Wed Jul 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	2000	Sun Aug 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Aug 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)		FDIC	Bowling Green	531 Lovers Ln	NM	STATE	Warren	Chicago	Chicago	DIF	true	Kentucky	https://banks.data.fdic.gov/bankfind-suite/bankfind/details/35568
31537	American Federal Savings and Loan Association	Inactive	Sat Jan 01 1966 00:00:00 GMT+0000 (Coordinated Universal Time)	1966	Fri Jul 17 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Oct 31 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Oct 31 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	OTS	Somerset	107 So Main St	SL	OTS	Pulaski	Chicago	Chicago	SAIF		Kentucky	https://banks.data.fdic.gov/bankfind-suite/bankfind/details/31537
28006	American Federal Savings and Loan Association of Erlanger	Inactive	Wed Jan 01 1890 00:00:00 GMT+0000 (Coordinated Universal Time)	1890	Fri Jul 17 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Feb 28 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Feb 28 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	OTS	Erlanger	3522 Dixie Highway	SL	OTS	Kenton	Chicago	Chicago	SAIF		Kentucky	https://banks.data.fdic.gov/bankfind-suite/bankfind/details/28006
18362	American Fidelity Bank and Trust Company	Inactive	Sat Mar 25 1961 00:00:00 GMT+0000 (Coordinated Universal Time)	1961	Fri Mar 08 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Feb 29 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Feb 29 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	FDIC	Corbin	U.S. Highway 25e	NM	STATE	Knox	Chicago	Chicago	BIF	true	Kentucky	https://banks.data.fdic.gov/bankfind-suite/bankfind/details/18362


CREATE TABLE ky_fdic_institutions (
  "fdic_certificate_number" BIGINT,
  "institution" VARCHAR,
  "status" VARCHAR,
  "established_date" TIMESTAMP,
  "established_year" BIGINT,
  "last_updated" TIMESTAMP,
  "effective_date" TIMESTAMP,
  "end_effective_date" TIMESTAMP,
  "regulator" VARCHAR,
  "city" VARCHAR,
  "address" VARCHAR,
  "bank_charter_class" VARCHAR,
  "occ_charter" BIGINT,
  "chartering_agency" VARCHAR,
  "county_name" VARCHAR,
  "fdic_supervisory_region" VARCHAR,
  "fed_reserve_district" VARCHAR,
  "insurance_fund_membership" VARCHAR,
  "state_chartered" BOOLEAN,
  "state_name" VARCHAR,
  "fdic_url" VARCHAR
);