990 Efile Data Catalog
Archived interim release · efile_v2_2
This build adds about 500,000 late-arriving filings for tax years 2022–2024 and introduces tax year 2024. It is purely additive: no previously published filings were revised. Details are in the release note; all data releases are listed on the data release notes page.
| Release | efile_v2_2 (published 2026-08-11) |
| Returns | Form 990 and Form 990-EZ, with schedules |
| Tax years | 2009–2024 |
| Tables | 111 tables, 1,698 table-year files |
| Filings | 5,675,704 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_2" ),
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
|
990-PF | 2026-10-07 | Interim | 2009–2024 | 84 | 1,151,314 | — |
efile_v2_2 this page
|
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,675,704 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P00-T00-HEADER-2024
|
CSV | Parquet | 159,496 |
| 2023 |
F9-P00-T00-HEADER-2023
|
CSV | Parquet | 527,764 |
| 2022 |
F9-P00-T00-HEADER-2022
|
CSV | Parquet | 553,554 |
| 2021 |
F9-P00-T00-HEADER-2021
|
CSV | Parquet | 539,238 |
| 2020 |
F9-P00-T00-HEADER-2020
|
CSV | Parquet | 515,679 |
| 2019 |
F9-P00-T00-HEADER-2019
|
CSV | Parquet | 437,203 |
| 2018 |
F9-P00-T00-HEADER-2018
|
CSV | Parquet | 420,826 |
| 2017 |
F9-P00-T00-HEADER-2017
|
CSV | Parquet | 400,756 |
| 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 |
P01 Part I - Summary
F9-P01-T00-SUMMARY
1:1 one row per filing · tax years 2009–2024 · 5,663,534 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P01-T00-SUMMARY-2024
|
CSV | Parquet | 158,843 |
| 2023 |
F9-P01-T00-SUMMARY-2023
|
CSV | Parquet | 526,235 |
| 2022 |
F9-P01-T00-SUMMARY-2022
|
CSV | Parquet | 551,869 |
| 2021 |
F9-P01-T00-SUMMARY-2021
|
CSV | Parquet | 537,670 |
| 2020 |
F9-P01-T00-SUMMARY-2020
|
CSV | Parquet | 514,469 |
| 2019 |
F9-P01-T00-SUMMARY-2019
|
CSV | Parquet | 436,289 |
| 2018 |
F9-P01-T00-SUMMARY-2018
|
CSV | Parquet | 419,877 |
| 2017 |
F9-P01-T00-SUMMARY-2017
|
CSV | Parquet | 400,002 |
| 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 |
F9-P01-T00-SUMMARY-EZ
1:1 one row per filing · tax years 2009–2024 · 1,944,198 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P01-T00-SUMMARY-EZ-2024
|
CSV | Parquet | 75,837 |
| 2023 |
F9-P01-T00-SUMMARY-EZ-2023
|
CSV | Parquet | 188,020 |
| 2022 |
F9-P01-T00-SUMMARY-EZ-2022
|
CSV | Parquet | 194,416 |
| 2021 |
F9-P01-T00-SUMMARY-EZ-2021
|
CSV | Parquet | 191,964 |
| 2020 |
F9-P01-T00-SUMMARY-EZ-2020
|
CSV | Parquet | 163,628 |
| 2019 |
F9-P01-T00-SUMMARY-EZ-2019
|
CSV | Parquet | 146,275 |
| 2018 |
F9-P01-T00-SUMMARY-EZ-2018
|
CSV | Parquet | 143,391 |
| 2017 |
F9-P01-T00-SUMMARY-EZ-2017
|
CSV | Parquet | 134,134 |
| 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 |
P02 Part II - Signature Block
F9-P02-T00-SIGNATURE
1:1 one row per filing · tax years 2009–2024 · 5,675,704 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P02-T00-SIGNATURE-2024
|
CSV | Parquet | 159,496 |
| 2023 |
F9-P02-T00-SIGNATURE-2023
|
CSV | Parquet | 527,764 |
| 2022 |
F9-P02-T00-SIGNATURE-2022
|
CSV | Parquet | 553,554 |
| 2021 |
F9-P02-T00-SIGNATURE-2021
|
CSV | Parquet | 539,238 |
| 2020 |
F9-P02-T00-SIGNATURE-2020
|
CSV | Parquet | 515,679 |
| 2019 |
F9-P02-T00-SIGNATURE-2019
|
CSV | Parquet | 437,203 |
| 2018 |
F9-P02-T00-SIGNATURE-2018
|
CSV | Parquet | 420,826 |
| 2017 |
F9-P02-T00-SIGNATURE-2017
|
CSV | Parquet | 400,756 |
| 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 |
P03 Part III - Statement of Program Service Accomplishments
F9-P03-T00-MISSION
1:1 one row per filing · tax years 2009–2024 · 5,675,599 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P03-T00-MISSION-2024
|
CSV | Parquet | 159,474 |
| 2023 |
F9-P03-T00-MISSION-2023
|
CSV | Parquet | 527,744 |
| 2022 |
F9-P03-T00-MISSION-2022
|
CSV | Parquet | 553,542 |
| 2021 |
F9-P03-T00-MISSION-2021
|
CSV | Parquet | 539,226 |
| 2020 |
F9-P03-T00-MISSION-2020
|
CSV | Parquet | 515,668 |
| 2019 |
F9-P03-T00-MISSION-2019
|
CSV | Parquet | 437,197 |
| 2018 |
F9-P03-T00-MISSION-2018
|
CSV | Parquet | 420,824 |
| 2017 |
F9-P03-T00-MISSION-2017
|
CSV | Parquet | 400,756 |
| 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 |
F9-P03-T00-PROGRAM-ONE
1:1 one row per filing · tax years 2009–2024 · 3,644,173 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P03-T00-PROGRAM-ONE-2024
|
CSV | Parquet | 78,815 |
| 2023 |
F9-P03-T00-PROGRAM-ONE-2023
|
CSV | Parquet | 329,036 |
| 2022 |
F9-P03-T00-PROGRAM-ONE-2022
|
CSV | Parquet | 348,027 |
| 2021 |
F9-P03-T00-PROGRAM-ONE-2021
|
CSV | Parquet | 336,513 |
| 2020 |
F9-P03-T00-PROGRAM-ONE-2020
|
CSV | Parquet | 343,789 |
| 2019 |
F9-P03-T00-PROGRAM-ONE-2019
|
CSV | Parquet | 284,515 |
| 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 |
F9-P03-T00-PROGRAM-THREE
1:1 one row per filing · tax years 2009–2024 · 777,165 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P03-T00-PROGRAM-THREE-2024
|
CSV | Parquet | 15,258 |
| 2023 |
F9-P03-T00-PROGRAM-THREE-2023
|
CSV | Parquet | 69,949 |
| 2022 |
F9-P03-T00-PROGRAM-THREE-2022
|
CSV | Parquet | 74,208 |
| 2021 |
F9-P03-T00-PROGRAM-THREE-2021
|
CSV | Parquet | 70,919 |
| 2020 |
F9-P03-T00-PROGRAM-THREE-2020
|
CSV | Parquet | 72,861 |
| 2019 |
F9-P03-T00-PROGRAM-THREE-2019
|
CSV | Parquet | 58,761 |
| 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 |
F9-P03-T00-PROGRAM-TWO
1:1 one row per filing · tax years 2009–2024 · 1,104,073 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P03-T00-PROGRAM-TWO-2024
|
CSV | Parquet | 21,264 |
| 2023 |
F9-P03-T00-PROGRAM-TWO-2023
|
CSV | Parquet | 98,160 |
| 2022 |
F9-P03-T00-PROGRAM-TWO-2022
|
CSV | Parquet | 104,405 |
| 2021 |
F9-P03-T00-PROGRAM-TWO-2021
|
CSV | Parquet | 100,672 |
| 2020 |
F9-P03-T00-PROGRAM-TWO-2020
|
CSV | Parquet | 103,836 |
| 2019 |
F9-P03-T00-PROGRAM-TWO-2019
|
CSV | Parquet | 84,552 |
| 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 |
F9-P03-T00-PROGRAMS
1:1 one row per filing · tax years 2009–2024 · 5,023,620 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P03-T00-PROGRAMS-2024
|
CSV | Parquet | 137,745 |
| 2023 |
F9-P03-T00-PROGRAMS-2023
|
CSV | Parquet | 467,217 |
| 2022 |
F9-P03-T00-PROGRAMS-2022
|
CSV | Parquet | 491,088 |
| 2021 |
F9-P03-T00-PROGRAMS-2021
|
CSV | Parquet | 477,639 |
| 2020 |
F9-P03-T00-PROGRAMS-2020
|
CSV | Parquet | 457,846 |
| 2019 |
F9-P03-T00-PROGRAMS-2019
|
CSV | Parquet | 388,354 |
| 2018 |
F9-P03-T00-PROGRAMS-2018
|
CSV | Parquet | 373,616 |
| 2017 |
F9-P03-T00-PROGRAMS-2017
|
CSV | Parquet | 354,450 |
| 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 |
F9-P03-T01-PROGRAMS-OTHER
1:M many rows per filing · tax years 2009–2024 · 676,210 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P03-T01-PROGRAMS-OTHER-2024
|
CSV | Parquet | 13,892 |
| 2023 |
F9-P03-T01-PROGRAMS-OTHER-2023
|
CSV | Parquet | 54,359 |
| 2022 |
F9-P03-T01-PROGRAMS-OTHER-2022
|
CSV | Parquet | 58,514 |
| 2021 |
F9-P03-T01-PROGRAMS-OTHER-2021
|
CSV | Parquet | 57,174 |
| 2020 |
F9-P03-T01-PROGRAMS-OTHER-2020
|
CSV | Parquet | 60,297 |
| 2019 |
F9-P03-T01-PROGRAMS-OTHER-2019
|
CSV | Parquet | 50,606 |
| 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,098 |
| 2010 |
F9-P03-T01-PROGRAMS-OTHER-2010
|
CSV | Parquet | 27,290 |
| 2009 |
F9-P03-T01-PROGRAMS-OTHER-2009
|
CSV | Parquet | 10,184 |
F9-P03-T02-PROGRAMS-EZ
1:M many rows per filing · tax years 2009–2024 · 3,066,216 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P03-T02-PROGRAMS-EZ-2024
|
CSV | Parquet | 123,858 |
| 2023 |
F9-P03-T02-PROGRAMS-EZ-2023
|
CSV | Parquet | 308,488 |
| 2022 |
F9-P03-T02-PROGRAMS-EZ-2022
|
CSV | Parquet | 316,610 |
| 2021 |
F9-P03-T02-PROGRAMS-EZ-2021
|
CSV | Parquet | 309,709 |
| 2020 |
F9-P03-T02-PROGRAMS-EZ-2020
|
CSV | Parquet | 255,915 |
| 2019 |
F9-P03-T02-PROGRAMS-EZ-2019
|
CSV | Parquet | 227,934 |
| 2018 |
F9-P03-T02-PROGRAMS-EZ-2018
|
CSV | Parquet | 220,933 |
| 2017 |
F9-P03-T02-PROGRAMS-EZ-2017
|
CSV | Parquet | 207,324 |
| 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 |
P04 Part IV - Checklist of Required Schedules
F9-P04-T00-REQUIRED-SCHEDULES
1:1 one row per filing · tax years 2009–2024 · 5,675,704 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P04-T00-REQUIRED-SCHEDULES-2024
|
CSV | Parquet | 159,496 |
| 2023 |
F9-P04-T00-REQUIRED-SCHEDULES-2023
|
CSV | Parquet | 527,764 |
| 2022 |
F9-P04-T00-REQUIRED-SCHEDULES-2022
|
CSV | Parquet | 553,554 |
| 2021 |
F9-P04-T00-REQUIRED-SCHEDULES-2021
|
CSV | Parquet | 539,238 |
| 2020 |
F9-P04-T00-REQUIRED-SCHEDULES-2020
|
CSV | Parquet | 515,679 |
| 2019 |
F9-P04-T00-REQUIRED-SCHEDULES-2019
|
CSV | Parquet | 437,203 |
| 2018 |
F9-P04-T00-REQUIRED-SCHEDULES-2018
|
CSV | Parquet | 420,826 |
| 2017 |
F9-P04-T00-REQUIRED-SCHEDULES-2017
|
CSV | Parquet | 400,756 |
| 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 |
F9-P04-T00-REQUIRED-SCHEDULES-EZ
1:1 one row per filing · tax years 2009–2024 · 255,759 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P04-T00-REQUIRED-SCHEDULES-EZ-2024
|
CSV | Parquet | 4,668 |
| 2023 |
F9-P04-T00-REQUIRED-SCHEDULES-EZ-2023
|
CSV | Parquet | 11,395 |
| 2022 |
F9-P04-T00-REQUIRED-SCHEDULES-EZ-2022
|
CSV | Parquet | 9,958 |
| 2021 |
F9-P04-T00-REQUIRED-SCHEDULES-EZ-2021
|
CSV | Parquet | 9,440 |
| 2020 |
F9-P04-T00-REQUIRED-SCHEDULES-EZ-2020
|
CSV | Parquet | 8,836 |
| 2019 |
F9-P04-T00-REQUIRED-SCHEDULES-EZ-2019
|
CSV | Parquet | 7,583 |
| 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 |
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,675,704 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P05-T00-OTHER-IRS-FILING-2024
|
CSV | Parquet | 159,496 |
| 2023 |
F9-P05-T00-OTHER-IRS-FILING-2023
|
CSV | Parquet | 527,764 |
| 2022 |
F9-P05-T00-OTHER-IRS-FILING-2022
|
CSV | Parquet | 553,554 |
| 2021 |
F9-P05-T00-OTHER-IRS-FILING-2021
|
CSV | Parquet | 539,238 |
| 2020 |
F9-P05-T00-OTHER-IRS-FILING-2020
|
CSV | Parquet | 515,679 |
| 2019 |
F9-P05-T00-OTHER-IRS-FILING-2019
|
CSV | Parquet | 437,203 |
| 2018 |
F9-P05-T00-OTHER-IRS-FILING-2018
|
CSV | Parquet | 420,826 |
| 2017 |
F9-P05-T00-OTHER-IRS-FILING-2017
|
CSV | Parquet | 400,756 |
| 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 |
P06 Part VI - Governance, Management, and Disclosure
F9-P06-T00-GOVERNANCE
1:1 one row per filing · tax years 2009–2024 · 5,675,704 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P06-T00-GOVERNANCE-2024
|
CSV | Parquet | 159,496 |
| 2023 |
F9-P06-T00-GOVERNANCE-2023
|
CSV | Parquet | 527,764 |
| 2022 |
F9-P06-T00-GOVERNANCE-2022
|
CSV | Parquet | 553,554 |
| 2021 |
F9-P06-T00-GOVERNANCE-2021
|
CSV | Parquet | 539,238 |
| 2020 |
F9-P06-T00-GOVERNANCE-2020
|
CSV | Parquet | 515,679 |
| 2019 |
F9-P06-T00-GOVERNANCE-2019
|
CSV | Parquet | 437,203 |
| 2018 |
F9-P06-T00-GOVERNANCE-2018
|
CSV | Parquet | 420,826 |
| 2017 |
F9-P06-T00-GOVERNANCE-2017
|
CSV | Parquet | 400,756 |
| 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 |
F9-P06-T00-GOVERNANCE-EZ
1:1 one row per filing · tax years 2009–2024 · 2,031,531 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P06-T00-GOVERNANCE-EZ-2024
|
CSV | Parquet | 80,681 |
| 2023 |
F9-P06-T00-GOVERNANCE-EZ-2023
|
CSV | Parquet | 198,728 |
| 2022 |
F9-P06-T00-GOVERNANCE-EZ-2022
|
CSV | Parquet | 205,527 |
| 2021 |
F9-P06-T00-GOVERNANCE-EZ-2021
|
CSV | Parquet | 202,725 |
| 2020 |
F9-P06-T00-GOVERNANCE-EZ-2020
|
CSV | Parquet | 171,890 |
| 2019 |
F9-P06-T00-GOVERNANCE-EZ-2019
|
CSV | Parquet | 152,688 |
| 2018 |
F9-P06-T00-GOVERNANCE-EZ-2018
|
CSV | Parquet | 149,384 |
| 2017 |
F9-P06-T00-GOVERNANCE-EZ-2017
|
CSV | Parquet | 139,144 |
| 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 |
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,211,322 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P07-T00-DIR-TRUST-KEY-2024
|
CSV | Parquet | 142,559 |
| 2023 |
F9-P07-T00-DIR-TRUST-KEY-2023
|
CSV | Parquet | 485,469 |
| 2022 |
F9-P07-T00-DIR-TRUST-KEY-2022
|
CSV | Parquet | 514,597 |
| 2021 |
F9-P07-T00-DIR-TRUST-KEY-2021
|
CSV | Parquet | 500,756 |
| 2020 |
F9-P07-T00-DIR-TRUST-KEY-2020
|
CSV | Parquet | 482,345 |
| 2019 |
F9-P07-T00-DIR-TRUST-KEY-2019
|
CSV | Parquet | 409,653 |
| 2018 |
F9-P07-T00-DIR-TRUST-KEY-2018
|
CSV | Parquet | 394,272 |
| 2017 |
F9-P07-T00-DIR-TRUST-KEY-2017
|
CSV | Parquet | 375,312 |
| 2016 |
F9-P07-T00-DIR-TRUST-KEY-2016
|
CSV | Parquet | 339,383 |
| 2015 |
F9-P07-T00-DIR-TRUST-KEY-2015
|
CSV | Parquet | 324,398 |
| 2014 |
F9-P07-T00-DIR-TRUST-KEY-2014
|
CSV | Parquet | 302,147 |
| 2013 |
F9-P07-T00-DIR-TRUST-KEY-2013
|
CSV | Parquet | 273,309 |
| 2012 |
F9-P07-T00-DIR-TRUST-KEY-2012
|
CSV | Parquet | 246,256 |
| 2011 |
F9-P07-T00-DIR-TRUST-KEY-2011
|
CSV | Parquet | 218,939 |
| 2010 |
F9-P07-T00-DIR-TRUST-KEY-2010
|
CSV | Parquet | 168,383 |
| 2009 |
F9-P07-T00-DIR-TRUST-KEY-2009
|
CSV | Parquet | 33,544 |
F9-P07-T01-COMPENSATION
1:M many rows per filing · tax years 2009–2024 · 55,829,192 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P07-T01-COMPENSATION-2024
|
CSV | Parquet | 1,125,095 |
| 2023 |
F9-P07-T01-COMPENSATION-2023
|
CSV | Parquet | 4,710,935 |
| 2022 |
F9-P07-T01-COMPENSATION-2022
|
CSV | Parquet | 5,059,549 |
| 2021 |
F9-P07-T01-COMPENSATION-2021
|
CSV | Parquet | 4,976,271 |
| 2020 |
F9-P07-T01-COMPENSATION-2020
|
CSV | Parquet | 4,988,251 |
| 2019 |
F9-P07-T01-COMPENSATION-2019
|
CSV | Parquet | 4,280,855 |
| 2018 |
F9-P07-T01-COMPENSATION-2018
|
CSV | Parquet | 4,142,095 |
| 2017 |
F9-P07-T01-COMPENSATION-2017
|
CSV | Parquet | 4,044,177 |
| 2016 |
F9-P07-T01-COMPENSATION-2016
|
CSV | Parquet | 3,795,552 |
| 2015 |
F9-P07-T01-COMPENSATION-2015
|
CSV | Parquet | 3,671,256 |
| 2014 |
F9-P07-T01-COMPENSATION-2014
|
CSV | Parquet | 3,478,037 |
| 2013 |
F9-P07-T01-COMPENSATION-2013
|
CSV | Parquet | 3,199,630 |
| 2012 |
F9-P07-T01-COMPENSATION-2012
|
CSV | Parquet | 2,935,442 |
| 2011 |
F9-P07-T01-COMPENSATION-2011
|
CSV | Parquet | 2,635,077 |
| 2010 |
F9-P07-T01-COMPENSATION-2010
|
CSV | Parquet | 2,081,865 |
| 2009 |
F9-P07-T01-COMPENSATION-2009
|
CSV | Parquet | 705,105 |
F9-P07-T01-COMPENSATION-HCE-EZ
1:M many rows per filing · tax years 2009–2024 · 1,660,419 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P07-T01-COMPENSATION-HCE-EZ-2024
|
CSV | Parquet | 68,104 |
| 2023 |
F9-P07-T01-COMPENSATION-HCE-EZ-2023
|
CSV | Parquet | 165,451 |
| 2022 |
F9-P07-T01-COMPENSATION-HCE-EZ-2022
|
CSV | Parquet | 170,314 |
| 2021 |
F9-P07-T01-COMPENSATION-HCE-EZ-2021
|
CSV | Parquet | 167,103 |
| 2020 |
F9-P07-T01-COMPENSATION-HCE-EZ-2020
|
CSV | Parquet | 140,076 |
| 2019 |
F9-P07-T01-COMPENSATION-HCE-EZ-2019
|
CSV | Parquet | 125,495 |
| 2018 |
F9-P07-T01-COMPENSATION-HCE-EZ-2018
|
CSV | Parquet | 123,659 |
| 2017 |
F9-P07-T01-COMPENSATION-HCE-EZ-2017
|
CSV | Parquet | 114,174 |
| 2016 |
F9-P07-T01-COMPENSATION-HCE-EZ-2016
|
CSV | Parquet | 106,552 |
| 2015 |
F9-P07-T01-COMPENSATION-HCE-EZ-2015
|
CSV | Parquet | 101,659 |
| 2014 |
F9-P07-T01-COMPENSATION-HCE-EZ-2014
|
CSV | Parquet | 94,288 |
| 2013 |
F9-P07-T01-COMPENSATION-HCE-EZ-2013
|
CSV | Parquet | 83,926 |
| 2012 |
F9-P07-T01-COMPENSATION-HCE-EZ-2012
|
CSV | Parquet | 75,467 |
| 2011 |
F9-P07-T01-COMPENSATION-HCE-EZ-2011
|
CSV | Parquet | 66,647 |
| 2010 |
F9-P07-T01-COMPENSATION-HCE-EZ-2010
|
CSV | Parquet | 45,106 |
| 2009 |
F9-P07-T01-COMPENSATION-HCE-EZ-2009
|
CSV | Parquet | 12,398 |
F9-P07-T02-CONTRACTORS
1:M many rows per filing · tax years 2009–2024 · 2,987,953 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P07-T02-CONTRACTORS-2024
|
CSV | Parquet | 79,356 |
| 2023 |
F9-P07-T02-CONTRACTORS-2023
|
CSV | Parquet | 275,340 |
| 2022 |
F9-P07-T02-CONTRACTORS-2022
|
CSV | Parquet | 291,396 |
| 2021 |
F9-P07-T02-CONTRACTORS-2021
|
CSV | Parquet | 279,012 |
| 2020 |
F9-P07-T02-CONTRACTORS-2020
|
CSV | Parquet | 252,868 |
| 2019 |
F9-P07-T02-CONTRACTORS-2019
|
CSV | Parquet | 227,140 |
| 2018 |
F9-P07-T02-CONTRACTORS-2018
|
CSV | Parquet | 221,887 |
| 2017 |
F9-P07-T02-CONTRACTORS-2017
|
CSV | Parquet | 211,411 |
| 2016 |
F9-P07-T02-CONTRACTORS-2016
|
CSV | Parquet | 195,426 |
| 2015 |
F9-P07-T02-CONTRACTORS-2015
|
CSV | Parquet | 187,031 |
| 2014 |
F9-P07-T02-CONTRACTORS-2014
|
CSV | Parquet | 175,222 |
| 2013 |
F9-P07-T02-CONTRACTORS-2013
|
CSV | Parquet | 160,174 |
| 2012 |
F9-P07-T02-CONTRACTORS-2012
|
CSV | Parquet | 147,872 |
| 2011 |
F9-P07-T02-CONTRACTORS-2011
|
CSV | Parquet | 135,074 |
| 2010 |
F9-P07-T02-CONTRACTORS-2010
|
CSV | Parquet | 106,081 |
| 2009 |
F9-P07-T02-CONTRACTORS-2009
|
CSV | Parquet | 42,663 |
P08 Part VIII - Statement of Revenue
F9-P08-T00-REVENUE
1:1 one row per filing · tax years 2009–2024 · 5,353,473 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P08-T00-REVENUE-2024
|
CSV | Parquet | 145,095 |
| 2023 |
F9-P08-T00-REVENUE-2023
|
CSV | Parquet | 493,193 |
| 2022 |
F9-P08-T00-REVENUE-2022
|
CSV | Parquet | 517,053 |
| 2021 |
F9-P08-T00-REVENUE-2021
|
CSV | Parquet | 503,654 |
| 2020 |
F9-P08-T00-REVENUE-2020
|
CSV | Parquet | 484,448 |
| 2019 |
F9-P08-T00-REVENUE-2019
|
CSV | Parquet | 410,656 |
| 2018 |
F9-P08-T00-REVENUE-2018
|
CSV | Parquet | 395,977 |
| 2017 |
F9-P08-T00-REVENUE-2017
|
CSV | Parquet | 378,913 |
| 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 |
F9-P08-T01-REVENUE-PROGRAMS
1:M many rows per filing · tax years 2009–2024 · 5,633,575 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P08-T01-REVENUE-PROGRAMS-2024
|
CSV | Parquet | 92,650 |
| 2023 |
F9-P08-T01-REVENUE-PROGRAMS-2023
|
CSV | Parquet | 441,040 |
| 2022 |
F9-P08-T01-REVENUE-PROGRAMS-2022
|
CSV | Parquet | 471,916 |
| 2021 |
F9-P08-T01-REVENUE-PROGRAMS-2021
|
CSV | Parquet | 455,380 |
| 2020 |
F9-P08-T01-REVENUE-PROGRAMS-2020
|
CSV | Parquet | 465,729 |
| 2019 |
F9-P08-T01-REVENUE-PROGRAMS-2019
|
CSV | Parquet | 407,102 |
| 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 | 411,565 |
| 2011 |
F9-P08-T01-REVENUE-PROGRAMS-2011
|
CSV | Parquet | 363,782 |
| 2010 |
F9-P08-T01-REVENUE-PROGRAMS-2010
|
CSV | Parquet | 283,207 |
| 2009 |
F9-P08-T01-REVENUE-PROGRAMS-2009
|
CSV | Parquet | 86,143 |
F9-P08-T02-REVENUE-MISC
1:M many rows per filing · tax years 2009–2024 · 2,060,354 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P08-T02-REVENUE-MISC-2024
|
CSV | Parquet | 36,509 |
| 2023 |
F9-P08-T02-REVENUE-MISC-2023
|
CSV | Parquet | 171,884 |
| 2022 |
F9-P08-T02-REVENUE-MISC-2022
|
CSV | Parquet | 184,554 |
| 2021 |
F9-P08-T02-REVENUE-MISC-2021
|
CSV | Parquet | 183,796 |
| 2020 |
F9-P08-T02-REVENUE-MISC-2020
|
CSV | Parquet | 191,827 |
| 2019 |
F9-P08-T02-REVENUE-MISC-2019
|
CSV | Parquet | 152,390 |
| 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 |
P09 Part IX - Statement of Functional Expenses
F9-P09-T00-EXPENSES
1:1 one row per filing · tax years 2009–2024 · 4,944,010 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P09-T00-EXPENSES-2024
|
CSV | Parquet | 131,364 |
| 2023 |
F9-P09-T00-EXPENSES-2023
|
CSV | Parquet | 453,826 |
| 2022 |
F9-P09-T00-EXPENSES-2022
|
CSV | Parquet | 477,675 |
| 2021 |
F9-P09-T00-EXPENSES-2021
|
CSV | Parquet | 464,734 |
| 2020 |
F9-P09-T00-EXPENSES-2020
|
CSV | Parquet | 448,048 |
| 2019 |
F9-P09-T00-EXPENSES-2019
|
CSV | Parquet | 378,623 |
| 2018 |
F9-P09-T00-EXPENSES-2018
|
CSV | Parquet | 364,285 |
| 2017 |
F9-P09-T00-EXPENSES-2017
|
CSV | Parquet | 349,048 |
| 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 |
F9-P09-T01-EXPENSES-OTHER
1:M many rows per filing · tax years 2009–2024 · 12,179,283 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P09-T01-EXPENSES-OTHER-2024
|
CSV | Parquet | 233,438 |
| 2023 |
F9-P09-T01-EXPENSES-OTHER-2023
|
CSV | Parquet | 1,005,864 |
| 2022 |
F9-P09-T01-EXPENSES-OTHER-2022
|
CSV | Parquet | 1,068,366 |
| 2021 |
F9-P09-T01-EXPENSES-OTHER-2021
|
CSV | Parquet | 1,031,882 |
| 2020 |
F9-P09-T01-EXPENSES-OTHER-2020
|
CSV | Parquet | 1,059,925 |
| 2019 |
F9-P09-T01-EXPENSES-OTHER-2019
|
CSV | Parquet | 900,739 |
| 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 | 765,732 |
| 2011 |
F9-P09-T01-EXPENSES-OTHER-2011
|
CSV | Parquet | 695,576 |
| 2010 |
F9-P09-T01-EXPENSES-OTHER-2010
|
CSV | Parquet | 607,830 |
| 2009 |
F9-P09-T01-EXPENSES-OTHER-2009
|
CSV | Parquet | 167,573 |
P10 Part X - Balance Sheet
F9-P10-T00-BALANCE-SHEET
1:1 one row per filing · tax years 2009–2024 · 5,675,704 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P10-T00-BALANCE-SHEET-2024
|
CSV | Parquet | 159,496 |
| 2023 |
F9-P10-T00-BALANCE-SHEET-2023
|
CSV | Parquet | 527,764 |
| 2022 |
F9-P10-T00-BALANCE-SHEET-2022
|
CSV | Parquet | 553,554 |
| 2021 |
F9-P10-T00-BALANCE-SHEET-2021
|
CSV | Parquet | 539,238 |
| 2020 |
F9-P10-T00-BALANCE-SHEET-2020
|
CSV | Parquet | 515,679 |
| 2019 |
F9-P10-T00-BALANCE-SHEET-2019
|
CSV | Parquet | 437,203 |
| 2018 |
F9-P10-T00-BALANCE-SHEET-2018
|
CSV | Parquet | 420,826 |
| 2017 |
F9-P10-T00-BALANCE-SHEET-2017
|
CSV | Parquet | 400,756 |
| 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 |
P11 Part XI - Reconciliation of Net Assets
F9-P11-T00-ASSETS
1:1 one row per filing · tax years 2009–2024 · 4,348,388 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P11-T00-ASSETS-2024
|
CSV | Parquet | 109,627 |
| 2023 |
F9-P11-T00-ASSETS-2023
|
CSV | Parquet | 406,152 |
| 2022 |
F9-P11-T00-ASSETS-2022
|
CSV | Parquet | 428,512 |
| 2021 |
F9-P11-T00-ASSETS-2021
|
CSV | Parquet | 416,859 |
| 2020 |
F9-P11-T00-ASSETS-2020
|
CSV | Parquet | 405,984 |
| 2019 |
F9-P11-T00-ASSETS-2019
|
CSV | Parquet | 336,963 |
| 2018 |
F9-P11-T00-ASSETS-2018
|
CSV | Parquet | 321,229 |
| 2017 |
F9-P11-T00-ASSETS-2017
|
CSV | Parquet | 308,777 |
| 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 |
P12 Part XII - Financial Statements and Reporting
F9-P12-T00-FINANCIAL-REPORTING
1:1 one row per filing · tax years 2009–2024 · 5,668,277 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
F9-P12-T00-FINANCIAL-REPORTING-2024
|
CSV | Parquet | 159,086 |
| 2023 |
F9-P12-T00-FINANCIAL-REPORTING-2023
|
CSV | Parquet | 526,868 |
| 2022 |
F9-P12-T00-FINANCIAL-REPORTING-2022
|
CSV | Parquet | 552,652 |
| 2021 |
F9-P12-T00-FINANCIAL-REPORTING-2021
|
CSV | Parquet | 538,367 |
| 2020 |
F9-P12-T00-FINANCIAL-REPORTING-2020
|
CSV | Parquet | 515,008 |
| 2019 |
F9-P12-T00-FINANCIAL-REPORTING-2019
|
CSV | Parquet | 436,555 |
| 2018 |
F9-P12-T00-FINANCIAL-REPORTING-2018
|
CSV | Parquet | 420,210 |
| 2017 |
F9-P12-T00-FINANCIAL-REPORTING-2017
|
CSV | Parquet | 400,247 |
| 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 |
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,357,047 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SA-P01-T00-PUBLIC-CHARITY-STATUS-2024
|
CSV | Parquet | 122,070 |
| 2023 |
SA-P01-T00-PUBLIC-CHARITY-STATUS-2023
|
CSV | Parquet | 409,608 |
| 2022 |
SA-P01-T00-PUBLIC-CHARITY-STATUS-2022
|
CSV | Parquet | 429,648 |
| 2021 |
SA-P01-T00-PUBLIC-CHARITY-STATUS-2021
|
CSV | Parquet | 415,583 |
| 2020 |
SA-P01-T00-PUBLIC-CHARITY-STATUS-2020
|
CSV | Parquet | 399,583 |
| 2019 |
SA-P01-T00-PUBLIC-CHARITY-STATUS-2019
|
CSV | Parquet | 337,970 |
| 2018 |
SA-P01-T00-PUBLIC-CHARITY-STATUS-2018
|
CSV | Parquet | 323,530 |
| 2017 |
SA-P01-T00-PUBLIC-CHARITY-STATUS-2017
|
CSV | Parquet | 307,658 |
| 2016 |
SA-P01-T00-PUBLIC-CHARITY-STATUS-2016
|
CSV | Parquet | 285,777 |
| 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 |
SA-P01-T01-PUBLIC-CHARITY-STATUS
1:M many rows per filing · tax years 2009–2024 · 811,425 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SA-P01-T01-PUBLIC-CHARITY-STATUS-2024
|
CSV | Parquet | 21,654 |
| 2023 |
SA-P01-T01-PUBLIC-CHARITY-STATUS-2023
|
CSV | Parquet | 80,511 |
| 2022 |
SA-P01-T01-PUBLIC-CHARITY-STATUS-2022
|
CSV | Parquet | 89,569 |
| 2021 |
SA-P01-T01-PUBLIC-CHARITY-STATUS-2021
|
CSV | Parquet | 88,759 |
| 2020 |
SA-P01-T01-PUBLIC-CHARITY-STATUS-2020
|
CSV | Parquet | 86,746 |
| 2019 |
SA-P01-T01-PUBLIC-CHARITY-STATUS-2019
|
CSV | Parquet | 74,089 |
| 2018 |
SA-P01-T01-PUBLIC-CHARITY-STATUS-2018
|
CSV | Parquet | 70,767 |
| 2017 |
SA-P01-T01-PUBLIC-CHARITY-STATUS-2017
|
CSV | Parquet | 40,300 |
| 2016 |
SA-P01-T01-PUBLIC-CHARITY-STATUS-2016
|
CSV | Parquet | 37,817 |
| 2015 |
SA-P01-T01-PUBLIC-CHARITY-STATUS-2015
|
CSV | Parquet | 36,121 |
| 2014 |
SA-P01-T01-PUBLIC-CHARITY-STATUS-2014
|
CSV | Parquet | 31,255 |
| 2013 |
SA-P01-T01-PUBLIC-CHARITY-STATUS-2013
|
CSV | Parquet | 71,444 |
| 2012 |
SA-P01-T01-PUBLIC-CHARITY-STATUS-2012
|
CSV | Parquet | 28,490 |
| 2011 |
SA-P01-T01-PUBLIC-CHARITY-STATUS-2011
|
CSV | Parquet | 25,184 |
| 2010 |
SA-P01-T01-PUBLIC-CHARITY-STATUS-2010
|
CSV | Parquet | 21,156 |
| 2009 |
SA-P01-T01-PUBLIC-CHARITY-STATUS-2009
|
CSV | Parquet | 7,563 |
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,171,844 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SA-P02-T00-SUPPORT_SCHEDULE_170-2024
|
CSV | Parquet | 57,316 |
| 2023 |
SA-P02-T00-SUPPORT_SCHEDULE_170-2023
|
CSV | Parquet | 195,217 |
| 2022 |
SA-P02-T00-SUPPORT_SCHEDULE_170-2022
|
CSV | Parquet | 204,751 |
| 2021 |
SA-P02-T00-SUPPORT_SCHEDULE_170-2021
|
CSV | Parquet | 205,038 |
| 2020 |
SA-P02-T00-SUPPORT_SCHEDULE_170-2020
|
CSV | Parquet | 199,388 |
| 2019 |
SA-P02-T00-SUPPORT_SCHEDULE_170-2019
|
CSV | Parquet | 170,922 |
| 2018 |
SA-P02-T00-SUPPORT_SCHEDULE_170-2018
|
CSV | Parquet | 164,085 |
| 2017 |
SA-P02-T00-SUPPORT_SCHEDULE_170-2017
|
CSV | Parquet | 156,457 |
| 2016 |
SA-P02-T00-SUPPORT_SCHEDULE_170-2016
|
CSV | Parquet | 145,837 |
| 2015 |
SA-P02-T00-SUPPORT_SCHEDULE_170-2015
|
CSV | Parquet | 139,071 |
| 2014 |
SA-P02-T00-SUPPORT_SCHEDULE_170-2014
|
CSV | Parquet | 129,772 |
| 2013 |
SA-P02-T00-SUPPORT_SCHEDULE_170-2013
|
CSV | Parquet | 116,516 |
| 2012 |
SA-P02-T00-SUPPORT_SCHEDULE_170-2012
|
CSV | Parquet | 105,504 |
| 2011 |
SA-P02-T00-SUPPORT_SCHEDULE_170-2011
|
CSV | Parquet | 92,911 |
| 2010 |
SA-P02-T00-SUPPORT_SCHEDULE_170-2010
|
CSV | Parquet | 71,178 |
| 2009 |
SA-P02-T00-SUPPORT_SCHEDULE_170-2009
|
CSV | Parquet | 17,881 |
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,175,970 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SA-P03-T00-SUPPORT_SCHEDULE_509-2024
|
CSV | Parquet | 67,381 |
| 2023 |
SA-P03-T00-SUPPORT_SCHEDULE_509-2023
|
CSV | Parquet | 206,257 |
| 2022 |
SA-P03-T00-SUPPORT_SCHEDULE_509-2022
|
CSV | Parquet | 213,088 |
| 2021 |
SA-P03-T00-SUPPORT_SCHEDULE_509-2021
|
CSV | Parquet | 205,373 |
| 2020 |
SA-P03-T00-SUPPORT_SCHEDULE_509-2020
|
CSV | Parquet | 191,908 |
| 2019 |
SA-P03-T00-SUPPORT_SCHEDULE_509-2019
|
CSV | Parquet | 171,394 |
| 2018 |
SA-P03-T00-SUPPORT_SCHEDULE_509-2018
|
CSV | Parquet | 165,469 |
| 2017 |
SA-P03-T00-SUPPORT_SCHEDULE_509-2017
|
CSV | Parquet | 155,504 |
| 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 |
P04 Part IV - Supporting Organizations
SA-P04-T00-SUPPORT-ORGS
1:1 one row per filing · tax years 2014–2024 · 204,476 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SA-P04-T00-SUPPORT-ORGS-2024
|
CSV | Parquet | 4,378 |
| 2023 |
SA-P04-T00-SUPPORT-ORGS-2023
|
CSV | Parquet | 21,278 |
| 2022 |
SA-P04-T00-SUPPORT-ORGS-2022
|
CSV | Parquet | 23,766 |
| 2021 |
SA-P04-T00-SUPPORT-ORGS-2021
|
CSV | Parquet | 23,572 |
| 2020 |
SA-P04-T00-SUPPORT-ORGS-2020
|
CSV | Parquet | 23,820 |
| 2019 |
SA-P04-T00-SUPPORT-ORGS-2019
|
CSV | Parquet | 19,918 |
| 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 |
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 · 42,520 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SA-P05-T00-SUPPORT-ORGS-2024
|
CSV | Parquet | 3,166 |
| 2023 |
SA-P05-T00-SUPPORT-ORGS-2023
|
CSV | Parquet | 6,303 |
| 2022 |
SA-P05-T00-SUPPORT-ORGS-2022
|
CSV | Parquet | 5,799 |
| 2021 |
SA-P05-T00-SUPPORT-ORGS-2021
|
CSV | Parquet | 5,265 |
| 2020 |
SA-P05-T00-SUPPORT-ORGS-2020
|
CSV | Parquet | 5,166 |
| 2019 |
SA-P05-T00-SUPPORT-ORGS-2019
|
CSV | Parquet | 3,904 |
| 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 |
Schedule B: Schedule of Contributors
P01 Part I - Contributors
SB-P01-T01-CONTRIBUTORS
1:M many rows per filing · tax years 2009–2024 · 2,117,709 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SB-P01-T01-CONTRIBUTORS-2024
|
CSV | Parquet | 56,102 |
| 2023 |
SB-P01-T01-CONTRIBUTORS-2023
|
CSV | Parquet | 220,553 |
| 2022 |
SB-P01-T01-CONTRIBUTORS-2022
|
CSV | Parquet | 233,852 |
| 2021 |
SB-P01-T01-CONTRIBUTORS-2021
|
CSV | Parquet | 227,991 |
| 2020 |
SB-P01-T01-CONTRIBUTORS-2020
|
CSV | Parquet | 220,667 |
| 2019 |
SB-P01-T01-CONTRIBUTORS-2019
|
CSV | Parquet | 181,428 |
| 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 |
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 · 91,966 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SC-P01-T00-LOBBY-2024
|
CSV | Parquet | 1,722 |
| 2023 |
SC-P01-T00-LOBBY-2023
|
CSV | Parquet | 7,323 |
| 2022 |
SC-P01-T00-LOBBY-2022
|
CSV | Parquet | 7,765 |
| 2021 |
SC-P01-T00-LOBBY-2021
|
CSV | Parquet | 7,476 |
| 2020 |
SC-P01-T00-LOBBY-2020
|
CSV | Parquet | 7,655 |
| 2019 |
SC-P01-T00-LOBBY-2019
|
CSV | Parquet | 6,679 |
| 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 |
SC-P01-T01-POLITICAL-ORGS-INFO
1:M many rows per filing · tax years 2009–2024 · 96,387 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SC-P01-T01-POLITICAL-ORGS-INFO-2024
|
CSV | Parquet | 1,820 |
| 2023 |
SC-P01-T01-POLITICAL-ORGS-INFO-2023
|
CSV | Parquet | 8,969 |
| 2022 |
SC-P01-T01-POLITICAL-ORGS-INFO-2022
|
CSV | Parquet | 10,547 |
| 2021 |
SC-P01-T01-POLITICAL-ORGS-INFO-2021
|
CSV | Parquet | 7,810 |
| 2020 |
SC-P01-T01-POLITICAL-ORGS-INFO-2020
|
CSV | Parquet | 8,753 |
| 2019 |
SC-P01-T01-POLITICAL-ORGS-INFO-2019
|
CSV | Parquet | 7,211 |
| 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 |
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 · 179,521 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SC-P02-T00-LOBBY-2024
|
CSV | Parquet | 1,670 |
| 2023 |
SC-P02-T00-LOBBY-2023
|
CSV | Parquet | 12,924 |
| 2022 |
SC-P02-T00-LOBBY-2022
|
CSV | Parquet | 14,521 |
| 2021 |
SC-P02-T00-LOBBY-2021
|
CSV | Parquet | 14,097 |
| 2020 |
SC-P02-T00-LOBBY-2020
|
CSV | Parquet | 14,967 |
| 2019 |
SC-P02-T00-LOBBY-2019
|
CSV | Parquet | 12,959 |
| 2018 |
SC-P02-T00-LOBBY-2018
|
CSV | Parquet | 12,682 |
| 2017 |
SC-P02-T00-LOBBY-2017
|
CSV | Parquet | 12,672 |
| 2016 |
SC-P02-T00-LOBBY-2016
|
CSV | Parquet | 11,900 |
| 2015 |
SC-P02-T00-LOBBY-2015
|
CSV | Parquet | 11,723 |
| 2014 |
SC-P02-T00-LOBBY-2014
|
CSV | Parquet | 11,249 |
| 2013 |
SC-P02-T00-LOBBY-2013
|
CSV | Parquet | 10,655 |
| 2012 |
SC-P02-T00-LOBBY-2012
|
CSV | Parquet | 10,233 |
| 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 |
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 · 235,904 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SC-P03-T00-LOBBY-2024
|
CSV | Parquet | 5,604 |
| 2023 |
SC-P03-T00-LOBBY-2023
|
CSV | Parquet | 21,478 |
| 2022 |
SC-P03-T00-LOBBY-2022
|
CSV | Parquet | 22,234 |
| 2021 |
SC-P03-T00-LOBBY-2021
|
CSV | Parquet | 21,861 |
| 2020 |
SC-P03-T00-LOBBY-2020
|
CSV | Parquet | 21,348 |
| 2019 |
SC-P03-T00-LOBBY-2019
|
CSV | Parquet | 19,054 |
| 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 |
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 · 100,000 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2024
|
CSV | Parquet | 665 |
| 2023 |
SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2023
|
CSV | Parquet | 5,507 |
| 2022 |
SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2022
|
CSV | Parquet | 5,517 |
| 2021 |
SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2021
|
CSV | Parquet | 5,203 |
| 2020 |
SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2020
|
CSV | Parquet | 5,771 |
| 2019 |
SD-P01-T00-ORGS-DONOR-ADVISED-FUNDS-OTH-2019
|
CSV | Parquet | 4,063 |
| 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 |
P02 Part II - Conservation Easements
SD-P02-T00-CONSERV-EASEMENTS
1:1 one row per filing · tax years 2009–2024 · 88,374 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SD-P02-T00-CONSERV-EASEMENTS-2024
|
CSV | Parquet | 540 |
| 2023 |
SD-P02-T00-CONSERV-EASEMENTS-2023
|
CSV | Parquet | 4,722 |
| 2022 |
SD-P02-T00-CONSERV-EASEMENTS-2022
|
CSV | Parquet | 4,625 |
| 2021 |
SD-P02-T00-CONSERV-EASEMENTS-2021
|
CSV | Parquet | 4,275 |
| 2020 |
SD-P02-T00-CONSERV-EASEMENTS-2020
|
CSV | Parquet | 4,789 |
| 2019 |
SD-P02-T00-CONSERV-EASEMENTS-2019
|
CSV | Parquet | 3,237 |
| 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 |
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 · 144,451 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2024
|
CSV | Parquet | 1,157 |
| 2023 |
SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2023
|
CSV | Parquet | 9,430 |
| 2022 |
SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2022
|
CSV | Parquet | 9,962 |
| 2021 |
SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2021
|
CSV | Parquet | 9,604 |
| 2020 |
SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2020
|
CSV | Parquet | 10,034 |
| 2019 |
SD-P03-T00-ORGS-COLLECT-ART-HIST-TREASURE-OTH-2019
|
CSV | Parquet | 7,682 |
| 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 |
P04 Part IV - Escrow and Custodial Arrangements
SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS
1:1 one row per filing · tax years 2009–2024 · 297,043 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2024
|
CSV | Parquet | 3,925 |
| 2023 |
SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2023
|
CSV | Parquet | 21,755 |
| 2022 |
SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2022
|
CSV | Parquet | 24,072 |
| 2021 |
SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2021
|
CSV | Parquet | 23,986 |
| 2020 |
SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2020
|
CSV | Parquet | 25,677 |
| 2019 |
SD-P04-T00-ESCROW-CUSTODIAL-ARRANGEMENTS-2019
|
CSV | Parquet | 20,160 |
| 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 |
P05 Part V - Endowment Funds
SD-P05-T00-ENDOWMENT
1:1 one row per filing · tax years 2009–2024 · 486,307 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SD-P05-T00-ENDOWMENT-2024
|
CSV | Parquet | 4,377 |
| 2023 |
SD-P05-T00-ENDOWMENT-2023
|
CSV | Parquet | 33,412 |
| 2022 |
SD-P05-T00-ENDOWMENT-2022
|
CSV | Parquet | 37,568 |
| 2021 |
SD-P05-T00-ENDOWMENT-2021
|
CSV | Parquet | 37,364 |
| 2020 |
SD-P05-T00-ENDOWMENT-2020
|
CSV | Parquet | 41,181 |
| 2019 |
SD-P05-T00-ENDOWMENT-2019
|
CSV | Parquet | 34,494 |
| 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 |
P06 Part VI - Land, Buildings, and Equipment
SD-P06-T00-LAND-BLDG-EQUIP
1:1 one row per filing · tax years 2009–2024 · 2,760,867 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SD-P06-T00-LAND-BLDG-EQUIP-2024
|
CSV | Parquet | 47,162 |
| 2023 |
SD-P06-T00-LAND-BLDG-EQUIP-2023
|
CSV | Parquet | 228,776 |
| 2022 |
SD-P06-T00-LAND-BLDG-EQUIP-2022
|
CSV | Parquet | 248,009 |
| 2021 |
SD-P06-T00-LAND-BLDG-EQUIP-2021
|
CSV | Parquet | 243,950 |
| 2020 |
SD-P06-T00-LAND-BLDG-EQUIP-2020
|
CSV | Parquet | 255,469 |
| 2019 |
SD-P06-T00-LAND-BLDG-EQUIP-2019
|
CSV | Parquet | 214,983 |
| 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 |
P07 Part VII - Investments - Other Securities
SD-P07-T00-INVESTMENTS-SECURITIES
1:1 one row per filing · tax years 2009–2024 · 260,347 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SD-P07-T00-INVESTMENTS-SECURITIES-2024
|
CSV | Parquet | 3,372 |
| 2023 |
SD-P07-T00-INVESTMENTS-SECURITIES-2023
|
CSV | Parquet | 20,630 |
| 2022 |
SD-P07-T00-INVESTMENTS-SECURITIES-2022
|
CSV | Parquet | 22,242 |
| 2021 |
SD-P07-T00-INVESTMENTS-SECURITIES-2021
|
CSV | Parquet | 21,509 |
| 2020 |
SD-P07-T00-INVESTMENTS-SECURITIES-2020
|
CSV | Parquet | 22,601 |
| 2019 |
SD-P07-T00-INVESTMENTS-SECURITIES-2019
|
CSV | Parquet | 18,876 |
| 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 |
SD-P07-T01-INVESTMENTS-OTH-DERIVATIVES
1:M many rows per filing · tax years 2009–2024 · 24,360 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SD-P07-T01-INVESTMENTS-OTH-DERIVATIVES-2024
|
CSV | Parquet | 388 |
| 2023 |
SD-P07-T01-INVESTMENTS-OTH-DERIVATIVES-2023
|
CSV | Parquet | 1,457 |
| 2022 |
SD-P07-T01-INVESTMENTS-OTH-DERIVATIVES-2022
|
CSV | Parquet | 1,947 |
| 2021 |
SD-P07-T01-INVESTMENTS-OTH-DERIVATIVES-2021
|
CSV | Parquet | 1,872 |
| 2020 |
SD-P07-T01-INVESTMENTS-OTH-DERIVATIVES-2020
|
CSV | Parquet | 1,781 |
| 2019 |
SD-P07-T01-INVESTMENTS-OTH-DERIVATIVES-2019
|
CSV | Parquet | 1,625 |
| 2018 |
SD-P07-T01-INVESTMENTS-OTH-DERIVATIVES-2018
|
CSV | Parquet | 1,667 |
| 2017 |
SD-P07-T01-INVESTMENTS-OTH-DERIVATIVES-2017
|
CSV | Parquet | 1,640 |
| 2016 |
SD-P07-T01-INVESTMENTS-OTH-DERIVATIVES-2016
|
CSV | Parquet | 1,507 |
| 2015 |
SD-P07-T01-INVESTMENTS-OTH-DERIVATIVES-2015
|
CSV | Parquet | 1,530 |
| 2014 |
SD-P07-T01-INVESTMENTS-OTH-DERIVATIVES-2014
|
CSV | Parquet | 1,564 |
| 2013 |
SD-P07-T01-INVESTMENTS-OTH-DERIVATIVES-2013
|
CSV | Parquet | 1,668 |
| 2012 |
SD-P07-T01-INVESTMENTS-OTH-DERIVATIVES-2012
|
CSV | Parquet | 1,654 |
| 2011 |
SD-P07-T01-INVESTMENTS-OTH-DERIVATIVES-2011
|
CSV | Parquet | 1,573 |
| 2010 |
SD-P07-T01-INVESTMENTS-OTH-DERIVATIVES-2010
|
CSV | Parquet | 1,424 |
| 2009 |
SD-P07-T01-INVESTMENTS-OTH-DERIVATIVES-2009
|
CSV | Parquet | 1,063 |
SD-P07-T01-INVESTMENTS-OTH-EQUITY
1:M many rows per filing · tax years 2009–2024 · 32,524 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SD-P07-T01-INVESTMENTS-OTH-EQUITY-2024
|
CSV | Parquet | 426 |
| 2023 |
SD-P07-T01-INVESTMENTS-OTH-EQUITY-2023
|
CSV | Parquet | 1,922 |
| 2022 |
SD-P07-T01-INVESTMENTS-OTH-EQUITY-2022
|
CSV | Parquet | 2,482 |
| 2021 |
SD-P07-T01-INVESTMENTS-OTH-EQUITY-2021
|
CSV | Parquet | 2,447 |
| 2020 |
SD-P07-T01-INVESTMENTS-OTH-EQUITY-2020
|
CSV | Parquet | 2,430 |
| 2019 |
SD-P07-T01-INVESTMENTS-OTH-EQUITY-2019
|
CSV | Parquet | 2,239 |
| 2018 |
SD-P07-T01-INVESTMENTS-OTH-EQUITY-2018
|
CSV | Parquet | 2,264 |
| 2017 |
SD-P07-T01-INVESTMENTS-OTH-EQUITY-2017
|
CSV | Parquet | 2,337 |
| 2016 |
SD-P07-T01-INVESTMENTS-OTH-EQUITY-2016
|
CSV | Parquet | 2,198 |
| 2015 |
SD-P07-T01-INVESTMENTS-OTH-EQUITY-2015
|
CSV | Parquet | 2,213 |
| 2014 |
SD-P07-T01-INVESTMENTS-OTH-EQUITY-2014
|
CSV | Parquet | 2,235 |
| 2013 |
SD-P07-T01-INVESTMENTS-OTH-EQUITY-2013
|
CSV | Parquet | 2,258 |
| 2012 |
SD-P07-T01-INVESTMENTS-OTH-EQUITY-2012
|
CSV | Parquet | 2,128 |
| 2011 |
SD-P07-T01-INVESTMENTS-OTH-EQUITY-2011
|
CSV | Parquet | 2,011 |
| 2010 |
SD-P07-T01-INVESTMENTS-OTH-EQUITY-2010
|
CSV | Parquet | 1,758 |
| 2009 |
SD-P07-T01-INVESTMENTS-OTH-EQUITY-2009
|
CSV | Parquet | 1,176 |
SD-P07-T01-INVESTMENTS-OTH-SECURITIES
1:M many rows per filing · tax years 2009–2024 · 728,975 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2024
|
CSV | Parquet | 10,170 |
| 2023 |
SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2023
|
CSV | Parquet | 56,298 |
| 2022 |
SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2022
|
CSV | Parquet | 62,842 |
| 2021 |
SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2021
|
CSV | Parquet | 61,943 |
| 2020 |
SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2020
|
CSV | Parquet | 68,997 |
| 2019 |
SD-P07-T01-INVESTMENTS-OTH-SECURITIES-2019
|
CSV | Parquet | 53,705 |
| 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 |
P08 Part VIII - Investments - Program Related
SD-P08-T00-INVESTMENTS-PROG-RLTD
1:1 one row per filing · tax years 2009–2024 · 75,476 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SD-P08-T00-INVESTMENTS-PROG-RLTD-2024
|
CSV | Parquet | 1,261 |
| 2023 |
SD-P08-T00-INVESTMENTS-PROG-RLTD-2023
|
CSV | Parquet | 6,426 |
| 2022 |
SD-P08-T00-INVESTMENTS-PROG-RLTD-2022
|
CSV | Parquet | 6,650 |
| 2021 |
SD-P08-T00-INVESTMENTS-PROG-RLTD-2021
|
CSV | Parquet | 6,695 |
| 2020 |
SD-P08-T00-INVESTMENTS-PROG-RLTD-2020
|
CSV | Parquet | 6,910 |
| 2019 |
SD-P08-T00-INVESTMENTS-PROG-RLTD-2019
|
CSV | Parquet | 5,731 |
| 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 |
SD-P08-T01-INVESTMENTS-PROG-RLTD
1:M many rows per filing · tax years 2009–2024 · 169,938 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SD-P08-T01-INVESTMENTS-PROG-RLTD-2024
|
CSV | Parquet | 2,822 |
| 2023 |
SD-P08-T01-INVESTMENTS-PROG-RLTD-2023
|
CSV | Parquet | 14,277 |
| 2022 |
SD-P08-T01-INVESTMENTS-PROG-RLTD-2022
|
CSV | Parquet | 14,991 |
| 2021 |
SD-P08-T01-INVESTMENTS-PROG-RLTD-2021
|
CSV | Parquet | 14,769 |
| 2020 |
SD-P08-T01-INVESTMENTS-PROG-RLTD-2020
|
CSV | Parquet | 15,065 |
| 2019 |
SD-P08-T01-INVESTMENTS-PROG-RLTD-2019
|
CSV | Parquet | 12,875 |
| 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 |
P09 Part IX - Other Assets
SD-P09-T00-OTH-ASSETS
1:1 one row per filing · tax years 2009–2024 · 530,951 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SD-P09-T00-OTH-ASSETS-2024
|
CSV | Parquet | 8,143 |
| 2023 |
SD-P09-T00-OTH-ASSETS-2023
|
CSV | Parquet | 55,026 |
| 2022 |
SD-P09-T00-OTH-ASSETS-2022
|
CSV | Parquet | 59,901 |
| 2021 |
SD-P09-T00-OTH-ASSETS-2021
|
CSV | Parquet | 44,989 |
| 2020 |
SD-P09-T00-OTH-ASSETS-2020
|
CSV | Parquet | 46,211 |
| 2019 |
SD-P09-T00-OTH-ASSETS-2019
|
CSV | Parquet | 38,899 |
| 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 |
SD-P09-T01-OTH-ASSETS
1:M many rows per filing · tax years 2009–2024 · 1,179,214 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SD-P09-T01-OTH-ASSETS-2024
|
CSV | Parquet | 16,089 |
| 2023 |
SD-P09-T01-OTH-ASSETS-2023
|
CSV | Parquet | 118,926 |
| 2022 |
SD-P09-T01-OTH-ASSETS-2022
|
CSV | Parquet | 130,430 |
| 2021 |
SD-P09-T01-OTH-ASSETS-2021
|
CSV | Parquet | 97,382 |
| 2020 |
SD-P09-T01-OTH-ASSETS-2020
|
CSV | Parquet | 99,766 |
| 2019 |
SD-P09-T01-OTH-ASSETS-2019
|
CSV | Parquet | 83,604 |
| 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 |
P10 Part X - Other Liabilities
SD-P10-T00-OTH-LIABILITIES
1:1 one row per filing · tax years 2009–2024 · 1,754,291 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SD-P10-T00-OTH-LIABILITIES-2024
|
CSV | Parquet | 26,190 |
| 2023 |
SD-P10-T00-OTH-LIABILITIES-2023
|
CSV | Parquet | 150,925 |
| 2022 |
SD-P10-T00-OTH-LIABILITIES-2022
|
CSV | Parquet | 164,107 |
| 2021 |
SD-P10-T00-OTH-LIABILITIES-2021
|
CSV | Parquet | 155,608 |
| 2020 |
SD-P10-T00-OTH-LIABILITIES-2020
|
CSV | Parquet | 167,556 |
| 2019 |
SD-P10-T00-OTH-LIABILITIES-2019
|
CSV | Parquet | 140,930 |
| 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 |
SD-P10-T01-OTH-LIABILITIES
1:M many rows per filing · tax years 2009–2024 · 3,095,680 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SD-P10-T01-OTH-LIABILITIES-2024
|
CSV | Parquet | 42,164 |
| 2023 |
SD-P10-T01-OTH-LIABILITIES-2023
|
CSV | Parquet | 242,847 |
| 2022 |
SD-P10-T01-OTH-LIABILITIES-2022
|
CSV | Parquet | 265,327 |
| 2021 |
SD-P10-T01-OTH-LIABILITIES-2021
|
CSV | Parquet | 234,524 |
| 2020 |
SD-P10-T01-OTH-LIABILITIES-2020
|
CSV | Parquet | 257,379 |
| 2019 |
SD-P10-T01-OTH-LIABILITIES-2019
|
CSV | Parquet | 214,407 |
| 2018 |
SD-P10-T01-OTH-LIABILITIES-2018
|
CSV | Parquet | 192,316 |
| 2017 |
SD-P10-T01-OTH-LIABILITIES-2017
|
CSV | Parquet | 189,926 |
| 2016 |
SD-P10-T01-OTH-LIABILITIES-2016
|
CSV | Parquet | 178,620 |
| 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 | 263,304 |
| 2011 |
SD-P10-T01-OTH-LIABILITIES-2011
|
CSV | Parquet | 245,388 |
| 2010 |
SD-P10-T01-OTH-LIABILITIES-2010
|
CSV | Parquet | 193,113 |
| 2009 |
SD-P10-T01-OTH-LIABILITIES-2009
|
CSV | Parquet | 72,323 |
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,328,847 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SD-P11-T00-RECONCILIATION-REVENUE-2024
|
CSV | Parquet | 13,341 |
| 2023 |
SD-P11-T00-RECONCILIATION-REVENUE-2023
|
CSV | Parquet | 94,435 |
| 2022 |
SD-P11-T00-RECONCILIATION-REVENUE-2022
|
CSV | Parquet | 106,073 |
| 2021 |
SD-P11-T00-RECONCILIATION-REVENUE-2021
|
CSV | Parquet | 106,720 |
| 2020 |
SD-P11-T00-RECONCILIATION-REVENUE-2020
|
CSV | Parquet | 117,662 |
| 2019 |
SD-P11-T00-RECONCILIATION-REVENUE-2019
|
CSV | Parquet | 100,155 |
| 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 |
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,328,235 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SD-P12-T00-RECONCILIATION-EXPENSES-2024
|
CSV | Parquet | 13,336 |
| 2023 |
SD-P12-T00-RECONCILIATION-EXPENSES-2023
|
CSV | Parquet | 94,411 |
| 2022 |
SD-P12-T00-RECONCILIATION-EXPENSES-2022
|
CSV | Parquet | 106,054 |
| 2021 |
SD-P12-T00-RECONCILIATION-EXPENSES-2021
|
CSV | Parquet | 106,698 |
| 2020 |
SD-P12-T00-RECONCILIATION-EXPENSES-2020
|
CSV | Parquet | 117,626 |
| 2019 |
SD-P12-T00-RECONCILIATION-EXPENSES-2019
|
CSV | Parquet | 100,141 |
| 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,142 |
| 2011 |
SD-P12-T00-RECONCILIATION-EXPENSES-2011
|
CSV | Parquet | 73,063 |
| 2010 |
SD-P12-T00-RECONCILIATION-EXPENSES-2010
|
CSV | Parquet | 58,524 |
| 2009 |
SD-P12-T00-RECONCILIATION-EXPENSES-2009
|
CSV | Parquet | 21,814 |
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 |
Schedule E: Schools
P01 Part I - Schools
SE-P01-T00-SCHOOLS
1:1 one row per filing · tax years 2009–2024 · 212,269 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SE-P01-T00-SCHOOLS-2024
|
CSV | Parquet | 1,954 |
| 2023 |
SE-P01-T00-SCHOOLS-2023
|
CSV | Parquet | 16,093 |
| 2022 |
SE-P01-T00-SCHOOLS-2022
|
CSV | Parquet | 19,331 |
| 2021 |
SE-P01-T00-SCHOOLS-2021
|
CSV | Parquet | 19,091 |
| 2020 |
SE-P01-T00-SCHOOLS-2020
|
CSV | Parquet | 20,528 |
| 2019 |
SE-P01-T00-SCHOOLS-2019
|
CSV | Parquet | 16,570 |
| 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 |
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 · 162,027 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SF-P01-T00-FRGN-ACTS-2024
|
CSV | Parquet | 3,014 |
| 2023 |
SF-P01-T00-FRGN-ACTS-2023
|
CSV | Parquet | 15,127 |
| 2022 |
SF-P01-T00-FRGN-ACTS-2022
|
CSV | Parquet | 15,807 |
| 2021 |
SF-P01-T00-FRGN-ACTS-2021
|
CSV | Parquet | 14,759 |
| 2020 |
SF-P01-T00-FRGN-ACTS-2020
|
CSV | Parquet | 14,836 |
| 2019 |
SF-P01-T00-FRGN-ACTS-2019
|
CSV | Parquet | 13,065 |
| 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 |
SF-P01-T01-FRGN-ACTS-BY-REGION
1:M many rows per filing · tax years 2009–2024 · 499,320 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SF-P01-T01-FRGN-ACTS-BY-REGION-2024
|
CSV | Parquet | 6,830 |
| 2023 |
SF-P01-T01-FRGN-ACTS-BY-REGION-2023
|
CSV | Parquet | 43,106 |
| 2022 |
SF-P01-T01-FRGN-ACTS-BY-REGION-2022
|
CSV | Parquet | 46,441 |
| 2021 |
SF-P01-T01-FRGN-ACTS-BY-REGION-2021
|
CSV | Parquet | 42,055 |
| 2020 |
SF-P01-T01-FRGN-ACTS-BY-REGION-2020
|
CSV | Parquet | 41,233 |
| 2019 |
SF-P01-T01-FRGN-ACTS-BY-REGION-2019
|
CSV | Parquet | 40,092 |
| 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,185 |
| 2015 |
SF-P01-T01-FRGN-ACTS-BY-REGION-2015
|
CSV | Parquet | 33,497 |
| 2014 |
SF-P01-T01-FRGN-ACTS-BY-REGION-2014
|
CSV | Parquet | 30,926 |
| 2013 |
SF-P01-T01-FRGN-ACTS-BY-REGION-2013
|
CSV | Parquet | 28,116 |
| 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 |
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 · 66,708 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SF-P02-T00-FRGN-ORG-GRANTS-2024
|
CSV | Parquet | 1,600 |
| 2023 |
SF-P02-T00-FRGN-ORG-GRANTS-2023
|
CSV | Parquet | 6,762 |
| 2022 |
SF-P02-T00-FRGN-ORG-GRANTS-2022
|
CSV | Parquet | 7,075 |
| 2021 |
SF-P02-T00-FRGN-ORG-GRANTS-2021
|
CSV | Parquet | 6,626 |
| 2020 |
SF-P02-T00-FRGN-ORG-GRANTS-2020
|
CSV | Parquet | 6,585 |
| 2019 |
SF-P02-T00-FRGN-ORG-GRANTS-2019
|
CSV | Parquet | 5,356 |
| 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 |
SF-P02-T01-FRGN-ORG-GRANTS
1:M many rows per filing · tax years 2009–2024 · 800,900 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SF-P02-T01-FRGN-ORG-GRANTS-2024
|
CSV | Parquet | 9,611 |
| 2023 |
SF-P02-T01-FRGN-ORG-GRANTS-2023
|
CSV | Parquet | 75,313 |
| 2022 |
SF-P02-T01-FRGN-ORG-GRANTS-2022
|
CSV | Parquet | 82,382 |
| 2021 |
SF-P02-T01-FRGN-ORG-GRANTS-2021
|
CSV | Parquet | 74,220 |
| 2020 |
SF-P02-T01-FRGN-ORG-GRANTS-2020
|
CSV | Parquet | 76,823 |
| 2019 |
SF-P02-T01-FRGN-ORG-GRANTS-2019
|
CSV | Parquet | 57,487 |
| 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,808 |
| 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,185 |
| 2009 |
SF-P02-T01-FRGN-ORG-GRANTS-2009
|
CSV | Parquet | 14,563 |
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 · 122,975 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SF-P03-T01-FRGN-INDIV-GRANTS-2024
|
CSV | Parquet | 2,048 |
| 2023 |
SF-P03-T01-FRGN-INDIV-GRANTS-2023
|
CSV | Parquet | 10,922 |
| 2022 |
SF-P03-T01-FRGN-INDIV-GRANTS-2022
|
CSV | Parquet | 11,529 |
| 2021 |
SF-P03-T01-FRGN-INDIV-GRANTS-2021
|
CSV | Parquet | 11,069 |
| 2020 |
SF-P03-T01-FRGN-INDIV-GRANTS-2020
|
CSV | Parquet | 10,344 |
| 2019 |
SF-P03-T01-FRGN-INDIV-GRANTS-2019
|
CSV | Parquet | 9,878 |
| 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,377 |
| 2013 |
SF-P03-T01-FRGN-INDIV-GRANTS-2013
|
CSV | Parquet | 6,727 |
| 2012 |
SF-P03-T01-FRGN-INDIV-GRANTS-2012
|
CSV | Parquet | 6,023 |
| 2011 |
SF-P03-T01-FRGN-INDIV-GRANTS-2011
|
CSV | Parquet | 5,397 |
| 2010 |
SF-P03-T01-FRGN-INDIV-GRANTS-2010
|
CSV | Parquet | 4,560 |
| 2009 |
SF-P03-T01-FRGN-INDIV-GRANTS-2009
|
CSV | Parquet | 2,338 |
P04 Part IV - Foreign Forms
SF-P04-T00-FRGN-INTERESTS
1:1 one row per filing · tax years 2010–2024 · 174,265 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SF-P04-T00-FRGN-INTERESTS-2024
|
CSV | Parquet | 3,662 |
| 2023 |
SF-P04-T00-FRGN-INTERESTS-2023
|
CSV | Parquet | 16,873 |
| 2022 |
SF-P04-T00-FRGN-INTERESTS-2022
|
CSV | Parquet | 17,482 |
| 2021 |
SF-P04-T00-FRGN-INTERESTS-2021
|
CSV | Parquet | 16,356 |
| 2020 |
SF-P04-T00-FRGN-INTERESTS-2020
|
CSV | Parquet | 16,401 |
| 2019 |
SF-P04-T00-FRGN-INTERESTS-2019
|
CSV | Parquet | 14,257 |
| 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 |
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 |
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 · 314,534 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SG-P01-T00-FUNDRAISING-ACTS-2024
|
CSV | Parquet | 5,399 |
| 2023 |
SG-P01-T00-FUNDRAISING-ACTS-2023
|
CSV | Parquet | 25,416 |
| 2022 |
SG-P01-T00-FUNDRAISING-ACTS-2022
|
CSV | Parquet | 26,288 |
| 2021 |
SG-P01-T00-FUNDRAISING-ACTS-2021
|
CSV | Parquet | 23,694 |
| 2020 |
SG-P01-T00-FUNDRAISING-ACTS-2020
|
CSV | Parquet | 21,184 |
| 2019 |
SG-P01-T00-FUNDRAISING-ACTS-2019
|
CSV | Parquet | 23,615 |
| 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 |
SG-P01-T01-FUNDRAISERS-INFO
1:M many rows per filing · tax years 2009–2024 · 115,884 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SG-P01-T01-FUNDRAISERS-INFO-2024
|
CSV | Parquet | 1,267 |
| 2023 |
SG-P01-T01-FUNDRAISERS-INFO-2023
|
CSV | Parquet | 8,859 |
| 2022 |
SG-P01-T01-FUNDRAISERS-INFO-2022
|
CSV | Parquet | 9,831 |
| 2021 |
SG-P01-T01-FUNDRAISERS-INFO-2021
|
CSV | Parquet | 9,073 |
| 2020 |
SG-P01-T01-FUNDRAISERS-INFO-2020
|
CSV | Parquet | 9,151 |
| 2019 |
SG-P01-T01-FUNDRAISERS-INFO-2019
|
CSV | Parquet | 8,562 |
| 2018 |
SG-P01-T01-FUNDRAISERS-INFO-2018
|
CSV | Parquet | 8,530 |
| 2017 |
SG-P01-T01-FUNDRAISERS-INFO-2017
|
CSV | Parquet | 8,754 |
| 2016 |
SG-P01-T01-FUNDRAISERS-INFO-2016
|
CSV | Parquet | 8,163 |
| 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,918 |
| 2009 |
SG-P01-T01-FUNDRAISERS-INFO-2009
|
CSV | Parquet | 2,242 |
P02 Part II - Fundraising Events
SG-P02-T00-FUNDRAISING-EVENTS
1:1 one row per filing · tax years 2009–2024 · 276,564 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SG-P02-T00-FUNDRAISING-EVENTS-2024
|
CSV | Parquet | 5,275 |
| 2023 |
SG-P02-T00-FUNDRAISING-EVENTS-2023
|
CSV | Parquet | 16,629 |
| 2022 |
SG-P02-T00-FUNDRAISING-EVENTS-2022
|
CSV | Parquet | 15,867 |
| 2021 |
SG-P02-T00-FUNDRAISING-EVENTS-2021
|
CSV | Parquet | 13,094 |
| 2020 |
SG-P02-T00-FUNDRAISING-EVENTS-2020
|
CSV | Parquet | 7,933 |
| 2019 |
SG-P02-T00-FUNDRAISING-EVENTS-2019
|
CSV | Parquet | 8,940 |
| 2018 |
SG-P02-T00-FUNDRAISING-EVENTS-2018
|
CSV | Parquet | 9,359 |
| 2017 |
SG-P02-T00-FUNDRAISING-EVENTS-2017
|
CSV | Parquet | 8,634 |
| 2016 |
SG-P02-T00-FUNDRAISING-EVENTS-2016
|
CSV | Parquet | 8,024 |
| 2015 |
SG-P02-T00-FUNDRAISING-EVENTS-2015
|
CSV | Parquet | 7,867 |
| 2014 |
SG-P02-T00-FUNDRAISING-EVENTS-2014
|
CSV | Parquet | 7,390 |
| 2013 |
SG-P02-T00-FUNDRAISING-EVENTS-2013
|
CSV | Parquet | 7,054 |
| 2012 |
SG-P02-T00-FUNDRAISING-EVENTS-2012
|
CSV | Parquet | 59,340 |
| 2011 |
SG-P02-T00-FUNDRAISING-EVENTS-2011
|
CSV | Parquet | 52,288 |
| 2010 |
SG-P02-T00-FUNDRAISING-EVENTS-2010
|
CSV | Parquet | 37,203 |
| 2009 |
SG-P02-T00-FUNDRAISING-EVENTS-2009
|
CSV | Parquet | 11,667 |
SG-P02-T01-FUNDRAISING-EVENTS
1:M many rows per filing · tax years 2009–2024 · 1,120,207 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SG-P02-T01-FUNDRAISING-EVENTS-2024
|
CSV | Parquet | 22,614 |
| 2023 |
SG-P02-T01-FUNDRAISING-EVENTS-2023
|
CSV | Parquet | 96,965 |
| 2022 |
SG-P02-T01-FUNDRAISING-EVENTS-2022
|
CSV | Parquet | 99,524 |
| 2021 |
SG-P02-T01-FUNDRAISING-EVENTS-2021
|
CSV | Parquet | 87,697 |
| 2020 |
SG-P02-T01-FUNDRAISING-EVENTS-2020
|
CSV | Parquet | 72,505 |
| 2019 |
SG-P02-T01-FUNDRAISING-EVENTS-2019
|
CSV | Parquet | 87,772 |
| 2018 |
SG-P02-T01-FUNDRAISING-EVENTS-2018
|
CSV | Parquet | 92,269 |
| 2017 |
SG-P02-T01-FUNDRAISING-EVENTS-2017
|
CSV | Parquet | 89,616 |
| 2016 |
SG-P02-T01-FUNDRAISING-EVENTS-2016
|
CSV | Parquet | 83,446 |
| 2015 |
SG-P02-T01-FUNDRAISING-EVENTS-2015
|
CSV | Parquet | 80,432 |
| 2014 |
SG-P02-T01-FUNDRAISING-EVENTS-2014
|
CSV | Parquet | 75,530 |
| 2013 |
SG-P02-T01-FUNDRAISING-EVENTS-2013
|
CSV | Parquet | 67,967 |
| 2012 |
SG-P02-T01-FUNDRAISING-EVENTS-2012
|
CSV | Parquet | 60,662 |
| 2011 |
SG-P02-T01-FUNDRAISING-EVENTS-2011
|
CSV | Parquet | 53,503 |
| 2010 |
SG-P02-T01-FUNDRAISING-EVENTS-2010
|
CSV | Parquet | 37,929 |
| 2009 |
SG-P02-T01-FUNDRAISING-EVENTS-2009
|
CSV | Parquet | 11,776 |
P03 Part III - Gaming
SG-P03-T00-GAMING
1:1 one row per filing · tax years 2009–2024 · 168,675 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SG-P03-T00-GAMING-2024
|
CSV | Parquet | 4,339 |
| 2023 |
SG-P03-T00-GAMING-2023
|
CSV | Parquet | 16,079 |
| 2022 |
SG-P03-T00-GAMING-2022
|
CSV | Parquet | 16,341 |
| 2021 |
SG-P03-T00-GAMING-2021
|
CSV | Parquet | 15,328 |
| 2020 |
SG-P03-T00-GAMING-2020
|
CSV | Parquet | 13,717 |
| 2019 |
SG-P03-T00-GAMING-2019
|
CSV | Parquet | 12,838 |
| 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 |
Schedule H: Hospitals
P01 Part I - Financial Assistance and Certain Other Community Benefits at Cost
SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY
1:M many rows per filing · tax years 2009–2024 · 34,580 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2024
|
CSV | Parquet | 20 |
| 2023 |
SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2023
|
CSV | Parquet | 1,810 |
| 2022 |
SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2022
|
CSV | Parquet | 2,347 |
| 2021 |
SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2021
|
CSV | Parquet | 2,329 |
| 2020 |
SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2020
|
CSV | Parquet | 2,444 |
| 2019 |
SH-P01-T00-FAP-COMMUNITY-BENEFIT-POLICY-2019
|
CSV | Parquet | 2,310 |
| 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 |
P02 Part II - Community Building Activities
SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY
1:M many rows per filing · tax years 2009–2024 · 19,144 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2024
|
CSV | Parquet | 7 |
| 2023 |
SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2023
|
CSV | Parquet | 1,089 |
| 2022 |
SH-P02-T00-FAP-COMMUNITY-BENEFIT-POLICY-2022
|
CSV | Parquet | 1,329 |
| 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,246 |
| 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 |
P03 Part III - Bad Debt, Medicare, and Collection Practices
SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY
1:M many rows per filing · tax years 2009–2024 · 34,474 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2024
|
CSV | Parquet | 17 |
| 2023 |
SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2023
|
CSV | Parquet | 1,809 |
| 2022 |
SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2022
|
CSV | Parquet | 2,344 |
| 2021 |
SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2021
|
CSV | Parquet | 2,328 |
| 2020 |
SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2020
|
CSV | Parquet | 2,443 |
| 2019 |
SH-P03-T00-FAP-COMMUNITY-BENEFIT-POLICY-2019
|
CSV | Parquet | 2,310 |
| 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 |
P04 Part IV - Management Companies and Joint Ventures
SH-P04-T01-COMPANY-JOINT-VENTURES
1:M many rows per filing · tax years 2009–2024 · 17,372 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SH-P04-T01-COMPANY-JOINT-VENTURES-2024
|
CSV | Parquet | 2 |
| 2023 |
SH-P04-T01-COMPANY-JOINT-VENTURES-2023
|
CSV | Parquet | 809 |
| 2022 |
SH-P04-T01-COMPANY-JOINT-VENTURES-2022
|
CSV | Parquet | 1,027 |
| 2021 |
SH-P04-T01-COMPANY-JOINT-VENTURES-2021
|
CSV | Parquet | 1,043 |
| 2020 |
SH-P04-T01-COMPANY-JOINT-VENTURES-2020
|
CSV | Parquet | 1,072 |
| 2019 |
SH-P04-T01-COMPANY-JOINT-VENTURES-2019
|
CSV | Parquet | 1,083 |
| 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 |
P05 Part V - Facility Information
SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY
1:1 one row per filing · tax years 2010–2024 · 33,000 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2024
|
CSV | Parquet | 21 |
| 2023 |
SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2023
|
CSV | Parquet | 1,811 |
| 2022 |
SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2022
|
CSV | Parquet | 2,347 |
| 2021 |
SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2021
|
CSV | Parquet | 2,330 |
| 2020 |
SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2020
|
CSV | Parquet | 2,445 |
| 2019 |
SH-P05-T00-FAP-COMMUNITY-BENEFIT-POLICY-2019
|
CSV | Parquet | 2,310 |
| 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 |
SH-P05-T01-HOSPITAL-FACILITY
1:M many rows per filing · tax years 2009–2024 · 171,189 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SH-P05-T01-HOSPITAL-FACILITY-2024
|
CSV | Parquet | 30 |
| 2023 |
SH-P05-T01-HOSPITAL-FACILITY-2023
|
CSV | Parquet | 3,015 |
| 2022 |
SH-P05-T01-HOSPITAL-FACILITY-2022
|
CSV | Parquet | 3,723 |
| 2021 |
SH-P05-T01-HOSPITAL-FACILITY-2021
|
CSV | Parquet | 3,687 |
| 2020 |
SH-P05-T01-HOSPITAL-FACILITY-2020
|
CSV | Parquet | 3,848 |
| 2019 |
SH-P05-T01-HOSPITAL-FACILITY-2019
|
CSV | Parquet | 3,641 |
| 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 | 45,101 |
| 2011 |
SH-P05-T01-HOSPITAL-FACILITY-2011
|
CSV | Parquet | 41,768 |
| 2010 |
SH-P05-T01-HOSPITAL-FACILITY-2010
|
CSV | Parquet | 36,824 |
| 2009 |
SH-P05-T01-HOSPITAL-FACILITY-2009
|
CSV | Parquet | 7,495 |
SH-P05-T02-NON-HOSPITAL-FACILITY
1:M many rows per filing · tax years 2010–2024 · 296,558 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SH-P05-T02-NON-HOSPITAL-FACILITY-2024
|
CSV | Parquet | 29 |
| 2023 |
SH-P05-T02-NON-HOSPITAL-FACILITY-2023
|
CSV | Parquet | 24,060 |
| 2022 |
SH-P05-T02-NON-HOSPITAL-FACILITY-2022
|
CSV | Parquet | 27,358 |
| 2021 |
SH-P05-T02-NON-HOSPITAL-FACILITY-2021
|
CSV | Parquet | 26,160 |
| 2020 |
SH-P05-T02-NON-HOSPITAL-FACILITY-2020
|
CSV | Parquet | 25,702 |
| 2019 |
SH-P05-T02-NON-HOSPITAL-FACILITY-2019
|
CSV | Parquet | 25,321 |
| 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 |
P99 Lines from earlier versions of the schedule (Part V, Section B facility policies)
SH-P99-T00-FAP-COMMUNITY-BENEFIT-POLICY
1:1 one row per filing · tax years 2010–2015 · 12,704 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2015 |
SH-P99-T00-FAP-COMMUNITY-BENEFIT-POLICY-2015
|
CSV | Parquet | 2,365 |
| 2014 |
SH-P99-T00-FAP-COMMUNITY-BENEFIT-POLICY-2014
|
CSV | Parquet | 2,387 |
| 2013 |
SH-P99-T00-FAP-COMMUNITY-BENEFIT-POLICY-2013
|
CSV | Parquet | 2,437 |
| 2012 |
SH-P99-T00-FAP-COMMUNITY-BENEFIT-POLICY-2012
|
CSV | Parquet | 2,452 |
| 2011 |
SH-P99-T00-FAP-COMMUNITY-BENEFIT-POLICY-2011
|
CSV | Parquet | 2,346 |
| 2010 |
SH-P99-T00-FAP-COMMUNITY-BENEFIT-POLICY-2010
|
CSV | Parquet | 717 |
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 · 810,035 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SI-P01-T00-GRANTS-INFO-2024
|
CSV | Parquet | 14,076 |
| 2023 |
SI-P01-T00-GRANTS-INFO-2023
|
CSV | Parquet | 72,822 |
| 2022 |
SI-P01-T00-GRANTS-INFO-2022
|
CSV | Parquet | 77,437 |
| 2021 |
SI-P01-T00-GRANTS-INFO-2021
|
CSV | Parquet | 73,458 |
| 2020 |
SI-P01-T00-GRANTS-INFO-2020
|
CSV | Parquet | 75,776 |
| 2019 |
SI-P01-T00-GRANTS-INFO-2019
|
CSV | Parquet | 63,510 |
| 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 |
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 · 396,791 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SI-P02-T00-GRANTS-US-ORGS-GOVTS-2024
|
CSV | Parquet | 5,907 |
| 2023 |
SI-P02-T00-GRANTS-US-ORGS-GOVTS-2023
|
CSV | Parquet | 35,246 |
| 2022 |
SI-P02-T00-GRANTS-US-ORGS-GOVTS-2022
|
CSV | Parquet | 37,677 |
| 2021 |
SI-P02-T00-GRANTS-US-ORGS-GOVTS-2021
|
CSV | Parquet | 36,030 |
| 2020 |
SI-P02-T00-GRANTS-US-ORGS-GOVTS-2020
|
CSV | Parquet | 36,979 |
| 2019 |
SI-P02-T00-GRANTS-US-ORGS-GOVTS-2019
|
CSV | Parquet | 31,107 |
| 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 |
SI-P02-T01-GRANTS-US-ORGS-GOVTS
1:M many rows per filing · tax years 2009–2024 · 8,261,288 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SI-P02-T01-GRANTS-US-ORGS-GOVTS-2024
|
CSV | Parquet | 66,243 |
| 2023 |
SI-P02-T01-GRANTS-US-ORGS-GOVTS-2023
|
CSV | Parquet | 826,628 |
| 2022 |
SI-P02-T01-GRANTS-US-ORGS-GOVTS-2022
|
CSV | Parquet | 928,684 |
| 2021 |
SI-P02-T01-GRANTS-US-ORGS-GOVTS-2021
|
CSV | Parquet | 899,810 |
| 2020 |
SI-P02-T01-GRANTS-US-ORGS-GOVTS-2020
|
CSV | Parquet | 1,050,955 |
| 2019 |
SI-P02-T01-GRANTS-US-ORGS-GOVTS-2019
|
CSV | Parquet | 700,119 |
| 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,145 |
| 2016 |
SI-P02-T01-GRANTS-US-ORGS-GOVTS-2016
|
CSV | Parquet | 514,902 |
| 2015 |
SI-P02-T01-GRANTS-US-ORGS-GOVTS-2015
|
CSV | Parquet | 450,254 |
| 2014 |
SI-P02-T01-GRANTS-US-ORGS-GOVTS-2014
|
CSV | Parquet | 412,297 |
| 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,683 |
| 2011 |
SI-P02-T01-GRANTS-US-ORGS-GOVTS-2011
|
CSV | Parquet | 273,266 |
| 2010 |
SI-P02-T01-GRANTS-US-ORGS-GOVTS-2010
|
CSV | Parquet | 228,952 |
| 2009 |
SI-P02-T01-GRANTS-US-ORGS-GOVTS-2009
|
CSV | Parquet | 83,445 |
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 · 772,113 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SI-P03-T01-GRANTS-US-INDIV-2024
|
CSV | Parquet | 11,108 |
| 2023 |
SI-P03-T01-GRANTS-US-INDIV-2023
|
CSV | Parquet | 66,087 |
| 2022 |
SI-P03-T01-GRANTS-US-INDIV-2022
|
CSV | Parquet | 72,261 |
| 2021 |
SI-P03-T01-GRANTS-US-INDIV-2021
|
CSV | Parquet | 67,782 |
| 2020 |
SI-P03-T01-GRANTS-US-INDIV-2020
|
CSV | Parquet | 70,924 |
| 2019 |
SI-P03-T01-GRANTS-US-INDIV-2019
|
CSV | Parquet | 59,616 |
| 2018 |
SI-P03-T01-GRANTS-US-INDIV-2018
|
CSV | Parquet | 57,867 |
| 2017 |
SI-P03-T01-GRANTS-US-INDIV-2017
|
CSV | Parquet | 56,453 |
| 2016 |
SI-P03-T01-GRANTS-US-INDIV-2016
|
CSV | Parquet | 51,241 |
| 2015 |
SI-P03-T01-GRANTS-US-INDIV-2015
|
CSV | Parquet | 48,867 |
| 2014 |
SI-P03-T01-GRANTS-US-INDIV-2014
|
CSV | Parquet | 46,653 |
| 2013 |
SI-P03-T01-GRANTS-US-INDIV-2013
|
CSV | Parquet | 42,982 |
| 2012 |
SI-P03-T01-GRANTS-US-INDIV-2012
|
CSV | Parquet | 40,324 |
| 2011 |
SI-P03-T01-GRANTS-US-INDIV-2011
|
CSV | Parquet | 36,693 |
| 2010 |
SI-P03-T01-GRANTS-US-INDIV-2010
|
CSV | Parquet | 30,112 |
| 2009 |
SI-P03-T01-GRANTS-US-INDIV-2009
|
CSV | Parquet | 13,143 |
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 |
Schedule J: Compensation Information
P01 Part I - Questions Regarding Compensation
SJ-P01-T00-COMPENSATION
1:1 one row per filing · tax years 2009–2024 · 808,707 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SJ-P01-T00-COMPENSATION-2024
|
CSV | Parquet | 9,468 |
| 2023 |
SJ-P01-T00-COMPENSATION-2023
|
CSV | Parquet | 71,233 |
| 2022 |
SJ-P01-T00-COMPENSATION-2022
|
CSV | Parquet | 76,687 |
| 2021 |
SJ-P01-T00-COMPENSATION-2021
|
CSV | Parquet | 72,518 |
| 2020 |
SJ-P01-T00-COMPENSATION-2020
|
CSV | Parquet | 74,408 |
| 2019 |
SJ-P01-T00-COMPENSATION-2019
|
CSV | Parquet | 62,798 |
| 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 |
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,151,345 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SJ-P02-T01-COMPENSATION-DTK-2024
|
CSV | Parquet | 25,410 |
| 2023 |
SJ-P02-T01-COMPENSATION-DTK-2023
|
CSV | Parquet | 273,229 |
| 2022 |
SJ-P02-T01-COMPENSATION-DTK-2022
|
CSV | Parquet | 300,184 |
| 2021 |
SJ-P02-T01-COMPENSATION-DTK-2021
|
CSV | Parquet | 280,175 |
| 2020 |
SJ-P02-T01-COMPENSATION-DTK-2020
|
CSV | Parquet | 283,890 |
| 2019 |
SJ-P02-T01-COMPENSATION-DTK-2019
|
CSV | Parquet | 243,578 |
| 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 | 168,554 |
| 2011 |
SJ-P02-T01-COMPENSATION-DTK-2011
|
CSV | Parquet | 156,192 |
| 2010 |
SJ-P02-T01-COMPENSATION-DTK-2010
|
CSV | Parquet | 139,351 |
| 2009 |
SJ-P02-T01-COMPENSATION-DTK-2009
|
CSV | Parquet | 68,473 |
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 · 150,100 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SK-P01-T01-BOND-ISSUES-2024
|
CSV | Parquet | 416 |
| 2023 |
SK-P01-T01-BOND-ISSUES-2023
|
CSV | Parquet | 8,074 |
| 2022 |
SK-P01-T01-BOND-ISSUES-2022
|
CSV | Parquet | 10,295 |
| 2021 |
SK-P01-T01-BOND-ISSUES-2021
|
CSV | Parquet | 10,458 |
| 2020 |
SK-P01-T01-BOND-ISSUES-2020
|
CSV | Parquet | 11,789 |
| 2019 |
SK-P01-T01-BOND-ISSUES-2019
|
CSV | Parquet | 10,562 |
| 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,280 |
| 2011 |
SK-P01-T01-BOND-ISSUES-2011
|
CSV | Parquet | 9,824 |
| 2010 |
SK-P01-T01-BOND-ISSUES-2010
|
CSV | Parquet | 9,108 |
| 2009 |
SK-P01-T01-BOND-ISSUES-2009
|
CSV | Parquet | 5,512 |
P02 Part II - Proceeds
SK-P02-T01-BOND-PROCEEDS
1:M many rows per filing · tax years 2009–2024 · 148,292 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SK-P02-T01-BOND-PROCEEDS-2024
|
CSV | Parquet | 409 |
| 2023 |
SK-P02-T01-BOND-PROCEEDS-2023
|
CSV | Parquet | 8,030 |
| 2022 |
SK-P02-T01-BOND-PROCEEDS-2022
|
CSV | Parquet | 10,234 |
| 2021 |
SK-P02-T01-BOND-PROCEEDS-2021
|
CSV | Parquet | 10,389 |
| 2020 |
SK-P02-T01-BOND-PROCEEDS-2020
|
CSV | Parquet | 11,682 |
| 2019 |
SK-P02-T01-BOND-PROCEEDS-2019
|
CSV | Parquet | 10,475 |
| 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,091 |
| 2011 |
SK-P02-T01-BOND-PROCEEDS-2011
|
CSV | Parquet | 9,594 |
| 2010 |
SK-P02-T01-BOND-PROCEEDS-2010
|
CSV | Parquet | 8,840 |
| 2009 |
SK-P02-T01-BOND-PROCEEDS-2009
|
CSV | Parquet | 5,306 |
P03 Part III - Private Business Use
SK-P03-T01-BOND-PRIVATE-BIZ-USE
1:M many rows per filing · tax years 2009–2024 · 139,591 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SK-P03-T01-BOND-PRIVATE-BIZ-USE-2024
|
CSV | Parquet | 368 |
| 2023 |
SK-P03-T01-BOND-PRIVATE-BIZ-USE-2023
|
CSV | Parquet | 7,525 |
| 2022 |
SK-P03-T01-BOND-PRIVATE-BIZ-USE-2022
|
CSV | Parquet | 9,601 |
| 2021 |
SK-P03-T01-BOND-PRIVATE-BIZ-USE-2021
|
CSV | Parquet | 9,787 |
| 2020 |
SK-P03-T01-BOND-PRIVATE-BIZ-USE-2020
|
CSV | Parquet | 10,984 |
| 2019 |
SK-P03-T01-BOND-PRIVATE-BIZ-USE-2019
|
CSV | Parquet | 9,888 |
| 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,887 |
| 2015 |
SK-P03-T01-BOND-PRIVATE-BIZ-USE-2015
|
CSV | Parquet | 9,985 |
| 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,695 |
| 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,139 |
| 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 |
P04 Part IV - Arbitrage
SK-P04-T01-BOND-ARBITRAGE
1:M many rows per filing · tax years 2009–2024 · 145,766 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SK-P04-T01-BOND-ARBITRAGE-2024
|
CSV | Parquet | 406 |
| 2023 |
SK-P04-T01-BOND-ARBITRAGE-2023
|
CSV | Parquet | 7,945 |
| 2022 |
SK-P04-T01-BOND-ARBITRAGE-2022
|
CSV | Parquet | 10,117 |
| 2021 |
SK-P04-T01-BOND-ARBITRAGE-2021
|
CSV | Parquet | 10,275 |
| 2020 |
SK-P04-T01-BOND-ARBITRAGE-2020
|
CSV | Parquet | 11,562 |
| 2019 |
SK-P04-T01-BOND-ARBITRAGE-2019
|
CSV | Parquet | 10,365 |
| 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,003 |
P05 Part V - Procedures To Undertake Corrective Action
SK-P05-T01-PROCEDURE-CORRECTIVE-ACT
1:M many rows per filing · tax years 2010–2024 · 123,200 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2024
|
CSV | Parquet | 389 |
| 2023 |
SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2023
|
CSV | Parquet | 7,649 |
| 2022 |
SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2022
|
CSV | Parquet | 9,704 |
| 2021 |
SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2021
|
CSV | Parquet | 9,917 |
| 2020 |
SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2020
|
CSV | Parquet | 11,113 |
| 2019 |
SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2019
|
CSV | Parquet | 10,007 |
| 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 | 9,871 |
| 2011 |
SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2011
|
CSV | Parquet | 3,945 |
| 2010 |
SK-P05-T01-PROCEDURE-CORRECTIVE-ACT-2010
|
CSV | Parquet | 2,096 |
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 · 675 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2024
|
CSV | Parquet | 38 |
| 2023 |
SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2023
|
CSV | Parquet | 100 |
| 2022 |
SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2022
|
CSV | Parquet | 101 |
| 2021 |
SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2021
|
CSV | Parquet | 73 |
| 2020 |
SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2020
|
CSV | Parquet | 47 |
| 2019 |
SL-P01-T00-EXCESS-BENEFIT-TRANSAC-2019
|
CSV | Parquet | 40 |
| 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 |
SL-P01-T01-EXCESS-BENEFIT-TRANSAC
1:M many rows per filing · tax years 2009–2024 · 15,876 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2024
|
CSV | Parquet | 40 |
| 2023 |
SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2023
|
CSV | Parquet | 2,572 |
| 2022 |
SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2022
|
CSV | Parquet | 2,726 |
| 2021 |
SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2021
|
CSV | Parquet | 2,429 |
| 2020 |
SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2020
|
CSV | Parquet | 2,269 |
| 2019 |
SL-P01-T01-EXCESS-BENEFIT-TRANSAC-2019
|
CSV | Parquet | 1,325 |
| 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 |
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 · 134,645 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SL-P02-T00-LOANS-INTERESTED-PERS-2024
|
CSV | Parquet | 2,197 |
| 2023 |
SL-P02-T00-LOANS-INTERESTED-PERS-2023
|
CSV | Parquet | 9,259 |
| 2022 |
SL-P02-T00-LOANS-INTERESTED-PERS-2022
|
CSV | Parquet | 10,037 |
| 2021 |
SL-P02-T00-LOANS-INTERESTED-PERS-2021
|
CSV | Parquet | 10,262 |
| 2020 |
SL-P02-T00-LOANS-INTERESTED-PERS-2020
|
CSV | Parquet | 10,824 |
| 2019 |
SL-P02-T00-LOANS-INTERESTED-PERS-2019
|
CSV | Parquet | 10,152 |
| 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 |
SL-P02-T01-LOANS-INTERESTED-PERS
1:M many rows per filing · tax years 2009–2024 · 305,289 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SL-P02-T01-LOANS-INTERESTED-PERS-2024
|
CSV | Parquet | 4,461 |
| 2023 |
SL-P02-T01-LOANS-INTERESTED-PERS-2023
|
CSV | Parquet | 23,100 |
| 2022 |
SL-P02-T01-LOANS-INTERESTED-PERS-2022
|
CSV | Parquet | 24,429 |
| 2021 |
SL-P02-T01-LOANS-INTERESTED-PERS-2021
|
CSV | Parquet | 24,639 |
| 2020 |
SL-P02-T01-LOANS-INTERESTED-PERS-2020
|
CSV | Parquet | 25,387 |
| 2019 |
SL-P02-T01-LOANS-INTERESTED-PERS-2019
|
CSV | Parquet | 22,569 |
| 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 |
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 · 31,194 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SL-P03-T01-GRANTS-INTERESTED-PERS-2024
|
CSV | Parquet | 259 |
| 2023 |
SL-P03-T01-GRANTS-INTERESTED-PERS-2023
|
CSV | Parquet | 2,155 |
| 2022 |
SL-P03-T01-GRANTS-INTERESTED-PERS-2022
|
CSV | Parquet | 2,506 |
| 2021 |
SL-P03-T01-GRANTS-INTERESTED-PERS-2021
|
CSV | Parquet | 2,355 |
| 2020 |
SL-P03-T01-GRANTS-INTERESTED-PERS-2020
|
CSV | Parquet | 2,720 |
| 2019 |
SL-P03-T01-GRANTS-INTERESTED-PERS-2019
|
CSV | Parquet | 2,199 |
| 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 |
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 · 485,170 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2024
|
CSV | Parquet | 4,564 |
| 2023 |
SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2023
|
CSV | Parquet | 31,143 |
| 2022 |
SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2022
|
CSV | Parquet | 34,487 |
| 2021 |
SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2021
|
CSV | Parquet | 34,400 |
| 2020 |
SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2020
|
CSV | Parquet | 36,938 |
| 2019 |
SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS-2019
|
CSV | Parquet | 33,269 |
| 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 |
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 · 359,787 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SM-P01-T00-NONCASH-CONTRIBUTIONS-2024
|
CSV | Parquet | 4,767 |
| 2023 |
SM-P01-T00-NONCASH-CONTRIBUTIONS-2023
|
CSV | Parquet | 28,797 |
| 2022 |
SM-P01-T00-NONCASH-CONTRIBUTIONS-2022
|
CSV | Parquet | 31,328 |
| 2021 |
SM-P01-T00-NONCASH-CONTRIBUTIONS-2021
|
CSV | Parquet | 31,019 |
| 2020 |
SM-P01-T00-NONCASH-CONTRIBUTIONS-2020
|
CSV | Parquet | 32,198 |
| 2019 |
SM-P01-T00-NONCASH-CONTRIBUTIONS-2019
|
CSV | Parquet | 27,932 |
| 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 |
SM-P01-T01-NONCASH-CONTRIBUTIONS
1:M many rows per filing · tax years 2009–2024 · 404,198 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SM-P01-T01-NONCASH-CONTRIBUTIONS-2024
|
CSV | Parquet | 4,563 |
| 2023 |
SM-P01-T01-NONCASH-CONTRIBUTIONS-2023
|
CSV | Parquet | 29,891 |
| 2022 |
SM-P01-T01-NONCASH-CONTRIBUTIONS-2022
|
CSV | Parquet | 31,612 |
| 2021 |
SM-P01-T01-NONCASH-CONTRIBUTIONS-2021
|
CSV | Parquet | 29,484 |
| 2020 |
SM-P01-T01-NONCASH-CONTRIBUTIONS-2020
|
CSV | Parquet | 30,779 |
| 2019 |
SM-P01-T01-NONCASH-CONTRIBUTIONS-2019
|
CSV | Parquet | 30,398 |
| 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,234 |
| 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 |
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 · 40,400 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2024
|
CSV | Parquet | 2,006 |
| 2023 |
SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2023
|
CSV | Parquet | 4,217 |
| 2022 |
SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2022
|
CSV | Parquet | 4,287 |
| 2021 |
SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2021
|
CSV | Parquet | 3,825 |
| 2020 |
SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2020
|
CSV | Parquet | 3,718 |
| 2019 |
SN-P01-T00-LIQUIDATION-TERMINATION-DISSOLUTION-2019
|
CSV | Parquet | 3,074 |
| 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 |
SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION
1:M many rows per filing · tax years 2009–2024 · 72,443 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2024
|
CSV | Parquet | 3,391 |
| 2023 |
SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2023
|
CSV | Parquet | 7,651 |
| 2022 |
SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2022
|
CSV | Parquet | 7,397 |
| 2021 |
SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2021
|
CSV | Parquet | 7,150 |
| 2020 |
SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2020
|
CSV | Parquet | 6,994 |
| 2019 |
SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2019
|
CSV | Parquet | 5,258 |
| 2018 |
SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2018
|
CSV | Parquet | 5,543 |
| 2017 |
SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2017
|
CSV | Parquet | 4,976 |
| 2016 |
SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2016
|
CSV | Parquet | 4,643 |
| 2015 |
SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2015
|
CSV | Parquet | 4,172 |
| 2014 |
SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2014
|
CSV | Parquet | 4,056 |
| 2013 |
SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2013
|
CSV | Parquet | 3,704 |
| 2012 |
SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2012
|
CSV | Parquet | 2,940 |
| 2011 |
SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2011
|
CSV | Parquet | 2,401 |
| 2010 |
SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2010
|
CSV | Parquet | 1,734 |
| 2009 |
SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION-2009
|
CSV | Parquet | 433 |
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 · 18,409 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SN-P02-T00-DISPOSITION-OF-ASSETS-2024
|
CSV | Parquet | 487 |
| 2023 |
SN-P02-T00-DISPOSITION-OF-ASSETS-2023
|
CSV | Parquet | 1,553 |
| 2022 |
SN-P02-T00-DISPOSITION-OF-ASSETS-2022
|
CSV | Parquet | 1,722 |
| 2021 |
SN-P02-T00-DISPOSITION-OF-ASSETS-2021
|
CSV | Parquet | 1,411 |
| 2020 |
SN-P02-T00-DISPOSITION-OF-ASSETS-2020
|
CSV | Parquet | 1,515 |
| 2019 |
SN-P02-T00-DISPOSITION-OF-ASSETS-2019
|
CSV | Parquet | 1,209 |
| 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 |
SN-P02-T01-DISPOSITION-OF-ASSETS
1:M many rows per filing · tax years 2009–2024 · 29,818 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SN-P02-T01-DISPOSITION-OF-ASSETS-2024
|
CSV | Parquet | 546 |
| 2023 |
SN-P02-T01-DISPOSITION-OF-ASSETS-2023
|
CSV | Parquet | 2,345 |
| 2022 |
SN-P02-T01-DISPOSITION-OF-ASSETS-2022
|
CSV | Parquet | 2,390 |
| 2021 |
SN-P02-T01-DISPOSITION-OF-ASSETS-2021
|
CSV | Parquet | 2,437 |
| 2020 |
SN-P02-T01-DISPOSITION-OF-ASSETS-2020
|
CSV | Parquet | 2,860 |
| 2019 |
SN-P02-T01-DISPOSITION-OF-ASSETS-2019
|
CSV | Parquet | 2,121 |
| 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 |
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 |
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 · 1,973,568 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SR-P01-T01-ID-DISREGARDED-ENTITIES-2024
|
CSV | Parquet | 1,779 |
| 2023 |
SR-P01-T01-ID-DISREGARDED-ENTITIES-2023
|
CSV | Parquet | 30,587 |
| 2022 |
SR-P01-T01-ID-DISREGARDED-ENTITIES-2022
|
CSV | Parquet | 33,288 |
| 2021 |
SR-P01-T01-ID-DISREGARDED-ENTITIES-2021
|
CSV | Parquet | 31,298 |
| 2020 |
SR-P01-T01-ID-DISREGARDED-ENTITIES-2020
|
CSV | Parquet | 30,948 |
| 2019 |
SR-P01-T01-ID-DISREGARDED-ENTITIES-2019
|
CSV | Parquet | 38,426 |
| 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 | 765,251 |
| 2011 |
SR-P01-T01-ID-DISREGARDED-ENTITIES-2011
|
CSV | Parquet | 489,582 |
| 2010 |
SR-P01-T01-ID-DISREGARDED-ENTITIES-2010
|
CSV | Parquet | 297,907 |
| 2009 |
SR-P01-T01-ID-DISREGARDED-ENTITIES-2009
|
CSV | Parquet | 105,984 |
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,183,817 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2024
|
CSV | Parquet | 22,115 |
| 2023 |
SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2023
|
CSV | Parquet | 420,971 |
| 2022 |
SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2022
|
CSV | Parquet | 547,068 |
| 2021 |
SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2021
|
CSV | Parquet | 537,284 |
| 2020 |
SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2020
|
CSV | Parquet | 566,983 |
| 2019 |
SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2019
|
CSV | Parquet | 533,297 |
| 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 | 386,272 |
| 2011 |
SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2011
|
CSV | Parquet | 342,197 |
| 2010 |
SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2010
|
CSV | Parquet | 276,253 |
| 2009 |
SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS-2009
|
CSV | Parquet | 99,618 |
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,585,136 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2024
|
CSV | Parquet | 5,840 |
| 2023 |
SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2023
|
CSV | Parquet | 223,433 |
| 2022 |
SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2022
|
CSV | Parquet | 260,855 |
| 2021 |
SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2021
|
CSV | Parquet | 246,078 |
| 2020 |
SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2020
|
CSV | Parquet | 253,687 |
| 2019 |
SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2019
|
CSV | Parquet | 227,502 |
| 2018 |
SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP-2018
|
CSV | Parquet | 219,432 |
| 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,927 |
| 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,251 |
| 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,706 |
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,475,269 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2024
|
CSV | Parquet | 9,213 |
| 2023 |
SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2023
|
CSV | Parquet | 255,253 |
| 2022 |
SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2022
|
CSV | Parquet | 291,106 |
| 2021 |
SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2021
|
CSV | Parquet | 287,156 |
| 2020 |
SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2020
|
CSV | Parquet | 284,599 |
| 2019 |
SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2019
|
CSV | Parquet | 261,530 |
| 2018 |
SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION-2018
|
CSV | Parquet | 262,950 |
| 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,250 |
| 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 |
P05 Part V - Transactions With Related Organizations
SR-P05-T00-TRANSACTIONS-RLTD-ORGS
1:1 one row per filing · tax years 2009–2024 · 877,699 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2024
|
CSV | Parquet | 8,666 |
| 2023 |
SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2023
|
CSV | Parquet | 66,814 |
| 2022 |
SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2022
|
CSV | Parquet | 74,948 |
| 2021 |
SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2021
|
CSV | Parquet | 74,339 |
| 2020 |
SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2020
|
CSV | Parquet | 78,615 |
| 2019 |
SR-P05-T00-TRANSACTIONS-RLTD-ORGS-2019
|
CSV | Parquet | 67,670 |
| 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 |
SR-P05-T01-TRANSACTIONS-RLTD-ORGS
1:M many rows per filing · tax years 2009–2024 · 1,504,801 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2024
|
CSV | Parquet | 9,431 |
| 2023 |
SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2023
|
CSV | Parquet | 99,603 |
| 2022 |
SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2022
|
CSV | Parquet | 117,615 |
| 2021 |
SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2021
|
CSV | Parquet | 117,267 |
| 2020 |
SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2020
|
CSV | Parquet | 124,996 |
| 2019 |
SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2019
|
CSV | Parquet | 112,872 |
| 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,780 |
| 2013 |
SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2013
|
CSV | Parquet | 94,718 |
| 2012 |
SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2012
|
CSV | Parquet | 99,706 |
| 2011 |
SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2011
|
CSV | Parquet | 92,847 |
| 2010 |
SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2010
|
CSV | Parquet | 78,452 |
| 2009 |
SR-P05-T01-TRANSACTIONS-RLTD-ORGS-2009
|
CSV | Parquet | 33,715 |
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 · 14,307 rows · Data dictionary
| Year | Table | CSV | Parquet | Rows |
|---|---|---|---|---|
| 2024 |
SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2024
|
CSV | Parquet | 13 |
| 2023 |
SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2023
|
CSV | Parquet | 265 |
| 2022 |
SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2022
|
CSV | Parquet | 529 |
| 2021 |
SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2021
|
CSV | Parquet | 1,456 |
| 2020 |
SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2020
|
CSV | Parquet | 400 |
| 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 | 3,998 |
| 2011 |
SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2011
|
CSV | Parquet | 3,294 |
| 2010 |
SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2010
|
CSV | Parquet | 2,116 |
| 2009 |
SR-P06-T01-UNRLTD-ORGS-TAXABLE-PARTNERSHIP-2009
|
CSV | Parquet | 104 |
Table list and row counts: public/efile_v2_2/COUNT-OF-ROWS-BY-TABLE-AND-FORMTYPE-EFILE_V2_2.CSV. Page rendered 2026-10-23.