upneja.ai
← all data postsFamily policy / cfindexbacklog
1600×900 exportdata.upneja.ai
desired childrenactual fertilityaffordability gap

People want kids. Life got too expensive.

source-backedX first
post copy

The Baby Gap

A
Ayush Upneja
@upneja · draft

The fertility debate usually gets weird fast. But one question is pretty concrete: do people have fewer kids than they say they want because the surrounding life got too expensive? I’m mapping desired children vs actual children, then layering in housing, childcare, and wages.

draft tweet
what the visualization is

A gap chart between desired children and actual fertility, with housing/childcare/wage pressure layered in the empty space.

data shape

OECD, UN WPP, WVS, CDC/NCHS, ACS housing/income, childcare datasets.

animation

Desired line appears first, actual line trails below it, affordability pressure fills the gap.

why it works

It reframes a culture-war topic as a concrete affordability gap.

deep build brief
core thesis

The gap between the number of kids people say they want and the number they actually have — with affordability pressure sitting in between.

sharper tweet

The fertility debate usually gets weird fast. But one question is pretty concrete: are people having fewer kids than they say they want because the surrounding life got too expensive? I’m mapping desired children vs actual children — then layering in housing, childcare, wages, and family policy.

visual lead

A gap chart where the desired-family-size line floats above actual fertility. The empty space is filled with housing, childcare, wage, and policy pressure.

why this deserves a whole microsite

The interesting story is not ‘people do/don’t want kids.’ The story is the preference gap: many people report wanting children or wanting more children than they have, while housing, childcare, instability, and delayed partnership make the path harder.

data plan
Actual fertility
UN World Population Prospects — https://population.un.org/wpp/ and UN Data Portal — https://population.un.org/dataportal/ ; CDC/NCHS Natality — https://www.cdc.gov/nchs/nvss/births.htm

Fields: Total fertility rate by country/year; U.S. births by state/age; birth rates by demographic group.

Use: Actual line in the desired-vs-actual gap chart.

Fertility preferences
OECD Family Database — https://www.oecd.org/els/family/database.htm ; World Values Survey — https://www.worldvaluessurvey.org/

Fields: Ideal number of children, desired family size, attitudes toward family/children by country/cohort where available.

Use: Desired line. Cross-country comparisons and cohort splits.

Affordability pressure
ACS 5-year API (B19013 income, B25064 rent, B25077 home value, B25070 rent burden); HUD Fair Market Rents; BLS wages; DOL National Database of Childcare Prices — https://www.dol.gov/agencies/wb/topics/childcare/price-by-age-care-setting

Fields: Rent/income, home price/income, wages, childcare price by county/age setting, commuting time.

Use: Fill the gap with explanatory pressure variables.

Policy context
OECD family benefits, paid leave, childcare spending; state policy sources

Fields: Paid leave, childcare subsidy, family benefits, public childcare access.

Use: Compare places with similar preferences but different affordability/policy environments.

method
  1. 1.Start international: OECD countries where desired/ideal children and actual TFR are both available.
  2. 2.Compute baby gap = desired/ideal number of children - actual total fertility rate. Label exact definitions clearly because surveys differ.
  3. 3.Second version: U.S. state/county affordability overlay using actual birth rates plus housing/childcare/wage pressure. Desired fertility may need national or survey subgroup proxy if state-level preference data is thin.
  4. 4.Create cohorts if possible: women/men, age groups, income/education. Avoid treating one national average as everyone’s preference.
  5. 5.Frame carefully: not ‘people should have more kids,’ but ‘can people have the families they say they want?’
visual

Main X card: the gap

Countries or states sorted by the gap between desired children and actual fertility, with affordability pressure shown as color intensity.

It makes a culture-war topic look concrete and measurable.

visual

Affordability wedge

Desired line and actual line with the space between them filled by housing, childcare, and wage-pressure bands.

The viewer instantly understands that the gap is the story.

visual

Policy comparison cards

Two countries/cities with similar desired family size but different actual fertility and support systems.

Creates debate around policy rather than vague moralizing.

animation spec
  1. 1.Frame 1: desired children line appears by country/cohort.
  2. 2.Frame 2: actual fertility line appears below it.
  3. 3.Frame 3: the gap fills in red/orange and gets labeled ‘the baby gap.’
  4. 4.Frame 4: housing, childcare, wages, and partnership delay icons layer into the gap.
  5. 5.Frame 5: countries/states reorder by largest gap.
  6. 6.Frame 6: CTA: ‘what would make the lines converge?’
caveats
  1. 1.Desired children survey questions differ across sources; do not over-compare incompatible definitions.
  2. 2.Actual TFR is a period measure, not completed family size. Explain this plainly.
  3. 3.Avoid coercive/pro-natalist framing. The frame is autonomy and affordability.
  4. 4.Infertility, partnership, health, culture, and preference changes also matter; affordability is not the only driver.
build steps
  1. 1.Build cross-country OECD/UN version first because desired vs actual is clearest there.
  2. 2.Then build U.S. affordability overlay using childcare/rent/wage data.
  3. 3.Then make cfindex.org version as a family-formation affordability dashboard.
  4. 4.Then make a short thread with 3 surprising country examples and one U.S. state/city teaser.
Thread beats
  1. 1.This should not be framed as coercive pro-natalism. It is about whether people can have the families they say they want.
  2. 2.The key chart is desired family size vs actual fertility, with affordability pressure sitting in the gap.
  3. 3.This is one of the cleanest anchors for cfindex.org.
Sources to pull
  1. OECD family/fertility indicators
  2. UN World Population Prospects
  3. World Values Survey
  4. CDC/NCHS natality
  5. ACS housing/income
  6. childcare cost datasets
CTA

The policy question: what would make the desired and actual lines converge?

visualization package
X hero card16:9
desired childrenactual fertilityaffordability gap
Carousel frame4:5
frame 1

People want kids. Life got too expensive.

The fertility debate usually gets weird fast.

Vertical animation9:16
01
hook appears
02
data reveals
03
labels snap in
04
CTA end card
babygap.mp4
more posts