party_contribution
1 row where partyId = 976
This data as json, CSV (advanced)
| id ▼ | partyAddress | contributedBy | transactionHash | contributedAmountWei | blockNumber | previousTotalContributedToPartyWei | totalFromContributorWei | runId | partyId |
|---|---|---|---|---|---|---|---|---|---|
| 10529 | 0xa357407fdda7fd6ce8223b8095c886b0ace62a7a | 0x1c92efdb6c924cb2acf7dceec29b7abb69ab58bc | 0x5056b10197f64ad1182347f26dea22dd3b7961871d6259215c334ed1a3c9e3c1 | 5e+17 | 13133967.0 | 0.0 | 5e+17 | 373 | BanksyParty 976 |
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]);