{
    "V":2, 
    "tstart":"2026-05-08",
    "tend":"2026-05-19",
    "sql":"select * from aqualog where device ='I13JA287987'  and tstamp>'2026-05-08' and tstamp < '2026-05-19' order by tstamp ",
    "n":234,
    "tstamp":["2026-05-08 00:15:00","2026-05-08 01:15:00","2026-05-08 02:15:00","2026-05-08 03:15:00","2026-05-08 04:15:00","2026-05-08 05:15:00","2026-05-08 06:14:00","2026-05-08 07:14:00","2026-05-08 08:14:00","2026-05-08 09:14:00","2026-05-08 10:15:00","2026-05-08 11:15:00","2026-05-08 12:15:00","2026-05-08 13:15:00","2026-05-08 14:14:00","2026-05-08 15:14:00","2026-05-08 16:14:00","2026-05-08 17:14:00","2026-05-08 18:33:00","2026-05-08 19:33:00","2026-05-08 20:33:00","2026-05-08 21:33:00","2026-05-09 02:14:00","2026-05-09 03:14:00","2026-05-09 04:14:00","2026-05-09 05:14:00","2026-05-09 06:14:00","2026-05-09 07:14:00","2026-05-09 08:14:00","2026-05-09 09:14:00","2026-05-09 10:14:00","2026-05-09 11:14:00","2026-05-09 12:14:00","2026-05-09 13:14:00","2026-05-09 14:14:00","2026-05-09 15:14:00","2026-05-09 16:14:00","2026-05-09 17:14:00","2026-05-09 18:47:00","2026-05-09 19:47:00","2026-05-09 20:47:00","2026-05-10 02:14:00","2026-05-10 03:14:00","2026-05-10 04:14:00","2026-05-10 05:14:00","2026-05-10 06:14:00","2026-05-10 07:14:00","2026-05-10 08:14:00","2026-05-10 09:14:00","2026-05-10 10:35:00","2026-05-10 11:35:00","2026-05-10 12:35:00","2026-05-10 13:35:00","2026-05-10 14:32:00","2026-05-10 15:32:00","2026-05-10 16:32:00","2026-05-10 17:32:00","2026-05-10 18:14:00","2026-05-10 19:14:00","2026-05-10 20:14:00","2026-05-10 21:14:00","2026-05-11 02:34:00","2026-05-11 03:34:00","2026-05-11 04:34:00","2026-05-11 05:34:00","2026-05-11 06:14:00","2026-05-11 07:14:00","2026-05-11 08:14:00","2026-05-11 09:14:00","2026-05-11 10:14:00","2026-05-11 11:14:00","2026-05-11 12:14:00","2026-05-11 13:14:00","2026-05-11 14:14:00","2026-05-11 15:14:00","2026-05-11 16:14:00","2026-05-11 17:14:00","2026-05-11 18:14:00","2026-05-11 19:14:00","2026-05-11 20:14:00","2026-05-11 21:14:00","2026-05-12 02:14:00","2026-05-12 03:14:00","2026-05-12 04:14:00","2026-05-12 05:14:00","2026-05-12 06:32:00","2026-05-12 07:32:00","2026-05-12 08:32:00","2026-05-12 09:32:00","2026-05-12 10:14:00","2026-05-12 11:14:00","2026-05-12 12:14:00","2026-05-12 13:14:00","2026-05-12 14:14:00","2026-05-12 15:14:00","2026-05-12 16:14:00","2026-05-12 17:14:00","2026-05-12 18:31:00","2026-05-12 19:31:00","2026-05-12 20:31:00","2026-05-12 21:31:00","2026-05-12 22:14:00","2026-05-12 23:14:00","2026-05-13 00:14:00","2026-05-13 01:14:00","2026-05-13 02:14:00","2026-05-13 03:14:00","2026-05-13 04:14:00","2026-05-13 05:14:00","2026-05-13 06:14:00","2026-05-13 07:14:00","2026-05-13 08:14:00","2026-05-13 09:14:00","2026-05-13 10:14:00","2026-05-13 11:14:00","2026-05-13 12:14:00","2026-05-13 13:14:00","2026-05-13 14:14:00","2026-05-13 15:14:00","2026-05-13 16:14:00","2026-05-13 17:14:00","2026-05-13 18:14:00","2026-05-13 19:14:00","2026-05-13 20:14:00","2026-05-13 21:14:00","2026-05-14 02:14:00","2026-05-14 03:14:00","2026-05-14 04:14:00","2026-05-14 05:14:00","2026-05-14 06:14:00","2026-05-14 07:14:00","2026-05-14 08:14:00","2026-05-14 09:14:00","2026-05-14 10:14:00","2026-05-14 11:14:00","2026-05-14 12:14:00","2026-05-14 13:14:00","2026-05-14 14:14:00","2026-05-14 15:14:00","2026-05-14 16:14:00","2026-05-14 17:14:00","2026-05-14 18:14:00","2026-05-14 19:14:00","2026-05-14 20:14:00","2026-05-14 21:14:00","2026-05-14 22:14:00","2026-05-14 23:14:00","2026-05-15 00:14:00","2026-05-15 01:14:00","2026-05-15 02:48:00","2026-05-15 03:48:00","2026-05-15 04:48:00","2026-05-15 05:45:00","2026-05-15 06:45:00","2026-05-15 07:45:00","2026-05-15 08:45:00","2026-05-15 10:14:00","2026-05-15 11:14:00","2026-05-15 12:14:00","2026-05-15 13:14:00","2026-05-15 18:14:00","2026-05-15 19:14:00","2026-05-15 20:14:00","2026-05-15 21:14:00","2026-05-15 22:14:00","2026-05-15 23:14:00","2026-05-16 00:14:00","2026-05-16 01:14:00","2026-05-16 02:14:00","2026-05-16 03:14:00","2026-05-16 04:14:00","2026-05-16 05:14:00","2026-05-16 06:14:00","2026-05-16 07:14:00","2026-05-16 08:14:00","2026-05-16 09:14:00","2026-05-16 10:35:00","2026-05-16 11:35:00","2026-05-16 12:35:00","2026-05-16 13:35:00","2026-05-16 14:14:00","2026-05-16 15:14:00","2026-05-16 16:14:00","2026-05-16 17:14:00","2026-05-16 18:14:00","2026-05-16 19:14:00","2026-05-16 20:14:00","2026-05-16 21:14:00","2026-05-16 22:14:00","2026-05-16 23:14:00","2026-05-17 00:14:00","2026-05-17 01:14:00","2026-05-17 02:14:00","2026-05-17 03:14:00","2026-05-17 04:14:00","2026-05-17 05:14:00","2026-05-17 06:14:00","2026-05-17 07:14:00","2026-05-17 08:14:00","2026-05-17 09:14:00","2026-05-17 10:14:00","2026-05-17 11:14:00","2026-05-17 12:14:00","2026-05-17 13:14:00","2026-05-17 14:14:00","2026-05-17 15:14:00","2026-05-17 16:14:00","2026-05-17 17:14:00","2026-05-17 18:33:00","2026-05-17 19:33:00","2026-05-17 20:33:00","2026-05-17 21:33:00","2026-05-18 02:14:00","2026-05-18 03:14:00","2026-05-18 04:14:00","2026-05-18 05:14:00","2026-05-18 06:35:00","2026-05-18 07:35:00","2026-05-18 08:35:00","2026-05-18 09:35:00","2026-05-18 10:14:00","2026-05-18 11:14:00","2026-05-18 12:14:00","2026-05-18 13:14:00","2026-05-18 14:14:00","2026-05-18 15:14:00","2026-05-18 16:14:00","2026-05-18 17:14:00","2026-05-18 18:14:00","2026-05-18 19:14:00","2026-05-18 20:14:00","2026-05-18 21:14:00","2026-05-18 22:14:00","2026-05-18 23:14:00"],
    "valor_l":["10","10","10","9","10","9","10","10","9","22","37","24","11","19","13","27","9","12","9","26","19","10","49","10","10","9","10","10","9","10","10","10","10","9","10","10","10","10","20","10","9","50","10","9","10","10","10","9","10","10","10","9","10","10","10","10","10","10","10","9","10","50","10","9","10","10","10","10","18","27","42","10","9","20","22","11","10","21","10","10","10","51","10","10","10","10","10","10","20","29","30","20","10","14","10","10","10","13","10","11","10","10","10","10","10","11","10","10","10","10","10","10","18","32","28","18","12","10","11","10","23","10","9","10","10","49","10","9","10","9","10","10","16","23","43","10","9","11","10","10","10","20","9","10","10","9","10","10","9","19","10","9","10","9","10","13","13","28","45","21","67","9","10","9","9","9","9","9","10","9","9","9","9","9","9","9","9","10","9","9","9","10","9","10","9","9","10","9","9","9","9","10","9","9","9","9","10","9","9","9","9","10","9","9","9","10","9","9","9","9","10","9","46","9","9","9","10","9","9","10","19","29","9","36","31","11","14","10","30","9","8","9","9","9"],
    "leitura_l":["341817","341827","341837","341846","341856","341865","341875","341885","341894","341916","341953","341977","341988","342007","342020","342047","342056","342068","342077","342103","342122","342132","342181","342191","342201","342210","342220","342230","342239","342249","342259","342269","342279","342288","342298","342308","342318","342328","342348","342358","342367","342417","342427","342436","342446","342456","342466","342475","342485","342495","342505","342514","342524","342534","342544","342554","342564","342574","342584","342593","342603","342653","342663","342672","342682","342692","342702","342712","342730","342757","342799","342809","342818","342838","342860","342871","342881","342902","342912","342922","342932","342983","342993","343003","343013","343023","343033","343043","343063","343092","343122","343142","343152","343166","343176","343186","343196","343209","343219","343230","343240","343250","343260","343270","343280","343291","343301","343311","343321","343331","343341","343351","343369","343401","343429","343447","343459","343469","343480","343490","343513","343523","343532","343542","343552","343601","343611","343620","343630","343639","343649","343659","343675","343698","343741","343751","343760","343771","343781","343791","343801","343821","343830","343840","343850","343859","343869","343879","343888","343907","343917","343926","343936","343945","343955","343968","343981","344009","344054","344075","344142","344151","344161","344170","344179","344188","344197","344206","344216","344225","344234","344243","344252","344261","344270","344279","344288","344298","344307","344316","344325","344335","344344","344354","344363","344372","344382","344391","344400","344409","344418","344428","344437","344446","344455","344464","344474","344483","344492","344501","344510","344520","344529","344538","344547","344557","344566","344575","344584","344593","344603","344612","344658","344667","344676","344685","344695","344704","344713","344723","344742","344771","344780","344816","344847","344858","344872","344882","344912","344921","344929","344938","344947","344956"],
    "ndia":11,
    "dia":["20260509","20260510","20260511","20260512","20260513","20260514","20260515","20260516","20260517","20260518","20260519"],
    "CDiario":["235","236","329","328","292","317","319","221","203","344","9"],
    "ndias":10.96,
    "CTot":3139,
    "CMDia":286.5,
   "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":0.683

}