{
    "V":2, 
    "tstart":"2026-03-26",
    "tend":"2026-04-06",
    "sql":"select * from aqualog where device ='I13JA287987'  and tstamp>'2026-03-26' and tstamp < '2026-04-06' order by tstamp ",
    "n":222,
    "tstamp":["2026-03-26 01:34:00","2026-03-26 02:34:00","2026-03-26 03:34:00","2026-03-26 04:34:00","2026-03-26 05:16:00","2026-03-26 06:16:00","2026-03-26 07:16:00","2026-03-26 08:16:00","2026-03-26 09:16:00","2026-03-26 10:16:00","2026-03-26 11:16:00","2026-03-26 12:16:00","2026-03-26 13:32:00","2026-03-26 14:32:00","2026-03-26 15:32:00","2026-03-26 16:32:00","2026-03-26 17:16:00","2026-03-26 18:16:00","2026-03-26 19:16:00","2026-03-26 20:16:00","2026-03-26 21:37:00","2026-03-26 22:37:00","2026-03-26 23:37:00","2026-03-27 00:37:00","2026-03-27 01:16:00","2026-03-27 02:16:00","2026-03-27 03:16:00","2026-03-27 04:16:00","2026-03-27 05:34:00","2026-03-27 06:34:00","2026-03-27 07:34:00","2026-03-27 08:34:00","2026-03-27 13:35:00","2026-03-27 14:35:00","2026-03-27 15:35:00","2026-03-27 16:35:00","2026-03-27 17:16:00","2026-03-27 18:16:00","2026-03-27 19:16:00","2026-03-27 20:16:00","2026-03-27 21:16:00","2026-03-27 22:16:00","2026-03-27 23:16:00","2026-03-28 00:16:00","2026-03-28 01:36:00","2026-03-28 02:36:00","2026-03-28 03:36:00","2026-03-28 04:36:00","2026-03-28 05:36:00","2026-03-28 06:36:00","2026-03-28 07:36:00","2026-03-28 08:36:00","2026-03-28 09:16:00","2026-03-28 10:16:00","2026-03-28 11:16:00","2026-03-28 12:16:00","2026-03-28 13:16:00","2026-03-28 14:16:00","2026-03-28 15:16:00","2026-03-28 16:16:00","2026-03-28 17:33:00","2026-03-28 18:33:00","2026-03-28 19:33:00","2026-03-28 20:33:00","2026-03-28 21:36:00","2026-03-28 22:36:00","2026-03-28 23:36:00","2026-03-29 00:36:00","2026-03-29 02:16:00","2026-03-29 03:16:00","2026-03-29 04:16:00","2026-03-29 05:16:00","2026-03-29 10:16:00","2026-03-29 11:16:00","2026-03-29 12:16:00","2026-03-29 13:16:00","2026-03-29 14:16:00","2026-03-29 15:16:00","2026-03-29 16:16:00","2026-03-29 17:16:00","2026-03-29 18:33:00","2026-03-29 19:33:00","2026-03-29 20:33:00","2026-03-29 21:33:00","2026-03-29 22:16:00","2026-03-29 23:16:00","2026-03-30 00:16:00","2026-03-30 01:16:00","2026-03-30 02:16:00","2026-03-30 03:16:00","2026-03-30 04:16:00","2026-03-30 05:16:00","2026-03-30 06:16:00","2026-03-30 07:16:00","2026-03-30 08:16:00","2026-03-30 09:16:00","2026-03-30 10:35:00","2026-03-30 11:35:00","2026-03-30 12:35:00","2026-03-30 13:35:00","2026-03-30 14:34:00","2026-03-30 15:34:00","2026-03-30 16:34:00","2026-03-30 17:34:00","2026-03-30 18:33:00","2026-03-30 19:33:00","2026-03-30 20:33:00","2026-03-30 21:33:00","2026-03-31 02:37:00","2026-03-31 03:37:00","2026-03-31 04:37:00","2026-03-31 05:37:00","2026-03-31 06:16:00","2026-03-31 07:16:00","2026-03-31 08:16:00","2026-03-31 09:16:00","2026-03-31 10:37:00","2026-03-31 11:37:00","2026-03-31 12:37:00","2026-03-31 13:37:00","2026-03-31 14:34:00","2026-03-31 15:34:00","2026-03-31 16:34:00","2026-03-31 17:34:00","2026-03-31 18:16:00","2026-03-31 19:16:00","2026-03-31 20:16:00","2026-03-31 21:16:00","2026-03-31 22:37:00","2026-03-31 23:37:00","2026-04-01 00:37:00","2026-04-01 01:37:00","2026-04-01 02:16:00","2026-04-01 03:16:00","2026-04-01 04:16:00","2026-04-01 05:16:00","2026-04-01 06:34:00","2026-04-01 07:34:00","2026-04-01 08:34:00","2026-04-01 09:34:00","2026-04-01 10:16:00","2026-04-01 11:16:00","2026-04-01 12:16:00","2026-04-01 13:16:00","2026-04-01 14:33:00","2026-04-01 15:33:00","2026-04-01 16:33:00","2026-04-01 17:33:00","2026-04-01 22:16:00","2026-04-01 23:16:00","2026-04-02 00:16:00","2026-04-02 01:16:00","2026-04-02 02:16:00","2026-04-02 03:16:00","2026-04-02 04:16:00","2026-04-02 05:16:00","2026-04-02 06:31:00","2026-04-02 07:31:00","2026-04-02 08:31:00","2026-04-02 09:31:00","2026-04-02 10:16:00","2026-04-02 11:16:00","2026-04-02 12:16:00","2026-04-02 13:16:00","2026-04-02 14:16:00","2026-04-02 15:16:00","2026-04-02 16:16:00","2026-04-02 17:16:00","2026-04-02 18:16:00","2026-04-02 19:16:00","2026-04-02 20:16:00","2026-04-02 21:16:00","2026-04-03 06:16:00","2026-04-03 07:16:00","2026-04-03 08:16:00","2026-04-03 09:16:00","2026-04-03 14:16:00","2026-04-03 15:16:00","2026-04-03 16:16:00","2026-04-03 17:16:00","2026-04-03 18:33:00","2026-04-03 19:33:00","2026-04-03 20:33:00","2026-04-03 21:33:00","2026-04-03 22:16:00","2026-04-03 23:16:00","2026-04-04 00:16:00","2026-04-04 01:16:00","2026-04-04 06:35:00","2026-04-04 07:35:00","2026-04-04 08:35:00","2026-04-04 09:35:00","2026-04-04 10:16:00","2026-04-04 11:16:00","2026-04-04 12:16:00","2026-04-04 13:16:00","2026-04-04 14:16:00","2026-04-04 15:16:00","2026-04-04 16:16:00","2026-04-04 17:16:00","2026-04-04 18:16:00","2026-04-04 19:16:00","2026-04-04 20:16:00","2026-04-04 21:16:00","2026-04-04 22:16:00","2026-04-04 23:16:00","2026-04-05 00:16:00","2026-04-05 01:16:00","2026-04-05 06:37:00","2026-04-05 07:37:00","2026-04-05 08:37:00","2026-04-05 09:37:00","2026-04-05 14:16:00","2026-04-05 15:16:00","2026-04-05 16:16:00","2026-04-05 17:16:00","2026-04-05 18:32:00","2026-04-05 19:32:00","2026-04-05 20:32:00","2026-04-05 21:32:00","2026-04-05 22:16:00","2026-04-05 23:16:00"],
    "valor_l":["51","10","10","10","10","11","10","10","13","32","15","10","17","10","10","29","9","9","10","10","10","10","9","10","10","10","9","10","9","10","10","9","102","10","10","10","11","10","10","10","10","10","10","10","10","10","10","9","10","10","10","10","10","10","10","10","10","10","10","10","11","10","10","11","10","10","11","10","10","11","10","10","52","10","10","11","10","10","11","10","10","11","10","11","10","10","11","10","10","11","10","10","11","10","11","10","27","19","30","9","14","16","10","10","24","10","10","10","50","11","10","10","10","10","10","16","65","149","106","17","26","10","9","15","72","9","10","9","10","9","10","9","10","9","10","9","10","9","10","10","21","14","33","12","9","10","20","21","48","10","9","10","10","9","10","9","10","9","10","10","28","92","93","125","10","10","9","13","9","10","9","10","85","9","10","9","48","10","9","10","9","10","9","10","10","9","10","9","47","10","9","10","9","10","9","10","9","10","9","10","10","9","10","9","10","10","9","10","47","10","9","10","48","10","9","10","9","10","10","9","10","9"],
    "leitura_l":["329152","329162","329172","329182","329192","329203","329213","329223","329236","329268","329283","329293","329310","329320","329330","329359","329368","329377","329387","329397","329407","329417","329426","329436","329446","329456","329465","329475","329484","329494","329504","329513","329615","329625","329635","329645","329656","329666","329676","329686","329696","329706","329716","329726","329736","329746","329756","329765","329775","329785","329795","329805","329815","329825","329835","329845","329855","329865","329875","329885","329896","329906","329916","329927","329937","329947","329958","329968","329978","329989","329999","330009","330061","330071","330081","330092","330102","330112","330123","330133","330143","330154","330164","330175","330185","330195","330206","330216","330226","330237","330247","330257","330268","330278","330289","330299","330326","330345","330375","330384","330398","330414","330424","330434","330458","330468","330478","330488","330538","330549","330559","330569","330579","330589","330599","330615","330680","330829","330935","330952","330978","330988","330997","331012","331084","331093","331103","331112","331122","331131","331141","331150","331160","331169","331179","331188","331198","331207","331217","331227","331248","331262","331295","331307","331316","331326","331346","331367","331415","331425","331434","331444","331454","331463","331473","331482","331492","331501","331511","331521","331549","331641","331734","331859","331869","331879","331888","331901","331910","331920","331929","331939","332024","332033","332043","332052","332100","332110","332119","332129","332138","332148","332157","332167","332177","332186","332196","332205","332252","332262","332271","332281","332290","332300","332309","332319","332328","332338","332347","332357","332367","332376","332386","332395","332405","332415","332424","332434","332481","332491","332500","332510","332558","332568","332577","332587","332596","332606","332616","332625","332635","332644"],
    "ndia":11,
    "dia":["20260327","20260328","20260329","20260330","20260331","20260401","20260402","20260403","20260404","20260405","20260406"],
    "CDiario":["290","242","237","293","643","294","514","247","229","229","10"],
    "ndias":10.90,
    "CTot":3492,
    "CMDia":320.2,
   "metadata": {
      "nome":"i13ja287987",
      "descrição":"Water consumption (device i13ja287987)",
      "fonte":"SMAS",
      "status":"ok",
      "License":"Licença: Creative Commons CCZero",
      "LicenseURL":"http://opendefinition.org/licenses/cc-zero/",
      "Editor":"PCP (ppimenta[at]ipmaia.pt)"
   },
   "id":"i13ja287987",
   "JSON validado em": ["https://www.itb.ec.europa.eu/json/any/upload","https://jsonlint.com/", "https://jsonformatter.curiousconcept.com/"],
   "Last revision": "2024-02-16",
   "Disclaimer": "This is an experimental service based on the BaZe data lake, setup on the context of Omega-X (https://bit.ly/OMEGAX) project. Data and formats might change without prior notification.",
   "td":2.196

}