990 Efile Data Catalog

Archived interim release · efile_v2_3

Superseded. This page lists efile_v2_3, an interim build that was not a full public release. It is kept so that analyses run on it can be reproduced. The current 990 / 990-EZ release is efile_v3_1.
Release efile_v2_3 (published 2026-10-07)
Returns Form 990 and Form 990-EZ, with schedules
Tax years 2009–2024
Tables 131 tables, 2,000 table-year files
Filings 5,981,036 returns

Each table-year is published as CSV and Parquet. Data dictionary links point to the current concordance990 dictionary, so a few variables may differ from the ones in this release.

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 = "v2_3" ),
            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 =.

Version history

Release Returns Published Status Tax years Tables Filings Notes
efile_v3_1 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 this page 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

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–2024 · 5,981,036 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P00-T00-HEADER-2024 CSV Parquet 456,170
2023 F9-P00-T00-HEADER-2023 CSV Parquet 561,156
2022 F9-P00-T00-HEADER-2022 CSV Parquet 555,197
2021 F9-P00-T00-HEADER-2021 CSV Parquet 539,217
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
Back to contents

F9-P00-T01-AFFILIATE-LISTING

1:M many rows per filing · tax years 2009–2024 · 29,042 rows · Data dictionary

Group return: list of subordinate organizations (AffiliateListing attachment)

Year Table CSV Parquet Rows
2024 F9-P00-T01-AFFILIATE-LISTING-2024 CSV Parquet 1,734
2023 F9-P00-T01-AFFILIATE-LISTING-2023 CSV Parquet 3,903
2022 F9-P00-T01-AFFILIATE-LISTING-2022 CSV Parquet 3,821
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
Back to contents

P01 Part I - Summary

F9-P01-T00-SUMMARY

1:1 one row per filing · tax years 2009–2024 · 5,968,128 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P01-T00-SUMMARY-2024 CSV Parquet 454,873
2023 F9-P01-T00-SUMMARY-2023 CSV Parquet 559,537
2022 F9-P01-T00-SUMMARY-2022 CSV Parquet 553,502
2021 F9-P01-T00-SUMMARY-2021 CSV Parquet 537,649
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
Back to contents

F9-P01-T00-SUMMARY-EZ

1:1 one row per filing · tax years 2009–2024 · 2,043,089 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P01-T00-SUMMARY-EZ-2024 CSV Parquet 169,129
2023 F9-P01-T00-SUMMARY-EZ-2023 CSV Parquet 195,114
2022 F9-P01-T00-SUMMARY-EZ-2022 CSV Parquet 194,969
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
Back to contents

P02 Part II - Signature Block

F9-P02-T00-SIGNATURE

1:1 one row per filing · tax years 2009–2024 · 5,981,036 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P02-T00-SIGNATURE-2024 CSV Parquet 456,170
2023 F9-P02-T00-SIGNATURE-2023 CSV Parquet 561,156
2022 F9-P02-T00-SIGNATURE-2022 CSV Parquet 555,197
2021 F9-P02-T00-SIGNATURE-2021 CSV Parquet 539,217
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
Back to contents

P03 Part III - Statement of Program Service Accomplishments

F9-P03-T00-MISSION

1:1 one row per filing · tax years 2009–2024 · 5,980,897 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P03-T00-MISSION-2024 CSV Parquet 456,120
2023 F9-P03-T00-MISSION-2023 CSV Parquet 561,131
2022 F9-P03-T00-MISSION-2022 CSV Parquet 555,184
2021 F9-P03-T00-MISSION-2021 CSV Parquet 539,205
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
Back to contents

F9-P03-T00-PROGRAM-ONE

1:1 one row per filing · tax years 2009–2024 · 3,845,141 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P03-T00-PROGRAM-ONE-2024 CSV Parquet 277,302
2023 F9-P03-T00-PROGRAM-ONE-2023 CSV Parquet 354,774
2022 F9-P03-T00-PROGRAM-ONE-2022 CSV Parquet 349,062
2021 F9-P03-T00-PROGRAM-ONE-2021 CSV Parquet 336,488
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
Back to contents

F9-P03-T00-PROGRAM-THREE

1:1 one row per filing · tax years 2009–2024 · 821,017 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P03-T00-PROGRAM-THREE-2024 CSV Parquet 58,480
2023 F9-P03-T00-PROGRAM-THREE-2023 CSV Parquet 76,062
2022 F9-P03-T00-PROGRAM-THREE-2022 CSV Parquet 74,428
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
Back to contents

F9-P03-T00-PROGRAM-TWO

1:1 one row per filing · tax years 2009–2024 · 1,165,466 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P03-T00-PROGRAM-TWO-2024 CSV Parquet 81,984
2023 F9-P03-T00-PROGRAM-TWO-2023 CSV Parquet 106,640
2022 F9-P03-T00-PROGRAM-TWO-2022 CSV Parquet 104,712
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
Back to contents

F9-P03-T00-PROGRAMS

1:1 one row per filing · tax years 2009–2024 · 5,296,445 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P03-T00-PROGRAMS-2024 CSV Parquet 403,754
2023 F9-P03-T00-PROGRAMS-2023 CSV Parquet 498,037
2022 F9-P03-T00-PROGRAMS-2022 CSV Parquet 492,529
2021 F9-P03-T00-PROGRAMS-2021 CSV Parquet 477,612
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
Back to contents

F9-P03-T01-PROGRAMS-OTHER

1:M many rows per filing · tax years 2009–2024 · 714,296 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P03-T01-PROGRAMS-OTHER-2024 CSV Parquet 52,008
2023 F9-P03-T01-PROGRAMS-OTHER-2023 CSV Parquet 59,074
2022 F9-P03-T01-PROGRAMS-OTHER-2022 CSV Parquet 58,661
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
Back to contents

F9-P03-T02-PROGRAMS-EZ

