SQL Console

Query XahauTestnet data indexed by WinDB, read-only, right in the browser.

Query

Ctrl+Enter Read-only · at most 1,000 rows · 30 s a query · 12 queries a minute

Tables (33)

600

Date

String

UInt64

UInt32

551

String

UInt64

UInt32

Nullable(String)

UInt64

UInt32

Nullable(FixedString(64))

UInt16

DateTime('UTC')

UInt8

UInt32

499

String

DateTime('UTC')

UInt64

String

UInt64

String

Nullable(FixedString(48))

String

Nullable(FixedString(48))

DateTime('UTC')

Nullable(DateTime('UTC'))

String

Nullable(String)

Nullable(DateTime)

Nullable(DateTime('UTC'))

592

Date

String

SimpleAggregateFunction(sum, UInt64)

Date

Decimal(18, 6)

UInt16

UInt32

LowCardinality(String)

Date

UInt32

211

LowCardinality(FixedString(64))

DateTime('UTC')

UInt64

String

Enum8('Created' = 1, 'Destroyed' = 2, 'Installed' = 3, 'InstalledThenUninstalled' = 4, 'Uninstalled' = 5, 'Modified' = 6)

LowCardinality(FixedString(64))

UInt64

String

Date

UInt32

4.9k

LowCardinality(FixedString(64))

DateTime('UTC')

UInt64

String

LowCardinality(String)

UInt8

String

100

LowCardinality(FixedString(64))

UInt64

String

Nullable(String)

Array(Tuple(HookParameterName String, HookParameterValue String))

FixedString(64)

String

DateTime('UTC')

UInt32

Float64

FixedString(48)

DateTime('UTC')

UInt64

UInt32

String

DateTime('UTC')

Float64

UInt32

64.6k

UInt32

DateTime('UTC')

UInt16

UInt64

UInt16

Date

FixedString(48)

String

UInt64

UInt32

FixedString(48)

String

UInt64

UInt32

String

FixedString(48)

UInt8

UInt16

String

DateTime('UTC')

Nullable(DateTime('UTC'))

Date

String

UInt32

Date

String

Nullable(UInt32)

LowCardinality(String)

Decimal(18, 6)

Float64

Nullable(String)

Nullable(FixedString(48))

String

UInt32

Nullable(String)

Nullable(DateTime('UTC'))

FixedString(64)

String

UInt32

LowCardinality(String)

UInt64

String

Nullable(String)

LowCardinality(String)

Nullable(Decimal(18, 6))

Nullable(Float64)

Nullable(String)

Nullable(FixedString(48))

LowCardinality(String)

Nullable(Decimal(18, 6))

Nullable(Float64)

Nullable(String)

Nullable(FixedString(48))

Nullable(String)

DateTime('UTC')

Date

String

UInt32

Date

String

LowCardinality(String)

Decimal(18, 6)

Float64

Nullable(String)

Nullable(FixedString(48))

FixedString(64)

UInt32

UInt8

String

Nullable(String)

LowCardinality(String)

Nullable(Decimal(18, 6))

Nullable(Float64)

Nullable(String)

Nullable(FixedString(48))

DateTime('UTC')

Nullable(DateTime('UTC'))

FixedString(64)

String

UInt32

LowCardinality(String)

String

FixedString(64)

Nullable(String)

Nullable(UInt16)

Nullable(Float64)

Nullable(UInt32)

Nullable(UInt8)

Nullable(String)

Nullable(UInt8)

Nullable(DateTime('UTC'))

DateTime('UTC')

String

UInt32

Float64

DateTime('UTC')

UInt32

String

FixedString(64)

Array(Tuple(Issuer String, CredentialTypeHEX String, CredentialType String))

Nullable(DateTime('UTC'))

UInt32

Date

String

Float64

UInt32

String

Float64

UInt32

266.1k

UInt64

String

DateTime64(9, 'UTC')

UInt32

Array(Tuple(Issuer String, CredentialType String))

UInt8

String

FixedString(64)

String

LowCardinality(Nullable(FixedString(64)))

Decimal(18, 6)

Float64

String

Nullable(FixedString(48))

Decimal(18, 6)

Float64

String

Nullable(FixedString(48))

String

