990-PF Efile Data Catalog

Archived interim release · efilepf_v2_3

Superseded. This page lists efilepf_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-PF release is efilepf_v3_1.
Release efilepf_v2_3 (published 2026-10-07)
Returns Form 990-PF
Tax years 2009–2024
Tables 81 tables, 1,288 table-year files
Filings 1,151,314 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 = "PF-P01-T00-REVENUE-EXPENSE",
            years = 2020:2024,
            source = data_source( version = "v2_3", form = "990PF" ),
            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 990, 990-EZ 2026-10-07 Interim 2009–2024 136 5,981,036 —
efilepf_v2_3 this page 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

Shared tables (every e-filed return)

P00 Heading (items A-O)

F9-P00-T00-HEADER

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

Year Table CSV Parquet Rows
2024 F9-P00-T00-HEADER-2024 CSV Parquet 114,820
2023 F9-P00-T00-HEADER-2023 CSV Parquet 124,529
2022 F9-P00-T00-HEADER-2022 CSV Parquet 122,819
2021 F9-P00-T00-HEADER-2021 CSV Parquet 119,354
2020 F9-P00-T00-HEADER-2020 CSV Parquet 114,957
2019 F9-P00-T00-HEADER-2019 CSV Parquet 87,788
2018 F9-P00-T00-HEADER-2018 CSV Parquet 75,540
2017 F9-P00-T00-HEADER-2017 CSV Parquet 68,260
2016 F9-P00-T00-HEADER-2016 CSV Parquet 62,979
2015 F9-P00-T00-HEADER-2015 CSV Parquet 58,815
2014 F9-P00-T00-HEADER-2014 CSV Parquet 53,442
2013 F9-P00-T00-HEADER-2013 CSV Parquet 45,887
2012 F9-P00-T00-HEADER-2012 CSV Parquet 39,933
2011 F9-P00-T00-HEADER-2011 CSV Parquet 34,597
2010 F9-P00-T00-HEADER-2010 CSV Parquet 25,249
2009 F9-P00-T00-HEADER-2009 CSV Parquet 2,345
Back to contents

P02 Part II - Signature Block

F9-P02-T00-SIGNATURE

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

Year Table CSV Parquet Rows
2024 F9-P02-T00-SIGNATURE-2024 CSV Parquet 114,820
2023 F9-P02-T00-SIGNATURE-2023 CSV Parquet 124,529
2022 F9-P02-T00-SIGNATURE-2022 CSV Parquet 122,819
2021 F9-P02-T00-SIGNATURE-2021 CSV Parquet 119,354
2020 F9-P02-T00-SIGNATURE-2020 CSV Parquet 114,957
2019 F9-P02-T00-SIGNATURE-2019 CSV Parquet 87,788
2018 F9-P02-T00-SIGNATURE-2018 CSV Parquet 75,540
2017 F9-P02-T00-SIGNATURE-2017 CSV Parquet 68,260
2016 F9-P02-T00-SIGNATURE-2016 CSV Parquet 62,979
2015 F9-P02-T00-SIGNATURE-2015 CSV Parquet 58,815
2014 F9-P02-T00-SIGNATURE-2014 CSV Parquet 53,442
2013 F9-P02-T00-SIGNATURE-2013 CSV Parquet 45,887
2012 F9-P02-T00-SIGNATURE-2012 CSV Parquet 39,933
2011 F9-P02-T00-SIGNATURE-2011 CSV Parquet 34,597
2010 F9-P02-T00-SIGNATURE-2010 CSV Parquet 25,249
2009 F9-P02-T00-SIGNATURE-2009 CSV Parquet 2,345
Back to contents

Schedule B: Schedule of Contributors

P00 Heading - Organization Type and Filing Rules

SB-P00-T00-HEADER

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

Year Table CSV Parquet Rows
2024 SB-P00-T00-HEADER-2024 CSV Parquet 29,676
2023 SB-P00-T00-HEADER-2023 CSV Parquet 31,645
2022 SB-P00-T00-HEADER-2022 CSV Parquet 31,221
2021 SB-P00-T00-HEADER-2021 CSV Parquet 32,035
2020 SB-P00-T00-HEADER-2020 CSV Parquet 29,219
2019 SB-P00-T00-HEADER-2019 CSV Parquet 22,642
2018 SB-P00-T00-HEADER-2018 CSV Parquet 19,695
2017 SB-P00-T00-HEADER-2017 CSV Parquet 19,378
2016 SB-P00-T00-HEADER-2016 CSV Parquet 17,917
2015 SB-P00-T00-HEADER-2015 CSV Parquet 16,412
2014 SB-P00-T00-HEADER-2014 CSV Parquet 14,795
2013 SB-P00-T00-HEADER-2013 CSV Parquet 12,640
2012 SB-P00-T00-HEADER-2012 CSV Parquet 11,176
2011 SB-P00-T00-HEADER-2011 CSV Parquet 8,941
2010 SB-P00-T00-HEADER-2010 CSV Parquet 6,620
2009 SB-P00-T00-HEADER-2009 CSV Parquet 580
Back to contents

P01 Part I - Contributors

SB-P01-T01-CONTRIBUTORS

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

Year Table CSV Parquet Rows
2024 SB-P01-T01-CONTRIBUTORS-2024 CSV Parquet 66,886
2023 SB-P01-T01-CONTRIBUTORS-2023 CSV Parquet 72,826
2022 SB-P01-T01-CONTRIBUTORS-2022 CSV Parquet 70,127
2021 SB-P01-T01-CONTRIBUTORS-2021 CSV Parquet 70,850
2020 SB-P01-T01-CONTRIBUTORS-2020 CSV Parquet 61,894
2019 SB-P01-T01-CONTRIBUTORS-2019 CSV Parquet 48,270
2018 SB-P01-T01-CONTRIBUTORS-2018 CSV Parquet 40,448
2017 SB-P01-T01-CONTRIBUTORS-2017 CSV Parquet 39,781
2016 SB-P01-T01-CONTRIBUTORS-2016 CSV Parquet 35,875
2015 SB-P01-T01-CONTRIBUTORS-2015 CSV Parquet 32,649
2014 SB-P01-T01-CONTRIBUTORS-2014 CSV Parquet 30,990
2013 SB-P01-T01-CONTRIBUTORS-2013 CSV Parquet 25,225
2012 SB-P01-T01-CONTRIBUTORS-2012 CSV Parquet 22,586
2011 SB-P01-T01-CONTRIBUTORS-2011 CSV Parquet 18,287
2010 SB-P01-T01-CONTRIBUTORS-2010 CSV Parquet 12,895
2009 SB-P01-T01-CONTRIBUTORS-2009 CSV Parquet 1,454
Back to contents

P02 Part II - Noncash Property

SB-P02-T01-NONCASH-PROPERTY

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

Year Table CSV Parquet Rows
2024 SB-P02-T01-NONCASH-PROPERTY-2024 CSV Parquet 26,698
2023 SB-P02-T01-NONCASH-PROPERTY-2023 CSV Parquet 30,054
2022 SB-P02-T01-NONCASH-PROPERTY-2022 CSV Parquet 26,119
2021 SB-P02-T01-NONCASH-PROPERTY-2021 CSV Parquet 34,872
2020 SB-P02-T01-NONCASH-PROPERTY-2020 CSV Parquet 24,978
2019 SB-P02-T01-NONCASH-PROPERTY-2019 CSV Parquet 20,376
2018 SB-P02-T01-NONCASH-PROPERTY-2018 CSV Parquet 13,942
2017 SB-P02-T01-NONCASH-PROPERTY-2017 CSV Parquet 14,700
2016 SB-P02-T01-NONCASH-PROPERTY-2016 CSV Parquet 12,648
2015 SB-P02-T01-NONCASH-PROPERTY-2015 CSV Parquet 10,180
2014 SB-P02-T01-NONCASH-PROPERTY-2014 CSV Parquet 10,073
2013 SB-P02-T01-NONCASH-PROPERTY-2013 CSV Parquet 7,178
2012 SB-P02-T01-NONCASH-PROPERTY-2012 CSV Parquet 7,281
2011 SB-P02-T01-NONCASH-PROPERTY-2011 CSV Parquet 5,541
2010 SB-P02-T01-NONCASH-PROPERTY-2010 CSV Parquet 3,116
2009 SB-P02-T01-NONCASH-PROPERTY-2009 CSV Parquet 245
Back to contents

P03 Part III - Exclusively Religious, Charitable, etc., Contributions to Organizations Described in Section 501(c)(7), (8), or (10)

SB-P03-T01-EXCLUSIVELY-RELIGIOUS

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

Year Table CSV Parquet Rows
2024 SB-P03-T01-EXCLUSIVELY-RELIGIOUS-2024 CSV Parquet 163
2023 SB-P03-T01-EXCLUSIVELY-RELIGIOUS-2023 CSV Parquet 204
2022 SB-P03-T01-EXCLUSIVELY-RELIGIOUS-2022 CSV Parquet 148
2021 SB-P03-T01-EXCLUSIVELY-RELIGIOUS-2021 CSV Parquet 162
2020 SB-P03-T01-EXCLUSIVELY-RELIGIOUS-2020 CSV Parquet 135
2019 SB-P03-T01-EXCLUSIVELY-RELIGIOUS-2019 CSV Parquet 70
2018 SB-P03-T01-EXCLUSIVELY-RELIGIOUS-2018 CSV Parquet 96
2017 SB-P03-T01-EXCLUSIVELY-RELIGIOUS-2017 CSV Parquet 58
2016 SB-P03-T01-EXCLUSIVELY-RELIGIOUS-2016 CSV Parquet 41
2015 SB-P03-T01-EXCLUSIVELY-RELIGIOUS-2015 CSV Parquet 70
2014 SB-P03-T01-EXCLUSIVELY-RELIGIOUS-2014 CSV Parquet 52
2013 SB-P03-T01-EXCLUSIVELY-RELIGIOUS-2013 CSV Parquet 61
2012 SB-P03-T01-EXCLUSIVELY-RELIGIOUS-2012 CSV Parquet 58
2011 SB-P03-T01-EXCLUSIVELY-RELIGIOUS-2011 CSV Parquet 26
2010 SB-P03-T01-EXCLUSIVELY-RELIGIOUS-2010 CSV Parquet 7
2009 SB-P03-T01-EXCLUSIVELY-RELIGIOUS-2009 CSV Parquet 2
Back to contents

SB-P03-T00-EXCLUSIVELY-RELIGIOUS

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

Year Table CSV Parquet Rows
2024 SB-P03-T00-EXCLUSIVELY-RELIGIOUS-2024 CSV Parquet 5
2023 SB-P03-T00-EXCLUSIVELY-RELIGIOUS-2023 CSV Parquet 8
2022 SB-P03-T00-EXCLUSIVELY-RELIGIOUS-2022 CSV Parquet 8
2021 SB-P03-T00-EXCLUSIVELY-RELIGIOUS-2021 CSV Parquet 12
2020 SB-P03-T00-EXCLUSIVELY-RELIGIOUS-2020 CSV Parquet 8
2019 SB-P03-T00-EXCLUSIVELY-RELIGIOUS-2019 CSV Parquet 8
2018 SB-P03-T00-EXCLUSIVELY-RELIGIOUS-2018 CSV Parquet 8
2017 SB-P03-T00-EXCLUSIVELY-RELIGIOUS-2017 CSV Parquet 1
2016 SB-P03-T00-EXCLUSIVELY-RELIGIOUS-2016 CSV Parquet 4
2015 SB-P03-T00-EXCLUSIVELY-RELIGIOUS-2015 CSV Parquet 4
2013 SB-P03-T00-EXCLUSIVELY-RELIGIOUS-2013 CSV Parquet 2
2012 SB-P03-T00-EXCLUSIVELY-RELIGIOUS-2012 CSV Parquet 3
2011 SB-P03-T00-EXCLUSIVELY-RELIGIOUS-2011 CSV Parquet 32
2010 SB-P03-T00-EXCLUSIVELY-RELIGIOUS-2010 CSV Parquet 25
2009 SB-P03-T00-EXCLUSIVELY-RELIGIOUS-2009 CSV Parquet 2
Back to contents

Form 990-PF: Return of Private Foundation

P00 Heading (items A-J)

PF-P00-T00-HEADER

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

Year Table CSV Parquet Rows
2024 PF-P00-T00-HEADER-2024 CSV Parquet 114,820
2023 PF-P00-T00-HEADER-2023 CSV Parquet 124,529
2022 PF-P00-T00-HEADER-2022 CSV Parquet 122,819
2021 PF-P00-T00-HEADER-2021 CSV Parquet 119,354
2020 PF-P00-T00-HEADER-2020 CSV Parquet 114,957
2019 PF-P00-T00-HEADER-2019 CSV Parquet 87,788
2018 PF-P00-T00-HEADER-2018 CSV Parquet 75,540
2017 PF-P00-T00-HEADER-2017 CSV Parquet 68,260
2016 PF-P00-T00-HEADER-2016 CSV Parquet 62,979
2015 PF-P00-T00-HEADER-2015 CSV Parquet 58,815
2014 PF-P00-T00-HEADER-2014 CSV Parquet 53,442
2013 PF-P00-T00-HEADER-2013 CSV Parquet 45,887
2012 PF-P00-T00-HEADER-2012 CSV Parquet 39,933
2011 PF-P00-T00-HEADER-2011 CSV Parquet 34,597
2010 PF-P00-T00-HEADER-2010 CSV Parquet 25,249
2009 PF-P00-T00-HEADER-2009 CSV Parquet 2,345
Back to contents

P01 Part I - Analysis of Revenue and Expenses

PF-P01-T00-REVENUE-EXPENSE

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

Year Table CSV Parquet Rows
2024 PF-P01-T00-REVENUE-EXPENSE-2024 CSV Parquet 114,820
2023 PF-P01-T00-REVENUE-EXPENSE-2023 CSV Parquet 124,529
2022 PF-P01-T00-REVENUE-EXPENSE-2022 CSV Parquet 122,819
2021 PF-P01-T00-REVENUE-EXPENSE-2021 CSV Parquet 119,354
2020 PF-P01-T00-REVENUE-EXPENSE-2020 CSV Parquet 114,957
2019 PF-P01-T00-REVENUE-EXPENSE-2019 CSV Parquet 87,788
2018 PF-P01-T00-REVENUE-EXPENSE-2018 CSV Parquet 75,540
2017 PF-P01-T00-REVENUE-EXPENSE-2017 CSV Parquet 68,260
2016 PF-P01-T00-REVENUE-EXPENSE-2016 CSV Parquet 62,979
2015 PF-P01-T00-REVENUE-EXPENSE-2015 CSV Parquet 58,815
2014 PF-P01-T00-REVENUE-EXPENSE-2014 CSV Parquet 53,442
2013 PF-P01-T00-REVENUE-EXPENSE-2013 CSV Parquet 45,887
2012 PF-P01-T00-REVENUE-EXPENSE-2012 CSV Parquet 39,933
2011 PF-P01-T00-REVENUE-EXPENSE-2011 CSV Parquet 34,597
2010 PF-P01-T00-REVENUE-EXPENSE-2010 CSV Parquet 25,249
2009 PF-P01-T00-REVENUE-EXPENSE-2009 CSV Parquet 2,345
Back to contents

P02 Part II - Balance Sheets

PF-P02-T00-BALANCE-SHEET

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

Year Table CSV Parquet Rows
2024 PF-P02-T00-BALANCE-SHEET-2024 CSV Parquet 114,820
2023 PF-P02-T00-BALANCE-SHEET-2023 CSV Parquet 124,529
2022 PF-P02-T00-BALANCE-SHEET-2022 CSV Parquet 122,819
2021 PF-P02-T00-BALANCE-SHEET-2021 CSV Parquet 119,354
2020 PF-P02-T00-BALANCE-SHEET-2020 CSV Parquet 114,957
2019 PF-P02-T00-BALANCE-SHEET-2019 CSV Parquet 87,788
2018 PF-P02-T00-BALANCE-SHEET-2018 CSV Parquet 75,540
2017 PF-P02-T00-BALANCE-SHEET-2017 CSV Parquet 68,260
2016 PF-P02-T00-BALANCE-SHEET-2016 CSV Parquet 62,979
2015 PF-P02-T00-BALANCE-SHEET-2015 CSV Parquet 58,815
2014 PF-P02-T00-BALANCE-SHEET-2014 CSV Parquet 53,442
2013 PF-P02-T00-BALANCE-SHEET-2013 CSV Parquet 45,887
2012 PF-P02-T00-BALANCE-SHEET-2012 CSV Parquet 39,933
2011 PF-P02-T00-BALANCE-SHEET-2011 CSV Parquet 34,597
2010 PF-P02-T00-BALANCE-SHEET-2010 CSV Parquet 25,249
2009 PF-P02-T00-BALANCE-SHEET-2009 CSV Parquet 2,345
Back to contents