1:M many rows per filing · tax years 2009–2024 · 3,230,185 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P03-T02-PROGRAMS-EZ-2024 CSV Parquet 278,378
2023 F9-P03-T02-PROGRAMS-EZ-2023 CSV Parquet 320,330
2022 F9-P03-T02-PROGRAMS-EZ-2022 CSV Parquet 317,523
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
Back to contents

P04 Part IV - Checklist of Required Schedules

F9-P04-T00-REQUIRED-SCHEDULES

1:1 one row per filing · tax years 2009–2024 · 5,981,036 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P04-T00-REQUIRED-SCHEDULES-2024 CSV Parquet 456,170
2023 F9-P04-T00-REQUIRED-SCHEDULES-2023 CSV Parquet 561,156
2022 F9-P04-T00-REQUIRED-SCHEDULES-2022 CSV Parquet 555,197
2021 F9-P04-T00-REQUIRED-SCHEDULES-2021 CSV Parquet 539,217
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
Back to contents

F9-P04-T00-REQUIRED-SCHEDULES-EZ

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

Year Table CSV Parquet Rows
2024 F9-P04-T00-REQUIRED-SCHEDULES-EZ-2024 CSV Parquet 9,825
2023 F9-P04-T00-REQUIRED-SCHEDULES-EZ-2023 CSV Parquet 11,830
2022 F9-P04-T00-REQUIRED-SCHEDULES-EZ-2022 CSV Parquet 9,988
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
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–2024 · 5,981,036 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P05-T00-OTHER-IRS-FILING-2024 CSV Parquet 456,170
2023 F9-P05-T00-OTHER-IRS-FILING-2023 CSV Parquet 561,156
2022 F9-P05-T00-OTHER-IRS-FILING-2022 CSV Parquet 555,197
2021 F9-P05-T00-OTHER-IRS-FILING-2021 CSV Parquet 539,217
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
Back to contents

P06 Part VI - Governance, Management, and Disclosure

F9-P06-T00-GOVERNANCE

1:1 one row per filing · tax years 2009–2024 · 5,981,036 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P06-T00-GOVERNANCE-2024 CSV Parquet 456,170
2023 F9-P06-T00-GOVERNANCE-2023 CSV Parquet 561,156
2022 F9-P06-T00-GOVERNANCE-2022 CSV Parquet 555,197
2021 F9-P06-T00-GOVERNANCE-2021 CSV Parquet 539,217
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
Back to contents

F9-P06-T00-GOVERNANCE-EZ

1:1 one row per filing · tax years 2009–2024 · 2,135,895 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P06-T00-GOVERNANCE-EZ-2024 CSV Parquet 178,868
2023 F9-P06-T00-GOVERNANCE-EZ-2023 CSV Parquet 206,382
2022 F9-P06-T00-GOVERNANCE-EZ-2022 CSV Parquet 206,135
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
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–2024 · 5,690,492 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P07-T00-DIR-TRUST-KEY-2024 CSV Parquet 431,370
2023 F9-P07-T00-DIR-TRUST-KEY-2023 CSV Parquet 530,868
2022 F9-P07-T00-DIR-TRUST-KEY-2022 CSV Parquet 529,600
2021 F9-P07-T00-DIR-TRUST-KEY-2021 CSV Parquet 513,694
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
Back to contents

F9-P07-T01-COMPENSATION

1:M many rows per filing · tax years 2009–2024 · 58,675,305 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P07-T01-COMPENSATION-2024 CSV Parquet 3,880,073
2023 F9-P07-T01-COMPENSATION-2023 CSV Parquet 5,095,205
2022 F9-P07-T01-COMPENSATION-2022 CSV Parquet 5,073,368
2021 F9-P07-T01-COMPENSATION-2021 CSV Parquet 4,976,573
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
Back to contents

F9-P07-T01-COMPENSATION-HCE-EZ

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

Year Table CSV Parquet Rows
2024 F9-P07-T01-COMPENSATION-HCE-EZ-2024 CSV Parquet 496
2023 F9-P07-T01-COMPENSATION-HCE-EZ-2023 CSV Parquet 746
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
Back to contents

F9-P07-T02-CONTRACTORS

1:M many rows per filing · tax years 2009–2024 · 1,429,297 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P07-T02-CONTRACTORS-2024 CSV Parquet 84,190
2023 F9-P07-T02-CONTRACTORS-2023 CSV Parquet 128,841
2022 F9-P07-T02-CONTRACTORS-2022 CSV Parquet 122,923
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
Back to contents

P08 Part VIII - Statement of Revenue

F9-P08-T00-REVENUE

1:1 one row per filing · tax years 2009–2024 · 5,641,196 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P08-T00-REVENUE-2024 CSV Parquet 425,521
2023 F9-P08-T00-REVENUE-2023 CSV Parquet 525,228
2022 F9-P08-T00-REVENUE-2022 CSV Parquet 518,555
2021 F9-P08-T00-REVENUE-2021 CSV Parquet 503,634
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
Back to contents

F9-P08-T01-REVENUE-PROGRAMS

1:M many rows per filing · tax years 2009–2024 · 5,558,284 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P08-T01-REVENUE-PROGRAMS-2024 CSV Parquet 362,083
2023 F9-P08-T01-REVENUE-PROGRAMS-2023 CSV Parquet 480,038
2022 F9-P08-T01-REVENUE-PROGRAMS-2022 CSV Parquet 473,299
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
Back to contents

F9-P08-T02-REVENUE-MISC

1:M many rows per filing · tax years 2009–2024 · 2,166,543 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P08-T02-REVENUE-MISC-2024 CSV Parquet 140,619
2023 F9-P08-T02-REVENUE-MISC-2023 CSV Parquet 187,575
2022 F9-P08-T02-REVENUE-MISC-2022 CSV Parquet 185,068
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
Back to contents

P09 Part IX - Statement of Functional Expenses

F9-P09-T00-EXPENSES

