Unified Projects - Cleanview API Documentation

Get merged energy projects data

curl --request GET \
  --url https://api.cleanview.co/api/v1/projects \
  --header 'x-api-key: <api-key>'

{
  "summary": {
    "limit": 50,
    "offset": 0,
    "total_results": 62222,
    "has_more": true,
    "current_page": 1,
    "total_pages": 1245
  },
  "filters": {
    "state": null,
    "technology": null,
    "status": "all",
    "source_table": null,
    "min_capacity": null,
    "max_capacity": null,
    "balancing_authority": null,
    "developer": null
  },
  "customer": {
    "id": "test_user_001",
    "name": "Test Developer"
  },
  "data": [
    {
      "source_table": "eia_860m",
      "source_id": "57472_CTG",
      "project_name": "TBE-Montgomery LLC",
      "capacity_mw": 12,
      "operating_date": "2039-12-01",
      "technology": "Biomass",
      "county": "Orange",
      "state": "NY",
      "balancing_authority": "NYIS",
      "status": "Planned",
      "latitude": 41.4885,
      "longitude": -74.2262,
      "has_ia_signed": null,
      "under_construction": true,
      "ir_request_date": null,
      "developer": null
    },
    {
      "source_table": "miso_queue",
      "source_id": "J4004",
      "project_name": "Other_",
      "capacity_mw": 392,
      "operating_date": "2032-10-31",
      "technology": "Solar",
      "county": "Peoria",
      "state": "IL",
      "balancing_authority": "MISO",
      "status": "Planned",
      "latitude": null,
      "longitude": null,
      "has_ia_signed": false,
      "under_construction": false,
      "ir_request_date": "2025-05-03",
      "raw_fields": {
        "project_id": "J4004",
        "request_status": "Active",
        "queue_date": "2025-05-03T04:00:00.000Z",
        "withdrawn_date": null,
        "done_date": null,
        "in_service_date": "2032-10-31T04:00:00.000Z",
        "transmission_owner": "AMEREN TRANSMISSION COMPANY OF ILLINOIS",
        "county": "Peoria",
        "state": "IL",
        "study_cycle": "DPP Cycle Pending",
        "study_group": "Central",
        "study_phase": null,
        "service_type": null,
        "poi_name": "Other_",
        "summer_mw": 392,
        "winter_mw": 392,
        "fuel_type": "Solar",
        "facility_type": "Photovoltaic",
        "post_gia_status": null,
        "negotiated_in_service_date": null,
        "dp1_eris_mw": 0,
        "dp1_nris_mw": 0,
        "dp2_eris_mw": 0,
        "dp2_nris_mw": 0
      },
      "developer": null
    }
  ]
}

GET

projects

Get merged energy projects data

curl --request GET \
  --url https://api.cleanview.co/api/v1/projects \
  --header 'x-api-key: <api-key>'

{
  "summary": {
    "limit": 50,
    "offset": 0,
    "total_results": 62222,
    "has_more": true,
    "current_page": 1,
    "total_pages": 1245
  },
  "filters": {
    "state": null,
    "technology": null,
    "status": "all",
    "source_table": null,
    "min_capacity": null,
    "max_capacity": null,
    "balancing_authority": null,
    "developer": null
  },
  "customer": {
    "id": "test_user_001",
    "name": "Test Developer"
  },
  "data": [
    {
      "source_table": "eia_860m",
      "source_id": "57472_CTG",
      "project_name": "TBE-Montgomery LLC",
      "capacity_mw": 12,
      "operating_date": "2039-12-01",
      "technology": "Biomass",
      "county": "Orange",
      "state": "NY",
      "balancing_authority": "NYIS",
      "status": "Planned",
      "latitude": 41.4885,
      "longitude": -74.2262,
      "has_ia_signed": null,
      "under_construction": true,
      "ir_request_date": null,
      "developer": null
    },
    {
      "source_table": "miso_queue",
      "source_id": "J4004",
      "project_name": "Other_",
      "capacity_mw": 392,
      "operating_date": "2032-10-31",
      "technology": "Solar",
      "county": "Peoria",
      "state": "IL",
      "balancing_authority": "MISO",
      "status": "Planned",
      "latitude": null,
      "longitude": null,
      "has_ia_signed": false,
      "under_construction": false,
      "ir_request_date": "2025-05-03",
      "raw_fields": {
        "project_id": "J4004",
        "request_status": "Active",
        "queue_date": "2025-05-03T04:00:00.000Z",
        "withdrawn_date": null,
        "done_date": null,
        "in_service_date": "2032-10-31T04:00:00.000Z",
        "transmission_owner": "AMEREN TRANSMISSION COMPANY OF ILLINOIS",
        "county": "Peoria",
        "state": "IL",
        "study_cycle": "DPP Cycle Pending",
        "study_group": "Central",
        "study_phase": null,
        "service_type": null,
        "poi_name": "Other_",
        "summer_mw": 392,
        "winter_mw": 392,
        "fuel_type": "Solar",
        "facility_type": "Photovoltaic",
        "post_gia_status": null,
        "negotiated_in_service_date": null,
        "dp1_eris_mw": 0,
        "dp1_nris_mw": 0,
        "dp2_eris_mw": 0,
        "dp2_nris_mw": 0
      },
      "developer": null
    }
  ]
}