P03 Part III - Analysis of Changes in Net Assets or Fund Balances

PF-P03-T00-NET-ASSET-FUND-BALANCE-CHANGE

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

Year Table CSV Parquet Rows
2024 PF-P03-T00-NET-ASSET-FUND-BALANCE-CHANGE-2024 CSV Parquet 112,092
2023 PF-P03-T00-NET-ASSET-FUND-BALANCE-CHANGE-2023 CSV Parquet 121,467
2022 PF-P03-T00-NET-ASSET-FUND-BALANCE-CHANGE-2022 CSV Parquet 119,929
2021 PF-P03-T00-NET-ASSET-FUND-BALANCE-CHANGE-2021 CSV Parquet 116,777
2020 PF-P03-T00-NET-ASSET-FUND-BALANCE-CHANGE-2020 CSV Parquet 112,779
2019 PF-P03-T00-NET-ASSET-FUND-BALANCE-CHANGE-2019 CSV Parquet 86,258
2018 PF-P03-T00-NET-ASSET-FUND-BALANCE-CHANGE-2018 CSV Parquet 74,225
2017 PF-P03-T00-NET-ASSET-FUND-BALANCE-CHANGE-2017 CSV Parquet 67,150
2016 PF-P03-T00-NET-ASSET-FUND-BALANCE-CHANGE-2016 CSV Parquet 61,946
2015 PF-P03-T00-NET-ASSET-FUND-BALANCE-CHANGE-2015 CSV Parquet 57,896
2014 PF-P03-T00-NET-ASSET-FUND-BALANCE-CHANGE-2014 CSV Parquet 52,668
2013 PF-P03-T00-NET-ASSET-FUND-BALANCE-CHANGE-2013 CSV Parquet 45,257
2012 PF-P03-T00-NET-ASSET-FUND-BALANCE-CHANGE-2012 CSV Parquet 39,379
2011 PF-P03-T00-NET-ASSET-FUND-BALANCE-CHANGE-2011 CSV Parquet 34,116
2010 PF-P03-T00-NET-ASSET-FUND-BALANCE-CHANGE-2010 CSV Parquet 24,929
2009 PF-P03-T00-NET-ASSET-FUND-BALANCE-CHANGE-2009 CSV Parquet 2,317
Back to contents

P04 Part IV - Capital Gains and Losses for Tax on Investment Income

PF-P04-T00-INVEST-INCOME-TAX-CAPITAL-GAINLOSS

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

Year Table CSV Parquet Rows
2024 PF-P04-T00-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2024 CSV Parquet 68,749
2023 PF-P04-T00-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2023 CSV Parquet 73,338
2022 PF-P04-T00-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2022 CSV Parquet 73,016
2021 PF-P04-T00-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2021 CSV Parquet 73,837
2020 PF-P04-T00-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2020 CSV Parquet 71,991
2019 PF-P04-T00-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2019 CSV Parquet 55,283
2018 PF-P04-T00-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2018 CSV Parquet 46,756
2017 PF-P04-T00-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2017 CSV Parquet 41,320
2016 PF-P04-T00-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2016 CSV Parquet 37,820
2015 PF-P04-T00-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2015 CSV Parquet 35,575
2014 PF-P04-T00-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2014 CSV Parquet 32,621
2013 PF-P04-T00-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2013 CSV Parquet 27,552
2012 PF-P04-T00-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2012 CSV Parquet 23,247
2011 PF-P04-T00-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2011 CSV Parquet 20,381
2010 PF-P04-T00-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2010 CSV Parquet 14,479
2009 PF-P04-T00-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2009 CSV Parquet 1,332
Back to contents

PF-P04-T01-INVEST-INCOME-TAX-CAPITAL-GAINLOSS

1:M many rows per filing · tax years 2009–2024 · 26,692,702 rows · Data dictionary

Year Table CSV Parquet Rows
2024 PF-P04-T01-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2024 CSV Parquet 3,450,256
2023 PF-P04-T01-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2023 CSV Parquet 3,622,672
2022 PF-P04-T01-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2022 CSV Parquet 4,121,444
2021 PF-P04-T01-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2021 CSV Parquet 3,796,237
2020 PF-P04-T01-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2020 CSV Parquet 4,116,608
2019 PF-P04-T01-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2019 CSV Parquet 1,721,232
2018 PF-P04-T01-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2018 CSV Parquet 1,278,045
2017 PF-P04-T01-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2017 CSV Parquet 849,536
2016 PF-P04-T01-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2016 CSV Parquet 789,827
2015 PF-P04-T01-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2015 CSV Parquet 697,521
2014 PF-P04-T01-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2014 CSV Parquet 625,829
2013 PF-P04-T01-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2013 CSV Parquet 467,081
2012 PF-P04-T01-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2012 CSV Parquet 420,578
2011 PF-P04-T01-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2011 CSV Parquet 418,115
2010 PF-P04-T01-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2010 CSV Parquet 289,586
2009 PF-P04-T01-INVEST-INCOME-TAX-CAPITAL-GAINLOSS-2009 CSV Parquet 28,135
Back to contents

P05 Part V - Qualification Under Section 4940(e) for Reduced Tax on Net Investment Income (removed after 2019)

PF-P05-T00-NET-INVEST-INCOME-TAX-4940E

1:1 one row per filing · tax years 2009–2019 · 498,091 rows · Data dictionary

Year Table CSV Parquet Rows
2019 PF-P05-T00-NET-INVEST-INCOME-TAX-4940E-2019 CSV Parquet 78,735
2018 PF-P05-T00-NET-INVEST-INCOME-TAX-4940E-2018 CSV Parquet 67,870
2017 PF-P05-T00-NET-INVEST-INCOME-TAX-4940E-2017 CSV Parquet 61,168
2016 PF-P05-T00-NET-INVEST-INCOME-TAX-4940E-2016 CSV Parquet 56,333
2015 PF-P05-T00-NET-INVEST-INCOME-TAX-4940E-2015 CSV Parquet 52,602
2014 PF-P05-T00-NET-INVEST-INCOME-TAX-4940E-2014 CSV Parquet 47,907
2013 PF-P05-T00-NET-INVEST-INCOME-TAX-4940E-2013 CSV Parquet 41,241
2012 PF-P05-T00-NET-INVEST-INCOME-TAX-4940E-2012 CSV Parquet 35,968
2011 PF-P05-T00-NET-INVEST-INCOME-TAX-4940E-2011 CSV Parquet 31,196
2010 PF-P05-T00-NET-INVEST-INCOME-TAX-4940E-2010 CSV Parquet 22,919
2009 PF-P05-T00-NET-INVEST-INCOME-TAX-4940E-2009 CSV Parquet 2,152
Back to contents

P06 Part VI - Excise Tax Based on Investment Income (2023: Part V)

PF-P06-T00-INVEST-INCOME-EXCISE-TAX

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

Year Table CSV Parquet Rows
2024 PF-P06-T00-INVEST-INCOME-EXCISE-TAX-2024 CSV Parquet 113,673
2023 PF-P06-T00-INVEST-INCOME-EXCISE-TAX-2023 CSV Parquet 123,190
2022 PF-P06-T00-INVEST-INCOME-EXCISE-TAX-2022 CSV Parquet 121,483
2021 PF-P06-T00-INVEST-INCOME-EXCISE-TAX-2021 CSV Parquet 117,641
2020 PF-P06-T00-INVEST-INCOME-EXCISE-TAX-2020 CSV Parquet 114,874
2019 PF-P06-T00-INVEST-INCOME-EXCISE-TAX-2019 CSV Parquet 87,788
2018 PF-P06-T00-INVEST-INCOME-EXCISE-TAX-2018 CSV Parquet 75,540
2017 PF-P06-T00-INVEST-INCOME-EXCISE-TAX-2017 CSV Parquet 68,260
2016 PF-P06-T00-INVEST-INCOME-EXCISE-TAX-2016 CSV Parquet 62,979
2015 PF-P06-T00-INVEST-INCOME-EXCISE-TAX-2015 CSV Parquet 58,815
2014 PF-P06-T00-INVEST-INCOME-EXCISE-TAX-2014 CSV Parquet 53,442
2013 PF-P06-T00-INVEST-INCOME-EXCISE-TAX-2013 CSV Parquet 45,887
2012 PF-P06-T00-INVEST-INCOME-EXCISE-TAX-2012 CSV Parquet 39,933
2011 PF-P06-T00-INVEST-INCOME-EXCISE-TAX-2011 CSV Parquet 34,597
2010 PF-P06-T00-INVEST-INCOME-EXCISE-TAX-2010 CSV Parquet 25,249
2009 PF-P06-T00-INVEST-INCOME-EXCISE-TAX-2009 CSV Parquet 2,345
Back to contents

P07 Part VII-A - Statements Regarding Activities; Part VII-B - Activities for Which Form 4720 May Be Required (2023: Part VI-A, VI-B)

PF-P07-T00-ACTIVITIES

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

Year Table CSV Parquet Rows
2024 PF-P07-T00-ACTIVITIES-2024 CSV Parquet 114,820
2023 PF-P07-T00-ACTIVITIES-2023 CSV Parquet 124,528
2022 PF-P07-T00-ACTIVITIES-2022 CSV Parquet 122,818
2021 PF-P07-T00-ACTIVITIES-2021 CSV Parquet 119,354
2020 PF-P07-T00-ACTIVITIES-2020 CSV Parquet 114,957
2019 PF-P07-T00-ACTIVITIES-2019 CSV Parquet 87,788
2018 PF-P07-T00-ACTIVITIES-2018 CSV Parquet 75,540
2017 PF-P07-T00-ACTIVITIES-2017 CSV Parquet 68,260
2016 PF-P07-T00-ACTIVITIES-2016 CSV Parquet 62,979
2015 PF-P07-T00-ACTIVITIES-2015 CSV Parquet 58,815
2014 PF-P07-T00-ACTIVITIES-2014 CSV Parquet 53,442
2013 PF-P07-T00-ACTIVITIES-2013 CSV Parquet 45,887
2012 PF-P07-T00-ACTIVITIES-2012 CSV Parquet 39,933
2011 PF-P07-T00-ACTIVITIES-2011 CSV Parquet 34,597
2010 PF-P07-T00-ACTIVITIES-2010 CSV Parquet 25,249
2009 PF-P07-T00-ACTIVITIES-2009 CSV Parquet 2,345
Back to contents

PF-P07-T00-ACTIVITIES-4720

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

Year Table CSV Parquet Rows
2024 PF-P07-T00-ACTIVITIES-4720-2024 CSV Parquet 114,366
2023 PF-P07-T00-ACTIVITIES-4720-2023 CSV Parquet 122,529
2022 PF-P07-T00-ACTIVITIES-4720-2022 CSV Parquet 121,109
2021 PF-P07-T00-ACTIVITIES-4720-2021 CSV Parquet 117,865
2020 PF-P07-T00-ACTIVITIES-4720-2020 CSV Parquet 113,431
2019 PF-P07-T00-ACTIVITIES-4720-2019 CSV Parquet 86,543
2018 PF-P07-T00-ACTIVITIES-4720-2018 CSV Parquet 74,451
2017 PF-P07-T00-ACTIVITIES-4720-2017 CSV Parquet 67,115
2016 PF-P07-T00-ACTIVITIES-4720-2016 CSV Parquet 62,218
2015 PF-P07-T00-ACTIVITIES-4720-2015 CSV Parquet 58,259
2014 PF-P07-T00-ACTIVITIES-4720-2014 CSV Parquet 53,000
2013 PF-P07-T00-ACTIVITIES-4720-2013 CSV Parquet 45,588
2012 PF-P07-T00-ACTIVITIES-4720-2012 CSV Parquet 39,688
2011 PF-P07-T00-ACTIVITIES-4720-2011 CSV Parquet 34,348
2010 PF-P07-T00-ACTIVITIES-4720-2010 CSV Parquet 25,184
2009 PF-P07-T00-ACTIVITIES-4720-2009 CSV Parquet 2,342
Back to contents

P08 Part VIII - Information About Officers, Directors, Trustees, Foundation Managers, Highly Paid Employees, and Contractors (2023: Part VII)

PF-P08-T00-COMPENSATION-CONTRACTORS

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

Year Table CSV Parquet Rows
2024 PF-P08-T00-COMPENSATION-CONTRACTORS-2024 CSV Parquet 105,544
2023 PF-P08-T00-COMPENSATION-CONTRACTORS-2023 CSV Parquet 110,041
2022 PF-P08-T00-COMPENSATION-CONTRACTORS-2022 CSV Parquet 109,100
2021 PF-P08-T00-COMPENSATION-CONTRACTORS-2021 CSV Parquet 105,038
2020 PF-P08-T00-COMPENSATION-CONTRACTORS-2020 CSV Parquet 102,549
2019 PF-P08-T00-COMPENSATION-CONTRACTORS-2019 CSV Parquet 79,309
2018 PF-P08-T00-COMPENSATION-CONTRACTORS-2018 CSV Parquet 68,402
2017 PF-P08-T00-COMPENSATION-CONTRACTORS-2017 CSV Parquet 61,578
2016 PF-P08-T00-COMPENSATION-CONTRACTORS-2016 CSV Parquet 56,609
2015 PF-P08-T00-COMPENSATION-CONTRACTORS-2015 CSV Parquet 53,029
2014 PF-P08-T00-COMPENSATION-CONTRACTORS-2014 CSV Parquet 48,112
2013 PF-P08-T00-COMPENSATION-CONTRACTORS-2013 CSV Parquet 41,306
2012 PF-P08-T00-COMPENSATION-CONTRACTORS-2012 CSV Parquet 35,046
2011 PF-P08-T00-COMPENSATION-CONTRACTORS-2011 CSV Parquet 31,326
2010 PF-P08-T00-COMPENSATION-CONTRACTORS-2010 CSV Parquet 22,787
2009 PF-P08-T00-COMPENSATION-CONTRACTORS-2009 CSV Parquet 2,167
Back to contents

PF-P08-T00-COMPENSATION-HIGHEST

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

Year Table CSV Parquet Rows
2024 PF-P08-T00-COMPENSATION-HIGHEST-2024 CSV Parquet 105,120
2023 PF-P08-T00-COMPENSATION-HIGHEST-2023 CSV Parquet 109,784
2022 PF-P08-T00-COMPENSATION-HIGHEST-2022 CSV Parquet 109,154
2021 PF-P08-T00-COMPENSATION-HIGHEST-2021 CSV Parquet 104,988
2020 PF-P08-T00-COMPENSATION-HIGHEST-2020 CSV Parquet 102,421
2019 PF-P08-T00-COMPENSATION-HIGHEST-2019 CSV Parquet 79,242
2018 PF-P08-T00-COMPENSATION-HIGHEST-2018 CSV Parquet 68,389
2017 PF-P08-T00-COMPENSATION-HIGHEST-2017 CSV Parquet 61,570
2016 PF-P08-T00-COMPENSATION-HIGHEST-2016 CSV Parquet 56,637
2015 PF-P08-T00-COMPENSATION-HIGHEST-2015 CSV Parquet 53,142
2014 PF-P08-T00-COMPENSATION-HIGHEST-2014 CSV Parquet 48,255
2013 PF-P08-T00-COMPENSATION-HIGHEST-2013 CSV Parquet 41,450
2012 PF-P08-T00-COMPENSATION-HIGHEST-2012 CSV Parquet 36,074
2011 PF-P08-T00-COMPENSATION-HIGHEST-2011 CSV Parquet 31,783
2010 PF-P08-T00-COMPENSATION-HIGHEST-2010 CSV Parquet 23,248
2009 PF-P08-T00-COMPENSATION-HIGHEST-2009 CSV Parquet 2,166
Back to contents

PF-P08-T01-COMPENSATION

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

