cosmos_data_structure_demo.md

Cosmos tx data structure as seen from Numia data tables

WITH 
-- Retrieve the block date for the specified height
block_info AS (
  SELECT 
    block_height,
    block_date
  FROM 
    sei.cosmos_blocks
  WHERE 
    block_height = 119832245
),

-- Fetch transaction data for the block
tx_data AS (
  SELECT 
    tx_id AS tx_hash,
    block_height,
    gas_wanted,
    gas_used,
    tx_info AS raw_tx_info,
    tx_log_message AS raw_log
  FROM 
    sei.cosmos_transactions
  WHERE 
    block_height = 119832245
),

-- Extract messages from cosmos_tx_messages for transactions in the block
tx_messages AS (
  SELECT 
    tx_id AS tx_hash,
    message_index,
    message_type,
    message AS message_body
  FROM 
    sei.cosmos_tx_messages
  WHERE 
    block_height = 119832245
),

-- Extract events from cosmos_message_events for transactions in the block
tx_events AS (
  SELECT 
    tx_id AS tx_hash,
    event_type,
    CONCAT('Key: ', attribute_key, ', Value: ', attribute_value) AS event_attributes
  FROM 
    sei.cosmos_message_events
  WHERE 
    block_height = 119832245
)

-- Combine all the data into a single view
SELECT 
  b.block_date,
  tx.tx_hash AS transaction_hash,
  tx.block_height,
  tx.gas_wanted,
  tx.gas_used,
  tx.raw_tx_info,
  tx.raw_log,
  ARRAY_AGG(DISTINCT m.message_type) AS message_types,
  ARRAY_AGG(DISTINCT e.event_type) AS event_types,
  ARRAY_AGG(DISTINCT m.message_body) AS message_details,
  ARRAY_AGG(DISTINCT e.event_attributes) AS event_attributes
FROM 
  block_info b
JOIN 
  tx_data tx
ON 
  b.block_height = tx.block_height
LEFT JOIN 
  tx_messages m
ON 
  tx.tx_hash = m.tx_hash
LEFT JOIN 
  tx_events e
ON 
  tx.tx_hash = e.tx_hash
GROUP BY 
  b.block_date, tx.tx_hash, tx.block_height, tx.gas_wanted, tx.gas_used, tx.raw_tx_info, tx.raw_log;

table.md