1:1 one row per filing · tax years 2009–2024 · 5,208,251 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P09-T00-EXPENSES-2024 CSV Parquet 389,798
2023 F9-P09-T00-EXPENSES-2023 CSV Parquet 483,934
2022 F9-P09-T00-EXPENSES-2022 CSV Parquet 479,091
2021 F9-P09-T00-EXPENSES-2021 CSV Parquet 464,713
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
Back to contents

F9-P09-T01-EXPENSES-OTHER

1:M many rows per filing · tax years 2009–2024 · 12,327,423 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P09-T01-EXPENSES-OTHER-2024 CSV Parquet 841,101
2023 F9-P09-T01-EXPENSES-OTHER-2023 CSV Parquet 1,086,442
2022 F9-P09-T01-EXPENSES-OTHER-2022 CSV Parquet 1,071,514
2021 F9-P09-T01-EXPENSES-OTHER-2021 CSV Parquet 1,031,774
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
Back to contents

P10 Part X - Balance Sheet

F9-P10-T00-BALANCE-SHEET

1:1 one row per filing · tax years 2009–2024 · 5,981,036 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P10-T00-BALANCE-SHEET-2024 CSV Parquet 456,170
2023 F9-P10-T00-BALANCE-SHEET-2023 CSV Parquet 561,156
2022 F9-P10-T00-BALANCE-SHEET-2022 CSV Parquet 555,197
2021 F9-P10-T00-BALANCE-SHEET-2021 CSV Parquet 539,217
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
Back to contents

P11 Part XI - Reconciliation of Net Assets

F9-P11-T00-ASSETS

1:1 one row per filing · tax years 2009–2024 · 4,591,476 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P11-T00-ASSETS-2024 CSV Parquet 347,694
2023 F9-P11-T00-ASSETS-2023 CSV Parquet 435,086
2022 F9-P11-T00-ASSETS-2022 CSV Parquet 429,791
2021 F9-P11-T00-ASSETS-2021 CSV Parquet 416,833
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
Back to contents

P12 Part XII - Financial Statements and Reporting

F9-P12-T00-FINANCIAL-REPORTING

1:1 one row per filing · tax years 2009–2024 · 5,973,131 rows · Data dictionary

Year Table CSV Parquet Rows
2024 F9-P12-T00-FINANCIAL-REPORTING-2024 CSV Parquet 455,316
2023 F9-P12-T00-FINANCIAL-REPORTING-2023 CSV Parquet 560,227
2022 F9-P12-T00-FINANCIAL-REPORTING-2022 CSV Parquet 554,290
2021 F9-P12-T00-FINANCIAL-REPORTING-2021 CSV Parquet 538,346
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
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–2024 · 4,594,558 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SA-P01-T00-PUBLIC-CHARITY-STATUS-2024 CSV Parquet 354,153
2023 SA-P01-T00-PUBLIC-CHARITY-STATUS-2023 CSV Parquet 437,894
2022 SA-P01-T00-PUBLIC-CHARITY-STATUS-2022 CSV Parquet 430,993
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
Back to contents

SA-P01-T01-PUBLIC-CHARITY-STATUS

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

Year Table CSV Parquet Rows
2024 SA-P01-T01-PUBLIC-CHARITY-STATUS-2024 CSV Parquet 29,601
2023 SA-P01-T01-PUBLIC-CHARITY-STATUS-2023 CSV Parquet 45,777
2022 SA-P01-T01-PUBLIC-CHARITY-STATUS-2022 CSV Parquet 45,678
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
Back to contents

SA-P01-T02-HOSPITAL-NAME-ADDRESS

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

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

Year Table CSV Parquet Rows
2024 SA-P01-T02-HOSPITAL-NAME-ADDRESS-2024 CSV Parquet 384
2023 SA-P01-T02-HOSPITAL-NAME-ADDRESS-2023 CSV Parquet 504
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
Back to contents

SA-P01-T03-AGRI-RESEARCH-UNIV

1:M many rows per filing · tax years 2016–2024 · 276 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
2024 SA-P01-T03-AGRI-RESEARCH-UNIV-2024 CSV Parquet 41
2023 SA-P01-T03-AGRI-RESEARCH-UNIV-2023 CSV Parquet 37
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
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–2024 · 2,286,772 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SA-P02-T00-SUPPORT_SCHEDULE_170-2024 CSV Parquet 169,162
2023 SA-P02-T00-SUPPORT_SCHEDULE_170-2023 CSV Parquet 208,597
2022 SA-P02-T00-SUPPORT_SCHEDULE_170-2022 CSV Parquet 205,718
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
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–2024 · 2,292,872 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SA-P03-T00-SUPPORT_SCHEDULE_509-2024 CSV Parquet 182,164
2023 SA-P03-T00-SUPPORT_SCHEDULE_509-2023 CSV Parquet 217,330
2022 SA-P03-T00-SUPPORT_SCHEDULE_509-2022 CSV Parquet 213,731
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
Back to contents

P04 Part IV - Supporting Organizations

SA-P04-T00-SUPPORT-ORGS

1:1 one row per filing · tax years 2014–2024 · 217,619 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SA-P04-T00-SUPPORT-ORGS-2024 CSV Parquet 16,782
2023 SA-P04-T00-SUPPORT-ORGS-2023 CSV Parquet 23,565
2022 SA-P04-T00-SUPPORT-ORGS-2022 CSV Parquet 23,810
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
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–2024 · 47,171 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SA-P05-T00-SUPPORT-ORGS-2024 CSV Parquet 7,626
2023 SA-P05-T00-SUPPORT-ORGS-2023 CSV Parquet 6,709
2022 SA-P05-T00-SUPPORT-ORGS-2022 CSV Parquet 5,824
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
Back to contents

P06 Part VI - Supplemental Information