Year Table CSV Parquet Rows
2024 PF-P08-T01-COMPENSATION-2024 CSV Parquet 367,283
2023 PF-P08-T01-COMPENSATION-2023 CSV Parquet 400,385
2022 PF-P08-T01-COMPENSATION-2022 CSV Parquet 395,598
2021 PF-P08-T01-COMPENSATION-2021 CSV Parquet 384,572
2020 PF-P08-T01-COMPENSATION-2020 CSV Parquet 370,946
2019 PF-P08-T01-COMPENSATION-2019 CSV Parquet 280,145
2018 PF-P08-T01-COMPENSATION-2018 CSV Parquet 241,355
2017 PF-P08-T01-COMPENSATION-2017 CSV Parquet 223,180
2016 PF-P08-T01-COMPENSATION-2016 CSV Parquet 207,801
2015 PF-P08-T01-COMPENSATION-2015 CSV Parquet 194,046
2014 PF-P08-T01-COMPENSATION-2014 CSV Parquet 175,819
2013 PF-P08-T01-COMPENSATION-2013 CSV Parquet 153,025
2012 PF-P08-T01-COMPENSATION-2012 CSV Parquet 133,519
2011 PF-P08-T01-COMPENSATION-2011 CSV Parquet 112,718
2010 PF-P08-T01-COMPENSATION-2010 CSV Parquet 82,055
2009 PF-P08-T01-COMPENSATION-2009 CSV Parquet 8,941
Back to contents

PF-P08-T02-COMPENSATION-HIGHEST

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

Year Table CSV Parquet Rows
2024 PF-P08-T02-COMPENSATION-HIGHEST-2024 CSV Parquet 7,943
2023 PF-P08-T02-COMPENSATION-HIGHEST-2023 CSV Parquet 8,531
2022 PF-P08-T02-COMPENSATION-HIGHEST-2022 CSV Parquet 8,179
2021 PF-P08-T02-COMPENSATION-HIGHEST-2021 CSV Parquet 7,842
2020 PF-P08-T02-COMPENSATION-HIGHEST-2020 CSV Parquet 7,463
2019 PF-P08-T02-COMPENSATION-HIGHEST-2019 CSV Parquet 4,984
2018 PF-P08-T02-COMPENSATION-HIGHEST-2018 CSV Parquet 3,765
2017 PF-P08-T02-COMPENSATION-HIGHEST-2017 CSV Parquet 3,213
2016 PF-P08-T02-COMPENSATION-HIGHEST-2016 CSV Parquet 2,860
2015 PF-P08-T02-COMPENSATION-HIGHEST-2015 CSV Parquet 2,596
2014 PF-P08-T02-COMPENSATION-HIGHEST-2014 CSV Parquet 2,207
2013 PF-P08-T02-COMPENSATION-HIGHEST-2013 CSV Parquet 2,974
2012 PF-P08-T02-COMPENSATION-HIGHEST-2012 CSV Parquet 1,557
2011 PF-P08-T02-COMPENSATION-HIGHEST-2011 CSV Parquet 1,238
2010 PF-P08-T02-COMPENSATION-HIGHEST-2010 CSV Parquet 1,008
2009 PF-P08-T02-COMPENSATION-HIGHEST-2009 CSV Parquet 212
Back to contents

PF-P08-T03-COMPENSATION-CONTRACTORS

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

Year Table CSV Parquet Rows
2024 PF-P08-T03-COMPENSATION-CONTRACTORS-2024 CSV Parquet 10,804
2023 PF-P08-T03-COMPENSATION-CONTRACTORS-2023 CSV Parquet 11,225
2022 PF-P08-T03-COMPENSATION-CONTRACTORS-2022 CSV Parquet 10,702
2021 PF-P08-T03-COMPENSATION-CONTRACTORS-2021 CSV Parquet 9,990
2020 PF-P08-T03-COMPENSATION-CONTRACTORS-2020 CSV Parquet 9,074
2019 PF-P08-T03-COMPENSATION-CONTRACTORS-2019 CSV Parquet 5,863
2018 PF-P08-T03-COMPENSATION-CONTRACTORS-2018 CSV Parquet 4,207
2017 PF-P08-T03-COMPENSATION-CONTRACTORS-2017 CSV Parquet 3,667
2016 PF-P08-T03-COMPENSATION-CONTRACTORS-2016 CSV Parquet 3,209
2015 PF-P08-T03-COMPENSATION-CONTRACTORS-2015 CSV Parquet 2,891
2014 PF-P08-T03-COMPENSATION-CONTRACTORS-2014 CSV Parquet 2,496
2013 PF-P08-T03-COMPENSATION-CONTRACTORS-2013 CSV Parquet 1,981
2012 PF-P08-T03-COMPENSATION-CONTRACTORS-2012 CSV Parquet 1,592
2011 PF-P08-T03-COMPENSATION-CONTRACTORS-2011 CSV Parquet 1,328
2010 PF-P08-T03-COMPENSATION-CONTRACTORS-2010 CSV Parquet 946
2009 PF-P08-T03-COMPENSATION-CONTRACTORS-2009 CSV Parquet 192
Back to contents

P09 Part IX-A - Summary of Direct Charitable Activities; Part IX-B - Summary of Program-Related Investments (2023: Part VIII-A, VIII-B)

PF-P09-T01-CHARITABLE-ACTIVITIES

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

Year Table CSV Parquet Rows
2024 PF-P09-T01-CHARITABLE-ACTIVITIES-2024 CSV Parquet 32,844
2023 PF-P09-T01-CHARITABLE-ACTIVITIES-2023 CSV Parquet 36,217
2022 PF-P09-T01-CHARITABLE-ACTIVITIES-2022 CSV Parquet 35,613
2021 PF-P09-T01-CHARITABLE-ACTIVITIES-2021 CSV Parquet 34,823
2020 PF-P09-T01-CHARITABLE-ACTIVITIES-2020 CSV Parquet 33,762
2019 PF-P09-T01-CHARITABLE-ACTIVITIES-2019 CSV Parquet 24,996
2018 PF-P09-T01-CHARITABLE-ACTIVITIES-2018 CSV Parquet 21,048
2017 PF-P09-T01-CHARITABLE-ACTIVITIES-2017 CSV Parquet 19,941
2016 PF-P09-T01-CHARITABLE-ACTIVITIES-2016 CSV Parquet 18,702
2015 PF-P09-T01-CHARITABLE-ACTIVITIES-2015 CSV Parquet 16,808
2014 PF-P09-T01-CHARITABLE-ACTIVITIES-2014 CSV Parquet 15,304
2013 PF-P09-T01-CHARITABLE-ACTIVITIES-2013 CSV Parquet 15,116
2012 PF-P09-T01-CHARITABLE-ACTIVITIES-2012 CSV Parquet 13,341
2011 PF-P09-T01-CHARITABLE-ACTIVITIES-2011 CSV Parquet 11,381
2010 PF-P09-T01-CHARITABLE-ACTIVITIES-2010 CSV Parquet 7,954
2009 PF-P09-T01-CHARITABLE-ACTIVITIES-2009 CSV Parquet 867
Back to contents

P10 Part X - Minimum Investment Return (2023: Part IX)

PF-P10-T00-MINIMUM-INVESTMENT-RETURN

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

Year Table CSV Parquet Rows
2024 PF-P10-T00-MINIMUM-INVESTMENT-RETURN-2024 CSV Parquet 112,697
2023 PF-P10-T00-MINIMUM-INVESTMENT-RETURN-2023 CSV Parquet 122,141
2022 PF-P10-T00-MINIMUM-INVESTMENT-RETURN-2022 CSV Parquet 120,701
2021 PF-P10-T00-MINIMUM-INVESTMENT-RETURN-2021 CSV Parquet 117,262
2020 PF-P10-T00-MINIMUM-INVESTMENT-RETURN-2020 CSV Parquet 113,056
2019 PF-P10-T00-MINIMUM-INVESTMENT-RETURN-2019 CSV Parquet 86,464
2018 PF-P10-T00-MINIMUM-INVESTMENT-RETURN-2018 CSV Parquet 74,470
2017 PF-P10-T00-MINIMUM-INVESTMENT-RETURN-2017 CSV Parquet 67,271
2016 PF-P10-T00-MINIMUM-INVESTMENT-RETURN-2016 CSV Parquet 62,207
2015 PF-P10-T00-MINIMUM-INVESTMENT-RETURN-2015 CSV Parquet 58,234
2014 PF-P10-T00-MINIMUM-INVESTMENT-RETURN-2014 CSV Parquet 52,961
2013 PF-P10-T00-MINIMUM-INVESTMENT-RETURN-2013 CSV Parquet 45,514
2012 PF-P10-T00-MINIMUM-INVESTMENT-RETURN-2012 CSV Parquet 39,614
2011 PF-P10-T00-MINIMUM-INVESTMENT-RETURN-2011 CSV Parquet 34,329
2010 PF-P10-T00-MINIMUM-INVESTMENT-RETURN-2010 CSV Parquet 25,109
2009 PF-P10-T00-MINIMUM-INVESTMENT-RETURN-2009 CSV Parquet 2,339
Back to contents

P11 Part XI - Distributable Amount (2023: Part X)

PF-P11-T00-DISTRIBUTABLE-AMOUNT

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

Year Table CSV Parquet Rows
2024 PF-P11-T00-DISTRIBUTABLE-AMOUNT-2024 CSV Parquet 114,810
2023 PF-P11-T00-DISTRIBUTABLE-AMOUNT-2023 CSV Parquet 124,494
2022 PF-P11-T00-DISTRIBUTABLE-AMOUNT-2022 CSV Parquet 122,781
2021 PF-P11-T00-DISTRIBUTABLE-AMOUNT-2021 CSV Parquet 119,332
2020 PF-P11-T00-DISTRIBUTABLE-AMOUNT-2020 CSV Parquet 114,935
2019 PF-P11-T00-DISTRIBUTABLE-AMOUNT-2019 CSV Parquet 87,775
2018 PF-P11-T00-DISTRIBUTABLE-AMOUNT-2018 CSV Parquet 75,528
2017 PF-P11-T00-DISTRIBUTABLE-AMOUNT-2017 CSV Parquet 68,249
2016 PF-P11-T00-DISTRIBUTABLE-AMOUNT-2016 CSV Parquet 62,974
2015 PF-P11-T00-DISTRIBUTABLE-AMOUNT-2015 CSV Parquet 58,808
2014 PF-P11-T00-DISTRIBUTABLE-AMOUNT-2014 CSV Parquet 53,436
2013 PF-P11-T00-DISTRIBUTABLE-AMOUNT-2013 CSV Parquet 45,885
2012 PF-P11-T00-DISTRIBUTABLE-AMOUNT-2012 CSV Parquet 39,933
2011 PF-P11-T00-DISTRIBUTABLE-AMOUNT-2011 CSV Parquet 34,596
2010 PF-P11-T00-DISTRIBUTABLE-AMOUNT-2010 CSV Parquet 25,249
2009 PF-P11-T00-DISTRIBUTABLE-AMOUNT-2009 CSV Parquet 2,345
Back to contents

P12 Part XII - Qualifying Distributions (2023: Part XI)

PF-P12-T00-QUALIFYING-DISTRIBUTIONS

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

Year Table CSV Parquet Rows
2024 PF-P12-T00-QUALIFYING-DISTRIBUTIONS-2024 CSV Parquet 114,814
2023 PF-P12-T00-QUALIFYING-DISTRIBUTIONS-2023 CSV Parquet 124,523
2022 PF-P12-T00-QUALIFYING-DISTRIBUTIONS-2022 CSV Parquet 122,813
2021 PF-P12-T00-QUALIFYING-DISTRIBUTIONS-2021 CSV Parquet 119,350
2020 PF-P12-T00-QUALIFYING-DISTRIBUTIONS-2020 CSV Parquet 114,956
2019 PF-P12-T00-QUALIFYING-DISTRIBUTIONS-2019 CSV Parquet 87,788
2018 PF-P12-T00-QUALIFYING-DISTRIBUTIONS-2018 CSV Parquet 75,540
2017 PF-P12-T00-QUALIFYING-DISTRIBUTIONS-2017 CSV Parquet 68,260
2016 PF-P12-T00-QUALIFYING-DISTRIBUTIONS-2016 CSV Parquet 62,979
2015 PF-P12-T00-QUALIFYING-DISTRIBUTIONS-2015 CSV Parquet 58,814
2014 PF-P12-T00-QUALIFYING-DISTRIBUTIONS-2014 CSV Parquet 53,441
2013 PF-P12-T00-QUALIFYING-DISTRIBUTIONS-2013 CSV Parquet 45,884
2012 PF-P12-T00-QUALIFYING-DISTRIBUTIONS-2012 CSV Parquet 39,933
2011 PF-P12-T00-QUALIFYING-DISTRIBUTIONS-2011 CSV Parquet 34,597
2010 PF-P12-T00-QUALIFYING-DISTRIBUTIONS-2010 CSV Parquet 25,249
2009 PF-P12-T00-QUALIFYING-DISTRIBUTIONS-2009 CSV Parquet 2,345
Back to contents

P13 Part XIII - Undistributed Income (2023: Part XII)

PF-P13-T00-UNDISTRIBUTED-INCOME

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

Year Table CSV Parquet Rows
2024 PF-P13-T00-UNDISTRIBUTED-INCOME-2024 CSV Parquet 107,852
2023 PF-P13-T00-UNDISTRIBUTED-INCOME-2023 CSV Parquet 117,397
2022 PF-P13-T00-UNDISTRIBUTED-INCOME-2022 CSV Parquet 116,041
2021 PF-P13-T00-UNDISTRIBUTED-INCOME-2021 CSV Parquet 113,003
2020 PF-P13-T00-UNDISTRIBUTED-INCOME-2020 CSV Parquet 109,149
2019 PF-P13-T00-UNDISTRIBUTED-INCOME-2019 CSV Parquet 83,364
2018 PF-P13-T00-UNDISTRIBUTED-INCOME-2018 CSV Parquet 71,909
2017 PF-P13-T00-UNDISTRIBUTED-INCOME-2017 CSV Parquet 64,923
2016 PF-P13-T00-UNDISTRIBUTED-INCOME-2016 CSV Parquet 59,822
2015 PF-P13-T00-UNDISTRIBUTED-INCOME-2015 CSV Parquet 55,804
2014 PF-P13-T00-UNDISTRIBUTED-INCOME-2014 CSV Parquet 50,766
2013 PF-P13-T00-UNDISTRIBUTED-INCOME-2013 CSV Parquet 43,576
2012 PF-P13-T00-UNDISTRIBUTED-INCOME-2012 CSV Parquet 37,891
2011 PF-P13-T00-UNDISTRIBUTED-INCOME-2011 CSV Parquet 32,944
2010 PF-P13-T00-UNDISTRIBUTED-INCOME-2010 CSV Parquet 23,965
2009 PF-P13-T00-UNDISTRIBUTED-INCOME-2009 CSV Parquet 2,264
Back to contents

P14 Part XIV - Private Operating Foundations (2023: Part XIII)

PF-P14-T00-PRIVATE-OPERATING-FOUNDATIONS

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

Year Table CSV Parquet Rows
2024 PF-P14-T00-PRIVATE-OPERATING-FOUNDATIONS-2024 CSV Parquet 12,772
2023 PF-P14-T00-PRIVATE-OPERATING-FOUNDATIONS-2023 CSV Parquet 13,920
2022 PF-P14-T00-PRIVATE-OPERATING-FOUNDATIONS-2022 CSV Parquet 13,327
2021 PF-P14-T00-PRIVATE-OPERATING-FOUNDATIONS-2021 CSV Parquet 12,783
2020 PF-P14-T00-PRIVATE-OPERATING-FOUNDATIONS-2020 CSV Parquet 12,043
2019 PF-P14-T00-PRIVATE-OPERATING-FOUNDATIONS-2019 CSV Parquet 8,510
2018 PF-P14-T00-PRIVATE-OPERATING-FOUNDATIONS-2018 CSV Parquet 6,893
2017 PF-P14-T00-PRIVATE-OPERATING-FOUNDATIONS-2017 CSV Parquet 6,485
2016 PF-P14-T00-PRIVATE-OPERATING-FOUNDATIONS-2016 CSV Parquet 5,915
2015 PF-P14-T00-PRIVATE-OPERATING-FOUNDATIONS-2015 CSV Parquet 5,525
2014 PF-P14-T00-PRIVATE-OPERATING-FOUNDATIONS-2014 CSV Parquet 4,782
2013 PF-P14-T00-PRIVATE-OPERATING-FOUNDATIONS-2013 CSV Parquet 4,101
2012 PF-P14-T00-PRIVATE-OPERATING-FOUNDATIONS-2012 CSV Parquet 3,623
2011 PF-P14-T00-PRIVATE-OPERATING-FOUNDATIONS-2011 CSV Parquet 3,006
2010 PF-P14-T00-PRIVATE-OPERATING-FOUNDATIONS-2010 CSV Parquet 2,164
2009 PF-P14-T00-PRIVATE-OPERATING-FOUNDATIONS-2009 CSV Parquet 231
Back to contents

