`ferc1_sales_for_resale`

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

FERC Form 1 sales for resale (Schedule 310) for one utility and report year, 1994 to date: each purchaser (buyer), statistical classification (RQ, LF, IF, SF, LU, OS, AD), MWh sold and revenue dollars. Rows sorted by MWh, subtotal and total rows excluded and reported separately. Answers “who bought the most power for resale from LG&E in 1994”. Source: FERC Form 1 as processed by Catalyst Cooperative PUDL.

Parameters

Name	Type	Required	Description
`classification`	string	no	Optional statistical classification code filter, e.g. SF, LF, OS, RQ.
`limit`	integer	no	Max rows to return (default 25, max 200).

Example call

Arguments

{
  "utility": "LG&E",
  "year": 1994
}

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_sales_for_resale","arguments":{"utility":"LG&E","year":1994}}}'

TypeScript (@pipeworx/sdk)

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

const result = await pipeworx.call('ferc1_sales_for_resale', {
  "utility": "LG&E",
  "year": 1994
});

Response shape

Field	Type	Description
`found`	boolean
`utility`	object \| null
`report_year`	number \| null
`years_available`	array
`currency`	string
`row_count`	number
`detail_mwh_sum`	number
`subtotals_excluded`	array
`rows`	array
`top_counterparties_aggregated`	array
`message`	string \| null
`note`	string
`source`	string
`data_as_of`	string
`copy_refreshed_at`	string
`attribution`	string
`ambiguous`	boolean
`candidates`	array

Full JSON Schema

{
  "type": "object",
  "properties": {
    "found": {
      "type": "boolean"
    },
    "utility": {
      "type": [
        "object",
        "null"
      ]
    },
    "report_year": {
      "type": [
        "number",
        "null"
      ]
    },
    "years_available": {
      "type": "array",
      "items": {
        "type": "number"
      }
    },
    "currency": {
      "type": "string"
    },
    "row_count": {
      "type": "number"
    },
    "detail_mwh_sum": {
      "type": "number"
    },
    "subtotals_excluded": {
      "type": "array",
      "items": {
        "type": "object"
      }
    },
    "rows": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "purchaser": {
            "type": [
              "string",
              "null"
            ]
          },
          "classification": {
            "type": [
              "string",
              "null"
            ]
          },
          "rate_schedule": {
            "type": [
              "string",
              "null"
            ]
          },
          "mwh_sold": {
            "type": [
              "number",
              "null"
            ]
          },
          "demand_charges": {
            "type": [
              "number",
              "null"
            ]
          },
          "energy_charges": {
            "type": [
              "number",
              "null"
            ]
          },
          "other_charges": {
            "type": [
              "number",
              "null"
            ]
          },
          "total_revenue": {
            "type": [
              "number",
              "null"
            ]
          }
        },
        "additionalProperties": true
      }
    },
    "top_counterparties_aggregated": {
      "type": "array",
      "items": {
        "type": "object"
      }
    },
    "message": {
      "type": [
        "string",
        "null"
      ]
    },
    "note": {
      "type": "string"
    },
    "source": {
      "type": "string"
    },
    "data_as_of": {
      "type": "string"
    },
    "copy_refreshed_at": {
      "type": "string"
    },
    "attribution": {
      "type": "string"
    },
    "ambiguous": {
      "type": "boolean"
    },
    "candidates": {
      "type": "array",
      "items": {
        "type": "object"
      }
    }
  },
  "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_sales_for_resale