FDIC - Banks In Washington State

Bank institutions established in Washington state

@kaggle.donnetew_fdic_banks_in_washington_state_17822020

Table List

1 table(40.65 KB)

Wa Fdic Institutions

@kaggle.donnetew_fdic_banks_in_washington_state_17822020.wa_fdic_institutions

40.65 KB
313 rows
20 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	occ_charter OCC Charter	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	fdic_url FDIC URL
57633	1st Security Bank of Washington	Active	Thu Apr 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	2004	Mon Nov 19 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Nov 15 2018 00:00:00 GMT+0000 (Coordinated Universal Time)		FDIC	Mountlake Terrace	6920 220th Street Sw, Suite 300	SI		STATE	Snohomish	San Francisco	San Francisco	DIF	true	https://banks.data.fdic.gov/bankfind-suite/bankfind/details/57633
19465	American Commercial Bank	Inactive	Mon Aug 02 1965 00:00:00 GMT+0000 (Coordinated Universal Time)	1965	Thu Oct 04 1990 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	FDIC	Spokane	North 120 Wall Street	NM		STATE	Spokane	San Francisco	San Francisco	BIF	true	https://banks.data.fdic.gov/bankfind-suite/bankfind/details/19465
28680	American Federal Savings and Loan Association	Inactive	Sat Jan 01 1921 00:00:00 GMT+0000 (Coordinated Universal Time)	1921	Fri Jul 17 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 31 1983 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 31 1983 00:00:00 GMT+0000 (Coordinated Universal Time)	OTS	Tacoma	960 Pacific Avenue	SL		OTS	Pierce	San Francisco	San Francisco	SAIF		https://banks.data.fdic.gov/bankfind-suite/bankfind/details/28680
25711	American First National Bank	Inactive	Mon Sep 17 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	1984	Tue Sep 02 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Aug 01 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Aug 01 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	OCC	Everett	6920 Evergreen Way	N	18404	OCC	Snohomish	San Francisco	San Francisco	BIF		https://banks.data.fdic.gov/bankfind-suite/bankfind/details/25711
16730	American Marine Bank	Inactive	Fri Sep 17 1948 00:00:00 GMT+0000 (Coordinated Universal Time)	1948	Mon Feb 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 29 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 29 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	FDIC	Bainbridge Island	249 Winslow Way East	NM		STATE	Kitsap	San Francisco	San Francisco	DIF	true	https://banks.data.fdic.gov/bankfind-suite/bankfind/details/16730
19168	American National Bank of Edmonds	Inactive	Sat Jul 11 1964 00:00:00 GMT+0000 (Coordinated Universal Time)	1964	Thu Oct 04 1990 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Nov 13 1975 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Nov 13 1975 00:00:00 GMT+0000 (Coordinated Universal Time)	OCC	Edmonds	140 Fourth Avenue South	N	15351	OCC	Snohomish	San Francisco	San Francisco	BIF		https://banks.data.fdic.gov/bankfind-suite/bankfind/details/19168
27159	American Savings Bank	Inactive	Mon Jun 19 1899 00:00:00 GMT+0000 (Coordinated Universal Time)	1899	Mon Mar 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Dec 02 1989 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Dec 02 1989 00:00:00 GMT+0000 (Coordinated Universal Time)	FDIC	Tacoma	101 South Ninth Street	SI		STATE	Pierce	San Francisco	San Francisco	BIF	true	https://banks.data.fdic.gov/bankfind-suite/bankfind/details/27159
22441	AmericanWest Bank	Inactive	Fri Apr 01 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	1977	Wed Oct 14 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	FDIC	Spokane	41 W. Riverside Avenue, Suite 400	NM		STATE	Spokane	San Francisco	San Francisco	DIF	true	https://banks.data.fdic.gov/bankfind-suite/bankfind/details/22441
27531	AmericanWest Bank, National Association	Inactive	Thu Jun 15 1989 00:00:00 GMT+0000 (Coordinated Universal Time)	1989	Thu Jan 31 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Dec 01 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Dec 01 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	OCC	Ephrata	261 Basin Southwest Street	N	21728	OCC	Grant	San Francisco	San Francisco	BIF		https://banks.data.fdic.gov/bankfind-suite/bankfind/details/27531
28454	Anchor Bank	Inactive	Tue Jan 01 1907 00:00:00 GMT+0000 (Coordinated Universal Time)	1907	Mon Nov 19 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Nov 15 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Nov 15 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	FDIC	Aberdeen	120 North Broadway	SI		STATE	Grays Harbor	San Francisco	San Francisco	DIF	true	https://banks.data.fdic.gov/bankfind-suite/bankfind/details/28454


CREATE TABLE wa_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,
  "fdic_url" VARCHAR
);