{"id":"4d908a61-9e1b-466f-88b4-9943db058c1e","type":"API","name":"Salaires dans la fonction publique par catégorie socioprofessionnelle détaillée","slug":"salaires-dans-la-fonction-publique-par-categorie-socioprofessionnelle-detaillee","description":"Salaire net en équivalent temps plein dans la fonction public ventilé par profession et selon plusieurs variables (sexe, âge, secteur...), pour la France hors Mayotte.","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":"https://catalogue-donnees.insee.fr/fr/catalogue/recherche/DS_DERA_PUBLIC_ANNUEL","docs_url":"https://catalogue-donnees.insee.fr/fr/catalogue/recherche/DS_DERA_PUBLIC_ANNUEL","repo_url":null,"status":"ACTIVE","verification_state":"VERIFIED","tags":[],"logo_url":"https://catalogue-donnees.insee.fr/favicon.svg","primary_source_url":"https://catalogue-donnees.insee.fr/fr/catalogue/recherche/DS_DERA_PUBLIC_ANNUEL","extraction_confidence":"0.40","created_at":"2026-07-21T22:34:24.149Z","updated_at":"2026-09-04T04:56:00.110Z","last_verified_at":"2026-09-04T04:56:00.110Z","deprecated_at":null,"ranking_score":52,"last_ranked_at":"2026-08-24T23:51:12.370Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-09-02T11:24:37.714Z","search_vector":"'age':62B 'categorie':41A 'catégori':7A 'dan':2A,16B 'dans':36A,50B 'detaillee':43A 'détaillé':9A 'en':12B,46B 'equivalent':47B 'et':23B,57B 'fonction':4A,18B,38A,52B 'franc':32B 'france':66B 'hor':33B 'hors':67B 'la':3A,17B,31B,37A,51B,65B 'mayott':34B 'mayotte':68B 'net':11B,45B 'par':6A,21B,40A,55B 'plein':15B,49B 'plusieur':25B 'plusieurs':59B 'pour':30B,64B 'profess':22B 'profession':56B 'public':19B,53B 'publiqu':5A 'publique':39A 'salair':1A,10B 'salaire':44B 'salaires':35A 'secteur':29B,63B 'selon':24B,58B 'sex':27B 'sexe':61B 'socioprofessionnell':8A 'socioprofessionnelle':42A 'temp':14B 'temps':48B 'variabl':26B 'variables':60B 'ventile':54B 'ventilé':20B 'âge':28B 'équival':13B","popularity_score":"0.0000","maintenance_score":"0.7000","institution_id":"7e8c524c-d2f0-4000-9e63-e91795edd443","institution_type":"STATISTICS_OFFICE","country_code":"FR","official_confidence":40,"proof_summary":"40% - Official domain (insee.fr)","source_seed_url":null,"is_public_sector":true,"published_at":"2026-07-22T08:25:45.910Z","geographic_scope":"NATIONAL","name_en":null,"description_en":null,"native_lang":null,"access_level":"direct","formats":[],"capability_tier":"live","trust_score":58.25,"merged_into_entry_id":null,"identity_key":"API|https://catalogue-donnees.insee.fr/fr/catalogue/recherche/DS_DERA_PUBLIC_ANNUEL|salaires dans la fonction publique par catégorie socioprofessionnelle détaillée","upstream_ref":"catalogue-donnees.insee.fr:dataset:DS_DERA_PUBLIC_ANNUEL","access":{"level":"direct","primary":{"kind":"query","label":"List observations","method":"GET","url":"https://api.insee.fr/melodi/data/DS_DERA_PUBLIC_ANNUEL?maxResult=20","source":"query_example","runnable":true,"direct":true},"actions":[{"kind":"query","label":"List observations","method":"GET","url":"https://api.insee.fr/melodi/data/DS_DERA_PUBLIC_ANNUEL?maxResult=20","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"Filter by dimension","method":"GET","url":"https://api.insee.fr/melodi/data/DS_DERA_PUBLIC_ANNUEL?GEO=COM-75056&maxResult=20","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"Run verified request","method":"GET","url":"https://api.insee.fr/melodi/data/DS_DERA_PUBLIC_ANNUEL","source":"probe","runnable":true},{"kind":"landing","label":"Read the docs","method":"GET","url":"https://catalogue-donnees.insee.fr/fr/catalogue/recherche/DS_DERA_PUBLIC_ANNUEL","source":"docs","runnable":false}],"formats":[]},"maturity":{"entry_id":"4d908a61-9e1b-466f-88b4-9943db058c1e","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":40,"proven_threshold":80,"institution_id":"7e8c524c-d2f0-4000-9e63-e91795edd443","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":"catalogue-donnees.insee.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-09-05T01:29:24.024Z"},"api_details":{"id":"ddf1220e-585a-412f-8d8b-241fe4541cff","entry_id":"4d908a61-9e1b-466f-88b4-9943db058c1e","base_url":"https://api.insee.fr/melodi/data/DS_DERA_PUBLIC_ANNUEL","openapi_url":null,"graphql_url":null,"api_version":null,"spec_format":null,"endpoints_count":null,"endpoints":[],"rate_limit_info":null,"free_tier_limits":null,"ping_url":"https://api.insee.fr/melodi/data/DS_DERA_PUBLIC_ANNUEL","created_at":"2026-07-21T22:34:24.303Z","updated_at":"2026-07-21T22:34:24.303Z"},"dataset_details":null,"license":null,"reuse":{"license_id":null,"license_name":null,"license_url":null,"commercial_use":{"status":"unknown","value":null},"redistribution":{"status":"unknown","value":null},"attribution_required":{"status":"unknown","value":null},"share_alike":{"status":"unknown","value":null},"personal_data_warning":{"status":"unknown","value":null},"cache_and_mirror":{"status":"unknown","value":null},"undetermined":["commercial_use","redistribution","attribution_required","share_alike","personal_data_warning","cache_and_mirror"],"basis":"unverified","confidence":0.1,"confidence_tier":"low","source_text":null,"source_url":null,"reviewed_at":null},"license_raw":null,"latest_check":{"id":"e345da7d-7013-4f5b-9d3d-d7013c9d94ae","entry_id":"4d908a61-9e1b-466f-88b4-9943db058c1e","status":"VERIFIED","last_checked_at":"2026-09-04T04:55:59.785Z","p50_latency_ms":1733,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-22T09:32:26.536Z","updated_at":"2026-09-04T04:55:59.785Z","consecutive_successes":31,"probe_url":"https://api.insee.fr/melodi/data/DS_DERA_PUBLIC_ANNUEL","probe_method":"GET","probe_http_status":200,"probe_content_type":"application/json","probe_succeeded_at":"2026-09-04T04:55:59.785Z"},"data_profile":{"id":"fe74ae3f-1c1c-4d78-94e5-41741a350f81","entry_id":"4d908a61-9e1b-466f-88b4-9943db058c1e","profile_source":"melodi","profile_kind":"dataset","dataset_id":null,"fields":[{"name":"GEO","type":"string","label":null,"description":null},{"name":"QUANTILE","type":"string","label":null,"description":null},{"name":"SEX","type":"string","label":null,"description":null},{"name":"CIVILSERVANT_STATUS","type":"string","label":null,"description":null},{"name":"FREQ","type":"string","label":null,"description":null},{"name":"PUBLIC_LEGAL_FORM","type":"string","label":null,"description":null},{"name":"TIME_PERIOD","type":"string","label":null,"description":null},{"name":"UNIT_MEASURE","type":"string","label":null,"description":null},{"name":"WKTIME","type":"string","label":null,"description":null},{"name":"DERA_MEASURE","type":"string","label":null,"description":null},{"name":"PCS_ESE","type":"string","label":null,"description":null},{"name":"AGE","type":"string","label":null,"description":null},{"name":"OBS_VALUE_NIVEAU","type":"number","label":null,"description":null}],"field_count":13,"sample_records":[{"AGE":"_T","GEO":"2025-FRANCE-F","SEX":"F","FREQ":"A","WKTIME":"_T","PCS_ESE":"311D","QUANTILE":"_T","TIME_PERIOD":"2023","DERA_MEASURE":"SALAIRE_NET_EQTP_MENSUEL_MOYENNE","UNIT_MEASURE":"XDC","OBS_VALUE_NIVEAU":2615.937,"PUBLIC_LEGAL_FORM":"_T","CIVILSERVANT_STATUS":"_T"},{"AGE":"Y40T49","GEO":"2025-FRANCE-F","SEX":"_T","FREQ":"A","WKTIME":"_T","PCS_ESE":"431F","QUANTILE":"_T","TIME_PERIOD":"2023","DERA_MEASURE":"EFFECTIFS_EQTP","UNIT_MEASURE":"FT","OBS_VALUE_NIVEAU":58144.576,"PUBLIC_LEGAL_FORM":"_T","CIVILSERVANT_STATUS":"_T"},{"AGE":"Y_UNK","GEO":"2025-FRANCE-F","SEX":"_T","FREQ":"A","WKTIME":"_T","PCS_ESE":"432D","QUANTILE":"_T","TIME_PERIOD":"2023","DERA_MEASURE":"EFFECTIFS_EQTP","UNIT_MEASURE":"FT","OBS_VALUE_NIVEAU":3250.596,"PUBLIC_LEGAL_FORM":"_T","CIVILSERVANT_STATUS":"_T"},{"AGE":"Y40T49","GEO":"2025-FRANCE-F","SEX":"M","FREQ":"A","WKTIME":"PT","PCS_ESE":"_T","QUANTILE":"_T","TIME_PERIOD":"2023","DERA_MEASURE":"SALAIRE_NET_EQTP_MENSUEL_MOYENNE","UNIT_MEASURE":"XDC","OBS_VALUE_NIVEAU":2525.398,"PUBLIC_LEGAL_FORM":"3","CIVILSERVANT_STATUS":"NT"},{"AGE":"Y_GE60","GEO":"2025-FRANCE-F","SEX":"_T","FREQ":"A","WKTIME":"_T","PCS_ESE":"_T","QUANTILE":"_T","TIME_PERIOD":"2023","DERA_MEASURE":"EFFECTIFS_EQTP","UNIT_MEASURE":"FT","OBS_VALUE_NIVEAU":79483.379,"PUBLIC_LEGAL_FORM":"_T","CIVILSERVANT_STATUS":"NT"}],"record_count":null,"data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://api.insee.fr/melodi/data/DS_DERA_PUBLIC_ANNUEL?maxResult=20","curl":"curl -s 'https://api.insee.fr/melodi/data/DS_DERA_PUBLIC_ANNUEL?maxResult=20' -H 'Accept: application/json'","label":"List observations","method":"GET","description":"First 20 observations (dimensions + measures) as JSON."},{"url":"https://api.insee.fr/melodi/data/DS_DERA_PUBLIC_ANNUEL?GEO=COM-75056&maxResult=20","curl":"curl -s 'https://api.insee.fr/melodi/data/DS_DERA_PUBLIC_ANNUEL?GEO=COM-75056&maxResult=20' -H 'Accept: application/json'","label":"Filter by dimension","method":"GET","description":"Server-side dimension filter — e.g. GEO=COM-75056 scopes to a commune (also DEP-…, REG-…, TIME_PERIOD=…)."}],"status":"ok","error_message":null,"profiled_at":"2026-09-01T08:33:10.666Z","run_id":"f2b6112f-1339-47fa-bdc6-a99f20a814ce","created_at":"2026-07-21T22:34:43.391Z","updated_at":"2026-09-01T08:33:10.666Z","license_raw":null,"license_id":null,"consecutive_failure_count":0,"last_error_at":null,"last_error_message":null,"previewable":true,"personal_data":{"status":"none","basis":"no_person_column_cited","grain":"none","allowed":true,"columns":{"direct_identifiers":[],"family_names":[],"given_names":[],"attributes":[],"unresolved_names":[],"measures":["OBS_VALUE_NIVEAU"],"entity_identifiers":[]},"publication":null,"publication_evidence":null,"notice":"personal data: no cited column names a natural person (the cited columns are all this reads)"}},"datasets":[],"limits":[],"manifest":{"answer_sha256":"5d7929d9b58ce9a067217c2455618eff1a7aeed9c50dd7d898c367eba73776d2","answer_sha256_rule":"sha256 (hex, UTF-8) of JSON.stringify(this body) after deleting the keys listed in manifest.stamped_keys from manifest, and deleting manifest itself if it is then empty. The hash was computed before the stamp existed, so no field of the stamp is inside it.","stamped_keys":["answer_sha256","answer_sha256_rule","stamped_keys","row_count","row_count_basis","live","live_basis","created_at","created_at_basis","durable_citation"],"row_count":31,"row_count_basis":"Objects that are elements of a JSON array anywhere in this body, excluding manifest. Not a claim about which collection is the answer. Largest single collection: data_profile.fields[] (13 rows).","live":false,"live_basis":"This body was replayed from the worker edge cache (x-edge-cache: hit); the bytes, and therefore answer_sha256, are those of the execution that filled the cache.","created_at":"2026-09-05T01:29:25.097Z","created_at_basis":"When this response body was assembled, deliberately OUTSIDE the hashed bytes so the same answer hashes identically on every request. Not the upstream read time — that is provenance[].retrieved_at. A zone-cached replay carries the assembly time, not your receipt time.","durable_citation":"This manifest is produced at response time and is NOT stored. A durable, replayable citation is persisted only on an explicit cite: GET /api/v1/entries/{id-or-slug}/evidence, or the MCP cite_query tool. Both are entry-scoped, because evidence_manifests is entry-shaped; a domain answer spanning several sources has no single entry and cannot be persisted through that path."}}