# Service orchestrators

Solstice ServiceOrchestrators.

- Table: `service_orchestrators`
- Parquet: https://data.filecoindataportal.xyz/service_orchestrators.parquet
- Source SQL: https://github.com/davidgasquez/filecoin-data-portal/blob/main/assets/main/service_orchestrators.sql
- Page: https://filecoindataportal.xyz/datasets/service_orchestrators
- Catalog: https://filecoindataportal.xyz/datasets.md
- Rows: ≈ 1 (snapshot estimate) · 17 columns
- Coverage: not date-indexed
- Raw sources: `raw.riba_eth_logs_decoded`, `raw.solstice_deployments`

## Query

```sql
select *
from 'https://data.filecoindataportal.xyz/service_orchestrators.parquet'
limit 10;
```

## Columns

| Name | Type | Description |
| --- | --- | --- |
| `orchestrator` | `VARCHAR` | ServiceOrchestrator identity address (not the payout wallet). |
| `wallet` | `VARCHAR` | Current payout wallet. |
| `is_admitted` | `BOOLEAN` | Whether the latest admission has no later removal. |
| `admissions` | `BIGINT` | Number of admission events. |
| `first_admitted_block` | `BIGINT` | First admission block. |
| `first_admitted_at` | `TIMESTAMP WITH TIME ZONE` | UTC first admission timestamp. |
| `admitted_block` | `BIGINT` | Latest admission block. |
| `admitted_log_index` | `BIGINT` | Latest admission log index. |
| `admitted_transaction_hash` | `VARCHAR` | Latest admission transaction hash. |
| `admitted_at` | `TIMESTAMP WITH TIME ZONE` | UTC latest admission timestamp. |
| `removed_block` | `BIGINT` | Removal block after the latest admission, if any. |
| `removed_log_index` | `BIGINT` | Removal log index, if any. |
| `removed_transaction_hash` | `VARCHAR` | Removal transaction hash, if any. |
| `removed_at` | `TIMESTAMP WITH TIME ZONE` | UTC removal timestamp, if any. |
| `wallet_replaced_block` | `BIGINT` | Latest payout wallet replacement block since admission, if any. |
| `wallet_replaced_transaction_hash` | `VARCHAR` | Latest payout wallet replacement transaction hash, if any. |
| `bound_pairs` | `BIGINT` | Open (payer, operator) binding spans. |

## Sample

1 rows exactly as stored. Values are code spans; strings with whitespace or backslashes use JSON literals. A bare null is missing, not zero.

| `orchestrator` | `wallet` | `is_admitted` | `admissions` | `first_admitted_block` | `first_admitted_at` | `admitted_block` | `admitted_log_index` | `admitted_transaction_hash` | `admitted_at` | `removed_block` | `removed_log_index` | `removed_transaction_hash` | `removed_at` | `wallet_replaced_block` | `wallet_replaced_transaction_hash` | `bound_pairs` |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| `0x97a90f5696be5e3c8d3752c92adac287c2b4484e` | `0x97a90f5696be5e3c8d3752c92adac287c2b4484e` | `true` | `1` | `6393228` | `2026-09-22 18:54:00+00` | `6393228` | `25` | `0x0f9621c112e5790b659eee5551b5380bdbb5624ba1a98491b66d20c797b75a46` | `2026-09-22 18:54:00+00` | null | null | null | null | null | null | `1` |