party_contribution
2 rows where partyId = 929
This data as json, CSV (advanced)
| id ▼ | partyAddress | contributedBy | transactionHash | contributedAmountWei | blockNumber | previousTotalContributedToPartyWei | totalFromContributorWei | runId | partyId |
|---|---|---|---|---|---|---|---|---|---|
| 9008 | 0x53075079ce50817464c52bb1ed7fa9972065424a | 0x60a363530ec7db4fe74f5ebe62c337fdca8efe0f | 0xd2dd43eccc8640fb55514d3b026a6495787228d40d4f30918cc4867ef2aecebb | 1.5e+17 | 13044210.0 | 0.0 | 1.5e+17 | 373 | The Guy Soft (Scary) 929 |
| 9014 | 0x53075079ce50817464c52bb1ed7fa9972065424a | 0xc53197e821fd28708c0d5a73e00df3167f4e6c85 | 0xfc2c608042ca9d8a1cdc62f3dab7a77e0676ce826bfa7de498e3f3b74ada3ea1 | 1.1e+17 | 13045621.0 | 1.5e+17 | 1.1e+17 | 373 | The Guy Soft (Scary) 929 |
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]);