990 Efile Data Catalog

Form 990 and 990-EZ filers · release efile_v3_1

The NCCS 990 Efile database turns the XML returns that nonprofits file electronically with the IRS into 131 relational tables, one or more for each Part of Form 990, Form 990-EZ, and their Schedules. Every table is published for each tax year in two formats, CSV and Parquet.

Release efile_v3_1 (published 2026-10-09)
Returns Form 990 and Form 990-EZ, with schedules
Tax years 2009–2025 (2025 is a partial year)
Tables 131 tables, 2,126 table-year files
Filings 6,307,836 returns
Labels concordance990 02de916
Private foundations Form 990-PF returns are a separate database: efilepf_v3_1 catalog

About this release

Data sources and processing

IRS 990 e-file returns are published by the IRS as XML documents. NCCS builds this database from the XML files indexed by the Giving Tuesday 990 Data Commons, supplemented with returns the IRS e-file index lists but the Data Commons index never picked up (see the release notes below).

Each XML element (xpath) is assigned to a research variable and a table by the Master Concordance (concordance990), and the tables are built with the ef2 package. A table holds one Part of a form or schedule: either one row per filing (1:1), or several rows per filing for repeating groups such as officers, grants, or program service accomplishments (1:M).

Efile data are organized by tax year, the closest approximation to the calendar year in which the nonprofit’s activities took place. The tax year (TAX_YEAR) is the year in which the fiscal year begins (TAX_PERIOD_BEGIN_DATE). Returns are due five months after the fiscal year ends, and the IRS releases them in monthly batches, so the most recent tax year is always incomplete and keeps growing for two to three years.

Every table carries the keys needed to join tables to each other and to the BMF: OBJECTID (OID- followed by 18 digits, one per filing), EIN2, and TAX_YEAR. One-to-many tables add TABLE_ID (TID-NNN-NNN-NNN, one per row). Every row also carries URL, a link to the source XML return: open it to confirm whether a value is missing from the return or was not captured by the concordance.

R packages

  • ef2 Parses IRS 990 e-file XML into the relational tables published here.
  • concordance990 The Master Concordance: maps XML xpaths to variables and tables; holds the data dictionaries.
  • panel990 Downloads efile tables and builds longitudinal panels, with BMF fields attached.
  • fiscal Fiscal health accounting metrics from 990 data.
  • governance Governance scores for nonprofits from Part VI.
  • peopleparser Splits officer and director names into parts and infers gender.
  • titleclassifier Classifies officer titles into standard roles.

Data dictionaries

Variable names, labels, descriptions, data types, and form locations for every table are documented in the concordance990 data dictionaries. Each table below links to its own section of the dictionary.

An archive of historic 990 forms and schedules is available from the Nonprofit Open Data Collective.

Coverage

Before tax year 2021, electronic filing was required only for the largest nonprofits (more than $10 million in assets) and for private foundations. Other organizations adopted it gradually. Beginning with tax year 2021 (calendar year 2022), e-filing is mandatory for almost all tax-exempt organizations, so recent waves cover nearly the full population of 990 and 990-EZ filers. For earlier years, the larger an organization is, the more likely it filed electronically; sample weights can be built by comparing efilers with the BMF or the NCCS Core files.

E-filed returns by tax year and return type (efile_v3_1 and efilepf_v3_1)

Stacked bar chart of e-filed returns per tax year, 2009 to 2025, split into Form 990, 990-EZ and 990-PF. Counts rise from about 51 thousand in 2009 to about 690 thousand in 2023 and 2024; 2025 is a partial year.

Tax year 990 990-EZ 990-PF Total
2009 33,311 15,470 2,345 51,126
2010 123,025 63,326 25,249 211,600
2011 159,504 82,048 34,597 276,149
2012 179,688 93,750 39,933 313,371
2013 198,855 104,375 45,887 349,117
2014 218,619 116,417 53,442 388,478
2015 233,519 124,894 58,815 417,228
2016 243,903 130,484 62,988 437,375
2017 261,612 139,145 68,950 469,707
2018 271,442 149,384 80,138 500,964
2019 283,694 152,623 87,789 524,106
2020 320,343 169,865 114,957 605,165
2021 336,489 202,729 119,354 658,572
2022 349,396 206,375 122,914 678,685
2023 359,351 208,863 125,565 693,779
2024 360,911 207,825 124,337 693,073
2025 102,869 103,732 67,525 274,126

Proportion of paper vs. electronic 990/990-EZ filers

Tax year E-file Paper
2013 0.50 0.50
2014 0.65 0.35
2015 0.68 0.32
2016 0.71 0.29
2017 0.73 0.27
2018 0.76 0.24
2019 0.81 0.19
2020 0.91 0.09
2021 0.99 0.01
2022 0.99 0.01
2023 1.00 0.00

While most parts of Form 990 and its schedules are public, some sensitive information is redacted by the IRS or nonprofits to protect the privacy of donors.

Table and file names

Table names follow the pattern FF-PPP-TTT-NAME, and each file appends the tax year: F9-P07-T01-COMPENSATION-2023.parquet.

  • FF is the form: F9 = Form 990, SA = Schedule A, SB = Schedule B, and so on.
  • PPP is the part: P01 = Part I, P02 = Part II, and so on. P00 is the heading and P99 holds lines outside any part or from earlier versions of the form.
  • TTT is the table: T00 holds the one-to-one fields of the part, and T01, T02, … are its one-to-many tables.

Tables whose names end in -EZ hold lines that appear only on Form 990-EZ. All other tables pool the matching lines from the 990 and the 990-EZ.

Each table-year is published as CSV (readable anywhere) and Parquet (smaller and much faster in R with arrow or duckdb; panel990 reads Parquet by default). Both files hold the same rows and columns. Table-years with no filings are omitted from the listings below.

Release notes

Changes from efile_v2_3 to efile_v3_1. Generated by ef2::write_release_notes() on 2026-10-09.

Notes

  • New filings. This release adds filings that the Giving Tuesday Data Commons (GTDC) index never listed. The IRS e-file index lists 184,165 such filings (990, 990-EZ and 990-PF; IRS batches 2025_09A, 2025_10A, the second half of 2026_05A, and 2026_08A). Their XML is re-hosted at https://nccs-efile.s3.us-east-1.amazonaws.com/xml2/v2_3_patch/<OBJECT_ID>_public.xml, with PATCH-INDEX-v2_3-2026-10-07.csv beside them. The build index combined the GTDC index of 2026-08-25 with that patch, one row per filing.
  • TY2025 is new: built from the combined index. Many TY2025 returns are not filed yet, so expect it to grow.
  • Labels follow concordance990 2.0.1 (commit 02de916). Relabelling moved some xpaths between tables; where the builders already selected those cells by xpath, the published tables are unchanged.
  • Keys. OBJECTID is OID- + 18 digits, and TABLE_ID is the fixed-width TID-NNN-NNN-NNN (EF2-17), in every table.
  • Record. dev/UPSTREAM-ISSUES.md (EF2-18) in the ef2 repository documents how this release was built and checked.
  • Header table. F9-P00-T00-HEADER gains F9_00_ORG_EXEMPT_TYPE (EF2-12): the filer’s tax-exempt status as one string (501c3, 501c4, …, 4947a1, 527), derived from the 501(c) subsection attribute and the status checkboxes.

Summary

  • Tax years: 2009-2025 (previously 2009-2024).
  • Tables: 0 added, 0 dropped.
  • Table-years in both releases: 2,000; row counts changed in 391, column counts in 18; rows fell in 0.
  • Columns: 10 added and 0 removed, across 3 tables.
  • Filings: 6,307,836, previously 5,981,036 (+326,800).
  • Concordance: 59 xpaths newly mapped, 0 dropped, 187 moved between tables, 0 variables renamed, 0 multi_value changes.

Filings by tax year

Tax year efile_v2_3 efile_v3_1 Change
2009 48,781 48,781 0
2010 186,351 186,351 0
2011 241,552 241,552 0
2012 273,438 273,438 0
2013 303,230 303,230 0
2014 335,036 335,036 0
2015 358,413 358,413 0
2016 374,387 374,387 0
2017 400,757 400,757 0
2018 420,826 420,826 0
2019 436,317 436,317 0
2020 490,208 490,208 0
2021 539,217 539,218 +1
2022 555,197 555,771 +574
2023 561,156 568,214 +7,058
2024 456,170 568,736 +112,566
2025 0 206,601 +206,601

By return type:

Tax year Return type efile_v2_3 efile_v3_1 Change
2021 990 336,488 336,489 +1
2022 990 349,062 349,396 +334
2022 990EZ 206,135 206,375 +240
2023 990 354,774 359,351 +4,577
2023 990EZ 206,382 208,863 +2,481
2024 990 277,302 360,911 +83,609
2024 990EZ 178,868 207,825 +28,957
2025 990 0 102,869 +102,869
2025 990EZ 0 103,732 +103,732

Tables added and dropped

Added:

None.

Dropped:

None.

Column changes

Columns added or removed in tables present in both releases, with the tax years affected.

Table Change Column Years
F9-P00-T00-HEADER added F9_00_IRS_SEC_ACTIVE_PREP_TIME 2020
F9-P00-T00-HEADER added F9_00_IRS_SEC_AUTH_REVIEW_CD 2020
F9-P00-T00-HEADER added F9_00_IRS_SEC_AUTH_REVIEW_TXT 2020
F9-P00-T00-HEADER added F9_00_IRS_SEC_PREP_SUBMIT_TIME 2020
F9-P00-T00-HEADER added F9_00_IRS_SEC_VENDOR_CTRL_NUM 2020
F9-P00-T00-HEADER added F9_00_IRS_TRUST_CELL_CHANGE_X 2020-2021
F9-P00-T00-HEADER added F9_00_IRS_TRUST_PAY_DECLINED_CD 2020
F9-P00-T00-HEADER added F9_00_ORG_EXEMPT_TYPE 2009-2024
SH-P04-T01-COMPANY-JOINT-VENTURES added SH_04_CO_ENTITY_NAME_L2 2024
SH-P05-T03-FACILITY-POLICIES-PRACTICES added SH_05_EMERGENCY_LIMIT_CARE_X 2024

Row-count changes

Tables whose row counts changed, summed over the years that changed.

Table Years efile_v2_3 efile_v3_1 Change
F9-P07-T01-COMPENSATION 2021-2024 19,025,219 20,347,699 +1,322,480
SO-P00-T99-SUPPLEMENTAL-INFO 2021-2024 10,839,225 11,498,112 +658,887
SI-P02-T01-GRANTS-US-ORGS-GOVTS 2022-2024 2,546,144 2,997,058 +450,914
SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS 2022-2024 1,347,153 1,624,300 +277,147
F9-P09-T01-EXPENSES-OTHER 2021-2024 4,030,831 4,305,664 +274,833
SJ-P02-T01-COMPENSATION-DTK 2022-2024 820,049 955,062 +135,013
F9-P08-T01-REVENUE-PROGRAMS 2022-2024 1,315,420 1,447,997 +132,577
F9-P00-T00-HEADER 2021-2024 2,111,740 2,231,939 +120,199
F9-P02-T00-SIGNATURE 2021-2024 2,111,740 2,231,939 +120,199
F9-P04-T00-REQUIRED-SCHEDULES 2021-2024 2,111,740 2,231,939 +120,199
F9-P05-T00-OTHER-IRS-FILING 2021-2024 2,111,740 2,231,939 +120,199
F9-P06-T00-GOVERNANCE 2021-2024 2,111,740 2,231,939 +120,199
F9-P10-T00-BALANCE-SHEET 2021-2024 2,111,740 2,231,939 +120,199
F9-P03-T00-MISSION 2021-2024 2,111,640 2,231,825 +120,185
F9-P12-T00-FINANCIAL-REPORTING 2021-2024 2,108,179 2,228,250 +120,071
F9-P01-T00-SUMMARY 2021-2024 2,105,561 2,225,425 +119,864
F9-P07-T00-DIR-TRUST-KEY 2021-2024 2,005,532 2,121,328 +115,796
F9-P08-T00-REVENUE 2021-2024 1,972,938 2,087,943 +115,005
F9-P03-T00-PROGRAMS 2021-2024 1,871,932 1,981,045 +109,113
F9-P09-T00-EXPENSES 2021-2024 1,817,536 1,924,649 +107,113
F9-P11-T00-ASSETS 2021-2024 1,629,404 1,730,752 +101,348
SA-P01-T00-PUBLIC-CHARITY-STATUS 2022-2024 1,223,040 1,320,838 +97,798
SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION 2022-2024 779,586 877,166 +97,580
SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP 2022-2024 696,346 785,422 +89,076
F9-P03-T00-PROGRAM-ONE 2021-2024 1,317,626 1,406,147 +88,521
SD-P10-T01-OTH-LIABILITIES 2022-2024 729,393 815,557 +86,164
SD-P13-T99-SUPPLEMENTAL-INFO 2022-2024 550,395 622,582 +72,187
SD-P06-T00-LAND-BLDG-EQUIP 2021-2024 927,761 994,785 +67,024
SB-P01-T01-CONTRIBUTORS 2022-2024 659,139 716,651 +57,512
F9-P08-T02-REVENUE-MISC 2022-2024 513,262 566,084 +52,822
F9-P07-T02-CONTRACTORS 2022-2024 335,954 388,105 +52,151
SD-P10-T00-OTH-LIABILITIES 2022-2024 451,298 501,485 +50,187
F9-P03-T02-PROGRAMS-EZ 2022-2024 916,231 965,729 +49,498
SR-P05-T01-TRANSACTIONS-RLTD-ORGS 2022-2024 305,636 353,231 +47,595
SA-P02-T00-SUPPORT_SCHEDULE_170 2022-2024 583,477 628,970 +45,493
SD-P09-T01-OTH-ASSETS 2022-2024 353,187 397,957 +44,770
SA-P03-T00-SUPPORT_SCHEDULE_509 2022-2024 613,225 655,536 +42,311
SD-P11-T00-RECONCILIATION-REVENUE 2022-2024 284,135 318,332 +34,197
SD-P12-T00-RECONCILIATION-EXPENSES 2022-2024 284,075 318,261 +34,186
F9-P06-T00-GOVERNANCE-EZ 2022-2024 591,385 623,063 +31,678
F9-P01-T00-SUMMARY-EZ 2022-2024 559,212 588,913 +29,701
SJ-P01-T00-COMPENSATION 2022-2024 213,316 242,391 +29,075
F9-P03-T00-PROGRAM-TWO 2022-2024 293,336 321,644 +28,308
SG-P02-T00-FUNDRAISING-EVENTS 2021-2024 374,299 401,092 +26,793
SR-P05-T00-TRANSACTIONS-RLTD-ORGS 2022-2024 201,227 226,659 +25,432
SI-P03-T01-GRANTS-US-INDIV 2022-2024 198,717 222,426 +23,709
SF-P02-T01-FRGN-ORG-GRANTS 2022-2024 231,669 255,110 +23,441
SI-P01-T00-GRANTS-INFO 2022-2024 218,261 241,648 +23,387
SJ-P03-T99-SUPPLEMENTAL-INFO 2022-2024 128,732 151,731 +22,999
F9-P03-T00-PROGRAM-THREE 2022-2024 208,970 229,512 +20,542
SA-P06-T99-SUPPLEMENTAL-INFO 2022-2024 203,386 223,538 +20,152
SH-P06-T99-SUPPLEMENTAL-INFO 2022-2024 77,830 97,301 +19,471
SD-P09-T00-OTH-ASSETS 2022-2024 162,496 181,725 +19,229
SD-P07-T01-INVESTMENTS-OTH-SECURITIES 2022-2024 170,668 189,463 +18,795
F9-P03-T01-PROGRAMS-OTHER 2022-2024 169,743 188,196 +18,453
SA-P01-T01-PUBLIC-CHARITY-STATUS 2022-2024 121,056 137,779 +16,723
SI-P04-T99-SUPPLEMENTAL-INFO 2022-2024 132,374 148,307 +15,933
SF-P01-T01-FRGN-ACTS-BY-REGION 2022-2024 129,079 144,471 +15,392
SE-P02-T99-SUPPLEMENTAL-INFO 2022-2024 77,984 91,635 +13,651
SH-P05-T02-NON-HOSPITAL-FACILITY 2022-2024 72,111 85,389 +13,278

… and 66 more.

Concordance changes

Xpaths moved between tables:

From To Xpaths
SH-P99-T00-FAP-COMMUNITY-BENEFIT-POLICY SH-P99-T01-FAP-COMMUNITY-BENEFIT-POLICY 89
SG-P02-T01-FUNDRAISING-EVENTS SG-P02-T00-FUNDRAISING-EVENTS 86
SD-P07-T01-INVESTMENTS-OTH-EQUITY SD-P07-T00-INVESTMENTS-OTH-EQUITY 6
SD-P07-T01-INVESTMENTS-OTH-DERIVATIVES SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES 6

Newly mapped xpaths, by table:

Table Xpaths
SB-P03-T01-EXCLUSIVELY-RELIGIOUS 23
SB-P01-T01-CONTRIBUTORS 18
F9-P00-T00-HEADER 7
SB-P00-T00-HEADER 6
SB-P02-T01-NONCASH-PROPERTY 4
SB-P03-T00-EXCLUSIVELY-RELIGIOUS 1

Renamed variables:

None.

multi_value changes:

None.

Release notes on S3

Version history

Every release stays on S3 and keeps its catalog page, so earlier analyses can be reproduced. Interim releases were built and posted but not announced as full public releases.

Release Returns Published Status Tax years Tables Filings Notes
efile_v3_1 this page 990, 990-EZ 2026-10-09 Current 2009–2025 136 6,307,836 Release notes
efilepf_v3_1 990-PF 2026-10-09 Current 2009–2025 83 1,234,785 Release notes
efile_v2_3 990, 990-EZ 2026-10-07 Interim 2009–2024 136 5,981,036 —
efilepf_v2_3 990-PF 2026-10-07 Interim 2009–2024 84 1,151,314 —
efile_v2_2 990, 990-EZ 2026-08-11 Interim 2009–2024 112 5,675,704 —
efile_v2_1 990, 990-EZ 2025-10-28 Archived 2009–2024 112 5,675,704 —
efile_v2_0 990, 990-EZ 2025-03-22 Archived 2009–2023 111 5,159,432 —
efile_v1 990, 990-EZ 2023-03-21 Archived — — — —

Available tables

Each table lists its files by tax year. The code below each table uses panelize() from panel990 to download a multi-year panel of the table with BMF organization fields (NTEE codes, geography, subsection) attached.

Anchor your code to a release. panelize() reads the current release (efile_version()) unless told otherwise, so the same code returns different data after the next release. For reproducible results, name the release explicitly:

panel <- 
  panelize( tables = "F9-P01-T00-SUMMARY",
            years = 2020:2024,
            source = data_source( version = "v3_1" ),
            bmf = TRUE )

BMF fields come from the current NCCS master BMF. To fix those as well, save the BMF once and pass the data frame or file path to bmf =.

Form 990 / 990-EZ: Return of Organization Exempt From Income Tax

P00 Heading (items A-O)

F9-P00-T00-HEADER

1:1 one row per filing · tax years 2009–2025 · 6,307,836 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P00-T00-HEADER-2025 CSV Parquet 206,601
2024 F9-P00-T00-HEADER-2024 CSV Parquet 568,736
2023 F9-P00-T00-HEADER-2023 CSV Parquet 568,214
2022 F9-P00-T00-HEADER-2022 CSV Parquet 555,771
2021 F9-P00-T00-HEADER-2021 CSV Parquet 539,218
2020 F9-P00-T00-HEADER-2020 CSV Parquet 490,208
2019 F9-P00-T00-HEADER-2019 CSV Parquet 436,317
2018 F9-P00-T00-HEADER-2018 CSV Parquet 420,826
2017 F9-P00-T00-HEADER-2017 CSV Parquet 400,757
2016 F9-P00-T00-HEADER-2016 CSV Parquet 374,387
2015 F9-P00-T00-HEADER-2015 CSV Parquet 358,413
2014 F9-P00-T00-HEADER-2014 CSV Parquet 335,036
2013 F9-P00-T00-HEADER-2013 CSV Parquet 303,230
2012 F9-P00-T00-HEADER-2012 CSV Parquet 273,438
2011 F9-P00-T00-HEADER-2011 CSV Parquet 241,552
2010 F9-P00-T00-HEADER-2010 CSV Parquet 186,351
2009 F9-P00-T00-HEADER-2009 CSV Parquet 48,781
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P00-T00-HEADER",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

F9-P00-T01-AFFILIATE-LISTING

1:M many rows per filing · tax years 2009–2025 · 30,143 rows · Data dictionary

Group return: list of subordinate organizations (AffiliateListing attachment)

Year Table CSV Parquet Rows
2025 F9-P00-T01-AFFILIATE-LISTING-2025 CSV Parquet 207
2024 F9-P00-T01-AFFILIATE-LISTING-2024 CSV Parquet 2,512
2023 F9-P00-T01-AFFILIATE-LISTING-2023 CSV Parquet 3,980
2022 F9-P00-T01-AFFILIATE-LISTING-2022 CSV Parquet 3,860
2021 F9-P00-T01-AFFILIATE-LISTING-2021 CSV Parquet 2,516
2020 F9-P00-T01-AFFILIATE-LISTING-2020 CSV Parquet 2,310
2019 F9-P00-T01-AFFILIATE-LISTING-2019 CSV Parquet 2,123
2018 F9-P00-T01-AFFILIATE-LISTING-2018 CSV Parquet 1,138
2017 F9-P00-T01-AFFILIATE-LISTING-2017 CSV Parquet 1,329
2016 F9-P00-T01-AFFILIATE-LISTING-2016 CSV Parquet 1,451
2015 F9-P00-T01-AFFILIATE-LISTING-2015 CSV Parquet 1,716
2014 F9-P00-T01-AFFILIATE-LISTING-2014 CSV Parquet 1,561
2013 F9-P00-T01-AFFILIATE-LISTING-2013 CSV Parquet 1,070
2012 F9-P00-T01-AFFILIATE-LISTING-2012 CSV Parquet 1,204
2011 F9-P00-T01-AFFILIATE-LISTING-2011 CSV Parquet 1,276
2010 F9-P00-T01-AFFILIATE-LISTING-2010 CSV Parquet 1,630
2009 F9-P00-T01-AFFILIATE-LISTING-2009 CSV Parquet 260
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P00-T01-AFFILIATE-LISTING",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P01 Part I - Summary

F9-P01-T00-SUMMARY

1:1 one row per filing · tax years 2009–2025 · 6,293,700 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P01-T00-SUMMARY-2025 CSV Parquet 205,708
2024 F9-P01-T00-SUMMARY-2024 CSV Parquet 567,161
2023 F9-P01-T00-SUMMARY-2023 CSV Parquet 566,538
2022 F9-P01-T00-SUMMARY-2022 CSV Parquet 554,076
2021 F9-P01-T00-SUMMARY-2021 CSV Parquet 537,650
2020 F9-P01-T00-SUMMARY-2020 CSV Parquet 489,004
2019 F9-P01-T00-SUMMARY-2019 CSV Parquet 435,403
2018 F9-P01-T00-SUMMARY-2018 CSV Parquet 419,877
2017 F9-P01-T00-SUMMARY-2017 CSV Parquet 400,003
2016 F9-P01-T00-SUMMARY-2016 CSV Parquet 373,742
2015 F9-P01-T00-SUMMARY-2015 CSV Parquet 357,836
2014 F9-P01-T00-SUMMARY-2014 CSV Parquet 334,544
2013 F9-P01-T00-SUMMARY-2013 CSV Parquet 302,859
2012 F9-P01-T00-SUMMARY-2012 CSV Parquet 273,131
2011 F9-P01-T00-SUMMARY-2011 CSV Parquet 241,366
2010 F9-P01-T00-SUMMARY-2010 CSV Parquet 186,075
2009 F9-P01-T00-SUMMARY-2009 CSV Parquet 48,727
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P01-T00-SUMMARY",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

F9-P01-T00-SUMMARY-EZ

1:1 one row per filing · tax years 2009–2025 · 2,170,655 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P01-T00-SUMMARY-EZ-2025 CSV Parquet 97,865
2024 F9-P01-T00-SUMMARY-EZ-2024 CSV Parquet 196,381
2023 F9-P01-T00-SUMMARY-EZ-2023 CSV Parquet 197,347
2022 F9-P01-T00-SUMMARY-EZ-2022 CSV Parquet 195,185
2021 F9-P01-T00-SUMMARY-EZ-2021 CSV Parquet 191,967
2020 F9-P01-T00-SUMMARY-EZ-2020 CSV Parquet 161,640
2019 F9-P01-T00-SUMMARY-EZ-2019 CSV Parquet 146,211
2018 F9-P01-T00-SUMMARY-EZ-2018 CSV Parquet 143,391
2017 F9-P01-T00-SUMMARY-EZ-2017 CSV Parquet 134,135
2016 F9-P01-T00-SUMMARY-EZ-2016 CSV Parquet 126,200
2015 F9-P01-T00-SUMMARY-EZ-2015 CSV Parquet 121,147
2014 F9-P01-T00-SUMMARY-EZ-2014 CSV Parquet 113,234
2013 F9-P01-T00-SUMMARY-EZ-2013 CSV Parquet 101,744
2012 F9-P01-T00-SUMMARY-EZ-2012 CSV Parquet 91,482
2011 F9-P01-T00-SUMMARY-EZ-2011 CSV Parquet 79,957
2010 F9-P01-T00-SUMMARY-EZ-2010 CSV Parquet 61,618
2009 F9-P01-T00-SUMMARY-EZ-2009 CSV Parquet 11,151
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P01-T00-SUMMARY-EZ",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P02 Part II - Signature Block

F9-P02-T00-SIGNATURE

1:1 one row per filing · tax years 2009–2025 · 6,307,836 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P02-T00-SIGNATURE-2025 CSV Parquet 206,601
2024 F9-P02-T00-SIGNATURE-2024 CSV Parquet 568,736
2023 F9-P02-T00-SIGNATURE-2023 CSV Parquet 568,214
2022 F9-P02-T00-SIGNATURE-2022 CSV Parquet 555,771
2021 F9-P02-T00-SIGNATURE-2021 CSV Parquet 539,218
2020 F9-P02-T00-SIGNATURE-2020 CSV Parquet 490,208
2019 F9-P02-T00-SIGNATURE-2019 CSV Parquet 436,317
2018 F9-P02-T00-SIGNATURE-2018 CSV Parquet 420,826
2017 F9-P02-T00-SIGNATURE-2017 CSV Parquet 400,757
2016 F9-P02-T00-SIGNATURE-2016 CSV Parquet 374,387
2015 F9-P02-T00-SIGNATURE-2015 CSV Parquet 358,413
2014 F9-P02-T00-SIGNATURE-2014 CSV Parquet 335,036
2013 F9-P02-T00-SIGNATURE-2013 CSV Parquet 303,230
2012 F9-P02-T00-SIGNATURE-2012 CSV Parquet 273,438
2011 F9-P02-T00-SIGNATURE-2011 CSV Parquet 241,552
2010 F9-P02-T00-SIGNATURE-2010 CSV Parquet 186,351
2009 F9-P02-T00-SIGNATURE-2009 CSV Parquet 48,781
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P02-T00-SIGNATURE",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P03 Part III - Statement of Program Service Accomplishments

F9-P03-T00-MISSION

1:1 one row per filing · tax years 2009–2025 · 6,307,603 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P03-T00-MISSION-2025 CSV Parquet 206,521
2024 F9-P03-T00-MISSION-2024 CSV Parquet 568,673
2023 F9-P03-T00-MISSION-2023 CSV Parquet 568,188
2022 F9-P03-T00-MISSION-2022 CSV Parquet 555,758
2021 F9-P03-T00-MISSION-2021 CSV Parquet 539,206
2020 F9-P03-T00-MISSION-2020 CSV Parquet 490,197
2019 F9-P03-T00-MISSION-2019 CSV Parquet 436,311
2018 F9-P03-T00-MISSION-2018 CSV Parquet 420,824
2017 F9-P03-T00-MISSION-2017 CSV Parquet 400,757
2016 F9-P03-T00-MISSION-2016 CSV Parquet 374,384
2015 F9-P03-T00-MISSION-2015 CSV Parquet 358,404
2014 F9-P03-T00-MISSION-2014 CSV Parquet 335,032
2013 F9-P03-T00-MISSION-2013 CSV Parquet 303,230
2012 F9-P03-T00-MISSION-2012 CSV Parquet 273,437
2011 F9-P03-T00-MISSION-2011 CSV Parquet 241,549
2010 F9-P03-T00-MISSION-2010 CSV Parquet 186,351
2009 F9-P03-T00-MISSION-2009 CSV Parquet 48,781
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P03-T00-MISSION",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

F9-P03-T00-PROGRAM-ONE