SA-P06-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2009–2024 · 691,400 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SA-P06-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 55,142
2023 SA-P06-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 74,248
2022 SA-P06-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 73,996
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
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–2024 · 2,250,579 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SB-P01-T01-CONTRIBUTORS-2024 CSV Parquet 187,035
2023 SB-P01-T01-CONTRIBUTORS-2023 CSV Parquet 237,646
2022 SB-P01-T01-CONTRIBUTORS-2022 CSV Parquet 234,458
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
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–2024 · 96,965 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SC-P01-T00-LOBBY-2024 CSV Parquet 6,458
2023 SC-P01-T00-LOBBY-2023 CSV Parquet 7,796
2022 SC-P01-T00-LOBBY-2022 CSV Parquet 7,787
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
Back to contents

SC-P01-T01-POLITICAL-ORGS-INFO

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

Year Table CSV Parquet Rows
2024 SC-P01-T01-POLITICAL-ORGS-INFO-2024 CSV Parquet 9,386
2023 SC-P01-T01-POLITICAL-ORGS-INFO-2023 CSV Parquet 9,298
2022 SC-P01-T01-POLITICAL-ORGS-INFO-2022 CSV Parquet 10,596
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
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–2024 · 188,534 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SC-P02-T00-LOBBY-2024 CSV Parquet 9,755
2023 SC-P02-T00-LOBBY-2023 CSV Parquet 14,827
2022 SC-P02-T00-LOBBY-2022 CSV Parquet 14,590
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
Back to contents

SC-P02-T01-AFFILIATED-GROUP

1:M many rows per filing · tax years 2009–2024 · 20,292 rows · Data dictionary

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

Year Table CSV Parquet Rows
2024 SC-P02-T01-AFFILIATED-GROUP-2024 CSV Parquet 1,584
2023 SC-P02-T01-AFFILIATED-GROUP-2023 CSV Parquet 2,321
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
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–2024 · 249,433 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SC-P03-T00-LOBBY-2024 CSV Parquet 18,250
2023 SC-P03-T00-LOBBY-2023 CSV Parquet 22,450
2022 SC-P03-T00-LOBBY-2022 CSV Parquet 22,278
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
Back to contents

P04 Part IV - Supplemental Information

SC-P04-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2009–2024 · 149,196 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SC-P04-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 8,773
2023 SC-P04-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 12,658
2022 SC-P04-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 12,855
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
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–2024 · 102,093 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2024 CSV Parquet 2,744
2023 SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2023 CSV Parquet 5,919
2022 SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2022 CSV Parquet 5,530
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
Back to contents

P02 Part II - Conservation Easements

SD-P02-T00-CONSERV-EASEMENTS

1:1 one row per filing · tax years 2009–2024 · 89,948 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SD-P02-T00-CONSERV-EASEMENTS-2024 CSV Parquet 2,090
2023 SD-P02-T00-CONSERV-EASEMENTS-2023 CSV Parquet 5,063
2022 SD-P02-T00-CONSERV-EASEMENTS-2022 CSV Parquet 4,638
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
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–2024 · 148,770 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2024 CSV Parquet 5,320
2023 SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2023 CSV Parquet 10,410
2022 SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2022 CSV Parquet 9,994
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
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–2024 · 308,476 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2024 CSV Parquet 15,191
2023 SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2023 CSV Parquet 23,731
2022 SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2022 CSV Parquet 24,156
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
Back to contents

P05 Part V - Endowment Funds

SD-P05-T00-ENDOWMENT

1:1 one row per filing · tax years 2009–2024 · 506,708 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SD-P05-T00-ENDOWMENT-2024 CSV Parquet 24,792
2023 SD-P05-T00-ENDOWMENT-2023 CSV Parquet 37,723
2022 SD-P05-T00-ENDOWMENT-2022 CSV Parquet 37,636
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
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–2024 · 2,901,535 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SD-P06-T00-LAND-BLDG-EQUIP-2024 CSV Parquet 186,287
2023 SD-P06-T00-LAND-BLDG-EQUIP-2023 CSV Parquet 248,882
2022 SD-P06-T00-LAND-BLDG-EQUIP-2022 CSV Parquet 248,672
2021 SD-P06-T00-LAND-BLDG-EQUIP-2021 CSV Parquet 243,920
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
Back to contents

P07 Part VII - Investments - Other Securities

SD-P07-T00-INVESTMENTS-SECURITIES

1:1 one row per filing · tax years 2009–2024 · 273,785 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SD-P07-T00-INVESTMENTS-SECURITIES-2024 CSV Parquet 16,261
2023 SD-P07-T00-INVESTMENTS-SECURITIES-2023 CSV Parquet 22,921
2022 SD-P07-T00-INVESTMENTS-SECURITIES-2022 CSV Parquet 22,283
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
Back to contents

SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES

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

Year Table CSV Parquet Rows
2024 SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES-2024 CSV Parquet 644
2023 SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES-2023 CSV Parquet 802
2022 SD-P07-T00-INVESTMENTS-OTH-DERIVATIVES-2022 CSV Parquet 856
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
Back to contents

SD-P07-T00-INVESTMENTS-OTH-EQUITY

1:1 one row per filing · tax years 2009–2024 · 18,434 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SD-P07-T00-INVESTMENTS-OTH-EQUITY-2024 CSV Parquet 1,003
2023 SD-P07-T00-INVESTMENTS-OTH-EQUITY-2023 CSV Parquet 1,379
2022 SD-P07-T00-INVESTMENTS-OTH-EQUITY-2022 CSV Parquet 1,461
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
Back to contents

SD-P07-T01-INVESTMENTS-OTH-SECURITIES

1:M many rows per filing · tax years 2009–2024 · 765,727 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2024 CSV Parquet 45,556
2023 SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2023 CSV Parquet 62,166
2022 SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2022 CSV Parquet 62,946
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
Back to contents

P08 Part VIII - Investments - Program Related

SD-P08-T00-INVESTMENTS-PROG-RLTD

