{"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":"int32"},{"name":"max_value","type":"int64"},{"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":"int32","nullable":true,"metadata":null,"children":null},{"name":"max_value","type":"int64","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 int32 field_id=-1 min_value;\n  optional int64 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",193060,193060,0.0,192846,null,null,"2013-2024|2012"]
["tax_period","Tax period","tax_pd|taxpd|tax_prd|taxprd|a_tax_prd","Form 990-EZ Header","character",193060,193060,0.0,12,null,null,"2013,2016|2017-2024|2012|2014|2015"]
["subsection_cd","Subsection code","subseccd","Form 990-EZ Header","integer",193060,193060,0.0,18,2,25,"2012-2024"]
["total_contributions","Contributions, gifts, grants, etc received","totcntrbs","990-EZ_Pt I-1","numeric",193060,193060,0.0,76564,0,389918,"2012-2024"]
["program_service_revenue","Program service revenue","prgmservrev","990-EZ_Pt I-2","numeric",193060,193060,0.0,44776,0,199950,"2012-2024"]
["membership_dues_assessments","Membership dues and assessments","duesassesmnts","990-EZ_Pt I-3","numeric",193060,193060,0.0,31292,0,199994,"2012-2024"]
["investment_income","Investment income","othrinvstinc","990-EZ_Pt I-4","integer",193060,193060,0.0,8798,-29248,191432,"2012-2024"]
["gross_sales_other_assets","Gross amount from sale of assets","grsamtsalesastothr","990-EZ_Pt I-5a","numeric",193060,193060,0.0,4721,-118603,194195,"2012-2024"]
["cost_basis_other_assets","Cost or other basis and sales expenses","basisalesexpnsothr","990-EZ_Pt I-5b","numeric",193060,193060,0.0,4064,0,1057697,"2012-2024"]
["gain_loss_sales_other_assets","Gain or (loss) from sale of assets","gnsaleofastothr","990-EZ_Pt I-5c","numeric",193060,193060,0.0,5100,-1057697,189073,"2012-2024"]
["gross_income_gaming_activities","Gross income from gaming","grsincgaming","990-EZ_Pt I-6a","integer",193060,193060,0.0,4966,0,199484,"2012-2024"]
["gross_income_fundraising_events","Special events gross revenue","grsrevnuefndrsng","990-EZ_Pt I-6b","numeric",193060,193060,0.0,32765,0,199374,"2012-2024"]
["gaming_fundraising_direct_expenses","Special events direct expenses","direxpns","990-EZ_Pt I-6c","integer",193060,193060,0.0,26111,0,271278,"2012-2024"]
["net_income_fundraising_events","Special events net income (or loss)","netincfndrsng","990-EZ_Pt I-6d","numeric",193060,193060,0.0,32339,-240914,196681,"2012-2024"]
["gross_sales_inventory","Gross sales of inventory","grsalesminusret","990-EZ_Pt I-7a","numeric",193060,193060,0.0,13078,-2492,199567,"2012-2024"]
["cost_of_goods_sold","Less: cost of goods sold","costgoodsold","990-EZ_Pt I-7b","integer",193060,193060,0.0,11412,0,327370,"2012-2024"]
["net_income_inventory_sales","Gross profit (or loss) from sales of inventory","grsprft","990-EZ_Pt I-7c","integer",193060,193060,0.0,12533,-165867,199547,"2012-2024"]
["other_revenue_total_11e","Other revenue - total","othrevnue","990-EZ_Pt I-8","numeric",193060,193060,0.0,14449,0,199542,"2012-2024"]
["total_revenue","Total revenue","totrevnue","990-EZ_Pt I-9","numeric",193060,193060,0.0,108912,-890459,444769,"2012-2024"]
["total_expenses","Total expenses","totexpns","990-EZ_Pt I-17","numeric",193060,193060,0.0,107179,-17522,14760642,"2012-2024"]
["excess_or_deficit_for_year","Excess or deficit","totexcessyr","990-EZ_Pt I-18","numeric",193060,193060,0.0,74994,-14760268,223540,"2012-2024"]
["other_changes_net_assets_fund_balances","Other changes in net assets","othrchgsnetassetfnd","990-EZ_Pt I-20","numeric",193060,193060,0.0,16782,-13837283,24103019,"2012-2024"]
["total_assets_eoy","Total assets e-o-y","totassetsend","990-EZ_Pt II-25B","numeric",193060,193060,0.0,121009,-388322,835171,"2012-2024"]
["total_liabilities_eoy","Total liabilities e-o-y","totliabend","990-EZ_Pt II-26B","numeric",193060,193060,0.0,24218,-7815,14864940,"2012-2024"]
["total_net_assets_eoy","Net assets EOY","networthend|totnetassetsend","990-EZ_Pt I-21","numeric",193060,193060,0.0,123588,-14667516,7770881,"2013-2024|2012-2024"]
["unrelated_business_income_1k_cd","UBI over $1,000?","unrelbusincd","990-EZ_Pt V-35a","boolean",193060,193042,0.01,2,null,null,"2012-2024"]
["initiation_fees","Initiation fees and capital contributions","initiationfee","990-EZ_Pt V-39a","integer",193060,193060,0.0,1001,0,199889,"2012-2024"]
["gross_receipts_public_use","Gross receipts for public use of club facilities","grspublicrcpts","990-EZ_Pt V-39b","integer",193060,193060,0.0,524,0,10240460,"2012-2024"]
["non_pf_status_reason","Reason for non-PF status","nonpfrea","990-EZ Sch A_Pt I-1-11","integer",193060,152802,20.85,15,1,16,"2012-2024"]
["gifts_grants_received_sec170","Gifts grants membership fees received (170)","gftgrntrcvd170|gftgrntsrcvd170","990-EZ Sch A_Pt II-1(f)","numeric",193060,193060,0.0,47065,-7189,2867350795,"2012, 2017-2024|2013-2016"]
["tax_revenues_levied_sec170","Tax revenues levied (170)","txrevnuelevied170","990-EZ Sch A_Pt II-2(f)","numeric",193060,193060,0.0,694,-8,14519815,"2012-2024"]
["gov_services_value_sec170","Services or facilities furnished by gov (170)","srvcsval170","990-EZ Sch A_Pt II-3(f)","numeric",193060,193060,0.0,538,0,3250000,"2012-2024"]
["gross_income_interest_sec170","Gross income from interest etc (170)","grsinc170","990-EZ Sch A_Pt II-8(f)","integer",193060,193060,0.0,6544,-64392,1970801,"2012-2024"]
["gross_receipts_related_activities_sec170","Gross receipts from related activities (170)","grsrcptsrelatd170|grsrcptsrelated170","990-EZ Sch A_Pt II-12","numeric",193060,193060,0.0,10196,-48711,17035967,"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",193060,193060,0.0,69174,-298235,54590135,"2012-2024"]
["gross_receipts_admissions_sec509","Receipts from admissions merchandise etc (509)","grsrcptsadmiss509|grsrcptsadmissn509","990-EZ Sch A_Pt III-2(f)","numeric",193060,193060,0.0,40644,-113355,75456211,"2012, 2017-2024|2013-2016"]
["tax_revenues_levied_sec509","Tax revenues levied (509)","txrevnuelevied509","990-EZ Sch A_Pt III-4(f)","integer",193060,193060,0.0,473,-4007,1158767,"2012-2024"]
["gov_services_value_sec509","Services or facilities furnished by gov (509)","srvcsval509","990-EZ Sch A_Pt III-5(f)","numeric",193060,193060,0.0,351,-8235,1250000,"2012-2024"]
["total_support_subtotal_sec509","Subtotal total support (509)","subtotsuppinc509","990-EZ Sch A_Pt III-10c(f)","numeric",193060,193060,0.0,8069,-141768,5707137,"2012-2024"]
["total_support_sec509","Total support (509)","totsupp509","990-EZ Sch A_Pt III-13(f)","numeric",193060,193060,0.0,77255,-298235,87347234,"2012-2024"]
["significant_new_activity_cd","Activity not previously reported?","actvtynotprevrptcd","990-EZ_Pt V-33","boolean",193060,193052,0.0,2,null,null,"2013-2024"]
["changes_to_governing_docs_cd","Significant changes to governing docs?","chngsinorgcd","990-EZ_Pt V-34","boolean",193060,193051,0.0,2,null,null,"2013-2024"]
["liquidated_terminated_cd","Liquidation, dissolution, termination, or contraction","contractioncd","990-EZ_Pt V-36","boolean",193060,193029,0.02,2,null,null,"2013-2024"]
["efile_indicator","E-file indicator","efile|e-file|elf","n/a","boolean",193060,193060,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",193060,193060,0.0,1699,-27898,18519724,"2017-2024|2013-2016"]
["excess_over_2pct_sec170","Amount support exceeds total (170)","excds2pct170|exceeds2pct170","990-EZ Sch A_Pt II-5(f)","numeric",193060,193060,0.0,10759,-510,3941225,"2017-2024|2013-2016"]
["filed_form_1120pol_cd","File Form 1120-POL?","filedf1120polcd|filedfyyn0polcd","990-EZ_Pt V-37b","boolean",193060,191506,0.8,2,null,null,"2013-2024|2015"]
["filed_form_990t_cd","Organization Filed 990T","filedf990tcd","990-EZ_Pt V-35b","boolean",193060,184181,4.6,2,null,null,"2013-2024"]
["gross_income_interest_sec509","Gross income from interest etc (509)","grsinc509","990-EZ Sch A_Pt III-10a(f)","numeric",193060,193060,0.0,7984,-141768,5707137,"2013-2024"]
["gross_receipts_related_activities_sec509","Gross receipts from related activities (509)","grsrcptsactivities509|grsrcptsactvts509","990-EZ Sch A_Pt III-3(f)","numeric",193060,193060,0.0,8700,-71727,2065991,"2013-2016|2017-2024"]
["loans_to_officers_amount","Amount of loans to/from officers","loanstoofficers","990-EZ_Pt V-38b","numeric",193060,193060,0.0,1754,0,1708485,"2013-2024"]
["loan_to_interested_person_cd","Loans to/from officers, directors or trustees?","loanstoofficerscd","990-EZ_Pt V-38a","boolean",193060,193049,0.01,2,null,null,"2013-2024"]
["net_ubi_sec170","Net UBI (170)","netincunrelatd170|netincunreltd170","990-EZ Sch A_Pt II-9(f)","integer",193060,193060,0.0,1244,-33444,492820,"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",193060,193060,0.0,1321,-77034,727413,"2013-2016|2017-2024"]
["other_income_sec170","Other income (170)","othrinc170","990-EZ Sch A_Pt II-10(f)","numeric",193060,193060,0.0,6001,-53702,1095093,"2013-2024"]
["other_income_sec509","Other income (509)","othrinc509","990-EZ Sch A_Pt III-12(f)","numeric",193060,193060,0.0,5465,-105625,13418111,"2013-2024"]
["political_expenditures","Direct or indirect political expenditures.","politicalexpend","990-EZ_Pt V-37a","integer",193060,193060,0.0,237,0,136067,"2013-2024"]
["prohibited_tax_shelter_cd","Party to a prohibited tax shelter transaction?","prohibtdtxshltrcd","990-EZ_Pt V-40e","boolean",193060,192753,0.16,2,null,null,"2013-2024"]
["public_support_sec170","Public support (170)","pubsupplesspct170","990-EZ Sch A_Pt II-6(f)","numeric",193060,193060,0.0,46894,-211756,2867350795,"2013-2024"]
["public_support_sec509","Public support (509)","pubsupplesssub509|pubsupplesub509","990-EZ Sch A_Pt III-8(f)","numeric",193060,193060,0.0,76635,-298235,81034257,"2017-2024|2013-2016"]
["public_support_subtotal_sec170","Public support subtotal (170)","pubsuppsubtot170","990-EZ Sch A_Pt II-4(f)","numeric",193060,193060,0.0,47195,-7189,2867350795,"2013-2024"]
["public_support_subtotal_line6_sec509","Public support subtotal (509)","pubsuppsubtot509","990-EZ Sch A_Pt III-6(f)","numeric",193060,193060,0.0,76888,-298235,81034257,"2013-2024"]
["disqualified_persons_amts_sec509","Amounts from disqualified persons (509)","rcvdfrmdisqualsub509","990-EZ Sch A_Pt III-7a(f)","numeric",193060,193060,0.0,3557,-32048,1280000,"2013-2024"]
["excess_benefit_transaction_cd","Section 4958 excess benefit transactions?","s4958excessbenefcd","990-EZ_Pt V-40b","boolean",193060,191981,0.56,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",193060,193060,0.0,47207,-7189,2867350795,"2013-2024"]
["public_support_subtotal_line6_ref_sec509","Public support from line 6 (509)","samepubsuppsubtot509","990-EZ Sch A_Pt III-9(f)","numeric",193060,193060,0.0,76886,-298235,81034257,"2013-2024"]
["public_support_subtotal_line7c_sec509","Public support subtotal (509)","subtotpub509","990-EZ Sch A_Pt III-7c(f)","numeric",193060,193060,0.0,4700,-27898,18519724,"2013-2024"]
["n_orgs_supported","Number of organizations supported","totnoforgscnt|totnooforgscnt","990-EZ Sch A_Pt I-11h","integer",193060,193060,0.0,34,0,27846,"2017-2024|2013-2016"]
["total_support_sec170","Total support (170)","totsupp170|totsupport170","990-EZ Sch A_Pt II-11(f)","numeric",193060,193060,0.0,47619,-7189,2867459033,"2013-2016|2017-2024"]
["total_support_amount","Sum of amounts of support","totsupport","990-EZ Sch A_Pt I-11h(vii)","numeric",193060,193060,0.0,1612,-1,14760642,"2013-2024"]
["net_ubi_line10b_sec509","Net UBI (509)","unreltxincls511tx509","990-EZ Sch A_Pt III-10b(f)","numeric",193060,193060,0.0,318,-52184,205343,"2013-2024"]
["tax_year","Calendar year the filing's fiscal period ended (substr(tax_period, 1, 4)).","","pipeline-derived","integer",193060,193060,0.0,1,2022,2022,"all"]
["tax_month","Month the filing's fiscal period ended (substr(tax_period, 5, 6)).","","pipeline-derived","integer",193060,193060,0.0,12,1,12,"all"]
["is_501c3","TRUE if subsection_cd == 3, else FALSE. Strict boolean, never NA.","","pipeline-derived","boolean",193060,193060,0.0,2,null,null,"all"]
["extract_year","Processing year of the IRS SOI extract that supplied this row.","","pipeline-derived","integer",193060,193060,0.0,3,2022,2024,"all"]
["is_amendment","TRUE if the same (ein, tax_period) appeared in an earlier extract_year for this series.","","pipeline-derived","boolean",193060,193060,0.0,1,null,null,"all"]