{"id":"a269b529-994f-4783-9745-58de238e4ec0","type":"DATASET","name":"Oulun kaupungin kiinteistöjen energiankulutus","slug":"oulun-kaupungin-kiinteistjen-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":"UNKNOWN","auth_type":"UNKNOWN","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-07-04T15:52:47.597Z","last_verified_at":"2026-07-04T15:52:47.597Z","deprecated_at":null,"ranking_score":37,"last_ranked_at":"2026-07-03T05:47:46.178Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":null,"search_vector":"'14.1.2020':13B 'aineistoresursseina':27B 'ajalta':15B 'ei':10B 'energiankulutus':4A 'energiankulutusdataa':9B 'energiankulutustiedot':22B 'ja':20B 'jälkeiseltä':14B 'k':32B 'kaupungin':2A,17B 'kiinteistöjen':3A,18B,25B 'kiinteistötaloustietojärjestelmän':5B 'lämmön':21B 'ole':11B 'omat':29B 'oulun':1A,16B 'rajapinnat':30B 'saatavilla':12B 'sekä':23B 'sähkön':19B 'tietoja':24B 'toimittajan':6B 'vaihtumisen':7B 'vedenkulutuksesta':26B 'vuoksi':8B 'vuosi':31B","popularity_score":"0.0000","maintenance_score":"0.9000","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","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":null,"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-04T17:49:52.138Z","distributions":[],"license":null},"latest_check":{"id":"f9d85bb0-06b8-498c-b586-6602d42ea74f","entry_id":"a269b529-994f-4783-9745-58de238e4ec0","status":"VERIFIED","last_checked_at":"2026-07-04T15:52:47.440Z","p50_latency_ms":3502,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-02T22:38:40.509Z","updated_at":"2026-07-04T15:52:47.440Z","consecutive_successes":1},"data_profile":{"id":"e300f6f4-a056-4d57-a4d1-bf49c97971f5","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},{"name":"property_internal_id","type":"text","label":null,"description":null},{"name":"property_name","type":"text","label":null,"description":null},{"name":"consumption_measure","type":"text","label":null,"description":null},{"name":"year","type":"int","label":null,"description":null},{"name":"month","type":"int","label":null,"description":null},{"name":"day","type":"int","label":null,"description":null},{"name":"starting_hour","type":"int","label":null,"description":null},{"name":"consumption","type":"number","label":null,"description":null},{"name":"keyfield","type":"int","label":null,"description":null}],"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-04T17:49:51.640Z","run_id":"33c03130-a046-4571-aabe-19c6de5d0cfd","created_at":"2026-07-02T12:38:55.483Z","updated_at":"2026-07-04T17:49:51.640Z"},"limits":[]}