{"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":66,"rows_kept":66,"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",524386,524386,0.0,522864,null,null,"2012-2024"]
["efile_indicator","E-file indicator","efile|elf","n/a","boolean",524386,524386,0.0,2,null,null,"2020-2024|2015-2019"]
["excess_benefit_transaction_cd","Excess benefit transaction?","engageexcessbnftcd","990 Core_Pt IV-25a","boolean",524386,524315,0.01,2,null,null,"2013-2024"]
["excess_over_1pct_sec509","Amount support exceeds total (509)","exceeds1pct509","990 Sch A_Pt III-7b(f)","numeric",524386,524386,0.0,8472,-1500000,2008682657.0,"2013-2024"]
["excess_over_2pct_sec170","Amount support exceeds total (170)","exceeds2pct170","990 Sch A_Pt II-5(f)","numeric",524386,524386,0.0,43396,-16474140,5340724842.0,"2013-2024"]
["filed_form_990t_cd","Form 990-T filed?","filedf990tcd","990 Core_Pt V-3b","boolean",524386,524139,0.05,2,null,null,"2013-2024"]
["gifts_grants_received_sec170","Gifts grants membership fees received (170)","gftgrntsrcvd170","990 Sch A_Pt II-1(f)","numeric",524386,524386,0.0,147581,-243706,20491199708.0,"2012-2024"]
["gross_sales_inventory","Gross sales of inventory","grsalesinvent","990 Core_Pt VIII-10a","numeric",524386,524386,0.0,45216,-28294,1051437549.0,"2012-2024"]
["gross_income_interest_sec170","Gross income from interest etc (170)","grsinc170","990 Sch A_Pt II-8(f)","numeric",524386,524386,0.0,47636,-1616915,3398443981.0,"2012-2024"]
["gross_income_interest_sec509","Gross income from interest etc (509)","grsinc509","990 Sch A_Pt III-10a(f)","integer",524386,524386,0.0,33784,-1174930,697952753.0,"2013-2024"]
["gross_income_fundraising_events","Gross fundraising","grsincfndrsng","990 Core_Pt VIII-8a","numeric",524386,524386,0.0,79420,-179669,65250811.0,"2012-2024"]
["gross_income_gaming_activities","Gross income from gaming","grsincgaming","990 Core_Pt VIII-9a","numeric",524386,524386,0.0,18781,-16647,48069428.0,"2012-2024"]
["gross_receipts_related_activities_sec509","Gross receipts from related activities (509)","grsrcptsactivities509","990 Sch A_Pt III-3(f)","numeric",524386,524386,0.0,18533,-22802911,313660557.0,"2013-2024"]
["gross_receipts_admissions_sec509","Receipts from admissions merchandise etc (509)","grsrcptsadmissn509","990 Sch A_Pt III-2(f)","numeric",524386,524386,0.0,108456,-2445130,227000000000.0,"2012-2024"]
["gross_receipts_public_use","Gross receipts amount","grsrcptspublicuse","990 Core_Pt V-10b","numeric",524386,524386,0.0,3110,-1667296,7838055.0,"2012-2024"]
["gross_receipts_related_activities_sec170","Gross receipts from related activities (170)","grsrcptsrelated170","990 Sch A_Pt II-12","numeric",524386,524386,0.0,55198,-7482866,35108219419.0,"2012-2024"]
["initiation_fees","Initiation fees amount","initiationfees","990 Core_Pt V-10a","numeric",524386,524386,0.0,3617,-746698,28002125.0,"2012-2024"]
["investment_income","Investment income","invstmntinc","990 Core_Pt VIII-3(A)","numeric",524386,524386,0.0,67180,-107173812,1706372427.0,"2012-2024"]
["cost_of_goods_sold","Cost of goods sold (inventory)","lesscstofgoods","990 Core_Pt VIII-10b","numeric",524386,524386,0.0,39201,-111884,655793344.0,"2012-2024"]
["loan_to_interested_person_cd","Loan to officer or DQP?","loantofficercd","990 Core_Pt IV-26","boolean",524386,524382,0.0,2,null,null,"2013-2024"]
["other_revenue_total_11e","Other revenue","miscrevtot11e","990 Core_Pt VIII-11e(A)","numeric",524386,524386,0.0,60336,-79938913,1225046680.0,"2012-2024"]
["net_income_fundraising_events","Fundraising income","netincfndrsng","990 Core_Pt VIII-8c(A)","numeric",524386,524386,0.0,72994,-23452690,20150409.0,"2012-2024"]
["net_income_inventory_sales","Income from sales of inventory","netincsales","990 Core_Pt VIII-10c(A)","numeric",524386,524386,0.0,39983,-39394174,445447266.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",524386,524386,0.0,5458,-2127161,73112741.0,"2013-2024"]
["net_ubi_sec170","Net UBI (170)","netincunreltd170","990 Sch A_Pt II-9(f)","integer",524386,524386,0.0,8238,-3997195,73652874.0,"2013-2024"]
["non_pf_status_reason","Reason for non-PF status","nonpfrea","990 Sch A_Pt I-1-11","integer",524386,522866,0.29,17,0,16.0,"2012-2024"]
["other_income_sec170","Other income (170)","othrinc170","990 Sch A_Pt II-10(f)","numeric",524386,524386,0.0,38395,-24384688,2154743214.0,"2013-2024"]
["other_income_sec509","Other income (509)","othrinc509","990 Sch A_Pt III-12(f)","numeric",524386,524386,0.0,23229,-79938913,875997011.0,"2013-2024"]
["prohibited_tax_shelter_cd","Prohibited tax shelter transaction?","prohibtdtxshltrcd","990 Core_Pt V-5a","boolean",524386,524376,0.0,2,null,null,"2013-2024"]
["public_support_sec170","Public support (170)","pubsupplesspct170","990 Sch A_Pt II-6(f)","numeric",524386,524386,0.0,147077,-15323920,20491199708.0,"2013-2024"]
["public_support_sec509","Public support (509)","pubsupplesub509","990 Sch A_Pt III-8(f)","numeric",524386,524386,0.0,159422,-5188013,227000000000.0,"2013-2024"]
["public_support_subtotal_sec170","Public support subtotal (170)","pubsuppsubtot170","990 Sch A_Pt II-4(f)","numeric",524386,524386,0.0,148176,-243706,20491199708.0,"2013-2024"]
["public_support_subtotal_line6_sec509","Public support subtotal (509)","pubsuppsubtot509","990 Sch A_Pt III-6(f)","numeric",524386,524386,0.0,160600,-2445130,227000000000.0,"2013-2024"]
["disqualified_persons_amts_sec509","Amounts from disqualified persons (509)","rcvdfrmdisqualsub509","990 Sch A_Pt III-7a(f)","numeric",524386,524386,0.0,12648,0,309687641.0,"2013-2024"]
["public_support_subtotal_line4_ref_sec170","Public support from line 4 (170)","samepubsuppsubtot170","990 Sch A_Pt II-7(f)","numeric",524386,524386,0.0,148030,-243706,20491199708.0,"2013-2024"]
["public_support_subtotal_line6_ref_sec509","Public support from line 6 (509)","samepubsuppsubtot509","990 Sch A_Pt III-9(f)","numeric",524386,524386,0.0,160434,-2445130,227000000000.0,"2013-2024"]
["gov_services_value_sec170","Services or facilities furnished by gov (170)","srvcsval170","990 Sch A_Pt II-3(f)","numeric",524386,524386,0.0,3306,0,254553232.0,"2012-2024"]
["gov_services_value_sec509","Services or facilities furnished by gov (509)","srvcsval509","990 Sch A_Pt III-5(f)","numeric",524386,524386,0.0,1158,-63908,38448361.0,"2012-2024"]
["subsection_cd","Subsection code","subseccd","Form 990 Header","integer",524386,524386,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",524386,524386,0.0,18396,-66400,2008682657.0,"2013-2024"]
["total_support_subtotal_sec509","Subtotal total support (509)","subtotsuppinc509","990 Sch A_Pt III-10c(f)","integer",524386,524386,0.0,34161,-1174930,895501827.0,"2012-2024"]
["tax_period","Tax period","tax_pd|tax_prd","Form 990 Header","character",524386,524386,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",524386,524386,0.0,361090,-32065682,84809384257.0,"2012-2024"]
["total_contributions","Total contributions","totcntrbgfts","990 Core_Pt VIII-1h(A)","numeric",524386,524386,0.0,226450,-654611,5061181767.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",524386,524386,0.0,340432,-128684882,50977670187.0,"2012-2024"]
["total_gifts_grants_received_sec509","Gifts grants membership fees received (509)","totgftgrntrcvd509","990 Sch A_Pt III-1(f)","numeric",524386,524386,0.0,135362,-150000,7195317000.0,"2012-2024"]
["total_liabilities_eoy","Total liabilities -- eoy","totliabend","990 Core_Pt X-26(B)","numeric",524386,524386,0.0,174588,-45628505,77083770334.0,"2012-2024"]
["total_net_assets_eoy","Total Net Assets -- eoy","totnetassetend","990 Core_Pt X-33(B)","numeric",524386,524386,0.0,359435,-4024142141,56725510973.0,"2012-2024"]
["n_orgs_supported","Number of organizations supported","totnooforgscnt","990 Sch A_Pt I-11h","integer",524386,524386,0.0,76,0,83029.0,"2013-2024"]
["program_service_revenue","Program service revenue","totprgmrevnue","990 Core_Pt VIII-2g(A)","numeric",524386,524386,0.0,203244,-53698341,50930020265.0,"2012-2024"]
["total_revenue","Total revenue","totrevenue","990 Core_Pt VIII-12(A)","numeric",524386,524386,0.0,347389,-161526595,51065716534.0,"2012-2024"]
["total_support_sec170","Total support (170)","totsupp170","990 Sch A_Pt II-11(f)","numeric",524386,524386,0.0,149625,-2051666,21013107000.0,"2013-2024"]
["total_support_sec509","Total support (509)","totsupp509","990 Sch A_Pt III-13(f)","numeric",524386,524386,0.0,161103,-2445130,227123576904.0,"2012-2024"]
["total_support_amount","Sum of amounts of support","totsupport","990 Sch A_Pt I-11h(vii)","numeric",524386,524386,0.0,10318,-54126,3023207431.0,"2013-2024"]
["tax_revenues_levied_sec170","Tax revenues levied (170)","txrevnuelevied170","990 Sch A_Pt II-2(f)","numeric",524386,524386,0.0,3137,-28133,887118042.0,"2012-2024"]
["tax_revenues_levied_sec509","Tax revenues levied (509)","txrevnuelevied509","990 Sch A_Pt III-4(f)","integer",524386,524386,0.0,1173,-511,120327682.0,"2012-2024"]
["unrelated_business_income_1k_cd","Unrelated business income?","unrelbusinccd","990 Core_Pt V-3a","boolean",524386,524379,0.0,2,null,null,"2012-2024"]
["net_ubi_line10b_sec509","Net UBI (509)","unreltxincls511tx509","990 Sch A_Pt III-10b(f)","numeric",524386,524386,0.0,1754,-1018302,197549074.0,"2013-2024"]
["tax_year","Calendar year the filing's fiscal period ended (substr(tax_period, 1, 4)).","","pipeline-derived","integer",524386,524386,0.0,1,2016,2016.0,"all"]
["tax_month","Month the filing's fiscal period ended (substr(tax_period, 5, 6)).","","pipeline-derived","integer",524386,524386,0.0,12,1,12.0,"all"]
["is_501c3","TRUE if subsection_cd == 3, else FALSE. Strict boolean, never NA.","","pipeline-derived","boolean",524386,524386,0.0,2,null,null,"all"]
["extract_year","Processing year of the IRS SOI extract that supplied this row.","","pipeline-derived","integer",524386,524386,0.0,9,2016,2024.0,"all"]
["is_amendment","TRUE if the same (ein, tax_period) appeared in an earlier extract_year for this series.","","pipeline-derived","boolean",524386,524386,0.0,1,null,null,"all"]
["source_form","990combined only: '990' or '990ez' indicating which source form this row came from.","","pipeline-derived","character",524386,524386,0.0,2,null,null,"all"]
["source_pipeline","","","","character",524386,524386,0.0,1,null,null,""]
["has_legacy_augment","","","","boolean",524386,524386,0.0,1,null,null,""]