party_contribution
2 rows where partyId = 999
This data as json, CSV (advanced)
| id ▼ | partyAddress | contributedBy | transactionHash | contributedAmountWei | blockNumber | previousTotalContributedToPartyWei | totalFromContributorWei | runId | partyId |
|---|---|---|---|---|---|---|---|---|---|
| 11052 | 0x25f7b714f5c1bc4b633222b5b9ea86aa005c5431 | 0xcde3725b25d6d9bc78cf0941cc15fd9710c764b9 | 0x7f40cbda9dfe515a6e3b24fdf38182b01e871f8842454d6b1e541c2a4a1cfa43 | 1e+17 | 13198617.0 | 0.0 | 1e+17 | 373 | "Yield" Party 999 |
| 11057 | 0x25f7b714f5c1bc4b633222b5b9ea86aa005c5431 | 0x70a5d38b135482c89cf540bc27cf5c282c73c35c | 0x55607448511387c0b8e713df9fbfad83cb490a73b34e14fcdb42af99c29f1acd | 1e+17 | 13198646.0 | 1e+17 | 1e+17 | 373 | "Yield" Party 999 |
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]);