How I Built a Childcare Availability Platform for 38,000 French Nurseries Finding childcare in France is famously difficult: 230,000 spots are missing nationwide, and the search process involves calls to mairies, waiting lists at crèches associatives, and forms sent by post to CAF. I built a platform to fix this — here is the technical story. The Data Problem: 18 Different Source Formats French childcare data comes from multiple public sources, each with its own format and update frequency: Source Format Update Scope CAF (data.gouv.fr) CSV Monthly Agrément PMI + PSU subvention Mairie databases No API Variable Municipal crèches DREES SSAM Excel Annually Capacity statistics Monenfant.fr (CNAF) HTML Daily Limited fields The strategy: use the CAF CSV as the authoritative registry (38,427 établissements in the 2025 edition), then enrich with GPS coordinates from the government Base Adresse Nationale (BAN API), and supplement with phone/email via SIREN lookup on api.insee.fr.…