party_contribution
2 rows where partyId = 1001
This data as json, CSV (advanced)
| id ▼ | partyAddress | contributedBy | transactionHash | contributedAmountWei | blockNumber | previousTotalContributedToPartyWei | totalFromContributorWei | runId | partyId |
|---|---|---|---|---|---|---|---|---|---|
| 11068 | 0x9502a35f51d632645e8170328fcc5432beb69414 | 0x841412043d4e6b727bae0ea5ddb5cc73dcb699f2 | 0x4826d3b5853045f83b5283764218f4cc0b296cab2b364383b18e99592a2a9197 | 1e+17 | 13218966.0 | 0.0 | 1e+17 | 373 | Chisweetart fund 1001 |
| 11074 | 0x9502a35f51d632645e8170328fcc5432beb69414 | 0x5794f7de490ea3f193ca8b60373db91a86fda811 | 0x590e9484bcd17332715ec9a05f070073e408030102be0741e70937b6e25935ff | 2e+16 | 13221921.0 | 1e+17 | 2e+16 | 373 | Chisweetart fund 1001 |
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]);