{"id":"aec02673-db6d-408b-ac8f-8c51fe22a5cb","type":"DATASET","name":"European Central Bank — Securities (SEC)","slug":"ecb-securities-sec","description":"Securities (SEC) — official time series from the European Central Bank Data Portal, published as the SEC dataflow over SDMX 2.1 REST. One endpoint serves XML (SDMX-ML), CSV (?format=csvdata) and JSON (?format=jsondata); extract exactly the series you need with a key path and startPeriod / endPeriod / lastNObservations filters. Browse and chart the same series on the ECB Data Portal.","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":"https://data.ecb.europa.eu/data/datasets/SEC","docs_url":"https://data.ecb.europa.eu/help/api/overview","repo_url":null,"status":"ACTIVE","verification_state":"VERIFIED","tags":["economy","prices"],"logo_url":"https://data.ecb.europa.eu/themes/custom/edp/favicon.ico","primary_source_url":"https://data-api.ecb.europa.eu/service/data/SEC/all?lastNObservations=1&format=jsondata","extraction_confidence":"0.95","created_at":"2026-07-18T21:24:13.797Z","updated_at":"2026-10-16T15:53:25.411Z","last_verified_at":"2026-10-16T15:53:25.411Z","deprecated_at":null,"ranking_score":61,"last_ranked_at":"2026-10-07T00:40:02.832Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":null,"search_vector":"'2.1':25B,108B,182B,265B 'a':205B,227B,269B,287B 'across':94B,251B 'also':144B,301B 'and':194B,208B,214B,249B,278B,304B 'api':110B,267B 'are':256B 'area':97B,254B 'as':176B,235B,258B 'bank':3A,15B,77B,160A,172B,234B 'be':302B 'brows':56B,146B 'browse':213B 'browsed':303B 'by':230B 'can':282B,300B 'central':2A,14B,76B,159A,171B,233B 'chart':58B,148B,215B 'charted':305B 'csv':34B,120B,191B,277B 'csvdata':36B,193B 'data':16B,65B,82B,98B,153B,173B,222B,239B,255B,310B 'dataflow':22B,104B,179B,261B 'dataset':71B,228B 'distribut':100B 'distributed':257B 'ecb':64B,152B,221B,309B 'economi':156C 'endperiod':53B,136B,210B,293B 'endpoint':28B,114B,185B,271B 'euro':96B,253B 'european':1A,13B,75B,158A,170B,232B 'exact':42B 'exactly':199B 'extract':41B,126B,198B,283B 'filter':55B,139B 'filters':212B,296B 'format':35B,39B,123B,192B,196B 'formats':280B 'from':168B 'hold':93B 'holdings':250B 'interact':149B 'interactively':306B 'is':226B 'issuanc':91B 'issuance':248B 'its':238B 'json':38B,122B,195B,279B 'jsondata':40B,197B 'key':49B,131B,206B,288B 'lastnobserv':54B,138B 'lastnobservations':211B,295B 'ml':33B,119B,190B,276B 'need':46B,203B 'of':237B 'offici':8B,85B 'official':165B,242B 'on':219B,246B 'one':27B,184B 'or':294B 'over':180B 'part':79B,236B 'path':50B,132B,207B,289B 'portal':17B,66B,83B,154B,174B,223B,240B,311B 'price':157C 'provid':84B 'providing':241B 'publish':18B,72B 'published':175B,229B 'rest':26B,109B,183B,266B 'same':217B,298B 'sdmx':24B,32B,107B,118B,181B,189B,264B,275B 'sdmx-ml':31B,117B,188B,274B 'sec':5A,7B,21B,68B,103B,162A,164B,178B,225B,260B 'secur':4A,6B,67B,90B 'securities':161A,163B,224B,247B 'seri':10B,44B,61B,87B,128B,142B 'series':167B,201B,218B,244B,285B,299B 'serv':29B,115B 'serves':186B 'serving':272B 'singl':113B 'single':270B 'specif':127B 'specific':284B 'startperiod':52B,135B,209B,292B 'statist':88B 'statistics':245B 'the':169B,177B,200B,216B,220B,231B,252B,259B,263B,297B,308B 'through':307B 'time':9B,86B,166B,243B 'togeth':133B 'together':290B 'use':129B 'user':124B 'users':281B 'using':286B 'via':105B,262B 'websit':155B 'website':312B 'with':204B,268B,291B 'xml':30B,116B,187B,273B 'you':202B","popularity_score":"0.0000","maintenance_score":"0.7000","institution_id":"eab3ebe3-a519-43d8-a676-4192af61f357","institution_type":"REGULATOR","country_code":"EU","official_confidence":95,"proof_summary":"Official ECB Data Portal dataflow SEC, promoted from the endpoint-verified portal entry","source_seed_url":null,"is_public_sector":true,"published_at":"2026-07-18T21:24:13.797Z","geographic_scope":"EUROPEAN","name_en":null,"description_en":"Securities (SEC) is a dataset published by the European Central Bank as part of its Data Portal, providing official time series statistics on securities issuance and holdings across the euro area. Data are distributed as the SEC dataflow via the SDMX 2.1 REST API, with a single endpoint serving XML (SDMX-ML), CSV, and JSON formats. Users can extract specific series using a key path together with startPeriod, endPeriod, or lastNObservations filters. The same series can also be browsed and charted interactively through the ECB Data Portal website.","native_lang":"en","access_level":"direct","formats":[],"capability_tier":"live","trust_score":76.25,"merged_into_entry_id":null,"identity_key":"DATASET|https://data-api.ecb.europa.eu/service/data/SEC/all?format=jsondata&lastNObservations=1|european central bank — securities (sec)","upstream_ref":null,"content_changed_at":null,"title_qualifier":null,"access":{"level":"direct","primary":{"kind":"query","label":"List dataflows","method":"GET","url":"https://data-api.ecb.europa.eu/service/dataflow/ECB","source":"query_example","runnable":true,"direct":true},"actions":[{"kind":"query","label":"List dataflows","method":"GET","url":"https://data-api.ecb.europa.eu/service/dataflow/ECB","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"Run verified request","method":"GET","url":"https://data.ecb.europa.eu/data/datasets/SEC","source":"probe","runnable":true},{"kind":"query","label":"Dataflow structure","method":"GET","url":"https://data-api.ecb.europa.eu/service/dataflow/ECB/SEC?references=all","source":"query_example","runnable":true,"direct":false},{"kind":"query","label":"Fetch observations (JSON)","method":"GET","url":"https://data-api.ecb.europa.eu/service/data/SEC/all?lastNObservations=5&format=jsondata","source":"query_example","runnable":true,"direct":false},{"kind":"landing","label":"Read the docs","method":"GET","url":"https://data.ecb.europa.eu/help/api/overview","source":"docs","runnable":false},{"kind":"landing","label":"Open source record","method":"GET","url":"https://data-api.ecb.europa.eu/service/data/SEC/all?lastNObservations=1&format=jsondata","source":"primary_source","runnable":false}],"formats":[]},"maturity":{"entry_id":"aec02673-db6d-408b-ac8f-8c51fe22a5cb","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":"per_item_proven","label":"Proven for this item: its own proof signals scored >= 80 AND it matched a registered public institution, so it would have been APPROVED on its own evidence.","proof_confidence":95,"proven_threshold":80,"institution_id":"eab3ebe3-a519-43d8-a676-4192af61f357","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":"data-api.ecb.europa.eu","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-10-17T05:53:49.085Z"},"api_details":null,"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":"85630e69-7c13-4069-a3cb-270457f030a8","entry_id":"aec02673-db6d-408b-ac8f-8c51fe22a5cb","status":"VERIFIED","last_checked_at":"2026-10-16T15:53:25.276Z","p50_latency_ms":4130,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-18T21:41:30.017Z","updated_at":"2026-10-16T15:53:25.276Z","consecutive_successes":95,"probe_url":"https://data.ecb.europa.eu/data/datasets/SEC","probe_method":"GET","probe_http_status":200,"probe_content_type":"text/html; charset=UTF-8","probe_succeeded_at":"2026-10-16T15:53:25.276Z"},"data_profile":{"id":"60335126-fa1e-4543-af28-627c06b0df25","entry_id":"aec02673-db6d-408b-ac8f-8c51fe22a5cb","profile_source":"sdmx","profile_kind":"dataset","dataset_id":"SEC","fields":[{"name":"FREQ","role":"parameter","type":"dimension","label":"Frequency","param_in":"path","required":true,"filterable":true,"description":"2 codes (e.g. Monthly, Annual)","enum_values":["M","A"],"description_en":"Time frequency of the observation, such as monthly or annual."},{"name":"REF_AREA","role":"parameter","type":"dimension","label":"Reference area","param_in":"path","required":true,"filterable":true,"description":"33 codes (e.g. Lithuania, Italy, Luxembourg)","enum_values":["LT","IT","LU","LV","MT","PT","EE","ES","SI","U2","SK","CY","DE","IE","NL","GR","FR","FI","A1","BG","GB","V3","V5","SE","RO","PL","HR","HU","BE","CZ","DK","AT","I8"],"description_en":"Country or reference area covered by the data."},{"name":"SEC_ISSUING_SECTOR","role":"parameter","type":"dimension","label":"Securities issuing sector","param_in":"path","required":true,"filterable":true,"description":"22 codes (e.g. Non-financial corporations (ESA 2010 classification), Other financial intermediaries (ESA 2010 classification), Central government (ESA 2010 classification))","enum_values":["S110","S125","S131","S134","S127","S13C","1000","1100","1220","1230","S126","1235","1250","12A0","1300","130C","130D","1311","1314","1610","1210","2000"],"description_en":"Institutional sector issuing the securities, per ESA 2010 classification."},{"name":"SEC_ITEM","role":"parameter","type":"dimension","label":"Securities item","param_in":"path","required":true,"filterable":true,"description":"6 codes (e.g. Long-term / Fixed rate issues, Long-term / Floating rate issues, Securities other than shares, excluding financial derivatives)","enum_values":["F33201","F33202","F33000","F33200","F33100","F51100"],"description_en":"Type of security item, such as long-term fixed-rate issues or listed shares."},{"name":"SEC_VALUATION","role":"parameter","type":"dimension","label":"Securities valuation","param_in":"path","required":true,"filterable":true,"description":"2 codes (e.g. Nominal value, ESA95 valuation)","enum_values":["N","M"],"description_en":"Valuation method used for the securities, e.g. nominal or ESA95 value."},{"name":"DATA_TYPE_SEC","role":"parameter","type":"dimension","label":"Securities data type","param_in":"path","required":true,"filterable":true,"description":"7 codes (e.g. Outstanding amounts at the end of the period (stocks), Redemptions (flows), (Gross) issues against cash (flows))","enum_values":["1","3","2","4","I","Q","A"],"description_en":"Type of securities data, such as net issues or outstanding stocks."},{"name":"CURRENCY_TRANS","role":"parameter","type":"dimension","label":"Currency of transaction","param_in":"path","required":true,"filterable":true,"description":"13 codes (e.g. All currencies except EUR, All currencies combined, Euro)","enum_values":["Z06","Z01","EUR","Z07","BGN","GBP","SEK","RON","PLN","HRK","CZK","HUF","DKK"],"description_en":"Currency in which the underlying transaction is denominated."},{"name":"SERIES_DENOM","role":"parameter","type":"dimension","label":"Series denominat/spec calcul","param_in":"path","required":true,"filterable":true,"description":"5 codes (e.g. Euro, Annual growth rate, National currency)","enum_values":["E","A","N","3","6"],"description_en":"Denomination or calculation basis of the series, e.g. euro or growth rate."},{"name":"SEC_SUFFIX","role":"parameter","type":"dimension","label":"Series suffix - SEC context","param_in":"path","required":true,"filterable":true,"description":"3 codes (e.g. Unspecified, Seasonally adjusted, Percentage of total currencies)","enum_values":["Z","S","P"],"description_en":"Additional series qualifier, such as seasonal adjustment status."},{"name":"OBS_VALUE","role":"field","type":"number","label":"Observation value","description":"The observed numeric value for each cell.","description_en":"Numeric value of the observation for this series and period."}],"field_count":10,"sample_records":[],"record_count":null,"data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://data-api.ecb.europa.eu/service/dataflow/ECB","curl":"curl -s 'https://data-api.ecb.europa.eu/service/dataflow/ECB' -H 'Accept: application/vnd.sdmx.structure+xml;version=2.1'","label":"List dataflows","method":"GET","description":"All dataflows (datasets) published by this agency, as SDMX-ML."},{"url":"https://data-api.ecb.europa.eu/service/dataflow/ECB/SEC?references=all","curl":"curl -s 'https://data-api.ecb.europa.eu/service/dataflow/ECB/SEC?references=all' -H 'Accept: application/vnd.sdmx.structure+xml;version=2.1'","label":"Dataflow structure","method":"GET","description":"Full structure of the SEC dataflow: dimensions, code lists, attributes."},{"url":"https://data-api.ecb.europa.eu/service/data/SEC/all?lastNObservations=5&format=jsondata","curl":"curl -s 'https://data-api.ecb.europa.eu/service/data/SEC/all?lastNObservations=5&format=jsondata'","label":"Fetch observations (JSON)","method":"GET","description":"Latest observations as SDMX-JSON (the response embeds the dimension structure). Add a key like /data/SEC/D.USD.EUR.SP00.A to select a series."}],"status":"ok","error_message":null,"profiled_at":"2026-10-15T20:43:34.270Z","run_id":"570aa872-c9d0-4a31-8cb7-71d670ba876d","created_at":"2026-07-19T21:54:33.322Z","updated_at":"2026-10-15T20:43:34.270Z","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"],"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":"49294ca01cd609fb514f307fb9e70546fae54c42a3a7f8f6f97c4fa0f6704122","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[] (10 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-10-17T05:55:08.217Z","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."}}