`ferc1_income_statement`

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_income_statement for the schema, then POST the same URL with its arguments for the data.

FERC Form 1 income statement (Schedule 114) for one utility and report year: operating revenues, operating expenses, taxes, net utility operating income, net income, in US dollars as filed, by line item and segment. The headline block gives total operating revenues and net income. 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_income_statement","arguments":{"utility":"PacifiCorp","year":2023}}}'

TypeScript (@pipeworx/sdk)

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

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

Response shape

Field	Type	Description
`found`	boolean
`utility`	object
`report_year`	number
`years_available`	array
`currency`	string
`headline`	object
`line_item_count`	number
`line_items`	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_operating_revenues": {
          "type": "number"
        },
        "total_utility_operating_expenses": {
          "type": "number"
        },
        "net_utility_operating_income": {
          "type": "number"
        },
        "net_income": {
          "type": "number"
        }
      },
      "additionalProperties": true
    },
    "line_item_count": {
      "type": "number"
    },
    "line_items": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "utility_type": {
            "type": "string"
          },
          "income_type": {
            "type": "string"
          },
          "dollar_value": {
            "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_income_statement