Energy consumption of the City of Oulu's propertiesOulun kaupungin kiinteistöjen energiankulutus
Oulun kaupungin kiinteistöjen energiankulutusEnergy consumption of the City of Oulu's properties
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.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...
Trust score
How is this computed?Weighted across five axes. Tap a ring for what it measures.
Data schema (10 fields)
Click a field to see example values.
| Field | Type | Description |
|---|---|---|
| property_idProperty id | int | Numeric identifier of the property.Numeric identifier of the property. |
| property_internal_idProperty internal id | text | Internal reference code of the property.Internal reference code of the property. |
| property_nameProperty name | text | Name of the property, e.g. a building or facility.Name of the property, e.g. a building or facility. |
| consumption_measureConsumption measure | text | Type of energy or resource measured, e.g. electricity or heat.Type of energy or resource measured, e.g. electricity or heat. |
| year | int | Year of the consumption reading.Year of the consumption reading. |
| month | int | Month of the consumption reading.Month of the consumption reading. |
| day | int | Day of the month of the consumption reading.Day of the month of the consumption reading. |
| starting_hourStarting hour | int | Starting hour of the measurement period.Starting hour of the measurement period. |
| consumption | number | Recorded consumption value for the given period.Recorded consumption value for the given period. |
| keyfield | int | Unique identifier for the record.Unique identifier for the record. |
Schema captured from ckan 29 days ago.
Query the data
Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.
Sample data (5 records)
Record 1day: 1 · year: 2019
{
"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"
}Record 2day: 1 · year: 2019
{
"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"
}Record 3day: 1 · year: 2019
{
"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"
}Record 4day: 1 · year: 2019
{
"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"
}Record 5day: 1 · year: 2019
{
"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"
}Live sample captured at profiling time — values may have changed upstream.
Verification Status
Using the API
Query examples
curl -s 'https://www.avoindata.fi/data/api/3/action/package_show?id=oulun-kaupungin-kiinteistojen-energiankulutus' -H 'Accept: application/json'Full CKAN dataset record: resources, licence, organization, freshness.
Dataset
Volume & freshness
License
No license declared upstream.
Distributions (5)
Oulun kaupungin kiinteistöjen energiankulutus tuntitasolla -rajapinta
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=744Oulun kaupungin kiinteistöjen energiankulutus päivätasolla -rajapinta
https://api.ouka.fi/v1/properties_consumption_daily?property_id=eq.629101Oulun kaupungin kiinteistöjen energiankulutus kuukausitasolla -rajapinta
https://api.ouka.fi/v1/properties_meter_consumption_monthlyOulun kaupungin kiinteistöjen energiankulutus vuositasolla -rajapinta
https://api.ouka.fi/v1/properties_consumption_yearlyOulun kaupungin kiinteistöjen energiankulutus vuosina 2010-2016
https://avoindata.suomi.fi/data/dataset/43edfcaf-eff3-4415-958c-f49203e6ee47/resource/feb5721b-f048-459f-9a6c-d2e5abc974a2/download/kiinteistojen_energiakulutus_2010_2016.zip941 KB
Source: ckan · Open original page
Machine-readable & source
Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.