{"id":"a269b529-994f-4783-9745-58de238e4ec0","type":"DATASET","name":"Oulun kaupungin kiinteistöjen energiankulutus","slug":"oulun-kaupungin-kiinteistojen-energiankulutus","description":"Kiinteistötaloustietojärjestelmän toimittajan vaihtumisen vuoksi energiankulutusdataa ei ole saatavilla 14.1.2020 jälkeiseltä ajalta. Oulun kaupungin kiinteistöjen sähkön ja lämmön energiankulutustiedot sekä tietoja kiinteistöjen vedenkulutuksesta. Aineistoresursseina on omat rajapinnat vuosi-, k...","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":"https://www.avoindata.fi/data/dataset/oulun-kaupungin-kiinteistojen-energiankulutus","docs_url":"https://www.avoindata.fi/data/dataset/oulun-kaupungin-kiinteistojen-energiankulutus","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/properties_consumption_hourly?property_id=eq.629101&year=eq.2019&month=eq.12&consumption_measure=eq.S%C3%A4hk%C3%B6&order=day.asc,starting_hour.asc&limit=744","extraction_confidence":"0.00","created_at":"2026-07-02T12:34:55.495Z","updated_at":"2026-08-22T16:09:17.923Z","last_verified_at":"2026-08-22T16:09:17.923Z","deprecated_at":null,"ranking_score":51,"last_ranked_at":"2026-08-22T05:33:41.789Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-08-16T12:30:01.954Z","search_vector":"'14':102B,217B '14.1.2020':22B,137B '2020':104B,219B 'a':196B 'after':216B 'aineistoresursseina':36B,151B 'ajalta':24B,139B 'and':160B,190B 'as':165B,167B 'avail':97B 'available':212B 'avoindata.fi':115B,230B 'by':174B 'chang':82B 'change':197B 'citi':9A,61B 'city':124A,176B 'consumpt':6A,48B,54B,93B 'consumption':121A,163B,169B,208B 'data':49B,66B,90B,94B,113B,164B,181B,205B,209B,228B 'dataset':42B,106B,157B,221B 'due':79B,194B 'ei':19B,134B 'electr':44B 'electricity':159B 'energi':5A,47B,92B 'energiankulutus':4A,119A 'energiankulutusdataa':18B,133B 'energiankulutustiedot':31B,146B 'energy':120A,162B,207B 'finland':64B,110B,179B,225B 'for':171B,187B,213B 'heat':46B,161B 'in':198B 'inform':55B 'information':170B 'interfac':71B 'interfaces':186B 'is':182B,210B,222B 'ja':29B,144B 'jalkeiselta':138B 'januari':103B 'january':218B 'jälkeiseltä':23B 'k':41B,156B 'kaupungin':2A,26B,117A,141B 'kiinteistojen':118A,142B,149B 'kiinteistotaloustietojarjestelman':129B 'kiinteistöjen':3A,27B,34B 'kiinteistötaloustietojärjestelmän':14B 'lammon':145B 'lämmön':30B 'manag':89B 'management':204B 'month':74B 'monthly':189B 'not':211B 'of':122A,125A,177B,201B 'ole':20B,135B 'omat':38B,153B 'on':152B 'open':112B,227B 'organ':68B 'organized':183B 'other':191B 'oulu':11A,63B,126A,178B 'oulun':1A,25B,116A,140B 'own':58B 'owned':173B 'period':78B,100B,215B 'periods':193B 'portal':114B,229B 'properti':13A,57B,88B 'properties':128A,172B 'property':203B 'provid':43B 'providing':158B 'publish':108B 'published':223B 'rajapinnat':39B,154B 'report':77B 'reporting':192B 's':127A,226B 'saatavilla':21B,136B 'sahkon':143B 'seka':147B 'sekä':32B 'separ':70B 'separate':185B 'supplier':85B,200B 'system':91B,206B 'sähkön':28B 'the':123A,175B,180B,199B,202B,214B,220B 'through':184B 'tietoja':33B,148B 'to':195B 'toimittajan':15B,130B 'vaihtumisen':16B,131B 'vedenkulutuksesta':35B,150B 'via':109B,224B 'vuoksi':17B,132B 'vuosi':40B,155B 'water':53B,168B 'well':51B,166B 'year':73B 'yearly':188B","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-02T18:25:13.982Z","geographic_scope":"NATIONAL","name_en":"Energy consumption of the City of Oulu's properties","description_en":"Dataset providing electricity and heat energy consumption data, as well as water consumption information, for properties owned by the City of Oulu, Finland. The data is organized through separate interfaces for yearly, monthly and other reporting periods. Due to a change in the supplier of the property management data system, energy consumption data is not available for the period after 14 January 2020. The dataset is published via Finland's open data portal avoindata.fi.","native_lang":"fi","access_level":"direct","formats":["JSON","XLSX"],"capability_tier":"sample","trust_score":37.23076923076923,"access":{"level":"direct","primary":{"kind":"download","label":"Download JSON","method":"GET","url":"https://api.ouka.fi/v1/properties_consumption_hourly?property_id=eq.629101&year=eq.2019&month=eq.12&consumption_measure=eq.S%C3%A4hk%C3%B6&order=day.asc,starting_hour.asc&limit=744","format":"JSON","source":"distribution","runnable":true},"actions":[{"kind":"download","label":"Download JSON","method":"GET","url":"https://api.ouka.fi/v1/properties_consumption_hourly?property_id=eq.629101&year=eq.2019&month=eq.12&consumption_measure=eq.S%C3%A4hk%C3%B6&order=day.asc,starting_hour.asc&limit=744","format":"JSON","source":"distribution","runnable":true},{"kind":"download","label":"Download JSON","method":"GET","url":"https://api.ouka.fi/v1/properties_consumption_daily?property_id=eq.629101","format":"JSON","source":"distribution","runnable":true},{"kind":"download","label":"Download JSON","method":"GET","url":"https://api.ouka.fi/v1/properties_meter_consumption_monthly","format":"JSON","source":"distribution","runnable":true},{"kind":"download","label":"Download JSON","method":"GET","url":"https://api.ouka.fi/v1/properties_consumption_yearly","format":"JSON","source":"distribution","runnable":true},{"kind":"download","label":"Download XLSX","method":"GET","url":"https://avoindata.suomi.fi/data/dataset/43edfcaf-eff3-4415-958c-f49203e6ee47/resource/feb5721b-f048-459f-9a6c-d2e5abc974a2/download/kiinteistojen_energiakulutus_2010_2016.zip","format":"XLSX","byte_size":"963746","source":"distribution","runnable":true},{"kind":"query","label":"Dataset metadata","method":"GET","url":"https://www.avoindata.fi/data/api/3/action/package_show?id=oulun-kaupungin-kiinteistojen-energiankulutus","source":"query_example","runnable":true,"direct":false},{"kind":"landing","label":"Open source page","method":"GET","url":"https://www.avoindata.fi/data/dataset/oulun-kaupungin-kiinteistojen-energiankulutus","source":"landing_page","runnable":false}],"formats":["JSON","XLSX"]},"maturity":{"entry_id":"a269b529-994f-4783-9745-58de238e4ec0","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.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-22T20:05:18.281Z"},"api_details":null,"dataset_details":{"id":"f4360042-027f-49cf-83a7-a2fffd23eae3","entry_id":"a269b529-994f-4783-9745-58de238e4ec0","upstream_issued":null,"upstream_modified":"2026-03-18T10:43:24.123Z","themes":[],"update_frequency":null,"temporal_start":null,"temporal_end":null,"spatial_coverage":null,"landing_page":"https://www.avoindata.fi/data/dataset/oulun-kaupungin-kiinteistojen-energiankulutus","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:49:52.138Z","updated_at":"2026-07-24T13:37:08.527Z","publisher":null,"publisher_url":null,"distributions":[{"id":"e754cc4e-c881-436b-84ce-0086d585fd7d","dataset_details_id":"f4360042-027f-49cf-83a7-a2fffd23eae3","title":"Oulun kaupungin kiinteistöjen energiankulutus tuntitasolla -rajapinta","description":"Oulun kaupungin kiinteistöjen sähkön ja lämmön kulutustietojen rajapinta tuntikohtaisesti ilmoitettuna. Tämän aineistoresurssin osoite listaa esimerkkinä Oulun uimahallin sähkönkulutustiedot tunnettain joulukuun 2019 osalta. Osoitteessa olevia parametritietoja voidaan vaihtaa, jolloin saadaan listaus tietyn kiinteistön ja halutun aikavälin osalta. Näytettäväksi voidaan myös vaihtaa sähkön sijaan lämmön kulutuksen tuntikohtaiset tiedot. Osoitteeseen vaihdettavat parametrit ovat seuraavat:\r\n\r\nproperty_id=eq.629101 (vaihda kuusinumeroinen kiinteistön id-numero)\r\n\r\nyear=eq.2019 (vaihda nelinumeroinen vuosiluku)\r\n\r\nmonth=eq.12 (vaihda yksi- tai kaksinumeroinen kuukausiluku, 1=tammikuu, 12=joulukuu)\r\n\r\nconsumption_measure=eq.Sähkö (vaihda merkkijono Sähkö > Lämpö, jos haluat tiedot sähkön sijaan lämmön kulutuksesta)\r\n\r\nday.asc (vaihda merkkijono asc > desc, jos haluat päivät laskevassa järjestyksessä)\r\n\r\nstarting_hour.asc (vaihda merkkijono asc > desc, jos haluat tunnit laskevassa järjestyksessä)\r\n\r\nlimit=744 (vaihda numeron 744 tilalle haluamasi arvo havaintotuntien lukumääräksi, 31-päiväisen kuukauden tuntimäärä: 31x24=744)\r\n\r\n\r\nRajapintaohje https://api.ouka.fi/ohje/index.html#properties_consumption_hourly.","access_url":"https://api.ouka.fi/v1/properties_consumption_hourly?property_id=eq.629101&year=eq.2019&month=eq.12&consumption_measure=eq.S%C3%A4hk%C3%B6&order=day.asc,starting_hour.asc&limit=744","download_url":"https://api.ouka.fi/v1/properties_consumption_hourly?property_id=eq.629101&year=eq.2019&month=eq.12&consumption_measure=eq.S%C3%A4hk%C3%B6&order=day.asc,starting_hour.asc&limit=744","media_type":null,"format":"json","byte_size":null,"license_id":null,"license_raw":null,"last_checked_at":"2026-08-22T16:09:16.543Z","is_available":true,"last_http_status":200,"created_at":"2026-07-24T13:37:07.398Z","updated_at":"2026-08-22T16:09:16.543Z"},{"id":"bb94d869-baf8-4338-bfb7-564feb91bfad","dataset_details_id":"f4360042-027f-49cf-83a7-a2fffd23eae3","title":"Oulun kaupungin kiinteistöjen energiankulutus päivätasolla -rajapinta","description":"Oulun kaupungin kiinteistöjen sähkön ja lämmön kulutustietojen rajapinta päiväkohtaisesti ilmoitettuna. Rajapintaosoitteen kuusi viimeistä merkkiä sisältävät kiinteistön id-numeron. Tässä esimerkkiosoitteessa on listattu Oulun uimahallin (id-numero = 629101) päiväkohtaiset sähkön ja lämmön kulutustiedot (kWh) 1.1.2016 alkaen. Tietyn kiinteistön kulutustiedot saadaan vaihtamalla osoitteen kuusi viimeistä merkkiä kyseisen kiinteistön id-numeron mukaiseksi.  Kiinteistökohtaiset id-numerot ja kiinteistöjen muut perustiedot on haettavissa dataportaalin \"Oulun kaupungin kiinteistöjen perustiedot\" -aineistosta.\r\n\r\nYksittäisen kiinteistön päiväkohtaiset tiedot tietyn kuukauden osalta saa listattua rajapintaosoitteella https://api.ouka.fi/v1/properties_consumption_daily?property_id=eq.629101&year=eq.2018&month=eq.1&order=consumption_measure.asc,day.desc. Tässä osoite-esimerkissä on listattu Oulun uimahallin (id=eq.629101) vuoden 2018 (year=eq.2018) tammikuun (month=eq.1) päiväkohtaiset sähkön ja lämmön kulutustiedot. Osoitteessa oleva id-numero, vuosi ja/tai kuukausi voidaan vaihtaa halutun kiinteistön ja ajankohdan mukaisiksi.\r\n\r\nRajapintaohje https://api.ouka.fi/ohje/index.html#properties_consumption_daily.","access_url":"https://api.ouka.fi/v1/properties_consumption_daily?property_id=eq.629101","download_url":"https://api.ouka.fi/v1/properties_consumption_daily?property_id=eq.629101","media_type":null,"format":"json","byte_size":null,"license_id":null,"license_raw":null,"last_checked_at":null,"is_available":null,"last_http_status":null,"created_at":"2026-07-24T13:37:07.565Z","updated_at":"2026-07-24T13:37:07.565Z"},{"id":"6026a24f-5d29-4cde-9549-40640ff2f47f","dataset_details_id":"f4360042-027f-49cf-83a7-a2fffd23eae3","title":"Oulun kaupungin kiinteistöjen energiankulutus kuukausitasolla -rajapinta","description":"Oulun kaupungin kiinteistöjen sähkön, lämmön ja veden kulutustietojen rajapinta kuukausitasoilla ilmoitettuna. Rajapinta sisältää kiinteistöjen id-numeron, nimen, osoitteen, sähkön kulutustiedon (kWh), lämmön kulutustiedon (kWh), veden kulutustiedon (m3), tarkasteluvuoden ja tarkastelukuukauden. Tietoja on saatavilla vuodesta 2015 lähtien.\r\n\r\nYksittäisen kiinteistökohteen kuukausittaiset tiedot yhdeltä tarkasteluvuodelta saa listattua osoitteella https://api.ouka.fi/v1/properties_meter_consumption_monthly?property_id=eq.629101&year=eq.2018&order=consumption_measure.asc,month.desc. Osoitteeseen voi vaihtaa kiinteistön id-numeron (kuusinumeroinen merkkijono osoitteen keskellä) ja tarkasteluvuoden (nelinumeroinen merkkijono osoitteen keskellä). Kiinteistökohtaiset id-numerot ja kiinteistöjen muut perustiedot on ilmoitettu dataportaalin \"Oulun kaupungin kiinteistöjen perustiedot\" -aineistossa. Edellämainittu esimerkkiosoite näyttää Oulun uimahallin kuukausikohtaiset kulutustiedot vuonna 2018.\r\n\r\nRajapintaohje https://api.ouka.fi/ohje/index.html#properties_meter_consumption_monthly.","access_url":"https://api.ouka.fi/v1/properties_meter_consumption_monthly","download_url":"https://api.ouka.fi/v1/properties_meter_consumption_monthly","media_type":null,"format":"json","byte_size":null,"license_id":null,"license_raw":null,"last_checked_at":null,"is_available":null,"last_http_status":null,"created_at":"2026-07-24T13:37:07.721Z","updated_at":"2026-07-24T13:37:07.721Z"},{"id":"6be47a21-21cf-4fb0-afee-230529b65a8e","dataset_details_id":"f4360042-027f-49cf-83a7-a2fffd23eae3","title":"Oulun kaupungin kiinteistöjen energiankulutus vuositasolla -rajapinta","description":"Oulun kaupungin kiinteistöjen sähkön, lämmön ja veden kulutustietojen rajapinta vuositasoilla ilmoitettuna. Rajapinta sisältää kiinteistöjen id-numeron, nimen, sähkön kulutustiedon (kWh), lämmön kulutustiedon (kWh), veden kulutustiedon (m3) ja tarkasteluvuoden. Tietoja on saatavilla vuodesta 2015 lähtien.\r\n\r\nVuosikohtaiset tiedot kaikista kiinteistöistä saa listattua osoitteella https://api.ouka.fi/v1/properties_consumption_yearly?year=eq.2018. Osoitteeseen voi vaihtaa tarkasteluvuoden (neljä viimeistä merkkiä).\r\n\r\nYksittäisen kiinteistökohteen tiedot yhdeltä tarkasteluvuodelta saa listattua osoitteella https://api.ouka.fi/v1/properties_consumption_yearly?property_id=eq.629101&year=eq.2018. Osoitteeseen voi vaihtaa kiinteistön id-numeron (kuusinumeroinen merkkijono osoitteen loppupuolella) ja tarkasteluvuoden (neljä viimeistä merkkiä). Kiinteistökohtaiset id-numerot ja kiinteistöjen muut perustiedot on ilmoitettu dataportaalin \"Oulun kaupungin kiinteistöjen perustiedot\" -aineistossa. Edellämainittu esimerkkiosoite näyttää Oulun uimahallin vuosikohtaiset kulutustiedot vuonna 2018.\r\n\r\nRajapintaohje https://api.ouka.fi/ohje/index.html#properties_consumption_yearly.","access_url":"https://api.ouka.fi/v1/properties_consumption_yearly","download_url":"https://api.ouka.fi/v1/properties_consumption_yearly","media_type":null,"format":"json","byte_size":null,"license_id":null,"license_raw":null,"last_checked_at":null,"is_available":null,"last_http_status":null,"created_at":"2026-07-24T13:37:07.885Z","updated_at":"2026-07-24T13:37:07.885Z"},{"id":"9dc3243d-6c0c-4bfb-9c02-96d9cf28bc05","dataset_details_id":"f4360042-027f-49cf-83a7-a2fffd23eae3","title":"Oulun kaupungin kiinteistöjen energiankulutus vuosina 2010-2016","description":"Oulun kaupungin kiinteistöjen energiankulutustiedot; sähkön, veden ja lämmön kulutus (normeerattu) kuukausittain vuosilta 2010-2016. L = Lämpö, V = Vesi, S = Sähkö. Vuoden 2017 alusta lähtien kiinteistöjen energiankulutustietoja ei enää julkaista Excel-muotoisena, vaan tiedot on saatavilla avoimena rajapintana.","access_url":"https://avoindata.suomi.fi/data/dataset/43edfcaf-eff3-4415-958c-f49203e6ee47/resource/feb5721b-f048-459f-9a6c-d2e5abc974a2/download/kiinteistojen_energiakulutus_2010_2016.zip","download_url":"https://avoindata.suomi.fi/data/dataset/43edfcaf-eff3-4415-958c-f49203e6ee47/resource/feb5721b-f048-459f-9a6c-d2e5abc974a2/download/kiinteistojen_energiakulutus_2010_2016.zip","media_type":null,"format":"xlsx","byte_size":"963746","license_id":null,"license_raw":null,"last_checked_at":null,"is_available":null,"last_http_status":null,"created_at":"2026-07-24T13:37:08.047Z","updated_at":"2026-07-24T13:37:08.047Z"}],"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":"f9d85bb0-06b8-498c-b586-6602d42ea74f","entry_id":"a269b529-994f-4783-9745-58de238e4ec0","status":"VERIFIED","last_checked_at":"2026-08-22T16:09:17.628Z","p50_latency_ms":3729,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-02T22:38:40.509Z","updated_at":"2026-08-22T16:09:17.628Z","consecutive_successes":169,"probe_url":"https://api.ouka.fi/v1/properties_consumption_hourly?property_id=eq.629101&year=eq.2019&month=eq.12&consumption_measure=eq.S%C3%A4hk%C3%B6&order=day.asc,starting_hour.asc&limit=744","probe_method":"GET","probe_http_status":200,"probe_content_type":"application/json; charset=utf-8","probe_succeeded_at":"2026-08-22T16:09:17.628Z"},"data_profile":{"id":"e86a6992-3315-4b43-999e-a6a5eb388540","entry_id":"a269b529-994f-4783-9745-58de238e4ec0","profile_source":"ckan","profile_kind":"dataset","dataset_id":"oulun-kaupungin-kiinteistojen-energiankulutus","fields":[{"name":"property_id","type":"int","label":null,"description":null,"description_en":"Numeric identifier of the property."},{"name":"property_internal_id","type":"text","label":null,"description":null,"description_en":"Internal reference code of the property."},{"name":"property_name","type":"text","label":null,"description":null,"description_en":"Name of the property, e.g. a building or facility."},{"name":"consumption_measure","type":"text","label":null,"description":null,"description_en":"Type of energy or resource measured, e.g. electricity or heat."},{"name":"year","type":"int","label":null,"description":null,"description_en":"Year of the consumption reading."},{"name":"month","type":"int","label":null,"description":null,"description_en":"Month of the consumption reading."},{"name":"day","type":"int","label":null,"description":null,"description_en":"Day of the month of the consumption reading."},{"name":"starting_hour","type":"int","label":null,"description":null,"description_en":"Starting hour of the measurement period."},{"name":"consumption","type":"number","label":null,"description":null,"description_en":"Recorded consumption value for the given period."},{"name":"keyfield","type":"int","label":null,"description":null,"description_en":"Unique identifier for the record."}],"field_count":10,"sample_records":[{"day":"1","year":"2019","month":"12","keyfield":"146171941","consumption":"150.0000","property_id":"629101","property_name":"Oulun uimahalli","starting_hour":"00","consumption_measure":"Sähkö","property_internal_id":"R0308"},{"day":"1","year":"2019","month":"12","keyfield":"146185742","consumption":"158.0000","property_id":"629101","property_name":"Oulun uimahalli","starting_hour":"01","consumption_measure":"Sähkö","property_internal_id":"R0308"},{"day":"1","year":"2019","month":"12","keyfield":"146201367","consumption":"160.0000","property_id":"629101","property_name":"Oulun uimahalli","starting_hour":"02","consumption_measure":"Sähkö","property_internal_id":"R0308"},{"day":"1","year":"2019","month":"12","keyfield":"146214510","consumption":"174.0000","property_id":"629101","property_name":"Oulun uimahalli","starting_hour":"03","consumption_measure":"Sähkö","property_internal_id":"R0308"},{"day":"1","year":"2019","month":"12","keyfield":"146228926","consumption":"188.0000","property_id":"629101","property_name":"Oulun uimahalli","starting_hour":"04","consumption_measure":"Sähkö","property_internal_id":"R0308"}],"record_count":null,"data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://www.avoindata.fi/data/api/3/action/package_show?id=oulun-kaupungin-kiinteistojen-energiankulutus","curl":"curl -s 'https://www.avoindata.fi/data/api/3/action/package_show?id=oulun-kaupungin-kiinteistojen-energiankulutus' -H 'Accept: application/json'","label":"Dataset metadata","method":"GET","description":"Full CKAN dataset record: resources, licence, organization, freshness."},{"url":"https://api.ouka.fi/v1/properties_consumption_hourly?property_id=eq.629101&year=eq.2019&month=eq.12&consumption_measure=eq.S%C3%A4hk%C3%B6&order=day.asc,starting_hour.asc&limit=744","curl":"curl -sL 'https://api.ouka.fi/v1/properties_consumption_hourly?property_id=eq.629101&year=eq.2019&month=eq.12&consumption_measure=eq.S%C3%A4hk%C3%B6&order=day.asc,starting_hour.asc&limit=744' -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-07-24T13:37:06.914Z","run_id":"9487e7b3-603b-4edf-9031-8d5325a6e2e5","created_at":"2026-07-17T13:36:18.369Z","updated_at":"2026-08-05T06:14:46.215Z","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":[],"manifest":{"answer_sha256":"bc84b1c5da3044949194f5d14462fb6c6ae1c736750d7e192eeb983efc7ba3dd","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":36,"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[] (10 rows).","live":true,"live_basis":"This body was produced by executing the request.","created_at":"2026-08-22T20:05:18.535Z","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."}}