block_date	transaction_hash	block_height	gas_wanted	gas_used	raw_tx_info	raw_log	message_types	event_types	message_details	event_attributes
2024-12-10	BD0908075B812E70CDB421D066681D1569DA02A705542AC39D4B1CEB46959CC9	119,832,245	200,000	73,056			[/cosmos.bank.v1beta1.MsgSend]	[message tx signer coin_spent transfer coin_received]	[{"@type":"/cosmos.bank.v1beta1.MsgSend","amount":[{"amount":"562561100","denom":"usei"}],"from_address":"sei1harxqujpk0hevszkwd6hfn5asn0va689a5zjky","to_address":"sei1a6d96c6dx0rwm8uqgs63regnaq772maawc0h9k"}]	[Key: module, Value: bank Key: fee_payer, Value: sei1harxqujpk0hevszkwd6hfn5asn0va689a5zjky Key: signature, Value: Eh0bazEhfdogHzJ00xKk6IbH8bVIYAe523KTTCq1iyMaCrxQCWvYTCdxyNi6e+W0enqSYOA7PQhkb7lwBDNkSA== Key: evm_addr, Value: 0x2538cEa9f5473018F4e421E190F892F16f1C265A Key: spender, Value: sei1harxqujpk0hevszkwd6hfn5asn0va689a5zjky Key: sei_addr, Value: sei1harxqujpk0hevszkwd6hfn5asn0va689a5zjky Key: sender, Value: sei1harxqujpk0hevszkwd6hfn5asn0va689a5zjky Key: recipient, Value: sei1a6d96c6dx0rwm8uqgs63regnaq772maawc0h9k Key: fee, Value: 20000usei Key: amount, Value: 562561100usei Key: amount, Value: 20000usei Key: action, Value: /cosmos.bank.v1beta1.MsgSend Key: acc_seq, Value: sei1harxqujpk0hevszkwd6hfn5asn0va689a5zjky/4080 Key: receiver, Value: sei1a6d96c6dx0rwm8uqgs63regnaq772maawc0h9k]
2024-12-10	0DDAA26DCF2F815AF630D79ACDDD9D07E6CA0B159AD853E68F9D1394DE3CA6AB	119,832,245					[/seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote]	[signer tx aggregate_vote message]	[{"@type":"/seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote","exchange_rates":"7.386891420758720368uatom,94598.794905289351785101ubtc,3538.004457970416081697ueth,0.588629126781658587uosmo,0.514932943090108687usei,0.999848126170911464uusdc,1.000240425969195699uusdt","feeder":"sei1f8ey877q8x84972dhhcd4jddrk46pxn7wua7yl","validator":"seivaloper1y82m5y3wevjneamzg0pmx87dzanyxzht0kepvn"}]	[Key: evm_addr, Value: 0x6575ecEfe7a6E1Ba355514D59aF8C48423767757 Key: acc_seq, Value: sei1f8ey877q8x84972dhhcd4jddrk46pxn7wua7yl/44577910 Key: voter, Value: seivaloper1y82m5y3wevjneamzg0pmx87dzanyxzht0kepvn Key: signature, Value: 7Y/OURycVk3d0u+inBtNFp7VI/6SouH69XLIBl8QWXJrjzMqDZVan1itYeXxabHRSgBUi2yR+0fIA61LSi+toA== Key: fee_payer, Value: sei1f8ey877q8x84972dhhcd4jddrk46pxn7wua7yl Key: module, Value: oracle Key: sender, Value: sei1f8ey877q8x84972dhhcd4jddrk46pxn7wua7yl Key: sei_addr, Value: sei1f8ey877q8x84972dhhcd4jddrk46pxn7wua7yl Key: exchange_rates, Value: 7.386891420758720368uatom,94598.794905289351785101ubtc,3538.004457970416081697ueth,0.588629126781658587uosmo,0.514932943090108687usei,0.999848126170911464uusdc,1.000240425969195699uusdt Key: action, Value: /seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote Key: fee, Value: 0usei]
2024-12-10	10A538120B21CE32E0E8ADCEED4FA22A85EB84B4ADE8399FA2C97B94D9BC3B08	119,832,245					[/seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote]	[signer aggregate_vote message tx]	[{"@type":"/seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote","exchange_rates":"7.387115308790304977uatom,94599.729756780794771042ubtc,3537.979250155760596087ueth,0.588629813202429009uosmo,0.514936407795246128usei,0.999843313704330680uusdc,1.000240425969195699uusdt","feeder":"sei1rwewv6crhfl07z3z5uxw6zt3657hhpwm0ry0rp","validator":"seivaloper1vjj609rued3hxztj6gauca3w7fzu96g4yp6y39"}]	[Key: sei_addr, Value: sei1rwewv6crhfl07z3z5uxw6zt3657hhpwm0ry0rp Key: exchange_rates, Value: 7.387115308790304977uatom,94599.729756780794771042ubtc,3537.979250155760596087ueth,0.588629813202429009uosmo,0.514936407795246128usei,0.999843313704330680uusdc,1.000240425969195699uusdt Key: action, Value: /seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote Key: evm_addr, Value: 0xdc378B767EE8989127Add05f1A18EE8Dbb30c84B Key: signature, Value: HdT37x0GYuRh7H0OQ329coCPE50ww/mlR0Ka/v5d7tsm3fS/+xLy0pQUczcetew/70YWoexpwy0hb8xxV/TwYQ== Key: fee, Value: 0usei Key: sender, Value: sei1rwewv6crhfl07z3z5uxw6zt3657hhpwm0ry0rp Key: acc_seq, Value: sei1rwewv6crhfl07z3z5uxw6zt3657hhpwm0ry0rp/26836782 Key: voter, Value: seivaloper1vjj609rued3hxztj6gauca3w7fzu96g4yp6y39 Key: fee_payer, Value: sei1rwewv6crhfl07z3z5uxw6zt3657hhpwm0ry0rp Key: module, Value: oracle]
2024-12-10	26D035889601C1B2ED0F19DDAB152E7FC899969726724C322253DB1D788DAF7B	119,832,245	150,000	120,513			[/ibc.applications.transfer.v1.MsgTransfer]	[burn signer send_packet ibc_transfer message coin_spent transfer coin_received tx]	[{"@type":"/ibc.applications.transfer.v1.MsgTransfer","memo":"","receiver":"noble1f8se40xdwnaaj66hsndt2ch8ppusah4yeprwmw","sender":"sei1f8se40xdwnaaj66hsndt2ch8ppusah4yuw8s9p","source_channel":"channel-45","source_port":"transfer","timeout_timestamp":"1733854550602939595","token":{"amount":"29926000000","denom":"ibc/CA6FBFAF399474A06263E10D0CE5AEBBE15189D6D4B2DD9ADE61007E68EB9DB0"}}]	[Key: burner, Value: sei1yl6hdjhmkf37639730gffanpzndzdpmhrn8l3z Key: sei_addr, Value: sei1f8se40xdwnaaj66hsndt2ch8ppusah4yuw8s9p Key: packet_connection, Value: connection-77 Key: packet_src_port, Value: transfer Key: packet_data, Value: {"amount":"29926000000","denom":"transfer/channel-45/uusdc","receiver":"noble1f8se40xdwnaaj66hsndt2ch8ppusah4yeprwmw","sender":"sei1f8se40xdwnaaj66hsndt2ch8ppusah4yuw8s9p"} Key: receiver, Value: noble1f8se40xdwnaaj66hsndt2ch8ppusah4yeprwmw Key: evm_addr, Value: 0xfD4de3dB3eF2959C538045BCbda87804B3278265 Key: sender, Value: sei1f8se40xdwnaaj66hsndt2ch8ppusah4yuw8s9p Key: packet_sequence, Value: 16543 Key: amount, Value: 29926000000ibc/CA6FBFAF399474A06263E10D0CE5AEBBE15189D6D4B2DD9ADE61007E68EB9DB0 Key: receiver, Value: sei1yl6hdjhmkf37639730gffanpzndzdpmhrn8l3z Key: packet_data_hex, Value: 7b22616d6f756e74223a223239393236303030303030222c2264656e6f6d223a227472616e736665722f6368616e6e656c2d34352f7575736463222c227265636569766572223a226e6f626c65316638736534307864776e61616a363668736e6474326368387070757361683479657072776d77222c2273656e646572223a22736569316638736534307864776e61616a363668736e6474326368387070757361683479757738733970227d Key: signature, Value: s/uDEbAw0zYMvC9Gsij/dNqHqEi3DSrKj5U4uFzZ5511aS80goBGhzPs8bEsaJgtg/1qamHaVPXY8mzK6yD0aA== Key: spender, Value: sei1yl6hdjhmkf37639730gffanpzndzdpmhrn8l3z Key: module, Value: ibc_channel Key: amount, Value: 150000usei Key: fee, Value: 150000usei Key: spender, Value: sei1f8se40xdwnaaj66hsndt2ch8ppusah4yuw8s9p Key: acc_seq, Value: sei1f8se40xdwnaaj66hsndt2ch8ppusah4yuw8s9p/69350 Key: packet_timeout_timestamp, Value: 1733854550602939595 Key: recipient, Value: sei1yl6hdjhmkf37639730gffanpzndzdpmhrn8l3z Key: fee_payer, Value: sei1f8se40xdwnaaj66hsndt2ch8ppusah4yuw8s9p Key: action, Value: /ibc.applications.transfer.v1.MsgTransfer Key: packet_timeout_height, Value: 0-0 Key: packet_src_channel, Value: channel-45 Key: packet_dst_channel, Value: channel-39 Key: packet_dst_port, Value: transfer Key: module, Value: transfer Key: packet_channel_ordering, Value: ORDER_UNORDERED]
2024-12-10	F8E284D9D461C6E234F6F4DD2180A8B8B5BB8EEEEBAE4909D121781ACB1A1FB6	119,832,245					[/seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote]	[signer message tx aggregate_vote]	[{"@type":"/seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote","exchange_rates":"7.399908354120531991uatom,94597.622901389571044059ubtc,3538.024587183149349726ueth,0.589148696836354228uosmo,0.514828249879170378usei,0.999846331475181332uusdc,1.000240425969195699uusdt","feeder":"sei1ay3j0cpae2tppuu374tfqht7n70d45vz9uch5e","validator":"seivaloper146m089lq8mkqw6w0mmlhxz6247g2taha89at74"}]	[Key: evm_addr, Value: 0x20999166D82f8BcDc83E699cDAB50fe5A17b9c82 Key: sender, Value: sei1ay3j0cpae2tppuu374tfqht7n70d45vz9uch5e Key: acc_seq, Value: sei1ay3j0cpae2tppuu374tfqht7n70d45vz9uch5e/5226555 Key: action, Value: /seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote Key: sei_addr, Value: sei1ay3j0cpae2tppuu374tfqht7n70d45vz9uch5e Key: exchange_rates, Value: 7.399908354120531991uatom,94597.622901389571044059ubtc,3538.024587183149349726ueth,0.589148696836354228uosmo,0.514828249879170378usei,0.999846331475181332uusdc,1.000240425969195699uusdt Key: signature, Value: CjK1QVA5q/c9cSJIQI2NuzxnQA2mPqNWgwowHtrnJEVSGlhpm+qA4vIQfP0DjiyWF2VGzW/mRhsw7EJ7mG0fMA== Key: voter, Value: seivaloper146m089lq8mkqw6w0mmlhxz6247g2taha89at74 Key: fee_payer, Value: sei1ay3j0cpae2tppuu374tfqht7n70d45vz9uch5e Key: module, Value: oracle Key: fee, Value: 0usei]
2024-12-10	02D2B25E97B7596E794C9703B36C5C6100EB2C546CACACB5E115A9BBE7EFDF9F	119,832,245					[/seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote]	[tx signer message aggregate_vote]	[{"@type":"/seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote","exchange_rates":"7.387081615540767269uatom,94597.622896431703226051ubtc,3538.024587183149349726ueth,0.588629126781658587uosmo,0.514927149285300857usei,0.999847183104143599uusdc,1.000240393241813976uusdt","feeder":"sei14n9fhykwk8rk7zln7rzd6uyhm2gzntuw2pv0e9","validator":"seivaloper1t9fq3qfm7ngau5gr8qgf5dpfzjqg79kf65cu04"}]	[Key: acc_seq, Value: sei14n9fhykwk8rk7zln7rzd6uyhm2gzntuw2pv0e9/58874378 Key: fee, Value: 0usei Key: evm_addr, Value: 0x5f2416E768cCC42719319957DaD61Ac3e55e43B1 Key: module, Value: oracle Key: voter, Value: seivaloper1t9fq3qfm7ngau5gr8qgf5dpfzjqg79kf65cu04 Key: sender, Value: sei14n9fhykwk8rk7zln7rzd6uyhm2gzntuw2pv0e9 Key: sei_addr, Value: sei14n9fhykwk8rk7zln7rzd6uyhm2gzntuw2pv0e9 Key: action, Value: /seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote Key: signature, Value: 3qIT/GwCiFlaeuFHng1aeGXzrP9sEqAZsb4dc1Jcp5BPTdS0Xpp6CiMwbh42gZmd0H/RccPUj8ku6ztGMSmxww== Key: fee_payer, Value: sei14n9fhykwk8rk7zln7rzd6uyhm2gzntuw2pv0e9 Key: exchange_rates, Value: 7.387081615540767269uatom,94597.622896431703226051ubtc,3538.024587183149349726ueth,0.588629126781658587uosmo,0.514927149285300857usei,0.999847183104143599uusdc,1.000240393241813976uusdt]
2024-12-10	22F18497C759EC39FE8EAB3B0BBDB6266106B84A5C6F2D2E641F1B55E8E10847	119,832,245					[/seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote]	[signer tx aggregate_vote message]	[{"@type":"/seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote","exchange_rates":"7.397318809280170064uatom,94598.454675765726495450ubtc,3538.004015886638509011ueth,0.589148696836354228uosmo,0.514856200659762269usei,0.999713518801655316uusdc,1.000160445248179855uusdt","feeder":"sei1v03sk39q3jy42tc30mptnp6vw5fv54e0x6drkv","validator":"seivaloper16znh8ktn33dwnxxc9q0jmxmjf6hsz4tl0s6vxh"}]	[Key: sei_addr, Value: sei1v03sk39q3jy42tc30mptnp6vw5fv54e0x6drkv Key: signature, Value: 0s31KSljC5J6bvUhv6WnSaliihYKQW+2ymTFOcQUy/Bm0B0V6jrAHQmgmmqMuiTsWiJfnzdsPo5BVzbXCtGTWQ== Key: voter, Value: seivaloper16znh8ktn33dwnxxc9q0jmxmjf6hsz4tl0s6vxh Key: sender, Value: sei1v03sk39q3jy42tc30mptnp6vw5fv54e0x6drkv Key: fee, Value: 0usei Key: action, Value: /seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote Key: fee_payer, Value: sei1v03sk39q3jy42tc30mptnp6vw5fv54e0x6drkv Key: evm_addr, Value: 0x9Dfd9c43F5f4A65B28d22eD189a9209cF6f6bddA Key: exchange_rates, Value: 7.397318809280170064uatom,94598.454675765726495450ubtc,3538.004015886638509011ueth,0.589148696836354228uosmo,0.514856200659762269usei,0.999713518801655316uusdc,1.000160445248179855uusdt Key: module, Value: oracle Key: acc_seq, Value: sei1v03sk39q3jy42tc30mptnp6vw5fv54e0x6drkv/58225917]
2024-12-10	91024983DDA33E6035562C0A46E648DD9AFE1D8C7A0A61BD222701B98B504475	119,832,245					[/seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote]	[signer tx message aggregate_vote]	[{"@type":"/seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote","exchange_rates":"7.386891478338662423uatom,94599.332332198901396258ubtc,3538.004429118029532001ueth,0.588629126781658587uosmo,0.514932943090108687usei,0.999848126170911464uusdc,1.000240425969195699uusdt","feeder":"sei1umsz72jtj9n30hkehahhq9mfj5k53apv8s6hsy","validator":"seivaloper1d50kgydm02xg9kpafa8e3jwz83c0uvagkx9m5n"}]	[Key: evm_addr, Value: 0x417c5363a44C1C0907bBb8fdEff4514f9aed6699 Key: fee, Value: 0usei Key: action, Value: /seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote Key: sei_addr, Value: sei1umsz72jtj9n30hkehahhq9mfj5k53apv8s6hsy Key: module, Value: oracle Key: acc_seq, Value: sei1umsz72jtj9n30hkehahhq9mfj5k53apv8s6hsy/58861524 Key: fee_payer, Value: sei1umsz72jtj9n30hkehahhq9mfj5k53apv8s6hsy Key: sender, Value: sei1umsz72jtj9n30hkehahhq9mfj5k53apv8s6hsy Key: signature, Value: UMPyR9qL8Hyq4z02llbQFQgOfpD6CTuh8McBrKOz059WG6kL9KjeSP1+9oLsE2n6ScbLooxJyLabS9VRMctR+g== Key: exchange_rates, Value: 7.386891478338662423uatom,94599.332332198901396258ubtc,3538.004429118029532001ueth,0.588629126781658587uosmo,0.514932943090108687usei,0.999848126170911464uusdc,1.000240425969195699uusdt Key: voter, Value: seivaloper1d50kgydm02xg9kpafa8e3jwz83c0uvagkx9m5n]
2024-12-10	980FB35781EB6D42DC250713AD9FB0C1A7D99B7FA635116D1E84F8D4586AFE3D	119,832,245					[/seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote]	[tx message aggregate_vote signer]	[{"@type":"/seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote","exchange_rates":"7.400285110830899053uatom,94597.622901389571044059ubtc,3538.024587183149349726ueth,0.589148696836354228uosmo,0.514911772348361690usei,0.999842677711114155uusdc,1.000240425969195699uusdt","feeder":"sei1gnmmg6mcc3nf25ur8a55yyjm5f95k2gwulwyqh","validator":"seivaloper1gnmmg6mcc3nf25ur8a55yyjm5f95k2gwzsl2p8"}]	[Key: fee, Value: 0usei Key: fee_payer, Value: sei1gnmmg6mcc3nf25ur8a55yyjm5f95k2gwulwyqh Key: module, Value: oracle Key: action, Value: /seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote Key: exchange_rates, Value: 7.400285110830899053uatom,94597.622901389571044059ubtc,3538.024587183149349726ueth,0.589148696836354228uosmo,0.514911772348361690usei,0.999842677711114155uusdc,1.000240425969195699uusdt Key: sender, Value: sei1gnmmg6mcc3nf25ur8a55yyjm5f95k2gwulwyqh Key: sei_addr, Value: sei1gnmmg6mcc3nf25ur8a55yyjm5f95k2gwulwyqh Key: signature, Value: /ByVU+gfVUEs7LlSBzCE6wiSpVCEU7VOaWADVflEhMMUb/+sG5Nwz3+boxMQRW9PlO+oPJM8km61yex9Q5p2EA== Key: evm_addr, Value: 0xC0452Cef98C01C643C524a20bb142d2335677C4B Key: acc_seq, Value: sei1gnmmg6mcc3nf25ur8a55yyjm5f95k2gwulwyqh/3457442 Key: voter, Value: seivaloper1gnmmg6mcc3nf25ur8a55yyjm5f95k2gwzsl2p8]
2024-12-10	5F562C57EAA5216379FF9D9DFD646DA7DD9DEFC5771CD8863B04AD1213F9E20E	119,832,245					[/seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote]	[signer tx aggregate_vote message]	[{"@type":"/seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote","exchange_rates":"7.387075441312424682uatom,94599.332332198901396258ubtc,3538.004429118029532001ueth,0.588629126781658587uosmo,0.514940618136072083usei,0.999843339093968104uusdc,1.000240425969195699uusdt","feeder":"sei1pwnqs47ymjft945dhvdm4vzga6qsphsw6shlex","validator":"seivaloper10c6rrz55ukkaf7rjeerhpxwpqel4tllzs8vgfq"}]	[Key: evm_addr, Value: 0xA606b4D55D7301815cDDEE0A0037A6837aA2421B Key: acc_seq, Value: sei1pwnqs47ymjft945dhvdm4vzga6qsphsw6shlex/3445077 Key: exchange_rates, Value: 7.387075441312424682uatom,94599.332332198901396258ubtc,3538.004429118029532001ueth,0.588629126781658587uosmo,0.514940618136072083usei,0.999843339093968104uusdc,1.000240425969195699uusdt Key: signature, Value: M2eZRpaFA/YIvX0wJyDkvSV0zVpUH+zyIcYEu476shNo7m6Lv387BNTHrjQOeRx3y/Zqcd8tyLXFrhFqiFIkyA== Key: voter, Value: seivaloper10c6rrz55ukkaf7rjeerhpxwpqel4tllzs8vgfq Key: module, Value: oracle Key: sender, Value: sei1pwnqs47ymjft945dhvdm4vzga6qsphsw6shlex Key: sei_addr, Value: sei1pwnqs47ymjft945dhvdm4vzga6qsphsw6shlex Key: action, Value: /seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote Key: fee, Value: 0usei Key: fee_payer, Value: sei1pwnqs47ymjft945dhvdm4vzga6qsphsw6shlex]