{"id":"1726c5bd-cd39-48b8-b602-f65668db9949","type":"DATASET","name":"Register of guarantees Closure 31.12.2015","slug":"register-of-guarantees-closure-31122015","description":"Overview of guarantees and other guarantees received by beneficiaries, e.g. for third-party loans.","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":null,"docs_url":null,"repo_url":"https://daten.transparenz.hamburg.de/Dataport.HmbTG.ZS.Webservice.GetRessource100/GetRessource100.svc/51c59721-719a-433c-a4de-48f07eeb1f34/Upload___Buergschaftsregister_fuer_HmbTG_31.12.2015_.xlsx","status":"ACTIVE","verification_state":"UNVERIFIED","tags":[],"logo_url":"https://www.google.com/s2/favicons?sz=64&domain=daten.transparenz.hamburg.de","primary_source_url":"https://daten.transparenz.hamburg.de/Dataport.HmbTG.ZS.Webservice.GetRessource100/GetRessource100.svc/51c59721-719a-433c-a4de-48f07eeb1f34/Upload___Buergschaftsregister_fuer_HmbTG_31.12.2015_.xlsx","extraction_confidence":"0.16","created_at":"2026-07-30T13:41:03.224Z","updated_at":"2026-10-12T20:48:42.521Z","last_verified_at":null,"deprecated_at":null,"ranking_score":33,"last_ranked_at":"2026-10-03T14:18:59.880Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-10-04T17:39:11.238Z","search_vector":"'2015':55B,160B '31':53B,158B '31.12.2015':5A,110A 'a':129B,165B,190B 'an':183B 'and':114B,133B,170B,200B 'as':142B,149B 'at':151B,189B 'author':63B 'authority':168B 'back':103B 'backed':208B 'beneficiari':14B,35B 'beneficiaries':119B,140B 'by':118B,164B 'close':48B,153B 'closur':4A 'closure':109A 'commit':74B 'commitments':179B 'cover':66B 'covers':171B 'data':70B,175B 'dataset':22B,127B 'date':88B,193B 'decemb':54B 'december':159B 'e.g':15B,120B 'financi':62B,93B 'financial':167B,198B 'finanzbehorde':169B 'finanzbehörd':64B 'for':121B,144B,195B 'form':30B 'forms':135B 'german':61B,166B 'grant':33B 'granted':138B 'guarante':3A,8B,11B,27B,38B,73B,82B,105B 'guarantee':178B,187B 'guarantees':108A,113B,116B,132B,143B,210B 'in':202B 'is':128B,162B 'it':161B 'level':69B,174B 'liabil':94B 'liabilities':199B 'loan':20B,43B,104B,209B 'loans':125B,148B 'manag':99B 'management':204B 'monitor':91B 'monitoring':196B 'nation':68B 'national':173B 'national-level':67B,172B 'oblig':83B 'obligations':188B 'of':107A,112B,131B,136B,154B,185B,205B 'on':157B,176B 'other':115B,134B 'outstand':81B 'outstanding':186B 'overview':6B,79B,111B,184B 'parti':19B,42B 'party':124B,147B 'period':51B,156B 'provid':77B 'provides':182B 'public':72B,92B,177B,197B 'publish':58B 'published':163B 'receiv':12B 'received':117B 'record':45B 'recorded':150B 'regist':1A,25B,76B 'register':106A,130B,181B 'report':87B 'reporting':192B 'specif':86B 'specific':191B 'state':102B,207B 'state-back':101B 'state-backed':206B 'such':141B 'sureti':32B 'surety':137B 'the':152B,155B,180B,203B 'third':18B,41B,123B,146B 'third-parti':17B,40B 'third-party':122B,145B 'this':126B 'to':139B 'transpar':96B 'transparency':201B 'use':89B 'useful':194B","popularity_score":"0.0000","maintenance_score":"0.5000","institution_id":null,"institution_type":null,"country_code":null,"official_confidence":null,"proof_summary":null,"source_seed_url":null,"is_public_sector":true,"published_at":"2026-07-31T15:24:09.378Z","geographic_scope":"NATIONAL","name_en":null,"description_en":"This dataset is a register of guarantees and other forms of surety granted to beneficiaries, such as guarantees for third-party loans, as recorded at the close of the period on 31 December 2015. It is published by a German financial authority (Finanzbehörde) and covers national-level data on public guarantee commitments. The register provides an overview of outstanding guarantee obligations at a specific reporting date, useful for monitoring public financial liabilities and transparency in the management of state-backed loan guarantees.","native_lang":"de","access_level":"direct","formats":["CSV","EXCEL XLSX","ZIP"],"capability_tier":"live","trust_score":24.903846153846153,"merged_into_entry_id":null,"identity_key":"DATASET|https://daten.transparenz.hamburg.de/Dataport.HmbTG.ZS.Webservice.GetRessource100/GetRessource100.svc/51c59721-719a-433c-a4de-48f07eeb1f34/Upload___Buergschaftsregister_fuer_HmbTG_31.12.2015_.xlsx|register of guarantees closure 31.12.2015","upstream_ref":null,"content_changed_at":null,"title_qualifier":null,"access":{"level":"direct","primary":{"kind":"download","label":"Download EXCEL XLSX","method":"GET","url":"https://daten.transparenz.hamburg.de/Dataport.HmbTG.ZS.Webservice.GetRessource100/GetRessource100.svc/51c59721-719a-433c-a4de-48f07eeb1f34/Upload___Buergschaftsregister_fuer_HmbTG_31.12.2015_.xlsx","format":"EXCEL XLSX","source":"distribution","runnable":true},"actions":[{"kind":"download","label":"Download EXCEL XLSX","method":"GET","url":"https://daten.transparenz.hamburg.de/Dataport.HmbTG.ZS.Webservice.GetRessource100/GetRessource100.svc/51c59721-719a-433c-a4de-48f07eeb1f34/Upload___Buergschaftsregister_fuer_HmbTG_31.12.2015_.xlsx","format":"EXCEL XLSX","source":"distribution","runnable":true},{"kind":"download","label":"Download CSV","method":"GET","url":"https://daten.transparenz.hamburg.de/Dataport.HmbTG.ZS.Webservice.GetRessource100/GetRessource100.svc/f50c8a77-2a8a-4fff-a51d-36083aabd23b/Upload___Buergschaftsregister_fuer_HmbTG_31.12.2015_.csv","format":"CSV","source":"distribution","runnable":true},{"kind":"download","label":"Download ZIP","method":"GET","url":"http://suche.transparenz.hamburg.de/localresources/Upload_Intern/Upload_Internca870a49-3445-447d-9050-bc3544875f2c/Upload___Buergschaftsregister_fuer_HmbTG_31.12.2015_.zip","format":"ZIP","source":"distribution","runnable":true}],"formats":["CSV","EXCEL XLSX","ZIP"]},"maturity":{"entry_id":"1726c5bd-cd39-48b8-b602-f65668db9949","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":"discovered","level_index":1,"level_label":"Discovered","meaning":"Source and metadata recorded","counts_as_coverage":false,"blocked_by":"verified","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":false,"reached":false,"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":false,"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":false,"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":null,"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":"daten.transparenz.hamburg.de","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-12T22:46:21.256Z"},"api_details":null,"dataset_details":{"id":"ca5ff256-bd9b-43cd-b0aa-36f4efea4e41","entry_id":"1726c5bd-cd39-48b8-b602-f65668db9949","upstream_issued":"2016-10-19T00:00:00.000Z","upstream_modified":"2017-01-27T15:51:55.618Z","themes":["AGRI","ECON","REGI"],"update_frequency":null,"temporal_start":null,"temporal_end":null,"spatial_coverage":null,"landing_page":null,"license_id":"dl-de-by-2.0","license_raw":"http://dcat-ap.de/def/licenses/dl-by-de/2.0","has_documentation":false,"has_data_dictionary":false,"has_versioning":false,"source_portal":null,"source_portal_url":null,"created_at":"2026-07-30T13:41:03.399Z","updated_at":"2026-07-30T13:41:03.399Z","publisher":"Finanzbehörde","publisher_url":null,"distributions":[{"id":"461ece39-8ccc-4652-aae4-0eb879eb76fe","dataset_details_id":"ca5ff256-bd9b-43cd-b0aa-36f4efea4e41","title":"Upload: _Guarantee Register for HmbTG _31.12.2015 _","description":null,"access_url":"https://daten.transparenz.hamburg.de/Dataport.HmbTG.ZS.Webservice.GetRessource100/GetRessource100.svc/51c59721-719a-433c-a4de-48f07eeb1f34/Upload___Buergschaftsregister_fuer_HmbTG_31.12.2015_.xlsx","download_url":null,"media_type":null,"format":"Excel XLSX","byte_size":null,"license_id":"dl-de-by-2.0","license_raw":"http://dcat-ap.de/def/licenses/dl-by-de/2.0","last_checked_at":"2026-10-04T17:39:10.614Z","is_available":true,"last_http_status":200,"created_at":"2026-07-30T13:41:03.815Z","updated_at":"2026-10-04T17:39:10.614Z"},{"id":"1f9b0250-8169-4f39-a9a7-9fc874009fb2","dataset_details_id":"ca5ff256-bd9b-43cd-b0aa-36f4efea4e41","title":"Upload: _Guarantee Register for HmbTG _31.12.2015 _","description":null,"access_url":"https://daten.transparenz.hamburg.de/Dataport.HmbTG.ZS.Webservice.GetRessource100/GetRessource100.svc/f50c8a77-2a8a-4fff-a51d-36083aabd23b/Upload___Buergschaftsregister_fuer_HmbTG_31.12.2015_.csv","download_url":null,"media_type":null,"format":"CSV","byte_size":null,"license_id":"dl-de-by-2.0","license_raw":"http://dcat-ap.de/def/licenses/dl-by-de/2.0","last_checked_at":null,"is_available":null,"last_http_status":null,"created_at":"2026-07-30T13:41:03.985Z","updated_at":"2026-07-30T13:41:03.985Z"},{"id":"66b11af5-8e0b-4644-8ec9-6e7c8a3b6f45","dataset_details_id":"ca5ff256-bd9b-43cd-b0aa-36f4efea4e41","title":"Upload: _Guarantee Register for HmbTG _31.12.2015 _ (CSV version in a ZIP file)","description":null,"access_url":"http://suche.transparenz.hamburg.de/localresources/Upload_Intern/Upload_Internca870a49-3445-447d-9050-bc3544875f2c/Upload___Buergschaftsregister_fuer_HmbTG_31.12.2015_.zip","download_url":null,"media_type":null,"format":"ZIP","byte_size":null,"license_id":"dl-de-by-2.0","license_raw":"http://dcat-ap.de/def/licenses/dl-by-de/2.0","last_checked_at":null,"is_available":null,"last_http_status":null,"created_at":"2026-07-30T13:41:04.143Z","updated_at":"2026-07-30T13:41:04.143Z"}],"license":{"id":"dl-de-by-2.0","spdx_id":null,"name":"Data licence Germany — attribution 2.0 (DL-DE-BY-2.0)","url":"https://www.govdata.de/dl-de/by-2-0","is_open":true,"is_redistributable":true,"requires_attribution":true,"category":"national","notes":null,"created_at":"2026-06-12T16:29:19.729Z"}},"license":{"id":"dl-de-by-2.0","spdx_id":null,"name":"Data licence Germany — attribution 2.0 (DL-DE-BY-2.0)","url":"https://www.govdata.de/dl-de/by-2-0","is_open":true,"is_redistributable":true,"requires_attribution":true,"category":"national","notes":null,"created_at":"2026-06-12T16:29:19.729Z"},"reuse":{"license_id":"dl-de-by-2.0","license_name":"Data licence Germany — attribution 2.0 (DL-DE-BY-2.0)","license_url":"https://www.govdata.de/dl-de/by-2-0","commercial_use":{"status":"yes","value":true},"redistribution":{"status":"yes","value":true},"attribution_required":{"status":"yes","value":true},"share_alike":{"status":"no","value":false},"personal_data_warning":{"status":"unknown","value":null},"cache_and_mirror":{"status":"yes","value":true},"undetermined":["personal_data_warning"],"basis":"licence_text","confidence":0.95,"confidence_tier":"high","source_text":"Lizenztext: die Daten duerfen \"vervielfaeltigt, ausgedruckt, praesentiert, veraendert, bearbeitet sowie an Dritte uebermittelt werden\" und \"zusammengefuehrt und zu selbstaendigen neuen Datensaetzen verbunden werden\", fuer kommerzielle wie nicht kommerzielle Nutzung. Pflicht ist ein Quellenvermerk mit \"Bezeichnung des Bereitstellers nach dessen Massgabe\", dem Zusatz \"Datenlizenz Deutschland - Namensnennung - Version 2.0\" und \"einen Verweis auf den Datensatz (URI)\"; Aenderungen sind kenntlich zu machen. Keine Share-Alike-Klausel. Zu personenbezogenen Daten sagt der Text nichts, daher bleibt dieses Feld offen.","source_url":"https://www.govdata.de/dl-de/by-2-0","reviewed_at":null},"license_raw":"http://dcat-ap.de/def/licenses/dl-by-de/2.0","latest_check":{"id":"3f118836-574e-4e68-8f50-f580dd58892c","entry_id":"1726c5bd-cd39-48b8-b602-f65668db9949","status":"UNVERIFIED","last_checked_at":"2026-10-12T20:30:30.921Z","p50_latency_ms":null,"p95_latency_ms":null,"last_error":"No distribution or landing-page URL available for verification","consecutive_failures":0,"created_at":"2026-07-30T13:42:10.754Z","updated_at":"2026-10-12T20:30:30.921Z","consecutive_successes":0,"probe_url":null,"probe_method":null,"probe_http_status":null,"probe_content_type":null,"probe_succeeded_at":null},"data_profile":{"id":"7a71eb53-6dc8-4469-9179-e3d2b04208bf","entry_id":"1726c5bd-cd39-48b8-b602-f65668db9949","profile_source":"distribution","profile_kind":"dataset","dataset_id":null,"fields":[{"name":"Meldung nach § 3 Abs. 1 Nr. 14 HmbTG: Subventions- und Zuwendungsvergaben","type":"text","label":null,"description":null,"description_en":"Report heading on subsidy and grant awards under Hamburg Transparency Act §3(1)14."},{"name":"column_2","type":"text","label":null,"description":null,"description_en":"Unlabelled text column, likely a data field within the register."},{"name":"column_3","type":"int","label":null,"description":null,"description_en":"Unlabelled numeric column, likely a data field within the register."},{"name":"column_4","type":"text","label":null,"description":null,"description_en":"Unlabelled text column, likely a data field within the register."},{"name":"column_5","type":"text","label":null,"description":null,"description_en":"Unlabelled text column, likely a data field within the register."},{"name":"column_6","type":"text","label":null,"description":null,"description_en":"Unlabelled text column, likely a data field within the register."},{"name":"Stand: 31.12.2015","type":"text","label":null,"description":null,"description_en":"Indicates the data status date of 31 December 2015."},{"name":"column_8","type":"text","label":null,"description":null,"description_en":"Unlabelled text column, likely a data field within the register."}],"field_count":8,"sample_records":[{"column_2":"","column_3":"","column_4":"","column_5":"","column_6":"","column_8":"","Stand: 31.12.2015":"","Meldung nach § 3 Abs. 1 Nr. 14 HmbTG: Subventions- und Zuwendungsvergaben":"hier:  Bürgschaften (B) und Garantien (G) gemäß \"Bürgschaftregister\""},{"column_2":"","column_3":"","column_4":"","column_5":"","column_6":"","column_8":"","Stand: 31.12.2015":"","Meldung nach § 3 Abs. 1 Nr. 14 HmbTG: Subventions- und Zuwendungsvergaben":""},{"column_2":"","column_3":"","column_4":"","column_5":"","column_6":"","column_8":"","Stand: 31.12.2015":"","Meldung nach § 3 Abs. 1 Nr. 14 HmbTG: Subventions- und Zuwendungsvergaben":""},{"column_2":"AKN Eisenbahn AG","column_3":"1","column_4":"","column_5":"4.080.437,62","column_6":"","column_8":"","Stand: 31.12.2015":"B","Meldung nach § 3 Abs. 1 Nr. 14 HmbTG: Subventions- und Zuwendungsvergaben":""},{"column_2":"AKN Eisenbahn AG","column_3":"2","column_4":"BWVI","column_5":"","column_6":"Erleichterung der Finanzierung von Investitionen","column_8":"27.291.020,82 €","Stand: 31.12.2015":"B","Meldung nach § 3 Abs. 1 Nr. 14 HmbTG: Subventions- und Zuwendungsvergaben":""}],"record_count":null,"data_size_bytes":"45306","dataset_count":null,"query_examples":[{"url":"https://daten.transparenz.hamburg.de/Dataport.HmbTG.ZS.Webservice.GetRessource100/GetRessource100.svc/f50c8a77-2a8a-4fff-a51d-36083aabd23b/Upload___Buergschaftsregister_fuer_HmbTG_31.12.2015_.csv","curl":"curl -sL 'https://daten.transparenz.hamburg.de/Dataport.HmbTG.ZS.Webservice.GetRessource100/GetRessource100.svc/f50c8a77-2a8a-4fff-a51d-36083aabd23b/Upload___Buergschaftsregister_fuer_HmbTG_31.12.2015_.csv' -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://daten.transparenz.hamburg.de/Dataport.HmbTG.ZS.Webservice.GetRessource100/GetRessource100.svc/f50c8a77-2a8a-4fff-a51d-36083aabd23b/Upload___Buergschaftsregister_fuer_HmbTG_31.12.2015_.csv","curl":"curl -sL 'https://daten.transparenz.hamburg.de/Dataport.HmbTG.ZS.Webservice.GetRessource100/GetRessource100.svc/f50c8a77-2a8a-4fff-a51d-36083aabd23b/Upload___Buergschaftsregister_fuer_HmbTG_31.12.2015_.csv' -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-10-08T19:53:23.441Z","run_id":"aa71abe6-7f25-4028-b5dd-c133d08a058e","created_at":"2026-07-30T13:41:40.233Z","updated_at":"2026-10-08T19:53:23.441Z","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":[],"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":"fbd3e8371676777484dfdf2774ef0631035061290fb41255b3b060ed018e327a","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":28,"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-10-12T22:47:07.313Z","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."}}