Core Data Catalog

The NCCS Core Data Series is a panel of nonprofit organizations derived from annual IRS Form 990 filings. This catalog organizes the published files by processing tier — pick the tier that matches your time-span and analytic needs, then drill into a form type within it.

For background on what the Core Series contains and its scope limitations, see the Core overview page.

NoteFiles are organized by tax year, not filing year

Every year label in this catalog refers to the tax year covered by the return — the fiscal period the filing describes — not the calendar year the IRS received it. A nonprofit’s 2022 tax-year return is in the 2022 directory regardless of when it was actually filed (typically 6–18 months later). Recent tax years are still in-progress as the IRS continues to release returns over time.

Which tier should I use?

The Core Series is now published in three tiers. Most analysts should default to the merged panel; the SOI-current and legacy tiers expose the underlying per-pipeline sources for cases where the merged dedup is too aggressive.

Tier	Coverage	Forms	When to use
Merged panel — jump ↓	1987–2024	990combined, 990pf	Default for most analysts. One row per (ein, tax_period) across the full historical record. SOI takes precedence on overlap years.
SOI-current — jump ↓	2012–2024	990, 990ez, 990combined, 990pf	When you need the long-form 990 or 990-EZ standalone variable sets, or every filing including amendments (use the is_amendment flag).
Legacy — jump ↓	1987–2011	990combined, 990pf	Pre-SOI-era filings, harmonized from the historical NCCS CORE files. Includes all rows from the source files without dedup.

WarningMerged-panel dedup caveat

The merged panel is deliberately one row per (ein, tax_period), keeping the first occurrence on each side with SOI-current taking precedence over legacy. It is not a complete revision history. Analysts who need every original filing plus amendments should use:

• SOI-current — carries the is_amendment flag; filter is_amendment == FALSE for originals only.
• Legacy — raw harmonized legacy with no dedup, includes every row from the source files.

See legacy harmonization & merge semantics in the pipeline guide for SOI-precedence rules and the disagreement audit.

---

Merged Panel

Default analyst-facing tier. Column-merge of the legacy and SOI-current panels on (ein, tax_period), one row per filer-period. SOI-current values take precedence; legacy contributes columns where it has them and SOI does not. Includes two tag columns:

• source_pipeline — "legacy" or "soi_current", indicates which side a row came from.
• has_legacy_augment — TRUE iff legacy contributed columns to a SOI row at merge time (overlap row).

990 Combined — merged

Stacked 990 + 990-EZ filers on the 53-column shared variable subset, spanning 1987–2024.

Year	Data	Dictionary	Quality Report	Size
2024	CSV · Parquet	CSV · Parquet	Quality report	17.2 mb
2023	CSV · Parquet	CSV · Parquet	Quality report	120.9 mb
2022	CSV · Parquet	CSV · Parquet	Quality report	123.2 mb
2021	CSV · Parquet	CSV · Parquet	Quality report	119.8 mb
2020	CSV · Parquet	CSV · Parquet	Quality report	122.4 mb

Show all years (merged 990combined)

Year	Data	Dictionary	Quality Report	Size
2024	CSV · Parquet	CSV · Parquet	Quality report	17.2 mb
2023	CSV · Parquet	CSV · Parquet	Quality report	120.9 mb
2022	CSV · Parquet	CSV · Parquet	Quality report	123.2 mb
2021	CSV · Parquet	CSV · Parquet	Quality report	119.8 mb
2020	CSV · Parquet	CSV · Parquet	Quality report	122.4 mb
2019	CSV · Parquet	CSV · Parquet	Quality report	123.9 mb
2018	CSV · Parquet	CSV · Parquet	Quality report	123.7 mb
2017	CSV · Parquet	CSV · Parquet	Quality report	123 mb
2016	CSV · Parquet	CSV · Parquet	Quality report	122.4 mb
2015	CSV · Parquet	CSV · Parquet	Quality report	121.9 mb
2014	CSV · Parquet	CSV · Parquet	Quality report	120.1 mb
2013	CSV · Parquet	CSV · Parquet	Quality report	117.8 mb
2012	CSV · Parquet	CSV · Parquet	Quality report	112.8 mb
2011	CSV · Parquet	CSV · Parquet	Quality report	138.8 mb
2010	CSV · Parquet	CSV · Parquet	Quality report	143.7 mb
2009	CSV · Parquet	CSV · Parquet	Quality report	142.8 mb
2008	CSV · Parquet	CSV · Parquet	Quality report	142.9 mb
2007	CSV · Parquet	CSV · Parquet	Quality report	145.7 mb
2006	CSV · Parquet	CSV · Parquet	Quality report	140.5 mb
2005	CSV · Parquet	CSV · Parquet	Quality report	137 mb
2004	CSV · Parquet	CSV · Parquet	Quality report	133.3 mb
2003	CSV · Parquet	CSV · Parquet	Quality report	129.4 mb
2002	CSV · Parquet	CSV · Parquet	Quality report	122 mb
2001	CSV · Parquet	CSV · Parquet	Quality report	119.9 mb
2000	CSV · Parquet	CSV · Parquet	Quality report	110.9 mb
1999	CSV · Parquet	CSV · Parquet	Quality report	65.9 mb
1998	CSV · Parquet	CSV · Parquet	Quality report	109.8 mb
1997	CSV · Parquet	CSV · Parquet	Quality report	92.7 mb
1996	CSV · Parquet	CSV · Parquet	Quality report	88 mb
1995	CSV · Parquet	CSV · Parquet	Quality report	86.7 mb
1994	CSV · Parquet	CSV · Parquet	Quality report	83.3 mb
1993	CSV · Parquet	CSV · Parquet	Quality report	81.5 mb
1992	CSV · Parquet	CSV · Parquet	Quality report	79.7 mb
1991	CSV · Parquet	CSV · Parquet	Quality report	79 mb
1990	CSV · Parquet	CSV · Parquet	Quality report	75.1 mb
1989	CSV · Parquet	CSV · Parquet	Quality report	57.8 mb
1988	CSV · Parquet	CSV · Parquet	Quality report	12.5 mb
1987	CSV · Parquet	CSV · Parquet	Quality report	7.3 mb