1:1 one row per filing · tax years 2009–2024 · 79,501 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SD-P08-T00-INVESTMENTS-PROG-RLTD-2024 CSV Parquet 5,193
2023 SD-P08-T00-INVESTMENTS-PROG-RLTD-2023 CSV Parquet 6,921
2022 SD-P08-T00-INVESTMENTS-PROG-RLTD-2022 CSV Parquet 6,666
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
Back to contents

SD-P08-T01-INVESTMENTS-PROG-RLTD

1:M many rows per filing · tax years 2009–2024 · 179,324 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SD-P08-T01-INVESTMENTS-PROG-RLTD-2024 CSV Parquet 11,973
2023 SD-P08-T01-INVESTMENTS-PROG-RLTD-2023 CSV Parquet 15,298
2022 SD-P08-T01-INVESTMENTS-PROG-RLTD-2022 CSV Parquet 15,056
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
Back to contents

P09 Part IX - Other Assets

SD-P09-T00-OTH-ASSETS

1:1 one row per filing · tax years 2009–2024 · 566,800 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SD-P09-T00-OTH-ASSETS-2024 CSV Parquet 40,863
2023 SD-P09-T00-OTH-ASSETS-2023 CSV Parquet 61,547
2022 SD-P09-T00-OTH-ASSETS-2022 CSV Parquet 60,086
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
Back to contents

SD-P09-T01-OTH-ASSETS

1:M many rows per filing · tax years 2009–2024 · 1,257,877 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SD-P09-T01-OTH-ASSETS-2024 CSV Parquet 88,093
2023 SD-P09-T01-OTH-ASSETS-2023 CSV Parquet 134,245
2022 SD-P09-T01-OTH-ASSETS-2022 CSV Parquet 130,849
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
Back to contents

P10 Part X - Other Liabilities

SD-P10-T00-OTH-LIABILITIES

1:1 one row per filing · tax years 2009–2024 · 1,851,092 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SD-P10-T00-OTH-LIABILITIES-2024 CSV Parquet 120,089
2023 SD-P10-T00-OTH-LIABILITIES-2023 CSV Parquet 166,661
2022 SD-P10-T00-OTH-LIABILITIES-2022 CSV Parquet 164,548
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
Back to contents

SD-P10-T01-OTH-LIABILITIES

1:M many rows per filing · tax years 2009–2024 · 2,904,804 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SD-P10-T01-OTH-LIABILITIES-2024 CSV Parquet 193,093
2023 SD-P10-T01-OTH-LIABILITIES-2023 CSV Parquet 270,245
2022 SD-P10-T01-OTH-LIABILITIES-2022 CSV Parquet 266,055
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
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–2024 · 1,387,280 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SD-P11-T00-RECONCILIATION-REVENUE-2024 CSV Parquet 73,045
2023 SD-P11-T00-RECONCILIATION-REVENUE-2023 CSV Parquet 104,777
2022 SD-P11-T00-RECONCILIATION-REVENUE-2022 CSV Parquet 106,313
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
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–2024 · 1,386,644 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SD-P12-T00-RECONCILIATION-EXPENSES-2024 CSV Parquet 73,030
2023 SD-P12-T00-RECONCILIATION-EXPENSES-2023 CSV Parquet 104,751
2022 SD-P12-T00-RECONCILIATION-EXPENSES-2022 CSV Parquet 106,294
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
Back to contents

P13 Part XIII - Supplemental Information

SD-P13-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2009–2024 · 2,733,959 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SD-P13-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 135,293
2023 SD-P13-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 206,132
2022 SD-P13-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 208,970
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
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
Back to contents

Schedule E: Schools

P01 Part I - Schools

SE-P01-T00-SCHOOLS

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

Year Table CSV Parquet Rows
2024 SE-P01-T00-SCHOOLS-2024 CSV Parquet 11,672
2023 SE-P01-T00-SCHOOLS-2023 CSV Parquet 19,347
2022 SE-P01-T00-SCHOOLS-2022 CSV Parquet 19,405
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
Back to contents

P02 Part II - Supplemental Information

SE-P02-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2010–2024 · 344,824 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SE-P02-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 17,209
2023 SE-P02-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 30,234
2022 SE-P02-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 30,541
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
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–2024 · 172,024 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SF-P01-T00-FRGN-ACTS-2024 CSV Parquet 12,744
2023 SF-P01-T00-FRGN-ACTS-2023 CSV Parquet 16,340
2022 SF-P01-T00-FRGN-ACTS-2022 CSV Parquet 15,851
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
Back to contents

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

1:M many rows per filing · tax years 2009–2024 · 529,286 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SF-P01-T01-FRGN-ACTS-BY-REGION-2024 CSV Parquet 34,328
2023 SF-P01-T01-FRGN-ACTS-BY-REGION-2023 CSV Parquet 48,199
2022 SF-P01-T01-FRGN-ACTS-BY-REGION-2022 CSV Parquet 46,552
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
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–2024 · 71,108 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SF-P02-T00-FRGN-ORG-GRANTS-2024 CSV Parquet 6,016
2023 SF-P02-T00-FRGN-ORG-GRANTS-2023 CSV Parquet 7,152
2022 SF-P02-T00-FRGN-ORG-GRANTS-2022 CSV Parquet 7,097
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
Back to contents

SF-P02-T01-FRGN-ORG-GRANTS

1:M many rows per filing · tax years 2009–2024 · 859,715 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SF-P02-T01-FRGN-ORG-GRANTS-2024 CSV Parquet 66,738
2023 SF-P02-T01-FRGN-ORG-GRANTS-2023 CSV Parquet 82,127
2022 SF-P02-T01-FRGN-ORG-GRANTS-2022 CSV Parquet 82,804
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
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–2024 · 130,689 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SF-P03-T01-FRGN-INDIV-GRANTS-2024 CSV Parquet 9,083
2023 SF-P03-T01-FRGN-INDIV-GRANTS-2023 CSV Parquet 12,326
2022 SF-P03-T01-FRGN-INDIV-GRANTS-2022 CSV Parquet 11,553
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
Back to contents

