`ferc1_balance_sheet`

Pack: ferc-form1 · Connect: https://pipeworx.io/mcp (see Connect below for a single-pack URL)

No MCP client? Call it directly: GET https://gateway.pipeworx.io/v1/tools/ferc1_balance_sheet for the schema, then POST the same URL with its arguments for the data.

FERC Form 1 comparative balance sheet (Schedule 110) for one utility and report year: assets and liabilities/equity line items with starting and ending balances in US dollars. Source: FERC Form 1 as processed by Catalyst Cooperative PUDL.

Example call

Arguments

{
  "utility": "PacifiCorp",
  "year": 2023
}

curl

curl -X POST https://gateway.pipeworx.io/ferc-form1/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"ferc1_balance_sheet","arguments":{"utility":"PacifiCorp","year":2023}}}'

TypeScript (@pipeworx/sdk)

import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();

const result = await pipeworx.call('ferc1_balance_sheet', {
  "utility": "PacifiCorp",
  "year": 2023
});

Response shape

Field	Type	Description
`found`	boolean
`utility`	object
`report_year`	number
`years_available`	array
`currency`	string
`headline`	object
`assets_count`	number
`assets`	array
`liabilities_count`	number
`liabilities`	array
`source`	string
`data_as_of`	string
`attribution`	string

Full JSON Schema

{
  "type": "object",
  "properties": {
    "found": {
      "type": "boolean"
    },
    "utility": {
      "type": "object",
      "properties": {
        "utility_id_ferc1": {
          "type": "number"
        },
        "name": {
          "type": "string"
        },
        "utility_id_pudl": {
          "type": "number"
        }
      },
      "additionalProperties": true
    },
    "report_year": {
      "type": "number"
    },
    "years_available": {
      "type": "array",
      "items": {
        "type": "number"
      }
    },
    "currency": {
      "type": "string"
    },
    "headline": {
      "type": "object",
      "properties": {
        "total_assets_and_other_debits": {
          "type": "null"
        },
        "total_liabilities_and_other_credits": {
          "type": "null"
        }
      },
      "additionalProperties": true
    },
    "assets_count": {
      "type": "number"
    },
    "assets": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "utility_type": {
            "type": "string"
          },
          "line_item": {
            "type": "string"
          },
          "ending_balance": {
            "type": [
              "number",
              "null"
            ]
          },
          "starting_balance": {
            "type": [
              "number",
              "null"
            ]
          },
          "ferc_account": {
            "type": [
              "string",
              "null"
            ]
          },
          "row_type": {
            "type": "string"
          },
          "is_correction": {
            "type": "boolean"
          }
        },
        "additionalProperties": true
      }
    },
    "liabilities_count": {
      "type": "number"
    },
    "liabilities": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "utility_type": {
            "type": "string"
          },
          "line_item": {
            "type": "string"
          },
          "ending_balance": {
            "type": "number"
          },
          "starting_balance": {
            "type": "number"
          },
          "ferc_account": {
            "type": "string"
          },
          "row_type": {
            "type": "string"
          },
          "is_correction": {
            "type": "boolean"
          }
        },
        "additionalProperties": true
      }
    },
    "source": {
      "type": "string"
    },
    "data_as_of": {
      "type": "string"
    },
    "attribution": {
      "type": "string"
    }
  },
  "additionalProperties": true
}

Connect

Add this to your MCP client config — every tool in the catalog, including this one — or use one-click install buttons:

{
  "mcpServers": {
    "pipeworx": {
      "url": "https://pipeworx.io/mcp"
    }
  }
}

Connect to just the ferc-form1 pack

{
  "mcpServers": {
    "ferc-form1": {
      "url": "https://gateway.pipeworx.io/ferc-form1/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

ferc1_balance_sheet