party_contribution
2 rows where partyId = 892
This data as json, CSV (advanced)
| id ▼ | partyAddress | contributedBy | transactionHash | contributedAmountWei | blockNumber | previousTotalContributedToPartyWei | totalFromContributorWei | runId | partyId |
|---|---|---|---|---|---|---|---|---|---|
| 8134 | 0xc8d0a35df0a2bcecb8fa3d0ea63e4fe9bd126c4a | 0x8700b87c2a053bde8cdc84d5078b4ae47c127feb | 0xd745913d59240a63ff49baea7d8bf92ae01ff2ed966661968d6a3fd4b1086bde | 6.9e+17 | 12999942.0 | 0.0 | 6.9e+17 | 373 | 🍆🍆🍆 892 |
| 8140 | 0xc8d0a35df0a2bcecb8fa3d0ea63e4fe9bd126c4a | 0x8269c9ecf3fceae69896ac193a8e61bc243b120c | 0x2d62e9594c3febd35ad1f6f7ea7ca90dde455554645eebaad8817d426e0ae991 | 6.9e+17 | 13019900.0 | 6.9e+17 | 6.9e+17 | 373 | 🍆🍆🍆 892 |
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]);