1:1 one row per filing · tax years 2009–2025 · 4,036,531 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P03-T00-PROGRAM-ONE-2025 CSV Parquet 102,869
2024 F9-P03-T00-PROGRAM-ONE-2024 CSV Parquet 360,911
2023 F9-P03-T00-PROGRAM-ONE-2023 CSV Parquet 359,351
2022 F9-P03-T00-PROGRAM-ONE-2022 CSV Parquet 349,396
2021 F9-P03-T00-PROGRAM-ONE-2021 CSV Parquet 336,489
2020 F9-P03-T00-PROGRAM-ONE-2020 CSV Parquet 320,343
2019 F9-P03-T00-PROGRAM-ONE-2019 CSV Parquet 283,694
2018 F9-P03-T00-PROGRAM-ONE-2018 CSV Parquet 271,442
2017 F9-P03-T00-PROGRAM-ONE-2017 CSV Parquet 261,612
2016 F9-P03-T00-PROGRAM-ONE-2016 CSV Parquet 243,903
2015 F9-P03-T00-PROGRAM-ONE-2015 CSV Parquet 233,519
2014 F9-P03-T00-PROGRAM-ONE-2014 CSV Parquet 218,619
2013 F9-P03-T00-PROGRAM-ONE-2013 CSV Parquet 198,855
2012 F9-P03-T00-PROGRAM-ONE-2012 CSV Parquet 179,688
2011 F9-P03-T00-PROGRAM-ONE-2011 CSV Parquet 159,504
2010 F9-P03-T00-PROGRAM-ONE-2010 CSV Parquet 123,025
2009 F9-P03-T00-PROGRAM-ONE-2009 CSV Parquet 33,311
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P03-T00-PROGRAM-ONE",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

F9-P03-T00-PROGRAM-THREE

1:1 one row per filing · tax years 2009–2025 · 862,595 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P03-T00-PROGRAM-THREE-2025 CSV Parquet 21,036
2024 F9-P03-T00-PROGRAM-THREE-2024 CSV Parquet 77,960
2023 F9-P03-T00-PROGRAM-THREE-2023 CSV Parquet 77,063
2022 F9-P03-T00-PROGRAM-THREE-2022 CSV Parquet 74,489
2021 F9-P03-T00-PROGRAM-THREE-2021 CSV Parquet 70,911
2020 F9-P03-T00-PROGRAM-THREE-2020 CSV Parquet 67,341
2019 F9-P03-T00-PROGRAM-THREE-2019 CSV Parquet 58,586
2018 F9-P03-T00-PROGRAM-THREE-2018 CSV Parquet 55,861
2017 F9-P03-T00-PROGRAM-THREE-2017 CSV Parquet 54,553
2016 F9-P03-T00-PROGRAM-THREE-2016 CSV Parquet 51,376
2015 F9-P03-T00-PROGRAM-THREE-2015 CSV Parquet 49,527
2014 F9-P03-T00-PROGRAM-THREE-2014 CSV Parquet 47,079
2013 F9-P03-T00-PROGRAM-THREE-2013 CSV Parquet 43,380
2012 F9-P03-T00-PROGRAM-THREE-2012 CSV Parquet 39,861
2011 F9-P03-T00-PROGRAM-THREE-2011 CSV Parquet 35,898
2010 F9-P03-T00-PROGRAM-THREE-2010 CSV Parquet 28,293
2009 F9-P03-T00-PROGRAM-THREE-2009 CSV Parquet 9,381
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P03-T00-PROGRAM-THREE",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

F9-P03-T00-PROGRAM-TWO

1:1 one row per filing · tax years 2009–2025 · 1,222,571 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P03-T00-PROGRAM-TWO-2025 CSV Parquet 28,797
2024 F9-P03-T00-PROGRAM-TWO-2024 CSV Parquet 108,839
2023 F9-P03-T00-PROGRAM-TWO-2023 CSV Parquet 108,006
2022 F9-P03-T00-PROGRAM-TWO-2022 CSV Parquet 104,799
2021 F9-P03-T00-PROGRAM-TWO-2021 CSV Parquet 100,661
2020 F9-P03-T00-PROGRAM-TWO-2020 CSV Parquet 95,983
2019 F9-P03-T00-PROGRAM-TWO-2019 CSV Parquet 84,302
2018 F9-P03-T00-PROGRAM-TWO-2018 CSV Parquet 80,499
2017 F9-P03-T00-PROGRAM-TWO-2017 CSV Parquet 78,414
2016 F9-P03-T00-PROGRAM-TWO-2016 CSV Parquet 73,751
2015 F9-P03-T00-PROGRAM-TWO-2015 CSV Parquet 70,979
2014 F9-P03-T00-PROGRAM-TWO-2014 CSV Parquet 67,171
2013 F9-P03-T00-PROGRAM-TWO-2013 CSV Parquet 61,858
2012 F9-P03-T00-PROGRAM-TWO-2012 CSV Parquet 56,368
2011 F9-P03-T00-PROGRAM-TWO-2011 CSV Parquet 50,470
2010 F9-P03-T00-PROGRAM-TWO-2010 CSV Parquet 39,321
2009 F9-P03-T00-PROGRAM-TWO-2009 CSV Parquet 12,353
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P03-T00-PROGRAM-TWO",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

F9-P03-T00-PROGRAMS

1:1 one row per filing · tax years 2009–2025 · 5,586,009 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P03-T00-PROGRAMS-2025 CSV Parquet 180,451
2024 F9-P03-T00-PROGRAMS-2024 CSV Parquet 506,210
2023 F9-P03-T00-PROGRAMS-2023 CSV Parquet 504,189
2022 F9-P03-T00-PROGRAMS-2022 CSV Parquet 493,033
2021 F9-P03-T00-PROGRAMS-2021 CSV Parquet 477,613
2020 F9-P03-T00-PROGRAMS-2020 CSV Parquet 433,273
2019 F9-P03-T00-PROGRAMS-2019 CSV Parquet 387,508
2018 F9-P03-T00-PROGRAMS-2018 CSV Parquet 373,616
2017 F9-P03-T00-PROGRAMS-2017 CSV Parquet 354,451
2016 F9-P03-T00-PROGRAMS-2016 CSV Parquet 331,564
2015 F9-P03-T00-PROGRAMS-2015 CSV Parquet 319,205
2014 F9-P03-T00-PROGRAMS-2014 CSV Parquet 298,901
2013 F9-P03-T00-PROGRAMS-2013 CSV Parquet 270,467
2012 F9-P03-T00-PROGRAMS-2012 CSV Parquet 238,100
2011 F9-P03-T00-PROGRAMS-2011 CSV Parquet 210,714
2010 F9-P03-T00-PROGRAMS-2010 CSV Parquet 163,756
2009 F9-P03-T00-PROGRAMS-2009 CSV Parquet 42,958
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P03-T00-PROGRAMS",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

F9-P03-T01-PROGRAMS-OTHER

1:M many rows per filing · tax years 2009–2025 · 751,492 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P03-T01-PROGRAMS-OTHER-2025 CSV Parquet 18,743
2024 F9-P03-T01-PROGRAMS-OTHER-2024 CSV Parquet 69,682
2023 F9-P03-T01-PROGRAMS-OTHER-2023 CSV Parquet 59,803
2022 F9-P03-T01-PROGRAMS-OTHER-2022 CSV Parquet 58,711
2021 F9-P03-T01-PROGRAMS-OTHER-2021 CSV Parquet 57,167
2020 F9-P03-T01-PROGRAMS-OTHER-2020 CSV Parquet 55,538
2019 F9-P03-T01-PROGRAMS-OTHER-2019 CSV Parquet 50,481
2018 F9-P03-T01-PROGRAMS-OTHER-2018 CSV Parquet 49,188
2017 F9-P03-T01-PROGRAMS-OTHER-2017 CSV Parquet 48,963
2016 F9-P03-T01-PROGRAMS-OTHER-2016 CSV Parquet 45,941
2015 F9-P03-T01-PROGRAMS-OTHER-2015 CSV Parquet 45,156
2014 F9-P03-T01-PROGRAMS-OTHER-2014 CSV Parquet 42,699
2013 F9-P03-T01-PROGRAMS-OTHER-2013 CSV Parquet 40,227
2012 F9-P03-T01-PROGRAMS-OTHER-2012 CSV Parquet 37,622
2011 F9-P03-T01-PROGRAMS-OTHER-2011 CSV Parquet 34,097
2010 F9-P03-T01-PROGRAMS-OTHER-2010 CSV Parquet 27,290
2009 F9-P03-T01-PROGRAMS-OTHER-2009 CSV Parquet 10,184
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P03-T01-PROGRAMS-OTHER",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

F9-P03-T02-PROGRAMS-EZ

1:M many rows per filing · tax years 2009–2025 · 3,440,416 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P03-T02-PROGRAMS-EZ-2025 CSV Parquet 160,733
2024 F9-P03-T02-PROGRAMS-EZ-2024 CSV Parquet 323,918
2023 F9-P03-T02-PROGRAMS-EZ-2023 CSV Parquet 323,950
2022 F9-P03-T02-PROGRAMS-EZ-2022 CSV Parquet 317,861
2021 F9-P03-T02-PROGRAMS-EZ-2021 CSV Parquet 309,715
2020 F9-P03-T02-PROGRAMS-EZ-2020 CSV Parquet 252,697
2019 F9-P03-T02-PROGRAMS-EZ-2019 CSV Parquet 227,837
2018 F9-P03-T02-PROGRAMS-EZ-2018 CSV Parquet 220,933
2017 F9-P03-T02-PROGRAMS-EZ-2017 CSV Parquet 207,327
2016 F9-P03-T02-PROGRAMS-EZ-2016 CSV Parquet 194,282
2015 F9-P03-T02-PROGRAMS-EZ-2015 CSV Parquet 186,108
2014 F9-P03-T02-PROGRAMS-EZ-2014 CSV Parquet 174,103
2013 F9-P03-T02-PROGRAMS-EZ-2013 CSV Parquet 156,547
2012 F9-P03-T02-PROGRAMS-EZ-2012 CSV Parquet 140,936
2011 F9-P03-T02-PROGRAMS-EZ-2011 CSV Parquet 123,645
2010 F9-P03-T02-PROGRAMS-EZ-2010 CSV Parquet 95,504
2009 F9-P03-T02-PROGRAMS-EZ-2009 CSV Parquet 24,320
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P03-T02-PROGRAMS-EZ",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P04 Part IV - Checklist of Required Schedules

F9-P04-T00-REQUIRED-SCHEDULES

1:1 one row per filing · tax years 2009–2025 · 6,307,836 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P04-T00-REQUIRED-SCHEDULES-2025 CSV Parquet 206,601
2024 F9-P04-T00-REQUIRED-SCHEDULES-2024 CSV Parquet 568,736
2023 F9-P04-T00-REQUIRED-SCHEDULES-2023 CSV Parquet 568,214
2022 F9-P04-T00-REQUIRED-SCHEDULES-2022 CSV Parquet 555,771
2021 F9-P04-T00-REQUIRED-SCHEDULES-2021 CSV Parquet 539,218
2020 F9-P04-T00-REQUIRED-SCHEDULES-2020 CSV Parquet 490,208
2019 F9-P04-T00-REQUIRED-SCHEDULES-2019 CSV Parquet 436,317
2018 F9-P04-T00-REQUIRED-SCHEDULES-2018 CSV Parquet 420,826
2017 F9-P04-T00-REQUIRED-SCHEDULES-2017 CSV Parquet 400,757
2016 F9-P04-T00-REQUIRED-SCHEDULES-2016 CSV Parquet 374,387
2015 F9-P04-T00-REQUIRED-SCHEDULES-2015 CSV Parquet 358,413
2014 F9-P04-T00-REQUIRED-SCHEDULES-2014 CSV Parquet 335,036
2013 F9-P04-T00-REQUIRED-SCHEDULES-2013 CSV Parquet 303,230
2012 F9-P04-T00-REQUIRED-SCHEDULES-2012 CSV Parquet 273,438
2011 F9-P04-T00-REQUIRED-SCHEDULES-2011 CSV Parquet 241,552
2010 F9-P04-T00-REQUIRED-SCHEDULES-2010 CSV Parquet 186,351
2009 F9-P04-T00-REQUIRED-SCHEDULES-2009 CSV Parquet 48,781
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P04-T00-REQUIRED-SCHEDULES",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

F9-P04-T00-REQUIRED-SCHEDULES-EZ

1:1 one row per filing · tax years 2009–2025 · 270,475 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P04-T00-REQUIRED-SCHEDULES-EZ-2025 CSV Parquet 7,265
2024 F9-P04-T00-REQUIRED-SCHEDULES-EZ-2024 CSV Parquet 11,481
2023 F9-P04-T00-REQUIRED-SCHEDULES-EZ-2023 CSV Parquet 12,007
2022 F9-P04-T00-REQUIRED-SCHEDULES-EZ-2022 CSV Parquet 10,014
2021 F9-P04-T00-REQUIRED-SCHEDULES-EZ-2021 CSV Parquet 9,441
2020 F9-P04-T00-REQUIRED-SCHEDULES-EZ-2020 CSV Parquet 8,807
2019 F9-P04-T00-REQUIRED-SCHEDULES-EZ-2019 CSV Parquet 7,581
2018 F9-P04-T00-REQUIRED-SCHEDULES-EZ-2018 CSV Parquet 29,882
2017 F9-P04-T00-REQUIRED-SCHEDULES-EZ-2017 CSV Parquet 27,382
2016 F9-P04-T00-REQUIRED-SCHEDULES-EZ-2016 CSV Parquet 26,525
2015 F9-P04-T00-REQUIRED-SCHEDULES-EZ-2015 CSV Parquet 25,346
2014 F9-P04-T00-REQUIRED-SCHEDULES-EZ-2014 CSV Parquet 22,989
2013 F9-P04-T00-REQUIRED-SCHEDULES-EZ-2013 CSV Parquet 20,427
2012 F9-P04-T00-REQUIRED-SCHEDULES-EZ-2012 CSV Parquet 18,410
2011 F9-P04-T00-REQUIRED-SCHEDULES-EZ-2011 CSV Parquet 16,916
2010 F9-P04-T00-REQUIRED-SCHEDULES-EZ-2010 CSV Parquet 12,999
2009 F9-P04-T00-REQUIRED-SCHEDULES-EZ-2009 CSV Parquet 3,003
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P04-T00-REQUIRED-SCHEDULES-EZ",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P05 Part V - Statements Regarding Other IRS Filings and Tax Compliance

F9-P05-T00-OTHER-IRS-FILING

1:1 one row per filing · tax years 2009–2025 · 6,307,836 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P05-T00-OTHER-IRS-FILING-2025 CSV Parquet 206,601
2024 F9-P05-T00-OTHER-IRS-FILING-2024 CSV Parquet 568,736
2023 F9-P05-T00-OTHER-IRS-FILING-2023 CSV Parquet 568,214
2022 F9-P05-T00-OTHER-IRS-FILING-2022 CSV Parquet 555,771
2021 F9-P05-T00-OTHER-IRS-FILING-2021 CSV Parquet 539,218
2020 F9-P05-T00-OTHER-IRS-FILING-2020 CSV Parquet 490,208
2019 F9-P05-T00-OTHER-IRS-FILING-2019 CSV Parquet 436,317
2018 F9-P05-T00-OTHER-IRS-FILING-2018 CSV Parquet 420,826
2017 F9-P05-T00-OTHER-IRS-FILING-2017 CSV Parquet 400,757
2016 F9-P05-T00-OTHER-IRS-FILING-2016 CSV Parquet 374,387
2015 F9-P05-T00-OTHER-IRS-FILING-2015 CSV Parquet 358,413
2014 F9-P05-T00-OTHER-IRS-FILING-2014 CSV Parquet 335,036
2013 F9-P05-T00-OTHER-IRS-FILING-2013 CSV Parquet 303,230
2012 F9-P05-T00-OTHER-IRS-FILING-2012 CSV Parquet 273,438
2011 F9-P05-T00-OTHER-IRS-FILING-2011 CSV Parquet 241,552
2010 F9-P05-T00-OTHER-IRS-FILING-2010 CSV Parquet 186,351
2009 F9-P05-T00-OTHER-IRS-FILING-2009 CSV Parquet 48,781
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P05-T00-OTHER-IRS-FILING",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P06 Part VI - Governance, Management, and Disclosure

F9-P06-T00-GOVERNANCE

1:1 one row per filing · tax years 2009–2025 · 6,307,836 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P06-T00-GOVERNANCE-2025 CSV Parquet 206,601
2024 F9-P06-T00-GOVERNANCE-2024 CSV Parquet 568,736
2023 F9-P06-T00-GOVERNANCE-2023 CSV Parquet 568,214
2022 F9-P06-T00-GOVERNANCE-2022 CSV Parquet 555,771
2021 F9-P06-T00-GOVERNANCE-2021 CSV Parquet 539,218
2020 F9-P06-T00-GOVERNANCE-2020 CSV Parquet 490,208
2019 F9-P06-T00-GOVERNANCE-2019 CSV Parquet 436,317
2018 F9-P06-T00-GOVERNANCE-2018 CSV Parquet 420,826
2017 F9-P06-T00-GOVERNANCE-2017 CSV Parquet 400,757
2016 F9-P06-T00-GOVERNANCE-2016 CSV Parquet 374,387
2015 F9-P06-T00-GOVERNANCE-2015 CSV Parquet 358,413
2014 F9-P06-T00-GOVERNANCE-2014 CSV Parquet 335,036
2013 F9-P06-T00-GOVERNANCE-2013 CSV Parquet 303,230
2012 F9-P06-T00-GOVERNANCE-2012 CSV Parquet 273,438
2011 F9-P06-T00-GOVERNANCE-2011 CSV Parquet 241,552
2010 F9-P06-T00-GOVERNANCE-2010 CSV Parquet 186,351
2009 F9-P06-T00-GOVERNANCE-2009 CSV Parquet 48,781
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P06-T00-GOVERNANCE",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

F9-P06-T00-GOVERNANCE-EZ

1:1 one row per filing · tax years 2009–2025 · 2,271,305 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P06-T00-GOVERNANCE-EZ-2025 CSV Parquet 103,732
2024 F9-P06-T00-GOVERNANCE-EZ-2024 CSV Parquet 207,825
2023 F9-P06-T00-GOVERNANCE-EZ-2023 CSV Parquet 208,863
2022 F9-P06-T00-GOVERNANCE-EZ-2022 CSV Parquet 206,375
2021 F9-P06-T00-GOVERNANCE-EZ-2021 CSV Parquet 202,729
2020 F9-P06-T00-GOVERNANCE-EZ-2020 CSV Parquet 169,865
2019 F9-P06-T00-GOVERNANCE-EZ-2019 CSV Parquet 152,623
2018 F9-P06-T00-GOVERNANCE-EZ-2018 CSV Parquet 149,384
2017 F9-P06-T00-GOVERNANCE-EZ-2017 CSV Parquet 139,145
2016 F9-P06-T00-GOVERNANCE-EZ-2016 CSV Parquet 130,484
2015 F9-P06-T00-GOVERNANCE-EZ-2015 CSV Parquet 124,894
2014 F9-P06-T00-GOVERNANCE-EZ-2014 CSV Parquet 116,417
2013 F9-P06-T00-GOVERNANCE-EZ-2013 CSV Parquet 104,375
2012 F9-P06-T00-GOVERNANCE-EZ-2012 CSV Parquet 93,750
2011 F9-P06-T00-GOVERNANCE-EZ-2011 CSV Parquet 82,048
2010 F9-P06-T00-GOVERNANCE-EZ-2010 CSV Parquet 63,326
2009 F9-P06-T00-GOVERNANCE-EZ-2009 CSV Parquet 15,470
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P06-T00-GOVERNANCE-EZ",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P07 Part VII - Compensation of Officers, Directors, Trustees, Key Employees, Highest Compensated Employees, and Independent Contractors

F9-P07-T00-DIR-TRUST-KEY

1:1 one row per filing · tax years 2009–2025 · 5,999,555 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P07-T00-DIR-TRUST-KEY-2025 CSV Parquet 193,267
2024 F9-P07-T00-DIR-TRUST-KEY-2024 CSV Parquet 539,878
2023 F9-P07-T00-DIR-TRUST-KEY-2023 CSV Parquet 537,600
2022 F9-P07-T00-DIR-TRUST-KEY-2022 CSV Parquet 530,155
2021 F9-P07-T00-DIR-TRUST-KEY-2021 CSV Parquet 513,695
2020 F9-P07-T00-DIR-TRUST-KEY-2020 CSV Parquet 469,091
2019 F9-P07-T00-DIR-TRUST-KEY-2019 CSV Parquet 417,636
2018 F9-P07-T00-DIR-TRUST-KEY-2018 CSV Parquet 402,551
2017 F9-P07-T00-DIR-TRUST-KEY-2017 CSV Parquet 382,914
2016 F9-P07-T00-DIR-TRUST-KEY-2016 CSV Parquet 357,136
2015 F9-P07-T00-DIR-TRUST-KEY-2015 CSV Parquet 341,588
2014 F9-P07-T00-DIR-TRUST-KEY-2014 CSV Parquet 318,983
2013 F9-P07-T00-DIR-TRUST-KEY-2013 CSV Parquet 288,373
2012 F9-P07-T00-DIR-TRUST-KEY-2012 CSV Parquet 260,071
2011 F9-P07-T00-DIR-TRUST-KEY-2011 CSV Parquet 229,876
2010 F9-P07-T00-DIR-TRUST-KEY-2010 CSV Parquet 171,033
2009 F9-P07-T00-DIR-TRUST-KEY-2009 CSV Parquet 45,708
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P07-T00-DIR-TRUST-KEY",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

F9-P07-T01-COMPENSATION

1:M many rows per filing · tax years 2009–2025 · 61,442,801 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P07-T01-COMPENSATION-2025 CSV Parquet 1,445,016
2024 F9-P07-T01-COMPENSATION-2024 CSV Parquet 5,137,965
2023 F9-P07-T01-COMPENSATION-2023 CSV Parquet 5,155,612
2022 F9-P07-T01-COMPENSATION-2022 CSV Parquet 5,077,540
2021 F9-P07-T01-COMPENSATION-2021 CSV Parquet 4,976,582
2020 F9-P07-T01-COMPENSATION-2020 CSV Parquet 4,684,044
2019 F9-P07-T01-COMPENSATION-2019 CSV Parquet 4,273,112
2018 F9-P07-T01-COMPENSATION-2018 CSV Parquet 4,142,633
2017 F9-P07-T01-COMPENSATION-2017 CSV Parquet 4,044,857
2016 F9-P07-T01-COMPENSATION-2016 CSV Parquet 3,796,202
2015 F9-P07-T01-COMPENSATION-2015 CSV Parquet 3,671,882
2014 F9-P07-T01-COMPENSATION-2014 CSV Parquet 3,478,574
2013 F9-P07-T01-COMPENSATION-2013 CSV Parquet 3,200,115
2012 F9-P07-T01-COMPENSATION-2012 CSV Parquet 2,935,949
2011 F9-P07-T01-COMPENSATION-2011 CSV Parquet 2,635,426
2010 F9-P07-T01-COMPENSATION-2010 CSV Parquet 2,082,149
2009 F9-P07-T01-COMPENSATION-2009 CSV Parquet 705,143
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P07-T01-COMPENSATION",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

F9-P07-T01-COMPENSATION-HCE-EZ

1:M many rows per filing · tax years 2009–2025 · 6,763 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P07-T01-COMPENSATION-HCE-EZ-2025 CSV Parquet 356
2024 F9-P07-T01-COMPENSATION-HCE-EZ-2024 CSV Parquet 577
2023 F9-P07-T01-COMPENSATION-HCE-EZ-2023 CSV Parquet 756
2022 F9-P07-T01-COMPENSATION-HCE-EZ-2022 CSV Parquet 690
2021 F9-P07-T01-COMPENSATION-HCE-EZ-2021 CSV Parquet 671
2020 F9-P07-T01-COMPENSATION-HCE-EZ-2020 CSV Parquet 668
2019 F9-P07-T01-COMPENSATION-HCE-EZ-2019 CSV Parquet 542
2018 F9-P07-T01-COMPENSATION-HCE-EZ-2018 CSV Parquet 489
2017 F9-P07-T01-COMPENSATION-HCE-EZ-2017 CSV Parquet 411
2016 F9-P07-T01-COMPENSATION-HCE-EZ-2016 CSV Parquet 333
2015 F9-P07-T01-COMPENSATION-HCE-EZ-2015 CSV Parquet 328
2014 F9-P07-T01-COMPENSATION-HCE-EZ-2014 CSV Parquet 251
2013 F9-P07-T01-COMPENSATION-HCE-EZ-2013 CSV Parquet 176
2012 F9-P07-T01-COMPENSATION-HCE-EZ-2012 CSV Parquet 194
2011 F9-P07-T01-COMPENSATION-HCE-EZ-2011 CSV Parquet 145
2010 F9-P07-T01-COMPENSATION-HCE-EZ-2010 CSV Parquet 114
2009 F9-P07-T01-COMPENSATION-HCE-EZ-2009 CSV Parquet 62
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P07-T01-COMPENSATION-HCE-EZ",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

F9-P07-T02-CONTRACTORS

1:M many rows per filing · tax years 2009–2025 · 1,496,585 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P07-T02-CONTRACTORS-2025 CSV Parquet 15,137
2024 F9-P07-T02-CONTRACTORS-2024 CSV Parquet 134,917
2023 F9-P07-T02-CONTRACTORS-2023 CSV Parquet 130,162
2022 F9-P07-T02-CONTRACTORS-2022 CSV Parquet 123,026
2021 F9-P07-T02-CONTRACTORS-2021 CSV Parquet 113,352
2020 F9-P07-T02-CONTRACTORS-2020 CSV Parquet 106,282
2019 F9-P07-T02-CONTRACTORS-2019 CSV Parquet 102,847
2018 F9-P07-T02-CONTRACTORS-2018 CSV Parquet 99,584
2017 F9-P07-T02-CONTRACTORS-2017 CSV Parquet 98,488
2016 F9-P07-T02-CONTRACTORS-2016 CSV Parquet 90,316
2015 F9-P07-T02-CONTRACTORS-2015 CSV Parquet 86,795
2014 F9-P07-T02-CONTRACTORS-2014 CSV Parquet 82,220
2013 F9-P07-T02-CONTRACTORS-2013 CSV Parquet 77,437
2012 F9-P07-T02-CONTRACTORS-2012 CSV Parquet 73,469
2011 F9-P07-T02-CONTRACTORS-2011 CSV Parquet 69,675
2010 F9-P07-T02-CONTRACTORS-2010 CSV Parquet 62,180
2009 F9-P07-T02-CONTRACTORS-2009 CSV Parquet 30,698
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P07-T02-CONTRACTORS",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P08 Part VIII - Statement of Revenue

F9-P08-T00-REVENUE

1:1 one row per filing · tax years 2009–2025 · 5,944,657 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P08-T00-REVENUE-2025 CSV Parquet 188,456
2024 F9-P08-T00-REVENUE-2024 CSV Parquet 533,393
2023 F9-P08-T00-REVENUE-2023 CSV Parquet 531,828
2022 F9-P08-T00-REVENUE-2022 CSV Parquet 519,087
2021 F9-P08-T00-REVENUE-2021 CSV Parquet 503,635
2020 F9-P08-T00-REVENUE-2020 CSV Parquet 459,099
2019 F9-P08-T00-REVENUE-2019 CSV Parquet 409,784
2018 F9-P08-T00-REVENUE-2018 CSV Parquet 395,977
2017 F9-P08-T00-REVENUE-2017 CSV Parquet 378,914
2016 F9-P08-T00-REVENUE-2016 CSV Parquet 354,526
2015 F9-P08-T00-REVENUE-2015 CSV Parquet 340,236
2014 F9-P08-T00-REVENUE-2014 CSV Parquet 318,968
2013 F9-P08-T00-REVENUE-2013 CSV Parquet 289,883
2012 F9-P08-T00-REVENUE-2012 CSV Parquet 262,310
2011 F9-P08-T00-REVENUE-2011 CSV Parquet 231,871
2010 F9-P08-T00-REVENUE-2010 CSV Parquet 179,037
2009 F9-P08-T00-REVENUE-2009 CSV Parquet 47,653
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P08-T00-REVENUE",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

F9-P08-T01-REVENUE-PROGRAMS

1:M many rows per filing · tax years 2009–2025 · 5,813,174 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P08-T01-REVENUE-PROGRAMS-2025 CSV Parquet 122,313
2024 F9-P08-T01-REVENUE-PROGRAMS-2024 CSV Parquet 487,426
2023 F9-P08-T01-REVENUE-PROGRAMS-2023 CSV Parquet 486,824
2022 F9-P08-T01-REVENUE-PROGRAMS-2022 CSV Parquet 473,747
2021 F9-P08-T01-REVENUE-PROGRAMS-2021 CSV Parquet 455,282
2020 F9-P08-T01-REVENUE-PROGRAMS-2020 CSV Parquet 433,019
2019 F9-P08-T01-REVENUE-PROGRAMS-2019 CSV Parquet 406,021
2018 F9-P08-T01-REVENUE-PROGRAMS-2018 CSV Parquet 398,765
2017 F9-P08-T01-REVENUE-PROGRAMS-2017 CSV Parquet 390,753
2016 F9-P08-T01-REVENUE-PROGRAMS-2016 CSV Parquet 367,381
2015 F9-P08-T01-REVENUE-PROGRAMS-2015 CSV Parquet 354,839
2014 F9-P08-T01-REVENUE-PROGRAMS-2014 CSV Parquet 333,795
2013 F9-P08-T01-REVENUE-PROGRAMS-2013 CSV Parquet 309,528
2012 F9-P08-T01-REVENUE-PROGRAMS-2012 CSV Parquet 283,866
2011 F9-P08-T01-REVENUE-PROGRAMS-2011 CSV Parquet 250,674
2010 F9-P08-T01-REVENUE-PROGRAMS-2010 CSV Parquet 196,243
2009 F9-P08-T01-REVENUE-PROGRAMS-2009 CSV Parquet 62,698
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P08-T01-REVENUE-PROGRAMS",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