990PF — merged

Private foundations, 1987–2024. Tax years 1993 and 2017–2019 are striped: those partitions exist but are mostly empty (see Known coverage gaps below).

Year	Data	Dictionary	Quality Report	Size
2024	CSV · Parquet	CSV · Parquet	Quality report	7.5 mb
2023	CSV · Parquet	CSV · Parquet	Quality report	82.4 mb
2022	CSV · Parquet	CSV · Parquet	Quality report	83.7 mb
2021	CSV · Parquet	CSV · Parquet	Quality report	82.1 mb
2020	CSV · Parquet	CSV · Parquet	Quality report	80.6 mb

Show all years (merged 990pf)

Year	Data	Dictionary	Quality Report	Size
2024	CSV · Parquet	CSV · Parquet	Quality report	7.5 mb
2023	CSV · Parquet	CSV · Parquet	Quality report	82.4 mb
2022	CSV · Parquet	CSV · Parquet	Quality report	83.7 mb
2021	CSV · Parquet	CSV · Parquet	Quality report	82.1 mb
2020	CSV · Parquet	CSV · Parquet	Quality report	80.6 mb
2019	CSV · Parquet	CSV · Parquet	Quality report	72.3 mb
2018	CSV · Parquet	CSV · Parquet	Quality report	2.3 mb
2017	CSV · Parquet	CSV · Parquet	Quality report	0.5 mb
2016	CSV · Parquet	CSV · Parquet	Quality report	8.6 mb
2015	CSV · Parquet	CSV · Parquet	Quality report	72.7 mb
2014	CSV · Parquet	CSV · Parquet	Quality report	73.5 mb
2013	CSV · Parquet	CSV · Parquet	Quality report	71.6 mb
2012	CSV · Parquet	CSV · Parquet	Quality report	68.7 mb
2011	CSV · Parquet	CSV · Parquet	Quality report	40.1 mb
2010	CSV · Parquet	CSV · Parquet	Quality report	41.5 mb
2009	CSV · Parquet	CSV · Parquet	Quality report	40.9 mb
2008	CSV · Parquet	CSV · Parquet	Quality report	38.6 mb
2007	CSV · Parquet	CSV · Parquet	Quality report	37.1 mb
2006	CSV · Parquet	CSV · Parquet	Quality report	35.8 mb
2005	CSV · Parquet	CSV · Parquet	Quality report	36 mb
2004	CSV · Parquet	CSV · Parquet	Quality report	34 mb
2003	CSV · Parquet	CSV · Parquet	Quality report	33 mb
2002	CSV · Parquet	CSV · Parquet	Quality report	31.3 mb
2001	CSV · Parquet	CSV · Parquet	Quality report	29.3 mb
2000	CSV · Parquet	CSV · Parquet	Quality report	28.9 mb
1999	CSV · Parquet	CSV · Parquet	Quality report	26.1 mb
1998	CSV · Parquet	CSV · Parquet	Quality report	26.7 mb
1997	CSV · Parquet	CSV · Parquet	Quality report	23.3 mb
1996	CSV · Parquet	CSV · Parquet	Quality report	17.4 mb
1995	CSV · Parquet	CSV · Parquet	Quality report	16.1 mb
1994	CSV · Parquet	CSV · Parquet	Quality report	13.7 mb
1993	CSV · Parquet	CSV · Parquet	Quality report	3.8 mb
1992	CSV · Parquet	CSV · Parquet	Quality report	14.3 mb
1991	CSV · Parquet	CSV · Parquet	Quality report	13.6 mb
1990	CSV · Parquet	CSV · Parquet	Quality report	13.1 mb
1989	CSV · Parquet	CSV · Parquet	Quality report	11.2 mb
1988	CSV · Parquet	CSV · Parquet	Quality report	1.4 mb
1987	CSV · Parquet	CSV · Parquet	Quality report	0.5 mb

