{"help": "https://data.yorkopendata.org/en/api/3/action/help_show?name=datastore_search", "success": true, "result": {"include_total": true, "limit": 100, "records_format": "objects", "resource_id": "dddc9035-faaf-40c3-97ae-90856f3e40a8", "total_estimation_threshold": null, "records": [{"_id":1,"retail_area":"retail_area","month":"month","sales":"sales","transactions":"transactions","customers":"customers","ATV":"ATV","ARPC":"ARPC"},{"_id":2,"retail_area":"Bishopthorpe","month":"2022-01-01 00:00:00","sales":"921405.76","transactions":"74243","customers":"18949","ATV":"12.4106752151718","ARPC":"48.6255612433374"},{"_id":3,"retail_area":"Bishopthorpe","month":"2022-02-01 00:00:00","sales":"1059856.82","transactions":"78807","customers":"20931","ATV":"13.4487649574276","ARPC":"50.6357469781664"},{"_id":4,"retail_area":"Bishopthorpe","month":"2022-03-01 00:00:00","sales":"1431980.17","transactions":"91841","customers":"23553","ATV":"15.5919488028223","ARPC":"60.79820702246"},{"_id":5,"retail_area":"Bishopthorpe","month":"2022-04-01 00:00:00","sales":"1280184.07","transactions":"91777","customers":"26129","ATV":"13.9488550508297","ARPC":"48.994759462666"},{"_id":6,"retail_area":"Bishopthorpe","month":"2022-05-01 00:00:00","sales":"1278403.7","transactions":"93111","customers":"25327","ATV":"13.7298890571468","ARPC":"50.4759229281004"},{"_id":7,"retail_area":"Bishopthorpe","month":"2022-06-01 00:00:00","sales":"1308622.29","transactions":"97804","customers":"25997","ATV":"13.3800487710114","ARPC":"50.3374347040043"},{"_id":8,"retail_area":"Bishopthorpe","month":"2022-07-01 00:00:00","sales":"1529888.04","transactions":"97644","customers":"27147","ATV":"15.6680189258941","ARPC":"56.3556945518842"},{"_id":9,"retail_area":"Bishopthorpe","month":"2022-08-01 00:00:00","sales":"1316979.38","transactions":"93724","customers":"28703","ATV":"14.051677051769","ARPC":"45.882987144201"},{"_id":10,"retail_area":"Bishopthorpe","month":"2022-09-01 00:00:00","sales":"1213709.43","transactions":"86456","customers":"24787","ATV":"14.0384638428796","ARPC":"48.9655638036067"},{"_id":11,"retail_area":"Bishopthorpe","month":"2022-10-01 00:00:00","sales":"1243399.86","transactions":"90708","customers":"24621","ATV":"13.7077199364995","ARPC":"50.5015986353113"},{"_id":12,"retail_area":"Bishopthorpe","month":"2022-11-01 00:00:00","sales":"1269027.43","transactions":"91191","customers":"26628","ATV":"13.9161477558092","ARPC":"47.6576321916779"},{"_id":13,"retail_area":"Bishopthorpe","month":"2022-12-01 00:00:00","sales":"1426148.67","transactions":"96699","customers":"30183","ATV":"14.7483290416654","ARPC":"47.250063611967"},{"_id":14,"retail_area":"Bishopthorpe","month":"2023-01-01 00:00:00","sales":"1036214.45","transactions":"72573","customers":"18523","ATV":"14.278236396456","ARPC":"55.9420423257572"},{"_id":15,"retail_area":"Bishopthorpe","month":"2023-02-01 00:00:00","sales":"1108313.75","transactions":"79962","customers":"22624","ATV":"13.8605056151672","ARPC":"48.9884083274399"},{"_id":16,"retail_area":"Bishopthorpe","month":"2023-03-01 00:00:00","sales":"1145985.31","transactions":"86206","customers":"22981","ATV":"13.2935678491056","ARPC":"49.8666424437579"},{"_id":17,"retail_area":"Bishopthorpe","month":"2023-04-01 00:00:00","sales":"1260420.35","transactions":"86672","customers":"25342","ATV":"14.5424168128115","ARPC":"49.7364197774446"},{"_id":18,"retail_area":"Bishopthorpe","month":"2023-05-01 00:00:00","sales":"1194909.78","transactions":"87945","customers":"24313","ATV":"13.5870121098414","ARPC":"49.1469493686505"},{"_id":19,"retail_area":"Bishopthorpe","month":"2023-06-01 00:00:00","sales":"1394931.19","transactions":"93766","customers":"25923","ATV":"14.8767270652475","ARPC":"53.8105616633877"},{"_id":20,"retail_area":"Bishopthorpe","month":"2023-07-01 00:00:00","sales":"1319615.02","transactions":"97807","customers":"27462","ATV":"13.49203042727","ARPC":"48.0524004078363"},{"_id":21,"retail_area":"Bishopthorpe","month":"2023-08-01 00:00:00","sales":"1227357.74","transactions":"90592","customers":"26050","ATV":"13.5481912310138","ARPC":"47.115460268714"},{"_id":22,"retail_area":"Bishopthorpe","month":"2023-09-01 00:00:00","sales":"1300824.21","transactions":"93613","customers":"24607","ATV":"13.8957645839787","ARPC":"52.8639903279555"},{"_id":23,"retail_area":"Bishopthorpe","month":"2023-10-01 00:00:00","sales":"1171226.83","transactions":"87341","customers":"23280","ATV":"13.4098170389622","ARPC":"50.3104308419244"},{"_id":24,"retail_area":"Bishopthorpe","month":"2023-11-01 00:00:00","sales":"1333780.19","transactions":"96391","customers":"27859","ATV":"13.8371859405961","ARPC":"47.8760971319861"},{"_id":25,"retail_area":"Bishopthorpe","month":"2023-12-01 00:00:00","sales":"1504467.48","transactions":"100281","customers":"33740","ATV":"15.0025177251922","ARPC":"44.590026081802"},{"_id":26,"retail_area":"Bishopthorpe","month":"2024-01-01 00:00:00","sales":"1020670.14","transactions":"76437","customers":"19233","ATV":"13.3530899956827","ARPC":"53.0686913118078"},{"_id":27,"retail_area":"Bishopthorpe","month":"2024-02-01 00:00:00","sales":"1086446.11","transactions":"81555","customers":"21818","ATV":"13.3216370547483","ARPC":"49.7958616738473"},{"_id":28,"retail_area":"Bishopthorpe","month":"2024-03-01 00:00:00","sales":"1263799.12","transactions":"92171","customers":"22982","ATV":"13.7114615226047","ARPC":"54.9908241232269"},{"_id":29,"retail_area":"Bishopthorpe","month":"2024-04-01 00:00:00","sales":"1218359.45","transactions":"90227","customers":"22874","ATV":"13.5032689771354","ARPC":"53.263943778963"},{"_id":30,"retail_area":"Bishopthorpe","month":"2024-05-01 00:00:00","sales":"1458060.09","transactions":"101796","customers":"27448","ATV":"14.3233534716492","ARPC":"53.120813538327"},{"_id":31,"retail_area":"Bishopthorpe","month":"2024-06-01 00:00:00","sales":"1375962.14","transactions":"97511","customers":"25511","ATV":"14.1108402128991","ARPC":"53.9360330837678"},{"_id":32,"retail_area":"Bishopthorpe","month":"2024-07-01 00:00:00","sales":"1363898.58","transactions":"94668","customers":"25023","ATV":"14.407176448219","ARPC":"54.5057978659633"},{"_id":33,"retail_area":"Bishopthorpe","month":"2024-08-01 00:00:00","sales":"1476264.7","transactions":"92799","customers":"27986","ATV":"15.9081962090109","ARPC":"52.7501143428857"},{"_id":34,"retail_area":"Bishopthorpe","month":"2024-09-01 00:00:00","sales":"1261966.58","transactions":"86382","customers":"23320","ATV":"14.6091382463939","ARPC":"54.115204974271"},{"_id":35,"retail_area":"Bishopthorpe","month":"2024-10-01 00:00:00","sales":"1243462.77","transactions":"91887","customers":"24219","ATV":"13.532521140096","ARPC":"51.3424489037533"},{"_id":36,"retail_area":"Bishopthorpe","month":"2024-11-01 00:00:00","sales":"1353150.76","transactions":"91458","customers":"23271","ATV":"14.7953241925255","ARPC":"58.1475123544326"},{"_id":37,"retail_area":"Bishopthorpe","month":"2024-12-01 00:00:00","sales":"1472655.28","transactions":"88981","customers":"24222","ATV":"16.5502217327295","ARPC":"60.7982528280076"},{"_id":38,"retail_area":"Bishopthorpe","month":"2025-01-01 00:00:00","sales":"1102802.3","transactions":"79306","customers":"19176","ATV":"13.9056603535672","ARPC":"57.5095066750104"},{"_id":39,"retail_area":"Bishopthorpe","month":"2025-02-01 00:00:00","sales":"1160223.03","transactions":"79712","customers":"19772","ATV":"14.5551865465676","ARPC":"58.680104693506"},{"_id":40,"retail_area":"Bishopthorpe","month":"2025-03-01 00:00:00","sales":"1439300.77","transactions":"95404","customers":"24365","ATV":"15.0863776151943","ARPC":"59.0724715780833"},{"_id":41,"retail_area":"Bishopthorpe","month":"2025-04-01 00:00:00","sales":"1286701.63","transactions":"92545","customers":"24452","ATV":"13.9035240153439","ARPC":"52.6215291182725"},{"_id":42,"retail_area":"Heworth","month":"2022-01-01 00:00:00","sales":"418567.6","transactions":"35074","customers":"9567","ATV":"11.9338427325084","ARPC":"43.7511863698129"},{"_id":43,"retail_area":"Heworth","month":"2022-02-01 00:00:00","sales":"316343.39","transactions":"30612","customers":"8466","ATV":"10.3339667450673","ARPC":"37.3663347507678"},{"_id":44,"retail_area":"Heworth","month":"2022-03-01 00:00:00","sales":"445167.59","transactions":"39422","customers":"11021","ATV":"11.2923644158084","ARPC":"40.3926676345159"},{"_id":45,"retail_area":"Heworth","month":"2022-04-01 00:00:00","sales":"399207.3","transactions":"36001","customers":"10915","ATV":"11.0887836448988","ARPC":"36.5741914796152"},{"_id":46,"retail_area":"Heworth","month":"2022-05-01 00:00:00","sales":"364340.33","transactions":"33142","customers":"11084","ATV":"10.9933115080562","ARPC":"32.8708345362685"},{"_id":47,"retail_area":"Heworth","month":"2022-06-01 00:00:00","sales":"411265.66","transactions":"38062","customers":"11357","ATV":"10.805151069308","ARPC":"36.2125261952981"},{"_id":48,"retail_area":"Heworth","month":"2022-07-01 00:00:00","sales":"432376.44","transactions":"40265","customers":"12148","ATV":"10.738269961505","ARPC":"35.5923971024037"},{"_id":49,"retail_area":"Heworth","month":"2022-08-01 00:00:00","sales":"418621.16","transactions":"36714","customers":"11533","ATV":"11.4022214958871","ARPC":"36.2976814358796"},{"_id":50,"retail_area":"Heworth","month":"2022-09-01 00:00:00","sales":"367707.45","transactions":"32842","customers":"10878","ATV":"11.1962563181292","ARPC":"33.8028543849972"},{"_id":51,"retail_area":"Heworth","month":"2022-10-01 00:00:00","sales":"426193.29","transactions":"32310","customers":"10404","ATV":"13.1907548746518","ARPC":"40.9643685121107"},{"_id":52,"retail_area":"Heworth","month":"2022-11-01 00:00:00","sales":"369402.17","transactions":"33876","customers":"10209","ATV":"10.9045392017948","ARPC":"36.183971985503"},{"_id":53,"retail_area":"Heworth","month":"2022-12-01 00:00:00","sales":"429144.71","transactions":"35068","customers":"10815","ATV":"12.2375017109616","ARPC":"39.6805094775774"},{"_id":54,"retail_area":"Heworth","month":"2023-01-01 00:00:00","sales":"375541.63","transactions":"30689","customers":"9324","ATV":"12.2370109811333","ARPC":"40.2768800943801"},{"_id":55,"retail_area":"Heworth","month":"2023-02-01 00:00:00","sales":"355732.51","transactions":"32151","customers":"11065","ATV":"11.0644306553451","ARPC":"32.1493456845911"},{"_id":56,"retail_area":"Heworth","month":"2023-03-01 00:00:00","sales":"433795.78","transactions":"35346","customers":"11688","ATV":"12.2728393594749","ARPC":"37.114628678987"},{"_id":57,"retail_area":"Heworth","month":"2023-04-01 00:00:00","sales":"528232.66","transactions":"35049","customers":"11535","ATV":"15.0712619475591","ARPC":"45.7939020372779"},{"_id":58,"retail_area":"Heworth","month":"2023-05-01 00:00:00","sales":"478331.28","transactions":"37775","customers":"12916","ATV":"12.6626414295169","ARPC":"37.0340105295757"},{"_id":59,"retail_area":"Heworth","month":"2023-06-01 00:00:00","sales":"445808.02","transactions":"34767","customers":"12168","ATV":"12.8227347772313","ARPC":"36.6377399737015"},{"_id":60,"retail_area":"Heworth","month":"2023-07-01 00:00:00","sales":"396742.46","transactions":"33556","customers":"11627","ATV":"11.8232941947789","ARPC":"34.1225131160231"},{"_id":61,"retail_area":"Heworth","month":"2023-08-01 00:00:00","sales":"424833.99","transactions":"35368","customers":"11470","ATV":"12.011818310337","ARPC":"37.0387088055798"},{"_id":62,"retail_area":"Heworth","month":"2023-09-01 00:00:00","sales":"451760.76","transactions":"34431","customers":"11230","ATV":"13.1207562951991","ARPC":"40.2280284951024"},{"_id":63,"retail_area":"Heworth","month":"2023-10-01 00:00:00","sales":"452222.97","transactions":"31452","customers":"10318","ATV":"14.3781943914536","ARPC":"43.8285491374297"},{"_id":64,"retail_area":"Heworth","month":"2023-11-01 00:00:00","sales":"442243.42","transactions":"32673","customers":"10415","ATV":"13.5354396596578","ARPC":"42.4621622659626"},{"_id":65,"retail_area":"Heworth","month":"2023-12-01 00:00:00","sales":"402326.66","transactions":"32059","customers":"10480","ATV":"12.5495698555788","ARPC":"38.3899484732824"},{"_id":66,"retail_area":"Heworth","month":"2024-01-01 00:00:00","sales":"383041.91","transactions":"29113","customers":"10026","ATV":"13.1570745027994","ARPC":"38.2048583682426"},{"_id":67,"retail_area":"Heworth","month":"2024-02-01 00:00:00","sales":"392169.22","transactions":"30261","customers":"10080","ATV":"12.9595591685668","ARPC":"38.9056765873016"},{"_id":68,"retail_area":"Heworth","month":"2024-03-01 00:00:00","sales":"412390.03","transactions":"31203","customers":"10216","ATV":"13.2163583629779","ARPC":"40.3670741973375"},{"_id":69,"retail_area":"Heworth","month":"2024-04-01 00:00:00","sales":"356187.56","transactions":"29323","customers":"9629","ATV":"12.1470367970535","ARPC":"36.9911268044449"},{"_id":70,"retail_area":"Heworth","month":"2024-05-01 00:00:00","sales":"417939.67","transactions":"32315","customers":"10960","ATV":"12.9333024911032","ARPC":"38.1331815693431"},{"_id":71,"retail_area":"Heworth","month":"2024-06-01 00:00:00","sales":"398005.78","transactions":"32460","customers":"10995","ATV":"12.2614226740604","ARPC":"36.1987976352888"},{"_id":72,"retail_area":"Heworth","month":"2024-07-01 00:00:00","sales":"435531","transactions":"29950","customers":"12079","ATV":"14.5419365609349","ARPC":"36.0568755691696"},{"_id":73,"retail_area":"Heworth","month":"2024-08-01 00:00:00","sales":"424250.99","transactions":"29640","customers":"10068","ATV":"14.3134612010796","ARPC":"42.1385568136671"},{"_id":74,"retail_area":"Heworth","month":"2024-09-01 00:00:00","sales":"387259.31","transactions":"29406","customers":"10674","ATV":"13.1693977419574","ARPC":"36.2806173880457"},{"_id":75,"retail_area":"Heworth","month":"2024-10-01 00:00:00","sales":"418460.15","transactions":"29385","customers":"10726","ATV":"14.2406040496852","ARPC":"39.0136257691591"},{"_id":76,"retail_area":"Heworth","month":"2024-11-01 00:00:00","sales":"442961.02","transactions":"28345","customers":"10236","ATV":"15.6274835067913","ARPC":"43.2748163345057"},{"_id":77,"retail_area":"Heworth","month":"2024-12-01 00:00:00","sales":"432733.17","transactions":"28473","customers":"10102","ATV":"15.1980181224318","ARPC":"42.8363858641853"},{"_id":78,"retail_area":"Heworth","month":"2025-01-01 00:00:00","sales":"347174.24","transactions":"27120","customers":"10090","ATV":"12.8014100294985","ARPC":"34.4077542120912"},{"_id":79,"retail_area":"Heworth","month":"2025-02-01 00:00:00","sales":"473344.51","transactions":"29824","customers":"11391","ATV":"15.871261735515","ARPC":"41.5542542358002"},{"_id":80,"retail_area":"Heworth","month":"2025-03-01 00:00:00","sales":"427450.98","transactions":"33532","customers":"11202","ATV":"12.7475539782894","ARPC":"38.1584520621318"},{"_id":81,"retail_area":"Heworth","month":"2025-04-01 00:00:00","sales":"481637.78","transactions":"34201","customers":"12025","ATV":"14.0825642525072","ARPC":"40.0530378378378"},{"_id":82,"retail_area":"Micklegate","month":"2022-01-01 00:00:00","sales":"1282909.87","transactions":"117976","customers":"51111","ATV":"10.8743292703601","ARPC":"25.1004650662284"},{"_id":83,"retail_area":"Micklegate","month":"2022-02-01 00:00:00","sales":"1794912.42","transactions":"148482","customers":"69654","ATV":"12.08841758597","ARPC":"25.768978378844"},{"_id":84,"retail_area":"Micklegate","month":"2022-03-01 00:00:00","sales":"1696356.98","transactions":"171989","customers":"73561","ATV":"9.86317136561059","ARPC":"23.0605481165291"},{"_id":85,"retail_area":"Micklegate","month":"2022-04-01 00:00:00","sales":"1998565.35","transactions":"175662","customers":"84956","ATV":"11.377334597124","ARPC":"23.5247110268845"},{"_id":86,"retail_area":"Micklegate","month":"2022-05-01 00:00:00","sales":"1802609.59","transactions":"174380","customers":"80229","ATV":"10.3372496272508","ARPC":"22.4683043537873"},{"_id":87,"retail_area":"Micklegate","month":"2022-06-01 00:00:00","sales":"1620932.76","transactions":"162836","customers":"72585","ATV":"9.95438821882139","ARPC":"22.3315114693118"},{"_id":88,"retail_area":"Micklegate","month":"2022-07-01 00:00:00","sales":"1840413.07","transactions":"174402","customers":"79571","ATV":"10.5527062189654","ARPC":"23.129193676088"},{"_id":89,"retail_area":"Micklegate","month":"2022-08-01 00:00:00","sales":"2043679.2","transactions":"192624","customers":"91155","ATV":"10.6096810366309","ARPC":"22.4198255718282"},{"_id":90,"retail_area":"Micklegate","month":"2022-09-01 00:00:00","sales":"1629451.1","transactions":"162340","customers":"73474","ATV":"10.037274239251","ARPC":"22.1772477338923"},{"_id":91,"retail_area":"Micklegate","month":"2022-10-01 00:00:00","sales":"2075081.38","transactions":"193661","customers":"88281","ATV":"10.7150194411885","ARPC":"23.5054131693116"},{"_id":92,"retail_area":"Micklegate","month":"2022-11-01 00:00:00","sales":"1930423.85","transactions":"189003","customers":"83634","ATV":"10.2137206816823","ARPC":"23.081807040199"},{"_id":93,"retail_area":"Micklegate","month":"2022-12-01 00:00:00","sales":"2512528.79","transactions":"222150","customers":"112165","ATV":"11.31005532298","ARPC":"22.4002923371818"},{"_id":94,"retail_area":"Micklegate","month":"2023-01-01 00:00:00","sales":"1445472.46","transactions":"156504","customers":"61923","ATV":"9.23600968665338","ARPC":"23.3430625131211"},{"_id":95,"retail_area":"Micklegate","month":"2023-02-01 00:00:00","sales":"1879530.5","transactions":"186102","customers":"82316","ATV":"10.0994642722808","ARPC":"22.8331126390981"},{"_id":96,"retail_area":"Micklegate","month":"2023-03-01 00:00:00","sales":"1763652.5","transactions":"187808","customers":"75890","ATV":"9.39072084256262","ARPC":"23.2395901963368"},{"_id":97,"retail_area":"Micklegate","month":"2023-04-01 00:00:00","sales":"2089709.34","transactions":"198149","customers":"90111","ATV":"10.5461513305644","ARPC":"23.1903911842061"},{"_id":98,"retail_area":"Micklegate","month":"2023-05-01 00:00:00","sales":"1942440.79","transactions":"195477","customers":"82822","ATV":"9.93692756692603","ARPC":"23.4531983047982"},{"_id":99,"retail_area":"Micklegate","month":"2023-06-01 00:00:00","sales":"1655714.45","transactions":"180379","customers":"77642","ATV":"9.17908653446355","ARPC":"21.3249845444476"},{"_id":100,"retail_area":"Micklegate","month":"2023-07-01 00:00:00","sales":"2175373.13","transactions":"214756","customers":"92529","ATV":"10.1295103745646","ARPC":"23.5101765932843"}], "fields": [{"id": "_id", "type": "int"}, {"id": "retail_area", "type": "text"}, {"id": "month", "type": "text"}, {"id": "sales", "type": "text"}, {"id": "transactions", "type": "text"}, {"id": "customers", "type": "text"}, {"id": "ATV", "type": "text"}, {"id": "ARPC", "type": "text"}], "_links": {"start": "/api/action/datastore_search?resource_id=dddc9035-faaf-40c3-97ae-90856f3e40a8", "next": "/api/action/datastore_search?resource_id=dddc9035-faaf-40c3-97ae-90856f3e40a8&offset=100"}, "total": 121, "total_was_estimated": false}}