Sujetos pasivos de lobby o gestión de intereses particulares

Todos Vigente No Vigente
Nombre completo Cargo o función Fecha de incorporación Fecha de término Respaldo jurídico Registros
Ricardo Jaramillo Alcalde 28-10-2022 05-12-2028 Sentencia y Acta de Proclamación del Tribunal Electoral Regional de La Araucanía.<br />Ver documento Audiencias Viajes Donativos
Mario Emilio Pérez Rebolledo Concejal(a) 06-12-2016 Indefinido Proclamación
Ver documento		 Audiencias Viajes Donativos
Erwin Hauri Concejal 06-12-2024 05-12-2028 Sentencia en causa Rol N° 187-2021 del TER Araucanía de fecha 01.06.2021
Ver documento		 Audiencias Viajes Donativos
Piero Jara Concejal 06-12-2024 05-12-2028 Sentencia y Acta de Proclamación del Tribunal Electoral Regional de La Araucanía.
Ver documento		 Audiencias Viajes Donativos
Ricardo Ojeda Concejal 06-12-2024 05-12-2028 Sentencia y Acta de Proclamación del Tribunal Electoral Regional de La Araucanía.
Ver documento		 Audiencias Viajes Donativos
Germán Ortiz Concejal 28-06-2021 05-12-2028 Sentencia y Acta de Proclamación del Tribunal Electoral Regional de La Araucanía.
Ver documento		 Audiencias Viajes Donativos
Elias Jesús Pantoja Ferrerira Concejal 06-12-2024 05-12-2028 Sentencia y Acta de Proclamación del Tribunal Electoral Regional de La Araucanía.
Ver documento		 Audiencias Viajes Donativos
Carmen Phillips Concejala 06-12-2024 05-12-2028 Sentencia y Acta de Proclamación del Tribunal Electoral Regional de La Araucanía.
Ver documento		 Audiencias Viajes Donativos
José Bustos Director(a) de Obras Municipales 28-08-2015 Indefinido Ver documento Audiencias Viajes Donativos
Sergio Zúñiga Secretario(a) Municipal 13-03-2020 Indefinido NOMBRASE en el cargo de Secretario Municipal titular, Planta Directivo, Grado 6 de la EUM, de la Municipalidad de Lautaro, al funcionario SERGIO ENRIQUE ZÚÑIGA IBÁÑEZ, Cédula de Identidad N° 13.517.390-8.- (Decreto de Personal N° 616 del 13.03.2020)
Ver documento		 Audiencias Viajes Donativos
MessagesRequestTimelineExceptionsViews3Queries15Models21MailsGate
SettingsRequest history146msRequest Duration2MBMemory Usage10.x
Laravel Version
10.48.29
PHP Version
8.2.28
Environment
production
Debug Mode
Enabled
URL
devinterno-lobby.minsegpres.gob.cl
Timezone
America/Santiago
Locale
es
GET instituciones/{institucionCodigo}/cargos-pasivos
status
200 OK
full_url
http://devinterno-lobby.minsegpres.gob.cl/instituciones/MU136/cargos-pasivos?q=var%2Fwww%2Fhtml%2Flo...
controller_action
App\Http\Controllers\CargoPasivoController@index
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
    status
    200 OK
    full_url
    http://devinterno-lobby.minsegpres.gob.cl/instituciones/MU136/cargos-pasivos?q=var%2Fwww%2Fhtml%2Flo...
    action_name
    controller_action
    App\Http\Controllers\CargoPasivoController@index
    uri
    GET instituciones/{institucionCodigo}/cargos-pasivos
    controller
    App\Http\Controllers\CargoPasivoController@index
    file
    app/Http/Controllers/CargoPasivoController.php:13-104
    middleware
    web
    duration
    147ms
    peak_memory
    4MB
    response
    text/html; charset=UTF-8
    request_format
    html
    request_query
      0 of 0   
    array:1 [▼
  "q" => "var/www/html/lobby/public/instituciones/MU136/cargos-pasivos"
]
    request_request
    []
    request_headers
      0 of 0   
    array:24 [▼
  "via" => array:1 [▶
    0 => "HTTP/2.0 Azure"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "216.73.216.145"
  ]
  "x-forwarded-host" => array:1 [▶
    0 => "devinterno-lobby.minsegpres.gob.cl"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "host" => array:1 [▶
    0 => "devinterno-lobby.minsegpres.gob.cl"
  ]
  "x-azure-fdid" => array:1 [▶
    0 => "ac47273c-7e27-47a2-a0c7-c2ad3c620cff"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "x-azure-ref" => array:1 [▶
    0 => "20250813T184044Z-16577bdcc9bk9jnfhC1CHIqadg0000000b6000000000ca8e"
  ]
  "x-azure-clientip" => array:1 [▶
    0 => "216.73.216.145"
  ]
  "x-azure-socketip" => array:1 [▶
    0 => "216.73.216.145"
  ]
  "x-azure-requestchainv2" => array:1 [▶
    0 => "hops=1"
  ]
]
    request_cookies
    []
    response_headers
      0 of 0   
    array:3 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Wed, 13 Aug 2025 18:40:44 GMT"
  ]
]
    session_attributes
      0 of 0   
    array:1 [▼
  "_token" => "v24ZwjIrPOYlRkXbt2ToVAkvi3GLyKtjxihhXjzF"
]
    • Booting (25.7ms)time
    • Application (120ms)time
    • Routing (7.49ms)
    • Preparing Response (21.74ms)
    • View: layouts.principal_LFv2views
    • View: cargos-pasivos.indexviews
    • View: pagination::bootstrap-4views
    • 1 x Application (82.38%)
      120ms
      1 x Booting (17.61%)
      25.70ms
      1 x Preparing Response (14.9%)
      21.74ms
      1 x Routing (5.13%)
      7.49ms
      3 x View (0%)
      0μs
      3 templates were rendered
      • layouts.principal_LFv2principal_LFv2.blade.php#?blade
      • cargos-pasivos.indexindex.blade.php#?blade
      • pagination::bootstrap-4bootstrap-4.blade.php#?blade
      15 statements were executed95.24ms
      • CargoPasivoController.php#17lobby_db7Connection Established
        Backtrace
        • app/Http/Controllers/CargoPasivoController.php:17
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • CargoPasivoController.php#17lobby_db732msselect * from "instituciones" where "codigo" = 'MU136' and "instituciones"."deleted_at" is null limit 1
        Bindings
        • 0: MU136
        Backtrace
        • app/Http/Controllers/CargoPasivoController.php:17
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • CargoPasivoController.php#60lobby_db74.08msselect count(*) as aggregate from "pertenencias" left join "usuarios" as "u" on "u"."id" = "pertenencias"."usuario_id" where "pertenencias"."institucion_id" = 544 and "pertenencias"."institucion_id" is not null and "cargo_pasivo" = 1 and ((NOW() - fecha_inicio) >= INTERVAL '0' DAY and (NOW() - COALESCE(fecha_termino, '9999-12-31'::DATE)) <= INTERVAL '0' DAY) and "tipo_id" = 15 and "pertenencias"."deleted_at" is null
        Bindings
        • 0: 544
        • 1: 1
        • 2: 15
        Backtrace
        • app/Http/Controllers/CargoPasivoController.php:60
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • CargoPasivoController.php#60lobby_db74.13msselect "pertenencias".* from "pertenencias" left join "usuarios" as "u" on "u"."id" = "pertenencias"."usuario_id" where "pertenencias"."institucion_id" = 544 and "pertenencias"."institucion_id" is not null and "cargo_pasivo" = 1 and ((NOW() - fecha_inicio) >= INTERVAL '0' DAY and (NOW() - COALESCE(fecha_termino, '9999-12-31'::DATE)) <= INTERVAL '0' DAY) and "tipo_id" = 15 and "pertenencias"."deleted_at" is null order by "tipo_id" asc, CASE WHEN fecha_termino is null THEN 0 ELSE 1 END ASC, "fecha_termino" desc, "u"."apellidos" asc limit 50 offset 0
        Bindings
        • 0: 544
        • 1: 1
        • 2: 15
        Backtrace
        • app/Http/Controllers/CargoPasivoController.php:60
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • CargoPasivoController.php#64lobby_db719.52msselect count(*) as aggregate from "pertenencias" left join "usuarios" as "u" on "u"."id" = "pertenencias"."usuario_id" where "pertenencias"."institucion_id" = 544 and "pertenencias"."institucion_id" is not null and "cargo_pasivo" = 1 and ((NOW() - fecha_inicio) >= INTERVAL '0' DAY and (NOW() - COALESCE(fecha_termino, '9999-12-31'::DATE)) <= INTERVAL '0' DAY) and "tipo_id" <> 15 and "pertenencias"."deleted_at" is null
        Bindings
        • 0: 544
        • 1: 1
        • 2: 15
        Backtrace
        • app/Http/Controllers/CargoPasivoController.php:64
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • CargoPasivoController.php#64lobby_db722.96msselect "pertenencias".* from "pertenencias" left join "usuarios" as "u" on "u"."id" = "pertenencias"."usuario_id" where "pertenencias"."institucion_id" = 544 and "pertenencias"."institucion_id" is not null and "cargo_pasivo" = 1 and ((NOW() - fecha_inicio) >= INTERVAL '0' DAY and (NOW() - COALESCE(fecha_termino, '9999-12-31'::DATE)) <= INTERVAL '0' DAY) and "tipo_id" <> 15 and "pertenencias"."deleted_at" is null order by "tipo_id" asc, CASE WHEN fecha_termino is null THEN 0 ELSE 1 END ASC, "fecha_termino" desc, "u"."apellidos" asc limit 50 offset 0
        Bindings
        • 0: 544
        • 1: 1
        • 2: 15
        Backtrace
        • app/Http/Controllers/CargoPasivoController.php:64
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • index.blade.php#36lobby_db7800μsselect * from "usuarios" where "usuarios"."id" = 30235 and "usuarios"."deleted_at" is null limit 1
        Bindings
        • 0: 30235
        Backtrace
        • view::cargos-pasivos.index:36
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • index.blade.php#51lobby_db7520μsselect * from "usuarios" where "usuarios"."id" = 184307 and "usuarios"."deleted_at" is null limit 1
        Bindings
        • 0: 184307
        Backtrace
        • view::cargos-pasivos.index:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • index.blade.php#51lobby_db7470μsselect * from "usuarios" where "usuarios"."id" = 515719 and "usuarios"."deleted_at" is null limit 1
        Bindings
        • 0: 515719
        Backtrace
        • view::cargos-pasivos.index:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • index.blade.php#51lobby_db71.85msselect * from "usuarios" where "usuarios"."id" = 208783 and "usuarios"."deleted_at" is null limit 1
        Bindings
        • 0: 208783
        Backtrace
        • view::cargos-pasivos.index:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • index.blade.php#51lobby_db7450μsselect * from "usuarios" where "usuarios"."id" = 770067 and "usuarios"."deleted_at" is null limit 1
        Bindings
        • 0: 770067
        Backtrace
        • view::cargos-pasivos.index:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • index.blade.php#51lobby_db72.33msselect * from "usuarios" where "usuarios"."id" = 515716 and "usuarios"."deleted_at" is null limit 1
        Bindings
        • 0: 515716
        Backtrace
        • view::cargos-pasivos.index:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • index.blade.php#51lobby_db7440μsselect * from "usuarios" where "usuarios"."id" = 770061 and "usuarios"."deleted_at" is null limit 1
        Bindings
        • 0: 770061
        Backtrace
        • view::cargos-pasivos.index:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • index.blade.php#51lobby_db7450μsselect * from "usuarios" where "usuarios"."id" = 172418 and "usuarios"."deleted_at" is null limit 1
        Bindings
        • 0: 172418
        Backtrace
        • view::cargos-pasivos.index:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • index.blade.php#51lobby_db74.79msselect * from "usuarios" where "usuarios"."id" = 30229 and "usuarios"."deleted_at" is null limit 1
        Bindings
        • 0: 30229
        Backtrace
        • view::cargos-pasivos.index:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • index.blade.php#51lobby_db7450μsselect * from "usuarios" where "usuarios"."id" = 277879 and "usuarios"."deleted_at" is null limit 1
        Bindings
        • 0: 277879
        Backtrace
        • view::cargos-pasivos.index:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      App\Models\Pertenencia
      10Pertenencia.php#?
      App\Models\Usuario
      10Usuario.php#?
      App\Models\Institucion
      1Institucion.php#?
          ClearShow all
          Date ↕MethodURLData
          #12025-08-13 14:40:44GET/instituciones/MU136/cargos-pasivos31521