{"id":"100a33c6-2fcb-41c4-af14-2094d9140a80","type":"DATASET","name":"Expenses All Plans [National]","slug":"expenses-all-plans-national","description":"Annual expenditure on all family and social benefit schemes managed by the Family branch from 2013. Expenditure is expressed in millions of Euros. The expenditure is indicated for each of the family benefits (early childhood and youth childhood) and social benefits (housing assistance, active solidarity income). It is broken down into the following categories:All schemes in France as a whole;All schemes in mainland France;All schemes in DOM;General scheme (CAF), France as a whole;General scheme (CAF), mainland France;General scheme (CAF), DOM;The field of all schemes aggregates data from the general scheme (CAF), the agricultural scheme (employees and farmers) and the special schemes (SNCF and RATP until 2014, EDF until 2012). The RSA expenditures of several departments have been recentralized into the state accounts. These are French Guiana and Mayotte from 2019, Reunion from 2020, as well as Seine-Saint-Denis and Pyrénées Orientales from January 2021 and July 2022 respectively.The Dom funds have the particularity of paying benefits to recipients of all plans.","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":null,"docs_url":null,"repo_url":"https://www.data.gouv.fr/api/1/datasets/r/137adcd8-15ad-4f05-ba18-28f0f4fbf47f","status":"ACTIVE","verification_state":"VERIFIED","tags":["salary"],"logo_url":"https://www.google.com/s2/favicons?sz=64&domain=data.gouv.fr","primary_source_url":"https://www.data.gouv.fr/api/1/datasets/r/137adcd8-15ad-4f05-ba18-28f0f4fbf47f","extraction_confidence":"0.16","created_at":"2026-07-30T13:43:03.882Z","updated_at":"2026-07-31T11:57:58.614Z","last_verified_at":"2026-07-30T13:50:08.820Z","deprecated_at":null,"ranking_score":38,"last_ranked_at":"2026-07-30T20:43:35.809Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-07-31T07:58:09.949Z","search_vector":"'2012':120B,295B '2013':20B,195B '2014':117B,292B '2019':141B,316B '2020':144B,319B '2021':157B,332B '2022':160B,335B 'a':239B,255B 'account':133B 'accounts':308B 'activ':48B 'active':223B 'aggreg':96B 'aggregates':271B 'agricultur':104B 'agricultural':279B 'all':177A,183B,234B,241B,246B,269B,348B 'and':185B,215B,218B,282B,284B,289B,313B,327B,333B 'annual':5B,180B 'are':310B 'as':238B,254B,320B,322B 'assist':47B 'assistance':222B 'been':303B 'benefit':12B,37B,45B,169B,187B 'benefits':212B,220B,344B 'branch':18B,193B 'broken':53B,228B 'by':190B 'caf':77B,84B,89B,102B,252B,259B,264B,277B 'categori':58B 'categories':233B 'childhood':39B,42B,214B,217B 'data':97B,272B 'deni':151B 'denis':326B 'depart':126B 'departments':301B 'dom':74B,90B,162B,249B,265B,337B 'down':229B 'each':208B 'earli':38B 'early':213B 'edf':118B,293B 'employe':106B 'employees':281B 'euro':27B 'euros':202B 'expenditur':6B,21B,29B,123B 'expenditure':181B,196B,204B 'expenditures':298B 'expens':1A 'expenses':176A 'express':23B 'expressed':198B 'famili':9B,17B,36B 'family':184B,192B,211B 'farmer':108B 'farmers':283B 'field':92B,267B 'follow':57B 'following':232B 'for':207B 'franc':62B,70B,78B,86B 'france':237B,245B,253B,261B 'french':136B,311B 'from':194B,273B,315B,318B,330B 'fund':163B 'funds':338B 'general':75B,82B,87B,100B,250B,257B,262B,275B 'guiana':137B,312B 'have':302B,339B 'hous':46B 'housing':221B 'in':199B,236B,243B,248B 'incom':50B 'income':225B 'indic':31B 'indicated':206B 'into':230B,305B 'is':197B,205B,227B 'it':226B 'januari':156B 'january':331B 'juli':159B 'july':334B 'mainland':69B,85B,244B,260B 'manag':14B 'managed':189B 'mayott':139B 'mayotte':314B 'million':25B 'millions':200B 'nation':4A 'national':179A 'of':201B,209B,268B,299B,342B,347B 'on':182B 'oriental':154B 'orientales':329B 'particular':166B 'particularity':341B 'pay':168B 'paying':343B 'plan':3A,174B 'plans':178A,349B 'pyrenees':328B 'pyréné':153B 'ratp':115B,290B 'recentr':129B 'recentralized':304B 'recipi':171B 'recipients':346B 'respectively.the':161B,336B 'reunion':142B,317B 'rsa':122B,297B 'saint':150B,325B 'salari':175C 'scheme':13B,60B,67B,72B,76B,83B,88B,95B,101B,105B,112B,251B,258B,263B,276B,280B 'schemes':188B,235B,242B,247B,270B,287B 'sein':149B 'seine':324B 'seine-saint-deni':148B 'seine-saint-denis':323B 'sever':125B 'several':300B 'sncf':113B,288B 'social':11B,44B,186B,219B 'solidar':49B 'solidarity':224B 'special':111B,286B 'state':132B,307B 'the':191B,203B,210B,231B,266B,274B,278B,285B,296B,306B,340B 'these':309B 'to':345B 'until':291B,294B 'well':146B,321B 'whole':65B,81B,240B,256B 'youth':41B,216B","popularity_score":"0.0000","maintenance_score":"0.5000","institution_id":"7abf1844-58f2-4b35-a86e-1e4a6b7652f7","institution_type":"AGENCY","country_code":"FR","official_confidence":null,"proof_summary":null,"source_seed_url":null,"is_public_sector":true,"published_at":"2026-07-31T09:36:00.000Z","geographic_scope":"NATIONAL","name_en":null,"description_en":null,"native_lang":null,"access_level":"direct","formats":["CSV","JSON"],"capability_tier":"live","trust_score":66.1923076923077,"access":{"level":"direct","primary":{"kind":"download","label":"Download CSV","method":"GET","url":"https://data.caf.fr/api/explore/v2.1/catalog/datasets/dep_tr_nat/exports/csv?use_labels=true","format":"CSV","source":"distribution","runnable":true},"actions":[{"kind":"download","label":"Download CSV","method":"GET","url":"https://data.caf.fr/api/explore/v2.1/catalog/datasets/dep_tr_nat/exports/csv?use_labels=true","format":"CSV","source":"distribution","runnable":true},{"kind":"download","label":"Download JSON","method":"GET","url":"https://data.caf.fr/api/explore/v2.1/catalog/datasets/dep_tr_nat/exports/json","format":"JSON","source":"distribution","runnable":true},{"kind":"landing","label":"Open source page","method":"GET","url":"https://data.caf.fr/explore/dataset/dep_tr_nat/","source":"landing_page","runnable":false},{"kind":"landing","label":"Open source record","method":"GET","url":"https://www.data.gouv.fr/api/1/datasets/r/137adcd8-15ad-4f05-ba18-28f0f4fbf47f","source":"primary_source","runnable":false}],"formats":["CSV","JSON"]},"maturity":{"entry_id":"100a33c6-2fcb-41c4-af14-2094d9140a80","granularity":"entry","granularity_label":"One unit = one catalog entry. A PROXY for the SCOPE.md §4 ladder, which governs source families, not entries: a family with 400 entries moves this reading 400 times as much as a family with one. Never compare or combine with the source_family reading.","level":"executable","level_index":4,"level_label":"Executable","meaning":"Queries run through Commodity","counts_as_coverage":true,"blocked_by":null,"rungs":[{"level":"discovered","level_index":1,"label":"Discovered","meaning":"Source and metadata recorded","evidence":"membership of the named population the ladder is taken over","counts_as_coverage":false,"met":true,"reached":true,"criterion":"TRUE"},{"level":"verified","level_index":2,"label":"Verified","meaning":"Access tested successfully","evidence":"entries.verification_state = 'VERIFIED'","counts_as_coverage":false,"met":true,"reached":true,"criterion":"entries.verification_state = 'VERIFIED'"},{"level":"profiled","level_index":3,"label":"Profiled","meaning":"Schema, dimensions and licence understood","evidence":"a data profile with at least one field (entry_data_profiles.field_count > 0)","counts_as_coverage":false,"met":true,"reached":true,"criterion":"EXISTS (SELECT 1 FROM entry_data_profiles p WHERE p.entry_id = entries.id AND COALESCE(p.field_count, 0) > 0)"},{"level":"executable","level_index":4,"label":"Executable","meaning":"Queries run through Commodity","evidence":"entries.capability_tier = 'live' — today's proxy for \"queryable through us\"","counts_as_coverage":true,"met":true,"reached":true,"criterion":"entries.capability_tier = 'live'"},{"level":"joinable","level_index":5,"label":"Joinable","meaning":"Canonical identifiers and concepts mapped","evidence":"a field link to a canonical identifier whose sampled VALUES match its format","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM entry_field_links efl WHERE efl.entry_id = entries.id AND efl.identifier_id IS NOT NULL AND efl.value_status = 'match')"},{"level":"reproducible","level_index":6,"label":"Reproducible","meaning":"Snapshots and transformation evidence retained","evidence":"at least one retained evidence manifest (migration 078)","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM evidence_manifests em WHERE em.entry_id = entries.id)"},{"level":"guaranteed","level_index":7,"label":"Guaranteed","meaning":"Monitored against an operational reliability target","evidence":"an active reliability target with a named monitor (migration 096)","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM entry_reliability_targets rt WHERE rt.entry_id = entries.id AND rt.is_active = true)"}],"officialness":{"basis":"catalog_inherited","label":"Inherited from the upstream catalog: this item came from a trusted official government catalog, and that provenance — not per-item proof — is the warrant. Its own proof score is below 80 or it matched no registered institution (apps/worker/src/connectors/catalog/qualify-store.ts).","proof_confidence":null,"proven_threshold":80,"institution_id":"7abf1844-58f2-4b35-a86e-1e4a6b7652f7","definition":"CASE WHEN COALESCE(entries.is_public_sector, false) IS NOT TRUE THEN 'not_official' WHEN COALESCE(entries.official_confidence, 0) >= 80 AND entries.institution_id IS NOT NULL THEN 'per_item_proven' ELSE 'catalog_inherited' END"},"source_family":{"key":"www.data.gouv.fr","label":"One unit = one source family, approximated by the serving host of the entry's primary source URL (e.g. bdl.stat.gov.pl). A COMPUTED stand-in for the curated families of SCOPE.md §5, which no table holds yet. A family sits at the highest level any of its entries has reached, because a family is integrated to the depth of its deepest working integration. Never compare or combine with the entry reading."},"generated_at":"2026-07-31T14:40:12.099Z"},"api_details":null,"dataset_details":{"id":"56f8a86d-0dca-4e93-9871-ae2d34a501e5","entry_id":"100a33c6-2fcb-41c4-af14-2094d9140a80","upstream_issued":"2025-11-21T14:07:19.000Z","upstream_modified":"2025-11-21T14:07:19.000Z","themes":[],"update_frequency":null,"temporal_start":null,"temporal_end":null,"spatial_coverage":null,"landing_page":"https://data.caf.fr/explore/dataset/dep_tr_nat/","license_id":"lo-2.0","license_raw":"https://www.etalab.gouv.fr/licence-ouverte-open-licence","has_documentation":true,"has_data_dictionary":false,"has_versioning":false,"source_portal":null,"source_portal_url":null,"created_at":"2026-07-30T13:43:04.049Z","updated_at":"2026-07-30T13:43:04.049Z","publisher":"Caisse nationale des Allocations familiales","publisher_url":null,"distributions":[{"id":"a7a526a8-11b8-4dbc-a77a-3d113777f030","dataset_details_id":"56f8a86d-0dca-4e93-9871-ae2d34a501e5","title":"dep_tr _nat.csv","description":null,"access_url":"https://www.data.gouv.fr/api/1/datasets/r/e436efca-e2b1-4424-bcaa-e7594f27b899","download_url":"https://data.caf.fr/api/explore/v2.1/catalog/datasets/dep_tr_nat/exports/csv?use_labels=true","media_type":null,"format":"CSV","byte_size":null,"license_id":"lo-2.0","license_raw":"https://www.etalab.gouv.fr/licence-ouverte-open-licence","last_checked_at":"2026-07-31T07:58:09.265Z","is_available":true,"last_http_status":200,"created_at":"2026-07-30T13:43:04.366Z","updated_at":"2026-07-31T07:58:09.265Z"},{"id":"5a340851-59c2-4bc1-86d4-70dc50679374","dataset_details_id":"56f8a86d-0dca-4e93-9871-ae2d34a501e5","title":"dep_tr _nat.json","description":null,"access_url":"https://www.data.gouv.fr/api/1/datasets/r/137adcd8-15ad-4f05-ba18-28f0f4fbf47f","download_url":"https://data.caf.fr/api/explore/v2.1/catalog/datasets/dep_tr_nat/exports/json","media_type":null,"format":"JSON","byte_size":null,"license_id":"lo-2.0","license_raw":"https://www.etalab.gouv.fr/licence-ouverte-open-licence","last_checked_at":null,"is_available":null,"last_http_status":null,"created_at":"2026-07-30T13:43:04.588Z","updated_at":"2026-07-30T13:43:04.588Z"}],"license":{"id":"lo-2.0","spdx_id":"etalab-2.0","name":"Licence Ouverte 2.0 (France / Etalab)","url":"https://www.etalab.gouv.fr/wp-content/uploads/2017/04/ETALAB-Licence-Ouverte-v2.0.pdf","is_open":true,"is_redistributable":true,"requires_attribution":true,"category":"national","notes":null,"created_at":"2026-06-12T16:29:19.729Z","commercial_use":true,"redistribution":true,"attribution_required":true,"share_alike":false,"personal_data_warning":true,"cache_and_mirror":true,"reuse_basis":"licence_text","reuse_source_text":"Texte de la licence - le reutilisateur est libre \"de la communiquer, la reproduire, la copier ; de l'adapter, la modifier, l'extraire et la transformer, notamment pour creer des Informations derivees ; de la diffuser, la redistribuer, la publier et la transmettre, de l'exploiter a titre commercial\". Seule obligation : \"mentionner la paternite de l'Information : sa source (a minima le nom du Concedant) et la date de la derniere mise a jour\". Le texte rappelle que le reutilisateur doit respecter \"le cadre legal relatif a la protection des donnees a caractere personnel\". Aucune clause de partage a l'identique n'est imposee.","reuse_source_url":"https://github.com/etalab/licence-ouverte/blob/master/LO.md","reuse_reviewed_at":null,"reuse_confidence":"0.95"}},"license":{"id":"lo-2.0","spdx_id":"etalab-2.0","name":"Licence Ouverte 2.0 (France / Etalab)","url":"https://www.etalab.gouv.fr/wp-content/uploads/2017/04/ETALAB-Licence-Ouverte-v2.0.pdf","is_open":true,"is_redistributable":true,"requires_attribution":true,"category":"national","notes":null,"created_at":"2026-06-12T16:29:19.729Z","commercial_use":true,"redistribution":true,"attribution_required":true,"share_alike":false,"personal_data_warning":true,"cache_and_mirror":true,"reuse_basis":"licence_text","reuse_source_text":"Texte de la licence - le reutilisateur est libre \"de la communiquer, la reproduire, la copier ; de l'adapter, la modifier, l'extraire et la transformer, notamment pour creer des Informations derivees ; de la diffuser, la redistribuer, la publier et la transmettre, de l'exploiter a titre commercial\". Seule obligation : \"mentionner la paternite de l'Information : sa source (a minima le nom du Concedant) et la date de la derniere mise a jour\". Le texte rappelle que le reutilisateur doit respecter \"le cadre legal relatif a la protection des donnees a caractere personnel\". Aucune clause de partage a l'identique n'est imposee.","reuse_source_url":"https://github.com/etalab/licence-ouverte/blob/master/LO.md","reuse_reviewed_at":null,"reuse_confidence":"0.95"},"license_raw":"https://www.etalab.gouv.fr/licence-ouverte-open-licence","latest_check":{"id":"c41d78ff-b013-47b8-b3aa-9108bda8c1b3","entry_id":"100a33c6-2fcb-41c4-af14-2094d9140a80","status":"VERIFIED","last_checked_at":"2026-07-30T13:50:08.658Z","p50_latency_ms":1488,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-30T13:50:08.658Z","updated_at":"2026-07-30T13:50:08.658Z","consecutive_successes":1,"probe_url":"https://data.caf.fr/api/explore/v2.1/catalog/datasets/dep_tr_nat/exports/csv?use_labels=true","probe_method":"GET","probe_http_status":200,"probe_content_type":"text/csv; charset=utf-8","probe_succeeded_at":"2026-07-30T13:50:08.658Z"},"data_profile":{"id":"81766f60-1281-42b0-9f87-956dcdf3cc59","entry_id":"100a33c6-2fcb-41c4-af14-2094d9140a80","profile_source":"distribution","profile_kind":"dataset","dataset_id":null,"fields":[{"name":"2024","type":"int","label":null,"description":null},{"name":"Total prestations légales enfance et jeunesse (AF, CF, ARS, ASF, AEH, AJPP)","type":"text","label":null,"description":null},{"name":"22409.71848","type":"number","label":null,"description":null},{"name":"21792.66387","type":"number","label":null,"description":null},{"name":"1203.038607","type":"number","label":null,"description":null},{"name":"1203.038607","type":"number","label":null,"description":null},{"name":"23612.75709","type":"number","label":null,"description":null},{"name":"22995.70248","type":"number","label":null,"description":null}],"field_count":8,"sample_records":[{"2024":"2024","1203.038607":"346.2661655","21792.66387":"2881.566167","22409.71848":"2918.432414","22995.70248":"3227.832333","23612.75709":"3264.69858","Total prestations légales enfance et jeunesse (AF, CF, ARS, ASF, AEH, AJPP)":"Allocation de soutien familial (ASF)"},{"2024":"2024","1203.038607":"336.696586","21792.66387":"10829.04021","22409.71848":"11227.23904","22995.70248":"11165.7368","23612.75709":"11563.93562","Total prestations légales enfance et jeunesse (AF, CF, ARS, ASF, AEH, AJPP)":"Total Prestation d'accueil du jeune enfant (PAJE)"},{"2024":"2024","1203.038607":"1.19347627","21792.66387":"171.6984884","22409.71848":"178.9486048","22995.70248":"172.8919646","23612.75709":"180.1420811","Total prestations légales enfance et jeunesse (AF, CF, ARS, ASF, AEH, AJPP)":"PAJE CLCA PrePareE rang 2 et plus Taux partiel"},{"2024":"2024","1203.038607":"0.00217411","21792.66387":"0.3294642","22409.71848":"0.35852003","22995.70248":"0.33163831","23612.75709":"0.36069414","Total prestations légales enfance et jeunesse (AF, CF, ARS, ASF, AEH, AJPP)":"PAJE CLCA PrePareE adoption Taux plein"},{"2024":"2024","1203.038607":"0.002021","21792.66387":"0.15093119","22409.71848":"0.15464274","22995.70248":"0.15295219","23612.75709":"0.15666374","Total prestations légales enfance et jeunesse (AF, CF, ARS, ASF, AEH, AJPP)":"PAJE CLCA PrePareE adoption Taux partiel"}],"record_count":null,"data_size_bytes":"139779","dataset_count":null,"query_examples":[{"url":"https://data.caf.fr/api/explore/v2.1/catalog/datasets/dep_tr_nat/exports/csv?use_labels=true","curl":"curl -sL 'https://data.caf.fr/api/explore/v2.1/catalog/datasets/dep_tr_nat/exports/csv?use_labels=true' -o data.csv","label":"Download distribution","method":"GET","description":"Full csv file download — the schema shown was inferred from the file's first records."},{"url":"https://data.caf.fr/api/explore/v2.1/catalog/datasets/dep_tr_nat/exports/csv?use_labels=true","curl":"curl -sL 'https://data.caf.fr/api/explore/v2.1/catalog/datasets/dep_tr_nat/exports/csv?use_labels=true' -H 'Range: bytes=0-4095'","label":"Preview first bytes","method":"GET","description":"First 4 KB of the file (servers honoring Range requests)."}],"status":"ok","error_message":null,"profiled_at":"2026-07-30T13:46:15.840Z","run_id":"c0e4fa65-8b93-4b67-8e87-f893baaec0b6","created_at":"2026-07-30T13:46:15.840Z","updated_at":"2026-07-30T13:46:15.840Z","license_raw":null,"license_id":null,"consecutive_failure_count":0,"last_error_at":null,"last_error_message":null,"previewable":true},"datasets":[],"limits":[]}