> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# kleros_v1_ethereum

> Tables in tt-contracts.kleros_v1_ethereum

## Tables

### KlerosLiquid\_TokenAndETHShift\_event

Token and ETH transfer events from Kleros Liquid decentralized arbitration court on Ethereum, tracking dispute-related payments and redistributions to juror addresses. Contains native ETH amounts in wei and token amounts (likely PNK governance token) with positive values for receipts and negative for withdrawals.

<Accordion title="Columns">
  | Column             | Type        | Description                                                                                                                                                                                                                                                                              |
  | ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`  | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                                                                                                                                                              |
  | `block_number`     | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain.                                                                                                                                     |
  | `transaction_hash` | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                                                                                                                                                      |
  | `log_index`        | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                                                                                                                                                       |
  | `address`          | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                                                                                                  |
  | `removed`          | `BOOL`      | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.                                                                                                                                                                             |
  | `in__address`      | `STRING`    | Address of the account or contract involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                                                                             |
  | `in__disputeID`    | `STRING`    | Identifier of the Kleros dispute for which ETH and token amounts are being shifted. Numeric string representing the unique dispute case within the arbitration system.                                                                                                                   |
  | `in__tokenAmount`  | `STRING`    | Amount of tokens being shifted in the Kleros dispute resolution process, denominated in the smallest unit of the token (wei-equivalent). Can be positive (incoming), negative (outgoing), or zero, representing token balance adjustments for jurors or parties involved in the dispute. |
  | `in__ETHAmount`    | `STRING`    | ETH transfer amount associated with this dispute resolution event, denominated in wei (1 ETH = 10^18 wei). Values can be negative to indicate outflows or positive for inflows, with most transfers ranging from 0.011 to 0.0975 ETH.                                                    |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | in\_\_address                              | block\_number | in\_\_ETHAmount   | in\_\_disputeID | block\_timestamp         | in\_\_tokenAmount | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ----------------- | --------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ |
  | 0x988b3a538b618c7a603e1c11ab82cd16dbe28069 | false   | 297        | 0x55122fdca4ba43294677d96c12ce76dabc459a2b | 16726082      | 11000000000000000 | 1528            | 2023-02-28T10:31:47.000Z | 0                 | 0x55dddd19aae0f6d8f18ff666a2b6bcd7b5ee37784094dc6e4ff2e2b5630f50cb |
  | 0x988b3a538b618c7a603e1c11ab82cd16dbe28069 | false   | 621        | 0x379e9883833baf8402414bef58858cc8c84624d9 | 16351213      | 25000000000000000 | 1440            | 2023-01-07T00:05:59.000Z | 0                 | 0xcf7493ea32bc31f862bda13a993e4fd4d20fdd769fa6624090a7e3b0c6ca7d1d |
  | 0x988b3a538b618c7a603e1c11ab82cd16dbe28069 | false   | 206        | 0x1fcb32c860b9f4c0df99d1fd54e7ce958e9e93cc | 16354350      | 25000000000000000 | 1442            | 2023-01-07T10:36:59.000Z | 0                 | 0xd156ac20dfe4b774d227a694b987c398a733e345549a24bde6a2dc0f89290736 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.kleros_v1_ethereum.KlerosLiquid_TokenAndETHShift_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### MerkleRedeem\_Claimed\_event

Token claim events from Merkle tree-based distribution contracts recording successful redemptions. Contains claimant address and claimed token balance for tracking airdrop and reward distribution execution.

<Accordion title="Columns">
  | Column             | Type        | Description                                                                                                                                          |
  | ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`  | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                          |
  | `block_number`     | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
  | `transaction_hash` | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                  |
  | `log_index`        | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                   |
  | `address`          | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.                                                              |
  | `removed`          | `BOOL`      | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.                                         |
  | `in__claimant`     | `STRING`    | Address of the account claiming the tokens or rewards. Hex-encoded, 0x-prefixed, 42-character string.                                                |
  | `in__balance`      | `STRING`    | Token amount represented in smallest denomination. String-encoded integer value without decimal places.                                              |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | in\_\_balance           | block\_number | in\_\_claimant                             | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ----------------------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 0xdbc3088dfebc3cc6a84b0271dade2696db00af38 | false   | 207        | 113518420431173529432   | 15889607      | 0xae30f8bcdfa81f37b38d6e221a2775c7d03aa779 | 2022-11-03T12:50:47.000Z | 0x464b835b4169853c108805034b413f7dece6aa96f6560eeb46c99b169e92433b |
  | 0xdbc3088dfebc3cc6a84b0271dade2696db00af38 | false   | 116        | 19658841716079000149636 | 14042324      | 0x6f5f5d2a7d9b6ea028b8efceab2ff221a27ab6e3 | 2022-01-20T12:08:08.000Z | 0x9bf0f961305e3b4bd416ca4af7b3950ff103f2ff57585de64131e179102c1969 |
  | 0xdbc3088dfebc3cc6a84b0271dade2696db00af38 | false   | 121        | 7121814179694304134144  | 15309664      | 0xfd4ba0a1c08e0af938a2b1ac06e8937c8535ec93 | 2022-08-09T18:55:27.000Z | 0xbdc88e7cb69e76a2a1e4a43f6c4193a7cda7e44b54bcfc5ff7ce3fef2928eb11 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.kleros_v1_ethereum.MerkleRedeem_Claimed_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***