{"help": "https://datosabiertos.bogota.gov.co/pl/api/3/action/help_show?name=datastore_search", "success": true, "result": {"include_total": true, "limit": 100, "records_format": "objects", "resource_id": "70e6aa93-b2c5-44a5-8062-08ab51e07b3f", "total_estimation_threshold": null, "records": [{"_id":1,"CREDITO":"PEC 10D12","MONEDA DE ORIGEN":"COP","TASA DE INTERES":"IPC + 4,35%","SPREAD":"4,35%","MODALIDAD":"A.V","SALDO MONEDA ORG.":"103000","VENCIMIENTO":"2/12/2033","SALDO COP":"103000","VIDA MEDIA":"11,6","DUR":"0,090410959","DM":"0,087668142"},{"_id":2,"CREDITO":"PEC 10O20","MONEDA DE ORIGEN":"UVR","TASA DE INTERES":"UVR + 4,53%","SPREAD":"4,53%","MODALIDAD":"T.V","SALDO MONEDA ORG.":"205,9","VENCIMIENTO":"2/12/2041","SALDO COP":"62310,87871","VIDA MEDIA":"19,60547945","DUR":"13,16215959","DM":"12,59328166"},{"_id":3,"CREDITO":"PEC 9D4","MONEDA DE ORIGEN":"COP","TASA DE INTERES":"IPC + 1,3%","SPREAD":"1,30%","MODALIDAD":"T.V","SALDO MONEDA ORG.":"240550","VENCIMIENTO":"25/02/2025","SALDO COP":"240550","VIDA MEDIA":"2,82739726","DUR":"0,068493151","DM":"0,066704871"},{"_id":4,"CREDITO":"PEC 9O10","MONEDA DE ORIGEN":"COP","TASA DE INTERES":"IPC + 2,7%","SPREAD":"2,70%","MODALIDAD":"T.V","SALDO MONEDA ORG.":"59160","VENCIMIENTO":"25/02/2031","SALDO COP":"59160","VIDA MEDIA":"8,830136986","DUR":"0,068493151","DM":"0,066704871"},{"_id":5,"CREDITO":"PEC 9D15","MONEDA DE ORIGEN":"UVR","TASA DE INTERES":"UVR+3,30%","SPREAD":"3,30%","MODALIDAD":"A.V","SALDO MONEDA ORG.":"787,67","VENCIMIENTO":"25/02/2036","SALDO COP":"238370,1303","VIDA MEDIA":"13,83287671","DUR":"11,26488654","DM":"10,90502085"},{"_id":6,"CREDITO":"PEC 9O25","MONEDA DE ORIGEN":"UVR","TASA DE INTERES":"UVR+3,85%","SPREAD":"3,85%","MODALIDAD":"A.V","SALDO MONEDA ORG.":"1590,53","VENCIMIENTO":"25/02/2046","SALDO COP":"481337,1633","VIDA MEDIA":"23,84109589","DUR":"15,91355584","DM":"15,32359734"},{"_id":7,"CREDITO":"PEC 8D10","MONEDA DE ORIGEN":"COP","TASA DE INTERES":"IPC+3,70%","SPREAD":"3,70%","MODALIDAD":"T.V","SALDO MONEDA ORG.":"212550","VENCIMIENTO":"21/05/2030","SALDO COP":"212550","VIDA MEDIA":"8,063013699","DUR":"0,057534247","DM":"0,056271546"},{"_id":8,"CREDITO":"PEC 8O20","MONEDA DE ORIGEN":"UVR","TASA DE INTERES":"UVR+3,93%","SPREAD":"3,93%","MODALIDAD":"A.V","SALDO MONEDA ORG.":"1402,88","VENCIMIENTO":"21/05/2040","SALDO COP":"424549,2255","VIDA MEDIA":"18,07123288","DUR":"12,79751064","DM":"12,31358669"},{"_id":9,"CREDITO":"PEC 7A5","MONEDA DE ORIGEN":"COP","TASA DE INTERES":"0,0594","SPREAD":"0,0594","MODALIDAD":"A.V","SALDO MONEDA ORG.":"300000","VENCIMIENTO":"24/10/2024","SALDO COP":"300000","VIDA MEDIA":"2,487671233","DUR":"2,341504506","DM":"2,210217582"},{"_id":10,"CREDITO":"PEC 7D10","MONEDA DE ORIGEN":"COP","TASA DE INTERES":"IPC+2,79%","SPREAD":"2,79%","MODALIDAD":"T.V","SALDO MONEDA ORG.":"300000","VENCIMIENTO":"24/10/2029","SALDO COP":"300000","VIDA MEDIA":"7,490410959","DUR":"0,232876712","DM":"0,226883785"},{"_id":11,"CREDITO":"PEC 7O20","MONEDA DE ORIGEN":"UVR","TASA DE INTERES":"UVR+3,33%","SPREAD":"3,33%","MODALIDAD":"A.V","SALDO MONEDA ORG.":"1483,01","VENCIMIENTO":"24/10/2039","SALDO COP":"448798,719","VIDA MEDIA":"17,49589041","DUR":"13,31575379","DM":"12,88662904"},{"_id":12,"CREDITO":"PEC 7O29","MONEDA DE ORIGEN":"UVR","TASA DE INTERES":"UVR+3,49%","SPREAD":"3,49%","MODALIDAD":"A.V","SALDO MONEDA ORG.":"1483,01","VENCIMIENTO":"24/10/2048","SALDO COP":"448798,719","VIDA MEDIA":"26,50410959","DUR":"17,39543007","DM":"16,80880285"},{"_id":13,"CREDITO":"GLOBAL PESOS","MONEDA DE ORIGEN":"COP","TASA DE INTERES":"0,0975","SPREAD":"0,0975","MODALIDAD":"A.V","SALDO MONEDA ORG.":"578577","VENCIMIENTO":"26/07/2028","SALDO COP":"578577","VIDA MEDIA":"5,242009132","DUR":"4,037166108","DM":"3,67851126"},{"_id":14,"CREDITO":"CORBANCA - SED*","MONEDA DE ORIGEN":"COP","TASA DE INTERES":"DTF-2,40%","SPREAD":"2,40%","MODALIDAD":"T.V","SALDO MONEDA ORG.":"10172,00894","VENCIMIENTO":"13/06/2026","SALDO COP":"10172,00894","VIDA MEDIA":"2,122481865","DUR":"0,120547945","DM":"0,116639617"},{"_id":15,"CREDITO":"BBVA - CABLE","MONEDA DE ORIGEN":"COP","TASA DE INTERES":"IBR-1,97%","SPREAD":"1,97%","MODALIDAD":"T.V","SALDO MONEDA ORG.":"11025,54282","VENCIMIENTO":"26/02/2028","SALDO COP":"11025,54282","VIDA MEDIA":"2,951141553","DUR":"0,071232877","DM":"0,069897142"},{"_id":16,"CREDITO":"BBVA-CABLE-2","MONEDA DE ORIGEN":"COP","TASA DE INTERES":"IBR+0,25%","SPREAD":"0,25%","MODALIDAD":"T.V","SALDO MONEDA ORG.":"47500","VENCIMIENTO":"17/09/2031","SALDO COP":"47500","VIDA MEDIA":"4,760201875","DUR":"0,131506849","DM":"0,126041891"},{"_id":17,"CREDITO":"BBVA-C_F","MONEDA DE ORIGEN":"COP","TASA DE INTERES":"IBR+0,25%","SPREAD":"0,25%","MODALIDAD":"T.V","SALDO MONEDA ORG.":"208907,927","VENCIMIENTO":"3/03/2032","SALDO COP":"208907,927","VIDA MEDIA":"4,971986301","DUR":"0,093150685","DM":"0,089360828"},{"_id":18,"CREDITO":"BANCOLOMBIA*10","MONEDA DE ORIGEN":"COP","TASA DE INTERES":"IBR-2,02%","SPREAD":"2,02%","MODALIDAD":"T.V","SALDO MONEDA ORG.":"8000","VENCIMIENTO":"27/02/2030","SALDO COP":"8000","VIDA MEDIA":"3,954794521","DUR":"0,073972603","DM":"0,072621124"},{"_id":19,"CREDITO":"BANCOLOMBIA","MONEDA DE ORIGEN":"COP","TASA DE INTERES":"DTF-1,18%","SPREAD":"1,18%","MODALIDAD":"T.V","SALDO MONEDA ORG.":"42000","VENCIMIENTO":"30/01/2029","SALDO COP":"42000","VIDA MEDIA":"3,378375734","DUR":"0,252777778","DM":"0,241564891"},{"_id":20,"CREDITO":"BBVA 2022 ","MONEDA DE ORIGEN":"COP","TASA DE INTERES":"IBR+1,59%","SPREAD":"1,59%","MODALIDAD":"T.V","SALDO MONEDA ORG.":"230000","VENCIMIENTO":"25/01/2034","SALDO COP":"230000","VIDA MEDIA":"7,117351598","DUR":"0,235616438","DM":"0,220428888"},{"_id":21,"CREDITO":"BANBOGOTÁ 2022 ","MONEDA DE ORIGEN":"COP","TASA DE INTERES":"IBR+1,90%","SPREAD":"1,90%","MODALIDAD":"T.V","SALDO MONEDA ORG.":"366667","VENCIMIENTO":"25/01/2034","SALDO COP":"366667","VIDA MEDIA":"6,617054795","DUR":"0,235616438","DM":"0,219783253"},{"_id":22,"CREDITO":"Popular 2022 ","MONEDA DE ORIGEN":"COP","TASA DE INTERES":"IBR+1,90%","SPREAD":"1,90%","MODALIDAD":"T.V","SALDO MONEDA ORG.":"220000","VENCIMIENTO":"25/01/2034","SALDO COP":"220000","VIDA MEDIA":"6,617054795","DUR":"0,235616438","DM":"0,219783253"},{"_id":23,"CREDITO":"Occidente 2022 ","MONEDA DE ORIGEN":"COP","TASA DE INTERES":"IBR+1,90%","SPREAD":"1,90%","MODALIDAD":"T.V","SALDO MONEDA ORG.":"95333","VENCIMIENTO":"25/01/2034","SALDO COP":"95333","VIDA MEDIA":"6,617054795","DUR":"0,235616438","DM":"0,219783253"},{"_id":24,"CREDITO":"AV Villas 2022 ","MONEDA DE ORIGEN":"COP","TASA DE INTERES":"IBR+1,90%","SPREAD":"1,90%","MODALIDAD":"T.V","SALDO MONEDA ORG.":"88000","VENCIMIENTO":"25/01/2034","SALDO COP":"88000","VIDA MEDIA":"6,617054795","DUR":"0,235616438","DM":"0,219783253"},{"_id":25,"CREDITO":"BBVA COL-02005-21","MONEDA DE ORIGEN":"COP","TASA DE INTERES":"0,0853","SPREAD":"0,0853","MODALIDAD":"S.V.","SALDO MONEDA ORG.":"1000000","VENCIMIENTO":"17/11/2028","SALDO COP":"1000000","VIDA MEDIA":"4,051805729","DUR":"3,480308409","DM":"3,206770855"},{"_id":26,"CREDITO":"CONVERSIÓN 7365","MONEDA DE ORIGEN":"COP","TASA DE INTERES":"0,0802","SPREAD":"0,0802","MODALIDAD":"S.V.","SALDO MONEDA ORG.":"553,7916652","VENCIMIENTO":"15/08/2022","SALDO COP":"553,7916652","VIDA MEDIA":"0,293150685","DUR":"0,293150685","DM":"0,271385563"},{"_id":27,"CREDITO":"CAF 4081","MONEDA DE ORIGEN":"USD","TASA DE INTERES":"LB6M+1,45%","SPREAD":"1,45%","MODALIDAD":"S.V.","SALDO MONEDA ORG.":"13250","VENCIMIENTO":"26/06/2025","SALDO COP":"52553,0775","VIDA MEDIA":"1,714603257","DUR":"0,156164384","DM":"0,151147935"},{"_id":28,"CREDITO":"CAF 4536","MONEDA DE ORIGEN":"USD","TASA DE INTERES":"LB6M+1,35%","SPREAD":"1,35%","MODALIDAD":"S.V.","SALDO MONEDA ORG.":"16500","VENCIMIENTO":"27/12/2025","SALDO COP":"65443,455","VIDA MEDIA":"1,977716895","DUR":"0,15890411","DM":"0,153948656"},{"_id":29,"CREDITO":"IFC 26473","MONEDA DE ORIGEN":"USD","TASA DE INTERES":"LB6M+1,31%","SPREAD":"1,31%","MODALIDAD":"S.V.","SALDO MONEDA ORG.":"10500","VENCIMIENTO":"15/06/2025","SALDO COP":"41645,835","VIDA MEDIA":"1,62778865","DUR":"0,126027397","DM":"0,122144544"},{"_id":30,"CREDITO":"BID 1385 OC-CO","MONEDA DE ORIGEN":"USD","TASA DE INTERES":"BID - SCF","SPREAD":"SFC","MODALIDAD":"S.V.","SALDO MONEDA ORG.":"0","VENCIMIENTO":"5/04/2022","SALDO COP":"0","VIDA MEDIA":"0","DUR":"0","DM":"0"},{"_id":31,"CREDITO":"BID 1812","MONEDA DE ORIGEN":"USD","TASA DE INTERES":"4,59% + MKO","SPREAD":"4,59%","MODALIDAD":"S.V.","SALDO MONEDA ORG.":"12282,56672","VENCIMIENTO":"15/12/2031","SALDO COP":"48715,9759","VIDA MEDIA":"4,879999969","DUR":"0,126027397","DM":"0,120496603"},{"_id":32,"CREDITO":"BID 1812 2","MONEDA DE ORIGEN":"USD","TASA DE INTERES":"LB3M +1,05% + MKO","SPREAD":"1,05%","MODALIDAD":"S.V.","SALDO MONEDA ORG.":"17063,56426","VENCIMIENTO":"15/12/2031","SALDO COP":"67678,70301","VIDA MEDIA":"4,879999953","DUR":"0,126027397","DM":"0,12471786"},{"_id":33,"CREDITO":"IFC 39772","MONEDA DE ORIGEN":"USD","TASA DE INTERES":"LB6M+1,65%","SPREAD":"1,65%","MODALIDAD":"S.V.","SALDO MONEDA ORG.":"28686,24678","VENCIMIENTO":"15/12/2034","SALDO COP":"113777,4","VIDA MEDIA":"6,386617492","DUR":"0,131506849","DM":"0,127136331"},{"_id":34,"CREDITO":"IFC 38347","MONEDA DE ORIGEN":"USD","TASA DE INTERES":"LB6M+1,65%","SPREAD":"1,65%","MODALIDAD":"S.V.","SALDO MONEDA ORG.":"28806,35963","VENCIMIENTO":"15/12/2034","SALDO COP":"114253,8","VIDA MEDIA":"6,549631191","DUR":"0,252054795","DM":"0,243093595"},{"_id":35,"CREDITO":"BIRF 7365","MONEDA DE ORIGEN":"USD","TASA DE INTERES":"LB6M+0,50%","SPREAD":"0,50%","MODALIDAD":"S.V.","SALDO MONEDA ORG.":"2531,218651","VENCIMIENTO":"15/08/2022","SALDO COP":"10039,4966","VIDA MEDIA":"0,293150685","DUR":"0,293150685","DM":"0,290121813"},{"_id":36,"CREDITO":"ICO","MONEDA DE ORIGEN":"USD","TASA DE INTERES":"0,01","SPREAD":"0,01","MODALIDAD":"S.V.","SALDO MONEDA ORG.":"3243,89732","VENCIMIENTO":"24/02/2029","SALDO COP":"12866,17262","VIDA MEDIA":"3,57221123","DUR":"3,512271064","DM":"3,477496103"},{"_id":37,"CREDITO":"KFW","MONEDA DE ORIGEN":"EUR","TASA DE INTERES":"0,02","SPREAD":"0,02","MODALIDAD":"S.V.","SALDO MONEDA ORG.":"2162,01474","VENCIMIENTO":"30/12/2037","SALDO COP":"9038,19145","VIDA MEDIA":"6,350573473","DUR":"7,357345752","DM":"7,21308407"}], "fields": [{"id": "_id", "type": "int"}, {"id": "CREDITO", "type": "text"}, {"id": "MONEDA DE ORIGEN", "type": "text"}, {"id": "TASA DE INTERES", "type": "text"}, {"id": "SPREAD", "type": "text"}, {"id": "MODALIDAD", "type": "text"}, {"id": "SALDO MONEDA ORG.", "type": "text"}, {"id": "VENCIMIENTO", "type": "text"}, {"id": "SALDO COP", "type": "text"}, {"id": "VIDA MEDIA", "type": "text"}, {"id": "DUR", "type": "text"}, {"id": "DM", "type": "text"}], "_links": {"start": "/api/3/action/datastore_search?resource_id=70e6aa93-b2c5-44a5-8062-08ab51e07b3f", "next": "/api/3/action/datastore_search?resource_id=70e6aa93-b2c5-44a5-8062-08ab51e07b3f&offset=100"}, "total": 37, "total_was_estimated": false}}