F9-P08-T02-REVENUE-MISC

1:M many rows per filing · tax years 2009–2025 · 2,267,836 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P08-T02-REVENUE-MISC-2025 CSV Parquet 48,471
2024 F9-P08-T02-REVENUE-MISC-2024 CSV Parquet 190,728
2023 F9-P08-T02-REVENUE-MISC-2023 CSV Parquet 190,119
2022 F9-P08-T02-REVENUE-MISC-2022 CSV Parquet 185,237
2021 F9-P08-T02-REVENUE-MISC-2021 CSV Parquet 183,747
2020 F9-P08-T02-REVENUE-MISC-2020 CSV Parquet 178,101
2019 F9-P08-T02-REVENUE-MISC-2019 CSV Parquet 152,039
2018 F9-P08-T02-REVENUE-MISC-2018 CSV Parquet 147,603
2017 F9-P08-T02-REVENUE-MISC-2017 CSV Parquet 146,663
2016 F9-P08-T02-REVENUE-MISC-2016 CSV Parquet 137,570
2015 F9-P08-T02-REVENUE-MISC-2015 CSV Parquet 134,692
2014 F9-P08-T02-REVENUE-MISC-2014 CSV Parquet 128,582
2013 F9-P08-T02-REVENUE-MISC-2013 CSV Parquet 121,165
2012 F9-P08-T02-REVENUE-MISC-2012 CSV Parquet 112,771
2011 F9-P08-T02-REVENUE-MISC-2011 CSV Parquet 100,374
2010 F9-P08-T02-REVENUE-MISC-2010 CSV Parquet 81,912
2009 F9-P08-T02-REVENUE-MISC-2009 CSV Parquet 28,062
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P08-T02-REVENUE-MISC",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P09 Part IX - Statement of Functional Expenses

F9-P09-T00-EXPENSES

1:1 one row per filing · tax years 2009–2025 · 5,485,123 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P09-T00-EXPENSES-2025 CSV Parquet 169,759
2024 F9-P09-T00-EXPENSES-2024 CSV Parquet 490,357
2023 F9-P09-T00-EXPENSES-2023 CSV Parquet 490,013
2022 F9-P09-T00-EXPENSES-2022 CSV Parquet 479,565
2021 F9-P09-T00-EXPENSES-2021 CSV Parquet 464,714
2020 F9-P09-T00-EXPENSES-2020 CSV Parquet 423,213
2019 F9-P09-T00-EXPENSES-2019 CSV Parquet 377,761
2018 F9-P09-T00-EXPENSES-2018 CSV Parquet 364,285
2017 F9-P09-T00-EXPENSES-2017 CSV Parquet 349,049
2016 F9-P09-T00-EXPENSES-2016 CSV Parquet 326,922
2015 F9-P09-T00-EXPENSES-2015 CSV Parquet 314,410
2014 F9-P09-T00-EXPENSES-2014 CSV Parquet 294,988
2013 F9-P09-T00-EXPENSES-2013 CSV Parquet 268,654
2012 F9-P09-T00-EXPENSES-2012 CSV Parquet 243,036
2011 F9-P09-T00-EXPENSES-2011 CSV Parquet 215,744
2010 F9-P09-T00-EXPENSES-2010 CSV Parquet 168,006
2009 F9-P09-T00-EXPENSES-2009 CSV Parquet 44,647
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P09-T00-EXPENSES",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

F9-P09-T01-EXPENSES-OTHER

1:M many rows per filing · tax years 2009–2025 · 12,905,948 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P09-T01-EXPENSES-OTHER-2025 CSV Parquet 303,692
2024 F9-P09-T01-EXPENSES-OTHER-2024 CSV Parquet 1,100,723
2023 F9-P09-T01-EXPENSES-OTHER-2023 CSV Parquet 1,100,665
2022 F9-P09-T01-EXPENSES-OTHER-2022 CSV Parquet 1,072,499
2021 F9-P09-T01-EXPENSES-OTHER-2021 CSV Parquet 1,031,777
2020 F9-P09-T01-EXPENSES-OTHER-2020 CSV Parquet 984,877
2019 F9-P09-T01-EXPENSES-OTHER-2019 CSV Parquet 898,124
2018 F9-P09-T01-EXPENSES-OTHER-2018 CSV Parquet 869,115
2017 F9-P09-T01-EXPENSES-OTHER-2017 CSV Parquet 844,447
2016 F9-P09-T01-EXPENSES-OTHER-2016 CSV Parquet 792,168
2015 F9-P09-T01-EXPENSES-OTHER-2015 CSV Parquet 762,060
2014 F9-P09-T01-EXPENSES-OTHER-2014 CSV Parquet 717,503
2013 F9-P09-T01-EXPENSES-OTHER-2013 CSV Parquet 657,065
2012 F9-P09-T01-EXPENSES-OTHER-2012 CSV Parquet 597,052
2011 F9-P09-T01-EXPENSES-OTHER-2011 CSV Parquet 545,801
2010 F9-P09-T01-EXPENSES-OTHER-2010 CSV Parquet 492,348
2009 F9-P09-T01-EXPENSES-OTHER-2009 CSV Parquet 136,032
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P09-T01-EXPENSES-OTHER",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P10 Part X - Balance Sheet

F9-P10-T00-BALANCE-SHEET

1:1 one row per filing · tax years 2009–2025 · 6,307,836 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P10-T00-BALANCE-SHEET-2025 CSV Parquet 206,601
2024 F9-P10-T00-BALANCE-SHEET-2024 CSV Parquet 568,736
2023 F9-P10-T00-BALANCE-SHEET-2023 CSV Parquet 568,214
2022 F9-P10-T00-BALANCE-SHEET-2022 CSV Parquet 555,771
2021 F9-P10-T00-BALANCE-SHEET-2021 CSV Parquet 539,218
2020 F9-P10-T00-BALANCE-SHEET-2020 CSV Parquet 490,208
2019 F9-P10-T00-BALANCE-SHEET-2019 CSV Parquet 436,317
2018 F9-P10-T00-BALANCE-SHEET-2018 CSV Parquet 420,826
2017 F9-P10-T00-BALANCE-SHEET-2017 CSV Parquet 400,757
2016 F9-P10-T00-BALANCE-SHEET-2016 CSV Parquet 374,387
2015 F9-P10-T00-BALANCE-SHEET-2015 CSV Parquet 358,413
2014 F9-P10-T00-BALANCE-SHEET-2014 CSV Parquet 335,036
2013 F9-P10-T00-BALANCE-SHEET-2013 CSV Parquet 303,230
2012 F9-P10-T00-BALANCE-SHEET-2012 CSV Parquet 273,438
2011 F9-P10-T00-BALANCE-SHEET-2011 CSV Parquet 241,552
2010 F9-P10-T00-BALANCE-SHEET-2010 CSV Parquet 186,351
2009 F9-P10-T00-BALANCE-SHEET-2009 CSV Parquet 48,781
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P10-T00-BALANCE-SHEET",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P11 Part XI - Reconciliation of Net Assets

F9-P11-T00-ASSETS

1:1 one row per filing · tax years 2009–2025 · 4,835,913 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P11-T00-ASSETS-2025 CSV Parquet 143,089
2024 F9-P11-T00-ASSETS-2024 CSV Parquet 443,094
2023 F9-P11-T00-ASSETS-2023 CSV Parquet 440,614
2022 F9-P11-T00-ASSETS-2022 CSV Parquet 430,210
2021 F9-P11-T00-ASSETS-2021 CSV Parquet 416,834
2020 F9-P11-T00-ASSETS-2020 CSV Parquet 381,667
2019 F9-P11-T00-ASSETS-2019 CSV Parquet 336,113
2018 F9-P11-T00-ASSETS-2018 CSV Parquet 321,229
2017 F9-P11-T00-ASSETS-2017 CSV Parquet 308,778
2016 F9-P11-T00-ASSETS-2016 CSV Parquet 287,974
2015 F9-P11-T00-ASSETS-2015 CSV Parquet 276,113
2014 F9-P11-T00-ASSETS-2014 CSV Parquet 258,537
2013 F9-P11-T00-ASSETS-2013 CSV Parquet 235,479
2012 F9-P11-T00-ASSETS-2012 CSV Parquet 213,508
2011 F9-P11-T00-ASSETS-2011 CSV Parquet 190,454
2010 F9-P11-T00-ASSETS-2010 CSV Parquet 148,310
2009 F9-P11-T00-ASSETS-2009 CSV Parquet 3,910
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P11-T00-ASSETS",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P12 Part XII - Financial Statements and Reporting

F9-P12-T00-FINANCIAL-REPORTING

1:1 one row per filing · tax years 2009–2025 · 6,299,263 rows · Data dictionary

Year Table CSV Parquet Rows
2025 F9-P12-T00-FINANCIAL-REPORTING-2025 CSV Parquet 206,061
2024 F9-P12-T00-FINANCIAL-REPORTING-2024 CSV Parquet 567,767
2023 F9-P12-T00-FINANCIAL-REPORTING-2023 CSV Parquet 567,273
2022 F9-P12-T00-FINANCIAL-REPORTING-2022 CSV Parquet 554,863
2021 F9-P12-T00-FINANCIAL-REPORTING-2021 CSV Parquet 538,347
2020 F9-P12-T00-FINANCIAL-REPORTING-2020 CSV Parquet 489,540
2019 F9-P12-T00-FINANCIAL-REPORTING-2019 CSV Parquet 435,670
2018 F9-P12-T00-FINANCIAL-REPORTING-2018 CSV Parquet 420,210
2017 F9-P12-T00-FINANCIAL-REPORTING-2017 CSV Parquet 400,248
2016 F9-P12-T00-FINANCIAL-REPORTING-2016 CSV Parquet 373,927
2015 F9-P12-T00-FINANCIAL-REPORTING-2015 CSV Parquet 358,030
2014 F9-P12-T00-FINANCIAL-REPORTING-2014 CSV Parquet 334,707
2013 F9-P12-T00-FINANCIAL-REPORTING-2013 CSV Parquet 303,000
2012 F9-P12-T00-FINANCIAL-REPORTING-2012 CSV Parquet 273,216
2011 F9-P12-T00-FINANCIAL-REPORTING-2011 CSV Parquet 241,387
2010 F9-P12-T00-FINANCIAL-REPORTING-2010 CSV Parquet 186,257
2009 F9-P12-T00-FINANCIAL-REPORTING-2009 CSV Parquet 48,760
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "F9-P12-T00-FINANCIAL-REPORTING",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

Schedule A: Public Charity Status and Public Support

P01 Part I - Reason for Public Charity Status

SA-P01-T00-PUBLIC-CHARITY-STATUS

1:1 one row per filing · tax years 2009–2025 · 4,852,183 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SA-P01-T00-PUBLIC-CHARITY-STATUS-2025 CSV Parquet 159,827
2024 SA-P01-T00-PUBLIC-CHARITY-STATUS-2024 CSV Parquet 445,975
2023 SA-P01-T00-PUBLIC-CHARITY-STATUS-2023 CSV Parquet 443,386
2022 SA-P01-T00-PUBLIC-CHARITY-STATUS-2022 CSV Parquet 431,477
2021 SA-P01-T00-PUBLIC-CHARITY-STATUS-2021 CSV Parquet 415,591
2020 SA-P01-T00-PUBLIC-CHARITY-STATUS-2020 CSV Parquet 376,119
2019 SA-P01-T00-PUBLIC-CHARITY-STATUS-2019 CSV Parquet 337,164
2018 SA-P01-T00-PUBLIC-CHARITY-STATUS-2018 CSV Parquet 323,545
2017 SA-P01-T00-PUBLIC-CHARITY-STATUS-2017 CSV Parquet 307,680
2016 SA-P01-T00-PUBLIC-CHARITY-STATUS-2016 CSV Parquet 285,799
2015 SA-P01-T00-PUBLIC-CHARITY-STATUS-2015 CSV Parquet 272,862
2014 SA-P01-T00-PUBLIC-CHARITY-STATUS-2014 CSV Parquet 254,078
2013 SA-P01-T00-PUBLIC-CHARITY-STATUS-2013 CSV Parquet 229,399
2012 SA-P01-T00-PUBLIC-CHARITY-STATUS-2012 CSV Parquet 206,478
2011 SA-P01-T00-PUBLIC-CHARITY-STATUS-2011 CSV Parquet 182,404
2010 SA-P01-T00-PUBLIC-CHARITY-STATUS-2010 CSV Parquet 140,561
2009 SA-P01-T00-PUBLIC-CHARITY-STATUS-2009 CSV Parquet 39,838
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SA-P01-T00-PUBLIC-CHARITY-STATUS",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SA-P01-T01-PUBLIC-CHARITY-STATUS

1:M many rows per filing · tax years 2009–2025 · 543,499 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SA-P01-T01-PUBLIC-CHARITY-STATUS-2025 CSV Parquet 9,243
2024 SA-P01-T01-PUBLIC-CHARITY-STATUS-2024 CSV Parquet 45,800
2023 SA-P01-T01-PUBLIC-CHARITY-STATUS-2023 CSV Parquet 46,279
2022 SA-P01-T01-PUBLIC-CHARITY-STATUS-2022 CSV Parquet 45,700
2021 SA-P01-T01-PUBLIC-CHARITY-STATUS-2021 CSV Parquet 45,679
2020 SA-P01-T01-PUBLIC-CHARITY-STATUS-2020 CSV Parquet 43,554
2019 SA-P01-T01-PUBLIC-CHARITY-STATUS-2019 CSV Parquet 38,861
2018 SA-P01-T01-PUBLIC-CHARITY-STATUS-2018 CSV Parquet 36,130
2017 SA-P01-T01-PUBLIC-CHARITY-STATUS-2017 CSV Parquet 34,594
2016 SA-P01-T01-PUBLIC-CHARITY-STATUS-2016 CSV Parquet 32,688
2015 SA-P01-T01-PUBLIC-CHARITY-STATUS-2015 CSV Parquet 31,313
2014 SA-P01-T01-PUBLIC-CHARITY-STATUS-2014 CSV Parquet 30,308
2013 SA-P01-T01-PUBLIC-CHARITY-STATUS-2013 CSV Parquet 27,438
2012 SA-P01-T01-PUBLIC-CHARITY-STATUS-2012 CSV Parquet 26,310
2011 SA-P01-T01-PUBLIC-CHARITY-STATUS-2011 CSV Parquet 23,265
2010 SA-P01-T01-PUBLIC-CHARITY-STATUS-2010 CSV Parquet 19,468
2009 SA-P01-T01-PUBLIC-CHARITY-STATUS-2009 CSV Parquet 6,869
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SA-P01-T01-PUBLIC-CHARITY-STATUS",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SA-P01-T02-HOSPITAL-NAME-ADDRESS

1:M many rows per filing · tax years 2009–2025 · 6,792 rows · Data dictionary

Schedule A Part I line 3: hospital name and address (one row per hospital)

Year Table CSV Parquet Rows
2025 SA-P01-T02-HOSPITAL-NAME-ADDRESS-2025 CSV Parquet 157
2024 SA-P01-T02-HOSPITAL-NAME-ADDRESS-2024 CSV Parquet 503
2023 SA-P01-T02-HOSPITAL-NAME-ADDRESS-2023 CSV Parquet 507
2022 SA-P01-T02-HOSPITAL-NAME-ADDRESS-2022 CSV Parquet 507
2021 SA-P01-T02-HOSPITAL-NAME-ADDRESS-2021 CSV Parquet 509
2020 SA-P01-T02-HOSPITAL-NAME-ADDRESS-2020 CSV Parquet 483
2019 SA-P01-T02-HOSPITAL-NAME-ADDRESS-2019 CSV Parquet 473
2018 SA-P01-T02-HOSPITAL-NAME-ADDRESS-2018 CSV Parquet 459
2017 SA-P01-T02-HOSPITAL-NAME-ADDRESS-2017 CSV Parquet 464
2016 SA-P01-T02-HOSPITAL-NAME-ADDRESS-2016 CSV Parquet 445
2015 SA-P01-T02-HOSPITAL-NAME-ADDRESS-2015 CSV Parquet 450
2014 SA-P01-T02-HOSPITAL-NAME-ADDRESS-2014 CSV Parquet 448
2013 SA-P01-T02-HOSPITAL-NAME-ADDRESS-2013 CSV Parquet 397
2012 SA-P01-T02-HOSPITAL-NAME-ADDRESS-2012 CSV Parquet 338
2011 SA-P01-T02-HOSPITAL-NAME-ADDRESS-2011 CSV Parquet 321
2010 SA-P01-T02-HOSPITAL-NAME-ADDRESS-2010 CSV Parquet 237
2009 SA-P01-T02-HOSPITAL-NAME-ADDRESS-2009 CSV Parquet 94
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SA-P01-T02-HOSPITAL-NAME-ADDRESS",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SA-P01-T03-AGRI-RESEARCH-UNIV

1:M many rows per filing · tax years 2016–2025 · 303 rows · Data dictionary

Schedule A Part I line 9: college or university of an agricultural research organization (one row per institution)

Year Table CSV Parquet Rows
2025 SA-P01-T03-AGRI-RESEARCH-UNIV-2025 CSV Parquet 23
2024 SA-P01-T03-AGRI-RESEARCH-UNIV-2024 CSV Parquet 44
2023 SA-P01-T03-AGRI-RESEARCH-UNIV-2023 CSV Parquet 38
2022 SA-P01-T03-AGRI-RESEARCH-UNIV-2022 CSV Parquet 34
2021 SA-P01-T03-AGRI-RESEARCH-UNIV-2021 CSV Parquet 35
2020 SA-P01-T03-AGRI-RESEARCH-UNIV-2020 CSV Parquet 33
2019 SA-P01-T03-AGRI-RESEARCH-UNIV-2019 CSV Parquet 22
2018 SA-P01-T03-AGRI-RESEARCH-UNIV-2018 CSV Parquet 23
2017 SA-P01-T03-AGRI-RESEARCH-UNIV-2017 CSV Parquet 25
2016 SA-P01-T03-AGRI-RESEARCH-UNIV-2016 CSV Parquet 26
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SA-P01-T03-AGRI-RESEARCH-UNIV",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P02 Part II - Support Schedule for Organizations Described in Sections 170(b)(1)(A)(iv) and 170(b)(1)(A)(vi)

SA-P02-T00-SUPPORT_SCHEDULE_170

1:1 one row per filing · tax years 2009–2025 · 2,407,676 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SA-P02-T00-SUPPORT_SCHEDULE_170-2025 CSV Parquet 75,411
2024 SA-P02-T00-SUPPORT_SCHEDULE_170-2024 CSV Parquet 211,872
2023 SA-P02-T00-SUPPORT_SCHEDULE_170-2023 CSV Parquet 211,147
2022 SA-P02-T00-SUPPORT_SCHEDULE_170-2022 CSV Parquet 205,951
2021 SA-P02-T00-SUPPORT_SCHEDULE_170-2021 CSV Parquet 205,266
2020 SA-P02-T00-SUPPORT_SCHEDULE_170-2020 CSV Parquet 187,223
2019 SA-P02-T00-SUPPORT_SCHEDULE_170-2019 CSV Parquet 170,535
2018 SA-P02-T00-SUPPORT_SCHEDULE_170-2018 CSV Parquet 164,144
2017 SA-P02-T00-SUPPORT_SCHEDULE_170-2017 CSV Parquet 156,500
2016 SA-P02-T00-SUPPORT_SCHEDULE_170-2016 CSV Parquet 145,878
2015 SA-P02-T00-SUPPORT_SCHEDULE_170-2015 CSV Parquet 139,095
2014 SA-P02-T00-SUPPORT_SCHEDULE_170-2014 CSV Parquet 129,790
2013 SA-P02-T00-SUPPORT_SCHEDULE_170-2013 CSV Parquet 116,664
2012 SA-P02-T00-SUPPORT_SCHEDULE_170-2012 CSV Parquet 105,643
2011 SA-P02-T00-SUPPORT_SCHEDULE_170-2011 CSV Parquet 93,227
2010 SA-P02-T00-SUPPORT_SCHEDULE_170-2010 CSV Parquet 71,410
2009 SA-P02-T00-SUPPORT_SCHEDULE_170-2009 CSV Parquet 17,920
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SA-P02-T00-SUPPORT_SCHEDULE_170",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P03 Part III - Support Schedule for Organizations Described in Section 509(a)(2)

SA-P03-T00-SUPPORT_SCHEDULE_509

1:1 one row per filing · tax years 2009–2025 · 2,423,651 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SA-P03-T00-SUPPORT_SCHEDULE_509-2025 CSV Parquet 88,468
2024 SA-P03-T00-SUPPORT_SCHEDULE_509-2024 CSV Parquet 221,519
2023 SA-P03-T00-SUPPORT_SCHEDULE_509-2023 CSV Parquet 220,061
2022 SA-P03-T00-SUPPORT_SCHEDULE_509-2022 CSV Parquet 213,956
2021 SA-P03-T00-SUPPORT_SCHEDULE_509-2021 CSV Parquet 205,366
2020 SA-P03-T00-SUPPORT_SCHEDULE_509-2020 CSV Parquet 182,726
2019 SA-P03-T00-SUPPORT_SCHEDULE_509-2019 CSV Parquet 170,985
2018 SA-P03-T00-SUPPORT_SCHEDULE_509-2018 CSV Parquet 165,469
2017 SA-P03-T00-SUPPORT_SCHEDULE_509-2017 CSV Parquet 155,505
2016 SA-P03-T00-SUPPORT_SCHEDULE_509-2016 CSV Parquet 144,599
2015 SA-P03-T00-SUPPORT_SCHEDULE_509-2015 CSV Parquet 138,227
2014 SA-P03-T00-SUPPORT_SCHEDULE_509-2014 CSV Parquet 127,486
2013 SA-P03-T00-SUPPORT_SCHEDULE_509-2013 CSV Parquet 113,969
2012 SA-P03-T00-SUPPORT_SCHEDULE_509-2012 CSV Parquet 101,792
2011 SA-P03-T00-SUPPORT_SCHEDULE_509-2011 CSV Parquet 89,438
2010 SA-P03-T00-SUPPORT_SCHEDULE_509-2010 CSV Parquet 68,462
2009 SA-P03-T00-SUPPORT_SCHEDULE_509-2009 CSV Parquet 15,623
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SA-P03-T00-SUPPORT_SCHEDULE_509",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P04 Part IV - Supporting Organizations

SA-P04-T00-SUPPORT-ORGS

1:1 one row per filing · tax years 2014–2025 · 230,536 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SA-P04-T00-SUPPORT-ORGS-2025 CSV Parquet 5,799
2024 SA-P04-T00-SUPPORT-ORGS-2024 CSV Parquet 23,657
2023 SA-P04-T00-SUPPORT-ORGS-2023 CSV Parquet 23,791
2022 SA-P04-T00-SUPPORT-ORGS-2022 CSV Parquet 23,827
2021 SA-P04-T00-SUPPORT-ORGS-2021 CSV Parquet 23,572
2020 SA-P04-T00-SUPPORT-ORGS-2020 CSV Parquet 22,246
2019 SA-P04-T00-SUPPORT-ORGS-2019 CSV Parquet 19,900
2018 SA-P04-T00-SUPPORT-ORGS-2018 CSV Parquet 18,813
2017 SA-P04-T00-SUPPORT-ORGS-2017 CSV Parquet 18,411
2016 SA-P04-T00-SUPPORT-ORGS-2016 CSV Parquet 17,381
2015 SA-P04-T00-SUPPORT-ORGS-2015 CSV Parquet 16,770
2014 SA-P04-T00-SUPPORT-ORGS-2014 CSV Parquet 16,369
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SA-P04-T00-SUPPORT-ORGS",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P05 Part V - Type III Non-Functionally Integrated 509(a)(3) Supporting Organizations

SA-P05-T00-SUPPORT-ORGS

1:1 one row per filing · tax years 2014–2025 · 54,891 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SA-P05-T00-SUPPORT-ORGS-2025 CSV Parquet 6,125
2024 SA-P05-T00-SUPPORT-ORGS-2024 CSV Parquet 9,073
2023 SA-P05-T00-SUPPORT-ORGS-2023 CSV Parquet 6,846
2022 SA-P05-T00-SUPPORT-ORGS-2022 CSV Parquet 5,835
2021 SA-P05-T00-SUPPORT-ORGS-2021 CSV Parquet 5,265
2020 SA-P05-T00-SUPPORT-ORGS-2020 CSV Parquet 4,942
2019 SA-P05-T00-SUPPORT-ORGS-2019 CSV Parquet 3,888
2018 SA-P05-T00-SUPPORT-ORGS-2018 CSV Parquet 2,920
2017 SA-P05-T00-SUPPORT-ORGS-2017 CSV Parquet 2,892
2016 SA-P05-T00-SUPPORT-ORGS-2016 CSV Parquet 2,210
2015 SA-P05-T00-SUPPORT-ORGS-2015 CSV Parquet 2,090
2014 SA-P05-T00-SUPPORT-ORGS-2014 CSV Parquet 2,805
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SA-P05-T00-SUPPORT-ORGS",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P06 Part VI - Supplemental Information

SA-P06-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2009–2025 · 731,930 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SA-P06-T99-SUPPLEMENTAL-INFO-2025 CSV Parquet 20,378
2024 SA-P06-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 74,415
2023 SA-P06-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 75,081
2022 SA-P06-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 74,042
2021 SA-P06-T99-SUPPLEMENTAL-INFO-2021 CSV Parquet 73,399
2020 SA-P06-T99-SUPPLEMENTAL-INFO-2020 CSV Parquet 65,559
2019 SA-P06-T99-SUPPLEMENTAL-INFO-2019 CSV Parquet 54,866
2018 SA-P06-T99-SUPPLEMENTAL-INFO-2018 CSV Parquet 50,240
2017 SA-P06-T99-SUPPLEMENTAL-INFO-2017 CSV Parquet 47,873
2016 SA-P06-T99-SUPPLEMENTAL-INFO-2016 CSV Parquet 44,784
2015 SA-P06-T99-SUPPLEMENTAL-INFO-2015 CSV Parquet 42,214
2014 SA-P06-T99-SUPPLEMENTAL-INFO-2014 CSV Parquet 37,989
2013 SA-P06-T99-SUPPLEMENTAL-INFO-2013 CSV Parquet 44,629
2012 SA-P06-T99-SUPPLEMENTAL-INFO-2012 CSV Parquet 10,014
2011 SA-P06-T99-SUPPLEMENTAL-INFO-2011 CSV Parquet 7,840
2010 SA-P06-T99-SUPPLEMENTAL-INFO-2010 CSV Parquet 6,370
2009 SA-P06-T99-SUPPLEMENTAL-INFO-2009 CSV Parquet 2,237
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SA-P06-T99-SUPPLEMENTAL-INFO",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

Schedule B: Schedule of Contributors

P01 Part I - Contributors

SB-P01-T01-CONTRIBUTORS

1:M many rows per filing · tax years 2009–2025 · 2,382,640 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SB-P01-T01-CONTRIBUTORS-2025 CSV Parquet 74,549
2024 SB-P01-T01-CONTRIBUTORS-2024 CSV Parquet 241,718
2023 SB-P01-T01-CONTRIBUTORS-2023 CSV Parquet 240,270
2022 SB-P01-T01-CONTRIBUTORS-2022 CSV Parquet 234,663
2021 SB-P01-T01-CONTRIBUTORS-2021 CSV Parquet 227,976
2020 SB-P01-T01-CONTRIBUTORS-2020 CSV Parquet 205,320
2019 SB-P01-T01-CONTRIBUTORS-2019 CSV Parquet 181,028
2018 SB-P01-T01-CONTRIBUTORS-2018 CSV Parquet 102,958
2017 SB-P01-T01-CONTRIBUTORS-2017 CSV Parquet 1,632
2016 SB-P01-T01-CONTRIBUTORS-2016 CSV Parquet 153,877
2015 SB-P01-T01-CONTRIBUTORS-2015 CSV Parquet 146,807
2014 SB-P01-T01-CONTRIBUTORS-2014 CSV Parquet 136,844
2013 SB-P01-T01-CONTRIBUTORS-2013 CSV Parquet 124,313
2012 SB-P01-T01-CONTRIBUTORS-2012 CSV Parquet 112,124
2011 SB-P01-T01-CONTRIBUTORS-2011 CSV Parquet 98,962
2010 SB-P01-T01-CONTRIBUTORS-2010 CSV Parquet 75,866
2009 SB-P01-T01-CONTRIBUTORS-2009 CSV Parquet 23,733
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SB-P01-T01-CONTRIBUTORS",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

Schedule C: Political Campaign and Lobbying Activities

P01 Part I - Political Campaign Activities (I-A, I-B, I-C)

SC-P01-T00-LOBBY

