tungwaiyip.info

home

about me

links

Blog

< June 2011 >
SuMoTuWeThFrSa
    1 2 3 4
5 6 7 8 91011
12131415161718
19202122232425
2627282930  

past articles »

Click for San Francisco, California Forecast

San Francisco, USA

 

S.F. Children Flee City Before Entering School, Census Data Shows

(Sorry these charts below are confusing. Please see the new charts of my second attempt.)

San Francisco is losing children population. Family move out of the city because of bad schools and expensive housing. Such is the popular conception of the issue of living in the city. But I have also heard some contradicting figures, like the kindergarten enrollment is steadily increasing in recent years. So rather than listening only to anecdotes, I am most interested in looking for some hard data to understand the extent of the issue.

Luckily we have the wonderful U.S. Census Bureau. They have collected and published lots of data at great level of details. Not only is the census of 1990, 2000 and 2010 available, the American Community Survey has also provided 1-Year estimates for every year since 2000. This allows me to do an analysis on the demographics. By tracking individual cohort and comparing their population change over time, it is able isolate other factors to provide insight on whether or how children leave the city.

The analysis mostly validate the observation that children are leaving the city before entering school. Moreover it suggests that the initial elementary school enrollment is the only event that triggers mass migration. Other factors, like real estate concerns, may not play any significant role.

SF total population

First of all the overall population of San Francisco is growing slowly. It has recovered from the lost after the dot-com crash and arrive a near all time high 0f 800,000. This is 11% over the population of 1990.

SF Children population

The children population, in this study it is defined as 0-19 year old, has shown similar fluctuation around the dot-com crash. However the overall trend is slightly down, it is 2% less than 2000 and 6% less than 1990. Since the overall population is up, as the percentage of population the decline is even more steep.

SF age < 5

Looking at the population of the group from new born to 4, it has instilled some hope. The number is holding up well and perhaps even on a upward tread. The number is slightly less than 1990 but 11% more than 2000.

Five year change

The next 2 charts are perhaps the most interesting in this analysis. Rather than looking at one aggregated number, we track the individual cohorts and compare its change in 5 years. This directly answers the question whether children are leaving San Francisco. For example, the blue data point at the lower right hand corner represent the group of 0-4 years in 2005. It says that in 2010, when this cohort turns 5-9, their population is only 72% compare to where they have started. One quarter of them has left due to net migration. The green data point at the upper right hand corner tells a more positive story. It says that the 10-14 cohort in 2005 gains 20% in 5 years when they have turned 15-19 in 2010. Older children are actually moving into the city.

The population in separated in three groups (as compiled by the census bureau), under 5, 5-9 and 10-14. They shows a rather divergent outcome. Nearly all the losses come from the under 5 group. And it is at a rather significant drop of one quarter in size! The lost ease up for the older group. In fact more recent census shows that the cohort actually grow in size!

(One note about the five year change charts, the child mortality rate is negligible here. The changes mainly come from net migration.)

Five year change by population percentage

While it is a good for population to grow due to immigration, we are particularly interested to see how well we are retaining children who are already in the city. For this we compare the population of each cohort as a percentage of population instead. The overall pattern remains similar, although it makes the lost of the under 5 group even more terrible. This metrics maybe a little bias against the children population though, because I believe the recent influx of immigrant is more likely to have a higher percentage of childless adult as they are more mobile.

The sharp drop of children after they turn 5 points to one single issue, family are leaving at the time when the child first enroll in school. People are concern about the quality of public schools. The assignment system leave them feel out of control. Many bait out when they are not assigned to popular schools.

A sharp drop of children at age of 5 is a more acute problem than if the drop is gradual over time. It lowers the basis for the older groups. Even when there are population increase in older group, it is already on a smaller base. And it comes too late to make a long term boost to the children population.

On the other hand, this analysis largely discount other issues such as housing problem. As children grow, they need more space as they grow physically bigger, acquired more stuff and become more independent. The housing issue should have become more pressing over time. However the population drop off ceased and it even turned into growth for older groups. Housing issues seems far less influential compare to school enrollment.

To halt the exodus of family, the key is in improving the initial school enrollment. As a parent who are right at this watershed stage, I find the public school quality issue is often a perceived one. Nearly all the schools I have toured leave me a positive impression. And those are not even trophy schools people are clamoring, but simply neighborhood schools. It is unfortunately to find so many people dismiss the schools as unacceptable before even trying.

Here is the data I have prepared for anyone who want to validate or further analyze the result.

2011.06.23 [] - comments

 

 

blog comments powered by Disqus

past articles »

 

BBC News

 

Ukraine war: Russian missile strikes kill 19 in Odesa region - emergency service (01 Jul 2022)

 

Xi defends Hong Kong rule on handover anniversary (01 Jul 2022)

 

Brittney Griner: Detained US basketball star appears in Russian court on drug charges (01 Jul 2022)

 

Technoblade: Minecraft YouTuber dies from cancer aged 23 (01 Jul 2022)

 

Missing Cryptoqueen: FBI adds Ruja Ignatova to top ten most wanted (01 Jul 2022)

 

Nupur Sharma: India court says Prophet row 'set country on fire' (01 Jul 2022)

 

Bison attacks woman at Yellowstone National Park (01 Jul 2022)

 

Supreme Court limits Biden's power to cut emissions (30 Jun 2022)

 

North Korea claims Covid arrived on 'alien things' near border (01 Jul 2022)

 

US stocks see worst first half drop in more than 50 years (01 Jul 2022)

more »

 

SF Gate

 

'This will be somewhat painful': Elon Musk talks Twitter takeover in extended interview at TED2022 Vancouver (14 Apr 2022)

 

Best Background Check Services in 2022, Top 13 People Finder Sites Reviewed (5 Apr 2022)

 

Better.com employees got severance checks before they were laid off (9 Mar 2022)

 

Apple joins other Bay Area tech giants in responding to Russian invasion of Ukraine (1 Mar 2022)

 

Uber will now show you how you’re rated by drivers (18 Feb 2022)

 

The man behind Google’s Silicon Valley headquarters says fancy tech offices are ‘dangerous’ (24 Jan 2022)

more »


Site feed Updated: 2022-Jul-01 07:00