Small business loan originations, by county and year, 2010 to 2020

Multi-year CRA disclosures for small business originations, aggregated to county and year

ffiec.gov-cra_disclosure-county-d11-1.3.1. Modified 2022-01-12T22:50:58

Resources

smb_orig_county. Small business loan originations by county

Documentation

Documentation Links

Disclosure File Specifications File specifications for the 2017 Disclosure Flat File
Documentation Page
CRA Data Products
Aggregate & Disclosure Flat Files Links to download the files.

Contacts

Wrangler
Eric Busboom, Civic Knowledge

Data Dictionary

smb_orig_county

Column Name	Data Type	Description
year	integer
geoid	string
respondents	integer
num_orig_bus_lt100k	integer
tot_orig_bus_lt100k	integer
num_orig_bus_lt250k	integer
tot_orig_bus_gt100k_lt250k	integer
num_orig_bus_gt250k_lt1m	integer
tot_orig_bus_gt250k_lt1m	integer
num_orig_bus_lt1m	integer
tot_orig_bus_lt1m	integer
num_orig_bus_al	integer
tot_orig_bus_al	integer

References

Urls used in the creation of this data package.

index:ffiec.gov-cra_disclosure-d11-2.2.1. Source data, CRA small business originations

Packages

s3 s3://library.metatab.org/ffiec.gov-cra_disclosure-county-d11-1.3.1.csv
csv http://library.metatab.org/ffiec.gov-cra_disclosure-county-d11-1.3.1.csv
source https://github.com/metatab-packages/ffiec.gov-cra_disclosure-d11agg.git

Accessing Data in Vanilla Pandas

import pandas as pd


smb_orig_county_df =  pd.read_csv('http://library.metatab.org/ffiec.gov-cra_disclosure-county-d11-1.3.1/data/smb_orig_county.csv')

Accessing Package in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/ffiec.gov-cra_disclosure-county-d11-1.3.1.csv')

# Create Dataframes
smb_orig_county_df = pkg.resource('smb_orig_county').dataframe()