c0mm0.com — the continuously verified register of European data

Register record·DATASET·PTVERIFIED · checked 2h ago
C

Water consumptionConsumo de água

Consumo de águaWater consumption

DatasetProfiled3/7PreviewSubscribe🇵🇹Portugal
Website (opens an external site)Docs (opens an external site)

This dataset provides figures on average water consumption per customer, expressed in cubic metres. It covers a set of Portuguese municipalities, including Alvaiázere, Ansião, Castanheira de Pera, Figueiró dos Vinhos, Góis, Pampilhosa da Serra, Penela, Pedrógão Grande, Lousã and Vila Nova de (municipality name truncated in source). The data is published as part of Portugal's open data portal (dados.gov.pt) and offers a municipal-level view of domestic or general water use, useful for tracking consumption patterns across this group of central Portuguese municipalities over time.O Conjunto de dados contem informação relativo ao consumo médio de água por cliente em m3. A granularidade espacial do conjunto de dados abrange os municípios de Alvaiázere, Ansião, Castanheira de Pera, Figueiró dos Vinhos, Góis, Pampilhosa da Serra, Penela, Pedrogão Grande, Lousã e Vila Nova de...

⬇ Download CSVRead the docs

Trust score

How is this computed?
39
poor

Weighted across five axes. Tap a ring for what it measures.

Data schema (12 fields)

Click a field to see example values.

FieldTypeDescription
idtextUnique NGSI-LD identifier for the water consumption observation.Unique NGSI-LD identifier for the water consumption observation.
typetextEntity type, here WaterConsumptionObserved.Entity type, here WaterConsumptionObserved.
dateObservedDate observedtextDate and time when the water consumption was recorded.Date and time when the water consumption was recorded.
waterConsumptionWater consumptiontextMeasured water consumption value, in cubic metres.Measured water consumption value, in cubic metres.
locationtextGeographic coordinates of the water meter or connection point.Geographic coordinates of the water meter or connection point.
addresstextPostal address, district and region of the water connection.Postal address, district and region of the water connection.
waterTypeWater typetextType of water supplied, such as cold or hot.Type of water supplied, such as cold or hot.
alarmStopsLeaksAlarm stops leakstextIndicates whether a leak-stop alarm has been triggered.Indicates whether a leak-stop alarm has been triggered.
alarmTamperAlarm tampertextIndicates whether a meter tampering alarm has been triggered.Indicates whether a meter tampering alarm has been triggered.
alarmWaterQualityAlarm water qualitytextIndicates whether a water quality alarm has been triggered.Indicates whether a water quality alarm has been triggered.
alarmInProgressAlarm in progresstextIndicates whether an alarm is currently active.Indicates whether an alarm is currently active.
@contexttextJSON-LD context defining the vocabulary used in the entity.JSON-LD context defining the vocabulary used in the entity.