Access via S3

s3://nccsdata/processed_merged/core/{YYYY}/{form_type}/

---

SOI-Current Panel (2012–2024)

The annual SOI-current pipeline: IRS Statistics of Income extracts harmonized into year-by-form-type files. Carries the is_amendment flag (TRUE iff the (ein, tax_period) has appeared in an earlier processing-year extract) and extract_year (the processing year the row was sourced from).

990

Full Form 990 filers — the long-form return required for nonprofits with gross receipts ≥ $200k or assets ≥ $500k. Richest variable set in the Core Series (251 columns in 2024).

Year	Data	Dictionary	Quality Report	Size
2024	CSV · Parquet	CSV · Parquet	Quality report	40.6 mb
2023	CSV · Parquet	CSV · Parquet	Quality report	329.2 mb
2022	CSV · Parquet	CSV · Parquet	Quality report	325.9 mb
2021	CSV · Parquet	CSV · Parquet	Quality report	292.2 mb
2020	CSV · Parquet	CSV · Parquet	Quality report	308.8 mb

Show all 990 releases (SOI)

Year	Data	Dictionary	Quality Report	Size
2024	CSV · Parquet	CSV · Parquet	Quality report	40.6 mb
2023	CSV · Parquet	CSV · Parquet	Quality report	329.2 mb
2022	CSV · Parquet	CSV · Parquet	Quality report	325.9 mb
2021	CSV · Parquet	CSV · Parquet	Quality report	292.2 mb
2020	CSV · Parquet	CSV · Parquet	Quality report	308.8 mb
2019	CSV · Parquet	CSV · Parquet	Quality report	314.1 mb
2018	CSV · Parquet	CSV · Parquet	Quality report	311.2 mb
2017	CSV · Parquet	CSV · Parquet	Quality report	308.5 mb
2016	CSV · Parquet	CSV · Parquet	Quality report	305 mb
2015	CSV · Parquet	CSV · Parquet	Quality report	301.6 mb
2014	CSV · Parquet	CSV · Parquet	Quality report	297.5 mb
2013	CSV · Parquet	CSV · Parquet	Quality report	291.9 mb
2012	CSV · Parquet	CSV · Parquet	Quality report	264 mb

990EZ

Short-form filers only. 76 columns in 2024. Most users want 990 Combined below; this standalone slice is useful when you specifically need only the EZ filers.

Year	Data	Dictionary	Quality Report	Size
2024	CSV · Parquet	CSV · Parquet	Quality report	8.9 mb
2023	CSV · Parquet	CSV · Parquet	Quality report	49.1 mb
2022	CSV · Parquet	CSV · Parquet	Quality report	51.8 mb
2021	CSV · Parquet	CSV · Parquet	Quality report	52.4 mb
2020	CSV · Parquet	CSV · Parquet	Quality report	56.4 mb

Show all 990EZ releases (SOI)

Year	Data	Dictionary	Quality Report	Size
2024	CSV · Parquet	CSV · Parquet	Quality report	8.9 mb
2023	CSV · Parquet	CSV · Parquet	Quality report	49.1 mb
2022	CSV · Parquet	CSV · Parquet	Quality report	51.8 mb
2021	CSV · Parquet	CSV · Parquet	Quality report	52.4 mb
2020	CSV · Parquet	CSV · Parquet	Quality report	56.4 mb
2019	CSV · Parquet	CSV · Parquet	Quality report	57.2 mb
2018	CSV · Parquet	CSV · Parquet	Quality report	58.2 mb
2017	CSV · Parquet	CSV · Parquet	Quality report	58.7 mb
2016	CSV · Parquet	CSV · Parquet	Quality report	59.2 mb
2015	CSV · Parquet	CSV · Parquet	Quality report	59.6 mb
2014	CSV · Parquet	CSV · Parquet	Quality report	58.9 mb
2013	CSV · Parquet	CSV · Parquet	Quality report	59 mb
2012	CSV · Parquet	CSV · Parquet	Quality report	55.9 mb

990 Combined

Form 990 + Form 990-EZ filers stacked on the 53-column shared variable subset (plus pipeline-derived universals: tax_year, tax_month, is_501c3, extract_year, is_amendment).

Year	Data	Dictionary	Quality Report	Size
2024	CSV · Parquet	CSV · Parquet	Quality report	15.9 mb
2023	CSV · Parquet	CSV · Parquet	Quality report	111.6 mb
2022	CSV · Parquet	CSV · Parquet	Quality report	113.8 mb
2021	CSV · Parquet	CSV · Parquet	Quality report	110.5 mb
2020	CSV · Parquet	CSV · Parquet	Quality report	113 mb