P15 Part XV - Supplementary Information (2023: Part XIV)

PF-P15-T00-SUPPLEMENTARY-INFO

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

Year Table CSV Parquet Rows
2024 PF-P15-T00-SUPPLEMENTARY-INFO-2024 CSV Parquet 90,895
2023 PF-P15-T00-SUPPLEMENTARY-INFO-2023 CSV Parquet 98,001
2022 PF-P15-T00-SUPPLEMENTARY-INFO-2022 CSV Parquet 97,170
2021 PF-P15-T00-SUPPLEMENTARY-INFO-2021 CSV Parquet 94,969
2020 PF-P15-T00-SUPPLEMENTARY-INFO-2020 CSV Parquet 91,875
2019 PF-P15-T00-SUPPLEMENTARY-INFO-2019 CSV Parquet 71,119
2018 PF-P15-T00-SUPPLEMENTARY-INFO-2018 CSV Parquet 61,250
2017 PF-P15-T00-SUPPLEMENTARY-INFO-2017 CSV Parquet 54,949
2016 PF-P15-T00-SUPPLEMENTARY-INFO-2016 CSV Parquet 50,660
2015 PF-P15-T00-SUPPLEMENTARY-INFO-2015 CSV Parquet 47,363
2014 PF-P15-T00-SUPPLEMENTARY-INFO-2014 CSV Parquet 43,049
2013 PF-P15-T00-SUPPLEMENTARY-INFO-2013 CSV Parquet 36,883
2012 PF-P15-T00-SUPPLEMENTARY-INFO-2012 CSV Parquet 31,989
2011 PF-P15-T00-SUPPLEMENTARY-INFO-2011 CSV Parquet 27,636
2010 PF-P15-T00-SUPPLEMENTARY-INFO-2010 CSV Parquet 20,143
2009 PF-P15-T00-SUPPLEMENTARY-INFO-2009 CSV Parquet 1,817
Back to contents

PF-P15-T03-SUPPLEMENTARY-INFO-GRANT-APP

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

Year Table CSV Parquet Rows
2024 PF-P15-T03-SUPPLEMENTARY-INFO-GRANT-APP-2024 CSV Parquet 27,397
2023 PF-P15-T03-SUPPLEMENTARY-INFO-GRANT-APP-2023 CSV Parquet 30,067
2022 PF-P15-T03-SUPPLEMENTARY-INFO-GRANT-APP-2022 CSV Parquet 30,518
2021 PF-P15-T03-SUPPLEMENTARY-INFO-GRANT-APP-2021 CSV Parquet 30,406
2020 PF-P15-T03-SUPPLEMENTARY-INFO-GRANT-APP-2020 CSV Parquet 30,136
2019 PF-P15-T03-SUPPLEMENTARY-INFO-GRANT-APP-2019 CSV Parquet 22,903
2018 PF-P15-T03-SUPPLEMENTARY-INFO-GRANT-APP-2018 CSV Parquet 19,904
2017 PF-P15-T03-SUPPLEMENTARY-INFO-GRANT-APP-2017 CSV Parquet 18,753
2016 PF-P15-T03-SUPPLEMENTARY-INFO-GRANT-APP-2016 CSV Parquet 17,549
2015 PF-P15-T03-SUPPLEMENTARY-INFO-GRANT-APP-2015 CSV Parquet 16,566
2014 PF-P15-T03-SUPPLEMENTARY-INFO-GRANT-APP-2014 CSV Parquet 15,275
2013 PF-P15-T03-SUPPLEMENTARY-INFO-GRANT-APP-2013 CSV Parquet 13,520
2012 PF-P15-T03-SUPPLEMENTARY-INFO-GRANT-APP-2012 CSV Parquet 11,962
2011 PF-P15-T03-SUPPLEMENTARY-INFO-GRANT-APP-2011 CSV Parquet 10,338
2010 PF-P15-T03-SUPPLEMENTARY-INFO-GRANT-APP-2010 CSV Parquet 7,743
2009 PF-P15-T03-SUPPLEMENTARY-INFO-GRANT-APP-2009 CSV Parquet 816
Back to contents

PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-FUTURE

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

Year Table CSV Parquet Rows
2024 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-FUTURE-2024 CSV Parquet 48,997
2023 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-FUTURE-2023 CSV Parquet 51,683
2022 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-FUTURE-2022 CSV Parquet 50,564
2021 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-FUTURE-2021 CSV Parquet 49,352
2020 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-FUTURE-2020 CSV Parquet 47,429
2019 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-FUTURE-2019 CSV Parquet 36,113
2018 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-FUTURE-2018 CSV Parquet 31,447
2017 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-FUTURE-2017 CSV Parquet 29,168
2016 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-FUTURE-2016 CSV Parquet 26,767
2015 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-FUTURE-2015 CSV Parquet 24,801
2014 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-FUTURE-2014 CSV Parquet 22,602
2013 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-FUTURE-2013 CSV Parquet 21,580
2012 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-FUTURE-2012 CSV Parquet 17,820
2011 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-FUTURE-2011 CSV Parquet 15,674
2010 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-FUTURE-2010 CSV Parquet 11,516
2009 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-FUTURE-2009 CSV Parquet 1,287
Back to contents

PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-PAID

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

Year Table CSV Parquet Rows
2024 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-PAID-2024 CSV Parquet 98,280
2023 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-PAID-2023 CSV Parquet 105,525
2022 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-PAID-2022 CSV Parquet 105,449
2021 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-PAID-2021 CSV Parquet 103,346
2020 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-PAID-2020 CSV Parquet 100,977
2019 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-PAID-2019 CSV Parquet 78,152
2018 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-PAID-2018 CSV Parquet 67,417
2017 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-PAID-2017 CSV Parquet 60,776
2016 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-PAID-2016 CSV Parquet 56,087
2015 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-PAID-2015 CSV Parquet 52,514
2014 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-PAID-2014 CSV Parquet 48,138
2013 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-PAID-2013 CSV Parquet 41,192
2012 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-PAID-2012 CSV Parquet 35,434
2011 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-PAID-2011 CSV Parquet 30,872
2010 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-PAID-2010 CSV Parquet 22,626
2009 PF-P15-T00-SUPPLEMENTARY-INFO-GRANT-PAID-2009 CSV Parquet 2,124
Back to contents

PF-P15-T01-SUPPLEMENTARY-INFO-GRANT-PAID

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

Year Table CSV Parquet Rows
2024 PF-P15-T01-SUPPLEMENTARY-INFO-GRANT-PAID-2024 CSV Parquet 1,463,063
2023 PF-P15-T01-SUPPLEMENTARY-INFO-GRANT-PAID-2023 CSV Parquet 2,035,127
2022 PF-P15-T01-SUPPLEMENTARY-INFO-GRANT-PAID-2022 CSV Parquet 2,051,577
2021 PF-P15-T01-SUPPLEMENTARY-INFO-GRANT-PAID-2021 CSV Parquet 2,031,798
2020 PF-P15-T01-SUPPLEMENTARY-INFO-GRANT-PAID-2020 CSV Parquet 1,962,611
2019 PF-P15-T01-SUPPLEMENTARY-INFO-GRANT-PAID-2019 CSV Parquet 1,151,963
2018 PF-P15-T01-SUPPLEMENTARY-INFO-GRANT-PAID-2018 CSV Parquet 944,731
2017 PF-P15-T01-SUPPLEMENTARY-INFO-GRANT-PAID-2017 CSV Parquet 864,906
2016 PF-P15-T01-SUPPLEMENTARY-INFO-GRANT-PAID-2016 CSV Parquet 797,022
2015 PF-P15-T01-SUPPLEMENTARY-INFO-GRANT-PAID-2015 CSV Parquet 790,979
2014 PF-P15-T01-SUPPLEMENTARY-INFO-GRANT-PAID-2014 CSV Parquet 711,162
2013 PF-P15-T01-SUPPLEMENTARY-INFO-GRANT-PAID-2013 CSV Parquet 613,008
2012 PF-P15-T01-SUPPLEMENTARY-INFO-GRANT-PAID-2012 CSV Parquet 559,962
2011 PF-P15-T01-SUPPLEMENTARY-INFO-GRANT-PAID-2011 CSV Parquet 409,242
2010 PF-P15-T01-SUPPLEMENTARY-INFO-GRANT-PAID-2010 CSV Parquet 301,258
2009 PF-P15-T01-SUPPLEMENTARY-INFO-GRANT-PAID-2009 CSV Parquet 34,933
Back to contents

PF-P15-T02-SUPPLEMENTARY-INFO-GRANT-FUTURE

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

Year Table CSV Parquet Rows
2024 PF-P15-T02-SUPPLEMENTARY-INFO-GRANT-FUTURE-2024 CSV Parquet 47,572
2023 PF-P15-T02-SUPPLEMENTARY-INFO-GRANT-FUTURE-2023 CSV Parquet 52,132
2022 PF-P15-T02-SUPPLEMENTARY-INFO-GRANT-FUTURE-2022 CSV Parquet 51,349
2021 PF-P15-T02-SUPPLEMENTARY-INFO-GRANT-FUTURE-2021 CSV Parquet 48,712
2020 PF-P15-T02-SUPPLEMENTARY-INFO-GRANT-FUTURE-2020 CSV Parquet 47,076
2019 PF-P15-T02-SUPPLEMENTARY-INFO-GRANT-FUTURE-2019 CSV Parquet 31,663
2018 PF-P15-T02-SUPPLEMENTARY-INFO-GRANT-FUTURE-2018 CSV Parquet 22,979
2017 PF-P15-T02-SUPPLEMENTARY-INFO-GRANT-FUTURE-2017 CSV Parquet 21,148
2016 PF-P15-T02-SUPPLEMENTARY-INFO-GRANT-FUTURE-2016 CSV Parquet 21,360
2015 PF-P15-T02-SUPPLEMENTARY-INFO-GRANT-FUTURE-2015 CSV Parquet 21,740
2014 PF-P15-T02-SUPPLEMENTARY-INFO-GRANT-FUTURE-2014 CSV Parquet 18,861
2013 PF-P15-T02-SUPPLEMENTARY-INFO-GRANT-FUTURE-2013 CSV Parquet 17,351
2012 PF-P15-T02-SUPPLEMENTARY-INFO-GRANT-FUTURE-2012 CSV Parquet 23,432
2011 PF-P15-T02-SUPPLEMENTARY-INFO-GRANT-FUTURE-2011 CSV Parquet 15,219
2010 PF-P15-T02-SUPPLEMENTARY-INFO-GRANT-FUTURE-2010 CSV Parquet 11,275
2009 PF-P15-T02-SUPPLEMENTARY-INFO-GRANT-FUTURE-2009 CSV Parquet 3,846
Back to contents

P16 Part XVI-A - Analysis of Income-Producing Activities; Part XVI-B - Relationship of Activities to the Accomplishment of Exempt Purposes (2023: Part XV)

PF-P16-T00-INCOME-PRODUCING-ACTS

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

Year Table CSV Parquet Rows
2024 PF-P16-T00-INCOME-PRODUCING-ACTS-2024 CSV Parquet 101,056
2023 PF-P16-T00-INCOME-PRODUCING-ACTS-2023 CSV Parquet 108,661
2022 PF-P16-T00-INCOME-PRODUCING-ACTS-2022 CSV Parquet 107,297
2021 PF-P16-T00-INCOME-PRODUCING-ACTS-2021 CSV Parquet 104,607
2020 PF-P16-T00-INCOME-PRODUCING-ACTS-2020 CSV Parquet 101,977
2019 PF-P16-T00-INCOME-PRODUCING-ACTS-2019 CSV Parquet 78,418
2018 PF-P16-T00-INCOME-PRODUCING-ACTS-2018 CSV Parquet 67,326
2017 PF-P16-T00-INCOME-PRODUCING-ACTS-2017 CSV Parquet 60,679
2016 PF-P16-T00-INCOME-PRODUCING-ACTS-2016 CSV Parquet 56,187
2015 PF-P16-T00-INCOME-PRODUCING-ACTS-2015 CSV Parquet 52,766
2014 PF-P16-T00-INCOME-PRODUCING-ACTS-2014 CSV Parquet 48,328
2013 PF-P16-T00-INCOME-PRODUCING-ACTS-2013 CSV Parquet 41,751
2012 PF-P16-T00-INCOME-PRODUCING-ACTS-2012 CSV Parquet 36,391
2011 PF-P16-T00-INCOME-PRODUCING-ACTS-2011 CSV Parquet 31,787
2010 PF-P16-T00-INCOME-PRODUCING-ACTS-2010 CSV Parquet 23,349
2009 PF-P16-T00-INCOME-PRODUCING-ACTS-2009 CSV Parquet 2,206
Back to contents

PF-P16-T01-INCOME-PRODUCING-ACTS

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

Year Table CSV Parquet Rows
2024 PF-P16-T01-INCOME-PRODUCING-ACTS-2024 CSV Parquet 43,089
2023 PF-P16-T01-INCOME-PRODUCING-ACTS-2023 CSV Parquet 44,573
2022 PF-P16-T01-INCOME-PRODUCING-ACTS-2022 CSV Parquet 40,162
2021 PF-P16-T01-INCOME-PRODUCING-ACTS-2021 CSV Parquet 30,597
2020 PF-P16-T01-INCOME-PRODUCING-ACTS-2020 CSV Parquet 27,776
2019 PF-P16-T01-INCOME-PRODUCING-ACTS-2019 CSV Parquet 8,079
2018 PF-P16-T01-INCOME-PRODUCING-ACTS-2018 CSV Parquet 4,586
2017 PF-P16-T01-INCOME-PRODUCING-ACTS-2017 CSV Parquet 3,994
2016 PF-P16-T01-INCOME-PRODUCING-ACTS-2016 CSV Parquet 3,657
2015 PF-P16-T01-INCOME-PRODUCING-ACTS-2015 CSV Parquet 3,398
2014 PF-P16-T01-INCOME-PRODUCING-ACTS-2014 CSV Parquet 3,041
2013 PF-P16-T01-INCOME-PRODUCING-ACTS-2013 CSV Parquet 2,705
2012 PF-P16-T01-INCOME-PRODUCING-ACTS-2012 CSV Parquet 2,235
2011 PF-P16-T01-INCOME-PRODUCING-ACTS-2011 CSV Parquet 1,927
2010 PF-P16-T01-INCOME-PRODUCING-ACTS-2010 CSV Parquet 1,399
2009 PF-P16-T01-INCOME-PRODUCING-ACTS-2009 CSV Parquet 216
Back to contents

PF-P16-T02-INCOME-PRODUCING-ACTS

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

Year Table CSV Parquet Rows
2024 PF-P16-T02-INCOME-PRODUCING-ACTS-2024 CSV Parquet 52,536
2023 PF-P16-T02-INCOME-PRODUCING-ACTS-2023 CSV Parquet 63,021
2022 PF-P16-T02-INCOME-PRODUCING-ACTS-2022 CSV Parquet 50,986
2021 PF-P16-T02-INCOME-PRODUCING-ACTS-2021 CSV Parquet 45,755
2020 PF-P16-T02-INCOME-PRODUCING-ACTS-2020 CSV Parquet 42,655
2019 PF-P16-T02-INCOME-PRODUCING-ACTS-2019 CSV Parquet 24,265
2018 PF-P16-T02-INCOME-PRODUCING-ACTS-2018 CSV Parquet 16,386
2017 PF-P16-T02-INCOME-PRODUCING-ACTS-2017 CSV Parquet 17,908
2016 PF-P16-T02-INCOME-PRODUCING-ACTS-2016 CSV Parquet 15,698
2015 PF-P16-T02-INCOME-PRODUCING-ACTS-2015 CSV Parquet 14,194
2014 PF-P16-T02-INCOME-PRODUCING-ACTS-2014 CSV Parquet 12,335
2013 PF-P16-T02-INCOME-PRODUCING-ACTS-2013 CSV Parquet 10,913
2012 PF-P16-T02-INCOME-PRODUCING-ACTS-2012 CSV Parquet 9,025
2011 PF-P16-T02-INCOME-PRODUCING-ACTS-2011 CSV Parquet 7,263
2010 PF-P16-T02-INCOME-PRODUCING-ACTS-2010 CSV Parquet 5,980
2009 PF-P16-T02-INCOME-PRODUCING-ACTS-2009 CSV Parquet 802
Back to contents

