party_contribution
2 rows where partyId = 854
This data as json, CSV (advanced)
| id ▼ | partyAddress | contributedBy | transactionHash | contributedAmountWei | blockNumber | previousTotalContributedToPartyWei | totalFromContributorWei | runId | partyId |
|---|---|---|---|---|---|---|---|---|---|
| 7721 | 0x8644ae98e566f6e440bd70692141266bd17e8012 | 0x7435a46b957004fe0353f82778964ace2e37c53b | 0xa784d221e7c0e89257217add9387780566ed7c6d4d3570071917b847703e0440 | 1e+16 | 12960989.0 | 0.0 | 1e+16 | 373 | Angel from the Earth 854 |
| 14862 | 0x8644ae98e566f6e440bd70692141266bd17e8012 | 0x384169ebfc98798e2a367f234b41bc6a66c583aa | 0x58360ae8bbc02a76fabc583b61011f81005555fcd7ab0ca2fc54c777583492e8 | 6000000000000000.0 | 14067897.0 | 1e+16 | 6000000000000000.0 | 28307 | Angel from the Earth 854 |
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]);