{"id":"a57efd8f-211b-4c70-9bbb-d8a0e498d9b1","type":"API","name":"Nombre d'établissements et effectifs salariés en 38 grands secteurs","slug":"nombre-detablissements-et-effectifs-salaries-en-38-grands-secteurs","description":"Nombre d'établissements et effectifs salariés par secteur d'activité et tranche d'effectifs au niveau communal et supracommunal pour la France.","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":"https://catalogue-donnees.insee.fr/fr/catalogue/recherche/DS_FLORES_A38","docs_url":"https://catalogue-donnees.insee.fr/fr/catalogue/recherche/DS_FLORES_A38","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_FLORES_A38","extraction_confidence":"0.40","created_at":"2026-07-21T22:35:20.558Z","updated_at":"2026-09-03T23:10:23.970Z","last_verified_at":"2026-09-03T23:10:23.970Z","deprecated_at":null,"ranking_score":35,"last_ranked_at":"2026-08-24T23:49:43.263Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-09-02T13:32:23.928Z","search_vector":"'38':8A,18A,64B,117A,127A,173B 'across':17A,88B,126A,197B 'activ':68B 'activite':139B 'activity':177B 'activité':30B 'aggreg':85B 'aggregations':194B 'analysi':97B 'analysis':206B 'and':123A,167B,178B,192B,211B,216B 'api':44B,153B 'are':185B 'at':187B 'au':35B,144B 'avail':77B 'available':186B 'bracket':74B,183B 'broken':61B,170B 'busi':100B 'business':209B 'by':155B,172B,179B,214B 'communal':37B,81B,146B,190B 'd':2A,22B,29B,33B,111A,131B,138B,142B 'data':75B,184B 'distribut':104B 'distribution':213B 'down':171B 'effectif':5A,25B,34B 'effectifs':114A,134B,143B 'employ':103B 'employe':16A,60B 'employees':125A,169B 'employment':212B 'en':7A,116A 'establish':13A,57B,108B 'establishment':217B 'establishments':122A,166B 'et':4A,24B,31B,38B,113A,133B,140B,147B 'etablissements':112A,132B 'for':193B,202B 'franc':42B,89B 'france':151B,198B 'french':49B,158B 'grand':9A 'grands':118A 'inse':47B 'insee':156B 'institut':52B 'institute':161B 'intend':92B 'intended':201B 'is':200B 'it':199B 'la':41B,150B 'level':82B,191B 'local':99B,208B 'major':19A,65B,128A,174B 'municip':80B,87B 'municipal':189B 'municipalities':196B 'nation':50B,95B 'national':159B,204B 'national-scop':94B 'national-scope':203B 'niveau':36B,145B 'nombr':1A,21B 'nombre':110A,130B 'number':11A,55B,120A,164B 'of':121A,165B,176B,195B,207B 'par':27B,136B 'pour':40B,149B 'provid':53B 'provides':162B 'publish':45B 'published':154B 'salari':15A,59B 'salaried':124A,168B 'salaries':115A,135B 'salarié':6A,26B 'scope':96B,205B 'secteur':10A,28B,137B 'secteurs':119A 'sector':20A,66B,106B,215B 'sectors':129A,175B 'size':73B,109B,182B,218B 'staff':72B,181B 'staff-siz':71B 'staff-size':180B 'statist':51B 'statistics':160B 'structur':101B 'structure':210B 'supracommun':39B 'supracommunal':148B 'the':157B,163B,188B 'this':152B 'tranch':32B 'tranche':141B 'établiss':3A,23B","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-22T18:02:34.160Z","geographic_scope":"NATIONAL","name_en":"Number of establishments and salaried employees across 38 major sectors","description_en":"This API published by INSEE, the French national statistics institute, provides the number of establishments and salaried employees broken down by 38 major sectors of activity and by staff-size bracket. Data are available at the municipal (communal) level and for aggregations of municipalities across France. It is intended for national-scope analysis of local business structure and employment distribution by sector and establishment size.","native_lang":"fr","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_FLORES_A38|nombre d'établissements et effectifs salariés en 38 grands secteurs","upstream_ref":"catalogue-donnees.insee.fr:dataset:DS_FLORES_A38","access":{"level":"direct","primary":{"kind":"query","label":"List observations","method":"GET","url":"https://api.insee.fr/melodi/data/DS_FLORES_A38?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_FLORES_A38?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_FLORES_A38?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_FLORES_A38","source":"probe","runnable":true},{"kind":"landing","label":"Read the docs","method":"GET","url":"https://catalogue-donnees.insee.fr/fr/catalogue/recherche/DS_FLORES_A38","source":"docs","runnable":false}],"formats":[]},"maturity":{"entry_id":"a57efd8f-211b-4c70-9bbb-d8a0e498d9b1","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:30:05.035Z"},"api_details":{"id":"d91e3b19-3b6d-4b26-9d9e-3381a7a8fd8b","entry_id":"a57efd8f-211b-4c70-9bbb-d8a0e498d9b1","base_url":"https://api.insee.fr/melodi/data/DS_FLORES_A38","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_FLORES_A38","created_at":"2026-07-21T22:35:20.710Z","updated_at":"2026-07-21T22:35:20.710Z"},"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":"471a5d84-5c38-495b-822f-b19d7c377b01","entry_id":"a57efd8f-211b-4c70-9bbb-d8a0e498d9b1","status":"VERIFIED","last_checked_at":"2026-09-03T23:10:23.645Z","p50_latency_ms":1131,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-22T03:53:22.467Z","updated_at":"2026-09-03T23:10:23.645Z","consecutive_successes":4,"probe_url":"https://api.insee.fr/melodi/data/DS_FLORES_A38","probe_method":"GET","probe_http_status":200,"probe_content_type":"application/json","probe_succeeded_at":"2026-09-03T23:10:23.645Z"},"data_profile":{"id":"cc8b5485-5efa-46a2-afda-ff53ed8fd100","entry_id":"a57efd8f-211b-4c70-9bbb-d8a0e498d9b1","profile_source":"melodi","profile_kind":"dataset","dataset_id":null,"fields":[{"name":"GEO","type":"string","label":null,"concept":"http://rdf.insee.fr/def/geo#codeCommune","description":null},{"name":"NUMBER_EMPL","type":"string","label":null,"description":null},{"name":"FLORES_MEASURE","type":"string","label":null,"description":null},{"name":"FREQ","type":"string","label":null,"description":null},{"name":"LEGAL_FORM_WITH_PUBLIC","type":"string","label":null,"description":null},{"name":"TIME_PERIOD","type":"string","label":null,"description":null},{"name":"ACTIVITY","type":"string","label":null,"description":null},{"name":"OBS_VALUE_NIVEAU","type":"number","label":null,"description":null}],"field_count":8,"sample_records":[{"GEO":"2026-AAV2020-001","FREQ":"A","ACTIVITY":"AZ","NUMBER_EMPL":"E0","TIME_PERIOD":"2024","FLORES_MEASURE":"UNIT_LOC","OBS_VALUE_NIVEAU":535,"LEGAL_FORM_WITH_PUBLIC":"1T9X7"},{"GEO":"2026-AAV2020-001","FREQ":"A","ACTIVITY":"AZ","NUMBER_EMPL":"E100T199","TIME_PERIOD":"2024","FLORES_MEASURE":"EMPL3112","OBS_VALUE_NIVEAU":104,"LEGAL_FORM_WITH_PUBLIC":"1T9X7"},{"GEO":"2026-AAV2020-001","FREQ":"A","ACTIVITY":"AZ","NUMBER_EMPL":"E100T199","TIME_PERIOD":"2024","FLORES_MEASURE":"UNIT_LOC","OBS_VALUE_NIVEAU":1,"LEGAL_FORM_WITH_PUBLIC":"1T9X7"},{"GEO":"2026-AAV2020-001","FREQ":"A","ACTIVITY":"AZ","NUMBER_EMPL":"E10T19","TIME_PERIOD":"2024","FLORES_MEASURE":"EMPL3112","OBS_VALUE_NIVEAU":971,"LEGAL_FORM_WITH_PUBLIC":"1T9X7"},{"GEO":"2026-AAV2020-001","FREQ":"A","ACTIVITY":"AZ","NUMBER_EMPL":"E10T19","TIME_PERIOD":"2024","FLORES_MEASURE":"UNIT_LOC","OBS_VALUE_NIVEAU":76,"LEGAL_FORM_WITH_PUBLIC":"1T9X7"}],"record_count":null,"data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://api.insee.fr/melodi/data/DS_FLORES_A38?maxResult=20","curl":"curl -s 'https://api.insee.fr/melodi/data/DS_FLORES_A38?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_FLORES_A38?GEO=COM-75056&maxResult=20","curl":"curl -s 'https://api.insee.fr/melodi/data/DS_FLORES_A38?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-01T01:27:29.383Z","run_id":"9a7cae0b-d016-4770-a4ab-c2c14572143f","created_at":"2026-07-21T22:50:48.333Z","updated_at":"2026-09-01T01:27:29.383Z","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":"d0f35e7c491bad2cc9bbda0e8cbee5bd898104caa80ee341acd9a2d052d72308","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":26,"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[] (8 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:30:25.741Z","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."}}