{"success":true,"data":{"_id":271194585,"filings":[{"Organization":{"value":null,"Person":["NICHOLAS J SCHRUP","MARGARET WICK","LINDA BUDDE","JIM THEISEN"],"Title":["PRESIDENT","VICE PRESIDENT","TREASURER/SECRETARY","BOARD MEMBER"],"Hours":[1.0,1.0,1.0,1.0],"Total Compensation":[0,0,0,0],"Direct compensation":[0,0,0,0],"Other compensation":[0,0,0,0]},"Basic":{"value":null,"mission":"Housing assistance to individuals with housing needs, particularly college-aged students","year":2020,"name":"COLUMBIA HOUSING","phone":5635887000,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"NICHOLAS J SCHRUP","year_formation":2009,"state_legal_domicile":"IA","total_volunteers":4,"tax_period_begin":"2020-10-01T00:00:00","tax_period_end":"2021-09-30T00:00:00","address":"1450 ALTA VISTA ST, DUBUQUE, IA, 52001, USA","city":"DUBUQUE","state":"IA","country":"USA","zip_code":52001},"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":0,"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":180399,"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":180289,"Total revenue":180289,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":110,"Investment income total":110,"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":144648,"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":144648,"Management services":0,"Legal":125,"Accounting":1200,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":0,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":90571,"Payments to affiliates":0,"Depreciation and depletion":51170,"Insurance":1582,"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":143323,"Management And General Expenses":1325,"Fundraising Expenses":0}},"Assets":{"value":1517912,"Non-interest bearing cash":19105,"Savings and temp cash investments":91033,"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":1404167,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":3607,"Other assets":0},"Liabilities":{"value":1454950,"Sum of Total Liabilities":0,"Accounts payable, accrued":1200,"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":1453750,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":62962,"Net assets without donor restriction":62962,"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.9908398318677064,"percentile":0.9073995230921673},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.19817737348876657,"percentile":0.754459992186161},"Liabilities to Assets Ratio":{"score":0.9585206520536105,"percentile":0.056762130202725844},"Operating Reserve Ratio":{"score":10.493833305679996,"percentile":0.8966565816381075},"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.8181025196079778,"percentile":0.9686482015477614}},"source_xml":"202232249349301113_public.xml"},{"Organization":{"value":null,"Person":["NICHOLAS J SCHRUP","MARGARET WICK","LINDA BUDDE","JIM THEISEN"],"Title":["PRESIDENT","VICE PRESIDENT","TREASURER/SECRETARY","BOARD MEMBER"],"Hours":[1.0,1.0,1.0,1.0],"Total Compensation":[0,0,0,0],"Direct compensation":[0,0,0,0],"Other compensation":[0,0,0,0]},"Basic":{"value":null,"mission":"Housing assistance to individuals with housing needs, particularly college-aged students","year":2021,"name":"COLUMBIA HOUSING","phone":5635887000,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"NICHOLAS J SCHRUP","year_formation":2009,"state_legal_domicile":"IA","total_volunteers":4,"tax_period_begin":"2021-10-01T00:00:00","tax_period_end":"2022-09-30T00:00:00","address":"1450 ALTA VISTA ST, DUBUQUE, IA, 52001, USA","city":"DUBUQUE","state":"IA","country":"USA","zip_code":52001},"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":0,"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":184097,"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":183895,"Total revenue":183895,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":202,"Investment income total":202,"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":140064,"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":140064,"Management services":0,"Legal":0,"Accounting":1200,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":41,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":86072,"Payments to affiliates":0,"Depreciation and depletion":51170,"Insurance":1581,"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":138823,"Management And General Expenses":1241,"Fundraising Expenses":0}},"Assets":{"value":1483236,"Non-interest bearing cash":10416,"Savings and temp cash investments":116216,"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":1354167,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":2437,"Other assets":0},"Liabilities":{"value":1376241,"Sum of Total Liabilities":0,"Accounts payable, accrued":1241,"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":1375000,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":106995,"Net assets without donor restriction":106995,"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.9911397646790039,"percentile":0.9079153005244375},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.23918369120626626,"percentile":0.7921329273832668},"Liabilities to Assets Ratio":{"score":0.927863805894679,"percentile":0.06028619396197846},"Operating Reserve Ratio":{"score":10.58970185058259,"percentile":0.8974827307948109},"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.8277757378070602,"percentile":0.9730552639667801}},"source_xml":"202340349349300549_public.xml"},{"Organization":{"value":null,"Person":["NICHOLAS J SCHRUP","MARGARET WICK","LINDA BUDDE","JIM THEISEN","DAVID SPAHN"],"Title":["PRESIDENT","VICE PRESIDENT","TREASURER/SECRETARY","BOARD MEMBER","BOARD MEMBER"],"Hours":[1.0,1.0,1.0,1.0,1.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":"Housing assistance to individuals with housing needs, particularly college-aged students","year":2024,"name":"COLUMBIA HOUSING","phone":5635887000,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"Nicholas J Schrup","year_formation":2009,"state_legal_domicile":"IA","total_volunteers":5,"tax_period_begin":"2024-10-01T00:00:00","tax_period_end":"2025-09-30T00:00:00","address":"1450 ALTA VISTA ST, DUBUQUE, IA, 52001, USA","city":"DUBUQUE","state":"IA","country":"USA","zip_code":52001},"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":0,"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":180212,"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":180000,"Total revenue":180000,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":212,"Investment income total":212,"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":124166,"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":124166,"Management services":0,"Legal":150,"Accounting":1200,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":41,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":71059,"Payments to affiliates":0,"Depreciation and depletion":50098,"Insurance":1618,"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":122775,"Management And General Expenses":1391,"Fundraising Expenses":0}},"Assets":{"value":1384187,"Non-interest bearing cash":490,"Savings and temp cash investments":4530,"Pledges and grants receivable":0,"Accounts receivable":175000,"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":1204167,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":1107179,"Sum of Total Liabilities":0,"Accounts payable, accrued":1241,"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":1105938,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":277008,"Net assets without donor restriction":277008,"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.9887972552872767,"percentile":0.9039409343204466},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.31100037733336294,"percentile":0.8418700306256024},"Liabilities to Assets Ratio":{"score":0.7998767507569425,"percentile":0.07896840223324533},"Operating Reserve Ratio":{"score":11.147874619461044,"percentile":0.9021318407140774},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":-0.03790527012022303,"percentile":0.2195280895217742},"Revenue Growth":{"score":0.003975562618896468,"percentile":0.38741649637680853},"Asset Growth":{"score":-0.022443920664451812,"percentile":0.2376938943211992},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6890415537219279,"percentile":0.8297454414991812}},"source_xml":"202630239349300028_public.xml"},{"Organization":{"value":null,"Person":["NICHOLAS J SCHRUP","MARGARET WICK","LINDA BUDDE","JIM THEISEN","DAVID SPAHN"],"Title":["PRESIDENT","VICE PRESIDENT","TREASURER/SECRETARY","BOARD MEMBER","BOARD MEMBER"],"Hours":[1.0,1.0,1.0,1.0,1.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":"Housing assistance to individuals with housing needs, particularly college-aged students","year":2022,"name":"COLUMBIA HOUSING","phone":5635887000,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"NICHOLAS J SCHRUP","year_formation":2009,"state_legal_domicile":"IA","total_volunteers":5,"tax_period_begin":"2022-10-01T00:00:00","tax_period_end":"2023-09-30T00:00:00","address":"1450 ALTA VISTA ST, DUBUQUE, IA, 52001, USA","city":"DUBUQUE","state":"IA","country":"USA","zip_code":52001},"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":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":188118,"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":187573,"Total revenue":187573,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":545,"Investment income total":545,"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":135475,"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":135475,"Management services":0,"Legal":155,"Accounting":1200,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":41,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":81272,"Payments to affiliates":0,"Depreciation and depletion":51170,"Insurance":1637,"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":134079,"Management And General Expenses":1396,"Fundraising Expenses":0}},"Assets":{"value":1452129,"Non-interest bearing cash":29956,"Savings and temp cash investments":116739,"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":1304167,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":1267,"Other assets":0},"Liabilities":{"value":1292491,"Sum of Total Liabilities":0,"Accounts payable, accrued":1241,"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":1291250,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":159638,"Net assets without donor restriction":159638,"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.9896955157778188,"percentile":0.9054328824728316},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.27984031299503503,"percentile":0.8223529601182389},"Liabilities to Assets Ratio":{"score":0.8900662406714555,"percentile":0.06627775784003814},"Operating Reserve Ratio":{"score":10.718796825982654,"percentile":0.8985982746658976},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":-0.03331371253528741,"percentile":0.22876415701443273},"Revenue Growth":{"score":0.02095223790928207,"percentile":0.46955094151463767},"Asset Growth":{"score":-0.02215772789341422,"percentile":0.23869674643597796},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6939576959642262,"percentile":0.8384883717907208}},"source_xml":"202440379349301629_public.xml"},{"Organization":{"value":null,"Person":["NICHOLAS J SCHRUP","MARGARET WICK","LINDA BUDDE","JIM THEISEN","DAVID SPAHN"],"Title":["PRESIDENT","VICE PRESIDENT","TREASURER/SECRETARY","BOARD MEMBER","BOARD MEMBER"],"Hours":[1.0,1.0,1.0,1.0,1.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":"Housing assistance to individuals with housing needs, particularly college-aged students","year":2023,"name":"COLUMBIA HOUSING","phone":5635887000,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"Nicholas J Schrup","year_formation":2009,"state_legal_domicile":"IA","total_volunteers":5,"tax_period_begin":"2023-10-01T00:00:00","tax_period_end":"2024-09-30T00:00:00","address":"1450 ALTA VISTA ST, DUBUQUE, IA, 52001, USA","city":"DUBUQUE","state":"IA","country":"USA","zip_code":52001},"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":0,"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":191823,"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":191208,"Total revenue":191208,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":615,"Investment income total":615,"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":130499,"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":130499,"Management services":0,"Legal":0,"Accounting":1200,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":41,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":76378,"Payments to affiliates":0,"Depreciation and depletion":51170,"Insurance":1710,"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":129258,"Management And General Expenses":1241,"Fundraising Expenses":0}},"Assets":{"value":1424703,"Non-interest bearing cash":13118,"Savings and temp cash investments":157320,"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":1254167,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":98,"Other assets":0},"Liabilities":{"value":1203741,"Sum of Total Liabilities":0,"Accounts payable, accrued":1241,"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":1202500,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":220962,"Net assets without donor restriction":220962,"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.9904903485850466,"percentile":0.9067933184568164},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.31969054805732366,"percentile":0.8468595561274744},"Liabilities to Assets Ratio":{"score":0.8449066226434562,"percentile":0.07289223952162535},"Operating Reserve Ratio":{"score":10.91734802565537,"percentile":0.9002586566305442},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":-0.03442013774948073,"percentile":0.2264436791399493},"Revenue Growth":{"score":0.02057554903907248,"percentile":0.4676261691767098},"Asset Growth":{"score":-0.021145631662577963,"percentile":0.2420122983256547},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6989101543168079,"percentile":0.8469537233447918}},"source_xml":"202510369349300531_public.xml"}],"Latest":{"Organization":{"value":null,"Person":["NICHOLAS J SCHRUP","MARGARET WICK","LINDA BUDDE","JIM THEISEN","DAVID SPAHN"],"Title":["PRESIDENT","VICE PRESIDENT","TREASURER/SECRETARY","BOARD MEMBER","BOARD MEMBER"],"Hours":[1.0,1.0,1.0,1.0,1.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":"Housing assistance to individuals with housing needs, particularly college-aged students","year":2024,"name":"COLUMBIA HOUSING","phone":5635887000,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"Nicholas J Schrup","year_formation":2009,"state_legal_domicile":"IA","total_volunteers":5,"tax_period_begin":"2024-10-01T00:00:00","tax_period_end":"2025-09-30T00:00:00","address":"1450 ALTA VISTA ST, DUBUQUE, IA, 52001, USA","city":"DUBUQUE","state":"IA","country":"USA","zip_code":52001},"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":0,"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":180212,"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":180000,"Total revenue":180000,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":212,"Investment income total":212,"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":124166,"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":124166,"Management services":0,"Legal":150,"Accounting":1200,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":41,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":71059,"Payments to affiliates":0,"Depreciation and depletion":50098,"Insurance":1618,"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":122775,"Management And General Expenses":1391,"Fundraising Expenses":0}},"Assets":{"value":1384187,"Non-interest bearing cash":490,"Savings and temp cash investments":4530,"Pledges and grants receivable":0,"Accounts receivable":175000,"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":1204167,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":1107179,"Sum of Total Liabilities":0,"Accounts payable, accrued":1241,"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":1105938,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":277008,"Net assets without donor restriction":277008,"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.9887972552872767,"percentile":0.9039409343204466},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.31100037733336294,"percentile":0.8418700306256024},"Liabilities to Assets Ratio":{"score":0.7998767507569425,"percentile":0.07896840223324533},"Operating Reserve Ratio":{"score":11.147874619461044,"percentile":0.9021318407140774},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":-0.03790527012022303,"percentile":0.2195280895217742},"Revenue Growth":{"score":0.003975562618896468,"percentile":0.38741649637680853},"Asset Growth":{"score":-0.022443920664451812,"percentile":0.2376938943211992},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6890415537219279,"percentile":0.8297454414991812}},"source_xml":"202630239349300028_public.xml"},"sector":"Education","donation_categories":[],"zakat_policy":null},"error":null}