Data license: CC-BY-SA · Data source: Democracy Club
This data as JSON, CSV (advanced)
Suggested facets: gender, party_id, party_name, post_id, post_label, email, party_ec_id
| Link | rowid | id | name | honorific_prefix | honorific_suffix | gender | birth_date | election | party_id | party_name | post_id | post_label | mapit_url | elected | twitter_username | facebook_page_url | party_ppc_page_url | facebook_personal_url | homepage_url | wikipedia_url | linkedin_url | image_url | proxy_image_url_template | image_copyright | image_uploading_user | image_uploading_user_notes | twitter_user_id | election_date | election_current | party_lists_in_use | party_list_position | old_person_ids | gss_code | parlparse_id | theyworkforyou_url | party_ec_id | favourite_biscuits | cancelled_poll | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14656 | 14656 | 550 | Jackie Grunsell | female | local.pendle.2016-05-05 88 | party:804 | Trade Unionist and Socialist Coalition | DIW:E05005264 | Reedley | jackie.grunsell@hotmail.co.uk | JackieGrunsell | 1186063214 | 2016-05-05 | 0 | 0 | PP804 | 0 | ||||||||||||||||||||||
| 14657 | 14657 | 5730 | Mick Waddington | male | local.pendle.2016-05-05 88 | party:85 | UK Independence Party (UKIP) | DIW:E05005250 | Barrowford | michael.waddington@ukiplocal.org | 2016-05-05 | 0 | 0 | PP85 | 0 | ||||||||||||||||||||||||
| 14658 | 14658 | 18916 | Ian Barnett | male | 1955-09-26 | local.pendle.2016-05-05 88 | party:63 | Green Party | DIW:E05005250 | Barrowford | ian.barnett@greenparty.org.uk | https://www.facebook.com/IanBarnett4Pendle/ | https://my.greenparty.org.uk/candidates/106129 | https://static-candidates.democracyclub.org.uk/media/images/images/18916_dZRGxXg.png | public-domain | ian3 | 2016-05-05 | 0 | 0 | PP63 | 0 | ||||||||||||||||||
| 14659 | 14659 | 18917 | Sue Nike | local.pendle.2016-05-05 88 | party:53 | Labour Party | DIW:E05005250 | Barrowford | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14660 | 14660 | 18918 | Robert Andrew Oliver | local.pendle.2016-05-05 88 | party:53 | Labour Party | DIW:E05005250 | Barrowford | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14661 | 14661 | 18919 | Ken Turner | local.pendle.2016-05-05 88 | party:52 | Conservative and Unionist Party | DIW:E05005250 | Barrowford | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14662 | 14662 | 18920 | Christian Wakeford | local.pendle.2016-05-05 88 | party:52 | Conservative and Unionist Party | DIW:E05005250 | Barrowford | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14663 | 14663 | 18921 | Margaret Sarah Foxley | local.pendle.2016-05-05 88 | party:52 | Conservative and Unionist Party | DIW:E05005252 | Boulsworth | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14664 | 14664 | 18922 | Heather Ann Greaves | local.pendle.2016-05-05 88 | party:90 | Liberal Democrats | DIW:E05005252 | Boulsworth | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14665 | 14665 | 18923 | David Phillip Johns | local.pendle.2016-05-05 88 | party:53 | Labour Party | DIW:E05005252 | Boulsworth | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14666 | 14666 | 18924 | Mohammad Aslam | local.pendle.2016-05-05 88 | party:52 | Conservative and Unionist Party | DIW:E05005253 | Bradley | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14667 | 14667 | 18925 | Mohammad Sakib | local.pendle.2016-05-05 88 | party:53 | Labour Party | DIW:E05005253 | Bradley | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14668 | 14668 | 18926 | Howard Philip Thomas | local.pendle.2016-05-05 88 | party:90 | Liberal Democrats | DIW:E05005253 | Bradley | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14669 | 14669 | 18927 | Naeem Hussain Ashraf | local.pendle.2016-05-05 88 | party:53 | Labour Party | DIW:E05005254 | Brierfield | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14670 | 14670 | 18928 | Keith Wilkinson | local.pendle.2016-05-05 88 | party:52 | Conservative and Unionist Party | DIW:E05005254 | Brierfield | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14671 | 14671 | 18929 | Eileen Ansar | local.pendle.2016-05-05 88 | party:53 | Labour Party | DIW:E05005255 | Clover Hill | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14672 | 14672 | 18930 | Janice Taylor | local.pendle.2016-05-05 88 | party:52 | Conservative and Unionist Party | DIW:E05005255 | Clover Hill | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14673 | 14673 | 18931 | Marjorie Adams | local.pendle.2016-05-05 88 | party:90 | Liberal Democrats | DIW:E05005256 | Coates | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14674 | 14674 | 18932 | Harry Purcell | local.pendle.2016-05-05 88 | party:52 | Conservative and Unionist Party | DIW:E05005256 | Coates | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14675 | 14675 | 18933 | Ghulam Abbas Ullah | local.pendle.2016-05-05 88 | party:53 | Labour Party | DIW:E05005256 | Coates | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14676 | 14676 | 18934 | Jane Veronica Bailes Wood | local.pendle.2016-05-05 88 | party:63 | Green Party | DIW:E05005256 | Coates | 2016-05-05 | 0 | 0 | PP63 | 0 | ||||||||||||||||||||||||||
| 14677 | 14677 | 18935 | Ken Hartley | local.pendle.2016-05-05 88 | party:90 | Liberal Democrats | DIW:E05005257 | Craven | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14678 | 14678 | 18936 | Anthony James Lancaster | local.pendle.2016-05-05 88 | party:90 | Liberal Democrats | DIW:E05005257 | Craven | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14679 | 14679 | 18937 | Valerie Langtree | local.pendle.2016-05-05 88 | party:52 | Conservative and Unionist Party | DIW:E05005257 | Craven | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14680 | 14680 | 18938 | Richard Michael Oliver | local.pendle.2016-05-05 88 | party:85 | UK Independence Party (UKIP) | DIW:E05005257 | Craven | 2016-05-05 | 0 | 0 | PP85 | 0 | ||||||||||||||||||||||||||
| 14681 | 14681 | 18939 | Mark Porter | local.pendle.2016-05-05 88 | party:53 | Labour Party | DIW:E05005257 | Craven | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14682 | 14682 | 18940 | Jenny Purcell | local.pendle.2016-05-05 88 | party:52 | Conservative and Unionist Party | DIW:E05005257 | Craven | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14683 | 14683 | 18941 | Rosemary Elizabeth Carroll | local.pendle.2016-05-05 88 | party:52 | Conservative and Unionist Party | DIW:E05008551 | Earby | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14684 | 14684 | 18942 | Ian James Lyons | local.pendle.2016-05-05 88 | party:90 | Liberal Democrats | DIW:E05008551 | Earby | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14685 | 14685 | 18943 | Russell Tennant | local.pendle.2016-05-05 88 | party:53 | Labour Party | DIW:E05008551 | Earby | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14686 | 14686 | 18944 | Steve Petty | local.pendle.2016-05-05 88 | party:52 | Conservative and Unionist Party | DIW:E05005261 | Horsfield | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14687 | 14687 | 18945 | Louise Antoinette Whitehead | local.pendle.2016-05-05 88 | party:90 | Liberal Democrats | DIW:E05005261 | Horsfield | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14688 | 14688 | 18946 | Ann Marie Wrigley | local.pendle.2016-05-05 88 | joint-party:53-119 | Labour and Co-operative Party | DIW:E05005261 | Horsfield | 2016-05-05 | 0 | 0 | joint-party:53-119 | 0 | ||||||||||||||||||||||||||
| 14689 | 14689 | 18947 | Tommy Cooney | local.pendle.2016-05-05 88 | party:52 | Conservative and Unionist Party | DIW:E05005262 | Marsden | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14690 | 14690 | 18948 | John Barry Richardson | local.pendle.2016-05-05 88 | party:53 | Labour Party | DIW:E05005262 | Marsden | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14691 | 14691 | 18949 | John Rowe | local.pendle.2016-05-05 88 | party:3960 | British National Party | DIW:E05005262 | Marsden | 2016-05-05 | 0 | 0 | PP3960 | 0 | ||||||||||||||||||||||||||
| 14692 | 14692 | 18950 | Musawar Raza Arshad | local.pendle.2016-05-05 88 | party:52 | Conservative and Unionist Party | DIW:E05005264 | Reedley | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14693 | 14693 | 18951 | Mohammad Hanif | local.pendle.2016-05-05 88 | party:53 | Labour Party | DIW:E05005264 | Reedley | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14694 | 14694 | 18952 | Nigel Lofthouse | local.pendle.2016-05-05 88 | party:85 | UK Independence Party (UKIP) | DIW:E05005264 | Reedley | 2016-05-05 | 0 | 0 | PP85 | 0 | ||||||||||||||||||||||||||
| 14695 | 14695 | 18953 | James Wood | local.pendle.2016-05-05 88 | party:90 | Liberal Democrats | DIW:E05005264 | Reedley | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14696 | 14696 | 18954 | Saanval Safir | local.pendle.2016-05-05 88 | party:52 | Conservative and Unionist Party | DIW:E05005265 | Southfield | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14697 | 14697 | 18955 | Sheila Wicks | local.pendle.2016-05-05 88 | joint-party:53-119 | Labour and Co-operative Party | DIW:E05005265 | Southfield | 2016-05-05 | 0 | 0 | joint-party:53-119 | 0 | ||||||||||||||||||||||||||
| 14698 | 14698 | 18956 | Glennda Louise Clegg | local.pendle.2016-05-05 88 | party:90 | Liberal Democrats | DIW:E05005266 | Vivary Bridge | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14699 | 14699 | 18957 | Nathan Thomas McCollum | local.pendle.2016-05-05 88 | party:52 | Conservative and Unionist Party | DIW:E05005266 | Vivary Bridge | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14700 | 14700 | 18958 | Ian William Tweedie | local.pendle.2016-05-05 88 | party:53 | Labour Party | DIW:E05005266 | Vivary Bridge | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14701 | 14701 | 18959 | George Adam | local.pendle.2016-05-05 88 | party:53 | Labour Party | DIW:E05005267 | Walverden | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14702 | 14702 | 18960 | Abdul Aziz | local.pendle.2016-05-05 88 | party:52 | Conservative and Unionist Party | DIW:E05005267 | Walverden | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14703 | 14703 | 18961 | Ian Graham | local.pendle.2016-05-05 88 | party:53 | Labour Party | DIW:E05005268 | Waterside | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14704 | 14704 | 18962 | Anthony Robert Greaves | local.pendle.2016-05-05 88 | party:90 | Liberal Democrats | DIW:E05005268 | Waterside | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14705 | 14705 | 18963 | David Richard John Penney | local.pendle.2016-05-05 88 | party:63 | Green Party | DIW:E05005268 | Waterside | 2016-05-05 | 0 | 0 | PP63 | 0 | ||||||||||||||||||||||||||
| 14706 | 14706 | 18964 | Ash Sutcliffe | local.pendle.2016-05-05 88 | party:52 | Conservative and Unionist Party | DIW:E05005268 | Waterside | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14707 | 14707 | 18965 | Nadeem Ahmed | local.pendle.2016-05-05 88 | party:90 | Liberal Democrats | DIW:E05005269 | Whitefield | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14708 | 14708 | 18966 | Adrian Robert Barrett | local.pendle.2016-05-05 88 | party:53 | Labour Party | DIW:E05005269 | Whitefield | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14709 | 14709 | 18967 | Jess McNamara | local.pendle.2016-05-05 88 | party:52 | Conservative and Unionist Party | DIW:E05005269 | Whitefield | 2016-05-05 | 0 | 0 | PP52 | 0 |
JSON shape: default, array, newline-delimited
CREATE TABLE "candidates" (
"id" INTEGER,
"name" TEXT,
"honorific_prefix" REAL,
"honorific_suffix" REAL,
"gender" TEXT,
"birth_date" REAL,
"election" INTEGER,
"party_id" TEXT,
"party_name" TEXT,
"post_id" TEXT,
"post_label" TEXT,
"mapit_url" INTEGER,
"elected" REAL,
"email" TEXT,
"twitter_username" REAL,
"facebook_page_url" REAL,
"party_ppc_page_url" REAL,
"facebook_personal_url" REAL,
"homepage_url" REAL,
"wikipedia_url" REAL,
"linkedin_url" REAL,
"image_url" REAL,
"proxy_image_url_template" INTEGER,
"image_copyright" REAL,
"image_uploading_user" REAL,
"image_uploading_user_notes" REAL,
"twitter_user_id" INTEGER,
"election_date" TEXT,
"election_current" INTEGER,
"party_lists_in_use" INTEGER,
"party_list_position" INTEGER,
"old_person_ids" REAL,
"gss_code" INTEGER,
"parlparse_id" REAL,
"theyworkforyou_url" REAL,
"party_ec_id" TEXT,
"favourite_biscuits" REAL,
"cancelled_poll" INTEGER
,
FOREIGN KEY ("election") REFERENCES [election](id))