{"id":"5a813dad-61a3-41d4-ae90-c3fa8e714093","type":"DATASET","name":"Population: Date, district, nationality","slug":"population-date-district-nationality","description":"Population at main residence by nationality at district level.","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":null,"docs_url":null,"repo_url":"https://gelsenkirchen.opendata.ruhr/dataset/924ad5e7-1460-4c69-8453-2bec4a9efce7/resource/eb2ba070-6b5f-498c-8659-9e722a24da1e/download/stadt-gelsenkirchen-statistik-bevoelkerung-nationalitaet.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/924ad5e7-1460-4c69-8453-2bec4a9efce7/resource/eb2ba070-6b5f-498c-8659-9e722a24da1e/download/stadt-gelsenkirchen-statistik-bevoelkerung-nationalitaet.json","extraction_confidence":"0.16","created_at":"2026-07-05T11:45:50.331Z","updated_at":"2026-10-12T20:48:46.886Z","last_verified_at":"2026-10-12T18:14:27.415Z","deprecated_at":null,"ranking_score":36,"last_ranked_at":"2026-10-10T23:54:08.883Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-10-10T12:25:22.267Z","search_vector":"'a':127B,151B,173B 'across':48B,137B 'administr':88B 'administrative':177B 'allow':54B 'allowing':143B 'analysi':76B 'analysis':165B 'and':169B 'as':150B 'at':95B,100B,108B,115B,172B 'breakdown':40B,129B 'broken':22B,111B 'by':98B,113B,120B,135B 'categori':73B 'category':162B 'citi':33B,53B,87B 'city':122B,142B,176B 'comparison':55B,144B 'composit':44B 'composition':133B 'dataset':15B,67B,104B,156B 'date':2A,91A 'demograph':39B,78B 'demographic':128B,167B 'differ':49B 'different':138B 'distribut':79B 'distribution':168B 'district':3A,12B,28B,50B,92A,101B,117B 'districts':139B 'down':112B 'fall':68B 'falling':157B 'figur':18B 'figures':107B 'gelsenkirchen':35B,124B 'how':131B 'it':125B,163B 'level':13B,29B,89B,102B,118B,178B 'main':7B,20B,96B,109B 'nation':4A,10B,25B,47B,64B,81B 'national':153B 'national-scop':63B 'national-scope':152B 'nationality':93A,99B,114B,136B,170B 'number':58B 'numbers':147B 'of':123B,145B,166B 'offer':37B 'offers':126B 'over':148B 'pattern':82B 'patterns':171B 'popul':1A,5B,17B,43B 'population':90A,94B,106B,132B 'provid':16B 'provides':105B 'publish':30B 'published':119B 'resid':8B,21B,57B 'residence':97B,110B 'resident':146B 'scope':65B,154B 'show':41B 'showing':130B 'social':71B,160B 'statist':66B 'statistical':155B 'sub':86B,175B 'sub-citi':85B 'sub-city':174B 'support':75B 'supports':164B 'the':116B,121B,141B,159B 'theme':72B 'themes':161B 'this':103B 'time':60B,149B 'under':158B 'vari':45B 'varies':134B 'within':51B,140B","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-06T08:49:35.069Z","geographic_scope":"NATIONAL","name_en":null,"description_en":"This dataset provides population figures at main residence broken down by nationality at the district level, published by the city of Gelsenkirchen. It offers a demographic breakdown showing how population composition varies by nationality across different districts within the city, allowing comparison of resident numbers over time. As a national-scope statistical dataset falling under the social themes category, it supports analysis of demographic distribution and nationality patterns at a sub-city administrative 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/924ad5e7-1460-4c69-8453-2bec4a9efce7/resource/eb2ba070-6b5f-498c-8659-9e722a24da1e/download/stadt-gelsenkirchen-statistik-bevoelkerung-nationalitaet.json|population: date, district, nationality","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/924ad5e7-1460-4c69-8453-2bec4a9efce7/resource/3d7ed688-ca44-4aa5-a24c-79ab4c31a7b9/download/stadt-gelsenkirchen-statistik-bevoelkerung-nationalitaet.csv","format":"CSV","byte_size":"44558","source":"distribution","runnable":true},"actions":[{"kind":"download","label":"Download CSV","method":"GET","url":"https://gelsenkirchen.opendata.ruhr/dataset/924ad5e7-1460-4c69-8453-2bec4a9efce7/resource/3d7ed688-ca44-4aa5-a24c-79ab4c31a7b9/download/stadt-gelsenkirchen-statistik-bevoelkerung-nationalitaet.csv","format":"CSV","byte_size":"44558","source":"distribution","runnable":true},{"kind":"download","label":"Download JSON","method":"GET","url":"https://gelsenkirchen.opendata.ruhr/dataset/924ad5e7-1460-4c69-8453-2bec4a9efce7/resource/eb2ba070-6b5f-498c-8659-9e722a24da1e/download/stadt-gelsenkirchen-statistik-bevoelkerung-nationalitaet.json","format":"JSON","byte_size":"156101","source":"distribution","runnable":true},{"kind":"download","label":"Download RDATA","method":"GET","url":"https://gelsenkirchen.opendata.ruhr/dataset/924ad5e7-1460-4c69-8453-2bec4a9efce7/resource/040a940e-f5fe-4855-9a2d-508316bee76e/download/stadt-gelsenkirchen-statistik-bevoelkerung-nationalitaet.rdata","format":"RDATA","byte_size":"7712","source":"distribution","runnable":true},{"kind":"query","label":"Dataset metadata (DCAT)","method":"GET","url":"https://gelsenkirchen.opendata.ruhr/dataset/924ad5e7-1460-4c69-8453-2bec4a9efce7.rdf","source":"query_example","runnable":true,"direct":false},{"kind":"landing","label":"Open source page","method":"GET","url":"https://gelsenkirchen.opendata.ruhr/dataset/924ad5e7-1460-4c69-8453-2bec4a9efce7","source":"landing_page","runnable":false}],"formats":["CSV","JSON","RDATA"]},"maturity":{"entry_id":"5a813dad-61a3-41d4-ae90-c3fa8e714093","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:38.854Z"},"api_details":null,"dataset_details":{"id":"142cd232-b789-4eae-9cdc-5835313eaf66","entry_id":"5a813dad-61a3-41d4-ae90-c3fa8e714093","upstream_issued":"2026-02-06T16:25:03.213Z","upstream_modified":"2026-08-11T11:26:20.434Z","themes":["SOCI"],"update_frequency":null,"temporal_start":null,"temporal_end":null,"spatial_coverage":null,"landing_page":"https://gelsenkirchen.opendata.ruhr/dataset/924ad5e7-1460-4c69-8453-2bec4a9efce7","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-05T11:45:50.494Z","updated_at":"2026-10-07T22:12:43.901Z","publisher":"Gelsenkirchen","publisher_url":null,"distributions":[{"id":"65edb373-111b-4a67-a544-b39b3f0fb8fc","dataset_details_id":"142cd232-b789-4eae-9cdc-5835313eaf66","title":"stadt-gelsenkirchen-statistik-bevoelkerung-nationalitaet.csv","description":null,"access_url":"https://gelsenkirchen.opendata.ruhr/dataset/924ad5e7-1460-4c69-8453-2bec4a9efce7/resource/3d7ed688-ca44-4aa5-a24c-79ab4c31a7b9/download/stadt-gelsenkirchen-statistik-bevoelkerung-nationalitaet.csv","download_url":"https://gelsenkirchen.opendata.ruhr/dataset/924ad5e7-1460-4c69-8453-2bec4a9efce7/resource/3d7ed688-ca44-4aa5-a24c-79ab4c31a7b9/download/stadt-gelsenkirchen-statistik-bevoelkerung-nationalitaet.csv","media_type":"text/csv","format":"csv","byte_size":"44558","license_id":null,"license_raw":null,"last_checked_at":"2026-10-12T18:14:25.976Z","is_available":true,"last_http_status":200,"created_at":"2026-10-07T22:12:42.782Z","updated_at":"2026-10-12T18:14:25.976Z"},{"id":"0ca437b7-1082-4e3f-8c90-59e039acadab","dataset_details_id":"142cd232-b789-4eae-9cdc-5835313eaf66","title":"stadt-gelsenkirchen-statistik-bevoelkerung-nationalitaet.json","description":null,"access_url":"https://gelsenkirchen.opendata.ruhr/dataset/924ad5e7-1460-4c69-8453-2bec4a9efce7/resource/eb2ba070-6b5f-498c-8659-9e722a24da1e/download/stadt-gelsenkirchen-statistik-bevoelkerung-nationalitaet.json","download_url":"https://gelsenkirchen.opendata.ruhr/dataset/924ad5e7-1460-4c69-8453-2bec4a9efce7/resource/eb2ba070-6b5f-498c-8659-9e722a24da1e/download/stadt-gelsenkirchen-statistik-bevoelkerung-nationalitaet.json","media_type":"application/json","format":"json","byte_size":"156101","license_id":null,"license_raw":null,"last_checked_at":null,"is_available":null,"last_http_status":null,"created_at":"2026-10-07T22:12:42.940Z","updated_at":"2026-10-07T22:12:42.940Z"},{"id":"ae070e58-4bb8-4b68-818f-575fe5770541","dataset_details_id":"142cd232-b789-4eae-9cdc-5835313eaf66","title":"stadt-gelsenkirchen-statistik-bevoelkerung-nationalitaet.RData","description":null,"access_url":"https://gelsenkirchen.opendata.ruhr/dataset/924ad5e7-1460-4c69-8453-2bec4a9efce7/resource/040a940e-f5fe-4855-9a2d-508316bee76e/download/stadt-gelsenkirchen-statistik-bevoelkerung-nationalitaet.rdata","download_url":null,"media_type":null,"format":"rdata","byte_size":"7712","license_id":null,"license_raw":null,"last_checked_at":null,"is_available":null,"last_http_status":null,"created_at":"2026-10-07T22:12:43.105Z","updated_at":"2026-10-07T22:12:43.105Z"}],"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":"79f25b2c-e58f-43f5-9a60-4e9986c585b3","entry_id":"5a813dad-61a3-41d4-ae90-c3fa8e714093","status":"VERIFIED","last_checked_at":"2026-10-12T18:14:27.120Z","p50_latency_ms":3300,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-05T11:46:55.685Z","updated_at":"2026-10-12T18:14:27.120Z","consecutive_successes":212,"probe_url":"https://gelsenkirchen.opendata.ruhr/dataset/924ad5e7-1460-4c69-8453-2bec4a9efce7/resource/3d7ed688-ca44-4aa5-a24c-79ab4c31a7b9/download/stadt-gelsenkirchen-statistik-bevoelkerung-nationalitaet.csv","probe_method":"GET","probe_http_status":200,"probe_content_type":"text/csv","probe_succeeded_at":"2026-10-12T18:14:27.120Z"},"data_profile":{"id":"bfb51f35-3afe-4d19-bce0-a059f6c037b7","entry_id":"5a813dad-61a3-41d4-ae90-c3fa8e714093","profile_source":"ckan","profile_kind":"dataset","dataset_id":"924ad5e7-1460-4c69-8453-2bec4a9efce7","fields":[{"name":"Stichtag","type":"text","label":null,"description":null,"description_en":"Reference date for the population count."},{"name":"Stadtbezirk_ID","type":"int","label":null,"description":null,"description_en":"Identifier code for the city district (Stadtbezirk)."},{"name":"Stadtbezirk_Name","type":"text","label":null,"description":null,"description_en":"Name of the city district (Stadtbezirk)."},{"name":"Stadtteil_ID","type":"int","label":null,"description":null,"description_en":"Identifier code for the city quarter (Stadtteil)."},{"name":"Stadtteil_Name","type":"text","label":null,"description":null,"description_en":"Name of the city quarter (Stadtteil)."},{"name":"deutsch","type":"int","label":null,"description":null,"description_en":"Number of residents holding German nationality."},{"name":"davon deutsch mit 2. StA","type":"int","label":null,"description":null,"description_en":"Of the German residents, number also holding a second nationality."},{"name":"nichtdeutsch","type":"int","label":null,"description":null,"description_en":"Number of residents without German nationality."}],"field_count":8,"sample_records":[{"deutsch":"2425","Stichtag":"30.06.2026","Stadtteil_ID":"12","nichtdeutsch":"2061","Stadtbezirk_ID":"1","Stadtteil_Name":"Schalke-Nord","Stadtbezirk_Name":"Mitte","davon deutsch mit 2. StA":"572"},{"deutsch":"4709","Stichtag":"30.06.2026","Stadtteil_ID":"16","nichtdeutsch":"982","Stadtbezirk_ID":"1","Stadtteil_Name":"Heßler","Stadtbezirk_Name":"Mitte","davon deutsch mit 2. StA":"689"},{"deutsch":"5637","Stichtag":"30.06.2026","Stadtteil_ID":"10","nichtdeutsch":"4829","Stadtbezirk_ID":"1","Stadtteil_Name":"Altstadt","Stadtbezirk_Name":"Mitte","davon deutsch mit 2. StA":"1814"},{"deutsch":"8143","Stichtag":"30.06.2026","Stadtteil_ID":"15","nichtdeutsch":"2754","Stadtbezirk_ID":"1","Stadtteil_Name":"Feldmark","Stadtbezirk_Name":"Mitte","davon deutsch mit 2. StA":"1568"},{"deutsch":"11867","Stichtag":"30.06.2026","Stadtteil_ID":"13","nichtdeutsch":"4474","Stadtbezirk_ID":"1","Stadtteil_Name":"Bismarck","Stadtbezirk_Name":"Mitte","davon deutsch mit 2. StA":"2810"}],"record_count":null,"data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://gelsenkirchen.opendata.ruhr/dataset/924ad5e7-1460-4c69-8453-2bec4a9efce7.rdf","curl":"curl -s 'https://gelsenkirchen.opendata.ruhr/dataset/924ad5e7-1460-4c69-8453-2bec4a9efce7.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/924ad5e7-1460-4c69-8453-2bec4a9efce7/resource/3d7ed688-ca44-4aa5-a24c-79ab4c31a7b9/download/stadt-gelsenkirchen-statistik-bevoelkerung-nationalitaet.csv","curl":"curl -sL 'https://gelsenkirchen.opendata.ruhr/dataset/924ad5e7-1460-4c69-8453-2bec4a9efce7/resource/3d7ed688-ca44-4aa5-a24c-79ab4c31a7b9/download/stadt-gelsenkirchen-statistik-bevoelkerung-nationalitaet.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-07T22:12:42.313Z","run_id":"a75406eb-104a-4d56-86e5-9a3880bafe99","created_at":"2026-07-05T11:47:00.632Z","updated_at":"2026-10-07T22:12:42.313Z","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":"9f10adbcff147a6ecec87a27b7d704a086df3caf27254ccd3f85911916b85792","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":30,"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":true,"live_basis":"This body was produced by executing the request.","created_at":"2026-10-12T22:45:38.893Z","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."}}