party_contribution
3 rows where partyId = 893
This data as json, CSV (advanced)
| id ▼ | partyAddress | contributedBy | transactionHash | contributedAmountWei | blockNumber | previousTotalContributedToPartyWei | totalFromContributorWei | runId | partyId |
|---|---|---|---|---|---|---|---|---|---|
| 8151 | 0x6256c8c9957c43781109bc02e9e4dd716d32bbd0 | 0x70ece45cdc64a768f936ccb8ac851578251363e3 | 0x838f1b26b76c078a957d915a3bcb79c9db34e54d1f55699980326ce1d3a088f0 | 2.5e+16 | 12999269.0 | 0.0 | 2.5e+16 | 373 | CollectiveCollection 893 |
| 8157 | 0x6256c8c9957c43781109bc02e9e4dd716d32bbd0 | 0xf627e5f4bad95a956468d8bb6ee20b119f992e96 | 0x135d9acf199a2d628411fb03705bdb9970d9836b02cdac521dca50efd753f1b8 | 1e+16 | 13026271.0 | 2.5e+16 | 1e+16 | 373 | CollectiveCollection 893 |
| 8163 | 0x6256c8c9957c43781109bc02e9e4dd716d32bbd0 | 0x1350f912f00f09b8fbbfd71ac73a286c0cd814c6 | 0xeaa10f7385684a7559961fd4343d8a30ddb8047a93faf78ad89e8865cff18cdc | 3.5e+16 | 13053879.0 | 3.5e+16 | 3.5e+16 | 373 | CollectiveCollection 893 |
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]);