party_contribution
3 rows where partyId = 988
This data as json, CSV (advanced)
| id ▼ | partyAddress | contributedBy | transactionHash | contributedAmountWei | blockNumber | previousTotalContributedToPartyWei | totalFromContributorWei | runId | partyId |
|---|---|---|---|---|---|---|---|---|---|
| 10831 | 0x35a73bb1aca43fd3bb366086f7a54e05f3495361 | 0xc2bd45d9a9d42d8d9371b9fe86d6c66ec85f651b | 0xa6963d70314fade71f95e07fcf102e529647cadec20a00b32f8214a7d6ce0cb0 | 4e+18 | 13153434.0 | 0.0 | 4e+18 | 373 | DESOLATION 988 |
| 10837 | 0x35a73bb1aca43fd3bb366086f7a54e05f3495361 | 0xc2bd45d9a9d42d8d9371b9fe86d6c66ec85f651b | 0x1b366500f2a3400082953e7b5aca22c2a6b712208ceb358ff102fae766dbc35e | 2e+18 | 13153530.0 | 4e+18 | 6e+18 | 373 | DESOLATION 988 |
| 10843 | 0x35a73bb1aca43fd3bb366086f7a54e05f3495361 | 0xc2bd45d9a9d42d8d9371b9fe86d6c66ec85f651b | 0xdc4a3d2896e4c86602c73bdbe7a20d50dd9d2cef8444568985b8d08e6e9f669c | 3e+18 | 13153539.0 | 6e+18 | 9e+18 | 373 | DESOLATION 988 |
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]);