{"help": "https://datosabiertos.bogota.gov.co/en/api/3/action/help_show?name=datastore_search", "success": true, "result": {"include_total": true, "limit": 100, "records_format": "objects", "resource_id": "dbe3d399-ed3e-44e5-8108-6eaa40ada15b", "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,68219178","DUR":"0,17260274","DM":"0,167346981"},{"_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":"61518,47256","VIDA MEDIA":"19,68767123","DUR":"13,24434775","DM":"12,67191759"},{"_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,909589041","DUR":"0,150684932","DM":"0,146803518"},{"_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,912328767","DUR":"0,150684932","DM":"0,146803518"},{"_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":"235338,7823","VIDA MEDIA":"13,91506849","DUR":"11,34707832","DM":"10,98458695"},{"_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":"475216,0086","VIDA MEDIA":"23,92328767","DUR":"15,99574762","DM":"15,40274205"},{"_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,145205479","DUR":"0,139726027","DM":"0,136659469"},{"_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":"419150,2418","VIDA MEDIA":"18,15342466","DUR":"12,87970242","DM":"12,39267047"},{"_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,569863014","DUR":"2,393555501","DM":"2,259350105"},{"_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,57260274","DUR":"0,065753425","DM":"0,064488458"},{"_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":"443091,355","VIDA MEDIA":"17,57808219","DUR":"13,39794557","DM":"12,96617204"},{"_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":"443091,355","VIDA MEDIA":"26,58630137","DUR":"17,47759227","DM":"16,88819429"},{"_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,324200913","DUR":"4,119357889","DM":"3,753401266"},{"_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,204673646","DUR":"0,202739726","DM":"0,197277717"},{"_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":"3,033333333","DUR":"0,153424658","DM":"0,150547691"},{"_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,842393655","DUR":"0,21369863","DM":"0,204818073"},{"_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":"5,054178082","DUR":"0,175342466","DM":"0,168208617"},{"_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":"4,036986301","DUR":"0,156164384","DM":"0,153311261"},{"_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,460567515","DUR":"0,083333333","DM":"0,081706127"},{"_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,199543379","DUR":"0,068493151","DM":"0,06549793"},{"_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,699246575","DUR":"0,068493151","DM":"0,065302472"},{"_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,699246575","DUR":"0,068493151","DM":"0,065302472"},{"_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,699246575","DUR":"0,068493151","DM":"0,065302472"},{"_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,699246575","DUR":"0,068493151","DM":"0,065302472"},{"_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,133997509","DUR":"3,56250019","DM":"3,282502709"},{"_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,375342466","DUR":"0,375342466","DM":"0,347474973"},{"_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":"49767,3975","VIDA MEDIA":"1,796795037","DUR":"0,238356164","DM":"0,23046571"},{"_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":"61974,495","VIDA MEDIA":"2,059908676","DUR":"0,24109589","DM":"0,233340357"},{"_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":"39438,315","VIDA MEDIA":"1,709980431","DUR":"0,208219178","DM":"0,201599263"},{"_id":30,"CREDITO":"BID 1385 OC-CO","MONEDA DE ORIGEN":"USD","TASA DE INTERES":"BID - SCF","SPREAD":"SCF","MODALIDAD":"S.V.","SALDO MONEDA ORG.":"483,5331797","VENCIMIENTO":"5/04/2022","SALDO COP":"1816,165129","VIDA MEDIA":"0,01369863","DUR":"0,01369863","DM":"0,013435957"},{"_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":"46133,68908","VIDA MEDIA":"4,96219175","DUR":"0,208219178","DM":"0,199081344"},{"_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":"64091,25926","VIDA MEDIA":"4,962191733","DUR":"0,208219178","DM":"0,206055594"},{"_id":33,"CREDITO":"IFC 39772","MONEDA DE ORIGEN":"USD","TASA DE INTERES":"LB6M+1,65%","SPREAD":"1,65%","MODALIDAD":"S.V.","SALDO MONEDA ORG.":"30291,93058","VENCIMIENTO":"15/12/2034","SALDO COP":"113777,4","VIDA MEDIA":"6,468809273","DUR":"0,21369863","DM":"0,206596538"},{"_id":34,"CREDITO":"IFC 38347","MONEDA DE ORIGEN":"USD","TASA DE INTERES":"LB6M+1,65%","SPREAD":"1,65%","MODALIDAD":"S.V.","SALDO MONEDA ORG.":"30418,76662","VENCIMIENTO":"15/12/2034","SALDO COP":"114253,8","VIDA MEDIA":"6,546891465","DUR":"0,334246575","DM":"0,322363245"},{"_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":"9507,33319","VIDA MEDIA":"0,375342466","DUR":"0,375342466","DM":"0,371464378"},{"_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":"12184,17565","VIDA MEDIA":"3,654403011","DUR":"3,594462845","DM":"3,558874104"},{"_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":"9014,669428","VIDA MEDIA":"6,416347916","DUR":"7,439537532","DM":"7,293664247"}], "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=dbe3d399-ed3e-44e5-8108-6eaa40ada15b", "next": "/api/3/action/datastore_search?resource_id=dbe3d399-ed3e-44e5-8108-6eaa40ada15b&offset=100"}, "total": 37, "total_was_estimated": false}}