{"success":true,"data":{"_id":311253999,"filings":[{"Organization":{"value":null,"Person":["JOHN P MCCONNELL","AMY MCCONNELL","MICHAEL J ENDRES","STEVEN J ALLEN","JOHN F WOLFE","DOUGLAS F KRIDLER","RAYMOND J BIDDISCOMBE"],"Title":["CHAIR/TREASURER/TRUSTEE","VICE CHAIR/SECRETARY/TRUST","TRUSTEE","TRUSTEE","TRUSTEE (THRU 6.24.16)","PRESIDENT","ASST TREASURER"],"Hours":[1.0,1.0,1.0,1.0,1.0,0.5,0.5],"Total Compensation":[0,0,0,0,0,103216,23755],"Direct compensation":[0,0,0,0,0,0,0],"Other compensation":[0,0,0,0,0,103216,23755]},"Basic":{"value":null,"mission":"The purpose of the foundation is to support charitable organizations which benefit the community.","year":2016,"name":"THE JOHN H MCCONNELL FOUNDATION","phone":6142514000,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"DOUGLAS F KRIDLER","year_formation":1989,"state_legal_domicile":"OH","total_volunteers":0,"tax_period_begin":"2016-01-01T00:00:00","tax_period_end":"2016-12-31T00:00:00","address":"1234 EAST BROAD STREET, COLUMBUS, OH, 432051405, USA","city":"COLUMBUS","state":"OH","country":"USA","zip_code":432051405},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":4,"Number of independent voting members":4,"Number of employees total":0,"Total Gross UBI":-34,"Net unrelated business taxable income":-34,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"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":72247,"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":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":71006,"Investment income total":66162,"Net investment gain":4844,"Income from invest bond proceeds":0},"Other revenues":{"value":1241,"Other total":-34,"Royalties revenue":0,"Net rental income":1275,"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":31134,"Grant expense":{"value":10000,"Grants to domestic orgs":10000,"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":21134,"Management services":10000,"Legal":0,"Accounting":3650,"Lobbying services":0,"Investment management fees":7284,"Other services":0,"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":200,"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":10000,"Management And General Expenses":21134,"Fundraising Expenses":0}},"Assets":{"value":2511376,"Non-interest bearing cash":0,"Savings and temp cash investments":79248,"Pledges and grants receivable":0,"Accounts receivable":1136,"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":1813343,"Investments other":617649,"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":2511376,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":2511376,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.3211922656902422,"percentile":0.45834427589762594},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.5690616911428849,"percentile":0.9355276756437501},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":80.66345474400977,"percentile":0.987339789610851},"Officer Compensation Ratio":{"score":4.078210316695574,"percentile":0.005159344327627156},"Program Expense Growth":{"score":-0.2545454545454545,"percentile":0.07252821548567653},"Revenue Growth":{"score":-0.2617064458381052,"percentile":0.05561010243708374},"Asset Growth":{"score":0.019920595595328734,"percentile":0.4035087768484426},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5620452070449938,"percentile":0.493070030835638}},"source_xml":"201741329349301339_public.xml"},{"Organization":{"value":null,"Person":["JOHN P MCCONNELL","AMY MCCONNELL","JOHN F WOLFE","MICHAEL J ENDRES","STEVEN J ALLEN FROM 1114","DOUGLAS F KRIDLER","RAYMOND J BIDDISCOMBE"],"Title":["CHAIR/TREASURER/TRUSTEE","VICE CHAIR/SECRETARY/TRUST","TRUSTEE","TRUSTEE","TRUSTEE","PRESIDENT","ASST TREASURER"],"Hours":[1.0,1.0,1.0,1.0,1.0,0.5,0.5],"Total Compensation":[0,0,0,0,0,87349,26680],"Direct compensation":[0,0,0,0,0,0,0],"Other compensation":[0,0,0,0,0,87349,26680]},"Basic":{"value":null,"mission":"The purpose of the foundation is to support charitable organizations which benefit the community.","year":2014,"name":"THE JOHN H MCCONNELL FOUNDATION","phone":6142514000,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"RAYMOND J BIDDISCOMBE","year_formation":1989,"state_legal_domicile":"OH","total_volunteers":0,"tax_period_begin":"2014-01-01T00:00:00","tax_period_end":"2014-12-31T00:00:00","address":"1234 EAST BROAD STREET, COLUMBUS, OH, 432051405, USA","city":"COLUMBUS","state":"OH","country":"USA","zip_code":432051405},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":5,"Number of independent voting members":5,"Number of employees total":0,"Total Gross UBI":-2423,"Net unrelated business taxable income":-2423,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"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":255657,"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":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":257342,"Investment income total":71785,"Net investment gain":185557,"Income from invest bond proceeds":0},"Other revenues":{"value":-1685,"Other total":-2582,"Royalties revenue":0,"Net rental income":897,"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":22692,"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":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":22692,"Management services":10000,"Legal":0,"Accounting":3650,"Lobbying services":0,"Investment management fees":8817,"Other services":0,"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":{"value":225,"FILING FEES":200,"OTHER EXPENSE":25},"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":22692,"Fundraising Expenses":0}},"Assets":{"value":2381496,"Non-interest bearing cash":0,"Savings and temp cash investments":71483,"Pledges and grants receivable":0,"Accounts receivable":13231,"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":1782797,"Investments other":513985,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":37725,"Sum of Total Liabilities":0,"Accounts payable, accrued":37725,"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":2343771,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":2343771,"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.9112404510731175,"percentile":0.9848679728182749},"Liabilities to Assets Ratio":{"score":0.015840883209545596,"percentile":0.4724871483515313},"Operating Reserve Ratio":{"score":104.94870438921205,"percentile":0.9898010593220767},"Officer Compensation Ratio":{"score":5.025074916270051,"percentile":0.004563021019786115},"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.6733400742285455,"percentile":0.7965173867681735}},"source_xml":"201511339349302691_public.xml"},{"Organization":{"value":null,"Person":["JOHN P MCCONNELL","AMY MCCONNELL","MICHAEL J ENDRES","STEVEN J ALLEN","DOUGLAS F KRIDLER","RAYMOND J BIDDISCOMBE","SCOTT HEITKAMP"],"Title":["CHAIR/TREASURER/TRUSTEE","VICE CHAIR/SECRETARY/TRUST","TRUSTEE","TRUSTEE","PRESIDENT","ASST TREASURER (THRU 12.28.17)","ASST TREASURER (FROM 12.29.17)"],"Hours":[1.0,1.0,1.0,1.0,0.5,0.5,0.5],"Total Compensation":[0,0,0,0,98699,0,35458],"Direct compensation":[0,0,0,0,0,0,0],"Other compensation":[0,0,0,0,98699,0,35458]},"Basic":{"value":null,"mission":"The purpose of the foundation is to support charitable organizations which benefit the community.","year":2017,"name":"THE JOHN H MCCONNELL FOUNDATION","phone":6142514000,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"SCOTT HEITKAMP","year_formation":1989,"state_legal_domicile":"OH","total_volunteers":0,"tax_period_begin":"2017-01-01T00:00:00","tax_period_end":"2017-12-31T00:00:00","address":"1234 EAST BROAD STREET, COLUMBUS, OH, 432051405, USA","city":"COLUMBUS","state":"OH","country":"USA","zip_code":432051405},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":4,"Number of independent voting members":4,"Number of employees total":0,"Total Gross UBI":-27,"Net unrelated business taxable income":-27,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"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":101332,"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":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":100041,"Investment income total":65802,"Net investment gain":34239,"Income from invest bond proceeds":0},"Other revenues":{"value":1291,"Other total":-27,"Royalties revenue":0,"Net rental income":1318,"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":22934,"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":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":22934,"Management services":10000,"Legal":0,"Accounting":3750,"Lobbying services":0,"Investment management fees":8984,"Other services":0,"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":200,"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":22934,"Fundraising Expenses":0}},"Assets":{"value":2788418,"Non-interest bearing cash":0,"Savings and temp cash investments":83282,"Pledges and grants receivable":0,"Accounts receivable":1156,"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":2107438,"Investments other":596542,"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":2788418,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":2788418,"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.7736746536138633,"percentile":0.9695476308925038},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":121.58445975407692,"percentile":0.9909182199234114},"Officer Compensation Ratio":{"score":5.849699136653005,"percentile":0.004189891611767642},"Program Expense Growth":{"score":-0.4090909090909091,"percentile":0.043838865605085174},"Revenue Growth":{"score":-0.20979592998029717,"percentile":0.07195148957781274},"Asset Growth":{"score":0.04392634686008551,"percentile":0.502972810287687},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.567145536222415,"percentile":0.5082552676464983}},"source_xml":"201833309349300923_public.xml"},{"Organization":{"value":null,"Person":["JOHN P MCCONNELL","AMY MCCONNELL","MICHAEL J ENDRES","STEVEN J ALLEN","ANGELA G PARSONS","DOUGLAS F KRIDLER","SCOTT HEITKAMP"],"Title":["CHAIR/TREASURER/TRUSTEE","VICE CHAIR/SECRETARY/TRUST","TRUSTEE","TRUSTEE","TRUSTEE (AS OF 12/11/19)","PRESIDENT","ASST TREASURER"],"Hours":[1.0,1.0,1.0,1.0,0.5,0.5,0.5],"Total Compensation":[0,0,0,0,46723,99735,49418],"Direct compensation":[0,0,0,0,0,0,0],"Other compensation":[0,0,0,0,46723,99735,49418]},"Basic":{"value":null,"mission":"The purpose of the foundation is to support charitable organizations which benefit the community.","year":2019,"name":"THE JOHN H MCCONNELL FOUNDATION","phone":6142514000,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"SCOTT HEITKAMP","year_formation":1989,"state_legal_domicile":"OH","total_volunteers":0,"tax_period_begin":"2019-01-01T00:00:00","tax_period_end":"2019-12-31T00:00:00","address":"1234 EAST BROAD STREET, COLUMBUS, OH, 432051405, USA","city":"COLUMBUS","state":"OH","country":"USA","zip_code":432051405},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":5,"Number of independent voting members":4,"Number of employees total":0,"Total Gross UBI":-39,"Net unrelated business taxable income":-39,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"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":95235,"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":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":93846,"Investment income total":74704,"Net investment gain":19142,"Income from invest bond proceeds":0},"Other revenues":{"value":1389,"Other total":-39,"Royalties revenue":0,"Net rental income":1428,"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":24463,"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":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":24463,"Management services":10000,"Legal":0,"Accounting":3900,"Lobbying services":0,"Investment management fees":9983,"Other services":0,"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":{"value":580,"OTHER EXPENSES":380,"FILING FEES":200},"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":24463,"Fundraising Expenses":0}},"Assets":{"value":3070427,"Non-interest bearing cash":0,"Savings and temp cash investments":85969,"Pledges and grants receivable":0,"Accounts receivable":13273,"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":2389747,"Investments other":581438,"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":3070427,"Net assets without donor restriction":3070427,"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.7431301517299312,"percentile":0.9655487958352279},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":125.51310141846871,"percentile":0.9911512311703975},"Officer Compensation Ratio":{"score":8.007031026448105,"percentile":0.003523240247965004},"Program Expense Growth":{"score":-0.45454545454545453,"percentile":0.038283600442501765},"Revenue Growth":{"score":-0.07015368748203257,"percentile":0.1834065866689288},"Asset Growth":{"score":0.04479511157744466,"percentile":0.5064349910999328},"Independent Voting Board Pct":{"score":0.8,"percentile":0.1938826265975589},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5137572250280834,"percentile":0.35697625561881957}},"source_xml":"202033089349302153_public.xml"},{"Organization":{"value":null,"Person":["JOHN P MCCONNELL","AMY MCCONNELL","DOUGLAS F KRIDLER","SCOTT HEITKAMP","ANGELA G PARSONS"],"Title":["CHAIR/TREASURER/TRUSTEE","VICE CHAIR/SECRETARY/TRUST","TRUSTEE/PRESIDENT","TRUSTEE/ASST TREASURER","TRUSTEE"],"Hours":[1.0,1.0,0.5,0.5,0.5],"Total Compensation":[0,0,107467,63398,58041],"Direct compensation":[0,0,0,0,0],"Other compensation":[0,0,107467,63398,58041]},"Basic":{"value":null,"mission":"The purpose of the foundation is to support charitable organizations which benefit the community.","year":2024,"name":"THE JOHN H MCCONNELL FOUNDATION","phone":6142514000,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"SCOTT G HEITKAMP","year_formation":1989,"state_legal_domicile":"OH","total_volunteers":0,"tax_period_begin":"2024-01-01T00:00:00","tax_period_end":"2024-12-31T00:00:00","address":"1234 E BROAD ST, COLUMBUS, OH, 43205, USA","city":"COLUMBUS","state":"OH","country":"USA","zip_code":43205},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":5,"Number of independent voting members":2,"Number of employees total":0,"Total Gross UBI":-39,"Net unrelated business taxable income":0,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"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":227546,"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":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":225895,"Investment income total":102921,"Net investment gain":122974,"Income from invest bond proceeds":0},"Other revenues":{"value":1651,"Other total":-39,"Royalties revenue":0,"Net rental income":1690,"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":31693,"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":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":31693,"Management services":10000,"Legal":0,"Accounting":4700,"Lobbying services":0,"Investment management fees":16768,"Other services":0,"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":225,"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":31693,"Fundraising Expenses":0}},"Assets":{"value":4463162,"Non-interest bearing cash":0,"Savings and temp cash investments":267120,"Pledges and grants receivable":0,"Accounts receivable":751,"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":3438278,"Investments other":757013,"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":4463162,"Net assets without donor restriction":4463162,"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.8607182723493272,"percentile":0.9795605133329488},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":140.82485091345092,"percentile":0.9918937145367694},"Officer Compensation Ratio":{"score":7.222604360584356,"percentile":0.0037254334088545954},"Program Expense Growth":{"score":-0.3304405874499332,"percentile":0.05674502421163306},"Revenue Growth":{"score":0.03006143923542594,"percentile":0.5149635301136581},"Asset Growth":{"score":0.06228262525259492,"percentile":0.5717756986812088},"Independent Voting Board Pct":{"score":0.4,"percentile":0.12263016446670459},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5457561720652132,"percentile":0.4449321181997459}},"source_xml":"202531339349301938_public.xml"},{"Organization":{"value":null,"Person":["JOHN P MCCONNELL","AMY MCCONNELL","DOUGLAS F KRIDLER","SCOTT HEITKAMP","ANGELA G PARSONS"],"Title":["CHAIR/TREASURER/TRUSTEE","VICE CHAIR/SECRETARY/TRUST","TRUSTEE/PRESIDENT","TRUSTEE/ASST TREASURER","TRUSTEE"],"Hours":[1.0,1.0,0.5,0.5,0.5],"Total Compensation":[0,0,101206,52149,51651],"Direct compensation":[0,0,0,0,0],"Other compensation":[0,0,101206,52149,51651]},"Basic":{"value":null,"mission":"The purpose of the foundation is to support charitable organizations which benefit the community.","year":2020,"name":"THE JOHN H MCCONNELL FOUNDATION","phone":6142514000,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"SCOTT HEITKAMP","year_formation":1989,"state_legal_domicile":"OH","total_volunteers":0,"tax_period_begin":"2020-01-01T00:00:00","tax_period_end":"2020-12-31T00:00:00","address":"1234 EAST BROAD STREET, COLUMBUS, OH, 432051405, USA","city":"COLUMBUS","state":"OH","country":"USA","zip_code":432051405},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":5,"Number of independent voting members":2,"Number of employees total":0,"Total Gross UBI":-32,"Net unrelated business taxable income":0,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"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":308498,"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":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":307054,"Investment income total":66298,"Net investment gain":240756,"Income from invest bond proceeds":0},"Other revenues":{"value":1444,"Other total":-32,"Royalties revenue":0,"Net rental income":1476,"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":26880,"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":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":26880,"Management services":10000,"Legal":0,"Accounting":4000,"Lobbying services":0,"Investment management fees":12303,"Other services":0,"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":{"value":577,"OTHER EXPENSES":377,"FILING FEES":200},"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":26880,"Fundraising Expenses":0}},"Assets":{"value":3473397,"Non-interest bearing cash":0,"Savings and temp cash investments":131972,"Pledges and grants receivable":0,"Accounts receivable":358,"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":2704535,"Investments other":636532,"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":3473397,"Net assets without donor restriction":3473397,"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.9128681547368216,"percentile":0.985038556628628},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":129.21863839285714,"percentile":0.9913442283437468},"Officer Compensation Ratio":{"score":7.6267113095238095,"percentile":0.0036228716605772662},"Program Expense Growth":{"score":-0.4415584415584416,"percentile":0.03983801213537949},"Revenue Growth":{"score":0.04176085488706301,"percentile":0.5703798954659642},"Asset Growth":{"score":0.0570443657411537,"percentile":0.5531664417702344},"Independent Voting Board Pct":{"score":0.4,"percentile":0.12263016446670459},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5486464490344325,"percentile":0.45333307468647904}},"source_xml":"202113089349303151_public.xml"},{"Organization":{"value":null,"Person":["JOHN P MCCONNELL","AMY MCCONNELL","MICHAEL J ENDRES","STEVEN J ALLEN","DOUGLAS F KRIDLER","SCOTT HEITKAMP"],"Title":["CHAIR/TREASURER/TRUSTEE","VICE CHAIR/SECRETARY/TRUST","TRUSTEE","TRUSTEE","PRESIDENT","ASST TREASURER"],"Hours":[1.0,1.0,1.0,1.0,0.5,0.5],"Total Compensation":[0,0,0,0,99545,47877],"Direct compensation":[0,0,0,0,0,0],"Other compensation":[0,0,0,0,99545,47877]},"Basic":{"value":null,"mission":"The purpose of the foundation is to support charitable organizations which benefit the community.","year":2018,"name":"THE JOHN H MCCONNELL FOUNDATION","phone":6142514000,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"SCOTT HEITKAMP","year_formation":1989,"state_legal_domicile":"OH","total_volunteers":0,"tax_period_begin":"2018-01-01T00:00:00","tax_period_end":"2018-12-31T00:00:00","address":"1234 EAST BROAD STREET, COLUMBUS, OH, 432051405, USA","city":"COLUMBUS","state":"OH","country":"USA","zip_code":432051405},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":4,"Number of independent voting members":4,"Number of employees total":0,"Total Gross UBI":-126,"Net unrelated business taxable income":-126,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"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":214069,"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":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":212840,"Investment income total":66892,"Net investment gain":145948,"Income from invest bond proceeds":0},"Other revenues":{"value":1229,"Other total":-126,"Royalties revenue":0,"Net rental income":1355,"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":23703,"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":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":23703,"Management services":10000,"Legal":0,"Accounting":3800,"Lobbying services":0,"Investment management fees":9250,"Other services":0,"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":{"value":653,"OTHER EXPENSES":453,"FILING FEES":200},"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":23703,"Fundraising Expenses":0}},"Assets":{"value":2591256,"Non-interest bearing cash":0,"Savings and temp cash investments":67956,"Pledges and grants receivable":0,"Accounts receivable":1135,"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":1981564,"Investments other":540601,"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":2591256,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":2591256,"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.8892740191246747,"percentile":0.9825539840694694},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":109.32185799265916,"percentile":0.9901332973880308},"Officer Compensation Ratio":{"score":6.219550267898578,"percentile":0.0040448399963468485},"Program Expense Growth":{"score":-0.45194805194805193,"percentile":0.03860836451725406},"Revenue Growth":{"score":-0.041594629027318177,"percentile":0.23814263248942916},"Asset Growth":{"score":0.03290633350032296,"percentile":0.45810772431631813},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5809604709941734,"percentile":0.5492773253568777}},"source_xml":"201903039349301670_public.xml"},{"Organization":{"value":null,"Person":["JOHN P MCCONNELL","AMY MCCONNELL","DOUGLAS F KRIDLER","SCOTT HEITKAMP","ANGELA G PARSONS"],"Title":["CHAIR/TREASURER/TRUSTEE","VICE CHAIR/SECRETARY/TRUST","TRUSTEE/PRESIDENT","TRUSTEE/ASST TREASURER","TRUSTEE"],"Hours":[1.0,1.0,0.5,0.5,0.5],"Total Compensation":[0,0,51618,58454,58051],"Direct compensation":[0,0,0,0,0],"Other compensation":[0,0,51618,58454,58051]},"Basic":{"value":null,"mission":"The purpose of the foundation is to support charitable organizations which benefit the community.","year":2022,"name":"THE JOHN H MCCONNELL FOUNDATION","phone":6142514000,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"SCOTT HEITKAMP","year_formation":1989,"state_legal_domicile":"OH","total_volunteers":0,"tax_period_begin":"2022-01-01T00:00:00","tax_period_end":"2022-12-31T00:00:00","address":"1234 E BROAD ST, COLUMBUS, OH, 43205, USA","city":"COLUMBUS","state":"OH","country":"USA","zip_code":43205},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":5,"Number of independent voting members":2,"Number of employees total":0,"Total Gross UBI":-37,"Net unrelated business taxable income":0,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"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":172111,"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":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":170604,"Investment income total":76251,"Net investment gain":94353,"Income from invest bond proceeds":0},"Other revenues":{"value":1507,"Other total":-37,"Royalties revenue":0,"Net rental income":1544,"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":28702,"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":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":28702,"Management services":10000,"Legal":0,"Accounting":4400,"Lobbying services":0,"Investment management fees":13588,"Other services":0,"Advertising":0,"Office expenses":514,"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":200,"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":28702,"Fundraising Expenses":0}},"Assets":{"value":3352724,"Non-interest bearing cash":0,"Savings and temp cash investments":137506,"Pledges and grants receivable":0,"Accounts receivable":584,"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":2588354,"Investments other":626280,"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":3352724,"Net assets without donor restriction":3352724,"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.8332355282346857,"percentile":0.9765790670227256},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":116.81151139293429,"percentile":0.990631048213119},"Officer Compensation Ratio":{"score":5.857536060204864,"percentile":0.00418891483321262},"Program Expense Growth":{"score":-0.3826979472140762,"percentile":0.04836328332195088},"Revenue Growth":{"score":0.028343410489660888,"percentile":0.5065533248727341},"Asset Growth":{"score":0.051333638614707834,"percentile":0.531879454764697},"Independent Voting Board Pct":{"score":0.4,"percentile":0.12263016446670459},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5413195288479179,"percentile":0.43212569917144344}},"source_xml":"202333059349302183_public.xml"},{"Organization":{"value":null,"Person":["JOHN P MCCONNELL","AMY MCCONNELL","DOUGLAS F KRIDLER","SCOTT HEITKAMP","ANGELA G PARSONS"],"Title":["CHAIR/TREASURER/TRUSTEE","VICE CHAIR/SECRETARY/TRUST","TRUSTEE/PRESIDENT","TRUSTEE/ASST TREASURER","TRUSTEE"],"Hours":[1.0,1.0,0.5,0.5,0.5],"Total Compensation":[0,0,105945,63469,58986],"Direct compensation":[0,0,0,0,0],"Other compensation":[0,0,105945,63469,58986]},"Basic":{"value":null,"mission":"The purpose of the foundation is to support charitable organizations which benefit the community.","year":2023,"name":"THE JOHN H MCCONNELL FOUNDATION","phone":6142514000,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"SCOTT G HEITKAMP","year_formation":1989,"state_legal_domicile":"OH","total_volunteers":0,"tax_period_begin":"2023-01-01T00:00:00","tax_period_end":"2023-12-31T00:00:00","address":"1234 E BROAD ST, COLUMBUS, OH, 43205, USA","city":"COLUMBUS","state":"OH","country":"USA","zip_code":43205},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":5,"Number of independent voting members":2,"Number of employees total":0,"Total Gross UBI":-37,"Net unrelated business taxable income":0,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"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":171594,"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":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":170050,"Investment income total":90284,"Net investment gain":79766,"Income from invest bond proceeds":0},"Other revenues":{"value":1544,"Other total":-37,"Royalties revenue":0,"Net rental income":1581,"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":29014,"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":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":29014,"Management services":10000,"Legal":0,"Accounting":4600,"Lobbying services":0,"Investment management fees":14214,"Other services":0,"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":200,"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":29014,"Fundraising Expenses":0}},"Assets":{"value":4040459,"Non-interest bearing cash":0,"Savings and temp cash investments":133536,"Pledges and grants receivable":0,"Accounts receivable":994,"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":3067074,"Investments other":838855,"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":4040459,"Net assets without donor restriction":4040459,"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.8309148338519995,"percentile":0.9763287959126733},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":139.2589439580892,"percentile":0.9918312683309423},"Officer Compensation Ratio":{"score":7.872061763286689,"percentile":0.003554985551003225},"Program Expense Growth":{"score":-0.35146671510307864,"percentile":0.05326173670802339},"Revenue Growth":{"score":0.021258754126989434,"percentile":0.47108292031218546},"Asset Growth":{"score":0.05748326434861048,"percentile":0.5547703883591775},"Independent Voting Board Pct":{"score":0.4,"percentile":0.12263016446670459},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5399723438798736,"percentile":0.42831619097977097}},"source_xml":"202431359349310853_public.xml"},{"Organization":{"value":null,"Person":["JOHN P MCCONNELL","AMY MCCONNELL","JOHN F WOLFE","MICHAEL J ENDRES","STEVEN J ALLEN","DOUGLAS F KRIDLER","RAYMOND J BIDDISCOMBE"],"Title":["CHAIR/TREASURER/TRUSTEE","VICE CHAIR/SECRETARY/TRUST","TRUSTEE","TRUSTEE","TRUSTEE","PRESIDENT","ASST TREASURER"],"Hours":[1.0,1.0,1.0,1.0,1.0,0.5,0.5],"Total Compensation":[0,0,0,0,0,114866,36098],"Direct compensation":[0,0,0,0,0,0,0],"Other compensation":[0,0,0,0,0,114866,36098]},"Basic":{"value":null,"mission":"The purpose of the foundation is to support charitable organizations which benefit the community.","year":2015,"name":"THE JOHN H MCCONNELL FOUNDATION","phone":6142514000,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"RAYMOND J BIDDISCOMBE","year_formation":1989,"state_legal_domicile":"OH","total_volunteers":0,"tax_period_begin":"2015-01-01T00:00:00","tax_period_end":"2015-12-31T00:00:00","address":"1234 EAST BROAD STREET, COLUMBUS, OH, 432051405, USA","city":"COLUMBUS","state":"OH","country":"USA","zip_code":432051405},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":5,"Number of independent voting members":5,"Number of employees total":0,"Total Gross UBI":2904,"Net unrelated business taxable income":0,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"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":116607,"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":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":115403,"Investment income total":63866,"Net investment gain":51537,"Income from invest bond proceeds":0},"Other revenues":{"value":1204,"Other total":-46,"Royalties revenue":0,"Net rental income":1250,"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":73004,"Grant expense":{"value":50000,"Grants to domestic orgs":50000,"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":23004,"Management services":10000,"Legal":0,"Accounting":3650,"Lobbying services":0,"Investment management fees":9154,"Other services":0,"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":200,"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":50000,"Management And General Expenses":23004,"Fundraising Expenses":0}},"Assets":{"value":2263556,"Non-interest bearing cash":0,"Savings and temp cash investments":110552,"Pledges and grants receivable":0,"Accounts receivable":14018,"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":1624510,"Investments other":514476,"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":2263556,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":2263556,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.6848939784121418,"percentile":0.5285097435814812},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.3739312391194354,"percentile":0.8738578578301128},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":31.00591748397348,"percentile":0.968398178025847},"Officer Compensation Ratio":{"score":2.0678866911402114,"percentile":0.007931930256057615},"Program Expense Growth":{"score":0.0,"percentile":0.3240494224083784},"Revenue Growth":{"score":-0.11474575246615762,"percentile":0.12900398140907893},"Asset Growth":{"score":-0.011051688051831876,"percentile":0.27665148884428653},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5977821065737844,"percentile":0.5990047162387361}},"source_xml":"201641339349304834_public.xml"},{"Organization":{"value":null,"Person":["JOHN P MCCONNELL","AMY MCCONNELL","JOHN F WOLFE","MICHAEL J ENDRES","DOUGLAS F KRIDLER","RAYMOND J BIDDISCOMBE"],"Title":["CHAIR/TREASURER/TRUSTEE","VICE CHAIR/SECRETARY/TRUST","TRUSTEE","TRUSTEE","PRESIDENT","ASST TREASURER"],"Hours":[1.0,1.0,1.0,1.0,0.5,0.5],"Total Compensation":[0,0,0,0,110706,38489],"Direct compensation":[0,0,0,0,0,0],"Other compensation":[0,0,0,0,110706,38489]},"Basic":{"value":null,"mission":"The purpose of the foundation is to support charitable organizations which benefit the community.","year":2013,"name":"THE JOHN H MCCONNELL FOUNDATION","phone":6142514000,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"RAYMOND J BIDDISCOMBE","year_formation":1989,"state_legal_domicile":"OH","total_volunteers":0,"tax_period_begin":"2013-01-01T00:00:00","tax_period_end":"2013-12-31T00:00:00","address":"1234 EAST BROAD STREET, COLUMBUS, OH, 432051405, USA","city":"COLUMBUS","state":"OH","country":"USA","zip_code":432051405},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":4,"Number of independent voting members":4,"Number of employees total":0,"Total Gross UBI":1731,"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":157102,"Contributions":{"value":50000,"Other contributions":50000,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"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":126053,"Investment income total":66180,"Net investment gain":59873,"Income from invest bond proceeds":0},"Other revenues":{"value":-18951,"Other total":-18951,"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":72182,"Grant expense":{"value":50000,"Grants to domestic orgs":50000,"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":22182,"Management services":10000,"Legal":0,"Accounting":3650,"Lobbying services":0,"Investment management fees":8332,"Other services":0,"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":200,"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":50000,"Management And General Expenses":22182,"Fundraising Expenses":0}},"Assets":{"value":2314835,"Non-interest bearing cash":0,"Savings and temp cash investments":84733,"Pledges and grants receivable":0,"Accounts receivable":697,"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":1649629,"Investments other":579776,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":23850,"Sum of Total Liabilities":0,"Accounts payable, accrued":23850,"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":2290985,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":2290985,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.6926934692859715,"percentile":0.532668589335632},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.5405405405405406,"percentile":0.9289223933336581},"Liabilities to Assets Ratio":{"score":0.010303110156879432,"percentile":0.4967600490304523},"Operating Reserve Ratio":{"score":32.06942173949184,"percentile":0.9696570046151586},"Officer Compensation Ratio":{"score":2.0669280430024104,"percentile":0.00793388381316766},"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.6951594032400511,"percentile":0.8405650127200256}},"source_xml":"201421349349303647_public.xml"}],"Latest":{"Organization":{"value":null,"Person":["JOHN P MCCONNELL","AMY MCCONNELL","DOUGLAS F KRIDLER","SCOTT HEITKAMP","ANGELA G PARSONS"],"Title":["CHAIR/TREASURER/TRUSTEE","VICE CHAIR/SECRETARY/TRUST","TRUSTEE/PRESIDENT","TRUSTEE/ASST TREASURER","TRUSTEE"],"Hours":[1.0,1.0,0.5,0.5,0.5],"Total Compensation":[0,0,107467,63398,58041],"Direct compensation":[0,0,0,0,0],"Other compensation":[0,0,107467,63398,58041]},"Basic":{"value":null,"mission":"The purpose of the foundation is to support charitable organizations which benefit the community.","year":2024,"name":"THE JOHN H MCCONNELL FOUNDATION","phone":6142514000,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"SCOTT G HEITKAMP","year_formation":1989,"state_legal_domicile":"OH","total_volunteers":0,"tax_period_begin":"2024-01-01T00:00:00","tax_period_end":"2024-12-31T00:00:00","address":"1234 E BROAD ST, COLUMBUS, OH, 43205, USA","city":"COLUMBUS","state":"OH","country":"USA","zip_code":43205},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":5,"Number of independent voting members":2,"Number of employees total":0,"Total Gross UBI":-39,"Net unrelated business taxable income":0,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"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":227546,"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":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":225895,"Investment income total":102921,"Net investment gain":122974,"Income from invest bond proceeds":0},"Other revenues":{"value":1651,"Other total":-39,"Royalties revenue":0,"Net rental income":1690,"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":31693,"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":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":31693,"Management services":10000,"Legal":0,"Accounting":4700,"Lobbying services":0,"Investment management fees":16768,"Other services":0,"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":225,"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":31693,"Fundraising Expenses":0}},"Assets":{"value":4463162,"Non-interest bearing cash":0,"Savings and temp cash investments":267120,"Pledges and grants receivable":0,"Accounts receivable":751,"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":3438278,"Investments other":757013,"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":4463162,"Net assets without donor restriction":4463162,"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.8607182723493272,"percentile":0.9795605133329488},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":140.82485091345092,"percentile":0.9918937145367694},"Officer Compensation Ratio":{"score":7.222604360584356,"percentile":0.0037254334088545954},"Program Expense Growth":{"score":-0.3304405874499332,"percentile":0.05674502421163306},"Revenue Growth":{"score":0.03006143923542594,"percentile":0.5149635301136581},"Asset Growth":{"score":0.06228262525259492,"percentile":0.5717756986812088},"Independent Voting Board Pct":{"score":0.4,"percentile":0.12263016446670459},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5457561720652132,"percentile":0.4449321181997459}},"source_xml":"202531339349301938_public.xml"},"sector":"","donation_categories":[],"zakat_policy":null},"error":null}