Live workspace · free

Enter a Columbia address. Eight answers in seconds.

Parcel, building, flood, wetland, traffic, demographic and lending layers resolve at the address without leaving this page.

HomeMissouriBoone CountyColumbia

Columbia, Missouri: commercial real estate data.

Columbia is a Census city of 128,548 people across 67.56 square miles of land, in Boone County. Median household income is $66,498, 48.7 percent of occupied homes are owned, and the SBA record carries 252 7(a) approvals to borrowers here worth $71.5 m since FY2020.

Underlined figures are computed by MMCG Analytics, not published by the agency.

Columbia

What Columbia is

  • Census place typecity
  • Land area67.56 sq mi
  • Water area0.28 sq mi
  • Population per square mile of land1,903
  • County holding the largest share of its areaBoone County, 100.0 percent

US Census Bureau, cartographic boundary file, places, 2024 vintage. US Census Bureau, American Community Survey 5-Year Estimates, place level, 2020-2024 5-year.

Columbia

How many people live in Columbia

  • Population128,548
  • Median age29.5
  • Population under 1824,091
  • Share under 1818.7 percent
  • Population 65 and over14,883
  • Share 65 and over11.6 percent
  • Households52,564
  • Family households25,886
  • Share of households that are families49.2 percent

US Census Bureau, American Community Survey 5-Year Estimates, place level, 2020-2024 5-year.

Columbia

Income and work in Columbia

  • Median household income$66,498
  • Per capita income$39,340
  • Civilian labor force70,686
  • Employed67,846
  • Unemployed2,840
  • Unemployment rate4.0 percent
  • Adults 25 and over73,408
  • Adults 25 and over with a high school diploma or higher95.7 percent
  • Adults 25 and over with a bachelor degree or higher56.7 percent
  • Adults 25 and over with a graduate degree26.7 percent

US Census Bureau, American Community Survey 5-Year Estimates, place level, 2020-2024 5-year.

Columbia

Housing in Columbia

  • Housing units56,054
  • Occupied units52,564
  • Vacant units3,490
  • Vacancy rate6.2 percent
  • Owner occupied25,592
  • Renter occupied26,972
  • Ownership rate48.7 percent
  • Median owner-occupied home value$284,600
  • Median gross rent, monthly$1,097
  • Annual rent as a share of median income19.8 percent
  • Single family units33,224
  • Share single family59.3 percent
  • Units in buildings of two or more21,985
  • Share in buildings of two or more39.2 percent
  • Mobile homes845 plus or minus 213
  • Median year structure built1993

US Census Bureau, American Community Survey 5-Year Estimates, place level, 2020-2024 5-year.

Columbia

How Columbia gets to work

  • Workers 16 and over who commute60,167
  • Commuting under 15 minutes27,817
  • Share commuting under 15 minutes46.2 percent
  • Commuting 30 minutes or more6,665
  • Share commuting 30 minutes or more11.1 percent
  • Drove alone73.7 percent
  • Carpooled7.8 percent
  • Public transport1.2 percent plus or minus 0.4
  • Walked5.4 percent
  • Worked from home10.0 percent

US Census Bureau, American Community Survey 5-Year Estimates, place level, 2020-2024 5-year.

Columbia

SBA loans in Columbia (7(a))

  • Approvals252
  • Gross approval$71,478,500
  • Average approval$283,645
  • Median approval$125,000
  • Ninetieth percentile approval$683,720
  • Largest approval$3,225,200
  • Jobs supported2,580
  • Jobs per approval10.2
  • Loans with a final outcome59
  • Paid in full44
  • Charged off15
  • Charge-off rate over resolved loans25.4 percent
  • Median term120 months
  • Share on real estate terms of 20 years or more6.4 percent
  • Share to franchises13.5 percent
  • Distinct lenders35
  • Distinct industries by NAICS115

Counted by borrower city: approvals to borrowers whose address is in Columbia, in any county, FY2020 to FY2026.

US Small Business Administration, 7(a) FOIA release, FY2020 to FY2026 year to date, as of 2026-06-30.

Columbia

SBA loans in Columbia (504)

  • Approvals77
  • Gross approval$51,468,000
  • Average approval$668,416
  • Median approval$503,000
  • Largest approval$2,574,000
  • Jobs supported749
  • Loans with a final outcome31
  • Charged off0
  • Charge-off rate over resolved loans0.0 percent
  • Median term240 months
  • Distinct CDCs5

Counted by borrower city: approvals to borrowers whose address is in Columbia, in any county, FY2010 to FY2026.

US Small Business Administration, 504 FOIA release, FY2010 to FY2026 year to date, as of 2026-06-30.

Columbia

Flood risk in Columbia

  • NFIP communityCity of Columbia
  • NFIP community number290036
  • Participating in the NFIPYes
  • Community Rating System classNone
  • Currently effective map date04/19/17

The City of Columbia participates in the National Flood Insurance Program as community 290036 and carries no Community Rating System class, so no CRS premium discount applies to it.

Federal Emergency Management Agency, NFIP Community Status Book (OpenFEMA), as of 2026-09-26.

Boone County, not Columbia

Boone County context, not Columbia figures

  • Establishments in Boone County4,725
  • Covered employment, Boone County98,657
  • Average annual pay, Boone County$59,677
  • Housing units permitted, Boone County1,303

Every figure in this section is published for Boone County as a whole and is not a measurement of Columbia.

All Boone County figures →

US Census Bureau, County Business Patterns, 2023. US Bureau of Labor Statistics, Quarterly Census of Employment and Wages, 2024 annual averages. US Census Bureau, Building Permits Survey, 2024 annual.

Coverage

What this page does not hold.

Parcel detail, zoning and the flood zone at an address are not on this page; they resolve at the address in the platform. How this page was built →

Common questions

Columbia questions, answered from the record.

How many people live in Columbia, Missouri?

128,548, in 52,564 households. Columbia city covers 67.56 square miles of land, which is 1,903 people per square mile. Source: US Census Bureau, American Community Survey 5-Year Estimates, place level, 2020-2024 5-year.

What county is Columbia in?

Boone County, which holds 100.0 percent of the place by area. Source: US Census Bureau, cartographic boundary file, places, 2024 vintage.

What is the median household income in Columbia?

$66,498. The median owner-occupied home is valued at $284,600. Median gross rent is $1,097 per month. Source: US Census Bureau, American Community Survey 5-Year Estimates, place level, 2020-2024 5-year.

How much SBA lending goes to Columbia businesses?

252 7(a) approvals totaling $71.5 m since FY2020, across 35 lenders, median approval $125,000, plus 77 504 approvals worth $51.5 m since FY2010. These count approvals to borrowers whose address is in Columbia, not projects sited inside the place boundary, and they are approvals recorded in the release rather than loans disbursed.

Do SBA loans to Columbia borrowers get paid back?

Of the 59 loans that have reached a final outcome, 44 were paid in full and 15 charged off, a charge off rate of 25.4 percent. Loans still running are excluded because they have not yet succeeded or failed.

Is Columbia in the National Flood Insurance Program?

Yes. Columbia appears in the FEMA Community Status Book as Columbia, city of, community 290036, with no Community Rating System class, so no CRS discount applies. Whether a specific parcel sits in a mapped special flood hazard area is an address level question the platform answers.

Are the county figures on this page Columbia figures?

No, and they are labeled so. County Business Patterns, QCEW, the Building Permits Survey, BEA product and IRS migration are published for Boone County as a whole and there is no place level equivalent. They appear in one clearly marked section as context and are never presented as measurements of Columbia.

Is zoning published for Columbia?

No. Nothing on this page presents parcel level zoning.