party_created
1 row where partyId = 970
This data as json, CSV (advanced)
| id ▼ | partyAddress | createdBy | blockNumber | runId | transactionHash | partyId |
|---|---|---|---|---|---|---|
| 970 | 0x78864b864d75aaf14d43d45ec6a894dea767ca2a | 0x036440ad48ba424419a3408202e31dd49425322e | 13113485.0 | 373 | 0x754be6833bf9093358f66bff18c5b79a7a46092d2e4936f039dbbb5d0b5fd5c4 | market square 970 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "party_created" (
[id] INTEGER PRIMARY KEY,
[partyAddress] TEXT,
[createdBy] TEXT,
[blockNumber] FLOAT,
[runId] INTEGER,
[transactionHash] TEXT,
[partyId] INTEGER REFERENCES [party]([id])
);
CREATE INDEX [idx_party_created_partyId]
ON [party_created] ([partyId]);
CREATE INDEX [idx_party_created_partyAddress]
ON [party_created] ([partyAddress]);
CREATE INDEX [idx_party_created_createdBy]
ON [party_created] ([createdBy]);