PF-P16-T03-ACTS-RELATIONSHIP-EXEMPT-PURPOSE

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

Year Table CSV Parquet Rows
2024 PF-P16-T03-ACTS-RELATIONSHIP-EXEMPT-PURPOSE-2024 CSV Parquet 25,608
2023 PF-P16-T03-ACTS-RELATIONSHIP-EXEMPT-PURPOSE-2023 CSV Parquet 30,729
2022 PF-P16-T03-ACTS-RELATIONSHIP-EXEMPT-PURPOSE-2022 CSV Parquet 30,580
2021 PF-P16-T03-ACTS-RELATIONSHIP-EXEMPT-PURPOSE-2021 CSV Parquet 29,659
2020 PF-P16-T03-ACTS-RELATIONSHIP-EXEMPT-PURPOSE-2020 CSV Parquet 29,125
2019 PF-P16-T03-ACTS-RELATIONSHIP-EXEMPT-PURPOSE-2019 CSV Parquet 22,760
2018 PF-P16-T03-ACTS-RELATIONSHIP-EXEMPT-PURPOSE-2018 CSV Parquet 19,055
2017 PF-P16-T03-ACTS-RELATIONSHIP-EXEMPT-PURPOSE-2017 CSV Parquet 16,903
2016 PF-P16-T03-ACTS-RELATIONSHIP-EXEMPT-PURPOSE-2016 CSV Parquet 15,984
2015 PF-P16-T03-ACTS-RELATIONSHIP-EXEMPT-PURPOSE-2015 CSV Parquet 14,937
2014 PF-P16-T03-ACTS-RELATIONSHIP-EXEMPT-PURPOSE-2014 CSV Parquet 13,551
2013 PF-P16-T03-ACTS-RELATIONSHIP-EXEMPT-PURPOSE-2013 CSV Parquet 11,938
2012 PF-P16-T03-ACTS-RELATIONSHIP-EXEMPT-PURPOSE-2012 CSV Parquet 10,542
2011 PF-P16-T03-ACTS-RELATIONSHIP-EXEMPT-PURPOSE-2011 CSV Parquet 8,902
2010 PF-P16-T03-ACTS-RELATIONSHIP-EXEMPT-PURPOSE-2010 CSV Parquet 6,545
2009 PF-P16-T03-ACTS-RELATIONSHIP-EXEMPT-PURPOSE-2009 CSV Parquet 789
Back to contents

P17 Part XVII - Information Regarding Transfers to and Transactions and Relationships With Noncharitable Exempt Organizations (2023: Part XVI)

PF-P17-T00-RELATIONSHIPS

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

Year Table CSV Parquet Rows
2024 PF-P17-T00-RELATIONSHIPS-2024 CSV Parquet 113,393
2023 PF-P17-T00-RELATIONSHIPS-2023 CSV Parquet 123,443
2022 PF-P17-T00-RELATIONSHIPS-2022 CSV Parquet 121,587
2021 PF-P17-T00-RELATIONSHIPS-2021 CSV Parquet 118,751
2020 PF-P17-T00-RELATIONSHIPS-2020 CSV Parquet 114,316
2019 PF-P17-T00-RELATIONSHIPS-2019 CSV Parquet 87,508
2018 PF-P17-T00-RELATIONSHIPS-2018 CSV Parquet 75,314
2017 PF-P17-T00-RELATIONSHIPS-2017 CSV Parquet 68,035
2016 PF-P17-T00-RELATIONSHIPS-2016 CSV Parquet 62,785
2015 PF-P17-T00-RELATIONSHIPS-2015 CSV Parquet 58,637
2014 PF-P17-T00-RELATIONSHIPS-2014 CSV Parquet 53,274
2013 PF-P17-T00-RELATIONSHIPS-2013 CSV Parquet 45,778
2012 PF-P17-T00-RELATIONSHIPS-2012 CSV Parquet 39,836
2011 PF-P17-T00-RELATIONSHIPS-2011 CSV Parquet 34,519
2010 PF-P17-T00-RELATIONSHIPS-2010 CSV Parquet 25,193
2009 PF-P17-T00-RELATIONSHIPS-2009 CSV Parquet 2,344
Back to contents

PF-P17-T00-TRANSFERS-TRANSACTIONS

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

Year Table CSV Parquet Rows
2024 PF-P17-T00-TRANSFERS-TRANSACTIONS-2024 CSV Parquet 113,393
2023 PF-P17-T00-TRANSFERS-TRANSACTIONS-2023 CSV Parquet 123,443
2022 PF-P17-T00-TRANSFERS-TRANSACTIONS-2022 CSV Parquet 121,587
2021 PF-P17-T00-TRANSFERS-TRANSACTIONS-2021 CSV Parquet 118,751
2020 PF-P17-T00-TRANSFERS-TRANSACTIONS-2020 CSV Parquet 114,316
2019 PF-P17-T00-TRANSFERS-TRANSACTIONS-2019 CSV Parquet 87,508
2018 PF-P17-T00-TRANSFERS-TRANSACTIONS-2018 CSV Parquet 75,314
2017 PF-P17-T00-TRANSFERS-TRANSACTIONS-2017 CSV Parquet 68,035
2016 PF-P17-T00-TRANSFERS-TRANSACTIONS-2016 CSV Parquet 62,785
2015 PF-P17-T00-TRANSFERS-TRANSACTIONS-2015 CSV Parquet 58,637
2014 PF-P17-T00-TRANSFERS-TRANSACTIONS-2014 CSV Parquet 53,274
2013 PF-P17-T00-TRANSFERS-TRANSACTIONS-2013 CSV Parquet 45,778
2012 PF-P17-T00-TRANSFERS-TRANSACTIONS-2012 CSV Parquet 39,836
2011 PF-P17-T00-TRANSFERS-TRANSACTIONS-2011 CSV Parquet 34,519
2010 PF-P17-T00-TRANSFERS-TRANSACTIONS-2010 CSV Parquet 25,193
2009 PF-P17-T00-TRANSFERS-TRANSACTIONS-2009 CSV Parquet 2,344
Back to contents

PF-P17-T01-TRANSFERS-TRANSACTIONS

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

Year Table CSV Parquet Rows
2024 PF-P17-T01-TRANSFERS-TRANSACTIONS-2024 CSV Parquet 1,279
2023 PF-P17-T01-TRANSFERS-TRANSACTIONS-2023 CSV Parquet 1,315
2022 PF-P17-T01-TRANSFERS-TRANSACTIONS-2022 CSV Parquet 1,336
2021 PF-P17-T01-TRANSFERS-TRANSACTIONS-2021 CSV Parquet 1,265
2020 PF-P17-T01-TRANSFERS-TRANSACTIONS-2020 CSV Parquet 1,154
2019 PF-P17-T01-TRANSFERS-TRANSACTIONS-2019 CSV Parquet 802
2018 PF-P17-T01-TRANSFERS-TRANSACTIONS-2018 CSV Parquet 697
2017 PF-P17-T01-TRANSFERS-TRANSACTIONS-2017 CSV Parquet 633
2016 PF-P17-T01-TRANSFERS-TRANSACTIONS-2016 CSV Parquet 539
2015 PF-P17-T01-TRANSFERS-TRANSACTIONS-2015 CSV Parquet 500
2014 PF-P17-T01-TRANSFERS-TRANSACTIONS-2014 CSV Parquet 517
2013 PF-P17-T01-TRANSFERS-TRANSACTIONS-2013 CSV Parquet 477
2012 PF-P17-T01-TRANSFERS-TRANSACTIONS-2012 CSV Parquet 410
2011 PF-P17-T01-TRANSFERS-TRANSACTIONS-2011 CSV Parquet 336
2010 PF-P17-T01-TRANSFERS-TRANSACTIONS-2010 CSV Parquet 237
2009 PF-P17-T01-TRANSFERS-TRANSACTIONS-2009 CSV Parquet 35
Back to contents

PF-P17-T02-RELATIONSHIPS

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

Year Table CSV Parquet Rows
2024 PF-P17-T02-RELATIONSHIPS-2024 CSV Parquet 2,048
2023 PF-P17-T02-RELATIONSHIPS-2023 CSV Parquet 2,249
2022 PF-P17-T02-RELATIONSHIPS-2022 CSV Parquet 2,235
2021 PF-P17-T02-RELATIONSHIPS-2021 CSV Parquet 2,178
2020 PF-P17-T02-RELATIONSHIPS-2020 CSV Parquet 2,147
2019 PF-P17-T02-RELATIONSHIPS-2019 CSV Parquet 1,559
2018 PF-P17-T02-RELATIONSHIPS-2018 CSV Parquet 1,097
2017 PF-P17-T02-RELATIONSHIPS-2017 CSV Parquet 968
2016 PF-P17-T02-RELATIONSHIPS-2016 CSV Parquet 954
2015 PF-P17-T02-RELATIONSHIPS-2015 CSV Parquet 829
2014 PF-P17-T02-RELATIONSHIPS-2014 CSV Parquet 783
2013 PF-P17-T02-RELATIONSHIPS-2013 CSV Parquet 660
2012 PF-P17-T02-RELATIONSHIPS-2012 CSV Parquet 536
2011 PF-P17-T02-RELATIONSHIPS-2011 CSV Parquet 496
2010 PF-P17-T02-RELATIONSHIPS-2010 CSV Parquet 403
2009 PF-P17-T02-RELATIONSHIPS-2009 CSV Parquet 69
Back to contents

P99 Auxiliary schedules and attachments (statements filed with the 990-PF)

PF-P99-T00-AUXILLIARY

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

Year Table CSV Parquet Rows
2024 PF-P99-T00-AUXILLIARY-2024 CSV Parquet 11,659
2023 PF-P99-T00-AUXILLIARY-2023 CSV Parquet 12,283
2022 PF-P99-T00-AUXILLIARY-2022 CSV Parquet 11,574
2021 PF-P99-T00-AUXILLIARY-2021 CSV Parquet 11,208
2020 PF-P99-T00-AUXILLIARY-2020 CSV Parquet 10,732
2019 PF-P99-T00-AUXILLIARY-2019 CSV Parquet 7,270
2018 PF-P99-T00-AUXILLIARY-2018 CSV Parquet 6,057
2017 PF-P99-T00-AUXILLIARY-2017 CSV Parquet 5,209
2016 PF-P99-T00-AUXILLIARY-2016 CSV Parquet 4,557
2015 PF-P99-T00-AUXILLIARY-2015 CSV Parquet 4,214
2014 PF-P99-T00-AUXILLIARY-2014 CSV Parquet 3,627
2013 PF-P99-T00-AUXILLIARY-2013 CSV Parquet 3,157
2012 PF-P99-T00-AUXILLIARY-2012 CSV Parquet 2,830
2011 PF-P99-T00-AUXILLIARY-2011 CSV Parquet 2,297
2010 PF-P99-T00-AUXILLIARY-2010 CSV Parquet 1,425
2009 PF-P99-T00-AUXILLIARY-2009 CSV Parquet 148
Back to contents

PF-P99-T01-ACC-FEES

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

Year Table CSV Parquet Rows
2024 PF-P99-T01-ACC-FEES-2024 CSV Parquet 70,013
2023 PF-P99-T01-ACC-FEES-2023 CSV Parquet 75,209
2022 PF-P99-T01-ACC-FEES-2022 CSV Parquet 73,681
2021 PF-P99-T01-ACC-FEES-2021 CSV Parquet 72,170
2020 PF-P99-T01-ACC-FEES-2020 CSV Parquet 70,276
2019 PF-P99-T01-ACC-FEES-2019 CSV Parquet 56,773
2018 PF-P99-T01-ACC-FEES-2018 CSV Parquet 49,330
2017 PF-P99-T01-ACC-FEES-2017 CSV Parquet 44,707
2016 PF-P99-T01-ACC-FEES-2016 CSV Parquet 41,968
2015 PF-P99-T01-ACC-FEES-2015 CSV Parquet 39,230
2014 PF-P99-T01-ACC-FEES-2014 CSV Parquet 35,329
2013 PF-P99-T01-ACC-FEES-2013 CSV Parquet 29,639
2012 PF-P99-T01-ACC-FEES-2012 CSV Parquet 26,795
2011 PF-P99-T01-ACC-FEES-2011 CSV Parquet 23,366
2010 PF-P99-T01-ACC-FEES-2010 CSV Parquet 16,858
2009 PF-P99-T01-ACC-FEES-2009 CSV Parquet 1,692
Back to contents

PF-P99-T03-PROG-INVEST-OTH

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

Year Table CSV Parquet Rows
2024 PF-P99-T03-PROG-INVEST-OTH-2024 CSV Parquet 2,911
2023 PF-P99-T03-PROG-INVEST-OTH-2023 CSV Parquet 3,097
2022 PF-P99-T03-PROG-INVEST-OTH-2022 CSV Parquet 3,223
2021 PF-P99-T03-PROG-INVEST-OTH-2021 CSV Parquet 3,315
2020 PF-P99-T03-PROG-INVEST-OTH-2020 CSV Parquet 3,387
2019 PF-P99-T03-PROG-INVEST-OTH-2019 CSV Parquet 2,685
2018 PF-P99-T03-PROG-INVEST-OTH-2018 CSV Parquet 2,067
2017 PF-P99-T03-PROG-INVEST-OTH-2017 CSV Parquet 1,969
2016 PF-P99-T03-PROG-INVEST-OTH-2016 CSV Parquet 1,861
2015 PF-P99-T03-PROG-INVEST-OTH-2015 CSV Parquet 1,767
2014 PF-P99-T03-PROG-INVEST-OTH-2014 CSV Parquet 1,665
2013 PF-P99-T03-PROG-INVEST-OTH-2013 CSV Parquet 3,335
2012 PF-P99-T03-PROG-INVEST-OTH-2012 CSV Parquet 2,975
2011 PF-P99-T03-PROG-INVEST-OTH-2011 CSV Parquet 2,734
2010 PF-P99-T03-PROG-INVEST-OTH-2010 CSV Parquet 1,744
2009 PF-P99-T03-PROG-INVEST-OTH-2009 CSV Parquet 240
Back to contents

PF-P99-T04-AMORTIZATION

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

Year Table CSV Parquet Rows
2024 PF-P99-T04-AMORTIZATION-2024 CSV Parquet 1,665
2023 PF-P99-T04-AMORTIZATION-2023 CSV Parquet 1,972
2022 PF-P99-T04-AMORTIZATION-2022 CSV Parquet 2,155
2021 PF-P99-T04-AMORTIZATION-2021 CSV Parquet 2,188
2020 PF-P99-T04-AMORTIZATION-2020 CSV Parquet 1,861
2019 PF-P99-T04-AMORTIZATION-2019 CSV Parquet 1,429
2018 PF-P99-T04-AMORTIZATION-2018 CSV Parquet 1,177
2017 PF-P99-T04-AMORTIZATION-2017 CSV Parquet 1,108
2016 PF-P99-T04-AMORTIZATION-2016 CSV Parquet 913
2015 PF-P99-T04-AMORTIZATION-2015 CSV Parquet 891
2014 PF-P99-T04-AMORTIZATION-2014 CSV Parquet 791
2013 PF-P99-T04-AMORTIZATION-2013 CSV Parquet 663
2012 PF-P99-T04-AMORTIZATION-2012 CSV Parquet 525
2011 PF-P99-T04-AMORTIZATION-2011 CSV Parquet 397
2010 PF-P99-T04-AMORTIZATION-2010 CSV Parquet 320
2009 PF-P99-T04-AMORTIZATION-2009 CSV Parquet 58
Back to contents

PF-P99-T06-FUND-BORROWED

1:M many rows per filing · tax years 2011–2024 · 162 rows · Data dictionary

