home / democracyclub

candidates

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

60 rows where election = 30

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: honorific_prefix, gender, party_id, party_name, post_id, post_label, email, twitter_username, facebook_page_url, party_ppc_page_url, image_url, image_copyright, image_uploading_user, image_uploading_user_notes, twitter_user_id, old_person_ids, 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
9757 9757 886 John Beirne     male   local.st-helens.2016-05-05 30 ynmp-party:2 Independent MTW:E05000927 Sutton                       2016-05-05 0 0   5513.0       ynmp-party:2   0
9758 9758 3797 Brian Spencer     male   local.st-helens.2016-05-05 30 party:90 Liberal Democrats MTW:E05000927 Sutton             https://static-candidates.democracyclub.org.uk/media/images/images/3797.png   other rml http://www.sthelensstar.co.uk/news/15272340.Former_council_leader_Brian_Spencer_to_stand_as_Lib_Dems_announce_general_election_candidates/ 2016-05-05 0 0   15928.0       PP90   0
9759 9759 13531 Charlie Preston         local.st-helens.2016-05-05 30 party:53 Labour Party MTW:E05000919 Earlestown                       2016-05-05 0 0           PP53   0
9760 9760 13532 Mark Paul Sherman         local.st-helens.2016-05-05 30 party:85 UK Independence Party (UKIP) MTW:E05000919 Earlestown                       2016-05-05 0 0           PP85   0
9761 9761 13533 Les Skeetch         local.st-helens.2016-05-05 30 party:52 Conservative and Unionist Party MTW:E05000919 Earlestown                       2016-05-05 0 0           PP52   0
9762 9762 13986 Anthony James Burns Mr   Male   local.st-helens.2016-05-05 30 party:53 Labour Party MTW:E05000921 Haydock                       2016-05-05 0 0           PP53   0
9763 9763 13992 Mark Joseph Hitchen Mr   Male   local.st-helens.2016-05-05 30 party:85 UK Independence Party (UKIP) MTW:E05000921 Haydock                       2016-05-05 0 0           PP85   0
9764 9764 13993 Melanie Ann Marie Lee Ms   Female   local.st-helens.2016-05-05 30 party:52 Conservative and Unionist Party MTW:E05000921 Haydock                       2016-05-05 0 0           PP52   0
9765 9765 15875 Judith Margaret Collins         local.st-helens.2016-05-05 30 party:52 Conservative and Unionist Party MTW:E05000916 Billinge and Seneley Green                       2016-05-05 0 0           PP52   0
9766 9766 15876 Dennis McDonnell         local.st-helens.2016-05-05 30 party:53 Labour Party MTW:E05000916 Billinge and Seneley Green                       2016-05-05 0 0           PP53   0
9767 9767 15877 Peter Peers Mr   male   local.st-helens.2016-05-05 30 party:85 UK Independence Party (UKIP) MTW:E05000916 Billinge and Seneley Green     http://ukipnw.org.uk/branches/merseyside/ukip-st-helens/       https://static-candidates.democracyclub.org.uk/media/images/images/15877.png   public-domain ripperger2345   2016-05-05 0 0           PP85   0
9768 9768 15878 Nancy Jane Ashcroft         local.st-helens.2016-05-05 30 party:52 Conservative and Unionist Party MTW:E05000917 Blackbrook                       2016-05-05 0 0           PP52   0
9769 9769 15879 Barry Joseph Critchley         local.st-helens.2016-05-05 30 party:85 UK Independence Party (UKIP) MTW:E05000917 Blackbrook                       2016-05-05 0 0           PP85   0
9770 9770 15880 Alan Cunliffe         local.st-helens.2016-05-05 30 party:53 Labour Party MTW:E05000917 Blackbrook                       2016-05-05 0 0           PP53   0
9771 9771 15881 David O'Keefe         local.st-helens.2016-05-05 30 party:63 Green Party MTW:E05000918 Bold                       2016-05-05 0 0   41880.0       PP63   0
9772 9772 15882 Ian Edward Pennington         local.st-helens.2016-05-05 30 party:85 UK Independence Party (UKIP) MTW:E05000918 Bold                       2016-05-05 0 0           PP85   0
9773 9773 15883 John Wiseman         local.st-helens.2016-05-05 30 joint-party:53-119 Labour and Co-operative Party MTW:E05000918 Bold                       2016-05-05 0 0           joint-party:53-119   0
9774 9774 15884 Barbara Evelyne Woodcock         local.st-helens.2016-05-05 30 party:52 Conservative and Unionist Party MTW:E05000918 Bold                       2016-05-05 0 0           PP52   0
9775 9775 15889 Kathleen Sheila Barton         local.st-helens.2016-05-05 30 party:52 Conservative and Unionist Party MTW:E05000920 Eccleston                       2016-05-05 0 0           PP52   0
9776 9776 15890 Alex Graham         local.st-helens.2016-05-05 30 joint-party:53-119 Labour and Co-operative Party MTW:E05000920 Eccleston                       2016-05-05 0 0           joint-party:53-119   0
9777 9777 15891 Teresa Veronica Sims         local.st-helens.2016-05-05 30 party:90 Liberal Democrats MTW:E05000920 Eccleston                       2016-05-05 0 0           PP90   0
9778 9778 15892 Susan Gwyneth Wagstaff         local.st-helens.2016-05-05 30 party:85 UK Independence Party (UKIP) MTW:E05000920 Eccleston                       2016-05-05 0 0           PP85   0
9779 9779 15897 Laurence Christopher Allen         local.st-helens.2016-05-05 30 party:85 UK Independence Party (UKIP) MTW:E05000922 Moss Bank                       2016-05-05 0 0           PP85   0
9780 9780 15898 Steve Broughton         local.st-helens.2016-05-05 30 ynmp-party:2 Independent MTW:E05000922 Moss Bank                       2016-05-05 0 0           ynmp-party:2   0
9781 9781 15899 Deb Connor         local.st-helens.2016-05-05 30 party:63 Green Party MTW:E05000922 Moss Bank                       2016-05-05 0 0           PP63   0
9782 9782 15900 Margaret Hilda Ethel Harvey         local.st-helens.2016-05-05 30 party:52 Conservative and Unionist Party MTW:E05000922 Moss Bank                       2016-05-05 0 0           PP52   0
9783 9783 15901 Paul Michael John Lynch         local.st-helens.2016-05-05 30 joint-party:53-119 Labour and Co-operative Party MTW:E05000922 Moss Bank                       2016-05-05 0 0           joint-party:53-119   0
9784 9784 15904 John Philip Cunliffe         local.st-helens.2016-05-05 30 party:52 Conservative and Unionist Party MTW:E05000923 Newton                       2016-05-05 0 0           PP52   0
9785 9785 15905 Seve Gomez-Aspron         local.st-helens.2016-05-05 30 party:53 Labour Party MTW:E05000923 Newton                       2016-05-05 0 0           PP53   0
9786 9786 15906 Rachel Parkinson Ms   Female 1968.0 local.st-helens.2016-05-05 30 party:63 Green Party MTW:E05000923 Newton     https://my.greenparty.org.uk/candidates/106216       https://static-candidates.democracyclub.org.uk/media/images/images/15906.png   profile-photo kdcm87 https://my.greenparty.org.uk/candidates/106216 2016-05-05 0 0           PP63   0
9787 9787 15907 Mark Stephen Richardson         local.st-helens.2016-05-05 30 party:85 UK Independence Party (UKIP) MTW:E05000923 Newton                       2016-05-05 0 0           PP85   0
9788 9788 15908 David James Smith         local.st-helens.2016-05-05 30 party:90 Liberal Democrats MTW:E05000923 Newton                       2016-05-05 0 0           PP90   0
9789 9789 15913 Andy Bowden         local.st-helens.2016-05-05 30 party:53 Labour Party MTW:E05000924 Parr                       2016-05-05 0 0           PP53   0
9790 9790 15914 Paul Brown         local.st-helens.2016-05-05 30 ynmp-party:2 Independent MTW:E05000924 Parr                       2016-05-05 0 0           ynmp-party:2   0
9791 9791 15915 Susan Levy         local.st-helens.2016-05-05 30 party:85 UK Independence Party (UKIP) MTW:E05000924 Parr                       2016-05-05 0 0           PP85   0
9792 9792 15916 Madeleine Patricia Wilcock         local.st-helens.2016-05-05 30 party:52 Conservative and Unionist Party MTW:E05000924 Parr                       2016-05-05 0 0           PP52   0
9793 9793 15917 Alex Mitchell         local.st-helens.2016-05-05 30 party:53 Labour Party MTW:E05000925 Rainford                       2016-05-05 0 0           PP53   0
9794 9794 15919 Rob Reynolds         local.st-helens.2016-05-05 30 party:52 Conservative and Unionist Party MTW:E05000925 Rainford                       2016-05-05 0 0           PP52   0
9795 9795 15920 Barrie Andrew Grunewald         local.st-helens.2016-05-05 30 party:53 Labour Party MTW:E05000926 Rainhill                       2016-05-05 0 0           PP53   0
9796 9796 15921 Graham Samuel Woodhouse         local.st-helens.2016-05-05 30 party:52 Conservative and Unionist Party MTW:E05000926 Rainhill                       2016-05-05 0 0           PP52   0
9797 9797 15925 Mark Stephen Collins         local.st-helens.2016-05-05 30 party:52 Conservative and Unionist Party MTW:E05000927 Sutton                       2016-05-05 0 0           PP52   0
9798 9798 15926 John Michael Fairhurst         local.st-helens.2016-05-05 30 party:85 UK Independence Party (UKIP) MTW:E05000927 Sutton                       2016-05-05 0 0           PP85   0
9799 9799 15927 Jimmy Jackson         local.st-helens.2016-05-05 30 joint-party:53-119 Labour and Co-operative Party MTW:E05000927 Sutton                       2016-05-05 0 0           joint-party:53-119   0
9800 9800 15932 Nova Louise Charlton         local.st-helens.2016-05-05 30 party:53 Labour Party MTW:E05000928 Thatto Heath                       2016-05-05 0 0           PP53   0
9801 9801 15933 Lisa Mackarell         local.st-helens.2016-05-05 30 party:52 Conservative and Unionist Party MTW:E05000928 Thatto Heath                       2016-05-05 0 0           PP52   0
9802 9802 15934 Tony Rundle         local.st-helens.2016-05-05 30 party:85 UK Independence Party (UKIP) MTW:E05000928 Thatto Heath                       2016-05-05 0 0           PP85   0
9803 9803 15940 Jonathan Casson         local.st-helens.2016-05-05 30 ynmp-party:2 Independent MTW:E05000929 Town Centre                       2016-05-05 0 0           ynmp-party:2   0
9804 9804 15941 Lynn Susan Clarke         local.st-helens.2016-05-05 30 party:53 Labour Party MTW:E05000929 Town Centre                       2016-05-05 0 0           PP53   0
9805 9805 15942 Paul David Leyland         local.st-helens.2016-05-05 30 party:85 UK Independence Party (UKIP) MTW:E05000929 Town Centre                       2016-05-05 0 0           PP85   0
9806 9806 15943 Henry John Patrick Spriggs         local.st-helens.2016-05-05 30 party:52 Conservative and Unionist Party MTW:E05000929 Town Centre                       2016-05-05 0 0           PP52   0
9807 9807 15944 Richard William Barton         local.st-helens.2016-05-05 30 party:52 Conservative and Unionist Party MTW:E05000930 West Park                       2016-05-05 0 0           PP52   0
9808 9808 15945 Martin William Ellison         local.st-helens.2016-05-05 30 party:85 UK Independence Party (UKIP) MTW:E05000930 West Park                       2016-05-05 0 0           PP85   0
9809 9809 15946 Derek Paul Long         local.st-helens.2016-05-05 30 party:53 Labour Party MTW:E05000930 West Park                       2016-05-05 0 0           PP53   0
9810 9810 15947 Jessica Ayesha Northey Dr   Female   local.st-helens.2016-05-05 30 party:63 Green Party MTW:E05000930 West Park     https://my.greenparty.org.uk/candidates/106217       https://static-candidates.democracyclub.org.uk/media/images/images/15947.png   profile-photo kdcm87 https://my.greenparty.org.uk/candidates/106217 2016-05-05 0 0   34183.0       PP63   0
9811 9811 15948 Paul Joseph Pritchard         local.st-helens.2016-05-05 30 party:53 Labour Party MTW:E05000930 West Park                       2016-05-05 0 0           PP53   0
9812 9812 15953 Wally Ashcroft         local.st-helens.2016-05-05 30 party:52 Conservative and Unionist Party MTW:E05000931 Windle                       2016-05-05 0 0           PP52   0
9813 9813 15954 Gill Neal         local.st-helens.2016-05-05 30 party:53 Labour Party MTW:E05000931 Windle                       2016-05-05 0 0           PP53   0
9814 9814 15955 Maria Alison Parr         local.st-helens.2016-05-05 30 party:85 UK Independence Party (UKIP) MTW:E05000931 Windle                       2016-05-05 0 0           PP85   0
9815 9815 15956 Ann Shacklady-Smith         local.st-helens.2016-05-05 30 party:63 Green Party MTW:E05000931 Windle                       2016-05-05 0 0           PP63   0
9816 9816 42173 Tony Parr         local.st-helens.2016-05-05 30 party:85 UK Independence Party (UKIP) MTW:E05000925 Rainford                       2016-05-05 0 0   15918.0       PP85   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 7.374ms · Data license: CC-BY-SA · Data source: Democracy Club