Show all 990 Combined releases (SOI)

Year	Data	Dictionary	Quality Report	Size
2024	CSV · Parquet	CSV · Parquet	Quality report	15.9 mb
2023	CSV · Parquet	CSV · Parquet	Quality report	111.6 mb
2022	CSV · Parquet	CSV · Parquet	Quality report	113.8 mb
2021	CSV · Parquet	CSV · Parquet	Quality report	110.5 mb
2020	CSV · Parquet	CSV · Parquet	Quality report	113 mb
2019	CSV · Parquet	CSV · Parquet	Quality report	114.4 mb
2018	CSV · Parquet	CSV · Parquet	Quality report	114.1 mb
2017	CSV · Parquet	CSV · Parquet	Quality report	113.6 mb
2016	CSV · Parquet	CSV · Parquet	Quality report	113 mb
2015	CSV · Parquet	CSV · Parquet	Quality report	112.5 mb
2014	CSV · Parquet	CSV · Parquet	Quality report	110.8 mb
2013	CSV · Parquet	CSV · Parquet	Quality report	108.6 mb
2012	CSV · Parquet	CSV · Parquet	Quality report	103.6 mb

990PF

Private foundations. 187 columns in 2024. Tax years 2017–2019 are striped: IRS never published 990-PF extracts for those years (see Known coverage gaps).

Year	Data	Dictionary	Quality Report	Size
2024	CSV · Parquet	CSV · Parquet	Quality report	7.3 mb
2023	CSV · Parquet	CSV · Parquet	Quality report	80.3 mb
2022	CSV · Parquet	CSV · Parquet	Quality report	81.6 mb
2021	CSV · Parquet	CSV · Parquet	Quality report	80.1 mb
2020	CSV · Parquet	CSV · Parquet	Quality report	78.5 mb

Show all 990PF releases (SOI)

Year	Data	Dictionary	Quality Report	Size
2024	CSV · Parquet	CSV · Parquet	Quality report	7.3 mb
2023	CSV · Parquet	CSV · Parquet	Quality report	80.3 mb
2022	CSV · Parquet	CSV · Parquet	Quality report	81.6 mb
2021	CSV · Parquet	CSV · Parquet	Quality report	80.1 mb
2020	CSV · Parquet	CSV · Parquet	Quality report	78.5 mb
2019	CSV · Parquet	CSV · Parquet	Quality report	70.5 mb
2018	CSV · Parquet	CSV · Parquet	Quality report	2.2 mb
2017	CSV · Parquet	CSV · Parquet	Quality report	0.4 mb
2016	CSV · Parquet	CSV · Parquet	Quality report	8.4 mb
2015	CSV · Parquet	CSV · Parquet	Quality report	70.9 mb
2014	CSV · Parquet	CSV · Parquet	Quality report	71.7 mb
2013	CSV · Parquet	CSV · Parquet	Quality report	69.8 mb
2012	CSV · Parquet	CSV · Parquet	Quality report	66.9 mb

Access via S3

s3://nccsdata/processed/core/{YYYY}/{form_type}/

---

Legacy Panel (1987–2011)

Pre-SOI-era filings harmonized from the historical NCCS CORE bucket. No dedup is applied; every row from the source legacy files is preserved. Use this when you need the full pre-2012 record including duplicates.

990 Combined — legacy

Year	Data	Dictionary	Quality Report	Size
2011	CSV · Parquet	CSV · Parquet	Quality report	137.8 mb
2010	CSV · Parquet	CSV · Parquet	Quality report	157.3 mb
2009	CSV · Parquet	CSV · Parquet	Quality report	165.7 mb
2008	CSV · Parquet	CSV · Parquet	Quality report	167.9 mb
2007	CSV · Parquet	CSV · Parquet	Quality report	171.8 mb

Show all years (legacy 990combined)

