SOI Tax Stats - Private Foundations Harmonized Microdata Files (ASCII)


Harmonized Microdata in ASCII Format

This section contains microdata files for all Forms 990-PF sampled for the annual SOI studies of private foundations. The data from each of the annual studies are included in a single, "harmonized" dataset, with standardized element names and codes based on the form revision of the latest available Tax Year. 

The data are contained in ASCII flat files, Microsoft Excel spreadsheets, and Adobe Acrobat PDF. Documentation to assist with the files is included. (Free Adobe Acrobat reader and Microsoft Excel viewer software is available for download, if needed.)

The SOI sample includes returns filed by private foundations, exempt under Internal Revenue Code section 501(c)(3), and section 4947(a)(1) nonexempt charitable trusts. The stratified random samples are based on asset size and represent approximately 10 percent of Forms 990-PF filed; sampling rates of 100 percent are applied to large-asset classes. Microdata records contain most financial information from Forms 990-PF, as well as weights (to estimate the population), for each organization.

Background InformationDOC: Explains all the other files. (Microsoft Word format)

Data Element Reference ListXLS: Record layout for the Form 990-PF study harmonized dataset. (Microsoft Excel format)

Main Data FileZIP: SOI Form 990-PF study data for Tax Years 1985-2018. (ZIP format)

Compensation Data File: SOI Form 990-PF study data, Part VIII compensation data for Tax Years 1993-2018. (ASCII text format)

Explanation of CodesXLS: 2018 SOI Form 990-PF study, editing code reference list. (Microsoft Excel format)

Marked up Form 990-PFPDF: 2018 Form 990-PF, marked with the Name / Element Code. (Adobe Acrobat PDF format)

Form 990-PF InstructionsPDF: 2018 Form 990-PF Filing Instructions. (Adobe Acrobat PDF format)

Unrelated Business Activity CodesPDF: 2018 SOI Form 990-PF study, business code reference list. (Adobe Acrobat PDF format)

Exclusion Code ReferencePDF: 2018 SOI Form 990-PF study, exclusion code reference list for Part XVI-A, Analysis of Income-Producing Activities. (Adobe Acrobat PDF format)