ClimateOrders
Represents Climate orders for carbon removal, including order amounts, delivery details, and beneficiary information.
Table-Specific Information
SELECT
The provider uses the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| Id | = |
You can select a ClimateOrder by specifying its Id:
SELECT * FROM ClimateOrders WHERE Id = 'climorder_1Tdswsw345454'
INSERT
To create a new ClimateOrder:
INSERT INTO ClimateOrders (Product, MetricTons) VALUES ('climsku_carbon_run_2026', '0.01')
UPDATE
To modify a ClimateOrder, specify the climate order's Id:
Update ClimateOrders SET BeneficiaryName = 'beneficiary2' WHERE Id = 'climorder_1Tdswsw345454'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The unique identifier for the Climate Order object. | |
| Object | String | True |
The string representing the object's type. Objects of the same type share the same value. | |
| AmountFees | Integer | True |
Total amount of Frontier's service fees in the currency's smallest unit. | |
| AmountSubtotal | Integer | True |
Total amount of the carbon removal in the currency's smallest unit. | |
| AmountTotal | Integer | True |
Total amount of the order including fees in the currency's smallest unit. | |
| BeneficiaryName | String | False |
Publicly displayable name for the end beneficiary of carbon removal. | |
| CanceledAt | Datetime | True |
Time at which the order was canceled. Measured in seconds since the Unix epoch. | |
| CancellationReason | String | True |
Reason for the cancellation of this order. The allowed values are expired, product_unavailable, requested. | |
| Certificate | String | True |
For delivered orders, a URL to a delivery certificate for the order. | |
| ConfirmImmediately | Boolean | True |
DEPRECATED. Indicates whether to immediately confirm the order. | |
| ConfirmedAt | Datetime | True |
Time at which the order was confirmed. Measured in seconds since the Unix epoch. | |
| Created | Datetime | True |
Time at which the object was created. Measured in seconds since the Unix epoch. | |
| Currency | String | False |
Three-letter ISO currency code, in lowercase. | |
| DelayedAt | Datetime | True |
Time at which the order's expected delivery date was delayed. Measured in seconds since the Unix epoch. | |
| DeliveredAt | Datetime | True |
Time at which the order was delivered. Measured in seconds since the Unix epoch. | |
| DeliveryDetails | String | True |
Details about the delivery of carbon removal for this order. | |
| ExpectedDeliveryYear | Integer | True |
The year this order is expected to be delivered. | |
| Livemode | Boolean | True |
Indicates whether the object exists in live mode. Returns true if the object exists in live mode and false if the object exists in test mode. | |
| MetricTons | String | False |
Quantity of carbon removal that is included in this order. | |
| Product | String | False |
Products.Id |
The unique Id of the Climate product. |
| ProductSubstitutedAt | Datetime | True |
Time at which the order's product was substituted for a different product. Measured in seconds since the Unix epoch. | |
| Status | String | True |
The current status of this order. The allowed values are awaiting_funds, canceled, confirmed, delivered, open. | |
| Amount | Integer | False |
The requested amount of carbon removal units. Either this value or metric_tons must be specified. |