party_contribution
4 rows where partyId = 909
This data as json, CSV (advanced)
| id ▼ | partyAddress | contributedBy | transactionHash | contributedAmountWei | blockNumber | previousTotalContributedToPartyWei | totalFromContributorWei | runId | partyId |
|---|---|---|---|---|---|---|---|---|---|
| 8477 | 0xa73388379f1a898f1a69b5ec50a63ae55b44917f | 0x6a4aa35badeb1417811edb4d005384678f4da79e | 0x064c30b61254cc6f302a65a92599f3d4e433f87b2aedd4d29d3bdaee9a42c977 | 1e+16 | 13012559.0 | 0.0 | 1e+16 | 373 | 🗣🗣🗣 909 |
| 8483 | 0xa73388379f1a898f1a69b5ec50a63ae55b44917f | 0xa952623b3bb55e6a8f9421da69ad15aa28899b2f | 0x301538f2aa77efa482f5cb632ddac00d315c6c3c356b5ac1e1c6619078d8cc32 | 1000000000000000.0 | 13012580.0 | 1e+16 | 1000000000000000.0 | 373 | 🗣🗣🗣 909 |
| 8489 | 0xa73388379f1a898f1a69b5ec50a63ae55b44917f | 0xb618aacb9dcdc21ca69d310a6fc04674d293a193 | 0x8bba85527407c444e243d521a258e5285b5bff5a2abfdbd4c7f1bcc4386e8e74 | 1e+18 | 13012765.0 | 1.1e+16 | 1e+18 | 373 | 🗣🗣🗣 909 |
| 8495 | 0xa73388379f1a898f1a69b5ec50a63ae55b44917f | 0x9079a0a7e0ebee7650c8c9da2b6946e5a5b07c19 | 0x3d822ade4d32e7deda54627c38750bd429a992c768b0fe94df303514087ded75 | 5e+17 | 13016266.0 | 1.011e+18 | 5e+17 | 373 | 🗣🗣🗣 909 |
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]);