Year	Data	Dictionary	Quality Report	Size
2011	CSV · Parquet	CSV · Parquet	Quality report	137.8 mb
2010	CSV · Parquet	CSV · Parquet	Quality report	157.3 mb
2009	CSV · Parquet	CSV · Parquet	Quality report	165.7 mb
2008	CSV · Parquet	CSV · Parquet	Quality report	167.9 mb
2007	CSV · Parquet	CSV · Parquet	Quality report	171.8 mb
2006	CSV · Parquet	CSV · Parquet	Quality report	162.6 mb
2005	CSV · Parquet	CSV · Parquet	Quality report	162.9 mb
2004	CSV · Parquet	CSV · Parquet	Quality report	158.4 mb
2003	CSV · Parquet	CSV · Parquet	Quality report	151.4 mb
2002	CSV · Parquet	CSV · Parquet	Quality report	138.3 mb
2001	CSV · Parquet	CSV · Parquet	Quality report	135.3 mb
2000	CSV · Parquet	CSV · Parquet	Quality report	119.4 mb
1999	CSV · Parquet	CSV · Parquet	Quality report	70.9 mb
1998	CSV · Parquet	CSV · Parquet	Quality report	168.8 mb
1997	CSV · Parquet	CSV · Parquet	Quality report	114.4 mb
1996	CSV · Parquet	CSV · Parquet	Quality report	102.7 mb
1995	CSV · Parquet	CSV · Parquet	Quality report	100.8 mb
1994	CSV · Parquet	CSV · Parquet	Quality report	97.7 mb
1993	CSV · Parquet	CSV · Parquet	Quality report	94.8 mb
1992	CSV · Parquet	CSV · Parquet	Quality report	93 mb
1991	CSV · Parquet	CSV · Parquet	Quality report	93.3 mb
1990	CSV · Parquet	CSV · Parquet	Quality report	88.3 mb
1989	CSV · Parquet	CSV · Parquet	Quality report	65.8 mb
1988	CSV · Parquet	CSV · Parquet	Quality report	16.4 mb
1987	CSV · Parquet	CSV · Parquet	Quality report	6.9 mb

990PF — legacy

Tax year 1993 is striped: the source CORE-1993-501C3-PRIVFOUND-PF.csv is missing from the legacy NCCS bucket, so the partition contains only ~11k spillover rows.

Year	Data	Dictionary	Quality Report	Size
2011	CSV · Parquet	CSV · Parquet	Quality report	39.9 mb
2010	CSV · Parquet	CSV · Parquet	Quality report	44.6 mb
2009	CSV · Parquet	CSV · Parquet	Quality report	43.6 mb
2008	CSV · Parquet	CSV · Parquet	Quality report	40.9 mb
2007	CSV · Parquet	CSV · Parquet	Quality report	39.9 mb

Show all years (legacy 990pf)

Year	Data	Dictionary	Quality Report	Size
2011	CSV · Parquet	CSV · Parquet	Quality report	39.9 mb
2010	CSV · Parquet	CSV · Parquet	Quality report	44.6 mb
2009	CSV · Parquet	CSV · Parquet	Quality report	43.6 mb
2008	CSV · Parquet	CSV · Parquet	Quality report	40.9 mb
2007	CSV · Parquet	CSV · Parquet	Quality report	39.9 mb
2006	CSV · Parquet	CSV · Parquet	Quality report	39.3 mb
2005	CSV · Parquet	CSV · Parquet	Quality report	39.9 mb
2004	CSV · Parquet	CSV · Parquet	Quality report	36.3 mb
2003	CSV · Parquet	CSV · Parquet	Quality report	35.7 mb
2002	CSV · Parquet	CSV · Parquet	Quality report	33.6 mb
2001	CSV · Parquet	CSV · Parquet	Quality report	31.8 mb
2000	CSV · Parquet	CSV · Parquet	Quality report	31.4 mb
1999	CSV · Parquet	CSV · Parquet	Quality report	27.3 mb
1998	CSV · Parquet	CSV · Parquet	Quality report	27.3 mb
1997	CSV · Parquet	CSV · Parquet	Quality report	23.3 mb
1996	CSV · Parquet	CSV · Parquet	Quality report	19 mb
1995	CSV · Parquet	CSV · Parquet	Quality report	17.7 mb
1994	CSV · Parquet	CSV · Parquet	Quality report	14.8 mb
1993	CSV · Parquet	CSV · Parquet	Quality report	4.1 mb
1992	CSV · Parquet	CSV · Parquet	Quality report	14.6 mb
1991	CSV · Parquet	CSV · Parquet	Quality report	14.1 mb
1990	CSV · Parquet	CSV · Parquet	Quality report	14 mb
1989	CSV · Parquet	CSV · Parquet	Quality report	11.8 mb
1988	CSV · Parquet	CSV · Parquet	Quality report	1.8 mb
1987	CSV · Parquet	CSV · Parquet	Quality report	0.4 mb

Access via S3

s3://nccsdata/processed_legacy/core/{YYYY}/{form_type}/

---

Output schema additions

Columns added by the new pipeline that are worth knowing about — see the output schema reference and legacy harmonization guide for the full definitions.

Column	Tier	Type	What it means
is_amendment	SOI-current	boolean	TRUE iff this (ein, tax_period) has appeared in an earlier processing-year extract. Filter == FALSE for original filings only.
extract_year	SOI-current	integer	The processing year of the IRS extract this row came from. Useful for amendment provenance.
source_pipeline	Merged	string	"legacy" or "soi_current". Which side of the merge contributed this row.
has_legacy_augment	Merged	boolean	TRUE iff legacy contributed columns to this SOI-current row at merge time (overlap-year augmentation).
is_501c3	all	boolean	TRUE for 501(c)(3) public charities; pair with subsection_cd (1–93) for finer 501(c) subclass breakdowns.

---

