{"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":"double"},{"name":"max_value","type":"int32"},{"name":"years_present","type":"string"}],"n_rows":76,"rows_kept":76,"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":"double","nullable":true,"metadata":null,"children":null},{"name":"max_value","type":"int32","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 double field_id=-1 min_value;\n  optional int32 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|ein","Form 990-EZ Header","character",218552,218552,0.0,217968,null,null,"2013-2024|2012"]
["tax_period","Tax period","tax_pd|taxpd|tax_prd|taxprd|a_tax_prd","Form 990-EZ Header","character",218552,218552,0.0,12,null,null,"2013,2016|2017-2024|2012|2014|2015"]
["subsection_cd","Subsection code","subseccd","Form 990-EZ Header","integer",218552,218552,0.0,22,2.0,25,"2012-2024"]
["total_contributions","Contributions, gifts, grants, etc received","totcntrbs","990-EZ_Pt I-1","numeric",218552,218552,0.0,73972,-100000.0,679509,"2012-2024"]
["program_service_revenue","Program service revenue","prgmservrev","990-EZ_Pt I-2","numeric",218552,218552,0.0,50768,-955195.0,446161,"2012-2024"]
["membership_dues_assessments","Membership dues and assessments","duesassesmnts","990-EZ_Pt I-3","numeric",218552,218552,0.0,36952,-31787.0,610338,"2012-2024"]
["investment_income","Investment income","othrinvstinc","990-EZ_Pt I-4","integer",218552,218552,0.0,10475,-63607.0,197348,"2012-2024"]
["gross_sales_other_assets","Gross amount from sale of assets","grsamtsalesastothr","990-EZ_Pt I-5a","numeric",218552,218552,0.0,5389,-32806.0,511313,"2012-2024"]
["cost_basis_other_assets","Cost or other basis and sales expenses","basisalesexpnsothr","990-EZ_Pt I-5b","numeric",218552,218552,0.0,4671,-6724.0,413258,"2012-2024"]
["gain_loss_sales_other_assets","Gain or (loss) from sale of assets","gnsaleofastothr","990-EZ_Pt I-5c","integer",218552,218552,0.0,5418,-291351.0,511313,"2012-2024"]
["gross_income_gaming_activities","Gross income from gaming","grsincgaming","990-EZ_Pt I-6a","integer",218552,218552,0.0,6766,-74682.0,630147,"2012-2024"]
["gross_income_fundraising_events","Special events gross revenue","grsrevnuefndrsng","990-EZ_Pt I-6b","numeric",218552,218552,0.0,40835,-164245.0,353446,"2012-2024"]
["gaming_fundraising_direct_expenses","Special events direct expenses","direxpns","990-EZ_Pt I-6c","integer",218552,218552,0.0,32160,-63224.0,547310,"2012-2024"]
["net_income_fundraising_events","Special events net income (or loss)","netincfndrsng","990-EZ_Pt I-6d","numeric",218552,218552,0.0,36781,-345989.0,316230,"2012-2024"]
["gross_sales_inventory","Gross sales of inventory","grsalesminusret","990-EZ_Pt I-7a","integer",218552,218552,0.0,16605,-37460.0,399744,"2012-2024"]
["cost_of_goods_sold","Less: cost of goods sold","costgoodsold","990-EZ_Pt I-7b","numeric",218552,218552,0.0,14271,-24960.0,393630,"2012-2024"]
["net_income_inventory_sales","Gross profit (or loss) from sales of inventory","grsprft","990-EZ_Pt I-7c","numeric",218552,218552,0.0,14756,-354634.0,204524,"2012-2024"]
["other_revenue_total_11e","Other revenue - total","othrevnue","990-EZ_Pt I-8","numeric",218552,218552,0.0,16723,-65559.0,305050,"2012-2024"]
["total_revenue","Total revenue","totrevnue","990-EZ_Pt I-9","numeric",218552,218552,0.0,113971,-955195.0,679509,"2012-2024"]
["total_expenses","Total expenses","totexpns","990-EZ_Pt I-17","numeric",218552,218552,0.0,111032,-177366.0,14127108,"2012-2024"]
["excess_or_deficit_for_year","Excess or deficit","totexcessyr","990-EZ_Pt I-18","numeric",218552,218552,0.0,67781,-14098468.0,466490,"2012-2024"]
["other_changes_net_assets_fund_balances","Other changes in net assets","othrchgsnetassetfnd","990-EZ_Pt I-20","numeric",218552,218552,0.0,15464,-34072424.0,5623629,"2012-2024"]
["total_assets_eoy","Total assets e-o-y","totassetsend","990-EZ_Pt II-25B","numeric",218552,218552,0.0,120477,-2604447.0,2119304,"2012-2024"]
["total_liabilities_eoy","Total liabilities e-o-y","totliabend","990-EZ_Pt II-26B","numeric",218552,218552,0.0,26240,-531400.0,187190920,"2012-2024"]
["total_net_assets_eoy","Net assets EOY","networthend|totnetassetsend","990-EZ_Pt I-21","numeric",218552,218552,0.0,123547,-186741265.0,2119304,"2013-2024|2012-2024"]
["unrelated_business_income_1k_cd","UBI over $1,000?","unrelbusincd","990-EZ_Pt V-35a","boolean",218552,218548,0.0,2,null,null,"2012-2024"]
["initiation_fees","Initiation fees and capital contributions","initiationfee","990-EZ_Pt V-39a","integer",218552,218552,0.0,1043,-2000.0,425675,"2012-2024"]
["gross_receipts_public_use","Gross receipts for public use of club facilities","grspublicrcpts","990-EZ_Pt V-39b","integer",218552,218552,0.0,556,0.0,198110,"2012-2024"]
["non_pf_status_reason","Reason for non-PF status","nonpfrea","990-EZ Sch A_Pt I-1-11","integer",218552,215968,1.18,17,0.0,16,"2012-2024"]
["gifts_grants_received_sec170","Gifts grants membership fees received (170)","gftgrntrcvd170|gftgrntsrcvd170","990-EZ Sch A_Pt II-1(f)","numeric",218552,218552,0.0,49608,-137821.0,120540629,"2012, 2017-2024|2013-2016"]
["tax_revenues_levied_sec170","Tax revenues levied (170)","txrevnuelevied170","990-EZ Sch A_Pt II-2(f)","numeric",218552,218552,0.0,874,-3040.0,13288030,"2012-2024"]
["gov_services_value_sec170","Services or facilities furnished by gov (170)","srvcsval170","990-EZ Sch A_Pt II-3(f)","numeric",218552,218552,0.0,694,0.0,5954085,"2012-2024"]
["gross_income_interest_sec170","Gross income from interest etc (170)","grsinc170","990-EZ Sch A_Pt II-8(f)","integer",218552,218552,0.0,6908,-46659.0,1510691,"2012-2024"]
["gross_receipts_related_activities_sec170","Gross receipts from related activities (170)","grsrcptsrelatd170|grsrcptsrelated170","990-EZ Sch A_Pt II-12","numeric",218552,218552,0.0,11880,-63607.0,14385977,"2012, 2017-2024|2013-2016"]
["total_gifts_grants_received_sec509","Gifts grants membership fees received (509)","totgftgrntrcvd509","990-EZ Sch A_Pt III-1(f)","numeric",218552,218552,0.0,70743,-97939.0,15446338,"2012-2024"]
["gross_receipts_admissions_sec509","Receipts from admissions merchandise etc (509)","grsrcptsadmiss509|grsrcptsadmissn509","990-EZ Sch A_Pt III-2(f)","numeric",218552,218552,0.0,47975,-174517.0,57227222,"2012, 2017-2024|2013-2016"]
["tax_revenues_levied_sec509","Tax revenues levied (509)","txrevnuelevied509","990-EZ Sch A_Pt III-4(f)","integer",218552,218552,0.0,455,0.0,1607246,"2012-2024"]
["gov_services_value_sec509","Services or facilities furnished by gov (509)","srvcsval509","990-EZ Sch A_Pt III-5(f)","numeric",218552,218552,0.0,427,0.0,2613485,"2012-2024"]
["total_support_subtotal_sec509","Subtotal total support (509)","subtotsuppinc509","990-EZ Sch A_Pt III-10c(f)","integer",218552,218552,0.0,8222,-83083.0,1498116,"2012-2024"]
["total_support_sec509","Total support (509)","totsupp509","990-EZ Sch A_Pt III-13(f)","numeric",218552,218552,0.0,81440,-327704.0,63412272,"2012-2024"]
["significant_new_activity_cd","Activity not previously reported?","actvtynotprevrptcd","990-EZ_Pt V-33","boolean",218552,218549,0.0,2,null,null,"2013-2024"]
["changes_to_governing_docs_cd","Significant changes to governing docs?","chngsinorgcd","990-EZ_Pt V-34","boolean",218552,218549,0.0,2,null,null,"2013-2024"]
["liquidated_terminated_cd","Liquidation, dissolution, termination, or contraction","contractioncd","990-EZ_Pt V-36","boolean",218552,218545,0.0,2,null,null,"2013-2024"]
["efile_indicator","E-file indicator","efile|e-file|elf","n/a","boolean",218552,218552,0.0,2,null,null,"2021-2024|2020|2015-2019"]
["excess_over_1pct_sec509","Amount support exceeds total (509)","excds1pct509|exceeds1pct509","990-EZ Sch A_Pt III-7b(f)","numeric",218552,218552,0.0,1954,0.0,3210592,"2017-2024|2013-2016"]
["excess_over_2pct_sec170","Amount support exceeds total (170)","excds2pct170|exceeds2pct170","990-EZ Sch A_Pt II-5(f)","numeric",218552,218552,0.0,11012,-92721.0,6526561,"2017-2024|2013-2016"]
["filed_form_1120pol_cd","File Form 1120-POL?","filedf1120polcd|filedfyyn0polcd","990-EZ_Pt V-37b","boolean",218552,218537,0.01,2,null,null,"2013-2024|2015"]
["filed_form_990t_cd","Organization Filed 990T","filedf990tcd","990-EZ_Pt V-35b","boolean",218552,218346,0.09,2,null,null,"2013-2024"]
["gross_income_interest_sec509","Gross income from interest etc (509)","grsinc509","990-EZ Sch A_Pt III-10a(f)","integer",218552,218552,0.0,8077,-83083.0,1498116,"2013-2024"]
["gross_receipts_related_activities_sec509","Gross receipts from related activities (509)","grsrcptsactivities509|grsrcptsactvts509","990-EZ Sch A_Pt III-3(f)","numeric",218552,218552,0.0,9027,-17053.0,7345647,"2013-2016|2017-2024"]
["loans_to_officers_amount","Amount of loans to/from officers","loanstoofficers","990-EZ_Pt V-38b","numeric",218552,218552,0.0,2374,-86728.0,1516401,"2013-2024"]
["loan_to_interested_person_cd","Loans to/from officers, directors or trustees?","loanstoofficerscd","990-EZ_Pt V-38a","boolean",218552,218545,0.0,2,null,null,"2013-2024"]
["net_ubi_sec170","Net UBI (170)","netincunrelatd170|netincunreltd170","990-EZ Sch A_Pt II-9(f)","integer",218552,218552,0.0,1476,-31364.0,592382,"2017-2024|2013-2016"]
["net_ubi_excl_10b_sec509","Net income from UBI not in 10b (509)","netincunrelatd509|netincunreltd509","990-EZ Sch A_Pt III-11(f)","integer",218552,218552,0.0,1433,-125309.0,1306990,"2013-2016|2017-2024"]
["other_income_sec170","Other income (170)","othrinc170","990-EZ Sch A_Pt II-10(f)","numeric",218552,218552,0.0,7387,-64092.0,89371710,"2013-2024"]
["other_income_sec509","Other income (509)","othrinc509","990-EZ Sch A_Pt III-12(f)","numeric",218552,218552,0.0,6287,-1225401.0,6276089,"2013-2024"]
["political_expenditures","Direct or indirect political expenditures.","politicalexpend","990-EZ_Pt V-37a","integer",218552,218552,0.0,243,0.0,196636,"2013-2024"]
["prohibited_tax_shelter_cd","Party to a prohibited tax shelter transaction?","prohibtdtxshltrcd","990-EZ_Pt V-40e","boolean",218552,218539,0.01,2,null,null,"2013-2024"]
["public_support_sec170","Public support (170)","pubsupplesspct170","990-EZ Sch A_Pt II-6(f)","numeric",218552,218552,0.0,49315,-213034.0,120540629,"2013-2024"]
["public_support_sec509","Public support (509)","pubsupplesssub509|pubsupplesub509","990-EZ Sch A_Pt III-8(f)","numeric",218552,218552,0.0,80569,-97939.0,57797577,"2017-2024|2013-2016"]
["public_support_subtotal_sec170","Public support subtotal (170)","pubsuppsubtot170","990-EZ Sch A_Pt II-4(f)","numeric",218552,218552,0.0,49783,-137821.0,120540629,"2013-2024"]
["public_support_subtotal_line6_sec509","Public support subtotal (509)","pubsuppsubtot509","990-EZ Sch A_Pt III-6(f)","numeric",218552,218552,0.0,81149,-97939.0,57797577,"2013-2024"]
["disqualified_persons_amts_sec509","Amounts from disqualified persons (509)","rcvdfrmdisqualsub509","990-EZ Sch A_Pt III-7a(f)","numeric",218552,218552,0.0,4004,0.0,3800000,"2013-2024"]
["excess_benefit_transaction_cd","Section 4958 excess benefit transactions?","s4958excessbenefcd","990-EZ_Pt V-40b","boolean",218552,218482,0.03,2,null,null,"2013-2024"]
["public_support_subtotal_line4_ref_sec170","Public support from line 4 (170)","samepubsuppsubtot170","990-EZ Sch A_Pt II-7(f)","numeric",218552,218552,0.0,49700,-137821.0,120540629,"2013-2024"]
["public_support_subtotal_line6_ref_sec509","Public support from line 6 (509)","samepubsuppsubtot509","990-EZ Sch A_Pt III-9(f)","numeric",218552,218552,0.0,81068,-97939.0,57797577,"2013-2024"]
["public_support_subtotal_line7c_sec509","Public support subtotal (509)","subtotpub509","990-EZ Sch A_Pt III-7c(f)","numeric",218552,218552,0.0,5468,0.0,3800000,"2013-2024"]
["n_orgs_supported","Number of organizations supported","totnoforgscnt|totnooforgscnt","990-EZ Sch A_Pt I-11h","integer",218552,218552,0.0,26,0.0,34,"2017-2024|2013-2016"]
["total_support_sec170","Total support (170)","totsupp170|totsupport170","990-EZ Sch A_Pt II-11(f)","numeric",218552,218552,0.0,50296,-137821.0,120540629,"2013-2016|2017-2024"]
["total_support_amount","Sum of amounts of support","totsupport","990-EZ Sch A_Pt I-11h(vii)","numeric",218552,218552,0.0,2239,-10848.0,547926,"2013-2024"]
["net_ubi_line10b_sec509","Net UBI (509)","unreltxincls511tx509","990-EZ Sch A_Pt III-10b(f)","integer",218552,218552,0.0,420,-168149.0,622671,"2013-2024"]
["tax_year","Calendar year the filing's fiscal period ended (substr(tax_period, 1, 4)).","","pipeline-derived","integer",218552,218552,0.0,1,2017.0,2017,"all"]
["tax_month","Month the filing's fiscal period ended (substr(tax_period, 5, 6)).","","pipeline-derived","integer",218552,218552,0.0,12,1.0,12,"all"]
["is_501c3","TRUE if subsection_cd == 3, else FALSE. Strict boolean, never NA.","","pipeline-derived","boolean",218552,218552,0.0,2,null,null,"all"]
["extract_year","Processing year of the IRS SOI extract that supplied this row.","","pipeline-derived","integer",218552,218552,0.0,8,2017.0,2024,"all"]
["is_amendment","TRUE if the same (ein, tax_period) appeared in an earlier extract_year for this series.","","pipeline-derived","boolean",218552,218552,0.0,2,null,null,"all"]