# Table FDIC_Insured_Banks.csv ┌────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐ │ X │ Y │ OBJECTID │ ACQDATE │ ADDRESS │ ADDRESS2 │ BKCLASS │ CBSA │ CBSA_DIV │ CBSA_DIV_FLG │ CBSA_DIV_NO │ CBSA_METRO │ CBSA_METRO_FLG │ CBSA_METRO_NAME │ CBSA_MICRO_FLG │ CBSA_NO │ CERT │ CITY │ COUNTY │ CSA │ CSA_FLG │ CSA_NO │ ESTYMD │ FI_UNINUM │ ID │ LATITUDE │ LONGITUDE │ MAINOFF │ MDI_STATUS_CODE │ MDI_STATUS_DESC │ NAME │ OFFNAME │ OFFNUM │ RUNDATE │ SERVTYPE │ SERVTYPE_DESC │ STALP │ STCNTY │ STNAME │ UNINUM │ ZIP │ ├────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┤ │ ██████ ███████████ ██████ │ ChallangeFDICInsuredBank │ ██████ ▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒ │ fdic_cert_number: String │ █████████ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒ │ institution_class: ChallangeInstitutionClass │ █████████ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒ │ abbreviation: String │ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒ █████████ ▒▒▒▒▒▒ ████████ ████████ │ main_office: ChallangeOffice,Part │ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒ ████████ │ uninum: String │ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒ ██████ │ name: String │ ██████████ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒ ████ ▒▒▒▒▒▒ ██████████████████ ████████ │ office: ChallangeOffice,Part │ ▒▒▒▒▒▒▒▒▒▒ █████████ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒ │ acquired: String │ ▒▒▒▒▒▒▒▒▒▒ ████████████████████ ▒▒▒▒▒▒ ███████████████ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ████████ ▒▒▒▒▒▒▒▒ █████│ address: ChallangeAddress │ ▒▒▒▒▒▒▒▒▒▒ █████████ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ address_line_1: String │ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒ ██████████ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ address_line_2: String │ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒ ██████ ▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ city_name: String │ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒ ████████ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ████████ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ county: ChallangeCounty │ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒ ████████ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ name: String │ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ███████ ▒▒▒▒▒▒▒▒ ████████ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ state: ChallangeState │ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ████████ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ name: String │ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ███████████████████████████████████ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ minority_status: ChallangeMinorityStatus │ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ █████████████████ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ code: String │ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ █████████████████ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ description: String │ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ █████│ zip: String │ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒ ████████ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒ │ established: String │ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ████████ │ location: ChallangeLocation │ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒ ████████████████████████ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒ │ combined_statistical_area: ChallangeCombinedStatisticalArea │ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ████████ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒ │ code: String │ ▒▒▒▒▒▒▒▒▒▒ ██████ ███████████████████████████████████████████████ █████████ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒ │ metropolitan_core_based_statistical_area: ChallangeMetropolitanStatisticalArea │ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒ ████████████ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒ │ code: String │ ▒▒▒▒▒▒▒▒▒▒ ███████████████████████████████████████ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒ │ metropolitan_division_core_based_statistical_area: ChallangeMetropolitanDivisionStatisticalArea │ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ █████████████ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒ │ code: String │ ▒▒▒▒▒▒▒▒▒▒ ██████ ██████████████████████████ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒ │ micropolitan_core_based_statistical_area: ChallangeMicropolitanStatisticalArea │ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ █████████ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒ │ code: String │███████ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ██████████████████████ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒ │ point: ChallangePoint │▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ██████████ ▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒ │ latitude: String │▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ███████████ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒ │ longitude: String │ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒ █████████ ▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒ │ name: String │ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ██████████████████████████ ▒▒▒▒▒▒▒▒ │ service_type: ChallangeServiceType │ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒ ███████████████ ▒▒▒▒▒▒▒▒ │ service_type_description: String │ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ██████████ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒ │ service_type_id: String │ ▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ████████ │ uninum: String │ █████████ │ ChallangeRunDate ## Ontology relations ChallangeCombinedStatisticalArea is contained in http://www.opengis.net/ont/geosparql#SpatialObject https://spec.edmcouncil.org/fibo/ontology/IND/EconomicIndicators/EconomicIndicators/CombinedStatisticalArea ChallangeServiceType is contained in https://www.omg.org/spec/Commons/Organizations/Service ChallangeMinorityStatus is contained in https://www.sensmetry.com/omg_semantic_challange_2025/minority_status ChallangeMicropolitanStatisticalArea is contained in https://spec.edmcouncil.org/fibo/ontology/IND/EconomicIndicators/EconomicIndicators/MicropolitanStatisticalArea http://www.opengis.net/ont/geosparql#SpatialObject ChallangeMetropolitanDivisionStatisticalArea is contained in https://www.sensmetry.com/omg_semantic_challange_2025/cbsa_div http://www.opengis.net/ont/geosparql#SpatialObject ChallangeState is contained in https://www.omg.org/spec/Commons/Locations/State ChallangeFDICInsuredBank is contained in https://spec.edmcouncil.org/fibo/ontology/FBC/FunctionalEntities/FinancialServicesEntities/Bank ChallangeAddress is contained in https://spec.edmcouncil.org/fibo/ontology/FND/Places/Addresses/ConventionalStreetAddress ChallangeOffice is contained in https://spec.edmcouncil.org/fibo/ontology/FND/Places/Addresses/Office ChallangePoint is contained in http://www.opengis.net/ont/sf#Point ChallangeInstitutionClass is contained in https://www.sensmetry.com/omg_semantic_challange_2025/institution_class ChallangeMetropolitanStatisticalArea is contained in https://spec.edmcouncil.org/fibo/ontology/IND/EconomicIndicators/EconomicIndicators/MetropolitanStatisticalArea http://www.opengis.net/ont/geosparql#SpatialObject ChallangeLocation is contained in http://www.opengis.net/ont/geosparql#SpatialObject ChallangeCounty is contained in https://www.omg.org/spec/Commons/Locations/County address_line_2 specialises https://spec.edmcouncil.org/fibo/ontology/FND/Places/Addresses/hasAddressLine2 description specialises http://www.w3.org/2000/01/rdf-schema#comment micropolitan_core_based_statistical_area specialises http://www.opengis.net/ont/geosparql#ehInside has range in https://spec.edmcouncil.org/fibo/ontology/IND/EconomicIndicators/EconomicIndicators/MicropolitanStatisticalArea http://www.opengis.net/ont/geosparql#SpatialObject metropolitan_core_based_statistical_area specialises http://www.opengis.net/ont/geosparql#ehInside has range in https://spec.edmcouncil.org/fibo/ontology/IND/EconomicIndicators/EconomicIndicators/MetropolitanStatisticalArea http://www.opengis.net/ont/geosparql#SpatialObject state specialises https://www.omg.org/spec/Commons/Collections/hasPart has range in https://www.omg.org/spec/Commons/Locations/State name specialises https://www.omg.org/spec/Commons/Designators/hasTextualName location specialises http://purl.org/dc/terms/location has range in http://www.opengis.net/ont/geosparql#SpatialObject name specialises https://www.omg.org/spec/Commons/Designators/hasTextualName zip specialises https://spec.edmcouncil.org/fibo/ontology/FND/Places/Addresses/hasPostalCode office specialises https://www.omg.org/spec/Commons/Collections/hasPart has range in https://spec.edmcouncil.org/fibo/ontology/FND/Places/Addresses/Office https://spec.edmcouncil.org/fibo/ontology/BE/LegalEntities/FormalBusinessOrganizations/Branch county specialises https://www.omg.org/spec/Commons/Locations/hasCounty has range in https://www.omg.org/spec/Commons/Locations/County code specialises https://www.omg.org/spec/Commons/Identifiers/isIdentifiedBy code specialises https://www.omg.org/spec/Commons/Identifiers/isIdentifiedBy code specialises https://www.omg.org/spec/Commons/Identifiers/isIdentifiedBy main_office specialises https://www.sensmetry.com/omg_semantic_challange_2025/has_main_office https://www.omg.org/spec/Commons/Collections/hasPart has range in https://spec.edmcouncil.org/fibo/ontology/FND/Places/Addresses/Office https://spec.edmcouncil.org/fibo/ontology/BE/LegalEntities/FormalBusinessOrganizations/Branch name specialises https://schema.org/name latitude specialises http://www.w3.org/2003/01/geo/wgs84_pos#lat longitude specialises http://www.w3.org/2003/01/geo/wgs84_pos#long combined_statistical_area specialises http://www.opengis.net/ont/geosparql#ehInside has range in http://www.opengis.net/ont/geosparql#SpatialObject https://spec.edmcouncil.org/fibo/ontology/IND/EconomicIndicators/EconomicIndicators/CombinedStatisticalArea address specialises https://spec.edmcouncil.org/fibo/ontology/BE/LegalEntities/FormalBusinessOrganizations/hasRegisteredAddress has range in https://spec.edmcouncil.org/fibo/ontology/FND/Places/Addresses/ConventionalStreetAddress service_type_description specialises http://www.w3.org/2000/01/rdf-schema#comment address_line_1 specialises https://spec.edmcouncil.org/fibo/ontology/FND/Places/Addresses/hasAddressLine1 code specialises https://www.omg.org/spec/Commons/Identifiers/isIdentifiedBy name specialises https://schema.org/name point specialises http://w3.org/ns/locn#geometry has range in http://www.opengis.net/ont/sf#Point city_name specialises https://www.omg.org/spec/Commons/Locations/hasCityName minority_status has range in https://www.sensmetry.com/omg_semantic_challange_2025/minority_status metropolitan_division_core_based_statistical_area specialises http://www.opengis.net/ont/geosparql#ehInside has range in https://www.sensmetry.com/omg_semantic_challange_2025/cbsa_div http://www.opengis.net/ont/geosparql#SpatialObject service_type specialises https://www.omg.org/spec/Commons/Organizations/provides has range in https://www.omg.org/spec/Commons/Organizations/Service institution_class specialises https://www.sensmetry.com/omg_semantic_challange_2025/has_institution_class has range in https://www.sensmetry.com/omg_semantic_challange_2025/institution_class