Overview

The unified projects endpoint provides a simplified, consolidated view of energy projects by combining data from multiple sources including EIA 860M and major grid operator interconnection queues. This endpoint standardizes project information across different data sources to provide a unified perspective on the energy project landscape.

Endpoint

curl -H "x-api-key: your_api_key_here" \
  "https://api.cleanview.co/api/v1/projects?limit=50&technology=Solar&state=CA"

Query Parameters

Parameter	Type	Default	Description
`limit`	integer	1000	Number of records to return (50-5000)
`offset`	integer	0	Number of records to skip
`state`	string	-	Filter by state code (e.g., CA, TX, NY)
`technology`	string	-	Filter by standardized technology type
`status`	string	-	Filter by project status
`source_table`	string	-	Filter by data source table
`min_capacity`	number	-	Minimum capacity (MW)
`max_capacity`	number	-	Maximum capacity (MW)
`balancing_authority`	string	-	Filter by balancing authority code
`developer`	string	-	Filter by developer name (e.g., NextEra, Tesla). Supports partial matches

Technology Types

Common standardized technology types:

Type	Description
`Solar`	Solar photovoltaic
`Wind`	Wind turbine
`Battery`	Battery energy storage
`Natural Gas`	Natural gas generation
`Biomass`	Biomass generation
`Hydroelectric`	Hydroelectric
`Geothermal`	Geothermal

Hybrid Project Availability: Hybrid technology classifications are available for interconnection queue data (PJM, MISO, SPP, NE-ISO, NYISO) but not for CAISO, ERCOT, or EIA 860M data sources.

Project Status

Status	Description
`Operating`	Currently operational
`Planned`	Planned/permitted
`Cancelled`	Cancelled/withdrawn
`Retired`	Retired from service

Data Sources

Projects are sourced from:

Source	Description
`eia_860m`	EIA 860M Monthly data
`caiso_queue`	CAISO interconnection queue
`ercot_queue`	ERCOT interconnection queue
`pjm_queue`	PJM interconnection queue
`miso_queue`	MISO interconnection queue
`nyiso_queue`	NYISO interconnection queue
`ne_iso_queue`	ISO-NE interconnection queue
`spp_queue`	SPP interconnection queue

Developer Information

Developer information is always included in the response when available. The developer parameter can be used to filter results: Filtering Options:

Single developer: developer=NextEra - Returns projects where developer name contains “NextEra”
Partial matching: developer=Solar - Returns projects where developer name contains “Solar” (e.g., “First Solar”, “Solar Power Corp”)
Case insensitive: All developer filtering is case-insensitive

Example Requests

Get Solar Projects in California

curl -H "x-api-key: your_api_key_here" \
  "https://api.cleanview.co/api/v1/projects?technology=Solar&state=CA&limit=50"

Get Operating Projects

curl -H "x-api-key: your_api_key_here" \
  "https://api.cleanview.co/api/v1/projects?status=Operating&limit=50"

Get Large Projects (>100 MW)

curl -H "x-api-key: your_api_key_here" \
  "https://api.cleanview.co/api/v1/projects?min_capacity=100&limit=50"

Get Projects from EIA Data Only

curl -H "x-api-key: your_api_key_here" \
  "https://api.cleanview.co/api/v1/projects?source_table=eia_860m&limit=50"

Get Projects by Specific Developer

curl -H "x-api-key: your_api_key_here" \
  "https://api.cleanview.co/api/v1/projects?developer=NextEra&limit=50"

Data Availability Summary

