{"id":"592eabca-1e88-437e-922c-32d1c432dec8","type":"DATASET","name":"Oulun uimavesien laatutiedot","slug":"oulun-uimavesien-laatutiedot","description":"Oulun seudun alueella sijaitsevien yhdeksän EU-rannan, 30 muun yleisen uimarannan sekä kahden leirintäalueen uimarannan vesinäytteiden tulokset. Näytteet otetaan säännöllisesti toukokuun lopulta elokuun loppuun asti. Vuodelta 2016 tiedot XLSX -muodossa ja vuoden 2017 tietoja on saatavilla rajapin...","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":"https://www.avoindata.fi/data/dataset/oulun-uimavesien-laatutiedot","docs_url":"https://www.avoindata.fi/data/dataset/oulun-uimavesien-laatutiedot","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.ouka.fi/v1/swimming_water_quality_stats?order=meas_time.desc,month.desc,day.desc,beach.asc","extraction_confidence":"0.00","created_at":"2026-07-02T12:34:48.277Z","updated_at":"2026-08-16T14:40:01.864Z","last_verified_at":"2026-08-16T14:40:01.864Z","deprecated_at":null,"ranking_score":51,"last_ranked_at":"2026-08-05T08:36:11.665Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-08-03T21:46:09.102Z","search_vector":"'2016':38B,95B,164B,221B '2017':44B,102B,170B,228B '30':19B,69B,145B,195B 'across':118B,244B 'alueella':13B,139B 'an':234B 'and':200B,246B 'api':109B,235B 'are':206B 'area':126B,252B 'asti':36B,162B 'august':92B,218B 'avail':106B 'available':232B 'bath':9A,55B,72B,77B,115B 'bathing':135A,181B,198B,203B,241B 'beach':68B,73B,78B 'beaches':194B,199B,204B 'campsit':76B 'campsite':202B 'classifi':67B 'classified':193B 'collect':81B 'collected':207B 'contain':50B 'containing':176B 'cover':63B 'covering':189B 'data':6A,93B,103B,132A,219B,229B 'dataset':49B,111B,175B,237B 'elokuun':34B,160B 'end':85B,90B,211B,216B 'eu':17B,66B,143B,192B 'eu-classifi':65B 'eu-classified':191B 'eu-rannan':16B,142B 'finland':62B,188B 'for':133A,220B 'format':100B,226B 'from':180B,209B 'in':183B,224B,249B 'is':222B,230B 'ja':42B,168B 'kahden':24B,150B 'laatutiedot':3A,129A 'leirintaalueen':151B 'leirintäalueen':25B 'loppuun':35B,161B 'lopulta':33B,159B 'made':105B,231B 'may':87B,213B 'monitor':113B 'monitoring':239B 'municip':119B 'municipal':245B 'muodossa':41B,167B 'muun':20B,146B 'naytteet':155B 'nine':64B,190B 'näytteet':29B 'of':187B,212B,217B,240B 'on':172B 'otetaan':30B,156B 'other':196B 'oulu':8A,59B,125B,134A,185B,251B 'oulun':1A,11B,127A,137B 'provid':97B 'provided':223B 'public':71B,197B 'qualiti':5A,117B 'quality':131A,243B 'rajapin':48B,174B 'rannan':18B,144B 'recreat':121B 'recreational':247B 'region':60B,186B 'regular':82B 'regularly':208B 'result':53B 'results':179B 'saannollisesti':157B 'saatavilla':47B,173B 'sampl':52B,79B 'sample':178B 'samples':205B 'seka':149B 'sekä':23B 'seudun':12B,138B 'sijaitsevien':14B,140B 'site':56B,122B 'sites':182B,248B 'support':112B 'supports':238B 'säännöllisesti':31B 'the':184B,210B,215B,236B,250B 'through':214B 'tiedot':39B,165B 'tietoja':45B,171B 'toukokuun':32B,158B 'tulokset':28B,154B 'two':75B,201B 'uimarannan':22B,26B,148B,152B 'uimavesien':2A,128A 'vesinaytteiden':153B 'vesinäytteiden':27B 'via':107B,233B 'vuodelta':37B,163B 'vuoden':43B,169B 'water':4A,10A,51B,116B,130A,177B,242B 'waters':136A 'while':227B 'xlsx':40B,99B,166B,225B 'yhdeksan':141B 'yhdeksän':15B 'yleisen':21B,147B","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:44:17.414Z","geographic_scope":"NATIONAL","name_en":"Water quality data for Oulu bathing waters","description_en":"Dataset containing water sample results from bathing sites in the Oulu region of Finland, covering nine EU-classified beaches, 30 other public bathing beaches, and two campsite bathing beaches. Samples are collected regularly from the end of May through the end of August. Data for 2016 is provided in XLSX format, while 2017 data is made available via an API. The dataset supports monitoring of bathing water quality across municipal and recreational sites in the Oulu area.","native_lang":"fi","access_level":"direct","formats":["JSON"],"capability_tier":"live","trust_score":37.23076923076923,"access":{"level":"direct","primary":{"kind":"download","label":"Download JSON","method":"GET","url":"https://api.ouka.fi/v1/swimming_water_quality_stats?order=meas_time.desc,month.desc,day.desc,beach.asc","format":"JSON","source":"distribution","runnable":true},"actions":[{"kind":"download","label":"Download JSON","method":"GET","url":"https://api.ouka.fi/v1/swimming_water_quality_stats?order=meas_time.desc,month.desc,day.desc,beach.asc","format":"JSON","source":"distribution","runnable":true},{"kind":"query","label":"List records","method":"GET","url":"https://www.avoindata.fi/data/api/3/action/datastore_search?resource_id=fec07901-9869-43fc-b250-b4b25cd7a172&limit=20","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"Filter records","method":"GET","url":"https://www.avoindata.fi/data/api/3/action/datastore_search?resource_id=fec07901-9869-43fc-b250-b4b25cd7a172&limit=20&q=%7B%22P%C3%A4iv%C3%A4m%C3%A4%C3%A4r%C3%A4%22%3A%22%3Cvalue%3E%22%7D","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"Dataset metadata","method":"GET","url":"https://www.avoindata.fi/data/api/3/action/package_show?id=oulun-uimavesien-laatutiedot","source":"query_example","runnable":true,"direct":false},{"kind":"landing","label":"Open source page","method":"GET","url":"https://www.avoindata.fi/data/dataset/oulun-uimavesien-laatutiedot","source":"landing_page","runnable":false}],"formats":["JSON"]},"maturity":{"entry_id":"592eabca-1e88-437e-922c-32d1c432dec8","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":"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.ouka.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-16T16:08:11.732Z"},"api_details":null,"dataset_details":{"id":"85301e49-ca9e-4f31-803e-943e23e7e328","entry_id":"592eabca-1e88-437e-922c-32d1c432dec8","upstream_issued":null,"upstream_modified":"2026-03-19T14:24:43.838Z","themes":[],"update_frequency":null,"temporal_start":null,"temporal_end":null,"spatial_coverage":null,"landing_page":"https://www.avoindata.fi/data/dataset/oulun-uimavesien-laatutiedot","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:51:44.845Z","updated_at":"2026-07-24T04:06:45.630Z","publisher":null,"publisher_url":null,"distributions":[{"id":"6c3c58c2-5d8d-41b4-b321-83024c1ade3d","dataset_details_id":"85301e49-ca9e-4f31-803e-943e23e7e328","title":"Uimavesien laatutiedot -rajapinta","description":null,"access_url":"https://api.ouka.fi/v1/swimming_water_quality_stats?order=meas_time.desc,month.desc,day.desc,beach.asc","download_url":"https://api.ouka.fi/v1/swimming_water_quality_stats?order=meas_time.desc,month.desc,day.desc,beach.asc","media_type":null,"format":"json","byte_size":null,"license_id":null,"license_raw":null,"last_checked_at":"2026-08-16T14:40:00.378Z","is_available":true,"last_http_status":200,"created_at":"2026-07-24T04:06:44.837Z","updated_at":"2026-08-16T14:40:00.378Z"},{"id":"983b7ea7-458f-464f-bcea-097722a3655b","dataset_details_id":"85301e49-ca9e-4f31-803e-943e23e7e328","title":"Uimavesien laatutiedot 2016","description":"Aineiston kuvaus: https://www.ouka.fi/c/document_library/get_file?uuid=20420ed1-3d3f-4c9e-b163-2e084ad4ea3e&groupId=50085","access_url":"https://avoindata.suomi.fi/data/dataset/bb676312-454d-4a33-8669-ed2e03eeb621/resource/fec07901-9869-43fc-b250-b4b25cd7a172/download/uimavesien_laatutiedot_2016_uusin.xlsx","download_url":"https://avoindata.suomi.fi/data/dataset/bb676312-454d-4a33-8669-ed2e03eeb621/resource/fec07901-9869-43fc-b250-b4b25cd7a172/download/uimavesien_laatutiedot_2016_uusin.xlsx","media_type":null,"format":"xlsx","byte_size":"20241","license_id":null,"license_raw":null,"last_checked_at":"2026-07-27T08:13:47.439Z","is_available":false,"last_http_status":null,"created_at":"2026-07-24T04:06:45.003Z","updated_at":"2026-07-27T08:13:47.439Z"},{"id":"65dfb568-7db3-4c01-8163-e64240e47242","dataset_details_id":"85301e49-ca9e-4f31-803e-943e23e7e328","title":"Uimavesien laatutietojen kuvaus","description":null,"access_url":"https://avoindata.suomi.fi/data/dataset/bb676312-454d-4a33-8669-ed2e03eeb621/resource/0b6f2c5a-4672-4f4a-a474-05f01844edd0/download/uimavesien-laatutietoa-2016kuvaus.pdf","download_url":"https://avoindata.suomi.fi/data/dataset/bb676312-454d-4a33-8669-ed2e03eeb621/resource/0b6f2c5a-4672-4f4a-a474-05f01844edd0/download/uimavesien-laatutietoa-2016kuvaus.pdf","media_type":null,"format":"pdf","byte_size":"61959","license_id":null,"license_raw":null,"last_checked_at":"2026-07-27T08:14:05.415Z","is_available":false,"last_http_status":null,"created_at":"2026-07-24T04:06:45.160Z","updated_at":"2026-07-27T08:14:05.415Z"}],"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":"c46cf022-5695-45df-ab02-649566183fa0","entry_id":"592eabca-1e88-437e-922c-32d1c432dec8","status":"VERIFIED","last_checked_at":"2026-08-16T14:40:01.696Z","p50_latency_ms":3923,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-02T22:38:40.506Z","updated_at":"2026-08-16T14:40:01.696Z","consecutive_successes":79,"probe_url":"https://api.ouka.fi/v1/swimming_water_quality_stats?order=meas_time.desc,month.desc,day.desc,beach.asc","probe_method":"GET","probe_http_status":200,"probe_content_type":"application/json; charset=utf-8","probe_succeeded_at":"2026-08-16T14:40:01.696Z"},"data_profile":{"id":"020c4fee-63b1-4235-a67a-1a04d8422406","entry_id":"592eabca-1e88-437e-922c-32d1c432dec8","profile_source":"ckan","profile_kind":"dataset","dataset_id":"oulun-uimavesien-laatutiedot","fields":[{"name":"Päivämäärä","type":"timestamp","label":null,"filterable":true,"description":null},{"name":"Ranta","type":"text","label":null,"filterable":true,"description":null},{"name":"Mittauskohde","type":"text","label":null,"filterable":true,"description":null},{"name":"Mittaustulos","type":"text","label":null,"filterable":true,"description":null}],"field_count":4,"sample_records":[{"_id":1,"Ranta":"Kalliomonttu, Kempele","Mittauskohde":"lämpötila ºC","Mittaustulos":"15","Päivämäärä":"2016-06-06T00:00:00"},{"_id":2,"Ranta":"Kalliomonttu, Kempele","Mittauskohde":"E.coli pmy/100 ml","Mittaustulos":"<1","Päivämäärä":"2016-06-06T00:00:00"},{"_id":3,"Ranta":"Kalliomonttu, Kempele","Mittauskohde":"Suolistop. enterokokit pmy/100 ml","Mittaustulos":"<1","Päivämäärä":"2016-06-06T00:00:00"},{"_id":4,"Ranta":"Rantakylä, Liminka","Mittauskohde":"lämpötila ºC","Mittaustulos":"16","Päivämäärä":"2016-06-06T00:00:00"},{"_id":5,"Ranta":"Rantakylä, Liminka","Mittauskohde":"E.coli pmy/100 ml","Mittaustulos":"1","Päivämäärä":"2016-06-06T00:00:00"}],"record_count":"390","data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://www.avoindata.fi/data/api/3/action/package_show?id=oulun-uimavesien-laatutiedot","curl":"curl -s 'https://www.avoindata.fi/data/api/3/action/package_show?id=oulun-uimavesien-laatutiedot' -H 'Accept: application/json'","label":"Dataset metadata","method":"GET","description":"Full CKAN dataset record: resources, licence, organization, freshness."},{"url":"https://www.avoindata.fi/data/api/3/action/datastore_search?resource_id=fec07901-9869-43fc-b250-b4b25cd7a172&limit=20","curl":"curl -s 'https://www.avoindata.fi/data/api/3/action/datastore_search?resource_id=fec07901-9869-43fc-b250-b4b25cd7a172&limit=20' -H 'Accept: application/json'","label":"List records","method":"GET","description":"First 20 rows of the DataStore resource as JSON."},{"url":"https://www.avoindata.fi/data/api/3/action/datastore_search?resource_id=fec07901-9869-43fc-b250-b4b25cd7a172&limit=20&q=%7B%22P%C3%A4iv%C3%A4m%C3%A4%C3%A4r%C3%A4%22%3A%22%3Cvalue%3E%22%7D","curl":"curl -s 'https://www.avoindata.fi/data/api/3/action/datastore_search?resource_id=fec07901-9869-43fc-b250-b4b25cd7a172&limit=20&q=%7B%22P%C3%A4iv%C3%A4m%C3%A4%C3%A4r%C3%A4%22%3A%22%3Cvalue%3E%22%7D' -H 'Accept: application/json'","label":"Filter records","method":"GET","description":"Filter rows where Päivämäärä matches a value (CKAN DataStore q= JSON syntax; filters= takes exact matches)."}],"status":"ok","error_message":null,"profiled_at":"2026-07-24T04:06:44.356Z","run_id":"673c777e-2771-442e-8226-657bc1cea770","created_at":"2026-07-17T03:05:01.176Z","updated_at":"2026-07-24T04:06:44.356Z","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":[]}