{"success":true,"data":{"_id":510245295,"filings":[{"Organization":{"value":null,"Person":["STEVE CERONI","WILLIAM SPRAGUE","GARY STATDFIELD","JAMES ZWEEP","GREG HILL","BRIAN HELM","KEVIN SCHIAVO","TOM SETTERSTROM","TEX SHOCKEY","GENE MEAD","RICHARD B LUNDVALL"],"Title":["DIRECTOR","DIRECTOR","DIRECTOR","2ND VP","TREASURER","DIRECTOR","DIRECTOR","DIRECTOR","1ST VP","PRESIDENT","EXECUTIVE VICE PRESIDENT"],"Hours":[1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,5.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,0,65112],"Direct compensation":[0,0,0,0,0,0,0,0,0,0,56881],"Other compensation":[0,0,0,0,0,0,0,0,0,0,8231]},"Basic":{"value":null,"mission":"To provide education resources for contributing members.","year":2016,"name":"PIPING INDUSTRY COUNCIL OF THE ROCKFORD Area Trustees","phone":5633456450,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"RICK LUNDVALL","year_formation":1964,"state_legal_domicile":"IL","total_volunteers":0,"tax_period_begin":"2016-01-01T00:00:00","tax_period_end":"2016-12-31T00:00:00","address":"1983 Spruce Hills Drive, Bettendorf, IA, 52722, USA","city":"Bettendorf","state":"IA","country":"USA","zip_code":52722},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":10,"Number of independent voting members":10,"Number of employees total":1,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":1,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":false,"Premiums Paid":false,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":251879,"Contributions":{"value":0,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":248344,"Total revenue":248344,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":3535,"Investment income total":5308,"Net investment gain":-1773,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":215674,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":71167,"Current officers":56881,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":8231,"Other employee benefits":0,"Payroll taxes":6055},"Other expenses":{"value":144507,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":4174,"Advertising":1000,"Office expenses":910,"Information technology":0,"Royalties":0,"Occupancy":1800,"Travel":3320,"Conferences and meetings":14503,"Interest":0,"Payments to affiliates":32548,"Depreciation and depletion":0,"Insurance":4053,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":77283,"Seminars":39806,"Seminar Retreat":17165,"Education Reimbursement":12372,"Valentine/Installation":7940},"All other expenses":4916},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":398899,"Non-interest bearing cash":64340,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":306573,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":27986},"Liabilities":{"value":42,"Sum of Total Liabilities":0,"Accounts payable, accrued":42,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":398857,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":398857,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.14373965276978232,"percentile":0.6902385503514699},"Liabilities to Assets Ratio":{"score":0.00010528981020258261,"percentile":0.5855902581472978},"Operating Reserve Ratio":{"score":1.8495460741674936,"percentile":0.595416691001825},"Officer Compensation Ratio":{"score":0.30190008995057355,"percentile":0.1853129622909755},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.08444402128099317,"percentile":0.7250820372966286},"Asset Growth":{"score":0.06370390181357136,"percentile":0.5766694039267954},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6109461296006375,"percentile":0.6371577937130016}},"source_xml":"201742449349300119_public.xml"},{"Organization":{"value":null,"Person":["STEVE CERONI","WILLIAM SPRAGUE","GARY STATDFIELD","JAMES ZWEEP","GREG HILL","BRIAN HELM","KEVIN SCHIAVO","TOM SETTERSTROM","TEX SHOCKEY","GENE MEAD","GARY LUNDVALL","RICHARD B LUNDVALL"],"Title":["PRESIDENT","DIRECTOR","DIRECTOR","TREASURER","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","VICE PRESIDENT","CHIEF FINANCIAL OFFICER","EXECUTIVE VICE PRESIDENT"],"Hours":[1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,10.0,10.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,0,6027,60863],"Direct compensation":[0,0,0,0,0,0,0,0,0,0,5303,53247],"Other compensation":[0,0,0,0,0,0,0,0,0,0,724,7616]},"Basic":{"value":null,"mission":"To provide education resources for contributing members.","year":2014,"name":"PIPING INDUSTRY COUNCIL OF THE ROCKFORD AREA TRUSTEES","phone":5633456450,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"RICK LUNDVALL","year_formation":1964,"state_legal_domicile":"IL","total_volunteers":0,"tax_period_begin":"2014-01-01T00:00:00","tax_period_end":"2014-12-31T00:00:00","address":"1983 SPRUCE HILLS DRIVE, BETTENDORF, IA, 52722, USA","city":"BETTENDORF","state":"IA","country":"USA","zip_code":52722},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":10,"Number of independent voting members":10,"Number of employees total":2,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":2,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":false,"Premiums Paid":false,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":205836,"Contributions":{"value":198527,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":198527,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":7309,"Investment income total":6497,"Net investment gain":812,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":183927,"Grant expense":{"value":15000,"Grants to domestic orgs":15000,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":73596,"Current officers":58550,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":8340,"Other employee benefits":0,"Payroll taxes":6706},"Other expenses":{"value":95331,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":3893,"Advertising":1000,"Office expenses":1325,"Information technology":0,"Royalties":0,"Occupancy":1800,"Travel":3825,"Conferences and meetings":12780,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":4443,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":63934,"SEMINARS":28530,"SEMINAR RETREAT":19633,"EDUCATION REIMBURSEMENT":10327,"VALENTINE/INSTALLATION":5444},"All other expenses":2331},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":347539,"Non-interest bearing cash":35283,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":0,"Investments other":294696,"Investments program related":0,"Intangible assets":0,"Other assets":17560},"Liabilities":{"value":2658,"Sum of Total Liabilities":0,"Accounts payable, accrued":2658,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":344881,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.10643910686177345,"percentile":0.6341537728471742},"Liabilities to Assets Ratio":{"score":0.007648062519602116,"percentile":0.5114112150604769},"Operating Reserve Ratio":{"score":1.8895485709004116,"percentile":0.6011358742539548},"Officer Compensation Ratio":{"score":0.3636768935501585,"percentile":0.1367958830737463},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":null,"percentile":null},"Asset Growth":{"score":null,"percentile":null},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5785900103316413,"percentile":0.5422626626800388}},"source_xml":"201531349349305773_public.xml"},{"Organization":{"value":null,"Person":["STEVE CERONI","WILLIAM SPRAGUE","GARY STATDFIELD","JAMES ZWEEP","GREG HILL","BRIAN HELM","KEVIN SCHIAVO","TOM SETTERSTROM","TEX SHOCKEY","GENE MEAD","RICHARD B LUNDVALL"],"Title":["DIRECTOR","DIRECTOR","DIRECTOR","2ND VP","TREASURER","DIRECTOR","DIRECTOR","DIRECTOR","1ST VP","PRESIDENT","EXECUTIVE VICE PRESIDENT"],"Hours":[1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,7.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,0,69176],"Direct compensation":[0,0,0,0,0,0,0,0,0,0,60945],"Other compensation":[0,0,0,0,0,0,0,0,0,0,8231]},"Basic":{"value":null,"mission":"To provide education resources for contributing members.","year":2017,"name":"PIPING INDUSTRY COUNCIL OF THE ROCKFORD AREA TRUSTEES","phone":5633456450,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"RICK LUNDVALL","year_formation":1964,"state_legal_domicile":"IL","total_volunteers":0,"tax_period_begin":"2017-01-01T00:00:00","tax_period_end":"2017-12-31T00:00:00","address":"1983 SPRUCE HILLS DRIVE, BETTENDORF, IA, 52722, USA","city":"BETTENDORF","state":"IA","country":"USA","zip_code":52722},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":10,"Number of independent voting members":10,"Number of employees total":1,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":1,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":false,"Premiums Paid":false,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":333227,"Contributions":{"value":0,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":323818,"Total revenue":323818,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":9409,"Investment income total":9013,"Net investment gain":396,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":252252,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":73937,"Current officers":60945,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":8231,"Other employee benefits":0,"Payroll taxes":4761},"Other expenses":{"value":178315,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":3079,"Advertising":500,"Office expenses":950,"Information technology":0,"Royalties":0,"Occupancy":1800,"Travel":3856,"Conferences and meetings":20634,"Interest":0,"Payments to affiliates":36000,"Depreciation and depletion":0,"Insurance":4881,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":99838,"SEMINARS":47276,"SEMINAR RETREAT":26244,"EDUCATION REIMBURSEMENT":16998,"VALENTINE/INSTALLATION":9320},"All other expenses":6777},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":504308,"Non-interest bearing cash":35907,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":446307,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":22094},"Liabilities":{"value":42,"Sum of Total Liabilities":0,"Accounts payable, accrued":42,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":504266,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":504266,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.24300251780317922,"percentile":0.7952672265701506},"Liabilities to Assets Ratio":{"score":8.328243850979956e-05,"percentile":0.5862015000827553},"Operating Reserve Ratio":{"score":1.9992229992229993,"percentile":0.6159806913906487},"Officer Compensation Ratio":{"score":0.2742337028051314,"percentile":0.2129157474773473},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.13677378575345447,"percentile":0.8306093955206978},"Asset Growth":{"score":0.11057129597852326,"percentile":0.7078316385964332},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6524380086003153,"percentile":0.747575135744602}},"source_xml":"201821349349304522_public.xml"},{"Organization":{"value":null,"Person":["JOSH CERONI","WILLIAM SPRAGUE","JESSE ARNDT","JAMES ZWEEP","GREG HILL","BRIAN HELM","KEVIN SCHIAVO","TODD DORN","SPENCER MEINERT","RICHARD LUNDVALL"],"Title":["SECRETARY/TREASURER","1ST VICE PRESIDENT","DIRECTOR","DIRECTOR","PRESIDENT","2ND VICE PRESIDENT","DIRECTOR","DIRECTOR","DIRECTOR","EXECUTIVE DIRECTOR"],"Hours":[1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,7.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,8231],"Direct compensation":[0,0,0,0,0,0,0,0,0,0],"Other compensation":[0,0,0,0,0,0,0,0,0,8231]},"Basic":{"value":null,"mission":"To provide educational resources on the piping industry.","year":2022,"name":"PIPING INDUSTRY COUNCIL OF THE ROCKFORD AREA TRUSTEES","phone":5633456450,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"RICHARD LUNDVALL","year_formation":1964,"state_legal_domicile":"IL","total_volunteers":0,"tax_period_begin":"2022-01-01T00:00:00","tax_period_end":"2022-12-31T00:00:00","address":"1983 SPRUCE HILLS DR, BETTENDORF, IA, 52722, USA","city":"BETTENDORF","state":"IA","country":"USA","zip_code":52722},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":9,"Number of independent voting members":9,"Number of employees total":0,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":false,"Premiums Paid":false,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":301768,"Contributions":{"value":0,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":295896,"Total revenue":295896,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":5872,"Investment income total":16716,"Net investment gain":-10844,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":244289,"Grant expense":{"value":1250,"Grants to domestic orgs":1250,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":0,"Current officers":0,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":0},"Other expenses":{"value":243039,"Management services":0,"Legal":0,"Accounting":1925,"Lobbying services":0,"Investment management fees":0,"Other services":2069,"Advertising":580,"Office expenses":0,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":16225,"Interest":0,"Payments to affiliates":84000,"Depreciation and depletion":0,"Insurance":1198,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":132626,"DUES":55517,"MCAA SEMINARS":52702,"EDUCATION REIMBURSEMENT":15728,"VALENTINE BANQUET":8679},"All other expenses":4416},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":684992,"Non-interest bearing cash":112944,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":546783,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":25265},"Liabilities":{"value":0,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":684992,"Net assets without donor restriction":684992,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.1904741390737255,"percentile":0.746535691452406},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":2.8040231037828147,"percentile":0.6976023284149031},"Officer Compensation Ratio":{"score":0.033693698856682046,"percentile":0.8403216141070265},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.04606667825316126,"percentile":0.5895369095743356},"Asset Growth":{"score":0.08908173659085651,"percentile":0.6546216006551481},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6859067122388534,"percentile":0.8237365017839633}},"source_xml":"202302229349300840_public.xml"},{"Organization":{"value":null,"Person":["JOSH CERONI","WILLIAM SPRAGUE","JESSE ARNDT","JAMES ZWEEP","GREG HILL","BRIAN HELM","KEVIN SCHIAVO","TODD DORN","SPENCER MEINERT","JAY DOYLE","RICHARD LUNDVALL"],"Title":["SECRETARY/TREASURER","1ST VICE PRESIDENT","DIRECTOR","DIRECTOR","PRESIDENT","2ND VICE PRESIDENT","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","EXECUTIVE DIRECTOR"],"Hours":[1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,7.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,0,8231],"Direct compensation":[0,0,0,0,0,0,0,0,0,0,0],"Other compensation":[0,0,0,0,0,0,0,0,0,0,8231]},"Basic":{"value":null,"mission":"To provide educational resources on the piping industry.","year":2023,"name":"PIPING INDUSTRY COUNCIL OF THE ROCKFORD AREA TRUSTEES","phone":5633456450,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"RICHARD LUNDVALL","year_formation":1964,"state_legal_domicile":"IL","total_volunteers":0,"tax_period_begin":"2023-01-01T00:00:00","tax_period_end":"2023-12-31T00:00:00","address":"1983 SPRUCE HILLS DR, BETTENDORF, IA, 52722, USA","city":"BETTENDORF","state":"IA","country":"USA","zip_code":52722},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":10,"Number of independent voting members":10,"Number of employees total":0,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":false,"Premiums Paid":false,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":360935,"Contributions":{"value":0,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":345309,"Total revenue":345309,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":15626,"Investment income total":21597,"Net investment gain":-5971,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":318502,"Grant expense":{"value":1250,"Grants to domestic orgs":1250,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":0,"Current officers":0,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":0},"Other expenses":{"value":317252,"Management services":0,"Legal":0,"Accounting":2256,"Lobbying services":0,"Investment management fees":5796,"Other services":2369,"Advertising":54,"Office expenses":0,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":24586,"Interest":0,"Payments to affiliates":96000,"Depreciation and depletion":0,"Insurance":1198,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":152293,"MCAA SEMINARS":71866,"DUES":37234,"SEMINAR RETREAT":25383,"EDUCATION REIMBURSEMENT":17810},"All other expenses":32700},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":780973,"Non-interest bearing cash":145548,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":607586,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":27839},"Liabilities":{"value":0,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":780973,"Net assets without donor restriction":780973,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.11756410434011665,"percentile":0.6519929263764758},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":2.4520191395972395,"percentile":0.6667991711832384},"Officer Compensation Ratio":{"score":0.02584285185022386,"percentile":0.881825911688474},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.05020478320392023,"percentile":0.6072450950501574},"Asset Growth":{"score":0.0912023392682937,"percentile":0.6603555485029131},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6709779553470454,"percentile":0.7912303917519918}},"source_xml":"202421349349304617_public.xml"},{"Organization":{"value":null,"Person":["STEVE CERONI","WILLIAM SPRAGUE","GARY STATDFIELD","JAMES ZWEEP","GREG HILL","BRIAN HELM","KEVIN SCHIAVO","TOM SETTERSTROM","TEX SHOCKEY","GENE MEAD","RICHARD B LUNDVALL"],"Title":["PRESIDENT","DIRECTOR","DIRECTOR","TREASURER","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","VICE PRESIDENT","EXECUTIVE VICE PRESIDENT"],"Hours":[1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,10.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,0,62609],"Direct compensation":[0,0,0,0,0,0,0,0,0,0,54694],"Other compensation":[0,0,0,0,0,0,0,0,0,0,7915]},"Basic":{"value":null,"mission":"To provide education resources for contributing members.","year":2015,"name":"PIPING INDUSTRY COUNCIL OF THE ROCKFORD AREA TRUSTEES","phone":5633456450,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"RICK LUNDVALL","year_formation":1964,"state_legal_domicile":"IL","total_volunteers":0,"tax_period_begin":"2015-01-01T00:00:00","tax_period_end":"2015-12-31T00:00:00","address":"1983 SPRUCE HILLS DRIVE, BETTENDORF, IA, 52722, USA","city":"BETTENDORF","state":"IA","country":"USA","zip_code":52722},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":10,"Number of independent voting members":10,"Number of employees total":1,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":1,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":false,"Premiums Paid":false,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":210646,"Contributions":{"value":205839,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":205839,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":4807,"Investment income total":6283,"Net investment gain":-1476,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":211997,"Grant expense":{"value":30000,"Grants to domestic orgs":30000,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":70255,"Current officers":54694,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":7915,"Other employee benefits":0,"Payroll taxes":7646},"Other expenses":{"value":111742,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":3775,"Advertising":200,"Office expenses":950,"Information technology":0,"Royalties":0,"Occupancy":1800,"Travel":3252,"Conferences and meetings":14237,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":4503,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":79340,"SEMINARS":36637,"SEMINAR RETREAT":26314,"EDUCATION REIMBURSEMENT":11911,"VALENTINE/INSTALLATION":4478},"All other expenses":3685},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":332360,"Non-interest bearing cash":29125,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":0,"Investments other":285509,"Investments program related":0,"Intangible assets":0,"Other assets":17726},"Liabilities":{"value":842,"Sum of Total Liabilities":0,"Accounts payable, accrued":842,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":331518,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-0.006413603866202064,"percentile":0.3689697247364256},"Liabilities to Assets Ratio":{"score":0.002533397520760621,"percentile":0.5506855578115244},"Operating Reserve Ratio":{"score":1.5677580343118063,"percentile":0.5506373049591786},"Officer Compensation Ratio":{"score":0.2953296508912862,"percentile":0.19140806047431388},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.04374022538437933,"percentile":0.5792517661011055},"Asset Growth":{"score":0.01914503422704507,"percentile":0.4002307933634011},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5204984727558597,"percentile":0.3747978904815891}},"source_xml":"201632019349301003_public.xml"},{"Organization":{"value":null,"Person":["STEVE CERONI","WILLIAM SPRAGUE","GARY STATDFIELD","JAMES ZWEEP","GREG HILL","BRIAN HELM","KEVIN SCHIAVO","TOM SETTERSTROM","TEX SHOCKEY","GENE MEAD","GARY LUNDVALL","RICHARD B LUNDVALL"],"Title":["VICE PRESIDENT","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","PRESIDENT","DIRECTOR","DIRECTOR","TREASURER","CHIEF FINANCIAL OFFICER","EXECUTIVE VICE PRESIDENT"],"Hours":[1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,10.0,10.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,0,13801,56686],"Direct compensation":[0,0,0,0,0,0,0,0,0,0,12000,49292],"Other compensation":[0,0,0,0,0,0,0,0,0,0,1801,7394]},"Basic":{"value":null,"mission":"To provide education resources for contributing members.","year":2013,"name":"PIPING INDUSTRY COUNCIL OF THE ROCKFORD AREA TRUSTEES","phone":5633456450,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"RICK LUNDVALL","year_formation":1964,"state_legal_domicile":"IL","total_volunteers":0,"tax_period_begin":"2013-01-01T00:00:00","tax_period_end":"2013-12-31T00:00:00","address":"1983 SPRUCE HILLS DRIVE, BETTENDORF, IA, 52722, USA","city":"BETTENDORF","state":"IA","country":"USA","zip_code":52722},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":10,"Number of independent voting members":10,"Number of employees total":2,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":2,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":false,"Premiums Paid":false,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":192877,"Contributions":{"value":172583,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":172583,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":20294,"Investment income total":3804,"Net investment gain":16490,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":191415,"Grant expense":{"value":20000,"Grants to domestic orgs":20000,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":76286,"Current officers":61292,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":9194,"Other employee benefits":0,"Payroll taxes":5800},"Other expenses":{"value":95129,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":2875,"Advertising":700,"Office expenses":1294,"Information technology":0,"Royalties":0,"Occupancy":1800,"Travel":4319,"Conferences and meetings":10218,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":4322,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":63219,"SEMINARS":29342,"SEMINAR RETREAT":17447,"EDUCATION REIMBURSEMENT":11255,"DUES":5175},"All other expenses":6382},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":319603,"Non-interest bearing cash":20682,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":0,"Investments other":285901,"Investments program related":0,"Intangible assets":0,"Other assets":13020},"Liabilities":{"value":3011,"Sum of Total Liabilities":0,"Accounts payable, accrued":3011,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":316592,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.007579960285570597,"percentile":0.41812741367429984},"Liabilities to Assets Ratio":{"score":0.00942106300629218,"percentile":0.5013224456887779},"Operating Reserve Ratio":{"score":1.6696862837290702,"percentile":0.5679292454174286},"Officer Compensation Ratio":{"score":0.3682417783350312,"percentile":0.13378740512427797},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":null,"percentile":null},"Asset Growth":{"score":null,"percentile":null},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5267703869229609,"percentile":0.39162460155552087}},"source_xml":"201401359349306560_public.xml"},{"Organization":{"value":null,"Person":["STEVE CERONI","GARY STATDFIELD","KEVIN SCHIAVO","TOM SETTERSTROM","TEX SHOCKEY","GENE MEAD","WILLIAM SPRAGUE","JAMES ZWEEP","GREG HILL","BRIAN HELM","RICHARD LUNDVALL"],"Title":["DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","2ND VICE PRESIDENT","PRESIDENT","1ST VICE PRESIDENT","SECRETARY/TREASURER","EXECUTIVE DIRECTOR"],"Hours":[1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,7.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,0,81254],"Direct compensation":[0,0,0,0,0,0,0,0,0,0,73023],"Other compensation":[0,0,0,0,0,0,0,0,0,0,8231]},"Basic":{"value":null,"mission":"To provide educational resources on the piping industry.","year":2020,"name":"PIPING INDUSTRY COUNCIL OF THE ROCKFORD AREA TRUSTEES","phone":5633456450,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"RICHARD LUNDVALL","year_formation":1964,"state_legal_domicile":"IL","total_volunteers":0,"tax_period_begin":"2020-01-01T00:00:00","tax_period_end":"2020-12-31T00:00:00","address":"1983 SPRUCE HILLS DR, BETTENDORF, IA, 52722, USA","city":"BETTENDORF","state":"IA","country":"USA","zip_code":52722},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":10,"Number of independent voting members":10,"Number of employees total":1,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":1,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":false,"Premiums Paid":false,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":251047,"Contributions":{"value":0,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":236833,"Total revenue":236833,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":14214,"Investment income total":12515,"Net investment gain":1699,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":234547,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":86882,"Current officers":73023,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":8231,"Other employee benefits":0,"Payroll taxes":5628},"Other expenses":{"value":147665,"Management services":0,"Legal":0,"Accounting":3450,"Lobbying services":0,"Investment management fees":0,"Other services":3193,"Advertising":1328,"Office expenses":0,"Information technology":0,"Royalties":0,"Occupancy":2300,"Travel":2390,"Conferences and meetings":18563,"Interest":0,"Payments to affiliates":60000,"Depreciation and depletion":0,"Insurance":7326,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":46973,"EDUCATION REIMBURSEMENT":28006,"MCAA SEMINARS":8827,"VALENTINE BANQUET":7340,"OFFICE COMMUNICATION":2800},"All other expenses":2142},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":574121,"Non-interest bearing cash":39824,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":511464,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":22833},"Liabilities":{"value":42,"Sum of Total Liabilities":0,"Accounts payable, accrued":42,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":574079,"Net assets without donor restriction":574079,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.06572474476890781,"percentile":0.5586403757001426},"Liabilities to Assets Ratio":{"score":7.315531046591224e-05,"percentile":0.5865073258902747},"Operating Reserve Ratio":{"score":2.4477865843519635,"percentile":0.6663897342479446},"Officer Compensation Ratio":{"score":0.34642950027073466,"percentile":0.14869353426319395},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.0558688771716376,"percentile":0.6302250569802603},"Asset Growth":{"score":0.08915494264394981,"percentile":0.6548273857969562},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.583875065373844,"percentile":0.5579774589266462}},"source_xml":"202121949349301077_public.xml"},{"Organization":{"value":null,"Person":["STEVE CERONI","WILLIAM SPRAGUE","GARY STATDFIELD","JAMES ZWEEP","GREG HILL","BRIAN HELM","KEVIN SCHIAVO","TOM SETTERSTROM","TEX SHOCKEY","GENE MEAD","RICHARD B LUNDVALL"],"Title":["DIRECTOR","SECRETARY/TREASURER","DIRECTOR","1ST VICE PRESIDENT","2ND VICE PRESIDENT","DIRECTOR","DIRECTOR","DIRECTOR","PRESIDENT","DIRECTOR","EXECUTIVE VICE PRESIDENT"],"Hours":[1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,7.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,0,70696],"Direct compensation":[0,0,0,0,0,0,0,0,0,0,62465],"Other compensation":[0,0,0,0,0,0,0,0,0,0,8231]},"Basic":{"value":null,"mission":"To provide education resources for contributing members.","year":2018,"name":"PIPING INDUSTRY COUNCIL OF THE ROCKFORD AREA TRUSTEES","phone":5633456450,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"RICK LUNDVALL","year_formation":1964,"state_legal_domicile":"IL","total_volunteers":0,"tax_period_begin":"2018-01-01T00:00:00","tax_period_end":"2018-12-31T00:00:00","address":"1983 SPRUCE HILLS DRIVE, BETTENDORF, IA, 52722, USA","city":"BETTENDORF","state":"IA","country":"USA","zip_code":52722},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":10,"Number of independent voting members":10,"Number of employees total":1,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":1,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":false,"Premiums Paid":false,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":305756,"Contributions":{"value":0,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":293639,"Total revenue":293639,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":12117,"Investment income total":12333,"Net investment gain":-216,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":280467,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":75475,"Current officers":62465,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":8231,"Other employee benefits":0,"Payroll taxes":4779},"Other expenses":{"value":204992,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":8677,"Advertising":350,"Office expenses":6354,"Information technology":0,"Royalties":0,"Occupancy":1800,"Travel":2814,"Conferences and meetings":19133,"Interest":0,"Payments to affiliates":54000,"Depreciation and depletion":0,"Insurance":7332,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":101365,"SEMINARS":46061,"SEMINAR RETREAT":25278,"EDUCATION REIMBURSEMENT":19462,"VALENTINE/INSTALLATION":10564},"All other expenses":3167},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":482540,"Non-interest bearing cash":49078,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":410300,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":23162},"Liabilities":{"value":242,"Sum of Total Liabilities":0,"Accounts payable, accrued":242,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":482298,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":482298,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.08270974240897971,"percentile":0.5920884573863503},"Liabilities to Assets Ratio":{"score":0.0005015128279520868,"percentile":0.5770795745231739},"Operating Reserve Ratio":{"score":1.7204876152987696,"percentile":0.5760337120591303},"Officer Compensation Ratio":{"score":0.25206530536569366,"percentile":0.23849562427626814},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.11287491262001684,"percentile":0.7908728555586445},"Asset Growth":{"score":0.09713494422235522,"percentile":0.6758900838195965},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.606903923952834,"percentile":0.6255208851002013}},"source_xml":"201931359349304783_public.xml"},{"Organization":{"value":null,"Person":["JOSH CERONI","WILLIAM SPRAGUE","JESSE ARNDT","JAMES ZWEEP","GREG HILL","BRIAN HELM","KEVIN SCHIAVO","TODD DORN","SPENCER MEINERT","JAY DOYLE","RICHARD LUNDVALL"],"Title":["1ST VICE PRESIDENT","PRESIDENT","2ND VICE PRESIDENT","DIRECTOR","SECRETARY/TREASURER","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","EXECUTIVE DIRECTOR"],"Hours":[1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,7.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,0,8231],"Direct compensation":[0,0,0,0,0,0,0,0,0,0,0],"Other compensation":[0,0,0,0,0,0,0,0,0,0,8231]},"Basic":{"value":null,"mission":"To provide educational resources on the piping industry.","year":2024,"name":"PIPING INDUSTRY COUNCIL OF THE ROCKFORD AREA TRUSTEES","phone":5633456450,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"RICHARD LUNDVALL","year_formation":1964,"state_legal_domicile":"IL","total_volunteers":0,"tax_period_begin":"2024-01-01T00:00:00","tax_period_end":"2024-12-31T00:00:00","address":"1983 SPRUCE HILLS DR, BETTENDORF, IA, 52722, USA","city":"BETTENDORF","state":"IA","country":"USA","zip_code":52722},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":10,"Number of independent voting members":10,"Number of employees total":0,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":false,"Premiums Paid":false,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":399869,"Contributions":{"value":0,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":378445,"Total revenue":378445,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":21424,"Investment income total":22191,"Net investment gain":-767,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":359476,"Grant expense":{"value":1250,"Grants to domestic orgs":1250,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":0,"Current officers":0,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":0},"Other expenses":{"value":358226,"Management services":0,"Legal":0,"Accounting":2194,"Lobbying services":0,"Investment management fees":6518,"Other services":182068,"Advertising":405,"Office expenses":0,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":20132,"Interest":0,"Payments to affiliates":120000,"Depreciation and depletion":0,"Insurance":1198,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":25409,"VALENTINE BANQUET":14700,"STIPENDS":6000,"ADMIN FEE/BENEFIT FUNDS":2359,"DONATIONS/FLOWERS":2350},"All other expenses":302},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":863292,"Non-interest bearing cash":171033,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":655570,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":36689},"Liabilities":{"value":0,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":863292,"Net assets without donor restriction":863292,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.10101558260330258,"percentile":0.624979950797678},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":2.4015288920539897,"percentile":0.6618828965904978},"Officer Compensation Ratio":{"score":0.022897217060387897,"percentile":0.8972150578228485},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.05464867861669832,"percentile":0.6253511134702987},"Asset Growth":{"score":0.09199468411261821,"percentile":0.6624778830035771},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6685108246456785,"percentile":0.7857200138469393}},"source_xml":"202501359349304670_public.xml"},{"Organization":{"value":null,"Person":["STEVE CERONI","WILLIAM SPRAGUE","GARY STATDFIELD","JAMES ZWEEP","GREG HILL","BRIAN HELM","KEVIN SCHIAVO","TOM SETTERSTROM","TEX SHOCKEY","GENE MEAD","RICHARD LUNDVALL"],"Title":["DIRECTOR","SECRETARY/TREASURER","DIRECTOR","1ST VICE PRESIDENT","2ND VICE PRESIDENT","DIRECTOR","DIRECTOR","DIRECTOR","PRESIDENT","DIRECTOR","EXECUTIVE DIRECTOR"],"Hours":[1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,7.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,0,71866],"Direct compensation":[0,0,0,0,0,0,0,0,0,0,63635],"Other compensation":[0,0,0,0,0,0,0,0,0,0,8231]},"Basic":{"value":null,"mission":"To provide education resources.","year":2019,"name":"PIPING INDUSTRY COUNCIL OF THE ROCKFORD AREA TRUSTEES","phone":5633456450,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"RICHARD LUNDVALL","year_formation":1964,"state_legal_domicile":"IL","total_volunteers":0,"tax_period_begin":"2019-01-01T00:00:00","tax_period_end":"2019-12-31T00:00:00","address":"1983 SPRUCE HILLS DR, BETTENDORF, IA, 52722, USA","city":"BETTENDORF","state":"IA","country":"USA","zip_code":52722},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":10,"Number of independent voting members":10,"Number of employees total":1,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":1,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":false,"Premiums Paid":false,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":290627,"Contributions":{"value":0,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":279727,"Total revenue":279727,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":10900,"Investment income total":10900,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":291265,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":76976,"Current officers":63635,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":8231,"Other employee benefits":0,"Payroll taxes":5110},"Other expenses":{"value":214289,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":3280,"Advertising":1250,"Office expenses":55,"Information technology":0,"Royalties":0,"Occupancy":2300,"Travel":3815,"Conferences and meetings":18520,"Interest":0,"Payments to affiliates":60000,"Depreciation and depletion":0,"Insurance":7325,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":108499,"MCAA SEMINARS":58522,"SEMINAR RETREAT":22746,"EDUCATION REIMBURSEMENT":17640,"VALENTINE BANQUET":9591},"All other expenses":9245},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":534088,"Non-interest bearing cash":37539,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":476704,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":19845},"Liabilities":{"value":42,"Sum of Total Liabilities":0,"Accounts payable, accrued":42,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":534046,"Net assets without donor restriction":534046,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-0.0021952537100819952,"percentile":0.3798964635754652},"Liabilities to Assets Ratio":{"score":7.863872620242357e-05,"percentile":0.5863379233833634},"Operating Reserve Ratio":{"score":1.8336841021063293,"percentile":0.5931225507799814},"Officer Compensation Ratio":{"score":0.24673750708118036,"percentile":0.24518167348539496},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.08594685311092845,"percentile":0.7292151884275128},"Asset Growth":{"score":0.09294961492969123,"percentile":0.6650190771798016},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5623372977845781,"percentile":0.49393636447448125}},"source_xml":"202001499349300820_public.xml"}],"Latest":{"Organization":{"value":null,"Person":["JOSH CERONI","WILLIAM SPRAGUE","JESSE ARNDT","JAMES ZWEEP","GREG HILL","BRIAN HELM","KEVIN SCHIAVO","TODD DORN","SPENCER MEINERT","JAY DOYLE","RICHARD LUNDVALL"],"Title":["1ST VICE PRESIDENT","PRESIDENT","2ND VICE PRESIDENT","DIRECTOR","SECRETARY/TREASURER","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","EXECUTIVE DIRECTOR"],"Hours":[1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,7.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,0,8231],"Direct compensation":[0,0,0,0,0,0,0,0,0,0,0],"Other compensation":[0,0,0,0,0,0,0,0,0,0,8231]},"Basic":{"value":null,"mission":"To provide educational resources on the piping industry.","year":2024,"name":"PIPING INDUSTRY COUNCIL OF THE ROCKFORD AREA TRUSTEES","phone":5633456450,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"RICHARD LUNDVALL","year_formation":1964,"state_legal_domicile":"IL","total_volunteers":0,"tax_period_begin":"2024-01-01T00:00:00","tax_period_end":"2024-12-31T00:00:00","address":"1983 SPRUCE HILLS DR, BETTENDORF, IA, 52722, USA","city":"BETTENDORF","state":"IA","country":"USA","zip_code":52722},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":10,"Number of independent voting members":10,"Number of employees total":0,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":false,"Premiums Paid":false,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":399869,"Contributions":{"value":0,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":378445,"Total revenue":378445,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":21424,"Investment income total":22191,"Net investment gain":-767,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":359476,"Grant expense":{"value":1250,"Grants to domestic orgs":1250,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":0,"Current officers":0,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":0},"Other expenses":{"value":358226,"Management services":0,"Legal":0,"Accounting":2194,"Lobbying services":0,"Investment management fees":6518,"Other services":182068,"Advertising":405,"Office expenses":0,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":20132,"Interest":0,"Payments to affiliates":120000,"Depreciation and depletion":0,"Insurance":1198,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":25409,"VALENTINE BANQUET":14700,"STIPENDS":6000,"ADMIN FEE/BENEFIT FUNDS":2359,"DONATIONS/FLOWERS":2350},"All other expenses":302},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":863292,"Non-interest bearing cash":171033,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":655570,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":36689},"Liabilities":{"value":0,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":863292,"Net assets without donor restriction":863292,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.10101558260330258,"percentile":0.624979950797678},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":2.4015288920539897,"percentile":0.6618828965904978},"Officer Compensation Ratio":{"score":0.022897217060387897,"percentile":0.8972150578228485},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.05464867861669832,"percentile":0.6253511134702987},"Asset Growth":{"score":0.09199468411261821,"percentile":0.6624778830035771},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6685108246456785,"percentile":0.7857200138469393}},"source_xml":"202501359349304670_public.xml"},"sector":"","donation_categories":[],"zakat_policy":null},"error":null}