Raw data explorer

This table shows statement-based, sourced records from our database. For more context, learn about how OpenSanctions stores information.

ID	Property	Value	Lang	Source dataset	Source ID	First seen
Q512681	`Person:birthDate`	1962-01-28		everypolitician	evpo-e3a2f111-07f8-41bc-92fb-7864c2695f36	2021-07-26
Q512681	`Person:birthDate`	1962-01-28		wikidata	Q512681	2023-07-18
Q512681	`Person:birthPlace`	Gourock	eng	wikidata	Q512681	2023-07-18
Q512681	`Person:country`	gb		wd_peps	Q512681	2023-04-20
Q512681	`Person:country`	gb-sct		everypolitician	evpo-e3a2f111-07f8-41bc-92fb-7864c2695f36	2019-05-21
Q512681	`Person:education`	University of Glasgow	eng	wikidata	Q512681	2023-07-18
Q512681	`Person:education`	City, University of London	eng	wikidata	Q512681	2023-07-18
Q512681	`Person:email`	Joan.McAlpine.msp@parliament.scot		everypolitician	evpo-e3a2f111-07f8-41bc-92fb-7864c2695f36	2021-07-26
Q512681	`Person:firstName`	Joan	eng	wikidata	Q512681	2023-07-18
Q512681	`Person:firstName`	Joan		everypolitician	evpo-e3a2f111-07f8-41bc-92fb-7864c2695f36	2021-07-26
Q512681	`Person:gender`	female	eng	wikidata	Q512681	2023-07-18
Q512681	`Person:gender`	female		everypolitician	evpo-e3a2f111-07f8-41bc-92fb-7864c2695f36	2021-07-26
Q512681	`Person:id`	96d2ea0fd4eeb929f705ac99a46c0fe5fd391423		everypolitician	evpo-e3a2f111-07f8-41bc-92fb-7864c2695f36	2019-05-21
Q512681	`Person:id`	20df07fa5ffb1f0f8fcb66b88587caadaa571422		wd_peps	Q512681	2023-04-20
Q512681	`Person:id`	b626e7484add43596783d6c45b940b3cc9e5eb87		wikidata	Q512681	2024-04-12
Q512681	`Person:id`	ca0ebece459150a7638846121969587919863eb8		everypolitician	evpo-e3a2f111-07f8-41bc-92fb-7864c2695f36	2019-05-21
Q512681	`Person:id`	1abedf28edbb9215f4b235166ba920aa0469e523		everypolitician	evpo-e3a2f111-07f8-41bc-92fb-7864c2695f36	2019-05-21
Q512681	`Person:keywords`	State government		wd_peps	Q512681	2023-04-20
Q512681	`Person:lastName`	McAlpine		everypolitician	evpo-e3a2f111-07f8-41bc-92fb-7864c2695f36	2021-07-26
Q512681	`Person:lastName`	McAlpine	eng	wikidata	Q512681	2023-07-18
Q512681	`Person:modifiedAt`	2024-04-07		wikidata	Q512681	2024-04-12
Q512681	`Person:modifiedAt`	2019-05-12		everypolitician	evpo-e3a2f111-07f8-41bc-92fb-7864c2695f36	2022-01-21
Q512681	`Person:name`	Joan McAlpine	eng	wikidata	Q512681	2023-07-18
Q512681	`Person:name`	Joan McAlpine		everypolitician	evpo-e3a2f111-07f8-41bc-92fb-7864c2695f36	2021-07-26
Q512681	`Person:name`	Joan McAlpine		wd_peps	Q512681	2023-04-20
Q512681	`Person:nationality`	gb-sct		everypolitician	evpo-e3a2f111-07f8-41bc-92fb-7864c2695f36	2021-07-26
Q512681	`Person:nationality`	gb	eng	wikidata	Q512681	2023-07-18
Q512681	`Person:notes`	Scottish journalist and politician (born 1962)	eng	wikidata	Q512681	2023-07-18
Q512681	`Person:position`	Scottish Parliament (member, 2011-2016)		everypolitician	evpo-e3a2f111-07f8-41bc-92fb-7864c2695f36	2022-04-23
Q512681	`Person:position`	Member of the 4th Scottish Parliament (2011-2016)	eng	wikidata	Q512681	2023-07-18
Q512681	`Person:position`	Member of the 5th Scottish Parliament (2016-2021)	eng	wikidata	Q512681	2023-07-18
Q512681	`Person:position`	Scottish Parliament (member, 2016-)		everypolitician	evpo-e3a2f111-07f8-41bc-92fb-7864c2695f36	2022-04-23
Q512681	`Person:topics`	role.pep		wikidata	Q512681	2023-07-18
Q512681	`Person:topics`	role.pep		wd_peps	Q512681	2023-04-20
Q512681	`Person:topics`	role.pep		everypolitician	evpo-e3a2f111-07f8-41bc-92fb-7864c2695f36	2021-07-26
Q512681	`Person:website`	http://www.joanmcalpine.com/		wikidata	Q512681	2023-07-18
Q512681	`Person:website`	https://twitter.com/JoanMcAlpine		everypolitician	evpo-e3a2f111-07f8-41bc-92fb-7864c2695f36	2021-07-26
Q512681	`Person:website`	http://www.joanmcalpine.com/		everypolitician	evpo-e3a2f111-07f8-41bc-92fb-7864c2695f36	2021-07-26
Q512681	`Person:wikidataId`	Q512681		wikidata	Q512681	2023-07-18
Q512681	`Person:wikidataId`	Q512681		everypolitician	evpo-e3a2f111-07f8-41bc-92fb-7864c2695f36	2021-07-26

Previous
1 - 40 of 40
Next