P04 Part IV - Foreign Forms

SF-P04-T00-FRGN-INTERESTS

1:1 one row per filing · tax years 2010–2024 · 185,329 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SF-P04-T00-FRGN-INTERESTS-2024 CSV Parquet 14,495
2023 SF-P04-T00-FRGN-INTERESTS-2023 CSV Parquet 18,153
2022 SF-P04-T00-FRGN-INTERESTS-2022 CSV Parquet 17,528
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
Back to contents

P05 Part V - Supplemental Information

SF-P05-T99-EXPLANATION-TEXT

1:M many rows per filing · tax years 2009–2024 · 191,383 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SF-P05-T99-EXPLANATION-TEXT-2024 CSV Parquet 12,597
2023 SF-P05-T99-EXPLANATION-TEXT-2023 CSV Parquet 16,371
2022 SF-P05-T99-EXPLANATION-TEXT-2022 CSV Parquet 23,551
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
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
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–2024 · 330,239 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SG-P01-T00-FUNDRAISING-ACTS-2024 CSV Parquet 20,506
2023 SG-P01-T00-FUNDRAISING-ACTS-2023 CSV Parquet 27,498
2022 SG-P01-T00-FUNDRAISING-ACTS-2022 CSV Parquet 26,366
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
Back to contents

SG-P01-T01-FUNDRAISERS-INFO

1:M many rows per filing · tax years 2009–2024 · 121,933 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SG-P01-T01-FUNDRAISERS-INFO-2024 CSV Parquet 6,923
2023 SG-P01-T01-FUNDRAISERS-INFO-2023 CSV Parquet 10,117
2022 SG-P01-T01-FUNDRAISERS-INFO-2022 CSV Parquet 9,849
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
Back to contents

P02 Part II - Fundraising Events

SG-P02-T00-FUNDRAISING-EVENTS

1:1 one row per filing · tax years 2009–2024 · 1,182,348 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SG-P02-T00-FUNDRAISING-EVENTS-2024 CSV Parquet 82,133
2023 SG-P02-T00-FUNDRAISING-EVENTS-2023 CSV Parquet 104,732
2022 SG-P02-T00-FUNDRAISING-EVENTS-2022 CSV Parquet 99,767
2021 SG-P02-T00-FUNDRAISING-EVENTS-2021 CSV Parquet 87,667
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
Back to contents

P03 Part III - Gaming

SG-P03-T00-GAMING

1:1 one row per filing · tax years 2009–2024 · 178,417 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SG-P03-T00-GAMING-2024 CSV Parquet 13,582
2023 SG-P03-T00-GAMING-2023 CSV Parquet 17,052
2022 SG-P03-T00-GAMING-2022 CSV Parquet 16,389
2021 SG-P03-T00-GAMING-2021 CSV Parquet 15,326
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
Back to contents

P04 Part IV - Supplemental Information

SG-P04-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2010–2024 · 51,672 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SG-P04-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 4,040
2023 SG-P04-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 5,060
2022 SG-P04-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 5,113
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
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–2024 · 35,958 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2024 CSV Parquet 984
2023 SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2023 CSV Parquet 2,313
2022 SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2022 CSV Parquet 2,357
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
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–2024 · 20,013 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2024 CSV Parquet 563
2023 SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2023 CSV Parquet 1,428
2022 SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2022 CSV Parquet 1,330
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
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–2024 · 35,852 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2024 CSV Parquet 981
2023 SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2023 CSV Parquet 2,312
2022 SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2022 CSV Parquet 2,354
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
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–2024 · 18,026 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SH-P04-T01-COMPANY-JOINT-VENTURES-2024 CSV Parquet 528
2023 SH-P04-T01-COMPANY-JOINT-VENTURES-2023 CSV Parquet 961
2022 SH-P04-T01-COMPANY-JOINT-VENTURES-2022 CSV Parquet 1,028
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
Back to contents

P05 Part V - Facility Information

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

1:1 one row per filing · tax years 2010–2024 · 34,378 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2024 CSV Parquet 985
2023 SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2023 CSV Parquet 2,314
2022 SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2022 CSV Parquet 2,357
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
Back to contents

SH-P05-T01-HOSPITAL-FACILITY

1:M many rows per filing · tax years 2009–2024 · 61,073 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SH-P05-T01-HOSPITAL-FACILITY-2024 CSV Parquet 1,732
2023 SH-P05-T01-HOSPITAL-FACILITY-2023 CSV Parquet 3,742
2022 SH-P05-T01-HOSPITAL-FACILITY-2022 CSV Parquet 3,733
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
Back to contents

SH-P05-T02-NON-HOSPITAL-FACILITY

1:M many rows per filing · tax years 2010–2024 · 316,563 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SH-P05-T02-NON-HOSPITAL-FACILITY-2024 CSV Parquet 17,163
2023 SH-P05-T02-NON-HOSPITAL-FACILITY-2023 CSV Parquet 27,567
2022 SH-P05-T02-NON-HOSPITAL-FACILITY-2022 CSV Parquet 27,381
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
Back to contents

SH-P05-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2013–2024 · 181,422 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SH-P05-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 7,468
2023 SH-P05-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 17,055
2022 SH-P05-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 17,267
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
Back to contents

SH-P05-T03-FACILITY-POLICIES-PRACTICES

1:M many rows per filing · tax years 2010–2024 · 42,346 rows · Data dictionary

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

Year Table CSV Parquet Rows
2024 SH-P05-T03-FACILITY-POLICIES-PRACTICES-2024 CSV Parquet 1,151
2023 SH-P05-T03-FACILITY-POLICIES-PRACTICES-2023 CSV Parquet 2,706
2022 SH-P05-T03-FACILITY-POLICIES-PRACTICES-2022 CSV Parquet 2,743
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
Back to contents

