{
  "data": [
    {
      "drepId": "drep1y24xr6m4mkgl7e7886sk3wee7h73mcreysyvhrwzksy5ajqrv0rrv",
      "id": "dc3cfd1e-3308-4223-adf6-da1662a1b4b0",
      "links": [
        "x.com/Crown_Tech1021",
        "crown-tech.co.jp/ctecstakepool",
        "https://www.crown-tech.co.jp/DRep/CTEC-Stake-Pool.jsonld"
      ],
      "metrics": {
        "participationRate": 100,
        "votingPower": 19829102.491109,
        "communityAlignment": 0,
        "proposalsVoted": 12,
        "globalAlignment": 54.19,
        "totalDelegators": 33,
        "totalAllowedProposals": 12,
        "totalProposals": 18
      },
      "motivations": "●目標：Target\n\n・安全で安心できるカルダノネットワークを運営する\n\n　Operate a safe and secure Cardano network.\n\n・カルダノネットワークをより高度な次元へ発展させるために貢献する\n\n　Contribute to the development of the Cardano network to a higher dimension.\n",
      "name": "CTEC-Stake-Pool",
      "objectives": "●ミッション：mission\n\nカルダノネットワークの発展のためにDRepとして活動していきます\n\nI will work as a DRep for the development of the Cardano network.",
      "profilePic": null,
      "qualifications": "●資格：Qualifications\n\n　CTEC Stake Pool Operator（SPO）",
      "registration_date": "2024-11-14T09:54:59+00:00",
      "status": "active",
      "username": "drep1y24xr6m4mkgl7e7886sk3wee7h73mcreysyvhrwzksy5ajqrv0rrv",
      "voting_history": [
        {
          "communityAlignment": "Coming Soon",
          "alignmentStatus": "aligned",
          "date": "2025-03-25",
          "globalAlignment": 54.19,
          "id": "1b75c28f-e77b-4304-b050-9ee894d863f5",
          "isAligned": true,
          "proposalId": "gov_action1nd3t833j7v5sz65k3tp9yyvztw60sjcjgcgjr37682s3m7frwrusqmd2k80",
          "isIncluded": true,
          "proposalTitle": "2025 Net Change Limit",
          "majorityVote": "Yes",
          "proposalUrl": "ipfs://bafkreiaqno22swabd3kcqt2awtgwaucdzaagacoemxwadm3exrchhnfite",
          "rationale": "As agreed with the Cardano Budget Committee, the 2025 Net Change Limit shall begin at the start of Epoch 532 and progress for 72 epochs, concluding in December 2025 at the end of Epoch 604.\n\nThe 2025 Net Change Limit shall be set at 350,000,000,000,000 lovelace (350M ada).\n\nThis figure is derived from our modeling, which projected in October 2024 that the treasury would increase by approximately 351M ada across 2024 (epoch 459-531), including all approved withdrawals (e.g., Catalyst). Based on this analysis, the 2025 Net Change Limit was proposed at 350m ada. From January 5th, 2024, Epoch 459, through December 30th, Epoch 531, the actual total income into the Cardano Treasury was 335,957,093 ada. Since this is within 5% of our proposed number, the 2025 Net Change Limit should stay at 350 million ada.",
          "type": "InfoAction",
          "subtype": null,
          "vote": "Yes",
          "drepVotingAllowed": true
        }
      ],
      "active_since": "2024-11-14T09:54:59",
      "metadata": {
        "drep_id": "drep1y24xr6m4mkgl7e7886sk3wee7h73mcreysyvhrwzksy5ajqrv0rrv",
        "hex": "22aa61eb75dd91ff67c73ea168bb39f5fd1de0792408cb8dc2b4094ec8",
        "url": "https://www.crown-tech.co.jp/DRep/CTEC-Stake-Pool.jsonld",
        "hash": "d679b05cc0de219e47c11333bc1faf0caa6b75d480dbf406b69a60016ef8b551",
        "json_metadata": { /* ... detailed metadata ... */ },
        "bytes": "\\x7b0a20202240636f...",
        "location": null,
        "other_links": [
          "x.com/Crown_Tech1021",
          "crown-tech.co.jp/ctecstakepool"
        ],
        "created_at": "2025-04-09T10:27:41.477642+00:00",
        "updated_at": "2025-05-21T03:14:13.159637+00:00"
      }
    }
  ],
  "meta": {
    "explanation": "Found 112 DReps who voted yes on the Cardano net change proposal and no on the Cardano Treasury DeFi Liquidity Budget, while DRep voting was not allowed for the Plutus V3 Cost Model Parameter Changes. These DReps demonstrate active governance participation with an average participation rate of 84.49% and significant voting power representation.",
    "query": "Find DReps who voted yes on the cardano net change and no on Cardano Treasury DeFi Liquidity Budget",
    "parsedQuery": {
      "queryType": "proposal_first",
      "proposalFilters": {
        "title": {
          "all": [
            "Set a 300 million ADA Net Change Limit for Epochs 563–635",
            "Cardano Treasury DeFi Liquidity Budget"
          ]
        }
      },
      "voteFilters": {
        "vote": {
          "all": [
            {
              "proposalTitle": "Set a 300 million ADA Net Change Limit for Epochs 563–635",
              "value": "yes"
            },
            {
              "proposalTitle": "Cardano Treasury DeFi Liquidity Budget", 
              "value": "no"
            }
          ]
        },
        "voterRole": "DRep"
      },
      "drepFilters": {},
      "orderBy": [
        {
          "column": "participation_data->rate",
          "direction": "desc",
          "nullsPosition": "last",
          "excludeZeros": false
        },
        {
          "column": "basic_info->ada_delegated",
          "direction": "desc", 
          "nullsPosition": "last",
          "excludeZeros": false
        }
      ],
      "explanation": "Query focuses on DReps with specific voting patterns across multiple proposals using AND logic.",
      "pagination": {
        "page": 1,
        "limit": 5,
        "total": 112,
        "pages": 23
      }
    },
    "queryIntent": "proposal_first",
    "matchedProposals": [
      {
        "id": "gov_action1vdlrcftd48qn2zz8egepr6xyfcmxpfz8r69k769gc5mhg662adesq9yy8pl",
        "title": "Set a 300 million ADA Net Change Limit for Epochs 563–635",
        "type": "InfoAction",
        "subtype": null,
        "drepVotingAllowed": true
      },
      {
        "id": "gov_action1fpqwxp2kxvnntr8hpkh9q9djm78ccdww7qlhg5safugh4stmcwzqql5lauu",
        "title": "Cardano Treasury DeFi Liquidity Budget",
        "type": "InfoAction", 
        "subtype": null,
        "drepVotingAllowed": true
      }
    ],
    "resultCount": 1,
    "usedCache": true,
    "redisAvailable": true,
    "sortInfo": {
      "field": "participation",
      "direction": "desc"
    },
    "optimized": true
  },
  "pagination": {
    "page": 1,
    "limit": 10,
    "total": 194,
    "pages": 20
  },
  "timings": {
    "intent_determination": 1631,
    "query_parsing": 5060,
    "database_queries": 609,
    "data_transformation": 0,
    "explanation_generation": 2917,
    "proposal_validation": 6649,
    "redis_get": 332,
    "redis_set": 0,
    "sort_application": 1,
    "total": 1120
  }
}