| | Columbia, SC | Santa Rosa, CA | United States |
| Population | 137,276 | 179,213 | 329,725,481 |
| Female Population | 50.0% | 51.4% | 50.5% |
| Male Population | 50.0% | 48.6% | 49.5% |
| Median Age | 28.2 | 40 | 38.4 |
| space3 | | | |
| Population - 2010 | 130,909 | 175,221 | 309,327,143 |
| Population - 2000 | 116,278 | 147,595 | 285,036,114 |
| Population - 1990 | 98,052 | 113,313 | 251,960,433 |
| Pop. 2000 to Now | 13.6% | 18.3% | 15.6% |
| Pop. 1990 to Now | 34.8% | 54.1% | 30.8% |
| space4 | | | |
| Population Density | 1,009.4 | 4,215.9 | 93.4 |
| Land Area | 136.0 | 42.5 | 3,531,905.4 |
| Water Area | 2.8 | 0.2 | 264,836.8 |
| space | | | |
| Est. Total Population By Age | | | |
| | Columbia, SC | Santa Rosa, CA | United States |
| Age 0 to 4 | 5.3% | 5.0% | 5.9% |
| Age 5 to 9 | 4.1% | 5.8% | 6.1% |
| Age 10 to 14 | 4.8% | 6.4% | 6.6% |
| Age 15 to 17 | 3.2% | 3.9% | 3.9% |
| Age 18 to 20 | 14.6% | 3.5% | 4.0% |
| Age 21 to 24 | 11.9% | 4.7% | 5.2% |
| Age 25 to 34 | 17.0% | 13.7% | 13.8% |
| Age 35 to 44 | 10.3% | 13.8% | 12.9% |
| Age 45 to 54 | 10.0% | 12.9% | 12.6% |
| Age 55 to 59 | 4.3% | 6.6% | 6.7% |
| Age 60 to 64 | 4.1% | 6.0% | 6.3% |
| Age 65 to 74 | 6.4% | 10.6% | 9.6% |
| Age 75 to 84 | 2.9% | 4.8% | 4.5% |
| Age 85 and over | 1.0% | 2.4% | 1.9% |
| space1 | | | |
| Race | | | |
| | Columbia, SC | Santa Rosa, CA | United States |
| White | 48.0% | 53.8% | 59.4% |
| Black | 40.3% | 1.9% | 12.2% |
| Asian | 2.6% | 5.8% | 5.6% |
| Native American | 0.2% | 0.3% | 0.6% |
| Hawaiian, Pacific Islander | 0.2% | 0.4% | 0.2% |
| Other | 0.3% | 0.4% | 0.4% |
| Two or More Races | 2.8% | 3.4% | 3.2% |
| Hispanic | 5.6% | 34.0% | 18.4% |
| space2 | | | |
| Marriage & Family | | | |
| | Columbia, SC | Santa Rosa, CA | United States |
| Married Population | 31.9% | 48.4% | 49.8% |
| Currently Married | 29.6% | 46.4% | 48.0% |
| Married but Separated | 2.3% | 2.0% | 1.8% |
| Single Population | 68.1% | 51.6% | 50.2% |
| Never Married | 55.7% | 33.8% | 33.8% |
| Divorced | 8.4% | 12.3% | 10.8% |
| Widowed | 4.0% | 5.4% | 5.6% |
| space5 | | | |
| Household Size | 2.19 | 2.60 | 2.60 |
| Households | 50,372 | 67,662 | 124,010,992 |
| Family Households | 24,276 | 42,220 | 80,755,759 |
| Married couple, w/children | 25.6% | 32.1% | 30.5% |
| Married couple, no children | 37.4% | 41.8% | 42.9% |
| Non Family Households | 26,096 | 25,442 | 43,255,233 |
| Single householder, w/children | 25.2% | 15.4% | 15.8% |
| Single householder, no children | 11.8% | 10.7% | 10.8% |