BMF Pipeline Quality Report

Post-Transformation Validation Results

Published

May 6, 2026

Executive Summary

Overall Status: PASSED

Pipeline Timestamp: 2026-05-06 16:11:17

Metric	Value
Total Records	1,441,957
Output Columns	110
Overall Completeness	63.9%
Row Preservation	Passed
Unique EINs	1,441,957
Duplicate EINs	0

Field Completeness by Category

This section shows the completeness of each output field, grouped by category. Each field shows its source column(s) from the raw BMF file.

Identity

Average Completeness: 100.0% | Columns: 2

Field	Source	Completeness	Status	Null Count
ein	EIN	100.0%	Good	0
ein_raw	EIN	100.0%	Good	0

Column Descriptions:

ein: Employer Identification Number formatted as XX-XXXXXXX
ein_raw: Original 9-digit EIN value from source file without formatting

Organization Name

Average Completeness: 68.1% | Columns: 5

Field	Source	Completeness	Status	Null Count
org_name_raw	NAME	100.0%	Good	0
org_name_join	NAME	100.0%	Good	0
org_name_display	NAME	100.0%	Good	0
org_legal_suffix	NAME	36.0%	Low	923,223
org_parent_name	NAME	4.4%	Low	1,377,986

Column Descriptions:

org_name_raw: Original organization name exactly as it appears in the source file
org_name_join: Standardized name for matching and joining (uppercase, punctuation removed)
org_name_display: Title-cased organization name suitable for display purposes
org_legal_suffix: Legal entity suffix extracted from name (Inc, Corp, LLC, Foundation, etc.)
org_parent_name: Parent organization name if this is a subordinate/chapter organization

DBA Name

Average Completeness: 30.8% | Columns: 2

Field	Source	Completeness	Status	Null Count
dba_name	SORT_NAME	30.8%	Low	998,016
dba_name_raw	SORT_NAME	30.8%	Low	998,016

Column Descriptions:

dba_name: Cleaned ‘Doing Business As’ name
dba_name_raw: Original secondary/DBA name from source file

In Care Of

Average Completeness: 33.3% | Columns: 3

Field	Source	Completeness	Status	Null Count
in_care_of_name_raw	ICO	0.0%	Low	1,441,957
in_care_of_name_clean	ICO	0.0%	Low	1,441,957
in_care_of_name_provided	ICO	100.0%	Good	0

Column Descriptions:

in_care_of_name_raw: Original ‘In Care Of’ field from source file
in_care_of_name_clean: Cleaned ICO name with standardized formatting
in_care_of_name_provided: Boolean indicating whether an ICO name was provided

Group Exemption

Average Completeness: 100.0% | Columns: 3

Field	Source	Completeness	Status
group_exemption_number_raw	GROUP	100.0%	Good
group_exemption_number	GROUP	100.0%	Good
group_exemption_is_member	GROUP	100.0%	Good

Column Descriptions:

group_exemption_number_raw: Original group exemption number from source file
group_exemption_number: Cleaned group exemption number (GEN)
group_exemption_is_member: Boolean indicating if organization is a member of a group exemption

Address (Raw)

Average Completeness: 75.0% | Columns: 4

Field	Source	Completeness	Status	Null Count
org_addr_street_raw	STREET	0.0%	Low	1,441,957
org_addr_city_raw	CITY	100.0%	Good	0
org_addr_state_raw	STATE	100.0%	Good	0
org_addr_zip_raw	ZIP	100.0%	Good	0

Column Descriptions:

org_addr_street_raw: Original street address from source file
org_addr_city_raw: Original city name from source file
org_addr_state_raw: Original state code from source file
org_addr_zip_raw: Original ZIP code from source file

Address (Cleaned)

Average Completeness: 68.9% | Columns: 7

Field	Source	Completeness	Status	Null Count
org_addr_street	STREET	0.0%	Low	1,441,957
org_addr_city	CITY	100.0%	Good	0
org_addr_state	STATE	99.9%	Good	1,158
org_addr_zip5	ZIP	91.3%	Fair	125,556
org_addr_zip4	ZIP	0.0%	Low	1,441,957
org_addr_zip	ZIP	91.3%	Fair	125,556
org_addr_full	STREET, CITY, STATE, ZIP	100.0%	Good	0

Column Descriptions:

org_addr_street: Standardized street address with USPS abbreviations
org_addr_city: Cleaned city name
org_addr_state: Two-letter state abbreviation
org_addr_zip5: 5-digit ZIP code
org_addr_zip4: 4-digit ZIP code extension (if available)
org_addr_zip: Full ZIP code (5 or 9 digits)
org_addr_full: Complete formatted address string

