party_contribution
2 rows where partyId = 922
This data as json, CSV (advanced)
| id ▼ | partyAddress | contributedBy | transactionHash | contributedAmountWei | blockNumber | previousTotalContributedToPartyWei | totalFromContributorWei | runId | partyId |
|---|---|---|---|---|---|---|---|---|---|
| 8813 | 0x3c2e365946d33e0872da276c18be6c60ed5136d6 | 0x4184740fd5ff75b1d66aaddd5b9b5772296f8f46 | 0xee154fb79afeabdefc309cc2b508ddbab89df351b4400166c892f583e76e5012 | 2.5e+17 | 13031972.0 | 0.0 | 2.5e+17 | 373 | Beast in the dark 922 |
| 8819 | 0x3c2e365946d33e0872da276c18be6c60ed5136d6 | 0x836ef81a58e5565b8d1d555ec8e9a5c2792511c6 | 0x96d131b472c127a2244a32208440aaf73a94b90f3e6b842ffb6f99bf2d9e9e05 | 1e+17 | 13037370.0 | 2.5e+17 | 1e+17 | 373 | Beast in the dark 922 |
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]);