{"id":"a1462246-579d-4b71-b59a-c99f87463de7","type":"DATASET","name":"Helsingin kaupungin koulurekisteri","slug":"helsingin-kaupungin-koulurekisteri","description":"**HUOM (1/2026): Koulurekisteri-palvelu on siirretty uudelle alustalle osoitteeseen https://historia.hel.fi/fi/koulurekisteri. Samalla rajapinta on poistunut käytöstä.** Helsingin kaupungin koulurekisteristä löytyy tietoja Helsingin kouluista kaupungin perustamisesta (vuodesta 1550) lähtien. Koul...","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":"https://www.avoindata.fi/data/dataset/helsingin-kaupungin-koulurekisteri","docs_url":"https://www.avoindata.fi/data/dataset/helsingin-kaupungin-koulurekisteri","repo_url":null,"status":"ACTIVE","verification_state":"VERIFIED","tags":[],"logo_url":"https://avoindata.suomi.fi/themes/avoindata/images/logo/apple-touch-icon.png","primary_source_url":"https://api.hel.fi/kore/v1/","extraction_confidence":"0.00","created_at":"2026-07-02T13:44:24.477Z","updated_at":"2026-08-16T13:16:50.404Z","last_verified_at":"2026-08-16T13:16:50.404Z","deprecated_at":null,"ranking_score":51,"last_ranked_at":"2026-08-06T09:23:07.323Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-08-16T12:29:58.067Z","search_vector":"'/fi/koulurekisteri,':81B,197B '/fi/koulurekisteri.':21B,137B '1/2026':10B,126B '1550':37B,56B,153B,172B '2026':68B,184B 'a':191B 'access':60B 'accessible':176B 'alustall':17B 'alustalle':133B 'an':178B 'and':198B,223B 'api':63B,179B 'as':181B 'at':194B 'back':49B,165B 'been':188B,203B 'but':180B 'centuri':103B 'centuries':219B 'citi':4A,52B,97B 'city':120A,168B,213B 'cover':104B 'covering':220B 'dataset':41B,157B 'date':48B 'dating':164B 'develop':94B 'development':210B 'discontinu':88B 'discontinued':204B 'document':91B 'documents':207B 'educ':113B 'education':229B 'establish':109B 'establishment':225B 'former':59B 'formerly':175B 'found':54B 'founding':170B 'has':187B,202B 'helsingin':1A,27B,32B,117A,143B,148B 'helsinki':6A,47B,116B,122A,163B,232B 'histor':93B 'historia.hel.fi':20B,80B,136B,196B 'historia.hel.fi/fi/koulurekisteri,':79B,195B 'historia.hel.fi/fi/koulurekisteri.':19B,135B 'historical':209B 'huom':9B,125B 'in':162B,171B 'individu':105B 'individual':221B 'inform':43B 'information':159B 'interfac':85B 'interface':201B 'it':173B 'januari':67B 'january':183B 'kaupungin':2A,28B,34B,118A,144B,150B 'kaytosta':142B 'koul':39B,155B 'kouluista':33B,149B 'koulurekisteri':3A,12B,119A,128B 'koulurekisteri-palvelu':11B,127B 'koulurekisterista':145B 'koulurekisteristä':29B 'käytöstä':26B 'lahtien':154B 'loytyy':146B 'lähtien':38B 'löytyy':30B 'migrat':73B 'migrated':189B 'municip':112B 'municipal':228B 'network':100B,216B 'new':76B,192B 'of':121A,182B,211B,231B 'on':130B,140B,160B 'origin':84B 'original':200B 'osoitteeseen':18B,134B 'over':217B 'palvelu':13B,129B 'perustamisesta':35B,151B 'platform':77B,193B 'poistunut':25B,141B 'provid':42B 'provides':158B 'rajapinta':23B,139B 'regist':8A,90B 'register':124A,206B 's':169B,214B 'samalla':22B,138B 'school':7A,45B,99B,106B,123A,215B 'schools':161B,222B 'servic':70B 'service':186B 'sever':102B 'several':218B 'siirretti':15B 'siirretty':131B 'system':114B,230B 'the':167B,185B,199B,205B,208B,212B,227B 'their':224B 'this':156B 'tietoja':31B,147B 'to':166B,190B 'uudell':16B 'uudelle':132B 'via':61B,177B 'vuodesta':36B,152B 'was':174B 'within':110B,226B","popularity_score":"0.0000","maintenance_score":"0.7000","institution_id":null,"institution_type":null,"country_code":"FI","official_confidence":0,"proof_summary":"Confidence: 0%","source_seed_url":null,"is_public_sector":true,"published_at":"2026-07-03T17:55:00.000Z","geographic_scope":"NATIONAL","name_en":"City of Helsinki School Register","description_en":"This dataset provides information on schools in Helsinki dating back to the city's founding in 1550. It was formerly accessible via an API, but as of January 2026 the service has been migrated to a new platform at historia.hel.fi/fi/koulurekisteri, and the original interface has been discontinued. The register documents the historical development of the city's school network over several centuries, covering individual schools and their establishment within the municipal education system of Helsinki.","native_lang":"fi","access_level":"direct","formats":["JSON"],"capability_tier":"sample","trust_score":37.23076923076923,"access":{"level":"direct","primary":{"kind":"download","label":"Download JSON","method":"GET","url":"https://api.hel.fi/kore/v1/","format":"JSON","source":"distribution","runnable":true},"actions":[{"kind":"download","label":"Download JSON","method":"GET","url":"https://api.hel.fi/kore/v1/","format":"JSON","source":"distribution","runnable":true},{"kind":"query","label":"Dataset metadata","method":"GET","url":"https://www.avoindata.fi/data/api/3/action/package_show?id=helsingin-kaupungin-koulurekisteri","source":"query_example","runnable":true,"direct":false},{"kind":"landing","label":"Open source page","method":"GET","url":"https://www.avoindata.fi/data/dataset/helsingin-kaupungin-koulurekisteri","source":"landing_page","runnable":false}],"formats":["JSON"]},"maturity":{"entry_id":"a1462246-579d-4b71-b59a-c99f87463de7","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":0,"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":"api.hel.fi","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-08-16T17:09:12.346Z"},"api_details":null,"dataset_details":{"id":"0bea370d-bccb-4e1a-82f9-9376d4ad2edd","entry_id":"a1462246-579d-4b71-b59a-c99f87463de7","upstream_issued":null,"upstream_modified":"2026-01-13T05:14:18.562Z","themes":[],"update_frequency":null,"temporal_start":null,"temporal_end":null,"spatial_coverage":null,"landing_page":"https://www.avoindata.fi/data/dataset/helsingin-kaupungin-koulurekisteri","license_id":null,"license_raw":null,"has_documentation":false,"has_data_dictionary":false,"has_versioning":false,"source_portal":"ckan","source_portal_url":"https://www.avoindata.fi/data","created_at":"2026-07-04T17:56:40.448Z","updated_at":"2026-07-24T04:40:56.582Z","publisher":null,"publisher_url":null,"distributions":[{"id":"dc9d82c2-8a19-42ca-a502-e0ba440feda9","dataset_details_id":"0bea370d-bccb-4e1a-82f9-9376d4ad2edd","title":"REST-rajapinta","description":"REST-rajapinta","access_url":"https://api.hel.fi/kore/v1/","download_url":"https://api.hel.fi/kore/v1/","media_type":null,"format":"json","byte_size":null,"license_id":null,"license_raw":null,"last_checked_at":"2026-08-16T13:16:48.593Z","is_available":true,"last_http_status":200,"created_at":"2026-07-24T04:40:56.071Z","updated_at":"2026-08-16T13:16:48.593Z"}],"license":null},"license":{"id":"cc-by-4.0","spdx_id":"CC-BY-4.0","name":"Creative Commons Attribution 4.0","url":"https://creativecommons.org/licenses/by/4.0/","is_open":true,"is_redistributable":true,"requires_attribution":true,"category":"cc","notes":null,"created_at":"2026-06-12T16:29:19.729Z"},"reuse":{"license_id":"cc-by-4.0","license_name":"Creative Commons Attribution 4.0","license_url":"https://creativecommons.org/licenses/by/4.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":"yes","value":true},"cache_and_mirror":{"status":"yes","value":true},"undetermined":[],"basis":"licence_text","confidence":0.95,"confidence_tier":"high","source_text":"Deed: \"Share - copy and redistribute the material in any medium or format for any purpose, even commercially\" and \"Adapt - remix, transform, and build upon the material for any purpose, even commercially\". Under the following terms: \"Attribution - You must give appropriate credit, provide a link to the license, and indicate if changes were made.\" Notices: \"other rights such as publicity, privacy, or moral rights may limit how you use the material.\" Attribution is the only term listed; no ShareAlike term appears.","source_url":"https://creativecommons.org/licenses/by/4.0/","reviewed_at":null},"license_raw":"http://creativecommons.org/licenses/by/4.0/","latest_check":{"id":"7eafccf1-6c44-4489-b382-51667d3e75ef","entry_id":"a1462246-579d-4b71-b59a-c99f87463de7","status":"VERIFIED","last_checked_at":"2026-08-16T13:16:50.090Z","p50_latency_ms":1680,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-03T02:01:36.822Z","updated_at":"2026-08-16T13:16:50.090Z","consecutive_successes":140,"probe_url":"https://api.hel.fi/kore/v1/","probe_method":"GET","probe_http_status":200,"probe_content_type":"application/json","probe_succeeded_at":"2026-08-16T13:16:50.090Z"},"data_profile":{"id":"07c90353-023f-4b69-82ea-c5e79c1d5280","entry_id":"a1462246-579d-4b71-b59a-c99f87463de7","profile_source":"ckan","profile_kind":"dataset","dataset_id":"helsingin-kaupungin-koulurekisteri","fields":[{"name":"school","type":"text","label":null,"description":null,"description_en":"API endpoint link to the school resource collection."},{"name":"principal","type":"text","label":null,"description":null,"description_en":"API endpoint link to the school principal resource collection."},{"name":"employership","type":"text","label":null,"description":null,"description_en":"API endpoint link to the employership type resource collection."},{"name":"school_field","type":"text","label":null,"description":null,"description_en":"API endpoint link to the school field (subject area) resource collection."},{"name":"school_type","type":"text","label":null,"description":null,"description_en":"API endpoint link to the school type resource collection."},{"name":"language","type":"text","label":null,"description":null,"description_en":"API endpoint link to the teaching language resource collection."},{"name":"building","type":"text","label":null,"description":null,"description_en":"API endpoint link to the building resource collection."},{"name":"school_building","type":"text","label":null,"description":null,"description_en":"API endpoint link to the school-building association resource collection."}],"field_count":8,"sample_records":[{"school":"https://api.hel.fi/kore/v1/school/","building":"https://api.hel.fi/kore/v1/building/","language":"https://api.hel.fi/kore/v1/language/","principal":"https://api.hel.fi/kore/v1/principal/","school_type":"https://api.hel.fi/kore/v1/school_type/","employership":"https://api.hel.fi/kore/v1/employership/","school_field":"https://api.hel.fi/kore/v1/school_field/","school_building":"https://api.hel.fi/kore/v1/school_building/"}],"record_count":null,"data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://www.avoindata.fi/data/api/3/action/package_show?id=helsingin-kaupungin-koulurekisteri","curl":"curl -s 'https://www.avoindata.fi/data/api/3/action/package_show?id=helsingin-kaupungin-koulurekisteri' -H 'Accept: application/json'","label":"Dataset metadata","method":"GET","description":"Full CKAN dataset record: resources, licence, organization, freshness."},{"url":"https://api.hel.fi/kore/v1/","curl":"curl -sL 'https://api.hel.fi/kore/v1/' -o data.json","label":"Download distribution","method":"GET","description":"Full ndjson file download — the schema shown was inferred from the file's first records."}],"status":"ok","error_message":null,"profiled_at":"2026-07-24T04:40:55.561Z","run_id":"3dfb0c39-9c7e-4177-8d06-d2b9b4c2cea5","created_at":"2026-07-17T04:38:03.582Z","updated_at":"2026-08-05T06:12:20.129Z","license_raw":"http://creativecommons.org/licenses/by/4.0/","license_id":"cc-by-4.0","consecutive_failure_count":0,"last_error_at":null,"last_error_message":null,"previewable":true},"datasets":[],"limits":[]}