Address Quality Flags

Average Completeness: 100.0% | Columns: 6

Field	Source	Completeness	Status
org_addr_is_missing	STREET, CITY, STATE, ZIP	100.0%	Good
org_addr_is_po_box	STREET	100.0%	Good
org_addr_is_rural_route	STREET	100.0%	Good
org_addr_has_special_chars	STREET	100.0%	Good
org_addr_missing_number	STREET	100.0%	Good
org_addr_state_invalid	STATE	100.0%	Good

Column Descriptions:

org_addr_is_missing: TRUE if street address is missing or empty
org_addr_is_po_box: TRUE if address is a P.O. Box
org_addr_is_rural_route: TRUE if address is a rural route
org_addr_has_special_chars: TRUE if address contains unusual special characters
org_addr_missing_number: TRUE if street address lacks a street number
org_addr_state_invalid: TRUE if state code is not a valid US state/territory

Classification

Average Completeness: 50.0% | Columns: 4

Field	Source	Completeness	Status	Null Count
subsection_code	SUBSECTION	100.0%	Good	0
classification_code	CLASSIFICATION	0.0%	Low	1,441,957
exempt_organization_type	SUBSECTION	100.0%	Good	36
all_classifications_string	CLASSIFICATION	0.0%	Low	1,441,957

Column Descriptions:

subsection_code: IRS subsection code (e.g., 03 for 501(c)(3), 04 for 501(c)(4))
classification_code: IRS classification code indicating organization type within subsection
exempt_organization_type: Human-readable exempt organization type based on subsection
all_classifications_string: Semicolon-separated list of all classification descriptions

Organization Codes

Average Completeness: 27.3% | Columns: 11

Field	Source	Completeness	Status	Null Count
affiliation_code	AFFILIATION	0.0%	Low	1,441,957
affiliation_code_definition	AFFILIATION	0.0%	Low	1,441,957
deductibility_code	DEDUCTIBILITY	0.0%	Low	1,441,957
deductibility_code_definition	DEDUCTIBILITY	0.0%	Low	1,441,957
foundation_code	FOUNDATION	100.0%	Good	0
foundation_code_definition	FOUNDATION	100.0%	Good	1
organization_code	ORGANIZATION	0.0%	Low	1,441,957
organization_code_definition	ORGANIZATION	0.0%	Low	1,441,957
status_code	STATUS	0.0%	Low	1,441,957
status_code_definition	STATUS	0.0%	Low	1,441,957
naics_code	NTEE_CD	100.0%	Good	0

Column Descriptions:

affiliation_code: Code indicating relationship to parent organization (1-9)
affiliation_code_definition: Description of affiliation relationship
deductibility_code: Code indicating deductibility status of contributions (1-4)
deductibility_code_definition: Description of contribution deductibility
foundation_code: Foundation status code (00-99) per IRS determination
foundation_code_definition: Description of foundation/public charity status
organization_code: Code for type of organization (corporation, trust, etc.)
organization_code_definition: Description of organization type
status_code: IRS determination status code (01-99)
status_code_definition: Description of exempt status
naics_code: North American Industry Classification System code derived from NTEE

Dates

Average Completeness: 97.0% | Columns: 7

Field	Source	Completeness	Status	Null Count
ruling_date_ym_str	RULING	100.0%	Good	0
ruling_date	RULING	100.0%	Good	0
ruling_date_is_missing	RULING	100.0%	Good	0
tax_period_ym_str	TAX_PERIOD	79.3%	Fair	299,020
tax_period_ymd	TAX_PERIOD	100.0%	Good	0
tax_period_is_missing	TAX_PERIOD	100.0%	Good	0
accounting_period	ACCT_PD	100.0%	Good	0

Column Descriptions:

ruling_date_ym_str: Ruling date as YYYYMM string
ruling_date: Date of IRS ruling granting exempt status
ruling_date_is_missing: TRUE if ruling date is missing or invalid
tax_period_ym_str: Tax period end date as YYYYMM string
tax_period_ymd: Tax period end date in YYYY-MM-DD format
tax_period_is_missing: TRUE if tax period is missing
accounting_period: Month when organization’s accounting period ends (01-12)

Financial Codes

Average Completeness: 0.0% | Columns: 4