Year Table CSV Parquet Rows
2024 PF-P99-T06-FUND-BORROWED-2024 CSV Parquet 24
2023 PF-P99-T06-FUND-BORROWED-2023 CSV Parquet 23
2022 PF-P99-T06-FUND-BORROWED-2022 CSV Parquet 27
2021 PF-P99-T06-FUND-BORROWED-2021 CSV Parquet 22
2020 PF-P99-T06-FUND-BORROWED-2020 CSV Parquet 17
2019 PF-P99-T06-FUND-BORROWED-2019 CSV Parquet 10
2018 PF-P99-T06-FUND-BORROWED-2018 CSV Parquet 7
2017 PF-P99-T06-FUND-BORROWED-2017 CSV Parquet 7
2016 PF-P99-T06-FUND-BORROWED-2016 CSV Parquet 6
2015 PF-P99-T06-FUND-BORROWED-2015 CSV Parquet 6
2014 PF-P99-T06-FUND-BORROWED-2014 CSV Parquet 5
2013 PF-P99-T06-FUND-BORROWED-2013 CSV Parquet 4
2012 PF-P99-T06-FUND-BORROWED-2012 CSV Parquet 2
2011 PF-P99-T06-FUND-BORROWED-2011 CSV Parquet 2
Back to contents

PF-P99-T09-COMP

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

Year Table CSV Parquet Rows
2024 PF-P99-T09-COMP-2024 CSV Parquet 3,025
2023 PF-P99-T09-COMP-2023 CSV Parquet 3,577
2022 PF-P99-T09-COMP-2022 CSV Parquet 3,038
2021 PF-P99-T09-COMP-2021 CSV Parquet 3,297
2020 PF-P99-T09-COMP-2020 CSV Parquet 3,216
2019 PF-P99-T09-COMP-2019 CSV Parquet 2,270
2018 PF-P99-T09-COMP-2018 CSV Parquet 1,890
2017 PF-P99-T09-COMP-2017 CSV Parquet 2,027
2016 PF-P99-T09-COMP-2016 CSV Parquet 2,053
2015 PF-P99-T09-COMP-2015 CSV Parquet 1,597
2014 PF-P99-T09-COMP-2014 CSV Parquet 1,295
2013 PF-P99-T09-COMP-2013 CSV Parquet 26,913
2012 PF-P99-T09-COMP-2012 CSV Parquet 22,994
2011 PF-P99-T09-COMP-2011 CSV Parquet 19,337
2010 PF-P99-T09-COMP-2010 CSV Parquet 14,396
2009 PF-P99-T09-COMP-2009 CSV Parquet 36
Back to contents

PF-P99-T10-COMP-KONTR

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

Year Table CSV Parquet Rows
2024 PF-P99-T10-COMP-KONTR-2024 CSV Parquet 590
2023 PF-P99-T10-COMP-KONTR-2023 CSV Parquet 598
2022 PF-P99-T10-COMP-KONTR-2022 CSV Parquet 568
2021 PF-P99-T10-COMP-KONTR-2021 CSV Parquet 501
2020 PF-P99-T10-COMP-KONTR-2020 CSV Parquet 404
2019 PF-P99-T10-COMP-KONTR-2019 CSV Parquet 317
2018 PF-P99-T10-COMP-KONTR-2018 CSV Parquet 273
2017 PF-P99-T10-COMP-KONTR-2017 CSV Parquet 256
2016 PF-P99-T10-COMP-KONTR-2016 CSV Parquet 242
2015 PF-P99-T10-COMP-KONTR-2015 CSV Parquet 234
2014 PF-P99-T10-COMP-KONTR-2014 CSV Parquet 214
2013 PF-P99-T10-COMP-KONTR-2013 CSV Parquet 379
2012 PF-P99-T10-COMP-KONTR-2012 CSV Parquet 265
2011 PF-P99-T10-COMP-KONTR-2011 CSV Parquet 198
2010 PF-P99-T10-COMP-KONTR-2010 CSV Parquet 141
2009 PF-P99-T10-COMP-KONTR-2009 CSV Parquet 25
Back to contents

PF-P99-T11-DEPREC

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

Year Table CSV Parquet Rows
2024 PF-P99-T11-DEPREC-2024 CSV Parquet 105,171
2023 PF-P99-T11-DEPREC-2023 CSV Parquet 120,870
2022 PF-P99-T11-DEPREC-2022 CSV Parquet 119,973
2021 PF-P99-T11-DEPREC-2021 CSV Parquet 120,366
2020 PF-P99-T11-DEPREC-2020 CSV Parquet 116,183
2019 PF-P99-T11-DEPREC-2019 CSV Parquet 86,983
2018 PF-P99-T11-DEPREC-2018 CSV Parquet 77,891
2017 PF-P99-T11-DEPREC-2017 CSV Parquet 76,109
2016 PF-P99-T11-DEPREC-2016 CSV Parquet 71,029
2015 PF-P99-T11-DEPREC-2015 CSV Parquet 68,860
2014 PF-P99-T11-DEPREC-2014 CSV Parquet 61,765
2013 PF-P99-T11-DEPREC-2013 CSV Parquet 52,983
2012 PF-P99-T11-DEPREC-2012 CSV Parquet 43,897
2011 PF-P99-T11-DEPREC-2011 CSV Parquet 37,291
2010 PF-P99-T11-DEPREC-2010 CSV Parquet 27,495
2009 PF-P99-T11-DEPREC-2009 CSV Parquet 4,487
Back to contents

PF-P99-T12-DISSOLUTION

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

Year Table CSV Parquet Rows
2024 PF-P99-T12-DISSOLUTION-2024 CSV Parquet 2,166
2023 PF-P99-T12-DISSOLUTION-2023 CSV Parquet 2,434
2022 PF-P99-T12-DISSOLUTION-2022 CSV Parquet 1,980
2021 PF-P99-T12-DISSOLUTION-2021 CSV Parquet 1,901
2020 PF-P99-T12-DISSOLUTION-2020 CSV Parquet 1,882
2019 PF-P99-T12-DISSOLUTION-2019 CSV Parquet 1,152
2018 PF-P99-T12-DISSOLUTION-2018 CSV Parquet 1,087
2017 PF-P99-T12-DISSOLUTION-2017 CSV Parquet 988
2016 PF-P99-T12-DISSOLUTION-2016 CSV Parquet 744
2015 PF-P99-T12-DISSOLUTION-2015 CSV Parquet 708
2014 PF-P99-T12-DISSOLUTION-2014 CSV Parquet 590
2013 PF-P99-T12-DISSOLUTION-2013 CSV Parquet 636
2012 PF-P99-T12-DISSOLUTION-2012 CSV Parquet 468
2011 PF-P99-T12-DISSOLUTION-2011 CSV Parquet 280
2010 PF-P99-T12-DISSOLUTION-2010 CSV Parquet 237
2009 PF-P99-T12-DISSOLUTION-2009 CSV Parquet 10
Back to contents

PF-P99-T16-EXP-RESPONSIBILITY

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

Year Table CSV Parquet Rows
2024 PF-P99-T16-EXP-RESPONSIBILITY-2024 CSV Parquet 16,453
2023 PF-P99-T16-EXP-RESPONSIBILITY-2023 CSV Parquet 15,087
2022 PF-P99-T16-EXP-RESPONSIBILITY-2022 CSV Parquet 15,460
2021 PF-P99-T16-EXP-RESPONSIBILITY-2021 CSV Parquet 14,527
2020 PF-P99-T16-EXP-RESPONSIBILITY-2020 CSV Parquet 14,169
2019 PF-P99-T16-EXP-RESPONSIBILITY-2019 CSV Parquet 8,647
2018 PF-P99-T16-EXP-RESPONSIBILITY-2018 CSV Parquet 6,559
2017 PF-P99-T16-EXP-RESPONSIBILITY-2017 CSV Parquet 6,380
2016 PF-P99-T16-EXP-RESPONSIBILITY-2016 CSV Parquet 6,012
2015 PF-P99-T16-EXP-RESPONSIBILITY-2015 CSV Parquet 5,663
2014 PF-P99-T16-EXP-RESPONSIBILITY-2014 CSV Parquet 5,477
2013 PF-P99-T16-EXP-RESPONSIBILITY-2013 CSV Parquet 4,843
2012 PF-P99-T16-EXP-RESPONSIBILITY-2012 CSV Parquet 4,592
2011 PF-P99-T16-EXP-RESPONSIBILITY-2011 CSV Parquet 5,499
2010 PF-P99-T16-EXP-RESPONSIBILITY-2010 CSV Parquet 3,703
2009 PF-P99-T16-EXP-RESPONSIBILITY-2009 CSV Parquet 1,562
Back to contents

PF-P99-T20-SALE-OTH-ASSET

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

Year Table CSV Parquet Rows
2024 PF-P99-T20-SALE-OTH-ASSET-2024 CSV Parquet 36,200
2023 PF-P99-T20-SALE-OTH-ASSET-2023 CSV Parquet 42,317
2022 PF-P99-T20-SALE-OTH-ASSET-2022 CSV Parquet 46,712
2021 PF-P99-T20-SALE-OTH-ASSET-2021 CSV Parquet 42,168
2020 PF-P99-T20-SALE-OTH-ASSET-2020 CSV Parquet 48,559
2019 PF-P99-T20-SALE-OTH-ASSET-2019 CSV Parquet 44,964
2018 PF-P99-T20-SALE-OTH-ASSET-2018 CSV Parquet 44,804
2017 PF-P99-T20-SALE-OTH-ASSET-2017 CSV Parquet 43,422
2016 PF-P99-T20-SALE-OTH-ASSET-2016 CSV Parquet 53,631
2015 PF-P99-T20-SALE-OTH-ASSET-2015 CSV Parquet 54,723
2014 PF-P99-T20-SALE-OTH-ASSET-2014 CSV Parquet 51,968
2013 PF-P99-T20-SALE-OTH-ASSET-2013 CSV Parquet 47,701
2012 PF-P99-T20-SALE-OTH-ASSET-2012 CSV Parquet 42,587
2011 PF-P99-T20-SALE-OTH-ASSET-2011 CSV Parquet 34,258
2010 PF-P99-T20-SALE-OTH-ASSET-2010 CSV Parquet 24,860
2009 PF-P99-T20-SALE-OTH-ASSET-2009 CSV Parquet 3,624
Back to contents

PF-P99-T22-SUPPLEMENTAL-INFO

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

Year Table CSV Parquet Rows
2024 PF-P99-T22-SUPPLEMENTAL-INFO-2024 CSV Parquet 6,735
2023 PF-P99-T22-SUPPLEMENTAL-INFO-2023 CSV Parquet 7,442
2022 PF-P99-T22-SUPPLEMENTAL-INFO-2022 CSV Parquet 7,710
2021 PF-P99-T22-SUPPLEMENTAL-INFO-2021 CSV Parquet 8,321
2020 PF-P99-T22-SUPPLEMENTAL-INFO-2020 CSV Parquet 8,328
2019 PF-P99-T22-SUPPLEMENTAL-INFO-2019 CSV Parquet 9,204
2018 PF-P99-T22-SUPPLEMENTAL-INFO-2018 CSV Parquet 6,678
2017 PF-P99-T22-SUPPLEMENTAL-INFO-2017 CSV Parquet 4,701
2016 PF-P99-T22-SUPPLEMENTAL-INFO-2016 CSV Parquet 4,880
2015 PF-P99-T22-SUPPLEMENTAL-INFO-2015 CSV Parquet 4,309
2014 PF-P99-T22-SUPPLEMENTAL-INFO-2014 CSV Parquet 3,973
2013 PF-P99-T22-SUPPLEMENTAL-INFO-2013 CSV Parquet 1,672
2012 PF-P99-T22-SUPPLEMENTAL-INFO-2012 CSV Parquet 1,682
2011 PF-P99-T22-SUPPLEMENTAL-INFO-2011 CSV Parquet 1,419
2010 PF-P99-T22-SUPPLEMENTAL-INFO-2010 CSV Parquet 1,073
2009 PF-P99-T22-SUPPLEMENTAL-INFO-2009 CSV Parquet 140
Back to contents

PF-P99-T23-INVEST-CORP-BOND

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

Year Table CSV Parquet Rows
2024 PF-P99-T23-INVEST-CORP-BOND-2024 CSV Parquet 183,496
2023 PF-P99-T23-INVEST-CORP-BOND-2023 CSV Parquet 183,500
2022 PF-P99-T23-INVEST-CORP-BOND-2022 CSV Parquet 176,507
2021 PF-P99-T23-INVEST-CORP-BOND-2021 CSV Parquet 178,673
2020 PF-P99-T23-INVEST-CORP-BOND-2020 CSV Parquet 172,938
2019 PF-P99-T23-INVEST-CORP-BOND-2019 CSV Parquet 111,116
2018 PF-P99-T23-INVEST-CORP-BOND-2018 CSV Parquet 92,501
2017 PF-P99-T23-INVEST-CORP-BOND-2017 CSV Parquet 80,514
2016 PF-P99-T23-INVEST-CORP-BOND-2016 CSV Parquet 60,340
2015 PF-P99-T23-INVEST-CORP-BOND-2015 CSV Parquet 52,136
2014 PF-P99-T23-INVEST-CORP-BOND-2014 CSV Parquet 48,146
2013 PF-P99-T23-INVEST-CORP-BOND-2013 CSV Parquet 44,021
2012 PF-P99-T23-INVEST-CORP-BOND-2012 CSV Parquet 43,005
2011 PF-P99-T23-INVEST-CORP-BOND-2011 CSV Parquet 44,371
2010 PF-P99-T23-INVEST-CORP-BOND-2010 CSV Parquet 33,438
2009 PF-P99-T23-INVEST-CORP-BOND-2009 CSV Parquet 4,839
Back to contents

PF-P99-T24-INVEST-CORP-STOCK

1:M many rows per filing · tax years 2009–2024 · 9,571,788 rows · Data dictionary

Year Table CSV Parquet Rows
2024 PF-P99-T24-INVEST-CORP-STOCK-2024 CSV Parquet 1,103,162
2023 PF-P99-T24-INVEST-CORP-STOCK-2023 CSV Parquet 1,168,243
2022 PF-P99-T24-INVEST-CORP-STOCK-2022 CSV Parquet 1,210,113
2021 PF-P99-T24-INVEST-CORP-STOCK-2021 CSV Parquet 1,186,745
2020 PF-P99-T24-INVEST-CORP-STOCK-2020 CSV Parquet 1,059,120
2019 PF-P99-T24-INVEST-CORP-STOCK-2019 CSV Parquet 679,804
2018 PF-P99-T24-INVEST-CORP-STOCK-2018 CSV Parquet 548,795
2017 PF-P99-T24-INVEST-CORP-STOCK-2017 CSV Parquet 480,423
2016 PF-P99-T24-INVEST-CORP-STOCK-2016 CSV Parquet 432,989
2015 PF-P99-T24-INVEST-CORP-STOCK-2015 CSV Parquet 388,575
2014 PF-P99-T24-INVEST-CORP-STOCK-2014 CSV Parquet 355,949
2013 PF-P99-T24-INVEST-CORP-STOCK-2013 CSV Parquet 277,869
2012 PF-P99-T24-INVEST-CORP-STOCK-2012 CSV Parquet 244,243
2011 PF-P99-T24-INVEST-CORP-STOCK-2011 CSV Parquet 232,863
2010 PF-P99-T24-INVEST-CORP-STOCK-2010 CSV Parquet 178,181
2009 PF-P99-T24-INVEST-CORP-STOCK-2009 CSV Parquet 24,714
Back to contents

PF-P99-T25-INVEST-GOVT-SEC

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

Year Table CSV Parquet Rows
2024 PF-P99-T25-INVEST-GOVT-SEC-2024 CSV Parquet 9,053
2023 PF-P99-T25-INVEST-GOVT-SEC-2023 CSV Parquet 10,197
2022 PF-P99-T25-INVEST-GOVT-SEC-2022 CSV Parquet 9,385
2021 PF-P99-T25-INVEST-GOVT-SEC-2021 CSV Parquet 7,105
2020 PF-P99-T25-INVEST-GOVT-SEC-2020 CSV Parquet 7,192
2019 PF-P99-T25-INVEST-GOVT-SEC-2019 CSV Parquet 5,638
2018 PF-P99-T25-INVEST-GOVT-SEC-2018 CSV Parquet 4,866
2017 PF-P99-T25-INVEST-GOVT-SEC-2017 CSV Parquet 4,410
2016 PF-P99-T25-INVEST-GOVT-SEC-2016 CSV Parquet 4,289
2015 PF-P99-T25-INVEST-GOVT-SEC-2015 CSV Parquet 4,000
2014 PF-P99-T25-INVEST-GOVT-SEC-2014 CSV Parquet 3,901
2013 PF-P99-T25-INVEST-GOVT-SEC-2013 CSV Parquet 3,750
2012 PF-P99-T25-INVEST-GOVT-SEC-2012 CSV Parquet 3,394
2011 PF-P99-T25-INVEST-GOVT-SEC-2011 CSV Parquet 3,187
2010 PF-P99-T25-INVEST-GOVT-SEC-2010 CSV Parquet 2,516
2009 PF-P99-T25-INVEST-GOVT-SEC-2009 CSV Parquet 289
Back to contents