1:1 one row per filing · tax years 2009–2025 · 100,831 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SC-P01-T00-LOBBY-2025 CSV Parquet 2,204
2024 SC-P01-T00-LOBBY-2024 CSV Parquet 8,027
2023 SC-P01-T00-LOBBY-2023 CSV Parquet 7,884
2022 SC-P01-T00-LOBBY-2022 CSV Parquet 7,792
2021 SC-P01-T00-LOBBY-2021 CSV Parquet 7,476
2020 SC-P01-T00-LOBBY-2020 CSV Parquet 7,429
2019 SC-P01-T00-LOBBY-2019 CSV Parquet 6,673
2018 SC-P01-T00-LOBBY-2018 CSV Parquet 6,784
2017 SC-P01-T00-LOBBY-2017 CSV Parquet 6,517
2016 SC-P01-T00-LOBBY-2016 CSV Parquet 6,267
2015 SC-P01-T00-LOBBY-2015 CSV Parquet 5,793
2014 SC-P01-T00-LOBBY-2014 CSV Parquet 5,583
2013 SC-P01-T00-LOBBY-2013 CSV Parquet 4,907
2012 SC-P01-T00-LOBBY-2012 CSV Parquet 4,539
2011 SC-P01-T00-LOBBY-2011 CSV Parquet 7,457
2010 SC-P01-T00-LOBBY-2010 CSV Parquet 4,540
2009 SC-P01-T00-LOBBY-2009 CSV Parquet 959
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SC-P01-T00-LOBBY",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SC-P01-T01-POLITICAL-ORGS-INFO

1:M many rows per filing · tax years 2009–2025 · 108,180 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SC-P01-T01-POLITICAL-ORGS-INFO-2025 CSV Parquet 2,389
2024 SC-P01-T01-POLITICAL-ORGS-INFO-2024 CSV Parquet 10,789
2023 SC-P01-T01-POLITICAL-ORGS-INFO-2023 CSV Parquet 9,391
2022 SC-P01-T01-POLITICAL-ORGS-INFO-2022 CSV Parquet 10,597
2021 SC-P01-T01-POLITICAL-ORGS-INFO-2021 CSV Parquet 7,810
2020 SC-P01-T01-POLITICAL-ORGS-INFO-2020 CSV Parquet 8,717
2019 SC-P01-T01-POLITICAL-ORGS-INFO-2019 CSV Parquet 7,210
2018 SC-P01-T01-POLITICAL-ORGS-INFO-2018 CSV Parquet 8,379
2017 SC-P01-T01-POLITICAL-ORGS-INFO-2017 CSV Parquet 6,585
2016 SC-P01-T01-POLITICAL-ORGS-INFO-2016 CSV Parquet 7,480
2015 SC-P01-T01-POLITICAL-ORGS-INFO-2015 CSV Parquet 6,019
2014 SC-P01-T01-POLITICAL-ORGS-INFO-2014 CSV Parquet 6,040
2013 SC-P01-T01-POLITICAL-ORGS-INFO-2013 CSV Parquet 5,128
2012 SC-P01-T01-POLITICAL-ORGS-INFO-2012 CSV Parquet 4,688
2011 SC-P01-T01-POLITICAL-ORGS-INFO-2011 CSV Parquet 3,312
2010 SC-P01-T01-POLITICAL-ORGS-INFO-2010 CSV Parquet 3,378
2009 SC-P01-T01-POLITICAL-ORGS-INFO-2009 CSV Parquet 268
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SC-P01-T01-POLITICAL-ORGS-INFO",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P02 Part II - Lobbying Activities (II-A electing 501(h), II-B non-electing)

SC-P02-T00-LOBBY

1:1 one row per filing · tax years 2009–2025 · 196,138 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SC-P02-T00-LOBBY-2025 CSV Parquet 2,097
2024 SC-P02-T00-LOBBY-2024 CSV Parquet 15,121
2023 SC-P02-T00-LOBBY-2023 CSV Parquet 14,957
2022 SC-P02-T00-LOBBY-2022 CSV Parquet 14,601
2021 SC-P02-T00-LOBBY-2021 CSV Parquet 14,132
2020 SC-P02-T00-LOBBY-2020 CSV Parquet 13,750
2019 SC-P02-T00-LOBBY-2019 CSV Parquet 12,962
2018 SC-P02-T00-LOBBY-2018 CSV Parquet 12,708
2017 SC-P02-T00-LOBBY-2017 CSV Parquet 12,700
2016 SC-P02-T00-LOBBY-2016 CSV Parquet 11,923
2015 SC-P02-T00-LOBBY-2015 CSV Parquet 11,743
2014 SC-P02-T00-LOBBY-2014 CSV Parquet 11,269
2013 SC-P02-T00-LOBBY-2013 CSV Parquet 10,666
2012 SC-P02-T00-LOBBY-2012 CSV Parquet 10,240
2011 SC-P02-T00-LOBBY-2011 CSV Parquet 14,038
2010 SC-P02-T00-LOBBY-2010 CSV Parquet 9,374
2009 SC-P02-T00-LOBBY-2009 CSV Parquet 3,857
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SC-P02-T00-LOBBY",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SC-P02-T01-AFFILIATED-GROUP

1:M many rows per filing · tax years 2009–2025 · 21,091 rows · Data dictionary

Schedule C Part II-A: affiliated group members (AffiliatedGroupSchedule)

Year Table CSV Parquet Rows
2025 SC-P02-T01-AFFILIATED-GROUP-2025 CSV Parquet 6
2024 SC-P02-T01-AFFILIATED-GROUP-2024 CSV Parquet 2,376
2023 SC-P02-T01-AFFILIATED-GROUP-2023 CSV Parquet 2,322
2022 SC-P02-T01-AFFILIATED-GROUP-2022 CSV Parquet 2,364
2021 SC-P02-T01-AFFILIATED-GROUP-2021 CSV Parquet 2,297
2020 SC-P02-T01-AFFILIATED-GROUP-2020 CSV Parquet 2,314
2019 SC-P02-T01-AFFILIATED-GROUP-2019 CSV Parquet 2,094
2018 SC-P02-T01-AFFILIATED-GROUP-2018 CSV Parquet 969
2017 SC-P02-T01-AFFILIATED-GROUP-2017 CSV Parquet 1,037
2016 SC-P02-T01-AFFILIATED-GROUP-2016 CSV Parquet 979
2015 SC-P02-T01-AFFILIATED-GROUP-2015 CSV Parquet 766
2014 SC-P02-T01-AFFILIATED-GROUP-2014 CSV Parquet 702
2013 SC-P02-T01-AFFILIATED-GROUP-2013 CSV Parquet 652
2012 SC-P02-T01-AFFILIATED-GROUP-2012 CSV Parquet 761
2011 SC-P02-T01-AFFILIATED-GROUP-2011 CSV Parquet 554
2010 SC-P02-T01-AFFILIATED-GROUP-2010 CSV Parquet 543
2009 SC-P02-T01-AFFILIATED-GROUP-2009 CSV Parquet 355
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SC-P02-T01-AFFILIATED-GROUP",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P03 Part III - Lobbying and Political Activities of Section 501(c)(4), (5), and (6) Organizations (III-A, III-B)

SC-P03-T00-LOBBY

1:1 one row per filing · tax years 2009–2025 · 261,090 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SC-P03-T00-LOBBY-2025 CSV Parquet 7,253
2024 SC-P03-T00-LOBBY-2024 CSV Parquet 22,407
2023 SC-P03-T00-LOBBY-2023 CSV Parquet 22,686
2022 SC-P03-T00-LOBBY-2022 CSV Parquet 22,289
2021 SC-P03-T00-LOBBY-2021 CSV Parquet 21,861
2020 SC-P03-T00-LOBBY-2020 CSV Parquet 21,221
2019 SC-P03-T00-LOBBY-2019 CSV Parquet 19,048
2018 SC-P03-T00-LOBBY-2018 CSV Parquet 18,162
2017 SC-P03-T00-LOBBY-2017 CSV Parquet 17,250
2016 SC-P03-T00-LOBBY-2016 CSV Parquet 16,096
2015 SC-P03-T00-LOBBY-2015 CSV Parquet 15,242
2014 SC-P03-T00-LOBBY-2014 CSV Parquet 14,193
2013 SC-P03-T00-LOBBY-2013 CSV Parquet 12,456
2012 SC-P03-T00-LOBBY-2012 CSV Parquet 10,810
2011 SC-P03-T00-LOBBY-2011 CSV Parquet 11,684
2010 SC-P03-T00-LOBBY-2010 CSV Parquet 7,368
2009 SC-P03-T00-LOBBY-2009 CSV Parquet 1,064
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SC-P03-T00-LOBBY",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P04 Part IV - Supplemental Information

SC-P04-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2009–2025 · 155,781 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SC-P04-T99-SUPPLEMENTAL-INFO-2025 CSV Parquet 2,033
2024 SC-P04-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 13,190
2023 SC-P04-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 12,783
2022 SC-P04-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 12,865
2021 SC-P04-T99-SUPPLEMENTAL-INFO-2021 CSV Parquet 12,252
2020 SC-P04-T99-SUPPLEMENTAL-INFO-2020 CSV Parquet 11,749
2019 SC-P04-T99-SUPPLEMENTAL-INFO-2019 CSV Parquet 10,825
2018 SC-P04-T99-SUPPLEMENTAL-INFO-2018 CSV Parquet 10,611
2017 SC-P04-T99-SUPPLEMENTAL-INFO-2017 CSV Parquet 10,745
2016 SC-P04-T99-SUPPLEMENTAL-INFO-2016 CSV Parquet 10,144
2015 SC-P04-T99-SUPPLEMENTAL-INFO-2015 CSV Parquet 9,709
2014 SC-P04-T99-SUPPLEMENTAL-INFO-2014 CSV Parquet 8,993
2013 SC-P04-T99-SUPPLEMENTAL-INFO-2013 CSV Parquet 7,847
2012 SC-P04-T99-SUPPLEMENTAL-INFO-2012 CSV Parquet 7,452
2011 SC-P04-T99-SUPPLEMENTAL-INFO-2011 CSV Parquet 6,604
2010 SC-P04-T99-SUPPLEMENTAL-INFO-2010 CSV Parquet 5,480
2009 SC-P04-T99-SUPPLEMENTAL-INFO-2009 CSV Parquet 2,499
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SC-P04-T99-SUPPLEMENTAL-INFO",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

Schedule D: Supplemental Financial Statements

P01 Part I - Organizations Maintaining Donor Advised Funds or Other Similar Funds or Accounts

SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH

1:1 one row per filing · tax years 2009–2025 · 103,952 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2025 CSV Parquet 918
2024 SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2024 CSV Parquet 3,610
2023 SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2023 CSV Parquet 5,989
2022 SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2022 CSV Parquet 5,535
2021 SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2021 CSV Parquet 5,202
2020 SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2020 CSV Parquet 5,377
2019 SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2019 CSV Parquet 4,047
2018 SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2018 CSV Parquet 3,682
2017 SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2017 CSV Parquet 3,503
2016 SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2016 CSV Parquet 3,174
2015 SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2015 CSV Parquet 2,893
2014 SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2014 CSV Parquet 2,586
2013 SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2013 CSV Parquet 2,823
2012 SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2012 CSV Parquet 2,535
2011 SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2011 CSV Parquet 26,954
2010 SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2010 CSV Parquet 20,215
2009 SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2009 CSV Parquet 4,909
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P02 Part II - Conservation Easements

SD-P02-T00-CONSERV-EASEMENTS

1:1 one row per filing · tax years 2009–2025 · 91,495 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SD-P02-T00-CONSERV-EASEMENTS-2025 CSV Parquet 775
2024 SD-P02-T00-CONSERV-EASEMENTS-2024 CSV Parquet 2,787
2023 SD-P02-T00-CONSERV-EASEMENTS-2023 CSV Parquet 5,131
2022 SD-P02-T00-CONSERV-EASEMENTS-2022 CSV Parquet 4,645
2021 SD-P02-T00-CONSERV-EASEMENTS-2021 CSV Parquet 4,274
2020 SD-P02-T00-CONSERV-EASEMENTS-2020 CSV Parquet 4,475
2019 SD-P02-T00-CONSERV-EASEMENTS-2019 CSV Parquet 3,222
2018 SD-P02-T00-CONSERV-EASEMENTS-2018 CSV Parquet 2,890
2017 SD-P02-T00-CONSERV-EASEMENTS-2017 CSV Parquet 2,747
2016 SD-P02-T00-CONSERV-EASEMENTS-2016 CSV Parquet 2,397
2015 SD-P02-T00-CONSERV-EASEMENTS-2015 CSV Parquet 2,123
2014 SD-P02-T00-CONSERV-EASEMENTS-2014 CSV Parquet 1,720
2013 SD-P02-T00-CONSERV-EASEMENTS-2013 CSV Parquet 2,033
2012 SD-P02-T00-CONSERV-EASEMENTS-2012 CSV Parquet 1,716
2011 SD-P02-T00-CONSERV-EASEMENTS-2011 CSV Parquet 26,277
2010 SD-P02-T00-CONSERV-EASEMENTS-2010 CSV Parquet 19,551
2009 SD-P02-T00-CONSERV-EASEMENTS-2009 CSV Parquet 4,732
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SD-P02-T00-CONSERV-EASEMENTS",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P03 Part III - Organizations Maintaining Collections of Art, Historical Treasures, or Other Similar Assets

SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH

1:1 one row per filing · tax years 2009–2025 · 152,777 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2025 CSV Parquet 1,585
2024 SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2024 CSV Parquet 7,613
2023 SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2023 CSV Parquet 10,530
2022 SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2022 CSV Parquet 10,003
2021 SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2021 CSV Parquet 9,600
2020 SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2020 CSV Parquet 9,205
2019 SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2019 CSV Parquet 7,659
2018 SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2018 CSV Parquet 7,161
2017 SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2017 CSV Parquet 7,017
2016 SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2016 CSV Parquet 6,301
2015 SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2015 CSV Parquet 5,878
2014 SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2014 CSV Parquet 5,309
2013 SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2013 CSV Parquet 4,911
2012 SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2012 CSV Parquet 4,483
2011 SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2011 CSV Parquet 28,326
2010 SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2010 CSV Parquet 21,480
2009 SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2009 CSV Parquet 5,716
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P04 Part IV - Escrow and Custodial Arrangements

SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS

1:1 one row per filing · tax years 2009–2025 · 319,120 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2025 CSV Parquet 4,921
2024 SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2024 CSV Parquet 20,583
2023 SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2023 CSV Parquet 24,032
2022 SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2022 CSV Parquet 24,186
2021 SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2021 CSV Parquet 23,984
2020 SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2020 CSV Parquet 23,855
2019 SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2019 CSV Parquet 20,091
2018 SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2018 CSV Parquet 18,590
2017 SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2017 CSV Parquet 18,109
2016 SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2016 CSV Parquet 16,742
2015 SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2015 CSV Parquet 16,305
2014 SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2014 CSV Parquet 15,195
2013 SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2013 CSV Parquet 12,897
2012 SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2012 CSV Parquet 12,241
2011 SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2011 CSV Parquet 35,822
2010 SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2010 CSV Parquet 25,503
2009 SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2009 CSV Parquet 6,064
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P05 Part V - Endowment Funds

SD-P05-T00-ENDOWMENT

1:1 one row per filing · tax years 2009–2025 · 525,393 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SD-P05-T00-ENDOWMENT-2025 CSV Parquet 5,560
2024 SD-P05-T00-ENDOWMENT-2024 CSV Parquet 37,493
2023 SD-P05-T00-ENDOWMENT-2023 CSV Parquet 38,122
2022 SD-P05-T00-ENDOWMENT-2022 CSV Parquet 37,661
2021 SD-P05-T00-ENDOWMENT-2021 CSV Parquet 37,350
2020 SD-P05-T00-ENDOWMENT-2020 CSV Parquet 36,868
2019 SD-P05-T00-ENDOWMENT-2019 CSV Parquet 34,428
2018 SD-P05-T00-ENDOWMENT-2018 CSV Parquet 33,392
2017 SD-P05-T00-ENDOWMENT-2017 CSV Parquet 33,404
2016 SD-P05-T00-ENDOWMENT-2016 CSV Parquet 30,998
2015 SD-P05-T00-ENDOWMENT-2015 CSV Parquet 29,879
2014 SD-P05-T00-ENDOWMENT-2014 CSV Parquet 28,541
2013 SD-P05-T00-ENDOWMENT-2013 CSV Parquet 26,522
2012 SD-P05-T00-ENDOWMENT-2012 CSV Parquet 24,430
2011 SD-P05-T00-ENDOWMENT-2011 CSV Parquet 44,067
2010 SD-P05-T00-ENDOWMENT-2010 CSV Parquet 34,964
2009 SD-P05-T00-ENDOWMENT-2009 CSV Parquet 11,714
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SD-P05-T00-ENDOWMENT",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P06 Part VI - Land, Buildings, and Equipment

SD-P06-T00-LAND-BLDG-EQUIP

1:1 one row per filing · tax years 2009–2025 · 3,028,794 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SD-P06-T00-LAND-BLDG-EQUIP-2025 CSV Parquet 60,235
2024 SD-P06-T00-LAND-BLDG-EQUIP-2024 CSV Parquet 249,892
2023 SD-P06-T00-LAND-BLDG-EQUIP-2023 CSV Parquet 252,066
2022 SD-P06-T00-LAND-BLDG-EQUIP-2022 CSV Parquet 248,906
2021 SD-P06-T00-LAND-BLDG-EQUIP-2021 CSV Parquet 243,921
2020 SD-P06-T00-LAND-BLDG-EQUIP-2020 CSV Parquet 236,814
2019 SD-P06-T00-LAND-BLDG-EQUIP-2019 CSV Parquet 214,442
2018 SD-P06-T00-LAND-BLDG-EQUIP-2018 CSV Parquet 206,814
2017 SD-P06-T00-LAND-BLDG-EQUIP-2017 CSV Parquet 202,099
2016 SD-P06-T00-LAND-BLDG-EQUIP-2016 CSV Parquet 189,880
2015 SD-P06-T00-LAND-BLDG-EQUIP-2015 CSV Parquet 183,537
2014 SD-P06-T00-LAND-BLDG-EQUIP-2014 CSV Parquet 173,569
2013 SD-P06-T00-LAND-BLDG-EQUIP-2013 CSV Parquet 159,874
2012 SD-P06-T00-LAND-BLDG-EQUIP-2012 CSV Parquet 145,599
2011 SD-P06-T00-LAND-BLDG-EQUIP-2011 CSV Parquet 130,304
2010 SD-P06-T00-LAND-BLDG-EQUIP-2010 CSV Parquet 101,093
2009 SD-P06-T00-LAND-BLDG-EQUIP-2009 CSV Parquet 29,749
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SD-P06-T00-LAND-BLDG-EQUIP",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P07 Part VII - Investments - Other Securities

SD-P07-T00-INVESTMENTS-SECURITIES

1:1 one row per filing · tax years 2009–2025 · 285,319 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SD-P07-T00-INVESTMENTS-SECURITIES-2025 CSV Parquet 4,553
2024 SD-P07-T00-INVESTMENTS-SECURITIES-2024 CSV Parquet 22,963
2023 SD-P07-T00-INVESTMENTS-SECURITIES-2023 CSV Parquet 23,184
2022 SD-P07-T00-INVESTMENTS-SECURITIES-2022 CSV Parquet 22,299
2021 SD-P07-T00-INVESTMENTS-SECURITIES-2021 CSV Parquet 21,505
2020 SD-P07-T00-INVESTMENTS-SECURITIES-2020 CSV Parquet 20,859
2019 SD-P07-T00-INVESTMENTS-SECURITIES-2019 CSV Parquet 18,839
2018 SD-P07-T00-INVESTMENTS-SECURITIES-2018 CSV Parquet 18,709
2017 SD-P07-T00-INVESTMENTS-SECURITIES-2017 CSV Parquet 18,637
2016 SD-P07-T00-INVESTMENTS-SECURITIES-2016 CSV Parquet 17,534
2015 SD-P07-T00-INVESTMENTS-SECURITIES-2015 CSV Parquet 17,284
2014 SD-P07-T00-INVESTMENTS-SECURITIES-2014 CSV Parquet 16,867
2013 SD-P07-T00-INVESTMENTS-SECURITIES-2013 CSV Parquet 15,959
2012 SD-P07-T00-INVESTMENTS-SECURITIES-2012 CSV Parquet 15,065
2011 SD-P07-T00-INVESTMENTS-SECURITIES-2011 CSV Parquet 14,142
2010 SD-P07-T00-INVESTMENTS-SECURITIES-2010 CSV Parquet 12,046
2009 SD-P07-T00-INVESTMENTS-SECURITIES-2009 CSV Parquet 4,874
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SD-P07-T00-INVESTMENTS-SECURITIES",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES

1:1 one row per filing · tax years 2009–2025 · 9,798 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES-2025 CSV Parquet 287
2024 SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES-2024 CSV Parquet 846
2023 SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES-2023 CSV Parquet 813
2022 SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES-2022 CSV Parquet 857
2021 SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES-2021 CSV Parquet 825
2020 SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES-2020 CSV Parquet 763
2019 SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES-2019 CSV Parquet 529
2018 SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES-2018 CSV Parquet 512
2017 SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES-2017 CSV Parquet 400
2016 SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES-2016 CSV Parquet 354
2015 SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES-2015 CSV Parquet 377
2014 SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES-2014 CSV Parquet 395
2013 SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES-2013 CSV Parquet 595
2012 SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES-2012 CSV Parquet 641
2011 SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES-2011 CSV Parquet 611
2010 SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES-2010 CSV Parquet 543
2009 SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES-2009 CSV Parquet 450
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SD-P07-T00-INVESTMENTS-OTH-EQUITY

1:1 one row per filing · tax years 2009–2025 · 19,121 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SD-P07-T00-INVESTMENTS-OTH-EQUITY-2025 CSV Parquet 314
2024 SD-P07-T00-INVESTMENTS-OTH-EQUITY-2024 CSV Parquet 1,353
2023 SD-P07-T00-INVESTMENTS-OTH-EQUITY-2023 CSV Parquet 1,401
2022 SD-P07-T00-INVESTMENTS-OTH-EQUITY-2022 CSV Parquet 1,462
2021 SD-P07-T00-INVESTMENTS-OTH-EQUITY-2021 CSV Parquet 1,453
2020 SD-P07-T00-INVESTMENTS-OTH-EQUITY-2020 CSV Parquet 1,428
2019 SD-P07-T00-INVESTMENTS-OTH-EQUITY-2019 CSV Parquet 1,185
2018 SD-P07-T00-INVESTMENTS-OTH-EQUITY-2018 CSV Parquet 1,158
2017 SD-P07-T00-INVESTMENTS-OTH-EQUITY-2017 CSV Parquet 1,146
2016 SD-P07-T00-INVESTMENTS-OTH-EQUITY-2016 CSV Parquet 1,087
2015 SD-P07-T00-INVESTMENTS-OTH-EQUITY-2015 CSV Parquet 1,099
2014 SD-P07-T00-INVESTMENTS-OTH-EQUITY-2014 CSV Parquet 1,105
2013 SD-P07-T00-INVESTMENTS-OTH-EQUITY-2013 CSV Parquet 1,227
2012 SD-P07-T00-INVESTMENTS-OTH-EQUITY-2012 CSV Parquet 1,147
2011 SD-P07-T00-INVESTMENTS-OTH-EQUITY-2011 CSV Parquet 1,075
2010 SD-P07-T00-INVESTMENTS-OTH-EQUITY-2010 CSV Parquet 902
2009 SD-P07-T00-INVESTMENTS-OTH-EQUITY-2009 CSV Parquet 579
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SD-P07-T00-INVESTMENTS-OTH-EQUITY",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SD-P07-T01-INVESTMENTS-OTH-SECURITIES

1:M many rows per filing · tax years 2009–2025 · 797,690 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2025 CSV Parquet 13,168
2024 SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2024 CSV Parquet 63,665
2023 SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2023 CSV Parquet 62,798
2022 SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2022 CSV Parquet 63,000
2021 SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2021 CSV Parquet 61,936
2020 SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2020 CSV Parquet 64,515
2019 SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2019 CSV Parquet 53,588
2018 SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2018 CSV Parquet 51,915
2017 SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2017 CSV Parquet 52,312
2016 SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2016 CSV Parquet 50,058
2015 SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2015 CSV Parquet 50,265
2014 SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2014 CSV Parquet 49,632
2013 SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2013 CSV Parquet 46,963
2012 SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2012 CSV Parquet 44,536
2011 SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2011 CSV Parquet 31,398
2010 SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2010 CSV Parquet 27,166
2009 SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2009 CSV Parquet 10,775
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SD-P07-T01-INVESTMENTS-OTH-SECURITIES",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P08 Part VIII - Investments - Program Related

SD-P08-T00-INVESTMENTS-PROG-RLTD

1:1 one row per filing · tax years 2009–2025 · 82,987 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SD-P08-T00-INVESTMENTS-PROG-RLTD-2025 CSV Parquet 1,721
2024 SD-P08-T00-INVESTMENTS-PROG-RLTD-2024 CSV Parquet 6,880
2023 SD-P08-T00-INVESTMENTS-PROG-RLTD-2023 CSV Parquet 6,994
2022 SD-P08-T00-INVESTMENTS-PROG-RLTD-2022 CSV Parquet 6,671
2021 SD-P08-T00-INVESTMENTS-PROG-RLTD-2021 CSV Parquet 6,694
2020 SD-P08-T00-INVESTMENTS-PROG-RLTD-2020 CSV Parquet 6,508
2019 SD-P08-T00-INVESTMENTS-PROG-RLTD-2019 CSV Parquet 5,716
2018 SD-P08-T00-INVESTMENTS-PROG-RLTD-2018 CSV Parquet 5,803
2017 SD-P08-T00-INVESTMENTS-PROG-RLTD-2017 CSV Parquet 5,626
2016 SD-P08-T00-INVESTMENTS-PROG-RLTD-2016 CSV Parquet 5,177
2015 SD-P08-T00-INVESTMENTS-PROG-RLTD-2015 CSV Parquet 4,852
2014 SD-P08-T00-INVESTMENTS-PROG-RLTD-2014 CSV Parquet 4,629
2013 SD-P08-T00-INVESTMENTS-PROG-RLTD-2013 CSV Parquet 4,338
2012 SD-P08-T00-INVESTMENTS-PROG-RLTD-2012 CSV Parquet 3,938
2011 SD-P08-T00-INVESTMENTS-PROG-RLTD-2011 CSV Parquet 3,599
2010 SD-P08-T00-INVESTMENTS-PROG-RLTD-2010 CSV Parquet 3,063
2009 SD-P08-T00-INVESTMENTS-PROG-RLTD-2009 CSV Parquet 778
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SD-P08-T00-INVESTMENTS-PROG-RLTD",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SD-P08-T01-INVESTMENTS-PROG-RLTD

1:M many rows per filing · tax years 2009–2025 · 186,069 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SD-P08-T01-INVESTMENTS-PROG-RLTD-2025 CSV Parquet 3,446
2024 SD-P08-T01-INVESTMENTS-PROG-RLTD-2024 CSV Parquet 15,140
2023 SD-P08-T01-INVESTMENTS-PROG-RLTD-2023 CSV Parquet 15,410
2022 SD-P08-T01-INVESTMENTS-PROG-RLTD-2022 CSV Parquet 15,076
2021 SD-P08-T01-INVESTMENTS-PROG-RLTD-2021 CSV Parquet 14,768
2020 SD-P08-T01-INVESTMENTS-PROG-RLTD-2020 CSV Parquet 14,258
2019 SD-P08-T01-INVESTMENTS-PROG-RLTD-2019 CSV Parquet 12,832
2018 SD-P08-T01-INVESTMENTS-PROG-RLTD-2018 CSV Parquet 12,483
2017 SD-P08-T01-INVESTMENTS-PROG-RLTD-2017 CSV Parquet 12,370
2016 SD-P08-T01-INVESTMENTS-PROG-RLTD-2016 CSV Parquet 11,605
2015 SD-P08-T01-INVESTMENTS-PROG-RLTD-2015 CSV Parquet 11,190
2014 SD-P08-T01-INVESTMENTS-PROG-RLTD-2014 CSV Parquet 10,635
2013 SD-P08-T01-INVESTMENTS-PROG-RLTD-2013 CSV Parquet 10,043
2012 SD-P08-T01-INVESTMENTS-PROG-RLTD-2012 CSV Parquet 9,407
2011 SD-P08-T01-INVESTMENTS-PROG-RLTD-2011 CSV Parquet 8,614
2010 SD-P08-T01-INVESTMENTS-PROG-RLTD-2010 CSV Parquet 7,291
2009 SD-P08-T01-INVESTMENTS-PROG-RLTD-2009 CSV Parquet 1,501
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SD-P08-T01-INVESTMENTS-PROG-RLTD",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P09 Part IX - Other Assets

SD-P09-T00-OTH-ASSETS

1:1 one row per filing · tax years 2009–2025 · 596,328 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SD-P09-T00-OTH-ASSETS-2025 CSV Parquet 10,299
2024 SD-P09-T00-OTH-ASSETS-2024 CSV Parquet 59,257
2023 SD-P09-T00-OTH-ASSETS-2023 CSV Parquet 62,323
2022 SD-P09-T00-OTH-ASSETS-2022 CSV Parquet 60,145
2021 SD-P09-T00-OTH-ASSETS-2021 CSV Parquet 44,983
2020 SD-P09-T00-OTH-ASSETS-2020 CSV Parquet 42,746
2019 SD-P09-T00-OTH-ASSETS-2019 CSV Parquet 38,793
2018 SD-P09-T00-OTH-ASSETS-2018 CSV Parquet 37,483
2017 SD-P09-T00-OTH-ASSETS-2017 CSV Parquet 36,283
2016 SD-P09-T00-OTH-ASSETS-2016 CSV Parquet 33,955
2015 SD-P09-T00-OTH-ASSETS-2015 CSV Parquet 32,741
2014 SD-P09-T00-OTH-ASSETS-2014 CSV Parquet 31,078
2013 SD-P09-T00-OTH-ASSETS-2013 CSV Parquet 28,413
2012 SD-P09-T00-OTH-ASSETS-2012 CSV Parquet 26,290
2011 SD-P09-T00-OTH-ASSETS-2011 CSV Parquet 24,146
2010 SD-P09-T00-OTH-ASSETS-2010 CSV Parquet 19,791
2009 SD-P09-T00-OTH-ASSETS-2009 CSV Parquet 7,602
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SD-P09-T00-OTH-ASSETS",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SD-P09-T01-OTH-ASSETS

