Skip to content


The basegoerli.logs table provides indexed views of all emitted logs.


Name Type Description
address text The address of the smart contract that emitted the log.
block_number integer The block number the parent transaction was included in.
data text The data of the log (bytes data as a hex string).
log_index integer The index of the log in the block.
timestamp timestamp The log's timestamp (in ISO-8601 format).
topic_0 text The first log topic.
topic_1 text The second log topic.
topic_2 text The third log topic.
topic_3 text The fourth log topic.
transaction_hash text The parent transaction's hash.
transaction_position integer The position of the parent transaction in the block.
__confirmed boolean Flag indicating whether the log has been confirmed.


transaction_hash, log_index
__confirmed WHERE __confirmed = false
address, topic_0, block_number, log_index
address, block_number, log_index
block_number, log_index
topic_0, block_number, log_index

Got questions? Join our Discord

Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.