Schema inferred from the distribution file's first records 3 days ago. Column types are sampled estimates, not source-declared.

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 1id: urn:apin:WaterConsumptionObserved:1 · type: WaterConsumptionObserved
{
  "id": "urn:apin:WaterConsumptionObserved:1",
  "type": "WaterConsumptionObserved",
  "address": "{\"type\": \"Property\", \"value\": {\"district\": \"Leiria\", \"addressRegion\": \"Centro\", \"addressCountry\": \"Portugal\", \"addressLocality\": \"ANSIÃO\"}}",
  "@context": "[\"https://uri.etsi.org/ngsi-ld/v1/ngsi-ld-core-context.jsonld\", \"https://raw.githubusercontent.com/smart-data-models/dataModel.WaterConsumption/master/context.jsonld\"]",
  "location": "{\"type\": \"GeoProperty\", \"value\": {\"type\": \"Point\", \"coordinates\": [-8.457645737, 39.878927644]}}",
  "waterType": "{\"type\": \"Property\", \"value\": \"cold\"}",
  "alarmTamper": "{\"type\": \"Property\", \"value\": 0}",
  "dateObserved": "{\"type\": \"Property\", \"value\": {\"@type\": \"DateTime\", \"@value\": \"2025-12-31T23:59:59.000Z\"}}",
  "alarmInProgress": "{\"type\": \"Property\", \"value\": 0}",
  "alarmStopsLeaks": "{\"type\": \"Property\", \"value\": 0}",
  "waterConsumption": "{\"type\": \"Property\", \"value\": 0, \"unitCode\": \"MTQ\"}",
  "alarmWaterQuality": "{\"type\": \"Property\", \"value\": 0}"
}
Record 2id: urn:apin:WaterConsumptionObserved:2 · type: WaterConsumptionObserved
{
  "id": "urn:apin:WaterConsumptionObserved:2",
  "type": "WaterConsumptionObserved",
  "address": "{\"type\": \"Property\", \"value\": {\"district\": \"Leiria\", \"addressRegion\": \"Centro\", \"addressCountry\": \"Portugal\", \"addressLocality\": \"ANSIÃO\"}}",
  "@context": "[\"https://uri.etsi.org/ngsi-ld/v1/ngsi-ld-core-context.jsonld\", \"https://raw.githubusercontent.com/smart-data-models/dataModel.WaterConsumption/master/context.jsonld\"]",
  "location": "{\"type\": \"GeoProperty\", \"value\": {\"type\": \"Point\", \"coordinates\": [-8.3702267, 39.8905817]}}",
  "waterType": "{\"type\": \"Property\", \"value\": \"cold\"}",
  "alarmTamper": "{\"type\": \"Property\", \"value\": 0}",
  "dateObserved": "{\"type\": \"Property\", \"value\": {\"@type\": \"DateTime\", \"@value\": \"2025-12-31T23:59:59.000Z\"}}",
  "alarmInProgress": "{\"type\": \"Property\", \"value\": 0}",
  "alarmStopsLeaks": "{\"type\": \"Property\", \"value\": 0}",
  "waterConsumption": "{\"type\": \"Property\", \"value\": 1, \"unitCode\": \"MTQ\"}",
  "alarmWaterQuality": "{\"type\": \"Property\", \"value\": 0}"
}
Record 3id: urn:apin:WaterConsumptionObserved:4 · type: WaterConsumptionObserved
{
  "id": "urn:apin:WaterConsumptionObserved:4",
  "type": "WaterConsumptionObserved",
  "address": "{\"type\": \"Property\", \"value\": {\"district\": \"Leiria\", \"addressRegion\": \"Centro\", \"addressCountry\": \"Portugal\", \"addressLocality\": \"ANSIÃO\"}}",
  "@context": "[\"https://uri.etsi.org/ngsi-ld/v1/ngsi-ld-core-context.jsonld\", \"https://raw.githubusercontent.com/smart-data-models/dataModel.WaterConsumption/master/context.jsonld\"]",
  "location": "{\"type\": \"GeoProperty\", \"value\": {\"type\": \"Point\", \"coordinates\": [-8.483177014, 39.92019014]}}",
  "waterType": "{\"type\": \"Property\", \"value\": \"cold\"}",
  "alarmTamper": "{\"type\": \"Property\", \"value\": 0}",
  "dateObserved": "{\"type\": \"Property\", \"value\": {\"@type\": \"DateTime\", \"@value\": \"2025-12-31T23:59:59.000Z\"}}",
  "alarmInProgress": "{\"type\": \"Property\", \"value\": 0}",
  "alarmStopsLeaks": "{\"type\": \"Property\", \"value\": 0}",
  "waterConsumption": "{\"type\": \"Property\", \"value\": 6, \"unitCode\": \"MTQ\"}",
  "alarmWaterQuality": "{\"type\": \"Property\", \"value\": 0}"
}
Record 4id: urn:apin:WaterConsumptionObserved:5 · type: WaterConsumptionObserved
{
  "id": "urn:apin:WaterConsumptionObserved:5",
  "type": "WaterConsumptionObserved",
  "address": "{\"type\": \"Property\", \"value\": {\"district\": \"Leiria\", \"addressRegion\": \"Centro\", \"addressCountry\": \"Portugal\", \"addressLocality\": \"ANSIÃO\"}}",
  "@context": "[\"https://uri.etsi.org/ngsi-ld/v1/ngsi-ld-core-context.jsonld\", \"https://raw.githubusercontent.com/smart-data-models/dataModel.WaterConsumption/master/context.jsonld\"]",
  "location": "{\"type\": \"GeoProperty\", \"value\": {\"type\": \"Point\", \"coordinates\": [-8.3913195, 39.8926182]}}",
  "waterType": "{\"type\": \"Property\", \"value\": \"cold\"}",
  "alarmTamper": "{\"type\": \"Property\", \"value\": 0}",
  "dateObserved": "{\"type\": \"Property\", \"value\": {\"@type\": \"DateTime\", \"@value\": \"2025-12-31T23:59:59.000Z\"}}",
  "alarmInProgress": "{\"type\": \"Property\", \"value\": 0}",
  "alarmStopsLeaks": "{\"type\": \"Property\", \"value\": 0}",
  "waterConsumption": "{\"type\": \"Property\", \"value\": 8, \"unitCode\": \"MTQ\"}",
  "alarmWaterQuality": "{\"type\": \"Property\", \"value\": 0}"
}
Record 5id: urn:apin:WaterConsumptionObserved:13 · type: WaterConsumptionObserved
{
  "id": "urn:apin:WaterConsumptionObserved:13",
  "type": "WaterConsumptionObserved",
  "address": "{\"type\": \"Property\", \"value\": {\"district\": \"Leiria\", \"addressRegion\": \"Centro\", \"addressCountry\": \"Portugal\", \"addressLocality\": \"ANSIÃO\"}}",
  "@context": "[\"https://uri.etsi.org/ngsi-ld/v1/ngsi-ld-core-context.jsonld\", \"https://raw.githubusercontent.com/smart-data-models/dataModel.WaterConsumption/master/context.jsonld\"]",
  "location": "{\"type\": \"GeoProperty\", \"value\": {\"type\": \"Point\", \"coordinates\": [-8.3571111, 39.9226095]}}",
  "waterType": "{\"type\": \"Property\", \"value\": \"cold\"}",
  "alarmTamper": "{\"type\": \"Property\", \"value\": 0}",
  "dateObserved": "{\"type\": \"Property\", \"value\": {\"@type\": \"DateTime\", \"@value\": \"2025-12-31T23:59:59.000Z\"}}",
  "alarmInProgress": "{\"type\": \"Property\", \"value\": 0}",
  "alarmStopsLeaks": "{\"type\": \"Property\", \"value\": 0}",
  "waterConsumption": "{\"type\": \"Property\", \"value\": 10, \"unitCode\": \"MTQ\"}",
  "alarmWaterQuality": "{\"type\": \"Property\", \"value\": 0}"
}

Live sample captured at profiling time — values may have changed upstream.

Verification Status

Using the API

Query examples

curl -sL 'https://api-dados-abertos.apin.pt/WaterConsumptionObserved_ngsild' -o data.csv

Full csv file download — the schema shown was inferred from the file's first records.

Full API documentation ↗

Dataset

Volume & freshness

Data size
44 MB

License

No license declared upstream.

○ Documentation○ Data dictionary○ Versioning

Distributions (1)

WaterConsumptionObserved_ngsild

https://api-dados-abertos.apin.pt/WaterConsumptionObserved_ngsild
csv●

35 MB

Machine-readable & source

JSON
Consumo de água — live verification badge

Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.