party_contribution
2 rows where partyId = 906
This data as json, CSV (advanced)
| id ▼ | partyAddress | contributedBy | transactionHash | contributedAmountWei | blockNumber | previousTotalContributedToPartyWei | totalFromContributorWei | runId | partyId |
|---|---|---|---|---|---|---|---|---|---|
| 8439 | 0x2d63c418a9e731cf318cb88458249fe3c0a88e81 | 0x6c70e5fc4e4926cd836a6f8b0645aa1a077fa605 | 0xd6a9f220a9f57239673c6c494a9df1e458080b88581db5c1615bff962acb2f26 | 1e+18 | 13008507.0 | 0.0 | 1e+18 | 373 | DreamTeam 906 |
| 8445 | 0x2d63c418a9e731cf318cb88458249fe3c0a88e81 | 0x9cbea9002993dd3a151c54a7618cecc19f6437de | 0xf273fcf387f12c47db280898622db9a719049584ddcdb50f6e7d52ab75b7aa5c | 1e+18 | 13008510.0 | 1e+18 | 1e+18 | 373 | DreamTeam 906 |
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]);