{"help": "https://energydata.info/en/api/3/action/help_show?name=datastore_search", "success": true, "result": {"include_total": true, "limit": 100, "records_format": "objects", "resource_id": "73db1c75-4a6d-4bec-bc2c-7105959d7c2e", "total_estimation_threshold": null, "records": [{"_id":1,"Variable":"item_name","Type":"varchar","Example":"Long-grain rice, not parboiled, WKB","Description":"Item name."},{"_id":2,"Variable":"item_code","Type":"varchar","Example":"110111102.0","Description":"Item code."},{"_id":3,"Variable":"bh_code","Type":"varchar","Example":"1101111.0","Description":"Basic heading code."},{"_id":4,"Variable":"bh_name","Type":"varchar","Example":"Rice","Description":"Basic heading name."},{"_id":5,"Variable":"created_at","Type":"timestamp","Example":"2016-04-30 05:31:23","Description":"ISO 8601 timestamp of the observation in UTC time as recorded by the mobile phone."},{"_id":6,"Variable":"brand","Type":"varchar","Example":"phka romeat","Description":"Brand of the item, if observed."},{"_id":7,"Variable":"created_fr_lat","Type":"float8","Example":"11.5482358932","Description":"Latitude of the observation."},{"_id":8,"Variable":"created_fr_lon","Type":"float8","Example":"104.932060242","Description":"Longitude of the observation."},{"_id":9,"Variable":"obs_uid","Type":"varchar","Example":"1a9f73ad-6cad-4ca8-ae4c-f133a938291f","Description":"A unique identifier for the price observation."},{"_id":10,"Variable":"size","Type":"float8","Example":"1000.0","Description":"Numeric component of the observed item's size; e.g. \"500\" if the item is packaged in \"500 ml\" units."},{"_id":11,"Variable":"quantity","Type":"float8","Example":"1.0","Description":"Quantity of items sold in a group (e.g. 6 for a 6-pack of Coca Cola)."},{"_id":12,"Variable":"total_size","Type":"float8","Example":"1000.0","Description":"Total size e.g. in case of multipacks it could be 6x 0.5 liters."},{"_id":13,"Variable":"converted_total_size","Type":"float8","Example":"1.0","Description":"Converted size if changes from an unit to another are needed (e.g. from 1000 (g) to 1 (kg)."},{"_id":14,"Variable":"normalized_total_size","Type":"float8","Example":"1.0","Description":"Normalized size as per the reference unit and quantity."},{"_id":15,"Variable":"price","Type":"float8","Example":"1.5","Description":"Observed purchase price of the item in local currency."},{"_id":16,"Variable":"normalized_price","Type":"float8","Example":"1.5","Description":"Price of the item normalized for size and unit of measurement."},{"_id":17,"Variable":"fx_usd","Type":"float8","Example":"1.0","Description":"Daily exchange rate: Local currency per U.S. Dollar."},{"_id":18,"Variable":"fx_local","Type":"float8","Example":"4049.949951","Description":"Daily exchange rate: Observed currency of the item per local currency."},{"_id":19,"Variable":"normalized_price_usd","Type":"float8","Example":"1.5","Description":"Price of the item normalized for size and unit of measurement, in U.S. dollars."},{"_id":20,"Variable":"normalized_price_local","Type":"float8","Example":"6074.9249265","Description":"Price of the item normalized for size and unit of measurement, in local currency units."},{"_id":21,"Variable":"currency","Type":"varchar","Example":"USD","Description":"ISO 4217 currency code for the item’s price."},{"_id":22,"Variable":"units","Type":"varchar","Example":"g","Description":"Reported unit of measurement."},{"_id":23,"Variable":"reference_unit_of_measurement","Type":"varchar","Example":"Kilogram","Description":"Reference unit of measurement for the normalization."},{"_id":24,"Variable":"reference_quantity","Type":"float8","Example":"1.0","Description":"Reference size for the normalization."},{"_id":25,"Variable":"place_uuid","Type":"varchar","Example":"7d7e4b2d-815c-4484-b123-d9eed5948899","Description":"A unique identifier for the store/shop/outlet."},{"_id":26,"Variable":"place_name","Type":"varchar","Example":"Aeon mall Phnom Penh","Description":"A string name for the store/shop/outlet."},{"_id":27,"Variable":"place_lat","Type":"float8","Example":"11.5480862","Description":"Latitude of the store/shop/outlet."},{"_id":28,"Variable":"place_long","Type":"float8","Example":"104.9344974","Description":"Longitude of the store/shop/outlet."},{"_id":29,"Variable":"store_type","Type":"varchar","Example":"small_medium_shop","Description":"Type of store/shop/outlet where an item's price was observed."},{"_id":30,"Variable":"country","Type":"varchar","Example":"KH","Description":"The ISO 3166 country  where an item was observed."},{"_id":31,"Variable":"L0","Type":"varchar","Example":"Cambodia","Description":"For purposes of this pilot and in order to ensure comparability across countries when describing spatial units, Level 0 (“L0”) denotes the country level."},{"_id":32,"Variable":"L1","Type":"varchar","Example":"Phnom Penh","Description":"For purposes of this pilot and in order to ensure comparability across countries when describing spatial units, Level 1 (“L1”) denotes the state or province level."},{"_id":33,"Variable":"L2","Type":"varchar","Example":"Phnom Penh","Description":"For purposes of this pilot and in order to ensure comparability across countries when describing spatial units, Level 2 (“L2”) denotes the city or municipality level."},{"_id":34,"Variable":"L0_geo","Type":"varchar","Example":"Cambodia","Description":"For purposes of this pilot and in order to ensure comparability across countries when describing spatial units, this alternative Level 0 georefence (“L0_geo”) denotes the country level."},{"_id":35,"Variable":"L1_geo","Type":"varchar","Example":"Phnom Penh","Description":"For purposes of this pilot and in order to ensure comparability across countries when describing spatial units, this alternative Level 1 georefence (“L1_geo”) denotes the state or province level."},{"_id":36,"Variable":"L2_geo","Type":"varchar","Example":"Phnom Penh","Description":"For purposes of this pilot and in order to ensure comparability across countries when describing spatial units, this alternative Level 2 georefence (“L2_geo”) denotes the city or municipality level."},{"_id":37,"Variable":"L3_geo","Type":"varchar","Example":"n.a. ( 1025)","Description":"For purposes of this pilot and in order to ensure comparability across countries when describing spatial units, this alternative Level 3 georefence (“L3_geo”) denotes the district or zone level."},{"_id":38,"Variable":"pop_density","Type":"float8","Example":"118.114913111","Description":"Estimated population density for the location of the observation."},{"_id":39,"Variable":"dist_L2","Type":"float8","Example":"8.41953136278","Description":"Distance of the observation from the L2 (city) central location."},{"_id":40,"Variable":"city_radius","Type":"float8","Example":"29.0","Description":"Radius estimating the (L2) city boundary."},{"_id":41,"Variable":"metadata_json","Type":"json","Example":"{u'brand_value': u'phka romeat', u'packaged_unpackaged_value': u'prepacked', u'rice_packaging_value': u'paper_or_plastic_bag', u'rice_type_other_value': None, u'rice_type_value': [u'non-parboiled']}","Description":"Additional metadata assosiated with the observation in JSON format."}], "fields": [{"id": "_id", "type": "int"}, {"id": "Variable", "type": "text"}, {"id": "Type", "type": "text"}, {"id": "Example", "type": "text"}, {"id": "Description", "type": "text"}], "_links": {"start": "/api/3/action/datastore_search?resource_id=73db1c75-4a6d-4bec-bc2c-7105959d7c2e", "next": "/api/3/action/datastore_search?resource_id=73db1c75-4a6d-4bec-bc2c-7105959d7c2e&offset=100"}, "total": 41, "total_was_estimated": false}}