party_contribution
2 rows where partyId = 926
This data as json, CSV (advanced)
| id ▼ | partyAddress | contributedBy | transactionHash | contributedAmountWei | blockNumber | previousTotalContributedToPartyWei | totalFromContributorWei | runId | partyId |
|---|---|---|---|---|---|---|---|---|---|
| 8936 | 0x54e2085271af15665a51afd0ff16836e5b9b7988 | 0xf56345338cb4cddaf915ebef3bfde63e70fe3053 | 0x4c99c7be6dd6dba43604cd865c9bbb85b0cbdc522ee3f6cc8bfd667a9afec133 | 1e+17 | 13043393.0 | 0.0 | 1e+17 | 373 | No Future (Lead by Bored Elon) 926 |
| 8942 | 0x54e2085271af15665a51afd0ff16836e5b9b7988 | 0x508ad3d4c1ecfa35ea886312f82005f841d59268 | 0x5576a8f38f507530836b98a3d69fe80de613b68e5748a266f4322fedff9e1c9b | 1e+17 | 13044126.0 | 1e+17 | 1e+17 | 373 | No Future (Lead by Bored Elon) 926 |
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]);