P06 Part VI - Supplemental Information

SH-P06-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2009–2024 · 448,872 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SH-P06-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 13,430
2023 SH-P06-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 32,306
2022 SH-P06-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 32,094
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
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
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–2024 · 857,611 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SI-P01-T00-GRANTS-INFO-2024 CSV Parquet 60,804
2023 SI-P01-T00-GRANTS-INFO-2023 CSV Parquet 79,828
2022 SI-P01-T00-GRANTS-INFO-2022 CSV Parquet 77,629
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
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–2024 · 420,226 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SI-P02-T00-GRANTS-US-ORGS-GOVTS-2024 CSV Parquet 28,510
2023 SI-P02-T00-GRANTS-US-ORGS-GOVTS-2023 CSV Parquet 38,784
2022 SI-P02-T00-GRANTS-US-ORGS-GOVTS-2022 CSV Parquet 37,776
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
Back to contents

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

1:M many rows per filing · tax years 2009–2024 · 8,843,247 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SI-P02-T01-GRANTS-US-ORGS-GOVTS-2024 CSV Parquet 641,902
2023 SI-P02-T01-GRANTS-US-ORGS-GOVTS-2023 CSV Parquet 974,603
2022 SI-P02-T01-GRANTS-US-ORGS-GOVTS-2022 CSV Parquet 929,639
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
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–2024 · 814,564 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SI-P03-T01-GRANTS-US-INDIV-2024 CSV Parquet 52,633
2023 SI-P03-T01-GRANTS-US-INDIV-2023 CSV Parquet 73,678
2022 SI-P03-T01-GRANTS-US-INDIV-2022 CSV Parquet 72,406
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
Back to contents

P04 Part IV - Supplemental Information

SI-P04-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2009–2024 · 573,405 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SI-P04-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 35,239
2023 SI-P04-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 48,997
2022 SI-P04-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 48,138
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
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
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–2024 · 858,988 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SJ-P01-T00-COMPENSATION-2024 CSV Parquet 55,850
2023 SJ-P01-T00-COMPENSATION-2023 CSV Parquet 80,590
2022 SJ-P01-T00-COMPENSATION-2022 CSV Parquet 76,876
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
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–2024 · 3,326,738 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SJ-P02-T01-COMPENSATION-DTK-2024 CSV Parquet 201,626
2023 SJ-P02-T01-COMPENSATION-DTK-2023 CSV Parquet 317,569
2022 SJ-P02-T01-COMPENSATION-DTK-2022 CSV Parquet 300,854
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
Back to contents

P03 Part III - Supplemental Information

SJ-P03-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2009–2024 · 573,193 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SJ-P03-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 29,851
2023 SJ-P03-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 50,165
2022 SJ-P03-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 48,716
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
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–2024 · 155,221 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SK-P01-T01-BOND-ISSUES-2024 CSV Parquet 4,987
2023 SK-P01-T01-BOND-ISSUES-2023 CSV Parquet 10,164
2022 SK-P01-T01-BOND-ISSUES-2022 CSV Parquet 10,319
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
Back to contents

P02 Part II - Proceeds

SK-P02-T01-BOND-PROCEEDS

1:M many rows per filing · tax years 2009–2024 · 153,503 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SK-P02-T01-BOND-PROCEEDS-2024 CSV Parquet 4,959
2023 SK-P02-T01-BOND-PROCEEDS-2023 CSV Parquet 10,118
2022 SK-P02-T01-BOND-PROCEEDS-2022 CSV Parquet 10,258
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
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–2024 · 144,766 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SK-P03-T01-BOND-PRIVATE-BIZ-USE-2024 CSV Parquet 4,621
2023 SK-P03-T01-BOND-PRIVATE-BIZ-USE-2023 CSV Parquet 9,475
2022 SK-P03-T01-BOND-PRIVATE-BIZ-USE-2022 CSV Parquet 9,625
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
Back to contents

P04 Part IV - Arbitrage

SK-P04-T01-BOND-ARBITRAGE

1:M many rows per filing · tax years 2009–2024 · 151,237 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SK-P04-T01-BOND-ARBITRAGE-2024 CSV Parquet 4,910
2023 SK-P04-T01-BOND-ARBITRAGE-2023 CSV Parquet 10,010
2022 SK-P04-T01-BOND-ARBITRAGE-2022 CSV Parquet 10,141
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
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–2024 · 121,185 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2024 CSV Parquet 4,714
2023 SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2023 CSV Parquet 9,623
2022 SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2022 CSV Parquet 9,726
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
Back to contents

P06 Part VI - Supplemental Information

SK-P06-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2010–2024 · 85,739 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SK-P06-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 3,411
2023 SK-P06-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 7,380
2022 SK-P06-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 7,210
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
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–2024 · 733 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2024 CSV Parquet 92
2023 SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2023 CSV Parquet 105
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
Back to contents

SL-P01-T01-EXCESS-BENEFIT-TRANSAC

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

Year Table CSV Parquet Rows
2024 SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2024 CSV Parquet 207
2023 SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2023 CSV Parquet 2,776
2022 SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2022 CSV Parquet 2,749
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
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–2024 · 140,698 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SL-P02-T00-LOANS-INTERESTED-PERS-2024 CSV Parquet 8,030
2023 SL-P02-T00-LOANS-INTERESTED-PERS-2023 CSV Parquet 9,968
2022 SL-P02-T00-LOANS-INTERESTED-PERS-2022 CSV Parquet 10,089
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
Back to contents

SL-P02-T01-LOANS-INTERESTED-PERS