Source	Hybrid Projects	Status
PJM, MISO, SPP, NE-ISO, NYISO	1,343 total	✅ Full support
CAISO, ERCOT, EIA 860M	0	❌ No hybrid classifications

System Limitations: Our current query system is not optimized for detecting hybrid projects in CAISO, ERCOT, or EIA data sources.

Complete Documentation

For comprehensive hybrid project guidance including:

✅ All 4 query methods with code examples
✅ Detailed workarounds for sources without hybrid data
✅ Root cause analysis and technical limitations
✅ Future enhancement roadmap

👉 See our complete Hybrid Project System Limitations documentation.

Response Schema

{
  "summary": {
    "limit": 50,
    "offset": 0,
    "total_results": 62222,
    "has_more": true,
    "current_page": 1,
    "total_pages": 1245
  },
  "filters": {
    "state": null,
    "technology": null,
    "status": "all",
    "source_table": null,
    "min_capacity": null,
    "max_capacity": null,
    "balancing_authority": null,
    "developer": null
  },
  "customer": {
    "id": "test_user_001",
    "name": "Test Developer"
  },
  "data": [
    {
      "source_table": "eia_860m",
      "source_id": "57472_CTG",
      "project_name": "TBE-Montgomery LLC",
      "capacity_mw": 12,
      "operating_date": "2039-12-01",
      "technology": "Biomass",
      "county": "Orange",
      "state": "NY",
      "balancing_authority": "NYIS",
      "status": "Planned",
      "latitude": 41.4885,
      "longitude": -74.2262,
      "has_ia_signed": null,
      "under_construction": true,
      "ir_request_date": null,
      "developer": null
    },
    {
      "source_table": "miso_queue",
      "source_id": "J4004",
      "project_name": "Other_",
      "capacity_mw": 392,
      "operating_date": "2032-10-31",
      "technology": "Solar",
      "county": "Peoria",
      "state": "IL",
      "balancing_authority": "MISO",
      "status": "Planned",
      "latitude": null,
      "longitude": null,
      "has_ia_signed": false,
      "under_construction": false,
      "ir_request_date": "2025-05-03",
      "raw_fields": {
        "project_id": "J4004",
        "request_status": "Active",
        "queue_date": "2025-05-03T04:00:00.000Z",
        "withdrawn_date": null,
        "done_date": null,
        "in_service_date": "2032-10-31T04:00:00.000Z",
        "transmission_owner": "AMEREN TRANSMISSION COMPANY OF ILLINOIS",
        "county": "Peoria",
        "state": "IL",
        "study_cycle": "DPP Cycle Pending",
        "study_group": "Central",
        "study_phase": null,
        "service_type": null,
        "poi_name": "Other_",
        "summer_mw": 392,
        "winter_mw": 392,
        "fuel_type": "Solar",
        "facility_type": "Photovoltaic",
        "post_gia_status": null,
        "negotiated_in_service_date": null,
        "dp1_eris_mw": 0,
        "dp1_nris_mw": 0,
        "dp2_eris_mw": 0,
        "dp2_nris_mw": 0
      },
      "developer": null
    }
  ]
}

Raw Fields for ISO Queue Data: Projects from interconnection queue sources (CAISO, ERCOT, PJM, MISO, NYISO, ISO-NE, SPP) include a nested raw_fields object containing all ISO-specific upstream data. EIA 860M projects return only standardized fields without the raw_fields object.

Response Fields

Standardized Fields (All Sources)

Field	Type	Description
`source_table`	string	Source data table (eia_860m, caiso_queue, etc.)
`source_id`	string	Unique identifier within source table
`project_name`	string	Project or facility name
`capacity_mw`	number	Capacity in megawatts
`operating_date`	string	Operating or proposed online date (YYYY-MM-DD)
`technology`	string	Standardized technology type
`county`	string	County name
`state`	string	State code (CA, TX, NY, etc.)
`balancing_authority`	string	Balancing authority code
`status`	string	Project status (Operating, Planned, Cancelled, Retired)
`latitude`	number	Project latitude in decimal degrees (nullable)
`longitude`	number	Project longitude in decimal degrees (nullable)
`developer`	string	Developer/owner name
`has_ia_signed`	boolean	Whether an Interconnection Agreement has been executed (null for EIA data)
`under_construction`	boolean	Whether the project is or was under construction
`ir_request_date`	string	Interconnection Request date in YYYY-MM-DD format (null for EIA data)

Interconnection Milestone Fields