Known coverage gaps

These partitions exist in the manifest but reflect IRS-side gaps rather than normal coverage. Rows are striped and flagged with a † in the tables above.

• SOI 990PF, tax years 2017–2019 — IRS never published 990-PF extracts for those tax years. The processed/core/.../990pf/ partitions contain only late-filer spillover (~665 / 3,348 / 100,359 rows vs. ~100k typical full-year extract). The merged tier inherits this gap.
• Legacy 990PF, tax year 1993 — CORE-1993-501C3-PRIVFOUND-PF.csv is missing from the legacy NCCS bucket. The processed_legacy/1993/990pf/ and processed_merged/1993/990pf/ partitions contain ~11k spillover rows vs. ~40k in 1992 and 1994.

See the upstream-source quirks section of the pipeline guide for the full list of IRS-side coverage issues.

---

File conventions

Every year/form directory in all three tiers contains the same four artifacts:

{TIER_PREFIX}/{YYYY}/{FORM_TYPE}/
    core_{YYYY}_{FORM_TYPE}.csv                # data, CSV
    core_{YYYY}_{FORM_TYPE}.parquet            # data, Parquet (3-5x smaller; fastest for DuckDB / arrow)
    core_{YYYY}_{FORM_TYPE}_dictionary.csv     # variable definitions
    core_{YYYY}_{FORM_TYPE}_dictionary.parquet # variable definitions, Parquet

Where {TIER_PREFIX} is one of processed_merged/core, processed/core, or processed_legacy/core.

Quality reports are HTML pages served from GitHub Pages, with one URL prefix per tier:

https://urbaninstitute.github.io/nccs-data-core/quality-reports/{YYYY}/{form}/core_{YYYY}_{form}_quality.html         # SOI-current
https://urbaninstitute.github.io/nccs-data-core/quality-reports/legacy/{YYYY}/{form}/core_{YYYY}_{form}_quality.html  # Legacy
https://urbaninstitute.github.io/nccs-data-core/quality-reports/merged/{YYYY}/{form}/core_{YYYY}_{form}_quality.html  # Merged

This catalog page is the index for those reports — the Quality Report column links the appropriate per-tier URL on every row.

Data dictionaries are per-year because the variable set evolves as the underlying 990 forms change. Always read the dictionary for the year you’re using rather than assuming column stability across years.

Filter on is_501c3 (boolean) to subset to 501(c)(3) public charities or their complement. The raw subsection_cd (IRC EO subsection code, 1–93) is also present for finer breakdowns.

---

Before you analyze

Known upstream-IRS data shapes that look like pipeline bugs but aren’t — documented in the pipeline guide so analysts don’t have to rediscover them:

• No top-coding or winsorization — identical maxes across related columns (e.g. total_contributions = total_revenue) reflect real-world equality for one filer, not capping.
• ~12% of 990-EZ rows fail the balance-sheet identity — filer-supplied, not a harmonization error.
• Schedule A _sec170 / _sec509 zeros are filer-test-specific — cross-reference non_pf_status_reason before interpreting them as missing data.
• Filer-supplied negatives on revenue fields — IRS-supplied as-filed; not amendments.
• Legacy + SOI merge precedence and disagreement audit — how the merged panel resolves overlapping (ein, tax_period) rows.

Full pipeline guide and per-form quality reports are at the CORE Pipeline Guide.

---

Blank IRS Forms Archive

Blank IRS Form 990, 990-EZ, 990-PF, their schedules (A–O and R), and the corresponding instruction booklets are mirrored at s3://nccsdata/raw/core/forms/. Each cell below links the blank Form and (where IRS publishes one standalone) the Instr.uction booklet. Empty cells reflect years IRS did not publish that combination — not a coverage gap on our side. See the Forms archive section of the Pipeline Guide for the year-coverage details and refresh SOP.

Direct download URLs follow:

https://nccsdata.s3.us-east-1.amazonaws.com/raw/core/forms/<basename>_<YYYY>.pdf

A note on schedule instructions: M, N, and parts of I/L have no standalone instruction PDF because IRS folds those instructions into the main i990_YYYY.pdf booklet linked under Form 990 below.

Main Forms