1:M many rows per filing · tax years 2009–2024 · 317,645 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SL-P02-T01-LOANS-INTERESTED-PERS-2024 CSV Parquet 16,278
2023 SL-P02-T01-LOANS-INTERESTED-PERS-2023 CSV Parquet 24,597
2022 SL-P02-T01-LOANS-INTERESTED-PERS-2022 CSV Parquet 24,556
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
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–2024 · 32,570 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SL-P03-T01-GRANTS-INTERESTED-PERS-2024 CSV Parquet 1,574
2023 SL-P03-T01-GRANTS-INTERESTED-PERS-2023 CSV Parquet 2,516
2022 SL-P03-T01-GRANTS-INTERESTED-PERS-2022 CSV Parquet 2,513
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
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–2024 · 502,396 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2024 CSV Parquet 21,089
2023 SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2023 CSV Parquet 34,463
2022 SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2022 CSV Parquet 34,600
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
Back to contents

P05 Part V - Supplemental Information

SL-P05-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2010–2024 · 73,686 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SL-P05-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 4,376
2023 SL-P05-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 5,847
2022 SL-P05-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 5,927
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
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–2024 · 378,645 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SM-P01-T00-NONCASH-CONTRIBUTIONS-2024 CSV Parquet 23,500
2023 SM-P01-T00-NONCASH-CONTRIBUTIONS-2023 CSV Parquet 32,163
2022 SM-P01-T00-NONCASH-CONTRIBUTIONS-2022 CSV Parquet 31,413
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
Back to contents

SM-P01-T01-NONCASH-CONTRIBUTIONS

1:M many rows per filing · tax years 2009–2024 · 423,526 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SM-P01-T01-NONCASH-CONTRIBUTIONS-2024 CSV Parquet 23,449
2023 SM-P01-T01-NONCASH-CONTRIBUTIONS-2023 CSV Parquet 33,460
2022 SM-P01-T01-NONCASH-CONTRIBUTIONS-2022 CSV Parquet 31,686
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
Back to contents

P02 Part II - Supplemental Information

SM-P02-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2009–2024 · 126,717 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SM-P02-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 7,783
2023 SM-P02-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 11,728
2022 SM-P02-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 11,360
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
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–2024 · 42,523 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2024 CSV Parquet 4,052
2023 SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2023 CSV Parquet 4,403
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
Back to contents

SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION

1:M many rows per filing · tax years 2009–2024 · 75,601 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2024 CSV Parquet 6,755
2023 SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2023 CSV Parquet 7,934
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
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–2024 · 19,177 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SN-P02-T00-DISPOSITION-OF-ASSETS-2024 CSV Parquet 1,205
2023 SN-P02-T00-DISPOSITION-OF-ASSETS-2023 CSV Parquet 1,666
2022 SN-P02-T00-DISPOSITION-OF-ASSETS-2022 CSV Parquet 1,730
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
Back to contents

SN-P02-T01-DISPOSITION-OF-ASSETS

1:M many rows per filing · tax years 2009–2024 · 31,152 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SN-P02-T01-DISPOSITION-OF-ASSETS-2024 CSV Parquet 1,940
2023 SN-P02-T01-DISPOSITION-OF-ASSETS-2023 CSV Parquet 2,559
2022 SN-P02-T01-DISPOSITION-OF-ASSETS-2022 CSV Parquet 2,400
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
Back to contents

P03 Part III - Supplemental Information

SN-P03-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2009–2024 · 25,190 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SN-P03-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 1,804
2023 SN-P03-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 2,074
2022 SN-P03-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 2,204
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
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
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–2024 · 32,509,092 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SO-P00-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 2,276,991
2023 SO-P00-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 2,889,150
2022 SO-P00-T99-SUPPLEMENTAL-INFO-2022 CSV Parquet 2,873,610
2021 SO-P00-T99-SUPPLEMENTAL-INFO-2021 CSV Parquet 2,799,474
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
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–2024 · 385,460 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SR-P01-T01-ID-DISREGARDED-ENTITIES-2024 CSV Parquet 24,332
2023 SR-P01-T01-ID-DISREGARDED-ENTITIES-2023 CSV Parquet 34,574
2022 SR-P01-T01-ID-DISREGARDED-ENTITIES-2022 CSV Parquet 33,471
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
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–2024 · 6,314,565 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2024 CSV Parquet 263,429
2023 SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2023 CSV Parquet 536,056
2022 SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2022 CSV Parquet 547,668
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
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–2024 · 2,782,289 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2024 CSV Parquet 177,020
2023 SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2023 CSV Parquet 258,379
2022 SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2022 CSV Parquet 260,947
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
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–2024 · 3,693,769 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2024 CSV Parquet 199,153
2023 SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2023 CSV Parquet 288,989
2022 SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2022 CSV Parquet 291,444
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
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–2024 · 923,008 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2024 CSV Parquet 51,126
2023 SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2023 CSV Parquet 74,978
2022 SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2022 CSV Parquet 75,123
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
Back to contents

SR-P05-T01-TRANSACTIONS-RLTD-ORGS

1:M many rows per filing · tax years 2009–2024 · 1,576,006 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2024 CSV Parquet 70,892
2023 SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2023 CSV Parquet 116,838
2022 SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2022 CSV Parquet 117,906
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
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–2024 · 5,774 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2024 CSV Parquet 200
2023 SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2023 CSV Parquet 306
2022 SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2022 CSV Parquet 531
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
Back to contents

P07 Part VII - Supplemental Information

SR-P07-T99-SUPPLEMENTAL-INFO

1:M many rows per filing · tax years 2010–2024 · 81,044 rows · Data dictionary

Year Table CSV Parquet Rows
2024 SR-P07-T99-SUPPLEMENTAL-INFO-2024 CSV Parquet 4,150
2023 SR-P07-T99-SUPPLEMENTAL-INFO-2023 CSV Parquet 7,327
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
Back to contents

Table list and row counts: public/efile_v2_3/COUNT-OF-ROWS-BY-TABLE-AND-FORMTYPE-EFILE_V2_3.CSV. Page rendered 2026-10-23.