party_finalized
1 row where partyId = 991
This data as json, CSV (advanced)
| id ▼ | partyAddress | versionNumber | transactionHash | totalSpentWei | feeWei | totalContributedWei | blockNumber | result | runId | partyId |
|---|---|---|---|---|---|---|---|---|---|---|
| 297 | 0x5b00ba8a84c45df9c503cfb8f9ed52baeda47174 | 1 | 0xf6bd9be5475f5413941ab57f85bef12c8002a623537dfe4ec750dc65fbf1af6d | 0.0 | 0.0 | 2.7101e+18 | 13168110.0 | 2 | 373 | 𝚝𝚊𝚕𝚕 𝚏𝚛𝚎𝚗𝚜 991 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "party_finalized" (
[id] INTEGER PRIMARY KEY,
[partyAddress] TEXT,
[versionNumber] INTEGER,
[transactionHash] TEXT,
[totalSpentWei] FLOAT,
[feeWei] FLOAT,
[totalContributedWei] FLOAT,
[blockNumber] FLOAT,
[result] INTEGER,
[runId] INTEGER,
[partyId] INTEGER REFERENCES [party]([id])
);
CREATE INDEX [idx_party_finalized_partyId]
ON [party_finalized] ([partyId]);
CREATE INDEX [idx_party_finalized_partyAddress]
ON [party_finalized] ([partyAddress]);
CREATE INDEX [idx_party_finalized_result]
ON [party_finalized] ([result]);