The bitcoin.nfts.ordinals_collections table contains ordinals collection data aggregated from various ordinals explorer/data sources.

Table Columns

Column NameDescriptionExample
nameCollection name of the inscription, if applicable.ordfish
slugCollection slug of the inscription, if applicable. The collection slug is a human-readable, unique identifier.ordfish
supplyTotal supply of the collection.100
iconCollection icon, if applicable.5b182278c42d5a74ab4dd9f43826a0a2fce0158000001ed3bdf44873f1378d93i0
genesis_heightBlock height at the genesis of inscription.788301
genesis_timestampTimestamp of the inscription2023-05-04 23:48:48
descriptionDescription of the collection, if applicable.Ordinary literary fish. Look up an ordfish by entering its satoshi code into ordinals.com or aesthetic.computer
twitter_linkCollection Twitter link, if applicable.https://twitter.com/digitpain
discord_linkCollection Discord link, if applicable.https://discord.gg/aesthetic-computer
website_linkCollection Website link, if applicable.https://aesthetic.computer
unique_idUnique ID of the collection.ordfish