Array(Tuple(XRP Decimal(18, 6), token_value Float64, token_issuer String, token_currency String))

UInt8

String

UInt32

String

Nullable(FixedString(48))

String

Nullable(FixedString(48))

String

UInt8

String

Array(String)

UInt8

String

Array(Tuple(Issuer String, CredentialType String))

UInt8

Decimal(18, 6)

Float64

String

Nullable(FixedString(48))

UInt64

Int64

Decimal(18, 6)

Float64

String

Nullable(FixedString(48))

Decimal(18, 6)

Float64

String

Nullable(FixedString(48))

FixedString(64)

UInt32

FixedString(64)

String

Nullable(FixedString(48))

UInt32

String

Array(FixedString(64))

String

FixedString(64)

String

UInt32

Decimal(18, 6)

Float64

String

Nullable(FixedString(48))

String

Nullable(UInt32)

FixedString(64)

String

FixedString(64)

Decimal(18, 6)

Float64

String

Nullable(FixedString(48))

FixedString(32)

UInt64

UInt32

FixedString(64)

String

FixedString(64)

UInt16

FixedString(64)

UInt32

Int64

UInt32

String

Array(Tuple(Amount_XRP Decimal(18, 6), Destination String, GovernanceFlags String, GovernanceMarks String))

UInt16

String

UInt16

String

Array(Tuple(HookParameterName String, HookParameterValue String))

UInt8

UInt16

Array(Tuple(position UInt8, HookHash Nullable(String), CreateCode Nullable(String), Flags UInt32, HookApiVersion Nullable(Int8), HookName Nullable(String), HookNamespace Nullable(FixedString(64)), HookOn Nullable(FixedString(64)), HookOnIncoming Nullable(FixedString(64)), HookOnOutgoing Nullable(FixedString(64)), HookCanEmit Nullable(FixedString(64)), Fee Nullable(Int64)))

UInt8

String

FixedString(64)

String

Nullable(FixedString(48))

Decimal(18, 6)

Float64

String

Nullable(FixedString(48))

Decimal(18, 6)

Float64

String

Nullable(FixedString(48))

UInt32

UInt16

Nullable(UInt32)

Decimal(18, 6)

Float64

String

Nullable(FixedString(48))

String

FixedString(48)

String

FixedString(64)

UInt64

Array(Tuple(MemoData String, MemoFormat Nullable(String), MemoType Nullable(String)))

UInt8

UInt32

String

Decimal(18, 6)

Float64

String

Nullable(FixedString(48))

String

UInt32

Decimal(18, 6)

Float64

String

Nullable(FixedString(48))

FixedString(64)

String

Array(FixedString(64))

FixedString(64)

UInt32

FixedString(64)

UInt32

String

Array(Tuple(account Nullable(String), currency Nullable(String), issuer Nullable(String), type Nullable(UInt8)))

FixedString(64)

String

UInt32

FixedString(64)

String

UInt32

String

Array(Tuple(RemarkName String, RemarkValue Nullable(String), Flags Nullable(UInt32)))

UInt8

Nullable(UInt32)

UInt32

Int64

UInt32

Int64

Decimal(18, 6)

Float64

String

Nullable(FixedString(48))

UInt32

String

Decimal(18, 6)

Float64

String

Nullable(FixedString(48))

Array(Tuple(Account String, SignerWeight UInt16, WalletLocator Nullable(FixedString(64))))

UInt8

UInt32

Array(String)

UInt8

Nullable(UInt32)

String

Decimal(21, 6)

Float64

String

Nullable(FixedString(48))

FixedString(40)

Decimal(21, 6)

Float64

String

Nullable(FixedString(48))

UInt8

UInt32

UInt16

FixedString(64)

UInt32

LowCardinality(String)

UInt16

UInt32

Decimal(18, 6)

Float64

String

Nullable(FixedString(48))

UInt8

String

FixedString(64)

Array(FixedString(64))

String

Array(Tuple(Issuer String, CredentialType String))

UInt8

String

FixedString(64)

UInt32

String

UInt64

Decimal(18, 6)

Float64

String

Nullable(FixedString(48))

UInt16

UInt8

String

Array(String)

String

Decimal(18, 6)

Switch network

Tools & Services

SQL Console

Tables (33)