The fields has_ia_signed, under_construction, and ir_request_date represent milestone progression through the interconnection process, not just current operational state. This distinction is important for understanding cancelled projects.

Milestone vs. Current State: A project with status=Cancelled may still show has_ia_signed=true or under_construction=true. This indicates how far the project progressed before being cancelled—valuable for analyzing interconnection queue attrition patterns.

Data Availability by Source

Source	`has_ia_signed`	`under_construction`	`ir_request_date`
EIA 860M	`null`	Available	`null`
CAISO	Available	`null`	Available
ERCOT	Available	Available	Available
PJM	Available	Available	Available
MISO	Available	Available	Available
NYISO	Available	`null`	Available
ISO-NE	Available	Available	Available
SPP	Available	`null`	Available

Example: Cancelled Project Analysis

{
  "source_table": "miso_queue",
  "source_id": "J720",
  "project_name": "Lakefield - Raun 345 kV line",
  "status": "Cancelled",
  "has_ia_signed": true,
  "under_construction": true,
  "ir_request_date": "2018-03-12"
}

This cancelled MISO project shows:

has_ia_signed: true — The project secured an Interconnection Agreement
under_construction: true — Construction had begun before withdrawal
The status: Cancelled indicates the project is no longer active

Attrition Analysis: Query status=Cancelled with has_ia_signed=true to find projects that failed after securing an IA—these represent late-stage failures with different characteristics than early-stage withdrawals.

ISO-Specific Raw Fields

Field	Type	Description
`raw_fields`	object	Nested object containing all ISO-specific upstream data (interconnection queue sources only)

The raw_fields object structure varies by source_table:

CAISO Queue: See CAISO endpoint documentation for 47 CAISO-specific fields
ERCOT Queue: See ERCOT endpoint documentation for 45 ERCOT-specific fields
PJM Queue: See PJM endpoint documentation for 38 PJM-specific fields
MISO Queue: See MISO endpoint documentation for 41 MISO-specific fields (includes DPP process fields)
NYISO Queue: See NYISO endpoint documentation for 38 NYISO-specific fields (includes storage fields)
ISO-NE Queue: See ISO-NE endpoint documentation for 41 ISO-NE-specific fields (includes five-phase study process)
SPP Queue: See SPP endpoint documentation for 43 SPP-specific fields (includes DISIS cluster data)
EIA 860M: No raw_fields object - only standardized fields listed above

Data Consolidation: This endpoint provides a simplified view of complex energy project data. For detailed information, use the specific EIA 860M or interconnection queue endpoints.

Cross-Reference: Projects may appear in multiple sources. The source_table and source_id fields help identify the original data source for each record.

Authorizations

x-api-key

string

header

required

API key authentication using x-api-key header

Query Parameters

limit

integer

default:1000

Number of records to return

Required range: 50 <= x <= 5000

offset

integer

default:0

Number of records to skip

state

string

Filter by state code (e.g., CA, TX, NY)

technology

string

Filter by technology type (Solar, Wind, Battery, etc.)

status

string

Filter by project status (Operating, Planned, Cancelled, Retired)

source

string

Filter by data source (eia_860m, caiso_queue, ercot_queue, etc.)

min_capacity

number

Minimum capacity in MW

max_capacity

number

Maximum capacity in MW

balancing_authority

string

Filter by balancing authority

Response

Successful response

success

boolean

required

Always true for successful responses

Example:

true

summary

object

required

Summary metadata for pagination

Show child attributes

filters

object

required

Applied filters for the request

customer

object

required

Customer information for the API key

Show child attributes

data

object[]

required

Array of merged project records

Show child attributes

ISO-NE Interconnection Queue Data Centers

​Overview

​Endpoint

​Query Parameters

​Technology Types

​Project Status

​Data Sources

​Developer Information

​Example Requests

​Data Availability Summary

​Complete Documentation

​Response Schema

​Response Fields

​Standardized Fields (All Sources)

​Interconnection Milestone Fields

​Data Availability by Source

​Example: Cancelled Project Analysis

​ISO-Specific Raw Fields

Authorizations

Query Parameters

Response

Overview

Endpoint

Query Parameters

Technology Types

Project Status

Data Sources

Developer Information

Example Requests

Data Availability Summary

Complete Documentation

Response Schema

Response Fields

Standardized Fields (All Sources)

Interconnection Milestone Fields

Data Availability by Source

Example: Cancelled Project Analysis

ISO-Specific Raw Fields