Field	Source	Completeness	Status	Null Count
asset_code	ASSET_CD	0.0%	Low	1,441,957
asset_code_definition	ASSET_CD	0.0%	Low	1,441,957
income_code	INCOME_CD	0.0%	Low	1,441,957
income_code_definition	INCOME_CD	0.0%	Low	1,441,957

Column Descriptions:

asset_code: Asset amount range code (0-9)
asset_code_definition: Description of asset range (e.g., ‘$100,000 to $499,999’)
income_code: Income amount range code (0-9)
income_code_definition: Description of income range

Financial Amounts

Average Completeness: 93.0% | Columns: 3

Field	Source	Completeness	Status	Null Count
asset_amount	ASSET_AMT	100.0%	Good	0
income_amount	INCOME_AMT	100.0%	Good	0
revenue_amount	REVENUE_AMT	79.1%	Fair	301,212

Column Descriptions:

asset_amount: Total assets in dollars (most recent return)
income_amount: Total income in dollars (can be negative)
revenue_amount: Total revenue in dollars (can be negative)

Activity

Average Completeness: 0.0% | Columns: 3

Field	Source	Completeness	Status	Null Count
activity_code	ACTIVITY	0.0%	Low	1,441,957
activity_code_definitions	ACTIVITY	0.0%	Low	1,441,957
activity_code_categories	ACTIVITY	0.0%	Low	1,441,957

Column Descriptions:

activity_code: Three 3-digit activity codes concatenated (9 characters total)
activity_code_definitions: Semicolon-separated descriptions of activity codes
activity_code_categories: Semicolon-separated activity categories

Filing Requirements

Average Completeness: 26.9% | Columns: 4

Field	Source	Completeness	Status	Null Count
filing_requirement_code	FILING_REQ_CD	100.0%	Good	0
filing_requirement_code_definition	FILING_REQ_CD	7.8%	Low	1,330,247
pf_filing_requirement_code	PF_FILING_REQ_CD	0.0%	Low	1,441,957
pf_filing_requirement_code_definition	PF_FILING_REQ_CD	0.0%	Low	1,441,957

Column Descriptions:

filing_requirement_code: Code indicating required annual return form (0-6)
filing_requirement_code_definition: Description of filing requirement (990, 990-EZ, 990-N, etc.)
pf_filing_requirement_code: Private foundation filing requirement code
pf_filing_requirement_code_definition: Description of private foundation filing requirement

NTEE Codes

Average Completeness: 100.0% | Columns: 6

Field	Source	Completeness	Status	Null Count
ntee_code_raw	NTEE_CD	100.0%	Good	22
ntee_code_clean	NTEE_CD	100.0%	Good	0
ntee_code_definition	NTEE_CD	100.0%	Good	0
ntee_code_major_group	NTEE_CD	100.0%	Good	0
ntee_common_code	NTEE_CD	100.0%	Good	0
ntee_common_code_definition	NTEE_CD	100.0%	Good	0

Column Descriptions:

ntee_code_raw: Original NTEE code from source file (1-4 characters)
ntee_code_clean: Standardized 3-character NTEE code
ntee_code_definition: Full description of NTEE classification
ntee_code_major_group: NTEE major group letter (A-Z) indicating broad category
ntee_common_code: Common code suffix for 4-character NTEE codes (e.g., 01-99)
ntee_common_code_definition: Description of common code suffix

NTEE V2 Codes

Average Completeness: 100.0% | Columns: 5

Field	Source	Completeness	Status
nteev2	NTEE_CD	100.0%	Good
nteev2_code	NTEE_CD	100.0%	Good
nteev2_subsector	NTEE_CD	100.0%	Good
nteev2_subsector_definition	NTEE_CD	100.0%	Good
nteev2_org_type	NTEE_CD	100.0%	Good

Column Descriptions:

nteev2: Full NTEEv2 code in SUBSECTOR-CODE-TYPE format
nteev2_code: NTEEv2 code portion (3 characters)
nteev2_subsector: NTEEv2 subsector code (e.g., UNI, HOS, ART, ENV)
nteev2_subsector_definition: Human-readable name of the NTEEv2 subsector (e.g., ‘Human Services’, ‘Public, Societal Benefit’)
nteev2_org_type: NTEEv2 organization type (RG=Regular, AA=Alliance, etc.)

Organization Distribution

Exempt Organization Type

Distribution of organizations by exempt organization type (based on IRS subsection code).

