party_contribution
2 rows where partyId = 857
This data as json, CSV (advanced)
| id ▼ | partyAddress | contributedBy | transactionHash | contributedAmountWei | blockNumber | previousTotalContributedToPartyWei | totalFromContributorWei | runId | partyId |
|---|---|---|---|---|---|---|---|---|---|
| 7781 | 0xbde14d753db2806af3bdf82e9bd43ac8bbda674f | 0xbc68dee71fd19c6eb4028f98f3c3ab62aad6fef3 | 0x2b379922610b29ecbc5f209de289810cf7e6c2190ea756eef3a82c2c19011028 | 5e+16 | 12961215.0 | 0.0 | 5e+16 | 373 | FZ First Party: Surveillance State 👁 857 |
| 7787 | 0xbde14d753db2806af3bdf82e9bd43ac8bbda674f | 0x08aea2985b70552c577d393c01ef44af70277c57 | 0xc19a9c7774f1e0dd11c07979fc1842f47b658ae0afab12457d605141acdc652f | 7e+16 | 12961394.0 | 5e+16 | 7e+16 | 373 | FZ First Party: Surveillance State 👁 857 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "party_contribution" (
[id] INTEGER PRIMARY KEY,
[partyAddress] TEXT,
[contributedBy] TEXT,
[transactionHash] TEXT,
[contributedAmountWei] FLOAT,
[blockNumber] FLOAT,
[previousTotalContributedToPartyWei] FLOAT,
[totalFromContributorWei] FLOAT,
[runId] INTEGER,
[partyId] INTEGER REFERENCES [party]([id])
);
CREATE INDEX [idx_party_contribution_partyId]
ON [party_contribution] ([partyId]);
CREATE INDEX [idx_party_contribution_partyAddress]
ON [party_contribution] ([partyAddress]);
CREATE INDEX [idx_party_contribution_contributedBy]
ON [party_contribution] ([contributedBy]);