1:M many rows per filing · tax years 2009–2025 · 1,323,140 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SD-P09-T01-OTH-ASSETS-2025 CSV Parquet 20,493
2024 SD-P09-T01-OTH-ASSETS-2024 CSV Parquet 131,033
2023 SD-P09-T01-OTH-ASSETS-2023 CSV Parquet 135,917
2022 SD-P09-T01-OTH-ASSETS-2022 CSV Parquet 131,007
2021 SD-P09-T01-OTH-ASSETS-2021 CSV Parquet 96,688
2020 SD-P09-T01-OTH-ASSETS-2020 CSV Parquet 91,621
2019 SD-P09-T01-OTH-ASSETS-2019 CSV Parquet 83,364
2018 SD-P09-T01-OTH-ASSETS-2018 CSV Parquet 79,853
2017 SD-P09-T01-OTH-ASSETS-2017 CSV Parquet 78,893
2016 SD-P09-T01-OTH-ASSETS-2016 CSV Parquet 74,357
2015 SD-P09-T01-OTH-ASSETS-2015 CSV Parquet 74,202
2014 SD-P09-T01-OTH-ASSETS-2014 CSV Parquet 71,163
2013 SD-P09-T01-OTH-ASSETS-2013 CSV Parquet 66,676
2012 SD-P09-T01-OTH-ASSETS-2012 CSV Parquet 62,450
2011 SD-P09-T01-OTH-ASSETS-2011 CSV Parquet 57,526
2010 SD-P09-T01-OTH-ASSETS-2010 CSV Parquet 48,455
2009 SD-P09-T01-OTH-ASSETS-2009 CSV Parquet 19,442
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SD-P09-T01-OTH-ASSETS",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P10 Part X - Other Liabilities

SD-P10-T00-OTH-LIABILITIES

1:1 one row per filing · tax years 2009–2025 · 1,934,636 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SD-P10-T00-OTH-LIABILITIES-2025 CSV Parquet 33,357
2024 SD-P10-T00-OTH-LIABILITIES-2024 CSV Parquet 168,020
2023 SD-P10-T00-OTH-LIABILITIES-2023 CSV Parquet 168,758
2022 SD-P10-T00-OTH-LIABILITIES-2022 CSV Parquet 164,707
2021 SD-P10-T00-OTH-LIABILITIES-2021 CSV Parquet 155,582
2020 SD-P10-T00-OTH-LIABILITIES-2020 CSV Parquet 154,648
2019 SD-P10-T00-OTH-LIABILITIES-2019 CSV Parquet 140,589
2018 SD-P10-T00-OTH-LIABILITIES-2018 CSV Parquet 132,609
2017 SD-P10-T00-OTH-LIABILITIES-2017 CSV Parquet 130,163
2016 SD-P10-T00-OTH-LIABILITIES-2016 CSV Parquet 121,635
2015 SD-P10-T00-OTH-LIABILITIES-2015 CSV Parquet 117,956
2014 SD-P10-T00-OTH-LIABILITIES-2014 CSV Parquet 112,733
2013 SD-P10-T00-OTH-LIABILITIES-2013 CSV Parquet 101,745
2012 SD-P10-T00-OTH-LIABILITIES-2012 CSV Parquet 92,460
2011 SD-P10-T00-OTH-LIABILITIES-2011 CSV Parquet 66,958
2010 SD-P10-T00-OTH-LIABILITIES-2010 CSV Parquet 54,263
2009 SD-P10-T00-OTH-LIABILITIES-2009 CSV Parquet 18,453
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SD-P10-T00-OTH-LIABILITIES",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SD-P10-T01-OTH-LIABILITIES

1:M many rows per filing · tax years 2009–2025 · 3,045,120 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SD-P10-T01-OTH-LIABILITIES-2025 CSV Parquet 54,152
2024 SD-P10-T01-OTH-LIABILITIES-2024 CSV Parquet 275,301
2023 SD-P10-T01-OTH-LIABILITIES-2023 CSV Parquet 273,915
2022 SD-P10-T01-OTH-LIABILITIES-2022 CSV Parquet 266,341
2021 SD-P10-T01-OTH-LIABILITIES-2021 CSV Parquet 234,480
2020 SD-P10-T01-OTH-LIABILITIES-2020 CSV Parquet 240,075
2019 SD-P10-T01-OTH-LIABILITIES-2019 CSV Parquet 213,874
2018 SD-P10-T01-OTH-LIABILITIES-2018 CSV Parquet 192,313
2017 SD-P10-T01-OTH-LIABILITIES-2017 CSV Parquet 189,925
2016 SD-P10-T01-OTH-LIABILITIES-2016 CSV Parquet 178,619
2015 SD-P10-T01-OTH-LIABILITIES-2015 CSV Parquet 177,781
2014 SD-P10-T01-OTH-LIABILITIES-2014 CSV Parquet 169,677
2013 SD-P10-T01-OTH-LIABILITIES-2013 CSV Parquet 156,584
2012 SD-P10-T01-OTH-LIABILITIES-2012 CSV Parquet 147,060
2011 SD-P10-T01-OTH-LIABILITIES-2011 CSV Parquet 129,779
2010 SD-P10-T01-OTH-LIABILITIES-2010 CSV Parquet 106,645
2009 SD-P10-T01-OTH-LIABILITIES-2009 CSV Parquet 38,599
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SD-P10-T01-OTH-LIABILITIES",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P11 Part XI - Reconciliation of Revenue per Audited Financial Statements With Revenue per Return

SD-P11-T00-RECONCILIATION-REVENUE

1:1 one row per filing · tax years 2009–2025 · 1,437,705 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SD-P11-T00-RECONCILIATION-REVENUE-2025 CSV Parquet 16,228
2024 SD-P11-T00-RECONCILIATION-REVENUE-2024 CSV Parquet 106,001
2023 SD-P11-T00-RECONCILIATION-REVENUE-2023 CSV Parquet 105,941
2022 SD-P11-T00-RECONCILIATION-REVENUE-2022 CSV Parquet 106,390
2021 SD-P11-T00-RECONCILIATION-REVENUE-2021 CSV Parquet 106,702
2020 SD-P11-T00-RECONCILIATION-REVENUE-2020 CSV Parquet 106,061
2019 SD-P11-T00-RECONCILIATION-REVENUE-2019 CSV Parquet 99,921
2018 SD-P11-T00-RECONCILIATION-REVENUE-2018 CSV Parquet 98,963
2017 SD-P11-T00-RECONCILIATION-REVENUE-2017 CSV Parquet 99,554
2016 SD-P11-T00-RECONCILIATION-REVENUE-2016 CSV Parquet 94,346
2015 SD-P11-T00-RECONCILIATION-REVENUE-2015 CSV Parquet 92,712
2014 SD-P11-T00-RECONCILIATION-REVENUE-2014 CSV Parquet 89,299
2013 SD-P11-T00-RECONCILIATION-REVENUE-2013 CSV Parquet 83,850
2012 SD-P11-T00-RECONCILIATION-REVENUE-2012 CSV Parquet 78,212
2011 SD-P11-T00-RECONCILIATION-REVENUE-2011 CSV Parquet 73,128
2010 SD-P11-T00-RECONCILIATION-REVENUE-2010 CSV Parquet 58,568
2009 SD-P11-T00-RECONCILIATION-REVENUE-2009 CSV Parquet 21,829
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SD-P11-T00-RECONCILIATION-REVENUE",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P12 Part XII - Reconciliation of Expenses per Audited Financial Statements With Expenses per Return

SD-P12-T00-RECONCILIATION-EXPENSES

1:1 one row per filing · tax years 2009–2025 · 1,437,051 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SD-P12-T00-RECONCILIATION-EXPENSES-2025 CSV Parquet 16,221
2024 SD-P12-T00-RECONCILIATION-EXPENSES-2024 CSV Parquet 105,976
2023 SD-P12-T00-RECONCILIATION-EXPENSES-2023 CSV Parquet 105,914
2022 SD-P12-T00-RECONCILIATION-EXPENSES-2022 CSV Parquet 106,371
2021 SD-P12-T00-RECONCILIATION-EXPENSES-2021 CSV Parquet 106,680
2020 SD-P12-T00-RECONCILIATION-EXPENSES-2020 CSV Parquet 106,031
2019 SD-P12-T00-RECONCILIATION-EXPENSES-2019 CSV Parquet 99,907
2018 SD-P12-T00-RECONCILIATION-EXPENSES-2018 CSV Parquet 98,936
2017 SD-P12-T00-RECONCILIATION-EXPENSES-2017 CSV Parquet 99,504
2016 SD-P12-T00-RECONCILIATION-EXPENSES-2016 CSV Parquet 94,289
2015 SD-P12-T00-RECONCILIATION-EXPENSES-2015 CSV Parquet 92,654
2014 SD-P12-T00-RECONCILIATION-EXPENSES-2014 CSV Parquet 89,246
2013 SD-P12-T00-RECONCILIATION-EXPENSES-2013 CSV Parquet 83,797
2012 SD-P12-T00-RECONCILIATION-EXPENSES-2012 CSV Parquet 78,138
2011 SD-P12-T00-RECONCILIATION-EXPENSES-2011 CSV Parquet 73,056
2010 SD-P12-T00-RECONCILIATION-EXPENSES-2010 CSV Parquet 58,521
2009 SD-P12-T00-RECONCILIATION-EXPENSES-2009 CSV Parquet 21,810
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SD-P12-T00-RECONCILIATION-EXPENSES",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P13 Part XIII - Supplemental Information

SD-P13-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2009–2025 · 2,833,051 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SD-P13-T99-SUPPLEMENTAL-INFO-2025 CSV Parquet 26,905
2024 SD-P13-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 205,165
2023 SD-P13-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 208,275
2022 SD-P13-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 209,142
2021 SD-P13-T99-SUPPLEMENTAL-INFO-2021 CSV Parquet 207,412
2020 SD-P13-T99-SUPPLEMENTAL-INFO-2020 CSV Parquet 204,566
2019 SD-P13-T99-SUPPLEMENTAL-INFO-2019 CSV Parquet 197,678
2018 SD-P13-T99-SUPPLEMENTAL-INFO-2018 CSV Parquet 196,045
2017 SD-P13-T99-SUPPLEMENTAL-INFO-2017 CSV Parquet 197,284
2016 SD-P13-T99-SUPPLEMENTAL-INFO-2016 CSV Parquet 186,061
2015 SD-P13-T99-SUPPLEMENTAL-INFO-2015 CSV Parquet 182,486
2014 SD-P13-T99-SUPPLEMENTAL-INFO-2014 CSV Parquet 176,783
2013 SD-P13-T99-SUPPLEMENTAL-INFO-2013 CSV Parquet 164,871
2012 SD-P13-T99-SUPPLEMENTAL-INFO-2012 CSV Parquet 153,113
2011 SD-P13-T99-SUPPLEMENTAL-INFO-2011 CSV Parquet 152,368
2010 SD-P13-T99-SUPPLEMENTAL-INFO-2010 CSV Parquet 117,057
2009 SD-P13-T99-SUPPLEMENTAL-INFO-2009 CSV Parquet 47,840
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SD-P13-T99-SUPPLEMENTAL-INFO",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P99 Lines from earlier versions of the schedule (reconciliation of net assets)

SD-P99-T00-RECONCILIATION-NETASSETS

1:1 one row per filing · tax years 2009–2011 · 172,535 rows · Data dictionary

Year Table CSV Parquet Rows
2011 SD-P99-T00-RECONCILIATION-NETASSETS-2011 CSV Parquet 81,936
2010 SD-P99-T00-RECONCILIATION-NETASSETS-2010 CSV Parquet 67,007
2009 SD-P99-T00-RECONCILIATION-NETASSETS-2009 CSV Parquet 23,592
Download with panel990
library( panel990 )

# Panel of tax years 2009-2011
# with BMF fields appended