Exempt Organization Type	Count	Percentage
501(c)(3)	1,059,911	73.51%
501(c)(4)	87,040	6.04%
501(c)(6)	64,123	4.45%
501(c)(8)	50,736	3.52%
501(c)(7)	47,240	3.28%
501(c)(5)	46,887	3.25%
501(c)(19)	32,369	2.24%
501(c)(10)	15,545	1.08%
501(c)(13)	8,177	0.57%
4947(a)(1)	8,084	0.56%
501(c)(9)	7,168	0.50%
501(c)(12)	5,202	0.36%
501(c)(2)	4,583	0.32%
501(c)(14)	2,489	0.17%
501(c)(15)	850	0.06%
501(c)(25)	825	0.06%
501(c)(1)	238	0.02%
501(d)	218	0.02%
501(c)(17)	130	0.01%
NA	36	0.00%
501(c)(21)	28	0.00%
501(c)(16)	14	0.00%
82	13	0.00%
501(c)(26)	11	0.00%
501(e)	10	0.00%
501(c)(27)	9	0.00%
501(c)(11)	7	0.00%
501(c)(20)	5	0.00%
501(c)(23)	3	0.00%
501(c)(18)	2	0.00%
529	1	0.00%
501(n)	1	0.00%
501(c)(24)	1	0.00%
501(f)	1	0.00%

NTEE Major Group Distribution

Distribution of organizations by NTEE major group code.

NTEE Major Group	Count	Percentage
Religion-Related	231,989	16.09%
Education	191,327	13.27%
Community Improvement and Capacity Building	121,732	8.44%
Recreation and Sports	117,933	8.18%
Arts, Culture and Humanities	107,305	7.44%
Philanthropy, Voluntarism and Grantmaking Foundations	105,322	7.30%
Human Services	88,372	6.13%
Mutual and Membership Benefit	67,091	4.65%
Public and Societal Benefit	66,673	4.62%
Health Care	41,717	2.89%
Environment	33,481	2.32%
Employment	32,796	2.27%
Housing and Shelter	32,507	2.25%
Voluntary Health Associations and Medical Disciplines	26,977	1.87%
Youth Development	23,099	1.60%
Animal-Related	21,486	1.49%
Public Safety, Disaster Preparedness and Relief	20,804	1.44%
Crime and Legal-Related	19,545	1.36%
International, Foreign Affairs and National Security	19,442	1.35%
Mental Health and Crisis Intervention	16,076	1.11%
Food, Agriculture and Nutrition	15,654	1.09%
Unknown	11,868	0.82%
Science and Technology	10,402	0.72%
Civil Rights, Societal Action and Advocacy	9,257	0.64%
Medical Research	4,041	0.28%
UNDEFINED	2,697	0.19%
Social Science	2,364	0.16%

Financial Summary

Metric	Value
Total Assets (all organizations)	$4,645,182,420,212
Median Assets	$0
Organizations with Asset Data	1,441,957
Organizations with Zero Assets	828,312
Total Income	$3,362,309,737,800
Median Income	$0
Total Revenue	$2,112,991,977,086
Median Revenue	$4,694

Address Quality

Address Issue	Count	% of Total
Missing Address	1,441,957	100.00%
P.O. Box Addresses	0	0.00%
Rural Route Addresses	0	0.00%
Invalid State Code	1,158	0.08%

Date Coverage

Ruling Date Range

Metric	Value
Earliest Ruling Date	1900-02-01
Latest Ruling Date	2012-02-01
Organizations with Ruling Date	1,424,640

Tax Period Year Distribution

Tax Year	Count	Percentage
2010	691,609	60.51%
2011	295,790	25.88%
2009	117,264	10.26%
2008	31,177	2.73%
2007	2,687	0.24%
2006	1,371	0.12%
2005	444	0.04%
2003	406	0.04%
2004	366	0.03%
2002	301	0.03%
2001	279	0.02%
2000	222	0.02%
1998	193	0.02%
2012	192	0.02%
1999	183	0.02%
1997	164	0.01%
1996	159	0.01%
1995	62	0.01%
1994	23	0.00%
1993	13	0.00%
1992	9	0.00%
1990	6	0.00%
1983	4	0.00%
1989	3	0.00%
1991	3	0.00%
1987	2	0.00%
1988	2	0.00%
1986	1	0.00%
1984	1	0.00%
1979	1	0.00%

Data Issues

No Data Issues Detected

All expected columns are present and no critical field issues were found.

Report Metadata

Property	Value
Report Generated	2026-05-06 16:12:14
Pipeline Timestamp	2026-05-06 16:11:17
Row Preservation Check	Passed
Overall Completeness	63.9%
Overall Result	PASSED

Generated by BMF Pipeline Quality System