Water consumptionConsumo de água

Name: Water consumption
Creator: dados.gov.pt

Consumo de águaWater consumption

DatasetProfiled3/7PreviewSubscribe🇵🇹Portugal

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 CSV Read the docs

Trust score

How is this computed?

poor

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

Data schema (11 fields)

Click a field to see example values.

Field	Type	Description
id	text	—
type	text	—
dateObservedDate observed	text	—
waterConsumptionWater consumption	text	—
location	text	—
waterTypeWater type	text	—
alarmStopsLeaksAlarm stops leaks	text	—
alarmTamperAlarm tamper	text	—
alarmWaterQualityAlarm water quality	text	—
alarmInProgressAlarm in progress	text	—
@context	text	—

Schema inferred from the distribution file's first records 1 month 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.

Where=

Sort by

Sample data (5 records)

Record 1id: urn:apin:WaterConsumptionObserved:1 · type: WaterConsumptionObserved

{
  "id": "urn:apin:WaterConsumptionObserved:1",
  "type": "WaterConsumptionObserved",
  "@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\": false}",
  "dateObserved": "{\"type\": \"Property\", \"value\": \"2026-07-25T18:29:37Z\"}",
  "alarmInProgress": "{\"type\": \"Property\", \"value\": false}",
  "alarmStopsLeaks": "{\"type\": \"Property\", \"value\": false}",
  "waterConsumption": "{\"type\": \"Property\", \"value\": 0, \"unitCode\": \"MTQ\"}",
  "alarmWaterQuality": "{\"type\": \"Property\", \"value\": false}"
}

Record 2id: urn:apin:WaterConsumptionObserved:2 · type: WaterConsumptionObserved

{
  "id": "urn:apin:WaterConsumptionObserved:2",
  "type": "WaterConsumptionObserved",
  "@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\": false}",
  "dateObserved": "{\"type\": \"Property\", \"value\": \"2026-07-25T18:29:37Z\"}",
  "alarmInProgress": "{\"type\": \"Property\", \"value\": false}",
  "alarmStopsLeaks": "{\"type\": \"Property\", \"value\": false}",
  "waterConsumption": "{\"type\": \"Property\", \"value\": 1, \"unitCode\": \"MTQ\"}",
  "alarmWaterQuality": "{\"type\": \"Property\", \"value\": false}"
}

Record 3id: urn:apin:WaterConsumptionObserved:4 · type: WaterConsumptionObserved

{
  "id": "urn:apin:WaterConsumptionObserved:4",
  "type": "WaterConsumptionObserved",
  "@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\": false}",
  "dateObserved": "{\"type\": \"Property\", \"value\": \"2026-07-25T18:29:37Z\"}",
  "alarmInProgress": "{\"type\": \"Property\", \"value\": false}",
  "alarmStopsLeaks": "{\"type\": \"Property\", \"value\": false}",
  "waterConsumption": "{\"type\": \"Property\", \"value\": 6, \"unitCode\": \"MTQ\"}",
  "alarmWaterQuality": "{\"type\": \"Property\", \"value\": false}"
}

Record 4id: urn:apin:WaterConsumptionObserved:5 · type: WaterConsumptionObserved

{
  "id": "urn:apin:WaterConsumptionObserved:5",
  "type": "WaterConsumptionObserved",
  "@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\": false}",
  "dateObserved": "{\"type\": \"Property\", \"value\": \"2026-07-25T18:29:37Z\"}",
  "alarmInProgress": "{\"type\": \"Property\", \"value\": false}",
  "alarmStopsLeaks": "{\"type\": \"Property\", \"value\": false}",
  "waterConsumption": "{\"type\": \"Property\", \"value\": 8, \"unitCode\": \"MTQ\"}",
  "alarmWaterQuality": "{\"type\": \"Property\", \"value\": false}"
}

Record 5id: urn:apin:WaterConsumptionObserved:13 · type: WaterConsumptionObserved

{
  "id": "urn:apin:WaterConsumptionObserved:13",
  "type": "WaterConsumptionObserved",
  "@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\": false}",
  "dateObserved": "{\"type\": \"Property\", \"value\": \"2026-07-25T18:29:37Z\"}",
  "alarmInProgress": "{\"type\": \"Property\", \"value\": false}",
  "alarmStopsLeaks": "{\"type\": \"Property\", \"value\": false}",
  "waterConsumption": "{\"type\": \"Property\", \"value\": 10, \"unitCode\": \"MTQ\"}",
  "alarmWaterQuality": "{\"type\": \"Property\", \"value\": false}"
}

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

35 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

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