q.sql

select txn_summary(data) from txns limit 1;

response.json

{
  "amount": 49900000,
  "hash": "4b2815d527dcff16a25df94ed2a18700d37f670b37f6f7feee311d15c1d7fffd",
  "block_hash": "000000000000026b76226c39aa82500f429e096926b21ff79c9e6ede9ca9893e",
  "block_height": 205069,
  "block_time": 1351267348,
  "confirmations": 104920,
  "inputs": [
    {
      "script_signature": "304602210099d2d3718c1a0b96b9c4d012a2ee4c798ae6a1bb7dd0ff5dc15f4a2d74d27cd3022100fd2fb70ea959af6de869a030fe3e195efb57333725a9be941192308c69599bc901 048cc0b94178715f03ed3d0bceb368191d0fdd7fc16d806567f6f2c45aecafb8f53e5ef849564072189b9b4f8bfe1564da776567ba359cfb0c05e839bcf65371ab",
      "addresses": [
        "1dice8EMZmqKvrGE4Qc9bUFf9PX3xaYDp"
      ],
      "value": 5e+07,
      "output_index": 0,
      "output_hash": "b4b112221b9fa723ec5e9dfe06fa704501e4e960ef84bab0ae59bb276f91a65e",
      "transaction_hash": "4b2815d527dcff16a25df94ed2a18700d37f670b37f6f7feee311d15c1d7fffd"
    }
  ],
  "outputs": [
    {
      "spent": true,
      "required_signatures": 1,
      "script_type": "pubkeyhash",
      "script": "OP_DUP OP_HASH160 992229f6bcaff1ee9e6ba4664cdc257fa6a7cf8d OP_EQUALVERIFY OP_CHECKSIG",
      "addresses": [
        "1ExhK6rTwVt6iKVrg9cijpYhjVFFYXqMak"
      ],
      "value": 200000,
      "output_index": 0,
      "transaction_hash": "4b2815d527dcff16a25df94ed2a18700d37f670b37f6f7feee311d15c1d7fffd"
    },
    {
      "spent": true,
      "required_signatures": 1,
      "script_type": "pubkeyhash",
      "script": "OP_DUP OP_HASH160 45d906fdc235c3ffb40acb4831a509e5bac4092c OP_EQUALVERIFY OP_CHECKSIG",
      "addresses": [
        "17NKcZNXqAbxWsTwB1UJHjc9mQG3yjGALA"
      ],
      "value": 49700000,
      "output_index": 1,
      "transaction_hash": "4b2815d527dcff16a25df94ed2a18700d37f670b37f6f7feee311d15c1d7fffd"
    }
  ],
  "fees": 100000
}