home / democracyclub

candidates

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

88 rows where election = 33

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: gender, party_id, party_name, post_id, post_label, email, twitter_username, homepage_url, image_url, 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
10053 10053 2831 Neil Miney     male   local.knowsley.2016-05-05 33 party:85 UK Independence Party (UKIP) MTW:E05010944 St Gabriels             https://static-candidates.democracyclub.org.uk/media/images/images/2831.png   profile-photo TangoKid   2016-05-05 0 0   6878;17972       PP85   0
10054 10054 4508 Carl Cashman     male 1991-10-25 local.knowsley.2016-05-05 33 party:90 Liberal Democrats MTW:E05010940 Prescot North   1.0 http://www.libdems.org.uk/carl_cashman http://www.carlcashman.org.uk/ https://en.wikipedia.org/wiki/Carl_Cashman   https://static-candidates.democracyclub.org.uk/media/images/5481e91ab150e238702c062f.png   profile-photo     2016-05-05 0 0           PP90   0
10055 10055 17877 Sean Phillip Donnelly         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010949 Whitefield   1.0                   2016-05-05 0 0           PP53   0
10056 10056 17878 Brian Johns         local.knowsley.2016-05-05 33 ynmp-party:2 Independent MTW:E05010949 Whitefield                       2016-05-05 0 0           ynmp-party:2   0
10057 10057 17879 Norman Frederick Keats         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010949 Whitefield   1.0                   2016-05-05 0 0           PP53   0
10058 10058 17880 Geraldine Veronica Robertson         local.knowsley.2016-05-05 33 party:704 First For Kirkby MTW:E05010949 Whitefield                       2016-05-05 0 0           PP704   0
10059 10059 17881 Ros Smith         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010949 Whitefield   1.0                   2016-05-05 0 0           PP53   0
10060 10060 17911 Jayne Elizabeth Aston         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010935 Cherryfield                       2016-05-05 0 0           PP53   0
10061 10061 17912 Jenny Bamber         local.knowsley.2016-05-05 33 party:704 First For Kirkby MTW:E05010935 Cherryfield                       2016-05-05 0 0           PP704   0
10062 10062 17913 Adam William Butler         local.knowsley.2016-05-05 33 party:52 Conservative and Unionist Party MTW:E05010935 Cherryfield                       2016-05-05 0 0           PP52   0
10063 10063 17914 Jackie Harris         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010935 Cherryfield                       2016-05-05 0 0           PP53   0
10064 10064 17915 David Mark Lonergan         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010935 Cherryfield                       2016-05-05 0 0           PP53   0
10065 10065 17916 Alan John Flute         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010936 Halewood North   1.0                   2016-05-05 0 0           PP53   0
10066 10066 17917 Shelley Powell         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010936 Halewood North   1.0                   2016-05-05 0 0           PP53   0
10067 10067 17918 Terry Powell         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010936 Halewood North   1.0                   2016-05-05 0 0           PP53   0
10068 10068 17919 Matthew Paul Smith         local.knowsley.2016-05-05 33 party:52 Conservative and Unionist Party MTW:E05010936 Halewood North                       2016-05-05 0 0           PP52   0
10069 10069 17920 Bob Swann         local.knowsley.2016-05-05 33 ynmp-party:2 Independent MTW:E05010936 Halewood North                       2016-05-05 0 0           ynmp-party:2   0
10070 10070 17921 Phil Williamson         local.knowsley.2016-05-05 33 party:63 Green Party MTW:E05010936 Halewood North                       2016-05-05 0 0           PP63   0
10071 10071 17927 Edna Finneran         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010937 Halewood South   1.0                   2016-05-05 0 0           PP53   0
10072 10072 17928 Tina Harris         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010937 Halewood South   1.0                   2016-05-05 0 0           PP53   0
10073 10073 17929 Allan Harvey         local.knowsley.2016-05-05 33 ynmp-party:2 Independent MTW:E05010937 Halewood South                       2016-05-05 0 0           ynmp-party:2   0
10074 10074 17930 Gary Eric See     male   local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010937 Halewood South   1.0   https://cllrseeblog.org/     https://static-candidates.democracyclub.org.uk/media/images/images/17930.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=1446112092 2016-05-05 0 0           PP53   0
10075 10075 17931 Paula Marjorie Thomas         local.knowsley.2016-05-05 33 party:804 Trade Unionist and Socialist Coalition MTW:E05010937 Halewood South                       2016-05-05 0 0           PP804   0
10076 10076 17932 Andy Tomo         local.knowsley.2016-05-05 33 party:804 Trade Unionist and Socialist Coalition MTW:E05010937 Halewood South                       2016-05-05 0 0           PP804   0
10077 10077 17933 Graham Tubey         local.knowsley.2016-05-05 33 party:52 Conservative and Unionist Party MTW:E05010937 Halewood South                       2016-05-05 0 0           PP52   0
10078 10078 17934 Bren Tyrrell         local.knowsley.2016-05-05 33 party:804 Trade Unionist and Socialist Coalition MTW:E05010937 Halewood South                       2016-05-05 0 0           PP804   0
10079 10079 17935 Eddie Connor         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010938 Northwood   1.0                   2016-05-05 0 0           PP53   0
10080 10080 17936 Philip McKuhen         local.knowsley.2016-05-05 33 party:704 First For Kirkby MTW:E05010938 Northwood                       2016-05-05 0 0           PP704   0
10081 10081 17937 Mike Murphy         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010938 Northwood   1.0                   2016-05-05 0 0           PP53   0
10082 10082 17938 Marie Ellen Stuart         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010938 Northwood   1.0                   2016-05-05 0 0           PP53   0
10083 10083 17939 Ken McGlashan         local.knowsley.2016-05-05 33 joint-party:53-119 Labour and Co-operative Party MTW:E05010939 Page Moss   1.0                   2016-05-05 0 0           joint-party:53-119   0
10084 10084 17940 Veronica McNeill         local.knowsley.2016-05-05 33 joint-party:53-119 Labour and Co-operative Party MTW:E05010939 Page Moss   1.0                   2016-05-05 0 0           joint-party:53-119   0
10085 10085 17941 Andy Moorhead         local.knowsley.2016-05-05 33 joint-party:53-119 Labour and Co-operative Party MTW:E05010939 Page Moss   1.0                   2016-05-05 0 0           joint-party:53-119   0
10086 10086 17942 Kirk Anthony Sandringham     Man   local.knowsley.2016-05-05 33 party:63 Green Party MTW:E05010939 Page Moss             https://static-candidates.democracyclub.org.uk/media/images/images/17942.png   profile-photo j0e_m https://www.facebook.com/Huytongreens/posts/2183939895169910 2016-05-05 0 0           PP63   0
10087 10087 17943 Robert Peter Allan Avery         local.knowsley.2016-05-05 33 party:52 Conservative and Unionist Party MTW:E05010940 Prescot North                       2016-05-05 0 0           PP52   0
10088 10088 17944 Mike Kearns         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010940 Prescot North                       2016-05-05 0 0           PP53   0
10089 10089 17945 Lynn O'Keeffe         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010940 Prescot North                       2016-05-05 0 0   38384.0       PP53   0
10090 10090 17946 Ian Smith         local.knowsley.2016-05-05 33 party:90 Liberal Democrats MTW:E05010940 Prescot North   1.0                   2016-05-05 0 0           PP90   0
10091 10091 17947 Bill Weightman         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010940 Prescot North                       2016-05-05 0 0           PP53   0
10092 10092 17948 Steve Whatham         local.knowsley.2016-05-05 33 party:804 Trade Unionist and Socialist Coalition MTW:E05010940 Prescot North                       2016-05-05 0 0           PP804   0
10093 10093 17949 Mike Wynn         local.knowsley.2016-05-05 33 party:90 Liberal Democrats MTW:E05010940 Prescot North   1.0                   2016-05-05 0 0           PP90   0
10094 10094 17950 Denise Allen         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010941 Prescot South   1.0                   2016-05-05 0 0           PP53   0
10095 10095 17952 Paul Terence Shaw         local.knowsley.2016-05-05 33 party:90 Liberal Democrats MTW:E05010941 Prescot South                       2016-05-05 0 0           PP90   0
10096 10096 17953 Sophia April Smith         local.knowsley.2016-05-05 33 party:90 Liberal Democrats MTW:E05010941 Prescot South                       2016-05-05 0 0           PP90   0
10097 10097 17954 Sheila Mary Webster         local.knowsley.2016-05-05 33 party:52 Conservative and Unionist Party MTW:E05010941 Prescot South                       2016-05-05 0 0           PP52   0
10098 10098 17955 John Loftus Wickham         local.knowsley.2016-05-05 33 party:90 Liberal Democrats MTW:E05010941 Prescot South                       2016-05-05 0 0           PP90   0
10099 10099 17956 Dave Williams         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010941 Prescot South   1.0                   2016-05-05 0 0           PP53   0
10100 10100 17957 Ray Cleary         local.knowsley.2016-05-05 33 party:85 UK Independence Party (UKIP) MTW:E05010942 Roby                       2016-05-05 0 0           PP85   0
10101 10101 17958 Maggie Harvey         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010942 Roby   1.0                   2016-05-05 0 0           PP53   0
10102 10102 17959 Martin Peter Mackarel         local.knowsley.2016-05-05 33 party:63 Green Party MTW:E05010942 Roby                       2016-05-05 0 0           PP63   0
10103 10103 17960 Tyrone Noon         local.knowsley.2016-05-05 33 party:52 Conservative and Unionist Party MTW:E05010942 Roby                       2016-05-05 0 0           PP52   0
10104 10104 17961 Gary John Robertson         local.knowsley.2016-05-05 33 party:85 UK Independence Party (UKIP) MTW:E05010942 Roby                       2016-05-05 0 0           PP85   0
10105 10105 17962 Sam Robertson         local.knowsley.2016-05-05 33 party:85 UK Independence Party (UKIP) MTW:E05010942 Roby                       2016-05-05 0 0           PP85   0
10106 10106 17963 Pam Spall         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010942 Roby   1.0                   2016-05-05 0 0           PP53   0
10107 10107 17964 Sarah Joanne Spall         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010942 Roby   1.0                   2016-05-05 0 0           PP53   0
10108 10108 17965 Johnny Webster         local.knowsley.2016-05-05 33 ynmp-party:2 Independent MTW:E05010942 Roby                       2016-05-05 0 0           ynmp-party:2   0
10109 10109 17966 Tony Brennan         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010943 Shevington   1.0                   2016-05-05 0 0           PP53   0
10110 10110 17967 Neill Thomas John Dunne         local.knowsley.2016-05-05 33 party:804 Trade Unionist and Socialist Coalition MTW:E05010943 Shevington                       2016-05-05 0 0           PP804   0
10111 10111 17968 Ray Halpin         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010943 Shevington   1.0                   2016-05-05 0 0           PP53   0
10112 10112 17969 Linda Mooney         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010943 Shevington   1.0                   2016-05-05 0 0           PP53   0
10113 10113 17970 Fred Fricker     male   local.knowsley.2016-05-05 33 party:85 UK Independence Party (UKIP) MTW:E05010944 St Gabriels                       2016-05-05 0 0           PP85   0
10114 10114 17971 Sharon Marie Fricker         local.knowsley.2016-05-05 33 party:85 UK Independence Party (UKIP) MTW:E05010944 St Gabriels                       2016-05-05 0 0           PP85   0
10115 10115 17973 Brian Michael O'Hare         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010944 St Gabriels   1.0                   2016-05-05 0 0           PP53   0
10116 10116 17974 Christina Maria O'Hare         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010944 St Gabriels   1.0                   2016-05-05 0 0           PP53   0
10117 10117 17975 Tony Read         local.knowsley.2016-05-05 33 party:52 Conservative and Unionist Party MTW:E05010944 St Gabriels                       2016-05-05 0 0   38387.0       PP52   0
10118 10118 17976 Frank Walsh         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010944 St Gabriels   1.0                   2016-05-05 0 0           PP53   0
10119 10119 17977 Ron Ford         local.knowsley.2016-05-05 33 party:52 Conservative and Unionist Party MTW:E05010945 St Michaels                       2016-05-05 0 0           PP52   0
10120 10120 17978 Vickie Lamb         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010945 St Michaels   1.0                   2016-05-05 0 0           PP53   0
10121 10121 17979 Joan Elizabeth Lilly         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010945 St Michaels   1.0                   2016-05-05 0 0           PP53   0
10122 10122 17980 Kay Moorhead         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010945 St Michaels   1.0                   2016-05-05 0 0           PP53   0
10123 10123 17981 John David Price         local.knowsley.2016-05-05 33 party:85 UK Independence Party (UKIP) MTW:E05010945 St Michaels                       2016-05-05 0 0           PP85   0
10124 10124 17982 Dennis John Baum         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010946 Stockbridge   1.0                   2016-05-05 0 0           PP53   0
10125 10125 17983 John Jason Donnelly         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010946 Stockbridge   1.0                   2016-05-05 0 0           PP53   0
10126 10126 17985 Paul Gary Woods         local.knowsley.2016-05-05 33 ynmp-party:2 Independent MTW:E05010946 Stockbridge                       2016-05-05 0 0           ynmp-party:2   0
10127 10127 17986 Chris Bannon         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010947 Swanside   1.0                   2016-05-05 0 0           PP53   0
10128 10128 17987 Colin Dever         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010947 Swanside   1.0                   2016-05-05 0 0           PP53   0
10129 10129 17988 Paul Kenneth Robert Marshall         local.knowsley.2016-05-05 33 party:63 Green Party MTW:E05010947 Swanside                       2016-05-05 0 0           PP63   0
10130 10130 17989 Graham James Morgan         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010947 Swanside   1.0                   2016-05-05 0 0           PP53   0
10131 10131 17990 Ray Newland         local.knowsley.2016-05-05 33 party:52 Conservative and Unionist Party MTW:E05010947 Swanside                       2016-05-05 0 0           PP52   0
10132 10132 17991 Terry Byron         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010948 Whiston & Cronton   1.0                   2016-05-05 0 0           PP53   0
10133 10133 17992 Carl Robert Cross         local.knowsley.2016-05-05 33 party:52 Conservative and Unionist Party MTW:E05010948 Whiston & Cronton                       2016-05-05 0 0           PP52   0
10134 10134 17993 Gillian Flatley         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010948 Whiston & Cronton   1.0                   2016-05-05 0 0           PP53   0
10135 10135 17994 Tony Newman         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010948 Whiston & Cronton   1.0                   2016-05-05 0 0           PP53   0
10136 10136 17995 Dave O'Hara         local.knowsley.2016-05-05 33 party:90 Liberal Democrats MTW:E05010948 Whiston & Cronton                       2016-05-05 0 0           PP90   0
10137 10137 17996 Samantha Clare Smith         local.knowsley.2016-05-05 33 party:90 Liberal Democrats MTW:E05010948 Whiston & Cronton                       2016-05-05 0 0           PP90   0
10138 10138 17997 Marjorie Elizabeth Sommerfield         local.knowsley.2016-05-05 33 party:90 Liberal Democrats MTW:E05010948 Whiston & Cronton                       2016-05-05 0 0           PP90   0
10139 10139 19396 Steff O'Keeffe         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010941 Prescot South   1.0                   2016-05-05 0 0           PP53   0
10140 10140 19405 Margi O'Mara         local.knowsley.2016-05-05 33 party:53 Labour Party MTW:E05010946 Stockbridge   1.0                   2016-05-05 0 0   17984.0       PP53   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 8.174ms · Data license: CC-BY-SA · Data source: Democracy Club