panel <- 
  panelize( tables = "SD-P99-T00-RECONCILIATION-NETASSETS",
            years = 2009:2011,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

Schedule E: Schools

P01 Part I - Schools

SE-P01-T00-SCHOOLS

1:1 one row per filing · tax years 2009–2025 · 233,415 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SE-P01-T00-SCHOOLS-2025 CSV Parquet 2,468
2024 SE-P01-T00-SCHOOLS-2024 CSV Parquet 19,422
2023 SE-P01-T00-SCHOOLS-2023 CSV Parquet 19,629
2022 SE-P01-T00-SCHOOLS-2022 CSV Parquet 19,430
2021 SE-P01-T00-SCHOOLS-2021 CSV Parquet 19,087
2020 SE-P01-T00-SCHOOLS-2020 CSV Parquet 18,166
2019 SE-P01-T00-SCHOOLS-2019 CSV Parquet 16,511
2018 SE-P01-T00-SCHOOLS-2018 CSV Parquet 15,613
2017 SE-P01-T00-SCHOOLS-2017 CSV Parquet 15,916
2016 SE-P01-T00-SCHOOLS-2016 CSV Parquet 14,510
2015 SE-P01-T00-SCHOOLS-2015 CSV Parquet 13,972
2014 SE-P01-T00-SCHOOLS-2014 CSV Parquet 13,300
2013 SE-P01-T00-SCHOOLS-2013 CSV Parquet 12,258
2012 SE-P01-T00-SCHOOLS-2012 CSV Parquet 11,163
2011 SE-P01-T00-SCHOOLS-2011 CSV Parquet 9,960
2010 SE-P01-T00-SCHOOLS-2010 CSV Parquet 7,744
2009 SE-P01-T00-SCHOOLS-2009 CSV Parquet 4,266
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SE-P01-T00-SCHOOLS",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P02 Part II - Supplemental Information

SE-P02-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2010–2025 · 361,580 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SE-P02-T99-SUPPLEMENTAL-INFO-2025 CSV Parquet 3,105
2024 SE-P02-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 30,434
2023 SE-P02-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 30,626
2022 SE-P02-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 30,575
2021 SE-P02-T99-SUPPLEMENTAL-INFO-2021 CSV Parquet 30,472
2020 SE-P02-T99-SUPPLEMENTAL-INFO-2020 CSV Parquet 29,404
2019 SE-P02-T99-SUPPLEMENTAL-INFO-2019 CSV Parquet 26,691
2018 SE-P02-T99-SUPPLEMENTAL-INFO-2018 CSV Parquet 25,346
2017 SE-P02-T99-SUPPLEMENTAL-INFO-2017 CSV Parquet 26,422
2016 SE-P02-T99-SUPPLEMENTAL-INFO-2016 CSV Parquet 24,402
2015 SE-P02-T99-SUPPLEMENTAL-INFO-2015 CSV Parquet 23,642
2014 SE-P02-T99-SUPPLEMENTAL-INFO-2014 CSV Parquet 22,789
2013 SE-P02-T99-SUPPLEMENTAL-INFO-2013 CSV Parquet 21,184
2012 SE-P02-T99-SUPPLEMENTAL-INFO-2012 CSV Parquet 14,897
2011 SE-P02-T99-SUPPLEMENTAL-INFO-2011 CSV Parquet 12,094
2010 SE-P02-T99-SUPPLEMENTAL-INFO-2010 CSV Parquet 9,497
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SE-P02-T99-SUPPLEMENTAL-INFO",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

Schedule F: Statement of Activities Outside the United States

P01 Part I - General Information on Activities Outside the United States

SF-P01-T00-FRGN-ACTS

1:1 one row per filing · tax years 2009–2025 · 180,228 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SF-P01-T00-FRGN-ACTS-2025 CSV Parquet 4,099
2024 SF-P01-T00-FRGN-ACTS-2024 CSV Parquet 16,693
2023 SF-P01-T00-FRGN-ACTS-2023 CSV Parquet 16,487
2022 SF-P01-T00-FRGN-ACTS-2022 CSV Parquet 15,860
2021 SF-P01-T00-FRGN-ACTS-2021 CSV Parquet 14,754
2020 SF-P01-T00-FRGN-ACTS-2020 CSV Parquet 13,884
2019 SF-P01-T00-FRGN-ACTS-2019 CSV Parquet 13,032
2018 SF-P01-T00-FRGN-ACTS-2018 CSV Parquet 12,509
2017 SF-P01-T00-FRGN-ACTS-2017 CSV Parquet 12,096
2016 SF-P01-T00-FRGN-ACTS-2016 CSV Parquet 11,135
2015 SF-P01-T00-FRGN-ACTS-2015 CSV Parquet 10,526
2014 SF-P01-T00-FRGN-ACTS-2014 CSV Parquet 9,551
2013 SF-P01-T00-FRGN-ACTS-2013 CSV Parquet 8,516
2012 SF-P01-T00-FRGN-ACTS-2012 CSV Parquet 7,589
2011 SF-P01-T00-FRGN-ACTS-2011 CSV Parquet 6,647
2010 SF-P01-T00-FRGN-ACTS-2010 CSV Parquet 5,117
2009 SF-P01-T00-FRGN-ACTS-2009 CSV Parquet 1,733
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SF-P01-T00-FRGN-ACTS",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SF-P01-T01-FRGN-ACTS-BY-REGION

1:M many rows per filing · tax years 2009–2025 · 553,604 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SF-P01-T01-FRGN-ACTS-BY-REGION-2025 CSV Parquet 8,926
2024 SF-P01-T01-FRGN-ACTS-BY-REGION-2024 CSV Parquet 49,281
2023 SF-P01-T01-FRGN-ACTS-BY-REGION-2023 CSV Parquet 48,621
2022 SF-P01-T01-FRGN-ACTS-BY-REGION-2022 CSV Parquet 46,569
2021 SF-P01-T01-FRGN-ACTS-BY-REGION-2021 CSV Parquet 42,039
2020 SF-P01-T01-FRGN-ACTS-BY-REGION-2020 CSV Parquet 38,580
2019 SF-P01-T01-FRGN-ACTS-BY-REGION-2019 CSV Parquet 40,029
2018 SF-P01-T01-FRGN-ACTS-BY-REGION-2018 CSV Parquet 39,021
2017 SF-P01-T01-FRGN-ACTS-BY-REGION-2017 CSV Parquet 38,649
2016 SF-P01-T01-FRGN-ACTS-BY-REGION-2016 CSV Parquet 35,184
2015 SF-P01-T01-FRGN-ACTS-BY-REGION-2015 CSV Parquet 33,496
2014 SF-P01-T01-FRGN-ACTS-BY-REGION-2014 CSV Parquet 30,925
2013 SF-P01-T01-FRGN-ACTS-BY-REGION-2013 CSV Parquet 28,115
2012 SF-P01-T01-FRGN-ACTS-BY-REGION-2012 CSV Parquet 25,336
2011 SF-P01-T01-FRGN-ACTS-BY-REGION-2011 CSV Parquet 22,291
2010 SF-P01-T01-FRGN-ACTS-BY-REGION-2010 CSV Parquet 18,304
2009 SF-P01-T01-FRGN-ACTS-BY-REGION-2009 CSV Parquet 8,238
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SF-P01-T01-FRGN-ACTS-BY-REGION",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P02 Part II - Grants and Other Assistance to Organizations or Entities Outside the United States

SF-P02-T00-FRGN-ORG-GRANTS

1:1 one row per filing · tax years 2009–2025 · 74,599 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SF-P02-T00-FRGN-ORG-GRANTS-2025 CSV Parquet 2,105
2024 SF-P02-T00-FRGN-ORG-GRANTS-2024 CSV Parquet 7,327
2023 SF-P02-T00-FRGN-ORG-GRANTS-2023 CSV Parquet 7,222
2022 SF-P02-T00-FRGN-ORG-GRANTS-2022 CSV Parquet 7,102
2021 SF-P02-T00-FRGN-ORG-GRANTS-2021 CSV Parquet 6,623
2020 SF-P02-T00-FRGN-ORG-GRANTS-2020 CSV Parquet 6,173
2019 SF-P02-T00-FRGN-ORG-GRANTS-2019 CSV Parquet 5,343
2018 SF-P02-T00-FRGN-ORG-GRANTS-2018 CSV Parquet 4,982
2017 SF-P02-T00-FRGN-ORG-GRANTS-2017 CSV Parquet 4,667
2016 SF-P02-T00-FRGN-ORG-GRANTS-2016 CSV Parquet 4,309
2015 SF-P02-T00-FRGN-ORG-GRANTS-2015 CSV Parquet 4,118
2014 SF-P02-T00-FRGN-ORG-GRANTS-2014 CSV Parquet 3,740
2013 SF-P02-T00-FRGN-ORG-GRANTS-2013 CSV Parquet 3,239
2012 SF-P02-T00-FRGN-ORG-GRANTS-2012 CSV Parquet 2,821
2011 SF-P02-T00-FRGN-ORG-GRANTS-2011 CSV Parquet 2,447
2010 SF-P02-T00-FRGN-ORG-GRANTS-2010 CSV Parquet 1,904
2009 SF-P02-T00-FRGN-ORG-GRANTS-2009 CSV Parquet 477
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SF-P02-T00-FRGN-ORG-GRANTS",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SF-P02-T01-FRGN-ORG-GRANTS

1:M many rows per filing · tax years 2009–2025 · 894,936 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SF-P02-T01-FRGN-ORG-GRANTS-2025 CSV Parquet 11,780
2024 SF-P02-T01-FRGN-ORG-GRANTS-2024 CSV Parquet 89,234
2023 SF-P02-T01-FRGN-ORG-GRANTS-2023 CSV Parquet 83,049
2022 SF-P02-T01-FRGN-ORG-GRANTS-2022 CSV Parquet 82,827
2021 SF-P02-T01-FRGN-ORG-GRANTS-2021 CSV Parquet 74,155
2020 SF-P02-T01-FRGN-ORG-GRANTS-2020 CSV Parquet 71,432
2019 SF-P02-T01-FRGN-ORG-GRANTS-2019 CSV Parquet 57,399
2018 SF-P02-T01-FRGN-ORG-GRANTS-2018 CSV Parquet 56,645
2017 SF-P02-T01-FRGN-ORG-GRANTS-2017 CSV Parquet 52,496
2016 SF-P02-T01-FRGN-ORG-GRANTS-2016 CSV Parquet 47,807
2015 SF-P02-T01-FRGN-ORG-GRANTS-2015 CSV Parquet 46,230
2014 SF-P02-T01-FRGN-ORG-GRANTS-2014 CSV Parquet 42,178
2013 SF-P02-T01-FRGN-ORG-GRANTS-2013 CSV Parquet 40,253
2012 SF-P02-T01-FRGN-ORG-GRANTS-2012 CSV Parquet 47,129
2011 SF-P02-T01-FRGN-ORG-GRANTS-2011 CSV Parquet 40,577
2010 SF-P02-T01-FRGN-ORG-GRANTS-2010 CSV Parquet 37,182
2009 SF-P02-T01-FRGN-ORG-GRANTS-2009 CSV Parquet 14,563
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SF-P02-T01-FRGN-ORG-GRANTS",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P03 Part III - Grants and Other Assistance to Individuals Outside the United States

SF-P03-T01-FRGN-INDIV-GRANTS

1:M many rows per filing · tax years 2009–2025 · 137,514 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SF-P03-T01-FRGN-INDIV-GRANTS-2025 CSV Parquet 2,800
2024 SF-P03-T01-FRGN-INDIV-GRANTS-2024 CSV Parquet 12,955
2023 SF-P03-T01-FRGN-INDIV-GRANTS-2023 CSV Parquet 12,465
2022 SF-P03-T01-FRGN-INDIV-GRANTS-2022 CSV Parquet 11,567
2021 SF-P03-T01-FRGN-INDIV-GRANTS-2021 CSV Parquet 11,067
2020 SF-P03-T01-FRGN-INDIV-GRANTS-2020 CSV Parquet 9,624
2019 SF-P03-T01-FRGN-INDIV-GRANTS-2019 CSV Parquet 9,857
2018 SF-P03-T01-FRGN-INDIV-GRANTS-2018 CSV Parquet 9,539
2017 SF-P03-T01-FRGN-INDIV-GRANTS-2017 CSV Parquet 9,386
2016 SF-P03-T01-FRGN-INDIV-GRANTS-2016 CSV Parquet 8,073
2015 SF-P03-T01-FRGN-INDIV-GRANTS-2015 CSV Parquet 7,765
2014 SF-P03-T01-FRGN-INDIV-GRANTS-2014 CSV Parquet 7,375
2013 SF-P03-T01-FRGN-INDIV-GRANTS-2013 CSV Parquet 6,726
2012 SF-P03-T01-FRGN-INDIV-GRANTS-2012 CSV Parquet 6,021
2011 SF-P03-T01-FRGN-INDIV-GRANTS-2011 CSV Parquet 5,396
2010 SF-P03-T01-FRGN-INDIV-GRANTS-2010 CSV Parquet 4,560
2009 SF-P03-T01-FRGN-INDIV-GRANTS-2009 CSV Parquet 2,338
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SF-P03-T01-FRGN-INDIV-GRANTS",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P04 Part IV - Foreign Forms

SF-P04-T00-FRGN-INTERESTS

1:1 one row per filing · tax years 2010–2025 · 194,576 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SF-P04-T00-FRGN-INTERESTS-2025 CSV Parquet 4,870
2024 SF-P04-T00-FRGN-INTERESTS-2024 CSV Parquet 18,696
2023 SF-P04-T00-FRGN-INTERESTS-2023 CSV Parquet 18,318
2022 SF-P04-T00-FRGN-INTERESTS-2022 CSV Parquet 17,539
2021 SF-P04-T00-FRGN-INTERESTS-2021 CSV Parquet 16,351
2020 SF-P04-T00-FRGN-INTERESTS-2020 CSV Parquet 15,347
2019 SF-P04-T00-FRGN-INTERESTS-2019 CSV Parquet 14,221
2018 SF-P04-T00-FRGN-INTERESTS-2018 CSV Parquet 13,640
2017 SF-P04-T00-FRGN-INTERESTS-2017 CSV Parquet 13,006
2016 SF-P04-T00-FRGN-INTERESTS-2016 CSV Parquet 12,009
2015 SF-P04-T00-FRGN-INTERESTS-2015 CSV Parquet 11,364
2014 SF-P04-T00-FRGN-INTERESTS-2014 CSV Parquet 10,349
2013 SF-P04-T00-FRGN-INTERESTS-2013 CSV Parquet 9,224
2012 SF-P04-T00-FRGN-INTERESTS-2012 CSV Parquet 8,126
2011 SF-P04-T00-FRGN-INTERESTS-2011 CSV Parquet 6,509
2010 SF-P04-T00-FRGN-INTERESTS-2010 CSV Parquet 5,007
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SF-P04-T00-FRGN-INTERESTS",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P05 Part V - Supplemental Information

SF-P05-T99-EXPLANATION-TEXT

1:M many rows per filing · tax years 2009–2025 · 199,779 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SF-P05-T99-EXPLANATION-TEXT-2025 CSV Parquet 4,145
2024 SF-P05-T99-EXPLANATION-TEXT-2024 CSV Parquet 16,702
2023 SF-P05-T99-EXPLANATION-TEXT-2023 CSV Parquet 16,502
2022 SF-P05-T99-EXPLANATION-TEXT-2022 CSV Parquet 23,566
2021 SF-P05-T99-EXPLANATION-TEXT-2021 CSV Parquet 22,086
2020 SF-P05-T99-EXPLANATION-TEXT-2020 CSV Parquet 20,801
2019 SF-P05-T99-EXPLANATION-TEXT-2019 CSV Parquet 19,213
2018 SF-P05-T99-EXPLANATION-TEXT-2018 CSV Parquet 12,008
2017 SF-P05-T99-EXPLANATION-TEXT-2017 CSV Parquet 11,600
2016 SF-P05-T99-EXPLANATION-TEXT-2016 CSV Parquet 10,601
2015 SF-P05-T99-EXPLANATION-TEXT-2015 CSV Parquet 9,752
2014 SF-P05-T99-EXPLANATION-TEXT-2014 CSV Parquet 8,678
2013 SF-P05-T99-EXPLANATION-TEXT-2013 CSV Parquet 7,392
2012 SF-P05-T99-EXPLANATION-TEXT-2012 CSV Parquet 6,410
2011 SF-P05-T99-EXPLANATION-TEXT-2011 CSV Parquet 5,425
2010 SF-P05-T99-EXPLANATION-TEXT-2010 CSV Parquet 3,722
2009 SF-P05-T99-EXPLANATION-TEXT-2009 CSV Parquet 1,176
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SF-P05-T99-EXPLANATION-TEXT",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P99 Lines from earlier versions of the schedule

SF-P99-T00-FRGN-ORG-GRANTS

1:1 one row per filing · tax years 2009–2011 · 2,097 rows · Data dictionary

Year Table CSV Parquet Rows
2011 SF-P99-T00-FRGN-ORG-GRANTS-2011 CSV Parquet 1,115
2010 SF-P99-T00-FRGN-ORG-GRANTS-2010 CSV Parquet 808
2009 SF-P99-T00-FRGN-ORG-GRANTS-2009 CSV Parquet 174
Download with panel990
library( panel990 )

# Panel of tax years 2009-2011
# with BMF fields appended

panel <- 
  panelize( tables = "SF-P99-T00-FRGN-ORG-GRANTS",
            years = 2009:2011,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

Schedule G: Supplemental Information Regarding Fundraising or Gaming Activities

P01 Part I - Fundraising Activities

SG-P01-T00-FUNDRAISING-ACTS

1:1 one row per filing · tax years 2009–2025 · 344,488 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SG-P01-T00-FUNDRAISING-ACTS-2025 CSV Parquet 7,226
2024 SG-P01-T00-FUNDRAISING-ACTS-2024 CSV Parquet 27,162
2023 SG-P01-T00-FUNDRAISING-ACTS-2023 CSV Parquet 27,836
2022 SG-P01-T00-FUNDRAISING-ACTS-2022 CSV Parquet 26,395
2021 SG-P01-T00-FUNDRAISING-ACTS-2021 CSV Parquet 23,693
2020 SG-P01-T00-FUNDRAISING-ACTS-2020 CSV Parquet 19,686
2019 SG-P01-T00-FUNDRAISING-ACTS-2019 CSV Parquet 23,552
2018 SG-P01-T00-FUNDRAISING-ACTS-2018 CSV Parquet 25,630
2017 SG-P01-T00-FUNDRAISING-ACTS-2017 CSV Parquet 25,364
2016 SG-P01-T00-FUNDRAISING-ACTS-2016 CSV Parquet 23,586
2015 SG-P01-T00-FUNDRAISING-ACTS-2015 CSV Parquet 22,883
2014 SG-P01-T00-FUNDRAISING-ACTS-2014 CSV Parquet 21,505
2013 SG-P01-T00-FUNDRAISING-ACTS-2013 CSV Parquet 19,650
2012 SG-P01-T00-FUNDRAISING-ACTS-2012 CSV Parquet 17,922
2011 SG-P01-T00-FUNDRAISING-ACTS-2011 CSV Parquet 16,534
2010 SG-P01-T00-FUNDRAISING-ACTS-2010 CSV Parquet 12,349
2009 SG-P01-T00-FUNDRAISING-ACTS-2009 CSV Parquet 3,515
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SG-P01-T00-FUNDRAISING-ACTS",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SG-P01-T01-FUNDRAISERS-INFO

1:M many rows per filing · tax years 2009–2025 · 127,287 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SG-P01-T01-FUNDRAISERS-INFO-2025 CSV Parquet 1,636
2024 SG-P01-T01-FUNDRAISERS-INFO-2024 CSV Parquet 10,532
2023 SG-P01-T01-FUNDRAISERS-INFO-2023 CSV Parquet 10,210
2022 SG-P01-T01-FUNDRAISERS-INFO-2022 CSV Parquet 9,865
2021 SG-P01-T01-FUNDRAISERS-INFO-2021 CSV Parquet 9,069
2020 SG-P01-T01-FUNDRAISERS-INFO-2020 CSV Parquet 8,313
2019 SG-P01-T01-FUNDRAISERS-INFO-2019 CSV Parquet 8,525
2018 SG-P01-T01-FUNDRAISERS-INFO-2018 CSV Parquet 8,529
2017 SG-P01-T01-FUNDRAISERS-INFO-2017 CSV Parquet 8,754
2016 SG-P01-T01-FUNDRAISERS-INFO-2016 CSV Parquet 8,162
2015 SG-P01-T01-FUNDRAISERS-INFO-2015 CSV Parquet 8,153
2014 SG-P01-T01-FUNDRAISERS-INFO-2014 CSV Parquet 7,823
2013 SG-P01-T01-FUNDRAISERS-INFO-2013 CSV Parquet 7,484
2012 SG-P01-T01-FUNDRAISERS-INFO-2012 CSV Parquet 6,974
2011 SG-P01-T01-FUNDRAISERS-INFO-2011 CSV Parquet 6,100
2010 SG-P01-T01-FUNDRAISERS-INFO-2010 CSV Parquet 4,916
2009 SG-P01-T01-FUNDRAISERS-INFO-2009 CSV Parquet 2,242
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SG-P01-T01-FUNDRAISERS-INFO",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P02 Part II - Fundraising Events

SG-P02-T00-FUNDRAISING-EVENTS

1:1 one row per filing · tax years 2009–2025 · 1,238,991 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SG-P02-T00-FUNDRAISING-EVENTS-2025 CSV Parquet 29,850
2024 SG-P02-T00-FUNDRAISING-EVENTS-2024 CSV Parquet 107,659
2023 SG-P02-T00-FUNDRAISING-EVENTS-2023 CSV Parquet 105,904
2022 SG-P02-T00-FUNDRAISING-EVENTS-2022 CSV Parquet 99,861
2021 SG-P02-T00-FUNDRAISING-EVENTS-2021 CSV Parquet 87,668
2020 SG-P02-T00-FUNDRAISING-EVENTS-2020 CSV Parquet 67,338
2019 SG-P02-T00-FUNDRAISING-EVENTS-2019 CSV Parquet 87,587
2018 SG-P02-T00-FUNDRAISING-EVENTS-2018 CSV Parquet 92,268
2017 SG-P02-T00-FUNDRAISING-EVENTS-2017 CSV Parquet 89,615
2016 SG-P02-T00-FUNDRAISING-EVENTS-2016 CSV Parquet 83,446
2015 SG-P02-T00-FUNDRAISING-EVENTS-2015 CSV Parquet 80,430
2014 SG-P02-T00-FUNDRAISING-EVENTS-2014 CSV Parquet 75,530
2013 SG-P02-T00-FUNDRAISING-EVENTS-2013 CSV Parquet 67,967
2012 SG-P02-T00-FUNDRAISING-EVENTS-2012 CSV Parquet 60,661
2011 SG-P02-T00-FUNDRAISING-EVENTS-2011 CSV Parquet 53,502
2010 SG-P02-T00-FUNDRAISING-EVENTS-2010 CSV Parquet 37,929
2009 SG-P02-T00-FUNDRAISING-EVENTS-2009 CSV Parquet 11,776
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SG-P02-T00-FUNDRAISING-EVENTS",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P03 Part III - Gaming

SG-P03-T00-GAMING

1:1 one row per filing · tax years 2009–2025 · 187,541 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SG-P03-T00-GAMING-2025 CSV Parquet 5,379
2024 SG-P03-T00-GAMING-2024 CSV Parquet 17,077
2023 SG-P03-T00-GAMING-2023 CSV Parquet 17,282
2022 SG-P03-T00-GAMING-2022 CSV Parquet 16,408
2021 SG-P03-T00-GAMING-2021 CSV Parquet 15,327
2020 SG-P03-T00-GAMING-2020 CSV Parquet 13,216
2019 SG-P03-T00-GAMING-2019 CSV Parquet 12,819
2018 SG-P03-T00-GAMING-2018 CSV Parquet 12,632
2017 SG-P03-T00-GAMING-2017 CSV Parquet 12,142
2016 SG-P03-T00-GAMING-2016 CSV Parquet 11,374
2015 SG-P03-T00-GAMING-2015 CSV Parquet 11,677
2014 SG-P03-T00-GAMING-2014 CSV Parquet 10,170
2013 SG-P03-T00-GAMING-2013 CSV Parquet 9,298
2012 SG-P03-T00-GAMING-2012 CSV Parquet 8,212
2011 SG-P03-T00-GAMING-2011 CSV Parquet 7,246
2010 SG-P03-T00-GAMING-2010 CSV Parquet 5,615
2009 SG-P03-T00-GAMING-2009 CSV Parquet 1,667
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SG-P03-T00-GAMING",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P04 Part IV - Supplemental Information

SG-P04-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2010–2025 · 54,557 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SG-P04-T99-SUPPLEMENTAL-INFO-2025 CSV Parquet 1,500
2024 SG-P04-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 5,357
2023 SG-P04-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 5,122
2022 SG-P04-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 5,119
2021 SG-P04-T99-SUPPLEMENTAL-INFO-2021 CSV Parquet 4,862
2020 SG-P04-T99-SUPPLEMENTAL-INFO-2020 CSV Parquet 4,019
2019 SG-P04-T99-SUPPLEMENTAL-INFO-2019 CSV Parquet 3,768
2018 SG-P04-T99-SUPPLEMENTAL-INFO-2018 CSV Parquet 3,639
2017 SG-P04-T99-SUPPLEMENTAL-INFO-2017 CSV Parquet 3,470
2016 SG-P04-T99-SUPPLEMENTAL-INFO-2016 CSV Parquet 3,315
2015 SG-P04-T99-SUPPLEMENTAL-INFO-2015 CSV Parquet 3,105
2014 SG-P04-T99-SUPPLEMENTAL-INFO-2014 CSV Parquet 2,946
2013 SG-P04-T99-SUPPLEMENTAL-INFO-2013 CSV Parquet 2,589
2012 SG-P04-T99-SUPPLEMENTAL-INFO-2012 CSV Parquet 2,279
2011 SG-P04-T99-SUPPLEMENTAL-INFO-2011 CSV Parquet 2,003
2010 SG-P04-T99-SUPPLEMENTAL-INFO-2010 CSV Parquet 1,464
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SG-P04-T99-SUPPLEMENTAL-INFO",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

Schedule H: Hospitals

P01 Part I - Financial Assistance and Certain Other Community Benefits at Cost

SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY

1:1 one row per filing · tax years 2009–2025 · 37,303 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2025 CSV Parquet 20
2024 SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2024 CSV Parquet 2,278
2023 SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2023 CSV Parquet 2,341
2022 SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2022 CSV Parquet 2,360
2021 SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2021 CSV Parquet 2,327
2020 SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2020 CSV Parquet 2,351
2019 SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2019 CSV Parquet 2,306
2018 SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2018 CSV Parquet 2,331
2017 SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2017 CSV Parquet 2,415
2016 SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2016 CSV Parquet 2,330
2015 SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2015 CSV Parquet 2,397
2014 SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2014 CSV Parquet 2,420
2013 SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2013 CSV Parquet 2,439
2012 SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2012 CSV Parquet 2,454
2011 SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2011 CSV Parquet 2,472
2010 SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2010 CSV Parquet 2,469
2009 SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2009 CSV Parquet 1,593
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P02 Part II - Community Building Activities

SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY

1:1 one row per filing · tax years 2009–2025 · 20,901 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2025 CSV Parquet 7
2024 SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2024 CSV Parquet 1,433
2023 SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2023 CSV Parquet 1,438
2022 SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2022 CSV Parquet 1,331
2021 SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2021 CSV Parquet 1,266
2020 SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2020 CSV Parquet 1,219
2019 SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2019 CSV Parquet 1,242
2018 SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2018 CSV Parquet 1,274
2017 SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2017 CSV Parquet 1,332
2016 SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2016 CSV Parquet 1,305
2015 SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2015 CSV Parquet 1,354
2014 SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2014 CSV Parquet 1,348
2013 SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2013 CSV Parquet 1,385
2012 SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2012 CSV Parquet 1,395
2011 SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2011 CSV Parquet 1,378
2010 SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2010 CSV Parquet 1,369
2009 SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2009 CSV Parquet 825
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P03 Part III - Bad Debt, Medicare, and Collection Practices

SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY

1:1 one row per filing · tax years 2009–2025 · 37,195 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2025 CSV Parquet 18
2024 SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2024 CSV Parquet 2,275
2023 SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2023 CSV Parquet 2,340
2022 SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2022 CSV Parquet 2,357
2021 SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2021 CSV Parquet 2,326
2020 SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2020 CSV Parquet 2,350
2019 SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2019 CSV Parquet 2,306
2018 SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2018 CSV Parquet 2,331
2017 SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2017 CSV Parquet 2,415
2016 SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2016 CSV Parquet 2,329
2015 SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2015 CSV Parquet 2,397
2014 SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2014 CSV Parquet 2,420
2013 SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2013 CSV Parquet 2,439
2012 SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2012 CSV Parquet 2,452
2011 SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2011 CSV Parquet 2,469
2010 SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2010 CSV Parquet 2,466
2009 SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2009 CSV Parquet 1,505
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P04 Part IV - Management Companies and Joint Ventures

SH-P04-T01-COMPANY-JOINT-VENTURES

1:M many rows per filing · tax years 2009–2025 · 18,495 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SH-P04-T01-COMPANY-JOINT-VENTURES-2025 CSV Parquet 5
2024 SH-P04-T01-COMPANY-JOINT-VENTURES-2024 CSV Parquet 983
2023 SH-P04-T01-COMPANY-JOINT-VENTURES-2023 CSV Parquet 969
2022 SH-P04-T01-COMPANY-JOINT-VENTURES-2022 CSV Parquet 1,029
2021 SH-P04-T01-COMPANY-JOINT-VENTURES-2021 CSV Parquet 1,043
2020 SH-P04-T01-COMPANY-JOINT-VENTURES-2020 CSV Parquet 1,050
2019 SH-P04-T01-COMPANY-JOINT-VENTURES-2019 CSV Parquet 1,080
2018 SH-P04-T01-COMPANY-JOINT-VENTURES-2018 CSV Parquet 1,105
2017 SH-P04-T01-COMPANY-JOINT-VENTURES-2017 CSV Parquet 1,148
2016 SH-P04-T01-COMPANY-JOINT-VENTURES-2016 CSV Parquet 1,153
2015 SH-P04-T01-COMPANY-JOINT-VENTURES-2015 CSV Parquet 1,241
2014 SH-P04-T01-COMPANY-JOINT-VENTURES-2014 CSV Parquet 1,334
2013 SH-P04-T01-COMPANY-JOINT-VENTURES-2013 CSV Parquet 1,352
2012 SH-P04-T01-COMPANY-JOINT-VENTURES-2012 CSV Parquet 1,423
2011 SH-P04-T01-COMPANY-JOINT-VENTURES-2011 CSV Parquet 1,408
2010 SH-P04-T01-COMPANY-JOINT-VENTURES-2010 CSV Parquet 1,389
2009 SH-P04-T01-COMPANY-JOINT-VENTURES-2009 CSV Parquet 783
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SH-P04-T01-COMPANY-JOINT-VENTURES",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P05 Part V - Facility Information

SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY

1:1 one row per filing · tax years 2010–2025 · 35,724 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2025 CSV Parquet 21
2024 SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2024 CSV Parquet 2,279
2023 SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2023 CSV Parquet 2,342
2022 SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2022 CSV Parquet 2,360
2021 SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2021 CSV Parquet 2,328
2020 SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2020 CSV Parquet 2,352
2019 SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2019 CSV Parquet 2,306
2018 SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2018 CSV Parquet 2,331
2017 SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2017 CSV Parquet 2,415
2016 SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2016 CSV Parquet 2,330
2015 SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2015 CSV Parquet 2,397
2014 SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2014 CSV Parquet 2,420
2013 SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2013 CSV Parquet 2,439
2012 SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2012 CSV Parquet 2,454
2011 SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2011 CSV Parquet 2,475
2010 SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2010 CSV Parquet 2,475
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SH-P05-T01-HOSPITAL-FACILITY

1:M many rows per filing · tax years 2009–2025 · 63,205 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SH-P05-T01-HOSPITAL-FACILITY-2025 CSV Parquet 35
2024 SH-P05-T01-HOSPITAL-FACILITY-2024 CSV Parquet 3,788
2023 SH-P05-T01-HOSPITAL-FACILITY-2023 CSV Parquet 3,778
2022 SH-P05-T01-HOSPITAL-FACILITY-2022 CSV Parquet 3,738
2021 SH-P05-T01-HOSPITAL-FACILITY-2021 CSV Parquet 3,685
2020 SH-P05-T01-HOSPITAL-FACILITY-2020 CSV Parquet 3,732
2019 SH-P05-T01-HOSPITAL-FACILITY-2019 CSV Parquet 3,636
2018 SH-P05-T01-HOSPITAL-FACILITY-2018 CSV Parquet 3,648
2017 SH-P05-T01-HOSPITAL-FACILITY-2017 CSV Parquet 3,768
2016 SH-P05-T01-HOSPITAL-FACILITY-2016 CSV Parquet 3,594
2015 SH-P05-T01-HOSPITAL-FACILITY-2015 CSV Parquet 3,635
2014 SH-P05-T01-HOSPITAL-FACILITY-2014 CSV Parquet 3,706
2013 SH-P05-T01-HOSPITAL-FACILITY-2013 CSV Parquet 3,706
2012 SH-P05-T01-HOSPITAL-FACILITY-2012 CSV Parquet 3,815
2011 SH-P05-T01-HOSPITAL-FACILITY-2011 CSV Parquet 3,868
2010 SH-P05-T01-HOSPITAL-FACILITY-2010 CSV Parquet 4,423
2009 SH-P05-T01-HOSPITAL-FACILITY-2009 CSV Parquet 6,650
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SH-P05-T01-HOSPITAL-FACILITY",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SH-P05-T02-NON-HOSPITAL-FACILITY

1:M many rows per filing · tax years 2010–2025 · 329,956 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SH-P05-T02-NON-HOSPITAL-FACILITY-2025 CSV Parquet 115
2024 SH-P05-T02-NON-HOSPITAL-FACILITY-2024 CSV Parquet 30,177
2023 SH-P05-T02-NON-HOSPITAL-FACILITY-2023 CSV Parquet 27,789
2022 SH-P05-T02-NON-HOSPITAL-FACILITY-2022 CSV Parquet 27,423
2021 SH-P05-T02-NON-HOSPITAL-FACILITY-2021 CSV Parquet 26,133
2020 SH-P05-T02-NON-HOSPITAL-FACILITY-2020 CSV Parquet 25,108
2019 SH-P05-T02-NON-HOSPITAL-FACILITY-2019 CSV Parquet 25,283
2018 SH-P05-T02-NON-HOSPITAL-FACILITY-2018 CSV Parquet 24,299
2017 SH-P05-T02-NON-HOSPITAL-FACILITY-2017 CSV Parquet 22,616
2016 SH-P05-T02-NON-HOSPITAL-FACILITY-2016 CSV Parquet 21,274
2015 SH-P05-T02-NON-HOSPITAL-FACILITY-2015 CSV Parquet 20,130
2014 SH-P05-T02-NON-HOSPITAL-FACILITY-2014 CSV Parquet 18,474
2013 SH-P05-T02-NON-HOSPITAL-FACILITY-2013 CSV Parquet 17,343
2012 SH-P05-T02-NON-HOSPITAL-FACILITY-2012 CSV Parquet 15,721
2011 SH-P05-T02-NON-HOSPITAL-FACILITY-2011 CSV Parquet 15,150
2010 SH-P05-T02-NON-HOSPITAL-FACILITY-2010 CSV Parquet 12,921
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SH-P05-T02-NON-HOSPITAL-FACILITY",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SH-P05-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2013–2025 · 191,233 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SH-P05-T99-SUPPLEMENTAL-INFO-2025 CSV Parquet 141
2024 SH-P05-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 16,974
2023 SH-P05-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 17,201
2022 SH-P05-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 17,285
2021 SH-P05-T99-SUPPLEMENTAL-INFO-2021 CSV Parquet 17,126
2020 SH-P05-T99-SUPPLEMENTAL-INFO-2020 CSV Parquet 17,046
2019 SH-P05-T99-SUPPLEMENTAL-INFO-2019 CSV Parquet 16,310
2018 SH-P05-T99-SUPPLEMENTAL-INFO-2018 CSV Parquet 15,660
2017 SH-P05-T99-SUPPLEMENTAL-INFO-2017 CSV Parquet 15,416
2016 SH-P05-T99-SUPPLEMENTAL-INFO-2016 CSV Parquet 14,041
2015 SH-P05-T99-SUPPLEMENTAL-INFO-2015 CSV Parquet 14,932
2014 SH-P05-T99-SUPPLEMENTAL-INFO-2014 CSV Parquet 17,233
2013 SH-P05-T99-SUPPLEMENTAL-INFO-2013 CSV Parquet 11,868
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SH-P05-T99-SUPPLEMENTAL-INFO",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SH-P05-T03-FACILITY-POLICIES-PRACTICES

1:M many rows per filing · tax years 2010–2025 · 43,924 rows · Data dictionary

Schedule H Part V Section B: facility policies and practices (one row per hospital facility)

Year Table CSV Parquet Rows
2025 SH-P05-T03-FACILITY-POLICIES-PRACTICES-2025 CSV Parquet 25
2024 SH-P05-T03-FACILITY-POLICIES-PRACTICES-2024 CSV Parquet 2,672
2023 SH-P05-T03-FACILITY-POLICIES-PRACTICES-2023 CSV Parquet 2,735
2022 SH-P05-T03-FACILITY-POLICIES-PRACTICES-2022 CSV Parquet 2,746
2021 SH-P05-T03-FACILITY-POLICIES-PRACTICES-2021 CSV Parquet 2,735
2020 SH-P05-T03-FACILITY-POLICIES-PRACTICES-2020 CSV Parquet 2,773
2019 SH-P05-T03-FACILITY-POLICIES-PRACTICES-2019 CSV Parquet 2,725
2018 SH-P05-T03-FACILITY-POLICIES-PRACTICES-2018 CSV Parquet 2,772
2017 SH-P05-T03-FACILITY-POLICIES-PRACTICES-2017 CSV Parquet 2,871
2016 SH-P05-T03-FACILITY-POLICIES-PRACTICES-2016 CSV Parquet 2,762
2015 SH-P05-T03-FACILITY-POLICIES-PRACTICES-2015 CSV Parquet 2,856
2014 SH-P05-T03-FACILITY-POLICIES-PRACTICES-2014 CSV Parquet 2,937
2013 SH-P05-T03-FACILITY-POLICIES-PRACTICES-2013 CSV Parquet 2,979
2012 SH-P05-T03-FACILITY-POLICIES-PRACTICES-2012 CSV Parquet 2,979
2011 SH-P05-T03-FACILITY-POLICIES-PRACTICES-2011 CSV Parquet 3,691
2010 SH-P05-T03-FACILITY-POLICIES-PRACTICES-2010 CSV Parquet 3,666
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SH-P05-T03-FACILITY-POLICIES-PRACTICES",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P06 Part VI - Supplemental Information

SH-P06-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2009–2025 · 468,562 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SH-P06-T99-SUPPLEMENTAL-INFO-2025 CSV Parquet 219
2024 SH-P06-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 32,532
2023 SH-P06-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 32,635
2022 SH-P06-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 32,134
2021 SH-P06-T99-SUPPLEMENTAL-INFO-2021 CSV Parquet 31,246
2020 SH-P06-T99-SUPPLEMENTAL-INFO-2020 CSV Parquet 30,467
2019 SH-P06-T99-SUPPLEMENTAL-INFO-2019 CSV Parquet 29,780
2018 SH-P06-T99-SUPPLEMENTAL-INFO-2018 CSV Parquet 30,230
2017 SH-P06-T99-SUPPLEMENTAL-INFO-2017 CSV Parquet 30,872
2016 SH-P06-T99-SUPPLEMENTAL-INFO-2016 CSV Parquet 29,481
2015 SH-P06-T99-SUPPLEMENTAL-INFO-2015 CSV Parquet 29,463
2014 SH-P06-T99-SUPPLEMENTAL-INFO-2014 CSV Parquet 29,367
2013 SH-P06-T99-SUPPLEMENTAL-INFO-2013 CSV Parquet 28,781
2012 SH-P06-T99-SUPPLEMENTAL-INFO-2012 CSV Parquet 37,370
2011 SH-P06-T99-SUPPLEMENTAL-INFO-2011 CSV Parquet 33,584
2010 SH-P06-T99-SUPPLEMENTAL-INFO-2010 CSV Parquet 28,649
2009 SH-P06-T99-SUPPLEMENTAL-INFO-2009 CSV Parquet 1,752
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SH-P06-T99-SUPPLEMENTAL-INFO",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P99 Lines from earlier versions of the schedule (Part V, Section B facility policies)

SH-P99-T01-FAP-COMMUNITY-BENEFIT-POLICY

1:M many rows per filing · tax years 2010–2015 · 16,297 rows · Data dictionary

Year Table CSV Parquet Rows
2015 SH-P99-T01-FAP-COMMUNITY-BENEFIT-POLICY-2015 CSV Parquet 2,821
2014 SH-P99-T01-FAP-COMMUNITY-BENEFIT-POLICY-2014 CSV Parquet 2,901
2013 SH-P99-T01-FAP-COMMUNITY-BENEFIT-POLICY-2013 CSV Parquet 2,979
2012 SH-P99-T01-FAP-COMMUNITY-BENEFIT-POLICY-2012 CSV Parquet 2,979
2011 SH-P99-T01-FAP-COMMUNITY-BENEFIT-POLICY-2011 CSV Parquet 3,530
2010 SH-P99-T01-FAP-COMMUNITY-BENEFIT-POLICY-2010 CSV Parquet 1,087
Download with panel990
library( panel990 )

# Panel of tax years 2011-2015
# with BMF fields appended

panel <- 
  panelize( tables = "SH-P99-T01-FAP-COMMUNITY-BENEFIT-POLICY",
            years = 2011:2015,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

Schedule I: Grants and Other Assistance to Organizations, Governments, and Individuals in the United States

P01 Part I - General Information on Grants and Assistance

SI-P01-T00-GRANTS-INFO

1:1 one row per filing · tax years 2009–2025 · 899,783 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SI-P01-T00-GRANTS-INFO-2025 CSV Parquet 18,785
2024 SI-P01-T00-GRANTS-INFO-2024 CSV Parquet 83,244
2023 SI-P01-T00-GRANTS-INFO-2023 CSV Parquet 80,718
2022 SI-P01-T00-GRANTS-INFO-2022 CSV Parquet 77,686
2021 SI-P01-T00-GRANTS-INFO-2021 CSV Parquet 73,446
2020 SI-P01-T00-GRANTS-INFO-2020 CSV Parquet 69,600
2019 SI-P01-T00-GRANTS-INFO-2019 CSV Parquet 63,348
2018 SI-P01-T00-GRANTS-INFO-2018 CSV Parquet 60,914
2017 SI-P01-T00-GRANTS-INFO-2017 CSV Parquet 58,979
2016 SI-P01-T00-GRANTS-INFO-2016 CSV Parquet 54,111
2015 SI-P01-T00-GRANTS-INFO-2015 CSV Parquet 51,578
2014 SI-P01-T00-GRANTS-INFO-2014 CSV Parquet 48,644
2013 SI-P01-T00-GRANTS-INFO-2013 CSV Parquet 44,744
2012 SI-P01-T00-GRANTS-INFO-2012 CSV Parquet 41,356
2011 SI-P01-T00-GRANTS-INFO-2011 CSV Parquet 35,498
2010 SI-P01-T00-GRANTS-INFO-2010 CSV Parquet 27,559
2009 SI-P01-T00-GRANTS-INFO-2009 CSV Parquet 9,573
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SI-P01-T00-GRANTS-INFO",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P02 Part II - Grants and Other Assistance to Domestic Organizations and Domestic Governments

SI-P02-T00-GRANTS-US-ORGS-GOVTS

1:1 one row per filing · tax years 2009–2025 · 440,209 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SI-P02-T00-GRANTS-US-ORGS-GOVTS-2025 CSV Parquet 8,311
2024 SI-P02-T00-GRANTS-US-ORGS-GOVTS-2024 CSV Parquet 39,746
2023 SI-P02-T00-GRANTS-US-ORGS-GOVTS-2023 CSV Parquet 39,194
2022 SI-P02-T00-GRANTS-US-ORGS-GOVTS-2022 CSV Parquet 37,802
2021 SI-P02-T00-GRANTS-US-ORGS-GOVTS-2021 CSV Parquet 36,023
2020 SI-P02-T00-GRANTS-US-ORGS-GOVTS-2020 CSV Parquet 34,242
2019 SI-P02-T00-GRANTS-US-ORGS-GOVTS-2019 CSV Parquet 31,046
2018 SI-P02-T00-GRANTS-US-ORGS-GOVTS-2018 CSV Parquet 30,005
2017 SI-P02-T00-GRANTS-US-ORGS-GOVTS-2017 CSV Parquet 28,963
2016 SI-P02-T00-GRANTS-US-ORGS-GOVTS-2016 CSV Parquet 26,368
2015 SI-P02-T00-GRANTS-US-ORGS-GOVTS-2015 CSV Parquet 25,257
2014 SI-P02-T00-GRANTS-US-ORGS-GOVTS-2014 CSV Parquet 23,841
2013 SI-P02-T00-GRANTS-US-ORGS-GOVTS-2013 CSV Parquet 21,778
2012 SI-P02-T00-GRANTS-US-ORGS-GOVTS-2012 CSV Parquet 20,424
2011 SI-P02-T00-GRANTS-US-ORGS-GOVTS-2011 CSV Parquet 18,226
2010 SI-P02-T00-GRANTS-US-ORGS-GOVTS-2010 CSV Parquet 14,216
2009 SI-P02-T00-GRANTS-US-ORGS-GOVTS-2009 CSV Parquet 4,767
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SI-P02-T00-GRANTS-US-ORGS-GOVTS",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SI-P02-T01-GRANTS-US-ORGS-GOVTS

1:M many rows per filing · tax years 2009–2025 · 9,427,776 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SI-P02-T01-GRANTS-US-ORGS-GOVTS-2025 CSV Parquet 133,615
2024 SI-P02-T01-GRANTS-US-ORGS-GOVTS-2024 CSV Parquet 1,087,500
2023 SI-P02-T01-GRANTS-US-ORGS-GOVTS-2023 CSV Parquet 979,773
2022 SI-P02-T01-GRANTS-US-ORGS-GOVTS-2022 CSV Parquet 929,785
2021 SI-P02-T01-GRANTS-US-ORGS-GOVTS-2021 CSV Parquet 899,654
2020 SI-P02-T01-GRANTS-US-ORGS-GOVTS-2020 CSV Parquet 909,188
2019 SI-P02-T01-GRANTS-US-ORGS-GOVTS-2019 CSV Parquet 699,433
2018 SI-P02-T01-GRANTS-US-ORGS-GOVTS-2018 CSV Parquet 615,253
2017 SI-P02-T01-GRANTS-US-ORGS-GOVTS-2017 CSV Parquet 559,142
2016 SI-P02-T01-GRANTS-US-ORGS-GOVTS-2016 CSV Parquet 514,898
2015 SI-P02-T01-GRANTS-US-ORGS-GOVTS-2015 CSV Parquet 450,252
2014 SI-P02-T01-GRANTS-US-ORGS-GOVTS-2014 CSV Parquet 412,294
2013 SI-P02-T01-GRANTS-US-ORGS-GOVTS-2013 CSV Parquet 344,652
2012 SI-P02-T01-GRANTS-US-ORGS-GOVTS-2012 CSV Parquet 306,677
2011 SI-P02-T01-GRANTS-US-ORGS-GOVTS-2011 CSV Parquet 273,265
2010 SI-P02-T01-GRANTS-US-ORGS-GOVTS-2010 CSV Parquet 228,950
2009 SI-P02-T01-GRANTS-US-ORGS-GOVTS-2009 CSV Parquet 83,445
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SI-P02-T01-GRANTS-US-ORGS-GOVTS",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P03 Part III - Grants and Other Assistance to Domestic Individuals

SI-P03-T01-GRANTS-US-INDIV

1:M many rows per filing · tax years 2009–2025 · 851,991 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SI-P03-T01-GRANTS-US-INDIV-2025 CSV Parquet 13,718
2024 SI-P03-T01-GRANTS-US-INDIV-2024 CSV Parquet 75,554
2023 SI-P03-T01-GRANTS-US-INDIV-2023 CSV Parquet 74,420
2022 SI-P03-T01-GRANTS-US-INDIV-2022 CSV Parquet 72,452
2021 SI-P03-T01-GRANTS-US-INDIV-2021 CSV Parquet 67,750
2020 SI-P03-T01-GRANTS-US-INDIV-2020 CSV Parquet 64,343
2019 SI-P03-T01-GRANTS-US-INDIV-2019 CSV Parquet 59,447
2018 SI-P03-T01-GRANTS-US-INDIV-2018 CSV Parquet 57,863
2017 SI-P03-T01-GRANTS-US-INDIV-2017 CSV Parquet 56,452
2016 SI-P03-T01-GRANTS-US-INDIV-2016 CSV Parquet 51,241
2015 SI-P03-T01-GRANTS-US-INDIV-2015 CSV Parquet 48,866
2014 SI-P03-T01-GRANTS-US-INDIV-2014 CSV Parquet 46,651
2013 SI-P03-T01-GRANTS-US-INDIV-2013 CSV Parquet 42,981
2012 SI-P03-T01-GRANTS-US-INDIV-2012 CSV Parquet 40,320
2011 SI-P03-T01-GRANTS-US-INDIV-2011 CSV Parquet 36,691
2010 SI-P03-T01-GRANTS-US-INDIV-2010 CSV Parquet 30,105
2009 SI-P03-T01-GRANTS-US-INDIV-2009 CSV Parquet 13,137
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SI-P03-T01-GRANTS-US-INDIV",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P04 Part IV - Supplemental Information

SI-P04-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2009–2025 · 598,559 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SI-P04-T99-SUPPLEMENTAL-INFO-2025 CSV Parquet 9,221
2024 SI-P04-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 50,666
2023 SI-P04-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 49,465
2022 SI-P04-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 48,176
2021 SI-P04-T99-SUPPLEMENTAL-INFO-2021 CSV Parquet 46,468
2020 SI-P04-T99-SUPPLEMENTAL-INFO-2020 CSV Parquet 45,476
2019 SI-P04-T99-SUPPLEMENTAL-INFO-2019 CSV Parquet 41,170
2018 SI-P04-T99-SUPPLEMENTAL-INFO-2018 CSV Parquet 39,107
2017 SI-P04-T99-SUPPLEMENTAL-INFO-2017 CSV Parquet 38,434
2016 SI-P04-T99-SUPPLEMENTAL-INFO-2016 CSV Parquet 36,729
2015 SI-P04-T99-SUPPLEMENTAL-INFO-2015 CSV Parquet 35,245
2014 SI-P04-T99-SUPPLEMENTAL-INFO-2014 CSV Parquet 34,151
2013 SI-P04-T99-SUPPLEMENTAL-INFO-2013 CSV Parquet 33,850
2012 SI-P04-T99-SUPPLEMENTAL-INFO-2012 CSV Parquet 31,461
2011 SI-P04-T99-SUPPLEMENTAL-INFO-2011 CSV Parquet 28,484
2010 SI-P04-T99-SUPPLEMENTAL-INFO-2010 CSV Parquet 22,681
2009 SI-P04-T99-SUPPLEMENTAL-INFO-2009 CSV Parquet 7,775
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SI-P04-T99-SUPPLEMENTAL-INFO",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P99 Lines from earlier versions of the schedule

SI-P99-T00-GRANTS-US-ORGS-GOVTS

1:1 one row per filing · tax years 2009–2011 · 8,375 rows · Data dictionary

Year Table CSV Parquet Rows
2011 SI-P99-T00-GRANTS-US-ORGS-GOVTS-2011 CSV Parquet 4,295
2010 SI-P99-T00-GRANTS-US-ORGS-GOVTS-2010 CSV Parquet 3,299
2009 SI-P99-T00-GRANTS-US-ORGS-GOVTS-2009 CSV Parquet 781
Download with panel990
library( panel990 )

# Panel of tax years 2009-2011
# with BMF fields appended

panel <- 
  panelize( tables = "SI-P99-T00-GRANTS-US-ORGS-GOVTS",
            years = 2009:2011,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

Schedule J: Compensation Information

P01 Part I - Questions Regarding Compensation

SJ-P01-T00-COMPENSATION

1:1 one row per filing · tax years 2009–2025 · 900,490 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SJ-P01-T00-COMPENSATION-2025 CSV Parquet 12,427
2024 SJ-P01-T00-COMPENSATION-2024 CSV Parquet 83,997
2023 SJ-P01-T00-COMPENSATION-2023 CSV Parquet 81,466
2022 SJ-P01-T00-COMPENSATION-2022 CSV Parquet 76,928
2021 SJ-P01-T00-COMPENSATION-2021 CSV Parquet 72,502
2020 SJ-P01-T00-COMPENSATION-2020 CSV Parquet 68,900
2019 SJ-P01-T00-COMPENSATION-2019 CSV Parquet 62,675
2018 SJ-P01-T00-COMPENSATION-2018 CSV Parquet 59,758
2017 SJ-P01-T00-COMPENSATION-2017 CSV Parquet 58,287
2016 SJ-P01-T00-COMPENSATION-2016 CSV Parquet 53,617
2015 SJ-P01-T00-COMPENSATION-2015 CSV Parquet 51,280
2014 SJ-P01-T00-COMPENSATION-2014 CSV Parquet 48,165
2013 SJ-P01-T00-COMPENSATION-2013 CSV Parquet 44,479
2012 SJ-P01-T00-COMPENSATION-2012 CSV Parquet 41,301
2011 SJ-P01-T00-COMPENSATION-2011 CSV Parquet 37,953
2010 SJ-P01-T00-COMPENSATION-2010 CSV Parquet 32,717
2009 SJ-P01-T00-COMPENSATION-2009 CSV Parquet 14,038
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SJ-P01-T00-COMPENSATION",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P02 Part II - Officers, Directors, Trustees, Key Employees, and Highest Compensated Employees

SJ-P02-T01-COMPENSATION-DTK

1:M many rows per filing · tax years 2009–2025 · 3,495,863 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SJ-P02-T01-COMPENSATION-DTK-2025 CSV Parquet 34,112
2024 SJ-P02-T01-COMPENSATION-DTK-2024 CSV Parquet 333,382
2023 SJ-P02-T01-COMPENSATION-DTK-2023 CSV Parquet 320,575
2022 SJ-P02-T01-COMPENSATION-DTK-2022 CSV Parquet 301,105
2021 SJ-P02-T01-COMPENSATION-DTK-2021 CSV Parquet 280,067
2020 SJ-P02-T01-COMPENSATION-DTK-2020 CSV Parquet 266,836
2019 SJ-P02-T01-COMPENSATION-DTK-2019 CSV Parquet 243,303
2018 SJ-P02-T01-COMPENSATION-DTK-2018 CSV Parquet 231,132
2017 SJ-P02-T01-COMPENSATION-DTK-2017 CSV Parquet 225,046
2016 SJ-P02-T01-COMPENSATION-DTK-2016 CSV Parquet 204,871
2015 SJ-P02-T01-COMPENSATION-DTK-2015 CSV Parquet 196,710
2014 SJ-P02-T01-COMPENSATION-DTK-2014 CSV Parquet 184,000
2013 SJ-P02-T01-COMPENSATION-DTK-2013 CSV Parquet 170,550
2012 SJ-P02-T01-COMPENSATION-DTK-2012 CSV Parquet 159,751
2011 SJ-P02-T01-COMPENSATION-DTK-2011 CSV Parquet 147,645
2010 SJ-P02-T01-COMPENSATION-DTK-2010 CSV Parquet 132,025
2009 SJ-P02-T01-COMPENSATION-DTK-2009 CSV Parquet 64,753
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SJ-P02-T01-COMPENSATION-DTK",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P03 Part III - Supplemental Information

SJ-P03-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2009–2025 · 600,148 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SJ-P03-T99-SUPPLEMENTAL-INFO-2025 CSV Parquet 3,956
2024 SJ-P03-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 52,382
2023 SJ-P03-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 50,599
2022 SJ-P03-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 48,750
2021 SJ-P03-T99-SUPPLEMENTAL-INFO-2021 CSV Parquet 46,687
2020 SJ-P03-T99-SUPPLEMENTAL-INFO-2020 CSV Parquet 45,116
2019 SJ-P03-T99-SUPPLEMENTAL-INFO-2019 CSV Parquet 42,361
2018 SJ-P03-T99-SUPPLEMENTAL-INFO-2018 CSV Parquet 40,837
2017 SJ-P03-T99-SUPPLEMENTAL-INFO-2017 CSV Parquet 40,313
2016 SJ-P03-T99-SUPPLEMENTAL-INFO-2016 CSV Parquet 37,541
2015 SJ-P03-T99-SUPPLEMENTAL-INFO-2015 CSV Parquet 35,975
2014 SJ-P03-T99-SUPPLEMENTAL-INFO-2014 CSV Parquet 34,264
2013 SJ-P03-T99-SUPPLEMENTAL-INFO-2013 CSV Parquet 31,725
2012 SJ-P03-T99-SUPPLEMENTAL-INFO-2012 CSV Parquet 29,499
2011 SJ-P03-T99-SUPPLEMENTAL-INFO-2011 CSV Parquet 26,592
2010 SJ-P03-T99-SUPPLEMENTAL-INFO-2010 CSV Parquet 22,568
2009 SJ-P03-T99-SUPPLEMENTAL-INFO-2009 CSV Parquet 10,983
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SJ-P03-T99-SUPPLEMENTAL-INFO",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

Schedule K: Supplemental Information on Tax-Exempt Bonds

P01 Part I - Bond Issues

SK-P01-T01-BOND-ISSUES

1:M many rows per filing · tax years 2009–2025 · 160,892 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SK-P01-T01-BOND-ISSUES-2025 CSV Parquet 481
2024 SK-P01-T01-BOND-ISSUES-2024 CSV Parquet 10,072
2023 SK-P01-T01-BOND-ISSUES-2023 CSV Parquet 10,256
2022 SK-P01-T01-BOND-ISSUES-2022 CSV Parquet 10,332
2021 SK-P01-T01-BOND-ISSUES-2021 CSV Parquet 10,452
2020 SK-P01-T01-BOND-ISSUES-2020 CSV Parquet 10,665
2019 SK-P01-T01-BOND-ISSUES-2019 CSV Parquet 10,546
2018 SK-P01-T01-BOND-ISSUES-2018 CSV Parquet 10,585
2017 SK-P01-T01-BOND-ISSUES-2017 CSV Parquet 11,188
2016 SK-P01-T01-BOND-ISSUES-2016 CSV Parquet 10,584
2015 SK-P01-T01-BOND-ISSUES-2015 CSV Parquet 10,634
2014 SK-P01-T01-BOND-ISSUES-2014 CSV Parquet 10,503
2013 SK-P01-T01-BOND-ISSUES-2013 CSV Parquet 10,288
2012 SK-P01-T01-BOND-ISSUES-2012 CSV Parquet 10,196
2011 SK-P01-T01-BOND-ISSUES-2011 CSV Parquet 9,744
2010 SK-P01-T01-BOND-ISSUES-2010 CSV Parquet 8,959
2009 SK-P01-T01-BOND-ISSUES-2009 CSV Parquet 5,407
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SK-P01-T01-BOND-ISSUES",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P02 Part II - Proceeds

SK-P02-T01-BOND-PROCEEDS

1:M many rows per filing · tax years 2009–2025 · 159,185 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SK-P02-T01-BOND-PROCEEDS-2025 CSV Parquet 476
2024 SK-P02-T01-BOND-PROCEEDS-2024 CSV Parquet 10,062
2023 SK-P02-T01-BOND-PROCEEDS-2023 CSV Parquet 10,208
2022 SK-P02-T01-BOND-PROCEEDS-2022 CSV Parquet 10,271
2021 SK-P02-T01-BOND-PROCEEDS-2021 CSV Parquet 10,383
2020 SK-P02-T01-BOND-PROCEEDS-2020 CSV Parquet 10,576
2019 SK-P02-T01-BOND-PROCEEDS-2019 CSV Parquet 10,459
2018 SK-P02-T01-BOND-PROCEEDS-2018 CSV Parquet 10,505
2017 SK-P02-T01-BOND-PROCEEDS-2017 CSV Parquet 11,121
2016 SK-P02-T01-BOND-PROCEEDS-2016 CSV Parquet 10,496
2015 SK-P02-T01-BOND-PROCEEDS-2015 CSV Parquet 10,544
2014 SK-P02-T01-BOND-PROCEEDS-2014 CSV Parquet 10,403
2013 SK-P02-T01-BOND-PROCEEDS-2013 CSV Parquet 10,173
2012 SK-P02-T01-BOND-PROCEEDS-2012 CSV Parquet 10,041
2011 SK-P02-T01-BOND-PROCEEDS-2011 CSV Parquet 9,538
2010 SK-P02-T01-BOND-PROCEEDS-2010 CSV Parquet 8,690
2009 SK-P02-T01-BOND-PROCEEDS-2009 CSV Parquet 5,239
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SK-P02-T01-BOND-PROCEEDS",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P03 Part III - Private Business Use

SK-P03-T01-BOND-PRIVATE-BIZ-USE

1:M many rows per filing · tax years 2009–2025 · 150,135 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SK-P03-T01-BOND-PRIVATE-BIZ-USE-2025 CSV Parquet 421
2024 SK-P03-T01-BOND-PRIVATE-BIZ-USE-2024 CSV Parquet 9,473
2023 SK-P03-T01-BOND-PRIVATE-BIZ-USE-2023 CSV Parquet 9,559
2022 SK-P03-T01-BOND-PRIVATE-BIZ-USE-2022 CSV Parquet 9,637
2021 SK-P03-T01-BOND-PRIVATE-BIZ-USE-2021 CSV Parquet 9,781
2020 SK-P03-T01-BOND-PRIVATE-BIZ-USE-2020 CSV Parquet 9,960
2019 SK-P03-T01-BOND-PRIVATE-BIZ-USE-2019 CSV Parquet 9,873
2018 SK-P03-T01-BOND-PRIVATE-BIZ-USE-2018 CSV Parquet 9,913
2017 SK-P03-T01-BOND-PRIVATE-BIZ-USE-2017 CSV Parquet 10,509
2016 SK-P03-T01-BOND-PRIVATE-BIZ-USE-2016 CSV Parquet 9,886
2015 SK-P03-T01-BOND-PRIVATE-BIZ-USE-2015 CSV Parquet 9,984
2014 SK-P03-T01-BOND-PRIVATE-BIZ-USE-2014 CSV Parquet 9,862
2013 SK-P03-T01-BOND-PRIVATE-BIZ-USE-2013 CSV Parquet 9,692
2012 SK-P03-T01-BOND-PRIVATE-BIZ-USE-2012 CSV Parquet 9,621
2011 SK-P03-T01-BOND-PRIVATE-BIZ-USE-2011 CSV Parquet 9,137
2010 SK-P03-T01-BOND-PRIVATE-BIZ-USE-2010 CSV Parquet 8,152
2009 SK-P03-T01-BOND-PRIVATE-BIZ-USE-2009 CSV Parquet 4,675
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SK-P03-T01-BOND-PRIVATE-BIZ-USE",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P04 Part IV - Arbitrage

SK-P04-T01-BOND-ARBITRAGE

1:M many rows per filing · tax years 2009–2025 · 156,860 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SK-P04-T01-BOND-ARBITRAGE-2025 CSV Parquet 473
2024 SK-P04-T01-BOND-ARBITRAGE-2024 CSV Parquet 9,957
2023 SK-P04-T01-BOND-ARBITRAGE-2023 CSV Parquet 10,100
2022 SK-P04-T01-BOND-ARBITRAGE-2022 CSV Parquet 10,154
2021 SK-P04-T01-BOND-ARBITRAGE-2021 CSV Parquet 10,269
2020 SK-P04-T01-BOND-ARBITRAGE-2020 CSV Parquet 10,464
2019 SK-P04-T01-BOND-ARBITRAGE-2019 CSV Parquet 10,349
2018 SK-P04-T01-BOND-ARBITRAGE-2018 CSV Parquet 10,393
2017 SK-P04-T01-BOND-ARBITRAGE-2017 CSV Parquet 10,990
2016 SK-P04-T01-BOND-ARBITRAGE-2016 CSV Parquet 10,353
2015 SK-P04-T01-BOND-ARBITRAGE-2015 CSV Parquet 10,393
2014 SK-P04-T01-BOND-ARBITRAGE-2014 CSV Parquet 10,257
2013 SK-P04-T01-BOND-ARBITRAGE-2013 CSV Parquet 10,025
2012 SK-P04-T01-BOND-ARBITRAGE-2012 CSV Parquet 9,819
2011 SK-P04-T01-BOND-ARBITRAGE-2011 CSV Parquet 9,324
2010 SK-P04-T01-BOND-ARBITRAGE-2010 CSV Parquet 8,539
2009 SK-P04-T01-BOND-ARBITRAGE-2009 CSV Parquet 5,001
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SK-P04-T01-BOND-ARBITRAGE",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P05 Part V - Procedures To Undertake Corrective Action

SK-P05-T01-PROCEDURE-CORRECTIVE-ACT

1:M many rows per filing · tax years 2011–2025 · 126,616 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2025 CSV Parquet 447
2024 SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2024 CSV Parquet 9,605
2023 SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2023 CSV Parquet 9,703
2022 SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2022 CSV Parquet 9,739
2021 SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2021 CSV Parquet 9,911
2020 SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2020 CSV Parquet 10,064
2019 SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2019 CSV Parquet 9,991
2018 SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2018 CSV Parquet 10,020
2017 SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2017 CSV Parquet 10,561
2016 SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2016 CSV Parquet 9,971
2015 SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2015 CSV Parquet 9,942
2014 SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2014 CSV Parquet 9,358
2013 SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2013 CSV Parquet 8,657
2012 SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2012 CSV Parquet 7,101
2011 SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2011 CSV Parquet 1,546
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SK-P05-T01-PROCEDURE-CORRECTIVE-ACT",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P06 Part VI - Supplemental Information

SK-P06-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2010–2025 · 90,123 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SK-P06-T99-SUPPLEMENTAL-INFO-2025 CSV Parquet 261
2024 SK-P06-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 7,458
2023 SK-P06-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 7,435
2022 SK-P06-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 7,231
2021 SK-P06-T99-SUPPLEMENTAL-INFO-2021 CSV Parquet 7,230
2020 SK-P06-T99-SUPPLEMENTAL-INFO-2020 CSV Parquet 7,245
2019 SK-P06-T99-SUPPLEMENTAL-INFO-2019 CSV Parquet 7,118
2018 SK-P06-T99-SUPPLEMENTAL-INFO-2018 CSV Parquet 6,224
2017 SK-P06-T99-SUPPLEMENTAL-INFO-2017 CSV Parquet 6,305
2016 SK-P06-T99-SUPPLEMENTAL-INFO-2016 CSV Parquet 5,996
2015 SK-P06-T99-SUPPLEMENTAL-INFO-2015 CSV Parquet 6,073
2014 SK-P06-T99-SUPPLEMENTAL-INFO-2014 CSV Parquet 5,977
2013 SK-P06-T99-SUPPLEMENTAL-INFO-2013 CSV Parquet 5,527
2012 SK-P06-T99-SUPPLEMENTAL-INFO-2012 CSV Parquet 5,175
2011 SK-P06-T99-SUPPLEMENTAL-INFO-2011 CSV Parquet 2,776
2010 SK-P06-T99-SUPPLEMENTAL-INFO-2010 CSV Parquet 2,092
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SK-P06-T99-SUPPLEMENTAL-INFO",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

Schedule L: Transactions With Interested Persons

P01 Part I - Excess Benefit Transactions

SL-P01-T00-EXCESS-BENEFIT-TRANSAC

1:1 one row per filing · tax years 2009–2025 · 827 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2025 CSV Parquet 65
2024 SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2024 CSV Parquet 119
2023 SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2023 CSV Parquet 107
2022 SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2022 CSV Parquet 104
2021 SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2021 CSV Parquet 73
2020 SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2020 CSV Parquet 44
2019 SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2019 CSV Parquet 39
2018 SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2018 CSV Parquet 43
2017 SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2017 CSV Parquet 38
2016 SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2016 CSV Parquet 32
2015 SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2015 CSV Parquet 22
2014 SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2014 CSV Parquet 32
2013 SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2013 CSV Parquet 29
2012 SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2012 CSV Parquet 18
2011 SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2011 CSV Parquet 27
2010 SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2010 CSV Parquet 24
2009 SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2009 CSV Parquet 11
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SL-P01-T00-EXCESS-BENEFIT-TRANSAC",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SL-P01-T01-EXCESS-BENEFIT-TRANSAC

1:M many rows per filing · tax years 2009–2025 · 16,506 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2025 CSV Parquet 74
2024 SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2024 CSV Parquet 425
2023 SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2023 CSV Parquet 2,842
2022 SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2022 CSV Parquet 2,750
2021 SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2021 CSV Parquet 2,429
2020 SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2020 CSV Parquet 2,154
2019 SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2019 CSV Parquet 1,317
2018 SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2018 CSV Parquet 1,171
2017 SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2017 CSV Parquet 992
2016 SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2016 CSV Parquet 716
2015 SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2015 CSV Parquet 471
2014 SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2014 CSV Parquet 91
2013 SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2013 CSV Parquet 75
2012 SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2012 CSV Parquet 79
2011 SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2011 CSV Parquet 90
2010 SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2010 CSV Parquet 803
2009 SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2009 CSV Parquet 27
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SL-P01-T01-EXCESS-BENEFIT-TRANSAC",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P02 Part II - Loans to and/or From Interested Persons

SL-P02-T00-LOANS-INTERESTED-PERS

1:1 one row per filing · tax years 2009–2025 · 145,798 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SL-P02-T00-LOANS-INTERESTED-PERS-2025 CSV Parquet 2,895
2024 SL-P02-T00-LOANS-INTERESTED-PERS-2024 CSV Parquet 10,059
2023 SL-P02-T00-LOANS-INTERESTED-PERS-2023 CSV Parquet 10,134
2022 SL-P02-T00-LOANS-INTERESTED-PERS-2022 CSV Parquet 10,099
2021 SL-P02-T00-LOANS-INTERESTED-PERS-2021 CSV Parquet 10,261
2020 SL-P02-T00-LOANS-INTERESTED-PERS-2020 CSV Parquet 10,322
2019 SL-P02-T00-LOANS-INTERESTED-PERS-2019 CSV Parquet 10,114
2018 SL-P02-T00-LOANS-INTERESTED-PERS-2018 CSV Parquet 10,233
2017 SL-P02-T00-LOANS-INTERESTED-PERS-2017 CSV Parquet 9,974
2016 SL-P02-T00-LOANS-INTERESTED-PERS-2016 CSV Parquet 9,654
2015 SL-P02-T00-LOANS-INTERESTED-PERS-2015 CSV Parquet 9,633
2014 SL-P02-T00-LOANS-INTERESTED-PERS-2014 CSV Parquet 9,358
2013 SL-P02-T00-LOANS-INTERESTED-PERS-2013 CSV Parquet 9,003
2012 SL-P02-T00-LOANS-INTERESTED-PERS-2012 CSV Parquet 8,503
2011 SL-P02-T00-LOANS-INTERESTED-PERS-2011 CSV Parquet 7,643
2010 SL-P02-T00-LOANS-INTERESTED-PERS-2010 CSV Parquet 6,243
2009 SL-P02-T00-LOANS-INTERESTED-PERS-2009 CSV Parquet 1,670
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SL-P02-T00-LOANS-INTERESTED-PERS",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SL-P02-T01-LOANS-INTERESTED-PERS

1:M many rows per filing · tax years 2009–2025 · 328,294 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SL-P02-T01-LOANS-INTERESTED-PERS-2025 CSV Parquet 5,864
2024 SL-P02-T01-LOANS-INTERESTED-PERS-2024 CSV Parquet 20,642
2023 SL-P02-T01-LOANS-INTERESTED-PERS-2023 CSV Parquet 25,002
2022 SL-P02-T01-LOANS-INTERESTED-PERS-2022 CSV Parquet 24,572
2021 SL-P02-T01-LOANS-INTERESTED-PERS-2021 CSV Parquet 24,638
2020 SL-P02-T01-LOANS-INTERESTED-PERS-2020 CSV Parquet 24,377
2019 SL-P02-T01-LOANS-INTERESTED-PERS-2019 CSV Parquet 22,495
2018 SL-P02-T01-LOANS-INTERESTED-PERS-2018 CSV Parquet 22,652
2017 SL-P02-T01-LOANS-INTERESTED-PERS-2017 CSV Parquet 22,184
2016 SL-P02-T01-LOANS-INTERESTED-PERS-2016 CSV Parquet 21,440
2015 SL-P02-T01-LOANS-INTERESTED-PERS-2015 CSV Parquet 20,864
2014 SL-P02-T01-LOANS-INTERESTED-PERS-2014 CSV Parquet 20,013
2013 SL-P02-T01-LOANS-INTERESTED-PERS-2013 CSV Parquet 19,368
2012 SL-P02-T01-LOANS-INTERESTED-PERS-2012 CSV Parquet 18,465
2011 SL-P02-T01-LOANS-INTERESTED-PERS-2011 CSV Parquet 16,961
2010 SL-P02-T01-LOANS-INTERESTED-PERS-2010 CSV Parquet 15,837
2009 SL-P02-T01-LOANS-INTERESTED-PERS-2009 CSV Parquet 2,920
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SL-P02-T01-LOANS-INTERESTED-PERS",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P03 Part III - Grants or Assistance Benefiting Interested Persons

SL-P03-T01-GRANTS-INTERESTED-PERS

1:M many rows per filing · tax years 2009–2025 · 33,832 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SL-P03-T01-GRANTS-INTERESTED-PERS-2025 CSV Parquet 352
2024 SL-P03-T01-GRANTS-INTERESTED-PERS-2024 CSV Parquet 2,472
2023 SL-P03-T01-GRANTS-INTERESTED-PERS-2023 CSV Parquet 2,526
2022 SL-P03-T01-GRANTS-INTERESTED-PERS-2022 CSV Parquet 2,515
2021 SL-P03-T01-GRANTS-INTERESTED-PERS-2021 CSV Parquet 2,354
2020 SL-P03-T01-GRANTS-INTERESTED-PERS-2020 CSV Parquet 2,429
2019 SL-P03-T01-GRANTS-INTERESTED-PERS-2019 CSV Parquet 2,184
2018 SL-P03-T01-GRANTS-INTERESTED-PERS-2018 CSV Parquet 2,235
2017 SL-P03-T01-GRANTS-INTERESTED-PERS-2017 CSV Parquet 2,385
2016 SL-P03-T01-GRANTS-INTERESTED-PERS-2016 CSV Parquet 2,122
2015 SL-P03-T01-GRANTS-INTERESTED-PERS-2015 CSV Parquet 2,198
2014 SL-P03-T01-GRANTS-INTERESTED-PERS-2014 CSV Parquet 2,087
2013 SL-P03-T01-GRANTS-INTERESTED-PERS-2013 CSV Parquet 2,050
2012 SL-P03-T01-GRANTS-INTERESTED-PERS-2012 CSV Parquet 1,945
2011 SL-P03-T01-GRANTS-INTERESTED-PERS-2011 CSV Parquet 1,829
2010 SL-P03-T01-GRANTS-INTERESTED-PERS-2010 CSV Parquet 1,428
2009 SL-P03-T01-GRANTS-INTERESTED-PERS-2009 CSV Parquet 721
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SL-P03-T01-GRANTS-INTERESTED-PERS",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P04 Part IV - Business Transactions Involving Interested Persons

SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS

1:M many rows per filing · tax years 2009–2025 · 517,480 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2025 CSV Parquet 5,737
2024 SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2024 CSV Parquet 30,012
2023 SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2023 CSV Parquet 34,851
2022 SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2022 CSV Parquet 34,636
2021 SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2021 CSV Parquet 34,395
2020 SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2020 CSV Parquet 34,279
2019 SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2019 CSV Parquet 33,201
2018 SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2018 CSV Parquet 34,215
2017 SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2017 CSV Parquet 34,741
2016 SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2016 CSV Parquet 33,084
2015 SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2015 CSV Parquet 34,643
2014 SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2014 CSV Parquet 33,949
2013 SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2013 CSV Parquet 35,088
2012 SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2012 CSV Parquet 33,518
2011 SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2011 CSV Parquet 31,876
2010 SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2010 CSV Parquet 27,232
2009 SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2009 CSV Parquet 12,023
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P05 Part V - Supplemental Information

SL-P05-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2010–2025 · 76,567 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SL-P05-T99-SUPPLEMENTAL-INFO-2025 CSV Parquet 1,263
2024 SL-P05-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 5,916
2023 SL-P05-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 5,921
2022 SL-P05-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 5,931
2021 SL-P05-T99-SUPPLEMENTAL-INFO-2021 CSV Parquet 5,918
2020 SL-P05-T99-SUPPLEMENTAL-INFO-2020 CSV Parquet 5,906
2019 SL-P05-T99-SUPPLEMENTAL-INFO-2019 CSV Parquet 5,352
2018 SL-P05-T99-SUPPLEMENTAL-INFO-2018 CSV Parquet 5,491
2017 SL-P05-T99-SUPPLEMENTAL-INFO-2017 CSV Parquet 5,432
2016 SL-P05-T99-SUPPLEMENTAL-INFO-2016 CSV Parquet 5,104
2015 SL-P05-T99-SUPPLEMENTAL-INFO-2015 CSV Parquet 4,833
2014 SL-P05-T99-SUPPLEMENTAL-INFO-2014 CSV Parquet 4,585
2013 SL-P05-T99-SUPPLEMENTAL-INFO-2013 CSV Parquet 4,791
2012 SL-P05-T99-SUPPLEMENTAL-INFO-2012 CSV Parquet 4,158
2011 SL-P05-T99-SUPPLEMENTAL-INFO-2011 CSV Parquet 3,499
2010 SL-P05-T99-SUPPLEMENTAL-INFO-2010 CSV Parquet 2,467
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SL-P05-T99-SUPPLEMENTAL-INFO",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

Schedule M: Noncash Contributions

P01 Part I - Types of Property

SM-P01-T00-NONCASH-CONTRIBUTIONS

1:1 one row per filing · tax years 2009–2025 · 395,652 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SM-P01-T00-NONCASH-CONTRIBUTIONS-2025 CSV Parquet 6,447
2024 SM-P01-T00-NONCASH-CONTRIBUTIONS-2024 CSV Parquet 33,685
2023 SM-P01-T00-NONCASH-CONTRIBUTIONS-2023 CSV Parquet 32,511
2022 SM-P01-T00-NONCASH-CONTRIBUTIONS-2022 CSV Parquet 31,440
2021 SM-P01-T00-NONCASH-CONTRIBUTIONS-2021 CSV Parquet 31,013
2020 SM-P01-T00-NONCASH-CONTRIBUTIONS-2020 CSV Parquet 28,953
2019 SM-P01-T00-NONCASH-CONTRIBUTIONS-2019 CSV Parquet 27,857
2018 SM-P01-T00-NONCASH-CONTRIBUTIONS-2018 CSV Parquet 27,398
2017 SM-P01-T00-NONCASH-CONTRIBUTIONS-2017 CSV Parquet 27,769
2016 SM-P01-T00-NONCASH-CONTRIBUTIONS-2016 CSV Parquet 25,272
2015 SM-P01-T00-NONCASH-CONTRIBUTIONS-2015 CSV Parquet 24,456
2014 SM-P01-T00-NONCASH-CONTRIBUTIONS-2014 CSV Parquet 23,030
2013 SM-P01-T00-NONCASH-CONTRIBUTIONS-2013 CSV Parquet 20,825
2012 SM-P01-T00-NONCASH-CONTRIBUTIONS-2012 CSV Parquet 18,953
2011 SM-P01-T00-NONCASH-CONTRIBUTIONS-2011 CSV Parquet 17,020
2010 SM-P01-T00-NONCASH-CONTRIBUTIONS-2010 CSV Parquet 13,344
2009 SM-P01-T00-NONCASH-CONTRIBUTIONS-2009 CSV Parquet 5,679
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SM-P01-T00-NONCASH-CONTRIBUTIONS",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SM-P01-T01-NONCASH-CONTRIBUTIONS

1:M many rows per filing · tax years 2009–2025 · 440,613 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SM-P01-T01-NONCASH-CONTRIBUTIONS-2025 CSV Parquet 5,951
2024 SM-P01-T01-NONCASH-CONTRIBUTIONS-2024 CSV Parquet 34,235
2023 SM-P01-T01-NONCASH-CONTRIBUTIONS-2023 CSV Parquet 33,790
2022 SM-P01-T01-NONCASH-CONTRIBUTIONS-2022 CSV Parquet 31,706
2021 SM-P01-T01-NONCASH-CONTRIBUTIONS-2021 CSV Parquet 29,466
2020 SM-P01-T01-NONCASH-CONTRIBUTIONS-2020 CSV Parquet 27,669
2019 SM-P01-T01-NONCASH-CONTRIBUTIONS-2019 CSV Parquet 30,326
2018 SM-P01-T01-NONCASH-CONTRIBUTIONS-2018 CSV Parquet 31,474
2017 SM-P01-T01-NONCASH-CONTRIBUTIONS-2017 CSV Parquet 32,241
2016 SM-P01-T01-NONCASH-CONTRIBUTIONS-2016 CSV Parquet 30,233
2015 SM-P01-T01-NONCASH-CONTRIBUTIONS-2015 CSV Parquet 29,665
2014 SM-P01-T01-NONCASH-CONTRIBUTIONS-2014 CSV Parquet 28,600
2013 SM-P01-T01-NONCASH-CONTRIBUTIONS-2013 CSV Parquet 25,898
2012 SM-P01-T01-NONCASH-CONTRIBUTIONS-2012 CSV Parquet 23,489
2011 SM-P01-T01-NONCASH-CONTRIBUTIONS-2011 CSV Parquet 21,345
2010 SM-P01-T01-NONCASH-CONTRIBUTIONS-2010 CSV Parquet 17,124
2009 SM-P01-T01-NONCASH-CONTRIBUTIONS-2009 CSV Parquet 7,401
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SM-P01-T01-NONCASH-CONTRIBUTIONS",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P02 Part II - Supplemental Information

SM-P02-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2009–2025 · 133,350 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SM-P02-T99-SUPPLEMENTAL-INFO-2025 CSV Parquet 1,590
2024 SM-P02-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 12,705
2023 SM-P02-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 11,837
2022 SM-P02-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 11,372
2021 SM-P02-T99-SUPPLEMENTAL-INFO-2021 CSV Parquet 11,085
2020 SM-P02-T99-SUPPLEMENTAL-INFO-2020 CSV Parquet 10,331
2019 SM-P02-T99-SUPPLEMENTAL-INFO-2019 CSV Parquet 9,552
2018 SM-P02-T99-SUPPLEMENTAL-INFO-2018 CSV Parquet 9,066
2017 SM-P02-T99-SUPPLEMENTAL-INFO-2017 CSV Parquet 9,067
2016 SM-P02-T99-SUPPLEMENTAL-INFO-2016 CSV Parquet 8,009
2015 SM-P02-T99-SUPPLEMENTAL-INFO-2015 CSV Parquet 7,681
2014 SM-P02-T99-SUPPLEMENTAL-INFO-2014 CSV Parquet 7,214
2013 SM-P02-T99-SUPPLEMENTAL-INFO-2013 CSV Parquet 6,563
2012 SM-P02-T99-SUPPLEMENTAL-INFO-2012 CSV Parquet 5,945
2011 SM-P02-T99-SUPPLEMENTAL-INFO-2011 CSV Parquet 5,250
2010 SM-P02-T99-SUPPLEMENTAL-INFO-2010 CSV Parquet 3,948
2009 SM-P02-T99-SUPPLEMENTAL-INFO-2009 CSV Parquet 2,135
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SM-P02-T99-SUPPLEMENTAL-INFO",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

Schedule N: Liquidation, Termination, Dissolution, or Significant Disposition of Assets

P01 Part I - Liquidation, Termination, or Dissolution

SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION

1:1 one row per filing · tax years 2009–2025 · 45,803 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2025 CSV Parquet 2,507
2024 SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2024 CSV Parquet 4,783
2023 SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2023 CSV Parquet 4,445
2022 SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2022 CSV Parquet 4,293
2021 SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2021 CSV Parquet 3,825
2020 SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2020 CSV Parquet 3,605
2019 SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2019 CSV Parquet 3,072
2018 SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2018 CSV Parquet 3,136
2017 SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2017 CSV Parquet 2,843
2016 SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2016 CSV Parquet 2,661
2015 SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2015 CSV Parquet 2,460
2014 SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2014 CSV Parquet 2,172
2013 SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2013 CSV Parquet 1,954
2012 SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2012 CSV Parquet 1,576
2011 SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2011 CSV Parquet 1,314
2010 SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2010 CSV Parquet 951
2009 SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2009 CSV Parquet 206
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION

1:M many rows per filing · tax years 2009–2025 · 81,036 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2025 CSV Parquet 4,203
2024 SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2024 CSV Parquet 7,924
2023 SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2023 CSV Parquet 7,997
2022 SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2022 CSV Parquet 7,410
2021 SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2021 CSV Parquet 7,149
2020 SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2020 CSV Parquet 6,783
2019 SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2019 CSV Parquet 5,256
2018 SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2018 CSV Parquet 5,542
2017 SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2017 CSV Parquet 4,975
2016 SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2016 CSV Parquet 4,642
2015 SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2015 CSV Parquet 4,170
2014 SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2014 CSV Parquet 4,056
2013 SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2013 CSV Parquet 3,702
2012 SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2012 CSV Parquet 2,867
2011 SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2011 CSV Parquet 2,324
2010 SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2010 CSV Parquet 1,644
2009 SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2009 CSV Parquet 392
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P02 Part II - Sale, Exchange, Disposition, or Other Transfer of More Than 25% of the Organization’s Assets

SN-P02-T00-DISPOSITION-OF-ASSETS

1:1 one row per filing · tax years 2009–2025 · 20,148 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SN-P02-T00-DISPOSITION-OF-ASSETS-2025 CSV Parquet 608
2024 SN-P02-T00-DISPOSITION-OF-ASSETS-2024 CSV Parquet 1,552
2023 SN-P02-T00-DISPOSITION-OF-ASSETS-2023 CSV Parquet 1,681
2022 SN-P02-T00-DISPOSITION-OF-ASSETS-2022 CSV Parquet 1,731
2021 SN-P02-T00-DISPOSITION-OF-ASSETS-2021 CSV Parquet 1,411
2020 SN-P02-T00-DISPOSITION-OF-ASSETS-2020 CSV Parquet 1,446
2019 SN-P02-T00-DISPOSITION-OF-ASSETS-2019 CSV Parquet 1,207
2018 SN-P02-T00-DISPOSITION-OF-ASSETS-2018 CSV Parquet 1,419
2017 SN-P02-T00-DISPOSITION-OF-ASSETS-2017 CSV Parquet 1,307
2016 SN-P02-T00-DISPOSITION-OF-ASSETS-2016 CSV Parquet 1,419
2015 SN-P02-T00-DISPOSITION-OF-ASSETS-2015 CSV Parquet 1,205
2014 SN-P02-T00-DISPOSITION-OF-ASSETS-2014 CSV Parquet 1,207
2013 SN-P02-T00-DISPOSITION-OF-ASSETS-2013 CSV Parquet 1,086
2012 SN-P02-T00-DISPOSITION-OF-ASSETS-2012 CSV Parquet 883
2011 SN-P02-T00-DISPOSITION-OF-ASSETS-2011 CSV Parquet 938
2010 SN-P02-T00-DISPOSITION-OF-ASSETS-2010 CSV Parquet 795
2009 SN-P02-T00-DISPOSITION-OF-ASSETS-2009 CSV Parquet 253
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SN-P02-T00-DISPOSITION-OF-ASSETS",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SN-P02-T01-DISPOSITION-OF-ASSETS

1:M many rows per filing · tax years 2009–2025 · 32,504 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SN-P02-T01-DISPOSITION-OF-ASSETS-2025 CSV Parquet 709
2024 SN-P02-T01-DISPOSITION-OF-ASSETS-2024 CSV Parquet 2,567
2023 SN-P02-T01-DISPOSITION-OF-ASSETS-2023 CSV Parquet 2,574
2022 SN-P02-T01-DISPOSITION-OF-ASSETS-2022 CSV Parquet 2,401
2021 SN-P02-T01-DISPOSITION-OF-ASSETS-2021 CSV Parquet 2,437
2020 SN-P02-T01-DISPOSITION-OF-ASSETS-2020 CSV Parquet 2,578
2019 SN-P02-T01-DISPOSITION-OF-ASSETS-2019 CSV Parquet 2,119
2018 SN-P02-T01-DISPOSITION-OF-ASSETS-2018 CSV Parquet 2,149
2017 SN-P02-T01-DISPOSITION-OF-ASSETS-2017 CSV Parquet 2,076
2016 SN-P02-T01-DISPOSITION-OF-ASSETS-2016 CSV Parquet 1,975
2015 SN-P02-T01-DISPOSITION-OF-ASSETS-2015 CSV Parquet 2,125
2014 SN-P02-T01-DISPOSITION-OF-ASSETS-2014 CSV Parquet 2,177
2013 SN-P02-T01-DISPOSITION-OF-ASSETS-2013 CSV Parquet 1,902
2012 SN-P02-T01-DISPOSITION-OF-ASSETS-2012 CSV Parquet 1,441
2011 SN-P02-T01-DISPOSITION-OF-ASSETS-2011 CSV Parquet 1,471
2010 SN-P02-T01-DISPOSITION-OF-ASSETS-2010 CSV Parquet 1,354
2009 SN-P02-T01-DISPOSITION-OF-ASSETS-2009 CSV Parquet 449
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SN-P02-T01-DISPOSITION-OF-ASSETS",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P03 Part III - Supplemental Information

SN-P03-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2009–2025 · 26,769 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SN-P03-T99-SUPPLEMENTAL-INFO-2025 CSV Parquet 1,013
2024 SN-P03-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 2,342
2023 SN-P03-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 2,100
2022 SN-P03-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 2,206
2021 SN-P03-T99-SUPPLEMENTAL-INFO-2021 CSV Parquet 2,026
2020 SN-P03-T99-SUPPLEMENTAL-INFO-2020 CSV Parquet 2,123
2019 SN-P03-T99-SUPPLEMENTAL-INFO-2019 CSV Parquet 1,854
2018 SN-P03-T99-SUPPLEMENTAL-INFO-2018 CSV Parquet 1,751
2017 SN-P03-T99-SUPPLEMENTAL-INFO-2017 CSV Parquet 1,792
2016 SN-P03-T99-SUPPLEMENTAL-INFO-2016 CSV Parquet 1,757
2015 SN-P03-T99-SUPPLEMENTAL-INFO-2015 CSV Parquet 1,459
2014 SN-P03-T99-SUPPLEMENTAL-INFO-2014 CSV Parquet 1,454
2013 SN-P03-T99-SUPPLEMENTAL-INFO-2013 CSV Parquet 1,413
2012 SN-P03-T99-SUPPLEMENTAL-INFO-2012 CSV Parquet 1,187
2011 SN-P03-T99-SUPPLEMENTAL-INFO-2011 CSV Parquet 1,126
2010 SN-P03-T99-SUPPLEMENTAL-INFO-2010 CSV Parquet 892
2009 SN-P03-T99-SUPPLEMENTAL-INFO-2009 CSV Parquet 274
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SN-P03-T99-SUPPLEMENTAL-INFO",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P99 Lines from earlier versions of the schedule

SN-P99-T00-LIQUIDATION-TERMINATION-DISSOLUTION

1:1 one row per filing · tax years 2009–2009 · 203 rows · Data dictionary

Year Table CSV Parquet Rows
2009 SN-P99-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2009 CSV Parquet 203
Download with panel990
library( panel990 )

# Panel of tax years 2009
# with BMF fields appended

panel <- 
  panelize( tables = "SN-P99-T00-LIQUIDATION-TERMINATION-DISSOLUTION",
            years = 2009,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

Schedule O: Supplemental Information to Form 990 or 990-EZ

P00 Supplemental Information to Form 990 or 990-EZ

SO-P00-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2009–2025 · 34,123,244 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SO-P00-T99-SUPPLEMENTAL-INFO-2025 CSV Parquet 955,265
2024 SO-P00-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 2,896,983
2023 SO-P00-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 2,925,149
2022 SO-P00-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 2,876,503
2021 SO-P00-T99-SUPPLEMENTAL-INFO-2021 CSV Parquet 2,799,477
2020 SO-P00-T99-SUPPLEMENTAL-INFO-2020 CSV Parquet 2,621,009
2019 SO-P00-T99-SUPPLEMENTAL-INFO-2019 CSV Parquet 2,409,996
2018 SO-P00-T99-SUPPLEMENTAL-INFO-2018 CSV Parquet 2,390,668
2017 SO-P00-T99-SUPPLEMENTAL-INFO-2017 CSV Parquet 2,360,863
2016 SO-P00-T99-SUPPLEMENTAL-INFO-2016 CSV Parquet 2,229,158
2015 SO-P00-T99-SUPPLEMENTAL-INFO-2015 CSV Parquet 2,096,020
2014 SO-P00-T99-SUPPLEMENTAL-INFO-2014 CSV Parquet 1,802,858
2013 SO-P00-T99-SUPPLEMENTAL-INFO-2013 CSV Parquet 1,696,792
2012 SO-P00-T99-SUPPLEMENTAL-INFO-2012 CSV Parquet 1,534,224
2011 SO-P00-T99-SUPPLEMENTAL-INFO-2011 CSV Parquet 1,314,960
2010 SO-P00-T99-SUPPLEMENTAL-INFO-2010 CSV Parquet 1,030,395
2009 SO-P00-T99-SUPPLEMENTAL-INFO-2009 CSV Parquet 182,924
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SO-P00-T99-SUPPLEMENTAL-INFO",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

Schedule R: Related Organizations and Unrelated Partnerships

P01 Part I - Identification of Disregarded Entities

SR-P01-T01-ID-DISREGARDED-ENTITIES

1:M many rows per filing · tax years 2009–2025 · 399,858 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SR-P01-T01-ID-DISREGARDED-ENTITIES-2025 CSV Parquet 2,572
2024 SR-P01-T01-ID-DISREGARDED-ENTITIES-2024 CSV Parquet 35,748
2023 SR-P01-T01-ID-DISREGARDED-ENTITIES-2023 CSV Parquet 34,937
2022 SR-P01-T01-ID-DISREGARDED-ENTITIES-2022 CSV Parquet 33,518
2021 SR-P01-T01-ID-DISREGARDED-ENTITIES-2021 CSV Parquet 31,292
2020 SR-P01-T01-ID-DISREGARDED-ENTITIES-2020 CSV Parquet 29,229
2019 SR-P01-T01-ID-DISREGARDED-ENTITIES-2019 CSV Parquet 38,351
2018 SR-P01-T01-ID-DISREGARDED-ENTITIES-2018 CSV Parquet 34,108
2017 SR-P01-T01-ID-DISREGARDED-ENTITIES-2017 CSV Parquet 26,098
2016 SR-P01-T01-ID-DISREGARDED-ENTITIES-2016 CSV Parquet 22,890
2015 SR-P01-T01-ID-DISREGARDED-ENTITIES-2015 CSV Parquet 24,641
2014 SR-P01-T01-ID-DISREGARDED-ENTITIES-2014 CSV Parquet 21,997
2013 SR-P01-T01-ID-DISREGARDED-ENTITIES-2013 CSV Parquet 18,784
2012 SR-P01-T01-ID-DISREGARDED-ENTITIES-2012 CSV Parquet 15,871
2011 SR-P01-T01-ID-DISREGARDED-ENTITIES-2011 CSV Parquet 13,839
2010 SR-P01-T01-ID-DISREGARDED-ENTITIES-2010 CSV Parquet 11,335
2009 SR-P01-T01-ID-DISREGARDED-ENTITIES-2009 CSV Parquet 4,648
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SR-P01-T01-ID-DISREGARDED-ENTITIES",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P02 Part II - Identification of Related Tax-Exempt Organizations

SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS

1:M many rows per filing · tax years 2009–2025 · 6,619,016 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2025 CSV Parquet 27,304
2024 SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2024 CSV Parquet 536,558
2023 SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2023 CSV Parquet 539,842
2022 SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2022 CSV Parquet 547,900
2021 SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2021 CSV Parquet 537,258
2020 SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2020 CSV Parquet 544,357
2019 SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2019 CSV Parquet 533,074
2018 SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2018 CSV Parquet 531,319
2017 SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2017 CSV Parquet 436,267
2016 SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2016 CSV Parquet 409,181
2015 SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2015 CSV Parquet 386,810
2014 SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2014 CSV Parquet 359,046
2013 SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2013 CSV Parquet 329,136
2012 SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2012 CSV Parquet 305,507
2011 SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2011 CSV Parquet 272,433
2010 SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2010 CSV Parquet 231,011
2009 SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2009 CSV Parquet 92,013
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P03 Part III - Identification of Related Organizations Taxable as a Partnership

SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP

1:M many rows per filing · tax years 2009–2025 · 2,883,506 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2025 CSV Parquet 12,141
2024 SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2024 CSV Parquet 265,074
2023 SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2023 CSV Parquet 259,357
2022 SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2022 CSV Parquet 260,991
2021 SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2021 CSV Parquet 246,076
2020 SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2020 CSV Parquet 244,671
2019 SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2019 CSV Parquet 227,460
2018 SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2018 CSV Parquet 219,431
2017 SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2017 CSV Parquet 180,874
2016 SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2016 CSV Parquet 171,245
2015 SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2015 CSV Parquet 153,926
2014 SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2014 CSV Parquet 143,435
2013 SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2013 CSV Parquet 128,191
2012 SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2012 CSV Parquet 139,249
2011 SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2011 CSV Parquet 122,551
2010 SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2010 CSV Parquet 89,129
2009 SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2009 CSV Parquet 19,705
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P04 Part IV - Identification of Related Organizations Taxable as a Corporation or Trust

SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION

1:M many rows per filing · tax years 2009–2025 · 3,804,554 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2025 CSV Parquet 13,205
2024 SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2024 CSV Parquet 294,188
2023 SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2023 CSV Parquet 291,500
2022 SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2022 CSV Parquet 291,478
2021 SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2021 CSV Parquet 287,153
2020 SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2020 CSV Parquet 279,149
2019 SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2019 CSV Parquet 261,474
2018 SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2018 CSV Parquet 262,949
2017 SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2017 CSV Parquet 235,330
2016 SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2016 CSV Parquet 221,099
2015 SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2015 CSV Parquet 209,588
2014 SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2014 CSV Parquet 196,334
2013 SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2013 CSV Parquet 184,005
2012 SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2012 CSV Parquet 467,522
2011 SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2011 CSV Parquet 220,246
2010 SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2010 CSV Parquet 68,060
2009 SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2009 CSV Parquet 21,274
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P05 Part V - Transactions With Related Organizations

SR-P05-T00-TRANSACTIONS-RLTD-ORGS

1:1 one row per filing · tax years 2009–2025 · 959,360 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2025 CSV Parquet 10,920
2024 SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2024 CSV Parquet 75,753
2023 SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2023 CSV Parquet 75,730
2022 SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2022 CSV Parquet 75,176
2021 SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2021 CSV Parquet 74,331
2020 SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2020 CSV Parquet 73,232
2019 SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2019 CSV Parquet 67,571
2018 SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2018 CSV Parquet 65,451
2017 SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2017 CSV Parquet 65,099
2016 SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2016 CSV Parquet 61,294
2015 SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2015 CSV Parquet 59,389
2014 SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2014 CSV Parquet 56,676
2013 SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2013 CSV Parquet 52,844
2012 SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2012 CSV Parquet 49,294
2011 SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2011 CSV Parquet 45,248
2010 SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2010 CSV Parquet 37,096
2009 SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2009 CSV Parquet 14,256
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SR-P05-T00-TRANSACTIONS-RLTD-ORGS",
            years = 2020:2024,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

SR-P05-T01-TRANSACTIONS-RLTD-ORGS

1:M many rows per filing · tax years 2009–2025 · 1,635,588 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2025 CSV Parquet 11,987
2024 SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2024 CSV Parquet 117,219
2023 SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2023 CSV Parquet 117,955
2022 SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2022 CSV Parquet 118,057
2021 SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2021 CSV Parquet 117,259
2020 SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2020 CSV Parquet 117,362
2019 SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2019 CSV Parquet 112,736
2018 SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2018 CSV Parquet 110,274
2017 SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2017 CSV Parquet 109,671
2016 SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2016 CSV Parquet 104,617
2015 SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2015 CSV Parquet 101,237
2014 SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2014 CSV Parquet 97,779
2013 SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2013 CSV Parquet 94,717
2012 SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2012 CSV Parquet 99,705
2011 SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2011 CSV Parquet 92,846
2010 SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2010 CSV Parquet 78,452
2009 SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2009 CSV Parquet 33,715
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SR-P05-T01-TRANSACTIONS-RLTD-ORGS",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P06 Part VI - Unrelated Organizations Taxable as a Partnership

SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP

1:M many rows per filing · tax years 2009–2025 · 5,898 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2025 CSV Parquet 38
2024 SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2024 CSV Parquet 282
2023 SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2023 CSV Parquet 309
2022 SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2022 CSV Parquet 532
2021 SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2021 CSV Parquet 1,456
2020 SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2020 CSV Parquet 377
2019 SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2019 CSV Parquet 337
2018 SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2018 CSV Parquet 309
2017 SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2017 CSV Parquet 321
2016 SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2016 CSV Parquet 294
2015 SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2015 CSV Parquet 301
2014 SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2014 CSV Parquet 280
2013 SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2013 CSV Parquet 290
2012 SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2012 CSV Parquet 263
2011 SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2011 CSV Parquet 208
2010 SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2010 CSV Parquet 197
2009 SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2009 CSV Parquet 104
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

P07 Part VII - Supplemental Information

SR-P07-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2010–2025 · 84,932 rows · Data dictionary

Year Table CSV Parquet Rows
2025 SR-P07-T99-SUPPLEMENTAL-INFO-2025 CSV Parquet 759
2024 SR-P07-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 7,222
2023 SR-P07-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 7,384
2022 SR-P07-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 7,267
2021 SR-P07-T99-SUPPLEMENTAL-INFO-2021 CSV Parquet 7,179
2020 SR-P07-T99-SUPPLEMENTAL-INFO-2020 CSV Parquet 7,370
2019 SR-P07-T99-SUPPLEMENTAL-INFO-2019 CSV Parquet 6,432
2018 SR-P07-T99-SUPPLEMENTAL-INFO-2018 CSV Parquet 6,181
2017 SR-P07-T99-SUPPLEMENTAL-INFO-2017 CSV Parquet 5,936
2016 SR-P07-T99-SUPPLEMENTAL-INFO-2016 CSV Parquet 5,635
2015 SR-P07-T99-SUPPLEMENTAL-INFO-2015 CSV Parquet 5,394
2014 SR-P07-T99-SUPPLEMENTAL-INFO-2014 CSV Parquet 4,844
2013 SR-P07-T99-SUPPLEMENTAL-INFO-2013 CSV Parquet 4,575
2012 SR-P07-T99-SUPPLEMENTAL-INFO-2012 CSV Parquet 3,742
2011 SR-P07-T99-SUPPLEMENTAL-INFO-2011 CSV Parquet 3,091
2010 SR-P07-T99-SUPPLEMENTAL-INFO-2010 CSV Parquet 1,921
Download with panel990
library( panel990 )

# Panel of tax years 2020-2024
# with BMF fields appended

panel <- 
  panelize( tables = "SR-P07-T99-SUPPLEMENTAL-INFO",
            years = 2020:2024,
            include_many = TRUE,
            bmf = TRUE )

df <- panel_data( panel )
Back to contents

Table list and row counts: public/efile_v3_1/COUNT-OF-ROWS-BY-TABLE-AND-FORMTYPE-EFILE_V3_1.CSV. Table and part names: concordance990 02de916. Page rendered 2026-10-23.