Year	Form 990	Form 990-EZ	Form 990-PF
2024	Form Instr.	Form Instr.	Form Instr.
2023	Form Instr.	Form Instr.	Form Instr.
2022	Form Instr.	Form Instr.	Form Instr.
2021	Form Instr.	Form Instr.	Form Instr.
2020	Form Instr.	Form Instr.	Form Instr.
2019	Form Instr.	Form Instr.	Form Instr.
2018	Form Instr.	Form Instr.	Form Instr.
2017	Form Instr.	Form Instr.	Form Instr.
2016	Form Instr.	Form Instr.	Form Instr.
2015	Form Instr.	Form Instr.	Form Instr.
2014	Form Instr.	Form Instr.	Form Instr.
2013	Form Instr.	Form Instr.	Form Instr.
2012	Form Instr.	Form Instr.	Form Instr.
2011	Form Instr.	Form Instr.	Form Instr.
2010	Form Instr.	Form Instr.	Form Instr.
2009	Form Instr.	Form Instr.	Form Instr.
2008	Form Instr.	Form Instr.	Form Instr.
2007	Form	Form	Form Instr.
2006	Form	Form	Form Instr.
2005	Form	Form	Form Instr.
2004	Form	Form	Form Instr.
2003	Form	Form	Form Instr.
2002	Form	Form	Form Instr.
2001	Form	Form	Form Instr.
2000	Form	Form	Form Instr.
1999	Form	Form	Form Instr.
1998	Form	Form	Form Instr.
1997	Form	Form	Form Instr.
1996	Form	Form	Form Instr.
1995	Form Instr.	Form Instr.	Form Instr.
1994	Form Instr.	Form Instr.	Form Instr.
1993	Form Instr.	Form Instr.	Form Instr.
1992	Form Instr.	Form Instr.	Form Instr.
1991	Form Instr.	Form Instr.	Form Instr.
1990	Form Instr.	Form Instr.	Form Instr.

Schedules

Columns are too narrow for the full labels here, so cells use F = blank form, I = instruction booklet.

Year	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	R
2024	F I	F	F I	F I	F I	F I	F I	F I	F I	F I	F I	F I	F	F	F I	F I
2023	F I	F	F I	F I	F	F I	F I	F I	F	F I	F I	F I	F	F	F	F I
2022	F I	F	F I	F I	F	F I	F I	F I	F	F I	F I	F I	F	F	F	F I
2021	F I	F	F I	F I	F	F I	F I	F I	F	F I	F I	F I	F	F	F	F I
2020	F I	F	F I	F I	F	F I	F I	F I	F	F I	F I	F I	F	F	F	F I
2019	F I	F	F I	F I	F	F I	F I	F I	F	F I	F I	F I	F	F	F	F I
2018	F I	F	F I	F I	F	F I	F I	F I	F	F I	F I	F I	F	F	F	F I
2017	F I	F	F I	F I	F	F I	F I	F I	F	F I	F I	F I	F	F	F	F I
2016	F I	F	F I	F I	F	F I	F I	F I	F	F I	F I	F I	F	F	F	F I
2015	F I	F	F I	F I	F	F I	F I	F I	F	F I	F I	F I	F	F	F	F I
2014	F I	F	F I	F I	F	F I	F I	F I	F	F I	F I	F I	F	F	F	F I
2013	F I	F	F I	F I	F	F I	F I	F I	F	F I	F I	F I	F	F	F	F I
2012	F I	F	F I	F I	F	F I	F I	F I	F	F I	F I	F I	F	F	F	F I
2011	F I	F	F I	F I	F	F I	F I	F I	F	F I	F I	F I	F	F	F	F I
2010	F I	F	F I	F I	F	F I	F I	F I	F	F I	F I	F I	F	F	F	F I
2009	F I	F	F I	F I	F	F I	F I	F I	F	F I	F I	F I	F	F	F	F I
2008	F I	F	F I	F I	F	F I	F I	F I	F	F I	F I	F I	F	F	F	F I
2007	F I	F
2006	F I	F
2005	F I	F
2004	F I	F
2003	F I	F
2002	F I	F
2001	F I	F
2000	F I	F
1999	F I
1998	F I
1997	F I
1996	F I
1995	F I
1994	F I
1993	F I
1992	F I
1991	F I
1990	F I

---

Deprecated: harmonized/core/ (pre-tier layout)

Show legacy harmonized/core/ files (for reproducibility only — use the Legacy Panel above)

These files predate the current three-tier layout. They split each year’s filers along two axes — tax-exempt class (501c3 charities vs. all other 501c types) and form scope (PC = full 990 only, PZ = 990 + 990EZ) — producing five products. The current pipeline pools these into a single set of by-form-type files with an is_501c3 column for filtering, so the products below are kept only to support replication of analyses built on the older layout.

Shared dictionaries (PC/PZ variants share a single dictionary; PF has its own):

• PC/PZ data dictionary
• PF data dictionary

501(c)(3) Charities — PC (full 990 only)

Year	Download	Size
2023	Download	29.4 mb
2022	Download	296 mb
2021	Download	485.6 mb
2020	Download	258.3 mb
2019	Download	233.6 mb
2018	Download	217.4 mb
2017	Download	203.6 mb
2016	Download	193 mb
2015	Download	190.3 mb
2014	Download	187.8 mb
2013	Download	219.8 mb
2012	Download	227.5 mb

501(c)(3) Charities — PZ (990 + 990EZ)

