certifications
Data license: Open Parliament Licence · Data source: Original Data Source
19 rows where political_party_id = 84
This data as json, CSV (advanced)
id ▼ | candidacy_id | political_party_id | adjunct_to_certification_id |
---|---|---|---|
1810 | 1864 1864 | Alliance For Green Socialism 84 | |
1905 | 1959 1959 | Alliance For Green Socialism 84 | |
1911 | 1965 1965 | Alliance For Green Socialism 84 | |
2878 | 2965 2965 | Alliance For Green Socialism 84 | |
5332 | 5541 5541 | Alliance For Green Socialism 84 | |
5406 | 5620 5620 | Alliance For Green Socialism 84 | |
5418 | 5631 5631 | Alliance For Green Socialism 84 | |
8582 | 8931 8931 | Alliance For Green Socialism 84 | |
8594 | 8942 8942 | Alliance For Green Socialism 84 | |
8641 | 8992 8992 | Alliance For Green Socialism 84 | |
11954 | 12531 12531 | Alliance For Green Socialism 84 | |
11978 | 12555 12555 | Alliance For Green Socialism 84 | |
12032 | 12615 12615 | Alliance For Green Socialism 84 | |
15255 | 16123 16123 | Alliance For Green Socialism 84 | |
15336 | 16210 16210 | Alliance For Green Socialism 84 | |
15342 | 16216 16216 | Alliance For Green Socialism 84 | |
15350 | 16224 16224 | Alliance For Green Socialism 84 | |
16312 | 17253 17253 | Alliance For Green Socialism 84 | |
16917 | 17898 17898 | Alliance For Green Socialism 84 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "certifications" ( [id] INTEGER PRIMARY KEY, [candidacy_id] INTEGER REFERENCES [candidacies]([id]), [political_party_id] INTEGER REFERENCES [political_parties]([id]), [adjunct_to_certification_id] INTEGER REFERENCES [certifications]([id]) ); CREATE INDEX [idx_certifications_adjunct_to_certification_id] ON [certifications] ([adjunct_to_certification_id]); CREATE INDEX [idx_certifications_political_party_id] ON [certifications] ([political_party_id]); CREATE INDEX [idx_certifications_candidacy_id] ON [certifications] ([candidacy_id]);