certifications
Data license: Open Parliament Licence · Data source: Original Data Source
21 rows where political_party_id = 76
This data as json, CSV (advanced)
id ▼ | candidacy_id | political_party_id | adjunct_to_certification_id |
---|---|---|---|
1512 | 1560 1560 | Animal Welfare Party 76 | |
1679 | 1732 1732 | Animal Welfare Party 76 | |
1811 | 1865 1865 | Animal Welfare Party 76 | |
2708 | 2786 2786 | Animal Welfare Party 76 | |
5076 | 5268 5268 | Animal Welfare Party 76 | |
5080 | 5273 5273 | Animal Welfare Party 76 | |
5465 | 5680 5680 | Animal Welfare Party 76 | |
5544 | 5764 5764 | Animal Welfare Party 76 | |
7193 | 7470 7470 | Animal Welfare Party 76 | |
7616 | 7918 7918 | Animal Welfare Party 76 | |
7705 | 8013 8013 | Animal Welfare Party 76 | |
8538 | 8887 8887 | Animal Welfare Party 76 | |
8882 | 9252 9252 | Animal Welfare Party 76 | |
9336 | 9727 9727 | Animal Welfare Party 76 | |
10417 | 10876 10876 | Animal Welfare Party 76 | |
10867 | 11363 11363 | Animal Welfare Party 76 | |
10969 | 11472 11472 | Animal Welfare Party 76 | |
12261 | 12863 12863 | Animal Welfare Party 76 | |
12650 | 13287 13287 | Animal Welfare Party 76 | |
12799 | 13451 13451 | Animal Welfare Party 76 | |
15227 | 16093 16093 | Animal Welfare Party 76 |
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]);