Year	Download	Size
2023	Download	30.5 mb
2022	Download	272.3 mb
2021	Download	544.7 mb
2020	Download	379.4 mb
2019	Download	370.2 mb
2018	Download	361.7 mb
2017	Download	352.7 mb
2016	Download	329 mb
2015	Download	322 mb
2014	Download	316.1 mb
2013	Download	385.7 mb
2012	Download	365.1 mb
2011	Download	286.3 mb
2010	Download	264.3 mb
2009	Download	286.6 mb
2008	Download	251.8 mb
2007	Download	304.9 mb
2006	Download	251.8 mb
2005	Download	233.7 mb
2004	Download	231.5 mb
2003	Download	219.2 mb
2002	Download	207.6 mb
2001	Download	185.6 mb
2000	Download	187.2 mb
1999	Download	199.5 mb
1998	Download	198.7 mb
1997	Download	189.5 mb
1996	Download	178.4 mb
1995	Download	116.6 mb
1994	Download	104.5 mb
1993	Download	98.3 mb
1992	Download	93.4 mb
1991	Download	88.9 mb
1990	Download	88.8 mb
1989	Download	86.5 mb

Other 501(c) Nonprofits — PC (full 990 only)

Year	Download	Size
2023	Download	10.1 mb
2022	Download	75.1 mb
2021	Download	118.8 mb
2020	Download	65.4 mb
2019	Download	59.5 mb
2018	Download	56.2 mb
2017	Download	54 mb
2016	Download	52.3 mb
2015	Download	52.4 mb
2014	Download	52.6 mb
2013	Download	65.1 mb
2012	Download	67.3 mb

Other 501(c) Nonprofits — PZ (990 + 990EZ)

Year	Download	Size
2023	Download	10.7 mb
2022	Download	75.2 mb
2021	Download	144.8 mb
2020	Download	106 mb
2019	Download	106.2 mb
2018	Download	107.3 mb
2017	Download	110 mb
2016	Download	103.2 mb
2015	Download	103.4 mb
2014	Download	104.3 mb
2013	Download	121.1 mb
2012	Download	113.6 mb
2011	Download	97.1 mb
2010	Download	103.6 mb
2009	Download	118.5 mb
2008	Download	104.8 mb
2007	Download	106.3 mb
2006	Download	92.3 mb
2005	Download	105.3 mb
2004	Download	98.4 mb
2003	Download	91.2 mb
2002	Download	89 mb
2001	Download	98.3 mb
2000	Download	89.9 mb
1999	Download	78.7 mb
1998	Download	89.1 mb
1997	Download	62.9 mb
1996	Download	83.9 mb
1995	Download	86.8 mb
1994	Download	88.7 mb
1993	Download	95.5 mb
1992	Download	101.8 mb
1991	Download	100.3 mb
1990	Download	97.4 mb
1989	Download	98.7 mb

Private Foundations — PF

Year	Download	Size
2023	Download	5.7 mb
2022	Download	60.2 mb
2021	Download	60.2 mb
2020	Download	63.7 mb
2019	Download	93.8 mb
2018	Download	2 mb
2017	Download	0.3 mb
2016	Download	12.2 mb
2015	Download	104.7 mb
2014	Download	106.2 mb
2013	Download	107.5 mb
2012	Download	102.3 mb
2011	Download	89.3 mb
2010	Download	56.6 mb
2009	Download	54.1 mb
2008	Download	49.6 mb
2007	Download	46.3 mb
2006	Download	47.5 mb
2005	Download	48.6 mb
2004	Download	42.2 mb
2003	Download	40.5 mb
2002	Download	38.4 mb
2001	Download	37.4 mb
2000	Download	35.9 mb
1999	Download	32.6 mb
1998	Download	33 mb
1997	Download	28.2 mb
1996	Download	23.7 mb
1995	Download	21.3 mb
1994	Download	17.4 mb
1993	Download	4.8 mb
1992	Download	18.6 mb
1991	Download	18.2 mb
1990	Download	17.9 mb
1989	Download	15.1 mb
1988	Download	2.3 mb
1987	Download	0.6 mb

Access via S3

s3://nccsdata/harmonized/core/{PRODUCT}/marts/

where {PRODUCT} is one of 501c3-pc, 501c3-pz, 501ce-pc, 501ce-pz, 501c3-pf.

---

Documentation & Support

• Core overview page — what’s in the Core Series, scope limitations, and merging guidance
• CORE Pipeline Guide — root of the pipeline documentation site
• Architecture overview — how the three tiers fit together
• Output schema reference — column-by-column definitions
• Legacy harmonization & merge semantics — SOI precedence, disagreement audit, dedup rules
• Upstream-source quirks — IRS extract format changes and missing-year gaps
• BMF Data Catalog — Business Master File, for merging organizational attributes (NTEE, 501c type, address) onto Core rows via EIN
• Census Crosswalk Catalog — aggregate Core data to tracts, counties, or MSAs
• Contact — questions, corrections, data requests

Last verified: 2026-05-18