home / democracyclub

candidates

Data license: CC-BY-SA · Data source: Democracy Club

54 rows where election = 88

✎ View and edit SQL

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 party_ppc_page_url homepage_url wikipedia_url linkedin_url image_url proxy_image_url_template image_copyright image_uploading_user image_uploading_user_notes 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                       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                       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     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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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))
Powered by Datasette · Query took 6.712ms · Data license: CC-BY-SA · Data source: Democracy Club