{"help": "https://data.santamonica.gov/ja/api/3/action/help_show?name=datastore_search", "success": true, "result": {"include_total": true, "limit": 100, "records_format": "objects", "resource_id": "dacb5a37-650c-41e9-82c8-399ae80049d0", "total_estimation_threshold": null, "records": [{"_id":1,"Year":"1990-06-30T00:00:00","Demand (MGD)":14.2,"Local (MGY)":"1,625","Imported (MGY)":"3,654","Potable (MGY)":"","Non-Potable (MGY)":null,"Local +Imp":"5,279","Annual Res. MG":"","Pct Local":0.31,"Pct Imported":69,"Potable_Nonpot":" -   ","Pct Potable":null,"Pct Non-Potable":null,"Dem Per Cap_GPD":null,"Res Per Cap":null,"Population":""},{"_id":2,"Year":"1991-06-30T00:00:00","Demand (MGD)":11.2,"Local (MGY)":"1,802","Imported (MGY)":"2,412","Potable (MGY)":"","Non-Potable (MGY)":null,"Local +Imp":"4,214","Annual Res. MG":"","Pct Local":0.43,"Pct Imported":57,"Potable_Nonpot":" -   ","Pct Potable":null,"Pct Non-Potable":null,"Dem Per Cap_GPD":129,"Res Per Cap":null,"Population":"86,623"},{"_id":3,"Year":"1992-06-30T00:00:00","Demand (MGD)":11.8,"Local (MGY)":"2,561","Imported (MGY)":"1,829","Potable (MGY)":"","Non-Potable (MGY)":null,"Local +Imp":"4,390","Annual Res. MG":"","Pct Local":0.58,"Pct Imported":42,"Potable_Nonpot":" -   ","Pct Potable":null,"Pct Non-Potable":null,"Dem Per Cap_GPD":137,"Res Per Cap":null,"Population":"86,341"},{"_id":4,"Year":"1993-06-30T00:00:00","Demand (MGD)":12,"Local (MGY)":"3,065","Imported (MGY)":"1,643","Potable (MGY)":"","Non-Potable (MGY)":null,"Local +Imp":"4,708","Annual Res. MG":"","Pct Local":0.65,"Pct Imported":35,"Potable_Nonpot":" -   ","Pct Potable":null,"Pct Non-Potable":null,"Dem Per Cap_GPD":139,"Res Per Cap":null,"Population":"86,059"},{"_id":5,"Year":"1994-06-30T00:00:00","Demand (MGD)":12.2,"Local (MGY)":"3,078","Imported (MGY)":"1,614","Potable (MGY)":"","Non-Potable (MGY)":null,"Local +Imp":"4,692","Annual Res. MG":"","Pct Local":0.66,"Pct Imported":34,"Potable_Nonpot":" -   ","Pct Potable":null,"Pct Non-Potable":null,"Dem Per Cap_GPD":142,"Res Per Cap":null,"Population":"85,777"},{"_id":6,"Year":"1995-06-30T00:00:00","Demand (MGD)":12.2,"Local (MGY)":"3,270","Imported (MGY)":"1,427","Potable (MGY)":"","Non-Potable (MGY)":null,"Local +Imp":"4,697","Annual Res. MG":"","Pct Local":0.70,"Pct Imported":30,"Potable_Nonpot":" -   ","Pct Potable":null,"Pct Non-Potable":null,"Dem Per Cap_GPD":143,"Res Per Cap":null,"Population":"85,495"},{"_id":7,"Year":"1996-06-30T00:00:00","Demand (MGD)":12.8,"Local (MGY)":"1,856","Imported (MGY)":"3,022","Potable (MGY)":"","Non-Potable (MGY)":null,"Local +Imp":"4,878","Annual Res. MG":"","Pct Local":0.38,"Pct Imported":62,"Potable_Nonpot":" -   ","Pct Potable":null,"Pct Non-Potable":null,"Dem Per Cap_GPD":150,"Res Per Cap":null,"Population":"85,213"},{"_id":8,"Year":"1997-06-30T00:00:00","Demand (MGD)":13.4,"Local (MGY)":"919","Imported (MGY)":"3,933","Potable (MGY)":"","Non-Potable (MGY)":null,"Local +Imp":"4,852","Annual Res. MG":"","Pct Local":0.19,"Pct Imported":81,"Potable_Nonpot":" -   ","Pct Potable":null,"Pct Non-Potable":null,"Dem Per Cap_GPD":158,"Res Per Cap":null,"Population":"84,931"},{"_id":9,"Year":"1998-06-30T00:00:00","Demand (MGD)":12.4,"Local (MGY)":"861","Imported (MGY)":"3,728","Potable (MGY)":"","Non-Potable (MGY)":null,"Local +Imp":"4,589","Annual Res. MG":"","Pct Local":0.19,"Pct Imported":81,"Potable_Nonpot":" -   ","Pct Potable":null,"Pct Non-Potable":null,"Dem Per Cap_GPD":146,"Res Per Cap":null,"Population":"84,649"},{"_id":10,"Year":"1999-06-30T00:00:00","Demand (MGD)":13,"Local (MGY)":"957","Imported (MGY)":"3,844","Potable (MGY)":"","Non-Potable (MGY)":null,"Local +Imp":"4,801","Annual Res. MG":"","Pct Local":0.20,"Pct Imported":80,"Potable_Nonpot":" -   ","Pct Potable":null,"Pct Non-Potable":null,"Dem Per Cap_GPD":154,"Res Per Cap":null,"Population":"84,367"},{"_id":11,"Year":"2000-06-30T00:00:00","Demand (MGD)":13.2,"Local (MGY)":"948","Imported (MGY)":"4,016","Potable (MGY)":"4,470.75","Non-Potable (MGY)":0.2,"Local +Imp":"4,964","Annual Res. MG":"","Pct Local":0.19,"Pct Imported":81,"Potable_Nonpot":"4,470.95","Pct Potable":100,"Pct Non-Potable":0,"Dem Per Cap_GPD":157,"Res Per Cap":null,"Population":"84,084"},{"_id":12,"Year":"2001-06-30T00:00:00","Demand (MGD)":13.2,"Local (MGY)":"915","Imported (MGY)":"3,758","Potable (MGY)":"4,326.77","Non-Potable (MGY)":0.6,"Local +Imp":"4,673","Annual Res. MG":"","Pct Local":0.20,"Pct Imported":80,"Potable_Nonpot":"4,327.37","Pct Potable":100,"Pct Non-Potable":0,"Dem Per Cap_GPD":155,"Res Per Cap":null,"Population":"85,116"},{"_id":13,"Year":"2002-06-30T00:00:00","Demand (MGD)":13.2,"Local (MGY)":"687","Imported (MGY)":"4,180","Potable (MGY)":"4,581.08","Non-Potable (MGY)":0.6,"Local +Imp":"4,867","Annual Res. MG":"","Pct Local":0.14,"Pct Imported":86,"Potable_Nonpot":"4,581.68","Pct Potable":100,"Pct Non-Potable":0,"Dem Per Cap_GPD":152,"Res Per Cap":null,"Population":"87,084"},{"_id":14,"Year":"2003-06-30T00:00:00","Demand (MGD)":13.6,"Local (MGY)":"341","Imported (MGY)":"4,509","Potable (MGY)":"4,847.40","Non-Potable (MGY)":2.6,"Local +Imp":"4,850","Annual Res. MG":"","Pct Local":0.70,"Pct Imported":93,"Potable_Nonpot":"4,850.00","Pct Potable":100,"Pct Non-Potable":0,"Dem Per Cap_GPD":154,"Res Per Cap":null,"Population":"88,019"},{"_id":15,"Year":"2004-06-30T00:00:00","Demand (MGD)":13.1,"Local (MGY)":"256","Imported (MGY)":"4,698","Potable (MGY)":"4,951.40","Non-Potable (MGY)":2.6,"Local +Imp":"4,954","Annual Res. MG":"","Pct Local":0.50,"Pct Imported":95,"Potable_Nonpot":"4,954.00","Pct Potable":100,"Pct Non-Potable":0,"Dem Per Cap_GPD":148,"Res Per Cap":null,"Population":"88,795"},{"_id":16,"Year":"2005-06-30T00:00:00","Demand (MGD)":13.1,"Local (MGY)":"616","Imported (MGY)":"4,129","Potable (MGY)":"4,721.11","Non-Potable (MGY)":23.89,"Local +Imp":"4,745","Annual Res. MG":"","Pct Local":0.13,"Pct Imported":87,"Potable_Nonpot":"4,745.00","Pct Potable":100,"Pct Non-Potable":1,"Dem Per Cap_GPD":148,"Res Per Cap":null,"Population":"88,692"},{"_id":17,"Year":"2006-06-30T00:00:00","Demand (MGD)":13.8,"Local (MGY)":"571","Imported (MGY)":"4,306","Potable (MGY)":"4,845.78","Non-Potable (MGY)":31.22,"Local +Imp":"4,877","Annual Res. MG":"","Pct Local":0.12,"Pct Imported":88,"Potable_Nonpot":"4,877.00","Pct Potable":99,"Pct Non-Potable":1,"Dem Per Cap_GPD":156,"Res Per Cap":null,"Population":"88,181"},{"_id":18,"Year":"2007-06-30T00:00:00","Demand (MGD)":13,"Local (MGY)":"650","Imported (MGY)":"4,242","Potable (MGY)":"4,858.50","Non-Potable (MGY)":33.5,"Local +Imp":"4,892","Annual Res. MG":"","Pct Local":0.13,"Pct Imported":87,"Potable_Nonpot":"4,892.00","Pct Potable":99,"Pct Non-Potable":1,"Dem Per Cap_GPD":148,"Res Per Cap":null,"Population":"87,860"},{"_id":19,"Year":"2008-06-30T00:00:00","Demand (MGD)":12.6,"Local (MGY)":"671","Imported (MGY)":"4,016","Potable (MGY)":"4,651.80","Non-Potable (MGY)":35,"Local +Imp":"4,687","Annual Res. MG":"","Pct Local":0.14,"Pct Imported":86,"Potable_Nonpot":"4,686.80","Pct Potable":99,"Pct Non-Potable":1,"Dem Per Cap_GPD":142,"Res Per Cap":null,"Population":"88,170"},{"_id":20,"Year":"2009-06-30T00:00:00","Demand (MGD)":11.9,"Local (MGY)":"878","Imported (MGY)":"3,471","Potable (MGY)":"4,241","Non-Potable (MGY)":107.8,"Local +Imp":"4,349","Annual Res. MG":"","Pct Local":0.20,"Pct Imported":80,"Potable_Nonpot":"4,348.80","Pct Potable":98,"Pct Non-Potable":2,"Dem Per Cap_GPD":133,"Res Per Cap":null,"Population":"89,295"},{"_id":21,"Year":"2010-06-30T00:00:00","Demand (MGD)":11.6,"Local (MGY)":"1,052","Imported (MGY)":"3,196","Potable (MGY)":"4,223.13","Non-Potable (MGY)":24.5,"Local +Imp":"4,248","Annual Res. MG":"","Pct Local":0.25,"Pct Imported":75,"Potable_Nonpot":"4,247.63","Pct Potable":99,"Pct Non-Potable":1,"Dem Per Cap_GPD":130,"Res Per Cap":null,"Population":"89,494"},{"_id":22,"Year":"2011-06-30T00:00:00","Demand (MGD)":11.7,"Local (MGY)":"2,176","Imported (MGY)":"2,081","Potable (MGY)":"4,256.00","Non-Potable (MGY)":25.86,"Local +Imp":"4,257","Annual Res. MG":"","Pct Local":0.51,"Pct Imported":49,"Potable_Nonpot":"4,256.50","Pct Potable":99,"Pct Non-Potable":1,"Dem Per Cap_GPD":130,"Res Per Cap":null,"Population":"90,080"},{"_id":23,"Year":"2012-06-30T00:00:00","Demand (MGD)":12.1,"Local (MGY)":"2,202","Imported (MGY)":"2,134","Potable (MGY)":"4,336.00","Non-Potable (MGY)":28.14,"Local +Imp":"4,833","Annual Res. MG":"","Pct Local":0.56,"Pct Imported":44,"Potable_Nonpot":"4,214.58","Pct Potable":99,"Pct Non-Potable":1,"Dem Per Cap_GPD":127,"Res Per Cap":null,"Population":"90,269"},{"_id":24,"Year":"2013-06-30T00:00:00","Demand (MGD)":12.8,"Local (MGY)":"2,683","Imported (MGY)":"1,922","Potable (MGY)":"4,587.00","Non-Potable (MGY)":29.03,"Local +Imp":"4,713","Annual Res. MG":"","Pct Local":0.59,"Pct Imported":41,"Potable_Nonpot":"4,607.43","Pct Potable":99,"Pct Non-Potable":1,"Dem Per Cap_GPD":138,"Res Per Cap":null,"Population":"91,094"},{"_id":25,"Year":"2014-06-30T00:00:00","Demand (MGD)":11.8,"Local (MGY)":"2,893","Imported (MGY)":"1,674","Potable (MGY)":"4,567.00","Non-Potable (MGY)":31.63,"Local +Imp":"4,567","Annual Res. MG":"","Pct Local":0.63,"Pct Imported":37,"Potable_Nonpot":"4,324.04","Pct Potable":99,"Pct Non-Potable":1,"Dem Per Cap_GPD":128,"Res Per Cap":null,"Population":"92,185"},{"_id":26,"Year":"2015-06-30T00:00:00","Demand (MGD)":10.1,"Local (MGY)":"2,782","Imported (MGY)":"1,075","Potable (MGY)":"3,857.00","Non-Potable (MGY)":26.09,"Local +Imp":"3,857","Annual Res. MG":"","Pct Local":0.72,"Pct Imported":28,"Potable_Nonpot":"3747.45","Pct Potable":99,"Pct Non-Potable":1,"Dem Per Cap_GPD":113,"Res Per Cap":null,"Population":"92,734"},{"_id":27,"Year":"2016-06-30T00:00:00","Demand (MGD)":10.1,"Local (MGY)":"2,784","Imported (MGY)":"909","Potable (MGY)":"3,693.00","Non-Potable (MGY)":56.3,"Local +Imp":"","Annual Res. MG":"","Pct Local":0.75,"Pct Imported":25,"Potable_Nonpot":"","Pct Potable":null,"Pct Non-Potable":null,"Dem Per Cap_GPD":108,"Res Per Cap":null,"Population":"93,551"},{"_id":28,"Year":"2017-06-30T00:00:00","Demand (MGD)":10.2,"Local (MGY)":"2,371","Imported (MGY)":"1,346","Potable (MGY)":"3,717.00","Non-Potable (MGY)":59.4,"Local +Imp":"","Annual Res. MG":"","Pct Local":0.64,"Pct Imported":36,"Potable_Nonpot":"","Pct Potable":null,"Pct Non-Potable":null,"Dem Per Cap_GPD":109,"Res Per Cap":null,"Population":"92,298"},{"_id":29,"Year":"2018-06-30T00:00:00","Demand (MGD)":10.2,"Local (MGY)":"2,408","Imported (MGY)":"1,314","Potable (MGY)":"3,722.00","Non-Potable (MGY)":59.1,"Local +Imp":"3,720","Annual Res. MG":"2,491.73","Pct Local":0.67,"Pct Imported":33,"Potable_Nonpot":"","Pct Potable":null,"Pct Non-Potable":null,"Dem Per Cap_GPD":110,"Res Per Cap":null,"Population":"91,417"},{"_id":30,"Year":"2019-06-30T00:00:00","Demand (MGD)":9.5,"Local (MGY)":"2,357","Imported (MGY)":"","Potable (MGY)":"","Non-Potable (MGY)":null,"Local +Imp":"3470.9","Annual Res. MG":"2357.32","Pct Local":0.68,"Pct Imported":32,"Potable_Nonpot":"","Pct Potable":null,"Pct Non-Potable":null,"Dem Per Cap_GPD":null,"Res Per Cap":null,"Population":"90,401"},{"_id":31,"Year":"2020-06-30T00:00:00","Demand (MGD)":9.4,"Local (MGY)":"2,417","Imported (MGY)":"","Potable (MGY)":"","Non-Potable (MGY)":null,"Local +Imp":"3455.5","Annual Res. MG":"2417.06","Pct Local":0.70,"Pct Imported":30,"Potable_Nonpot":"","Pct Potable":null,"Pct Non-Potable":null,"Dem Per Cap_GPD":null,"Res Per Cap":null,"Population":"93,076"},{"_id":32,"Year":"2021-06-30T00:00:00","Demand (MGD)":9.4,"Local (MGY)":"","Imported (MGY)":"","Potable (MGY)":"","Non-Potable (MGY)":null,"Local +Imp":"3,446","Annual Res. MG":"","Pct Local":0.50,"Pct Imported":50,"Potable_Nonpot":"","Pct Potable":null,"Pct Non-Potable":null,"Dem Per Cap_GPD":null,"Res Per Cap":null,"Population":""},{"_id":33,"Year":"2022-06-30T00:00:00","Demand (MGD)":9.4,"Local (MGY)":"","Imported (MGY)":"","Potable (MGY)":"","Non-Potable (MGY)":null,"Local +Imp":"3442","Annual Res. MG":"2684.76","Pct Local":0.513,"Pct Imported":48.7,"Potable_Nonpot":"","Pct Potable":null,"Pct Non-Potable":null,"Dem Per Cap_GPD":101.59,"Res Per Cap":79.23,"Population":"92,828"}], "fields": [{"id": "_id", "type": "int"}, {"id": "Year", "type": "timestamp"}, {"id": "Demand (MGD)", "type": "numeric"}, {"id": "Local (MGY)", "type": "text"}, {"id": "Imported (MGY)", "type": "text"}, {"id": "Potable (MGY)", "type": "text"}, {"id": "Non-Potable (MGY)", "type": "numeric"}, {"id": "Local +Imp", "type": "text"}, {"id": "Annual Res. MG", "type": "text"}, {"id": "Pct Local", "type": "numeric"}, {"id": "Pct Imported", "type": "numeric"}, {"id": "Potable_Nonpot", "type": "text"}, {"id": "Pct Potable", "type": "numeric"}, {"id": "Pct Non-Potable", "type": "numeric"}, {"id": "Dem Per Cap_GPD", "type": "numeric"}, {"id": "Res Per Cap", "type": "numeric"}, {"id": "Population", "type": "text"}], "_links": {"start": "/api/3/action/datastore_search?resource_id=dacb5a37-650c-41e9-82c8-399ae80049d0", "next": "/api/3/action/datastore_search?resource_id=dacb5a37-650c-41e9-82c8-399ae80049d0&offset=100"}, "total": 33, "total_was_estimated": false}}