Flipside Data ScienceNear On-chain Labels
    Updated 2023-10-27
    SELECT
    BLOCK_TIMESTAMP as timestamp,
    TX_HASH as hash,
    SIGNER_ID as actor ,
    TRY_PARSE_JSON(NODE_DATA):value:blockchain :: string as blockchain,
    TRY_PARSE_JSON(NODE_DATA):value:contract_address :: string as contract_address,
    TRY_PARSE_JSON(NODE_DATA):value:contract_name :: string as contract_name,
    TRY_PARSE_JSON(NODE_DATA):value:protocol :: string as protocol ,
    TRY_PARSE_JSON(NODE_DATA):value:label_type :: string as label_type,
    TRY_PARSE_JSON(NODE_DATA):value:label_subtype :: string as label_subtype,
    TRY_PARSE_JSON(NODE_DATA):value:discord_handle :: string as discord_handle
    from near.social.fact_decoded_actions
    where TRY_PARSE_JSON(NODE_DATA):value:gateway ='flipside_gateway'
    and TRY_PARSE_JSON(NODE_DATA):value:method ='register_label'
    and NODE ='index'
    Run a query to Download Data