party_contribution
3 rows where partyId = 950
This data as json, CSV (advanced)
| id ▼ | partyAddress | contributedBy | transactionHash | contributedAmountWei | blockNumber | previousTotalContributedToPartyWei | totalFromContributorWei | runId | partyId |
|---|---|---|---|---|---|---|---|---|---|
| 9855 | 0xcdab206a717d976162846ea068d667ea793ae3f1 | 0x008c84421da5527f462886cec43d2717b686a7e4 | 0x7969a4dcbf50f5f051aa9960036daa5834aee6de505a1d386890322b6752d68c | 3e+18 | 13065198.0 | 0.0 | 3e+18 | 373 | Noun 14 950 |
| 9861 | 0xcdab206a717d976162846ea068d667ea793ae3f1 | 0xa8a30174d1cc072bf152a7ac41e962f80a2a5ed3 | 0x88f9a5d08d5e4152774d4342e17b71505bd9c92f30f3d3d13728af0c1e11db87 | 5e+17 | 13065964.0 | 3e+18 | 5e+17 | 373 | Noun 14 950 |
| 9867 | 0xcdab206a717d976162846ea068d667ea793ae3f1 | 0xbf24bb6ce53fe0ff68f08a24891cf40a4fe3dcf5 | 0xaa657eb22b24a6b5854137e3605277d3780e912956c4322ab866aa61e541f0a6 | 5e+16 | 13066928.0 | 3.5e+18 | 5e+16 | 373 | Noun 14 950 |
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]);