{"success":true,"data":{"_id":630984295,"filings":[{"Organization":{"value":null,"Person":["ROBERT W KERR","BARRY HOWTON","HOWARD KERR","ROBERT D KERR","RICHARD KERR"],"Title":["EXECUTIVE VICE PRESIDENT","SECRETARY/TREASURER","PRESIDENT","VICE PRESIDENT","VICE PRESIDENT"],"Hours":[0.5,1.0,0.5,0.5,0.5],"Total Compensation":[0,0,0,0,0],"Direct compensation":[0,0,0,0,0],"Other compensation":[0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide health care benefits including hospital, surgical, major medical, and dental benefits for employees of consolidated pipe & supply co. inc.","year":2017,"name":"CONSOLIDATED PIPE AND SUPPLY INC EMPLOYEE HEALTHCARE PLAN & TRUST","phone":2053237261,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"HOWARD KERR","year_formation":1989,"state_legal_domicile":"AL","total_volunteers":0,"tax_period_begin":"2017-01-01T00:00:00","tax_period_end":"2017-12-31T00:00:00","address":"P O BOX 2472, BIRMINGHAM, AL, 352012472, USA","city":"BIRMINGHAM","state":"AL","country":"USA","zip_code":352012472},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":5,"Number of independent voting members":5,"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":6008911,"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":6008458,"Total revenue":{"value":6008458,"SPONSOR CONTRIBUTIONS":3326646,"PARTICIPANTS CONTRIBUT":2681812},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":453,"Investment income total":453,"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":5861570,"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":5292469,"Benefits paid to members Total":5292469},"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":569101,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":569101,"Advertising":0,"Office expenses":0,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":0,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":0,"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":473614,"Non-interest bearing cash":473614,"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":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":407000,"Sum of Total Liabilities":0,"Accounts payable, accrued":407000,"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":66614,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":66614,"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.024520416428201384,"percentile":0.46401180920944696},"Liabilities to Assets Ratio":{"score":0.8593495969291448,"percentile":0.07090140159578391},"Operating Reserve Ratio":{"score":0.08079985396404035,"percentile":0.05913979037879788},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.06360792007567444,"percentile":0.6593124965179119},"Asset Growth":{"score":-0.03695291237965184,"percentile":0.19361410015119881},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.49145950411313816,"percentile":0.30103534069290294}},"source_xml":"201813189349301476_public.xml"},{"Organization":{"value":null,"Person":["ROBERT W KERR","BARRY HOWTON","HOWARD KERR","CHARLES ZEITVOGEL"],"Title":["EXECUTIVE VP","SECRETARY/TREASURER","PRESIDENT","COO"],"Hours":[0.5,1.0,0.5,0.5],"Total Compensation":[0,0,0,0],"Direct compensation":[0,0,0,0],"Other compensation":[0,0,0,0]},"Basic":{"value":null,"mission":"To provide health care benefits including hospital, surgical, major medical, and dental benefits for employees of consolidated pipe & supply co. inc.","year":2014,"name":"CONSOLIDATED PIPE AND SUPPLY INC EMPLOYEE HEALTHCARE PLAN & TRUST","phone":2053237261,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"HOWARD KERR","year_formation":1989,"state_legal_domicile":"AL","total_volunteers":0,"tax_period_begin":"2014-01-01T00:00:00","tax_period_end":"2014-12-31T00:00:00","address":"P O BOX 2472, BIRMINGHAM, AL, 352012472, USA","city":"BIRMINGHAM","state":"AL","country":"USA","zip_code":352012472},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":4,"Number of independent voting members":4,"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":5708588,"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":5708586,"Total revenue":{"value":5708586,"SPONSOR CONTRIBUTIONS":3568389,"PARTICIPANTS CONTRIBUT":2140197},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":2,"Investment income total":2,"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":5467088,"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":4942777,"Benefits paid to members Total":4942777},"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":524311,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":524311,"Advertising":0,"Office expenses":0,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":0,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":0,"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":606756,"Non-interest bearing cash":606756,"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":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":509223,"Sum of Total Liabilities":0,"Accounts payable, accrued":509223,"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":97533,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":97533,"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.04230468199842063,"percentile":0.5074986564232141},"Liabilities to Assets Ratio":{"score":0.8392549888258213,"percentile":0.07366366617341245},"Operating Reserve Ratio":{"score":0.11098339737717776,"percentile":0.07321827737796263},"Officer Compensation Ratio":{"score":null,"percentile":null},"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.5056999806722023,"percentile":0.33569108606280756}},"source_xml":"201543099349300414_public.xml"},{"Organization":{"value":null,"Person":["robert w kerr","barry howton","HOWARD KERR","CHARLES ZEITVOGEL"],"Title":["executive vp","secretary/TREASURER","PRESIDENT","COO"],"Hours":[0.5,1.0,0.5,0.5],"Total Compensation":[0,0,0,0],"Direct compensation":[0,0,0,0],"Other compensation":[0,0,0,0]},"Basic":{"value":null,"mission":"To provide health care benefits including hospital, surgical, major medical, and dental benefits for employees of consolidated pipe & supply co. inc.","year":2015,"name":"CONSOLIDATED PIPE AND SUPPLY inc employee healthCARE plan & trust","phone":2053237261,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"HOWARD KERR","year_formation":1989,"state_legal_domicile":"AL","total_volunteers":0,"tax_period_begin":"2015-01-01T00:00:00","tax_period_end":"2015-12-31T00:00:00","address":"P O BOX 2472, BIRMINGHAM, AL, 352012472, USA","city":"BIRMINGHAM","state":"AL","country":"USA","zip_code":352012472},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":4,"Number of independent voting members":4,"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":5217803,"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":5217801,"Total revenue":{"value":5217801,"SPONSOR CONTRIBUTIONS":2889287,"PARTICIPANTS CONTRIBUT":2328514},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":2,"Investment income total":2,"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":5313601,"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":4797866,"Benefits paid to members Total":4797866},"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":515735,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":515735,"Advertising":0,"Office expenses":0,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":0,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":0,"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":415235,"Non-interest bearing cash":415235,"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":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":413500,"Sum of Total Liabilities":0,"Accounts payable, accrued":413500,"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":1735,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":1735,"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.018359834589385608,"percentile":0.3418874558535417},"Liabilities to Assets Ratio":{"score":0.9958216431659181,"percentile":0.05251539166187342},"Operating Reserve Ratio":{"score":0.07814568688917366,"percentile":0.05792380714105709},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.1020893995630826,"percentile":0.7686012098488991},"Asset Growth":{"score":-0.021338960346839127,"percentile":0.24141064312903318},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.48057173285100796,"percentile":0.27589886614685316}},"source_xml":"201622249349302392_public.xml"},{"Organization":{"value":null,"Person":["ROBERT W KERR","BARRY HOWTON","HOWARD KERR","ROBERT D KERR","RICHARD KERR"],"Title":["EXECUTIVE VICE PRESIDENT","SECRETARY/TREASURER","PRESIDENT","VICE PRESIDENT","VICE PRESIDENT"],"Hours":[0.5,1.0,0.5,0.5,0.5],"Total Compensation":[0,0,0,0,0],"Direct compensation":[0,0,0,0,0],"Other compensation":[0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide health care benefits including hospital, surgical, major medical, and dental benefits for employees of consolidated pipe & supply co. inc.","year":2018,"name":"CONSOLIDATED PIPE AND SUPPLY INC EMPLOYEE HEALTHCARE PLAN & TRUST","phone":2053237261,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"HOWARD KERR","year_formation":1989,"state_legal_domicile":"AL","total_volunteers":0,"tax_period_begin":"2018-01-01T00:00:00","tax_period_end":"2018-12-31T00:00:00","address":"P O BOX 2472, BIRMINGHAM, AL, 352012472, USA","city":"BIRMINGHAM","state":"AL","country":"USA","zip_code":352012472},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":5,"Number of independent voting members":5,"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":7016170,"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":7014479,"Total revenue":{"value":7014479,"SPONSOR CONTRIBUTIONS":4379065,"PARTICIPANTS CONTRIBUT":2635414},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":1691,"Investment income total":1691,"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":7082784,"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":6449905,"Benefits paid to members Total":6449905},"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":632879,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":632879,"Advertising":0,"Office expenses":0,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":0,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":0,"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":0,"Non-interest bearing cash":0,"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":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"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":0,"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.009494353757106798,"percentile":0.361536998854011},"Liabilities to Assets Ratio":{"score":null,"percentile":null},"Operating Reserve Ratio":{"score":0.0,"percentile":0.01998217959084195},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.07792235351424608,"percentile":0.7064054463638041},"Asset Growth":{"score":-0.19676771134604698,"percentile":0.05488519628229797},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.49221635243796796,"percentile":0.30283640273155077}},"source_xml":"201922909349301067_public.xml"},{"Organization":{"value":null,"Person":["ROBERT W KERR","BARRY HOWTON","HOWARD KERR","CHARLES ZEITVOGEL","REGIONS BANK"],"Title":["EXECUTIVE VP","SECRETARY/TREASURER","PRESIDENT","COO","TRUSTEE"],"Hours":[0.5,1.0,0.5,0.5,0.0],"Total Compensation":[0,0,0,0,0],"Direct compensation":[0,0,0,0,0],"Other compensation":[0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide health care benefits including hospital, surgical, major medical, and dental benefits for employees of consolidated pipe & supply co. inc.","year":2013,"name":"CONSOLIDATED PIPE AND SUPPLY INC EMPLOYEE HEALTHCARE PLAN & TRUST","phone":2053237261,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"HOWARD KERR","year_formation":1989,"state_legal_domicile":"AL","total_volunteers":0,"tax_period_begin":"2013-01-01T00:00:00","tax_period_end":"2013-12-31T00:00:00","address":"P O BOX 2472, BIRMINGHAM, AL, 352012472, USA","city":"BIRMINGHAM","state":"AL","country":"USA","zip_code":352012472},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":4,"Number of independent voting members":4,"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":4189052,"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":4189020,"Total revenue":{"value":4189020,"SPONSOR CONTRIBUTIONS":2301436,"PARTICIPANT CONTRIBUTI":1887584},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":32,"Investment income total":32,"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":4357581,"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":3954965,"Benefits paid to members Total":3954965},"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":402616,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":402616,"Advertising":0,"Office expenses":0,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":0,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":0,"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":435976,"Non-interest bearing cash":435976,"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":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":579943,"Sum of Total Liabilities":0,"Accounts payable, accrued":579943,"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":-143967,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":-143967,"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.04023082072029662,"percentile":0.30097770814027164},"Liabilities to Assets Ratio":{"score":1.3302177184065178,"percentile":0.03214960515081944},"Operating Reserve Ratio":{"score":0.10005000480771327,"percentile":0.06811587671542657},"Officer Compensation Ratio":{"score":null,"percentile":null},"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.4519758430484962,"percentile":0.215187916605588}},"source_xml":"201432279349302313_public.xml"},{"Organization":{"value":null,"Person":["robert w kerr","barry howton","HOWARD KERR","ROBERT D KERR","RICHARD KERR"],"Title":["executive vice president","secretary/TREASURER","PRESIDENT","vice president","vice president"],"Hours":[0.5,1.0,0.5,0.5,0.5],"Total Compensation":[0,0,0,0,0],"Direct compensation":[0,0,0,0,0],"Other compensation":[0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide health care benefits including hospital, surgical, major medical, and dental benefits for employees of consolidated pipe & supply co. inc.","year":2016,"name":"CONSOLIDATED PIPE AND SUPPLY inc employee healthCARE plan & trust","phone":2053237261,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"HOWARD KERR","year_formation":1989,"state_legal_domicile":"AL","total_volunteers":0,"tax_period_begin":"2016-01-01T00:00:00","tax_period_end":"2016-12-31T00:00:00","address":"P O BOX 2472, BIRMINGHAM, AL, 352012472, USA","city":"BIRMINGHAM","state":"AL","country":"USA","zip_code":352012472},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":5,"Number of independent voting members":5,"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":5449483,"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":5449007,"Total revenue":{"value":5449007,"SPONSOR CONTRIBUTIONS":2919646,"PARTICIPANTS CONTRIBUT":2529361},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":476,"Investment income total":476,"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":5531945,"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":5056650,"Benefits paid to members Total":5056650},"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":475295,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":475295,"Advertising":0,"Office expenses":0,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":0,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":0,"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":361973,"Non-interest bearing cash":361973,"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":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":442700,"Sum of Total Liabilities":0,"Accounts payable, accrued":442700,"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":-80727,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":-80727,"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.015132077666817201,"percentile":0.3487658353032672},"Liabilities to Assets Ratio":{"score":1.2230193964743226,"percentile":0.03625951071148233},"Operating Reserve Ratio":{"score":0.06543322466148886,"percentile":0.05206780809169447},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.06400233095903189,"percentile":0.6607574056140639},"Asset Growth":{"score":-0.09088871061683353,"percentile":0.1121904706900559},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.46035526612665517,"percentile":0.23213061879460034}},"source_xml":"201702979349300220_public.xml"}],"Latest":{"Organization":{"value":null,"Person":["ROBERT W KERR","BARRY HOWTON","HOWARD KERR","ROBERT D KERR","RICHARD KERR"],"Title":["EXECUTIVE VICE PRESIDENT","SECRETARY/TREASURER","PRESIDENT","VICE PRESIDENT","VICE PRESIDENT"],"Hours":[0.5,1.0,0.5,0.5,0.5],"Total Compensation":[0,0,0,0,0],"Direct compensation":[0,0,0,0,0],"Other compensation":[0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide health care benefits including hospital, surgical, major medical, and dental benefits for employees of consolidated pipe & supply co. inc.","year":2018,"name":"CONSOLIDATED PIPE AND SUPPLY INC EMPLOYEE HEALTHCARE PLAN & TRUST","phone":2053237261,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"HOWARD KERR","year_formation":1989,"state_legal_domicile":"AL","total_volunteers":0,"tax_period_begin":"2018-01-01T00:00:00","tax_period_end":"2018-12-31T00:00:00","address":"P O BOX 2472, BIRMINGHAM, AL, 352012472, USA","city":"BIRMINGHAM","state":"AL","country":"USA","zip_code":352012472},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":5,"Number of independent voting members":5,"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":7016170,"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":7014479,"Total revenue":{"value":7014479,"SPONSOR CONTRIBUTIONS":4379065,"PARTICIPANTS CONTRIBUT":2635414},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":1691,"Investment income total":1691,"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":7082784,"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":6449905,"Benefits paid to members Total":6449905},"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":632879,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":632879,"Advertising":0,"Office expenses":0,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":0,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":0,"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":0,"Non-interest bearing cash":0,"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":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"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":0,"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.009494353757106798,"percentile":0.361536998854011},"Liabilities to Assets Ratio":{"score":null,"percentile":null},"Operating Reserve Ratio":{"score":0.0,"percentile":0.01998217959084195},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.07792235351424608,"percentile":0.7064054463638041},"Asset Growth":{"score":-0.19676771134604698,"percentile":0.05488519628229797},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.49221635243796796,"percentile":0.30283640273155077}},"source_xml":"201922909349301067_public.xml"},"sector":"Health","donation_categories":[],"zakat_policy":null},"error":null}