{"columns":[{"name":"harmonized_name","type":"string"},{"name":"description","type":"string"},{"name":"source_var","type":"string"},{"name":"source_location","type":"string"},{"name":"data_type","type":"string"},{"name":"n_rows","type":"int32"},{"name":"n_nonnull","type":"int32"},{"name":"null_pct","type":"double"},{"name":"n_distinct","type":"int32"},{"name":"min_value","type":"int64"},{"name":"max_value","type":"double"},{"name":"years_present","type":"string"}],"n_rows":64,"rows_kept":64,"cut":false,"text_format":"parquet-jsonl-2026-10-02","bounds":{"document_bytes":16777216,"package_text_limit_bytes":33554432,"package_text_slack_bytes":1024,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096,"vector_min":64,"vector_head_fixed":16,"vector_head_variable":64,"kv_value_chars":1048576,"nesting_max":64,"binary_text":true},"cells_cut":0,"cells_bad_utf8":0,"cells_raw":0,"cells_binary":0,"cells_binary_text":0,"cells_vector":0,"n_row_groups":1,"reader":"pyarrow 23.0.1, python 3.13","created_by":"parquet-cpp-arrow version 15.0.1","schema":{"fields":[{"name":"harmonized_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"description","type":"string","nullable":true,"metadata":null,"children":null},{"name":"source_var","type":"string","nullable":true,"metadata":null,"children":null},{"name":"source_location","type":"string","nullable":true,"metadata":null,"children":null},{"name":"data_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"n_rows","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"n_nonnull","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"null_pct","type":"double","nullable":true,"metadata":null,"children":null},{"name":"n_distinct","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"min_value","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"max_value","type":"double","nullable":true,"metadata":null,"children":null},{"name":"years_present","type":"string","nullable":true,"metadata":null,"children":null}],"parquet":"required group field_id=-1 schema {\n  optional binary field_id=-1 harmonized_name (String);\n  optional binary field_id=-1 description (String);\n  optional binary field_id=-1 source_var (String);\n  optional binary field_id=-1 source_location (String);\n  optional binary field_id=-1 data_type (String);\n  optional int32 field_id=-1 n_rows;\n  optional int32 field_id=-1 n_nonnull;\n  optional double field_id=-1 null_pct;\n  optional int32 field_id=-1 n_distinct;\n  optional int64 field_id=-1 min_value;\n  optional double field_id=-1 max_value;\n  optional binary field_id=-1 years_present (String);\n}\n"},"kv_metadata":[["ARROW:schema",{"$cut":{"chars":2104,"head":""}}],["r","A\n3\n262915\n197888\n5\nUTF-8\n531\n2\n531\n2\n16\n2\n262153\n10\ndata.table\n262153\n10\ndata.frame\n22\n22\n254\n254\n16\n12\n262153\n15\nharmonized_name\n262153\n11\ndescription\n262153\n10\nsource_var\n262153\n15\nsource_location\n262153\n9\ndata_type\n262153\n6\nn_rows\n262153\n9\nn_nonnull\n262153\n8\nnull_pct\n262153\n10\nn_distinct\n262153\n9\nmin_value\n262153\n9\nmax_value\n262153\n13\nyears_present\n1026\n1\n262153\n5\nnames\n16\n2\n262153\n5\nclass\n262153\n17\n.internal.selfref\n254\n531\n12\n254\n254\n254\n254\n254\n254\n254\n254\n254\n254\n254\n254\n1026\n1023\n16\n12\n262153\n15\nharmonized_name\n262153\n11\ndescription\n262153\n10\nsource_var\n262153\n15\nsource_location\n262153\n9\ndata_type\n262153\n6\nn_rows\n262153\n9\nn_nonnull\n262153\n8\nnull_pct\n262153\n10\nn_distinct\n262153\n9\nmin_value\n262153\n9\nmax_value\n262153\n13\nyears_present\n254\n1026\n1023\n16\n2\n262153\n10\nattributes\n262153\n7\ncolumns\n254\n"]]}
["ein","Employer Identification Number","EIN","Form 990 Header","character",515769,515769,0.0,515132,null,null,"2012-2024"]
["efile_indicator","E-file indicator","efile|elf","n/a","boolean",515769,515769,0.0,2,null,null,"2020-2024|2015-2019"]
["excess_benefit_transaction_cd","Excess benefit transaction?","engageexcessbnftcd","990 Core_Pt IV-25a","boolean",515769,492538,4.5,2,null,null,"2013-2024"]
["excess_over_1pct_sec509","Amount support exceeds total (509)","exceeds1pct509","990 Sch A_Pt III-7b(f)","numeric",515769,515769,0.0,8709,-27898,13289465573.0,"2013-2024"]
["excess_over_2pct_sec170","Amount support exceeds total (170)","exceeds2pct170","990 Sch A_Pt II-5(f)","numeric",515769,515769,0.0,54258,-1270324,14947896649.0,"2013-2024"]
["filed_form_990t_cd","Form 990-T filed?","filedf990tcd","990 Core_Pt V-3b","boolean",515769,366907,28.86,2,null,null,"2013-2024"]
["gifts_grants_received_sec170","Gifts grants membership fees received (170)","gftgrntsrcvd170","990 Sch A_Pt II-1(f)","numeric",515769,515769,0.0,160292,-7285,62385244797.0,"2012-2024"]
["gross_sales_inventory","Gross sales of inventory","grsalesinvent","990 Core_Pt VIII-10a","numeric",515769,515769,0.0,42110,-1121191,1763976648.0,"2012-2024"]
["gross_income_interest_sec170","Gross income from interest etc (170)","grsinc170","990 Sch A_Pt II-8(f)","numeric",515769,515769,0.0,59643,-54682151,4512208228.0,"2012-2024"]
["gross_income_interest_sec509","Gross income from interest etc (509)","grsinc509","990 Sch A_Pt III-10a(f)","numeric",515769,515769,0.0,40122,-4666983,435974000.0,"2013-2024"]
["gross_income_fundraising_events","Gross fundraising","grsincfndrsng","990 Core_Pt VIII-8a","numeric",515769,515769,0.0,74716,-196134,2690940620.0,"2012-2024"]
["gross_income_gaming_activities","Gross income from gaming","grsincgaming","990 Core_Pt VIII-9a","numeric",515769,515769,0.0,17179,-50,95283126.0,"2012-2024"]
["gross_receipts_related_activities_sec509","Gross receipts from related activities (509)","grsrcptsactivities509","990 Sch A_Pt III-3(f)","numeric",515769,515769,0.0,20346,-1210284,7957160287.0,"2013-2024"]
["gross_receipts_admissions_sec509","Receipts from admissions merchandise etc (509)","grsrcptsadmissn509","990 Sch A_Pt III-2(f)","numeric",515769,515769,0.0,104485,-1314409,342505000000.0,"2012-2024"]
["gross_receipts_public_use","Gross receipts amount","grsrcptspublicuse","990 Core_Pt V-10b","integer",515769,515769,0.0,2591,0,11285429.0,"2012-2024"]
["gross_receipts_related_activities_sec170","Gross receipts from related activities (170)","grsrcptsrelated170","990 Sch A_Pt II-12","numeric",515769,515769,0.0,59785,-60790868,64361193689.0,"2012-2024"]
["initiation_fees","Initiation fees amount","initiationfees","990 Core_Pt V-10a","numeric",515769,515769,0.0,3392,-300,7777777777.0,"2012-2024"]
["investment_income","Investment income","invstmntinc","990 Core_Pt VIII-3(A)","numeric",515769,515769,0.0,91788,-180119525,4503584389.0,"2012-2024"]
["cost_of_goods_sold","Cost of goods sold (inventory)","lesscstofgoods","990 Core_Pt VIII-10b","integer",515769,515769,0.0,36694,-17118516,1046760662.0,"2012-2024"]
["loan_to_interested_person_cd","Loan to officer or DQP?","loantofficercd","990 Core_Pt IV-26","boolean",515769,515756,0.0,2,null,null,"2013-2024"]
["other_revenue_total_11e","Other revenue","miscrevtot11e","990 Core_Pt VIII-11e(A)","numeric",515769,515769,0.0,63453,-72515480,897564407.0,"2012-2024"]
["net_income_fundraising_events","Fundraising income","netincfndrsng","990 Core_Pt VIII-8c(A)","numeric",515769,515769,0.0,74925,-17864803,2690940620.0,"2012-2024"]
["net_income_inventory_sales","Income from sales of inventory","netincsales","990 Core_Pt VIII-10c(A)","numeric",515769,515769,0.0,39122,-57751387,717215986.0,"2012-2024"]
["net_ubi_excl_10b_sec509","Net income from UBI not in 10b (509)","netincunrelatd509","990 Sch A_Pt III-11(f)","numeric",515769,515769,0.0,6075,-2900327,38823953.0,"2013-2024"]
["net_ubi_sec170","Net UBI (170)","netincunreltd170","990 Sch A_Pt II-9(f)","numeric",515769,515769,0.0,10162,-10029525,259266249.0,"2013-2024"]
["non_pf_status_reason","Reason for non-PF status","nonpfrea","990 Sch A_Pt I-1-11","integer",515769,406259,21.23,15,1,16.0,"2012-2024"]
["other_income_sec170","Other income (170)","othrinc170","990 Sch A_Pt II-10(f)","numeric",515769,515769,0.0,39443,-9173561,4133627704.0,"2013-2024"]
["other_income_sec509","Other income (509)","othrinc509","990 Sch A_Pt III-12(f)","numeric",515769,515769,0.0,23551,-10335468,828349052.0,"2013-2024"]
["prohibited_tax_shelter_cd","Prohibited tax shelter transaction?","prohibtdtxshltrcd","990 Core_Pt V-5a","boolean",515769,512354,0.66,2,null,null,"2013-2024"]
["public_support_sec170","Public support (170)","pubsupplesspct170","990 Sch A_Pt II-6(f)","numeric",515769,515769,0.0,160143,-210760960,60372948893.0,"2013-2024"]
["public_support_sec509","Public support (509)","pubsupplesub509","990 Sch A_Pt III-8(f)","numeric",515769,515769,0.0,167903,-38669677,342517000000.0,"2013-2024"]
["public_support_subtotal_sec170","Public support subtotal (170)","pubsuppsubtot170","990 Sch A_Pt II-4(f)","numeric",515769,515769,0.0,160708,-7285,62385244797.0,"2013-2024"]
["public_support_subtotal_line6_sec509","Public support subtotal (509)","pubsuppsubtot509","990 Sch A_Pt III-6(f)","numeric",515769,515769,0.0,168314,-1314409,342517000000.0,"2013-2024"]
["disqualified_persons_amts_sec509","Amounts from disqualified persons (509)","rcvdfrmdisqualsub509","990 Sch A_Pt III-7a(f)","numeric",515769,515769,0.0,13687,-6567,368660308.0,"2013-2024"]
["public_support_subtotal_line4_ref_sec170","Public support from line 4 (170)","samepubsuppsubtot170","990 Sch A_Pt II-7(f)","numeric",515769,515769,0.0,160709,-7285,62385244797.0,"2013-2024"]
["public_support_subtotal_line6_ref_sec509","Public support from line 6 (509)","samepubsuppsubtot509","990 Sch A_Pt III-9(f)","numeric",515769,515769,0.0,168314,-1314409,342517000000.0,"2013-2024"]
["gov_services_value_sec170","Services or facilities furnished by gov (170)","srvcsval170","990 Sch A_Pt II-3(f)","numeric",515769,515769,0.0,3215,-56002,292053476.0,"2012-2024"]
["gov_services_value_sec509","Services or facilities furnished by gov (509)","srvcsval509","990 Sch A_Pt III-5(f)","numeric",515769,515769,0.0,1108,-2180,54145685.0,"2012-2024"]
["subsection_cd","Subsection code","subseccd","Form 990 Header","integer",515769,515769,0.0,25,2,29.0,"2012-2024"]
["public_support_subtotal_line7c_sec509","Public support subtotal (509)","subtotpub509","990 Sch A_Pt III-7c(f)","numeric",515769,515769,0.0,19217,-27898,13289465573.0,"2013-2024"]
["total_support_subtotal_sec509","Subtotal total support (509)","subtotsuppinc509","990 Sch A_Pt III-10c(f)","numeric",515769,515769,0.0,40442,-4666983,435974000.0,"2012-2024"]
["tax_period","Tax period","tax_pd|tax_prd","Form 990 Header","character",515769,515769,0.0,12,null,null,"2013,2016-2024|2012,2014-2015"]
["total_assets_eoy","Total assets -- eoy","totassetsend","990 Core_Pt X-16(B)","numeric",515769,515769,0.0,393183,-103544076,72059961625.0,"2012-2024"]
["total_contributions","Total contributions","totcntrbgfts","990 Core_Pt VIII-1h(A)","numeric",515769,515769,0.0,262200,-236277,12623545644.0,"2012-2024"]
["total_expenses","Total functional expenses (Form 990 Part IX Line 25; equivalent to Form 990-EZ Part I Line 17 total expenses)","totfuncexpns","990 Core_Pt IX-25(A)","numeric",515769,515769,0.0,365157,-491433541,74356004001.0,"2012-2024"]
["total_gifts_grants_received_sec509","Gifts grants membership fees received (509)","totgftgrntrcvd509","990 Sch A_Pt III-1(f)","numeric",515769,515769,0.0,149809,-298235,166081000000.0,"2012-2024"]
["total_liabilities_eoy","Total liabilities -- eoy","totliabend","990 Core_Pt X-26(B)","numeric",515769,515769,0.0,185972,-33135081,45572981504.0,"2012-2024"]
["total_net_assets_eoy","Total Net Assets -- eoy","totnetassetend","990 Core_Pt X-33(B)","numeric",515769,515769,0.0,392437,-6198252533,60515813928.0,"2012-2024"]
["n_orgs_supported","Number of organizations supported","totnooforgscnt","990 Sch A_Pt I-11h","integer",515769,515769,0.0,86,0,753.0,"2013-2024"]
["program_service_revenue","Program service revenue","totprgmrevnue","990 Core_Pt VIII-2g(A)","numeric",515769,515769,0.0,205565,-12126397,75068903991.0,"2012-2024"]
["total_revenue","Total revenue","totrevenue","990 Core_Pt VIII-12(A)","numeric",515769,515769,0.0,372284,-150302637,75101306911.0,"2012-2024"]
["total_support_sec170","Total support (170)","totsupp170","990 Sch A_Pt II-11(f)","numeric",515769,515769,0.0,161973,-528757,66946725787.0,"2013-2024"]
["total_support_sec509","Total support (509)","totsupp509","990 Sch A_Pt III-13(f)","numeric",515769,515769,0.0,168864,-1314409,342849000000.0,"2012-2024"]
["total_support_amount","Sum of amounts of support","totsupport","990 Sch A_Pt I-11h(vii)","numeric",515769,515769,0.0,9320,-1090410,5372967871.0,"2013-2024"]
["tax_revenues_levied_sec170","Tax revenues levied (170)","txrevnuelevied170","990 Sch A_Pt II-2(f)","numeric",515769,515769,0.0,2997,-2220,1301156244.0,"2012-2024"]
["tax_revenues_levied_sec509","Tax revenues levied (509)","txrevnuelevied509","990 Sch A_Pt III-4(f)","numeric",515769,515769,0.0,1319,-25392,319958970.0,"2012-2024"]
["unrelated_business_income_1k_cd","Unrelated business income?","unrelbusinccd","990 Core_Pt V-3a","boolean",515769,515756,0.0,2,null,null,"2012-2024"]
["net_ubi_line10b_sec509","Net UBI (509)","unreltxincls511tx509","990 Sch A_Pt III-10b(f)","numeric",515769,515769,0.0,1625,-2363980,247648509.0,"2013-2024"]
["tax_year","Calendar year the filing's fiscal period ended (substr(tax_period, 1, 4)).","","pipeline-derived","integer",515769,515769,0.0,1,2023,2023.0,"all"]
["tax_month","Month the filing's fiscal period ended (substr(tax_period, 5, 6)).","","pipeline-derived","integer",515769,515769,0.0,12,1,12.0,"all"]
["is_501c3","TRUE if subsection_cd == 3, else FALSE. Strict boolean, never NA.","","pipeline-derived","boolean",515769,515769,0.0,2,null,null,"all"]
["extract_year","Processing year of the IRS SOI extract that supplied this row.","","pipeline-derived","integer",515769,515769,0.0,2,2023,2024.0,"all"]
["is_amendment","TRUE if the same (ein, tax_period) appeared in an earlier extract_year for this series.","","pipeline-derived","boolean",515769,515769,0.0,1,null,null,"all"]
["source_form","990combined only: '990' or '990ez' indicating which source form this row came from.","","pipeline-derived","character",515769,515769,0.0,2,null,null,"all"]