Unified Projects - Cleanview API Documentation

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,
      "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,
      "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

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

summary.limit

integer

Number of records per page

summary.offset

integer

Number of records to skip

summary.total_results

integer

Total number of records matching the query

summary.has_more

boolean

Whether additional records exist beyond this page

summary.current_page

integer

Current page number (1-indexed)

summary.total_pages

integer

Total number of pages available

filters

object

required

Applied filters for the request

customer

object

required

Customer information for the API key

Show child attributes

customer.id

string

customer.name

string

data

object[]

required

Array of merged project records

Show child attributes

data.source_table

string

Source data table (eia_860m, caiso_queue, ercot_queue, etc.)

data.source_id

string

Unique identifier within source table

data.project_name

string

Project or facility name

data.capacity_mw

number | null

Capacity in megawatts

data.operating_date

string<date> | null

Operating or proposed online date

data.technology

string | null

Technology type (Solar, Wind, Battery, Natural Gas, etc.)

data.county

string | null

County name

data.state

string | null

State code (CA, TX, NY, etc.)

data.balancing_authority

string | null

Balancing authority code (CISO, ERCO, PJM, etc.)

data.status

string | null

Project status (Operating, Planned, Cancelled, Retired)

data.latitude

number | null

Project latitude coordinate in decimal degrees

data.longitude

number | null

Project longitude coordinate in decimal degrees

Overview

EIA Data

Interconnection Queues

Projects

​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)

​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)

ISO-Specific Raw Fields