PF-P99-T26-INVEST-LAND

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

Year Table CSV Parquet Rows
2024 PF-P99-T26-INVEST-LAND-2024 CSV Parquet 10,843
2023 PF-P99-T26-INVEST-LAND-2023 CSV Parquet 12,243
2022 PF-P99-T26-INVEST-LAND-2022 CSV Parquet 11,718
2021 PF-P99-T26-INVEST-LAND-2021 CSV Parquet 10,792
2020 PF-P99-T26-INVEST-LAND-2020 CSV Parquet 9,189
2019 PF-P99-T26-INVEST-LAND-2019 CSV Parquet 7,391
2018 PF-P99-T26-INVEST-LAND-2018 CSV Parquet 6,581
2017 PF-P99-T26-INVEST-LAND-2017 CSV Parquet 5,912
2016 PF-P99-T26-INVEST-LAND-2016 CSV Parquet 5,916
2015 PF-P99-T26-INVEST-LAND-2015 CSV Parquet 5,996
2014 PF-P99-T26-INVEST-LAND-2014 CSV Parquet 5,269
2013 PF-P99-T26-INVEST-LAND-2013 CSV Parquet 4,332
2012 PF-P99-T26-INVEST-LAND-2012 CSV Parquet 2,659
2011 PF-P99-T26-INVEST-LAND-2011 CSV Parquet 2,031
2010 PF-P99-T26-INVEST-LAND-2010 CSV Parquet 1,506
2009 PF-P99-T26-INVEST-LAND-2009 CSV Parquet 467
Back to contents

PF-P99-T27-INVEST-OTH

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

Year Table CSV Parquet Rows
2024 PF-P99-T27-INVEST-OTH-2024 CSV Parquet 445,627
2023 PF-P99-T27-INVEST-OTH-2023 CSV Parquet 478,114
2022 PF-P99-T27-INVEST-OTH-2022 CSV Parquet 466,511
2021 PF-P99-T27-INVEST-OTH-2021 CSV Parquet 469,788
2020 PF-P99-T27-INVEST-OTH-2020 CSV Parquet 492,477
2019 PF-P99-T27-INVEST-OTH-2019 CSV Parquet 309,378
2018 PF-P99-T27-INVEST-OTH-2018 CSV Parquet 229,186
2017 PF-P99-T27-INVEST-OTH-2017 CSV Parquet 123,110
2016 PF-P99-T27-INVEST-OTH-2016 CSV Parquet 106,514
2015 PF-P99-T27-INVEST-OTH-2015 CSV Parquet 98,271
2014 PF-P99-T27-INVEST-OTH-2014 CSV Parquet 89,974
2013 PF-P99-T27-INVEST-OTH-2013 CSV Parquet 79,770
2012 PF-P99-T27-INVEST-OTH-2012 CSV Parquet 70,095
2011 PF-P99-T27-INVEST-OTH-2011 CSV Parquet 57,932
2010 PF-P99-T27-INVEST-OTH-2010 CSV Parquet 40,019
2009 PF-P99-T27-INVEST-OTH-2009 CSV Parquet 4,266
Back to contents

PF-P99-T28-LAND-ETC

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

Year Table CSV Parquet Rows
2024 PF-P99-T28-LAND-ETC-2024 CSV Parquet 59,464
2023 PF-P99-T28-LAND-ETC-2023 CSV Parquet 67,820
2022 PF-P99-T28-LAND-ETC-2022 CSV Parquet 66,214
2021 PF-P99-T28-LAND-ETC-2021 CSV Parquet 68,590
2020 PF-P99-T28-LAND-ETC-2020 CSV Parquet 63,617
2019 PF-P99-T28-LAND-ETC-2019 CSV Parquet 46,121
2018 PF-P99-T28-LAND-ETC-2018 CSV Parquet 40,956
2017 PF-P99-T28-LAND-ETC-2017 CSV Parquet 39,813
2016 PF-P99-T28-LAND-ETC-2016 CSV Parquet 36,297
2015 PF-P99-T28-LAND-ETC-2015 CSV Parquet 34,566
2014 PF-P99-T28-LAND-ETC-2014 CSV Parquet 30,600
2013 PF-P99-T28-LAND-ETC-2013 CSV Parquet 27,543
2012 PF-P99-T28-LAND-ETC-2012 CSV Parquet 23,100
2011 PF-P99-T28-LAND-ETC-2011 CSV Parquet 19,911
2010 PF-P99-T28-LAND-ETC-2010 CSV Parquet 15,494
2009 PF-P99-T28-LAND-ETC-2009 CSV Parquet 2,696
Back to contents

PF-P99-T31-LOAN-OFF

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

Year Table CSV Parquet Rows
2024 PF-P99-T31-LOAN-OFF-2024 CSV Parquet 749
2023 PF-P99-T31-LOAN-OFF-2023 CSV Parquet 841
2022 PF-P99-T31-LOAN-OFF-2022 CSV Parquet 822
2021 PF-P99-T31-LOAN-OFF-2021 CSV Parquet 801
2020 PF-P99-T31-LOAN-OFF-2020 CSV Parquet 744
2019 PF-P99-T31-LOAN-OFF-2019 CSV Parquet 576
2018 PF-P99-T31-LOAN-OFF-2018 CSV Parquet 541
2017 PF-P99-T31-LOAN-OFF-2017 CSV Parquet 540
2016 PF-P99-T31-LOAN-OFF-2016 CSV Parquet 533
2015 PF-P99-T31-LOAN-OFF-2015 CSV Parquet 489
2014 PF-P99-T31-LOAN-OFF-2014 CSV Parquet 382
2013 PF-P99-T31-LOAN-OFF-2013 CSV Parquet 334
2012 PF-P99-T31-LOAN-OFF-2012 CSV Parquet 284
2011 PF-P99-T31-LOAN-OFF-2011 CSV Parquet 225
2010 PF-P99-T31-LOAN-OFF-2010 CSV Parquet 187
2009 PF-P99-T31-LOAN-OFF-2009 CSV Parquet 28
Back to contents

PF-P99-T32-MTG-NOTE

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

Year Table CSV Parquet Rows
2024 PF-P99-T32-MTG-NOTE-2024 CSV Parquet 761
2023 PF-P99-T32-MTG-NOTE-2023 CSV Parquet 930
2022 PF-P99-T32-MTG-NOTE-2022 CSV Parquet 971
2021 PF-P99-T32-MTG-NOTE-2021 CSV Parquet 1,033
2020 PF-P99-T32-MTG-NOTE-2020 CSV Parquet 1,121
2019 PF-P99-T32-MTG-NOTE-2019 CSV Parquet 824
2018 PF-P99-T32-MTG-NOTE-2018 CSV Parquet 694
2017 PF-P99-T32-MTG-NOTE-2017 CSV Parquet 701
2016 PF-P99-T32-MTG-NOTE-2016 CSV Parquet 659
2015 PF-P99-T32-MTG-NOTE-2015 CSV Parquet 584
2014 PF-P99-T32-MTG-NOTE-2014 CSV Parquet 519
2013 PF-P99-T32-MTG-NOTE-2013 CSV Parquet 458
2012 PF-P99-T32-MTG-NOTE-2012 CSV Parquet 338
2011 PF-P99-T32-MTG-NOTE-2011 CSV Parquet 322
2010 PF-P99-T32-MTG-NOTE-2010 CSV Parquet 228
2009 PF-P99-T32-MTG-NOTE-2009 CSV Parquet 42
Back to contents

PF-P99-T33-ASSET-OTH

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

Year Table CSV Parquet Rows
2024 PF-P99-T33-ASSET-OTH-2024 CSV Parquet 37,809
2023 PF-P99-T33-ASSET-OTH-2023 CSV Parquet 42,639
2022 PF-P99-T33-ASSET-OTH-2022 CSV Parquet 41,429
2021 PF-P99-T33-ASSET-OTH-2021 CSV Parquet 39,787
2020 PF-P99-T33-ASSET-OTH-2020 CSV Parquet 38,199
2019 PF-P99-T33-ASSET-OTH-2019 CSV Parquet 29,651
2018 PF-P99-T33-ASSET-OTH-2018 CSV Parquet 23,444
2017 PF-P99-T33-ASSET-OTH-2017 CSV Parquet 20,981
2016 PF-P99-T33-ASSET-OTH-2016 CSV Parquet 18,085
2015 PF-P99-T33-ASSET-OTH-2015 CSV Parquet 16,844
2014 PF-P99-T33-ASSET-OTH-2014 CSV Parquet 14,410
2013 PF-P99-T33-ASSET-OTH-2013 CSV Parquet 14,278
2012 PF-P99-T33-ASSET-OTH-2012 CSV Parquet 12,294
2011 PF-P99-T33-ASSET-OTH-2011 CSV Parquet 9,847
2010 PF-P99-T33-ASSET-OTH-2010 CSV Parquet 6,670
2009 PF-P99-T33-ASSET-OTH-2009 CSV Parquet 773
Back to contents

PF-P99-T35-DECREASE-OTH

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

Year Table CSV Parquet Rows
2024 PF-P99-T35-DECREASE-OTH-2024 CSV Parquet 51,272
2023 PF-P99-T35-DECREASE-OTH-2023 CSV Parquet 53,792
2022 PF-P99-T35-DECREASE-OTH-2022 CSV Parquet 59,373
2021 PF-P99-T35-DECREASE-OTH-2021 CSV Parquet 51,030
2020 PF-P99-T35-DECREASE-OTH-2020 CSV Parquet 47,525
2019 PF-P99-T35-DECREASE-OTH-2019 CSV Parquet 36,295
2018 PF-P99-T35-DECREASE-OTH-2018 CSV Parquet 35,286
2017 PF-P99-T35-DECREASE-OTH-2017 CSV Parquet 26,624
2016 PF-P99-T35-DECREASE-OTH-2016 CSV Parquet 22,593
2015 PF-P99-T35-DECREASE-OTH-2015 CSV Parquet 22,787
2014 PF-P99-T35-DECREASE-OTH-2014 CSV Parquet 19,790
2013 PF-P99-T35-DECREASE-OTH-2013 CSV Parquet 10,266
2012 PF-P99-T35-DECREASE-OTH-2012 CSV Parquet 8,579
2011 PF-P99-T35-DECREASE-OTH-2011 CSV Parquet 9,603
2010 PF-P99-T35-DECREASE-OTH-2010 CSV Parquet 5,735
2009 PF-P99-T35-DECREASE-OTH-2009 CSV Parquet 515
Back to contents

PF-P99-T36-EXP-OTH

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

Year Table CSV Parquet Rows
2024 PF-P99-T36-EXP-OTH-2024 CSV Parquet 283,397
2023 PF-P99-T36-EXP-OTH-2023 CSV Parquet 304,877
2022 PF-P99-T36-EXP-OTH-2022 CSV Parquet 295,129
2021 PF-P99-T36-EXP-OTH-2021 CSV Parquet 279,900
2020 PF-P99-T36-EXP-OTH-2020 CSV Parquet 267,492
2019 PF-P99-T36-EXP-OTH-2019 CSV Parquet 217,230
2018 PF-P99-T36-EXP-OTH-2018 CSV Parquet 187,598
2017 PF-P99-T36-EXP-OTH-2017 CSV Parquet 173,757
2016 PF-P99-T36-EXP-OTH-2016 CSV Parquet 161,811
2015 PF-P99-T36-EXP-OTH-2015 CSV Parquet 152,614
2014 PF-P99-T36-EXP-OTH-2014 CSV Parquet 133,462
2013 PF-P99-T36-EXP-OTH-2013 CSV Parquet 113,144
2012 PF-P99-T36-EXP-OTH-2012 CSV Parquet 97,036
2011 PF-P99-T36-EXP-OTH-2011 CSV Parquet 80,913
2010 PF-P99-T36-EXP-OTH-2010 CSV Parquet 57,503
2009 PF-P99-T36-EXP-OTH-2009 CSV Parquet 6,557
Back to contents

PF-P99-T37-INCOME-OTH

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

Year Table CSV Parquet Rows
2024 PF-P99-T37-INCOME-OTH-2024 CSV Parquet 56,852
2023 PF-P99-T37-INCOME-OTH-2023 CSV Parquet 68,990
2022 PF-P99-T37-INCOME-OTH-2022 CSV Parquet 60,090
2021 PF-P99-T37-INCOME-OTH-2021 CSV Parquet 61,082
2020 PF-P99-T37-INCOME-OTH-2020 CSV Parquet 58,464
2019 PF-P99-T37-INCOME-OTH-2019 CSV Parquet 49,512
2018 PF-P99-T37-INCOME-OTH-2018 CSV Parquet 39,169
2017 PF-P99-T37-INCOME-OTH-2017 CSV Parquet 39,592
2016 PF-P99-T37-INCOME-OTH-2016 CSV Parquet 35,900
2015 PF-P99-T37-INCOME-OTH-2015 CSV Parquet 33,040
2014 PF-P99-T37-INCOME-OTH-2014 CSV Parquet 30,021
2013 PF-P99-T37-INCOME-OTH-2013 CSV Parquet 24,004
2012 PF-P99-T37-INCOME-OTH-2012 CSV Parquet 19,668
2011 PF-P99-T37-INCOME-OTH-2011 CSV Parquet 15,668
2010 PF-P99-T37-INCOME-OTH-2010 CSV Parquet 11,907
2009 PF-P99-T37-INCOME-OTH-2009 CSV Parquet 1,601
Back to contents

PF-P99-T38-INCREASE-OTH

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

Year Table CSV Parquet Rows
2024 PF-P99-T38-INCREASE-OTH-2024 CSV Parquet 44,850
2023 PF-P99-T38-INCREASE-OTH-2023 CSV Parquet 46,914
2022 PF-P99-T38-INCREASE-OTH-2022 CSV Parquet 40,779
2021 PF-P99-T38-INCREASE-OTH-2021 CSV Parquet 45,210
2020 PF-P99-T38-INCREASE-OTH-2020 CSV Parquet 43,694
2019 PF-P99-T38-INCREASE-OTH-2019 CSV Parquet 30,682
2018 PF-P99-T38-INCREASE-OTH-2018 CSV Parquet 23,594
2017 PF-P99-T38-INCREASE-OTH-2017 CSV Parquet 18,773
2016 PF-P99-T38-INCREASE-OTH-2016 CSV Parquet 19,656
2015 PF-P99-T38-INCREASE-OTH-2015 CSV Parquet 16,724
2014 PF-P99-T38-INCREASE-OTH-2014 CSV Parquet 15,836
2013 PF-P99-T38-INCREASE-OTH-2013 CSV Parquet 11,309
2012 PF-P99-T38-INCREASE-OTH-2012 CSV Parquet 9,141
2011 PF-P99-T38-INCREASE-OTH-2011 CSV Parquet 8,286
2010 PF-P99-T38-INCREASE-OTH-2010 CSV Parquet 7,252
2009 PF-P99-T38-INCREASE-OTH-2009 CSV Parquet 699
Back to contents

PF-P99-T39-LIAB-OTH

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

Year Table CSV Parquet Rows
2024 PF-P99-T39-LIAB-OTH-2024 CSV Parquet 15,871
2023 PF-P99-T39-LIAB-OTH-2023 CSV Parquet 17,293
2022 PF-P99-T39-LIAB-OTH-2022 CSV Parquet 17,391
2021 PF-P99-T39-LIAB-OTH-2021 CSV Parquet 16,787
2020 PF-P99-T39-LIAB-OTH-2020 CSV Parquet 15,683
2019 PF-P99-T39-LIAB-OTH-2019 CSV Parquet 11,497
2018 PF-P99-T39-LIAB-OTH-2018 CSV Parquet 10,135
2017 PF-P99-T39-LIAB-OTH-2017 CSV Parquet 9,452
2016 PF-P99-T39-LIAB-OTH-2016 CSV Parquet 8,614
2015 PF-P99-T39-LIAB-OTH-2015 CSV Parquet 8,253
2014 PF-P99-T39-LIAB-OTH-2014 CSV Parquet 7,759
2013 PF-P99-T39-LIAB-OTH-2013 CSV Parquet 6,688
2012 PF-P99-T39-LIAB-OTH-2012 CSV Parquet 5,533
2011 PF-P99-T39-LIAB-OTH-2011 CSV Parquet 4,504
2010 PF-P99-T39-LIAB-OTH-2010 CSV Parquet 3,166
2009 PF-P99-T39-LIAB-OTH-2009 CSV Parquet 437
Back to contents

