{"id":"b3890c41-8c70-468f-8193-572cb0f9771b","type":"DATASET","name":"Population: Date, marital status","slug":"population-date-marital-status","description":"Population at the main residence by marital status at the level of the city as a whole.","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":null,"docs_url":null,"repo_url":"https://gelsenkirchen.opendata.ruhr/dataset/ab2c6544-dc4e-46df-9c6a-fdd07d991043/resource/aedfcf9b-0aa3-495f-8e1d-b8c33926e4dc/download/stadt-gelsenkirchen-statistik-bevoelkerung-familienstand.json","status":"ACTIVE","verification_state":"VERIFIED","tags":[],"logo_url":"https://www.google.com/s2/favicons?sz=64&domain=gelsenkirchen.opendata.ruhr","primary_source_url":"https://gelsenkirchen.opendata.ruhr/dataset/ab2c6544-dc4e-46df-9c6a-fdd07d991043/resource/aedfcf9b-0aa3-495f-8e1d-b8c33926e4dc/download/stadt-gelsenkirchen-statistik-bevoelkerung-familienstand.json","extraction_confidence":"0.16","created_at":"2026-07-18T12:45:42.750Z","updated_at":"2026-10-12T20:48:52.911Z","last_verified_at":"2026-10-12T19:22:25.580Z","deprecated_at":null,"ranking_score":36,"last_ranked_at":"2026-10-06T12:19:58.542Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-10-07T01:56:07.192Z","search_vector":"'a':118B,140B,147B,168B 'administr':80B 'administrative':178B 'analysi':79B 'analysis':177B 'and':161B,180B 'as':117B,139B,146B,166B 'at':104B,111B,128B,193B 'broken':36B,134B 'by':108B,136B,151B,156B,190B 'citi':18B,47B,60B 'city':116B,145B,158B 'composit':87B 'composition':185B 'data':67B,165B 'dataset':23B,74B,121B,172B 'date':2A,72B,100A,170B 'demograph':78B 'demographic':176B 'district':54B,152B 'down':135B 'figur':44B 'figure':142B 'for':143B,175B 'gelsenkirchen':35B,62B,133B,160B 'given':71B,169B 'in':132B 'is':154B,173B 'it':153B 'level':15B,98B,113B,196B 'main':8B,32B,106B,130B 'marit':3A,11B,39B,93B 'marital':101A,109B,137B,191B 'municip':97B 'municipal':195B 'number':26B,124B 'of':114B,125B,159B,167B,186B 'on':183B 'plan':81B 'planning':179B 'popul':1A,5B,65B,91B 'population':99A,103B,163B,189B 'provid':24B 'provides':122B 'publish':57B 'published':155B 'rather':51B,149B 'reflect':64B 'reflects':162B 'regist':29B,66B 'register':164B 'registered':127B 'report':84B 'reporting':182B 'resid':9B,28B,33B,90B 'residence':107B,131B 'resident':188B 'residents':126B 'singl':43B 'single':141B 'statist':83B 'statistical':181B 'status':4A,12B,40B,94B,102A,110B,138B,192B 'than':150B 'the':105B,112B,115B,123B,144B,157B,171B,184B,187B,194B 'their':129B 'this':120B 'use':76B 'useful':174B 'whole':21B,50B,119B,148B","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-19T17:29:00.000Z","geographic_scope":"NATIONAL","name_en":null,"description_en":"This dataset provides the number of residents registered at their main residence in Gelsenkirchen, broken down by marital status, as a single figure for the city as a whole rather than by district. It is published by the city of Gelsenkirchen and reflects population register data as of a given date. The dataset is useful for demographic analysis, administrative planning, and statistical reporting on the composition of the resident population by marital status at the municipal level.","native_lang":"en","access_level":"direct","formats":["CSV","JSON","RDATA"],"capability_tier":"sample","trust_score":41.69230769230769,"merged_into_entry_id":null,"identity_key":"DATASET|https://gelsenkirchen.opendata.ruhr/dataset/ab2c6544-dc4e-46df-9c6a-fdd07d991043/resource/aedfcf9b-0aa3-495f-8e1d-b8c33926e4dc/download/stadt-gelsenkirchen-statistik-bevoelkerung-familienstand.json|population: date, marital status","upstream_ref":null,"content_changed_at":null,"title_qualifier":null,"access":{"level":"direct","primary":{"kind":"download","label":"Download CSV","method":"GET","url":"https://gelsenkirchen.opendata.ruhr/dataset/ab2c6544-dc4e-46df-9c6a-fdd07d991043/resource/4d426d1f-8804-4af6-81b8-c6676b67a64c/download/stadt-gelsenkirchen-statistik-bevoelkerung-familienstand.csv","format":"CSV","byte_size":"2737","source":"distribution","runnable":true},"actions":[{"kind":"download","label":"Download CSV","method":"GET","url":"https://gelsenkirchen.opendata.ruhr/dataset/ab2c6544-dc4e-46df-9c6a-fdd07d991043/resource/4d426d1f-8804-4af6-81b8-c6676b67a64c/download/stadt-gelsenkirchen-statistik-bevoelkerung-familienstand.csv","format":"CSV","byte_size":"2737","source":"distribution","runnable":true},{"kind":"download","label":"Download JSON","method":"GET","url":"https://gelsenkirchen.opendata.ruhr/dataset/ab2c6544-dc4e-46df-9c6a-fdd07d991043/resource/aedfcf9b-0aa3-495f-8e1d-b8c33926e4dc/download/stadt-gelsenkirchen-statistik-bevoelkerung-familienstand.json","format":"JSON","byte_size":"9962","source":"distribution","runnable":true},{"kind":"download","label":"Download RDATA","method":"GET","url":"https://gelsenkirchen.opendata.ruhr/dataset/ab2c6544-dc4e-46df-9c6a-fdd07d991043/resource/80f0e0e1-b45b-4107-8c21-59455b71cb9a/download/stadt-gelsenkirchen-statistik-bevoelkerung-familienstand.rdata","format":"RDATA","byte_size":"1251","source":"distribution","runnable":true},{"kind":"query","label":"Dataset metadata (DCAT)","method":"GET","url":"https://gelsenkirchen.opendata.ruhr/dataset/ab2c6544-dc4e-46df-9c6a-fdd07d991043.rdf","source":"query_example","runnable":true,"direct":false},{"kind":"landing","label":"Open source page","method":"GET","url":"https://gelsenkirchen.opendata.ruhr/dataset/ab2c6544-dc4e-46df-9c6a-fdd07d991043","source":"landing_page","runnable":false}],"formats":["CSV","JSON","RDATA"]},"maturity":{"entry_id":"b3890c41-8c70-468f-8193-572cb0f9771b","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":"profiled","level_index":3,"level_label":"Profiled","meaning":"Schema, dimensions and licence understood","counts_as_coverage":false,"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":false,"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":"gelsenkirchen.opendata.ruhr","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:45:28.678Z"},"api_details":null,"dataset_details":{"id":"a456616f-ab38-4716-98c9-292de2ddf00b","entry_id":"b3890c41-8c70-468f-8193-572cb0f9771b","upstream_issued":"2026-02-06T16:25:27.269Z","upstream_modified":"2026-08-11T11:23:53.285Z","themes":["SOCI"],"update_frequency":null,"temporal_start":null,"temporal_end":null,"spatial_coverage":null,"landing_page":"https://gelsenkirchen.opendata.ruhr/dataset/ab2c6544-dc4e-46df-9c6a-fdd07d991043","license_id":"proprietary","license_raw":"http://dcat-ap.de/def/licenses/other-closed","has_documentation":false,"has_data_dictionary":false,"has_versioning":false,"source_portal":"ckan","source_portal_url":"https://gelsenkirchen.opendata.ruhr","created_at":"2026-07-18T12:45:42.917Z","updated_at":"2026-10-06T13:59:02.590Z","publisher":"Gelsenkirchen","publisher_url":null,"distributions":[{"id":"badc1118-515c-48eb-9f46-82dcba525a44","dataset_details_id":"a456616f-ab38-4716-98c9-292de2ddf00b","title":"stadt-gelsenkirchen-statistik-bevoelkerung-familienstand.csv","description":null,"access_url":"https://gelsenkirchen.opendata.ruhr/dataset/ab2c6544-dc4e-46df-9c6a-fdd07d991043/resource/4d426d1f-8804-4af6-81b8-c6676b67a64c/download/stadt-gelsenkirchen-statistik-bevoelkerung-familienstand.csv","download_url":"https://gelsenkirchen.opendata.ruhr/dataset/ab2c6544-dc4e-46df-9c6a-fdd07d991043/resource/4d426d1f-8804-4af6-81b8-c6676b67a64c/download/stadt-gelsenkirchen-statistik-bevoelkerung-familienstand.csv","media_type":"text/csv","format":"csv","byte_size":"2737","license_id":null,"license_raw":null,"last_checked_at":"2026-10-12T19:22:23.427Z","is_available":true,"last_http_status":200,"created_at":"2026-10-06T13:59:01.051Z","updated_at":"2026-10-12T19:22:23.427Z"},{"id":"ceb93e5d-2940-4d6d-9193-8764be8eb4b4","dataset_details_id":"a456616f-ab38-4716-98c9-292de2ddf00b","title":"stadt-gelsenkirchen-statistik-bevoelkerung-familienstand.json","description":null,"access_url":"https://gelsenkirchen.opendata.ruhr/dataset/ab2c6544-dc4e-46df-9c6a-fdd07d991043/resource/aedfcf9b-0aa3-495f-8e1d-b8c33926e4dc/download/stadt-gelsenkirchen-statistik-bevoelkerung-familienstand.json","download_url":"https://gelsenkirchen.opendata.ruhr/dataset/ab2c6544-dc4e-46df-9c6a-fdd07d991043/resource/aedfcf9b-0aa3-495f-8e1d-b8c33926e4dc/download/stadt-gelsenkirchen-statistik-bevoelkerung-familienstand.json","media_type":"application/json","format":"json","byte_size":"9962","license_id":null,"license_raw":null,"last_checked_at":null,"is_available":null,"last_http_status":null,"created_at":"2026-10-06T13:59:01.229Z","updated_at":"2026-10-06T13:59:01.229Z"},{"id":"a5954638-305d-47ef-8889-150f39c6b979","dataset_details_id":"a456616f-ab38-4716-98c9-292de2ddf00b","title":"stadt-gelsenkirchen-statistik-bevoelkerung-familienstand.RData","description":null,"access_url":"https://gelsenkirchen.opendata.ruhr/dataset/ab2c6544-dc4e-46df-9c6a-fdd07d991043/resource/80f0e0e1-b45b-4107-8c21-59455b71cb9a/download/stadt-gelsenkirchen-statistik-bevoelkerung-familienstand.rdata","download_url":null,"media_type":null,"format":"rdata","byte_size":"1251","license_id":null,"license_raw":null,"last_checked_at":null,"is_available":null,"last_http_status":null,"created_at":"2026-10-06T13:59:01.408Z","updated_at":"2026-10-06T13:59:01.408Z"}],"license":{"id":"proprietary","spdx_id":null,"name":"Proprietary / non-redistributable","url":null,"is_open":false,"is_redistributable":false,"requires_attribution":true,"category":"restricted","notes":null,"created_at":"2026-06-12T16:29:19.729Z"}},"license":{"id":"proprietary","spdx_id":null,"name":"Proprietary / non-redistributable","url":null,"is_open":false,"is_redistributable":false,"requires_attribution":true,"category":"restricted","notes":null,"created_at":"2026-06-12T16:29:19.729Z"},"reuse":{"license_id":"proprietary","license_name":"Proprietary / non-redistributable","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":"Internal sentinel, not a licence. Set when an all-rights-reserved or other-closed notice was matched. No licence text has been read for these entries, so no reuse permission is asserted here and every consumer must fail closed.","source_url":null,"reviewed_at":null},"license_raw":"http://dcat-ap.de/def/licenses/other-closed","latest_check":{"id":"1fb8011e-c058-424d-aef7-d4898d50f947","entry_id":"b3890c41-8c70-468f-8193-572cb0f9771b","status":"VERIFIED","last_checked_at":"2026-10-12T19:22:24.958Z","p50_latency_ms":1961,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-18T12:46:42.458Z","updated_at":"2026-10-12T19:22:24.958Z","consecutive_successes":88,"probe_url":"https://gelsenkirchen.opendata.ruhr/dataset/ab2c6544-dc4e-46df-9c6a-fdd07d991043/resource/4d426d1f-8804-4af6-81b8-c6676b67a64c/download/stadt-gelsenkirchen-statistik-bevoelkerung-familienstand.csv","probe_method":"GET","probe_http_status":200,"probe_content_type":"text/csv","probe_succeeded_at":"2026-10-12T19:22:24.958Z"},"data_profile":{"id":"a9283401-aa73-4e90-b64e-3207518080d2","entry_id":"b3890c41-8c70-468f-8193-572cb0f9771b","profile_source":"ckan","profile_kind":"dataset","dataset_id":"ab2c6544-dc4e-46df-9c6a-fdd07d991043","fields":[{"name":"Stichtag","type":"text","label":null,"description":null},{"name":"ledig","type":"int","label":null,"description":null},{"name":"verheiratet","type":"int","label":null,"description":null},{"name":"verwitwet","type":"int","label":null,"description":null},{"name":"geschieden","type":"int","label":null,"description":null},{"name":"Lebenspartnerschaft","type":"int","label":null,"description":null},{"name":"Lebenspartnerschaft aufgehoben","type":"int","label":null,"description":null},{"name":"Lebenspartner verstorben","type":"int","label":null,"description":null},{"name":"nicht bekannt","type":"int","label":null,"description":null}],"field_count":9,"sample_records":[{"ledig":"117668","Stichtag":"30.06.2026","verwitwet":"17945","geschieden":"21377","verheiratet":"105502","nicht bekannt":"7926","Lebenspartnerschaft":"133","Lebenspartner verstorben":"17","Lebenspartnerschaft aufgehoben":"83"},{"ledig":"117969","Stichtag":"31.03.2026","verwitwet":"18062","geschieden":"21426","verheiratet":"105631","nicht bekannt":"7608","Lebenspartnerschaft":"142","Lebenspartner verstorben":"15","Lebenspartnerschaft aufgehoben":"81"},{"ledig":"117651","Stichtag":"31.12.2025","verwitwet":"18186","geschieden":"21392","verheiratet":"106208","nicht bekannt":"7410","Lebenspartnerschaft":"140","Lebenspartner verstorben":"16","Lebenspartnerschaft aufgehoben":"84"},{"ledig":"117678","Stichtag":"30.09.2025","verwitwet":"18321","geschieden":"21411","verheiratet":"106417","nicht bekannt":"7108","Lebenspartnerschaft":"144","Lebenspartner verstorben":"15","Lebenspartnerschaft aufgehoben":"84"},{"ledig":"118502","Stichtag":"30.06.2025","verwitwet":"18538","geschieden":"21554","verheiratet":"106761","nicht bekannt":"6908","Lebenspartnerschaft":"148","Lebenspartner verstorben":"15","Lebenspartnerschaft aufgehoben":"89"}],"record_count":null,"data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://gelsenkirchen.opendata.ruhr/dataset/ab2c6544-dc4e-46df-9c6a-fdd07d991043.rdf","curl":"curl -s 'https://gelsenkirchen.opendata.ruhr/dataset/ab2c6544-dc4e-46df-9c6a-fdd07d991043.rdf' -H 'Accept: application/rdf+xml'","label":"Dataset metadata (DCAT)","method":"GET","description":"DCAT (RDF/XML) record: title, publisher, freshness and every distribution. This portal disallows /api/ in robots.txt, so this is the route to use."},{"url":"https://gelsenkirchen.opendata.ruhr/dataset/ab2c6544-dc4e-46df-9c6a-fdd07d991043/resource/4d426d1f-8804-4af6-81b8-c6676b67a64c/download/stadt-gelsenkirchen-statistik-bevoelkerung-familienstand.csv","curl":"curl -sL 'https://gelsenkirchen.opendata.ruhr/dataset/ab2c6544-dc4e-46df-9c6a-fdd07d991043/resource/4d426d1f-8804-4af6-81b8-c6676b67a64c/download/stadt-gelsenkirchen-statistik-bevoelkerung-familienstand.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."}],"status":"ok","error_message":null,"profiled_at":"2026-10-06T13:58:59.979Z","run_id":"3230e996-33a2-4d43-98f6-e212f42f1ab8","created_at":"2026-07-18T12:46:47.658Z","updated_at":"2026-10-06T13:58:59.979Z","license_raw":"dl-de-by-2.0","license_id":"dl-de-by-2.0","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":"7b42f9586999b9cae915442a065bb141ca15a484a59eca6766a487aedff37808","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[] (9 rows).","live":true,"live_basis":"This body was produced by executing the request.","created_at":"2026-10-12T22:45:28.717Z","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."}}