party_contribution
2 rows where partyId = 975
This data as json, CSV (advanced)
| id ▼ | partyAddress | contributedBy | transactionHash | contributedAmountWei | blockNumber | previousTotalContributedToPartyWei | totalFromContributorWei | runId | partyId |
|---|---|---|---|---|---|---|---|---|---|
| 10512 | 0xe09d6985a5275f6276e680561af78c4046ec630f | 0x008c84421da5527f462886cec43d2717b686a7e4 | 0xc9826acea8f043a34260ad40c82921baf72f5f2ceea41bdebbc4d2a1b9be1d52 | 2.5e+19 | 13129582.0 | 0.0 | 2.5e+19 | 373 | SquidBid 975 |
| 10518 | 0xe09d6985a5275f6276e680561af78c4046ec630f | 0xa58899bbc983781d47c7dd5a6b8aeef53cd34bbc | 0xfa036d0b61b53db56f73a69ce50804b13cd0e8a9bbb875a8f94593fdd3abb2be | 2.5e+19 | 13129619.0 | 2.5e+19 | 2.5e+19 | 373 | SquidBid 975 |
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]);