PF-P99-T40-NOTE-LOAN-OTH-LONG

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

Year Table CSV Parquet Rows
2024 PF-P99-T40-NOTE-LOAN-OTH-LONG-2024 CSV Parquet 1,595
2023 PF-P99-T40-NOTE-LOAN-OTH-LONG-2023 CSV Parquet 2,090
2022 PF-P99-T40-NOTE-LOAN-OTH-LONG-2022 CSV Parquet 1,979
2021 PF-P99-T40-NOTE-LOAN-OTH-LONG-2021 CSV Parquet 2,014
2020 PF-P99-T40-NOTE-LOAN-OTH-LONG-2020 CSV Parquet 2,112
2019 PF-P99-T40-NOTE-LOAN-OTH-LONG-2019 CSV Parquet 1,616
2018 PF-P99-T40-NOTE-LOAN-OTH-LONG-2018 CSV Parquet 1,189
2017 PF-P99-T40-NOTE-LOAN-OTH-LONG-2017 CSV Parquet 961
2016 PF-P99-T40-NOTE-LOAN-OTH-LONG-2016 CSV Parquet 947
2015 PF-P99-T40-NOTE-LOAN-OTH-LONG-2015 CSV Parquet 923
2014 PF-P99-T40-NOTE-LOAN-OTH-LONG-2014 CSV Parquet 863
2013 PF-P99-T40-NOTE-LOAN-OTH-LONG-2013 CSV Parquet 672
2012 PF-P99-T40-NOTE-LOAN-OTH-LONG-2012 CSV Parquet 633
2011 PF-P99-T40-NOTE-LOAN-OTH-LONG-2011 CSV Parquet 629
2010 PF-P99-T40-NOTE-LOAN-OTH-LONG-2010 CSV Parquet 542
2009 PF-P99-T40-NOTE-LOAN-OTH-LONG-2009 CSV Parquet 29
Back to contents

PF-P99-T41-NOTE-LOAN-OTH-SHORT

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

Year Table CSV Parquet Rows
2024 PF-P99-T41-NOTE-LOAN-OTH-SHORT-2024 CSV Parquet 1,073
2023 PF-P99-T41-NOTE-LOAN-OTH-SHORT-2023 CSV Parquet 1,257
2022 PF-P99-T41-NOTE-LOAN-OTH-SHORT-2022 CSV Parquet 1,290
2021 PF-P99-T41-NOTE-LOAN-OTH-SHORT-2021 CSV Parquet 1,360
2020 PF-P99-T41-NOTE-LOAN-OTH-SHORT-2020 CSV Parquet 1,366
2019 PF-P99-T41-NOTE-LOAN-OTH-SHORT-2019 CSV Parquet 1,067
2018 PF-P99-T41-NOTE-LOAN-OTH-SHORT-2018 CSV Parquet 1,125
2017 PF-P99-T41-NOTE-LOAN-OTH-SHORT-2017 CSV Parquet 899
2016 PF-P99-T41-NOTE-LOAN-OTH-SHORT-2016 CSV Parquet 856
2015 PF-P99-T41-NOTE-LOAN-OTH-SHORT-2015 CSV Parquet 826
2014 PF-P99-T41-NOTE-LOAN-OTH-SHORT-2014 CSV Parquet 763
2013 PF-P99-T41-NOTE-LOAN-OTH-SHORT-2013 CSV Parquet 719
2012 PF-P99-T41-NOTE-LOAN-OTH-SHORT-2012 CSV Parquet 588
2011 PF-P99-T41-NOTE-LOAN-OTH-SHORT-2011 CSV Parquet 505
2010 PF-P99-T41-NOTE-LOAN-OTH-SHORT-2010 CSV Parquet 394
2009 PF-P99-T41-NOTE-LOAN-OTH-SHORT-2009 CSV Parquet 12
Back to contents

PF-P99-T42-PROF-FEES-OTH

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

Year Table CSV Parquet Rows
2024 PF-P99-T42-PROF-FEES-OTH-2024 CSV Parquet 58,085
2023 PF-P99-T42-PROF-FEES-OTH-2023 CSV Parquet 62,043
2022 PF-P99-T42-PROF-FEES-OTH-2022 CSV Parquet 60,358
2021 PF-P99-T42-PROF-FEES-OTH-2021 CSV Parquet 57,504
2020 PF-P99-T42-PROF-FEES-OTH-2020 CSV Parquet 54,758
2019 PF-P99-T42-PROF-FEES-OTH-2019 CSV Parquet 40,760
2018 PF-P99-T42-PROF-FEES-OTH-2018 CSV Parquet 33,218
2017 PF-P99-T42-PROF-FEES-OTH-2017 CSV Parquet 30,453
2016 PF-P99-T42-PROF-FEES-OTH-2016 CSV Parquet 27,630
2015 PF-P99-T42-PROF-FEES-OTH-2015 CSV Parquet 25,482
2014 PF-P99-T42-PROF-FEES-OTH-2014 CSV Parquet 22,601
2013 PF-P99-T42-PROF-FEES-OTH-2013 CSV Parquet 18,930
2012 PF-P99-T42-PROF-FEES-OTH-2012 CSV Parquet 15,735
2011 PF-P99-T42-PROF-FEES-OTH-2011 CSV Parquet 12,926
2010 PF-P99-T42-PROF-FEES-OTH-2010 CSV Parquet 9,196
2009 PF-P99-T42-PROF-FEES-OTH-2009 CSV Parquet 954
Back to contents

PF-P99-T43-OFF-OTH

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

Year Table CSV Parquet Rows
2024 PF-P99-T43-OFF-OTH-2024 CSV Parquet 233
2023 PF-P99-T43-OFF-OTH-2023 CSV Parquet 347
2022 PF-P99-T43-OFF-OTH-2022 CSV Parquet 288
2021 PF-P99-T43-OFF-OTH-2021 CSV Parquet 259
2020 PF-P99-T43-OFF-OTH-2020 CSV Parquet 222
2019 PF-P99-T43-OFF-OTH-2019 CSV Parquet 208
2018 PF-P99-T43-OFF-OTH-2018 CSV Parquet 199
2017 PF-P99-T43-OFF-OTH-2017 CSV Parquet 197
2016 PF-P99-T43-OFF-OTH-2016 CSV Parquet 206
2015 PF-P99-T43-OFF-OTH-2015 CSV Parquet 190
2014 PF-P99-T43-OFF-OTH-2014 CSV Parquet 110
2013 PF-P99-T43-OFF-OTH-2013 CSV Parquet 99
2012 PF-P99-T43-OFF-OTH-2012 CSV Parquet 108
2011 PF-P99-T43-OFF-OTH-2011 CSV Parquet 102
2010 PF-P99-T43-OFF-OTH-2010 CSV Parquet 78
2009 PF-P99-T43-OFF-OTH-2009 CSV Parquet 3
Back to contents

PF-P99-T46-SALE-INV

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

Year Table CSV Parquet Rows
2024 PF-P99-T46-SALE-INV-2024 CSV Parquet 1,241
2023 PF-P99-T46-SALE-INV-2023 CSV Parquet 1,393
2022 PF-P99-T46-SALE-INV-2022 CSV Parquet 1,289
2021 PF-P99-T46-SALE-INV-2021 CSV Parquet 1,161
2020 PF-P99-T46-SALE-INV-2020 CSV Parquet 1,053
2019 PF-P99-T46-SALE-INV-2019 CSV Parquet 786
2018 PF-P99-T46-SALE-INV-2018 CSV Parquet 661
2017 PF-P99-T46-SALE-INV-2017 CSV Parquet 584
2016 PF-P99-T46-SALE-INV-2016 CSV Parquet 533
2015 PF-P99-T46-SALE-INV-2015 CSV Parquet 516
2014 PF-P99-T46-SALE-INV-2014 CSV Parquet 458
2013 PF-P99-T46-SALE-INV-2013 CSV Parquet 363
2012 PF-P99-T46-SALE-INV-2012 CSV Parquet 290
2011 PF-P99-T46-SALE-INV-2011 CSV Parquet 251
2010 PF-P99-T46-SALE-INV-2010 CSV Parquet 195
2009 PF-P99-T46-SALE-INV-2009 CSV Parquet 36
Back to contents

PF-P99-T48-CONTRIBUTOR

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

Year Table CSV Parquet Rows
2024 PF-P99-T48-CONTRIBUTOR-2024 CSV Parquet 12,006
2023 PF-P99-T48-CONTRIBUTOR-2023 CSV Parquet 13,024
2022 PF-P99-T48-CONTRIBUTOR-2022 CSV Parquet 13,124
2021 PF-P99-T48-CONTRIBUTOR-2021 CSV Parquet 13,711
2020 PF-P99-T48-CONTRIBUTOR-2020 CSV Parquet 12,330
2019 PF-P99-T48-CONTRIBUTOR-2019 CSV Parquet 9,196
2018 PF-P99-T48-CONTRIBUTOR-2018 CSV Parquet 8,204
2017 PF-P99-T48-CONTRIBUTOR-2017 CSV Parquet 7,904
2016 PF-P99-T48-CONTRIBUTOR-2016 CSV Parquet 7,289
2015 PF-P99-T48-CONTRIBUTOR-2015 CSV Parquet 7,127
2014 PF-P99-T48-CONTRIBUTOR-2014 CSV Parquet 7,254
2013 PF-P99-T48-CONTRIBUTOR-2013 CSV Parquet 6,317
2012 PF-P99-T48-CONTRIBUTOR-2012 CSV Parquet 5,427
2011 PF-P99-T48-CONTRIBUTOR-2011 CSV Parquet 4,512
2010 PF-P99-T48-CONTRIBUTOR-2010 CSV Parquet 3,242
2009 PF-P99-T48-CONTRIBUTOR-2009 CSV Parquet 213
Back to contents

PF-P99-T49-TAXES

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

Year Table CSV Parquet Rows
2024 PF-P99-T49-TAXES-2024 CSV Parquet 153,633
2023 PF-P99-T49-TAXES-2023 CSV Parquet 145,439
2022 PF-P99-T49-TAXES-2022 CSV Parquet 170,590
2021 PF-P99-T49-TAXES-2021 CSV Parquet 160,020
2020 PF-P99-T49-TAXES-2020 CSV Parquet 160,828
2019 PF-P99-T49-TAXES-2019 CSV Parquet 122,793
2018 PF-P99-T49-TAXES-2018 CSV Parquet 110,384
2017 PF-P99-T49-TAXES-2017 CSV Parquet 86,791
2016 PF-P99-T49-TAXES-2016 CSV Parquet 80,653
2015 PF-P99-T49-TAXES-2015 CSV Parquet 76,685
2014 PF-P99-T49-TAXES-2014 CSV Parquet 71,195
2013 PF-P99-T49-TAXES-2013 CSV Parquet 55,655
2012 PF-P99-T49-TAXES-2012 CSV Parquet 46,540
2011 PF-P99-T49-TAXES-2011 CSV Parquet 42,483
2010 PF-P99-T49-TAXES-2010 CSV Parquet 28,006
2009 PF-P99-T49-TAXES-2009 CSV Parquet 2,521
Back to contents

PF-P99-T51-TRANSFER-FROM-CE

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

Year Table CSV Parquet Rows
2024 PF-P99-T51-TRANSFER-FROM-CE-2024 CSV Parquet 348
2023 PF-P99-T51-TRANSFER-FROM-CE-2023 CSV Parquet 376
2022 PF-P99-T51-TRANSFER-FROM-CE-2022 CSV Parquet 328
2021 PF-P99-T51-TRANSFER-FROM-CE-2021 CSV Parquet 342
2020 PF-P99-T51-TRANSFER-FROM-CE-2020 CSV Parquet 271
2019 PF-P99-T51-TRANSFER-FROM-CE-2019 CSV Parquet 219
2018 PF-P99-T51-TRANSFER-FROM-CE-2018 CSV Parquet 131
2017 PF-P99-T51-TRANSFER-FROM-CE-2017 CSV Parquet 113
2016 PF-P99-T51-TRANSFER-FROM-CE-2016 CSV Parquet 113
2015 PF-P99-T51-TRANSFER-FROM-CE-2015 CSV Parquet 111
2014 PF-P99-T51-TRANSFER-FROM-CE-2014 CSV Parquet 122
2013 PF-P99-T51-TRANSFER-FROM-CE-2013 CSV Parquet 93
2012 PF-P99-T51-TRANSFER-FROM-CE-2012 CSV Parquet 94
2011 PF-P99-T51-TRANSFER-FROM-CE-2011 CSV Parquet 76
2010 PF-P99-T51-TRANSFER-FROM-CE-2010 CSV Parquet 63
2009 PF-P99-T51-TRANSFER-FROM-CE-2009 CSV Parquet 28
Back to contents

PF-P99-T52-TRANSFER-TO-CE

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

Year Table CSV Parquet Rows
2024 PF-P99-T52-TRANSFER-TO-CE-2024 CSV Parquet 415
2023 PF-P99-T52-TRANSFER-TO-CE-2023 CSV Parquet 398
2022 PF-P99-T52-TRANSFER-TO-CE-2022 CSV Parquet 403
2021 PF-P99-T52-TRANSFER-TO-CE-2021 CSV Parquet 370
2020 PF-P99-T52-TRANSFER-TO-CE-2020 CSV Parquet 365
2019 PF-P99-T52-TRANSFER-TO-CE-2019 CSV Parquet 214
2018 PF-P99-T52-TRANSFER-TO-CE-2018 CSV Parquet 155
2017 PF-P99-T52-TRANSFER-TO-CE-2017 CSV Parquet 148
2016 PF-P99-T52-TRANSFER-TO-CE-2016 CSV Parquet 116
2015 PF-P99-T52-TRANSFER-TO-CE-2015 CSV Parquet 125
2014 PF-P99-T52-TRANSFER-TO-CE-2014 CSV Parquet 151
2013 PF-P99-T52-TRANSFER-TO-CE-2013 CSV Parquet 108
2012 PF-P99-T52-TRANSFER-TO-CE-2012 CSV Parquet 112
2011 PF-P99-T52-TRANSFER-TO-CE-2011 CSV Parquet 88
2010 PF-P99-T52-TRANSFER-TO-CE-2010 CSV Parquet 63
2009 PF-P99-T52-TRANSFER-TO-CE-2009 CSV Parquet 12
Back to contents

PF-P99-T14-COMP-EMPL

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

Year Table CSV Parquet Rows
2024 PF-P99-T14-COMP-EMPL-2024 CSV Parquet 84
2023 PF-P99-T14-COMP-EMPL-2023 CSV Parquet 89
2022 PF-P99-T14-COMP-EMPL-2022 CSV Parquet 123
2021 PF-P99-T14-COMP-EMPL-2021 CSV Parquet 122
2020 PF-P99-T14-COMP-EMPL-2020 CSV Parquet 143
2019 PF-P99-T14-COMP-EMPL-2019 CSV Parquet 87
2018 PF-P99-T14-COMP-EMPL-2018 CSV Parquet 42
2017 PF-P99-T14-COMP-EMPL-2017 CSV Parquet 48
2016 PF-P99-T14-COMP-EMPL-2016 CSV Parquet 36
2015 PF-P99-T14-COMP-EMPL-2015 CSV Parquet 38
2014 PF-P99-T14-COMP-EMPL-2014 CSV Parquet 35
2013 PF-P99-T14-COMP-EMPL-2013 CSV Parquet 187
2012 PF-P99-T14-COMP-EMPL-2012 CSV Parquet 158
2011 PF-P99-T14-COMP-EMPL-2011 CSV Parquet 134
2010 PF-P99-T14-COMP-EMPL-2010 CSV Parquet 234
2009 PF-P99-T14-COMP-EMPL-2009 CSV Parquet 32
Back to contents

Table list and row counts: efile/ROW-COUNTS-EFILEPF_V2_3.csv. Page rendered 2026-10-23.